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_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 }