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 }