Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $items = DB::table('transactions')
- ->leftjoin('transaction_payments','transaction_payments.transaction_id','=','transactions.id')
- ->leftjoin('transaction_sell_lines','transaction_sell_lines.transaction_id','=','transactions.id')
- ->leftjoin('transaction_sell_lines_purchase_lines','transaction_sell_lines_purchase_lines.sell_line_id','=','transaction_sell_lines.id')
- // ->leftjoin('variation_location_details','variation_location_details.product_id','=','transaction_sell_lines.product_id')
- ->select('transactions.id')
- ->orderBy('transactions.id','desc')
- ->limit(10)
- ->get();
- dd($items);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement