Function Reference: geodir_imex_get_filter_where

Summary

Get the SQL where clause part to filter posts in import/export.

Global Values

$wpdb
(object) (required) WordPress Database object.

Default: None

Package

GeoDirectory

Parameters

$where
(string) (required) The SQL where clause part.

Default: empty
$post_type
(string) (required) The post type.

Default: None

Return Values

(string)
  • SQL where clause part.

Change Log

Since: 1.6.4

Source File

geodir_imex_get_filter_where() is located in geodirectory-admin/admin_functions.php [Line: 6327]

Source Code

function geodir_imex_get_filter_where($where = '', $post_type = '') {
    global $wpdb;
    
    $filters = !empty( $_REQUEST['gd_imex'] ) && is_array( $_REQUEST['gd_imex'] ) ? $_REQUEST['gd_imex'] : NULL;
    
    if ( !empty( $filters ) ) {
        foreach ( $filters as $field => $value ) {
            switch ($field) {
                case 'start_date':
                    $where .= " AND `" . $wpdb->posts . "`.`post_date` >= '" . sanitize_text_field( $value ) . " 00:00:00'";
                break;
                case 'end_date':
                    $where .= " AND `" . $wpdb->posts . "`.`post_date` <= '" . sanitize_text_field( $value ) . " 23:59:59'";
                break;
            }
        }
    }
    
    return $where;
}