|
Last Week |
Last Month |
Last 3 Month |
= (curdate() - INTERVAL 7 DAY), 1, 0) ) as total_lastweek
, sum( IF(start_date >= (curdate() - INTERVAL 1 month), 1, 0) ) as total_lastmonth
, sum( IF(start_date >= (curdate() - INTERVAL 3 month), 1, 0) ) as total_last3month
FROM screenshot
WHERE priority = 1";
$screenshot_result = $wrapperObj->executeQuery($sql, []);
if ($screenshot_result === false) {
show_pdo_error($sql, $wrapperObj->getLastStatement());
}
$rci = 0;
if ($screenshot_row = $screenshot_result[0])
{
$row_class = (++$rci & 1) ? '' : 'alt';
?>
| Priority 1 |
"> |
"> |
"> |
= (curdate() - INTERVAL 7 DAY), 1, 0) ) as total_lastweek
, sum( IF(start_date >= (curdate() - INTERVAL 1 month), 1, 0) ) as total_lastmonth
, sum( IF(start_date >= (curdate() - INTERVAL 3 month), 1, 0) ) as total_last3month
FROM screenshot
WHERE 1";
$screenshot_result = $wrapperObj->executeQuery($sql, []);
if ($screenshot_result === false) {
show_pdo_error($sql, $wrapperObj->getLastStatement());
}
$rci = 0;
if ($screenshot_row =$screenshot_result[0])
{
$row_class = (++$rci & 1) ? 'alt' : '';
?>
| All Screenshots |
"> |
"> |
"> |