bills.js 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148
  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. let bills = db.model("bills", billsSchema);
  64. let baseModel = require('./base_model');
  65. class billsModel extends baseModel {
  66. constructor () {
  67. super(bills);
  68. };
  69. getData (projectID, callback) {
  70. this.model.find({'$or': [{projectID: projectID, deleteInfo: null}, {projectID: projectID, 'deleteInfo.deleted': {$in: [null, false]}}]}, '-_id', function(err, datas){
  71. if (!err) {
  72. callback(0, projectConsts.BILLS, datas);
  73. } else {
  74. callback(1, projectConsts.BILLS, null);
  75. };
  76. });
  77. };
  78. save (user_id, datas, callback) {
  79. let functions = [];
  80. let data;
  81. function saveOne(doc) {
  82. return function (cb) {
  83. switch (doc.updateType) {
  84. case commonConsts.UT_UPDATE:
  85. bills.update({projectID: doc.updateData.projectID, ID: doc.updateData.ID,deleteInfo: null}, doc.updateData, cb);
  86. break;
  87. case commonConsts.UT_CREATE:
  88. bills.create(doc.updateData, cb);
  89. break;
  90. case commonConsts.UT_DELETE:
  91. doc.updateData.deleteInfo = {deleted: true, deleteDateTime: new Date(), deleteBy: user_id};
  92. bills.update({projectID: doc.updateData.projectID, ID: doc.updateData.ID}, doc.updateData, cb);
  93. break;
  94. }
  95. }
  96. }
  97. for (let i = 0; i < datas.length; i++){
  98. data = datas[i];
  99. functions.push(saveOne(data));
  100. quantity_detial.quantityEditChecking(data,'bills',functions);
  101. }
  102. async.parallel(functions, function(err,result){
  103. let returnData = {
  104. moduleName:'bills',
  105. data:{}
  106. };
  107. callback(err, returnData);
  108. });
  109. };
  110. getItemTemplate (callback) {
  111. let data = new bills;
  112. /* to do: 需要根据标准配置库填充fees和flags字段,是否需要更多的参数? */
  113. callback(0, '', data);
  114. };
  115. allocIDs (IDStep, callback) {
  116. counter.counterDAO.getIDAfterCount(counter.moduleName.bills, IDStep, function(err, highID){
  117. let lowID = highID - IDStep + 1;
  118. callback(0, '', {lowID: lowID, highID: highID});
  119. });
  120. };
  121. //zhong 2017-9-1
  122. updateCharacterContent(findSet, updateObj, txtObj, callback) {
  123. let updateSet = {};
  124. updateSet[updateObj.field] = updateObj.updateArr;
  125. if(txtObj && typeof txtObj !== 'undefined'){
  126. updateSet[txtObj.field] = txtObj.text;
  127. }
  128. bills.update(findSet, updateSet, function (err) {
  129. if(err){
  130. callback(1, '更新失败');
  131. }
  132. else{
  133. callback(0, '更新成功');
  134. }
  135. });
  136. };
  137. };
  138. module.exports = new billsModel();