material_controller.js 37 KB

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