?>
</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'];