public function setPeriod($period)
{
$this->period = $period;
$rangeArray = getDateRangeFromPeriod($this->period);
$this->from = $rangeArray['date_from'];
$this->to = $rangeArray['date_to'];
}
public function get_email_chart_data()
{
$where = "";
if (!DashboardCommon::is_su()) {
$where = " AND client_id IN ('" . implode('\',\'', $this->get_unbounce_ids()) . "') AND test_data=0";
}
$rangeArray = getDateRangeFromPeriod($this->period);
$date_from = $rangeArray['date_from'];
$date_to = $rangeArray['date_to'];
$where .= " AND email_date>=CONVERT_TZ('{$date_from}','+00:00','-04:00') AND\n email_date<=CONVERT_TZ('{$date_to}','+00:00','-04:00') ";
$data_array = array();
$sql = "SELECT *,CONVERT_TZ(email_date,'+00:00','+04:00') AS email_date_ae\n FROM emails WHERE 1 {$where} ORDER BY email_date DESC ";
$r = DashboardCommon::db()->Execute($sql);
foreach ($r as $res) {
$data_array[] = $res;
}
return $data_array;
}
$format = 'xml';
$allowed_formats = array('xml', 'json');
if (isset($_REQUEST['format']) && in_array($_REQUEST['format'], $allowed_formats)) {
$format = $_REQUEST['format'];
}
if ($gsm == '') {
echo json_encode(array('not authenticated'));
die;
}
if ($_REQUEST['get'] == 'calls') {
if (!isset($_GET['period'])) {
$period = 'lifetime';
} else {
$period = $_GET['period'];
}
$rangeArray = getDateRangeFromPeriod($period);
$from = $rangeArray['date_from'];
$to = $rangeArray['date_to'];
$data = getCallsData($gsm, $from, $to);
}
header("Content-Type: application/{$format}");
if ($format == 'json') {
echo json_encode($data);
die;
} else {
$xml = new SimpleXMLElement('<root/>');
array_to_xml($data, $xml);
print $xml->asXML();
die;
}
die;
function getROIData($from, $to)
{
if ($is_su) {
//admin roi not supported yet
return array();
}
global $db;
global $client_gsm_id;
$period_leads = getLeadsDataClient($from, $to);
$lifetime_range = getDateRangeFromPeriod('lifetime');
$lifetime_from = $lifetime_range['date_from'];
$lifetime_to = $lifetime_range['date_to'];
$lifetime_leads = getLeadsDataClient($lifetime_from, $lifetime_to);
$total_leads_period = $period_leads['total_leads'];
$total_leads_lifetime = $lifetime_leads['total_leads'];
$sql_roi2 = "SELECT avg_value_of_sale,avg_lead_to_sale FROM tbl_admin WHERE client_id LIKE '%" . $client_gsm_id . "%'";
$res_roi2 = $db->Execute($sql_roi2);
$avg_value_of_sale = $res_roi2->fields['avg_value_of_sale'] != '' ? $res_roi2->fields['avg_value_of_sale'] : 0;
$avg_lead_to_sale = $res_roi2->fields['avg_lead_to_sale'] != '' ? $res_roi2->fields['avg_lead_to_sale'] : 0;
$period_roi = $avg_value_of_sale * ($total_leads_period * ($avg_lead_to_sale / 100));
$lifetime_roi = $avg_value_of_sale * ($total_leads_lifetime * ($avg_lead_to_sale / 100));
//return array('period_roi'=>$period_roi,'lifetime_roi'=>$lifetime_roi,'total_leads_period'=>$total_leads_period,'avg_value_of_sale'=>$avg_value_of_sale,'avg_lead_to_sale'=>$avg_lead_to_sale,'period_leads'=>$period_leads);
return array('period_roi' => $period_roi, 'lifetime_roi' => $lifetime_roi, 'total_leads_period' => $total_leads_period, 'avg_value_of_sale' => $avg_value_of_sale, 'avg_lead_to_sale' => $avg_lead_to_sale);
}
