SELECT a.serialNumber , a.fullName , a.securityTaskType , a.startDate , a.endDate , a.content , a.disposeUrl FROM sp_activity_security_task a where a.activityId = #{activityId} limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab SELECT CONCAT(b.securityTaskId,'') AS securityTaskId ,a.areaName ,a.orgName ,b.serialNumber ,b.fullName ,b.securityTaskType ,b.startDate ,b.endDate ,IF(b.startDate ]]> NOW(),'未开始',IF(b.endDate NOW(),'已结束','进行中')) AS taskStatus ,b.orgType FROM sp_activity_security_task_area a LEFT JOIN sp_activity_security_task b ON a.securityTaskId = b.securityTaskId LEFT JOIN sp_activity c ON b.activityId = c.id WHERE c.activityNo = #{activityNo} AND ( b.serialNumber like CONCAT('%', #{keywords}, '%') OR b.fullName like CONCAT('%', #{keywords}, '%') OR a.areaName like CONCAT('%', #{keywords}, '%') OR a.orgName like CONCAT('%', #{keywords}, '%') ) AND b.securityTaskType = #{securityTaskType} AND b.orgType = #{orgType} AND b.startDate >= CONCAT(#{startDate}," 00:00:00") AND CONCAT(#{endDate}," 23:59:59") >= b.startDate AND b.startDate ]]> NOW() AND b.startDate NOW() AND b.endDate = ]]> NOW() AND b.endDate NOW() limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab SELECT CONCAT(a.securityTaskPersonTrackId,'') AS securityTaskPersonTrackId ,a.trackTime ,a.longitude ,a.latitude FROM sp_activity_security_task_person_track a WHERE a.securityTaskId = #{taskId} AND ( a.longitude like CONCAT('%', #{keywords}, '%') OR a.latitude like CONCAT('%', #{keywords}, '%') ) SELECT b.fullName ,b.serialNumber ,b.securityTaskType ,b.startDate ,b.endDate ,b.content ,b.disposeUrl ,DATE_FORMAT(b.createOn,'%Y-%m-%d %H:%i:%s') AS createOn ,a.areaName ,a.areaTypeCode ,(select fullName from base_region where id=a.areaCode) as areaCode ,a.areaPoint ,a.areaMark ,a.orgName ,a.orgNo ,s.orgScale ,s.foundDate ,s.legalName ,s.legalIdCardNo ,CONCAT(b.securityTaskId,'') AS securityTaskId ,e.lineName ,e.lineCode ,IFNULL((SELECT 1 FROM base_serviceorg WHERE orgNo = a.orgNo),0) AS isCom FROM sp_activity_security_task b LEFT JOIN sp_activity_security_task_area a ON a.securityTaskId = b.securityTaskId LEFT JOIN sp_activity_security_task_line e ON a.securityTaskId = e.securityTaskId LEFT JOIN base_serviceorg s ON s.orgNo = a.orgNo where b.securityTaskId = #{taskId} limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab SELECT a.securityPersonId, a.securityTaskId, b.fullName ,b.usedName ,b.sex ,b.avatar ,b.mobile ,b.comName ,b.idCardType ,b.idCardNo ,b.country ,b.nation ,b.nativeAddress ,(SELECT r.fullName from base_region r where b.province=r.id) AS provinceName ,(SELECT r.fullName from base_region r where b.city=r.id) AS cityName ,(SELECT r.fullName from base_region r where b.area=r.id) AS areaName ,b.province ,b.city ,b.area ,b.address ,b.actualAddress ,b.securityCertUrl ,b.securityCertNo ,b.securityCertEndDate ,b.education ,b.specialIdentity ,b.birthday ,b.marry ,b.religion ,b.politics ,e.policeCode ,e.policeTitle ,e.policeType ,e.walkPoliceCode ,e.policeYear ,e.serviceEquip ,e.serviceEquipType ,c.areaName as checkAreaName ,a.taskPersonType, a.isLeader, d.longitude, d.latitude, b.policeOrg, b.policeOrgCode, b.policeOrgDepartType ,DATE_FORMAT(a.createOn,'%Y-%m-%d %H:%i:%s') AS createOn FROM sp_activity_security_task_person a inner join sp_security_person b on a.securityPersonId=b.securityPersonId left join sp_activity_security_task_area c on c.securityTaskId=a.securityTaskId left join (select max(trackTime),longitude,latitude,securityTaskId,securityPersonId from sp_activity_security_task_person_track group by securityPersonId,securityTaskId) d on a.securityPersonId =d.securityPersonId left join sp_activity_security_task_police e on a.securityTaskId=e.securityTaskId WHERE a.securityPersonId = b.securityPersonId AND a.securityTaskId = #{taskId} AND ( b.fullName like CONCAT('%', #{keywords}, '%') OR b.idCardNo like CONCAT('%', #{keywords}, '%') OR b.nativeAddress like CONCAT('%', #{keywords}, '%') OR b.mobile like CONCAT('%', #{keywords}, '%') ) AND b.sex = #{sex} AND a.taskPersonType = #{taskPersonType} AND e.policeType = #{policeType} AND a.isLeader = #{isLeader}