Ajax Pop-Up | Member | | Join Date: Aug 2008
Posts: 40
| | |
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....
|  | Moderator | | Join Date: Aug 2008 Location: Leipzig, Germany
Posts: 3,664
| | | re: Ajax Pop-Up
If you can show us the code, we can maybe spot the problem.
regards
| | Member | | Join Date: Aug 2008
Posts: 40
| | | re: Ajax Pop-Up
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 -
<?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 -
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\')"> <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.. -
<?
-
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> </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"/> <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>
-
<? } }?>
-
|  | Moderator | | Join Date: Aug 2008 Location: Leipzig, Germany
Posts: 3,664
| | | re: Ajax Pop-Up Quote:
Originally Posted by divyac My problem is,if i click on the submit button,nothing is getting submitted. technically speaking, you do not have a form here, i.e. you are missing the <form> tags.
regards
|  | Similar JavaScript / Ajax / DHTML bytes | | | /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 226,537 network members.
|