| | |
|---|
| | | <!--行政区统计分页--> |
|---|
| | | <select id="getRegionReportPage" resultType="cn.gistack.sm.patrol.vo.PatrolTaskReport"> |
|---|
| | | select * from ( |
|---|
| | | select "ad_name" AS adName ,"guid" AS adCode,"ad_grad","order_id", #{patrolTaskReport.startTime} AS startTime,#{patrolTaskReport.endTime} AS endTime, |
|---|
| | | select "ad_name" AS adName ,"guid" AS adCode,"ad_grad","order_id",date_format(#{patrolTaskReport.startTime},'%Y-%m-%d') AS startTime,date_format(#{patrolTaskReport.endTime},'%Y-%m-%d') AS endTime, |
|---|
| | | ( |
|---|
| | | select count(*) from YWXT.SM_PATROL_TASK spt |
|---|
| | | left join SJZT_MD."att_res_base" a on (spt.project_id = a."guid") |
|---|
| | |
|---|
| | | arb."guid" AS reservoirId, |
|---|
| | | arb."interior_ad_guid" AS adCode, |
|---|
| | | aab."ad_name" AS adName, |
|---|
| | | #{patrolTaskReport.startTime} AS startTime, |
|---|
| | | #{patrolTaskReport.endTime} AS endTime, |
|---|
| | | |
|---|
| | | date_format(#{patrolTaskReport.startTime},'%Y-%m-%d') AS startTime, |
|---|
| | | date_format(#{patrolTaskReport.endTime},'%Y-%m-%d') AS endTime, |
|---|
| | | ( |
|---|
| | | select count(*) from YWXT.SM_PATROL_TASK spt |
|---|
| | | where arb."guid" = spt.project_id |
|---|
