tender_controller.js 50 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098
  1. 'use strict';
  2. /**
  3. * 标段管理控制器
  4. *
  5. * @author CaiAoLin
  6. * @date 2018/2/5
  7. * @version
  8. */
  9. const tenderConst = require('../const/tender');
  10. const codeRuleConst = require('../const/code_rule');
  11. const settingConst = require('../const/setting.js');
  12. const tenderMenu = require('../../config/menu').tenderMenu;
  13. const auditConst = require('../const/audit');
  14. const shenpiConst = require('../const/shenpi');
  15. const accountGroup = require('../const/account_group').group;
  16. const accountPermission = require('../const/account_permission');
  17. const measureType = require('../const/tender').measureType;
  18. const billsPosConvert = require('../lib/bills_pos_convert');
  19. const path = require('path');
  20. const sendToWormhole = require('stream-wormhole');
  21. const scheduleConst = require('../const/schedule');
  22. module.exports = app => {
  23. class TenderController extends app.BaseController {
  24. /**
  25. * 构造函数
  26. *
  27. * @param {Object} ctx - egg全局变量
  28. * @return {void}
  29. */
  30. constructor(ctx) {
  31. super(ctx);
  32. ctx.showProject = true;
  33. ctx.showTitle = true;
  34. }
  35. async _getLedgerAuditInfo(tender) {
  36. tender.cur_flow = {
  37. title: '台账',
  38. status: auditConst.ledger.tiStatusString[tender.ledger_status],
  39. status_class: auditConst.ledger.tiStatusStringClass[tender.ledger_status],
  40. };
  41. if (tender.ledger_status === auditConst.ledger.status.uncheck) {
  42. tender.cur_flow.name = tender.user_name;
  43. } else {
  44. const cur = tender.ledger_status === auditConst.ledger.status.checkNo
  45. ? await this.ctx.service.ledgerAudit.getLastestAuditor(tender.id, tender.ledger_times - 1, auditConst.ledger.status.checkNo)
  46. : await this.ctx.service.ledgerAudit.getLastestAuditor(tender.id, tender.ledger_times, tender.ledger_status);
  47. if (cur) {
  48. tender.cur_flow.name = cur.name;
  49. if (cur.audit_order === 1) {
  50. tender.pre_flow = { name: tender.user_name, time: cur.begin_time };
  51. } else {
  52. const pre = await this.ctx.service.ledgerAudit.getAuditorByOrder(tender.id, cur.audit_order - 1, cur.times);
  53. if (pre) tender.pre_flow = { name: pre.name, time: pre.end_time };
  54. }
  55. } else {
  56. tender.cur_flow.name = '';
  57. }
  58. }
  59. }
  60. async _getStageAuditInfo(tender, stage) {
  61. tender.cur_flow = {
  62. title: '第' + stage.order + '期',
  63. status: auditConst.stage.tiStatusString[stage.status],
  64. status_class: auditConst.stage.tiStatusStringClass[stage.status],
  65. };
  66. if (stage.status === auditConst.stage.status.uncheck) {
  67. if (tender.user_id === stage.user_id) {
  68. tender.cur_flow.name = tender.user_name;
  69. } else {
  70. const user = await this.ctx.service.projectAccount.getDataById(stage.user_id);
  71. tender.cur_flow.name = user.name;
  72. }
  73. if (stage.order > 1) {
  74. const preStage = await this.ctx.service.stage.getDataByCondition({ tid: tender.id, order: stage.order - 1 });
  75. if (!preStage) return;
  76. const pre = await this.ctx.service.stageAudit.getLastestAuditor(preStage.id, preStage.times, auditConst.stage.status.checked);
  77. if (pre) tender.pre_flow = { name: pre.name, time: pre.end_time };
  78. }
  79. } else {
  80. let cur;
  81. if (stage.status === auditConst.stage.status.checkNo) {
  82. cur = await this.ctx.service.stageAudit.getLastestAuditor(stage.id, stage.times - 1, auditConst.stage.status.checkNo);
  83. } else if (stage.status === auditConst.stage.status.checked) {
  84. cur = await this.ctx.service.stageAudit.getLastestAuditor(stage.id, stage.times, auditConst.stage.status.checked);
  85. } else {
  86. cur = await this.ctx.service.stageAudit.getCurAuditor(stage.id, stage.times);
  87. }
  88. if (cur) {
  89. tender.cur_flow.name = cur.name;
  90. if (cur.order === 1) {
  91. tender.pre_flow = {};
  92. if (tender.user_id === stage.user_id) {
  93. tender.pre_flow.name = tender.user_name;
  94. } else {
  95. const user = await this.ctx.service.projectAccount.getDataById(stage.user_id);
  96. tender.pre_flow.name = user.name;
  97. }
  98. tender.pre_flow.time = cur.begin_time;
  99. } else {
  100. const pre = await this.ctx.service.stageAudit.getAuditorByOrder(stage.id, cur.order - 1, cur.times);
  101. if (pre) tender.pre_flow = { name: pre.name, time: pre.end_time };
  102. }
  103. } else {
  104. tender.cur_flow.name = '';
  105. }
  106. }
  107. }
  108. async _listDetail(view, modal = '') {
  109. try {
  110. // 获取用户新建标段权利
  111. const accountInfo = await this.ctx.service.projectAccount.getDataById(this.ctx.session.sessionUser.accountId);
  112. const userPermission = accountInfo !== undefined && accountInfo.permission !== ''
  113. ? JSON.parse(accountInfo.permission) : null;
  114. const tenderList = await this.ctx.service.tender.getList('', userPermission, this.ctx.session.sessionUser.is_admin);
  115. for (const t of tenderList) {
  116. if (t.user_id === this.ctx.session.sessionUser.accountId && (
  117. t.ledger_status === auditConst.ledger.status.checkNo || t.ledger_status === auditConst.ledger.status.uncheck)) {
  118. const sum = await this.ctx.service.ledger.addUp({ tender_id: t.id/* , is_leaf: true*/ });
  119. t.total_price = sum.total_price;
  120. t.deal_tp = sum.deal_tp;
  121. }
  122. t.advance_tp = await this.ctx.service.advance.getSumAdvance(t.id);
  123. if (t.ledger_status === auditConst.ledger.status.checked) {
  124. t.lastStage = await this.ctx.service.stage.getLastestStage(t.id, true);
  125. if (t.lastStage && t.lastStage.status === auditConst.stage.status.uncheck &&
  126. t.lastStage.user_id !== this.ctx.session.sessionUser.accountId) {
  127. t.lastStage = await this.ctx.service.stage.getLastestStage(t.id);
  128. }
  129. if (t.lastStage) await this.ctx.service.stage.checkStageGatherData(t.lastStage);
  130. t.completeStage = await this.ctx.service.stage.getLastestCompleteStage(t.id);
  131. }
  132. if (t.lastStage) {
  133. await this._getStageAuditInfo(t, t.lastStage);
  134. } else {
  135. await this._getLedgerAuditInfo(t);
  136. }
  137. }
  138. const categoryData = await this.ctx.service.category.getAllCategory(this.ctx.session.sessionProject.id);
  139. const valuations = await this.ctx.service.valuation.getProjectValidValuation(this.ctx.session.sessionProject.id);
  140. const renderData = {
  141. tenderList,
  142. tenderConst,
  143. settingConst,
  144. categoryData,
  145. measureType: tenderConst.measureType,
  146. jsFiles: this.app.jsFiles.common.concat(this.jsFiles),
  147. auditConst,
  148. userPermission,
  149. valuations,
  150. uid: this.ctx.session.sessionUser.accountId,
  151. pid: this.ctx.session.sessionProject.id,
  152. };
  153. await this.layout(view, renderData, modal);
  154. } catch (err) {
  155. this.log(err);
  156. this.ctx.redirect('/dashboard');
  157. }
  158. }
  159. async _list(view, renderData, modal = '', list_status = '') {
  160. try {
  161. renderData.tenderList = await this.ctx.service.tender.getList(list_status, renderData.userPermission, this.ctx.session.sessionUser.is_admin);
  162. for (const t of renderData.tenderList) {
  163. if (t.ledger_status === auditConst.ledger.status.checked) {
  164. t.lastStage = await this.ctx.service.stage.getLastestStage(t.id, true);
  165. t.completeStage = await this.ctx.service.stage.getLastestCompleteStage(t.id);
  166. }
  167. if (t.lastStage) {
  168. if (t.lastStage.status === auditConst.stage.status.uncheck) {
  169. const status_name = await this.ctx.service.projectAccount.getAccountInfoById(t.lastStage.user_id);
  170. t.status_users = status_name ? status_name.name : '';
  171. // const status_name = await this.ctx.service.stageAudit.getStatusName(t.lastStage.id, t.lastStage.times - 1);
  172. // t.status_users = status_name ? status_name.name : '';
  173. } else {
  174. const status_name = await this.ctx.service.stageAudit.getAuditorByStatus(t.lastStage.id, t.lastStage.status, t.lastStage.times);
  175. t.status_users = status_name ? status_name.name : '';
  176. }
  177. } else {
  178. if (t.ledger_status !== auditConst.ledger.status.uncheck) {
  179. const status_name = await this.ctx.service.ledgerAudit.getStatusName(t.id, t.ledger_times);
  180. t.status_users = status_name ? status_name.name : '';
  181. }
  182. }
  183. }
  184. renderData.categoryData = await this.ctx.service.category.getAllCategory(this.ctx.session.sessionProject.id);
  185. renderData.valuations = await this.ctx.service.valuation.getProjectValidValuation(this.ctx.session.sessionProject.id);
  186. renderData.tenderConst = tenderConst;
  187. renderData.settingConst = settingConst;
  188. renderData.measureType = tenderConst.measureType;
  189. renderData.jsFiles = this.app.jsFiles.common.concat(this.jsFiles);
  190. renderData.auditConst = auditConst;
  191. renderData.uid = this.ctx.session.sessionUser.accountId;
  192. renderData.pid = this.ctx.session.sessionProject.id;
  193. await this.layout(view, renderData, modal);
  194. } catch (err) {
  195. this.log(err);
  196. this.ctx.redirect('/dashboard');
  197. }
  198. }
  199. async listDefault(ctx) {
  200. this.jsFiles = this.app.jsFiles.tender.list;
  201. const accountInfo = await this.ctx.service.projectAccount.getDataById(this.ctx.session.sessionUser.accountId);
  202. const userPermission = accountInfo !== undefined && accountInfo.permission !== '' ? JSON.parse(accountInfo.permission) : null;
  203. const renderData = {
  204. accountInfo,
  205. userPermission,
  206. };
  207. await this._list('tender/index.ejs', renderData, 'tender/modal.ejs');
  208. }
  209. /**
  210. * 标段概况(Get)
  211. *
  212. * @param {object} ctx - egg全局变量
  213. * @return {void}
  214. */
  215. async listInfo(ctx) {
  216. this.jsFiles = this.app.jsFiles.tender.info;
  217. await this._listDetail('tender/info.ejs', 'tender/modal.ejs');
  218. }
  219. /**
  220. * 计量进度(Get)
  221. *
  222. * @param ctx
  223. * @return {Promise<void>}
  224. */
  225. async listProgress(ctx) {
  226. this.jsFiles = this.app.jsFiles.tender.progress;
  227. await this._listDetail('tender/progress.ejs', 'tender/modal.ejs');
  228. }
  229. /**
  230. * 标段管理(Get)
  231. *
  232. * @param ctx
  233. * @return {Promise<void>}
  234. */
  235. async listManage(ctx) {
  236. this.jsFiles = this.app.jsFiles.tender.manage;
  237. // 先判断权限
  238. // 获取用户新建标段权利
  239. const accountInfo = await this.ctx.service.projectAccount.getDataById(this.ctx.session.sessionUser.accountId);
  240. const userPermission = accountInfo !== undefined && accountInfo.permission !== '' ? JSON.parse(accountInfo.permission) : null;
  241. if (userPermission !== null && userPermission.tender !== undefined && userPermission.tender.indexOf('1') !== -1) {
  242. const renderData = {
  243. accountInfo,
  244. userPermission,
  245. };
  246. await this._list('tender/manage.ejs', renderData, 'tender/manage_modal.ejs', 'manage');
  247. // 获取用户新建标段权利
  248. // const accountInfo = await this.ctx.service.projectAccount.getDataById(this.ctx.session.sessionUser.accountId);
  249. // const userPermission = accountInfo !== undefined && accountInfo.permission !== '' ? JSON.parse(accountInfo.permission) : null;
  250. //
  251. // const tenderList = await this.ctx.service.tender.getList('manage', userPermission);
  252. // for (const t of tenderList) {
  253. // t.lastStage = await this.ctx.service.stage.getLastestStage(t.id, true);
  254. // t.completeStage = await this.ctx.service.stage.getLastestCompleteStage(t.id);
  255. // }
  256. // const categoryData = await this.ctx.service.category.getAllCategory(this.ctx.session.sessionProject.id);
  257. // const valuations = await this.ctx.service.valuation.getProjectValidValuation(this.ctx.session.sessionProject.id);
  258. // const renderData = {
  259. // tenderList,
  260. // tenderConst,
  261. // settingConst,
  262. // categoryData,
  263. // measureType: tenderConst.measureType,
  264. // jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.tender.manage),
  265. // auditConst,
  266. // userPermission,
  267. // valuations,
  268. // };
  269. // await this.layout('tender/manage.ejs', renderData, 'tender/manage_modal.ejs');
  270. } else {
  271. this.ctx.redirect(ctx.request.header.referer);
  272. }
  273. }
  274. async listLoad(ctx) {
  275. try {
  276. const data = JSON.parse(ctx.request.body.data);
  277. if (!data.tid && !data.lid && !data.type) throw '数据错误';
  278. const responseData = {
  279. err: 0,
  280. msg: '',
  281. data: { ledgerAuditConst: auditConst.ledger, stageAuditConst: auditConst.stage },
  282. };
  283. responseData.data.category = await this.ctx.service.category.getAllCategory(this.ctx.session.sessionProject.id);
  284. // 获取用户权限
  285. const accountInfo = await this.ctx.service.projectAccount.getDataById(this.ctx.session.sessionUser.accountId);
  286. const userPermission = accountInfo !== undefined && accountInfo.permission !== '' ? JSON.parse(accountInfo.permission) : null;
  287. const tenderList = await this.ctx.service.tender.getList('', userPermission);
  288. for (const t of tenderList) {
  289. if (t.ledger_status === auditConst.ledger.status.checked) {
  290. t.lastStage = await this.ctx.service.stage.getLastestStage(t.id, false);
  291. }
  292. }
  293. if (data.type === 'ledger') {
  294. responseData.data.tenders = tenderList.filter(x => {
  295. return x.ledger_status === auditConst.ledger.status.checked;
  296. });
  297. const history = await this.ctx.service.sumLoadHistory.getLedgerHistory(data.tid, data.lid);
  298. if (history) responseData.data.history = { tenders: history.tender, load_time: history.load_time, type: 'ledger' };
  299. } else if (data.type === 'stage') {
  300. responseData.data.tenders = tenderList.filter(x => {
  301. return x.ledger_status === auditConst.ledger.status.checked && !!x.lastStage;
  302. });
  303. let history = await this.ctx.service.sumLoadHistory.getStageHistory(data.tid, data.lid);
  304. if (history) {
  305. responseData.data.history = { tenders: history.tender, load_time: history.load_time, type: 'stage' };
  306. } else {
  307. history = await this.ctx.service.sumLoadHistory.getReviseHistory(data.tid, data.lid);
  308. if (history) {
  309. responseData.data.history = { tenders: history.tender, load_time: history.load_time, type: 'revise' };
  310. } else {
  311. history = await this.ctx.service.sumLoadHistory.getLedgerHistory(data.tid, data.lid);
  312. if (history) responseData.data.history = { tenders: history.tender, load_time: history.load_time, type: 'ledger' };
  313. }
  314. }
  315. } else if (data.type === 'revise') {
  316. responseData.data.tenders = tenderList.filter(x => {
  317. return x.ledger_status === auditConst.ledger.status.checked;
  318. });
  319. let history = await this.ctx.service.sumLoadHistory.getReviseHistory(data.tid, data.lid);
  320. if (history) {
  321. responseData.data.history = { tenders: history.tender, load_time: history.load_time, type: 'revise' };
  322. } else {
  323. history = await this.ctx.service.sumLoadHistory.getLedgerHistory(data.tid, data.lid);
  324. if (history) responseData.data.history = { tenders: history.tender, load_time: history.load_time, type: 'ledger' };
  325. }
  326. }
  327. ctx.body = responseData;
  328. } catch(err) {
  329. this.log(err);
  330. this.ajaxErrorBody(err, '获取标段列表错误');
  331. }
  332. }
  333. /**
  334. * 新增标段(Ajax)
  335. *
  336. * @param ctx
  337. * @return {Promise<void>}
  338. */
  339. async addTender(ctx) {
  340. try {
  341. const responseData = {
  342. err: 0, msg: '', data: null,
  343. };
  344. // 获取用户新建标段权利
  345. const accountInfo = await this.ctx.service.projectAccount.getDataById(this.ctx.session.sessionUser.accountId);
  346. const userPermission = accountInfo !== undefined && accountInfo.permission !== '' ? JSON.parse(accountInfo.permission) : null;
  347. if (userPermission === null || userPermission.tender === undefined || userPermission.tender.indexOf('1') === -1) {
  348. throw '当前用户没有创建标段的权限';
  349. }
  350. const data = JSON.parse(ctx.request.body.data);
  351. if (!data.name || data.name === '' || !data.valuation) {
  352. throw '标段信息不完整';
  353. }
  354. responseData.data = await ctx.service.tender.add(data);
  355. ctx.body = responseData;
  356. } catch (error) {
  357. this.log(error);
  358. ctx.body = { err: 1, msg: error.toString(), data: null };
  359. }
  360. }
  361. /**
  362. * 编辑标段(Ajax)
  363. *
  364. * @param ctx
  365. * @return {Promise<void>}
  366. */
  367. async updateTender(ctx) {
  368. try {
  369. const responseData = {
  370. err: 0, msg: '', data: null,
  371. };
  372. const data = JSON.parse(ctx.request.body.data);
  373. if (!data.id) {
  374. throw '提交信息错误';
  375. }
  376. if (!data.name || data.name === '') {
  377. throw '标段信息不完整';
  378. }
  379. if (await ctx.service.tender.save(data, data.id)) {
  380. responseData.data = await ctx.service.tender.getTender(data.id);
  381. }
  382. ctx.body = responseData;
  383. } catch (error) {
  384. this.log(error);
  385. ctx.body = { err: 1, msg: error.toString(), data: null };
  386. }
  387. }
  388. /**
  389. * 删除标段(Ajax)
  390. *
  391. * @param ctx
  392. * @return {Promise<void>}
  393. */
  394. async deleteTender(ctx) {
  395. try {
  396. const data = JSON.parse(ctx.request.body.data),
  397. result = [];
  398. if (!(data instanceof Array) && (data.length === 0)) {
  399. throw '提交数据有误';
  400. }
  401. for (const id of data) {
  402. if (await ctx.service.tender.deleteTenderNoBackup(id)) {
  403. result.push(id);
  404. }
  405. }
  406. ctx.body = { err: 0, msg: '', data: result };
  407. } catch (err) {
  408. ctx.body = { err: 1, msg: err.toString(), data: [] };
  409. }
  410. }
  411. /**
  412. * 标段概况(Get)
  413. *
  414. * @param ctx
  415. * @return {Promise<void>}
  416. */
  417. async tenderInfo(ctx) {
  418. try {
  419. const tender = ctx.tender.data;
  420. if (tender.user_id === this.ctx.session.sessionUser.accountId && (
  421. tender.ledger_status === auditConst.ledger.status.checkNo || tender.ledger_status === auditConst.ledger.status.uncheck)) {
  422. const sum = await this.ctx.service.ledger.addUp({ tender_id: tender.id/* , is_leaf: true*/ });
  423. tender.total_price = sum.total_price;
  424. tender.deal_tp = sum.deal_tp;
  425. }
  426. const stages = await ctx.service.stage.getValidStages(ctx.tender.id);
  427. const lastStage = stages.length > 0 ? stages[0] : null; // await ctx.service.stage.getLastestStage(ctx.tender.id);
  428. if (lastStage) {
  429. await this.ctx.service.stage.checkStageGatherData(lastStage);
  430. tender.gather_tp = ctx.helper.add(lastStage.contract_tp, lastStage.qc_tp);
  431. tender.end_contract_tp = ctx.helper.add(lastStage.contract_tp, lastStage.pre_contract_tp);
  432. tender.end_qc_tp = ctx.helper.add(lastStage.qc_tp, lastStage.pre_qc_tp);
  433. tender.end_gather_tp = ctx.helper.add(tender.end_contract_tp, tender.end_qc_tp);
  434. tender.pre_gather_tp = ctx.helper.add(lastStage.pre_contract_tp, lastStage.pre_qc_tp);
  435. tender.yf_tp = lastStage.yf_tp;
  436. tender.qc_ratio = ctx.helper.mul(ctx.helper.div(tender.end_qc_tp, ctx.tender.info.deal_param.contractPrice, 2), 100);
  437. tender.sum = ctx.helper.add(tender.total_price, tender.end_qc_tp);
  438. tender.pre_ratio = ctx.helper.mul(ctx.helper.div(tender.pre_gather_tp, tender.sum, 2), 100);
  439. tender.cur_ratio = ctx.helper.mul(ctx.helper.div(tender.gather_tp, tender.sum, 2), 100);
  440. tender.other_tp = ctx.helper.sub(ctx.helper.sub(tender.sum, tender.pre_gather_tp), tender.gather_tp);
  441. tender.other_ratio = Math.max(0, 100 - tender.pre_ratio - tender.cur_ratio);
  442. }
  443. const monthProgress = [];
  444. for (const s of stages) {
  445. if (s.s_time) {
  446. let progress = monthProgress.find(function(x) {
  447. return x.month === s.s_time;
  448. });
  449. if (!progress) {
  450. progress = { month: s.s_time };
  451. monthProgress.push(progress);
  452. }
  453. progress.tp = ctx.helper.add(ctx.helper.add(progress.tp, s.contract_tp), s.qc_tp);
  454. }
  455. }
  456. monthProgress.sort(function(x, y) {
  457. return Date.parse(x.month) - Date.parse(y.month);
  458. });
  459. let sum = 0;
  460. for (const p of monthProgress) {
  461. p.ratio = ctx.helper.mul(ctx.helper.div(p.tp, tender.sum, 4), 100);
  462. sum = ctx.helper.add(sum, p.tp);
  463. p.end_tp = sum;
  464. p.end_ratio = ctx.helper.mul(ctx.helper.div(p.end_tp, tender.sum, 4), 100);
  465. }
  466. const revise = await ctx.service.ledgerRevise.getLastestRevise(tender.id);
  467. const tenders = await ctx.service.tender.getList('', null, 1);
  468. const categoryData = await ctx.service.category.getAllCategory(ctx.session.sessionProject.id);
  469. const renderData = {
  470. tenders,
  471. categoryData,
  472. tender,
  473. revise,
  474. tenderInfo: ctx.tender.info,
  475. tenderMenu: this.menu.tenderMenu,
  476. preUrl: '/tender/' + ctx.tender.id,
  477. cooperation: ctx.session.sessionUser.cooperation,
  478. lastStage,
  479. stages: stages.reverse(),
  480. monthProgress,
  481. audit: auditConst,
  482. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.tender.tenderInfo),
  483. };
  484. if (ctx.session.sessionUser.is_admin) {
  485. renderData.tourists = await ctx.service.tenderTourist.getTourists(tender.id);
  486. // 获取所有项目参与者
  487. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  488. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  489. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  490. });
  491. const accountGroupList = accountGroup.map((item, idx) => {
  492. const groupList = accountList.filter(item => item.account_group === idx);
  493. return { groupName: item, groupList };
  494. });
  495. renderData.accountList = accountList;
  496. renderData.accountGroup = accountGroupList;
  497. }
  498. if (ctx.session.sessionProject.page_show.xxjd && ctx.session.sessionUser.is_admin) {
  499. // 投资进度内容
  500. renderData.scheduleAuditList = await ctx.service.scheduleAudit.getAllDataByCondition({ where: { tid: tender.id } });
  501. renderData.scPermission = scheduleConst.permission;
  502. }
  503. await this.layout('tender/detail.ejs', renderData, 'tender/detail_modal.ejs');
  504. } catch (error) {
  505. this.log(error);
  506. this.ctx.redirect('/list');
  507. }
  508. }
  509. /**
  510. * 保存标段属性等(Ajax)
  511. *
  512. * @param ctx
  513. * @return {Promise<void>}
  514. */
  515. async saveTenderInfo(ctx) {
  516. try {
  517. const data = JSON.parse(ctx.request.body.data);
  518. if (!data) {
  519. throw '提交数据错误';
  520. }
  521. // 针对查阅所有标段者但非原报和审批人提示
  522. const times = ctx.tender.data.ledger_status === auditConst.ledger.status.checkNo ? ctx.tender.data.ledger_times - 1 : ctx.tender.data.ledger_times;
  523. const auditors = await this.service.ledgerAudit.getAuditors(ctx.tender.id, times);
  524. const auditorsId = ctx.helper._.map(auditors, 'audit_id');
  525. const stageAuditors = await this.service.stageAudit.getAllAuditors(ctx.tender.id);
  526. const stageAUditorsId = ctx.helper._.map(stageAuditors, 'aid');
  527. const accountId = ctx.session.sessionUser.accountId;
  528. if (auditorsId.indexOf(accountId) === -1 && ctx.tender.data.user_id !== accountId &&
  529. stageAUditorsId.indexOf(accountId) === -1) {
  530. throw '您无权修改标段设置内容';
  531. }
  532. if (ctx.tender.data.ledger_status === auditConst.ledger.status.checked) {
  533. if (data.deal_param) {
  534. const lastStage = await this.ctx.service.stage.getLastestStage(ctx.tender.id, true);
  535. if (lastStage) {
  536. if (lastStage.order > 1 || (lastStage.status === auditConst.stage.status.checked || lastStage.status === auditConst.stage.status.checking)) throw '第一期上报后不可修改合同参数';
  537. if (lastStage.user_id !== ctx.session.sessionUser.accountId) throw '仅原报可修改合同参数';
  538. }
  539. }
  540. }
  541. if (data.decimal) {
  542. if (ctx.tender.data.user_id !== ctx.session.sessionUser.accountId) throw '仅原报可修改小数位数';
  543. await ctx.service.tenderInfo.saveDecimal(ctx.tender.id, data.decimal, ctx.tender.info.decimal);
  544. } else if (data.precision) {
  545. if (ctx.tender.data.user_id !== ctx.session.sessionUser.accountId) throw '仅原报可修改清单精度';
  546. await ctx.service.tenderInfo.savePrecision(ctx.tender.id,
  547. data.precision, ctx.tender.info.precision, ctx.tender.info.decimal);
  548. } else {
  549. await ctx.service.tenderInfo.saveTenderInfo(ctx.tender.id, data);
  550. }
  551. ctx.body = { err: 0, msg: '', data: JSON.parse(ctx.request.body.data) };
  552. } catch (err) {
  553. this.log(err);
  554. ctx.body = this.ajaxErrorBody(err, '保存标段设置失败');
  555. }
  556. }
  557. async saveTenderInfo2(ctx) {
  558. try {
  559. const data = JSON.parse(ctx.request.body.data);
  560. if (!data || !data.ledger_check) throw '提交数据错误';
  561. if (!ctx.session.sessionUser.is_admin) throw '您无权修改该内容';
  562. const updateData = {};
  563. if (data.ledger_check) updateData.ledger_check = data.ledger_check;
  564. await ctx.service.tenderInfo.saveTenderInfo(ctx.tender.id, data);
  565. ctx.body = { err: 0, msg: '', data: JSON.parse(ctx.request.body.data) };
  566. } catch (err) {
  567. this.log(err);
  568. ctx.body = this.ajaxErrorBody(err, '保存失败');
  569. }
  570. }
  571. /**
  572. * 设置标段计量类型并调整到标段概况(Get)
  573. *
  574. * @param ctx
  575. * @return {Promise<void>}
  576. */
  577. async tenderType(ctx) {
  578. try {
  579. const tenderId = ctx.params.id,
  580. type = ctx.query.type;
  581. if (!tenderId) {
  582. throw '当前未打开标段';
  583. }
  584. await ctx.service.tender.checkTender(tenderId);
  585. if (!ctx.tender) {
  586. throw '标段数据错误';
  587. }
  588. if (!ctx.tender.measure_type) {
  589. await ctx.service.tender.setTenderType(ctx.tender, parseInt(type));
  590. }
  591. ctx.redirect('/tender/' + tenderId);
  592. } catch (error) {
  593. ctx.helper.log(error);
  594. this.postError(error, '设置标段类型错误');
  595. ctx.redirect('/list');
  596. }
  597. }
  598. /**
  599. * 标段协作办公
  600. *
  601. * @param {Object} ctx - egg全局变量
  602. * @return {void}
  603. */
  604. async tenderCooperation(ctx) {
  605. const tenderId = ctx.params.id;
  606. try {
  607. if (!ctx.session.sessionUser.cooperation) {
  608. throw '权限不足';
  609. }
  610. const tender = await ctx.service.tender.getDataById(tenderId);
  611. const user = await ctx.service.projectAccount.getDataById(ctx.session.sessionUser.accountId);
  612. // 获取已参与协作用户列表
  613. const cooperationArray = [];
  614. if (tender.cooperation !== null && tender.cooperation !== '') {
  615. const cooperationList = JSON.parse(tender.cooperation);
  616. for (const cl in cooperationList) {
  617. const clArray = [];
  618. for (const audit of cooperationList[cl]) {
  619. const userInfo = await ctx.service.projectAccount.getDataById(audit);
  620. clArray.push(userInfo);
  621. }
  622. cooperationArray[cl] = clArray;
  623. }
  624. }
  625. const renderData = {
  626. user,
  627. tender,
  628. tenderMenu: this.menu.tenderMenu,
  629. preUrl: '/tender/' + tenderId,
  630. tenderPermissionList: accountPermission.tenderPermissionList,
  631. cooperationArray,
  632. };
  633. await this.layout('tender/cooperation.ejs', renderData, 'tender/cooperationModal.ejs');
  634. } catch (error) {
  635. ctx.helper.log(error);
  636. this.ctx.redirect('/tender/' + tenderId);
  637. }
  638. }
  639. /**
  640. * 添加标段操作
  641. *
  642. * @param {Object} ctx - egg全局变量
  643. * @return {void}
  644. */
  645. async add(ctx) {
  646. try {
  647. const rule = ctx.service.tender.rule('add');
  648. ctx.helper.validate(rule);
  649. const result = ctx.service.tender.add(ctx.request.body);
  650. if (!result) {
  651. throw '新增标段失败';
  652. }
  653. } catch (error) {
  654. ctx.helper.log(error);
  655. this.setMessage(error.toString(), this.messageType.ERROR);
  656. }
  657. ctx.redirect(ctx.request.header.referer);
  658. }
  659. /**
  660. * 保存标段操作
  661. *
  662. * @param {Object} ctx - egg全局变量
  663. * @return {void}
  664. */
  665. async save(ctx) {
  666. let id = ctx.request.body.tenderId;
  667. id = parseInt(id);
  668. try {
  669. if (isNaN(id) || id < 0) {
  670. throw '参数错误';
  671. }
  672. // 获取数据规则
  673. const rule = ctx.service.tender.rule('save');
  674. ctx.validate(rule);
  675. const result = await ctx.service.tender.save(ctx.request.body, id);
  676. if (!result) {
  677. throw '保存标段数据失败';
  678. }
  679. this.setMessage('保存标段数据成功', this.messageType.SUCCESS);
  680. } catch (error) {
  681. this.postError(error, '保存标段数据失败');
  682. }
  683. ctx.redirect(ctx.request.header.referer);
  684. }
  685. /**
  686. * 删除标段
  687. *
  688. * @param {Object} ctx -egg全局变量
  689. * @return {void}
  690. */
  691. async delete(ctx) {
  692. let id = ctx.request.body.tenderId;
  693. id = parseInt(id);
  694. try {
  695. if (isNaN(id) || id <= 0) {
  696. throw '参数错误';
  697. }
  698. const result = ctx.service.tender.deleteTenderById(id);
  699. if (!result) {
  700. throw '删除标段失败';
  701. }
  702. this.setMessage('删除标段成功', this.messageType.SUCCESS);
  703. } catch (error) {
  704. this.postError(error, '删除标段失败');
  705. }
  706. ctx.redirect(ctx.request.header.referer);
  707. }
  708. async rule(ctx) {
  709. const responseData = {
  710. err: 0,
  711. msg: '',
  712. data: {},
  713. };
  714. try {
  715. const tenderId = ctx.session.sessionUser.tenderId;
  716. if (!tenderId) {
  717. throw '当前未打开标段';
  718. }
  719. const data = JSON.parse(ctx.request.body.data);
  720. if (!data.rule || !JSON.parse(data.data).length || !codeRuleConst.ruleField[data.rule]) {
  721. throw '请选择组件再添加';
  722. }
  723. if (!data.connector) {
  724. throw '请选择连接符';
  725. }
  726. const updateData = {
  727. id: tenderId,
  728. };
  729. updateData[codeRuleConst.ruleField[data.rule]] = data.data;
  730. updateData.c_connector = data.connector;
  731. updateData.c_rule_first = 0;
  732. const result = await ctx.service.tender.db.update(ctx.service.tender.tableName, updateData);
  733. if (result.affectedRows !== 1) {
  734. throw '更新规则失败';
  735. }
  736. } catch (err) {
  737. ctx.helper.log(err);
  738. responseData.err = 1;
  739. responseData.msg = err.toString();
  740. }
  741. ctx.body = responseData;
  742. }
  743. async ruleFirst(ctx) {
  744. const responseData = {
  745. err: 0,
  746. msg: '',
  747. data: {},
  748. };
  749. try {
  750. const tenderId = ctx.session.sessionUser.tenderId;
  751. if (!tenderId) {
  752. throw '当前未打开标段';
  753. }
  754. const updateData = {
  755. id: tenderId,
  756. };
  757. updateData.c_rule_first = 0;
  758. const result = await ctx.service.tender.db.update(ctx.service.tender.tableName, updateData);
  759. if (result.affectedRows !== 1) {
  760. throw '更新规则失败';
  761. }
  762. } catch (err) {
  763. ctx.helper.log(err);
  764. responseData.err = 1;
  765. responseData.msg = err.toString();
  766. }
  767. ctx.body = responseData;
  768. }
  769. async shenpiSet(ctx) {
  770. if (ctx.session.sessionUser.is_admin === 0) {
  771. ctx.request.headers.referer ? ctx.redirect(ctx.request.headers.referer) : ctx.redirect('/list');
  772. }
  773. // 获取所有项目参与者
  774. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  775. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  776. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  777. });
  778. const accountGroupList = accountGroup.map((item, idx) => {
  779. const groupList = accountList.filter(item => item.account_group === idx);
  780. return { groupName: item, groupList };
  781. });
  782. // 获取固定审批流 or 固定终审
  783. for (const sp of shenpiConst.sp_lc) {
  784. sp.status = ctx.tender.info.shenpi ? ctx.tender.info.shenpi[sp.code] : shenpiConst.sp_status.sqspr;
  785. if (sp.status === shenpiConst.sp_status.gdspl) {
  786. sp.auditList = await ctx.service.shenpiAudit.getAuditList(ctx.tender.id, sp.type, sp.status);
  787. } else if (sp.status === shenpiConst.sp_status.gdzs) {
  788. sp.audit = await ctx.service.shenpiAudit.getAudit(ctx.tender.id, sp.type, sp.status);
  789. }
  790. }
  791. const tenders = await ctx.service.tender.getList('', null, 1);
  792. const removeTenders = [];
  793. for (const tender of tenders) {
  794. const shenpiInfo = await ctx.service.tenderInfo.getTenderShenpiInfo(tender.id);
  795. if (!shenpiInfo) {
  796. removeTenders.push(tender.id);
  797. } else {
  798. tender.shenpiInfo = shenpiInfo;
  799. // 获取所有的固定审批流或固定终审
  800. const shenpiauditList = {};
  801. for (const shenpi in tender.shenpiInfo) {
  802. if (tender.shenpiInfo[shenpi] === shenpiConst.sp_status.gdspl) {
  803. const shenpiList = await ctx.service.shenpiAudit.getAllDataByCondition({ where: { tid: tender.id, sp_type: shenpiConst.sp_type[shenpi], sp_status: tender.shenpiInfo[shenpi] } });
  804. const shenpiIdList = ctx.helper._.map(shenpiList, 'audit_id');
  805. shenpiauditList[shenpi] = shenpiIdList.length ? shenpiIdList : null;
  806. } else if (tender.shenpiInfo[shenpi] === shenpiConst.sp_status.gdzs) {
  807. const shenpiInfo = await ctx.service.shenpiAudit.getDataByCondition({ tid: tender.id, sp_type: shenpiConst.sp_type[shenpi], sp_status: tender.shenpiInfo[shenpi] });
  808. shenpiauditList[shenpi] = shenpiInfo && shenpiInfo.audit_id ? [shenpiInfo.audit_id] : null;
  809. }
  810. }
  811. tender.shenpiauditList = shenpiauditList;
  812. }
  813. }
  814. if (removeTenders.length > 0) {
  815. ctx.helper._.remove(tenders, function(n) {
  816. return removeTenders.indexOf(n.id) !== -1;
  817. });
  818. }
  819. const categoryData = await ctx.service.category.getAllCategory(ctx.session.sessionProject.id);
  820. // 是否修订中
  821. const lastRevise = await ctx.service.ledgerRevise.getLastestRevise(ctx.tender.id);
  822. const revising = (lastRevise && lastRevise.status !== auditConst.revise.status.checked) || false;
  823. const cooperationNum = await ctx.service.ledgerCooperation.count({ tid: ctx.tender.id, status: 1 });
  824. const renderData = {
  825. shenpi: shenpiConst,
  826. accountList,
  827. accountGroup: accountGroupList,
  828. tenders,
  829. categoryData,
  830. auditConst,
  831. revising,
  832. measureType,
  833. cooperationNum,
  834. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.tender.shenpi),
  835. };
  836. await this.layout('tender/shenpi.ejs', renderData, 'tender/shenpi_modal.ejs');
  837. }
  838. async saveTenderInfoShenpi(ctx) {
  839. try {
  840. const data = JSON.parse(ctx.request.body.data);
  841. if (!data) {
  842. throw '提交数据错误';
  843. }
  844. // 判断修改权限
  845. if (ctx.session.sessionUser.is_admin === 0) {
  846. throw '你没有权限修改审批流程';
  847. }
  848. // let postData = {};
  849. // if (!ctx.tender.info.shenpi) {
  850. // for (const sp of shenpiConst.sp_lc) {
  851. // if (sp.code === data.code) {
  852. // postData[sp.code] = data.status;
  853. // } else {
  854. // postData[sp.code] = shenpiConst.sp_status.sqspr;
  855. // }
  856. // }
  857. // } else {
  858. const postData = ctx.tender.info.shenpi;
  859. postData[data.code] = data.status;
  860. if (data.code === shenpiConst.sp_lc[shenpiConst.sp_type.stage - 1].code) {
  861. const status = parseInt(data.status) === shenpiConst.sp_status.gdspl ? 1 : 0;
  862. await ctx.service.ledgerCooperation.changeAllStatus(status);
  863. }
  864. // }
  865. // console.log(postData);
  866. await ctx.service.tenderInfo.saveTenderInfo(ctx.tender.id, { shenpi: postData });
  867. let auditList = [];
  868. if (data.status === shenpiConst.sp_status.gdspl) {
  869. auditList = await ctx.service.shenpiAudit.getAuditList(ctx.tender.id, shenpiConst.sp_type[data.code], data.status);
  870. } else if (data.status === shenpiConst.sp_status.gdzs) {
  871. auditList = await ctx.service.shenpiAudit.getAudit(ctx.tender.id, shenpiConst.sp_type[data.code], data.status);
  872. }
  873. ctx.body = { err: 0, msg: '', data: auditList };
  874. } catch (err) {
  875. this.log(err);
  876. ctx.body = this.ajaxErrorBody(err, '保存审批流程设置失败');
  877. }
  878. }
  879. async saveShenpiAudit(ctx) {
  880. try {
  881. const data = JSON.parse(ctx.request.body.data);
  882. if (!data) {
  883. throw '提交数据错误';
  884. }
  885. // 判断修改权限
  886. if (ctx.session.sessionUser.is_admin === 0) {
  887. throw '你没有权限修改审批流程';
  888. }
  889. let info = '';
  890. switch (data.type) {
  891. case 'add':
  892. const result = await ctx.service.shenpiAudit.addAudit(data);
  893. if (result) {
  894. throw '添加审批人失败';
  895. }
  896. break;
  897. case 'del':
  898. await ctx.service.shenpiAudit.removeAudit(data);
  899. break;
  900. case 'copy2ot':
  901. await ctx.service.shenpiAudit.copyAudit2otherTender(data);
  902. break;
  903. case 'copy2os':
  904. await ctx.service.shenpiAudit.copyAudit2otherShenpi(data);
  905. break;
  906. case 'pwd':
  907. info = await ctx.service.ledgerCooperation.save(data);
  908. break;
  909. case 'company':
  910. info = await ctx.service.ledgerCooperation.saveCompany(data);
  911. break;
  912. default:break;
  913. }
  914. ctx.body = { err: 0, msg: '', data: info };
  915. } catch (err) {
  916. this.log(err);
  917. ctx.body = this.ajaxErrorBody(err, '保存审批流程设置失败');
  918. }
  919. }
  920. /**
  921. * 签名,上传图片 (Ajax)
  922. * @param ctx
  923. * @return {Promise<void>}
  924. */
  925. async saveCooperateSign(ctx) {
  926. try {
  927. const stream = await ctx.getFileStream();
  928. const create_time = Date.parse(new Date()) / 1000;
  929. const id = stream.fields.id;
  930. const fileInfo = path.parse(stream.filename);
  931. const fileName = path.join('public/upload', ctx.tender.id.toString(), 'sign', 'signImg_' + create_time + fileInfo.ext);
  932. await ctx.helper.saveStreamFile(stream, path.join(this.app.baseDir, 'app', fileName));
  933. if (stream) {
  934. await sendToWormhole(stream);
  935. }
  936. await ctx.service.ledgerCooperation.saveSign(id, fileName);
  937. ctx.body = { err: 0, msg: '', data: fileName };
  938. } catch (err) {
  939. this.log(err);
  940. ctx.body = { err: 1, msg: err.toString(), data: null };
  941. }
  942. }
  943. /**
  944. * 拷贝设置
  945. * @param {object} ctx - 上下文
  946. */
  947. async copyTender(ctx) {
  948. try {
  949. const id = ctx.tender.data.id;
  950. const { id: copy_id = '', type: typeArr = [] } = JSON.parse(ctx.request.body.data);
  951. await ctx.service.tenderInfo.copyTenderHandler(id, copy_id, typeArr);
  952. ctx.body = { err: 0, msg: '' };
  953. } catch (error) {
  954. this.log(error);
  955. ctx.body = this.ajaxErrorBody(error, '保存审批流程设置失败');
  956. }
  957. }
  958. /**
  959. * 游客账号设置
  960. * @param {object} ctx - 上下文
  961. */
  962. async saveTourist(ctx) {
  963. try {
  964. const data = JSON.parse(ctx.request.body.data);
  965. if (!data) {
  966. throw '提交数据错误';
  967. }
  968. // 判断修改权限
  969. if (ctx.session.sessionUser.is_admin === 0) {
  970. throw '你没有权限修改游客账号';
  971. }
  972. let info = '';
  973. switch (data.type) {
  974. case 'add':
  975. const result = await ctx.service.tenderTourist.addAudit(data);
  976. if (!result) {
  977. throw '添加审批人失败';
  978. }
  979. info = result;
  980. break;
  981. case 'del':
  982. await ctx.service.tenderTourist.removeAudit(data);
  983. break;
  984. default:break;
  985. }
  986. ctx.body = { err: 0, msg: '', data: info };
  987. } catch (err) {
  988. this.log(err);
  989. ctx.body = this.ajaxErrorBody(err, '保存游客账号设置失败');
  990. }
  991. }
  992. /**
  993. * 获取部位明细数据(Ajax)
  994. *
  995. * @param ctx
  996. * @return {Promise<void>}
  997. */
  998. async loadLedgerData(ctx) {
  999. try {
  1000. const ledgerData = await ctx.service.ledger.getData(ctx.tender.id);
  1001. const posData = ctx.tender.data.measure_type === measureType.tz.value
  1002. ? await ctx.service.pos.getPosData({ tid: ctx.tender.id }) : [];
  1003. const convert = new billsPosConvert(ctx);
  1004. convert.loadData(ledgerData, posData, []);
  1005. const result = await convert.convert();
  1006. const ledgerCooperationList = await ctx.service.ledgerCooperation.getAllDataByCondition({ where: { tid: ctx.tender.id, status: 1 } });
  1007. ctx.body = { err: 0, msg: '', data: { ledgerList: result, ledgerCooperationList } };
  1008. } catch (err) {
  1009. this.log(err);
  1010. ctx.body = { err: 1, msg: err.toString(), data: [] };
  1011. }
  1012. }
  1013. async billsTag(ctx) {
  1014. try {
  1015. if (ctx.stage) {
  1016. if (ctx.stage.users.indexOf(this.ctx.session.sessionUser.accountId) < 0)
  1017. throw '您无权进行该操作';
  1018. } else {
  1019. if (ctx.tender.ledgerUsers.indexOf(this.ctx.session.sessionUser.accountId) < 0)
  1020. throw '您无权进行该操作';
  1021. }
  1022. const data = JSON.parse(ctx.request.body.data);
  1023. const result = await ctx.service.ledgerTag.update(data);
  1024. ctx.body = { err: 0, msg: '', data: result };
  1025. } catch (err) {
  1026. this.log(err);
  1027. ctx.body = this.ajaxErrorBody(err, '书签数据错误');
  1028. }
  1029. }
  1030. }
  1031. return TenderController;
  1032. };