| Server IP : 2.57.91.136 / Your IP : 216.73.216.163 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/arsip/ |
Upload File : |
<?php
// menghubungkan dengan koneksi
include "koneksi.php";
// mengaktifkan session php
session_start();
if($_SESSION['status'] !="login"){
header("location:../");
}
?>
<?php
$view = isset($_GET['view']) ? $_GET['view'] : null;
switch($view){
default:
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="">
<meta name="author" content="">
<title>IDI Bandung</title>
<!-- Custom fonts for this template-->
<link rel="icon" href="idilogo.png">
<link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
<link href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">
<!-- Custom styles for this template-->
<link href="css/sb-admin-2.min.css" rel="stylesheet">
<!-- Custom styles for this page -->
<link href="vendor/datatables/dataTables.bootstrap4.min.css" rel="stylesheet">
<link href="table.css" rel="stylesheet">
<style>
#button-blue{
font-family: 'Montserrat', Arial, Helvetica, sans-serif;
float:center;
width: 50%;
font-size:18px;
}
#isi{
width: 100%;
height: 80px;
font-size:11px;
size:80;
}
#tgl{
width: 110%;
}
#ktk {
outline:none;
border: 0;
border:none;
width: 20px;
background-color: none;
background: none;
}
</style>
<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: 11px;
}
.prog-table th,
.prog-table td {
border-bottom: 1px solid #e1edff;
border-left: 1px solid #e1edff;
padding: 3px;
}
.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;
font-size: 10px;
text-align:center;
height:30px;
}
/* Table Body */
.prog-table tbody td {
color: #353535;
}
.style2 {
font-family: Arial, Helvetica, sans-serif;
font-size: 16px;
font-weight: bold;
}
.style4 {font-size: 12px}
.style5 {font-family: Arial, Helvetica, sans-serif}
.style6 {font-size: 12px; font-family: Arial, Helvetica, sans-serif; }
.rapih{
padding-top=0;
margin-top=0;
margin-top: 10px;
max-width:700px;
background: ;
height: auto;
overflow: hidden;
padding: 10px;
margin-left: 20px;
font-size: 11px;
}
.table th{
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
text-align:center;
}
/* untuk ukuran layar 700px kebawah */
@media screen and (max-width: 780px) {
#button-blue{
font-family: 'Montserrat', Arial, Helvetica, sans-serif;
float:left;
width: 100%;
font-size:18px;
}
}
</style>
</head>
<body id="page-top">
<!-- Page Wrapper -->
<div id="wrapper">
<?php include "sidebar005.php"; ?>
<!-- Content Wrapper -->
<div id="content-wrapper" class="d-flex flex-column">
<!-- Main Content -->
<div id="content">
<?php include "topbar.php";?>
<!-- Begin Page Content -->
<div class="container-fluid">
<!-- DataTales Example -->
<div class="card shadow mb-4">
<div class="card-header py-3">
<h6 class="m-0 font-weight-bold text-primary">List Post</h6>
</div>
<div class="card-body">
<div class="table-responsive">
<center><span class="style2">STATUS PEMOHON</span></center>
<br><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'];
$npm= $ds['npm'];
$nmlead= $ds['nmlead'];
$noreg= $ds['noreg'];
$ahli= $ds['ahli'];
$stat_ang= $ds['stat_ang'];
$iuran= $ds['iuran'];
$tgliuran= $ds['iuran'];
$date = new DateTime($tgliuran);
$iuran2= $date->format('d-m-Y');
$pengurus= $ds['pengurus'];
?>
<center>
Nama : <?php echo $ds['nmlead']; ?><br>
No registrasi : <?php echo $ds['noreg']; ?> <br>
<?php
if ($pengurus=='1'){
?>
Status : Pengurus IDI Cabang Bandung <br><br>
<?php
}
?>
<a href="dataanggota2.php?noreg=<?php echo $ds['noreg']; ?>&npm=<?php echo $_GET['npm']; ?>"> Chek Data Anggota</a><br>
</center>
</p>
</p>
<?php
$hari = date('Y-m-d');
$sqlSiswa = mysqli_query($konek, "SELECT * FROM h_anggota WHERE npm='$_GET[npm]'");
$da=mysqli_fetch_array($sqlSiswa);
$tgliur= $da['tgliuran'];
$tunggakan=$da['tunggakan'] ;
?>
<?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);
$iuran= $ds['iuran'];
$pinv= $ds['pinv'];
$adm= $ds['adm'];
$ahli2= $ds['ahli'];
$stat_ang= $ds['stat_ang'];
$tgliuran= $ds['iuran'];
$date = new DateTime($tgliuran);
$iuran2= $date->format('d-m-Y');
?>
</div>
<?php
IF($ds['adm'] == 'lunas'){
?>
<div class='alert alert-info'>
<span style='color:red'><i class='far fa-bell'></i> </span> Administrasi: <span style='color:red'> </span>
<span class='pull-right'> <span style='color:red'>pembayaran sudah Valid </span><i class='fa fa-angle-double-right'></i></span>
<span class='pull-right'><a href='bayar_validagt.php?npm=<?php echo $_GET['npm']; ?>&noreg=<?php echo $_GET['noreg']; ?>'> <span style='color:red'> <br> Cek Pemb Sudah valid:<br> </span> Click disini.. <i class='fas fa-angle-double-right'></i> </a></span>
</div>
<?php
}
else if ($ds['adm'] == 'bayar'){
}else if ($ds['adm'] == 'proses'){
}
?>
<?php
$hari = date('Y-m-d');
$sqlSiswa = mysqli_query($konek, "SELECT count(noreg) as jumlah FROM file WHERE file.npm='$_GET[npm]' AND file.noreg='$_GET[noreg]'");
$ds=mysqli_fetch_array($sqlSiswa);
$jumlah= $ds['jumlah'];
?>
<?php
// $sql=mysqli_query($konek,"SELECT * FROM peserta order by id desc limit 1");
// $data=mysqli_fetch_array($sql);
// //data hobi dari tabel siswa
// // $datahobi=explode(',', $data['dokumen']);
// $dokumen= $data['dokumen'];
//
//foreach ($dokumen as $key) {
// $total=count($dokumen);
//}
//echo $total;
//
//
//$mobil = array ("$dokumen");
//print_r ($mobil);
//$jml_mbl = count($mobil);
//echo '<br/>Jumlah : '.$jml_mbl;
$sql=mysqli_query($konek,"SELECT * FROM peserta where npm='$npm' AND noreg='$_GET[noreg]' order by id desc limit 1 ");
$data=mysqli_fetch_array($sql);
$dokumen = $data['dokumen'];
$hobi = explode(",", $data['dokumen']);
// $query=mysql_query("INSERT INTO siswa(nama, hobi) VALUES('$nama','$hobi')");
$jumlahup = count($hobi);
//echo $jumlahup;
?>
<?php
$vld = mysqli_query($konek, "select * from h_registrasi WHERE noreg='$_GET[noreg]' ");
$vd=mysqli_fetch_array($vld);
$verifikasi3= $vd['verifikasi3'];
$verifikasi2= $vd['verifikasi2'];
?>
<?php
if ($verifikasi2=='valid' || $verifikasi3=='valid'){
?>
<?php
}else{
?>
<?php if ( $jumlah<$jumlahup){
echo "
<div class='alert alert-primary'>
<span class='glyphicon glyphicon-bell'></span> Upload Pengajuan Rekomendasi $jumlahup Document : <span style='color:red'> Baru $jumlah buah,</span> Masih kurang,
<span class='pull-right'><a href='data_upl.php?npm=$_GET[npm]&noreg=$_GET[noreg]'> <span style='color:red'> Cek Upload Dokumen,Chek Click disini... </span> <i class='glyphicon glyphicon-download-alt'></i></a></span>
</div>";
}else{
echo "
<div class='alert alert-primary'>
<span class='glyphicon glyphicon-bell'></span> Document upload: <span style='color:red'> $jumlah buah,</span>
<span class='pull-right'><a href='data_upl.php?npm=$_GET[npm]&noreg=$_GET[noreg]'> <span style='color:red'> Cek Upload Dokumen,Chek Click disini... </span> <i class='glyphicon glyphicon-download-alt'></i></a></span>
</div>";
}
?>
<?php
}
?>
<?php
if ($verifikasi2=='valid' || $verifikasi3=='valid'){
?>
<?php
}else{
?>
<?php
$sqlSiswa = mysqli_query($konek, "select *, count(npm) as jumlah2 from d_praktek WHERE npm='$_GET[npm]' AND noreg='$_GET[noreg]'");
$dp=mysqli_fetch_array($sqlSiswa);
$jumlah2= $dp['jumlah2'];
echo "
<div class='alert alert-info'>
<span class='glyphicon glyphicon-bell'></span> Tempat Praktek Max 3 : <span style='color:red'> $jumlah2</span>
<span class='pull-right'><a href='data_prk.php?npm=$_GET[npm]&noreg=$_GET[noreg]&nmlead=$nmlead&ahli=$ahli'><span style='color:red'> Tempat </span> Cek disini <i class='fa fa-angle-double-right'></i></a></span>
</div>";
?>
<?php
}
?>
<div align="center"><span class="style2">Progress <br>Pengajuan Surat Rekomendasi IDI</span></center>
<br/><br/>
<h4> <?php echo $nmlead ?></h4>
<p><?php echo $npm ?><br>
<?php echo $noreg ?></p></center>
<br>
<?php
//menampilkan data Pra registrasi
$npm=$_GET['npm'];
$noreg=$_GET['noreg'];
$sql=mysqli_query($konek,"SELECT * FROM peserta where noreg='$noreg' order by id desc limit 1");
$data=mysqli_fetch_array($sql);
//data hobi dari tabel siswa
// $datahobi=explode(',', $data['dokumen']);
$rs = isset($data['rs']) ? $data['rs'] : null;
$klinik = isset($data['klinik']) ? $data['klinik'] : null;
$puskesmas = isset($data['puskesmas']) ? $data['puskesmas'] : null;
$pribadi = isset($data['pribadi']) ? $data['pribadi'] : null;
$kota = isset($data['kota']) ? $data['kota'] : null;
$npm = $data['npm'] ;
$perihal = $data['perihal'];
$anggota = $data['anggota'];
$ahli = $data['ahli'];
$status = $data['status'];
$instansi= $data['instansi'];
$jumlah= $data['jumlah'];
?>
<title> Form Persiapan Dokumen Rekomendasi </title>
<div class="rapih">
<div align="left">
<div class="card-body">
<div class="row">
<div class="col-md-6">
<div class="form-group ">
<strong>Status Keanggotaan IDI Bandung:</strong><br>
<input type="radio" name="anggota" value="anggota_IDI"<?php if($anggota=='anggota_IDI') echo 'checked'?> disabled> Anggota IDI Bandung <br>
<input type="radio" name="anggota" value="tamu_IDI"<?php if($anggota=='tamu_IDI') echo 'checked'?> disabled> Tamu IDI Bandung<br>
<br>
<strong>Status Kota :</strong><br>
<input type="checkbox" name="kota" value="bandung"<?php if ("bandung"==$kota) echo "checked";?> disabled> Bandung<br>
<input type="checkbox" name="kota" value="luar_kota"<?php if ("luar_kota"==$kota) echo "checked";?> disabled> Luar Kota Bandung<br>
<br>
<strong>Keahlian : </strong><br>
<input type="radio" name="ahli" value="dokter_umum"<?php if($ahli=='dokter_umum') echo 'checked'?> disabled> Dokter Umum <br>
<input type="radio" name="ahli" value="spesialis"<?php if($ahli=='spesialis') echo 'checked' ?> disabled> Dokter Spesialis<br>
<br>
<strong>Status Pengajuan :</strong><br>
<input type="radio" name="status" value="rekom_baru"<?php if($status=='rekom_baru') echo 'checked'?> disabled> Pengajuan Baru
<input type="radio" name="status" value="rekom_revisi"<?php if($status=='rekom_revisi') echo 'checked'?> disabled> Penambahan Praktek (Revisi)<br>
<br>
<strong>Pengajuan Jumlah Tempat Praktek : </strong><br>
<input type="radio" name="jumlah" value="1"<?php if($jumlah=='1') echo 'checked'?> disabled> 1 tempat Praktek Baru<br>
<input type="radio" name="jumlah" value="1"<?php if($jumlah=='2') echo 'checked'?> disabled> 2 tempat Praktek Baru<br>
<input type="radio" name="jumlah" value="1"<?php if($jumlah=='3') echo 'checked'?> disabled> 3 tempat Praktek Baru<br>
<br>
<br>
<strong>Jika Instansi PNS/TNI/POLRI/BUMN/Badan Hukum : </strong><br>
<input type="radio" name="instansi" value="1" <?php if($instansi=='1') echo 'checked'?> disabled> Non Instansi (Pribadi) <br>
<input type="radio" name="instansi" value="2"<?php if($instansi=='2') echo 'checked'?> disabled> Instansi<br>
<br>
</div>
</div>
<div class="col-md-6">
<strong>Jenis Pengajuan rekomendasi:</strong><br>
<input type="radio" name="perihal" value="rekomendasi_SIP_dr_umum"<?php if($perihal=='rekomendasi_SIP_dr_umum') echo 'checked'?> disabled> Rekomendasi SIP dr Umum <br>
<input type="radio" name="perihal" value="rekomendasi_SIP_dr_spesialis"<?php if($perihal=='rekomendasi_SIP_dr_spesialis') echo 'checked'?> disabled> Rekomendasi SIP dr Spesialis <br>
<input type="radio" name="perihal" value="rekomendasi_PPDS"<?php if($perihal=='rekomendasi_PPDS') echo 'checked'?> disabled> Rekomendasi Daftar PPDS <br>
<input type="radio" name="perihal" value="rekomendasi_SIP_PPDS_I"<?php if($perihal=='rekomendasi_SIP_PPDS_I') echo 'checked'?> disabled> Rekomendasi SIP PPDS I<br>
<input type="radio" name="perihal" value="rekomendasi_PPDS_II"<?php if($perihal=='rekomendasi_PPDS_II') echo 'checked'?> disabled> Rekomendasi Daftar PPDS II<br>
<input type="radio" name="perihal" value="rekomendasi_SIP_PPDS_II"<?php if($perihal=='rekomendasi_SIP_PPDS_II') echo 'checked'?> disabled> Rekomendasi SIP PPDS II <br>
<input type="radio" name="perihal" value="rekomendasi_fellowship"<?php if($perihal=='rekomendasi_fellowship') echo 'checked'?> disabled> Rekomendasi Fellowship<br>
<input type="radio" name="perihal" value="rekomendasi_COGS"<?php if($perihal=='rekomendasi_COGS') echo 'checked'?> disabled> Rekomendasi Certificate Of Good Standing<br>
<input type="radio" name="perihal" value="rekomendasi_UKDI"<?php if($perihal=='rekomendasi_UKDI') echo 'checked'?> disabled> Rekomendasi UKDI<br>
<input type="radio" name="perihal" value="rekomendasi_internsip"<?php if($perihal=='rekomendasi_internsip') echo 'checked'?> disabled> Rekomendasi Internsip<br>
<input type="radio" name="perihal" value="mutasi"<?php if($perihal=='mutasi') echo 'checked'?> disabled> Rekomendasi Mutasi <br>
<input type="radio" name="perihal" value="kehilangan"<?php if($perihal=='kehilangan') echo 'checked'?> disabled> Rekomendasi Kehilangan<br>
<input type="radio" name="perihal" value="p2kb"<?php if($perihal=='p2kb') echo 'checked'?> disabled> Rekomendasi P2KB<br>
<input type="radio" name="perihal" value="rekomendasi_Pengantar_SIP"<?php if($perihal=='rekomendasi_Pengantar_SIP') echo 'checked'?> disabled> Rekomendasi Pengantar Puskesmas<br>
<br>
<strong>Tempat Sarana Kesehatan :</strong><br>
<label><input type="checkbox" name="rs" value="rumah_sakit" <?php if ("rumah_sakit"==$rs) echo "checked";?> disabled> Rumah Sakit</label><br>
<input type="checkbox" name="klinik" value="klinik"<?php if ("klinik"==$klinik) echo "checked";?> disabled> Klinik</label><br>
<input type="checkbox" name="puskesmas" value="puskesmas"<?php if ("puskesmas"==$puskesmas) echo "checked";?> disabled> Puskesmas</label><br>
<input type="checkbox" name="pribadi" value="pribadi"<?php if ("pribadi"==$pribadi) echo "checked";?> disabled> Pribadi</label><br>
</div>
</div>
</div>
</div>
<div class="">
</div>
</div>
</div>
</div>
<div class="container">
<table class="prog-table" >
<thead>
<tr>
<th width="30px">Tahap</th>
<th>Note</th>
<th>Tgl cek</th>
<th>status</th>
<th>Tgl Revisi</th>
<th>Notif</th>
<th>Note dari Admin</th>
<th>Note Anggota</th>
<th>Validasi</th>
</tr>
</thead>
<?php
$npm = $_GET['npm'];
$sql = mysqli_query($konek, "SELECT * FROM d_progres WHERE npm='$npm' AND noreg='$_GET[noreg]' order by tahap ");
$no=1;
$total =0;
$hariini = date('Y-m-d');
while($d=mysqli_fetch_array($sql)){
$idtag=$d['id_tagihan'];
?>
<tr>
<form method="post" action="upd_sip2.php?view=update" enctype="multipart/form-data">
<?php
if($d['tahap'] == '1'){
?>
<td data-header='TAHAP' text-align='center' class="bg-gradient-danger" ><h2><?php echo $d['tahap']; ?></h2></td>
<?php
}
elseif ($d['tahap'] == '2'){
?>
<td data-header='TAHAP' text-align='center' class="bg-gradient-warning" ><h2><?php echo $d['tahap']; ?></h2></td>
<?php
}
elseif($d['tahap'] == '3'){
?>
<td data-header='TAHAP' text-align='center' class="bg-gradient-info"><h2><?php echo $d['tahap']; ?></h2></td>
<?php
}
elseif($d['tahap'] == '4'){
?>
<td data-header='TAHAP' text-align='center' class="bg-gradient-primary" ><h2><?php echo $d['tahap']; ?></h2></td>
<?php
}
elseif($d['tahap'] == '5'){
?>
<td data-header='TAHAP' text-align='center' class="bg-gradient-success" ><h2><?php echo $d['tahap']; ?></h2></td>
<?php
}
?>
<td data-header='Tgl Registrasi'><?php echo $d['note']; ?></td>
<td>
<?php
if($d['tgl_cek'] == '0000-00-00'){
?>
<?php echo '-' ?>
<?php
}else{
?>
<?php echo $d['tgl_cek']; ?>
<?php
}
?>
<input type="hidden" name="tglcek" value="<?php echo $hariini ?>"> </td>
<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
}
?>
<input type='hidden' type="" name="id" value="<?php echo $d['id_tagihan']; ?>" readonly>
<input type='hidden' type="" name="noreg" value="<?php echo $d['noreg']; ?>" readonly>
<input type='hidden' type="" name="npm" value="<?php echo $d['npm']; ?>" readonly>
</td>
<?php if($adm== 'bayar'){
$note4 = ' ADM Sudah Bayar,validasi!';
$note41 = ' <span style=color:red>ADM Sudah Bayar,validasi!</span>';
}
else if ($adm== 'proses'){
$note4 = ' Menunggu Pembayaran.';
$note41 = ' <span style=color:red>Menunggu Pembayaran.</span>';
}
else if ($adm== 'lunas'){
$note4 = ' ADM Lunas, Valid.';
}
?>
<?php if ( $jumlah<$jumlahup){
$note3 = ' Dokumen belum lengkap.';
$note31 = '<span style=color:red> Dokumen belum lengkap.</span>';
}
else{
$note3 = '';
}
?>
<td>
<br>
<br>
<?php if($adm== 'bayar'){
$note41 = ' <span style=color:red>ADM Sudah Bayar,validasi!</span>';
$chek = 'checked';
echo '<input type="checkbox" name="hobi[]" value="'.$adm.'"'.$chek.'>'.$note41;
}
else if ($adm== 'proses'){
$note4 = ' Menunggu Pembayaran.';
$note41 = ' <span style=color:red>Menunggu Pembayaran adm.</span>';
$chek = 'checked';
echo '<input type="checkbox" name="hobi[]" value="'.$adm.'"'.$chek.'>'.$note41;
}
else if ($adm== 'lunas'){
$note41 = ' Adm Lunas, Valid.';
$chek = 'checked';
echo '<input type="checkbox" name="hobi[]" value="'.$adm.'"'.$chek.'>'.$note41;
}
?>
<br>
<?php
if ($jumlah< $jumlahup){
$chek = 'checked';
echo '<input type="checkbox" name="hobi[]" value="'.$jumlah.'"'.$chek.'>' .$jumlah .$note31;
}else{
$chek = 'checked';
$note32 = ' Dokumen, Cek';
echo '<input type="checkbox" name="hobi[]" value="'.$jumlah.'"'.$chek.'>' .$jumlah .$note32;
}
?>
<br>
<?php
if ( $jumlah2<3) $chek = 'checked'; else $chek = 'checked';
$note41 = ' Tempat Praktek, Max 3.';
echo '<input type="checkbox" name="hobi[]" value="'.$jumlah2.'"'.$chek.'>' .$jumlah2. $note41;
?>
</td>
<td data-header='Progress'><span class='merah'>
<textarea name="note" id="note" px="px" cols="15" rows="4"><?php echo $d['keterangan']; ?></textarea> </span></td>
<td data-header='Keterangan'><textarea cols="25" rows="4" id="note2" px="px" readonly><?php echo $d['note2']; ?> </textarea></td>
<?php
if ($d['tahap']> 1){
?>
<?php
}
?>
</tr>
<?php $no++; ?>
<?php
}
?>
<br>
<div><caption class="title"> <span class="merah"> Warna Tahap : </span>Warna Merah Verifikasi Data, Kuning Data Sudah Lengkap, Hijau Muda Menunggu SK, Biru Selesai </caption></div>
</table>
</FORM>
</div> </div>
</br>
<center>
<br> <br> <br> <br>
<h4 align="center">Tabel Data Tempat Praktek Dokter</h4></center>
<br>
</table>
<table class="demo-table responsive">
<thead>
<tr>
<th scope="col">Praktik ke :</th>
<th scope="col"> Dokter</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>
<th>pengajuan</th>
<th>urutan</th>
<th>Action</th>
<th>Hapus</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 * from d_praktek WHERE noreg='$_GET[noreg]' order by d_praktek.id,urutan");
//$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)){
?>
<form method="post" action="data_sip2.php?view=update" enctype="multipart/form-data">
<tr>
<td data-header='No'><?php echo $no; ?>
<input type='hidden' type="" name="noreg" value="<?php echo $du['noreg']; ?>" readonly>
<input type='hidden' type="" name="npm" value="<?php echo $du['npm']; ?>" readonly>
</td>
<td data-header='Dokter'><?php echo $du['nmlead']; ?></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='jam Praktek' ><?php echo $du['jam1']; ?></td>
<td data-header='Status' ><span class='merah'><?php echo $du['status']; ?> </span></td>
<td data-header='pengajuan' ><?php echo $du['pengajuan']; ?></td>
<td data-header='urutan' ><?php echo $du['urutan']; ?></td>
</span>
</td>
</tr>
<?php $no++;
}
?>
</table>
</form>
</p>
<br>
<h4 align="center">Tabel Input Dokumen </h4></center>
<br>
<table id="example" class="demo-table responsive" style="width:90%">
<thead>
<tr>
<th>No</th>
<th>Nama Surat</th>
<th>Dokumen</th>
<th>Validasi1</th>
<th>Validasi2</th>
<th>Notif1 Admin</th>
<th>Notif2 Sekr</th>
<th>Note</th>
</tr>
</thead>
<tbody class="alert-success">
<?php
//require 'config.php';
$row = $konek->query("SELECT *,count( file_id) as jumlah FROM file WHERE noreg='$_GET[noreg]' group by file_id ") or die(mysqli_error());
$no = 1;
$total2=0;
while($fetch = $row->fetch_array()){
$file=$fetch['file'];
$potong_kalimat = substr($fetch['file'],-4);
?>
<tr>
<?php
$name = explode('/', $fetch['file']);
?>
<td><?php echo $no ?></td>
<td><?php echo $fetch['nmsurat']?></td>
<td><a href="<?php echo $fetch['file']; ?>" title="Foto Bukti!" class="MagicZoom" rel="zoom-id:zoom;opacity-reverse:true; ">
<?php
if ($potong_kalimat==".pdf"){
?>
<div class="video-container"><embed type="application/pdf" src="<?php echo $fetch['file']; ?>" width="150" height="150"></embed></div>
<?php
}else{
?>
<img src="<?php echo $fetch['file']; ?>" style="width:25%;"/>
<?php
}
?>
<br><br>
<?php echo $fetch['nmfile']; ?>
</p>
<a href="download22.php?file=<?php echo $file ?>" class="btn btn-primary"><span class="glyphicon glyphicon-download"></span> Download</a></td>
<td><span class='merah'><?php echo $fetch['status']?></span></td>
<td><?php echo $fetch['status2']?></td>
<form name="form" enctype="multipart/form-data" action="adm_note.php" method="POST">
<input name="back" type = "hidden" readonly class="form-control" value="1" />
<input name="id" type = "hidden" readonly class="form-control" value="<?php echo $fetch['file_id'] ?>" />
<input name="npm" type = "hidden" readonly class="form-control" value="<?php echo $_GET['npm'] ?>" />
<input name="noreg" type = "hidden" readonly class="form-control" value="<?php echo $_GET['noreg'] ?>" />
<td><textarea cols="10" rows="4" name="note1" readonly ><?php echo $fetch['note1']; ?> </textarea></td>
<td> <textarea cols="10" rows="4" name="note2" readonly ><?php echo $fetch['note2']; ?> </textarea></td>
<td data-header='Reminder' class='merah' background-color='#ffcccc' >
<?php
// IF($fetch['status'] == 'proses'){
?>
</form>
</td>
</span>
</td>
</tr>
<?php
$no++;
}
?>
</tr>
</tbody>
</table>
<br> <br>
</center>
<br> <br>
<?php
$npm=$_GET['npm'];
?>
<hr>
<center>
<a href='cetak_rekom.php?npm=<?php echo $_GET['npm']; ?>&noreg=<?php echo $_GET['noreg']; ?>' type="button" id="button-blue" class="btn btn-warning"> Cek Surat Rekomendasi </button></a>
<br><br>
<a href="d_table.php?npm=<?php echo $_GET['npm']; ?>&noreg=<?php echo $_GET['noreg']; ?>" class="btn btn-success " id="button-blue"><span class="glyphicon glyphicon-trash"></span> Cek dokumen</a>
<br><br>
<a href="../surat/cetak_kwitansi.php?npm=<?php echo $_GET['npm']; ?>&noreg=<?php echo $_GET['noreg']; ?>" class="btn btn-primary"><span class="glyphicon glyphicon-trash"></span> Cek Kwitansi</a></td>
</center>
<br>
<table class="table table-bordered" id="dataTable" width="80%" cellspacing="0">
<thead>
<tr>
<th>No</th>
<th>No Rekomendasi</th>
<th>Pengajuan</th>
<th>kota</th>
<th>Verifikasi 1 (Sekretariat)</th>
<th>Verifikasi 2 (Sekertaris)</th>
<th>Verifikasi 3 (Ketua)</th>
<th>Note Surat</th>
</tr>
</thead>
<tbody >
<?php
//require 'config.php';
// $row = $konek->query("SELECT * FROM h_registrasi where noreg='$noreg' AND status2='valid' order by nmlead") or die(mysqli_error());
$row = $konek->query("SELECT * FROM h_registrasi where noreg='$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['tgliuran'];
$date = new DateTime($tgliuran);
$iuran= $date->format('d-m-Y');
$iuran2= $fetch['iuran'];
$date = new DateTime($iuran2);
$iuran2= $date->format('d-m-Y');
?>
<tr>
<td><?php echo $no ?></td>
<td><?php echo $fetch['noreko']?></td>
<td><?php echo $fetch['perihal']?></td>
<td><?php echo $fetch['kota']?></td>
<td><?php echo $fetch['verifikasi1']?></td>
<td><?php echo $fetch['verifikasi2']?></td>
<td><?php echo $fetch['verifikasi3']?></td>
<td data-header='Note Surat' align='left'><?php echo $fetch['note4']; ?></td>
<td data-header='Status' align='center' > </td>
</tr>
<?php
$no++;
}
?>
</tbody>
</table>
</br>
<br>
<br>
<!-- proses edit data -->
<?php
if($_SERVER['REQUEST_METHOD']=='POST'){
include "koneksi.php";
//variabel untuk menampung inputan dari form
//$id = $_POST['id'];
$npm = $_GET['npm'];
$noreg = $_GET['noreg'];
//$nmlead = $_POST['nmlead'];
$tahap = $_POST['tahap'];
$note = $_POST['note'];
$keterangan = $_POST['ket'];
$status2 = $_POST['status2'];
$tglcek = $_POST['tglcek'];
//$tglreg = $_POST['tglreg'];
//$alamat = $_POST['alamat'];
// $nostr = $_POST['nostr'];
// $mbstr = $_POST['mbstr'];
// $ahli = $_POST['ahli'];
// $tgliuran = $_POST['tgliuran'];
// simpan inputan user ke variabel
// $userInput = array('ket' => $data);
//mysqli_query($konek, "INSERT INTO d_progres(npm,noreg,tgl_reg,tgl_cek,nmlead,tahap,dokumen,status2,keterangan,iuran,alamat,nostr,mbstr,ahli)
// values('$npm','$noreg','$tglreg','$tglcek','$nmlead','$tahap','$dokumen','$status2','$keterangan','$tgliuran','$alamat','$nostr','$mbstr','$ahli')
// ");
mysqli_query($konek, "INSERT INTO d_progres(npm,noreg,tahap,status2,keterangan,status,tgl_cek,note)
values('$npm','$noreg','$tahap','$status2','$keterangan','proses','$tglcek','$note')
");
$update = mysqli_query($konek, "UPDATE h_registrasi SET tahap='$tahap',status2='$status2',tgl_cek='$tglcek' WHERE noreg='$noreg'");
//$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:upd_sip2.php?noreg=$noreg&npm=$npm");
header("location:mail_notif.php?noreg=$noreg&npm=$npm");
//echo "$id";
}
?>
<!-- <center><a class="btn btn-danger" href="./validasi-ijazah">Kembali</a></center> -->
</div>
</div>
</div>
</div>
<?php
break;
case "update":
?>
<?php
if($_SERVER['REQUEST_METHOD']=='POST'){
//variabel untuk menampung inputan dari form
include "koneksi.php";
$id = $_POST['id'];
$npm = $_POST['npm'];
$noreg = $_POST['noreg'];
//$nmlead = $_POST['nmlead'];
//$tahap = $_POST['tahap']+1;
//$dokumen = $_POST['doc'];
$ket = $_POST['note'];
$status2= $_POST['status2'];
$tglcek = $_POST['tglcek'];
//$tgl_reg = $_POST['tgl_reg'];
//$hobi = $_POST['hobi'];
$hobi = implode(",", $_POST['hobi']);
$update = mysqli_query($konek, "UPDATE d_progres SET data='chek',status='chek',status2='$status2',keterangan='$ket',tgl_cek='$tglcek',notifi='$hobi' WHERE id_tagihan='$id'");
//$update = mysqli_query($konek, "UPDATE d_progres SET data='chek' WHERE id_tagihan='136'");
$update = mysqli_query($konek, "UPDATE h_registrasi SET data='chek',status2='$status2',keterangan='$ket',tgl_cek='$tglcek' WHERE noreg= '$noreg'");
$update = mysqli_query($konek, "UPDATE d_praktek SET status2='$status2' WHERE noreg= '$noreg'");
// header("location:upd_sip2.php?noreg=$noreg&npm=$npm");
header("location:mail_notif.php?noreg=$noreg&npm=$npm");
//echo "$id";
}
?>
</div>
<?php
break;
}
?>
<!-- Bootstrap core JavaScript-->
<script src="vendor/jquery/jquery.min.js"></script>
<script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- Core plugin JavaScript-->
<script src="vendor/jquery-easing/jquery.easing.min.js"></script>
<!-- Custom scripts for all pages-->
<script src="js/sb-admin-2.min.js"></script>
<!-- Page level plugins -->
<script src="vendor/datatables/jquery.dataTables.min.js"></script>
<script src="vendor/datatables/dataTables.bootstrap4.min.js"></script>
<!-- Page level custom scripts -->
<script src="js/demo/datatables-demo.js"></script>
</body>
</html>