stage_controller.js 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author Mai
  6. * @date 2018/6/20
  7. * @version
  8. */
  9. const moment = require('moment');
  10. const auditConst = require('../const/audit').stage;
  11. const spreadConst = require('../const/spread');
  12. const tenderConst = require('../const/tender');
  13. const payConst = require('../const/deal_pay.js');
  14. const measureType = tenderConst.measureType;
  15. const path = require('path');
  16. const PayCalculator = require('../lib/pay_calc');
  17. const accountGroup = require('../const/account_group').group;
  18. module.exports = app => {
  19. class StageController extends app.BaseController {
  20. /**
  21. * 构造函数
  22. *
  23. * @param {Object} ctx - egg全局变量
  24. * @return {void}
  25. */
  26. constructor(ctx) {
  27. super(ctx);
  28. ctx.showProject = true;
  29. ctx.showTender = true;
  30. ctx.showTitle = true;
  31. }
  32. /**
  33. * 获取通用的renderData(用于layout, Menu, subMenu部分)
  34. * @param ctx
  35. * @returns {{tender, tenderMenu, auditConst}}
  36. * @private
  37. */
  38. _getDefaultRenderData (ctx) {
  39. const data = {
  40. tender: ctx.tender.data,
  41. tenderMenu: JSON.parse(JSON.stringify(this.menu.stageMenu)),
  42. auditConst,
  43. measureType,
  44. preUrl: '/tender/' + ctx.tender.id + '/measure/stage/' + ctx.params.order,
  45. stage: ctx.stage,
  46. };
  47. data.tenderMenu.back.children[0].url = '/tender/' + ctx.tender.id + '/measure/stage';
  48. return data;
  49. }
  50. _stageReadOnly(stage) {
  51. return stage.status === auditConst.status.checked;
  52. }
  53. /**
  54. * 获取SpreadSetting
  55. * @private
  56. */
  57. _getSpreadSetting() {
  58. const _ = this.app._;
  59. function removeFieldCols(setting, cols) {
  60. _.remove(setting.cols, function (c) {
  61. return cols.indexOf(c.field) > -1;
  62. });
  63. }
  64. function setColFormat(cols, field, formatter) {
  65. const filterCols = cols.filter(function (c) {
  66. return c.field.search(field) !== -1;
  67. });
  68. for (const col of filterCols) {
  69. col.formatter = formatter;
  70. }
  71. }
  72. const tpFormatter = this.ctx.helper.getNumberFormatter(this.ctx.tender.info.decimal.tp);
  73. const upFormatter = this.ctx.helper.getNumberFormatter(2);
  74. const ledger = JSON.parse(JSON.stringify(spreadConst.stage.ledger));
  75. setColFormat(ledger.cols, 'unit_price', upFormatter);
  76. setColFormat(ledger.cols, 'total_price', tpFormatter);
  77. setColFormat(ledger.cols, 'tp', tpFormatter);
  78. const pos = JSON.parse(JSON.stringify(spreadConst.stage.pos));
  79. const tender = this.ctx.tender, stage = this.ctx.stage;
  80. if (this._stageReadOnly(stage)) {
  81. ledger.readOnly = true;
  82. pos.readOnly = true;
  83. }
  84. if (tender.data.measure_type === measureType.tz.value) {
  85. removeFieldCols(ledger, spreadConst.filterCols.tzWithoutCols);
  86. removeFieldCols(pos, spreadConst.filterCols.posTzWithoutCols);
  87. }
  88. if (!tender.info.display.ledger.dgnQty) {
  89. removeFieldCols(ledger, spreadConst.filterCols.dgnCols);
  90. }
  91. return [ledger, pos];
  92. }
  93. /**
  94. * 获取期数据
  95. * @param ctx
  96. * @returns {Promise<void>}
  97. * @private
  98. */
  99. async _getStage(ctx) {
  100. const stageOrder = parseInt(ctx.params.order);
  101. ctx.stage = await ctx.service.stage.getDataByCondition({
  102. tid: ctx.tender.id,
  103. order: stageOrder,
  104. });
  105. if (ctx.stage.status === auditConst.status.uncheck && ctx.stage.user_id !== ctx.session.sessionUser.accountId) {
  106. throw '数据错误';
  107. }
  108. ctx.stage.auditors = await ctx.service.stageAudit.getAuditors(ctx.stage.id, ctx.stage.times);
  109. ctx.stage.curAuditor = await ctx.service.stageAudit.getCurAuditor(ctx.stage.id, ctx.stage.times);
  110. ctx.stage.user = await ctx.service.projectAccount.getAccountInfoById(ctx.stage.user_id);
  111. ctx.stage.auditHistory = [];
  112. if (ctx.stage.times > 1) {
  113. for (let i = 1; i < ctx.stage.times; i++) {
  114. ctx.stage.auditHistory.push(await ctx.service.stageAudit.getAuditors(ctx.stage.id, i));
  115. }
  116. }
  117. }
  118. /**
  119. * 期计量页面 (Get)
  120. * @param {Object} ctx - egg全局变量
  121. * @returns {Promise<void>}
  122. */
  123. async index(ctx) {
  124. try {
  125. await this._getStage(ctx);
  126. const renderData = this._getDefaultRenderData(ctx);
  127. [renderData.ledgerSpread, renderData.posSpread] = this._getSpreadSetting();
  128. renderData.ledgerData = await ctx.service.ledger.getDataByTenderId(ctx.tender.id, -1);
  129. renderData.curStageData = await ctx.service.stageBills.getAuditorStageData(ctx.tender.id, ctx.stage.id, ctx.stage.times, 0);
  130. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.index);
  131. // 查询截止上期数据
  132. // if (ctx.stage.order > 0) {
  133. // renderData.preStageData
  134. // }
  135. if (ctx.stage.status === auditConst.status.uncheck && ctx.session.sessionUser.accountId === ctx.stage.user_id) {
  136. renderData.accountGroup = accountGroup;
  137. // 获取所有项目参与者
  138. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  139. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  140. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group'],
  141. });
  142. renderData.accountList = accountList;
  143. }
  144. await this.layout('stage/index.ejs', renderData, 'stage/modal.ejs');
  145. } catch (err) {
  146. this.log(err);
  147. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage');
  148. }
  149. }
  150. /**
  151. * 获取期数据(截止上期 & 本期)
  152. * @param ctx
  153. * @returns {Promise<void>}
  154. */
  155. async getStagePosData(ctx) {
  156. try {
  157. await this._getStage(ctx);
  158. const condition = JSON.parse(ctx.request.body.data) || {};
  159. condition.tid = ctx.tender.id;
  160. const responseData = {err: 0, msg: '', data: {}};
  161. responseData.data.pos = await ctx.service.pos.getPosData(condition);
  162. // todo 根据当前人,或指定对象查询数据
  163. responseData.data.curStageData = await ctx.service.stagePos.getAuditorStageData(ctx.tender.id,
  164. ctx.stage.id, ctx.stage.times, ctx.stage.curAuditor ? ctx.stage.curAuditor.order : 0,
  165. this.app._.map(responseData.data.pos, 'id'));
  166. ctx.body = responseData;
  167. } catch (err) {
  168. this.log(err);
  169. ctx.body = {err: 1, msg: err.toString(), data: null};
  170. }
  171. }
  172. /**
  173. * 保存数据
  174. * @param ctx
  175. * @returns {Promise<void>}
  176. */
  177. async updateStageData(ctx) {
  178. try {
  179. await this._getStage(ctx);
  180. // 检查登录用户,是否可操作
  181. if (ctx.session.sessionUser.accountId === ctx.stage.user_id) {
  182. if (ctx.stage.status === auditConst.status.checking || ctx.stage.status === auditConst.status.checked) {
  183. throw '该计量期当前您无权操作';
  184. }
  185. } else {
  186. // 检查是否可修改
  187. //const curAuditor = await ctx.service.stageAudit.get
  188. }
  189. const data = JSON.parse(ctx.request.body.data);
  190. const responseData = { err: 0, msg: '', data: {}, };
  191. if (data.pos) {
  192. responseData.data = await ctx.service.stagePos.updateStageData(data.pos);
  193. } else if (data.bills) {
  194. responseData.data.bills = await ctx.service.stageBills.updateStageData(data.bills);
  195. }
  196. ctx.body = responseData;
  197. } catch (err) {
  198. this.log(err);
  199. ctx.body = {err: 1, msg: err.toString(), data: null};
  200. }
  201. }
  202. /**
  203. * 中间计量
  204. * @param ctx
  205. * @returns {Promise<void>}
  206. */
  207. async detail(ctx) {
  208. try {
  209. await this._getStage(ctx);
  210. const renderData = this._getDefaultRenderData(ctx);
  211. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.detail);
  212. renderData.imType = tenderConst.imType;
  213. await this.layout('stage/detail.ejs', renderData, 'stage/detail_modal.ejs');
  214. } catch (err) {
  215. this.log(err);
  216. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage/' + ctx.params.order);
  217. }
  218. }
  219. /**
  220. * 设置中间计量生成规则,并生成中间计量数据
  221. * @param ctx
  222. * @returns {Promise<void>}
  223. */
  224. async buildDetailData (ctx) {
  225. try {
  226. await this._getStage(ctx);
  227. // 检查登录用户,是否可操作
  228. if (ctx.session.sessionUser.accountId === ctx.stage.user_id) {
  229. if (ctx.stage.status === auditConst.status.checking || ctx.stage.status === auditConst.status.checked) {
  230. throw '该计量期当前您无权操作';
  231. }
  232. }
  233. const data = JSON.parse(ctx.request.body.data);
  234. await ctx.service.stage.buildDetailData(ctx.tender.id, ctx.stage.order, data);
  235. ctx.body = {err: 0, msg: '', data: null};
  236. } catch (err) {
  237. this.log(err);
  238. ctx.body = {err: 1, msg: err.toString(), data: null};
  239. }
  240. }
  241. /**
  242. * 加载数据
  243. * @param ctx
  244. * @returns {Promise<void>}
  245. */
  246. async loadDetailRelaData(ctx) {
  247. try {
  248. await this._getStage(ctx);
  249. const data = JSON.parse(ctx.request.body.data);
  250. // 加载台账数据
  251. if (data.loadType === 'ledger') {
  252. const ledgerData = await ctx.service.ledger.getDataByTenderId(ctx.tender.id, -1);
  253. ctx.body = {err: 0, msg: '', data: ledgerData };
  254. } else if (data.loadType === 'all') {
  255. const ledger = await ctx.service.ledger.getDataByTenderId(ctx.tender.id, -1);
  256. const curStage = await ctx.service.stageBills.getLastestStageData(ctx.tender.id, ctx.stage.id);
  257. const stageDetail = await ctx.service.stageDetail.getLastestStageData(ctx.tender.id, ctx.stage.id);
  258. ctx.body = {
  259. err: 0,
  260. msg: '',
  261. data: {
  262. ledger,
  263. curStage,
  264. stageDetail,
  265. }
  266. };
  267. }
  268. } catch (err) {
  269. this.log(err);
  270. ctx.body = {err: 1, msg: err.toString(), data: null};
  271. }
  272. }
  273. /**
  274. * 中间计量,生成规则,高级设置
  275. * @param ctx
  276. * @returns {Promise<void>}
  277. */
  278. async setAdvancedConfig(ctx) {
  279. try {
  280. await this._getStage(ctx);
  281. // 检查登录用户,是否可操作
  282. if (ctx.session.sessionUser.accountId === ctx.stage.user_id) {
  283. if (ctx.stage.status === auditConst.status.checking || ctx.stage.status === auditConst.status.checked) {
  284. throw '该计量期当前您无权操作';
  285. }
  286. }
  287. const data = JSON.parse(ctx.request.body.data);
  288. await ctx.service.stage.update(data, { id: ctx.stage.id });
  289. ctx.body = {err: 0, msg: '', data: this.ctx.stage};
  290. } catch (err) {
  291. this.log(err);
  292. ctx.body = {err: 1, msg: err.toString(), data: null};
  293. }
  294. }
  295. /**
  296. * 中间计量,编辑中间计量数据
  297. * @param ctx
  298. * @returns {Promise<void>}
  299. */
  300. async saveDetailData(ctx) {
  301. try {
  302. await this._getStage(ctx);
  303. // 检查登录用户,是否可操作
  304. if (ctx.session.sessionUser.accountId === ctx.stage.user_id) {
  305. if (ctx.stage.status === auditConst.status.checking || ctx.stage.status === auditConst.status.checked) {
  306. throw '该计量期当前您无权操作';
  307. }
  308. } else {
  309. // 检查是否可修改
  310. //const curAuditor = await ctx.service.stageAudit.get
  311. }
  312. const data = JSON.parse(ctx.request.body.data);
  313. const responseData = { err: 0, msg: '', data: {}, };
  314. responseData.data = await ctx.service.stageDetail.saveDetailData(data);
  315. ctx.body = responseData;
  316. } catch (err) {
  317. this.log(err);
  318. ctx.body = {err: 1, msg: err.toString(), data: null};
  319. }
  320. }
  321. /**
  322. * 中间计量,添加草图,上传图片
  323. * @param ctx
  324. * @returns {Promise<void>}
  325. */
  326. async addCalcImage(ctx) {
  327. try {
  328. const stream = await ctx.getFileStream();
  329. const create_time = Date.parse(new Date()) / 1000;
  330. const fileInfo = path.parse(stream.filename);
  331. const fileName = path.join('public/upload', this.ctx.tender.id.toString(), 'im', 'calcImg_' + create_time + fileInfo.ext);
  332. await ctx.helper.saveStreamFile(stream, path.join(this.app.baseDir, 'app', fileName));
  333. ctx.body = {err: 0, msg: '', data: fileName};
  334. } catch(err) {
  335. this.log(err);
  336. ctx.body = {err: 1, msg: err.toString(), data: null};
  337. }
  338. }
  339. /**
  340. * 中间计量,设置草图
  341. * @param ctx
  342. * @returns {Promise<void>}
  343. */
  344. async mergeCalcImage(ctx) {
  345. try {
  346. await this._getStage(ctx);
  347. // 检查登录用户,是否可操作
  348. if (ctx.session.sessionUser.accountId === ctx.stage.user_id) {
  349. if (ctx.stage.status === auditConst.status.checking || ctx.stage.status === auditConst.status.checked) {
  350. throw '该计量期当前您无权操作';
  351. }
  352. } else {
  353. // 检查是否可修改
  354. //const curAuditor = await ctx.service.stageAudit.get
  355. }
  356. const data = JSON.parse(ctx.request.body.data);
  357. if (data.updateType === 'update') {
  358. const create_time = Date.parse(new Date()) / 1000;
  359. const fileName = path.join('public/upload', this.ctx.tender.id.toString(), 'im', 'calcImg_' + create_time + '.jpg');
  360. const base64Data = data.img.replace(/^data:image\/\w+;base64,/, "");
  361. const dataBuffer = new Buffer(base64Data, 'base64');
  362. await this.ctx.helper.saveBufferFile(dataBuffer, path.join(this.app.baseDir, 'app', fileName));
  363. data.calc_img = fileName;
  364. data.calc_img_org = JSON.stringify(data.imgInfo);
  365. delete data.updateType;
  366. delete data.img;
  367. delete data.imgInfo;
  368. } else if (data.updateType === 'clear') {
  369. data.calc_img = null;
  370. data.calc_img_org = null;
  371. delete data.updateType;
  372. }
  373. await this.ctx.service.stageDetail.saveDetailData(data);
  374. const imData = await ctx.service.stageDetail.getLastestImStageData(this.ctx.tender.id, this.ctx.stage.id, data.lid, data.uuid);
  375. const responseData = {err: 0, msg: '', data: imData};
  376. ctx.body = responseData;
  377. } catch (err) {
  378. this.log(err);
  379. ctx.body = {err: 1, msg: err.toString(), data: null};
  380. }
  381. }
  382. /**
  383. * 合同支付
  384. * @param ctx
  385. * @returns {Promise<void>}
  386. */
  387. async pay(ctx) {
  388. try {
  389. await this._getStage(ctx);
  390. const renderData = this._getDefaultRenderData(ctx);
  391. const dealPay = await ctx.service.stagePay.getStagePays(ctx.stage);
  392. if (dealPay && dealPay.length > 0) {
  393. renderData.dealPay = dealPay;
  394. } else {
  395. await ctx.service.pay.addDefaultPayData(this.ctx.tender.id);
  396. await ctx.service.stagePay.addInitialStageData(ctx.stage);
  397. renderData.dealPay = await ctx.service.stagePay.getStagePays(ctx.stage);
  398. }
  399. renderData.calcBase = await ctx.service.stage.getStagePayCalcBase();
  400. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.pay);
  401. // 计算 本期金额
  402. const payCalculator = new PayCalculator(this.ctx, this.ctx.tender.info.decimal);
  403. await payCalculator.calculateAll(renderData.dealPay);
  404. await this.layout('stage/pay.ejs', renderData, 'stage/pay_modal.ejs');
  405. } catch (err) {
  406. this.log(err);
  407. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage');
  408. }
  409. }
  410. /**
  411. * 合同支付 - 编辑合同支付项
  412. * @param ctx
  413. * @returns {Promise<void>}
  414. */
  415. async savePayData(ctx) {
  416. try {
  417. await this._getStage(ctx);
  418. // 检查登录用户,是否可操作
  419. if (ctx.session.sessionUser.accountId === ctx.stage.user_id) {
  420. if (ctx.stage.status === auditConst.status.checking || ctx.stage.status === auditConst.status.checked) {
  421. throw '该计量期当前您无权操作';
  422. }
  423. } else {
  424. if (!ctx.stage.curAuditor || ctx.stage.curAuditor.id !== ctx.session.sessionUser.accountId) {
  425. throw '该计量期当前您无权操作';
  426. }
  427. }
  428. const data = JSON.parse(ctx.request.body.data);
  429. const responseData = { err: 0, msg: '', data: {}, };
  430. const payCalculator = new PayCalculator(this.ctx, this.ctx.tender.info.decimal);
  431. switch (data.type) {
  432. case 'add':
  433. responseData.data = await ctx.service.pay.add();
  434. responseData.data = await ctx.service.stagePay.getStagePay(ctx.stage, responseData.data.pid);
  435. break;
  436. case 'del':
  437. await ctx.service.pay.del(data.id);
  438. responseData.data = await ctx.service.stagePay.getStagePays(ctx.stage);
  439. await payCalculator.calculate(responseData.data);
  440. break;
  441. case 'changeOrder':
  442. responseData.data = await ctx.service.pay.changeOrder(data.id1, data.id2);
  443. break;
  444. case 'info':
  445. responseData.data = await ctx.service.pay.save(data.updateData);
  446. if (data.updateData.sexpr !== undefined || data.updateData.sprice !== undefined
  447. || data.updateData.rexpr !== undefined || data.updateData.rprice !== undefined
  448. || data.updateData.minus !== undefined || data.updateData.is_yf !== undefined
  449. || data.updateData.dl_type !== undefined) {
  450. responseData.data = await ctx.service.stagePay.getStagePays(ctx.stage);
  451. await payCalculator.calculateAll(responseData.data);
  452. //console.log(responseData.data[responseData.data.length - 1]);
  453. } else {
  454. responseData.data = await ctx.service.stagePay.getStagePay(ctx.stage, responseData.data.id);
  455. }
  456. break;
  457. case 'stage':
  458. await ctx.service.stagePay.save(data.updateData);
  459. responseData.data = await ctx.service.stagePay.getStagePays(ctx.stage);
  460. await payCalculator.calculateAll(responseData.data);
  461. break;
  462. }
  463. ctx.body = responseData;
  464. } catch(err) {
  465. this.log(err);
  466. ctx.body = {err: 1, msg: err.toString(), data: null};
  467. }
  468. }
  469. /**
  470. * 合同支付 - 章节明细
  471. * @param ctx
  472. * @returns {Promise<void>}
  473. */
  474. async chapterDetail(ctx) {
  475. const _ = this.app._;
  476. const fields = ['contract_tp', 'qc_tp', 'gather_tp', 'end_gather_tp'];
  477. function assignStageData(chapter, curStage, preStage) {
  478. chapter.contract_tp = curStage.contract_tp;
  479. chapter.qc_tp = curStage.qc_tp;
  480. chapter.gather_tp = _.add(curStage.contract_tp, curStage.qc_tp);
  481. if (preStage) {
  482. chapter.pre_contract_tp = preStage.contract_tp;
  483. chapter.pre_qc_tp = preStage.qc_tp;
  484. chapter.pre_gather_tp = _.add(preStage.contract_tp, preStage.qc_tp);
  485. chapter.end_contract_tp = _.add(curStage.contract_tp, preStage.contract_tp);
  486. chapter.end_qc_tp = _.add(curStage.qc_tp, preStage.qc_tp);
  487. chapter.end_gather_tp = _.add(chapter.gather_tp, chapter.pre_gather_tp);
  488. } else {
  489. chapter.end_contract_tp = curStage.contract_tp;
  490. chapter.end_qc_tp = curStage.qc_tp;
  491. chapter.end_gather_tp = chapter.gather_tp;
  492. }
  493. }
  494. try {
  495. await this._getStage(ctx);
  496. const chapterDetail = JSON.parse(JSON.stringify(payConst.chapterDetail));
  497. const calcDetail = _.sortBy(chapterDetail, ['cType']);
  498. for (const cd of calcDetail) {
  499. switch (cd.cType) {
  500. case 1:
  501. const tp = await ctx.service.stageBills.getSumTotalPriceGcl(ctx.stage, cd.filter);
  502. assignStageData(cd, tp);
  503. break;
  504. case 11:
  505. assignStageData(cd, await ctx.service.stageBills.getSumTotalPriceGcl(ctx.stage));
  506. break;
  507. case 21:
  508. const sum = _.find(calcDetail, {cType: 11});
  509. const chapters = _.filter(calcDetail, {cType: 1});
  510. for (const f of fields) {
  511. cd[f] = _.subtract(sum[f], _.sumBy(chapters, f));
  512. }
  513. break;
  514. case 31:
  515. assignStageData(cd, await ctx.service.stageBills.getSumTotalPriceNotGcl(ctx.stage));
  516. break;
  517. case 41:
  518. const sum1 = _.find(calcDetail, {cType: 11});
  519. const sum2 = _.find(calcDetail, {cType: 31});
  520. for (const f of fields) {
  521. cd[f] = _.add(sum1.value, sum2.value);
  522. }
  523. break;
  524. }
  525. }
  526. ctx.body = {err: 0, msg: '', data: {detail: chapterDetail, decimal: ctx.tender.info.decimal}};
  527. } catch (err) {
  528. this.log(err);
  529. ctx.body = {err: 1, msg: err.toString(), data: null};
  530. }
  531. }
  532. /**
  533. * 变更令
  534. * @param ctx
  535. * @returns {Promise<void>}
  536. */
  537. async change(ctx) {
  538. try {
  539. await this._getStage(ctx);
  540. const renderData = this._getDefaultRenderData(ctx);
  541. await this.layout('stage/change.ejs', renderData);
  542. } catch (err) {
  543. this.log(err);
  544. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage');
  545. }
  546. }
  547. /**
  548. * 查询可用变更令
  549. * @param ctx
  550. * @returns {Promise<void>}
  551. */
  552. async searchValidChange(ctx) {
  553. }
  554. // 审批相关
  555. /**
  556. * 添加审批人
  557. * @param ctx
  558. * @returns {Promise<void>}
  559. */
  560. async addAudit(ctx) {
  561. try {
  562. await this._getStage(ctx);
  563. const data = JSON.parse(ctx.request.body.data);
  564. const id = this.app._.toInteger(data.auditorId);
  565. if (isNaN(id) || id <= 0) {
  566. throw '参数错误';
  567. }
  568. // 检查权限等
  569. if (ctx.stage.user_id !== ctx.session.sessionUser.accountId) {
  570. throw '您无权添加审核人';
  571. }
  572. if (ctx.stage.status === auditConst.status.checking || ctx.stage.status === auditConst.status.checked) {
  573. throw '当前不允许添加审核人';
  574. }
  575. // 检查审核人是否已存在
  576. const exist = this.app._.find(ctx.stage.auditors, {aid: id});
  577. if (exist) {
  578. throw '该审核人已存在,请勿重复添加';
  579. }
  580. const result = await ctx.service.stageAudit.addAuditor(ctx.stage.id, id);
  581. if (!result) {
  582. throw '添加审核人失败';
  583. }
  584. const audit = await ctx.service.stageAudit.getAuditor(ctx.stage.id, id);
  585. ctx.body = {err: 0, msg: '', data: audit};
  586. } catch (err) {
  587. this.log(err);
  588. ctx.body = {err: 1, msg: err.toString(), data: null};
  589. }
  590. }
  591. /**
  592. * 移除审批人
  593. * @param ctx
  594. * @returns {Promise<void>}
  595. */
  596. async deleteAudit(ctx) {
  597. try {
  598. await this._getStage(ctx);
  599. const data = JSON.parse(ctx.request.body.data);
  600. const id = data.auditorId instanceof Number ? data.auditorId : this.app._.toNumber(data.auditorId);
  601. if (isNaN(id) || id <= 0) {
  602. throw '参数错误';
  603. }
  604. const result = await ctx.service.stageAudit.deleteAuditor(ctx.stage.id, id, ctx.stage.times);
  605. if (!result) {
  606. throw '移除审核人失败';
  607. }
  608. const auditors = await ctx.service.stageAudit.getAuditors(ctx.stage.id);
  609. ctx.body = {err: 0, msg: '', data: auditors};
  610. } catch (err) {
  611. ctx.body = {err: 1, msg: err.toString(), data: null};
  612. }
  613. }
  614. /**
  615. * 上报
  616. * @param ctx
  617. * @returns {Promise<void>}
  618. */
  619. async startAudit(ctx) {
  620. try {
  621. await this._getStage(ctx);
  622. // 检查权限等
  623. if (!ctx.stage) {
  624. throw '数据错误';
  625. }
  626. if (ctx.stage.user_id !== ctx.session.sessionUser.accountId) {
  627. throw '您无权上报该期数据';
  628. }
  629. if (ctx.stage.status === auditConst.status.checking || ctx.stage.status === auditConst.status.checked) {
  630. throw '该期数据当前无法上报';
  631. }
  632. await ctx.service.stageAudit.start(ctx.stage.id, ctx.stage.times);
  633. ctx.redirect(ctx.request.header.referer);
  634. } catch (err) {
  635. this.log(err);
  636. ctx.session.postError = err.toString();
  637. ctx.redirect(ctx.request.header.referer);
  638. }
  639. }
  640. /**
  641. * 审批
  642. * @param ctx
  643. * @returns {Promise<void>}
  644. */
  645. async checkAudit(ctx) {
  646. try {
  647. await this._getStage(ctx);
  648. if (!this.ctx.stage || this.ctx.stage.status !== auditConst.status.checking) {
  649. throw '当前期数据有误';
  650. }
  651. if (!this.ctx.stage.curAuditor || this.ctx.stage.curAuditor.aid !== ctx.session.sessionUser.accountId) {
  652. throw '您无权进行该操作';
  653. }
  654. const data = {
  655. checkType: parseInt(ctx.request.body.checkType),
  656. opinion: ctx.request.body.opinion,
  657. };
  658. if (!data.checkType || isNaN(data.checkType)) {
  659. throw '提交数据错误';
  660. }
  661. if (data.checkType === auditConst.status.checkNo) {
  662. if (!data.checkType || isNaN(data.checkType)) {
  663. throw '提交数据错误';
  664. }
  665. }
  666. await ctx.service.stageAudit.check(ctx.stage.id, data, ctx.stage.times);
  667. console.log('success');
  668. ctx.redirect(ctx.request.header.referer);
  669. } catch (err) {
  670. console.log(err);
  671. this.log(err);
  672. ctx.session.postError = err.toString();
  673. ctx.redirect(ctx.request.header.referer);
  674. }
  675. }
  676. _getGatherSpreadSetting() {
  677. const _ = this.app._;
  678. function removeFieldCols(setting, cols) {
  679. _.remove(setting.cols, function (c) {
  680. return cols.indexOf(c.field) > -1;
  681. });
  682. }
  683. function setColFormat(cols, field, formatter) {
  684. const filterCols = cols.filter(function (c) {
  685. return c.field.search(field) !== -1;
  686. });
  687. for (const col of filterCols) {
  688. col.formatter = formatter;
  689. }
  690. }
  691. const tpFormatter = this.ctx.helper.getNumberFormatter(this.ctx.tender.info.decimal.tp);
  692. const upFormatter = this.ctx.helper.getNumberFormatter(2);
  693. const gcl = JSON.parse(JSON.stringify(spreadConst.stageGather.gcl));
  694. setColFormat(gcl.cols, 'unit_price', upFormatter);
  695. setColFormat(gcl.cols, 'total_price', tpFormatter);
  696. setColFormat(gcl.cols, 'tp', tpFormatter);
  697. const leafXmj = JSON.parse(JSON.stringify(spreadConst.stageGather.leafXmj));
  698. const tender = this.ctx.tender;
  699. if (tender.data.measure_type === measureType.tz.value) {
  700. removeFieldCols(gcl, spreadConst.filterCols.tzWithoutCols);
  701. }
  702. return [gcl, leafXmj];
  703. }
  704. /**
  705. * 清单汇总
  706. * @param ctx
  707. * @returns {Promise<void>}
  708. */
  709. async gather(ctx) {
  710. try {
  711. await this._getStage(ctx);
  712. const renderData = this._getDefaultRenderData(ctx);
  713. [renderData.gclSpread, renderData.leafXmjSpread] = this._getGatherSpreadSetting();
  714. renderData.ledger = await ctx.service.ledger.getDataByTenderId(ctx.tender.id, -1);
  715. renderData.curLedgerData = await ctx.service.stageBills.getAuditorStageData(ctx.tender.id, ctx.stage.id, ctx.stage.times, 0);
  716. renderData.pos = await ctx.service.pos.getPosData({tid: ctx.tender.id});
  717. // todo 根据当前人,或指定对象查询数据
  718. renderData.curPosData = await ctx.service.stagePos.getAuditorStageData(ctx.tender.id,
  719. ctx.stage.id, ctx.stage.times, ctx.stage.curAuditor ? ctx.stage.curAuditor.order : 0);
  720. //renderData.gcl = await this.ctx.service.ledger.getAllLeafGclBills(this.ctx.tender.id);
  721. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.gather);
  722. await this.layout('stage/gather.ejs', renderData);
  723. } catch (err) {
  724. this.log(err);
  725. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage/' + ctx.params.order);
  726. }
  727. }
  728. /**
  729. * 审核比较
  730. * @param ctx
  731. * @returns {Promise<void>}
  732. */
  733. async compare(ctx) {
  734. function getCompareSpreadSetting () {
  735. function setColFormat(cols, field, formatter) {
  736. const filterCols = cols.filter(function (c) {
  737. return c.field.search(field) !== -1;
  738. });
  739. for (const col of filterCols) {
  740. col.formatter = formatter;
  741. }
  742. }
  743. const tpFormatter = ctx.helper.getNumberFormatter(ctx.tender.info.decimal.tp);
  744. const upFormatter = ctx.helper.getNumberFormatter(2);
  745. const ledger = JSON.parse(JSON.stringify(spreadConst.stageCompare.ledger));
  746. setColFormat(ledger.baseCols, 'unit_price', upFormatter);
  747. setColFormat(ledger.extraCols, 'total_price', tpFormatter);
  748. setColFormat(ledger.extraCols, 'tp', tpFormatter);
  749. const pos = JSON.parse(JSON.stringify(spreadConst.stageCompare.pos));
  750. return [ledger, pos];
  751. };
  752. try {
  753. await this._getStage(ctx);
  754. const renderData = this._getDefaultRenderData(ctx);
  755. [renderData.ledgerSpread, renderData.posSpread] = getCompareSpreadSetting();
  756. renderData.ledger = await ctx.service.ledger.getDataByTenderId(ctx.tender.id, -1);
  757. renderData.orgStageLedger = await ctx.service.stageBills.getAuditorStageData(ctx.tender.id, ctx.stage.id, ctx.stage.times, 0);
  758. renderData.pos = await ctx.service.pos.getPosData({tid: ctx.tender.id});
  759. renderData.orgStagePos = await ctx.service.stagePos.getAuditorStageData(ctx.tender.id,
  760. ctx.stage.id, ctx.stage.times, ctx.stage.curAuditor ? ctx.stage.curAuditor.order : 0);
  761. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.compare);
  762. await this.layout('stage/compare.ejs', renderData, 'stage/compare_modal.ejs');
  763. } catch (err) {
  764. this.log(err);
  765. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage/' + ctx.params.order);
  766. }
  767. }
  768. async compareAuditor(ctx) {
  769. try {
  770. await this._getStage(ctx);
  771. const data = JSON.parse(ctx.request.body.data);
  772. const result = [];
  773. for (const order of data.auditors) {
  774. const data = { order: order, bills: [], pos: [] };
  775. data.bills = await ctx.service.stageBills.getAuditorStageData(ctx.tender.id, ctx.stage.id, ctx.stage.times, order);
  776. data.pos = await ctx.service.stagePos.getAuditorStageData(ctx.tender.id, ctx.stage.id, ctx.stage.times, order);
  777. result.push(data);
  778. }
  779. ctx.body = {err: 0, msg: '', data: result};
  780. } catch (err) {
  781. this.log(err);
  782. ctx.body = {err: 1, msg: err.toString(), data: null};
  783. }
  784. }
  785. /**
  786. * 报表
  787. * @param ctx
  788. * @returns {Promise<void>}
  789. */
  790. async report(ctx) {
  791. try {
  792. await this._getStage(ctx);
  793. const renderData = this._getDefaultRenderData(ctx);
  794. await this.layout('stage/report.ejs', renderData, 'stage/report_modal.ejs');
  795. } catch (err) {
  796. this.log(err);
  797. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage');
  798. }
  799. }
  800. }
  801. return StageController;
  802. };