glj_controller.js 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935
  1. /**
  2. * 工料机相关控制器
  3. *
  4. * @author CaiAoLin
  5. * @date 2017/6/22
  6. * @version
  7. */
  8. import BaseController from "../../common/base/base_controller";
  9. import GLJTypeConst from "../../common/const/glj_type_const";
  10. import GLJListModel from "../models/glj_list_model";
  11. import UnitPriceModel from "../models/unit_price_model";
  12. import MixRatioModel from "../models/mix_ratio_model";
  13. import UnitPriceFileModel from "../models/unit_price_file_model";
  14. let logger = require("../../../logs/log_helper").logger;
  15. let consts = require('../../main/models/project_consts');
  16. let glj_type_util = require('../../../public/cache/std_glj_type_util');
  17. let ration_glj_facade = require('../../ration_glj/facade/ration_glj_facade');
  18. let EngineeringLibModel = require("../../users/models/engineering_lib_model");
  19. let mongoose = require('mongoose');
  20. let original_calc_model = mongoose.model('original_calc');
  21. let freight_calc_model = mongoose.model('freight_calc');
  22. let com_electrovalence_model = mongoose.model('com_electrovalence');
  23. let ration = mongoose.model('ration');
  24. let projectModel = mongoose.model('projects');
  25. let _ = require('lodash');
  26. let glj_facade = require('../facade/glj_facade');
  27. let gljUtil = require('../../../public/gljUtil');
  28. const ProjectModel = require('../../pm/models/project_model').project;
  29. class GLJController extends BaseController {
  30. /**
  31. * 构造函数
  32. *
  33. * @return {void}
  34. */
  35. constructor() {
  36. let parent = super();
  37. parent.title = '工料机';
  38. }
  39. /**
  40. * 获取工料机相关数据
  41. *
  42. * @param {object} request
  43. * @param {object} response
  44. * @return {void}
  45. */
  46. async getGljList(request, response) {
  47. // 标段id
  48. let projectId = request.body.project_id;
  49. projectId = parseInt(projectId);
  50. let responseData = await getGLJListByProjectID(projectId);
  51. responseData.hostname = request.hostname;
  52. response.json(responseData);
  53. }
  54. /**
  55. * project getData 接口
  56. * @param projectID
  57. * @param callback
  58. */
  59. getData(projectID, callback){
  60. let start = +new Date();
  61. getGLJListByProjectID(projectID).then(function(result){
  62. let end = +new Date();
  63. console.log("项目工料机模块取数据总时间-----"+(end - start));
  64. callback(result.err,consts.projectConst.PROJECTGLJ,result.data);
  65. })
  66. }
  67. /**
  68. * 更新数据
  69. *
  70. * @param {object} request
  71. * @param {object} response
  72. * @return {void}
  73. */
  74. async updateData(request, response) {
  75. let field = request.body.field;
  76. let value = request.body.value;
  77. let extend = request.body.extend;
  78. value = value === 'true' ? 1 : value;
  79. value = value === 'false' ? 0 : value;
  80. let id = request.body.id;
  81. let responseData = {
  82. err: 0,
  83. msg: ''
  84. };
  85. try {
  86. // 可编辑的字段
  87. let editableField = ['is_evaluate', 'unit_price.market_price', 'is_adjust_price', 'mix_ratio.consumption',
  88. 'supply', 'supply_quantity','delivery_address','delivery','materialType','materialCoe','is_main_material','remark'];
  89. if (editableField.indexOf(field) < 0) {
  90. throw '对应字段不能编辑';
  91. }
  92. let modelString = 'glj';
  93. // 切割字段
  94. let fieldArray = field.split('.');
  95. modelString = fieldArray.length > 1 ? fieldArray[0] : modelString;
  96. field = fieldArray.length > 1 ? fieldArray[1] : field;
  97. // 组合数据
  98. let updateData = new Object();
  99. updateData[field] = value;
  100. let result = false;
  101. let model = null;
  102. switch (modelString) {
  103. case 'glj':
  104. if (extend&&extend !== '') {
  105. extend = JSON.parse(extend);
  106. for (let code in extend) {
  107. updateData[code] = extend[code];
  108. }
  109. }
  110. console.log(updateData);
  111. model = new GLJListModel();
  112. // 更新数据
  113. result = await model.updateById(id, updateData);
  114. break;
  115. case 'unit_price':
  116. model = new UnitPriceModel();
  117. // 更新数据
  118. result = await model.updatePrice({id: id}, updateData, extend);
  119. break;
  120. case 'mix_ratio':
  121. let marketPrice = request.body.market_price;
  122. let basePrice = request.body.base_price;
  123. model = new MixRatioModel();
  124. result = await model.updateById(id, updateData);
  125. if (result && marketPrice && basePrice) {
  126. // 修改后更新父节点的项目工料机市场单价
  127. let mixRatioData = await model.findDataByCondition({id: id});
  128. if (mixRatioData.length <= 0) {
  129. break;
  130. }
  131. let indexList = ['code','name','specs','unit','type'];
  132. let keyList = mixRatioData.connect_key.split("|-|");
  133. // 更新市场单价和基价单价
  134. let condition = {unit_price_file_id: mixRatioData.unit_price_file_id};
  135. for(let i = 1;i<keyList.length;i++){
  136. if(keyList[i]!='null'){
  137. condition[indexList[i]]=keyList[i];
  138. }
  139. }
  140. let unitPriceUpdate = {
  141. // base_price: basePrice, ---- 20190218 修改机械台班的组成物,仅重新计算机械预算价,定额价保持不变。
  142. market_price: marketPrice
  143. };
  144. let unitPriceModel = new UnitPriceModel();
  145. let unitPriceResult = await unitPriceModel.updatePrice(condition, unitPriceUpdate);
  146. if (!unitPriceResult) {
  147. throw '更新单价数据失败';
  148. }
  149. }
  150. break;
  151. }
  152. if (!result) {
  153. throw '更新失败';
  154. }
  155. } catch (error) {
  156. console.log('error:' + error);
  157. responseData.err = 1;
  158. }
  159. response.json(responseData);
  160. }
  161. /**
  162. * 加载配合比相关数据
  163. *
  164. * @return {void}
  165. */
  166. async getRatio(request, response) {
  167. let projectGLJId = request.body.id;
  168. let projectId = request.body.project_id;
  169. let responseData = {
  170. err: 0,
  171. data: null
  172. };
  173. try {
  174. // 获取标段对应的单价文件id
  175. let unitPriceFileId = await ProjectModel.getUnitPriceFileId(projectId);
  176. if (unitPriceFileId <= 0) {
  177. throw '没有对应的单价文件';
  178. }
  179. let gljListModel = new GLJListModel();
  180. let result = await gljListModel.getCompositionList(projectGLJId, unitPriceFileId);
  181. if (result.length <= 0) {
  182. throw '没有找到数据';
  183. }
  184. responseData.data = JSON.stringify(result);
  185. } catch (error) {
  186. console.log(error);
  187. responseData.err = 1;
  188. }
  189. response.json(responseData);
  190. }
  191. /**
  192. * 删除配合比数据
  193. *
  194. * @param {object} request
  195. * @param {object} response
  196. * @return {void}
  197. */
  198. async deleteMixRatio(request, response) {
  199. let id = request.body.id;
  200. id = parseInt(id);
  201. let responseData = {
  202. err: 0,
  203. msg: ''
  204. };
  205. try {
  206. if (isNaN(id) || id <= 0) {
  207. throw '参数错误';
  208. }
  209. let mixRatioModel = new MixRatioModel();
  210. let result = await mixRatioModel.deleteById(id);
  211. if(request.body.unitPrice){
  212. let unitPrice = JSON.parse(request.body.unitPrice);
  213. let unitPriceModel = new UnitPriceModel();
  214. await unitPriceModel.model.update(unitPrice.query,unitPrice.doc);
  215. }
  216. if (!result) {
  217. throw '删除失败';
  218. }
  219. } catch (error) {
  220. responseData.err = 1;
  221. responseData.msg = error;
  222. }
  223. response.json(responseData);
  224. }
  225. //添加组成物
  226. async addMixRatio(request,response){
  227. let result={
  228. error:0
  229. };
  230. try {
  231. let data = request.body.data;
  232. data = JSON.parse(data);
  233. let gljList = data.gljList, parentInfo = data.parentInfo,mixRatios = [];
  234. let projectGljModel = new GLJListModel();
  235. let mixRatioModel = new MixRatioModel();
  236. if(gljList.length > 0){
  237. let [unitFileId,ext] = await ration_glj_facade.prepareExtData(gljList[0].project_id,request.session.sessionCompilation);
  238. for(let g of gljList){
  239. let newProjectGLJ = await projectGljModel.addList(g,unitFileId,ext);
  240. let mixRatio = {
  241. glj_id:newProjectGLJ.glj_id,
  242. consumption:0,
  243. unit_price_file_id:unitFileId,
  244. connect_key:parentInfo.connect_key,
  245. type: newProjectGLJ.type,
  246. code: newProjectGLJ.code,
  247. specs:newProjectGLJ.specs,
  248. name:newProjectGLJ.name,
  249. unit:newProjectGLJ.unit,
  250. model:newProjectGLJ.model
  251. };
  252. newProjectGLJ.ratio_data = await mixRatioModel.add(mixRatio);
  253. mixRatios.push(newProjectGLJ);
  254. }
  255. }
  256. result.data = mixRatios;
  257. }catch (err){
  258. logger.err(err);
  259. result.error=1;
  260. result.message = err.message;
  261. }
  262. response.json(result);
  263. }
  264. /**
  265. * 获取项目与单价文件对应的数据
  266. *
  267. * @param {object} request
  268. * @param {object} response
  269. * @return {void}
  270. */
  271. async getProjectInfo(request, response) {
  272. if(typeof request.body.data == "string"){
  273. request.body = JSON.parse(request.body.data)
  274. }
  275. let projectId = request.body.project_id;
  276. let rootProjectID = request.body.rootProjectID;
  277. projectId = parseInt(projectId);
  278. const notDeleted = [{deleteInfo: null}, {'deleteInfo.deleted': false}];
  279. let responseData = {
  280. err: 0,
  281. data: null
  282. };
  283. try {
  284. let sessionUserData = request.session.sessionUser;
  285. //获取当前单位工程
  286. let currentTender = await projectModel.findOne({ID: projectId, $or: notDeleted});
  287. // 获取对应用户所有的建设项目数据
  288. let projectList = await ProjectModel.getUserProjectData(sessionUserData.id,request.session.sessionCompilation._id);
  289. //获取对应用户所有文件夹
  290. let folders = await projectModel.find({userID: sessionUserData.id, $or: notDeleted, projType: 'Folder'}, {_id: 0, name: 1, ID: 1, NextSiblingID: 1, ParentID: 1});
  291. if(currentTender === null){
  292. throw '当前单位工程不存在';
  293. }
  294. if (projectList === null) {
  295. throw '没有找到对应的项目数据';
  296. }
  297. // 转换mongoose数据
  298. projectList = JSON.stringify(projectList);
  299. projectList = JSON.parse(projectList);
  300. let result = {
  301. self: [],
  302. other: [],
  303. treeData: []
  304. };
  305. for (let index in projectList) {
  306. // 获取对应的单价文件
  307. let unitPriceFileModel = new UnitPriceFileModel();
  308. let unitPriceFileData = await unitPriceFileModel.getDataByRootProject(projectList[index].ID);
  309. projectList[index].unitPriceList = unitPriceFileData;
  310. // 归类
  311. if (rootProjectID == projectList[index].ID) {
  312. //剔除自身
  313. let currentUsedUF = currentTender.property.unitPriceFile.id;
  314. result.self = _.filter(unitPriceFileData, function (uf) {
  315. return uf.id !== currentUsedUF;
  316. });
  317. result.currentProjectName = projectList[index].name;
  318. } else {
  319. result.other.push(projectList[index]);
  320. }
  321. result.treeData.push({name: projectList[index].name, ID: projectList[index].ID, NextSiblingID: projectList[index].NextSiblingID, ParentID: projectList[index].ParentID});
  322. }
  323. result.treeData = result.treeData.concat(folders);
  324. responseData.data = result;
  325. response.json(responseData);
  326. } catch (error) {
  327. responseData.err = 1;
  328. response.json(responseData);
  329. }
  330. }
  331. /**
  332. * 更改单价文件
  333. *
  334. * @param {object} request
  335. * @param {object} response
  336. * @return {void}
  337. */
  338. async changeUnitPriceFile(request, response) {
  339. let projectId = request.body.project_id;
  340. let changeUnitPriceId = request.body.change_id;
  341. let newName = request.body.newName;
  342. let type = request.body.type;
  343. type = parseInt(type);
  344. let responseData = {
  345. err: 0,
  346. msg: ''
  347. };
  348. try {
  349. responseData.unitFile = await glj_facade.changeUnitFile({projectID:projectId}, {id:changeUnitPriceId,name:newName},type,request.session.sessionUser.id);
  350. } catch (error) {
  351. console.log(error);
  352. responseData.err = 1;
  353. responseData.msg = error;
  354. }
  355. response.json(responseData);
  356. }
  357. async changeVvTaxFile(request, response){
  358. let result={error:0};
  359. try {
  360. let data = JSON.parse(request.body.data);
  361. await glj_facade.changeVvTaxFile(data);
  362. }catch (err){
  363. logger.err(err);
  364. result.error=1;
  365. result.message = err.message;
  366. }
  367. response.json(result);
  368. }
  369. async changeAssistProductionFeeRate(request, response){
  370. let result={error:0};
  371. try {
  372. let data = JSON.parse(request.body.data);
  373. await glj_facade.changeAssistProductionFeeRate(data);
  374. }catch (err){
  375. logger.err(err);
  376. result.error=1;
  377. result.message = err.message;
  378. }
  379. response.json(result);
  380. }
  381. async updateMaterialCalc(request, response){
  382. let result={error:0};
  383. try {
  384. let data = JSON.parse(request.body.data);
  385. result.data = await glj_facade.updateMaterialCalc(data);
  386. }catch (err){
  387. logger.err(err);
  388. result.error=1;
  389. result.message = err.message;
  390. }
  391. response.json(result);
  392. }
  393. async updateMaterialCalcTasks(request, response){
  394. let result={error:0};
  395. try {
  396. let data = JSON.parse(request.body.data);
  397. result.data = await glj_facade.updateMaterialCalcTasks(data);
  398. }catch (err){
  399. logger.err(err);
  400. result.error=1;
  401. result.message = err.message;
  402. }
  403. response.json(result);
  404. }
  405. async insertElectrovalence(request, response){
  406. let result={error:0};
  407. try {
  408. let data = JSON.parse(request.body.data);
  409. result.data = await glj_facade.insertElectrovalence(data,request.session.sessionCompilation._id);
  410. }catch (err){
  411. logger.err(err);
  412. result.error=1;
  413. result.message = err.message;
  414. }
  415. response.json(result);
  416. }
  417. async updateElectrovalence(request, response){
  418. let result={error:0};
  419. try {
  420. let data = JSON.parse(request.body.data);
  421. result.data = await glj_facade.updateElectrovalence(data);
  422. }catch (err){
  423. logger.err(err);
  424. result.error=1;
  425. result.message = err.message;
  426. }
  427. response.json(result);
  428. }
  429. async updateUserFreight(request, response){
  430. let result={error:0};
  431. try {
  432. let data = JSON.parse(request.body.data);
  433. result.data = await glj_facade.updateUserFreight(data,request);
  434. }catch (err){
  435. logger.err(err);
  436. result.error=1;
  437. result.message = err.message;
  438. }
  439. response.json(result);
  440. }
  441. async checkUnitFileName(request, response){
  442. let result={
  443. error:0
  444. }
  445. try {
  446. let data = request.body.data;
  447. let nameExist = false;
  448. data = JSON.parse(data);
  449. let unitPriceFileModel = new UnitPriceFileModel();
  450. let count = await unitPriceFileModel.model.count({root_project_id:data.rootProjectID,name:data.name,deleteInfo:null});
  451. if(count>0){
  452. nameExist = true;
  453. }else {
  454. nameExist = false;
  455. }
  456. result.data= nameExist;
  457. }catch (err){
  458. console.log(err);
  459. result.error=1;
  460. result.message = err.message;
  461. }
  462. response.json(result);
  463. }
  464. /**
  465. * 单价文件另存为
  466. *
  467. * @param {object} request
  468. * @param {object} response
  469. * @return {void}
  470. */
  471. async unitPriceSaveAs(request, response) {
  472. let responseData = {
  473. err: 0,
  474. msg: ''
  475. };
  476. let projectId = request.body.project_id;
  477. let name = request.body.name;
  478. try {
  479. // 当前单价文件id
  480. let currentUnitPriceId = await ProjectModel.getUnitPriceFileId(projectId);
  481. // 获取当前项目的rootProjectId
  482. let projectData = await ProjectModel.getProject(projectId);
  483. let rootProjectId = projectData.property.rootProjectID !== undefined ? projectData.property.rootProjectID : 0;
  484. // 新增单价文件信息
  485. let unitPriceFileModel = new UnitPriceFileModel();
  486. let insertData = {
  487. name: name,
  488. project_id: projectId,
  489. user_id: request.session.sessionUser.id,
  490. root_project_id: rootProjectId
  491. };
  492. let addResult = await unitPriceFileModel.add(insertData);
  493. if (!addResult) {
  494. throw '单价文件另存为失败';
  495. }
  496. // 查找对应单价文件的项目工料机数据
  497. let unitPriceModel = new UnitPriceModel();
  498. let copyResult = await unitPriceModel.copyNotExist(currentUnitPriceId, addResult.id,projectId);
  499. // 复制成功后更改project数据
  500. if (!copyResult) {
  501. throw '复制数据失败';
  502. }
  503. await ProjectModel.updateUnitFileToProject(projectId,{id:addResult.id,name:addResult.name});
  504. responseData.data = addResult;
  505. } catch (error) {
  506. responseData.err = 1;
  507. responseData.msg = error;
  508. }
  509. response.json(responseData);
  510. }
  511. /**
  512. * 获取项目中所有组成物数据(用户缓存到前端变量)
  513. *
  514. * @param {object} request
  515. * @param {object} response
  516. * @return {void}
  517. */
  518. async getComposition(request, response) {
  519. let projectId = request.body.project_id;
  520. projectId = parseInt(projectId);
  521. let responseData = {
  522. err: 0,
  523. data: null
  524. };
  525. try {
  526. // 当前单价文件id
  527. let currentUnitPriceId = await ProjectModel.getUnitPriceFileId(projectId);
  528. if (currentUnitPriceId <= 0) {
  529. throw '没有找到对应的单价文件';
  530. }
  531. // 获取组成物数据
  532. let mixRatioModel = new MixRatioModel();
  533. let compositionData = await mixRatioModel.findDataByCondition({unit_price_file_id: currentUnitPriceId}, null, false);
  534. if (compositionData === null) {
  535. throw '没有找到组成物数据';
  536. }
  537. compositionData = JSON.parse(JSON.stringify(compositionData));
  538. // 查找对应的单价数据
  539. let unitPriceModel = new UnitPriceModel();
  540. let unitPriceData = await unitPriceModel.findDataByCondition({unit_price_file_id: currentUnitPriceId}, null, false, 'glj_id');
  541. // 整理数据
  542. let result = {};
  543. for(let composition of compositionData) {
  544. let tmpId = composition.glj_id !== undefined ? composition.glj_id : -1;
  545. let tmpData = {
  546. market_price: unitPriceData[tmpId] !== undefined ?
  547. unitPriceData[tmpId].market_price : 0,
  548. base_price: unitPriceData[tmpId] !== undefined ?
  549. unitPriceData[tmpId].base_price : 0,
  550. consumption: composition.consumption,
  551. glj_type: composition.glj_type,
  552. connect_code: composition.connect_code
  553. };
  554. if (result[tmpId] === undefined) {
  555. result[tmpId] = [];
  556. }
  557. result[tmpId].push(tmpData);
  558. }
  559. responseData.data = result;
  560. } catch (error) {
  561. responseData.err = 1;
  562. responseData.data = null;
  563. }
  564. response.json(responseData);
  565. }
  566. /**
  567. * 模拟定额插入
  568. *
  569. * @param {object} request
  570. * @param {object} response
  571. * @return {void}
  572. */
  573. async test(request, response) {
  574. // 从定额库获取的数据
  575. let data = {
  576. glj_id: 17,
  577. project_id: 1,
  578. code: '00010201',
  579. name: '土石方综合工日',
  580. specs: '',
  581. unit: '工日',
  582. type: GLJTypeConst.LABOUR,
  583. base_price: 50,
  584. market_price: 50
  585. };
  586. try {
  587. let gljListModel = new GLJListModel();
  588. let result = await gljListModel.addList(data);
  589. } catch (error) {
  590. console.log(error);
  591. }
  592. response.end('success');
  593. }
  594. /**
  595. * 模拟定额修改单价
  596. *
  597. * @param {object} request
  598. * @param {object} response
  599. * @return {void}
  600. */
  601. async testModify(request, response) {
  602. let projectId = request.query.project;
  603. // 修改数据
  604. let updateData = {
  605. code: '36290101',
  606. market_price: '13',
  607. name: '水(10)',
  608. project_id: projectId
  609. };
  610. try {
  611. let gljListModel = new GLJListModel();
  612. let result = await gljListModel.modifyMarketPrice(updateData);
  613. console.log(result);
  614. } catch (error) {
  615. console.log(error);
  616. }
  617. response.end('success');
  618. }
  619. /**
  620. * 测试删除
  621. *
  622. * @param {object} request
  623. * @param {object} response
  624. * @return {void}
  625. */
  626. async delete(request, response) {
  627. try {
  628. let gljListModel = new GLJListModel();
  629. let result = await gljListModel.deleteById(63);
  630. console.log(result);
  631. } catch (error) {
  632. console.log(error);
  633. }
  634. response.end('success');
  635. }
  636. async updateUnitPrice(req, res){
  637. let result={
  638. error:0
  639. }
  640. try {
  641. let data = req.body.data;
  642. data = JSON.parse(data);
  643. let unitPriceModel = new UnitPriceModel();
  644. // 更新数据
  645. let datas = await unitPriceModel.updateUnitPrice(data);
  646. result.data=datas;
  647. }catch (err){
  648. logger.err(err);
  649. result.error=1;
  650. result.message = err.message;
  651. }
  652. res.json(result);
  653. }
  654. async updateCalcMaterial(req, res){
  655. let result={
  656. error:0
  657. }
  658. try {
  659. let data = req.body.data;
  660. data = JSON.parse(data);
  661. let unitPriceModel = new UnitPriceModel();
  662. // 更新数据
  663. let datas = await unitPriceModel.updateCalcMaterial(data);
  664. result.data=datas;
  665. }catch (err){
  666. logger.err(err);
  667. result.error=1;
  668. result.message = err.message;
  669. }
  670. res.json(result);
  671. }
  672. async batchUpdatePrices(req, res){
  673. let result={
  674. error:0
  675. }
  676. try {
  677. let data = req.body.data;
  678. data = JSON.parse(data);
  679. let unitPriceModel = new UnitPriceModel();
  680. // 更新数据
  681. let datas = await unitPriceModel.batchUpdatePrices(data);
  682. result.data=datas;
  683. }catch (err){
  684. logger.err(err);
  685. result.error=1;
  686. result.message = err.message;
  687. }
  688. res.json(result);
  689. }
  690. async batchUpdateGLJProperty(req, res){
  691. let result={
  692. error:0
  693. };
  694. try {
  695. let data = req.body.data;
  696. data = JSON.parse(data);
  697. let tasks = [];
  698. for(let key in data){
  699. let doc = data[key];
  700. let query = {id:parseInt(key)};
  701. let task = {updateOne:{filter:query, update :doc}};
  702. tasks.push(task);
  703. }
  704. if(tasks.length > 0){
  705. let gljModel = new GLJListModel().model;
  706. await gljModel.bulkWrite(tasks);
  707. }
  708. result.data=data;
  709. }catch (err){
  710. logger.err(err);
  711. result.error=1;
  712. result.message = err.message;
  713. }
  714. res.json(result);
  715. }
  716. async batchUpdateConsumption(req,res){
  717. let result={
  718. error:0
  719. };
  720. try {
  721. let data = req.body.data;
  722. data = JSON.parse(data);
  723. let mixTasks = [],unitPriceTask=[];
  724. for(let d of data){
  725. if(d.type == 'mix_ratio'){
  726. let task = {updateOne:{filter:d.query, update :d.doc}};
  727. mixTasks.push(task);
  728. }else if(d.type == 'unitPrice'){
  729. let utask = {updateOne:{filter:d.query, update :d.doc}};
  730. unitPriceTask.push(utask);
  731. }
  732. }
  733. if(mixTasks.length > 0){
  734. let mixRatioModel = new MixRatioModel().model;
  735. await mixRatioModel.bulkWrite(mixTasks);
  736. }
  737. let unitPriceModel = new UnitPriceModel();
  738. if(unitPriceTask.length > 0)await unitPriceModel.model.bulkWrite(unitPriceTask);
  739. result.data = "ok";
  740. }catch (err){
  741. logger.err(err);
  742. result.error=1;
  743. result.message = err.message;
  744. }
  745. res.json(result);
  746. }
  747. async modifyKeyValue(req,res){//修改工料机关键的属性:名称、类型、规格、型号等
  748. let result={
  749. error:0
  750. }
  751. try {
  752. let data = req.body.data;
  753. data = JSON.parse(data);
  754. let gljListModel = new GLJListModel();
  755. let ration_data = await ration.findOne(data.ration);
  756. // 修改项目工料机
  757. let projcetGLJ = await gljListModel.modifyGLJ(data.updateData,ration_data);
  758. // let datas = await gljListModel.addList(data);
  759. result.data=projcetGLJ;
  760. }catch (err){
  761. logger.err(err);
  762. result.error=1;
  763. result.message = err.message;
  764. }
  765. res.json(result);
  766. }
  767. async getVvTaxList(req,res){
  768. let vvTxtList = [];
  769. try {
  770. let egnrModel = new EngineeringLibModel();
  771. let egnr = await egnrModel.getEngineering(req.query.engineeringID);
  772. vvTxtList = egnr.vvTax_lib;
  773. }catch (err){
  774. logger.err(err);
  775. }
  776. res.json(vvTxtList);
  777. }
  778. async getUserFreights(req,res){
  779. let userFreights = [];
  780. try {
  781. userFreights = await await glj_facade.getUserFreights(req);
  782. }catch (err){
  783. logger.err(err);
  784. }
  785. res.json(userFreights);
  786. }
  787. async getProjectGLJsByProjectID(projectId){
  788. return await getGLJListByProjectID(projectId)
  789. }
  790. async getFreightAndOriginalData(projectId,unitPriceFileId){
  791. return await getFreightAndOriginalData(projectId,unitPriceFileId);
  792. }
  793. }
  794. async function getFreightAndOriginalData(projectId,unitPriceFileId){
  795. if(!unitPriceFileId) unitPriceFileId = await ProjectModel.getUnitPriceFileId(projectId);
  796. let originalList = await original_calc_model.find({"unit_price_file_id":unitPriceFileId}).lean();
  797. let freightList = await freight_calc_model .find({"unit_price_file_id":unitPriceFileId}).lean();
  798. return [originalList,freightList]
  799. }
  800. /**
  801. * 取项目工料机列表
  802. * @param projectId
  803. * @returns {Promise.<void>}
  804. */
  805. async function getGLJListByProjectID(projectId){
  806. let responseData = {
  807. err: 0,
  808. msg: '',
  809. data: {}
  810. };
  811. try {
  812. if (isNaN(projectId) || projectId <= 0) {
  813. throw '标段id有误';
  814. }
  815. // 获取标段对应的单价文件id
  816. let unitPriceFileId = await ProjectModel.getUnitPriceFileId(projectId);
  817. if (unitPriceFileId <= 0) {
  818. throw '没有对应的单价文件';
  819. }
  820. // 获取使用该单价文件的项目数据
  821. let tenderData = await ProjectModel.getTenderByUnitPriceFileId(unitPriceFileId);
  822. let usedTenderList = [];
  823. let usedUnitPriceInfo = {};
  824. if (tenderData !== null) {
  825. for (let tmp of tenderData) {
  826. usedTenderList.push(tmp.name);
  827. usedUnitPriceInfo.name = tmp.property.unitPriceFile.name;
  828. usedUnitPriceInfo.id = tmp.property.unitPriceFile.id;
  829. }
  830. }
  831. let [originalList,freightList] = await getFreightAndOriginalData(projectId,unitPriceFileId);
  832. responseData.data.originalList = originalList;
  833. responseData.data.freightList = freightList;
  834. responseData.data.com_electrovalence = await com_electrovalence_model.findOne({"unit_price_file_id":unitPriceFileId}).lean();
  835. //if(!responseData.data.com_electrovalence) responseData.data.com_electrovalence = {};
  836. // 先获取对应标段的项目工料机数据
  837. let gljListModel = new GLJListModel();
  838. let [gljList, mixRatioConnectData,mixRatioMap,unitPriceMap] = await gljListModel.getListByProjectId(projectId, unitPriceFileId,responseData.data.freightList,responseData.data.originalList,responseData.data.com_electrovalence);
  839. responseData.data.gljList = gljList;
  840. responseData.data.mixRatioConnectData = mixRatioConnectData;
  841. responseData.data.mixRatioMap = mixRatioMap;
  842. responseData.data.usedTenderList = usedTenderList;
  843. responseData.data.unitPriceMap = unitPriceMap;
  844. let gljTypeMap = glj_type_util.getStdGljTypeCacheObj().innerGljTypeObj;
  845. let unitPriceFileModel = new UnitPriceFileModel();
  846. let unitFileInfo = await unitPriceFileModel.findDataByCondition({id: unitPriceFileId});
  847. responseData.data.constData = {
  848. materialIdList: gljListModel.materialIdList,
  849. ownCompositionTypes: gljListModel.ownCompositionTypes,
  850. roomId: unitPriceFileId,
  851. GLJTypeConst: JSON.stringify(GLJTypeConst),
  852. usedUnitPriceInfo: usedUnitPriceInfo,
  853. gljTypeMap:gljTypeMap,
  854. vvTaxFileID:unitFileInfo.vvTaxFileID,
  855. assistProductionFeeRate:unitFileInfo.assistProductionFeeRate?unitFileInfo.assistProductionFeeRate:3
  856. };
  857. } catch (error) {
  858. console.log(error);
  859. responseData.err = 1;
  860. responseData.msg = error;
  861. }
  862. return responseData;
  863. }
  864. export default GLJController;