revise_controller.js 41 KB

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