example for iconic_wds_get_reservations_query

ids_hook.php

	add_filter( 'iconic_wds_get_reservations_query', array( __CLASS__, 'filter_deliveries_per_warehouse' ) );

  	/**
	 * Filter deliveries per warehouse
	 *
	 * @param string $q WordPress SQL query statement.
	 * @return mixed
	 */
	public static function filter_deliveries_per_warehouse( $q ) {
		if ( is_user_logged_in() ) {
			$user  = wp_get_current_user();
			$roles = (array) $user->roles;
			if ( in_array( 'courier', $roles, true ) ) {
				global $wpdb;
				$warehouse_id = Vmm_Helpers::get_user_connected_warehouse_id( $user );
				$needle       = 'FROM ' . $wpdb->prefix . 'jckwds';
				$join         = $needle . ' JOIN ' . $wpdb->prefix . 'vmm_order_to_warehouse ON ' . $wpdb->prefix . 'vmm_order_to_warehouse.order_id = ' . $wpdb->prefix . 'jckwds.order_id AND ' . $wpdb->prefix . 'vmm_order_to_warehouse .warehouse_id = ' . $warehouse_id;
				$q            = str_replace( $needle, $join, $q );
			}
		}

		return $q;
	}