bills.js 3.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111
  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 billsSchema = new Schema({
  15. ID: Number,
  16. ParentID: Number,
  17. NextSiblingID: Number,
  18. projectID: Number,
  19. serialNo: Number,
  20. chapterID: Number,
  21. code: String,
  22. fullCode: String,
  23. name: String,
  24. unit: String,
  25. quantity: String, // Decimal
  26. isFromDetail:{type: Number,default:0},//1 true 2 false
  27. programID: Number,
  28. comments: String,
  29. // 调价
  30. xs_Labour: String, // Decimal
  31. xs_Material: String, // Decimal
  32. xs_Machine: String, // Decimal
  33. xs_FeeRate: String, // Decimal
  34. xs_LabourPrice: String, // Decimal
  35. xs_MaterialPrice: String, // Decimal
  36. xs_MachinePrice: String, // Decimal
  37. isTender_Labour: Boolean,
  38. isTender_Material: Boolean,
  39. isTender_Machine: Boolean,
  40. tenderTargetPrice: String, // Decimal
  41. tenderTargetUnitPrice: String, // Decimal
  42. tenderTargetUnitPrice: String, // Decimal
  43. // 费用字段
  44. fees: [subSchema.feesSchema],
  45. // 标记字段
  46. flags: [subSchema.flagsSchema],
  47. deleteInfo: deleteSchema
  48. });
  49. let bills = db.model("bills", billsSchema);
  50. let baseModel = require('./base_model');
  51. class billsModel extends baseModel {
  52. constructor () {
  53. super(bills);
  54. };
  55. getData (projectID, callback) {
  56. this.model.find({'$or': [{projectID: projectID, deleteInfo: null}, {projectID: projectID, 'deleteInfo.deleted': {$in: [null, false]}}]}, '-_id', function(err, datas){
  57. if (!err) {
  58. callback(0, projectConsts.BILLS, datas);
  59. } else {
  60. callback(1, projectConsts.BILLS, null);
  61. };
  62. });
  63. };
  64. save (user_id, datas, callback) {
  65. let functions = [];
  66. let data;
  67. function saveOne(doc) {
  68. return function (cb) {
  69. switch (doc.updateType) {
  70. case commonConsts.UT_UPDATE:
  71. bills.update({projectID: doc.updateData.projectID, ID: doc.updateData.ID}, doc.updateData, cb);
  72. break;
  73. case commonConsts.UT_CREATE:
  74. bills.create(doc.updateData, cb);
  75. break;
  76. case commonConsts.UT_DELETE:
  77. doc.updateData.deleteInfo = {deleted: true, deleteDateTime: new Date(), deleteBy: user_id};
  78. bills.update({projectID: doc.updateData.projectID, ID: doc.updateData.ID}, doc.updateData, cb);
  79. break;
  80. }
  81. }
  82. }
  83. for (let i = 0; i < datas.length; i++){
  84. data = datas[i];
  85. functions.push(saveOne(data));
  86. }
  87. async.parallel(functions, callback);
  88. };
  89. getItemTemplate (callback) {
  90. let data = new bills;
  91. /* to do: 需要根据标准配置库填充fees和flags字段,是否需要更多的参数? */
  92. callback(0, '', data);
  93. };
  94. allocIDs (IDStep, callback) {
  95. counter.counterDAO.getIDAfterCount(counter.moduleName.bills, IDStep, function(err, highID){
  96. let lowID = highID - IDStep + 1;
  97. callback(0, '', {lowID: lowID, highID: highID});
  98. });
  99. };
  100. };
  101. module.exports = new billsModel();