stage_controller.js 64 KB

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