| Server IP : 93.86.61.54 / Your IP : 216.73.216.60 Web Server : Apache/2.4.62 (Ubuntu) System : Linux rasin.ddns.net 6.8.0-124-generic #124~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Tue May 26 21:05:19 UTC x86_64 User : www-data ( 33) PHP Version : 8.4.22 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/projects/radvre_old/ |
Upload File : |
<!DOCTYPE html>
<!--
******************************
Project: Radno vreme, 2023.
Version: PHP 5-7
Author : M. Kukic
Note :
Link: http://net-nas/w3/radvre_v7/last.php
******************************
-->
<html>
<head>
<style>
table, th, td {
border: 1px solid gray;
border-collapse: collapse;
}
th, td {
padding: 4px;
text-align: center;
}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel='shortcut icon' type='image/png' href='favicon.png'/>
<meta http-equiv="refresh" content="20">
<title>Radno vreme</title>
</head>
<body>
<div style="width:720px; word-wrap:break-word;">
<?php
//
include "config.php";
include "hed.php";
//
echo "<h2 style='font-family:arial'>STATUS ZAPOSLENIH</h2>";
//
echo date("d/m/Y h:i:s A T",time())."<br><br>";
//
echo "<table style='background-color:#F0F8FF; width:720px; margin:0 auto;'>";
echo "<tr>";
echo "<th>LBr.</th>";
echo "<th>Disp-Name</th>";
echo "<th>Full-Name</th>";
echo "<th>In-Out</th>";
echo "<th>Vreme</th>";
echo "<th>Notes</th>";
echo "<th>Lokacija</th>";
echo "</tr>";
$i=0;
if ($db==5){ // MySQL ver 5
$sql = "SELECT * FROM user ORDER BY dispname";
$result_user = mysql_query($sql, $dbh) or die (mysql_error($dbh));
$nuz_user = mysql_num_rows($result_user);
$row_user = mysql_fetch_array($result_user);
for ($j = 1; $j<($nuz_user); $j++) {
$row_user = mysql_fetch_array($result_user);
$dn=$row_user['dispname'];
$fn=$row_user['fullname'];
$i=$i+1;
$sql = "SELECT * FROM logdog WHERE dispname='".$dn."' ORDER BY dattim DESC LIMIT 1";
$result_log = mysql_query($sql, $dbh) or die (mysql_error($dbh));
$row_log = mysql_fetch_array($result_log);
//
echo "<tr>";
//echo "<td>".$i."</td>";
echo "<td>".$row_log['id']."</td>";
echo "<td>".$dn."</td>";
echo "<td>".$fn."</td>";
echo "<td>".$row_log['in_out']."</td>";
$dt=$row_log['dattim'];
$vreme= date("d/m/Y h:i:s A",$dt);
//echo "<td>".$dt."</td>";
echo "<td>".$vreme."</td>";
echo "<td>".$row_log['notes']."</td>";
echo "<td>".$row_log['lokc']."</td>";
echo "</tr>";
}
echo "</table>";
echo "<br>";
//
mysql_close($dbh);
}else{ // MySQL ver 7
$sql = "SELECT * FROM user ORDER BY dispname";
$result_user = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
$nuz_user = mysqli_num_rows($result_user);
$row_user = mysqli_fetch_array($result_user);
for ($j = 1; $j<($nuz_user); $j++) {
$row_user = mysqli_fetch_array($result_user);
$dn=$row_user['dispname'];
$fn=$row_user['fullname'];
$i=$i+1;
$sql = "SELECT * FROM logdog WHERE dispname='".$dn."' ORDER BY dattim DESC LIMIT 1";
$result_log = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
$row_log = mysqli_fetch_array($result_log);
//
echo "<tr>";
//echo "<td>".$i."</td>";
echo "<td>".$row_log['id']."</td>";
echo "<td>".$dn."</td>";
echo "<td>".$fn."</td>";
echo "<td>".$row_log['in_out']."</td>";
$dt=$row_log['dattim'];
$vreme= date("d/m/Y h:i:s A",$dt);
//echo "<td>".$dt."</td>";
echo "<td>".$vreme."</td>";
echo "<td>".$row_log['notes']."</td>";
echo "<td>".$row_log['lokc']."</td>";
echo "</tr>";
}
echo "</table>";
echo "<br>";
mysqli_close($dbh);
} //END
?>
<hr>
<img src="img/b_white-2.png">
<a href="javascript:history.go(-1)"><img src="img/r_ret.png" width="" height="48"></a>
<img src="img/b_white-2.png">
<a href="rad.php?tip=1"><img src="img/r_ent.png" width="" height="48"></a>
<img src="img/b_white-2.png">
<a href="lista.php?tip=1"><img src="img/r_dw.png" width="" height="48"></a>
<img src="img/b_white-2.png">
<a href="help.php"><img src="img/r_hlp.png" width="" height="48"></a>
</div>
<?php include "fut.php";?>
</body>
</html>