Advertisement
Guest User

Untitled

a guest
Jun 24th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.00 KB | None | 0 0
  1. if($interval_type == "custom") {
  2. $startTime = $request->start_time;
  3. if($request->Start_Time) {
  4. if($request->End_Time) {
  5. $invoice_list = Forms::where('seller_id', $seller_id)->whereBetween('created_at', [$request->Start_Time, $request->End_Time])->get();
  6. } else {
  7. $invoice_list = Forms::where('seller_id', $seller_id)->where('created_at', '>=', $request->Start_Time)->get();
  8. }
  9. } else if ($request->End_Time) {
  10. $invoice_list = Forms::where('seller_id', $seller_id)->where('created_at', '<=', $request->End_Time)->get();
  11. } else {
  12. $invoice_list = Forms::where('seller_id', $seller_id)->get();
  13. }
  14. } else if($interval_type == "last_week") {
  15. $start_time = date('Y-m-d', strtotime("-1 week"));
  16. $invoice_list = Forms::where('seller_id', $seller_id)->where('created_at', '>=', $start_time)->get();
  17. } else if($interval_type == "last_month") {
  18. $start_time = date('Y-m-d', strtotime("-1 month"));
  19. $invoice_list = Forms::where('seller_id', $seller_id)->where('created_at', '>=', $start_time)->get();
  20. } else if ($interval_type == "anytime") {
  21. $invoice_list = Forms::where('seller_id', $seller_id)->get();
  22. } else if($interval_type == "last_year") {
  23. $start_time = date('Y-m-d', strtotime("-1 year"));
  24. $invoice_list = Forms::where('seller_id', $seller_id)->where('created_at', '>=', $start_time)->get();
  25. }
  26.  
  27. foreach ($invoice_list as $invoice) {
  28. $tmp_ron = Items::where('form_id', $invoice->id)->sum('total_ron');
  29. $tmp_euro = Items::where('form_id', $invoice->id)->sum('total_eur');
  30. $tmp = array("total_euro" => $tmp_euro, "total_ron" => $tmp_ron);
  31. $total_euro += $tmp_euro;
  32. $total_ron += $tmp_ron;
  33. array_push($invoice_list_total, $tmp);
  34. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement