public function doSearch(SalesSearchRequest $request) { $productSales = []; $from = date('Y-m-d', strtotime($request->date_from)); $to = date('Y-m-d', strtotime($request->date_to)); $product = $request->product; $doctor = $request->doctor; $allSearchedReport = Report::select('id')->where('date', '>=', $from)->where('date', '<=', $to); if (!empty($MR)) { $allSearchedReport = $allSearchedReport->where('mr_id', \Auth::user()->id); } if (!empty($doctor)) { $allSearchedReport = $allSearchedReport->where('doctor_id', $doctor); } $searchResult = ReportSoldProduct::whereIn('report_id', $allSearchedReport->get()); if (!empty($product)) { $searchResult->where('product_id', $product); } foreach ($searchResult->get() as $singleResult) { if (isset($productSales[$singleResult->product->name])) { $productSales[$singleResult->product->name] += $singleResult->quantity; } else { $productSales[$singleResult->product->name] = $singleResult->quantity; } } $dataView = ['searchResult' => $productSales]; \Session::flash('date_from', $from); \Session::flash('date_to', $to); \Session::flash('productSales', $productSales); return view('mr.search.sales.result', $dataView); }
public static function test() { $mrId = '3'; $currentMonth = 'Dec-2015'; $totalSoldProductsSales = []; $totalSoldProductsSalesPrice = 0; $reportsId = Report::select('id')->where('month', $currentMonth)->where('mr_id', $mrId)->get()->toArray(); $allSoldProducts = ReportSoldProduct::whereIn('report_id', $reportsId)->get(); foreach ($allSoldProducts as $singleReportProducts) { $productName = $singleReportProducts->product->name; $productPrice = $singleReportProducts->product->unit_price; $quantity = $singleReportProducts->quantity; $totalSoldProductsSalesPrice += $quantity * $productPrice; if (isset($totalSoldProductsSales[$productName])) { $totalSoldProductsSales[$productName] += $quantity; } else { $totalSoldProductsSales[$productName] = $quantity; } } return ['totalSoldProductsSales' => $totalSoldProductsSales, 'totalSoldProductsSalesPrice' => $totalSoldProductsSalesPrice]; print_r($totalSoldProductsSales); print_r($totalSoldProductsSalesPrice); }
public function singleMR($id) { $singleReport = Report::findOrFail($id); $singleReport['promotedProducts'] = ReportPromotedProduct::select('product_id')->where('report_id', $singleReport->id)->get(); $singleReport['sampleProducts'] = ReportSampleProduct::select('product_id')->where('report_id', $singleReport->id)->get(); $singleReport['gifts'] = ReportGift::select('gift_id')->where('report_id', $singleReport->id)->get(); $singleReport['soldProducts'] = ReportSoldProduct::select('product_id', 'quantity')->where('report_id', $singleReport->id)->get(); $dataView = ['singleReport' => $singleReport]; return view('sm.report.single', $dataView); }