gljModel.js 17 KB

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