REDROOM

Navigation

Breadcrumbs

/ / home / ankaservis / azad.ankaservis.com / muhasebe

Create

Create File | Create Folder | Upload Files | Run Command

Edit File Size: 5.08 KB

/home/ankaservis/azad.ankaservis.com/muhasebe/fetch_pages.php

Text Base64

if(isset($_POST) && isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest'){
	
	include("config.inc.php"); 
	include("sistem/ayarlar.php");

if(isset($_POST["page"])){
		$page_number = filter_var($_POST["page"], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH); //filter number
		if(!is_numeric($page_number)){die('Invalid page number!');} 
	}else{
		$page_number = 1; 
	}
	
	
	$results = $mysqli_conn->query("SELECT COUNT(*) FROM musteriler where bayidurum='1' and ID!='6285'");
	$get_total_rows = $results->fetch_row(); 
	
	$total_pages = ceil($get_total_rows[0]/$item_per_page);

$page_position = (($page_number-1) * $item_per_page);
	
	$results = $mysqli_conn->query("SELECT ID, Ad_Soyad, firma, Tel, email, bayidurum FROM musteriler where bayidurum='1' and ID!='6285' ORDER BY ID DESC LIMIT $page_position, $item_per_page");
	
		
										
	
	echo '
	 <table id="id="exRowTable"" class="table table-striped table-bordered responsive">
                                <thead class="">
                                    <tr>
										<th>ID</th>
                                        <th>Ad Soyad</th>
										<th>Firma</th>
                                        <th>Telefon</th>
                                        <th>E-posta</th>
										<th>Bakiye</th>
                                       
                                        
                                    </tr>
                                </thead>
                         
                                <tbody>
	
	';
	while($row = $results->fetch_assoc()) {
		$carikim= $row["ID"];
										$cariborc = mysql_query("SELECT SUM(borc) as borc FROM carihareket where cariid='$carikim' ");
										$row5 = mysql_fetch_array($cariborc); 
										$borcu= $row5["borc"];
										$carialacak = mysql_query("SELECT SUM(alacak) as alacak FROM carihareket where cariid='$carikim' ");
										$row2 = mysql_fetch_array($carialacak); 
									
										$alacak= $row2["alacak"];
										$toplayalim	= number_format($borcu-$alacak,2, ',', '.');
		echo '
		<tr>
										
                                        <td><a href="Musteri.php?GiT='.$row["ID"].'">'.$row["ID"].' </a>	</td>
										<td><a href="Musteri.php?GiT='.$row["ID"].'">'.$row["Ad_Soyad"].' </a>	</td>
                                        <td><a href="Musteri.php?GiT='.$row["ID"].'">'.$row["firma"].'</a></td>
										<td><a href="Musteri.php?GiT='.$row["ID"].'">'.$row["Tel"].'</a></td>
                                        <td><a href="Musteri.php?GiT='.$row["ID"].'">'.$row["email"].'</a></td>
										<td>'.$toplayalim.'</td>
                                       
                                        
                                    </tr>
		
		';
		
	
	}  
	echo '
	</tbody>
                            </table>
	';
	
	
	echo '<div align="center">';
	
	echo paginate_function($item_per_page, $page_number, $get_total_rows[0], $total_pages);
	echo '</div>';
}

Exit & Reset Text mode: syntax highlighting auto-detects file type.

Directory Contents

Dirs: 21 × Files: 125

Sort:

Enable drag-to-move

Name	Size	Perms	Modified	Actions
ajax DIR	-	drwxr-xr-x	2025-01-09 06:49:12	Edit Download recursive recursive
barkod DIR	-	drwxr-xr-x	2025-01-09 06:49:14	Edit Download recursive recursive
blok DIR	-	drwxr-xr-x	2025-01-09 06:49:14	Edit Download recursive recursive
css DIR	-	drwxr-xr-x	2025-01-09 06:49:14	Edit Download recursive recursive
db DIR	-	drwxr-xr-x	2025-01-09 06:49:14	Edit Download recursive recursive
dist DIR	-	drwxr-xr-x	2025-01-09 06:49:18	Edit Download recursive recursive
Excel DIR	-	drwxr-xr-x	2025-01-09 06:49:22	Edit Download recursive recursive
font DIR	-	drwxr-xr-x	2025-01-09 06:49:22	Edit Download recursive recursive
fonts DIR	-	drwxr-xr-x	2025-01-09 06:49:22	Edit Download recursive recursive
giris DIR	-	drwxr-xr-x	2025-01-09 06:49:22	Edit Download recursive recursive
holder.js DIR	-	drwxr-xr-x	2025-01-09 06:49:22	Edit Download recursive recursive
images DIR	-	drwxr-xr-x	2025-01-09 06:49:24	Edit Download recursive recursive
img DIR	-	drwxr-xr-x	2025-01-09 06:49:24	Edit Download recursive recursive
js DIR	-	drwxr-xr-x	2025-01-09 06:49:24	Edit Download recursive recursive
Pager DIR	-	drwxr-xr-x	2025-01-09 06:49:24	Edit Download recursive recursive
scopbin DIR	-	drwxr-xr-x	2025-01-09 06:49:24	Edit Download recursive recursive
sf DIR	-	drwxr-xr-x	2025-01-09 06:49:24	Edit Download recursive recursive
sistem DIR	-	drwxr-xr-x	2025-01-09 06:49:26	Edit Download recursive recursive
Sorgula DIR	-	drwxr-xr-x	2025-01-09 06:49:30	Edit Download recursive recursive
yedekle_Xc DIR	-	drwxr-xr-x	2025-01-09 06:49:30	Edit Download recursive recursive
yuklenen DIR	-	drwxr-xr-x	2025-01-09 06:49:30	Edit Download recursive recursive
.htaccess	1.33 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
30ustu.php	9.25 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
ajax-loader.gif	3.41 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
ara.php	4.12 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
arafatura.php	985 B	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
aramasonuc.php	18.62 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
aramatel.php	18.62 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
araseri.php	975 B	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
aratakip.php	993 B	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
ay.php	9.25 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
ayarlar.php	17.22 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
carihareket_yazdir.php	9.55 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
cari_tarih_sorgu.php	10.89 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
class.phpmailer.php	88.75 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
class.smtp.php	30.33 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
config.inc.php	508 B	lrw-r--r--	2023-01-20 08:58:08	Edit Download recursive recursive
deftergiris.php	27.25 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
deftersorgu.php	28.51 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
depo.php	12.88 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
depo_analiz.php	12.88 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
depo_hareketleri.php	22.62 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
depo_hareketleri_sorgu.php	23.71 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
depo_nakil.php	22.48 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
depo_stok_kodu_sorgu.php	23.19 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
error_log	153 B	lrw-r--r--	2025-01-09 10:13:36	Edit Download recursive recursive
faturam.php	22.76 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
fetch_pages.php	5.08 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
fetch_pagesarama.php	6.06 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
fetch_pages_tumu.php	4.96 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
fis.php	6.03 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
formhesap.php	3.51 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
formhesap2.php	4.04 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
giris.php	4.46 KB	lrw-r--r--	2024-07-31 10:29:22	Edit Download recursive recursive
girisler.php	20.38 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
girisler_sorgu.php	24.71 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
gorusmeekle.php	1.02 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
hafta.php	9.25 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
hatirlatmalar.php	16.59 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
hatirlatma_duzen.php	14.07 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
hesap_nakil.php	2.79 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
hesap_nakil_personel.php	2.67 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
index.php	18.53 KB	lrw-r--r--	2024-07-31 11:02:08	Edit Download recursive recursive
islem.php	253 B	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
jquery-1.9.0.js	261.05 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
jquery-ui-1.10.0.custom.js	422.49 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
jquery-ui-1.10.0.custom.min.css	26.42 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
jsDatePick.css	8.21 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
jsDatePick.min.1.1.js	27.95 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
kasadefteri.php	26.70 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
kasa_defteri_ajax1.php	7.11 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
kasa_hareketleri.php	27.98 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
kasa_rapor.php	29.34 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
kasa_rapor_sorgu.php	30.18 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
lisans.php	466 B	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
markaListele.php	9.61 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
mesajlarim.php	6.55 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
mesaj_oku.php	7.25 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
mesaj_yaz.php	6.92 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
Musteri.php	81.68 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
MusteriEkle.php	23.05 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
Musteriler.php	15.92 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
Musterilerajax.php	18.04 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
Musteriler_tumu.php	18.06 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
Musteri_borc.php	17.80 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
musteri_exel.php	1.01 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
ORNEK_MUSTERI_SABLONU.xls	19.50 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
ORNEK_STOK_SABLONU.xls	19.00 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
parcamodul.php	53.08 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
perListele.php	10.65 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
personelis.php	10.53 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
personelis_yazdir.php	8.84 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
personel_defter_sorgu.php	29.72 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
personel_excel.php	17.39 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
personel_kasa.php	33.75 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
personel_kasa_getir.php	17.15 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
personel_kasa_giris.php	39.56 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
personel_kasa_onaysiz.php	33.47 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
personel_kasa_yazdir.php	11.15 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
pesin_satis.php	18.70 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
profil_resmim.php	7.23 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
rapor_aylik_alislar.php	25.79 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
rapor_aylik_satislar.php	25.81 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
rapor_gunluk.php	27.80 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
rapor_tarih_kasa.php	28.12 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
refresh.png	832 B	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
rehberduzen.php	19.24 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
rehberekle.php	18.41 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
resimyukle.php	3.58 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
resimyukleser.php	3.59 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
security.php	879 B	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
serinoListele.php	6.16 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
serinosorgula.php	7.90 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
seri_liste.php	9.53 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
ServisDuzen.php	21.54 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
ServisDuzenpersonel.php	13.70 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
servisekle.php	11.84 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
sifre_degistir.php	7.05 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
sortable.js	187.39 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
stokalis_satis.php	20.05 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
stokfis_list.php	23.75 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
stokfis_list_personel.php	22.43 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
stokguruplari.php	12.89 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
stokhareket.php	56.47 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
stokkartduzenle.php	27.42 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
stokkartekle.php	22.12 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
stokkartiara.php	21.65 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
stokkartlari.php	21.35 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
stokkartlari_depo.php	21.34 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
stokkartlari_kritik.php	20.87 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
stok_alis.php	19.71 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
stok_excel.php	3.01 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
stok_fatura.php	23.47 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
stok_fis_sorgu.php	26.82 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
stok_fis_sorgu_personel.php	25.67 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
stok_hareketleri.php	25.08 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
stok_hareketleri_sorgu.php	26.52 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
stok_kodu_sorgu.php	24.86 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
stok_satis.php	19.71 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
turListele.php	9.57 KB	lrw-r--r--	2017-05-21 19:35:00	Edit Download recursive recursive
veri_kontrol.php	239 B	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
vt_yedekleme_Xc.php	11.27 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
xls.php	18.01 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
xls_stok.php	17.00 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
yazdir.php	7.42 KB	lrw-r--r--	2024-04-11 01:54:26	Edit Download recursive recursive
yedekle_Xc.php	1.15 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive