'1',
), $atts
)
);
$table_id = $atts['id'];
if ($table_id == "") {
$table_id = 1;
}
if( isset($GLOBALS['arp_data']) && isset($GLOBALS['arp_data'][$table_id]) ){
$result = $GLOBALS['arp_data'][$table_id];
} else {
$result = $wpdb->get_row($wpdb->prepare("select * from " . $wpdb->prefix . "arp_arprice where ID=%d", $table_id));
$GLOBALS['arp_data'][$table_id] = $result;
}
$pricetable_name = (isset($result) ) ? $result->table_name : '';
if ($pricetable_name == "") {
return "Please Select Valid Pricing Table";
} else if ($result->status != 'published') {
return "Please Select Valid Pricing Table";
} else if ($result->is_template == 1) {
return "";
}
$file_url = PRICINGTABLE_INC_DIR . "/GeoIP.dat";
if (!(extension_loaded('geoip'))) {
$gi = @geoip_open($file_url, GEOIP_STANDARD);
$country_name = geoip_country_name_by_addr($gi, $_SERVER['REMOTE_ADDR']);
} else {
$country_name = "";
}
$d = date("Y/m/d H:i:s");
$brow = $_SERVER['HTTP_USER_AGENT'];
$pageurl = $_SERVER['REQUEST_URI'];
$ref = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '';
$ip = $_SERVER['REMOTE_ADDR'];
$ses_id = session_id();
$browser = $arprice_analytics->getBrowser($brow);
$sel = $wpdb->get_row($wpdb->prepare("SELECT tracking_id, session_id FROM " . $wpdb->prefix . "arp_arprice_analytics WHERE pricing_table_id = " . $table_id . " AND session_id = %s", $ses_id));
if ($sel) {
require_once PRICINGTABLE_DIR . '/core/views/arprice_front.php';
$contents = arp_get_pricing_table_string($table_id);
$contents = apply_filters('arp_predisplay_pricingtable', $contents, $table_id);
return $contents;
}
$res = $wpdb->query($wpdb->prepare("INSERT INTO " . $wpdb->prefix . "arp_arprice_analytics (pricing_table_id,browser_name,browser_version,page_url,ip_address,country_name,session_id,added_date ) VALUES (%d,%s,%s,%s,%s,%s,%s,%s)", $table_id, $browser['browser_name'], $browser['version'], $pageurl, $ip, $country_name, $ses_id, $d));
require_once PRICINGTABLE_DIR . '/core/views/arprice_front.php';
$contents = arp_get_pricing_table_string($table_id);
$contents = apply_filters('arp_predisplay_pricingtable', $contents, $table_id);
return $contents;
}
function arp_analytics_pagination() {
global $wpdb, $arprice_analytics;
$per_page_rec = 10;
$no_per_pages = 5;
$page = 1;
if ($_REQUEST['pageno'] != "") {
$page = intval($_REQUEST['pageno']);
if ($page < 1)
$page = 1;
}
else {
$page = 1;
}
$start_frm = ($page - 1) * $per_page_rec;
$table = $wpdb->prefix . 'arp_arprice_analytics';
$sel = "SELECT * FROM $table ORDER BY added_date DESC";
$limit = $wpdb->prepare("LIMIT %d, %d", $start_frm, $per_page_rec);
$total_rows = $wpdb->get_var("SELECT COUNT(*) FROM $table");
$total_pages = $total_rows / $per_page_rec;
$total_pages = ceil($total_pages);
if ($total_pages > 1) {
$sel = $sel . " " . $limit;
}
if ($total_pages > 1) {
$range = array('start' => 1, 'end' => $total_pages);
if ($total_pages > $no_per_pages) {
if ($page < $no_per_pages) {
$range['start'] = 1;
$range['end'] = $no_per_pages;
} elseif ($page == $no_per_pages) {
$range['start'] = $page;
$range['end'] = $page + $no_per_pages - 1;
} elseif ($page > $no_per_pages) {
for ($i = $page; $i <= $total_pages; $i++) {
if ($page == ((2 * $no_per_pages) - 1)) {
$range['start'] = $page;
$range['end'] = $page + $no_per_pages - 1;
} elseif ($page == $total_pages) {
$range['start'] = $page - 2;
$range['end'] = $page;
} else {
$range['start'] = $page - 1;
$range['end'] = $page + ($no_per_pages - 2);
}
}
}
}
}
if ($wpdb->get_var($sel) > 0) {
$row = $wpdb->get_results($sel);
foreach ($row as $i => $data) {
if (($i + 1) % 2 == 0) {
$background = "background:#FFFFFF;";
} else {
$background = "background:#F8F8F8;";
}
$date_format = get_option('date_format');
$time_format = get_option('time_format');
$pricetable_id = $data->pricing_table_id;
$result = $wpdb->get_row($wpdb->prepare("select * from " . $wpdb->prefix . "arp_arprice where ID = %d", $pricetable_id));
$pricetable_name = $result->table_name;
$browser = $arprice_analytics->getBrowser($data->browser_info);
?>
|
browser_name . "
( Version " . $data->browser_version . " )"; ?> |
country_name; ?> |
ip_address; ?> |
referer; ?> |
|
' . join('|', $known) .
')[/ ]+(?[0-9.|a-zA-Z.]*)#';
if (!@preg_match_all($pattern, $u_agent, $matches)) {
}
$i = count($matches['browser']);
if ($i != 1) {
if (strripos($u_agent, "Version") < strripos($u_agent, $ub)) {
$version = $matches['version'][0];
} else {
$version = @$matches['version'][1];
}
} else {
$version = $matches['version'][0];
}
if ($ub == "Trident") {
$version = "11";
}
if ($version == null || $version == "") {
$version = "?";
}
return array('browser_name' => $bname, 'version' => $version);
}
function arp_retrieve_template_views( $template_id ){
global $wpdb;
$table = $wpdb->prefix . 'arp_arprice_analytics';
$counter = $wpdb->get_var("SELECT COUNT(*) FROM " . $table . " WHERE pricing_table_id = '" . $template_id . "' AND is_click='0'");
return $counter;
}
function arprice_get_template_charts() {
global $wpdb, $arprice_analytics_chart, $arprice_analytics;
$template_id = $_POST['template_id'];
$start_date = $_POST['start_date'];
$end_date = $_POST['end_date'];
$table = $wpdb->prefix . 'arp_arprice_analytics';
$browser_chart = array();
$country_chart = array();
$data = array();
$get_country_list = $wpdb->get_results("SELECT country_name FROM " . $table . " WHERE pricing_table_id = '" . $template_id . "' and is_click='0'");
foreach ($get_country_list as $key => $country) {
$country_name = $country->country_name;
$country_counter = $wpdb->get_var("SELECT COUNT(*) FROM " . $table . " WHERE pricing_table_id = '" . $template_id . "' and country_name = '" . $country_name . "' and is_click='0'");
$data['country'][$country_name] = $country_counter;
}
$get_browser_list = $wpdb->get_results("SELECT DISTINCT browser_name FROM ".$table." WHERE pricing_table_id = '".$template_id."'");
foreach( $get_browser_list as $key => $browser ){
$browser_name = $browser->browser_name;
$browser_counter = $wpdb->get_var("SELECT COUNT(*) FROM ".$table." WHERE pricing_table_id = '".$template_id."' and browser_name = '".$browser_name."'");
$data['browser'][$browser_name] = $browser_counter;
}
$browser_chart['chart'] = array(
'type' => "area",
);
$browser_chart['colors'] = array(
'#49c5f8','#c9ffdf'
);
$browser_chart['title'] = array(
'text' => ''
);
$dt = new DateTime($start_date, new DateTimeZone('UTC'));
$browser_chart['xAxis'] = array(
'title' => array(
'text' => 'Time Period'
),
'pointStart'=> $dt->getTimestamp()*1000,
'type'=>'datetime',
'minTickInterval'=> 24 * 3600 * 1000 * 7,
'labels'=>array(
'rotation'=> -70,
),
'tickPixelInterval'=>10
);
$browser_chart['yAxis'] = array(
'title' => array(
'text' => 'Clicks And Visits',
'style'=> array(
),
),
);
$dt = new DateTime($start_date, new DateTimeZone('UTC'));
$browser_chart['plotOptions']=array(
'area'=>array(
'pointStart'=> $dt->getTimestamp()*1000,
'pointInterval'=> 24 * 3600 * 1000,
'marker'=> array(
'enabled'=>false,
'symbol'=>'circle',
'radius'=>2,
'states'=>array(
'hover'=>array(
'enabled'=>true,
)
)
),
),
);
$browser_chart['no_of_views'] = $wpdb->get_var("SELECT COUNT(*) FROM " . $table . " WHERE pricing_table_id = '" . $template_id . "' and added_date BETWEEN '".(date('Y-m-d 00:00:00',strtotime($start_date)))."' AND '".(date('Y-m-d 23:59:59',strtotime($end_date)))."' and is_click='0'");
$browser_chart['no_of_clicks'] = $wpdb->get_var("SELECT COUNT(*) FROM " . $table . " WHERE pricing_table_id = '" . $template_id . "' and added_date BETWEEN '".(date('Y-m-d 00:00:00',strtotime($start_date)))."' AND '".(date('Y-m-d 23:59:59',strtotime($end_date)))."' and is_click='1'");
if($browser_chart['no_of_clicks']!=0)
{
$browser_chart['conversion'] =($browser_chart['no_of_clicks']*100) / $browser_chart['no_of_views'];
$browser_chart['conversion'] = number_format((float)$browser_chart['conversion'],2);
}
else
{
$browser_chart['conversion']=0;
}
// get all date for input
$start = new DateTime($start_date);
$end = new DateTime($end_date);
$interval = new DateInterval('P1D');
$start->setTime(0, 0);
$end->setTime(0, 0)->add($interval);
$periods = new DatePeriod($start, $interval, $end);
$view_data = array();
$click_data = array();
if (!empty($periods)) {
foreach ($periods as $key => $interval_date) {
$final_views['views'] = $wpdb->get_var("SELECT COUNT(*) FROM " . $table . " WHERE pricing_table_id = '" . $template_id . "' and added_date BETWEEN '".(date('Y-m-d 00:00:00',strtotime($interval_date->format('Y-m-d'))))."' AND '".(date('Y-m-d 23:59:59',strtotime($interval_date->format('Y-m-d'))))."' and is_click='0'");
$final_views['clicks'] = $wpdb->get_var("SELECT COUNT(*) FROM " . $table . " WHERE pricing_table_id = '" . $template_id . "' and added_date BETWEEN '".(date('Y-m-d 00:00:00',strtotime($interval_date->format('Y-m-d'))))."' AND '".(date('Y-m-d 23:59:59',strtotime($interval_date->format('Y-m-d'))))."' and is_click='1'");
array_push($view_data,(int)$final_views['views']);
array_push($click_data,(int)$final_views['clicks']);
}
}
$series = array(
array(
'name' => "Visits",
'data' => $view_data,
),
array(
'name' => "Clicks",
'data' => $click_data,
),
);
$browser_chart['series'] = $series;
$browser_chart['legend'] =array(
'symbolHeight'=> 10,
'symbolWidth'=> 10,
'symbolRadius'=> 5,
);
// browser chart over
//country chart
$country_chart['chart'] = array(
'type' => 'pie',
);
$country_chart['title'] = array(
'text' => ''
);
$country_chart['tooltip'] = array(
'tooltip' => array(
'pointFormat' => '{point.name}:{point.y}'
)
);
$country_chart['legend'] =array(
'align'=> 'right',
'verticalAlign'=> 'top',
'layout'=> 'vertical',
'x'=> 0,
'y'=> 100,
'symbolHeight'=> 10,
'symbolWidth'=> 10,
'symbolRadius'=> 5
);
$country_chart['plotOptions'] = array(
'pie' => array(
'depth' => 100,
'innerSize' => 70,
'showInLegend'=>true,
),
);
$country_chart_color['colors'] = array('#6ec1e9','#01d7cb','#56d456','#bad709','#f9d900','#ffa801','#ef6565','#f471cf','#9b4e96','#51dd89');
$color_counter = count($country_chart_color['colors']);
$data_chart_c = array();
$data_color = array();
$series_data_country = array();
arsort($data['country']);
$other_entry=0;
if (!empty($data['country'])) {
$i=0; // for color count
$y=0; //for country count
foreach ($data['country'] as $country => $counter)
{
if($y<=8 && $country!='')
{
$data_chart_c['name'] = $country;
$data_chart_c['y'] = (int) $counter;
$data_chart_c['color'] = $country_chart_color['colors'][$i];
$i++;
$y++;
array_push($series_data_country, $data_chart_c);
}
else
{
$other_entry=1;
$other_country=0;
$other_country=$other_country+$counter;
}
}
if($other_entry==1)
{
$data_chart_c['name'] = 'Others';
$data_chart_c['y']=$other_country;
$data_chart_c['color'] = $country_chart_color['colors'][$color_counter-1];
array_push($series_data_country, $data_chart_c);
}
}
$country_series = array(
array(
'name' => 'Countries',
'data' => $series_data_country
)
);
$country_chart['series'] = $country_series;
$final_data['browser'] = $browser_chart;
$final_data['country'] = $country_chart;
$final_data['arp_table'] = $arprice_analytics->arp_analytic_table($template_id);
echo json_encode($final_data);
die();
}
function arp_analytic_table($template_id) {
global $wpdb;
$arp_table = array();
$table = $wpdb->prefix . 'arp_arprice_analytics';
$sel = $wpdb->get_results("SELECT * FROM $table WHERE pricing_table_id = '" . $template_id."' AND is_click='0'");
$arp_table_row_data = array();
$arp_row_data= array();
$i=0;
$date_format = get_option('date_format');
$time_format = get_option('time_format');
foreach($sel as $key => $value)
{
$arp_row_data['date'] =date($date_format.' '.$time_format,strtotime($value->added_date));
$arp_row_data['browser'] =$value->browser_name.' ('.$value->browser_version.')';
$arp_row_data['ip_address'] =$value->ip_address;
$arp_row_data['country'] =$value->country_name;
$sele = $wpdb->get_results("SELECT plan_id FROM $table WHERE pricing_table_id = '" . $template_id."' AND is_click='1' AND ip_address='".$value->ip_address."' AND session_id='".$value->session_id ."'");
if(empty($sele[0]))
{
$i=$i+1;
$arp_row_data['click']='No';
$arp_row_data['sr_no']=$i;
array_push($arp_table_row_data,$arp_row_data);
}
else
{
foreach($sele as $obj_id => $plan_id)
{
$i=$i+1;
$plan_id = explode("_",$plan_id->plan_id);
$arp_row_data['click']='Yes (Plan '.$plan_id[2].')';
$arp_row_data['sr_no']=$i;
array_push($arp_table_row_data,$arp_row_data);
}
}
}
return $arp_table_row_data;
}
function arp_insert_plan_id() {
global $wpdb, $arprice_analytics;
$arp_plan_id = isset($_POST['arp_plan_id']) ? $_POST['arp_plan_id'] : '';
$arp_template_id = isset($_POST['arp_template_id']) ? $_POST['arp_template_id'] : '';
$caption_column = $_POST['caption_column'];
if($caption_column==0)
{
$plan_id = explode("_",$arp_plan_id);
$plan_id[2]=$plan_id[2]+1;
$arp_plan_id='plan_id_'.$plan_id[2];
}
if($caption_column==1)
{
$plan_id = explode("_",$arp_plan_id);
$arp_plan_id='plan_id_'.$plan_id[2];
}
$file_url = PRICINGTABLE_INC_DIR . "/GeoIP.dat";
if (!(extension_loaded('geoip'))) {
@include(PRICINGTABLE_INC_DIR . '/geoip.inc');
$gi = geoip_open($file_url, GEOIP_STANDARD);
$country_name = geoip_country_name_by_addr($gi, $_SERVER['REMOTE_ADDR']);
} else {
$country_name = "";
}
$d = date("Y/m/d H:i:s");
$brow = $_SERVER['HTTP_USER_AGENT'];
$pageurl = $_SERVER['REQUEST_URI'];
$ref = @$_SERVER['HTTP_REFERER'];
$ip = $_SERVER['REMOTE_ADDR'];
$ses_id = session_id();
$browser = $arprice_analytics->getBrowser($brow);
$sel = $wpdb->get_row($wpdb->prepare("SELECT plan_id,is_click,tracking_id FROM " . $wpdb->prefix . "arp_arprice_analytics WHERE pricing_table_id = " . $arp_template_id . " AND ip_address ='" . $ip . "' AND is_click='1' AND plan_id='".$arp_plan_id."' AND session_id = %s", $ses_id));
if ($sel) {
} else {
$is_click = 1;
$res = $wpdb->query($wpdb->prepare("INSERT INTO " . $wpdb->prefix . "arp_arprice_analytics (pricing_table_id,browser_name,browser_version,page_url,ip_address,country_name,session_id,added_date,is_click,plan_id ) VALUES (%d,%s,%s,%s,%s,%s,%s,%s,%d,%s)", $arp_template_id, $browser['browser_name'], $browser['version'], $pageurl, $ip, $country_name, $ses_id, $d, $is_click, $arp_plan_id));
}
die();
}
function arp_analytics_pagination_popup() {
global $wpdb, $arprice_analytics;
$per_page_rec = 10;
$no_per_pages = 5;
$page = 1;
if ($_REQUEST['pageno'] != "") {
$page = intval($_REQUEST['pageno']);
if ($page < 1)
$page = 1;
}
else {
$page = 1;
}
if ($_REQUEST['template_id'] != "") {
$template_id = intval($_REQUEST['template_id']);
}
$start_frm = ($page - 1) * $per_page_rec;
$table = $wpdb->prefix . 'arp_arprice_analytics';
$sel = "SELECT * FROM $table WHERE pricing_table_id = $template_id ORDER BY added_date DESC";
$limit = $wpdb->prepare("LIMIT %d, %d", $start_frm, $per_page_rec);
$total_rows = $wpdb->get_var("SELECT COUNT(*) FROM $table WHERE pricing_table_id = $template_id");
$total_pages = $total_rows / $per_page_rec;
$total_pages = ceil($total_pages);
if ($total_pages > 1) {
$sel = $sel . " " . $limit;
}
if ($total_pages > 1) {
$range = array('start' => 1, 'end' => $total_pages);
if ($total_pages > $no_per_pages) {
if ($page < $no_per_pages) {
$range['start'] = 1;
$range['end'] = $no_per_pages;
} elseif ($page == $no_per_pages) {
$range['start'] = $page;
$range['end'] = $page + $no_per_pages - 1;
} elseif ($page > $no_per_pages) {
for ($i = $page; $i <= $total_pages; $i++) {
if ($page == ((2 * $no_per_pages) - 1)) {
$range['start'] = $page;
$range['end'] = $page + $no_per_pages - 1;
} elseif ($page == $total_pages) {
$range['start'] = $page - 2;
$range['end'] = $page;
} else {
$range['start'] = $page - 1;
$range['end'] = $page + ($no_per_pages - 2);
}
}
}
}
}
if ($wpdb->get_var($sel) > 0) {
$row = $wpdb->get_results($sel);
foreach ($row as $i => $data) {
if (($i + 1) % 2 == 0) {
$background = "background:#FFFFFF;";
} else {
$background = "background:#F8F8F8;";
}
$date_format = get_option('date_format');
$time_format = get_option('time_format');
$pricetable_id = $data->pricing_table_id;
$result = $wpdb->get_row($wpdb->prepare("select * from " . $wpdb->prefix . "arp_arprice where ID = %d", $pricetable_id));
$pricetable_name = $result->table_name;
$browser = $arprice_analytics->getBrowser($data->browser_info);
?>
|
browser_name . "
( Version " . $data->browser_version . " )"; ?> |
country_name; ?> |
ip_address; ?> |
page_url; ?> |
|
prefix . 'arp_arprice_analytics';
$browser_chart['no_of_views'] = $wpdb->get_var("SELECT COUNT(*) FROM " . $table . " WHERE pricing_table_id = '" . $template_id . "' and added_date BETWEEN '".(date('Y-m-d 00:00:00',strtotime($start_date)))."' AND '".(date('Y-m-d 23:59:59',strtotime($end_date)))."' and is_click='0'");
$browser_chart['no_of_clicks'] = $wpdb->get_var("SELECT COUNT(*) FROM " . $table . " WHERE pricing_table_id = '" . $template_id . "' and added_date BETWEEN '".(date('Y-m-d 00:00:00',strtotime($start_date)))."' AND '".(date('Y-m-d 23:59:59',strtotime($end_date)))."' and is_click='1'");
if($browser_chart['no_of_clicks']!=0)
{
$browser_chart['conversion'] =($browser_chart['no_of_clicks']*100) / $browser_chart['no_of_views'];
$browser_chart['conversion'] = number_format((float)$browser_chart['conversion'],2);
}
else
{
$browser_chart['conversion']=0;
}
$browser_chart['colors'] = array(
'#49c5f8','#c9ffdf'
);
$browser_chart['chart'] = array(
'type' => "area",
);
$browser_chart['title'] = array(
'text' => ''
);
$browser_chart['xAxis'] = array(
'title' => array(
'text' => 'Time Period'
),
'type'=>'datetime',
'tickInterval' => 7 * 24 * 3600 * 1000,
'labels'=>array(
'rotation'=> -70,
),
);
$browser_chart['yAxis'] = array(
'title' => array(
'text' => 'Clicks And Visits'
),
);
$browser_chart['legend'] =array(
'symbolHeight'=> 10,
'symbolWidth'=> 10,
'symbolRadius'=> 5,
);
$dt = new DateTime($start_date, new DateTimeZone('UTC'));
$browser_chart['plotOptions']=array(
'area'=>array(
'pointStart'=> $dt->getTimestamp()*1000,
'pointInterval'=> 24 * 3600 * 1000 ,
'marker'=> array(
'enabled'=>false,
'symbol'=>'circle',
'radius'=>2,
'states'=>array(
'hover'=>array(
'enabled'=>true,
)
)
),
),
);
// get all date for input
$start = new DateTime($start_date);
$end = new DateTime($end_date);
$interval = new DateInterval('P1D');
$start->setTime(0, 0);
$end->setTime(0, 0)->add($interval);
$periods = new DatePeriod($start, $interval, $end);
$view_data = array();
$click_data = array();
if (!empty($periods)) {
foreach ($periods as $key => $interval_date) {
$final_views['views'] = $wpdb->get_var("SELECT COUNT(*) FROM " . $table . " WHERE pricing_table_id = '" . $template_id . "' and added_date BETWEEN '".(date('Y-m-d 00:00:00',strtotime($interval_date->format('Y-m-d'))))."' AND '".(date('Y-m-d 23:59:59',strtotime($interval_date->format('Y-m-d'))))."' and is_click='0'");
$final_views['clicks'] = $wpdb->get_var("SELECT COUNT(*) FROM " . $table . " WHERE pricing_table_id = '" . $template_id . "' and added_date BETWEEN '".(date('Y-m-d 00:00:00',strtotime($interval_date->format('Y-m-d'))))."' AND '".(date('Y-m-d 23:59:59',strtotime($interval_date->format('Y-m-d'))))."' and is_click='1'");
array_push($view_data,(int)$final_views['views']);
array_push($click_data,(int)$final_views['clicks']);
}
}
$series = array(
array(
'name' => "Visits",
'data' => $view_data,
),
array(
'name' => "Clicks",
'data' => $click_data,
),
);
$browser_chart['series'] = $series;
$final_data['browser'] = $browser_chart;
echo json_encode($final_data);
die();
}
function arp_get_basic_area_daily() {
global $wpdb, $arprice_analytics_chart, $arprice_analytics;
$template_id = $_POST['template_id'];
$start_date = $_POST['start_date'];
$end_date = $_POST['end_date'];
$table = $wpdb->prefix . 'arp_arprice_analytics';
$browser_chart['no_of_views'] = $wpdb->get_var("SELECT COUNT(*) FROM " . $table . " WHERE pricing_table_id = '" . $template_id . "' and added_date BETWEEN '".(date('Y-m-d 00:00:00',strtotime($start_date)))."' AND '".(date('Y-m-d 23:59:59',strtotime($end_date)))."' and is_click='0'");
$browser_chart['no_of_clicks'] = $wpdb->get_var("SELECT COUNT(*) FROM " . $table . " WHERE pricing_table_id = '" . $template_id . "' and added_date BETWEEN '".(date('Y-m-d 00:00:00',strtotime($start_date)))."' AND '".(date('Y-m-d 23:59:59',strtotime($end_date)))."' and is_click='1'");
if($browser_chart['no_of_clicks']!=0)
{
$browser_chart['conversion'] =($browser_chart['no_of_clicks']*100) / $browser_chart['no_of_views'];
$browser_chart['conversion'] = number_format((float)$browser_chart['conversion'],2);
}
else
{
$browser_chart['conversion']=0;
}
$browser_chart['chart'] = array(
'type' => "area",
);
$browser_chart['colors'] = array(
'#49c5f8','#c9ffdf'
);
$browser_chart['title'] = array(
'text' => ''
);
$browser_chart['xAxis'] = array(
'title' => array(
'text' => 'Time Period'
),
'type'=>'datetime',
'tickInterval' => 24 * 3600 * 1000,
'labels'=>array(
'rotation'=> -70,
),
);
$browser_chart['yAxis'] = array(
'title' => array(
'text' => 'Clicks And Visits'
),
);
$dt = new DateTime($start_date, new DateTimeZone('UTC'));
$browser_chart['plotOptions']=array(
'area'=>array(
'pointStart'=> $dt->getTimestamp()*1000,
'pointInterval'=> 24 * 3600 * 1000 ,
'marker'=> array(
'enabled'=>false,
'symbol'=>'circle',
'radius'=>2,
'states'=>array(
'hover'=>array(
'enabled'=>true,
)
)
),
),
);
// get all date for input
$start = new DateTime($start_date);
$end = new DateTime($end_date);
$interval = new DateInterval('P1D');
$start->setTime(0, 0);
$end->setTime(0, 0)->add($interval);
$periods = new DatePeriod($start, $interval, $end);
$view_data = array();
$click_data = array();
if (!empty($periods)) {
foreach ($periods as $key => $interval_date) {
$final_views['views'] = $wpdb->get_var("SELECT COUNT(*) FROM " . $table . " WHERE pricing_table_id = '" . $template_id . "' and added_date BETWEEN '".(date('Y-m-d 00:00:00',strtotime($interval_date->format('Y-m-d'))))."' AND '".(date('Y-m-d 23:59:59',strtotime($interval_date->format('Y-m-d'))))."' and is_click='0'");
$final_views['clicks'] = $wpdb->get_var("SELECT COUNT(*) FROM " . $table . " WHERE pricing_table_id = '" . $template_id . "' and added_date BETWEEN '".(date('Y-m-d 00:00:00',strtotime($interval_date->format('Y-m-d'))))."' AND '".(date('Y-m-d 23:59:59',strtotime($interval_date->format('Y-m-d'))))."' and is_click='1'");
array_push($view_data,(int)$final_views['views']);
array_push($click_data,(int)$final_views['clicks']);
}
}
$series = array(
array(
'name' => "Visits",
'data' => $view_data,
),
array(
'name' => "Clicks",
'data' => $click_data,
),
);
$browser_chart['legend'] =array(
'symbolHeight'=> 10,
'symbolWidth'=> 10,
'symbolRadius'=> 5,
);
$browser_chart['series'] = $series;
$final_data['browser'] = $browser_chart;
echo json_encode($final_data);
die();
}
}
?>