bills.js 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169
  1. /**
  2. * Created by jimiz on 2017/4/1.
  3. */
  4. let mongoose = require("mongoose");
  5. let db = require("../db/project_db");
  6. let subSchema = require("./bills_sub_schemas");
  7. let deleteSchema = require('../../../public/models/delete_schema');
  8. let Schema = mongoose.Schema;
  9. let async = require("async");
  10. let counter = require("../../../public/counter/counter.js");
  11. let consts = require('./project_consts');
  12. let projectConsts = consts.projectConst;
  13. let commonConsts = consts.commonConst;
  14. let quantity_detial = require('../facade/quantity_detail_facade');
  15. let billsSchema = new Schema({
  16. ID: Number,
  17. ParentID: Number,
  18. NextSiblingID: Number,
  19. projectID: Number,
  20. serialNo: Number,
  21. chapterID: Number,
  22. code: String,
  23. fullCode: String,
  24. type:{type: Number,default:4},//1 :大项费用 2:分部 3分项 4清单
  25. isAdd:{type: Number,default:0},//1 true 0 false是否新增
  26. name: String,
  27. unit: String,
  28. quantity: String, // Decimal
  29. feeRateID:Number,
  30. feeRate:String,
  31. isFromDetail:{type: Number,default:0},//1 true 0 false
  32. programID: Number,
  33. calcBase: String,
  34. calcBaseValue: String, // 计算基数表达式的值
  35. // 工程量计算规则
  36. ruleText: String,
  37. // 说明
  38. comments: String,
  39. // 调价
  40. xs_Labour: String, // Decimal
  41. xs_Material: String, // Decimal
  42. xs_Machine: String, // Decimal
  43. xs_FeeRate: String, // Decimal
  44. xs_LabourPrice: String, // Decimal
  45. xs_MaterialPrice: String, // Decimal
  46. xs_MachinePrice: String, // Decimal
  47. isTender_Labour: Boolean,
  48. isTender_Material: Boolean,
  49. isTender_Machine: Boolean,
  50. tenderTargetPrice: String, // Decimal
  51. tenderTargetUnitPrice: String, // Decimal
  52. tenderTargetUnitPrice: String, // Decimal
  53. //工作内容//zhong 2017-8-31
  54. jobContentText: String, //清单工作内容列显示文本, 减少第一次拉数据时的循环次数
  55. jobContent: [subSchema.jobContentSchema],
  56. //项目特征
  57. itemCharacterText: String,//清单项目特征列显示文本
  58. itemCharacter: [subSchema.itemCharacterSchema],
  59. // 费用字段
  60. fees: [subSchema.feesSchema],
  61. // 标记字段
  62. flags: [subSchema.flagsSchema],
  63. deleteInfo: deleteSchema,
  64. });
  65. let bills = db.model("bills", billsSchema);
  66. let baseModel = require('./base_model');
  67. class billsModel extends baseModel {
  68. constructor () {
  69. super(bills);
  70. };
  71. getData (projectID, callback) {
  72. this.model.find({'$or': [{projectID: projectID, deleteInfo: null}, {projectID: projectID, 'deleteInfo.deleted': {$in: [null, false]}}]}, '-_id', function(err, datas){
  73. if (!err) {
  74. callback(0, projectConsts.BILLS, datas);
  75. } else {
  76. callback(1, projectConsts.BILLS, null);
  77. };
  78. });
  79. };
  80. save (user_id, datas, callback) {
  81. let functions = [];
  82. let data;
  83. function saveOne(doc) {
  84. return function (cb) {
  85. switch (doc.updateType) {
  86. case commonConsts.UT_UPDATE:
  87. bills.update({projectID: doc.updateData.projectID, ID: doc.updateData.ID,deleteInfo: null}, doc.updateData, cb);
  88. break;
  89. case commonConsts.UT_CREATE:
  90. bills.create(doc.updateData, cb);
  91. break;
  92. case commonConsts.UT_DELETE:
  93. doc.updateData.deleteInfo = {deleted: true, deleteDateTime: new Date(), deleteBy: user_id};
  94. bills.update({projectID: doc.updateData.projectID, ID: doc.updateData.ID}, doc.updateData, cb);
  95. break;
  96. }
  97. }
  98. }
  99. for (let i = 0; i < datas.length; i++){
  100. data = datas[i];
  101. functions.push(saveOne(data));
  102. quantity_detial.quantityEditChecking(data,'bills',functions);
  103. }
  104. async.parallel(functions, function(err,result){
  105. let returnData = {
  106. moduleName:'bills',
  107. data:{}
  108. };
  109. callback(err, returnData);
  110. });
  111. };
  112. getItemTemplate (callback) {
  113. let data = new bills;
  114. /* to do: 需要根据标准配置库填充fees和flags字段,是否需要更多的参数? */
  115. callback(0, '', data);
  116. };
  117. allocIDs (IDStep, callback) {
  118. counter.counterDAO.getIDAfterCount(counter.moduleName.bills, IDStep, function(err, highID){
  119. let lowID = highID - IDStep + 1;
  120. callback(0, '', {lowID: lowID, highID: highID});
  121. });
  122. };
  123. //zhong 2017-9-1
  124. updateCharacterContent(findSet, updateObj, txtObj, callback) {
  125. let updateSet = {};
  126. updateSet[updateObj.field] = updateObj.updateArr;
  127. if(txtObj && typeof txtObj !== 'undefined'){
  128. updateSet[txtObj.field] = txtObj.text;
  129. }
  130. bills.update(findSet, updateSet, function (err) {
  131. if(err){
  132. callback(1, '更新失败');
  133. }
  134. else{
  135. callback(0, '更新成功');
  136. }
  137. });
  138. };
  139. async updateBill(findSet, updateData) {
  140. let update = {};
  141. if (!updateData instanceof Array) {
  142. return false;
  143. }
  144. for (const tmp of updateData) {
  145. if (tmp === undefined) {
  146. continue;
  147. }
  148. update[tmp.field] = tmp.value;
  149. }
  150. if (Object.keys(update).length <= 0) {
  151. return false;
  152. }
  153. return bills.update(findSet, update);
  154. };
  155. }
  156. module.exports = new billsModel();