MMessageController.java 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887
  1. package cn.com.lzt.message.send.controller;
  2. import cn.com.lzt.common.entity.TSysFileEntity;
  3. import cn.com.lzt.common.service.TSysFileServiceI;
  4. import cn.com.lzt.common.util.DictUtil;
  5. import cn.com.lzt.common.util.LztUtil;
  6. import cn.com.lzt.common.view.JsonDataModelAndView;
  7. import cn.com.lzt.message.data.dao.MessageDataDao;
  8. import cn.com.lzt.message.data.dto.MessageMultiRowViewer;
  9. import cn.com.lzt.message.data.dto.MessageSimpleRowViewer;
  10. import cn.com.lzt.message.data.dto.MessageViewer;
  11. import cn.com.lzt.message.send.entity.MMessageEntity;
  12. import cn.com.lzt.message.personal.entity.MPersonalMessageEntity;
  13. import cn.com.lzt.message.send.entity.MessageWxTemplateConfig;
  14. import cn.com.lzt.message.send.service.MMessageSendServiceI;
  15. import cn.com.lzt.message.send.service.MMessageServiceI;
  16. import cn.com.lzt.message.send.page.MMessagePage;
  17. import cn.com.lzt.message.send.entity.MMessageSendScopeEntity;
  18. import java.util.*;
  19. import javax.servlet.http.HttpServletRequest;
  20. import javax.servlet.http.HttpServletResponse;
  21. import cn.com.lzt.message.send.util.Des3;
  22. import cn.com.lzt.message.white_ip.entity.MWhiteIpListEntity;
  23. import cn.com.lzt.workflow.service.WorkflowServiceI;
  24. import com.jeecg.qianbao.util.FormProcUtil;
  25. import com.xcgl.utils.XcglConstant;
  26. import com.xcgl.weixin.entity.WXAjaxJson;
  27. import com.xcgl.weixin.entity.WXMultiRowViewer;
  28. import com.xcgl.weixin.entity.WXMultiRowViewerDto;
  29. import net.sf.json.JSONObject;
  30. import org.activiti.engine.impl.persistence.entity.MessageEntity;
  31. import org.apache.commons.lang3.StringUtils;
  32. import org.apache.log4j.Logger;
  33. import org.hibernate.criterion.Restrictions;
  34. import org.jeecgframework.core.common.model.json.DataGridReturn;
  35. import org.jeecgframework.core.util.*;
  36. import org.jeecgframework.minidao.pojo.MiniDaoPage;
  37. import org.jeecgframework.tag.vo.datatable.SortDirection;
  38. import org.jeecgframework.web.system.pojo.base.TSUser;
  39. import org.springframework.beans.factory.annotation.Autowired;
  40. import org.springframework.stereotype.Controller;
  41. import org.springframework.web.bind.annotation.*;
  42. import org.springframework.web.servlet.ModelAndView;
  43. import org.jeecgframework.core.common.controller.BaseController;
  44. import org.jeecgframework.core.common.exception.BusinessException;
  45. import org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery;
  46. import org.jeecgframework.core.common.model.json.AjaxJson;
  47. import org.jeecgframework.core.common.model.json.DataGrid;
  48. import org.jeecgframework.core.constant.Globals;
  49. import org.jeecgframework.tag.core.easyui.TagUtil;
  50. import org.jeecgframework.web.system.service.SystemService;
  51. import org.jeecgframework.poi.excel.ExcelImportUtil;
  52. import org.jeecgframework.poi.excel.entity.ExportParams;
  53. import org.jeecgframework.poi.excel.entity.ImportParams;
  54. import org.jeecgframework.poi.excel.entity.vo.NormalExcelConstants;
  55. import org.springframework.ui.ModelMap;
  56. import org.springframework.web.multipart.MultipartFile;
  57. import org.springframework.web.multipart.MultipartHttpServletRequest;
  58. import java.io.IOException;
  59. import org.springframework.http.ResponseEntity;
  60. import org.springframework.http.HttpHeaders;
  61. import org.springframework.http.HttpStatus;
  62. import org.jeecgframework.core.beanvalidator.BeanValidators;
  63. import javax.validation.ConstraintViolation;
  64. import javax.validation.Validator;
  65. import java.net.URI;
  66. import java.util.regex.Pattern;
  67. import org.springframework.http.MediaType;
  68. import org.springframework.web.util.UriComponentsBuilder;
  69. /**
  70. * @Title: Controller
  71. * @Description: 消息管理主表
  72. * @author onlineGenerator
  73. * @date 2019-05-23 16:51:48
  74. * @version V1.0
  75. *
  76. */
  77. @Controller
  78. @RequestMapping("/mMessageController")
  79. public class MMessageController extends BaseController {
  80. /**
  81. * Logger for this class
  82. */
  83. private static final Logger logger = Logger.getLogger(MMessageController.class);
  84. @Autowired
  85. private MMessageServiceI mMessageService;
  86. @Autowired
  87. private SystemService systemService;
  88. @Autowired
  89. private Validator validator;
  90. @Autowired
  91. private MMessageSendServiceI mMessageSendService;
  92. @Autowired
  93. private WorkflowServiceI workflowService;
  94. @Autowired
  95. private MessageDataDao messageDataDao;
  96. @Autowired
  97. private TSysFileServiceI tSysFileService;
  98. /**
  99. * 消息管理主表列表 页面跳转
  100. *
  101. * @return
  102. */
  103. @RequestMapping(params = "list")
  104. public ModelAndView list(HttpServletRequest request) {
  105. List<MWhiteIpListEntity> whiteIpList = systemService.getList(MWhiteIpListEntity.class);
  106. String ip = IpUtil.getIpAddr(request);
  107. boolean access = false;
  108. for(MWhiteIpListEntity whiteIpListEntity:whiteIpList){
  109. if(whiteIpListEntity.getIp().equals(ip)){
  110. access=true;
  111. break;
  112. }
  113. }
  114. // if(!access){
  115. // return new ModelAndView("cn/com/lzt/message/mMessage-noauth");
  116. // }
  117. return new ModelAndView("cn/com/lzt/message/mMessageList");
  118. }
  119. /**
  120. * easyui AJAX请求数据
  121. *
  122. * @param request
  123. * @param response
  124. * @param dataGrid
  125. */
  126. @RequestMapping(params = "datagrid")
  127. public void datagrid(MMessageEntity mMessage,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
  128. CriteriaQuery cq = new CriteriaQuery(MMessageEntity.class, dataGrid);
  129. //查询条件组装器
  130. String searchTitle = mMessage.getTitle();
  131. if(StringUtils.isNotBlank(searchTitle)){
  132. mMessage.setTitle(searchTitle+"*");
  133. }
  134. org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, mMessage);
  135. try{
  136. //自定义追加查询条件
  137. TSUser user = ResourceUtil.getSessionUser();
  138. cq.add(Restrictions.eq("createBy",user.getUserName()));
  139. }catch (Exception e) {
  140. throw new BusinessException(e.getMessage());
  141. }
  142. cq.add();
  143. cq.addOrder("createDate",SortDirection.desc);
  144. this.mMessageService.getDataGridReturn(cq, true);
  145. List<MMessageEntity> msgList = dataGrid.getResults();
  146. if(msgList != null && msgList.size() > 0) {
  147. ArrayList<String> ids = new ArrayList<String>();
  148. for (MMessageEntity msg : msgList) {
  149. ids.add(msg.getId());
  150. }
  151. String idstr = "'"+StringUtils.join(ids,"','")+"'";
  152. String attrSql = "select distinct busi_id from t_sys_file where busi_id in("+idstr+") ";
  153. List<String> exsitID = systemService.findListbySql(attrSql);
  154. HashMap<String,String> exsitIDMap = new HashMap<String, String>();
  155. for (String id : exsitID) {
  156. exsitIDMap.put(id, id);
  157. }
  158. for (MMessageEntity msg : msgList) {
  159. if(exsitIDMap.containsKey(msg.getId())) {
  160. msg.setUploadattr("有附件");
  161. }else {
  162. msg.setUploadattr("无附件");
  163. }
  164. }
  165. }
  166. TagUtil.datagrid(response, dataGrid);
  167. }
  168. @RequestMapping(params = "messageSendLog")
  169. public ModelAndView messageSendLog(HttpServletRequest request, HttpServletResponse response) {
  170. return new ModelAndView("cn/com/lzt/message/messageSendLog");
  171. }
  172. @RequestMapping(params = "messageSendLogData")
  173. public void messageSendLog(MMessageEntity mMessage,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid
  174. ) {
  175. String messageId = mMessage.getId();
  176. MiniDaoPage<?> list =messageDataDao.messageUserSendLogView(messageId,dataGrid.getPage(),dataGrid.getRows());
  177. if(list!=null){
  178. dataGrid.setResults(list.getResults());
  179. dataGrid.setTotal(list.getTotal());
  180. }
  181. TagUtil.datagrid(response, dataGrid);
  182. }
  183. /**
  184. * 删除消息管理主表
  185. *
  186. * @return
  187. */
  188. @RequestMapping(params = "doDel")
  189. @ResponseBody
  190. public AjaxJson doDel(MMessageEntity mMessage, HttpServletRequest request) {
  191. AjaxJson j = new AjaxJson();
  192. mMessage = systemService.getEntity(MMessageEntity.class, mMessage.getId());
  193. String message = "消息删除成功";
  194. try{
  195. mMessageService.delMain(mMessage);
  196. systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
  197. }catch(Exception e){
  198. e.printStackTrace();
  199. message = "消息删除失败";
  200. throw new BusinessException(e.getMessage());
  201. }
  202. j.setMsg(message);
  203. return j;
  204. }
  205. /**
  206. * 批量删除消息管理主表
  207. *
  208. * @return
  209. */
  210. @RequestMapping(params = "doBatchDel")
  211. @ResponseBody
  212. public AjaxJson doBatchDel(String ids,HttpServletRequest request){
  213. AjaxJson j = new AjaxJson();
  214. String message = "消息删除成功";
  215. try{
  216. for(String id:ids.split(",")){
  217. MMessageEntity mMessage = systemService.getEntity(MMessageEntity.class,
  218. Integer.parseInt(id)
  219. );
  220. mMessageService.delMain(mMessage);
  221. systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
  222. }
  223. }catch(Exception e){
  224. e.printStackTrace();
  225. message = "消息删除失败";
  226. throw new BusinessException(e.getMessage());
  227. }
  228. j.setMsg(message);
  229. return j;
  230. }
  231. /**
  232. * 添加消息管理主表
  233. *
  234. * @return
  235. */
  236. @RequestMapping(params = "doAdd")
  237. @ResponseBody
  238. public AjaxJson doAdd(MMessageEntity mMessage,MMessagePage mMessagePage, HttpServletRequest request) {
  239. beforeSave(mMessage);
  240. if(StringUtils.isNotBlank(mMessage.getId())) {
  241. return doUpdate(mMessage,mMessagePage,request);
  242. }
  243. List<MMessageSendScopeEntity> mMessageSendScopeList = buildMessageSendScope(mMessage);
  244. AjaxJson j = new AjaxJson();
  245. String message = "添加成功";
  246. try{
  247. mMessageService.addMain(mMessage, mMessageSendScopeList);
  248. tSysFileService.updateBusiId(mMessage.getAttachment(), mMessage.getId());
  249. systemService.addLog(message, Globals.Log_Type_INSERT, Globals.Log_Leavel_INFO);
  250. }catch(Exception e){
  251. e.printStackTrace();
  252. message = "消息管理主表添加失败";
  253. throw new BusinessException(e.getMessage());
  254. }
  255. j.setMsg(message);
  256. return j;
  257. }
  258. private void beforeSave(MMessageEntity mMessage) {
  259. String sendWay = mMessage.getSendWay();
  260. String[] sendWayStringArr = sendWay.split(",");
  261. mMessage.setIsWx(0);
  262. mMessage.setIsSite(0);
  263. mMessage.setIsEmail(0);
  264. mMessage.setIsShort(0);
  265. mMessage.setStatus(0);
  266. for(String way :sendWayStringArr){
  267. if(StringUtils.isBlank(way)){
  268. continue;
  269. }
  270. try{
  271. MMessageEntity.MessageSendWay wayEnum = MMessageEntity.MessageSendWay.valueOf(way);
  272. switch(wayEnum){
  273. case wx:mMessage.setIsWx(1);break;
  274. case short_message:mMessage.setIsShort(1);break;
  275. case email:mMessage.setIsEmail(1);break;
  276. case site:mMessage.setIsSite(1);break;
  277. }
  278. }catch(Exception e){
  279. continue;
  280. }
  281. }
  282. String templateData = mMessage.parseTemplateKv();
  283. mMessage.setTemplateData(templateData);
  284. boolean indexUpdate = StringUtils.isBlank(mMessage.getId()) || mMessage.getFileIndex()==null;
  285. String sendText = mMessageService.replaceTemplate(mMessage,true,indexUpdate);
  286. mMessage.setSendText(sendText);
  287. TSUser user = ResourceUtil.getSessionUser();
  288. mMessage.setCreateById(user.getId());
  289. }
  290. private List<MMessageSendScopeEntity> buildMessageSendScope(MMessageEntity mMessage){
  291. List<MMessageSendScopeEntity> mMessageSendScopeList = new ArrayList<>();
  292. String sendScope = mMessage.getSendScope();
  293. String sendScopeIds = mMessage.getSendScopeIds();
  294. if(StringUtils.isBlank(sendScopeIds)){//全员的时候为空
  295. MMessageSendScopeEntity sse = new MMessageSendScopeEntity();
  296. sse.setSendScope(sendScope);
  297. mMessageSendScopeList.add(sse);
  298. }else {
  299. String[] sendScopeIdsArr = sendScopeIds.split(",");
  300. for(String id:sendScopeIdsArr){
  301. MMessageSendScopeEntity sse = new MMessageSendScopeEntity();
  302. sse.setSendScope(sendScope);
  303. sse.setScopeId(id);
  304. mMessageSendScopeList.add(sse);
  305. }
  306. }
  307. return mMessageSendScopeList;
  308. }
  309. /**
  310. * 更新消息管理主表
  311. *
  312. * @return
  313. */
  314. @RequestMapping(params = "doUpdate")
  315. @ResponseBody
  316. public AjaxJson doUpdate(MMessageEntity mMessage,MMessagePage mMessagePage, HttpServletRequest request) {
  317. // List<MMessageSendScopeEntity> mMessageSendScopeList = mMessagePage.getMMessageSendScopeList();
  318. List<MMessageSendScopeEntity> mMessageSendScopeList = buildMessageSendScope(mMessage);
  319. AjaxJson j = new AjaxJson();
  320. String message = "更新成功";
  321. try{
  322. mMessageService.updateMain(mMessage, mMessageSendScopeList);
  323. systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO);
  324. }catch(Exception e){
  325. e.printStackTrace();
  326. message = "更新消息管理主表失败";
  327. throw new BusinessException(e.getMessage());
  328. }
  329. j.setMsg(message);
  330. return j;
  331. }
  332. /**
  333. * 消息管理主表新增页面跳转
  334. *
  335. * @return
  336. */
  337. @RequestMapping(params = "goAdd")
  338. public ModelAndView goAdd(MMessageEntity mMessage, HttpServletRequest req) {
  339. if (StringUtil.isNotEmpty(mMessage.getId())) {
  340. mMessage = mMessageService.getEntity(MMessageEntity.class, mMessage.getId());
  341. req.setAttribute("mMessagePage", mMessage);
  342. }
  343. return new ModelAndView("cn/com/lzt/message/mMessage-add");
  344. }
  345. /**
  346. * 消息管理主表编辑页面跳转
  347. *
  348. * @return
  349. */
  350. @RequestMapping(params = "goUpdate")
  351. public ModelAndView goUpdate(MMessageEntity mMessage, HttpServletRequest req) {
  352. if (StringUtil.isNotEmpty(mMessage.getId())) {
  353. mMessage = mMessageService.getEntity(MMessageEntity.class, mMessage.getId());
  354. req.setAttribute("mMessagePage", mMessage);
  355. }
  356. // return new ModelAndView("cn/com/lzt/message/mMessage-update");
  357. return new ModelAndView("cn/com/lzt/message/mMessage-add");
  358. }
  359. @RequestMapping(params = "goView")
  360. public ModelAndView goView(MMessageEntity message, HttpServletRequest request) {
  361. String taskId = request.getParameter("taskId");
  362. if(LztUtil.isApiRequest()){
  363. return goViewMobile(message,request);
  364. }
  365. if(StringUtils.isBlank(taskId)){
  366. return new ModelAndView("redirect:/mMessageController.do?goUpdate&load=detail&id="+message.getId());
  367. }
  368. if(org.apache.commons.lang.xwork.StringUtils.isNotEmpty(request.getParameter("flag"))){
  369. //驳回重填表单
  370. request.setAttribute("url", "mMessageController.do?goUpdate&returnBack=1&id="+workflowService.getBpmDataId(taskId));
  371. }else {
  372. request.setAttribute("url", "mMessageController.do?goUpdate&load=detail&audit=1&id="+workflowService.getBpmDataId(taskId));
  373. }
  374. Map<String, Object> taskDetails = workflowService.getTaskDetails(taskId);
  375. request.setAttribute("busititle", "消息审批");
  376. request.setAttribute("id", workflowService.getBpmDataId(taskId));
  377. request.setAttribute("bpmLogList", taskDetails.get("bpmLogList"));
  378. request.setAttribute("taskId", taskDetails.get("taskId"));
  379. request.setAttribute("taskName", taskDetails.get("taskName"));
  380. request.setAttribute("task", taskDetails.get("task"));
  381. request.setAttribute("transitionList", taskDetails.get("transitionList"));
  382. request.setAttribute("nextCodeCount", taskDetails.get("nextCodeCount"));
  383. request.setAttribute("bpmLogListCount", taskDetails.get("bpmLogListCount"));
  384. request.setAttribute("bpmLogNewList", taskDetails.get("bpmLogNewList"));
  385. request.setAttribute("bpmLogNewListCount", taskDetails.get("bpmLogNewListCount"));
  386. request.setAttribute("histListNode", taskDetails.get("histListNode"));
  387. request.setAttribute("histListSize", taskDetails.get("histListSize"));
  388. request.setAttribute("turnbackTaskId", taskDetails.get("turnbackTaskId"));
  389. request.setAttribute("height", "500px");
  390. return new ModelAndView("cn/com/lzt/workflow/task-option");
  391. }
  392. @RequestMapping(params = "goViewMobile")
  393. public ModelAndView goViewMobile(MMessageEntity message, HttpServletRequest request) {
  394. String taskId = oConvertUtils.getString(request.getParameter("taskId"));
  395. if(oConvertUtils.isNotEmpty(taskId)){
  396. FormProcUtil.initWorkflowParam(request);
  397. request.setAttribute("taskId",taskId);
  398. }
  399. message = mMessageService.getEntity(MMessageEntity.class, message.getId());
  400. Map<String,String> dicMap = new HashMap<>();
  401. dicMap.put("sendScope",DictUtil.formatToTypeName(message.getSendScope(),"message_send_scope"));
  402. dicMap.put("sendWay",DictUtil.formatToTypeName(message.getSendWay(),"message_send_way"));
  403. dicMap.put("sendTimeType",DictUtil.formatToTypeName(String.valueOf(message.getSendTimeType()),"message_send_time_type"));
  404. dicMap.put("noticeType",DictUtil.formatToTypeName(message.getNoticeType(),"message_notice_type"));
  405. // request.setAttribute("message", message);
  406. // request.setAttribute("dicMap",dicMap);
  407. Map<String, Object> data = new HashMap<>();
  408. data.put("entity",message);
  409. data.put("dicMap",dicMap);
  410. return new JsonDataModelAndView(WXAjaxJson.success(data));
  411. // return "cn/com/lzt/message/message_view_mobile";
  412. }
  413. /**
  414. * 加载明细列表[范围详情]
  415. *
  416. * @return
  417. */
  418. @RequestMapping(params = "mMessageSendScopeList")
  419. public ModelAndView mMessageSendScopeList(MMessageEntity mMessage, HttpServletRequest req) {
  420. //===================================================================================
  421. //获取参数
  422. Object id0 = mMessage.getId();
  423. //===================================================================================
  424. //查询-范围详情
  425. String hql0 = "from MMessageSendScopeEntity where 1 = 1 AND mESSAGE_ID =? ";
  426. try{
  427. List<MMessageSendScopeEntity> mMessageSendScopeEntityList = systemService.findHql(hql0,id0);
  428. req.setAttribute("mMessageSendScopeList", mMessageSendScopeEntityList);
  429. }catch(Exception e){
  430. logger.info(e.getMessage());
  431. }
  432. return new ModelAndView("cn/com/lzt/message/mMessageSendScopeList");
  433. }
  434. /**
  435. * 导出excel
  436. *
  437. * @param request
  438. * @param response
  439. */
  440. @RequestMapping(params = "exportXls")
  441. public String exportXls(MMessageEntity mMessage,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid,ModelMap map) {
  442. CriteriaQuery cq = new CriteriaQuery(MMessageEntity.class, dataGrid);
  443. //查询条件组装器
  444. org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, mMessage);
  445. try{
  446. //自定义追加查询条件
  447. }catch (Exception e) {
  448. throw new BusinessException(e.getMessage());
  449. }
  450. cq.add();
  451. List<MMessageEntity> list=this.mMessageService.getListByCriteriaQuery(cq, false);
  452. List<MMessagePage> pageList=new ArrayList<MMessagePage>();
  453. if(list!=null&&list.size()>0){
  454. for(MMessageEntity entity:list){
  455. try{
  456. MMessagePage page=new MMessagePage();
  457. MyBeanUtils.copyBeanNotNull2Bean(entity,page);
  458. Object id0 = entity.getId();
  459. String hql0 = "from MMessageSendScopeEntity where 1 = 1 AND mESSAGE_ID =? ";
  460. List<MMessageSendScopeEntity> mMessageSendScopeEntityList = systemService.findHql(hql0,id0);
  461. page.setMMessageSendScopeList(mMessageSendScopeEntityList);
  462. pageList.add(page);
  463. }catch(Exception e){
  464. logger.info(e.getMessage());
  465. }
  466. }
  467. }
  468. map.put(NormalExcelConstants.FILE_NAME,"消息管理主表");
  469. map.put(NormalExcelConstants.CLASS,MMessagePage.class);
  470. map.put(NormalExcelConstants.PARAMS,new ExportParams("消息管理主表列表", "导出人:Jeecg",
  471. "导出信息"));
  472. map.put(NormalExcelConstants.DATA_LIST,pageList);
  473. return NormalExcelConstants.JEECG_EXCEL_VIEW;
  474. }
  475. /**
  476. * 通过excel导入数据
  477. * @param request
  478. * @param
  479. * @return
  480. */
  481. @RequestMapping(params = "importExcel", method = RequestMethod.POST)
  482. @ResponseBody
  483. public AjaxJson importExcel(HttpServletRequest request, HttpServletResponse response) {
  484. AjaxJson j = new AjaxJson();
  485. MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
  486. Map<String, MultipartFile> fileMap = multipartRequest.getFileMap();
  487. for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) {
  488. MultipartFile file = entity.getValue();// 获取上传文件对象
  489. ImportParams params = new ImportParams();
  490. params.setTitleRows(2);
  491. params.setHeadRows(2);
  492. params.setNeedSave(true);
  493. try {
  494. List<MMessagePage> list = ExcelImportUtil.importExcel(file.getInputStream(), MMessagePage.class, params);
  495. MMessageEntity entity1=null;
  496. for (MMessagePage page : list) {
  497. entity1=new MMessageEntity();
  498. MyBeanUtils.copyBeanNotNull2Bean(page,entity1);
  499. mMessageService.addMain(entity1, page.getMMessageSendScopeList());
  500. }
  501. j.setMsg("文件导入成功!");
  502. } catch (Exception e) {
  503. j.setMsg("文件导入失败!");
  504. logger.error(ExceptionUtil.getExceptionMessage(e));
  505. }finally{
  506. try {
  507. file.getInputStream().close();
  508. } catch (IOException e) {
  509. e.printStackTrace();
  510. }
  511. }
  512. }
  513. return j;
  514. }
  515. /**
  516. * 导出excel 使模板
  517. */
  518. @RequestMapping(params = "exportXlsByT")
  519. public String exportXlsByT(ModelMap map) {
  520. map.put(NormalExcelConstants.FILE_NAME,"消息管理主表");
  521. map.put(NormalExcelConstants.CLASS,MMessagePage.class);
  522. map.put(NormalExcelConstants.PARAMS,new ExportParams("消息管理主表列表", "导出人:"+ ResourceUtil.getSessionUser().getRealName(),
  523. "导出信息"));
  524. map.put(NormalExcelConstants.DATA_LIST,new ArrayList());
  525. return NormalExcelConstants.JEECG_EXCEL_VIEW;
  526. }
  527. /**
  528. * 导入功能跳转
  529. *
  530. * @return
  531. */
  532. @RequestMapping(params = "upload")
  533. public ModelAndView upload(HttpServletRequest req) {
  534. req.setAttribute("controller_name", "mMessageController");
  535. return new ModelAndView("common/upload/pub_excel_upload");
  536. }
  537. @RequestMapping(method = RequestMethod.GET)
  538. @ResponseBody
  539. public List<MMessageEntity> list() {
  540. List<MMessageEntity> listMMessages=mMessageService.getList(MMessageEntity.class);
  541. return listMMessages;
  542. }
  543. @RequestMapping(value = "/{id}", method = RequestMethod.GET)
  544. @ResponseBody
  545. public ResponseEntity<?> get(@PathVariable("id") String id) {
  546. MMessageEntity task = mMessageService.get(MMessageEntity.class, id);
  547. if (task == null) {
  548. return new ResponseEntity(HttpStatus.NOT_FOUND);
  549. }
  550. return new ResponseEntity(task, HttpStatus.OK);
  551. }
  552. @RequestMapping(method = RequestMethod.POST, consumes = MediaType.APPLICATION_JSON_VALUE)
  553. @ResponseBody
  554. public ResponseEntity<?> create(@RequestBody MMessagePage mMessagePage, UriComponentsBuilder uriBuilder) {
  555. //调用JSR303 Bean Validator进行校验,如果出错返回含400错误码及json格式的错误信息.
  556. Set<ConstraintViolation<MMessagePage>> failures = validator.validate(mMessagePage);
  557. if (!failures.isEmpty()) {
  558. return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
  559. }
  560. //保存
  561. List<MMessageSendScopeEntity> mMessageSendScopeList = mMessagePage.getMMessageSendScopeList();
  562. MMessageEntity mMessage = new MMessageEntity();
  563. try{
  564. MyBeanUtils.copyBeanNotNull2Bean(mMessage,mMessagePage);
  565. }catch(Exception e){
  566. logger.info(e.getMessage());
  567. }
  568. mMessageService.addMain(mMessage, mMessageSendScopeList);
  569. //按照Restful风格约定,创建指向新任务的url, 也可以直接返回id或对象.
  570. String id = mMessagePage.getId();
  571. URI uri = uriBuilder.path("/rest/mMessageController/" + id).build().toUri();
  572. HttpHeaders headers = new HttpHeaders();
  573. headers.setLocation(uri);
  574. return new ResponseEntity(headers, HttpStatus.CREATED);
  575. }
  576. @RequestMapping(value = "/{id}", method = RequestMethod.PUT, consumes = MediaType.APPLICATION_JSON_VALUE)
  577. public ResponseEntity<?> update(@RequestBody MMessagePage mMessagePage) {
  578. //调用JSR303 Bean Validator进行校验,如果出错返回含400错误码及json格式的错误信息.
  579. Set<ConstraintViolation<MMessagePage>> failures = validator.validate(mMessagePage);
  580. if (!failures.isEmpty()) {
  581. return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
  582. }
  583. //保存
  584. List<MMessageSendScopeEntity> mMessageSendScopeList = mMessagePage.getMMessageSendScopeList();
  585. MMessageEntity mMessage = new MMessageEntity();
  586. try{
  587. MyBeanUtils.copyBeanNotNull2Bean(mMessage,mMessagePage);
  588. }catch(Exception e){
  589. logger.info(e.getMessage());
  590. }
  591. mMessageService.updateMain(mMessage, mMessageSendScopeList);
  592. //按Restful约定,返回204状态码, 无内容. 也可以返回200状态码.
  593. return new ResponseEntity(HttpStatus.NO_CONTENT);
  594. }
  595. @RequestMapping(value = "/{id}", method = RequestMethod.DELETE)
  596. @ResponseStatus(HttpStatus.NO_CONTENT)
  597. public void delete(@PathVariable("id") String id) {
  598. MMessageEntity mMessage = mMessageService.get(MMessageEntity.class, id);
  599. mMessageService.delMain(mMessage);
  600. }
  601. //前台用户查看消息
  602. @RequestMapping(params = "user_preview")
  603. public String user_preview(@RequestParam("k") String key,HttpServletRequest request) {
  604. try {
  605. String id = request.getParameter("id");
  606. MMessageEntity messageEntity =null;
  607. if(StringUtils.isNotBlank(id)){//审批预览
  608. messageEntity = systemService.getEntity(MMessageEntity.class,id);
  609. }else {//用户查看
  610. String decodeString = Des3.decode(key);
  611. String[] sa = decodeString.split(Pattern.quote("||||"));
  612. String messageId = sa[0];
  613. String userId = sa[1];
  614. messageEntity = userPreview(userId,messageId);
  615. String readOnly = request.getParameter("readOnly");
  616. TSUser user =systemService.getEntity(TSUser.class,userId);
  617. request.setAttribute("user",user);
  618. if(StringUtils.equals(readOnly,"true" )){//只设置已读状态
  619. return null;
  620. }
  621. }
  622. if(messageEntity==null){
  623. return null;
  624. }
  625. String messageType = messageEntity.getMessageType();
  626. if(StringUtils.equals(messageType,MMessageEntity.MessageType.api.toString())){
  627. request.setAttribute("message",messageEntity);
  628. if(StringUtils.equals(messageEntity.getApiViewer(),"simpleRow" )){//使用后台解析json 前台\t会报错
  629. Map<String,Object> sendTextMap = JSONObject.fromObject(messageEntity.getSendText());
  630. request.setAttribute("sendTextMap", sendTextMap);
  631. }
  632. return "cn/com/lzt/message/view/"+messageEntity.getApiViewer();
  633. }else {
  634. //读取附件
  635. CriteriaQuery cq = new CriteriaQuery(TSysFileEntity.class);
  636. //查询条件组装器
  637. TSysFileEntity tSysFile = new TSysFileEntity();
  638. try{
  639. cq.eq("busiTable","m_message");
  640. cq.eq("tagetType","mmessage");
  641. cq.addOrder("createDate",SortDirection.asc);
  642. cq.eq("busiId",messageEntity.getId());
  643. }catch (Exception e) {
  644. throw new BusinessException(e.getMessage());
  645. }
  646. cq.add();
  647. cq.setDataGrid(new DataGrid());
  648. DataGridReturn dataGridReturn = systemService.getDataGridReturn(cq, false);
  649. // 设置是否预览Flg
  650. for(int i = 0; i < dataGridReturn.getRows().size(); i++) {
  651. TSysFileEntity tSysFileEntity = (TSysFileEntity) dataGridReturn.getRows().get(i);
  652. String fileName = tSysFileEntity.getFileName();
  653. String fileType = fileName.substring(fileName.lastIndexOf(".") + 1);
  654. if("jpg".equals(fileType) || "png".equals(fileType) || "pdf".equals(fileType)) {
  655. tSysFileEntity.setIsPreviewFlg("1");
  656. } else {
  657. tSysFileEntity.setIsPreviewFlg("0");
  658. }
  659. String userName = tSysFileEntity.getCreateBy();
  660. String realName = "";
  661. // 查询主组织
  662. StringBuilder getRealNameByUserNameSql = new StringBuilder();
  663. getRealNameByUserNameSql.append(" SELECT ");
  664. getRealNameByUserNameSql.append(" realname ");
  665. getRealNameByUserNameSql.append(" FROM t_s_base_user ");
  666. getRealNameByUserNameSql.append(" WHERE ");
  667. getRealNameByUserNameSql.append(" username = '" + userName + "'");
  668. List<Map<String, Object>> realNameMapList = systemService.findForJdbc(getRealNameByUserNameSql.toString());
  669. if(realNameMapList.size() > 0) {
  670. realName = (String)realNameMapList.get(0).get("realname");
  671. }
  672. tSysFileEntity.setCreateBy(realName);
  673. }
  674. String showAndDownUrl = ResourceUtil.getConfigByName("showAndDownUrl");
  675. request.setAttribute("showAndDownUrl",showAndDownUrl);
  676. request.setAttribute("fileRows",dataGridReturn.getRows());
  677. request.setAttribute("message",messageEntity);
  678. String host = ResourceUtil.getConfigByName(Globals.SERVER_WXMSG);
  679. request.setAttribute("host",host);
  680. return "cn/com/lzt/message/mMessage-user-preview";
  681. }
  682. } catch (Exception e) {
  683. e.printStackTrace();
  684. }
  685. return null;
  686. }
  687. //后台预览
  688. @RequestMapping(params = "preview")
  689. public String preview(HttpServletRequest request,MMessageEntity mMessage) {
  690. String sendText = mMessageService.replaceTemplate(mMessage,true,false);
  691. mMessage.setSendText(sendText);
  692. request.setAttribute("message",mMessage);
  693. request.setAttribute("back_view",true);
  694. return "cn/com/lzt/message/mMessage-user-preview";
  695. }
  696. //test
  697. @RequestMapping(params = "send")
  698. public String send(HttpServletRequest request,MMessageEntity mMessage) {
  699. // mMessageSendService.sendByMessageId(mMessage.getId());
  700. return null;
  701. }
  702. /**
  703. * 测试消息,
  704. * @param request
  705. * @param mMessage
  706. * @return
  707. */
  708. @RequestMapping(params = "sendTest")
  709. @ResponseBody
  710. public AjaxJson sendTest(HttpServletRequest request,MMessageEntity mMessage) {
  711. // mMessageSendService.sendByMessageId(mMessage.getId())
  712. AjaxJson j = new AjaxJson();
  713. String message = "发送成功";
  714. try {
  715. mMessageSendService.sendForTest(mMessage.getId(),ResourceUtil.getSessionUser().getId());
  716. }catch (Exception e){
  717. e.printStackTrace();
  718. message="发送失败";
  719. }
  720. j.setMsg(message);
  721. return j;
  722. }
  723. @RequestMapping(params = "cancelMessage")
  724. @ResponseBody
  725. public AjaxJson cancelMessage(HttpServletRequest request,@RequestParam("id") String id) {
  726. AjaxJson j = new AjaxJson();
  727. MMessageEntity mMessage = systemService.findUniqueByProperty(MMessageEntity.class,"id",id);
  728. String message = "消息撤回成功";
  729. try{
  730. mMessage.setStatus(1);
  731. mMessage.setCancelTime(new Date());
  732. systemService.updateEntitie(mMessage);
  733. systemService.addLog(message, Globals.Log_Type_OTHER, Globals.Log_Leavel_INFO);
  734. }catch(Exception e){
  735. e.printStackTrace();
  736. message = "消息撤回失败";
  737. throw new BusinessException(e.getMessage());
  738. }
  739. j.setMsg(message);
  740. return j;
  741. }
  742. private MMessageEntity userPreview(String userId, String messageId) {
  743. MPersonalMessageEntity personalMessageEntity =
  744. systemService.singleResult(String.format("from MPersonalMessageEntity where userId ='%s' and messageId='%s'",userId,messageId));
  745. if(personalMessageEntity ==null) return null;
  746. MMessageEntity message = systemService.findUniqueByProperty(MMessageEntity.class,"id",messageId);
  747. if(message==null) return null;
  748. if(personalMessageEntity.getIsRead()==0){
  749. personalMessageEntity.setIsRead(1);
  750. personalMessageEntity.setFirstReadTime(new Date());
  751. systemService.updateEntitie(personalMessageEntity);
  752. message.setSeeCount(message.getSeeCount()+1);
  753. systemService.updateEntitie(message);
  754. }
  755. return message;
  756. }
  757. @RequestMapping(params = "list4all")
  758. public ModelAndView list4all(HttpServletRequest request) {
  759. List<MWhiteIpListEntity> whiteIpList = systemService.getList(MWhiteIpListEntity.class);
  760. String ip = IpUtil.getIpAddr(request);
  761. boolean access = false;
  762. for(MWhiteIpListEntity whiteIpListEntity:whiteIpList){
  763. if(whiteIpListEntity.getIp().equals(ip)){
  764. access=true;
  765. break;
  766. }
  767. }
  768. if(!access){
  769. return new ModelAndView("cn/com/lzt/message/mMessage-noauth");
  770. }
  771. return new ModelAndView("cn/com/lzt/message/message_list_all");
  772. }
  773. /**
  774. * easyui AJAX请求数据
  775. *
  776. * @param request
  777. * @param response
  778. * @param dataGrid
  779. */
  780. @RequestMapping(params = "datagrid4all")
  781. public void datagrid4all(MMessageEntity mMessage,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
  782. CriteriaQuery cq = new CriteriaQuery(MMessageEntity.class, dataGrid);
  783. //查询条件组装器
  784. if(StringUtils.isNotBlank(mMessage.getTitle())){
  785. cq.like("title", "%"+mMessage.getTitle()+"%");
  786. mMessage.setTitle(null);
  787. }
  788. if(StringUtils.isNotBlank(mMessage.getCreateName())){
  789. cq.like("createName","%"+mMessage.getCreateName()+"%" );
  790. mMessage.setCreateName(null);
  791. }
  792. org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, mMessage,request.getParameterMap());
  793. try{
  794. //自定义追加查询条件
  795. TSUser user = ResourceUtil.getSessionUser();
  796. cq.notEq("createById", "-1");
  797. }catch (Exception e) {
  798. throw new BusinessException(e.getMessage());
  799. }
  800. cq.add();
  801. cq.addOrder("createDate",SortDirection.desc);
  802. this.mMessageService.getDataGridReturn(cq, true);
  803. List<MMessageEntity> msgList = dataGrid.getResults();
  804. if(msgList != null && msgList.size() > 0) {
  805. ArrayList<String> ids = new ArrayList<String>();
  806. for (MMessageEntity msg : msgList) {
  807. ids.add(msg.getId());
  808. }
  809. String idstr = "'"+StringUtils.join(ids,"','")+"'";
  810. String attrSql = "select distinct busi_id from t_sys_file where busi_id in("+idstr+") ";
  811. List<String> exsitID = systemService.findListbySql(attrSql);
  812. HashMap<String,String> exsitIDMap = new HashMap<String, String>();
  813. for (String id : exsitID) {
  814. exsitIDMap.put(id, id);
  815. }
  816. for (MMessageEntity msg : msgList) {
  817. if(exsitIDMap.containsKey(msg.getId())) {
  818. msg.setUploadattr("有附件");
  819. }else {
  820. msg.setUploadattr("无附件");
  821. }
  822. }
  823. }
  824. TagUtil.datagrid(response, dataGrid);
  825. }
  826. }