|
Server : Apache System : Linux srv.rainic.com 4.18.0-553.47.1.el8_10.x86_64 #1 SMP Wed Apr 2 05:45:37 EDT 2025 x86_64 User : rainic ( 1014) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/stando/www/wp-content/plugins/wpseo-local/classes/ |
Upload File : |
<?php
/**
* Yoast SEO: Local plugin file.
*
* @package WPSEO_LOCAL\Import
*/
if ( ! defined( 'WPSEO_LOCAL_VERSION' ) ) {
header( 'Status: 403 Forbidden' );
header( 'HTTP/1.1 403 Forbidden' );
exit();
}
if ( ! class_exists( 'WPSEO_Local_Import' ) ) {
/**
* Class that holds the functionality for the WPSEO Local Import function
*
* @since 3.9
*/
class WPSEO_Local_Import extends WPSEO_Local_Import_Export {
/**
* WPSEO_Local_Import constructor.
*/
public function __construct() {
// Create an instance of the parent.
parent::__construct();
add_action( 'admin_init', array( $this, 'maybe_handle_import' ), 11 );
add_action( 'wpseo_import_tab_content_inner', array( $this, 'import_html' ), 11 );
}
/**
* Check if the import should be run, else display the import form.
*/
public function maybe_handle_import() {
if ( ! empty( $_POST ) && isset( $_POST['csv-import'] ) ) {
$this->handle_csv_import();
}
}
/**
* Handle the import of the uploaded .csv file.
*/
private function handle_csv_import() {
if ( isset( $_POST['csv-import'] ) && check_admin_referer( 'wpseo_local_import_nonce', 'wpseo_local_import_nonce_field' ) ) {
/**
* Set max execution time to 3600 seconds (or 1 hour)
*
* @Todo See if we can do in batches, to avoid tempering with execution times
*/
set_time_limit( 3600 );
$count = 0;
$options = get_option( $this->option_name );
$csv_path = $this->wpseo_upload_dir . basename( $_FILES['wpseo']['name']['csvuploadlocations'] );
if ( ! empty( $_FILES['wpseo'] ) && ! move_uploaded_file( $_FILES['wpseo']['tmp_name']['csvuploadlocations'], $csv_path ) ) {
$this->messages[] = array(
'type' => 'error',
'content' => sprintf(
/* translators: %s expands to the location of the WPSEO upload dir. */
__( 'Sorry, there was an error while uploading the CSV file.<br>Please make sure the %s directory is writable (chmod 777).', 'yoast-local-seo' ),
$this->wpseo_upload_dir
),
);
}
$is_simplemap_import = ! empty( $_POST['is-simplemap-import'] ) && $_POST['is-simplemap-import'] == '1';
$separator = ',';
if ( ( ! empty( $_POST['csv_separator'] ) && $_POST['csv_separator'] === 'semicolon' ) && false === $is_simplemap_import ) {
$separator = ';';
}
// Get location data from CSV.
$column_names = $this->columns;
// If a simplemap import is used, overwrite our WPSEO Local columns.
if ( $is_simplemap_import ) {
$column_names = array(
'name',
'address',
'address2',
'city',
'state',
'zipcode',
'country',
'phone',
'email',
'fax',
'url',
'description',
'special',
'lat',
'long',
'pubdate',
'category',
'tag',
);
}
$handle = fopen( $csv_path, 'r' );
$locations = array();
$row = 0;
while ( ( $csvdata = fgetcsv( $handle, 2000, $separator ) ) !== false ) {
if ( $row > 0 ) {
$tmp_location = array();
$column_name_count = count( $column_names );
$simplemap_skip_columns = array(
'email',
'url',
'special',
'pubdate',
'tag',
);
for ( $i = 0; $i < $column_name_count; $i++ ) {
// Skip columns for simplemap import.
if ( $is_simplemap_import
&& in_array( $column_names[ $i ], $simplemap_skip_columns, true )
) {
continue;
}
if ( isset( $csvdata[ $i ] ) ) {
$tmp_location[ $column_names[ $i ] ] = addslashes( $csvdata[ $i ] );
}
}
array_push( $locations, $tmp_location );
}
$row++;
}
fclose( $handle );
$debug = false;
global $wpseo_local_core;
$business_types = $wpseo_local_core->get_local_business_types();
array_walk( $business_types, 'wpseo_local_sanitize_business_types' );
foreach ( $locations as $location ) {
// Create standard post data.
$current_post['ID'] = '';
$current_post['post_title'] = isset( $location['name'] ) ? $location['name'] : '';
$current_post['post_content'] = isset( $location['description'] ) ? $location['description'] : '';
$current_post['post_status'] = 'publish';
$current_post['post_type'] = 'wpseo_locations';
$post_id = wp_insert_post( $current_post );
if ( ! $debug ) {
// Insert custom fields for location details.
if ( ! empty( $post_id ) ) {
add_post_meta( $post_id, '_wpseo_business_name', isset( $location['name'] ) ? sanitize_text_field( $location['name'] ) : '', true );
add_post_meta( $post_id, '_wpseo_business_address', isset( $location['address'] ) ? sanitize_text_field( $location['address'] ) : '', true );
add_post_meta( $post_id, '_wpseo_business_address_2', isset( $location['address'] ) ? sanitize_text_field( $location['address_2'] ) : '', true );
add_post_meta( $post_id, '_wpseo_business_city', isset( $location['city'] ) ? sanitize_text_field( $location['city'] ) : '', true );
add_post_meta( $post_id, '_wpseo_business_state', isset( $location['state'] ) ? sanitize_text_field( $location['state'] ) : '', true );
add_post_meta( $post_id, '_wpseo_business_zipcode', isset( $location['zipcode'] ) ? sanitize_text_field( $location['zipcode'] ) : '', true );
add_post_meta( $post_id, '_wpseo_business_country', isset( $location['country'] ) ? sanitize_text_field( $location['country'] ) : '', true );
add_post_meta( $post_id, '_wpseo_business_phone', isset( $location['phone'] ) ? sanitize_text_field( $location['phone'] ) : '', true );
add_post_meta( $post_id, '_wpseo_business_fax', isset( $location['fax'] ) ? sanitize_text_field( $location['fax'] ) : '', true );
add_post_meta( $post_id, '_wpseo_business_email', isset( $location['email'] ) ? sanitize_email( $location['email'] ) : '', true );
add_post_meta( $post_id, '_wpseo_business_vat_id', isset( $location['vat_id'] ) ? sanitize_text_field( $location['vat_id'] ) : '', true );
add_post_meta( $post_id, '_wpseo_business_tax_id', isset( $location['tax_id'] ) ? sanitize_text_field( $location['tax_id'] ) : '', true );
add_post_meta( $post_id, '_wpseo_business_coc_id', isset( $location['coc_id'] ) ? sanitize_text_field( $location['coc_id'] ) : '', true );
if ( isset( $location['phone_2nd'] ) ) {
add_post_meta( $post_id, '_wpseo_business_phone_2nd', $location['phone_2nd'], true );
}
if ( isset( $location['category'] ) ) {
// Allow for a comma separated list to be used.
$categories = explode( ',', $location['category'] );
// Remove possible spaces.
array_walk( $categories, 'trim' );
// And finally set the terms in the locations category.
wp_set_object_terms( $post_id, $categories, 'wpseo_locations_category' );
}
if ( isset( $location['business_type'] ) ) {
$business_type = $location['business_type'];
if ( false === in_array( $business_type, array_keys( $business_types ) ) ) {
$business_type = array_search( $business_type, $business_types );
}
add_post_meta( $post_id, '_wpseo_business_type', $business_type, true );
}
if ( isset( $location['url'] ) ) {
add_post_meta( $post_id, '_wpseo_business_url', sanitize_text_field( $location['url'] ), true );
}
// Replace comma's into points.
$location['lat'] = str_replace( ',', '.', $location['lat'] );
$location['long'] = str_replace( ',', '.', $location['long'] );
add_post_meta( $post_id, '_wpseo_coordinates_lat', sanitize_text_field( $location['lat'] ), true );
add_post_meta( $post_id, '_wpseo_coordinates_long', sanitize_text_field( $location['long'] ), true );
// If just a postal adddress, check box.
if ( '1' == $location['is_postal_address'] ) {
update_post_meta( $post_id, '_wpseo_is_postal_address', '1' );
}
// Add image as post thumbnail.
if ( ! empty( $location['image'] ) ) {
$wpseo_local_core->insert_attachment( $post_id, $location['image'], true );
}
if ( ! empty( $location['location_logo'] ) ) {
$logo_id = $wpseo_local_core->insert_attachment( $post_id, $location['location_logo'], false );
update_post_meta( $post_id, '_wpseo_business_location_logo', wp_get_attachment_image_url( $logo_id, 'full' ) );
}
if ( ! empty( $location['custom_marker'] ) ) {
$marker_id = $wpseo_local_core->insert_attachment( $post_id, $location['custom_marker'], false );
update_post_meta( $post_id, '_wpseo_business_location_custom_marker', wp_get_attachment_image_url( $marker_id ) );
}
// Opening hours.
foreach ( $wpseo_local_core->days as $key => $day ) {
if ( isset( $location[ 'opening_hours_' . $key . '_from' ] ) && ! empty( $location[ 'opening_hours_' . $key . '_from' ] ) && isset( $location[ 'opening_hours_' . $key . '_to' ] ) && ! empty( $location[ 'opening_hours_' . $key . '_to' ] ) ) {
if ( 'closed' === strtolower( $location[ 'opening_hours_' . $key . '_from' ] ) || 'closed' === strtolower( $location[ 'opening_hours_' . $key . '_to' ] ) ) {
add_post_meta( $post_id, '_wpseo_opening_hours_' . $key . '_from', 'closed', true );
}
else {
$time_from = strtotime( $location[ 'opening_hours_' . $key . '_from' ] );
$time_to = strtotime( $location[ 'opening_hours_' . $key . '_to' ] );
if ( false !== $time_from && false !== $time_to ) {
add_post_meta( $post_id, '_wpseo_opening_hours_' . $key . '_from', gmdate( 'H:i', $time_from ), true );
add_post_meta( $post_id, '_wpseo_opening_hours_' . $key . '_to', gmdate( 'H:i', $time_to ), true );
}
else {
add_post_meta( $post_id, '_wpseo_opening_hours_' . $key . '_from', 'closed', true );
if ( false === $time_from ) {
$this->messages[] = array(
'type' => 'error',
'content' => sprintf(
/* translators: %s extends to Location opening hours from per week day */
__( '%s is not a valid time notation', 'yoast-local-seo' ),
$location[ 'opening_hours_' . $key . '_from' ]
),
);
}
elseif ( false === $time_to ) {
$this->messages[] = array(
'type' => 'error',
'content' => sprintf(
/* translators: %s extends to Location opening hours to per week day */
__( '%s is not a valid time notation', 'yoast-local-seo' ),
$location[ 'opening_hours_' . $key . '_to' ]
),
);
}
}
if ( 'on' === $location['multiple_opening_hours'] ) {
// Multiple openingtimes are set. Enable them in the backend.
update_post_meta( $post_id, '_wpseo_multiple_opening_hours', 'on', true );
}
if ( isset( $location[ 'opening_hours_' . $key . '_second_from' ] ) && ! empty( $location[ 'opening_hours_' . $key . '_second_from' ] ) && isset( $location[ 'opening_hours_' . $key . '_second_to' ] ) && ! empty( $location[ 'opening_hours_' . $key . '_second_to' ] ) ) {
if ( isset( $location[ 'opening_hours_' . $key . '_second_from' ] ) && ! empty( $location[ 'opening_hours_' . $key . '_from' ] ) && isset( $location[ 'opening_hours_' . $key . '_second_to' ] ) && ! empty( $location[ 'opening_hours_' . $key . '_to' ] ) ) {
if ( 'closed' === strtolower( $location[ 'opening_hours_' . $key . '_second_from' ] ) || 'closed' === strtolower( $location[ 'opening_hours_' . $key . '_second_to' ] ) ) {
add_post_meta( $post_id, '_wpseo_opening_hours_' . $key . '_second_from', 'closed', true );
}
}
else {
$time_second_from = strtotime( $location[ 'opening_hours_' . $key . '_second_from' ] );
$time_second_to = strtotime( $location[ 'opening_hours_' . $key . '_second_to' ] );
if ( false !== $time_second_from && false !== $time_second_to ) {
add_post_meta( $post_id, '_wpseo_opening_hours_' . $key . '_second_from', gmdate( 'H:i', $time_second_from ), true );
add_post_meta( $post_id, '_wpseo_opening_hours_' . $key . '_second_to', gmdate( 'H:i', $time_second_to ), true );
}
else {
add_post_meta( $post_id, '_wpseo_opening_hours_' . $key . '_second_from', 'closed', true );
if ( false === $time_second_from ) {
$this->messages[] = array(
'type' => 'error',
'content' => sprintf(
/* translators: %s extends to Location second from opening hours per week day */
__( '%s is not a valid time notation', 'yoast-local-seo' ),
$location[ 'opening_hours_' . $key . '_second_from' ]
),
);
}
elseif ( false === $time_second_to ) {
$this->messages[] = array(
'type' => 'error',
'content' => sprintf(
/* translators: %s extends to Location second to opening hours per week day */
__( '%s is not a valid time notation', 'yoast-local-seo' ),
$location[ 'opening_hours_' . $key . '_second_to' ]
),
);
}
}
}
}
else {
add_post_meta( $post_id, '_wpseo_opening_hours_' . $key . '_second_from', 'closed', true );
}
}
}
else {
add_post_meta( $post_id, '_wpseo_opening_hours_' . $key . '_from', 'closed', true );
}
}
$count++;
$last_imported = $post_id;
}
}
}
if ( $count > 0 ) {
$this->messages[] = array(
'type' => 'success',
'content' => sprintf(
/* translators: 1: nr of locations found; 2: link to post type overview; 3: link close tag. */
__( '%1$d locations found and successfully imported %2$shere%3$s', 'yoast-local-seo' ),
$count,
'<a href="' . esc_url( get_admin_url( null, 'edit.php?post_type=wpseo_locations' ) ) . '">',
'</a>'
),
);
}
}
}
/**
* Builds the HTML for the import form.
*/
public function import_html() {
echo '<h2>' . esc_html__( 'Import', 'yoast-local-seo' ) . '</h2>';
/* translators: %1$s extends to link opening tag; %2$s closes the tag */
echo '<p>' . sprintf( __( 'View the %1$sdocumentation%2$s to check what format of the CSV file should be.', 'yoast-local-seo' ), '<a href="https://yoast.com/question/csv-import-file-local-seo-look-like/" target="_blank">', '</a>' ) . '</p>';
echo '<form action="" method="post" enctype="multipart/form-data">';
WPSEO_Local_Admin_Wrappers::file_upload( 'csvuploadlocations', __( 'Upload CSV', 'yoast-local-seo' ) );
echo '<label for="csv_separator" class="checkbox">' . esc_html__( 'Column separator', 'yoast-local-seo' ) . ':</label>';
echo '<select class="textinput" id="csv_separator" name="csv_separator">';
echo '<option value="comma">' . esc_html__( 'Comma', 'yoast-local-seo' ) . '</option>';
echo '<option value="semicolon">' . esc_html__( 'Semicolon', 'yoast-local-seo' ) . '</option>';
echo '</select>';
echo '<br class="clear">';
echo '<p>';
echo '<input class="checkbox double" id="is-simplemap-import" type="checkbox" name="is-simplemap-import" value="1"> ';
echo '<label for="is-simplemap-import">' . esc_html__( 'This CSV is exported by the SimpleMap plugin', 'yoast-local-seo' ) . '</label>';
echo '</p>';
echo '<br class="clear">';
echo '<br/>';
echo '<p><em>' . esc_html__( 'Note', 'yoast-local-seo' ) . ': ' . esc_html__( 'The Geocoding API is limited to 2,500 queries a day, so when you have large CSV files, with no coordinates, cut them in pieces of 2,500 rows and import them one a day. Indeed, it\'s not funny. It\'s reality.', 'yoast-local-seo' ) . '</em></p>';
if ( ! is_writable( $this->wpseo_upload_dir ) ) {
/* translators: %s extends to the upload directory */
echo '<p>' . sprintf( __( 'Make sure the %s directory is writeable.', 'yoast-local-seo' ), '<code>"' . $this->wpseo_upload_dir . '"</code>' ) . '</p>';
}
// Add a NONCE field.
wp_nonce_field( 'wpseo_local_import_nonce', 'wpseo_local_import_nonce_field' );
echo '<input type="submit" class="button button-primary" name="csv-import" value="Import" ' . ( ! is_writable( $this->wpseo_upload_dir ) ? ' disabled="disabled"' : '' ) . ' />';
echo '</form>';
}
}
}