gljModel.js 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425
  1. /**
  2. * Created by Zhong on 2017/8/11.
  3. */
  4. import {gljMapModel, gljModel, gljClassModel, gljClassTemplateModel} from "./schemas";
  5. import {OprDao} from "./gljMapModel";
  6. import moment from "moment";
  7. import counter from "../../../public/counter/counter";
  8. import async from "async";
  9. class GljDao extends OprDao{
  10. getGljTypes (gljLibId, callback){
  11. gljClassModel.find({"repositoryId": gljLibId, "$or": [{"isDeleted": null}, {"isDeleted": false} ]},function(err,data){
  12. if(data.length) {
  13. callback(false,data);
  14. }
  15. else if(err) callback("获取工料机类型错误!",false)
  16. else {
  17. gljClassTemplateModel.find({'$or': [{isDeleted: null}, {isDeleted: false}]}, function (err, datas) {
  18. if(err){
  19. callback("获取工料机类型错误!", false);
  20. }
  21. else{
  22. let rst = [];
  23. async.each(datas, function (data, cb) {
  24. let newClassObj = {};
  25. newClassObj.ID = data.ID;
  26. newClassObj.ParentID = data.ParentID;
  27. newClassObj.NextSiblingID = data.NextSiblingID;
  28. newClassObj.Name = data.Name;
  29. newClassObj.repositoryId = gljLibId;
  30. newClassObj.deleted = false;
  31. gljClassModel.create(newClassObj, function(err){
  32. if(err)cb(err);
  33. else{
  34. rst.push(newClassObj);
  35. cb(null);
  36. }
  37. });
  38. }, function (err) {
  39. if(err) callback("新增工料机类型错误!", false);
  40. else callback(false, rst);
  41. });
  42. }
  43. });
  44. }
  45. })
  46. }
  47. _exist(data, attr){
  48. return data && data[attr] !== 'undefined' && data[attr];
  49. }
  50. sortToNumber(datas){
  51. for(let i = 0, len = datas.length; i < len; i++){
  52. let data = datas[i]._doc;
  53. if(this._exist(data, 'basePrice')){
  54. data['basePrice'] = parseFloat(data['basePrice']);
  55. }
  56. if(this._exist(data, 'component')){
  57. for(let j = 0, jLen = data['component'].length; j < jLen; j++){
  58. let comGljObj = data['component'][j]._doc;
  59. if(this._exist(comGljObj, 'consumeAmt')){
  60. comGljObj['consumeAmt'] = parseFloat(comGljObj['consumeAmt']);
  61. }
  62. }
  63. }
  64. }
  65. }
  66. getGljItemsByRep(repositoryId,callback){
  67. let me = this;
  68. gljModel.find({"repositoryId": repositoryId},function(err,data){
  69. if(err) callback(true, "")
  70. else {
  71. me.sortToNumber(data);
  72. callback(false,data);
  73. }
  74. })
  75. }
  76. getGljItemByType (repositoryId, type, callback){
  77. let me = this;
  78. gljModel.find({"repositoryId": repositoryId, "gljType": type},function(err,data){
  79. if(err) callback(true, "");
  80. else {
  81. me.sortToNumber(data);
  82. callback(false, data);
  83. }
  84. })
  85. };
  86. getGljItem (repositoryId, code, callback){
  87. let me = this;
  88. gljModel.find({"repositoryId": repositoryId, "code": code},function(err,data){
  89. if(err) callback(true, "")
  90. else {
  91. me.sortToNumber(data);
  92. callback(false, data);
  93. }
  94. })
  95. };
  96. getGljItems (gljIds, callback){
  97. let me = this;
  98. gljModel.find({"ID": {"$in": gljIds}},function(err,data){
  99. if(err) callback(true, "")
  100. else {
  101. me.sortToNumber(data);
  102. callback(false, data);
  103. }
  104. })
  105. };
  106. getGljItemsByCode (repositoryId, codes, callback){
  107. let me = this;
  108. gljModel.find({"repositoryId": repositoryId,"code": {"$in": codes}},function(err,data){
  109. if(err) callback(true, "");
  110. else {
  111. me.sortToNumber(data);
  112. callback(false, data);
  113. }
  114. })
  115. };
  116. updateComponent(libId, oprtor, updateArr, callback){
  117. let parallelFucs = [];
  118. for(let i = 0; i < updateArr.length; i++){
  119. parallelFucs.push((function(obj){
  120. return function (cb) {
  121. if(typeof obj.component === 'undefined'){
  122. obj.component = [];
  123. }
  124. gljModel.update({repositoryId: libId, ID: obj.ID}, obj, function (err, result) {
  125. if(err){
  126. cb(err);
  127. }
  128. else{
  129. cb(null, obj);
  130. }
  131. })
  132. }
  133. })(updateArr[i]));
  134. }
  135. parallelFucs.push((function () {
  136. return function (cb) {
  137. GljDao.updateOprArr({ID: libId}, oprtor, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
  138. if(err){
  139. cb(err);
  140. }
  141. else{
  142. cb(null);
  143. }
  144. })
  145. }
  146. })());
  147. async.parallel(parallelFucs, function (err, result) {
  148. if(err){
  149. callback(err, '更新组成物错误!', null);
  150. }
  151. else{
  152. callback(null, '成功!', result);
  153. }
  154. });
  155. }
  156. mixUpdateGljItems (repId, lastOpr, updateItems, addItems, rIds, callback) {
  157. if (updateItems.length == 0 && rIds.length == 0) {
  158. GljDao.addGljItems(repId, lastOpr, addItems, callback);
  159. }
  160. else if(rIds.length > 0 && updateItems.length > 0){
  161. async.parallel([
  162. function (cb) {
  163. GljDao.removeGljItems(repId, lastOpr, rIds, cb);
  164. },
  165. function (cb) {
  166. GljDao.updateGljItems(repId, lastOpr, updateItems, cb);
  167. }
  168. ], function (err) {
  169. if(err){
  170. callback(true, "Fail to update and delete", false)
  171. }
  172. else{
  173. callback(false, "Save successfully", false);
  174. }
  175. })
  176. }
  177. else if (rIds.length > 0 && updateItems.length === 0) {
  178. GljDao.removeGljItems(repId, lastOpr, rIds, callback);
  179. }
  180. else if(updateItems.length > 0 || addItems.length > 0){
  181. GljDao.updateGljItems(repId, lastOpr, updateItems, function(err, results){
  182. if (err) {
  183. callback(true, "Fail to update", false);
  184. } else {
  185. if (addItems && addItems.length > 0) {
  186. GljDao.addGljItems(repId, lastOpr, addItems, callback);
  187. } else {
  188. callback(false, "Save successfully", results);
  189. }
  190. }
  191. });
  192. }
  193. }
  194. /*mixUpdateGljItems (repId, lastOpr, updateItems, addItems, rIds, callback) {
  195. if (updateItems.length == 0 && rIds.length == 0) {
  196. GljDao.addGljItems(repId, lastOpr, addItems, callback);
  197. } else if (rIds.length > 0) {
  198. GljDao.removeGljItems(repId, lastOpr, rIds, function(err, message, docs) {
  199. });
  200. }else{
  201. GljDao.updateGljItems(repId, lastOpr, updateItems, function(err, results){
  202. if (err) {
  203. callback(true, "Fail to update", false);
  204. } else {
  205. if (addItems && addItems.length > 0) {
  206. GljDao.addGljItems(repId, lastOpr, addItems, callback);
  207. } else {
  208. callback(false, "Save successfully", results);
  209. }
  210. }
  211. });
  212. }
  213. };*/
  214. static removeGljItems (repId, lastOpr, rIds, callback) {
  215. if (rIds && rIds.length > 0) {
  216. gljModel.collection.remove({ID: {$in: rIds}}, null, function(err, docs){
  217. if (err) {
  218. callback(true, "Fail to remove", false);
  219. } else {
  220. GljDao.updateOprArr({ID: repId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
  221. if(err){
  222. callback(true, "Fail to update operator", false);
  223. }
  224. else{
  225. callback(false, "Remove successfully", docs);
  226. }
  227. });
  228. }
  229. })
  230. } else {
  231. callback(false, "No records were deleted!", null);
  232. }
  233. }
  234. static addGljItems (repId, lastOpr, items, callback) {
  235. if (items && items.length > 0) {
  236. counter.counterDAO.getIDAfterCount(counter.moduleName.GLJ, items.length, function(err, result){
  237. var maxId = result.value.sequence_value;
  238. var arr = [];
  239. for (var i = 0; i < items.length; i++) {
  240. var obj = new gljModel(items[i]);
  241. obj.ID = (maxId - (items.length - 1) + i);
  242. obj.repositoryId = repId;
  243. arr.push(obj);
  244. }
  245. gljModel.collection.insert(arr, null, function(err, docs){
  246. if (err) {
  247. callback(true, "Fail to add", false);
  248. } else {
  249. GljDao.updateOprArr({ID: repId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
  250. if(err){
  251. callback(true, "Fail to update Operator", false);
  252. }
  253. else{
  254. callback(false, "Add successfully", docs);
  255. }
  256. });
  257. }
  258. })
  259. });
  260. } else {
  261. callback(true, "No source", false);
  262. }
  263. }
  264. static updateGljItems(repId, lastOpr, items, callback) {
  265. var functions = [];
  266. for (var i=0; i < items.length; i++) {
  267. functions.push((function(doc) {
  268. return function(cb) {
  269. var filter = {};
  270. if (doc.ID) {
  271. filter.ID = doc.ID;
  272. } else {
  273. filter.repositoryId = repId;
  274. filter.code = doc.code;
  275. }
  276. gljModel.update(filter, doc, cb);
  277. };
  278. })(items[i]));
  279. }
  280. functions.push((function () {
  281. return function (cb) {
  282. GljDao.updateOprArr({ID: repId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
  283. if(err){
  284. cb(err);
  285. }
  286. else{
  287. cb(null);
  288. }
  289. })
  290. }
  291. })());
  292. async.parallel(functions, function(err, results) {
  293. callback(err, results);
  294. });
  295. }
  296. getRationGljIds(rationLibs, callback){
  297. }
  298. updateNodes (repId, lastOpr, nodes, callback) {
  299. var functions = [];
  300. for (var i=0; i < nodes.length; i++) {
  301. functions.push((function(doc) {
  302. return function(cb) {
  303. gljClassModel.update({ID: doc.ID}, doc, cb);
  304. };
  305. })(nodes[i]));
  306. }
  307. functions.push((function () {
  308. return function (cb) {
  309. GljDao.updateOprArr({ID: repId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
  310. if(err){
  311. cb(err);
  312. }
  313. else{
  314. cb(null);
  315. }
  316. })
  317. }
  318. })());
  319. async.parallel(functions, function(err, results) {
  320. callback(err, results);
  321. });
  322. }
  323. removeNodes (repId, lastOpr, nodeIds, preNodeId, preNodeNextId, callback){
  324. var functions = [];
  325. if (preNodeId != -1) {
  326. functions.push((function(nodeId, nextId) {
  327. return function(cb) {
  328. gljClassModel.update({ID: nodeId}, {"NextSiblingID": nextId}, cb);
  329. };
  330. })(preNodeId, preNodeNextId));
  331. }
  332. for (var i=0; i < nodeIds.length; i++) {
  333. functions.push((function(nodeId) {
  334. return function(cb) {
  335. gljClassModel.update({ID: nodeId}, {"isDeleted": true}, cb);
  336. };
  337. })(nodeIds[i]));
  338. }
  339. functions.push((function () {
  340. return function (cb) {
  341. GljDao.updateOprArr({ID: repId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
  342. if(err){
  343. cb(err);
  344. }
  345. else{
  346. cb(null);
  347. }
  348. })
  349. }
  350. })());
  351. async.parallel(functions, function(err, results) {
  352. callback(err, results);
  353. });
  354. }
  355. createNewNode(repId, lastOpr, lastNodeId, nodeData, callback) {
  356. return counter.counterDAO.getIDAfterCount(counter.moduleName.GLJ, 1, function(err, result){
  357. nodeData.repositoryId = repId;
  358. nodeData.ID = result.value.sequence_value;
  359. var node = new gljModel(nodeData);
  360. async.parallel([
  361. function (cb) {
  362. node.save(function (err, result) {
  363. if (err) {
  364. cb("章节树ID错误!", false);
  365. } else {
  366. if (lastNodeId > 0) {
  367. gljClassModel.update({ID: lastNodeId}, {"NextSiblingID": nodeData.ID}, function(err, rst){
  368. if (err) {
  369. cb("章节树ID错误!", false);
  370. } else {
  371. cb(false, result);
  372. }
  373. });
  374. } else cb(false, result);
  375. }
  376. });
  377. },
  378. function (cb) {
  379. GljDao.updateOprArr({ID: repId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
  380. if(err){
  381. cb(err);
  382. }
  383. else{
  384. cb(null);
  385. }
  386. })
  387. }
  388. ], function (err, result) {
  389. if(err){
  390. callback(true, "章节树错误!", false);
  391. }
  392. else{
  393. callback(false, '', result[0]);
  394. }
  395. })
  396. });
  397. }
  398. getGljItemsOccupied(repId, occupation, callback){
  399. gljModel.find({repositoryId: repId}, occupation, function (err, result) {
  400. if(err) callback(true, 'fail', null);
  401. else callback(false, 'sc', result);
  402. });
  403. }
  404. }
  405. export default GljDao;