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 }