package cn.com.lzt.car.jobImageManagement.controller; import cn.afterturn.easypoi.entity.vo.NormalExcelConstants; import cn.com.lzt.car.jobImageManagement.entity.TBCarShoot; import cn.com.lzt.car.jobImageManagement.service.jobImageManagementService; import com.alibaba.fastjson.JSONObject; import org.apache.commons.lang.xwork.StringUtils; import org.apache.log4j.Logger; import org.jeecgframework.core.common.controller.BaseController; import org.jeecgframework.core.common.exception.BusinessException; import org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery; import org.jeecgframework.core.common.model.json.AjaxJson; import org.jeecgframework.core.common.model.json.DataGrid; import org.jeecgframework.core.constant.Globals; import org.jeecgframework.core.util.JeecgDataAutorUtils; import org.jeecgframework.core.util.MyBeanUtils; import org.jeecgframework.core.util.ResourceUtil; import org.jeecgframework.core.util.StringUtil; import org.jeecgframework.tag.core.easyui.TagUtil; import org.jeecgframework.tag.vo.datatable.SortDirection; import org.jeecgframework.web.system.pojo.base.TSType; import org.jeecgframework.web.system.service.SystemService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.ModelMap; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; import org.springframework.web.servlet.ModelAndView; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; /** * @author LiuMengxiang * @version V1.0 * @Title: Controller * @Description: 作业车辆-抓拍图片管理 * @date 2021年11月11日16:06:49 */ @Controller @RequestMapping("/imageManagementController") public class ImageManagementController extends BaseController { /** * Logger for this class */ private static final Logger logger = Logger.getLogger(ImageManagementController.class); @Resource private jobImageManagementService jobImageManagementService; @Autowired private SystemService systemService; /*** * 页面跳转到抓拍筛选index页面 * @author 刘梦祥 * @date 2021年11月12日10:30:08 * @param request * @return ModelAndView */ @RequestMapping(params = "screeningIndex") public ModelAndView screeningIndex(HttpServletRequest request) { return new ModelAndView("cn/com/lzt/jobimage/management/screeningList"); } /*** * 页面跳转到抓拍存证index页面 * @author 刘梦祥 * @date 2021年11月12日17:46:19 * @param request * @return ModelAndView */ @RequestMapping(params = "depositCertificateIndex") public ModelAndView depositCertificateIndex(HttpServletRequest request) { return new ModelAndView("cn/com/lzt/jobimage/management/depositCertificateList"); } /*** * 页面跳转到录像回放index页面 * @author 刘梦祥 * @date 2021年11月15日15:37:36 * @param request * @return ModelAndView */ @RequestMapping(params = "videoPlaybackIndex") public ModelAndView videoPlaybackIndex(HttpServletRequest request) { return new ModelAndView("cn/com/lzt/jobimage/management/videoPlaybackList2"); } /** * 初始化请求接口 * * @param tBCarShoot * @param request * @param response * @param dataGrid * @author 刘梦祥 * @date 2021年11月12日10:29:43 */ @RequestMapping(params = "datagrid") public void datagrid(TBCarShoot tBCarShoot, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) { CriteriaQuery cq = new CriteriaQuery(TBCarShoot.class, dataGrid); String plateNo = request.getParameter("plateNo"); // 查询条件组装器-车牌号 tBCarShoot.setPlateNo(null); if (StringUtils.isNotBlank(plateNo)) { cq.like("plateNo", "%" + plateNo + "%"); } String position = request.getParameter("position"); // 查询条件组装器-抓拍位置 tBCarShoot.setPosition(null); if (StringUtils.isNotBlank(position)) { cq.like("position", "%" + position + "%"); } String type = request.getParameter("type"); // 查询条件组装器-车辆类型 tBCarShoot.setType(null); if (StringUtils.isNotBlank(type)) { // 模糊查询 cq.eq("type", type); } String camera = request.getParameter("camera"); // 查询条件组装器-摄像头位置 if (StringUtils.isNotBlank(camera)) { // 模糊查询 cq.eq("camera", Integer.valueOf(camera)); tBCarShoot.setCamera(null); } String status = request.getParameter("status"); // 查询条件组装器-存证状态 if (StringUtils.isNotBlank(status)) { // 模糊查询 cq.eq("status", Integer.valueOf(status)); tBCarShoot.setStatus(null); } Map map = new HashMap<>(); map.put("uploadTime", "desc"); cq.setOrder(map); //查询条件组装器 org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tBCarShoot, request.getParameterMap()); cq.add(); this.jobImageManagementService.getDataGridReturn(cq, true); List tBCarShootData = dataGrid.getResults(); // 得到文件服务器地址 TSType tsType = systemService.getType("JobFileServerIpAddress","serverAddress"); TSType tsType2 = systemService.getType("JobFileServerPortAddress","serverAddress"); //查询出所有的车辆类型 String getAllCarTypeList = "select * from t_s_type where typegroupid = (select id from t_s_typegroup where typegroupcode = \"cartype\");"; List> allCarTypeList = this.systemService.findForJdbc(getAllCarTypeList); Map allCarTypeMap = new HashMap<>(); if(allCarTypeList != null && allCarTypeList.size() > 0){ for (Map carTypeItem : allCarTypeList){ if(carTypeItem.containsKey("typecode") && carTypeItem.containsKey("typename") && carTypeItem.get("typecode") != null && carTypeItem.get("typename") != null){ allCarTypeMap.put(String.valueOf(carTypeItem.get("typecode")),String.valueOf(carTypeItem.get("typename"))); } } } for (TBCarShoot tbCarShoot : tBCarShootData){ if(StringUtil.isNotEmpty(tbCarShoot.getType()) && allCarTypeMap.containsKey(tbCarShoot.getType())){ tbCarShoot.setType(allCarTypeMap.get(tbCarShoot.getType())); }else{ tbCarShoot.setType("未知车辆类型"); } if(StringUtil.isNotEmpty(tbCarShoot.getShoot()) && !tbCarShoot.getShoot().contains("http")){ tbCarShoot.setShoot(tsType.getTypename().concat(tsType2.getTypename()).concat(tbCarShoot.getShoot())); } } dataGrid.setResults(tBCarShootData); TagUtil.datagrid(response, dataGrid); } /** * 车辆抓拍档案存证更新（同时支持批量操作） * * @param * @return AjaxJson * @author 刘梦祥 * @date 2021年11月12日10:30:38 */ @RequestMapping(params = "depositCertificate") @ResponseBody public AjaxJson depositCertificate(TBCarShoot tBCarShoot) { String message = null; AjaxJson j = new AjaxJson(); try { // 批量对象操作 if (tBCarShoot.getCheckIds() != null && tBCarShoot.getCheckIds().length() > 0) { String[] checkidsList = tBCarShoot.getCheckIds().split(","); for (String checkId : checkidsList) { TBCarShoot t = jobImageManagementService.get(TBCarShoot.class, checkId); // 防止多用户操作同一对象导致重复操作出现异常 if (t != null) { MyBeanUtils.copyBeanNotNull2Bean(tBCarShoot, t); t.setStatus(1); jobImageManagementService.saveOrUpdate(t); message = "车辆抓拍档案更新成功"; systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO); } } } else { // 单个对象操作 TBCarShoot t = jobImageManagementService.get(TBCarShoot.class, tBCarShoot.getId()); MyBeanUtils.copyBeanNotNull2Bean(tBCarShoot, t); t.setStatus(1); jobImageManagementService.saveOrUpdate(t); message = "车辆抓拍档案更新成功"; systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO); } } catch (Exception e) { e.printStackTrace(); throw new BusinessException(e.getMessage()); } j.setMsg(message); return j; } /** * 车辆抓拍档案存证删除（同时支持批量操作） * * @return AjaxJson * @author 刘梦祥 * @date 2021年11月12日10:31:40 */ @RequestMapping(params = "delDepositCertificate") @ResponseBody public AjaxJson delDepositCertificate(TBCarShoot tBCarShoot) { String message = null; AjaxJson j = new AjaxJson(); try { // 批量对象操作 if (tBCarShoot.getCheckIds() != null && tBCarShoot.getCheckIds().length() > 0) { String[] checkidsList = tBCarShoot.getCheckIds().split(","); for (String checkId : checkidsList) { TBCarShoot t = jobImageManagementService.get(TBCarShoot.class, checkId); // 防止多用户操作同一对象导致重复操作出现异常 if (t != null) { jobImageManagementService.delete(t); message = "车辆抓拍档案删除成功"; systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO); } } } else { // 单个对象操作 tBCarShoot = systemService.getEntity(TBCarShoot.class, tBCarShoot.getId()); jobImageManagementService.delete(tBCarShoot); message = "车辆抓拍档案删除成功"; systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO); } } catch (Exception e) { e.printStackTrace(); throw new BusinessException(e.getMessage()); } j.setMsg(message); return j; } /** * 批量导出数据 * * @param tBCarShoot * @return * @author 刘梦祥 * @date 2021年11月15日13:17:24 */ @RequestMapping(params = "exportXls") public String exportXls(TBCarShoot tBCarShoot, HttpServletResponse response, HttpServletRequest request, DataGrid dataGrid, ModelMap modelMap) { String pageType = request.getParameter("pageType"); modelMap.put(NormalExcelConstants.FILE_NAME, "jobImageManagementListTable".equals(pageType) ? "抓拍图片存证管理" : "抓拍录像管理"); modelMap.put(NormalExcelConstants.CLASS, TBCarShoot.class); modelMap.put(NormalExcelConstants.PARAMS, new cn.afterturn.easypoi.excel.entity.ExportParams( "jobImageManagementListTable".equals(pageType) ? "抓拍图片存证管理列表" : "抓拍录像管理列表", "导出人:" + ResourceUtil.getSessionUser().getRealName(), "导出信息")); //批量对象操作 List list = new ArrayList<>(); if (tBCarShoot.getCheckIds() != null && tBCarShoot.getCheckIds().length() > 0) { // 得到文件服务器地址 TSType tsType = systemService.getType("JobFileServerIpAddress","serverAddress"); TSType tsType2 = systemService.getType("JobFileServerPortAddress","serverAddress"); //查询出所有的车辆类型 String getAllCarTypeList = "select * from t_s_type where typegroupid = (select id from t_s_typegroup where typegroupcode = \"cartype\");"; List> allCarTypeList = this.systemService.findForJdbc(getAllCarTypeList); Map allCarTypeMap = new HashMap<>(); if(allCarTypeList != null && allCarTypeList.size() > 0){ for (Map carTypeItem : allCarTypeList){ if(carTypeItem.containsKey("typecode") && carTypeItem.containsKey("typename") && carTypeItem.get("typecode") != null && carTypeItem.get("typename") != null){ allCarTypeMap.put(String.valueOf(carTypeItem.get("typecode")),String.valueOf(carTypeItem.get("typename"))); } } } String[] checkidsList = tBCarShoot.getCheckIds().split(","); for (String checkId : checkidsList) { TBCarShoot t = jobImageManagementService.get(TBCarShoot.class, checkId); //防止多用户操作同一对象导致重复操作出现异常 if (t != null) { TBCarShoot tBCarShoot1 = JSONObject.parseObject(JSONObject.toJSONString(t), TBCarShoot.class); if(tBCarShoot1.getCamera() != null){ switch (tBCarShoot1.getCamera()){ case 1: tBCarShoot1.setCameraStr("前置"); break; case 2: tBCarShoot1.setCameraStr("后置"); break; case 3: tBCarShoot1.setCameraStr("驾驶室"); break; default: tBCarShoot1.setCameraStr("未知"); break; } } // 转换车辆类型 if(StringUtil.isNotEmpty(tBCarShoot1.getType()) && allCarTypeMap.containsKey(tBCarShoot1.getType())){ tBCarShoot1.setType(allCarTypeMap.get(tBCarShoot1.getType())); }else{ tBCarShoot1.setType("未知车辆类型"); } // 转换文件路径 if(StringUtil.isNotEmpty(tBCarShoot1.getShoot()) && !tBCarShoot1.getShoot().contains("http")){ tBCarShoot1.setShoot(tsType.getTypename().concat(tsType2.getTypename()).concat(tBCarShoot1.getShoot())); } list.add(tBCarShoot1); } } } modelMap.put(NormalExcelConstants.DATA_LIST, list); return NormalExcelConstants.EASYPOI_EXCEL_VIEW; } }