| Server IP : 91.108.119.24 / Your IP : 216.73.217.80 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
// 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:left;
width: 100%;
border: #fbfbfb solid 4px;
cursor:pointer;
background-color: #3498db;
color:white;
font-size:12px;
padding:5px;
margin-top:-4px;
height:50px;
}
#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: 12px;
}
</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>
<center><a href='dashboard005.php' class="btn btn-info btn-sm"><span class="glyphicon glyphicon-home"> </span> Home</a></center>
<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'];
$ahli= $ds['ahli'];
$noreg= $ds['noreg'];
?>
<center>
Nama : <?php echo $ds['nmlead']; ?><br>
No registrasi : <?php echo $ds['noreg']; ?> <br>
<a href="dataanggota.php?noreg=<?php echo $ds['noreg']; ?>&npm=<?php echo $_GET['npm']; ?>"> Chek Data Anggota</a><br>
</center>
</p>
</p>
<?php if ( $mbstr<$hari){
echo "
<div class='alert alert-warning'>
<span style='color:red'> <span class='glyphicon glyphicon-bell'></span> Masa berlaku STR : <span style='color:red'> $mbstr</span> STR 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>";
}
?>
<?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'];
$stat_ang= $ds['stat_ang'];
?>
<?php if ( $iuran<$hari){
?>
<?php
IF($ds['pinv'] == 'lunas'){
echo "
<div class='alert alert-warning'>
<span style='color:red'><span class='glyphicon glyphicon-bell'></span> Iuran 5 Tahun : Pembayaran Sudah Lunas dan <span style='color:red'></span>
<span class='pull-right'><a href='#d_new.php'> <span style='color:red'>Valid </span><i class='fa fa-angle-double-right'></i></a></span>
</div>";
?>
<?php
}
else if ($ds['pinv'] == 'bayar'){
echo "
<div class='alert alert-warning'>
<span style='color:red'><span class='glyphicon glyphicon-bell'></span> Iuran 5 Tahun : Sudah melakukan pembayaran, <span style='color:red'></span>
<span class='pull-right'><a href='invoice2.php?noreg=$_GET[noreg]'><span style='color:red'>Silahkan Validasi! </span><i class='fa fa-angle-double-right'></i></a></span>
</div>";
}
else if ($ds['pinv'] == 'tagihan'){
echo "
<div class='alert alert-warning'>
<span style='color:red'><span class='glyphicon glyphicon-bell'></span> Invoice sudah dikirim <span style='color:red'></span>
<span class='pull-right'><span style='color:red'>Tunggu Pembayaran </span><i class='fa fa-angle-double-right'></i></span>
</div>";
}
else if ($ds['pinv'] == 'expired'){
echo "
<div class='alert alert-warning'>
<span style='color:red'><span class='glyphicon glyphicon-bell'></span> Masa berlaku Iuran 5tahun : <span style='color:red'> $iuran <?php echo $iuran; ?></span> Sudah Expired !!
<span class='pull-right'><a href='b_inv.php?noreg=$_GET[noreg]&npm=$_GET[npm]'> <span style='color:red'>Buat Invoice </span><i class='fa fa-angle-double-right'></i></a></span>";
?>
<?php
}
else{
echo "-";
}
?>
</div>
<?php
}
?>
<?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>
</div>
<?php
}else if ($ds['adm'] == 'bayar'){
echo "
<div class='alert alert-info'>
<i class='far fa-bell'></i> </span>Administrasi: Sudah melakukan Pembayaran, <span style='color:red'> </span>
<span class='pull-right'> <a href='invoiceadm.php?noreg=$_GET[noreg]'><span style='color:red'>Validasi! </span><i class='fa fa-angle-double-right'></i></a></span>
<span class='pull-right'><a href='bukti_admnon.php?npm=$npm&noreg=$_GET[noreg]&view=2'> <span style='color:red'> <br> Bantu Upload bukti transfer:<br> </span> Upload bukti transfer.. <i class='fas fa-angle-double-right'></i> </a></span>
<br>
<span class='pull-right'><a href='cancel_bayar.php?npm=$npm&noreg=$_GET[noreg]&stat_ang=$stat_ang&view=2'> <span style='color:red'> <br> Jika Nominal tdk sesuai cancel Bayar dan Bantu bantar ( masa berlaku NOSTR sudah di edit untuk non Anggota):<br>
</span> Cancel bayar.. <i class='fas fa-angle-double-right'></i> </a></span>
</div>";
}else if ($ds['adm'] == 'proses'){
echo "
<div class='alert alert-info'>
<i class='far fa-bell'></i> </span>Administrasi: User Belum melakukan Pembayaran, <span style='color:red'> </span>
<span class='pull-right'> <span style='color:red'>Tunggu pembayaran! </span></span>
<span class='pull-right'><a href='tagihanadmnon.php?npm=$npm&noreg=$_GET[noreg]&view=2'> <span style='color:red'> <br> Bantu Bayar:<br> </span> Bayar dan Upload bukti transfer.. <i class='fas fa-angle-double-right'></i> </a></span>
<br>
<span class='pull-right'><a href='nonang_bantu.php?npm=$npm&noreg=$_GET[noreg]&stat_ang=$stat_ang&view=2'> <span style='color:red'> <br> Untuk Non Anggota yg tidak muncul bayar:<br>
</span> Bantu nonang Bayar.. <i class='fas fa-angle-double-right'></i> </a></span>
</div>";
}
?>
<?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 if ( $jumlah<30){
echo "
<div class='alert alert-primary'>
<span class='glyphicon glyphicon-bell'></span> Upload Dokumen : <span style='color:red'> $jumlah buah,</span> Masih kurang,
<span class='pull-right'><a href='data_upl.php?npm=$_GET[npm]&noreg=$_GET[noreg]'> <span style='color:red'> Chek Dokumen Click disini... </span> <i class='glyphicon glyphicon-download-alt'></i></a></span>
</div>";
}
?>
<?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'];
?>
<?php if ( $jumlah2<3){
echo "
<div class='alert alert-info'>
<span class='glyphicon glyphicon-bell'></span> Tempat Praktek Max 3 : Sudah Input <span style='color:red'> $jumlah2</span>
<span class='pull-right'> Tempat, <i class='fa fa-angle-double-right'></i>
<a href='data_prk.php?npm=$_GET[npm]&noreg=$_GET[noreg]'> <span style='color:red'> Chek Click disini... </span> <i class='glyphicon glyphicon-download-alt'></i></a>
</span>
</div>";
}
?>
<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'];
$sql=mysqli_query($konek,"SELECT * FROM peserta where npm='$npm' 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'];
?>
<div class="container">
<title> Form Persiapan Dokumen Rekomendasi </title>
<div class="rapih">
<div align="left">
<strong>Status Keanggotaan IDI Bandung:</strong><br>
<input type="radio" name="anggota" value="internsip"<?php if($anggota=='internsip') echo 'checked'?> disabled> internsip <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="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 |
<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>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 |
<input type="radio" name="perihal" value="rekomendasi_SIP_dr_spesialis"<?php if($perihal=='rekomendasi_SIP_dr_spesialis') echo 'checked'?> disabled> Rekomendasi SIP dr Spesialis |
<input type="radio" name="perihal" value="rekomendasi_PPDS"<?php if($perihal=='rekomendasi_PPDS') echo 'checked'?> disabled> Rekomendasi PPDS | <br>
<input type="radio" name="perihal" value="rekomendasi_SIP_PPDS"<?php if($perihal=='rekomendasi_SIP_PPDS') echo 'checked'?> disabled> Rekomendasi SIP PPDS |
<input type="radio" name="perihal" value="rekomendasi_SIP_PPDS_II"<?php if($perihal=='rekomendasi_SIP_PPDS_II') echo 'checked'?> disabled> Rekomendasi SIP PPDS II |
<input type="radio" name="perihal" value="rekomendasi_internsip"<?php if($perihal=='rekomendasi_internsip') echo 'checked'?> disabled> Rekomendasi Internsip<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>
<table class="prog-table responsive" >
<thead>
<tr>
<th width="30px">Tahap</th>
<th>Note</th>
<th>Tgl cek</th>
<th>status</th>
<th>Tgl Revisi</th>
<th>Notif1</th>
<th>Notif</th>
<th>Note dari Admin</th>
<th>Validasi</th>
<th>Action</th>
<th>hapus</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 ( $mbstr<$hari){
$note1 = ' MBSTR Expired.';
$note11 = ' <span style=color:red>MBSTR Expired.</span>';
}
else{
$note1 = ' MBSTR Valid.';
}
?>
<?php if($pinv== 'bayar'){
$note2 = ' Iuran Sudah Bayar,validasi!';
$note21 = ' <span style=color:red>Iuran Sudah Bayar,validasi!</span>';
}
else if ($pinv== 'tagihan'){
$note2 = ' Menunggu Pembayaran.';
$note21 = ' <span style=color:red>Menunggu Pembayaran.</span>';
}
else if ($pinv== 'expired'){
$note2 = ' Iuran Expired buat Invoice.';
$note21 = ' <span style=color:red>Iuran Expired buat Invoice.</span>';
}
else if ($pinv== 'lunas'){
$note2 = ' Iuran Lunas, Valid.';
}
?>
<?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<10){
$note3 = ' Kurang dari 10 Dokumen.';
$note31 = '<span style=color:red> Kurang dari 10 Dokumen.</span>';
}
else{
$note3 = '';
}
?>
<td>
<?php
if ($mbstr<$hari){
$chek = 'checked';
echo '<input type="checkbox" name="hobi[]" value="'.$mbstr.'"'.$chek.'>'.$note1;
}else{
$chek = 'checked';
echo '<input type="checkbox" name="hobi[]" value="'.$mbstr.'"'.$chek.'>'.$note1;
}
?>
<br>
<?php if($pinv== 'bayar'){
$note21 = ' <span style=color:red>Iuran Sudah Bayar,validasi!</span>';
$chek = 'checked';
echo '<input type="checkbox" name="hobi[]" value="'.$iuran.'"'.$chek.'>'.$note21;
}
else if ($pinv== 'tagihan'){
$note2 = ' Menunggu Pembayaran.';
$note21 = ' <span style=color:red>Menunggu Pembayaran.</span>';
$chek = 'checked';
echo '<input type="checkbox" name="hobi[]" value="'.$iuran.'"'.$chek.'>'.$note21;
}
else if ($pinv== 'expired'){
$note21 = ' <span style=color:red>Iuran Expired buat Invoice.</span>';
$chek = 'checked';
echo '<input type="checkbox" name="hobi[]" value="'.$iuran.'"'.$chek.'>'.$note21;
}
else if ($pinv== 'lunas'){
$note21 = ' Iuran Lunas, Valid.';
$chek = 'checked';
echo '<input type="checkbox" name="hobi[]" value="'.$iuran.'"'.$chek.'>'.$note21;
}
?>
<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< 10){
$chek = 'checked';
echo '<input type="checkbox" name="hobi[]" value="'.$jumlah.'"'.$chek.'>' .$jumlah .$note31;
}else{
$chek = 'checked';
$note32 = ' lebih dari 10 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'>
<textarea name="notif" id="note" px="px" cols="15" rows="4"><?php echo $note1,$note2,$note3 ?></textarea> </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='Status'> <select name="status2">
<?php
$sqlKelas = mysqli_query($konek, "select * from d_progres WHERE npm='$npm' AND noreg='$_GET[noreg]' AND id_tagihan ='$idtag' order by status2 ASC");
while($k=mysqli_fetch_array($sqlKelas)){
if($k['status2'] == $e['status2']){
$selected = "selected";
}else{
$selected ="";
}
?>
<option value="<?php echo $k['status2']; ?>" <?php echo $selected; ?>><?php echo $k['status2']; ?></option>
<option value="proses">Proses</option>
<option value="revisi">Revisi</option>
<option value="valid">Valid</option>
<option value="finish">Finish</option>
<?php
}
?>
</select></td>
<td> <input type="SUBMIT" name="SUBMIT" id="button-blue" value="Update Data" > </td>
<?php
if ($d['tahap']> 1){
?>
<td><a class='btn btn-danger btn-sm' href='del_pro.php?id=<?php echo $d['id_tagihan']; ?>'>Hapus</a> </td>
<?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>
</br>
<center>
<span class="style4"><span class="style5">
<a class='btn btn-success btn-sm' href='edit_prk.php?npm=<?php echo $_GET['npm']; ?>&noreg=<?php echo $_GET['noreg']; ?>&ahli=<?php echo $ahli ?>&nmlead=<?php echo $nmlead ?>'>Edit Praktek Kerja</a>
<a class='btn btn-danger btn-sm' href='data_upl.php?npm=<?php echo $_GET['npm']; ?>&noreg=<?php echo $_GET['noreg']; ?>'>Cek Upload Data</a> </span></span>
</center>
<span class="style6"><br>
</span>
<center class="style6"> <a class='btn btn-info btn-sm' href='data_rev.php?npm=<?php echo $_GET['npm']; ?>&noreg=<?php echo $_GET['noreg']; ?>'>Edit Data Anggota</a>
<a class='btn btn-warning btn-sm' href='data_sip2.php?npm=<?php echo $_GET['npm']; ?>&noreg=<?php echo $_GET['noreg']; ?>'>Cek All Data</a></center>
<br> <br>
<?php
$npm=$_GET['npm'];
?>
<hr>
<div align="center"><span class="style2">Update Pengajuan Surat</span></center><br>
<br><br>
<table class="prog-table responsive">
<thead>
<tr>
<th scope="col">Tahap</th>
<th scope="col">Note</th>
<th scope="col">No Reg</th>
<th scope="col">Tanggal Reg</th>
<th scope="col">Tanggal cek</th>
<th scope="col">Note Admin</th>
<th scope="col">Status</th>
<th scope="col">Action</th>
</tr>
<thead>
<?php
$npm=$_GET['npm'];
$tglinput = date('Y-m-d');
$tgl = mysqli_query($konek, "select * from d_progres WHERE npm='$_GET[npm]' AND noreg='$_GET[noreg]' order by tahap desc limit 1");
$dtgl=mysqli_fetch_array($tgl);
// $booking =new DateTime('2020-06-01');
// $today =new DateTime();
// $diff = $today->diff($booking);
// echo $diff->d; echo " Hari";
?>
<?php
date_default_timezone_set('Asia/Jakarta');
// $sql=mysqli_query($konek, "SELECT * FROM mahasiswa WHERE npm='$_GET[noijazah]'");
$sql = mysqli_query($konek, "select *, count(tahap) + 1 as tahapke from d_progres WHERE npm='$_GET[npm]' AND noreg='$_GET[noreg]' order by tahap desc limit 1");
while($d=mysqli_fetch_array($sql)){
?>
<tr>
<form name="form1" method="post" action="add_progres.php">
<?php
if($d['tahapke'] == '1'){
?>
<td bgcolor='#FF4F4F' ><input id="ktk" type="" name="tahap" value="<?php echo $d['tahapke']; ?>" readonly></td>
<?php
}
elseif ($d['tahapke'] == '2'){
?>
<td bgcolor='#FFDE5B' ><input id="ktk" type="" name="tahap" value="<?php echo $d['tahapke']; ?>" readonly></td>
<?php
}
elseif($d['tahapke'] == '3'){
?>
<td bgcolor='#44FFFF' ><input id="ktk" type="" name="tahap" value="<?php echo $d['tahapke']; ?>" readonly></td>
<?php
}
elseif($d['tahapke'] == '4'){
?>
<td bgcolor='#99FF66' ><input id="ktk" type="text" name="tahap" value="<?php echo $d['tahapke']; ?>" readonly></td>
<?php
}
elseif($d['tahapke'] == '5'){
?>
<td bgcolor='#22FFFF' ><input id="ktk" type="" name="tahap" value="<?php echo $d['tahapke']; ?>" readonly></td>
<?php
}
elseif($d['tahapke'] == '6'){
?>
<td bgcolor='#22FFFF' ><input class="form-control" type="" name="tahap" value="<?php echo $d['tahapke']; ?>" readonly></td>
<?php
}
?>
<?php
if($d['tahapke'] == '1'){
?>
<td data-header='note'><textarea name="note" rows="4" disabled readonly type=""><?php echo "Proses Registrasi dan Cek kelengkapan Data"; ?></textarea></td>
<?php
}
elseif ($d['tahapke'] == '2'){
?>
<td data-header='note'><textarea name="note" rows="4" readonly type=""><?php echo "Data Sudah Lengkap proses verivikasi Data"; ?></textarea></td>
<?php
}
elseif($d['tahapke'] == '3'){
?>
<td data-header='note'><textarea rows="4" type="" name="note" readonly><?php echo "Data sudah Di verivikasi Proses Menunggu SK"; ?></textarea></td>
<?php
}
elseif($d['tahapke'] == '4'){
?>
<td data-header='note'><textarea rows="4" type="" name="note" readonly><?php echo "Finish"; ?></textarea></td>
<?php
}
elseif($d['tahapke'] == '5'){
?>
<td data-header='note'><textarea rows="4" type="" name="note" readonly><?php echo "Silahkan Download Data"; ?></textarea></td>
<?php
}
elseif($d['tahapke'] == '6'){
?>
<td data-header='note'><textarea rows="4" type="" name="note" readonly><?php echo "Catatan"; ?></textarea></td>
<?php
}
?>
<td data-header='noreg'><input class="form-control" type="" name="noreg" value="<?php echo $d['noreg']; ?>" readonly></td>
<td data-header='Tgl registrasi'><input name="tglreg" class="form-control" type="text" value="<?php echo $d['tgl_reg']; ?>" size="11"></td>
<td data-header='Tgl cek'> <input name="tglcek" class="form-control" type="text" id="datepicker2" value="<?php echo $tglinput ?>" size="11"></td>
<td data-header='Keterangan'><textarea cols="25" rows="4" name="ket" id="note" px="px"> </textarea></td>
<td data-header='Status 2'><label>
<select name='status2'>
<option value="proses">Proses</option>
<option value="valid">Valid</option>
<option value="finish">Finish</option>
</select>
</label></td>
<input name="npm" type="hidden" value="<?php echo $d['npm']; ?>" maxlength="30" />
<input name="alamat" type="hidden" value="<?php echo $d['alamat']; ?>" maxlength="30" />
<input name="nostr" type="hidden" value="<?php echo $d['nostr']; ?>" maxlength="30"/>
<input name="mbstr" type="hidden" value="<?php echo $d['mbstr']; ?>" size="11">
<input name="ahli" type="hidden" value="<?php echo $d['ahli']; ?>" maxlength="30" />
<input name="tgliuran" type="hidden" value="<?php echo $d['iuran']; ?>" size="11">
<td> <input type="SUBMIT" name="SUBMIT" id="button-blue" value="Tambah progres" ></td>
</form>
</tr>
<?php
}
?>
</table>
<hr>
<div align="center">
<center><h4> verifikasi Surat Rekomendasi (Verifikasi 1) </h4><center>
Pastikan Status Sudah Valid, (data Praktek dan documen sudah di validasi) <br> sebelum membuat Surat rekomendasi
<br><br>
<a href='s_reko.php?npm=<?php echo $_GET['npm']; ?>&noreg=<?php echo $_GET['noreg']; ?>' type="button" class="btn btn-primary">Buat Surat Rekomendasi</button></a>
<a href='cetak_rekom.php?npm=<?php echo $_GET['npm']; ?>&noreg=<?php echo $_GET['noreg']; ?>' type="button" class="btn btn-warning"> Cek Surat Rekomendasi </button></a>
<br><br>
<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>perihal</th>
<th>kota</th>
<th>Verifikasi 1 (Sekretariat)</th>
<th>Verifikasi 2 (Sekertaris)</th>
<th>Verifikasi 3 (Ketua)</th>
<th>Cek 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());
$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['level']?></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='Status' align='center' >
<?php
IF($fetch['status2'] == 'valid'){
?>
<a class='btn btn-danger btn-sm' href='valids1.php?noreg=<?php echo $fetch['noreg']; ?>&npm=<?php echo $fetch['npm']; ?>&id=<?php echo $fetch['id_tagihan']; ?>'>Validasi 1</a>
<?php
}else{
echo "-";
}
?>
</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");
//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");
//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>