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/update-batches/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

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

$adminRoleId = Role::findByName('admin')->id;
$dataEntryRoleId = Role::findByName('data_entry')->id;

$reportsMenuId = DB::table('menus')->insertGetId([
    'parent_id' => 1,// admin
    'key' => 'ledger-reports',
    '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
    ],
]);