stage_controller.js 87 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855
  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 shenpiConst = require('../const/shenpi');
  15. const payConst = require('../const/deal_pay.js');
  16. const externalDataConst = require('../const/external_data.js');
  17. const changeConst = require('../const/change');
  18. const measureType = tenderConst.measureType;
  19. const path = require('path');
  20. const PayCalculator = require('../lib/pay_calc');
  21. const accountGroup = require('../const/account_group').group;
  22. const sendToWormhole = require('stream-wormhole');
  23. const billsPosConvert = require('../lib/bills_pos_convert');
  24. const fs = require('fs');
  25. const stdConst = require('../const/standard');
  26. module.exports = app => {
  27. class StageController extends app.BaseController {
  28. /**
  29. * 构造函数
  30. *
  31. * @param {Object} ctx - egg全局变量
  32. * @return {void}
  33. */
  34. constructor(ctx) {
  35. super(ctx);
  36. ctx.showProject = true;
  37. ctx.showTender = true;
  38. ctx.showTitle = true;
  39. // ctx.reUploadPermission = false;
  40. }
  41. /**
  42. * 获取通用的renderData(用于layout, Menu, subMenu部分)
  43. * @param ctx
  44. * @return {{tender, tenderMenu, auditConst}}
  45. * @private
  46. */
  47. async _getDefaultRenderData(ctx) {
  48. const data = {
  49. tender: ctx.tender.data,
  50. tenderMenu: JSON.parse(JSON.stringify(this.menu.stageMenu)),
  51. auditConst,
  52. measureType,
  53. preUrl: '/tender/' + ctx.tender.id + '/measure/stage/' + ctx.params.order,
  54. stage: ctx.stage,
  55. thirdParty: {
  56. gxby: ctx.session.sessionProject.gxby_status,
  57. dagl: ctx.session.sessionProject.dagl_status,
  58. },
  59. shenpiConst,
  60. };
  61. if ((ctx.stage.status === auditConst.status.uncheck || ctx.stage.status === auditConst.status.checkNo) && ctx.session.sessionUser.accountId === ctx.stage.user_id) {
  62. // data.accountGroup = accountGroup;
  63. // 获取所有项目参与者
  64. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  65. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  66. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  67. });
  68. data.accountList = accountList;
  69. data.accountGroup = accountGroup.map((item, idx) => {
  70. const groupList = accountList.filter(item => item.account_group === idx);
  71. return { groupName: item, groupList };
  72. });
  73. }
  74. data.tenderMenu.back.children[0].url = '/tender/' + ctx.tender.id + '/measure/stage';
  75. // 是否已验证手机短信
  76. const pa = await ctx.service.projectAccount.getDataById(ctx.session.sessionUser.accountId);
  77. data.authMobile = pa.auth_mobile;
  78. return data;
  79. }
  80. /**
  81. * 获取SpreadSetting
  82. * @private
  83. */
  84. _getSpreadSetting() {
  85. const _ = this.app._;
  86. function removeFieldCols(setting, cols) {
  87. _.remove(setting.cols, function(c) {
  88. return cols.indexOf(c.field) > -1;
  89. });
  90. }
  91. function setColFormat(cols, field, formatter) {
  92. const filterCols = cols.filter(function(c) {
  93. return c.field.search(field) !== -1;
  94. });
  95. for (const col of filterCols) {
  96. col.formatter = formatter;
  97. }
  98. }
  99. // const tpFormatter = this.ctx.helper.getNumberFormatter(this.ctx.tender.info.decimal.tp);
  100. // const upFormatter = this.ctx.helper.getNumberFormatter(2);
  101. const tender = this.ctx.tender,
  102. stage = this.ctx.stage;
  103. const stageSetting = tender.data.measure_type === measureType.tz.value
  104. ? spreadConst.stageTz
  105. : (tender.info.display.ledger.clQty ? spreadConst.stageCl : spreadConst.stageNoCl);
  106. const ledger = JSON.parse(JSON.stringify(stageSetting.ledger));
  107. // setColFormat(ledger.cols, 'unit_price', upFormatter);
  108. // setColFormat(ledger.cols, 'total_price', tpFormatter);
  109. // setColFormat(ledger.cols, 'tp', tpFormatter);
  110. if (!tender.info.display.ledger.dgnQty) {
  111. removeFieldCols(ledger, spreadConst.filterCols.stageDgnCols);
  112. }
  113. const pos = JSON.parse(JSON.stringify(stageSetting.pos));
  114. if (!tender.info.display.stage.realComplete) {
  115. removeFieldCols(pos, spreadConst.filterCols.realCompleteCols);
  116. }
  117. if (!this.ctx.session.sessionProject.gxby) {
  118. removeFieldCols(ledger, spreadConst.filterCols.thirdPartyCols.gxby);
  119. removeFieldCols(pos, spreadConst.filterCols.thirdPartyCols.gxby);
  120. }
  121. if (!this.ctx.session.sessionProject.dagl) {
  122. removeFieldCols(ledger, spreadConst.filterCols.thirdPartyCols.dagl);
  123. removeFieldCols(pos, spreadConst.filterCols.thirdPartyCols.dagl);
  124. }
  125. if (this.ctx.stage.readOnly || this.ctx.stage.revising) {
  126. ledger.readOnly = true;
  127. pos.readOnly = true;
  128. }
  129. return [ledger, pos];
  130. }
  131. /**
  132. * 获取审批界面所需的 原报、审批人数据等
  133. * @param ctx
  134. * @return {Promise<void>}
  135. * @private
  136. */
  137. async _getStageAuditViewData(ctx) {
  138. const times = ctx.stage.status === auditConst.status.checkNo ? ctx.stage.times - 1 : ctx.stage.times;
  139. ctx.stage.user = await ctx.service.projectAccount.getAccountInfoById(ctx.stage.user_id);
  140. ctx.stage.auditHistory = [];
  141. if (times >= 1) {
  142. for (let i = 1; i <= times; i++) {
  143. ctx.stage.auditHistory.push(await ctx.service.stageAudit.getAuditors(ctx.stage.id, i));
  144. }
  145. }
  146. // 获取审批流程中左边列表
  147. ctx.stage.auditors2 = ctx.stage.status === auditConst.status.checkNo && ctx.stage.user_id !== ctx.session.sessionUser.accountId ?
  148. await ctx.service.stageAudit.getAuditGroupByListWithOwner(ctx.stage.id, times) :
  149. await ctx.service.stageAudit.getAuditGroupByListWithOwner(ctx.stage.id, ctx.stage.times);
  150. const { status } = ctx.stage;
  151. if (status === auditConst.status.uncheck || status === auditConst.status.checkNo) {
  152. ctx.stage.auditorList = await ctx.service.stageAudit.getAuditors(ctx.stage.id, ctx.stage.times);
  153. }
  154. }
  155. _checkStageCanModify(ctx) {
  156. // 检查登录用户,是否可操作
  157. if (ctx.stage.readOnly) {
  158. throw '该计量期当前您无权操作';
  159. }
  160. if (ctx.stage.revising) {
  161. throw '台账修订中,请勿修改提交期数据';
  162. }
  163. }
  164. /**
  165. * 期计量页面 (Get)
  166. * @param {Object} ctx - egg全局变量
  167. * @return {Promise<void>}
  168. */
  169. async index(ctx) {
  170. try {
  171. await this._getStageAuditViewData(ctx);
  172. const renderData = await this._getDefaultRenderData(ctx);
  173. [renderData.ledgerSpread, renderData.posSpread] = this._getSpreadSetting();
  174. const sjsRela = await this.ctx.service.project.getSjsRela(ctx.session.sessionProject.id);
  175. this.ctx.helper.refreshSpreadShow(sjsRela.ledgerCol, [renderData.ledgerSpread, renderData.posSpread]);
  176. renderData.changeConst = changeConst;
  177. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.index);
  178. renderData.whiteList = this.ctx.app.config.multipart.whitelist;
  179. renderData.imType = tenderConst.imType;
  180. renderData.curAuditor = ctx.stage.curAuditor;
  181. renderData.auditConst = auditConst;
  182. // 获取附件列表
  183. const attData = await ctx.service.stageAtt.getDataByTenderIdAndStageId(ctx.tender.id, ctx.params.order);
  184. for (const index in attData) {
  185. attData[index].in_time = moment(attData[index].in_time * 1000).format('YYYY-MM-DD');
  186. }
  187. renderData.attData = attData;
  188. renderData.coopwd = ((ctx.stage.status === auditConst.status.uncheck || ctx.stage.status === auditConst.status.checkNo) && ctx.session.sessionUser.accountId === ctx.stage.user_id) || ((ctx.stage.status === auditConst.status.checking || ctx.stage.status === auditConst.status.checkNoPre) && ctx.stage.curAuditor && ctx.stage.curAuditor.aid === ctx.session.sessionUser.accountId);
  189. await this.layout('stage/index.ejs', renderData, 'stage/modal.ejs');
  190. } catch (err) {
  191. this.log(err);
  192. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage');
  193. }
  194. }
  195. _checkUniqData(data, field) {
  196. const groupData = this.ctx.helper._.groupBy(data, field);
  197. const surplus = [];
  198. for (const gd in groupData) {
  199. if (groupData[gd].length > 1) {
  200. const first = groupData[gd][0];
  201. for (let i = 1, iLen = groupData[gd].length; i < iLen; i++) {
  202. const check = groupData[gd][i];
  203. if (this.ctx.helper._.isMatch({ field: check[field], sid: check.sid, order: check.order, times: check.times },
  204. { field: first[field], sid: first.sid, order: first.order, times: first.times })) {
  205. surplus.push(groupData[gd][i].id);
  206. }
  207. }
  208. }
  209. }
  210. return surplus;
  211. }
  212. async _getStageLedgerData(ctx) {
  213. const ledgerData = await ctx.service.ledger.getData(ctx.tender.id);
  214. const dgnData = await ctx.service.stageBillsDgn.getDgnData(ctx.tender.id);
  215. for (const d of dgnData) {
  216. const l = ctx.app._.find(ledgerData, { id: d.id });
  217. ctx.app._.assignIn(l, d);
  218. }
  219. let curStageData,
  220. preStageData;
  221. // 当前操作人查看最新数据,其他人查看历史数据
  222. if (ctx.stage.readOnly) {
  223. curStageData = await ctx.service.stageBills.getAuditorStageData(ctx.tender.id, ctx.stage.id, ctx.stage.curTimes, ctx.stage.curOrder);
  224. } else {
  225. curStageData = await ctx.service.stageBills.getLastestStageData(ctx.tender.id, ctx.stage.id);
  226. const surplus = this._checkUniqData(curStageData, 'lid');
  227. if (surplus.length > 0) {
  228. await ctx.service.stageBills.deleteById(surplus);
  229. }
  230. }
  231. // 查询截止上期数据
  232. if (ctx.stage.order > 1) {
  233. preStageData = await ctx.service.stageBillsFinal.getFinalData(ctx.tender.data, ctx.stage.order - 1);
  234. // renderData.preStageData = await ctx.service.stageBills.getEndStageData(ctx.tender.id, ctx.stage.order - 1);
  235. } else {
  236. preStageData = [];
  237. }
  238. this.ctx.helper.assignRelaData(ledgerData, [
  239. { data: curStageData, fields: ['contract_qty', 'contract_expr', 'contract_tp', 'qc_qty', 'qc_tp', 'postil'], prefix: '', relaId: 'lid' },
  240. { data: preStageData, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp', 'used'], prefix: 'pre_', relaId: 'lid' },
  241. ]);
  242. return ledgerData;
  243. }
  244. async _getStagePosData(ctx) {
  245. let curStageData,
  246. preStageData;
  247. const posData = await ctx.service.pos.getPosDataWithAddStageOrder({ tid: ctx.tender.id });
  248. // 根据当前人,或指定对象查询数据
  249. // console.time('cur');
  250. if (ctx.stage.readOnly) {
  251. curStageData = await ctx.service.stagePos.getAuditorStageData2(ctx.tender.id,
  252. ctx.stage.id, ctx.stage.curTimes, ctx.stage.curOrder);
  253. } else {
  254. curStageData = await ctx.service.stagePos.getLastestStageData2(ctx.tender.id, ctx.stage.id);
  255. const surplus = this._checkUniqData(curStageData, 'pid');
  256. if (surplus.length > 0) {
  257. await ctx.service.stagePos.deleteById(surplus);
  258. }
  259. }
  260. // console.timeEnd('cur');
  261. // 查询截止上期数据
  262. // console.time('pre');
  263. if (ctx.stage.order > 1) {
  264. preStageData = await ctx.service.stagePosFinal.getFinalData(ctx.tender.data, ctx.stage.order - 1);
  265. // responseData.data.preStageData = await ctx.service.stagePos.getEndStageData(ctx.tender.id, ctx.stage.order - 1);
  266. } else {
  267. preStageData = [];
  268. }
  269. // console.timeEnd('pre');
  270. // console.time('assign');
  271. // console.log('cur: ' + curStageData.length);
  272. // console.log('pre: ' + preStageData.length);
  273. this.ctx.helper.assignRelaData(posData, [
  274. { data: curStageData, fields: ['contract_qty', 'contract_expr', 'qc_qty', 'postil'], prefix: '', relaId: 'pid' },
  275. { data: preStageData, fields: ['contract_qty', 'qc_qty'], prefix: 'pre_', relaId: 'pid' },
  276. ]);
  277. return posData;
  278. }
  279. async _getStageDetailData(ctx) {
  280. if (ctx.stage.readOnly) {
  281. return await ctx.service.stageDetail.getAuditorStageData(ctx.tender.id, ctx.stage.id, ctx.stage.curTimes, ctx.stage.curOrder);
  282. }
  283. return await ctx.service.stageDetail.getLastestStageData(ctx.tender.id, ctx.stage.id);
  284. }
  285. async _getStageChangeData(ctx) {
  286. if (ctx.stage.readOnly) {
  287. return await ctx.service.stageChange.getAuditorAllStageData(ctx.tender.id, ctx.stage.id, ctx.stage.curTimes, ctx.stage.curOrder);
  288. }
  289. return await ctx.service.stageChange.getLastestAllStageData(ctx.tender.id, ctx.stage.id);
  290. }
  291. async getStageData(ctx) {
  292. try {
  293. const data = JSON.parse(ctx.request.body.data);
  294. const filter = data.filter.split(';');
  295. const responseData = { err: 0, msg: '', data: {} };
  296. for (const f of filter) {
  297. switch (f) {
  298. case 'ledger':
  299. responseData.data.ledgerData = await this._getStageLedgerData(ctx);
  300. break;
  301. case 'pos':
  302. responseData.data.posData = await this._getStagePosData(ctx);
  303. break;
  304. case 'detail':
  305. responseData.data.detailData = await this._getStageDetailData(ctx);
  306. break;
  307. case 'change':
  308. responseData.data.changeData = await this._getStageChangeData(ctx);
  309. break;
  310. case 'dealBills':
  311. responseData.data.dealBills = await ctx.service.dealBills.getAllDataByCondition({
  312. where: { tender_id: this.ctx.tender.id },
  313. });
  314. break;
  315. case 'tag':
  316. responseData.data.tags = await ctx.service.ledgerTag.getDatas(ctx.tender.id, ctx.stage.id);
  317. break;
  318. case 'cooperation':
  319. const uid = ctx.stage.curAuditor ?
  320. ctx.stage.curAuditor.aid :
  321. (ctx.stage.status === auditConst.status.uncheck ||
  322. (ctx.stage.status === auditConst.status.checkNo && ctx.stage.user_id === ctx.session.sessionUser.accountId) ?
  323. ctx.stage.user_id : (ctx.stage.status === auditConst.status.checkNo && ctx.stage.user_id !== ctx.session.sessionUser.accountId) ?
  324. ctx.session.sessionUser.accountId : null);
  325. responseData.data.cooperation = uid !== null ? await ctx.service.ledgerCooperation.getValidData(
  326. ctx.tender.id, uid) : [];
  327. const stageTimes = (ctx.stage.status === auditConst.status.checkNo && ctx.stage.user_id !== ctx.session.sessionUser.accountId) ? ctx.stage.times - 1 : ctx.stage.times;
  328. responseData.data.cooperationConfirm = uid !== null ? await ctx.service.cooperationConfirm.getValidData(ctx.tender.id, ctx.stage.id, stageTimes, uid) : [];
  329. break;
  330. case 'spec':
  331. const spec = {zlj: JSON.parse(JSON.stringify(stdConst.zlj)), jrg: stdConst.jrg};
  332. spec.zlj.deal_bills_tp = ctx.tender.info.deal_param.zanLiePrice;
  333. responseData.data.spec = spec;
  334. break;
  335. }
  336. }
  337. ctx.body = responseData;
  338. } catch (err) {
  339. this.log(err);
  340. ctx.body = { err: 1, msg: err.toString(), data: null };
  341. }
  342. }
  343. async check(ctx) {
  344. try {
  345. const ledgerData = await this._getStageLedgerData(ctx);
  346. const posData = await this._getStagePosData(ctx);
  347. const projRela = await this.ctx.service.project.getFunRela(this.ctx.session.sessionProject.id);
  348. const checkDataModel = require('../lib/ledger').checkData;
  349. const checkData = new checkDataModel(ctx, measureType);
  350. checkData.loadData(ledgerData, posData);
  351. await this.ctx.service.s2bProj.refreshSessionS2b();
  352. checkData.check3fLimit(ctx.tender.data);
  353. checkData.checkBillsQty(['sgfh_qty', 'qtcl_qty', 'sjcl_qty', 'quantity']);
  354. projRela.banOver && ctx.tender.info.ledger_check.over && checkData.checkOverRange(['contract_qty', 'qc_qty']);
  355. checkData.checkBillsTp([
  356. { qty: 'contract_qty', tp: 'contract_tp' }, { qty: 'qc_qty', tp: 'qc_tp' },
  357. ], this.ctx.tender.info.decimal, x => { return x.is_tp; });
  358. ctx.body = { err: 0, msg: '', data: checkData.checkResult };
  359. } catch (err) {
  360. this.log(err);
  361. ctx.body = this.ajaxErrorBody(err, '检查数据错误');
  362. }
  363. }
  364. /**
  365. * 获取期数据(截止上期 & 本期) (Ajax)
  366. * @param ctx
  367. * @return {Promise<void>}
  368. */
  369. async getStagePosData(ctx) {
  370. try {
  371. const condition = JSON.parse(ctx.request.body.data) || {};
  372. condition.tid = ctx.tender.id;
  373. const responseData = { err: 0, msg: '', data: {} };
  374. let curStageData,
  375. preStageData;
  376. responseData.data = await ctx.service.pos.getPosDataWithAddStageOrder(condition);
  377. // 根据当前人,或指定对象查询数据
  378. // console.time('cur');
  379. const curWhere = JSON.parse(ctx.request.body.data);
  380. if (ctx.stage.readOnly) {
  381. curStageData = await ctx.service.stagePos.getAuditorStageData2(ctx.tender.id,
  382. ctx.stage.id, ctx.stage.curTimes, ctx.stage.curOrder, curWhere);
  383. } else {
  384. curStageData = await ctx.service.stagePos.getLastestStageData2(ctx.tender.id, ctx.stage.id, curWhere);
  385. }
  386. // console.timeEnd('cur');
  387. // 查询截止上期数据
  388. // console.time('pre');
  389. if (ctx.stage.order > 1) {
  390. preStageData = await ctx.service.stagePosFinal.getFinalData(ctx.tender.data, ctx.stage.order - 1);
  391. // responseData.data.preStageData = await ctx.service.stagePos.getEndStageData(ctx.tender.id, ctx.stage.order - 1);
  392. } else {
  393. preStageData = [];
  394. }
  395. // console.timeEnd('pre');
  396. // console.time('assign');
  397. // console.log('cur: ' + curStageData.length);
  398. // console.log('pre: ' + preStageData.length);
  399. this.ctx.helper.assignRelaData(responseData.data, [
  400. { data: curStageData, fields: ['contract_qty', 'qc_qty', 'postil'], prefix: '', relaId: 'pid' },
  401. { data: preStageData, fields: ['contract_qty', 'qc_qty'], prefix: 'pre_', relaId: 'pid' },
  402. ]);
  403. // console.timeEnd('assign');
  404. ctx.body = responseData;
  405. } catch (err) {
  406. this.log(err);
  407. ctx.body = { err: 1, msg: err.toString(), data: null };
  408. }
  409. }
  410. /**
  411. * 保存数据 (Ajax)
  412. * @param ctx
  413. * @return {Promise<void>}
  414. */
  415. async updateStageData(ctx) {
  416. try {
  417. this._checkStageCanModify(ctx);
  418. const data = JSON.parse(ctx.request.body.data);
  419. const responseData = { err: 0, msg: '', data: {} };
  420. if (data.pos) {
  421. responseData.data = await ctx.service.stagePos.updateStageData(data.pos);
  422. } else if (data.bills) {
  423. if (data.bills.main) {
  424. const updateDatas = data.bills.main instanceof Array ? data.bills.main : [data.bills.main];
  425. const result = await ctx.app.mysql.updateRows(ctx.service.ledger.tableName, updateDatas);
  426. responseData.data.bills = await ctx.service.ledger.getDataByIds(this.ctx.helper._.map(updateDatas, 'id'));
  427. }
  428. if (data.bills.dgn) {
  429. ctx.helper.checkDgnQtyPrecision(data.bills.dgn);
  430. responseData.data.dgn = await ctx.service.stageBillsDgn.saveDgnData(data.bills.dgn);
  431. }
  432. if (data.bills.stage) {
  433. responseData.data.curStageData = await ctx.service.stageBills.updateStageData(data.bills.stage);
  434. }
  435. if (data.bills.calcType) {
  436. responseData.data = await ctx.service.stageBills.updateStageBillsCalcType(data.bills.calcType);
  437. }
  438. }
  439. await ctx.service.stage.updateCheckCalcFlag(ctx.stage, true);
  440. await ctx.service.stage.updateCacheTime(ctx.stage.id);
  441. ctx.body = responseData;
  442. } catch (err) {
  443. this.log(err);
  444. ctx.body = { err: 1, msg: err.toString(), data: null };
  445. }
  446. }
  447. /**
  448. * 查询可用变更令 (Ajax-Post)
  449. * @param ctx
  450. * @return {Promise<void>}
  451. */
  452. async searchValidChange(ctx) {
  453. try {
  454. const data = JSON.parse(ctx.request.body.data);
  455. if (!data.bills && !data.pos) {
  456. throw '数据错误';
  457. }
  458. const bills = data.bills ? data.bills : await ctx.service.ledger.getDataById(data.pos.lid);
  459. const pos = data.pos;
  460. const changes = ctx.stage.readOnly
  461. ? await ctx.service.change.getAuditValidChanges(ctx.tender.id, bills, null, ctx.stage.curTimes, ctx.stage.curOrder)
  462. : await ctx.service.change.getValidChanges(ctx.tender.id, bills);
  463. const useChanges = ctx.stage.readOnly
  464. ? await ctx.service.stageChange.getAuditorStageData(ctx.tender.id, ctx.stage.id, ctx.stage.curTimes, ctx.stage.curOrder, bills.id, pos ? pos.id : -1)
  465. : await ctx.service.stageChange.getLastestStageData(ctx.tender.id, ctx.stage.id, bills.id, pos ? pos.id : -1);
  466. ctx.body = { err: 0, msg: '', data: { changes, useChanges } };
  467. } catch (err) {
  468. this.log(err);
  469. ctx.body = { err: 1, msg: err.toString(), data: null };
  470. }
  471. }
  472. /**
  473. * 调用变更令 (Ajax-Post)
  474. * @param ctx
  475. * @return {Promise<void>}
  476. */
  477. async useChange(ctx) {
  478. try {
  479. this._checkStageCanModify(ctx);
  480. const data = JSON.parse(ctx.request.body.data);
  481. if (!data.target || (!data.target.bills && !data.target.pos) || !data.change) {
  482. throw '调用变更令数据错误';
  483. }
  484. let result;
  485. if (data.target.pos) {
  486. result = await ctx.service.stageChange.posChange(data.target.pos, data.change);
  487. result.change = { target: { lid: data.target.pos.lid, pid: data.target.pos.id } };
  488. result.change.data = await ctx.service.stageChange.getLastestStageData(ctx.tender.id,
  489. ctx.stage.id, data.target.pos.lid, data.target.pos.id);
  490. } else {
  491. result = await ctx.service.stageChange.billsChange(data.target.bills, data.change);
  492. result.change = { target: { lid: data.target.bills.id, pid: '-1' } };
  493. result.change.data = await ctx.service.stageChange.getLastestStageData(ctx.tender.id,
  494. ctx.stage.id, data.target.bills.id, '-1');
  495. }
  496. await ctx.service.stage.updateCheckCalcFlag(ctx.stage, true);
  497. await ctx.service.stage.updateCacheTime(ctx.stage.id);
  498. ctx.body = { err: 0, msg: '', data: result };
  499. } catch (err) {
  500. this.log(err);
  501. ctx.body = { err: 1, msg: err.toString(), data: null };
  502. }
  503. }
  504. /**
  505. * 查询变更令 明细数据(包括附件、变更清单、累计使用情况、本期使用情况) (Ajax-Post)
  506. * @param ctx
  507. * @return {Promise<void>}
  508. */
  509. async changeDetail(ctx) {
  510. try {
  511. const data = JSON.parse(ctx.request.body.data);
  512. if (!data.cid) {
  513. throw '查询数据错误';
  514. }
  515. const detailData = await this._getChangeDetailData(ctx.tender.id, ctx.stage.id, data.cid);
  516. ctx.body = { err: 0, msg: '', data: detailData };
  517. } catch (err) {
  518. this.log(err);
  519. ctx.body = { err: 1, msg: err.toString(), data: null };
  520. }
  521. }
  522. /**
  523. * 中间计量 (Get)
  524. * @param ctx
  525. * @return {Promise<void>}
  526. */
  527. async detail(ctx) {
  528. try {
  529. await this._getStageAuditViewData(ctx);
  530. const renderData = await this._getDefaultRenderData(ctx);
  531. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.detail);
  532. renderData.imType = tenderConst.imType;
  533. await this.layout('stage/detail.ejs', renderData, 'stage/detail_modal.ejs');
  534. } catch (err) {
  535. this.log(err);
  536. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage/' + ctx.params.order);
  537. }
  538. }
  539. /**
  540. * 设置中间计量生成规则,并生成中间计量数据 (Ajax)
  541. * @param ctx
  542. * @return {Promise<void>}
  543. */
  544. async buildDetailData(ctx) {
  545. try {
  546. this._checkStageCanModify(ctx);
  547. const data = JSON.parse(ctx.request.body.data);
  548. await ctx.service.stage.buildDetailData(ctx.tender.id, ctx.stage.order, data);
  549. await ctx.service.stage.updateCacheTime(ctx.stage.id);
  550. ctx.body = { err: 0, msg: '', data: null };
  551. } catch (err) {
  552. this.log(err);
  553. ctx.body = { err: 1, msg: err.toString(), data: null };
  554. }
  555. }
  556. /**
  557. * 加载数据 (Ajax)
  558. * @param ctx
  559. * @return {Promise<void>}
  560. */
  561. async loadDetailRelaData(ctx) {
  562. try {
  563. const data = JSON.parse(ctx.request.body.data);
  564. // 加载台账数据
  565. if (data.loadType === 'ledger') {
  566. const ledgerData = await ctx.service.ledger.getData(ctx.tender.id);
  567. ctx.body = { err: 0, msg: '', data: ledgerData };
  568. } else if (data.loadType === 'all') {
  569. const result = {};
  570. result.ledger = await ctx.service.ledger.getData(ctx.tender.id);
  571. result.pos = await ctx.service.pos.getPosData({ tid: ctx.tender.id });
  572. if (ctx.stage.readOnly) {
  573. const curStage = await ctx.service.stageBills.getAuditorStageData(ctx.tender.id, ctx.stage.id, ctx.stage.curTimes, ctx.stage.curOrder);
  574. this.ctx.helper.assignRelaData(result.ledger, [
  575. { data: curStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: '', relaId: 'lid' },
  576. ]);
  577. const curPosStage = await ctx.service.stagePos.getAuditorStageData2(ctx.tender.id, ctx.stage.id, ctx.stage.curTimes, ctx.stage.curOrder);
  578. this.ctx.helper.assignRelaData(result.pos, [
  579. { data: curPosStage, fields: ['contract_qty', 'qc_qty'], prefix: '', relaId: 'pid' },
  580. ]);
  581. } else {
  582. const curStage = await ctx.service.stageBills.getLastestStageData(ctx.tender.id, ctx.stage.id);
  583. this.ctx.helper.assignRelaData(result.ledger, [
  584. { data: curStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: '', relaId: 'lid' },
  585. ]);
  586. const curPosStage = await ctx.service.stagePos.getLastestStageData2(ctx.tender.id, ctx.stage.id);
  587. this.ctx.helper.assignRelaData(result.pos, [
  588. { data: curPosStage, fields: ['contract_qty', 'qc_qty'], prefix: '', relaId: 'pid' },
  589. ]);
  590. }
  591. result.stageDetail = await this._getStageDetailData(ctx);
  592. result.changeData = await this._getStageChangeData(ctx);
  593. ctx.body = { err: 0, msg: '', data: result };
  594. }
  595. } catch (err) {
  596. this.log(err);
  597. ctx.body = { err: 1, msg: err.toString(), data: null };
  598. }
  599. }
  600. /**
  601. * 中间计量,生成规则,高级设置 (Ajax)
  602. * @param ctx
  603. * @return {Promise<void>}
  604. */
  605. async setAdvancedConfig(ctx) {
  606. try {
  607. this._checkStageCanModify(ctx);
  608. const data = JSON.parse(ctx.request.body.data);
  609. await ctx.service.stage.update(data, { id: ctx.stage.id });
  610. await ctx.service.stage.updateCacheTime(ctx.stage.id);
  611. ctx.body = { err: 0, msg: '', data: this.ctx.stage };
  612. } catch (err) {
  613. this.log(err);
  614. ctx.body = { err: 1, msg: err.toString(), data: null };
  615. }
  616. }
  617. /**
  618. * 中间计量,编辑中间计量数据(Ajax)
  619. * @param ctx
  620. * @return {Promise<void>}
  621. */
  622. async saveDetailData(ctx) {
  623. try {
  624. this._checkStageCanModify(ctx);
  625. const data = JSON.parse(ctx.request.body.data);
  626. const responseData = { err: 0, msg: '', data: {} };
  627. if (data instanceof Array) {
  628. responseData.data = await ctx.service.stageDetail.saveDetailDatas(data);
  629. } else {
  630. responseData.data = await ctx.service.stageDetail.saveDetailData(data);
  631. }
  632. await ctx.service.stage.updateCacheTime(ctx.stage.id);
  633. ctx.body = responseData;
  634. } catch (err) {
  635. this.log(err);
  636. ctx.body = { err: 1, msg: err.toString(), data: null };
  637. }
  638. }
  639. /**
  640. * 中间计量,添加草图,上传图片 (Ajax)
  641. * @param ctx
  642. * @return {Promise<void>}
  643. */
  644. async addCalcImage(ctx) {
  645. try {
  646. this._checkStageCanModify(ctx);
  647. const stream = await ctx.getFileStream();
  648. const create_time = Date.parse(new Date()) / 1000;
  649. const fileInfo = path.parse(stream.filename);
  650. const fileName = path.join('public/upload', this.ctx.tender.id.toString(), 'im', 'calcImg_' + create_time + fileInfo.ext);
  651. await ctx.helper.saveStreamFile(stream, path.join(this.app.baseDir, 'app', fileName));
  652. ctx.body = { err: 0, msg: '', data: fileName };
  653. } catch (err) {
  654. this.log(err);
  655. ctx.body = { err: 1, msg: err.toString(), data: null };
  656. }
  657. }
  658. /**
  659. * 中间计量,设置草图 (Ajax)
  660. * @param ctx
  661. * @return {Promise<void>}
  662. */
  663. async mergeCalcImage(ctx) {
  664. try {
  665. this._checkStageCanModify(ctx);
  666. const data = JSON.parse(ctx.request.body.data);
  667. if (data.updateType === 'update') {
  668. if (data.img) {
  669. const create_time = Date.parse(new Date()) / 1000;
  670. const fileName = path.join('public/upload', this.ctx.tender.id.toString(), 'im', 'calcImg_' + create_time + '.png');
  671. const base64Data = data.img.replace(/^data:image\/\w+;base64,/, '');
  672. const dataBuffer = new Buffer.from(base64Data, 'base64');
  673. await this.ctx.helper.saveBufferFile(dataBuffer, path.join(this.app.baseDir, 'app', fileName));
  674. data.calc_img = fileName;
  675. data.calc_img_org = JSON.stringify(data.imgInfo);
  676. delete data.img;
  677. }
  678. delete data.updateType;
  679. delete data.imgInfo;
  680. } else if (data.updateType === 'clear') {
  681. data.calc_img = null;
  682. data.calc_img_org = null;
  683. data.calc_img_remark = null;
  684. delete data.updateType;
  685. }
  686. await this.ctx.service.stageDetail.saveDetailData(data);
  687. const imData = await ctx.service.stageDetail.getLastestImStageData(this.ctx.tender.id, this.ctx.stage.id, data.lid, data.uuid);
  688. await ctx.service.stage.updateCacheTime(ctx.stage.id);
  689. const responseData = { err: 0, msg: '', data: imData };
  690. ctx.body = responseData;
  691. } catch (err) {
  692. this.log(err);
  693. ctx.body = { err: 1, msg: err.toString(), data: null };
  694. }
  695. }
  696. async _updateStageCache(ctx, payCalculator) {
  697. await ctx.service.stage.update({
  698. check_calc: false,
  699. contract_tp: payCalculator.cur.contract_tp, qc_tp: payCalculator.cur.qc_tp,
  700. yf_tp: payCalculator.yf.tp,
  701. sf_tp: payCalculator.sf.tp,
  702. }, { id: ctx.stage.id });
  703. }
  704. /**
  705. * 合同支付 (Get)
  706. * @param ctx
  707. * @return {Promise<void>}
  708. */
  709. async pay(ctx) {
  710. try {
  711. await this._getStageAuditViewData(ctx);
  712. const renderData = await this._getDefaultRenderData(ctx);
  713. const dealPay = await ctx.service.stagePay.getStagePays(ctx.stage);
  714. // 附件不取下载地址
  715. for (const index in dealPay) {
  716. if (dealPay[index].attachment !== null) {
  717. const attachments = JSON.parse(dealPay[index].attachment);
  718. for (const att_index in attachments) {
  719. delete attachments[att_index].filepath;
  720. attachments[att_index].username = (await ctx.service.projectAccount.getAccountInfoById(attachments[att_index].uid)).name;
  721. }
  722. dealPay[index].attachment = attachments;
  723. }
  724. }
  725. renderData.dealPay = dealPay;
  726. renderData.calcBase = await ctx.service.stage.getStagePayCalcBase(ctx.stage, ctx.tender.info);
  727. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.pay);
  728. renderData.whiteList = this.ctx.app.config.multipart.whitelist;
  729. if (ctx.stage.order > 1) {
  730. renderData.pre = await ctx.service.stageBillsFinal.getSumTotalPrice(ctx.stage.tid, ctx.stage.order - 1);
  731. renderData.pre.gather_tp = ctx.helper.add(renderData.pre.contract_tp, renderData.pre.qc_tp);
  732. } else {
  733. renderData.pre = { contract_tp: null, qc_tp: null, gather_tp: null };
  734. }
  735. // 用户有无权限上传和删除附件
  736. renderData.uploadPermission = (!(ctx.stage.readOnly || ctx.stage.revising) && ((ctx.stage.status === auditConst.status.uncheck || ctx.stage.status === auditConst.status.checkNo) && ctx.session.sessionUser.accountId === ctx.stage.user_id) ||
  737. (ctx.stage.status === auditConst.status.checkNoPre && ctx.session.sessionUser.accountId === ctx.stage.curAuditor.aid) ||
  738. (ctx.stage.status === auditConst.status.checking && ctx.stage.curAuditor && ctx.stage.curAuditor.aid === ctx.session.sessionUser.accountId)) ||
  739. (ctx.tender.isTourist && ctx.tender.touristPermission.file);
  740. if (!ctx.stage.readOnly || ctx.tender.isTourist) {
  741. // 计算 本期金额
  742. const payCalculator = new PayCalculator(ctx, ctx.stage, ctx.tender.info);
  743. await payCalculator.calculateAll(renderData.dealPay);
  744. await this._updateStageCache(ctx, payCalculator);
  745. // renderData.calcBase = payCalculator.bases;
  746. }
  747. await this.layout('stage/pay.ejs', renderData, 'stage/pay_modal.ejs');
  748. } catch (err) {
  749. this.log(err);
  750. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage');
  751. }
  752. }
  753. /**
  754. * 合同支付 - 编辑合同支付项 (Ajax)
  755. * @param ctx
  756. * @return {Promise<void>}
  757. */
  758. async savePayData(ctx) {
  759. function checkCalcField(data) {
  760. return data.sexpr !== undefined || data.sprice !== undefined
  761. || data.rexpr !== undefined || data.rprice !== undefined
  762. || data.minus !== undefined || data.is_yf !== undefined || data.dl_type !== undefined;
  763. }
  764. try {
  765. this._checkStageCanModify(ctx);
  766. const data = JSON.parse(ctx.request.body.data);
  767. const responseData = { err: 0, msg: '', data: {} };
  768. const payCalculator = new PayCalculator(ctx, ctx.stage, ctx.tender.info);
  769. switch (data.type) {
  770. case 'add':
  771. responseData.data = await ctx.service.pay.add();
  772. responseData.data = await ctx.service.stagePay.getStagePay(ctx.stage, responseData.data.pid);
  773. break;
  774. case 'del':
  775. await ctx.service.pay.del(data.id);
  776. responseData.data = await ctx.service.stagePay.getStagePays(ctx.stage);
  777. await payCalculator.calculateAll(responseData.data);
  778. await this._updateStageCache(ctx, payCalculator);
  779. break;
  780. case 'changeOrder':
  781. responseData.data = await ctx.service.pay.changeOrder(data.id1, data.id2);
  782. break;
  783. case 'info':
  784. responseData.data = await ctx.service.pay.save(data.updateData);
  785. const bReCalc = data.updateData instanceof Array ? checkCalcField(data.updateData[0]) : checkCalcField(data.updateData);
  786. if (bReCalc) {
  787. responseData.data = await ctx.service.stagePay.getStagePays(ctx.stage);
  788. await payCalculator.calculateAll(responseData.data);
  789. await this._updateStageCache(ctx, payCalculator);
  790. } else {
  791. if (data.updateData instanceof Array) {
  792. responseData.data = await ctx.service.stagePay.getStagePay(ctx.stage, this.app._.map(responseData.data, 'id'));
  793. } else {
  794. responseData.data = await ctx.service.stagePay.getStagePay(ctx.stage, responseData.data.id);
  795. }
  796. }
  797. break;
  798. case 'stage':
  799. await ctx.service.stagePay.save(data.updateData);
  800. responseData.data = await ctx.service.stagePay.getStagePays(ctx.stage);
  801. await payCalculator.calculateAll(responseData.data);
  802. await this._updateStageCache(ctx, payCalculator);
  803. break;
  804. }
  805. ctx.body = responseData;
  806. } catch (err) {
  807. this.log(err);
  808. ctx.body = { err: 1, msg: err.toString(), data: null };
  809. }
  810. }
  811. /**
  812. * 合同支付 - 章节明细 (Ajax-Post)
  813. * @param ctx
  814. * @return {Promise<void>}
  815. */
  816. async chapterDetail(ctx) {
  817. const _ = this.app._;
  818. const fields = ['contract_tp', 'qc_tp', 'gather_tp', 'end_gather_tp'];
  819. function assignStageData(chapter, curStage, preStage) {
  820. chapter.contract_tp = curStage.contract_tp;
  821. chapter.qc_tp = curStage.qc_tp;
  822. chapter.gather_tp = ctx.helper.add(curStage.contract_tp, curStage.qc_tp);
  823. if (preStage) {
  824. chapter.pre_contract_tp = preStage.contract_tp;
  825. chapter.pre_qc_tp = preStage.qc_tp;
  826. chapter.pre_gather_tp = ctx.helper.add(preStage.contract_tp, preStage.qc_tp);
  827. chapter.end_contract_tp = ctx.helper.add(curStage.contract_tp, preStage.contract_tp);
  828. chapter.end_qc_tp = ctx.helper.add(curStage.qc_tp, preStage.qc_tp);
  829. chapter.end_gather_tp = ctx.helper.add(chapter.gather_tp, chapter.pre_gather_tp);
  830. } else {
  831. chapter.end_contract_tp = curStage.contract_tp;
  832. chapter.end_qc_tp = curStage.qc_tp;
  833. chapter.end_gather_tp = chapter.gather_tp;
  834. }
  835. }
  836. try {
  837. const chapterDetail = JSON.parse(JSON.stringify(payConst.chapterDetail));
  838. const calcDetail = _.sortBy(chapterDetail, ['cType']);
  839. for (const cd of calcDetail) {
  840. switch (cd.cType) {
  841. case 1:
  842. const tp = await ctx.service.stageBills.getSumTotalPriceGcl(ctx.stage, cd.filter);
  843. assignStageData(cd, tp);
  844. break;
  845. case 11:
  846. assignStageData(cd, await ctx.service.stageBills.getSumTotalPriceGcl(ctx.stage));
  847. break;
  848. case 21:
  849. const sum = _.find(calcDetail, { cType: 11 });
  850. const chapters = _.filter(calcDetail, { cType: 1 });
  851. for (const f of fields) {
  852. cd[f] = ctx.helper.sub(sum[f], this.ctx.helper.sum(_.map(chapters, f)));// _.sumBy(chapters, f));
  853. }
  854. break;
  855. case 31:
  856. assignStageData(cd, await ctx.service.stageBills.getSumTotalPriceNotGcl(ctx.stage));
  857. break;
  858. case 41:
  859. const sum1 = _.find(calcDetail, { cType: 11 });
  860. const sum2 = _.find(calcDetail, { cType: 31 });
  861. for (const f of fields) {
  862. cd[f] = ctx.helper.add(sum1.value, sum2.value);
  863. }
  864. break;
  865. }
  866. }
  867. ctx.body = { err: 0, msg: '', data: { detail: chapterDetail, decimal: ctx.tender.info.decimal } };
  868. } catch (err) {
  869. this.log(err);
  870. ctx.body = { err: 1, msg: err.toString(), data: null };
  871. }
  872. }
  873. // 变更令相关
  874. /**
  875. * 查询变更令 明细数据(包括附件、变更清单、累计使用情况、本期使用情况)
  876. * @param tid
  877. * @param sid
  878. * @param cid
  879. * @return {Promise<{}>}
  880. * @private
  881. */
  882. async _getChangeDetailData(tid, sid, cid) {
  883. const data = {};
  884. data.attachments = await this.ctx.service.changeAtt.getChangeAttachment(cid);
  885. data.bills = await this.ctx.service.changeAuditList.getAllDataByCondition({ where: { cid } });
  886. data.addUsedBills = await this.ctx.service.stageChange.getUsedData(tid, cid);
  887. data.curUsedBills = await this.ctx.service.stageChange.getStageUsedData(sid, cid);
  888. return data;
  889. }
  890. /**
  891. * 获取变更数据 Post(Ajax)
  892. * @param ctx
  893. * @return {Promise<void>}
  894. */
  895. async getChangeData(ctx) {
  896. try {
  897. const data = {};
  898. data.tenderInfo = ctx.tender.info;
  899. data.ledger = await ctx.service.ledger.getData(ctx.tender.id);
  900. data.usedChangesId = await ctx.service.stageChange.getStageUsedChangeId(ctx.stage.id);
  901. data.changes = await ctx.service.change.getChangeAndUsedInfo(ctx.tender.id);
  902. if (data.changes.length > 0) {
  903. const change = data.changes[0];
  904. change.detail = await this._getChangeDetailData(ctx.tender.id, ctx.stage.id, change.cid);
  905. }
  906. ctx.body = { err: 0, msg: '', data };
  907. } catch (err) {
  908. this.log(err);
  909. ctx.body = { err: 1, msg: err.toString(), data: null };
  910. }
  911. }
  912. /**
  913. * 变更令 (Get)
  914. * @param ctx
  915. * @return {Promise<void>}
  916. */
  917. async change(ctx) {
  918. try {
  919. await this._getStageAuditViewData(ctx);
  920. const renderData = await this._getDefaultRenderData(ctx);
  921. renderData.changeConst = changeConst;
  922. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.change);
  923. await this.layout('stage/change.ejs', renderData, 'stage/audit_modal.ejs');
  924. } catch (err) {
  925. this.log(err);
  926. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage');
  927. }
  928. }
  929. // 审批相关
  930. /**
  931. * 添加审批人
  932. * @param ctx
  933. * @return {Promise<void>}
  934. */
  935. async addAudit(ctx) {
  936. try {
  937. this._checkStageCanModify(ctx);
  938. const data = JSON.parse(ctx.request.body.data);
  939. const id = this.app._.toInteger(data.auditorId);
  940. if (isNaN(id) || id <= 0) {
  941. throw '参数错误';
  942. }
  943. // 检查权限等
  944. if (ctx.stage.user_id !== ctx.session.sessionUser.accountId) {
  945. throw '您无权添加审核人';
  946. }
  947. if (ctx.stage.status === auditConst.status.checking || ctx.stage.status === auditConst.status.checked) {
  948. throw '当前不允许添加审核人';
  949. }
  950. ctx.stage.auditorList = await ctx.service.stageAudit.getAuditors(ctx.stage.id, ctx.stage.times);
  951. // 检查审核人是否已存在
  952. const exist = this.app._.find(ctx.stage.auditorList, { aid: id });
  953. if (exist) {
  954. throw '该审核人已存在,请勿重复添加';
  955. }
  956. const shenpiInfo = await ctx.service.shenpiAudit.getDataByCondition({ tid: ctx.tender.id, sp_type: shenpiConst.sp_type.stage, sp_status: shenpiConst.sp_status.gdzs });
  957. const is_gdzs = shenpiInfo && ctx.tender.info.shenpi.stage === shenpiConst.sp_status.gdzs ? 1 : 0;
  958. const result = await ctx.service.stageAudit.addAuditor(ctx.stage.id, id, ctx.stage.times, is_gdzs);
  959. if (!result) {
  960. throw '添加审核人失败';
  961. }
  962. const auditors = await ctx.service.stageAudit.getAuditGroupByListWithOwner(ctx.stage.id, ctx.stage.times);
  963. ctx.body = { err: 0, msg: '', data: auditors };
  964. } catch (err) {
  965. this.log(err);
  966. ctx.body = { err: 1, msg: err.toString(), data: null };
  967. }
  968. }
  969. /**
  970. * 移除审批人
  971. * @param ctx
  972. * @return {Promise<void>}
  973. */
  974. async deleteAudit(ctx) {
  975. try {
  976. this._checkStageCanModify(ctx);
  977. const data = JSON.parse(ctx.request.body.data);
  978. const id = data.auditorId instanceof Number ? data.auditorId : this.app._.toNumber(data.auditorId);
  979. if (isNaN(id) || id <= 0) {
  980. throw '参数错误';
  981. }
  982. const result = await ctx.service.stageAudit.deleteAuditor(ctx.stage.id, id, ctx.stage.times);
  983. if (!result) {
  984. throw '移除审核人失败';
  985. }
  986. const auditors = await ctx.service.stageAudit.getAuditors(ctx.stage.id, ctx.stage.times);
  987. ctx.body = { err: 0, msg: '', data: auditors };
  988. } catch (err) {
  989. ctx.body = { err: 1, msg: err.toString(), data: null };
  990. }
  991. }
  992. /**
  993. * 上报
  994. * @param ctx
  995. * @return {Promise<void>}
  996. */
  997. async startAudit(ctx) {
  998. try {
  999. this._checkStageCanModify(ctx);
  1000. if (ctx.stage.user_id !== ctx.session.sessionUser.accountId) {
  1001. throw '您无权上报该期数据';
  1002. }
  1003. if (ctx.stage.status === auditConst.status.checking || ctx.stage.status === auditConst.status.checked) {
  1004. throw '该期数据当前无法上报';
  1005. }
  1006. await ctx.service.stageAudit.start(ctx.stage.id, ctx.stage.times);
  1007. ctx.body = { err: 0, msg: '', data: [] };
  1008. } catch (err) {
  1009. this.log(err);
  1010. ctx.session.postError = err.toString();
  1011. // ctx.redirect(ctx.request.header.referer);
  1012. ctx.body = this.ajaxErrorBody(err, '上报失败');
  1013. }
  1014. }
  1015. /**
  1016. * 审批
  1017. * @param ctx
  1018. * @return {Promise<void>}
  1019. */
  1020. async checkAudit(ctx) {
  1021. try {
  1022. this._checkStageCanModify(ctx);
  1023. if (!this.ctx.stage || (this.ctx.stage.status !== auditConst.status.checking && this.ctx.stage.status !== auditConst.status.checkNoPre)) {
  1024. throw '当前期数据有误';
  1025. }
  1026. if (!this.ctx.stage.curAuditor || this.ctx.stage.curAuditor.aid !== ctx.session.sessionUser.accountId) {
  1027. throw '您无权进行该操作';
  1028. }
  1029. const data = JSON.parse(ctx.request.body.data);
  1030. data.checkType = parseInt(data.checkType);
  1031. // const data = {
  1032. // checkType: parseInt(ctx.request.body.checkType),
  1033. // opinion: ctx.request.body.opinion,
  1034. // };
  1035. if (!data.checkType || isNaN(data.checkType)) {
  1036. throw '提交数据错误';
  1037. }
  1038. if (data.checkType === auditConst.status.checkNo) {
  1039. if (!data.checkType || isNaN(data.checkType)) {
  1040. throw '提交数据错误';
  1041. }
  1042. }
  1043. await ctx.service.stageAudit.check(ctx.stage.id, data, ctx.stage.times);
  1044. ctx.body = { err: 0, msg: '', data: [] };
  1045. } catch (err) {
  1046. this.log(err);
  1047. ctx.body = this.ajaxErrorBody(err, '提交失败');
  1048. ctx.session.postError = err.toString();
  1049. }
  1050. }
  1051. /**
  1052. * 重新审批
  1053. * @param ctx
  1054. * @return {Promise<void>}
  1055. */
  1056. async checkAuditAgain(ctx) {
  1057. try {
  1058. if (ctx.stage.revising) {
  1059. throw '台账修订中,请勿修改提交期数据';
  1060. }
  1061. if (ctx.query.confirm !== undefined && ctx.query.confirm !== '确认设置终审审批') {
  1062. throw '请输入正确的文本信息';
  1063. }
  1064. if (ctx.session.sessionUser.loginStatus === 0) {
  1065. const code = ctx.query.code;
  1066. const pa = await ctx.service.projectAccount.getDataById(ctx.session.sessionUser.accountId);
  1067. if (!pa.auth_mobile) {
  1068. throw '未绑定手机号';
  1069. }
  1070. const cacheKey = 'smsCode:' + ctx.session.sessionUser.accountId;
  1071. const cacheCode = await app.redis.get(cacheKey);
  1072. // console.log(cacheCode);
  1073. if (cacheCode === null || code === undefined || cacheCode !== (code + pa.auth_mobile)) {
  1074. throw '验证码不正确!';
  1075. }
  1076. }
  1077. if ((ctx.stage.auditors[ctx.stage.auditors.length - 1].aid === ctx.session.sessionUser.accountId || (ctx.query.confirm === '确认设置终审审批' && ctx.session.sessionUser.is_admin)) && ctx.stage.status === auditConst.status.checked && ctx.stage.order === ctx.stage.highOrder) {
  1078. await ctx.service.stageAudit.checkAgain(ctx.stage.id, ctx.stage.times);
  1079. // ctx.redirect(ctx.request.header.referer);
  1080. ctx.body = {
  1081. err: 0,
  1082. url: ctx.request.header.referer,
  1083. msg: '',
  1084. };
  1085. } else {
  1086. throw '您无权进行该操作';
  1087. }
  1088. } catch (err) {
  1089. this.log(err);
  1090. // ctx.session.postError = err.toString();
  1091. // ctx.redirect(ctx.request.header.referer);
  1092. ctx.body = {
  1093. err: 1,
  1094. // url: ctx.request.header.referer,
  1095. msg: err,
  1096. };
  1097. }
  1098. }
  1099. // 清单汇总相关
  1100. _getGatherSpreadSetting() {
  1101. const _ = this.app._;
  1102. function removeFieldCols(setting, cols) {
  1103. _.remove(setting.cols, function(c) {
  1104. return cols.indexOf(c.field) > -1;
  1105. });
  1106. }
  1107. function setColFormat(cols, field, formatter) {
  1108. const filterCols = cols.filter(function(c) {
  1109. return c.field.search(field) !== -1;
  1110. });
  1111. for (const col of filterCols) {
  1112. col.formatter = formatter;
  1113. }
  1114. }
  1115. // const tpFormatter = this.ctx.helper.getNumberFormatter(this.ctx.tender.info.decimal.tp);
  1116. // const upFormatter = this.ctx.helper.getNumberFormatter(2);
  1117. const gcl = JSON.parse(JSON.stringify(spreadConst.stageGather.gcl));
  1118. // setColFormat(gcl.cols, 'unit_price', upFormatter);
  1119. // setColFormat(gcl.cols, 'total_price', tpFormatter);
  1120. // setColFormat(gcl.cols, 'tp', tpFormatter);
  1121. const leafXmj = JSON.parse(JSON.stringify(spreadConst.stageGather.leafXmj));
  1122. const tender = this.ctx.tender;
  1123. if (tender.data.measure_type === measureType.tz.value) {
  1124. removeFieldCols(gcl, spreadConst.filterCols.tzWithoutCols);
  1125. }
  1126. return [gcl, leafXmj];
  1127. }
  1128. /**
  1129. * 清单汇总 页面 (Get)
  1130. * @param ctx
  1131. * @return {Promise<void>}
  1132. */
  1133. async gather(ctx) {
  1134. try {
  1135. await this._getStageAuditViewData(ctx);
  1136. const renderData = await this._getDefaultRenderData(ctx);
  1137. [renderData.gclSpread, renderData.leafXmjSpread] = this._getGatherSpreadSetting();
  1138. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.gather);
  1139. await this.layout('stage/gather.ejs', renderData, 'stage/gather_modal.ejs');
  1140. } catch (err) {
  1141. this.log(err);
  1142. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage/' + ctx.params.order);
  1143. }
  1144. }
  1145. /**
  1146. * 审核比较 页面 (Get)
  1147. * @param ctx
  1148. * @return {Promise<void>}
  1149. */
  1150. async compare(ctx) {
  1151. try {
  1152. await this._getStageAuditViewData(ctx);
  1153. const renderData = await this._getDefaultRenderData(ctx);
  1154. if (ctx.stage.status === auditConst.status.checkNo && !ctx.stage.readOnly) {
  1155. renderData.compareAuditors = ctx.stage.auditHistory[ctx.stage.curTimes - 2];
  1156. } else if (ctx.stage.times !== ctx.stage.curTimes) {
  1157. renderData.compareAuditors = ctx.stage.auditHistory[ctx.stage.curTimes - 1];
  1158. } else {
  1159. renderData.compareAuditors = ctx.stage.auditors;
  1160. }
  1161. renderData.ledgerSpread = JSON.parse(JSON.stringify(spreadConst.stageCompare.ledger));
  1162. renderData.posSpread = JSON.parse(JSON.stringify(spreadConst.stageCompare.pos));
  1163. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.compare);
  1164. await this.layout('stage/compare.ejs', renderData, 'stage/compare_modal.ejs');
  1165. } catch (err) {
  1166. this.log(err);
  1167. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage/' + ctx.params.order);
  1168. }
  1169. }
  1170. async compareAuditor(ctx) {
  1171. try {
  1172. const data = JSON.parse(ctx.request.body.data);
  1173. const result = {
  1174. main: null,
  1175. roles: [],
  1176. };
  1177. if (data.main) {
  1178. result.main = {};
  1179. result.main.ledger = await ctx.service.ledger.getData(ctx.tender.id);
  1180. result.main.pos = await ctx.service.pos.getPosData({ tid: ctx.tender.id });
  1181. }
  1182. for (const order of data.roles) {
  1183. const data = { order, bills: [], pos: [] };
  1184. const compareTimes = ctx.stage.status === auditConst.status.checkNo && !ctx.stage.readOnly
  1185. ? ctx.stage.curTimes - 1 : ctx.stage.curTimes;
  1186. data.bills = await ctx.service.stageBills.getAuditorStageData(ctx.tender.id, ctx.stage.id, compareTimes, order);
  1187. data.pos = await ctx.service.stagePos.getAuditorStageData(ctx.tender.id, ctx.stage.id, compareTimes, order);
  1188. result.roles.push(data);
  1189. }
  1190. ctx.body = { err: 0, msg: '', data: result };
  1191. } catch (err) {
  1192. this.log(err);
  1193. ctx.body = { err: 1, msg: err.toString(), data: null };
  1194. }
  1195. }
  1196. async bwtz(ctx) {
  1197. try {
  1198. await this._getStageAuditViewData(ctx);
  1199. const renderData = await this._getDefaultRenderData(ctx);
  1200. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.bwtz);
  1201. const sjsRela = await this.ctx.service.project.getSjsRela(ctx.session.sessionProject.id);
  1202. renderData.ex_memo1 = sjsRela.ledgerCol.find(x => { return x.field === 'ex_memo1'; });
  1203. renderData.ex_memo2 = sjsRela.ledgerCol.find(x => { return x.field === 'ex_memo2'; });
  1204. renderData.ex_memo3 = sjsRela.ledgerCol.find(x => { return x.field === 'ex_memo3'; });
  1205. await this.layout('stage/bwtz.ejs', renderData, 'stage/audit_modal.ejs');
  1206. } catch (err) {
  1207. this.log(err);
  1208. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage/' + ctx.params.order);
  1209. }
  1210. }
  1211. async loadBwtz(ctx) {
  1212. try {
  1213. const data = ctx.request.body.data ? JSON.parse(ctx.request.body.data) : {};
  1214. const ledgerData = await this._getStageLedgerData(ctx);
  1215. const posData = await this._getStagePosData(ctx);
  1216. const changeData = await this._getStageChangeData(ctx);
  1217. const convert = new billsPosConvert(ctx);
  1218. convert.loadData(ledgerData, posData, changeData);
  1219. const result = convert.convert(data.filter);
  1220. // const wbsCodeHis = await ctx.service.externalData.getExValue(ctx.tender.id, -1,
  1221. // externalDataConst.FuLong.exType, externalDataConst.FuLong.exFields.wbsCode) || [];
  1222. // const [result, needUpdate] = convert.convertByWbsCode(wbsCodeHis);
  1223. // if (needUpdate) {
  1224. // await ctx.service.externalData.saveExValue(ctx.tender.id, -1,
  1225. // externalDataConst.FuLong.exType, externalDataConst.FuLong.exFields.wbsCode, wbsCodeHis);
  1226. // }
  1227. ctx.body = { err: 0, msg: '', data: result };
  1228. } catch (err) {
  1229. this.log(err);
  1230. ctx.body = this.ajaxErrorBody(err, '加载合同支付数据错误');
  1231. }
  1232. }
  1233. /**
  1234. * 检查当前期当前用户是否在审核列表中,如果是的话允许再次上传附件
  1235. * @param {Object} ctx 上下文
  1236. */
  1237. _checkStageCanModifyRe(ctx) {
  1238. // 检查登录用户,是否可操作
  1239. // if (ctx.stage.readOnly) {
  1240. // if (ctx.stage.status === auditConst.status.checked) {
  1241. // // 当前期状态为完成,且提交人是审核列表中的则可再次上传
  1242. // if (ctx.stage.user_id === ctx.session.sessionUser.accountId || ctx.stage.auditors.findIndex(auditor => auditor.aid === ctx.session.sessionUser.accountId) !== -1) {
  1243. // // 再次上传的图片要给个标识,方便给前端进行编辑操作
  1244. // // ctx.reUploadPermission = true;
  1245. // return;
  1246. // }
  1247. // throw '该计量期当前您无权操作';
  1248. // } else {
  1249. // throw '该计量期当前您无权操作';
  1250. // }
  1251. // }
  1252. if (ctx.stage.revising) {
  1253. throw '台账修订中,请勿修改提交期数据';
  1254. }
  1255. }
  1256. /**
  1257. * 上传附件
  1258. * @param {Object} ctx - egg全局变量
  1259. * @return {void}
  1260. */
  1261. async uploadFile(ctx) {
  1262. const responseData = {
  1263. err: 0,
  1264. msg: '',
  1265. data: [],
  1266. };
  1267. let stream;
  1268. try {
  1269. this._checkStageCanModifyRe(ctx);
  1270. const parts = ctx.multipart({ autoFields: true });
  1271. const files = [];
  1272. let index = 0;
  1273. const extra_upload = ctx.stage.status === auditConst.status.checked;
  1274. while ((stream = await parts()) !== undefined) {
  1275. // 判断用户是否选择上传文件
  1276. if (!stream.filename) {
  1277. throw '请选择上传的文件!';
  1278. }
  1279. // const dirName = 'app/public/upload/stage/' + moment().format('YYYYMMDD');
  1280. // 判断文件夹是否存在,不存在则直接创建文件夹
  1281. // if (!fs.existsSync(path.join(this.app.baseDir, dirName))) {
  1282. // await fs.mkdirSync(path.join(this.app.baseDir, dirName));
  1283. // }
  1284. const fileInfo = path.parse(stream.filename);
  1285. const create_time = Date.parse(new Date()) / 1000;
  1286. const filepath = `app/public/upload/${this.ctx.tender.id}/stage/fujian_${create_time + index.toString() + fileInfo.ext}`;
  1287. await ctx.helper.saveStreamFile(stream, path.resolve(this.app.baseDir, filepath));
  1288. // console.log(await fs.existsSync(path.resolve(this.app.baseDir, 'app', filepath)));
  1289. // const fileInfo = path.parse(stream.filename);
  1290. // const fileName = 'stage' + create_time + '_' + index + fileInfo.ext;
  1291. // 保存文件
  1292. // await ctx.helper.saveStreamFile(stream, path.resolve(this.app.baseDir, dirName, fileName));
  1293. if (stream) {
  1294. await sendToWormhole(stream);
  1295. }
  1296. // 保存数据到att表
  1297. const fileData = {
  1298. tid: ctx.params.id,
  1299. sid: ctx.params.order,
  1300. in_time: create_time,
  1301. filename: fileInfo.name,
  1302. fileext: fileInfo.ext,
  1303. filesize: Array.isArray(parts.field.size) ? parts.field.size[index] : parts.field.size,
  1304. filepath,
  1305. extra_upload,
  1306. };
  1307. // if (ctx.reUploadPermission) {
  1308. // fileData.re_upload = 1;
  1309. // }
  1310. const result = await ctx.service.stageAtt.save(parts.field, fileData, ctx.session.sessionUser.accountId);
  1311. if (!result) {
  1312. throw '导入数据库保存失败';
  1313. }
  1314. const attData = await ctx.service.stageAtt.getDataByFid(result.insertId);
  1315. attData.in_time = moment(create_time * 1000).format('YYYY-MM-DD');
  1316. files.length !== 0 ? files.unshift(attData) : files.push(attData);
  1317. ++index;
  1318. }
  1319. responseData.data = files;
  1320. } catch (err) {
  1321. this.log(err);
  1322. // 失败需要消耗掉stream 以防卡死
  1323. if (stream) {
  1324. await sendToWormhole(stream);
  1325. }
  1326. this.setMessage(err.toString(), this.messageType.ERROR);
  1327. responseData.err = 1;
  1328. responseData.msg = err.toString();
  1329. }
  1330. ctx.body = responseData;
  1331. }
  1332. /**
  1333. * 下载附件
  1334. * @param {Object} ctx - egg全局变量
  1335. * @return {void}
  1336. */
  1337. async downloadFile(ctx) {
  1338. const id = ctx.params.fid;
  1339. if (id) {
  1340. try {
  1341. const fileInfo = await ctx.service.stageAtt.getDataById(id);
  1342. if (fileInfo !== undefined && fileInfo !== '') {
  1343. const fileName = path.join(this.app.baseDir, fileInfo.filepath);
  1344. // 解决中文无法下载问题
  1345. const userAgent = (ctx.request.header['user-agent'] || '').toLowerCase();
  1346. let disposition = '';
  1347. if (userAgent.indexOf('msie') >= 0 || userAgent.indexOf('chrome') >= 0) {
  1348. disposition = 'attachment; filename=' + encodeURIComponent(fileInfo.filename + fileInfo.fileext);
  1349. } else if (userAgent.indexOf('firefox') >= 0) {
  1350. disposition = 'attachment; filename*="utf8\'\'' + encodeURIComponent(fileInfo.filename + fileInfo.fileext) + '"';
  1351. } else {
  1352. /* safari等其他非主流浏览器只能自求多福了 */
  1353. disposition = 'attachment; filename=' + new Buffer(fileInfo.filename + fileInfo.fileext).toString('binary');
  1354. }
  1355. ctx.response.set({
  1356. 'Content-Type': 'application/octet-stream',
  1357. 'Content-Disposition': disposition,
  1358. 'Content-Length': fileInfo.filesize,
  1359. });
  1360. ctx.body = await fs.createReadStream(fileName);
  1361. } else {
  1362. throw '不存在该文件';
  1363. }
  1364. } catch (err) {
  1365. this.log(err);
  1366. this.setMessage(err.toString(), this.messageType.ERROR);
  1367. }
  1368. }
  1369. }
  1370. /**
  1371. * 查看附件
  1372. * @param {Object} ctx - egg全局变量
  1373. * @return {void}
  1374. */
  1375. async checkFile(ctx) {
  1376. const responseData = { err: 0, msg: '' };
  1377. const { id = '' } = JSON.parse(ctx.request.body.data);
  1378. if (id) {
  1379. try {
  1380. const fileInfo = await ctx.service.stageAtt.getDataById(id);
  1381. if (fileInfo && Object.keys(fileInfo).length) {
  1382. let filepath = fileInfo.filepath;
  1383. if (!ctx.helper.canPreview(fileInfo.fileext)) {
  1384. filepath = `/tender/${ctx.tender.id}/measure/stage/${ctx.params.order}/download/file/${fileInfo.id}`;
  1385. } else {
  1386. filepath = filepath.replace(/^app|\/app/, '');
  1387. }
  1388. fileInfo.filepath && (responseData.data = { filepath });
  1389. }
  1390. } catch (error) {
  1391. this.log(error);
  1392. this.setMessage(error.toString(), this.messageType.ERROR);
  1393. responseData.err = 1;
  1394. responseData.msg = error.toString();
  1395. }
  1396. }
  1397. ctx.body = responseData;
  1398. }
  1399. /**
  1400. * 删除附件
  1401. * @param {Object} ctx - egg全局变量
  1402. * @return {void}
  1403. */
  1404. async deleteFile(ctx) {
  1405. const responseData = {
  1406. err: 0,
  1407. msg: '',
  1408. data: '',
  1409. };
  1410. try {
  1411. this._checkStageCanModifyRe(ctx);
  1412. const data = JSON.parse(ctx.request.body.data);
  1413. const fileInfo = await ctx.service.stageAtt.getDataById(data.id);
  1414. if (!fileInfo || !Object.keys(fileInfo).length) {
  1415. throw '该文件不存在';
  1416. }
  1417. if (!fileInfo.extra_upload && ctx.stage.status === auditConst.status.checked) {
  1418. throw '无权限删除';
  1419. }
  1420. if (fileInfo !== undefined && fileInfo !== '') {
  1421. // 先删除文件
  1422. await fs.unlinkSync(path.join(this.app.baseDir, fileInfo.filepath));
  1423. // 再删除数据库
  1424. await ctx.service.stageAtt.deleteById(data.id);
  1425. responseData.data = '';
  1426. } else {
  1427. throw '不存在该文件';
  1428. }
  1429. // if (data.tid === undefined || data.uci === undefined || data.uc === undefined || data.ac === undefined) {
  1430. // throw '参数有误';
  1431. // }
  1432. // const [addCompany, selectCompany] = await ctx.service.changeCompany.setCompanyList(data);
  1433. // responseData.data = { add: addCompany, select: selectCompany };
  1434. } catch (err) {
  1435. responseData.err = 1;
  1436. responseData.msg = err;
  1437. }
  1438. ctx.body = responseData;
  1439. }
  1440. /**
  1441. * 保存附件(或替换)
  1442. * @param {Object} ctx - egg全局变量
  1443. * @return {void}
  1444. */
  1445. async saveFile(ctx) {
  1446. const responseData = {
  1447. err: 0,
  1448. msg: '',
  1449. data: [],
  1450. };
  1451. let stream;
  1452. try {
  1453. this._checkStageCanModifyRe(ctx);
  1454. stream = await ctx.getFileStream({ requireFile: false });
  1455. let fileData = {};
  1456. if (stream.filename !== undefined) {
  1457. const create_time = Date.parse(new Date()) / 1000;
  1458. const fileInfo = path.parse(stream.filename);
  1459. // const dirName = 'app/public/upload/stage/' + moment().format('YYYYMMDD');
  1460. const dirName = `app/public/upload/${this.ctx.tender.id}/stage`;
  1461. const fileName = 'fujian_' + create_time + fileInfo.ext;
  1462. // 保存文件
  1463. await ctx.helper.saveStreamFile(stream, path.join(this.app.baseDir, dirName, fileName));
  1464. // 保存数据到att表
  1465. fileData = {
  1466. filesize: stream.fields.size,
  1467. filepath: path.join(dirName, fileName),
  1468. };
  1469. }
  1470. const result = await ctx.service.stageAtt.updateByID(stream.fields, fileData);
  1471. if (!result) {
  1472. throw '导入数据库保存失败';
  1473. }
  1474. const attData = await ctx.service.stageAtt.getDataByFid(stream.fields.id);
  1475. attData.in_time = moment(attData.in_time * 1000).format('YYYY-MM-DD');
  1476. responseData.data = attData;
  1477. } catch (err) {
  1478. this.log(err);
  1479. // 失败需要消耗掉stream 以防卡死
  1480. if (stream) {
  1481. await sendToWormhole(stream);
  1482. }
  1483. this.setMessage(err.toString(), this.messageType.ERROR);
  1484. responseData.err = 1;
  1485. responseData.msg = err.toString();
  1486. }
  1487. ctx.body = responseData;
  1488. }
  1489. /**
  1490. * 批量下载 - 压缩成zip文件返回
  1491. * @param {Object} ctx - 全局上下文
  1492. */
  1493. async downloadZip(ctx) {
  1494. try {
  1495. const fileIds = JSON.parse(ctx.request.query.fileIds);
  1496. const zipFilename = `${ctx.tender.data.name}-计量台账-${ctx.params.order}-附件.zip`;
  1497. const time = Date.now();
  1498. const zipPath = `app/public/upload/${ctx.tender.id}/stage/fu_jian_zip${time}.zip`;
  1499. const size = await ctx.service.stageAtt.compressedFile(fileIds, zipPath);
  1500. // 解决中文无法下载问题
  1501. const userAgent = (ctx.request.header['user-agent'] || '').toLowerCase();
  1502. let disposition = '';
  1503. if (userAgent.indexOf('msie') >= 0 || userAgent.indexOf('chrome') >= 0) {
  1504. disposition = 'attachment; filename=' + encodeURIComponent(zipFilename);
  1505. } else if (userAgent.indexOf('firefox') >= 0) {
  1506. disposition = 'attachment; filename*="utf8\'\'' + encodeURIComponent(zipFilename) + '"';
  1507. } else {
  1508. /* safari等其他非主流浏览器只能自求多福了 */
  1509. disposition = 'attachment; filename=' + new Buffer(zipFilename).toString('binary');
  1510. }
  1511. ctx.response.set({
  1512. 'Content-Type': 'application/octet-stream',
  1513. 'Content-Disposition': disposition,
  1514. 'Content-Length': size,
  1515. });
  1516. const readStream = fs.createReadStream(path.join(this.app.baseDir, zipPath));
  1517. ctx.body = readStream;
  1518. readStream.on('close', () => {
  1519. if (fs.existsSync(path.resolve(this.app.baseDir, zipPath))) {
  1520. fs.unlinkSync(path.resolve(this.app.baseDir, zipPath));
  1521. }
  1522. });
  1523. } catch (error) {
  1524. this.log(error);
  1525. }
  1526. }
  1527. /**
  1528. * 合同支付上传附件
  1529. * @param {Object} ctx - egg全局变量
  1530. * @return {void}
  1531. */
  1532. async payUploadFile(ctx) {
  1533. const responseData = {
  1534. err: 0,
  1535. msg: '',
  1536. data: [],
  1537. };
  1538. let stream;
  1539. try {
  1540. // this._checkStageCanModify(ctx);
  1541. this._checkStageCanModifyRe(ctx);
  1542. const parts = ctx.multipart({ autoFields: true });
  1543. const files = [];
  1544. let index = 0;
  1545. const create_time = Date.parse(new Date()) / 1000;
  1546. while ((stream = await parts()) !== undefined) {
  1547. // 判断用户是否选择上传文件
  1548. if (!stream.filename) {
  1549. throw '请选择上传的文件!';
  1550. }
  1551. const fileInfo = path.parse(stream.filename);
  1552. const dirName = 'app/public/upload/pay/' + moment().format('YYYYMMDD');
  1553. const fileName = 'pay' + create_time + '_' + index + fileInfo.ext;
  1554. // 判断文件夹是否存在,不存在则直接创建文件夹
  1555. if (!fs.existsSync(path.join(this.app.baseDir, dirName))) {
  1556. await fs.mkdirSync(path.join(this.app.baseDir, dirName));
  1557. }
  1558. // 保存文件
  1559. await ctx.helper.saveStreamFile(stream, path.join(this.app.baseDir, dirName, fileName));
  1560. await sendToWormhole(stream);
  1561. // 插入到stage_pay对应的附件列表中
  1562. const attData = {
  1563. filename: fileInfo.name,
  1564. fileext: fileInfo.ext,
  1565. filesize: Array.isArray(parts.field.size) ? parts.field.size[index] : parts.field.size,
  1566. filepath: path.join(dirName, fileName),
  1567. uid: ctx.session.sessionUser.accountId,
  1568. in_time: moment(create_time * 1000).format('YYYY-MM-DD'),
  1569. };
  1570. const result = await ctx.service.stagePay.saveAtt(parts.field.pay_id, attData);
  1571. if (!result) {
  1572. throw '导入数据库保存失败';
  1573. }
  1574. delete attData.filepath;
  1575. attData.username = ctx.session.sessionUser.name;
  1576. files.length !== 0 ? files.unshift(attData) : files.push(attData);
  1577. ++index;
  1578. }
  1579. responseData.data = files;
  1580. } catch (err) {
  1581. this.log(err);
  1582. // 失败需要消耗掉stream 以防卡死
  1583. if (stream) {
  1584. await sendToWormhole(stream);
  1585. }
  1586. this.setMessage(err.toString(), this.messageType.ERROR);
  1587. responseData.err = 1;
  1588. responseData.msg = err.toString();
  1589. }
  1590. ctx.body = responseData;
  1591. }
  1592. /**
  1593. * 合同支付下载附件
  1594. * @param {Object} ctx - egg全局变量
  1595. * @return {void}
  1596. */
  1597. async payDownloadFile(ctx) {
  1598. const id = ctx.params.pid;
  1599. const index = ctx.params.index;
  1600. if (id && index) {
  1601. try {
  1602. const payInfo = await ctx.service.stagePay.getDataById(id);
  1603. if (payInfo !== undefined && payInfo.attachment !== null) {
  1604. const fileInfo = JSON.parse(payInfo.attachment)[index];
  1605. const fileName = path.join(this.app.baseDir, fileInfo.filepath);
  1606. // 解决中文无法下载问题
  1607. const userAgent = (ctx.request.header['user-agent'] || '').toLowerCase();
  1608. let disposition = '';
  1609. if (userAgent.indexOf('msie') >= 0 || userAgent.indexOf('chrome') >= 0) {
  1610. disposition = 'attachment; filename=' + encodeURIComponent(fileInfo.filename + fileInfo.fileext);
  1611. } else if (userAgent.indexOf('firefox') >= 0) {
  1612. disposition = 'attachment; filename*="utf8\'\'' + encodeURIComponent(fileInfo.filename + fileInfo.fileext) + '"';
  1613. } else {
  1614. /* safari等其他非主流浏览器只能自求多福了 */
  1615. disposition = 'attachment; filename=' + new Buffer(fileInfo.filename + fileInfo.fileext).toString('binary');
  1616. }
  1617. ctx.response.set({
  1618. 'Content-Type': 'application/octet-stream',
  1619. 'Content-Disposition': disposition,
  1620. 'Content-Length': fileInfo.filesize,
  1621. });
  1622. ctx.body = await fs.createReadStream(fileName);
  1623. } else {
  1624. throw '不存在该文件';
  1625. }
  1626. } catch (err) {
  1627. this.log(err);
  1628. this.setMessage(err.toString(), this.messageType.ERROR);
  1629. }
  1630. }
  1631. }
  1632. /**
  1633. * 合同支付删除附件
  1634. * @param {Object} ctx - egg全局变量
  1635. * @return {void}
  1636. */
  1637. async payDeleteFile(ctx) {
  1638. const responseData = {
  1639. err: 0,
  1640. msg: '',
  1641. data: '',
  1642. };
  1643. try {
  1644. // this._checkStageCanModify(ctx);
  1645. this._checkStageCanModifyRe(ctx);
  1646. const data = JSON.parse(ctx.request.body.data);
  1647. const payInfo = await ctx.service.stagePay.getDataById(data.id);
  1648. if (payInfo !== undefined) {
  1649. const fileInfo = JSON.parse(payInfo.attachment)[data.index];
  1650. // 先删除文件
  1651. await fs.unlinkSync(path.join(this.app.baseDir, fileInfo.filepath));
  1652. // 再删除数据库
  1653. const attachment = JSON.parse(payInfo.attachment);
  1654. attachment.splice(data.index, 1);
  1655. const result = await ctx.service.stagePay.deleteAtt(data.id, attachment);
  1656. responseData.data = '';
  1657. } else {
  1658. throw '不存在该文件';
  1659. }
  1660. // if (data.tid === undefined || data.uci === undefined || data.uc === undefined || data.ac === undefined) {
  1661. // throw '参数有误';
  1662. // }
  1663. // const [addCompany, selectCompany] = await ctx.service.changeCompany.setCompanyList(data);
  1664. // responseData.data = { add: addCompany, select: selectCompany };
  1665. } catch (err) {
  1666. responseData.err = 1;
  1667. responseData.msg = err;
  1668. }
  1669. ctx.body = responseData;
  1670. }
  1671. /**
  1672. * 期审批管理
  1673. * @param {Object} ctx - egg全局变量
  1674. * @return {void}
  1675. */
  1676. async manager(ctx) {
  1677. try {
  1678. await this._getStageAuditViewData(ctx);
  1679. const renderData = await this._getDefaultRenderData(ctx);
  1680. // 获取已完成期审批列表
  1681. const lastStage = await ctx.service.stage.getLastestStage(ctx.tender.id, true);
  1682. const auditList = [];
  1683. if (lastStage) {
  1684. renderData.lastStageUser = await ctx.service.projectAccount.getDataById(lastStage.user_id);
  1685. const times = lastStage.status !== auditConst.status.checkNo ? lastStage.times : lastStage.times - 1;
  1686. for (let i = times; i > 0; i--) {
  1687. const timeAuditList = await ctx.service.stageAudit.getAuditors(lastStage.id, i, 'desc');
  1688. auditList.push(timeAuditList);
  1689. }
  1690. }
  1691. renderData.lastStage = lastStage;
  1692. renderData.lastAuditList = auditList;
  1693. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.manager);
  1694. await this.layout('stage/manager.ejs', renderData, 'stage/manager_modal.ejs');
  1695. } catch (err) {
  1696. this.log(err);
  1697. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage');
  1698. }
  1699. }
  1700. /**
  1701. * 删除本次审批 - 期审批管理页面
  1702. * @param ctx
  1703. * @return {Promise<void>}
  1704. */
  1705. async managerAuditDelete(ctx) {
  1706. try {
  1707. if (ctx.stage.revising) {
  1708. throw '台账修订中,请勿修改提交期数据';
  1709. }
  1710. if (ctx.request.body.confirm !== undefined && ctx.request.body.confirm !== '确认删除本次审批') {
  1711. throw '请输入正确的文本信息';
  1712. }
  1713. if (ctx.request.body.confirm === '确认删除本次审批' && ctx.session.sessionUser.is_admin && ctx.stage.order === ctx.stage.highOrder && ctx.stage.times !== 1) {
  1714. await ctx.service.stageAudit.timesDelete();
  1715. ctx.redirect(ctx.request.header.referer);
  1716. } else {
  1717. throw '您无权进行该操作';
  1718. }
  1719. } catch (err) {
  1720. this.log(err);
  1721. ctx.session.postError = err.toString();
  1722. ctx.redirect(ctx.request.header.referer);
  1723. }
  1724. }
  1725. /**
  1726. * 删除本次审批 - 期审批管理页面
  1727. * @param ctx
  1728. * @return {Promise<void>}
  1729. */
  1730. async saveCooperationData(ctx) {
  1731. try {
  1732. const data = JSON.parse(ctx.request.body.data);
  1733. const responseData = { err: 0, msg: '', data: {} };
  1734. switch (data.type) {
  1735. case 'save-confirm':
  1736. await ctx.service.cooperationConfirm.save(data.postData);
  1737. responseData.data.cooperationConfirm = await ctx.service.cooperationConfirm.getValidData(ctx.tender.id, ctx.stage.id, ctx.stage.times, ctx.session.sessionUser.accountId);
  1738. break;
  1739. case 'del-confirm':
  1740. await ctx.service.cooperationConfirm.del(data.postData);
  1741. responseData.data.cooperationConfirm = await ctx.service.cooperationConfirm.getValidData(ctx.tender.id, ctx.stage.id, ctx.stage.times, ctx.session.sessionUser.accountId);
  1742. break;
  1743. default:
  1744. throw '参数有误';
  1745. }
  1746. ctx.body = responseData;
  1747. } catch (err) {
  1748. this.log(err);
  1749. ctx.body = { err: 1, msg: err.toString(), data: null };
  1750. }
  1751. }
  1752. }
  1753. return StageController;
  1754. };