ELECT 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 ); } } }