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

<?php

namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\User;
use DB;
use Auth;

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

// Show reports page
    public function index(){

return view('reports.index');
    }

// Show employees client meetings page
    public function employees_client_meeting(){

// Get employees
    	$employees = DB::table('employees')
    				->join('user_roles', 'user_roles.user_id', '=', 'employees.user_id')
    				->join('roles', 'roles.id', '=', 'user_roles.role_id')
    				->where('status', 1)
    				->select('employees.*', 'roles.role')
    				->get();

return view('reports.employees_client_meeting', array('employees' => $employees));
    }

// employee client meeting report generate
    public function generate_employee_client_meeting_report(Request $request){

$employee = $request->employee;
    	$start_date = date('Y-m-d', strtotime($request->start));
    	$end_date = date('Y-m-d', strtotime($request->end));

// Get meetings of this employee
    	$meeting_records = DB::table('user_details')
                            ->join('user_location', 'user_location.user_id', '=', 'user_details.user_id')
    						->join('employees', 'employees.user_id', '=', 'user_details.created_by')
    						->where('user_details.created_by', $employee)
    						->whereDate('user_details.created_at', '>=', $start_date)
    						->whereDate('user_details.created_at', '<=', $end_date)
    						->select('user_details.*', 'user_location.business_name', 'user_location.building', 'user_location.street', 'user_location.landmark', 'user_location.area', 'user_location.city', 'user_location.pincode', 'user_location.state', 'user_location.country', 'employees.name as created_by_name')
    						->get();

return view('reports.employees_client_meeting', array('employees' => $employees, 'meeting_records' => $meeting_records));
    }

}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Reports.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation