bills.js 4.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147
  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. // 工程量计算规则
  33. ruleText: String,
  34. // 说明
  35. comments: String,
  36. // 调价
  37. xs_Labour: String, // Decimal
  38. xs_Material: String, // Decimal
  39. xs_Machine: String, // Decimal
  40. xs_FeeRate: String, // Decimal
  41. xs_LabourPrice: String, // Decimal
  42. xs_MaterialPrice: String, // Decimal
  43. xs_MachinePrice: String, // Decimal
  44. isTender_Labour: Boolean,
  45. isTender_Material: Boolean,
  46. isTender_Machine: Boolean,
  47. tenderTargetPrice: String, // Decimal
  48. tenderTargetUnitPrice: String, // Decimal
  49. tenderTargetUnitPrice: String, // Decimal
  50. //工作内容//zhong 2017-8-31
  51. jobContentText: String, //清单工作内容列显示文本, 减少第一次拉数据时的循环次数
  52. jobContent: [subSchema.jobContentSchema],
  53. //项目特征
  54. itemCharacterText: String,//清单项目特征列显示文本
  55. itemCharacter: [subSchema.itemCharacterSchema],
  56. // 费用字段
  57. fees: [subSchema.feesSchema],
  58. // 标记字段
  59. flags: [subSchema.flagsSchema],
  60. deleteInfo: deleteSchema
  61. });
  62. let bills = db.model("bills", billsSchema);
  63. let baseModel = require('./base_model');
  64. class billsModel extends baseModel {
  65. constructor () {
  66. super(bills);
  67. };
  68. getData (projectID, callback) {
  69. this.model.find({'$or': [{projectID: projectID, deleteInfo: null}, {projectID: projectID, 'deleteInfo.deleted': {$in: [null, false]}}]}, '-_id', function(err, datas){
  70. if (!err) {
  71. callback(0, projectConsts.BILLS, datas);
  72. } else {
  73. callback(1, projectConsts.BILLS, null);
  74. };
  75. });
  76. };
  77. save (user_id, datas, callback) {
  78. let functions = [];
  79. let data;
  80. function saveOne(doc) {
  81. return function (cb) {
  82. switch (doc.updateType) {
  83. case commonConsts.UT_UPDATE:
  84. bills.update({projectID: doc.updateData.projectID, ID: doc.updateData.ID,deleteInfo: null}, doc.updateData, cb);
  85. break;
  86. case commonConsts.UT_CREATE:
  87. bills.create(doc.updateData, cb);
  88. break;
  89. case commonConsts.UT_DELETE:
  90. doc.updateData.deleteInfo = {deleted: true, deleteDateTime: new Date(), deleteBy: user_id};
  91. bills.update({projectID: doc.updateData.projectID, ID: doc.updateData.ID}, doc.updateData, cb);
  92. break;
  93. }
  94. }
  95. }
  96. for (let i = 0; i < datas.length; i++){
  97. data = datas[i];
  98. functions.push(saveOne(data));
  99. quantity_detial.quantityEditChecking(data,'bills',functions);
  100. }
  101. async.parallel(functions, function(err,result){
  102. let returnData = {
  103. moduleName:'bills',
  104. data:{}
  105. };
  106. callback(err, returnData);
  107. });
  108. };
  109. getItemTemplate (callback) {
  110. let data = new bills;
  111. /* to do: 需要根据标准配置库填充fees和flags字段,是否需要更多的参数? */
  112. callback(0, '', data);
  113. };
  114. allocIDs (IDStep, callback) {
  115. counter.counterDAO.getIDAfterCount(counter.moduleName.bills, IDStep, function(err, highID){
  116. let lowID = highID - IDStep + 1;
  117. callback(0, '', {lowID: lowID, highID: highID});
  118. });
  119. };
  120. //zhong 2017-9-1
  121. updateCharacterContent(findSet, updateObj, txtObj, callback) {
  122. let updateSet = {};
  123. updateSet[updateObj.field] = updateObj.updateArr;
  124. if(txtObj && typeof txtObj !== 'undefined'){
  125. updateSet[txtObj.field] = txtObj.text;
  126. }
  127. bills.update(findSet, updateSet, function (err) {
  128. if(err){
  129. callback(1, '更新失败');
  130. }
  131. else{
  132. callback(0, '更新成功');
  133. }
  134. });
  135. };
  136. };
  137. module.exports = new billsModel();