| | |
| | | <result column="id" property="id"/> |
| | | <result column="event_image_url" property="eventImageUrl"/> |
| | | <result column="create_time" property="createTime"/> |
| | | <result column="geojson" property="geojson"/> |
| | | <result column="attachment_type" property="attachmentType"/> |
| | | </resultMap> |
| | | |
| | | <resultMap id="gdClueEventCountVoResultMap" type="org.sxkj.gd.workorder.vo.GdClueEventCountVO"> |
| | |
| | | <select id="selectGdClueEventSimpleList" resultMap="gdClueEventListVoResultMap"> |
| | | select ce.id as id, |
| | | tr.result_url as event_image_url, |
| | | tr.geojson as geojson, |
| | | tr.attachment_type as attachmentType, |
| | | ce.create_time as create_time |
| | | from ja_gd_clue_event ce |
| | | left join ja_gd_task_result tr on tr.id::VARCHAR = ce.result_id::VARCHAR and tr.is_deleted = 0 |