| | |
|---|
| | | ps.add(type); |
|---|
| | | } |
|---|
| | | StringBuilder sql = new StringBuilder(); |
|---|
| | | sql.append("\nselect SUBSTRING(message_type,1,1) message_type, count(*) num from product_db_lift.product_sys_message m inner join product_db_lift.product_sys_message_user u on u.message_uuid=m.uuid \r\n" |
|---|
| | | sql.append("\nselect SUBSTRING(message_type,1,1) message_type, count(*) num from product_sys_message m inner join product_sys_message_user u on u.message_uuid=m.uuid \r\n" |
|---|
| | | + "and u.user_id=? and u.read_type=?").append(f).append(" group by SUBSTRING(message_type,1,1) "); |
|---|
| | | DataTableEntity dte = baseDao.listTable(sql.toString(),ps.toArray(),Integer.MAX_VALUE, 1); |
|---|
| | | return dte; |
|---|
