ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / letacommog / entrepro / wp-content / plugins / geo-my-wp / includes / admin / pages / import-export / tabs

<?php
/**
 * GEO my WP V3 importers class.
 *
 * @package geo-my-wp
 */

if ( ! defined( 'ABSPATH' ) ) {
	exit; // Exit if accessed directly.
}

/**
 * Importer page.
 */
class GMW_V_3_Import_Page {

/**
	 * [__construct description]
	 */
	public function __construct() {

global $wpdb;

// look for post types table.
		$this->posts_table = $wpdb->get_results( "SHOW TABLES LIKE '{$wpdb->prefix}places_locator'", ARRAY_A ); // WPCS: db call ok, cache ok.

// look for users table.
		$this->users_table = $wpdb->get_results( "SHOW TABLES LIKE 'wppl_friends_locator'", ARRAY_A ); // WPCS: db call ok, cache ok.

// abort if tables do not exsit.
		if ( 0 === count( $this->posts_table ) && 0 === count( $this->users_table ) ) {
			return;
		}

// add importer tab.
		add_filter( 'gmw_import_export_tabs', array( $this, 'create_tab' ), 50 );

add_action( 'gmw_import_export_gmw_v_3_tab', array( $this, 'tab_content' ) );
	}

/**
	 * Create tab.
	 *
	 * @param  array $tabs tabs.
	 *
	 * @return [type]       [description]
	 */
	public function create_tab( $tabs ) {

$tabs['gmw_v_3'] = __( 'GEO my WP v3.0 Importer', 'geo-my-wp' );

return $tabs;
	}

/**
	 * Tab content.
	 */
	public function tab_content() {

do_action( 'gmw_v3_import_page_start' );

if ( 0 !== count( $this->posts_table ) ) : ?>

<div class="inside">
								<?php
								$pt_importer = new GMW_Posts_Locations_Importer_V3();
								$pt_importer->output();
								?>
							</div>
						</div>
					</div>
				</div>
			</div>

<?php endif; ?>

<?php if ( 0 !== count( $this->users_table ) ) : ?>

<div class="inside">
								<?php
									$users_importer = new GMW_Users_Locations_Importer_V3();
									$users_importer->output();
								?>
							</div>
						</div>
					</div>
				</div>
			</div>

<?php
		endif;

do_action( 'gmw_v3_import_page_end' );
	}
}
new GMW_V_3_Import_Page();

/**
 * Post types locations importer class
 *
 * @since 3.0
 */
class GMW_Posts_Locations_Importer_V3 extends GMW_Locations_Importer {

/**
	 * The object type we importing.
	 *
	 * @var string
	 */
	protected $object_type = 'post';

/**
	 * Records to import per batch.
	 *
	 * @var integer
	 */
	protected $records_per_batch = 50;

/**
	 * Message
	 *
	 * @var string
	 */
	public $form_message = 'Import existing posts locations into GEO my WP v3.0 database table.';

/**
	 * Location meta fields.
	 *
	 * @var array
	 */
	protected $location_meta_fields = array(
		'phone'   => 'phone',
		'fax'     => 'fax',
		'email'   => 'email',
		'website' => 'website',
	);

/**
	 * Import location metas.
	 *
	 * @param  [type] $location_id location ID.
	 * @param  [type] $location    location object.
	 */
	protected function import_locationmeta( $location_id, $location ) {

parent::import_locationmeta( $location_id, $location );

$days_hours = get_post_meta( $location->object_id, '_wppl_days_hours', true );

if ( ! empty( $days_hours ) ) {
			gmw_update_location_meta( $location_id, 'days_hours', $days_hours );
		}
	}

/**
	 * Query locations.
	 *
	 * @return [type] [description]
	 */
	public function query_locations() {

global $wpdb;

// check for post types table.
		$gmw_pt_table = $wpdb->prefix . 'places_locator';

// count rows only when init the importer.
		$count_rows = 0 === $this->total_locations ? 'SQL_CALC_FOUND_ROWS' : '';

// get records from database.
		$data = $wpdb->get_results(
			"
			SELECT {$count_rows} 
			gmwLocations.post_id as object_id,
			wpposts.post_author as user_id,
			'1' as status,
			gmwLocations.feature as featured, 
			wpposts.post_title as title, 
			gmwLocations.lat as latitude,
			gmwLocations.long as longitude,
			gmwLocations.street_number,
			gmwLocations.street_name,
			gmwLocations.street,
			gmwLocations.apt as permise,
			gmwLocations.city,
			gmwLocations.state_long as region_name,
			gmwLocations.state as region_code,
			gmwLocations.zipcode as	postcode,
			gmwLocations.country_long as country_name,
			gmwLocations.country as country_code,
			gmwLocations.address,
			gmwLocations.formatted_address,
			gmwLocations.phone,
			gmwLocations.fax,
			gmwLocations.email,
			gmwLocations.website,
			gmwLocations.map_icon,
			wpposts.post_date as created, 
			wpposts.post_modified as updated
			FROM {$gmw_pt_table} gmwLocations 
			INNER JOIN {$wpdb->prefix}posts wpposts 
			ON gmwLocations.post_id = wpposts.ID
			LIMIT {$this->records_completed}, {$this->records_per_batch}
		"
		); // WPCS: unprepared SQL ok, db call ok, cache ok.

// count rows only when init the importer.
		$this->total_locations = 0 === $this->total_locations ? $wpdb->get_var( 'SELECT FOUND_ROWS()' ) : $this->total_locations; // WPCS: db call ok, cache ok.

return $data;
	}

/**
	 * Delete import notice option when done importing
	 *
	 * @param  [type] $data data.
	 */
	public function import_done( $data ) {
		delete_option( 'gmw_old_locations_tables_exist' );
		update_option( 'gmw_old_locations_tables_updated', true );
	}
}

/**
 * Users Locations importer class
 *
 * @since 3.0
 */
class GMW_Users_Locations_Importer_V3 extends GMW_Locations_Importer {

/**
	 * The object type we importing.
	 *
	 * @var string
	 */
	protected $object_type = 'user';

/**
	 * Records to import per batch.
	 *
	 * @var integer
	 */
	protected $records_per_batch = 50;

/**
	 * Message
	 *
	 * @var string
	 */
	public $form_message = 'Import existing users/members locations into GEO my WP v3.0 database table.';

/**
	 * Get location from database.
	 *
	 * @return [type] [description]
	 */
	public function query_locations() {

global $wpdb;

// check for post types table.
		$gmw_users_table = 'wppl_friends_locator';

// count rows only when init the importer.
		$count_rows = 0 === $this->total_locations ? 'SQL_CALC_FOUND_ROWS' : '';

/**
		 * Check if street_name and street number columns exists. If so, add them to the query below.
		 *
		 * These columns added to GEO my WP in a later version, so in some sites they
		 *
		 * might not exists.
		 *
		 * We do this to prevent error with the importer.
		 */
		$street_colums = '';
		$sc            = $wpdb->get_results( "SHOW COLUMNS FROM {$gmw_users_table} LIKE 'street_name'" ); // WPCS: unprepared SQL ok, db call ok, cache ok.

if ( ! empty( $sc ) ) {
			$street_colums = 'gmwLocations.street_number, gmwLocations.street_name,';
		}

// get records from database.
		$data = $wpdb->get_results(
			"
			SELECT {$count_rows} 
			gmwLocations.member_id as object_id, 
			gmwLocations.member_id as user_id, 
			wpusers.user_status as status,		
			'0' as featured,
			wpusers.display_name as title,
			gmwLocations.lat as latitude,
			gmwLocations.long as longitude,
			{$street_colums}
			gmwLocations.street,
			gmwLocations.apt as permise,
			gmwLocations.city,
			gmwLocations.state_long as region_name,
			gmwLocations.state as region_code,
			gmwLocations.zipcode as	postcode,
			gmwLocations.country_long as country_name,
			gmwLocations.country as country_code,
			gmwLocations.address,
			gmwLocations.formatted_address,
			gmwLocations.map_icon,
			wpusers.user_registered as created
			FROM {$gmw_users_table} gmwLocations 
			INNER JOIN {$wpdb->users} wpusers 
			ON gmwLocations.member_id = wpusers.ID
			LIMIT {$this->records_completed}, {$this->records_per_batch}
		"
		); // WPCS: unprepared SQL ok, db call ok, cache ok.

// count rows only when init the importer.
		$this->total_locations = 0 === $this->total_locations ? $wpdb->get_var( 'SELECT FOUND_ROWS()' ) : $this->total_locations; // WPCS: db call ok, cache ok.

return $data;
	}

[+] ..
[-] gmw-v-3-import.php [edit]
[-] gmw-data.php [edit]
[-] posts-locator.php [edit]
[-] forms.php [edit]
[-] location-tables.php [edit]