XmlCsvExport.php — WP All Export – Drag & Drop Export to Any Custom CSV, XML & Excel 1.1.5

wp-all-export / libraries / XmlCsvExport.php

wp-all-export / libraries Last commit date

XmlCsvExport.php

850 lines

1	<?php
2
3	final Class XmlCsvExport
4	{
5	public static $main_xml_tag = '';
6
7	public static $node_xml_tag = '';
8
9	/** @var \Wpae\Csv\CsvWriter */
10	private static $csvWriter;
11
12	public static function export()
13	{
14	switch ( XmlExportEngine::$exportOptions['export_to'] )
15	{
16	case 'xml':
17	self::export_xml();
18	break;
19
20	case XmlExportEngine::EXPORT_TYPE_CSV:
21	self::export_csv();
22	break;
23	default:
24	# code...
25	break;
26	}
27	}
28
29	public static function export_csv( $preview = false, $is_cron = false, $file_path = false, $exported_by_cron = 0 )
30	{
31
32	if ( XmlExportEngine::$exportOptions['delimiter'] == '\t' ) XmlExportEngine::$exportOptions['delimiter'] = "\t";
33
34	ob_start();
35
36	$stream = fopen("php://output", 'w');
37
38	$headers = array();
39	$woo = array();
40	$woo_order = array();
41	$acfs = array();
42	$articles = array();
43
44	// self::$implode = (XmlExportEngine::$exportOptions['delimiter'] == ',') ? '\|' : ',';
45	//
46	// self::$implode = apply_filters('wp_all_export_implode_delimiter', self::$implode, XmlExportEngine::$exportID);
47
48	// [ Exporting requested data ]
49
50	if ( XmlExportEngine::$is_user_export ) { // exporting WordPress users
51
52	foreach ( XmlExportEngine::$exportQuery->results as $user ) {
53	$articles[] = XmlExportUser::prepare_data($user, false, $acfs, XmlExportEngine::$implode, $preview);
54	$articles = apply_filters('wp_all_export_csv_rows', $articles, XmlExportEngine::$exportOptions, XmlExportEngine::$exportID);
55	if (!$preview) do_action('pmxe_exported_post', $user->ID, XmlExportEngine::$exportRecord);
56	}
57	}
58	elseif ( XmlExportEngine::$is_comment_export ) { // exporting comments
59	global $wp_version;
60
61	if ( version_compare($wp_version, '4.2.0', '>=') ) {
62	$comments = XmlExportEngine::$exportQuery->get_comments();
63	}
64	else {
65	$comments = XmlExportEngine::$exportQuery;
66	}
67
68	foreach ( $comments as $comment ) {
69	$articles[] = XmlExportComment::prepare_data($comment, false, XmlExportEngine::$implode, $preview);
70	$articles = apply_filters('wp_all_export_csv_rows', $articles, XmlExportEngine::$exportOptions, XmlExportEngine::$exportID);
71	if (!$preview) do_action('pmxe_exported_post', $comment->comment_ID, XmlExportEngine::$exportRecord);
72	}
73	}
74	elseif ( XmlExportEngine::$is_taxonomy_export ) { // exporting WordPress taxonomy terms
75
76	add_filter('terms_clauses', 'wp_all_export_terms_clauses', 10, 3);
77	$terms = XmlExportEngine::$exportQuery->get_terms();
78	remove_filter('terms_clauses', 'wp_all_export_terms_clauses');
79	foreach ( $terms as $term ) {
80	$articles[] = XmlExportTaxonomy::prepare_data($term, false, $acfs, XmlExportEngine::$implode, $preview);
81	$articles = apply_filters('wp_all_export_csv_rows', $articles, XmlExportEngine::$exportOptions, XmlExportEngine::$exportID);
82	if (!$preview) do_action('pmxe_exported_post', $term->term_id, XmlExportEngine::$exportRecord);
83	}
84	}
85	else { // exporting custom post types
86	while ( XmlExportEngine::$exportQuery->have_posts() ) {
87	XmlExportEngine::$exportQuery->the_post();
88	$record = get_post(get_the_ID());
89	$articles[] = XmlExportCpt::prepare_data($record, XmlExportEngine::$exportOptions, false, $acfs, $woo, $woo_order, XmlExportEngine::$implode, $preview);
90	$articles = apply_filters('wp_all_export_csv_rows', $articles, XmlExportEngine::$exportOptions, XmlExportEngine::$exportID);
91	if (!$preview) do_action('pmxe_exported_post', $record->ID, XmlExportEngine::$exportRecord);
92	}
93
94	wp_reset_postdata();
95	}
96	// [ \Exporting requested data ]
97
98	// [ Prepare CSV headers ]
99	if (XmlExportEngine::$exportOptions['ids']):
100
101	foreach (XmlExportEngine::$exportOptions['ids'] as $ID => $value)
102	{
103	if ( empty(XmlExportEngine::$exportOptions['cc_name'][$ID]) or empty(XmlExportEngine::$exportOptions['cc_type'][$ID]) or ! is_numeric($ID) ) continue;
104
105	self::prepare_csv_headers( $headers, $ID, $acfs );
106	}
107
108	endif;
109
110	$headers = apply_filters( 'wp_all_export_csv_headers', $headers, XmlExportEngine::$exportID );
111
112	if ($is_cron) {
113	if ( ! $exported_by_cron ) {
114	self::getCsvWriter()->writeCsv($stream, array_map(array('XmlCsvExport', '_get_valid_header_name'), $headers), XmlExportEngine::$exportOptions['delimiter']);
115	apply_filters('wp_all_export_after_csv_line', $stream, XmlExportEngine::$exportID);
116	}
117	else {
118	self::merge_headers( $file_path, $headers );
119	}
120	}
121	else
122	{
123	if ($preview or empty(PMXE_Plugin::$session->file)) {
124	self::getCsvWriter()->writeCsv($stream, array_map(array('XmlCsvExport', '_get_valid_header_name'), $headers), XmlExportEngine::$exportOptions['delimiter']);
125	apply_filters('wp_all_export_after_csv_line', $stream, XmlExportEngine::$exportID);
126	}
127	else {
128	self::merge_headers( PMXE_Plugin::$session->file, $headers );
129	}
130	}
131
132	// [ \Prepare CSV headers ]
133	if (!empty($articles)) {
134	foreach ($articles as $article) { if (empty($article)) continue;
135	$line = array();
136	foreach ($headers as $header) {
137	$line[$header] = (isset($article[$header])) ? $article[$header] : '';
138	}
139	self::getCsvWriter()->writeCsv($stream, $line, XmlExportEngine::$exportOptions['delimiter']);
140	apply_filters('wp_all_export_after_csv_line', $stream, XmlExportEngine::$exportID);
141	}
142	}
143
144	if ($preview) return ob_get_clean();
145
146	return self::save_csv_to_file( $file_path, $is_cron, $exported_by_cron );
147
148	}
149
150	public static function export_xml( $preview = false, $is_cron = false, $file_path = false, $exported_by_cron = 0 )
151	{
152	$is_custom_xml = ( ! empty(XmlExportEngine::$exportOptions['xml_template_type']) && in_array(XmlExportEngine::$exportOptions['xml_template_type'], array('custom', 'XmlGoogleMerchants')) ) ? true : false;
153
154	if ( ! empty(XmlExportEngine::$exportOptions['xml_template_type']) ){
155
156	switch (XmlExportEngine::$exportOptions['xml_template_type']) {
157	case 'custom':
158	case 'XmlGoogleMerchants':
159	XmlExportEngine::$exportOptions['ids'] = XmlExportEngine::$exportOptions['custom_xml_template_options']['ids'];
160	XmlExportEngine::$exportOptions['cc_label'] = XmlExportEngine::$exportOptions['custom_xml_template_options']['cc_label'];
161	XmlExportEngine::$exportOptions['cc_type'] = XmlExportEngine::$exportOptions['custom_xml_template_options']['cc_type'];
162	XmlExportEngine::$exportOptions['cc_value'] = XmlExportEngine::$exportOptions['custom_xml_template_options']['cc_value'];
163	XmlExportEngine::$exportOptions['cc_name'] = XmlExportEngine::$exportOptions['custom_xml_template_options']['cc_name'];
164	XmlExportEngine::$exportOptions['cc_php'] = XmlExportEngine::$exportOptions['custom_xml_template_options']['cc_php'];
165	XmlExportEngine::$exportOptions['cc_code'] = XmlExportEngine::$exportOptions['custom_xml_template_options']['cc_code'];
166	XmlExportEngine::$exportOptions['cc_sql'] = XmlExportEngine::$exportOptions['custom_xml_template_options']['cc_sql'];
167	XmlExportEngine::$exportOptions['cc_options'] = XmlExportEngine::$exportOptions['custom_xml_template_options']['cc_options'];
168	XmlExportEngine::$exportOptions['cc_settings'] = XmlExportEngine::$exportOptions['custom_xml_template_options']['cc_settings'];
169	break;
170	default:
171	# code...
172	break;
173	}
174	}
175
176	if ( XmlExportEngine::$exportOptions['delimiter'] == '\t' ) XmlExportEngine::$exportOptions['delimiter'] = "\t";
177
178	require_once PMXE_ROOT_DIR . '/classes/XMLWriter.php';
179
180	$woo = array();
181	$woo_order = array();
182	$acfs = array();
183
184	self::$main_xml_tag = apply_filters('wp_all_export_main_xml_tag', XmlExportEngine::$exportOptions['main_xml_tag'], XmlExportEngine::$exportID);
185	self::$node_xml_tag = apply_filters('wp_all_export_record_xml_tag', XmlExportEngine::$exportOptions['record_xml_tag'], XmlExportEngine::$exportID);
186
187	// self::$implode = (XmlExportEngine::$exportOptions['delimiter'] == ',') ? '\|' : ',';
188	//
189	// if ( $is_custom_xml ) self::$implode = '#delimiter#';
190
191	$xmlWriter = new PMXE_XMLWriter();
192
193	if ( ! $is_custom_xml ) {
194
195	$xmlWriter->openMemory();
196	$xmlWriter->setIndent(true);
197	$xmlWriter->setIndentString("\t");
198	$xmlWriter->startDocument('1.0', XmlExportEngine::$exportOptions['encoding']);
199	$xmlWriter->startElement(self::$main_xml_tag);
200	// add additional data after XML root element
201	self::xml_header( $xmlWriter, $is_cron, $exported_by_cron );
202	}
203
204	// [ Exporting requested data ]
205
206	if ( XmlExportEngine::$is_user_export ) // exporting WordPress users
207	{
208	foreach ( XmlExportEngine::$exportQuery->results as $user ) :
209
210	$is_export_record = apply_filters('wp_all_export_xml_rows', true, $user, XmlExportEngine::$exportOptions, XmlExportEngine::$exportID);
211
212	if ( ! $is_export_record ) continue;
213
214	if ( ! $is_custom_xml ) {
215	// add additional information before each node
216	self::before_xml_node( $xmlWriter, $user->ID);
217
218	$xmlWriter->startElement(self::$node_xml_tag);
219
220	XmlExportUser::prepare_data( $user, $xmlWriter, $acfs, XmlExportEngine::$implode, $preview );
221
222	$xmlWriter->closeElement(); // end post
223
224	// add additional information after each node
225	self::after_xml_node( $xmlWriter, $user->ID);
226	}
227	else {
228	$articles = array();
229	$articles[] = XmlExportUser::prepare_data( $user, $xmlWriter, $acfs, XmlExportEngine::$implode, $preview );
230	$articles = apply_filters('wp_all_export_csv_rows', $articles, XmlExportEngine::$exportOptions, XmlExportEngine::$exportID);
231
232	$xmlWriter->writeArticle( $articles );
233	}
234
235	if ( ! $preview) do_action('pmxe_exported_post', $user->ID, XmlExportEngine::$exportRecord );
236
237	endforeach;
238
239	}
240	elseif ( XmlExportEngine::$is_taxonomy_export ) // exporting WordPress taxonomy terms
241	{
242	add_filter('terms_clauses', 'wp_all_export_terms_clauses', 10, 3);
243	$terms = XmlExportEngine::$exportQuery->get_terms();
244	remove_filter('terms_clauses', 'wp_all_export_terms_clauses');
245	foreach ( $terms as $term ) {
246
247	$is_export_record = apply_filters('wp_all_export_xml_rows', true, $term, XmlExportEngine::$exportOptions, XmlExportEngine::$exportID);
248
249	if (!$is_export_record) continue;
250
251	if (!$is_custom_xml) {
252	// add additional information before each node
253	self::before_xml_node($xmlWriter, $term->term_id);
254
255	$xmlWriter->startElement(self::$node_xml_tag);
256
257	XmlExportTaxonomy::prepare_data($term, $xmlWriter, $acfs, XmlExportEngine::$implode, $preview);
258
259	$xmlWriter->closeElement(); // end post
260
261	// add additional information after each node
262	self::after_xml_node($xmlWriter, $term->term_id);
263	} else {
264	$articles = array();
265	$articles[] = XmlExportTaxonomy::prepare_data($term, $xmlWriter, $acfs, XmlExportEngine::$implode, $preview);
266	$articles = apply_filters('wp_all_export_csv_rows', $articles, XmlExportEngine::$exportOptions, XmlExportEngine::$exportID);
267
268	$xmlWriter->writeArticle($articles);
269	}
270
271	if (!$preview) do_action('pmxe_exported_post', $term->term_id, XmlExportEngine::$exportRecord);
272
273	}
274
275	}
276	elseif ( XmlExportEngine::$is_comment_export ) // exporting comments
277	{
278	global $wp_version;
279
280	if ( version_compare($wp_version, '4.2.0', '>=') ) {
281	$comments = XmlExportEngine::$exportQuery->get_comments();
282	}
283	else {
284	$comments = XmlExportEngine::$exportQuery;
285	}
286
287	foreach ( $comments as $comment ) {
288
289	$is_export_record = apply_filters('wp_all_export_xml_rows', true, $comment, XmlExportEngine::$exportOptions, XmlExportEngine::$exportID);
290
291	if (!$is_export_record) continue;
292
293	if (!$is_custom_xml) {
294	// add additional information before each node
295	self::before_xml_node($xmlWriter, $comment->comment_ID);
296
297	$xmlWriter->startElement(self::$node_xml_tag);
298
299	XmlExportComment::prepare_data($comment, $xmlWriter, XmlExportEngine::$implode, $preview);
300
301	$xmlWriter->closeElement(); // end post
302
303	// add additional information after each node
304	self::after_xml_node($xmlWriter, $comment->comment_ID);
305	} else {
306	$articles = array();
307	$articles[] = XmlExportComment::prepare_data($comment, $xmlWriter, XmlExportEngine::$implode, $preview);
308	$articles = apply_filters('wp_all_export_csv_rows', $articles, XmlExportEngine::$exportOptions, XmlExportEngine::$exportID);
309
310	$xmlWriter->writeArticle($articles);
311	}
312
313	if (!$preview) do_action('pmxe_exported_post', $comment->comment_ID, XmlExportEngine::$exportRecord);
314
315	}
316	}
317	else {// exporting custom post types
318	while ( XmlExportEngine::$exportQuery->have_posts() ) {
319	XmlExportEngine::$exportQuery->the_post();
320	$record = get_post(get_the_ID());
321
322	$is_export_record = apply_filters('wp_all_export_xml_rows', true, $record, XmlExportEngine::$exportOptions, XmlExportEngine::$exportID);
323
324	if (!$is_export_record) continue;
325
326	if (!$is_custom_xml) {
327	// add additional information before each node
328	self::before_xml_node($xmlWriter, $record->ID);
329	$xmlWriter->startElement(self::$node_xml_tag);
330	XmlExportCpt::prepare_data($record, XmlExportEngine::$exportOptions, $xmlWriter, $acfs, $woo, $woo_order, XmlExportEngine::$implode, $preview);
331
332	$xmlWriter->closeElement(); // end post
333
334	// add additional information after each node
335	self::after_xml_node($xmlWriter, $record->ID);
336	} else {
337	$articles = array();
338	$articles[] = XmlExportCpt::prepare_data($record, XmlExportEngine::$exportOptions, $xmlWriter, $acfs, $woo, $woo_order, XmlExportEngine::$implode, $preview);
339	$articles = apply_filters('wp_all_export_csv_rows', $articles, XmlExportEngine::$exportOptions, XmlExportEngine::$exportID);
340
341	$xmlWriter->writeArticle($articles);
342	}
343
344	if (!$preview) do_action('pmxe_exported_post', $record->ID, XmlExportEngine::$exportRecord);
345	}
346	wp_reset_postdata();
347	}
348	// [ \Exporting requested data ]
349
350	if ( ! $is_custom_xml ) $xmlWriter->closeElement(); // close root XML element
351
352	if ($preview) {
353	return $xmlWriter->wpae_flush();
354	}
355
356	return self::save_xml_to_file( $xmlWriter, $file_path, $is_cron, $exported_by_cron );
357
358	}
359
360	// [ XML Export Helpers ]
361	private static function xml_header($xmlWriter, $is_cron, $exported_by_cron)
362	{
363	if ($is_cron) {
364	if ( ! $exported_by_cron ) {
365
366	$additional_data = apply_filters('wp_all_export_additional_data', array(), XmlExportEngine::$exportOptions, XmlExportEngine::$exportID);
367
368	if ( ! empty($additional_data)) {
369	foreach ($additional_data as $key => $value) {
370	self::addElement($xmlWriter, $key, $value);
371	}
372	}
373	}
374	}
375	else
376	{
377
378	if ( empty(PMXE_Plugin::$session->file) ){
379
380	$additional_data = apply_filters('wp_all_export_additional_data', array(), XmlExportEngine::$exportOptions, XmlExportEngine::$exportID);
381
382	if ( ! empty($additional_data)) {
383	foreach ($additional_data as $key => $value) {
384	self::addElement($xmlWriter, $key, $value);
385	}
386	}
387	}
388	}
389	}
390
391	private static function before_xml_node( $xmlWriter, $pid )
392	{
393	$add_before_node = apply_filters('wp_all_export_add_before_node', array(), XmlExportEngine::$exportOptions, XmlExportEngine::$exportID, $pid);
394
395	if ( ! empty($add_before_node)) {
396	foreach ($add_before_node as $key => $value) {
397	self::addElement($xmlWriter, $key, $value);
398	}
399	}
400	}
401
402	private static function after_xml_node( $xmlWriter, $pid )
403	{
404	$add_after_node = apply_filters('wp_all_export_add_after_node', array(), XmlExportEngine::$exportOptions, XmlExportEngine::$exportID, $pid);
405
406	if ( ! empty($add_after_node)) {
407	foreach ($add_after_node as $key => $value) {
408	self::addElement($xmlWriter, $key, $value);
409	}
410	}
411	}
412
413	private static function save_xml_to_file( $xmlWriter, $file_path, $is_cron, $exported_by_cron )
414	{
415	$is_custom_xml = in_array(XmlExportEngine::$exportOptions['xml_template_type'], array('custom', 'XmlGoogleMerchants'));
416
417	if ($is_cron)
418	{
419	if ( ! $is_custom_xml ) {
420	$xml_header = apply_filters('wp_all_export_xml_header', '<?xml version="1.0" encoding="UTF-8"?>', XmlExportEngine::$exportID);
421
422	$xml = str_replace('<?xml version="1.0" encoding="UTF-8"?>', $xml_header, $xmlWriter->wpae_flush());
423	}
424	else {
425	$xml_header = XmlExportEngine::$exportOptions['custom_xml_template_header'];
426
427	$xml = ( ! $exported_by_cron ) ? PMXE_XMLWriter::preprocess_xml($xml_header) . $xmlWriter->wpae_flush() : $xmlWriter->wpae_flush();
428	}
429
430	if ( ! $exported_by_cron ) {
431	if ( ! $is_custom_xml ) $xml = substr($xml, 0, (strlen(self::$main_xml_tag) + 4) * (-1));
432
433	// The BOM will help some programs like Microsoft Excel read your export file if it includes non-English characters.
434	if (XmlExportEngine::$exportOptions['include_bom']) {
435	file_put_contents($file_path, chr(0xEF).chr(0xBB).chr(0xBF).$xml);
436	}
437	else {
438	file_put_contents($file_path, $xml);
439	}
440	}
441	else {
442	$xml = ( ! $is_custom_xml ) ? substr(substr($xml, 41 + strlen(self::$main_xml_tag)), 0, (strlen(self::$main_xml_tag) + 4) * (-1)) : $xml;
443	file_put_contents($file_path, $xml, FILE_APPEND);
444	}
445
446	return $file_path;
447
448	}
449	else {
450
451	if ( empty(PMXE_Plugin::$session->file) ){
452
453	// generate export file name
454	$export_file = wp_all_export_generate_export_file( XmlExportEngine::$exportID );
455
456	if ( ! $is_custom_xml ) {
457	$xml_header = apply_filters('wp_all_export_xml_header', '<?xml version="1.0" encoding="UTF-8"?>', XmlExportEngine::$exportID);
458
459	$xml = str_replace('<?xml version="1.0" encoding="UTF-8"?>', $xml_header, $xmlWriter->wpae_flush());
460	}
461	else {
462	$xml_header = XmlExportEngine::$exportOptions['custom_xml_template_header'];
463
464	$xml = PMXE_XMLWriter::preprocess_xml($xml_header) . $xmlWriter->wpae_flush();
465	}
466
467	if ( ! $is_custom_xml ) $xml = substr($xml, 0, (strlen(self::$main_xml_tag) + 4) * (-1));
468
469	// The BOM will help some programs like Microsoft Excel read your export file if it includes non-English characters.
470	if (XmlExportEngine::$exportOptions['include_bom']) {
471	file_put_contents($export_file, chr(0xEF).chr(0xBB).chr(0xBF).$xml);
472	}
473	else {
474	file_put_contents($export_file, $xml);
475	}
476
477	PMXE_Plugin::$session->set('file', $export_file);
478	PMXE_Plugin::$session->save_data();
479
480	}
481	else {
482	$xml = ( ! $is_custom_xml ) ? substr(substr($xmlWriter->wpae_flush(), 41 + strlen(self::$main_xml_tag)), 0, (strlen(self::$main_xml_tag) + 4) * (-1)) : $xmlWriter->wpae_flush();
483
484	file_put_contents(PMXE_Plugin::$session->file, $xml, FILE_APPEND);
485	}
486
487	return true;
488
489	}
490	}
491	// [ \XML Export Helpers ]
492
493	// [ CSV Export Helpers ]
494	public static function prepare_csv_headers( & $headers, $ID, &$acfs )
495	{
496	$element_name = ( ! empty(XmlExportEngine::$exportOptions['cc_name'][$ID]) ) ? XmlExportEngine::$exportOptions['cc_name'][$ID] : 'untitled_' . $ID;
497	$element_name = apply_filters('wp_all_export_field_name', wp_all_export_parse_field_name($element_name), XmlExportEngine::$exportID);
498
499	if ( strpos(XmlExportEngine::$exportOptions['cc_label'][$ID], "item_data__") !== false ) {
500	XmlExportEngine::$woo_order_export->get_element_header( $headers, XmlExportEngine::$exportOptions, $ID );
501	return;
502	}
503
504	switch (XmlExportEngine::$exportOptions['cc_type'][$ID])
505	{
506	case 'woo':
507	XmlExportEngine::$woo_export->get_element_header( $headers, XmlExportEngine::$exportOptions, $ID );
508	break;
509
510	case 'woo_order':
511	XmlExportEngine::$woo_order_export->get_element_header( $headers, XmlExportEngine::$exportOptions, $ID );
512	break;
513
514	case 'acf':
515	if ( ! empty($acfs) ) {
516	$single_acf_field = array_shift($acfs);
517
518	if ( is_array($single_acf_field)) {
519	foreach ($single_acf_field as $acf_header) {
520	if ( ! in_array($acf_header, $headers)) $headers[] = $acf_header;
521	}
522	}
523	else {
524	if ( ! in_array($single_acf_field, $headers)) $headers[] = $single_acf_field;
525	}
526	}
527	break;
528
529	default:
530
531	// For ID columns make first element in lowercase for Excel export
532	if ($element_name == 'ID' && ! $ID && isset(XmlExportEngine::$exportOptions['export_to_sheet']) && XmlExportEngine::$exportOptions['export_to_sheet'] != 'csv'){
533	$element_name = 'id';
534	}
535
536	if ( ! in_array($element_name, $headers)) {
537	$headers[] = $element_name;
538	}
539	else {
540	$is_added = false;
541	$i = 0;
542	do {
543	$new_element_name = $element_name . '_' . md5($i);
544
545	if ( ! in_array($new_element_name, $headers) ) {
546	$headers[] = $new_element_name;
547	$is_added = true;
548	}
549
550	$i++;
551	}
552	while ( ! $is_added );
553	}
554
555	// if ( XmlExportEngine::$exportOptions['cc_label'][$ID] == 'product_type' and ! in_array('parent_id', $headers)) {
556	// $headers[] = 'parent_id';
557	// }
558
559	break;
560	}
561
562	}
563
564	public static function _get_valid_header_name( $element_name )
565	{
566	$element_name_parts = explode("_", $element_name);
567
568	$elementIndex = array_pop($element_name_parts);
569
570	if (wp_all_export_isValidMd5($elementIndex)) {
571	$element_name_in_file = str_replace("_" . $elementIndex, "", $element_name);
572	}
573	else {
574	$element_name_in_file = $element_name;
575	}
576
577	$element_name_in_file = XmlExportEngine::sanitizeFieldName($element_name_in_file);
578
579	return $element_name_in_file;
580	}
581
582
583	public static function merge_headers( $file, &$headers )
584	{
585
586	$in = fopen($file, 'r');
587
588	$clear_old_headers = fgetcsv($in, 0, XmlExportEngine::$exportOptions['delimiter']);
589
590	fclose($in);
591
592	$old_headers = array();
593
594	foreach ($clear_old_headers as $i => $header) {
595	$header = str_replace("'", "", str_replace('"', "", str_replace(chr(0xEF).chr(0xBB).chr(0xBF), "", $header)));
596
597	if ( ! in_array($header, $old_headers)) {
598	$old_headers[] = $header;
599	}
600	else {
601	$is_added = false;
602	$i = 0;
603	do {
604	$new_element_name = $header . '_' . md5($i);
605
606	if ( ! in_array($new_element_name, $old_headers) ) {
607	$old_headers[] = $new_element_name;
608	$is_added = true;
609	}
610
611	$i++;
612	}
613	while ( ! $is_added );
614	}
615	}
616
617	$is_update_headers = false;
618
619	foreach ($headers as $header) {
620	if ( ! in_array(XmlExportEngine::sanitizeFieldName($header), $old_headers)) {
621	$is_update_headers = true;
622	break;
623	}
624	}
625
626	if ($is_update_headers) {
627	$tmp_headers = $headers;
628	$headers = $old_headers;
629	foreach ($tmp_headers as $theader){
630	if (!in_array(XmlExportEngine::sanitizeFieldName($theader), $headers)) $headers[] = $theader;
631	}
632	$tmp_file = str_replace(basename($file), 'iteration_' . basename($file), $file);
633	copy($file, $tmp_file);
634	$in = fopen($tmp_file, 'r');
635	$out = fopen($file, 'w');
636	$headers = apply_filters('wp_all_export_csv_headers', $headers, XmlExportEngine::$exportID);
637
638	if ( XmlExportEngine::$exportOptions['include_bom'] ) {
639	fwrite($out, chr(0xEF).chr(0xBB).chr(0xBF));
640	self::getCsvWriter()->writeCsv($out, array_map(array('XmlCsvExport', '_get_valid_header_name'), $headers), XmlExportEngine::$exportOptions['delimiter']);
641	}
642	else {
643	self::getCsvWriter()->writeCsv($out, array_map(array('XmlCsvExport', '_get_valid_header_name'), $headers), XmlExportEngine::$exportOptions['delimiter']);
644	}
645
646	apply_filters('wp_all_export_after_csv_line', $out, XmlExportEngine::$exportID);
647
648	$exclude_old_headers = fgetcsv($in);
649
650	if (is_resource($in)) {
651	while ( ! feof($in) ) {
652	$data = fgetcsv($in, 0, XmlExportEngine::$exportOptions['delimiter']);
653	if ( empty($data) ) continue;
654	$data_assoc = array_combine($old_headers, array_values($data));
655	$line = array();
656	foreach ($headers as $header) {
657	$line[$header] = ( isset($data_assoc[$header]) ) ? $data_assoc[$header] : '';
658	}
659	self::getCsvWriter()->writeCsv($out, $line, XmlExportEngine::$exportOptions['delimiter']);
660	apply_filters('wp_all_export_after_csv_line', $out, XmlExportEngine::$exportID);
661	}
662	fclose($in);
663	}
664	fclose($out);
665	@unlink($tmp_file);
666	}
667	}
668
669	private static function save_csv_to_file( $file_path, $is_cron, $exported_by_cron )
670	{
671	if ($is_cron) {
672	if ( ! $exported_by_cron ) {
673	// The BOM will help some programs like Microsoft Excel read your export file if it includes non-English characters.
674	if (XmlExportEngine::$exportOptions['include_bom']) {
675	file_put_contents($file_path, chr(0xEF).chr(0xBB).chr(0xBF).ob_get_clean());
676	}
677	else {
678	file_put_contents($file_path, ob_get_clean());
679	}
680	}
681	else {
682	file_put_contents($file_path, ob_get_clean(), FILE_APPEND);
683	}
684
685	return $file_path;
686
687	}
688	else
689	{
690	if ( empty(PMXE_Plugin::$session->file) ){
691
692	// generate export file name
693	$export_file = wp_all_export_generate_export_file( XmlExportEngine::$exportID );
694
695	// The BOM will help some programs like Microsoft Excel read your export file if it includes non-English characters.
696	if (XmlExportEngine::$exportOptions['include_bom']) {
697	file_put_contents($export_file, chr(0xEF).chr(0xBB).chr(0xBF).ob_get_clean());
698	}
699	else {
700	file_put_contents($export_file, ob_get_clean());
701	}
702
703	PMXE_Plugin::$session->set('file', $export_file);
704	PMXE_Plugin::$session->save_data();
705
706	}
707	else {
708	file_put_contents(PMXE_Plugin::$session->file, ob_get_clean(), FILE_APPEND);
709	}
710
711	return true;
712	}
713	}
714	// [ \CSV Export Helpers ]
715
716	public static function auto_genetate_export_fields( $post, $errors = false )
717	{
718	$errors or $errors = new WP_Error();
719
720	remove_all_filters( "wp_all_export_init_fields", 10 );
721	remove_all_filters( "wp_all_export_default_fields", 10 );
722	remove_all_filters( "wp_all_export_other_fields", 10 );
723	remove_all_filters( "wp_all_export_available_sections", 10 );
724	remove_all_filters( "wp_all_export_available_data", 10 );
725
726	$engine = new XmlExportEngine($post, $errors);
727	$engine->init_additional_data();
728
729	$auto_generate = array(
730	'ids' => array(),
731	'cc_label' => array(),
732	'cc_php' => array(),
733	'cc_code' => array(),
734	'cc_sql' => array(),
735	'cc_type' => array(),
736	'cc_options' => array(),
737	'cc_value' => array(),
738	'cc_name' => array()
739	);
740
741	$available_data = $engine->init_available_data();
742
743	$available_sections = apply_filters("wp_all_export_available_sections", $engine->get('available_sections'));
744
745	foreach ($available_sections as $slug => $section)
746	{
747	if ( ! empty($section['content']) and ! empty($available_data[$section['content']]))
748	{
749	foreach ($available_data[$section['content']] as $field)
750	{
751	if ( is_array($field) and (isset($field['auto']) or ! in_array('product', $post['cpt']) ))
752	{
753	$auto_generate['ids'][] = 1;
754	$auto_generate['cc_label'][] = is_array($field) ? $field['label'] : $field;
755	$auto_generate['cc_php'][] = 0;
756	$auto_generate['cc_code'][] = '';
757	$auto_generate['cc_sql'][] = '';
758	$auto_generate['cc_settings'][] = '';
759	$auto_generate['cc_type'][] = is_array($field) ? $field['type'] : $slug;
760	$auto_generate['cc_options'][] = '';
761	$auto_generate['cc_value'][] = is_array($field) ? $field['label'] : $field;
762	$auto_generate['cc_name'][] = is_array($field) ? $field['name'] : $field;
763	}
764	}
765	}
766	if ( ! empty($section['additional']) )
767	{
768	foreach ($section['additional'] as $sub_slug => $sub_section) {
769	foreach ($sub_section['meta'] as $field) {
770	$field_options = ( in_array($sub_slug, array('images', 'attachments')) ) ? esc_attr('{"is_export_featured":true,"is_export_attached":true,"image_separator":"\|"}') : '0';
771	$field_name = '';
772	switch ($sub_slug) {
773	case 'images':
774	$field_name = 'Image ' . $field['name'];
775	break;
776	case 'attachments':
777	$field_name = 'Attachment ' . $field['name'];
778	break;
779	default:
780	$field_name = $field['name'];
781	break;
782	}
783
784	if ( is_array($field) and isset($field['auto']) ) {
785	$auto_generate['ids'][] = 1;
786	$auto_generate['cc_label'][] = is_array($field) ? $field['label'] : $field;
787	$auto_generate['cc_php'][] = 0;
788	$auto_generate['cc_code'][] = '';
789	$auto_generate['cc_sql'][] = '';
790	$auto_generate['cc_settings'][] = '';
791	$auto_generate['cc_type'][] = is_array($field) ? $field['type'] : $sub_slug;
792	$auto_generate['cc_options'][] = $field_options;
793	$auto_generate['cc_value'][] = is_array($field) ? $field['label'] : $field;
794	$auto_generate['cc_name'][] = $field_name;
795	}
796	}
797	}
798	}
799	}
800
801	if ( XmlExportWooCommerceOrder::$is_active ) {
802	foreach (XmlExportWooCommerceOrder::$order_sections as $slug => $section) {
803	if ( ! empty($section['meta']) ) {
804	foreach ($section['meta'] as $cur_meta_key => $field) {
805	$auto_generate['ids'][] = 1;
806	$auto_generate['cc_label'][] = is_array($field) ? $field['label'] : $cur_meta_key;
807	$auto_generate['cc_php'][] = 0;
808	$auto_generate['cc_code'][] = '';
809	$auto_generate['cc_sql'][] = '';
810	$auto_generate['cc_settings'][] = '';
811	$auto_generate['cc_type'][] = is_array($field) ? $field['type'] : 'woo_order';
812	$auto_generate['cc_options'][] = is_array($field) ? $field['options'] : $slug;
813	$auto_generate['cc_value'][] = is_array($field) ? $field['label'] : $cur_meta_key;
814	$auto_generate['cc_name'][] = is_array($field) ? $field['name'] : $field;
815	}
816	}
817	}
818	}
819
820	if ( ! XmlExportEngine::$is_comment_export ) XmlExportEngine::$acf_export->auto_generate_export_fields( $auto_generate );
821
822	return $auto_generate;
823	}
824
825	/**
826	* @param $xmlWriter
827	* @param $key
828	* @param $value
829	*/
830	private static function addElement($xmlWriter, $key, $value)
831	{
832	$xmlWriter->startElement(preg_replace('/[^a-z0-9_-]/i', '', $key));
833	$xmlWriter->writeData($value, preg_replace('/[^a-z0-9_-]/i', '', $key));
834	$xmlWriter->closeElement();
835	}
836
837	/**
838	* @return \Wpae\Csv\CsvWriter
839	*/
840	private static function getCsvWriter()
841	{
842	if(is_null(self::$csvWriter)) {
843	$csvStrategy = apply_filters('wp_all_export_csv_strategy', \Wpae\Csv\CsvWriter::CSV_STRATEGY_DEFAULT);
844	self::$csvWriter = new \Wpae\Csv\CsvWriter($csvStrategy);
845	}
846
847	return self::$csvWriter;
848	}
849	}
850