<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"; }