ration_glj_facade.js 38 KB

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