?> </span><p> <div class="hr"></div> <?php //Overdue Sum $past = future_past("-", "721"); benfund_connect(); $odquery = "SELECT SUM(total) AS paytotal FROM invoice WHERE date <= {$past} AND to_id='{$cid}' AND status='0'"; $odresult = mysql_query($odquery) or die(mysql_error()); $odrow = mysql_fetch_array($odresult); $odnum_pend = mysql_num_rows($odresult); $overdue = (int) $odrow['paytotal']; //echo 'This '.$balance.' is the Total Payments.' //Current $to_now = future_past("-", "720"); benfund_connect(); $curquery = "SELECT SUM(total) AS paytotal FROM invoice WHERE date >= {$to_now} AND to_id='{$cid}' AND status='0'"; $curresult = mysql_query($curquery) or die(mysql_error()); $currow = mysql_fetch_array($curresult); $curnum_pend = mysql_num_rows($curresult); $curbalance = (int) $currow['paytotal']; ?> <?php $userquery = "SELECT name, contact_name, goal FROM merchant WHERE id='{$mid}'"; $userresult = mysql_query($userquery) or die(mysql_error()); $userrow = mysql_fetch_row($userresult); $mname = $userrow[0]; $c_name = $userrow[1]; $total = (int) $userrow[2];
The following are invoices from 90 to 120 days ago. To view invoices older than 120 days click on the 'Archive' tab. <table class="tablesorter" id="invman90" align="center" border="0" cellpadding="4" cellspacing="0" width="95%"> <thead> <tr> <th valign="top" width="50" ><a href="#"><b>Inv#</b></a></th> <th valign="top" width="400" ><a href="#"><b>Client</b></a></th> <th valign="top" width="40" ><a href="#"><b>Amount</b></a></th> <th valign="top" width="50" ><a href="#"><b>Date</b></a></th> <th valign="top" width="30" ><a href="#"><b>Status</b></a></th> </tr> </thead> <tbody> <?php benfund_connect(); $back = future_past("-", 2880); $front = future_past("-", 2161); $query = "SELECT * FROM invoice WHERE date BETWEEN {$back} AND {$front} AND from_id='{$mid}' ORDER BY id DESC"; $result = mysql_query($query); $color1 = "row0"; $color2 = "row1"; $row_count = 0; while ($row = mysql_fetch_array($result)) { if ($result) { $id = $row[0]; $inv = $row[1]; $to = $row[2]; $total = $row['total']; $status = $row['status']; if ($status == 0) { $condition = '<span class="true">Paid</span>'; }
</tr> </table> <div id="datatable"> <table class="sortable-onload-1-reverse no-arrow paginate-5" id="jukejoint" align="center" border="0" cellpadding="4" cellspacing="0" width="95%"> <tr> <th valign="top" width="50" class="sortable"><b>Inv#</b></th> <th valign="top" width="400" class="sortable"><b>Type</b></th> <th valign="top" width="60" class="sortable"><b>Amount</b></th> <th valign="top" width="60" class="sortable"><b>Status</b></th> <th valign="top" width="50" class="sortable"><b>Date</b></th> <th valign="top" width="20">View</th> </tr> <?php benfund_connect(); $past = future_past("-", 1140); $now = future_past("-", 720); $query = "SELECT * FROM payments WHERE from_id='{$cid}' ORDER BY id DESC"; $result = mysql_query($query); $color1 = "row0"; $color2 = "row1"; $row_count = 0; while ($row = mysql_fetch_array($result)) { $iid = $row[0]; $type = $row[1]; if ($type == 1) { $type = '<span class="bold red">Payment</span>'; } elseif ($type == 2) { $type = '<span class="bold blue">Invoice</span>'; } elseif ($type == 3) { $type = '<span class="bold green">Credit</span>'; }
</tr> </table> <table class="tablesorter" id="invmanrec" align="center" border="0" cellpadding="4" cellspacing="0" width="95%"> <thead> <tr> <th valign="top" width="50" ><a href="#"><b>Inv#</b></a></th> <th valign="top" width="400" ><a href="#"><b>Client</b></a></th> <th valign="top" width="40" ><a href="#"><b>Amount</b></a></th> <th valign="top" width="50" ><a href="#"><b>Date</b></a></th> <th valign="top" width="30" ><a href="#"><b>Status</b></a></th> </tr> </thead> <tbody> <?php benfund_connect(); $back = future_past("-", 720); $front = datetime(); $query = "SELECT * FROM invoice WHERE from_id='{$mid}' ORDER BY id DESC"; //$query = "SELECT * FROM invoice WHERE date BETWEEN $back AND $front AND from_id='$mid' ORDER BY id DESC"; $result = mysql_query($query); $color1 = "row0"; $color2 = "row1"; $row_count = 0; while ($row = mysql_fetch_array($result)) { if ($result) { $id = $row[0]; $inv = $row[1]; $to = $row[2]; $total = $row['total']; $status = $row['status']; if ($status == 0) {
<!--PATHWAY END--> <!--MAINBODY START--> <?php if ($m_type == 1) { m_menu1(); } if ($m_type == 2) { m_menu2(); } ?> <div class="content_outer"> <div class="content_inner"> <span class="pagetitle">Client Information</span><p> <div class="hr"></div> <?php future_past("-", "720"); ?> <table class="clear"> <tr><td> <table class="toolbar" align="right"> <tr> <td align="center"><a class="toolbar" href="#" onclick="document.editclient.submit();"><img src="https://www.benfund.com/images/elements/icons/save.png" border="0"/><br />Save Changes</a></td> <td align="center"><a class="toolbar" href="https://www.benfund.com/acct/new_invoice.php?id=<?php echo $cid; ?> "><img src="https://www.benfund.com/images/elements/icons/invoice-send.png" border="0"/><br />Send Invoice</a></td> <td align="center"><a class="toolbar" href="https://www.benfund.com/acct/message_center.php?view=compose&id=<?php echo $cid; ?> "><img src="https://www.benfund.com/images/elements/icons/mail-compose.png" border="0"/><br />Send Message</a></td> <td align="center"><a class="toolbar" href="https://www.benfund.com/acct/client_manager.php"><img src="https://www.benfund.com/images/elements/icons/cancel.gif" border="0"/><br />Cancel</a></td>
<table class="tablesorter" id="finman60" align="center" border="0" cellpadding="4" cellspacing="0" width="95%"> <thead> <tr> <th valign="top" width="50"><b>#</b></th> <th valign="top" width="400"><b>Type</b></th> <th valign="top" width="400"><b>Client</b></th> <th valign="top" width="60"><b>Amount</b></th> <th valign="top" width="50"><b>Date</b></th> <th valign="top" width="20">Status</th> </tr> </thead> <tbody> <?php $back = future_past("-", 2160); $front = future_past("-", 1141); benfund_connect(); $query = "SELECT * FROM transactions WHERE date BETWEEN {$back} AND {$front} AND from_id='{$mid}' OR to_id='{$mid}' ORDER BY id DESC"; echo $query; $result = mysql_query($query); $color1 = "row0"; $color2 = "row1"; $row_count = 0; while ($row = mysql_fetch_array($result)) { if ($result) { $iid = $row[0]; $type = $row[1]; if ($type == 1) { $type = '<span class="bold red">Payment</span>'; } elseif ($type == 2) { $type = '<span class="bold blue">Invoice</span>';
</tr> </table> <div id="datatable"> <table class="sortable-onload-1-reverse no-arrow paginate-5" id="jukejoint" align="center" border="0" cellpadding="4" cellspacing="0" width="95%"> <tr> <th valign="top" width="50" class="sortable"><b>Inv#</b></th> <th valign="top" width="400" class="sortable"><b>Type</b></th> <th valign="top" width="60" class="sortable"><b>Amount</b></th> <th valign="top" width="60" class="sortable"><b>Status</b></th> <th valign="top" width="50" class="sortable"><b>Date</b></th> <th valign="top" width="20">View</th> </tr> <?php benfund_connect(); $back = future_past("-", 1140); $front = future_past("-", 720); $query = "SELECT * FROM transactions WHERE date BETWEEN {$back} AND {$front} AND to_id='{$cid}' OR from_id='{$cid}' ORDER BY id DESC"; $result = mysql_query($query); $color1 = "row0"; $color2 = "row1"; $row_count = 0; while ($row = mysql_fetch_array($result)) { $iid = $row[0]; $type = $row[1]; if ($type == 1) { $type = '<span class="bold red">Payment</span>'; } elseif ($type == 2) { $type = '<span class="bold blue">Invoice</span>'; } elseif ($type == 3) { $type = '<span class="bold green">Credit</span>'; }
require_once $ROOT . "/functions/common.php"; //require_once('../../functions/common.php'); //$mid = '617428'; ?> <table class="sortable" id="omfug" align="center" border="0" cellpadding="4" cellspacing="0" width="95%"> <tr> <th valign="top" width="50"><b>Inv#</b></th> <th valign="top" width="400"><b>Client</b></th> <th valign="top" width="60"><b>Amount</b></th> <th valign="top" width="50"><b>Date</b></th> <th valign="top" width="20">Status</th> </tr> <?php benfund_connect(); $back = future_past("-", $_REQUEST['b']); $front = future_past("-", $_REQUEST['f']); $query = "SELECT * FROM invoice WHERE date BETWEEN {$back} AND {$front} AND from_id='{$mid}' ORDER BY id DESC"; $result = mysql_query($query); echo $query; $color1 = "row0"; $color2 = "row1"; $row_count = 0; while ($row = mysql_fetch_array($result)) { $id = $row[0]; $inv = $row[1]; $to = $row[2]; $total = $row['total']; benfund_connect(); $c_result = mysql_query("SELECT first_name, last_name FROM client WHERE cid='{$to}'"); $c_row = mysql_fetch_array($c_result) or die(mysql_error()); $cname = $c_row['first_name'];