­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ admin->multilingual_support ) ) { $this->_multilingual = jet_smart_filters()->admin->multilingual_support; } else { require_once jet_smart_filters()->plugin_path( 'admin/includes/multilingual-support.php' ); $this->_multilingual = new Jet_Smart_Filters_Admin_Multilingual_Support(); } }, 9999 ); } public function get( $args ) { global $wpdb; $args = array_merge( array( 'status' => 'publish', 'page' => 1, 'per_page' => 20, 'orderby' => 'date', 'order' => 'DESC', 'search' => false, 'type' => false, 'source' => false, 'date' => false, 'language' => false ), $args ); // escapes data for use in a MySQL query foreach ( $args as $key => $value ) { $args[$key] = esc_sql( $value ); } $status = $args['status']; // Pagination $page = absint( $args['page'] ); $per_page = absint( $args['per_page'] ); $offset = $per_page * ( $page - 1 ); // Sort $order_by = $args['orderby']; $order = $args['order']; $allowed_orderby = [ 'title', 'date' ]; $allowed_order = [ 'asc', 'desc' ]; $order_by = in_array( $order_by, $allowed_orderby ) ? $order_by : 'title'; $order = in_array( $order, $allowed_order ) ? $order : 'asc'; // Search $searchSql = ''; $search = $args['search']; // escaped above if ( $search ) { $searchSql = "AND $wpdb->posts.post_title LIKE '%{$search}%'"; } // Filtration $filtrationSql = ''; $type = $args['type']; $source = $args['source']; $date = $args['date']; // escaped above if ( $type ) { $filtrationSql .= "AND postmeta_type.meta_value = '$type' "; } // escaped above if ( $source ) { $filtrationSql .= "AND postmeta_source.meta_value = '$source' "; } if ( $date ) { if ( $date['from'] ) { $date['from'] = esc_sql( $date['from'] ); $filtrationSql .= "AND $wpdb->posts.post_date >= '" . $date['from'] . " 00:00:00' "; } if ( $date['to'] ) { $date['to'] = esc_sql( $date['to'] ); $filtrationSql .= "AND $wpdb->posts.post_date <= '" . $date['to'] . " 23:59:59' "; } } // Multilingual $current_language = $args['language']; // Display all languages if ( $status === 'trash' || $current_language === 'all' ) { $current_language = false; } $ml_SQL_parts = $this->_multilingual->get_SQL_filters_parts( $current_language ); $ml_join = $ml_SQL_parts['join']; $ml_where = $ml_SQL_parts['where']; $sql_main = " SELECT $wpdb->posts.ID, $wpdb->posts.post_title as title, $wpdb->posts.post_date as date, postmeta_type.meta_value as type, postmeta_source.meta_value as source FROM $wpdb->posts LEFT JOIN $wpdb->postmeta as postmeta_type ON ($wpdb->posts.ID = postmeta_type.post_ID AND postmeta_type.meta_key = '_filter_type') LEFT JOIN $wpdb->postmeta as postmeta_source ON ($wpdb->posts.ID = postmeta_source.post_ID AND postmeta_source.meta_key = '_data_source') $ml_join WHERE $wpdb->posts.post_type = 'jet-smart-filters' AND $wpdb->posts.post_status = '$status' $searchSql $filtrationSql $ml_where ORDER BY $order_by $order LIMIT $offset, $per_page"; $filters_result = $wpdb->get_results( $sql_main, ARRAY_A ); $sql_count = " SELECT COUNT(*) as count FROM $wpdb->posts LEFT JOIN $wpdb->postmeta as postmeta_type ON ($wpdb->posts.ID = postmeta_type.post_ID AND postmeta_type.meta_key = '_filter_type') LEFT JOIN $wpdb->postmeta as postmeta_source ON ($wpdb->posts.ID = postmeta_source.post_ID AND postmeta_source.meta_key = '_data_source') $ml_join WHERE $wpdb->posts.post_type = 'jet-smart-filters' AND $wpdb->posts.post_status = '$status' $searchSql $filtrationSql $ml_where"; $count_result = $wpdb->get_results( $sql_count, ARRAY_A ); $sql_total_count = " SELECT COUNT(*) as count FROM $wpdb->posts WHERE $wpdb->posts.post_type = 'jet-smart-filters' AND $wpdb->posts.post_status = 'publish'"; $total_count_result = $wpdb->get_results( $sql_total_count, ARRAY_A ); $sql_total_trash_count = " SELECT COUNT(*) as count FROM $wpdb->posts WHERE $wpdb->posts.post_type = 'jet-smart-filters' AND $wpdb->posts.post_status = 'trash'"; $total_trash_count_result = $wpdb->get_results( $sql_total_trash_count, ARRAY_A ); $quantity = array( 'filters' => $total_count_result[0]['count'], 'trash' => $total_trash_count_result[0]['count'], ); $output = array( 'filters' => $filters_result, 'count' => $count_result[0]['count'], 'quantity' => $quantity ); if ( $this->_multilingual->is_Enabled ) { // add translations quantity to response $output['multilingual_quantity'] = $this->_multilingual->get_translations_count(); $output['multilingual_quantity']['all'] = $quantity['filters']; // add translations data to filters list $this->_multilingual->add_data_to_list( $output['filters'] ); } return $output; } public function restore( $ids ) { global $wpdb; if ( $ids !== 'all' && ! is_array( $ids ) ) { $ids = array( $ids ); } $sql = " UPDATE $wpdb->posts SET post_status = 'publish' WHERE $wpdb->posts.post_type = 'jet-smart-filters' AND $wpdb->posts.post_status = 'trash'"; if ( $ids !== 'all' ) { $sql .= " AND $wpdb->posts.ID IN ('" . implode( "','", $ids ) . "')"; } $result = $wpdb->query( $sql ); return $result; } public function move_to_trash( $ids ) { global $wpdb; if ( ! is_array( $ids ) ) { $ids = array( $ids ); } $sql = " UPDATE $wpdb->posts SET post_status = 'trash' WHERE $wpdb->posts.post_type = 'jet-smart-filters' AND $wpdb->posts.post_status = 'publish' AND $wpdb->posts.ID IN ('" . implode( "','", $ids ) . "')"; $result = $wpdb->query( $sql ); return $result; } public function delete( $ids ) { global $wpdb; if ( $ids !== 'all' && ! is_array( $ids ) ) { $ids = array( $ids ); } if ( $ids === 'all' ) { $sql = " SELECT $wpdb->posts.ID FROM $wpdb->posts WHERE $wpdb->posts.post_type = 'jet-smart-filters' AND $wpdb->posts.post_status = 'trash' GROUP BY $wpdb->posts.ID"; $result = $wpdb->get_results( $sql, ARRAY_A ); $ids = array_map( function($row) { return $row['ID']; }, $result ); } foreach ( $ids as $id ) { wp_delete_post( $id, true ); } } }