// Emails //////////////////////////////////////////////////////////////////////////// if ($_GET['act'] == 'get_emails_data') { if (!isset($_GET['period'])) { $period = 'lifetime'; } $period = $_GET['period']; //class based implementation require '../classes/dashboard/Emails.php'; $email = new Emails(); $email->setPeriod($period); if ($period == 'custom') { $email->setCustomPeriod($_REQUEST['from'], $_REQUEST['to']); } header('Content-Type: application/json'); echo json_encode($email->get_emails_data()); die; //non-class based implementation $where = ""; if (!$is_su) { $where = " AND client_id = '" . $client_unbouce_id . "' \n ORDER BY email_date DESC"; } $rangeArray = getDateRangeFromPeriod($period); $date_from = $rangeArray['date_from']; $date_to = $rangeArray['date_to']; $arr_dates = createDateRangeArray($date_from, $date_to); $json_array = array(); foreach ($arr_dates as $arr_call) { $sql = "SELECT count(*) as total FROM emails "; $sql .= "WHERE email_date LIKE '%" . $arr_call . "%' {$where}"; // echo $sql;