ÿØÿà JFIF ÿá Exif MM * ÿÛ C
Server IP : 199.250.214.225 / Your IP : 3.133.126.232 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 PromotionSelfController extends functionController { public function __construct() { $this->username = Session::get('userName'); $this->middleware('auth'); }// public function GetPromotion() { $data['error'] = ""; $data['warning'] = ""; $data['success'] = ""; $data['staffid'] = ""; $data['prevgrade'] = ""; $data['prevstep'] = ""; $data['newgrade'] = ""; $data['newstep'] = ""; $data['approvedate'] = ""; $staffid=$this->StaffNo($this->username); $data['staffPromotion']=DB::Select("SELECT * ,(Select CONCAT(tblper.surname,' ', tblper.first_name ,' ', tblper.othernames) from tblper where tblper.fileNo=tblstaff_promotion.staffid ) as `StaffName`FROM `tblstaff_promotion` WHERE `tblstaff_promotion`.`staffid`='$staffid'"); return view('Promotion.staffpromotion',$data); } public function PostPromotion(Request $request) { $data['error'] = ""; $data['warning'] = ""; $data['success'] = ""; $data['staffid'] = $this->StaffNo($this->username); $data['prevgrade'] = trim($request['prevgrade']); $data['prevstep'] = trim($request['prevstep']); $data['newgrade'] = trim($request['newgrade']); $data['newstep'] = trim($request['newstep']); $data['approvedate'] = trim($request['approvedate']); $promodate = trim($request['approvedate']); $prevgrade = trim($request['prevgrade']); $prevstep = trim($request['prevstep']); $newgrade = trim($request['newgrade']); $newstep = trim($request['newstep']); $staffid = $this->StaffNo($this->username); $delcode = trim($request['delcode']); $updated_date = (date('Y-m-d')); $updatedby = $this->username; DB::delete("DELETE FROM `tblstaff_promotion` WHERE `promoid`='$delcode'"); if ( isset( $_POST['add'] ) ) { DB::insert("INSERT INTO `tblstaff_promotion`( `promodate`, `prevgrade`, `prevstep`, `newgrade`, `newstep`, `staffid`, `updated_date`, `updatedby`) VALUES ('$promodate','$prevgrade','$prevstep','$newgrade','$newstep','$staffid','$updated_date','$updatedby')"); } $data['staffPromotion']=DB::Select("SELECT * ,(Select CONCAT(tblper.surname,' ', tblper.first_name ,' ', tblper.othernames) from tblper where tblper.fileNo=tblstaff_promotion.staffid ) as `StaffName` FROM `tblstaff_promotion` WHERE `tblstaff_promotion`.`staffid`='$staffid'"); $data['staffList']=DB::Select("SELECT UserID, fileNo, surname, first_name, othernames,email FROM tblper"); return view('Promotion.staffpromotion',$data); } }