@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
@csrf
@foreach ($positions as $key => $p) @php $selectedDesignationQry = $editData->where('position_id', $p->uid)->pluck('designation_ids')->toArray(); $selDesig = array(); if(count($selectedDesignationQry) > 0){ $selDesig = explode(',',$selectedDesignationQry[0]); } $selectedRoleQry = $editData->where('position_id', $p->uid)->pluck('role_id')->toArray(); $selRole = array(); if(count($selectedRoleQry) > 0){ $selRole = explode(',',$selectedRoleQry[0]); } @endphp
@endforeach
@include('elements.button.common_button', [ 'back' => true, 'submitBtn' => [ 'id' => 'edit_updateBtn' ], 'print' => [ 'action' => 'print', 'title' => 'Print', 'exClass' => 'float-right', 'jsEvent' => 'onclick= window.print()' ] ])
@endsection