Once the input is selected and the update is done, it shows the recently inputed values. and then doesnt give the user the option to enter it again.
kind of a write once module. Help!
Code: Select all
<?php
include ("opendatabase.php");
$ur_file_id=5;
//start of claim update
if ( $pageaction == "clmupdate") {
$update_status = ", Claim Information updated" ;
$query="update claims SET q1=".$updt_q1.", q2=".$updt_q2.", q3=".$updt_q3.", q4=".$updt_q4.", q4a=".$updt_q4a.",
q1_date=".$updt_q1_date.", q2_date=".$updt_q2_date.", q3_date=".$updt_q3_date.", q4_date=".$updt_q4_date."
WHERE ur_file_id=".$urfile ;
$result = mysql_query($query);
}
//end of claim update
//start of normal page rendering.
$query = "select * from claims where ur_adjuster_no =4 and ur_file_id=5" ;
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
// now assign the questionaire fields to temp variables for proper visual coding.
$page_q1 = $row['q1'];
$page_q2 = $row['q2'];
$page_q3 = $row['q3'];
$page_q4 = $row['q4'];
$page_q4a = $row['q4a'];
$page_q1_date = $row['q1_date'];
$page_q2_date = $row['q2_date'];
$page_q3_date = $row['q3_date'];
$page_q4_date = $row['q4_date'];
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Universal Risk Claims Detail Page</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.style3 {color: #FFFFFF}
.style4 {font-size: 24px}
.style5 {font-size: 36px}
.style6 {font-size: 18px}
body {
margin-left: 0px;
margin-top: 1px;
margin-right: 0px;
margin-bottom: 0px;
}
.style7 {
color: #006666;
font-size: 24px;
}
.style8 {font-size: 12px}
input
{
border: 1px solid #000000;
background: #DDDDDD;
}
select
{
border: 1px solid #000000;
background: #DDDDDD;
font-family: verdana,helvetica,arial,sans-serif;
font-size: 10px;
}
-->
</style>
<script language="JavaScript" src="calendar1.js"></script>
</head>
<body>
<table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="10" rowspan="6" align="left" valign="top"> </td>
<td width="25" rowspan="6" align="left" valign="top" bgcolor="#9E0B0E"> </td>
<td width="5" rowspan="6" align="left" valign="top"> </td>
<td width="730" bgcolor="#006666"><span class="style3"> <span class="style4">Status System</span> </span></td>
<td width="5" rowspan="6" align="left" valign="top"> </td>
<td width="25" rowspan="6" align="left" valign="top" bgcolor="#9E0B0E"> </td>
</tr>
<tr>
<td height="2" align="left" valign="top"></td>
</tr>
<tr>
<td width="730" align="center" valign="top" bgcolor="#9E0B0E"><div align="center" class="style3 style6">Claim Detail Page <? echo $update_status ; ?> </div></td>
</tr>
<tr>
<td height="15" align="left" valign="top"></td>
</tr>
<tr>
<td height="20" align="left" valign="top"><table width="730" border="0" cellspacing="0" cellpadding="0">
<tr align="left" valign="top">
<td colspan="6"><div align="left"> </div></td>
</tr>
<tr>
<td class="style8">Claim Assignment Type </td>
<td colspan="3" align="left" valign="top"><span class="style8"><? echo $row['claim_assignment_type'] ;?></span></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="6"> </td>
</tr>
<tr align="left" valign="top">
<td height="100" colspan="6">
<form name="adjdetail" action="test.php" method="post">
<table width="730" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="25" align="left" valign="top" class="style8">1.</td>
<td width="340" align="left" valign="top" class="style8"> Has initial contact been made with the insured? </td>
<td width="10" align="left" valign="top"> </td>
<td width="100" align="left" valign="top"><span class="style8"><? if ($page_q1_date == 0) {?><input type="radio" name="updt_q1" value="NO" checked>NO<input type="radio" name="updt_q1" value="YES">Yes<? } else { echo $page_q1; ?><input type="hidden" name="$updt_q1" value="<? echo $page_q1; ?>"><? } ?></span></td>
<td width="30" align="right" valign="top" class="style8">Date: </td>
<td width="150" align="left" valign="top" class="style8"><? if ($page_q1_date == 0) {?><input type="text" name="updt_q1_date" value="" size="10"> <a href="javascript:cal1.popup();"><img src="../images/img/cal.gif" width="16" height="16" border="0" alt="Click Here to Pick up the date"></a><? } else {echo $page_q1_date ; ?><input type="hidden" name="updt_q1_date" value="<? echo $page_q1_date ; ?>"><? } ?></td>
<td width="75" align="left" valign="top"> </td>
</tr>
<tr>
<td class="style8">2.</td>
<td class="style8"> If No, contact attempted? </td>
<td> </td>
<td><span class="style8"><? if ($page_q2_date == 0) {?><input type="radio" name="updt_q2" value="NO" checked>NO<input type="radio" name="updt_q2" value="YES">Yes<? } else { echo $page_q2; ?><input type="hidden" name="$updt_q2" value="<? echo $page_q2; ?>"><? } ?></span></td>
<td align="right" valign="top"><span class="style8">Date: </span></td>
<td align="left" valign="top"><span class="style8"><? if ($page_q2_date == 0) {?><input type="text" name="updt_q2_date" value="" size="10"> <a href="javascript:cal2.popup();"><img src="../images/img/cal.gif" width="16" height="16" border="0" alt="Click Here to Pick up the date"></a><? } else {echo $page_q2_date ; ?><input type="hidden" name="updt_q2_date" value="<? echo $page_q2_date ; ?>"><? } ?></span></td>
<td> </td>
</tr>
<tr>
<td class="style8">3.</td>
<td class="style8"> Inspected/Scoped ? </td>
<td> </td>
<td><span class="style8"><? if ($page_q3_date == 0) {?><input type="radio" name="updt_q3" value="NO" checked>NO<input type="radio" name="updt_q3" value="YES">Yes<? } else { echo $page_q3; ?><input type="hidden" name="$updt_q3" value="<? echo $page_q3; ?>"><? } ?></span></td>
<td align="right" valign="top"><span class="style8">Date: </span></td>
<td align="left" valign="top"><span class="style8"><? if ($page_q3_date == 0) {?><input type="text" name="updt_q3_date" value="" size="10"> <a href="javascript:cal3.popup();"><img src="../images/img/cal.gif" width="16" height="16" border="0" alt="Click Here to Pick up the date"></a><? } else {echo $page_q3_date ; ?><input type="hidden" name="updt_q3_date" value="<? echo $page_q3_date ; ?>"><? } ?></span></td>
<td> </td>
</tr>
<tr>
<td class="style8">4.</td>
<td class="style8"> Has a reserve change been entered in the system? </td>
<td> </td>
<td><span class="style8"><? if ($page_q4_date == 0) {?><input type="radio" name="updt_q4" value="NO" checked>NO<input type="radio" name="updt_q4" value="YES">Yes<? } else { echo $page_q4; ?><input type="hidden" name="$updt_q4" value="<? echo $page_q4; ?>"><? } ?></span></td>
<td align="right" valign="top"><span class="style8">Date: </span></td>
<td align="left" valign="top"><span class="style8"><? if ($page_q4_date == 0) {?><input type="text" name="updt_q4_date" value="" size="10"> <a href="javascript:cal4.popup();"><img src="../images/img/cal.gif" width="16" height="16" border="0" alt="Click Here to Pick up the date"></a><? } else {echo $page_q4_date ; ?><input type="hidden" name="updt_q4_date" value="<? echo $page_q4_date ; ?>"><? } ?></span></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td class="style8"> 4-a. Reserve Amount</td>
<td> </td>
<td><span class="style8"><? if ($page_q4a == 0) {?>$ <input type="text" name="updt_q4a" value="0" size="10"><? } else { ?>$ <? echo $page_q4a; ?><input type="hidden" name="$updt_q4a" value="<? echo $page_q4a; ?>"><? } ?></span></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td class="style8"> </td>
<td height="20" align="left" valign="top" class="style8"> </td>
<td> </td>
<td> </td>
<td align="right" valign="top"> </td>
<td align="left" valign="top"> </td>
<td> </td>
</tr>
<tr>
<td class="style8"> </td>
<td height="20" align="left" valign="top">
<input type="submit" name="Submit" value="Update Claim">
<input type="hidden" name="pageaction" value="clmupdate">
<input type="hidden" name="PHPSESSID" value="<? echo $PHPSESSID ; ?>">
<input type="hidden" name="ur_adj_id" value="<? echo $ur_adj_id ; ?>">
<input type="hidden" name="urfile" value="<? echo $urfile ; ?>">
</td>
<td> </td>
<td> </td>
<td align="right" valign="top"> </td>
<td align="left" valign="top"> </td>
<td> </td>
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td colspan="6" align="left" valign="top"> </td>
<td height="10"> </td>
</tr>
</table> </td>
</tr>
<tr>
<td align="center" valign="top"><div align="center">
<p> </p>
</div></td>
</tr>
</table>
</body>
</html>
<?
}# end of while statement
?>
<script language="JavaScript">
<!-- // create calendar object(s) just after form tag closed
// specify form element as the only parameter (document.forms['formname'].elements['inputname']);
// note: you can have as many calendar objects as you need for your application
var cal1 = new calendar1(document.forms['adjdetail'].elements['updt_q1_date']);
cal1.year_scroll = true;
cal1.time_comp = false;
var cal2 = new calendar1(document.forms['adjdetail'].elements['updt_q2_date']);
cal2.year_scroll = true;
cal2.time_comp = false;
var cal3 = new calendar1(document.forms['adjdetail'].elements['updt_q3_date']);
cal3.year_scroll = true;
cal3.time_comp = false;
var cal4 = new calendar1(document.forms['adjdetail'].elements['updt_q4_date']);
cal4.year_scroll = true;
cal4.time_comp = false;
var cal5 = new calendar1(document.forms['adjdetail'].elements['updt_q5_date']);
cal5.year_scroll = true;
cal5.time_comp = false;
var cal6 = new calendar1(document.forms['adjdetail'].elements['updt_q6_date']);
cal6.year_scroll = true;
cal6.time_comp = false;
var cal7 = new calendar1(document.forms['adjdetail'].elements['updt_q7_date']);
cal7.year_scroll = true;
cal7.time_comp = false;
var cal8 = new calendar1(document.forms['adjdetail'].elements['updt_q8_date']);
cal8.year_scroll = true;
cal8.time_comp = false;
var cal9 = new calendar1(document.forms['adjdetail'].elements['updt_q9_date']);
cal9.year_scroll = true;
cal9.time_comp = false;
var cal10 = new calendar1(document.forms['adjdetail'].elements['updt_q10_date']);
cal10.year_scroll = true;
cal10.time_comp = false;
var cal11 = new calendar1(document.forms['adjdetail'].elements['updt_q11_date']);
cal11.year_scroll = true;
cal11.time_comp = false;
var cal12 = new calendar1(document.forms['adjdetail'].elements['updt_q12_date']);
cal12.year_scroll = true;
cal12.time_comp = false;
var cal13 = new calendar1(document.forms['adjdetail'].elements['updt_q13_date']);
cal13.year_scroll = true;
cal13.time_comp = false;
var cal14 = new calendar1(document.forms['adjdetail'].elements['updt_q14_date']);
cal14.year_scroll = true;
cal14.time_comp = false;
</script>feyd | Please review how to post code using
Code: Select all
andCode: Select all
tags. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]