fee_rates_facade.js 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402
  1. /**
  2. * Created by chen on 2017/8/2.
  3. */
  4. let async_n = require("async");
  5. let mongoose = require('mongoose');
  6. let feeRateModel = mongoose.model('fee_rates');
  7. let feeRateFileModel = mongoose.model('fee_rate_file');
  8. let std_fee_rate_lib_model = mongoose.model('std_fee_rate_libs');
  9. let billModel=require('../../main/models/bills');//mongoose.model('bills');
  10. let projectsModel = require("../../pm/models/project_schema");
  11. let consts = require('../../main/models/project_consts');
  12. let _=require("lodash");
  13. let template = require('../controllers/feerate_template');
  14. let logger = require("../../../logs/log_helper").logger;
  15. const uuidV1 = require('uuid/v1');
  16. let EngineeringLibModel = require("../../users/models/engineering_lib_model");
  17. module.exports={
  18. save:save,
  19. getData:getData,
  20. getFeeRateStandardsByProjectID:getFeeRateStandardsByProjectID,
  21. changeFeeRateStandard:changeFeeRateStandard,
  22. checkFeeRateName:checkFeeRateName,
  23. getChangeInfo:getChangeInfo,
  24. changeFeeRateFileFromCurrent:changeFeeRateFileFromCurrent,
  25. changeFeeRateFileFromOthers:changeFeeRateFileFromOthers,
  26. newFeeRateFile:newFeeRateFile,
  27. getFeeRatesByProject:getFeeRatesByProject,
  28. getGCFeeRateFiles: getGCFeeRateFiles ,
  29. updateFeeRate:updateFeeRate
  30. };
  31. let operationMap={
  32. 'ut_create':create_fee_rate,
  33. 'ut_update':update_fee_rate,
  34. 'ut_delete':delete_fee_rate
  35. };
  36. let updateFunctionMap = {
  37. 'normalUpdate':normalUpdate,
  38. 'update_rates':update_rates,
  39. 'updateStatusBySelected':updateStatusBySelected,
  40. 'feeRateFileSaveAs':feeRateFileSaveAs
  41. }
  42. function create_fee_rate() {
  43. }
  44. function update_fee_rate(user_id,datas) {
  45. if(datas.updateFunction){
  46. return updateFunctionMap[datas.updateFunction](user_id,datas);
  47. }else {
  48. return normalUpdate(user_id,datas);
  49. }
  50. }
  51. function updateStatusBySelected(user_id,datas) {
  52. return function(callback){
  53. feeRateModel.bulkWrite(generateUpdateTaks(datas.tasks),function (err,data) {
  54. console.log(data);
  55. commonCallback(callback,data,err);
  56. })
  57. }
  58. }
  59. function feeRateFileSaveAs(user_id,datas) {
  60. return function(callback){
  61. let doc = datas.doc;
  62. let projectID=datas.query.projectID;
  63. let feeRate={
  64. ID:doc.feeRateID,
  65. rates:doc.rates
  66. };
  67. delete doc._id;
  68. delete doc.rates;
  69. creatFeeRateFile(doc,feeRate,projectID).then(function (result) {
  70. commonCallback(callback,result,result.err);
  71. })
  72. }
  73. }
  74. async function creatFeeRateFile(feeRateFile,feeRate,projectID) {//预留projectID
  75. let result={
  76. err:null
  77. }
  78. try {
  79. let feeFile={
  80. id:feeRateFile.ID,
  81. name:feeRateFile.name
  82. }
  83. await projectsModel.findOneAndUpdate({ID:projectID},{'property.feeFile':feeFile});
  84. await feeRateFileModel.create(feeRateFile);
  85. await feeRateModel.create(feeRate);
  86. }catch (err){
  87. console.log(err);
  88. result.err=err;
  89. }
  90. return result;
  91. }
  92. function normalUpdate(user_id,datas) {
  93. return function(callback){
  94. console.log(datas)
  95. callback(null,'');
  96. }
  97. }
  98. function generateUpdateTaks(updateTasks) {
  99. var tasks=[];
  100. for(let u of updateTasks){
  101. let t ={
  102. updateOne:{
  103. filter:u.query,
  104. update: u.doc
  105. }
  106. }
  107. tasks.push(t);
  108. }
  109. return tasks;
  110. }
  111. function update_rates(user_id,datas) {
  112. return function(callback){
  113. feeRateModel.findOne(datas.query,['rates'],function(err, data){
  114. let doc = datas.doc;
  115. if(_.isArray(doc)){
  116. _.forEach(doc,function (item) {
  117. data.rates[item.rateIndex]=item.rate;
  118. })
  119. }else {
  120. data.rates[doc.rateIndex]=doc.rate;
  121. }
  122. data.save(function (err) {
  123. commonCallback(callback,'',err);
  124. });
  125. })
  126. }
  127. }
  128. function delete_fee_rate() {
  129. }
  130. function save (user_id, datas, callback) {
  131. let operations=[];
  132. if(_.isArray(datas)){
  133. for(let i=0;i<datas.length;i++){
  134. operations.push(operationMap[datas[i].updateType](user_id,datas[i]));
  135. }
  136. }else {
  137. operations.push(operationMap[datas.updateType](user_id,datas));
  138. }
  139. async_n.parallel(operations,function (err,results) {
  140. if(err){
  141. callback(err,'');
  142. }else {
  143. if(results.length==1){
  144. callback(null,results[0])
  145. }else {
  146. callback(null,results)
  147. }
  148. }
  149. })
  150. }
  151. function getData(projectID, callback) {
  152. getFeeRateData(projectID).then(function (result) {
  153. if(result.err){
  154. callback(1, '', null);
  155. }else {
  156. //feeRateModel
  157. callback(0, consts.projectConst.FEERATE, result.datas);
  158. }
  159. })
  160. }
  161. async function getFeeRateData(projectID) {
  162. let result={
  163. err:null
  164. }
  165. try {
  166. //
  167. let project = await projectsModel.findOne({ID:projectID});
  168. if (project&&project.property&&project.property.feeFile){
  169. let feeRateData = await feeRateFileModel.findOne({'ID':project.property.feeFile.id,deleteInfo:null});
  170. if(feeRateData===null){
  171. result.datas=[];
  172. }else {
  173. let feeRate = await feeRateModel.findOne({ID:feeRateData.feeRateID});
  174. feeRateData._doc.rates = feeRate?feeRate.rates:[];
  175. //
  176. feeRateData._doc.usageProjects=await getUsageProjects(feeRateData.ID);
  177. result.datas = feeRateData;
  178. }
  179. }else {
  180. result.datas=[];
  181. }
  182. logger.info("get fee rate data");
  183. }catch (err){
  184. console.log(err);
  185. result.err=err;
  186. }
  187. return result;
  188. }
  189. async function getUsageProjects(feeRateID){
  190. let projects = await projectsModel.find({'property.feeFile.id':feeRateID,'deleteInfo':null});
  191. return projects;
  192. }
  193. function commonCallback(callback,result,err) {
  194. if(err){
  195. callback(err,'');
  196. }else {
  197. callback(null,result);
  198. }
  199. }
  200. async function getFeeRateStandardsByProjectID(projectID) {
  201. logger.info("get feeRate standard, projectID:"+projectID)
  202. let feeRateStandards=[];
  203. let project = await projectsModel.findOne({ID:projectID});
  204. let engineeringLibModel = new EngineeringLibModel();
  205. let engineeringInfo = project !== null && project.property.engineering_id !== undefined ?
  206. await engineeringLibModel.getEngineering(project.property.engineering_id) : null;
  207. if(engineeringInfo!=null){
  208. let fee_lib = engineeringInfo.fee_lib;
  209. for(let lib of fee_lib){
  210. feeRateStandards.push({ID:lib.id,libName:lib.name});
  211. }
  212. }
  213. return feeRateStandards;
  214. }
  215. async function changeFeeRateStandard(jdata){
  216. let data = JSON.parse(jdata);
  217. let template = await std_fee_rate_lib_model.findOne({"ID":data.newLibID});
  218. let newFeeRate = {};
  219. newFeeRate.ID =uuidV1();
  220. newFeeRate.rates=template.rates;
  221. await feeRateModel.create(newFeeRate);
  222. let doc={
  223. libID:data.newLibID,
  224. libName:template.libName,
  225. feeRateID: newFeeRate.ID
  226. };
  227. let deleteInfo = {deleted: true, deleteDateTime: new Date(), deleteBy: data.user_id};
  228. await feeRateFileModel.findOneAndUpdate({ID:data.feeRateFileID,deleteInfo:null},doc);
  229. await feeRateModel.findOneAndUpdate({ID:data.feeRateID},{deleteInfo:deleteInfo});
  230. doc.rates=newFeeRate.rates;
  231. return doc;
  232. }
  233. async function newFeeRateFile(updateData){
  234. if(updateData.property !== null){
  235. let property = updateData.property;
  236. logger.info("Create new feeRate file for project :"+updateData.ID);
  237. let feeFile = property.feeFile;
  238. let rootProjectID = property.rootProjectID;
  239. let name = updateData.name;
  240. let newFeeRate = {};
  241. if(feeFile.id.indexOf("newFeeRate")!=-1){
  242. let temFee = await feeRateFileModel.findOne({rootProjectID:rootProjectID,name:name,deleteInfo:null});
  243. if(temFee){
  244. newFeeRate.id=temFee.ID;
  245. newFeeRate.name = temFee.name;
  246. return newFeeRate;
  247. }
  248. let temA = feeFile.id.split("-");
  249. let libID = temA[1];
  250. let doc={
  251. rootProjectID:rootProjectID,
  252. name:name
  253. };
  254. if(libID!== ''){
  255. let template = await std_fee_rate_lib_model.findOne({"ID":libID});
  256. let newFeeRate = {};
  257. newFeeRate.ID =uuidV1();
  258. newFeeRate.rates=template.rates;
  259. await feeRateModel.create(newFeeRate);
  260. doc.libID = libID;
  261. doc.libName = template.libName;
  262. doc.feeRateID = newFeeRate.ID;
  263. }
  264. doc.ID = uuidV1();
  265. await feeRateFileModel.create(doc);
  266. newFeeRate.id = doc.ID;
  267. newFeeRate.name =doc.name;
  268. return newFeeRate;
  269. }else {
  270. return feeFile
  271. }
  272. }
  273. return null;
  274. }
  275. async function checkFeeRateName(jdata) {
  276. let data = JSON.parse(jdata);
  277. let count = await feeRateFileModel.count({rootProjectID:data.rootProjectID,name:data.name,deleteInfo:null});
  278. if(count>0){
  279. return true;
  280. }
  281. return false;
  282. }
  283. async function getChangeInfo(jdata){
  284. let data = JSON.parse(jdata);
  285. //{ rootProjectID: 99, user_id: '76075' }
  286. let result={};
  287. let currentProject = await projectsModel.findOne({'ID':data.rootProjectID},['ID','name']); //{projectID:99,name:'建设项目1'};//dummy 数据
  288. if(currentProject){
  289. currentProject._doc.currentOptions=await getFeeRatesByProject(data.rootProjectID);
  290. }
  291. //根据用户ID 找除了当前项目的其它建设项目;
  292. let others =await projectsModel.find({'$and': [
  293. {'$or':[{'userID': data.user_id,'projType':'Project', 'deleteInfo': null}, {'userID': data.user_id,'projType':'Project', 'deleteInfo.deleted': {'$in': [null, false]}}]},
  294. { 'ID':{'$nin':[data.rootProjectID]}}
  295. ]},['ID','name']);
  296. for(let o of others){
  297. o._doc.optionList = await getFeeRatesByProject(o.ID);
  298. }
  299. result.currentProject=currentProject;
  300. result.others = others;
  301. return result;
  302. }
  303. async function getFeeRatesByProject(rootProjectID) {
  304. let feeRates = await feeRateFileModel.find({rootProjectID:rootProjectID,deleteInfo:null},['ID','name']);
  305. return feeRates;
  306. }
  307. async function setFeeRateToBill(data){
  308. data=JSON.parse(data);
  309. if(data.hasOwnProperty('bills')){
  310. await billModel.model.findOneAndUpdate(data.bills.query,data.bills.doc);
  311. }
  312. if(data.hasOwnProperty('feeRate')){
  313. await feeRateModel.findOneAndUpdate(data.feeRate.query,data.feeRate.doc);
  314. }
  315. return "ok";
  316. }
  317. async function updateFeeRate(data) {
  318. data=JSON.parse(data);
  319. return await feeRateModel.findOneAndUpdate(data.query,data.doc);
  320. }
  321. async function changeFeeRateFileFromCurrent(jdata){
  322. let data = JSON.parse(jdata);
  323. let newFeeRateFile=data.newFeeRateFile;
  324. let result = await projectsModel.findOneAndUpdate({ID:data.projectID},{'property.feeFile':newFeeRateFile});
  325. let feeRateData = await feeRateFileModel.findOne({'ID':newFeeRateFile.id});
  326. if(feeRateData!==null){
  327. let feeRate = await feeRateModel.findOne({ID:feeRateData.feeRateID});
  328. feeRateData._doc.rates = feeRate.rates;
  329. }
  330. //
  331. feeRateData._doc.usageProjects=await getUsageProjects(feeRateData.ID);
  332. return feeRateData;
  333. }
  334. async function changeFeeRateFileFromOthers(jdata) {
  335. let data = JSON.parse(jdata);
  336. console.log(data);
  337. let feeRateFile = await feeRateFileModel.findOne({'ID':data.feeRateFileID});
  338. let feeRate = await feeRateModel.findOne({ID:feeRateFile.feeRateID});
  339. let newFeeRate={};
  340. newFeeRate.ID=uuidV1();
  341. newFeeRate.rates =feeRate.rates;
  342. let newFeeRateFile = {};
  343. newFeeRateFile.ID = uuidV1();
  344. newFeeRateFile.name = data.name;
  345. newFeeRateFile.libName = feeRateFile.libName;
  346. newFeeRateFile.libID=feeRateFile.libID;
  347. newFeeRateFile.rootProjectID = data.rootProjectID;
  348. newFeeRateFile.feeRateID =newFeeRate.ID;
  349. await feeRateModel.create(newFeeRate);
  350. await feeRateFileModel.create(newFeeRateFile);
  351. let feeFile={
  352. id:newFeeRateFile.ID,
  353. name:data.name
  354. }
  355. await projectsModel.findOneAndUpdate({ID:data.projectID},{'property.feeFile':feeFile});
  356. newFeeRateFile.rates=newFeeRate.rates;
  357. newFeeRateFile.usageProjects=await getUsageProjects(newFeeRateFile.ID);
  358. return newFeeRateFile;
  359. }
  360. async function getGCFeeRateFiles(userID){
  361. return await feeRateFileModel.find({userID: userID, 'deleteInfo.deleted': true});
  362. }