rpt_tpl_controller.js 16 KB

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