coe.js 5.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179
  1. /**
  2. * Created by CSL on 2017/5/3.
  3. * 系数表。
  4. */
  5. //modiyied by zhong on 2017/9/21
  6. let counter = require('../../../public/counter/counter');
  7. import {coeListModel} from './schemas';
  8. import async from 'async';
  9. let coeListDAO = function(){};
  10. coeListDAO.prototype.getCoe = function (data, callback) {
  11. coeListModel.findOne({
  12. "libID": data.libID,
  13. "ID": data.ID,
  14. "$or": [{"isDeleted": null}, {"isDeleted": false}]
  15. },
  16. function (err, doc) {
  17. if (err) callback("获取系数明细错误!", null)
  18. else callback(null, doc);
  19. })
  20. };
  21. coeListDAO.prototype.getCoeItemsByIDs = function (data, callback) {
  22. coeListModel.find({
  23. "libID": data.libID,
  24. "ID": {"$in":data.coeIDs}
  25. }, ["libID","ID","serialNo","name","content","-_id"],
  26. function (err, doc) {
  27. if (err) callback("批量获取系数明细错误!", null)
  28. else callback(null, doc);
  29. })
  30. };
  31. coeListDAO.prototype.getCoeItemsByNos = function (data, callback) {
  32. coeListModel.find({
  33. "libID": data.libID,
  34. "serialNo": {"$in":data.coeNos}
  35. }, ["libID","ID","serialNo","name","content","-_id"],
  36. function (err, doc) {
  37. if (err) callback("批量获取系数明细错误!", null)
  38. else callback(null, doc);
  39. })
  40. };
  41. coeListDAO.prototype.getCoesByLibID = function (libID, callback) {
  42. coeListModel.find({ "libID": libID },
  43. function (err, doc) {
  44. if (err) callback("获取定额库系数表错误", null)
  45. else callback(null, doc);
  46. })
  47. };
  48. coeListDAO.prototype.saveToCoeList = function(data, callback) {
  49. let me = this;
  50. /*if (data.addArr.length > 0) {
  51. me.addItems(data.addArr, callback);
  52. }
  53. if (data.deleteArr.length > 0) {
  54. me.deleteItems(data.deleteArr, callback);
  55. }
  56. if (data.updateArr.length > 0) {
  57. me.updateItems(data.updateArr, callback);
  58. }*/
  59. if (data.addArr.length > 0 && data.updateArr.length > 0) {
  60. async.parallel([
  61. function (cb) {
  62. me.addItems(data.addArr, cb);
  63. },
  64. function (cb) {
  65. me.updateItems(data.updateArr, cb);
  66. }
  67. ], function (err, result) {
  68. callback(err, 'mixed', result);
  69. });
  70. }
  71. else if(data.addArr.length > 0){
  72. me.addItems(data.addArr, callback);
  73. }
  74. else if (data.updateArr.length > 0) {
  75. me.updateItems(data.updateArr, callback);
  76. }
  77. else if (data.deleteArr.length > 0) {
  78. me.deleteItems(data.deleteArr, callback);
  79. }
  80. };
  81. coeListDAO.prototype.addItems = function(addArr, callback) {
  82. if (addArr && addArr.length > 0) {
  83. counter.counterDAO.getIDAfterCount(counter.moduleName.coeList, addArr.length, function(err, result){
  84. let maxId = result.value.sequence_value;
  85. let functions = [];
  86. for (let i = 0; i < addArr.length; i++) {
  87. let obj = new coeListModel(addArr[i]);
  88. obj.ID = (maxId - (addArr.length - 1) + i);
  89. functions.push((function (obj) {
  90. return function (cb) {
  91. coeListModel.create(obj, function(err) {
  92. if (err) {
  93. cb(true, null);
  94. } else {
  95. cb(false, obj);
  96. };
  97. });
  98. }
  99. })(obj));
  100. }
  101. async.parallel(functions, function (err, result) {
  102. if(err) callback(true, 'add fail', null);
  103. else callback(false, 'addSc', result);
  104. })
  105. });
  106. } else {
  107. callback(true, "no source", null);
  108. }
  109. };
  110. coeListDAO.prototype.updateItems = function(updateArr, callback) {
  111. if (updateArr && updateArr.length > 0) {
  112. let functions = [];
  113. for (let i = 0; i < updateArr.length; i++) {
  114. let obj = updateArr[i];
  115. let needSet = {};
  116. for(let attr in obj){
  117. if(attr !== 'libID' || attr !== 'ID'){
  118. needSet[attr] = obj[attr];
  119. }
  120. }
  121. functions.push((function (obj) {
  122. return function (cb) {
  123. coeListModel.update({"libID": obj.libID, "ID": obj.ID}, needSet, function(err) {
  124. if (err) {
  125. cb(true);
  126. } else {
  127. cb(false);
  128. }
  129. });
  130. }
  131. })(obj));
  132. }
  133. async.parallel(functions, function (err, result) {
  134. if(err) callback(true, 'update fail', null);
  135. else callback(false, 'updateSc', null);
  136. })
  137. } else {
  138. callback(true, "no source", null);
  139. }
  140. };
  141. coeListDAO.prototype.deleteItems = function(deleteArr, callback) {
  142. if (deleteArr && deleteArr.length > 0) {
  143. let functions = [];
  144. for (let i = 0; i < deleteArr.length; i++) {
  145. let obj = deleteArr[i];
  146. functions.push((function (obj) {
  147. return function (cb) {
  148. coeListModel.remove({"libID": obj.libID, "ID": obj.ID}, function(err) {
  149. if (err) {
  150. cb(true, null);
  151. } else {
  152. cb(false, obj.ID);
  153. }
  154. });
  155. }
  156. })(obj));
  157. }
  158. async.parallel(functions, function (err, result) {
  159. if(err) callback(true, 'delete fail', null);
  160. else callback(false, 'sc', result);
  161. })
  162. } else {
  163. callback(true, "no source", null);
  164. }
  165. };
  166. module.exports = new coeListDAO();