gljModel.js 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509
  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}, {deleted: false} ]},function(err,data){
  12. if(data.length) {
  13. callback(0, data);
  14. }
  15. else if(err) callback("获取工料机类型错误!",false)
  16. else {
  17. gljClassTemplateModel.find({'$or': [{isDeleted: null}, {isDeleted: false}, {deleted: 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(0, 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. async getGljItemsByRep(repositoryId,callback = null){
  67. /* let me = this;
  68. if (callback === null) {
  69. return gljModel.find({"repositoryId": repositoryId});
  70. } else {
  71. gljModel.find({"repositoryId": repositoryId},function(err,data){
  72. if(err) callback(true, "")
  73. else {
  74. me.sortToNumber(data);
  75. callback(false,data);
  76. }
  77. })
  78. }*/
  79. let me = this;
  80. let rst = [];
  81. //批量获取异步
  82. let functions = [];
  83. let count = await gljModel.find({repositoryId: repositoryId, $or: [{deleted: null}, {deleted: false}]}).count();
  84. let findCount = Math.ceil(count/500);
  85. for(let i = 0, len = findCount; i < len; i++){
  86. functions.push((function(flag) {
  87. return function (cb) {
  88. gljModel.find({repositoryId: repositoryId, deleted: null}, cb).skip(flag).sort({ID: 1}).limit(500);
  89. }
  90. })(i*500));
  91. }
  92. async.parallel(functions, function (err, results) {
  93. if(err){
  94. callback(err, null);
  95. }
  96. else{
  97. for(let stdGljs of results){
  98. rst = rst.concat(stdGljs);
  99. }
  100. me.sortToNumber(rst);
  101. callback(0, rst);
  102. }
  103. });
  104. }
  105. getGljItemByType (repositoryId, type, callback){
  106. let me = this;
  107. gljModel.find({"repositoryId": repositoryId, "gljType": type},function(err,data){
  108. if(err) callback(true, "");
  109. else {
  110. me.sortToNumber(data);
  111. callback(false, data);
  112. }
  113. })
  114. };
  115. getGljItem (repositoryId, code, callback){
  116. let me = this;
  117. gljModel.find({"repositoryId": repositoryId, "code": code},function(err,data){
  118. if(err) callback(true, "")
  119. else {
  120. me.sortToNumber(data);
  121. callback(false, data);
  122. }
  123. })
  124. };
  125. getGljItems (gljIds, callback){
  126. let me = this;
  127. gljModel.find({"ID": {"$in": gljIds}},function(err,data){
  128. if(err) callback(true, "")
  129. else {
  130. me.sortToNumber(data);
  131. callback(false, data);
  132. }
  133. })
  134. };
  135. getGljItemsByCode (repositoryId, codes, callback){
  136. let me = this;
  137. gljModel.find({"repositoryId": repositoryId,"code": {"$in": codes}},function(err,data){
  138. if(err) callback(true, "");
  139. else {
  140. me.sortToNumber(data);
  141. callback(false, data);
  142. }
  143. })
  144. };
  145. updateComponent(libId, oprtor, updateArr, callback){
  146. let parallelFucs = [];
  147. for(let i = 0; i < updateArr.length; i++){
  148. parallelFucs.push((function(obj){
  149. return function (cb) {
  150. if(typeof obj.component === 'undefined'){
  151. obj.component = [];
  152. }
  153. gljModel.update({repositoryId: libId, ID: obj.ID}, obj, function (err, result) {
  154. if(err){
  155. cb(err);
  156. }
  157. else{
  158. cb(null, obj);
  159. }
  160. })
  161. }
  162. })(updateArr[i]));
  163. }
  164. parallelFucs.push((function () {
  165. return function (cb) {
  166. GljDao.updateOprArr({ID: libId}, oprtor, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
  167. if(err){
  168. cb(err);
  169. }
  170. else{
  171. cb(null);
  172. }
  173. })
  174. }
  175. })());
  176. async.parallel(parallelFucs, function (err, result) {
  177. if(err){
  178. callback(err, '更新组成物错误!', null);
  179. }
  180. else{
  181. callback(null, '成功!', result);
  182. }
  183. });
  184. }
  185. mixUpdateGljItems (repId, lastOpr, updateItems, addItems, rIds, callback) {
  186. if (updateItems.length == 0 && rIds.length == 0) {
  187. GljDao.addGljItems(repId, lastOpr, addItems, callback);
  188. }
  189. else if(rIds.length > 0 && updateItems.length > 0){
  190. async.parallel([
  191. function (cb) {
  192. GljDao.removeGljItems(repId, lastOpr, rIds, cb);
  193. },
  194. function (cb) {
  195. GljDao.updateGljItems(repId, lastOpr, updateItems, cb);
  196. }
  197. ], function (err) {
  198. if(err){
  199. callback(true, "Fail to update and delete", false)
  200. }
  201. else{
  202. callback(false, "Save successfully", false);
  203. }
  204. })
  205. }
  206. else if (rIds.length > 0 && updateItems.length === 0) {
  207. GljDao.removeGljItems(repId, lastOpr, rIds, callback);
  208. }
  209. else if(updateItems.length > 0 || addItems.length > 0){
  210. GljDao.updateGljItems(repId, lastOpr, updateItems, function(err, results){
  211. if (err) {
  212. callback(true, "Fail to update", false);
  213. } else {
  214. if (addItems && addItems.length > 0) {
  215. GljDao.addGljItems(repId, lastOpr, addItems, callback);
  216. } else {
  217. callback(false, "Save successfully", results);
  218. }
  219. }
  220. });
  221. }
  222. }
  223. /*mixUpdateGljItems (repId, lastOpr, updateItems, addItems, rIds, callback) {
  224. if (updateItems.length == 0 && rIds.length == 0) {
  225. GljDao.addGljItems(repId, lastOpr, addItems, callback);
  226. } else if (rIds.length > 0) {
  227. GljDao.removeGljItems(repId, lastOpr, rIds, function(err, message, docs) {
  228. });
  229. }else{
  230. GljDao.updateGljItems(repId, lastOpr, updateItems, function(err, results){
  231. if (err) {
  232. callback(true, "Fail to update", false);
  233. } else {
  234. if (addItems && addItems.length > 0) {
  235. GljDao.addGljItems(repId, lastOpr, addItems, callback);
  236. } else {
  237. callback(false, "Save successfully", results);
  238. }
  239. }
  240. });
  241. }
  242. };*/
  243. static removeGljItems (repId, lastOpr, rIds, callback) {
  244. if (rIds && rIds.length > 0) {
  245. gljModel.collection.remove({ID: {$in: rIds}}, null, function(err, docs){
  246. if (err) {
  247. callback(true, "Fail to remove", 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, "Remove successfully", docs);
  255. }
  256. });
  257. }
  258. })
  259. } else {
  260. callback(false, "No records were deleted!", null);
  261. }
  262. }
  263. static addGljItems (repId, lastOpr, items, callback) {
  264. if (items && items.length > 0) {
  265. counter.counterDAO.getIDAfterCount(counter.moduleName.GLJ, items.length, function(err, result){
  266. var maxId = result.value.sequence_value;
  267. var arr = [];
  268. for (var i = 0; i < items.length; i++) {
  269. var obj = new gljModel(items[i]);
  270. obj.ID = (maxId - (items.length - 1) + i);
  271. obj.repositoryId = repId;
  272. arr.push(obj);
  273. }
  274. gljModel.collection.insert(arr, null, function(err, docs){
  275. if (err) {
  276. callback(true, "Fail to add", false);
  277. } else {
  278. GljDao.updateOprArr({ID: repId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
  279. if(err){
  280. callback(true, "Fail to update Operator", false);
  281. }
  282. else{
  283. callback(false, "Add successfully", docs);
  284. }
  285. });
  286. }
  287. })
  288. });
  289. } else {
  290. callback(true, "No source", false);
  291. }
  292. }
  293. static updateGljItems(repId, lastOpr, items, callback) {
  294. var functions = [];
  295. for (var i=0; i < items.length; i++) {
  296. functions.push((function(doc) {
  297. return function(cb) {
  298. var filter = {};
  299. if (doc.ID) {
  300. filter.ID = doc.ID;
  301. } else {
  302. filter.repositoryId = repId;
  303. filter.code = doc.code;
  304. }
  305. gljModel.update(filter, doc, cb);
  306. };
  307. })(items[i]));
  308. }
  309. functions.push((function () {
  310. return function (cb) {
  311. GljDao.updateOprArr({ID: repId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
  312. if(err){
  313. cb(err);
  314. }
  315. else{
  316. cb(null);
  317. }
  318. })
  319. }
  320. })());
  321. async.parallel(functions, function(err, results) {
  322. callback(err, results);
  323. });
  324. }
  325. getRationGljIds(rationLibs, callback){
  326. }
  327. updateNodes (updateData, lastOpr, callback) {
  328. let functions = [];
  329. for (let i = 0, len = updateData.length; i < len; i++) {
  330. functions.push((function(doc) {
  331. return function(cb) {
  332. if(doc.updateType === 'update'){
  333. gljClassModel.update({repositoryId: doc.updateData.repositoryId, ID: doc.updateData.ID}, doc.updateData, function (err) {
  334. if(err){
  335. cb(err);
  336. }
  337. else {
  338. cb(null);
  339. }
  340. });
  341. }
  342. else if(doc.updateType === 'new'){
  343. gljClassModel.create(doc.updateData, function (err) {
  344. if(err){
  345. cb(err);
  346. }
  347. else {
  348. cb(null);
  349. }
  350. });
  351. }
  352. };
  353. })(updateData[i]));
  354. }
  355. if(updateData.length > 0){
  356. functions.push((function () {
  357. return function (cb) {
  358. GljDao.updateOprArr({ID: updateData[0].updateData.rationRepId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
  359. if(err){
  360. cb(err);
  361. }
  362. else{
  363. cb(null);
  364. }
  365. })
  366. }
  367. })());
  368. }
  369. async.parallel(functions, function(err, results) {
  370. if(!err){
  371. err = 0;
  372. }
  373. callback(err, results);
  374. });
  375. }
  376. /* updateNodes (repId, lastOpr, nodes, callback) {
  377. var functions = [];
  378. for (var i=0; i < nodes.length; i++) {
  379. functions.push((function(doc) {
  380. return function(cb) {
  381. gljClassModel.update({ID: doc.ID}, doc, cb);
  382. };
  383. })(nodes[i]));
  384. }
  385. functions.push((function () {
  386. return function (cb) {
  387. GljDao.updateOprArr({ID: repId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
  388. if(err){
  389. cb(err);
  390. }
  391. else{
  392. cb(null);
  393. }
  394. })
  395. }
  396. })());
  397. async.parallel(functions, function(err, results) {
  398. callback(err, results);
  399. });
  400. }*/
  401. removeNodes (repId, lastOpr, nodeIds, preNodeId, preNodeNextId, callback){
  402. var functions = [];
  403. if (preNodeId != -1) {
  404. functions.push((function(nodeId, nextId) {
  405. return function(cb) {
  406. gljClassModel.update({ID: nodeId}, {"NextSiblingID": nextId}, cb);
  407. };
  408. })(preNodeId, preNodeNextId));
  409. }
  410. for (var i=0; i < nodeIds.length; i++) {
  411. functions.push((function(nodeId) {
  412. return function(cb) {
  413. gljClassModel.update({ID: nodeId}, {"isDeleted": true}, cb);
  414. };
  415. })(nodeIds[i]));
  416. }
  417. functions.push((function () {
  418. return function (cb) {
  419. GljDao.updateOprArr({ID: repId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
  420. if(err){
  421. cb(err);
  422. }
  423. else{
  424. cb(null);
  425. }
  426. })
  427. }
  428. })());
  429. async.parallel(functions, function(err, results) {
  430. callback(err, results);
  431. });
  432. }
  433. createNewNode(repId, lastOpr, lastNodeId, nodeData, callback) {
  434. return counter.counterDAO.getIDAfterCount(counter.moduleName.GLJ, 1, function(err, result){
  435. nodeData.repositoryId = repId;
  436. nodeData.ID = result.value.sequence_value;
  437. var node = new gljModel(nodeData);
  438. async.parallel([
  439. function (cb) {
  440. node.save(function (err, result) {
  441. if (err) {
  442. cb("章节树ID错误!", false);
  443. } else {
  444. if (lastNodeId > 0) {
  445. gljClassModel.update({ID: lastNodeId}, {"NextSiblingID": nodeData.ID}, function(err, rst){
  446. if (err) {
  447. cb("章节树ID错误!", false);
  448. } else {
  449. cb(false, result);
  450. }
  451. });
  452. } else cb(false, result);
  453. }
  454. });
  455. },
  456. function (cb) {
  457. GljDao.updateOprArr({ID: repId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
  458. if(err){
  459. cb(err);
  460. }
  461. else{
  462. cb(null);
  463. }
  464. })
  465. }
  466. ], function (err, result) {
  467. if(err){
  468. callback(true, "章节树错误!", false);
  469. }
  470. else{
  471. callback(false, '', result[0]);
  472. }
  473. })
  474. });
  475. }
  476. getGljItemsOccupied(repId, occupation, callback){
  477. gljModel.find({repositoryId: repId}, occupation, function (err, result) {
  478. if(err) callback(true, 'fail', null);
  479. else callback(false, 'sc', result);
  480. });
  481. }
  482. async getGljItemsByRepId(repositoryId){
  483. return gljModel.find({"repositoryId": repositoryId});
  484. }
  485. }
  486. export default GljDao;