public function isDoctorVisited($doctorId, $date)
{
$visited = AMReport::where('am_id', \Auth::user()->id)->where('doctor_id', $doctorId)->where('date', '>=', $date)->count();
if ($visited > 0) {
return true;
}
}
public function doAMSearch(AMSalesSearchRequest $request)
{
$productSales = [];
$from = $request->date_from;
$to = $request->date_to;
$product = $request->product;
$doctor = $request->doctor;
$AM = $request->am;
$allSearchedReport = AMReport::select('id')->where('date', '>=', $from)->where('date', '<=', $to);
if (!empty($AM)) {
$allSearchedReport = $allSearchedReport->where('am_id', $AM);
}
if (!empty($doctor)) {
$allSearchedReport = $allSearchedReport->where('doctor_id', $doctor);
}
$searchResult = AMReportSoldProduct::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 = ['productSales' => $productSales];
\Session::flash('date_from', $from);
\Session::flash('date_to', $to);
\Session::flash('productSales', $productSales);
return view('admin.search.sales.result', $dataView);
}
public function index()
{
$employees = Employee::select('line_id')->where('manager_id', \Auth::user()->id)->get();
$products = Product::whereIn('line_id', $employees)->get();
$employees = Employee::select('id')->where('manager_id', \Auth::user()->id)->get();
$customers = Customer::whereIn('mr_id', $employees)->get();
$employees = Employee::where('manager_id', \Auth::user()->id)->get();
$dataView = ['productsCount' => count($products), 'plansCount' => AMPlan::where('month', \Config::get('app.current_month'))->count(), 'reportsCount' => AMReport::where('month', \Config::get('app.current_month'))->count(), 'customersCount' => count($customers), 'employeesCount' => count($employees)];
return view('am.index', $dataView);
}
public function singleReport($level, $id, $type)
{
if ($level == 'sm') {
$singleReport = SMReport::findOrFail($id);
} elseif ($level == 'am') {
$singleReport = AMReport::findOrFail($id);
} elseif ($level == 'mr') {
$singleReport = Report::findOrFail($id);
}
\Excel::create('report-' . $level . '-' . $singleReport->emp->name . '-' . $singleReport->date, function ($excel) use($singleReport) {
$excel->sheet('report', function ($sheet) use($singleReport) {
$sheet->setAllBorders('thin');
$sheet->loadView('admin.export.single_report')->with('singleReport', $singleReport);
});
})->export($type);
}
public function singleAM($id)
{
$singleReport = AMReport::findOrFail($id);
$singleReport['promotedProducts'] = AMReportPromotedProduct::select('product_id')->where('report_id', $singleReport->id)->get();
$singleReport['sampleProducts'] = AMReportSampleProduct::select('product_id')->where('report_id', $singleReport->id)->get();
$singleReport['gifts'] = AMReportGift::select('gift_id')->where('report_id', $singleReport->id)->get();
$singleReport['soldProducts'] = AMReportSoldProduct::select('product_id', 'quantity')->where('report_id', $singleReport->id)->get();
$dataView = ['singleReport' => $singleReport];
return view('sm.report.single', $dataView);
}
