change_controller.js 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author Mai
  6. * @date 2018/8/14
  7. * @version
  8. */
  9. const moment = require('moment');
  10. const sendToWormhole = require('stream-wormhole');
  11. const fs = require('fs');
  12. const path = require('path');
  13. const audit = require('../const/audit');
  14. const codeRuleConst = require('../const/code_rule');
  15. const changeConst = require('../const/change');
  16. const accountGroup = require('../const/account_group').group;
  17. // const tenderMenu = require('../../config/menu').tenderMenu;
  18. module.exports = app => {
  19. class ChangeController extends app.BaseController {
  20. /**
  21. * 构造函数
  22. *
  23. * @param {Object} ctx - egg全局变量
  24. * @return {void}
  25. */
  26. constructor(ctx) {
  27. super(ctx);
  28. ctx.showProject = true;
  29. ctx.showTender = true;
  30. ctx.showTitle = true;
  31. }
  32. async _filterChanges(ctx, status = 0) {
  33. const tenderId = ctx.params.id;
  34. ctx.session.sessionUser.tenderId = tenderId;
  35. const tender = await this.service.tender.getDataById(tenderId);
  36. const tenderList = await this.service.tender.getList();
  37. const page = ctx.page;
  38. const changes = await ctx.service.change.getListByStatus(tender.id, status);
  39. const total = await ctx.service.change.getCountByStatus(tender.id, status);
  40. if (changes !== null) {
  41. let i = 0;
  42. for (const c of changes) {
  43. const status = c.status === audit.flow.status.uncheck ? 0 : 1;
  44. // 根据审批人对当前变更令的状态取不同的展示方式。
  45. let changeAudit = '';
  46. let auditStatus = 0;
  47. switch (c.status) {
  48. case 1:
  49. auditStatus = 1;
  50. break;
  51. case 2:
  52. changeAudit = await ctx.service.changeAudit.getLastUser(c.cid, c.times, status);
  53. auditStatus = changeAudit.uid === ctx.session.sessionUser.accountId ? 1 : 0;
  54. break;
  55. case 3:
  56. case 4:
  57. auditStatus = 0;
  58. changeAudit = await ctx.service.changeAudit.getLastUser(c.cid, c.times, status);
  59. break;
  60. case 5:
  61. changeAudit = await ctx.service.changeAudit.getLastUser(c.cid, c.times - 1, status);
  62. auditStatus = c.uid === ctx.session.sessionUser.accountId ? 1 : 0;
  63. break;
  64. case 6:
  65. changeAudit = await ctx.service.changeAudit.getLastBackUser(c.cid, c.times);
  66. const checkingAudit = await ctx.service.changeAudit.getLastUser(c.cid, c.times, status);
  67. auditStatus = checkingAudit.uid === ctx.session.sessionUser.accountId ? 1 : 0;
  68. break;
  69. default:
  70. break;
  71. }
  72. changes[i].changeAudit = changeAudit;
  73. changes[i].auditStatus = auditStatus;
  74. i++;
  75. }
  76. }
  77. // 分页相关
  78. const pageInfo = {
  79. page,
  80. total: parseInt(total / app.config.pageSize),
  81. queryData: JSON.stringify(ctx.urlInfo.query),
  82. };
  83. const filter = JSON.parse(JSON.stringify(audit.filter));
  84. filter.count = [];
  85. filter.count[filter.status.pending] = await ctx.service.change.getCountByStatus(tender.id, filter.status.pending);// await ctx.service.change.pendingDatas(tender.id, ctx.session.sessionUser.accountId);
  86. filter.count[filter.status.uncheck] = await ctx.service.change.getCountByStatus(tender.id, filter.status.uncheck);// await ctx.service.change.checkingDatas(tender.id, ctx.session.sessionUser.accountId);
  87. filter.count[filter.status.checking] = await ctx.service.change.getCountByStatus(tender.id, filter.status.checking);// await ctx.service.change.checkedDatas(tender.id, ctx.session.sessionUser.accountId);
  88. filter.count[filter.status.checked] = await ctx.service.change.getCountByStatus(tender.id, filter.status.checked);// await ctx.service.change.pendingDatas(tender.id, ctx.session.sessionUser.accountId);
  89. filter.count[filter.status.checkNo] = await ctx.service.change.getCountByStatus(tender.id, filter.status.checkNo);// await ctx.service.change.pendingDatas(tender.id, ctx.session.sessionUser.accountId);
  90. const codeRule = tender.c_rule ? JSON.parse(tender.c_rule) : [];
  91. for (const rule of codeRule) {
  92. switch (rule.rule_type) {
  93. case codeRuleConst.measure.ruleType.tenderName:
  94. rule.preview = tender.name;
  95. break;
  96. case codeRuleConst.measure.ruleType.inDate:
  97. rule.preview = moment().format('YYYY');
  98. break;
  99. case codeRuleConst.measure.ruleType.text:
  100. rule.preview = rule.text;
  101. break;
  102. case codeRuleConst.measure.ruleType.addNo:
  103. const s = '0000000000';
  104. rule.preview = s.substr(s.length - rule.format);
  105. break;
  106. default: break;
  107. }
  108. }
  109. const renderData = {
  110. uid: ctx.session.sessionUser.accountId,
  111. moment,
  112. tender,
  113. tenderList,
  114. pageInfo,
  115. changes,
  116. filter,
  117. status,
  118. codeRule,
  119. auditConst: audit.flow,
  120. changeConst,
  121. ruleType: codeRuleConst.ruleType.change,
  122. ruleConst: codeRuleConst.measure,
  123. tenderMenu: this.menu.tenderMenu,
  124. preUrl: '/tender/' + tenderId,
  125. };
  126. await this.layout('change/index.ejs', renderData, 'change/modal.ejs');
  127. }
  128. /**
  129. * 变更管理 页面 (Get)
  130. *
  131. * @param {Object} ctx - egg全局变量
  132. * @return {void}
  133. */
  134. async index(ctx) {
  135. try {
  136. await this._filterChanges(ctx);
  137. } catch (err) {
  138. this.log(err);
  139. ctx.redirect('/dashboard');
  140. }
  141. }
  142. /**
  143. *
  144. * @param {Object} ctx - egg全局变量
  145. * @return {void}
  146. */
  147. async newCode(ctx) {
  148. const responseData = {
  149. err: 0,
  150. msg: '',
  151. data: '',
  152. };
  153. try {
  154. const tenderId = ctx.params.id;
  155. if (!tenderId) {
  156. throw '当前未打开标段';
  157. }
  158. const tenderData = await ctx.service.tender.getDataById(tenderId);
  159. const cCodeRule = tenderData.c_rule !== null ? JSON.parse(tenderData.c_rule) : [];
  160. const code = [];
  161. for (const rule of cCodeRule) {
  162. switch (rule.rule_type) {
  163. case codeRuleConst.measure.ruleType.tenderName:
  164. code.push(tenderData.name);
  165. break;
  166. case codeRuleConst.measure.ruleType.text:
  167. code.push(rule.text);
  168. break;
  169. case codeRuleConst.measure.ruleType.inDate:
  170. code.push(moment().format('YYYY'));
  171. break;
  172. case codeRuleConst.measure.ruleType.addNo:
  173. let s = '0000000000';
  174. const count = rule.start + await ctx.service.change.count({ tid: tenderId });
  175. s = s + count;
  176. code.push(s.substr(s.length - rule.format));
  177. break;
  178. default: break;
  179. }
  180. }
  181. responseData.data = code.join(tenderData.c_connector !== null && tenderData.c_connector !== 3 ? codeRuleConst.measure.connectorString[tenderData.c_connector] : '');
  182. } catch (err) {
  183. responseData.err = 1;
  184. responseData.msg = err;
  185. }
  186. ctx.body = responseData;
  187. }
  188. /**
  189. * 新增变更 (Post)
  190. *
  191. * @param {Object} ctx - egg全局变量
  192. * @return {void}
  193. */
  194. async add(ctx) {
  195. try {
  196. const tenderId = ctx.params.id;
  197. if (!tenderId) {
  198. throw '当前未打开标段';
  199. }
  200. const data = JSON.parse(ctx.request.body.data);
  201. if (!data.code || data.code === '' || !data.name || data.name === '') {
  202. throw '变更令号不能为空';
  203. }
  204. const change = await ctx.service.change.add(tenderId, ctx.session.sessionUser.accountId, data.code, data.name);
  205. ctx.body = { err: 0, msg: '', data: change };
  206. } catch (err) {
  207. this.log(err);
  208. ctx.body = { err: 1, msg: err.toString() };
  209. }
  210. }
  211. /**
  212. * 变更管理 状态筛选 页面 (Get)
  213. * @param {Object} ctx - egg全局变量
  214. * @return {void}
  215. */
  216. async status(ctx) {
  217. try {
  218. const status = parseInt(ctx.params.status);
  219. await this._filterChanges(ctx, status);
  220. } catch (err) {
  221. this.logger.error(err);
  222. ctx.redirect('/tender/' + ctx.params.id + '/change');
  223. }
  224. }
  225. /**
  226. * 变更信息 页面 (Get)
  227. *
  228. * @param {Object} ctx - egg全局变量
  229. * @return {void}
  230. */
  231. async info(ctx) {
  232. try {
  233. const whiteList = this.ctx.app.config.multipart.whitelist;
  234. const tenderid = ctx.params.id !== undefined ? ctx.params.id : ctx.session.sessionUser.tenderId;
  235. ctx.session.sessionUser.tenderId = tenderid;
  236. const tender = await this.service.tender.getDataById(tenderid);
  237. const change = await ctx.service.change.getDataByCondition({ cid: ctx.params.cid });
  238. // 后台判断当前人查看info状态
  239. const auditStatus = await ctx.service.changeAudit.getStatusByChange(change);
  240. // 获取附件列表
  241. const attList = await ctx.service.changeAtt.getAllDataByCondition({ where: { cid: ctx.params.cid } });
  242. // 根据auditStatus获取审批人列表
  243. const auditList = await ctx.service.changeAudit.getListByStatus(change, auditStatus);
  244. // 获取已选清单
  245. const changeList = await ctx.service.changeAuditList.getAllDataByCondition({ where: { cid: ctx.params.cid } });
  246. const renderData = {
  247. uid: ctx.session.sessionUser.accountId,
  248. tender,
  249. change,
  250. changeConst,
  251. auditStatus,
  252. auditConst: audit.flow,
  253. attList,
  254. whiteList,
  255. auditList,
  256. changeList,
  257. tpUnit: ctx.tender.info.decimal.tp,
  258. upUnit: ctx.tender.info.decimal.up,
  259. };
  260. // 根据auditStatus状态获取的不同的数据
  261. if (auditStatus === 1 || auditStatus === 2) {
  262. // 获取标准清单列表
  263. const dealBillList = await ctx.service.dealBills.getAllDataByCondition({ where: { tender_id: tenderid } });
  264. // 获取清单列表和台账清单列表
  265. const ledger = await ctx.service.ledger.getDataByTenderId(tenderid, -1);
  266. const pos = await ctx.service.pos.getPosData({ tid: tenderid });
  267. renderData.ledger = ledger;
  268. renderData.pos = pos;
  269. renderData.dealBillList = dealBillList;
  270. renderData.changeUnits = changeConst.units;
  271. renderData.precision = ctx.tender.info.precision;
  272. renderData.accountGroup = accountGroup;
  273. // 获取所有项目参与者
  274. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  275. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  276. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group'],
  277. });
  278. renderData.accountList = accountList;
  279. // 重新上报获取审批流程
  280. if (auditStatus === 2) {
  281. const auditList2 = await ctx.service.changeAudit.getListByBack(change.cid, change.times);
  282. // 展示页右侧审批流程列表
  283. const auditList3 = [];
  284. for (let time = 1; time <= change.times; time++) {
  285. const auditTimeList = [];
  286. for (const al of auditList2) {
  287. if (al.times === time) {
  288. auditTimeList.push(al);
  289. }
  290. }
  291. auditList3.push(auditTimeList);
  292. }
  293. renderData.auditList3 = auditList3;
  294. }
  295. // 根据清单获取提交数据和计算总金额
  296. const changeListData = [];
  297. const changeWhiteListData = [];
  298. let ototalCost = 0;
  299. let ctotalCost = 0;
  300. for (const cl of changeList) {
  301. const cLArray = [
  302. cl.code,
  303. cl.name,
  304. cl.bwmx,
  305. cl.unit,
  306. cl.unit_price,
  307. cl.oamount,
  308. cl.camount,
  309. cl.detail,
  310. cl.lid,
  311. ];
  312. ototalCost += ctx.helper.accMul(cl.unit_price, cl.oamount);
  313. ctotalCost += ctx.helper.accMul(cl.unit_price, cl.camount);
  314. if (cl.lid !== 0) {
  315. changeListData.push(cLArray.join(';'));
  316. } else {
  317. changeWhiteListData.push(cLArray.join(';'));
  318. }
  319. }
  320. renderData.changeListData = changeListData.join('^_^');
  321. renderData.changeWhiteListData = changeWhiteListData.join('^_^');
  322. renderData.ototalCost = ototalCost;
  323. renderData.ctotalCost = ctotalCost;
  324. // 获取公司列表
  325. const companyList = await ctx.service.changeCompany.getAllDataByCondition({ where: { tid: tenderid } });
  326. renderData.companyList = companyList;
  327. } else if (auditStatus === 3 || auditStatus === 4 || auditStatus === 5 || auditStatus === 7) {
  328. // 展示页左侧审批流程列表和清单审批列表数据
  329. const auditList2 = await ctx.service.changeAudit.getListGroupByTimes(change.cid, change.times);
  330. // 展示页右侧审批流程列表
  331. const auditList3 = [];
  332. for (let time = 1; time <= change.times; time++) {
  333. const auditTimeList = [];
  334. for (const al of auditList) {
  335. if (al.times === time) {
  336. auditTimeList.push(al);
  337. }
  338. }
  339. auditList3.push(auditTimeList);
  340. }
  341. renderData.auditList3 = auditList3;
  342. renderData.changeList = changeList.sort();
  343. let ototalCost = 0;
  344. let ctotalCost = 0;
  345. let stotalCost = 0;
  346. const auditTotalCost = [];
  347. for (const cl of changeList) {
  348. ototalCost += parseFloat(ctx.helper.roundNum(ctx.helper.accMul(cl.unit_price, cl.oamount), renderData.tpUnit));
  349. ctotalCost += parseFloat(ctx.helper.roundNum(ctx.helper.accMul(cl.unit_price, cl.camount), renderData.tpUnit));
  350. stotalCost += cl.samount !== '' ? parseFloat(ctx.helper.roundNum(ctx.helper.accMul(cl.unit_price, cl.samount), renderData.tpUnit)) : 0;
  351. const audit_amount = cl.audit_amount !== null && cl.audit_amount !== '' ? cl.audit_amount.split(',') : '';
  352. auditTotalCost.push(audit_amount);
  353. }
  354. renderData.ototalCost = ototalCost;
  355. renderData.ctotalCost = ctotalCost;
  356. renderData.stotalCost = stotalCost;
  357. // 清单表页赋值
  358. for (const [index, au] of auditList2.entries()) {
  359. if (au.usite !== 0) {
  360. au.list_amount = [];
  361. au.totalCost = 0;
  362. for (const [auindex, at] of auditTotalCost.entries()) {
  363. au.list_amount.push(at[index - 1]);
  364. au.totalCost += at[index - 1] !== undefined ? parseFloat(ctx.helper.roundNum(ctx.helper.accMul(changeList[auindex].unit_price, at[index - 1]), renderData.tpUnit)) : 0;
  365. }
  366. }
  367. }
  368. renderData.auditList2 = auditList2;
  369. } else if (auditStatus === 6) {
  370. renderData.changeList = changeList.sort();
  371. let ototalCost = 0;
  372. let ctotalCost = 0;
  373. const auditTotalCost = [];
  374. const auditUnit = [];
  375. for (const cl of changeList) {
  376. ototalCost += parseFloat(ctx.helper.roundNum(ctx.helper.accMul(cl.unit_price, cl.oamount), renderData.tpUnit));
  377. ctotalCost += parseFloat(ctx.helper.roundNum(ctx.helper.accMul(cl.unit_price, cl.camount), renderData.tpUnit));
  378. const audit_amount = cl.audit_amount !== null && cl.audit_amount !== '' ? cl.audit_amount.split(',') : '';
  379. auditTotalCost.push(audit_amount);
  380. }
  381. renderData.ototalCost = ototalCost;
  382. renderData.ctotalCost = ctotalCost;
  383. // 清单表页赋值
  384. for (const [index, au] of auditList.entries()) {
  385. if (au.usite !== 0) {
  386. au.list_amount = [];
  387. au.totalCost = 0;
  388. if (au.uid === renderData.uid) {
  389. for (const [auindex, at] of auditTotalCost.entries()) {
  390. if (at[index - 2] !== undefined) {
  391. au.list_amount.push(at[index - 2]);
  392. au.totalCost += parseFloat(ctx.helper.roundNum(ctx.helper.accMul(changeList[auindex].unit_price, at[index - 2]), renderData.tpUnit));
  393. } else if (at[index - 2] === undefined) {
  394. au.list_amount.push(changeList[auindex].camount);
  395. au.totalCost += parseFloat(ctx.helper.roundNum(ctx.helper.accMul(changeList[auindex].unit_price, changeList[auindex].camount), renderData.tpUnit));
  396. }
  397. }
  398. } else {
  399. for (const [auindex, at] of auditTotalCost.entries()) {
  400. au.list_amount.push(at[index - 1]);
  401. au.totalCost += at[index - 1] !== undefined ? parseFloat(ctx.helper.roundNum(ctx.helper.accMul(changeList[auindex].unit_price, at[index - 1]), renderData.tpUnit)) : 0;
  402. }
  403. }
  404. }
  405. }
  406. }
  407. renderData.auditList = auditList;
  408. await this.layout('change/info.ejs', renderData, 'change/info_modal.ejs');
  409. } catch (err) {
  410. this.log(err);
  411. ctx.redirect('/tender/' + ctx.params.id + '/change');
  412. }
  413. }
  414. /**
  415. * 变更令上报和保存
  416. * @param {Object} ctx - egg全局变量
  417. * @return {void}
  418. */
  419. async save(ctx) {
  420. try {
  421. const result = await ctx.service.change.save(ctx.request.body, ctx.session.sessionUser.tenderId);
  422. if (!result) {
  423. throw '上报失败';
  424. }
  425. if (ctx.request.body.changestatus !== undefined && parseInt(ctx.request.body.changestatus) === 2) {
  426. ctx.body = { err: 0, msg: '保存成功' };
  427. } else {
  428. ctx.redirect('/tender/' + ctx.session.sessionUser.tenderId + '/change');
  429. }
  430. } catch (err) {
  431. this.log(err);
  432. if (ctx.request.body.changestatus !== undefined && parseInt(ctx.request.body.changestatus) === 2) {
  433. ctx.body = { err: 1, msg: err.toString() };
  434. } else {
  435. ctx.redirect('/tender/' + ctx.session.sessionUser.tenderId + '/change/' + ctx.request.body.cid + '/info');
  436. }
  437. }
  438. }
  439. /**
  440. * 变更令审批
  441. * @param {Object} ctx - egg全局变量
  442. * @return {void}
  443. */
  444. async approval(ctx) {
  445. try {
  446. const changeData = await ctx.service.change.getDataByCondition({cid: ctx.request.body.change_id});
  447. if (!changeData) {
  448. throw '变更令数据错误';
  449. }
  450. const status = parseInt(ctx.request.body.status);
  451. let result = false;
  452. switch (status) {
  453. case 3:// 审批通过
  454. result = await ctx.service.change.approvalSuccess(ctx.request.body, changeData);
  455. break;
  456. case 4:// 审批终止
  457. result = await ctx.service.change.approvalStop(ctx.request.body);
  458. break;
  459. case 5:// 审批退回到原报人
  460. result = await ctx.service.change.approvalBack(ctx.request.body, changeData);
  461. break;
  462. case 6:// 审批退回到上一个审批人
  463. result = await ctx.service.change.approvalBackNew(ctx.request.body, changeData);
  464. break;
  465. default:break;
  466. }
  467. if (!result) {
  468. throw '审批失败';
  469. }
  470. ctx.redirect('/tender/' + changeData.tid + '/change');
  471. } catch (err) {
  472. console.log(err);
  473. ctx.redirect(ctx.request.header.referer);
  474. }
  475. }
  476. /**
  477. * 变更公司管理
  478. * @param {Object} ctx - egg全局变量
  479. * @return {void}
  480. */
  481. async updateCompany(ctx) {
  482. const responseData = {
  483. err: 0,
  484. msg: '',
  485. data: '',
  486. };
  487. try {
  488. const data = JSON.parse(ctx.request.body.data);
  489. if (data.tid === undefined || data.uci === undefined || data.uc === undefined || data.ac === undefined) {
  490. throw '参数有误';
  491. }
  492. const [addCompany, selectCompany] = await ctx.service.changeCompany.setCompanyList(data);
  493. responseData.data = { add: addCompany, select: selectCompany };
  494. } catch (err) {
  495. responseData.err = 1;
  496. responseData.msg = err;
  497. }
  498. ctx.body = responseData;
  499. }
  500. /**
  501. * 上传附件
  502. * @param {Object} ctx - egg全局变量
  503. * @return {void}
  504. */
  505. async uploadFile(ctx) {
  506. const responseData = {
  507. err: 0,
  508. msg: '',
  509. data: [],
  510. };
  511. let stream;
  512. try {
  513. const parts = ctx.multipart({ autoFields: true });
  514. const files = [];
  515. let index = 0;
  516. while ((stream = await parts()) !== undefined) {
  517. // 判断用户是否选择上传文件
  518. if (!stream.filename) {
  519. throw '请选择上传的文件!';
  520. }
  521. const create_time = Date.parse(new Date()) / 1000;
  522. const fileInfo = path.parse(stream.filename);
  523. const dirName = 'app/public/upload/changes/' + moment().format('YYYYMMDD');
  524. const fileName = 'changes' + create_time + '_' + index + fileInfo.ext;
  525. // 判断文件夹是否存在,不存在则直接创建文件夹
  526. if (!fs.existsSync(path.join(this.app.baseDir, dirName))) {
  527. await fs.mkdirSync(path.join(this.app.baseDir, dirName));
  528. }
  529. // 保存文件
  530. await ctx.helper.saveStreamFile(stream, path.join(this.app.baseDir, dirName, fileName));
  531. await sendToWormhole(stream);
  532. // 保存数据到att表
  533. const fileData = {
  534. in_time: create_time,
  535. filename: fileInfo.name,
  536. fileext: fileInfo.ext,
  537. filesize: Array.isArray(parts.field.size) ? parts.field.size[index] : parts.field.size,
  538. filepath: path.join(dirName, fileName),
  539. };
  540. const result = await ctx.service.changeAtt.save(parts.field, fileData, ctx.session.sessionUser.accountId);
  541. if (!result) {
  542. throw '导入数据库保存失败';
  543. }
  544. fileData.in_time = moment(create_time * 1000).format('YYYY-MM-DD');
  545. fileData.filesize = await ctx.helper.bytesToSize(fileData.filesize);
  546. fileData.id = result.insertId;
  547. delete fileData.filepath;
  548. files.push(fileData);
  549. ++index;
  550. }
  551. responseData.data = files;
  552. } catch (err) {
  553. this.log(err);
  554. // 失败需要消耗掉stream 以防卡死
  555. if (stream) {
  556. await sendToWormhole(stream);
  557. }
  558. this.setMessage(err.toString(), this.messageType.ERROR);
  559. }
  560. ctx.body = responseData;
  561. }
  562. /**
  563. * 下载附件
  564. * @param {Object} ctx - egg全局变量
  565. * @return {void}
  566. */
  567. async downloadFile(ctx) {
  568. const id = ctx.params.id;
  569. if (id) {
  570. try {
  571. const fileInfo = await ctx.service.changeAtt.getDataById(id);
  572. if (fileInfo !== undefined && fileInfo !== '') {
  573. const fileName = path.join(this.app.baseDir, fileInfo.filepath);
  574. // 解决中文无法下载问题
  575. const userAgent = (ctx.request.header['user-agent'] || '').toLowerCase();
  576. let disposition = '';
  577. if (userAgent.indexOf('msie') >= 0 || userAgent.indexOf('chrome') >= 0) {
  578. disposition = 'attachment; filename=' + encodeURIComponent(fileInfo.filename + fileInfo.fileext);
  579. } else if (userAgent.indexOf('firefox') >= 0) {
  580. disposition = 'attachment; filename*="utf8\'\'' + encodeURIComponent(fileInfo.filename + fileInfo.fileext) + '"';
  581. } else {
  582. /* safari等其他非主流浏览器只能自求多福了 */
  583. disposition = 'attachment; filename=' + new Buffer(fileInfo.filename + fileInfo.fileext).toString('binary');
  584. }
  585. ctx.response.set({
  586. 'Content-Type': 'application/octet-stream',
  587. 'Content-Disposition': disposition,
  588. 'Content-Length': fileInfo.filesize,
  589. });
  590. ctx.body = await fs.createReadStream(fileName);
  591. } else {
  592. throw '不存在该文件';
  593. }
  594. } catch (err) {
  595. this.log(err);
  596. this.setMessage(err.toString(), this.messageType.ERROR);
  597. }
  598. }
  599. }
  600. /**
  601. * 删除附件
  602. * @param {Object} ctx - egg全局变量
  603. * @return {void}
  604. */
  605. async deleteFile(ctx) {
  606. const responseData = {
  607. err: 0,
  608. msg: '',
  609. data: '',
  610. };
  611. try {
  612. const data = JSON.parse(ctx.request.body.data);
  613. const fileInfo = await ctx.service.changeAtt.getDataById(data.id);
  614. if (fileInfo !== undefined && fileInfo !== '') {
  615. // 先删除文件
  616. await fs.unlinkSync(path.join(this.app.baseDir, fileInfo.filepath));
  617. // 再删除数据库
  618. await ctx.service.changeAtt.deleteById(data.id);
  619. responseData.data = '';
  620. } else {
  621. throw '不存在该文件';
  622. }
  623. // if (data.tid === undefined || data.uci === undefined || data.uc === undefined || data.ac === undefined) {
  624. // throw '参数有误';
  625. // }
  626. // const [addCompany, selectCompany] = await ctx.service.changeCompany.setCompanyList(data);
  627. // responseData.data = { add: addCompany, select: selectCompany };
  628. } catch (err) {
  629. responseData.err = 1;
  630. responseData.msg = err;
  631. }
  632. ctx.body = responseData;
  633. }
  634. /**
  635. * 删除变更令
  636. * @param {Object} ctx - egg全局变量
  637. * @return {void}
  638. */
  639. async delete(ctx) {
  640. try {
  641. const result = await ctx.service.change.delete(ctx.request.body.cid);
  642. if (!result) {
  643. throw '删除变更令失败';
  644. }
  645. ctx.redirect(ctx.request.header.referer);
  646. } catch (err) {
  647. console.log(err);
  648. ctx.redirect(ctx.request.header.referer);
  649. }
  650. }
  651. /**
  652. * 变更令重新审批
  653. * @param {Object} ctx - egg全局变量
  654. * @return {void}
  655. */
  656. async checkAgain(ctx) {
  657. try {
  658. const changeData = await ctx.service.change.getDataByCondition({ cid: ctx.request.body.cid });
  659. if (!changeData) {
  660. throw '变更令数据错误';
  661. }
  662. if (changeData.status !== audit.flow.status.checked || ctx.session.sessionUser.accountId !== changeData.uid) {
  663. throw '您无权进行该操作';
  664. }
  665. // 重新审批
  666. const result = await ctx.service.change.checkAgain(changeData.cid);
  667. if (!result) {
  668. throw '重新审批失败';
  669. }
  670. ctx.redirect('/tender/' + changeData.tid + '/change/' + changeData.cid + '/info');
  671. } catch (err) {
  672. console.log(err);
  673. ctx.redirect(ctx.request.header.referer);
  674. }
  675. }
  676. }
  677. return ChangeController;
  678. };