revise_controller.js 41 KB

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