fee_rates.js 1.9 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
  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 recordSchema = new Schema({
  14. ID:Number,
  15. name:String,
  16. optionList:[optionSchema]
  17. },{versionKey:false,_id: false})
  18. let valueMapSchema = new Schema({
  19. ID:String,
  20. value:Number
  21. },{versionKey:false,_id: false})
  22. let subFeeRatesSchema = new Schema({
  23. recodes :[recordSchema],
  24. valueMaps:[valueMapSchema],
  25. },{versionKey:false,_id: false});
  26. let ratesSchema = new Schema({
  27. ID: Number,
  28. ParentID: Number,
  29. name: String,
  30. rate: Number,
  31. memo: String,
  32. subFeeRate:subFeeRatesSchema
  33. },{versionKey:false,_id: false});
  34. let feeRatesSchema = new Schema({
  35. ID: {type: String, index: true},
  36. rates: [ratesSchema],
  37. deleteInfo: deleteSchema
  38. },{versionKey:false});
  39. mongoose.model('fee_rates', feeRatesSchema, 'fee_rates');
  40. let feeRateFileSchema = new Schema({
  41. ID: {type: String, index: true},
  42. rootProjectID:Number,//顶层项目ID
  43. userID:String,
  44. name:String,
  45. libID: String,
  46. libName: String,
  47. feeRateID:String,//关联的费率ID
  48. deleteInfo: deleteSchema
  49. },{versionKey:false});
  50. mongoose.model('fee_rate_file', feeRateFileSchema, 'fee_rate_file');
  51. let feeRatesLibSchema = new Schema({
  52. ID: {type: String, index: true},
  53. region: String, // 工程所在地
  54. libName: String,
  55. rates: [ratesSchema]
  56. },{versionKey:false});
  57. mongoose.model('std_fee_rate_libs', feeRatesLibSchema, 'std_fee_rate_libs');