material_controller.js 39 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author EllisRan
  6. * @date 2018/6/20
  7. * @version
  8. */
  9. const moment = require('moment');
  10. const auditConst = require('../const/audit').material;
  11. const auditStageConst = require('../const/audit').stage;
  12. const tenderConst = require('../const/tender');
  13. const measureType = tenderConst.measureType;
  14. const accountGroup = require('../const/account_group').group;
  15. const materialConst = require('../const/material');
  16. const MaterialCalculator = require('../lib/material_calc');
  17. const sendToWormhole = require('stream-wormhole');
  18. const fs = require('fs');
  19. const path = require('path');
  20. const _ = require('lodash');
  21. const { typeOf } = require('mathjs');
  22. module.exports = app => {
  23. class MaterialController 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.showTender = true;
  34. ctx.showTitle = true;
  35. }
  36. /**
  37. * 期列表(Get)
  38. * @param ctx
  39. * @return {Promise<void>}
  40. */
  41. async index(ctx) {
  42. try {
  43. const renderData = {
  44. tender: ctx.tender.data,
  45. tenderMenu: this.menu.tenderMenu,
  46. preUrl: '/tender/' + ctx.tender.id,
  47. auditConst,
  48. auditConst2: JSON.stringify(auditConst),
  49. };
  50. renderData.materials = await ctx.service.material.getValidMaterials(ctx.tender.id);
  51. // 获取未选中和已完成的计量期
  52. const stages = await ctx.service.stage.getAllDataByCondition({ where: { tid: ctx.tender.id, status: auditStageConst.status.checked } });
  53. for (const s of renderData.materials) {
  54. // s.curAuditor = null;
  55. // 根据期状态返回展示用户
  56. s.curAuditor = await ctx.service.materialAudit.getAuditorByStatus(s.id, s.status, s.times);
  57. const materialStageList = s.stage_id.split(',');
  58. for (const ms of materialStageList) {
  59. const index = stages.findIndex(function(item) {
  60. return item.id === parseInt(ms);
  61. });
  62. stages.splice(index, 1);
  63. }
  64. }
  65. renderData.stages = stages;
  66. await this.layout('material/index.ejs', renderData, 'material/modal.ejs');
  67. } catch (err) {
  68. this.log(err);
  69. ctx.redirect(this.menu.menu.dashboard.url);
  70. }
  71. }
  72. /**
  73. * 期审批流程(Get)
  74. * @param ctx
  75. * @return {Promise<void>}
  76. */
  77. async materialAuditors(ctx) {
  78. try {
  79. const responseData = {
  80. err: 0, msg: '', data: {},
  81. };
  82. const order = JSON.parse(ctx.request.body.data).order;
  83. const tenderId = ctx.params.id;
  84. const materialInfo = await ctx.service.material.getDataByCondition({ tid: tenderId, order });
  85. // 获取审批流程中右边列表
  86. const auditHistory = [];
  87. const times = materialInfo.status === auditConst.status.checkNo ? materialInfo.times - 1 : materialInfo.times;
  88. if (times >= 1) {
  89. for (let i = 1; i <= times; i++) {
  90. auditHistory.push(await ctx.service.materialAudit.getAuditors(materialInfo.id, i));
  91. }
  92. }
  93. responseData.data.auditHistory = auditHistory;
  94. // 获取审批流程中左边列表
  95. responseData.data.auditors = await ctx.service.materialAudit.getAuditGroupByList(materialInfo.id, times);
  96. responseData.data.user = await ctx.service.projectAccount.getAccountInfoById(materialInfo.user_id);
  97. // 获取原报信息
  98. // const materialAuditor = await ctx.service.projectAccount.getAccountInfoById(materialInfo.user_id);
  99. // responseData.data.materialAuditor = materialAuditor;
  100. ctx.body = responseData;
  101. } catch (error) {
  102. this.log(error);
  103. ctx.body = { err: 1, msg: error.toString(), data: null };
  104. }
  105. }
  106. /**
  107. * 新增期(Post)
  108. * @param ctx
  109. * @return {Promise<void>}
  110. */
  111. async add(ctx) {
  112. try {
  113. if (ctx.session.sessionUser.accountId !== ctx.tender.data.user_id) {
  114. throw '您无权创建材料调差期';
  115. }
  116. const data = ctx.request.body;
  117. if (data.s_order === '') {
  118. throw '没有选中计量期';
  119. }
  120. const newMaterial = await ctx.service.material.addMaterial(ctx.tender.id, data);
  121. if (!newMaterial) {
  122. throw '新增材料调差期失败,请重试';
  123. }
  124. ctx.redirect('/tender/' + ctx.tender.id + '/measure/material/' + newMaterial.order);
  125. } catch (err) {
  126. this.log(err);
  127. ctx.redirect(ctx.request.header.referer);
  128. }
  129. }
  130. /**
  131. * 删除期(Post)
  132. * @param ctx
  133. * @return {Promise<void>}
  134. */
  135. async delete(ctx) {
  136. try {
  137. const material_id = ctx.request.body.material_id;
  138. const materialInfo = await ctx.service.material.getDataById(material_id);
  139. // 获取最新的期数
  140. const material_highOrder = await ctx.service.material.count({
  141. tid: ctx.tender.id,
  142. });
  143. if (materialInfo === undefined || ctx.session.sessionUser.accountId !== materialInfo.user_id || material_highOrder !== materialInfo.order) {
  144. throw '您无权删除材料调差期';
  145. }
  146. const result = await ctx.service.material.deleteMaterial(material_id);
  147. if (!result) {
  148. throw '删除材料调差期失败,请重试';
  149. }
  150. ctx.redirect('/tender/' + ctx.tender.id + '/measure/material/');
  151. } catch (err) {
  152. this.log(err);
  153. ctx.redirect(ctx.request.header.referer);
  154. }
  155. }
  156. /**
  157. * 获取通用的renderData(用于layout, Menu, subMenu部分)
  158. * @param ctx
  159. * @return {{tender, tenderMenu, auditConst}}
  160. * @private
  161. */
  162. async _getDefaultRenderData(ctx) {
  163. const data = {
  164. tender: ctx.tender.data,
  165. tenderMenu: JSON.parse(JSON.stringify(this.menu.stageMenu)),
  166. auditConst,
  167. measureType,
  168. preUrl: '/tender/' + ctx.tender.id + '/measure/material/' + ctx.params.order,
  169. material: ctx.material,
  170. };
  171. if ((ctx.material.status === auditConst.status.uncheck || ctx.material.status === auditConst.status.checkNo) && ctx.session.sessionUser.accountId === ctx.material.user_id) {
  172. // data.accountGroup = accountGroup;
  173. // 获取所有项目参与者
  174. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  175. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  176. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  177. });
  178. data.accountList = accountList;
  179. data.accountGroup = accountGroup.map((item, idx) => {
  180. const groupList = accountList.filter(item => item.account_group === idx);
  181. return { groupName: item, groupList };
  182. });
  183. }
  184. data.tenderMenu.back.children[0].url = '/tender/' + ctx.tender.id + '/measure/material';
  185. return data;
  186. }
  187. _materialReadOnly(material) {
  188. return material.status === auditConst.status.checked;
  189. }
  190. /**
  191. * 获取审批界面所需的 原报、审批人数据等
  192. * @param ctx
  193. * @return {Promise<void>}
  194. * @private
  195. */
  196. async _getMaterialAuditViewData(ctx) {
  197. const times = ctx.material.status === auditConst.status.checkNo ? ctx.material.times - 1 : ctx.material.times;
  198. ctx.material.user = await ctx.service.projectAccount.getAccountInfoById(ctx.material.user_id);
  199. ctx.material.auditHistory = [];
  200. if (times >= 1) {
  201. for (let i = 1; i <= times; i++) {
  202. ctx.material.auditHistory.push(await ctx.service.materialAudit.getAuditors(ctx.material.id, i));
  203. }
  204. }
  205. // 获取审批流程中左边列表
  206. ctx.material.auditors2 = await ctx.service.materialAudit.getAuditorsWithOwner(ctx.material.id, times);
  207. if (ctx.material.status === auditConst.status.uncheck || ctx.material.status === auditConst.status.checkNo) {
  208. ctx.material.auditorList = await ctx.service.materialAudit.getAuditors(ctx.material.id, ctx.material.times);
  209. }
  210. }
  211. /**
  212. * 获取当前期工料列表信息
  213. * @param ctx
  214. * @return {Promise<void>}
  215. * @private
  216. */
  217. async _getMaterialBillsData(ctx) {
  218. // 根据期判断需要获取的工料信息值
  219. const searchsql = { tid: ctx.tender.id };
  220. if (ctx.material.highOrder !== ctx.material.order) {
  221. const midList = await ctx.service.material.getPreMidList(ctx.tender.id, ctx.material.order);
  222. searchsql.mid = midList;
  223. }
  224. // 取所有工料表
  225. return await ctx.service.materialBills.getAllDataByCondition({ where: searchsql });
  226. }
  227. /**
  228. * 获取当前月信息价列表信息
  229. * @param ctx
  230. * @return {Promise<void>}
  231. * @private
  232. */
  233. async _getMaterialMonthsData(ctx, materialBillsData) {
  234. // 取月信息价表
  235. const monthsList = [];
  236. if (ctx.material.months) {
  237. const material_month = ctx.material.months.split(',');
  238. const materialMonthList = await ctx.service.materialMonth.getListByMid(ctx.material.id);
  239. for (const mbd of materialBillsData) {
  240. const one_mb = {
  241. code: mbd.code,
  242. name: mbd.name,
  243. unit: mbd.unit,
  244. mb_id: mbd.id,
  245. };
  246. for (const m of material_month) {
  247. const one_mm = _.find(materialMonthList, { mb_id: mbd.id, yearmonth: m });
  248. one_mb[m] = one_mm.msg_tp;
  249. }
  250. monthsList.push(one_mb);
  251. }
  252. }
  253. return monthsList;
  254. }
  255. /**
  256. * 调差工料页面 (Get)
  257. * @param {Object} ctx - egg全局变量
  258. * @return {Promise<void>}
  259. */
  260. async info(ctx) {
  261. try {
  262. await this._getMaterialAuditViewData(ctx);
  263. const renderData = await this._getDefaultRenderData(ctx);
  264. renderData.materialBillsData = await this._getMaterialBillsData(ctx);
  265. // 取对应期的截取上期的调差金额和应耗数量
  266. if (ctx.material.highOrder !== ctx.material.order) {
  267. for (const [mindex, mb] of renderData.materialBillsData.entries()) {
  268. const result = await ctx.service.materialBillsHistory.getByMbId(ctx.material.id, ctx.material.order, mb.id);
  269. _.forEach(result, function(value, key) {
  270. renderData.materialBillsData[mindex][key] = result ? result[key] : null;
  271. });
  272. // if (result) {
  273. // renderData.materialBillsData[mindex].quantity = result.quantity;
  274. // renderData.materialBillsData[mindex].expr = result.expr;
  275. // renderData.materialBillsData[mindex].msg_tp = result.msg_tp;
  276. // renderData.materialBillsData[mindex].msg_times = result.msg_times;
  277. // renderData.materialBillsData[mindex].msg_spread = result.msg_spread;
  278. // renderData.materialBillsData[mindex].m_up_risk = result.m_up_risk;
  279. // renderData.materialBillsData[mindex].m_down_risk = result.m_down_risk;
  280. // renderData.materialBillsData[mindex].m_spread = result.m_spread;
  281. // renderData.materialBillsData[mindex].pre_tp = result.pre_tp;
  282. // } else {
  283. // this._.forEach(renderData.materialBillsData[mindex], function(value, key) {
  284. // renderData.materialBillsData[mindex][key] = null;
  285. // });
  286. // }
  287. }
  288. }
  289. // 取所有已被调用的工料清单表
  290. renderData.materialListData = await ctx.service.materialList.getAllDataByCondition({ tid: ctx.tender.id, mid: ctx.material.id });
  291. // 基数
  292. // if (!ctx.material.readOnly) {
  293. const stage_list = await ctx.service.stage.getStageMsgByStageId(ctx.material.stage_id);
  294. renderData.calcBase = await ctx.service.stage.getMaterialCalcBase(stage_list, ctx.tender.info);
  295. // }
  296. // 取当前期截止上期含税金额
  297. renderData.pre_tp_hs = await ctx.service.material.getPreTpHs(ctx.tender.id, ctx.material.order);
  298. renderData.months = ctx.material.months ? ctx.material.months.split(',') : [];
  299. renderData.monthsList = await this._getMaterialMonthsData(ctx, renderData.materialBillsData);
  300. renderData.materialType = JSON.stringify(materialConst);
  301. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.material.info);
  302. await this.layout('material/info.ejs', renderData, 'material/info_modal.ejs');
  303. } catch (err) {
  304. this.log(err);
  305. ctx.redirect('/tender/' + ctx.tender.id + '/measure/material');
  306. }
  307. }
  308. /**
  309. * 调差清单页面 (Get)
  310. * @param {Object} ctx - egg全局变量
  311. * @return {Promise<void>}
  312. */
  313. async list(ctx) {
  314. try {
  315. await this._getMaterialAuditViewData(ctx);
  316. const renderData = await this._getDefaultRenderData(ctx);
  317. // 根据期判断需要获取的工料信息值表
  318. const searchsql = { tid: ctx.tender.id };
  319. let midList = [];
  320. if (ctx.material.highOrder !== ctx.material.order) {
  321. midList = await ctx.service.material.getPreMidList(ctx.tender.id, ctx.material.order);
  322. searchsql.mid = midList;
  323. }
  324. searchsql.t_type = materialConst.t_type[0].value;
  325. renderData.materialBillsData = await ctx.service.materialBills.getAllDataByCondition({ where: searchsql });
  326. // 取所有已被调用的工料清单表
  327. renderData.materialListData = await ctx.service.materialList.getMaterialData(ctx.tender.id, ctx.material.id);
  328. renderData.materialNotJoinListData = await ctx.service.materialListNotjoin.getAllDataByCondition({ where: { tid: ctx.tender.id, mid: ctx.material.id } });
  329. renderData.materialType = JSON.stringify(materialConst);
  330. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.material.list);
  331. // 获取清单数据
  332. renderData.ledger = await ctx.service.ledger.getData(ctx.tender.id);
  333. renderData.pos = await ctx.service.pos.getPosData({ tid: ctx.tender.id });
  334. // 获取所选期数据并合并相加同类清单项
  335. renderData.curLedgerData = await ctx.service.stageBills.getStagesData(ctx.tender.id, ctx.material.stage_id);
  336. renderData.curPosData = await ctx.service.stagePos.getStagesData(ctx.tender.id, ctx.material.stage_id);
  337. await this.layout('material/list.ejs', renderData, 'material/list_modal.ejs');
  338. } catch (err) {
  339. this.log(err);
  340. ctx.redirect('/tender/' + ctx.tender.id + '/measure/material');
  341. }
  342. }
  343. /**
  344. * 附件页面 (Get)
  345. * @param {Object} ctx - egg全局变量
  346. * @return {Promise<void>}
  347. */
  348. async file(ctx) {
  349. try {
  350. await this._getMaterialAuditViewData(ctx);
  351. const renderData = await this._getDefaultRenderData(ctx);
  352. const whiteList = this.ctx.app.config.multipart.whitelist;
  353. // 获取当前标段所有附件
  354. // const searchsql = { tid: ctx.tender.id };
  355. renderData.fileList = await ctx.service.materialFile.getAllMaterialFiles(ctx.tender.id);
  356. renderData.auditors = ctx.material.auditors.map(audit => audit.aid);
  357. // renderData.auditors = ctx.material.auditors2.map(audit => audit.aid);
  358. renderData.report_id = ctx.material.user_id;
  359. renderData.auditConst = auditConst;
  360. renderData.whiteList = whiteList;
  361. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.material.file);
  362. await this.layout('material/file.ejs', renderData, 'material/file_modal.ejs');
  363. } catch (err) {
  364. this.log(err);
  365. ctx.redirect('/tender/' + ctx.tender.id + '/measure/material');
  366. }
  367. }
  368. /**
  369. * 调差清单 - 工料操作 (Ajax)
  370. * @param ctx
  371. * @return {Promise<void>}
  372. */
  373. async saveListsData(ctx) {
  374. try {
  375. const data = JSON.parse(ctx.request.body.data);
  376. const responseData = {
  377. err: 0,
  378. msg: '',
  379. data: {},
  380. };
  381. switch (data.type) {
  382. case 'add':
  383. responseData.data = await ctx.service.materialList.add(data.postData);
  384. break;
  385. case 'del':
  386. await ctx.service.materialList.del(data.id, data.mb_id);
  387. break;
  388. case 'update':
  389. if (data.updateData.quantity === '' || data.updateData.quantity === null) {
  390. throw '请输入数量';
  391. }
  392. // 判断数量是否为数字
  393. if (isNaN(data.updateData.quantity)) {
  394. throw '不能输入其它非数字类型字符';
  395. }
  396. await ctx.service.materialList.save(data.updateData);
  397. break;
  398. case 'useOther':
  399. responseData.data = await ctx.service.materialList.addOther(data.postData);
  400. break;
  401. case 'join':
  402. await ctx.service.materialListNotjoin.del(data.select.id);
  403. break;
  404. case 'notjoin':
  405. responseData.data = await ctx.service.materialListNotjoin.add(data.select);
  406. break;
  407. case 'paste':
  408. await ctx.service.materialList.saveDatas(data.updateData);
  409. // 取所有工料表
  410. responseData.data = await ctx.service.materialList.getMaterialData(ctx.tender.id, ctx.material.id);
  411. break;
  412. default: throw '参数有误';
  413. }
  414. ctx.body = responseData;
  415. } catch (err) {
  416. this.log(err);
  417. ctx.body = { err: 1, msg: err.toString(), data: null };
  418. }
  419. }
  420. /**
  421. * 调差工料 - 编辑工料项 (Ajax)
  422. * @param ctx
  423. * @return {Promise<void>}
  424. */
  425. async saveBillsData(ctx) {
  426. try {
  427. const data = JSON.parse(ctx.request.body.data);
  428. const responseData = {
  429. err: 0,
  430. msg: '',
  431. data: {},
  432. };
  433. switch (data.type) {
  434. case 'add':
  435. responseData.data = await ctx.service.materialBills.add();
  436. break;
  437. case 'del':
  438. responseData.data.m_tp = await ctx.service.materialBills.del(data.id);
  439. break;
  440. case 'update':
  441. if (data.updateData.code === '' || data.updateData.code === null) {
  442. throw '请先输入编号';
  443. }
  444. // 判断编号为纯数字时,不能为小数
  445. if (!isNaN(data.updateData.code) && data.updateData.code.toString().indexOf('.') !== -1) {
  446. throw '编号为纯数字时,不能为小数';
  447. }
  448. if (data.updateData.code.length > 15) {
  449. throw '长度不超过15个字符';
  450. }
  451. // 判断编号是否已存在
  452. const billData = await ctx.service.materialBills.getAllDataByCondition({ where: { tid: ctx.tender.id, code: data.updateData.code } });
  453. if (billData.length > 1 || (billData.length > 0 && billData[0].id !== data.updateData.id)) {
  454. throw '该编号已存在,请重新输入。';
  455. }
  456. responseData.data.m_tp = await ctx.service.materialBills.save(data.updateData);
  457. break;
  458. case 'rate':
  459. // 判断数量是否为数字
  460. if (isNaN(data.rate)) {
  461. throw '不能输入其它非数字类型字符';
  462. }
  463. if (ctx.material.readOnly) {
  464. throw '无权操作';
  465. }
  466. await ctx.service.material.changeRate(data.rate);
  467. break;
  468. case 'expr':
  469. const materialCalculator = new MaterialCalculator(ctx, ctx.material.stage_id, ctx.tender.info);
  470. const quantity = await materialCalculator.calculateExpr(data.expr);
  471. // 更新quantity值并重新返回计算本期金额,截止本期金额
  472. const updateData = {
  473. id: data.id,
  474. quantity: quantity !== 0 ? this.ctx.helper.round(quantity, 3) : null,
  475. expr: data.expr,
  476. };
  477. responseData.data = await ctx.service.materialBills.updateFYQuantity(updateData);
  478. break;
  479. case 'paste':
  480. responseData.data.m_tp = await ctx.service.materialBills.saveDatas(data.updateData);
  481. // 根据期判断需要获取的工料信息值
  482. const searchsql = { tid: ctx.tender.id };
  483. if (ctx.material.highOrder !== ctx.material.order) {
  484. const midList = await ctx.service.material.getPreMidList(ctx.tender.id, ctx.material.order);
  485. searchsql.mid = midList;
  486. }
  487. // 取所有工料表
  488. responseData.data.info = await ctx.service.materialBills.getAllDataByCondition({ where: searchsql });
  489. break;
  490. default: throw '参数有误';
  491. }
  492. ctx.body = responseData;
  493. } catch (err) {
  494. this.log(err);
  495. ctx.body = { err: 1, msg: err.toString(), data: null };
  496. }
  497. }
  498. /**
  499. * 调差工料 - 编辑月信息价 (Ajax)
  500. * @param ctx
  501. * @return {Promise<void>}
  502. */
  503. async saveMonth(ctx) {
  504. try {
  505. const data = JSON.parse(ctx.request.body.data);
  506. const responseData = {
  507. err: 0,
  508. msg: '',
  509. data: {},
  510. };
  511. const monthList = await ctx.service.materialMonth.getListByMid(ctx.material.id);
  512. const mbList = await this._getMaterialBillsData(ctx);
  513. switch (data.type) {
  514. case 'add':
  515. const tp = await ctx.service.materialMonth.add(data.updateData, monthList, mbList);
  516. const materialBillsData = await this._getMaterialBillsData(ctx);
  517. const monthsList = await this._getMaterialMonthsData(ctx, materialBillsData);
  518. responseData.data = {
  519. m_tp: tp,
  520. monthsList,
  521. };
  522. break;
  523. case 'del':
  524. const tp2 = await ctx.service.materialMonth.del(data.updateData.del_yearmonth, monthList, mbList);
  525. const materialBillsData2 = await this._getMaterialBillsData(ctx);
  526. const monthsList2 = await this._getMaterialMonthsData(ctx, materialBillsData2);
  527. responseData.data = {
  528. m_tp: tp2,
  529. monthsList: monthsList2,
  530. };
  531. break;
  532. case 'update':
  533. const tp3 = await ctx.service.materialMonth.save(data.updateData);
  534. responseData.data = {
  535. m_tp: tp3,
  536. };
  537. break;
  538. case 'paste':
  539. const tp4 = await ctx.service.materialMonth.saveDatas(data.updateData, mbList);
  540. responseData.data = {
  541. m_tp: tp4,
  542. };
  543. break;
  544. default: throw '参数有误';
  545. }
  546. responseData.data.materialBillsData = await this._getMaterialBillsData(ctx);
  547. ctx.body = responseData;
  548. } catch (err) {
  549. this.log(err);
  550. ctx.body = { err: 1, msg: err.toString(), data: null };
  551. }
  552. }
  553. // 审批相关
  554. /**
  555. * 添加审批人
  556. * @param ctx
  557. * @return {Promise<void>}
  558. */
  559. async addAudit(ctx) {
  560. try {
  561. const data = JSON.parse(ctx.request.body.data);
  562. const id = this.app._.toInteger(data.auditorId);
  563. if (isNaN(id) || id <= 0) {
  564. throw '参数错误';
  565. }
  566. // 检查权限等
  567. if (ctx.material.user_id !== ctx.session.sessionUser.accountId) {
  568. throw '您无权添加审核人';
  569. }
  570. if (ctx.material.status === auditConst.status.checking || ctx.material.status === auditConst.status.checked) {
  571. throw '当前不允许添加审核人';
  572. }
  573. ctx.material.auditorList = await ctx.service.materialAudit.getAuditors(ctx.material.id, ctx.material.times);
  574. // 检查审核人是否已存在
  575. const exist = this.app._.find(ctx.material.auditorList, { aid: id });
  576. if (exist) {
  577. throw '该审核人已存在,请勿重复添加';
  578. }
  579. const result = await ctx.service.materialAudit.addAuditor(ctx.material.id, id, ctx.material.times);
  580. if (!result) {
  581. throw '添加审核人失败';
  582. }
  583. const audit = await ctx.service.materialAudit.getAuditor(ctx.material.id, id, ctx.material.times);
  584. ctx.body = { err: 0, msg: '', data: audit };
  585. } catch (err) {
  586. this.log(err);
  587. ctx.body = { err: 1, msg: err.toString(), data: null };
  588. }
  589. }
  590. /**
  591. * 移除审批人
  592. * @param ctx
  593. * @return {Promise<void>}
  594. */
  595. async deleteAudit(ctx) {
  596. try {
  597. const data = JSON.parse(ctx.request.body.data);
  598. const id = data.auditorId instanceof Number ? data.auditorId : this.app._.toNumber(data.auditorId);
  599. if (isNaN(id) || id <= 0) {
  600. throw '参数错误';
  601. }
  602. const result = await ctx.service.materialAudit.deleteAuditor(ctx.material.id, id, ctx.material.times);
  603. if (!result) {
  604. throw '移除审核人失败';
  605. }
  606. const auditors = await ctx.service.materialAudit.getAuditors(ctx.material.id, ctx.material.times);
  607. ctx.body = { err: 0, msg: '', data: auditors };
  608. } catch (err) {
  609. ctx.body = { err: 1, msg: err.toString(), data: null };
  610. }
  611. }
  612. /**
  613. * 上报和重新上报
  614. * @param ctx
  615. * @return {Promise<void>}
  616. */
  617. async startAudit(ctx) {
  618. try {
  619. // 检查权限等
  620. if (!ctx.material) {
  621. throw '数据错误';
  622. }
  623. if (ctx.material.user_id !== ctx.session.sessionUser.accountId) {
  624. throw '您无权上报该期数据';
  625. }
  626. if (ctx.material.status === auditConst.status.checking || ctx.material.status === auditConst.status.checked) {
  627. throw '该材料调差期数据当前无法上报';
  628. }
  629. await ctx.service.materialAudit.start(ctx.material.id, ctx.material.times);
  630. ctx.redirect(ctx.request.header.referer);
  631. } catch (err) {
  632. this.log(err);
  633. ctx.session.postError = err.toString();
  634. ctx.redirect(ctx.request.header.referer);
  635. }
  636. }
  637. /**
  638. * 审批
  639. * @param ctx
  640. * @return {Promise<void>}
  641. */
  642. async checkAudit(ctx) {
  643. try {
  644. if (!this.ctx.material || this.ctx.material.status !== auditConst.status.checking) {
  645. throw '当前材料调差期数据有误';
  646. }
  647. if (!this.ctx.material.curAuditor || this.ctx.material.curAuditor.aid !== ctx.session.sessionUser.accountId) {
  648. throw '您无权进行该操作';
  649. }
  650. const data = {
  651. checkType: parseInt(ctx.request.body.checkType),
  652. opinion: ctx.request.body.opinion,
  653. };
  654. if (!data.checkType || isNaN(data.checkType)) {
  655. throw '提交数据错误';
  656. }
  657. if (data.checkType === auditConst.status.checkNo) {
  658. if (!data.checkType || isNaN(data.checkType)) {
  659. throw '提交数据错误';
  660. }
  661. }
  662. await ctx.service.materialAudit.check(ctx.material.id, data, ctx.material.times);
  663. ctx.redirect(ctx.request.header.referer);
  664. } catch (err) {
  665. this.log(err);
  666. ctx.session.postError = err.toString();
  667. ctx.redirect(ctx.request.header.referer);
  668. }
  669. }
  670. _checkMaterialFileCanModify(ctx) {
  671. // 检查登录用户,是否可操作
  672. const accountId = ctx.session.sessionUser.accountId;
  673. if (!ctx.material.curAuditor) {
  674. if (ctx.material.status === auditConst.status.uncheck || ctx.material.status === auditConst.status.checkNo && accountId === ctx.material.user_id) {
  675. return;
  676. }
  677. throw '该调差期当前您无权操作';
  678. } else {
  679. if (ctx.material.curAuditor.aid === accountId) return;
  680. throw '该调差期当前您无权操作';
  681. }
  682. }
  683. /**
  684. * 上传附件
  685. * @param {*} ctx 上下文
  686. */
  687. async upload(ctx) {
  688. let stream;
  689. try {
  690. this._checkMaterialFileCanModify(ctx);
  691. const parts = this.ctx.multipart({
  692. autoFields: true,
  693. });
  694. const files = [];
  695. const create_time = Date.parse(new Date()) / 1000;
  696. let idx = 0;
  697. while ((stream = await parts()) !== undefined) {
  698. if (!stream.filename) {
  699. // 如果没有传入直接返回
  700. return;
  701. }
  702. const fileInfo = path.parse(stream.filename);
  703. // const filepath = path.join('public/upload', this.ctx.tender.id.toString(), 'tc', 'fujian_' + create_time + fileInfo.ext);
  704. const filepath = `public/upload/${this.ctx.tender.id.toString()}/tc/fujian_${create_time + idx.toString() + fileInfo.ext}`;
  705. await ctx.helper.saveStreamFile(stream, path.resolve(this.app.baseDir, 'app', filepath));
  706. files.push({ filepath, name: stream.filename, ext: fileInfo.ext });
  707. ++idx;
  708. }
  709. const upload_time = this.ctx.helper.dateTran(new Date());
  710. const payload = files.map(file => {
  711. let idx;
  712. if (Array.isArray(parts.field.name)) {
  713. idx = parts.field.name.findIndex(name => name === file.name);
  714. } else {
  715. idx = 'isString';
  716. }
  717. const newFile = {
  718. tid: ctx.tender.id,
  719. user_id: ctx.session.sessionUser.accountId,
  720. mid: ctx.material.id,
  721. s_order: ctx.params.order,
  722. upload_time,
  723. filepath: file.filepath,
  724. file_size: ctx.helper.bytesToSize(idx === 'isString' ? parts.field.size : parts.field.size[idx]),
  725. file_name: file.name,
  726. fileext: file.ext,
  727. };
  728. return newFile;
  729. });
  730. // 执行文件信息写入数据库
  731. await ctx.service.materialFile.saveFileMsgToDb(payload);
  732. // 将最新的当前标段的所有文件信息返回
  733. const data = await ctx.service.materialFile.getAllMaterialFiles(ctx.tender.id);
  734. ctx.body = { err: 0, msg: '', data };
  735. } catch (err) {
  736. stream && (await sendToWormhole(stream));
  737. this.log(err);
  738. ctx.body = { err: 1, msg: err.toString(), data: null };
  739. }
  740. }
  741. /**
  742. * 下载附件
  743. * @param {Object} ctx - egg全局变量
  744. * @return {void}
  745. */
  746. async downloadFile(ctx) {
  747. const id = ctx.params.fid;
  748. if (id) {
  749. try {
  750. const fileInfo = await ctx.service.materialFile.getDataById(id);
  751. if (fileInfo !== undefined && fileInfo !== '') {
  752. const fileName = path.join(__dirname, '../', fileInfo.filepath);
  753. // 解决中文无法下载问题
  754. const userAgent = (ctx.request.header['user-agent'] || '').toLowerCase();
  755. let disposition = '';
  756. if (userAgent.indexOf('msie') >= 0 || userAgent.indexOf('chrome') >= 0) {
  757. disposition = 'attachment; filename=' + encodeURIComponent(fileInfo.file_name);
  758. } else if (userAgent.indexOf('firefox') >= 0) {
  759. disposition = 'attachment; filename*="utf8\'\'' + encodeURIComponent(fileInfo.file_name) + '"';
  760. } else {
  761. /* safari等其他非主流浏览器只能自求多福了 */
  762. disposition = 'attachment; filename=' + new Buffer(fileInfo.file_name).toString('binary');
  763. }
  764. ctx.response.set({
  765. 'Content-Type': 'application/octet-stream',
  766. 'Content-Disposition': disposition,
  767. 'Content-Length': fileInfo.file_size,
  768. });
  769. ctx.body = await fs.createReadStream(fileName);
  770. } else {
  771. throw '不存在该文件';
  772. }
  773. } catch (err) {
  774. this.log(err);
  775. this.setMessage(err.toString(), this.messageType.ERROR);
  776. }
  777. }
  778. }
  779. /**
  780. * 查看当前标段以往所有期的附件
  781. * @param {Object} ctx 上下文
  782. */
  783. async getCurMatericalFiles(ctx) {
  784. try {
  785. // const { isCheck } = JSON.parse(ctx.request.body.data);
  786. const data = await ctx.service.materialFile.getAllMaterialFiles(ctx.tender.id);
  787. ctx.body = { err: 0, msg: '', data };
  788. } catch (err) {
  789. this.log(err);
  790. ctx.body = { err: 1, msg: err.toString(), data: null };
  791. }
  792. }
  793. /**
  794. * 删除附件
  795. * @param {Ojbect} ctx 上下文
  796. */
  797. async deleteFile(ctx) {
  798. try {
  799. const { data } = ctx.request.body;
  800. const { id } = JSON.parse(data);
  801. const fileInfo = await ctx.service.materialFile.getMaterialFileById(id);
  802. if (fileInfo) {
  803. // 先删除文件
  804. await fs.unlinkSync(path.resolve(this.app.baseDir, './app', fileInfo.filepath));
  805. // 再删除数据库
  806. await ctx.service.materialFile.delete(id);
  807. } else {
  808. throw '不存在该文件';
  809. }
  810. ctx.body = { err: 0, msg: '请求成功' };
  811. } catch (err) {
  812. this.log(err);
  813. ctx.body = { err: 1, msg: err.toString(), data: null };
  814. }
  815. }
  816. }
  817. return MaterialController;
  818. };