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: SitemapController.php

<?php

namespace App\Http\Controllers;

use App\Http\Requests\AddUserValidation;
use App\User;
use Illuminate\Http\Request;
use DB;
use Storage;
use Auth;

class SitemapController extends Controller
{
    public function index()
    {
        $hostname =  'https://'.$_SERVER['HTTP_HOST'];

if (strpos($hostname, 'localhost') !== false) {
            $base_url = $hostname."/taresitare/trunk/";
        }else{
            $base_url = $hostname."/";
        }

$sitemapcountry = "sitemapcountry";
        $sitemapstate = "sitemapstate";
        $clients = "sitemapclients";
        $sitemapcity = "sitemapcity";
        $areas = "sitemapareas";
        $blogs = "sitemapblogs";

return response()->view('sitemap.index', [
            'country' => $sitemapcountry,
            'state' => $sitemapstate,
            'city' => $sitemapcity,
            'clients' => $clients,
            'areas' => $areas,
            'blogs' => $blogs,
            'base_url' => $base_url

])->header('Content-Type', 'text/xml');
    }

public function sitemapcountry()
    {
        $hostname =  'https://'.$_SERVER['HTTP_HOST'];

if (strpos($hostname, 'localhost') !== false) {
            $base_url = $hostname."/taresitare/trunk/";
        }else{
            $base_url = $hostname."/";
        }

// get all page urls from database table
        $country = DB::table('websites_page_head_titles')
                ->where('websites_page_head_titles.status', 1)
                ->where('websites_page_head_titles.update_status', 1)
                ->where('websites_page_head_titles.category', '!=', null)
                ->where('websites_page_head_titles.area', null)
                ->get();

return response()->view('sitemap.country', [
            'countries' => $country,
            'base_url' => $base_url

])->header('Content-Type', 'text/xml');
    }

public function sitemapstate()
    {
        $hostname =  'https://'.$_SERVER['HTTP_HOST'];

if (strpos($hostname, 'localhost') !== false) {
            $base_url = $hostname."/taresitare/trunk/";
        }else{
            $base_url = $hostname."/";
        }

// get all page urls from database table
        $categories = DB::table('websites_page_head_titles')
                ->leftjoin('category', 'category.id', '=', 'websites_page_head_titles.category')
                ->leftjoin('states', 'states.country_id', '=', 'websites_page_head_titles.country_id')
                ->where('websites_page_head_titles.status', 1)
                ->where('websites_page_head_titles.update_status', 1)
                ->where('websites_page_head_titles.category', '!=', null)
                ->where('websites_page_head_titles.area', null)
                ->select('websites_page_head_titles.*', 'category.category', 'states.name as state_name')
                ->get();

return response()->view('sitemap.state', [
            'categories' => $categories,
            'base_url' => $base_url

])->header('Content-Type', 'text/xml');
    }
    
    public function sitemapcity()
    {
        $hostname =  'https://'.$_SERVER['HTTP_HOST'];

if (strpos($hostname, 'localhost') !== false) {
            $base_url = $hostname."/taresitare/trunk/";
        }else{
            $base_url = $hostname."/";
        }
        
        $states = DB::table('states')->where('country_id', 101)->get();
        
        $cities = DB::table('cities')->get();
        
        // get all page urls from database table
                
        $cat_areas = DB::table('websites_page_head_titles')
                ->leftjoin('category', 'category.id', '=', 'websites_page_head_titles.category')
                ->where('websites_page_head_titles.status', 1)
                ->where('websites_page_head_titles.update_status', 1)
                ->where('websites_page_head_titles.business_page', null)
                ->where('websites_page_head_titles.area', null)
                ->select('websites_page_head_titles.*', 'category.category')
                ->get();

return response()->view('sitemap.city', [
            'states' => $states,
            'cities' => $cities,
            'cat_areas' => $cat_areas,
            'base_url' => $base_url

])->header('Content-Type', 'text/xml');
    }

public function sitemapclients()
    {

$hostname =  'https://'.$_SERVER['HTTP_HOST'];

if (strpos($hostname, 'localhost') !== false) {
            $base_url = $hostname."/taresitare/trunk/";
        }else{
            $base_url = $hostname."/";
        }

// Get all clients sitemap
        $clients = DB::table('websites_page_head_titles')
                ->leftjoin('cities', 'cities.id', '=', 'websites_page_head_titles.city')
                ->where('websites_page_head_titles.status', 1)
                ->where('websites_page_head_titles.update_status', 1)
                ->where('websites_page_head_titles.business_page', '!=', null)
                ->where('websites_page_head_titles.area', null)
                ->select('websites_page_head_titles.*', 'cities.name as city_name')
                ->get();

return response()->view('sitemap.clients', [
            'clients' => $clients,
            'base_url' => $base_url

])->header('Content-Type', 'text/xml');
    }

public function sitemapareas()
    {

$hostname =  'https://'.$_SERVER['HTTP_HOST'];

if (strpos($hostname, 'localhost') !== false) {
            $base_url = $hostname."/taresitare/trunk/";
        }else{
            $base_url = $hostname."/";
        }
        
        $area_info = DB::table('areas')->where('status', 1)->get();
        
        $cat_areas = DB::table('websites_page_head_titles')
                ->leftjoin('category', 'category.id', '=', 'websites_page_head_titles.category')
                ->where('websites_page_head_titles.status', 1)
                ->where('websites_page_head_titles.update_status', 1)
                ->where('websites_page_head_titles.business_page', null)
                ->where('websites_page_head_titles.area', null)
                ->select('websites_page_head_titles.*', 'category.category')
                ->get();

return response()->view('sitemap.area', [
            'cat_areas' => $cat_areas,
            'area_info' => $area_info,
            'base_url' => $base_url

])->header('Content-Type', 'text/xml');
    }
    
    public function sitemapblogs()
    {

$hostname =  'https://'.$_SERVER['HTTP_HOST'];

if (strpos($hostname, 'localhost') !== false) {
            $base_url = $hostname."/taresitare/trunk/";
        }else{
            $base_url = $hostname."/";
        }
        
        $blogs = DB::table('blogs')->where(array('status' => 1))->orderBy('id', 'asc')->get();

return response()->view('sitemap.blog', [
            'blogs' => $blogs,
            'base_url' => $base_url

])->header('Content-Type', 'text/xml');
    }
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: SitemapController.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation