ledger_controller.js 30 KB

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