function displayMiddle()
{
if (date("D") == "Mon") {
$interval = "3 DAY";
} else {
$interval = "1 DAY";
}
$whereclause = "clients.creationdate >= DATE_SUB(NOW(),INTERVAL " . $interval . ")\n\t\t\t AND clients.inactive = 0";
include_once "include/search_class.php";
$displayTable = new simpleTable($this->db, "tbld:6d290174-8b73-e199-fe6c-bcf3d4b61083", "rcl");
$displayTable->querywhereclause = $whereclause;
$displayTable->issueQuery();
?>
<h3 class="rclLinks">Recently Added Clients and Prospects <?php
if ($displayTable->numrows) {
echo " (" . $displayTable->numrows . ")";
}
?>
</h3>
<div class = "rclDivs">
<?php
$displayTable->show();
?>
</div>
<?php
}
function displayMiddle()
{
if (date("D") == "Mon") {
$interval = "3 DAY";
} else {
$interval = "1 DAY";
}
$whereclause = "invoices.creationdate >= DATE_SUB(NOW(),INTERVAL " . $interval . ")\n\t\t\t AND (\n invoices.type = 'Order'\n OR invoices.type = 'Quote'\n )";
include_once "include/search_class.php";
$displayTable = new simpleTable($this->db, "tbld:62fe599d-c18f-3674-9e54-b62c2d6b1883", "rso");
$displayTable->querywhereclause = $whereclause;
$displayTable->issueQuery();
?>
<h3 class="rsoLinks">Recent Sales Orders and Quotes <?php
if ($displayTable->numrows) {
echo " (" . $displayTable->numrows . ")";
}
?>
</h3>
<div class = "rsoDivs">
<?php
$displayTable->show();
?>
</div>
<?php
}
