1
|
|
|
<?php |
|
|
|
|
2
|
|
|
/** |
|
|
|
|
3
|
|
|
* @package LSX_WETU_Importer_Connect_Accommodation |
4
|
|
|
* @author LightSpeed |
5
|
|
|
* @license GPL-2.0+ |
6
|
|
|
* @link |
7
|
|
|
* @copyright 2016 LightSpeed |
8
|
|
|
**/ |
|
|
|
|
9
|
|
|
|
10
|
|
|
class LSX_WETU_Importer_Connect_Accommodation extends LSX_WETU_Importer_Admin { |
|
|
|
|
11
|
|
|
|
12
|
|
|
/** |
13
|
|
|
* The url to list items from WETU |
14
|
|
|
* |
15
|
|
|
* @since 0.0.1 |
16
|
|
|
* |
17
|
|
|
* @var string |
18
|
|
|
*/ |
19
|
|
|
public $tab_slug = 'connect_accommodation'; |
20
|
|
|
|
21
|
|
|
/** |
22
|
|
|
* The url to list items from WETU |
23
|
|
|
* |
24
|
|
|
* @since 0.0.1 |
25
|
|
|
* |
26
|
|
|
* @var string |
27
|
|
|
*/ |
28
|
|
|
public $url = false; |
29
|
|
|
|
30
|
|
|
/** |
31
|
|
|
* Initialize the plugin by setting localization, filters, and administration functions. |
32
|
|
|
* |
33
|
|
|
* @since 1.0.0 |
34
|
|
|
* |
35
|
|
|
* @access private |
36
|
|
|
*/ |
37
|
|
|
public function __construct() { |
|
|
|
|
38
|
|
|
$temp_options = get_option( '_lsx-to_settings', false ); |
39
|
|
|
|
40
|
|
|
if ( false !== $temp_options && isset( $temp_options[ $this->plugin_slug ] ) && ! empty( $temp_options[ $this->plugin_slug ] ) ) { |
|
|
|
|
41
|
|
|
$this->options = $temp_options[ $this->plugin_slug ]; |
|
|
|
|
42
|
|
|
} |
43
|
|
|
|
44
|
|
|
$this->url = 'http://wetu.com/API/Pins/' . $this->options['api_key'] . '/List'; |
45
|
|
|
|
46
|
|
|
add_action( 'lsx_tour_importer_admin_tab_' . $this->tab_slug, array( $this, 'display_page' ) ); |
47
|
|
|
add_action( 'wp_ajax_lsx_import_connect_accommodation', array( $this, 'process_connection' ) ); |
48
|
|
|
add_action( 'wp_ajax_nopriv_lsx_import_connect_accommodation', array( $this, 'process_connection' ) ); |
49
|
|
|
} |
|
|
|
|
50
|
|
|
|
51
|
|
|
/** |
52
|
|
|
* Display the importer administration screen |
53
|
|
|
*/ |
54
|
|
|
public function display_page() { |
55
|
|
|
global $post; |
56
|
|
|
?> |
57
|
|
|
<div class="wrap"> |
58
|
|
|
<h3><span class="dashicons dashicons-admin-multisite"></span> <?php esc_html_e( 'Connect your Accommodation', 'lsx-wetu-importer' ); ?></h3> |
59
|
|
|
|
60
|
|
|
<form method="get" action="" id="connect-accommodation-filter"> |
61
|
|
|
<input type="hidden" name="post_type" class="post_type" value="<?php echo esc_attr( $this->tab_slug ); ?>" /> |
62
|
|
|
|
63
|
|
|
<p><?php esc_html_e( 'Below is a list of your accommodation that does not contain a WETU ID, but its Title matches a name in the WETU DB. Connecting it will all you to pull through information from WETU.', 'lsx-wetu-importer' ); ?></p> |
64
|
|
|
|
65
|
|
|
<div class="ajax-loader-small" style="display:none;width:100%;text-align:center;"> |
66
|
|
|
<img style="width:32px;" src="<?php echo esc_url( LSX_WETU_IMPORTER_URL . 'assets/images/ajaxloader.gif' ); ?>" /> |
67
|
|
|
</div> |
68
|
|
|
|
69
|
|
|
<?php |
70
|
|
|
$loose_accommodation = $this->find_current_accommodation(); |
71
|
|
|
?> |
72
|
|
|
<p><input class="button button-primary connect" type="button" value="<?php esc_html_e( 'Connect', 'lsx-wetu-importer' ); ?>" /></p> |
73
|
|
|
<table class="wp-list-table widefat fixed posts"> |
74
|
|
|
<?php $this->table_header(); ?> |
75
|
|
|
|
76
|
|
|
<tbody> |
77
|
|
|
<?php |
78
|
|
|
if ( false !== $loose_accommodation ) { |
|
|
|
|
79
|
|
|
|
80
|
|
|
$loose_args = array( |
81
|
|
|
'post_type' => 'accommodation', |
82
|
|
|
'post_status' => array( 'publish', 'pending' ), |
83
|
|
|
'nopagin' => true, |
84
|
|
|
'post__in' => $loose_accommodation, |
85
|
|
|
); |
86
|
|
|
$loose_accommodation_query = new WP_Query( $loose_args ); |
87
|
|
|
$accommodation = get_transient( 'lsx_ti_accommodation' ); |
88
|
|
|
$identifier = ''; |
89
|
|
|
|
90
|
|
|
if ( $loose_accommodation_query->have_posts() && false !== $accommodation ) { |
|
|
|
|
91
|
|
|
while ( $loose_accommodation_query->have_posts() ) { |
|
|
|
|
92
|
|
|
$loose_accommodation_query->the_post(); |
93
|
|
|
|
94
|
|
|
foreach ( $accommodation as $row_key => $row ) { |
|
|
|
|
95
|
|
|
if ( stripos( ltrim( rtrim( $row->name ) ), $post->post_title ) !== false ) { |
|
|
|
|
96
|
|
|
$identifier = $row->id; |
97
|
|
|
} else { |
98
|
|
|
continue; |
99
|
|
|
} |
100
|
|
|
} |
101
|
|
|
?> |
102
|
|
|
<tr class="post-<?php the_ID(); ?> type-accommodation status-none" id="post-<?php the_ID(); ?>"> |
103
|
|
|
<th class="check-column" scope="row"> |
104
|
|
|
<label for="cb-select-<?php the_ID(); ?>" class="screen-reader-text"><?php the_title(); ?></label> |
105
|
|
|
<input type="checkbox" data-identifier="<?php echo esc_attr( $identifier ); ?>" value="<?php the_ID(); ?>" name="post[]" id="cb-select-<?php the_ID(); ?>"> |
106
|
|
|
</th> |
107
|
|
|
<td class="post-title page-title column-title"> |
108
|
|
|
<strong><?php the_title(); ?></strong> - <a href="<?php echo esc_url( admin_url( '/post.php?post=' . $post->ID . '&action=edit' ) ); ?>" target="_blank"><?php echo esc_html( $post->post_status ); ?></a> |
109
|
|
|
</td> |
110
|
|
|
<td class="excerpt column-excerpt"> |
111
|
|
|
<?php |
112
|
|
|
echo wp_kses_post( strip_tags( get_the_excerpt() ) ); |
|
|
|
|
113
|
|
|
?> |
114
|
|
|
</td> |
115
|
|
|
</tr> |
116
|
|
|
<?php |
117
|
|
|
} |
118
|
|
|
} |
119
|
|
|
} |
120
|
|
|
?> |
121
|
|
|
</tbody> |
122
|
|
|
|
123
|
|
|
<?php $this->table_footer(); ?> |
124
|
|
|
|
125
|
|
|
</table> |
126
|
|
|
|
127
|
|
|
<p><input class="button button-primary connect" type="button" value="<?php esc_html_e( 'Connect', 'lsx-wetu-importer' ); ?>" /></p> |
128
|
|
|
|
129
|
|
|
</form> |
130
|
|
|
|
131
|
|
|
<div style="display:none;" class="completed-list-wrapper"> |
132
|
|
|
<h3><?php esc_html_e( 'Completed' ); ?></h3> |
133
|
|
|
<ul> |
134
|
|
|
</ul> |
135
|
|
|
</div> |
136
|
|
|
</div> |
137
|
|
|
<?php |
138
|
|
|
} |
|
|
|
|
139
|
|
|
|
140
|
|
|
/** |
141
|
|
|
* The header of the item list |
142
|
|
|
*/ |
143
|
|
|
public function table_header() { |
144
|
|
|
?> |
145
|
|
|
<thead> |
146
|
|
|
<tr> |
147
|
|
|
<th style="" class="manage-column column-cb check-column" id="cb" scope="col"> |
148
|
|
|
<label for="cb-select-all-1" class="screen-reader-text">Select All</label> |
149
|
|
|
<input type="checkbox" id="cb-select-all-1"> |
150
|
|
|
</th> |
151
|
|
|
<th style="width:40%;" class="manage-column column-title " id="title" style="width:49%;" scope="col">Title</th> |
152
|
|
|
<th style="width:40%;" class="manage-column column-date" id="date" style="width:49%;" scope="col">Excerpt</th> |
153
|
|
|
</tr> |
154
|
|
|
</thead> |
155
|
|
|
<?php |
156
|
|
|
} |
|
|
|
|
157
|
|
|
|
158
|
|
|
/** |
159
|
|
|
* The footer of the item list |
160
|
|
|
*/ |
161
|
|
|
public function table_footer() { |
162
|
|
|
?> |
163
|
|
|
<tfoot> |
164
|
|
|
<tr> |
165
|
|
|
<th style="" class="manage-column column-cb check-column" id="cb" scope="col"> |
166
|
|
|
<label for="cb-select-all-1" class="screen-reader-text">Select All</label> |
167
|
|
|
<input type="checkbox" id="cb-select-all-1"> |
168
|
|
|
</th> |
169
|
|
|
<th style="width:40%;" class="manage-column column-title " id="title" style="width:49%;" scope="col">Title</th> |
170
|
|
|
<th style="width:40%;" class="manage-column column-date" id="date" style="width:49%;" scope="col">Excerpt</th> |
171
|
|
|
</tr> |
172
|
|
|
</tfoot> |
173
|
|
|
<?php |
174
|
|
|
} |
|
|
|
|
175
|
|
|
|
176
|
|
|
/** |
177
|
|
|
* Grab all the current accommodation posts via the lsx_wetu_id field. |
178
|
|
|
*/ |
179
|
|
|
public function find_current_accommodation() { |
180
|
|
|
global $wpdb; |
181
|
|
|
$return = false; |
182
|
|
|
|
183
|
|
|
$all_accommodation = $wpdb->get_results( |
|
|
|
|
184
|
|
|
" |
185
|
|
|
SELECT ID |
186
|
|
|
FROM {$wpdb->posts} |
187
|
|
|
WHERE post_type = 'accommodation' |
188
|
|
|
LIMIT 0,500 |
189
|
|
|
", |
190
|
|
|
ARRAY_A |
191
|
|
|
); |
192
|
|
|
|
193
|
|
|
$current_accommodation = $wpdb->get_results( |
|
|
|
|
194
|
|
|
" |
195
|
|
|
SELECT key1.post_id |
196
|
|
|
FROM {$wpdb->postmeta} key1 |
197
|
|
|
|
198
|
|
|
INNER JOIN {$wpdb->posts} key2 |
199
|
|
|
ON key1.post_id = key2.ID |
200
|
|
|
|
201
|
|
|
WHERE key1.meta_key = 'lsx_wetu_id' |
202
|
|
|
AND key2.post_type = 'accommodation' |
203
|
|
|
|
204
|
|
|
LIMIT 0,500 |
205
|
|
|
", |
206
|
|
|
ARRAY_A |
207
|
|
|
); |
208
|
|
|
|
209
|
|
|
if ( null !== $all_accommodation && ! empty( $all_accommodation ) ) { |
|
|
|
|
210
|
|
|
// remove the extra accommodation |
|
|
|
|
211
|
|
|
if ( null !== $current_accommodation && ! empty( $current_accommodation ) ) { |
|
|
|
|
212
|
|
|
$all_accommodation = array_diff( $this->format_array( $all_accommodation, 'ID' ), $this->format_array( $current_accommodation, 'post_id' ) ); |
213
|
|
|
} elseif ( null !== $current_accommodation && empty( $current_accommodation ) ) { |
|
|
|
|
214
|
|
|
$all_accommodation = $this->format_array( $current_accommodation, 'post_id' ); |
215
|
|
|
} |
216
|
|
|
|
217
|
|
|
$return = $all_accommodation; |
218
|
|
|
} |
219
|
|
|
|
220
|
|
|
return $return; |
221
|
|
|
} |
|
|
|
|
222
|
|
|
|
223
|
|
|
/** |
|
|
|
|
224
|
|
|
* format the array |
|
|
|
|
225
|
|
|
*/ |
226
|
|
|
public function format_array( $array, $key ) { |
227
|
|
|
$new_array = array(); |
228
|
|
|
|
229
|
|
|
foreach ( $array as $value ) { |
|
|
|
|
230
|
|
|
$new_array[] = $value[ $key ]; |
231
|
|
|
} |
232
|
|
|
|
233
|
|
|
return $new_array; |
234
|
|
|
} |
|
|
|
|
235
|
|
|
|
236
|
|
|
/** |
237
|
|
|
* Run through the accommodation an connect them. |
238
|
|
|
*/ |
239
|
|
|
public function process_connection() { |
240
|
|
|
$return = false; |
241
|
|
|
check_ajax_referer( 'lsx_wetu_ajax_action', 'security' ); |
242
|
|
|
if ( isset( $_POST['action'] ) && 'lsx_import_connect_accommodation' === $_POST['action'] && isset( $_POST['type'] ) && $_POST['type'] === $this->tab_slug && isset( $_POST['post_id'] ) && isset( $_POST['wetu_id'] ) ) { |
|
|
|
|
243
|
|
|
$post_id = false; |
244
|
|
|
$matching_id = false; |
245
|
|
|
$post_id = sanitize_text_field( $_POST['post_id'] ); |
|
|
|
|
246
|
|
|
$matching_id = sanitize_text_field( $_POST['wetu_id'] ); |
|
|
|
|
247
|
|
|
|
248
|
|
|
add_post_meta( $post_id, 'lsx_wetu_id', $matching_id ); |
249
|
|
|
$return = '<li class="post-' . $post_id . '"><span class="dashicons dashicons-yes"></span> <a target="_blank" href="' . get_permalink( $post_id ) . '">' . get_the_title( $post_id ) . '</a></li>'; |
250
|
|
|
} |
251
|
|
|
|
252
|
|
|
print_r( $return ); |
|
|
|
|
253
|
|
|
die(); |
|
|
|
|
254
|
|
|
} |
|
|
|
|
255
|
|
|
|
256
|
|
|
} |
257
|
|
|
|
258
|
|
|
$lsx_wetu_importer_connect_accommodation = new LSX_WETU_Importer_Connect_Accommodation(); |
259
|
|
|
|