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/ts.corals.io/corals-api/Corals/modules/Timesheet/update-batches/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

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

DB::table('settings')
    ->where('code', 'timesheet_start_of_week')
    ->update(['properties' => ['help_text' => '0 Sun - 6 Sat']]);

$employeeRoleSettingQB = DB::table('settings')->where('code', 'employee_role_id');

$role = Role::query()->where('id', $employeeRoleSettingQB->first()->value)->first();

$employeeRoleSettingQB->update(['code' => 'employee_role_name',
    'label' => 'Employee Role Name',
    'type' => 'TEXT',
    'value' => $role->name
]);