function ProjectTheme_my_account_outstanding_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("Outstanding Projects", '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; $outstanding = array('key' => 'outstanding', 'value' => "1", '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($outstanding, $winner)); query_posts($args); if (have_posts()) { while (have_posts()) { the_post(); projectTheme_get_post_outstanding_project(); } if (function_exists('wp_pagenavi')) { wp_pagenavi(); } } else { _e("There are no outstanding projects yet.", 'ProjectTheme'); } wp_reset_query(); ?> </div> </div> </div> <?php ProjectTheme_get_users_links(); }
function ProjectTheme_my_account_area_main_function() { global $current_user, $wp_query; get_currentuserinfo(); $uid = $current_user->ID; ?> <div id="content" class="account-main-area"> <?php if (isset($_GET['prj_not_approved'])) { $psts = get_post($_GET['prj_not_approved']); ?> <div class="saved_thing"> <?php echo sprintf(__('Your payment was received for the item: <b>%s</b> but your project needs to be approved. You will be notified when your project will be approved and live on our website', 'ProjectTheme'), $psts->post_title); ?> </div> <?php } if (ProjectTheme_is_user_business($uid)) { ?> <div class="box_title"><?php _e("My Latest Posted Projects", "ProjectTheme"); ?> </div> <?php global $wp_query; $query_vars = $wp_query->query_vars; $post_per_page = 5; $closed = array('key' => 'closed', 'value' => "0", 'compare' => '='); $paid = array('key' => 'paid', 'value' => "1", 'compare' => '='); $args = array('post_type' => 'project', 'author' => $uid, 'order' => 'DESC', 'orderby' => 'date', 'posts_per_page' => $post_per_page, 'paged' => 1, 'meta_query' => array($paid, $closed), 'post_status' => array('draft', 'publish')); query_posts($args); // query_posts( "meta_key=closed&meta_value=0&post_status=publish,draft&post_type=project&order=DESC&orderby=date&author=".$uid. // "&posts_per_page=".$post_per_page."&paged=".$query_vars['paged'] ); if (have_posts()) { while (have_posts()) { the_post(); projectTheme_get_post_acc(); } //if(function_exists('wp_pagenavi')): //wp_pagenavi(); endif; } else { echo '<div class="my_box3"> <div class="box_content"> '; _e("There are no projects yet.", 'ProjectTheme'); echo '</div></div>'; } wp_reset_query(); ?> <div class="box_title"><?php _e("My Unpublished & Unpaid Projects", 'ProjectTheme'); ?> </div> <?php query_posts("post_status=draft&meta_key=paid&meta_value=0&post_type=project&order=DESC&orderby=id&author=" . $uid . "&posts_per_page=3"); if (have_posts()) { while (have_posts()) { the_post(); projectTheme_get_post_acc(array('unpaid')); } } else { echo '<div class="my_box3"><div class="box_content">'; _e("There are no projects yet.", 'ProjectTheme'); echo '</div></div>'; } wp_reset_query(); ?> <div class="clear10"></div> <div class="box_title"><?php _e("My Latest Closed Projects", 'ProjectTheme'); ?> </div> <?php query_posts("meta_key=closed&meta_value=1&post_type=project&order=DESC&orderby=id&author=" . $uid . "&posts_per_page=3"); if (have_posts()) { while (have_posts()) { the_post(); projectTheme_get_post_acc(); } } else { echo '<div class="my_box3"><div class="box_content">'; _e("There are no projects yet.", 'ProjectTheme'); echo '</div></div>'; } wp_reset_query(); ?> <?php } ?> <?php if (ProjectTheme_is_user_provider($uid)) { ?> <div class="box_title"><?php _e("Outstanding Projects", 'ProjectTheme'); ?> </div> <?php global $wp_query; $query_vars = $wp_query->query_vars; $post_per_page = 3; $outstanding = array('key' => 'outstanding', 'value' => "1", 'compare' => '='); $winner = array('key' => 'winner', 'value' => $uid, 'compare' => '='); $args = array('post_type' => 'project', 'order' => 'DESC', 'orderby' => 'date', 'posts_per_page' => $post_per_page, 'paged' => 1, 'meta_query' => array($outstanding, $winner)); query_posts($args); if (have_posts()) { while (have_posts()) { the_post(); projectTheme_get_post_outstanding_project(); } } else { echo '<div class="my_box3"><div class="box_content">'; _e("There are no projects yet.", 'ProjectTheme'); echo '</div></div>'; } wp_reset_query(); ?> <div class="box_title"><?php _e("My Latest Posted Proposals", 'ProjectTheme'); ?> </div> <?php query_posts("meta_key=bid&meta_value=" . $uid . "&post_type=project&order=DESC&orderby=id&posts_per_page=3"); if (have_posts()) { while (have_posts()) { the_post(); projectTheme_get_post_my_proposal(); } } else { echo '<div class="my_box3"><div class="box_content">'; _e("There are no projects yet.", 'ProjectTheme'); echo '</div></div>'; } wp_reset_query(); ?> <div class="box_title"><?php _e("My Latest Won Projects", 'ProjectTheme'); ?> </div> <?php query_posts("meta_key=winner&meta_value=" . $uid . "&post_type=project&order=DESC&orderby=id&posts_per_page=3"); if (have_posts()) { while (have_posts()) { the_post(); projectTheme_get_post(); } } else { echo '<div class="my_box3"><div class="box_content">'; _e("There are no projects yet.", 'ProjectTheme'); echo '</div></div>'; } wp_reset_query(); ?> <?php } ?> </div> <!-- end dif content --> <?php ProjectTheme_get_users_links(); ?> <?php }
function ProjectTheme_my_account_outstanding_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, $wpdb; get_currentuserinfo(); $uid = $current_user->ID; global $wp_query; $query_vars = $wp_query->query_vars; $post_per_page = 10; // $querystr = " // SELECT distinct wposts.ID // FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta2, $wpdb->postmeta wpostmeta3 // LEFT JOIN {$wpdb->prefix}project_bids AS b ON wposts.ID = b.pid // WHERE // b.uid = '$uid' AND b.outstanding = '1' // AND wposts.ID = wpostmeta2.post_id AND // wpostmeta2.meta_key='winner' AND wpostmeta2.meta_value='$uid' AND // wposts.ID = wpostmeta3.post_id AND // wpostmeta3.meta_key='outstanding' AND wpostmeta3.meta_value='1' // AND wposts.post_type = 'project' AND wposts.post_status = 'publish' "; $querystr = "\n\t\t\t\t\tSELECT p.ID\n FROM {$wpdb->posts} AS p\n LEFT JOIN {$wpdb->prefix}project_bids AS b ON p.ID = b.pid\n LEFT JOIN {$wpdb->prefix}postmeta AS wpostmeta2 ON p.ID = wpostmeta2.post_id\n LEFT JOIN {$wpdb->prefix}postmeta AS wpostmeta3 ON p.ID = wpostmeta3.post_id\n WHERE \n b.uid = '916' AND b.outstanding = '1'\n AND wpostmeta2.meta_key='winner' AND wpostmeta2.meta_value='916'\n AND wpostmeta3.meta_key='outstanding' AND wpostmeta3.meta_value='1' \n AND p.post_type = 'project' AND p.post_status = 'publish' "; $pageposts = $wpdb->get_col($querystr); if (empty($pageposts)) { echo '<div class="my_box3 border_bottom_0"> <div class="box_content"> '; _e("There are no outstanding projects yet.", 'ProjectTheme'); echo '</div> </div> '; } else { // $outstanding = array( // 'key' => 'outstanding', // 'value' => "1", // '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($outstanding, $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_outstanding_project(); } if (function_exists('wp_pagenavi')) { wp_pagenavi(); } } else { echo '<div class="my_box3 border_bottom_0"> <div class="box_content"> '; _e("There are no outstanding projects yet.", 'ProjectTheme'); echo '</div> </div> '; } } wp_reset_query(); ?> </div> <?php ProjectTheme_get_users_links(); }
function ProjectTheme_my_account_area_main_function() { global $current_user, $wp_query; get_currentuserinfo(); $uid = $current_user->ID; ?> <div id="content"> <?php if (ProjectTheme_is_user_business($uid)) { ?> <div class="my_box3"> <div class="box_title"><?php _e("Your Latest Posted Projects", "ProjectTheme"); ?> </div> <div class="box_content "> <?php $query_vars = $wp_query->query_vars; $post_per_page = 3; global $wp_query; $query_vars = $wp_query->query_vars; $post_per_page = 5; $closed = array('key' => 'closed', 'value' => "0", 'compare' => '='); $paid = array('key' => 'paid', 'value' => "1", 'compare' => '='); $args = array('post_type' => 'project', 'author' => $uid, 'order' => 'DESC', 'orderby' => 'date', 'posts_per_page' => $post_per_page, 'paged' => 1, 'meta_query' => array($paid, $closed), 'post_status' => array('draft', 'publish')); query_posts($args); // query_posts( "meta_key=closed&meta_value=0&post_status=publish,draft&post_type=project&order=DESC&orderby=date&author=".$uid. // "&posts_per_page=".$post_per_page."&paged=".$query_vars['paged'] ); if (have_posts()) { while (have_posts()) { the_post(); projectTheme_get_post(); } //if(function_exists('wp_pagenavi')): //wp_pagenavi(); endif; } else { _e("There are no projects yet.", 'ProjectTheme'); } wp_reset_query(); ?> </div> </div> <div class="my_box3"> <div class="box_title"><?php _e("My Unpublished & Unpaid Projects", 'ProjectTheme'); ?> </div> <div class="box_content"> <?php query_posts("post_status=draft&meta_key=paid&meta_value=0&post_type=project&order=DESC&orderby=id&author=" . $uid . "&posts_per_page=3"); if (have_posts()) { while (have_posts()) { the_post(); projectTheme_get_post(array('unpaid')); } } else { _e("There are no projects yet.", 'ProjectTheme'); } wp_reset_query(); ?> </div> </div> <div class="clear10"></div> <div class="my_box3"> <div class="box_title"><?php _e("My Latest Closed Projects", 'ProjectTheme'); ?> </div> <div class="box_content"> <?php query_posts("meta_key=closed&meta_value=1&post_type=project&order=DESC&orderby=id&author=" . $uid . "&posts_per_page=3"); if (have_posts()) { while (have_posts()) { the_post(); projectTheme_get_post(); } } else { _e("There are no projects yet.", 'ProjectTheme'); } wp_reset_query(); ?> </div> </div> <?php } ?> <?php if (ProjectTheme_is_user_provider($uid)) { ?> <div class="my_box3"> <div class="box_title"><?php _e("Outstanding Projects", 'ProjectTheme'); ?> </div> <div class="box_content"> <?php global $wp_query; $query_vars = $wp_query->query_vars; $post_per_page = 3; $outstanding = array('key' => 'outstanding', 'value' => "1", 'compare' => '='); $winner = array('key' => 'winner', 'value' => $uid, 'compare' => '='); $args = array('post_type' => 'project', 'order' => 'DESC', 'orderby' => 'date', 'posts_per_page' => $post_per_page, 'paged' => 1, 'meta_query' => array($outstanding, $winner)); query_posts($args); if (have_posts()) { while (have_posts()) { the_post(); projectTheme_get_post_outstanding_project(); } } else { _e("There are no projects yet.", 'ProjectTheme'); } wp_reset_query(); ?> </div> </div> <div class="my_box3"> <div class="box_title"><?php _e("My Latest Bids", 'ProjectTheme'); ?> </div> <div class="box_content"> <?php query_posts("meta_key=bid&meta_value=" . $uid . "&post_type=project&order=DESC&orderby=id&posts_per_page=3"); if (have_posts()) { while (have_posts()) { the_post(); projectTheme_get_post(); } } else { _e("There are no projects yet.", 'ProjectTheme'); } wp_reset_query(); ?> </div> </div> <div class="my_box3"> <div class="box_title"><?php _e("My Latest Won Projects", 'ProjectTheme'); ?> </div> <div class="box_content"> <?php query_posts("meta_key=winner&meta_value=" . $uid . "&post_type=project&order=DESC&orderby=id&posts_per_page=3"); if (have_posts()) { while (have_posts()) { the_post(); projectTheme_get_post(); } } else { _e("There are no projects yet.", 'ProjectTheme'); } wp_reset_query(); ?> </div> </div> <?php } ?> </div> <!-- end dif content --> <?php ProjectTheme_get_users_links(); ?> <?php }