<?php
namespace App\Http\Controllers\Admin;
use App\CentralLogics\Helpers;
use App\Http\Controllers\Controller;
use App\Model\Admin;
use App\Model\Branch;
use App\Model\Brand;
use App\Model\Category;
use App\Model\Order;
use App\Model\OrderDetail;
use App\Model\Product;
use App\Model\Review;
use App\Model\SellerWalletHistory;
use App\Model\Shop;
use App\User;
use Brian2694\Toastr\Facades\Toastr;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class SystemController extends Controller
{
public function dashboard()
{
$top_sell = OrderDetail::with(['product'])
->select('product_id', DB::raw('SUM(quantity) as count'))
->groupBy('product_id')
->orderBy("count", 'desc')
->take(6)
->get();
$most_rated_products = Product::rightJoin('reviews', 'reviews.product_id', '=', 'products.id')
->groupBy('product_id')
->select(['product_id',
DB::raw('AVG(reviews.rating) as ratings_average'),
DB::raw('count(*) as total')
])
->orderBy('total', 'desc')
->take(6)
->get();
$top_customer = Order::with(['customer'])
->select('user_id', DB::raw('COUNT(user_id) as count'))
->groupBy('user_id')
->orderBy("count", 'desc')
->take(6)
->get();
$data = self::order_stats_data();
$data['customer'] = User::count();
$data['product'] = Product::count();
$data['order'] = Order::count();
$data['category'] = Category::count();
$data['branch'] = Branch::count();
$data['top_sell'] = $top_sell;
$data['most_rated_products'] = $most_rated_products;
$data['top_customer'] = $top_customer;
$earning=[];
for ($i=1;$i<=12;$i++){
$from = date('Y-'.$i.'-01');
$to = date('Y-'.$i.'-30');
$earning[$i] = Order::where(['order_status'=>'delivered'])->whereBetween('created_at', [$from, $to])->sum('order_amount');
}
return view('admin-views.dashboard', compact('data', 'earning'));
}
public function order_stats(Request $request)
{
session()->put('statistics_type', $request['statistics_type']);
$data = self::order_stats_data();
return response()->json([
'view' => view('admin-views.partials._dashboard-order-stats', compact('data'))->render()
], 200);
}
public function order_stats_data() {
$today = session()->has('statistics_type') && session('statistics_type') == 'today' ? 1 : 0;
$this_month = session()->has('statistics_type') && session('statistics_type') == 'this_month' ? 1 : 0;
$pending = Order::where(['order_status' => 'pending'])
->when($today, function ($query) {
return $query->whereDate('created_at', Carbon::today());
})
->when($this_month, function ($query) {
return $query->whereMonth('created_at', Carbon::now());
})
->count();
$confirmed = Order::where(['order_status' => 'confirmed'])
->when($today, function ($query) {
return $query->whereDate('created_at', Carbon::today());
})
->when($this_month, function ($query) {
return $query->whereMonth('created_at', Carbon::now());
})
->count();
$processing = Order::where(['order_status' => 'processing'])
->when($today, function ($query) {
return $query->whereDate('created_at', Carbon::today());
})
->when($this_month, function ($query) {
return $query->whereMonth('created_at', Carbon::now());
})
->count();
$out_for_delivery = Order::where(['order_status' => 'out_for_delivery'])
->when($today, function ($query) {
return $query->whereDate('created_at', Carbon::today());
})
->when($this_month, function ($query) {
return $query->whereMonth('created_at', Carbon::now());
})
->count();
$delivered = Order::where(['order_status' => 'delivered'])
->when($today, function ($query) {
return $query->whereDate('created_at', Carbon::today());
})
->when($this_month, function ($query) {
return $query->whereMonth('created_at', Carbon::now());
})
->count();
$all = Order::all()->count();
$returned = Order::where(['order_status' => 'returned'])
->when($today, function ($query) {
return $query->whereDate('created_at', Carbon::today());
})
->when($this_month, function ($query) {
return $query->whereMonth('created_at', Carbon::now());
})
->count();
$failed = Order::where(['order_status' => 'failed'])
->when($today, function ($query) {
return $query->whereDate('created_at', Carbon::today());
})
->when($this_month, function ($query) {
return $query->whereMonth('created_at', Carbon::now());
})
->count();
$data = [
'pending' => $pending,
'confirmed' => $confirmed,
'processing' => $processing,
'out_for_delivery' => $out_for_delivery,
'delivered' => $delivered,
'all' => $all,
'returned' => $returned,
'failed' => $failed
];
return $data;
}
public function restaurant_data()
{
$new_order = DB::table('orders')->where(['checked' => 0])->count();
return response()->json([
'success' => 1,
'data' => ['new_order' => $new_order]
]);
}
public function settings()
{
return view('admin-views.settings');
}
public function settings_update(Request $request)
{
$request->validate([
'f_name' => 'required',
'l_name' => 'required',
'email' => 'required',
'phone' => 'required',
], [
'f_name.required' => 'First name is required!',
'l_name.required' => 'Last name is required!',
]);
$admin = Admin::find(auth('admin')->id());
$admin->f_name = $request->f_name;
$admin->l_name = $request->l_name;
$admin->email = $request->email;
$admin->phone = $request->phone;
$admin->image = $request->has('image') ? Helpers::update('admin/', $admin->image, 'png', $request->file('image')) : $admin->image;
$admin->save();
Toastr::success('Admin updated successfully!');
return back();
}
public function settings_password_update(Request $request)
{
$request->validate([
'password' => 'required|same:confirm_password|min:8',
'confirm_password' => 'required',
]);
$admin = Admin::find(auth('admin')->id());
$admin->password = bcrypt($request['password']);
$admin->save();
Toastr::success('Admin password updated successfully!');
return back();
}
}