Exemplo n.º 1
0
function ProjectTheme_my_account_completed_projects_area_function()
{
    global $current_user, $wpdb, $wp_query;
    get_currentuserinfo();
    $uid = $current_user->ID;
    ?>
    	<div id="content" class="account-main-area">
        
        
         
				
                
                <?php 
    global $current_user;
    get_currentuserinfo();
    $uid = $current_user->ID;
    global $wp_query, $wpdb;
    $query_vars = $wp_query->query_vars;
    $post_per_page = 10;
    $querystr = "\n                        SELECT p.ID \n                        FROM {$wpdb->posts} AS p\n                        LEFT JOIN {$wpdb->prefix}project_bids AS pb ON p.ID = pb.pid\n                        WHERE   p.post_author = '{$uid}'\n                            AND pb.winner = '1'\n                            AND pb.paid = '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("There are no completed projects yet.", 'ProjectTheme');
        echo '</div>  </div> ';
    } else {
        //				$paid = array(
        //						'key' => 'paid_user',
        //						'value' => "1",
        //						'compare' => '='
        //					);
        //
        //				$args = array('post_type' => 'project','author' => $uid, 'order' => 'DESC', 'orderby' => 'date', 'posts_per_page' => $post_per_page,
        //				'paged' => $query_vars['paged'], 'meta_query' => array($paid));
        $args = array('post_type' => 'project', 'author' => $uid, '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_paid();
            }
            if (function_exists('wp_pagenavi')) {
                wp_pagenavi();
            }
        } else {
            echo '<div class="my_box3 border_bottom_0"> <div class="box_content">   ';
            _e("There are no completed projects yet.", 'ProjectTheme');
            echo '</div>  </div> ';
        }
        wp_reset_query();
    }
    ?>
        
   
        
  		</div>      
<?php 
    ProjectTheme_get_users_links();
}
Exemplo n.º 2
0
function ProjectTheme_my_account_completed_projects_area_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("Completed Payments", 'ProjectTheme');
    ?>
</div>
                <div class="box_content">    
				
                
                <?php 
    global $current_user;
    get_currentuserinfo();
    $uid = $current_user->ID;
    global $wp_query;
    $query_vars = $wp_query->query_vars;
    $post_per_page = 10;
    $paid = array('key' => 'paid_user', 'value' => "1", 'compare' => '=');
    $args = array('post_type' => 'project', 'author' => $uid, 'order' => 'DESC', 'orderby' => 'date', 'posts_per_page' => $post_per_page, 'pages' => $query_vars['paged'], 'meta_query' => array($paid));
    query_posts($args);
    if (have_posts()) {
        while (have_posts()) {
            the_post();
            projectTheme_get_post_paid();
        }
        if (function_exists('wp_pagenavi')) {
            wp_pagenavi();
        }
    } else {
        _e("There are no completed projects yet.", 'ProjectTheme');
    }
    wp_reset_query();
    ?>
        
        </div> </div>
        
  		</div>      
<?php 
    ProjectTheme_get_users_links();
}