class-strong-testimonials-exporter.php — Strong Testimonials 3.3.2

strong-testimonials / admin / class-strong-testimonials-exporter.php

strong-testimonials / admin Last commit date

class-strong-testimonials-exporter.php

92 lines

1	<?php
2
3	/**
4	* Class Strong_Testimonials_Exporter
5	*
6	* exports testimonials along with their featured media
7	*
8	* @since 2.36
9	*/
10	class Strong_Testimonials_Exporter {
11
12	public $args = array();
13	public $query_done = false;
14
15	public function __construct() {
16	add_action( 'export_wp', array( $this, 'export_wp' ), 10, 1 );
17	add_filter( 'export_query', array( $this, 'export_query' ), 10, 1 );
18	}
19
20	public function export_wp( $args ) {
21	$this->args = $args;
22	add_filter( 'query', array( $this, 'export_query_filter' ), 10, 1 );
23	}
24
25	public function export_query_filter( $query ) {
26
27	global $wpdb;
28	if ( false === $this->query_done && 0 === strpos( $query, "SELECT ID FROM {$wpdb->posts} " ) ) {
29	$this->query_done = true;
30	remove_filter( 'query', array( $this, 'export_query_filter' ), 10 );
31	$query = apply_filters( 'export_query', $query );
32	}
33	return $query;
34	}
35
36	public function export_query( $query ) {
37	global $wpdb;
38
39	if ( isset( $this->args['content'] ) && 'wpm-testimonial' === $this->args['content'] ) {
40
41	$attachments = $wpdb->get_results(
42	$wpdb->prepare(
43	"SELECT ID, guid, post_parent FROM {$wpdb->posts} WHERE post_type = %s",
44	'attachment'
45	),
46	OBJECT_K
47	);
48	if ( empty( $attachments ) ) {
49	return $query;
50	}
51
52	$ids = array();
53
54	// get attachments who are post thumbnails
55	$posts = $wpdb->get_col( $query ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
56	if ( $posts ) {
57	$placeholders = implode( ',', array_fill( 0, count( $posts ), '%d' ) );
58	$sql = $wpdb->prepare(
59	// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
60	"SELECT meta_value FROM {$wpdb->postmeta} WHERE meta_key = %s AND post_id IN($placeholders)",
61	array_merge( array( '_thumbnail_id' ), $posts )
62	);
63	$ids = $wpdb->get_col( $sql ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
64	}
65
66	// get attachments who have a post parent.
67	foreach ( $attachments as $id => $att ) {
68	if ( in_array( $att->post_parent, $posts, true ) ) {
69	$ids[] = $id;
70	}
71	}
72
73	$ids = array_unique( $ids );
74	if ( count( $ids ) === 0 ) {
75	return $query;
76	}
77
78	if ( 0 === strpos( $query, "SELECT ID FROM {$wpdb->posts} INNER JOIN {$wpdb->term_relationships} " ) ) {
79	// replace INNER JOIN with LEFT JOIN.
80	$query = str_replace( "SELECT ID FROM {$wpdb->posts} INNER JOIN {$wpdb->term_relationships} ", "SELECT ID FROM {$wpdb->posts} LEFT JOIN {$wpdb->term_relationships} ", $query );
81	}
82	$placeholders = implode( ',', array_fill( 0, count( $ids ), '%d' ) );
83	// phpcs:ignore
84	$query .= $wpdb->prepare( " OR {$wpdb->posts}.ID IN ($placeholders) ", $ids );
85
86	}
87	return $query;
88	}
89	}
90
91	new Strong_Testimonials_Exporter();
92