revise_controller.js 39 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author Mai
  6. * @date
  7. * @version
  8. */
  9. const stdDataAddType = {
  10. withParent: 1,
  11. child: 2,
  12. next: 3,
  13. };
  14. const audit = require('../const/audit');
  15. const accountGroup = require('../const/account_group').group;
  16. const tenderMenu = require('../../config/menu').tenderMenu;
  17. const measureType = require('../const/tender').measureType;
  18. const spreadConst = require('../const/spread');
  19. const fs = require('fs');
  20. const LzString = require('lz-string');
  21. module.exports = app => {
  22. class ReviseController extends app.BaseController {
  23. /**
  24. * 构造函数
  25. *
  26. * @param {Object} ctx - egg全局变量
  27. * @return {void}
  28. */
  29. constructor(ctx) {
  30. super(ctx);
  31. }
  32. /**
  33. * 是否可以新增修订
  34. * @param ctx
  35. * @return {Promise<boolean>}
  36. * @private
  37. */
  38. async _getAddReviseValid(ctx) {
  39. const revise = await ctx.service.ledgerRevise.getLastestRevise(ctx.tender.id);
  40. const lastStage = await ctx.service.stage.getLastestStage(ctx.tender.id, true);
  41. return (ctx.tender.data.user_id === ctx.session.sessionUser.accountId) &&
  42. (ctx.tender.data.ledger_status === audit.ledger.status.checked) &&
  43. (!revise || !revise.valid || revise.status === audit.revise.status.checked) &&
  44. (!lastStage || lastStage.status !== audit.stage.status.checking);
  45. }
  46. /**
  47. * 台账修订页面 (Get)
  48. *
  49. * @param {object} ctx - egg全局变量
  50. * @return {void}
  51. */
  52. async index(ctx) {
  53. try {
  54. // 分页相关
  55. const count = await ctx.service.ledgerRevise.count({ tid: ctx.tender.id });
  56. const ledgerRevise = await ctx.service.ledgerRevise.getReviseList(ctx.tender.id);
  57. if (ledgerRevise.length > 0) {
  58. const revise = ledgerRevise[0];
  59. if (revise.status === audit.revise.status.checked || !revise.valid) {
  60. revise.lastest = true;
  61. } else {
  62. if (ledgerRevise.length > 1) ledgerRevise[1].lastest = true;
  63. // if (revise.status === audit.revise.status.checking) {
  64. // revise.curAuditor = await ctx.service.reviseAudit.getCurAuditor(revise.id, revise.times);
  65. // }
  66. }
  67. }
  68. for (const lr of ledgerRevise) {
  69. if (lr.valid) {
  70. lr.curAuditor = await ctx.service.reviseAudit.getAuditorByStatus(lr.id, lr.status, lr.times);
  71. }
  72. }
  73. const addValid = await this._getAddReviseValid(ctx);
  74. const [stdBills, stdChapters] = await this.ctx.service.valuation.getValuationStdList(
  75. ctx.tender.data.valuation, ctx.tender.data.measure_type);
  76. const renderData = {
  77. tender: ctx.tender.data,
  78. tenderMenu: this.menu.tenderMenu,
  79. preUrl: '/tender/' + ctx.tender.id,
  80. pageInfo: {
  81. page: ctx.page,
  82. total: Math.ceil(count / app.config.pageSize),
  83. queryData: JSON.stringify(ctx.urlInfo.query),
  84. },
  85. ledgerRevise,
  86. addValid,
  87. auditConst: audit.revise,
  88. auditConst2: JSON.stringify(audit.revise),
  89. stdBills,
  90. stdChapters,
  91. };
  92. await this.layout('revise/index.ejs', renderData, 'revise/modal.ejs');
  93. } catch (err) {
  94. this.log(err);
  95. ctx.redirect(ctx.request.header.referer);
  96. }
  97. }
  98. /**
  99. * 修订审批流程(Get)
  100. * @param ctx
  101. * @return {Promise<void>}
  102. */
  103. async reviseAuditors(ctx) {
  104. try {
  105. const responseData = {
  106. err: 0, msg: '', data: {},
  107. };
  108. const rid = JSON.parse(ctx.request.body.data).id;
  109. const reviseInfo = await ctx.service.ledgerRevise.getDataById(rid);
  110. // 获取审批流程中右边列表
  111. const auditHistory = [];
  112. const times = reviseInfo.status === audit.revise.status.checkNo ? reviseInfo.times - 1 : reviseInfo.times;
  113. if (times >= 1) {
  114. for (let i = 1; i <= times; i++) {
  115. auditHistory.push(await ctx.service.reviseAudit.getAuditors2ReviseList(reviseInfo.id, i));
  116. }
  117. }
  118. responseData.data.auditHistory = auditHistory;
  119. // 获取审批流程中左边列表
  120. responseData.data.auditors = await ctx.service.reviseAudit.getAuditorsWithOwner(reviseInfo.id, times);
  121. // 获取原报信息
  122. const reviseAuditor = await ctx.service.projectAccount.getAccountInfoById(reviseInfo.uid);
  123. responseData.data.reviseAuditor = reviseAuditor;
  124. ctx.body = responseData;
  125. } catch (error) {
  126. this.log(error);
  127. ctx.body = { err: 1, msg: error.toString(), data: null };
  128. }
  129. }
  130. /**
  131. * 新增 修订 (Post)
  132. * @param ctx
  133. * @return {Promise<void>}
  134. */
  135. async add(ctx) {
  136. try {
  137. const addValid = await this._getAddReviseValid(ctx);
  138. if (!addValid) {
  139. throw '无法新增修订';
  140. }
  141. const revise = await ctx.service.ledgerRevise.add(ctx.tender.id, ctx.session.sessionUser.accountId);
  142. ctx.redirect('/tender/' + ctx.tender.id + '/revise/info');
  143. } catch (err) {
  144. this.log(err);
  145. ctx.redirect(ctx.request.header.referer);
  146. }
  147. }
  148. /**
  149. * 作废 修订 (Post)
  150. * @param ctx
  151. * @return {Promise<void>}
  152. */
  153. async cancel(ctx) {
  154. try {
  155. const revise = await ctx.service.ledgerRevise.getLastestRevise(ctx.tender.id);
  156. if (revise.uid !== ctx.session.sessionUser.accountId) {
  157. throw '您无权作废该修订';
  158. }
  159. if (revise.status === audit.revise.checking) {
  160. throw '修订审批中,不可作废';
  161. } else if (revise.status === audit.revise.checked) {
  162. throw '修订已审批通过,不可作废';
  163. }
  164. if (revise.valid) {
  165. const result = await ctx.service.ledgerRevise.cancelRevise(revise);
  166. }
  167. ctx.redirect('/tender/' + ctx.tender.id + '/revise/');
  168. } catch (err) {
  169. this.log(err);
  170. ctx.redirect(ctx.request.header.referer);
  171. }
  172. }
  173. /**
  174. * 保存 修订详情 (Ajax-post)
  175. * @param ctx
  176. * @return {Promise<void>}
  177. */
  178. async save(ctx) {
  179. try {
  180. const revise = await ctx.service.ledgerRevise.getLastestRevise(ctx.tender.id);
  181. if (!revise.valid) {
  182. throw '该修订已作废';
  183. } else if (revise.status === audit.revise.status.uncheck || revise.status === audit.revise.status.checkNo) {
  184. if (ctx.session.sessionUser.accountId !== revise.uid) {
  185. throw '您无权修改';
  186. }
  187. } else if (revise.status === audit.revise.status.checking) {
  188. throw '修订在审批中,不可修改修订数据';
  189. } else if (revise.staut === audit.revise.status.checked) {
  190. throw '修订已经审批通过,不可修改修订数据,请新增下一修订';
  191. }
  192. const data = JSON.parse(ctx.request.body.data);
  193. if (data.content === undefined) {
  194. throw '保存数据有误';
  195. }
  196. const result = await ctx.service.ledgerRevise.defaultUpdate({ id: revise.id, content: data.content });
  197. if (result.affectedRows !== 1) {
  198. throw '保存数据失败,请重试';
  199. }
  200. ctx.body = { err: 0, msg: '', data: null };
  201. } catch (err) {
  202. this.log(err);
  203. ctx.body = this.ajaxErrorBody(err, '保存数据失败,请重试');
  204. }
  205. }
  206. /**
  207. * 获取SpreadSetting
  208. * @private
  209. */
  210. _getSpreadSetting(revise) {
  211. const _ = this.app._;
  212. function removeFieldCols(setting, cols) {
  213. _.remove(setting.cols, function(c) {
  214. return cols.indexOf(c.field) > -1;
  215. });
  216. }
  217. const tender = this.ctx.tender;
  218. const setting = tender.data.measure_type === measureType.tz.value
  219. ? (tender.info.display.ledger.clQty ? spreadConst.withCl : spreadConst.withoutCl)
  220. : (tender.info.display.ledger.clQty ? spreadConst.withClGcl : spreadConst.withoutClGcl);
  221. const ledger = JSON.parse(JSON.stringify(setting.ledger));
  222. const pos = setting.pos ? JSON.parse(JSON.stringify(setting.pos)) : spreadConst.blank;
  223. if (revise.status === audit.revise.status.checking || revise.status === audit.revise.status.checked) {
  224. ledger.readOnly = true;
  225. pos.readOnly = true;
  226. }
  227. if (tender.data.measure_type === measureType.tz.value) {
  228. removeFieldCols(ledger, spreadConst.filterCols.tzWithoutCols);
  229. }
  230. if (!tender.info.display.ledger.dgnQty) {
  231. removeFieldCols(ledger, spreadConst.filterCols.dgnCols);
  232. }
  233. return [ledger, pos];
  234. }
  235. async _getDefaultReviseInfoData(ctx, revise) {
  236. // const reviseBills = revise.bills_file
  237. // ? JSON.parse(await fs.readFileSync(this.ctx.app.config.filePath + revise.bills_file, 'utf8'))
  238. // : await ctx.service.reviseBills.getData(ctx.tender.id);
  239. // const revisePos = revise.pos_file
  240. // ? JSON.parse(await fs.readFileSync(this.ctx.app.config.filePath + revise.pos_file, 'utf8'))
  241. // : await ctx.service.revisePos.getData(ctx.tender.id);
  242. const [ledgerSpread, posSpread] = this._getSpreadSetting(revise);
  243. const [stdBills, stdChapters] = await this.ctx.service.valuation.getValuationStdList(
  244. ctx.tender.data.valuation, ctx.tender.data.measure_type);
  245. const curAuditor = await ctx.service.reviseAudit.getCurAuditor(revise.id, revise.times);
  246. const auditors = await ctx.service.reviseAudit.getAuditorsWithOwner(revise.id, revise.times);
  247. const user = await ctx.service.projectAccount.getAccountInfoById(revise.uid);
  248. const times = revise.status === audit.revise.status.checkNo ? revise.times - 1 : revise.times;
  249. const auditHistory = [];
  250. if (times >= 1) {
  251. for (let i = 1; i <= times; i++) {
  252. auditHistory.push(await ctx.service.reviseAudit.getAuditors(revise.id, i));
  253. }
  254. }
  255. return {
  256. revise, tender: ctx.tender.data,
  257. // reviseBills, revisePos,
  258. ledgerSpread, posSpread, tenderMenu, measureType,
  259. preUrl: '/tender/' + ctx.tender.id,
  260. audit: audit.revise,
  261. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.revise.info),
  262. stdBills,
  263. auditConst: audit.revise,
  264. stdChapters,
  265. curAuditor,
  266. auditors,
  267. user,
  268. auditHistory,
  269. };
  270. }
  271. /**
  272. * 历史修订页面(修订完成后,用于查看)
  273. * @param ctx
  274. * @param revise
  275. * @return {Promise<void>}
  276. * @private
  277. */
  278. async _getHistoryReviseInfo(ctx, revise) {
  279. const renderData = await this._getDefaultReviseInfoData(ctx, revise);
  280. renderData.ledgerSpread.readOnly = true;
  281. renderData.posSpread.readOnly = true;
  282. renderData.readOnly = true;
  283. renderData.history = true;
  284. renderData.historyRevise = await ctx.service.ledgerRevise.getReviseList(ctx.tender.id);
  285. await this.layout('revise/info.ejs', renderData, 'revise/info_modal.ejs');
  286. }
  287. /**
  288. * 修订页面(草稿,审批中)
  289. * @param ctx
  290. * @param revise
  291. * @return {Promise<void>}
  292. * @private
  293. */
  294. async _getAuditReviseInfo(ctx, revise) {
  295. const renderData = await this._getDefaultReviseInfoData(ctx, revise);
  296. renderData.readOnly = true;
  297. renderData.ledgerSpread.readOnly = true;
  298. renderData.posSpread.readOnly = true;
  299. renderData.history = false;
  300. renderData.historyRevise = [];
  301. renderData.curAuditor = await ctx.service.reviseAudit.getCurAuditor(revise.id, revise.times);
  302. await this.layout('revise/info.ejs', renderData, 'revise/info_modal.ejs');
  303. }
  304. async _getDraftReviseInfo(ctx, revise) {
  305. const renderData = await this._getDefaultReviseInfoData(ctx, revise);
  306. // 台账只读、使用数据
  307. renderData.readOnly = false;
  308. // const lastStage = await ctx.service.stage.getLastestStage(ctx.tender.id, true);
  309. // if (lastStage) {
  310. // if (lastStage.status === audit.stage.status.checked) {
  311. // const usedPreBills = await ctx.service.stageBillsFinal.getUsedBills(ctx.tender.id, lastStage.order);
  312. // for (const b of renderData.reviseBills) {
  313. // b.used = usedPreBills.indexOf(b.id) >= 0;
  314. // }
  315. // const usedPrePos = await ctx.service.stagePosFinal.getUsedPos(ctx.tender.id, lastStage.order);
  316. // for (const p of renderData.revisePos) {
  317. // p.used = usedPrePos.indexOf(p.id) >= 0;
  318. // }
  319. // } else {
  320. // const usedPreBills = lastStage.order > 1 ? await ctx.service.stageBillsFinal.getUsedBills(ctx.tender.id, lastStage.order - 1) : [];
  321. // const usedCurBills = await ctx.service.stageBills.getStageUsedBills(ctx.tender.id, lastStage.id);
  322. // for (const b of renderData.reviseBills) {
  323. // b.used = usedPreBills.indexOf(b.id) >= 0 || usedCurBills.indexOf(b.id) >= 0;
  324. // }
  325. // const usedPrePos = lastStage.order > 1 ? await ctx.service.stagePosFinal.getUsedPos(ctx.tender.id, lastStage.order - 1) : [];
  326. // const usedCurPos = await ctx.service.stagePos.getStageUsedPos(ctx.tender.id, lastStage.id);
  327. // for (const p of renderData.revisePos) {
  328. // p.used = usedPrePos.indexOf(p.id) >= 0 || usedCurPos.indexOf(p.id) >= 0;
  329. // }
  330. // }
  331. // }
  332. // 修订历史
  333. renderData.history = false;
  334. renderData.historyRevise = [];
  335. // 添加审批人相关
  336. // renderData.accountGroup = accountGroup;
  337. renderData.accountList = await ctx.service.projectAccount.getAllDataByCondition({
  338. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  339. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  340. });
  341. renderData.accountGroup = accountGroup.map((item, idx) => {
  342. const groupList = renderData.accountList.filter(item => item.account_group === idx);
  343. return { groupName: item, groupList };
  344. });
  345. renderData.auditorList = await ctx.service.reviseAudit.getAuditors(revise.id, revise.times);
  346. renderData.curAuditor = await ctx.service.reviseAudit.getCurAuditor(revise.id, revise.times);
  347. await this.layout('revise/info.ejs', renderData, 'revise/info_modal.ejs');
  348. }
  349. /**
  350. * 修订 详细页面(Get)
  351. * @param ctx
  352. * @return {Promise<void>}
  353. */
  354. async info(ctx) {
  355. try {
  356. const revise = await ctx.service.ledgerRevise.getLastestRevise(ctx.tender.id);
  357. if (!revise) throw '台账修订数据有误';
  358. if (revise.uid === ctx.session.sessionUser.accountId &&
  359. (revise.status === audit.revise.status.uncheck || revise.status === audit.revise.status.checkNo)) {
  360. await this._getDraftReviseInfo(ctx, revise);
  361. } else if (revise.status === audit.revise.status.checked) {
  362. await this._getHistoryReviseInfo(ctx, revise);
  363. } else {
  364. await this._getAuditReviseInfo(ctx, revise);
  365. }
  366. } catch (err) {
  367. this.log(err);
  368. ctx.redirect(ctx.request.header.referer);
  369. }
  370. }
  371. async loadInfoData(ctx) {
  372. try {
  373. const revise = await ctx.service.ledgerRevise.getLastestRevise(ctx.tender.id);
  374. if (!revise) throw '台账修订数据有误';
  375. const billsFile = revise.status === audit.revise.status.checked && revise.bills_file
  376. ? this.ctx.app.config.filePath + revise.bills_file
  377. : undefined;
  378. const reviseBills = billsFile && fs.existsSync(billsFile)
  379. ? JSON.parse(await fs.readFileSync(billsFile, 'utf8'))
  380. : await ctx.service.reviseBills.getData(ctx.tender.id);
  381. const posFile = revise.status === audit.revise.status.checked && revise.pos_file
  382. ? this.ctx.app.config.filePath + revise.pos_file
  383. : undefined;
  384. const revisePos = posFile && fs.existsSync(posFile)
  385. ? JSON.parse(await fs.readFileSync(posFile, 'utf8'))
  386. : await ctx.service.revisePos.getData(ctx.tender.id);
  387. if (revise.uid === ctx.session.sessionUser.accountId &&
  388. (revise.status === audit.revise.status.uncheck || revise.status === audit.revise.status.checkNo)) {
  389. const lastStage = await ctx.service.stage.getLastestStage(ctx.tender.id, true);
  390. if (lastStage) {
  391. if (lastStage.status === audit.stage.status.checked) {
  392. const usedPreBills = await ctx.service.stageBillsFinal.getUsedBills(ctx.tender.id, lastStage.order);
  393. for (const b of reviseBills) {
  394. b.used = usedPreBills.indexOf(b.id) >= 0;
  395. }
  396. const usedPrePos = await ctx.service.stagePosFinal.getUsedPos(ctx.tender.id, lastStage.order);
  397. for (const p of revisePos) {
  398. p.used = usedPrePos.indexOf(p.id) >= 0;
  399. }
  400. } else {
  401. const usedPreBills = lastStage.order > 1 ? await ctx.service.stageBillsFinal.getUsedBills(ctx.tender.id, lastStage.order - 1) : [];
  402. const usedCurBills = await ctx.service.stageBills.getStageUsedBills(ctx.tender.id, lastStage.id);
  403. for (const b of reviseBills) {
  404. b.used = usedPreBills.indexOf(b.id) >= 0 || usedCurBills.indexOf(b.id) >= 0;
  405. }
  406. const usedPrePos = lastStage.order > 1 ? await ctx.service.stagePosFinal.getUsedPos(ctx.tender.id, lastStage.order - 1) : [];
  407. const usedCurPos = await ctx.service.stagePos.getStageUsedPos(ctx.tender.id, lastStage.id);
  408. for (const p of revisePos) {
  409. p.used = usedPrePos.indexOf(p.id) >= 0 || usedCurPos.indexOf(p.id) >= 0;
  410. }
  411. }
  412. }
  413. }
  414. ctx.body = { err: 0, msg: '', data: { bills: reviseBills, pos: revisePos } };
  415. } catch (err) {
  416. ctx.helper.log(err);
  417. this.ajaxErrorBody(err, '加载台账修订数据错误');
  418. }
  419. }
  420. async checkData(ctx) {
  421. try {
  422. const revise = await ctx.service.ledgerRevise.getLastestRevise(ctx.tender.id);
  423. if (!revise) throw '台账修订数据有误';
  424. const billsFile = revise.bills_file ? this.ctx.app.config.filePath + revise.bills_file : undefined;
  425. const reviseBills = billsFile && fs.existsSync(billsFile)
  426. ? JSON.parse(await fs.readFileSync(billsFile, 'utf8'))
  427. : await ctx.service.reviseBills.getData(ctx.tender.id);
  428. const posFile = revise.pos_file ? this.ctx.app.config.filePath + revise.pos_file : undefined;
  429. const revisePos = posFile && fs.existsSync(posFile)
  430. ? JSON.parse(await fs.readFileSync(posFile, 'utf8'))
  431. : await ctx.service.revisePos.getData(ctx.tender.id);
  432. const data = ctx.helper.checkBillsWithPos(reviseBills, revisePos,
  433. ['sgfh_qty', 'qtcl_qty', 'sjcl_qty', 'quantity']);
  434. ctx.body = { err: 0, msg: '', data };
  435. } catch (err) {
  436. this.log(err);
  437. ctx.body = this.ajaxErrorBody(err, '检查数据错误');
  438. }
  439. }
  440. async history(ctx) {
  441. try {
  442. const revise = await ctx.service.ledgerRevise.getLastestRevise(ctx.tender.id, false);
  443. if (!revise) throw '台账修订数据有误';
  444. // const reviseBills = await ctx.service.ledger.getData(ctx.tender.id);
  445. // const revisePos = await ctx.service.pos.getPosData({tid: ctx.tender.id});
  446. const [ledgerSpread, posSpread] = this._getSpreadSetting(revise);
  447. ledgerSpread.readOnly = true;
  448. posSpread.readOnly = true;
  449. const historyRevise = await ctx.service.ledgerRevise.getReviseList(ctx.tender.id);
  450. const renderData = {
  451. measureType, audit, revise,
  452. ledgerSpread, posSpread,
  453. // reviseBills, revisePos,
  454. readOnly: true,
  455. historyRevise,
  456. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.revise.history),
  457. };
  458. await this.layout('revise/history.ejs', renderData);
  459. } catch (err) {
  460. this.log(err);
  461. ctx.redirect(ctx.request.header.referer);
  462. }
  463. }
  464. async historyInfo(ctx) {
  465. try {
  466. const data = JSON.parse(ctx.request.body.data);
  467. if (!data || !data.rid || data.rid === '') throw '查询的台账修订有误';
  468. const reviseInfo = await ctx.service.ledgerRevise.getRevise(ctx.tender.id, data.rid);
  469. reviseInfo.end_time_str = reviseInfo.end_time ? reviseInfo.end_time.toLocaleString() : '';
  470. ctx.body = { err: 0, msg: '', data: reviseInfo };
  471. } catch (err) {
  472. this.log(err);
  473. ctx.body = this.ajaxErrorBody(err, '获取台账修订历史数据错误');
  474. }
  475. }
  476. /**
  477. * 加载 数据
  478. * @param {} ctx
  479. */
  480. async loadHistoryData(ctx) {
  481. try {
  482. const revise = await ctx.service.ledgerRevise.getLastestRevise(ctx.tender.id, false);
  483. if (!revise) throw '台账修订数据有误';
  484. const reviseBills = await ctx.service.ledger.getData(ctx.tender.id);
  485. const revisePos = await ctx.service.pos.getPosData({ tid: ctx.tender.id });
  486. ctx.body = { err: 0, msg: '', data: { bills: reviseBills, pos: revisePos } };
  487. } catch (error) {
  488. ctx.helper.log(error);
  489. this.ajaxErrorBody(error, '获取台账修订数据错误,请刷新页面');
  490. }
  491. }
  492. async checkRevise(ctx) {
  493. const revise = await ctx.service.ledgerRevise.getLastestRevise(ctx.tender.id);
  494. if (revise.uid !== ctx.session.sessionUser.accountId) {
  495. throw '修订数据错误';
  496. } else if (revise.status === audit.revise.status.checking) {
  497. throw '修订审批中,不可修改';
  498. } else if (revise.status === audit.revise.status.checked) {
  499. throw '修订已完成,如需修订台账,请新增修订';
  500. }
  501. return revise;
  502. }
  503. async _billsBase(revise, type, data) {
  504. if (isNaN(data.id) || data.id <= 0) throw '数据错误';
  505. if (type !== 'add') {
  506. if (isNaN(data.count) || data.count <= 0) data.count = 1;
  507. }
  508. switch (type) {
  509. case 'add':
  510. return await this.ctx.service.reviseBills.addReviseNode(revise.tid, revise.id, data.id, data.count);
  511. case 'delete':
  512. return await this.ctx.service.reviseBills.delete(revise.tid, data.id, data.count);
  513. case 'up-move':
  514. return await this.ctx.service.reviseBills.upMoveNode(revise.tid, data.id, data.count);
  515. case 'down-move':
  516. return await this.ctx.service.reviseBills.downMoveNode(revise.tid, data.id, data.count);
  517. case 'up-level':
  518. return await this.ctx.service.reviseBills.upLevelNode(revise.tid, data.id, data.count);
  519. case 'down-level':
  520. return await this.ctx.service.reviseBills.downLevelNode(revise.tid, data.id, data.count);
  521. }
  522. }
  523. async _batchInsert(revise, data) {
  524. if ((isNaN(data.id) || data.id <= 0) || !data.batchType) {
  525. throw '参数错误';
  526. }
  527. switch (data.batchType) {
  528. case 'child':
  529. return await this.ctx.service.reviseBills.batchInsertChild(revise.tid, revise.id, data.id, data.batchData);
  530. case 'next':
  531. return await this.ctx.service.reviseBills.batchInsertNext(revise.tid, revise.id, data.id, data.batchData);
  532. default:
  533. throw '参数错误';
  534. }
  535. }
  536. async _pasteBlock(revise, data) {
  537. if ((isNaN(data.id) || data.id <= 0) ||
  538. (!data.tid && data.tid <= 0) ||
  539. (!data.block || data.block.length <= 0)) throw '参数错误';
  540. return await this.ctx.service.reviseBills.pasteBlockData(this.ctx.tender.id, data.id, data.block, { crid: revise.id });
  541. }
  542. async _addStd(revise, data) {
  543. if ((isNaN(data.id) || data.id <= 0) || !data.stdType || !data.stdNode) throw '参数错误';
  544. // todo 校验项目是否使用该库的权限
  545. let stdLib,
  546. addType;
  547. switch (data.stdType) {
  548. case 'xmj':
  549. stdLib = this.ctx.service.stdXmj;
  550. addType = stdDataAddType.withParent;
  551. break;
  552. case 'gcl':
  553. stdLib = this.ctx.service.stdGcl;
  554. const selectNode = await this.ctx.service.reviseBills.getDataByKid(revise.tid, data.id);
  555. if (selectNode.b_code) {
  556. addType = stdDataAddType.next;
  557. } else {
  558. addType = stdDataAddType.child;
  559. }
  560. break;
  561. default:
  562. throw '未知标准库';
  563. }
  564. const stdData = await stdLib.getDataByDataId(data.stdLibId, data.stdNode);
  565. switch (addType) {
  566. case stdDataAddType.child:
  567. break;
  568. case stdDataAddType.next:
  569. return await this.ctx.service.reviseBills.addStdNode(revise.tid, data.id, stdData, revise.id);
  570. case stdDataAddType.withParent:
  571. return await this.ctx.service.reviseBills.addStdNodeWithParent(revise.tid, stdData, stdLib, revise.id);
  572. default:
  573. throw '未知添加方式';
  574. }
  575. }
  576. async _addDeal(revise, data) {
  577. if (!data.type || !data.dealBills) throw '数据错误';
  578. data.dealBills.unit_price = this.ctx.helper.round(data.dealBills.unit_price, this.ctx.tender.info.decimal.up);
  579. if (data.type === 'child') {
  580. return await this.ctx.service.reviseBills.addChild(revise.tid, data.id, data.dealBills, revise.id);
  581. } else if (data.type === 'next') {
  582. return await this.ctx.service.reviseBills.addBillsNode(revise.tid, data.id, data.dealBills, revise.id);
  583. }
  584. throw '数据错误';
  585. }
  586. async _addBg(revise, data) {
  587. if (!data.type || !data.bgBills) throw '数据错误';
  588. data.bgBills.unit_price = this.ctx.helper.round(data.bgBills.unit_price, this.ctx.tender.info.decimal.up);
  589. if (data.type === 'child') {
  590. return await this.ctx.service.reviseBills.addChild(revise.tid, data.id, data.bgBills, revise.id);
  591. } else if (data.type === 'next') {
  592. return await this.ctx.service.reviseBills.addBillsNode(revise.tid, data.id, data.bgBills, revise.id);
  593. }
  594. throw '数据错误';
  595. }
  596. async _updatePos(revise, data) {
  597. await this.checkMeasureType(measureType.tz.value);
  598. if (!data.posPostType) throw '数据错误';
  599. switch (data.posPostType) {
  600. case 'add':
  601. return await this.ctx.service.revisePos.addPos(revise.tid, revise.id, data.postData);
  602. case 'update':
  603. if (data.postData instanceof Array) {
  604. return await this.ctx.service.revisePos.updatePosArr(revise.tid, data.postData);
  605. }
  606. return await this.ctx.service.revisePos.updatePos(revise.tid, data.postData);
  607. case 'delete':
  608. return await this.ctx.service.revisePos.deletePos(revise.tid, data.postData);
  609. case 'paste':
  610. return await this.ctx.service.revisePos.pastePosData(revise.tid, revise.id, data.postData);
  611. default:
  612. throw '未知操作';
  613. }
  614. }
  615. async update(ctx) {
  616. try {
  617. if (!ctx.tender.data) throw '标段数据错误';
  618. const data = JSON.parse(ctx.request.body.data);
  619. if (!data.postType || !data.postData) throw '数据错误';
  620. const responseData = { err: 0, msg: '', data: {} };
  621. const revise = await this.checkRevise(ctx);
  622. switch (data.postType) {
  623. case 'add':
  624. case 'delete':
  625. case 'up-move':
  626. case 'down-move':
  627. case 'up-level':
  628. case 'down-level':
  629. responseData.data = await this._billsBase(revise, data.postType, data.postData);
  630. break;
  631. case 'update':
  632. responseData.data = await this.ctx.service.reviseBills.updateCalc(revise.tid, data.postData);
  633. break;
  634. case 'batch-insert':
  635. responseData.data = await this._batchInsert(revise, data.postData);
  636. break;
  637. case 'add-deal':
  638. responseData.data = await this._addDeal(revise, data.postData);
  639. break;
  640. case 'add-bg':
  641. responseData.data = await this._addDeal(revise, data.postData);
  642. break;
  643. case 'add-std':
  644. responseData.data = await this._addStd(revise, data.postData);
  645. break;
  646. case 'paste-block':
  647. responseData.data = await this._pasteBlock(revise, data.postData);
  648. break;
  649. case 'pos':
  650. responseData.data = await this._updatePos(revise, data);
  651. break;
  652. default:
  653. throw '未知操作';
  654. }
  655. ctx.body = responseData;
  656. } catch (err) {
  657. this.log(err);
  658. ctx.body = this.ajaxErrorBody(err, '数据错误');
  659. }
  660. }
  661. /**
  662. * 上传 清单Excel 并导入
  663. * @param ctx
  664. * @return {Promise<void>}
  665. */
  666. async uploadExcel(ctx) {
  667. try {
  668. const revise = await this.checkRevise(ctx);
  669. const ueType = ctx.params.ueType;
  670. const compressData = ctx.request.body.data;
  671. const data = JSON.parse(LzString.decompressFromUTF16(compressData));
  672. const responseData = { err: 0, msg: '', data: {} };
  673. switch (ueType) {
  674. case 'gcl2xmj':
  675. responseData.data = await ctx.service.reviseBills.importGclExcel(data.id, data.sheet, { crid: revise.id });
  676. break;
  677. }
  678. ctx.body = responseData;
  679. } catch (err) {
  680. this.log(err);
  681. ctx.body = { err: 1, msg: err.toString(), data: null };
  682. }
  683. }
  684. /**
  685. * 填设计量(Ajax)
  686. *
  687. * @param ctx
  688. * @return {Promise<void>}
  689. */
  690. async deal2sgfh(ctx) {
  691. try {
  692. const revise = await this.checkRevise(ctx);
  693. if (this.ctx.tender.measure_type === measureType.tz.value) throw '该功能仅工程量清单模式可用';
  694. await this.ctx.service.revise.deal2sgfh(ctx.tender.id);
  695. const ledgerData = await ctx.service.revise.getData(ctx.tender.id);
  696. ctx.body = { err: 0, msg: '', data: { bills: ledgerData } };
  697. } catch (err) {
  698. this.log(err);
  699. ctx.body = { err: 1, msg: err.toString(), data: null };
  700. }
  701. }
  702. /**
  703. * 新增审批人(Ajax)
  704. *
  705. * @param ctx
  706. * @return {Promise<void>}
  707. */
  708. async addAuditor(ctx) {
  709. try {
  710. const data = JSON.parse(ctx.request.body.data);
  711. const id = data.auditorId;
  712. if (isNaN(id) || id <= 0) {
  713. throw '参数错误';
  714. }
  715. const revise = await ctx.service.ledgerRevise.getLastestRevise(ctx.tender.id);
  716. if (!revise) throw '台账修订数据有误';
  717. // 检查权限等
  718. if (revise.uid !== ctx.session.sessionUser.accountId) throw '您无权添加审核人';
  719. if (revise.status === audit.revise.status.checking || revise.status === audit.revise.status.checked) {
  720. throw '当前不允许添加审核人';
  721. }
  722. // 检查审核人是否已存在
  723. const exist = await ctx.service.reviseAudit.getAuditor(revise.id, id, revise.times);
  724. if (exist) throw '该审核人已存在,请勿重复添加';
  725. const result = await ctx.service.reviseAudit.addAuditor(revise, id);
  726. if (!result) throw '添加审核人失败';
  727. const resultData = await ctx.service.reviseAudit.getAuditor(revise.id, id, revise.times);
  728. ctx.body = { err: 0, msg: '', data: resultData };
  729. } catch (err) {
  730. this.log(err, '数据错误');
  731. ctx.body = this.ajaxErrorBody(err);
  732. }
  733. }
  734. /**
  735. * 移除审批人(Ajax)
  736. *
  737. * @param ctx
  738. * @return {Promise<void>}
  739. */
  740. async removeAuditor(ctx) {
  741. try {
  742. const data = JSON.parse(ctx.request.body.data);
  743. const id = data.auditorId instanceof Number ? data.auditorId : this.app._.toNumber(data.auditorId);
  744. if (isNaN(id) || id <= 0) {
  745. throw '参数错误';
  746. }
  747. const revise = await ctx.service.ledgerRevise.getLastestRevise(ctx.tender.id);
  748. if (!revise) throw '台账修订数据有误';
  749. const result = await ctx.service.reviseAudit.deleteAuditor(revise, id);
  750. if (!result) {
  751. throw '移除审核人失败';
  752. }
  753. const resultData = await ctx.service.reviseAudit.getAuditors(revise.id, revise.times);
  754. ctx.body = { err: 0, msg: '', data: resultData };
  755. } catch (err) {
  756. this.log(err, '数据错误');
  757. ctx.body = this.ajaxErrorBody(err);
  758. }
  759. }
  760. /**
  761. * 上报(ajax-post)
  762. *
  763. * @param ctx
  764. * @return {Promise<void>}
  765. */
  766. async start(ctx) {
  767. try {
  768. const revise = await ctx.service.ledgerRevise.getLastestRevise(ctx.tender.id);
  769. if (!revise || revise.status === audit.revise.status.checking || revise.status === audit.revise.status.checked) {
  770. throw '台账修订数据有误';
  771. }
  772. if (revise.content === '') {
  773. throw '未填写修订内容,请先填写并保存修订内容';
  774. }
  775. if (revise.uid !== ctx.session.sessionUser.accountId) throw '上报失败';
  776. await ctx.service.reviseAudit.start(revise, revise.times);
  777. ctx.redirect('/tender/' + ctx.tender.id + '/revise/info');
  778. // ctx.body = { err: 0, msg: '', data: {} };
  779. } catch (err) {
  780. this.log(err);
  781. // ctx.body = this.ajaxErrorBody(err, '上报失败');
  782. this.postError(err, '审批失败');
  783. ctx.redirect('/tender/' + ctx.tender.id + '/revise/info');
  784. }
  785. }
  786. /**
  787. * 审批(post)
  788. *
  789. * @param ctx
  790. * @return {Promise<void>}
  791. */
  792. async check(ctx) {
  793. try {
  794. const revise = await ctx.service.ledgerRevise.getLastestRevise(ctx.tender.id);
  795. if (!revise || revise.status !== audit.revise.status.checking) throw '台账修订数据有误';
  796. const curAudit = await ctx.service.reviseAudit.getCurAuditor(revise.id, revise.times);
  797. if (curAudit.audit_id !== ctx.session.sessionUser.accountId) throw '审批失败';
  798. const checkType = parseInt(ctx.request.body.checkType);
  799. if (!checkType || isNaN(checkType)) throw '提交数据错误';
  800. await ctx.service.reviseAudit.check(revise, checkType, ctx.request.body.opinion, revise.times);
  801. ctx.redirect('/tender/' + ctx.tender.id + '/revise/info');
  802. } catch (err) {
  803. this.log(err);
  804. this.postError(err, '审批失败');
  805. ctx.redirect('/tender/' + ctx.tender.id + '/revise/info');
  806. }
  807. }
  808. }
  809. return ReviseController;
  810. };