| Server IP : 199.250.214.225 / Your IP : 3.135.210.182 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 App\Http\Requests;
use Auth;
use Entrust;
use Illuminate\Http\Request;
use DB;
use carbon\carbon;
use App\Http\Controllers\Controller;
use Session;
class AuditLogController extends Controller
{
public function viewLog()
{
$ses = Session::get('userses');
$sesfrom =date('Y-m-d', strtotime(Session::get('fromSes')));
$sesto = date('Y-m-d', strtotime(Session::get('toSes')));
$date = \Carbon\Carbon::today()->subDays(30);
$data['users']= DB::table('users')->get();
//dd($sesfrom);
/*if($sesfrom)
{
$data['getLog']= DB::table('audit_log')
->join('users','users.id','=','audit_log.user_id')
->whereBetween('audit_log.date', [$sesfrom, $sesto])
//->where('audit_log.user_id', '=', $ses)
->orderBy('audit_log.date','desc')
->paginate(50);
}else{
$data['getLog'] = DB::table('audit_log')
->join('users','users.id','=','audit_log.user_id')
->where('date', '>=', $date)
->orderBy('date','desc')
->paginate(50);
}*/
$data['getLog'] = DB::table('audit_log')
->join('users','users.id','=','audit_log.user_id')
->where('date', '>=', $date)
->orderBy('date','desc')
->paginate(50);
return view('auditLog.listLog', $data);
}
public function searchLog(Request $request)
{
Session::forget('fromSes');
Session::forget('toSes');
Session::forget('userses');
Session::forget('searchQuery');
$this->validate($request,[
//'dateFrom' => 'required',
//'dateTo' => 'required',
]);
$data['users']= DB::table('users')->get();
$datefrom = date('Y-m-d', strtotime(trim($request['dateFrom'])));
$dateTo = date('Y-m-d', strtotime(trim($request['dateTo'])));
$df = trim($request['dateFrom']);
$dt = trim($request['dateTo']);
//dd($request['dateFrom']);
$user = $request['user'];
$request->session()->flash('date_from',$request['dateFrom']);
$request->session()->flash('date_to',$request['dateTo']);
$request->session()->flash('user_ses',$request['user']);
Session::put('fromSes', $datefrom);
Session::put('toSes', $dateTo);
Session::put('userses', $request['user']);
if($df != '' && $dt != '')
{
$data['getLog']= DB::table('audit_log')
->join('users','users.id','=','audit_log.user_id')
->whereBetween('audit_log.date', [$datefrom, $dateTo])
//->where('audit_log.user_id', '=', $ses)
->orderBy('audit_log.date','desc')
->paginate(50);
}
if($user != '' && $df == '' && $dt == '')
{
$data['getLog']= DB::table('audit_log')
->join('users','users.id','=','audit_log.user_id')
//->whereBetween('audit_log.date', [$datefrom, $dateTo])
->where('audit_log.user_id', '=', $user)
->orderBy('audit_log.date','desc')
->paginate(50);
//dd($data['getLog']);
}
if($user != '' && $df != '' && $dt != '')
{
$data['getLog']= DB::table('audit_log')
->join('users','users.id','=','audit_log.user_id')
->whereBetween('audit_log.date', [$datefrom, $dateTo])
->where('audit_log.user_id', '=', $user)
->orderBy('audit_log.date','desc')
->paginate(50);
}
return view('auditLog.listLog', $data);
}
}