Merge branch 'zigonggao_dev' into huacheng_test
| | |
| | | select id,matter_name title,concat((select classify_name from automessage_classify_administration |
| | | where id=(select parent_id from automessage_classify_administration where id=automessage_transaction_event.classify_id)), |
| | | '>',(select classify_name from automessage_classify_administration where id=automessage_transaction_event.classify_id)) content, |
| | | transaction_num views,2 type from automessage_transaction_event |
| | | browse_num views,2 type from automessage_transaction_event |
| | | ) k |
| | | where k.title like concat('%',#{keyWord}, '%') or k.content like concat('%', #{keyWord}, '%') |
| | | </select> |
| | |
| | | select id,matter_name title,concat((select classify_name from automessage_classify_administration |
| | | where id=(select parent_id from automessage_classify_administration where id=automessage_transaction_event.classify_id)), |
| | | '>',(select classify_name from automessage_classify_administration where id=automessage_transaction_event.classify_id)) content, |
| | | transaction_num views ,3 type from automessage_transaction_event where associate_names like concat('%',#{keyWord}, '%') |
| | | browse_num views ,3 type from automessage_transaction_event where associate_names like concat('%',#{keyWord}, '%') |
| | | </select> |
| | | |
| | | <select id="selectSearchAssociateDistinct" resultType="com.dg.core.db.manual.pojo.Search" > |