lightspeeddevelopment / wetu-importer

	/**

	 * Grab all the current tour posts via the lsx_wetu_id field.

	 */

	public function find_current_tours() {

		global $wpdb;

		$return = array();

		$current_tours = $wpdb->get_results("

					SELECT key1.post_id,key1.meta_value

					FROM {$wpdb->postmeta} key1

					INNER JOIN  {$wpdb->posts} key2 

    				ON key1.post_id = key2.ID

					WHERE key1.meta_key = 'lsx_wetu_id'

					AND key2.post_type = 'tour'

					LIMIT 0,500

		");

		if(null !== $current_tours && !empty($current_tours)){

			foreach($current_tours as $tour){

				$return[$tour->meta_value] = $tour;

			}

		}

		return $return;

	}	

	/**

	 * Grab all the current accommodation posts via the lsx_wetu_id field.

	 */

	public function find_current_accommodation($post_type='accommodation') {

		global $wpdb;

		$return = array();

		$current_accommodation = $wpdb->get_results("

					SELECT key1.post_id,key1.meta_value

					FROM {$wpdb->postmeta} key1

					INNER JOIN  {$wpdb->posts} key2 

    				ON key1.post_id = key2.ID

					WHERE key1.meta_key = 'lsx_wetu_id'

					AND key2.post_type = '{$post_type}'

					LIMIT 0,500

		");

		if(null !== $current_accommodation && !empty($current_accommodation)){

			foreach($current_accommodation as $accom){

				$return[$accom->meta_value] = $accom;

			}

		}

		return $return;

	}	

	/**

	 * Grab all the current destination posts via the lsx_wetu_id field.

	 */

	public function find_current_destination($post_type='destination') {

		global $wpdb;

		$return = array();

		$current_destination = $wpdb->get_results("

					SELECT key1.post_id,key1.meta_value,key2.post_title as name,key2.post_date as last_modified

					FROM {$wpdb->postmeta} key1

					INNER JOIN  {$wpdb->posts} key2 

    				ON key1.post_id = key2.ID

					WHERE key1.meta_key = 'lsx_wetu_id'

					AND key2.post_type = '{$post_type}'

					LIMIT 0,500

		");

		if(null !== $current_destination && !empty($current_destination)){

			foreach($current_destination as $accom){

				$return[$accom->meta_value] = $accom;

			}

		}

		return $return;

	}