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;
?>
