material_controller.js 91 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763
  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 auditType = require('../const/audit').auditType;
  12. const auditStageConst = require('../const/audit').stage;
  13. const tenderConst = require('../const/tender');
  14. const measureType = tenderConst.measureType;
  15. const accountGroup = require('../const/account_group').group;
  16. const materialConst = require('../const/material');
  17. const shenpiConst = require('../const/shenpi');
  18. const MaterialCalculator = require('../lib/material_calc');
  19. const sendToWormhole = require('stream-wormhole');
  20. const fs = require('fs');
  21. const path = require('path');
  22. const _ = require('lodash');
  23. const { typeOf } = require('mathjs');
  24. module.exports = app => {
  25. class MaterialController extends app.BaseController {
  26. /**
  27. * 构造函数
  28. *
  29. * @param {Object} ctx - egg全局变量
  30. * @return {void}
  31. */
  32. constructor(ctx) {
  33. super(ctx);
  34. ctx.showProject = true;
  35. ctx.showTender = true;
  36. ctx.showTitle = true;
  37. }
  38. /**
  39. * 期列表(Get)
  40. * @param ctx
  41. * @return {Promise<void>}
  42. */
  43. async index(ctx) {
  44. try {
  45. if (!ctx.session.sessionProject.page_show.openMaterial) {
  46. throw '该功能已关闭';
  47. }
  48. // 列展示
  49. const tenderMsg = await ctx.service.tender.getTender(ctx.tender.id, ['material_col_show']);
  50. const material_col_show = tenderMsg.material_col_show ? JSON.parse(tenderMsg.material_col_show) : ctx.helper._.cloneDeep(tenderConst.materialColShow);
  51. const renderData = {
  52. tender: ctx.tender.data,
  53. tenderMenu: this.menu.tenderMenu,
  54. preUrl: '/tender/' + ctx.tender.id,
  55. auditConst,
  56. auditConst2: JSON.stringify(auditConst),
  57. materialColShow: material_col_show,
  58. qtySourceConst: materialConst.qty_source,
  59. qtySourceValueConst: materialConst.qty_source_value,
  60. auditType,
  61. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.material.index),
  62. };
  63. let openMaterialTax = ctx.subProject.page_show.openMaterialTax;
  64. let allMaterialTax = true;
  65. renderData.materials = await ctx.service.material.getValidMaterials(ctx.tender.id);
  66. const lastMaterial = renderData.materials.length > 0 ? renderData.materials[0] : null;
  67. if (lastMaterial && (lastMaterial.status === auditConst.status.uncheck || lastMaterial.status === auditConst.status.checkNo) && lastMaterial.material_tax !== openMaterialTax) {
  68. await ctx.service.material.updateMaterialTax(lastMaterial.id, openMaterialTax);
  69. lastMaterial.material_tax = openMaterialTax;
  70. }
  71. // 获取未选中和已完成的计量期
  72. const stages = await ctx.service.stage.getAllDataByCondition({ where: { tid: ctx.tender.id, status: auditStageConst.status.checked } });
  73. const materialTotalPrice = {
  74. m_tp: 0,
  75. tax_tp: 0,
  76. ex_tp: 0,
  77. ex_tax_tp: 0,
  78. m_tax_tp: 0,
  79. };
  80. for (const s of renderData.materials) {
  81. // s.curAuditor = null;
  82. // 根据期状态返回展示用户
  83. // s.curAuditor = await ctx.service.materialAudit.getAuditorByStatus(s.id, s.status, s.times);
  84. if (!s.final_auditor_str || s.status !== auditConst.status.checked) {
  85. // 根据期状态返回展示用户
  86. s.curAuditors = await ctx.service.materialAudit.getAuditorsByStatus(s.id, s.status, s.times);
  87. if (s.status === auditConst.status.checked && s.curAuditors.length > 0) {
  88. const final_auditor_str = (s.curAuditors[0].audit_type === auditType.key.common)
  89. ? `${s.curAuditors[0].name}${(s.curAuditors[0].role ? '-' + s.curAuditors[0].role : '')}`
  90. : ctx.helper.transFormToChinese(s.curAuditors[0].audit_order) + '审';
  91. await ctx.service.material.defaultUpdate({ id: s.id, final_auditor_str });
  92. }
  93. }
  94. if (!ctx.session.sessionProject.page_show.openMaterialStageRepeat) {
  95. const materialStageList = s.stage_id.split(',');
  96. for (const ms of materialStageList) {
  97. const index = stages.findIndex(function(item) {
  98. return item.id === parseInt(ms);
  99. });
  100. stages.splice(index, 1);
  101. }
  102. }
  103. if (allMaterialTax && s.material_tax === 0) {
  104. allMaterialTax = false;
  105. }
  106. if (!openMaterialTax && s.material_tax === 1) {
  107. openMaterialTax = 1;
  108. }
  109. s.decimal = s.decimal ? JSON.parse(s.decimal) : materialConst.decimal;
  110. materialTotalPrice.m_tp = ctx.helper.add(materialTotalPrice.m_tp, ctx.helper.round(s.m_tp, s.decimal.tp));
  111. materialTotalPrice.tax_tp = !s.material_tax ? ctx.helper.add(materialTotalPrice.tax_tp, ctx.helper.round(ctx.helper.mul(s.m_tp, 1 + s.rate / 100), s.decimal.tp)) : materialTotalPrice.tax_tp;
  112. materialTotalPrice.ex_tp = ctx.helper.add(materialTotalPrice.ex_tp, ctx.helper.round(s.ex_tp, s.decimal.tp));
  113. materialTotalPrice.ex_tax_tp = ctx.helper.add(materialTotalPrice.ex_tax_tp, ctx.helper.round(ctx.helper.mul(s.ex_tp, 1 + s.exponent_rate / 100), s.decimal.tp));
  114. materialTotalPrice.m_tax_tp = s.material_tax ? ctx.helper.add(materialTotalPrice.m_tax_tp, ctx.helper.round(s.m_tax_tp, s.decimal.tp)) : materialTotalPrice.m_tax_tp;
  115. }
  116. materialTotalPrice.total_tp = ctx.helper.add(materialTotalPrice.m_tp, materialTotalPrice.ex_tp);
  117. materialTotalPrice.total_tax_tp = ctx.helper.add(materialTotalPrice.tax_tp, materialTotalPrice.ex_tax_tp);
  118. if (lastMaterial && lastMaterial.status === auditConst.status.checked && ctx.session.sessionUser.accountId === ctx.tender.data.user_id && stages.length > 0) {
  119. renderData.lastMaterialList = lastMaterial.is_new ? await ctx.service.materialListGcl.getAllDataByCondition({ where: { tid: ctx.tender.id } }) : await ctx.service.materialList.getMaterialData(ctx.tender.id, lastMaterial.id);
  120. } else {
  121. renderData.lastMaterialList = null;
  122. }
  123. renderData.stages = stages;
  124. renderData.openMaterialTax = openMaterialTax;
  125. renderData.allMaterialTax = allMaterialTax;
  126. renderData.materialTotalPrice = materialTotalPrice;
  127. await this.layout('material/index.ejs', renderData, 'material/modal.ejs');
  128. } catch (err) {
  129. this.log(err);
  130. ctx.session.postError = err.toString();
  131. ctx.redirect(this.menu.menu.dashboard.url);
  132. }
  133. }
  134. /**
  135. * 期审批流程(Get)
  136. * @param ctx
  137. * @return {Promise<void>}
  138. */
  139. async materialAuditors(ctx) {
  140. try {
  141. if (!ctx.session.sessionProject.page_show.openMaterial) {
  142. throw '该功能已关闭';
  143. }
  144. const order = JSON.parse(ctx.request.body.data).order;
  145. const tenderId = ctx.params.id;
  146. const materialInfo = await ctx.service.material.getDataByCondition({ tid: tenderId, order });
  147. await ctx.service.material.loadMaterialUser(materialInfo);
  148. await ctx.service.material.loadMaterialAuditViewData(materialInfo);
  149. ctx.body = { err: 0, msg: '', data: materialInfo };
  150. } catch (error) {
  151. this.log(error);
  152. ctx.body = { err: 1, msg: error.toString(), data: null };
  153. }
  154. }
  155. /**
  156. * 编辑期(Post)
  157. * @param ctx
  158. * @return {Promise<void>}
  159. */
  160. async save(ctx) {
  161. try {
  162. if (!ctx.session.sessionProject.page_show.openMaterial) {
  163. throw '该功能已关闭';
  164. }
  165. const data = {
  166. mid: ctx.request.body.mid,
  167. period: ctx.request.body.period,
  168. };
  169. const material = await ctx.service.material.getDataById(data.mid);
  170. if (!material) {
  171. throw '提交数据错误';
  172. }
  173. // if (stage.status === auditConst.status.checked) {
  174. // throw '该计量期当前不可编辑';
  175. // }
  176. // if (ctx.session.sessionUser.accountId !== stage.user_id) {
  177. // throw '您无权修改该数据';
  178. // }
  179. await this.ctx.service.material.saveMaterial(data.mid, data.period);
  180. ctx.redirect('/tender/' + ctx.tender.id + '/measure/material');
  181. } catch (err) {
  182. this.log(err);
  183. ctx.redirect('/tender/' + ctx.tender.id + '/measure/material');
  184. }
  185. }
  186. /**
  187. * 编辑期数据(Post)
  188. * @param ctx
  189. * @return {Promise<void>}
  190. */
  191. async saveData(ctx) {
  192. try {
  193. if (!ctx.session.sessionProject.page_show.openMaterial) {
  194. throw '该功能已关闭';
  195. }
  196. const data = JSON.parse(ctx.request.body.data);
  197. const responseData = {
  198. err: 0,
  199. msg: '',
  200. data: {},
  201. };
  202. switch (data.type) {
  203. case 'material_col_set':
  204. responseData.data = await ctx.service.tender.saveTenderData(ctx.tender.id, { material_col_show: JSON.stringify(data.material_col_data) });
  205. break;
  206. default: throw '参数有误';
  207. }
  208. ctx.body = responseData;
  209. } catch (err) {
  210. this.log(err);
  211. ctx.body = { err: 1, msg: err.toString(), data: null };
  212. }
  213. }
  214. /**
  215. * 新增期(Post)
  216. * @param ctx
  217. * @return {Promise<void>}
  218. */
  219. async add(ctx) {
  220. try {
  221. if (!ctx.session.sessionProject.page_show.openMaterial) {
  222. throw '该功能已关闭';
  223. }
  224. if (ctx.session.sessionUser.accountId !== ctx.tender.data.user_id) {
  225. throw '您无权创建材料调差期';
  226. }
  227. const data = JSON.parse(ctx.request.body.data);
  228. if (data.s_order === '') {
  229. throw '没有选中计量期';
  230. }
  231. // 调差期是否存在审批或待上报,存在则无法重复添加
  232. const doingMaterial = await ctx.service.material.getDataByCondition({ tid: ctx.tender.id, status: [auditConst.status.uncheck, auditConst.status.checking, auditConst.status.checkNo] });
  233. if (doingMaterial) {
  234. throw '存在待上报或审批中的调差期,请勿重复生成';
  235. }
  236. // 参考变更令的做法,在创建新一期预付款时,需要copy前一个预付款报表的签名信息
  237. const lastMaterial = await ctx.service.material.getLastestMaterial(ctx.tender.id, true);
  238. const newMaterial = await ctx.service.material.addMaterial(ctx.tender.id, data);
  239. if (!newMaterial) {
  240. throw '新增材料调差期失败,请重试';
  241. }
  242. if (lastMaterial) {
  243. await ctx.service.roleRptRel.createRoleRelationshipFromOtherBz(ctx.tender.id, '-500', newMaterial.id, lastMaterial.id);
  244. }
  245. // ctx.redirect('/tender/' + ctx.tender.id + '/measure/material/' + newMaterial.order);
  246. ctx.body = { err: 0, msg: '', data: newMaterial };
  247. } catch (err) {
  248. this.log(err);
  249. // ctx.redirect(ctx.request.header.referer);
  250. ctx.body = { err: 1, msg: err.toString(), data: null };
  251. }
  252. }
  253. /**
  254. * 删除期(Post)
  255. * @param ctx
  256. * @return {Promise<void>}
  257. */
  258. async delete(ctx) {
  259. try {
  260. if (!ctx.session.sessionProject.page_show.openMaterial) {
  261. throw '该功能已关闭';
  262. }
  263. const material_id = ctx.request.body.material_id;
  264. const materialInfo = await ctx.service.material.getDataById(material_id);
  265. // 获取最新的期数
  266. const material_highOrder = await ctx.service.material.count({
  267. tid: ctx.tender.id,
  268. });
  269. if (materialInfo === undefined || !(ctx.session.sessionUser.is_admin || ((materialInfo.status === auditConst.status.uncheck || materialInfo.status === auditConst.status.checkNo) && materialInfo.user_id === ctx.session.sessionUser.accountId)) || material_highOrder !== materialInfo.order) {
  270. throw '您无权删除材料调差期';
  271. }
  272. const result = await ctx.service.material.deleteMaterial(material_id);
  273. if (!result) {
  274. throw '删除材料调差期失败,请重试';
  275. }
  276. ctx.redirect('/tender/' + ctx.tender.id + '/measure/material/');
  277. } catch (err) {
  278. this.log(err);
  279. ctx.redirect(ctx.request.header.referer);
  280. }
  281. }
  282. /**
  283. * 获取通用的renderData(用于layout, Menu, subMenu部分)
  284. * @param ctx
  285. * @return {{tender, tenderMenu, auditConst}}
  286. * @private
  287. */
  288. async _getDefaultRenderData(ctx) {
  289. const data = {
  290. tender: ctx.tender.data,
  291. tenderMenu: JSON.parse(JSON.stringify(this.menu.stageMenu)),
  292. auditConst,
  293. measureType,
  294. preUrl: '/tender/' + ctx.tender.id + '/measure/material/' + ctx.params.order,
  295. material: ctx.material,
  296. shenpiConst,
  297. qtySourceConst: materialConst.qty_source,
  298. qtySourceValueConst: materialConst.qty_source_value,
  299. auditType,
  300. };
  301. if ((ctx.material.status === auditConst.status.uncheck || ctx.material.status === auditConst.status.checkNo) && (ctx.session.sessionUser.accountId === ctx.material.user_id || ctx.tender.isTourist) || ctx.session.sessionUser.is_admin) {
  302. // data.accountGroup = accountGroup;
  303. // 获取所有项目参与者
  304. const accountList = await ctx.service.projectAccount.getAllSubProjectAccount(ctx.subProject);
  305. data.accountList = accountList;
  306. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: ctx.session.sessionProject.id } });
  307. data.accountGroup = unitList.map(item => {
  308. const groupList = accountList.filter(item1 => item1.company === item.name);
  309. return { groupName: item.name, groupList };
  310. }).filter(x => { return x.groupList.length > 0; });
  311. }
  312. data.tenderMenu.back.children[0].url = '/tender/' + ctx.tender.id + '/measure/material';
  313. return data;
  314. }
  315. _materialReadOnly(material) {
  316. return material.status === auditConst.status.checked;
  317. }
  318. /**
  319. * 获取审批界面所需的 原报、审批人数据等
  320. * @param ctx
  321. * @return {Promise<void>}
  322. * @private
  323. */
  324. async _getMaterialAuditViewData(ctx) {
  325. // const times = ctx.material.status === auditConst.status.checkNo ? ctx.material.times - 1 : ctx.material.times;
  326. // ctx.material.user = await ctx.service.projectAccount.getAccountInfoById(ctx.material.user_id);
  327. // ctx.material.auditHistory = [];
  328. // if (times >= 1) {
  329. // for (let i = 1; i <= times; i++) {
  330. // ctx.material.auditHistory.push(await ctx.service.materialAudit.getAuditors(ctx.material.id, i));
  331. // }
  332. // }
  333. // // 获取审批流程中左边列表
  334. // ctx.material.auditors2 = ctx.material.status === auditConst.status.checkNo && ctx.material.user_id !== ctx.session.sessionUser.accountId ?
  335. // await ctx.service.materialAudit.getAuditorsWithOwner(ctx.material.id, times) :
  336. // await ctx.service.materialAudit.getAuditorsWithOwner(ctx.material.id, ctx.material.times);
  337. // if (ctx.material.status === auditConst.status.uncheck || ctx.material.status === auditConst.status.checkNo) {
  338. // ctx.material.auditorList = await ctx.service.materialAudit.getAuditors(ctx.material.id, ctx.material.times);
  339. // }
  340. await ctx.service.material.loadMaterialAuditViewData(ctx.material);
  341. // 是否已验证手机短信
  342. const pa = await ctx.service.projectAccount.getDataById(ctx.session.sessionUser.accountId);
  343. ctx.material.authMobile = pa.auth_mobile;
  344. }
  345. /**
  346. * 获取当前期工料列表信息
  347. * @param ctx
  348. * @return {Promise<void>}
  349. * @private
  350. */
  351. async _getMaterialBillsData(ctx) {
  352. // 根据期判断需要获取的工料信息值
  353. const searchsql = { tid: ctx.tender.id };
  354. if (ctx.material.highOrder !== ctx.material.order) {
  355. const midList = await ctx.service.material.getPreMidList(ctx.tender.id, ctx.material.order);
  356. searchsql.mid = midList;
  357. }
  358. // 取所有工料表
  359. return await ctx.service.materialBills.getAllDataByCondition({ where: searchsql, orders: [['order', 'asc']] });
  360. }
  361. /**
  362. * 获取当前月信息价列表信息
  363. * @param ctx
  364. * @return {Promise<void>}
  365. * @private
  366. */
  367. async _getMaterialMonthsData(ctx, materialBillsData) {
  368. return await ctx.service.materialMonth.getMonthList(materialBillsData);
  369. // // 取月信息价表
  370. // const monthsList = [];
  371. // if (ctx.material.months) {
  372. // const material_month = ctx.material.months.split(',');
  373. // material_month.sort();
  374. // const materialMonthList = await ctx.service.materialMonth.getListByMid(ctx.material.id);
  375. // for (const mbd of materialBillsData) {
  376. // const one_mb = {
  377. // code: mbd.code,
  378. // name: mbd.name,
  379. // unit: mbd.unit,
  380. // origin: mbd.origin,
  381. // mb_id: mbd.id,
  382. // order: mbd.order,
  383. // };
  384. // for (const m of material_month) {
  385. // const mb_id = ctx.material.highOrder !== ctx.material.order ? mbd.mb_id : mbd.id;
  386. // const one_mm = _.find(materialMonthList, { mb_id, yearmonth: m });
  387. // one_mb[m] = one_mm.msg_tp;
  388. // }
  389. // monthsList.push(one_mb);
  390. // }
  391. // }
  392. // return monthsList;
  393. }
  394. /**
  395. * 检查旧数据是否存在指数法调差数据,没有自动添加定值
  396. * @param ctx
  397. * @return {Promise<void>}
  398. * @private
  399. */
  400. async _checkExponentExist(ctx) {
  401. const material_exponent_constant = await ctx.service.materialExponent.getDataByCondition({
  402. tid: ctx.tender.id,
  403. type: materialConst.ex_type[0].value,
  404. });
  405. // 不存在则生成指数调差清单表定值和历史期定值(防止变更定值发生变化)
  406. if (!material_exponent_constant) {
  407. await ctx.service.materialExponent.addOldData();
  408. }
  409. }
  410. /**
  411. * 获取当前期指数列表信息
  412. * @param ctx
  413. * @return {Promise<void>}
  414. * @private
  415. */
  416. async _getMaterialExponentData(ctx) {
  417. // 根据期判断需要获取的工料信息值
  418. const searchsql = { tid: ctx.tender.id };
  419. if (ctx.material.highOrder !== ctx.material.order) {
  420. const midList = await ctx.service.material.getPreMidList(ctx.tender.id, ctx.material.order);
  421. searchsql.mid = midList;
  422. }
  423. // 取所有工料表
  424. return await ctx.service.materialExponent.getAllDataByCondition({ where: searchsql });
  425. }
  426. /**
  427. * 调差工料页面 (Get)
  428. * @param {Object} ctx - egg全局变量
  429. * @return {Promise<void>}
  430. */
  431. async info(ctx) {
  432. try {
  433. await this._getMaterialAuditViewData(ctx);
  434. await this._setEditTaxPermission(ctx);
  435. const renderData = await this._getDefaultRenderData(ctx);
  436. renderData.materialBillsData = await this._getMaterialBillsData(ctx);
  437. // 判断order是否重复,重复则重新排版并更新数据库
  438. await this.checkBillsOrder(ctx, renderData.materialBillsData);
  439. // 取对应期的截取上期的调差金额和应耗数量
  440. if (ctx.material.highOrder !== ctx.material.order) {
  441. for (const [mindex, mb] of renderData.materialBillsData.entries()) {
  442. const result = await ctx.service.materialBillsHistory.getByMbId(ctx.material.id, ctx.material.order, mb.id);
  443. _.forEach(result, function(value, key) {
  444. renderData.materialBillsData[mindex][key] = result ? result[key] : null;
  445. });
  446. }
  447. }
  448. // 取所有已被调用的工料清单表
  449. const materialListData = await ctx.service.materialList.getAllDataByCondition({ where: { tid: ctx.tender.id, mid: ctx.material.id } });
  450. renderData.materialListData = ctx.helper._.uniqBy(materialListData, 'mb_id');
  451. // 基数
  452. // if (!ctx.material.readOnly) {
  453. const stage_list = await ctx.service.stage.getStageMsgByStageId(ctx.material.stage_id);
  454. renderData.calcBase = await ctx.service.stage.getMaterialCalcBase(stage_list, ctx.tender.info);
  455. renderData.materialStageData = ctx.material.is_stage_self ? await ctx.service.materialStage.getAllDataByCondition({ where: { tid: ctx.tender.id, mid: ctx.material.id } }) : [];
  456. renderData.materialStageBillsData = ctx.material.is_stage_self ? await ctx.service.materialStageBills.getAllDataByCondition({ where: { tid: ctx.tender.id, mid: ctx.material.id } }) : [];
  457. if (ctx.material.is_stage_self) {
  458. const calcBaseList = [];
  459. for (const ms of renderData.materialStageData) {
  460. const stage_info = await ctx.service.stage.getStageMsgByStageId(ms.sid);
  461. calcBaseList.push({
  462. ms_id: ms.id,
  463. calcBase: await ctx.service.stage.getMaterialCalcBase(stage_info, ctx.tender.info),
  464. });
  465. }
  466. renderData.calcBase = calcBaseList;
  467. }
  468. // }
  469. const [stdBills, stdChapters, gljLists] = await this.ctx.service.valuation.getValuationStdList(
  470. ctx.tender.data.valuation, ctx.tender.data.measure_type);
  471. renderData.gljLists = gljLists;
  472. // 取当前期截止上期含税金额
  473. renderData.material.m_tax_tp = renderData.material.m_tax_tp ? renderData.material.m_tax_tp : renderData.material.m_tp;
  474. renderData.pre_tp_hs = await ctx.service.material.getPreTpHs(ctx.tender.id, ctx.material.order, ctx.material.decimal.tp);
  475. renderData.ex_pre_tp_hs = await ctx.service.material.getExPreTpHs(ctx.tender.id, ctx.material.order, ctx.material.decimal.tp);
  476. // renderData.tax_pre_tp_hs = await ctx.service.material.getTaxPreTpHs(ctx.tender.id, ctx.material.order);
  477. renderData.months = ctx.material.months ? ctx.material.months.split(',') : [];
  478. renderData.monthsList = await this._getMaterialMonthsData(ctx, renderData.materialBillsData);
  479. renderData.materialType = JSON.stringify(materialConst);
  480. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.material.info);
  481. // 判断之前期有无调用过材料税
  482. renderData.old_had_tax = await ctx.service.material.getOldMaterialTax(ctx.tender.id, ctx.params.order);
  483. await this.layout('material/info.ejs', renderData, 'material/info_modal.ejs');
  484. } catch (err) {
  485. this.log(err);
  486. ctx.redirect('/tender/' + ctx.tender.id + '/measure/material');
  487. }
  488. }
  489. // 判断order是否重复,重复则重新排版并更新数据库
  490. async checkBillsOrder(ctx, billsList) {
  491. if (billsList.length > 0) {
  492. const needSet = ctx.helper._.uniq(ctx.helper._.map(billsList, 'order')).length !== billsList.length;
  493. if (needSet) {
  494. let order = 1;
  495. const updateOrderList = [];
  496. for (const b of billsList) {
  497. if (b.order !== order) {
  498. b.order = order;
  499. updateOrderList.push({
  500. id: b.id,
  501. order,
  502. });
  503. }
  504. order = order + 1;
  505. }
  506. if (updateOrderList.length > 0) await ctx.service.materialBills.updateAllOrder(updateOrderList);
  507. }
  508. }
  509. }
  510. /**
  511. * 调差清单页面 (Get)
  512. * @param {Object} ctx - egg全局变量
  513. * @return {Promise<void>}
  514. */
  515. async list(ctx) {
  516. try {
  517. await this._getMaterialAuditViewData(ctx);
  518. await this._setEditListPermission(ctx);
  519. const renderData = await this._getDefaultRenderData(ctx);
  520. // 根据期判断需要获取的工料信息值表
  521. const searchsql = { tid: ctx.tender.id };
  522. let midList = [];
  523. if (ctx.material.highOrder !== ctx.material.order) {
  524. midList = await ctx.service.material.getPreMidList(ctx.tender.id, ctx.material.order);
  525. searchsql.mid = midList;
  526. }
  527. searchsql.t_type = materialConst.t_type[0].value;
  528. renderData.materialBillsData = await ctx.service.materialBills.getAllDataByCondition({ where: searchsql, orders: [['order', 'asc']] });
  529. // 取对应期的截取上期的调差金额和应耗数量
  530. if (ctx.material.highOrder !== ctx.material.order) {
  531. for (const [mindex, mb] of renderData.materialBillsData.entries()) {
  532. const result = await ctx.service.materialBillsHistory.getByMbId(ctx.material.id, ctx.material.order, mb.id);
  533. _.forEach(result, function(value, key) {
  534. if (key === 'mb_id') {
  535. renderData.materialBillsData[mindex].id = result ? result[key] : null;
  536. } else {
  537. renderData.materialBillsData[mindex][key] = result ? result[key] : null;
  538. }
  539. });
  540. }
  541. }
  542. renderData.materialStageData = ctx.material.is_stage_self ? await ctx.service.materialStage.getAllDataByCondition({ where: { tid: ctx.tender.id, mid: ctx.material.id } }) : [];
  543. renderData.materialStageBillsData = ctx.material.is_stage_self ? await ctx.service.materialStageBills.getAllDataByCondition({ where: { tid: ctx.tender.id, mid: ctx.material.id } }) : [];
  544. // 取所有已被调用的工料清单表
  545. // renderData.materialListData = await ctx.service.materialList.getMaterialData(ctx.tender.id, ctx.material.id);
  546. // renderData.materialNotJoinListData = await ctx.service.materialListNotjoin.getAllDataByCondition({ where: { tid: ctx.tender.id, mid: ctx.material.id } });
  547. renderData.materialType = JSON.stringify(materialConst);
  548. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.material.list);
  549. // 获取清单数据
  550. // renderData.ledger = await ctx.service.ledger.getData(ctx.tender.id);
  551. // renderData.pos = await ctx.service.pos.getPosData({ tid: ctx.tender.id });
  552. // 获取所选期数据并合并相加同类清单项
  553. // renderData.curLedgerData = await ctx.service.stageBills.getStagesData(ctx.tender.id, ctx.material.stage_id);
  554. // renderData.curPosData = await ctx.service.stagePos.getStagesData(ctx.tender.id, ctx.material.stage_id, 'list');
  555. await this.layout('material/list.ejs', renderData, 'material/list_modal.ejs');
  556. } catch (err) {
  557. this.log(err);
  558. ctx.redirect('/tender/' + ctx.tender.id + '/measure/material');
  559. }
  560. }
  561. /**
  562. * 调差清单页面 (Get)
  563. * @param {Object} ctx - egg全局变量
  564. * @return {Promise<void>}
  565. */
  566. async loadListsData(ctx) {
  567. try {
  568. const data = JSON.parse(ctx.request.body.data);
  569. // const filter = data.filter.split(';');
  570. const responseData = { err: 0, msg: '', data: {} };
  571. // 取所有已被调用的工料清单表
  572. responseData.data.materialListData = await ctx.service.materialList.getMaterialData(ctx.tender.id, ctx.material.id);
  573. responseData.data.materialNotJoinListData = await ctx.service.materialListNotjoin.getAllDataByCondition({ where: { tid: ctx.tender.id, mid: ctx.material.id, type: 1 } });
  574. responseData.data.materialNotChangeListData = await ctx.service.materialListNotjoin.getAllDataByCondition({ where: { tid: ctx.tender.id, mid: ctx.material.id, type: 2 } });
  575. responseData.data.materialSelfListData = await ctx.service.materialListSelf.getAllDataByCondition({ where: { tid: ctx.tender.id, mid: ctx.material.id } });
  576. // 获取清单数据
  577. responseData.data.ledger = await ctx.service.ledger.getData(ctx.tender.id);
  578. responseData.data.pos = await ctx.service.pos.getPosData({ tid: ctx.tender.id });
  579. // 获取所选期数据并合并相加同类清单项
  580. if (ctx.material.is_stage_self && data.sid) {
  581. const curLedgerPcData = await ctx.service.stageBillsPc.getStagesData(ctx.tender.id, data.sid.toString());
  582. const curLedgerData = await ctx.service.stageBills.getStagesData(ctx.tender.id, data.sid.toString());
  583. for (const cl of curLedgerData) {
  584. const clpc = ctx.helper._.find(curLedgerPcData, { lid: cl.lid });
  585. ctx.helper._.assign(cl, clpc);
  586. }
  587. responseData.data.curLedgerData = curLedgerData;
  588. responseData.data.curPosData = await ctx.service.stagePos.getStagesData(ctx.tender.id, data.sid.toString(), 'list');
  589. const ledgerListData = [];
  590. const posListData = [];
  591. for (const s of ctx.material.stage_id.split(',')) {
  592. const curLedgerPcData = await ctx.service.stageBillsPc.getStagesData(ctx.tender.id, s.toString());
  593. const curLedgerData = await ctx.service.stageBills.getStagesData(ctx.tender.id, s.toString());
  594. for (const cl of curLedgerData) {
  595. const clpc = ctx.helper._.find(curLedgerPcData, { lid: cl.lid });
  596. ctx.helper._.assign(cl, clpc);
  597. }
  598. ledgerListData.push(curLedgerData);
  599. posListData.push(await ctx.service.stagePos.getStagesData(ctx.tender.id, s.toString(), 'list'));
  600. }
  601. responseData.data.ledgerListData = ledgerListData;
  602. responseData.data.posListData = posListData;
  603. } else {
  604. const curLedgerPcData = await ctx.service.stageBillsPc.getStagesData(ctx.tender.id, ctx.material.stage_id);
  605. const curLedgerData = await ctx.service.stageBills.getStagesData(ctx.tender.id, ctx.material.stage_id);
  606. for (const cl of curLedgerData) {
  607. const clpc = ctx.helper._.find(curLedgerPcData, { lid: cl.lid });
  608. ctx.helper._.assign(cl, clpc);
  609. }
  610. responseData.data.curLedgerData = curLedgerData;
  611. responseData.data.curPosData = await ctx.service.stagePos.getStagesData(ctx.tender.id, ctx.material.stage_id, 'list');
  612. }
  613. // 获取清单设置已选清单
  614. const materialChecklistData = await ctx.service.materialChecklist.getAllDataByCondition({ where: { tid: ctx.tender.id } });
  615. responseData.data.materialChecklistData = materialChecklistData.sort(function(a, b) {
  616. return ctx.helper.compareCode(a.b_code, b.b_code);
  617. });
  618. const lastMaterial = await ctx.service.material.getLastestMaterial(ctx.tender.id, true);
  619. if (lastMaterial && !lastMaterial.is_new) {
  620. const materialListData = await ctx.service.materialList.getMaterialData(ctx.tender.id, lastMaterial.id);
  621. const hadBillsList = [];
  622. for (const ml of materialListData) {
  623. const hb = _.find(hadBillsList, { gcl_id: ml.gcl_id, mb_id: ml.mb_id });
  624. if (!hb) {
  625. hadBillsList.push({
  626. gcl_id: ml.gcl_id,
  627. mb_id: ml.mb_id,
  628. order: ml.order,
  629. quantity: ml.quantity,
  630. expr: ml.expr,
  631. });
  632. }
  633. }
  634. // 批量插入并修改is_new值
  635. await ctx.service.materialListGcl.setData(lastMaterial.id, hadBillsList);
  636. // responseData.data.gclList = hadBillsList;
  637. }
  638. // } else {
  639. // 判断是否是最新期,不是则获取的gclList是由materialList拼接而成,
  640. if (lastMaterial.id === ctx.material.id) {
  641. const hadBillsList = await ctx.service.materialListGcl.getAllDataByCondition({ where: { tid: ctx.tender.id } });
  642. responseData.data.gclList = hadBillsList;
  643. } else {
  644. const materialList = await this.ctx.service.materialList.getAllDataByCondition({ where: { mid: ctx.material.id, is_self: 0 } });
  645. const hadBillsList = ctx.app._.unionWith(materialList, function(item1, item2) {
  646. return item1.gcl_id === item2.gcl_id && item1.mb_id === item2.mb_id;
  647. });
  648. responseData.data.gclList = hadBillsList;
  649. }
  650. ctx.body = responseData;
  651. } catch (err) {
  652. this.log(err);
  653. ctx.body = { err: 1, msg: err.toString(), data: null };
  654. }
  655. }
  656. /**
  657. * 调差清单新建台账数据获取 (Post)
  658. * @param {Object} ctx - egg全局变量
  659. * @return {Promise<void>}
  660. */
  661. async loadGclData(ctx) {
  662. try {
  663. // const data = JSON.parse(ctx.request.body.data);
  664. // const filter = data.filter.split(';');
  665. const responseData = { err: 0, msg: '', data: {} };
  666. const data = JSON.parse(ctx.request.body.data);
  667. if (data.stage_id === '') {
  668. throw '没有选中计量期';
  669. }
  670. // 取所有已被调用的工料清单表
  671. // responseData.data.materialListData = await ctx.service.materialList.getMaterialData(ctx.tender.id, ctx.material.id);
  672. // responseData.data.materialNotJoinListData = await ctx.service.materialListNotjoin.getAllDataByCondition({ where: { tid: ctx.tender.id, mid: ctx.material.id } });
  673. // 获取清单数据
  674. responseData.data.ledger = await ctx.service.ledger.getData(ctx.tender.id);
  675. responseData.data.pos = await ctx.service.pos.getPosData({ tid: ctx.tender.id });
  676. // 获取所选期数据并合并相加同类清单项
  677. if (data.is_stage_self) {
  678. const stage_id_list = data.stage_id;
  679. const curLedgerData = [];
  680. const curPosData = [];
  681. for (const sid of stage_id_list) {
  682. curLedgerData.push({ sid, ledgerData: await ctx.service.stageBills.getLastestStageData2(ctx.tender.id, sid) });
  683. curPosData.push({ sid, posData: await ctx.service.stagePos.getLastestStageData2(ctx.tender.id, sid) });
  684. }
  685. responseData.data.curLedgerData = curLedgerData;
  686. responseData.data.curPosData = curPosData;
  687. } else {
  688. responseData.data.curLedgerData = await ctx.service.stageBills.getStagesData(ctx.tender.id, data.stage_id.join(','));
  689. responseData.data.curPosData = await ctx.service.stagePos.getStagesData(ctx.tender.id, data.stage_id.join(','), 'list');
  690. }
  691. // 获取gclidlist值
  692. const lastMaterial = await ctx.service.material.getLastestCompleteMaterial(ctx.tender.id);
  693. // responseData.data.materialListData = await ctx.service.materialList.getMaterialData(ctx.tender.id, lastMaterial.id);
  694. if (lastMaterial && !lastMaterial.is_new) {
  695. const materialListData = await ctx.service.materialList.getMaterialData(ctx.tender.id, lastMaterial.id);
  696. const hadBillsList = [];
  697. for (const ml of materialListData) {
  698. const hb = _.find(hadBillsList, { gcl_id: ml.gcl_id, mb_id: ml.mb_id });
  699. if (!hb) {
  700. hadBillsList.push({
  701. gcl_id: ml.gcl_id,
  702. mb_id: ml.mb_id,
  703. order: ml.order,
  704. quantity: ml.quantity,
  705. expr: ml.expr,
  706. });
  707. }
  708. }
  709. // 批量插入并修改is_new值
  710. await ctx.service.materialListGcl.setData(lastMaterial.id, hadBillsList);
  711. // responseData.data.gclList = hadBillsList;
  712. }
  713. const hadBillsList = await ctx.service.materialListGcl.getAllDataByCondition({ where: { tid: ctx.tender.id } });
  714. responseData.data.gclList = hadBillsList;
  715. // 获取上一期的单独设置的清单明细
  716. responseData.data.materialListForSelf = lastMaterial ? await ctx.service.materialList.getAllDataByCondition({ where: { tid: ctx.tender.id, mid: lastMaterial.id, is_self: 1 } }) : [];
  717. responseData.data.selfList = lastMaterial ? await ctx.service.materialListSelf.getAllDataByCondition({ where: { tid: ctx.tender.id, mid: lastMaterial.id } }) : [];
  718. // 获取清单设置已选清单
  719. // const materialChecklistData = await ctx.service.materialChecklist.getAllDataByCondition({ where: { tid: ctx.tender.id } });
  720. // responseData.data.materialChecklistData = materialChecklistData.sort(function(a, b) {
  721. // return ctx.helper.compareCode(a.b_code, b.b_code);
  722. // });
  723. ctx.body = responseData;
  724. } catch (err) {
  725. this.log(err);
  726. ctx.body = { err: 1, msg: err.toString(), data: null };
  727. }
  728. }
  729. /**
  730. * 指数调差页面 (Get)
  731. * @param {Object} ctx - egg全局变量
  732. * @return {Promise<void>}
  733. */
  734. async exponent(ctx) {
  735. try {
  736. await this._checkExponentExist(ctx);
  737. await this._getMaterialAuditViewData(ctx);
  738. const renderData = await this._getDefaultRenderData(ctx);
  739. const stage_list = await ctx.service.stage.getStageMsgByStageId(ctx.material.stage_id);
  740. renderData.ex_calc = materialConst.ex_calc;
  741. if (!ctx.material.ex_calc) {
  742. const calcBase = await ctx.service.stage.getMaterialCalcBase(stage_list, ctx.tender.info);
  743. for (const bq of renderData.ex_calc) {
  744. const calc = _.find(calcBase, { code: bq.code }) || _.find(calcBase, { code: 'bqwc' });
  745. bq.value = calc.value;
  746. // if (calc.code === 'bqwc') {
  747. // ctx.material.ex_expr = calc.value.toString() + '*[0-1]';
  748. // ctx.material.ex_tp = this.ctx.helper.round(this.ctx.helper.mul(calc.value, -1), 2);
  749. // }
  750. }
  751. // 并更新至调差表中
  752. await ctx.service.material.update({ ex_calc: JSON.stringify(renderData.ex_calc) }, { id: ctx.material.id });
  753. } else {
  754. const ex_calc = JSON.parse(ctx.material.ex_calc);
  755. if (ctx.helper._.findIndex(ex_calc, { code: 'zdy' }) === -1) {
  756. ex_calc.push({
  757. code: 'zdy',
  758. text: '自定义金额',
  759. value: ctx.helper._.find(ex_calc, { code: 'bqwc' }).value,
  760. select: false,
  761. });
  762. // 并更新至调差表中
  763. await ctx.service.material.update({ ex_calc: JSON.stringify(ex_calc) }, { id: ctx.material.id });
  764. }
  765. renderData.ex_calc = ex_calc;
  766. }
  767. renderData.materialBillsData = await this._getMaterialBillsData(ctx);
  768. renderData.materialExponentData = await this._getMaterialExponentData(ctx);
  769. // 取对应期的截取上期的调差金额和应耗数量
  770. if (ctx.material.highOrder !== ctx.material.order) {
  771. for (const [mindex, me] of renderData.materialExponentData.entries()) {
  772. const result = await ctx.service.materialExponentHistory.getByMeId(ctx.material.id, ctx.material.order, me.id);
  773. _.forEach(result, function(value, key) {
  774. renderData.materialExponentData[mindex][key] = result ? result[key] : null;
  775. });
  776. }
  777. }
  778. // 取当前期截止上期含税金额
  779. renderData.pre_tp_hs = await ctx.service.material.getPreTpHs(ctx.tender.id, ctx.material.order, ctx.material.decimal.tp);
  780. renderData.ex_pre_tp_hs = await ctx.service.material.getExPreTpHs(ctx.tender.id, ctx.material.order, ctx.material.decimal.tp);
  781. renderData.materialType = materialConst;
  782. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.material.exponent);
  783. // 判断之前期有无调用过材料税
  784. renderData.old_had_tax = await ctx.service.material.getOldMaterialTax(ctx.tender.id, ctx.params.order);
  785. await this.layout('material/exponent.ejs', renderData, 'material/exponent_modal.ejs');
  786. } catch (err) {
  787. this.log(err);
  788. ctx.redirect('/tender/' + ctx.tender.id + '/measure/material');
  789. }
  790. }
  791. /**
  792. * 附件页面 (Get)
  793. * @param {Object} ctx - egg全局变量
  794. * @return {Promise<void>}
  795. */
  796. async file(ctx) {
  797. try {
  798. await this._getMaterialAuditViewData(ctx);
  799. const renderData = await this._getDefaultRenderData(ctx);
  800. renderData.materialBillsData = await this._getMaterialBillsData(ctx);
  801. const whiteList = this.ctx.app.config.multipart.whitelist;
  802. // 获取当前标段所有附件
  803. // const searchsql = { tid: ctx.tender.id };
  804. renderData.fileList = await ctx.service.materialFile.getAllMaterialFiles(ctx.tender.id);
  805. renderData.auditors = ctx.material.auditors.map(audit => audit.aid);
  806. // renderData.auditors = ctx.material.auditors2.map(audit => audit.aid);
  807. renderData.report_id = ctx.material.user_id;
  808. renderData.auditConst = auditConst;
  809. renderData.whiteList = whiteList;
  810. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.material.file);
  811. await this.layout('material/file.ejs', renderData, 'material/file_modal.ejs');
  812. } catch (err) {
  813. this.log(err);
  814. ctx.redirect('/tender/' + ctx.tender.id + '/measure/material');
  815. }
  816. }
  817. /**
  818. * 调差操作 (form)
  819. * @param ctx
  820. * @return {Promise<void>}
  821. */
  822. async saveDecimal(ctx) {
  823. try {
  824. const data = ctx.request.body;
  825. if (ctx.material.status !== auditConst.status.uncheck && ctx.material.status !== auditConst.status.checkNo) {
  826. throw '当前调差期无法调整小数位数';
  827. }
  828. const newDecimalUp = parseInt(data.up);
  829. const newDecimalTp = parseInt(data.tp);
  830. const newDecimalQty = parseInt(data.qty);
  831. const newQtySource = parseInt(data.qty_source);
  832. if (ctx.app._.isNaN(newDecimalUp) || newDecimalUp > 6 || newDecimalUp < 0) {
  833. throw '单价小数位数设置不能大于6或小于0';
  834. }
  835. if (ctx.app._.isNaN(newDecimalTp) || newDecimalTp > 6 || newDecimalTp < 0) {
  836. throw '金额小数位数设置不能大于6或小于0';
  837. }
  838. if (ctx.app._.isNaN(newDecimalQty) || newDecimalQty > 6 || newDecimalQty < 0) {
  839. throw '数量小数位数设置不能大于6或小于0';
  840. }
  841. if (ctx.material.decimal.up === newDecimalUp && ctx.material.decimal.tp === newDecimalTp && ctx.material.decimal.qty === newDecimalQty && newQtySource === ctx.material.qty_source) {
  842. throw '设置内容未发生变化';
  843. }
  844. if (ctx.material.decimal.up !== newDecimalUp || ctx.material.decimal.tp !== newDecimalTp || ctx.material.decimal.qty !== newDecimalQty) {
  845. const result = await ctx.service.material.saveDecimal(newDecimalUp, newDecimalTp, newDecimalQty);
  846. if (!result) {
  847. throw '小数位数设置失败';
  848. }
  849. }
  850. if (newQtySource !== ctx.material.qty_source) {
  851. const result = await ctx.service.material.saveQtySource(newQtySource);
  852. }
  853. this.setMessage('设置成功', this.messageType.SUCCESS);
  854. } catch (err) {
  855. console.log(err);
  856. this.log(err);
  857. ctx.session.postError = err.toString();
  858. }
  859. ctx.redirect(ctx.request.header.referer);
  860. }
  861. /**
  862. * 调差清单 - 工料操作 (Ajax)
  863. * @param ctx
  864. * @return {Promise<void>}
  865. */
  866. async saveListsData(ctx) {
  867. try {
  868. const data = JSON.parse(ctx.request.body.data);
  869. const responseData = {
  870. err: 0,
  871. msg: '',
  872. data: {},
  873. };
  874. const notControlList = ['join', 'notjoin', 'change', 'notchange', 'self', 'noself', 'useOther', 'add', 'del', 'update', 'paste'];
  875. if (ctx.subProject.page_show.openMaterialChecklist && ctx.app._.indexOf(notControlList, data.type) === -1) {
  876. throw '清单设置功能已启动,请前往清单设置页操作清单内容';
  877. }
  878. const selfControlList = ['self', 'noself', 'add', 'del', 'update', 'paste'];
  879. if (!ctx.subProject.page_show.openMaterialSelf && ctx.app._.indexOf(selfControlList, data.type) !== -1) {
  880. throw '单独设置工料功能已关闭,无法设置';
  881. }
  882. switch (data.type) {
  883. case 'add':
  884. responseData.data = await ctx.service.materialList.add(data.postData, data.ms_id);
  885. break;
  886. case 'del':
  887. await ctx.service.materialList.del(data.id, data.mb_id, data.ms_id);
  888. break;
  889. case 'update':
  890. if (data.updateData.quantity === '' || data.updateData.quantity === null) {
  891. throw '请输入数量';
  892. }
  893. // 判断数量是否为数字
  894. if (isNaN(data.updateData.quantity)) {
  895. throw '不能输入其它非数字类型字符';
  896. }
  897. await ctx.service.materialList.save(data.updateData, data.ms_id);
  898. break;
  899. case 'useOther':
  900. responseData.data = await ctx.service.materialList.addOther(data.postData);
  901. break;
  902. case 'change':
  903. case 'join':
  904. await ctx.service.materialListNotjoin.del(data.select.id, data.ms_id);
  905. break;
  906. case 'notjoin':
  907. responseData.data = await ctx.service.materialListNotjoin.add(data.select, data.ms_id);
  908. break;
  909. case 'notchange':
  910. responseData.data = await ctx.service.materialListNotjoin.addChange(data.select, data.ms_id);
  911. break;
  912. case 'self':
  913. responseData.data = await ctx.service.materialListSelf.add(data.select);
  914. break;
  915. case 'noself':
  916. responseData.data = await ctx.service.materialListSelf.del(data.select.id, data.ms_id, data.select);
  917. break;
  918. case 'paste':
  919. await ctx.service.materialList.saveDatas(data.updateData, data.ms_id);
  920. // 取所有工料表
  921. responseData.data = await ctx.service.materialList.getMaterialData(ctx.tender.id, ctx.material.id);
  922. break;
  923. case 'adds':
  924. responseData.data = await ctx.service.materialList.adds(data.postData);
  925. break;
  926. case 'dels':
  927. responseData.data = await ctx.service.materialList.dels(data.postData, false, false, data.ms_id);
  928. break;
  929. case 'updates':
  930. if (data.updateData.quantity === '' || data.updateData.quantity === null) {
  931. throw '请输入数量';
  932. }
  933. // 判断数量是否为数字
  934. if (isNaN(data.updateData.quantity)) {
  935. throw '不能输入其它非数字类型字符';
  936. }
  937. responseData.data = await ctx.service.materialList.saves(data.updateData, false, data.ms_id);
  938. break;
  939. case 'pastes':
  940. responseData.data = await ctx.service.materialList.savePastes(data.updateData, false, data.ms_id);
  941. // 取所有工料表
  942. break;
  943. default: throw '参数有误';
  944. }
  945. ctx.body = responseData;
  946. } catch (err) {
  947. this.log(err);
  948. ctx.body = { err: 1, msg: err.toString(), data: null };
  949. }
  950. }
  951. /**
  952. * 调差工料 - 编辑工料项 (Ajax)
  953. * @param ctx
  954. * @return {Promise<void>}
  955. */
  956. async saveBillsData(ctx) {
  957. try {
  958. const data = JSON.parse(ctx.request.body.data);
  959. const responseData = {
  960. err: 0,
  961. msg: '',
  962. data: {},
  963. };
  964. switch (data.type) {
  965. case 'add':
  966. responseData.data = await ctx.service.materialBills.add();
  967. break;
  968. case 'del':
  969. responseData.data = await ctx.service.materialBills.del(data.id);
  970. break;
  971. case 'changeOrder':
  972. await ctx.service.materialBills.changeOrder(data.postData);
  973. break;
  974. case 'update':
  975. if (data.updateData.code === '' || data.updateData.code === null) {
  976. throw '请先输入编号';
  977. }
  978. // 判断编号为纯数字时,不能为小数
  979. if (!isNaN(data.updateData.code) && data.updateData.code.toString().indexOf('.') !== -1) {
  980. throw '编号为纯数字时,不能为小数';
  981. }
  982. if (data.updateData.code.length > 15) {
  983. throw '长度不超过15个字符';
  984. }
  985. // 判断编号是否已存在
  986. const billData = await ctx.service.materialBills.getAllDataByCondition({ where: { tid: ctx.tender.id, code: data.updateData.code } });
  987. if (billData.length > 1 || (billData.length > 0 && billData[0].id !== data.updateData.id)) {
  988. throw '该编号已存在,请重新输入。';
  989. }
  990. responseData.data = await ctx.service.materialBills.save(data.updateData, data.ms_id);
  991. break;
  992. case 'rate':
  993. // 判断数量是否为数字
  994. if (isNaN(data.rate)) {
  995. throw '不能输入其它非数字类型字符';
  996. }
  997. if (ctx.material.readOnly) {
  998. throw '无权操作';
  999. }
  1000. await ctx.service.material.changeRate(data.rate);
  1001. break;
  1002. case 'expr':
  1003. responseData.data = await ctx.service.materialBills.updateFYQuantity(data);
  1004. break;
  1005. case 'paste':
  1006. responseData.data = await ctx.service.materialBills.saveDatas(data.updateData, data.ms_id);
  1007. // 根据期判断需要获取的工料信息值
  1008. // const searchsql = { tid: ctx.tender.id };
  1009. // if (ctx.material.highOrder !== ctx.material.order) {
  1010. // const midList = await ctx.service.material.getPreMidList(ctx.tender.id, ctx.material.order);
  1011. // searchsql.mid = midList;
  1012. // }
  1013. // // 取所有工料表
  1014. // responseData.data.info = await ctx.service.materialBills.getAllDataByCondition({ where: searchsql, orders: [['order', 'asc']] });
  1015. responseData.data.info = await this._getMaterialBillsData(ctx);
  1016. break;
  1017. case 'add-glj':
  1018. responseData.data = await ctx.service.materialBills.addByGlj(data.postData, data.order);
  1019. break;
  1020. case 'export':
  1021. responseData.data = await ctx.service.materialBills.exportData(data.postData, data.includeSpec, data.ms_id);
  1022. break;
  1023. case 'qty_update':
  1024. responseData.data = await ctx.service.materialList.saveQtyHistory(data.needUpdateList);
  1025. break;
  1026. default: throw '参数有误';
  1027. }
  1028. if (ctx.material.material_tax) {
  1029. responseData.data.m_tax_tp = await ctx.service.material.getMaterialTaxTp(ctx.material.id);
  1030. }
  1031. ctx.body = responseData;
  1032. } catch (err) {
  1033. this.log(err);
  1034. ctx.body = { err: 1, msg: err.toString(), data: null };
  1035. }
  1036. }
  1037. /**
  1038. * 调差工料 - 编辑月信息价 (Ajax)
  1039. * @param ctx
  1040. * @return {Promise<void>}
  1041. */
  1042. async saveMonth(ctx) {
  1043. try {
  1044. const data = JSON.parse(ctx.request.body.data);
  1045. const responseData = {
  1046. err: 0,
  1047. msg: '',
  1048. data: {},
  1049. };
  1050. const monthList = await ctx.service.materialMonth.getListByMid(ctx.material.id);
  1051. const mbList = await this._getMaterialBillsData(ctx);
  1052. const material_month = this.ctx.material.months ? this.ctx.material.months.split(',') : [];
  1053. switch (data.type) {
  1054. case 'add':
  1055. // 判断是否已存在该月份
  1056. if (ctx.app._.indexOf(material_month, data.updateData.yearmonth) !== -1) {
  1057. throw '调差期已创建过本月的信息价,请刷新页面重新获取';
  1058. }
  1059. const tp = await ctx.service.materialMonth.add(data.updateData, monthList, mbList);
  1060. const materialBillsData = await this._getMaterialBillsData(ctx);
  1061. const monthsList = await this._getMaterialMonthsData(ctx, materialBillsData);
  1062. responseData.data = {
  1063. m_tp: tp,
  1064. monthsList,
  1065. };
  1066. break;
  1067. case 'del':
  1068. // 判断是否已不存在该月份
  1069. if (ctx.app._.intersection(data.updateData.del_yearmonth, material_month).length !== data.updateData.del_yearmonth.length) {
  1070. throw '调差期已删除本月的信息价,请刷新页面重新获取';
  1071. }
  1072. const tp2 = await ctx.service.materialMonth.del(data.updateData.del_yearmonth, monthList, mbList);
  1073. const materialBillsData2 = await this._getMaterialBillsData(ctx);
  1074. const monthsList2 = await this._getMaterialMonthsData(ctx, materialBillsData2);
  1075. responseData.data = {
  1076. m_tp: tp2,
  1077. monthsList: monthsList2,
  1078. };
  1079. break;
  1080. case 'update':
  1081. const tp3 = await ctx.service.materialMonth.save(data.updateData);
  1082. responseData.data = {
  1083. m_tp: tp3,
  1084. };
  1085. break;
  1086. case 'updateOrigin':
  1087. await ctx.service.materialBills.saveOrigin(data.updateData);
  1088. break;
  1089. case 'paste':
  1090. const tp4 = await ctx.service.materialMonth.saveDatas(data.updateData, mbList);
  1091. responseData.data = {
  1092. m_tp: tp4,
  1093. };
  1094. break;
  1095. case 'pasteOrigin':
  1096. await ctx.service.materialBills.saveOrigins(data.updateData);
  1097. break;
  1098. default: throw '参数有误';
  1099. }
  1100. if (ctx.material.material_tax) {
  1101. responseData.data.m_tax_tp = await ctx.service.material.getMaterialTaxTp(ctx.material.id);
  1102. }
  1103. responseData.data.materialBillsData = await this._getMaterialBillsData(ctx);
  1104. ctx.body = responseData;
  1105. } catch (err) {
  1106. this.log(err);
  1107. ctx.body = { err: 1, msg: err.toString(), data: null };
  1108. }
  1109. }
  1110. /**
  1111. * 指数调差 - 编辑指数清单项 (Ajax)
  1112. * @param ctx
  1113. * @return {Promise<void>}
  1114. */
  1115. async saveExponentData(ctx) {
  1116. try {
  1117. const data = JSON.parse(ctx.request.body.data);
  1118. const responseData = {
  1119. err: 0,
  1120. msg: '',
  1121. data: {},
  1122. };
  1123. let ex_tp = ctx.material.ex_tp;
  1124. let ex_expr = ctx.material.ex_expr;
  1125. switch (data.type) {
  1126. case 'add':
  1127. responseData.data = await ctx.service.materialExponent.add();
  1128. break;
  1129. case 'del':
  1130. [ex_tp, ex_expr] = await ctx.service.materialExponent.del(data.id);
  1131. responseData.data.ex_tp = ex_tp;
  1132. responseData.data.ex_expr = ex_expr;
  1133. break;
  1134. case 'update':
  1135. [ex_tp, ex_expr] = await ctx.service.materialExponent.save(data.updateData);
  1136. responseData.data.ex_tp = ex_tp;
  1137. responseData.data.ex_expr = ex_expr;
  1138. break;
  1139. case 'rate':
  1140. // 判断数量是否为数字
  1141. if (isNaN(data.rate)) {
  1142. throw '不能输入其它非数字类型字符';
  1143. }
  1144. if (ctx.material.readOnly) {
  1145. throw '无权操作';
  1146. }
  1147. await ctx.service.material.changeExponentRate(data.rate);
  1148. break;
  1149. case 'paste':
  1150. [ex_tp, ex_expr] = await ctx.service.materialExponent.saveDatas(data.updateData);
  1151. responseData.data.ex_tp = ex_tp;
  1152. responseData.data.ex_expr = ex_expr;
  1153. // 取所有指数清单
  1154. responseData.data.info = await this._getMaterialExponentData(ctx);
  1155. break;
  1156. case 'ex_calc':
  1157. // 判断数量是否为数字
  1158. [ex_tp, ex_expr] = await ctx.service.material.changeExCalc(data.updateData);
  1159. responseData.data.ex_tp = ex_tp;
  1160. responseData.data.ex_expr = ex_expr;
  1161. break;
  1162. default: throw '参数有误';
  1163. }
  1164. ctx.body = responseData;
  1165. } catch (err) {
  1166. this.log(err);
  1167. ctx.body = { err: 1, msg: err.toString(), data: null };
  1168. }
  1169. }
  1170. // 审批相关
  1171. /**
  1172. * 添加审批人
  1173. * @param ctx
  1174. * @return {Promise<void>}
  1175. */
  1176. async addAudit(ctx) {
  1177. try {
  1178. const data = JSON.parse(ctx.request.body.data);
  1179. const id = this.app._.toInteger(data.auditorId);
  1180. if (isNaN(id) || id <= 0) {
  1181. throw '参数错误';
  1182. }
  1183. // 检查权限等
  1184. if (ctx.material.user_id !== ctx.session.sessionUser.accountId) {
  1185. throw '您无权添加审核人';
  1186. }
  1187. if (ctx.material.status === auditConst.status.checking || ctx.material.status === auditConst.status.checked) {
  1188. throw '当前不允许添加审核人';
  1189. }
  1190. ctx.material.auditorList = await ctx.service.materialAudit.getAuditors(ctx.material.id, ctx.material.times);
  1191. // 检查审核人是否已存在
  1192. const exist = this.app._.find(ctx.material.auditorList, { aid: id, is_old: 0 });
  1193. if (exist) {
  1194. throw '该审核人已存在,请勿重复添加';
  1195. }
  1196. const shenpiInfo = await ctx.service.shenpiAudit.getDataByCondition({ tid: ctx.tender.id, sp_type: shenpiConst.sp_type.material, sp_status: shenpiConst.sp_status.gdzs });
  1197. const is_gdzs = shenpiInfo && ctx.tender.info.shenpi.material === shenpiConst.sp_status.gdzs ? 1 : 0;
  1198. const result = await ctx.service.materialAudit.addAuditor(ctx.material.id, id, ctx.material.times, is_gdzs);
  1199. if (!result) {
  1200. throw '添加审核人失败';
  1201. }
  1202. const auditors = await ctx.service.materialAudit.getUserGroup(ctx.material.id, ctx.material.times);
  1203. ctx.body = { err: 0, msg: '', data: auditors };
  1204. } catch (err) {
  1205. this.log(err);
  1206. ctx.body = { err: 1, msg: err.toString(), data: null };
  1207. }
  1208. }
  1209. /**
  1210. * 移除审批人
  1211. * @param ctx
  1212. * @return {Promise<void>}
  1213. */
  1214. async deleteAudit(ctx) {
  1215. try {
  1216. const data = JSON.parse(ctx.request.body.data);
  1217. const id = data.auditorId instanceof Number ? data.auditorId : this.app._.toNumber(data.auditorId);
  1218. if (isNaN(id) || id <= 0) {
  1219. throw '参数错误';
  1220. }
  1221. const result = await ctx.service.materialAudit.deleteAuditor(ctx.material.id, id, ctx.material.times);
  1222. if (!result) {
  1223. throw '移除审核人失败';
  1224. }
  1225. const auditors = await ctx.service.materialAudit.getAuditors(ctx.material.id, ctx.material.times);
  1226. ctx.body = { err: 0, msg: '', data: auditors };
  1227. } catch (err) {
  1228. ctx.body = { err: 1, msg: err.toString(), data: null };
  1229. }
  1230. }
  1231. /**
  1232. * 上报和重新上报
  1233. * @param ctx
  1234. * @return {Promise<void>}
  1235. */
  1236. async startAudit(ctx) {
  1237. try {
  1238. // 检查权限等
  1239. if (!ctx.material) {
  1240. throw '数据错误';
  1241. }
  1242. if (ctx.material.user_id !== ctx.session.sessionUser.accountId) {
  1243. throw '您无权上报该期数据';
  1244. }
  1245. if (ctx.material.status === auditConst.status.checking || ctx.material.status === auditConst.status.checked) {
  1246. throw '该材料调差期数据当前无法上报';
  1247. }
  1248. await ctx.service.materialAudit.start(ctx.material.id, ctx.material.times);
  1249. ctx.redirect(ctx.request.header.referer);
  1250. } catch (err) {
  1251. this.log(err);
  1252. ctx.session.postError = err.toString();
  1253. ctx.redirect(ctx.request.header.referer);
  1254. }
  1255. }
  1256. /**
  1257. * 审批
  1258. * @param ctx
  1259. * @return {Promise<void>}
  1260. */
  1261. async checkAudit(ctx) {
  1262. try {
  1263. if (!ctx.material || (ctx.material.status !== auditConst.status.checking && ctx.material.status !== auditConst.status.checkNoPre)) {
  1264. throw '当前材料调差期数据有误';
  1265. }
  1266. if (ctx.material.curAuditorIds.indexOf(ctx.session.sessionUser.accountId) < 0) {
  1267. throw '您无权进行该操作';
  1268. }
  1269. const data = {
  1270. checkType: parseInt(ctx.request.body.checkType),
  1271. opinion: ctx.request.body.opinion,
  1272. };
  1273. if (!data.checkType || isNaN(data.checkType)) {
  1274. throw '提交数据错误';
  1275. }
  1276. // if (data.checkType === auditConst.status.checkNo) {
  1277. // if (!data.checkType || isNaN(data.checkType)) {
  1278. // throw '提交数据错误';
  1279. // }
  1280. // }
  1281. await ctx.service.materialAudit.check(ctx.material.id, data, ctx.material.times);
  1282. ctx.redirect(ctx.request.header.referer);
  1283. } catch (err) {
  1284. this.log(err);
  1285. ctx.session.postError = err.toString();
  1286. ctx.redirect(ctx.request.header.referer);
  1287. }
  1288. }
  1289. async _checkMaterialFileCanModify(ctx) {
  1290. // 检查登录用户,是否可操作
  1291. const accountId = ctx.session.sessionUser.accountId;
  1292. const auditors = await ctx.service.materialAudit.getAuditorsWithOwner(ctx.material.id, ctx.material.times);
  1293. // console.log(auditors);
  1294. if (auditors.findIndex(item => item.aid === accountId) === -1 && !ctx.tender.touristPermission.file) {
  1295. throw '该调差期当前您无权操作';
  1296. }
  1297. // if (!ctx.material.curAuditor) {
  1298. // if (ctx.material.status === auditConst.status.uncheck || ctx.material.status === auditConst.status.checkNo && accountId === ctx.material.user_id) {
  1299. // return;
  1300. // }
  1301. // throw '该调差期当前您无权操作';
  1302. // } else {
  1303. // if (ctx.material.curAuditor.aid === accountId) return;
  1304. // throw '该调差期当前您无权操作';
  1305. // }
  1306. }
  1307. /**
  1308. * 上传附件
  1309. * @param {*} ctx 上下文
  1310. */
  1311. async upload(ctx) {
  1312. let stream;
  1313. try {
  1314. await this._checkMaterialFileCanModify(ctx);
  1315. const parts = this.ctx.multipart({
  1316. autoFields: true,
  1317. });
  1318. const files = [];
  1319. const create_time = Date.parse(new Date()) / 1000;
  1320. let idx = 0;
  1321. const extra_upload = ctx.material.status === auditConst.status.checked;
  1322. while ((stream = await parts()) !== undefined) {
  1323. if (!stream.filename) {
  1324. // 如果没有传入直接返回
  1325. return;
  1326. }
  1327. const fileInfo = path.parse(stream.filename);
  1328. // const filepath = path.join('public/upload', this.ctx.tender.id.toString(), 'tc', 'fujian_' + create_time + fileInfo.ext);
  1329. const filepath = `app/public/upload/${this.ctx.tender.id.toString()}/tc/fujian_${create_time + idx.toString() + fileInfo.ext}`;
  1330. // await ctx.helper.saveStreamFile(stream, path.resolve(this.app.baseDir, 'app', filepath));
  1331. await ctx.app.fujianOss.put(ctx.app.config.fujianOssFolder + filepath, stream);
  1332. files.push({ filepath, name: stream.filename, ext: fileInfo.ext });
  1333. ++idx;
  1334. }
  1335. const upload_time = this.ctx.helper.dateTran(new Date());
  1336. const payload = files.map(file => {
  1337. let idx;
  1338. if (Array.isArray(parts.field.name)) {
  1339. idx = parts.field.name.findIndex(name => name === file.name);
  1340. } else {
  1341. idx = 'isString';
  1342. }
  1343. const newFile = {
  1344. tid: ctx.tender.id,
  1345. user_id: ctx.session.sessionUser.accountId,
  1346. mid: ctx.material.id,
  1347. s_order: ctx.params.order,
  1348. upload_time,
  1349. filepath: file.filepath,
  1350. file_size: ctx.helper.bytesToSize(idx === 'isString' ? parts.field.size : parts.field.size[idx]),
  1351. file_name: file.name,
  1352. fileext: file.ext,
  1353. extra_upload,
  1354. };
  1355. return newFile;
  1356. });
  1357. // 执行文件信息写入数据库
  1358. await ctx.service.materialFile.saveFileMsgToDb(payload);
  1359. // 将最新的当前标段的所有文件信息返回
  1360. const data = await ctx.service.materialFile.getAllMaterialFiles(ctx.tender.id);
  1361. ctx.body = { err: 0, msg: '', data };
  1362. } catch (err) {
  1363. stream && (await sendToWormhole(stream));
  1364. this.log(err);
  1365. ctx.body = { err: 1, msg: err.toString(), data: null };
  1366. }
  1367. }
  1368. /**
  1369. * 下载附件
  1370. * @param {Object} ctx - egg全局变量
  1371. * @return {void}
  1372. */
  1373. async downloadFile(ctx) {
  1374. const id = ctx.params.fid;
  1375. if (id) {
  1376. try {
  1377. const fileInfo = await ctx.service.materialFile.getDataById(id);
  1378. if (fileInfo !== undefined && fileInfo !== '') {
  1379. // const fileName = path.join(__dirname, '../', fileInfo.filepath);
  1380. // 解决中文无法下载问题
  1381. const userAgent = (ctx.request.header['user-agent'] || '').toLowerCase();
  1382. let disposition = '';
  1383. if (userAgent.indexOf('msie') >= 0 || userAgent.indexOf('chrome') >= 0) {
  1384. disposition = 'attachment; filename=' + encodeURIComponent(fileInfo.file_name);
  1385. } else if (userAgent.indexOf('firefox') >= 0) {
  1386. disposition = 'attachment; filename*="utf8\'\'' + encodeURIComponent(fileInfo.file_name) + '"';
  1387. } else {
  1388. /* safari等其他非主流浏览器只能自求多福了 */
  1389. disposition = 'attachment; filename=' + new Buffer(fileInfo.file_name).toString('binary');
  1390. }
  1391. ctx.response.set({
  1392. 'Content-Type': 'application/octet-stream',
  1393. 'Content-Disposition': disposition,
  1394. 'Content-Length': fileInfo.file_size,
  1395. });
  1396. // ctx.body = await fs.createReadStream(fileName);
  1397. ctx.body = await ctx.helper.ossFileGet(fileInfo.filepath);
  1398. } else {
  1399. throw '不存在该文件';
  1400. }
  1401. } catch (err) {
  1402. this.log(err);
  1403. this.setMessage(err.toString(), this.messageType.ERROR);
  1404. }
  1405. }
  1406. }
  1407. /**
  1408. * 查看当前标段以往所有期的附件
  1409. * @param {Object} ctx 上下文
  1410. */
  1411. async getCurMatericalFiles(ctx) {
  1412. try {
  1413. // const { isCheck } = JSON.parse(ctx.request.body.data);
  1414. const data = await ctx.service.materialFile.getAllMaterialFiles(ctx.tender.id);
  1415. ctx.body = { err: 0, msg: '', data };
  1416. } catch (err) {
  1417. this.log(err);
  1418. ctx.body = { err: 1, msg: err.toString(), data: null };
  1419. }
  1420. }
  1421. /**
  1422. * 删除附件
  1423. * @param {Ojbect} ctx 上下文
  1424. */
  1425. async deleteFile(ctx) {
  1426. try {
  1427. const { data } = ctx.request.body;
  1428. const { id } = JSON.parse(data);
  1429. const fileInfo = await ctx.service.materialFile.getMaterialFileById(id);
  1430. if (!fileInfo || !Object.keys(fileInfo).length) {
  1431. throw '该文件不存在';
  1432. }
  1433. if (!fileInfo.extra_upload && ctx.material.status === auditConst.status.checked) {
  1434. throw '无权限删除';
  1435. }
  1436. if (fileInfo) {
  1437. // 先删除文件
  1438. // await fs.unlinkSync(path.resolve(this.app.baseDir, './app', fileInfo.filepath));
  1439. await ctx.app.fujianOss.delete(ctx.app.config.fujianOssFolder + fileInfo.filepath);
  1440. // 再删除数据库
  1441. await ctx.service.materialFile.delete(id);
  1442. } else {
  1443. throw '不存在该文件';
  1444. }
  1445. ctx.body = { err: 0, msg: '请求成功' };
  1446. } catch (err) {
  1447. this.log(err);
  1448. ctx.body = { err: 1, msg: err.toString(), data: null };
  1449. }
  1450. }
  1451. /**
  1452. * 批量下载 - 压缩成zip文件返回
  1453. * @param {Object} ctx - 全局上下文
  1454. */
  1455. async downloadZip(ctx) {
  1456. const zipFilename = `${ctx.tender.data.name}-材料调差-${ctx.params.order}-附件.zip`;
  1457. const time = Date.now();
  1458. const zipPath = `app/public/upload/${ctx.tender.id}/tc/fu_jian_zip${time}.zip`;
  1459. const responseData = {
  1460. err: 0,
  1461. msg: '',
  1462. };
  1463. try {
  1464. // const fileIds = JSON.parse(ctx.request.query.fileIds);
  1465. const { fileIds = [] } = JSON.parse(ctx.request.body.data);
  1466. const size = await ctx.service.materialFile.compressedFile(fileIds, zipPath);
  1467. // 解决中文无法下载问题
  1468. const userAgent = (ctx.request.header['user-agent'] || '').toLowerCase();
  1469. let disposition = '';
  1470. if (userAgent.indexOf('msie') >= 0 || userAgent.indexOf('chrome') >= 0) {
  1471. disposition = 'attachment; filename=' + encodeURIComponent(zipFilename);
  1472. } else if (userAgent.indexOf('firefox') >= 0) {
  1473. disposition = 'attachment; filename*="utf8\'\'' + encodeURIComponent(zipFilename) + '"';
  1474. } else {
  1475. /* safari等其他非主流浏览器只能自求多福了 */
  1476. disposition = 'attachment; filename=' + new Buffer(zipFilename).toString('binary');
  1477. }
  1478. ctx.response.set({
  1479. 'Content-Type': 'application/octet-stream',
  1480. 'Content-Disposition': disposition,
  1481. 'Content-Length': size,
  1482. });
  1483. const readStream = fs.createReadStream(path.join(this.app.baseDir, zipPath));
  1484. ctx.body = readStream;
  1485. readStream.on('close', () => {
  1486. if (fs.existsSync(path.resolve(this.app.baseDir, zipPath))) {
  1487. fs.unlinkSync(path.resolve(this.app.baseDir, zipPath));
  1488. }
  1489. });
  1490. // fs的错误不能被try catch捕捉
  1491. readStream.on('error', err => {
  1492. this.log(err);
  1493. if (fs.existsSync(path.resolve(this.app.baseDir, zipPath))) {
  1494. fs.unlinkSync(path.resolve(this.app.baseDir, zipPath));
  1495. }
  1496. responseData.err = 1;
  1497. responseData.msg = err.toString();
  1498. ctx.body = responseData;
  1499. });
  1500. } catch (err) {
  1501. this.log(err);
  1502. if (fs.existsSync(path.resolve(this.app.baseDir, zipPath))) {
  1503. fs.unlinkSync(path.resolve(this.app.baseDir, zipPath));
  1504. }
  1505. this.setMessage(err.toString(), this.messageType.ERROR);
  1506. responseData.err = 1;
  1507. responseData.msg = err.toString();
  1508. ctx.body = responseData;
  1509. }
  1510. }
  1511. async _setEditListPermission(ctx) {
  1512. const permission = ctx.session.sessionUser.permission;
  1513. ctx.material.editListPermission = permission && permission.material !== undefined && permission.material.indexOf('2') !== -1;
  1514. }
  1515. async _setEditTaxPermission(ctx) {
  1516. const permission = ctx.session.sessionUser.permission;
  1517. ctx.material.editTaxPermission = permission && permission.material !== undefined && permission.material.indexOf('3') !== -1;
  1518. }
  1519. async _setChecklistPermission(ctx) {
  1520. // 清单设置权限判断
  1521. ctx.material.checklistPermission = false;
  1522. if (ctx.subProject.page_show.openMaterialChecklist && ctx.material.highOrder === ctx.material.order && ctx.material.status !== auditConst.status.checked) {
  1523. const permission = ctx.session.sessionUser.permission;
  1524. if ((permission && ((permission.tender !== undefined && permission.tender.indexOf('4') !== -1) || (permission.material !== undefined && permission.material.indexOf('1') !== -1))) || (ctx.material.order === 1 && ctx.session.sessionUser.accountId === ctx.material.user_id && (ctx.material.status === auditConst.status.uncheck || ctx.material.status === auditConst.status.checkNo))) {
  1525. ctx.material.checklistPermission = true;
  1526. }
  1527. }
  1528. }
  1529. /**
  1530. * 清单设置页
  1531. * @param {Object} ctx - 全局上下文
  1532. */
  1533. async checklist(ctx) {
  1534. try {
  1535. await this._getMaterialAuditViewData(ctx);
  1536. await this._setChecklistPermission(ctx);
  1537. ctx.material.readOnly = !ctx.material.checklistPermission;
  1538. const renderData = await this._getDefaultRenderData(ctx);
  1539. // 根据期判断需要获取的工料信息值表
  1540. const searchsql = { tid: ctx.tender.id };
  1541. let midList = [];
  1542. if (ctx.material.highOrder !== ctx.material.order) {
  1543. midList = await ctx.service.material.getPreMidList(ctx.tender.id, ctx.material.order);
  1544. searchsql.mid = midList;
  1545. }
  1546. searchsql.t_type = materialConst.t_type[0].value;
  1547. renderData.materialBillsData = await ctx.service.materialBills.getAllDataByCondition({ where: searchsql, orders: [['order', 'asc']] });
  1548. // 取对应期的截取上期的调差金额和应耗数量
  1549. if (ctx.material.highOrder !== ctx.material.order) {
  1550. for (const [mindex, mb] of renderData.materialBillsData.entries()) {
  1551. const result = await ctx.service.materialBillsHistory.getByMbId(ctx.material.id, ctx.material.order, mb.id);
  1552. _.forEach(result, function(value, key) {
  1553. if (key === 'mb_id') {
  1554. renderData.materialBillsData[mindex].id = result ? result[key] : null;
  1555. } else {
  1556. renderData.materialBillsData[mindex][key] = result ? result[key] : null;
  1557. }
  1558. });
  1559. }
  1560. }
  1561. renderData.materialStageData = ctx.material.is_stage_self ? await ctx.service.materialStage.getAllDataByCondition({ where: { tid: ctx.tender.id, mid: ctx.material.id } }) : [];
  1562. renderData.materialStageBillsData = ctx.material.is_stage_self ? await ctx.service.materialStageBills.getAllDataByCondition({ where: { tid: ctx.tender.id, mid: ctx.material.id } }) : [];
  1563. // 取所有已被调用的工料清单表
  1564. // renderData.materialListData = await ctx.service.materialList.getMaterialData(ctx.tender.id, ctx.material.id);
  1565. // renderData.materialNotJoinListData = await ctx.service.materialListNotjoin.getAllDataByCondition({ where: { tid: ctx.tender.id, mid: ctx.material.id } });
  1566. renderData.materialType = JSON.stringify(materialConst);
  1567. renderData.jsFiles = this.app.jsFiles.common.concat(this.app.jsFiles.material.checklist);
  1568. // 获取清单数据
  1569. // renderData.ledger = await ctx.service.ledger.getData(ctx.tender.id);
  1570. // renderData.pos = await ctx.service.pos.getPosData({ tid: ctx.tender.id });
  1571. // 获取所选期数据并合并相加同类清单项
  1572. // renderData.curLedgerData = await ctx.service.stageBills.getStagesData(ctx.tender.id, ctx.material.stage_id);
  1573. // renderData.curPosData = await ctx.service.stagePos.getStagesData(ctx.tender.id, ctx.material.stage_id, 'list');
  1574. await this.layout('material/checklist.ejs', renderData, 'material/checklist_modal.ejs');
  1575. } catch (err) {
  1576. this.log(err);
  1577. ctx.redirect('/tender/' + ctx.tender.id + '/measure/material');
  1578. }
  1579. }
  1580. /**
  1581. * 清单设置 - 编辑指数清单项 (Ajax)
  1582. * @param ctx
  1583. * @return {Promise<void>}
  1584. */
  1585. async saveChecklistData(ctx) {
  1586. try {
  1587. const data = JSON.parse(ctx.request.body.data);
  1588. const responseData = {
  1589. err: 0,
  1590. msg: '',
  1591. data: {},
  1592. };
  1593. await this._setChecklistPermission(ctx);
  1594. if (ctx.material.order !== ctx.material.highOrder) {
  1595. throw '无法设置非最新期的清单设置数据';
  1596. }
  1597. // 权限控制
  1598. if (!ctx.material.checklistPermission && data.type !== 'resetChecklist') {
  1599. throw '本期已审批完成或权限不足,无法设置清单数据';
  1600. }
  1601. switch (data.type) {
  1602. case 'adds':
  1603. responseData.data = await ctx.service.materialList.adds(data.postData, data.checklist);
  1604. break;
  1605. case 'dels':
  1606. responseData.data = await ctx.service.materialList.dels(data.postData, data.checklist, true, data.ms_id);
  1607. break;
  1608. case 'updates':
  1609. if (data.updateData.quantity === '' || data.updateData.quantity === null) {
  1610. throw '请输入数量';
  1611. }
  1612. // 判断数量是否为数字
  1613. if (isNaN(data.updateData.quantity)) {
  1614. throw '不能输入其它非数字类型字符';
  1615. }
  1616. responseData.data = await ctx.service.materialList.saves(data.updateData, true, data.ms_id);
  1617. break;
  1618. case 'pastes':
  1619. responseData.data = await ctx.service.materialList.savePastes(data.updateData, true, data.ms_id);
  1620. // 取所有工料表
  1621. break;
  1622. case 'resetChecklist':
  1623. responseData.data = await ctx.service.materialChecklist.resetData(data.pushData, data.removeData, data.updateData);
  1624. break;
  1625. case 'exportCB':
  1626. responseData.data = await ctx.service.materialChecklist.addExportCB(data.addChecklist, data.addBillsList);
  1627. break;
  1628. default: throw '参数有误';
  1629. }
  1630. ctx.body = responseData;
  1631. } catch (err) {
  1632. this.log(err);
  1633. ctx.body = { err: 1, msg: err.toString(), data: null };
  1634. }
  1635. }
  1636. /**
  1637. * 重新审批
  1638. * @param ctx
  1639. * @return {Promise<void>}
  1640. */
  1641. async checkAuditAgain(ctx) {
  1642. try {
  1643. if (ctx.query.confirm !== undefined && ctx.query.confirm !== '确认设置终审审批') {
  1644. throw '请输入正确的文本信息';
  1645. }
  1646. if (ctx.session.sessionUser.loginStatus === 0) {
  1647. const code = ctx.query.code;
  1648. const pa = await ctx.service.projectAccount.getDataById(ctx.session.sessionUser.accountId);
  1649. if (!pa.auth_mobile) {
  1650. throw '未绑定手机号';
  1651. }
  1652. const cacheKey = 'smsCode:' + ctx.session.sessionUser.accountId;
  1653. const cacheCode = await app.redis.get(cacheKey);
  1654. if (cacheCode === null || code === undefined || cacheCode !== (code + pa.auth_mobile)) {
  1655. throw '验证码不正确!';
  1656. }
  1657. }
  1658. if ((ctx.material.auditors[ctx.material.auditors.length - 1].aid === ctx.session.sessionUser.accountId || (ctx.query.confirm === '确认设置终审审批' && ctx.session.sessionUser.is_admin)) && ctx.material.status === auditConst.status.checked && ctx.material.order === ctx.material.highOrder) {
  1659. await ctx.service.materialAudit.checkAgain(ctx.material.id, ctx.material.times);
  1660. // ctx.redirect(ctx.request.header.referer);
  1661. ctx.body = {
  1662. err: 0,
  1663. url: ctx.request.header.referer,
  1664. msg: '',
  1665. };
  1666. } else {
  1667. throw '您无权进行该操作';
  1668. }
  1669. } catch (err) {
  1670. this.log(err);
  1671. // ctx.session.postError = err.toString();
  1672. // ctx.redirect(ctx.request.header.referer);
  1673. ctx.body = {
  1674. err: 1,
  1675. // url: ctx.request.header.referer,
  1676. msg: err,
  1677. };
  1678. }
  1679. }
  1680. async saveAudit(ctx) {
  1681. try {
  1682. if (!ctx.session.sessionUser.is_admin || ctx.material.status === auditConst.status.checked) {
  1683. throw '您无权进行该操作';
  1684. }
  1685. const data = JSON.parse(ctx.request.body.data);
  1686. await ctx.service.materialAudit.saveAudit(ctx.material.id, ctx.material.times, 0, data);
  1687. const auditors = await ctx.service.materialAudit.getUniqUserGroup(ctx.material.id, ctx.material.times);
  1688. ctx.body = { err: 0, msg: '', data: auditors };
  1689. } catch (err) {
  1690. this.log(err);
  1691. ctx.body = this.ajaxErrorBody(err, '保存审批人数据失败');
  1692. }
  1693. }
  1694. }
  1695. return MaterialController;
  1696. };