rpt_tpl_controller.js 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333
  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. let 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. getDftTemplates(req, res) {
  49. let filter = {"userId": "-100", "$or": [{"isDeleted": null}, {"isDeleted": false} ]};
  50. TreeNodeModel.find(filter, '-_id', function(err, data){
  51. if (err) {
  52. callback(req,res, true,"", null);
  53. } else {
  54. callback(req,res,false,"", data);
  55. }
  56. });
  57. },
  58. getCompilationList(req, res) {
  59. let compilationModel = new CompilationModel();
  60. let compilationList = compilationModel.getCompilationList();
  61. if (compilationList) {
  62. compilationList.then(function (rst) {
  63. callback(req,res,false,"", rst);
  64. })
  65. } else {
  66. callback(req,res, true,"no result", null);
  67. }
  68. },
  69. getRptTplTree: function(req, res) {
  70. let params = JSON.parse(req.body.params),
  71. compilationId = params.compilationId,
  72. // userId = params.userId,
  73. engineerId = params.engineerId;
  74. let userId = req.session.sessionUser.id;
  75. let userIds = [];
  76. userIds.push(userId);
  77. if (userId != "-100") {
  78. userIds.push("-100");
  79. }
  80. if (!compilationId) {
  81. compilationId = req.session.sessionCompilation._id;
  82. }
  83. rttFacade.findTplTree(compilationId, engineerId, userIds).then(function(result) {
  84. if (result) {
  85. callback(req,res,false,"", result);
  86. } else {
  87. callback(req,res, true,"no result", null);
  88. }
  89. });
  90. },
  91. updateTreeNodes: function(req, res) {
  92. let params = JSON.parse(req.body.params),
  93. nodes = params.nodes;
  94. let functions = [];
  95. for (let node of nodes) {
  96. functions.push((function(doc) {
  97. return function(cb) {
  98. TreeNodeModel.update({ID: doc.ID}, doc, cb);
  99. };
  100. })(node));
  101. }
  102. async.parallel(functions, function(err, results) {
  103. callback(req,res, err, "", results);
  104. });
  105. },
  106. deleteRptTplNodes: function(req, res){
  107. let params = JSON.parse(req.body.params),
  108. nodeIds = params.nodeIds,
  109. preNodeId = params.preNodeId,
  110. preNodeNextId = params.preNodeNextId;
  111. let functions = [];
  112. if (preNodeId !== -1) {
  113. functions.push((function(nodeId, nextId) {
  114. return function(cb) {
  115. TreeNodeModel.update({ID: nodeId}, {"NextSiblingID": nextId}, cb);
  116. };
  117. })(preNodeId, preNodeNextId));
  118. }
  119. for (let nId of nodeIds) {
  120. functions.push((function(nodeId) {
  121. return function(cb) {
  122. TreeNodeModel.update({ID: nodeId}, {"isDeleted": true}, cb);
  123. };
  124. })(nId));
  125. }
  126. async.parallel(functions, function(err, results) {
  127. callback(req,res, err, "", results);
  128. });
  129. },
  130. createTreeRootNode: function(req, res){
  131. let params = JSON.parse(req.body.params),
  132. doc = params.doc;
  133. rttFacade.createNewTree(doc).then(function (rst) {
  134. if (rst) {
  135. //success
  136. callback(req,res, false, "", rst);
  137. } else {
  138. //failed
  139. callback(req,res, true, "创建失败!", null);
  140. }
  141. })
  142. },
  143. updateTreeRootNode: function(req, res){
  144. let params = JSON.parse(req.body.params),
  145. doc = params.doc;
  146. rttFacade.updateTree(doc.compilationId, doc.engineerId, doc.userId, doc).then(function (rst) {
  147. if (rst) {
  148. //success
  149. callback(req,res, false, "", rst);
  150. } else {
  151. //failed
  152. callback(req,res, true, "更新失败!", null);
  153. }
  154. })
  155. },
  156. updateTopNodeName: function (req, res) {
  157. let params = JSON.parse(req.body.params),
  158. compilationId = params.compilationId, engineerId = params.engineerId,
  159. // userId = params.userId,
  160. nodeName = params.nodeName
  161. ;
  162. let userId = req.session.sessionUser.id;
  163. let filter = {"compilationId": compilationId, "engineerId": engineerId, "userId": userId, "$or": [{"isDeleted": null}, {"isDeleted": false}]};
  164. let updateStatement = {"$set": {"name": nodeName}};
  165. rttFacade.updateTreeInDetail(filter, updateStatement).then(function (rst) {
  166. if (rst) {
  167. //success
  168. callback(req,res, false, "", rst);
  169. } else {
  170. //failed
  171. callback(req,res, true, "更新失败!", null);
  172. }
  173. });
  174. },
  175. updateSubLevelOneNode: function (req, res) {
  176. let params = JSON.parse(req.body.params),
  177. compilationId = params.compilationId, engineerId = params.engineerId,
  178. // userId = params.userId,
  179. subNode = params.subNode
  180. ;
  181. let userId = req.session.sessionUser.id;
  182. let filter = {"compilationId": compilationId, "engineerId": engineerId, "userId": userId, "items.ID": subNode.ID, "$or": [{"isDeleted": null}, {"isDeleted": false}]};
  183. let updateStatement = {$set: {"items.$": subNode}};
  184. rttFacade.updateTreeInDetail(filter, updateStatement).then(function (rst) {
  185. if (rst) {
  186. //success
  187. callback(req,res, false, "", rst);
  188. } else {
  189. //failed
  190. callback(req,res, true, "更新失败!", null);
  191. }
  192. });
  193. },
  194. removeTreeRootNode: function (req, res) {
  195. let params = JSON.parse(req.body.params),
  196. compilationId = params.compilationId,
  197. engineerId = params.engineerId,
  198. // userId = params.userId,
  199. isPhysically = params.isPhysically
  200. ;
  201. let userId = req.session.sessionUser.id;
  202. if (isPhysically) {
  203. rttFacade.removeTreePhycically(compilationId, engineerId, userId).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. } else {
  213. rttFacade.removeTree(compilationId, engineerId, userId).then(function (rst) {
  214. if (rst) {
  215. //success
  216. callback(req,res, false, "", rst);
  217. } else {
  218. //failed
  219. callback(req,res, true, "删除失败!", null);
  220. }
  221. })
  222. }
  223. },
  224. // createTplTreeNode: function(req, res){
  225. // let params = JSON.parse(req.body.params),
  226. // lastNodeId = params.lastNodeId,
  227. // nodeData = params.rawNodeData;
  228. // counter.counterDAO.getIDAfterCount(counter.moduleName.report, 1, function(err, result){
  229. // nodeData.ID = result.value.sequence_value;
  230. // let node = new TreeNodeModel(nodeData);
  231. // node.save(function (err, result) {
  232. // if (err) {
  233. // callback(req,res, "树节点错误!", "", null);
  234. // } else {
  235. // if (lastNodeId > 0) {
  236. // TreeNodeModel.update({ID: lastNodeId}, {"NextSiblingID": nodeData.ID}, function(err, rst){
  237. // if (err) {
  238. // callback(req,res, "树节点错误!", "", null);
  239. // } else {
  240. // callback(req,res, false, "", result);
  241. // }
  242. // });
  243. // } else callback(req,res, false, "", result);
  244. // }
  245. // });
  246. // });
  247. // },
  248. getNewNodeID: function(req, res) {
  249. let params = JSON.parse(req.body.params),
  250. scope = params.scope;
  251. counter.counterDAO.getIDAfterCount(counter.moduleName.report, scope, function(err, result){
  252. callback(req,res, false, "", result.sequence_value);
  253. });
  254. },
  255. createDftRptTpl: function(req, res) {
  256. let params = JSON.parse(req.body.params),
  257. treeNodeId = params.treeNodeId,
  258. rptDftTplId = params.rptDftTplId,
  259. rptName = params.rptName,
  260. grpKey = params.grpKey,
  261. compilationId = params.compilationId,
  262. engineerId = params.engineerId,
  263. // userId = params.userId,
  264. subNode = params.subNode
  265. ;
  266. let userId = req.session.sessionUser.id;
  267. let filter = {"ID": rptDftTplId};
  268. RptTplModel.findOne(filter, '-_id').exec().then(function(dftTplRst) {
  269. if (dftTplRst) {
  270. let _doc = dftTplRst["_doc"];
  271. _doc["ID"] = treeNodeId;
  272. _doc["GROUP_KEY"] = grpKey;
  273. _doc["ID_KEY"] = "";
  274. _doc[JV.NODE_MAIN_INFO][JV.NODE_MAIN_INFO_RPT_NAME] = rptName;
  275. let rptTpl = new RptTplModel(_doc);
  276. rptTpl.save(function (err, actTplRst) {
  277. if (err) {
  278. callback(req,res, "报表模板创建错误", "", null);
  279. } else {
  280. //TreeNodeModel.update();
  281. let filter = {"compilationId": compilationId, "engineerId": engineerId, "userId": userId, "items.ID": subNode.ID, "$or": [{"isDeleted": null}, {"isDeleted": false}]};
  282. let updateStatement = {$set: {"items.$": subNode}};
  283. rttFacade.updateTreeInDetail(filter, updateStatement).then(function (rst) {
  284. if (rst) {
  285. //success
  286. callback(req,res, false, "", actTplRst);
  287. } else {
  288. //failed
  289. callback(req,res, true, "更新失败!", null);
  290. }
  291. });
  292. }
  293. });
  294. } else {
  295. callback(req, res, 'Create report template failed!', null);
  296. }
  297. })
  298. },
  299. getRefRptTpl: function (req, res) {
  300. let params = JSON.parse(req.body.params),
  301. rptTplId = params.rptTplId;
  302. let filter = {"ID": rptTplId};
  303. RptTplModel.findOne(filter, '-_id').exec().then(function(rstTpl) {
  304. if (rstTpl) {
  305. callback(req,res, false, "", rstTpl);
  306. } else {
  307. callback(req, res, 'The report template was not found!', null);
  308. }
  309. })
  310. },
  311. updateRptTpl: function (req, res) {
  312. let params = JSON.parse(req.body.params),
  313. rptTpl = JSON.parse(params.rptTpl);
  314. let filter = {"ID": parseInt(rptTpl[JV.PROP_ID])};
  315. RptTplModel.update(filter, rptTpl, function (err, rst) {
  316. if (err) {
  317. callback(req, res, true, 'The report template was updated failed!', false);
  318. } else {
  319. callback(req, res, false, 'The report template was updated successfully!', true);
  320. }
  321. });
  322. }
  323. };
  324. export default mExport;