<?php
/**
 * @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',
						/* translators: %s expands to the location of the WPSEO upload dir. */
						'content' => sprintf( __( '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 ) {
						if ( empty( $location['lat'] ) && empty( $location['long'] ) ) {
							$address_format = ! empty( $options['address_format'] ) ? $options['address_format'] : 'address-state-postal';
							$format         = new WPSEO_Local_Address_Format();
							$full_address   = $format->get_address_format( $address_format, array(
								'business_address' => $location['address'],
								'oneline'          => true,
								'business_zipcode' => $location['zipcode'],
								'business_city'    => $location['city'],
								'business_state'   => $location['state'],
								'show_state'       => true,
								'escape_output'    => false,
								'use_tags'         => false,
							) );

							if ( ! empty( $location['country'] ) ) {
								$full_address .= ', ' . WPSEO_Local_Frontend::get_country( $location['country'] );
							}

							$geo_data = wpseo_geocode_address( $full_address );

							if ( ! is_wp_error( $geo_data ) && ! empty( $geo_data->results[0] ) ) {
								$location['lat']  = $geo_data->results[0]->geometry->location->lat;
								$location['long'] = $geo_data->results[0]->geometry->location->lng;
							}
							else {
								$location['lat']  = '';
								$location['long'] = '';

								if ( $geo_data->get_error_code() === 'wpseo-query-limit' ) {
									$this->messages[] = array(
										'type'    => 'error',
										/* translators: %1$s extends to the link opening tag to the Yoast Local SEO admin page; %2$s closes that tag */
										'content' => sprintf( __( 'The usage of the Google Maps API has exceeded their limits. Please consider entering an API key in the %1$soptions%2$s', 'yoast-local-seo' ), '<a href="' . admin_url( 'admin.php?page=wpseo_local' ) . '">', '</a>' ),
									);

									if ( ! empty( $last_imported ) ) {
										$this->messages[] = array(
											'type'    => 'warning',
											/* translators: %1$s extends to the edit link for the last imported location; %2$s is the anchor text. */
											'content' => sprintf( __( 'The last successfully imported location is <a href="%1$s">%2$s</a>', 'yoast-local-seo' ), get_edit_post_link( $last_imported ), get_the_title( $last_imported ) ),
										);
									}
									break;
								}
								else {
									$this->messages[] = array(
										'type'    => 'error',
										/* translators: %1$s expands to the locations name; %2$s extends to the link opening tag to the location; %3$s closes that tag */
										'content' => sprintf( __( 'Location %1$s could not be geo-coded. %2$sEdit this location%3$s.', 'yoast-local-seo' ), '<em>' . esc_attr( $location['name'] ) . '</em>', '<a href="' . admin_url( 'post.php?post=' . esc_attr( $post_id ) . '&action=edit' ) . '">', '</a>' ),
									);
								}
							}
						}

						// 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 );
							add_post_meta( $post_id, '_wpseo_business_notes_1', isset( $location['notes_1'] ) ? sanitize_text_field( $location['notes_1'] ) : '', true );
							add_post_meta( $post_id, '_wpseo_business_notes_2', isset( $location['notes_2'] ) ? sanitize_text_field( $location['notes_2'] ) : '', true );
							add_post_meta( $post_id, '_wpseo_business_notes_3', isset( $location['notes_3'] ) ? sanitize_text_field( $location['notes_3'] ) : '', 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 );
							}

							// Add notes.
							for ( $i = 0; $i < 3; $i++ ) {
								$n = ( $i + 1 );
								if ( ! empty( $location[ 'notes_' . $n ] ) ) {
									add_post_meta( $post_id, '_wpseo_business_notes_' . $n, $location[ 'notes_' . $n ] );
								}
							}

							// 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', date( 'H:i', $time_from ), true );
											add_post_meta( $post_id, '_wpseo_opening_hours_' . $key . '_to', date( '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',
													/* translators: %s extends to Location opening hours from per week day */
													'content' => sprintf( __( '%s is not a valid time notation', 'yoast-local-seo' ), $location[ 'opening_hours_' . $key . '_from' ] ),
												);
											}
											elseif ( false === $time_to ) {
												$this->messages[] = array(
													'type'    => 'error',
													/* translators: %s extends to Location opening hours to per week day */
													'content' => sprintf( __( '%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', date( 'H:i', $time_second_from ), true );
													add_post_meta( $post_id, '_wpseo_opening_hours_' . $key . '_second_to', date( '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',
															/* translators: %s extends to Location second from opening hours per week day */
															'content' => sprintf( __( '%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',
															/* translators: %s extends to Location second to opening hours per week day */
															'content' => sprintf( __( '%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>';
		}
	}
}
