Laravel 5.2中orWhereRaw关联查询报错，求修正方案

安全阿岳

2026-8-22

解决Laravel 5.2中Object of class Closure could not be converted to string错误

你的错误核心原因是Laravel 5.2里的orWhereRaw()不支持传入闭包，它仅能接收原生SQL字符串，把闭包传给它就会触发“闭包无法转为字符串”的报错。

修改方案很直接，把外层的orWhereRaw()替换为orWhere()，闭包内部的whereRaw()保留即可——因为闭包内的$query是QueryBuilder实例，完全支持whereRaw()方法：

$results = DB::table('statement_transactions AS st')
            ->join('quickbooks_transactions AS qt', function ($join) {
                $join->on('st.transaction_date', '=', 'qt.transaction_date');
                $join->on('st.transaction_type_id', '=', 'qt.transaction_type_id');
                $join->on('st.original_amount', '=', 'qt.original_amount');
                $join->on('st.balance', '=', 'qt.balance');
            })
            ->where('st.statement_id', $this->statement->id)
            ->where('st.has_match', 0)
            ->where('st.has_partial_match', 0)
            ->whereNull('st.quickbooks_transaction_id')
            ->orWhere(function ($query) {
                $query->whereRaw("LEFT(REPLACE(st.invoice_nbr, '-', ''), 5) = LEFT(REPLACE(qt.invoice_nbr, '-', ''), 5)")
                    ->whereRaw("RIGHT(REPLACE(st.invoice_nbr, '-', ''), 5) = RIGHT(REPLACE(qt.invoice_nbr, '-', ''), 5)");
            })
            ->select('st.id AS statement_transaction_id', 'qt.id AS quickbooks_transaction_id')
            ->get();