File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/table/bt_assigned_customer_update.php

Back
<?php include_once("../../cfg/db.php"); include_once("../../api/controllers/utility.php"); if(!isset($_SESSION['user']['id'])){ echo "Session Expired."; exit; } // echo'<pre>';print_r($_SESSION['user']);echo'</pre>'; $user_dealer_id = (isset($_SESSION['user']['dealer']) ? $_SESSION['user']['dealer'] : 0); $current_employee_id = $_SESSION['user']['employee_id']; $utility = new Utility(); $my_customer_record_id = $_SESSION['user']['id']; $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ; // $fields_permissions = $utility->isNotEmpty($_SESSION['user']['fields_permissions']) ? $_SESSION['user']['fields_permissions'] : '-1' ; if(isset($_REQUEST['search'])){ $search = $db -> escape(trim($_REQUEST['search'])); $primary_search = $search_condition = (strlen($search) > 0 ? " AND CONCAT(e.first_name, ' ', e.last_name) LIKE '%" . $search . "%'" : ""); }else{ $search=""; } if(isset($_REQUEST['offset'])){ $offset = $db -> escape(trim($_REQUEST['offset'])); }else{ $offset=""; } if(isset($_REQUEST['my_records'])){ $my_record_bool = filter_var($_REQUEST['my_records'], FILTER_VALIDATE_BOOLEAN); if($my_record_bool){ $my_record=" AND (t1.upload_by='$my_customer_record_id' OR t1.modified_by='$my_customer_record_id') "; }else{ $my_record=""; } }else{ $my_record=""; } $customer_corporation = (isset($_REQUEST['customer_corporation']) && $_REQUEST['customer_corporation']) ? " AND t1.corporation_id = '".$_REQUEST['customer_id']."' " : "" ; if(isset($_REQUEST['limit'])){ $limit = $db -> escape(trim($_REQUEST['limit'])); if(isset($_REQUEST['grid'])){ $page = $_REQUEST['offset']; if($page){ $start = ($page - 1) * $limit; //first item to display on this page $offset = ($page - 1) * $limit; }else{ $start = 0; } } $offset_limit = " LIMIT ". $offset.",".$limit; // echo $offset_limit;exit; } else { $offset_limit = ""; } $where_age = " TIMESTAMPDIFF(YEAR,t1.date_of_birth, CURDATE() ) "; //FILTERS $type = (isset($_REQUEST['type']) && $_REQUEST['type'] != '0') ? " AND t1.type = '".$_REQUEST['type']."' " : "" ; $gender = (isset($_REQUEST['gender']) && $_REQUEST['gender'] != 'all') ? " AND t1.gender_id = '".$_REQUEST['gender']."' " : "" ; $dms = (isset($_REQUEST['dms']) && $_REQUEST['dms'] != '0') ? " AND sd.id = '".$_REQUEST['dms']."' " : "" ; $company = (isset($_REQUEST['company']) && $_REQUEST['company'] != '0') ? " AND scd.company_id = '".$_REQUEST['company']."' " : "" ; $age = "" ; if(isset($_REQUEST['filter_age']) && $_REQUEST['filter_age'] != '0'){ switch($_REQUEST['filter_age']){ case "below": $age = "AND $where_age <= 30 "; break; case "between": $age = "AND $where_age <= 50 AND $where_age >= 31 "; break; case "above": $age = "AND $where_age >= 51 "; break; } } $customer_actions = "" ; if(isset($_REQUEST['customer_actions']) && $_REQUEST['customer_actions'] != '0'){ switch($_REQUEST['customer_actions']){ case "all": $customer_actions = ""; break; case "new": $customer_actions = " AND t1.date_uploaded > DATE_SUB(NOW(), INTERVAL 1 WEEK) "; break; case "updated": $customer_actions = " AND t1.date_modified > DATE_SUB(NOW(), INTERVAL 1 WEEK) "; break; case "added": $customer_actions = " AND t1.date_uploaded > DATE_SUB(NOW(), INTERVAL 1 DAY) "; break; } } $complete_data = ""; $incomplete_data = ""; $mobile_phone_1 = ""; $email_1 = ""; $address_1 = ""; $date_of_birth =""; if(isset($_REQUEST['filter_data']) && $_REQUEST['filter_data'] != '0'){ switch($_REQUEST['filter_data']){ case "Complete Data": $complete_data = " AND ((IFNULL(DATE_FORMAT(t1.`date_of_birth`,'%%Y-%%m-%%d'),'') <> '' and t1.gender_id <> 0 and cc.address_1 <> '' and cc.email_1 <> '' and cc.mobile_phone_1 <> '') AND t1.type = 1) OR (cc.address_1 <> '' AND cc.email_1 <> '' AND t1.type = 2) "; break; case "Incomplete Data": $incomplete_data = " AND ((IFNULL(DATE_FORMAT(t1.`date_of_birth`,'%%Y-%%m-%%d'),'') = '' or t1.gender_id = 0 or cc.address_1 = '' or cc.email_1 = '' ) AND t1.type = 1) OR (cc.address_1 = '' or cc.email_1 = '' AND t1.type = 2) "; break; case "No Mobile": $mobile_phone_1 = " AND cc.mobile_phone_1 = '' "; break; case "No Email": $email_1 = " AND cc.email_1 = '' "; break; case "No Address": $address_1 = " AND cc.address_1 = '' "; break; case "No Gender": $gender = " AND t1.gender_id = '0' AND t1.type = '1' "; break; case "No Date of birth": $date_of_birth = " AND IFNULL(DATE_FORMAT(t1.`date_of_birth`,'%%Y-%%m-%%d'),'') = '' AND t1.type = '1' "; break; } } // if(isNotEmpty($search)){ // $filter_email = " OR cc.email_1 = '".$search."' "; // }else{ // $filter_email = ""; // } // if(isNotEmpty($dms) \|\| isNotEmpty($company)){ // $group_by = " GROUP BY t1.id "; // }else{ // $group_by = " GROUP BY t1.id "; // } $data_counter = 0; $json_arr['rows'] = array(); // $group_bys =" GROUP BY cua.user_id ORDER BY cua.id" ; $query ="SELECT %s FROM cu_dealer_users_assign cua LEFT OUTER JOIN employee e ON cua.user_id = e.employee_id LEFT OUTER JOIN source_dealer sc ON cua.dealer_id = sc.id LEFT JOIN inactive_customer icu ON cua.customer_id = icu.id WHERE cua.user_id ='".$current_employee_id."' AND cua.is_removed =0 %s GROUP BY cua.dealer_ref_header ORDER BY cua.dealer_batch_no DESC "; // $query = " SELECT %s // FROM cu_assign cu LEFT JOIN cu_assigned_user cua ON cu.ref_num_header =cua.ref_num_header LEFT JOIN inactive_customer icu ON cu.customer_id = icu.id WHERE cu.dealer_id = ".$user_dealer_id ." AND cu.active =1 %s "; // -- // -- LIKE // -- /'%%%s%%' / 1 search / // -- // -- ) // -- // -- %s / email / // -- // -- %s / 3 gender / // -- // -- %s / 4 dms / // -- // -- %s / 5 age / // -- // -- %s / 6 complete data / // -- // -- %s / 7 incomplete data / // -- // -- %s / 8 mobile phone / // -- // -- %s / 9 email / // -- // -- %s / 10 address / // -- // -- %s / 11 dateofbirth / // -- // -- %s / 12 company / // -- // -- %s / 13 corporation_customer / // -- // -- %s / 14 customer_actions / // -- // -- ) // -- // -- -- AND t1.status = 1 // -- // -- %s / myrec / // -- // -- %s / 2 type / // %s / 13 group / /ORDER BY t1.id DESC/ // $fields = "cu.hid,cu.ref_num_header,cu.batch_no,cu.dealer_id,(select name from source_dealer where id = dealer_id) dealer,cua.user_id, // (CASE // WHEN cu.batch_type =1 THEN 'Auto assigned' // WHEN cu.batch_type=2 THEN 'manually assigned' // ELSE '' // END) AS assign_type // ,cu.active,count(cu.customer_id) AS total // ,count(DISTINCT CASE WHEN DATEDIFF(NOW(), icu.date_modified)<=7 THEN icu.date_modified END) as total_icu_updated"; $fields ="icu.id as customer_id,cua.user_id,cua.ref_num_header,cua.dealer_ref_header,cua.dealer_batch_no,cua.dealer_id,concat(e.first_name,' ',IF(length(e.middle_name)>0,concat(e.middle_name,'. '),''),e.last_name) as employee,(select concat(e.first_name,' ',e.last_name) from employee e where e.id = cua.assigned_by) as assigned_by,sc.name as dealer_name,DATE_FORMAT(cua.created_at,'%M %d, %Y %r') AS date_assigned,COUNT(cua.id) AS nos, count(DISTINCT CASE WHEN DATEDIFF(NOW(), icu.date_modified)<=7 THEN icu.date_modified END) as total_icu_updated"; $count = " 1 "; // echo (sprintf($query,$fields,$search,$search,$filter_email,$gender,$dms,$age ,$complete_data, $incomplete_data,$mobile_phone_1,$email_1,$address_1,$date_of_birth,$company,$customer_corporation,$customer_actions,$my_record,$type,$group_by)." $offset_limit");exit; $final_query = sprintf($query,$fields,$primary_search)." $offset_limit"; // echo($final_query);exit; $exec_query = $db -> sql_query($final_query); // $query_count = $db -> select("SELECT COUNT() FROM ( ".sprintf($query,$count,$search,$filter_email,$gender,$dms,$age,$complete_data,$incomplete_data,$mobile_phone_1,$email_1,$address_1,$date_of_birth,$company,$customer_corporation,$customer_actions,$my_record,$type,$group_by)." ) as total_count"); // $query_count1 =$db->sql_query("select ref_num_header from cu_assign where active =1 group by ref_num_header"); // $query_count1 = $db->sql_query("select cu_assign.ref_num_header,cu_assigned_user.user_id,cu_assigned_user.ref_num_header from cu_assign // LEFT JOIN cu_assigned_user ON cu_assign.ref_num_header = cu_assigned_user.ref_num_header where cu_assign.active =1 group by cu_assign.ref_num_header"); // $query_count = $query_count1->num_rows; // $json_arr['total'] = $query_count; //total number of result if(isset($_REQUEST['grid'])){ $json_arr['customer_list'] = ""; $json_arr['customer_list_paging'] = ""; $total = intval($query_count);//100;//$json_arr['total']; /* Setup page vars for display. / if ($page == 0) $page = 1; //if no page var is given, default to 1. $prev = $page - 1; //previous page is current page - 1 $next = $page + 1; //next page is current page + 1 $lastpage = ceil($total/$limit); //lastpage. $lpm1 = $lastpage - 1; //last page minus 1 $counter=0; $adjacents = 1; $lpm1 = $lastpage - 1; //last page minus 1 if($lastpage > 1) { $json_arr['customer_list_paging'] .= ""; if ($page > $counter+1) { $json_arr['customer_list_paging'].= " <li class='page-item' style='cursor:pointer' ><a class='page-link' onclick='gotoOffsetCustomer(".$prev.")' hidden>Prev</a></li>"; } if ($lastpage < 7 + ($adjacents 2)){ for ($counter = 1; $counter <= $lastpage; $counter++){ if ($counter == $page) $json_arr['customer_list_paging'].= " <li class='page-item active' ><a class='page-link ' onclick='gotoOffsetCustomer(".$counter.")' >$counter</a></li>"; else $json_arr['customer_list_paging'].= " <li class='page-item' style='cursor:pointer' ><a class='page-link' onclick='gotoOffsetCustomer(".$counter.")'>$counter</a></li>"; } } elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some { //close to beginning; only hide later pages if($page < 1 + ($adjacents * 2)){ for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) { if ($counter == $page) $json_arr['customer_list_paging'].= " <li class='page-item active' ><a class='page-link ' >$counter</a></li>"; else $json_arr['customer_list_paging'].= " <li class='page-item' style='cursor:pointer' ><a class='page-link' onclick='gotoOffsetCustomer(".$counter.")'>$counter</a></li>"; } $json_arr['customer_list_paging'].= " <li class='page-item' style='cursor:pointer' >...</li>"; $json_arr['customer_list_paging'].= " <li class='page-item' style='cursor:pointer' ><a class='page-link' onclick='gotoOffsetCustomer(".$lpm1.")'>$lpm1</a></li>"; $json_arr['customer_list_paging'].= " <li class='page-item' style='cursor:pointer' ><a class='page-link' onclick='gotoOffsetCustomer(".$lastpage.")'>$lastpage</a></li>"; } //in middle; hide some front and some back elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) { $json_arr['customer_list_paging'].= " <li class='page-item' style='cursor:pointer' ><a class='page-link' onclick='gotoOffsetCustomer(1)'>1</a></li>"; $json_arr['customer_list_paging'].= " <li class='page-item' style='cursor:pointer' ><a class='page-link' onclick='gotoOffsetCustomer(2)'>2</a></li>"; $json_arr['customer_list_paging'].= " <li class='page-item' style='cursor:pointer' >...</li>"; for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) { if ($counter == $page) $json_arr['customer_list_paging'].= " <li class='page-item active' ><a class='page-link' >$counter</a></li>"; else $json_arr['customer_list_paging'].= " <li class='page-item' style='cursor:pointer' ><a class='page-link' onclick='gotoOffsetCustomer(".$counter.")' >$counter</a></li>"; } $json_arr['customer_list_paging'].= " <li class='page-item' style='cursor:pointer' >...</li>"; $json_arr['customer_list_paging'].= " <li class='page-item' style='cursor:pointer' ><a class='page-link' onclick='gotoOffsetCustomer(".$lpm1.")' >$lpm1</a></li>"; $json_arr['customer_list_paging'].= " <li class='page-item' style='cursor:pointer' ><a class='page-link' onclick='gotoOffsetCustomer(".$lastpage.")' >$lastpage</a></li>"; } //close to end; only hide early pages else { $json_arr['customer_list_paging'].= " <li class='page-item' style='cursor:pointer' ><a class='page-link' onclick='gotoOffsetCustomer(1)' >1</a></li>"; $json_arr['customer_list_paging'].= " <li class='page-item' style='cursor:pointer' ><a class='page-link' onclick='gotoOffsetCustomer(2)' >2</a></li>"; $json_arr['customer_list_paging'].= " <li class='page-item' style='cursor:pointer' >...</li>"; for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) { if ($counter == $page) $json_arr['customer_list_paging'].= " <li class='page-item active' ><a class='page-link ' >$counter</a></li>"; else $json_arr['customer_list_paging'].= " <li class='page-item' style='cursor:pointer' ><a class='page-link' onclick='gotoOffsetCustomer(".$counter.")' >$counter</a></li>"; } } } //next button if ($page < $counter - 1) $json_arr['customer_list_paging'].= " <li class='page-item' style='cursor:pointer' ><a class='page-link' onclick='gotoOffsetCustomer(".$next.")' hidden>Next</a></li>"; else $json_arr['customer_list_paging'].= ""; } // $goto_offset = 0; // for($i = 0; $i < $json_arr['total'] / $limit; $i++){ // if($offset == $goto_offset){ // $grid_status = "active"; // $grid_offset = ""; // }else{ // $grid_status = ""; // $grid_offset = " onclick='gotoOffsetCustomer(".$goto_offset.")' "; // } // // $json_arr['customer_list_paging'] = $json_arr['customer_list_paging']."<li style='cursor:pointer' class='page-item ".$grid_status."'><a class='page-link' ".$grid_offset.">".($i+1)."</a></li>"; // $goto_offset = $goto_offset+$limit; // } if($total < 1){ $json_arr['customer_list_paging'] = "No Record"; } // $json_arr['grid_offset'] = $goto_offset; // while($row = $exec_query->fetch_assoc()) { // $get_image_query = "SELECT vi.name FROM vehicle v // INNER JOIN vehicle_images vi // ON v.id = vi.vehicle_id // INNER JOIN source_company_dealer scd // ON v.company_dealer_id = scd.id // WHERE 1 // AND v.customer_record_id ='".$row['id']."' // AND scd.company_id IN (".$granted_company_ids.") // AND vi.name <> 'default.png' // AND vi.status <> 0 // ORDER BY v.date_uploaded DESC LIMIT 1"; // // echo $get_image_query; // $get_image_name= $db -> select($get_image_query); // if($get_image_name <> ''){ // $row['photo'] = $get_image_name; // } // $mask_email = $utility->isNotEmpty($row['email_1']) ? $utility->mask_email($row['email_1']) : '<span style="color: red;">(Not Provided)</span>'; // if(isset($_SESSION['user']['fields_permissions']['customer_fields']['fields_email_1'])){ // if($_SESSION['user']['fields_permissions']['customer_fields']['fields_email_1']){ // $mask_email = $row['email_1']; // } // } // $mask_mobile = $utility->isNotEmpty($row['mobile_phone_1']) ? $utility->mask($row['mobile_phone_1'],4,1) : ''; // if(isset($_SESSION['user']['fields_permissions']['customer_fields']['fields_mobile_1'])){ // if($_SESSION['user']['fields_permissions']['customer_fields']['fields_mobile_1']){ // $mask_mobile = $row['mobile_phone_1']; // } // } // $mask_landline = $utility->isNotEmpty($row['landline']) ? $utility->mask($row['landline'],2,1) : ''; // if(isset($_SESSION['user']['fields_permissions']['customer_fields']['fields_landline'])){ // if($_SESSION['user']['fields_permissions']['customer_fields']['fields_landline']){ // $mask_landline = $row['landline']; // } // } // // $utility->make_thumb('../../dist/img/customer/'.$row['photo'], '../../dist/img/thumbnail/'.$row['photo'], 150); // $grid_customer_master_id = $row['id']; // $grid_date_created = $row['date_created']; // $grid_name = $row['name']; // $grid_type =(intval($row['type']) === 1) ? 'Individual' : 'Corporation'; // $grid_photo = $row['photo']; // $grid_age_number = $row['age_number']; // $grid_email_1 = $mask_email; // $grid_mobile_phone_1 = intval($row['type']) === 2 ? ($utility->isNotEmpty($mask_landline) ? $mask_landline : $mask_mobile ) : $mask_mobile; // $json_arr['customer_list'] = $json_arr['customer_list']."<div class='col-md-4 d-flex align-items-stretch'><div class='card bg-light' style='width:100%'>"./$grid_date_created./"<div class='card-body mt-2 pt-0' style='padding: 1.00rem'><div class='row'><div class='col-8'><h2 class='lead mb-1'> <p class=' text-md mb-1'><b>$grid_name</b> </p> </h2><p class='text-muted text-sm mb-1'><b>Type: </b> ".$grid_type." </p> <!-- <p class='text-muted text-sm mb-1'><b>Age: </b> ".$grid_age_number." </p> --> <ul class='ml-4 mb-0 fa-ul text-muted'><li class='small'><span class='fa-li'><i class='fas fa-envelope'></i></span> Email: <a href='mailto:".$grid_email_1."' >".$grid_email_1."</a></li><li class='small'><span class='fa-li'><i class='fas fa-lg fa-phone'></i></span> Mobile: <a href='tel:".$grid_mobile_phone_1."' >".$grid_mobile_phone_1."</a></li></ul></div><div class='col-4 text-center'><img src='dist/img/customer/".$grid_photo."' alt='logo' class='img-circle img-fluid img' style='width:90px; height:90px;'> </div></div></div><div class='card-footer' style='padding: .25rem;' ><div class='text-right'><a onclick='customerInfo(\"".$grid_customer_master_id."\",\"".$grid_type."\")' class='btn btn-sm btn-primary'><i class='fas fa-info'></i> View </a></div></div></div></div>"; // $data_counter++; // } }else{ $users_dealer=''; while($row = $exec_query->fetch_assoc()) { // $dealer_user_query = $db->sql_query("select e.id,e.employee_id,CONCAT(e.first_name,' ',e.last_name) as employee_name,e.company_dealer_id, // scd.id AS sc_id,scd.company_id,scd.dealer_id // from employee e left join source_company_dealer scd on e.company_dealer_id = scd.id // where scd.dealer_id = '".$row['dealer_id']."' and e.status =1 AND e.company_dealer_id > 0 ORDER by scd.company_id"); // if($dealer_user_query->num_rows>0){ // while($user_row = $dealer_user_query->fetch_assoc()){ // $selected =($user_row['employee_id']>0 && $user_row['employee_id']== $row['user_id'] ? 'selected' : ''); // // $users_dealer[] =array_push($user_row, $users_dealer); // $users_dealer .= "<option value=".$user_row['employee_id']." ".$selected.">".$user_row['employee_name']."</option>"; // // echo'<pre>';print_r($users_dealer);echo'</pre>'; // } // } // return; // echo'<pre>';print_r($users_dealer);echo'</pre>'; // print_r($dealer_user_query);exit; // $get_image_query = "SELECT vi.name FROM vehicle v // INNER JOIN vehicle_images vi // ON v.id = vi.vehicle_id // INNER JOIN source_company_dealer scd // ON v.company_dealer_id = scd.id // WHERE 1 // AND v.customer_record_id ='".$row['id']."' // AND scd.company_id IN (".$granted_company_ids.") // AND vi.name <> 'default.png' // AND vi.status <> 0 // ORDER BY v.id DESC LIMIT 1"; // // echo $get_image_query; // $get_image_name= $db -> select($get_image_query); // if($get_image_name <> ''){ // $row['photo'] = $get_image_name; // } // $mask_email = $utility->isNotEmpty($row['email_1']) ? $utility->mask_email($row['email_1']) : ''; // if(isset($_SESSION['user']['fields_permissions']['customer_fields']['fields_email_1'])){ // if($_SESSION['user']['fields_permissions']['customer_fields']['fields_email_1']){ // $mask_email = $row['email_1']; // } // } // $mask_mobile = $utility->isNotEmpty($row['mobile_phone_1']) ? $utility->mask($row['mobile_phone_1'],4,1) : ''; // if(isset($_SESSION['user']['fields_permissions']['customer_fields']['fields_mobile_1'])){ // if($_SESSION['user']['fields_permissions']['customer_fields']['fields_mobile_1']){ // $mask_mobile = $row['mobile_phone_1']; // } // } // $mask_landline = $utility->isNotEmpty($row['landline']) ? $utility->mask($row['landline'],2,1) : ''; // if(isset($_SESSION['user']['fields_permissions']['customer_fields']['fields_landline'])){ // if($_SESSION['user']['fields_permissions']['customer_fields']['fields_landline']){ // $mask_landline = $row['landline']; // } // } // $utility->make_thumb('../../dist/img/customer/'.$row['photo'], '../../dist/img/thumbnail/'.$row['photo'], 150); $param =[ 'dealer_id' => $row['dealer_id'], 'user_id' => $row['user_id'], 'ref_num_header' => $row['ref_num_header'], 'dealer_ref_header' => $row['dealer_ref_header'], 'dealer_batch_no' => $row['dealer_batch_no'] ]; // echo'<pre>';print_r($param);echo'</pre>';exit; $encoded_data = $utility->str_encrypt($param); // $decoded_data = $utility->str_decrypt($encoded_data); $json_arr['rows'] = array_merge( $json_arr['rows'], array( array( 'user_id' => $row['user_id'], 'users' => $users_dealer, 'dealer_ref_code'=> '<span class="badge " style="background-color:#f9ce69;">'.$row['ref_num_header'].'-'.$row['dealer_ref_header'].'-'.$row['dealer_batch_no'].'</span>', 'emp_name' => $row['employee'], 'noofupdated'=>$row['total_icu_updated'], 'date_assigned'=> $row['date_assigned'].'<br><small style="font-style:Italic;">Assigned by : <b>'.$row['assigned_by'].'</b></small>', // 'iview' => '<a href="customer-update-assigned?q='.$encoded_data.'"title="View" class="btn btn-sm btn-default" style="background-color:#9bbbfc;">View <i class="fa fa-eye"></i></a> // ', 'iview' => '<a href="user-cu-assigned?q='.$encoded_data.'" title="View" class="btn btn-sm btn-default" style="background-color:#9bbbfc;">View <i class="fa fa-eye"></i></a> ', 'total_cu_assign' => $row['nos'] ) ) ); unset($row); $users_dealer =''; $data_counter++; } unset($user_row); unset($row); } if($data_counter > 0 ){ $json_arr['total'] = ($data_counter < $limit) ? $data_counter : $query_count;//100; //total number of result }else{ $json_arr['total'] = 0; } echo json_encode($json_arr); function isNotEmpty($data){ return preg_match('/\S/', $data); } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings