Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.37.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u732469475

Directory:

/home/u732469475/domains/taresitare.com/public_html/app/Http/Controllers

Free Space:

3.37 TB

🔧 Quick Actions

✏️ Editing: Blogs.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Auth;
use DB;
use Illuminate\Support\Facades\Input;
use Illuminate\Support\Facades\Validator;
use Illuminate\Support\Facades\Hash;
use Storage;
use File;
use Session;
use Illuminate\Support\Facades\Crypt;
use DataTables;

class Blogs extends Controller
{
    # construct function
    public function __construct()
    {
        $this->middleware('auth');
        $this->middleware('admin');
    }

// Website page head titles like Title, Meta title, Keyword, Description etc
    public function page_blogs(Request $request)
    {
        $category     = $request->category;
        //$sub_category = $request->sub_category;
        //$city         = $request->city;
        $business     = $request->business;
        $page         = $request->page;
        $title        = $request->title;
        $keyword      = $request->keyword;
        $description  = $request->description;
        $name         = $request->name;
        $slug         = strtolower(preg_replace('/[^A-Za-z0-9\-]/', '-', $name));
        $content      = $request->content;
        $hindi_content      = $request->hindi_content;
        $blog_id      = substr(md5(microtime()),rand(0,26),4);
        $date         = date('Y-m-d H:i:s');
        $status       = '';
        $filename     = '';

# upload image for category
        if($request->hasFile('image')) {

$file            = $request->image;
            
            $filename        = $file->getClientOriginalName();
            
            $ext             = pathinfo($filename, PATHINFO_EXTENSION);
            
            $filename        = substr(md5(microtime()),rand(0,26),6);
            
            $filename        .= '.'.$ext;
            
            $filesize        = $file->getClientSize();
            
            $destinationPath = config('app.fileDestinationPath').'/blogs/'.$filename;
            $uploaded        = Storage::put($destinationPath, file_get_contents($file->getRealPath()));                
        }

/*
        // First of all check if page url and page titles are already created or not for selected category, subcategory and city
        $rows = DB::table('blogs')
                ->where(['category' => $category, 'city' => $city, 'area' => null, 'status' => 1]);
                
                $rows->where('encoded_params', '!=', null);
                
        // If the sub category is selected
        if(!empty($sub_category)){
            $rows->where('subcategory', $sub_category);
        }else{
            $rows->where('subcategory', null);
        }

$exist = $rows->first();*/

// define blank array for ignore error when admin go to page directly
        $sub_category_info = array();

// If the entry is already not exist for selected data then process this to create page url and titles n all
        /*if(empty($exist)){*/
            
            if(!empty($title) && !empty($keyword) && !empty($description) && !empty($name) && !empty($filename))
            {
                // Create page url
                $page_url = $page;

// when category is selected and page name and business name is not seleted
                if(!empty($category))
                {
                    // define page url blank
                    $page_url = '';

// If sub category selected then page url will create with sub category
                    if(!empty($sub_category))
                    {
                        $params = $sub_category.'-2-'.$city;

// Get sub Category Name
                        $p_subcategory = DB::table('subcategory')->where(array('id' => $sub_category, 'status' => 1))->first();
                        $page_url .= preg_replace('/[^A-Za-z0-9\-]/', '-', $p_subcategory->subcategory);
                    }
                    else    // Page url will create with Category
                    {
                        //$params = $category.'-1-'.$city;

// Get Category Name
                        $p_category = DB::table('category')->where(array('id' => $category, 'status' => 1))->first();
                        $page_url .= preg_replace('/[^A-Za-z0-9\-]/', '-', $p_category->category);
                    }

//$encrypted = base64_encode($params);

// first insert selected city titles
                    $insert = DB::table('blogs')->insert(array(
                        'category'       => $category,
                        //'subcategory'    => $sub_category,
                        //'city'           => $city,
                        'business_page'  => $business,
                        'page_url'       => strtolower($page_url),
                        //'encoded_params' => $encrypted,
                        'title'          => ucfirst(strtolower($title)),
                        'keyword'        => ucfirst(strtolower($keyword)),
                        'description'    => ucfirst(strtolower($description)),
                        'name'           => $name,
                        'slug'           => $slug,
                        'image'          => $filename,
                        'content'        => $content,
                        'hindi_content'  => $hindi_content,
                        'blog_id'        => $blog_id,
                        'created_at'     => $date,
                        'updated_at'     => $date,
                        'status'         => 1
                    ));

// Get city name by city id
/*                    $cityRow = DB::table('cities')->where('id', $city)->first();
                    $cityName = $cityRow->name;
                    $cityName = strtolower($cityName);*/

// first of all get all areas of selectes city
/*                    $allAreas = DB::table('areas')->where(['city' => $city, 'status' => 1])->get();

if(!empty($allAreas[0])){

foreach ($allAreas as $key => $row) {

// Get Area Name
                            $areaa = preg_replace('/[^A-Za-z0-9\-]/', '-', $row->area);

$main_page_url = $page_url;
                            $area_page_url = $main_page_url.'-in-'.$areaa;

// If the subcategory is blank then
                            if(!empty($sub_category)){
                                $params = $sub_category.'-2-'.$city.'-'.$row->id;
                            }else{ 
                                $params = $category.'-1-'.$city.'-'.$row->id;
                            }

$encrypted = base64_encode($params);            
                            
                            // Insert titles for all areas of selected
                            $insert = DB::table('blogs')->insert(array(
                                'category'       => $category,
                                'subcategory'    => $sub_category,
                                'city'           => $city,
                                'area'           => $row->id,
                                'business_page'  => $business,
                                'page_url'       => strtolower($area_page_url),
                                'encoded_params' => $encrypted,
                                'title'          => str_replace($cityName, $row->area, ucfirst(strtolower($title))),
                                'keyword'        => str_replace($cityName, $row->area, ucfirst(strtolower($keyword))),
                                'description'    => str_replace($cityName, $row->area, ucfirst(strtolower($description))),
                                'name'           => $name,
                                'slug'           => $slug,
                                'image'          => $filename,
                                'content'        => $content,
                                'blog_id'        => $blog_id,
                                'created_at'     => $date,
                                'updated_at'     => $date,
                                'status'         => 1
                            ));

$params = '';
                        }
                    }*/
                }

if(!empty($page) && $page != '')    // If page name is selected and category name and business name not selected
                {
                    // Insert page titles when category and business name not selected
                    $insert = DB::table('blogs')->insert(array(
                        'page_url'    => $page_url,
                        'title'       => $title,
                        'keyword'     => $keyword,
                        'description' => $description,
                        'name'        => $name,
                        'slug'        => $slug,
                        'image'       => $filename,
                        'content'     => $content,
                        'hindi_content'     => $hindi_content,
                        'created_at'  => $date,
                        'updated_at'  => $date,
                        'status'      => 1
                    ));
                }
                if($insert){
                    $status = "Page url and Blogs created successfully.";
                }
                else{
                    $status = "All Fields manadatory";
                }
            }
            else{
                $status = "All Fields are manadatory";
            }

/*        }else{

// get sub category name if selected
            $sub_category_info = DB::table('subcategory')->where('id', $sub_category)->first();

// If enteries are already exist then hit error
            $status = "Page url and titles are already created for the category / subcategory with this city ! You can update this information.";
        }*/

//  Get All Categories
        $business = DB::table('user_location')->where('status', 1)->get();

//  Get All Categories
        $category = DB::table('category')->where('status', 1)->get();

//  Get All Page titles
        $titles = DB::table('blogs')->where('status', 1)->get();

//  Get All Page titles
        $getAllBlogPages = DB::table('blogs')->where(['status' => 1, 'area' => null])->get();

return view('blogs.page_titles', array('category' => $category, 'business' => $business, 'titles' => $titles, 'status' => $status, 'sub_category_info' => $sub_category_info, 'getAllBlogPages' => $getAllBlogPages));
    }

// Get page titles and urls using ajax
    public function getAllBlogPages(Request $request)
    {
        //  Get All Page titles
        $titles = DB::table('blogs')->where(['status' => 1, 'area' => null])->get();
        return Datatables::of($titles)->addColumn('action', function ($row) {
            return '<a class="btn btn-success editPageUrlTitle" href="javascript:;" id="editPageUrlTitle_'.$row->id.'"> Edit </a>';
        })->make(true);  
    }

// Get page titles and urls using ajax
    public function editBlog(Request $request)
    {
        $blog_id = $request->blog_id;

//  Get All Categories
        $business = DB::table('user_location')->where('status', 1)->get();

//  Get All Categories
        $category = DB::table('category')->where('status', 1)->get();

//  Get All Page editBlog
        $editAllBlogPages = DB::table('blogs')->where(['status' => 1, 'area' => null, 'blog_id' => $blog_id])->first();

// get sub category name if selected
        $sub_category_info = DB::table('subcategory')->where('id', $editAllBlogPages->subcategory)->first(); 
        
        return view('blogs.edit', array('category' => $category, 'business' => $business, 'sub_category_info' => $sub_category_info, 'editAllBlogPages' => $editAllBlogPages));
    }

// Update Website page head titles like Title, Meta title, Keyword, Description etc
    public function update_page_blog(Request $request){

$blog_id      = $request->u_blod_id;
        $category     = $request->u_cat_id;
        $sub_category = $request->u_subcat_id;
        $city         = $request->u_city_id;
        $title        = $request->u_title;
        $keyword      = $request->u_keyword;
        $description  = $request->u_description;
        $name         = $request->u_name;
        $filename     = $request->u_image;
        $content      = $request->u_content;
        $hindi_content      = $request->u_hindi_content;
        $date         = date('Y-m-d H:i:s');

if(empty($filename)){         
            //  Get All Page editBlog
            $editAllBlogPages = DB::table('blogs')->where(['status' => 1, 'area' => null, 'blog_id' => $blog_id])->first();
            $filename = $editAllBlogPages->image;
        }

# upload image for category
        if($request->hasFile('image')) {

$file            = $filename;
            
            $filename        = $file->getClientOriginalName();
            
            $ext             = pathinfo($filename, PATHINFO_EXTENSION);
            
            $filename        = substr(md5(microtime()),rand(0,26),6);
            
            $filename        .= '.'.$ext;
            
            $filesize        = $file->getClientSize();
            
            $destinationPath = config('app.fileDestinationPath').'/blogs/'.$filename;
            $uploaded        = Storage::put($destinationPath, file_get_contents($file->getRealPath()));                
        }

// if anyone directly come to this function then through back
        if(empty($category) &&  empty($sub_category) && empty($city)){
            return redirect('editBlog/'.$blod_id);
        }

// If subcategory is exist
        if($sub_category){            
            $where = array('category' => $category, 'subcategory' => $sub_category, 'city' => $city, 'blog_id' => $blog_id);
        }else{            
            $where = array('category' => $category, 'subcategory' => null, 'city' => $city, 'blog_id' => $blog_id);
        }

// Update title, keyword and description
        $update = DB::table('blogs')->where($where)->update([
            'title'       => ucfirst(strtolower($title)),
            'keyword'     => ucfirst(strtolower($keyword)),
            'description' => ucfirst(strtolower($description)),
            'name'        => $name,
            'image'       => $filename,
            'content'     => $content,
            'hindi_content'     => $hindi_content,
            'updated_at'  => $date
        ]);

/*        // first of all get all areas of selectes city
        $allAreas = DB::table('areas')->where(['city' => $city, 'status' => 1])->get();

// Get city name by city id
        $cityRow = DB::table('cities')->where('id', $city)->first();
        $cityName = $cityRow->name;
        $cityName = strtolower($cityName);

if(!empty($allAreas[0])){

foreach ($allAreas as $key => $row) {

// If subcategory is exist
                if($sub_category){
                    $where = array('category' => $category, 'subcategory' => $sub_category, 'city' => $city, 'area' => $row->id, 'blog_id' => $blog_id);
                }else{
                    $where = array('category' => $category, 'subcategory' => null, 'city' => $city, 'area' => $row->id, 'blog_id' => $blog_id);
                }

$new_title = str_replace($cityName, $row->area, ucfirst(strtolower($title)));
                $new_keyword = str_replace($cityName, $row->area, ucfirst(strtolower($keyword)));
                $new_description = str_replace($cityName, $row->area, ucfirst(strtolower($description)));
                
                // Update title, keyword and description for area
                $update_area = DB::table('blogs')->where($where)->update([
                    'title'       => $new_title,
                    'keyword'     => $new_keyword,
                    'description' => $new_description,
                    'name'        => $name,
                    'image'       => $filename,
                    'content'     => $content,
                    'hindi_content'     => $hindi_content,
                    'updated_at'  => $date
                ]);
            }
        }*/

$status = "Page url and blogs are description updated successfully.";
        
        //  Get All users with location
        $business = DB::table('user_location')->where('status', 1)->get();

//  Get All Categories
        $category = DB::table('category')->where('status', 1)->get();

//  Get All Page titles
        $titles = DB::table('blogs')->where('status', 1)->get();

return redirect('blogs')->with('status', $status);
    }

# Update page titles data
    public function editPageUrlTitle(Request $request)
    {
        $date = date('Y-m-d H:i:s');

$id = $request->row_id;
        $title = $request->edit_title;
        $keyword = $request->edit_keyword;
        $description = $request->edit_description;

$update = DB::table('blogs')->where('id', $id)->update([
            'title' => $title,
            'keyword' => $keyword,
            'description' => $description,
            'updated_at' => $date
        ]);

if($update)
        {
            $status = "Blog Updated Successfully.";
        }
        else
        {
            $status = 'Something Went Wrong !';
        }

return redirect('page_blogs')->with('status', $status);
    }
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Blogs.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation