import { CoolController, BaseController } from '@cool-midway/core';
import { RecycleTransactionEntity } from '../../entity/transaction';
import { RecycleTransactionService } from '../../service/transaction';
import { UserInfoEntity } from '../../../user/entity/info';
import { BaseSysDepartmentEntity } from '../../../base/entity/sys/department';
import { WithDeptFilterWhere } from '../../../base/middleware/with-dept-filter-where'

/**
 * 流水记录管理
 */
@CoolController({
    api: ['add', 'delete', 'update', 'info', 'list', 'page'],
    entity: RecycleTransactionEntity,
    service: RecycleTransactionService,
    pageQueryOp: {
        select: ['a.*', 'b.userName as userName', 'c.name as departmentName'],
        keyWordLikeFields: ['a.remark'],
        fieldEq: [
            { column: 'a.userId', requestParam: 'userId' },
            { column: 'a.orderId', requestParam: 'orderId' },
            { column: 'a.departmentId', requestParam: 'departmentId' },
            { column: 'a.type', requestParam: 'type' },
            { column: 'a.sourceType', requestParam: 'sourceType' }
        ],
        join: [
            {
                entity: UserInfoEntity,
                alias: 'b',
                condition: 'a.userId = b.unionid',
                type: 'leftJoin'
            },
            {
                entity: BaseSysDepartmentEntity,
                alias: 'c',
                condition: 'a.departmentId = c.id',
                type: 'leftJoin'
            }
        ],
        where: async (ctx) => {
            const { startTime, endTime } = ctx.request.body;
            const conditions: any[][] = [];
            if (startTime && endTime) {
                conditions.push(['a.createTime BETWEEN :startTime AND :endTime', { startTime, endTime }]);
            }
            conditions.push(...(await WithDeptFilterWhere(ctx, { alias: 'a', field: 'departmentId' })));
            return conditions;
        },
        addOrderBy: {
            createTime: 'desc'
        }
    }
})
export class AdminFinanceTransactionController extends BaseController { }