stage_controller.js 87 KB

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