ration_glj_facade.js 37 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057
  1. /**
  2. * Created by chen on 2017/6/29.
  3. */
  4. let mongoose = require('mongoose');
  5. const uuidV1 = require('uuid/v1');
  6. let consts = require('../../main/models/project_consts')
  7. let commonConsts = consts.commonConst;
  8. let _ = require("lodash");
  9. let ration_glj = mongoose.model('ration_glj');
  10. import GLJListModel from '../../glj/models/glj_list_model';
  11. let std_glj_lib_gljList_model = mongoose.model('std_glj_lib_gljList');
  12. let async_n = require("async");
  13. let ration = mongoose.model('ration');
  14. let ration_coe_facade = require('./ration_coe_facade');
  15. let ration_coe = mongoose.model('ration_coe');
  16. let std_ration_lib_ration_items = mongoose.model('std_ration_lib_ration_items');
  17. let glj_calculate_facade = require('./glj_calculate_facade');
  18. let glj_type_util = require('../../../public/cache/std_glj_type_util');
  19. let quantity_detail_facade = require('../../main/facade/quantity_detail_facade');
  20. let ration_installation_facade = require('../../main/facade/ration_installation_facade');
  21. let logger = require("../../../logs/log_helper").logger;
  22. import stdgljutil from "../../../public/cache/std_glj_type_util";
  23. import EngineeringLibModel from "../../users/models/engineering_lib_model";
  24. import GljDao from "../../complementary_glj_lib/models/gljModel";
  25. const complementaryGljModel = mongoose.model('complementary_glj_lib');
  26. const stdGljModel = mongoose.model('std_glj_lib_gljList');
  27. const gljClassModel = mongoose.model('std_glj_lib_gljClass');
  28. const projectDao = require('../../pm/models/project_model').project;
  29. const compleClassModel = mongoose.model('complementary_glj_section');
  30. let gljUtil = require('../../../public/gljUtil');
  31. module.exports = {
  32. save: save,
  33. getData: getData,
  34. deleteByRation: deleteByRation,
  35. getQuantityByProjectGLJ: getQuantityByProjectGLJ,
  36. getLibInfo: getLibInfo,
  37. getGLJData: getGLJData,
  38. getGLJDataByCodes:getGLJDataByCodes,
  39. addGLJ: addGLJ,
  40. deleteRationGLJ:deleteRationGLJ,
  41. deleteGLJ:deleteGLJ,
  42. insertAddTypeGLJ:insertAddTypeGLJ,
  43. replaceGLJ: replaceGLJ,
  44. replaceGLJByData:replaceGLJByData,
  45. mReplaceGLJ: mReplaceGLJ,
  46. updateRationGLJByEdit: updateRationGLJByEdit,
  47. getGLJClass: getGLJClass,
  48. insertGLJAsRation: insertGLJAsRation,
  49. getRationTypeGLJQuantity:getRationTypeGLJQuantity,
  50. getInfoFromProjectGLJ:getInfoFromProjectGLJ,
  51. createNewRecord:createNewRecord,
  52. getGLJSearchInfo:getGLJSearchInfo,
  53. updateRationGLJFromDoc:updateRationGLJFromDoc,
  54. getGLJLibByEngineerID:getGLJLibByEngineerID,
  55. prepareExtData:prepareExtData
  56. }
  57. let operationMap = {
  58. 'ut_create': create_ration_glj,
  59. 'ut_update': update_ration_glj,
  60. 'ut_delete': delete_ration_glj
  61. };
  62. let updateFunctionMap = {
  63. 'normalUpdate': normalUpdate
  64. };
  65. /**
  66. * 根据项目工料机ID和项目ID取消耗量
  67. *
  68. * @param {object} condition
  69. * @return Array
  70. */
  71. async function getQuantityByProjectGLJ(condition) {
  72. let query = {
  73. 'projectID': condition.projectID,
  74. };
  75. if(condition.projectGLJIDList){
  76. query['projectGLJID'] = {$in: condition.projectGLJIDList};
  77. }
  78. let startTime = +new Date();
  79. let results = await ration_glj.find(query, ['projectGLJID', 'quantity', 'rationID'], {sort: {projectGLJID: 1}});
  80. let rationList = _.uniq(_.map(results, 'rationID'));
  81. let getQuantity = +new Date();
  82. console.log("取工料机消耗量时间-----"+(getQuantity - startTime));
  83. let rationQuery = {
  84. 'projectID': condition.projectID,
  85. 'ID': {$in: rationList},
  86. 'deleteInfo': null
  87. };
  88. /* $and: [
  89. {'projectID': condition.projectID},
  90. {'ID': {$in: rationList}},
  91. {'deleteInfo': null}
  92. ]*/
  93. let rations = await ration.find(rationQuery, ['ID', 'quantity']);
  94. let rationsTime = +new Date();
  95. console.log("取定额消耗量时间-----"+(rationsTime - getQuantity));
  96. return combineQuantity(results, rations);
  97. }
  98. function combineQuantity(results, rations) {
  99. let resultList = [];
  100. let rationMap = _.indexBy(rations,'ID');
  101. for(let r of results){
  102. let tmp = {
  103. projectGLJID: r.projectGLJID,
  104. quantity: Number(r.quantity)
  105. }
  106. let ration = rationMap[r.rationID];//_.find(rations, {ID: r.rationID})
  107. if (ration) {
  108. tmp.rationID = ration.ID;
  109. tmp.rationQuantity = ration.quantity ? Number(ration.quantity) : undefined;
  110. }
  111. resultList.push(tmp);
  112. }
  113. return resultList;
  114. return resultList;
  115. }
  116. function get_lib_glj_info(ration_glj) {
  117. return function (result, cb) {
  118. std_glj_lib_gljList_model.findOne({'ID': ration_glj.GLJID}, (err, glj) => {
  119. if (err) {
  120. cb(err, '')
  121. } else if (glj) {
  122. ration_glj.name = glj.name;
  123. ration_glj.code = glj.code;
  124. ration_glj.original_code = glj.code;
  125. ration_glj.unit = glj.unit;
  126. ration_glj.specs = glj.specs;
  127. ration_glj.basePrice = glj.basePrice;
  128. ration_glj.marketPrice = glj.basePrice;
  129. ration_glj.shortName = glj.shortName;
  130. ration_glj.type = glj.gljType;
  131. ration_glj.repositoryId = glj.repositoryId;
  132. ration_glj.adjCoe = glj.adjCoe;
  133. getInfoFromProjectGLJ(ration_glj).then(function (info) {
  134. if (info) {
  135. let tem = {};
  136. tem.newRecode = createNewRecord(info);
  137. tem.showData = info;
  138. result.datas.push(tem);
  139. cb(null, result);
  140. } else {
  141. cb(new Error('get project glj error'), null);
  142. }
  143. });
  144. } else {
  145. cb(null, result);
  146. }
  147. })
  148. }
  149. }
  150. function createNewRecord(ration_glj) {
  151. let newRecoed = {};
  152. newRecoed.ID = ration_glj.ID;
  153. newRecoed.projectID = ration_glj.projectID;
  154. newRecoed.GLJID = ration_glj.GLJID;
  155. newRecoed.rationID = ration_glj.rationID;
  156. newRecoed.rationItemQuantity = ration_glj.rationItemQuantity;
  157. newRecoed.quantity = ration_glj.quantity;
  158. newRecoed.name = ration_glj.name;
  159. newRecoed.code = ration_glj.code;
  160. newRecoed.original_code = ration_glj.original_code;
  161. newRecoed.unit = ration_glj.unit;
  162. newRecoed.specs = ration_glj.specs;
  163. newRecoed.from = ration_glj.from ? ration_glj.from : 'std';
  164. newRecoed.createType = ration_glj.createType ? ration_glj.createType : 'normal';
  165. newRecoed.shortName = ration_glj.shortName;
  166. newRecoed.billsItemID = ration_glj.billsItemID;
  167. newRecoed.type = ration_glj.type;
  168. newRecoed.model = ration_glj.model;
  169. newRecoed.repositoryId = ration_glj.repositoryId;
  170. newRecoed.projectGLJID = ration_glj.projectGLJID;
  171. newRecoed.adjCoe = ration_glj.adjCoe;
  172. return newRecoed
  173. }
  174. async function getInfoFromProjectGLJ(ration_glj,unitPriceFileId,ext) {
  175. let data = getGLJSearchInfo(ration_glj);
  176. try {
  177. let projectGljModel = new GLJListModel();
  178. let result = await projectGljModel.addList(data,unitPriceFileId,ext);
  179. let typeString = result.type+"";
  180. ration_glj.marketPrice = result.unit_price.market_price;
  181. ration_glj.adjustPrice = result.unit_price.base_price;
  182. ration_glj.basePrice = result.unit_price.base_price;
  183. ration_glj.projectGLJID = result.id;
  184. if (typeString.startsWith("2")||typeString=='4'||typeString=='5') {//只有材料类型才显示是否暂估
  185. ration_glj.isEstimate = result.is_evaluate;
  186. }
  187. if (result.hasOwnProperty('subList') && result.subList.length > 0) {
  188. ration_glj.subList = getMixRatioShowDatas(result.subList);
  189. }
  190. return ration_glj;
  191. } catch (err) {
  192. logger.err(err);
  193. return null;
  194. }
  195. }
  196. function getMixRatioShowDatas(subList) {
  197. var temRationGLJs = [];
  198. for (let pg of subList) {
  199. var tem = {
  200. projectGLJID: pg.id,
  201. code: pg.code,
  202. name: pg.name,
  203. specs: pg.specs,
  204. unit: pg.unit,
  205. shortName: pg.unit_price.short_name,
  206. rationItemQuantity: pg.ratio_data.consumption,
  207. basePrice: pg.unit_price.base_price,
  208. marketPrice: pg.unit_price.market_price,
  209. adjustPrice: pg.adjust_price,
  210. isEstimate: pg.is_evaluate,
  211. isMixRatio: true,
  212. isAdd: pg.unit_price.is_add,
  213. GLJID: pg.glj_id
  214. }
  215. temRationGLJs.push(tem);
  216. }
  217. temRationGLJs = _.sortBy(temRationGLJs, 'code');
  218. return temRationGLJs;
  219. }
  220. function create_ration_glj(user_id, datas) {
  221. return function (callback) {
  222. let ration_glj_list = datas.ration_glj_list;
  223. var tasks = [];
  224. tasks.push(startingTask("get glj info"))
  225. for (let i = 0; i < ration_glj_list.length; i++) {
  226. ration_glj_list[i].ID = uuidV1();
  227. tasks.push(get_lib_glj_info(ration_glj_list[i]))
  228. }
  229. async_n.waterfall(tasks, (err, results) => {
  230. if (err) {
  231. callback(err, results)
  232. } else {
  233. let newRecords = [];
  234. let showDatas = [];
  235. for (let r of results.datas) {
  236. if (r) {
  237. newRecords.push(r.newRecode);
  238. showDatas.push(r.showData);
  239. }
  240. }
  241. if (newRecords.length > 0) {
  242. ration_glj.insertMany(newRecords, (err, doc) => {
  243. if (err) {
  244. callback(err, null);
  245. } else {
  246. let returndata = {
  247. updateTpye: commonConsts.UT_CREATE,
  248. moduleName: 'ration_glj',
  249. data: {
  250. newRecords: newRecords,
  251. showDatas: showDatas
  252. }
  253. }
  254. callback(null, returndata)
  255. }
  256. });
  257. } else {
  258. logger.info("can't find gljs")
  259. callback(null, null)
  260. }
  261. }
  262. })
  263. }
  264. }
  265. function update_ration_glj(user_id, datas) {
  266. if (datas.updateFunction) {
  267. return updateFunctionMap[datas.updateFunction](user_id, datas);
  268. } else {
  269. return normalUpdate(user_id, datas);
  270. }
  271. }
  272. function normalUpdate(user_id, datas) {
  273. return function (callback) {
  274. ration_glj.update(datas.query, datas.doc, (err, result) => {
  275. if (err) {
  276. callback(err, '');
  277. } else {
  278. let returndata = {
  279. moduleName: 'ration_glj',
  280. data: {
  281. updateTpye: commonConsts.UT_UPDATE,
  282. query: datas.query,
  283. doc: datas.doc
  284. }
  285. }
  286. callback(null, returndata)
  287. }
  288. })
  289. }
  290. }
  291. async function doCustomQuantityUpdate(datas) {
  292. let result = await ration_glj.findOneAndUpdate(datas.query, datas.doc);
  293. let cal_result = await glj_calculate_facade.calculateQuantity({
  294. projectID: datas.query.projectID,
  295. rationID: datas.query.rationID
  296. });
  297. cal_result.glj_result.forEach(function (item) {
  298. if (!item.doc.hasOwnProperty('customQuantity')) {
  299. item.doc.customQuantity = null;
  300. }
  301. });
  302. return cal_result;
  303. }
  304. function delete_ration_glj(user_id, datas) {
  305. return function (callback) {
  306. deleteByID(datas, callback);
  307. //callback(new Error("删除子数据失败!"),null)
  308. //这个方法已经不用,先注释,稳定后再删除
  309. /* if (datas.deleteType == "RATION") {
  310. deleteByRation(datas, callback);
  311. } else if (datas.deleteType == "BILL") {
  312. deleteByBill(user_id, datas, callback);
  313. } else {
  314. deleteByID(datas, callback);
  315. }*/
  316. }
  317. }
  318. function deleteByRation(datas, callback) {
  319. let data = datas.updateData;
  320. let tasks = [];
  321. tasks.push(deleteGLJList(data));
  322. tasks.push(ration_coe_facade.delete_ration_coe(data));
  323. tasks.push(quantity_detail_facade.deleteByRation(data));
  324. tasks.push(ration_installation_facade.deleteByRation(data));
  325. async_n.parallel(tasks, function (err, result) {
  326. commonCallback(callback, result, err)
  327. })
  328. }
  329. function deleteGLJList(data) {
  330. return function (callback) {
  331. ration_glj.deleteMany({projectID: data.projectID, rationID: data.ID}, (err, result) => {
  332. commonCallback(callback, result, err)
  333. });
  334. }
  335. }
  336. function deleteByBill(user_id, datas, callback) {
  337. let tasks = [];
  338. tasks.push(startingTask("deleteByBill"));
  339. tasks.push(getRationsByBill(datas));
  340. tasks.push(deleteRationsbyBill(user_id, datas));
  341. tasks.push(deleteByMultiRations(datas));
  342. async_n.waterfall(tasks, function (err, results) {
  343. if (err) {
  344. callback(err, '');
  345. } else {
  346. callback(null, results);
  347. }
  348. })
  349. }
  350. function deleteByID(datas, callback) {
  351. deleteAndUpdateState(datas).then(function (result) {
  352. if (result.err) {
  353. callback(result.err, '');
  354. } else {
  355. let returndata = {
  356. moduleName: 'ration_glj',
  357. data: {
  358. updateTpye: commonConsts.UT_DELETE,
  359. query: datas.query,
  360. adjustState: result.adjustState
  361. }
  362. }
  363. callback(null, returndata)
  364. }
  365. })
  366. }
  367. async function deleteGLJ(IDs) {
  368. await ration_glj.deleteMany({'ID': {$in: IDs}});
  369. }
  370. async function deleteAndUpdateState(datas) {
  371. let result = {
  372. err: null
  373. }
  374. try {
  375. await ration_glj.deleteOne(datas.query);
  376. let stateResult = await glj_calculate_facade.calculateQuantity({
  377. projectID: datas.query.projectID,
  378. rationID: datas.doc.rationID
  379. });
  380. result.adjustState = stateResult.adjustState;
  381. } catch (err) {
  382. result.err = err;
  383. }
  384. return result;
  385. }
  386. function startingTask(processName) {
  387. return function (asyncCallBack) {
  388. var result = {
  389. processName: processName,
  390. datas: []
  391. };
  392. asyncCallBack(null, result);
  393. };
  394. }
  395. function getRationsByBill(datas) {
  396. return function (results, callback) {
  397. ration.find({
  398. projectID: datas.updateData.projectID,
  399. billsItemID: datas.updateData.ID
  400. }, function (err, rations) {
  401. if (err) {
  402. callback(err, '')
  403. } else {
  404. results.rations = rations;
  405. callback(null, results)
  406. }
  407. })
  408. }
  409. }
  410. function deleteRationsbyBill(user_id, datas) {
  411. return function (results, callback) {
  412. let deleteInfo = {
  413. deleteInfo: {deleted: true, deleteDateTime: new Date(), deleteBy: user_id}
  414. };
  415. ration.update({
  416. projectID: datas.updateData.projectID,
  417. billsItemID: datas.updateData.ID
  418. }, deleteInfo, {multi: true}, (err, deleteresults) => {
  419. if (err) {
  420. callback(err, '');
  421. } else {
  422. callback(null, results);
  423. }
  424. });
  425. }
  426. }
  427. function deleteByMultiRations(datas) {
  428. return function (results, deleteCallBack) {
  429. var delete_tasks = [];
  430. var deleteOne = function (ration) {
  431. return function (callback) {
  432. ration_glj.deleteMany({projectID: ration.projectID, rationID: ration.ID}, function (err, result) {
  433. commonCallback(callback, result, err)
  434. });
  435. }
  436. }
  437. let rations = results.rations;
  438. for (let i = 0; i < rations.length; i++) {
  439. delete_tasks.push(deleteOne(rations[i]._doc));
  440. delete_tasks.push(ration_coe_facade.delete_ration_coe(rations[i]._doc));
  441. delete_tasks.push(quantity_detail_facade.deleteByRation(rations[i]._doc));
  442. delete_tasks.push(ration_installation_facade.deleteByRation(rations[i]._doc));
  443. }
  444. delete_tasks.push(quantity_detail_facade.deleteByBill(datas.updateData));
  445. async_n.parallel(delete_tasks, (err, results) => {
  446. if (err) {
  447. deleteCallBack(err, '')
  448. } else {
  449. deleteCallBack(null, results)
  450. }
  451. })
  452. }
  453. }
  454. /*
  455. function deleteByRation(doc) {
  456. return function (callback){
  457. ration_glj.deleteMany({projectID: doc.updateData.projectID, rationID: doc.updateData.ID},callback);
  458. }
  459. }
  460. */
  461. function save(user_id, datas, callback) {
  462. let operations = [];
  463. if (_.isArray(datas)) {
  464. for (let i = 0; i < datas.length; i++) {
  465. operations.push(operationMap[datas[i].updateType](user_id, datas[i]));
  466. }
  467. } else {
  468. operations.push(operationMap[datas.updateType](user_id, datas));
  469. }
  470. async_n.parallel(operations, function (err, results) {
  471. if (err) {
  472. callback(err, '');
  473. } else {
  474. if (results.length == 1) {
  475. callback(null, results[0])
  476. } else {
  477. callback(null, results)
  478. }
  479. }
  480. })
  481. }
  482. async function getLibInfo(req) {
  483. let gljLibId = null, engineerID, sessionCompilation = req.session.sessionCompilation;
  484. engineerID = req.params.engineerID;
  485. if(engineerID){
  486. gljLibId = await getGLJLibByEngineerID(engineerID);
  487. }else {
  488. throw new Error("工程专业ID为空!");
  489. }
  490. let data = {
  491. userID: req.session.sessionUser.id,
  492. gljLibId: gljLibId,
  493. compilationId: sessionCompilation._id
  494. };
  495. return data;
  496. }
  497. async function getGLJLibByEngineerID (engineerID) {
  498. let engineeringLibModel = new EngineeringLibModel() ;
  499. let engineeringInfo = await engineeringLibModel.findDataByCondition({'_id': engineerID});
  500. let gljLibId = engineeringInfo.glj_lib.length > 0 && typeof engineeringInfo.glj_lib !== 'undefined' ? engineeringInfo.glj_lib[0].id : null;
  501. return gljLibId
  502. }
  503. function getGLJData(info, callback) {
  504. let gljDao = new GljDao();
  505. let datas = {};
  506. let gljDistTypeCache = stdgljutil.getStdGljTypeCacheObj().toArray();
  507. datas.distTypeTree = gljDistTypeCache;
  508. async_n.parallel([
  509. async function (cb) {
  510. try {
  511. datas.treeData = await gljDao.getMixedTree(info.gljLibId, info.userID, info.compilationId);
  512. cb(null);
  513. } catch (err) {
  514. cb(err);
  515. }
  516. },
  517. function (cb) {
  518. gljDao.getGljItems(info.gljLibId, info.userID, info.compilationId, function (err, data) {
  519. if (err) {
  520. cb(err);
  521. } else {
  522. datas.stdGLJ = data.stdGljs;
  523. datas.complementaryGLJs = data.complementaryGljs;
  524. cb(null);
  525. }
  526. });
  527. }
  528. ], function (err) {
  529. if (err) {
  530. callback(true, null);
  531. }
  532. else {
  533. callback(false, datas);
  534. }
  535. })
  536. }
  537. function getGLJSearchInfo(ration_glj) {
  538. let data = {
  539. glj_id: ration_glj.GLJID,
  540. project_id: ration_glj.projectID,
  541. code: ration_glj.code,
  542. original_code: ration_glj.original_code,
  543. name: ration_glj.name,
  544. //shortName: ration_glj.shortName,
  545. specs: ration_glj.specs,
  546. unit: ration_glj.unit,
  547. type: ration_glj.subType ? ration_glj.subType : ration_glj.type,//如果有subType,则是通过插入定额级的工料机进来的
  548. model: ration_glj.model,
  549. type_of_work: ration_glj.subType ? ration_glj.subType : ration_glj.type,
  550. base_price: ration_glj.basePrice,
  551. market_price: ration_glj.marketPrice,
  552. repositoryId: ration_glj.repositoryId,
  553. adjCoe: ration_glj.adjCoe,
  554. materialType:ration_glj.materialType,
  555. materialCoe:ration_glj.materialCoe,
  556. grossWeightCoe:ration_glj.grossWeightCoe,
  557. purchaseStorageRate:ration_glj.purchaseStorageRate,
  558. offSiteTransportLossRate:ration_glj.offSiteTransportLossRate,
  559. handlingLossRate:ration_glj.handlingLossRate,
  560. from: ration_glj.from ? ration_glj.from : 'std'//std:标准工料机库, cpt:补充工料机库
  561. };
  562. let glj_type_object = glj_type_util.getStdGljTypeCacheObj();
  563. let type = glj_type_object.getItemById(data.type);
  564. data.shortName = type.shortName;
  565. if (data.from == 'cpt') {//从补充工料机来的数据即为新增数据
  566. data.is_add = 1;
  567. }
  568. return data;
  569. }
  570. async function prepareExtData(projectID,compilation) {
  571. let ext , unitFileId ;
  572. let property = await projectDao.getProjectProperty(projectID);
  573. ext = projectDao.getExtendData(property,compilation);
  574. unitFileId = property.unitPriceFile !== undefined ? property.unitPriceFile.id : 0;
  575. return [unitFileId,ext];
  576. }
  577. async function addGLJ(rgList,compilation) {
  578. if (rgList.length <= 0) return {};
  579. let newRecodes = await insertAddTypeGLJ(rgList,compilation);
  580. let stateResult = await glj_calculate_facade.calculateQuantity({
  581. projectID: rgList[0].projectID,
  582. rationID: rgList[0].rationID
  583. });
  584. let result = {
  585. newRecodes: newRecodes,
  586. showData: rgList,
  587. adjustState: stateResult.adjustState
  588. };
  589. return result;
  590. }
  591. async function insertAddTypeGLJ(rgList,compilation) {
  592. let newRecodes = [],GLJMap=null;
  593. let [unitFileId,ext] = await prepareExtData(rgList[0].projectID,compilation);
  594. for (let g of rgList) {
  595. let projectGljModel = new GLJListModel();
  596. let result = await projectGljModel.addList(getGLJSearchInfo(g),unitFileId,ext);
  597. let typeString = result.type+'';
  598. g.marketPrice = result.unit_price.market_price;
  599. g.adjustPrice = result.unit_price.base_price;
  600. g.basePrice = result.unit_price.base_price;
  601. g.isAdd = result.unit_price.is_add;
  602. g.projectGLJID = result.id;
  603. if (typeString.startsWith("2")||typeString=='4'||typeString=='5') {//只有材料类型才显示是否暂估
  604. g.isEstimate = result.is_evaluate;
  605. }
  606. g.ID = uuidV1();
  607. if (result.hasOwnProperty('subList') && result.subList.length > 0) {
  608. g.subList = getMixRatioShowDatas(result.subList);
  609. //对于混凝土,砂浆,配合比,组成物还要插入定额工料机
  610. if(gljUtil.isConcreteType(g.type)){
  611. if(GLJMap == null){
  612. let oldGLJList = await ration_glj.find({'rationID':g.rationID});
  613. GLJMap = _.indexBy(oldGLJList,"projectGLJID");
  614. }
  615. addMixRatioToRationGLJ(g,result.subList,newRecodes,GLJMap);
  616. }
  617. }
  618. newRecodes.push(createNewRecord(g));
  619. }
  620. await ration_glj.insertMany(newRecodes);
  621. return newRecodes;
  622. }
  623. async function deleteRationGLJ(data){
  624. let deleteIDs = [data.ID];
  625. if(gljUtil.isConcreteType(data.type)){//如果是混凝土、砂浆、配合比,还要删除没有被引用的组成物工料机
  626. let projectGljModel = new GLJListModel();
  627. let rationGLJList = await ration_glj.find({'rationID':data.rationID});
  628. let unitFileId = await projectDao.getUnitPriceFileId(data.projectID);
  629. let projectGLJMap = {},referenceMap={};
  630. let deleteMix = [];
  631. for(let r of rationGLJList){
  632. projectGLJMap[r.projectGLJID] = r;
  633. if(gljUtil.isConcreteType(r.type)){
  634. if(r.ID == data.ID){//是要删除的工料机
  635. deleteMix = await projectGljModel.getCompositionGLJByData(r,unitFileId);
  636. }else {
  637. let comList = await projectGljModel.getCompositionGLJByData(r,unitFileId);
  638. for(let c of comList){
  639. referenceMap[c.id] = c;
  640. }
  641. }
  642. }
  643. }
  644. for(let d of deleteMix){
  645. //删除不属于其它的组成物并且定额消耗为0
  646. if(referenceMap[d.id]) continue;
  647. if(projectGLJMap[d.id]&&(projectGLJMap[d.id].rationItemQuantity == '0'||projectGLJMap[d.id].rationItemQuantity == 0)){
  648. deleteIDs.push(projectGLJMap[d.id].ID);
  649. }
  650. }
  651. await ration_glj.deleteMany({'ID': {"$in": deleteIDs}});
  652. } else{
  653. await ration_glj.deleteOne({ID:data.ID});
  654. }
  655. let calcResult = await glj_calculate_facade.calculateQuantity({
  656. projectID: data.projectID,
  657. rationID: data.rationID
  658. });
  659. calcResult.deleteList = deleteIDs;
  660. return calcResult;
  661. }
  662. function addMixRatioToRationGLJ(g,subList,newRecodes,GLJMap){
  663. let newMap = {};
  664. for(let mr of subList ){
  665. //先查找该定额下是否已经有了工料机了,有就不用再插入了
  666. newMap[mr.id] = mr;//新增的定额工料机映射表
  667. if(GLJMap[mr.id]||_.find(newRecodes,{'projectGLJID':mr.id})) continue;
  668. //没有的情况下,生成一条定额工料机计录
  669. let newMr = {
  670. projectID:g.projectID,
  671. GLJID:mr.glj_id,
  672. rationID:g.rationID,
  673. rationItemQuantity:0,
  674. quantity:0,
  675. name:mr.name,
  676. code:mr.code,
  677. original_code:mr.original_code,
  678. unit:mr.unit,
  679. specs:mr.specs,
  680. from:mr.from,
  681. createType:g.createType,
  682. shortName:mr.unit_price.short_name,
  683. billsItemID:g.billsItemID,
  684. type:mr.type,
  685. model:mr.model,
  686. repositoryId:g.repositoryId,
  687. projectGLJID:mr.id,
  688. adjCoe:mr.adjCoe
  689. };
  690. newMr.ID = uuidV1();
  691. newRecodes.push(newMr);
  692. }
  693. return newMap;
  694. }
  695. async function replaceGLJByData(data,compilation) {
  696. let projectGljModel = new GLJListModel();
  697. let [unitFileId,ext] = await prepareExtData(data.projectID,compilation);
  698. let result = await projectGljModel.addList(getGLJSearchInfo(data),unitFileId,ext);
  699. let typeString = result.type+'';
  700. data.projectGLJID = result.id;
  701. // CompositionGLJ=await this.getCompositionGLJByData(data,unitPriceFileId);
  702. let [newRecodes,deleteList] = await replaceMixRatio(data,result,unitFileId);
  703. let updateResult = await ration_glj.findOneAndUpdate({ID: data.ID, projectID: data.projectID}, data);//更新定额工料机
  704. //组装回传数据
  705. data.marketPrice = result.unit_price.market_price;
  706. data.adjustPrice = result.unit_price.base_price;
  707. data.basePrice = result.unit_price.base_price;
  708. data.isAdd = result.unit_price.is_add;
  709. if (typeString.startsWith("2")||typeString=='4'||typeString=='5') {//只有材料类型才显示是否暂估
  710. data.isEstimate = result.is_evaluate;
  711. }
  712. if (result.hasOwnProperty('subList') && result.subList.length > 0) {
  713. data.subList = getMixRatioShowDatas(result.subList);
  714. }
  715. return {data:data,newRecodes:newRecodes,deleteList:deleteList};
  716. }
  717. async function replaceMixRatio(g,result,unitFileId){
  718. let newRecodes=[],deleteList = [];
  719. if(gljUtil.isConcreteType(g.type)||gljUtil.isCommercialConcreteType(g.type)){//混凝土大类,商品混凝土属于相同大类,替换前和替换后只判断一个就好了
  720. let IDMap = {}, projectGLJMap = {},referenceMap={},concreteList=[],newMap={};
  721. let projectGljModel = new GLJListModel();
  722. let rationGLJList = await ration_glj.find({'rationID':g.rationID});
  723. for(let r of rationGLJList){
  724. IDMap[r.ID] = r;
  725. projectGLJMap[r.projectGLJID] = r;
  726. if(gljUtil.isConcreteType(r.type)&&r.ID!=g.ID) concreteList.push(r) //除了本身,记录一下其它混凝土类型
  727. }
  728. if (result.hasOwnProperty('subList') && result.subList.length > 0){
  729. newMap = addMixRatioToRationGLJ(g,result.subList,newRecodes,projectGLJMap);//先生成要添加的工料机
  730. }
  731. let oldMixList = await projectGljModel.getCompositionGLJByData(IDMap[g.ID],unitFileId);
  732. for(let c of concreteList){//找出要删除的子定额工料机(没人引用,并且定额消耗量为0)
  733. let temList = await projectGljModel.getCompositionGLJByData(c,unitFileId);
  734. for(let t of temList){
  735. referenceMap[t.id] = t;
  736. }
  737. }
  738. for(let o of oldMixList){
  739. if(newMap[o.id]||referenceMap[o.id]) continue;//如果两个地方有一个存在,那么就不用删除
  740. //没有被其它地方引用并且定额消耗量为0,就删除对应的定额工料机
  741. if(projectGLJMap[o.id] && (projectGLJMap[o.id].rationItemQuantity == '0'||projectGLJMap[o.id].rationItemQuantity == 0)) deleteList.push(projectGLJMap[o.id].ID)
  742. }
  743. }
  744. if(deleteList.length > 0) await ration_glj.deleteMany({'ID': {"$in": deleteList}});//删除定额工料机
  745. if(newRecodes.length > 0) await ration_glj.insertMany(newRecodes);
  746. return [newRecodes,deleteList]
  747. }
  748. async function replaceGLJ(data,compilation) {
  749. let rdata = {};
  750. let r_result =await replaceGLJByData(data,compilation);
  751. data = r_result.data;
  752. let stateResult = await glj_calculate_facade.calculateQuantity({
  753. projectID: data.projectID,
  754. rationID: data.rationID
  755. }, null,true);
  756. rdata.data = data;
  757. rdata.adjustState = stateResult.adjustState;
  758. rdata.name = stateResult.rationName;
  759. rdata.newRecodes = r_result.newRecodes;
  760. rdata.deleteList = r_result.deleteList;
  761. rdata.glj_result = stateResult.glj_result;
  762. return rdata;
  763. }
  764. async function replaceMixRatioForMReplace(tasks,result,unitFileId) {
  765. let allNewRecodes = [],allDeleteList=[];
  766. for(let t of tasks){
  767. let tem = _.cloneDeep(t.updateOne.update);
  768. tem.ID = t.updateOne.filter.ID;
  769. tem.rationID = t.updateOne.filter.rationID;
  770. delete t.updateOne.filter.rationID;
  771. let [newRecodes,deleteList] = await replaceMixRatio(tem,result,unitFileId);
  772. allNewRecodes = allNewRecodes.concat(newRecodes);
  773. allDeleteList = allDeleteList.concat(deleteList);
  774. }
  775. return {newRecodes:allNewRecodes,deleteList:allDeleteList}
  776. }
  777. async function mReplaceGLJ(data,compilation) {
  778. let mresult = {},mixResult = null,noNeedCal=true;
  779. let projectGljModel = new GLJListModel();
  780. let [unitFileId,ext] = await prepareExtData(data.doc.projectID,compilation);
  781. //
  782. let result = await projectGljModel.addList(getGLJSearchInfo(data.doc),unitFileId,ext);
  783. let typeString = result.type+'';
  784. let newDoc = {};
  785. newDoc.projectGLJID = result.id;
  786. let rationList = [];//await ration_glj.distinct('rationID', data.query);
  787. for(let t of data.tasks){
  788. rationList.push(t.updateOne.filter.rationID);
  789. t.updateOne.update.projectGLJID = result.id;//更新项目工料机ID
  790. }
  791. if(gljUtil.isConcreteType(result.unit_price.type)) {
  792. mixResult = await replaceMixRatioForMReplace(data.tasks,result,unitFileId);
  793. noNeedCal = null;
  794. }
  795. await ration_glj.bulkWrite(data.tasks);
  796. newDoc.marketPrice = result.unit_price.market_price;
  797. newDoc.adjustPrice = result.unit_price.base_price;
  798. newDoc.basePrice = result.unit_price.base_price;
  799. newDoc.isAdd = result.unit_price.is_add;
  800. if (typeString.startsWith("2")||typeString=='4'||typeString=='5') {//只有材料类型才显示是否暂估
  801. newDoc.isEstimate = result.is_evaluate;
  802. }
  803. if (result.hasOwnProperty('subList') && result.subList.length > 0) {
  804. newDoc.subList = getMixRatioShowDatas(result.subList);
  805. }
  806. let [stateList,glj_result] = await changAdjustState(data, rationList,noNeedCal);
  807. data.doc = newDoc;
  808. mresult.data = data;
  809. mresult.stateList = stateList;
  810. mresult.newRecodes = mixResult?mixResult.newRecodes:[];
  811. mresult.deleteList = mixResult?mixResult.deleteList:[];
  812. mresult.glj_result = glj_result;
  813. return mresult
  814. }
  815. async function updateRationGLJByEdit(data) {
  816. var doc = data.doc;
  817. var result;
  818. if (doc.hasOwnProperty('customQuantity')) {
  819. result = await doCustomQuantityUpdate(data)
  820. } else {
  821. result = await doRationGLJUpdate(data);
  822. }
  823. return result;
  824. }
  825. async function updateRationGLJFromDoc(rg,doc,priceInfo) {
  826. let gljListModel = new GLJListModel();
  827. let projectGLJ = getGLJSearchInfo(rg);
  828. for (let key in doc) {
  829. projectGLJ[key] = doc[key]
  830. }
  831. projectGLJ.base_price = priceInfo.base_price;
  832. projectGLJ.market_price = priceInfo.market_price;
  833. let projcetGLJ_n = await gljListModel.modifyGLJ(projectGLJ, rg);
  834. doc.code = projcetGLJ_n.code;
  835. doc.projectGLJID = projcetGLJ_n.id;
  836. if (projcetGLJ_n.unit_price.is_add == 1) {
  837. doc.createType = 'replace';
  838. doc.rcode = projcetGLJ_n.original_code;
  839. } else {
  840. doc.createType = 'normal';
  841. doc.rcode = '';
  842. }
  843. await ration_glj.findOneAndUpdate({ID:rg.ID}, doc);
  844. return [projcetGLJ_n,doc]
  845. }
  846. async function doRationGLJUpdate(data) {
  847. let resutl = {};
  848. let priceInfo = data.priceInfo;
  849. let rg = await ration_glj.findOne(data.query);
  850. let [projcetGLJ_n,doc] = await updateRationGLJFromDoc(rg,data.doc,priceInfo);
  851. //取价格
  852. let gljListModel = new GLJListModel();
  853. gljListModel.getGLJPrice(projcetGLJ_n);
  854. doc.basePrice = projcetGLJ_n.unit_price.base_price;
  855. doc.marketPrice = projcetGLJ_n.unit_price.market_price;
  856. doc.adjustPrice = projcetGLJ_n.adjust_price;
  857. doc.isAdd = projcetGLJ_n.unit_price.is_add;
  858. resutl.doc = doc;
  859. let stateResult = await glj_calculate_facade.calculateQuantity({
  860. projectID: data.query.projectID,
  861. rationID: data.query.rationID
  862. },null,true);
  863. resutl.adjustState = stateResult.adjustState;
  864. resutl.name = stateResult.rationName;
  865. return resutl;
  866. }
  867. async function getGLJClass(info, data) {
  868. let result = {
  869. exist: false
  870. }
  871. //检查补充工料机中是否已经存在一样的记录了
  872. let condition = {
  873. userId: info.userID,
  874. compilationId: info.compilationId,
  875. code: data.code,
  876. name: data.name,
  877. unit: data.unit,
  878. gljType: data.type,
  879. basePrice: data.basePrice
  880. }
  881. if (data.specs != null && data.specs != undefined && data.specs != '') {
  882. condition['specs'] = data.specs;
  883. }
  884. let glj = await complementaryGljModel.find(condition);
  885. if (glj.length > 0) { //如果已存在就直接返回,不用再新增了
  886. result.exist = true;
  887. return result
  888. }
  889. //查找工料机类型树
  890. let items = await compleClassModel.find({
  891. userId: info.userID,
  892. compilationId: info.compilationId
  893. });
  894. result.items = items;
  895. return result;
  896. }
  897. async function insertGLJAsRation(data,compilation) {
  898. let gljList = data.gljList;
  899. if (data.hasOwnProperty("selectedSerialNo")) { //如果需要,更新序列号。
  900. let query = {
  901. projectID: data.projectID,
  902. billsItemID: data.billsItemID,
  903. serialNo: {$gt: data.selectedSerialNo}
  904. }
  905. await ration.update(query, {$inc: {serialNo: gljList.length}}, {multi: true});
  906. }
  907. let [unitFileId,ext] = await prepareExtData(data.projectID,compilation);
  908. for (let glj of gljList) {
  909. let p_glj = getGLJSearchInfo(glj);
  910. let projectGljModel = new GLJListModel();
  911. let result = await projectGljModel.addList(p_glj,unitFileId,ext);//逐条添加到项目工料机
  912. let typeString = result.type+'';
  913. glj.marketPrice = result.unit_price.market_price;
  914. glj.adjustPrice = result.unit_price.base_price;
  915. glj.basePrice = result.unit_price.base_price;
  916. glj.isAdd = result.unit_price.is_add;
  917. glj.projectGLJID = result.id;
  918. if (typeString.startsWith("2")||typeString=='4'||typeString=='5') {//只有材料类型才显示是否暂估
  919. glj.isEstimate = result.is_evaluate;
  920. }
  921. }
  922. await ration.insertMany(gljList);
  923. return gljList;
  924. }
  925. async function getRationTypeGLJQuantity(projectID) {
  926. let rations = await ration.find({'projectID': projectID,'type':3,'deleteInfo': null}, ['ID', 'projectGLJID','quantity']);
  927. return rations;
  928. }
  929. async function changAdjustState(data, rationList,noNeedCal) {
  930. let stateList = [],glj_result=[];
  931. for (let r of rationList) {
  932. let stateResult = await glj_calculate_facade.calculateQuantity({
  933. projectID: data.query.projectID,
  934. rationID: r
  935. }, noNeedCal,true);
  936. if(stateResult){
  937. stateList.push({rationID: r, adjustState: stateResult.adjustState,name:stateResult.rationName});
  938. glj_result = glj_result.concat(stateResult.glj_result)
  939. }
  940. }
  941. return [stateList,glj_result];
  942. }
  943. async function getGLJDataByCodes(data,compilation) {
  944. let gljLibId = await getGLJLibByEngineerID(data.engineerID);
  945. let gljDatas = [];
  946. if(gljLibId){
  947. let stdList = await std_glj_lib_gljList_model.find({'repositoryId':gljLibId,code:{'$in':data.codes}});
  948. if(stdList.length > 0){
  949. let property = await projectDao.getProjectProperty(data.projectID);
  950. let ext = projectDao.getExtendData(property,compilation);//多单价处理
  951. for(let s of stdList){
  952. let tem = JSON.parse(JSON.stringify(s));
  953. if(ext && ext.priceField && tem && tem.priceProperty){
  954. tem.basePrice = tem.priceProperty[ext.priceField];
  955. }
  956. gljDatas.push(tem);
  957. }
  958. }
  959. }
  960. return gljDatas
  961. }
  962. async function testError() {
  963. throw new Error('test Error');
  964. }
  965. function getData(projectID, callback) {
  966. ration_glj.find({'projectID': projectID}, (err, datas) => {
  967. if (err) {
  968. callback(1, '', null);
  969. } else {
  970. callback(0, consts.projectConst.RATION_GLJ, datas);
  971. }
  972. })
  973. }
  974. function commonCallback(callback, result, err) {
  975. if (err) {
  976. callback(err, '');
  977. } else {
  978. callback(null, result);
  979. }
  980. }