select roll_call_id, json_unquote(security_depart_json->'$.id') as supervise_depart_id, json_unquote(security_depart_json->'$.name') as supervise_depart_name, json_unquote(security_station_json->'$.id') as station_id, json_unquote(security_station_json->'$.name') as station_name, security_station_json->'$.stationTypes' as station_types, called_organization_name,created_time, 0 || `status`&16>0 ) then 1 else 0 end)) as countOfSuccess, sum((case when (`status`&2<=0 && `status`&16<=0 ) then 1 else 0 end)) as countOfFailed, ]]> a.action_employee_name from dispatch.vga_roll_call_employees a AND security_station_json->'$.name' like concat('"',#{stationName},'%') #{selectedDepartId} ${selectedStationType} AND action_employee_name like concat(#{actionEmployeeName},'%') AND created_time >= #{beginDate} AND roll_call_plan_id =#{rollCallPlanId} #{selectedOrgId} AND action_organization_id =#{actionOrganizationId} 0 ]]> GROUP BY roll_call_id,supervise_depart_id,station_id ORDER BY created_time DESC limit #{skip},#{pageSize} select count(1) from ( select roll_call_id, security_depart_json->'$.id' as supervise_depart_id, security_depart_json->'$.name' as supervise_depart_name, security_station_json->'$.id' as station_id, security_station_json->'$.name' as station_name, security_station_json->'$.stationTypes' as station_types, called_organization_name from dispatch.vga_roll_call_employees a AND security_station_json->'$.name' like concat('"',#{stationName},'%') #{selectedDepartId} ${selectedStationType} AND action_employee_name like concat(#{actionEmployeeName},'%') AND created_time >= #{beginDate} #{selectedOrgId} AND roll_call_plan_id =#{rollCallPlanId} 0 ]]> AND action_organization_id =#{actionOrganizationId} GROUP BY roll_call_id,supervise_depart_id,station_id ) as k update dispatch.vga_roll_call_employees set `status` = #{item.status},`last_room_id` = #{item.lastRoomId},`last_room_time` = #{item.lastRoomTime}, `last_roll_call_status_changed_time` = #{item.lastRollCallStatusTime},`last_roll_call_status_changed_note` = #{item.lastRollCallStatusNote}, `last_action_time` = #{item.lastActionTime},`call_type`=#{item.callType},`last_updated_tenant_user_cid_time`=#{item.lastUpdatedTenantUserCIdTime},`called_tenant_user_cid`=#{item.calledTenantUserCid} where `id` = #{item.id}