<?php

/*
  |--------------------------------------------------------------------------
  | Web Routes
  |--------------------------------------------------------------------------
  |
  | Here is where you can register web routes for your application. These
  | routes are loaded by the RouteServiceProvider within a group which
  | contains the "web" middleware group. Now create something great!
  |
 */

use App\DriverModal\DriverAccident;
use App\DriverModal\DriverAddress;
use App\DriverModal\DriverHistory;
use App\DriverModal\DriverLncInfo;
use App\DriverModal\DriverTrafficViolation;
use App\Http\Controllers\CommunicationNotesController;
use App\Http\Controllers\DistanceMatrixController;
use App\User;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Route;
use Illuminate\Support\Facades\Artisan;
use Illuminate\Support\Facades\DB;

Route::get('/', function () {
    return view('welcome');
});

Route::get('privacy-policy', function () {
    return view('privacyPolicy');
});
Route::get('term-condition', function () {
    return view('termCondition');
});

Route::get('/clear-cache', function () {
    Artisan::call('cache:clear');
    Artisan::call('route:clear');
    Artisan::call('config:clear');


    return "Cache cleared successfully";
});
//For Cron Job
Route::get('add-employee-notification', 'Notification\StoreNotificationController@addEmployeeNotification');
Route::get('delete-employee-notification-expire', 'Notification\StoreNotificationController@removeExpireNoti');
Route::get('email-notification', 'Notification\StoreNotificationController@emailNotification');
Route::get('employee-email-notification', 'Notification\EmployeeEmailNotificationController@emailNotification');
Route::get('driver-application-email-notification', 'Notification\DriverApplicationEmailNotificationController@emailNotification');
Route::post('send-email-notify', 'EmailAmmoucementController@SendEmailNotify')->name('send-email-notify');
Route::get('send-email-to-driver', 'Notification\StoreNotificationController@addEmployeeNotification');
Route::get('change-ssn-code', 'Notification\NotificationViewController@ChangeSSN');
Route::match(['get', 'post'], 'logouts', 'Auth\LogoutController@logout')->name('logouts');
Route::get('auto-logout', 'Auth\LogoutController@autologout')->name('auto-logout');
Route::get('session-ping', 'Auth\LogoutController@sessionPing')->name('session-ping')->middleware('auth');
Route::get('make-encrypted-data', 'DashboardController@makeEncrypedData');
Route::get('make-encrypted-application-data', 'DashboardController@makeEncrypedApplicationData');
Route::get('import-violiation-list', 'DashboardController@importViolationList');
Route::post('import-violiation-list/store', 'DashboardController@storeViolationList')->name('import.violation.list');
Route::get('active-vehicle', 'DashboardController@makeVehicleActive');
Route::get('unit-make-yes', 'DashboardController@unitMakeYes');
Route::get('import-fuel-tax-sheet', 'DashboardController@importFuelSheet')->name('import.fuel.sheet')->middleware('auth');
Route::post('import-fuel-tax-sheet/store', 'DashboardController@storeFuelSheet')->name('store.fuel.list')->middleware('auth');
Route::get('store-fuel-entry', 'CreateFuelEntryController@storeFuelentry');
Route::get('send-push-notification', 'NotificationController@sendPushNotification');
Route::get('get-duplicate-unit-code', 'NotificationController@getDuplicateUnitcode')->middleware('auth');
Route::get('get-importated-unit', 'NotificationController@getImportedUnitcode')->middleware('auth');
Route::get('change-work-month', 'Units\FuelController@changeWorkMonth')->middleware(['auth', '2fa']);

Route::get('emp-status-history', 'Notification\NotificationViewController@storeEmpStatusHistory')->name('emp.status.history');
Route::get('vehicle-status-history', 'Notification\NotificationViewController@storevehicleStatusHistory')->name('vehicle.status.history');

Route::get('email/view-notification/{key}/{cmp}', 'HomeController@showNotification')->name('email.noti.view');

Route::get('copy-vehicle-status-history', 'Notification\NotificationViewController@copyStatusHistory');
//End Cron Job
Route::get('directory', 'DirectoryController@index');
Route::get('directory/{id}/edit', 'DirectoryController@edit')->name('directory.edit')->middleware('auth');
Route::get('directory/create', 'DirectoryController@create')->name('directory.create')->middleware('auth');
Route::post('directory/store', 'DirectoryController@store')->name('directory.store')->middleware('auth');
Route::post('directory/{id}/update', 'DirectoryController@update')->name('directory.update')->middleware('auth');
Route::post('directory/{id}/destroy', 'DirectoryController@destroy')->name('directory.destroy')->middleware('auth');
Route::get('view-status-history', 'Notification\NotificationViewController@viewStatusHistory')->name('view-status-history')->middleware('auth');
Route::get('Chnage-cmp-status', 'DashboardController@changeCmpStatus')->name('Chnage-cmp-status')->middleware('auth');

//Ajax
Route::post('get-city', 'Driverapplication\DriverRegistrationController@getCity');
Route::post('check-three-year-address', 'Driverapplication\DriverApplicationControllers@checkThreeYearAddress');
Route::get('get-state', 'Driverapplication\DriverRegistrationController@getState');
Route::get('edit-history', 'Driverapplication\DriverRegistrationController@edit_history');
Route::post('driver-applications/history/update/{id}', 'Driverapplication\DriverRegistrationController@update_history')->name('update.history.detail.new');
Route::post('ajax-form-submit-comment', 'Driverapplication\DriverApplicationControllers@Update_comment')->middleware(['auth', '2fa']);

Route::any('check-ssn-exist', 'Admin\ajaxController@checkSsn')->name('check.ssn');
Route::any('get-company-name', 'Admin\ajaxController@getCompanyNameBySSN');
Route::post('check-employee-ssn-exist', 'Admin\ajaxController@checkEmployeeSsn')->name('check.employee.ssn');
Route::post('check-employee-ssn-exist-edit', 'Admin\ajaxController@checkEmployeeSsnEdit')->name('check.employee.ssn.edit');
Route::get('remove-document', 'Admin\ajaxController@removeDocument')->name('remove.doc');
Route::post('check-unit-code', 'Admin\ajaxController@checkUnitCode')->name('check.unit.code');
Route::post('check-primary-vin', 'Admin\ajaxController@checkPrimaryVin')->name('check.primary.vin');
Route::post('edit/check-primary-vin', 'Admin\ajaxController@checkPrimaryVinEdit')->name('check.primary.vin.on.edit');

Route::post('getCompanyList', 'Admin\ajaxController@getCompanyList');
Route::post('getApplicationAccess', 'Admin\ajaxController@getApplicationAccess');
Route::get('get-exp-date-for-frequancy', 'Admin\ajaxController@getExpDateforFrequancy');
Route::post('changeStaffAccess', 'Admin\ajaxController@changeStaffAccess');
Route::get('get-company-employee', 'Admin\ajaxController@getCompanyEmployee');
Route::post('getCompanyListDatatable', 'Admin\ajaxController@getCompanyListDatatable');
Route::post('store-assign-company', 'Admin\ajaxController@storeAssignCompany');
Route::get('not-access', 'Company\NotaccessController@notAccessPage');
Route::post('change-company-session', 'Company\NotaccessController@changeCmpSession');
Route::get('get-roadside-data', 'Admin\ajaxController@getRoadsideData');
Route::get('getLicensePlate', 'Admin\ajaxController@getLicencePlate');

Route::post('get-fleet-based-on-prorate', 'Reports\NewCompanyReportController@getfleetBasedOnProrate')->name('getfleetBasedOnProrate');
Route::post('get-unit-based-on-fleet', 'Reports\NewCompanyReportController@getUnitBasedOnFleet')->name('getUnitBasedOnFleet');

Route::any('get-trip-base-on-unit-code', 'Admin\ajaxController@getTripBaseonUnitCode');
Route::any('get-unit-code-based-on-trip-date', 'Admin\ajaxController@getUnitCodeBasedOnDate');

Route::any('get-next-service-date', 'Admin\ajaxController@getNextServiceDate');

Route::get('/search-by-ssn', 'Admin\ajaxController@searchBySsnPrefix');


Route::post('tax-file', 'TaxFileController@taxFile')->name('tax.file');
//End Ajax

Route::resource('createRequests', RequestsController::class);
Route::post('request-cancel/{id}', 'RequestsController@requestCancel');


//Notification View
Route::get('cp/dashboard/company/notification-view/{id}/{type}', 'Notification\NotificationViewController@safetyAuditView')->name('cp.company.notification.view');

require __DIR__ . '/report.php';
require __DIR__ . '/employee.php';
require __DIR__ . '/unit.php';
require __DIR__ . '/driverApplication.php';
require __DIR__ . '/vehicle.php';
require __DIR__ . '/company.php';

Route::group(['prefix' => 'admin', 'middleware' => '2fa.admin'], function () {
    Route::get('add-quick-company', 'Admin\QuickCompanyaddController@create');
    Route::get('import-Vehicle', 'Admin\QuickCompanyaddController@importVihicle');
    Route::get('import-employee', 'Admin\QuickCompanyaddController@importEmployee');
    Route::post('store-company-quick', 'Admin\QuickCompanyaddController@store');
    Route::post('store-company', 'Admin\QuickCompanyaddController@storeFullDetail');
    Route::any('company-detail-report', 'Admin\QuickCompanyaddController@companyDetailReportIndex');
    Route::any('company-detail-report/pdf', 'Admin\QuickCompanyaddController@companyDetailReportPdf')->name('companyDetailPDF');

    //Company Users
    Route::any('company-users', function () {
        $saData['saCompanies'] = \App\Company::select('id', 'company_name')->orderBy('company_name', 'asc')->get()->toArray();
        $saData['saUsers'] = \App\User::select('id', 'name')->where('role_id', '3')->get()->toArray();

        return view('admin.company_users')->with($saData);
    })->middleware('auth');

    //Staff Admin
    Route::get('staff-admin', function () {
        $saData['saCompanies'] = \App\Company::select('id', 'company_name')->orderBy('company_name', 'asc')->get()->toArray();
        $saData['saUsers'] = \App\User::select('id', 'name')->where('role_id', '>=', '4')->get()->toArray();

        return view('admin.staff_users')->with($saData);
    })->middleware('auth');

    //Company List
    Route::get('companies/index', function () {
        $saData['saCompanies'] = \App\Company::select('id', 'company_name', 'cmp_start_date', 'comopnay_type', 'company_address_line_1', 'company_address_line_2', 'company_address_city', 'company_address_state', 'company_status')->orderBy('company_name', 'asc')->get()->toArray();

        return view('admin.company.index')->with($saData);
    })->middleware('auth');

    //Company Create
    Route::get('company/create', function () {
        return view('admin.company.create');
    })->name('company.create')->middleware('auth');

    Route::post('store-company-quick', 'Admin\QuickCompanyaddController@store');

    Route::delete('company-destroy/{id}', 'Admin\QuickCompanyaddController@destroy')->name('company.destroy')->middleware('auth');
    Route::get('company/status/change/{status}/{id}', 'Admin\QuickCompanyaddController@changeStatus')->name('company.status.change')->middleware('auth');
    Route::get('role-permission', 'Admin\RolePermissionController@Index')->middleware('auth');
    Route::get('role-permission-change', 'Admin\RolePermissionController@changePermissionAjax')->middleware('auth');
    Route::post('role-permission', 'Admin\RolePermissionController@store')->name('role-permission-store')->middleware('auth');
    Route::get('copy-company-user', 'Admin\RolePermissionController@copyCompanyUserForm')->middleware('auth');
    Route::post('store-copy-company', 'Admin\RolePermissionController@copyCompanyUserStore')->middleware('auth');
    Route::any('report/login-report', 'Admin\RolePermissionController@loginReportIndex')->middleware('auth');
    Route::post('report/login-report/pdf', 'Admin\RolePermissionController@loginReportPdf')->name('admin.cp.report.login.report')->middleware('auth');
    Route::get('upload/fuel-tax', 'Admin\FuelMatrixController@create')->middleware('auth');
    Route::post('upload/fuel-tax/store', 'Admin\FuelMatrixController@store')->name('import-fuel-tax.store')->middleware('auth');
    Route::get('user/re-send/credentials/{id}', 'NotificationController@resendCredential')->name('resend-user-cred')->middleware('auth');
    Route::PUT('admin/user/update/{id}', 'Admin\UserController@update')->name('admin.user.update')->middleware('auth');
    Route::post('admin/user/store', 'Admin\UserController@store')->name('admin.user.store')->middleware('auth');
    Route::delete('admin/user/delete/{id}', 'Admin\UserController@destroy')->name('admin.user.destroy')->middleware('auth');

    Route::get('user/re-send/owner/{id}', 'CompanyOwnersController@resendCredential')->name('make.user.owner')->middleware('auth');
    Route::delete('admin/ownership/{id}/destroy', 'CompanyOwnersController@destroy')->name('admin.ownership.destroy')->middleware('auth');
    Route::get('admin/ownership/{id}/show', 'CompanyOwnersController@show')->name('admin.ownership.show')->middleware('auth');
    Route::get('admin/ownership/add', 'CompanyOwnersController@create')->name('admin.ownership.add')->middleware('auth');
    Route::get('admin/ownership/{id}/edit', 'CompanyOwnersController@edit')->name('admin.ownership.edit')->middleware('auth');
    Route::patch('admin/ownership/{id}/update', 'CompanyOwnersController@update')->name('admin.ownership.update')->middleware('auth');
    Route::post('admin/ownership/store', 'CompanyOwnersController@store')->name('admin.ownership.store')->middleware('auth');

    Route::get('main-users', function () {
        $users = User::with('role')->orderBy('id', 'DESC')->get()->toArray();

        return view('admin.users.index')->with(compact('users'));
    })->middleware('auth');

    //User For Voyger Admin Route
    Voyager::routes();

    Route::get('login', 'Admin\VoyagerAuthController@login')->name('voyager.login');
    Route::post('login', 'Admin\VoyagerAuthController@postLogin')->name('voyager.postlogin');
});

Route::get('2fa', [App\Http\Controllers\TwoFAController::class, 'index'])->name('2fa.index');
Route::post('2fa', [App\Http\Controllers\TwoFAController::class, 'store'])->name('2fa.post');
Route::get('2fa/reset', [App\Http\Controllers\TwoFAController::class, 'resend'])->name('2fa.resend');

Route::get('change-emp-license-country-name', 'Employee\ImportEmployeeController@changeEmpLicenseCountryandState')->middleware(['auth', '2fa']);
Route::get('get_job_title_from_application', 'Employee\ImportEmployeeController@getJobTitleFromApplication')->middleware(['auth', '2fa']);

Auth::routes();

Route::get('/home', 'HomeController@index')->name('home')->middleware('2fa');
Route::get('/include-in-active-companies', 'HomeController@includeInActiveCompanies')->middleware('2fa');

Route::get('email-annoucemnet/create', 'EmailAmmoucementController@create')->name('cp.email.annoucemnent')->middleware('2fa');

Route::get('change-employee-status', 'Employee\ImportEmployeeController@ChangeStatus')->middleware(['auth', '2fa']);
Route::get('change-state-city-to-name', 'Employee\ImportEmployeeController@ChangeStateandCity')->middleware(['auth', '2fa']);
Route::get('view-notification/{key}', 'HomeController@showNotification');
Route::any('make-employee-terminated', 'Employee\BasicInfoController@MakeTerminated')->middleware(['auth', '2fa']);
Route::get('get-duplicate-ssn', 'EmailAmmoucementController@getDuplicateSSN')->middleware('auth');
Route::get('get-empty-termination-date', 'Employee\ImportEmployeeController@getEmptyTerminationDate')->middleware(['auth', '2fa']);

Route::get('create-app-user', 'NotificationController@createCmpOwner');


Route::resource('communication-notes', 'CommunicationNotesController'::class);
Route::get('communication-notes/{id}/history', 'CommunicationNotesController@history')->name('communication-notes.history');

Route::resource('miles', 'MilesController'::class);

Route::post('miles/report', 'MilesController@report')->name('miles.report');

Route::post('/distance-matrix', [DistanceMatrixController::class, 'getDistances']);

Route::post('sendgrid/webhook', 'SendGridWebhookController@handle');


Route::get('/email/logs', 'EmailAmmoucementController@viewLogs')->name('email.logs');

Route::get('change-country-name', function () {

    //iolation
    DriverTrafficViolation::where('country', 231)->update(['country' => 'United States']);
    $driver_violation = DriverTrafficViolation::whereNotNull('country')->get()->toArray();

    foreach ($driver_violation as $key => $value) {
        if (is_numeric($value['country']) && $value['country'] > 0) {

            $get_country = DB::table('countries')->where('id', $value['country'])->first();

            if (!empty($get_country)) {
                $get_violation = DriverTrafficViolation::where('id', $value['id'])->first();
                $get_violation->country = $get_country->name;
                $get_violation->save();
            }
        }
    }

    //Accidents
    DriverAccident::where('country', 231)->update(['country' => 'United States']);
    $driver_accident = DriverAccident::whereNotNull('country')->get()->toArray();

    foreach ($driver_accident as $key => $value) {
        if (is_numeric($value['country']) && $value['country'] > 0) {

            $get_country = DB::table('countries')->where('id', $value['country'])->first();

            if (!empty($get_country)) {
                $get_accident = DriverAccident::where('id', $value['id'])->first();
                $get_accident->country = $get_country->name;
                $get_accident->save();
            }
        }
    }

    //History
    DriverHistory::where('country', 231)->update(['country' => 'United States']);
    $driver_history = DriverHistory::whereNotNull('country')->get()->toArray();

    foreach ($driver_history as $key => $value) {
        if (is_numeric($value['country']) && $value['country'] > 0) {

            $get_country = DB::table('countries')->where('id', $value['country'])->first();

            if (!empty($get_country)) {
                $get_history = DriverHistory::where('id', $value['id'])->first();
                $get_history->country = $get_country->name;
                $get_history->save();
            }
        }
    }

    // Address
    DriverAddress::where('country', 231)->update(['country' => 'United States']);
    $driver_address = DriverAddress::whereNotNull('country')->get()->toArray();
    foreach ($driver_address as $key => $value) {
        if (is_numeric($value['country'])) {

            $get_country = DB::table('countries')->where('id', $value['country'])->first();

            if (!empty($get_country)) {
                $get_address = DriverAddress::where('id', $value['id'])->first();
                $get_address->country = $get_country->name;
                $get_address->save();
            }
        }
    }

    // License
    DriverLncInfo::where('country', 231)->update(['country' => 'United States']);

    $driver_license = DriverLncInfo::whereNotNull('country')->get()->toArray();
    foreach ($driver_license as $key => $value) {
        if (is_numeric($value['country'])) {

            $get_country = DB::table('countries')->where('id', $value['country'])->first();

            if (!empty($get_country)) {
                $get_license = DriverLncInfo::where('id', $value['id'])->first();
                $get_license->country = $get_country->name;
                $get_license->save();
            }
        }
    }

    echo 'Country Name Changed';
});