bills.js 2.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. /**
  2. * Created by zhang on 2018/3/22.
  3. */
  4. let mongoose = require("mongoose");
  5. let subSchema = require("../all_schemas/bills_sub_schemas");
  6. let deleteSchema = require('../all_schemas/delete_schema');
  7. let Schema = mongoose.Schema;
  8. let billsSchema = new Schema({
  9. ID: String,
  10. ParentID: String,
  11. NextSiblingID: String,
  12. projectID: Number,
  13. serialNo: Number,
  14. chapterID: Number,
  15. billsLibId: Number,
  16. code: String,
  17. fullCode: String,
  18. type:{type: Number,default:4},//1 :大项费用 2:分部 3分项 4清单;5补项
  19. isAdd:{type: Number,default:0},//1 true 0 false是否新增
  20. name: String,
  21. unit: String,
  22. quantity: String, // Decimal
  23. quantityEXP:String,//工程量表达式
  24. feeRateID:Number,
  25. feeRate:String,
  26. isFromDetail:{type: Number,default:0},//1 true 0 false
  27. programID: Number,
  28. calcBase: String,
  29. calcBaseValue: String, // 计算基数表达式的值
  30. // 工程量计算规则
  31. ruleText: String,
  32. // 说明
  33. comments: String,
  34. // 调价
  35. xs_Labour: String, // Decimal
  36. xs_Material: String, // Decimal
  37. xs_Machine: String, // Decimal
  38. xs_FeeRate: String, // Decimal
  39. xs_LabourPrice: String, // Decimal
  40. xs_MaterialPrice: String, // Decimal
  41. xs_MachinePrice: String, // Decimal
  42. isTender_Labour: Boolean,
  43. isTender_Material: Boolean,
  44. isTender_Machine: Boolean,
  45. tenderTargetPrice: String, // Decimal
  46. tenderTargetUnitPrice: String, // Decimal
  47. tenderTargetUnitPrice: String, // Decimal
  48. //工作内容//zhong 2017-8-31
  49. jobContentText: String, //清单工作内容列显示文本, 减少第一次拉数据时的循环次数
  50. jobContent: [subSchema.jobContentSchema],
  51. //项目特征
  52. itemCharacterText: String,//清单项目特征列显示文本
  53. itemCharacter: [subSchema.itemCharacterSchema],
  54. // 费用字段
  55. fees: [subSchema.feesSchema],
  56. // 标记字段
  57. flags: [subSchema.flagsSchema],
  58. //消耗量调整系数字段
  59. quantityCoe:subSchema.quantityCoeSchema,
  60. // 不调价
  61. is_adjust_price: {type: Number,default: 0},
  62. installationKey:String,//用来记录安装增加费的关联字段
  63. deleteInfo: deleteSchema,
  64. isEstimate:{type: Number,default:0}, // 1 true 0 false 是否暂估
  65. remark:String
  66. });
  67. mongoose.model("bills", billsSchema);