PHP Dosya Yöneticisi

<?php

if (isset($_GET['temizle'])) {
	
$id = temizle($_GET['temizle']);
$sayfasil = $ozy->prepare("delete from siparis where id='$id'");
$sayfasil->execute(array($id));

if ($sayfasil) {
	
echo '<script type="text/javascript">$(document).ready(function(){toastr["success"]("Başarıyla veri silindi.", "Başarılı");});</script>';
	
}

}

if (isset($_POST['caridus'])) {
	
$crtutar = temizle($_POST['crtutar']);
$sipno = temizle($_POST['siparisno']);
$ssno = $ozy->query("select * from siparis where siparisno='$sipno'")->fetch(PDO::FETCH_ASSOC);
$nctutar = $ssno['caritutar']- $crtutar;
$ocrtutar = $ssno['odenencari']+$crtutar;
$stmtzzz = $ozy->prepare("UPDATE siparis SET caritutar = ? ,odenencari=? WHERE siparisno ='$sipno' and uye='$uyeid'");
$result2 = $stmtzzz->execute(array($nctutar,$ocrtutar));
if ($result2) {

echo '<script type="text/javascript">$(document).ready(function(){toastr["success"]("Başarıyla cari hesaptan tutar düşümü sağlandı.", "Başarılı");});</script>';
header("Location: ".$ayar['siteurl']."/boss/bayi-siparisleri?uye=".$uyeid."");	
}

}

<div class="wrapper">
        <div class="container-fluid">
            
            <div class="page-title-box">
                <div class="row align-items-center">
                    <div class="col-sm-6">
                        <h4 class="page-title">Cari Hesap Özeti
						
						
						
						</h4>
                    </div>
                    <div class="col-sm-6">
                        <ol class="breadcrumb float-right">
                            <li class="breadcrumb-item"><a href="index.html">Anasayfa</a></li>
                           
                            <li class="breadcrumb-item active">Cari Hesap Özeti</li>
                        </ol>
                    </div>
                </div>
                
            </div>

<div class="row">
			
			
			
			
							
			
			
			
			
                <div class="col-12">
                    <div class="card m-b-30">
                        <div class="card-body">
						
						
						
					
                <div class="col-sm-6 col-xl-3" style="float: left;margin-top: 6px;">
                    <div class="card">
                        <div class="card-heading p-4">
                            <div class="mini-stat-icon float-right">
                                <i class="mdi mdi-cube-outline bg-primary  text-white"></i>
                            </div>
                            <div>
				
							
							
                                <h5 class="font-16">Siparişler (Bugün)</h5>
                            </div>
                            <h3 class="mt-4">
						<?php $siparis1 = $ozy->query("SELECT SUM(toplamtutar+caritutar) FROM siparis where caritutar>'0' and tarihson = CURDATE();")->fetch(PDO::FETCH_ASSOC);
                        foreach( $siparis1 as $siparis1x ){
                        echo $siparis1x = number_format($siparis1x, 2, '.', '');}?> TL
		
							</h3>
                            <div class="progress mt-4" style="height: 4px;">
              
                            </div>
                            <p class="text-muted mt-2 mb-0">Toplam Sipariş<span class="float-right"><?php 
			  $say1 = $ozy->prepare("SELECT COUNT(*) FROM siparis where caritutar>'0' and tarihson = CURDATE();");
              $say1->execute();
              echo $siparis1 = $say1->fetchColumn();?> Adet</span></p>
                        </div>
                    </div>
                </div>

<div class="col-sm-6 col-xl-3" style="float: left;margin-top: 6px;">
                    <div class="card">
                        <div class="card-heading p-4">
                            <div class="mini-stat-icon float-right">
                                <i class="mdi mdi-buffer bg-danger text-white"></i>
              
                            </div>
                            <div>
				
							
							
                                <h5 class="font-16">Siparişler (Bu yıl)</h5>
                            </div>
                            <h3 class="mt-4">
						<?php $siparis1234 = $ozy->query("SELECT SUM(toplamtutar+caritutar) FROM siparis WHERE caritutar>'0' and tarihson >= NOW() - INTERVAL 1 YEAR")->fetch(PDO::FETCH_ASSOC);
                        foreach( $siparis1234 as $siparis1xxxx ){
                        echo $siparis1xxxx = number_format($siparis1xxxx, 2, '.', '');}?> TL
							
							</h3>
                            <div class="progress mt-4" style="height: 4px;">
              
                            </div>
                            <p class="text-muted mt-2 mb-0">Toplam Sipariş<span class="float-right"><?php 
			  $say1234 = $ozy->prepare("SELECT COUNT(*) FROM siparis WHERE caritutar>'0' and tarihson >= NOW() - INTERVAL 1 YEAR");
              $say1234->execute();
              echo $siparis1234 = $say1234->fetchColumn();?> Adet</span></p>
                        </div>
                    </div>
                </div>
<?php $usepettoplami = $ozy->query("SELECT SUM(toplamtutar+caritutar) FROM siparis WHERE caritutar>'0'")->fetch(PDO::FETCH_ASSOC);
foreach( $usepettoplami as $usepetbedeli ){
$usepetbedeli = number_format($usepetbedeli, 2, '.', '');
}?>
<?php $cusepettoplami = $ozy->query("SELECT SUM(caritutar+odenencari) FROM siparis WHERE caritutar>'0'")->fetch(PDO::FETCH_ASSOC);
foreach( $cusepettoplami as $cusepetbedeli ){
$cusepetbedeli = number_format($cusepetbedeli, 2, '.', '');
}?>	
<?php $ocusepettoplami = $ozy->query("SELECT SUM(toplamtutar) FROM siparis WHERE caritutar>'0'")->fetch(PDO::FETCH_ASSOC);
foreach( $ocusepettoplami as $ocusepetbedeli ){
$ocusepetbedeli = number_format($ocusepetbedeli, 2, '.', '');
}?>

<?php $cusepettoplamic = $ozy->query("SELECT SUM(odenencari) FROM siparis WHERE caritutar>'0'")->fetch(PDO::FETCH_ASSOC);
foreach( $cusepettoplamic as $cusepetbedelic ){
$cusepetbedelic = number_format($cusepetbedelic, 2, '.', '');
}?>

<?php $cusepettoplamic1 = $ozy->query("SELECT SUM(caritutar) FROM siparis WHERE caritutar>'0'")->fetch(PDO::FETCH_ASSOC);
foreach( $cusepettoplamic1 as $cusepetbedelic1 ){
$cusepetbedelic1 = number_format($cusepetbedelic1, 2, '.', '');
}?>	
		
<div style="border: 1px solid #e0dbdb;
font-size: 14px;
padding-left: 20px;
margin-bottom: 20px;
padding-bottom: 30px;">
<div style="border: 1px solid #e0dbdb;
font-size: 14px;
padding-left: 20px;
margin-bottom: 20px;
padding-bottom: 30px;">
<b style="background: #247a06;
color: white;
padding: 10px;float: left;margin-right:10px;width: 18%;
text-align: center;
height: 75px;
padding: 16px;">Toplam Sipariş Bedeli: <?php echo $usepetbedeli;?> TL</b></br></br>
<b style="background: #0b012f;
color: white;
padding: 10px;float: left;margin-right:10px;width: 18%;
text-align: center;
height: 75px;
padding: 16px;">Ödenen Tutar Bedeli: <?php echo $ocusepetbedeli;?> TL</b></br></br>
<b style="background: #ca0912;
color: white;
padding: 10px;float: left;margin-right:10px;width: 18%;
text-align: center;
height: 75px;
padding: 16px;">Toplam Cari Tutar Bedeli: <?php echo $cusepetbedeli;?> TL</b></br></br>

<b style="background: #1832be;
color: white;
padding: 10px;float: left;margin-right:10px;width: 18%;
text-align: center;
height: 75px;
padding: 16px;">Ödenen Cari Tutar Bedeli: <?php echo $cusepetbedelic;?> TL</b></br></br>

<b style="background: #caac09;
color: white;
padding: 10px;float: left;margin-right:10px;width: 18%;
text-align: center;
height: 75px;
padding: 16px;">Kalan Cari Tutar Bedeli: <?php echo $cusepetbedelic1;?> TL</b></br></br>

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

</div>

<form action="" method="POST" style="background: #f9f6f6;padding: 10px;"> 
                                             <label style="width: 95%;">Sipariş Seçiniz:</label>
		<input name="uyeid" value="<?php echo temizle($_GET['uye']);?>" type="hidden">
										       <select name="siparisno" style="width: 50%;" class="form-control" onchange='this.form.submit()'>
<?php $ekbimiz = $ozy->query("select * from siparis where caritutar>'0' order by id desc")->fetchAll(PDO::FETCH_ASSOC); 
foreach($ekbimiz as $ekibimiz){?>
												<option <?php echo $_GET['siparisno'] == $_POST['siparisno'] ? 'selected="selected"' : null; ?> value="<?php echo $ekibimiz['siparisno'];?>"><?php echo $ekibimiz['siparisno'];?> / Cari Tutar Miktarı : <?php echo $ekibimiz['caritutar'];?> TL</option>
                                                
						     <?php }?>
											</select>

<div style="margin-left: 53% !important;margin-top: -53px !important;">
							<label style="width: 100%;">Cari Hesaptan Düşülecek Tutar:
							<input type="search" class="form-control" name="crtutar" placeholder="Sadece TL bazında düşüm yapılabilir. Rakam giriniz" required>
							</label>
							</div>
							
							<button type="submit" name="caridus" style="width: 100%;" class="btn btn-warning waves-effect waves-lightt">
							Cari Hesaptan Düş
							</button>
							
							</div>
							</form>
						
						
						
						
						
						
						
						
						
						
						
						
                            <table data-order='[[ 0, "desc" ]]' id="datatable" class="table table-bordered dt-responsive nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                                <thead>
                                <tr>
								    
                                    <th>Sipariş No</th>
									<th>Bayi</th>
									<th>Toplam Sipariş Tutarı</th>
									<th>Sipariş Ödenenen Tutar</th>
									<th>Toplam Cari Tutar</th>
                                   <th>Ödenen Cari Tutar</th>
								   <th>Kalan Cari Tutar</th>
									<th>Ödeme Tarihi</th>
									 <th>Ödeme Tipi</th>
                                    <th>Durumu</th>
									<th>Sipariş Tarihi</th>
                                    <th>İşlem</th>
                                </tr>
                                </thead>

<tbody>
								
	                       <?php $pr = $ozy->query("select * from siparis where caritutar>'0' ORDER BY id desc")->fetchAll(PDO::FETCH_ASSOC);
                           foreach ($pr as $tr) {?>	
								
								
                                <tr>
								
                                    <td><?php echo $tr['siparisno']?></td>
									<?php 
									$sipuyeid = $tr['uye'];
									$kargoid = $tr['kargoid'];
									$siparisuyebilgileri = $ozy->query("select * from users where id='$sipuyeid' and bayi='1'")->fetch(PDO::FETCH_ASSOC);
									$kargobilgileri = $ozy->query("select * from kargolar where id='$kargoid'")->fetch(PDO::FETCH_ASSOC);?>
									<td><a target="_blank" href="bayi-siparisleri?uye=<?php echo $tr['uye']?>">
									<?php echo $siparisuyebilgileri['isim']?>
									</td>
									
									<?php if($tr['caritutar']=='0'){?>
									<td>
									<b><?php echo $tr['toplamtutar'];?> TL</b>
									</td>
									<?php } else { ?>
									<td>
									<b><?php echo $tr['toplamtutar']+$tr['caritutar'];?> TL</b>
									</td>
									<?php } ?>
									
									 <td><b><?php echo $tr['toplamtutar']?> TL</b></td>
									 
									 <td>
									<?php echo $xtoplamcari = $tr['caritutar']+$tr['odenencari'];?> TL 
									</td>
									
									 
									 
									
									<td><?php echo $tr['odenencari'];?> TL / <?php echo afiyatgoster($tr['odenencari'],$tr['para']);?></td>
									
									<td><?php echo $xkalancari = $tr['caritutar'];?> TL / <?php echo afiyatgoster($xkalancari,$tr['para']);?></td>
									
									
									<td>
									<?php echo $tr['caritarih'];?></td>
									
								
                                   
									
										<td><?php echo $tr['odemetipi']?></td>
									
									 <td><span style="font-size: 13px;font-size: 13px;background: white;color: black;border: 1px solid #6975b6;border-radius: 0px;padding: 5px;" class="badge badge-success"><?php echo $tr['durum']?></td>
									</span>
                                   
									<td><?php echo $tr['tarih']?></td>
                                    <td>
									<a href="tel:<?php echo $tr['telefon'];  ?>" target="_blank" onclick="return confirm('Telefon ile yanıt vermek istiyor musun ?')" class="btn btn-sm btn-danger" style="border: none;background: #4192e9;" data-toggle="tooltip" data-original-title="Telefon ile Yanıtla"><img style="width: 16px;height: 16px;" src="assets/images/tel.png"></img></a>									 
									<a href="https://api.whatsapp.com/send?phone=+9<?php echo $tr['telefon'];  ?>&amp;text=Merhaba iyi günler, <?php echo $ayar['siteadi'];?> olarak websitemizinden <?php echo $tr['siparisno'];  ?> nolu siparişiniz için rahatsız ediyorum. Sipariş durumunuz <?php echo $tr['durum'];  ?> olarak güncellenmiştir. <?php echo $tr['durum'] == 'Kargoya Verildi' ? 'Kargo Bilgileriniz : '.$kargobilgileri['adi'].' Takip Numaranız : '.$tr['takipno'].'' : null; ?> İyi günler dileriz." target="_blank" onclick="return confirm('WhatsApp ile yanıt vermek istiyor musun  ?')" class="btn btn-sm btn-danger" style="border: #2ab200;background: #2ab200;" data-toggle="tooltip" data-original-title="WhatsApp ile Yanıtla"><img style="width: 16px;height: 16px;" src="assets/images/whatsap.jpg"></img></a>									 
									<a href="javascript:printDiv('divYazdir<?php echo $tr['id']?>');" style="background: #8a940b;color: white;" onclick="return confirm('Siparişi yazdırmak istediğine emin misin?')" class="btn btn-sm btn" data-toggle="tooltip" data-original-title="Yazdır"><i class="fa fa-print" aria-hidden="true"></i></a>									 
			                        <a href="bayi-siparisleri?temizle=<?php echo $tr['id'];  ?>" onclick="return confirm('Silmek istediğinize emin misiniz ?')" class="btn btn-sm btn-danger" data-toggle="tooltip" data-original-title="Sil"><i class="ti-trash" aria-hidden="true"></i></a>									 
									<a href="siparis/duzenle/<?php echo $tr['id']?>" class="btn btn-sm btn-success" data-toggle="tooltip" data-original-title="Düzenle"><i class="fa fa-edit" aria-hidden="true"></i></a>					
									</td>
                                </tr>
                               
									 <div class="col-12" id="divYazdir<?php echo $tr['id']?>" style="display:none;">
							 <?php $adresdizi = $dizi = explode (" ",$tr['adres']);?>
<div style="position:absolute;left:50%;margin-left:-420px;top:0px;width:841px;height:594px;border-style:outset;overflow:hidden">
<div style="position:absolute;left:0px;top:0px">
<img src="faturaback.jpg" width=841 height=594></div>
<div style="position: absolute;left: 15%;top: 40.33px;" class="cls_002"><span class="cls_002"><img src="../resimler/siteayarlari/<?php echo $ayar['logo']; ?>" style="height: 40px !important"></span></div>
<div style="position:absolute;left:41.76px;top:84.33px" class="cls_002"><span class="cls_002">Gönderici Bilgileri</span></div>
<div style="position:absolute;left:41.76px;top:106.09px" class="cls_003"><span class="cls_003">Şirket İsmi</span></div>
<div style="position:absolute;left:134.07px;top:106.09px" class="cls_003"><span class="cls_003"><?php echo $ayar['siteadi'];?></span></div>
<div style="position:absolute;left:41.76px;top:127.85px" class="cls_003"><span class="cls_003">Şirket Telefon</span></div>
<div style="position:absolute;left:134.07px;top:127.85px" class="cls_003"><span class="cls_003"><?php echo $ayar['tel'];?></span></div>
<div style="position:absolute;left:41.76px;top:149.62px" class="cls_002"><span class="cls_002">Alıcı Bilgileri</span></div>
<div style="position:absolute;left:41.76px;top:171.38px" class="cls_003"><span class="cls_003">Ad / Soyad</span></div>
<div style="position:absolute;left:134.07px;top:171.38px" class="cls_003"><span class="cls_003"><?php echo $tr['adsoyad'];?></span></div>
<div style="position:absolute;left:134.07px;top:193.15px" class="cls_003"><span class="cls_003"><?php echo $dizi[0];?> <?php echo $dizi[1];?> <?php echo $dizi[2];?> </span></div>
<div style="position:absolute;left:41.76px;top:209.66px" class="cls_003"><span class="cls_003">Adres</span></div>
<div style="position:absolute;left:134.07px;top:209.66px" class="cls_003"><span class="cls_003"><?php echo $dizi[3];?>  <?php echo $dizi[4];?> <?php echo $dizi[5];?></span></div>
<div style="position:absolute;left:134.07px;top:226.17px" class="cls_003"><span class="cls_003"><?php echo $dizi[6];?> <?php echo $dizi[7];?> <?php echo $dizi[8];?> <?php echo $dizi[9];?></span></div>
<div style="position:absolute;left:41.76px;top:247.93px" class="cls_003"><span class="cls_003">İl / İlçe</span></div>
<div style="position:absolute;left:134.07px;top:247.93px" class="cls_003"><span class="cls_003"><?php echo $tr['il'];?> / <?php echo $tr['ilce'];?></span></div>
<div style="position:absolute;left:41.76px;top:269.69px" class="cls_003"><span class="cls_003">Telefon No</span></div>
<div style="position:absolute;left:134.07px;top:269.69px" class="cls_003"><span class="cls_003"><?php echo $tr['telefon'];?></span></div>
<div style="position:absolute;left:41.76px;top:291.46px" class="cls_003"><span class="cls_003">Cep Telefonu</span></div>
<div style="position:absolute;left:134.07px;top:291.46px" class="cls_003"><span class="cls_003"><?php echo $tr['telefon'];?></span></div>
<div style="position:absolute;left:41.76px;top:313.22px" class="cls_003"><span class="cls_003">Posta Kodu</span></div>
<div style="position:absolute;left:134.07px;top:313.22px" class="cls_003"><span class="cls_003">90000</span></div>
<div style="position:absolute;left:41.76px;top:334.99px" class="cls_002"><span class="cls_002">Satış Bilgileri</span></div>
<div style="position:absolute;left:41.76px;top:356.75px" class="cls_003"><span class="cls_003">Kargo</span></div>
<div style="position:absolute;left:41.76px;top:373.26px" class="cls_003"><span class="cls_003">Bilgileri</span></div>
<div style="position:absolute;left:134.07px;top:352.69px" class="cls_003"><span class="cls_003"><?php echo $kargobilgileri['adi'];?></span></div>
<div style="position:absolute;left:134.07px;top:372.69px" class="cls_003"><span class="cls_003"><?php echo $tr['takipno'];?></span></div>
<div style="position:absolute;left:41.76px;top:395.02px" class="cls_003"><span class="cls_003">Durum : <?php echo $tr['durum'];?></span></div>
<div style="position:absolute;left:41.76px;top:416.79px" class="cls_003"><span class="cls_003">Ödeme</span></div>
<div style="position:absolute;left:134.07px;top:425.04px" class="cls_003"><span class="cls_003"><?php echo $tr['odemetipi'];?></span></div>
<div style="position:absolute;left:41.76px;top:433.30px" class="cls_003"><span class="cls_003">Yöntemi</span></div>
<div style="position:absolute;left:41.76px;top:455.06px" class="cls_003"><span class="cls_003">Sipariş Kodu</span></div>
<div style="position:absolute;left:134.07px;top:455.06px" class="cls_003"><span class="cls_003"><?php echo $tr['siparisno'];?></span></div>
</div>
                                      
								
                                    
							 
							 
							</div>
							
							   
		                    <?php }?>					   
							   
							   
							   
							   
                                </tbody>
                            </table>

</div>
                    </div>
                </div> 
            </div>

</div>

İptal

📁 PHP Dosya Yöneticisi

📝 carihesapozeti.php

📝 carihesapozeti.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)