laravel unionAll 多表字段不一致解决方案

小人物之辈

于 2024-08-05 13:14:09 发布

阅读量164

点赞数 3

文章标签： laravel

本文链接：https://blog.csdn.net/u012230371/article/details/140924285

版权

 $querySell = Borrow::with(['userData','recordData','customerData','borrowInfoData'])
                // ->setAppends(['type' => 'sell'])
                ->wheres($sql)
                ->select('id','number','state','time','amount','total','user','examine','type','data','customer','borrow_nums','borrow_restore_nums',DB::raw("-1 as nums"));
            // $xk = DB::table('sells')
            //     ->leftJoin('users','users.id', '=', 'sells.user')
            //     ->wheres($sql)
            //     ->select('sells.id', 'sells.number','sells.time','sells.amount','sells.total','sells.user','users.name',DB::raw('"sell" as type'));
            
$querySre = BorrowRestore::with(['userData','recordData','customerData','borrowRestoreInfoData'])
                // ->setAppends(['type' => 'sre'])
                ->wheres($sql)
                ->select('id','number','state','time','amount','total','user','examine','type','data','customer',DB::raw("-1 as borrow_nums"),DB::raw("-1 as borrow_restore_nums"),'nums');
            $unionAllQuery = $querySell->unionAll($querySre);