public static function import_xml_entries($entries, $imported) { global $frm_duplicate_ids, $wpdb; $saved_entries = array(); $track_child_ids = array(); // Import all child entries first self::put_child_entries_first($entries); foreach ($entries as $item) { $entry = array('id' => (int) $item->id, 'item_key' => (string) $item->item_key, 'name' => (string) $item->name, 'description' => FrmAppHelper::maybe_json_decode((string) $item->description), 'ip' => (string) $item->ip, 'form_id' => isset($imported['forms'][(int) $item->form_id]) ? $imported['forms'][(int) $item->form_id] : (int) $item->form_id, 'post_id' => isset($imported['posts'][(int) $item->post_id]) ? $imported['posts'][(int) $item->post_id] : (int) $item->post_id, 'user_id' => FrmAppHelper::get_user_id_param((string) $item->user_id), 'parent_item_id' => (int) $item->parent_item_id, 'is_draft' => (int) $item->is_draft, 'updated_by' => FrmAppHelper::get_user_id_param((string) $item->updated_by), 'created_at' => (string) $item->created_at, 'updated_at' => (string) $item->updated_at); $metas = array(); foreach ($item->item_meta as $meta) { $field_id = (int) $meta->field_id; if (is_array($frm_duplicate_ids) && isset($frm_duplicate_ids[$field_id])) { $field_id = $frm_duplicate_ids[$field_id]; } $field = FrmField::getOne($field_id); if (!$field) { continue; } $metas[$field_id] = FrmAppHelper::maybe_json_decode((string) $meta->meta_value); $metas[$field_id] = apply_filters('frm_import_val', $metas[$field_id], $field); self::convert_field_values($field, $field_id, $metas, $saved_entries); if ($field->type == 'user_id' && $metas[$field_id] && is_numeric($metas[$field_id])) { $entry['frm_user_id'] = $metas[$field_id]; } unset($field, $meta); } unset($item); $entry['item_meta'] = $metas; unset($metas); // edit entry if the key and created time match $editing = FrmDb::get_var('frm_items', array('item_key' => $entry['item_key'], 'created_at' => date('Y-m-d H:i:s', strtotime($entry['created_at'])))); if ($editing) { FrmEntry::update_entry_from_xml($entry['id'], $entry); $imported['updated']['items']++; $saved_entries[$entry['id']] = $entry['id']; } else { if ($e = FrmEntry::create_entry_from_xml($entry)) { $saved_entries[$entry['id']] = $e; $imported['imported']['items']++; } } self::track_imported_child_entries($saved_entries[$entry['id']], $entry['parent_item_id'], $track_child_ids); unset($entry); } self::update_parent_item_ids($track_child_ids, $saved_entries); unset($entries); return $imported; }
private static function populate_postmeta(&$post, $meta, $imported) { global $frm_duplicate_ids; $m = array('key' => (string) $meta->meta_key, 'value' => (string) $meta->meta_value); //switch old form and field ids to new ones if ($m['key'] == 'frm_form_id' && isset($imported['forms'][(int) $m['value']])) { $m['value'] = $imported['forms'][(int) $m['value']]; } else { $m['value'] = FrmAppHelper::maybe_json_decode($m['value']); if (!empty($frm_duplicate_ids)) { if ($m['key'] == 'frm_dyncontent') { $m['value'] = FrmFieldsHelper::switch_field_ids($m['value']); } else { if ($m['key'] == 'frm_options') { foreach (array('date_field_id', 'edate_field_id') as $setting_name) { if (isset($m['value'][$setting_name]) && is_numeric($m['value'][$setting_name]) && isset($frm_duplicate_ids[$m['value'][$setting_name]])) { $m['value'][$setting_name] = $frm_duplicate_ids[$m['value'][$setting_name]]; } } $check_dup_array = array(); if (isset($m['value']['order_by']) && !empty($m['value']['order_by'])) { if (is_numeric($m['value']['order_by']) && isset($frm_duplicate_ids[$m['value']['order_by']])) { $m['value']['order_by'] = $frm_duplicate_ids[$m['value']['order_by']]; } else { if (is_array($m['value']['order_by'])) { $check_dup_array[] = 'order_by'; } } } if (isset($m['value']['where']) && !empty($m['value']['where'])) { $check_dup_array[] = 'where'; } foreach ($check_dup_array as $check_k) { foreach ((array) $m['value'][$check_k] as $mk => $mv) { if (isset($frm_duplicate_ids[$mv])) { $m['value'][$check_k][$mk] = $frm_duplicate_ids[$mv]; } unset($mk, $mv); } } } } } } if (!is_array($m['value'])) { $m['value'] = FrmAppHelper::maybe_json_decode($m['value']); } $post['postmeta'][(string) $meta->meta_key] = $m['value']; }
public function prepare_action($action) { $action->post_content = (array) FrmAppHelper::maybe_json_decode($action->post_content); $action->post_excerpt = sanitize_title($action->post_excerpt); $default_values = $this->get_global_defaults(); // fill default values $action->post_content += $default_values; foreach ($default_values as $k => $vals) { if (is_array($vals) && !empty($vals)) { if ('event' == $k && !$this->action_options['force_event'] && !empty($action->post_content[$k])) { continue; } $action->post_content[$k] = wp_parse_args($action->post_content[$k], $vals); } } if (!is_array($action->post_content['event'])) { $action->post_content['event'] = explode(',', $action->post_content['event']); } return $action; }
public function get_all($orderby = 'title', $order = 'ASC', $limit = 99) { $post_atts = array('post_type' => FrmStylesController::$post_type, 'post_status' => 'publish', 'numberposts' => $limit, 'orderby' => $orderby, 'order' => $order); $temp_styles = FrmAppHelper::check_cache(serialize($post_atts), 'frm_styles', $post_atts, 'get_posts'); if (empty($temp_styles)) { global $wpdb; // make sure there wasn't a conflict with the query $query = $wpdb->prepare('SELECT * FROM ' . $wpdb->posts . ' WHERE post_type=%s AND post_status=%s ORDER BY post_title ASC LIMIT 99', FrmStylesController::$post_type, 'publish'); $temp_styles = FrmAppHelper::check_cache('frm_backup_style_check', 'frm_styles', $query, 'get_results'); if (empty($temp_styles)) { // create a new style if there are none $new = $this->get_new(); $new->post_title = $new->post_name = __('Formidable Style', 'formidable'); $new->menu_order = 1; $new = $this->save((array) $new); $this->update('default'); $post_atts['include'] = $new; $temp_styles = get_posts($post_atts); } } $default_values = $this->get_defaults(); $default_style = false; $styles = array(); foreach ($temp_styles as $style) { $this->id = $style->ID; if ($style->menu_order) { if ($default_style) { // only return one default $style->menu_order = 0; } else { // check for a default style $default_style = $style->ID; } } $style->post_content = FrmAppHelper::maybe_json_decode($style->post_content); // fill default values $style->post_content = $this->override_defaults($style->post_content); $style->post_content = wp_parse_args($style->post_content, $default_values); $styles[$style->ID] = $style; } if (!$default_style) { $default_style = reset($styles); $styles[$default_style->ID]->menu_order = 1; } return $styles; }
public static function import_xml_forms($forms, $imported) { $frm_form = new FrmForm(); $frm_field = new FrmField(); foreach ($forms as $item) { $form = array('id' => (int) $item->id, 'form_key' => (string) $item->form_key, 'name' => (string) $item->name, 'description' => (string) $item->description, 'options' => (string) $item->options, 'logged_in' => (int) $item->logged_in, 'is_template' => (int) $item->is_template, 'default_template' => (int) $item->default_template, 'editable' => (int) $item->editable, 'status' => (string) $item->status, 'created_at' => date('Y-m-d H:i:s', strtotime((string) $item->created_at))); $form['options'] = FrmAppHelper::maybe_json_decode($form['options']); // if template, allow to edit if form keys match, otherwise, creation date must also match $edit_query = array('form_key' => $form['form_key'], 'is_template' => $form['is_template']); if (!$form['is_template']) { $edit_query['created_at'] = $form['created_at']; } $edit_query = apply_filters('frm_match_xml_form', $edit_query, $form); $this_form = $frm_form->getAll($edit_query, '', 1); unset($edit_query); if (!empty($this_form)) { $form_id = $this_form->id; $frm_form->update($form_id, $form); $imported['updated']['forms']++; $form_fields = $frm_field->getAll(array('fi.form_id' => $form_id), 'field_order'); $old_fields = array(); foreach ($form_fields as $f) { $old_fields[$f->id] = $f; $old_fields[$f->field_key] = $f->id; unset($f); } $form_fields = $old_fields; unset($old_fields); } else { //form does not exist, so create it if ($form_id = $frm_form->create($form)) { $imported['imported']['forms']++; } } foreach ($item->field as $field) { $f = array('id' => (int) $field->id, 'field_key' => (string) $field->field_key, 'name' => (string) $field->name, 'description' => (string) $field->description, 'type' => (string) $field->type, 'default_value' => FrmAppHelper::maybe_json_decode((string) $field->default_value), 'field_order' => (int) $field->field_order, 'form_id' => (int) $form_id, 'required' => (int) $field->required, 'options' => FrmAppHelper::maybe_json_decode((string) $field->options), 'field_options' => FrmAppHelper::maybe_json_decode((string) $field->field_options)); if (is_array($f['default_value']) && in_array($f['type'], array('text', 'email', 'url', 'textarea', 'number', 'phone', 'date', 'time', 'image', 'hidden', 'password', 'tag'))) { if (count($f['default_value']) === 1) { $f['default_value'] = '[' . reset($f['default_value']) . ']'; } else { $f['default_value'] = reset($f['default_value']); } } $f = apply_filters('frm_duplicated_field', $f); if ($this_form) { // check for field to edit by field id if (isset($form_fields[$f['id']])) { $frm_field->update($f['id'], $f); $imported['updated']['fields']++; unset($form_fields[$f['id']]); //unset old field key if (isset($form_fields[$f['field_key']])) { unset($form_fields[$f['field_key']]); } } else { if (isset($form_fields[$f['field_key']])) { // check for field to edit by field key unset($f['id']); $frm_field->update($form_fields[$f['field_key']], $f); $imported['updated']['fields']++; unset($form_fields[$form_fields[$f['field_key']]]); //unset old field id unset($form_fields[$f['field_key']]); //unset old field key } else { if ($frm_field->create($f)) { // if no matching field id or key in this form, create the field $imported['imported']['fields']++; } } } } else { if ($frm_field->create($f)) { $imported['imported']['fields']++; } } unset($field); } // Delete any fields attached to this form that were not included in the template if (isset($form_fields) && !empty($form_fields)) { foreach ($form_fields as $field) { if (is_object($field)) { $frm_field->destroy($field->id); } unset($field); } unset($form_fields); } // Update field ids/keys to new ones do_action('frm_after_duplicate_form', $form_id, $form); $imported['forms'][(int) $item->id] = $form_id; unset($form); unset($item); } unset($frm_form); unset($frm_field); return $imported; }
public static function import_xml_entries($entries, $imported) { global $frm_duplicate_ids, $wpdb, $frm_field; $frm_entry = new FrmEntry(); $saved_entries = array(); foreach ($entries as $item) { $entry = array('id' => (int) $item->id, 'item_key' => (string) $item->item_key, 'name' => (string) $item->name, 'description' => FrmAppHelper::maybe_json_decode((string) $item->description), 'ip' => (string) $item->ip, 'form_id' => isset($imported['forms'][(int) $item->form_id]) ? $imported['forms'][(int) $item->form_id] : (int) $item->form_id, 'post_id' => isset($imported['posts'][(int) $item->post_id]) ? $imported['posts'][(int) $item->post_id] : (int) $item->post_id, 'user_id' => FrmProAppHelper::get_user_id_param((string) $item->user_id), 'parent_item_id' => (int) $item->parent_item_id, 'is_draft' => (int) $item->is_draft, 'updated_by' => FrmProAppHelper::get_user_id_param((string) $item->updated_by), 'created_at' => (string) $item->created_at, 'updated_at' => (string) $item->updated_at); $metas = array(); foreach ($item->item_meta as $meta) { $field_id = (int) $meta->field_id; if (is_array($frm_duplicate_ids) && isset($frm_duplicate_ids[$field_id])) { $field_id = $frm_duplicate_ids[$field_id]; } $field = $frm_field->getOne($field_id); if (!$field) { continue; } $metas[$field_id] = FrmAppHelper::maybe_json_decode((string) $meta->meta_value); $metas[$field_id] = apply_filters('frm_import_val', $metas[$field_id], $field); switch ($field->type) { case 'user_id': $metas[$field_id] = FrmProAppHelper::get_user_id_param($metas[$field_id]); if ($metas[$field_id] && is_numeric($metas[$field_id])) { $entry['frm_user_id'] = $metas[$field_id]; } break; case 'file': $metas[$field_id] = self::get_file_id($metas[$field_id]); break; case 'date': $metas[$field_id] = self::get_date($metas[$field_id]); break; case 'data': $metas[$field_id] = self::get_dfe_id($metas[$field_id], $field, $saved_entries, $metas); break; case 'select': case 'checkbox': $metas[$field_id] = self::get_multi_opts($metas[$field_id], $field); break; } unset($field); unset($meta); } unset($item); $entry['item_meta'] = $metas; unset($metas); // edit entry if the key and created time match $editing = $wpdb->get_var($wpdb->prepare("SELECT id FROM {$wpdb->prefix}frm_items WHERE item_key=%s AND created_at=%s", $entry['item_key'], date('Y-m-d H:i:s', strtotime($entry['created_at'])))); if ($editing) { $frm_entry->update($entry['id'], $entry); $imported['updated']['items']++; $saved_entries[$entry['id']] = $entry['id']; } else { if ($e = $frm_entry->create($entry)) { $saved_entries[$entry['id']] = $e; $imported['imported']['items']++; } } unset($entry); } unset($entries); return $imported; }