tender_controller.js 48 KB

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