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); }