Calculation/app/service/financial_transfer.js

'use strict';

/**
 * Created by EllisRan on 2020/3/3.
 */

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

module.exports = app => {

    class FinancialTransfer extends BaseService {

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

        async getList(spid, pageLimit = 0) {
            let sql = 'SELECT ft.*, pa.`name` as username, pa.`company` FROM ?? as ft LEFT JOIN ?? as pa ON ft.`uid` = pa.`id` WHERE ft.`spid` = ? ORDER BY ft.`id` DESC';
            if (pageLimit) {
                const limit = this.ctx.pageSize ? this.ctx.pageSize : this.app.config.pageSize;
                const offset = limit * (this.ctx.page - 1);
                const limitString = offset >= 0 ? offset + ',' + limit : limit;
                sql += ' LIMIT ' + limitString;
            }
            const sqlParams = [this.tableName, this.ctx.service.projectAccount.tableName, spid];
            const list = await this.db.query(sql, sqlParams);
            for (const l of list) {
                l.files = await this.ctx.service.financialTransferAtt.getAtt(l.id);
            }
            return list;
        }

        async addTransfer(spid, date, remark) {
            const node = await this.getDataByCondition({ spid, t_time: date });
            if (node) {
                throw '资金划拨年月已存在，请勿重复';
            }
            let pre_hb_tp = 0;
            const ftList = await this.getAllDataByCondition({ where: { spid } });
            if (ftList.length > 0) {
                pre_hb_tp = this.ctx.helper.sum(this._.map(ftList, 'total_price'));
            }
            const insertData = {
                spid,
                pre_hb_tp,
                t_time: date,
                create_time: new Date(),
                remark,
                uid: this.ctx.session.sessionUser.accountId,
            };
            const result = await this.db.insert(this.tableName, insertData);
            if (result.affectedRows === 1) {
                return result.insertId;
            }
            return false;
        }

        async delTransfer(trid) {
            if (!trid) {
                throw '参数有误';
            }
            const node = await this.getDataById(trid);
            if (!node) {
                throw '资金划拨不存在';
            }
            const transaction = await this.db.beginTransaction();
            try {
                await transaction.delete(this.tableName, { id: node.id });
                // 删除合同附件
                const attList = await this.ctx.service.financialTransferAtt.getAllDataByCondition({ where: { trid } });
                const tenderAttList = await this.ctx.service.financialTransferTenderAtt.getAllDataByCondition({ where: { trid } });
                await this.ctx.helper.delFiles(this._.concat(attList, tenderAttList));
                // 重算截止上次划拨金额
                const fttList = await this.ctx.service.financialTransferTender.getAllDataByCondition({ where: { trid } });
                await transaction.delete(this.ctx.service.financialTransferTender.tableName, { trid });
                for (const ftt of fttList) {
                    await this.ctx.service.financialTransferTender.calcPreHbTp(transaction, node, ftt);
                }
                await transaction.commit();
            } catch (err) {
                await transaction.rollback();
                throw err;
            }
            return true;
        }

        async lockTransfer(trid, lock) {
            if (!trid) {
                throw '参数有误';
            }
            const node = await this.getDataById(trid);
            if (!node) {
                throw '该资金划拨不存在';
            }
            if (node.uid !== this.ctx.session.sessionUser.accountId) {
                throw '您没有权限操作';
            }
            const result = await this.db.update(this.tableName, { id: node.id, is_lock: lock });
            return result.affectedRows === 1;
        }

        async saveTransfer(data) {
            if (!data.id) {
                throw '参数有误';
            }
            const node = await this.getDataById(data.id);
            if (!node) {
                throw '该资金划拨不存在';
            }
            if (node.uid !== this.ctx.session.sessionUser.accountId) {
                throw '您没有权限操作';
            }
            const result = await this.db.update(this.tableName, data);
            return result.affectedRows === 1;
        }
    }
    return FinancialTransfer;
};