<?php

[0] Fix | Delete

[1] Fix | Delete

use AdvancedAds\Entities;

[2] Fix | Delete

use AdvancedAds\Utilities\WordPress;

[3] Fix | Delete

[4] Fix | Delete

/**

[5] Fix | Delete

* Export functionality.

[6] Fix | Delete

*/

[7] Fix | Delete

class Advanced_Ads_Export {

[8] Fix | Delete

/**

[9] Fix | Delete

* @var Advanced_Ads_Export

[10] Fix | Delete

*/

[11] Fix | Delete

private static $instance;

[12] Fix | Delete

[13] Fix | Delete

/**

[14] Fix | Delete

* Status messages

[15] Fix | Delete

*/

[16] Fix | Delete

private $messages = [];

[17] Fix | Delete

[18] Fix | Delete

private function __construct() {

[19] Fix | Delete

[20] Fix | Delete

$page_hook = 'admin_page_advanced-ads-import-export';

[21] Fix | Delete

// execute before headers are sent

[22] Fix | Delete

add_action( 'load-' . $page_hook, [ $this, 'download_export_file' ] );

[23] Fix | Delete

}

[24] Fix | Delete

[25] Fix | Delete

/**

[26] Fix | Delete

* Return an instance of this class.

[27] Fix | Delete

*/

[28] Fix | Delete

public static function get_instance() {

[29] Fix | Delete

if ( null == self::$instance ) {

[30] Fix | Delete

self::$instance = new self;

[31] Fix | Delete

}

[32] Fix | Delete

return self::$instance;

[33] Fix | Delete

}

[34] Fix | Delete

[35] Fix | Delete

/**

[36] Fix | Delete

* Handle form submissions

[37] Fix | Delete

*/

[38] Fix | Delete

public function download_export_file() {

[39] Fix | Delete

$action = WordPress::current_action();

[40] Fix | Delete

[41] Fix | Delete

if ( $action === 'export' ) {

[42] Fix | Delete

if ( ! WordPress::user_can( 'advanced_ads_manage_options') ) {

[43] Fix | Delete

return;

[44] Fix | Delete

}

[45] Fix | Delete

[46] Fix | Delete

check_admin_referer( 'advads-export' );

[47] Fix | Delete

[48] Fix | Delete

if ( isset( $_POST['content'] ) ) {

[49] Fix | Delete

$this->process( $_POST['content'] );

[50] Fix | Delete

}

[51] Fix | Delete

}

[52] Fix | Delete

}

[53] Fix | Delete

[54] Fix | Delete

/**

[55] Fix | Delete

* Generate XML file.

[56] Fix | Delete

*

[57] Fix | Delete

* @param array $content Types of content to be exported.

[58] Fix | Delete

*/

[59] Fix | Delete

private function process( array $content ) {

[60] Fix | Delete

global $wpdb;

[61] Fix | Delete

[62] Fix | Delete

@set_time_limit( 0 );

[63] Fix | Delete

@ini_set( 'memory_limit', apply_filters( 'admin_memory_limit', WP_MAX_MEMORY_LIMIT ) );

[64] Fix | Delete

[65] Fix | Delete

$export = [];

[66] Fix | Delete

$advads_ad_groups = get_option( 'advads-ad-groups', [] );

[67] Fix | Delete

[68] Fix | Delete

if ( in_array( 'ads', $content ) ) {

[69] Fix | Delete

$advads_ad_weights = get_option( 'advads-ad-weights', [] );

[70] Fix | Delete

[71] Fix | Delete

$ads = [];

[72] Fix | Delete

$export_fields = implode( ', ', [

[73] Fix | Delete

'ID',

[74] Fix | Delete

'post_date',

[75] Fix | Delete

'post_date_gmt',

[76] Fix | Delete

'post_content',

[77] Fix | Delete

'post_title',

[78] Fix | Delete

'post_password',

[79] Fix | Delete

'post_name',

[80] Fix | Delete

'post_status',

[81] Fix | Delete

'post_modified',

[82] Fix | Delete

'post_modified_gmt',

[83] Fix | Delete

'guid'

[84] Fix | Delete

] );

[85] Fix | Delete

[86] Fix | Delete

$posts = $wpdb->get_results( $wpdb->prepare( "SELECT $export_fields FROM {$wpdb->posts} where post_type = '%s' and post_status not in ('trash', 'auto-draft')", Entities::POST_TYPE_AD ), ARRAY_A );

[87] Fix | Delete

[88] Fix | Delete

$mime_types = array_filter( get_allowed_mime_types(), function( $mime_type ) {

[89] Fix | Delete

return preg_match( '/image\//', $mime_type );

[90] Fix | Delete

} );

[91] Fix | Delete

$search = '/' . preg_quote( home_url(), '/' ) . '(\S+?)\.(' . implode( '|', array_keys( $mime_types ) ) . ')/i';

[92] Fix | Delete

foreach ( $posts as $k => $post ) {

[93] Fix | Delete

if ( ! empty( $post['post_content'] ) ) {

[94] Fix | Delete

// wrap images in <advads_import_img></advads_import_img> tags

[95] Fix | Delete

$post['post_content'] = preg_replace( $search, '<advads_import_img>\\0</advads_import_img>', $post['post_content'] );

[96] Fix | Delete

}

[97] Fix | Delete

[98] Fix | Delete

$ads[$k] = $post;

[99] Fix | Delete

[100] Fix | Delete

if ( in_array( 'groups', $content ) ) {

[101] Fix | Delete

$terms = wp_get_object_terms( $post['ID'], 'advanced_ads_groups' );

[102] Fix | Delete

[103] Fix | Delete

foreach ( (array) $terms as $term ) {

[104] Fix | Delete

$group_info = [

[105] Fix | Delete

'term_id' => $term->term_id,

[106] Fix | Delete

'slug' => $term->slug,

[107] Fix | Delete

'name' => $term->name,

[108] Fix | Delete

];

[109] Fix | Delete

[110] Fix | Delete

if ( isset( $advads_ad_groups[ $term->term_id ] ) ) {

[111] Fix | Delete

$group_info += $advads_ad_groups[ $term->term_id ];

[112] Fix | Delete

}

[113] Fix | Delete

[114] Fix | Delete

if ( isset( $advads_ad_weights[ $term->term_id ][ $post['ID'] ] ) ) {

[115] Fix | Delete

$group_info['weight'] = $advads_ad_weights[ $term->term_id ][ $post['ID'] ];

[116] Fix | Delete

}

[117] Fix | Delete

[118] Fix | Delete

$ads[ $k ]['groups'][] = $group_info;

[119] Fix | Delete

}

[120] Fix | Delete

}

[121] Fix | Delete

[122] Fix | Delete

$postmeta = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM {$wpdb->postmeta} WHERE post_id = %d", absint( $post['ID'] ) ) );

[123] Fix | Delete

[124] Fix | Delete

foreach ( $postmeta as $meta ) {

[125] Fix | Delete

if ( $meta->meta_key === '_edit_lock' ) {

[126] Fix | Delete

continue;

[127] Fix | Delete

}

[128] Fix | Delete

if ( $meta->meta_key === Advanced_Ads_Ad::$options_meta_field ) {

[129] Fix | Delete

$ad_options = maybe_unserialize( $meta->meta_value );

[130] Fix | Delete

if ( isset( $ad_options['output']['image_id'] ) ) {

[131] Fix | Delete

$image_id = absint( $ad_options['output']['image_id'] );

[132] Fix | Delete

if ( $atached_img = wp_get_attachment_url( $image_id) ) {

[133] Fix | Delete

$ads[ $k ]['attached_img_url'] = $atached_img;

[134] Fix | Delete

}

[135] Fix | Delete

}

[136] Fix | Delete

$ads[ $k ]['meta_input'][ $meta->meta_key ] = $ad_options;

[137] Fix | Delete

} else {

[138] Fix | Delete

$ads[ $k ]['meta_input'] [$meta->meta_key ] = $meta->meta_value;

[139] Fix | Delete

}

[140] Fix | Delete

}

[141] Fix | Delete

}

[142] Fix | Delete

[143] Fix | Delete

if ( $ads ) {

[144] Fix | Delete

$export['ads'] = $ads;

[145] Fix | Delete

}

[146] Fix | Delete

}

[147] Fix | Delete

[148] Fix | Delete

if ( in_array( 'groups', $content ) ) {

[149] Fix | Delete

$terms = Advanced_Ads::get_instance()->get_model()->get_ad_groups();

[150] Fix | Delete

foreach ( $terms as $term ) {

[151] Fix | Delete

$group_info = [

[152] Fix | Delete

'term_id' => $term->term_id,

[153] Fix | Delete

'slug' => $term->slug,

[154] Fix | Delete

'name' => $term->name,

[155] Fix | Delete

];

[156] Fix | Delete

[157] Fix | Delete

if ( isset( $advads_ad_groups[ $term->term_id ] ) ) {

[158] Fix | Delete

$group_info += $advads_ad_groups[ $term->term_id ];

[159] Fix | Delete

}

[160] Fix | Delete

[161] Fix | Delete

$export['groups'][] = $group_info;

[162] Fix | Delete

}

[163] Fix | Delete

}

[164] Fix | Delete

[165] Fix | Delete

if ( in_array( 'placements', $content ) ) {

[166] Fix | Delete

$placements = Advanced_Ads::get_instance()->get_model()->get_ad_placements_array();

[167] Fix | Delete

[168] Fix | Delete

// prevent nodes starting with number

[169] Fix | Delete

foreach ( $placements as $key => &$placement ) {

[170] Fix | Delete

$placement['key'] = $key;

[171] Fix | Delete

}

[172] Fix | Delete

[173] Fix | Delete

$export['placements'] = array_values( $placements );

[174] Fix | Delete

}

[175] Fix | Delete

[176] Fix | Delete

if ( in_array( 'options', $content, true ) ) {

[177] Fix | Delete

/**

[178] Fix | Delete

* Filters the list of options to be exported.

[179] Fix | Delete

*

[180] Fix | Delete

* @param $options An array of options

[181] Fix | Delete

*/

[182] Fix | Delete

$export['options'] = array_filter( apply_filters( 'advanced-ads-export-options', [

[183] Fix | Delete

ADVADS_SLUG => get_option( ADVADS_SLUG ),

[184] Fix | Delete

GADSENSE_OPT_NAME => get_option( GADSENSE_OPT_NAME ),

[185] Fix | Delete

Advanced_Ads_Privacy::OPTION_KEY => get_option( Advanced_Ads_Privacy::OPTION_KEY ),

[186] Fix | Delete

Advanced_Ads_Ads_Txt_Strategy::OPTION => get_option( Advanced_Ads_Ads_Txt_Strategy::OPTION ),

[187] Fix | Delete

] ) );

[188] Fix | Delete

}

[189] Fix | Delete

[190] Fix | Delete

do_action_ref_array( 'advanced-ads-export', [ $content, &$export ] );

[191] Fix | Delete

[192] Fix | Delete

if ( $export ) {

[193] Fix | Delete

if ( defined( 'IMPORT_DEBUG' ) && IMPORT_DEBUG ) {

[194] Fix | Delete

error_log( print_r( 'Array to decode', true ) );

[195] Fix | Delete

error_log( print_r( $export, true) );

[196] Fix | Delete

}

[197] Fix | Delete

[198] Fix | Delete

// add the root domain and the current date to the filename.

[199] Fix | Delete

$filename = sprintf(

[200] Fix | Delete

'%s-advanced-ads-export-%s.xml',

[201] Fix | Delete

sanitize_title( preg_replace(

[202] Fix | Delete

'#^(?:[^:]+:)?//(?:www\.)?([^/]+)#',

[203] Fix | Delete

'$1',

[204] Fix | Delete

get_bloginfo( 'url' )

[205] Fix | Delete

) ),

[206] Fix | Delete

gmdate( 'Y-m-d' )

[207] Fix | Delete

);

[208] Fix | Delete

[209] Fix | Delete

try {

[210] Fix | Delete

$encoded = Advanced_Ads_XmlEncoder::get_instance()->encode( $export, [ 'encoding' => get_option( 'blog_charset' ) ] );

[211] Fix | Delete

[212] Fix | Delete

header( 'Content-Description: File Transfer' );

[213] Fix | Delete

header( 'Content-Disposition: attachment; filename=' . $filename );

[214] Fix | Delete

header( 'Content-Type: text/xml; charset=' . get_option( 'blog_charset' ), true );

[215] Fix | Delete

echo $encoded;

[216] Fix | Delete

[217] Fix | Delete

if ( defined( 'IMPORT_DEBUG' ) && IMPORT_DEBUG ) {

[218] Fix | Delete

error_log( print_r( $encoded, true ) );

[219] Fix | Delete

$decoded = Advanced_Ads_XmlEncoder::get_instance()->decode( $encoded );

[220] Fix | Delete

error_log( 'result ' . var_export( $export === $decoded , true ) );

[221] Fix | Delete

}

[222] Fix | Delete

[223] Fix | Delete

exit();

[224] Fix | Delete

[225] Fix | Delete

} catch ( Exception $e ) {

[226] Fix | Delete

$this->messages[] = [ 'error', $e->getMessage() ];

[227] Fix | Delete

}

[228] Fix | Delete

}

[229] Fix | Delete

}

[230] Fix | Delete

[231] Fix | Delete

public function get_messages(){

[232] Fix | Delete

return $this->messages;

[233] Fix | Delete

}

[234] Fix | Delete

}

[235] Fix | Delete

[236] Fix | Delete