bills.js 5.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166
  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. name: String,
  25. unit: String,
  26. quantity: String, // Decimal
  27. feeRateID:Number,
  28. feeRate:String,
  29. isFromDetail:{type: Number,default:0},//1 true 0 false
  30. programID: Number,
  31. calcBase: String,
  32. calcBaseValue: String, // 计算基数表达式的值
  33. // 工程量计算规则
  34. ruleText: String,
  35. // 说明
  36. comments: String,
  37. // 调价
  38. xs_Labour: String, // Decimal
  39. xs_Material: String, // Decimal
  40. xs_Machine: String, // Decimal
  41. xs_FeeRate: String, // Decimal
  42. xs_LabourPrice: String, // Decimal
  43. xs_MaterialPrice: String, // Decimal
  44. xs_MachinePrice: String, // Decimal
  45. isTender_Labour: Boolean,
  46. isTender_Material: Boolean,
  47. isTender_Machine: Boolean,
  48. tenderTargetPrice: String, // Decimal
  49. tenderTargetUnitPrice: String, // Decimal
  50. tenderTargetUnitPrice: String, // Decimal
  51. //工作内容//zhong 2017-8-31
  52. jobContentText: String, //清单工作内容列显示文本, 减少第一次拉数据时的循环次数
  53. jobContent: [subSchema.jobContentSchema],
  54. //项目特征
  55. itemCharacterText: String,//清单项目特征列显示文本
  56. itemCharacter: [subSchema.itemCharacterSchema],
  57. // 费用字段
  58. fees: [subSchema.feesSchema],
  59. // 标记字段
  60. flags: [subSchema.flagsSchema],
  61. deleteInfo: deleteSchema,
  62. // 添加规则
  63. addRule: subSchema.addRuleSchema,
  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. update[tmp.field] = tmp.value;
  146. }
  147. if (Object.keys(update).length <= 0) {
  148. return false;
  149. }
  150. return bills.update(findSet, update);
  151. };
  152. }
  153. module.exports = new billsModel();