| Server IP : 199.250.214.225 / Your IP : 18.219.147.124 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\Support\Facades\Log;
use Illuminate\Http\Request;
use App\Http\Requests;
use DB;
use Session;
class ControlVariableController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$data['getep'] = DB::table('tblearningParticular')->get();
$data['getedj'] = DB::table('tblcvSetup')
->join('tblearningParticular','tblearningParticular.ID','=','tblcvSetup.particularID')
->select('tblcvSetup.ID','Particular','description','status')
->orderBy('tblcvSetup.particularID', 'asc')->get();
//log::info('An informational message.');
$data['ID'] = Session::get('particularSession');
return view('controlVariable.controlVariable',$data);
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
//
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$this->validate($request, [
'particulars' =>'required',
'description' =>'required|unique:tblcvSetup,description',
]);
$particulars = trim($request['particulars']);
$description = trim($request['description']);
$description = str_replace('\'', '', $description);
log::info('char Description', ['is' => $description]);
$reallyStore = DB::table('tblcvSetup')->insert(array(
'particularID' =>$particulars,
'description' => $description,
'status' =>1,
));
if($reallyStore)
{
Session::put('particularSession', $particulars);
return redirect('/control-variable')->with('message', 'particular added');
}else{
Session::put('particularSession', $particulars);
return redirect('/control-variable')->with('error', 'info not added');
}
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
//
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
//
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request)
{
$this->validate($request, [
'descriptions' =>'required',
]);
$partDesc = trim($request['descriptions']);
$partId = trim($request['partid']);
$partStatus = trim($request['partStatus']);
log::info('Edited Description', ['partDesc' => $partDesc]);
//log::info('Edited status', ['partStatus' => $partStatus]);
DB::table('tblcvSetup')->where('ID',$partId)
->update(['description' => $partDesc,'status' => $partStatus]);
return redirect('/control-variable')->with('message', 'particular edited');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
//
}
}