<?php
// Exit if accessed directly
if ( ! defined( 'ABSPATH' ) ) {
	exit;
}
/**
 * This is a common class for all common functions which we will use in different classes in our plugin
 */
class Adsforwp_Admin_Common_Functions {



	protected $_all_ads_id = array();
	protected $_all_groups = array();


	public function __construct() {

		add_action( 'admin_init', array( $this, 'adsforwp_import_all_settings' ), 9 );
		add_action( 'wp_ajax_adsforwp_export_all_settings', array( $this, 'adsforwp_export_all_settings' ) );
	}
	/*
	 * Here, We are exporting all the settings and and post and saving it in json file
	 */
	public function adsforwp_export_all_settings() {

		if ( ! current_user_can( 'manage_options' ) ) {
			return;
		}
		if ( ! isset( $_GET['_wpnonce'] ) ) {
			return;
		}
		// phpcs:ignore WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized -- Reason Validating nonce so sanitization not needed
		if ( ! wp_verify_nonce( $_GET['_wpnonce'], '_wpnonce' ) ) {
			return;
		}

			$export_ad       = array();
			$export_group    = array();
			$export_data_all = array();
			// ads
			$all_ads_post = get_posts(
				array(
					'post_type'      => 'adsforwp',
					'posts_per_page' => -1,
					'post_status'    => 'any',
				)
			);

		if ( $all_ads_post ) {

			foreach ( $all_ads_post as $ads ) {

				$export_ad[ $ads->ID ]['post']     = $ads;
				$post_meta                         = get_post_meta( $ads->ID, $key = '', true );
				$export_ad[ $ads->ID ]['ads_meta'] = $post_meta;

				$in_group = $this->adsforwp_check_ads_in_group( $ads->ID );

				if ( ! empty( $in_group ) ) {

					$export_ad[ $ads->ID ]['in_groups'] = $in_group;

				}
			}
		}

			$all_group_post = get_posts(
				array(
					'post_type'      => 'adsforwp-groups',
					'posts_per_page' => -1,
					'post_status'    => 'any',
				)
			);

		if ( $all_group_post ) {

			foreach ( $all_group_post as $group ) {

					$export_group[ $group->ID ]['group_post'] = $group;
					$post_meta                                = get_post_meta( $group->ID, $key = '', true );
					$export_group[ $group->ID ]['group_meta'] = $post_meta;

			}
		}

				$get_settings_data                    = get_option( 'adsforwp_settings' );
				$export_data_all['ads']               = $export_ad;
				$export_data_all['group']             = $export_group;
				$export_data_all['adsforwp_settings'] = $get_settings_data;

				header( 'Content-type: application/json' );
				header( 'Content-disposition: attachment; filename=adsforwpbackup.json' );
				echo wp_json_encode( $export_data_all );

		wp_die();
	}
	/*
	 * Here, We are importing all the settings and post which is saved in json file
	 */
	public function adsforwp_import_all_settings() {

		if ( ! current_user_can( 'manage_options' ) ) {
					return;
		}

		$url = get_option( 'adsforwp-file-upload_url' );

		global $wpdb;
		$result = '';

		if ( $url ) {

			$response = wp_remote_get( $url );

			if ( is_wp_error( $response ) ) {
				// Handle the error.
				$error_message = $response->get_error_message();
				// You can log the error or display a message.
				return;
			}
			$json_data    = wp_remote_retrieve_body( $response );
			$json_array   = json_decode( $json_data, true );
			$all_ads_post = $json_array['ads'];
			$ads_in_group = array();

			$all_group_post    = $json_array['group'];
			$adsforwp_settings = $json_array['adsforwp_settings'];
			$ads_post          = array();

			if ( $all_ads_post || $all_group_post ) {

              //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need to run direct query to start transaction
				$wpdb->query( 'START TRANSACTION' );

				// ads
				foreach ( $all_ads_post as $ads_post ) {

					$post = $ads_post['post'];
					unset( $post['ID'] );

					$post_id = wp_insert_post( $post );

					wp_update_post(
						array(
							'ID'   => intval( $post_id ),
							'guid' => sanitize_url( get_option( 'siteurl' ) . '/?post_type=adsforwp&p=' . $post_id ),
						)
					);

					$ads_meta = $ads_post['ads_meta'];

					if ( isset( $ads_post['in_groups'] ) ) {

						$ads_in_group[] = array(
							'new_ad_id' => $post_id,
							'in_group'  => $ads_post['in_groups'],
						);

					}

					foreach ( $ads_meta as $key => $ad ) {

						if ( $key == 'adsforwp_ad_margin' || $key == 'data_group_array' || $key == 'visitor_conditions_array' || $key == 'ampforwp-post-metas' || $key == 'adsforwp_ad_expire_days' ) {

							update_post_meta( $post_id, $key, unserialize( $ad[0] ) );

						} else {

							update_post_meta( $post_id, $key, $ad[0] );

						}
					}
				}
					// group
				foreach ( $all_group_post as $group_post ) {

					$post         = $group_post['group_post'];
					$old_group_id = $post['ID'];
					unset( $post['ID'] );

					$post_id = wp_insert_post( $post );

					wp_update_post(
						array(
							'ID'   => intval( $post_id ),
							'guid' => sanitize_url( get_option( 'siteurl' ) . '/?post_type=adsforwp-groups&p=' . $post_id ),
						)
					);
					$ads_meta = $group_post['group_meta'];

					foreach ( $ads_meta as $key => $ad ) {

						if ( $key == 'adsforwp_ads' ) {
							$new_group_ad = array();

							foreach ( $ads_in_group as $in ) {

								if ( in_array( $old_group_id, $in['in_group'] ) ) {

									$new_group_ad[ $in['new_ad_id'] ] = get_the_title( $in['new_ad_id'] );

								}
							}

							update_post_meta( $post_id, $key, $new_group_ad );

						} elseif ( $key == 'adsforwp_ad_margin' || $key == 'data_group_array' || $key == 'visitor_conditions_array' || $key == 'ampforwp-post-metas' ) {

									update_post_meta( $post_id, $key, unserialize( $ad[0] ) );

						} else {

							update_post_meta( $post_id, $key, $ad[0] );
						}
					}
				}
			}

			update_option( 'adsforwp_settings', $adsforwp_settings );  // Security: Permission verified
			update_option( 'adsforwp-file-upload_url', '' );  // Security: Permission verified

			if ( is_wp_error( $result ) ) {

				echo esc_attr( $result->get_error_message() );
              //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need to run direct query to rollback transaction
				$wpdb->query( 'ROLLBACK' );
			} else {
                          //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need to run direct query to commit transaction
				$wpdb->query( 'COMMIT' );
				return true;
			}
		}
	}

	/**
	 * We are here fetching all groups information from advanced ads plugin
	 *
	 * @return type array
	 */
	public function adsforwp_get_advads_groups() {

		$group_list = array();
		global $wp_version;
		if ( version_compare( $wp_version, '4.5.0', '<' ) ) {
			// For WordPress versions earlier than 4.5.0
            //phpcs:ignore WordPress.WP.DeprecatedParameters.Get_termsParam2Found --Reason : added for old wordpress support
			$terms = get_terms(
				'advanced_ads_groups',
				array(
					'hide_empty' => false,
				)
			);
		} else {
			// For WordPress 4.5.0 and later versions
			$terms = get_terms(
				array(
					'taxonomy'   => 'advanced_ads_groups',
					'hide_empty' => false,
				)
			);
		}

		foreach ( $terms as $term ) {

			$ad_ids = array();
			$args   = array(
				'post_type'      => 'advanced_ads',
				'post_status'    => array( 'publish', 'pending', 'future', 'private' ),
				'taxonomy'       => $term->taxonomy,
				'term'           => $term->slug,
				'posts_per_page' => -1,
			);

			$wp = new WP_Query( $args );

			if ( $wp->post_count ) {

				foreach ( $wp->posts as $ad_id ) {

					$ad_ids[] = $ad_id->ID;

				}
			}
			$group_list[ $term->term_id ] = $ad_ids;
		}
		return $group_list;
	}
	/**
	 * We are here fetching all ads from advanced ads plugin
	 * note: Transaction is applied on this function, if any error occure all the data will be rollbacked
	 *
	 * @global type $wpdb
	 * @return boolean
	 */
	public function adsforwp_import_all_advanced_ads() {

		if ( ! current_user_can( 'manage_options' ) ) {
					return;
		}

		if ( ! isset( $_GET['adsforwp_security_nonce'] ) ) {
			return;
		}
		// phpcs:ignore WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized -- Reason Validating nonce so sanitization not needed
		if ( ! wp_verify_nonce( $_GET['adsforwp_security_nonce'], 'adsforwp_ajax_check_nonce' ) ) {
			return;
		}

		$advads_groups        = array();
		$advads_groups        = $this->adsforwp_get_advads_groups();
		$advads_ads_adsense   = get_option( 'advanced-ads-adsense' );
		$advads_ads_placement = get_option( 'advads-ads-placements' );
		$ads_post             = array();
		global $wpdb;
		$user_id          = get_current_user_id();
		$all_advanced_ads = get_posts(
			array(
				'post_type'      => 'advanced_ads',
				'posts_per_page' => -1,
				'post_status'    => 'any',
			)
		);

		if ( $all_advanced_ads ) {
			// begin transaction
            //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need to run direct query to start transaction
			$wpdb->query( 'START TRANSACTION' );

			foreach ( $all_advanced_ads as $ads ) {

				$ads_post = array(
					'post_author'           => $user_id,
					'post_date'             => $ads->post_date,
					'post_date_gmt'         => $ads->post_date_gmt,
					'post_content'          => $ads->post_content,
					'post_title'            => $ads->post_title,
					'post_excerpt'          => $ads->post_excerpt,
					'post_status'           => $ads->post_status,
					'comment_status'        => $ads->comment_status,
					'ping_status'           => $ads->ping_status,
					'post_password'         => $ads->post_password,
					'post_name'             => $ads->post_name,
					'to_ping'               => $ads->to_ping,
					'pinged'                => $ads->pinged,
					'post_modified'         => $ads->post_modified,
					'post_modified_gmt'     => $ads->post_modified_gmt,
					'post_content_filtered' => $ads->post_content_filtered,
					'post_parent'           => $ads->post_parent,
					'menu_order'            => $ads->menu_order,
					'post_type'             => 'adsforwp',
					'post_mime_type'        => $ads->post_mime_type,
					'comment_count'         => $ads->comment_count,
					'filter'                => $ads->filter,
				);

				$post_id = wp_insert_post( $ads_post );
				wp_update_post(
					array(
						'ID'   => intval( $post_id ),
						'guid' => sanitize_url( get_option( 'siteurl' ) . '/?post_type=adsforwp&p=' . $post_id ),
					)
				);

				$advn_meta_value = array();
				$advn_meta_value = get_post_meta( $ads->ID, $key = 'advanced_ads_ad_options', true );

				foreach ( $advads_groups as $group_id => $ads_id ) {

					for ( $i = 0;$i < count( $ads_id );$i++ ) {

						if ( $ads_id[ $i ] == $ads->ID ) {

							$advads_groups[ $group_id ][ $i ] = $post_id;

						}
					}
				}

				$post_content     = '';
				$slot_id          = '';
				$shortcode        = '';
				$adtype           = '';
				$wheretodisplay   = '';
				$adsense_type     = '';
				$adposition       = '50_of_the_content';
				$paragraph_number = '';

				foreach ( $advads_ads_placement as $placement ) {

					if ( $placement['item'] == 'ad_' . $ads->ID ) {

						switch ( $placement['type'] ) {
							case 'post_top':
								$wheretodisplay = 'before_the_content';
								break;
							case 'post_bottom':
								$wheretodisplay = 'after_the_content';
								break;
							case 'post_content':
								$wheretodisplay = 'between_the_content';
								if ( isset( $placement['item']['options']['index'] ) ) {
									$adposition       = 'number_of_paragraph';
									$paragraph_number = $placement['item']['options']['index'];
								}
								break;
							case 'default':
								$wheretodisplay = 'before_the_content';
								break;
						}
					}
				}
				$ad_expire_enable = 0;
				$expire_date      = gmdate( 'Y-m-d' );

				if ( isset( $advn_meta_value['expiry_date'] ) ) {

					$ad_expire_enable = 1;
					$expire_date      = gmdate( 'Y-m-d', $advn_meta_value['expiry_date'] );

				}

				if ( isset( $advn_meta_value['output']['allow_shortcodes'] ) ) {
					$shortcode = '[adsforwp id="' . $post_id . '"]';
				}

				if ( isset( $advn_meta_value['type'] ) ) {

					switch ( $advn_meta_value['type'] ) {

						case 'image':
							$adtype = 'ad_image';
							break;
						case 'dummy':
							$adtype = 'ad_image';
							break;
						case 'plain':
							$adtype       = 'custom';
							$post_content = $ads->post_content;
							break;
						case 'content':
							$adtype       = 'custom';
							$post_content = $ads->post_content;
							break;
						case 'adsense':
							$adsenedata   = json_decode( $ads->post_content, true );
							$slot_id      = $adsenedata['slotId'];
							$adtype       = 'adsense';
							$adsense_type = 'normal';
							break;
					}
				}

				$adsense_id      = '';
				$ad_width        = '';
				$ad_height       = '';
				$ad_url          = '';
				$ad_redirect_url = '';
				$ad_img_src      = array();

				$adsense_id      = adsforwp_rmv_warnings( $advads_ads_adsense, 'adsense-id', 'adsforwp_string' );
				$ad_width        = adsforwp_rmv_warnings( $advn_meta_value, 'width', 'adsforwp_string' );
				$ad_height       = adsforwp_rmv_warnings( $advn_meta_value, 'height', 'adsforwp_string' );
				$ad_redirect_url = adsforwp_rmv_warnings( $advn_meta_value, 'url', 'adsforwp_string' );

				if ( isset( $advn_meta_value['output']['image_id'] ) ) {
					$ad_img_src = wp_get_attachment_image_src( $advn_meta_value['output']['image_id'], 'full' );
					$ad_url     = $ad_img_src[0];
				}

				$adforwp_meta_key = array(
					'select_adtype'                 => $adtype,
					'adsense_type'                  => $adsense_type,
					'custom_code'                   => $post_content,
					'data_client_id'                => $adsense_id,
					'data_ad_slot'                  => $slot_id,
					'banner_size'                   => $ad_width . 'x' . $ad_height,
					'adsforwp_ad_image'             => $ad_url,
					'adsforwp_ad_redirect_url'      => $ad_redirect_url,
					'adsforwp_ad_img_width'         => $ad_width,
					'adsforwp_ad_img_height'        => $ad_height,
					'wheretodisplay'                => $wheretodisplay,
					'adposition'                    => $adposition,
					'paragraph_number'              => $paragraph_number,
					'adsforwp_ad_expire_day_enable' => 0,
					'adsforwp_ad_expire_days'       => array(
						'Monday'    => 'Monday',
						'Tuesday'   => 'Tuesday',
						'Wednesday' => 'Wednesday',
						'Thursday'  => 'Thursday',
						'Friday'    => 'Friday',
						'Saturday'  => 'Saturday',
						'Sunday'    => 'Sunday',
					),
					'adsforwp_ad_expire_enable'     => $ad_expire_enable,
					'adsforwp_ad_expire_from'       => gmdate( 'Y-m-d', strtotime( $ads->post_date ) ),
					'adsforwp_ad_expire_to'         => $expire_date,
					'manual_ads_type'               => $shortcode,
					'imported_from'                 => 'advance_ads',
				);
				foreach ( $adforwp_meta_key as $key => $val ) {

					update_post_meta( $post_id, $key, $val );

				}
			}
			$result = $this->adsforwp_import_all_advanced_groups( $advads_groups );

			if ( is_wp_error( $result ) ) {

				echo esc_html( $result->get_error_message() );

              //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need to run direct query to rollback transaction
				$wpdb->query( 'ROLLBACK' );

			} else {
              //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need to run direct query to commit transaction
				$wpdb->query( 'COMMIT' );
				return true;

			}
		}
	}

	/**
	 * We are here fetching all ads from advanced ads plugin
	 * note: Transaction is applied on this function, if any error occure all the data will be rollbacked
	 *
	 * @global type $wpdb
	 * @return boolean
	 */
	public function adsforwp_migrate_ampforwp_ads() {

		if ( ! current_user_can( 'manage_options' ) ) {
					return;
		}

		if ( ! isset( $_GET['adsforwp_security_nonce'] ) ) {
			return;
		}
		// phpcs:ignore WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized -- Reason Validating nonce so sanitization not needed
		if ( ! wp_verify_nonce( $_GET['adsforwp_security_nonce'], 'adsforwp_ajax_check_nonce' ) ) {
			return;
		}

		$result           = array();
		$adforwp_meta_key = array();
		$amp_options      = get_option( 'redux_builder_amp' );

		$user_id           = get_current_user_id();
		$ad_size           = array(
			'1' => '300x250',
			'2' => '336x280',
			'3' => '728x90',
			'4' => '300x600',
			'5' => '320x100',
			'6' => '200x50',
			'7' => '320x50',
		);
		$wheretodisplayamp = array(

			'1' => 'adsforwp_below_the_header',
			'2' => 'adsforwp_below_the_footer',
			'3' => 'adsforwp_above_the_post_content',
			'4' => 'adsforwp_below_the_post_content',
			'5' => 'adsforwp_below_the_title',
			'6' => 'adsforwp_above_related_post',

		);
		if ( $amp_options ) {

			for ( $i = 1; $i <= 6; $i++ ) {

				$amp_options[ 'enable-amp-ads-select-' . $i ];
				$amp_options[ 'enable-amp-ads-text-feild-client-' . $i ];
				$amp_options[ 'enable-amp-ads-text-feild-slot-' . $i ];

				$ads_post = array(
					'post_author' => $user_id,
					'post_title'  => 'Adsense Ad ' . $i . ' (Migrated from AMP)',
					'post_status' => 'publish',
					'post_name'   => 'Adsense Ad ' . $i . ' (Migrated from AMP)',
					'post_type'   => 'adsforwp',

				);

				if ( $amp_options[ 'enable-amp-ads-' . $i ] == 1 ) {

						$post_id          = wp_insert_post( $ads_post );
						$data_group_array = array();
						$conditions       = array();

					if ( $i == 3 ) {

						if ( isset( $amp_options['made-amp-ad-3-global'] ) ) {

							$conditions = $amp_options['made-amp-ad-3-global'];

							if ( ! empty( $conditions ) ) {

								for ( $k = 0; $k < count( $conditions ); $k++ ) {

											$displayon = '';
											$key_type  = '';

									if ( $conditions[ $k ] == 1 ) { // Single

										$displayon = 'post';
										$key_type  = 'post_type';

									} elseif ( $conditions[ $k ] == 2 ) { // pages

										$displayon = 'page';
										$key_type  = 'post_type';

									} elseif ( $conditions[ $k ] == 3 ) { // custom post type

										$displayon = 'post';
										$key_type  = 'post_type';

									} elseif ( $conditions[ $k ] == 4 ) {  // global

												unset( $data_group_array );
												$displayon = 'post';
												$key_type  = 'show_globally';

									}

									$data_group_array[ 'group-' . $k ] = array(

										'data_array' => array(
											array(
												'key_1' => $key_type,
												'key_2' => 'equal',
												'key_3' => $displayon,
											),
										),
									);
								}
							} else {

								$data_group_array['group-0'] = array(

									'data_array' => array(
										array(
											'key_1' => 'show_globally',
											'key_2' => 'equal',
											'key_3' => 'post',
										),
									),
								);

							}
						}
					} else {

						if ( $i == 4 || $i == 5 || $i == 6 ) {

										$con_key = 'post_type';

						} else {

							$con_key = 'show_globally';

						}

						$data_group_array['group-0'] = array(
							'data_array' => array(
								array(
									'key_1' => $con_key,
									'key_2' => 'equal',
									'key_3' => 'post',
								),
							),
						);

					}
					$adforwp_meta_key = array(
						'select_adtype'                 => 'adsense',
						'adsense_type'                  => 'normal',
						'data_client_id'                => $amp_options[ 'enable-amp-ads-text-feild-client-' . $i ],
						'data_ad_slot'                  => $amp_options[ 'enable-amp-ads-text-feild-slot-' . $i ],
						'banner_size'                   => $ad_size[ $amp_options[ 'enable-amp-ads-select-' . $i ] ],
						'adsforwp_ad_responsive'        => $amp_options[ 'enable-amp-ads-resp-' . $i ],
						'wheretodisplay'                => $wheretodisplayamp[ $i ],
						'adsforwp_ad_align'             => 'center',
						'ads_for_wp_non_amp_visibility' => 'hide',
						'imported_from'                 => 'ampforwp_ads',
						'data_group_array'              => $data_group_array,
					);

					foreach ( $adforwp_meta_key as $key => $val ) {

						$result[] = update_post_meta( $post_id, $key, $val );

					}
				}
			}

			$options = array();

			$settings = get_option( 'adsforwp_settings' );

			$options['ad_sponsorship_label']      = $amp_options['ampforwp-ads-sponsorship'];
			$options['ad_sponsorship_label_text'] = $amp_options['ampforwp-ads-sponsorship-label'];

			$options = array_merge( $settings, $options );

			update_option( 'adsforwp_settings', $options ); // Security: Permission and nonce verified

		}
		return $result;
	}

	public function adsforwp_migrate_advanced_auto_ads() {

		if ( ! current_user_can( 'manage_options' ) ) {
					return;
		}

		if ( ! isset( $_GET['adsforwp_security_nonce'] ) ) {
			return;
		}
		// phpcs:ignore WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized -- Reason Validating nonce so sanitization not needed
		if ( ! wp_verify_nonce( $_GET['adsforwp_security_nonce'], 'adsforwp_ajax_check_nonce' ) ) {
			return;
		}

		$result           = array();
		$adforwp_meta_key = array();
		$amp_options      = get_option( 'redux_builder_amp' );
		$user_id          = get_current_user_id();

		if ( isset( $amp_options['ampforwp-amp-auto-ads-code'] ) ) {

			$explodestr = explode( '"', $amp_options['ampforwp-amp-auto-ads-code'] );
			$ads_post   = array(
				'post_author' => $user_id,
				'post_title'  => 'Adsense Auto Ads ' . $i . ' (Migrated from Advanced AMP Ads)',
				'post_status' => 'publish',
				'post_name'   => 'Adsense Auto Ads ' . $i . ' (Migrated from Advanced AMP Ads)',
				'post_type'   => 'adsforwp',

			);
				$post_id = wp_insert_post( $ads_post );

				$data_group_array['group-0'] = array(
					'data_array' => array(
						array(
							'key_1' => 'show_globally',
							'key_2' => 'equal',
							'key_3' => 'post',
						),
					),
				);
				$adforwp_meta_key            = array(
					'select_adtype'                 => 'adsense',
					'adsense_type'                  => 'adsense_auto_ads',
					'data_client_id'                => $explodestr[3],
					'ads_for_wp_non_amp_visibility' => 'hide',
					'imported_from'                 => 'ampforwp_advanced_ads',
					'data_group_array'              => $data_group_array,
				);
				foreach ( $adforwp_meta_key as $key => $val ) {
					$result[] = update_post_meta( $post_id, $key, $val );
				}
		}

		return $result;
	}

	public function adsforwp_migrate_advanced_amp_ads_incontent() {

		if ( ! current_user_can( 'manage_options' ) ) {
					return;
		}

		if ( ! isset( $_GET['adsforwp_security_nonce'] ) ) {
			return;
		}
		// phpcs:ignore WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized -- Reason Validating nonce so sanitization not needed
		if ( ! wp_verify_nonce( $_GET['adsforwp_security_nonce'], 'adsforwp_ajax_check_nonce' ) ) {
			return;
		}

		$result           = array();
		$adforwp_meta_key = array();
		$amp_options      = get_option( 'redux_builder_amp' );
		$user_id          = get_current_user_id();

		for ( $i = 1;$i <= 4;$i++ ) {

			$adposition       = '';
			$paragraph_number = '';
			$post_title       = '';

			$data_group_array['group-0'] = array(
				'data_array' => array(
					array(
						'key_1' => 'post_type',
						'key_2' => 'equal',
						'key_3' => 'post',
					),
				),
			);
			if ( isset( $amp_options[ 'ampforwp-advertisement-type-incontent-ad-' . $i ] ) ) {
				switch ( $amp_options[ 'ampforwp-advertisement-type-incontent-ad-' . $i ] ) {
					case 1: // Adsense
						$post_title = 'Adsense Normal Ad ' . $i . '(Migrated from Advanced AMP Ads)';
						if ( $amp_options[ 'ampforwp-adsense-ad-position-incontent-ad-' . $i ] == '50-percent' ) {
							$adposition = '50_of_the_content';
						} elseif ( $amp_options[ 'ampforwp-adsense-ad-position-incontent-ad-' . $i ] == 'custom' ) {
							$adposition       = 'number_of_paragraph';
							$paragraph_number = $amp_options[ 'ampforwp-custom-adsense-ad-position-incontent-ad-' . $i ];
						} else {
							$adposition       = 'number_of_paragraph';
							$paragraph_number = $amp_options[ 'ampforwp-adsense-ad-position-incontent-ad-' . $i ];
						}
						$adforwp_meta_key = array(
							'select_adtype'    => 'adsense',
							'adsense_type'     => 'normal',
							'data_client_id'   => $amp_options[ 'ampforwp-adsense-ad-data-ad-client-incontent-ad-' . $i ],
							'data_ad_slot'     => $amp_options[ 'ampforwp-adsense-ad-data-ad-slot-incontent-ad-' . $i ],
							'banner_size'      => $amp_options[ 'ampforwp-adsense-ad-width-incontent-ad-' . $i ] . 'x' . $amp_options[ 'ampforwp-adsense-ad-height-incontent-ad-' . $i ],
							'wheretodisplay'   => 'between_the_content',
							'adposition'       => $adposition,
							'paragraph_number' => $paragraph_number,
							'ads_for_wp_non_amp_visibility' => 'hide',
							'imported_from'    => 'ampforwp_advanced_ads',
							'data_group_array' => $data_group_array,
						);

						break;

					case 3: // Custom Advertisement
						$post_title = 'Custom Ad ' . $i . '(Migrated from Advanced AMP Ads)';
						if ( $amp_options[ 'ampforwp-custom-ads-ad-position-incontent-ad-' . $i ] == '50-percent' ) {
							$adposition = '50_of_the_content';
						} elseif ( $amp_options[ 'ampforwp-custom-ads-ad-position-incontent-ad-' . $i ] == 'custom' ) {
							$adposition       = 'number_of_paragraph';
							$paragraph_number = $amp_options[ 'ampforwp-custom-custom-ads-ad-position-incontent-ad-' . $i ];
						} else {
							$adposition       = 'number_of_paragraph';
							$paragraph_number = $amp_options[ 'ampforwp-custom-ads-ad-position-incontent-ad-' . $i ];
						}
						$adforwp_meta_key = array(
							'select_adtype'    => 'custom',
							'wheretodisplay'   => 'between_the_content',
							'adposition'       => $adposition,
							'paragraph_number' => $paragraph_number,
							'ads_for_wp_non_amp_visibility' => 'hide',
							'custom_code'      => $amp_options[ 'ampforwp-custom-advertisement-incontent-ad-' . $i ],
							'imported_from'    => 'ampforwp_advanced_ads',
							'data_group_array' => $data_group_array,
						);
						break;

					default:
						break;
				}
				$ads_post = array(
					'post_author' => $user_id,
					'post_title'  => $post_title,
					'post_status' => 'publish',
					'post_name'   => $post_title,
					'post_type'   => 'adsforwp',

				);
			}
			if ( $amp_options[ 'ampforwp-advertisement-type-incontent-ad-' . $i ] != 2 ) {

				$post_id = wp_insert_post( $ads_post );

				foreach ( $adforwp_meta_key as $key => $val ) {

						$result[] = update_post_meta( $post_id, $key, $val );

				}
			}
		}

		return $result;
	}

	public function adsforwp_migrate_advanced_amp_ads_after_feature() {

		if ( ! current_user_can( 'manage_options' ) ) {
					return;
		}

		if ( ! isset( $_GET['adsforwp_security_nonce'] ) ) {
			return;
		}
		// phpcs:ignore WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized -- Reason Validating nonce so sanitization not needed
		if ( ! wp_verify_nonce( $_GET['adsforwp_security_nonce'], 'adsforwp_ajax_check_nonce' ) ) {
			return;
		}

		$result           = array();
		$adforwp_meta_key = array();
		$amp_options      = get_option( 'redux_builder_amp' );
		$user_id          = get_current_user_id();

		if ( isset( $amp_options['ampforwp-after-featured-image-ad-type'] ) ) {

			$ads_post = array(
				'post_author' => $user_id,
				'post_title'  => 'After Featured Image (Migrated from Advanced AMP Ads)',
				'post_status' => 'publish',
				'post_name'   => 'After Featured Image (Migrated from Advanced AMP Ads)',
				'post_type'   => 'adsforwp',
			);

			$post_id = wp_insert_post( $ads_post );

			$data_group_array['group-0'] = array(
				'data_array' => array(
					array(
						'key_1' => 'post_type',
						'key_2' => 'equal',
						'key_3' => 'post',
					),
				),
			);

			switch ( $amp_options['ampforwp-after-featured-image-ad-type'] ) {
				case 1:
					$adforwp_meta_key = array(
						'select_adtype'                 => 'adsense',
						'adsense_type'                  => 'normal',
						'data_client_id'                => $amp_options['ampforwp-after-featured-image-ad-type-1-data-ad-client'],
						'data_ad_slot'                  => $amp_options['ampforwp-after-featured-image-ad-type-1-data-ad-slot'],
						'banner_size'                   => $amp_options['ampforwp-after-featured-image-ad-type-1-width'] . 'x' . $amp_options['ampforwp-after-featured-image-ad-type-1-height'],
						'wheretodisplay'                => 'between_the_content',
						'ads_for_wp_non_amp_visibility' => 'hide',
						'wheretodisplay'                => 'adsforwp_after_featured_image',
						'imported_from'                 => 'ampforwp_advanced_ads',
						'data_group_array'              => $data_group_array,
					);
					break;
				case 2:
					$adforwp_meta_key = array(
						'select_adtype'                 => 'custom',
						'wheretodisplay'                => 'between_the_content',
						'wheretodisplay'                => 'adsforwp_after_featured_image',
						'ads_for_wp_non_amp_visibility' => 'hide',
						'custom_code'                   => $amp_options['ampforwp-after-featured-image-ad-custom-advertisement'],
						'imported_from'                 => 'ampforwp_advanced_ads',
						'data_group_array'              => $data_group_array,
					);

					break;

				default:
					break;
			}

			foreach ( $adforwp_meta_key as $key => $val ) {

						$result[] = update_post_meta( $post_id, $key, $val );

			}
		}

		return $result;
	}
	public function adsforwp_migrate_advanced_amp_ads_inloop() {

		if ( ! current_user_can( 'manage_options' ) ) {
					return;
		}

		if ( ! isset( $_GET['adsforwp_security_nonce'] ) ) {
			return;
		}
		// phpcs:ignore WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized -- Reason Validating nonce so sanitization not needed
		if ( ! wp_verify_nonce( $_GET['adsforwp_security_nonce'], 'adsforwp_ajax_check_nonce' ) ) {
			return;
		}

		$result           = array();
		$adforwp_meta_key = array();
		$amp_options      = get_option( 'redux_builder_amp' );
		$user_id          = get_current_user_id();

		if ( isset( $amp_options['ampforwp-inbetween-loop'] ) ) {

			$ads_post = array(
				'post_author' => $user_id,
				'post_title'  => 'In Loop Ad (Migrated from Advanced AMP Ads)',
				'post_status' => 'publish',
				'post_name'   => 'In Loop Ad (Migrated from Advanced AMP Ads)',
				'post_type'   => 'adsforwp',

			);

			$post_id                     = wp_insert_post( $ads_post );
			$data_group_array['group-0'] = array(
				'data_array' => array(
					array(
						'key_1' => 'post_type',
						'key_2' => 'equal',
						'key_3' => 'post',
					),
				),
			);

			switch ( $amp_options['ampforwp-inbetween-type'] ) {
				case 1:
					$adforwp_meta_key = array(
						'select_adtype'                 => 'adsense',
						'adsense_type'                  => 'normal',
						'data_client_id'                => $amp_options['ampforwp-inbetween-adsense-ad-data-ad-client'],
						'data_ad_slot'                  => $amp_options['ampforwp-inbetween-adsense-ad-data-ad-slot'],
						'banner_size'                   => $amp_options['ampforwp-inbetween-adsense-ad-width'] . 'x' . $amp_options['ampforwp-inbetween-adsense-ad-height'],
						'wheretodisplay'                => 'between_the_content',
						'wheretodisplay'                => 'adsforwp_ads_in_loops',
						'adsforwp_after_how_many_post'  => $amp_options['ampforwp-inbetween-loop-post-num'],
						'ads_for_wp_non_amp_visibility' => 'hide',
						'imported_from'                 => 'ampforwp_advanced_ads',
						'data_group_array'              => $data_group_array,
					);
					break;
				case 2:
					$adforwp_meta_key = array(
						'select_adtype'                 => 'custom',
						'wheretodisplay'                => 'between_the_content',
						'wheretodisplay'                => 'adsforwp_ads_in_loops',
						'custom_code'                   => $amp_options['ampforwp-inbetween-custom-advertisement'],
						'ads_for_wp_non_amp_visibility' => 'hide',
						'imported_from'                 => 'ampforwp_advanced_ads',
						'data_group_array'              => $data_group_array,
					);

					break;

				default:
					break;
			}

			foreach ( $adforwp_meta_key as $key => $val ) {

					$result[] = update_post_meta( $post_id, $key, $val );

			}
		}
		return $result;
	}
	public function adsforwp_migrate_advanced_amp_ads_standard() {

		if ( ! current_user_can( 'manage_options' ) ) {
					return;
		}

		if ( ! isset( $_GET['adsforwp_security_nonce'] ) ) {
			return;
		}
		// phpcs:ignore WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized -- Reason Validating nonce so sanitization not needed
		if ( ! wp_verify_nonce( $_GET['adsforwp_security_nonce'], 'adsforwp_ajax_check_nonce' ) ) {
			return;
		}

		$result           = array();
		$adforwp_meta_key = array();
		$amp_options      = get_option( 'redux_builder_amp' );
		$user_id          = get_current_user_id();

		$placement_position = array(
			'1' => 'adsforwp_below_the_header',
			'2' => 'adsforwp_below_the_footer',
			'3' => 'adsforwp_above_the_post_content',
			'4' => 'adsforwp_below_the_post_content',
			'5' => 'adsforwp_below_the_title',
			'6' => 'adsforwp_above_related_post',
			'7' => 'adsforwp_below_author_box',
		);

		for ( $i = 1;$i <= 7;$i++ ) {

			$post_title                  = '';
			$data_group_array['group-0'] = array(
				'data_array' => array(
					array(
						'key_1' => 'post_type',
						'key_2' => 'equal',
						'key_3' => 'post',
					),
				),
			);
			if ( isset( $amp_options[ 'ampforwp-standard-ads-' . $i ] ) ) {

				switch ( $amp_options[ 'ampforwp-advertisement-type-standard-' . $i ] ) {

					case 1: // Adsense
						$post_title = 'Adsense Normal Ad ' . $i . '(Migrated from Advanced AMP Ads)';

						$adforwp_meta_key = array(
							'select_adtype'    => 'adsense',
							'adsense_type'     => 'normal',
							'data_client_id'   => $amp_options[ 'ampforwp-adsense-ad-data-ad-client-standard-' . $i ],
							'data_ad_slot'     => $amp_options[ 'ampforwp-adsense-ad-data-ad-slot-standard-' . $i ],
							'banner_size'      => $amp_options[ 'ampforwp-adsense-ad-width-standard-' . $i ] . 'x' . $amp_options[ 'ampforwp-adsense-ad-height-standard-' . $i ],
							'wheretodisplay'   => 'between_the_content',
							'wheretodisplay'   => $placement_position[ $i ],
							'ads_for_wp_non_amp_visibility' => 'hide',
							'imported_from'    => 'ampforwp_advanced_ads',
							'data_group_array' => $data_group_array,
						);

						break;

					case 3: // Custom Advertisement
						$post_title = 'Custom Ad ' . $i . '(Migrated from Advanced AMP Ads)';

						$adforwp_meta_key = array(
							'select_adtype'    => 'custom',
							'wheretodisplay'   => 'between_the_content',
							'wheretodisplay'   => $placement_position[ $i ],
							'custom_code'      => $amp_options[ 'ampforwp-custom-advertisement-standard-' . $i ],
							'ads_for_wp_non_amp_visibility' => 'hide',
							'imported_from'    => 'ampforwp_advanced_ads',
							'data_group_array' => $data_group_array,
						);
						break;
					default:
						break;
				}
					$ads_post = array(
						'post_author' => $user_id,
						'post_title'  => $post_title,
						'post_status' => 'publish',
						'post_name'   => $post_title,
						'post_type'   => 'adsforwp',

					);
			}

			if ( $amp_options[ 'ampforwp-advertisement-type-standard-' . $i ] != 2 ) {

				$post_id = wp_insert_post( $ads_post );

				foreach ( $adforwp_meta_key as $key => $val ) {

					$result[] = update_post_meta( $post_id, $key, $val );

				}
			}
		}
			return $result;
	}
	public function adsforwp_import_all_amp_ads() {

		if ( ! current_user_can( 'manage_options' ) ) {
					return;
		}

		if ( ! isset( $_GET['adsforwp_security_nonce'] ) ) {
			return;
		}
		// phpcs:ignore WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized -- Reason Validating nonce so sanitization not needed
		if ( ! wp_verify_nonce( $_GET['adsforwp_security_nonce'], 'adsforwp_ajax_check_nonce' ) ) {
			return;
		}
			global $wpdb;
            //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need to run direct query to start transaction
				$wpdb->query( 'START TRANSACTION' );
				$result = array();
				$result = $this->adsforwp_migrate_ampforwp_ads();
		if ( is_wp_error( $result ) ) {
			echo wp_kses_post( $result->get_error_message() );
          //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need to run direct query to rollback transaction           
			$wpdb->query( 'ROLLBACK' );
		} else {
          //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need to run direct query to commit transaction
			$wpdb->query( 'COMMIT' );
			return $result;
		}
	}
	public function adsforwp_import_all_advanced_amp_ads() {

		if ( ! current_user_can( 'manage_options' ) ) {
					return;
		}

		if ( ! isset( $_GET['adsforwp_security_nonce'] ) ) {
			return;
		}
		// phpcs:ignore WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized -- Reason Validating nonce so sanitization not needed
		if ( ! wp_verify_nonce( $_GET['adsforwp_security_nonce'], 'adsforwp_ajax_check_nonce' ) ) {
			return;
		}

			global $wpdb;
            //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need to run direct query to start transaction
			$wpdb->query( 'START TRANSACTION' );
				$result = array();

				$result[] = $this->adsforwp_migrate_advanced_auto_ads();

				$result[] = $this->adsforwp_migrate_advanced_amp_ads_incontent();

				$result[] = $this->adsforwp_migrate_advanced_amp_ads_after_feature();

				$result[] = $this->adsforwp_migrate_advanced_amp_ads_standard();

				$result[] = $this->adsforwp_migrate_advanced_amp_ads_inloop();
		if ( is_wp_error( $result ) ) {
			echo wp_kses_post( $result->get_error_message() );
          //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need to run direct query to rollback transaction             
			$wpdb->query( 'ROLLBACK' );
		} else {
          //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need to run direct query to commit transaction
			$wpdb->query( 'COMMIT' );
			return $result;
		}
	}

	public function adsforwp_import_all_ad_inserter_ads() {

		if ( ! current_user_can( 'manage_options' ) ) {
					return;
		}

		if ( ! isset( $_GET['adsforwp_security_nonce'] ) ) {
			return;
		}
		// phpcs:ignore WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized -- Reason Validating nonce so sanitization not needed
		if ( ! wp_verify_nonce( $_GET['adsforwp_security_nonce'], 'adsforwp_ajax_check_nonce' ) ) {
			return;
		}

			global $wpdb;
            //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need to run direct query to start transaction
			$wpdb->query( 'START TRANSACTION' );
			$result  = array();
			$user_id = get_current_user_id();
			global $block_object;

		if ( is_array( $block_object ) ) {

			$i = 0;
			foreach ( $block_object as $object ) {

				$wp_options = $object->wp_options;

				$ad_code = $wp_options['code'];

				if ( $ad_code != '' ) {

					$ads_post = array(
						'post_author' => $user_id,
						'post_title'  => 'Custom Ad ' . $i . ' (Migrated from Ad Inserter)',
						'post_status' => 'publish',
						'post_name'   => 'Custom Ad ' . $i . ' (Migrated from Ad Inserter)',
						'post_type'   => 'adsforwp',

					);

					$post_id = wp_insert_post( $ads_post );

					$wheretodisplay = '';
					$ad_align       = '';
					$pragraph_no    = '';
					$adposition     = '';

					if ( $wp_options['display_type'] == 3 || $wp_options['display_type'] == 1 ) {
						$wheretodisplay = 'before_the_content';
					} elseif ( $wp_options['display_type'] == 4 || $wp_options['display_type'] == 2 ) {
						$wheretodisplay = 'after_the_content';
					} elseif ( $wp_options['display_type'] == 5 ) {
						$wheretodisplay = 'between_the_content';
						$pragraph_no    = $wp_options['paragraph_number'];
						$adposition     = 'number_of_paragraph';
					}

					if ( $wp_options['alignment_type'] == 1 ) {
						$ad_align = 'left';
					} elseif ( $wp_options['alignment_type'] == 2 ) {
						$ad_align = 'right';
					} elseif ( $wp_options['alignment_type'] == 3 ) {
						$ad_align = 'center';
					}

					$data_group_array['group-0'] = array(
						'data_array' => array(
							array(
								'key_1' => 'show_globally',
								'key_2' => 'equal',
								'key_3' => 'post',
							),
						),
					);

					$adforwp_meta_key = array(
						'select_adtype'     => 'custom',
						'custom_code'       => $ad_code,
						'adposition'        => $adposition,
						'paragraph_number'  => $pragraph_no,
						'adsforwp_ad_align' => $ad_align,
						'imported_from'     => 'ad_inserter',
						'wheretodisplay'    => $wheretodisplay,
						'data_group_array'  => $data_group_array,
					);

					foreach ( $adforwp_meta_key as $key => $val ) {

						$result[] = update_post_meta( $post_id, $key, $val );

					}
				}

				++$i;
			}
		}

		if ( is_wp_error( $result ) ) {
			echo wp_kses_post( $result->get_error_message() );
          //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need to run direct query to rollback transaction              
			$wpdb->query( 'ROLLBACK' );
		} else {
          //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need to run direct query to commit transaction
			$wpdb->query( 'COMMIT' );
			return $result;
		}
	}

	public function adsforwp_import_all_quick_adsense_ads() {
		if ( ! current_user_can( 'manage_options' ) ) {
						return;
		}

		if ( ! isset( $_GET['adsforwp_security_nonce'] ) ) {
			return;
		}
		// phpcs:ignore WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized -- Reason Validating nonce so sanitization not needed
		if ( ! wp_verify_nonce( $_GET['adsforwp_security_nonce'], 'adsforwp_ajax_check_nonce' ) ) {
			return;
		}

			global $wpdb;
            //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need to run direct query to start transaction
			$wpdb->query( 'START TRANSACTION' );
			$result  = array();
			$user_id = get_current_user_id();
			global $quickAdsenseAdsDisplayed;
			global $ampfowpAdsenseAdsId;
			global $quickAdsenseBeginEnd;
			$ampfowpAdsenseAdsId = array();
			$settings            = get_option( 'quick_adsense_settings' );

		for ( $i = 1; $i <= 10; $i++ ) {
			if ( isset( $settings[ 'onpost_ad_' . $i . '_content' ] ) && ! empty( $settings[ 'onpost_ad_' . $i . '_content' ] ) ) {
				$ads_post = array(
					'post_author' => $user_id,
					'post_title'  => 'Custom Ad ' . $i . ' (Migrated from Quick Adsense)',
					'post_status' => 'publish',
					'post_name'   => 'Custom Ad ' . $i . ' (Migrated from Quick Adsense)',
					'post_type'   => 'adsforwp',

				);
				$post_id       = wp_insert_post( $ads_post );
				$ads_content   = $settings[ 'onpost_ad_' . $i . '_content' ];
				$ads_alignment = $settings[ 'onpost_ad_' . $i . '_alignment' ];
				$ads_margin    = $settings[ 'onpost_ad_' . $i . '_margin' ];

					$wheretodisplay = '';
					$ad_align       = '';
					$pragraph_no    = '';
					$adposition     = '';

				if ( $ads_alignment == 1 ) {
					$ad_align = 'left';
					if ( ! empty( $ads_margin ) ) {
						$ads_align_margin = array(
							'ad_margin_top'    => $ads_margin,
							'ad_margin_bottom' => $ads_margin,
							'ad_margin_left'   => 0,
							'ad_margin_right'  => $ads_margin,
						);
					}
				} elseif ( $ads_alignment == 2 ) {
					$ad_align = 'center';
					if ( ! empty( $ads_margin ) ) {
						$ads_align_margin = array(
							'ad_margin_top'    => $ads_margin,
							'ad_margin_bottom' => $ads_margin,
							'ad_margin_left'   => 0,
							'ad_margin_right'  => 0,
						);
					}
				} elseif ( $ads_alignment == 3 ) {
					$ad_align = 'right';
					if ( ! empty( $ads_margin ) ) {
							$ads_align_margin = array(
								'ad_margin_top'    => $ads_margin,
								'ad_margin_bottom' => $ads_margin,
								'ad_margin_left'   => $ads_margin,
								'ad_margin_right'  => 0,
							);
					}
				} elseif ( $ads_alignment == 4 ) {
					$ad_align = 'none';
					if ( ! empty( $ads_margin ) ) {
								$ads_align_margin = array(
									'ad_margin_top'    => 0,
									'ad_margin_bottom' => 0,
									'ad_margin_left'   => 0,
									'ad_margin_right'  => 0,
								);
					}
				}
				if ( isset( $settings['enable_on_posts'] ) && $settings['enable_on_posts'] == 1 ) {
					$data_group_array['group-0'] = array(
						'data_array' => array(
							array(
								'key_1' => 'post_type',
								'key_2' => 'equal',
								'key_3' => 'post',
							),
						),
					);
				}
				if ( isset( $settings['enable_on_pages'] ) && $settings['enable_on_pages'] == 1 ) {
					$data_group_array['group-1'] = array(
						'data_array' => array(
							array(
								'key_1' => 'post_type',
								'key_2' => 'equal',
								'key_3' => 'page',
							),
						),
					);
				}

					// enable_position_before_last_para, ad_before_last_para

				if ( $settings['ad_beginning_of_post'] == $i ) {
					if ( $settings['enable_position_beginning_of_post'] == 1 ) {
						$wheretodisplay = 'before_the_content';
					}
				} elseif ( $settings['ad_end_of_post'] == $i ) {
					if ( $settings['enable_position_end_of_post'] == 1 ) {
							$wheretodisplay = 'after_the_content';
					}
				} elseif ( $settings['ad_middle_of_post'] == $i ) {
					if ( $settings['enable_position_middle_of_post'] == 1 ) {
							$wheretodisplay = 'between_the_content';
					}
				}

				for ( $j = 1; $j <= 3; $j++ ) {
					if ( $settings[ 'ad_after_para_option_' . $j ] == $i ) {
						if ( $settings[ 'enable_position_after_para_option_' . $j ] == 1 ) {
							$wheretodisplay   = 'between_the_content';
							$numberofparas    = 'number_of_paragraph';
							$display_tag_name = 'p_tag';
							$paragraph_number = $settings[ 'position_after_para_option_' . $j ];
							if ( $settings[ 'enable_jump_position_after_para_option_' . $j ] == 1 ) {
								$ads_on_every_paras = 1;
							}
						} elseif ( $settings[ 'enable_position_after_image_option_' . $j ] == 1 ) {
							$wheretodisplay   = 'between_the_content';
							$numberofparas    = 'number_of_paragraph';
							$display_tag_name = 'img_tag';
							$paragraph_number = $settings[ 'position_after_para_option_' . $j ];
							if ( $settings[ 'enable_jump_position_after_para_option_' . $j ] == 1 ) {
									$ads_on_every_paras = 1;
							}
						}
					}
				}

					// enable_on_posts
					// enable_on_pages
					// enable_on_homepage
					$adforwp_meta_key = array(
						'select_adtype'                  => 'custom',
						'custom_code'                    => $ads_content,
						'adposition'                     => $adposition,
						'paragraph_number'               => $pragraph_no,
						'adsforwp_ad_align'              => $ad_align,
						'adsforwp_ad_margin'             => $ads_align_margin,
						'imported_from'                  => 'quick_adsense',
						'wheretodisplay'                 => $wheretodisplay,
						'display_tag_name'               => $display_tag_name,
						'adposition'                     => $numberofparas,
						'paragraph_number'               => $paragraph_number,
						'ads_on_every_paragraphs_number' => $ads_on_every_paras,
						'data_group_array'               => $data_group_array,
					);

					foreach ( $adforwp_meta_key as $key => $val ) {
						$result[] = update_post_meta( $post_id, $key, $val );
					}
			}
		}
		for ( $i = 1; $i <= 10; $i++ ) {
			if ( isset( $settings[ 'widget_ad_' . $i . '_content' ] ) && ! empty( $settings[ 'widget_ad_' . $i . '_content' ] ) ) {
				$ads_post = array(
					'post_author' => $user_id,
					'post_title'  => 'Custom widget Ad ' . $i . ' (Migrated from Quick Adsense)',
					'post_status' => 'publish',
					'post_name'   => 'Custom widget Ad ' . $i . ' (Migrated from Quick Adsense)',
					'post_type'   => 'adsforwp',

				);
				$post_id       = wp_insert_post( $ads_post );
				$ads_content   = $settings[ 'widget_ad_' . $i . '_content' ];
				$ads_alignment = $settings[ 'onpost_ad_' . $i . '_alignment' ];
				$ads_margin    = $settings[ 'onpost_ad_' . $i . '_margin' ];

					$wheretodisplay = '';
					$ad_align       = '';
					$pragraph_no    = '';
					$adposition     = '';

				if ( $ads_alignment == 1 ) {
					$ad_align = 'left';
					if ( ! empty( $ads_margin ) ) {
						$ads_align_margin = array(
							'ad_margin_top'    => $ads_margin,
							'ad_margin_bottom' => $ads_margin,
							'ad_margin_left'   => 0,
							'ad_margin_right'  => $ads_margin,
						);
					}
				} elseif ( $ads_alignment == 2 ) {
					$ad_align = 'center';
					if ( ! empty( $ads_margin ) ) {
						$ads_align_margin = array(
							'ad_margin_top'    => $ads_margin,
							'ad_margin_bottom' => $ads_margin,
							'ad_margin_left'   => 0,
							'ad_margin_right'  => 0,
						);
					}
				} elseif ( $ads_alignment == 3 ) {
					$ad_align = 'right';
					if ( ! empty( $ads_margin ) ) {
								$ads_align_margin = array(
									'ad_margin_top'    => $ads_margin,
									'ad_margin_bottom' => $ads_margin,
									'ad_margin_left'   => $ads_margin,
									'ad_margin_right'  => 0,
								);
					}
				} elseif ( $ads_alignment == 4 ) {
					$ad_align = 'none';
					if ( ! empty( $ads_margin ) ) {
									$ads_align_margin = array(
										'ad_margin_top'    => 0,
										'ad_margin_bottom' => 0,
										'ad_margin_left'   => 0,
										'ad_margin_right'  => 0,
									);
					}
				}

					$data_group_array['group-0'] = array(
						'data_array' => array(
							array(
								'key_1' => 'show_globally',
								'key_2' => 'equal',
								'key_3' => 'post',
							),
						),
					);

					$adforwp_meta_key = array(
						'select_adtype'     => 'custom',
						'custom_code'       => $ads_content,
						'adposition'        => $adposition,
						'paragraph_number'  => $pragraph_no,
						'adsforwp_ad_align' => $ad_align,
						'imported_from'     => 'quick_adsense',
						'wheretodisplay'    => $wheretodisplay,
						'data_group_array'  => $data_group_array,
					);

					foreach ( $adforwp_meta_key as $key => $val ) {
						$result[] = update_post_meta( $post_id, $key, $val );
					}
			}
		}
			// die;
		if ( is_wp_error( $result ) ) {
			echo wp_kses_post( $result->get_error_message() );
            //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need to run direct query to rollback transaction              
			$wpdb->query( 'ROLLBACK' );
		} else {
            //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: We need to run direct query to commit transaction
			$wpdb->query( 'COMMIT' );
			return $result;
		}
	}
	/**
	 * We are here importing all fetched groups from advanced ads to adsforwp plugin
	 *
	 * @param type $advads_groups
	 */
	public function adsforwp_import_all_advanced_groups( $advads_groups ) {

		if ( ! current_user_can( 'manage_options' ) ) {
					return;
		}

		if ( ! isset( $_GET['adsforwp_security_nonce'] ) ) {
			return;
		}
		// phpcs:ignore WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized -- Reason Validating nonce so sanitization not needed
		if ( ! wp_verify_nonce( $_GET['adsforwp_security_nonce'], 'adsforwp_ajax_check_nonce' ) ) {
			return;
		}

			$user_id = get_current_user_id();

			global $wp_version;

		if ( version_compare( $wp_version, '4.5.0', '<' ) ) {
			// For WordPress versions earlier than 4.5.0
            //phpcs:ignore WordPress.WP.DeprecatedParameters.Get_termsParam2Found -- Reason : added for old wordpress support
			$terms = get_terms(
				'advanced_ads_groups',
				array(
					'hide_empty' => false,
				)
			);
		} else {
			// For WordPress 4.5.0 and later versions
			$terms = get_terms(
				array(
					'taxonomy'   => 'advanced_ads_groups',
					'hide_empty' => false,
				)
			);
		}

			$groups_extra_attr = get_option( 'advads-ad-groups', array() );

		foreach ( $terms as $term ) {

			$group_post = array(
				'user_ID'     => $user_id,
				'post_author' => $user_id,
				'post_title'  => $term->name,
				'post_status' => 'publish',
				'post_name'   => $term->name,
				'post_type'   => 'adsforwp-groups',

			);

				$group_post_id = wp_insert_post( $group_post );

				$adforwp_group_meta_key = array(
					'imported_from' => 'advance_ads',
				);

				if ( $groups_extra_attr[ $term->term_id ]['type'] == 'default' ) {
					$adforwp_group_meta_key['adsforwp_group_type'] = 'rand';
				} else {
					$adforwp_group_meta_key['adsforwp_group_type'] = 'ordered';
				}

				if ( $groups_extra_attr[ $term->term_id ]['options']['refresh']['enabled'] ) {
					$adforwp_group_meta_key['adsforwp_refresh_type']           = 'on_interval';
					$adforwp_group_meta_key['adsforwp_group_ref_interval_sec'] = $groups_extra_attr[ $term->term_id ]['options']['refresh']['interval'];
				} else {
					$adforwp_group_meta_key['adsforwp_refresh_type'] = 'on_load';
				}
				$store_ads_id  = $advads_groups[ $term->term_id ];
				$ads_forwp_ads = array();

				foreach ( $store_ads_id as $id ) {

					$title                = get_the_title( $id );
					$ads_forwp_ads[ $id ] = $title;

				}
				$adforwp_group_meta_key['adsforwp_ads'] = $ads_forwp_ads;

				foreach ( $adforwp_group_meta_key as $key => $val ) {

					update_post_meta( $group_post_id, $key, $val );

				}
		}
	}

	/**
	 * We are here fetching all ads post from adsforwp post type
	 *
	 * @return type
	 */
	public function adsforwp_fetch_all_ads() {

			$all_ads           = array();
			$all_ads_transient = json_decode( get_transient( 'transient_all_afw_ads_data' ) );
			$all_ads           = $all_ads_transient;

		if ( empty( $all_ads_transient ) ) {

			$all_ads = get_posts(
				array(
					'post_type'      => 'adsforwp',
					'posts_per_page' => -1,
					'post_status'    => 'publish',
				)
			);

			set_transient( 'transient_all_afw_ads_data', wp_json_encode( $all_ads ), 60 );

		}
		return $all_ads;
	}
	/**
	 * we are here fetching all ads post meta for adsforwp post type
	 *
	 * @return type
	 */
	public function adsforwp_fetch_all_ads_post_meta() {

		$all_ads_post_meta = array();
		$all_ads           = $this->adsforwp_fetch_all_ads();

		foreach ( $all_ads as $ad ) {

			$all_ads_post_meta[ $ad->ID ] = get_post_meta( $ad->ID, $key = '', true );

		}

		return $all_ads_post_meta;
	}
	/**
	 * We are here fetching all ads groups post from adsforwp-grops post type
	 *
	 * @return type
	 */
	public function adsforwp_fetch_all_groups() {

		$all_groups           = array();
		$all_groups_transient = json_decode( get_transient( 'transient_all_groups_data' ) );
		$all_groups           = $all_groups_transient;

		if ( empty( $all_groups_transient ) ) {

			$all_groups = get_posts(
				array(
					'post_type'      => 'adsforwp-groups',
					'posts_per_page' => -1,
					'post_status'    => 'publish',
				)
			);

			set_transient( 'transient_all_groups_data', wp_json_encode( $all_groups ), 60 );
		}

		return $all_groups;
	}
	/**
	 * we are here fetching all ads groups post meta for adsforwp-groups post type
	 *
	 * @return type
	 */
	public function adsforwp_fetch_all_groups_post_meta() {

		$all_groups_post_meta = array();
		$all_groups           = $this->adsforwp_fetch_all_groups();

		foreach ( $all_groups as $group ) {

				$all_groups_post_meta[ $group->ID ] = get_post_meta( $group->ID, $key = '', true );

		}

		return $all_groups_post_meta;
	}
	/**
	 * We are checking ad if it is added in group or not
	 *
	 * @param  type $ad_id
	 * @return type
	 */
	public function adsforwp_check_ads_in_group( $ad_id ) {

				$all_groups   = adsforwp_get_group_ad_ids();
				$meta_value   = array();
				$ad_group_ids = array();

		if ( $all_groups ) {

			foreach ( $all_groups as $groups_id ) {

				$meta_value = get_post_meta( $groups_id, $key = 'adsforwp_ads', true );

				if ( $meta_value ) {

					if ( in_array( $ad_id, array_keys( $meta_value ) ) ) {

							$ad_group_ids[] = $groups_id;

					}
				}
			}
		}

			return $ad_group_ids;
	}

	/**
	 * Function to expand html tags form allowed html tags in WordPress
	 *
	 * @return array
	 */
	public function adsforwp_expanded_allowed_tags() {

			$my_allowed = wp_kses_allowed_html( 'post' );
			// form fields - input
			$my_allowed['input'] = array(
				'class'         => array(),
				'id'            => array(),
				'name'          => array(),
				'value'         => array(),
				'type'          => array(),
				'style'         => array(),
				'placeholder'   => array(),
				'maxlength'     => array(),
				'checked'       => array(),
				'readonly'      => array(),
				'disabled'      => array(),
				'width'         => array(),
				'data-id'       => array(),
				'media-id'      => array(),
				'provider_type' => array(),

			);
			// number
			$my_allowed['number'] = array(

				'class' => array(),
				'id'    => array(),
				'name'  => array(),
				'value' => array(),
				'type'  => array(),
				'style' => array(),
				'width' => array(),

			);
			// textarea
			$my_allowed['textarea'] = array(
				'class' => array(),
				'id'    => array(),
				'name'  => array(),
				'value' => array(),
				'type'  => array(),
				'style' => array(),
				'rows'  => array(),
			);
			// amp tag
			$my_allowed['amp-ad']         = array(
				'class'                    => array(),
				'width'                    => array(),
				'height'                   => array(),
				'type'                     => array(),
				'data-slot'                => array(),
				'data-ad-client'           => array(),
				'data-ad-slot'             => array(),
				'data-tagtype'             => array(),
				'data-cid'                 => array(),
				'data-crid'                => array(),
				'data-mid'                 => array(),
				'data-block-id'            => array(),
				'data-html-access-allowed' => array(),
				'data-property'            => array(),
				'data-zone'                => array(),
				'data-json'                => array(),
				'fallback'                 => array(),
			);
			$my_allowed['amp-pixel']      = array(
				'src'    => array(),
				'layout' => array(),
			);
			$my_allowed['amp-embed']      = array(
				'class'            => array(),
				'width'            => array(),
				'height'           => array(),
				'heights'          => array(),
				'type'             => array(),
				'layout'           => array(),
				'data-publisher'   => array(),
				'data-mode'        => array(),
				'data-placement'   => array(),
				'data-target_type' => array(),
				'data-article'     => array(),
				'data-url'         => array(),
				'data-widgetids'   => array(),
				'data-publisherid' => array(),
				'data-websiteid'   => array(),
			);
			$my_allowed['amp-img']        = array(
				'class'    => array(),
				'id'       => array(),
				'width'    => array(),
				'height'   => array(),
				'type'     => array(),
				'src'      => array(),
				'on'       => array(),
				'role'     => array(),
				'tabindex' => array(),
				'layout'   => array(),
			);
			$my_allowed['amp-ad-exit']    = array(
				'id' => array(),
			);
			$my_allowed['amp-auto-ads']   = array(
				'type'           => array(),
				'id'             => array(),
				'data-ad-client' => array(),
				'height'         => array(),
				'width'          => array(),
			);
			$my_allowed['amp-sticky-ad']  = array(
				'layout' => array(),
				'id'     => array(),
			);
			$my_allowed['amp-list']       = array(
				'width'  => array(),
				'height' => array(),
				'layout' => array(),
				'src'    => array(),
				'width'  => array(),
				'id'     => array(),
			);
			$my_allowed['amp-live-list']  = array(
				'data-max-items-per-page' => array(),
				'data-poll-interval'      => array(),
				'id'                      => array(),
			);
			$my_allowed['amp-app-banner'] = array(
				'layout' => array(),
				'id'     => array(),
			);
			$my_allowed['amp-carousel']   = array(
				'width'                           => array(),
				'height'                          => array(),
				'id'                              => array(),
				'layout'                          => array(),
				'type'                            => array(),
				'data-next-button-aria-label'     => array(),
				'data-previous-button-aria-label' => array(),
				'delay'                           => array(),
				'loop'                            => array(),
				'autoplay'                        => array(),
				'controls'                        => array(),

			);
			$my_allowed['amp-iframe']         = array(
				'width'       => array(),
				'height'      => array(),
				'sandbox'     => array(),
				'layout'      => array(),
				'frameborder' => array(),
				'src'         => array(),
				'id'          => array(),
			);
			$my_allowed['amp-image-lightbox'] = array(
				'layout' => array(),
				'height' => array(),
				'id'     => array(),
			);
			$my_allowed['amp-layout']         = array(
				'layout' => array(),
				'width'  => array(),
				'height' => array(),
				'id'     => array(),
			);
			$my_allowed['amp-3d-gltf']        = array(
				'layout'       => array(),
				'width'        => array(),
				'height'       => array(),
				'id'           => array(),
				'antialiasing' => array(),
				'src'          => array(),
			);
			$my_allowed['amp-anim']           = array(
				'layout' => array(),
				'width'  => array(),
				'height' => array(),
				'id'     => array(),
				'srcset' => array(),
				'src'    => array(),
			);
			$my_allowed['amp-imgur']          = array(
				'data-imgur-id' => array(),
				'layout'        => array(),
				'width'         => array(),
				'height'        => array(),
				'id'            => array(),
			);
			$my_allowed['amp-animation']      = array(
				'layout'         => array(),
				'duration'       => array(),
				'delay'          => array(),
				'endDelay'       => array(),
				'iterations'     => array(),
				'iterationStart' => array(),
				'easing'         => array(),
				'direction'      => array(),
				'fill'           => array(),
			);

			// select
			$my_allowed['select'] = array(
				'class'    => array(),
				'id'       => array(),
				'name'     => array(),
				'value'    => array(),
				'type'     => array(),
				'required' => array(),
				'multiple' => array(),
				'style'    => array(),
			);

			$my_allowed['iframe'] = array(
				'class'  => array(),
				'id'     => array(),
				'src'    => array(),
				'height' => array(),
				'width'  => array(),
			);

			$my_allowed['tr']  = array(
				'class' => array(),
				'id'    => array(),
				'name'  => array(),
			);
			$my_allowed['div'] = array(
				'class'            => array(),
				'id'               => array(),
				'data-id'          => array(),
				'data-mantis-zone' => array(),

			);
			// options
			$my_allowed['option']   = array(
				'selected' => array(),
				'value'    => array(),
			);
			$my_allowed['optgroup'] = array(
				'label'   => array(),
				'data-id' => array(),
			);
			// style
			$my_allowed['style'] = array(
				'types' => array(),
			);
			// allow script
			$my_allowed['script'] = array(
				'src'            => array(),
				'type'           => array(),
				'data-width'     => array(),
				'data-height'    => array(),
				'async'          => array(),
				'crossorigin'    => array(),
				'defer'          => array(),
				'importance'     => array(),
				'integrity'      => array(),
				'nomodule'       => array(),
				'nonce'          => array(),
				'text'           => array(),
				'charset'        => array(),
				'language'       => array(),
				'data-adfscript' => array(),
			);

			return $my_allowed;
	}
}