Advertisement
Guest User

Untitled

a guest
May 22nd, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1.  
  2. $items = DB::table('transactions')
  3. ->leftjoin('transaction_payments','transaction_payments.transaction_id','=','transactions.id')
  4. ->leftjoin('transaction_sell_lines','transaction_sell_lines.transaction_id','=','transactions.id')
  5. ->leftjoin('transaction_sell_lines_purchase_lines','transaction_sell_lines_purchase_lines.sell_line_id','=','transaction_sell_lines.id')
  6. // ->leftjoin('variation_location_details','variation_location_details.product_id','=','transaction_sell_lines.product_id')
  7. ->select('transactions.id')
  8. ->orderBy('transactions.id','desc')
  9. ->limit(10)
  10. ->get();
  11. dd($items);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement