// --- TEMPORARY MANUAL DB UPDATE ROUTE ---
Route::get('/run-migrations-now', function () {
// 1. Add URL to site_features
try {
\Illuminate\Support\Facades\DB::statement("ALTER TABLE `site_features` ADD `url` VARCHAR(255) NULL AFTER `detail`");
} catch (\Exception $e) {} // Ignores if it already exists
// 2. Add admin_id to quotations
try {
\Illuminate\Support\Facades\DB::statement("ALTER TABLE `quotations` ADD `admin_id` INT UNSIGNED NULL AFTER `id`");
} catch (\Exception $e) {}
try {
\Illuminate\Support\Facades\DB::statement("ALTER TABLE `quotations` ADD CONSTRAINT `quotations_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `admins`(`id`) ON DELETE SET NULL");
} catch (\Exception $e) {}
// 3. Add Permissions
try {
$guards = ['admin', 'admin-session'];
foreach ($guards as $guard) {
$view = \Spatie\Permission\Models\Permission::firstOrCreate(
['name' => 'quotation.view', 'guard_name' => $guard],
['group_name' => 'quotation']
);
$create = \Spatie\Permission\Models\Permission::firstOrCreate(
['name' => 'quotation.create', 'guard_name' => $guard],
['group_name' => 'quotation']
);
$superAdmin = \Spatie\Permission\Models\Role::where('name', 'superadmin')->where('guard_name', $guard)->first();
if ($superAdmin) {
$superAdmin->givePermissionTo($view);
$superAdmin->givePermissionTo($create);
}
}
} catch (\Exception $e) {}
return "Manual Database Updates Completed Successfully!";
});
// ------------------------------------------
// --- TEMPORARY MANUAL DB UPDATE ROUTE ---
Route::get('/run-migrations-now', function () {
// 1. Add URL to site_features
try {
\Illuminate\Support\Facades\DB::statement("ALTER TABLE `site_features` ADD `url` VARCHAR(255) NULL AFTER `detail`");
} catch (\Exception $e) {} // Ignores if it already exists
// 2. Add admin_id to quotations
try {
\Illuminate\Support\Facades\DB::statement("ALTER TABLE `quotations` ADD `admin_id` INT UNSIGNED NULL AFTER `id`");
} catch (\Exception $e) {}
try {
\Illuminate\Support\Facades\DB::statement("ALTER TABLE `quotations` ADD CONSTRAINT `quotations_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `admins`(`id`) ON DELETE SET NULL");
} catch (\Exception $e) {}
// 3. Add Permissions
try {
$guards = ['admin', 'admin-session'];
foreach ($guards as $guard) {
$view = \Spatie\Permission\Models\Permission::firstOrCreate(
['name' => 'quotation.view', 'guard_name' => $guard],
['group_name' => 'quotation']
);
$create = \Spatie\Permission\Models\Permission::firstOrCreate(
['name' => 'quotation.create', 'guard_name' => $guard],
['group_name' => 'quotation']
);
$superAdmin = \Spatie\Permission\Models\Role::where('name', 'superadmin')->where('guard_name', $guard)->first();
if ($superAdmin) {
$superAdmin->givePermissionTo($view);
$superAdmin->givePermissionTo($create);
}
}
} catch (\Exception $e) {}
return "Manual Database Updates Completed Successfully!";
});
// ------------------------------------------
Not Found