Calculation/app/service/role_rpt_rel.js

'use strict';

/**
 * Created by Tony on 2019/9/26.
 */

const BaseService = require('../base/base_service');

module.exports = app => {

    class RoleRptRel extends BaseService {

        /**
         * 构造函数
         *
         * @param {Object} ctx - egg全局变量
         * @return {void}
         */
        constructor(ctx) {
            super(ctx);
            this.tableName = 'role_rpt_rel';
            this.dataId = 'id';
        }

        async getRoleRptRelById(id) {
            this.initSqlBuilder();
            this.sqlBuilder.setAndWhere('id', {
                value: id,
                operate: '=',
            });
            this.sqlBuilder.columns = ['id', 'tender_id', 'rpt_id', 'rel_content'];
            const [sql, sqlParam] = this.sqlBuilder.build(this.tableName);
            const list = await this.db.query(sql, sqlParam);
            return list;
        }

        async getRoleRptRelByTenderId(tenderId) {
            this.initSqlBuilder();
            this.sqlBuilder.setAndWhere('tender_id', {
                value: tenderId,
                operate: '=',
            });
            this.sqlBuilder.columns = ['id', 'tender_id', 'rpt_id', 'rel_content'];
            const [sql, sqlParam] = this.sqlBuilder.build(this.tableName);
            const list = await this.db.query(sql, sqlParam);
            return list;
        }

        async getRoleRptRelByDetailIds(tenderId, rptId) {
            this.initSqlBuilder();
            this.sqlBuilder.setAndWhere('tender_id', {
                value: tenderId,
                operate: '=',
            });
            this.sqlBuilder.setAndWhere('rpt_id', {
                value: rptId,
                operate: '=',
            });
            this.sqlBuilder.columns = ['id', 'tender_id', 'rpt_id', 'rel_content'];
            const [sql, sqlParam] = this.sqlBuilder.build(this.tableName);
            const list = await this.db.query(sql, sqlParam);
            return list;
        }

        async createRoleRelationship(tender_id, rpt_id, relArr) {
            let rst = null;
            this.transaction = await this.db.beginTransaction();
            try {
                const data = {
                    id: 0,
                    tender_id: tender_id,
                    rpt_id: rpt_id,
                    rel_content: JSON.stringify(relArr),
                };
                rst = await this.transaction.insert(this.tableName, data);
                await this.transaction.commit();
            } catch (ex) {
                console.log(ex);
                // 回滚
                await this.transaction.rollback();
            }
            return rst;
        }

        // async updateRoleRelationship(tender_id, rpt_id, relArr) {
        //     let rst = null;
        //     this.transaction = await this.db.beginTransaction();
        //     try {
        //         const data = {
        //             id: 0,
        //             tender_id: tender_id,
        //             rpt_id: rpt_id,
        //             rel_content: JSON.stringify(relArr),
        //         };
        //         rst = await this.transaction.insert(this.tableName, data);
        //         await this.transaction.commit();
        //     } catch (ex) {
        //         console.log(ex);
        //         // 回滚
        //         await this.transaction.rollback();
        //     }
        //     return rst;
        // }
    }
    return RoleRptRel;
};