| | |
|---|
| | | */ |
|---|
| | | public DataTableEntity listReadMessage(FieldSetEntity fse) { |
|---|
| | | StringBuilder sql = new StringBuilder(); |
|---|
| | | sql.append("\nselect m.uuid,m.title,m.content,m.send_user_id,mu.user_name send_user_name,m.send_time,m.message_type,ifnull(m.mobile_url,'') url "); |
|---|
| | | sql.append("\nselect m.uuid,m.title,m.content,m.send_user_id,mu.user_name send_user_name,m.send_time,m.message_type,m.mobile_url url "); |
|---|
| | | sql.append("\nfrom product_sys_message m"); |
|---|
| | | sql.append("\nleft join product_sys_users mu on mu.user_id=m.send_user_id "); |
|---|
| | | sql.append("\ninner join product_sys_message_user u on u.message_uuid=m.uuid and u.read_type=1 and u.user_id=?"); |
|---|
