<?
include "./auth.inc.php";
include "./hms.inc.php";
if (!$ID)
$ID=$CustomerID;
$sql="SELECT *, UNIX_TIMESTAMP(ExpireDate) as uExpireDate FROM MasterAccounts WHERE CustomerID=$ID";
if ($result=mysql_query($sql)){;
$row=mysql_fetch_array($result);
$rsql="SELECT resellername FROM resellers WHERE resellerID='$row[Reseller]'";
$rres=mysql_query($rsql);
if ($rres)
$reseller=mysql_fetch_row($rres);
$vsql="SELECT VISPID, VISPName FROM VISP";
$vres=mysql_query($vsql);
$ssql="SELECT AccountID, Login, AccountType FROM SubAccounts WHERE
CustomerID=$ID ORDER BY IsPrimary DESC,AccountID";
$sres=mysql_query($ssql);
print mysql_error();
#$srow=mysql_fetch_array($sres);
if ($row[Reseller]){
$dsql="SELECT DealerName FROM Dealer WHERE DealerID=$row[Reseller]";
$dres=mysql_query($dsql);
$drow=mysql_fetch_row($dres);
$dealername = $drow[0];
}
}
?>
<html>
<head>
<title>Accounting</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
//<!--
td { font-family: Arial, Helvetica, sans-serif; font-size: 10pt; font-style: normal; line-height: normal; font-weight: bold; color: #FFFFFF; text-decoration: none}
P { font-family: Arial, Helvetica, sans-serif; font-size: 10pt; font-style: normal; line-height: normal; font-weight: bold; color: #FFFFFF; text-decoration: none}
//-->
</style>
</head>
<body bgcolor="#FFFFFF" link=#FFFFFF vlink=#FFFFFF background="images/bg2.jpg">
<P>SubAccounts:
<?
if ($reseller){
while ($srow = mysql_fetch_array($sres)){
if (!$i)
$primaryaccttype=$srow[AccountType];
$i++;
print "<A HREF=\"subedit.php?ID=$srow[AccountID]\">$srow[Login]</A>, ";
}
print " Primary is <B>$primaryaccttype</B> ";
if ($dealername)
print "Dealer is <B>$dealername</B>";
}
?></P>
<form method="post" action="editadd.php">
<table width="69%" border="0">
<tr>
<td width="51%" valign="top"><img src="images/top2.gif" width="297"
height="22"><br>
<table width="297" border="0" cellspacing="0" cellpadding="4" bgcolor="#000031">
<tr>
<td width="41%" height="16"><font color="#FFFFCC"><b>First Name</b></font></td>
<td width="59%" height="16">
<div align="right">
<input type=text name="FirstName" value="<? echo $row[FirstName] ?>" maxlength=30>
</div>
</td>
</tr>
<tr>
<td width="41%" height="21"><font color="#FFFFCC"><b>Last Name</b></font></td>
<td width="59%" height="21">
<div align="right">
<input type=text name="LastName" value="<? echo $row[LastName] ?>" maxlength=40>
</div>
</td>
</tr>
<tr>
<td width="41%" height="19"><font color="#FFFFFF">Company</font></td>
<td width="59%" height="19">
<div align="right">
<input type=text name="Company" value="<? echo $row[Company] ?>" maxlength=40>
</div>
</td>
</tr>
<tr>
<td width="41%" height="19"><font color="#FFFFFF">ABN</font></td>
<td width="59%" height="19">
<div align="right">
<input type=text name="ABN" value="<? echo $row[ABN] ?>" maxlength=40>
</div>
</td>
</tr>
<tr>
<td width="41%" height="21"><font color="#FFFFFF">Address</font></td>
<td width="59%" height="21">
<div align="right">
<input type=text name="Address" value="<? echo $row[Address] ?>">
</div>
</td>
</tr>
<tr>
<td width="41%" height="18"><font color="#FFFFFF">Suburb</font></td>
<td width="59%" height="18">
<div align="right">
<input type=text name="Suburb" value="<? echo $row[Suburb] ?>" maxlength=20>
</div>
</td>
</tr>
<tr>
<td width="41%" height="13"><font color="#FFFFFF">State</font></td>
<td width="59%" height="13">
<div align="right">
<input type=text name="State" value="<? echo $row[State] ?>" maxlength=4>
</div>
</td>
</tr>
<tr>
<td width="41%" height="22"><font color="#FFFFFF">Postcode</font></td>
<td width="59%" height="22">
<div align="right">
<input type=text name="Postcode" value="<? echo $row[Postcode] ?>" maxlength=6>
</div>
</td>
</tr>
<tr>
<td width="41%" height="2"><font color="#FFFFCC"><b>Phone Home</b></font></td>
<td width="59%" height="2">
<div align="right">
<input type=text name="PhoneHome" value="<? echo $row[PhoneHome] ?>" maxlength=15>
</div>
</td>
</tr>
<tr>
<td width="41%" height="16"><font color="#FFFFFF">Phone Work</font></td>
<td width="59%" height="16">
<div align="right">
<input type=text name="PhoneWork" value="<? echo $row[PhoneWork] ?>" maxlength=15>
</div>
</td>
</tr>
<tr>
<td height="13" width="41%"><font color="#FFFFFF">Phone Mobile</font></td>
<td height="13" width="59%">
<div align="right">
<input type=text name="PhoneMobile" value="<? echo $row[PhoneMobile] ?>" maxlength=15>
</div>
</td>
</tr>
<tr>
<td height="2" width="41%"><font color="#FFFFFF">Facsimile</font></td>
<td height="2" width="59%">
<div align="right">
<input type=text name="PhoneFax" value="<? echo $row[PhoneFax] ?>" maxlength=15>
</div>
</td>
</tr>
<tr>
<td height="27" width="41%"><font color="#FFFFFF">Email Address</font></td>
<td height="27" width="59%">
<div align="right">
<input type=text name="ContactEmail" value="<? echo $row[ContactEmail] ?>" maxlength=40>
</div>
</td>
</tr>
</table>
<table width="297" border="0" cellspacing="0" cellpadding="4" bgcolor="#000031">
<tr>
<td width="51%" height="16"> </td>
<td width="49%" height="16"> </td>
</tr>
<tr>
<td width="51%" height="21"><font color="#FFFFCC"><b>Credit Card No.</b></font></td>
<td width="49%" height="21">
<input type=text name="CreditCardNumbor" value="<? echo $row[CreditCardNumbor] ?>" maxlength=20>
</td>
</tr>
<tr>
<td width="51%" height="19"><font color="#FFFFCC"><b> Card Name</b></font></td>
<td width="49%" height="19">
<div align="right">
<input type=text name="CreditCardName" value="<? echo $row[CreditCardName] ?>" maxlength=20>
</div>
</td>
</tr>
<tr>
<td width="51%" height="19"><font color="#FFFFFF">Credit Card Expiry</font></td>
<td width="49%" height="19">
<div align="right">
<input type=text name="CreditCardExp" value="<? echo $row[CreditCardExp] ?>" maxlength=10>
</div>
</td>
</tr>
<tr>
<td width="51%" height="18"><font color="#FFFFFF">Autobill</font></td>
<td width="49%" height="18">
<div align="right">
<select name="AutoBill">
<?
$absql="SELECT PlanID, PlanName FROM PlanTypes WHERE AccountType='$primaryaccttype' OR PlanID='$row[AutoBill]'";
$abres=mysql_query($absql);
print "<option value=\"00\"";
if (!$row[AutoBill])
print " selected";
print ">(None)</option>\n";
while ($abrow=mysql_fetch_array($abres)){
$pn = $abrow[PlanName];
$pn = ereg_replace("Digital","",$pn);
print "<option value=\"$abrow[PlanID]\"";
if ($row[AutoBill]==$abrow[PlanID])
print " selected";
print ">".substr($pn,0,25)."</option>\n";
}
?>
</select>
</div>
</td>
</tr>
<tr>
<td width="51%" height="13"><font color="#FFFFFF">Dealer</font></td>
<td width="49%" height="13">
<div align="right">
<? if ($dealername){
print $dealername;
if ($row[RecurDealer]){
if ($row[Reseller] == $row[RecurDealer])
print " (Recurring)";
else
print " (Dealer <A HREF=\"dealeredit.php?Dealer=$row[RecurDealer]\">$row[RecurDealer]</A> recur)";
}
}else{
print " ";
} ?>
</div>
</td>
</tr>
<tr>
<td width="51%" height="22"><font color="#FFFFFF">Active</font></td>
<td width="49%" height="22">
<div align="right">
<SELECT Name=Active><?
print "<option value=0";
if (!$row[Active])
print " selected";
print ">False</option>\n";
print "<option value=1";
if ($row[Active])
print " selected";
print ">True</option></SELECT>\n";
?>
</div>
</td>
</tr>
<tr>
<td width="51%" height="22"><font color="#FFFFFF">Supplier</font></td>
<td width="49%" height="22">
<div align="right">
<SELECT Name=Supplier><?
print "<option value=\"00\"";
if (!$row[Supplier])
print " selected";
print ">False</option>\n";
print "<option value=1";
if ($row[Supplier])
print " selected";
print ">True</option></SELECT>\n";
?>
</div>
</td>
</tr>
<tr>
<td width="51%" height="2"> </td>
<td width="49%" height="2">
<div align="right">
<input type="submit" value=" SAVE RECORD " name="submit2">
</div>
</td>
</tr>
</table>
<img src="images/top3.gif" width="297" height="22"> </td>
<td width="49%" valign="top">
<img src="images/top2.gif" width="297" height="22"><br>
<table width="297" border="0" cellspacing="0" cellpadding="04" bgcolor="#000031">
<tr>
<td width="140" height="32"><font color="#FFFFCC"><b>Time Remaining</b></font></td>
<td width="144" height="32"><? echo hhms($row[TimeRemaining]*60); ?></td>
</tr>
<tr>
<td width="140" height="32"><font color="#FFFFCC"><b><? if ((($row[uExpireDate]-86400) > mktime()) || !$row[uExpireDate]){ ?>
<font color="#FFFFCC">
<? }else{ ?>
<font color="#FF0000">
<? } ?>
Expire Date</b></font></td>
<td width="144" height="32"><?
if ($security<90)
print $row[ExpireDate];
else
print "<INPUT TYPE=TEXT NAME=ExpireDate VALUE=\"$row[ExpireDate]\">";
?></td>
</tr>
<tr>
<td width="140">
<? if (($row[TimeRemaining] <
$row[LowCreditPoint])&&$primaryaccttype=='Blocks')
print "<font color=\"#FF0000\">";
else
print "<font color=\"#FFFFFF\">";
?>Mins Remaining</font></td>
<td width="144">
<? if ($security > 90) { ?>
<input type=text name="TimeRemaining" value="<? echo $row[TimeRemaining] ?>"
maxlength=9>
<? }else{
print $row[TimeRemaining];
} ?>
</td>
</tr>
<tr>
<td width="140"><font color="#FFFFFF">Megs Remaining</font></td>
<td width="144">
<div align="right">
<input type=text name="MegsRemaining" value="<? echo $row[MegsRemaining] ?>" maxlength=11>
</div>
</td>
</tr>
<tr>
<td width="140" height="20"><font color="#FFFFFF">Low Credit Point</font></td>
<td width="144" height="20">
<div align="right">
<input type=text name="LowCreditPoint" value="<? echo $row[LowCreditPoint] ?>" maxlength=9>
</div>
</td>
</tr>
<tr>
<td width="140" height="20"><font color="#FFFFFF">Expire Point</font></td>
<td width="144" height="20">
<div align="right">
<input type=text name="ExpirePoint" value="<? echo $row[ExpirePoint] ?>" maxlength=9>
</div>
</td>
</tr>
<tr>
<td height=20><font color="#FFFFFF">Kbyte Quota</font></td>
<td><input type=text name="KByteQuota" value="<? echo
$row[KByteQuota] ?>"></td>
</tr>
<tr>
<td width="140" height="20"><font color="#FFFFFF">Excess Charge</font></td>
<td width="144" height="20">
<div align="right">
<input type=text name="ExcessCharge" value="<? echo $row[ExcessCharge] ?>" maxlength=9>
</div>
</td>
</tr>
<tr>
<td><font color="#FFFFFF">Over Quota Action</font></td>
<td width="144" height="20"><SELECT NAME="QuotaAction"><?
print "<OPTION VALUE=\"00\"";
if ($row[QuotaAction]==0)
print " selected";
print ">Charge Excess</option>\n";
print "<OPTION VALUE=1";
if ($row[QuotaAction]==1)
print " selected";
print ">Deny Access</option>\n";
?></SELECT></TD>
</tr>
<TR><TD colspan=2> </TD></TR>
<tr>
<td width="140" height="20"><font color="#FFFFFF">Computer</font></td>
<td width="144" height="20">
<div align="right">
<input type=text name="ComputerType" value="<? echo $row[ComputerType] ?>" maxlength=20>
</div>
</td>
</tr>
<tr>
<td width="140"><font color="#FFFFFF">Operating System</font></td>
<td width="144">
<div align="right">
<input type=text name="OperatingSystem" value="<? echo $row[OperatingSystem] ?>" maxlength=20>
</div>
</td>
</tr>
<tr>
<td width="140"><font color="#FFFFFF">Modem Type</font></td>
<td width="144">
<div align="right">
<input type=text name="ModemType" value="<? echo $row[ModemType] ?>" maxlength=20>
</div>
</td>
</tr>
<?
if ($row[Browser]){
?>
<tr>
<td width="140"><font color="#FFFFFF">Browser</font></td>
<td width="144">
<div align="right">
<? echo $row[Browser] ?>
</div>
</td>
</tr>
<?
}
?>
<TR><TD colspan=2> </TD></TR>
<tr>
<td width="140">Next Call</td>
<td width="144">
<div align="right">
<input type=text name="NextCall" value="<? echo $row[NextCall] ?>" maxlength=20>
</div>
</td>
</tr>
<tr>
<td width="140">Call Reason</td>
<td width="144">
<div align="right">
<input type=text name="NextCallReason" value="<? echo $row[NextCallReason] ?>" maxlength=20></div>
</td>
</tr>
<tr>
<td width="140"><font color="#FFFFFF">Last Used</font></td>
<td width="144">
<div align="right">
<input type=text name="LastUse" value="<? echo $row[LastUse] ?>" maxlength=19>
</div>
</td>
</tr>
<tr>
<td width="140"><font color="#FFFFFF">Create Date</font></td>
<td width="144">
<div align="right">
<? if ($row[CreateDate])
echo $row[CreateDate];
else
echo ' ';
?>
</div>
</td>
</tr>
<tr>
<td width="140" valign="top"><font color="#FFFFFF">Last Warning</font></td>
<td width="144">
<div align="right">
<input type=text name="LastWarning" value="<? echo $row[LastWarning] ?>" maxlength=10>
</div>
</td>
</tr>
<tr>
<td width="140" valign="top"><font color="#FFFFFF">Visp</font></td>
<td width="144">
<div align="right">
<select name=VISP>
<option value="0"></option>
<?
while ($vrow=mysql_fetch_row($vres)){
echo "<option value=$vrow[0]";
if ($row[VISP]==$vrow[0])
echo " selected";
echo ">$vrow[1]</option>\n";
}
?>
</select>
</div>
</td>
</tr>
<tr>
<td width="140" valign="top" height="7"><font color="#FFFFFF">Web Site</font></td>
<td width="144" height="7">
<div align="right">
<input type=text name="WebSite" value="<? echo $row[WebSite] ?>" maxlength=100>
</div>
</td>
</tr>
<tr>
<td width="140" valign="top"><font color="#FFFFFF">Last Modified</font></td>
<td width="144">
<div align="right">
<input type=text name="Input" value="<? echo $row[LastModifyDate] ?>" maxlength=40>
</div>
</td>
</tr>
<tr>
<td width="140" valign="top"><font color="#FFFFFF">Last Modified By</font></td>
<td width="144">
<div align="right">
<input type=text name="LastModifyUser" value="<? echo $row[LastModifyUser] ?>" maxlength=30>
</div>
</td>
</tr>
<tr>
<td width="140" valign="top"><font color="#FFFFFF">Start Date</font></td>
<td width="144">
<div align="right">
<input type=text name="StartDate" value="<? echo $row[StartDate] ?>">
</div>
</td>
</tr>
</table>
<div align="left"><img src="images/top3.gif" width="297"
height="22"><br>
</div>
<div align="right"></div>
<div align="right"></div>
<div align="right"></div>
</td>
</tr>
</table>
<p> </p>
<p> </p>
</form>
</body>
</html>
