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/Products

Free Space:

1.9 TB

🔧 Quick Actions

✏️ Editing: ProductsController.php

<?php
namespace App\Http\Controllers\Admin\Products;
use File;
use Image;
use Session;
use Exception;
use PDOException;
use App\Models\Ads;
use App\Models\User;
use App\Models\Brand;
use App\Models\Product;
use App\Models\Setting;
use App\Models\Categorie;
use App\Models\Userdevice;
use App\Models\ProductImage;
use App\Models\UserNotification;
use App\Models\NotificationSentRecord;

use App\Traits\GeneralsettingTrait;
use App\Traits\checkPermissionsTrait;
use App\Traits\SocialLink\SocialLinkTrait;

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\Http;
use Illuminate\Support\Facades\Auth;
use App\Exceptions\InvalidOrderException;
use Illuminate\Support\Facades\Validator;
use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;

class ProductsController extends Controller
{
    /**
     * Handle an authentication attempt.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    use SocialLinkTrait;
    use GeneralsettingTrait;
    use checkPermissionsTrait;

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

public function index(){

if(!$this->checkPermission(Auth::user()->role_id, 'products', 'is_read')){

return  redirect()->route('dashboard')->with('warning',app('translator')->get('You are not authorised to access that location'));
        }

$metatitle = "Products";
        return view('Admin.Products.index',compact('metatitle'));
    }

public function getProducts(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 = Product::select('count(*) as allcount')->where('products.delete_status', 0);

$totalRecords = $tRecords->count();

// Fetch records

$recordData =  Product::orderBy("products.".$columnName,$columnSortOrder)
                    ->where('products.delete_status', 0);

$recordData->where(function ($query) use ($searchValue){
                if($searchValue!=''){
                    $query->where('products.name', 'like', '%' .$searchValue . '%')
                        ->orWhere('products.id', 'like', '%' .$searchValue . '%')
                        ->orWhere('products.price', 'like', '%' .$searchValue . '%')
                        ->orWhere('products.discount', 'like', '%' .$searchValue . '%');
                }
            });

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

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

$are_you_sure_want_to_delete = app('translator')->get('messages.are_you_sure_want_to_delete');

foreach($records as $record){
            $proImage = ProductImage::where('product_id',$record->id)->first();
            $fileName = !empty($proImage) ? url("/public/uploads/products/".$proImage->file_name) : '';

$email_link = '<a href="mailto:'.$record->email.'" class="btn btn-secondary btn-sm ms-2"><span class="mdi mdi-email"></span></a>';
            $mobile_link = '<a href="tel:'.$record->national_number.$record->phone.'" class="btn btn-secondary btn-sm ms-2"><i class="fa fa-phone"></i></a>';

$data_arr[$incKey]['id'] = $record->id;
            $name = '<div class="d-flex align-items-center gap-2">
               <div class="rounded bg-light avatar-md d-flex align-items-center justify-content-center">
                  <img src="'.$fileName.'" alt="" class="avatar-md">
               </div>
               <div>
                  <a href="#!" class="text-dark fw-medium fs-15">'.$record->name.'</a>
                  <p class="text-muted mb-0 mt-1 fs-13"><span>Size : </span>S , M , L , Xl </p>
               </div>
            </div>';
            $data_arr[$incKey]['name'] = $name;
            $data_arr[$incKey]['price'] = !empty($record->price) ? $record->price : '';
            $data_arr[$incKey]['stock'] = !empty($record->stock) ? $record->stock : '';
            $data_arr[$incKey]['category'] = !empty($record->category) ? $record->category : '';

if($record->status == 1){
                $data_arr[$incKey]['status'] = '<a href="javascript:void(0)" class="btn btn-success btn-sm sm-1 updatestates upsta'.$record->id.'" data-id="'.$record->id.'" data-status="'.$record->status.'" >'.app('translator')->get('messages.statusactive').'</a>';
            }else{
                $data_arr[$incKey]['status'] = '<a href="javascript:void(0)" class="btn btn-danger btn-sm sm-1 updatestates upsta'.$record->id.'" data-id="'.$record->id.'" data-status="'.$record->status.'" >'.app('translator')->get('messages.statusinactive').'</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">';

$actions .= '<li><a href="'.route('product.edit', $record->id).'" class=""><i class="fe fe-edit"></i> '.app('translator')->get('messages.edit').'<div class="ripple-container"></li>';

$actions .= '</ul></div>';

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

$incKey++;
        }

$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, 'products', 'is_add')){

return  redirect()->route('dashboard')->with('warning',app('translator')->get('You are not authorised to access that location'));
        }

// $products = DB::table('product')->where('status', '1')->get();
        // $i = 1;

// foreach ($products as $record) {
            
        //     if($i >= 72 && $i <= 255){

//         $subcategory = DB::table('subcategory2')->where('status', '1')->where('category', $record->category)->where('subcategory', $record->subcategory)->where('id', $record->subcategory2)->first();

//         $catTitle = !empty($subcategory)?$subcategory->name:'';                
        //         $catData = Categorie::where('level',3)->where('title',$catTitle)->first();
        //         $cat_id = !empty($catData)?$catData->id:0;

//         // echo '<pre>';
        //         // print_r($subcategory);
        //         // die;
                
                
        //         $create = Product::where('name',$record->name)->update(['category_level3'=>$cat_id]);

//         // $brands = Brand::where('title', $record->brand)->first();

//         // $inputArr['name'] = $record->name;
        //         // $inputArr['brand'] = !empty($brands) ? $brands->id : 0;
        //         // $inputArr['gender'] = $record->gender;
        //         // $inputArr['stock'] = $record->stock;
        //         // $inputArr['size'] = $record->size;
        //         // $inputArr['price'] = !empty($record->mrp) ? $record->mrp :0;;
        //         // $inputArr['sellprice'] = !empty($record->sellprice) ? $record->sellprice :0;
        //         // $inputArr['description'] = $record->description;
        //         // $inputArr['specification'] = $record->specification;
        //         // $inputArr['rating'] = $record->rating;
        //         // $inputArr['status'] = true;

//         // $create = Product::create($inputArr);
        //         // $product_id = $create->id;
        //         // $imageArr = !empty($record->image) ? explode(',', $record->image) : array();            
        //         // foreach ($imageArr as $fileVal){
        //         //     $fileVal = !empty($fileVal) ? 'https://allspikes.in/admin/image/'.$fileVal :'';
        //         //     if(@file_get_contents($fileVal) == true){
        //         //         do{
        //         //             $fileName = $this->RandomString().'.jpeg';
        //         //         }
        //         //         while (ProductImage::where('file_name', $fileName)->exists());

//         //         $fullpath = public_path('uploads/products/') . $fileName;

//         //         @file_put_contents($fullpath, @file_get_contents($fileVal));
        //         //         $destinationPath = public_path('/uploads/products/thumbnail');

//         //         $Image = Image::make(file_get_contents(public_path('/uploads/products/'.$fileName)));
        //         //         $Image->resize(154, 154, function ($constraint)
        //         //         {
        //         //             $constraint->aspectRatio();
        //         //         })->save($destinationPath.'/'.$fileName);

//         //         $FileNameArr['product_id'] = $product_id;
        //         //         $FileNameArr['file_name'] = $fileName;
        //         //         $FileNameArr['file_root_path'] = public_path();
        //         //         $FileNameArr['file_base_url'] = url('/');
        //         //         $FileNameArr['file_full_url'] = url('public/uploads/products/'.$fileName);

//         //         ProductImage::create($FileNameArr);                    
        //         //     }
        //         // }
        //     }
        //     $i++;
        // }

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

$metatitle = "Add a product";
        return view('Admin.Products.create',compact('metatitle','brandList','catArr'));
    }

public function store(Request $request){

try
        {
            $request->validate([
                'name' => 'required',
                'brand' => 'required',
                'category' => 'required',
                'category_level2' => 'required',
                'category_level3' => 'required',
                'price' => 'required',
            ],[
                'name.required' => 'This field is required.',
                'brand.required' => 'This field is required.',
                'category.required' => 'This field is required.',
                'category_level2.required' => 'This field is required.',
                'category_level3.required' => 'This field is required.',
                'price.required' => 'This field is required.',
            ]);

$inputArr['name'] = !empty(request('name')) ? request('name') : '';
            $inputArr['category'] = !empty(request('category')) ? request('category') : 0;
            $inputArr['category_level2'] = !empty(request('category_level2')) ? request('category_level2') : 0;
            $inputArr['category_level3'] = !empty(request('category_level3')) ? request('category_level3') : 0;
            $inputArr['brand'] = !empty(request('brand')) ? request('brand') : 0;
            $inputArr['weight'] = !empty(request('weight')) ? request('weight') : '';
            $inputArr['stock'] = !empty(request('stock')) ? request('stock') : '';
            $inputArr['tag'] = !empty(request('tag')) ? request('tag') : '';
            $inputArr['price'] = !empty(request('price')) ? request('price') : '';
            $inputArr['sellprice'] = !empty(request('sellprice')) ? request('sellprice') : '';
            $inputArr['discount'] = !empty(request('discount')) ? request('discount') : '';
            $inputArr['tex'] = !empty(request('tex')) ? request('tex') : '';
            $inputArr['tex'] = !empty(request('tex')) ? request('tex') : '';
            $inputArr['description'] = !empty(request('description')) ? request('description') : '';
            $inputArr['specification'] = !empty(request('specification')) ? request('specification') : '';
            $inputArr['status'] = !empty(request('status')) ? 1 : 0;

if($create = Product::create($inputArr)){
                $id = $create->id;

$file = request('file_name');
                if($request->hasFile('file_name')){

$destinationPath = public_path('/uploads/products/');
                    foreach ($file as $key => $fileVal){

if ($fileVal->isValid()){

File::ensureDirectoryExists(public_path('/uploads/products'));
                            File::ensureDirectoryExists(public_path('/uploads/products/thumbnail'));

$fileName = $fileVal->hashName();
                            $foo = \File::extension($fileName);

do{
                                $fileName = $this->RandomString().'.'.$foo;
                            }
                            while (ProductImage::where('file_name', $fileName)->exists());

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

$fileVal->move($destinationPath,$fileName);
                            $file_name_arr['product_id'] = $id;
                            $file_name_arr['file_name'] = $fileName;
                            $file_name_arr['file_root_path'] = public_path();
                            $file_name_arr['file_base_url'] = url('/');
                            $file_name_arr['file_full_url'] = url('public/uploads/shops/'.$fileName);

ProductImage::create($file_name_arr);
                            
                        }
                    }
                }

return redirect()->route('product.index')->with('success','Product created successfully.');
            }
        }
        catch (PDOException $e)
        {
            return back()->with('error','Database error occured');;
        }
    }

public function edit(Product $product , $id){

try
        {
            if(!$this->checkPermission(Auth::user()->role_id, 'products', 'is_edit')){

return  redirect()->route('dashboard')->with('warning',app('translator')->get('You are not authorised to access that location'));
            }
            
            $product = Product::with('Image')->where('products.id', $id)->where('products.delete_status', 0)->firstOrFail();

$catArr = Categorie::where('level',1)->where('status',1)->where('delete_status',0)->orderBy('sort_order', 'asc')->pluck('title','id');
            $catLevel2Arr = Categorie::where('level',2)->where('status',1)->where('delete_status',0)->orderBy('sort_order', 'asc')->pluck('title','id');
            $catLevel3Arr = Categorie::where('level',3)->where('status',1)->where('delete_status',0)->orderBy('sort_order', 'asc')->pluck('title','id');
            $brandList = Brand::where('status', 1)->pluck('title','id');
            $imgArr = $product->Image;
            $metatitle = "Products";            
            return view('Admin.Products.edit',compact('metatitle','product','id','catArr','brandList','catLevel2Arr','catLevel3Arr','imgArr'));

}catch (Exception $e){
            
            $route = route('product.index');
            return view('Admin.Error.error400',compact('route'));

}catch (\Illuminate\Database\Eloquent\ModelNotFoundException $e){

$route = route('product.index');
            return view('Admin.Error.error404',compact('route'));
        }
    }

public function update(Request $request, $id){
        try
        {
            $request->validate([
                'name' => 'required',
                'brand' => 'required',
                'category' => 'required',
                'category_level2' => 'required',
                'category_level3' => 'required',
                'price' => 'required'
            ],[
                'name.required' => 'This field is required.',
                'brand.required' => 'This field is required.',
                'category.required' => 'This field is required.',
                'category_level2.required' => 'This field is required.',
                'category_level3.required' => 'This field is required.',
                'price.required' => 'This field is required.'
            ]);

$product = Product::with('Image')->where('id', $id)->firstOrFail();

$updateArr['name'] = !empty(request('name')) ? request('name') : $product->name;
            $updateArr['category'] = !empty(request('category')) ? request('category') : $product->name;
            $updateArr['category_level2'] = !empty(request('category_level2')) ? request('category_level2') : $product->category_level2;
            $updateArr['category_level3'] = !empty(request('category_level3')) ? request('category_level3') : $product->category_level3;
            $updateArr['brand'] = !empty(request('brand')) ? request('brand') : $product->brand;
            $updateArr['weight'] = !empty(request('weight')) ? request('weight') : '';
            $updateArr['stock'] = !empty(request('stock')) ? request('stock') : '';
            $updateArr['tag'] = !empty(request('tag')) ? request('tag') : '';
            $updateArr['price'] = !empty(request('price')) ? request('price') : '';
            $updateArr['sellprice'] = !empty(request('sellprice')) ? request('sellprice') : '';
            $updateArr['discount'] = !empty(request('discount')) ? request('discount') : '';
            $updateArr['tex'] = !empty(request('tex')) ? request('tex') : '';
            $updateArr['description'] = !empty(request('description')) ? request('description') : '';
            $updateArr['specification'] = !empty(request('specification')) ? request('specification') : '';

$updateArr['status'] = !empty(request('status')) ? 1 : 0;

if (Product::whereId($id)->update($updateArr)){

$file = request('file_name');
                if($request->hasFile('file_name')){

$destinationPath = public_path('/uploads/products/');
                    foreach ($file as $key => $fileVal){

if ($fileVal->isValid()){

$file_primary_id = request('file_primary_id');

File::ensureDirectoryExists(public_path('/uploads/products'));
                            File::ensureDirectoryExists(public_path('/uploads/products/thumbnail'));

$fileName = $fileVal->hashName();
                            $foo = \File::extension($fileName);

if (!empty($file_primary_id[$key])){

$proImage = ProductImage::where('id', $file_primary_id[$key])->where('product_id',$product->id)->first();

if (!empty($proImage)){

if(File::exists($destinationPath.$proImage->file_name)){
                                        @unlink($destinationPath.$proImage->file_name);
                                        @unlink($destinationPath.'thumbnail/'.$proImage->file_name);
                                    }

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

$fileVal->move($destinationPath,$fileName);

$file_name_arr['file_name'] = $fileName;
                                    $file_name_arr['file_full_url'] = url('public/uploads/products/'.$fileName);
                                    ProductImage::whereId($proImage->id)->update($file_name_arr);
                                }

}else{

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

$fileVal->move($destinationPath,$fileName);
                                $file_name_arr['product_id'] = $product->id;
                                $file_name_arr['file_name'] = $fileName;
                                $file_name_arr['file_root_path'] = public_path();
                                $file_name_arr['file_base_url'] = url('/');
                                $file_name_arr['file_full_url'] = url('public/uploads/shops/'.$fileName);

ProductImage::create($file_name_arr);
                            }
                        }
                    }
                }

return redirect()->route('product.index')->with('success',app('translator')->get('Product update successfully'));
            }
        }
        catch (PDOException $e)
        {
            return back()->with('error','Database error occured');;
        }
    }

public function distroy($id){
        try
        {
            if(!$this->checkPermission(Auth::user()->role_id, 'products', 'is_delete')){

return  redirect()->route('dashboard')->with('warning',app('translator')->get('messages.You are not authorised to access that location'));
            }

$product = Product::with('Image')->where('id', $id)->firstOrFail();
                
                foreach ($product->Image as $postData) {

$public_path = public_path('/uploads/products/');

if(File::exists($public_path.$postData->file_name)){
                        unlink($public_path.$postData->file_name);
                        unlink($public_path.'thumbnail/'.$postData->file_name);
                    }

ProductImage::where('id',$postData->id)->delete();
                }

$product->delete();

return redirect()->route('product.index')->with('success',app('translator')->get('messages.product deleted successfully.'));

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

public function updateStatus(Request $request){

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

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

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

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

public function removeFile(Request $request){

if ($request->ajax())
        {
            $row_id = request('row_id');
            $file_tab = request('file_tab');
            $public_path = public_path('/uploads/');
            switch ($file_tab) {
                case 'user_profile':

$detail = User::where('id',$row_id)->first();
                        if(!empty($detail->profile_pic) && File::exists($public_path.'users/'.$detail->profile_pic))
                        {
                            @unlink($public_path.'users/'.$detail->file_name);
                            @unlink($public_path.'users/thumbnail/'.$detail->file_name);
                            User::where('id',$row_id)->update(['profile_pic'=>NULL]);
                        }
                break;
                case 'verify_document1':

$detail = UserVerification::where('id',$row_id)->first();
                        if(!empty($detail->document1) && File::exists($public_path.'users/verification/'.$detail->document1))
                        {
                            @unlink($public_path.'users/verification/'.$detail->document1);
                            UserVerification::where('id',$row_id)->update(['document1'=>NULL]);
                        }
                break;
                case 'verify_document2':

$detail = UserVerification::where('id',$row_id)->first();
                        if(!empty($detail->document2) && File::exists($public_path.'users/verification/'.$detail->document2))
                        {
                            @unlink($public_path.'users/verification/'.$detail->document2);
                            UserVerification::where('id',$row_id)->update(['document2'=>NULL]);
                        }
                break;
            }

$output['success'] = true;
            return response()->json($output);
        }
    }

public function GetCatLevel3List(Request $request){

if ($request->ajax()){

$cat_id = request('cat_id');
            $category_level2_id = request('category_level2_id');

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

return view('Admin.Products.catlevel3list',compact('catArr'));
        }
    }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: ProductsController.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation