bills.js 4.6 KB

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