ration_glj_facade.js 40 KB

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