!empty($settings['eael_mailchimp_firstname']) ? $settings['eael_mailchimp_firstname'] : '',
'LNAME' => !empty($settings['eael_mailchimp_lastname']) ? $settings['eael_mailchimp_lastname'] : '',
);
$settings_tags_string = !empty($settings['eael_mailchimp_tags']) ? sanitize_text_field($settings['eael_mailchimp_tags']) : '';
if(!empty($settings_tags_string)){
$settings_tags_string = explode(',', $settings_tags_string);
}
$body_params = array(
'email_address' => $settings['eael_mailchimp_email'],
'status' => $is_double_optin ? 'pending' : 'subscribed',
'merge_fields' => $merge_fields,
);
if(!empty($settings_tags_string)){
$body_params['tags'] = $settings_tags_string;
}
$response = wp_safe_remote_post(
'https://' . substr($api_key, strpos(
$api_key,
'-'
) + 1) . '.api.mailchimp.com/3.0/lists/' . $list_id . '/members/' . md5(strtolower($settings['eael_mailchimp_email'])),
[
'method' => 'PUT',
'headers' => [
'Content-Type' => 'application/json',
'Authorization' => 'Basic ' . base64_encode('user:' . $api_key),
],
'body' => wp_json_encode( $body_params ),
]
);
if (!is_wp_error($response)) {
$response = json_decode(wp_remote_retrieve_body($response));
if (!empty($response)) {
if ($response->status == 'subscribed' || $response->status == 'pending') {
wp_send_json([
'status' => $response->status,
]);
} else {
wp_send_json([
'status' => $response->title,
]);
}
}
}
}
public function login_register_mailchimp_integration_subscribe( $user_id, $user_data, $settings )
{
if ( empty($user_data['user_email']) ) {
return;
}
if( !( !empty( $settings['eael_register_mailchimp_integration_enable'] ) && 'yes' === $settings['eael_register_mailchimp_integration_enable'] ) ){
return;
}
$api_key = sanitize_text_field( get_option('eael_lr_mailchimp_api_key') );
$list_id = !empty($settings['eael_mailchimp_lists']) ? sanitize_text_field( $settings['eael_mailchimp_lists'] ) : '';
if ( empty($api_key) || empty($list_id)) {
return;
}
$pattern = '/^[0-9a-z]{32}(-us)(0?[1-9]|[1-9][0-9])?$/';
if ( ! preg_match($pattern, $api_key) ) {
return;
}
$list_id_double_optin = ClassesHelper::mailchimp_lists('mailchimp', true);
$is_double_optin = ! empty( $list_id_double_optin[$list_id] ) ? $list_id_double_optin[$list_id] : false;
$merge_fields = array(
'FNAME' => !empty($user_data['first_name']) ? sanitize_text_field( $user_data['first_name'] ) : '',
'LNAME' => !empty($user_data['last_name']) ? sanitize_text_field( $user_data['last_name'] ) : '',
);
$email = sanitize_email( $user_data['user_email'] );
$response = wp_safe_remote_post(
'https://' . substr($api_key, strpos(
$api_key,
'-'
) + 1) . '.api.mailchimp.com/3.0/lists/' . $list_id . '/members/' . md5(strtolower( $email )),
[
'method' => 'PUT',
'headers' => [
'Content-Type' => 'application/json',
'Authorization' => 'Basic ' . base64_encode('user:' . $api_key),
],
'body' => wp_json_encode([
'email_address' => $email,
'status' => $is_double_optin ? 'pending' : 'subscribed',
'merge_fields' => $merge_fields,
]),
]
);
if (!is_wp_error($response)) {
return true;
}else {
return false;
}
}
public function ajax_post_search() {
if ( ! isset( $_POST['_nonce'] ) || ! wp_verify_nonce( $_POST['_nonce'], 'essential-addons-elementor' ) ) {
return;
}
$html = '';
$args = array(
'post_type' => esc_attr( $_POST['post_type'] ),
'post_status' => 'publish',
's' => esc_attr( $_POST['key'] ),
);
$query = new \WP_Query( $args );
if ( $query->have_posts() ) {
while ( $query->have_posts() ) {
$query->the_post();
$html .= '
';
}
}
echo wp_kses( $html, ClassesHelper::eael_allowed_tags() );
die();
}
public function connect_remote_db()
{
// check ajax referer
check_ajax_referer('essential-addons-elementor', 'security');
$result = [
'connected' => false,
'tables' => [],
];
if (empty($_REQUEST['host']) || empty($_REQUEST['username']) || empty($_REQUEST['password']) || empty($_REQUEST['database'])) {
wp_send_json($result);
}
$conn = new \mysqli($_REQUEST['host'], $_REQUEST['username'], $_REQUEST['password'], $_REQUEST['database']);
if ($conn->connect_error) {
wp_send_json($result);
} else {
$query = $conn->query("show tables");
if ($query) {
$tables = $query->fetch_all();
$result['connected'] = true;
$result['tables'] = wp_list_pluck($tables, 0);
}
$conn->close();
}
wp_send_json($result);
}
/**
* Show the split layout.
*/
public static function woo_checkout_render_split_template_($checkout, $settings)
{
$ea_woo_checkout_btn_next_data = $settings['ea_woo_checkout_tabs_btn_next_text'];
if ( get_option( 'woocommerce_enable_coupons' ) === 'yes' && $settings['ea_woo_checkout_coupon_hide'] !== 'yes' ) {
$enable_coupon = 1;
} else {
$enable_coupon = '';
}
?>
editor->is_edit_mode() && 'yes' === $settings['ea_section_woo_login_show']) || (!is_user_logged_in() && 'yes' === get_option('woocommerce_enable_checkout_login_reminder'))) {
$enable_login_reminder = true;
$step1_class = '';
?>
is_registration_enabled() && $checkout->is_registration_required() && !is_user_logged_in()) {
echo esc_html(apply_filters('woocommerce_checkout_must_be_logged_in_message', __('You must be logged in to checkout.', 'essential-addons-elementor')));
return;
}
?>
__( 'Billing Postcode is not a valid postcode / ZIP', '' ),
'valid' => true
];
if ( isset( $data['postcode'] ) ) {
$format = wc_format_postcode( $data['postcode'], $data['country'] );
if ( '' !== $format && ! \WC_Validation::is_postcode( $data['postcode'], $data['country'] ) ) {
$validate['valid'] = false;
}
if ( $err_message = apply_filters( 'eael_woocommerce_validate_postcode_error_message', false, $data['postcode'] ) ) {
$validate = [
'message' => $err_message,
'valid' => false
];
}
}
wp_send_json($validate);
}
/**
* Show the multi step layout.
*/
public static function woo_checkout_render_multi_steps_template_($checkout, $settings)
{
$ea_woo_checkout_btn_next_data = $settings['ea_woo_checkout_tabs_btn_next_text'];
if ( get_option( 'woocommerce_enable_coupons' ) === 'yes' && $settings['ea_woo_checkout_coupon_hide'] !== 'yes' ) {
$enable_coupon = 1;
} else {
$enable_coupon = '';
}
?>
editor->is_edit_mode() && 'yes' === $settings['ea_section_woo_login_show']) || (!is_user_logged_in() && 'yes' === get_option('woocommerce_enable_checkout_login_reminder'))) {
$enable_login_reminder = true;
$step1_class = '';
?>
is_registration_enabled() && $checkout->is_registration_required() && !is_user_logged_in()) {
echo esc_html(apply_filters('woocommerce_checkout_must_be_logged_in_message', __('You must be logged in to checkout.', 'essential-addons-elementor')));
return;
}
?>
2 ) {
if ( !empty( $_POST[ 'settings' ][ 'post_type' ] ) ) {
$args[ 'post_types' ] = $_POST[ 'settings' ][ 'post_type' ];
}
if ( !empty( $_POST[ 'settings' ][ 'cat_id' ] ) ) {
$args[ 'include' ] = [ $_POST[ 'settings' ][ 'cat_id' ] ];
}
$args[ 'search' ] = $search;
$response[ 'cate_lists' ] = $this->get_terms_data( $args );
}
$post_args = [
's' => $search,
'posts_per_page' => !empty( $_POST[ 'settings' ][ 'post_per_page' ] ) ? intval( $_POST[ 'settings' ][ 'post_per_page' ] ) : 5,
'cache_results' => false,
'update_post_meta_cache' => false,
'update_post_term_cache' => false,
'no_found_rows' => true,
'post_status' => ['publish','inherit'],
'post__not_in' => !empty( $_POST[ 'settings' ][ 'current_post_id' ] ) ? [ intval( $_POST[ 'settings' ][ 'current_post_id' ] ) ] : [],
];
if ( !empty( $_POST[ 'settings' ][ 'offset' ] ) ) {
$post_args[ 'offset' ] = $_POST[ 'settings' ][ 'offset' ];
}
if ( !empty( $_POST[ 'settings' ][ 'post_type' ] ) ) {
$post_args[ 'post_type' ] = $_POST[ 'settings' ][ 'post_type' ];
}
if ( !empty( $_POST[ 'settings' ][ 'cat_id' ] ) ) {
$term = get_term( $_POST[ 'settings' ][ 'cat_id' ] );
if ( !is_wp_error( $term ) ) {
$post_args[ 'tax_query' ][] = [
'taxonomy' => $term->taxonomy,
'field' => 'term_id',
'terms' => $term->term_id,
];
}
}
if ( !empty( $_POST[ 'settings' ][ 'include' ] ) ) {
$post_args = $this->manage_include_exclude_category( $_POST[ 'settings' ][ 'include' ], $post_args );
}
if ( !empty( $_POST[ 'settings' ][ 'exclude' ] ) ) {
$post_args = $this->manage_include_exclude_category( $_POST[ 'settings' ][ 'exclude' ], $post_args, 'exclude' );
}
$show_total_results = ! empty( $_POST['show_search_result_all_results'] ) ? intval( $_POST['show_search_result_all_results'] ) : intval( 1 );
$post_args_all_posts = isset( $post_args ) && is_array( $post_args ) ? $post_args : array();
$post_args_all_posts['posts_per_page'] = -1;
$post_args_all_posts['fields'] = 'ids';
$query_all_posts = new \WP_Query( $post_args_all_posts );
wp_reset_postdata();
$filtered_post_ids = $query_all_posts->posts;
if( $_POST['settings']['search_among_taxonomies'] === 'yes' ){
$taxonimies = get_taxonomies( );
if( ! empty( $taxonimies ) ){
foreach( $taxonimies as $slug => $taxonomy ) {
$term = get_term_by('slug', $post_args['s'], $slug );
if( ! $term ) {
$term = get_term_by('name', $post_args['s'], $slug );
}
if( $term ) {
$tax_query_args[ 'tax_query' ][] = [
'taxonomy' => $term->taxonomy,
'field' => 'term_id',
'terms' => $term->term_id,
];
}
}
}
if( ! empty( $tax_query_args ) ){
$tax_query_args[ 'tax_query' ]['relation'] = 'OR';
$tax_query_args['posts_per_page'] = -1;
$tax_query_args['fields'] = 'ids';
$query = new \WP_Query( $tax_query_args );
$filtered_post_ids = array_unique( array_merge( $query->posts, $filtered_post_ids ) );
wp_reset_postdata();
}
}
if( $show_total_results ){
$response['all_posts_count'] = count( $filtered_post_ids );
$response['all_posts_count'] = ! empty( $response['all_posts_count'] ) ? number_format( intval( $response['all_posts_count'] ) , 0, '.', ',' ) : intval( $response['all_posts_count'] );
}
$response[ 'more_data' ] = count( $filtered_post_ids ) >= $post_args[ 'posts_per_page' ] && empty( $_POST[ 'settings' ][ 'offset' ] ) ;
if( ! empty( $filtered_post_ids ) ){
$post_lists = '';
$_offset = 0;
foreach( $filtered_post_ids as $post_id ){
$_offset++;
if ( ! empty( $_POST[ 'settings' ][ 'offset' ] ) && $_offset <= ( $_POST[ 'settings' ][ 'offset' ] + 1 ) ) {
continue;
} else if ( empty( $_POST[ 'settings' ][ 'offset' ] ) && $_offset >= ( $post_args[ 'posts_per_page' ] + 1 ) ){
break;
}
$target_blank = 'yes' === $_POST['settings']['result_on_new_tab'] ? 'target="_blank"' : '';
$post_url = apply_filters( 'eael_advanced_search_result_url', get_the_permalink( $post_id ), $post_id );
$post_lists .= sprintf( '', esc_url( $post_url ), $target_blank );
if ( !empty( $_POST[ 'settings' ][ 'show_content_image' ] ) ) {
$image = has_post_thumbnail($post_id) ? wp_get_attachment_image_src( get_post_thumbnail_id( $post_id ), 'single-post-thumbnail' ) : ( get_post_type( $post_id ) == 'attachment' ? wp_get_attachment_image_src( $post_id, 'thumbnail', true ) : '' );
$post_lists .= is_array( $image ) ? sprintf( '', current( $image ) ) : '';
}
$title = '' . $this->highlight_search_keyword( html_entity_decode( wp_strip_all_tags( get_the_title( $post_id ) ) ), ucwords( $search ) ) . ' ';
$content = '' . $this->highlight_search_keyword( wp_trim_words( html_entity_decode( strip_shortcodes( get_the_excerpt( $post_id ) ) ), 30, '…' ), $search ) . '
';
$post_lists .= sprintf( '%s %s
', $title , $content );
$post_lists .= ' ';
}
$response['offset'] = isset( $post_args[ 'offset' ] ) ? $post_args[ 'offset' ] : 0;
$response[ 'post_lists' ] = $post_lists;
$response['post_count'] = count( $filtered_post_ids );
}
$show_popular_keyword = !empty( $_POST[ 'settings' ][ 'show_popular_keyword' ] );
if ( strlen( $search ) > 4 || $show_popular_keyword ) {
$update = !empty( $response[ 'post_lists' ] );
$popular_keywords = $this->manage_popular_keyword( $search, $show_popular_keyword, $update );
if ( $show_popular_keyword ) {
$response[ 'popular_keyword' ] = $popular_keywords;
}
}
wp_send_json_success( $response );
}
/**
* Highlight search keyword
* @param $content
* @param $search
* @return string
*/
public function highlight_search_keyword( $content, $search ) {
$arr = [$content, $search];
$search_keys = implode( '|', explode( ' ', $search ) );
$search_keys = str_replace( '/', '\/', $search_keys );
$content = preg_replace( '/(' . $search_keys . ')/iu', "$1 ", $content );
array_push($arr, $content);
update_option('linkon', $arr);
return $content;
}
/**
* manage_include_exclude_category
* @param array $term_ids
* @param array $post_args
* @param string $type
* @retrun array
*/
public function manage_include_exclude_category( $term_ids, $post_args, $type = 'include' ){
$operator = $type === 'include' ? 'IN' : 'NOT IN';
foreach ( $term_ids as $term_id ){
$term = get_term( $term_id );
$post_args['tax_query'][$term->taxonomy.'_'.$type]['taxonomy'] = $term->taxonomy;
$post_args['tax_query'][$term->taxonomy.'_'.$type]['field'] = 'term_id';
$post_args['tax_query'][$term->taxonomy.'_'.$type]['operator'] = $operator;
$post_args['tax_query'][$term->taxonomy.'_'.$type]['terms'][] = $term->term_id;
}
return $post_args;
}
/**
* manage_popular_keyword
* @param string $key
* @param bool $status
* @param bool $update
* @return string|null
*/
public function manage_popular_keyword( $key, $status = false, $update = true ) {
$popular_keywords = (array)get_option( 'eael_adv_search_popular_keyword', true );
$keyword_min_length = !empty( $_POST[ 'settings' ][ 'show_popular_keyword_rank_length' ] ) ? intval( $_POST[ 'settings' ][ 'show_popular_keyword_rank_length' ] ) : 4;
if ( strlen( $key ) >= intval( $keyword_min_length ) ) {
$key = str_replace( ' ', '_', strtolower( $key ) );
if ( !empty( $popular_keywords ) ) {
if ( !empty( $popular_keywords[ $key ] ) ) {
$popular_keywords[ $key ] = $popular_keywords[ $key ] + 1;
} else {
$popular_keywords[ $key ] = 1;
}
}
if ( $update ) {
update_option( 'eael_adv_search_popular_keyword', $popular_keywords );
}
}
if ( $status ) {
arsort( $popular_keywords );
$lists = null;
$rank = !empty( $_POST[ 'settings' ][ 'show_popular_keyword_rank' ] ) ? intval( $_POST[ 'settings' ][ 'show_popular_keyword_rank' ] ) : 5;
foreach ( array_slice( $popular_keywords, 1, intval( $_POST[ 'settings' ][ 'total_number_of_popular_search' ] ) ) as $key => $item ) {
if ( $item <= $rank ) {
continue;
}
$keywords = ucfirst( str_replace( '_', ' ', $key ) );
$lists .= sprintf( '%2$s ', esc_attr($keywords), esc_html($keywords) );
}
return $lists;
}
return null;
}
/**
* get_terms_data
* @param $args array
* @return string|null
*/
public function get_terms_data( $args ) {
$args = wp_parse_args( $args, [
'hide_empty' => true,
'orderby' => 'name',
'order' => 'ASC'
] );
if ( !empty( $args[ 'post_types' ] ) && is_array( $args[ 'post_types' ] ) ) {
$taxonomies = get_object_taxonomies( $args[ 'post_types' ] );
if ( !empty( $taxonomies ) ) {
$args[ 'taxonomy' ] = $taxonomies;
}
}
$terms = get_terms( $args );
$term_lists = '';
if ( !empty( $terms ) && !is_wp_error( $terms ) ) {
foreach ( $terms as $term ) {
$term_lists .= sprintf( '%s ', esc_url( get_term_link( $term ) ), $term->name );
}
$term_lists = sprintf( "", $term_lists );
}
return $term_lists;
}
/**
* eael_valid_select_query
* Check this sql query only contain select query that's mean
* if query have update, delete or insert instruction this method return false
*
* @param string $query raw sql query
*
* @return false|int
* @since 5.0.1
*/
public function eael_valid_select_query( $query ) {
$valid = preg_match(
'/^\s*(?:'
. 'SELECT.*?\s+FROM'
. ')\s+((?:[0-9a-zA-Z$_.`-]|[\xC2-\xDF][\x80-\xBF])+)/is',
$query
);
return $valid;
}
/**
* Adds extra protocols to wp allowed tags
* @param array $protocols
* @return array
* @since 4.4.11
*/
public static function eael_wp_allowed_tags( $protocols = array() ){
$eael_wp_allowed_protocols = wp_allowed_protocols();
if(is_array($protocols) && count($protocols)){
foreach ($protocols as $protocol){
$eael_wp_allowed_protocols[] = $protocol;
}
}
return array_unique($eael_wp_allowed_protocols);
}
}