@extends('layouts/gnr_layout') @section('title', '| User Role') @section('content')
New User Role
@php $assingedUsers = DB::table('gnr_user_role')->pluck('userIdFK')->toArray(); $users = DB::table('users as t1') ->join('hr_emp_general_info as t2','t1.emp_id_fk','t2.id') ->whereNotIn('t1.id',$assingedUsers) ->select('t1.id as id','t2.emp_id as emp_id','t2.emp_name_english as emp_name_english') ->orderBy('emp_id') ->get(); /*$users = DB::table('hr_emp_general_info')->where('status',1)->whereIn('emp_id_fk',$userList)->select('id','emp_id','emp_name_english')->get();*/ $roles = array(''=>'Select Role') + DB::table('gnr_role')->where('id','>=',2)->pluck('name','id')->toArray(); $modules = DB::table('gnr_module')->select('id','name','code')->get(); $subFunctions = DB::table('gnr_sub_function')->select('id','subfunctionName')->get(); @endphp {!! Form::open(['url'=>'','class'=>'form-horizontal form-group']) !!}
{!! Form::label('userId', 'User:', ['class' => 'col-sm-2 control-label']) !!}
{!! Form::label('roleId', 'Role:', ['class' => 'col-sm-2 control-label']) !!}
{!! Form::select('roleId',$roles,null,['id'=>'roleId','class'=>'form-control']) !!}
{!! Form::label('description', 'Description:', ['class' => 'col-sm-2 control-label']) !!}
{!! Form::textArea('description', $value = null, ['class' => 'form-control', 'id' => 'description','rows'=>'2', 'placeholder' => 'Enter Description']) !!}
{!! Form::button('Submit', ['id' => 'submitButton', 'class' => 'btn btn-info']) !!} Close
{!! Form::close() !!}
{{-- Valid Till Modal --}} {{-- Valid Till Modal --}} @endsection