Jump to content


Photo

Update Form Validation


  • Please log in to reply
No replies to this topic

#1 Colleen

Colleen
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 05 October 2004 - 09:46 PM

Below is code from a page that was developed using dreamweaver, php, mysql, and some javascript. The form validations work with the data entry form, but I want to validate the form when it is updated also. A lot of this code was written by another individual and/or autogenerated with dreamweaver. Could someone look at it to see if there is a way to get the ... onSubmit="return CheckRequiredFields()" form action to work?

<form action="<?php echo $editFormAction; ?>" method="POST" name="frmChangeProposalInfo" id="frmChangeProposalInfo" onSubmit="return CheckRequiredFields()">



<?php
//Connection statement
require_once('../../../Connections/PropDB.php');

//Aditional Functions
require_once('../../../includes/functions.inc.php');

// build the form action
$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'] . (isset($HTTP_SERVER_VARS['QUERY_STRING']) ? "?" . $HTTP_SERVER_VARS['QUERY_STRING'] : "");

$varCID = $HTTP_GET_VARS['CID'];
$varYRS = $HTTP_GET_VARS['YRS'];
$varPID = $HTTP_GET_VARS['PID'];

if ((isset($HTTP_POST_VARS["MM_update"])) && ($HTTP_POST_VARS["MM_update"] == "frmChangeProposalInfo")) {
$updateSQL = sprintf("UPDATE Projects SET SentDate=%s, ProbPercent=%s, Amount=%s, TMorFixed=%s, AwardDate=%s, ProjectMgr=%s, BusID=%s, Outcome=%s, SFKOptions=%s, QA=%s, DataEnteredBy=%s, Title=%s, StatusDate=%s WHERE $varCID=CID and $varYRS=YRS and $varPID=PID",
GetSQLValueString($HTTP_POST_VARS['SentDate'], "date"),
GetSQLValueString($HTTP_POST_VARS['ProbPercent'], "int"),
GetSQLValueString($HTTP_POST_VARS['Amount'], "double"),
GetSQLValueString($HTTP_POST_VARS['TMorFixed'], "int"),
GetSQLValueString($HTTP_POST_VARS['AwardDate'], "date"),
GetSQLValueString($HTTP_POST_VARS['ProjectMgr'], "text"),
GetSQLValueString($HTTP_POST_VARS['BusinessArea'], "text"),
GetSQLValueString($HTTP_POST_VARS['Status'], "int"),
GetSQLValueString($HTTP_POST_VARS['SKFOptions'], "int"),
GetSQLValueString(isset($HTTP_POST_VARS['QA']) ? "true" : "", "defined","1","0"),
GetSQLValueString($HTTP_POST_VARS['DataEnteredBy'], "text"),
GetSQLValueString($HTTP_POST_VARS['Title'], "text"),
GetSQLValueString($HTTP_POST_VARS['StatusDate'], "date"));

$Result1 = $PropDB->Execute($updateSQL) or die($PropDB->ErrorMsg());
$updateGoTo = "/11_Accounting/ActiveProposalList/Forms/frmDisplayChangeProposalInfo.php";
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
$updateGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
}
KT_redir($updateGoTo);
}

// begin Recordset
$varCID__ChangeProposalInfo = '-1';
if (isset($HTTP_GET_VARS['CID'])) {
$varCID__ChangeProposalInfo = $HTTP_GET_VARS['CID'];
}
$varYRS__ChangeProposalInfo = '-1';
if (isset($HTTP_GET_VARS['YRS'])) {
$varYRS__ChangeProposalInfo = $HTTP_GET_VARS['YRS'];
}
$varPID__ChangeProposalInfo = '-1';
if (isset($HTTP_GET_VARS['PID'])) {
$varPID__ChangeProposalInfo = $HTTP_GET_VARS['PID'];
}
$query_ChangeProposalInfo = sprintf("SELECT *, DATE_FORMAT(SentDate, '%%m/%%d/%%Y') AS Sdate, DATE_FORMAT(AwardDate, '%%m/%%d/%%Y') AS Adate, DATE_FORMAT(StatusDate, '%%m/%%d/%%Y') AS Statdate FROM Projects WHERE CID = %s and YRS = %s and PID = %s", $varCID__ChangeProposalInfo,$varYRS__ChangeProposalInfo,$varPID__ChangeProposalInfo);
$ChangeProposalInfo = $PropDB->SelectLimit($query_ChangeProposalInfo) or die($PropDB->ErrorMsg());
$totalRows_ChangeProposalInfo = $ChangeProposalInfo->RecordCount();
// end Recordset

// begin Recordset
$query_ProjectManagers = "SELECT * FROM Engineers WHERE Engineers.Active=1 ORDER BY Engineers.`EngineerName`";
$ProjectManagers = $PropDB->SelectLimit($query_ProjectManagers) or die($PropDB->ErrorMsg());
$totalRows_ProjectManagers = $ProjectManagers->RecordCount();
// end Recordset

// begin Recordset
$query_BusinessArea = "SELECT * FROM BusinessGroups";
$BusinessArea = $PropDB->SelectLimit($query_BusinessArea) or die($PropDB->ErrorMsg());
$totalRows_BusinessArea = $BusinessArea->RecordCount();
// end Recordset

// begin Recordset
$varCID__ClientList = '-1';
if (isset($HTTP_GET_VARS['CID'])) {
$varCID__ClientList = $HTTP_GET_VARS['CID'];
}
$query_ClientList = sprintf("SELECT * FROM ClientNumber WHERE ClientNo = %s", $varCID__ClientList);
$ClientList = $PropDB->SelectLimit($query_ClientList) or die($PropDB->ErrorMsg());
$totalRows_ClientList = $ClientList->RecordCount();
// end Recordset
//PHP ADODB document - made with PHAkt 2.7.1?>
<html>
<head>

<script language="JavaScript" type="text/JavaScript">
<!--VALIDATIONS
<!--
<!--Copyright 2003 Bontrager Connection, LLC
//Code obtained from http://WillMaster.com/
function CheckRequiredFields() {
var errormessage = new String();
// Put field checks below this point.
if(WithoutSelectionValue(document.frmChangeProposalInfo.ClientName))
{ errormessage += "\n\nPlease select the Client Name from the dropdown list."; }
if(WithoutContent(document.frmChangeProposalInfo.Title.value))
{ errormessage += "\n\nPlease enter a Project Title in the \"Project Title\" field."; }
if(WithoutSelectionValue(document.frmChangeProposalInfo.ProjectMgr))
{ errormessage += "\n\nPlease select a Project Manager from the dropdown list."; }
if(WithoutSelectionValue(document.frmChangeProposalInfo.BusinessArea))
{ errormessage += "\n\nPlease select the Business Area from the dropdown list."; }
if(WithoutContent(document.frmChangeProposalInfo.DataEnteredBy.value))
{ errormessage += "\n\nPlease enter a your initials in the \"Data Entered By\" field."; }
// Need to enter validation here for the numerical field Amount
if(ValidNumber(document.frmChangeProposalInfo.Amount))
{ errormessage += "\n\nPlease enter a valid number in the \"Amount\" field."; }

if(NoneWithCheck(document.frmChangeProposalInfo.TMorFixed))
{ errormessage += "\n\nPlease click one radio button under TM or Fixed?."; }
// Need to enter validation for two date fields here
if(ValidateDate(document.frmChangeProposalInfo.SentDate))
{ ; }
else
{ errormessage += "\n\nPlease enter a valid SENT DATE. The date format for the SENT DATE is: mm/dd/yyyy"; }

if(ValidateDate(document.frmChangeProposalInfo.AwardDate))
{ ; }
else
{ errormessage += "\n\nPlease enter a valid AWARD DATE. The date format for the AWARD DATE is: mm/dd/yyyy"; }

// Need to enter validation for the Probability field here
if(ValidProb(document.frmChangeProposalInfo.ProbPercent))
{ errormessage += "\n\nPlease enter a valid number in the \"Probability\" field."; }
if(NoneWithCheck(document.frmChangeProposalInfo.SKFOptions))
{ errormessage += "\n\nPlease click one radio button under SKF Option."; }
if(NoneWithCheck(document.frmChangeProposalInfo.Status))
{ errormessage += "\n\nPlease click one radio button under Status."; }

// Need to enter validation for date field here
if(ValidateDate(document.frmChangeProposalInfo.AwardDate))
{ ; }
else
{ errormessage += "\n\nPlease enter a valid AWARD DATE. The date format for the AWARD DATE is: mm/dd/yyyy"; }

// Put field checks above this point.
if(errormessage.length > 2) {
alert('NOTE:' + errormessage);
return false;
}
return true;
}
// end of function CheckRequiredFields()


function WithoutContent(ss) {
if(ss.length > 0) { return false; }
return true;
}

//function NoneWithContent(ss) {
//for(var i = 0; i < ss.length; i++) {
// if(ss[i].value.length > 0) { return false; }
// }
//return true;
//}

function NoneWithCheck(ss) {
for(var i = 0; i < ss.length; i++) {
if(ss[i].checked) { return false; }
}
return true;
}

//function WithoutCheck(ss) {
//if(ss.checked) { return false; }
//return true;
//}

function WithoutSelectionValue(ss) {
for(var i = 0; i < ss.length; i++) {
if(ss[i].selected) {
if(ss[i].value.length) { return false; }
}
}
return true;
}

// Validation test area

function ValidNumber(ss){

var digits="0123456789"
var temp

if (ss.value=="") {
return true
}
for (var i=0;i<ss.value.length;i++){
temp=ss.value.substring(i,i+1)
if (digits.indexOf(temp)==-1){
return true
}
}
return false;
}

function ValidProb(ss){

var digits="0123456789"
var temp

if (ss.value=="") {
return true
}
for (var i=0;i<ss.value.length;i++){
temp=ss.value.substring(i,i+1)
if (digits.indexOf(temp)==-1){
return true
}
if (ss.value>100){
return true
}
}
return false;
}

//-->
// Date Validation Function Test Area
/**
* DHTML date validation script. Courtesy of SmartWebby.com (http://www.smartwebby.com/dhtml/)
*/
// Declaring valid date character, minimum year and maximum year
var dtCh= "/";
var minYear=1900;
var maxYear=2100;

function isInteger(s){
var i;
for (i = 0; i < s.length; i++){
// Check that current character is number.
var c = s.charAt(i);
if (((c < "0") || (c > "9"))) return false;
}
// All characters are numbers.
return true;
}

function stripCharsInBag(s, bag){
var i;
var returnString = "";
// Search through string's characters one by one.
// If character is not in bag, append to returnString.
for (i = 0; i < s.length; i++){
var c = s.charAt(i);
if (bag.indexOf© == -1) returnString += c;
}
return returnString;
}

function daysInFebruary (year){
// February has 29 days in any year evenly divisible by four,
// EXCEPT for centurial years which are not also divisible by 400.
return (((year % 4 == 0) && ( (!(year % 100 == 0)) || (year % 400 == 0))) ? 29 : 28 );
}
function DaysArray(n) {
for (var i = 1; i <= n; i++) {
this[i] = 31
if (i==4 || i==6 || i==9 || i==11) {this[i] = 30}
if (i==2) {this[i] = 29}
}
return this
}

function isDate(dtStr){
var daysInMonth = DaysArray(12)
var pos1=dtStr.indexOf(dtCh)
var pos2=dtStr.indexOf(dtCh,pos1+1)
var strMonth=dtStr.substring(0,pos1)
var strDay=dtStr.substring(pos1+1,pos2)
var strYear=dtStr.substring(pos2+1)
strYr=strYear
if (strDay.charAt(0)=="0" && strDay.length>1) strDay=strDay.substring(1)
if (strMonth.charAt(0)=="0" && strMonth.length>1) strMonth=strMonth.substring(1)
for (var i = 1; i <= 3; i++) {
if (strYr.charAt(0)=="0" && strYr.length>1) strYr=strYr.substring(1)
}
month=parseInt(strMonth)
day=parseInt(strDay)
year=parseInt(strYr)
if (pos1==-1 || pos2==-1){
//alert("The date format for the Sent Date and the Award Date should be: mm/dd/yyyy")
return false
}
if (strMonth.length<1 || month<1 || month>12){
//alert("Please enter a valid month for the Sent Date and/or the Award Date")
return false
}
if (strDay.length<1 || day<1 || day>31 || (month==2 && day>daysInFebruary(year)) || day > daysInMonth[month]){
//alert("Please enter a valid day for the Sent Date and/or the Award Date")
return false
}
if (strYear.length != 4 || year==0 || year<minYear || year>maxYear){
//alert("Please enter a valid 4 digit year between "+minYear+" and "+maxYear +" for the Sent Date and the Award Date")
return false
}
if (dtStr.indexOf(dtCh,pos2+1)!=-1 || isInteger(stripCharsInBag(dtStr, dtCh))==false){
//alert("Please enter a valid date for the Sent Date and the Award Date")
return false
}
return true
}

function ValidateDate(ss){
var dt=ss
if (isDate(dt.value)==false){
dt.focus()
return false
}
return true
}

// end validate date test area
//-->
</script>


<title>Update Proposal Information</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="/Styles/Styles.css" rel="stylesheet" type="text/css">
</head>

<body>
<form action="<?php echo $editFormAction; ?>" method="POST" name="frmChangeProposalInfo" id="frmChangeProposalInfo" onSubmit="return CheckRequiredFields()">
<div id="Layer1" style="position:absolute; left:2px; top:3px; width:152px; height:34px; z-index:1;">
<div align="center"><font size="2"><a href="../Switchboard_01.php">Click
Here to Return to the Switchboard</a></font></div>
</div>
<p class="PageHeading">UPDATE PROPOSAL NUMBER INFORMATION</p>
<div align="center">
<table width="753" border="0" cellspacing="2" cellpadding="2">
<!--DWLayoutTable-->
<tr>
<td height="49" valign="top" class="FormLabel">Client Number:</td>
<td colspan="8" valign="middle" class="FormText"><span class="FormLabel"><font size="2"><?php echo $ChangeProposalInfo->Fields('CID'); ?></font></span> - <span class="FormLabel"><font size="2"><?php echo $ChangeProposalInfo->Fields('YRS'); ?></font></span> - <span class="FormLabel"><font size="2"><?php echo $ChangeProposalInfo->Fields('PID'); ?></font></span></td>
</tr>
<tr>
<td width="141" height="49" valign="top" class="FormLabel"> Client Name:</td>
<td colspan="8" align="left" valign="middle"><p class="FormText"><font color="#000066" size="2"><strong><?php echo $ClientList->Fields('ClientName'); ?></strong></font> </p>
</td>
</tr>
<tr>
<td height="32" valign="top" class="FormLabel">Project Title:</td>
<td colspan="8" valign="middle"><input name="Title" type="text" id="Title2" value="<?php echo $ChangeProposalInfo->Fields('Title'); ?>" size="60">
</td>
</tr>
<tr>
<td height="36" valign="top" class="FormLabel">Project Manager:</td>
<td colspan="2" valign="middle"><select name="ProjectMgr" size="1" id="ProjectMgr" title="<?php echo $ChangeProposalInfo->Fields('ProjectMgr'); ?>">
<option value="-1" <?php if (!(strcmp(-1, $ChangeProposalInfo->Fields('ProjectMgr')))) {echo "SELECTED";} ?>>Select
Project Manager</option>
<?php
while(!$ProjectManagers->EOF){
?>
<option value="<?php echo $ProjectManagers->Fields('Initials')?>"<?php if (!(strcmp($ProjectManagers->Fields('Initials'), $ChangeProposalInfo->Fields('ProjectMgr')))) {echo "SELECTED";} ?>><?php echo $ProjectManagers->Fields('EngineerName')?></option>
<?php
$ProjectManagers->MoveNext();
}
$ProjectManagers->MoveFirst();
?>
</select>
</td>
<td width="73" valign="" class="FormLabel">Business Area: </td
>
<td colspan="3" valign="top"><select name="BusinessArea" size="1" id="BusinessArea" title="<?php echo $ChangeProposalInfo->Fields('BusID'); ?>">
<option value="-1" <?php if (!(strcmp(-1, $ChangeProposalInfo->Fields('BusID')))) {echo "SELECTED";} ?>>Select Business Area</option>
<?php
while(!$BusinessArea->EOF){
?>
<option value="<?php echo $BusinessArea->Fields('BusinessArea')?>"<?php if (!(strcmp($BusinessArea->Fields('BusinessArea'), $ChangeProposalInfo->Fields('BusID')))) {echo "SELECTED";} ?>><?php echo $BusinessArea->Fields('BusinessArea')?></option>
<?php
$BusinessArea->MoveNext();
}
$BusinessArea->MoveFirst();
?>
</select>
</td>
<td width="95" valign="middle" nowrap><div align="right"><span class="FormLabel">QA? </span> </div>
</td>
<td width="36" valign="middle"><input name="QA" type="checkbox" id="QA2" value="<?php echo $ChangeProposalInfo->Fields('QA'); ?>">
</td>
</tr>
<tr>
<td height="36" valign="top" class="FormLabel">Data Entered By<br>
(initials only):</td>
<td width="42" valign="middle"> <input name="DataEnteredBy" type="text" id="DataEnteredBy2" value="<?php echo $ChangeProposalInfo->Fields('DataEnteredBy'); ?>" size="6">
</td>
<td width="157">&nbsp;</td>
<td></td>
<td width="87">&nbsp;</td>
<td width="12">&nbsp;</td>
<td width="54">&nbsp;</td>
<td></td>
<td></td>
</tr>
<tr>
<td height="33" colspan="9" valign="top"><hr>
</td>
</tr>
<tr>
<td height="33" valign="middle" class="FormLabel">Amount: </td>
<td colspan="2" valign="middle"> <p>
<input name="Amount" type="text" id="Amount" value="<?php echo $ChangeProposalInfo->Fields('Amount'); ?>" size="12">
</p></td>
<td colspan="3" rowspan="2" valign="top" bordercolor="#990033" class="FormLabel"><p><u>TM
or Fixed?</u> </p> <p align="left">
<label>
<input <?php if (!(strcmp($ChangeProposalInfo->Fields('TMorFixed'),"1"))) {echo "CHECKED";} ?> type="radio" name="TMorFixed" value="1">
Time and Materials</label>
<br>
<label>
<input <?php if (!(strcmp($ChangeProposalInfo->Fields('TMorFixed'),"2"))) {echo "CHECKED";} ?> type="radio" name="TMorFixed" value="2">
Fixed Price</label>
<br>
</p>
</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td height="39"></td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td></td>
<td></td>
</tr>
<tr>
<td height="28" colspan="9" valign="top"><hr>
</td>
</tr>
<tr>
<td height="34" valign="top" class="FormLabel">Date Proposal Sent (mm/dd/yyyy):</td>
<td colspan="2" valign="middle"><input name="SentDate" type="text" id="SentDate2" value="<?php echo $ChangeProposalInfo->Fields('Sdate'); ?>">
</td>
<td colspan="2" rowspan="3" valign="top" class="FormLabel"><p><u> SKF Option</u></p> <p align="left">
<label>
<input <?php if (!(strcmp($ChangeProposalInfo->Fields('SFKOptions'),"1"))) {echo "CHECKED";} ?> type="radio" name="SKFOptions" value="1">
SKF Client</label>
<br>
<label>
<input <?php if (!(strcmp($ChangeProposalInfo->Fields('SFKOptions'),"2"))) {echo "CHECKED";} ?> type="radio" name="SKFOptions" value="2">
SKF Internal</label>
<br>
<label>
<input <?php if (!(strcmp($ChangeProposalInfo->Fields('SFKOptions'),"3"))) {echo "CHECKED";} ?> type="radio" name="SKFOptions" value="3">
SKF Referral</label>
<br>
<label>
<input <?php if (!(strcmp($ChangeProposalInfo->Fields('SFKOptions'),"4"))) {echo "CHECKED";} ?> type="radio" name="SKFOptions" value="4">
Not Applicable</label>
<br>
</p>
</td>
<td colspan="4" rowspan="3" valign="top" class="FormLabel"><p><u>Status
as of:
<input name="StatusDate" type="text" id="StatusDate" value="<?php echo $ChangeProposalInfo->Fields('Statdate'); ?>">
</u></p> <p align="left">
<label>
<input <?php if (!(strcmp($ChangeProposalInfo->Fields('Outcome'),"1"))) {echo "CHECKED";} ?> type="radio" name="Status" value="1">
Active</label>
<br>
<label>
<input name="Status" type="radio" value="2" <?php if (!(strcmp($ChangeProposalInfo->Fields('Outcome'),"2"))) {echo "CHECKED";} ?>>
Won</label>
<br>
<label>
<input <?php if (!(strcmp($ChangeProposalInfo->Fields('Outcome'),"3"))) {echo "CHECKED";} ?> type="radio" name="Status" value="3">
Lost</label>
<br>
<label>
<input <?php if (!(strcmp($ChangeProposalInfo->Fields('Outcome'),"4"))) {echo "CHECKED";} ?> type="radio" name="Status" value="4">
Cancelled</label>
<br>
</p>
</td>
</tr>
<tr>
<td height="64" valign="top" class="FormLabel"><p>Anticipated<br>
Award Date<br>
(mm/dd/yyyy): </p>
</td>
<td colspan="2" valign="middle"><u>
<input name="AwardDate" type="text" id="AwardDate" value="<?php echo $ChangeProposalInfo->Fields('Adate'); ?>">
</u> </td>
</tr>
<tr>
<td height="34" valign="top" class="FormLabel">Probability (%):</td>
<td colspan="2" valign="middle"><input name="ProbPercent" type="text" id="ProbPercent2" value="<?php echo $ChangeProposalInfo->Fields('ProbPercent'); ?>">
</td>
</tr>
</table>
</div>
<p align="center">
<input name="Submit" type="submit" value="Submit">
</p>
<p align="center">&nbsp;</p>
<div align="center">
<input type="hidden" name="MM_update" value="frmChangeProposalInfo">
</div>
</form>
</body>
</html>
<?php
$ChangeProposalInfo->Close();

$ProjectManagers->Close();

$BusinessArea->Close();

$ClientList->Close();
?>





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users