Skip to content

Instantly share code, notes, and snippets.

@imranhoshain

imranhoshain/Entrepreneur & Investor Search Without Pagination

Created December 25, 2021 17:34
Show Gist options
  • Save imranhoshain/18caa7a37ae489cd3a87338a23a90c1a to your computer and use it in GitHub Desktop.
Save imranhoshain/18caa7a37ae489cd3a87338a23a90c1a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Entrepreneur & Investor Search Without Pagination
<?php
// child here
function ptc_my_theme_enqueue_styles()
{
$parent_style = "parent-style"; //
//wp_enqueue_style( $parent_style, get_template_directory_uri() . '/style.css' );
wp_enqueue_style(
"child-style",
get_stylesheet_directory_uri() . "/style.css",
[$parent_style],
wp_get_theme()->get("Version")
);
}
add_action("wp_enqueue_scripts", "ptc_my_theme_enqueue_styles");
//Entrepreneur All User ShortCode
if(!function_exists('entrepreneur_all_user_list_shortcode'))
{
function entrepreneur_all_user_list_shortcode($uid)
{
$get_user_info = get_userdata($uid);
$all_meta_for_user = get_user_meta($uid);
$full_name = $get_user_info->first_name. ' '. $get_user_info->last_name;
$full_name_tem = trim($full_name);
if(empty($full_name_tem)) $full_name = $get_user_info->user_login;
?>
<div class="user-table-row">
<div class="row">
<div class="col-xs-12 col-sm-8 col-md-4 col-lg-2 av-usr">
<div class="full-width-div">
<a href="<?php echo ProjectTheme_get_user_profile_link($uid); ?>"><img src="<?php echo ProjectTheme_get_avatar($uid,95, 95) ?>"
alt="avatar-user" class="acc_m1 av1z" width="95" height="95" />
</a>
<?php //echo get_avatar($uid, 64 );?>
</div>
</div>
<div class="user-table-user-info col-xs-12 col-sm-4 col-md-8 col-lg-10">
<h3>
<a href="<?php echo ProjectTheme_get_user_profile_link($uid) ?>"><?php echo $full_name ?>
</a>
</h3>
<p class="about-ttl">About:</p>
<p class="excerpt-thing pt-0">
<?php
$user_description = get_user_meta($uid,'user_description',true);
$user_description = strip_tags($user_description);
if(empty($user_description)) _e('This user doesnt have a description.','ProjectTheme');
else{
echo substr(trim($user_description),0,270);
}
?>
</p>
<p class="about-ttl">Location: </p>
<div class="row-with-tags">
<h5 class="my-badge3">
<?php
$user_location = get_user_meta($uid,'user_location',true);
$user_location = strip_tags($user_location);
if(empty($user_location)) _e('This user doesnt select any location.','ProjectTheme');
else{
echo substr(trim($user_location),0,270);
}
?>
</h5>
</div>
<div class="user-poster-thing">
<div class="user-avatar-me fun-time">
<div class="post-main-details">
<ul>
<li><?php echo ProjectTheme_project_get_star_rating($uid); ?></li>
<li>
<a href="<?php echo ProjectTheme_get_priv_mess_page_url('send', '', '&uid='.$uid.'&pid='); ?>"><?php _e('Contact User','ProjectTheme'); ?>
</a>
</li>
<li class="last">
<a href="<?php echo ProjectTheme_get_user_feedback_link($uid); ?>"><?php _e('User Feedback','ProjectTheme'); ?>
</a>
</li>
</ul>
</div>
</div>
</div>
<!-- end user-poster-thing -->
</div>
</div>
</div>
<?php
}
}
if(!function_exists('entrepreneur_search_shortcode'))
{
function entrepreneur_search_shortcode()
{
global $wpdb;
$args = array(
'role' => 'business_owner',
'orderby' => 'user_nicename',
'order' => 'ASC'
);
?>
<script>
jQuery(document).ready(function() {
jQuery("#filters-button-show-hide").click(function(){
jQuery("#filter-optns").slideToggle();
});
});
</script>
<div id="right-sidebar" class="col-xs-12 col-sm-12 col-md-4 col-lg-3">
<ul class="sidebar-ul" id="search-page-ulz">
<li class="" id="filters-things">
<h3 class="widget-title"><?php _e('Filter Options','ProjectTheme'); ?></h3>
<a href="#" id="filters-button-show-hide"><i class="fas fa-filter"></i></a>
<form method="get" id="filter-optns">
<div class="my_row_m1">
<div class="full_width_m1"><?php _e('Username like:','ProjectTheme'); ?>
</div>
<div class="full_width_m1"><input type="text" class="do_input_search_provider form-control" value="<?php echo htmlentities($_GET['username']); ?>" name="username" />
</div>
</div>
<script>
jQuery(document).ready(function( ) {
jQuery('#onlinestatus').lc_switch('<?php _e('YES', 'ProjectTheme') ?>','<?php _e('NO', 'ProjectTheme') ?>');
});
</script>
<div class="my_row_m1">
<div class="full_width_m1" style="float: left; width: auto"><?php _e('Online status?','ProjectTheme'); ?></div>
<div class="full_width_m1" style="float: right; width: auto"><input type="checkbox" value="1" name="online" id="onlinestatus" <?php echo $_GET['online'] == "1" ? "checked='checked'" : "" ?> /></div>
</div>
<div class="my_row_m1 apply-filters-button-container">
<div class="full_width_m1">
<input type="submit" value="<?php _e('Apply Filters','ProjectTheme'); ?>" class="btn btn-block btn-primary" name="business_owner" />
</div>
</div>
</form>
</li>
<?php dynamic_sidebar( 'other-page-area' ); ?>
</ul>
</div>
<!--############################## -->
<div class='col-xs-12 col-sm-12 col-md-8 col-lg-9' >
<div class="box_content " style="padding:0">
<?php
$ProjectTheme_enable_2_user_tp = get_option('ProjectTheme_enable_2_user_tp');
$pg = $_GET['pg'];
if(empty($pg)) $pg = 1;
$nrRes = 8;
//------------------
$offset = ($pg-1)*$nrRes;
//------------------
if(isset($_GET['username']))
$args['search'] = "*".trim($_GET['username'])."*";
// prepare arguments
$args['orderby'] = 'display_name';
$arr_aray = array();
$inner = '';
$where = '';
$rf_demo = true;
$rf_demo = apply_filters("ProjectTheme_rf_demo", $rf_demo);
if($ProjectTheme_enable_2_user_tp == "yes" and $rf_demo)
{
$arr_sbg = array(
// uses compare like WP_Query
'key' => 'user_tp',
'value' => 'business_owner',
'compare' => '='
);
array_push( $arr_aray, $arr_sbg);
}
//-----------------------------------------------
global $wpdb;
$wpdb->show_errors = true;
if(!empty($_GET['username']))
{
$us = addslashes($_GET['username']);
$inner .= ' INNER JOIN '.$wpdb->prefix.'usermeta AS mt2 ON ( '.$wpdb->prefix.'users.ID = mt2.user_id ) INNER JOIN '.$wpdb->prefix.'usermeta AS mt3 ON ( '.$wpdb->prefix.'users.ID = mt3.user_id ) ';
$addition = " AND ( user_login like '%".$us."%' or (mt2.meta_key = 'first_name' AND mt2.meta_value LIKE '%".$us."%')
or (mt3.meta_key = 'last_name' AND mt3.meta_value LIKE '%".$us."%') ) ";
}
//online
if(!empty($_GET['online']))
{
$tm = current_time('timestamp') - 300;
$inner .= ' INNER JOIN '.$wpdb->prefix.'usermeta AS mt5 ON ( '.$wpdb->prefix.'users.ID = mt5.user_id ) ';
$addition .= " AND (mt5.meta_key = 'lastonline' AND mt5.meta_value > $tm) ";
}
//---- main query here ----------
$main_query = "SELECT SQL_CALC_FOUND_ROWS distinct ".$wpdb->prefix."users.* FROM ".$wpdb->prefix."users
".$inner."
INNER JOIN ".$wpdb->prefix."usermeta AS mt1 ON ( ".$wpdb->prefix."users.ID = mt1.user_id )
WHERE 1=1
".$where."
AND mt1.meta_key = '".$wpdb->prefix."capabilities' AND mt1.meta_value LIKE '%business\_owner%' ".$addition." ORDER BY display_name ASC LIMIT ".$offset.", " . $nrRes;
$res = $wpdb->get_results($main_query);
$found_rows = "SELECT FOUND_ROWS() as XROWS";
$res2 = $wpdb->get_results($found_rows);
$fnd_rows = $res2[0]->XROWS;
// Get the results
$ttl = $fnd_rows;
$nrPages = ceil($ttl / $nrRes);
// Check for results
if (count($res) > 0)
{
foreach ($res as $user)
{
// get all the user's data
echo '<div class="card p-3 pt-4 pb-4">';
entrepreneur_all_user_list_shortcode($user->ID);
echo '</div>';
}
echo '<ul class="pagination">';
$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 '<li class="page-item"><a href="" class="page-link"><i class="fas fa-chevron-left"></i> '.__('Previous','ProjectTheme').'</a></li>';
echo '<li class="page-item"><a href="" class="page-link"><</a></li>';
}
for($i=$start;$i<=$end;$i++)
{
if($i == $pg)
echo '<li class="page-item active"><a href="#" class="page-link" >'.$i.'</a></li>';
else
echo '<li class="page-item"><a href="" class="page-link">'.$i.'</a></li>';
}
if($totalPages > $my_page)
echo '<li class="page-item"><a href="" class="page-link">></a></li>';
if($page < $totalPages)
echo '<li class="page-item"><a href="" class="page-link">'.__('Next','ProjectTheme').' <i class="fas fa-chevron-right"></i></a></li>';
echo '</ul>';
} else {
echo '<div class="card p-3">';
echo __('No entrepreneur are found.', 'ProjectTheme' );
echo '</div>';
}
?>
</div>
</div>
<?php
}}
add_shortcode("entrepreneur_search", "entrepreneur_search_shortcode");
//Investor All User ShortCode
if(!function_exists('investor_all_user_list_shortcode'))
{
function investor_all_user_list_shortcode($uid)
{
$get_user_info = get_userdata($uid);
$all_meta_for_user = get_user_meta($uid);
$full_name = $get_user_info->first_name. ' '. $get_user_info->last_name;
$full_name_tem = trim($full_name);
if(empty($full_name_tem)) $full_name = $get_user_info->user_login;
?>
<div class="user-table-row">
<div class="row">
<div class="col-xs-12 col-sm-8 col-md-4 col-lg-2 av-usr">
<div class="full-width-div">
<a href="<?php echo ProjectTheme_get_user_profile_link($uid); ?>"><img src="<?php echo ProjectTheme_get_avatar($uid,95, 95) ?>"
alt="avatar-user" class="acc_m1 av1z" width="95" height="95" />
</a>
<?php //echo get_avatar($uid, 64 );?>
</div>
</div>
<div class="user-table-user-info col-xs-12 col-sm-4 col-md-8 col-lg-10">
<h3>
<a href="<?php echo ProjectTheme_get_user_profile_link($uid) ?>"><?php echo $full_name ?>
</a>
</h3>
<p class="about-ttl">About:</p>
<p class="excerpt-thing pt-0">
<?php
$user_description = get_user_meta($uid,'user_description',true);
$user_description = strip_tags($user_description);
if(empty($user_description)) _e('This user doesnt have a description.','ProjectTheme');
else{
echo substr(trim($user_description),0,270);
}
?>
</p>
<p class="about-ttl">Location: </p>
<div class="row-with-tags">
<h5 class="my-badge3">
<?php
$user_location = get_user_meta($uid,'user_location',true);
$user_location = strip_tags($user_location);
if(empty($user_location)) _e('This user doesnt select any location.','ProjectTheme');
else{
echo substr(trim($user_location),0,270);
}
?>
</h5>
</div>
<div class="user-poster-thing">
<div class="user-avatar-me fun-time">
<div class="post-main-details">
<ul>
<li><?php echo ProjectTheme_project_get_star_rating($uid); ?></li>
<li>
<a href="<?php echo ProjectTheme_get_priv_mess_page_url('send', '', '&uid='.$uid.'&pid='); ?>"><?php _e('Contact User','ProjectTheme'); ?>
</a>
</li>
<li class="last">
<a href="<?php echo ProjectTheme_get_user_feedback_link($uid); ?>"><?php _e('User Feedback','ProjectTheme'); ?>
</a>
</li>
</ul>
</div>
</div>
</div>
<!-- end user-poster-thing -->
</div>
</div>
</div>
<?php
}
}
if(!function_exists('investor_search_shortcode'))
{
function investor_search_shortcode()
{
global $wpdb;
$args = array(
'role' => 'business_owner',
'orderby' => 'user_nicename',
'order' => 'ASC'
);
?>
<script>
jQuery(document).ready(function() {
jQuery("#filters-button-show-hide").click(function(){
jQuery("#filter-optns").slideToggle();
});
});
</script>
<div id="right-sidebar" class="col-xs-12 col-sm-12 col-md-4 col-lg-3">
<ul class="sidebar-ul" id="search-page-ulz">
<li class="" id="filters-things">
<h3 class="widget-title"><?php _e('Filter Options','ProjectTheme'); ?></h3>
<a href="#" id="filters-button-show-hide"><i class="fas fa-filter"></i></a>
<form method="get" id="filter-optns">
<div class="my_row_m1">
<div class="full_width_m1"><?php _e('Username like:','ProjectTheme'); ?>
</div>
<div class="full_width_m1"><input type="text" class="do_input_search_provider form-control" value="<?php echo htmlentities($_GET['username']); ?>" name="username" />
</div>
</div>
<script>
jQuery(document).ready(function( ) {
jQuery('#onlinestatus').lc_switch('<?php _e('YES', 'ProjectTheme') ?>','<?php _e('NO', 'ProjectTheme') ?>');
});
</script>
<div class="my_row_m1">
<div class="full_width_m1" style="float: left; width: auto"><?php _e('Online status?','ProjectTheme'); ?></div>
<div class="full_width_m1" style="float: right; width: auto"><input type="checkbox" value="1" name="online" id="onlinestatus" <?php echo $_GET['online'] == "1" ? "checked='checked'" : "" ?> /></div>
</div>
<div class="my_row_m1 apply-filters-button-container">
<div class="full_width_m1">
<input type="submit" value="<?php _e('Apply Filters','ProjectTheme'); ?>" class="btn btn-block btn-primary" name="investor" />
</div>
</div>
</form>
</li>
<?php dynamic_sidebar( 'other-page-area' ); ?>
</ul>
</div>
<!--############################## -->
<div class='col-xs-12 col-sm-12 col-md-8 col-lg-9' >
<div class="box_content " style="padding:0">
<?php
$ProjectTheme_enable_2_user_tp = get_option('ProjectTheme_enable_2_user_tp');
$pg = $_GET['pg'];
if(empty($pg)) $pg = 1;
$nrRes = 8;
//------------------
$offset = ($pg-1)*$nrRes;
//------------------
if(isset($_GET['username']))
$args['search'] = "*".trim($_GET['username'])."*";
// prepare arguments
$args['orderby'] = 'display_name';
$arr_aray = array();
$inner = '';
$where = '';
$rf_demo = true;
$rf_demo = apply_filters("ProjectTheme_rf_demo", $rf_demo);
if($ProjectTheme_enable_2_user_tp == "yes" and $rf_demo)
{
$arr_sbg = array(
// uses compare like WP_Query
'key' => 'user_tp',
'value' => 'investor',
'compare' => '='
);
array_push( $arr_aray, $arr_sbg);
}
//-----------------------------------------------
global $wpdb;
$wpdb->show_errors = true;
if(!empty($_GET['username']))
{
$us = addslashes($_GET['username']);
$inner .= ' INNER JOIN '.$wpdb->prefix.'usermeta AS mt2 ON ( '.$wpdb->prefix.'users.ID = mt2.user_id ) INNER JOIN '.$wpdb->prefix.'usermeta AS mt3 ON ( '.$wpdb->prefix.'users.ID = mt3.user_id ) ';
$addition = " AND ( user_login like '%".$us."%' or (mt2.meta_key = 'first_name' AND mt2.meta_value LIKE '%".$us."%')
or (mt3.meta_key = 'last_name' AND mt3.meta_value LIKE '%".$us."%') ) ";
}
//online
if(!empty($_GET['online']))
{
$tm = current_time('timestamp') - 300;
$inner .= ' INNER JOIN '.$wpdb->prefix.'usermeta AS mt5 ON ( '.$wpdb->prefix.'users.ID = mt5.user_id ) ';
$addition .= " AND (mt5.meta_key = 'lastonline' AND mt5.meta_value > $tm) ";
}
//---- main query here ----------
$main_query = "SELECT SQL_CALC_FOUND_ROWS distinct ".$wpdb->prefix."users.* FROM ".$wpdb->prefix."users
".$inner."
INNER JOIN ".$wpdb->prefix."usermeta AS mt1 ON ( ".$wpdb->prefix."users.ID = mt1.user_id )
WHERE 1=1
".$where."
AND mt1.meta_key = '".$wpdb->prefix."capabilities' AND mt1.meta_value LIKE '%investor%' ".$addition." ORDER BY display_name ASC LIMIT ".$offset.", " . $nrRes;
$res = $wpdb->get_results($main_query);
$found_rows = "SELECT FOUND_ROWS() as XROWS";
$res2 = $wpdb->get_results($found_rows);
$fnd_rows = $res2[0]->XROWS;
// Get the results
$ttl = $fnd_rows;
$nrPages = ceil($ttl / $nrRes);
// Check for results
if (count($res) > 0)
{
foreach ($res as $user)
{
// get all the user's data
echo '<div class="card p-3 pt-4 pb-4">';
entrepreneur_all_user_list_shortcode($user->ID);
echo '</div>';
}
echo '<ul class="pagination">';
$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 '<li class="page-item"><a href="" class="page-link"><i class="fas fa-chevron-left"></i> '.__('Previous','ProjectTheme').'</a></li>';
echo '<li class="page-item"><a href="" class="page-link"><</a></li>';
}
for($i=$start;$i<=$end;$i++)
{
if($i == $pg)
echo '<li class="page-item active"><a href="#" class="page-link" >'.$i.'</a></li>';
else
echo '<li class="page-item"><a href="" class="page-link">'.$i.'</a></li>';
}
if($totalPages > $my_page)
echo '<li class="page-item"><a href="" class="page-link">></a></li>';
if($page < $totalPages)
echo '<li class="page-item"><a href="" class="page-link">'.__('Next','ProjectTheme').' <i class="fas fa-chevron-right"></i></a></li>';
echo '</ul>';
} else {
echo '<div class="card p-3">';
echo __('No entrepreneur are found.', 'ProjectTheme' );
echo '</div>';
}
?>
</div>
</div>
<?php
}}
add_shortcode("investor_search", "investor_search_shortcode");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment