<?
include "./auth.inc.php";
include "./mysql.inc.php";
?>
<html>
<head>
<title>Add NewUser Form</title>
<script>
<?
$rsql="SELECT DealerID, DealerName, JoiningFee FROM Dealer ORDER BY DealerName";
$rresult=mysql_query($rsql);
print "dj=new Array(".mysql_num_rows($rresult).")\n";
while ($rrow=mysql_fetch_row($rresult)){
$jf=$rrow[2]*1.1;
$i++;
#print "dj[$rrow[0]]=\"$jf\";\n";
print "dj[$i]=\"$jf\";\n";
}
?>
function join()
{
//document.addnew.JoiningFee.value=dj[document.addnew.Reseller.value];
document.addnew.JoiningFee.value=dj[document.addnew.Reseller.selectedIndex];
//document.addnew.FirstName.value='testingjs';
//document.addnew.JoiningFee.value="2000";
}
</script>
</head>
<body bgcolor="#FFFFFF">
<p><font color="#000000" size="4">Add New User Form</font></p>
<form name="addnew" method="POST" action="submituser.php">
<table border=0 width=95%><TR><TD>
<table border="0">
<tr>
<td bgcolor="#FF8080">First Name</td>
<td bgcolor="#FF8080"><input type="text" size="20"
name="FirstName"></td>
</tr>
<tr>
<td bgcolor="#FF8080">Last Name</td>
<td bgcolor="#FF8080"><input type="text" size="20"
name="LastName"></td>
</tr>
<tr>
<td bgcolor="#ACACFF">Address</td>
<td bgcolor="#ACACFF"><input type="text" size="20"
name="Address"></td>
</tr>
<tr>
<td bgcolor="#ACACFF">Suburb</td>
<td bgcolor="#ACACFF"><input type="text" size="20"
name="Suburb"></td>
</tr>
<tr>
<td bgcolor="#ACACFF">State</td>
<td bgcolor="#ACACFF"><input type="text" size="3"
name="State" value="SA"></td>
</tr>
<tr>
<td bgcolor="#ACACFF">Postcode</td>
<td bgcolor="#ACACFF"><input type="text" size="4"
name="Postcode"></td>
</tr>
</table></TD>
<TD><table border="0">
<tr>
<td bgcolor="#ACFF80">Phone Home</td>
<td bgcolor="#ACFF80"><input type="text" size="20"
name="PhoneHome"></td>
</tr>
<tr>
<td bgcolor="#ACFF80">Phone Work</td>
<td bgcolor="#ACFF80"><input type="text" size="20"
name="PhoneWork"></td>
</tr>
<tr>
<td bgcolor="#ACFF80">Phone Mobile</td>
<td bgcolor="#ACFF80"><input type="text" size="20"
name="PhoneMobile"></td>
</tr>
<tr>
<td bgcolor="#ACFF80">Fax Number</td>
<td bgcolor="#ACFF80"><input type="text" size="20"
name="PhoneFax"></td>
</tr>
<tr>
<td bgcolor="#FFAC80">Start Date</td>
<TD bgcolor="#FFAC80"><input type="text" size="20"
name="StartDate" value="<? echo date("Y-m-d"); ?>"></td></tr>
<TR>
<td bgcolor="#FFAC80">Expire Date</td>
<td bgcolor="#FFAC80"><input type="text" size="20"
name="ExpireDate"></td>
</tr>
</table></TD></TR></table>
<p><br>
<table border=0>
<tr><td>Credit Card Number </td><TD><input type=text size=20
name="CreditCardNumbor"></td><TD>Expire Date</td><TD><input type=text
size=5 name="creditcardexpdate"> MM/YY</td> </tr>
<TR>
<td>Credit Card Name</td><TD><input name="CreditCardName" type="text" size="20"></td>
</tr>
</table>
<table border="0">
<tr>
<td>Account Type</td>
<td><select name="AccountType" size="1">
<option value="(None)">(None)</option>
<?
$plt="SELECT PlanID,PlanName,Cost FROM PlanTypes";
$plres=mysql_query($plt);
while ($plrow=mysql_fetch_row($plres)){
$cost = number_format($plrow[2]*1.1,2);
echo "<option value=\"$plrow[0]\">$plrow[1] (\$$cost)</option>";
}
?>
<option value="dealerspecial">Dealer Special 200 Hours</option>
</select></td>
<td>Payment Type</td>
<td><select name="paytype" size="1">
<? $ptsql="SELECT PaymentTypeName FROM PaymentTypes";
$ptres=mysql_query($ptsql);
while ($ptrow=mysql_fetch_row($ptres)){
echo "<option>$ptrow[0]</option>";
}
?>
</select></td>
</TR>
<TR>
<TD>Reseller</TD><TD><SELECT NAME="Reseller" onchange="join()"><Option></option><?
#$rsql="SELECT DealerID, DealerName, JoiningFee FROM Dealer ORDER BY DealerName";
# $rresult=mysql_query($rsql);
mysql_data_seek($rresult,0);
while ($rrow=mysql_fetch_row($rresult)){
print "<option value=\"$rrow[0]\">$rrow[1]</option>\n";
}
?></select></TD><TD>Joining Fee: $</TD><TD><INPUT TYPE=TEXT SIZE=4
VALUE="0" Name="JoiningFee"> (Include GST)</TD>
</TR>
<TR><TD>VISP</TD><TD><?
#VISP option
include "./visp.inc.php";
?>
</td>
<td>Plan Cost Override: $</td>
</TD><TD><INPUT TYPE=TEXT SIZE=4 VALUE="" Name="CostOverride"> (Include GST)</TD>
</tr>
<tr>
<td bgcolor=#BBBBBB>UserName</td>
<td bgcolor=#BBBBBB><input type="text" name="username" size="20"></td>
<td bgcolor=#BBBBBB>Password</td>
<td bgcolor=#BBBBBB><input type="text" name="password" size="20"></td>
</tr>
</table>
<BR>
<table><TR><TD>Comment</TD><TD COLSPAN=2><Input type="text" size="65" name="comments" value=" "></td></TR>
</table>
<p><br>
<input type="reset" name="B2" value="Reset"><input type="submit"
name="B1" value="Next >>"></p>
</form>
</body>
</html>