ledger_controller.js 31 KB

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