| Server IP : 2.57.91.28 / Your IP : 216.73.217.31 Web Server : LiteSpeed System : Linux id-dci-web1986.main-hosting.eu 5.14.0-611.26.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Jan 29 05:24:47 EST 2026 x86_64 User : u686484674 ( 686484674) PHP Version : 8.0.30 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u686484674/domains/idikotabandung.com/public_html/IDI/superadmin/ |
Upload File : |
<?php include "header.php";
// cek apakah yang mengakses halaman ini sudah login
if($_SESSION['level']<>"supervisor"){
header("location:location:../login.php");
}
?>
<!DOCTYPE html>
<html>
<head>
<script type="text/javascript" src="chartjs/Chart.js"></script>
<link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
<script src="https://code.jquery.com/jquery-1.12.4.js"></script>
<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
<script>
$( function() {
$( "#datepicker" ).datepicker({ dateFormat: 'yy-mm-dd' });
$( "#datepicker2" ).datepicker({ dateFormat: 'yy-mm-dd' });
} );
</script>
<title>INVOICE</title>
<link rel="stylesheet" href="jquery.dataTables.css">
<style type="text/css">
<!--
.style2 {font-family: Arial, Helvetica, sans-serif}
-->
.merah
{
color : red;
}
</style>
</head>
<body>
<?php
//$koneksi = mysqli_connect("localhost","bhaktiag_sales","cleosa2020","bhaktiag_sales");
//$koneksi = mysqli_connect("localhost","root","","agdsales");
?>
<?php include "bawahnotif.php"; ?>
<div class="container">
<div class="panel panel-primary">
<nav class="navbar navbar-inverse">
<div class="container-fluid">
<br>
<div class="navbar-header">
<a class="navbar-brand" href="index.php">Ikatan Dokter Indonesia</a>
</div>
</div>
</nav>
<div class="panel-body">
<center><h4>Data Anggota Baru</h4><center>
<br>
<table class="demo-table responsive" >
<thead>
<tr>
<th>No</th>
<th>ID</th>
<th>Nama</th>
<th>Keahlian</th>
<th>Alamat</th>
<th>Telp</th>
<th>No STTR</th>
<th>Masa Berlaku STR</th>
<th>Masa Berlaku Iuran</th>
<th>Action</th>
</tr>
</thead>
<tbody >
<?php
$hari = date('Y-m-d');
//require 'config.php';
$row = $konek->query("SELECT * FROM h_anggota where status='verifikasi' order by nmlead limit 10") or die(mysqli_error());
$hari = date('Y-m-d');
$no = 1;
while($fetch = $row->fetch_array()){
$str= $fetch['mbstr'];
$date = new DateTime($str);
$mbstr = $date->format('d-m-Y');
$tgliur= $fetch['tgliuran'];
$date = new DateTime($tgliur);
$tgliuran= $date->format('d-m-Y');
?>
<tr>
<td><?php echo $no ?></td>
<td><?php echo $fetch['npm']?></td>
<td><a href='d_psn2.php?npm=<?php echo $fetch['npm']; ?>'><?php echo $fetch['nmlead']?></a></td>
<td><?php echo $fetch['ahli']?></td>
<td><?php echo $fetch['alamat']?></td>
<td><?php echo $fetch['telp']?></td>
<td><?php echo $fetch['nostr']?></td>
<?php
IF($fetch['mbstr'] < $hari ){
?>
<td data-header='Masa berlaku STR'><span class='merah'><?php echo $mbstr; ?></span></td>
<?php
}else{
?>
<td data-header='Masa berlaku STR'><?php echo $mbstr; ?></td>
<?php
}
?>
<?php
IF($fetch['tgliuran'] < $hari ){
?>
<td data-header='Masa berlaku Iuran'><span class='merah'><?php echo $tgliuran; ?></span></td>
<?php
}else{
?>
<td data-header='Masa berlaku Iuran'><?php echo $tgliuran ?></td>
<?php
}
?>
<td data-header='Status' align='center' >
<a class='btn btn-danger btn-sm' href='d_psn2.php?npm=<?php echo $fetch['npm']; ?>'> Verifikasi</a>
</td>
</tr>
<?php
$no++;
}
?>
</tbody>
</table>
<br><br>
<center><h4>Data Anggota Iuran Expired</h4><center>
<br>
<table id="contoh" >
<thead>
<tr>
<th>No</th>
<th>ID</th>
<th>Nama</th>
<th>Keahlian</th>
<th>Alamat</th>
<th>Telp</th>
<th>No STTR</th>
<th>Masa Berlaku STR</th>
<th>Masa Berlaku Iuran</th>
<th>Action</th>
</tr>
</thead>
<tbody >
<?php
$hari = date('Y-m-d');
//require 'config.php';
$row = $konek->query("SELECT * FROM h_anggota2 where tgliuran < '$hari' order by id_tagihan") or die(mysqli_error());
$hari = date('Y-m-d');
$no = 1;
while($fetch = $row->fetch_array()){
$str= $fetch['mbstr'];
$date = new DateTime($str);
$mbstr = $date->format('d-m-Y');
$tgliur= $fetch['tgliuran'];
$date = new DateTime($tgliur);
$tgliuran= $date->format('d-m-Y');
?>
<tr>
<td><?php echo $no ?></td>
<td><?php echo $fetch['npm']?></td>
<td><a href='d_psn.php?npm=<?php echo $fetch['npm']; ?>'><?php echo $fetch['nmlead']?></a></td>
<td><?php echo $fetch['ahli']?></td>
<td><?php echo $fetch['alamat']?></td>
<td><?php echo $fetch['telp']?></td>
<td><?php echo $fetch['nostr']?></td>
<?php
IF($fetch['mbstr'] < $hari ){
?>
<td data-header='Masa berlaku STR'><span class='merah'><?php echo $mbstr; ?></span></td>
<?php
}else{
?>
<td data-header='Masa berlaku STR'><?php echo $mbstr; ?></td>
<?php
}
?>
<?php
IF($fetch['tgliuran'] < $hari ){
?>
<td data-header='Masa berlaku Iuran'><span class='merah'><?php echo $tgliuran; ?></span></td>
<?php
}else{
?>
<td data-header='Masa berlaku Iuran'><?php echo $tgliuran ?></td>
<?php
}
?>
<td data-header='Status' align='center' >
<?php
IF($fetch['tgliuran'] < $hari ){
?>
<a class='btn btn-danger btn-sm' href='b_inv.php?noreg=<?php echo $fetch['noreg']; ?>&npm=<?php echo $fetch['npm']; ?>'> Buat Invoice</a>
<?php
}else{
echo "-";
}
?>
</td>
</tr>
<?php
$no++;
}
?>
</tbody>
</table>
<br><br>
<br><br>
<center><h4>Data Anggota Iuran Non Expired </h4><center>
<br>
<table id="contoh2" >
<thead>
<tr>
<th>No</th>
<th>ID</th>
<th>Nama</th>
<th>Keahlian</th>
<th>Alamat</th>
<th>Telp</th>
<th>No STTR</th>
<th>Masa Berlaku STR</th>
<th>Masa Berlaku Iuran</th>
<th>Action</th>
</tr>
</thead>
<tbody >
<?php
$hari = date('Y-m-d');
//require 'config.php';
$row = $konek->query("SELECT * FROM h_anggota2 where tgliuran >'$hari' order by id_tagihan") or die(mysqli_error());
$hari = date('Y-m-d');
$no = 1;
while($fetch = $row->fetch_array()){
$str= $fetch['mbstr'];
$date = new DateTime($str);
$mbstr = $date->format('d-m-Y');
$tgliur= $fetch['tgliuran'];
$date = new DateTime($tgliur);
$tgliuran= $date->format('d-m-Y');
?>
<tr>
<td><?php echo $no ?></td>
<td><?php echo $fetch['npm']?></td>
<td><a href='d_psn.php?npm=<?php echo $fetch['npm']; ?>'><?php echo $fetch['nmlead']?></a></td>
<td><?php echo $fetch['ahli']?></td>
<td><?php echo $fetch['alamat']?></td>
<td><?php echo $fetch['telp']?></td>
<td><?php echo $fetch['nostr']?></td>
<?php
IF($fetch['mbstr'] < $hari ){
?>
<td data-header='Masa berlaku STR'><span class='merah'><?php echo $mbstr; ?></span></td>
<?php
}else{
?>
<td data-header='Masa berlaku STR'><?php echo $mbstr; ?></td>
<?php
}
?>
<?php
IF($fetch['tgliuran'] < $hari ){
?>
<td data-header='Masa berlaku Iuran'><span class='merah'><?php echo $tgliuran; ?></span></td>
<?php
}else{
?>
<td data-header='Masa berlaku Iuran'><?php echo $tgliuran ?></td>
<?php
}
?>
<td data-header='Status' align='center' >
<?php
IF($fetch['tgliuran'] < $hari ){
?>
<a class='btn btn-danger btn-sm' href='b_inv.php?noreg=<?php echo $fetch['noreg']; ?>&npm=<?php echo $fetch['npm']; ?>'> Buat Invoice</a>
<?php
}else{
echo "-";
}
?>
</td>
</tr>
<?php
$no++;
}
?>
</tbody>
</table>
<br><br>
</div>
<!-- proses edit data -->
<?php
if($_SERVER['REQUEST_METHOD']=='POST'){
//variabel untuk menampung inputan dari form
$id = $_POST['id'];
$npm = $_GET['npm'];
$noreg = $_GET['noreg'];
$nmlead = $_POST['nmlead'];
$tahap = $_POST['tahap']+1;
$dokumen = $_POST['doc'];
$keterangan = $_POST['ket'];
$status = $_POST['status'];
$tgl_cek = $_POST['tgl_cek'];
$tgl_reg = $_POST['tgl_reg'];
$ktp = $_POST['ktp'];
$sir = $_POST['sir'];
$foto = $_POST['foto'];
// simpan inputan user ke variabel
// $userInput = array('ket' => $data);
if($npm ==''){
echo "Form Belum lengkap Pilih Status....";
$nmlead=$userInput['ket'];
}else{
//mysqli_query($konek, "INSERT INTO d_reg(kota,tujuan,npm,tanggal,nmlead,telp,email,jmin,jmbls,keterangan,sumber,project)
// values('$kota','$tujuan','$npm','$tanggal','$nmlead','$telp','$email','$jmin','$jmbls','$ket','$sumber','$project')");
//mysqli_query($konek, "INSERT INTO d_progres(npm,noreg,tgl_cek,tgl_reg,nmlead,tahap,dokumen,status,keterangan)
// values('$npm','$noreg','$tgl_cek','$tgl_reg','$nmlead','$tahap','$dokumen','$status','$keterangan')");
$update = mysqli_query($konek, "UPDATE d_progres SET foto='$foto', sir='$sir',ktp='$ktp',data='chek',status='$status',keterangan='$keterangan',tgl_cek='$tgl_cek' WHERE id_tagihan='$id'");
//$update = mysqli_query($konek, "UPDATE d_reg SET kode='$data',type='$type',harga='$harga',cara_byr='$cara_byr',informasi='$catatan' WHERE d_reg.id_tagihan= '$_GET[id]'");
header('location:index.php');
//echo "$id";
if(!$update){
echo "Update data gagal...";
}else{
header('location:index.php');
}
}
}
?>
</div>
<head>
<script type="text/javascript" src="chartjs/Chart.js"></script>
</head>
<?php
$produk = mysqli_query($konek,"select ahli,count(ahli) as jumlah from d_praktek group by ahli ");
while($row = mysqli_fetch_array($produk)){
$nama_produk[] = $row['ahli'];
$total[] = $row['jumlah'];
//$query = mysqli_query($koneksi,"select count(nmlead) as jumlah from d_reg where npm='2001001' group by nmlead ");
//$row = $query->fetch_array();
//$jumlah_produk[] = $row['jumlah'];
}
?>
<script>
var ctx = document.getElementById("myChart").getContext('2d');
var myChart = new Chart(ctx, {
type: 'bar',
data: {
labels: <?php echo json_encode($nama_produk); ?>,
datasets: [{
label: 'Nilai menunjukan jumlah input Lead ',
data: <?php echo json_encode($total); ?>,
backgroundColor: [
'rgba(255, 99, 132, 0.2)',
'rgba(255, 99, 132, 0.2)',
'rgba(54, 162, 235, 0.2)',
'rgba(255, 206, 86, 0.2)',
'rgba(25, 206, 86, 0.2)',
'rgba(255, 99, 132, 0.2)',
'rgba(255, 99, 132, 0.2)',
'rgba(54, 162, 235, 0.2)',
'rgba(255, 206, 86, 0.2)',
'rgba(25, 206, 86, 0.2)',
'rgba(75, 192, 192, 0.2)'
],
borderColor: [
'rgba(255,99,132,1)',
'rgba(54, 162, 235, 1)',
'rgba(255, 206, 86, 1)',
'rgba(25, 206, 86, 1)',
'rgba(75, 192, 192, 1)',
'rgba(255,99,132,1)',
'rgba(54, 162, 235, 1)',
'rgba(255, 206, 86, 1)',
'rgba(25, 206, 86, 1)',
'rgba(75, 192, 192, 1)'
],
borderWidth: 1
}]
},
options: {
scales: {
yAxes: [{
ticks: {
beginAtZero:true
}
}]
}
}
});
</script>
<script src="http://code.jquery.com/jquery-1.10.2.min.js"></script><!-- -->
<script src="jquery.dataTables.js"></script>
<script>
$(document).ready(function() {
$('#contoh').dataTable(); // Menjalankan plugin DataTables pada id contoh. id contoh merupakan tabel yang kita gunakan untuk menampilkan data
} );
</script>
<script>
$(document).ready(function() {
$('#contoh2').dataTable(); // Menjalankan plugin DataTables pada id contoh. id contoh merupakan tabel yang kita gunakan untuk menampilkan data
} );
</script>
</div>
</div>
</div>
</div>
</body>
</html>