public function stats_30_days_box()
{
echo '<div class="charts-widget">';
cp_dashboard_charts();
echo '</div>';
}
function cp_dashboard()
{
global $wpdb, $app_edition, $app_rss_feed;
global $app_twitter_rss_feed, $app_forum_rss_feed, $options_dashboard;
$date_today = date('Y-m-d');
$date_yesterday = date('Y-m-d', strtotime('-1 days'));
$ad_counts = wp_count_posts(APP_POST_TYPE);
$ad_count_live = $ad_counts->publish;
$ad_count_pending = $ad_counts->pending;
$capabilities_meta = $wpdb->prefix . 'capabilities';
$ad_rev_total = $wpdb->get_var("SELECT sum(mc_gross) FROM {$wpdb->cp_order_info}");
$customers_today = $wpdb->get_var($wpdb->prepare("SELECT COUNT(ID) FROM {$wpdb->users} INNER JOIN {$wpdb->usermeta} ON {$wpdb->users}.ID = {$wpdb->usermeta}.user_id WHERE {$wpdb->usermeta}.meta_key = %s AND ({$wpdb->usermeta}.meta_value NOT LIKE %s) AND {$wpdb->users}.user_registered >= %s", $capabilities_meta, '%administrator%', $date_today));
$customers_yesterday = $wpdb->get_var($wpdb->prepare("SELECT COUNT(ID) FROM {$wpdb->users} INNER JOIN {$wpdb->usermeta} ON {$wpdb->users}.ID = {$wpdb->usermeta}.user_id WHERE {$wpdb->usermeta}.meta_key = %s AND ({$wpdb->usermeta}.meta_value NOT LIKE %s) AND {$wpdb->users}.user_registered BETWEEN %s AND %s", $capabilities_meta, '%administrator%', $date_yesterday, $date_today));
$countusers = count_users();
?>
<div class="wrap">
<div class="icon32" id="icon-themes"><br /></div>
<h2><?php
_e('ClassiPress Dashboard', APP_TD);
?>
</h2>
<?php
cp_admin_info_box();
?>
<div class="dash-left metabox-holder">
<div class="dash-wrap">
<div class="postbox">
<div class="statsico"></div>
<h3 class="hndle"><span><?php
_e('ClassiPress Info', APP_TD);
?>
</span></h3>
<div class="inside" id="boxy">
<?php
// $cp_edition = get_option('cp_edition');
$cp_version = get_option('cp_version');
?>
<div class="stats-info">
<ul>
<li><?php
_e('Total Live Ads', APP_TD);
?>
: <a href="edit.php?post_status=publish&post_type=<?php
echo APP_POST_TYPE;
?>
"><strong><?php
echo $ad_count_live;
?>
</strong></a></li>
<li><?php
_e('Total Pending Ads', APP_TD);
?>
: <a href="edit.php?post_status=pending&post_type=<?php
echo APP_POST_TYPE;
?>
"><strong><?php
echo $ad_count_pending;
?>
</strong></a></li>
<li><?php
_e('Total Users', APP_TD);
?>
: <a href="users.php?orderby=id&order=desc"><strong><?php
echo number_format_i18n($countusers['total_users']);
?>
</strong></a></li>
<li><?php
_e('Total Revenue', APP_TD);
?>
: <strong><?php
cp_display_price($ad_rev_total);
?>
</strong></li>
<li><?php
_e('Product Support', APP_TD);
?>
: <a href="http://forums.appthemes.com/" target="_blank"><?php
_e('Forum', APP_TD);
?>
</a> | <a href="http://docs.appthemes.com/" target="_blank"><?php
_e('Documentation', APP_TD);
?>
</a></li>
</ul>
</div>
<div class="stats_overview">
<h3><?php
_e('New Registrations', APP_TD);
?>
</h3>
<div class="overview_today">
<p class="overview_day"><?php
_e('Today', APP_TD);
?>
</p>
<p class="overview_count"><?php
echo number_format_i18n($customers_today);
?>
</p>
<p class="overview_type"><em><?php
_e('Customers', APP_TD);
?>
</em></p>
</div>
<div class="overview_previous">
<p class="overview_day"><?php
_e('Yesterday', APP_TD);
?>
</p>
<p class="overview_count"><?php
echo number_format_i18n($customers_yesterday);
?>
</p>
<p class="overview_type"><em><?php
_e('Customers', APP_TD);
?>
</em></p>
</div>
</div>
</div><!-- /inside -->
<div class="clear"></div>
</div> <!-- /postbox -->
<div class="postbox">
<div class="newspaperico"></div><a target="_new" href="<?php
echo $app_rss_feed;
?>
"><div class="rssico"></div></a>
<h3 class="hndle" id="poststuff"><span><?php
_e('Latest News', APP_TD);
?>
</span></h3>
<div class="inside" id="boxy">
<?php
appthemes_dashboard_appthemes();
?>
</div> <!-- /inside -->
</div> <!-- /postbox -->
</div> <!-- /dash-wrap -->
</div> <!-- /dash-left -->
<div class="dash-right metabox-holder">
<div class="dash-wrap">
<div class="postbox">
<div class="statsico"></div>
<h3 class="hndle" id="poststuff"><span><?php
_e('Stats - Last 30 Days', APP_TD);
?>
</span></h3>
<div class="inside" id="boxy">
<?php
cp_dashboard_charts();
?>
</div> <!-- /inside -->
</div> <!-- /postbox -->
<div class="postbox">
<div class="twitterico"></div><a target="_new" href="<?php
echo $app_twitter_rss_feed;
?>
"><div class="rssico"></div></a>
<h3 class="hndle" id="poststuff"><span><?php
_e('Latest Tweets', APP_TD);
?>
</span></h3>
<div class="inside" id="boxy">
<?php
appthemes_dashboard_twitter();
?>
</div> <!-- /inside -->
</div> <!-- /postbox -->
<div class="postbox">
<div class="forumico"></div><a target="_new" href="<?php
echo $app_forum_rss_feed;
?>
"><div class="rssico"></div></a>
<h3 class="hndle" id="poststuff"><span><?php
_e('Support Forum', APP_TD);
?>
</span></h3>
<div class="inside" id="boxy">
<?php
appthemes_dashboard_forum();
?>
</div> <!-- /inside -->
</div> <!-- /postbox -->
</div> <!-- /dash-wrap -->
</div> <!-- /dash-right -->
</div> <!-- /wrap -->
<?php
}
function cp_dashboard()
{
global $wpdb, $app_edition, $app_rss_feed;
global $app_twitter_rss_feed, $app_forum_rss_feed, $options_dashboard;
$date_today = date('Y-m-d');
$date_yesterday = date('Y-m-d', strtotime('-1 days'));
$ad_counts = wp_count_posts(APP_POST_TYPE);
$ad_count_live = $ad_counts->publish;
$ad_count_pending = $ad_counts->pending;
$capabilities_meta = $wpdb->prefix . 'capabilities';
$ad_rev_total = $wpdb->get_var($wpdb->prepare("SELECT sum(mc_gross) FROM {$wpdb->cp_order_info}"));
$customers_today = $wpdb->get_var($wpdb->prepare("SELECT COUNT(ID) FROM {$wpdb->users} INNER JOIN {$wpdb->usermeta} ON {$wpdb->users}.ID = {$wpdb->usermeta}.user_id WHERE {$wpdb->usermeta}.meta_key = %s AND ({$wpdb->usermeta}.meta_value NOT LIKE %s) AND {$wpdb->users}.user_registered >= %s", $capabilities_meta, '%administrator%', $date_today));
$customers_yesterday = $wpdb->get_var($wpdb->prepare("SELECT COUNT(ID) FROM {$wpdb->users} INNER JOIN {$wpdb->usermeta} ON {$wpdb->users}.ID = {$wpdb->usermeta}.user_id WHERE {$wpdb->usermeta}.meta_key = %s AND ({$wpdb->usermeta}.meta_value NOT LIKE %s) AND {$wpdb->users}.user_registered BETWEEN %s AND %s", $capabilities_meta, '%administrator%', $date_yesterday, $date_today));
$countusers = count_users();
?>
<div class="wrap">
<div class="icon32" id="icon-themes"><br /></div>
<h2><?php
_e('ClassiPress Dashboard', 'appthemes');
?>
</h2>
<div style="background-color:red" width="700px">
<label>Raporlama Buraya Gelicek</label>
</div>
<?php
cp_admin_info_box();
?>
<div class="dash-left metabox-holder">
<div class="dash-wrap">
<div class="postbox">
<div class="statsico"></div>
<h3 class="hndle"><span><?php
_e('ClassiPress Info', 'appthemes');
?>
</span></h3>
<div class="inside" id="boxy">
<?php
// $cp_edition = get_option('cp_edition');
$cp_version = get_option('cp_version');
?>
<div class="stats-info">
<ul>
<li><?php
_e('Total Live Ads', 'appthemes');
?>
: <a href="edit.php?post_status=publish&post_type=<?php
echo APP_POST_TYPE;
?>
"><strong><?php
echo $ad_count_live;
?>
</strong></a></li>
<li><?php
_e('Total Pending Ads', 'appthemes');
?>
: <a href="edit.php?post_status=pending&post_type=<?php
echo APP_POST_TYPE;
?>
"><strong><?php
echo $ad_count_pending;
?>
</strong></a></li>
<li><?php
_e('Total Users', 'appthemes');
?>
: <a href="users.php?orderby=id&order=desc"><strong><?php
echo number_format_i18n($countusers['total_users']);
?>
</strong></a></li>
</ul>
</div>
<div class="stats_overview">
<h3><?php
_e('New Registrations', 'appthemes');
?>
</h3>
<div class="overview_today">
<p class="overview_day"><?php
_e('Today', 'appthemes');
?>
</p>
<p class="overview_count"><?php
echo number_format_i18n($customers_today);
?>
</p>
<p class="overview_type"><em><?php
_e('Customers', 'appthemes');
?>
</em></p>
</div>
<div class="overview_previous">
<p class="overview_day"><?php
_e('Yesterday', 'appthemes');
?>
</p>
<p class="overview_count"><?php
echo number_format_i18n($customers_yesterday);
?>
</p>
<p class="overview_type"><em><?php
_e('Customers', 'appthemes');
?>
</em></p>
</div>
</div>
</div><!-- /inside -->
<div class="clear"></div><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/>
</div> <!-- /postbox -->
</div> <!-- /dash-wrap -->
</div> <!-- /dash-left -->
<div class="dash-right metabox-holder">
<div class="dash-wrap">
<div class="postbox">
<div class="statsico"></div>
<h3 class="hndle" id="poststuff"><span><?php
_e('Stats - Last 30 Days', 'appthemes');
?>
</span></h3>
<div class="inside" id="boxy">
<?php
cp_dashboard_charts();
?>
</div> <!-- /inside -->
</div> <!-- /postbox -->
</div> <!-- /dash-wrap -->
</div> <!-- /dash-right -->
</div> <!-- /wrap -->
<?php
}
