Skip to main content

How to create search filter with ajax in Laravel 8?

Create search filter with ajax in Laravel 8


<?php
function ajax_group_list(Request $request){
$group = DB::table('group');
$group->join('users', 'users.id', '=', 'group.userid_createdby');
if (!empty($request->search)) {
$group->where('group.gg_name', 'Like', '%' . $request->search . '%');
$group->orWhere('users.displayname', 'Like', '%' . $request->search . '%');
$group->orWhere('users.email', 'Like', '%' . $request->search . '%');
}

if (!empty($request->search_city)) {
$group->where('group.gg_city', 'Like', '%' . $request->search_city . '%');
}

if (!empty($request->search_state)) {
$group->where('group.gg_state', 'Like', '%' . $request->search_state . '%');
}

if (!empty($request->search_country)) {
$group->where('group.gg_country', 'Like', '%' . $request->search_country . '%');

if(!empty($request->date_range)){
$string = explode(' - ',$request->date_range);
$date1 = explode('/',$string[0]);
$date2 = explode('/',$string[1]);
$search_fromdate1 = $date1[0].'-'.$date1[1].'-'.$date1[2];
$search_todate1 = $date2[0].'-'.$date2[1].'-'.$date2[2];
$search_fromdate = date("Y-m-d", strtotime($search_fromdate1));
$search_todate = date("Y-m-d", strtotime($search_todate1)); 
$group->whereDate('group.created_at', '>=', $search_fromdate);
$group->whereDate('group.created_at', '<=', $search_todate);
}
$group->where('group.gg_type', 0);
$group->groupBy('group.id');
$group->select('group.*','users.displayname','users.email','users.profile_pic');
$group = $group->get();
$group_rows = view('admin.group.group-row', ['group' => $group])->render();
return response()->json(array('success' => 1, 'list_row'=>$group_rows));
}

Comments

Popular posts from this blog

How to use inner html value or data in php from javascript(innerHTML)?

 use inner html value or data in php from javascript(innerHTML)? <html> <body> <p id="demo">use inner html value in php(innerhtml)</p> <script>   var jassi = document.getElementById("demo").innerHTML;   //document.write(jassi); </script> <?php $jassi = '<script>document.write(jassi);</script>'; echo $jassi; ?> </body> </html>

How to get store data from WCFM(Best Multi Vendor Marketplace) Plugin?

 Get store data from WCFM(Best Multi Vendor Marketplace) Plugin. global $WCFM, $WCFMmp, $wp, $WCFM_Query, $post; $store_id = ''; if ( isset( $attr['id'] ) && !empty( $attr['id'] ) ) { $store_id = absint($attr['id']); } if (  wcfm_is_store_page() ) { $wcfm_store_url = get_option( 'wcfm_store_url', 'store' ); $store_name = apply_filters( 'wcfmmp_store_query_var', get_query_var( $wcfm_store_url ) ); $store_id  = 0; if ( !empty( $store_name ) ) { $store_user = get_user_by( 'slug', $store_name ); } $store_id    = $store_user->ID; } $user_id = $store_id;  $vendor_data = get_user_meta( $user_id, 'wcfmmp_profile_settings', true ); $street_1 = $vendor_data['address']['street_1']; $street_2 = $vendor_data['address']['street_2']; $city     = $vendor_data['address']['city']; $zip      = $vendor_data['address']['zip&#

How to create login with phone number in woocommerce wordpress?

Create login with phone number in woocommerce wordpress. function wooc_extra_register_fields() {?>        <p class="form-row form-row-wide">        <label for="reg_billing_phone"><?php _e( 'Phone', 'woocommerce' ); ?><span class="required">*</span></label>        <input type="text" class="input-text" name="billing_phone" id="reg_billing_phone" value="<?php esc_attr_e( $_POST['billing_phone'] ); ?>" />        </p>            <?php  }  add_action( 'woocommerce_register_form_start', 'wooc_extra_register_fields' );  function wooc_validate_extra_register_fields( $username, $email, $validation_errors ) { if ( isset( $_POST['billing_phone'] ) ) {    $hasPhoneNumber= get_users('meta_value='.$_POST['billing_phone']);    if ( !empty($hasPhoneNumber)) {      $validation_er