fee_rates_facade.js 15 KB

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