PHP Database::date_count Examples

Example #1

File: mailing-list-stats.php Project: alekhen/intoor-lib

 */
if (!defined('INTOOR_RESTRICT_ACCESS') || !INTOOR_RESTRICT_ACCESS) {
    die('Unauthorized Access');
}
extract($this->args);
$data = Database::get_results($table, array('status'));
$active_count = 0;
$inactive_count = 0;
$deleted_count = 0;
$total_count = 0;
$month_count = Database::date_count($table, 'create_date', 'month');
$month_unsub_count = Database::date_count($table, 'delete_date', 'month');
$week_count = Database::date_count($table, 'create_date', 'week');
$week_unsub_count = Database::date_count($table, 'delete_date', 'week');
$day_count = Database::date_count($table, 'create_date', 'day');
$day_unsub_count = Database::date_count($table, 'delete_date', 'day');
foreach ($data as $row => $val) {
    if (!isset($val['email'])) {
        $total_count++;
        switch ($val['status']) {
            case 'active':
                $active_count++;
                break;
            case 'trash':
                $inactive_count++;
                break;
            case 'deleted':
                $deleted_count++;
                break;
        }
    }