@extends('Layouts.erp_master') @section('content') @php use App\Services\CommonService as Common; use App\Services\RoleService as Role; $positions = DB::table('gnl_dynamic_form_value')->where([['form_id', 3],['type_id', 3], ['is_delete', 0], ['is_active', 1]])->get(); $designations = DB::table('hr_designations')->where([['is_active', 1],['is_delete', 0]])->get(); $editData = DB::table('hr_designation_role_mapping')->get(); $role_ids = array(); $ids[] = Common::getRoleId(); $role_ids = array_merge($ids, Role::childRolesIds(Common::getRoleId())); $roles = DB::table("gnl_sys_user_roles") ->where([['is_delete', 0], ['is_active', 1]]) ->whereIn('id', $role_ids) ->select('id', 'role_name', 'parent_id', 'order_by') ->get(); // dd($positions,$designations,$editData,$roles); @endphp