| Server IP : 66.29.137.217 / Your IP : 3.145.125.13 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 App\Package;
use App\Plan;
use App\User;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class PlanController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index(Request $request)
{
$data = DB::table('paypal_subscriptions')
->select('paypal_subscriptions.user_id', 'paypal_subscriptions.package_id', 'paypal_subscriptions.subscription_to')
->join('users', 'users.id', '=', 'paypal_subscriptions.user_id')
->join('packages', 'packages.id', '=', 'paypal_subscriptions.package_id')->get();
$x = count($data);
if ($request->ajax()) {
return \Datatables::of($data)
->addIndexColumn()
->setRowClass(function ($row) {
$today_date = date("Y-m-d");
$today_time = date('h:i');
$endtime = date('h:i', strtotime($row->subscription_to));
$subscription_to = date('Y-m-d', strtotime($row->subscription_to));
if ($today_date <= $subscription_to && $today_time == $endtime) {
return "success";
} else {
return "warning";
}
})
->addColumn('useremail', function ($row) {
$usee = User::where('id', $row->user_id)->first();
return $usee->email;
})
->addColumn('username', function ($row) {
$usename = User::where('id', $row->user_id)->first();
return $usename->name;
})
->addColumn('planname', function ($row) {
$packagename = Package::where('id', $row->package_id)->first();
if (isset($packagename)) {
return $packagename->name;
} else {
return 'free';
}
})
->addColumn('subscription_to', function ($row) {
return date('F d, Y', strtotime($row->subscription_to));
})
->editColumn('action', function ($row) {
$usename = User::where('id', $row->user_id)->first();
$html = '<div class="admin-table-action-block">
<a href="' . route('change_subscription_show', $usename->id) . '" data-toggle="tooltip" data-original-title="' . __('ChangeSubscription') . '" class="btn btn-round btn-outline-primary"><i class="fa fa-exchange"></i></a>
</div>';
return $html;
})
->rawColumns(['planname', 'action', 'subscription_to', 'useremail', 'username'])
->make(true);
}
return view('admin.plan.index');
}
/**
* Show the form for editing the specified resource.
*
* @param \App\plan $plan
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$plan = Plan::findOrFail($id);
return view('admin.users_plan.edit', compact('plan'));
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param \App\plan $plan
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$plan = Plan::findOrFail($id);
$request->validate([
'name' => 'required',
'image' => 'nullable|image|mimes:jpeg,png,jpg',
'email' => 'required|email',
'role' => 'nullable',
'confirm_password' => 'same:password',
]);
$input = $request->except('confirm_password');
if ($request->password !== '' || $request->password != null) {
$input['password'] = bcrypt($request->password);
}
if (!isset($input['is_admin'])) {
$input['is_admin'] = 0;
}
if ($file = $request->file('image')) {
$name = 'user_' . $file->getClientOriginalName();
if ($plan->image != '') {
unlink(public_path() . '/images/users/' . $plan->image);
}
$file->move('images/plan', $name);
$input['image'] = $name;
}
$plan->update($input);
return redirect('admin/plan')->with('success', __('User has been updated'));
}
/**
* Remove the specified resource from storage.
*
* @param \App\plan $plan
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$plan = Plan::findOrFail($id);
$plan->delete();
return back()->with('deleted', __('plan has been deleted'));
}
}