fee_rates_facade.js 13 KB

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