| Server IP : 199.250.214.225 / Your IP : 3.22.216.128 Web Server : Apache System : Linux vps64074.inmotionhosting.com 3.10.0-1160.105.1.vz7.214.3 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : nicngo5 ( 1001) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /home/nicngo5/funds.upgrade.nicn.gov.ng/funds-upgraded/app/Http/Controllers/function_setup/ |
Upload File : |
<?php
namespace App\Http\Controllers\function_setup;
use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use App\Http\Requests;
use DB;
use session;
class AssignFunctionRoleController extends Controller
{
public function __construct(Request $request)
{
$this->roleid = $request->session()->get('current_role');
}
public function create()
{
$data['subfunctions'] = DB::table('function')
->join('subfunction','subfunction.functionID','=','function.functionID')
->get();
$data['roles'] = DB::table('user_role')->get();
$data['assignroles'] = DB::table('assign_function_role')->get();
$data['getrole'] = DB::table('user_role')->where('roleID','=',$this->roleid)->first();
$data['functions'] = DB::table('function')->get();
return view('function_setup/assignFunction/assign',$data);
}
public function assignSubFunction(Request $request)
{
$this->validate($request, [
'role' => 'required|numeric',
]);
$roleID = $request['role'];
$ID = $request['subFunction'];
$date = date('Y-m-d H:i:s');
//insert assigned roles
foreach ($ID as $key => $ID)
{
$IDs = $request['subFunction'][$key];
$functionID = $request['modu'][$key];
$data = DB::table('assign_function_role')->where('roleID','=',$roleID)->where('subfunctionID','=',$IDs)->count();
if($data >= 1)
{
DB::table('assign_function_role')->where('roleID', $roleID)->delete();
DB::table('assign_function_role')->insert(array(
'roleID' => $roleID,
'subfunctionID' => $IDs,
'functionID' => $functionID,
'created_at' => $date,
));
//}
}
else
{
DB::table('assign_function_role')->insert(array(
'roleID' => $roleID,
'subfunctionID' => $IDs,
'functionID' => $functionID,
'created_at' => $date,
));
}
}
return redirect('assign-function/create')->with('message','Function Assigned Successfully');
}
public function sessionset(Request $request)
{
$roleid = $request['role'];
$ses = Session::put('current_role', $roleid);
if($ses)
{
return response()->json("Successfully Set");
}
else
{
return response()->json("Not Set");
}
}
}