88 lines
3.2 KiB
PHP
Executable File
88 lines
3.2 KiB
PHP
Executable File
<?php
|
|
|
|
use Illuminate\Database\Capsule\Manager as Capsule;
|
|
use App\Models\Module;
|
|
use Modules\Company\Models\Company;
|
|
|
|
class InsertCompanyModule
|
|
{
|
|
public function up()
|
|
{
|
|
$moduleData = [
|
|
'modules_name' => 'company',
|
|
'modules_display_name' => 'Company',
|
|
'modules_description' => 'Company management module',
|
|
'modules_version' => '1.0.0',
|
|
'modules_author' => 'SysCMS Team',
|
|
'modules_ative' => true,
|
|
'modules_public' => false,
|
|
'modules_blocked' => false,
|
|
'modules_dependencies' => ["auth"],
|
|
'modules_permissions' => [
|
|
"company.view",
|
|
"company.create",
|
|
"company.edit",
|
|
"company.delete"
|
|
],
|
|
'modules_settings' => [
|
|
'menu' => [
|
|
'dashboard' => [
|
|
'icon' => 'bi bi-building',
|
|
'label' => 'company.menu.dashboard',
|
|
'route' => 'admin/companies',
|
|
'order' => 30
|
|
]
|
|
]
|
|
],
|
|
'modules_path' => 'modules/company',
|
|
'modules_namespace' => 'Modules\\Company',
|
|
'modules_icon' => 'bi bi-building',
|
|
'menu_side_bar' => true,
|
|
'menu_nav_bar' => false,
|
|
'modules_order' => 30,
|
|
'modules_install_date' => date('Y-m-d H:i:s'),
|
|
'modules_update_date' => date('Y-m-d H:i:s')
|
|
];
|
|
|
|
$existingModule = Module::where('modules_name', 'company')->first();
|
|
|
|
if (!$existingModule) {
|
|
$module = Module::create($moduleData);
|
|
|
|
if (Capsule::schema()->hasTable('bus')) {
|
|
$companies = Company::all();
|
|
foreach ($companies as $company) {
|
|
$exists = Capsule::table('bus_modules')
|
|
->where('bus_modules_bus_id', $company->bus_id)
|
|
->where('bus_modules_module_id', $module->modules_id)
|
|
->exists();
|
|
|
|
if (!$exists) {
|
|
Capsule::table('bus_modules')->insert([
|
|
'bus_modules_bus_id' => $company->bus_id,
|
|
'bus_modules_module_id' => $module->modules_id,
|
|
'bus_modules_is_enabled' => true,
|
|
'bus_modules_settings' => json_encode([]),
|
|
'bus_modules_enabled_by' => 1,
|
|
'bus_modules_enabled_at' => date('Y-m-d H:i:s'),
|
|
'bus_modules_show_public_nav' => true,
|
|
'bus_modules_show_dashboard_nav' => true,
|
|
'created_at' => date('Y-m-d H:i:s'),
|
|
'updated_at' => date('Y-m-d H:i:s')
|
|
]);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
public function down()
|
|
{
|
|
$module = Module::where('modules_name', 'company')->first();
|
|
if ($module) {
|
|
Capsule::table('bus_modules')->where('bus_modules_module_id', $module->modules_id)->delete();
|
|
$module->delete();
|
|
}
|
|
}
|
|
}
|