| Server IP : 66.29.137.217 / Your IP : 3.142.243.141 Web Server : LiteSpeed System : Linux premium294.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : gltevjme ( 1095) PHP Version : 7.0.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/gltevjme/bofirmacademy.com/app/Http/Controllers/Organization/ |
Upload File : |
<?php
namespace App\Http\Controllers\Organization;
use App\Http\Controllers\Controller;
use App\Http\Middleware\Instrucotr;
use App\Models\AffiliateHistory;
use App\Models\BookingHistory;
use App\Models\Course;
use App\Models\CourseInstructor;
use App\Models\Instructor;
use App\Models\Order_item;
use App\Models\RankingLevel;
use App\Models\Student;
use App\Models\User;
use DB;
class DashboardController extends Controller
{
public function dashboard()
{
$data['title'] = 'Dashboard';
//Start:: Cancel Consultation Money Calculation
$cancelConsultationOrderItemIds = BookingHistory::where(['instructor_user_id' => auth()->id(),'status' => BOOKING_HISTORY_STATUS_CANCELLED, 'send_back_money_status' => SEND_BACK_MONEY_STATUS_YES])
->whereYear("created_at", now()->year)->whereMonth("created_at", now()->month)
->whereHas('order', function ($q){
$q->where('payment_status', 'paid');
})->pluck('order_item_id')->toArray();
$consultationOrderItems = Order_item::whereIn('id', $cancelConsultationOrderItemIds);
//End:: Cancel Consultation Money Calculation
$userCourseIds = CourseInstructor::where('instructor_id', auth()->id())->select('course_id')->get()->pluck('course_id')->toArray();
// $userCourseIds = Course::whereUserId(auth()->user()->id)->pluck('id')->toArray();
$orderBundleItemsCount = Order_item::where('owner_user_id', auth()->id())->whereNotNull('bundle_id')->whereNull('course_id')
->whereYear("created_at", now()->year)->whereMonth("created_at", now()->month)
->whereHas('order', function ($q) {
$q->where('payment_status', 'paid');
})->count();
$orderItems = Order_item::whereIn('course_id', $userCourseIds)
->whereYear("created_at", now()->year)->whereMonth("created_at", now()->month)
->whereHas('order', function ($q) {
$q->where('payment_status', 'paid');
});
//Start::Affiliate Earning from AffiliateHistory
$affiliateHistoryTotalCommission = AffiliateHistory::where(['user_id' => auth()->id(), 'status' => AFFILIATE_HISTORY_STATUS_PAID])->sum('commission');
//End::Affiliate Earning from AffiliateHistory
$data['total_earning_this_month'] = $orderItems->sum('owner_balance') + $affiliateHistoryTotalCommission - $consultationOrderItems->sum('owner_balance');
$data['total_enroll_this_month'] = $orderItems->count('id') - $orderBundleItemsCount - count($cancelConsultationOrderItemIds);
$data['best_selling_course'] = Order_item::whereIn('course_id', $userCourseIds)->whereHas('order', function ($q) {
$q->where('payment_status', 'paid');
})->groupBy("course_id")->selectRaw("COUNT(course_id) as total_course_id, course_id")->orderByRaw("COUNT(course_id) DESC")->first();
$data['recentCourses'] = Course::whereIn('id', $userCourseIds)->latest()->limit(2)->get();
$data['updatedCourses'] = Course::whereIn('id', $userCourseIds)->orderBy('updated_at', 'desc')->limit(2)->get();
// Start:: Sale Statistics
$months = collect([]);
$totalPrice = collect([]);
//Start:: Cancel Consultation Money Calculation
$cancelConsultationOrderItemIds = BookingHistory::where(['instructor_user_id' => auth()->id(),'status' => 2, 'send_back_money_status' => SEND_BACK_MONEY_STATUS_YES])
->whereHas('order', function ($q){
$q->where('payment_status', 'paid');
})->pluck('order_item_id')->toArray();
//End
Order_item::whereNotIn('id', $cancelConsultationOrderItemIds)->whereIn('course_id', $userCourseIds)->whereHas('order', function ($q) {
$q->where('payment_status', 'paid');
})->select(DB::raw('SUM(owner_balance) as total'), DB::raw('MONTHNAME(created_at) month'))
->groupby('month')
->get()
->map(function ($q) use ($months, $totalPrice) {
$months->push($q->month);
$totalPrice->push($q->total);
});
$data['months'] = $months;
$data['totalPrice'] = $totalPrice;
//End:: Sale Statistics
//Start:: ranking Level
$allOrderItems = Order_item::whereIn('course_id', $userCourseIds)->whereHas('order', function ($q) {
$q->where('payment_status', 'paid');
});
$organizationId = auth()->user()->organization->id;
$data['grand_total_earning'] = $allOrderItems->sum('owner_balance');
$data['grand_total_enroll'] = $allOrderItems->count('id') - $orderBundleItemsCount;
$data['totalCourse'] = count($userCourseIds);
$data['totalInstructor'] = Instructor::where('organization_id', $organizationId)->count();
$data['totalStudent'] = Student::where('organization_id', $organizationId)->count();
$topSellersDetails = User::join('instructors', 'instructors.user_id', 'users.id')
->join('course_instructor', 'course_instructor.instructor_id', '=', 'users.id')
->join('courses', 'courses.id', '=', 'course_instructor.course_id')
->join('order_items', 'courses.id', '=', 'order_items.course_id')
->join('orders', 'order_items.order_id', '=', 'orders.id')
->whereMonth('order_items.created_at', date('m'))
->where('orders.payment_status', 'paid')
->where('courses.organization_id', $organizationId)
->select('users.name', \DB::raw("SUM(order_items.owner_balance*course_instructor.share*0.01) as totalAmount"))
->groupBy('users.id')
->orderBy('totalAmount', 'desc')
->take(5)->get();
$data['allName'] = $topSellersDetails->pluck('name')->toArray();
$allPercentage = $topSellersDetails->pluck('totalAmount');
$data['allPercentage'] = $allPercentage->map(function($item){
return $item == NULL ? 0 : (float)$item;
});
return view('organization.dashboard', $data);
}
public function rankingLevelList()
{
$data['title'] = 'Dashboard';
$data['navDashboardActiveClass'] = 'active';
$data['levels'] = RankingLevel::orderBy('serial_no', 'asc')->get();
return view('organization.ranking-badge-list', $data);
}
}