function ProjectTheme_display_provider_search_page_disp()
{
?>
<div id="content" >
<div class="my_box3">
<div class="padd10">
<div class="box_content">
<?php
$ProjectTheme_enable_2_user_tp = get_option('ProjectTheme_enable_2_user_tp');
$pg = $_GET['pg'];
if (empty($pg)) {
$pg = 1;
}
$nrRes = 10;
//------------------
$offset = ($pg - 1) * $nrRes;
//------------------
if (isset($_GET['username'])) {
$args['search'] = "*" . trim($_GET['username']) . "*";
}
// prepare arguments
$args['orderby'] = 'display_name';
$arr_aray = array();
if (!empty($_GET['rating_over'])) {
$arr_sbg = array('key' => 'cool_user_rating', 'value' => $_GET['rating_over'], 'compare' => '>');
array_push($arr_aray, $arr_sbg);
}
if ($ProjectTheme_enable_2_user_tp == "yes") {
$arr_sbg = array('key' => 'user_tp', 'value' => 'service_provider', 'compare' => '=');
array_push($arr_aray, $arr_sbg);
}
//-----------------------------------------------
$args['meta_query'] = $arr_aray;
$args['number'] = $nrRes;
$args['offset'] = $offset;
$args['count_total'] = true;
//-----------------------------------------------
$wp_user_query = new WP_User_Query($args);
// Get the results
$ttl = $wp_user_query->total_users;
$nrPages = ceil($ttl / $nrRes);
$authors = $wp_user_query->get_results();
// Check for results
if (!empty($authors)) {
foreach ($authors as $author) {
// get all the user's data
ProjectTheme_get_user_table_row($author->ID);
}
echo '<div class="div_class_div">';
$totalPages = $nrPages;
$my_page = $pg;
$page = $pg;
$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 = $page + 1;
if ($next_pg > $totalPages) {
$next_pg = 1;
}
if ($my_page > 1) {
echo '<a href="' . projectTheme_provider_search_link() . 'pg=' . $previous_pg . '" class="bighi"><< ' . __('Previous', 'ProjectTheme') . '</a>';
echo '<a href="' . projectTheme_provider_search_link() . 'pg=' . $start_me . '" class="bighi"><<</a>';
}
for ($i = $start; $i <= $end; $i++) {
if ($i == $pg) {
echo '<a href="#" class="bighi" id="activees">' . $i . '</a>';
} else {
echo '<a href="' . projectTheme_provider_search_link() . 'pg=' . $i . '" class="bighi">' . $i . '</a>';
}
}
if ($totalPages > $my_page) {
echo '<a href="' . projectTheme_provider_search_link() . 'pg=' . $end_me . '" class="bighi">>></a>';
}
if ($page < $totalPages) {
echo '<a href="' . projectTheme_provider_search_link() . 'pg=' . $next_pg . '" class="bighi">' . __('Next', 'ProjectTheme') . ' >></a>';
}
echo '</div>';
} else {
echo 'No authors found';
}
?>
</div>
</div>
</div>
</div>
<!-- ############## -->
<div id="right-sidebar"> <ul class="xoxo">
<li class="">
<h3 class="widget-title"><?php
_e('Filter Options', 'ProjectTheme');
?>
</h3>
<form method="get">
<table width="100%">
<tr>
<td><?php
_e('Username Like', 'ProjectTheme');
?>
</td>
<td><input type="text" size="20" value="<?php
echo $_GET['username'];
?>
" name="username" /></td>
</tr>
<tr>
<td><?php
_e('Rating Over', 'ProjectTheme');
?>
</td>
<td><input type="text" size="10" value="<?php
echo $_GET['rating_over'];
?>
" name="rating_over" /> [0-5]</td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="<?php
_e('Search', 'ProjectTheme');
?>
" name="search_provider" /></td>
</tr>
</table>
</form>
<div class="clear10"></div>
</li>
<?php
dynamic_sidebar('other-page-area');
?>
</ul>
</div>
<?php
}
function ProjectTheme_display_provider_search_page_disp()
{
?>
<div id="content" >
<div class="my_box3">
<div class="padd10">
<div class="box_content">
<?php
$ProjectTheme_enable_2_user_tp = get_option('ProjectTheme_enable_2_user_tp');
$pg = $_GET['pg'];
if (empty($pg)) {
$pg = 1;
}
$nrRes = 10;
//------------------
$offset = ($pg - 1) * $nrRes;
//------------------
if (isset($_GET['username'])) {
$args['search'] = "*" . trim($_GET['username']) . "*";
}
$args['search_columns'] = array('user_login');
// prepare arguments
$args['orderby'] = 'display_name';
$arr_aray = array();
if (!empty($_GET['rating_over']) || $_GET['rating_over'] == '0') {
if ($_GET['rating_over'] == '0') {
$zero_rait = 1;
} else {
$arr_sbg = array('key' => 'cool_user_rating', 'value' => array($_GET['rating_over'], $_GET['rating_over'] + 0.9), 'compare' => 'BETWEEN');
array_push($arr_aray, $arr_sbg);
}
}
if ($ProjectTheme_enable_2_user_tp == "yes") {
$arr_sbg = array('key' => 'user_tp', 'value' => 'service_provider', 'compare' => '=');
array_push($arr_aray, $arr_sbg);
}
//-----------------------------------------------
$args['meta_query'] = $arr_aray;
$args['number'] = $nrRes;
$args['offset'] = $offset;
$args['count_total'] = true;
//-----------------------------------------------
$wp_user_query = new WP_User_Query($args);
// Get the results
$ttl = $wp_user_query->total_users;
$nrPages = ceil($ttl / $nrRes);
$authors = $wp_user_query->get_results();
// Check for results
if (!empty($authors)) {
foreach ($authors as $author) {
// get all the user's data
if ($zero_rait) {
global $wpdb;
$s = "select grade from " . $wpdb->prefix . "project_ratings where touser='******' AND awarded='1'";
$r = $wpdb->get_results($s);
if (count($r) != 0) {
continue;
}
}
ProjectTheme_get_user_table_row($author->ID, $zero_rait);
}
echo '<div class="div_class_div">';
$totalPages = $nrPages;
$my_page = $pg;
$page = $pg;
$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 = $page + 1;
if ($next_pg > $totalPages) {
$next_pg = 1;
}
if ($my_page > 1) {
echo '<a href="' . projectTheme_provider_search_link() . 'pg=' . $previous_pg . '&username='******'username'] . '&rating_over=' . $_GET['rating_over'] . '" class="bighi"><< ' . __('Previous', 'ProjectTheme') . '</a>';
echo '<a href="' . projectTheme_provider_search_link() . 'pg=' . $start_me . '&username='******'username'] . '&rating_over=' . $_GET['rating_over'] . '" class="bighi"><<</a>';
}
for ($i = $start; $i <= $end; $i++) {
if ($i == $pg) {
echo '<a href="#" class="bighi" id="activees">' . $i . '</a>';
} else {
echo '<a href="' . projectTheme_provider_search_link() . 'pg=' . $i . '&username='******'username'] . '&rating_over=' . $_GET['rating_over'] . '" class="bighi">' . $i . '</a>';
}
}
if ($totalPages > $my_page) {
echo '<a href="' . projectTheme_provider_search_link() . 'pg=' . $end_me . '&username='******'username'] . '&rating_over=' . $_GET['rating_over'] . '" class="bighi">>></a>';
}
if ($page < $totalPages) {
echo '<a href="' . projectTheme_provider_search_link() . 'pg=' . $next_pg . '&username='******'username'] . '&rating_over=' . $_GET['rating_over'] . '" class="bighi">' . __('Next', 'ProjectTheme') . ' >></a>';
}
echo '</div>';
} else {
echo 'No authors found';
}
?>
</div>
</div>
</div>
</div>
<!-- ############## -->
<div id="right-sidebar"> <ul class="xoxo">
<li class="">
<h3 class="widget-title"><?php
_e('Filter Options', 'ProjectTheme');
?>
</h3>
<form method="get">
<table width="100%">
<tr>
<td><?php
_e('Username Like', 'ProjectTheme');
?>
</td>
<td><input type="text" size="20" value="<?php
echo $_GET['username'];
?>
" name="username" /></td>
</tr>
<tr>
<td><?php
_e('Rating', 'ProjectTheme');
?>
</td>
<td><input type="text" size="10" value="<?php
echo $_GET['rating_over'];
?>
" name="rating_over" /> [0-5]</td>
</tr>
<script type="text/javascript">
$(document).ready(function(){
$( 'input[name="rating_over"]' ).keypress(function( event ) {
var kk = event.which;
if(kk == 13){
return true;
}else if((kk>47 && kk<54) || kk==0 || kk==8){
$(this).val('');
return true;
}else{
return false;
}
});
});
</script>
<tr>
<td></td>
<td><input type="submit" value="<?php
_e('Search', 'ProjectTheme');
?>
" name="search_provider" /></td>
</tr>
</table>
</form>
<div class="clear10"></div>
</li>
<?php
dynamic_sidebar('other-page-area');
?>
</ul>
</div>
<?php
}