REDROOM

Preview: formhesap.php Size: 4.60 KB

/home/ankaservis/azad.ankaservis.com/muhasebe/Sorgula/formhesap.php

<span style="font-size:13px"><b>Ücretlendirme</b></span>
<hr>
<?php 
		$girisgetir	=mysql_Real_escape_string($_POST["takip"]);
		$islemibitenler = mysql_num_rows(mysql_query("select * from parcamodul where girisid='$girisgetir' "));
		$var	=$islemibitenler;
		if($var=="0"){
		echo"0.00";
		}else{
		?>
	<table width="100%" align="right">
	<tr>
		<td style="background-color:#000000; color:#FFFFFF; width:300px"><span style="font-size:12px; color:#FFFFFF; ">&nbsp;&nbsp;<b>Parça Hizmet Adı</b></span></td>
	<td style="background-color:#000000; color:#FFFFFF; width:30px"><span style="font-size:12px; color:#FFFFFF"><b>Adet</b></span></td>
	<td style="background-color:#000000; color:#FFFFFF; width:50px"><span style="font-size:12px; color:#FFFFFF"><b>B.Fiyat</b></span></td>
	<td style="background-color:#000000; color:#FFFFFF; width:50px"><span style="font-size:12px; color:#FFFFFF"><b>Toplam</b></span></td>
	
	

	
	</tr>
	
		<?
$girisgetir	=mysql_Real_escape_string($_POST["takip"]);
		$sqlon2 = "select * from parcamodul where girisid='$girisgetir'";
		$sorumlupersa1 = mysql_query($sqlon2, $baglanti) or die(mysql_error());
		while ($sorumlupers_ver1 = mysql_fetch_array($sorumlupersa1)){


		?>
			
		<?php 
		$parcaidigetir2	=$sorumlupers_ver1['parcaid'];
		
		if($parcaidigetir2=="0" or $parcaidigetir2=="0" ){?>
		
		<tr>
		
		
		<td><span style="font-size:12px">&nbsp;&nbsp;<?php echo $sorumlupers_ver1['aciklama']; ?></span></td>
		<td ><span style="font-size:12px"><?php echo $sorumlupers_ver1['adet']; ?></span></td>
			<td><span style="font-size:12px"><?php echo $sorumlupers_ver1['fiyat']; ?> TL</span></td>
		<td><span style="font-size:12px"><?php echo $sorumlupers_ver1['toplam']; ?> TL</span></td>
		
		
		

		
		</tr>
			
		<?php	
			
		}

		$sqlon3 = "select * from stokkartlari where id='$parcaidigetir2'";
		$sorumlupersa2 = mysql_query($sqlon3, $baglanti) or die(mysql_error());
		while ($sorumlupers_ver2 = mysql_fetch_array($sorumlupersa2)){


		?>
		<tr>
		
		
		<td><span style="font-size:12px">&nbsp;&nbsp;<?php echo $sorumlupers_ver2['urunadi']; ?></span></td>
		<td ><span style="font-size:12px"><?php echo $sorumlupers_ver1['adet']; ?></span></td>
		<td><span style="font-size:12px"><?php echo $sorumlupers_ver1['fiyat']; ?> TL</span></td>
		<td><span style="font-size:12px"><?php echo $sorumlupers_ver1['toplam']; ?> TL</span></td>
		
		
		

		
		</tr>
		
		

	
		<?php } ?>
				
		
	
			
			<? } ?>
			<tr>
			<td colspan="4"><hr></td>
			</tr>
			</table>
			<table align="right">
		<tr>
		
	
		
		
		
		<td style="width:110px"><span style="font-size:12px"><b>Ara Toplam</b></span></td>
			<td >:</td>
		<td><span style="font-size:12px">
		<?php
									$sqlon2 =mysql_Real_escape_string($_POST["takip"]);
									$resultset = mysql_query("select sum(toplam) as toplam from parcamodul where girisid='$sqlon2'");

									if($row = mysql_fetch_array($resultset)){       
									$kasa = $row["toplam"]; 
									echo' '.number_format($kasa,2).' TL';
									}

									?>
		</span></td>
		<td ></td>
		

		
		</tr>
		<tr>
		
		
	
		
		<td><span style="font-size:12px"><b>Kdv</b></span></td>
		<td >:</td>
		<td><span style="font-size:12px">
		<?php
									$sqlon2 =mysql_Real_escape_string($_POST["takip"]);
								
									$kdv_ver2=mysql_fetch_assoc(mysql_query("select GID,kdv from girisler where GID='$sqlon2'"));
									$kdvdeger2=$kdv_ver2["kdv"];
									if($kdvdeger2=="" or $kdvdeger2=="0"){
									echo'Kdv Dahil';
									
									}else{
									
									$resultset = mysql_query("select sum(toplam) as toplam from parcamodul where girisid='$sqlon2'");

									if($row = mysql_fetch_array($resultset)){       
									$kasa = $row["toplam"]; 
									$yuzdehesap=$kasa*$kdvdeger2/100;
									
									
									echo''.number_format($yuzdehesap,2).' TL';
									}
									}

									?>
		</span></td>
		<td ></td>
		

		
		</tr>
		<tr>
		
		

		
		<td ><span style="font-size:12px"><b>Genel Toplam</b></span></td>
		<td >:</td>
		<td style="width:110px"><span style="font-size:12px">
		<?php
									$sqlon2 =mysql_Real_escape_string($_POST["takip"]);
								
									$kdv_ver2=mysql_fetch_assoc(mysql_query("select GID,kdv from girisler where GID='$sqlon2'"));
									$kdvdeger2=$kdv_ver2["kdv"];
									
									$resultset = mysql_query("select sum(toplam) as toplam from parcamodul where girisid='$sqlon2'");

									if($row = mysql_fetch_array($resultset)){       
									$kasa = $row["toplam"]; 
									$yuzdehesap=$kasa*$kdvdeger2/100;
									
									
									echo' '.number_format($yuzdehesap+$kasa,2).' TL';
									}
									

									?>
		</span></td>
		<td ></td>
		

		
		</tr>
		</table>
	
		<? } ?>

Name	Size	Perms	Modified	Actions
Sorgu DIR	-	drwxr-xr-x	2025-01-09 06:49:30	Edit Download recursive recursive
Sorgula_files DIR	-	drwxr-xr-x	2025-01-09 06:49:30	Edit Download recursive recursive
Error.png	12.73 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
formhesap.php	4.60 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
guvenlik.php	544 B	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
index.php	6.48 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
indexd.php	14.35 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
logom.png	39.91 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
mesajGonder.php	2.49 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
servis.png	108.10 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
sonuc.php	8.87 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive
Sorgula.php	4.96 KB	lrw-r--r--	2017-05-21 19:35:02	Edit Download recursive recursive

Directory Contents