function ProjectTheme_my_account_delivered_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("Delivered 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' => 'delivered', 'value' => "1", 'compare' => '=');
$paid_user = array('key' => 'paid_user', '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, $paid_user));
query_posts($args);
if (have_posts()) {
while (have_posts()) {
the_post();
projectTheme_get_post();
}
if (function_exists('wp_pagenavi')) {
wp_pagenavi();
}
} else {
_e("There are no delivered projects yet.", 'ProjectTheme');
}
wp_reset_query();
?>
</div>
</div>
</div>
<?php
ProjectTheme_get_users_links();
}
function ProjectTheme_my_account_unpublished_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("Unpublished Projects", 'ProjectTheme');
?>
</div>
<div class="box_content">
<?php
global $wp_query;
$query_vars = $wp_query->query_vars;
$post_per_page = 10;
$paids = array('key' => 'paid', 'value' => "0", 'compare' => '=');
$args = array('post_type' => 'project', 'order' => 'DESC', 'orderby' => 'date', 'post_status' => 'draft', 'author' => $uid, 'posts_per_page' => $post_per_page, 'paged' => $query_vars['paged'], 'meta_query' => array($paids));
query_posts($args);
//query_posts( "post_status=draft&meta_key=paid&meta_value=0&post_type=project&order=DESC&orderby=id&author=".$uid.
//"&posts_per_page=".$post_per_page."&paged=".$query_vars['paged'] );
if (have_posts()) {
while (have_posts()) {
the_post();
projectTheme_get_post(array('unpaid'));
}
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_closed_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("My Closed Projects", 'ProjectTheme');
?>
</div>
<div class="box_content">
<?php
global $wp_query;
$query_vars = $wp_query->query_vars;
$post_per_page = 5;
query_posts("meta_key=closed&meta_value=1&post_type=project&order=DESC&orderby=id&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();
}
} else {
_e("There are no projects yet.", 'ProjectTheme');
}
wp_reset_query();
?>
</div>
</div>
</div>
<?php
ProjectTheme_get_users_links();
}
function ProjectTheme_my_account_won_projects_area_function()
{
global $current_user, $wpdb, $wp_query;
get_currentuserinfo();
$uid = $current_user->ID;
?>
<div id="content" class="account-main-area">
<?php
global $wp_query;
$query_vars = $wp_query->query_vars;
$post_per_page = 10;
$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($winner, $paid, $reverse));
query_posts($args);
if (have_posts()) {
while (have_posts()) {
the_post();
projectTheme_get_post(array('winner_not'));
}
if (function_exists('wp_pagenavi')) {
wp_pagenavi();
}
} else {
echo '<div class="my_box3 border_bottom_0"> <div class="box_content"> ';
_e("There are no projects yet.", 'ProjectTheme');
echo '</div> </div> ';
}
wp_reset_query();
?>
</div>
<?php
ProjectTheme_get_users_links();
}
<div class="box_title"><?php
_e("User Latest Won Projects", 'ProjectTheme');
?>
</div>
<?php
$nrpostsPage = 8;
$args = array('meta_key' => 'winner', 'meta_value' => $uid, 'posts_per_page' => $nrpostsPage, 'paged' => $paged, 'post_type' => 'project', 'order' => "DESC", 'orderby' => "date");
$the_query = new WP_Query($args);
// The Loop
if ($the_query->have_posts()) {
while ($the_query->have_posts()) {
$the_query->the_post();
projectTheme_get_post();
}
if (function_exists('wp_pagenavi')) {
wp_pagenavi(array('query' => $the_query));
}
?>
<?php
} else {
echo '<div class="my_box3"><div class="box_content"> ';
echo __('No projects posted.', 'ProjectTheme');
echo '</div>
</div>';
}
// Reset Post Data
wp_reset_postdata();
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_advanced_search_area_main_function()
{
if (isset($_GET['pj'])) {
$pj = $_GET['pj'];
} else {
$pj = 1;
}
if (isset($_GET['order'])) {
$order = $_GET['order'];
} else {
$order = "DESC";
}
if (isset($_GET['orderby'])) {
$orderby = $_GET['orderby'];
} else {
$orderby = "date";
}
if (isset($_GET['meta_key'])) {
$meta_key = $_GET['meta_key'];
} else {
$meta_key = "";
}
if (!empty($_GET['budgets'])) {
$price_q = array('key' => 'budgets', 'value' => $_GET['budgets'], 'compare' => '=');
}
if (isset($_GET['featured'])) {
$featured = array('key' => 'featured', 'value' => "1", 'compare' => '=');
}
$closed = array('key' => 'closed', 'value' => "0", 'compare' => '=');
if (!empty($_GET['project_location_cat'])) {
$loc = array('taxonomy' => 'project_location', 'field' => 'slug', 'terms' => $_GET['project_location_cat']);
} else {
$loc = '';
}
if (!empty($_GET['project_cat_cat'])) {
$adsads = array('taxonomy' => 'project_cat', 'field' => 'slug', 'terms' => $_GET['project_cat_cat']);
} else {
$adsads = '';
}
//------------
global $term;
$term = trim($_GET['term']);
if (isset($_GET['term'])) {
add_filter('posts_where', 'projectTheme_posts_where2');
}
do_action('ProjectTheme_adv_search_before_search');
add_filter('posts_join', 'projectTheme_posts_join2');
add_filter('posts_orderby', 'projectTheme_posts_orderby');
//------------
//orderby price - meta_value_num
$nrpostsPage = 10;
$nrpostsPage = apply_filters('ProjectTheme_advanced_search_posts_per_page', $nrpostsPage);
$args = array('posts_per_page' => $nrpostsPage, 'paged' => $pj, 'post_type' => 'project', 'order' => $order, 'meta_query' => array($price_q, $closed, $featured), 'meta_key' => $meta_key, 'orderby' => $orderby, 'tax_query' => array($loc, $adsads));
$the_query = new WP_Query($args);
$nrposts = $the_query->found_posts;
$totalPages = ceil($nrposts / $nrpostsPage);
$pagess = $totalPages;
//===============*********=======================
?>
<div id="content" >
<?php
// The Loop
if ($the_query->have_posts()) {
while ($the_query->have_posts()) {
$the_query->the_post();
projectTheme_get_post($post, $i);
}
if (isset($_GET['pj'])) {
$pj = $_GET['pj'];
} else {
$pj = 1;
}
$pjsk = $pj;
?>
<div class="div_class_div">
<?php
$my_page = $pj;
$page = $pj;
$batch = 10;
$nrpostsPage = $nrRes;
$end = $batch * $nrpostsPage;
if ($end > $pagess) {
$end = $pagess;
}
$start = $end - $nrpostsPage + 1;
if ($start < 1) {
$start = 1;
}
$links = '';
$raport = ceil($my_page / $batch) - 1;
if ($raport < 0) {
$raport = 0;
}
$start = $raport * $batch + 1;
$end = $start + $batch - 1;
$end_me = $end + 1;
$start_me = $start - 1;
if ($end > $totalPages) {
$end = $totalPages;
}
if ($end_me > $totalPages) {
$end_me = $totalPages;
}
if ($start_me <= 0) {
$start_me = 1;
}
$previous_pg = $page - 1;
if ($previous_pg <= 0) {
$previous_pg = 1;
}
$next_pg = $pages_curent + 1;
if ($next_pg > $totalPages) {
$next_pg = 1;
}
if ($my_page > 1) {
echo '<a class="bighi" href="' . projectTheme_advanced_search_link_pgs($previous_pg) . '">' . __("<< Previous", "ProjectTheme") . '</a>';
echo '<a class="bighi" href="' . projectTheme_advanced_search_link_pgs($start_me) . '"><<</a>';
}
for ($i = $start; $i <= $end; $i++) {
if ($i == $pj) {
echo '<a class="bighi" id="activees" href="#">' . $i . '</a>';
} else {
echo '<a class="bighi" href="' . projectTheme_advanced_search_link_pgs($i) . '">' . $i . '</a>';
}
}
$next_pg = $pjsk + 1;
if ($totalPages > $my_page) {
echo '<a class="bighi" href="' . projectTheme_advanced_search_link_pgs($end_me) . '">>></a>';
}
if ($page < $totalPages) {
echo '<a class="bighi" href="' . projectTheme_advanced_search_link_pgs($next_pg) . '">' . __("Next >>", "ProjectTheme") . '</a>';
}
?>
</div>
<?php
} else {
echo '<div class="my_box3"> <div class="box_content"> ';
echo __('No projects posted.', "ProjectTheme");
echo '</div></div>';
}
// Reset Post Data
wp_reset_postdata();
?>
</div>
<div id="right-sidebar">
<li class="">
<h3 class="widget-title"><?php
_e('Filter Options', 'ProjectTheme');
?>
</h3>
<form method="get">
<table>
<tr>
<td><?php
_e('Keyword', "ProjectTheme");
?>
:</td>
<td><input size="20" class="" value="<?php
echo $_GET['term'];
?>
" name="term" /></td>
</tr>
<tr>
<td><?php
_e('Price', "ProjectTheme");
?>
:</td>
<td><?php
echo ProjecTheme_get_budgets_dropdown($_GET['budgets'], 'budgets_advanced_search', 1);
?>
</td>
</tr>
<tr>
<td><?php
_e('Location', "ProjectTheme");
?>
:</td>
<td><?php
echo ProjectTheme_get_categories_slug("project_location", $_GET['project_location_cat'], __("Select Location", "ProjectTheme"), 'categ_advanced_search');
?>
</td>
</tr>
<tr>
<td><?php
_e('Category', "ProjectTheme");
?>
:</td>
<td><?php
echo ProjectTheme_get_categories_slug("project_cat", $_GET['project_cat_cat'], __("Select Category", "ProjectTheme"), 'categ_advanced_search');
?>
</td>
</tr>
<tr>
<td><?php
_e('Featured?', "ProjectTheme");
?>
:</td>
<td><input type="checkbox" name="featured" value="1" <?php
if (isset($_GET['featured'])) {
echo 'checked="checked"';
}
?>
/></td>
</tr>
<?php
do_action('ProjectTheme_adv_search_add_to_form');
?>
<tr>
<td></td>
<td><input type="submit" value="<?php
_e("Refine Search", "ProjectTheme");
?>
" name="ref-search" class="big-search-submit2" /></td>
</tr>
</table>
</form>
<div class="clear10"></div>
<div style="float:left;width:100%">
<?php
$ge = 'order=' . ($_GET['order'] == 'ASC' ? "DESC" : "ASC") . '&meta_key=budgets&orderby=meta_value_num';
foreach ($_GET as $key => $value) {
if ($key != 'meta_key' && $key != 'orderby' && $key != 'order') {
$ge .= '&' . $key . "=" . $value;
}
}
//------------------------
$ge2 = 'order=' . ($_GET['order'] == 'ASC' ? "DESC" : "ASC") . '&orderby=title';
foreach ($_GET as $key => $value) {
if ($key != 'orderby' && $key != 'order') {
$ge2 .= '&' . $key . "=" . $value;
}
}
//------------------------
$ge3 = 'order=' . ($_GET['order'] == 'ASC' ? "DESC" : "ASC") . '&meta_key=views&orderby=meta_value_num';
foreach ($_GET as $key => $value) {
if ($key != 'meta_key' && $key != 'orderby' && $key != 'order') {
$ge3 .= '&' . $key . "=" . $value;
}
}
?>
<?php
_e("Order by:", "ProjectTheme");
$ProjectTheme_advanced_search_page_id = get_option('ProjectTheme_advanced_search_page_id');
if (ProjectTheme_using_permalinks()) {
$adv = get_permalink($ProjectTheme_advanced_search_page_id) . "?";
} else {
$adv = get_permalink($ProjectTheme_advanced_search_page_id) . "&";
}
?>
<a href="<?php
echo $adv;
echo $ge;
?>
"><?php
_e("Price", "ProjectTheme");
?>
</a> |
<a href="<?php
echo $adv;
echo $ge2;
?>
"><?php
_e("Name", "ProjectTheme");
?>
</a> |
<a href="<?php
echo $adv;
echo $ge2;
?>
"><?php
_e("Visits", "ProjectTheme");
?>
</a>
</div>
</li>
<?php
dynamic_sidebar('other-page-area');
?>
</div>
<?php
}
function ProjectTheme_my_account_delivered_projects_area_function()
{
global $current_user, $wpdb, $wp_query;
get_currentuserinfo();
$uid = $current_user->ID;
?>
<div id="content" class="account-main-area">
<div class="my_box3 border_bottom_0">
<div class="box_title"><?php
_e("Delivered Projects", 'ProjectTheme');
?>
</div>
<div class="box_content">
<?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 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_col($querystr);
if (empty($pageposts)) {
_e("There are no delivered projects yet.", 'ProjectTheme');
} else {
// $outstanding = array(
// 'key' => 'delivered',
// 'value' => "1",
// 'compare' => '='
// );
//
//
// $paid_user = array(
// 'key' => 'paid_user',
// '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, $paid_user));
$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();
}
if (function_exists('wp_pagenavi')) {
wp_pagenavi();
}
} else {
_e("There are no delivered 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">
<?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
}
function ProjectTheme_advanced_search_area_main_function()
{
if (isset($_GET['pj'])) {
$pj = $_GET['pj'];
} else {
$pj = 1;
}
if (isset($_GET['order'])) {
$order = $_GET['order'];
} else {
$order = "DESC";
}
if (isset($_GET['orderby'])) {
$orderby = $_GET['orderby'];
} else {
$orderby = "date";
}
if (isset($_GET['meta_key'])) {
$meta_key = $_GET['meta_key'];
} else {
$meta_key = "";
}
if (!empty($_GET['budgets'])) {
$price_q = array('key' => 'budgets', 'value' => $_GET['budgets'], 'compare' => '=');
}
if (isset($_GET['featured'])) {
$featured = array('key' => 'featured', 'value' => "1", 'compare' => '=');
}
$closed = array('key' => 'closed', 'value' => "0", 'compare' => '=');
/*
* Date filter
*/
if (!empty($_GET['time-posted-from']) && !empty($_GET['time-posted-to'])) {
$time_posted = array('relation' => 'AND', array('key' => 'made_me_date', 'value' => strtotime($_GET['time-posted-from']), 'compare' => '>='), array('key' => 'made_me_date', 'value' => strtotime($_GET['time-posted-to']), 'compare' => '<='));
} elseif (!empty($_GET['time-posted-from'])) {
$time_posted = array('key' => 'made_me_date', 'value' => strtotime($_GET['time-posted-from']), 'compare' => '>=');
} elseif (!empty($_GET['time-posted-to'])) {
$time_posted = array('key' => 'made_me_date', 'value' => strtotime($_GET['time-posted-to']), 'compare' => '<=');
}
/*
* Visits filter
*/
if (!empty($_GET['visits-over'])) {
$featured = array('key' => 'views', 'value' => $_GET['visits-over'], 'type' => 'numeric', 'compare' => '>=');
}
if (!empty($_GET['project_location_cat'])) {
$loc = array('taxonomy' => 'project_location', 'field' => 'slug', 'terms' => $_GET['project_location_cat']);
} else {
$loc = '';
}
if (!empty($_GET['project_cat_cat'])) {
$adsads = array('taxonomy' => 'project_cat', 'field' => 'slug', 'terms' => $_GET['project_cat_cat']);
} else {
$adsads = '';
}
//------------
global $term;
/*$term = trim($_GET['term']);
$tag_slug__in = explode(" ",$term);*/
if (!empty($_GET['term'])) {
add_filter('posts_where', 'projectTheme_posts_where2');
}
do_action('ProjectTheme_adv_search_before_search');
add_filter('posts_join', 'projectTheme_posts_join2');
add_filter('posts_orderby', 'projectTheme_posts_orderby');
//------------
//orderby price - meta_value_num
$nrpostsPage = 10;
$nrpostsPage = apply_filters('ProjectTheme_advanced_search_posts_per_page', $nrpostsPage);
$args = array('posts_per_page' => $nrpostsPage, 'paged' => $pj, 'post_type' => 'project', 'order' => $order, 'meta_query' => array($price_q, $closed, $featured, $time_posted), 'meta_key' => $meta_key, 'orderby' => $orderby, 'tax_query' => array($loc, $adsads));
//var_dump($args);
$the_query = new WP_Query($args);
//var_dump($the_query);
/*if(!$the_query->have_posts()){
remove_filter( 'posts_where' , 'projectTheme_posts_where2' );
$args = array( 'posts_per_page' => $nrpostsPage, 'paged' => $pj, 'post_type' => 'project', 'order' => $order , 'tag_slug__in'=>$tag_slug__in,
'meta_query' => array($price_q, $closed, $featured) ,'meta_key' => $meta_key, 'orderby'=>$orderby,'tax_query' => array($loc, $adsads));
$the_query = new WP_Query( $args );
}
var_dump($the_query);*/
$nrposts = $the_query->found_posts;
$totalPages = ceil($nrposts / $nrpostsPage);
$pagess = $totalPages;
//===============*********=======================
?>
<div id="content" >
<?php
echo '<h2 class="widget-title">Total search results: ' . $the_query->found_posts . '</h2>';
// The Loop
if ($the_query->have_posts()) {
while ($the_query->have_posts()) {
$the_query->the_post();
projectTheme_get_post($post, $i);
}
if (isset($_GET['pj'])) {
$pj = $_GET['pj'];
} else {
$pj = 1;
}
$pjsk = $pj;
?>
<div class="div_class_div">
<?php
$my_page = $pj;
$page = $pj;
$batch = 10;
$nrpostsPage = $nrRes;
$end = $batch * $nrpostsPage;
if ($end > $pagess) {
$end = $pagess;
}
$start = $end - $nrpostsPage + 1;
if ($start < 1) {
$start = 1;
}
$links = '';
$raport = ceil($my_page / $batch) - 1;
if ($raport < 0) {
$raport = 0;
}
$start = $raport * $batch + 1;
$end = $start + $batch - 1;
$end_me = $end + 1;
$start_me = $start - 1;
if ($end > $totalPages) {
$end = $totalPages;
}
if ($end_me > $totalPages) {
$end_me = $totalPages;
}
if ($start_me <= 0) {
$start_me = 1;
}
$previous_pg = $page - 1;
if ($previous_pg <= 0) {
$previous_pg = 1;
}
$next_pg = $pages_curent + 1;
if ($next_pg > $totalPages) {
$next_pg = 1;
}
if ($my_page > 1) {
echo '<a class="bighi" href="' . projectTheme_advanced_search_link_pgs($previous_pg) . '">' . __("<< Previous", "ProjectTheme") . '</a>';
echo '<a class="bighi" href="' . projectTheme_advanced_search_link_pgs($start_me) . '"><<</a>';
}
for ($i = $start; $i <= $end; $i++) {
if ($i == $pj) {
echo '<a class="bighi" id="activees" href="#">' . $i . '</a>';
} else {
echo '<a class="bighi" href="' . projectTheme_advanced_search_link_pgs($i) . '">' . $i . '</a>';
}
}
$next_pg = $pjsk + 1;
if ($totalPages > $my_page) {
echo '<a class="bighi" href="' . projectTheme_advanced_search_link_pgs($end_me) . '">>></a>';
}
if ($page < $totalPages) {
echo '<a class="bighi" href="' . projectTheme_advanced_search_link_pgs($next_pg) . '">' . __("Next >>", "ProjectTheme") . '</a>';
}
?>
</div>
<?php
} else {
echo '<div class="my_box3"> <div class="box_content"> ';
echo __('No projects posted.', "ProjectTheme");
echo '</div></div>';
}
// Reset Post Data
wp_reset_postdata();
?>
</div>
<div id="right-sidebar">
<li class="">
<h3 class="widget-title"><?php
_e('Filter Options', 'ProjectTheme');
?>
</h3>
<form method="get" id="filter-form">
<table class="form-table">
<tr>
<td><?php
_e('Keyword', "ProjectTheme");
?>
:</td>
<td><input size="20" class="" value="<?php
echo $_GET['term'];
?>
" name="term" /></td>
</tr>
<tr>
<td><?php
_e('Price', "ProjectTheme");
?>
:</td>
<td><?php
echo ProjecTheme_get_budgets_dropdown($_GET['budgets'], 'budgets_advanced_search', 1);
?>
</td>
</tr>
<tr>
<td><?php
_e('Location', "ProjectTheme");
?>
:</td>
<td><?php
echo ProjectTheme_get_categories_slug("project_location", $_GET['project_location_cat'], __("Select Location", "ProjectTheme"), 'categ_advanced_search');
?>
</td>
</tr>
<tr>
<td><?php
_e('Category', "ProjectTheme");
?>
:</td>
<td><?php
echo ProjectTheme_get_categories_slug("project_cat", $_GET['project_cat_cat'], __("Select Category", "ProjectTheme"), 'categ_advanced_search');
?>
</td>
</tr>
<tr>
<td><?php
_e('Featured', "ProjectTheme");
?>
:</td>
<td><input type="checkbox" name="featured" value="1" <?php
if (isset($_GET['featured'])) {
echo 'checked="checked"';
}
?>
/></td>
</tr>
<script src="//ajax.googleapis.com/ajax/libs/jqueryui/1.11.0/jquery-ui.min.js"></script>
<link rel="stylesheet" media="all" type="text/css" href="<?php
echo get_bloginfo('template_url');
?>
/css/ui_thing.css" />
<script type="text/javascript" language="javascript" src="<?php
echo get_bloginfo('template_url');
?>
/js/timepicker.js"></script>
<tr>
<td><?php
_e('Posted from', "ProjectTheme");
?>
:</td>
<td>
<input size="20" readonly name="time-posted-from" id="time-posted-from" class="filter-date" value="<?php
echo $_GET['time-posted-from'];
?>
" /></p>
</td>
</tr>
<tr>
<td><?php
_e('Posted to', "ProjectTheme");
?>
:</td>
<td>
<input size="20" readonly name="time-posted-to" id="time-posted-to" class="filter-date" value="<?php
echo $_GET['time-posted-to'];
?>
" /></p>
</td>
</tr>
<tr>
<td><?php
_e('Visits over', "ProjectTheme");
?>
:</td>
<td>
<input size="5" type="number" min="0" name="visits-over" id="visits-over" class="visits-over" onkeypress="return isNumberKey(event)" value="<?php
if (isset($_GET['visits-over'])) {
echo $_GET['visits-over'];
} else {
echo 0;
}
?>
" /></p>
</td>
</tr>
<?php
do_action('ProjectTheme_adv_search_add_to_form');
?>
<script>
function isNumberKey(evt){
var charCode = (evt.which) ? evt.which : event.keyCode
if (charCode > 31 && (charCode < 48 || charCode > 57))
return false;
return true;
}
jQuery(document).ready(function() {
jQuery('#time-posted-from').datetimepicker({
showSecond: false,
timeFormat: 'hh:mm:ss',
showButtonPanel: true,
beforeShow: function( input ) {
setTimeout(function() {
var buttonPane = $( input )
.datepicker( "widget" )
.find( ".ui-datepicker-buttonpane" );
var btn = $('<button type="button" class="ui-datepicker-current ui-state-default ui-priority-secondary ui-corner-all"><?php
_e('Clear', 'ProjectTheme');
?>
</button>');
btn
.unbind("click")
.bind("click", function () {
$.datepicker._clearDate( input );
jQuery('#time-posted-from').val('');
});
btn.appendTo( buttonPane );
}, 1 );
},
currentText: '<?php
_e('Now', 'ProjectTheme');
?>
',
closeText: '<?php
_e('Done', 'ProjectTheme');
?>
',
ampm: false,
dateFormat: 'mm/dd/yy',
timeFormat: 'hh:mm tt',
timeSuffix: '',
timeOnlyTitle: '<?php
_e('Choose Time', 'ProjectTheme');
?>
',
timeText: '<?php
_e('Time', 'ProjectTheme');
?>
',
hourText: '<?php
_e('Hour', 'ProjectTheme');
?>
',
minuteText: '<?php
_e('Minute', 'ProjectTheme');
?>
',
secondText: '<?php
_e('Second', 'ProjectTheme');
?>
',
timezoneText: '<?php
_e('Time Zone', 'ProjectTheme');
?>
'
});
jQuery('#time-posted-to').datetimepicker({
showSecond: false,
timeFormat: 'hh:mm:ss',
showButtonPanel: true,
beforeShow: function( input ) {
setTimeout(function() {
var buttonPane = $( input )
.datepicker( "widget" )
.find( ".ui-datepicker-buttonpane" );
var btn = $('<button type="button" class="ui-datepicker-current ui-state-default ui-priority-secondary ui-corner-all"><?php
_e('Clear', 'ProjectTheme');
?>
</button>');
btn
.unbind("click")
.bind("click", function () {
$.datepicker._clearDate( input );
jQuery('#time-posted-to').val('');
});
btn.appendTo( buttonPane );
}, 1 );
},
currentText: '<?php
_e('Now', 'ProjectTheme');
?>
',
closeText: '<?php
_e('Done', 'ProjectTheme');
?>
',
ampm: false,
dateFormat: 'mm/dd/yy',
timeFormat: 'hh:mm tt',
timeSuffix: '',
timeOnlyTitle: '<?php
_e('Choose Time', 'ProjectTheme');
?>
',
timeText: '<?php
_e('Time', 'ProjectTheme');
?>
',
hourText: '<?php
_e('Hour', 'ProjectTheme');
?>
',
minuteText: '<?php
_e('Minute', 'ProjectTheme');
?>
',
secondText: '<?php
_e('Second', 'ProjectTheme');
?>
',
timezoneText: '<?php
_e('Time Zone', 'ProjectTheme');
?>
'
});});
</script>
<tr style="padding-top: 20px">
<td><input type="submit" value="<?php
_e("Refine Search", "ProjectTheme");
?>
" name="ref-search" class="big-search-submit2" /></td>
</tr>
</table>
</form>
<div class="clear10"></div>
<div style="float:left;width:100%">
<?php
$ge = 'order=' . ($_GET['order'] == 'ASC' ? "DESC" : "ASC") . '&meta_key=budgets&orderby=meta_value_num';
foreach ($_GET as $key => $value) {
if ($key != 'meta_key' && $key != 'orderby' && $key != 'order') {
$ge .= '&' . $key . "=" . $value;
}
}
//------------------------
$ge2 = 'order=' . ($_GET['order'] == 'ASC' ? "DESC" : "ASC") . '&orderby=title';
foreach ($_GET as $key => $value) {
if ($key != 'orderby' && $key != 'order') {
$ge2 .= '&' . $key . "=" . $value;
}
}
//------------------------
$ge3 = 'order=' . ($_GET['order'] == 'ASC' ? "DESC" : "ASC") . '&meta_key=views&orderby=meta_value_num';
foreach ($_GET as $key => $value) {
if ($key != 'meta_key' && $key != 'orderby' && $key != 'order') {
$ge3 .= '&' . $key . "=" . $value;
}
}
?>
<?php
_e("Order by:", "ProjectTheme");
$ProjectTheme_advanced_search_page_id = get_option('ProjectTheme_advanced_search_page_id');
if (ProjectTheme_using_permalinks()) {
$adv = get_permalink($ProjectTheme_advanced_search_page_id) . "?";
} else {
$adv = get_permalink($ProjectTheme_advanced_search_page_id) . "&";
}
?>
<a href="<?php
echo $adv;
echo $ge;
?>
"><?php
_e("Price", "ProjectTheme");
?>
</a> |
<a href="<?php
echo $adv;
echo $ge2;
?>
"><?php
_e("Name", "ProjectTheme");
?>
</a> |
<a href="<?php
echo $adv;
echo $ge3;
?>
"><?php
_e("Visits", "ProjectTheme");
?>
</a>
</div>
<div>
<input form="filter-form" type="button" onclick="do_filters_clear()" value="<?php
_e("Clear Filters", "ProjectTheme");
?>
" id="clear-filters-btn" name="clear-filters" class="big-search-submit2" />
</div>
<script>
function do_filters_clear(){
jQuery('#filter-form').find('input,select').not('[name=ref-search]').val('');
jQuery('#filter-form').find('#visits-over').val(0);
jQuery('#filter-form').find('input[type=checkbox]').prop( "checked", false );
}
</script>
</li>
<?php
dynamic_sidebar('other-page-area');
?>
</div>
<?php
}
