ledger_controller.js 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736
  1. 'use strict';
  2. /**
  3. * 台账相关控制器
  4. *
  5. * @author CaiAoLin
  6. * @date 2017/11/30
  7. * @version
  8. */
  9. const stdDataAddType = {
  10. withParent: 1,
  11. child: 2,
  12. next: 3,
  13. };
  14. const audit = require('../const/audit');
  15. const auditConst = audit.ledger;
  16. const tenderMenu = require('../../config/menu').tenderMenu;
  17. const measureType = require('../const/tender').measureType;
  18. const spreadConst = require('../const/spread');
  19. const externalDataConst = require('../const/external_data.js');
  20. const fs = require('fs');
  21. const LzString = require('lz-string');
  22. const accountGroup = require('../const/account_group').group;
  23. const path = require('path');
  24. const exportExcel = require('../lib/export_excel');
  25. const billsPosConvert = require('../lib/bills_pos_convert');
  26. const xlsx = require('js-xlsx');
  27. module.exports = app => {
  28. class LedgerController extends app.BaseController {
  29. /**
  30. * 构造函数
  31. *
  32. * @param {Object} ctx - egg全局变量
  33. * @return {void}
  34. */
  35. constructor(ctx) {
  36. super(ctx);
  37. ctx.showProject = true;
  38. ctx.showTitle = true;
  39. ctx.showTender = true;
  40. }
  41. /**
  42. * 检查标段是否只读(审核中,审核完成)
  43. * @param {Object} tenderData
  44. * @return {boolean}
  45. * @private
  46. */
  47. _ledgerReadOnly() {
  48. const tender = this.ctx.tender.data;
  49. return tender.user_id !== this.ctx.session.sessionUser.accountId ||
  50. (tender.ledger_status === auditConst.status.checking || tender.ledger_status === auditConst.status.checked);
  51. }
  52. _canUpdateDealBills(tender, auditors) {
  53. const isUser = tender.user_id === this.ctx.session.sessionUser.accountId;
  54. const auditorsId = this.ctx.helper._.map(auditors, 'audit_id');
  55. const isAuditor = auditorsId.indexOf(this.ctx.session.sessionUser.accountId) >= 0;
  56. const upPermission = this.ctx.session.sessionUser.permission
  57. ? this.ctx.session.sessionUser.permission.tender.indexOf('3') >= 0
  58. : false;
  59. return ((tender.ledger_status === auditConst.status.uncheck || tender.ledger_status === auditConst.status.checkNo) && isUser) ||
  60. (tender.ledger_status === auditConst.status.checking && isAuditor) ||
  61. (tender.ledger_status === auditConst.status.checked && isAuditor && upPermission);
  62. }
  63. /**
  64. * 获取SpreadSetting
  65. * @private
  66. */
  67. _getSpreadSetting() {
  68. const _ = this.app._;
  69. function removeFieldCols(setting, cols) {
  70. _.remove(setting.cols, function(c) {
  71. return cols.indexOf(c.field) > -1;
  72. });
  73. }
  74. function hideFieldCols(setting, cols) {
  75. for (const c of setting.cols) {
  76. if (cols.indexOf(c.field) > -1) {
  77. c.visible = false;
  78. }
  79. }
  80. }
  81. function setColFormat(cols, field, formatter) {
  82. const col = _.find(cols, function(c) {
  83. return c.field === field;
  84. });
  85. col.formatter = formatter;
  86. }
  87. // const tpFormatter = this.ctx.helper.getNumberFormatter(this.ctx.tender.info.decimal.tp);
  88. // const upFormatter = this.ctx.helper.getNumberFormatter(this.ctx.tender.info.decimal.up);
  89. const tender = this.ctx.tender;
  90. const setting = tender.data.measure_type === measureType.tz.value
  91. ? (tender.info.display.ledger.clQty ? spreadConst.withCl : spreadConst.withoutCl)
  92. : (tender.info.display.ledger.clQty ? spreadConst.withClGcl : spreadConst.withoutClGcl);
  93. const ledger = JSON.parse(JSON.stringify(setting.ledger));
  94. // setColFormat(ledger.cols, 'unit_price', upFormatter);
  95. // setColFormat(ledger.cols, 'dgn_price', upFormatter);
  96. // setColFormat(ledger.cols, 'total_price', tpFormatter);
  97. // setColFormat(ledger.cols, 'deal_tp', tpFormatter);
  98. const pos = setting.pos ? JSON.parse(JSON.stringify(setting.pos)) : spreadConst.blank;
  99. if (this._ledgerReadOnly(tender.data)) {
  100. ledger.readOnly = true;
  101. pos.readOnly = true;
  102. }
  103. if (tender.data.measure_type === measureType.tz.value) {
  104. removeFieldCols(ledger, spreadConst.filterCols.tzWithoutCols);
  105. }
  106. if (!tender.info.display.ledger.dgnQty) {
  107. removeFieldCols(ledger, spreadConst.filterCols.dgnCols);
  108. }
  109. return [ledger, pos];
  110. }
  111. /**
  112. * 台账分解页面 (Get)
  113. *
  114. * @param {Object} ctx - egg全局变量
  115. * @return {void}
  116. */
  117. async explode(ctx) {
  118. try {
  119. const tender = ctx.tender;
  120. const [ledgerSpread, posSpread] = this._getSpreadSetting();
  121. const times = tender.data.ledger_status === auditConst.status.checkNo ? tender.data.ledger_times - 1 : tender.data.ledger_times;
  122. const curAuditor = await ctx.service.ledgerAudit.getCurAuditor(tender.id, tender.data.ledger_times);
  123. const auditors = await ctx.service.ledgerAudit.getAuditorsWithOwner(tender.id, times);
  124. const user = await ctx.service.projectAccount.getAccountInfoById(ctx.tender.data.user_id);
  125. const auditHistory = [];
  126. if (times >= 1) {
  127. for (let i = 1; i <= times; i++) {
  128. auditHistory.push(await ctx.service.ledgerAudit.getAuditors(ctx.tender.id, i));
  129. }
  130. }
  131. const [stdBills, stdChapters] = await this.ctx.service.valuation.getValuationStdList(
  132. ctx.tender.data.valuation, ctx.tender.data.measure_type);
  133. const renderData = {
  134. tender: tender.data,
  135. tenderInfo: tender.info,
  136. auditConst,
  137. auditors,
  138. curAuditor,
  139. user,
  140. auditHistory,
  141. ledgerSpreadSetting: JSON.stringify(ledgerSpread),
  142. posSpreadSetting: JSON.stringify(posSpread),
  143. tenderMenu,
  144. preUrl: '/tender/' + tender.id,
  145. measureType,
  146. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.ledger.explode),
  147. stdBills,
  148. stdChapters,
  149. dealBillsPermission: this._canUpdateDealBills(tender.data, auditors.filter(x => {return x.audit_order > 0}))
  150. };
  151. if ((tender.data.ledger_status === auditConst.status.uncheck || tender.data.ledger_status === auditConst.status.checkNo) && tender.data.user_id === ctx.session.sessionUser.accountId) {
  152. // renderData.accountGroup = accountGroup;
  153. // 获取所有项目参与者
  154. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  155. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  156. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  157. });
  158. renderData.accountList = accountList;
  159. renderData.accountGroup = accountGroup.map((item, idx) => {
  160. const groupList = accountList.filter(item => item.account_group === idx);
  161. return { groupName: item, groupList };
  162. });
  163. renderData.auditorList = await ctx.service.ledgerAudit.getAuditors(tender.id, tender.data.ledger_times);
  164. }
  165. await this.layout('ledger/explode.ejs', renderData, 'ledger/explode_modal.ejs');
  166. } catch (err) {
  167. ctx.helper.log(err);
  168. this.postError(err, '标段数据错误');
  169. await this.redirect('/dashboard');
  170. }
  171. }
  172. /**
  173. * 获取子节点 (Ajax)
  174. * @param ctx
  175. * @return {Promise<void>}
  176. */
  177. async getChildren(ctx) {
  178. const responseData = {
  179. err: 0,
  180. msg: '',
  181. data: [],
  182. };
  183. try {
  184. const data = JSON.parse(ctx.request.body.data);
  185. const id = data.ledger_id;
  186. if (isNaN(id) || id <= 0) {
  187. throw '参数错误';
  188. }
  189. responseData.data = await ctx.service.ledger.getChildrenByParentId(ctx.tender.id, id);
  190. } catch (err) {
  191. responseData.err = 1;
  192. responseData.msg = err;
  193. }
  194. ctx.body = responseData;
  195. }
  196. /**
  197. * 树结构基本操作(增、删、上下移、升降级)
  198. * @param {Object} ctx - egg全局变量
  199. * @return {Promise<void>}
  200. */
  201. async _base(ctx, type, data) {
  202. if (isNaN(data.id) || data.id <= 0) throw '数据错误';
  203. if (type !== 'add') {
  204. if (isNaN(data.count) || data.count <= 0) data.count = 1;
  205. }
  206. switch (type) {
  207. case 'add':
  208. return await ctx.service.ledger.addNodeBatch(ctx.tender.id, data.id, {}, data.count);
  209. case 'delete':
  210. return await ctx.service.ledger.delete(ctx.tender.id, data.id, data.count);
  211. case 'up-move':
  212. return await ctx.service.ledger.upMoveNode(ctx.tender.id, data.id, data.count);
  213. case 'down-move':
  214. return await ctx.service.ledger.downMoveNode(ctx.tender.id, data.id, data.count);
  215. case 'up-level':
  216. return await ctx.service.ledger.upLevelNode(ctx.tender.id, data.id, data.count);
  217. case 'down-level':
  218. return await ctx.service.ledger.downLevelNode(ctx.tender.id, data.id, data.count);
  219. }
  220. }
  221. /**
  222. * 复制粘贴整块
  223. *
  224. * @param ctx
  225. * @return {Promise<void>}
  226. */
  227. async _pasteBlock(ctx, data) {
  228. if ((isNaN(data.id) || data.id <= 0) ||
  229. (!data.tid && data.tid <= 0) ||
  230. (!data.block || data.block.length <= 0)) throw '参数错误';
  231. return await ctx.service.ledger.pasteBlockData(ctx.tender.id, data.id, data.block);
  232. }
  233. /**
  234. * 从标准项目表添加数据
  235. * @param ctx
  236. * @return {Promise<void>}
  237. */
  238. async _addStd(ctx, data) {
  239. if ((isNaN(data.id) || data.id <= 0) || !data.stdType || !data.stdNode) throw '参数错误';
  240. // todo 校验项目是否使用该库的权限
  241. let stdLib,
  242. addType;
  243. switch (data.stdType) {
  244. case 'xmj':
  245. stdLib = ctx.service.stdXmj;
  246. addType = stdDataAddType.withParent;
  247. break;
  248. case 'gcl':
  249. stdLib = ctx.service.stdGcl;
  250. const selectNode = await ctx.service.ledger.getDataByNodeId(ctx.tender.id, data.id);
  251. if (selectNode.b_code) {
  252. addType = stdDataAddType.next;
  253. } else {
  254. addType = stdDataAddType.child;
  255. }
  256. break;
  257. default:
  258. throw '未知标准库';
  259. }
  260. const stdData = await stdLib.getDataByDataId(data.stdLibId, data.stdNode);
  261. switch (addType) {
  262. case stdDataAddType.child:
  263. return await ctx.service.ledger.addStdNodeAsChild(ctx.tender.id, data.id, stdData);
  264. case stdDataAddType.next:
  265. return await ctx.service.ledger.addStdNode(ctx.tender.id, data.id, stdData);
  266. case stdDataAddType.withParent:
  267. return await ctx.service.ledger.addStdNodeWithParent(ctx.tender.id, stdData, stdLib);
  268. default:
  269. throw '未知添加方式';
  270. }
  271. }
  272. /**
  273. * 从签约清单添加节点
  274. * @param ctx
  275. * @return {Promise<void>}
  276. */
  277. async _addDeal(ctx, data) {
  278. if (!data.type || !data.dealBills) throw '数据错误';
  279. data.dealBills.unit_price = this.ctx.helper.round(data.dealBills.unit_price, ctx.tender.info.decimal.up);
  280. if (data.type === 'child') {
  281. return await ctx.service.ledger.addChild(ctx.tender.id, data.id, data.dealBills);
  282. } else if (data.type === 'next') {
  283. return await ctx.service.ledger.addNode(ctx.tender.id, data.id, data.dealBills);
  284. }
  285. throw '数据错误';
  286. }
  287. /**
  288. * 批量插入数据
  289. *
  290. * data = {id, batchData, batchType}
  291. * data.batchType = 'batchInsertChild'/'batchInsertNext'
  292. * data.batchData = [{name, children}] -- 项目节列表
  293. * data.batchData.children = [{code, name, unit, unit_price, quantity}] -- 工程量清单列表
  294. *
  295. * @param ctx
  296. * @return {Promise<void>}
  297. */
  298. async _batchInsert(ctx, data) {
  299. if ((isNaN(data.id) || data.id <= 0) || !data.batchType) throw '参数错误';
  300. switch (data.batchType) {
  301. case 'child':
  302. return await ctx.service.ledger.batchInsertChild(ctx.tender.id, data.id, data.batchData);
  303. case 'next':
  304. return await ctx.service.ledger.batchInsertNext(ctx.tender.id, data.id, data.batchData);
  305. default:
  306. throw '参数错误';
  307. }
  308. }
  309. /**
  310. * 更新清单相关 (Ajax)
  311. * @param ctx
  312. * @return {Promise<void>}
  313. */
  314. async update(ctx) {
  315. try {
  316. if (!ctx.tender.data) throw '标段数据错误';
  317. if (ctx.tender.data.user_id !== ctx.session.sessionUser.accountId || this._ledgerReadOnly()) throw '您无权进行该操作';
  318. const data = JSON.parse(ctx.request.body.data);
  319. if (!data.postType || !data.postData) throw '数据错误';
  320. const responseData = {
  321. err: 0,
  322. msg: '',
  323. data: [],
  324. };
  325. switch (data.postType) {
  326. case 'add':
  327. case 'delete':
  328. case 'up-move':
  329. case 'down-move':
  330. case 'up-level':
  331. case 'down-level':
  332. responseData.data = await this._base(ctx, data.postType, data.postData);
  333. break;
  334. case 'update':
  335. responseData.data = await ctx.service.ledger.updateCalc(ctx.tender.id, data.postData);
  336. break;
  337. case 'paste-block':
  338. responseData.data = await this._pasteBlock(ctx, data.postData);
  339. break;
  340. case 'add-std':
  341. responseData.data = await this._addStd(ctx, data.postData);
  342. break;
  343. case 'add-deal':
  344. responseData.data = await this._addDeal(ctx, data.postData);
  345. break;
  346. case 'batch-insert':
  347. responseData.data = await this._batchInsert(ctx, data.postData);
  348. break;
  349. default:
  350. throw '未知操作';
  351. }
  352. ctx.body = responseData;
  353. } catch (err) {
  354. this.log(err);
  355. ctx.body = this.ajaxErrorBody(err);
  356. }
  357. }
  358. /**
  359. * 定位
  360. * @param ctx
  361. * @return {Promise<void>}
  362. */
  363. async locate(ctx) {
  364. const responseData = {
  365. err: 0,
  366. msg: '',
  367. data: [],
  368. };
  369. try {
  370. const tenderId = ctx.params.id;
  371. if (!tenderId) {
  372. throw '当前未打开标段';
  373. }
  374. const data = JSON.parse(ctx.request.body.data);
  375. if ((isNaN(data.id) || data.id <= 0)) {
  376. throw '参数错误';
  377. }
  378. responseData.data = await ctx.service.ledger.locateNode(tenderId, data.id);
  379. } catch (err) {
  380. this.log(err);
  381. responseData.err = 1;
  382. responseData.msg = err;
  383. }
  384. ctx.body = responseData;
  385. }
  386. /**
  387. * 获取全部子节点
  388. *
  389. * @param ctx
  390. * @return {Promise<void>}
  391. */
  392. async posterity(ctx) {
  393. const responseData = {
  394. err: 0,
  395. msg: '',
  396. data: [],
  397. };
  398. try {
  399. const tenderId = ctx.params.id;
  400. if (!tenderId) {
  401. throw '当前未打开标段';
  402. }
  403. const data = JSON.parse(ctx.request.body.data);
  404. if ((isNaN(data.id) || data.id <= 0)) {
  405. throw '参数错误';
  406. }
  407. const expandData = await ctx.service.ledger.getPosterityByParentId(tenderId, data.id);
  408. responseData.data = { expand: expandData };
  409. } catch (err) {
  410. this.log(err);
  411. responseData.err = 1;
  412. responseData.msg = err;
  413. }
  414. ctx.body = responseData;
  415. }
  416. /**
  417. * 获取部位明细数据(Ajax)
  418. *
  419. * @param ctx
  420. * @return {Promise<void>}
  421. */
  422. async loadExplodeData(ctx) {
  423. try {
  424. const ledgerData = await ctx.service.ledger.getData(ctx.tender.id);
  425. const posData = this.ctx.tender.data.measure_type === measureType.tz.value
  426. ? await ctx.service.pos.getPosData({ tid: ctx.tender.id }) : [];
  427. ctx.body = { err: 0, msg: '', data: { bills: ledgerData, pos: posData } };
  428. } catch (err) {
  429. this.log(err);
  430. ctx.body = { err: 1, msg: err.toString(), data: [] };
  431. }
  432. }
  433. async check(ctx) {
  434. try {
  435. const ledgerData = await ctx.service.ledger.getData(ctx.tender.id);
  436. const posData = this.ctx.tender.data.measure_type === measureType.tz.value
  437. ? await ctx.service.pos.getPosData({ tid: ctx.tender.id }) : [];
  438. const qtyData = ctx.helper.checkBillsWithPos(ledgerData, posData,
  439. ['sgfh_qty', 'qtcl_qty', 'sjcl_qty', 'quantity']);
  440. qtyData.error.forEach(x => { x.errorType = 'qty'; });
  441. const tpData = ctx.helper.checkBillsTp(ledgerData, [
  442. {qty: 'sgfh_qty', tp: 'sgfh_tp'}, {qty: 'qtcl_qty', tp: 'qtcl_tp'},
  443. {qty: 'sjcl_qty', tp: 'sjcl_tp'}, {qty: 'quantity', tp: 'total_price'}
  444. ], this.ctx.tender.info.decimal);
  445. tpData.error.forEach(x => { x.errorType = 'tp'; });
  446. ctx.body = { err: 0, msg: '', data: {
  447. error: [...qtyData.error, ...tpData.error],
  448. source: {
  449. bills: [...qtyData.source.bills, ...tpData.source.bills],
  450. pos: [...qtyData.source.pos, ...tpData.source.pos],
  451. },
  452. }};
  453. } catch (err) {
  454. this.log(err);
  455. ctx.body = this.ajaxErrorBody(err, '检查数据错误');
  456. }
  457. }
  458. /**
  459. * 更新 部位明细数据
  460. *
  461. * @param ctx
  462. * @return {Promise<void>}
  463. */
  464. async posUpdate(ctx) {
  465. try {
  466. await this.checkMeasureType(measureType.tz.value);
  467. const data = JSON.parse(ctx.request.body.data);
  468. const responseData = await ctx.service.pos.savePosData(data, ctx.tender.id);
  469. ctx.body = { err: 0, msg: '', data: responseData };
  470. } catch (err) {
  471. this.log(err);
  472. ctx.body = { err: 1, msg: err.toString(), data: null };
  473. }
  474. }
  475. /**
  476. * 复制粘贴 部位明细
  477. * @param ctx
  478. * @return {Promise<void>}
  479. */
  480. async posPaste(ctx) {
  481. try {
  482. await this.checkMeasureType(measureType.tz.value);
  483. const data = JSON.parse(ctx.request.body.data);
  484. const result = await ctx.service.pos.pastePosData(data, ctx.tender.id);
  485. ctx.body = { err: 0, msg: '', data: result };
  486. } catch (err) {
  487. this.log(err);
  488. ctx.body = { err: 1, msg: err.toString(), data: null };
  489. }
  490. }
  491. /**
  492. * 上传 清单Excel 并导入
  493. * @param ctx
  494. * @return {Promise<void>}
  495. */
  496. async uploadExcel(ctx) {
  497. try {
  498. const ueType = ctx.params.ueType;
  499. const compressData = ctx.request.body.data;
  500. const data = JSON.parse(LzString.decompressFromUTF16(compressData));
  501. const responseData = { err: 0, msg: '', data: {} };
  502. switch (ueType) {
  503. case 'tz':
  504. const templateId = await this.ctx.service.valuation.getValuationTemplate(
  505. this.ctx.tender.data.valuation, this.ctx.tender.data.measure_type);
  506. responseData.data = await ctx.service.ledger.importExcel(templateId, data);
  507. break;
  508. case 'gcl2xmj':
  509. responseData.data = await ctx.service.ledger.importGclExcel(data.id, data.sheet);
  510. break;
  511. default:
  512. throw '数据错误';
  513. }
  514. ctx.body = responseData;
  515. } catch (err) {
  516. this.log(err);
  517. ctx.body = { err: 1, msg: err.toString(), data: null };
  518. }
  519. }
  520. // async uploadExcel(ctx) {
  521. // let stream;
  522. // try {
  523. // const responseData = { err: 0, msg: '', data: {}, };
  524. // // 保存文件
  525. // stream = await ctx.getFileStream();
  526. // const create_time = Date.parse(new Date());
  527. // const fileInfo = path.parse(stream.filename);
  528. // const fileName = this.app.config.filePath + '/cache/ledger/uploads/' + create_time + fileInfo.ext;
  529. // await ctx.helper.saveStreamFile(stream, fileName);
  530. // // 读取excel
  531. // console.log(ctx.query);
  532. // const name = ctx.query.sheetName;
  533. // if (!name) throw '未选择需要导入的工作簿';
  534. // const wb = xlsx.readFile(fileName);
  535. // const sheetData = {
  536. // rows: xlsx.utils.sheet_to_json(wb.Sheets[name], {header: 1}),
  537. // merge: wb.Sheets[name]["!merges"],
  538. // };
  539. // if (!sheetData.rows) throw '读取工作簿数据错误';
  540. // const ueType = ctx.query.ueType;
  541. // switch (ueType) {
  542. // case 'tz':
  543. // const templateId = await this.ctx.service.valuation.getValuationTemplate(
  544. // this.ctx.tender.data.valuation, this.ctx.tender.data.measure_type);
  545. // responseData.data = await ctx.service.ledger.importExcel(templateId, sheetData);
  546. // break;
  547. // case 'gcl2xmj':
  548. // responseData.data = await ctx.service.ledger.importGclExcel(ctx.tender.id, sheetData);
  549. // break;
  550. // default:
  551. // throw '数据错误';
  552. // }
  553. // ctx.body = responseData;
  554. // } catch (err) {
  555. // console.log(err);
  556. // this.log(err);
  557. // // 失败需要消耗掉stream 以防卡死
  558. // if (stream) await sendToWormhole(stream);
  559. // ctx.body = {err: 1, msg: err.toString(), data: null};
  560. // }
  561. // }
  562. /**
  563. * 填设计量(Ajax)
  564. *
  565. * @param ctx
  566. * @return {Promise<void>}
  567. */
  568. async deal2sgfh(ctx) {
  569. try {
  570. if (!ctx.tender.data) throw '标段数据错误';
  571. if (ctx.tender.data.user_id !== ctx.session.sessionUser.accountId || this._ledgerReadOnly()) throw '您无权进行该操作';
  572. if (this.ctx.tender.measure_type === measureType.tz.value) throw '该功能仅工程量清单模式可用';
  573. await this.ctx.service.ledger.deal2sgfh(ctx.tender.id);
  574. const ledgerData = await ctx.service.ledger.getData(ctx.tender.id);
  575. ctx.body = { err: 0, msg: '', data: { bills: ledgerData } };
  576. } catch (err) {
  577. this.log(err);
  578. ctx.body = { err: 1, msg: err.toString(), data: null };
  579. }
  580. }
  581. /**
  582. * 下载(清单Excel模板 or 导出项目台账Excel)
  583. * @param ctx
  584. * @return {Promise<void>}
  585. */
  586. async download(ctx) {
  587. const file = ctx.params.file;
  588. if (file) {
  589. try {
  590. let fileName;
  591. if (file === '导入分项清单EXCEL格式.xls') {
  592. fileName = path.join(this.app.baseDir, 'app', 'public', 'files', 'template', 'ledger', '导入分项清单EXCEL格式.xls');
  593. ctx.body = await fs.readFileSync(fileName);
  594. } else if (file === '台账分解.xlsx') {
  595. const create_time = Date.parse(new Date()) / 1000;
  596. fileName = this.app.baseDir + '/app/public/files/ledger' + ctx.tender.id + '-' + create_time + '.xlsx';
  597. const exportor = new exportExcel.exportLedger2Excel(ctx);
  598. await exportor.export2File(fileName);
  599. ctx.body = await fs.readFileSync(fileName);
  600. // 输出文件后删除
  601. fs.unlinkSync(fileName);
  602. }
  603. } catch (err) {
  604. this.log(err);
  605. this.setMessage(err.toString(), this.messageType.ERROR);
  606. }
  607. }
  608. }
  609. /**
  610. * 部位台账 页面 (Get)
  611. * @param ctx
  612. * @return {Promise<void>}
  613. */
  614. async bwtz(ctx) {
  615. try {
  616. const renderData = {
  617. tender: ctx.tender.data,
  618. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.ledger.bwtz),
  619. };
  620. await this.layout('ledger/bwtz.ejs', renderData);
  621. } catch (err) {
  622. this.log(err);
  623. ctx.redirect(ctx.request.header.referer);
  624. }
  625. }
  626. async loadBwtz(ctx) {
  627. try {
  628. const ledgerData = await ctx.service.ledger.getData(ctx.tender.id);
  629. const posData = this.ctx.tender.data.measure_type === measureType.tz.value
  630. ? await ctx.service.pos.getPosData({ tid: ctx.tender.id }) : [];
  631. const convert = new billsPosConvert(ctx);
  632. convert.loadData(ledgerData, posData, []);
  633. const result = await convert.convert();
  634. // const wbsCodeHis = await ctx.service.externalData.getExValue(ctx.tender.id, -1,
  635. // externalDataConst.FuLong.exType, externalDataConst.FuLong.exFields.wbsCode) || [];
  636. // const [result, needUpdate] = convert.convertByWbsCode(wbsCodeHis);
  637. // if (needUpdate) {
  638. // await ctx.service.externalData.saveExValue(ctx.tender.id, -1,
  639. // externalDataConst.FuLong.exType, externalDataConst.FuLong.exFields.wbsCode, wbsCodeHis);
  640. // }
  641. ctx.body = { err: 0, msg: '', data: result };
  642. } catch (err) {
  643. this.log(err);
  644. ctx.body = this.ajaxErrorBody(err, '加载合同支付数据错误');
  645. }
  646. }
  647. /**
  648. * 台账对比 页面 (Get)
  649. * @param ctx
  650. * @return {Promise<void>}
  651. */
  652. async gather(ctx) {
  653. try {
  654. const renderData = {
  655. tender: ctx.tender.data,
  656. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.ledger.gather),
  657. };
  658. await this.layout('ledger/gather.ejs', renderData);
  659. } catch (err) {
  660. this.log(err);
  661. await this.redirect(ctx.request.header.referer);
  662. }
  663. }
  664. /**
  665. * 获取 台账对比 数据 (Ajax)
  666. * @param ctx
  667. * @return {Promise<void>}
  668. */
  669. async loadGatherData(ctx) {
  670. try {
  671. const billsData = await ctx.service.ledger.getData(ctx.tender.id);
  672. const posData = this.ctx.tender.data.measure_type === measureType.tz.value
  673. ? await ctx.service.pos.getPosData({ tid: ctx.tender.id }) : [];
  674. const dealBills = await ctx.service.dealBills.getAllDataByCondition({ where: { tender_id: this.ctx.tender.id } });
  675. ctx.body = { err: 0, msg: '', data: { bills: billsData, pos: posData, dealBills } };
  676. } catch (err) {
  677. this.log(err);
  678. ctx.body = { err: 1, msg: err.toString(), data: [] };
  679. }
  680. }
  681. /**
  682. * 计量台账页面 (Get)
  683. *
  684. * @param {object} ctx - egg全局变量
  685. * @return {void}
  686. */
  687. async index(ctx) {
  688. const renderData = {};
  689. await this.layout('ledger/index.ejs', renderData);
  690. }
  691. }
  692. return LedgerController;
  693. };