根据封控圈名称获取详情 __9DIa4a2YJpzCiIFm3q7 __9DIa4a2YJpzCiIFm3q7 published UTF-8 post /duty/zone/details/byname json = CURRENT_DATE and r.ITEM_ZONEID = z.id ORDER BY p.ITEM_ONOFF desc, p.ITEM_STARTDATE limit 1) as item_planid ," + " z.ITEM_NAME as item_zoneName," + "z.id as item_zoneId," + "concat(z.ITEM_ATTENDANCESITEADDRESS,z.ITEM_ATTENDANCESITEFULLADDRESS) as ITEM_FULLADDRESS, " + "s.ITEM_NAME as item_shapeName," + "ITEM_RADIUS," + "z.ITEM_ATTENDANCESITELONGITUDE," + "z.ITEM_ATTENDANCESITELATITUDE " + " from duty.tlk_security_zone z join duty.tlk_security_zone_shape s on z.ITEM_SHAPE = s.id " + " where z.ITEM_NAME like '%" + zoneName + "%' and z.ITEM_SHAPE in" +shapeStr + " ) t " + "join duty.tlk_security_zone_plan p2 on t.ITEM_PLANID = p2.id " + ") t2 " + "LEFT JOIN " + //所属方案的封控圈的里面的公司 "(select sz.ITEM_PLANID,sz.ITEM_ZONEID,count(DISTINCT sz.DOMAINID) as item_cmpCnt, count(DISTINCT a.ITEM_EMPLOYEEID) as item_empCnt, count(DISTINCT es.id) as item_empOnDutyCnt from tlk_company_selected_zone sz left join tlk_company_zone_employee_arrange a on sz.id = a.ITEM_SELECTEDPLANZONEID left join dispatch.rd_employee_summary es on a.ITEM_EMPLOYEEID = es.id and es.occupation_type = '1' and es.`status` = '0' and es.duty_status = '1' GROUP BY sz.ITEM_PLANID,sz.ITEM_ZONEID ) c on t2.ITEM_PLANID = c.ITEM_PLANID and t2.item_zoneId = c.ITEM_ZONEID " //注释掉的是方案公司数，计划安排人员数和在线人数 //"(select ITEM_PLANID,count(1) as item_cmpCnt,sum(IFNULL(item_empNum,0)) as item_empCnt from tlk_security_plan_company_relations GROUP BY ITEM_PLANID ) c on t2.ITEM_PLANID = c.ITEM_PLANID " + //" left join " + //"(select sz.ITEM_PLANID, COUNT(DISTINCT a.ITEM_EMPLOYEEID) as item_empOnDutyCnt from duty.tlk_company_selected_zone sz join duty.tlk_company_zone_employee_arrange a on sz.ID = a.ITEM_SELECTEDPLANZONEID join dispatch.rd_employee_summary es on a.ITEM_EMPLOYEEID = es.id and es.`status` = '0' and es.duty_status = '1' GROUP BY sz.ITEM_PLANID) o on t2.ITEM_PLANID = o.ITEM_PLANID"; var data = queryByDSName("duty",sql); //result.put("sql",sql); result.put("data",data); return result; })() ]]>