'use strict'; /** * * * @author Mai * @date 2018/8/14 * @version */ const audit = require('../const/audit'); module.exports = app => { class ChangeAudit extends app.BaseService { /** * 构造函数 * * @param {Object} ctx - egg全局变量 * @return {void} */ constructor(ctx) { super(ctx); this.tableName = 'change_audit'; } /** * 获取最后一位审批人 * @param cid * @return {Promise.} */ async getLastUser(cid, times, site = 1) { this.initSqlBuilder(); this.sqlBuilder.setAndWhere('cid', { value: this.db.escape(cid), operate: '=', }); this.sqlBuilder.setAndWhere('times', { value: times, operate: '=', }); this.sqlBuilder.setAndWhere('status', { value: 1, operate: '!=', }); if (site === 0) { this.sqlBuilder.setAndWhere('usite', { value: site, operate: '=', }); } this.sqlBuilder.orderBy = [['usort', 'DESC']]; const [sql, sqlParam] = this.sqlBuilder.build(this.tableName); const data = await this.db.queryOne(sql, sqlParam); return data; } /** * 获取当前审批人查看info时的状态 * @param cid * @param times * @param status * @return {Promise.} */ async getStatusByChange(change) { const statusConst = audit.flow.status; const auditStatusConst = audit.flow.auditStatus; const uid = this.ctx.session.sessionUser.accountId; const changeAuditInfo = (await this.getAllDataByCondition({where: { cid: change.cid, times: change.times, uid: uid}, order: ['id', 'DESC']})); if (changeAuditInfo === null) { // 无权限查看此变更令 return 0; } if (change.status === statusConst.uncheck && uid === change.uid) { // 待上报 return 1; } else if (change.status === statusConst.back && uid === change.uid) { // 待重新上报 return 2; } else if (change.status === statusConst.back && uid !== change.uid) { // 被退回但你不是原报人 return 3; } else if (change.status === statusConst.checked) { // 已完成 return 4; } else if (change.status === statusConst.checkNo) { // 已终止 return 5; } else if (change.status === statusConst.checking && changeAuditInfo.status === auditStatusConst.checking) { // 待你审批 return 6; } else if (change.status === statusConst.checking && changeAuditInfo.status !== auditStatusConst.checking) { // 审批中但你未到你审批或你已审批 return 7; } else { // 无权限查看此变更令 return 0; } } } return ChangeAudit; };