'use strict'; const accountGroup = require('../const/account_group').group; const auditConst = require('../const/audit').advance; const shenpiConst = require('../const/shenpi'); const typeConsts = require('../const/advance'); const sendToWormhole = require('stream-wormhole'); const path = require('path'); const fs = require('fs'); module.exports = app => { class advanceController extends app.BaseController { constructor(ctx) { super(ctx); const { decimal } = ctx.tender.info; this.decimal = decimal.pay ? decimal.payTp : decimal.tp; } /** * 开工预付款页面(AJAX) GET * @param {Object} ctx 全局上下文 */ async index(ctx) { const advanceType = typeConsts.typeCol.find(item => item.key === ctx.params.type); const type = advanceType.type; const advancePayTotal = ctx.tender.info.deal_param[`${advanceType.key}Advance`]; const advanceList = await ctx.service.advance.getAdvanceList(ctx.tender.id, type, this.decimal, advancePayTotal); const latestOrder = await ctx.service.advance.getLastestAdvance(ctx.tender.id, type, true); const progress = await ctx.service.advance.calcProgress(latestOrder, advancePayTotal); const showAddBtn = ctx.tender.data.user_id === ctx.session.sessionUser.accountId ? (!latestOrder || (latestOrder.status === auditConst.status.checked && latestOrder.prev_total_amount < advancePayTotal)) : false; const renderData = { type, decimal: this.decimal, showAddBtn, advanceList, latestOrder, auditConst, typeColMap: typeConsts.typeColMap, preUrl: `/tender/${ctx.tender.id}/advance/${type}/create`, jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.advance.main), advancePayTotal, progress, }; await this.layout('advance/index.ejs', renderData, 'advance/modal.ejs'); } /** * 材料预付款页面(AJAX) GET * @param {Object} ctx 全局上下文 */ // async materialList(ctx) { // const type = auditConst.type.material; // const advancePayTotal = ctx.tender.info.deal_param.materialAdvance; // const advanceList = await ctx.service.advance.getAdvanceList(ctx.tender.id, type, this.decimal, advancePayTotal); // const latestOrder = await ctx.service.advance.getLastestAdvance(ctx.tender.id, type, true); // const progress = await ctx.service.advance.calcProgress(latestOrder, advancePayTotal); // const showAddBtn = ctx.tender.data.user_id === ctx.session.sessionUser.accountId ? !latestOrder || (latestOrder.status === auditConst.status.checked && latestOrder.prev_total_amount < advancePayTotal) : false; // const renderData = { // type, // decimal: this.decimal, // showAddBtn, // advanceList, // latestOrder, // auditConst, // preUrl: `/tender/${ctx.tender.id}/advance/${type}/create`, // jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.advance.main), // advancePayTotal, // progress, // }; // await this.layout('advance/index.ejs', renderData, 'advance/modal.ejs'); // } /** * 获取通用的renderData(用于layout, Menu, subMenu部分) * @param {Object} ctx 全局上下文 * @return {{auditConst, jsFiles, accountGroup?, accountList?, auditors, auditHistory, preUrl}} 通用数据 * @private */ async _getDefaultRenderData(ctx) { const data = { auditConst, shenpiConst, jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.advance.info), preUrl: `/tender/${ctx.tender.id}/advance/${ctx.advance.id}`, whiteList: ctx.app.config.multipart.whitelist, }; // 获取所有项目参与者 if ((ctx.advance.status === auditConst.status.uncheck || ctx.advance.status === auditConst.status.checkNo) && ctx.session.sessionUser.accountId === ctx.advance.uid) { // data.accountGroup = accountGroup; // 获取所有项目参与者 const accountList = await ctx.service.projectAccount.getAllDataByCondition({ where: { project_id: ctx.session.sessionProject.id, enable: 1 }, columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'], }); data.accountList = accountList; data.accountGroup = accountGroup.map((item, idx) => { const groupList = accountList.filter(item => item.account_group === idx); return { groupName: item, groupList }; }); data.auditorList = await ctx.service.advanceAudit.getAuditors(ctx.advance.id, ctx.advance.times); } // data.fileList = await ctx.service.advanceFile.getAdvanceFiles({ vid: ctx.advance.id }); // 获取审批流程中右边列表 const auditHistory = []; const times = ctx.advance.status === auditConst.status.checkNo ? ctx.advance.times - 1 : ctx.advance.times; // 获取审核人左边列表 data.auditors = ctx.advance.status === auditConst.status.checkNo && ctx.session.sessionUser.accountId !== ctx.advance.uid ? await ctx.service.advanceAudit.getAuditorsWithOwner(ctx.advance.id, times) : await ctx.service.advanceAudit.getAuditorsWithOwner(ctx.advance.id, ctx.advance.times); if (times >= 1) { for (let i = 1; i <= times; i++) { auditHistory.push(await ctx.service.advanceAudit.getAuditors(ctx.advance.id, i)); } } data.auditHistory = auditHistory; data.fileList = await ctx.service.advanceFile.getAdvanceFiles({ vid: ctx.advance.id }) || []; return data; } /** * 权限判断-进入详情页 * @param {Object} ctx - 全局上下文 * @return {void} * @private */ async _checkCanEntry(ctx) { ctx.advance.filePermission = false; if (ctx.advance.status === auditConst.status.uncheck) { if (ctx.session.sessionUser.accountId !== ctx.advance.uid && !ctx.tender.isTourist) { throw '无权访问'; } else if (ctx.session.sessionUser.accountId === ctx.advance.uid || ctx.tender.touristPermission.file) { ctx.advance.filePermission = true; } } else { const auditors = await ctx.service.advanceAudit.getAuditorsWithOwner(ctx.advance.id, ctx.advance.times); const cur_uid = ctx.session.sessionUser.accountId; if (auditors.findIndex(item => item.audit_id === cur_uid) === -1 && !ctx.tender.isTourist) { throw '无权访问'; } else if (auditors.findIndex(item => item.audit_id === cur_uid) !== -1 || ctx.session.sessionUser.accountId === ctx.advance.uid || ctx.tender.touristPermission.file) { ctx.advance.filePermission = true; } } } /** * 预付款详情页(AJAX) GET * @param {Object} ctx 全局上下文 */ async detail(ctx) { const advancePayTotal = ctx.tender.info.deal_param[`${typeConsts.typeColMap[ctx.advance.type].value}Advance`]; try { await this._checkCanEntry(ctx); const { uncheck, checkNo } = auditConst.status; const { status } = ctx.advance; const isEdited = ctx.session.sessionUser.accountId === ctx.advance.uid && (status === uncheck || status === checkNo); const renderData = await this._getDefaultRenderData(ctx); // 获取上一期预付款记录 const prevAdvance = await ctx.service.advance.getPreviousRecord(ctx.tender.id, ctx.advance.type); // 最大支付比例 const max_pr = ctx.helper.mul(ctx.helper.div(ctx.helper.sub(advancePayTotal, (prevAdvance && prevAdvance.prev_total_amount || 0)), advancePayTotal, 10), 100); const isLimitMax = ctx.helper.round(max_pr, 2) === ctx.advance.pay_ratio; // 特殊处理金额的显示(formatMoney) let cur_amount, prev_total_amount; const s1 = parseFloat(ctx.advance.prev_amount).toString().split('.')[1] || ''; const prev_amount = ctx.helper.formatMoney(ctx.advance.prev_amount, ',', isLimitMax ? s1.length : 2); if (status === uncheck || status === checkNo) { // cur_amount = parseFloat(ctx.helper.round(ctx.advance.cur_amount, 2)) || 0; cur_amount = ctx.advance.cur_amount || 0; const s2 = parseFloat(ctx.helper.add(cur_amount, ctx.advance.prev_amount)).toString().split('.')[1] || ''; prev_total_amount = ctx.helper.formatMoney(ctx.helper.add(cur_amount, ctx.advance.prev_amount), ',', isLimitMax ? s2.length : 2); } else { cur_amount = ctx.advance.cur_amount; const s2 = parseFloat(ctx.advance.prev_total_amount).toString().split('.')[1] || ''; prev_total_amount = ctx.helper.formatMoney(ctx.advance.prev_total_amount, ',', isLimitMax ? s2.length : 2); } renderData.isEdited = isEdited; renderData.advance = ctx.advance; renderData.cur_amount = cur_amount; renderData.prev_amount = prev_amount; renderData.prev_total_amount = prev_total_amount; renderData.max_pr = max_pr; renderData.decimal = 2; renderData.typeColMap = typeConsts.typeColMap; renderData.advancePayTotal = advancePayTotal; renderData.prevAdvance = prevAdvance; await this.layout('advance/detail.ejs', renderData, 'advance/modal_audit.ejs'); } catch (error) { this.log(error); ctx.redirect('/tender/' + ctx.tender.id + '/advance/' + typeConsts.typeColMap[ctx.advance.type].value); } } /** * 更新 * @param {Object} ctx 全局上下文 */ async update(ctx) { const { id } = ctx.advance; const data = JSON.parse(ctx.request.body.data); try { const result = await ctx.service.advance.updateAdvance(data, id); if (result) { ctx.body = { err: 0, msg: '请求成功', data: null }; } else { ctx.body = { err: 0, msg: '请求失败', data: null }; } } catch (error) { this.log(error); ctx.body = { code: 1, msg: error.toString() }; } } /** * 添加新一期 * @param {Object} ctx 全局上下文 */ async create(ctx) { const type = parseInt(ctx.params.type); try { const record = await ctx.service.advance.createRecord(type); if (!record) { throw '数据错误'; } ctx.redirect(`/tender/${ctx.tender.id}/advance/${record.id}/detail`); } catch (error) { this.log(error); ctx.redirect(`/tender/${ctx.tender.id}/advance/${typeConsts.typeColMap[ctx.advance.type].value}`); } } /** * 删除期 * @param {*} ctx 全局上下文 */ async delete(ctx) { try { const data = JSON.parse(ctx.request.body.data); const id = data && this.app._.toInteger(data.id); if (isNaN(id) || id <= 0) { throw '参数错误'; } const advance = await ctx.service.advance.getDataById(id); if (!advance) { throw '参数错误'; } // 检查权限等 if (!ctx.session.sessionUser.is_admin && advance.uid !== ctx.session.sessionUser.accountId) { throw '您无权删除'; } if (!ctx.session.sessionUser.is_admin && advance.status !== auditConst.status.uncheck && advance.status !== auditConst.status.checkNo) { // console.log(advance.status !== auditConst.status.uncheck); // console.log(advance.status !== auditConst.status.checkNo); throw '当前不允许删除'; } await ctx.service.advance.deleteAdvance(id, ctx.tender.id); ctx.body = { err: 0, msg: '' }; } catch (error) { this.log(error); ctx.body = { err: 1, msg: error.toString(), data: null }; } } /** * 添加审批人 * @param {Object} ctx 全局上下文 */ async addAudit(ctx) { try { const data = JSON.parse(ctx.request.body.data); const audit_id = data && this.app._.toInteger(data.auditorId); if (isNaN(audit_id) || audit_id <= 0) { throw '参数错误'; } // 检查权限等 if (ctx.advance.uid !== ctx.session.sessionUser.accountId) { throw '您无权添加审核人'; } if (ctx.advance.status === auditConst.status.checking || ctx.advance.status === auditConst.status.checked) { throw '当前不允许添加审核人'; } // 检查审核人是否已存在 const exist = this.app._.find(ctx.advance.auditors, { audit_id }); if (exist) { throw '该审核人已存在,请勿重复添加'; } const shenpiInfo = await ctx.service.shenpiAudit.getDataByCondition({ tid: ctx.tender.id, sp_type: shenpiConst.sp_type.advance, sp_status: shenpiConst.sp_status.gdzs }); const is_gdzs = shenpiInfo && ctx.tender.info.shenpi.advance === shenpiConst.sp_status.gdzs ? 1 : 0; const result = await ctx.service.advanceAudit.addAuditor(ctx.tender.id, ctx.advance.id, audit_id, ctx.advance.times, is_gdzs); if (!result) { throw '添加审核人失败'; } const auditors = await ctx.service.advanceAudit.getAuditorsWithOwner(ctx.advance.id, ctx.advance.times); ctx.body = { err: 0, msg: '', data: auditors }; } catch (err) { this.log(err); ctx.body = { err: 1, msg: err.toString(), data: null }; } } /** * 移除审批人 * @param {Object} ctx 全局上下文 */ async deleteAudit(ctx) { try { const data = JSON.parse(ctx.request.body.data); const id = data && data.auditorId instanceof Number ? data.auditorId : this.app._.toNumber(data.auditorId); if (isNaN(id) || id <= 0) { throw '参数错误'; } const result = await ctx.service.advanceAudit.deleteAuditor(ctx.advance.id, id, ctx.advance.times); if (!result) { throw '移除审核人失败'; } const auditors = await ctx.service.advanceAudit.getAuditGroupByList(ctx.advance.id, ctx.advance.times); ctx.body = { err: 0, msg: '', data: auditors }; } catch (err) { ctx.body = { err: 1, msg: err.toString(), data: null }; } } /** * 上报审批 * @param {Object} ctx 全局上下文 */ async start(ctx) { const data = JSON.parse(ctx.request.body.data); try { // 检查权限等 if (!ctx.advance) { throw '数据错误'; } if (ctx.advance.uid !== ctx.session.sessionUser.accountId) { throw '您无权上报该期数据'; } if (ctx.advance.status === auditConst.status.checking || ctx.advance.status === auditConst.status.checked) { throw '该预付款期数据当前无法上报'; } if (data.cur_amount === 0) { throw '本期金额不能为空'; } await ctx.service.advanceAudit.start(ctx.advance.id, ctx.advance.times, data); ctx.body = { err: 0, msg: '' }; } catch (error) { this.log(error); ctx.session.postError = error.toString(); ctx.body = { err: 1, msg: error.toString() }; } } /** * 审批 * @param {Object} ctx 全局上下文 */ async checkAudit(ctx) { try { if (!ctx.advance || ctx.advance.status !== auditConst.status.checking) { throw '当前材料调差期数据有误'; } if (!ctx.advance.curAuditor || ctx.advance.curAuditor.audit_id !== ctx.session.sessionUser.accountId) { throw '您无权进行该操作'; } const data = { checkType: parseInt(ctx.request.body.checkType), opinion: ctx.request.body.opinion, }; if (!data.checkType || isNaN(data.checkType)) { throw '提交数据错误'; } if (data.checkType === auditConst.status.checkNo) { if (!data.checkType || isNaN(data.checkType)) { throw '提交数据错误'; } } await ctx.service.advanceAudit.check(ctx.advance.id, data, ctx.advance.times); ctx.redirect(ctx.request.header.referer); } catch (err) { this.log(err); ctx.session.postError = err.toString(); ctx.redirect(ctx.request.header.referer); } } _checkAdvanceFileCanModify(ctx) { // 检查登录用户,是否可操作 const accountId = ctx.session.sessionUser.accountId; if (!ctx.advance.curAuditor) { if (ctx.advance.status === auditConst.status.uncheck || ctx.advance.status === auditConst.status.checkNo && accountId === ctx.advance.uid) { return; } throw '该预付款期当前您无权操作'; } else { if (ctx.advance.curAuditor.audit_id === accountId) return; throw '该预付款期当前您无权操作'; } } /** * 上传附件 * @param {*} ctx 上下文 */ async upload(ctx) { let stream; try { // this._checkAdvanceFileCanModify(ctx); const parts = this.ctx.multipart({ autoFields: true, }); const files = []; const create_time = Date.parse(new Date()) / 1000; let idx = 0; const extra_upload = ctx.advance.status === auditConst.status.checked; while ((stream = await parts()) !== undefined) { if (!stream.filename) { // 如果没有传入直接返回 return; } const fileInfo = path.parse(stream.filename); const filepath = `public/upload/${this.ctx.tender.id.toString()}/yfk/fujian_${create_time + idx.toString() + fileInfo.ext}`; await ctx.helper.saveStreamFile(stream, path.resolve(this.app.baseDir, 'app', filepath)); files.push({ filepath, name: stream.filename, ext: fileInfo.ext }); ++idx; stream && (await sendToWormhole(stream)); } const in_time = new Date(); const payload = files.map(file => { let idx; if (Array.isArray(parts.field.name)) { idx = parts.field.name.findIndex(name => name === file.name); } else { idx = 'isString'; } const newFile = { uid: ctx.session.sessionUser.accountId, vid: ctx.advance.id, tid: ctx.tender.id, create_time: in_time, filepath: file.filepath, filesize: ctx.helper.bytesToSize(idx === 'isString' ? parts.field.size : parts.field.size[idx]), filename: file.name, fileext: file.ext, extra_upload, }; return newFile; }); // 执行文件信息写入数据库 await ctx.service.advanceFile.saveFileMsgToDb(payload); // 将最新的当前标段的所有文件信息返回 const data = await ctx.service.advanceFile.getAdvanceFiles({ vid: ctx.advance.id }); ctx.body = { err: 0, msg: '', data }; } catch (err) { stream && (await sendToWormhole(stream)); this.log(err); ctx.body = { err: 1, msg: err.toString(), data: null }; } } /** * 删除附件 * @param {Ojbect} ctx 上下文 */ async deleteFile(ctx) { try { const { id } = JSON.parse(ctx.request.body.data); const fileInfo = await ctx.service.advanceFile.getDataById(id); if (fileInfo || Object.keys(fileInfo).length) { // 先删除文件 await fs.unlinkSync(path.resolve(this.app.baseDir, './app', fileInfo.filepath)); // 再删除数据库 await ctx.service.advanceFile.delete(id); } else { throw '不存在该文件'; } const data = await ctx.service.advanceFile.getAdvanceFiles({ vid: ctx.advance.id }); ctx.body = { err: 0, msg: '请求成功', data }; } catch (err) { this.log(err); ctx.body = { err: 1, msg: err.toString(), data: null }; } } /** * 下载附件 * @param {Object} ctx - egg全局变量 * @return {void} */ async downloadFile(ctx) { const id = ctx.params.fid; if (id) { try { const fileInfo = await ctx.service.advanceFile.getDataById(id); if (fileInfo !== undefined && fileInfo !== '') { const fileName = path.join(__dirname, '../', fileInfo.filepath); // 解决中文无法下载问题 const userAgent = (ctx.request.header['user-agent'] || '').toLowerCase(); let disposition = ''; if (userAgent.indexOf('msie') >= 0 || userAgent.indexOf('chrome') >= 0) { disposition = 'attachment; filename=' + encodeURIComponent(fileInfo.filename); } else if (userAgent.indexOf('firefox') >= 0) { disposition = 'attachment; filename*="utf8\'\'' + encodeURIComponent(fileInfo.filename) + '"'; } else { /* safari等其他非主流浏览器只能自求多福了 */ disposition = 'attachment; filename=' + new Buffer(fileInfo.filename).toString('binary'); } ctx.response.set({ 'Content-Type': 'application/octet-stream', 'Content-Disposition': disposition, 'Content-Length': fileInfo.filesize, }); ctx.body = await fs.createReadStream(fileName); } else { throw '不存在该文件'; } } catch (err) { this.log(err); this.setMessage(err.toString(), this.messageType.ERROR); } } } /** * 获取列表页所需的审核弹窗列表 * @param {object} ctx 全局上下文 */ async getAuditors(ctx) { try { const data = {}; // 获取审核人左边列表 data.auditors = await ctx.service.advanceAudit.getAuditorsWithOwner(ctx.advance.id, ctx.advance.times); // 获取审批流程中右边列表 const auditHistory = []; const times = ctx.advance.status === auditConst.status.checkNo ? ctx.advance.times - 1 : ctx.advance.times; if (times >= 1) { for (let i = 1; i <= times; i++) { auditHistory.push(await ctx.service.advanceAudit.getAuditors(ctx.advance.id, i)); } } data.auditHistory = auditHistory; data.user = ctx.advance.user; ctx.body = { err: 0, msg: '请求成功', data }; } catch (error) { this.log(error); ctx.body = { err: 0, msg: error.toString() }; } } } return advanceController; };