import { Inject } from '@midwayjs/core';
import { CoolController, BaseController } from '@cool-midway/core';
import { OperationWastesaleEntity } from '../../entity/wastesale';
import { OperationWastesaleService } from '../../service/wastesale';
import { BasicdataSorterEntity } from '../../../basicdata/entity/sorter';
import { BasicdataBuyerEntity } from '../../../basicdata/entity/buyer'
import { BaseSysDepartmentEntity } from '../../../base/entity/sys/department';
import { BasicdataSiteEntity } from '../../../basicdata/entity/site'
import { BasicdataWastetypeEntity } from '../../../basicdata/entity/wastetype';
import { WithDeptFilterWhere } from '../../../base/middleware/with-dept-filter-where'

/**
 * 可回收物收益管理
 */
@CoolController({
  api: ['add', 'delete', 'update', 'info', 'list', 'page'],
  entity: OperationWastesaleEntity,
  service: OperationWastesaleService,
  insertParam: (ctx) => {
    return {
      handlerId: ctx.admin.userId,
    };
  },
  pageQueryOp: {
    select: [
      'a.*',
      'b.name AS departmentName',
      'c.businessName AS siteName',
      'd.name AS wasteName',
      'e.businessName AS handlerName',
      'f.name AS buyerName',
    ],
    join: [
      {
        entity: BaseSysDepartmentEntity,
        alias: 'b',
        condition: 'a.departmentId = b.id',
        type: 'leftJoin',
      },
      {
        entity: BasicdataSiteEntity,
        alias: 'c',
        condition: 'a.siteId = c.businessId',
        type: 'leftJoin',
      },
      {
        entity: BasicdataWastetypeEntity,
        alias: 'd',
        condition: 'a.wasteCode = d.code',
        type: 'leftJoin',
      },
      {
        entity: BasicdataSorterEntity,
        alias: 'e',
        condition: 'a.handlerId = e.businessId',
        type: 'leftJoin',
      },
      {
        entity: BasicdataBuyerEntity,
        alias: 'f',
        condition: 'a.buyerCode = f.code',
        type: 'leftJoin',
      },
    ],
    fieldEq: ['a.departmentId', 'a.collectionPointId'],
    where: async (ctx) => {
      const { startTime, endTime } = ctx.request.body;
      const conditions: any[][] = [];
      if (startTime && endTime) {
        conditions.push(['a.dateTime BETWEEN :startTime AND :endTime', { startTime, endTime }]);
      }
      conditions.push(...(await WithDeptFilterWhere(ctx, { alias: 'a', field: 'departmentId' })));

      return conditions;
    },
  },
})
export class AdminOperationWastesaleController extends BaseController {
  @Inject()
  ctx;
}