public function __Construct($dbHost, $dbUser, $dbPwd, $dbName, $Date, $fromDate, $toDate) { $Db = new DbConnection($dbHost, $dbUser, $dbPwd, $dbName); $this->DB = $Db->SelectDb(); if (!empty($toDate)) { self::$TFromDate = gmdate($fromDate); self::$TToDate = gmdate($toDate); // echo self::$TFromDate; // echo self::$TToDate; $this->FromDate = gmdate($fromDate); $this->ToDate = gmdate($toDate); //echo $this->FromDate; //echo $this->ToDate; } else { $this->Dte = gmdate($Date); // echo $this->Dte; } }
/** * Show the form for editing the specified resource. * * @param $user * @return Response */ public function getActivity($tickets) { if ($tickets->id) { $list = TicketLog::whereRaw('ticket_id = ?', array($tickets->id))->select(array('id', 'action', 'created_at')); if (Api::Enabled()) { $u = $list->get(); return Api::make($u->toArray()); } else { return Datatables::of($list)->edit_column('created_at', '{{{ Carbon::parse($created_at)->diffForHumans() }}}')->make(); } } }
<html> <?php include "DBconfig.php"; include "AuditClass.php"; include "TicketClass.php"; include "ProfileClass.php"; $AuditEntries = new AuditLog($dbHost, $dbUser, $dbPwd, $dbName, date('Y-m-d'), '', ''); $ProfileEntries = new ProfileActivity($dbHost, $dbUser, $dbPwd, $dbName, date('Y-m-d'), "", ""); $TicketEntries = new TicketLog($dbHost, $dbUser, $dbPwd, $dbName, date('Y-m-d'), "", ""); include "header.php"; ?> <script type="text/javascript"> $(document).ready( function () { Index=setTimeout(function(){window.location.href=document.URL;},180000); } ); </script> <body> <form method="post"> <?php include "Menu.php"; ?> <div id="Header"> </div> <footer class="Entries"> <div class="EntriesBody"> <div class="EntriesHead"><div>Activity Entries of today</div></div><br/> <div class="EntriesRow"> <div>Audit Entries:<?php $AuditEntries->AuditEntriesCount(); ?> </div></div>
<?php include "DBconfig.php"; include "TicketClass.php"; $TicketTimer = new TicketLog($dbHost, $dbUser, $dbPwd, $dbName, date('Y-m-d'), "", ""); $result = $TicketTimer->Display(); ?> <html> <head> <?php include "header.php"; ?> <script type="text/javascript"> $(document).ready( function () { $('#TicketTimerDetails').dataTable({ "iDisplayLength": 20, "iDisplayStart": 20 }); // alert("Ticket"); Ticket=setTimeout(function(){window.location.href=document.URL;},180000); } ); </script> </head> <body> <?php include "Menu.php"; ?> <div class="positionDownload"><a href="TicketTimerDownload.php">Download<a/></div><br/> <div class="TableTitle TableDetails">Ticket Log Details</div><hr/> <table id="TicketTimerDetails" class="display"> <thead>
<?php include "DBconfig.php"; include "TicketClass.php"; $Tfrm_dte = $_GET['fdate']; $Tto_dte = $_GET['tdate']; $TicketHistory = new TicketLog($dbHost, $dbUser, $dbPwd, $dbName, '', $Tfrm_dte, $Tto_dte); $result = $TicketHistory->Display(); ?> <html> <head> <?php include "header.php"; ?> <script type="text/javascript"> $(document).ready( function () { $('#TicketHistoryDetails').dataTable({ "iDisplayLength": 20, "iDisplayStart": 20 }); } ); </script> </head> <body> <?php include "Menu.php"; ?> <div class="positionDownload"><a href="TicketTimerDownload.php?Tfdate=<?php echo $Tfrm_dte; ?>