Calculation/app/service/ledger_extra.js

'use strict';

/**
 * 部位明细
 *
 * @author Mai
 * @date
 * @version
 */

module.exports = app => {

    class LedgerExtra extends app.BaseService {
        /**
         * 构造函数
         *
         * @param {Object} ctx - egg全局变量
         * @return {void}
         */
        constructor(ctx) {
            super(ctx);
            this.depart = ctx.app.config.table_depart.heavy;
            this.tableName = 'ledger_extra';
        }

        async getData(tid, columns) {
            if (!columns || columns.length === 0) return [];

            return await this.db.select(this.departTableName(tid), {
                where: { tid },
                columns: ['id', ...columns],
            });
        }

        async getCalcTemplateData(tid) {
            const sql = `SELECT id, calc_template FROM ${this.departTableName(tid)} WHERE tid = ? and calc_template <> ''`;
            return await this.db.query(sql, [tid]);
        }

        async getUsedCalcTemplate(tid) {
            const sql = `SELECT calc_template, count(id) as count FROM ${this.departTableName(tid)} WHERE tid = ? and calc_template <> '' GROUP BY calc_template`;
            const result = await this.db.query(sql, [tid]);
            return result;
            // return result.map(x => { return x.calc_template; });
        }

        async updateMultiLimit(id, multi_limit) {
            const exist = await this.getDataById(id);
            if (exist) {
                await this.defaultUpdate({ id, multi_limit });
            } else {
                await this.db.insert(this.tableName, { id, tid: this.ctx.tender.id, multi_limit });
            }
        }
    }

    return LedgerExtra;
};