Ajax Pop-Up

**Divya** · 01-07-2009, 03:22 AM

I am doing an inventory project in which i need to do sales and rentals.As the starting point,there will be text box where the customer id is entered.If the customer id is valid another text box will appear in which the product id should be entered.If that particular product is for rentals, a popup will appear which is done using ajax.In that popup i need to add some data and submit it in the database.My problem is,if i click on the submit button,nothing is getting submitted.what may be the problem?????help me please....

Jordan · 01-07-2009, 05:21 AM

Can we see your code for the third popup and the server side script/code you are using?

**Divya** · 01-07-2009, 08:06 PM

The code is bit bigger...
Still i have to work on some functionalities and that too only after submitting.Now my sole aim is to submit...Here is the code for returns.php

Code:

<?php
include "includes/user.php";

if(isset($_GET['customerID'])&& $_GET['customerID']!='' && isset($_GET['productID'])&& $_GET['productID']!='' )
{
$totalUser=mysql_num_rows(mysql_query("SELECT Customers.customerID, Products.productID FROM pri_master_sales_rental SaleAndRental, pri_master_products Products, pri_master_customers Customers WHERE SaleAndRental.customerID=Customers.customerID AND SaleAndRental.productID=Products.productID HAVING customerID='$_GET[customerID]' AND productID ='$_GET[productID]' "));

$query="SELECT Customers.Name, Customers.customerID, Products.productID, Products.productName, SaleAndRental.rentalPrice, SaleAndRental.rentedDate, SaleAndRental.dueDate, SaleAndRental.lateCharges FROM pri_master_sales_rental SaleAndRental, pri_master_products Products, pri_master_customers Customers WHERE SaleAndRental.customerID=Customers.customerID AND SaleAndRental.productID=Products.productID HAVING customerID='$_GET[customerID]' ORDER BY SaleAndRental.rentedDate DESC LIMIT $set_limit, $limit";

$result=mysql_query($query);
$count=mysql_num_rows($result);
}

if(isset($_GET['sendCR']))
{
$productUpdate=mysql_query("update pri_master_products set stockInHand=stockInHand+1 where productID ='$_GET[productID]'");
$customerUpdate=mysql_query("update pri_master_customers set totalAmount=totalAmount+'$_GET[lateCharges]',
													  		 amountPaid=amountPaid+'$_GET[amountPaid]', 
													  		 balanceAmount='$_GET[balanceAmount]' where customerID='$_GET[customerID]'") or die("Query failed : " . mysql_error());
		//header('location:returns.php?success=1');								   
}


if(isset($_GET['sendCS']))
{
$tempInsert=mysql_query("insert into pri_temp_returns(productID)VALUES('$_GET[productID]')");
$productUpdate=mysql_query("update pri_master_products set stockInHand=stockInHand-1,stockInStores=stockInStores-1 where productID ='$_GET[productID]'");
$customerUpdate=mysql_query("update pri_master_customers set totalAmount=totalAmount+'$_GET[convCharges]',
													         amountPaid=amountPaid+'$_GET[amountPaid]', 
													         balanceAmount='$_GET[balanceAmount]' where customerID='$_GET[customerID]'") or die("Query failed : " . mysql_error());
		//header('location:returns.php?success=2');								   
}

if(isset($_GET['sendMoreCR']))
{
$insert=mysql_query("INSERT INTO pri_temp_returns(productID)VALUES('$_GET[productID]')");
$productUpdate=mysql_query("update pri_master_products set stockInHand=stockInHand+1 where productID ='$_GET[productID]'");
$customerUpdate=mysql_query("update pri_master_customers set totalAmount=totalAmount+'$_GET[lateCharges]',
													  		 amountPaid=amountPaid+'$_GET[amountPaid]', 
													  		 balanceAmount='$_GET[balanceAmount]' where customerID='$_GET[customerID]'") or die("Query failed : " . mysql_error());
}

if(isset($_GET['sendMoreCS']))
{
$insert=mysql_query("INSERT INTO pri_temp_returns(productID)VALUES('$_GET[productID]')");
$productUpdate=mysql_query("update pri_master_products set stockInHand=stockInHand-1,
													       stockInStores=stockInStores-1 where productID ='$_GET[productID]'");
$customerUpdate=mysql_query("update pri_master_customers set totalAmount=totalAmount+'$_GET[convCharges]',
													         amountPaid=amountPaid+'$_GET[amountPaid]', 
													         balanceAmount='$_GET[balanceAmount]' where customerID='$_GET[customerID]'") or die("Query failed : " . mysql_error());
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>SALES AND RENTALS MANAGEMENT SYSTEM</title>
<link rel="stylesheet" href="styled.css" type="text/css">
<link rel="stylesheet" href="style.css" type="text/css">
<script src="javascripts/popup.js"></script>

</head>
<body onload="javascript:document.getElementById('customerID').focus();">
	<div>
	<div>
    	<? include_once "includes/header.php" ?>
    	<? include_once "includes/menu.php" ?>
	</div>
    <div class="container">
    <div><h2>Home</h2></div>
<div style="min-height:400px;">

<h3 style="margin: 0px 50px 25px 50px; border-bottom: #999999 2px solid">Returns</h3><a href="home.php"><h5 align="right" style="margin-right:50px;">Back to Home</h5></a>
<div align="center" style="font-size:12px; color:#FF0000;"><strong>
<?
if($_GET['success']==1)
{echo 'Product Returned successfully';}
if($_GET['success']==2)
{echo 'Converted to sales successfully';}

?>
</strong>
</div><div style="padding-left:250px">

<div class='divStyle'>
<div class='divLabel'><label class='text'>Customer ID</label></div>
<div><input type='text' onkeyup="keyPress(this.value,event)" name="customerID" id="customerID" value="<?=isset($_GET['customerID'])&& $_GET['customerID']!=''? $_GET['customerID'] :''?>"/></div>

</div>
</div>
<div style="padding-left:250px">
<div id="placeHolder" class="text"></div></div>
<div style="display:none; width:440px;" id="popupForm"></div>

<div id="product"></div>

<div id="productDetails"></div>
      <br />
        <div align="center">
           <input type="button" name="history" id="history" value="Customer History" onclick="getHistory();"/>
           <input type="button" name="details" id="details" value="Customer Details" onclick="getDetails();"/>
           <input type="button" name="Reset" id="Reset" value="Reset" onclick="javascript:window.location='returns.php'"/>
        <input type="submit" name="view" id="view" value="View Last Transaction" onclick="viewTrans();formSubmit('salesRentals')"/>
</div>

        </div>
      </div>
      </div>
    </div>
    </div>
 <div align="right" style="padding:10px 16px 0px 0px; font-size:12px; font-weight:bold;"></div>
</body>
</html>

and the one below is popup.js

Code:

 var xmlHttp
var globalString
var returnPopup=0
var x=0
var y=0

function showUser(str)
{ 

customerxmlHttp=GetXmlHttpObject()
if (customerxmlHttp==null)
 {
 alert ("Browser does not support HTTP Request")
 return
 }
var url="product.php?customerID="+str+"&custid="+Math.random()
customerxmlHttp.onreadystatechange=stateChanged
customerxmlHttp.open("GET",url,true)
customerxmlHttp.send(null)

}

function stateChanged() 
{ 
if (customerxmlHttp.readyState==4 || customerxmlHttp.readyState=="complete")
 { 
	 //document.getElementById("txtHint").innerHTML=xmlHttp.responseText 
	 var placeHolder=document.getElementById("placeHolder");
	 //alert(xmlHttp.responseText)
	 if(customerxmlHttp.responseText==1)
	 {
			placeHolder.innerHTML='<div class="divStyle" id="product"><div class="divLabel"><label class="text">Product ID</label></div><div><input type="text" name="productID" id="productID" onKeyup="productPress(\'popupForm\',event)" onblur="returnForm(\'popupForm\')"></div></div>';
			document.getElementById('productID').focus();
			var rate=document.getElementById("salesPrice").value
			var val=document.getElementById("rentalPrice").value
	        document.getElementById("balanceAmount").value=rate-val

	 }else{
		 placeHolder.innerHTML=''
		 document.getElementById('customerID').value=''
		 document.getElementById('customerID').focus(); 
		 alert('Invalid customer')
	 }
  }
}

function returnForm(elementId)
{
	var customerId=document.getElementById('customerID').value
	var productID=document.getElementById('productID').value
	var popup=document.getElementById('popupForm')
		popxmlHttp=GetXmlHttpObject()
			if (popxmlHttp==null)
			 {
			 alert ("Browser does not support HTTP Request")
			 return
			 }
	
	if(popup.style.display=='none')
	{
		
		var url="returnsDetails.php?customerID="+customerId+"&productID="+productID+"&cid="+Math.random()
		//call the ajax function
		popxmlHttp.onreadystatechange=popUpControl
		popxmlHttp.open("GET",url,true)
		popxmlHttp.send(null)
	}
}
function popUpControl(){
	var control=document.getElementById("popupForm")
	if (popxmlHttp.readyState==4 || popxmlHttp.readyState=="complete"){ 
	if(popxmlHttp.responseText!=0){
		control.style.display='block';
		control.innerHTML=popxmlHttp.responseText
			var rate=document.getElementById("salesPrice").value
			var val=document.getElementById("rentalPrice").value
	        document.getElementById("convCharges").value=rate-val
			var num = new Number(document.getElementById('convCharges').value);
			document.getElementById('convCharges').value=num.toFixed(2);

	}
	else
	{
		var placeHolder=document.getElementById("placeHolder");
		placeHolder.innerHTML='<div class="divStyle" id="product"><div class="divLabel"><label class="text">Product ID</label></div><div><input type="text" name="productID" id="productID" onKeyup="productPress(\'popupForm\',event)" onblur="returnForm(\'popupForm\')">&nbsp;&nbsp;<font color="#FF0000">This Product is not for Rentals</font></div></div>';
        document.getElementById('productID').focus(); 
		
	}
	
	}
	ajaxPopup(control)
}

function ajaxPopup(htmlElement){
	htmlElement.style.zIndex="100";
	htmlElement.style.position="absolute";
	htmlElement.style.width="450px";
	htmlElement.style.margin='0px 0px 0px 0px';
	htmlElement.style.backgroundColor="#FFFFFF";
	htmlElement.style.borderColor="#000000";
	htmlElement.style.left=((window.screen.width/2)-250)+'px';
	//htmlElement.style.top=((window.screen.height/2)-80)+'px';
	htmlElement.style.top='330px';
}

function keyPress(str,e){
	var keycode = e.keyCode || window.event.keyCode;
	if(keycode == 13){
		showUser(str)
	}
}

function productPress(str,e){
	var keycode = e.keyCode || window.event.keyCode;
	if(keycode == 13){
		returnForm(str)
	}
}


function afterpopup(popupElement)
{
  var con=document.getElementById(popupElement);
  con.style.zIndex="50";
  con.innerHTML="";
  con.style.display='none';

}

/*function to get the details of the customer*/
function getDetails(){
	var customerId=document.getElementById('customerID').value
	//create ajax object
	getDetailxmlHttp=GetXmlHttpObject()
			if (getDetailxmlHttp==null)
			 {
			 alert ("Browser does not support HTTP Request")
			 return
			 }
	
		var url="customerDetails.php?customerID="+customerId+"&cid="+Math.random()
		//call the ajax function
		getDetailxmlHttp.onreadystatechange=getCustomerDetails
		getDetailxmlHttp.open("GET",url,true)
		getDetailxmlHttp.send(null)

}

function getCustomerDetails(){
		 	var place=document.getElementById("productDetails");
			
	if (getDetailxmlHttp.readyState==4 || getDetailxmlHttp.readyState=="complete"){ 
			place.innerHTML=getDetailxmlHttp.responseText
  	}
}

//end of the function

/* function to get the history of the customer*/
function getHistory(){	
	var customerId=document.getElementById('customerID').value
	//create ajax object
	getHistoryxmlHttp=GetXmlHttpObject()
			if (getHistoryxmlHttp==null)
			 {
			 alert ("Browser does not support HTTP Request")
			 return
			 }
	
		var url="customerHistory.php?customerID="+customerId+"&cid="+Math.random()
		//call the ajax function
		getHistoryxmlHttp.onreadystatechange=getCustomerHistory
		getHistoryxmlHttp.open("GET",url,true)
		getHistoryxmlHttp.send(null)
}

function getCustomerHistory(){
		 	var placeHolder=document.getElementById("productDetails");
			
	if (getHistoryxmlHttp.readyState==4 || getHistoryxmlHttp.readyState=="complete"){ 
			placeHolder.innerHTML=getHistoryxmlHttp.responseText
  	}
}
//end of the function



function lateBalance(){

if(x==0){
 var latefees=document.getElementById("lateCharges").value
 var balanceamount=document.getElementById("balanceAmount").value
 document.getElementById("balanceAmount").value=parseFloat(latefees)+parseFloat(balanceamount)
x++;
}
}

function returnBalance(){

if(y==0){

 var conversioncharges=document.getElementById("convCharges").value
 var balanceamount=document.getElementById("balanceAmount").value
 	document.getElementById("balanceAmount").value=parseFloat(conversioncharges)+parseFloat(balanceamount)
	y++
}
}

/*function caldueAmount(val){
 var rPrice=document.getElementById("rentalPrice").value
  var rprice=document.getElementById('rentalPrice').value
 var sprice=document.getElementById('salesPrice').value
 var latefees=document.getElementById("lateCharges").value
 var conversioncharges=document.getElementById("convCharges").value
 var balanceamount=document.getElementById("balanceAmount").value
 
 if(conversioncharges==sprice){
 	document.getElementById("balanceAmount").value=(parseFloat(balanceamount) + parseFloat(sprice))-rprice
	//alert "parseInt(balanceamount) + parseInt(sprice)-rprice"
 }
 else if(conversioncharges==latefees){
 	document.getElementById("balanceAmount").value=parseFloat(balanceamount) + parseFloat(latefees)
 }
 else{
 	document.getElementById("balanceAmount").value=balanceamount
 }
}
*/
function discountAmount(val){
	var rate=document.getElementById("balanceAmount").value
	document.getElementById("balanceAmount").value=rate-val
}

function paymentAmount(val){
	var balanceamount=document.getElementById("balanceAmount").value
	document.getElementById("newBalance").value=balanceamount-val
	var num = document.getElementById('newBalance').value;
    document.getElementById('newBalance').value=num.toFixed(2);
}

function GetXmlHttpObject()
{
var xmlHttp=null;
try
 {
	 // Firefox, Opera 8.0+, Safari
	 xmlHttp=new XMLHttpRequest();
 }
catch (e)
 {
 //Internet Explorer
 try
  {
	  xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
  }
 catch (e)
  {
	  xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
 }
return xmlHttp;
}// JavaScript Document// JavaScript Document// JavaScript Document

and the other one is returnDetails.php and this is the file where the submit buttons are present..

Code:

<?
include_once('includes/connection.php');

if(isset($_GET['customerID'])&&($_GET['customerID']!='') && isset($_GET['productID'])&&($_GET['productID']!='')) {

$select=mysql_query("select (DATEDIFF(curdate(),salesrental.dueDate)* products.lateFees) as lateCharges,products.lateFees from pri_master_sales_rental salesrental,pri_master_products products where products.productID=salesrental.productID and products.productID='$_GET[productID]' and salesrental.customerID='$_GET[customerID]'");
$selectResultset=mysql_fetch_array($select);

$result=mysql_query("SELECT Customers.firstName, Customers.customerID, Products.productID, Products.productName, SaleAndRental.rentalPrice, DATE_FORMAT(SaleAndRental.rentedDate, '%m-%d-%X') AS rentedDate,DATE_FORMAT(SaleAndRental.dueDate, '%m-%d-%X') AS dueDate , SaleAndRental.lateFees, SaleAndRental.Discounts, SaleAndRental.paymentMode, Products.salesPrice,Customers.balanceAmount FROM pri_master_sales_rental SaleAndRental, pri_master_products Products, pri_master_customers Customers WHERE SaleAndRental.customerID=Customers.customerID AND SaleAndRental.productID=Products.productID AND SaleAndRental.type='rented' HAVING customerID='$_GET[customerID]' AND productID ='$_GET[productID]' ORDER BY SaleAndRental.rentedDate");

if(mysql_num_rows($result)>0){
$detailsresultset=mysql_fetch_array($result);

?>
<div style="background:url(images/bg.gif); margin:0px 0px 0px 0px;  padding:0px 0px 0px 0px;">
<div style="float:right; line-height:36px;">
<a href="javascript:void(0)" onclick="afterpopup('popupForm')"><img src="images/close.png" style="border:none" title="Close"/></a>&nbsp;&nbsp;</div>
<div style=" line-height:36px; text-align:center; font-family:Verdana, Arial, Helvetica, sans-serif;">Returns</div>
</div>
<form name="returnDetails" id="returnDetails">

<div style="padding:10px 10px 0px 15px;" >
<div class='divStyle'><div class='divLabel'><label class='text'>Rented Date </label> </div><div><input size="30" name="rentedDate" id="rentedDate" type="text" value="<?= $detailsresultset['rentedDate']; ?>" readonly="readonly"/></div></div>
<div class='divStyle'><div class='divLabel'><label class='text'>Rental Charges </label></div><div><input size="30" name="rentalPrice" id="rentalPrice" type="text" value="<?= $detailsresultset['rentalPrice']; ?>" readonly="readonly" /></div></div>
<div class='divStyle'><div class='divLabel'><label class='text'>Sales Price </label></div><div><input size="30" name="salesPrice" type="text" value="<?= $detailsresultset['salesPrice']; ?>" readonly="readonly" id="salesPrice"/></div></div>
<div class='divStyle'><div class='divLabel'><label class='text'>Due Date</label></div><div><input size="30" name="dueDate" id="dueDate" type="text" value="<?= $detailsresultset['dueDate']; ?>" readonly="readonly" /></div></div>
<div class='divStyle'><div class='divLabel'><label class='text'>Late fees </label></div><div><input size="30" name="lateCharges" id="lateCharges" type="text" value="<? if($selectResultset['dueDate'] < $selectResultset['curdate()']) { 
					  echo $selectResultset['lateCharges'];
					  } else {
					  echo '0';
					  } ?>" readonly="readonly"/>
<input type="radio" id="radioLateCharges" name="radioLateCharges" onclick="lateBalance()"/></div>
</div>
<div class='divStyle'><div class='divLabel'><label class='text'>Current Charges</label></div><div><input size="30" name="convCharges" type="text" id="convCharges" readonly="readonly"/>&nbsp;<input type="radio" id="radioConvCharges" name="radioLateCharges" onclick="returnBalance()"/></div></div>
<div class='divStyle'><div class='divLabel'><label class='text'>Discount </label></div><div><input size="30" name="Discount" id="Discount" type="text" value="0" onchange='discountAmount(this.value)'/></div></div>
<div class='divStyle'><div class='divLabel'><label class='text'>Amount Due</label></div><div><input size="30" name="balanceAmount" id="balanceAmount" type="text" value="<?= $detailsresultset['balanceAmount']; ?>" readonly="readonly"/></div></div>
<div class='divStyle'><div class='divLabel'><label class='text'></label>
</div>
  <div></div>
</div>
</div>
<div class="divStyle"><div class="divLabel"><label class="text" style="padding: 0px 0px 0px 0px;"></label></div>        
<div>
<input type="submit" name="sendCR" id="sendCR" value="Submit-CR" style="border:double #000000 2px;" onclick="javascript:document.getElementById(\'returnDetails\').submit();"/>
<input type="submit" name="sendCS" id="sendCS" value="Submit-CS" style="border:double #000000 2px;" onclick="javascript:document.getElementById(\'returnDetails\').submit();"/>
<input type="submit" name="sendMoreCR" id="sendMoreCR" value="More Returns" style="border:double #000000 2px;" onclick="javascript:document.getElementById(\'returnDetails\').submit();"/>
<input type="submit" name="sendMoreCS" id="sendMoreCS" value="More Conversions" style="border:double #000000 2px;" onclick="javascript:document.getElementById(\'returnDetails\').submit();"/>
</div></div>
</form>
<!--<label class="text" style="padding:0px 0px 0px 30px;"></label>-->

<div class="divStyle"><div class="divLabel"><label class="text"></label></div> 
  <label class="text" style="padding:0px 0px 0px 46px;"></label>
</div>
</div>
<? } }?>

Thread: Ajax Pop-Up

LinkBack

Thread Tools

Search Thread

Display

Ajax Pop-Up

Re: Ajax Pop-Up

Re: Ajax Pop-Up

Thread Information

Users Browsing this Thread

Similar Threads

PHP Vs AJAX

SQL and AJAX

.Net and Ajax

Will Ajax still be Ajax?

Need some AJAX help

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions