wap_controller.js 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747
  1. 'use strict';
  2. /**
  3. * 登录页面控制器
  4. *
  5. * @author CaiAoLin
  6. * @date 2017/11/15
  7. * @version
  8. */
  9. const URL = require('url');
  10. const maintainConst = require('../const/maintain');
  11. const auditConst = require('../const/audit');
  12. const changeConst = require('../const/change');
  13. const advanceConst = require('../const/advance');
  14. const fs = require('fs');
  15. const path = require('path');
  16. const sendToWormhole = require('stream-wormhole');
  17. const moment = require('moment');
  18. module.exports = app => {
  19. class WapController extends app.BaseController {
  20. /**
  21. * 登录页面
  22. *
  23. * @param {Object} ctx - egg全局页面
  24. * @return {void}
  25. */
  26. async index(ctx) {
  27. if (!ctx.helper.isMobile(ctx.request.header['user-agent'])) {
  28. ctx.redirect('/');
  29. return;
  30. }
  31. const errorMessage = ctx.session.loginError;
  32. // 显示完删除
  33. ctx.session.loginError = null;
  34. // 获取系统维护信息
  35. const maintainData = await ctx.service.maintain.getDataById(1);
  36. if (!ctx.app.config.is_debug) {
  37. await ctx.service.maintain.syncMaintainData();
  38. }
  39. let projectData = '';
  40. if (ctx.session.wapTenderID) {
  41. const tenderData = await ctx.service.tender.getDataById(ctx.session.wapTenderID);
  42. if (tenderData) projectData = await ctx.service.project.getDataById(tenderData.project_id);
  43. }
  44. const renderData = {
  45. maintainData,
  46. maintainConst,
  47. errorMessage,
  48. projectData,
  49. };
  50. await ctx.render('wap/login.ejs', renderData);
  51. }
  52. /**
  53. * 登录操作
  54. *
  55. * @param {Object} ctx - egg全局变量
  56. * @return {void}
  57. */
  58. async login(ctx) {
  59. let loginType = ctx.request.body.type;
  60. try {
  61. loginType = parseInt(loginType);
  62. const result = await ctx.service.projectAccount.accountLogin(ctx.request.body, loginType);
  63. if (!result) {
  64. throw '用户名或密码错误';
  65. }
  66. if (result === 2) {
  67. throw '该账号已被停用,请联系销售人员';
  68. }
  69. // 调用 rotateCsrfSecret 刷新用户的 CSRF token
  70. ctx.rotateCsrfSecret();
  71. // 判断是否已经有对应用户信息,没有则跳转初始化页面
  72. const needBoot = await ctx.service.customer.isNeedBoot(ctx.request.body);
  73. const url = needBoot ? '/boot' : '/wap/dashboard';
  74. const query = URL.parse(ctx.request.header.referer, true).query;
  75. let referer = '';
  76. if (ctx.session.wapTenderID) {
  77. referer = query.referer ? query.referer + '#shenpi' : url;
  78. ctx.session.wapTenderID = null;
  79. }
  80. ctx.redirect(referer ? referer : url);
  81. } catch (error) {
  82. this.log(error);
  83. ctx.session.loginError = error;
  84. ctx.redirect('/wap');
  85. }
  86. }
  87. /**
  88. * 退出登录
  89. *
  90. * @param {Object} ctx - egg全局变量
  91. * @return {void}
  92. */
  93. async logout(ctx) {
  94. // 删除session并跳转
  95. ctx.session = null;
  96. ctx.redirect('/wap');
  97. }
  98. /**
  99. * 待办页
  100. *
  101. * @param {Object} ctx - egg全局变量
  102. * @return {void}
  103. */
  104. async dashboard(ctx) {
  105. // 获取待审批的期
  106. const auditStages = await ctx.service.stageAudit.getAuditStageByWap(ctx.session.sessionUser.accountId);
  107. for (const audit of auditStages) {
  108. await this.ctx.service.stage.checkStageGatherData(audit);
  109. audit.gather_tp = ctx.helper.add(audit.contract_tp, audit.qc_tp);
  110. audit.end_contract_tp = ctx.helper.add(audit.contract_tp, audit.pre_contract_tp);
  111. audit.end_qc_tp = ctx.helper.add(audit.qc_tp, audit.pre_qc_tp);
  112. audit.end_gather_tp = ctx.helper.add(audit.end_contract_tp, audit.end_qc_tp);
  113. audit.pre_gather_tp = ctx.helper.add(audit.pre_contract_tp, audit.pre_qc_tp);
  114. }
  115. // 获取待审批的变更期
  116. const auditChanges = await ctx.service.changeAudit.getAuditChangeByWap(ctx.session.sessionUser.accountId);
  117. // 获取待审批的台账修订
  118. const auditRevise = await ctx.service.reviseAudit.getAuditReviseByWap(ctx.session.sessionUser.accountId);
  119. for (const revise of auditRevise) {
  120. const yb_audit = await ctx.service.projectAccount.getAccountInfoById(revise.audit_id);
  121. revise.yb_name = yb_audit.name;
  122. }
  123. // 获取待审批的预付款
  124. const auditAdvance = await ctx.service.advanceAudit.getAuditAdvanceByWap(ctx.session.sessionUser.accountId);
  125. const renderData = {
  126. auditStages,
  127. auditChanges,
  128. auditRevise,
  129. auditAdvance,
  130. changeConst,
  131. advanceConst,
  132. tpUnit: 2,
  133. };
  134. await ctx.render('wap/dashboard.ejs', renderData);
  135. }
  136. /**
  137. * 标段列表页
  138. *
  139. * @param {Object} ctx - egg全局变量
  140. * @return {void}
  141. */
  142. async list(ctx) {
  143. try {
  144. // 获取用户新建标段权利
  145. const accountInfo = await this.ctx.service.projectAccount.getDataById(ctx.session.sessionUser.accountId);
  146. const userPermission = accountInfo !== undefined && accountInfo.permission !== '' ? JSON.parse(accountInfo.permission) : null;
  147. const tenderList = await this.ctx.service.tender.getList('', userPermission);
  148. for (const t of tenderList) {
  149. if (t.user_id === this.ctx.session.sessionUser.accountId && (
  150. t.ledger_status === auditConst.ledger.status.checkNo || t.ledger_status === auditConst.ledger.status.uncheck)) {
  151. const sum = await this.ctx.service.ledger.addUp({tender_id: t.id/*, is_leaf: true*/});
  152. t.total_price = sum.total_price;
  153. t.deal_tp = sum.deal_tp;
  154. }
  155. if (t.ledger_status === auditConst.ledger.status.checked) {
  156. t.lastStage = await this.ctx.service.stage.getLastestStage(t.id, true);
  157. if (!t.lastStage) continue;
  158. if (t.lastStage.status === auditConst.stage.status.uncheck && t.lastStage.user_id !== this.ctx.session.sessionUser.accountId) {
  159. t.lastStage = await this.ctx.service.stage.getLastestStage(t.id);
  160. }
  161. if (!t.lastStage) continue;
  162. await this.ctx.service.stage.checkStageGatherData(t.lastStage);
  163. }
  164. }
  165. const categoryData = await this.ctx.service.category.getAllCategory(this.ctx.session.sessionProject.id);
  166. const valuations = await this.ctx.service.valuation.getProjectValidValuation(this.ctx.session.sessionProject.id);
  167. const renderData = {
  168. tenderList,
  169. categoryData,
  170. auditConst,
  171. userPermission,
  172. valuations,
  173. uid: this.ctx.session.sessionUser.accountId,
  174. pid: this.ctx.session.sessionProject.id,
  175. };
  176. await ctx.render('wap/list.ejs', renderData);
  177. } catch (err) {
  178. this.log(err);
  179. this.ctx.redirect('/wap/dashboard');
  180. }
  181. }
  182. /**
  183. * 标段详细页
  184. *
  185. * @param {Object} ctx - egg全局变量
  186. * @return {void}
  187. */
  188. async tender(ctx) {
  189. try {
  190. const tender = ctx.tender.data;
  191. if (tender.user_id === this.ctx.session.sessionUser.accountId && (
  192. tender.ledger_status === auditConst.ledger.status.checkNo || tender.ledger_status === auditConst.ledger.status.uncheck)) {
  193. const sum = await this.ctx.service.ledger.addUp({tender_id: tender.id/*, is_leaf: true*/});
  194. tender.total_price = sum.total_price;
  195. tender.deal_tp = sum.deal_tp;
  196. }
  197. const stages = await ctx.service.stage.getValidStages(ctx.tender.id);
  198. const lastStage = stages.length > 0 ? stages[0] : null; //await ctx.service.stage.getLastestStage(ctx.tender.id);
  199. if (lastStage) {
  200. await this.ctx.service.stage.checkStageGatherData(lastStage);
  201. tender.gather_tp = ctx.helper.add(lastStage.contract_tp, lastStage.qc_tp);
  202. tender.end_contract_tp = ctx.helper.add(lastStage.contract_tp, lastStage.pre_contract_tp);
  203. tender.end_qc_tp = ctx.helper.add(lastStage.qc_tp, lastStage.pre_qc_tp);
  204. tender.end_gather_tp = ctx.helper.add(tender.end_contract_tp, tender.end_qc_tp);
  205. tender.pre_gather_tp = ctx.helper.add(lastStage.pre_contract_tp, lastStage.pre_qc_tp);
  206. tender.yf_tp = lastStage.yf_tp;
  207. tender.qc_ratio = ctx.helper.mul(ctx.helper.div(tender.end_qc_tp, ctx.tender.info.deal_param.contractPrice, 2), 100);
  208. tender.sum = ctx.helper.add(tender.total_price, tender.end_qc_tp);
  209. tender.pre_ratio = ctx.helper.mul(ctx.helper.div(tender.pre_gather_tp, tender.sum, 2), 100);
  210. tender.cur_ratio = ctx.helper.mul(ctx.helper.div(tender.gather_tp, tender.sum, 2), 100);
  211. tender.other_tp = ctx.helper.sub(ctx.helper.sub(tender.sum, tender.pre_gather_tp), tender.gather_tp);
  212. tender.other_ratio = Math.max(0, 100 - tender.pre_ratio - tender.cur_ratio);
  213. }
  214. const monthProgress = [];
  215. for (const s of stages) {
  216. if (s.s_time) {
  217. let progress = monthProgress.find(function(x) {
  218. return x.month === s.s_time;
  219. });
  220. if (!progress) {
  221. progress = { month: s.s_time };
  222. monthProgress.push(progress);
  223. }
  224. progress.tp = ctx.helper.add(ctx.helper.add(progress.tp, s.contract_tp), s.qc_tp);
  225. }
  226. }
  227. monthProgress.sort(function(x, y) {
  228. return Date.parse(x.month) - Date.parse(y.month);
  229. });
  230. let sum = 0;
  231. for (const p of monthProgress) {
  232. p.ratio = ctx.helper.mul(ctx.helper.div(p.tp, tender.sum, 4), 100);
  233. sum = ctx.helper.add(sum, p.tp);
  234. p.end_tp = sum;
  235. p.end_ratio = ctx.helper.mul(ctx.helper.div(p.end_tp, tender.sum, 4), 100);
  236. }
  237. // 变更令列表
  238. const changes = await ctx.service.change.getListByStatus(tender.id, 0, 0);
  239. for (const c of changes) {
  240. c.curAuditor = await ctx.service.changeAudit.getLastUser(c.cid, c.times);
  241. }
  242. // 台账修订列表
  243. const revises = await ctx.service.ledgerRevise.getReviseList(ctx.tender.id);
  244. for (const lr of revises) {
  245. if (lr.valid) {
  246. lr.curAuditor = await ctx.service.reviseAudit.getAuditorByStatus(lr.id, lr.status, lr.times);
  247. }
  248. }
  249. // 预付款期数获取
  250. const advanceList = [];
  251. for (const t of advanceConst.typeCol) {
  252. const advance = await ctx.service.advance.getLastestAdvance(ctx.tender.id, t.type, true);
  253. advanceList.push(advance);
  254. }
  255. const renderData = {
  256. tender,
  257. stages,
  258. changes,
  259. revises,
  260. advanceList,
  261. auditConst: auditConst.stage,
  262. auditChangeConst: auditConst.flow,
  263. auditReviseConst: auditConst.revise,
  264. changeConst,
  265. advanceConst,
  266. tpUnit: ctx.tender.info.decimal.tp,
  267. monthProgress,
  268. stagesEcharts: JSON.parse(JSON.stringify(stages)).reverse(),
  269. };
  270. if (stages.length > 0) {
  271. for (const s of stages) {
  272. // s.curAuditor = null;
  273. // 根据期状态返回展示用户
  274. s.curAuditor = await ctx.service.stageAudit.getAuditorByStatus(s.id, s.status, s.times);
  275. if (s.status === auditConst.stage.status.checkNoPre) {
  276. s.curAuditor2 = await ctx.service.stageAudit.getAuditorByStatus(s.id, auditConst.stage.status.checking);
  277. }
  278. }
  279. renderData.stage = stages[0];
  280. const times = renderData.stage.status === auditConst.stage.status.checkNo ? renderData.stage.times - 1 : renderData.stage.times;
  281. renderData.stage.user = await ctx.service.projectAccount.getAccountInfoById(renderData.stage.user_id);
  282. renderData.stage.auditors = await ctx.service.stageAudit.getAuditors(renderData.stage.id, times);
  283. // 获取审批流程中左边列表
  284. renderData.stage.auditors2 = await ctx.service.stageAudit.getAuditGroupByList(renderData.stage.id, times);
  285. }
  286. await ctx.render('wap/tender.ejs', renderData);
  287. } catch (err) {
  288. this.log(err);
  289. ctx.redirect('/wap/list');
  290. }
  291. }
  292. /**
  293. * 期审批详细页
  294. *
  295. * @param {Object} ctx - egg全局变量
  296. * @return {void}
  297. */
  298. async stage(ctx) {
  299. try {
  300. const tender = ctx.tender.data;
  301. const stages = await ctx.service.stage.getValidStages(ctx.tender.id);
  302. const lastStage = stages.length > 0 ? stages[0] : null;
  303. if (lastStage) {
  304. await this.ctx.service.stage.checkStageGatherData(lastStage);
  305. }
  306. const stage = lastStage;
  307. const renderData = {
  308. tender,
  309. stage,
  310. auditConst: auditConst.stage,
  311. };
  312. const times = renderData.stage.status === auditConst.stage.status.checkNo ? renderData.stage.times - 1 : renderData.stage.times;
  313. renderData.stage.user = await ctx.service.projectAccount.getAccountInfoById(renderData.stage.user_id);
  314. renderData.stage.auditors = await ctx.service.stageAudit.getAuditors(renderData.stage.id, times);
  315. // 获取审批流程中左边列表
  316. renderData.stage.auditors2 = await ctx.service.stageAudit.getAuditGroupByList(renderData.stage.id, times);
  317. await ctx.render('wap/shenpi_stage.ejs', renderData);
  318. } catch (err) {
  319. this.log(err);
  320. ctx.redirect('/wap/list');
  321. }
  322. }
  323. /**
  324. * 变更审批详细页
  325. *
  326. * @param {Object} ctx - egg全局变量
  327. * @return {void}
  328. */
  329. async change(ctx) {
  330. try {
  331. const tender = ctx.tender.data;
  332. const change = await ctx.service.change.getDataByCondition({ cid: ctx.params.cid });
  333. const times = change.status !== auditConst.flow.status.back ? change.times : change.times - 1;
  334. const auditList = await ctx.service.changeAudit.getListOrderByTimes(change.cid, times);
  335. const auditGroupList = await ctx.service.changeAudit.getListGroupByTimes(change.cid, times);
  336. const renderData = {
  337. tender,
  338. change,
  339. auditList,
  340. auditGroupList,
  341. auditConst: auditConst.flow,
  342. changeConst,
  343. tpUnit: ctx.tender.info.decimal.tp,
  344. };
  345. await ctx.render('wap/shenpi_change.ejs', renderData);
  346. } catch (err) {
  347. this.log(err);
  348. ctx.redirect('/wap/list');
  349. }
  350. }
  351. /**
  352. * 修订审批详细页
  353. *
  354. * @param {Object} ctx - egg全局变量
  355. * @return {void}
  356. */
  357. async revise(ctx) {
  358. try {
  359. const tender = ctx.tender.data;
  360. const revise = await ctx.service.ledgerRevise.getDataByCondition({ id: ctx.params.rid });
  361. revise.user = await ctx.service.projectAccount.getAccountInfoById(revise.uid);
  362. const times = revise.status === auditConst.revise.status.checkNo ? revise.times - 1 : revise.times;
  363. revise.curAuditor = await ctx.service.reviseAudit.getAuditorByStatus(revise.id, revise.status, times);
  364. revise.auditors = await ctx.service.reviseAudit.getAuditors(revise.id, times);
  365. console.log(times, revise.auditors);
  366. const renderData = {
  367. tender,
  368. revise,
  369. auditConst: auditConst.revise,
  370. };
  371. await ctx.render('wap/shenpi_revise.ejs', renderData);
  372. } catch (err) {
  373. this.log(err);
  374. ctx.redirect('/wap/list');
  375. }
  376. }
  377. /**
  378. * 预付款列表页
  379. *
  380. * @param {Object} ctx - egg全局变量
  381. * @return {void}
  382. */
  383. async advance(ctx) {
  384. try {
  385. const tender = ctx.tender.data;
  386. const { decimal } = ctx.tender.info;
  387. this.decimal = decimal.pay ? decimal.payTp : decimal.tp;
  388. const advancePayTotalList = [];
  389. const advanceList = [];
  390. for (const t of advanceConst.typeCol) {
  391. const advancePayTotal = ctx.tender.info.deal_param[t.key + 'Advance'];
  392. advancePayTotalList.push(advancePayTotal);
  393. const advances = await ctx.service.advance.getAdvanceList(ctx.tender.id, t.type, this.decimal, advancePayTotal);
  394. advanceList.push(advances);
  395. }
  396. const renderData = {
  397. tender,
  398. advancePayTotalList,
  399. advanceList,
  400. auditConst: auditConst.advance,
  401. advanceConst,
  402. };
  403. await ctx.render('wap/shenpi_advance.ejs', renderData);
  404. } catch (err) {
  405. this.log(err);
  406. ctx.redirect('/wap/list');
  407. }
  408. }
  409. /**
  410. * 预付款详情页 GET
  411. * @param {Object} ctx 全局上下文
  412. */
  413. async advanceDetail(ctx) {
  414. try {
  415. const tender = ctx.tender.data;
  416. ctx.advance.advancePayTotal = ctx.tender.info.deal_param[ advanceConst.typeCol[ctx.advance.type].key + 'Advance'];
  417. const times = ctx.advance.status === auditConst.advance.status.checkNo ? ctx.advance.times - 1 : ctx.advance.times;
  418. if (ctx.advance.status === auditConst.advance.status.checkNo) {
  419. ctx.advance.curAuditor = await ctx.service.advanceAudit.getAuditorByStatus(ctx.advance.id, ctx.advance.status, times);
  420. ctx.advance.auditors = await ctx.service.advanceAudit.getAuditors(ctx.advance.id, times);
  421. }
  422. // 获取审批流程中左边列表
  423. ctx.advance.auditors2 = await ctx.service.advanceAudit.getAuditGroupByList(ctx.advance.id, times);
  424. const renderData = {
  425. tender,
  426. advance: ctx.advance,
  427. auditConst: auditConst.advance,
  428. advanceConst,
  429. };
  430. await ctx.render('wap/shenpi_advance_detail.ejs', renderData);
  431. } catch (error) {
  432. this.log(error);
  433. ctx.redirect('/wap/tender/' + ctx.tender.id + '/advance');
  434. }
  435. }
  436. /**
  437. * 变更令审批
  438. * @param {Object} ctx - egg全局变量
  439. * @return {void}
  440. */
  441. async changeApproval(ctx) {
  442. try {
  443. const changeData = await ctx.service.change.getDataByCondition({ cid: ctx.request.body.change_id });
  444. if (!changeData) {
  445. throw '变更令数据错误';
  446. }
  447. const status = parseInt(ctx.request.body.status);
  448. const pid = this.ctx.session.sessionProject.id;
  449. let result = false;
  450. switch (status) {
  451. case 3:// 审批通过
  452. // 获取前一个人的list,生成bills_list
  453. // 获取已选清单
  454. const changeList = await ctx.service.changeAuditList.getAllDataByCondition({ where: { cid: ctx.request.body.change_id } });
  455. const bills_array = [];
  456. for (const cl of changeList) {
  457. const bill = cl.id + '_' + cl.spamount;
  458. bills_array.push(bill);
  459. }
  460. const postData = ctx.request.body;
  461. postData.bills_list = bills_array.join(',');
  462. result = await ctx.service.change.approvalSuccess(pid, ctx.request.body, changeData);
  463. break;
  464. case 4:// 审批终止
  465. result = await ctx.service.change.approvalStop(ctx.request.body);
  466. break;
  467. case 5:// 审批退回到原报人
  468. result = await ctx.service.change.approvalBack(pid, ctx.request.body, changeData);
  469. break;
  470. case 6:// 审批退回到上一个审批人
  471. result = await ctx.service.change.approvalBackNew(pid, ctx.request.body, changeData);
  472. break;
  473. default:break;
  474. }
  475. if (!result) {
  476. throw '审批失败';
  477. }
  478. ctx.redirect(ctx.request.header.referer);
  479. } catch (err) {
  480. console.log(err);
  481. ctx.redirect(ctx.request.header.referer);
  482. }
  483. }
  484. /**
  485. * 收方单附件上传页
  486. * @param {Object} ctx - egg全局变量
  487. * @return {void}
  488. */
  489. async shoufangUpload(ctx) {
  490. try {
  491. const tid = parseInt(ctx.query.tid) || 0;
  492. const order = parseInt(ctx.query.order) || 0;
  493. const sfid = parseInt(ctx.query.sfid) || 0;
  494. if (!tid || !order || !sfid) {
  495. throw '参数有误';
  496. }
  497. const tender = await ctx.service.tender.getDataById(tid);
  498. if (!tender) {
  499. throw '该标段不存在';
  500. }
  501. const sfInfo = await ctx.service.stageShoufang.getDataByCondition({ id: sfid, tid, order });
  502. if (!sfInfo) {
  503. throw '该收方单不存在';
  504. }
  505. // 查找对应的台账或计量单元名称
  506. const ledger = await ctx.service.ledger.getData(tid);
  507. const ledgerInfo = ctx.helper._.find(ledger, { id: sfInfo.lid });
  508. let name = ledgerInfo.b_code;
  509. if (sfInfo.pid) {
  510. const pos = await ctx.service.pos.getPosData({ tid });
  511. const posInfo = ctx.helper._.find(pos, { lid: sfInfo.lid, id: sfInfo.pid });
  512. name += ' / ' + posInfo.name;
  513. }
  514. const renderData = {
  515. tender,
  516. order,
  517. name,
  518. sfid,
  519. whiteList: this.ctx.app.config.multipart.whitelist,
  520. };
  521. await ctx.render('wap/shoufangupload.ejs', renderData);
  522. } catch (error) {
  523. this.log(error);
  524. ctx.redirect('/wap/login');
  525. }
  526. }
  527. /**
  528. * 上传附件
  529. * @param {Object} ctx - egg全局变量
  530. * @return {void}
  531. */
  532. async shoufangUpFile(ctx) {
  533. const responseData = {
  534. err: 0,
  535. msg: '',
  536. data: [],
  537. };
  538. let stream;
  539. try {
  540. const parts = ctx.multipart({ autoFields: true });
  541. const files = [];
  542. let index = 0;
  543. while ((stream = await parts()) !== undefined) {
  544. // 判断是否存在
  545. const sfInfo = await ctx.service.stageShoufang.getDataById(parts.field.sfid);
  546. if (!sfInfo) {
  547. throw '该清单 / 计量单元下不存在收方单';
  548. }
  549. // 判断用户是否选择上传文件
  550. if (!stream.filename) {
  551. throw '请选择上传的文件!';
  552. }
  553. // const dirName = 'app/public/upload/stage/' + moment().format('YYYYMMDD');
  554. // 判断文件夹是否存在,不存在则直接创建文件夹
  555. // if (!fs.existsSync(path.join(this.app.baseDir, dirName))) {
  556. // await fs.mkdirSync(path.join(this.app.baseDir, dirName));
  557. // }
  558. const fileInfo = path.parse(stream.filename);
  559. const now_time = new Date();
  560. const create_time = Date.parse(now_time) / 1000;
  561. const filepath = `app/public/upload/${sfInfo.tid}/stage/shoufang/fujian_${create_time + index.toString() + fileInfo.ext}`;
  562. await ctx.helper.saveStreamFile(stream, path.resolve(this.app.baseDir, filepath));
  563. // console.log(await fs.existsSync(path.resolve(this.app.baseDir, 'app', filepath)));
  564. // const fileInfo = path.parse(stream.filename);
  565. // const fileName = 'stage' + create_time + '_' + index + fileInfo.ext;
  566. // 保存文件
  567. // await ctx.helper.saveStreamFile(stream, path.resolve(this.app.baseDir, dirName, fileName));
  568. if (stream) {
  569. await sendToWormhole(stream);
  570. }
  571. // 保存数据到att表
  572. const fileData = {
  573. tid: sfInfo.tid,
  574. sid: sfInfo.sid,
  575. sfid: sfInfo.id,
  576. in_time: now_time,
  577. filename: fileInfo.name,
  578. fileext: fileInfo.ext,
  579. filesize: Array.isArray(parts.field.size) ? parts.field.size[index] : parts.field.size,
  580. filepath,
  581. };
  582. // if (ctx.reUploadPermission) {
  583. // fileData.re_upload = 1;
  584. // }
  585. const result = await ctx.service.stageShoufangAtt.save(fileData);
  586. if (!result) {
  587. throw '导入数据库保存失败';
  588. }
  589. const attData = await ctx.service.stageShoufangAtt.getDataByFid(result.insertId);
  590. attData.in_time = moment(create_time * 1000).format('YYYY-MM-DD');
  591. files.length !== 0 ? files.unshift(attData) : files.push(attData);
  592. ++index;
  593. }
  594. responseData.data = files;
  595. } catch (err) {
  596. this.log(err);
  597. // 失败需要消耗掉stream 以防卡死
  598. if (stream) {
  599. await sendToWormhole(stream);
  600. }
  601. this.setMessage(err.toString(), this.messageType.ERROR);
  602. responseData.err = 1;
  603. responseData.msg = err.toString();
  604. }
  605. ctx.body = responseData;
  606. }
  607. /**
  608. * 删除附件
  609. * @param {Object} ctx - egg全局变量
  610. * @return {void}
  611. */
  612. async shoufangDeleteFile(ctx) {
  613. const responseData = {
  614. err: 0,
  615. msg: '',
  616. data: '',
  617. };
  618. try {
  619. const data = JSON.parse(ctx.request.body.data);
  620. const fileInfo = await ctx.service.stageShoufangAtt.getDataById(data.id);
  621. if (!fileInfo || !Object.keys(fileInfo).length) {
  622. throw '该文件不存在';
  623. }
  624. if (fileInfo !== undefined && fileInfo !== '') {
  625. // 先删除文件
  626. await fs.unlinkSync(path.join(this.app.baseDir, fileInfo.filepath));
  627. // 再删除数据库
  628. await ctx.service.stageShoufangAtt.deleteById(data.id);
  629. responseData.data = '';
  630. } else {
  631. throw '不存在该文件';
  632. }
  633. } catch (err) {
  634. responseData.err = 1;
  635. responseData.msg = err;
  636. }
  637. ctx.body = responseData;
  638. }
  639. /**
  640. * 编辑附件
  641. * @param {Object} ctx - egg全局变量
  642. * @return {void}
  643. */
  644. async shoufangEditFile(ctx) {
  645. const responseData = {
  646. err: 0,
  647. msg: '',
  648. data: '',
  649. };
  650. try {
  651. const data = JSON.parse(ctx.request.body.data);
  652. const fileInfo = await ctx.service.stageShoufangAtt.getDataById(data.id);
  653. if (!fileInfo || !Object.keys(fileInfo).length) {
  654. throw '该文件不存在';
  655. }
  656. await ctx.service.stageShoufangAtt.edit(data);
  657. } catch (err) {
  658. responseData.err = 1;
  659. responseData.msg = err;
  660. }
  661. ctx.body = responseData;
  662. }
  663. /**
  664. * 下载附件
  665. * @param {Object} ctx - egg全局变量
  666. * @return {void}
  667. */
  668. async shoufangDownloadFile(ctx) {
  669. const id = ctx.params.fid;
  670. if (id) {
  671. try {
  672. const fileInfo = await ctx.service.stageShoufangAtt.getDataById(id);
  673. if (fileInfo !== undefined && fileInfo !== '') {
  674. const fileName = path.join(this.app.baseDir, fileInfo.filepath);
  675. // 解决中文无法下载问题
  676. const userAgent = (ctx.request.header['user-agent'] || '').toLowerCase();
  677. let disposition = '';
  678. if (userAgent.indexOf('msie') >= 0 || userAgent.indexOf('chrome') >= 0) {
  679. disposition = 'attachment; filename=' + encodeURIComponent(fileInfo.filename + fileInfo.fileext);
  680. } else if (userAgent.indexOf('firefox') >= 0) {
  681. disposition = 'attachment; filename*="utf8\'\'' + encodeURIComponent(fileInfo.filename + fileInfo.fileext) + '"';
  682. } else {
  683. /* safari等其他非主流浏览器只能自求多福了 */
  684. disposition = 'attachment; filename=' + new Buffer(fileInfo.filename + fileInfo.fileext).toString('binary');
  685. }
  686. ctx.response.set({
  687. 'Content-Type': 'application/octet-stream',
  688. 'Content-Disposition': disposition,
  689. 'Content-Length': fileInfo.filesize,
  690. });
  691. ctx.body = await fs.createReadStream(fileName);
  692. } else {
  693. throw '不存在该文件';
  694. }
  695. } catch (err) {
  696. this.log(err);
  697. this.setMessage(err.toString(), this.messageType.ERROR);
  698. }
  699. }
  700. }
  701. }
  702. return WapController;
  703. };