function ProjectTheme_my_account_area_awaiting_payments_function() { global $current_user, $wpdb, $wp_query; get_currentuserinfo(); $uid = $current_user->ID; ?> <div id="content"> <div class="my_box3 border_bottom_0"> <div class="box_title"><?php _e("Awaiting Payments", 'ProjectTheme'); ?> </div> <div class="box_content"> <?php global $wp_query; $query_vars = $wp_query->query_vars; $post_per_page = 10; $delivered = array('key' => 'delivered', 'value' => "1", 'compare' => '='); $paid = array('key' => 'paid_user', 'value' => "0", 'compare' => '='); $winner = array('key' => 'winner', 'value' => $uid, 'compare' => '='); $args = array('post_type' => 'project', 'order' => 'DESC', 'orderby' => 'date', 'posts_per_page' => $post_per_page, 'paged' => $query_vars['paged'], 'meta_query' => array($delivered, $paid, $winner)); query_posts($args); if (have_posts()) { while (have_posts()) { the_post(); projectTheme_get_post_awaiting_payment(); } if (function_exists('wp_pagenavi')) { wp_pagenavi(); } } else { _e("There are no projects yet.", 'ProjectTheme'); } wp_reset_query(); ?> </div> </div> </div> <?php ProjectTheme_get_users_links(); }
function ProjectTheme_my_account_area_awaiting_payments_function() { global $current_user, $wpdb, $wp_query; get_currentuserinfo(); $uid = $current_user->ID; ?> <div id="content" class="account-main-area"> <?php global $wp_query, $wpdb; $query_vars = $wp_query->query_vars; $post_per_page = 10; $querystr = "\n SELECT distinct p.ID \n FROM {$wpdb->posts} AS p\n LEFT JOIN {$wpdb->prefix}project_bids AS pb ON p.ID = pb.pid\n WHERE pb.uid = '{$uid}'\n AND pb.winner = '1'\n AND pb.paid = '0'\n AND pb.delivered = '1'\n AND p.post_type = 'project' "; $pageposts = $wpdb->get_col($querystr); if (empty($pageposts)) { echo '<div class="my_box3 border_bottom_0"> <div class="box_content"> '; _e("You do not have any awaiting payments yet.", 'ProjectTheme'); echo '</div> </div> '; } else { // $delivered = array( // 'key' => 'delivered', // 'value' => "1", // 'compare' => '=' // ); // // $paid = array( // 'key' => 'paid_user', // 'value' => "0", // 'compare' => '=' // ); // // $winner = array( // 'key' => 'winner', // 'value' => $uid, // 'compare' => '=' // ); // // // $args = array('post_type' => 'project', 'order' => 'DESC', 'orderby' => 'date', 'posts_per_page' => $post_per_page, // 'paged' => $query_vars['paged'], 'meta_query' => array($delivered, $paid, $winner)); $args = array('post_type' => 'project', 'order' => 'DESC', 'orderby' => 'date', 'posts_per_page' => $post_per_page, 'paged' => $query_vars['paged'], 'post__in' => $pageposts); query_posts($args); if (have_posts()) { while (have_posts()) { the_post(); projectTheme_get_post_awaiting_payment(); } if (function_exists('wp_pagenavi')) { wp_pagenavi(); } } else { echo '<div class="my_box3 border_bottom_0"> <div class="box_content"> '; _e("You do not have any awaiting payments yet.", 'ProjectTheme'); echo '</div> </div> '; } wp_reset_query(); } ?> </div> <?php ProjectTheme_get_users_links(); }