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();
}
