ration_glj_facade.js 35 KB

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