rpt_tpl_controller.js 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384
  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. sessionUserId = null,
  91. engineerId = params.engineerId;
  92. let userIds = ["-100"];
  93. if (req.session.sessionUser && req.session.sessionUser.id) sessionUserId = req.session.sessionUser.id;
  94. if (userId !== null) {
  95. if (typeof userId === "string") {
  96. if (userIds.indexOf(userId) < 0) userIds.push(userId);
  97. } else if (userId instanceof Array) {
  98. for (let uid of userId) {
  99. userIds.push(uid);
  100. }
  101. }
  102. } else {
  103. }
  104. if (sessionUserId && userIds.indexOf(sessionUserId) < 0) userIds.push(sessionUserId);
  105. if (!compilationId) {
  106. compilationId = req.session.sessionCompilation._id;
  107. }
  108. rttFacade.findTplTree(compilationId, engineerId, userIds).then(function(result) {
  109. if (result) {
  110. callback(req,res,false,"", result);
  111. } else {
  112. callback(req,res, true,"no result", null);
  113. }
  114. });
  115. },
  116. updateTreeNodes: function(req, res) {
  117. let params = JSON.parse(req.body.params),
  118. nodes = params.nodes;
  119. let functions = [];
  120. for (let node of nodes) {
  121. functions.push((function(doc) {
  122. return function(cb) {
  123. TreeNodeModel.update({ID: doc.ID}, doc, cb);
  124. };
  125. })(node));
  126. }
  127. async.parallel(functions, function(err, results) {
  128. callback(req,res, err, "", results);
  129. });
  130. },
  131. deleteRptTplNodes: function(req, res){
  132. let params = JSON.parse(req.body.params),
  133. nodeIds = params.nodeIds,
  134. preNodeId = params.preNodeId,
  135. preNodeNextId = params.preNodeNextId;
  136. let functions = [];
  137. if (preNodeId !== -1) {
  138. functions.push((function(nodeId, nextId) {
  139. return function(cb) {
  140. TreeNodeModel.update({ID: nodeId}, {"NextSiblingID": nextId}, cb);
  141. };
  142. })(preNodeId, preNodeNextId));
  143. }
  144. for (let nId of nodeIds) {
  145. functions.push((function(nodeId) {
  146. return function(cb) {
  147. TreeNodeModel.update({ID: nodeId}, {"isDeleted": true}, cb);
  148. };
  149. })(nId));
  150. }
  151. async.parallel(functions, function(err, results) {
  152. callback(req,res, err, "", results);
  153. });
  154. },
  155. createTreeRootNode: function(req, res){
  156. let params = JSON.parse(req.body.params),
  157. doc = params.doc;
  158. rttFacade.createNewTree(doc).then(function (rst) {
  159. if (rst) {
  160. //success
  161. callback(req,res, false, "", rst);
  162. } else {
  163. //failed
  164. callback(req,res, true, "创建失败!", null);
  165. }
  166. })
  167. },
  168. updateTreeRootNode: function(req, res){
  169. let params = JSON.parse(req.body.params),
  170. doc = params.doc;
  171. rttFacade.updateTree(doc.compilationId, doc.engineerId, doc.userId, doc).then(function (rst) {
  172. if (rst) {
  173. //success
  174. callback(req,res, false, "", rst);
  175. } else {
  176. //failed
  177. callback(req,res, true, "更新失败!", null);
  178. }
  179. })
  180. },
  181. updateTopNodeName: function (req, res) {
  182. let params = JSON.parse(req.body.params),
  183. compilationId = params.compilationId, engineerId = params.engineerId,
  184. userId = params.userId,
  185. nodeName = params.nodeName
  186. ;
  187. if (req.session.sessionUser && req.session.sessionUser.id) userId = req.session.sessionUser.id;
  188. let filter = {"compilationId": compilationId, "engineerId": engineerId, "userId": userId, "$or": [{"isDeleted": null}, {"isDeleted": false}]};
  189. let updateStatement = {"$set": {"name": nodeName}};
  190. rttFacade.updateTreeInDetail(filter, updateStatement).then(function (rst) {
  191. if (rst) {
  192. //success
  193. callback(req,res, false, "", rst);
  194. } else {
  195. //failed
  196. callback(req,res, true, "更新失败!", null);
  197. }
  198. });
  199. },
  200. updateSubLevelOneNode: function (req, res) {
  201. let params = JSON.parse(req.body.params),
  202. compilationId = params.compilationId, engineerId = params.engineerId,
  203. userId = params.userId,
  204. subNode = params.subNode
  205. ;
  206. if (req.session.sessionUser && req.session.sessionUser.id) userId = req.session.sessionUser.id;
  207. let filter = {"compilationId": compilationId, "engineerId": engineerId, "userId": userId, "items.ID": subNode.ID, "$or": [{"isDeleted": null}, {"isDeleted": false}]};
  208. let updateStatement = {$set: {"items.$": subNode}};
  209. rttFacade.updateTreeInDetail(filter, updateStatement).then(function (rst) {
  210. if (rst) {
  211. //success
  212. callback(req,res, false, "", rst);
  213. } else {
  214. //failed
  215. callback(req,res, true, "更新失败!", null);
  216. }
  217. });
  218. },
  219. removeTreeRootNode: function (req, res) {
  220. let params = JSON.parse(req.body.params),
  221. compilationId = params.compilationId,
  222. engineerId = params.engineerId,
  223. userId = params.userId,
  224. isPhysically = params.isPhysically
  225. ;
  226. if (req.session.sessionUser && req.session.sessionUser.id) userId = req.session.sessionUser.id;
  227. if (isPhysically) {
  228. rttFacade.removeTreePhycically(compilationId, engineerId, userId).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. } else {
  238. rttFacade.removeTree(compilationId, engineerId, userId).then(function (rst) {
  239. if (rst) {
  240. //success
  241. callback(req,res, false, "", rst);
  242. } else {
  243. //failed
  244. callback(req,res, true, "删除失败!", null);
  245. }
  246. })
  247. }
  248. },
  249. // createTplTreeNode: function(req, res){
  250. // let params = JSON.parse(req.body.params),
  251. // lastNodeId = params.lastNodeId,
  252. // nodeData = params.rawNodeData;
  253. // counter.counterDAO.getIDAfterCount(counter.moduleName.report, 1, function(err, result){
  254. // nodeData.ID = result.value.sequence_value;
  255. // let node = new TreeNodeModel(nodeData);
  256. // node.save(function (err, result) {
  257. // if (err) {
  258. // callback(req,res, "树节点错误!", "", null);
  259. // } else {
  260. // if (lastNodeId > 0) {
  261. // TreeNodeModel.update({ID: lastNodeId}, {"NextSiblingID": nodeData.ID}, function(err, rst){
  262. // if (err) {
  263. // callback(req,res, "树节点错误!", "", null);
  264. // } else {
  265. // callback(req,res, false, "", result);
  266. // }
  267. // });
  268. // } else callback(req,res, false, "", result);
  269. // }
  270. // });
  271. // });
  272. // },
  273. getNewNodeID: function(req, res) {
  274. let params = JSON.parse(req.body.params),
  275. scope = params.scope;
  276. counter.counterDAO.getIDAfterCount(counter.moduleName.report, scope, function(err, result){
  277. callback(req,res, false, "", result.sequence_value);
  278. });
  279. },
  280. createDftRptTpl: function(req, res) {
  281. let params = JSON.parse(req.body.params),
  282. treeNodeId = params.treeNodeId,
  283. rptDftTplId = params.rptDftTplId,
  284. rptName = params.rptName,
  285. grpKey = params.grpKey,
  286. compilationId = params.compilationId,
  287. engineerId = params.engineerId,
  288. userId = params.userId,
  289. subNode = params.subNode
  290. ;
  291. if (req.session.sessionUser && req.session.sessionUser.id) userId = req.session.sessionUser.id;
  292. let filter = {"ID": rptDftTplId};
  293. RptTplModel.findOne(filter, '-_id').exec().then(function(dftTplRst) {
  294. if (dftTplRst) {
  295. let _doc = dftTplRst["_doc"];
  296. _doc["ID"] = treeNodeId;
  297. _doc["GROUP_KEY"] = grpKey;
  298. _doc["ID_KEY"] = "";
  299. _doc[JV.NODE_MAIN_INFO][JV.NODE_MAIN_INFO_RPT_NAME] = rptName;
  300. let rptTpl = new RptTplModel(_doc);
  301. rptTpl.save(function (err, actTplRst) {
  302. if (err) {
  303. callback(req,res, "报表模板创建错误", "", null);
  304. } else {
  305. //TreeNodeModel.update();
  306. let filter = {"compilationId": compilationId, "engineerId": engineerId, "userId": userId, "items.ID": subNode.ID, "$or": [{"isDeleted": null}, {"isDeleted": false}]};
  307. let updateStatement = {$set: {"items.$": subNode}};
  308. rttFacade.updateTreeInDetail(filter, updateStatement).then(function (rst) {
  309. if (rst) {
  310. //success
  311. callback(req,res, false, "", actTplRst);
  312. } else {
  313. //failed
  314. callback(req,res, true, "更新失败!", null);
  315. }
  316. });
  317. }
  318. });
  319. } else {
  320. callback(req, res, 'Create report template failed!', null);
  321. }
  322. })
  323. },
  324. getRefRptTpl: function (req, res) {
  325. let params = JSON.parse(req.body.params),
  326. rptTplId = params.rptTplId;
  327. let filter = {"ID": rptTplId};
  328. RptTplModel.findOne(filter, '-_id').exec().then(function(rstTpl) {
  329. if (rstTpl) {
  330. callback(req,res, false, "", rstTpl);
  331. } else {
  332. callback(req, res, 'The report template was not found!', null);
  333. }
  334. })
  335. },
  336. updateRptTpl: function (req, res) {
  337. let params = JSON.parse(req.body.params),
  338. rptTpl = JSON.parse(params.rptTpl);
  339. let filter = {"ID": parseInt(rptTpl[JV.PROP_ID])};
  340. RptTplModel.update(filter, rptTpl, function (err, rst) {
  341. if (err) {
  342. callback(req, res, true, 'The report template was updated failed!', false);
  343. } else {
  344. callback(req, res, false, 'The report template was updated successfully!', true);
  345. }
  346. });
  347. },
  348. copyRptTpl: function (req, res) {
  349. let params = JSON.parse(req.body.params),
  350. orgRptTplId = params.orgRptTplId,
  351. newID = params.newRptTplId;
  352. let filter = {"ID": orgRptTplId};
  353. RptTplModel.findOne(filter, '-_id').exec().then(function(baseTplRst) {
  354. if (baseTplRst) {
  355. let _doc = baseTplRst["_doc"];
  356. _doc["ID"] = newID;
  357. if (_doc["GROUP_KEY"].indexOf("(Copy)") < 0) {
  358. _doc["GROUP_KEY"] = _doc["GROUP_KEY"] + "(Copy)";
  359. }
  360. let rptTpl = new RptTplModel(_doc);
  361. rptTpl.save(function (err, actTplRst) {
  362. if (err) {
  363. callback(req,res, "报表模板创建错误", "", null);
  364. } else {
  365. callback(req,res, false, "", newID);
  366. }
  367. });
  368. } else {
  369. callback(req, res, 'Create report template failed!', null);
  370. }
  371. });
  372. }
  373. };
  374. export default mExport;