Laravel多模型类型集合排队不支持报错解决方案咨询

你遇到的Queueing collections with multiple model types is not supported错误，核心原因是合并后的集合同时包含Nentrega和Compra两种模型实例，后续处理逻辑（如报表渲染、队列任务）不支持混合不同模型类型的集合。以下是两种可行的解决方案：

方案一：转为数组后合并集合 #

将两个模型的查询结果转换为关联数组，再合并排序，消除模型类型差异：

// 替换原代码中get()为get()->toArray()
$notas = Nentrega::join('users as u', 'u.id', 'nentregas.user_id')
    ->select('nentregas.*', 'u.name as user')
    ->whereBetween('nentregas.fecha_compra', [$from, $to])
    ->get()->toArray();

$facturas = Compra::join('users as u', 'u.id', 'compras.user_id')
    ->select('compras.*', 'u.name as user')
    ->whereBetween('compras.fecha_compra', [$from, $to])
    ->get()->toArray();

// 合并数组并排序
$c = collect(array_merge($facturas, $notas))->sortByDesc('created_at');
$this->data = $c;

这种方式把集合元素统一为关联数组，避免了模型类型冲突，适合数据量较小的场景。

方案二：数据库层面UNION查询（推荐） #

直接在数据库层合并两个表的查询结果，返回统一的数据集，性能更优且无类型问题：

// 构建Nentrega表的查询
$notasQuery = DB::table('nentregas')
    ->join('users as u', 'u.id', 'nentregas.user_id')
    ->select('nentregas.*', 'u.name as user', DB::raw('"nentrega" as source_table')) // 可选：标记数据来源表
    ->whereBetween('nentregas.fecha_compra', [$from, $to]);

// 构建Compra表查询并执行UNION
$combinedQuery = DB::table('compras')
    ->join('users as u', 'u.id', 'compras.user_id')
    ->select('compras.*', 'u.name as user', DB::raw('"compra" as source_table')) // 可选：标记数据来源表
    ->whereBetween('compras.fecha_compra', [$from, $to])
    ->union($notasQuery);

// 添加用户筛选条件（如果需要）
if ($this->userId != 0) {
    $combinedQuery->where('user_id', $this->userId);
}

// 执行查询并排序
$c = $combinedQuery->orderByDesc('created_at')->get();
$this->data = $c;

额外优化：消除代码冗余 #

原代码中三个分支的查询逻辑高度重复，可以提取为公共方法，提升维护性：

private function getCombinedRecords($from, $to, $userId = 0)
{
    $notasQuery = DB::table('nentregas')
        ->join('users as u', 'u.id', 'nentregas.user_id')
        ->select('nentregas.*', 'u.name as user', DB::raw('"nentrega" as source_table'))
        ->whereBetween('nentregas.fecha_compra', [$from, $to]);

    $combinedQuery = DB::table('compras')
        ->join('users as u', 'u.id', 'compras.user_id')
        ->select('compras.*', 'u.name as user', DB::raw('"compra" as source_table'))
        ->whereBetween('compras.fecha_compra', [$from, $to])
        ->union($notasQuery);

    if ($userId != 0) {
        $combinedQuery->where('user_id', $userId);
    }

    return $combinedQuery->orderByDesc('created_at')->get();
}

public function ComprasPorFecha()
{
    // 简化日期处理
    if ($this->tipoReporte == 0) {
        $from = Carbon::today()->startOfDay()->toDateTimeString();
        $to = Carbon::today()->endOfDay()->toDateTimeString();
    } else {
        if (empty($this->desde) || empty($this->hasta)) {
            $this->data = collect();
            return $this->data;
        }
        $from = Carbon::parse($this->desde)->startOfDay()->toDateTimeString();
        $to = Carbon::parse($this->hasta)->endOfDay()->toDateTimeString();
    }

    // 统一调用公共方法
    if ($this->tipoReporte == 1 && (empty($this->desde) || empty($this->hasta))) {
        $this->data = $this->getCombinedRecords($from, $to);
    } else {
        $this->data = $this->getCombinedRecords($from, $to, $this->userId);
    }

    return $this->data;
}

内容的提问来源于stack exchange，提问作者Karelix Alejandra