Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if($interval_type == "custom") {
- $startTime = $request->start_time;
- if($request->Start_Time) {
- if($request->End_Time) {
- $invoice_list = Forms::where('seller_id', $seller_id)->whereBetween('created_at', [$request->Start_Time, $request->End_Time])->get();
- } else {
- $invoice_list = Forms::where('seller_id', $seller_id)->where('created_at', '>=', $request->Start_Time)->get();
- }
- } else if ($request->End_Time) {
- $invoice_list = Forms::where('seller_id', $seller_id)->where('created_at', '<=', $request->End_Time)->get();
- } else {
- $invoice_list = Forms::where('seller_id', $seller_id)->get();
- }
- } else if($interval_type == "last_week") {
- $start_time = date('Y-m-d', strtotime("-1 week"));
- $invoice_list = Forms::where('seller_id', $seller_id)->where('created_at', '>=', $start_time)->get();
- } else if($interval_type == "last_month") {
- $start_time = date('Y-m-d', strtotime("-1 month"));
- $invoice_list = Forms::where('seller_id', $seller_id)->where('created_at', '>=', $start_time)->get();
- } else if ($interval_type == "anytime") {
- $invoice_list = Forms::where('seller_id', $seller_id)->get();
- } else if($interval_type == "last_year") {
- $start_time = date('Y-m-d', strtotime("-1 year"));
- $invoice_list = Forms::where('seller_id', $seller_id)->where('created_at', '>=', $start_time)->get();
- }
- foreach ($invoice_list as $invoice) {
- $tmp_ron = Items::where('form_id', $invoice->id)->sum('total_ron');
- $tmp_euro = Items::where('form_id', $invoice->id)->sum('total_eur');
- $tmp = array("total_euro" => $tmp_euro, "total_ron" => $tmp_ron);
- $total_euro += $tmp_euro;
- $total_ron += $tmp_ron;
- array_push($invoice_list_total, $tmp);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement