fee_rates_facade.js 13 KB

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