function ProjectTheme_get_users_links()
{
global $current_user, $wpdb;
get_currentuserinfo();
$rd = projectTheme_get_unread_number_messages($current_user->ID);
if ($rd > 0) {
$ssk = "<span class='notif_a'>" . $rd . "</span>";
} else {
$ssk = '';
}
$uid = $current_user->ID;
//-----------------------
$query = "select id from " . $wpdb->prefix . "project_ratings where fromuser='******' AND awarded='0'";
$r = $wpdb->get_results($query);
$ttl_fdbks = count($r);
if ($ttl_fdbks > 0) {
$ttl_fdbks2 = "<span class='notif_a'>" . $ttl_fdbks . "</span>";
}
$ProjectTheme_enable_2_user_tp = get_option('ProjectTheme_enable_2_user_tp');
$user_tp = get_user_meta($uid, 'user_tp', true);
?>
<div id="right-sidebar" class="account-sidebar">
<ul class="xoxo">
<li class="widget-container widget_text">
<p>
<ul id="my-account-admin-menu">
<li><a href="<?php
echo projectTheme_my_account_link();
?>
" <?php
echo $current_page == "home" ? "class='active'" : "";
?>
><?php
_e("MyAccount Home", 'ProjectTheme');
?>
</a></li>
<?php
$pmnts_lnk = get_permalink(get_option('ProjectTheme_my_account_payments_id'));
$pmnts_lnk = apply_filters('ProjectTheme_my_account_payments_id_link', $pmnts_lnk);
$ProjectTheme_enable_credits_wallet = get_option('ProjectTheme_enable_credits_wallet');
if ($ProjectTheme_enable_credits_wallet != 'no') {
?>
<li><a href="<?php
echo $pmnts_lnk;
?>
"><?php
_e("Finances", 'ProjectTheme');
?>
</a></li>
<?php
}
?>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_private_messages_id'));
?>
"><?php
echo sprintf(__("Private Messages %s", 'ProjectTheme'), $ssk);
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_personal_info_id'));
?>
"><?php
_e("Personal Info", 'ProjectTheme');
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_feedback_id'));
?>
"><?php
printf(__("Feedback/Reviews %s", 'ProjectTheme'), $ttl_fdbks2);
?>
</a></li>
<?php
do_action('ProjectTheme_my_account_main_menu');
?>
</ul>
</p>
</li>
<!-- ###### -->
<?php
if (ProjectTheme_is_user_business($uid)) {
?>
<li class="widget-container widget_text"><h3 class="widget-title"><?php
_e("Project Owner Menu", 'ProjectTheme');
?>
</h3>
<p>
<?php
global $wpdb;
// $querystr = "
//
// SELECT distinct wposts.ID
//
// FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta2, $wpdb->postmeta wpostmeta3
//
// WHERE wposts.post_author='$uid' AND wposts.ID = wpostmeta2.post_id
//
// AND wpostmeta2.meta_key='paid_user' AND wpostmeta2.meta_value='0'
//
//
//
// AND wposts.ID = wpostmeta3.post_id AND
//
// wpostmeta3.meta_key='delivered' AND wpostmeta3.meta_value='1'
//
//
//
// AND wposts.post_type = 'project' ";
$querystr = "\n\n\t\t\t\t\tSELECT distinct p.ID \n \n FROM {$wpdb->posts} AS p\n \n LEFT JOIN " . $wpdb->prefix . "project_bids AS pb ON p.ID = pb.pid\n \n WHERE p.post_author = '{$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_results($querystr, OBJECT);
$ttl_prj = count($pageposts);
if ($ttl_prj > 0) {
$scn = "<span class='notif_a'>" . $ttl_prj . "</span>";
}
//------------------------------------------------
/*$querystr = "
SELECT distinct wposts.ID
FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta2
WHERE wposts.post_author='$uid' AND wposts.ID = wpostmeta2.post_id AND
wpostmeta2.meta_key='paid' AND wpostmeta2.meta_value='0' AND wposts.post_type = 'project' AND wposts.post_status = 'draft' ";*/
$querystr = "\n\n\t\t\t\t\tSELECT distinct wposts.ID \n\n\t\t\t\t\tFROM {$wpdb->posts} wposts\n\n\t\t\t\t\tWHERE wposts.post_author='{$uid}' AND wposts.post_type = 'project' AND wposts.post_status = 'draft' ";
$pageposts = $wpdb->get_results($querystr, OBJECT);
$ttl_prj2 = count($pageposts);
if ($ttl_prj2 > 0) {
$scn2 = "<span class='notif_a'>" . $ttl_prj2 . "</span>";
}
//------------------------------------------------
$querystr = "\n\n\t\t\t\t\tSELECT distinct wposts.ID \n\n\t\t\t\t\tFROM {$wpdb->posts} wposts, {$wpdb->postmeta} wpostmeta2, {$wpdb->postmeta} wpostmeta3\n\n\t\t\t\t\tWHERE wposts.post_author='{$uid}' AND wposts.ID = wpostmeta2.post_id AND wposts.ID = wpostmeta3.post_id AND\n\n\t\t\t\t\twpostmeta2.meta_key='outstanding' AND wpostmeta2.meta_value='1' AND wposts.post_type = 'project' AND wposts.post_status= 'publish' " . " AND wpostmeta3.meta_key='mark_coder_delivered' AND wpostmeta3.meta_value = '1'";
$pageposts = $wpdb->get_results($querystr, OBJECT);
$ttl_prj2 = count($pageposts);
if ($ttl_prj2 > 0) {
$compl = "<span class='notif_a'>" . $ttl_prj2 . "</span>";
}
$querystr = "\n\n\t\t\t\t\tSELECT distinct wposts.ID \n\n\t\t\t\t\tFROM {$wpdb->posts} wposts, {$wpdb->postmeta} wpostmeta2\n\n\t\t\t\t\tWHERE wposts.post_author='{$uid}' AND wposts.ID = wpostmeta2.post_id AND\n\n\t\t\t\t\twpostmeta2.meta_key='closed' AND wpostmeta2.meta_value='1' AND wposts.post_type = 'project' AND wposts.post_status = 'publish'";
$pageposts = $wpdb->get_results($querystr, OBJECT);
$ttl_prj2 = count($pageposts);
if ($ttl_prj2 > 0) {
$closed_number = "<span class='notif_a'>" . $ttl_prj2 . "</span>";
}
$querystr = "\n\n\t\t\t\t\tSELECT distinct wposts.ID \n\n\t\t\t\t\tFROM {$wpdb->posts} wposts, {$wpdb->postmeta} wpostmeta2\n\n\t\t\t\t\tWHERE wposts.post_author='{$uid}' AND wposts.ID = wpostmeta2.post_id AND\n\n\t\t\t\t\twpostmeta2.meta_key='closed' AND wpostmeta2.meta_value='0' AND wposts.post_type = 'project' AND wposts.post_status = 'publish'";
$pageposts = $wpdb->get_results($querystr, OBJECT);
$ttl_prj2 = count($pageposts);
if ($ttl_prj2 > 0) {
$active_number = "<span class='notif_a'>" . $ttl_prj2 . "</span>";
}
// $querystr = "
//
// SELECT distinct wposts.ID
//
// FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta3, $wpdb->postmeta wpostmeta4
//
// WHERE
//
// wposts.ID = wpostmeta4.post_id AND
//
// wpostmeta4.meta_key='paid_user' AND wpostmeta4.meta_value='1'
//
// AND wposts.post_type = 'project' AND wposts.post_author='$uid'";
$querystr = "\n SELECT pb.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_results($querystr, OBJECT);
$paid = count($pageposts);
if ($paid > 0) {
$paid = "<span class='notif_a'>" . $paid . "</span>";
} else {
$paid = '';
}
?>
<ul id="my-account-admin-menu_seller">
<li><a href="<?php
echo projectTheme_post_new_link();
?>
" ><?php
_e("Post New Project", 'ProjectTheme');
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_active_projects_id'));
?>
"><?php
printf(__("Active Projects %s", 'ProjectTheme'), $active_number);
/*_e("Active Projects",'ProjectTheme');*/
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_closed_projects_id'));
?>
"><?php
printf(__("Closed Projects %s", 'ProjectTheme'), $closed_number);
/*_e("Closed Projects",'ProjectTheme');*/
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_unpublished_projects_id'));
?>
"><?php
printf(__("Unpublished Projects %s", 'ProjectTheme'), $scn2);
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_awaiting_completion_id'));
?>
"><?php
printf(__("Awaiting Completion %s", 'ProjectTheme'), $compl);
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_outstanding_payments_id'));
?>
"><?php
printf(__("Outstanding Payments %s", 'ProjectTheme'), $scn);
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_completed_payments_id'));
?>
"><?php
printf(__("Completed Payments %s", 'ProjectTheme'), $paid);
/*_e("Completed Payments",'ProjectTheme');*/
?>
</a></li>
<?php
do_action('ProjectTheme_my_account_service_contractor_menu');
?>
</ul>
</p>
</li>
<!-- ###### -->
<?php
}
if (ProjectTheme_is_user_provider($uid)) {
?>
<li class="widget-container widget_text"><h3 class="widget-title"><?php
_e("QA Engineer Menu", 'ProjectTheme');
?>
</h3>
<p>
<?php
$querystr = "\n\n\t\t\t\t\tSELECT distinct wposts.ID \n\n\t\t\t\t\tFROM {$wpdb->posts} wposts, {$wpdb->postmeta} wpostmeta2\n\n\t\t\t\t\tWHERE wposts.ID = wpostmeta2.post_id AND\n\n\t\t\t\t\twpostmeta2.meta_key='winner' AND wpostmeta2.meta_value='{$uid}'\n\n\t\t\t\t\tAND wposts.post_type = 'project' AND wposts.post_status = 'publish' ";
$pageposts = $wpdb->get_results($querystr, OBJECT);
$won = count($pageposts);
if ($won > 0) {
$won = "<span class='notif_a'>" . $won . "</span>";
} else {
$won = '';
}
$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_results($querystr, OBJECT);
$outsnr = count($pageposts);
if ($outsnr > 0) {
$outsnr = "<span class='notif_a'>" . $outsnr . "</span>";
} else {
$outsnr = '';
}
//---------------------------------------
// $querystr = "
//
// SELECT distinct wposts.ID
//
// FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta2, $wpdb->postmeta wpostmeta3, $wpdb->postmeta wpostmeta4
//
// WHERE 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='delivered' AND wpostmeta3.meta_value='1' AND
//
//
//
// wposts.ID = wpostmeta4.post_id AND
//
// wpostmeta4.meta_key='paid_user' AND wpostmeta4.meta_value='0'
//
//
//
// AND wposts.post_type = 'project' ";
$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_results($querystr, OBJECT);
$awnr = count($pageposts);
if ($awnr > 0) {
$awnr = "<span class='notif_a'>" . $awnr . "</span>";
} else {
$awnr = '';
}
// $querystr = "
//
// SELECT distinct wposts.ID
//
// FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta2, $wpdb->postmeta wpostmeta3, $wpdb->postmeta wpostmeta4
//
// WHERE 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='delivered' AND wpostmeta3.meta_value='1' AND
//
//
// wposts.ID = wpostmeta4.post_id AND
//
// wpostmeta4.meta_key='paid_user' AND wpostmeta4.meta_value='1'
//
// AND wposts.post_type = 'project' ";
$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 = '1'\n AND pb.delivered = '1'\n AND p.post_type = 'project' ";
$pageposts = $wpdb->get_results($querystr, OBJECT);
$deliv = count($pageposts);
if ($deliv > 0) {
$deliv = "<span class='notif_a'>" . $deliv . "</span>";
} else {
$deliv = '';
}
$s = "select * from " . $wpdb->prefix . "project_bids where uid='{$uid}'";
$r = $wpdb->get_results($s);
$pids = array();
foreach ($r as $k => $rr) {
$pids[] = $rr->pid;
}
$pids = implode(',', $pids);
$querystr = "\n\n\t\t\t\t\tSELECT distinct wposts.ID \n\n\t\t\t\t\tFROM {$wpdb->posts} wposts\n\n\t\t\t\t\tWHERE wposts.ID IN ({$pids})\n\n\t\t\t\t\t\n\n\t\t\t\t\tAND wposts.post_type = 'project' AND wposts.post_status = 'publish'";
$pageposts = $wpdb->get_results($querystr, OBJECT);
$prop = count($pageposts);
if ($prop > 0) {
$prop = "<span class='notif_a'>" . $prop . "</span>";
} else {
$prop = '';
}
?>
<ul id="my-account-admin-menu_buyer">
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_won_projects_id'));
?>
"><?php
printf(__("Projects I’ve Won %s", 'ProjectTheme'), $won);
/*_e("Projects I’ve Won",'ProjectTheme');*/
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_outstanding_projects_id'));
?>
"><?php
printf(__("Projects in progress %s", 'ProjectTheme'), $outsnr);
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_awaiting_payments_id'));
?>
"><?php
printf(__("Awaiting Payments %s", 'ProjectTheme'), $awnr);
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_delivered_projects_id'));
?>
"><?php
printf(__("Delivered & Paid Projects %s", 'ProjectTheme'), $deliv);
/*_e("Delivered & Paid Projects",'ProjectTheme');*/
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_bid_projects_id'));
?>
"><?php
printf(__("My Proposals %s", 'ProjectTheme'), $prop);
/*_e("My Proposals",'ProjectTheme');*/
?>
</a></li>
<?php
do_action('ProjectTheme_my_account_service_provider_menu');
?>
</ul>
</p>
</li>
<?php
}
?>
</ul>
</div>
<?php
}
<div class="rama1"><input type="text" placeholder="<?php
_e('What service do you need? (e.g. website design)', 'ProjectTheme');
?>
" id="findService" name="term"></div>
<div class="rama1 rama2"><input type="image" src="<?php
bloginfo('template_url');
?>
/images/sear1.png" width="44" height="44" /></div>
</div>
</div>
</form>
<div class="buttons_box_main">
<ul class="regular_ul">
<li><a href="<?php
echo projectTheme_post_new_link();
?>
"><?php
_e('Post Your Project', 'ProjectTheme');
?>
</a></li>
<li><a href="<?php
bloginfo('siteurl');
?>
/wp-login.php?action=register"><?php
_e("Join Us. It's Free", 'ProjectTheme');
?>
</a></li>
</ul>
</div>
function ProjectTheme_get_users_links()
{
global $current_user, $wpdb;
get_currentuserinfo();
$rd = projectTheme_get_unread_number_messages($current_user->ID);
if ($rd > 0) {
$ssk = "<span class='notif_a'>" . $rd . "</span>";
} else {
$ssk = '';
}
$uid = $current_user->ID;
//-----------------------
$query = "select id from " . $wpdb->prefix . "project_ratings where fromuser='******' AND awarded='0'";
$r = $wpdb->get_results($query);
$ttl_fdbks = count($r);
if ($ttl_fdbks > 0) {
$ttl_fdbks2 = "<span class='notif_a'>" . $ttl_fdbks . "</span>";
}
$ProjectTheme_enable_2_user_tp = get_option('ProjectTheme_enable_2_user_tp');
$user_tp = get_user_meta($uid, 'user_tp', true);
?>
<div id="right-sidebar" class="account-sidebar">
<ul class="xoxo">
<li class="widget-container widget_text">
<p>
<ul id="my-account-admin-menu">
<li><a href="<?php
echo projectTheme_my_account_link();
?>
" <?php
echo $current_page == "home" ? "class='active'" : "";
?>
><?php
_e("MyAccount Home", 'ProjectTheme');
?>
</a></li>
<?php
$pmnts_lnk = get_permalink(get_option('ProjectTheme_my_account_payments_id'));
$pmnts_lnk = apply_filters('ProjectTheme_my_account_payments_id_link', $pmnts_lnk);
$ProjectTheme_enable_credits_wallet = get_option('ProjectTheme_enable_credits_wallet');
if ($ProjectTheme_enable_credits_wallet != 'no') {
?>
<li><a href="<?php
echo $pmnts_lnk;
?>
"><?php
_e("Finances", 'ProjectTheme');
?>
</a></li>
<?php
}
?>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_private_messages_id'));
?>
"><?php
echo sprintf(__("Private Messages %s", 'ProjectTheme'), $ssk);
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_personal_info_id'));
?>
"><?php
_e("Personal Info", 'ProjectTheme');
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_feedback_id'));
?>
"><?php
printf(__("Reviews/Feedback %s", 'ProjectTheme'), $ttl_fdbks2);
?>
</a></li>
<?php
do_action('ProjectTheme_my_account_main_menu');
?>
</ul>
</p>
</li>
<!-- ###### -->
<?php
if (ProjectTheme_is_user_business($uid)) {
?>
<li class="widget-container widget_text"><h3 class="widget-title"><?php
_e("Service Contractor Menu", 'ProjectTheme');
?>
</h3>
<p>
<?php
global $wpdb;
$querystr = "\n\t\t\t\t\tSELECT distinct wposts.ID \n\t\t\t\t\tFROM {$wpdb->posts} wposts, {$wpdb->postmeta} wpostmeta2, {$wpdb->postmeta} wpostmeta3\n\t\t\t\t\tWHERE wposts.post_author='{$uid}' AND wposts.ID = wpostmeta2.post_id AND\n\t\t\t\t\twpostmeta2.meta_key='paid_user' AND wpostmeta2.meta_value='0'\n\t\t\t\t\t\n\t\t\t\t\tAND wposts.ID = wpostmeta3.post_id AND\n\t\t\t\t\twpostmeta3.meta_key='delivered' AND wpostmeta3.meta_value='1'\n\t\t\t\t\t\n\t\t\t\t\t AND wposts.post_type = 'project' ";
$pageposts = $wpdb->get_results($querystr, OBJECT);
$ttl_prj = count($pageposts);
if ($ttl_prj > 0) {
$scn = "<span class='notif_a'>" . $ttl_prj . "</span>";
}
//------------------------------------------------
$querystr = "\n\t\t\t\t\tSELECT distinct wposts.ID \n\t\t\t\t\tFROM {$wpdb->posts} wposts, {$wpdb->postmeta} wpostmeta2\n\t\t\t\t\tWHERE wposts.post_author='{$uid}' AND wposts.ID = wpostmeta2.post_id AND\n\t\t\t\t\twpostmeta2.meta_key='paid' AND wpostmeta2.meta_value='0' AND wposts.post_type = 'project' AND wposts.post_status = 'draft' ";
$pageposts = $wpdb->get_results($querystr, OBJECT);
$ttl_prj2 = count($pageposts);
if ($ttl_prj2 > 0) {
$scn2 = "<span class='notif_a'>" . $ttl_prj2 . "</span>";
}
//------------------------------------------------
$querystr = "\n\t\t\t\t\tSELECT distinct wposts.ID \n\t\t\t\t\tFROM {$wpdb->posts} wposts, {$wpdb->postmeta} wpostmeta2\n\t\t\t\t\tWHERE wposts.post_author='{$uid}' AND wposts.ID = wpostmeta2.post_id AND\n\t\t\t\t\twpostmeta2.meta_key='outstanding' AND wpostmeta2.meta_value='1' AND wposts.post_type = 'project' ";
$pageposts = $wpdb->get_results($querystr, OBJECT);
$ttl_prj2 = count($pageposts);
if ($ttl_prj2 > 0) {
$compl = "<span class='notif_a'>" . $ttl_prj2 . "</span>";
}
?>
<ul id="my-account-admin-menu_seller">
<li><a href="<?php
echo projectTheme_post_new_link();
?>
" ><?php
_e("Post New Project", 'ProjectTheme');
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_active_projects_id'));
?>
"><?php
_e("Active Projects", 'ProjectTheme');
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_closed_projects_id'));
?>
"><?php
_e("Closed Projects", 'ProjectTheme');
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_unpublished_projects_id'));
?>
"><?php
printf(__("Unpublished Projects %s", 'ProjectTheme'), $scn2);
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_awaiting_completion_id'));
?>
"><?php
printf(__("Awaiting Completion %s", 'ProjectTheme'), $compl);
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_outstanding_payments_id'));
?>
"><?php
printf(__("Outstanding Payments %s", 'ProjectTheme'), $scn);
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_completed_payments_id'));
?>
"><?php
_e("Completed Payments", 'ProjectTheme');
?>
</a></li>
<?php
do_action('ProjectTheme_my_account_service_contractor_menu');
?>
</ul>
</p>
</li>
<!-- ###### -->
<?php
}
if (ProjectTheme_is_user_provider($uid)) {
?>
<li class="widget-container widget_text"><h3 class="widget-title"><?php
_e("Freelancer Menu", 'ProjectTheme');
?>
</h3>
<p>
<?php
$querystr = "\n\t\t\t\t\tSELECT distinct wposts.ID \n\t\t\t\t\tFROM {$wpdb->posts} wposts, {$wpdb->postmeta} wpostmeta2, {$wpdb->postmeta} wpostmeta3\n\t\t\t\t\tWHERE wposts.ID = wpostmeta2.post_id AND\n\t\t\t\t\twpostmeta2.meta_key='winner' AND wpostmeta2.meta_value='{$uid}' AND\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\twposts.ID = wpostmeta3.post_id AND\n\t\t\t\t\twpostmeta3.meta_key='outstanding' AND wpostmeta3.meta_value='1' \n\t\t\t\t\t\n\t\t\t\t\tAND wposts.post_type = 'project' ";
$pageposts = $wpdb->get_results($querystr, OBJECT);
$outsnr = count($pageposts);
if ($outsnr > 0) {
$outsnr = "<span class='notif_a'>" . $outsnr . "</span>";
} else {
$outsnr = '';
}
//---------------------------------------
$querystr = "\n\t\t\t\t\tSELECT distinct wposts.ID \n\t\t\t\t\tFROM {$wpdb->posts} wposts, {$wpdb->postmeta} wpostmeta2, {$wpdb->postmeta} wpostmeta3, {$wpdb->postmeta} wpostmeta4\n\t\t\t\t\tWHERE wposts.ID = wpostmeta2.post_id AND\n\t\t\t\t\twpostmeta2.meta_key='winner' AND wpostmeta2.meta_value='{$uid}' AND\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\twposts.ID = wpostmeta3.post_id AND\n\t\t\t\t\twpostmeta3.meta_key='delivered' AND wpostmeta3.meta_value='1' AND\n\t\t\t\t\t\n\t\t\t\t\twposts.ID = wpostmeta4.post_id AND\n\t\t\t\t\twpostmeta4.meta_key='paid_user' AND wpostmeta4.meta_value='0' \n\t\t\t\t\t\n\t\t\t\t\tAND wposts.post_type = 'project' ";
$pageposts = $wpdb->get_results($querystr, OBJECT);
$awnr = count($pageposts);
if ($awnr > 0) {
$awnr = "<span class='notif_a'>" . $awnr . "</span>";
} else {
$awnr = '';
}
?>
<ul id="my-account-admin-menu_buyer">
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_won_projects_id'));
?>
"><?php
_e("Won Projects", 'ProjectTheme');
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_outstanding_projects_id'));
?>
"><?php
printf(__("Outstanding Projects %s", 'ProjectTheme'), $outsnr);
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_awaiting_payments_id'));
?>
"><?php
printf(__("Awaiting Payments %s", 'ProjectTheme'), $awnr);
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_delivered_projects_id'));
?>
"><?php
_e("Delivered & Paid Projects", 'ProjectTheme');
?>
</a></li>
<li><a href="<?php
echo get_permalink(get_option('ProjectTheme_my_account_bid_projects_id'));
?>
"><?php
_e("My Proposals", 'ProjectTheme');
?>
</a></li>
<?php
do_action('ProjectTheme_my_account_service_provider_menu');
?>
</ul>
</p>
</li>
<?php
}
?>
</ul>
</div>
<?php
}
