compilation_controller.js 21 KB

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