rpt_tpl_controller.js 6.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177
  1. /**
  2. * Created by Tony on 2017/6/1.
  3. */
  4. let mongoose = require('mongoose');
  5. let async = require("async");
  6. let counter = require('../../../public/counter/counter');
  7. let RptTplModel = mongoose.model('rpt_templates');
  8. let TreeNodeModel = mongoose.model('rpt_tpl_tree');
  9. let rptTplDef = require("../../../public/rpt_tpl_def").getUtil();
  10. let stringUtil = require("../../../public/stringUtil");
  11. let JV = require('../rpt_component/jpc_value_define');
  12. //let test_glj_type_util = require("../../../public/cache/std_glj_type_util");
  13. //统一回调函数
  14. let callback = function(req, res, err, message, data){
  15. res.json({error: err, message: message, data: data});
  16. }
  17. module.exports = {
  18. getDftTemplates(req, res) {
  19. let filter = {"userId": -100, "$or": [{"isDeleted": null}, {"isDeleted": false} ]};
  20. TreeNodeModel.find(filter, '-_id', function(err, data){
  21. if (err) {
  22. callback(req,res, true,"", null);
  23. } else {
  24. callback(req,res,false,"", data);
  25. }
  26. });
  27. },
  28. getRptTplTree: function(req, res) {
  29. let params = JSON.parse(req.body.params),
  30. grpType = params.grpType,
  31. userId = params.userId,
  32. tplType = params.tplType;
  33. let filter = {"grpType": grpType, "$or": [{"isDeleted": null}, {"isDeleted": false} ]};
  34. if (userId) {
  35. filter.userId = userId;
  36. }
  37. if ((tplType && tplType !== rptTplDef.TplType.ALL)) {
  38. filter.tplType = tplType;
  39. }
  40. TreeNodeModel.find(filter, '-_id', function(err, data){
  41. if (err) {
  42. callback(req,res, true,"", null);
  43. } else {
  44. callback(req,res,false,"", data);
  45. }
  46. });
  47. // let obj = test_glj_type_util.getStdGljTypeCacheObj();
  48. // console.log(obj.toArray());
  49. // console.log(obj.getItemById(1));
  50. },
  51. updateTreeNodes: function(req, res) {
  52. let params = JSON.parse(req.body.params),
  53. nodes = params.nodes;
  54. let functions = [];
  55. for (let node of nodes) {
  56. functions.push((function(doc) {
  57. return function(cb) {
  58. TreeNodeModel.update({ID: doc.ID}, doc, cb);
  59. };
  60. })(node));
  61. }
  62. async.parallel(functions, function(err, results) {
  63. callback(req,res, err, "", results);
  64. });
  65. },
  66. deleteRptTplNodes: function(req, res){
  67. let params = JSON.parse(req.body.params),
  68. nodeIds = params.nodeIds,
  69. preNodeId = params.preNodeId,
  70. preNodeNextId = params.preNodeNextId;
  71. let functions = [];
  72. if (preNodeId !== -1) {
  73. functions.push((function(nodeId, nextId) {
  74. return function(cb) {
  75. TreeNodeModel.update({ID: nodeId}, {"NextSiblingID": nextId}, cb);
  76. };
  77. })(preNodeId, preNodeNextId));
  78. }
  79. for (let nId of nodeIds) {
  80. functions.push((function(nodeId) {
  81. return function(cb) {
  82. TreeNodeModel.update({ID: nodeId}, {"isDeleted": true}, cb);
  83. };
  84. })(nId));
  85. }
  86. async.parallel(functions, function(err, results) {
  87. callback(req,res, err, "", results);
  88. });
  89. },
  90. createTplTreeNode: function(req, res){
  91. let params = JSON.parse(req.body.params),
  92. lastNodeId = params.lastNodeId,
  93. nodeData = params.rawNodeData;
  94. counter.counterDAO.getIDAfterCount(counter.moduleName.report, 1, function(err, result){
  95. nodeData.ID = result.value.sequence_value;
  96. let node = new TreeNodeModel(nodeData);
  97. node.save(function (err, result) {
  98. if (err) {
  99. callback(req,res, "树节点错误!", "", null);
  100. } else {
  101. if (lastNodeId > 0) {
  102. TreeNodeModel.update({ID: lastNodeId}, {"NextSiblingID": nodeData.ID}, function(err, rst){
  103. if (err) {
  104. callback(req,res, "树节点错误!", "", null);
  105. } else {
  106. callback(req,res, false, "", result);
  107. }
  108. });
  109. } else callback(req,res, false, "", result);
  110. }
  111. });
  112. });
  113. },
  114. createDftRptTpl: function(req, res) {
  115. let params = JSON.parse(req.body.params),
  116. treeNodeId = params.treeNodeId,
  117. //grpChars = stringUtil.getPinYinFullChars(params.grpChars),
  118. rptDftTplId = params.rptDftTplId;
  119. let filter = {"ID": rptDftTplId};
  120. RptTplModel.findOne(filter, '-_id').exec().then(function(dftTplRst) {
  121. if (dftTplRst) {
  122. let _doc = dftTplRst["_doc"];
  123. _doc["ID"] = treeNodeId;
  124. _doc["GROUP_KEY"] = "";
  125. _doc["ID_KEY"] = "";
  126. let rptTpl = new RptTplModel(_doc);
  127. rptTpl.save(function (err, actTplRst) {
  128. if (err) {
  129. callback(req,res, "报表模板创建错误", "", null);
  130. } else {
  131. //TreeNodeModel.update();
  132. TreeNodeModel.update({ID: treeNodeId}, {"refId": treeNodeId}, function(err, rst){
  133. if (err) {
  134. callback(req,res, "报表模板创建错误", "", null);
  135. } else {
  136. callback(req,res, false, "", actTplRst);
  137. }
  138. });
  139. }
  140. });
  141. } else {
  142. callback(req, res, 'Create report template failed!', null);
  143. }
  144. })
  145. },
  146. getRefRptTpl: function (req, res) {
  147. let params = JSON.parse(req.body.params),
  148. rptTplId = params.rptTplId;
  149. let filter = {"ID": rptTplId};
  150. RptTplModel.findOne(filter, '-_id').exec().then(function(rstTpl) {
  151. if (rstTpl) {
  152. callback(req,res, false, "", rstTpl);
  153. } else {
  154. callback(req, res, 'The report template was not found!', null);
  155. }
  156. })
  157. },
  158. updateRptTpl: function (req, res) {
  159. let params = JSON.parse(req.body.params),
  160. rptTpl = JSON.parse(params.rptTpl);
  161. let filter = {"ID": parseInt(rptTpl[JV.PROP_ID])};
  162. RptTplModel.update(filter, rptTpl, function (err, rst) {
  163. if (err) {
  164. callback(req, res, true, 'The report template was updated failed!', false);
  165. } else {
  166. callback(req, res, false, 'The report template was updated successfully!', true);
  167. }
  168. });
  169. }
  170. }