report_controller.js 119 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322
  1. 'use strict';
  2. /**
  3. * Created by Tony on 2019/7/5.
  4. */
  5. const tenderMenu = require('../../config/menu').tenderMenu;
  6. const measureType = require('../const/tender').measureType;
  7. const auditConst = require('../const/audit');
  8. const shenpiConst = require('../const/shenpi');
  9. const accountGroup = require('../const/account_group').group;
  10. const JpcEx = require('../reports/rpt_component/jpc_ex');
  11. const JV = require('../reports/rpt_component/jpc_value_define');
  12. const rpt_xl_util = require('../reports/util/rpt_excel_util');
  13. const rptDataExtractor = require('../reports/util/rpt_calculation_data_util');
  14. const fsUtil = require('../public/js/fsUtil');
  15. const fs = require('fs');
  16. const rptCronJob = require('../reports/util/rpt_tmp_file_sweep');
  17. const RPT_DEF_PROPERTIES = require('../const/report_defined_properties');
  18. const reportConst = require('../const/report');
  19. const advanceConst = require('../const/advance');
  20. const typeConsts = require('../const/advance');
  21. // const stringUtil = require('../public/js/string_util_light');
  22. const needCustomTables = [
  23. 'mem_custom_select',
  24. 'mem_gather_stage_bills', 'mem_gather_deal_bills', 'mem_gather_stage_pay', 'mem_gather_tender_info',
  25. 'mem_stage_sum_bills', 'mem_stage_sum_pay',
  26. 'mem_jh_gather_im_change', 'mem_jh_im_change', 'mem_jh_gather_stage_bills_compare',
  27. 'mem_material_sum_gl',
  28. ];
  29. const PermissionCheck = require('../const/account_permission').PermissionCheck;
  30. const STD_COMP_STAMP_SIZE_WIDTH = Math.round(5 * 96 / 2.54); // 公章标准尺寸(宽4.2厘米)转成像素
  31. const STD_COMP_STAMP_SIZE_HEIGHT = STD_COMP_STAMP_SIZE_WIDTH; // 公章标准尺寸(高4.2厘米)转成像素
  32. const NORMAL_SIGN_STR = 'normal_sign';
  33. const COMPANY_SIGN_STR = 'company_stamp';
  34. const PRIVATE_SIGN_STR = 'private_stamp';
  35. const sourceTypeConst = require('../const/source_type');
  36. const rptBusiness = require('../const/rpt_archive');
  37. module.exports = app => {
  38. class ReportController extends app.BaseController {
  39. /**
  40. * 获取审批界面所需的 原报、审批人数据等
  41. * @param {Object} ctx - egg全局context
  42. * @return {void}
  43. * @private
  44. */
  45. async _getStageAuditViewData(ctx) {
  46. if (!ctx.stage) return;
  47. await ctx.service.stage.loadStageAuditViewData(ctx.stage);
  48. }
  49. async _chkIfStageAuditor(ctx, stage) {
  50. //
  51. }
  52. async _filterStageList(ctx, stageList) {
  53. //
  54. // throw
  55. }
  56. async _getCustFolder(ctx, acc_id, tender_id) {
  57. const rst = [];
  58. // 因新需求,将增加tender_id作为定制化显示,但考虑到无缝链接,还是保留acc_id的判断:
  59. const custFolders1 = await ctx.service.rptTreeNodeCust.getCustFoldersByUserId(acc_id);
  60. const custFolders2 = await ctx.service.rptTreeNodeCust.getCustFolderByTenderId(tender_id);
  61. // 1. 两种条件都要查询结果,然后:
  62. // 1.1. 两种条件都没有,返回空数组
  63. // 1.2. 两种条件都有,返回tender_id的,删除acc_id的
  64. // 1.3. 只有acc_id的,那么:
  65. // 1.3.1 增加新记录,用tender_id作为索引保存(acc_id = -1);
  66. // 1.3.2 删除acc_id的这条记录,返回tender_id的这条记录
  67. // 1.4. 只有tender_id的,返回这条记录
  68. if (custFolders1.length > 0) {
  69. if (custFolders2.length > 0) {
  70. rst.push(custFolders2[0]);
  71. } else {
  72. await ctx.service.rptTreeNodeCust.createCustNodeByTenderId(acc_id, tender_id, custFolders1[0].rpt_tpl_items);
  73. rst.push(custFolders1[0]); // 直接拿原先的用了
  74. }
  75. // 现在会记录最后一个修改用户的id,所以不能直接删除,需要先判断
  76. if (custFolders1[0].id !== custFolders2[0].id) await ctx.service.rptTreeNodeCust.removeCustFolder(custFolders1[0].id);
  77. } else if (custFolders2.length > 0) {
  78. rst.push(custFolders2[0]);
  79. }
  80. return rst;
  81. }
  82. async _createNodes(ctx, source_type, pid) {
  83. const treeNodes = await ctx.service.rptTreeNode.getNodesBySourceType([pid], source_type); // 这个查定制的
  84. const commonTreeNodes = await ctx.service.rptTreeNode.getNodesByProjectId([-1]); // 这个查通用的
  85. const allTreeNodes = await ctx.service.rptTreeNode.getAllNodes([-1]); // 这个得到所有通用的(新业务需求)
  86. const allTreeItems = JSON.parse(allTreeNodes[0].items);
  87. const allIndivTreeNodes = await ctx.service.rptTreeNode.getAllNodes([pid]); // 这个得到所有定制的(新业务需求)
  88. // const allIndivTreeItems = JSON.parse(allIndivTreeNodes[0].items);
  89. const allIndivTreeItems = [];
  90. allIndivTreeNodes.forEach(indiTreeNode => {
  91. const newTopIndivNode = {
  92. ID: indiTreeNode.id || -1,
  93. name: indiTreeNode.name || '',
  94. // rpt_type: indiTreeNode.rpt_type || 1,
  95. source_type: indiTreeNode.source_type,
  96. // isParent: true,
  97. nodeType: 1,
  98. items: JSON.parse(indiTreeNode.items),
  99. };
  100. // allIndivTreeItems.push(...JSON.parse(indiTreeNode.items));
  101. allIndivTreeItems.push(newTopIndivNode);
  102. });
  103. const nodeItems = JSON.parse(commonTreeNodes[0].items);
  104. const commonArrs = [];
  105. nodeItems.forEach(nodeItem => {
  106. const srcType = nodeItem.source_type ? nodeItem.source_type : 1;
  107. if (srcType === source_type) {
  108. commonArrs.push(nodeItem);
  109. }
  110. });
  111. // 加一个dummy的通用报表
  112. const dummyCommonRptNode = { id: 1, name: '通用报表', pid: -1, rpt_type: 0, items: JSON.stringify(commonArrs) };
  113. treeNodes.push(dummyCommonRptNode);
  114. const custCfg = await ctx.service.rptCustomizeCfg.getCustomizeCfgByUserId('Administrator');
  115. return { treeNodes, commonArrs, custCfg, allTreeItems, allIndivTreeItems };
  116. }
  117. async _getInvolveAcc(ctx, tId) {
  118. // 获取所有项目参与者
  119. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  120. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  121. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  122. });
  123. const newAccountGroup = accountGroup.map((item, idx) => {
  124. const groupList = accountList.filter(item => item.account_group === idx);
  125. return { groupName: item, groupList };
  126. });
  127. const where = { tid: tId };
  128. const advance = await ctx.service.advance.getAllDataByCondition({
  129. columns: ['id', 'order', 'status', 'selected', 'type'],
  130. where,
  131. orders: [['type', 'asc'], ['create_time', 'desc']],
  132. });
  133. advance.forEach(x => {
  134. x.statusStr = auditConst.advance.statusString[x.status];
  135. x.typeStr = advanceConst.typeColMap[x.type].text;
  136. });
  137. return { accountList, newAccountGroup, advance };
  138. }
  139. /**
  140. * 报表显示页面
  141. *
  142. * @param {Object} ctx - egg全局context
  143. * @return {void}
  144. */
  145. async index(ctx) {
  146. // 普通情况(计量期入口)
  147. try {
  148. await this._getStageAuditViewData(ctx);
  149. const pageShow = ctx.session.sessionProject.page_show;
  150. pageShow.showArchive = 1;
  151. const tender = ctx.tender;
  152. const stage = ctx.stage;
  153. let stage_id = -1;
  154. let stage_order = -1;
  155. let sorder = -1;
  156. let stage_times = -1;
  157. let stage_status = -1;
  158. const { treeNodes, custCfg, allTreeItems, allIndivTreeItems } = await this._createNodes(ctx, sourceTypeConst.sourceType.tender, tender.data.project_id);
  159. // const custTreeFolders = await ctx.service.rptTreeNodeCust.getCustFoldersByUserId(this.ctx.session.sessionUser.accountId);
  160. const custTreeFolders = await this._getCustFolder(ctx, this.ctx.session.sessionUser.accountId, tender.id);
  161. const stageList = await ctx.service.stage.getValidStagesShort(tender.id);
  162. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: tender.data.project_id } }); // 找公司章用的
  163. // 以后还有预付款、材差
  164. // const advanceType = typeConsts.typeCol.find(item => item.key === 'start');
  165. // const advanceList = await ctx.service.advance.getAdvanceListDirectly(tender.id, advanceType.type);
  166. const advanceList = await ctx.service.advance.getAdvanceListDirectly(tender.id);
  167. const advanceAuditList = await ctx.service.advanceAudit.getAuditAdvanceByTender(tender.id);
  168. // const materialList = await ctx.service.advance.getValidMaterials(tender.id);
  169. const isAdmin = ctx.session.sessionUser.is_admin;
  170. // console.log('this.ctx.session.sessionUser.accountId: ' + this.ctx.session.sessionUser.accountId);
  171. if (stage && stage.status === auditConst.stage.status.uncheck) {
  172. // 得判断账号是否在审核人列表中(不含原报)
  173. if (stage.auditorList === undefined || stage.auditorList === null) {
  174. stage.auditorList = await ctx.service.stageAudit.getAuditors(ctx.stage.id, ctx.stage.times);
  175. }
  176. let isAudit = false;
  177. for (const audit of stage.auditorList) {
  178. if (audit.aid === this.ctx.session.sessionUser.accountId) {
  179. isAudit = true;
  180. break;
  181. }
  182. }
  183. if (isAudit) {
  184. throw '未上报!';
  185. }
  186. } else {
  187. // 剔除未上报期(审核人(非原报人)才需要判断)
  188. for (let idx = stageList.length - 1; idx >= 0; idx--) {
  189. if (stageList[idx].status === auditConst.stage.status.uncheck) {
  190. if (stageList[idx].auditorList === undefined || stageList[idx].auditorList === null) {
  191. stageList[idx].auditorList = await ctx.service.stageAudit.getAuditors(stageList[idx].id, stageList[idx].times);
  192. }
  193. let isAudit = false;
  194. for (const audit of stageList[idx].auditorList) {
  195. if (audit.aid === this.ctx.session.sessionUser.accountId) {
  196. isAudit = true;
  197. break;
  198. }
  199. }
  200. if (isAudit) {
  201. stageList.splice(idx, 1);
  202. }
  203. }
  204. }
  205. }
  206. let lastAuditor = null;
  207. if (stage) {
  208. lastAuditor = await ctx.service.stageAudit.getLastestAuditor(ctx.stage.id, ctx.stage.times, auditConst.stage.status.checked);
  209. } else {
  210. lastAuditor = stageList.length > 0 ? await ctx.service.stageAudit.getLastestAuditor(stageList[stageList.length - 1].id, stageList[stageList.length - 1].times, auditConst.stage.status.checked) : null;
  211. }
  212. let archiveList = [];
  213. if (stage) {
  214. const archives = await ctx.service.rptArchive.getPrjStgArchive(tender.data.project_id, ctx.stage.id);
  215. if (archives.length > 0) {
  216. archiveList = JSON.parse(archives[0].content);
  217. }
  218. } else {
  219. const archives = stageList.length > 0 ? await ctx.service.rptArchive.getPrjStgArchive(tender.data.project_id, stageList[stageList.length - 1].id) : [];
  220. // console.log(archives);
  221. if (archives && archives.length > 0) {
  222. archiveList = JSON.parse(archives[0].content);
  223. }
  224. }
  225. let prjAccList = await ctx.service.projectAccount.getAllAccountByProjectId(tender.data.project_id);
  226. prjAccList = prjAccList.filter(pa => pa.enable !== 0);
  227. const roleList = await ctx.service.signatureRole.getSignatureRolesByTenderId(tender.id);
  228. const usedList = await ctx.service.signatureUsed.getSignatureUsedByTenderId(tender.id);
  229. // ctx.session.sessionUser.is_admin
  230. // const pageShow = ctx.session.sessionProject.page_show;
  231. // 根据需求,如果开启了‘开启个人「签字」’功能,则只能是本身用户签名,管理员例外
  232. if (!ctx.session.sessionUser.is_admin && pageShow.individualSign === 1) {
  233. // 削减其他account
  234. const newAccList = [];
  235. for (const acc of prjAccList) {
  236. if (acc.id === this.ctx.session.sessionUser.accountId) {
  237. newAccList.push(acc);
  238. }
  239. }
  240. prjAccList = newAccList;
  241. }
  242. // 分类列表
  243. const categoryData = await this.ctx.service.category.getAllCategory(ctx.subProject);
  244. // 获取用户权限
  245. const accountInfo = await this.ctx.service.projectAccount.getDataById(this.ctx.session.sessionUser.accountId);
  246. const userPermission = accountInfo !== undefined && accountInfo.permission !== '' ? JSON.parse(accountInfo.permission) : null;
  247. // 获取用户可查看的标段
  248. const tenderList = await this.ctx.service.tender.getList('', userPermission);
  249. for (const t of tenderList) {
  250. if (t.ledger_status === auditConst.ledger.status.checked) {
  251. t.lastStage = await this.ctx.service.stage.getLastestStage(t.id, true);
  252. // if (t.lastStage) {
  253. // await this.ctx.service.stage.checkStageGatherData(t.lastStage, this.ctx.session.sessionUser.is_admin);
  254. // }
  255. }
  256. }
  257. // 获取汇总表,历史选择
  258. const cid = this.ctx.helper._.map(treeNodes, 'id');
  259. const customSelects = {};
  260. if (ctx.stage) {
  261. customSelects.audit_select = await ctx.service.rptCustomDefine.getCustomSelectByRpt(cid,
  262. reportConst.rptCustomType[JV.NODE_CUS_AUDIT_SELECT], ctx.tender.id, ctx.stage.id);
  263. customSelects.stageFlow = await ctx.service.stageAudit.getAuditGroupByListWithOwner(
  264. ctx.stage.stage_id, ctx.stage.stage_times);
  265. customSelects.stageFlow.forEach(x => {
  266. if (!x) return;
  267. x.visible = (!ctx.session.sessionUser.is_admin && ctx.session.sessionProject.page_show.individualSign === 1)
  268. ? x.aid === ctx.session.sessionUser.accountId : true;
  269. });
  270. } else {
  271. customSelects.audit_select = [];
  272. }
  273. customSelects.gather_select = await ctx.service.rptCustomDefine.getCustomSelectByRpt(cid,
  274. reportConst.rptCustomType[JV.NODE_CUS_GATHER_SELECT], ctx.tender.id, -1);
  275. customSelects.stage_select = await ctx.service.rptCustomDefine.getCustomSelectByRpt(cid,
  276. reportConst.rptCustomType[JV.NODE_CUS_STAGE_SELECT], ctx.tender.id, -1);
  277. customSelects.change_select = await ctx.service.rptCustomDefine.getCustomSelectByRpt(cid,
  278. reportConst.rptCustomType[JV.NODE_CUS_CHANGE_SELECT], ctx.tender.id, -1);
  279. customSelects.material_sum_select = await ctx.service.rptCustomDefine.getCustomSelectByRpt(cid,
  280. reportConst.rptCustomType[JV.NODE_CUS_MATERIAL_SUM_SELECT], ctx.tender.id, -1);
  281. const dataSelects = {};
  282. dataSelects.material_select = await ctx.service.rptCustomDefine.getDataSelectByRpt(cid,
  283. reportConst.rptDataType[JV.NODE_CUS_MATERIAL_SELECT]);
  284. const materialList = await ctx.service.material.getValidMaterials(ctx.tender.id);
  285. const materialAdjAuditList = await ctx.service.materialAudit.getAuditorsByTender(tender.id);
  286. if (stage !== null && stage !== undefined) {
  287. stage_id = stage.id;
  288. stage_order = stage.order;
  289. sorder = stage.curOrder;
  290. stage_times = stage.times;
  291. stage_status = stage.status;
  292. }
  293. for (const prjAcc of prjAccList) {
  294. prjAcc.account_group = prjAcc.company;
  295. }
  296. const cust_select_keys = JSON.stringify(['common', 'customize']); // 因其他地方也有可能保存用户报表的显示选择项,因当初设计问题,不好改数据库结构了,但可以调节内部json来满足需求
  297. const rpt_tpl_items = { customize: [], common: [] };
  298. if (custTreeFolders.length > 0) {
  299. const cust_select_item = JSON.parse(custTreeFolders[0].rpt_tpl_items);
  300. if (cust_select_item.common) rpt_tpl_items.common = cust_select_item.common;
  301. if (cust_select_item.customize) rpt_tpl_items.customize = cust_select_item.customize;
  302. }
  303. // 获取所有项目参与者
  304. const { accountList, newAccountGroup, advance } = await this._getInvolveAcc(ctx, this.ctx.tender.id);
  305. const renderData = {
  306. accountGroup: newAccountGroup,
  307. accountList,
  308. unitList: JSON.stringify(unitList),
  309. tender: tender.data,
  310. tenderInfo: tender.info,
  311. rpt_tpl_data: JSON.stringify(treeNodes),
  312. cust_tpl_data: JSON.stringify(rpt_tpl_items),
  313. all_common_tpl_data: JSON.stringify(allTreeItems),
  314. all_indivi_tpl_data: JSON.stringify(allIndivTreeItems),
  315. cust_select_keys,
  316. cust_cfg: JSON.stringify(custCfg),
  317. project_id: tender.data.project_id,
  318. tender_id: tender.id,
  319. tender_name: tender.data.name,
  320. budget_id: -1,
  321. sp_id: -1,
  322. detail_id: -1,
  323. stg_id: stage_id,
  324. stg_order: stage_order,
  325. cur_order: sorder,
  326. stg_times: stage_times,
  327. stg_status: stage_status,
  328. stage_list: JSON.stringify(stageList),
  329. prj_account_list: JSON.stringify(prjAccList),
  330. role_list: JSON.stringify(roleList),
  331. used_list: JSON.stringify(usedList),
  332. tenderMenu,
  333. preUrl: '/tender/' + ctx.tender.id + '/measure/stage/' + ctx.params.order,
  334. measureType,
  335. categoryData,
  336. tenderList,
  337. auditConst: auditConst.stage,
  338. ledgerAuditConst: auditConst.ledger,
  339. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.report.main),
  340. customSelects,
  341. rptCustomType: reportConst.rptCustomType,
  342. advanceList: JSON.stringify(advanceList),
  343. advanceAuditList: JSON.stringify(advanceAuditList),
  344. materialAdjList: JSON.stringify(materialList),
  345. materialAdjAuditList: JSON.stringify(materialAdjAuditList),
  346. materialList,
  347. stages: stageList,
  348. dataSelects,
  349. // pageShow: JSON.stringify(pageShow),
  350. pageShow,
  351. authMobile: accountInfo.auth_mobile,
  352. shenpiConst,
  353. archiveList,
  354. lastAuditor,
  355. rpt_id: ctx.query.rpt_id,
  356. isAdmin,
  357. prePay: JSON.stringify(advance),
  358. OSS_PATH: ctx.app.config.fujianOssPath,
  359. viewPmData: PermissionCheck.viewPmData(this.ctx.session.sessionUser.permission),
  360. auditType: auditConst.auditType,
  361. source_type: 1,
  362. bglObj: 'null',
  363. changes: 'null',
  364. otherChangeList: 'null',
  365. otherHintName: '',
  366. advanceConst,
  367. };
  368. await this.layout('report/index.ejs', renderData, 'report/rpt_all_popup.ejs');
  369. // await this.layout('report/index.ejs', renderData);
  370. // 在这里启动一个cron job,删除临时创建的excel文件
  371. if (!rptCronJob.started) {
  372. try {
  373. // console.log('rptCronJob.started: ' + rptCronJob.started);
  374. rptCronJob.started = true;
  375. // console.log('this.app.baseDir: ' + this.app.baseDir);
  376. rptCronJob.createJob(null, this.app.baseDir + '/app/public/download');
  377. } catch (ex) {
  378. rptCronJob.started = false;
  379. }
  380. }
  381. } catch (err) {
  382. this.log(err);
  383. ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage');
  384. }
  385. }
  386. async indexForPaymentSafe(ctx) {
  387. // 安全生产费入口
  388. try {
  389. await this._getStageAuditViewData(ctx);
  390. const pageShow = ctx.session.sessionProject.page_show;
  391. // pageShow.showArchive = 1;
  392. pageShow.showArchive = 0;
  393. // pageShow.closeWatermark = 1;
  394. pageShow.closeShowAllCustomized = 0;
  395. const tenderId = ctx.params.id;
  396. const paymentDetail_id = ctx.params.did;
  397. // 支付审批: ctx.params.did 是 zh_payment_detail表的id, 通过这个did在 zh_payment_detail_audit表里找审核信息(td_id = ctx.params.did)
  398. // 没有计量期的概念!!!
  399. // const paymentAuditorList = await ctx.service.paymentDetailAudit.getAuditors(paymentDetail_id);
  400. const tender = ctx.paymentTender;
  401. const { treeNodes, commonArrs, custCfg } = await this._createNodes(ctx, sourceTypeConst.sourceType.payment_safe, tender.pid);
  402. // const { treeNodes, custCfg, allTreeItems, allIndivTreeItems } = await this._createNodes(ctx, sourceTypeConst.sourceType.tender, tender.data.project_id);
  403. const stageList = [];
  404. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: tender.pid } }); // 找公司章用的
  405. const isAdmin = ctx.session.sessionUser.is_admin;
  406. const lastAuditor = null;
  407. const archiveList = [];
  408. let prjAccList = await ctx.service.projectAccount.getAllAccountByProjectId(tender.pid);
  409. prjAccList = prjAccList.filter(pa => pa.enable !== 0);
  410. const roleList = await ctx.service.signatureRole.getSignatureRolesByTenderId(tender.id);
  411. const usedList = await ctx.service.signatureUsed.getSignatureUsedByTenderId(tender.id);
  412. // 根据需求,如果开启了‘开启个人「签字」’功能,则只能是本身用户签名,管理员例外
  413. if (!ctx.session.sessionUser.is_admin && pageShow.individualSign === 1) {
  414. // 削减其他account
  415. const newAccList = [];
  416. for (const acc of prjAccList) {
  417. if (acc.id === this.ctx.session.sessionUser.accountId) {
  418. newAccList.push(acc);
  419. }
  420. }
  421. prjAccList = newAccList;
  422. }
  423. // 分类列表 todo 支付审批 目前没有所属子项目,自定义分类暂无法按所属子项目取值
  424. const categoryData = await this.ctx.service.category.getAllCategory(this.ctx.session.sessionProject.id);
  425. // 获取用户权限
  426. const accountInfo = await this.ctx.service.projectAccount.getDataById(this.ctx.session.sessionUser.accountId);
  427. // const userPermission = accountInfo !== undefined && accountInfo.permission !== '' ? JSON.parse(accountInfo.permission) : null;
  428. // 获取用户可查看的标段
  429. // ...
  430. const tenderList = [];
  431. const cid = this.ctx.helper._.map(treeNodes, 'id');
  432. const customSelects = null;
  433. const dataSelects = {};
  434. dataSelects.material_select = await ctx.service.rptCustomDefine.getDataSelectByRpt(cid,
  435. reportConst.rptDataType[JV.NODE_CUS_MATERIAL_SELECT]);
  436. const materialList = await ctx.service.material.getValidMaterials();
  437. const stage_id = -100;
  438. let stage_order = -1;
  439. let sorder = -1;
  440. let stage_times = -1;
  441. let stage_status = -1;
  442. const paymentDetailList = await ctx.service.paymentDetail.getDetail(paymentDetail_id);
  443. if (paymentDetailList && paymentDetailList.length > 0) {
  444. const payment = paymentDetailList[0];
  445. stage_status = payment.status;
  446. stage_order = payment.order;
  447. sorder = stage_order;
  448. stage_times = payment.times;
  449. stageList.push({ id: stage_id, user_id: payment.uid, status: payment.status });
  450. }
  451. for (const prjAcc of prjAccList) {
  452. prjAcc.account_group = prjAcc.company;
  453. }
  454. const cust_select_keys = JSON.stringify(['common_safe', 'customize_safe']); // 因其他地方也有可能保存用户报表的显示选择项,因当初设计问题,不好改数据库结构了,但可以调节内部json来满足需求,安全生产费没有这个,就过了
  455. const rpt_tpl_items = { customize: [], common: [] };
  456. commonArrs.forEach(item => {
  457. rpt_tpl_items.common.push(item.name);
  458. });
  459. // 获取所有项目参与者
  460. const { accountList, newAccountGroup, advance } = await this._getInvolveAcc(ctx, tenderId);
  461. const renderData = {
  462. accountGroup: newAccountGroup,
  463. accountList,
  464. unitList: JSON.stringify(unitList),
  465. tender: null,
  466. tenderInfo: null,
  467. rpt_tpl_data: JSON.stringify(treeNodes),
  468. cust_tpl_data: JSON.stringify(rpt_tpl_items),
  469. all_common_tpl_data: JSON.stringify([]),
  470. all_indivi_tpl_data: JSON.stringify([]),
  471. cust_select_keys,
  472. cust_cfg: JSON.stringify(custCfg),
  473. project_id: tender.pid,
  474. tender_id: tenderId,
  475. tender_name: tender.name,
  476. detail_id: paymentDetail_id,
  477. stg_id: stage_id,
  478. budget_id: -1,
  479. sp_id: -1,
  480. stg_order: stage_order,
  481. cur_order: sorder,
  482. stg_times: stage_times,
  483. stg_status: stage_status,
  484. stage_list: JSON.stringify(stageList),
  485. prj_account_list: JSON.stringify(prjAccList),
  486. role_list: JSON.stringify(roleList),
  487. used_list: JSON.stringify(usedList),
  488. tenderMenu,
  489. preUrl: '/tender/' + tenderId + '/measure/stage/' + ctx.params.order,
  490. measureType,
  491. categoryData,
  492. tenderList,
  493. auditConst: auditConst.stage,
  494. ledgerAuditConst: auditConst.ledger,
  495. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.report.main),
  496. customSelects,
  497. rptCustomType: reportConst.rptCustomType,
  498. advanceList: JSON.stringify([]),
  499. advanceAuditList: JSON.stringify([]),
  500. materialAdjList: JSON.stringify(materialList),
  501. materialAdjAuditList: JSON.stringify([]),
  502. materialList,
  503. stages: stageList,
  504. dataSelects,
  505. pageShow,
  506. authMobile: accountInfo.auth_mobile,
  507. shenpiConst,
  508. archiveList,
  509. lastAuditor,
  510. rpt_id: ctx.query.rpt_id,
  511. isAdmin,
  512. prePay: JSON.stringify(advance),
  513. OSS_PATH: ctx.app.config.fujianOssPath,
  514. viewPmData: PermissionCheck.viewPmData(this.ctx.session.sessionUser.permission),
  515. source_type: 101,
  516. bglObj: 'null',
  517. changes: 'null',
  518. otherChangeList: 'null',
  519. otherHintName: '',
  520. };
  521. /*
  522. //*/
  523. await this.layout('report/index.ejs', renderData, 'report/rpt_all_popup.ejs');
  524. } catch (err) {
  525. this.log(err);
  526. // ctx.redirect('/tender/' + ctx.tender.id + '/measure/stage');
  527. }
  528. }
  529. async indexForDynamicGrandTotal(ctx) {
  530. // 动态决算(动态投资)入口 (以独立报表为蓝本(index入口))
  531. try {
  532. await this._getStageAuditViewData(ctx);
  533. const pageShow = ctx.session.sessionProject.page_show;
  534. // pageShow.closeWatermark = 1;
  535. pageShow.showArchive = 0;
  536. pageShow.closeShowAllCustomized = 0;
  537. const tenderId = -1;
  538. const paymentDetail_id = -1;
  539. // const tender = ctx.paymentTender;
  540. const pid = ctx.budget.pid;
  541. const budget_id = ctx.budget.id;
  542. const subProj = await ctx.service.subProject.getDataByCondition({ budget_id });
  543. const sp_id = subProj.id;
  544. const { treeNodes, commonArrs, custCfg } = await this._createNodes(ctx, sourceTypeConst.sourceType.budget, pid);
  545. // const { treeNodes, custCfg, allTreeItems, allIndivTreeItems } = await this._createNodes(ctx, sourceTypeConst.sourceType.tender, tender.data.project_id);
  546. const stageList = [];
  547. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid } }); // 找公司章用的
  548. const isAdmin = ctx.session.sessionUser.is_admin;
  549. const lastAuditor = null;
  550. const archiveList = [];
  551. let prjAccList = await ctx.service.projectAccount.getAllAccountByProjectId(pid);
  552. prjAccList = prjAccList.filter(pa => pa.enable !== 0);
  553. const roleList = [];
  554. const usedList = [];
  555. // 根据需求,如果开启了‘开启个人「签字」’功能,则只能是本身用户签名,管理员例外
  556. if (!ctx.session.sessionUser.is_admin && pageShow.individualSign === 1) {
  557. // 削减其他account
  558. const newAccList = [];
  559. for (const acc of prjAccList) {
  560. if (acc.id === this.ctx.session.sessionUser.accountId) {
  561. newAccList.push(acc);
  562. }
  563. }
  564. prjAccList = newAccList;
  565. }
  566. // 分类列表
  567. const categoryData = await this.ctx.service.category.getAllCategory(ctx.subProject);
  568. // 获取用户权限
  569. const accountInfo = await this.ctx.service.projectAccount.getDataById(this.ctx.session.sessionUser.accountId);
  570. // const userPermission = accountInfo !== undefined && accountInfo.permission !== '' ? JSON.parse(accountInfo.permission) : null;
  571. // 获取用户可查看的标段
  572. // ...
  573. const tenderList = [];
  574. const cid = this.ctx.helper._.map(treeNodes, 'id');
  575. const customSelects = null;
  576. const dataSelects = {};
  577. dataSelects.material_select = await ctx.service.rptCustomDefine.getDataSelectByRpt(cid,
  578. reportConst.rptDataType[JV.NODE_CUS_MATERIAL_SELECT]);
  579. const materialList = await ctx.service.material.getValidMaterials();
  580. const stage_id = -200;
  581. const stage_order = -1;
  582. const sorder = -1;
  583. const stage_times = -1;
  584. const stage_status = -1;
  585. for (const prjAcc of prjAccList) {
  586. prjAcc.account_group = prjAcc.company;
  587. }
  588. const cust_select_keys = JSON.stringify(['common_dynamic', 'customize_dynamic']); // 因其他地方也有可能保存用户报表的显示选择项,因当初设计问题,不好改数据库结构了,但可以调节内部json来满足需求
  589. const rpt_tpl_items = { customize: [], common: [] };
  590. const custTreeFolders = await ctx.service.rptTreeNodeCust.getCustFoldersByUserId(this.ctx.session.sessionUser.accountId);
  591. if (custTreeFolders.length > 0) {
  592. const cust_select_item = JSON.parse(custTreeFolders[0].rpt_tpl_items);
  593. if (cust_select_item.common_dynamic) rpt_tpl_items.common = cust_select_item.common_dynamic;
  594. if (cust_select_item.customize_dynamic) rpt_tpl_items.customize = cust_select_item.customize_dynamic;
  595. if (!cust_select_item.hasOwnProperty('common_dynamic') && !cust_select_item.hasOwnProperty('customize_dynamic')) {
  596. commonArrs.forEach(item => {
  597. rpt_tpl_items.common.push(item.name);
  598. });
  599. }
  600. } else {
  601. commonArrs.forEach(item => {
  602. rpt_tpl_items.common.push(item.name);
  603. });
  604. }
  605. // 获取所有项目参与者
  606. const { accountList, newAccountGroup, advance } = await this._getInvolveAcc(ctx, tenderId);
  607. const renderData = {
  608. accountGroup: newAccountGroup,
  609. accountList,
  610. unitList: JSON.stringify(unitList),
  611. tender: null,
  612. tenderInfo: null,
  613. rpt_tpl_data: JSON.stringify(treeNodes),
  614. cust_tpl_data: JSON.stringify(rpt_tpl_items),
  615. all_common_tpl_data: JSON.stringify([]),
  616. all_indivi_tpl_data: JSON.stringify([]),
  617. cust_select_keys,
  618. cust_cfg: JSON.stringify(custCfg),
  619. project_id: pid,
  620. tender_id: tenderId,
  621. budget_id,
  622. sp_id,
  623. tender_name: ctx.budget.name,
  624. detail_id: paymentDetail_id,
  625. stg_id: stage_id,
  626. stg_order: stage_order,
  627. cur_order: sorder,
  628. stg_times: stage_times,
  629. stg_status: stage_status,
  630. stage_list: JSON.stringify(stageList),
  631. prj_account_list: JSON.stringify(prjAccList),
  632. role_list: JSON.stringify(roleList),
  633. used_list: JSON.stringify(usedList),
  634. tenderMenu,
  635. preUrl: '/tender/' + tenderId + '/measure/stage/' + ctx.params.order,
  636. measureType,
  637. categoryData,
  638. tenderList,
  639. auditConst: auditConst.stage,
  640. ledgerAuditConst: auditConst.ledger,
  641. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.report.main),
  642. customSelects,
  643. rptCustomType: reportConst.rptCustomType,
  644. advanceList: JSON.stringify([]),
  645. advanceAuditList: JSON.stringify([]),
  646. materialAdjList: JSON.stringify(materialList),
  647. materialAdjAuditList: JSON.stringify([]),
  648. materialList,
  649. stages: stageList,
  650. dataSelects,
  651. pageShow,
  652. authMobile: accountInfo.auth_mobile,
  653. shenpiConst,
  654. archiveList,
  655. lastAuditor,
  656. rpt_id: ctx.query.rpt_id,
  657. isAdmin,
  658. prePay: JSON.stringify(advance),
  659. OSS_PATH: ctx.app.config.fujianOssPath,
  660. viewPmData: PermissionCheck.viewPmData(this.ctx.session.sessionUser.permission),
  661. source_type: 200,
  662. bglObj: 'null',
  663. changes: 'null',
  664. otherChangeList: 'null',
  665. otherHintName: '',
  666. };
  667. await this.layout('report/index.ejs', renderData, 'report/rpt_all_popup.ejs');
  668. } catch (err) {
  669. this.log(err);
  670. }
  671. }
  672. async _indexForBGL(ctx, source_type, stage_id) {
  673. // 变更令、变更方案、变更立项、变更申请 报表入口
  674. try {
  675. await this._getStageAuditViewData(ctx);
  676. const pageShow = ctx.session.sessionProject.page_show;
  677. pageShow.closeWatermark = 1;
  678. pageShow.showArchive = 1;
  679. pageShow.closeShowAllCustomized = 0;
  680. const tenderId = ctx.params.id;
  681. const bglObj = {};
  682. if (stage_id === -300) {
  683. bglObj.BUSINESS_ID = ctx.params.cid;
  684. bglObj.change = await ctx.service.change.getChangeByCid(ctx.params.cid);
  685. bglObj.currentBz = bglObj.change;
  686. bglObj.status = bglObj.change.status;
  687. // const audit = await ctx.service.changeAudit.getChangeByCid(ctx.params.cid);
  688. }
  689. if (stage_id === -301) {
  690. bglObj.BUSINESS_ID = ctx.params.cplnid;
  691. bglObj.change_plan = await ctx.service.changePlan.getDataById(ctx.params.cplnid);
  692. bglObj.currentBz = bglObj.change_plan;
  693. bglObj.status = bglObj.change_plan.status;
  694. }
  695. if (stage_id === -302) {
  696. bglObj.BUSINESS_ID = ctx.params.cprjid;
  697. bglObj.change_project = await ctx.service.changeProject.getDataById(ctx.params.cprjid);
  698. bglObj.currentBz = bglObj.change_project;
  699. bglObj.status = bglObj.change_project.status;
  700. }
  701. if (stage_id === -303) {
  702. bglObj.BUSINESS_ID = ctx.params.caid;
  703. bglObj.change_apply = await ctx.service.changeApply.getDataById(ctx.params.caid);
  704. bglObj.currentBz = bglObj.change_apply;
  705. bglObj.status = bglObj.change_apply.status;
  706. }
  707. const changeId = ctx.params.cid;
  708. const paymentDetail_id = -1;
  709. const pid = ctx.session.sessionProject.id;
  710. const budget_id = -1;
  711. const sp_id = -1;
  712. const { treeNodes, custCfg } = await this._createNodes(ctx, source_type, pid);
  713. // const { treeNodes, custCfg, allTreeItems, allIndivTreeItems } = await this._createNodes(ctx, sourceTypeConst.sourceType.tender, tender.data.project_id);
  714. const state = ctx.session.sessionProject.page_show.openChangeState && ctx.query.state ? parseInt(ctx.query.state) : 0;
  715. const changes = await ctx.service.change.getListByStatus(tenderId, 0, 0, 0, 0, state);
  716. let change_times = 1;
  717. const stageList = [];
  718. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid } }); // 找公司章用的
  719. const isAdmin = ctx.session.sessionUser.is_admin;
  720. let lastAuditor = null;
  721. for (let cIdx = 0; cIdx < changes.length; cIdx++) {
  722. if (changes[cIdx].cid === changeId) {
  723. if (changes[cIdx].times > change_times) change_times = changes[cIdx].times;
  724. if (changes[cIdx].status === 3) {
  725. const changeAudit = await ctx.service.changeAudit.getLastUser(changeId, changes[cIdx].times, 3);
  726. if (changeAudit) {
  727. lastAuditor = { end_time: changeAudit.sin_time, sdesc: changeAudit.sdesc };
  728. }
  729. }
  730. break;
  731. }
  732. }
  733. let otherChangeList = [],
  734. otherHintName = '';
  735. switch (stage_id) {
  736. case rptBusiness.BusinessStageId.change_plan:
  737. otherChangeList = await ctx.service.changePlan.getListByStatus(tenderId, 0, 0, 0, 0, state);
  738. otherHintName = '变更方案';
  739. break;
  740. case rptBusiness.BusinessStageId.change_project:
  741. otherChangeList = await ctx.service.changeProject.getListByStatus(tenderId, 0, 0, 0, 0, state);
  742. otherHintName = '变更立项';
  743. break;
  744. case rptBusiness.BusinessStageId.change_apply:
  745. otherChangeList = await ctx.service.changeApply.getListByStatus(tenderId, 0, 0, 0, 0, state);
  746. otherHintName = '变更申请';
  747. break;
  748. default:
  749. break;
  750. }
  751. otherChangeList = otherChangeList.filter(x => { return x.id != bglObj.BUSINESS_ID; });
  752. let archiveList = [];
  753. const archives = await ctx.service.rptArchive.getArchiveByBzId(pid, stage_id, bglObj.BUSINESS_ID);
  754. if (archives.length > 0) {
  755. archiveList = JSON.parse(archives[0].content);
  756. }
  757. let prjAccList = await ctx.service.projectAccount.getAllAccountByProjectId(pid);
  758. prjAccList = prjAccList.filter(pa => pa.enable !== 0);
  759. const roleList = [];
  760. const usedList = await ctx.service.signatureUsed.getSignatureUsedByTenderId(tenderId);
  761. // 根据需求,如果开启了‘开启个人「签字」’功能,则只能是本身用户签名,管理员例外
  762. if (!ctx.session.sessionUser.is_admin && pageShow.individualSign === 1) {
  763. // 削减其他account
  764. const newAccList = [];
  765. for (const acc of prjAccList) {
  766. if (acc.id === this.ctx.session.sessionUser.accountId) {
  767. newAccList.push(acc);
  768. }
  769. }
  770. prjAccList = newAccList;
  771. }
  772. // 分类列表
  773. const categoryData = await this.ctx.service.category.getAllCategory(ctx.subProject);
  774. // 获取用户权限
  775. const accountInfo = await this.ctx.service.projectAccount.getDataById(this.ctx.session.sessionUser.accountId);
  776. // const userPermission = accountInfo !== undefined && accountInfo.permission !== '' ? JSON.parse(accountInfo.permission) : null;
  777. // 获取用户可查看的标段
  778. // ...
  779. const tenderList = [];
  780. const cid = this.ctx.helper._.map(treeNodes, 'id');
  781. const customSelects = null;
  782. const dataSelects = {};
  783. dataSelects.material_select = await ctx.service.rptCustomDefine.getDataSelectByRpt(cid,
  784. reportConst.rptDataType[JV.NODE_CUS_MATERIAL_SELECT]);
  785. const materialList = await ctx.service.material.getValidMaterials();
  786. const stage_order = -1;
  787. const sorder = -1;
  788. const stage_times = -1;
  789. const stage_status = -1;
  790. for (const prjAcc of prjAccList) {
  791. // prjAcc.account_group = accountGroup[prjAcc.account_group];
  792. prjAcc.account_group = prjAcc.company;
  793. }
  794. const cust_select_keys = JSON.stringify(['common', 'customize']); // 因其他地方也有可能保存用户报表的显示选择项,因当初设计问题,不好改数据库结构了,但可以调节内部json来满足需求
  795. const rpt_tpl_items = { customize: [], common: [] };
  796. if (treeNodes && treeNodes.length > 0) {
  797. for (let tIdx = treeNodes.length - 1; tIdx >= 0; tIdx--) {
  798. if (treeNodes[tIdx].name === '通用报表') {
  799. const items = JSON.parse(treeNodes[tIdx].items);
  800. for (let itemIdx = items.length - 1; itemIdx >= 0; itemIdx--) {
  801. rpt_tpl_items.common.push(items[itemIdx].name);
  802. }
  803. } else {
  804. rpt_tpl_items.customize.push(treeNodes[tIdx].name);
  805. }
  806. }
  807. }
  808. // 获取所有项目参与者
  809. const { accountList, newAccountGroup, advance } = await this._getInvolveAcc(ctx, tenderId);
  810. const renderData = {
  811. accountGroup: newAccountGroup,
  812. accountList,
  813. unitList: JSON.stringify(unitList),
  814. tender: null,
  815. tenderInfo: null,
  816. rpt_tpl_data: JSON.stringify(treeNodes),
  817. cust_tpl_data: JSON.stringify(rpt_tpl_items),
  818. all_common_tpl_data: JSON.stringify([]),
  819. all_indivi_tpl_data: JSON.stringify([]),
  820. cust_select_keys,
  821. cust_cfg: JSON.stringify(custCfg),
  822. project_id: pid,
  823. tender_id: tenderId,
  824. budget_id,
  825. sp_id,
  826. tender_name: ctx.tender.data.name,
  827. detail_id: paymentDetail_id,
  828. stg_id: stage_id,
  829. stg_order: stage_order,
  830. cur_order: sorder,
  831. stg_times: stage_times,
  832. stg_status: stage_status,
  833. stage_list: JSON.stringify(stageList),
  834. prj_account_list: JSON.stringify(prjAccList),
  835. role_list: JSON.stringify(roleList),
  836. used_list: JSON.stringify(usedList),
  837. tenderMenu,
  838. preUrl: '/tender/' + tenderId + '/measure/stage/' + ctx.params.order,
  839. measureType,
  840. categoryData,
  841. tenderList,
  842. auditConst: auditConst.stage,
  843. ledgerAuditConst: auditConst.ledger,
  844. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.report.main),
  845. customSelects,
  846. rptCustomType: reportConst.rptCustomType,
  847. advanceList: JSON.stringify([]),
  848. advanceAuditList: JSON.stringify([]),
  849. materialAdjList: JSON.stringify(materialList),
  850. materialAdjAuditList: JSON.stringify([]),
  851. materialList,
  852. stages: stageList,
  853. dataSelects,
  854. pageShow,
  855. authMobile: accountInfo.auth_mobile,
  856. shenpiConst,
  857. archiveList,
  858. lastAuditor,
  859. rpt_id: ctx.query.rpt_id,
  860. isAdmin,
  861. prePay: JSON.stringify(advance),
  862. OSS_PATH: ctx.app.config.fujianOssPath,
  863. viewPmData: PermissionCheck.viewPmData(this.ctx.session.sessionUser.permission),
  864. source_type,
  865. bglObj: JSON.stringify(bglObj),
  866. changes: JSON.stringify(changes),
  867. otherChangeList: JSON.stringify(otherChangeList || []),
  868. otherHintName,
  869. bizId: bglObj.BUSINESS_ID,
  870. };
  871. await this.layout('report/index.ejs', renderData, 'report/rpt_all_popup.ejs');
  872. } catch (err) {
  873. this.log(err);
  874. }
  875. }
  876. async indexForChange(ctx) {
  877. // 变更令报表入口
  878. await this._indexForBGL(ctx, sourceTypeConst.sourceType.change, -300);
  879. }
  880. async indexForChangePlan(ctx) {
  881. // 变更方案报表入口
  882. await this._indexForBGL(ctx, sourceTypeConst.sourceType.change_plan, -301);
  883. }
  884. async indexForChangeProject(ctx) {
  885. // 变更立项报表入口
  886. await this._indexForBGL(ctx, sourceTypeConst.sourceType.change_project, -302);
  887. }
  888. async indexForChangeApply(ctx) {
  889. // 变更申请报表入口
  890. await this._indexForBGL(ctx, sourceTypeConst.sourceType.change_apply, -303);
  891. }
  892. /**
  893. * 报表打印页面
  894. *
  895. * @param {Object} ctx - egg全局context
  896. * @return {void}
  897. */
  898. async showPrintPage(ctx) {
  899. try {
  900. // const params = JSON.parse(ctx.request.body.params);
  901. const pageSize = ctx.params.size;
  902. // console.log('pageSize: ' + pageSize);
  903. const renderData = {
  904. size: pageSize,
  905. // orientation: params.orientation,
  906. };
  907. await ctx.render('report/rpt_print.ejs', renderData);
  908. } catch (err) {
  909. this.log(err);
  910. console.log(err);
  911. }
  912. }
  913. async showIndividualPage(ctx) {
  914. try {
  915. // const params = JSON.parse(ctx.request.body.params);
  916. const pageSize = ctx.params.size;
  917. // console.log('pageSize: ' + pageSize);
  918. const renderData = {
  919. size: pageSize,
  920. OSS_PATH: ctx.app.config.fujianOssPath,
  921. // orientation: params.orientation,
  922. };
  923. await ctx.render('report/rpt_individual.ejs', renderData);
  924. } catch (err) {
  925. this.log(err);
  926. console.log(err);
  927. }
  928. }
  929. _mergeBlankRoleSignDate(roleRel, auditors) {
  930. // 有些签名信息的sign_date是空白的(从前一业务copy过来并清理),需要根据审核信息来自动填写上审核时间
  931. // 1. 用户ID 2. sign_date为空白
  932. if (roleRel && auditors) {
  933. roleRel.forEach(record => {
  934. const contents = JSON.parse(record.rel_content);
  935. let hasMerge = false;
  936. contents.forEach(role => {
  937. if (!role.sign_date || role.sign_date === '') {
  938. auditors.forEach(audit => {
  939. if (audit.aid === role.acc_id) {
  940. role.sign_date = audit.end_time;
  941. hasMerge = true;
  942. }
  943. });
  944. }
  945. });
  946. if (hasMerge) {
  947. record.rel_content = JSON.stringify(contents);
  948. }
  949. });
  950. }
  951. }
  952. async _commonGetAudit(ctx, params, stgAudit, stageFlow) {
  953. const COMMON_INVALID_STATUS_FOR_ORG = [1, 6]; // 对原报来说,待上报、重新上报状态就不能默认为审核通过
  954. switch (params.stage_id) {
  955. case -300: // 变更令
  956. const changeAudit = await ctx.service.changeAudit.getAuditors(params.change_id, params.change_times, 'asc', true);
  957. const change = await ctx.service.change.getChangeByCid(params.change_id);
  958. let orgChangeStatus = 3;
  959. if ([1, 9].includes(change.status)) orgChangeStatus = 1; // 原报只要已上报(非1、9),status都是3
  960. stgAudit.push({ aid: change.uid, status: orgChangeStatus, opinion: '', end_time: change.in_time, order: 0 }); // 加上原报
  961. changeAudit.forEach(audit => {
  962. stgAudit.push({ aid: audit.uid, status: audit.status, opinion: audit.sdesc, end_time: audit.sin_time, order: audit.usite });
  963. // 创建dummy stageFlow
  964. stageFlow.push({ aid: audit.uid || audit.aid, audit_type: audit.audit_type, status: audit.status, order: audit.audit_order });
  965. });
  966. break;
  967. case -301: // 变更方案
  968. const changePlanAudit = await ctx.service.changePlanAudit.getAuditors(params.business_id, params.change_plan_times, 'asc', true);
  969. const change_plan = await ctx.service.changePlan.getDataById(params.business_id);
  970. let orgChangePlanStatus = 3;
  971. if ([1, 9].includes(change_plan.status)) orgChangePlanStatus = 1; // 原报只要已上报(非1、9),status都是3
  972. stgAudit.push({ aid: change_plan.uid, status: orgChangePlanStatus, opinion: '', end_time: change_plan.in_time, order: 0 }); // 加上原报
  973. changePlanAudit.forEach(audit => {
  974. if (audit.order === 1) {
  975. stgAudit[0].end_time = audit.begin_time || stgAudit[0].end_time; // 如果没有begin_time,则保留时间
  976. }
  977. stgAudit.push({ aid: audit.aid, status: audit.status, opinion: audit.opinion, end_time: audit.end_time, times: audit.times, order: audit.order });
  978. // 创建dummy stageFlow
  979. stageFlow.push({ aid: audit.uid || audit.aid, audit_type: audit.audit_type, status: audit.status, order: audit.audit_order });
  980. });
  981. break;
  982. case -302: // 变更立项
  983. const changeProjectAudit = await ctx.service.changeProjectAudit.getAuditors(params.business_id, params.change_project_times, 'asc', true);
  984. const change_project = await ctx.service.changeProject.getDataById(params.business_id);
  985. let orgChangePrjStatus = 3;
  986. if ([1, 9].includes(change_project.status)) orgChangePrjStatus = 1; // 原报只要已上报(非1、9),status都是3
  987. stgAudit.push({ aid: change_project.uid, status: orgChangePrjStatus, opinion: '', end_time: change_project.in_time, order: 0 }); // 加上原报
  988. changeProjectAudit.forEach(audit => {
  989. if (audit.order === 1) {
  990. stgAudit[0].end_time = audit.begin_time || stgAudit[0].end_time; // 如果没有begin_time,则保留时间
  991. }
  992. stgAudit.push({ aid: audit.aid, status: audit.status, opinion: audit.opinion, end_time: audit.end_time, times: audit.times, order: audit.order });
  993. // 创建dummy stageFlow
  994. stageFlow.push({ aid: audit.uid || audit.aid, audit_type: audit.audit_type, status: audit.status, order: audit.audit_order });
  995. });
  996. break;
  997. case -303: // 变更申请
  998. const changeApplyAudit = await ctx.service.changeApplyAudit.getAuditors(params.business_id, params.change_apply_times, 'asc', true);
  999. const change_apply = await ctx.service.changeApply.getDataById(params.business_id);
  1000. let orgChangeApplyStatus = 3;
  1001. if ([1, 9].includes(change_apply.status)) orgChangeApplyStatus = 1; // 原报只要已上报(非1、9),status都是3
  1002. stgAudit.push({ aid: change_apply.uid, status: orgChangeApplyStatus, opinion: '', end_time: change_apply.in_time, order: 0 }); // 加上原报
  1003. changeApplyAudit.forEach(audit => {
  1004. if (audit.order === 1) {
  1005. stgAudit[0].end_time = audit.begin_time || stgAudit[0].end_time; // 如果没有begin_time,则保留时间
  1006. }
  1007. stgAudit.push({ aid: audit.aid, status: audit.status, opinion: audit.opinion, end_time: audit.end_time, times: audit.times, order: audit.order });
  1008. // 创建dummy stageFlow
  1009. stageFlow.push({ aid: audit.uid || audit.aid, audit_type: audit.audit_type, status: audit.status, order: audit.audit_order });
  1010. });
  1011. break;
  1012. case -400: // 预付款
  1013. const advanceList = await ctx.service.advance.getAdvanceListDirectly(params.tender_id);
  1014. for (const advance of advanceList) {
  1015. if (advance.id === params.advance_id) {
  1016. stgAudit.push({ aid: advance.uid, status: 3, opinion: '同意', end_time: advance.create_time || (new Date()), order: 0 }); // 加上原报,默认status为3
  1017. if (COMMON_INVALID_STATUS_FOR_ORG.includes(advance.status)) stgAudit[0].status = advance.status;
  1018. break;
  1019. }
  1020. }
  1021. const advanceAuditList = await ctx.service.advanceAudit.getAuditAdvanceByTender(params.tender_id);
  1022. // let maxTimes = -1;
  1023. advanceAuditList.forEach(advAudit => {
  1024. if (advAudit.vid === params.advance_id) {
  1025. stgAudit.push({ aid: advAudit.audit_id, status: advAudit.status, opinion: advAudit.opinion || '同意', end_time: advAudit.end_time || (new Date()), times: advAudit.times, order: advAudit.order });
  1026. }
  1027. });
  1028. break;
  1029. case -500: // 材差
  1030. const materialList = await ctx.service.material.getValidMaterials(params.tender_id);
  1031. for (const material of materialList) {
  1032. if (material.id === params.material_id) {
  1033. stgAudit.push({ aid: material.user_id, status: 3, opinion: '同意', end_time: material.in_time, order: 0 }); // 加上原报,默认status为3
  1034. if (COMMON_INVALID_STATUS_FOR_ORG.includes(material.status)) stgAudit[0].status = material.status;
  1035. break;
  1036. }
  1037. }
  1038. const materialAdjAuditList = await ctx.service.materialAudit.getAuditorsByTender(params.tender_id);
  1039. let maxTimes = -1;
  1040. // let orgTime = null;
  1041. materialAdjAuditList.forEach(material => {
  1042. if (material.mid === params.material_id) {
  1043. if (material.times > maxTimes) {
  1044. maxTimes = material.times;
  1045. if (material.order === 1) {
  1046. // orgTime = material.begin_time;
  1047. stgAudit[0].end_time = material.begin_time || stgAudit[0].end_time; // 如果是待上报,没有begin_time,则保留时间
  1048. }
  1049. }
  1050. }
  1051. });
  1052. materialAdjAuditList.forEach(material => {
  1053. if (material.mid === params.material_id) {
  1054. stgAudit.push({ aid: material.aid, status: material.status, opinion: material.opinion, end_time: material.end_time, order: material.order }); // 加上原报
  1055. }
  1056. });
  1057. break;
  1058. default:
  1059. break;
  1060. }
  1061. }
  1062. async _getReport(ctx, params) {
  1063. // console.log('in getReport');
  1064. // console.log(params);
  1065. let rptTpl = await ctx.service.rptTpl.getTplById(params.rpt_tpl_id);
  1066. if (!rptTpl || rptTpl.length !== 1) {
  1067. throw '获取模板失败';
  1068. }
  1069. const source_type = rptTpl[0].source_type;
  1070. rptTpl = JSON.parse(rptTpl[0].rpt_content);
  1071. rptTpl.source_type = source_type || params.source_type || sourceTypeConst.defaultSourceType;
  1072. rptTpl.id = params.rpt_tpl_id;
  1073. // console.log('get the template!');
  1074. const customSelect = rptTpl[JV.NODE_CUSTOM_DEFINE] && rptTpl[JV.NODE_CUSTOM_DEFINE][JV.NODE_CUS_AUDIT_SELECT].enable
  1075. ? await ctx.service.rptCustomDefine.getCustomDefine(params.tender_id, params.stage_id, params.rpt_tpl_id)
  1076. : await ctx.service.rptCustomDefine.getCustomDefine(params.tender_id, -1, params.rpt_tpl_id);
  1077. let copyCustomSelect = this.ctx.helper.clone(customSelect);
  1078. if (!params.gather_select && copyCustomSelect) delete copyCustomSelect.gather_select;
  1079. if (!params.stage_select && copyCustomSelect) delete copyCustomSelect.stage_select;
  1080. if (!params.material_sum_select && copyCustomSelect) delete copyCustomSelect.material_sum_select;
  1081. if (params.change_select) {
  1082. copyCustomSelect = { tid: params.tender_id, rid: params.rpt_tpl_id, sid: -1, change_select: params.change_select };
  1083. }
  1084. const pageRst = await ctx.service.jpcReport.getAllPagesCommon(ctx, rptTpl, params, JV.PAGING_OPTION_NORMAL, JV.OUTPUT_TYPE_NORMAL, this.app.baseDir, copyCustomSelect);
  1085. for (const page of pageRst.items) {
  1086. page[JV.PROP_WATERMARK_CELLS] = [];
  1087. }
  1088. let waterMarkStr = null;
  1089. if (params.stage_status !== 3 && params.closeWatermark === 0) {
  1090. // 加水印
  1091. fillWaterMark([pageRst]);
  1092. if (params.needWaterMark) {
  1093. waterMarkStr = await getWatermarkPicData(pageRst, this.app.baseDir);
  1094. }
  1095. }
  1096. // console.log(pageRst);
  1097. const roleRel = await ctx.service.roleRptRel.getRoleRptRelByDetailIds(params.tender_id, params.rpt_tpl_id, params.stage_id, params.business_id); // 新需求中,允许在非审核状态下设置签名
  1098. let stgAudit = null,
  1099. stgAuditForOrg = null,
  1100. stageFlow = null,
  1101. stageList = [],
  1102. ledger = [];
  1103. if (params.stage_id > 0) {
  1104. stgAudit = await ctx.service.stageAudit.getStageAudit(params.stage_id, params.stage_times);
  1105. stgAuditForOrg = await ctx.service.stageAudit.getStageAudit(params.stage_id, 1);
  1106. stageList = await ctx.service.stage.getValidStagesShort(params.tender_id);
  1107. stageFlow = await ctx.service.stageAudit.getAuditGroupByListWithOwner(params.stage_id, params.stage_times);
  1108. ledger = await ctx.service.ledger.getDataOnlyByNodeId(params.tender_id);
  1109. } else if ([-100, -200].includes(params.stage_id)) {
  1110. stgAudit = await ctx.service.paymentDetailAudit.getAuditors(params.detail_id, params.stage_times);
  1111. stgAuditForOrg = await ctx.service.paymentDetailAudit.getAuditors(params.detail_id, 1);
  1112. stageFlow = await ctx.service.paymentDetailAudit.getAuditorsWithOwner(params.detail_id);
  1113. const paymentDetailList = await ctx.service.paymentDetail.getDetail(params.detail_id);
  1114. if (paymentDetailList && paymentDetailList.length > 0) {
  1115. const payment = paymentDetailList[0];
  1116. stageList.push({ id: params.stage_id, user_id: payment.uid, status: payment.status });
  1117. }
  1118. } else if ([-300, -301, -302, -303, -400, -500].includes(params.stage_id)) {
  1119. // 变更令、预付款、材差相关的
  1120. stgAudit = [];
  1121. stgAuditForOrg = [];
  1122. stageFlow = [];
  1123. await this._commonGetAudit(ctx, params, stgAudit, stageFlow);
  1124. stgAudit.sort(function(stg1, stg2) {
  1125. return stg1.order - stg2.order;
  1126. });
  1127. this._mergeBlankRoleSignDate(roleRel, stgAudit);
  1128. }
  1129. if (stageFlow) {
  1130. stageFlow.forEach(x => {
  1131. if (!x) return;
  1132. x.visible = (!ctx.session.sessionUser.is_admin && ctx.session.sessionProject.page_show.individualSign === 1)
  1133. ? x.aid === ctx.session.sessionUser.accountId : true;
  1134. });
  1135. }
  1136. mergeStampSignature(ctx, params.stage_status, pageRst, roleRel[0], null, stgAudit, stageList);
  1137. mergeTextSignature(params.isTextSignature, params.stage_status, pageRst, roleRel[0], [], stgAudit, stageList);
  1138. await encodeSignatureDataUri(roleRel, this.app.baseDir);
  1139. if (params.getPicFlag) {
  1140. await encodeDummySignatureDataUri(pageRst, this.app.baseDir); // 注意草图数据量问题!
  1141. }
  1142. // console.log('encodeSignatureDataUri!');
  1143. // fsUtil.writeObjToFile(pageRst, 'D:/GitHome/Temp/testBuiltPageResult2.js');
  1144. return {
  1145. data: pageRst,
  1146. signatureRelInfo: roleRel,
  1147. stageAudit: stgAudit,
  1148. stageAuditOrg: stgAuditForOrg,
  1149. debugInfo: ctx.session.sessionUser.loginStatus ? ctx.debugInfo : null,
  1150. customDefine: rptTpl[JV.NODE_CUSTOM_DEFINE],
  1151. stageFlow,
  1152. ledger,
  1153. customSelect,
  1154. waterMarkStr,
  1155. };
  1156. }
  1157. /**
  1158. * 获取报表数据
  1159. *
  1160. * @param {Object} ctx - egg全局context
  1161. * @return {void}
  1162. */
  1163. async getReport(ctx) {
  1164. try {
  1165. // console.log('in getReport');
  1166. const params = JSON.parse(ctx.request.body.params);
  1167. ctx.body = await this._getReport(ctx, params);
  1168. ctx.status = 201;
  1169. } catch (ex) {
  1170. console.log(ex);
  1171. this.setMessage(ex.toString(), this.messageType.ERROR);
  1172. }
  1173. }
  1174. async getTestReport(ctx) {
  1175. try {
  1176. const file = 'D:/GitHome/Temp/导出PDF_格式样本1.js';
  1177. const tplObj = JSON.parse(fs.readFileSync(file, 'utf-8'));
  1178. ctx.body = { data: tplObj };
  1179. ctx.status = 201;
  1180. } catch (ex) {
  1181. this.setMessage(ex.toString(), this.messageType.ERROR);
  1182. }
  1183. }
  1184. /**
  1185. * 获取多批次报表数据
  1186. *
  1187. * @param {Object} ctx - egg全局context
  1188. * @return {void}
  1189. */
  1190. async getMultiReportsEx(ctx) {
  1191. // 原则说明:把所有报表模板集中获取,统一filter,只读一次数据!
  1192. const params = JSON.parse(ctx.request.body.params);
  1193. const pageShow = ctx.session.sessionProject.page_show;
  1194. if (pageShow !== null
  1195. && pageShow !== undefined
  1196. && params.outputType
  1197. && ((params.outputType === 'PDF' && parseInt(pageShow.closeExportPdf) === 1)
  1198. || (params.outputType === 'Excel' && parseInt(pageShow.closeExportExcel) === 1)
  1199. )
  1200. ) {
  1201. ctx.body = { data: [], signatureRelInfo: [], stageAudit: [] };
  1202. ctx.status = 201;
  1203. return;
  1204. }
  1205. if (params.stage_id > 0) {
  1206. await this._saveCustomSelects(params);
  1207. }
  1208. // const pageRstArr = await getMultiRptsCommon(ctx, params, JV.OUTPUT_TYPE_NORMAL, this.app.baseDir) || [];
  1209. const pageRstArr = await ctx.service.jpcReport.getMultiRptsCommon(ctx, params, JV.OUTPUT_TYPE_NORMAL, this.app.baseDir) || [];
  1210. for (const pageRst of pageRstArr) {
  1211. for (const page of pageRst.items) {
  1212. page[JV.PROP_WATERMARK_CELLS] = [];
  1213. }
  1214. }
  1215. let waterMarkStr = null;
  1216. if (params.stage_status !== 3 && params.closeWatermark === 0) {
  1217. // 加水印
  1218. fillWaterMark(pageRstArr);
  1219. if (params.needWaterMark) {
  1220. waterMarkStr = await getWatermarkPicData(pageRstArr[0], this.app.baseDir);
  1221. }
  1222. }
  1223. const roleRel = await ctx.service.roleRptRel.getRoleRptRelByDetailIds(params.tender_id, params.rpt_ids, params.stage_id, params.business_id); // 新需求:在审批流程中的签名需要显示
  1224. supplementRoles(params.rpt_ids, roleRel);
  1225. roleRel.sort(function(rr1, rr2) {
  1226. return params.rpt_ids.indexOf(parseInt(rr1.rpt_id)) - params.rpt_ids.indexOf(parseInt(rr2.rpt_id));
  1227. });
  1228. let stgAudit = null,
  1229. stageFlow = null,
  1230. stageList = [],
  1231. ledger = [];
  1232. if (params.stage_id > 0) {
  1233. stgAudit = await ctx.service.stageAudit.getStageAudit(params.stage_id, params.stage_times);
  1234. stageList = await ctx.service.stage.getValidStagesShort(params.tender_id);
  1235. stageFlow = await ctx.service.stageAudit.getAuditGroupByListWithOwner(params.stage_id, params.stage_times);
  1236. ledger = await ctx.service.ledger.getDataOnlyByNodeId(params.tender_id);
  1237. } else if ([-100, -200].includes(params.stage_id)) {
  1238. stgAudit = await ctx.service.paymentDetailAudit.getAuditors(params.detail_id);
  1239. stageFlow = await ctx.service.paymentDetailAudit.getAuditorsWithOwner(params.detail_id);
  1240. const paymentDetailList = await ctx.service.paymentDetail.getDetail(params.detail_id);
  1241. if (paymentDetailList && paymentDetailList.length > 0) {
  1242. const payment = paymentDetailList[0];
  1243. stageList.push({ id: params.stage_id, user_id: payment.uid, status: payment.status });
  1244. }
  1245. } else if ([-300, -301, -302, -303, -400, -500].includes(params.stage_id)) {
  1246. stgAudit = [];
  1247. stageFlow = [];
  1248. await this._commonGetAudit(ctx, params, stgAudit, stageFlow);
  1249. this._mergeBlankRoleSignDate(roleRel, stgAudit);
  1250. } else if ([-400, -500].includes(params.stage_id)) {
  1251. stgAudit = [];
  1252. }
  1253. mergeStampSignature(ctx, params.stage_status, pageRstArr, roleRel, params.rpt_ids, stgAudit, stageList);
  1254. mergeTextSignature(params.isTextSignature, params.stage_status, pageRstArr, roleRel, params.rpt_ids, stgAudit, stageList, !!params.closeArchiveSignature, !!params.isArchive);
  1255. await encodeSignatureDataUri(roleRel, this.app.baseDir);
  1256. if (params.getPicFlag) {
  1257. for (const pageRst of pageRstArr) {
  1258. await encodeDummySignatureDataUri(pageRst, this.app.baseDir); // 注意草图数据量问题!
  1259. }
  1260. }
  1261. // console.log(pageRstArr);
  1262. ctx.body = { data: pageRstArr, signatureRelInfo: roleRel, stageAudit: stgAudit, stageFlow, waterMarkStr, ledger };
  1263. ctx.status = 201;
  1264. }
  1265. async _saveCustomSelects(params) {
  1266. for (const [i, cs] of params.customSelect.entries()) {
  1267. if (!cs) continue;
  1268. cs.tender_id = params.tender_id;
  1269. cs.stage_id = params.stage_id;
  1270. cs.rpt_tpl_id = params.rpt_ids[i];
  1271. await this.ctx.service.rptCustomDefine.saveCustomSelect(cs);
  1272. }
  1273. }
  1274. async createExcelFilesEx(ctx) {
  1275. const params = JSON.parse(ctx.request.body.params);
  1276. const pageShow = ctx.session.sessionProject.page_show;
  1277. if (pageShow !== null && pageShow !== undefined && parseInt(pageShow.closeExportExcel) === 1) {
  1278. ctx.body = { data: [] };
  1279. ctx.status = 201;
  1280. return;
  1281. }
  1282. await this._saveCustomSelects(params);
  1283. const baseDir = this.app.baseDir;
  1284. function getExcelByPageData(pageRst, rpt_name, innerRoleRel) {
  1285. return new Promise(function(resolve, reject) {
  1286. rpt_xl_util.exportExcel(pageRst, params.pageSize, rpt_name, params.isOneSheet, null, null, baseDir, innerRoleRel,
  1287. (err, uuidName) => {
  1288. if (err) return reject(err);
  1289. const fileRst = { uuid: uuidName, reportName: rpt_name.replace(new RegExp('%', 'gm'), '_') };
  1290. resolve(fileRst);
  1291. }
  1292. );
  1293. });
  1294. }
  1295. // const stgAudit = (params.stage_status === 3) ? (await ctx.service.stageAudit.getStageAudit(params.stage_id, params.stage_times)) : [];
  1296. const stgAudit = await ctx.service.stageAudit.getStageAudit(params.stage_id, params.stage_times);
  1297. const stgAuditForOrg = (params.stage_status === 3) ? (await ctx.service.stageAudit.getStageAudit(params.stage_id, 1)) : [];
  1298. // const stageList = (params.stage_status === 3) ? (await ctx.service.stage.getValidStagesShort(params.tender_id)) : [];
  1299. const stageList = await ctx.service.stage.getValidStagesShort(params.tender_id);
  1300. const roleRelArr = (params.stage_status === 3) ? (await ctx.service.roleRptRel.getRoleRptRelByDetailIds(params.tender_id, params.rpt_ids, params.stage_id, params.business_id)) : [];
  1301. const pageRstArr = await ctx.service.jpcReport.getMultiRptsCommon(ctx, params, JV.OUTPUT_TYPE_NORMAL, baseDir);
  1302. // console.log('params.stage_status: ' + params.stage_status);
  1303. // fsUtil.writeObjToFile(pageRstArr, 'D:/GitHome/temp/testBuiltPageResult1.js');
  1304. for (const pageRst of pageRstArr) {
  1305. for (const page of pageRst.items) {
  1306. page[JV.PROP_WATERMARK_CELLS] = [];
  1307. }
  1308. }
  1309. let waterMarkStr = null;
  1310. if (params.stage_status !== 3 && params.closeWatermark === 0) {
  1311. // if (params.stage_status !== 3 && params.closeWatermark === 0 && params.option === JV.PAGING_OPTION_NORMAL) {
  1312. // 加水印(注意:还得看用户设置是否需要加水印)
  1313. fillWaterMark(pageRstArr);
  1314. if (params.needWaterMark) {
  1315. waterMarkStr = await getWatermarkPicData(pageRstArr[0], baseDir);
  1316. }
  1317. }
  1318. mergeStampSignature(ctx, params.stage_status, pageRstArr, roleRelArr, params.rpt_ids, stgAudit, stageList);
  1319. mergeTextSignature(params.isTextSignature, params.stage_status, pageRstArr, roleRelArr, params.rpt_ids, stgAudit, stageList);
  1320. await this.ctx.helper.recursiveMkdirSync(baseDir + '/app/public/download');
  1321. const runnableRst = [];
  1322. // 1. merge签名相关信息
  1323. const pageBrkSize = 62914560; // 60M, 1024*1024*6*10
  1324. for (let idx = 0; idx < pageRstArr.length; idx++) {
  1325. let roleRel = null;
  1326. for (const roleR of roleRelArr) {
  1327. if (roleR.rpt_id === params.rpt_ids[idx]) {
  1328. roleRel = JSON.parse(roleR.rel_content);
  1329. break;
  1330. }
  1331. }
  1332. if (params.stage_status === 3) {
  1333. mergeSignAudit(pageRstArr[idx], roleRel, stgAudit);
  1334. mergeSignDate(pageRstArr[idx], params.stage_id, roleRel, stgAudit, stgAuditForOrg, stageList);
  1335. }
  1336. // 2. 判断草图大小是否需要分页
  1337. const picSize = await _chkRawPicSize(pageRstArr[idx], baseDir);
  1338. // const picSize = 262914560; // 测试用,强制分页
  1339. if (picSize > pageBrkSize) {
  1340. // let pageBrkAmt = Math.ceil(picSize / pageBrkSize);
  1341. let pageBrkAmt = Math.floor(pageRstArr[idx].items.length / Math.ceil(picSize / pageBrkSize));
  1342. if (pageBrkAmt < 10) {
  1343. // 不用管
  1344. } else if (pageBrkAmt < 100) {
  1345. pageBrkAmt = Math.floor(pageBrkAmt / 10) * 10;
  1346. } else if (pageBrkAmt < 1000) {
  1347. pageBrkAmt = Math.floor(pageBrkAmt / 100) * 100;
  1348. } else {
  1349. // 暂时不管
  1350. }
  1351. const newRptNames = []; // 这个为导出控制分页用
  1352. const newPageDataRst = _resetPageDataByBreaks([pageRstArr[idx]], pageBrkAmt, [params.rpt_names[idx]], newRptNames);
  1353. for (let dtlIdx = 0; dtlIdx < newPageDataRst.length; dtlIdx++) {
  1354. runnableRst.push(getExcelByPageData(newPageDataRst[dtlIdx], newRptNames[dtlIdx], roleRel));
  1355. }
  1356. } else {
  1357. runnableRst.push(getExcelByPageData(pageRstArr[idx], params.rpt_names[idx], roleRel));
  1358. }
  1359. }
  1360. // */
  1361. // fsUtil.writeObjToFile(pageRstArr, 'D:/GitHome/temp/计量导出pageArr.js');
  1362. const uuidRst = await Promise.all(runnableRst);
  1363. ctx.body = { data: uuidRst, waterMarkStr };
  1364. ctx.status = 201;
  1365. }
  1366. _getExcelByPageData(pageRst, rpt_name, pageSize, baseDir, innerRoleRel) {
  1367. return new Promise(function(resolve, reject) {
  1368. rpt_xl_util.exportExcel(pageRst, pageSize, rpt_name, true, null, null, baseDir, innerRoleRel,
  1369. (err, uuidName) => {
  1370. if (err) return reject(err);
  1371. const fileRst = { uuid: uuidName, reportName: rpt_name.replace(new RegExp('%', 'gm'), '_') };
  1372. resolve(fileRst);
  1373. }
  1374. );
  1375. });
  1376. }
  1377. async createExcelFilesFromDirectData(ctx) {
  1378. const params = JSON.parse(ctx.request.body.params);
  1379. const names = params.rptNames;
  1380. const pageDataArr = params.pageData;
  1381. const runnableRst = [];
  1382. for (let idx = 0; idx < names.length; idx++) {
  1383. runnableRst.push(this._getExcelByPageData(pageDataArr[idx], names[idx], 'A4', this.app.baseDir, null));
  1384. }
  1385. const uuidRst = await Promise.all(runnableRst);
  1386. ctx.body = { data: uuidRst, waterMarkStr: null };
  1387. ctx.status = 201;
  1388. }
  1389. async createExcelFilesFromLocal(ctx) {
  1390. const baseDir = this.app.baseDir;
  1391. function getExcelByPageData(pageRst, rpt_name, innerRoleRel) {
  1392. return new Promise(function(resolve, reject) {
  1393. rpt_xl_util.exportExcel(pageRst, 'A4', rpt_name, true, null, null, baseDir, innerRoleRel,
  1394. (err, uuidName) => {
  1395. if (err) return reject(err);
  1396. const fileRst = { uuid: uuidName, reportName: rpt_name.replace(new RegExp('%', 'gm'), '_') };
  1397. resolve(fileRst);
  1398. }
  1399. );
  1400. });
  1401. }
  1402. try {
  1403. console.log('start:');
  1404. const pageRst = JSON.parse(fs.readFileSync('D:/GitHome/temp/计量excel原始数据_A3BZ6_5384_112表(清单).js', 'utf-8'));
  1405. console.log('read it');
  1406. const runnableRst = [];
  1407. const pageBrkSize = 6291456; // 6M, 1024*1024*6
  1408. // const pageBrkSize = 1048576; // 1M, 1024*1024*1
  1409. console.log('pageBrkSize:' + pageBrkSize);
  1410. const picSize = await _chkRawPicSize(pageRst, baseDir);
  1411. console.log('picSize:' + picSize);
  1412. if (picSize > pageBrkSize) {
  1413. let pageBrkAmt = Math.floor(pageRst.items.length / Math.ceil(picSize / pageBrkSize));
  1414. console.log('pageBrkAmt:' + pageBrkAmt);
  1415. if (pageBrkAmt < 10) {
  1416. // 不用管
  1417. } else if (pageBrkAmt < 100) {
  1418. pageBrkAmt = Math.floor(pageBrkAmt / 10) * 10;
  1419. } else if (pageBrkAmt < 1000) {
  1420. pageBrkAmt = Math.floor(pageBrkAmt / 100) * 100;
  1421. } else {
  1422. // 暂时不管
  1423. }
  1424. const newRptNames = []; // 这个为导出控制分页用
  1425. const newPageDataRst = _resetPageDataByBreaks([pageRst], pageBrkAmt, ['工程计量表(计量单元-清单)'], newRptNames);
  1426. for (let dtlIdx = 0; dtlIdx < newPageDataRst.length; dtlIdx++) {
  1427. runnableRst.push(getExcelByPageData(newPageDataRst[dtlIdx], newRptNames[dtlIdx], null));
  1428. }
  1429. } else {
  1430. runnableRst.push(getExcelByPageData(pageRst, '工程计量表(计量单元-清单)', null));
  1431. }
  1432. const uuidRst = await Promise.all(runnableRst);
  1433. ctx.body = { data: uuidRst, waterMarkStr: null };
  1434. ctx.status = 201;
  1435. } catch (ex) {
  1436. console.log(ex.toString());
  1437. ctx.status = 500;
  1438. }
  1439. }
  1440. async createExcelFilesInOneBookEx(ctx) {
  1441. const params = JSON.parse(ctx.request.body.params);
  1442. const baseDir = this.app.baseDir;
  1443. function getExcelByPageData(pageRstArr, rpt_name, innerRoleRel) {
  1444. return new Promise(function(resolve, reject) {
  1445. rpt_xl_util.exportExcelInOneBook(pageRstArr, params.pageSize, rpt_name, baseDir, innerRoleRel,
  1446. (err, uuidName) => {
  1447. if (err) return reject(err);
  1448. const fileRst = { uuid: uuidName, reportName: rpt_name };
  1449. resolve(fileRst);
  1450. }
  1451. );
  1452. });
  1453. }
  1454. const roleRelArr = (params.stage_status === 3) ? (await ctx.service.roleRptRel.getRoleRptRelByDetailIds(params.tender_id, params.rpt_ids, params.stage_id)) : [];
  1455. // console.log(`baseDir: ${baseDir}`);
  1456. // fsUtil.writeObjToFile(roleRelArr, 'D:/GitHome/temp/签名信息.js');
  1457. const stgAudit = await ctx.service.stageAudit.getStageAudit(params.stage_id, params.stage_times);
  1458. const stgAuditForOrg = await ctx.service.stageAudit.getStageAudit(params.stage_id, 1);
  1459. const stageList = await ctx.service.stage.getValidStagesShort(params.tender_id);
  1460. // const pageRstArr = await getMultiRptsCommon(ctx, params, JV.OUTPUT_TYPE_NORMAL, this.app.baseDir);
  1461. const pageRstArr = await ctx.service.jpcReport.getMultiRptsCommon(ctx, params, JV.OUTPUT_TYPE_NORMAL, this.app.baseDir);
  1462. // fsUtil.writeObjToFile(pageRstArr, 'D:/GitHome/temp/pageRstArrForExcel.js');
  1463. for (const pageRst of pageRstArr) {
  1464. for (const page of pageRst.items) {
  1465. page[JV.PROP_WATERMARK_CELLS] = [];
  1466. }
  1467. }
  1468. let waterMarkStr = null;
  1469. if (params.stage_status !== 3 && params.closeWatermark === 0) {
  1470. // if (params.stage_status !== 3 && params.closeWatermark === 0 && params.option === JV.PAGING_OPTION_NORMAL) {
  1471. // 加水印
  1472. fillWaterMark(pageRstArr);
  1473. if (params.needWaterMark) {
  1474. waterMarkStr = await getWatermarkPicData(pageRstArr[0], this.app.baseDir);
  1475. }
  1476. }
  1477. mergeStampSignature(ctx, params.stage_status, pageRstArr, roleRelArr, params.rpt_ids, stgAudit, stageList);
  1478. mergeTextSignature(params.isTextSignature, params.stage_status, pageRstArr, roleRelArr, params.rpt_ids, stgAudit, stageList);
  1479. await this.ctx.helper.recursiveMkdirSync(this.app.baseDir + '/app/public/download');
  1480. const runnableRst = [];
  1481. let rptRoleRelArr = [];
  1482. const reAssignSignatureName = function(pageData, roleRel, rpt_name_key) {
  1483. const keyMap = {};
  1484. for (const pageItem of pageData.items) {
  1485. for (const signCell of pageItem[JV.PROP_SIGNATURE_CELLS]) {
  1486. if (!keyMap.hasOwnProperty(signCell.signature_name)) {
  1487. keyMap[signCell.signature_name] = rpt_name_key + '_' + signCell.signature_name;
  1488. }
  1489. }
  1490. }
  1491. for (const pageItem of pageData.items) {
  1492. for (const signCell of pageItem[JV.PROP_SIGNATURE_CELLS]) {
  1493. if (keyMap.hasOwnProperty(signCell.signature_name)) {
  1494. signCell.signature_name = keyMap[signCell.signature_name];
  1495. }
  1496. }
  1497. }
  1498. for (const roleSign of roleRel) {
  1499. if (keyMap.hasOwnProperty(roleSign.signature_name)) {
  1500. roleSign.signature_name = keyMap[roleSign.signature_name];
  1501. }
  1502. }
  1503. // console.log('keyMap of : ' + rpt_name_key);
  1504. // console.log(keyMap);
  1505. };
  1506. for (let idx = 0; idx < pageRstArr.length; idx++) {
  1507. let roleRel = null;
  1508. for (const roleR of roleRelArr) {
  1509. if (roleR.rpt_id === params.rpt_ids[idx]) {
  1510. roleRel = JSON.parse(roleR.rel_content);
  1511. if (params.stage_status === 3) {
  1512. mergeSignAudit(pageRstArr[idx], roleRel, stgAudit);
  1513. mergeSignDate(pageRstArr[idx], params.stage_id, roleRel, stgAudit, stgAuditForOrg, stageList);
  1514. }
  1515. // 这里要做些电子签名的signature_name转换,以防重名
  1516. reAssignSignatureName(pageRstArr[idx], roleRel, params.rpt_names[idx]);
  1517. rptRoleRelArr = rptRoleRelArr.concat(roleRel);
  1518. break;
  1519. }
  1520. }
  1521. }
  1522. // fsUtil.writeObjToFile(pageRstArr, 'D:/GitHome/temp/pageRstArrForExcelAfterReAssign.js');
  1523. // fsUtil.writeObjToFile(rptRoleRelArr, 'D:/GitHome/temp/签名信息_新.js');
  1524. runnableRst.push(getExcelByPageData(pageRstArr, params.rptName, rptRoleRelArr));
  1525. const uuidRst = await Promise.all(runnableRst);
  1526. ctx.body = { data: uuidRst, waterMarkStr };
  1527. ctx.status = 201;
  1528. }
  1529. async getFileByUUID(ctx) {
  1530. // console.log('downloading : ' + ctx.params.uuid);
  1531. const uuid = ctx.params.uuid;
  1532. const rptName = ctx.params.rptName;
  1533. const suffix = '.' + ctx.params.suffix;
  1534. try {
  1535. const rptNameURI = encodeURI(rptName);
  1536. const filePath = this.app.baseDir + '/app/public/download/';
  1537. // console.log('filePath: ' + filePath);
  1538. // await this.ctx.helper.recursiveMkdirSync(this.app.baseDir + '/app/public/download');
  1539. ctx.set({
  1540. 'Content-Type': 'application/vnd.openxmlformats',
  1541. 'Content-Disposition': 'attachment; filename="' + rptNameURI + suffix + "\"; filename*=utf-8''" + rptNameURI + suffix,
  1542. });
  1543. ctx.body = await fs.readFileSync(filePath + uuid + suffix);
  1544. } catch (e) {
  1545. console.log(e);
  1546. }
  1547. }
  1548. /**
  1549. * 更新用户通用报表显示配置
  1550. *
  1551. * @param {Object} ctx - egg全局context
  1552. * @return {void}
  1553. */
  1554. async updateCustNode(ctx) {
  1555. const params = JSON.parse(ctx.request.body.params);
  1556. // console.log(params);
  1557. const custId = this.ctx.session.sessionUser.accountId;
  1558. const newNodeItems = JSON.stringify(params.nodeItems);
  1559. const rst = await ctx.service.rptTreeNodeCust.updateCustNodeByTenderId(custId, params.tender_id, newNodeItems);
  1560. // console.log(rst);
  1561. ctx.body = { data: rst };
  1562. // ctx.body = { data: { msg: 'test the network' } };
  1563. ctx.status = 201;
  1564. }
  1565. async setCustomDefine(ctx) {
  1566. try {
  1567. const data = JSON.parse(ctx.request.body.data);
  1568. await this.ctx.service.rptCustomDefine.saveCustomSelect(data);
  1569. const result = await this._getReport(ctx, data);
  1570. ctx.body = { err: 0, msg: '', data: result };
  1571. } catch (err) {
  1572. ctx.helper.log(err);
  1573. ctx.body = this.ajaxErrorBody(err, '保存数据出错');
  1574. }
  1575. }
  1576. }
  1577. return ReportController;
  1578. };
  1579. function isFileExisted(file) {
  1580. return new Promise(function(resolve, reject) {
  1581. fs.access(file, err => {
  1582. if (err) {
  1583. reject(false);
  1584. } else {
  1585. resolve(true);
  1586. }
  1587. });
  1588. });
  1589. }
  1590. function fillWaterMark(pageRstArray) {
  1591. const orgWaterMarkWidth = 600;
  1592. const orgWaterMarkHeight = 288;
  1593. const createWaterCell = function(area) {
  1594. const w = area[JV.PROP_RIGHT] - area[JV.PROP_LEFT];
  1595. const h = area[JV.PROP_BOTTOM] - area[JV.PROP_TOP];
  1596. const left = Math.round(area[JV.PROP_LEFT] + w / 2 - orgWaterMarkWidth / 2);
  1597. const right = left + orgWaterMarkWidth;
  1598. const top = Math.round(area[JV.PROP_TOP] + h / 2 - orgWaterMarkHeight / 2);
  1599. const bottom = top + orgWaterMarkHeight;
  1600. return {
  1601. signature_name: JV.SIGNATURE_NAME_DUMMY_WATER_MARK,
  1602. path: '/public/images/not_Approve.png',
  1603. sign_path: '/public/images/not_Approve.png',
  1604. pic: null,
  1605. control: 'Title',
  1606. style: 'Default_None',
  1607. area: {
  1608. Left: left,
  1609. Right: right,
  1610. Top: top,
  1611. Bottom: bottom,
  1612. },
  1613. };
  1614. };
  1615. for (const pageRst of pageRstArray) {
  1616. for (const page of pageRst.items) {
  1617. page[JV.PROP_WATERMARK_CELLS] = [];
  1618. if (page[JV.PROP_PAGE_MERGE_BORDER]) {
  1619. const wmCell = createWaterCell(page[JV.PROP_PAGE_MERGE_BORDER]);
  1620. page[JV.PROP_WATERMARK_CELLS].push(wmCell);
  1621. } else if (page[JV.PAGE_SPECIAL_MERGE_POS]) {
  1622. if (page[JV.PAGE_SPECIAL_MERGE_POS][JV.PROP_LEFT]) {
  1623. for (let i = 0; i < page[JV.PAGE_SPECIAL_MERGE_POS][JV.PROP_LEFT].length; i++) {
  1624. const area = {};
  1625. area[JV.PROP_LEFT] = page[JV.PAGE_SPECIAL_MERGE_POS][JV.PROP_LEFT][i];
  1626. area[JV.PROP_RIGHT] = page[JV.PAGE_SPECIAL_MERGE_POS][JV.PROP_RIGHT][i];
  1627. area[JV.PROP_TOP] = page[JV.PAGE_SPECIAL_MERGE_POS][JV.PROP_TOP][i];
  1628. area[JV.PROP_BOTTOM] = page[JV.PAGE_SPECIAL_MERGE_POS][JV.PROP_BOTTOM][i];
  1629. const wmCell = createWaterCell(area);
  1630. page[JV.PROP_WATERMARK_CELLS].push(wmCell);
  1631. }
  1632. }
  1633. }
  1634. }
  1635. }
  1636. }
  1637. async function encodeSignatureDataUri(roleRel, baseDir) {
  1638. if (roleRel) {
  1639. const _setImage = async role => {
  1640. if (role.sign_path !== '') {
  1641. const filePath = baseDir + '/app' + role.sign_path;
  1642. try {
  1643. const res = await isFileExisted(filePath);
  1644. if (res) {
  1645. const bData = fs.readFileSync(filePath);
  1646. const base64Str = bData.toString('base64');
  1647. const datauri = 'data:image/png;base64,' + base64Str;
  1648. role.sign_pic = datauri;
  1649. } else {
  1650. console.log('文件不存在:' + filePath);
  1651. }
  1652. } catch (err) {
  1653. console.error(err);
  1654. }
  1655. }
  1656. };
  1657. for (const singleRoleRel of roleRel) {
  1658. if (singleRoleRel.rel_content !== null && singleRoleRel.rel_content !== undefined && singleRoleRel.rel_content !== '') {
  1659. const roleRelContent = JSON.parse(singleRoleRel.rel_content);
  1660. for (const role of roleRelContent) {
  1661. if (role.type === '流程') {
  1662. for (const flowRole of role.assFlowInfos) {
  1663. await _setImage(flowRole);
  1664. }
  1665. } else await _setImage(role);
  1666. }
  1667. singleRoleRel.rel_content = JSON.stringify(roleRelContent);
  1668. } else {
  1669. singleRoleRel.rel_content = [];
  1670. }
  1671. }
  1672. }
  1673. }
  1674. async function encodeDummySignatureDataUri(pageRst, baseDir) {
  1675. if (pageRst) {
  1676. for (const page of pageRst.items) {
  1677. for (const signature of page[JV.PROP_SIGNATURE_CELLS]) {
  1678. if (signature.signature_name === JV.SIGNATURE_NAME_DUMMY) {
  1679. if (signature.path !== '') {
  1680. const filePath = baseDir + '/app' + signature.path;
  1681. try {
  1682. const res = await isFileExisted(filePath);
  1683. if (res) {
  1684. const bData = fs.readFileSync(filePath);
  1685. const base64Str = bData.toString('base64');
  1686. const datauri = 'data:image/png;base64,' + base64Str;
  1687. signature.pic = datauri;
  1688. signature.path = '';
  1689. } else {
  1690. console.log('文件不存在:' + filePath);
  1691. }
  1692. } catch (err) {
  1693. console.error(err);
  1694. }
  1695. }
  1696. }
  1697. }
  1698. // 考虑优化,水印只需要一张即可,不需要每页都设置
  1699. // for (const signature of page[JV.PROP_WATERMARK_CELLS]) {
  1700. // if (signature.path !== '') {
  1701. // const filePath = baseDir + '/app' + signature.path;
  1702. // try {
  1703. // const res = await isFileExisted(filePath);
  1704. // if (res) {
  1705. // const bData = fs.readFileSync(filePath);
  1706. // const base64Str = bData.toString('base64');
  1707. // const datauri = 'data:image/png;base64,' + base64Str;
  1708. // signature.pic = datauri;
  1709. // signature.path = '';
  1710. // } else {
  1711. // console.log('文件不存在:' + filePath);
  1712. // }
  1713. // } catch (err) {
  1714. // console.error(err);
  1715. // }
  1716. // }
  1717. // }
  1718. }
  1719. }
  1720. }
  1721. async function getWatermarkPicData(pageRst, baseDir) {
  1722. if (pageRst) {
  1723. for (const page of pageRst.items) {
  1724. for (const signature of page[JV.PROP_WATERMARK_CELLS]) {
  1725. if (signature.path !== '') {
  1726. const filePath = baseDir + '/app' + signature.path;
  1727. try {
  1728. const res = await isFileExisted(filePath);
  1729. if (res) {
  1730. const bData = fs.readFileSync(filePath);
  1731. const base64Str = bData.toString('base64');
  1732. return 'data:image/png;base64,' + base64Str;
  1733. }
  1734. } catch (err) {
  1735. console.error(err);
  1736. }
  1737. }
  1738. }
  1739. }
  1740. }
  1741. return '';
  1742. }
  1743. function mergeTextSignature(isTxtSignature, status, pageData, singleRoleRel, rpt_ids, stgAudit, stageList, closeArchiveSignature = false, isArchive = false) {
  1744. // 依据需求,有些用户不需要签名图片,那么从源头上把签名从signature_cells转移到cells下,省得后续 预览、打印、导出PDF、导出EXCEL每个地方都改动
  1745. const _mergeSingle = function(_page, _roleRelList, isDeleteSignCell, checkAudit = false) {
  1746. // console.log(_roleRelList);
  1747. let roleRelContent = [];
  1748. if (_roleRelList && _roleRelList.rel_content !== null && _roleRelList.rel_content !== undefined && _roleRelList.rel_content !== '') {
  1749. roleRelContent = JSON.parse(_roleRelList.rel_content);
  1750. }
  1751. for (const page of _page.items) {
  1752. if (page.signature_cells) {
  1753. const deleteSCellsIdx = [];
  1754. for (let scIdx = 0; scIdx < page.signature_cells.length; scIdx++) {
  1755. const sCell = page.signature_cells[scIdx];
  1756. if (sCell.signature_name !== JV.SIGNATURE_NAME_DUMMY) {
  1757. sCell.Value = ''; // 这里要先清除原有信息
  1758. sCell.path = '';
  1759. sCell.pic = '';
  1760. let needTransferText = true;
  1761. for (const role_rel of roleRelContent) {
  1762. if (sCell.signature_name === role_rel.signature_name) {
  1763. if (!checkAudit || _chkIfAudit(role_rel, stgAudit || [], stageList || [])) {
  1764. sCell.Value = role_rel.user_name; // 只有审核通过了才需要文本签名内容
  1765. if (role_rel.sign_output && role_rel.sign_output.indexOf(NORMAL_SIGN_STR) < 0) {
  1766. // 用户选择不签名,则不迁移
  1767. needTransferText = false;
  1768. }
  1769. break;
  1770. }
  1771. }
  1772. }
  1773. if (needTransferText) {
  1774. const newCell = {
  1775. font: 'Footer',
  1776. control: sCell.control,
  1777. style: sCell.style,
  1778. Value: sCell.Value,
  1779. area: { Left: sCell.area.Left, Right: sCell.area.Right, Top: sCell.area.Top, Bottom: sCell.area.Bottom },
  1780. };
  1781. if (isArchive && closeArchiveSignature) {
  1782. // 如果正在归档 且 归档不显示签名标记为true时,不输出文本签名,但要有这个空格子(边框用)
  1783. newCell.Value = '';
  1784. }
  1785. page.cells.push(newCell); // 迁移
  1786. deleteSCellsIdx.push(scIdx);
  1787. }
  1788. }
  1789. }
  1790. // 删除 page.signature_cells 签名(草图不能删);
  1791. // console.log('isDeleteSignCell: ' + isDeleteSignCell);
  1792. // console.log(deleteSCellsIdx);
  1793. if (isDeleteSignCell) {
  1794. for (let dIdx = deleteSCellsIdx.length - 1; dIdx >= 0; dIdx--) {
  1795. page.signature_cells.splice(deleteSCellsIdx[dIdx], 1);
  1796. }
  1797. }
  1798. }
  1799. }
  1800. };
  1801. if (isTxtSignature) {
  1802. if (pageData instanceof Array) {
  1803. pageData.forEach((dtlPage, index) => {
  1804. let dftRolRel = [];
  1805. const rpt_id = rpt_ids[index];
  1806. for (const roleRel of singleRoleRel) {
  1807. if (roleRel.rpt_id === rpt_id) {
  1808. dftRolRel = roleRel;
  1809. }
  1810. }
  1811. // _mergeSingle(dtlPage, dftRolRel, true, status !== 3);
  1812. _mergeSingle(dtlPage, dftRolRel, false, status !== 3); // 因加了个标记(归档不输出签名),前端做了大量的签名处理工作,导致现在不能删除,否则还会出现遗漏
  1813. });
  1814. } else {
  1815. _mergeSingle(pageData, singleRoleRel, false, status !== 3);
  1816. }
  1817. }
  1818. }
  1819. function _chkIfAudit(role_rel, STAGE_AUDIT = [], STAGE_LIST = []) {
  1820. let rst = false;
  1821. for (const stg_audit of STAGE_AUDIT) {
  1822. if (role_rel.acc_id === stg_audit.aid) {
  1823. if (stg_audit.status === 3) {
  1824. rst = true;
  1825. } else {
  1826. rst = false;
  1827. }
  1828. // break; //因为实际业务中会有反复,所以就不break了,一直判断,以最后一个为准
  1829. }
  1830. }
  1831. if (!rst) {
  1832. // 还有原报需要检测
  1833. for (const stg_ort_rpt of STAGE_LIST) {
  1834. if (role_rel.acc_id === stg_ort_rpt.user_id) {
  1835. if (stg_ort_rpt.status !== 1 && stg_ort_rpt.status !== 4) {
  1836. // 只要不是待上报(1)、退回审批(4) 状态,都需要显示
  1837. rst = true;
  1838. } else {
  1839. rst = false;
  1840. }
  1841. // break; //因为实际业务中会有反复,所以就不break了,一直判断,以最后一个为准
  1842. }
  1843. }
  1844. }
  1845. // rst = true; //测试,未来将屏蔽
  1846. return rst;
  1847. }
  1848. // 因机制问题,此方法必须在mergeTextSignature之前调用
  1849. async function mergeStampSignature(ctx, status, pageData, singleRoleRel, rpt_ids, stgAudit, stageList) {
  1850. const dupPicPaths = [];
  1851. const _getMaxRect = function(page) {
  1852. const rect = [100000000, 100000000, 0, 0];
  1853. for (const cell of page.cells) {
  1854. rect[0] = rect[0] > cell.area.Left ? cell.area.Left : rect[0];
  1855. rect[1] = rect[1] > cell.area.Top ? cell.area.Top : rect[1];
  1856. rect[2] = rect[2] < cell.area.Right ? cell.area.Right : rect[2];
  1857. rect[3] = rect[3] < cell.area.Bottom ? cell.area.Bottom : rect[3];
  1858. }
  1859. for (const sCell of page.signature_cells) {
  1860. rect[0] = rect[0] > sCell.area.Left ? sCell.area.Left : rect[0];
  1861. rect[1] = rect[1] > sCell.area.Top ? sCell.area.Top : rect[1];
  1862. rect[2] = rect[2] < sCell.area.Right ? sCell.area.Right : rect[2];
  1863. rect[3] = rect[3] < sCell.area.Bottom ? sCell.area.Bottom : rect[3];
  1864. }
  1865. return rect;
  1866. };
  1867. const createStampArea = function(orgCell, controls, maxRect) {
  1868. const ctrl = controls[orgCell.control];
  1869. const rst = { Left: orgCell.area.Left, Right: orgCell.area.Right, Top: orgCell.area.Top, Bottom: orgCell.area.Bottom };
  1870. let pLeft = orgCell.area.Left,
  1871. pTop = orgCell.area.Top;
  1872. switch (ctrl[JV.CONTROL_PROPS[JV.CONTROL_PROP_IDX_HORIZON]]) {
  1873. case JV.OUTPUT_ALIGN.H[JV.H_ALIGN_IDX_LEFT]:
  1874. pLeft = orgCell.area.Left;
  1875. break;
  1876. case JV.OUTPUT_ALIGN.H[JV.H_ALIGN_IDX_CENTER]:
  1877. pLeft = (orgCell.area.Left + orgCell.area.Right - STD_COMP_STAMP_SIZE_WIDTH) / 2;
  1878. break;
  1879. case JV.OUTPUT_ALIGN.H[JV.H_ALIGN_IDX_RIGHT]:
  1880. pLeft = orgCell.area.Right - STD_COMP_STAMP_SIZE_WIDTH;
  1881. break;
  1882. default:break;
  1883. }
  1884. switch (ctrl[JV.CONTROL_PROPS[JV.CONTROL_PROP_IDX_VERTICAL]]) {
  1885. case JV.OUTPUT_ALIGN.H[JV.V_ALIGN_IDX_TOP]:
  1886. pTop = orgCell.area.Top;
  1887. break;
  1888. case JV.OUTPUT_ALIGN.H[JV.V_ALIGN_IDX_CENTER]:
  1889. pTop = (orgCell.area.Top + orgCell.area.Bottom - STD_COMP_STAMP_SIZE_HEIGHT) / 2;
  1890. break;
  1891. case JV.OUTPUT_ALIGN.H[JV.V_ALIGN_IDX_BOTTOM]:
  1892. pTop = orgCell.area.Bottom - STD_COMP_STAMP_SIZE_HEIGHT;
  1893. break;
  1894. default:break;
  1895. }
  1896. rst.Left = pLeft;
  1897. rst.Top = pTop;
  1898. rst.Right = pLeft + STD_COMP_STAMP_SIZE_WIDTH;
  1899. rst.Bottom = pTop + STD_COMP_STAMP_SIZE_WIDTH;
  1900. // 最后一步,如超过报表范围,则要调整坐标
  1901. // if (rst.Left < maxRect[0]) {
  1902. // const width = maxRect[0] - rst.Left;
  1903. // rst.Left += width;
  1904. // rst.Right += width;
  1905. // }
  1906. // if (rst.Top < maxRect[1]) {
  1907. // const height = maxRect[1] - rst.Top;
  1908. // rst.Top += height;
  1909. // rst.Bottom += height;
  1910. // }
  1911. // if (rst.Right > maxRect[2]) {
  1912. // const width = maxRect[2] - rst.Right; // 负
  1913. // rst.Left += width;
  1914. // rst.Right += width;
  1915. // }
  1916. // if (rst.Bottom > maxRect[3]) {
  1917. // const height = maxRect[3] - rst.Bottom;
  1918. // rst.Top += height;
  1919. // rst.Bottom += height;
  1920. // }
  1921. return rst;
  1922. };
  1923. const _mergeSingleStamp = async function(_page, _roleRelList, checkAudit = false) {
  1924. let roleRelContent = [];
  1925. if (_roleRelList && _roleRelList.rel_content !== null && _roleRelList.rel_content !== undefined && _roleRelList.rel_content !== '') {
  1926. roleRelContent = JSON.parse(_roleRelList.rel_content);
  1927. }
  1928. for (const page of _page.items) {
  1929. const maxRect = _getMaxRect(page);
  1930. if (page.signature_cells) {
  1931. const newStampCells = [];
  1932. for (let scIdx = 0; scIdx < page.signature_cells.length; scIdx++) {
  1933. const sCell = page.signature_cells[scIdx];
  1934. for (const role_rel of roleRelContent) {
  1935. if (sCell.signature_name === role_rel.signature_name) {
  1936. if (!checkAudit || _chkIfAudit(role_rel, stgAudit || [], stageList || [])) {
  1937. if (Array.isArray(role_rel.sign_output) && role_rel.sign_output.length > 0) {
  1938. for (const signType of role_rel.sign_output) {
  1939. switch (signType) {
  1940. case COMPANY_SIGN_STR:
  1941. case PRIVATE_SIGN_STR:
  1942. // 创建一个新的cell
  1943. let stampPath = (signType === COMPANY_SIGN_STR) ? role_rel.company_stamp_path : role_rel.private_stamp_path;
  1944. stampPath = ctx.app.config.fujianOssPath + stampPath;
  1945. if (dupPicPaths.indexOf(stampPath) < 0) {
  1946. dupPicPaths.push(stampPath);
  1947. // await _chkRawPicSizeOSS(ctx, stampPath);
  1948. }
  1949. // 保存在签字信息中的签章信息
  1950. let signatureArea;
  1951. if (role_rel.areaData && role_rel.areaData[signType]) {
  1952. signatureArea = role_rel.areaData[signType];
  1953. }
  1954. const newStampCell = {
  1955. signature_name: JV.SIGNATURE_NAME_DUMMY,
  1956. control: sCell.control,
  1957. style: sCell.style,
  1958. path: stampPath,
  1959. isStamp: true,
  1960. maxRect,
  1961. orgArea: sCell.area,
  1962. area: signatureArea || createStampArea(sCell, _page[JV.NODE_CONTROL_COLLECTION], maxRect), // 有签章信息就直接取,没有的话就走原来的逻辑
  1963. signatureName: role_rel.signature_name, // 节点名称
  1964. signType, // 签章信息
  1965. isSaveSignature: !!signatureArea, // 是否有签章位置信息
  1966. };
  1967. newStampCells.push(newStampCell);
  1968. break;
  1969. default: break;
  1970. }
  1971. }
  1972. }
  1973. }
  1974. }
  1975. }
  1976. }
  1977. if (newStampCells.length > 0) {
  1978. if (page.liftUpInfo) {
  1979. const tmpStampCells = [];
  1980. newStampCells.forEach(newStampCell => {
  1981. const tmpCell = JSON.parse(JSON.stringify(newStampCell));
  1982. tmpStampCells.push(tmpCell);
  1983. let adjustHeight = page.liftUpInfo.liftUpHeight;
  1984. const tmpTop = tmpCell.area.Top - adjustHeight;
  1985. if (tmpTop < 10) {
  1986. adjustHeight = adjustHeight - (10 - tmpTop);
  1987. }
  1988. tmpCell.area.Top = tmpCell.area.Top - adjustHeight;
  1989. tmpCell.area.Bottom = tmpCell.area.Bottom - adjustHeight;
  1990. });
  1991. page.signature_cells = page.signature_cells.concat(tmpStampCells);
  1992. } else {
  1993. page.signature_cells = page.signature_cells.concat(newStampCells);
  1994. }
  1995. }
  1996. }
  1997. }
  1998. };
  1999. if (pageData instanceof Array) {
  2000. pageData.forEach((dtlPage, index) => {
  2001. let dftRolRel = [];
  2002. const rpt_id = rpt_ids[index];
  2003. for (const roleRel of singleRoleRel) {
  2004. if (roleRel.rpt_id === rpt_id) {
  2005. dftRolRel = roleRel;
  2006. }
  2007. }
  2008. _mergeSingleStamp(dtlPage, dftRolRel, status !== 3);
  2009. });
  2010. } else {
  2011. _mergeSingleStamp(pageData, singleRoleRel, status !== 3);
  2012. }
  2013. }
  2014. function mergeSignAudit(pageData, currRoleRelList, currAuditList) {
  2015. for (const page of pageData.items) {
  2016. if (page.signature_audit_cells) {
  2017. for (const sCell of page.signature_audit_cells) {
  2018. sCell.Value = ''; // 这里要先清除原有信息
  2019. if (currRoleRelList && currRoleRelList.length > 0) {
  2020. for (const role_rel of currRoleRelList) {
  2021. if (sCell.signature_name === role_rel.signature_name + '_审核意见') {
  2022. let preDate = '';
  2023. sCell.Value = '同意'; // 只有选择了签名的,才需要初始化一个默认的意见(之前的逻辑在有多个签名,哪怕只选择了一个,其他的意见都会有默认意见)
  2024. if (currAuditList && currAuditList.length > 0) {
  2025. for (const audit_rel of currAuditList) {
  2026. if (role_rel.acc_id === audit_rel.aid) {
  2027. if (audit_rel.end_time > preDate && audit_rel.status === 3) {
  2028. sCell.Value = audit_rel.opinion;
  2029. preDate = audit_rel.end_time;
  2030. }
  2031. // 不能break,实际会有多个审核意见,以最后一个为准
  2032. }
  2033. }
  2034. }
  2035. break;
  2036. }
  2037. }
  2038. }
  2039. }
  2040. }
  2041. }
  2042. }
  2043. function mergeSignDate(pageData, current_stage_id, currRoleRelList, STAGE_AUDIT, STAGE_AUDIT_ORG, STAGE_LIST) {
  2044. if (currRoleRelList && currRoleRelList.length > 0 && STAGE_AUDIT && STAGE_AUDIT.length > 0) {
  2045. for (let rridx = 0; rridx < currRoleRelList.length; rridx++) {
  2046. const role_rel = currRoleRelList[rridx];
  2047. if (role_rel.sign_date === undefined || role_rel.sign_date === null || role_rel.sign_date === '') {
  2048. const dftDate = _getSignDateByAllScenarios(role_rel.acc_id, current_stage_id, STAGE_AUDIT, STAGE_AUDIT_ORG, STAGE_LIST);
  2049. role_rel.sign_date = dftDate;
  2050. }
  2051. }
  2052. }
  2053. if (currRoleRelList && currRoleRelList.length > 0) {
  2054. for (const page of pageData.items) {
  2055. if (page.signature_date_cells) {
  2056. for (const sCell of page.signature_date_cells) {
  2057. sCell.Value = _getSignDateDftName();
  2058. for (const role_rel of currRoleRelList) {
  2059. if (sCell.signature_name === role_rel.signature_name + '_签字日期') {
  2060. if (role_rel.sign_date !== '') {
  2061. if (typeof role_rel.sign_date === 'string') {
  2062. role_rel.sign_date = new Date(role_rel.sign_date);
  2063. }
  2064. sCell.Value = role_rel.sign_date.Format(role_rel.sign_date_format);
  2065. }
  2066. break;
  2067. }
  2068. }
  2069. }
  2070. }
  2071. }
  2072. }
  2073. }
  2074. function _getSignDateByAllScenarios(userAccId, current_stage_id, STAGE_AUDIT, STAGE_AUDIT_ORG, STAGE_LIST) {
  2075. let rst = '';
  2076. let hasAudit = false;
  2077. for (const stg_audit of STAGE_AUDIT) {
  2078. if (stg_audit.aid === userAccId) {
  2079. hasAudit = true;
  2080. if (stg_audit.status === 3) {
  2081. rst = stg_audit.end_time;
  2082. } else {
  2083. rst = '';
  2084. }
  2085. // break; //因为实际业务中会有反复,所以就不break了,一直判断,以最后一个为准
  2086. }
  2087. }
  2088. let isOrgRpt = false;
  2089. for (const stg of STAGE_LIST) {
  2090. if (stg.id === current_stage_id) {
  2091. if (stg.user_id === userAccId) {
  2092. isOrgRpt = true;
  2093. }
  2094. break;
  2095. }
  2096. }
  2097. if (isOrgRpt && !hasAudit && STAGE_AUDIT_ORG && STAGE_AUDIT_ORG.length > 0) {
  2098. if (STAGE_AUDIT_ORG[0].begin_time && STAGE_AUDIT_ORG[0].begin_time !== '' && STAGE_AUDIT_ORG[0].begin_time.length > 20) {
  2099. rst = STAGE_AUDIT_ORG[0].begin_time;
  2100. }
  2101. }
  2102. if (!isOrgRpt && !hasAudit) {
  2103. // 非审批流程人员以及非原报,则显示期截至时间
  2104. // 之前给我的解释有问题的,不应该找stage的period属性,而是找当期最后一个status===3的end_time时间(STAGE_AUDIT已经取了最后times,并已排序了)
  2105. for (const stg_audit of STAGE_AUDIT) {
  2106. if (stg_audit.status === 3) {
  2107. rst = stg_audit.end_time;
  2108. }
  2109. }
  2110. }
  2111. return rst;
  2112. }
  2113. function _getSignDateDftName() {
  2114. return ' 年 月 日';
  2115. }
  2116. async function _chkRawPicSize(pageData, baseDir) {
  2117. let rst = 0;
  2118. const picKeys = [];
  2119. for (let pi = 0; pi < pageData.items.length; pi++) {
  2120. // 每页判断
  2121. for (let ci = 0; ci < pageData.items[pi][JV.PROP_SIGNATURE_CELLS].length; ci++) {
  2122. const picPath = pageData.items[pi][JV.PROP_SIGNATURE_CELLS][ci].path;
  2123. // if (picPath && picPath.indexOf('/sign') < 0 && picKeys.indexOf(picPath) < 0) {
  2124. if (picPath && picPath !== '' && picKeys.indexOf(picPath) < 0) {
  2125. // 签名图片也要计算在内,反正不重复
  2126. picKeys.push(picPath);
  2127. }
  2128. // signature_cells PROP_SIGNATURE_CELLS
  2129. }
  2130. }
  2131. // console.log(picKeys);
  2132. for (const pKey of picKeys) {
  2133. const filePath = `${baseDir}/app${pKey}`;
  2134. console.log('filePath: ' + filePath);
  2135. let isExist = false;
  2136. try {
  2137. isExist = await isFileExisted(filePath);
  2138. } catch (ex) {
  2139. isExist = false;
  2140. }
  2141. console.log('isExist: ' + isExist);
  2142. if (isExist) {
  2143. const obj = fs.statSync(filePath);
  2144. if (obj) {
  2145. rst += obj.size;
  2146. } else {
  2147. console.log('no statSync resutl: ' + filePath);
  2148. }
  2149. // rst += fs.statSync(filePath).size;
  2150. } else {
  2151. console.log(`${pKey} not exists!`);
  2152. }
  2153. }
  2154. return rst;
  2155. }
  2156. async function _chkRawPicSizeOSS(ctx, picPath) {
  2157. // 计量的草图、签章都放在OSS服务器上,需要另外的方式来获取,考虑到效率问题,机制上得有所变化
  2158. const rst = [0, 0];
  2159. try {
  2160. const pf = await ctx.app.signPdfOss.get(picPath);
  2161. console.log('get pic successfully!');
  2162. console.log(pf);
  2163. } catch (ex) {
  2164. console.log(ex);
  2165. } finally {
  2166. console.log('finally!');
  2167. }
  2168. return rst;
  2169. }
  2170. function _resetPageDataByBreaks(pageDataArr, breakAmt, rpt_names, newRptNames) {
  2171. const rst = [];
  2172. for (let pi = 0; pi < pageDataArr.length; pi++) {
  2173. const pageItem = pageDataArr[pi];
  2174. const currentRptName = rpt_names[pi];
  2175. if (pageItem.items.length > breakAmt) {
  2176. let pa = Math.floor(pageItem.items.length / breakAmt);
  2177. if (pageItem.items.length % breakAmt > 0) {
  2178. pa++;
  2179. }
  2180. for (let idx = 0; idx < pa; idx++) {
  2181. const newPageDataObj = { items: [] };
  2182. // newPageDataObj[JV.NODE_PAGE_INFO] = JSON.parse(JSON.stringify(pageItem[JV.NODE_PAGE_INFO]));
  2183. newPageDataObj[JV.NODE_PAGE_INFO] = pageItem[JV.NODE_PAGE_INFO];
  2184. // newPageDataObj[JV.BAND_PROP_MERGE_BAND] = JSON.parse(JSON.stringify(pageItem[JV.BAND_PROP_MERGE_BAND]));
  2185. newPageDataObj[JV.BAND_PROP_MERGE_BAND] = pageItem[JV.BAND_PROP_MERGE_BAND];
  2186. newPageDataObj[JV.NODE_FONT_COLLECTION] = pageItem[JV.NODE_FONT_COLLECTION];
  2187. newPageDataObj[JV.NODE_STYLE_COLLECTION] = pageItem[JV.NODE_STYLE_COLLECTION];
  2188. newPageDataObj[JV.NODE_CONTROL_COLLECTION] = pageItem[JV.NODE_CONTROL_COLLECTION];
  2189. for (let dIdx = idx * breakAmt; dIdx < (Math.min((idx + 1) * breakAmt, pageItem.items.length)); dIdx++) {
  2190. newPageDataObj.items.push(pageItem.items[dIdx]);
  2191. }
  2192. rst.push(newPageDataObj);
  2193. newRptNames.push(currentRptName + '_' + (idx + 1));
  2194. }
  2195. } else {
  2196. rst.push(pageItem);
  2197. newRptNames.push(currentRptName);
  2198. }
  2199. }
  2200. return rst;
  2201. }
  2202. function supplementRoles(rptIds, roleRel) {
  2203. const supplementRptIds = [];
  2204. supplementRptIds.push(...rptIds);
  2205. roleRel.forEach(role => {
  2206. const idx = supplementRptIds.indexOf(role.rpt_id);
  2207. if (idx >= 0) {
  2208. supplementRptIds.splice(idx, 1);
  2209. }
  2210. });
  2211. supplementRptIds.forEach(sRptId => {
  2212. // ['id', 'tender_id', 'rpt_id', 'sid', 'business_id', 'rel_content'];
  2213. const dummyRole = {
  2214. rpt_id: sRptId,
  2215. rel_content: '[]',
  2216. };
  2217. roleRel.push(dummyRole);
  2218. });
  2219. }