File: /var/www/html/spion/app/Http/Controllers/PlanController.php
<?php
namespace App\Http\Controllers;
use App\Models\Plan;
use App\Models\PricingPlanFeature;
use App\Models\PlanFeature;
use Yajra\DataTables\Facades\DataTables;
// use Validator;
use Illuminate\Validation\Rule;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\Facades\Storage;
use Illuminate\Support\Facades\Validator;
class PlanController extends Controller
{
/**
* Display a listing of the resource.
*/
public function index(Request $request)
{
if ($request->ajax()) {
$search_keyword = '';
$status = 'all'; // all status
$request_data = $request->all();
if ($request->has('search_keyword')) {
$search_keyword = $request->search_keyword;
}
if ($request->has('status_filter')) {
$status = $request->status_filter;
}
// avoid zero column as it's checkbox so we can't sort by it
if ($request->has('order') && $request->order[0]['column'] != 0) {
$sort_column_number = $request->order[0]['column'];
$sort_column_dir = $request->order[0]['dir'];
$sort_column_key = $request->columns[$sort_column_number]['data'];
}
$main_query = Plan::query()->with('planFeature');
$query = $main_query;
if (!empty($search_keyword)) {
$query = $query->where('name', 'LIKE', '%' . $search_keyword . '%');
}
if ($status != 'all' && $status != '') {
$query = $query->where('status', $status);
}
if (!empty($sort_column_key)) {
$query = $query->orderBy($sort_column_key, $sort_column_dir);
} else {
$query = $query->latest();
}
$data = $query->get();
$count_total = $main_query->count();
$count_filter = $count_total;
return DataTables::of($data)
->addColumn('image', function ($row) {
if ($row->icon) {
return '<img src="' . asset('storage/images/' . $row->icon) . '" alt="Plan Image" width="50" height="50">';
}
// return null;
return '<img src="' . asset('storage/images/default-image.jpg') . '" alt="No Image" width="50" height="50">';
})
// ->addColumn('icon', function ($row) {
// return $row->icon;
// })
->addColumn('name', function ($row) {
return $row->name;
})
->addColumn('key', function ($row) {
return $row->key;
})
->addColumn('description', function ($row) {
return $row->description;
})
->addColumn('interval', function ($row) {
return $row->interval;
})
->addColumn('price', function ($row) {
return $row->price;
})
->addColumn('trial_days', function ($row) {
return $row->trial_days;
})
->addColumn('is_test', function ($row) {
return $row->is_test;
})
->addColumn('pricing_plan_features', function ($row) {
if (!empty($row->features) && $row->features->count() > 0) {
$featureTitles = $row->features->map(function ($features) {
return $features->pricingPlanFeature->title;
});
return $featureTitles->implode(', ');
}
return 'error';
})
// ->addColumn('pricing_plan_features', function ($row) {
// if (!empty($row->planFeature->pricingPlanFeature)) {
// return $row->planFeature->pricingPlanFeature->title;
// }
// return 'error';
// })
->editColumn('status', function ($row) {
$update_url = route('admin.update.plans.status', $row->id);
return setStatus($row, $update_url);
})
->addColumn('action', function ($row) {
return view('admin.plan.partially.delete', compact('row'));
})
->rawColumns(['action', 'status','image'])
->with([
"recordsTotal" => $count_total,
"recordsFiltered" => $count_filter,
])
->make(true);
}
return view('admin.plan.index');
}
/**
* Show the form for creating a new resource.
*/
public function create()
{
$pricingPlans = PricingPlanFeature::all();
// dd($pricingPlans);
return view('admin.plan.create', compact('pricingPlans'));
}
/**
* Store a newly created resource in storage.
*/
public function store(Request $request)
{
// dd($request->all());
$validator = Validator::make($request->all(), [
'image' => 'required|image|mimes:jpeg,png,jpg,gif|max:2048',
// 'icon' => 'required|string',
'name' => 'required|string',
'key' => ['required', 'string', 'unique:' . Plan::class],
'description' => 'nullable|string',
'interval' => 'required|in:day,week,month,year',
'price' => 'required|numeric|min:0',
'trial_days' => 'nullable|integer|min:0',
'status' => 'required|boolean',
// 'features' => 'required|exists:pricing_plan_features,id',
'features' => 'required|array', // Ensures it's an array
'features.*' => 'exists:pricing_plan_features,id', // Validates each feature
]);
if ($validator->fails()) {
return redirect()->back()->withErrors($validator)->withInput();
}
DB::beginTransaction();
try {
$plans = new Plan();
if ($request->hasFile('image')) {
$filenameWithExt = $request->file('image')->getClientOriginalName();
$filename = pathinfo($filenameWithExt, PATHINFO_FILENAME);
$extension = $request->file('image')->getClientOriginalExtension();
$fileNameToStore = $filename.'_'.time().'.'.$extension;
$path = $request->file('image')->storeAs('public/images', $fileNameToStore);
$plans->icon = $fileNameToStore;
}
// $plans->icon = $request->input('icon');
$plans->name = $request->input('name');
$plans->key = $request->input('key');
$plans->description = $request->input('description');
$plans->interval = $request->input('interval');
$plans->price = $request->input('price');
$plans->trial_days = $request->input('trial_days');
$plans->is_test = $request->has('is_test') ? 1 : 0;
// $plans->is_test = $request->input('is_test');
$plans->status = $request->input('status');
$plans->save();
foreach ($request->input('features') as $featureId) {
$planFeature = new PlanFeature();
$planFeature->plan_id = $plans->id;
$planFeature->subscription_features_id = $featureId;
$planFeature->save();
}
// $planFeature = new PlanFeature();
// $planFeature->plan_id = $plans->id;
// $planFeature->subscription_features_id = $request->input('features');
// $planFeature->save();
DB::commit();
return redirect()->route('plans.index')->with('success', 'Plans Add Successfully');
} catch (\Exception $e) {
DB::rollback();
return response()->json(['success' => false, 'message' => $e->getMessage()]);
}
}
/**
* Display the specified resource.
*/
public function show(string $id)
{
//
}
/**
* Show the form for editing the specified resource.
*/
public function edit(string $id)
{
$plans = Plan::find($id);
$pricingPlans = PricingPlanFeature::all();
if ($plans) {
// Get the IDs of the features currently associated with the plan
$selectedFeatures = PlanFeature::where('plan_id', $id)->pluck('subscription_features_id')->toArray();
return view('admin.plan.edit', [
'plans' => $plans,
'pricingPlans' => $pricingPlans,
'selectedFeatures' => $selectedFeatures
]);
} else {
return back()->with('error', 'Plan does not exist');
}
// $plans = Plan::find($id);
// $pricingPlans = PricingPlanFeature::all();
// if (isset($plans)) {
// return view('admin.plan.edit', ['plans' => $plans, 'pricingPlans' => $pricingPlans]);
// } else {
// return back()->with('error', 'Plans does not exist');
// }
}
/**
* Update the specified resource in storage.
*/
public function update(Request $request, string $id)
{
// dd($request->all());
$validator = Validator::make($request->all(), [
'image' => 'required|image|mimes:jpeg,png,jpg,gif',
'name' => 'required|string',
'key' => ['required', 'string', Rule::unique('plans')->ignore($id)],
'description' => 'nullable|string',
'interval' => 'required|in:day,week,month,year',
'price' => 'required|numeric|min:0',
'trial_days' => 'nullable|integer|min:0',
'status' => 'required|boolean',
// 'features' => 'required|exists:pricing_plan_features,id',
'features' => 'required|array', // Ensures it's an array
'features.*' => 'exists:pricing_plan_features,id',
]);
if ($validator->fails()) {
return redirect()->back()->withErrors($validator)->withInput();
}
DB::beginTransaction();
try {
$plans = Plan::find($id);
if ($plans) {
// If a new image is uploaded, process it
if ($request->hasFile('image')) {
// Delete the old image if it exists
if ($plans->icon) {
Storage::delete('public/images/' . $plans->icon);
}
// Store the new image
$filenameWithExt = $request->file('image')->getClientOriginalName();
$filename = pathinfo($filenameWithExt, PATHINFO_FILENAME);
$extension = $request->file('image')->getClientOriginalExtension();
$fileNameToStore = $filename . '_' . time() . '.' . $extension;
$path = $request->file('image')->storeAs('public/images', $fileNameToStore);
$plans->icon = $fileNameToStore;
}
// Update other fields
$plans->name = $request->input('name');
$plans->key = $request->input('key');
$plans->description = $request->input('description');
$plans->interval = $request->input('interval');
$plans->price = $request->input('price');
$plans->trial_days = $request->input('trial_days');
$plans->is_test = $request->has('is_test') ? 1 : 0;
$plans->status = $request->input('status');
$plans->save();
// Clear existing features and attach new ones
PlanFeature::where('plan_id', $plans->id)->delete();
foreach ($request->input('features') as $featureId) {
$planFeature = new PlanFeature();
$planFeature->plan_id = $plans->id;
$planFeature->subscription_features_id = $featureId;
$planFeature->save();
}
DB::commit();
return redirect()->route('plans.index')->with('success', 'Plan updated successfully');
} else {
return back()->with('error', 'Plan does not exist');
}
} catch (\Exception $e) {
DB::rollback();
return response()->json(['success' => false, 'message' => $e->getMessage()]);
}
}
/**
* Remove the specified resource from storage.
*/
public function destroy(string $id)
{
$plans = Plan::find($id);
if (isset($plans)) {
DB::beginTransaction();
try {
// Check if the image exists and delete the image file
if ($plans->image) {
$imagePath = 'public/images/' . $plans->image;
// Delete the image file if it exists
if (Storage::disk('public')->exists($imagePath)) {
Storage::disk('public')->delete($imagePath);
}
}
// Delete the plan from the database
$plans->delete();
DB::commit();
return redirect()->back()->with('success', 'Plan has been deleted successfully.');
} catch (\Exception $e) {
DB::rollback();
return back()->with('error', 'An error occurred while deleting the plan: ' . $e->getMessage());
}
} else {
return back()->with('error', 'Plan does not exist.');
}
}
// public function destroy(string $id)
// {
// $plans = Plan::find($id);
// if (isset($plans)) {
// $plans->delete();
// return redirect()->back()->with('success', 'Plans has been deleted successfully.');
// } else {
// return back()->with('error', 'Plans does not exist');
// }
// }
public function updatePlansStatus(Request $request, $id)
{
if ($request->has('new_status')) {
$plans = Plan::find($id);
if ($plans) {
$plans->status = $request->new_status;
$plans->save();
return response()->json(['status' => 'success', 'message' => 'Plans status updated successfully']);
} else {
return response()->json(['status' => 'error', 'message' => 'Plans not found'], 404);
}
} else {
return response()->json(['status' => 'error', 'message' => 'Missing status value'], 404);
}
}
}