stage_controller.js 61 KB

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