fee_rates.js 2.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384
  1. /**
  2. * Created by CSL on 2017-03-29.
  3. */
  4. let mongoose = require('mongoose');
  5. let Schema = mongoose.Schema;
  6. let deleteSchema = require('../all_schemas/delete_schema');
  7. // {ID:1,name:'工程分类',optionList:[{name:'一类工程',value:1,selected:true},{name:'二类工程',value:2,selected:false},{name:'三类工程',value:3,selected:false},{name:'四类工程',value:4,selected:false}]},
  8. let optionSchema = new Schema({
  9. name:String,
  10. value:String,
  11. selected:Boolean
  12. },{versionKey:false,_id: false})
  13. let subRecord = new Schema({
  14. ID:Number,
  15. name:String,
  16. amount: Number,//倍数
  17. value: Number,
  18. }, {_id: false});
  19. let recordSchema = new Schema({
  20. ID:Number,
  21. name:String,
  22. editable:Boolean,
  23. step: Number,//每增加的步数
  24. amount: Number,//倍数
  25. value: Number,
  26. subList:[subRecord],
  27. optionList:[optionSchema]
  28. },{versionKey:false,_id: false})
  29. let valueMapSchema = new Schema({
  30. ID:String,
  31. value:Number
  32. },{versionKey:false,_id: false})
  33. let subFeeRatesSchema = new Schema({
  34. recodes :[recordSchema],
  35. valueMaps:[valueMapSchema],
  36. },{versionKey:false,_id: false});
  37. let ratesSchema = new Schema({
  38. ID: Number,
  39. ParentID: Number,
  40. name: String,
  41. rate: Number,
  42. memo: String,
  43. sum:Boolean,
  44. subFeeRate:subFeeRatesSchema
  45. },{versionKey:false,_id: false});
  46. let feeRatesSchema = new Schema({
  47. ID: String,
  48. rates: [ratesSchema],
  49. deleteInfo: deleteSchema
  50. },{versionKey:false});
  51. mongoose.model('fee_rates', feeRatesSchema, 'fee_rates');
  52. let feeRateFileSchema = new Schema({
  53. ID: String,
  54. rootProjectID:Number,//顶层项目ID
  55. userID:String,
  56. name:String,
  57. libID: String,
  58. libName: String,
  59. feeRateID:String,//关联的费率ID
  60. deleteInfo: deleteSchema
  61. },{versionKey:false});
  62. mongoose.model('fee_rate_file', feeRateFileSchema, 'fee_rate_file');
  63. let feeRatesLibSchema = new Schema({
  64. ID: String,
  65. region: String, // 工程所在地
  66. libName: String,
  67. rates: [ratesSchema]
  68. },{versionKey:false});
  69. mongoose.model('std_fee_rate_libs', feeRatesLibSchema, 'std_fee_rate_libs');