| Server IP : 199.250.214.225 / Your IP : 13.59.128.133 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/ |
Upload File : |
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
//use Auth;
use App\Http\Requests;
use DB;
use Auth;
use Session;
class StaffDesignationController extends Controller
{
public function __construct()
{
$this->middleware('auth');
}
public function displayForm()
{
$data['users']=DB::table('users')->get();
$data['sections']=DB::table('tblsections')->get();
$data['staffsections']=DB::table('tblstaff_section')
->leftjoin('users', 'users.id', '=', 'tblstaff_section.user_id')
->leftjoin('tblsections', 'tblsections.code', '=', 'tblstaff_section.section')
->select('users.name','users.username','tblsections.code','tblsections.section','tblstaff_section.id','tblstaff_section.user_id')
->get();
return view('StaffDesignation.designation',$data);
}
public function assignDesignation(Request $request)
{
$users=$request->input('users');
$sections=$request->input('sections');
$this->validate($request, [
'users' => 'string',
'sections' => 'string',
]);
if($check=DB::table('tblstaff_section')->where('section',$sections)->where('user_id',$users)->first()){
return redirect('staff/designation')->with('message','User existed!');
}
else{
$pid = DB::table('tblstaff_section')->insert([
'section' => $sections,
'user_id' => $users,
]);
return redirect('staff/designation')->with('message','User Assigned!');
}
}
public function deleteDesignation($id)
{
$delete=DB::table('tblstaff_section')->where('id',$id )->delete();
return redirect('staff/designation')->with('message','Deleted!');
}
}