compilation_controller.js 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688
  1. /**
  2. * 编办控制控制器
  3. *
  4. * @author CaiAoLin
  5. * @date 2017/7/28
  6. * @compilation
  7. */
  8. import BaseController from "../../common/base/base_controller";
  9. import CompilationModel from "../models/compilation_model";
  10. import STDRationLibMapModel from "../../common/std/std_ration_lib_map_model";
  11. import STDBillLibListsModel from "../../common/std/std_bills_lib_lists_model";
  12. import STDGLJLibMapModel from "../../common/std/std_glj_lib_map_model";
  13. import STDFeeRateLibsModel from "../../common/std/std_fee_rate_libs_model";
  14. import {default as EngineeringConst, List as EngineeringList} from "../../common/const/engineering";
  15. import BillsTemplateModel from "../models/bills_template_model";
  16. import {default as BillsFixedFlagConst, List as BillsFixedFlagList} from "../../common/const/bills_fixed.js";
  17. import {default as BillsTypeFlagConst, List as BillsTypeFlagList} from "../../common/const/bills_type.js";
  18. import EngineeringLibModel from "../models/engineering_lib_model";
  19. import STDLabourCoesModel from "../../common/std/std_labour_coes_model";
  20. import STDCalcProgramModel from "../../common/std/std_calc_program_model";
  21. const billsGuidanceFc = require('../../std_billsGuidance_lib/facade/facades');
  22. import mainColFacade from "../../main_col_lib/facade/main_col_facade";
  23. import billTemplateFacade from "../../bills_template_lib/facade/bills_template_facade";
  24. import projectFeatureFacade from "../../project_feature_lib/facade/project_feature_facade";
  25. import basicInfoFacade from "../../basic_info_lib/facade/basic_info_facade";
  26. import {default as category, List as categoryList} from "../../common/const/category_const.js";
  27. let config = require("../../../config/config.js");
  28. const fs = require('fs');
  29. let _ = require('lodash');
  30. class CompilationController extends BaseController {
  31. /**
  32. * 编办管理控制页面
  33. *
  34. * @param {object} request
  35. * @param {object} response
  36. * @return {void}
  37. */
  38. async index(request, response) {
  39. let id = request.query.id;
  40. let compilationList = [];
  41. let selectedCompilation = {};
  42. try {
  43. let compilationModel = new CompilationModel();
  44. compilationList = await compilationModel.getCompilationList();
  45. if (compilationList.length <= 0) {
  46. throw '没有数据';
  47. }
  48. // 循环查找数据
  49. for (let tmp of compilationList) {
  50. if (tmp._id.toString() === id) {
  51. selectedCompilation = tmp;
  52. break;
  53. }
  54. }
  55. selectedCompilation = Object.keys(selectedCompilation).length <= 0 ? compilationList[0] : selectedCompilation;
  56. request.session.selectedCompilation = selectedCompilation;
  57. } catch (error) {
  58. console.log(error);
  59. }
  60. if (selectedCompilation.example && Array.isArray(selectedCompilation.example)) {
  61. selectedCompilation.example = selectedCompilation.example.join(';');
  62. }
  63. let renderData = {
  64. id: id,
  65. compilationList: compilationList,
  66. categoryList: categoryList,
  67. selectedCompilation: selectedCompilation,
  68. layout: 'users/views/layout/layout',
  69. LicenseKey:config.getLicenseKey(process.env.NODE_ENV)
  70. };
  71. response.render('users/views/compilation/index', renderData);
  72. }
  73. /**
  74. * 新增计价页面
  75. *
  76. * @param {object} request
  77. * @param {object} response
  78. * @return {void}
  79. */
  80. async addValuation(request, response) {
  81. let name = request.body.name;
  82. let id = request.body.id;
  83. let section = request.body.section;
  84. let responseData = {
  85. err: 0,
  86. msg: ''
  87. };
  88. try {
  89. if (id === undefined || id === '') {
  90. throw '参数错误';
  91. }
  92. let insertData = {
  93. name: name,
  94. };
  95. let compilationModel = new CompilationModel();
  96. let valuationId = await compilationModel.addValuation(id, section, insertData);
  97. if (!valuationId) {
  98. throw '新增计价规则失败';
  99. }
  100. //添加标准工程专业 2018-08-24 不自动添加标准工程了
  101. /*let engineeringLibModel = new EngineeringLibModel();
  102. let stdEngs = await engineeringLibModel.addStdLib(valuationId);
  103. console.log(stdEngs);*/
  104. } catch (error) {
  105. console.log(error);
  106. responseData.err = 1;
  107. responseData.msg = error;
  108. }
  109. response.json(responseData);
  110. }
  111. /**
  112. * 修改计价规则页面
  113. *
  114. * @param {object} request
  115. * @param {object} response
  116. * @return {void}
  117. */
  118. async editValuation(request, response) {
  119. let selectedCompilation = request.session.selectedCompilation;
  120. let valuationId = request.params.id;
  121. let section = request.params.section;
  122. let compilationList = [];
  123. let engineeringList = [];
  124. let valuationData = {};
  125. let valuationList = {};
  126. try {
  127. let compilationModel = new CompilationModel();
  128. compilationList = await compilationModel.getCompilationList();
  129. // 获取对应的计价规则数据
  130. [valuationData, valuationList] = await compilationModel.getValuation(selectedCompilation._id, valuationId, section);
  131. if (Object.keys(valuationData).length <= 0) {
  132. throw '不存在数据';
  133. }
  134. // 获取计价规则中对应的标准库数据
  135. let engineeringLibModel = new EngineeringLibModel();
  136. engineeringList = await engineeringLibModel.getLibsByValuationID(valuationId);
  137. engineeringList = _.sortBy(engineeringList,['seq'])
  138. } catch (error) {
  139. console.log(error);
  140. }
  141. let renderData = {
  142. compilationList: compilationList,
  143. engineeringList: engineeringList,
  144. selectedCompilation: selectedCompilation,
  145. valuationData: valuationData,
  146. valuationList: valuationList,
  147. valuationId: valuationId,
  148. section: section,
  149. layout: 'users/views/layout/layout',
  150. LicenseKey:config.getLicenseKey(process.env.NODE_ENV)
  151. };
  152. response.render('users/views/compilation/add', renderData);
  153. }
  154. /**
  155. * 编辑工程专业页面
  156. *
  157. * @param {object} request
  158. * @param {object} response
  159. * @return {void}
  160. */
  161. async editEngineering(request, response) {
  162. let engineerID = request.params.engineerID;
  163. let valuationId = request.params.id;
  164. let section = request.params.section;
  165. let selectedCompilation = request.session.selectedCompilation;
  166. let compilationList = [],billList = [], rationList = [], gljList = [],feeRateList = [], libData = {}, billsTemplateData = [],featureList = [],infoList = [];
  167. let valuationData = {}, valuationList = {}, artificialCoefficientList = [], calculationList = [], billsGuidanceList = [], mainTreeColList = [];
  168. let billTemplateList = [];
  169. try {
  170. let compilationModel = new CompilationModel();
  171. compilationList = await compilationModel.getCompilationList();
  172. // 获取标准清单,不绑定编办
  173. let stdBillLibListsModel = new STDBillLibListsModel();
  174. billList = await stdBillLibListsModel.getBillList();
  175. // 获取定额库
  176. let stdRationLibMapModel = new STDRationLibMapModel();
  177. rationList = await stdRationLibMapModel.getRationLib(selectedCompilation._id);
  178. // 获取工料机库
  179. let stdGLJLibMapModel = new STDGLJLibMapModel();
  180. gljList = await stdGLJLibMapModel.getGLJLibList(selectedCompilation._id);
  181. // 获取费率标准库
  182. let stdFeeRateLibsModel = new STDFeeRateLibsModel();
  183. feeRateList = await stdFeeRateLibsModel.getFeeRateList(selectedCompilation._id);
  184. // 获取人工系数标准库
  185. let stdLabourCoesModel = new STDLabourCoesModel();
  186. artificialCoefficientList = await stdLabourCoesModel.getLabourCoesList();
  187. // 获取计算程序库
  188. let stdCalcProgramModel = new STDCalcProgramModel();
  189. calculationList = await stdCalcProgramModel.getProgramList(selectedCompilation._id);
  190. //获取列设置库
  191. mainTreeColList = await mainColFacade.getColLibsByCompilationID(selectedCompilation._id);
  192. //获取清单模板库
  193. billTemplateList = await billTemplateFacade.getTemplateLibByCompilationID(selectedCompilation._id);
  194. // 获取对应的计价规则数据
  195. [valuationData, valuationList] = await compilationModel.getValuation(selectedCompilation._id, valuationId, section);
  196. if (Object.keys(valuationData).length <= 0) {
  197. throw '不存在数据';
  198. }
  199. // 获取对应专业工程下的标准库数据
  200. let engineeringLibModel = new EngineeringLibModel();
  201. libData = await engineeringLibModel.findDataByCondition({_id:engineerID});
  202. // 获取清单模板数据
  203. let billsTemplateModel = new BillsTemplateModel();
  204. billsTemplateData = await billsTemplateModel.getTemplateData(valuationId, libData.engineering);
  205. //获取清单指引数据
  206. billsGuidanceList = await billsGuidanceFc.getBillsGuideLibs({compilationId: selectedCompilation._id, $or: [{deleted: null}, {deleted: false}]});
  207. //获取工程特征库
  208. featureList = await projectFeatureFacade.findByCondition({},null,false);
  209. //获取基本信息库
  210. infoList = await basicInfoFacade.findByCondition({},null,false);
  211. } catch (error) {
  212. console.log(error);
  213. }
  214. //example Array to example String
  215. if (selectedCompilation.example && Array.isArray(selectedCompilation.example)) {
  216. selectedCompilation.example = selectedCompilation.example.join(';');
  217. }
  218. let renderData = {
  219. section: section,
  220. valuationId: valuationId,
  221. compilationList: compilationList,
  222. selectedCompilation: selectedCompilation,
  223. libData: libData,
  224. billList: JSON.stringify(billList),
  225. rationList: JSON.stringify(rationList),
  226. gljList: JSON.stringify(gljList),
  227. artificialCoefficientList: JSON.stringify(artificialCoefficientList),
  228. feeRateList: JSON.stringify(feeRateList),
  229. billsTemplateData: JSON.stringify(billsTemplateData),
  230. billTemplateList:JSON.stringify(billTemplateList),
  231. mainTreeColList: JSON.stringify(mainTreeColList),
  232. gljCol:JSON.stringify(libData.glj_col),
  233. calculationList: JSON.stringify(calculationList),
  234. billsGuidanceList: JSON.stringify(billsGuidanceList),
  235. featureList:JSON.stringify(featureList),
  236. infoList: JSON.stringify(infoList),
  237. layout: 'users/views/layout/layout',
  238. LicenseKey:config.getLicenseKey(process.env.NODE_ENV)
  239. };
  240. response.render('users/views/compilation/engineering', renderData);
  241. }
  242. /**
  243. * 保存工程专业标准库
  244. *
  245. * @param {object} request
  246. * @param {object} response
  247. * @return {void}
  248. */
  249. async saveEngineering(request, response) {
  250. let engineerId = request.body.id;
  251. try {
  252. if (engineerId === '') {
  253. throw 'id参数错误';
  254. }
  255. // 先存入工程专业标准库表
  256. let engineeringLibModel = new EngineeringLibModel();
  257. let result = await engineeringLibModel.addLib(engineerId, request.body);
  258. if (!result) {
  259. throw '保存失败';
  260. }
  261. } catch (error) {
  262. console.log(error);
  263. }
  264. response.redirect(request.headers.referer);
  265. }
  266. /**
  267. * 通过工程专业ID删除工程专业
  268. * @param request
  269. * @param response
  270. * @returns {Promise.<void>}
  271. */
  272. async deleteEngineer(request,response){
  273. let result={
  274. error:0
  275. };
  276. try {
  277. let data = request.body.data;
  278. data = JSON.parse(data);
  279. if(data.id ){
  280. let engineeringLibModel = new EngineeringLibModel();
  281. result.data = await engineeringLibModel.deleteById(data.id,true);
  282. }else {
  283. throw new Error("提交数据有误");
  284. }
  285. }catch (err){
  286. console.log(err);
  287. result.error=1;
  288. result.message = err.message;
  289. }
  290. response.json(result);
  291. }
  292. /**
  293. * 修改保存工程专业信息-用于异步操作
  294. * @param request
  295. * @param response
  296. * @returns {Promise.<void>}
  297. */
  298. async updateEngineer(request,response){
  299. let result={
  300. error:0
  301. };
  302. try {
  303. let data = request.body.data;
  304. data = JSON.parse(data);
  305. if(data.id && data.updateData){
  306. let engineeringLibModel = new EngineeringLibModel();
  307. result.data = await engineeringLibModel.updateById(data.id,data.updateData);
  308. }else {
  309. throw new Error("提交数据有误");
  310. }
  311. }catch (err){
  312. console.log(err);
  313. result.error=1;
  314. result.message = err.message;
  315. }
  316. response.json(result);
  317. }
  318. /**
  319. * 保存计价规则
  320. *
  321. * @param {object} request
  322. * @param {object} response
  323. * @return {void}
  324. */
  325. async saveValuation(request, response) {
  326. let valuationId = request.body.id;
  327. try {
  328. if (valuationId === '') {
  329. throw 'id参数错误';
  330. }
  331. let compilationModel = new CompilationModel();
  332. let result = await compilationModel.saveValuation(valuationId, request.body);
  333. if (!result) {
  334. throw '保存失败';
  335. }
  336. } catch (error) {
  337. console.log(error);
  338. }
  339. response.redirect(request.headers.referer);
  340. }
  341. /**
  342. * 删除计价规则
  343. *
  344. * @param {object} request
  345. * @param {object} response
  346. * @return {void}
  347. */
  348. async deleteValuation(request, response) {
  349. let id = request.params.id;
  350. let section = request.params.section;
  351. let selectedCompilation = request.session.selectedCompilation;
  352. try {
  353. if (id === undefined || id === '' || section === undefined || section === '') {
  354. throw '参数错误';
  355. }
  356. //先删除对应的工程专业
  357. let engineeringLibModel = new EngineeringLibModel();
  358. await engineeringLibModel.deleteByValuationID(id);
  359. //删除计价规则
  360. let compilationModel = new CompilationModel();
  361. let result = compilationModel.deleteValuation(selectedCompilation._id, id, section);
  362. if (!result) {
  363. throw '删除失败';
  364. }
  365. } catch (error) {
  366. console.log(error);
  367. }
  368. response.redirect(request.headers.referer);
  369. }
  370. /**
  371. * 快速切换启用/禁用
  372. *
  373. * @param {object} request
  374. * @param {object} response
  375. * @return {void}
  376. */
  377. async enableSwitch(request, response) {
  378. let id = request.body.id;
  379. let section = request.params.section;
  380. let enable = request.body.enable;
  381. let responseData = {
  382. err: 0,
  383. msg: ''
  384. };
  385. try {
  386. let compilationModel = new CompilationModel();
  387. let result = await compilationModel.switchEnable(id, section, enable);
  388. if (!result) {
  389. throw '新增编办失败';
  390. }
  391. } catch (error) {
  392. console.log(error);
  393. responseData.err = 1;
  394. responseData.msg = error;
  395. }
  396. response.json(responseData);
  397. }
  398. /**
  399. * 发布/取消编办
  400. *
  401. * @param {object} request
  402. * @param {object} response
  403. * @return {void}
  404. */
  405. async release(request, response) {
  406. let id = request.body.id;
  407. let release = request.body.status;
  408. release = parseInt(release);
  409. let responseData = {
  410. err: 0,
  411. msg: ''
  412. };
  413. try {
  414. let compilationModel = new CompilationModel();
  415. let result = await compilationModel.release(id, release);
  416. if (!result) {
  417. throw '发布编办失败';
  418. }
  419. } catch (error) {
  420. console.log(error);
  421. responseData.err = 1;
  422. responseData.msg = error;
  423. }
  424. response.json(responseData);
  425. }
  426. /**
  427. * 新增编办操作
  428. *
  429. * @param {object} request
  430. * @param {object} response
  431. * @return {void}
  432. */
  433. async addCompilation(request, response) {
  434. let name = request.body.name;
  435. let responseData = {
  436. err: 0,
  437. msg: ''
  438. };
  439. try {
  440. let sessionManager = request.session.managerData;
  441. let insertData = {
  442. name: name,
  443. creator: sessionManager.userID
  444. };
  445. let compilationModel = new CompilationModel();
  446. let result = await compilationModel.add(insertData);
  447. if (!result) {
  448. throw '新增编办失败';
  449. }
  450. } catch (error) {
  451. console.log(error);
  452. responseData.err = 1;
  453. responseData.msg = error;
  454. }
  455. response.json(responseData);
  456. }
  457. async setDescription(request, response){
  458. let compilationId = request.body.id;
  459. let description = request.body.description;
  460. try{
  461. let compilationModel = new CompilationModel();
  462. await compilationModel.setDescription(compilationId, description);
  463. response.json({err: 0, msg: '', data: null});
  464. }
  465. catch (err){
  466. response.json({err: 1, msg: err, data: null});
  467. }
  468. }
  469. async setOverWriteUrl(request, response){
  470. let compilationId = request.body.id;
  471. let overWriteUrl = request.body.overWriteUrl;
  472. try{
  473. let compilationModel = new CompilationModel();
  474. //绝对路径
  475. let absoluteUrl = request.app.locals.rootDir + overWriteUrl;
  476. //文件是否存在
  477. let fileExists = fs.existsSync(absoluteUrl);
  478. let pricePropertiesTemplate = [],
  479. consumeAmtPropertiesTemplate = [];
  480. if(fileExists && fs.statSync(absoluteUrl).isFile()){
  481. //读取配置文件并赋值
  482. let overWriteExports = require(absoluteUrl);
  483. if(overWriteExports){
  484. pricePropertiesTemplate = overWriteExports.pricePropertiesTemplate ? overWriteExports.pricePropertiesTemplate : [];
  485. consumeAmtPropertiesTemplate = overWriteExports.consumeAmtPropertiesTemplate ? overWriteExports.consumeAmtPropertiesTemplate : [];
  486. }
  487. }
  488. await compilationModel.setOverWriteUrl(compilationId, overWriteUrl, pricePropertiesTemplate, consumeAmtPropertiesTemplate);
  489. response.json({err: 0, msg: '', data: null});
  490. }
  491. catch (err){
  492. console.log(err);
  493. response.json({err: 1, msg: err, data: null});
  494. }
  495. }
  496. async setExample(request, response){
  497. let compilationId = request.body.id,
  498. example = request.body.example;
  499. try {
  500. let compilationModel = new CompilationModel();
  501. await compilationModel.setExample(compilationId, example);
  502. response.json({err: 0, msg: 'success', data: null});
  503. }
  504. catch (err){
  505. console.log(err);
  506. response.json({err: 1, msg: err, data: null});
  507. }
  508. }
  509. /**
  510. * 模板设置页面
  511. *
  512. * @param {object} request
  513. * @param {object} response
  514. * @return {void}
  515. */
  516. async billsTemplate(request, response) {
  517. let billList = {};
  518. let valuationList = {};
  519. let valuationData = {};
  520. let compilationList = [];
  521. let billsTemplateData = [];
  522. let selectedCompilation = request.session.selectedCompilation;
  523. let engineering = request.params.engineering;
  524. let valuationId = request.params.id;
  525. let section = request.params.section;
  526. try {
  527. let compilationModel = new CompilationModel;
  528. // 获取对应的计价规则数据
  529. [valuationData, valuationList] = await compilationModel.getValuation(selectedCompilation._id, valuationId, section);
  530. compilationList = await compilationModel.getCompilationList();
  531. // 获取标准清单
  532. let stdBillLibListsModel = new STDBillLibListsModel();
  533. billList = await stdBillLibListsModel.getBillList(selectedCompilation._id);
  534. // 获取清单模板数据
  535. let billsTemplateModel = new BillsTemplateModel();
  536. billsTemplateData = await billsTemplateModel.getTemplateData(valuationId, engineering);
  537. } catch (error) {
  538. console.log(error);
  539. }
  540. let renderData = {
  541. engineering: engineering,
  542. billList: JSON.stringify(billList),
  543. billsTemplateData: JSON.stringify(billsTemplateData),
  544. billsFixedFlagList: JSON.stringify(BillsFixedFlagList),
  545. billsTypeFlagList: JSON.stringify(BillsTypeFlagList),
  546. valuationData: valuationData,
  547. valuationList: valuationList,
  548. selectedCompilation: selectedCompilation,
  549. compilationList: compilationList,
  550. valuationId: valuationId,
  551. section: section,
  552. layout: 'users/views/layout/layout',
  553. LicenseKey:config.getLicenseKey(process.env.NODE_ENV)
  554. };
  555. response.render('users/views/compilation/template', renderData);
  556. }
  557. /**
  558. * 清单模板,更新数据操作
  559. *
  560. * @param request
  561. * @param response
  562. */
  563. async updateBillsTemplate(request, response) {
  564. let engineering = request.params.engineering;
  565. let valuationId = request.params.id;
  566. let section = request.params.section;
  567. let data = JSON.parse(request.body.data);
  568. let billsTemplateModel = new BillsTemplateModel();
  569. let result = await billsTemplateModel.updateTemplate(valuationId, engineering, data);
  570. if (result) {
  571. response.json({error: 0, message: '', data: data});
  572. } else {
  573. response.json({error: 1, message: '更新数据错误', data: null});
  574. }
  575. }
  576. async addEngineer(request,response){
  577. let engineeringLibModel = new EngineeringLibModel();
  578. try {
  579. await engineeringLibModel.addEngineer(request.body);
  580. }catch (error) {
  581. console.log(error);
  582. }
  583. response.redirect(request.headers.referer);
  584. }
  585. /**
  586. * 更改编办所属办事处信息
  587. *
  588. * @param request
  589. * @param response
  590. * @return {Promise.<void>}
  591. */
  592. async changeCategory(request, response) {
  593. let valuationId = request.body.id;
  594. let category = request.body.category;
  595. category = parseInt(category);
  596. try {
  597. let compilationModel = new CompilationModel();
  598. let result = await compilationModel.updateCategory(valuationId, category);
  599. if (result) {
  600. response.json({error: 0, message: '', data: null});
  601. } else {
  602. response.json({error: 1, message: '更新数据错误', data: null});
  603. }
  604. } catch(error) {
  605. response.json({error: 1, message: '更新数据错误', data: null});
  606. }
  607. }
  608. }
  609. export default CompilationController;