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

Free Space:

1.9 TB

🔧 Quick Actions

✏️ Editing: OrdersController.php

<?php
namespace App\Http\Controllers\Admin\Orders;
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\Order;
use App\Models\Payment;
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 OrdersController 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, 'orders', 'is_read')){

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

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

public function getOrders(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 = Payment::select('count(*) as allcount');

$totalRecords = $tRecords->count();

// Fetch records

$recordData =  Payment::with('userData','Product')->orderBy("payments.".$columnName,$columnSortOrder);

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

$recordData->select('payments.*');
        $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->product_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;
            $image = '<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>';

$data_arr[$incKey]['order_id'] = '#'.$record->txn_id;
            $data_arr[$incKey]['image'] = $image;
            $data_arr[$incKey]['user_id'] = !empty($record->userData) ? $record->userData->first_name.' '.$record->userData->last_name : '';
            $data_arr[$incKey]['price'] = !empty($record->totalpricewithgst) ? number_format($record->totalpricewithgst) : '0.0';
            $data_arr[$incKey]['payment_status'] = !empty($record->paystatus) ? $record->paystatus : '';
            $data_arr[$incKey]['date'] = !empty($record->date) ? \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $record->date)->format('d-m-Y H:i:s') : '';

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>';
            }
            
            $data_arr[$incKey]['traking_data'] = 'Not updated yet';

$actions = '<a href="javascript:void(0)" class="btn btn-danger btn-sm pull-left delete-row" table-url="'.route('order.delete', $record->id).'"><i class="fe fe-trash"></i> '.app('translator')->get('messages.delete').'</a>';

$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'));
        }
        
        $metatitle = "Add a product";
        return view('Admin.Orders.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(Order $orders , $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 = Order::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.Orders.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, 'orders', '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: OrdersController.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation