stage_controller.js 87 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856
  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.status === auditConst.status.checkNoPre) && 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. const stageTimes = (ctx.stage.status === auditConst.status.checkNo && ctx.stage.user_id !== ctx.session.sessionUser.accountId) ? ctx.stage.times - 1 : ctx.stage.times;
  326. responseData.data.cooperationConfirm = uid !== null ? await ctx.service.cooperationConfirm.getValidData(ctx.tender.id, ctx.stage.id, stageTimes, uid) : [];
  327. break;
  328. case 'spec':
  329. const spec = {zlj: JSON.parse(JSON.stringify(stdConst.zlj)), jrg: stdConst.jrg};
  330. spec.zlj.deal_bills_tp = ctx.tender.info.deal_param.zanLiePrice;
  331. responseData.data.spec = spec;
  332. break;
  333. }
  334. }
  335. ctx.body = responseData;
  336. } catch (err) {
  337. this.log(err);
  338. ctx.body = { err: 1, msg: err.toString(), data: null };
  339. }
  340. }
  341. async check(ctx) {
  342. try {
  343. const projRela = await this.ctx.service.project.getFunRela(this.ctx.session.sessionProject.id);
  344. const ledgerData = await this._getStageLedgerData(ctx);
  345. const posData = await this._getStagePosData(ctx);
  346. const checkDataModel = require('../lib/ledger').checkData;
  347. const checkData = new checkDataModel(ctx);
  348. checkData.loadData(ledgerData, posData);
  349. await this.ctx.service.s2bProj.refreshSessionS2b();
  350. const check3fResult = checkData.check3fLimit(ctx.tender.data);
  351. const [qtyData, overData] = ctx.helper.checkBillsWithPos2(ledgerData, posData,
  352. ['contract_qty', 'qc_qty'], projRela.banOver, this.ctx.tender.data.measure_type === measureType.tz.value);
  353. qtyData.error.forEach(x => { x.errorType = 'qty'; });
  354. overData.error.forEach(x => {x.errorType = 'over'});
  355. const tpData = ctx.helper.checkBillsTp(ledgerData.filter(x => {return !x.is_tp}), [
  356. { qty: 'contract_qty', tp: 'contract_tp' }, { qty: 'qc_qty', tp: 'qc_tp' },
  357. ], this.ctx.tender.info.decimal);
  358. tpData.error.forEach(x => { x.errorType = 'tp'; });
  359. ctx.body = { err: 0, msg: '', data: {
  360. error: [...qtyData.error, ...tpData.error, ...overData.error, ...check3fResult.error],
  361. source: {
  362. bills: ctx.helper._.uniqBy([...qtyData.source.bills, ...tpData.source.bills, ...overData.source.bills, ...check3fResult.source.bills], 'id'),
  363. pos: ctx.helper._.uniqBy([...qtyData.source.pos, ...tpData.source.pos, ...overData.source.pos, ...check3fResult.source.pos], 'id'),
  364. },
  365. } };
  366. } catch (err) {
  367. this.log(err);
  368. ctx.body = this.ajaxErrorBody(err, '检查数据错误');
  369. }
  370. }
  371. /**
  372. * 获取期数据(截止上期 & 本期) (Ajax)
  373. * @param ctx
  374. * @return {Promise<void>}
  375. */
  376. async getStagePosData(ctx) {
  377. try {
  378. const condition = JSON.parse(ctx.request.body.data) || {};
  379. condition.tid = ctx.tender.id;
  380. const responseData = { err: 0, msg: '', data: {} };
  381. let curStageData,
  382. preStageData;
  383. responseData.data = await ctx.service.pos.getPosDataWithAddStageOrder(condition);
  384. // 根据当前人,或指定对象查询数据
  385. // console.time('cur');
  386. const curWhere = JSON.parse(ctx.request.body.data);
  387. if (ctx.stage.readOnly) {
  388. curStageData = await ctx.service.stagePos.getAuditorStageData2(ctx.tender.id,
  389. ctx.stage.id, ctx.stage.curTimes, ctx.stage.curOrder, curWhere);
  390. } else {
  391. curStageData = await ctx.service.stagePos.getLastestStageData2(ctx.tender.id, ctx.stage.id, curWhere);
  392. }
  393. // console.timeEnd('cur');
  394. // 查询截止上期数据
  395. // console.time('pre');
  396. if (ctx.stage.order > 1) {
  397. preStageData = await ctx.service.stagePosFinal.getFinalData(ctx.tender.data, ctx.stage.order - 1);
  398. // responseData.data.preStageData = await ctx.service.stagePos.getEndStageData(ctx.tender.id, ctx.stage.order - 1);
  399. } else {
  400. preStageData = [];
  401. }
  402. // console.timeEnd('pre');
  403. // console.time('assign');
  404. // console.log('cur: ' + curStageData.length);
  405. // console.log('pre: ' + preStageData.length);
  406. this.ctx.helper.assignRelaData(responseData.data, [
  407. { data: curStageData, fields: ['contract_qty', 'qc_qty', 'postil'], prefix: '', relaId: 'pid' },
  408. { data: preStageData, fields: ['contract_qty', 'qc_qty'], prefix: 'pre_', relaId: 'pid' },
  409. ]);
  410. // console.timeEnd('assign');
  411. ctx.body = responseData;
  412. } catch (err) {
  413. this.log(err);
  414. ctx.body = { err: 1, msg: err.toString(), data: null };
  415. }
  416. }
  417. /**
  418. * 保存数据 (Ajax)
  419. * @param ctx
  420. * @return {Promise<void>}
  421. */
  422. async updateStageData(ctx) {
  423. try {
  424. this._checkStageCanModify(ctx);
  425. const data = JSON.parse(ctx.request.body.data);
  426. const responseData = { err: 0, msg: '', data: {} };
  427. if (data.pos) {
  428. responseData.data = await ctx.service.stagePos.updateStageData(data.pos);
  429. } else if (data.bills) {
  430. if (data.bills.main) {
  431. const updateDatas = data.bills.main instanceof Array ? data.bills.main : [data.bills.main];
  432. const result = await ctx.app.mysql.updateRows(ctx.service.ledger.tableName, updateDatas);
  433. responseData.data.bills = await ctx.service.ledger.getDataByIds(this.ctx.helper._.map(updateDatas, 'id'));
  434. }
  435. if (data.bills.dgn) {
  436. ctx.helper.checkDgnQtyPrecision(data.bills.dgn);
  437. responseData.data.dgn = await ctx.service.stageBillsDgn.saveDgnData(data.bills.dgn);
  438. }
  439. if (data.bills.stage) {
  440. responseData.data.curStageData = await ctx.service.stageBills.updateStageData(data.bills.stage);
  441. }
  442. if (data.bills.calcType) {
  443. responseData.data = await ctx.service.stageBills.updateStageBillsCalcType(data.bills.calcType);
  444. }
  445. }
  446. await ctx.service.stage.updateCheckCalcFlag(ctx.stage, true);
  447. await ctx.service.stage.updateCacheTime(ctx.stage.id);
  448. ctx.body = responseData;
  449. } catch (err) {
  450. this.log(err);
  451. ctx.body = { err: 1, msg: err.toString(), data: null };
  452. }
  453. }
  454. /**
  455. * 查询可用变更令 (Ajax-Post)
  456. * @param ctx
  457. * @return {Promise<void>}
  458. */
  459. async searchValidChange(ctx) {
  460. try {
  461. const data = JSON.parse(ctx.request.body.data);
  462. if (!data.bills && !data.pos) {
  463. throw '数据错误';
  464. }
  465. const bills = data.bills ? data.bills : await ctx.service.ledger.getDataById(data.pos.lid);
  466. const pos = data.pos;
  467. const changes = ctx.stage.readOnly
  468. ? await ctx.service.change.getAuditValidChanges(ctx.tender.id, bills, null, ctx.stage.curTimes, ctx.stage.curOrder)
  469. : await ctx.service.change.getValidChanges(ctx.tender.id, bills);
  470. const useChanges = ctx.stage.readOnly
  471. ? await ctx.service.stageChange.getAuditorStageData(ctx.tender.id, ctx.stage.id, ctx.stage.curTimes, ctx.stage.curOrder, bills.id, pos ? pos.id : -1)
  472. : await ctx.service.stageChange.getLastestStageData(ctx.tender.id, ctx.stage.id, bills.id, pos ? pos.id : -1);
  473. ctx.body = { err: 0, msg: '', data: { changes, useChanges } };
  474. } catch (err) {
  475. this.log(err);
  476. ctx.body = { err: 1, msg: err.toString(), data: null };
  477. }
  478. }
  479. /**
  480. * 调用变更令 (Ajax-Post)
  481. * @param ctx
  482. * @return {Promise<void>}
  483. */
  484. async useChange(ctx) {
  485. try {
  486. this._checkStageCanModify(ctx);
  487. const data = JSON.parse(ctx.request.body.data);
  488. if (!data.target || (!data.target.bills && !data.target.pos) || !data.change) {
  489. throw '调用变更令数据错误';
  490. }
  491. let result;
  492. if (data.target.pos) {
  493. result = await ctx.service.stageChange.posChange(data.target.pos, data.change);
  494. result.change = { target: { lid: data.target.pos.lid, pid: data.target.pos.id } };
  495. result.change.data = await ctx.service.stageChange.getLastestStageData(ctx.tender.id,
  496. ctx.stage.id, data.target.pos.lid, data.target.pos.id);
  497. } else {
  498. result = await ctx.service.stageChange.billsChange(data.target.bills, data.change);
  499. result.change = { target: { lid: data.target.bills.id, pid: '-1' } };
  500. result.change.data = await ctx.service.stageChange.getLastestStageData(ctx.tender.id,
  501. ctx.stage.id, data.target.bills.id, '-1');
  502. }
  503. await ctx.service.stage.updateCheckCalcFlag(ctx.stage, true);
  504. await ctx.service.stage.updateCacheTime(ctx.stage.id);
  505. ctx.body = { err: 0, msg: '', data: result };
  506. } catch (err) {
  507. this.log(err);
  508. ctx.body = { err: 1, msg: err.toString(), data: null };
  509. }
  510. }
  511. /**
  512. * 查询变更令 明细数据(包括附件、变更清单、累计使用情况、本期使用情况) (Ajax-Post)
  513. * @param ctx
  514. * @return {Promise<void>}
  515. */
  516. async changeDetail(ctx) {
  517. try {
  518. const data = JSON.parse(ctx.request.body.data);
  519. if (!data.cid) {
  520. throw '查询数据错误';
  521. }
  522. const detailData = await this._getChangeDetailData(ctx.tender.id, ctx.stage.id, data.cid);
  523. ctx.body = { err: 0, msg: '', data: detailData };
  524. } catch (err) {
  525. this.log(err);
  526. ctx.body = { err: 1, msg: err.toString(), data: null };
  527. }
  528. }
  529. /**
  530. * 中间计量 (Get)
  531. * @param ctx
  532. * @return {Promise<void>}
  533. */
  534. async detail(ctx) {
  535. try {
  536. await this._getStageAuditViewData(ctx);
  537. const renderData = await this._getDefaultRenderData(ctx);
  538. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.detail);
  539. renderData.imType = tenderConst.imType;
  540. await this.layout('stage/detail.ejs', renderData, 'stage/detail_modal.ejs');
  541. } catch (err) {
  542. this.log(err);
  543. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage/' + ctx.params.order);
  544. }
  545. }
  546. /**
  547. * 设置中间计量生成规则,并生成中间计量数据 (Ajax)
  548. * @param ctx
  549. * @return {Promise<void>}
  550. */
  551. async buildDetailData(ctx) {
  552. try {
  553. this._checkStageCanModify(ctx);
  554. const data = JSON.parse(ctx.request.body.data);
  555. await ctx.service.stage.buildDetailData(ctx.tender.id, ctx.stage.order, data);
  556. await ctx.service.stage.updateCacheTime(ctx.stage.id);
  557. ctx.body = { err: 0, msg: '', data: null };
  558. } catch (err) {
  559. this.log(err);
  560. ctx.body = { err: 1, msg: err.toString(), data: null };
  561. }
  562. }
  563. /**
  564. * 加载数据 (Ajax)
  565. * @param ctx
  566. * @return {Promise<void>}
  567. */
  568. async loadDetailRelaData(ctx) {
  569. try {
  570. const data = JSON.parse(ctx.request.body.data);
  571. // 加载台账数据
  572. if (data.loadType === 'ledger') {
  573. const ledgerData = await ctx.service.ledger.getData(ctx.tender.id);
  574. ctx.body = { err: 0, msg: '', data: ledgerData };
  575. } else if (data.loadType === 'all') {
  576. const result = {};
  577. result.ledger = await ctx.service.ledger.getData(ctx.tender.id);
  578. result.pos = await ctx.service.pos.getPosData({ tid: ctx.tender.id });
  579. if (ctx.stage.readOnly) {
  580. const curStage = await ctx.service.stageBills.getAuditorStageData(ctx.tender.id, ctx.stage.id, ctx.stage.curTimes, ctx.stage.curOrder);
  581. this.ctx.helper.assignRelaData(result.ledger, [
  582. { data: curStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: '', relaId: 'lid' },
  583. ]);
  584. const curPosStage = await ctx.service.stagePos.getAuditorStageData2(ctx.tender.id, ctx.stage.id, ctx.stage.curTimes, ctx.stage.curOrder);
  585. this.ctx.helper.assignRelaData(result.pos, [
  586. { data: curPosStage, fields: ['contract_qty', 'qc_qty'], prefix: '', relaId: 'pid' },
  587. ]);
  588. } else {
  589. const curStage = await ctx.service.stageBills.getLastestStageData(ctx.tender.id, ctx.stage.id);
  590. this.ctx.helper.assignRelaData(result.ledger, [
  591. { data: curStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: '', relaId: 'lid' },
  592. ]);
  593. const curPosStage = await ctx.service.stagePos.getLastestStageData2(ctx.tender.id, ctx.stage.id);
  594. this.ctx.helper.assignRelaData(result.pos, [
  595. { data: curPosStage, fields: ['contract_qty', 'qc_qty'], prefix: '', relaId: 'pid' },
  596. ]);
  597. }
  598. result.stageDetail = await this._getStageDetailData(ctx);
  599. result.changeData = await this._getStageChangeData(ctx);
  600. ctx.body = { err: 0, msg: '', data: result };
  601. }
  602. } catch (err) {
  603. this.log(err);
  604. ctx.body = { err: 1, msg: err.toString(), data: null };
  605. }
  606. }
  607. /**
  608. * 中间计量,生成规则,高级设置 (Ajax)
  609. * @param ctx
  610. * @return {Promise<void>}
  611. */
  612. async setAdvancedConfig(ctx) {
  613. try {
  614. this._checkStageCanModify(ctx);
  615. const data = JSON.parse(ctx.request.body.data);
  616. await ctx.service.stage.update(data, { id: ctx.stage.id });
  617. await ctx.service.stage.updateCacheTime(ctx.stage.id);
  618. ctx.body = { err: 0, msg: '', data: this.ctx.stage };
  619. } catch (err) {
  620. this.log(err);
  621. ctx.body = { err: 1, msg: err.toString(), data: null };
  622. }
  623. }
  624. /**
  625. * 中间计量,编辑中间计量数据(Ajax)
  626. * @param ctx
  627. * @return {Promise<void>}
  628. */
  629. async saveDetailData(ctx) {
  630. try {
  631. this._checkStageCanModify(ctx);
  632. const data = JSON.parse(ctx.request.body.data);
  633. const responseData = { err: 0, msg: '', data: {} };
  634. if (data instanceof Array) {
  635. responseData.data = await ctx.service.stageDetail.saveDetailDatas(data);
  636. } else {
  637. responseData.data = await ctx.service.stageDetail.saveDetailData(data);
  638. }
  639. await ctx.service.stage.updateCacheTime(ctx.stage.id);
  640. ctx.body = responseData;
  641. } catch (err) {
  642. this.log(err);
  643. ctx.body = { err: 1, msg: err.toString(), data: null };
  644. }
  645. }
  646. /**
  647. * 中间计量,添加草图,上传图片 (Ajax)
  648. * @param ctx
  649. * @return {Promise<void>}
  650. */
  651. async addCalcImage(ctx) {
  652. try {
  653. this._checkStageCanModify(ctx);
  654. const stream = await ctx.getFileStream();
  655. const create_time = Date.parse(new Date()) / 1000;
  656. const fileInfo = path.parse(stream.filename);
  657. const fileName = path.join('public/upload', this.ctx.tender.id.toString(), 'im', 'calcImg_' + create_time + fileInfo.ext);
  658. await ctx.helper.saveStreamFile(stream, path.join(this.app.baseDir, 'app', fileName));
  659. ctx.body = { err: 0, msg: '', data: fileName };
  660. } catch (err) {
  661. this.log(err);
  662. ctx.body = { err: 1, msg: err.toString(), data: null };
  663. }
  664. }
  665. /**
  666. * 中间计量,设置草图 (Ajax)
  667. * @param ctx
  668. * @return {Promise<void>}
  669. */
  670. async mergeCalcImage(ctx) {
  671. try {
  672. this._checkStageCanModify(ctx);
  673. const data = JSON.parse(ctx.request.body.data);
  674. if (data.updateType === 'update') {
  675. const create_time = Date.parse(new Date()) / 1000;
  676. const fileName = path.join('public/upload', this.ctx.tender.id.toString(), 'im', 'calcImg_' + create_time + '.png');
  677. const base64Data = data.img.replace(/^data:image\/\w+;base64,/, '');
  678. const dataBuffer = new Buffer.from(base64Data, 'base64');
  679. await this.ctx.helper.saveBufferFile(dataBuffer, path.join(this.app.baseDir, 'app', fileName));
  680. data.calc_img = fileName;
  681. data.calc_img_org = JSON.stringify(data.imgInfo);
  682. delete data.updateType;
  683. delete data.img;
  684. delete data.imgInfo;
  685. } else if (data.updateType === 'clear') {
  686. data.calc_img = null;
  687. data.calc_img_org = null;
  688. data.calc_img_remark = null;
  689. delete data.updateType;
  690. }
  691. await this.ctx.service.stageDetail.saveDetailData(data);
  692. const imData = await ctx.service.stageDetail.getLastestImStageData(this.ctx.tender.id, this.ctx.stage.id, data.lid, data.uuid);
  693. await ctx.service.stage.updateCacheTime(ctx.stage.id);
  694. const responseData = { err: 0, msg: '', data: imData };
  695. ctx.body = responseData;
  696. } catch (err) {
  697. this.log(err);
  698. ctx.body = { err: 1, msg: err.toString(), data: null };
  699. }
  700. }
  701. async _updateStageCache(ctx, payCalculator) {
  702. await ctx.service.stage.update({
  703. check_calc: false,
  704. contract_tp: payCalculator.cur.contract_tp, qc_tp: payCalculator.cur.qc_tp,
  705. yf_tp: payCalculator.yf.tp,
  706. sf_tp: payCalculator.sf.tp,
  707. }, { id: ctx.stage.id });
  708. }
  709. /**
  710. * 合同支付 (Get)
  711. * @param ctx
  712. * @return {Promise<void>}
  713. */
  714. async pay(ctx) {
  715. try {
  716. await this._getStageAuditViewData(ctx);
  717. const renderData = await this._getDefaultRenderData(ctx);
  718. const dealPay = await ctx.service.stagePay.getStagePays(ctx.stage);
  719. // 附件不取下载地址
  720. for (const index in dealPay) {
  721. if (dealPay[index].attachment !== null) {
  722. const attachments = JSON.parse(dealPay[index].attachment);
  723. for (const att_index in attachments) {
  724. delete attachments[att_index].filepath;
  725. attachments[att_index].username = (await ctx.service.projectAccount.getAccountInfoById(attachments[att_index].uid)).name;
  726. }
  727. dealPay[index].attachment = attachments;
  728. }
  729. }
  730. renderData.dealPay = dealPay;
  731. renderData.calcBase = await ctx.service.stage.getStagePayCalcBase(ctx.stage, ctx.tender.info);
  732. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.pay);
  733. renderData.whiteList = this.ctx.app.config.multipart.whitelist;
  734. if (ctx.stage.order > 1) {
  735. renderData.pre = await ctx.service.stageBillsFinal.getSumTotalPrice(ctx.stage.tid, ctx.stage.order - 1);
  736. renderData.pre.gather_tp = ctx.helper.add(renderData.pre.contract_tp, renderData.pre.qc_tp);
  737. } else {
  738. renderData.pre = { contract_tp: null, qc_tp: null, gather_tp: null };
  739. }
  740. // 用户有无权限上传和删除附件
  741. renderData.uploadPermission = ((ctx.stage.status === auditConst.status.uncheck || ctx.stage.status === auditConst.status.checkNo) && ctx.session.sessionUser.accountId === ctx.stage.user_id) ||
  742. (ctx.stage.status === auditConst.status.checkNoPre && ctx.session.sessionUser.accountId === ctx.stage.curAuditor.aid) ||
  743. (ctx.stage.status === auditConst.status.checking && ctx.stage.curAuditor && ctx.stage.curAuditor.aid === ctx.session.sessionUser.accountId);
  744. if (!ctx.stage.readOnly || ctx.tender.isTourist) {
  745. // 计算 本期金额
  746. const payCalculator = new PayCalculator(ctx, ctx.stage, ctx.tender.info);
  747. await payCalculator.calculateAll(renderData.dealPay);
  748. await this._updateStageCache(ctx, payCalculator);
  749. // renderData.calcBase = payCalculator.bases;
  750. }
  751. await this.layout('stage/pay.ejs', renderData, 'stage/pay_modal.ejs');
  752. } catch (err) {
  753. this.log(err);
  754. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage');
  755. }
  756. }
  757. /**
  758. * 合同支付 - 编辑合同支付项 (Ajax)
  759. * @param ctx
  760. * @return {Promise<void>}
  761. */
  762. async savePayData(ctx) {
  763. function checkCalcField(data) {
  764. return data.sexpr !== undefined || data.sprice !== undefined
  765. || data.rexpr !== undefined || data.rprice !== undefined
  766. || data.minus !== undefined || data.is_yf !== undefined || data.dl_type !== undefined;
  767. }
  768. try {
  769. this._checkStageCanModify(ctx);
  770. const data = JSON.parse(ctx.request.body.data);
  771. const responseData = { err: 0, msg: '', data: {} };
  772. const payCalculator = new PayCalculator(ctx, ctx.stage, ctx.tender.info);
  773. switch (data.type) {
  774. case 'add':
  775. responseData.data = await ctx.service.pay.add();
  776. responseData.data = await ctx.service.stagePay.getStagePay(ctx.stage, responseData.data.pid);
  777. break;
  778. case 'del':
  779. await ctx.service.pay.del(data.id);
  780. responseData.data = await ctx.service.stagePay.getStagePays(ctx.stage);
  781. await payCalculator.calculateAll(responseData.data);
  782. await this._updateStageCache(ctx, payCalculator);
  783. break;
  784. case 'changeOrder':
  785. responseData.data = await ctx.service.pay.changeOrder(data.id1, data.id2);
  786. break;
  787. case 'info':
  788. responseData.data = await ctx.service.pay.save(data.updateData);
  789. const bReCalc = data.updateData instanceof Array ? checkCalcField(data.updateData[0]) : checkCalcField(data.updateData);
  790. if (bReCalc) {
  791. responseData.data = await ctx.service.stagePay.getStagePays(ctx.stage);
  792. await payCalculator.calculateAll(responseData.data);
  793. await this._updateStageCache(ctx, payCalculator);
  794. } else {
  795. if (data.updateData instanceof Array) {
  796. responseData.data = await ctx.service.stagePay.getStagePay(ctx.stage, this.app._.map(responseData.data, 'id'));
  797. } else {
  798. responseData.data = await ctx.service.stagePay.getStagePay(ctx.stage, responseData.data.id);
  799. }
  800. }
  801. break;
  802. case 'stage':
  803. await ctx.service.stagePay.save(data.updateData);
  804. responseData.data = await ctx.service.stagePay.getStagePays(ctx.stage);
  805. await payCalculator.calculateAll(responseData.data);
  806. await this._updateStageCache(ctx, payCalculator);
  807. break;
  808. }
  809. ctx.body = responseData;
  810. } catch (err) {
  811. this.log(err);
  812. ctx.body = { err: 1, msg: err.toString(), data: null };
  813. }
  814. }
  815. /**
  816. * 合同支付 - 章节明细 (Ajax-Post)
  817. * @param ctx
  818. * @return {Promise<void>}
  819. */
  820. async chapterDetail(ctx) {
  821. const _ = this.app._;
  822. const fields = ['contract_tp', 'qc_tp', 'gather_tp', 'end_gather_tp'];
  823. function assignStageData(chapter, curStage, preStage) {
  824. chapter.contract_tp = curStage.contract_tp;
  825. chapter.qc_tp = curStage.qc_tp;
  826. chapter.gather_tp = ctx.helper.add(curStage.contract_tp, curStage.qc_tp);
  827. if (preStage) {
  828. chapter.pre_contract_tp = preStage.contract_tp;
  829. chapter.pre_qc_tp = preStage.qc_tp;
  830. chapter.pre_gather_tp = ctx.helper.add(preStage.contract_tp, preStage.qc_tp);
  831. chapter.end_contract_tp = ctx.helper.add(curStage.contract_tp, preStage.contract_tp);
  832. chapter.end_qc_tp = ctx.helper.add(curStage.qc_tp, preStage.qc_tp);
  833. chapter.end_gather_tp = ctx.helper.add(chapter.gather_tp, chapter.pre_gather_tp);
  834. } else {
  835. chapter.end_contract_tp = curStage.contract_tp;
  836. chapter.end_qc_tp = curStage.qc_tp;
  837. chapter.end_gather_tp = chapter.gather_tp;
  838. }
  839. }
  840. try {
  841. const chapterDetail = JSON.parse(JSON.stringify(payConst.chapterDetail));
  842. const calcDetail = _.sortBy(chapterDetail, ['cType']);
  843. for (const cd of calcDetail) {
  844. switch (cd.cType) {
  845. case 1:
  846. const tp = await ctx.service.stageBills.getSumTotalPriceGcl(ctx.stage, cd.filter);
  847. assignStageData(cd, tp);
  848. break;
  849. case 11:
  850. assignStageData(cd, await ctx.service.stageBills.getSumTotalPriceGcl(ctx.stage));
  851. break;
  852. case 21:
  853. const sum = _.find(calcDetail, { cType: 11 });
  854. const chapters = _.filter(calcDetail, { cType: 1 });
  855. for (const f of fields) {
  856. cd[f] = ctx.helper.sub(sum[f], this.ctx.helper.sum(_.map(chapters, f)));// _.sumBy(chapters, f));
  857. }
  858. break;
  859. case 31:
  860. assignStageData(cd, await ctx.service.stageBills.getSumTotalPriceNotGcl(ctx.stage));
  861. break;
  862. case 41:
  863. const sum1 = _.find(calcDetail, { cType: 11 });
  864. const sum2 = _.find(calcDetail, { cType: 31 });
  865. for (const f of fields) {
  866. cd[f] = ctx.helper.add(sum1.value, sum2.value);
  867. }
  868. break;
  869. }
  870. }
  871. ctx.body = { err: 0, msg: '', data: { detail: chapterDetail, decimal: ctx.tender.info.decimal } };
  872. } catch (err) {
  873. this.log(err);
  874. ctx.body = { err: 1, msg: err.toString(), data: null };
  875. }
  876. }
  877. // 变更令相关
  878. /**
  879. * 查询变更令 明细数据(包括附件、变更清单、累计使用情况、本期使用情况)
  880. * @param tid
  881. * @param sid
  882. * @param cid
  883. * @return {Promise<{}>}
  884. * @private
  885. */
  886. async _getChangeDetailData(tid, sid, cid) {
  887. const data = {};
  888. data.attachments = await this.ctx.service.changeAtt.getChangeAttachment(cid);
  889. data.bills = await this.ctx.service.changeAuditList.getAllDataByCondition({ where: { cid } });
  890. data.addUsedBills = await this.ctx.service.stageChange.getUsedData(tid, cid);
  891. data.curUsedBills = await this.ctx.service.stageChange.getStageUsedData(sid, cid);
  892. return data;
  893. }
  894. /**
  895. * 获取变更数据 Post(Ajax)
  896. * @param ctx
  897. * @return {Promise<void>}
  898. */
  899. async getChangeData(ctx) {
  900. try {
  901. const data = {};
  902. data.tenderInfo = ctx.tender.info;
  903. data.ledger = await ctx.service.ledger.getData(ctx.tender.id);
  904. data.usedChangesId = await ctx.service.stageChange.getStageUsedChangeId(ctx.stage.id);
  905. data.changes = await ctx.service.change.getChangeAndUsedInfo(ctx.tender.id);
  906. if (data.changes.length > 0) {
  907. const change = data.changes[0];
  908. change.detail = await this._getChangeDetailData(ctx.tender.id, ctx.stage.id, change.cid);
  909. }
  910. ctx.body = { err: 0, msg: '', data };
  911. } catch (err) {
  912. this.log(err);
  913. ctx.body = { err: 1, msg: err.toString(), data: null };
  914. }
  915. }
  916. /**
  917. * 变更令 (Get)
  918. * @param ctx
  919. * @return {Promise<void>}
  920. */
  921. async change(ctx) {
  922. try {
  923. await this._getStageAuditViewData(ctx);
  924. const renderData = await this._getDefaultRenderData(ctx);
  925. renderData.changeConst = changeConst;
  926. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.change);
  927. await this.layout('stage/change.ejs', renderData, 'stage/audit_modal.ejs');
  928. } catch (err) {
  929. this.log(err);
  930. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage');
  931. }
  932. }
  933. // 审批相关
  934. /**
  935. * 添加审批人
  936. * @param ctx
  937. * @return {Promise<void>}
  938. */
  939. async addAudit(ctx) {
  940. try {
  941. this._checkStageCanModify(ctx);
  942. const data = JSON.parse(ctx.request.body.data);
  943. const id = this.app._.toInteger(data.auditorId);
  944. if (isNaN(id) || id <= 0) {
  945. throw '参数错误';
  946. }
  947. // 检查权限等
  948. if (ctx.stage.user_id !== ctx.session.sessionUser.accountId) {
  949. throw '您无权添加审核人';
  950. }
  951. if (ctx.stage.status === auditConst.status.checking || ctx.stage.status === auditConst.status.checked) {
  952. throw '当前不允许添加审核人';
  953. }
  954. ctx.stage.auditorList = await ctx.service.stageAudit.getAuditors(ctx.stage.id, ctx.stage.times);
  955. // 检查审核人是否已存在
  956. const exist = this.app._.find(ctx.stage.auditorList, { aid: id });
  957. if (exist) {
  958. throw '该审核人已存在,请勿重复添加';
  959. }
  960. const shenpiInfo = await ctx.service.shenpiAudit.getDataByCondition({ tid: ctx.tender.id, sp_type: shenpiConst.sp_type.stage, sp_status: shenpiConst.sp_status.gdzs });
  961. const is_gdzs = shenpiInfo && ctx.tender.info.shenpi.stage === shenpiConst.sp_status.gdzs ? 1 : 0;
  962. const result = await ctx.service.stageAudit.addAuditor(ctx.stage.id, id, ctx.stage.times, is_gdzs);
  963. if (!result) {
  964. throw '添加审核人失败';
  965. }
  966. const auditors = await ctx.service.stageAudit.getAuditGroupByListWithOwner(ctx.stage.id, ctx.stage.times);
  967. ctx.body = { err: 0, msg: '', data: auditors };
  968. } catch (err) {
  969. this.log(err);
  970. ctx.body = { err: 1, msg: err.toString(), data: null };
  971. }
  972. }
  973. /**
  974. * 移除审批人
  975. * @param ctx
  976. * @return {Promise<void>}
  977. */
  978. async deleteAudit(ctx) {
  979. try {
  980. this._checkStageCanModify(ctx);
  981. const data = JSON.parse(ctx.request.body.data);
  982. const id = data.auditorId instanceof Number ? data.auditorId : this.app._.toNumber(data.auditorId);
  983. if (isNaN(id) || id <= 0) {
  984. throw '参数错误';
  985. }
  986. const result = await ctx.service.stageAudit.deleteAuditor(ctx.stage.id, id, ctx.stage.times);
  987. if (!result) {
  988. throw '移除审核人失败';
  989. }
  990. const auditors = await ctx.service.stageAudit.getAuditors(ctx.stage.id, ctx.stage.times);
  991. ctx.body = { err: 0, msg: '', data: auditors };
  992. } catch (err) {
  993. ctx.body = { err: 1, msg: err.toString(), data: null };
  994. }
  995. }
  996. /**
  997. * 上报
  998. * @param ctx
  999. * @return {Promise<void>}
  1000. */
  1001. async startAudit(ctx) {
  1002. try {
  1003. this._checkStageCanModify(ctx);
  1004. if (ctx.stage.user_id !== ctx.session.sessionUser.accountId) {
  1005. throw '您无权上报该期数据';
  1006. }
  1007. if (ctx.stage.status === auditConst.status.checking || ctx.stage.status === auditConst.status.checked) {
  1008. throw '该期数据当前无法上报';
  1009. }
  1010. await ctx.service.stageAudit.start(ctx.stage.id, ctx.stage.times);
  1011. ctx.body = { err: 0, msg: '', data: [] };
  1012. } catch (err) {
  1013. this.log(err);
  1014. ctx.session.postError = err.toString();
  1015. // ctx.redirect(ctx.request.header.referer);
  1016. ctx.body = this.ajaxErrorBody(err, '上报失败');
  1017. }
  1018. }
  1019. /**
  1020. * 审批
  1021. * @param ctx
  1022. * @return {Promise<void>}
  1023. */
  1024. async checkAudit(ctx) {
  1025. try {
  1026. this._checkStageCanModify(ctx);
  1027. if (!this.ctx.stage || (this.ctx.stage.status !== auditConst.status.checking && this.ctx.stage.status !== auditConst.status.checkNoPre)) {
  1028. throw '当前期数据有误';
  1029. }
  1030. if (!this.ctx.stage.curAuditor || this.ctx.stage.curAuditor.aid !== ctx.session.sessionUser.accountId) {
  1031. throw '您无权进行该操作';
  1032. }
  1033. const data = JSON.parse(ctx.request.body.data);
  1034. data.checkType = parseInt(data.checkType);
  1035. // const data = {
  1036. // checkType: parseInt(ctx.request.body.checkType),
  1037. // opinion: ctx.request.body.opinion,
  1038. // };
  1039. if (!data.checkType || isNaN(data.checkType)) {
  1040. throw '提交数据错误';
  1041. }
  1042. if (data.checkType === auditConst.status.checkNo) {
  1043. if (!data.checkType || isNaN(data.checkType)) {
  1044. throw '提交数据错误';
  1045. }
  1046. }
  1047. await ctx.service.stageAudit.check(ctx.stage.id, data, ctx.stage.times);
  1048. ctx.body = { err: 0, msg: '', data: [] };
  1049. } catch (err) {
  1050. this.log(err);
  1051. ctx.body = this.ajaxErrorBody(err, '提交失败');
  1052. ctx.session.postError = err.toString();
  1053. }
  1054. }
  1055. /**
  1056. * 重新审批
  1057. * @param ctx
  1058. * @return {Promise<void>}
  1059. */
  1060. async checkAuditAgain(ctx) {
  1061. try {
  1062. if (ctx.stage.revising) {
  1063. throw '台账修订中,请勿修改提交期数据';
  1064. }
  1065. if (ctx.query.confirm !== undefined && ctx.query.confirm !== '确认设置终审审批') {
  1066. throw '请输入正确的文本信息';
  1067. }
  1068. if (ctx.session.sessionUser.loginStatus === 0) {
  1069. const code = ctx.query.code;
  1070. const pa = await ctx.service.projectAccount.getDataById(ctx.session.sessionUser.accountId);
  1071. if (!pa.auth_mobile) {
  1072. throw '未绑定手机号';
  1073. }
  1074. const cacheKey = 'smsCode:' + ctx.session.sessionUser.accountId;
  1075. const cacheCode = await app.redis.get(cacheKey);
  1076. // console.log(cacheCode);
  1077. if (cacheCode === null || code === undefined || cacheCode !== (code + pa.auth_mobile)) {
  1078. throw '验证码不正确!';
  1079. }
  1080. }
  1081. 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) {
  1082. await ctx.service.stageAudit.checkAgain(ctx.stage.id, ctx.stage.times);
  1083. // ctx.redirect(ctx.request.header.referer);
  1084. ctx.body = {
  1085. err: 0,
  1086. url: ctx.request.header.referer,
  1087. msg: '',
  1088. };
  1089. } else {
  1090. throw '您无权进行该操作';
  1091. }
  1092. } catch (err) {
  1093. this.log(err);
  1094. // ctx.session.postError = err.toString();
  1095. // ctx.redirect(ctx.request.header.referer);
  1096. ctx.body = {
  1097. err: 1,
  1098. // url: ctx.request.header.referer,
  1099. msg: err,
  1100. };
  1101. }
  1102. }
  1103. // 清单汇总相关
  1104. _getGatherSpreadSetting() {
  1105. const _ = this.app._;
  1106. function removeFieldCols(setting, cols) {
  1107. _.remove(setting.cols, function(c) {
  1108. return cols.indexOf(c.field) > -1;
  1109. });
  1110. }
  1111. function setColFormat(cols, field, formatter) {
  1112. const filterCols = cols.filter(function(c) {
  1113. return c.field.search(field) !== -1;
  1114. });
  1115. for (const col of filterCols) {
  1116. col.formatter = formatter;
  1117. }
  1118. }
  1119. // const tpFormatter = this.ctx.helper.getNumberFormatter(this.ctx.tender.info.decimal.tp);
  1120. // const upFormatter = this.ctx.helper.getNumberFormatter(2);
  1121. const gcl = JSON.parse(JSON.stringify(spreadConst.stageGather.gcl));
  1122. // setColFormat(gcl.cols, 'unit_price', upFormatter);
  1123. // setColFormat(gcl.cols, 'total_price', tpFormatter);
  1124. // setColFormat(gcl.cols, 'tp', tpFormatter);
  1125. const leafXmj = JSON.parse(JSON.stringify(spreadConst.stageGather.leafXmj));
  1126. const tender = this.ctx.tender;
  1127. if (tender.data.measure_type === measureType.tz.value) {
  1128. removeFieldCols(gcl, spreadConst.filterCols.tzWithoutCols);
  1129. }
  1130. return [gcl, leafXmj];
  1131. }
  1132. /**
  1133. * 清单汇总 页面 (Get)
  1134. * @param ctx
  1135. * @return {Promise<void>}
  1136. */
  1137. async gather(ctx) {
  1138. try {
  1139. await this._getStageAuditViewData(ctx);
  1140. const renderData = await this._getDefaultRenderData(ctx);
  1141. [renderData.gclSpread, renderData.leafXmjSpread] = this._getGatherSpreadSetting();
  1142. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.gather);
  1143. await this.layout('stage/gather.ejs', renderData, 'stage/gather_modal.ejs');
  1144. } catch (err) {
  1145. this.log(err);
  1146. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage/' + ctx.params.order);
  1147. }
  1148. }
  1149. /**
  1150. * 审核比较 页面 (Get)
  1151. * @param ctx
  1152. * @return {Promise<void>}
  1153. */
  1154. async compare(ctx) {
  1155. try {
  1156. await this._getStageAuditViewData(ctx);
  1157. const renderData = await this._getDefaultRenderData(ctx);
  1158. if (ctx.stage.status === auditConst.status.checkNo && !ctx.stage.readOnly) {
  1159. renderData.compareAuditors = ctx.stage.auditHistory[ctx.stage.curTimes - 2];
  1160. } else if (ctx.stage.times !== ctx.stage.curTimes) {
  1161. renderData.compareAuditors = ctx.stage.auditHistory[ctx.stage.curTimes - 1];
  1162. } else {
  1163. renderData.compareAuditors = ctx.stage.auditors;
  1164. }
  1165. renderData.ledgerSpread = JSON.parse(JSON.stringify(spreadConst.stageCompare.ledger));
  1166. renderData.posSpread = JSON.parse(JSON.stringify(spreadConst.stageCompare.pos));
  1167. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.compare);
  1168. await this.layout('stage/compare.ejs', renderData, 'stage/compare_modal.ejs');
  1169. } catch (err) {
  1170. this.log(err);
  1171. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage/' + ctx.params.order);
  1172. }
  1173. }
  1174. async compareAuditor(ctx) {
  1175. try {
  1176. const data = JSON.parse(ctx.request.body.data);
  1177. const result = {
  1178. main: null,
  1179. roles: [],
  1180. };
  1181. if (data.main) {
  1182. result.main = {};
  1183. result.main.ledger = await ctx.service.ledger.getData(ctx.tender.id);
  1184. result.main.pos = await ctx.service.pos.getPosData({ tid: ctx.tender.id });
  1185. }
  1186. for (const order of data.roles) {
  1187. const data = { order, bills: [], pos: [] };
  1188. const compareTimes = ctx.stage.status === auditConst.status.checkNo && !ctx.stage.readOnly
  1189. ? ctx.stage.curTimes - 1 : ctx.stage.curTimes;
  1190. data.bills = await ctx.service.stageBills.getAuditorStageData(ctx.tender.id, ctx.stage.id, compareTimes, order);
  1191. data.pos = await ctx.service.stagePos.getAuditorStageData(ctx.tender.id, ctx.stage.id, compareTimes, order);
  1192. result.roles.push(data);
  1193. }
  1194. ctx.body = { err: 0, msg: '', data: result };
  1195. } catch (err) {
  1196. this.log(err);
  1197. ctx.body = { err: 1, msg: err.toString(), data: null };
  1198. }
  1199. }
  1200. async bwtz(ctx) {
  1201. try {
  1202. await this._getStageAuditViewData(ctx);
  1203. const renderData = await this._getDefaultRenderData(ctx);
  1204. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.bwtz);
  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 fileName = 'stage' + create_time + fileInfo.ext;
  1461. // 判断文件夹是否存在,不存在则直接创建文件夹
  1462. if (!fs.existsSync(path.join(this.app.baseDir, dirName))) {
  1463. await fs.mkdirSync(path.join(this.app.baseDir, dirName));
  1464. }
  1465. // 保存文件
  1466. await ctx.helper.saveStreamFile(stream, path.join(this.app.baseDir, dirName, fileName));
  1467. // 保存数据到att表
  1468. fileData = {
  1469. filesize: stream.fields.size,
  1470. filepath: path.join(dirName, fileName),
  1471. };
  1472. }
  1473. const result = await ctx.service.stageAtt.updateByID(stream.fields, fileData);
  1474. if (!result) {
  1475. throw '导入数据库保存失败';
  1476. }
  1477. const attData = await ctx.service.stageAtt.getDataByFid(stream.fields.id);
  1478. attData.in_time = moment(attData.in_time * 1000).format('YYYY-MM-DD');
  1479. responseData.data = attData;
  1480. } catch (err) {
  1481. this.log(err);
  1482. // 失败需要消耗掉stream 以防卡死
  1483. if (stream) {
  1484. await sendToWormhole(stream);
  1485. }
  1486. this.setMessage(err.toString(), this.messageType.ERROR);
  1487. responseData.err = 1;
  1488. responseData.msg = err.toString();
  1489. }
  1490. ctx.body = responseData;
  1491. }
  1492. /**
  1493. * 批量下载 - 压缩成zip文件返回
  1494. * @param {Object} ctx - 全局上下文
  1495. */
  1496. async downloadZip(ctx) {
  1497. try {
  1498. const fileIds = JSON.parse(ctx.request.query.fileIds);
  1499. const zipFilename = `${ctx.tender.data.name}-计量台账-${ctx.params.order}-附件.zip`;
  1500. const time = Date.now();
  1501. const zipPath = `app/public/upload/${ctx.tender.id}/stage/fu_jian_zip${time}.zip`;
  1502. const size = await ctx.service.stageAtt.compressedFile(fileIds, zipPath);
  1503. // 解决中文无法下载问题
  1504. const userAgent = (ctx.request.header['user-agent'] || '').toLowerCase();
  1505. let disposition = '';
  1506. if (userAgent.indexOf('msie') >= 0 || userAgent.indexOf('chrome') >= 0) {
  1507. disposition = 'attachment; filename=' + encodeURIComponent(zipFilename);
  1508. } else if (userAgent.indexOf('firefox') >= 0) {
  1509. disposition = 'attachment; filename*="utf8\'\'' + encodeURIComponent(zipFilename) + '"';
  1510. } else {
  1511. /* safari等其他非主流浏览器只能自求多福了 */
  1512. disposition = 'attachment; filename=' + new Buffer(zipFilename).toString('binary');
  1513. }
  1514. ctx.response.set({
  1515. 'Content-Type': 'application/octet-stream',
  1516. 'Content-Disposition': disposition,
  1517. 'Content-Length': size,
  1518. });
  1519. const readStream = fs.createReadStream(path.join(this.app.baseDir, zipPath));
  1520. ctx.body = readStream;
  1521. readStream.on('close', () => {
  1522. if (fs.existsSync(path.resolve(this.app.baseDir, zipPath))) {
  1523. fs.unlinkSync(path.resolve(this.app.baseDir, zipPath));
  1524. }
  1525. });
  1526. } catch (error) {
  1527. this.log(error);
  1528. }
  1529. }
  1530. /**
  1531. * 合同支付上传附件
  1532. * @param {Object} ctx - egg全局变量
  1533. * @return {void}
  1534. */
  1535. async payUploadFile(ctx) {
  1536. const responseData = {
  1537. err: 0,
  1538. msg: '',
  1539. data: [],
  1540. };
  1541. let stream;
  1542. try {
  1543. this._checkStageCanModify(ctx);
  1544. const parts = ctx.multipart({ autoFields: true });
  1545. const files = [];
  1546. let index = 0;
  1547. const create_time = Date.parse(new Date()) / 1000;
  1548. while ((stream = await parts()) !== undefined) {
  1549. // 判断用户是否选择上传文件
  1550. if (!stream.filename) {
  1551. throw '请选择上传的文件!';
  1552. }
  1553. const fileInfo = path.parse(stream.filename);
  1554. const dirName = 'app/public/upload/pay/' + moment().format('YYYYMMDD');
  1555. const fileName = 'pay' + create_time + '_' + index + fileInfo.ext;
  1556. // 判断文件夹是否存在,不存在则直接创建文件夹
  1557. if (!fs.existsSync(path.join(this.app.baseDir, dirName))) {
  1558. await fs.mkdirSync(path.join(this.app.baseDir, dirName));
  1559. }
  1560. // 保存文件
  1561. await ctx.helper.saveStreamFile(stream, path.join(this.app.baseDir, dirName, fileName));
  1562. await sendToWormhole(stream);
  1563. // 插入到stage_pay对应的附件列表中
  1564. const attData = {
  1565. filename: fileInfo.name,
  1566. fileext: fileInfo.ext,
  1567. filesize: Array.isArray(parts.field.size) ? parts.field.size[index] : parts.field.size,
  1568. filepath: path.join(dirName, fileName),
  1569. uid: ctx.session.sessionUser.accountId,
  1570. in_time: moment(create_time * 1000).format('YYYY-MM-DD'),
  1571. };
  1572. const result = await ctx.service.stagePay.saveAtt(parts.field.pay_id, attData);
  1573. if (!result) {
  1574. throw '导入数据库保存失败';
  1575. }
  1576. delete attData.filepath;
  1577. attData.username = ctx.session.sessionUser.name;
  1578. files.length !== 0 ? files.unshift(attData) : files.push(attData);
  1579. ++index;
  1580. }
  1581. responseData.data = files;
  1582. } catch (err) {
  1583. this.log(err);
  1584. // 失败需要消耗掉stream 以防卡死
  1585. if (stream) {
  1586. await sendToWormhole(stream);
  1587. }
  1588. this.setMessage(err.toString(), this.messageType.ERROR);
  1589. responseData.err = 1;
  1590. responseData.msg = err.toString();
  1591. }
  1592. ctx.body = responseData;
  1593. }
  1594. /**
  1595. * 合同支付下载附件
  1596. * @param {Object} ctx - egg全局变量
  1597. * @return {void}
  1598. */
  1599. async payDownloadFile(ctx) {
  1600. const id = ctx.params.pid;
  1601. const index = ctx.params.index;
  1602. if (id && index) {
  1603. try {
  1604. const payInfo = await ctx.service.stagePay.getDataById(id);
  1605. if (payInfo !== undefined && payInfo.attachment !== null) {
  1606. const fileInfo = JSON.parse(payInfo.attachment)[index];
  1607. const fileName = path.join(this.app.baseDir, fileInfo.filepath);
  1608. // 解决中文无法下载问题
  1609. const userAgent = (ctx.request.header['user-agent'] || '').toLowerCase();
  1610. let disposition = '';
  1611. if (userAgent.indexOf('msie') >= 0 || userAgent.indexOf('chrome') >= 0) {
  1612. disposition = 'attachment; filename=' + encodeURIComponent(fileInfo.filename + fileInfo.fileext);
  1613. } else if (userAgent.indexOf('firefox') >= 0) {
  1614. disposition = 'attachment; filename*="utf8\'\'' + encodeURIComponent(fileInfo.filename + fileInfo.fileext) + '"';
  1615. } else {
  1616. /* safari等其他非主流浏览器只能自求多福了 */
  1617. disposition = 'attachment; filename=' + new Buffer(fileInfo.filename + fileInfo.fileext).toString('binary');
  1618. }
  1619. ctx.response.set({
  1620. 'Content-Type': 'application/octet-stream',
  1621. 'Content-Disposition': disposition,
  1622. 'Content-Length': fileInfo.filesize,
  1623. });
  1624. ctx.body = await fs.createReadStream(fileName);
  1625. } else {
  1626. throw '不存在该文件';
  1627. }
  1628. } catch (err) {
  1629. this.log(err);
  1630. this.setMessage(err.toString(), this.messageType.ERROR);
  1631. }
  1632. }
  1633. }
  1634. /**
  1635. * 合同支付删除附件
  1636. * @param {Object} ctx - egg全局变量
  1637. * @return {void}
  1638. */
  1639. async payDeleteFile(ctx) {
  1640. const responseData = {
  1641. err: 0,
  1642. msg: '',
  1643. data: '',
  1644. };
  1645. try {
  1646. this._checkStageCanModify(ctx);
  1647. const data = JSON.parse(ctx.request.body.data);
  1648. const payInfo = await ctx.service.stagePay.getDataById(data.id);
  1649. if (payInfo !== undefined) {
  1650. const fileInfo = JSON.parse(payInfo.attachment)[data.index];
  1651. // 先删除文件
  1652. await fs.unlinkSync(path.join(this.app.baseDir, fileInfo.filepath));
  1653. // 再删除数据库
  1654. const attachment = JSON.parse(payInfo.attachment);
  1655. attachment.splice(data.index, 1);
  1656. const result = await ctx.service.stagePay.deleteAtt(data.id, attachment);
  1657. responseData.data = '';
  1658. } else {
  1659. throw '不存在该文件';
  1660. }
  1661. // if (data.tid === undefined || data.uci === undefined || data.uc === undefined || data.ac === undefined) {
  1662. // throw '参数有误';
  1663. // }
  1664. // const [addCompany, selectCompany] = await ctx.service.changeCompany.setCompanyList(data);
  1665. // responseData.data = { add: addCompany, select: selectCompany };
  1666. } catch (err) {
  1667. responseData.err = 1;
  1668. responseData.msg = err;
  1669. }
  1670. ctx.body = responseData;
  1671. }
  1672. /**
  1673. * 期审批管理
  1674. * @param {Object} ctx - egg全局变量
  1675. * @return {void}
  1676. */
  1677. async manager(ctx) {
  1678. try {
  1679. await this._getStageAuditViewData(ctx);
  1680. const renderData = await this._getDefaultRenderData(ctx);
  1681. // 获取已完成期审批列表
  1682. const lastStage = await ctx.service.stage.getLastestStage(ctx.tender.id, true);
  1683. const auditList = [];
  1684. if (lastStage) {
  1685. renderData.lastStageUser = await ctx.service.projectAccount.getDataById(lastStage.user_id);
  1686. const times = lastStage.status !== auditConst.status.checkNo ? lastStage.times : lastStage.times - 1;
  1687. for (let i = times; i > 0; i--) {
  1688. const timeAuditList = await ctx.service.stageAudit.getAuditors(lastStage.id, i, 'desc');
  1689. auditList.push(timeAuditList);
  1690. }
  1691. }
  1692. renderData.lastStage = lastStage;
  1693. renderData.lastAuditList = auditList;
  1694. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.stage.manager);
  1695. await this.layout('stage/manager.ejs', renderData, 'stage/manager_modal.ejs');
  1696. } catch (err) {
  1697. this.log(err);
  1698. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage');
  1699. }
  1700. }
  1701. /**
  1702. * 删除本次审批 - 期审批管理页面
  1703. * @param ctx
  1704. * @return {Promise<void>}
  1705. */
  1706. async managerAuditDelete(ctx) {
  1707. try {
  1708. if (ctx.stage.revising) {
  1709. throw '台账修订中,请勿修改提交期数据';
  1710. }
  1711. if (ctx.request.body.confirm !== undefined && ctx.request.body.confirm !== '确认删除本次审批') {
  1712. throw '请输入正确的文本信息';
  1713. }
  1714. if (ctx.request.body.confirm === '确认删除本次审批' && ctx.session.sessionUser.is_admin && ctx.stage.order === ctx.stage.highOrder && ctx.stage.times !== 1) {
  1715. await ctx.service.stageAudit.timesDelete();
  1716. ctx.redirect(ctx.request.header.referer);
  1717. } else {
  1718. throw '您无权进行该操作';
  1719. }
  1720. } catch (err) {
  1721. this.log(err);
  1722. ctx.session.postError = err.toString();
  1723. ctx.redirect(ctx.request.header.referer);
  1724. }
  1725. }
  1726. /**
  1727. * 删除本次审批 - 期审批管理页面
  1728. * @param ctx
  1729. * @return {Promise<void>}
  1730. */
  1731. async saveCooperationData(ctx) {
  1732. try {
  1733. const data = JSON.parse(ctx.request.body.data);
  1734. const responseData = { err: 0, msg: '', data: {} };
  1735. switch (data.type) {
  1736. case 'save-confirm':
  1737. await ctx.service.cooperationConfirm.save(data.postData);
  1738. responseData.data.cooperationConfirm = await ctx.service.cooperationConfirm.getValidData(ctx.tender.id, ctx.stage.id, ctx.stage.times, ctx.session.sessionUser.accountId);
  1739. break;
  1740. case 'del-confirm':
  1741. await ctx.service.cooperationConfirm.del(data.postData);
  1742. responseData.data.cooperationConfirm = await ctx.service.cooperationConfirm.getValidData(ctx.tender.id, ctx.stage.id, ctx.stage.times, ctx.session.sessionUser.accountId);
  1743. break;
  1744. default:
  1745. throw '参数有误';
  1746. }
  1747. ctx.body = responseData;
  1748. } catch (err) {
  1749. this.log(err);
  1750. ctx.body = { err: 1, msg: err.toString(), data: null };
  1751. }
  1752. }
  1753. }
  1754. return StageController;
  1755. };