| Server IP : 66.29.137.217 / Your IP : 3.147.28.158 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/gle.gltechlimited.com/app/Http/Controllers/ |
Upload File : |
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Order;
use DB;
use App\Setting;
use App\Course;
use App\User;
use Auth;
use Redirect;
use PDF;
use App\Currency;
use App\BundleCourse;
use Session;
use Crypt;
use App\RefundCourse;
use App\RefundPolicy;
use Illuminate\Support\Facades\Log;
use App\InvoiceDesign;
use Rap2hpoutre\FastExcel\FastExcel;
use Spatie\Permission\Models\Role;
class OrderController extends Controller
{
public function __construct()
{
$this->middleware('permission:orders.manage', ['only' => ['index','enrollUser','create','store','destroy','vieworder','status','order_report']]);
}
public function index()
{
$refunds = RefundCourse::get();
$orders = Order::whereHas('courses')->orWhereHas('bundle')->orderBy('id','DESC')->get();
return view('admin.order.show', compact('orders', 'refunds'));
}
public function enrollUser($user_id)
{
Log::debug('<==enrollUser');
if (!isset($user_id)) {
return redirect('order/create');
}
$users = User::all();
$selectedUser = User::findOrFail($user_id);
Log::debug('Fetching user course details: ' . $selectedUser);
$orders = Order::where('user_id', $user_id)->get();
$enrolledCourses = [];
$enrolledBundles = [];
$enrolledCourseIds = [];
$enrolledBundleIds = [];
foreach ($orders as $order) {
if ($order->course_id !== null) {
array_push($enrolledCourseIds, $order->course_id);
array_push($enrolledCourses, $order->courses);
} else {
array_push($enrolledBundleIds, $order->bundle_id);
array_push($enrolledBundles, $order->bundle);
}
}
$courses = Course::all()->whereNotIn('id', $enrolledCourseIds);
$bundles = BundleCourse::all()->whereNotIn('id', $enrolledBundleIds);
Log::debug('==>enrollUser');
return view('admin.order.create', compact('users', 'courses', 'bundles', 'enrolledCourses', 'enrolledBundles', 'selectedUser'));
}
public function create()
{
$users = User::all();
if(Auth::user()->role == 'admin')
{
$courses = Course::get();
$bundles = BundleCourse::get();
}
else
{
$courses = Course::where('user_id', Auth::user()->id)->get();
$bundles = BundleCourse::where('user_id', Auth::user()->id)->get();
}
return view('admin.order.create', compact('users', 'courses', 'bundles'));
}
public function store(Request $request)
{
if (!isset($request->course_id) && !isset($request->bundle_id)) {
Session::flash('delete', trans('flash.CourseRequired'));
return redirect('order/create');
}
$subscription_status=null;
if (isset($request->bundle_id)) {
$selectedBundle = BundleCourse::findOrFail($request->bundle_id);
if($selectedBundle->is_subscription_enabled) {
$subscription_status = 'active';
}
$bundle = BundleCourse::where('id', $request->bundle_id)->first();
$created_bundle = Order::create([
'bundle_id' => $request->bundle_id,
'user_id' => $request->user_id,
'instructor_id' => $bundle->user_id,
'subscription_status'=>$subscription_status,
'payment_method' => 'Admin Enroll',
'created_at' => \Carbon\Carbon::now()->toDateTimeString(),
]);
Log::debug('order created successful'. $created_bundle);
}
if (isset($request->course_id)) {
$course = Course::where('id', $request->course_id)->first();
$created_course = Order::create([
'course_id' => $request->course_id,
'user_id' => $request->user_id,
'instructor_id' => $course->user_id,
'payment_method' => 'Admin Enroll',
'created_at' => \Carbon\Carbon::now()->toDateTimeString(),
]);
Log::debug('order created successful'. $created_course);
}
Session::flash('success', trans('flash.EnrolledSuccessfully'));
return redirect('order');
}
public function destroy($id)
{
DB::table('orders')->where('id',$id)->delete();
DB::table('pending_payouts')->where('order_id',$id)->delete();
return back();
}
public function vieworder($id)
{
$setting = Setting::first();
$show = Order::where('id', $id)->first();
$bundle_order = BundleCourse::where('id', $show->bundle_id)->first();
return view('admin.order.view', compact('show', 'setting', 'bundle_order'));
}
public function purchasehistory()
{
$course = Course::get();
if(Auth::check())
{
$orders = Order::where('refunded', '0')->where('user_id', Auth::user()->id)->get();
$refunds = RefundCourse::where('user_id', Auth::user()->id)->get();
$setting = Setting::first();
if($setting->theme == '1'){
return view('front.purchase_history.purchase',compact('orders', 'course', 'refunds'));
}
return view('quedecato.front.purchase_history.purchase',compact('orders', 'course', 'refunds'));
}
return Redirect::route('login')->withInput()->with('delete', trans('flash.PleaseLogin'));
}
public function invoice($id)
{
$course = Course::all();
$Bundle = BundleCourse::all();
$orders = Order::where('id', $id)->first();
$bundle_order = BundleCourse::where('id', $orders->bundle_id)->first();
$invoice = InvoiceDesign::first();
if(Auth::check())
{
$setting = Setting::first();
if($setting->theme == '1'){
return view('front.purchase_history.invoice',compact('orders', 'course', 'Bundle', 'bundle_order', 'invoice'));
}
}
return view('quedecato.front.purchase_history.invoice', compact('orders', 'course', 'Bundle', 'bundle_order', 'invoice'));
return Redirect::route('login')->withInput()->with('delete', trans('flash.PleaseLogin'));
}
public function pdfdownload($id){
$course = Course::all();
$orders = Order::where('id', $id)->first();
$bundle_order = BundleCourse::where('id', $orders->bundle_id)->first();
$invoice = InvoiceDesign::first();
$stylesheet = file_get_contents('css/bootstrap.min.css');
$pdf = PDF::loadView('front.purchase_history.download', compact('orders','course', 'bundle_order', 'invoice'), [],
[
'title' => 'Invoice',
'orientation' => 'L'
]
);
return $pdf->download('invoice.pdf');
// return $pdf->stream();
}
public function apiinvoicepdfdownload($id)
{
$course = Course::all();
$orders = Order::where('id', $id)->first();
if($orders->bundle_id != NULL)
{
$bundle_order = BundleCourse::where('id', $orders->bundle_id)->first();
}
else{
$bundle_order = NULL;
}
$invoice = InvoiceDesign::first();
$stylesheet = file_get_contents('css/bootstrap.min.css');
$pdf = PDF::loadView('front.purchase_history.download', compact('orders','course', 'bundle_order','invoice'), [],
[
'title' => 'Invoice',
'orientation' => 'L'
]
);
return $pdf->download('invoice.pdf');
}
public function refundview($id)
{
$ids = Crypt::decrypt($id);
$order = Order::where('id', $ids)->first();
$cor = $order->course_id;
$course = Course::where('id', $cor)->first();
$policy = RefundPolicy::where('id', $course->refund_policy_id)->first();
if(Auth::check())
{
return view('front.purchase_history.refund',compact('order', 'policy'));
}
return Redirect::route('login')->withInput()->with('delete', trans('flash.PleaseLogin'));
}
public function refundrequest(Request $request, $id)
{
// return $request;
$ids = Crypt::decrypt($id);
$order = Order::where('id', $ids)->first();
$currency = Currency::where('default', '=', '1')->first();
if($request->refund_mode == "bank")
{
$user_bank_id = $request->bank_id;
$payment_method = "BankTransfer";
}
else{
$user_bank_id = NULL;
$payment_method = $order->payment_method;
}
$created_refund = RefundCourse::create([
'user_id' => Auth::user()->id,
'course_id' => $order->course_id,
'order_id' => $order->id,
'instructor_id' => $order->instructor_id,
'payment_method' => $payment_method,
'total_amount' => $order->total_amount,
'status' => 0,
'reason' => $request->reason,
'detail' => $request->detail,
'currency' => $order['currency'],
'currency_icon' => $order->currency_icon,
'bank_id' => $user_bank_id,
'created_at' => \Carbon\Carbon::now()->toDateTimeString(),
'updated_at' => \Carbon\Carbon::now()->toDateTimeString(),
]
);
$created_refund->ref_id = 'REF'.$created_refund->id.$created_refund->order_id;
$created_refund->save();
return redirect('all/purchase')->with('success', trans('flash.RequestSuccessfully'));
}
public function confirmation()
{
return view('front.purchase_history.confirmation');
}
public function status(Request $request)
{
$pages = Order::find($request->id);
$pages->status = $request->status;
$pages->save();
return response()->json($request->all());
return redirect('page');
}
public function fileImportExport()
{
$orders = Order::whereHas('courses')->with(['courses:id,title'])->where('proof','!=' ,NUll)->get();
$filename = now()->format('d-m-Y').'.xlsx';
$down = (new FastExcel($orders))->export($filename, function ($order) {
return [
'Id' => $order->id,
'Course Name' => $order->courses->title,
'User Name' => $order->user->fname,
'Order Id' => $order->order_id,
'Payment Method' => $order->payment_method,
'Transaction Id' => $order->transaction_id,
'Currency Icon' => $order->currency_icon,
'Amount' => $order->total_amount,
];
});
$file = file_get_contents(public_path().'/'.$filename);
ob_end_clean();
$response = response($file, 200, [
'Content-Disposition' => 'attachment; filename="'.$filename.'"',
]);
// unlink(public_path().'/'.$filename);
return $response;
}
public function order_report()
{
$order_total = array(
Order::where('instructor_id',Auth::user()->id)->whereMonth('created_at', '01')
->whereYear('created_at', date('Y'))->sum('total_amount'),
Order::where('instructor_id',Auth::user()->id)->whereMonth('created_at', '02')
->whereYear('created_at', date('Y'))->sum('total_amount'),
Order::where('instructor_id',Auth::user()->id)->whereMonth('created_at', '03')
->whereYear('created_at', date('Y'))->sum('total_amount'),
Order::where('instructor_id',Auth::user()->id)->whereMonth('created_at', '04')
->whereYear('created_at', date('Y'))->sum('total_amount'),
Order::where('instructor_id',Auth::user()->id)->whereMonth('created_at', '05')
->whereYear('created_at', date('Y'))->sum('total_amount'),
Order::where('instructor_id',Auth::user()->id)->whereMonth('created_at', '06')
->whereYear('created_at', date('Y'))->sum('total_amount'),
Order::where('instructor_id',Auth::user()->id)->whereMonth('created_at', '07')
->whereYear('created_at', date('Y'))->sum('total_amount'),
Order::where('instructor_id',Auth::user()->id)->whereMonth('created_at', '08')
->whereYear('created_at', date('Y'))->sum('total_amount'),
Order::where('instructor_id',Auth::user()->id)->whereMonth('created_at', '09')
->whereYear('created_at', date('Y'))->sum('total_amount'),
Order::where('instructor_id',Auth::user()->id)->whereMonth('created_at', '10')
->whereYear('created_at', date('Y'))->sum('total_amount'),
Order::where('instructor_id',Auth::user()->id)->whereMonth('created_at', '11')
->whereYear('created_at', date('Y'))->sum('total_amount'),
Order::where('instructor_id',Auth::user()->id)->whereMonth('created_at', '12')
->whereYear('created_at', date('Y'))->sum('total_amount')
);
$order_data = Order::select(DB::raw('DATE_FORMAT(created_at, "%M") as month'), DB::raw('count(*) as count'), DB::raw('SUM(total_amount) as total_amount'))
->whereYear('created_at',date('Y'))
->where('refunded',0)
->where('instructor_id',Auth::user()->id)
->groupBy(DB::raw("Month(created_at)"))
->groupBy(DB::raw("YEAR(created_at)"))
->get();
return view('admin.report.ordertotal',compact('order_total','order_data'));
}
}