objDatabase=new wsmDatabase(); //wp_clear_scheduled_hook( 'schedule_report_event' ); } function send_test_mail_callback() { if(null !== (sanitize_text_field($_POST['report']) ) && sanitize_text_field($_POST['report']) == 1 ) { $this->generate_report( false ); echo "1"; die(); } else { echo "0" ; exit; } } function init(){ if(isset( $_GET['report'] ) && $_GET['report'] == 1 ){ $this->generate_report( false ); die(); } if (! wp_next_scheduled ( 'schedule_report_event' )) { $schedule_time = wsmGetCurrentDateByTimeZone('Y-m-d').' 23:59:59'; $schedule_time = get_gmt_from_date( $schedule_time, 'U' ); wp_schedule_event($schedule_time, 'daily', 'schedule_report_event'); } } function generate_report( $live = true ){ global $call_by_reports; $call_by_reports = true; $reportStats = get_option(WSM_PREFIX.'ReportStats'); $reportScheduleTime = get_option(WSM_PREFIX.'ReportScheduleTime'); $reportEmail = get_option(WSM_PREFIX.'ReportEmails'); $report_time = get_option('report_time'); if( !$reportEmail ){ $reportEmail = get_option('admin_email'); } $arrAtts = array(); $newReportDate = date('Y-m-d'); if( $reportScheduleTime ){ switch($reportScheduleTime){ case 1: $arrAtts['from'] = $arrAtts['to'] = date('Y-m-d', strtotime("-1 day")); $newReportDate = date('Y-m-d', strtotime("+1 day")); break; case 3: if( date('w') == 4 ){ $arrAtts['from'] = date('Y-m-d', strtotime("-4 day")); $arrAtts['to'] = date('Y-m-d', strtotime("-1 day")); $newReportDate = date('Y-m-d', strtotime("+3 day")); } if( date('w') == 0 ){ $arrAtts['from'] = date('Y-m-d', strtotime("-3 day")); $arrAtts['to'] = date('Y-m-d', strtotime("-1 day")); $newReportDate = date('Y-m-d', strtotime("+4 day")); } break; case 7: if( date('w') == 0 ) { $arrAtts['from'] = date('Y-m-d', strtotime("-7 day")); $arrAtts['to'] = date('Y-m-d', strtotime("-1 day")); $newReportDate = date('Y-m-d', strtotime("+7 day")); } break; case 30: if( date('j') == 1 ) { $month_ini = new DateTime("first day of last month"); $month_end = new DateTime("last day of last month"); $arrAtts['from'] = $month_ini->format('Y-m-d'); $arrAtts['to'] = $month_end->format('Y-m-d'); $newReportDate = date('Y-m-d', strtotime("first day of next month")); } break; } } if( $live && strtotime( $report_time ) > strtotime( date('Y-m-d') ) ){ return; } if( count( $arrAtts) ){ if( is_array($reportStats) && count( $reportStats ) ){ ob_start(); echo '
'; echo sprintf('
%s, %s %s
', 'Report', date('l M d, Y'), date('H:m A') ); echo '
'; $this->general_stats( $arrAtts ); echo '
'; foreach( $reportStats as $reportFunction ){ echo '
'; $this->$reportFunction( $arrAtts ); echo '
'; } echo '

'._('Reports generated by WordPress Stats Plugin').'

'; echo '
'; $content = ob_get_contents(); ob_clean(); $headers = array('Content-Type: text/html; charset=UTF-8'); wp_mail($reportEmail,'Website Statistics Report - '.date('D, d M Y h:m:s'), $content, $headers); //wp_mail('mitesh@prismitsystems.com','Report', $content, $headers); //echo $content; update_option( 'report_time', $newReportDate ); } } } function general_stats_new( $arrAtts ){ echo do_shortcode("[".WSM_PREFIX."_showGenStats]"); } function general_stats( $arrAtts ){ $totalPageViews=$this->objDatabase->fnGetTotalPageViewCount(); $totalVisitors=$this->objDatabase->fnGetTotalVisitorsCount(); $pageViews=0; if($totalPageViews>0 && $totalVisitors>0){ $pageViews=($totalPageViews/$totalVisitors); } $totalPageViews=number_format_i18n($totalPageViews,0); $totalVisitors=number_format_i18n($totalVisitors,0); $pageViews=number_format_i18n($pageViews,2); $data = array( __('Total Page Views','wp-stats-manager') => $totalPageViews, __('Total Visitors','wp-stats-manager') => $totalVisitors, __('Page Views Per Visit','wp-stats-manager') => $pageViews ); echo $this->generate_section( $data, __('General Stats','wp-stats-manager') ); } function daily_stats( $arrAtts ){ if( !is_array( $arrAtts ) ){ $arrAtts['from'] = $arrAtts['to'] = date('Y-m-d', strtotime("-1 day")); } $pageViews=$this->objDatabase->fnGetTotalPageViewCount('Normal',$arrAtts); $visitors=$this->objDatabase->fnGetTotalVisitorsCount('Normal',$arrAtts); $firstTimeVisitors=$this->objDatabase->fnGetFirstTimeVisitorCount('Normal',$arrAtts); if($pageViews>0 && $visitors>0){ $pvpv=($pageViews/$visitors); } if($firstTimeVisitors>0 && $visitors>0){ $nvr=($firstTimeVisitors*100)/$visitors; } $strPageViews=''.number_format_i18n($pageViews,0).''; $strVisitors=''.number_format_i18n($visitors,0).''; $strFirstTimeVisitors=''.number_format_i18n($firstTimeVisitors,0).''; $strPvpv=''.number_format_i18n($pvpv,2).''; $strNvr=''.number_format_i18n($nvr,2).'%'; $data = array( __('Total Page Views','wp-stats-manager') => $strPageViews, __('Total Visitors','wp-stats-manager') => $strVisitors, __('First Time Visitors','wp-stats-manager') => $strFirstTimeVisitors, __('Page Views Per Visit','wp-stats-manager') => $strPvpv, __('New Visitors Ratio','wp-stats-manager') => $strNvr ); echo $this->generate_table( $data, __('Daily Stats','wp-stats-manager') ); } function referral_website_stats( $arrAtts ){ if( !is_array( $arrAtts ) ){ $arrAtts['from'] = $arrAtts['to'] = date('Y-m-d', strtotime("-1 day")); } $atts['condition'] = 'Normal'; $pageViews=$this->objDatabase->fnGetTotalPageViewCount($atts['condition'],$arrAtts); $RpageViews=$this->objDatabase->fnGetReferralTotalPageViewCount($atts['condition'],$arrAtts); $visitors=$this->objDatabase->fnGetTotalVisitorsCount($atts['condition'],$arrAtts); $Rvisitors=$this->objDatabase->fnGetReferralTotalVisitorsCount($atts['condition'],$arrAtts); $firstTimeVisitors=$this->objDatabase->fnGetFirstTimeVisitorCount($atts['condition'],$arrAtts); $RfirstTimeVisitors=$this->objDatabase->fnGetReferralFirstTimeVisitorCount($atts['condition'],$arrAtts); if($pageViews>0 && $visitors>0){ $pvpv=($pageViews/$visitors); } if($RpageViews>0 && $Rvisitors>0){ $Rpvpv=($RpageViews/$Rvisitors); } if($pageViews>0 && $RpageViews>0){ $PpageViews=($RpageViews/$pageViews)*100; $PpageViews=number_format_i18n($PpageViews,2); } if($visitors>0 && $Rvisitors>0){ $Pvisitors=($Rvisitors/$visitors)*100; $Pvisitors=number_format_i18n($Pvisitors,2); } if($firstTimeVisitors>0 && $RfirstTimeVisitors>0){ $PfirstTimeVisitors=($RfirstTimeVisitors/$firstTimeVisitors)*100; $PfirstTimeVisitors=number_format_i18n($PfirstTimeVisitors,2); } $pvDiff=$Rpvpv-$pvpv; if($pvDiff>0 && $pvpv>0){ $Ppvpv= ($pvDiff/$pvpv)*100; if($Ppvpv>=0){ $Ppvpv='+'.number_format_i18n($Ppvpv,2); }else{ $Ppvpv='-'.number_format_i18n($Ppvpv,2); } } $pageViews=number_format_i18n($pageViews,0); $RpageViews=number_format_i18n($RpageViews,0); $visitors=number_format_i18n($visitors,0); $Rvisitors=number_format_i18n($Rvisitors,0); $firstTimeVisitors=number_format_i18n($firstTimeVisitors,0); $RfirstTimeVisitors=number_format_i18n($RfirstTimeVisitors,0); $pvpv=number_format_i18n($pvpv,2); $Rpvpv=number_format_i18n($Rpvpv,2); $column = array( __('Summary','wp-stats-manager'), __('Stats Summary','wp-stats-manager'), __('Referrer Summary','wp-stats-manager') ,'(%)' ); $rows = array( array( __('Total Page Views','wp-stats-manager'), $pageViews, $RpageViews, $PpageViews ), array( __('Total Visitors','wp-stats-manager'), $visitors, $Rvisitors, $Pvisitors ), array( __('Total New Visitors','wp-stats-manager'), $firstTimeVisitors, $RfirstTimeVisitors, $PfirstTimeVisitors ), array( __('Page Views Per Visit','wp-stats-manager'), $pvpv, $Rpvpv, $Ppvpv ) ); echo $this->generate_row_table( $column, $rows, __('Referral Website Stats','wp-stats-manager') ); } function search_engine_stats( $arrAtts ){ $graph = false; global $call_by_reports; if( !is_array( $arrAtts ) ){ $graph = true; if( $call_by_reports ){ $arrAtts['from'] = $arrAtts['to'] = date('Y-m-d', strtotime("-1 day")); }else{ $arrAtts['from'] = $arrAtts['to'] = wsmGetCurrentDateByTimeZone( 'Y-m-d' ); } } $atts['condition'] = 'Normal'; $arrAtts['searchengine']=1; $pageViews=$this->objDatabase->fnGetTotalPageViewCount($atts['condition'],$arrAtts); $visitors=$this->objDatabase->fnGetTotalVisitorsCount($atts['condition'],$arrAtts); $firstTimeVisitors=$this->objDatabase->fnGetFirstTimeVisitorCount($atts['condition'],$arrAtts); if($pageViews>0 && $visitors>0){ $pvpv=($pageViews/$visitors); } $pageViews=number_format_i18n($pageViews,0); $visitors=number_format_i18n($visitors,0);; $firstTimeVisitors=number_format_i18n($firstTimeVisitors,0); $pvpv=number_format_i18n($pvpv,2); $column = array( __('Summary','wp-stats-manager'), __('Stats Summary','wp-stats-manager') ); $rows = array( array( __('Total Page Views','wp-stats-manager'), $pageViews ), array( __('Total Visitors','wp-stats-manager'), $visitors ), array( __('Total New Visitors','wp-stats-manager'), $firstTimeVisitors ), array( __('Page Views Per Visit','wp-stats-manager'), $pvpv ) ); $html = $this->generate_row_table( $column, $rows, __('Search Engine Stats','wp-stats-manager') ); $arrSearchEngineStatList = $this->objDatabase->fnGetTotalUserSeachEngineWise( $atts['condition'] ,$arrAtts); $totalUsers = array_sum( $arrSearchEngineStatList ); $column = array( '', __('Visitors','wp-stats-manager') ); $rows = array(); foreach( $arrSearchEngineStatList as $key => $arrSearchEngineStat ){ if( $arrSearchEngineStat ){ $number = $arrSearchEngineStat * 100 / $totalUsers; $user_per = number_format($number,2); $graph_div = ''; if( $graph ){ $graph_div = '
'; } $name = sprintf( '%s %s', str_replace(' ','', strtolower($key)), WSM_URL, $key, $key, $key ); $rows[] = array( ''.$name.' '.$graph_div.$user_per.'%', number_format($arrSearchEngineStat) ); } } $html .= $this->generate_row_table( $column, $rows, __('Search Engine Summary','wp-stats-manager') ); echo $html; } function top_search_engine_stats( $arrAtts ){ global $call_by_reports; if( !is_array( $arrAtts ) ){ if( $call_by_reports ){ $arrAtts['from'] = $arrAtts['to'] = date('Y-m-d', strtotime("-1 day")); }else{ $arrAtts['from'] = $arrAtts['to'] = wsmGetCurrentDateByTimeZone( 'Y-m-d' ); } } $atts['condition'] = 'Normal'; $arrAtts['searchengine']=1; $arrReferrerList=$this->objDatabase->fnGetReferralList($atts['condition'],$arrAtts); $column = $rows = array(); if(count($arrReferrerList['data'])>0){ $column = array( __('Rank','wp-stats-manager'), __('Referrer url','wp-stats-manager'), __('References','wp-stats-manager') ); $count = 1; foreach($arrReferrerList['data'] as $referrer=>$referrers){ $name = sprintf( '%s %s', str_replace(' ','', strtolower($referrers['searchEngine'] )), WSM_URL, $referrers['searchEngine'] , $referrers['searchEngine'] , $referrers['refUrl'] ); $rows[] = array( $count++, $name, number_format($referrers['total'] ) ); } } echo $this->generate_row_table( $column, $rows, __('Top Search Engine Summary','wp-stats-manager') ); } function os_wise_visitor_stats( $arrAtts ){ global $call_by_reports; if( !is_array( $arrAtts ) ){ if( $call_by_reports ){ $arrAtts['from'] = $arrAtts['to'] = date('Y-m-d', strtotime("-1 day")); }else{ $arrAtts['from'] = $arrAtts['to'] = wsmGetCurrentDateByTimeZone( 'Y-m-d' ); } } echo $this->get_visitor_stats( $arrAtts, __('OS','wp-stats-manager'), __('Operating System','wp-stats-manager') ); } function browser_wise_visitor_stats( $arrAtts ){ global $call_by_reports; if( !is_array( $arrAtts ) ){ if( $call_by_reports ){ $arrAtts['from'] = $arrAtts['to'] = date('Y-m-d', strtotime("-1 day")); }else{ $arrAtts['from'] = $arrAtts['to'] = wsmGetCurrentDateByTimeZone( 'Y-m-d' ); } } echo $this->get_visitor_stats( $arrAtts, __('Browser','wp-stats-manager'), __('Browser','wp-stats-manager') ); } function screen_wise_visitor_stats( $arrAtts ){ global $call_by_reports; if( !is_array( $arrAtts ) ){ if( $call_by_reports ){ $arrAtts['from'] = $arrAtts['to'] = date('Y-m-d', strtotime("-1 day")); }else{ $arrAtts['from'] = $arrAtts['to'] = wsmGetCurrentDateByTimeZone( 'Y-m-d' ); } } echo $this->get_visitor_stats( $arrAtts, __('Screen Resolution','wp-stats-manager'), __('Screen Resolution','wp-stats-manager') ); } function country_wise_visitor_stats( $arrAtts ){ global $call_by_reports; if( !is_array( $arrAtts ) ){ if( $call_by_reports ){ $arrAtts['from'] = $arrAtts['to'] = date('Y-m-d', strtotime("-1 day")); }else{ $arrAtts['from'] = $arrAtts['to'] = wsmGetCurrentDateByTimeZone( 'Y-m-d' ); } } echo $this->get_location_stats( $arrAtts, __('Country Stats','wp-stats-manager') ); } function city_wise_visitor_stats( $arrAtts ){ global $call_by_reports; if( !is_array( $arrAtts ) ){ if( $call_by_reports ){ $arrAtts['from'] = $arrAtts['to'] = date('Y-m-d', strtotime("-1 day")); }else{ $arrAtts['from'] = $arrAtts['to'] = wsmGetCurrentDateByTimeZone( 'Y-m-d' ); } } $arrAtts['location'] = 1; echo $this->get_location_stats( $arrAtts, __('City Stats','wp-stats-manager') ); } function get_location_stats( $arrAtts, $title ){ $condition = 'Normal'; $totalGeoLocationDetails = $this->objDatabase->getGeoLocationInfo( $condition, $arrAtts ); $column = $rows = array(); if( $totalGeoLocationDetails ){ $count = 1; if( isset( $arrAtts['location'] )){ $column = array( __('Rank','wp-stats-manager'), __('City','wp-stats-manager'), __('New visitors','wp-stats-manager'), __('Visitors','wp-stats-manager'), __('Page viewed','wp-stats-manager'), __('Ppv','wp-stats-manager') ); }else{ $column = array( __('Rank','wp-stats-manager'), __('Country','wp-stats-manager'), __('New visitors','wp-stats-manager'), __('Visitors','wp-stats-manager'), __('Page viewed','wp-stats-manager'), __('Ppv','wp-stats-manager') ); } foreach( $totalGeoLocationDetails as $key => $locationDetail ){ if( $count < 11 ){ $name = sprintf( '%s %s', strtolower($locationDetail['alpha2Code']), WSM_URL, $locationDetail['name'] , $locationDetail['name'] , $locationDetail['name'] ); $ppv = $locationDetail['total_page_views'] / $locationDetail['total_visitors']; $rows[] = array( $count++, $name, number_format($locationDetail['total_unique_visitors']), number_format($locationDetail['total_visitors']), number_format($locationDetail['total_page_views']), number_format($ppv, 2) ); } } } return $this->generate_row_table( $column, $rows, $title ); } function get_visitor_stats( $arrAtts, $keyName, $title ){ $condition = 'Normal'; $rows = array(); $arrVisitorsInfo = $this->objDatabase->getVisitorsInfo( $condition, $arrAtts ); if( isset( $arrVisitorsInfo ) && is_array($arrVisitorsInfo) && count($arrVisitorsInfo) && isset( $arrVisitorsInfo[ $keyName ] ) ){ $column = array( __('Rank','wp-stats-manager'), $title, __('References','wp-stats-manager') ); $count = 1; foreach( $arrVisitorsInfo[ $keyName ] as $os_detail ){ $name = $os_detail['name']; if( !isset($arrAtts['icon']) ){ if( isset( $os_detail['deviceType'] ) && $os_detail['name'] != '-' ){ $name = sprintf( '%s %s', str_replace(' ','', strtolower($os_detail['deviceType'] )), WSM_URL, $os_detail['name'] , $os_detail['name'] , $os_detail['name'] ); } if( $keyName == __('OS','wp-stats-manager') && $os_detail['name'] != '-' ){ $name = sprintf( '%s %s', str_replace(' ','', strtolower($os_detail['name'] )), WSM_URL, $os_detail['name'] , $os_detail['name'] , $os_detail['name'] ); } if( $keyName == __('Browser','wp-stats-manager') && $os_detail['name'] != '-' ){ $name = sprintf( '%s %s', str_replace(' ','', strtolower($os_detail['name'] )), WSM_URL, $os_detail['name'] , $os_detail['name'] , $os_detail['name'] ); } } $rows[] = array( $count++, $name, number_format($os_detail['total']) );; if( $count == 6 ){ break; } } } return $this->generate_row_table( $column, $rows, $title.' '.__('Stats','wp-stats-manager') ); } function generate_row_table( $column, $rows, $title ){ $html = ''; if( isset( $rows) && is_array( $rows ) ){ $html .= sprintf( '

%s

', $title ); $html .= '
'; $html .= ''; foreach( $rows as $value ){ //$html .= ''; $html .= ''; $count = 1; foreach( $value as $td ){ $class = 'string'; $alogn = 'left'; $temp = str_replace(',','',$td); if( is_numeric( $temp ) ){ $class = 'integer'; $alogn = 'right'; } if( is_numeric( $temp ) && $count == 1 ){ $class = 'integer first_column'; $alogn = 'center'; } $count++; $html .= ''; } $html .= ''; } $html .= '
'.implode( '', $column ).'
'.implode( '', $value ).'
'.$td.'
'; } return $html; } function generate_table($data, $title){ $html = ''; if( isset( $data) && is_array( $data ) ){ $html .= sprintf( '

%s

', $title ); $html .= ''; foreach( $data as $key => $value ){ $html .= sprintf('', $key, $value ); } $html .= '
%s%s
'; } return $html; } function generate_section( $data, $title ){ $html = ''; $html .= '
'; foreach( $data as $key => $value ){ $html .= sprintf('', $key, $value ); } $html .= '
%s
%s
'; return $html; } function traffic_by_title_stats( $arrAtts ){ $html = do_shortcode("[".WSM_PREFIX."_showContentByURLStats content='byTitle' limit=10]"); echo $html; } function recent_visit_pages(){ $html = do_shortcode("[".WSM_PREFIX."_showRecentVisitedPages]"); echo $html; } function recent_active_visitors(){ $html = do_shortcode("[".WSM_PREFIX."_showMostActiveVisitorsGeo]"); echo $html; } } new wsmScheduledMail(); ?>