stage_controller.js 64 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426
  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 changeAudit = require('../const/audit').flow;
  12. const spreadConst = require('../const/spread');
  13. const tenderConst = require('../const/tender');
  14. const payConst = require('../const/deal_pay.js');
  15. const changeConst = require('../const/change');
  16. const measureType = tenderConst.measureType;
  17. const path = require('path');
  18. const PayCalculator = require('../lib/pay_calc');
  19. const accountGroup = require('../const/account_group').group;
  20. const sendToWormhole = require('stream-wormhole');
  21. const fs = require('fs');
  22. module.exports = app => {
  23. class StageController extends app.BaseController {
  24. /**
  25. * 构造函数
  26. *
  27. * @param {Object} ctx - egg全局变量
  28. * @return {void}
  29. */
  30. constructor(ctx) {
  31. super(ctx);
  32. ctx.showProject = true;
  33. ctx.showTender = true;
  34. ctx.showTitle = true;
  35. }
  36. /**
  37. * 获取通用的renderData(用于layout, Menu, subMenu部分)
  38. * @param ctx
  39. * @returns {{tender, tenderMenu, auditConst}}
  40. * @private
  41. */
  42. async _getDefaultRenderData (ctx) {
  43. const data = {
  44. tender: ctx.tender.data,
  45. tenderMenu: JSON.parse(JSON.stringify(this.menu.stageMenu)),
  46. auditConst,
  47. measureType,
  48. preUrl: '/tender/' + ctx.tender.id + '/measure/stage/' + ctx.params.order,
  49. stage: ctx.stage,
  50. };
  51. if ((ctx.stage.status === auditConst.status.uncheck || ctx.stage.status === auditConst.status.checkNo) && ctx.session.sessionUser.accountId === ctx.stage.user_id) {
  52. data.accountGroup = accountGroup;
  53. // 获取所有项目参与者
  54. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  55. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  56. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group'],
  57. });
  58. data.accountList = accountList;
  59. }
  60. data.tenderMenu.back.children[0].url = '/tender/' + ctx.tender.id + '/measure/stage';
  61. return data;
  62. }
  63. _stageReadOnly(stage) {
  64. return stage.status === auditConst.status.checked;
  65. }
  66. /**
  67. * 获取SpreadSetting
  68. * @private
  69. */
  70. _getSpreadSetting() {
  71. const _ = this.app._;
  72. function removeFieldCols(setting, cols) {
  73. _.remove(setting.cols, function (c) {
  74. return cols.indexOf(c.field) > -1;
  75. });
  76. }
  77. function setColFormat(cols, field, formatter) {
  78. const filterCols = cols.filter(function (c) {
  79. return c.field.search(field) !== -1;
  80. });
  81. for (const col of filterCols) {
  82. col.formatter = formatter;
  83. }
  84. }
  85. // const tpFormatter = this.ctx.helper.getNumberFormatter(this.ctx.tender.info.decimal.tp);
  86. // const upFormatter = this.ctx.helper.getNumberFormatter(2);
  87. const tender = this.ctx.tender, stage = this.ctx.stage;
  88. const stageSetting = tender.data.measure_type === measureType.tz.value ? spreadConst.stageTz :
  89. (tender.info.display.ledger.clQty ? spreadConst.stageCl : spreadConst.stageNoCl);
  90. const ledger = JSON.parse(JSON.stringify(stageSetting.ledger));
  91. // setColFormat(ledger.cols, 'unit_price', upFormatter);
  92. // setColFormat(ledger.cols, 'total_price', tpFormatter);
  93. // setColFormat(ledger.cols, 'tp', tpFormatter);
  94. if (!tender.info.display.ledger.dgnQty) {
  95. removeFieldCols(ledger, spreadConst.filterCols.stageDgnCols);
  96. }
  97. const pos = JSON.parse(JSON.stringify(stageSetting.pos));
  98. if (this.ctx.stage.readOnly) {
  99. ledger.readOnly = true;
  100. pos.readOnly = true;
  101. }
  102. return [ledger, pos];
  103. }
  104. /**
  105. * 获取审批界面所需的 原报、审批人数据等
  106. * @param ctx
  107. * @returns {Promise<void>}
  108. * @private
  109. */
  110. async _getStageAuditViewData (ctx) {
  111. const times = ctx.stage.status === auditConst.status.checkNo ? ctx.stage.times - 1 : ctx.stage.times;
  112. ctx.stage.user = await ctx.service.projectAccount.getAccountInfoById(ctx.stage.user_id);
  113. ctx.stage.auditHistory = [];
  114. if (ctx.stage.times > 1) {
  115. for (let i = 1; i < ctx.stage.times; i++) {
  116. ctx.stage.auditHistory.push(await ctx.service.stageAudit.getAuditors(ctx.stage.id, i));
  117. }
  118. }
  119. // 获取审批流程中左边列表
  120. ctx.stage.auditors2 = await ctx.service.stageAudit.getAuditGroupByList(ctx.stage.id, times);
  121. if (ctx.stage.status === auditConst.status.uncheck || ctx.stage.status === auditConst.status.checkNo) {
  122. ctx.stage.auditorList = await ctx.service.stageAudit.getAuditors(ctx.stage.id, ctx.stage.times);
  123. }
  124. }
  125. /**
  126. * 期计量页面 (Get)
  127. * @param {Object} ctx - egg全局变量
  128. * @returns {Promise<void>}
  129. */
  130. async index(ctx) {
  131. try {
  132. await this._getStageAuditViewData(ctx);
  133. const renderData = await this._getDefaultRenderData(ctx);
  134. [renderData.ledgerSpread, renderData.posSpread] = this._getSpreadSetting();
  135. renderData.changeConst = changeConst;
  136. renderData.ledgerData = await ctx.service.ledger.getData(ctx.tender.id);
  137. const dgnData = await ctx.service.stageBillsDgn.getDgnData(ctx.tender.id);
  138. for (const d of dgnData) {
  139. const l = ctx.app._.find(renderData.ledgerData, {id: d.id});
  140. ctx.app._.assignIn(l, d);
  141. }
  142. let curStageData, preStageData;
  143. // 当前操作人查看最新数据,其他人查看历史数据
  144. if (ctx.stage.readOnly) {
  145. curStageData = await ctx.service.stageBills.getAuditorStageData(ctx.tender.id, ctx.stage.id, ctx.stage.curTimes, ctx.stage.curOrder);
  146. } else {
  147. curStageData = await ctx.service.stageBills.getLastestStageData(ctx.tender.id, ctx.stage.id);
  148. }
  149. // 查询截止上期数据
  150. if (ctx.stage.order > 1) {
  151. preStageData = await ctx.service.stageBillsFinal.getFinalData(ctx.tender.data, ctx.stage.order - 1);
  152. //renderData.preStageData = await ctx.service.stageBills.getEndStageData(ctx.tender.id, ctx.stage.order - 1);
  153. } else {
  154. preStageData = [];
  155. }
  156. this.ctx.helper.assignRelaData(renderData.ledgerData, [
  157. {data: curStageData, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp', 'postil'], prefix: '', relaId: 'lid',},
  158. {data: preStageData, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: 'pre_', relaId: 'lid',}
  159. ]);
  160. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.index);
  161. renderData.whiteList = this.ctx.app.config.multipart.whitelist;
  162. // 获取附件列表
  163. const attData = await ctx.service.stageAtt.getDataByTenderIdAndStageId(ctx.tender.id, ctx.params.order);
  164. for (const index in attData) {
  165. attData[index].in_time = moment(attData[index].in_time * 1000).format('YYYY-MM-DD');
  166. }
  167. renderData.attData = attData;
  168. await this.layout('stage/index.ejs', renderData, 'stage/modal.ejs');
  169. } catch (err) {
  170. this.log(err);
  171. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage');
  172. }
  173. }
  174. /**
  175. * 获取期数据(截止上期 & 本期) (Ajax)
  176. * @param ctx
  177. * @returns {Promise<void>}
  178. */
  179. async getStagePosData(ctx) {
  180. try {
  181. const condition = JSON.parse(ctx.request.body.data) || {};
  182. condition.tid = ctx.tender.id;
  183. const responseData = {err: 0, msg: '', data: {}};
  184. let curStageData, preStageData;
  185. responseData.data = await ctx.service.pos.getPosData(condition);
  186. // 根据当前人,或指定对象查询数据
  187. //console.time('cur');
  188. const curWhere = JSON.parse(ctx.request.body.data);
  189. if (ctx.stage.readOnly) {
  190. curStageData = await ctx.service.stagePos.getAuditorStageData2(ctx.tender.id,
  191. ctx.stage.id, ctx.stage.curTimes, ctx.stage.curOrder, curWhere);
  192. } else {
  193. curStageData = await ctx.service.stagePos.getLastestStageData2(ctx.tender.id, ctx.stage.id, curWhere);
  194. }
  195. //console.timeEnd('cur');
  196. // 查询截止上期数据
  197. //console.time('pre');
  198. if (ctx.stage.order > 1) {
  199. preStageData = await ctx.service.stagePosFinal.getFinalData(ctx.tender.data, ctx.stage.order - 1);
  200. //responseData.data.preStageData = await ctx.service.stagePos.getEndStageData(ctx.tender.id, ctx.stage.order - 1);
  201. } else {
  202. preStageData = [];
  203. }
  204. //console.timeEnd('pre');
  205. //console.time('assign');
  206. console.log('cur: ' + curStageData.length);
  207. console.log('pre: ' + preStageData.length);
  208. this.ctx.helper.assignRelaData(responseData.data, [
  209. {data: curStageData, fields: ['contract_qty', 'qc_qty', 'postil'], prefix: '', relaId: 'pid'},
  210. {data: preStageData, fields: ['contract_qty', 'qc_qty'], prefix: 'pre_', relaId: 'pid'}
  211. ]);
  212. //console.timeEnd('assign');
  213. ctx.body = responseData;
  214. } catch (err) {
  215. this.log(err);
  216. ctx.body = {err: 1, msg: err.toString(), data: null};
  217. }
  218. }
  219. /**
  220. * 保存数据 (Ajax)
  221. * @param ctx
  222. * @returns {Promise<void>}
  223. */
  224. async updateStageData(ctx) {
  225. try {
  226. // 检查登录用户,是否可操作
  227. if (ctx.stage.readOnly) {
  228. throw '该计量期当前您无权操作';
  229. }
  230. const data = JSON.parse(ctx.request.body.data);
  231. const responseData = { err: 0, msg: '', data: {}, };
  232. if (data.pos) {
  233. responseData.data = await ctx.service.stagePos.updateStageData(data.pos);
  234. } else if (data.bills) {
  235. if (data.bills.dgn) {
  236. responseData.data.dgn = await ctx.service.stageBillsDgn.saveDgnData(data.bills.dgn);
  237. }
  238. if (data.bills.stage) {
  239. responseData.data.curStageData = await ctx.service.stageBills.updateStageData(data.bills.stage);
  240. }
  241. }
  242. await this.ctx.service.stage.updateCheckDetailFlag(ctx.stage.id, true);
  243. ctx.body = responseData;
  244. } catch (err) {
  245. this.log(err);
  246. ctx.body = {err: 1, msg: err.toString(), data: null};
  247. }
  248. }
  249. /**
  250. * 查询可用变更令 (Ajax-Post)
  251. * @param ctx
  252. * @returns {Promise<void>}
  253. */
  254. async searchValidChange(ctx) {
  255. try {
  256. // if (ctx.stage.readOnly) {
  257. // throw '您无权调用变更令';
  258. // }
  259. const data = JSON.parse(ctx.request.body.data);
  260. if (!data.bills && !data.pos) {
  261. throw '数据错误';
  262. }
  263. const bills = data.bills ? data.bills : await ctx.service.ledger.getDataById(data.pos.lid);
  264. const pos = data.pos;
  265. const changes = await ctx.service.change.getValidChanges(ctx.tender.id, bills);
  266. const useChanges = await ctx.service.stageChange.getLastestStageData(ctx.tender.id, ctx.stage.id, bills.id, pos ? pos.id : -1);
  267. ctx.body = {err: 0, msg: '', data: {changes, useChanges}};
  268. } catch(err) {
  269. this.log(err);
  270. ctx.body = {err: 1, msg: err.toString(), data: null};
  271. }
  272. }
  273. /**
  274. * 调用变更令 (Ajax-Post)
  275. * @param ctx
  276. * @returns {Promise<void>}
  277. */
  278. async useChange(ctx) {
  279. try {
  280. if (ctx.stage.readOnly) {
  281. throw '您无权使用变更令';
  282. }
  283. const data = JSON.parse(ctx.request.body.data);
  284. if (!data.target || (!data.target.bills && !data.target.pos) || !data.change) {
  285. throw '调用变更令数据错误'
  286. }
  287. let result;
  288. if (data.target.pos) {
  289. result = await ctx.service.stageChange.posChange(data.target.pos, data.change);
  290. } else {
  291. result = await ctx.service.stageChange.billsChange(data.target.bills, data.change);
  292. }
  293. await this.ctx.service.stage.updateCheckDetailFlag(ctx.stage.id, true);
  294. ctx.body = {err: 0, msg: '', data: result};
  295. } catch(err) {
  296. this.log(err);
  297. ctx.body = {err: 1, msg: err.toString(), data: null};
  298. }
  299. }
  300. /**
  301. * 查询变更令 明细数据(包括附件、变更清单、累计使用情况、本期使用情况) (Ajax-Post)
  302. * @param ctx
  303. * @returns {Promise<void>}
  304. */
  305. async changeDetail(ctx) {
  306. try {
  307. const data = JSON.parse(ctx.request.body.data);
  308. if (!data.cid) {
  309. throw '查询数据错误';
  310. }
  311. const detailData = await this._getChangeDetailData(ctx.tender.id, ctx.stage.id, data.cid);
  312. ctx.body = {err: 0, msg: '', data: detailData};
  313. } catch(err) {
  314. this.log(err);
  315. ctx.body = {err: 1, msg: err.toString(), data: null};
  316. }
  317. }
  318. /**
  319. * 中间计量 (Get)
  320. * @param ctx
  321. * @returns {Promise<void>}
  322. */
  323. async detail(ctx) {
  324. try {
  325. await this._getStageAuditViewData(ctx);
  326. const renderData = await this._getDefaultRenderData(ctx);
  327. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.detail);
  328. renderData.imType = tenderConst.imType;
  329. await this.layout('stage/detail.ejs', renderData, 'stage/detail_modal.ejs');
  330. } catch (err) {
  331. this.log(err);
  332. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage/' + ctx.params.order);
  333. }
  334. }
  335. /**
  336. * 设置中间计量生成规则,并生成中间计量数据 (Ajax)
  337. * @param ctx
  338. * @returns {Promise<void>}
  339. */
  340. async buildDetailData (ctx) {
  341. try {
  342. // 检查登录用户,是否可操作
  343. if (ctx.stage.readOnly) {
  344. throw '该计量期当前您无权操作';
  345. }
  346. const data = JSON.parse(ctx.request.body.data);
  347. await ctx.service.stage.buildDetailData(ctx.tender.id, ctx.stage.order, data);
  348. ctx.body = {err: 0, msg: '', data: null};
  349. } catch (err) {
  350. this.log(err);
  351. ctx.body = {err: 1, msg: err.toString(), data: null};
  352. }
  353. }
  354. /**
  355. * 加载数据 (Ajax)
  356. * @param ctx
  357. * @returns {Promise<void>}
  358. */
  359. async loadDetailRelaData(ctx) {
  360. try {
  361. const data = JSON.parse(ctx.request.body.data);
  362. // 加载台账数据
  363. if (data.loadType === 'ledger') {
  364. const ledgerData = await ctx.service.ledger.getData(ctx.tender.id);
  365. ctx.body = {err: 0, msg: '', data: ledgerData };
  366. } else if (data.loadType === 'all') {
  367. const result = {};
  368. result.ledger = await ctx.service.ledger.getData(ctx.tender.id);
  369. result.pos = await ctx.service.pos.getPosData({tid: ctx.tender.id});
  370. if (ctx.stage.readOnly) {
  371. const curStage = await ctx.service.stageBills.getAuditorStageData(ctx.tender.id, ctx.stage.id, ctx.stage.curTimes, ctx.stage.curOrder);
  372. this.ctx.helper.assignRelaData(result.ledger, [
  373. {data: curStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: '', relaId: 'lid'}
  374. ]);
  375. const curPosStage = await ctx.service.stagePos.getAuditorStageData2(ctx.tender.id, ctx.stage.id, ctx.stage.curTimes, ctx.stage.curOrder);
  376. this.ctx.helper.assignRelaData(result.pos, [
  377. {data: curPosStage, fields: ['contract_qty', 'qc_qty'], prefix: '', relaId: 'pid'}
  378. ]);
  379. result.stageDetail = await ctx.service.stageDetail.getAuditorStageData(ctx.tender.id, ctx.stage.id, ctx.stage.curTimes, ctx.stage.curOrder);
  380. } else {
  381. const curStage = await ctx.service.stageBills.getLastestStageData(ctx.tender.id, ctx.stage.id);
  382. this.ctx.helper.assignRelaData(result.ledger, [
  383. {data: curStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: '', relaId: 'lid'}
  384. ]);
  385. const curPosStage = await ctx.service.stagePos.getLastestStageData2(ctx.tender.id, ctx.stage.id);
  386. this.ctx.helper.assignRelaData(result.pos, [
  387. {data: curPosStage, fields: ['contract_qty', 'qc_qty'], prefix: '', relaId: 'pid'}
  388. ]);
  389. result.stageDetail = await ctx.service.stageDetail.getLastestStageData(ctx.tender.id, ctx.stage.id);
  390. }
  391. ctx.body = { err: 0, msg: '', data: result };
  392. }
  393. } catch (err) {
  394. this.log(err);
  395. ctx.body = { err: 1, msg: err.toString(), data: null };
  396. }
  397. }
  398. /**
  399. * 中间计量,生成规则,高级设置 (Ajax)
  400. * @param ctx
  401. * @returns {Promise<void>}
  402. */
  403. async setAdvancedConfig(ctx) {
  404. try {
  405. // 检查登录用户,是否可操作
  406. if (ctx.stage.readOnly) {
  407. throw '该计量期当前您无权操作';
  408. }
  409. const data = JSON.parse(ctx.request.body.data);
  410. await ctx.service.stage.update(data, { id: ctx.stage.id });
  411. ctx.body = {err: 0, msg: '', data: this.ctx.stage};
  412. } catch (err) {
  413. this.log(err);
  414. ctx.body = {err: 1, msg: err.toString(), data: null};
  415. }
  416. }
  417. /**
  418. * 中间计量,编辑中间计量数据(Ajax)
  419. * @param ctx
  420. * @returns {Promise<void>}
  421. */
  422. async saveDetailData(ctx) {
  423. try {
  424. // 检查登录用户,是否可操作
  425. if (ctx.stage.readOnly) {
  426. throw '该计量期当前您无权操作';
  427. }
  428. const data = JSON.parse(ctx.request.body.data);
  429. const responseData = { err: 0, msg: '', data: {}, };
  430. if (data instanceof Array) {
  431. responseData.data = await ctx.service.stageDetail.saveDetailDatas(data);
  432. } else {
  433. responseData.data = await ctx.service.stageDetail.saveDetailData(data);
  434. }
  435. ctx.body = responseData;
  436. } catch (err) {
  437. this.log(err);
  438. ctx.body = {err: 1, msg: err.toString(), data: null};
  439. }
  440. }
  441. /**
  442. * 中间计量,添加草图,上传图片 (Ajax)
  443. * @param ctx
  444. * @returns {Promise<void>}
  445. */
  446. async addCalcImage(ctx) {
  447. try {
  448. if (ctx.stage.readOnly) {
  449. throw '该计量期当前您无权操作';
  450. }
  451. const stream = await ctx.getFileStream();
  452. const create_time = Date.parse(new Date()) / 1000;
  453. const fileInfo = path.parse(stream.filename);
  454. const fileName = path.join('public/upload', this.ctx.tender.id.toString(), 'im', 'calcImg_' + create_time + fileInfo.ext);
  455. await ctx.helper.saveStreamFile(stream, path.join(this.app.baseDir, 'app', fileName));
  456. ctx.body = {err: 0, msg: '', data: fileName};
  457. } catch(err) {
  458. this.log(err);
  459. ctx.body = {err: 1, msg: err.toString(), data: null};
  460. }
  461. }
  462. /**
  463. * 中间计量,设置草图 (Ajax)
  464. * @param ctx
  465. * @returns {Promise<void>}
  466. */
  467. async mergeCalcImage(ctx) {
  468. try {
  469. // 检查登录用户,是否可操作
  470. if (ctx.stage.readOnly) {
  471. throw '该计量期当前您无权操作';
  472. }
  473. const data = JSON.parse(ctx.request.body.data);
  474. if (data.updateType === 'update') {
  475. const create_time = Date.parse(new Date()) / 1000;
  476. const fileName = path.join('public/upload', this.ctx.tender.id.toString(), 'im', 'calcImg_' + create_time + '.jpg');
  477. const base64Data = data.img.replace(/^data:image\/\w+;base64,/, "");
  478. const dataBuffer = new Buffer(base64Data, 'base64');
  479. await this.ctx.helper.saveBufferFile(dataBuffer, path.join(this.app.baseDir, 'app', fileName));
  480. data.calc_img = fileName;
  481. data.calc_img_org = JSON.stringify(data.imgInfo);
  482. delete data.updateType;
  483. delete data.img;
  484. delete data.imgInfo;
  485. } else if (data.updateType === 'clear') {
  486. data.calc_img = null;
  487. data.calc_img_org = null;
  488. delete data.updateType;
  489. }
  490. await this.ctx.service.stageDetail.saveDetailData(data);
  491. const imData = await ctx.service.stageDetail.getLastestImStageData(this.ctx.tender.id, this.ctx.stage.id, data.lid, data.uuid);
  492. const responseData = {err: 0, msg: '', data: imData};
  493. ctx.body = responseData;
  494. } catch (err) {
  495. this.log(err);
  496. ctx.body = {err: 1, msg: err.toString(), data: null};
  497. }
  498. }
  499. /**
  500. * 中间计量 -- 完成中间计量(Post)
  501. * @param ctx
  502. * @returns {Promise<void>}
  503. */
  504. async doneDetail(ctx) {
  505. try {
  506. await ctx.service.stage.updateCheckDetailFlag(ctx.stage.id, false);
  507. ctx.stage.check_detail = false;
  508. ctx.redirect(ctx.request.header.referer);
  509. } catch (err) {
  510. ctx.redirect(ctx.request.header.referer);
  511. }
  512. }
  513. /**
  514. * 中间计量 -- 解锁编辑(Post)
  515. * @param ctx
  516. * @returns {Promise<void>}
  517. */
  518. async unlockDetail(ctx) {
  519. try {
  520. await ctx.service.stage.updateCheckDetailFlag(ctx.stage.id, true);
  521. ctx.stage.check_detail = true;
  522. ctx.redirect(ctx.request.header.referer);
  523. } catch (err) {
  524. ctx.redirect(ctx.request.header.referer);
  525. }
  526. }
  527. /**
  528. * 合同支付 (Get)
  529. * @param ctx
  530. * @returns {Promise<void>}
  531. */
  532. async pay(ctx) {
  533. try {
  534. await this._getStageAuditViewData(ctx);
  535. const renderData = await this._getDefaultRenderData(ctx);
  536. const dealPay = await ctx.service.stagePay.getStagePays(ctx.stage);
  537. // 附件不取下载地址
  538. for (const index in dealPay) {
  539. if (dealPay[index].attachment !== null) {
  540. const attachments = JSON.parse(dealPay[index].attachment);
  541. for (const att_index in attachments) {
  542. delete attachments[att_index].filepath;
  543. attachments[att_index].username = (await ctx.service.projectAccount.getAccountInfoById(attachments[att_index].uid)).name;
  544. }
  545. dealPay[index].attachment = attachments;
  546. }
  547. }
  548. renderData.dealPay = dealPay;
  549. // if (dealPay && dealPay.length > 0) {
  550. // renderData.dealPay = dealPay;
  551. // } else {
  552. // await ctx.service.pay.addDefaultPayData(this.ctx.tender.id);
  553. // await ctx.service.stagePay.addInitialStageData(ctx.stage);
  554. // renderData.dealPay = await ctx.service.stagePay.getStagePays(ctx.stage);
  555. // }
  556. renderData.calcBase = await ctx.service.stage.getStagePayCalcBase();
  557. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.pay);
  558. renderData.whiteList = this.ctx.app.config.multipart.whitelist;
  559. // 用户有无权限上传和删除附件
  560. renderData.uploadPermission = ((ctx.stage.status === auditConst.status.uncheck || ctx.stage.status === auditConst.status.checkNo) && ctx.session.sessionUser.accountId === ctx.stage.user_id) ||
  561. (ctx.stage.status === auditConst.status.checkNoPre && ctx.session.sessionUser.accountId === ctx.stage.curAuditor.aid) ||
  562. (ctx.stage.status === auditConst.status.checking && ctx.stage.curAuditor && ctx.stage.curAuditor.aid === ctx.session.sessionUser.accountId);
  563. // 计算 本期金额
  564. const payCalculator = new PayCalculator(this.ctx, this.ctx.tender.info.decimal);
  565. await payCalculator.calculateAll(renderData.dealPay);
  566. await this.layout('stage/pay.ejs', renderData, 'stage/pay_modal.ejs');
  567. } catch (err) {
  568. console.log(err);
  569. this.log(err);
  570. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage');
  571. }
  572. }
  573. /**
  574. * 合同支付 - 编辑合同支付项 (Ajax)
  575. * @param ctx
  576. * @returns {Promise<void>}
  577. */
  578. async savePayData(ctx) {
  579. function checkCalcField(data) {
  580. return data.sexpr !== undefined || data.sprice !== undefined
  581. || data.rexpr !== undefined || data.rprice !== undefined
  582. || data.minus !== undefined || data.is_yf !== undefined || data.dl_type !== undefined
  583. }
  584. try {
  585. // 检查登录用户,是否可操作
  586. if (ctx.stage.readOnly) {
  587. throw '该计量期当前您无权操作';
  588. }
  589. const data = JSON.parse(ctx.request.body.data);
  590. const responseData = { err: 0, msg: '', data: {}, };
  591. const payCalculator = new PayCalculator(this.ctx, this.ctx.tender.info.decimal);
  592. switch (data.type) {
  593. case 'add':
  594. responseData.data = await ctx.service.pay.add();
  595. responseData.data = await ctx.service.stagePay.getStagePay(ctx.stage, responseData.data.pid);
  596. break;
  597. case 'del':
  598. await ctx.service.pay.del(data.id);
  599. responseData.data = await ctx.service.stagePay.getStagePays(ctx.stage);
  600. await payCalculator.calculate(responseData.data);
  601. break;
  602. case 'changeOrder':
  603. responseData.data = await ctx.service.pay.changeOrder(data.id1, data.id2);
  604. break;
  605. case 'info':
  606. responseData.data = await ctx.service.pay.save(data.updateData);
  607. const bReCalc = data.updateData instanceof Array ? checkCalcField(data.updateData[0]) : checkCalcField(data.updateData);
  608. if (bReCalc) {
  609. responseData.data = await ctx.service.stagePay.getStagePays(ctx.stage);
  610. await payCalculator.calculateAll(responseData.data);
  611. } else {
  612. if (data.updateData instanceof Array) {
  613. responseData.data = await ctx.service.stagePay.getStagePay(ctx.stage, this.app._.map(responseData.data, 'id'));
  614. } else {
  615. responseData.data = await ctx.service.stagePay.getStagePay(ctx.stage, responseData.data.id);
  616. }
  617. }
  618. break;
  619. case 'stage':
  620. await ctx.service.stagePay.save(data.updateData);
  621. responseData.data = await ctx.service.stagePay.getStagePays(ctx.stage);
  622. await payCalculator.calculateAll(responseData.data);
  623. break;
  624. }
  625. ctx.body = responseData;
  626. } catch(err) {
  627. this.log(err);
  628. ctx.body = {err: 1, msg: err.toString(), data: null};
  629. }
  630. }
  631. /**
  632. * 合同支付 - 章节明细 (Ajax-Post)
  633. * @param ctx
  634. * @returns {Promise<void>}
  635. */
  636. async chapterDetail(ctx) {
  637. const _ = this.app._;
  638. const fields = ['contract_tp', 'qc_tp', 'gather_tp', 'end_gather_tp'];
  639. function assignStageData(chapter, curStage, preStage) {
  640. chapter.contract_tp = curStage.contract_tp;
  641. chapter.qc_tp = curStage.qc_tp;
  642. chapter.gather_tp = ctx.helper.add(curStage.contract_tp, curStage.qc_tp);
  643. if (preStage) {
  644. chapter.pre_contract_tp = preStage.contract_tp;
  645. chapter.pre_qc_tp = preStage.qc_tp;
  646. chapter.pre_gather_tp = ctx.helper.add(preStage.contract_tp, preStage.qc_tp);
  647. chapter.end_contract_tp = ctx.helper.add(curStage.contract_tp, preStage.contract_tp);
  648. chapter.end_qc_tp = ctx.helper.add(curStage.qc_tp, preStage.qc_tp);
  649. chapter.end_gather_tp = ctx.helper.add(chapter.gather_tp, chapter.pre_gather_tp);
  650. } else {
  651. chapter.end_contract_tp = curStage.contract_tp;
  652. chapter.end_qc_tp = curStage.qc_tp;
  653. chapter.end_gather_tp = chapter.gather_tp;
  654. }
  655. }
  656. try {
  657. const chapterDetail = JSON.parse(JSON.stringify(payConst.chapterDetail));
  658. const calcDetail = _.sortBy(chapterDetail, ['cType']);
  659. for (const cd of calcDetail) {
  660. switch (cd.cType) {
  661. case 1:
  662. const tp = await ctx.service.stageBills.getSumTotalPriceGcl(ctx.stage, cd.filter);
  663. assignStageData(cd, tp);
  664. break;
  665. case 11:
  666. assignStageData(cd, await ctx.service.stageBills.getSumTotalPriceGcl(ctx.stage));
  667. break;
  668. case 21:
  669. const sum = _.find(calcDetail, {cType: 11});
  670. const chapters = _.filter(calcDetail, {cType: 1});
  671. for (const f of fields) {
  672. cd[f] = ctx.helper.sub(sum[f], this.ctx.helper.sum(_.map(chapters, f)));//_.sumBy(chapters, f));
  673. }
  674. break;
  675. case 31:
  676. assignStageData(cd, await ctx.service.stageBills.getSumTotalPriceNotGcl(ctx.stage));
  677. break;
  678. case 41:
  679. const sum1 = _.find(calcDetail, {cType: 11});
  680. const sum2 = _.find(calcDetail, {cType: 31});
  681. for (const f of fields) {
  682. cd[f] = ctx.helper.add(sum1.value, sum2.value);
  683. }
  684. break;
  685. }
  686. }
  687. ctx.body = {err: 0, msg: '', data: {detail: chapterDetail, decimal: ctx.tender.info.decimal}};
  688. } catch (err) {
  689. this.log(err);
  690. ctx.body = {err: 1, msg: err.toString(), data: null};
  691. }
  692. }
  693. // 变更令相关
  694. /**
  695. * 查询变更令 明细数据(包括附件、变更清单、累计使用情况、本期使用情况)
  696. * @param tid
  697. * @param sid
  698. * @param cid
  699. * @returns {Promise<{}>}
  700. * @private
  701. */
  702. async _getChangeDetailData(tid, sid, cid) {
  703. const data = {};
  704. data.attachments = await this.ctx.service.changeAtt.getChangeAttachment(cid);
  705. data.bills = await this.ctx.service.changeAuditList.getAllDataByCondition({where: {cid: cid}});
  706. data.addUsedBills = await this.ctx.service.stageChange.getUsedData(tid, cid);
  707. data.curUsedBills = await this.ctx.service.stageChange.getStageUsedData(sid, cid);
  708. return data;
  709. }
  710. /**
  711. * 获取变更数据 Post(Ajax)
  712. * @param ctx
  713. * @returns {Promise<void>}
  714. */
  715. async getChangeData(ctx) {
  716. try {
  717. const data = {};
  718. data.tenderInfo = ctx.tender.info;
  719. data.ledger = await ctx.service.ledger.getData(ctx.tender.id);
  720. data.usedChangesId = await ctx.service.stageChange.getStageUsedChangeId(ctx.stage.id);
  721. data.changes = await ctx.service.change.getChangeAndUsedInfo(ctx.tender.id);
  722. if (data.changes.length > 0) {
  723. const change = data.changes[0];
  724. change.detail = await this._getChangeDetailData(ctx.tender.id, ctx.stage.id, change.cid);
  725. }
  726. ctx.body = {err: 0, msg: '', data: data};
  727. } catch (err) {
  728. this.log(err);
  729. ctx.body = {err: 1, msg: err.toString(), data: null};
  730. }
  731. }
  732. /**
  733. * 变更令 (Get)
  734. * @param ctx
  735. * @returns {Promise<void>}
  736. */
  737. async change(ctx) {
  738. try {
  739. await this._getStageAuditViewData(ctx);
  740. const renderData = await this._getDefaultRenderData(ctx);
  741. renderData.changeConst = changeConst;
  742. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.change);
  743. await this.layout('stage/change.ejs', renderData, 'stage/audit_modal.ejs');
  744. } catch (err) {
  745. this.log(err);
  746. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage');
  747. }
  748. }
  749. // 审批相关
  750. /**
  751. * 添加审批人
  752. * @param ctx
  753. * @returns {Promise<void>}
  754. */
  755. async addAudit(ctx) {
  756. try {
  757. const data = JSON.parse(ctx.request.body.data);
  758. const id = this.app._.toInteger(data.auditorId);
  759. if (isNaN(id) || id <= 0) {
  760. throw '参数错误';
  761. }
  762. // 检查权限等
  763. if (ctx.stage.user_id !== ctx.session.sessionUser.accountId) {
  764. throw '您无权添加审核人';
  765. }
  766. if (ctx.stage.status === auditConst.status.checking || ctx.stage.status === auditConst.status.checked) {
  767. throw '当前不允许添加审核人';
  768. }
  769. ctx.stage.auditorList = await ctx.service.stageAudit.getAuditors(ctx.stage.id, ctx.stage.times);
  770. // 检查审核人是否已存在
  771. const exist = this.app._.find(ctx.stage.auditorList, {aid: id});
  772. if (exist) {
  773. throw '该审核人已存在,请勿重复添加';
  774. }
  775. const result = await ctx.service.stageAudit.addAuditor(ctx.stage.id, id, ctx.stage.times);
  776. if (!result) {
  777. throw '添加审核人失败';
  778. }
  779. const audit = await ctx.service.stageAudit.getAuditor(ctx.stage.id, id, ctx.stage.times);
  780. ctx.body = {err: 0, msg: '', data: audit};
  781. } catch (err) {
  782. this.log(err);
  783. ctx.body = {err: 1, msg: err.toString(), data: null};
  784. }
  785. }
  786. /**
  787. * 移除审批人
  788. * @param ctx
  789. * @returns {Promise<void>}
  790. */
  791. async deleteAudit(ctx) {
  792. try {
  793. const data = JSON.parse(ctx.request.body.data);
  794. const id = data.auditorId instanceof Number ? data.auditorId : this.app._.toNumber(data.auditorId);
  795. if (isNaN(id) || id <= 0) {
  796. throw '参数错误';
  797. }
  798. const result = await ctx.service.stageAudit.deleteAuditor(ctx.stage.id, id, ctx.stage.times);
  799. if (!result) {
  800. throw '移除审核人失败';
  801. }
  802. const auditors = await ctx.service.stageAudit.getAuditors(ctx.stage.id, ctx.stage.times);
  803. ctx.body = {err: 0, msg: '', data: auditors};
  804. } catch (err) {
  805. ctx.body = {err: 1, msg: err.toString(), data: null};
  806. }
  807. }
  808. /**
  809. * 上报
  810. * @param ctx
  811. * @returns {Promise<void>}
  812. */
  813. async startAudit(ctx) {
  814. try {
  815. // 检查权限等
  816. if (!ctx.stage) {
  817. throw '数据错误';
  818. }
  819. if (ctx.stage.user_id !== ctx.session.sessionUser.accountId) {
  820. throw '您无权上报该期数据';
  821. }
  822. if (ctx.stage.status === auditConst.status.checking || ctx.stage.status === auditConst.status.checked) {
  823. throw '该期数据当前无法上报';
  824. }
  825. if (ctx.stage.check_detail) {
  826. throw '上报前,需要完成中间计量。';
  827. }
  828. await ctx.service.stageAudit.start(ctx.stage.id, ctx.stage.times);
  829. ctx.redirect(ctx.request.header.referer);
  830. } catch (err) {
  831. this.log(err);
  832. ctx.session.postError = err.toString();
  833. ctx.redirect(ctx.request.header.referer);
  834. }
  835. }
  836. /**
  837. * 审批
  838. * @param ctx
  839. * @returns {Promise<void>}
  840. */
  841. async checkAudit(ctx) {
  842. try {
  843. if (!this.ctx.stage || (this.ctx.stage.status !== auditConst.status.checking && this.ctx.stage.status !== auditConst.status.checkNoPre)) {
  844. throw '当前期数据有误';
  845. }
  846. if (!this.ctx.stage.curAuditor || this.ctx.stage.curAuditor.aid !== ctx.session.sessionUser.accountId) {
  847. throw '您无权进行该操作';
  848. }
  849. const data = {
  850. checkType: parseInt(ctx.request.body.checkType),
  851. opinion: ctx.request.body.opinion,
  852. };
  853. if (!data.checkType || isNaN(data.checkType)) {
  854. throw '提交数据错误';
  855. }
  856. if (data.checkType === auditConst.status.checked && ctx.stage.check_detail) {
  857. throw '审批通过前,需要中间计量。';
  858. }
  859. if (data.checkType === auditConst.status.checkNo) {
  860. if (!data.checkType || isNaN(data.checkType)) {
  861. throw '提交数据错误';
  862. }
  863. }
  864. await ctx.service.stageAudit.check(ctx.stage.id, data, ctx.stage.times);
  865. ctx.redirect(ctx.request.header.referer);
  866. } catch (err) {
  867. console.log(err);
  868. this.log(err);
  869. ctx.session.postError = err.toString();
  870. ctx.redirect(ctx.request.header.referer);
  871. }
  872. }
  873. /**
  874. * 重新审批
  875. * @param ctx
  876. * @returns {Promise<void>}
  877. */
  878. async checkAuditAgain(ctx) {
  879. try {
  880. if (ctx.stage.auditors[ctx.stage.auditors.length - 1].aid === ctx.session.sessionUser.accountId && ctx.stage.status === auditConst.status.checked && ctx.stage.order === ctx.stage.highOrder) {
  881. await ctx.service.stageAudit.checkAgain(ctx.stage.id, ctx.stage.times);
  882. console.log('success');
  883. ctx.redirect(ctx.request.header.referer);
  884. } else {
  885. throw '您无权进行该操作';
  886. }
  887. } catch (err) {
  888. console.log(err);
  889. this.log(err);
  890. ctx.session.postError = err.toString();
  891. ctx.redirect(ctx.request.header.referer);
  892. }
  893. }
  894. // 清单汇总相关
  895. _getGatherSpreadSetting() {
  896. const _ = this.app._;
  897. function removeFieldCols(setting, cols) {
  898. _.remove(setting.cols, function (c) {
  899. return cols.indexOf(c.field) > -1;
  900. });
  901. }
  902. function setColFormat(cols, field, formatter) {
  903. const filterCols = cols.filter(function (c) {
  904. return c.field.search(field) !== -1;
  905. });
  906. for (const col of filterCols) {
  907. col.formatter = formatter;
  908. }
  909. }
  910. const tpFormatter = this.ctx.helper.getNumberFormatter(this.ctx.tender.info.decimal.tp);
  911. const upFormatter = this.ctx.helper.getNumberFormatter(2);
  912. const gcl = JSON.parse(JSON.stringify(spreadConst.stageGather.gcl));
  913. setColFormat(gcl.cols, 'unit_price', upFormatter);
  914. setColFormat(gcl.cols, 'total_price', tpFormatter);
  915. setColFormat(gcl.cols, 'tp', tpFormatter);
  916. const leafXmj = JSON.parse(JSON.stringify(spreadConst.stageGather.leafXmj));
  917. const tender = this.ctx.tender;
  918. if (tender.data.measure_type === measureType.tz.value) {
  919. removeFieldCols(gcl, spreadConst.filterCols.tzWithoutCols);
  920. }
  921. return [gcl, leafXmj];
  922. }
  923. /**
  924. * 清单汇总 页面 (Get)
  925. * @param ctx
  926. * @returns {Promise<void>}
  927. */
  928. async gather(ctx) {
  929. try {
  930. await this._getStageAuditViewData(ctx);
  931. const renderData = await this._getDefaultRenderData(ctx);
  932. [renderData.gclSpread, renderData.leafXmjSpread] = this._getGatherSpreadSetting();
  933. renderData.ledger = await ctx.service.ledger.getData(ctx.tender.id);
  934. renderData.curLedgerData = await ctx.service.stageBills.getAuditorStageData(ctx.tender.id, ctx.stage.id, ctx.stage.times, 0);
  935. renderData.pos = await ctx.service.pos.getPosData({tid: ctx.tender.id});
  936. // todo 根据当前人,或指定对象查询数据
  937. renderData.curPosData = await ctx.service.stagePos.getAuditorStageData(ctx.tender.id,
  938. ctx.stage.id, ctx.stage.times, ctx.stage.curAuditor ? ctx.stage.curAuditor.order : 0);
  939. //renderData.gcl = await this.ctx.service.ledger.getAllLeafGclBills(this.ctx.tender.id);
  940. renderData.dealBills = await ctx.service.dealBills.getAllDataByCondition({ where: {tender_id: this.ctx.tender.id} });
  941. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.gather);
  942. await this.layout('stage/gather.ejs', renderData, 'stage/gather_modal.ejs');
  943. } catch (err) {
  944. this.log(err);
  945. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage/' + ctx.params.order);
  946. }
  947. }
  948. /**
  949. * 审核比较 页面 (Get)
  950. * @param ctx
  951. * @returns {Promise<void>}
  952. */
  953. async compare(ctx) {
  954. function getCompareSpreadSetting () {
  955. function setColFormat(cols, field, formatter) {
  956. const filterCols = cols.filter(function (c) {
  957. return c.field.search(field) !== -1;
  958. });
  959. for (const col of filterCols) {
  960. col.formatter = formatter;
  961. }
  962. }
  963. const tpFormatter = ctx.helper.getNumberFormatter(ctx.tender.info.decimal.tp);
  964. const upFormatter = ctx.helper.getNumberFormatter(2);
  965. const ledger = JSON.parse(JSON.stringify(spreadConst.stageCompare.ledger));
  966. setColFormat(ledger.baseCols, 'unit_price', upFormatter);
  967. setColFormat(ledger.extraCols, 'total_price', tpFormatter);
  968. setColFormat(ledger.extraCols, 'tp', tpFormatter);
  969. const pos = JSON.parse(JSON.stringify(spreadConst.stageCompare.pos));
  970. return [ledger, pos];
  971. }
  972. try {
  973. await this._getStageAuditViewData(ctx);
  974. const renderData = await this._getDefaultRenderData(ctx);
  975. [renderData.ledgerSpread, renderData.posSpread] = getCompareSpreadSetting();
  976. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.compare);
  977. await this.layout('stage/compare.ejs', renderData, 'stage/compare_modal.ejs');
  978. } catch (err) {
  979. this.log(err);
  980. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage/' + ctx.params.order);
  981. }
  982. }
  983. async compareAuditor(ctx) {
  984. try {
  985. const data = JSON.parse(ctx.request.body.data);
  986. const result = {
  987. main: null,
  988. roles: []
  989. };
  990. if (data.main) {
  991. result.main = {};
  992. result.main.ledger = await ctx.service.ledger.getData(ctx.tender.id);
  993. result.main.pos = await ctx.service.pos.getPosData({tid: ctx.tender.id});
  994. }
  995. for (const order of data.roles) {
  996. const data = { order: order, bills: [], pos: [] };
  997. data.bills = await ctx.service.stageBills.getAuditorStageData(ctx.tender.id, ctx.stage.id, ctx.stage.times, order);
  998. data.pos = await ctx.service.stagePos.getAuditorStageData(ctx.tender.id, ctx.stage.id, ctx.stage.times, order);
  999. result.roles.push(data);
  1000. }
  1001. ctx.body = {err: 0, msg: '', data: result};
  1002. } catch (err) {
  1003. this.log(err);
  1004. ctx.body = {err: 1, msg: err.toString(), data: null};
  1005. }
  1006. }
  1007. /**
  1008. * 报表
  1009. * @param ctx
  1010. * @returns {Promise<void>}
  1011. */
  1012. async report(ctx) {
  1013. try {
  1014. const renderData = await this._getDefaultRenderData(ctx);
  1015. await this.layout('stage/report.ejs', renderData, 'stage/report_modal.ejs');
  1016. } catch (err) {
  1017. this.log(err);
  1018. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage');
  1019. }
  1020. }
  1021. /**
  1022. * 上传附件
  1023. * @param {Object} ctx - egg全局变量
  1024. * @return {void}
  1025. */
  1026. async uploadFile(ctx) {
  1027. const responseData = {
  1028. err: 0,
  1029. msg: '',
  1030. data: [],
  1031. };
  1032. let stream;
  1033. try {
  1034. const parts = ctx.multipart({ autoFields: true });
  1035. const files = [];
  1036. let index = 0;
  1037. while ((stream = await parts()) !== undefined) {
  1038. // 判断用户是否选择上传文件
  1039. if (!stream.filename) {
  1040. throw '请选择上传的文件!';
  1041. }
  1042. const dirName = 'app/public/upload/stage/' + moment().format('YYYYMMDD');
  1043. // 判断文件夹是否存在,不存在则直接创建文件夹
  1044. if (!fs.existsSync(path.join(this.app.baseDir, dirName))) {
  1045. await fs.mkdirSync(path.join(this.app.baseDir, dirName));
  1046. }
  1047. const create_time = Date.parse(new Date()) / 1000;
  1048. const fileInfo = path.parse(stream.filename);
  1049. const fileName = 'stage' + create_time + '_' + index + fileInfo.ext;
  1050. // 保存文件
  1051. await ctx.helper.saveStreamFile(stream, path.join(this.app.baseDir, dirName, fileName));
  1052. if (stream) {
  1053. await sendToWormhole(stream);
  1054. }
  1055. // 保存数据到att表
  1056. const fileData = {
  1057. tid: ctx.params.id,
  1058. sid: ctx.params.order,
  1059. in_time: create_time,
  1060. filename: fileInfo.name,
  1061. fileext: fileInfo.ext,
  1062. filesize: Array.isArray(parts.field.size) ? parts.field.size[index] : parts.field.size,
  1063. filepath: path.join(dirName, fileName),
  1064. };
  1065. const result = await ctx.service.stageAtt.save(parts.field, fileData, ctx.session.sessionUser.accountId);
  1066. if (!result) {
  1067. throw '导入数据库保存失败';
  1068. }
  1069. const attData = await ctx.service.stageAtt.getDataByFid(result.insertId);
  1070. attData.in_time = moment(create_time * 1000).format('YYYY-MM-DD');
  1071. files.length !== 0 ? files.unshift(attData) : files.push(attData);
  1072. ++index;
  1073. }
  1074. responseData.data = files;
  1075. } catch (err) {
  1076. this.log(err);
  1077. // 失败需要消耗掉stream 以防卡死
  1078. if (stream) {
  1079. await sendToWormhole(stream);
  1080. }
  1081. this.setMessage(err.toString(), this.messageType.ERROR);
  1082. responseData.err = 1;
  1083. responseData.msg = err.toString();
  1084. }
  1085. ctx.body = responseData;
  1086. }
  1087. /**
  1088. * 下载附件
  1089. * @param {Object} ctx - egg全局变量
  1090. * @return {void}
  1091. */
  1092. async downloadFile(ctx) {
  1093. const id = ctx.params.fid;
  1094. if (id) {
  1095. try {
  1096. const fileInfo = await ctx.service.stageAtt.getDataById(id);
  1097. if (fileInfo !== undefined && fileInfo !== '') {
  1098. const fileName = path.join(this.app.baseDir, fileInfo.filepath);
  1099. // 解决中文无法下载问题
  1100. const userAgent = (ctx.request.header['user-agent'] || '').toLowerCase();
  1101. let disposition = '';
  1102. if (userAgent.indexOf('msie') >= 0 || userAgent.indexOf('chrome') >= 0) {
  1103. disposition = 'attachment; filename=' + encodeURIComponent(fileInfo.filename + fileInfo.fileext);
  1104. } else if (userAgent.indexOf('firefox') >= 0) {
  1105. disposition = 'attachment; filename*="utf8\'\'' + encodeURIComponent(fileInfo.filename + fileInfo.fileext) + '"';
  1106. } else {
  1107. /* safari等其他非主流浏览器只能自求多福了 */
  1108. disposition = 'attachment; filename=' + new Buffer(fileInfo.filename + fileInfo.fileext).toString('binary');
  1109. }
  1110. ctx.response.set({
  1111. 'Content-Type': 'application/octet-stream',
  1112. 'Content-Disposition': disposition,
  1113. 'Content-Length': fileInfo.filesize,
  1114. });
  1115. ctx.body = await fs.createReadStream(fileName);
  1116. } else {
  1117. throw '不存在该文件';
  1118. }
  1119. } catch (err) {
  1120. this.log(err);
  1121. this.setMessage(err.toString(), this.messageType.ERROR);
  1122. }
  1123. }
  1124. }
  1125. /**
  1126. * 删除附件
  1127. * @param {Object} ctx - egg全局变量
  1128. * @return {void}
  1129. */
  1130. async deleteFile(ctx) {
  1131. const responseData = {
  1132. err: 0,
  1133. msg: '',
  1134. data: '',
  1135. };
  1136. try {
  1137. const data = JSON.parse(ctx.request.body.data);
  1138. const fileInfo = await ctx.service.stageAtt.getDataById(data.id);
  1139. if (fileInfo !== undefined && fileInfo !== '') {
  1140. // 先删除文件
  1141. await fs.unlinkSync(path.join(this.app.baseDir, fileInfo.filepath));
  1142. // 再删除数据库
  1143. await ctx.service.stageAtt.deleteById(data.id);
  1144. responseData.data = '';
  1145. } else {
  1146. throw '不存在该文件';
  1147. }
  1148. // if (data.tid === undefined || data.uci === undefined || data.uc === undefined || data.ac === undefined) {
  1149. // throw '参数有误';
  1150. // }
  1151. // const [addCompany, selectCompany] = await ctx.service.changeCompany.setCompanyList(data);
  1152. // responseData.data = { add: addCompany, select: selectCompany };
  1153. } catch (err) {
  1154. responseData.err = 1;
  1155. responseData.msg = err;
  1156. }
  1157. ctx.body = responseData;
  1158. }
  1159. /**
  1160. * 保存附件(或替换)
  1161. * @param {Object} ctx - egg全局变量
  1162. * @return {void}
  1163. */
  1164. async saveFile(ctx) {
  1165. const responseData = {
  1166. err: 0,
  1167. msg: '',
  1168. data: [],
  1169. };
  1170. let stream;
  1171. try {
  1172. stream = await ctx.getFileStream({ requireFile: false });
  1173. let fileData = {};
  1174. if (stream.filename !== undefined) {
  1175. const create_time = Date.parse(new Date()) / 1000;
  1176. const fileInfo = path.parse(stream.filename);
  1177. const dirName = 'app/public/upload/stage/' + moment().format('YYYYMMDD');
  1178. const fileName = 'stage' + create_time + fileInfo.ext;
  1179. // 判断文件夹是否存在,不存在则直接创建文件夹
  1180. if (!fs.existsSync(path.join(this.app.baseDir, dirName))) {
  1181. await fs.mkdirSync(path.join(this.app.baseDir, dirName));
  1182. }
  1183. // 保存文件
  1184. await ctx.helper.saveStreamFile(stream, path.join(this.app.baseDir, dirName, fileName));
  1185. // 保存数据到att表
  1186. fileData = {
  1187. filesize: stream.fields.size,
  1188. filepath: path.join(dirName, fileName),
  1189. };
  1190. }
  1191. const result = await ctx.service.stageAtt.updateByID(stream.fields, fileData);
  1192. if (!result) {
  1193. throw '导入数据库保存失败';
  1194. }
  1195. const attData = await ctx.service.stageAtt.getDataByFid(stream.fields.id);
  1196. attData.in_time = moment(attData.in_time * 1000).format('YYYY-MM-DD');
  1197. responseData.data = attData;
  1198. } catch (err) {
  1199. this.log(err);
  1200. // 失败需要消耗掉stream 以防卡死
  1201. if (stream) {
  1202. await sendToWormhole(stream);
  1203. }
  1204. this.setMessage(err.toString(), this.messageType.ERROR);
  1205. responseData.err = 1;
  1206. responseData.msg = err.toString();
  1207. }
  1208. ctx.body = responseData;
  1209. }
  1210. /**
  1211. * 合同支付上传附件
  1212. * @param {Object} ctx - egg全局变量
  1213. * @return {void}
  1214. */
  1215. async payUploadFile(ctx) {
  1216. const responseData = {
  1217. err: 0,
  1218. msg: '',
  1219. data: [],
  1220. };
  1221. let stream;
  1222. try {
  1223. const parts = ctx.multipart({ autoFields: true });
  1224. const files = [];
  1225. let index = 0;
  1226. const create_time = Date.parse(new Date()) / 1000;
  1227. while ((stream = await parts()) !== undefined) {
  1228. // 判断用户是否选择上传文件
  1229. if (!stream.filename) {
  1230. throw '请选择上传的文件!';
  1231. }
  1232. const fileInfo = path.parse(stream.filename);
  1233. const dirName = 'app/public/upload/pay/' + moment().format('YYYYMMDD');
  1234. const fileName = 'pay' + create_time + '_' + index + fileInfo.ext;
  1235. // 判断文件夹是否存在,不存在则直接创建文件夹
  1236. if (!fs.existsSync(path.join(this.app.baseDir, dirName))) {
  1237. await fs.mkdirSync(path.join(this.app.baseDir, dirName));
  1238. }
  1239. // 保存文件
  1240. await ctx.helper.saveStreamFile(stream, path.join(this.app.baseDir, dirName, fileName));
  1241. await sendToWormhole(stream);
  1242. // 插入到stage_pay对应的附件列表中
  1243. const attData = {
  1244. filename: fileInfo.name,
  1245. fileext: fileInfo.ext,
  1246. filesize: Array.isArray(parts.field.size) ? parts.field.size[index] : parts.field.size,
  1247. filepath: path.join(dirName, fileName),
  1248. uid: ctx.session.sessionUser.accountId,
  1249. in_time: moment(create_time * 1000).format('YYYY-MM-DD'),
  1250. };
  1251. const result = await ctx.service.stagePay.saveAtt(parts.field.pay_id, attData);
  1252. if (!result) {
  1253. throw '导入数据库保存失败';
  1254. }
  1255. delete attData.filepath;
  1256. attData.username = ctx.session.sessionUser.name;
  1257. files.length !== 0 ? files.unshift(attData) : files.push(attData);
  1258. ++index;
  1259. }
  1260. responseData.data = files;
  1261. } catch (err) {
  1262. this.log(err);
  1263. // 失败需要消耗掉stream 以防卡死
  1264. if (stream) {
  1265. await sendToWormhole(stream);
  1266. }
  1267. this.setMessage(err.toString(), this.messageType.ERROR);
  1268. responseData.err = 1;
  1269. responseData.msg = err.toString();
  1270. }
  1271. ctx.body = responseData;
  1272. }
  1273. /**
  1274. * 合同支付下载附件
  1275. * @param {Object} ctx - egg全局变量
  1276. * @return {void}
  1277. */
  1278. async payDownloadFile(ctx) {
  1279. const id = ctx.params.pid;
  1280. const index = ctx.params.index;
  1281. if (id && index) {
  1282. try {
  1283. const payInfo = await ctx.service.stagePay.getDataById(id);
  1284. if (payInfo !== undefined && payInfo.attachment !== null) {
  1285. const fileInfo = JSON.parse(payInfo.attachment)[index];
  1286. const fileName = path.join(this.app.baseDir, fileInfo.filepath);
  1287. // 解决中文无法下载问题
  1288. const userAgent = (ctx.request.header['user-agent'] || '').toLowerCase();
  1289. let disposition = '';
  1290. if (userAgent.indexOf('msie') >= 0 || userAgent.indexOf('chrome') >= 0) {
  1291. disposition = 'attachment; filename=' + encodeURIComponent(fileInfo.filename + fileInfo.fileext);
  1292. } else if (userAgent.indexOf('firefox') >= 0) {
  1293. disposition = 'attachment; filename*="utf8\'\'' + encodeURIComponent(fileInfo.filename + fileInfo.fileext) + '"';
  1294. } else {
  1295. /* safari等其他非主流浏览器只能自求多福了 */
  1296. disposition = 'attachment; filename=' + new Buffer(fileInfo.filename + fileInfo.fileext).toString('binary');
  1297. }
  1298. ctx.response.set({
  1299. 'Content-Type': 'application/octet-stream',
  1300. 'Content-Disposition': disposition,
  1301. 'Content-Length': fileInfo.filesize,
  1302. });
  1303. ctx.body = await fs.createReadStream(fileName);
  1304. } else {
  1305. throw '不存在该文件';
  1306. }
  1307. } catch (err) {
  1308. this.log(err);
  1309. this.setMessage(err.toString(), this.messageType.ERROR);
  1310. }
  1311. }
  1312. }
  1313. /**
  1314. * 合同支付删除附件
  1315. * @param {Object} ctx - egg全局变量
  1316. * @return {void}
  1317. */
  1318. async payDeleteFile(ctx) {
  1319. const responseData = {
  1320. err: 0,
  1321. msg: '',
  1322. data: '',
  1323. };
  1324. try {
  1325. const data = JSON.parse(ctx.request.body.data);
  1326. const payInfo = await ctx.service.stagePay.getDataById(data.id);
  1327. if (payInfo !== undefined) {
  1328. const fileInfo = JSON.parse(payInfo.attachment)[data.index];
  1329. // 先删除文件
  1330. await fs.unlinkSync(path.join(this.app.baseDir, fileInfo.filepath));
  1331. // 再删除数据库
  1332. const attachment = JSON.parse(payInfo.attachment);
  1333. attachment.splice(data.index, 1);
  1334. const result = await ctx.service.stagePay.deleteAtt(data.id, attachment);
  1335. responseData.data = '';
  1336. } else {
  1337. throw '不存在该文件';
  1338. }
  1339. // if (data.tid === undefined || data.uci === undefined || data.uc === undefined || data.ac === undefined) {
  1340. // throw '参数有误';
  1341. // }
  1342. // const [addCompany, selectCompany] = await ctx.service.changeCompany.setCompanyList(data);
  1343. // responseData.data = { add: addCompany, select: selectCompany };
  1344. } catch (err) {
  1345. responseData.err = 1;
  1346. responseData.msg = err;
  1347. }
  1348. ctx.body = responseData;
  1349. }
  1350. }
  1351. return StageController;
  1352. };