import { CoolController, BaseController } from '@cool-midway/core';
import { BasicdataSorterEntity } from '../../entity/sorter';
import { BasicdataSorterService } from '../../service/sorter';
import { BaseSysDepartmentEntity } from '../../../base/entity/sys/department';
import { BasicdataSiteEntity } from '../../entity/site';
import { WithDeptFilterWhere } from '../../../base/middleware/with-dept-filter-where'

/**
 * 分拣人员后台管理
 */
@CoolController({
  api: ['add', 'delete', 'update', 'info', 'list', 'page'],
  entity: BasicdataSorterEntity,
  service: BasicdataSorterService,
  pageQueryOp: {
    keyWordLikeFields: ['a.businessName', 'a.businessId', 'a.phone'],
    fieldEq: ['a.status', 'a.departmentId', 'a.siteId'],

    select: [
      'a.*',
      'b.name AS departmentName',
      'c.businessName AS workSiteName',   // ✅ 站点名称
    ],

    join: [
      {
        entity: BaseSysDepartmentEntity,
        alias: 'b',
        condition: 'a.departmentId = b.id',
        type: 'leftJoin',
      },
      {
        entity: BasicdataSiteEntity,
        alias: 'c',
        condition: 'a.workSiteId = c.businessId',
        type: 'leftJoin',
      },
    ],
    where: async ctx => {
      const conditions: any[][] = [];
      conditions.push(...(await WithDeptFilterWhere(ctx, { alias: 'a', field: 'departmentId' })));

      // 其他关联表（举例）
      // conditions.push(...(await deptFilterWhere(ctx, 'd', 'id')));

      return conditions;
    },
  },
})
export class AdminBasicdataSorterController extends BaseController { }