stdRation_ration.js 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. /**
  2. * Created by Zhong on 2018/3/22.
  3. */
  4. /*定额库-定额*/
  5. const mongoose = require('mongoose');
  6. const Schema = mongoose.Schema;
  7. const rationGljItemSchema = new Schema({
  8. gljId: Number,
  9. consumeAmt: Number,
  10. proportion: Number //配合比,暂时无需使用,默认0
  11. }, { _id: false });
  12. const rationAssItemSchema = new Schema({
  13. name: String,
  14. assistID: Number,
  15. assistCode: String,
  16. stdValue: String,
  17. stepValue: String,
  18. decimal: Number,
  19. carryBit: String,
  20. minValue: String,
  21. maxValue: String,
  22. paramName: String,//参数名称
  23. param: String,//参数
  24. thirdRationCode: String//第三定额
  25. }, { _id: false });
  26. //定额安装增加费用
  27. const rationInstSchema = new Schema({
  28. feeItemId: String,
  29. sectionId: String
  30. }, { _id: false });
  31. const rationItemSchema = new Schema({
  32. ID: Number,
  33. code: String,
  34. name: String,
  35. unit: String,
  36. basePrice: Number,
  37. labourPrice: Number,
  38. materialPrice: Number,
  39. machinePrice: Number,
  40. sectionId: Number,
  41. rationRepId: { type: Number, index: true },
  42. caption: String,
  43. feeType: Number,
  44. jobContent: String,
  45. annotation: String,
  46. manageFeeRate: String, // 管理费费率
  47. rationGljList: [rationGljItemSchema],
  48. rationCoeList: Array,
  49. rationAssList: [rationAssItemSchema],
  50. rationInstList: [rationInstSchema],
  51. rationTemplateList: {
  52. type: Array,
  53. default: []
  54. },
  55. jobContentText: String,//默认的工作内容
  56. manageFee1: Number, // 1类地区管理费
  57. manageFee2: Number, // 2类地区管理费
  58. manageFee3: Number, // 3类地区管理费
  59. manageFee4: Number, // 4类地区管理费
  60. isDeleted: { type: Boolean, default: false }
  61. });
  62. mongoose.model('std_ration_lib_ration_items', rationItemSchema, 'std_ration_lib_ration_items');