| Server IP : 88.223.91.129 / Your IP : 216.73.216.52 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/project/ |
Upload File : |
<?php include "header.php"; ?>
<?php
$id_user=$_SESSION["npm"];
$username=$_SESSION["level"];
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- link to magiczoom.css file -->
<link href="magiczoom.css" rel="stylesheet" type="text/css" media="screen"/>
<!-- link to magiczoom.js file -->
<script src="magiczoom.js" type="text/javascript"></script>
<style type="text/css">
body {
font-family: "Lucida Sans Unicode", "Lucida Grande", "Segoe Ui";
}
/* Table */
table {
margin: auto;
font-family: "Lucida Sans Unicode", "Lucida Grande", "Segoe Ui";
font-size: 12px;
}
.prog-table {
border-collapse: collapse;
font-size: 13px;
}
.prog-table th,
.prog-table td {
border-bottom: 1px solid #e1edff;
border-left: 1px solid #e1edff;
padding: 7px 17px;
}
.prog-table th,
.prog-table td:last-child {
border-right: 1px solid #e1edff;
}
.prog-table td:first-child {
border-top: 1px solid #e1edff;
}
.prog-table td:last-child{
border-bottom: 0;
}
caption {
caption-side: top;
margin-bottom: 10px;
}
/* Table Header */
.prog-table thead th {
background-color: #508abb;
color: #FFFFFF;
border-color: #6ea1cc !important;
text-transform: uppercase;
}
/* Table Body */
.prog-table tbody td {
color: #353535;
}
.style1 {
font-size: 18;
font-family: Arial, Helvetica, sans-serif;
font-weight: bold;
}
.style2 {
font-family: Arial, Helvetica, sans-serif;
font-size: 16px;
font-weight: bold;
}
.style3 {
font-size: 16px;
font-weight: bold;
}
</style>
</head>
<body>
<?php include "bawah.php"; ?>
<?php
$view = isset($_GET['view']) ? $_GET['view'] : null;
switch($view){
default:
?>
<div class="container">
<br>
<div class="panel panel-primary">
<nav class="navbar navbar-inverse">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="index.php">Ikatan Dokter Indonesia</a>
</div>
</div>
</nav>
<?php
$noreg = isset($_GET['noreg']) ? $_GET['noreg'] : '';
$npm = $_GET['npm'];
?>
<p align="center">No Reg Pengajuan : <?php echo $noreg ?></p>
<div align="center"><span class="style2">Progress <br>Pengajuan Surat Rekomendasi IDI</span></center>
<br/>
<div class="table-container"></div>
<div class="panel-body">
<table class="prog-table responsive" >
<thead>
<tr>
<th>Tahap</th>
<th>Note</th>
<th>Tgl Cek</th>
<th>status</th>
<th>Tgl Revisi</th>
<th>Note dari Admin</th>
<th>Validasi</th>
<th>Action</th>
</tr>
</thead>
<?php
//mysql_connect("localhost","root","");
//mysql_select_db("mahasiswa");
//if(isset($_GET['npm'])){
//$cari = $_GET['npm'];
$npm = $_GET['npm'];
$sql = mysqli_query($konek, "SELECT * FROM d_progres WHERE npm='$npm' AND noreg='$noreg' order by tahap ");
$no=1;
$total =0;
while($d=mysqli_fetch_array($sql)){
?>
<tr>
<?php
if($d['tahap'] == '1'){
?>
<td bgcolor='#FF4F4F' ><?php echo $d['tahap']; ?></td>
<?php
}
elseif ($d['tahap'] == '2'){
?>
<td bgcolor='#FFDE5B' ><?php echo $d['tahap']; ?></td>
<?php
}
elseif($d['tahap'] == '3'){
?>
<td bgcolor='#44FFFF' ><?php echo $d['tahap']; ?></td>
<?php
}
elseif($d['tahap'] == '4'){
?>
<td bgcolor='#99FF66' ><?php echo $d['tahap']; ?></td>
<?php
}
elseif($d['tahap'] == '5'){
?>
<td bgcolor='#5398FF' ><?php echo $d['tahap']; ?></td>
<?php
}
?>
<td data-header='Tgl Registrasi'><?php echo $d['note']; ?></td>
<?php
if($d['tgl_cek'] == '0000-00-00'){
?>
<td><?php echo '-' ?></td>
<?php
}else{
?>
<td><?php echo $d['tgl_cek']; ?></td>
<?php
}
?>
<td data-header='Status'><?php echo $d['status']; ?></td>
<?php
if($d['tgl_rev'] == '0000-00-00'){
?>
<td> <?php echo '-' ?></td>
<?php
}else{
?>
<td<?php echo $d['tgl_rev']; ?></td>
<?php
}
?>
<td data-header='Keterangan' align='left'><?php echo $d['keterangan']; ?></td>
<td data-header='Permintaan Revisi' align='left'><?php echo $d['status2']; ?></td>
<td data-header='Action' align='center' >
<?php
if($d['status2'] == 'revisi'){
?>
<a class='btn btn-success btn-sm' href='revisi.php?npm=<?php echo $_GET['npm']; ?>&id=<?php echo $d['id_tagihan']; ?>&noreg=<?php echo $_GET['noreg']; ?>&nmlead=<?php echo $d['nmlead']; ?>&ket=<?php echo $d['keterangan']; ?>'>Revisi Kelengkapan dokumen</a>
<?php
}else{
echo "-";
}
?>
<?php
if($d['status'] == 'revisi'){
?>
<a class='btn btn-success btn-sm' href='revisi.php?npm=<?php echo $_GET['npm']; ?>&id=<?php echo $d['id_tagihan']; ?>&noreg=<?php echo $_GET['noreg']; ?>&nmlead=<?php echo $d['nmlead']; ?>&ket=<?php echo $d['keterangan']; ?>'>Revisi Kelengkapan dokumen</a>
<?php
}else{
echo "-";
}
?>
</td>
</tr>
<?php $no++; ?>
<?php
$status2=$d['status2'];
}
?>
</table>
<br>
<div><caption class="title"> <span class="merah"> Warna Tahap : </span></caption>
Warna Merah Verifikasi Data, Kuning Data Sudah Lengkap, Hijau Muda Menunggu SK, Biru Selesai </p>
</div>
<?php
}
?>
</br>
<br>
<span class="style3">Tabel: Data Pribadi dan STR
</span> <br>
<?php
$hari = date('Y-m-d');
$sqlSiswa = mysqli_query($konek, "SELECT * FROM h_registrasi WHERE h_registrasi.npm='$_GET[npm]' AND h_registrasi.noreg='$_GET[noreg]'");
$ds=mysqli_fetch_array($sqlSiswa);
$mbstr= $ds['mbstr'];
?>
<?php if ( $mbstr<$hari){
echo "
<div class='alert alert-warning'>
<span class='glyphicon glyphicon-info-sign'></span> Masa berlaku STR : <span style='color:red'> $mbstr</span> Sudah Expired !!
<span class='pull-right'><a href='#d_new.php'> <span style='color:red'>Revisi STR </span><i class='fa fa-angle-double-right'></i></a></span>
</div>";
}
?>
<br>
<table class="demo-table responsive" >
<thead>
<tr>
<th>No</th>
<th>Tgl registrasi</th>
<th>No registasi</th>
<th>Nama</th>
<th>Alamat</th>
<th>Keahlian</th>
<th>No STR</th>
<th>MB STR</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$no = 1;
//$data = mysqli_query($konek,"select count( d_reg.kode='Closing') as pros, d_reg.project,d_reg.nmlead, d_reg.npm ,count(d_reg.npm) as jumlah,d_reg.kode, mahasiswa.nama_mhs from d_reg INNER JOIN mahasiswa ON d_reg.npm=mahasiswa.npm where mahasiswa.project='$_GET[project]' group by npm ");
//$data = mysqli_query($konek,"select d_reg.telp,d_reg.kode,d_reg.tgl_input,d_reg.project,d_reg.nmlead, d_reg.npm ,count(d_reg.nmlead) as jumlah,mahasiswa.nama_mhs from d_reg INNER JOIN mahasiswa ON d_reg.npm=mahasiswa.npm where d_reg.kode <> 'Close' AND mahasiswa.npm='$_GET[npm]' group by telp ");
$data = mysqli_query($konek,"select * from h_registrasi where id_tagihan
IN (SELECT MAX(id_tagihan) FROM h_registrasi where h_registrasi.npm='$_GET[npm]' AND h_registrasi.noreg='$noreg' GROUP BY noreg ) " );
$no = 1;
while($d=mysqli_fetch_array($data)){
$hari = date('Y-m-d');
$ahli=$d['ahli'];
?>
<tr>
<td data-header='No' > <?php echo $no; ?> </td>
<td data-header='Tgl Registrasi'><?php echo $d['tgl_reg']; ?></td>
<td data-header='No Registrasi'><?php echo $d['noreg']; ?></td>
<td data-header='Nama'><?php echo $d['nmlead']; ?></td>
<td data-header='Alamat'><?php echo $d['alamat']; ?></td>
<td data-header='Spesialis'><?php echo $d['ahli']; ?></td>
<td data-header='No STR'><?php echo $d['nostr']; ?><br></td>
<?php
IF($d['mbstr'] < $hari ){
?>
<td data-header='Masa Berlaku STR'><span class='merah'><?php echo $d['mbstr']; ?></span></td>
<?php
}else{
?>
<td data-header='Masa Berlaku STR'><?php echo $d['mbstr']; ?></td>
<?php
}
?>
<td data-header='Status'><span class='merah'><?php echo $d['status']; ?></span></td>
<td data-header='Status' align='center' >
<?php
if($d['status'] == 'proses'){
?>
<a class='btn btn-success btn-sm' href='r_registrasi.php?noreg=<?php echo $d['noreg']; ?>&npm=<?php echo $d['npm']; ?>&ket=<?php echo $_GET['ket']; ?>'>Revisi</a>
<?php
}else{
echo "-";
}
?>
</td>
</tr>
<?php $no++; ?>
<?php
$mbstr=$d['mbstr'] ;
// $tglexp=$d['iuran'] ;
$iuran=$d['iuran'] ;
}
?>
<td>
<td>
<?php echo "Keterangan:" ?>
<td>
<?php
IF($mbstr < $hari ){
?>
<?php echo " Masa berlaku STR : " ?><span class='merah'><?php echo $mbstr; ?></span> <br>
<span class='merah'><?php echo " Masa berlaku STR sudah Expired Silahkan Revisi STR" ?></span>
<?php
}else{
echo "Valid" ;
}
?>
</tr>
</tbody>
</table>
<br>
<br>
<span class="style3">Data Iuran 5 tahun /Invoice
</span> <br> <br>
<br>
<table id="contoh" class="demo-table responsive" >
<thead>
<tr>
<th>No</th>
<th>ID </th>
<th>No Registrasi</th>
<th>No Invoice</th>
<th>Nama</th>
<th>Alamat</th>
<th>Exp Iuran</th>
<th>Nominal Iuran</th>
<th>Iuran selanjutnya</th>
<th>status</th>
<th>Invoice</th>
</tr>
</thead>
<tbody >
<?php
$hari = date('Y-m-d');
//require 'config.php';
$row = $konek->query("SELECT * FROM h_registrasi where npm='$_GET[npm]' AND noreg='$_GET[noreg]' order by nmlead") 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');
$tgliuran= $fetch['iuran'];
$date = new DateTime($tgliuran);
$iuran= $date->format('d-m-Y');
$tgl3 = date('Y-m-d', strtotime('+1825 days', strtotime($tgliuran)));
$date = new DateTime($tgl3);
$tgl2 = $date->format('d-m-Y');
?>
<tr>
<td data-header='No'><?php echo $no ?></td>
<td data-header='No ID'><?php echo $fetch['npm']?></td>
<td data-header='No Registrasi'><?php echo $fetch['noreg']?></td>
<td data-header='No Invoice'><?php echo $fetch['noinv']?></td>
<td data-header='Nama'><?php echo $fetch['nmlead']?></td>
<td data-header='Alamat'><?php echo $fetch['alamat']?></td>
<?php
IF($fetch['iuran'] < $hari ){
?>
<td data-header='Masa berlaku Iuran'><span class='merah'><?php echo $iuran; ?></span></td>
<?php
}else{
?>
<td data-header='Masa berlaku Iuran'><?php echo $iuran ?></td>
<?php
}
?>
<td><?php echo '5.000.000'?></td>
<td data-header='Tanggal Iuran'><?php echo $fetch['tgliuran']?></td>
<?php
IF($fetch['pinv'] <> 'lunas' ){
?>
<td data-header='Status Invoice'><span class='merah'><?php echo $fetch['pinv']?></span'></td>
<?php
}else{
?>
<td data-header='Status Invoice'><?php echo $fetch['pinv']?></td>
<?php
}
?>
<td data-header='Action' align='center' >
<?php
IF($fetch['pinv'] == 'tagihan'){
?>
<a class='btn btn-danger btn-sm' href='b_inv.php?noreg=<?php echo $fetch['noreg']; ?>&npm=<?php echo $fetch['npm']; ?>&tgl2=<?php echo $tgl3; ?>'>Bayar Invoice</a>
<?php
}else{
echo "-";
}
?>
</td>
</tr>
<?php
$no++;
// $tglexp=$d['iuran'] ;
$pinv=$fetch['pinv'] ;
}
?>
<td>
<td>
<?php echo "Keterangan:" ?>
<td>
<?php
IF($pinv=='expired'){
?>
<?php echo " Iuran : " ?><span class='merah'><?php echo $iuran; ?><br>
</span><span class='merah'><?php echo " Masa berlaku Iuran sudah Expired Lakukan pelunasan Invoice " ?></span>
<?php
}else{
echo " $pinv " ;
}
?>
<td>
<?php
IF($pinv =='lunas'){
?>
<span class='merah'><?php echo $pinv ?><br>
<?php
}else if($pinv == 'bayar'){
echo "Tunggu Verifikasi Pembayaran";
}else if($pinv == 'tagihan'){
echo "Bayar Invoice";
}else if($pinv == 'expired'){
echo "Tunggu Invoice";
}else{
echo "-" ;
}
?>
</tr>
</tbody>
</table>
<br /><br />
<span class="style3">Data praktek Dokter
</span>
</br>
<br>
</table>
<table class="demo-table responsive">
<thead>
<tr>
<th scope="col">Praktik ke :</th>
<th scope="col"> telp</th>
<th scope="col">Sarana Praktek</th>
<th scope="col">alamat Praktik</th>
<th scope="col">Hari Praktek</th>
<th scope="col">Jam praktek </th>
<th scope="col">Status </th>
</tr>
<thead>
<?php
date_default_timezone_set('Asia/Jakarta');
// $sql=mysqli_query($konek, "SELECT * FROM mahasiswa WHERE npm='$_GET[noijazah]'");
$sql = mysqli_query($konek, "select d_praktek.* from d_praktek WHERE npm='$_GET[npm]' AND noreg='$_GET[noreg]' order by praktek ");
//$sql = mysqli_query($konek, "select d_reg.* from d_reg WHERE npm='$_GET[npm]' AND noreg='$_GET[noreg]' order by tahap ");
?>
<?php
$no = 1;
while($du=mysqli_fetch_array($sql)){
?>
<tr>
<td data-header='No'><?php echo $no; ?></td>
<td data-header='Telpon'><?php echo $du['telp']; ?></td>
<td data-header='Wilayah Kerja'><?php echo $du['wilker']; ?></td>
<td data-header='Alamat'><?php echo $du['alamat']; ?></td>
<td data-header='Hari Praktek' ><?php echo $du['hari']; ?></td>
<td data-header='Hari Praktek' ><?php echo $du['jam1']; ?></td>
<td data-header='Hari Praktek' <span class='merah'><?php echo $du['status']; ?> </span></td>
</tr>
<?php $no++; ?>
<?php
$nmlead=$du['nmlead'];
}
?>
</table>
<td>
<?php
$npm=$_GET['npm'];
?>
</td>
<p> </p>
<?php
IF($status2 == 'finish'){
echo "-";
}else if ($status2 == 'valid'){
echo "-";
}else if ($status2 == 'revisi'){
?>
<p><a class='btn btn-success btn-sm' href='edt_praktek.php?npm=<?php echo $_GET['npm']; ?>&noreg=<?php echo $_GET['noreg']; ?>&nmlead=<?php echo $_GET['nmlead']; ?>&ahli=<?php echo $ahli; ?>'>Edit</a>
<?php
}else{
?>
<p><a class='btn btn-success btn-sm' href='edt_praktek.php?npm=<?php echo $_GET['npm']; ?>&noreg=<?php echo $_GET['noreg']; ?>&nmlead=<?php echo $_GET['nmlead']; ?>&ahli=<?php echo $ahli; ?>'>Edit</a>
<?php
}
?>
</p>
<br />
<br>
<span class="style3">Tabel Upload Document</span>
<br>
<form class="form-inline" method="POST" action="upload22.php" enctype="multipart/form-data">
<br>
<input name="npm" readonly class="form-control" type="hidden" value="<?php echo $_GET['npm'] ?>" />
<input name="noreg" readonly class="form-control" type="hidden" value="<?php echo $_GET['noreg'] ?>" />
<input name="nmlead" readonly class="form-control" type="hidden" value="<?php echo $_GET['nmlead'] ?>" />
<input name="ket" readonly class="form-control" type="hidden" value="<?php echo $_GET['ket'] ?>" />
<input class="form-control" type="file" name="upload22"/>
<button type="submit" class="btn btn-success form-control" name="submit"><span class="glyphicon glyphicon-upload"></span> Upload</button>
</form>
<br />
<table id="example" class="demo-table responsive" style="width:100%">
<thead>
<tr>
<th>No</th>
<th>Name</th>
<th>File Name</th>
<th>Status</th>
</tr>
</thead>
<tbody class="alert-success">
<?php
$row = $konek->query("SELECT *,count( file_id) as jumlah FROM file WHERE noreg='$_GET[noreg]' group by nmfile") or die(mysqli_error());
$no = 1;
while($fetch = $row->fetch_array()){
?>
<tr>
<?php
$name = explode('/', $fetch['file']);
?>
<td><?php echo $no?></td>
<td><?php echo $fetch['nmfile']?></td>
<td><?php echo $fetch['name']?></td>
<td><span class='merah'><?php echo $fetch['status']?></span></td>
</tr>
<?php
$no++;
$jumlah= $fetch['jumlah'];
$total += $fetch['jumlah'];
}
$selisih = 10-$total ;
?>
<td>
<td>
</span><strong><?php echo "Total document: " ?>
<span class='merah'><span class='style1'><?php echo $total ?></span></span></strong>
<td>
<strong class=;style1'><?php echo "Total Document di upload ada 10, Upload Sisa : " ?></strong>
<strong><span class='merah'><?php echo $selisih ?></span><strong>
<?php echo " Document " ?></strong>
</tr>
</tbody>
</table>
<br><br>
<div align="left">File yg akan di up load untuk pembuatan <strong>Surat Rekomendasi IDI Kota Bandung
</strong></div>
<p align="left">Foto copy :<br>
1. Surat permohonan SIP ditujukan ke DPMPTSP Kota Bandung<br>
2. Surat pernyataan mempunyai tempat praktik (bermaterai)<br>
3. Surat pernyataan dan persetujuan tidak keberatan dari pimpinan, tempat bekerja bagi PNS/TNI/POLRI/Badan Hukum<br>
4. Surat permohonan pengesahan Dokumen, ditujukan ke Dinas Kesehatan Kota Bandung<br>
5. STR (salinan)<br>
6. Scan KTP berwarna<br>
7. Ijazah dokter umum/spesialis<br>
8. Rekomendasi Profesi bagi dokter spesialis<br>
9. Scan NPWP berwarna<br>
10.Surat keterangan bekerja</p>
<p align="left">Documen yang asli :<br>
1. Surat pernyataan keabsahan dokumen (bermaterai)</p>
<p align="left">
</div>
</div>
<!--Script Javascript-->
<script src="https://code.jquery.com/jquery-1.12.4.js"></script>
<script src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/responsive/2.2.1/js/dataTables.responsive.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.colVis.min.js"></script>
<script>
$(document).ready(function() {
$('#example').DataTable( {
dom: 'Bfrtip',
buttons: [
'colvis'
]
} );
} );
</script>
<p> </p>
</body>
</html>