rpt_tpl_controller.js 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409
  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. me = this;
  22. ;
  23. if (req.session.sessionUser && req.session.sessionUser.id) userId = req.session.sessionUser.id;
  24. let userIds = [];
  25. userIds.push(userId);
  26. if (userId !== "-100") {
  27. userIds.push("-100");
  28. }
  29. rptCustCfgFacade.getCustomizeCfg(userIds).then(function (custCfg) {
  30. if (custCfg) {
  31. //success
  32. let rst = null;
  33. if (custCfg.length > 0) {
  34. rst = [];
  35. rst.push(null);
  36. for (let itemCfg of custCfg) {
  37. // rst = itemCfg;
  38. let doc = (itemCfg._doc)?itemCfg._doc:itemCfg;
  39. let dest = {};
  40. copyRptCfg(doc, dest);
  41. if (doc.userId !== "-100") {
  42. rst.push(dest);
  43. } else {
  44. rst[0] = dest;
  45. }
  46. }
  47. }
  48. if (rst !== null && rst.length === 1) {
  49. //copy dft config
  50. let userDest = {};
  51. copyRptCfg(rst[0], userDest);
  52. rst.push(userDest);
  53. }
  54. callback(req,res, false, "", rst);
  55. } else {
  56. //failed
  57. callback(req,res, true, "失败!", null);
  58. }
  59. })
  60. },
  61. saveCustomerCfg: function (req, res) {
  62. let params = JSON.parse(req.body.params),
  63. userId = params.userId,
  64. custCfg = params.custCfg;
  65. ;
  66. if (req.session.sessionUser && req.session.sessionUser.id) userId = req.session.sessionUser.id;
  67. custCfg.userId = userId;
  68. rptCustCfgFacade.saveCustomizeCfg(custCfg).then(function (rst) {
  69. if (rst) {
  70. //success
  71. callback(req,res, false, "", "success!");
  72. } else {
  73. //failed
  74. callback(req,res, true, "更新失败!", null);
  75. }
  76. })
  77. },
  78. getDftTemplates(req, res) {
  79. let filter = {"userId": "-100", "$or": [{"isDeleted": null}, {"isDeleted": false} ]};
  80. TreeNodeModel.find(filter, '-_id', function(err, data){
  81. if (err) {
  82. callback(req,res, true,"", null);
  83. } else {
  84. callback(req,res,false,"", data);
  85. }
  86. });
  87. },
  88. getCompilationList(req, res) {
  89. let compilationModel = new CompilationModel();
  90. let compilationList = compilationModel.getCompilationList();
  91. if (compilationList) {
  92. compilationList.then(function (rst) {
  93. callback(req,res,false,"", rst);
  94. })
  95. } else {
  96. callback(req,res, true,"no result", null);
  97. }
  98. },
  99. getRptTplTree: function(req, res) {
  100. let params = JSON.parse(req.body.params),
  101. compilationId = params.compilationId,
  102. userId = params.userId,
  103. sessionUserId = null;
  104. let userIds = ["-100"];
  105. if (req.session.sessionUser && req.session.sessionUser.id) sessionUserId = req.session.sessionUser.id;
  106. if (userId !== null) {
  107. if (typeof userId === "string") {
  108. if (userIds.indexOf(userId) < 0) userIds.push(userId);
  109. } else if (userId instanceof Array) {
  110. for (let uid of userId) {
  111. userIds.push(uid);
  112. }
  113. }
  114. } else {
  115. }
  116. if (sessionUserId && userIds.indexOf(sessionUserId) < 0) userIds.push(sessionUserId);
  117. if (!compilationId) {
  118. compilationId = req.session.sessionCompilation._id;
  119. }
  120. rttFacade.findTplTree(compilationId, userIds).then(function(result) {
  121. if (result) {
  122. callback(req,res,false,"", result);
  123. } else {
  124. callback(req,res, true,"no result", null);
  125. }
  126. });
  127. },
  128. updateTreeNodes: function(req, res) {
  129. let params = JSON.parse(req.body.params),
  130. nodes = params.nodes;
  131. let functions = [];
  132. for (let node of nodes) {
  133. functions.push((function(doc) {
  134. return function(cb) {
  135. TreeNodeModel.update({ID: doc.ID}, doc, cb);
  136. };
  137. })(node));
  138. }
  139. async.parallel(functions, function(err, results) {
  140. callback(req,res, err, "", results);
  141. });
  142. },
  143. deleteRptTplNodes: function(req, res){
  144. let params = JSON.parse(req.body.params),
  145. nodeIds = params.nodeIds,
  146. preNodeId = params.preNodeId,
  147. preNodeNextId = params.preNodeNextId;
  148. let functions = [];
  149. if (preNodeId !== -1) {
  150. functions.push((function(nodeId, nextId) {
  151. return function(cb) {
  152. TreeNodeModel.update({ID: nodeId}, {"NextSiblingID": nextId}, cb);
  153. };
  154. })(preNodeId, preNodeNextId));
  155. }
  156. for (let nId of nodeIds) {
  157. functions.push((function(nodeId) {
  158. return function(cb) {
  159. TreeNodeModel.update({ID: nodeId}, {"isDeleted": true}, cb);
  160. };
  161. })(nId));
  162. }
  163. async.parallel(functions, function(err, results) {
  164. callback(req,res, err, "", results);
  165. });
  166. },
  167. createTreeRootNode: function(req, res){
  168. let params = JSON.parse(req.body.params),
  169. doc = params.doc;
  170. rttFacade.createNewTree(doc).then(function (rst) {
  171. if (rst) {
  172. //success
  173. callback(req,res, false, "", rst);
  174. } else {
  175. //failed
  176. callback(req,res, true, "创建失败!", null);
  177. }
  178. })
  179. },
  180. updateTreeRootNode: function(req, res){
  181. let params = JSON.parse(req.body.params),
  182. doc = params.doc;
  183. rttFacade.updateTree(doc.compilationId, doc.engineerId, doc.userId, doc).then(function (rst) {
  184. if (rst) {
  185. //success
  186. callback(req,res, false, "", rst);
  187. } else {
  188. //failed
  189. callback(req,res, true, "更新失败!", null);
  190. }
  191. })
  192. },
  193. updateTopNodeName: function (req, res) {
  194. //备注:因设计的更改,此方法将被放弃
  195. let params = JSON.parse(req.body.params),
  196. compilationId = params.compilationId, engineerId = params.engineerId,
  197. userId = params.userId,
  198. nodeName = params.nodeName
  199. ;
  200. if (req.session.sessionUser && req.session.sessionUser.id) userId = req.session.sessionUser.id;
  201. let filter = {"compilationId": compilationId, "engineerId": engineerId, "userId": userId, "$or": [{"isDeleted": null}, {"isDeleted": false}]};
  202. let updateStatement = {"$set": {"name": nodeName}};
  203. rttFacade.updateTreeInDetail(filter, updateStatement).then(function (rst) {
  204. if (rst) {
  205. //success
  206. callback(req,res, false, "", rst);
  207. } else {
  208. //failed
  209. callback(req,res, true, "更新失败!", null);
  210. }
  211. });
  212. },
  213. updateSubLevelOneNode: function (req, res) {
  214. let params = JSON.parse(req.body.params),
  215. compilationId = params.compilationId,
  216. // engineerId = params.engineerId,
  217. userId = params.userId,
  218. subNode = params.subNode
  219. ;
  220. if (req.session.sessionUser && req.session.sessionUser.id) userId = req.session.sessionUser.id; //备注:这段逻辑只会在前端有效,后端运维不会走到
  221. let filter = {"compilationId": compilationId, "userId": userId, "items.ID": subNode.ID, "$or": [{"isDeleted": null}, {"isDeleted": false}]};
  222. let updateStatement = {$set: {"items.$": subNode}};
  223. rttFacade.updateTreeInDetail(filter, updateStatement).then(function (rst) {
  224. if (rst) {
  225. //success
  226. callback(req,res, false, "", rst);
  227. } else {
  228. //failed
  229. callback(req,res, true, "更新失败!", null);
  230. }
  231. });
  232. },
  233. removeTreeRootNode: function (req, res) {
  234. let params = JSON.parse(req.body.params),
  235. compilationId = params.compilationId,
  236. engineerId = params.engineerId,
  237. userId = params.userId,
  238. isPhysically = params.isPhysically
  239. ;
  240. if (req.session.sessionUser && req.session.sessionUser.id) userId = req.session.sessionUser.id;
  241. if (isPhysically) {
  242. rttFacade.removeTreePhycically(compilationId, engineerId, userId).then(function (rst) {
  243. if (rst) {
  244. //success
  245. callback(req,res, false, "", rst);
  246. } else {
  247. //failed
  248. callback(req,res, true, "删除失败!", null);
  249. }
  250. })
  251. } else {
  252. rttFacade.removeTree(compilationId, engineerId, userId).then(function (rst) {
  253. if (rst) {
  254. //success
  255. callback(req,res, false, "", rst);
  256. } else {
  257. //failed
  258. callback(req,res, true, "删除失败!", null);
  259. }
  260. })
  261. }
  262. },
  263. // createTplTreeNode: function(req, res){
  264. // let params = JSON.parse(req.body.params),
  265. // lastNodeId = params.lastNodeId,
  266. // nodeData = params.rawNodeData;
  267. // counter.counterDAO.getIDAfterCount(counter.moduleName.report, 1, function(err, result){
  268. // nodeData.ID = result.value.sequence_value;
  269. // let node = new TreeNodeModel(nodeData);
  270. // node.save(function (err, result) {
  271. // if (err) {
  272. // callback(req,res, "树节点错误!", "", null);
  273. // } else {
  274. // if (lastNodeId > 0) {
  275. // TreeNodeModel.update({ID: lastNodeId}, {"NextSiblingID": nodeData.ID}, function(err, rst){
  276. // if (err) {
  277. // callback(req,res, "树节点错误!", "", null);
  278. // } else {
  279. // callback(req,res, false, "", result);
  280. // }
  281. // });
  282. // } else callback(req,res, false, "", result);
  283. // }
  284. // });
  285. // });
  286. // },
  287. getNewNodeID: function(req, res) {
  288. let params = JSON.parse(req.body.params),
  289. scope = params.scope;
  290. counter.counterDAO.getIDAfterCount(counter.moduleName.report, scope, function(err, result){
  291. callback(req,res, false, "", result.sequence_value);
  292. });
  293. },
  294. createDftRptTpl: function(req, res) {
  295. let params = JSON.parse(req.body.params),
  296. treeNodeId = params.treeNodeId,
  297. rptDftTplId = params.rptDftTplId,
  298. rptName = params.rptName,
  299. grpKey = params.grpKey,
  300. compilationId = params.compilationId,
  301. engineerId = params.engineerId,
  302. userId = params.userId,
  303. subNode = params.subNode
  304. ;
  305. if (req.session.sessionUser && req.session.sessionUser.id) userId = req.session.sessionUser.id;
  306. let filter = {"ID": rptDftTplId};
  307. RptTplModel.findOne(filter, '-_id').exec().then(function(dftTplRst) {
  308. if (dftTplRst) {
  309. let _doc = dftTplRst["_doc"];
  310. _doc["ID"] = treeNodeId;
  311. _doc["GROUP_KEY"] = grpKey;
  312. _doc["ID_KEY"] = "";
  313. _doc[JV.NODE_MAIN_INFO][JV.NODE_MAIN_INFO_RPT_NAME] = rptName;
  314. let rptTpl = new RptTplModel(_doc);
  315. rptTpl.save(function (err, actTplRst) {
  316. if (err) {
  317. callback(req,res, "报表模板创建错误", "", null);
  318. } else {
  319. //TreeNodeModel.update();
  320. let filter = {"compilationId": compilationId, "engineerId": engineerId, "userId": userId, "items.ID": subNode.ID, "$or": [{"isDeleted": null}, {"isDeleted": false}]};
  321. let updateStatement = {$set: {"items.$": subNode}};
  322. rttFacade.updateTreeInDetail(filter, updateStatement).then(function (rst) {
  323. if (rst) {
  324. //success
  325. callback(req,res, false, "", actTplRst);
  326. } else {
  327. //failed
  328. callback(req,res, true, "更新失败!", null);
  329. }
  330. });
  331. }
  332. });
  333. } else {
  334. callback(req, res, 'Create report template failed!', null);
  335. }
  336. })
  337. },
  338. getRefRptTpl: function (req, res) {
  339. let params = JSON.parse(req.body.params),
  340. rptTplId = params.rptTplId;
  341. let filter = {"ID": rptTplId};
  342. RptTplModel.findOne(filter, '-_id').exec().then(function(rstTpl) {
  343. if (rstTpl) {
  344. callback(req,res, false, "", rstTpl);
  345. } else {
  346. callback(req, res, 'The report template was not found!', null);
  347. }
  348. })
  349. },
  350. updateRptTpl: function (req, res) {
  351. let params = JSON.parse(req.body.params),
  352. rptTpl = JSON.parse(params.rptTpl);
  353. let filter = {"ID": parseInt(rptTpl[JV.PROP_ID])};
  354. RptTplModel.update(filter, rptTpl, function (err, rst) {
  355. if (err) {
  356. callback(req, res, true, 'The report template was updated failed!', false);
  357. } else {
  358. callback(req, res, false, 'The report template was updated successfully!', true);
  359. }
  360. });
  361. },
  362. copyRptTpl: function (req, res) {
  363. let params = JSON.parse(req.body.params),
  364. orgRptTplId = params.orgRptTplId,
  365. newID = params.newRptTplId;
  366. let filter = {"ID": orgRptTplId};
  367. RptTplModel.findOne(filter, '-_id').exec().then(function(baseTplRst) {
  368. if (baseTplRst) {
  369. let _doc = baseTplRst["_doc"];
  370. _doc["ID"] = newID;
  371. if (_doc["GROUP_KEY"].indexOf("(Copy)") < 0) {
  372. _doc["GROUP_KEY"] = _doc["GROUP_KEY"] + "(Copy)";
  373. }
  374. let rptTpl = new RptTplModel(_doc);
  375. rptTpl.save(function (err, actTplRst) {
  376. if (err) {
  377. callback(req,res, "报表模板创建错误", "", null);
  378. } else {
  379. callback(req,res, false, "", newID);
  380. }
  381. });
  382. } else {
  383. callback(req, res, 'Create report template failed!', null);
  384. }
  385. });
  386. }
  387. };
  388. function copyRptCfg(src, dest) {
  389. dest.margins = {Left: src.margins.Left, Right: src.margins.Right, Top: src.margins.Top, Bottom: src.margins.Bottom};
  390. dest.showVerticalLine = src.showVerticalLine;
  391. dest.isNarrow = src.isNarrow;
  392. dest.fillZero = src.fillZero;
  393. dest.fonts = [];
  394. for (let font of src.fonts) {
  395. dest.fonts.push({"ID": font["ID"], "CfgDispName": font["CfgDispName"], "Name": font["Name"], "FontHeight": font["FontHeight"], "FontColor": font["FontColor"],
  396. "FontBold": font["FontBold"], "FontItalic": font["FontItalic"], "FontUnderline": font["FontUnderline"], "FontStrikeOut": font["FontStrikeOut"], "FontAngle": font["FontAngle"]});
  397. }
  398. }
  399. export default mExport;