add_filter('posts_join', 'easyparca_ajax_search_join', 20, 2);
add_filter('posts_where', 'easyparca_ajax_search_where', 20, 2);
add_filter('posts_distinct', 'easyparca_ajax_search_distinct', 20);
function easyparca_ajax_search_join($join, $query) {
global $wpdb;
if (
!is_admin() &&
$query->is_search() &&
isset($_REQUEST['action']) &&
strpos($_REQUEST['action'], 'ecomall') !== false
) {
$join .= " LEFT JOIN {$wpdb->postmeta} epm ON {$wpdb->posts}.ID = epm.post_id ";
}
return $join;
}
function easyparca_ajax_search_where($where, $query) {
global $wpdb;
if (
!is_admin() &&
$query->is_search() &&
isset($_REQUEST['action']) &&
strpos($_REQUEST['action'], 'ecomall') !== false
) {
$search = $query->get('s');
if ($search) {
$like = '%' . $wpdb->esc_like($search) . '%';
$where .= $wpdb->prepare(
" OR (epm.meta_value LIKE %s)",
$like
);
}
}
return $where;
}
function easyparca_ajax_search_distinct($distinct) {
if (
isset($_REQUEST['action']) &&
strpos($_REQUEST['action'], 'ecomall') !== false
) {
return "DISTINCT";
}
return $distinct;
}
Shop – EasyParça
Ürün sepetinize eklendi
