<td align="left"><textarea name="comments" style="width:200; height:75;"></textarea></td>
</tr>
<tr><td colspan="2" align="center"><input type="submit" name="submit" value="Submit" style="width:100;"></td></tr></form>
</table>
<?php
}
CloseTable();
}
// Check to see if the user is logged in or not, if not then redirect the user to the login page
if (!is_user($user)) {
header("Location: modules.php?name=Your_Account");
} else {
switch ($_GET['op']) {
case 'ViewPaid':
ViewPaid();
break;
case 'ViewUnpaid':
ViewUnpaid();
break;
case 'Cancel':
CancelReq();
break;
case 'ViewInvoice':
ViewInvoice();
break;
default:
ViewUnpaid();
break;
}
}
include "footer.php";
function EditInvoice()
{
global $db, $prefix;
if (isset($_POST['submit'])) {
// Update the invoice details
$sql = "UPDATE " . $prefix . "_hosting_accounting SET duedate = '" . mktime(11, 59, 59, $_POST['month'], $_POST['date'], $_POST['year']) . "',\r\n\t\t\tuid = '" . $_POST['user_id'] . "' WHERE id='" . $_GET['id'] . "'";
if ($db->sql_query($sql)) {
header("Location: " . $_SERVER['PHP_SELF'] . "?op=Accounting&action=ViewUnPaid");
} else {
echo "Error: This could not be done.";
}
} else {
DoHead();
$sql = "SELECT uid, total, duedate FROM " . $prefix . "_hosting_accounting WHERE id='" . $_GET['id'] . "'";
$row = $db->sql_fetchrow($db->sql_query($sql));
$due_month = date("m", $row['duedate']);
$due_date = date("d", $row['duedate']);
$due_year = date("y", $row['duedate']);
?>
<center>
<form method="post">
<br><table width="100%" border="1" style="border-collapse: collapse" cellpadding="0" cellspacing="0"><tr><td>
<table width="100%" cellpadding="0">
<tr>
<td align="right">Invoice ID: </td>
<td align="left"><?php
echo $_GET['id'];
?>
</td>
</tr><tr>
<td align="right" >Assign to User: </td><td align="left"><select name="user_id" style="width:200">
<?php
$result2 = $db->sql_query("SELECT user_id, username FROM " . $prefix . "_users ORDER BY username");
while ($row2 = $db->sql_fetchrow($result2)) {
?>
<option <?php
if ($row2['user_id'] == $row['uid']) {
echo " selected ";
}
?>
value="<?php
echo $row2['user_id'];
?>
"><?php
echo $row2['username'];
?>
</option>
<?php
}
?>
</select></td>
</tr><tr>
<td align="right" >Payment Due Date: </td>
<td align="left">
<select name="month">
<option <?php
if ($due_month == 1) {
echo " selected ";
}
?>
value="1">January</option>
<option <?php
if ($due_month == 2) {
echo " selected ";
}
?>
value="2">February</option>
<option <?php
if ($due_month == 3) {
echo " selected ";
}
?>
value="3">March</option>
<option <?php
if ($due_month == 4) {
echo " selected ";
}
?>
value="4">April</option>
<option <?php
if ($due_month == 5) {
echo " selected ";
}
?>
value="5">May</option>
<option <?php
if ($due_month == 6) {
echo " selected ";
}
?>
value="6">June</option>
<option <?php
if ($due_month == 7) {
echo " selected ";
}
?>
value="7">July</option>
<option <?php
if ($due_month == 8) {
echo " selected ";
}
?>
value="8">August</option>
<option <?php
if ($due_month == 9) {
echo " selected ";
}
?>
value="9">September</option>
<option <?php
if ($due_month == 10) {
echo " selected ";
}
?>
value="10">October</option>
<option <?php
if ($due_month == 11) {
echo " selected ";
}
?>
value="11">November</option>
<option <?php
if ($due_month == 12) {
echo " selected ";
}
?>
value="12">December</option>
</select> -
<select name="date">
<option <?php
if ($due_date == 1) {
echo " selected ";
}
?>
value="1">1</option>
<option <?php
if ($due_date == 2) {
echo " selected ";
}
?>
value="2">2</option>
<option <?php
if ($due_date == 3) {
echo " selected ";
}
?>
value="3">3</option>
<option <?php
if ($due_date == 4) {
echo " selected ";
}
?>
value="4">4</option>
<option <?php
if ($due_date == 5) {
echo " selected ";
}
?>
value="5">5</option>
<option <?php
if ($due_date == 6) {
echo " selected ";
}
?>
value="6">6</option>
<option <?php
if ($due_date == 7) {
echo " selected ";
}
?>
value="7">7</option>
<option <?php
if ($due_date == 8) {
echo " selected ";
}
?>
value="8">8</option>
<option <?php
if ($due_date == 9) {
echo " selected ";
}
?>
value="9">9</option>
<option <?php
if ($due_date == 10) {
echo " selected ";
}
?>
value="10">10</option>
<option <?php
if ($due_date == 11) {
echo " selected ";
}
?>
value="11">11</option>
<option <?php
if ($due_date == 12) {
echo " selected ";
}
?>
value="12">12</option>
<option <?php
if ($due_date == 13) {
echo " selected ";
}
?>
value="13">13</option>
<option <?php
if ($due_date == 14) {
echo " selected ";
}
?>
value="14">14</option>
<option <?php
if ($due_date == 15) {
echo " selected ";
}
?>
value="15">15</option>
<option <?php
if ($due_date == 16) {
echo " selected ";
}
?>
value="16">16</option>
<option <?php
if ($due_date == 17) {
echo " selected ";
}
?>
value="17">17</option>
<option <?php
if ($due_date == 18) {
echo " selected ";
}
?>
value="18">18</option>
<option <?php
if ($due_date == 19) {
echo " selected ";
}
?>
value="19">19</option>
<option <?php
if ($due_date == 20) {
echo " selected ";
}
?>
value="20">20</option>
<option <?php
if ($due_date == 21) {
echo " selected ";
}
?>
value="21">21</option>
<option <?php
if ($due_date == 22) {
echo " selected ";
}
?>
value="22">22</option>
<option <?php
if ($due_date == 23) {
echo " selected ";
}
?>
value="23">23</option>
<option <?php
if ($due_date == 24) {
echo " selected ";
}
?>
value="24">24</option>
<option <?php
if ($due_date == 25) {
echo " selected ";
}
?>
value="25">25</option>
<option <?php
if ($due_date == 26) {
echo " selected ";
}
?>
value="26">26</option>
<option <?php
if ($due_date == 27) {
echo " selected ";
}
?>
value="27">27</option>
<option <?php
if ($due_date == 28) {
echo " selected ";
}
?>
value="28">28</option>
<option <?php
if ($due_date == 29) {
echo " selected ";
}
?>
value="29">29</option>
<option <?php
if ($due_date == 30) {
echo " selected ";
}
?>
value="30">30</option>
<option <?php
if ($due_date == 31) {
echo " selected ";
}
?>
value="31">31</option>
</select> -
<select name="year">
<option value="<?php
echo $due_year - 1;
?>
"><?php
echo $due_year - 1;
?>
</option>
<option selected value="<?php
echo $due_year;
?>
"><?php
echo $due_year;
?>
</option>
<option value="<?php
echo $due_year + 1;
?>
"><?php
echo $due_year + 1;
?>
</option>
<option value="<?php
echo $due_year + 2;
?>
"><?php
echo $due_year + 2;
?>
</option>
<option value="<?php
echo $due_year + 3;
?>
"><?php
echo $due_year + 3;
?>
</option>
</select>
</td>
</tr><tr>
<td align="center" colspan="2"><input type="submit" name="submit" value="Save" style="width:75;"></td>
</tr>
</table></td></tr></table>
</form></center>
<?php
ViewInvoice();
}
CloseTable();
include "footer.php";
}
