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();
         }
     }
 }
Beispiel #3
0
<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;
?>