Na}{

File Content: invoice.php

<?php
	include("../library.php");
echo $custId=$_REQUEST['id'];
$row6=$mysql6->m_FetchArray($mysql6->m_Query("select * from tblcustomer where id=$custId"));
echo	$name=mysql_real_escape_string($row6['name']);
	echo $mobileNo=mysql_real_escape_string($row6['mobileNo']);
	echo $email=mysql_real_escape_string($row6['email']);
	echo $houseNo=mysql_real_escape_string($row6['houseNo']);
	echo $street=mysql_real_escape_string($row6['street']);
	echo $colony=mysql_real_escape_string($row6['colony']);
	echo $landmark=mysql_real_escape_string($row6['landmark']);
	echo $city=mysql_real_escape_string($row6['city']);
	echo $state=mysql_real_escape_string($row6['state']);
	$payment=mysql_real_escape_string($_REQUEST['payment']);

$discount=mysql_real_escape_string($_REQUEST['discount']);
	
	$createdDate=date('Y-m-d');
	$createdTime=date('H:i:s');
	
	
		$billingId=$_REQUEST['billingId'];
	
	
	$result=$mysql2->m_Query("select * from tblinvoice order by invoiceId desc");
	if($mysql2->m_NumRows()==0)
	{
	   $invoiceId=1;
	}
	else
	{
		$row2=$mysql2->m_FetchObject();
		$invoiceId=$row2->invoiceId+1;
	}
	  $billingId;
	
	$result=$mysql9->m_Query("select * from tblinvoice where billingId='$billingId'");
	if($mysql9->m_NumRows()==0)
	{
	    $total=0;$subtotal=0;
		$result=$mysql->m_Query("select * from tbladdcart where billingId='$billingId'");
		while($row=$mysql->m_FetchObject())
		{
			 $productId=$row->productId;
			$qty=$row->qty;
			$price=$row->price;
			$totalAmount=$row->totalAmount;
			$productName=mysql_real_escape_string($row->productName);
			
		
			 $subtotal=$subtotal+$row->price;
			$total=$total+$row->totalAmount;
		}
		 $subtotal=$subtotal;
		 $netAmount=$total;
		
		$discountAmt=($netAmount*$discount/100);
        $netAmount=$netAmount-$discountAmt;
		$result=$mysql8->m_Query("insert into tblinvoice(invoiceId,name,mobileNo,emailId,houseNo,street,colony,landmark,city,state,gst,gstAmount,subtotal,netAmount,createdDate,ipAddress,status,custId,payment,invoiceStatus,createdTime,billingId,discount,discountAmt)value('$invoiceId','$name','$mobileNo','$email','$houseNo','$street','$colony','$landmark','$city','$state','0','0','$subtotal','$netAmount','$createdDate','$ipAddress','Approved','$custId','$payment','Pending','$createdTime','$billingId','$discount','$discountAmt')");
		
		
		header("location:../bookingDetails.php?id=$invoiceId");
	
	}
?>

Name	Size	Permission
delete.php	1677 bytes	0644
insert.php	1355 bytes	0644
insertorder.php	1411 bytes	0644
inserts.php	1318 bytes	0644
invoice.php	2382 bytes	0644
room_inventorysingle.php	372 bytes	0644
save_Booking.php	1580 bytes	0644
save_BookingBlock.php	674 bytes	0644
save_BookingE.php	1314 bytes	0644
save_BookingRate.php	824 bytes	0644
save_Gallery.php	1586 bytes	0644
save_Homes.php	802 bytes	0644
save_ProductImage.php	904 bytes	0644
save_Testimonials.php	832 bytes	0644
save_category.php	1403 bytes	0644
save_product.php	1763 bytes	0644
save_productcategory.php	535 bytes	0644
save_roomInventory.php	1200 bytes	0644
save_user.php	1258 bytes	0644
save_users.php	1491 bytes	0644
setRate.php	545 bytes	0644
setRatesF.php	581 bytes	0644
setRatesI.php	569 bytes	0644
track.php	360 bytes	0644
update.php	16071 bytes	0644
update_Homes.php	899 bytes	0644
update_Testimonials.php	401 bytes	0644
update_category.php	1572 bytes	0644
update_inventoryActive.php	575 bytes	0644
update_inventoryBlock.php	462 bytes	0644
update_inventoryRate.php	562 bytes	0644
update_orderproduct.php	579 bytes	0644
update_product.php	1618 bytes	0644
update_productDetail.php	1079 bytes	0644
update_productDetails.php	1045 bytes	0644
update_productcategory.php	333 bytes	0644