Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/ledger.corals.io/Corals/modules/Ledger/database/seeds/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

namespace Corals\Modules\Ledger\database\seeds;

use Corals\User\Models\Role;
use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;

class LedgerMenuDatabaseSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $adminRoleId = Role::findByName('admin')->id;
        $dataEntryRoleId = Role::findByName('data_entry')->id;

        $ledger_menu_id = DB::table('menus')->insertGetId([
            'parent_id' => 1,// admin
            'key' => 'ledger-reports',
            'url' => null,
            'active_menu_url' => 'ledgers*',
            'name' => 'Ledger',
            'description' => 'Ledger Menu Item',
            'icon' => 'fa fa-globe',
            'target' => null,
            'roles' => '["1"]',
            'order' => 0
        ]);

        // seed children menu
        DB::table('menus')->insert([
                [
                    'parent_id' => $ledger_menu_id,
                    'key' => null,
                    'url' => config('ledger.models.item.resource_url'),
                    'active_menu_url' => config('ledger.models.item.resource_url') . '*',
                    'name' => 'Items',
                    'description' => 'Ledgers List Menu Item',
                    'icon' => 'fa fa-cube fa-fw',
                    'target' => null,
                    'roles' => '["1"]',
                    'order' => 1
                ],
                [
                    'parent_id' => $ledger_menu_id,
                    'key' => null,
                    'url' => config('ledger.models.account.resource_url'),
                    'active_menu_url' => config('ledger.models.account.resource_url') . '*',
                    'name' => 'Accounts',
                    'description' => 'Ledgers List Menu Account',
                    'icon' => 'fa fa-cube fa-fw',
                    'target' => null,
                    'roles' => '["1"]',
                    'order' => 1
                ],
                [
                    'parent_id' => $ledger_menu_id,
                    'key' => null,
                    'url' => config('ledger.models.record.resource_url'),
                    'active_menu_url' => config('ledger.models.record.resource_url') . '*',
                    'name' => 'Records',
                    'description' => 'Ledgers List Menu Record',
                    'icon' => 'fa fa-cube fa-fw',
                    'target' => null,
                    'roles' => '["1"]',
                    'order' => 1
                ],
                [
                    'parent_id' => 1,
                    'key' => null,
                    'url' => config('ledger.models.item.resource_url'),
                    'active_menu_url' => config('ledger.models.item.resource_url') . '*',
                    'name' => 'Items',
                    'description' => 'Ledgers List Menu Item',
                    'icon' => 'fa fa-cube fa-fw',
                    'target' => null,
                    'roles' => '["' . $adminRoleId . '"]',
                    'order' => 1
                ],
                [
                    'parent_id' => 1,
                    'key' => null,
                    'url' => config('ledger.models.account.resource_url'),
                    'active_menu_url' => config('ledger.models.account.resource_url') . '*',
                    'name' => 'Accounts',
                    'description' => 'Ledgers List Menu Account',
                    'icon' => 'fa fa-cube fa-fw',
                    'target' => null,
                    'roles' => '["' . $adminRoleId . '"]',
                    'order' => 1
                ],
                [
                    'parent_id' => 1,
                    'key' => null,
                    'url' => config('ledger.models.record.resource_url'),
                    'active_menu_url' => config('ledger.models.record.resource_url') . '*',
                    'name' => 'Records',
                    'description' => 'Ledgers List Menu Record',
                    'icon' => 'fa fa-cube fa-fw',
                    'target' => null,
                    'roles' => '["' . $adminRoleId . '","' . $dataEntryRoleId . '"]',
                    'order' => 1
                ],
            ]
        );

        $reportsMenuId = DB::table('menus')->insertGetId([
            'parent_id' => 1,// admin
            'key' => 'ledger',
            'url' => null,
            'active_menu_url' => 'ledgers/reports*',
            'name' => 'Reports',
            'description' => 'Ledger Reports Menu Item',
            'icon' => 'fa fa-globe',
            'target' => null,
            'roles' => '["1","' . $adminRoleId . '"]',
            'order' => 0
        ]);

        DB::table('menus')->insert([
            [
                'parent_id' => $reportsMenuId,
                'key' => null,
                'url' => 'ledger/reports/balance-report',
                'active_menu_url' => 'ledger/reports/balance-report',
                'name' => 'Balance Report',
                'description' => 'Balance Report List Menu Item',
                'icon' => 'fa fa-file-text-o fa-fw',
                'target' => null,
                'roles' => '["1","' . $adminRoleId . '"]',
                'order' => 1
            ],
        ]);
    }
}