JavaScript Forum

**ckdoublenecks** · 12-13-2010, 08:26 PM

I'm hoping someone will look at the below code for me. The fields I'm trying to selectively zero are all being zeroed except the prevbal and I don't know what's going on with that. The rest of it works. ?

Code:

 
<script>
function calculate_paid()
{
var rentdue = document.getElementById("rentdue");
var prevbal = document.getElementById("prevbal");
var amtpaid = document.getElementById("amtpaid");
var tentpay = document.getElementById("tentpay");
var hudpay = document.getElementById("hudpay");
 var datepaid = document.getElementById("datepaid");
 var late = document.getElementById("late");
var damage = document.getElementById("damage");
var courtcost = document.getElementById("courtcost");
var nsf = document.getElementById("nsf");
var latechg = document.getElementById("latechg");
var secdep = document.getElementById("secdep");
 var dateNow = new Date();
 var dayNow = dateNow.getDate();
 var datePaid = (dateNow.getMonth()+1)+"/"+dateNow.getDate()+"/"+dateNow.getFullYear();
 datepaid.value = datePaid; 
          var totOwed = parseInt(rentdue.value) + parseInt(prevbal.value) + parseInt(damage.value) + parseInt(courtcost.value) + parseInt(nsf.value) + parseInt(latechg.value) + parseInt(secdep.value) - parseInt(hudpay.value);
         var hold = totOwed - amtpaid.value;
 tentpay.value = amtpaid.value - hudpay.value;
  if(dayNow > 5)
{
   late.value = "L";
prevbal.value = prevbal.value + 10;
  } 
 
 if(hold >= prevbal.value)
{
hold = hold - prevbal.value;
prevbal.value = 0;
}
if(hold >= secdep.value)
{
hold = hold - secdep.value;
secdep.value = 0;
}
if(hold >= damage.value)
{
hold = hold - damage.value;
damage.value = 0;
}
if(hold >= courtcost.value)
{
hold = hold - courtcost.value;
courtcost.value = 0;
}
if(hold >= nsf.value)
{
hold = hold - nsf.value
nsf.value = 0;
}
if(hold >= latechg.value)
{
hold = hold - latechg.value;
latechg.value = 0;
}
prevbal.value = hold;
      } 
</script>

**PaulW** · 12-14-2010, 11:40 AM

Could just be the data -- are you sure you've entered data that would cause hold >= prevbal.value to be followed?

**ckdoublenecks** · 12-14-2010, 02:59 PM

I've tried it above and below. the values are always cleared and the prevbal is always incorrect.

**PaulW** · 12-15-2010, 05:52 AM

Last statement in function -- prevbal is always being reassigned...

**ckdoublenecks** · 08:00 PM

I've worked so long & hard on this. Someone offered that I should use the code I've commented in in my input but I don't see how or where. Could someone code a line to show me ?

Code:

 
<html><head>
<script>
function $_(IDS) { return document.getElementById(IDS); }
function calculate_paid()
 {
  var rentdue = parseInt($_("rentdue")).value;
  var prevbal = parseInt($_("prevbal")).value;
  var amtpaid = $_("amtpaid").value;
  var tentpay = parseInt($_("tentpay")).value;
  var hudpay = parseInt($_("hudpay")).value;
  var datepaid = $_("datepaid").value;
  var late = $_("late").value;
  var damage = parseInt($_("damage")).value;
  var courtcost = parseInt($_("courtcost")).value;
  var nsf = parseInt($_("nsf")).value;
  var latechg = parseInt($_("latechg")).value;
  var secdep = parseInt($_("secdep")).value;
  var dateNow = new Date();
  var dayNow = dateNow.getDate();
if(dayNow > 5) { late = "L"; prevbal = prevbal + 10; }
  var datePaid = (dateNow.getMonth()+1)+"/"+dateNow.getDate()+"/"+dateNow.getFullYear();
$_('datePaid').value = datePaid;
      tentpay = amtpaid - hudpay;
  var totOwed = rentdue + prevbal + damage + courtcost + nsf + latechg + secdep - hudpay;
  var hold =  amtpaid - totOwed;
  if (hold >= prevbal) { hold = hold - prevbal; prevbal = 0; }
  if (hold >= secdep) { hold = hold - secdep; secdep = 0; }
  if (hold >= damage) { hold = hold - damage; damage = 0; }
  if (hold >= courtcost) { hold = hold - courtcost; courtcost = 0; }
  if (hold >= nsf) { hold = hold - nsf; nsf = 0; }
  if (hold >= latechg) { hold = hold - latechg; latechg = 0; }
  prevbal = hold + prevbal + secdep + damage + courtcost + nsf + latechg; 
      } 
</script>
<script type="text/javascript">
window.google_analytics_uacct = "UA-256751-2";
</script>
<script type="text/javascript">
window.google_analytics_uacct = "UA-256751-2";
</script>
</head><body>
<?php
mysql_connect(localhost,root,"");
mysql_select_db(test) or die( "Unable to select database");
if(!empty($_POST["submit"]))
{
$apt = $_POST['apt'];
$query="SELECT * FROM testdata Where apt='$apt'";
$result=mysql_query($query);
if(mysql_num_rows($result))
{
echo "<form action='#' method='post'><b>Rent Payment :<br /><br />
<table cellspacing=0 cellpadding=0 border=1>
<tr>
<th>dep</th>
<th>tenant</th>
<th>apt</th>
<th>paid</th>
<th>due</th>
<th>prev</th>
<th>tent</th>
<th>hud</th>
<th>dmg</th>
<th>court</th>
<th>nsf</th>
<th>latchg</th>
<th>sec</th>
<th>date</th>
<th>late</th>
<th>comments</th>
</tr>";
while($row = mysql_fetch_assoc($result))
{
echo "<tr>
// $_('prevbal').value = hold
// $_('secdep').value = secdep
// $_('damage').value = damage
// $_('courtcost').value = courtcost
// $_('latechg').value = latechg
<td><input type='text' size=5 name='dep' value='" . $row['dep'] . "'></td>
<td><input type='text' size=25 name='name' value='" . $row['name'] . "'></td>
<td><input type='text' size=2 name='apt' value='" . $row['apt'] . "' ></td>
<td><input type='text' size=4 id='amtpaid' name='amtpaid' value='" . $row['amtpaid'] ."' onkeyup='calculate_paid(this)'></td>
<td><input type='text' size=4 name='rentdue' value='" . $row['rentdue'] . "'></td>
<td><input type='text' size=4 id='prevbal' name='prevbal' value='" . $row['prevbal'] ."'        onkeyup='calculate_paid(this)'></td>
<td><input type='text' size=4 id='tentpay' name='tentpay' value='" . $row['tentpay'] . "'></td>
<td><input type='text' size=4 id='hudpay' name='hudpay' value='" . $row['hudpay'] ."' ></td>
<td><input type='text' size=4 id='damage' name='damage' value='" . $row['damage'] ."'   onkeyup='calculate_paid(this)'></td>
<td><input type='text' size=4 id='courtcost' name='courtcost' value='" . $row['courtcost'] ."'       onkeyup='calculate_paid(this)'></td>
<td><input type='text' size=4 id='nsf' name='nsf' value='" . $row['nsf'] ."'        onkeyup='$_(IDS)(this)'></td>
<td><input type='text' size=4 id='latechg' name='latechg' value='" . $row['latechg'] ."'   onkeyup='calculate_paid(this)'></td>
<td><input type='text' size=4 id='secdep' name='secdep' value='" . $row['secdep'] ."'   onkeyup='calculate_paid(this)'></td>
<td><input type='text' size=10 id='datepaid' name='datepaid' value='" . $row['datepaid'] . "'></td>
<td><input type='text' size=1 id='late' name='late' value='" . $row['late'] . "'></td>
<td><input type='text' size=25 name='comments' value='" . $row['comments'] . "'></td>
</tr>";
}
echo "</table>
<input type='submit' name='update' value='Make Payment' />
</form>";
}
else{echo "No listing for apartment $apt.<br />Please select another.<br />";}
}
if(!empty($_POST["update"]))
{
$sql = "UPDATE payments SET
dep = '" . mysql_real_escape_string($_POST['dep']) . "',
name = '" . mysql_real_escape_string($_POST['name']) . "',
amtpaid = '" . mysql_real_escape_string($_POST['amtpaid']) . "',
rentdue = '" . mysql_real_escape_string($_POST['rentdue']) . "',
prevbal = '" . mysql_real_escape_string($_POST['prevbal']) . "',
tentpay = '" . mysql_real_escape_string($_POST['tentpay']) . "',
hudpay = '" . mysql_real_escape_string($_POST['hudpay']) . "',
damage = '" . mysql_real_escape_string($_POST['damage']) . "',
courtcost = '" . mysql_real_escape_string($_POST['costcost']) . "',
nsf = '" . mysql_real_escape_string($_POST['nsf']) . "',
latechg = '" . mysql_real_escape_string($_POST['latechg']) . "',
secdep = '" . mysql_real_escape_string($_POST['secdep']) . "',
datepaid = '" . mysql_real_escape_string($_POST['datepaid']) . "',
late = '" . mysql_real_escape_string($_POST['late']) . "',
comments = '" . mysql_real_escape_string($_POST['comments']) . "'
WHERE apt='".$_POST["apt"]."'";
mysql_query($sql) or die("Update query failed.");
echo "Record for apartment ".$_POST["apt"]." has been updated";
}
?>
<form method="post" action="#">
<br />
<input type="text" name="apt"/> <p>
<input type="submit" name="submit" value="select apartment"/>
</form>
<script type="text/javascript"><!--
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
//-->
</script>
<script type="text/javascript"><!--
try {
var pageTracker = _gat._getTracker("UA-256751-2");
pageTracker._trackPageview();
} catch(err) {}
//-->
</script>
<script type="text/javascript"><!--
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
//-->
</script>
<script type="text/javascript"><!--
try {
var pageTracker = _gat._getTracker("UA-256751-2");
pageTracker._trackPageview();
} catch(err) {}
//-->
</script>
</body></html>

**ckdoublenecks** · 12-17-2010, 09:23 AM

what is post count padding?

**CSM** · 12-17-2010, 12:44 PM

Check here http://whirlpool.net.au/wiki/post_padding