| | |
|---|
| | | <!--自定义分页查询--> |
|---|
| | | <select id="selectPatrolTask" resultType="cn.gistack.sm.patrol.vo.PatrolTaskVO"> |
|---|
| | | SELECT |
|---|
| | | spt.id,spt.title,spt.start_time,spt.end_time,spt.content,spt.to_user_id,spt.state,spt.source,spt.project_id,spt.task_type,spt.PATROL_GROUP_ITEM_ID,spt.problem_count,spt.real_start_time,spt.real_end_time,spt.mile, |
|---|
| | | DATEDIFF(ss,spt.REAL_START_TIME,spt.REAL_END_TIME) timeGap, |
|---|
| | | dmgeo.ST_AsGeoJSON(spt.route_coordinates) AS route_coordinates, |
|---|
| | | spt2.name as patrolTypeName, |
|---|
| | | spt.*,spt2.name as patrolTypeName, |
|---|
| | | route.ROUTE_COORDINATES routeRange |
|---|
| | | FROM sm_patrol_task spt |
|---|
| | | left join sm_patrol_type spt2 on spt.task_type = spt2.id |
|---|
