// make sure that the person has enough priviledge...
if(check_user_permission(36) )
{
// get current open customer orders.
?>
|
Last 30 Days |
Total |
$sql = "SELECT count(*) as total, SUM(IF(date_created >= (curdate() - INTERVAL 30 DAY), 1, 0)) as total_month
FROM vendor
WHERE priority = 1 AND status = 'signed' ";
$label_summary = $pdoWrapper->executeQuery($sql, []);
if ($label_summary === false) {
show_pdo_error($sql, $pdoWrapper->getLastStatement());
}
$rci = 0;
foreach ($label_summary as $label_summary_row)
{
$row_class = (++$rci & 1) ? '' : 'alt';
?>
| Priority 1 Labels |
">=$label_summary_row["total_month"]?> |
=$label_summary_row["total"]?> |
}
$row_class = (++$rci & 1) ? '' : 'alt';;
?>
}
?>