contract_controller.js 70 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249
  1. 'use strict';
  2. const stdDataAddType = {
  3. withParent: 1,
  4. child: 2,
  5. next: 3,
  6. };
  7. const auditConst = require('../const/audit');
  8. const shenpiConst = require('../const/sp_shenpi');
  9. const contractConst = require('../const/contract');
  10. const moment = require('moment');
  11. const sendToWormhole = require('stream-wormhole');
  12. const fs = require('fs');
  13. const path = require('path');
  14. const AiDify = require('../lib/ai_dify');
  15. module.exports = app => {
  16. class ContractController extends app.BaseController {
  17. /**
  18. * 构造函数
  19. *
  20. * @param {Object} ctx - egg全局变量
  21. * @return {void}
  22. */
  23. constructor(ctx) {
  24. super(ctx);
  25. ctx.showProject = true;
  26. // ctx.showTitle = true;
  27. }
  28. /**
  29. * 项目合同列表页
  30. *
  31. * @param {Object} ctx - egg全局页面
  32. * @return {void}
  33. */
  34. async index(ctx) {
  35. try {
  36. if (!ctx.subProject.page_show.openContract) {
  37. throw '该功能已关闭或无法查看';
  38. }
  39. const renderData = {
  40. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.contract.index),
  41. auditConst,
  42. isTender: false,
  43. };
  44. // renderData.budgetStd = await ctx.service.budgetStd.getDataByProjectId(ctx.session.sessionProject.id);
  45. renderData.projectList = await ctx.service.subProject.getSubProjectByContract(ctx.session.sessionProject.id, ctx.session.sessionUser.accountId, ctx.session.sessionUser.is_admin);
  46. for (const t of renderData.projectList) {
  47. if (!t.is_folder) {
  48. const expensesList = await ctx.service.contract.getListByUsers({ spid: t.id, contract_type: contractConst.type.expenses }, ctx.session.sessionUser);
  49. t.expenses_count = expensesList.length;
  50. t.expenses_total_price = expensesList.reduce((total, item) => ctx.helper.add(total, item.total_price), 0);
  51. t.expenses_yf_price = expensesList.reduce((total, item) => ctx.helper.add(total, item.yf_price), 0);
  52. const incomeList = await ctx.service.contract.getListByUsers({ spid: t.id, contract_type: contractConst.type.income }, ctx.session.sessionUser);
  53. t.income_count = incomeList.length;
  54. t.income_total_price = incomeList.reduce((total, item) => ctx.helper.add(total, item.total_price), 0);
  55. t.income_yf_price = incomeList.reduce((total, item) => ctx.helper.add(total, item.yf_price), 0);
  56. }
  57. }
  58. const accountList = await ctx.service.projectAccount.getAllSubProjectAccount(ctx.subProject);
  59. renderData.accountList = accountList;
  60. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: ctx.session.sessionProject.id } });
  61. renderData.accountGroup = unitList.map(item => {
  62. const groupList = accountList.filter(item1 => item1.company === item.name);
  63. return { groupName: item.name, groupList };
  64. }).filter(x => { return x.groupList.length > 0; });
  65. // renderData.permissionConst = ctx.service.subProjPermission.PermissionConst;
  66. renderData.categoryData = await this.ctx.service.category.getAllCategory(ctx.subProject);
  67. renderData.companys = await this.ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: ctx.session.sessionProject.id } });
  68. // renderData.templates = await this.ctx.service.filingTemplateList.getAllTemplate(ctx.session.sessionProject.id);
  69. await this.layout('contract/index.ejs', renderData, 'contract/modal.ejs');
  70. } catch (err) {
  71. ctx.log(err);
  72. ctx.session.postError = err.toString();
  73. ctx.redirect(this.menu.menu.dashboard.url);
  74. }
  75. }
  76. /**
  77. * 标段合同列表页
  78. *
  79. * @param {Object} ctx - egg全局页面
  80. * @return {void}
  81. */
  82. async tender(ctx) {
  83. try {
  84. if (!ctx.subProject.page_show.openTenderContract) {
  85. throw '该功能已关闭或无法查看';
  86. }
  87. // 获取用户新建标段权利
  88. const accountInfo = await this.ctx.service.projectAccount.getDataById(ctx.session.sessionUser.accountId);
  89. const userPermission = accountInfo !== undefined && accountInfo.permission !== ''
  90. ? JSON.parse(accountInfo.permission) : null;
  91. let tenderList = await ctx.service.tender.getContractList('', userPermission, ctx.session.sessionUser.is_admin);
  92. const projectList = await ctx.service.subProject.getSubProjectByTender(ctx.session.sessionProject.id, tenderList);
  93. const removeTidList = [];
  94. for (const t of tenderList) {
  95. const spInfo = ctx.helper._.find(projectList, { id: t.spid });
  96. if (!spInfo) {
  97. removeTidList.push(t.id);
  98. continue;
  99. }
  100. spInfo.child_order = spInfo.child_order ? spInfo.child_order : 0;
  101. spInfo.is_folder = 1;
  102. t.tree_pid = spInfo.id;
  103. t.tree_level = spInfo.tree_level + 1;
  104. t.tree_order = spInfo.child_order + 1;
  105. spInfo.child_order++;
  106. const expensesList = await ctx.service.contract.getListByUsers({ tid: t.id, contract_type: contractConst.type.expenses }, ctx.session.sessionUser);
  107. t.expenses_count = expensesList.length;
  108. t.expenses_total_price = expensesList.reduce((total, item) => ctx.helper.add(total, item.total_price), 0);
  109. t.expenses_yf_price = expensesList.reduce((total, item) => ctx.helper.add(total, item.yf_price), 0);
  110. const incomeList = await ctx.service.contract.getListByUsers({ tid: t.id, contract_type: contractConst.type.income }, ctx.session.sessionUser);
  111. t.income_count = incomeList.length;
  112. t.income_total_price = incomeList.reduce((total, item) => ctx.helper.add(total, item.total_price), 0);
  113. t.income_yf_price = incomeList.reduce((total, item) => ctx.helper.add(total, item.yf_price), 0);
  114. }
  115. if (removeTidList.length > 0) {
  116. tenderList = tenderList.filter(item => !removeTidList.includes(item.id));
  117. }
  118. const categoryData = await ctx.service.category.getAllCategory(ctx.subProject);
  119. const renderData = {
  120. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.contract.tender),
  121. // jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.contract.index),
  122. auditConst,
  123. tenderList,
  124. projectList: projectList.concat(tenderList),
  125. categoryData,
  126. isTender: true,
  127. selfCategoryLevel: accountInfo ? accountInfo.self_category_level : '',
  128. // selfCategoryLevel: '',
  129. pid: ctx.session.sessionProject.id,
  130. uid: ctx.session.sessionUser.accountId,
  131. };
  132. if (ctx.session.sessionUser.is_admin) {
  133. const projectId = ctx.session.sessionProject.id;
  134. // 获取所有项目参与者
  135. const accountList = await ctx.service.projectAccount.getAllSubProjectAccount(ctx.subProject);
  136. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: projectId } });
  137. const accountGroupList = unitList.map(item => {
  138. const groupList = accountList.filter(item1 => item1.company === item.name);
  139. return { groupName: item.name, groupList };
  140. }).filter(x => { return x.groupList.length > 0; });
  141. renderData.accountList = accountList;
  142. renderData.accountGroup = accountGroupList;
  143. }
  144. await this.layout('contract/tender.ejs', renderData, 'contract/modal.ejs');
  145. // await this.layout('contract/index.ejs', renderData, 'contract/modal.ejs');
  146. } catch (err) {
  147. ctx.log(err);
  148. ctx.session.postError = err.toString();
  149. ctx.redirect(`/sp/${ctx.subProject.id}/dashboard`);
  150. }
  151. }
  152. async auditSave(ctx) {
  153. try {
  154. if (ctx.session.sessionUser.is_admin === 0) throw '没有设置权限';
  155. const responseData = {
  156. err: 0, msg: '', data: null,
  157. };
  158. const data = JSON.parse(ctx.request.body.data);
  159. if (!data.type) {
  160. throw '提交数据错误';
  161. }
  162. const info = ctx.contract;
  163. const options = ctx.contractOptions;
  164. let uids;
  165. let result = false;
  166. let auditList = [];
  167. switch (data.type) {
  168. case 'check':
  169. await ctx.service.contractTree.insertTree(options, info);
  170. // 新建合同信息
  171. break;
  172. case 'add-audit':
  173. // 判断用户是单个还是数组
  174. uids = data.id instanceof Array ? data.id : [data.id];
  175. // 判断该用户的组是否已加入到表中,已加入则提示无需添加
  176. auditList = await ctx.service.contractAudit.getList(options);
  177. const addAidList = ctx.helper._.difference(uids, ctx.helper._.map(auditList, 'uid'));
  178. if (addAidList.length === 0) {
  179. throw '用户已存在成员管理中,无需重复添加';
  180. }
  181. const accountList = await ctx.service.projectAccount.getAllDataByCondition({ where: { id: addAidList } });
  182. await ctx.service.contractAudit.saveAudits(options, accountList);
  183. responseData.data = await ctx.service.contractAudit.getList(options);
  184. break;
  185. case 'del-audit':
  186. uids = data.id instanceof Array ? data.id : [data.id];
  187. const cloneOptions = ctx.helper._.cloneDeep(options);
  188. cloneOptions.uid = uids;
  189. auditList = options.spid ? await ctx.service.subProjPermission.getContractAuditList(options.spid, uids) : await ctx.service.contractAudit.getAllDataByCondition({ where: cloneOptions });
  190. if (auditList.length !== uids.length) {
  191. throw '该用户已不存在成员管理中,移除失败';
  192. }
  193. await ctx.service.contractAudit.delAudit(options, ctx.helper._.map(auditList, 'id'));
  194. responseData.data = await ctx.service.contractAudit.getList(options);
  195. break;
  196. case 'save-permission':
  197. result = await ctx.service.contractAudit.updatePermission(options, data.updateData);
  198. if (!result) {
  199. throw '修改权限失败';
  200. }
  201. break;
  202. case 'list':
  203. responseData.data = await ctx.service.contractAudit.getList(options);
  204. break;
  205. case 'get-contract-type':
  206. const commonJson = ctx.subProject.common_json ? JSON.parse(ctx.subProject.common_json) : null;
  207. responseData.data = commonJson && commonJson[(data.is_tender ? 'tender_' : '') + 'contract_type'] ? commonJson[(data.is_tender ? 'tender_' : '') + 'contract_type'] : [];
  208. break;
  209. case 'set-contract-type':
  210. result = await ctx.service.subProject.saveCommonJsons(ctx.subProject.id, ['contract_type', 'tender_contract_type'], data.contract_type);
  211. break;
  212. case 'get-contract-used':
  213. const commonJson2 = ctx.subProject.common_json ? JSON.parse(ctx.subProject.common_json) : null;
  214. responseData.data = commonJson2 && commonJson2[(data.is_tender ? 'tender_' : '') + 'contract_used'] ? commonJson2[(data.is_tender ? 'tender_' : '') + 'contract_used'] : [];
  215. break;
  216. case 'set-contract-used':
  217. result = await ctx.service.subProject.saveCommonJsons(ctx.subProject.id, ['contract_used', 'tender_contract_used'], data.contract_used);
  218. break;
  219. default: throw '参数有误';
  220. }
  221. ctx.body = responseData;
  222. } catch (err) {
  223. this.log(err);
  224. ctx.body = { err: 1, msg: err.toString(), data: null };
  225. }
  226. }
  227. async panel(ctx) {
  228. try {
  229. const whiteList = ctx.app.config.multipart.whitelist;
  230. const contractOptions = ctx.helper._.cloneDeep(ctx.contractOptions);
  231. contractOptions.contract_type = ctx.contract_type;
  232. const contractTreeAudits = await ctx.service.contractTreeAudit.getAllDataByCondition({ where: contractOptions });
  233. const expensesOptions = ctx.helper._.cloneDeep(ctx.contractOptions);
  234. expensesOptions.contract_type = contractConst.type.expenses;
  235. const expensesList = await ctx.service.contract.getListByUsers(expensesOptions, ctx.session.sessionUser);
  236. const expensesPayList = expensesList.length > 0 ? await ctx.service.contractPay.getAllDataByCondition({ where: { cid: ctx.helper._.map(expensesList, 'id') } }) : [];
  237. const expenses_total_price = expensesList.reduce((total, item) => ctx.helper.add(total, item.total_price), 0);
  238. const expenses_yf_price = expensesList.reduce((total, item) => ctx.helper.add(total, item.yf_price), 0);
  239. const incomeOptions = ctx.helper._.cloneDeep(ctx.contractOptions);
  240. incomeOptions.contract_type = contractConst.type.income;
  241. const incomeList = await ctx.service.contract.getListByUsers(incomeOptions, ctx.session.sessionUser);
  242. const incomePayList = incomeList.length > 0 ? await ctx.service.contractPay.getAllDataByCondition({ where: { cid: ctx.helper._.map(incomeList, 'id') } }) : [];
  243. const income_total_price = incomeList.reduce((total, item) => ctx.helper.add(total, item.total_price), 0);
  244. const income_yf_price = incomeList.reduce((total, item) => ctx.helper.add(total, item.yf_price), 0);
  245. const prices = {
  246. expenses_total_price,
  247. expenses_yf_price,
  248. expenses_rate: ctx.helper.div(expenses_yf_price, expenses_total_price) * 100,
  249. income_total_price,
  250. income_yf_price,
  251. income_rate: ctx.helper.div(income_yf_price, income_total_price) * 100,
  252. };
  253. const renderData = {
  254. contractTreeAudits,
  255. audit_permission: ctx.contract_audit_permission,
  256. preUrl: `/sp/${ctx.subProject.id}` + (ctx.contractOptions.tid ? '/contract/tender' : '/contract'),
  257. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.contract.panel),
  258. contractConst,
  259. prices,
  260. expensesList,
  261. incomeList,
  262. expensesPayList,
  263. incomePayList,
  264. thisUrl: `/sp/${ctx.subProject.id}` + (ctx.contract_tender ? `/contract/tender/${ctx.contract.id}/detail` : '/contract/detail'),
  265. is_setting: false,
  266. };
  267. await this.layout('contract/panel.ejs', renderData, 'contract/setting_modal.ejs');
  268. } catch (err) {
  269. ctx.log(err);
  270. ctx.session.postError = err.toString();
  271. ctx.redirect(`/sp/${ctx.subProject.id}` + (ctx.contractOptions.spid ? '/contract/detail' : '/contract/tender'));
  272. }
  273. }
  274. async detail(ctx) {
  275. try {
  276. const whiteList = ctx.app.config.multipart.whitelist;
  277. const contractOptions = ctx.helper._.cloneDeep(ctx.contractOptions);
  278. contractOptions.contract_type = ctx.contract_type;
  279. const contractTreeAudits = await ctx.service.contractTreeAudit.getAllDataByCondition({ where: contractOptions });
  280. const [stdBills, stdChapters] = ctx.contract_tender ? await this.ctx.service.valuation.getValuationStdList(
  281. ctx.contract.valuation, ctx.contract.measure_type) : await ctx.service.budgetStd.getStdList(ctx.subProject.std_id, 'yu');
  282. const commonJson = ctx.subProject.common_json ? JSON.parse(ctx.subProject.common_json) : null;
  283. const types = commonJson && commonJson[(ctx.contract_tender ? 'tender_' : '') + 'contract_type'] ? commonJson[(ctx.contract_tender ? 'tender_' : '') + 'contract_type'] : [];
  284. const used = commonJson && commonJson[(ctx.contract_tender ? 'tender_' : '') + 'contract_used'] ? commonJson[(ctx.contract_tender ? 'tender_' : '') + 'contract_used'] : [];
  285. const shenpi_status = ctx.contract_tender ? ctx.subProject.page_show.openContractTenderShenpi : ctx.subProject.page_show.openContractSubProjectShenpi;
  286. const pay_shenpi_status = ctx.contract_tender ? ctx.subProject.page_show.openContractPayTenderShenpi : ctx.subProject.page_show.openContractPaySubProjectShenpi;
  287. const renderData = {
  288. contractTreeAudits,
  289. audit_permission: ctx.contract_audit_permission,
  290. preUrl: `/sp/${ctx.subProject.id}` + (ctx.contractOptions.tid ? '/contract/tender' : '/contract'),
  291. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.contract.detail),
  292. contract_type: ctx.contract_type,
  293. contractConst,
  294. whiteList,
  295. types,
  296. used,
  297. thisUrl: `/sp/${ctx.subProject.id}` + (ctx.contract_tender ? `/contract/tender/${ctx.contract.id}/detail` : '/contract/detail'),
  298. stdChapters,
  299. is_setting: false,
  300. shenpi_status,
  301. pay_shenpi_status,
  302. auditConst: auditConst.contract,
  303. shenpiConst,
  304. auditType: auditConst.auditType,
  305. };
  306. if (ctx.contract_tender) {
  307. const tenderInfo = await ctx.service.tenderInfo.getTenderInfo(ctx.contract.id);
  308. if (tenderInfo.shenpi.contract === shenpiConst.sp_status.gdspl) {
  309. renderData.spGroupList = await ctx.service.shenpiGroup.getGroupListByChangeType(ctx.contract.id, shenpiConst.sp_type.contract, 'contract');
  310. renderData.paySpGroupList = await ctx.service.shenpiGroup.getGroupListByChangeType(ctx.contract.id, shenpiConst.sp_type.contract, contractConst.typeMap[ctx.contract_type]);
  311. }
  312. renderData.shenpi = tenderInfo.shenpi;
  313. } else {
  314. if (ctx.subProject.shenpi.contract === shenpiConst.sp_status.gdspl) {
  315. // 获取固定审批流列表
  316. renderData.spGroupList = await ctx.service.shenpiGroup.getGroupListByChangeType(ctx.subProject.id, shenpiConst.sp_type.contract, 'contract');
  317. renderData.paySpGroupList = await ctx.service.shenpiGroup.getGroupListByChangeType(ctx.subProject.id, shenpiConst.sp_type.contract, contractConst.typeMap[ctx.contract_type]);
  318. }
  319. renderData.shenpi = ctx.subProject.shenpi;
  320. }
  321. const accountList = await ctx.service.projectAccount.getAllSubProjectAccount(ctx.subProject);
  322. renderData.accountList = accountList;
  323. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: ctx.session.sessionProject.id } });
  324. renderData.accountGroup = unitList.map(item => {
  325. const groupList = accountList.filter(item1 => item1.company === item.name);
  326. return { groupName: item.name, groupList };
  327. }).filter(x => { return x.groupList.length > 0; });
  328. const contractAttributeSet = commonJson && commonJson.contract_attribute ? commonJson.contract_attribute : contractConst.attributeSet;
  329. const attributeSet = ctx.service.contractColSet.analysisColSetWithDefine(contractConst.attributeSet, contractAttributeSet, contractConst.defaultAttributeSet);
  330. renderData.attributeSet = ctx.helper._.filter(attributeSet, { show: 1 });
  331. const detailColumnSet = contractConst.detailColumnSet.filter(item => {
  332. return !item.contractTypes || item.contractTypes.indexOf(ctx.contract_type) >= 0;
  333. }).map(item => {
  334. const result = Object.assign({ source: 'detail' }, item);
  335. if (item.field === 'pay_price') {
  336. result.name = ctx.contract_type === contractConst.type.income ? '累计回款(P)' : '累计付款(P)';
  337. } else if (item.field === 'df_price') {
  338. result.name = ctx.contract_type === contractConst.type.income ? '待回款' : '待支付';
  339. }
  340. return result;
  341. });
  342. const attributeColumnSet = renderData.attributeSet.map(item => {
  343. return Object.assign({}, item, {
  344. name: item.alias || item.name,
  345. source: 'attribute',
  346. fixed: ['alias'],
  347. removable: true,
  348. });
  349. });
  350. const contractColumnDefine = contractConst.colSet[ctx.contract_type]
  351. .concat(detailColumnSet, attributeColumnSet);
  352. const contractColSet = await ctx.service.contractColSet.getContractColSet(ctx.subProject.id, ctx.contractOptions.tid, ctx.contract_type);
  353. renderData.colSet = ctx.service.contractColSet.analysisColSetWithDefine(
  354. contractColumnDefine,
  355. contractColSet.info,
  356. contractConst.defaultColSet[ctx.contract_type]
  357. );
  358. renderData.contractColumnOptions = {
  359. detail: contractConst.colSet[ctx.contract_type]
  360. .filter(item => { return item.removable; })
  361. .map(item => { return Object.assign({ source: 'detail' }, item); })
  362. .concat(detailColumnSet),
  363. attribute: attributeColumnSet,
  364. };
  365. if (ctx.contractOptions.tid) {
  366. const tenders = await ctx.service.tender.getAllDataByCondition({
  367. where: { spid: ctx.subProject.id },
  368. columns: ['id', 'name'],
  369. });
  370. renderData.contractColCopyScope = 'tender';
  371. renderData.contractColCopyTargets = [{
  372. id: 'sub-project-root', name: ctx.subProject.name, tree_level: 1, is_folder: true,
  373. }].concat(tenders.filter(item => {
  374. return Number(item.id) !== Number(ctx.contractOptions.tid);
  375. }).map(item => {
  376. return { id: item.id, name: item.name, tree_level: 2, is_folder: false };
  377. }));
  378. } else {
  379. const subProjects = await ctx.service.subProject.getSubProjectTreeNodes(
  380. ctx.session.sessionProject.id,
  381. ctx.session.sessionUser.accountId,
  382. true
  383. );
  384. renderData.contractColCopyScope = 'project';
  385. renderData.contractColCopyTargets = subProjects.map(item => {
  386. return Object.assign({}, item, {
  387. current: String(item.id) === String(ctx.subProject.id),
  388. });
  389. });
  390. }
  391. await this.layout('contract/detail.ejs', renderData, 'contract/detail_modal.ejs');
  392. } catch (err) {
  393. ctx.log(err);
  394. ctx.session.postError = err.toString();
  395. ctx.redirect(`/sp/${ctx.subProject.id}` + (ctx.contractOptions.spid ? '/contract/detail' : '/contract/tender'));
  396. }
  397. }
  398. /**
  399. * 保存列设置
  400. * @param ctx
  401. * @return {Promise<void>}
  402. */
  403. async colSet(ctx) {
  404. try {
  405. const colType = ctx.request.body.col_type;
  406. const colSet = JSON.parse(ctx.request.body.col_set);
  407. const contractType = ctx.request.body.type;
  408. await ctx.service.contractColSet.setContractColSet(ctx.subProject.id, ctx.contractOptions.tid, contractType, colType, colSet);
  409. ctx.redirect(ctx.request.header.referer);
  410. } catch (err) {
  411. ctx.log(err);
  412. ctx.redirect(ctx.request.header.referer);
  413. }
  414. }
  415. async copyColSet(ctx) {
  416. try {
  417. if (!ctx.session.sessionUser.is_admin) throw '无权进行列设置';
  418. const data = JSON.parse(ctx.request.body.data);
  419. const contractType = Number(data.type);
  420. if ([contractConst.type.expenses, contractConst.type.income].indexOf(contractType) < 0) throw '合同类型错误';
  421. if (!Array.isArray(data.col_set) || !Array.isArray(data.target_ids)) throw '列设置参数错误';
  422. const targetIds = Array.from(new Set(data.target_ids.map(String)));
  423. if (!targetIds.length) throw '请选择需要设置的目标';
  424. let targets = [];
  425. if (ctx.contractOptions.tid) {
  426. const tenders = await ctx.service.tender.getAllDataByCondition({
  427. where: { spid: ctx.subProject.id },
  428. columns: ['id'],
  429. });
  430. const validIds = new Set(tenders.map(item => String(item.id)));
  431. targets = targetIds.filter(id => validIds.has(id) && id !== String(ctx.contractOptions.tid))
  432. .map(id => { return { spid: ctx.subProject.id, tid: Number(id) }; });
  433. } else {
  434. const subProjects = await ctx.service.subProject.getSubProject(
  435. ctx.session.sessionProject.id,
  436. ctx.session.sessionUser.accountId,
  437. true
  438. );
  439. const validIds = new Set(subProjects.filter(item => !item.is_folder).map(item => String(item.id)));
  440. targets = targetIds.filter(id => validIds.has(id) && id !== String(ctx.subProject.id))
  441. .map(id => { return { spid: id, tid: null }; });
  442. }
  443. if (targets.length !== targetIds.length) throw '选择的目标不存在或不属于当前范围';
  444. await ctx.service.contractColSet.copyContractColSet(targets, contractType, 'info', data.col_set);
  445. ctx.body = { err: 0, msg: '列设置复制成功', data: { count: targets.length } };
  446. } catch (err) {
  447. ctx.log(err);
  448. ctx.body = this.ajaxErrorBody(err, '复制列设置失败');
  449. }
  450. }
  451. async loadDetail(ctx) {
  452. try {
  453. const responseData = {
  454. err: 0, msg: '', data: {},
  455. };
  456. const contractOptions = ctx.helper._.cloneDeep(ctx.contractOptions);
  457. contractOptions.contract_type = ctx.contract_type;
  458. // const data = JSON.parse(ctx.request.body.data);
  459. // ctx.contractOptions.contract_type = ctx.contract_type;
  460. responseData.data.contractTree = await ctx.service.contractTree.getAllDataByCondition({ where: contractOptions });
  461. // 获取权限并展示对应合同
  462. responseData.data.contractList = await ctx.service.contract.getListByUsers(contractOptions, ctx.session.sessionUser);
  463. // responseData.data.contractList = await ctx.service.contract.getAllDataByCondition({ where: contractOptions });
  464. // const userOptions = ctx.helper._.cloneDeep(ctx.contractOptions);
  465. // // userOptions.uid = ctx.session.sessionUser.id;
  466. // const permissionEdit = ctx.session.sessionUser.is_admin ? true : await ctx.service.contractAudit.getUserPermissionEdit(userOptions);
  467. // responseData.data.auditContractTreePermission = permissionEdit ? [] : await ctx.service.contractTreeAudit.getAllDataByCondition({ where: contractOptions });
  468. // responseData.data.contractAttList = await ctx.service.contractAtt.getAllDataByCondition({ where: ctx.contractOptions });
  469. if (ctx.session.sessionUser.is_admin) {
  470. const contractAudits = await ctx.service.contractAudit.getList(ctx.contractOptions);
  471. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: ctx.session.sessionProject.id } });
  472. const accountGroup = unitList.map(item => {
  473. const groupList = contractAudits.filter(item1 => item1.company === item.name);
  474. return { groupName: item.name, groupList };
  475. }).filter(x => { return x.groupList.length > 0; });
  476. responseData.data.contractAudits = contractAudits;
  477. responseData.data.accountGroup = ctx.helper._.filter(accountGroup, function(item) {
  478. return item.groupList.length > 0;
  479. });
  480. }
  481. ctx.body = responseData;
  482. } catch (err) {
  483. this.log(err);
  484. ctx.body = { err: 1, msg: err.toString(), data: null };
  485. }
  486. }
  487. /**
  488. * 审批及上报和审批人员增删改,切换审批组等
  489. * @param ctx
  490. * @return {Promise<void>}
  491. */
  492. async checkAudit(ctx) {
  493. try {
  494. const data = JSON.parse(ctx.request.body.data);
  495. if (!data.postType || !data.id || !data.type) throw '数据错误';
  496. const responseData = {
  497. err: 0, msg: '', data: {},
  498. };
  499. const contract = await this._getContractByType(ctx, data);
  500. if (!contract) {
  501. throw '未找到合同相关数据';
  502. }
  503. let tip = '';
  504. // 判断功能是否已关闭
  505. const shenpi_status = ctx.contract_tender ? ctx.subProject.page_show.openContractTenderShenpi : ctx.subProject.page_show.openContractSubProjectShenpi;
  506. const pay_shenpi_status = ctx.contract_tender ? ctx.subProject.page_show.openContractPayTenderShenpi : ctx.subProject.page_show.openContractPaySubProjectShenpi;
  507. switch (data.type) {
  508. case 'contract':
  509. if (!shenpi_status) {
  510. throw '合同审批功能已关闭, 无法进行审批操作, 请刷新页面';
  511. }
  512. break;
  513. case 'pay':
  514. if (!pay_shenpi_status) {
  515. throw '合同' + tip + '审批功能已关闭, 无法进行审批操作, 请刷新页面';
  516. }
  517. tip = contractConst.typeName[contract.contract_type];
  518. break;
  519. case 'supplement':
  520. if (!shenpi_status) {
  521. throw '合同审批功能已关闭, 无法进行审批操作, 请刷新页面';
  522. }
  523. break;
  524. default: throw '数据错误';
  525. }
  526. let shenpi = '';
  527. if (ctx.contract_tender) {
  528. const tenderInfo = await ctx.service.tenderInfo.getTenderInfo(ctx.contract.id);
  529. shenpi = tenderInfo ? tenderInfo.shenpi : '';
  530. } else {
  531. shenpi = ctx.subProject.shenpi;
  532. }
  533. await ctx.service.contractSpAudit.loadUser(contract, data.type);
  534. await ctx.service.contractSpAudit.loadAuditViewData(contract, data.type);
  535. switch (data.postType) {
  536. case 'start':
  537. if (contract.status !== auditConst.contract.status.uncheck && contract.status !== auditConst.contract.status.checkNo) {
  538. throw '该合同' + tip + '当前无法上报';
  539. }
  540. await ctx.service.contractSpAudit.start(ctx.contractOptions, shenpi, contract, data.type, contract.times);
  541. break;
  542. case 'check':
  543. if (contract.status !== auditConst.contract.status.checking && contract.status !== auditConst.contract.status.checkNoPre) {
  544. throw '当前合同' + tip + '数据有误';
  545. }
  546. if (contract.curAuditorIds.length === 0 || contract.curAuditorIds.indexOf(ctx.session.sessionUser.accountId) === -1) {
  547. throw '您无权进行该操作';
  548. }
  549. const checkData = {
  550. checkType: parseInt(data.checkType),
  551. opinion: data.opinion,
  552. };
  553. if (!checkData.checkType || isNaN(checkData.checkType)) {
  554. throw '提交数据错误';
  555. }
  556. await ctx.service.contractSpAudit.check(contract, data.type, checkData);
  557. break;
  558. case 'add-audit':
  559. if (shenpi.contract === shenpiConst.sp_status.gdspl) {
  560. throw '固定审批流程不允许添加人员,请刷新页面';
  561. }
  562. const add_id = this.app._.toInteger(data.auditorId);
  563. if (isNaN(add_id) || add_id <= 0) {
  564. throw '参数错误';
  565. }
  566. // 检查权限等
  567. if (!(contract.uid === ctx.session.sessionUser.accountId || ctx.contract_audit_permission.permission_edit_contract)) {
  568. throw '您无权添加审核人';
  569. }
  570. if (contract.status !== auditConst.contract.status.uncheck && contract.status !== auditConst.contract.status.checkNo) {
  571. throw '当前不允许添加审核人';
  572. }
  573. const auditorList = await ctx.service.contractSpAudit.getAuditors(contract, data.type, contract.times, 'asc', true);
  574. // 检查审核人是否已存在
  575. const exist = this.app._.find(auditorList, { aid: add_id });
  576. if (exist) {
  577. throw '该审核人已存在,请勿重复添加';
  578. }
  579. const shenpiCondition = ctx.helper._.assign({ sp_type: shenpiConst.sp_type.contract, sp_status: shenpiConst.sp_status.gdzs }, ctx.contractOptions);
  580. const shenpiInfo = await ctx.service.shenpiAudit.getDataByCondition(shenpiCondition);
  581. const is_gdzs = shenpiInfo && shenpi.contract === shenpiConst.sp_status.gdzs ? 1 : 0;
  582. const add_result = await ctx.service.contractSpAudit.addAuditor(ctx.contractOptions, contract, data.type, add_id, contract.times, is_gdzs);
  583. if (!add_result) {
  584. throw '添加审核人失败';
  585. }
  586. break;
  587. case 'del-audit':
  588. if (shenpi.contract === shenpiConst.sp_status.gdspl) {
  589. throw '固定审批流程不允许删除人员,请刷新页面';
  590. }
  591. const del_id = data.auditorId instanceof Number ? data.auditorId : this.app._.toNumber(data.auditorId);
  592. if (isNaN(del_id) || del_id <= 0) {
  593. throw '参数错误';
  594. }
  595. // 检查权限等
  596. if (!(contract.uid === ctx.session.sessionUser.accountId || ctx.contract_audit_permission.permission_edit_contract)) {
  597. throw '您无权移除审核人';
  598. }
  599. if (contract.status !== auditConst.contract.status.uncheck && contract.status !== auditConst.contract.status.checkNo) {
  600. throw '当前不允许移除审核人';
  601. }
  602. const del_result = await ctx.service.contractSpAudit.deleteAuditor(contract, data.type, del_id, contract.times);
  603. if (!del_result) {
  604. throw '移除审核人失败';
  605. }
  606. break;
  607. case 'change-sp':
  608. if (shenpi.contract !== shenpiConst.sp_status.gdspl) {
  609. throw '非固定审批流程不允许切换审批组,请刷新页面';
  610. }
  611. if (contract.status !== auditConst.contract.status.uncheck && contract.status !== auditConst.contract.status.checkNo) {
  612. throw '当前状态不允许切换审批组';
  613. }
  614. const chagne_result = await ctx.service.contractSpAudit.changeSpGroup(contract, data.type, data.sp_group);
  615. if (!chagne_result) {
  616. throw '切换审批组失败';
  617. }
  618. break;
  619. default:
  620. throw '参数错误';
  621. }
  622. const newContract = await this._getContractByType(ctx, data);
  623. await ctx.service.contractSpAudit.loadUser(newContract, data.type);
  624. await ctx.service.contractSpAudit.loadAuditViewData(newContract, data.type);
  625. responseData.data = newContract;
  626. ctx.body = responseData;
  627. } catch (err) {
  628. console.log(err);
  629. this.log(err);
  630. ctx.body = { err: 1, msg: err.toString(), data: null };
  631. }
  632. }
  633. async _getContractByType(ctx, data) {
  634. let contract = null;
  635. switch (data.type) {
  636. case 'contract':
  637. contract = await ctx.service.contract.getDataById(data.id);
  638. break;
  639. case 'pay':
  640. contract = await ctx.service.contractPay.getDataById(data.id);
  641. break;
  642. case 'supplement':
  643. contract = await ctx.service.contractSupplement.getDataById(data.id);
  644. break;
  645. default: throw '数据错误';
  646. }
  647. return contract;
  648. }
  649. async updateBills(ctx) {
  650. try {
  651. const data = JSON.parse(ctx.request.body.data);
  652. if (!data.postType || !data.postData) throw '数据错误';
  653. const responseData = { err: 0, msg: '', data: {} };
  654. const options = ctx.helper._.cloneDeep(ctx.contractOptions);
  655. options.contract_type = ctx.contract_type;
  656. switch (data.postType) {
  657. case 'add':
  658. case 'add-child':
  659. case 'delete':
  660. case 'up-move':
  661. case 'down-move':
  662. case 'up-level':
  663. case 'down-level':
  664. responseData.data = await this._billsBase(ctx, data.postType, data.postData, options);
  665. break;
  666. case 'update':
  667. responseData.data = await ctx.service.contractTree.updateCalc(options, data.postData, data.updateAll || false);
  668. break;
  669. case 'update-contract':
  670. responseData.data = await ctx.service.contract.updateCalc(options, data.postData);
  671. break;
  672. case 'paste-block':
  673. responseData.data = await this._pasteBlock(ctx, data.postData, options);
  674. break;
  675. case 'add-std':
  676. responseData.data = await this._addStd(ctx, data.postData, options);
  677. break;
  678. case 'add-contract':
  679. responseData.data = await ctx.service.contract.add(options, data.postData.select, data.postData.contract);
  680. break;
  681. case 'add-tree-audit':
  682. responseData.data = await ctx.service.contractTreeAudit.add(options, data.postData.select, data.postData.auditId);
  683. break;
  684. case 'del-tree-audit':
  685. responseData.data = await ctx.service.contractTreeAudit.dels(options, data.postData.select, data.postData.auditIds);
  686. break;
  687. case 'get-contract':
  688. const contract = await ctx.service.contract.getDataById(data.postData);
  689. const shenpi_status = ctx.contract_tender ? ctx.subProject.page_show.openContractTenderShenpi : ctx.subProject.page_show.openContractSubProjectShenpi;
  690. if (shenpi_status) {
  691. await ctx.service.contractSpAudit.loadUser(contract);
  692. await ctx.service.contractSpAudit.loadAuditViewData(contract);
  693. await ctx.service.contractSpAudit.checkShenpi(contract);
  694. }
  695. responseData.data.contract = contract;
  696. responseData.data.pays = await ctx.service.contractPay.getPays(options, data.postData);
  697. responseData.data.files = await ctx.service.contractAtt.getAtt(data.postData);
  698. responseData.data.supplements = await ctx.service.contractSupplement.getSupplements(options, data.postData);
  699. break;
  700. case 'add-contract-pay':
  701. responseData.data = await ctx.service.contractPay.add(options, data.postData.select, data.postData.pay);
  702. break;
  703. case 'save-contract-pay':
  704. responseData.data = await ctx.service.contractPay.save(options, data.postData.select, data.postData.pay);
  705. break;
  706. case 'del-contract-pay':
  707. responseData.data = await ctx.service.contractPay.del(options, data.postData.select, data.postData.pay);
  708. break;
  709. case 'add-contract-supplement':
  710. responseData.data = await ctx.service.contractSupplement.add(options, data.postData.select, data.postData.supplement);
  711. break;
  712. case 'save-contract-supplement':
  713. responseData.data = await ctx.service.contractSupplement.save(options, data.postData.select, data.postData.supplement);
  714. break;
  715. case 'del-contract-supplement':
  716. responseData.data = await ctx.service.contractSupplement.del(options, data.postData.select, data.postData.supplement);
  717. break;
  718. case 'get-tenders':
  719. // 获取用户新建标段权利
  720. const accountInfo = await ctx.service.projectAccount.getDataById(ctx.session.sessionUser.accountId);
  721. const userPermission = accountInfo !== undefined && accountInfo.permission !== ''
  722. ? JSON.parse(accountInfo.permission) : null;
  723. const tenderList = await ctx.service.tender.getBuildList('', userPermission, ctx.session.sessionUser.is_admin);
  724. responseData.data.categoryData = await this.ctx.service.category.getAllCategory(ctx.subProject);
  725. responseData.data.tenders = tenderList;
  726. break;
  727. case 'get-tender-pays':
  728. responseData.data.tender = await ctx.service.tender.getDataById(data.postData.tid);
  729. if (!responseData.data.tender) {
  730. throw '关联标段不存在';
  731. }
  732. // 判断项目开没开启独立支付合同
  733. if (ctx.subProject.page_show.phasePay) {
  734. // 直接读phasePay表数据并展示
  735. responseData.data.stages = await ctx.service.phasePay.getDatasForContract(data.postData.tid);
  736. } else {
  737. // 读取期支付数据
  738. responseData.data.stages = await ctx.service.stagePay.getDatasForContract(data.postData.tid);
  739. }
  740. break;
  741. case 'add-tender-pays':
  742. responseData.data = await ctx.service.contractPay.addTenderPays(
  743. options,
  744. data.postData.select,
  745. data.postData.pays
  746. );
  747. break;
  748. default:
  749. throw '未知操作';
  750. }
  751. ctx.body = responseData;
  752. } catch (err) {
  753. console.log(err);
  754. this.log(err);
  755. ctx.body = this.ajaxErrorBody(err, '数据错误');
  756. }
  757. }
  758. async _billsBase(ctx, type, data, options) {
  759. if (isNaN(data.id) || data.id <= 0) throw '数据错误';
  760. if (type !== 'add') {
  761. if (isNaN(data.count) || data.count <= 0) data.count = 1;
  762. }
  763. switch (type) {
  764. case 'add':
  765. return await ctx.service.contractTree.addNodeBatch(options, data.id, data.count);
  766. case 'add-child':
  767. return await ctx.service.contractTree.addChildNode(options, data.id, data.count);
  768. case 'delete':
  769. return await ctx.service.contractTree.delete(options, data.id, data.count);
  770. case 'up-move':
  771. return await ctx.service.contractTree.upMoveNode(options, data.id, data.count);
  772. case 'down-move':
  773. return await ctx.service.contractTree.downMoveNode(options, data.id, data.count);
  774. case 'up-level':
  775. return await ctx.service.contractTree.upLevelNode(options, data.id, data.count);
  776. case 'down-level':
  777. return await ctx.service.contractTree.downLevelNode(options, data.id, data.count);
  778. default:
  779. throw '未知操作';
  780. }
  781. }
  782. /**
  783. * 复制粘贴整块
  784. *
  785. * @param ctx
  786. * @return {Promise<void>}
  787. */
  788. async _pasteBlock(ctx, data, options) {
  789. if ((isNaN(data.id) || data.id <= 0) ||
  790. (!data.block || data.block.length <= 0)) throw '参数错误';
  791. return await ctx.service.contractTree.pasteBlockData(options, data.id, data.block);
  792. }
  793. /**
  794. * 从标准项目表添加数据
  795. * @param ctx
  796. * @return {Promise<void>}
  797. */
  798. async _addStd(ctx, data, options) {
  799. if ((isNaN(data.id) || data.id <= 0) || !data.stdType || !data.stdNode) throw '参数错误';
  800. // todo 校验项目是否使用该库的权限
  801. if (!(ctx.session.sessionUser.is_admin || ctx.contract_audit_permission.permission_edit)) {
  802. throw '没有操作权限';
  803. }
  804. let stdLib,
  805. addType;
  806. switch (data.stdType) {
  807. case 'xmj':
  808. stdLib = ctx.service.stdXmj;
  809. addType = stdDataAddType.withParent;
  810. break;
  811. default:
  812. throw '未知标准库';
  813. }
  814. const stdData = await stdLib.getDataByDataId(data.stdLibId, data.stdNode);
  815. switch (addType) {
  816. // case stdDataAddType.child:
  817. // return await ctx.service.contractTree.addStdNodeAsChild(options, data.id, stdData);
  818. // case stdDataAddType.next:
  819. // return await ctx.service.contractTree.addStdNode(options, data.id, stdData);
  820. case stdDataAddType.withParent:
  821. return await ctx.service.contractTree.addStdNodeWithParent(options, data.id, stdData, stdLib);
  822. default:
  823. throw '未知添加方式';
  824. }
  825. }
  826. /**
  827. * 上传附件
  828. * @param {*} ctx 上下文
  829. */
  830. async uploadFile(ctx) {
  831. let stream;
  832. try {
  833. const responseData = { err: 0, msg: '', data: {} };
  834. const cid = ctx.params.cid;
  835. if (!cid) throw '参数有误';
  836. const cpid = parseInt(ctx.params.cpid);
  837. const csid = parseInt(ctx.params.csid);
  838. const parts = this.ctx.multipart({
  839. autoFields: true,
  840. });
  841. const files = [];
  842. const create_time = Date.parse(new Date()) / 1000;
  843. let idx = 0;
  844. while ((stream = await parts()) !== undefined) {
  845. if (!stream.filename) {
  846. // 如果没有传入直接返回
  847. return;
  848. }
  849. const fileInfo = path.parse(stream.filename);
  850. const headpath = ctx.contractOptions.spid ? `sp/contract/${ctx.contractOptions.spid}` : `app/public/upload/${ctx.contractOptions.tid}`;
  851. const filepath = `${headpath}/contract/${cid}${cpid ? '/pay/' + cpid : (csid ? '/supplement/' + csid : '')}/fujian_${create_time + idx.toString() + fileInfo.ext}`;
  852. // await ctx.helper.saveStreamFile(stream, path.resolve(this.app.baseDir, 'app', filepath));
  853. await ctx.app.fujianOss.put(ctx.app.config.fujianOssFolder + filepath, stream);
  854. files.push({ filepath, name: stream.filename, ext: fileInfo.ext });
  855. ++idx;
  856. stream && (await sendToWormhole(stream));
  857. }
  858. const in_time = new Date();
  859. const payload = files.map(file => {
  860. let idx;
  861. if (Array.isArray(parts.field.name)) {
  862. idx = parts.field.name.findIndex(name => name === file.name);
  863. } else {
  864. idx = 'isString';
  865. }
  866. const newFile = {
  867. spid: ctx.contractOptions.spid || null,
  868. tid: ctx.contractOptions.tid || null,
  869. contract_type: ctx.contract_type,
  870. cid,
  871. uid: ctx.session.sessionUser.accountId,
  872. filename: file.name,
  873. fileext: file.ext,
  874. filesize: ctx.helper.bytesToSize(idx === 'isString' ? parts.field.size : parts.field.size[idx]),
  875. filepath: file.filepath,
  876. upload_time: in_time,
  877. };
  878. if (cpid) {
  879. newFile.cpid = cpid;
  880. }
  881. if (csid) {
  882. newFile.csid = csid;
  883. }
  884. return newFile;
  885. });
  886. if (cpid) {
  887. // 执行文件信息写入数据库
  888. await ctx.service.contractPayAtt.saveFileMsgToDb(payload);
  889. // 将最新的当前标段的所有文件信息返回
  890. responseData.data = await ctx.service.contractPayAtt.getAtt(cpid);
  891. } else if (csid) {
  892. // 执行文件信息写入数据库
  893. await ctx.service.contractSupplementAtt.saveFileMsgToDb(payload);
  894. // 将最新的当前标段的所有文件信息返回
  895. responseData.data = await ctx.service.contractSupplementAtt.getAtt(csid);
  896. } else {
  897. // 执行文件信息写入数据库
  898. await ctx.service.contractAtt.saveFileMsgToDb(payload);
  899. // 将最新的当前标段的所有文件信息返回
  900. responseData.data = await ctx.service.contractAtt.getAtt(cid);
  901. }
  902. ctx.body = responseData;
  903. } catch (err) {
  904. stream && (await sendToWormhole(stream));
  905. this.log(err);
  906. ctx.body = { err: 1, msg: err.toString(), data: null };
  907. }
  908. }
  909. /**
  910. * 删除附件
  911. * @param {Ojbect} ctx 上下文
  912. */
  913. async deleteFile(ctx) {
  914. try {
  915. const cpid = ctx.params.cpid;
  916. const csid = ctx.params.csid;
  917. const cid = ctx.params.cid;
  918. const responseData = { err: 0, msg: '', data: {} };
  919. const data = JSON.parse(ctx.request.body.data);
  920. let fileInfo = null;
  921. if (cpid) {
  922. fileInfo = await ctx.service.contractPayAtt.getDataById(data.id);
  923. } else if (csid) {
  924. fileInfo = await ctx.service.contractSupplementAtt.getDataById(data.id);
  925. } else if (cid) {
  926. fileInfo = await ctx.service.contractAtt.getDataById(data.id);
  927. } else {
  928. throw '参数错误';
  929. }
  930. if (fileInfo || Object.keys(fileInfo).length) {
  931. // 先删除文件
  932. // await fs.unlinkSync(path.resolve(this.app.baseDir, './app', fileInfo.filepath));
  933. await ctx.app.fujianOss.delete(ctx.app.config.fujianOssFolder + fileInfo.filepath);
  934. // 再删除数据库
  935. if (cpid) {
  936. await ctx.service.contractPayAtt.delete(data.id);
  937. } else if (csid) {
  938. await ctx.service.contractSupplementAtt.delete(data.id);
  939. } else {
  940. await ctx.service.contractAtt.delete(data.id);
  941. }
  942. } else {
  943. throw '不存在该文件';
  944. }
  945. if (cpid) {
  946. responseData.data = await ctx.service.contractPayAtt.getAtt(cpid);
  947. } else if (csid) {
  948. responseData.data = await ctx.service.contractSupplementAtt.getAtt(csid);
  949. } else {
  950. responseData.data = await ctx.service.contractAtt.getAtt(cid);
  951. }
  952. ctx.body = responseData;
  953. } catch (err) {
  954. this.log(err);
  955. ctx.body = { err: 1, msg: err.toString(), data: null };
  956. }
  957. }
  958. /**
  959. * 下载附件
  960. * @param {Object} ctx - egg全局变量
  961. * @return {void}
  962. */
  963. async downloadFile(ctx) {
  964. const id = ctx.params.fid;
  965. if (id) {
  966. try {
  967. const cpid = ctx.params.cpid;
  968. const csid = ctx.params.csid;
  969. const cid = ctx.params.cid;
  970. let fileInfo = null;
  971. if (cpid) {
  972. fileInfo = await ctx.service.contractPayAtt.getDataById(id);
  973. } else if (csid) {
  974. fileInfo = await ctx.service.contractSupplementAtt.getDataById(id);
  975. } else if (cid) {
  976. fileInfo = await ctx.service.contractAtt.getDataById(id);
  977. } else {
  978. throw '参数错误';
  979. }
  980. if (fileInfo || Object.keys(fileInfo).length) {
  981. // const fileName = path.join(__dirname, '../', fileInfo.filepath);
  982. // 解决中文无法下载问题
  983. const userAgent = (ctx.request.header['user-agent'] || '').toLowerCase();
  984. let disposition = '';
  985. if (userAgent.indexOf('msie') >= 0 || userAgent.indexOf('chrome') >= 0) {
  986. disposition = 'attachment; filename=' + encodeURIComponent(fileInfo.filename);
  987. } else if (userAgent.indexOf('firefox') >= 0) {
  988. disposition = 'attachment; filename*="utf8\'\'' + encodeURIComponent(fileInfo.filename) + '"';
  989. } else {
  990. /* safari等其他非主流浏览器只能自求多福了 */
  991. disposition = 'attachment; filename=' + new Buffer(fileInfo.filename).toString('binary');
  992. }
  993. ctx.response.set({
  994. 'Content-Type': 'application/octet-stream',
  995. 'Content-Disposition': disposition,
  996. 'Content-Length': fileInfo.filesize,
  997. });
  998. // ctx.body = await fs.createReadStream(fileName);
  999. ctx.body = await ctx.helper.ossFileGet(fileInfo.filepath);
  1000. } else {
  1001. throw '不存在该文件';
  1002. }
  1003. } catch (err) {
  1004. this.log(err);
  1005. this.setMessage(err.toString(), this.messageType.ERROR);
  1006. }
  1007. }
  1008. }
  1009. async setting(ctx) {
  1010. try {
  1011. if (!ctx.subProject.page_show.openTenderContract && !ctx.subProject.page_show.openContract) {
  1012. throw '该功能已关闭或无法查看';
  1013. }
  1014. if (!ctx.session.sessionUser.is_admin) {
  1015. throw '您没有权限查看该页面';
  1016. }
  1017. // url是否包含tender
  1018. const types_from = ctx.url.indexOf('tender') > -1 ? 'tender' : 'subProject';
  1019. const commonJson = ctx.subProject.common_json ? JSON.parse(ctx.subProject.common_json) : null;
  1020. const types = commonJson && commonJson.contract_type ? commonJson.contract_type : [];
  1021. const tender_types = commonJson && commonJson.tender_contract_type ? commonJson.tender_contract_type : [];
  1022. const used = commonJson && commonJson.contract_used ? commonJson.contract_used : [];
  1023. const tender_used = commonJson && commonJson.tender_contract_used ? commonJson.tender_contract_used : [];
  1024. const renderData = {
  1025. types_from,
  1026. types,
  1027. tender_types,
  1028. used,
  1029. tender_used,
  1030. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.contract.setting),
  1031. thisUrl: `/sp/${ctx.subProject.id}/contract${types_from === 'tender' ? '/tender' : ''}/setting`,
  1032. is_setting: true,
  1033. };
  1034. const attributeSet = commonJson && commonJson.contract_attribute ? commonJson.contract_attribute : contractConst.attributeSet;
  1035. renderData.attributeSet = ctx.service.contractColSet.analysisColSetWithDefine(contractConst.attributeSet, attributeSet, contractConst.defaultAttributeSet);
  1036. await this.layout('contract/setting.ejs', renderData);
  1037. } catch (err) {
  1038. ctx.log(err);
  1039. ctx.session.postError = err.toString();
  1040. ctx.redirect(`/sp/${ctx.subProject.id}/dashboard`);
  1041. }
  1042. }
  1043. /**
  1044. * 保存功能设置相关
  1045. * @param ctx
  1046. * @return {Promise<void>}
  1047. */
  1048. async updateSetting(ctx) {
  1049. try {
  1050. const responseData = { err: 0, msg: '', data: null };
  1051. if (!ctx.subProject) throw '没有对应的项目数据';
  1052. if (ctx.session.sessionUser.is_admin === 0) throw '没有访问权限';
  1053. const data = JSON.parse(ctx.request.body.data);
  1054. if (data) ctx.request.body = data;
  1055. switch (data.type) {
  1056. case 'page_show':
  1057. this.ctx.subProject.page_show.openContractSubProjectShenpi = data.openContractSubProjectShenpi ? 1 : 0;
  1058. this.ctx.subProject.page_show.openContractPaySubProjectShenpi = data.openContractPaySubProjectShenpi ? 1 : 0;
  1059. this.ctx.subProject.page_show.openContractTenderShenpi = data.openContractTenderShenpi ? 1 : 0;
  1060. this.ctx.subProject.page_show.openContractPayTenderShenpi = data.openContractPayTenderShenpi ? 1 : 0;
  1061. const result = await ctx.service.contract.savePageShow(ctx.subProject.id, ctx.subProject.page_show);
  1062. if (!result) throw '保存数据失败';
  1063. break;
  1064. case 'attribute_set':
  1065. const result2 = await ctx.service.subProject.saveCommonJson(ctx.subProject.id, 'contract_attribute', data.attribute_set);
  1066. if (!result2) throw '保存数据失败';
  1067. responseData.data = ctx.service.contractColSet.analysisColSetWithDefine(contractConst.attributeSet, data.attribute_set, contractConst.defaultAttributeSet);
  1068. break;
  1069. default:
  1070. throw '参数有误';
  1071. }
  1072. ctx.body = responseData;
  1073. } catch (error) {
  1074. ctx.log(error);
  1075. this.ajaxErrorBody(error, '保存数据失败');
  1076. }
  1077. }
  1078. async shenpiSet(ctx) {
  1079. try {
  1080. if (!ctx.subProject) throw '没有对应的项目数据';
  1081. if (ctx.session.sessionUser.is_admin === 0) throw '没有访问权限';
  1082. // 获取所有项目参与者
  1083. const accountList = await ctx.service.projectAccount.getAllSubProjectAccount(ctx.subProject);
  1084. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: ctx.session.sessionProject.id } });
  1085. const accountGroupList = unitList.map(item => {
  1086. const groupList = accountList.filter(item1 => item1.company === item.name);
  1087. return { groupName: item.name, groupList };
  1088. }).filter(x => { return x.groupList.length > 0; });
  1089. // 获取固定审批流 or 固定终审
  1090. const spConst = ctx.helper._.cloneDeep(shenpiConst);
  1091. for (const sp of spConst.sp_lc) {
  1092. sp.status = ctx.subProject.shenpi ? ctx.subProject.shenpi[sp.code] : spConst.sp_status.sqspr;
  1093. if (sp.status === shenpiConst.sp_status.gdspl) {
  1094. sp.groupList = await ctx.service.shenpiGroup.getGroupList(ctx.subProject.id, sp.type) || [];
  1095. if (sp.groupList && sp.groupList.length > 0) {
  1096. for (const group of sp.groupList) {
  1097. if (group.change_type) group.change_type = JSON.parse(group.change_type);
  1098. group.auditGroupList = await ctx.service.shenpiAudit.getAuditGroupList(ctx.subProject.id, sp.type, sp.status, group.id);
  1099. if (group.is_select) sp.auditGroupList = group.auditGroupList;
  1100. }
  1101. } else {
  1102. sp.auditGroupList = await ctx.service.shenpiAudit.getAuditGroupList(ctx.subProject.id, sp.type, sp.status);
  1103. }
  1104. } else if (sp.status === shenpiConst.sp_status.gdzs) {
  1105. sp.audit = await ctx.service.shenpiAudit.getAudit(ctx.subProject.id, sp.type, sp.status);
  1106. }
  1107. }
  1108. const renderData = {
  1109. shenpi: spConst,
  1110. accountList,
  1111. accountGroup: accountGroupList,
  1112. auditConst,
  1113. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.contract.shenpi),
  1114. auditType: auditConst.auditType,
  1115. types_from: 'subProject',
  1116. thisUrl: `/sp/${ctx.subProject.id}/contract/setting`,
  1117. contract_type_list: shenpiConst.contract_type_list,
  1118. is_setting: true,
  1119. };
  1120. await this.layout('contract/shenpi.ejs', renderData, 'contract/shenpi_modal.ejs');
  1121. } catch (err) {
  1122. ctx.log(err);
  1123. ctx.session.postError = err.toString();
  1124. ctx.redirect(`/sp/${ctx.subProject.id}/dashboard`);
  1125. }
  1126. }
  1127. async editAndAi(ctx) {
  1128. try {
  1129. const data = JSON.parse(ctx.request.body.data);
  1130. if (!data.id || !data.fid) throw '数据错误';
  1131. const contract = await ctx.service.contract.getDataById(data.id);
  1132. if (!contract) {
  1133. throw '未找到合同相关数据';
  1134. }
  1135. const att = await ctx.service.contractAtt.getDataById(data.fid);
  1136. if (!att) {
  1137. throw '未找到合同文件';
  1138. }
  1139. att.viewpath = ctx.app.config.fujianOssPath + att.filepath;
  1140. const aiDify = new AiDify({ apiKey: ctx.difyInfo.apiKey.contract });
  1141. const transResult = await aiDify.contractTrans(att);
  1142. transResult.res = JSON.parse(transResult.res);
  1143. const responseData = {
  1144. ...transResult,
  1145. cid: contract.id,
  1146. attached: false,
  1147. };
  1148. ctx.body = { err: 0, msg: '', data: responseData };
  1149. } catch (err) {
  1150. console.log(err);
  1151. this.log(err);
  1152. ctx.body = { err: 1, msg: err.toString(), data: null };
  1153. }
  1154. }
  1155. async uploadAndAi(ctx) {
  1156. const stream = await ctx.getFileStream();
  1157. try {
  1158. const hasExistingCid = !!stream.fields.cid;
  1159. const cid = stream.fields.cid || this.ctx.app.uuid.v4();
  1160. if (!cid) throw '参数有误';
  1161. const attachToContract = stream.fields.attachToContract === 'true' || stream.fields.attachToContract === '1';
  1162. const create_time = Date.parse(new Date()) / 1000;
  1163. const parsedPath = path.parse(stream.filename);
  1164. const headpath = ctx.contractOptions.spid
  1165. ? `sp/contract/${ctx.contractOptions.spid}`
  1166. : `app/public/upload/${ctx.contractOptions.tid}`;
  1167. const filepath = `${headpath}/contract/${cid}/fujian_${create_time}${parsedPath.ext}`;
  1168. await ctx.app.fujianOss.put(ctx.app.config.fujianOssFolder + filepath, stream);
  1169. const fileInfo = { filepath, name: stream.filename, ext: parsedPath.ext };
  1170. if (stream) await sendToWormhole(stream);
  1171. if (!fileInfo) {
  1172. throw '请上传文件';
  1173. }
  1174. const newFile = {
  1175. spid: ctx.contractOptions.spid || null,
  1176. tid: ctx.contractOptions.tid || null,
  1177. contract_type: ctx.contract_type,
  1178. cid,
  1179. uid: ctx.session.sessionUser.accountId,
  1180. filename: fileInfo.name,
  1181. fileext: fileInfo.ext,
  1182. filesize: stream.fields.size,
  1183. filepath: fileInfo.filepath,
  1184. upload_time: new Date(),
  1185. };
  1186. // 写入数据库(只有这一条记录)
  1187. if (!hasExistingCid || attachToContract) {
  1188. const fileResult = await ctx.service.contractAtt.saveFileMsgToDb([newFile]);
  1189. newFile.id = fileResult.insertId;
  1190. newFile.username = ctx.session.sessionUser.name;
  1191. }
  1192. // 重新查出该cid下的附件,按filepath精确匹配出刚上传的这一份(避免拿到该cid下其他历史文件)
  1193. newFile.viewpath = ctx.app.config.fujianOssPath + newFile.filepath;
  1194. const aiDify = new AiDify({ apiKey: ctx.difyInfo.apiKey.contract });
  1195. const transResult = await aiDify.contractTrans(newFile);
  1196. transResult.res = JSON.parse(transResult.res);
  1197. // 如果不勾选"附加到合同"并且没有cid,则要删除oss文件
  1198. if (!attachToContract && hasExistingCid) {
  1199. await ctx.app.fujianOss.delete(ctx.app.config.fujianOssFolder + newFile.filepath);
  1200. }
  1201. const responseData = {
  1202. ...transResult,
  1203. cid,
  1204. attached: attachToContract,
  1205. };
  1206. if ((!hasExistingCid || attachToContract) && newFile.id) responseData.file = newFile;
  1207. ctx.body = { err: 0, msg: '', data: responseData };
  1208. } catch (err) {
  1209. stream && (await sendToWormhole(stream));
  1210. this.log(err);
  1211. ctx.body = { err: 1, msg: err.toString(), data: null };
  1212. }
  1213. }
  1214. }
  1215. return ContractController;
  1216. };