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 jr_dashboard()
{
global $wpdb, $app_rss_feed, $app_twitter_rss_feed, $app_forum_rss_feed, $options_dashboard, $app_version;
$date_today = date('Y-m-d');
$date_yesterday = date('Y-m-d', strtotime('-1 days'));
$job_count_live = $wpdb->get_var($wpdb->prepare("SELECT count(ID) FROM {$wpdb->posts} WHERE post_status = 'publish' AND post_type = '" . APP_POST_TYPE . "'"));
$resume_count_live = $wpdb->get_var($wpdb->prepare("SELECT count(ID) FROM {$wpdb->posts} WHERE post_status = 'publish' AND post_type = '" . APP_POST_TYPE_RESUME . "'"));
$job_count_pending = $wpdb->get_var($wpdb->prepare("SELECT count(ID) FROM {$wpdb->posts} WHERE post_status = 'pending' AND post_type = '" . APP_POST_TYPE . "'"));
$job_rev_total = $wpdb->get_var($wpdb->prepare("SELECT sum(cost) FROM {$wpdb->prefix}" . 'jr_orders' . " WHERE status = 'completed'"));
$job_seekers_today = $wpdb->get_var("SELECT COUNT(ID) FROM {$wpdb->users} INNER JOIN {$wpdb->usermeta} ON {$wpdb->users}.ID = {$wpdb->usermeta}.user_id WHERE {$wpdb->usermeta}.meta_key = 'wp_capabilities' AND ({$wpdb->usermeta}.meta_value LIKE '%job_seeker%') AND {$wpdb->users}.user_registered >= '{$date_today}'");
$job_listers_today = $wpdb->get_var("SELECT COUNT(ID) FROM {$wpdb->users} INNER JOIN {$wpdb->usermeta} ON {$wpdb->users}.ID = {$wpdb->usermeta}.user_id WHERE {$wpdb->usermeta}.meta_key = 'wp_capabilities' AND ({$wpdb->usermeta}.meta_value LIKE '%job_lister%') AND {$wpdb->users}.user_registered >= '{$date_today}'");
$job_seekers_yesterday = $wpdb->get_var("SELECT COUNT(ID) FROM {$wpdb->users} INNER JOIN {$wpdb->usermeta} ON {$wpdb->users}.ID = {$wpdb->usermeta}.user_id WHERE {$wpdb->usermeta}.meta_key = 'wp_capabilities' AND ({$wpdb->usermeta}.meta_value LIKE '%job_seeker%') AND {$wpdb->users}.user_registered BETWEEN '{$date_yesterday}' AND '{$date_today}'");
$job_listers_yesterday = $wpdb->get_var("SELECT COUNT(ID) FROM {$wpdb->users} INNER JOIN {$wpdb->usermeta} ON {$wpdb->users}.ID = {$wpdb->usermeta}.user_id WHERE {$wpdb->usermeta}.meta_key = 'wp_capabilities' AND ({$wpdb->usermeta}.meta_value LIKE '%job_lister%') AND {$wpdb->users}.user_registered BETWEEN '{$date_yesterday}' AND '{$date_today}'");
$total_users = $wpdb->get_var("SELECT COUNT(ID) FROM {$wpdb->users}");
?>
<div class="wrap jobroller">
<div class="icon32" id="icon-themes"><br/></div>
<h2><?php
_e('JobRoller Dashboard', 'appthemes');
?>
</h2>
<div class="dash-left metabox-holder">
<div class="postbox">
<div class="statsico"></div>
<h3 class="hndle"><span><?php
_e('JobRoller Info', 'appthemes');
?>
</span></h3>
<div class="preloader-container">
<div class="insider" id="boxy">
<div class="stats-info">
<ul>
<li><?php
_e('Total Live Jobs', 'appthemes');
?>
: <a href="edit.php?post_status=publish&post_type=job_listing"><strong><?php
echo number_format_i18n($job_count_live);
?>
</strong></a></li>
<li><?php
_e('Total Pending Jobs', 'appthemes');
?>
: <a href="edit.php?post_status=pending&post_type=job_listing"><strong><?php
echo number_format_i18n($job_count_pending);
?>
</strong></a></li>
<li><?php
_e('Total Live Resumes', 'appthemes');
?>
: <a href="edit.php?post_status=publish&post_type=resume"><strong><?php
echo number_format_i18n($resume_count_live);
?>
</strong></a></li>
<li><?php
_e('Total Users', 'appthemes');
?>
: <a href="users.php"><strong><?php
echo number_format_i18n($total_users);
?>
</strong></a></li>
<li><?php
_e('Total Revenue', 'appthemes');
?>
: <strong><?php
echo jr_get_currency(number_format($job_rev_total, 2));
?>
</strong></li>
<li><?php
_e('Product Version', 'appthemes');
?>
: <strong><?php
echo $app_version;
?>
</strong></li>
<li><?php
_e('Product Support', 'appthemes');
?>
: <a href="http://forums.appthemes.com/" target="_new"><?php
_e('Forum', 'appthemes');
?>
</a> | <a href="http://www.appthemes.com/support/docs/" target="_new"><?php
_e('Documentation', 'appthemes');
?>
</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($job_listers_today);
?>
</p>
<p class="overview_type"><em><?php
_e('Job Listers', 'appthemes');
?>
</em></p>
<p class="overview_count"><?php
echo number_format_i18n($job_seekers_today);
?>
</p>
<p class="overview_type_seek"><em><?php
_e('Job Seekers', '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($job_listers_yesterday);
?>
</p>
<p class="overview_type"><em><?php
_e('Job Listers', 'appthemes');
?>
</em></p>
<p class="overview_count"><?php
echo number_format_i18n($job_seekers_yesterday);
?>
</p>
<p class="overview_type_seek"><em><?php
_e('Job Seekers', 'appthemes');
?>
</em></p>
</div>
</div>
<div class="clear"></div>
</div>
</div>
</div> <!-- postbox end -->
<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', 'appthemes');
?>
</span></h3>
<div class="preloader-container">
<div class="insider" id="boxy">
<?php
appthemes_dashboard_appthemes();
?>
</div> <!-- inside end -->
</div>
</div> <!-- postbox end -->
</div> <!-- dash-left end -->
<div class="dash-right metabox-holder">
<div class="postbox">
<div class="statsico"></div>
<h3 class="hndle" id="poststuff"><span><?php
_e('Stats - Last 30 Days', 'appthemes');
?>
</span></h3>
<div class="preloader-container">
<div class="insider" id="boxy">
<?php
jr_dashboard_charts();
?>
</div> <!-- inside end -->
</div>
</div> <!-- postbox end -->
<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', 'appthemes');
?>
</span></h3>
<div class="preloader-container">
<div class="insider" id="boxy">
<?php
appthemes_dashboard_twitter();
?>
</div> <!-- inside end -->
</div>
</div> <!-- postbox end -->
<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', 'appthemes');
?>
</span></h3>
<div class="preloader-container">
<div class="insider" id="boxy">
<?php
appthemes_dashboard_forum();
?>
</div> <!-- inside end -->
</div>
</div> <!-- postbox end -->
</div> <!-- dash-right end -->
</div> <!-- /wrap -->
<?php
}
