rpt_tpl_controller.js 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376
  1. /**
  2. * Created by Tony on 2017/6/1.
  3. */
  4. import mongoose from "mongoose";
  5. import async from "async";
  6. import counter from "../../../public/counter/counter";
  7. let RptTplModel = mongoose.model('rpt_templates');
  8. let TreeNodeModel = mongoose.model('rpt_tpl_tree');
  9. let rptCustCfgFacade = require("../facade/rpt_cust_cfg_facade");
  10. import JV from "../rpt_component/jpc_value_define";
  11. import rttFacade from "../facade/rpt_tpl_tree_node_facade";
  12. import CompilationModel from "../../users/models/compilation_model";
  13. //统一回调函数
  14. let callback = function(req, res, err, message, data){
  15. res.json({error: err, message: message, data: data});
  16. };
  17. let mExport = {
  18. getCustomerCfg(req, res) {
  19. let params = JSON.parse(req.body.params),
  20. userId = params.userId
  21. ;
  22. if (req.session.sessionUser && req.session.sessionUser.id) userId = req.session.sessionUser.id;
  23. let userIds = [];
  24. userIds.push(userId);
  25. if (userId !== "-100") {
  26. userIds.push("-100");
  27. }
  28. rptCustCfgFacade.getCustomizeCfg(userIds).then(function (custCfg) {
  29. if (custCfg) {
  30. //success
  31. let rst = null;
  32. if (custCfg.length > 0) {
  33. for (let itemCfg of custCfg) {
  34. rst = itemCfg;
  35. let doc = (itemCfg._doc)?itemCfg._doc:itemCfg;
  36. if (doc.userId !== "-100") {
  37. break;
  38. }
  39. }
  40. }
  41. callback(req,res, false, "", rst);
  42. } else {
  43. //failed
  44. callback(req,res, true, "失败!", null);
  45. }
  46. })
  47. },
  48. saveCustomerCfg: function (req, res) {
  49. let params = JSON.parse(req.body.params),
  50. userId = params.userId,
  51. custCfg = params.custCfg;
  52. ;
  53. if (req.session.sessionUser && req.session.sessionUser.id) userId = req.session.sessionUser.id;
  54. custCfg.userId = userId;
  55. rptCustCfgFacade.saveCustomizeCfg(custCfg).then(function (rst) {
  56. if (rst) {
  57. //success
  58. callback(req,res, false, "", "success!");
  59. } else {
  60. //failed
  61. callback(req,res, true, "更新失败!", null);
  62. }
  63. })
  64. },
  65. getDftTemplates(req, res) {
  66. let filter = {"userId": "-100", "$or": [{"isDeleted": null}, {"isDeleted": false} ]};
  67. TreeNodeModel.find(filter, '-_id', function(err, data){
  68. if (err) {
  69. callback(req,res, true,"", null);
  70. } else {
  71. callback(req,res,false,"", data);
  72. }
  73. });
  74. },
  75. getCompilationList(req, res) {
  76. let compilationModel = new CompilationModel();
  77. let compilationList = compilationModel.getCompilationList();
  78. if (compilationList) {
  79. compilationList.then(function (rst) {
  80. callback(req,res,false,"", rst);
  81. })
  82. } else {
  83. callback(req,res, true,"no result", null);
  84. }
  85. },
  86. getRptTplTree: function(req, res) {
  87. let params = JSON.parse(req.body.params),
  88. compilationId = params.compilationId,
  89. userId = params.userId,
  90. engineerId = params.engineerId;
  91. if (req.session.sessionUser && req.session.sessionUser.id) userId = req.session.sessionUser.id;
  92. let userIds = [];
  93. userIds.push(userId);
  94. if (userId != "-100") {
  95. userIds.push("-100");
  96. }
  97. if (!compilationId) {
  98. compilationId = req.session.sessionCompilation._id;
  99. }
  100. rttFacade.findTplTree(compilationId, engineerId, userIds).then(function(result) {
  101. if (result) {
  102. callback(req,res,false,"", result);
  103. } else {
  104. callback(req,res, true,"no result", null);
  105. }
  106. });
  107. },
  108. updateTreeNodes: function(req, res) {
  109. let params = JSON.parse(req.body.params),
  110. nodes = params.nodes;
  111. let functions = [];
  112. for (let node of nodes) {
  113. functions.push((function(doc) {
  114. return function(cb) {
  115. TreeNodeModel.update({ID: doc.ID}, doc, cb);
  116. };
  117. })(node));
  118. }
  119. async.parallel(functions, function(err, results) {
  120. callback(req,res, err, "", results);
  121. });
  122. },
  123. deleteRptTplNodes: function(req, res){
  124. let params = JSON.parse(req.body.params),
  125. nodeIds = params.nodeIds,
  126. preNodeId = params.preNodeId,
  127. preNodeNextId = params.preNodeNextId;
  128. let functions = [];
  129. if (preNodeId !== -1) {
  130. functions.push((function(nodeId, nextId) {
  131. return function(cb) {
  132. TreeNodeModel.update({ID: nodeId}, {"NextSiblingID": nextId}, cb);
  133. };
  134. })(preNodeId, preNodeNextId));
  135. }
  136. for (let nId of nodeIds) {
  137. functions.push((function(nodeId) {
  138. return function(cb) {
  139. TreeNodeModel.update({ID: nodeId}, {"isDeleted": true}, cb);
  140. };
  141. })(nId));
  142. }
  143. async.parallel(functions, function(err, results) {
  144. callback(req,res, err, "", results);
  145. });
  146. },
  147. createTreeRootNode: function(req, res){
  148. let params = JSON.parse(req.body.params),
  149. doc = params.doc;
  150. rttFacade.createNewTree(doc).then(function (rst) {
  151. if (rst) {
  152. //success
  153. callback(req,res, false, "", rst);
  154. } else {
  155. //failed
  156. callback(req,res, true, "创建失败!", null);
  157. }
  158. })
  159. },
  160. updateTreeRootNode: function(req, res){
  161. let params = JSON.parse(req.body.params),
  162. doc = params.doc;
  163. rttFacade.updateTree(doc.compilationId, doc.engineerId, doc.userId, doc).then(function (rst) {
  164. if (rst) {
  165. //success
  166. callback(req,res, false, "", rst);
  167. } else {
  168. //failed
  169. callback(req,res, true, "更新失败!", null);
  170. }
  171. })
  172. },
  173. updateTopNodeName: function (req, res) {
  174. let params = JSON.parse(req.body.params),
  175. compilationId = params.compilationId, engineerId = params.engineerId,
  176. userId = params.userId,
  177. nodeName = params.nodeName
  178. ;
  179. if (req.session.sessionUser && req.session.sessionUser.id) userId = req.session.sessionUser.id;
  180. let filter = {"compilationId": compilationId, "engineerId": engineerId, "userId": userId, "$or": [{"isDeleted": null}, {"isDeleted": false}]};
  181. let updateStatement = {"$set": {"name": nodeName}};
  182. rttFacade.updateTreeInDetail(filter, updateStatement).then(function (rst) {
  183. if (rst) {
  184. //success
  185. callback(req,res, false, "", rst);
  186. } else {
  187. //failed
  188. callback(req,res, true, "更新失败!", null);
  189. }
  190. });
  191. },
  192. updateSubLevelOneNode: function (req, res) {
  193. let params = JSON.parse(req.body.params),
  194. compilationId = params.compilationId, engineerId = params.engineerId,
  195. userId = params.userId,
  196. subNode = params.subNode
  197. ;
  198. if (req.session.sessionUser && req.session.sessionUser.id) userId = req.session.sessionUser.id;
  199. let filter = {"compilationId": compilationId, "engineerId": engineerId, "userId": userId, "items.ID": subNode.ID, "$or": [{"isDeleted": null}, {"isDeleted": false}]};
  200. let updateStatement = {$set: {"items.$": subNode}};
  201. rttFacade.updateTreeInDetail(filter, updateStatement).then(function (rst) {
  202. if (rst) {
  203. //success
  204. callback(req,res, false, "", rst);
  205. } else {
  206. //failed
  207. callback(req,res, true, "更新失败!", null);
  208. }
  209. });
  210. },
  211. removeTreeRootNode: function (req, res) {
  212. let params = JSON.parse(req.body.params),
  213. compilationId = params.compilationId,
  214. engineerId = params.engineerId,
  215. userId = params.userId,
  216. isPhysically = params.isPhysically
  217. ;
  218. if (req.session.sessionUser && req.session.sessionUser.id) userId = req.session.sessionUser.id;
  219. if (isPhysically) {
  220. rttFacade.removeTreePhycically(compilationId, engineerId, userId).then(function (rst) {
  221. if (rst) {
  222. //success
  223. callback(req,res, false, "", rst);
  224. } else {
  225. //failed
  226. callback(req,res, true, "删除失败!", null);
  227. }
  228. })
  229. } else {
  230. rttFacade.removeTree(compilationId, engineerId, userId).then(function (rst) {
  231. if (rst) {
  232. //success
  233. callback(req,res, false, "", rst);
  234. } else {
  235. //failed
  236. callback(req,res, true, "删除失败!", null);
  237. }
  238. })
  239. }
  240. },
  241. // createTplTreeNode: function(req, res){
  242. // let params = JSON.parse(req.body.params),
  243. // lastNodeId = params.lastNodeId,
  244. // nodeData = params.rawNodeData;
  245. // counter.counterDAO.getIDAfterCount(counter.moduleName.report, 1, function(err, result){
  246. // nodeData.ID = result.value.sequence_value;
  247. // let node = new TreeNodeModel(nodeData);
  248. // node.save(function (err, result) {
  249. // if (err) {
  250. // callback(req,res, "树节点错误!", "", null);
  251. // } else {
  252. // if (lastNodeId > 0) {
  253. // TreeNodeModel.update({ID: lastNodeId}, {"NextSiblingID": nodeData.ID}, function(err, rst){
  254. // if (err) {
  255. // callback(req,res, "树节点错误!", "", null);
  256. // } else {
  257. // callback(req,res, false, "", result);
  258. // }
  259. // });
  260. // } else callback(req,res, false, "", result);
  261. // }
  262. // });
  263. // });
  264. // },
  265. getNewNodeID: function(req, res) {
  266. let params = JSON.parse(req.body.params),
  267. scope = params.scope;
  268. counter.counterDAO.getIDAfterCount(counter.moduleName.report, scope, function(err, result){
  269. callback(req,res, false, "", result.sequence_value);
  270. });
  271. },
  272. createDftRptTpl: function(req, res) {
  273. let params = JSON.parse(req.body.params),
  274. treeNodeId = params.treeNodeId,
  275. rptDftTplId = params.rptDftTplId,
  276. rptName = params.rptName,
  277. grpKey = params.grpKey,
  278. compilationId = params.compilationId,
  279. engineerId = params.engineerId,
  280. userId = params.userId,
  281. subNode = params.subNode
  282. ;
  283. if (req.session.sessionUser && req.session.sessionUser.id) userId = req.session.sessionUser.id;
  284. let filter = {"ID": rptDftTplId};
  285. RptTplModel.findOne(filter, '-_id').exec().then(function(dftTplRst) {
  286. if (dftTplRst) {
  287. let _doc = dftTplRst["_doc"];
  288. _doc["ID"] = treeNodeId;
  289. _doc["GROUP_KEY"] = grpKey;
  290. _doc["ID_KEY"] = "";
  291. _doc[JV.NODE_MAIN_INFO][JV.NODE_MAIN_INFO_RPT_NAME] = rptName;
  292. let rptTpl = new RptTplModel(_doc);
  293. rptTpl.save(function (err, actTplRst) {
  294. if (err) {
  295. callback(req,res, "报表模板创建错误", "", null);
  296. } else {
  297. //TreeNodeModel.update();
  298. let filter = {"compilationId": compilationId, "engineerId": engineerId, "userId": userId, "items.ID": subNode.ID, "$or": [{"isDeleted": null}, {"isDeleted": false}]};
  299. let updateStatement = {$set: {"items.$": subNode}};
  300. rttFacade.updateTreeInDetail(filter, updateStatement).then(function (rst) {
  301. if (rst) {
  302. //success
  303. callback(req,res, false, "", actTplRst);
  304. } else {
  305. //failed
  306. callback(req,res, true, "更新失败!", null);
  307. }
  308. });
  309. }
  310. });
  311. } else {
  312. callback(req, res, 'Create report template failed!', null);
  313. }
  314. })
  315. },
  316. getRefRptTpl: function (req, res) {
  317. let params = JSON.parse(req.body.params),
  318. rptTplId = params.rptTplId;
  319. let filter = {"ID": rptTplId};
  320. RptTplModel.findOne(filter, '-_id').exec().then(function(rstTpl) {
  321. if (rstTpl) {
  322. callback(req,res, false, "", rstTpl);
  323. } else {
  324. callback(req, res, 'The report template was not found!', null);
  325. }
  326. })
  327. },
  328. updateRptTpl: function (req, res) {
  329. let params = JSON.parse(req.body.params),
  330. rptTpl = JSON.parse(params.rptTpl);
  331. let filter = {"ID": parseInt(rptTpl[JV.PROP_ID])};
  332. RptTplModel.update(filter, rptTpl, function (err, rst) {
  333. if (err) {
  334. callback(req, res, true, 'The report template was updated failed!', false);
  335. } else {
  336. callback(req, res, false, 'The report template was updated successfully!', true);
  337. }
  338. });
  339. },
  340. copyRptTpl: function (req, res) {
  341. let params = JSON.parse(req.body.params),
  342. orgRptTplId = params.orgRptTplId,
  343. newID = params.newRptTplId;
  344. let filter = {"ID": orgRptTplId};
  345. RptTplModel.findOne(filter, '-_id').exec().then(function(baseTplRst) {
  346. if (baseTplRst) {
  347. let _doc = baseTplRst["_doc"];
  348. _doc["ID"] = newID;
  349. if (_doc["GROUP_KEY"].indexOf("(Copy)") < 0) {
  350. _doc["GROUP_KEY"] = _doc["GROUP_KEY"] + "(Copy)";
  351. }
  352. let rptTpl = new RptTplModel(_doc);
  353. rptTpl.save(function (err, actTplRst) {
  354. if (err) {
  355. callback(req,res, "报表模板创建错误", "", null);
  356. } else {
  357. callback(req,res, false, "", newID);
  358. }
  359. });
  360. } else {
  361. callback(req, res, 'Create report template failed!', null);
  362. }
  363. });
  364. }
  365. };
  366. export default mExport;