Tiny File Manager

Back Back Up Advanced Editor

<?php

if ( ! defined( 'ABSPATH' ) ) {
	die( 'You are not allowed to call this page directly.' );
}

class FrmProXMLController {

public static function route( $continue, $action ) {
		if ( $action == 'import_csv' ) {
			self::import_csv();
			$continue = false;
		}
		return $continue;
	}

public static function importing_xml( $imported, $xml ) {
		if ( ! isset($xml->view) && ! isset($xml->item) ) {
			return $imported;
		}

$append = array(
			'items' => 0,
		);
		$imported['updated'] = array_merge($imported['updated'], $append);
		$imported['imported'] = array_merge($imported['imported'], $append);
		unset($append);

// get entries
		if ( isset($xml->item) ) {
			$imported = FrmProXMLHelper::import_xml_entries($xml->item, $imported);
			unset($xml->item);
		}

return $imported;
	}

public static function csv_instructions_1() {
		return __( 'Upload your Formidable XML or CSV file to import forms, entries, and views into this site. Note: If your imported form/entry/view key and creation date match an item on your site, that item will be updated. You cannot undo this action.', 'formidable-pro' );
	}

public static function csv_instructions_2() {
		return __( 'Choose a Formidable XML or any CSV file', 'formidable-pro' );
	}

/**
	 * @param array|object $forms
	 */
	public static function csv_opts( $forms ) {
		$csv_del = FrmAppHelper::get_param( 'csv_del', ',', 'get', 'sanitize_text_field' );
		$form_id = FrmAppHelper::get_param( 'form_id', '', 'get', 'absint' );
		$csv_files = FrmAppHelper::get_param( 'csv_files', '', 'get', 'absint' );

if ( 'object' == gettype( $forms ) ) {
			// do_action resets an array with a single object in it
			$forms = array( $forms );
		}

include(FrmProAppHelper::plugin_path() . '/classes/views/xml/csv_opts.php');
	}

public static function xml_export_types( $types ) {
		$types['posts'] = __( 'Views', 'formidable-pro' );
		$types['styles'] = __( 'Styles', 'formidable-pro' );

return $types;
	}

public static function export_formats( $formats ) {
		$formats['csv'] = array( 'name' => 'CSV', 'support' => 'items', 'count' => 'single' );
		$formats['xml']['support'] = 'forms|items|posts|styles';

return $formats;
	}

public static function csv_filter( $query, $atts ) {
		if ( ! empty( $atts['search'] ) && ! $atts['item_id'] ) {
			$query = FrmProEntriesHelper::get_search_str( $query, $atts['search'], $atts['form_id'], $atts['fid'] );
		}
		return $query;
	}

public static function csv_row( $row, $atts ) {
		$row['user_id'] = FrmFieldsHelper::get_user_display_name( $atts['entry']->user_id, 'user_login' );
		$row['updated_by'] = FrmFieldsHelper::get_user_display_name( $atts['entry']->updated_by, 'user_login' );
		self::add_comments_to_csv( $row, $atts );
		return $row;
	}

private static function add_comments_to_csv( &$row, $atts ) {
		if ( ! $atts['comment_count'] ) {
			// don't continue if we already know there are no comments
			return;
		}

$comments = FrmEntryMeta::getAll( array( 'item_id' => (int) $atts['entry']->id, 'field_id' => 0 ), ' ORDER BY it.created_at ASC' );

$i = 0;
		if ( $comments ) {
			foreach ( $comments as $comment ) {
				$c = $comment->meta_value;
				FrmProAppHelper::unserialize_or_decode( $c );
				if ( ! isset( $c['comment'] ) ) {
					continue;
				}

$row[ 'comment' . $i ] = $c['comment'];

$row[ 'comment_user_id' . $i ] = FrmFieldsHelper::get_user_display_name( $c['user_id'], 'user_login' );
				unset( $c );

$row[ 'comment_created_at' . $i ] = FrmAppHelper::get_formatted_time( $comment->created_at, $atts['date_format'], ' ');
				unset( $comment );
				$i++;
			}
		}

for ( $i; $i <= $atts['comment_count']; $i++ ) {
			$row[ 'comment' . $i ] = '';
			$row[ 'comment_user_id' . $i ] = '';
			$row[ 'comment_created_at' . $i ] = '';
		}
	}

public static function csv_field_value( $field_value, $atts ) {
		// Post values need to be retrieved differently
		if ( $atts['entry']->post_id && ( $atts['field']->type == 'tag' || ( isset( $atts['field']->field_options['post_field'] ) && $atts['field']->field_options['post_field'] ) ) ) {
			$field_value = FrmProEntryMetaHelper::get_post_value(
				$atts['entry']->post_id,
				$atts['field']->field_options['post_field'],
				$atts['field']->field_options['custom_field'],
				array(
					'truncate' => ( ( $atts['field']->field_options['post_field'] == 'post_category' ) ? true : false ),
					'form_id' => $atts['entry']->form_id, 'field' => $atts['field'], 'type' => $atts['field']->type,
					'exclude_cat' => ( isset( $atts['field']->field_options['exclude_cat'] ) ? $atts['field']->field_options['exclude_cat'] : 0 ),
					'sep' => $atts['separator'],
				)
			);
		}

$field_value = FrmProFieldsHelper::get_export_val( $field_value, $atts['field'], $atts['entry'] );

return $field_value;
	}

// map fields from csv
	public static function map_csv_fields() {
		$name = 'frm_import_file';

if ( ! isset( $_FILES ) || ! isset( $_FILES[ $name ] ) || empty( $_FILES[ $name ]['name'] ) || (int) $_FILES[ $name ]['size'] < 1 ) {
			return;
		}

$file = $_FILES[ $name ]['tmp_name'];

// check if file was uploaded
		if ( ! is_uploaded_file( $file ) ) {
			return;
		}

if ( empty( $_POST['form_id'] ) ) {
			$errors = array( __( 'All Fields are required', 'formidable-pro' ) );
			FrmXMLController::form($errors);
			return;
		}

// upload
		$media_id = ( ! empty( $_POST[ $name ] ) && is_numeric( $_POST[ $name ] ) ) ? absint( $_POST[ $name ] ) : FrmProFileField::upload_file( $name );
		if ( $media_id && ! is_wp_error( $media_id ) ) {
			$filename = get_attached_file($media_id);
		}

if ( empty( $filename ) ) {
			$errors = array( __( 'That CSV was not uploaded. Are CSV files allowed on your site?', 'formidable-pro' ) );
			FrmXMLController::form($errors);
			return;
		}

$headers   = '';
		$example   = '';
		$csv_del   = FrmAppHelper::get_param( 'csv_del', ',', 'get', 'sanitize_text_field' );
		$csv_files = FrmAppHelper::get_param( 'csv_files', ',', 'get', 'absint' );
		$form_id   = FrmAppHelper::get_param( 'form_id', '', 'get', 'absint' );

if ( 0200 === FrmProFileField::get_chmod( array( 'file' => $filename ) ) ) {
			FrmProFileField::chmod( $filename, 0600 );
		}

setlocale(LC_ALL, get_locale());
		$f = fopen( $filename, 'r' );
		if ( $f !== false ) {
			$row = 0;
			while ( ( $data = fgetcsv( $f, 100000, $csv_del ) ) !== false ) {
				$row ++;
				if ( $row === 1 ) {
					$headers = $data;
				} elseif ( $row === 2 ) {
					$example = $data;
				} else {
					continue;
				}
			}
			fclose( $f );
		} else {
			$errors = array( __( 'CSV cannot be opened.', 'formidable-pro' ) );
			FrmXMLController::form($errors);
			return;
		}

$fields = FrmField::get_all_for_form( $form_id, '', 'include', 'include' );

/**
		 * Allows modifying fields for CSV import mapping.
		 *
		 * @since 5.4
		 *
		 * @param object[] $fields Array of field objects.
		 * @param array    $args   Contains `form_id`, `context` and `meta`.
		 */
		$fields = apply_filters( 'frm_pro_fields_for_csv_mapping', $fields, compact( 'form_id' ) );

include FrmProAppHelper::plugin_path() . '/classes/views/xml/map_csv_fields.php';
	}

public static function import_csv() {
		//Import csv to entries
		$import_count = 250;
		$media_id = FrmAppHelper::get_param( 'frm_import_file', '', 'get', 'absint' );
		$current_path = get_attached_file($media_id);
		$row = FrmAppHelper::get_param('row', 0, 'get', 'absint' );
		$csv_del = FrmAppHelper::get_param( 'csv_del', ',', 'get', 'sanitize_text_field' );
		$csv_files = FrmAppHelper::get_param( 'csv_files', ',', 'get', 'absint' );
		$form_id = FrmAppHelper::get_param( 'form_id', 0, 'get', 'absint' );

$opts = get_option('frm_import_options');

$left = ( $opts && isset( $opts[ $media_id ] ) ) ? ( (int) $row - (int) $opts[ $media_id ]['imported'] - 1 ) : ( $row - 1 );
		if ( $row < 300 && ( ! isset( $opts[ $media_id ] ) || $opts[ $media_id ]['imported'] < 300 ) ) {
			// if the total number of rows is less than 250
			$import_count = ceil( $left / 2 );
		}

if ( $import_count > $left ) {
			$import_count = $left;
		}

$mapping = FrmAppHelper::get_param( 'data_array', '', 'get', 'sanitize_text_field' );
		$url_vars = '&csv_del=' . urlencode( $csv_del ) . "&form_id={$form_id}&frm_import_file={$media_id}&row={$row}&max={$import_count}";
		$url_vars .= '&csv_files=' . $csv_files;

foreach ( $mapping as $mkey => $map ) {
			$url_vars .= "&data_array[$mkey]=$map";
		}

include(FrmProAppHelper::plugin_path() . '/classes/views/xml/import_csv.php');
	}

public static function import_csv_entries() {
		check_ajax_referer( 'frm_ajax', 'nonce' );
		FrmAppHelper::permission_check('frm_create_entries');

$opts = get_option('frm_import_options');
		if ( ! $opts ) {
			$opts = array();
		}

$vars = $_POST;
		$file_id = $vars['frm_import_file'];
		$current_path = get_attached_file($file_id);
		$start_row = isset( $opts[ $file_id ] ) ? $opts[ $file_id ]['imported'] : 1;

$imported = FrmProXMLHelper::import_csv( $current_path, $vars['form_id'], $vars['data_array'], 0, $start_row + 1, $vars['csv_del'], $vars['max'] );

$opts[ $file_id ] = array( 'row' => $vars['row'], 'imported' => $imported );
		$remaining = ( (int) $vars['row'] - (int) $imported );
		echo (int) $remaining;

// check if the import is complete
		if ( ! $remaining ) {
			unset( $opts[ $file_id ] );

// since we are finished with this csv, delete it
			wp_delete_attachment($file_id, true);
		}

update_option( 'frm_import_options', $opts, 'no' );

wp_die();
	}

/**
	 * The templates are now off-site
	 *
	 * @deprecated 3.06
	 */
	public static function import_default_templates( $files ) {
		_deprecated_function( __METHOD__, '3.06' );
		return $files;
	}

/**
	 * @since 5.0.06
	 *
	 * @param array $headings
	 * @return array
	 */
	public static function export_csv_headings( $headings ) {
		if ( ! self::exporting_specific_columns_only() ) {
			return $headings;
		}
		return self::sort_csv_headings( $headings );
	}

/**
	 * @since 5.0.06
	 *
	 * @param array $headings
	 * @return array
	 */
	private static function sort_csv_headings( $headings ) {
		$custom_columns  = self::get_custom_columns();
		$sorted_headings = array();
		foreach ( $custom_columns as $column ) {
			if ( array_key_exists( $column, $headings ) ) {
				$sorted_headings[ $column ] = $headings[ $column ];
			} elseif ( in_array( $column, array( 'comment', 'comment_user_id', 'comment_created_at' ), true ) ) {
				$sorted_headings += self::pull_series_of_headings( $headings, $column );
			} else {
				$sorted_headings += self::pull_series_of_headings( $headings, $column, '[', ']' );
			}
		}
		return $sorted_headings;
	}

/**
	 * @since 5.0.06
	 *
	 * @param array  $headings
	 * @param string $column
	 * @param string $index_prefix
	 * @param string $index_suffix
	 */
	private static function pull_series_of_headings( $headings, $column, $index_prefix = '', $index_suffix = '' ) {
		$index           = 0;
		$sorted_headings = array();
		while ( 1 ) {
			$key = $column . $index_prefix . $index . $index_suffix;
			if ( ! array_key_exists( $key, $headings ) ) {
				break;
			}
			$sorted_headings[ $key ] = $headings[ $key ];
			++$index;
		}
		return $sorted_headings;

}

/**
	 * @since 5.0.06
	 *
	 * @param array $csv_fields
	 * @return array
	 */
	public static function fields_for_csv_export( $csv_fields ) {
		if ( ! self::exporting_specific_columns_only() ) {
			return $csv_fields;
		}
		$ids = self::get_custom_field_ids();
		return array_filter(
			$csv_fields,
			function( $field ) use ( $ids ) {
				return in_array( $field->id, $ids, true );
			}
		);
	}

/**
	 * @since 5.0.06
	 *
	 * @return bool
	 */
	private static function exporting_specific_columns_only() {
		return isset( $_GET['columns'] );
	}

/**
	 * @since 5.0.06
	 *
	 * @return array
	 */
	private static function get_custom_field_ids() {
		$field_ids      = array();
		$custom_columns = self::get_custom_columns();
		foreach ( $custom_columns as $key ) {
			if ( is_numeric( $key ) ) {
				$field_ids[] = $key;
			} elseif ( '_label' === substr( $key, -6 ) ) {
				$stripped_key = str_replace( '_label', '', $key );
				if ( is_numeric( $stripped_key ) ) {
					$field_ids[] = $stripped_key;
				}
			}
		}
		return $field_ids;
	}

/**
	 * @since 5.0.06
	 *
	 * @return array
	 */
	private static function get_custom_columns() {
		return explode( ',', FrmAppHelper::get_param( 'columns', '', 'get', 'sanitize_text_field' ) );
	}
}