std_fee_rate_libs.js 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
  1. /*
  2. /!**
  3. * Created by CSL on 2017-03-22.
  4. *!/
  5. var mg = require('mongoose');
  6. var dbm = require("../../../config/db/db_manager");
  7. var db = dbm.getCfgConnection("scConstruct");
  8. var ratesSchema = new mg.Schema({
  9. ID: Number,
  10. ParentID: Number,
  11. name: String,
  12. rate: Number,
  13. memo: String
  14. });
  15. var libsSchema = new mg.Schema({
  16. region: String, // 工程所在地
  17. libID: Number, // 费率标准文件ID
  18. libName: String, // 费率标准文件名称
  19. rates: [ratesSchema] // 树表结构费率值
  20. });
  21. var libsModel = db.model('std_fee_rate_libs', libsSchema, 'std_fee_rate_libs');
  22. var StdFeeRateLibs = function(){};
  23. StdFeeRateLibs.prototype.libNames = function(region, controllerFun){
  24. libsModel.find({"region": region}, ["libID", "libName"], function(err, data){
  25. if(data.length){
  26. controllerFun(data);
  27. }
  28. else{
  29. controllerFun(false);
  30. }
  31. })
  32. };
  33. StdFeeRateLibs.prototype.rates = function(libID, controllerFun){
  34. libsModel.find({"libID": libID}, ["rates"], function(err, data){
  35. if(data.length){
  36. controllerFun(data);
  37. }
  38. else{
  39. controllerFun(false);
  40. }
  41. })
  42. };
  43. module.exports = new StdFeeRateLibs();
  44. */