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