@@ -2,109 +2,109 @@ discard block |
||
2 | 2 | |
3 | 3 | class FrmXMLController { |
4 | 4 | |
5 | - public static function menu() { |
|
5 | + public static function menu() { |
|
6 | 6 | add_submenu_page( 'formidable', 'Formidable | ' . __( 'Import/Export', 'formidable' ), __( 'Import/Export', 'formidable' ), 'frm_edit_forms', 'formidable-import', 'FrmXMLController::route' ); |
7 | - } |
|
7 | + } |
|
8 | 8 | |
9 | - public static function add_default_templates() { |
|
9 | + public static function add_default_templates() { |
|
10 | 10 | if ( ! function_exists( 'libxml_disable_entity_loader' ) ) { |
11 | - // XML import is not enabled on your server |
|
12 | - return; |
|
13 | - } |
|
11 | + // XML import is not enabled on your server |
|
12 | + return; |
|
13 | + } |
|
14 | 14 | |
15 | - $set_err = libxml_use_internal_errors(true); |
|
16 | - $loader = libxml_disable_entity_loader( true ); |
|
15 | + $set_err = libxml_use_internal_errors(true); |
|
16 | + $loader = libxml_disable_entity_loader( true ); |
|
17 | 17 | |
18 | 18 | $files = apply_filters( 'frm_default_templates_files', array( FrmAppHelper::plugin_path() . '/classes/views/xml/default-templates.xml' ) ); |
19 | 19 | |
20 | - foreach ( (array) $files as $file ) { |
|
21 | - FrmXMLHelper::import_xml($file); |
|
22 | - unset($file); |
|
23 | - } |
|
24 | - /* |
|
20 | + foreach ( (array) $files as $file ) { |
|
21 | + FrmXMLHelper::import_xml($file); |
|
22 | + unset($file); |
|
23 | + } |
|
24 | + /* |
|
25 | 25 | if(is_wp_error($result)) |
26 | 26 | $errors[] = $result->get_error_message(); |
27 | 27 | else if($result) |
28 | 28 | $message = $result; |
29 | 29 | */ |
30 | 30 | |
31 | - unset( $files ); |
|
31 | + unset( $files ); |
|
32 | 32 | |
33 | - libxml_use_internal_errors( $set_err ); |
|
34 | - libxml_disable_entity_loader( $loader ); |
|
35 | - } |
|
33 | + libxml_use_internal_errors( $set_err ); |
|
34 | + libxml_disable_entity_loader( $loader ); |
|
35 | + } |
|
36 | 36 | |
37 | - public static function route() { |
|
38 | - $action = isset( $_REQUEST['frm_action'] ) ? 'frm_action' : 'action'; |
|
37 | + public static function route() { |
|
38 | + $action = isset( $_REQUEST['frm_action'] ) ? 'frm_action' : 'action'; |
|
39 | 39 | $action = FrmAppHelper::get_param( $action, '', 'get', 'sanitize_title' ); |
40 | 40 | if ( $action == 'import_xml' ) { |
41 | - return self::import_xml(); |
|
41 | + return self::import_xml(); |
|
42 | 42 | } else if ( $action == 'export_xml' ) { |
43 | - return self::export_xml(); |
|
44 | - } else { |
|
45 | - if ( apply_filters( 'frm_xml_route', true, $action ) ) { |
|
46 | - return self::form(); |
|
47 | - } |
|
48 | - } |
|
49 | - } |
|
50 | - |
|
51 | - public static function form( $errors = array(), $message = '' ) { |
|
43 | + return self::export_xml(); |
|
44 | + } else { |
|
45 | + if ( apply_filters( 'frm_xml_route', true, $action ) ) { |
|
46 | + return self::form(); |
|
47 | + } |
|
48 | + } |
|
49 | + } |
|
50 | + |
|
51 | + public static function form( $errors = array(), $message = '' ) { |
|
52 | 52 | $where = array( |
53 | 53 | 'status' => array( null, '', 'published' ), |
54 | 54 | ); |
55 | 55 | $forms = FrmForm::getAll( $where, 'name' ); |
56 | 56 | |
57 | - $export_types = apply_filters( 'frm_xml_export_types', |
|
58 | - array( 'forms' => __( 'Forms', 'formidable' ), 'items' => __( 'Entries', 'formidable' ) ) |
|
59 | - ); |
|
57 | + $export_types = apply_filters( 'frm_xml_export_types', |
|
58 | + array( 'forms' => __( 'Forms', 'formidable' ), 'items' => __( 'Entries', 'formidable' ) ) |
|
59 | + ); |
|
60 | 60 | |
61 | - $export_format = apply_filters( 'frm_export_formats', array( |
|
62 | - 'xml' => array( 'name' => 'XML', 'support' => 'forms', 'count' => 'multiple' ), |
|
61 | + $export_format = apply_filters( 'frm_export_formats', array( |
|
62 | + 'xml' => array( 'name' => 'XML', 'support' => 'forms', 'count' => 'multiple' ), |
|
63 | 63 | 'csv' => array( 'name' => 'CSV', 'support' => 'items', 'count' => 'single' ), |
64 | - ) ); |
|
64 | + ) ); |
|
65 | 65 | |
66 | 66 | include( FrmAppHelper::plugin_path() . '/classes/views/xml/import_form.php' ); |
67 | - } |
|
67 | + } |
|
68 | 68 | |
69 | - public static function import_xml() { |
|
70 | - $errors = array(); |
|
71 | - $message = ''; |
|
69 | + public static function import_xml() { |
|
70 | + $errors = array(); |
|
71 | + $message = ''; |
|
72 | 72 | |
73 | - $permission_error = FrmAppHelper::permission_nonce_error('frm_edit_forms', 'import-xml', 'import-xml-nonce'); |
|
74 | - if ( $permission_error !== false ) { |
|
75 | - $errors[] = $permission_error; |
|
76 | - self::form($errors); |
|
77 | - return; |
|
78 | - } |
|
73 | + $permission_error = FrmAppHelper::permission_nonce_error('frm_edit_forms', 'import-xml', 'import-xml-nonce'); |
|
74 | + if ( $permission_error !== false ) { |
|
75 | + $errors[] = $permission_error; |
|
76 | + self::form($errors); |
|
77 | + return; |
|
78 | + } |
|
79 | 79 | |
80 | - if ( ! isset($_FILES) || ! isset($_FILES['frm_import_file']) || empty($_FILES['frm_import_file']['name']) || (int) $_FILES['frm_import_file']['size'] < 1 ) { |
|
81 | - $errors[] = __( 'Oops, you didn\'t select a file.', 'formidable' ); |
|
82 | - self::form($errors); |
|
83 | - return; |
|
84 | - } |
|
80 | + if ( ! isset($_FILES) || ! isset($_FILES['frm_import_file']) || empty($_FILES['frm_import_file']['name']) || (int) $_FILES['frm_import_file']['size'] < 1 ) { |
|
81 | + $errors[] = __( 'Oops, you didn\'t select a file.', 'formidable' ); |
|
82 | + self::form($errors); |
|
83 | + return; |
|
84 | + } |
|
85 | 85 | |
86 | - $file = $_FILES['frm_import_file']['tmp_name']; |
|
86 | + $file = $_FILES['frm_import_file']['tmp_name']; |
|
87 | 87 | |
88 | - if ( ! is_uploaded_file( $file ) ) { |
|
89 | - unset($file); |
|
90 | - $errors[] = __( 'The file does not exist, please try again.', 'formidable' ); |
|
91 | - self::form($errors); |
|
92 | - return; |
|
93 | - } |
|
88 | + if ( ! is_uploaded_file( $file ) ) { |
|
89 | + unset($file); |
|
90 | + $errors[] = __( 'The file does not exist, please try again.', 'formidable' ); |
|
91 | + self::form($errors); |
|
92 | + return; |
|
93 | + } |
|
94 | 94 | |
95 | - //add_filter('upload_mimes', 'FrmXMLController::allow_mime'); |
|
95 | + //add_filter('upload_mimes', 'FrmXMLController::allow_mime'); |
|
96 | 96 | |
97 | - $export_format = apply_filters('frm_export_formats', array( |
|
97 | + $export_format = apply_filters('frm_export_formats', array( |
|
98 | 98 | 'xml' => array( 'name' => 'XML', 'support' => 'forms', 'count' => 'multiple' ), |
99 | 99 | ) ); |
100 | 100 | |
101 | - $file_type = strtolower(pathinfo($_FILES['frm_import_file']['name'], PATHINFO_EXTENSION)); |
|
102 | - if ( $file_type != 'xml' && isset( $export_format[ $file_type ] ) ) { |
|
103 | - // allow other file types to be imported |
|
101 | + $file_type = strtolower(pathinfo($_FILES['frm_import_file']['name'], PATHINFO_EXTENSION)); |
|
102 | + if ( $file_type != 'xml' && isset( $export_format[ $file_type ] ) ) { |
|
103 | + // allow other file types to be imported |
|
104 | 104 | do_action( 'frm_before_import_' . $file_type ); |
105 | - return; |
|
106 | - } |
|
107 | - unset($file_type); |
|
105 | + return; |
|
106 | + } |
|
107 | + unset($file_type); |
|
108 | 108 | |
109 | 109 | if ( ! function_exists( 'libxml_disable_entity_loader' ) ) { |
110 | 110 | $errors[] = __( 'XML import is not enabled on your server.', 'formidable' ); |
@@ -123,145 +123,145 @@ discard block |
||
123 | 123 | libxml_use_internal_errors( $set_err ); |
124 | 124 | libxml_disable_entity_loader( $loader ); |
125 | 125 | |
126 | - self::form($errors, $message); |
|
127 | - } |
|
126 | + self::form($errors, $message); |
|
127 | + } |
|
128 | 128 | |
129 | - public static function export_xml() { |
|
130 | - $error = FrmAppHelper::permission_nonce_error( 'frm_edit_forms', 'export-xml', 'export-xml-nonce' ); |
|
131 | - if ( ! empty($error) ) { |
|
132 | - wp_die( $error ); |
|
133 | - } |
|
129 | + public static function export_xml() { |
|
130 | + $error = FrmAppHelper::permission_nonce_error( 'frm_edit_forms', 'export-xml', 'export-xml-nonce' ); |
|
131 | + if ( ! empty($error) ) { |
|
132 | + wp_die( $error ); |
|
133 | + } |
|
134 | 134 | |
135 | 135 | $ids = FrmAppHelper::get_post_param( 'frm_export_forms', array() ); |
136 | 136 | $type = FrmAppHelper::get_post_param( 'type', array() ); |
137 | 137 | $format = FrmAppHelper::get_post_param( 'format', 'xml', 'sanitize_title' ); |
138 | 138 | |
139 | - if ( ! headers_sent() && ! $type ) { |
|
140 | - wp_redirect( esc_url_raw( admin_url( 'admin.php?page=formidable-import' ) ) ); |
|
141 | - die(); |
|
142 | - } |
|
139 | + if ( ! headers_sent() && ! $type ) { |
|
140 | + wp_redirect( esc_url_raw( admin_url( 'admin.php?page=formidable-import' ) ) ); |
|
141 | + die(); |
|
142 | + } |
|
143 | 143 | |
144 | - if ( $format == 'xml' ) { |
|
145 | - self::generate_xml($type, compact('ids')); |
|
144 | + if ( $format == 'xml' ) { |
|
145 | + self::generate_xml($type, compact('ids')); |
|
146 | 146 | } if ( $format == 'csv' ) { |
147 | 147 | self::generate_csv( compact('ids') ); |
148 | - } else { |
|
148 | + } else { |
|
149 | 149 | do_action( 'frm_export_format_' . $format, compact('ids') ); |
150 | - } |
|
150 | + } |
|
151 | 151 | |
152 | - wp_die(); |
|
153 | - } |
|
152 | + wp_die(); |
|
153 | + } |
|
154 | 154 | |
155 | 155 | public static function generate_xml( $type, $args = array() ) { |
156 | - global $wpdb; |
|
156 | + global $wpdb; |
|
157 | 157 | |
158 | - self::prepare_types_array( $type ); |
|
158 | + self::prepare_types_array( $type ); |
|
159 | 159 | |
160 | - $tables = array( |
|
160 | + $tables = array( |
|
161 | 161 | 'items' => $wpdb->prefix . 'frm_items', |
162 | 162 | 'forms' => $wpdb->prefix . 'frm_forms', |
163 | - 'posts' => $wpdb->posts, |
|
164 | - 'styles' => $wpdb->posts, |
|
165 | - 'actions' => $wpdb->posts, |
|
166 | - ); |
|
163 | + 'posts' => $wpdb->posts, |
|
164 | + 'styles' => $wpdb->posts, |
|
165 | + 'actions' => $wpdb->posts, |
|
166 | + ); |
|
167 | 167 | |
168 | 168 | $defaults = array( 'ids' => false ); |
169 | - $args = wp_parse_args( $args, $defaults ); |
|
169 | + $args = wp_parse_args( $args, $defaults ); |
|
170 | 170 | |
171 | - $sitename = sanitize_key( get_bloginfo( 'name' ) ); |
|
171 | + $sitename = sanitize_key( get_bloginfo( 'name' ) ); |
|
172 | 172 | |
173 | - if ( ! empty( $sitename ) ) { |
|
173 | + if ( ! empty( $sitename ) ) { |
|
174 | 174 | $sitename .= '.'; |
175 | 175 | } |
176 | - $filename = $sitename . 'formidable.' . date( 'Y-m-d' ) . '.xml'; |
|
176 | + $filename = $sitename . 'formidable.' . date( 'Y-m-d' ) . '.xml'; |
|
177 | 177 | |
178 | - header( 'Content-Description: File Transfer' ); |
|
179 | - header( 'Content-Disposition: attachment; filename=' . $filename ); |
|
180 | - header( 'Content-Type: text/xml; charset=' . get_option( 'blog_charset' ), true ); |
|
178 | + header( 'Content-Description: File Transfer' ); |
|
179 | + header( 'Content-Disposition: attachment; filename=' . $filename ); |
|
180 | + header( 'Content-Type: text/xml; charset=' . get_option( 'blog_charset' ), true ); |
|
181 | 181 | |
182 | - //make sure ids are numeric |
|
183 | - if ( is_array( $args['ids'] ) && ! empty( $args['ids'] ) ) { |
|
184 | - $args['ids'] = array_filter( $args['ids'], 'is_numeric' ); |
|
185 | - } |
|
182 | + //make sure ids are numeric |
|
183 | + if ( is_array( $args['ids'] ) && ! empty( $args['ids'] ) ) { |
|
184 | + $args['ids'] = array_filter( $args['ids'], 'is_numeric' ); |
|
185 | + } |
|
186 | 186 | |
187 | - $records = array(); |
|
187 | + $records = array(); |
|
188 | 188 | |
189 | 189 | foreach ( $type as $tb_type ) { |
190 | - $where = array(); |
|
190 | + $where = array(); |
|
191 | 191 | $join = ''; |
192 | - $table = $tables[ $tb_type ]; |
|
192 | + $table = $tables[ $tb_type ]; |
|
193 | 193 | |
194 | 194 | $select = $table . '.id'; |
195 | - $query_vars = array(); |
|
195 | + $query_vars = array(); |
|
196 | 196 | |
197 | - switch ( $tb_type ) { |
|
198 | - case 'forms': |
|
199 | - //add forms |
|
200 | - if ( $args['ids'] ) { |
|
197 | + switch ( $tb_type ) { |
|
198 | + case 'forms': |
|
199 | + //add forms |
|
200 | + if ( $args['ids'] ) { |
|
201 | 201 | $where[] = array( 'or' => 1, $table . '.id' => $args['ids'], $table . '.parent_form_id' => $args['ids'] ); |
202 | - } else { |
|
202 | + } else { |
|
203 | 203 | $where[ $table . '.status !' ] = 'draft'; |
204 | - } |
|
205 | - break; |
|
206 | - case 'actions': |
|
204 | + } |
|
205 | + break; |
|
206 | + case 'actions': |
|
207 | 207 | $select = $table . '.ID'; |
208 | 208 | $where['post_type'] = FrmFormActionsController::$action_post_type; |
209 | - if ( ! empty($args['ids']) ) { |
|
209 | + if ( ! empty($args['ids']) ) { |
|
210 | 210 | $where['menu_order'] = $args['ids']; |
211 | - } |
|
212 | - break; |
|
213 | - case 'items': |
|
214 | - //$join = "INNER JOIN {$wpdb->prefix}frm_item_metas im ON ($table.id = im.item_id)"; |
|
215 | - if ( $args['ids'] ) { |
|
211 | + } |
|
212 | + break; |
|
213 | + case 'items': |
|
214 | + //$join = "INNER JOIN {$wpdb->prefix}frm_item_metas im ON ($table.id = im.item_id)"; |
|
215 | + if ( $args['ids'] ) { |
|
216 | 216 | $where[ $table . '.form_id' ] = $args['ids']; |
217 | - } |
|
218 | - break; |
|
219 | - case 'styles': |
|
220 | - // Loop through all exported forms and get their selected style IDs |
|
217 | + } |
|
218 | + break; |
|
219 | + case 'styles': |
|
220 | + // Loop through all exported forms and get their selected style IDs |
|
221 | 221 | $frm_style = new FrmStyle(); |
222 | 222 | $default_style = $frm_style->get_default_style(); |
223 | - $form_ids = $args['ids']; |
|
224 | - $style_ids = array(); |
|
225 | - foreach ( $form_ids as $form_id ) { |
|
226 | - $form_data = FrmForm::getOne( $form_id ); |
|
227 | - // For forms that have not been updated while running 2.0, check if custom_style is set |
|
228 | - if ( isset( $form_data->options['custom_style'] ) ) { |
|
223 | + $form_ids = $args['ids']; |
|
224 | + $style_ids = array(); |
|
225 | + foreach ( $form_ids as $form_id ) { |
|
226 | + $form_data = FrmForm::getOne( $form_id ); |
|
227 | + // For forms that have not been updated while running 2.0, check if custom_style is set |
|
228 | + if ( isset( $form_data->options['custom_style'] ) ) { |
|
229 | 229 | if ( $form_data->options['custom_style'] == 1 ) { |
230 | 230 | $style_ids[] = $default_style->ID; |
231 | 231 | } else { |
232 | 232 | $style_ids[] = $form_data->options['custom_style']; |
233 | 233 | } |
234 | - } |
|
235 | - unset( $form_id, $form_data ); |
|
236 | - } |
|
234 | + } |
|
235 | + unset( $form_id, $form_data ); |
|
236 | + } |
|
237 | 237 | $select = $table . '.ID'; |
238 | - $where['post_type'] = 'frm_styles'; |
|
239 | - |
|
240 | - // Only export selected styles |
|
241 | - if ( ! empty( $style_ids ) ) { |
|
242 | - $where['ID'] = $style_ids; |
|
243 | - } |
|
244 | - break; |
|
245 | - default: |
|
238 | + $where['post_type'] = 'frm_styles'; |
|
239 | + |
|
240 | + // Only export selected styles |
|
241 | + if ( ! empty( $style_ids ) ) { |
|
242 | + $where['ID'] = $style_ids; |
|
243 | + } |
|
244 | + break; |
|
245 | + default: |
|
246 | 246 | $select = $table . '.ID'; |
247 | - $join = ' INNER JOIN ' . $wpdb->postmeta . ' pm ON (pm.post_id=' . $table . '.ID)'; |
|
248 | - $where['pm.meta_key'] = 'frm_form_id'; |
|
249 | - |
|
250 | - if ( empty($args['ids']) ) { |
|
251 | - $where['pm.meta_value >'] = 1; |
|
252 | - } else { |
|
253 | - $where['pm.meta_value'] = $args['ids']; |
|
254 | - } |
|
255 | - break; |
|
256 | - } |
|
247 | + $join = ' INNER JOIN ' . $wpdb->postmeta . ' pm ON (pm.post_id=' . $table . '.ID)'; |
|
248 | + $where['pm.meta_key'] = 'frm_form_id'; |
|
249 | + |
|
250 | + if ( empty($args['ids']) ) { |
|
251 | + $where['pm.meta_value >'] = 1; |
|
252 | + } else { |
|
253 | + $where['pm.meta_value'] = $args['ids']; |
|
254 | + } |
|
255 | + break; |
|
256 | + } |
|
257 | 257 | |
258 | 258 | $records[ $tb_type ] = FrmDb::get_col( $table . $join, $where, $select ); |
259 | - unset($tb_type); |
|
260 | - } |
|
259 | + unset($tb_type); |
|
260 | + } |
|
261 | 261 | |
262 | 262 | echo '<?xml version="1.0" encoding="' . esc_attr( get_bloginfo('charset') ) . "\" ?>\n"; |
263 | 263 | include( FrmAppHelper::plugin_path() . '/classes/views/xml/xml.php' ); |
264 | - } |
|
264 | + } |
|
265 | 265 | |
266 | 266 | private static function prepare_types_array( &$type ) { |
267 | 267 | $type = (array) $type; |
@@ -342,14 +342,14 @@ discard block |
||
342 | 342 | } |
343 | 343 | |
344 | 344 | /** |
345 | - * Get the fields that should be included in the CSV export |
|
346 | - * |
|
347 | - * @since 2.0.19 |
|
348 | - * |
|
349 | - * @param int $form_id |
|
350 | - * @param object $form |
|
351 | - * @return array $csv_fields |
|
352 | - */ |
|
345 | + * Get the fields that should be included in the CSV export |
|
346 | + * |
|
347 | + * @since 2.0.19 |
|
348 | + * |
|
349 | + * @param int $form_id |
|
350 | + * @param object $form |
|
351 | + * @return array $csv_fields |
|
352 | + */ |
|
353 | 353 | private static function get_fields_for_csv_export( $form_id, $form ) { |
354 | 354 | $csv_fields = FrmField::get_all_for_form( $form_id, '', 'include', 'include' ); |
355 | 355 | $no_export_fields = FrmField::no_save_fields(); |
@@ -363,16 +363,16 @@ discard block |
||
363 | 363 | } |
364 | 364 | |
365 | 365 | public static function allow_mime( $mimes ) { |
366 | - if ( ! isset( $mimes['csv'] ) ) { |
|
367 | - // allow csv files |
|
368 | - $mimes['csv'] = 'text/csv'; |
|
369 | - } |
|
370 | - |
|
371 | - if ( ! isset( $mimes['xml'] ) ) { |
|
372 | - // allow xml |
|
373 | - $mimes['xml'] = 'text/xml'; |
|
374 | - } |
|
375 | - |
|
376 | - return $mimes; |
|
377 | - } |
|
366 | + if ( ! isset( $mimes['csv'] ) ) { |
|
367 | + // allow csv files |
|
368 | + $mimes['csv'] = 'text/csv'; |
|
369 | + } |
|
370 | + |
|
371 | + if ( ! isset( $mimes['xml'] ) ) { |
|
372 | + // allow xml |
|
373 | + $mimes['xml'] = 'text/xml'; |
|
374 | + } |
|
375 | + |
|
376 | + return $mimes; |
|
377 | + } |
|
378 | 378 | } |