| Server IP : 172.67.189.169 / Your IP : 216.73.216.59 Web Server : Apache/2 System : Linux cat167-197.static.lnwhostname.com 5.10.0-20-amd64 #1 SMP Debian 5.10.158-2 (2022-12-13) x86_64 User : paphayomho ( 1042) PHP Version : 5.6.40 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/paphayomho/domains/paphayomhospital.go.th/private_html/hrm/user/ |
Upload File : |
<style>
.dash-summary{
display: flex;
justify-content:space-between;
width: 83%;
}
.dash-panel {
border: 1px solid #f0efef;
width: 48%;
padding: 1em 1em;
box-shadow: 2px 2px 7px #c8c8c8;
}
</style>
<?php
include_once('../controller/connect.php');
$dbs = new database();
$db=$dbs->connection();
$pending = 0;
$accepted = 0;
$EmpId = $_SESSION['User']['EmpId'];
$pending_sql = "SELECT Detail_Id FROM `leavedetails` where EmpId= '{$EmpId}' ";
$pending_qry = mysqli_query($db, $pending_sql);
$pending = $pending_qry->num_rows;
$accepted_sql = "SELECT *,sum(mon) as t1 FROM leavedetails WHERE LeaveStatus='Accept' and EmpId= '{$EmpId}'";
$accepted_qry = mysqli_query($db, $accepted_sql);
$accepted = $accepted_qry->num_rows;
?>
<?php
require_once 'conn.php';
$query = mysqli_query($conn, "SELECT *, sum(mon) AS total FROM leavedetails WHERE EmpId= '{$EmpId}' ") or die(mysqli_error());
while($fetch = mysqli_fetch_array($query)){
?>
<?php echo " <span class='text-info'>".$fetch['total']."บาท</span>"?>
<?php
}
?>
</div>
<?php include('userfooter.php'); ?>