Popular post view widget, sort by + where clause

Hi anders,

Please provide us site admin & FTP credentials.
I have to look into current functionally. If it is possible, i will provide you snippet to achieve that.

Kiran

Hi anders,

The widget filtering is used by many GD widgets. So i am not able to provide snippet without checking your custom code & fields.

Kiran

Hi There,

You forgot to provide FTP host.

Use following code snippet and let us know how it goes.

function _gd_custom_widget_listings_where_date( $where ) {
	global $plugin_prefix, $gd_query_args_widgets;

	$query_args = $gd_query_args_widgets;
	if ( empty( $query_args ) || empty( $query_args['is_geodir_loop'] ) ) {
		return $where;
	}
    
	$post_type = 'gd_vinresa'; // Change post type here
	$field = 'geodir_avresedatum'; // Change field name here

	if ( !empty( $query_args['post_type'] ) && $query_args['post_type'] == $post_type ) {
		$date_now = date( "Y-m-d" );
		$date_param = isset($_REQUEST['archive']) ? '<=' : '>=';
		$table = $plugin_prefix . $post_type . '_detail';
		$where .= " AND $table.$field $date_param '$date_now' ";
	}        

	return $where;
}
add_filter( 'geodir_filter_widget_listings_where', '_gd_custom_widget_listings_where_date', 10, 1 );

Kiran

Hi There,

I have updated snippet for sorting listing in widget.
Check and let us know.

Kiran

The functions.php under child theme directory was overwritten and it has lost my changes. I updated file on 14th Oct and it shows recently edited on 15th.

BTW i have added snippet again. Check and let us know.

Kiran