function _setup_test_update_values($entry)
 {
     $form = FrmForm::getOne($entry->form_id);
     $this->set_current_user_to_1();
     $values = array('form_id' => $entry->form_id, 'frm_hide_fields_' . $entry->form_id => '', 'frm_helers_' . $entry->form_id => '', 'form_key' => $form->form_key, 'item_meta' => $entry->metas, 'frm_submit_entry_' . $entry->form_id => wp_create_nonce('frm_submit_entry_' . $entry->form_id), '_wp_http_referer' => '/features/create-a-post-no-categories/?frm_action=edit&entry=' . $entry->id, 'id' => $entry->id, 'item_key' => $entry->item_key, 'item_name' => $entry->name, 'frm_user_id' => $entry->user_id, 'frm_skip_cookie' => 1);
     return $values;
 }
Exemplo n.º 2
0
 function user_can_edit_check($entry, $form)
 {
     global $user_ID;
     if (!$user_ID) {
         return false;
     }
     if (is_numeric($form)) {
         $form = FrmForm::getOne($form);
     }
     $form->options = maybe_unserialize($form->options);
     //if editable and user can edit someone elses entry
     if ($form->editable and isset($form->options['open_editable']) and $form->options['open_editable'] and isset($form->options['open_editable_role']) and FrmAppHelper::user_has_permission($form->options['open_editable_role'])) {
         return true;
     }
     if (is_object($entry)) {
         if ($entry->user_id == $user_ID) {
             return true;
         } else {
             return false;
         }
     }
     $where = "user_id='{$user_ID}' and fr.id='{$form->id}'";
     if ($entry and !empty($entry)) {
         if (is_numeric($entry)) {
             $where .= ' and it.id=' . $entry;
         } else {
             $where .= " and item_key='" . $entry . "'";
         }
     }
     return FrmEntry::getAll($where, '', ' LIMIT 1', true);
 }
 public static function show()
 {
     FrmAppHelper::permission_check('frm_view_reports');
     remove_action('frm_form_action_reports', 'FrmStatisticsController::list_reports');
     add_filter('frm_form_stop_action_reports', '__return_true');
     global $wpdb;
     $form = false;
     if (isset($_REQUEST['form'])) {
         $form = FrmForm::getOne($_REQUEST['form']);
     }
     if (!$form) {
         require FrmAppHelper::plugin_path() . '/pro/classes/views/frmpro-statistics/select.php';
         return;
     }
     $exclude_types = FrmField::no_save_fields();
     $exclude_types = array_merge($exclude_types, array('rte', 'textarea', 'file', 'grid', 'signature', 'form', 'table'));
     $fields = FrmField::getAll(array('fi.form_id' => (int) $form->id, 'fi.type not' => $exclude_types), 'field_order');
     $js = '';
     $data = array();
     $colors = '#21759B,#EF8C08,#C6C6C6';
     $data['time'] = self::get_daily_entries($form, array('is3d' => true, 'colors' => $colors, 'bg_color' => 'transparent'));
     $data['month'] = self::get_daily_entries($form, array('is3d' => true, 'colors' => $colors, 'bg_color' => 'transparent', 'width' => '100%'), 'MONTH');
     foreach ($fields as $field) {
         $this_data = self::graph_shortcode(array('id' => $field->id, 'field' => $field, 'is3d' => true, 'min' => 0, 'colors' => $colors, 'width' => 650, 'bg_color' => 'transparent'));
         if (strpos($this_data, 'frm_no_data_graph') === false) {
             $data[$field->id] = $this_data;
         }
         unset($field, $this_data);
     }
     $entries = FrmDb::get_col($wpdb->prefix . 'frm_items', array('form_id' => $form->id), 'created_at');
     // trigger the scripts to load
     global $frm_vars;
     $frm_vars['forms_loaded'][] = true;
     include FrmAppHelper::plugin_path() . '/pro/classes/views/frmpro-statistics/show.php';
 }
Exemplo n.º 4
0
 function create($values)
 {
     global $wpdb, $blog_id, $frmpro_display;
     $exists = $wpdb->query("DESCRIBE {$this->table_name}");
     if (!$exists) {
         $this->install(true);
     }
     unset($exists);
     $new_values = array();
     $new_values['blog_id'] = $blog_id;
     $new_values['form_id'] = isset($values['form_id']) ? (int) $values['form_id'] : null;
     $new_values['type'] = isset($values['type']) ? $values['type'] : 'form';
     //options here are: form, display
     if ($new_values['type'] == 'form') {
         $frm_form = new FrmForm();
         $form_copied = $frm_form->getOne($new_values['form_id']);
         $new_values['copy_key'] = $form_copied->form_key;
     } else {
         $form_copied = $frmpro_display->getOne($new_values['form_id']);
         $new_values['copy_key'] = $form_copied->post_name;
     }
     $new_values['created_at'] = current_time('mysql', 1);
     $exists = $this->getAll(array('blog_id' => $blog_id, 'form_id' => $new_values['form_id'], 'type' => $new_values['type']), '', ' LIMIT 1');
     if ($exists) {
         return false;
     }
     $query_results = $wpdb->insert($this->table_name, $new_values);
     if ($query_results) {
         return $wpdb->insert_id;
     } else {
         return false;
     }
 }
 public static function add_form_nav($views)
 {
     if (!FrmProDisplaysHelper::is_edit_view_page()) {
         return $views;
     }
     $form = isset($_REQUEST['form']) && is_numeric($_REQUEST['form']) ? $_REQUEST['form'] : false;
     if (!$form) {
         return $views;
     }
     $form = FrmForm::getOne($form);
     if (!$form) {
         return $views;
     }
     echo '<div id="poststuff">';
     echo '<div id="post-body" class="metabox-holder columns-2">';
     echo '<div id="post-body-content">';
     FrmAppController::get_form_nav($form, true, 'hide');
     echo '</div>';
     echo '<div class="clear"></div>';
     echo '</div>';
     echo '<div id="titlediv"><input id="title" type="text" value="' . esc_attr($form->name == '' ? __('(no title)') : $form->name) . '" readonly="readonly" disabled="disabled" /></div>';
     echo '</div>';
     echo '<style type="text/css">p.search-box{margin-top:-91px;}</style>';
     return $views;
 }
Exemplo n.º 6
0
 public static function create($values)
 {
     global $wpdb, $blog_id;
     $exists = $wpdb->query('DESCRIBE ' . self::table_name());
     if (!$exists) {
         self::install(true);
     }
     unset($exists);
     $new_values = array();
     $new_values['blog_id'] = $blog_id;
     $new_values['form_id'] = isset($values['form_id']) ? (int) $values['form_id'] : null;
     $new_values['type'] = isset($values['type']) ? $values['type'] : 'form';
     //options here are: form, display
     if ($new_values['type'] == 'form') {
         $form_copied = FrmForm::getOne($new_values['form_id']);
         $new_values['copy_key'] = $form_copied->form_key;
     } else {
         $form_copied = FrmProDisplay::getOne($new_values['form_id']);
         $new_values['copy_key'] = $form_copied->post_name;
     }
     $new_values['created_at'] = current_time('mysql', 1);
     $exists = self::getAll(array('blog_id' => $blog_id, 'form_id' => $new_values['form_id'], 'type' => $new_values['type']), '', ' LIMIT 1');
     if ($exists) {
         return false;
     }
     $query_results = $wpdb->insert(self::table_name(), $new_values);
     if ($query_results) {
         return $wpdb->insert_id;
     } else {
         return false;
     }
 }
Exemplo n.º 7
0
 function duplicate($id, $template = false, $copy_keys = false, $blog_id = false)
 {
     global $wpdb;
     $frm_form = new FrmForm();
     $values = $frm_form->getOne($id, $blog_id);
     if (!$values) {
         return false;
     }
     $new_key = $copy_keys ? $values->form_key : '';
     $new_values = array('form_key' => FrmAppHelper::get_unique_key($new_key, $wpdb->prefix . 'frm_forms', 'form_key'), 'name' => $values->name, 'description' => $values->description, 'status' => $template ? '' : 'draft', 'logged_in' => $values->logged_in ? $values->logged_in : 0, 'editable' => $values->editable ? $values->editable : 0, 'created_at' => current_time('mysql', 1), 'is_template' => $template ? 1 : 0);
     if ($blog_id) {
         $new_values['status'] = 'published';
         $new_options = maybe_unserialize($values->options);
         $new_options['email_to'] = get_option('admin_email');
         $new_options['copy'] = false;
         $new_values['options'] = $new_options;
     } else {
         $new_values['options'] = $values->options;
     }
     if (is_array($new_values['options'])) {
         $new_values['options'] = serialize($new_values['options']);
     }
     $query_results = $wpdb->insert($wpdb->prefix . 'frm_forms', $new_values);
     if ($query_results) {
         global $frm_field;
         $form_id = $wpdb->insert_id;
         $frm_field->duplicate($id, $form_id, $copy_keys, $blog_id);
         // update form settings after fields are created
         do_action('frm_after_duplicate_form', $form_id, $new_values);
         return $form_id;
     } else {
         return false;
     }
 }
Exemplo n.º 8
0
 function import_xml()
 {
     // install test data in older format
     add_filter('frm_default_templates_files', 'FrmUnitTest::install_data');
     FrmXMLController::add_default_templates();
     $form = FrmForm::getOne('contact-db12');
     $this->assertEquals($form->form_key, 'contact-db12');
 }
 /**
  * @covers FrmXMLHelper::track_repeating_fields
  * @covers FrmXMLHelper::update_repeat_field_options
  */
 public function _check_form_select($f, $expected_form_key)
 {
     $this->assertNotEmpty($f->field_options['form_select'], 'Imported repeating section has a blank form_select.');
     // Check if the form_select setting matches the correct form
     $nested_form = FrmForm::getOne($f->field_options['form_select']);
     $this->assertNotEmpty($nested_form, 'The form_select in an imported repeating section is not updating correctly.');
     $this->assertEquals($expected_form_key, $nested_form->form_key, 'The form_select is not updating properly when a repeating section is imported.');
 }
Exemplo n.º 10
0
 function entry_created($entry_id, $form_id)
 {
     if (apply_filters('frm_stop_standard_email', false, $entry_id)) {
         return;
     }
     global $frm_entry, $frm_entry_meta;
     $entry = $frm_entry->getOne($entry_id, true);
     $frm_form = new FrmForm();
     $form = $frm_form->getOne($form_id);
     $values = $frm_entry_meta->getAll("it.item_id = {$entry_id}", " ORDER BY fi.field_order");
     if (isset($form->options['notification'])) {
         $notification = reset($form->options['notification']);
     } else {
         $notification = $form->options;
     }
     // Set the from and to email names and addresses
     $to_email = $notification['email_to'];
     if (empty($to_email)) {
         $to_email = '[admin_email]';
     }
     $to_emails = explode(',', $to_email);
     $reply_to = $reply_to_name = '';
     foreach ($values as $value) {
         $val = apply_filters('frm_email_value', maybe_unserialize($value->meta_value), $value, $entry);
         if (is_array($val)) {
             $val = implode(', ', $val);
         }
         if (isset($notification['reply_to']) and (int) $notification['reply_to'] == $value->field_id and is_email($val)) {
             $reply_to = $val;
         }
         if (isset($notification['reply_to_name']) and (int) $notification['reply_to_name'] == $value->field_id) {
             $reply_to_name = $val;
         }
     }
     if (empty($reply_to) && $notification['reply_to'] == 'custom') {
         $reply_to = $notification['cust_reply_to'];
     }
     if (empty($reply_to_name) && $notification['reply_to_name'] == 'custom') {
         $reply_to_name = $notification['cust_reply_to_name'];
     }
     // Set the email message
     $plain_text = isset($notification['plain_text']) && $notification['plain_text'] ? true : false;
     $mail_body = isset($notification['email_message']) ? $notification['email_message'] : '';
     $mail_body = FrmEntriesHelper::replace_default_message($mail_body, array('id' => $entry->id, 'entry' => $entry, 'plain_text' => $plain_text, 'user_info' => isset($notification['inc_user_info']) ? $notification['inc_user_info'] : false));
     // Set the subject
     $subject = isset($notification['email_subject']) ? $notification['email_subject'] : '';
     if (empty($subject)) {
         $frm_blogname = wp_specialchars_decode(get_option('blogname'), ENT_QUOTES);
         $subject = sprintf(__('%1$s Form submitted on %2$s', 'formidable'), $form->name, $frm_blogname);
     }
     // Send the emails now
     foreach ((array) $to_emails as $to_email) {
         $this->send_notification_email(trim($to_email), $subject, $mail_body, $reply_to, $reply_to_name, $plain_text);
     }
 }
 public static function _logic_row()
 {
     check_ajax_referer('frm_ajax', 'nonce');
     $meta_name = FrmAppHelper::get_param('meta_name', '', 'get', 'sanitize_title');
     $form_id = FrmAppHelper::get_param('form_id', '', 'get', 'absint');
     $key = FrmAppHelper::get_param('email_id', '', 'get', 'sanitize_title');
     $type = FrmAppHelper::get_param('type', '', 'get', 'sanitize_title');
     $form = FrmForm::getOne($form_id);
     FrmProFormsController::include_logic_row(array('form_id' => $form->id, 'form' => $form, 'meta_name' => $meta_name, 'condition' => array('hide_field_cond' => '==', 'hide_field' => ''), 'key' => $key, 'name' => 'frm_' . $type . '_action[' . $key . '][post_content][conditions][' . $meta_name . ']'));
     wp_die();
 }
Exemplo n.º 12
0
 function duplicate($id, $copy_keys = false, $blog_id = false)
 {
     global $wpdb;
     $values = $this->getOne($id, $blog_id, true);
     if (!$values or !is_numeric($values->frm_form_id)) {
         return false;
     }
     $new_values = array();
     foreach (array('post_name', 'post_title', 'post_excerpt', 'post_content', 'post_status', 'post_type') as $k) {
         $new_values[$k] = $values->{$k};
         unset($k);
     }
     $meta = array();
     foreach (array('form_id', 'entry_id', 'post_id', 'dyncontent', 'param', 'type', 'show_count', 'insert_loc') as $k) {
         $meta[$k] = $values->{'frm_' . $k};
         unset($k);
     }
     $default = FrmProDisplaysHelper::get_default_opts();
     $meta['options'] = array();
     foreach ($default as $k => $v) {
         if (isset($meta[$k])) {
             continue;
         }
         $meta['options'][$k] = $values->{'frm_' . $k};
         unset($k);
         unset($v);
     }
     $meta['options']['copy'] = false;
     if ($blog_id) {
         $frm_form = new FrmForm();
         $old_form = $frm_form->getOne($values->frm_form_id, $blog_id);
         $new_form = $frm_form->getOne($old_form->form_key);
         $meta['form_id'] = $new_form->id;
     } else {
         $meta['form_id'] = $values->form_id;
     }
     $post_ID = wp_insert_post($new_values);
     $new_values = array_merge((array) $new_values, $meta);
     $this->update($post_ID, $new_values);
     return $post_ID;
 }
Exemplo n.º 13
0
 public static function save_wppost_actions($settings, $action)
 {
     $form_id = $action['menu_order'];
     if (isset($settings['post_custom_fields'])) {
         foreach ($settings['post_custom_fields'] as $cf_key => $n) {
             if (!isset($n['custom_meta_name'])) {
                 continue;
             }
             if ($n['meta_name'] == '' && $n['custom_meta_name'] != '') {
                 $settings['post_custom_fields'][$cf_key]['meta_name'] = $n['custom_meta_name'];
             }
             unset($settings['post_custom_fields'][$cf_key]['custom_meta_name']);
             unset($cf_key, $n);
         }
     }
     self::create_post_category_field($settings, $form_id);
     self::create_post_status_field($settings, $form_id);
     //update/create View
     if (!empty($settings['display_id'])) {
         if (is_numeric($settings['display_id'])) {
             //updating View
             $type = get_post_meta($settings['display_id'], 'frm_show_count', true);
             if ('one' == $type) {
                 $display = get_post($settings['display_id'], ARRAY_A);
                 $display['post_content'] = $_POST['dyncontent'];
                 wp_insert_post($display);
             } else {
                 update_post_meta($settings['display_id'], 'frm_dyncontent', $_POST['dyncontent']);
             }
         } else {
             if ('new' == $settings['display_id']) {
                 // Get form name for View title
                 $form = FrmForm::getOne($form_id);
                 if (!empty($form->name)) {
                     $post_title = $form->name;
                 } else {
                     $post_title = __('Single Post', 'formidable');
                 }
                 //create new
                 $cd_values = array('post_status' => 'publish', 'post_type' => 'frm_display', 'post_title' => $post_title, 'post_excerpt' => __('Used for the single post page', 'formidable'), 'post_content' => $_POST['dyncontent']);
                 $display_id = wp_insert_post($cd_values);
                 $settings['display_id'] = $display_id;
                 unset($cd_values);
                 update_post_meta($display_id, 'frm_param', 'entry');
                 update_post_meta($display_id, 'frm_type', 'display_key');
                 update_post_meta($display_id, 'frm_show_count', 'one');
                 update_post_meta($display_id, 'frm_form_id', $form_id);
             }
         }
     }
     return $settings;
 }
 function _setup_post_values($form_id)
 {
     $fields = FrmField::get_all_for_form($form_id);
     $form = FrmForm::getOne($form_id);
     $_POST = array('page' => 'formidable', 'frm_action' => 'update', 'id' => $form_id, 'action' => 'update', 'frm_save_form' => wp_create_nonce('frm_save_form_nonce'), 'status' => 'published', 'new_status' => '', 'name' => $form->name, 'frm_fields_submitted' => array(), 'item_meta' => array(), 'field_options' => array());
     foreach ($fields as $field) {
         $_POST['frm_fields_submitted'][] = $field->id;
         $_POST['item_meta'][$field->id] = 'default';
         $field_options = array('description_' . $field->id => '', 'type_' . $field->id => '', 'required_indicator_' . $field->id => '*', 'field_key_' . $field->id => $field->field_key, 'classes_' . $field->id => '', 'label_' . $field->id => '', 'size_' . $field->id => '', 'max_' . $field->id => '', 'admin_only_' . $field->id => '', 'use_calc_' . $field->id => 1, 'calc_' . $field->id => '', 'calc_dec_' . $field->id => '', 'show_hide_' . $field->id => 'show', 'any_all_' . $field->id => 'any', 'blank_' . $field->id => 'This field cannot be blank.', 'unique_msg_' . $field->id => '');
         $_POST['field_options'] = array_merge($_POST['field_options'], $field_options);
         $_REQUEST = $_POST;
     }
 }
 public function no_items()
 {
     $s = isset($_REQUEST['s']) ? $_REQUEST['s'] : '';
     if (!empty($s)) {
         _e('No Entries Found', 'formidable');
         return;
     }
     $form_id = $form = $this->params['form'];
     if ($form_id) {
         $form = FrmForm::getOne($form_id);
     }
     $colspan = $this->get_column_count();
     include FrmAppHelper::plugin_path() . '/classes/views/frm-entries/no_entries.php';
 }
Exemplo n.º 16
0
 /**
  * @covers FrmForm::destroy
  */
 function test_destroy()
 {
     $forms = FrmForm::getAll();
     $this->assertNotEmpty(count($forms));
     foreach ($forms as $form) {
         if ($form->is_template) {
             continue;
         }
         $id = FrmForm::destroy($form->id);
         $form_exists = FrmForm::getOne($form->id);
         $this->assertEmpty($form_exists, 'Failed to delete form ' . $form->form_key);
         $subforms_exist = FrmForm::getAll(array('parent_form_id' => $form->id));
         $this->assertEmpty($subforms_exist, 'Failed to delete child forms for parent form ' . $form->form_key);
     }
 }
Exemplo n.º 17
0
 public static function get_form_nav($id, $show_nav = false)
 {
     global $pagenow, $frm_vars;
     $show_nav = FrmAppHelper::get_param('show_nav', $show_nav);
     if (!$show_nav) {
         return;
     }
     $current_page = isset($_GET['page']) ? $_GET['page'] : (isset($_GET['post_type']) ? $_GET['post_type'] : 'None');
     if ($id and is_numeric($id)) {
         $frm_form = new FrmForm();
         $form = $frm_form->getOne($id);
         unset($frm_form);
     } else {
         $form = false;
     }
     include FrmAppHelper::plugin_path() . '/classes/views/shared/form-nav.php';
 }
Exemplo n.º 18
0
 public static function setup_new_vars($fields, $form = '', $reset = false, $args = array())
 {
     global $frm_vars;
     $values = array();
     foreach (array('name' => '', 'description' => '', 'item_key' => '') as $var => $default) {
         $values[$var] = FrmAppHelper::get_post_param($var, $default);
     }
     $values['fields'] = array();
     if (empty($fields)) {
         return apply_filters('frm_setup_new_entry', $values);
     }
     foreach ((array) $fields as $field) {
         $new_value = self::get_field_value_for_new_entry($field, $reset);
         $field_array = array('id' => $field->id, 'value' => $new_value, 'default_value' => $field->default_value, 'name' => $field->name, 'description' => $field->description, 'type' => apply_filters('frm_field_type', $field->type, $field, $new_value), 'options' => $field->options, 'required' => $field->required, 'field_key' => $field->field_key, 'field_order' => $field->field_order, 'form_id' => $field->form_id, 'parent_form_id' => isset($args['parent_form_id']) ? $args['parent_form_id'] : $field->form_id);
         $opt_defaults = FrmFieldsHelper::get_default_field_opts($field_array['type'], $field, true);
         $opt_defaults['required_indicator'] = '';
         $opt_defaults['original_type'] = $field->type;
         foreach ($opt_defaults as $opt => $default_opt) {
             $field_array[$opt] = isset($field->field_options[$opt]) && $field->field_options[$opt] != '' ? $field->field_options[$opt] : $default_opt;
             unset($opt, $default_opt);
         }
         unset($opt_defaults);
         if ($field_array['custom_html'] == '') {
             $field_array['custom_html'] = FrmFieldsHelper::get_default_html($field->type);
         }
         $field_array = apply_filters('frm_setup_new_fields_vars', $field_array, $field);
         $field_array = array_merge($field->field_options, $field_array);
         $values['fields'][] = $field_array;
         if (!$form || !isset($form->id)) {
             $form = FrmForm::getOne($field->form_id);
         }
     }
     $form->options = maybe_unserialize($form->options);
     if (is_array($form->options)) {
         foreach ($form->options as $opt => $value) {
             $values[$opt] = FrmAppHelper::get_post_param($opt, $value);
             unset($opt, $value);
         }
     }
     $form_defaults = FrmFormsHelper::get_default_opts();
     $frm_settings = FrmAppHelper::get_settings();
     $form_defaults['custom_style'] = $frm_settings->load_style != 'none';
     $values = array_merge($form_defaults, $values);
     return apply_filters('frm_setup_new_entry', $values);
 }
 public static function show()
 {
     global $frmdb, $frm_field, $frm_entry_meta, $frm_entry, $wpdb;
     if (!isset($_GET['form'])) {
         require FrmAppHelper::plugin_path() . '/pro/classes/views/frmpro-statistics/show.php';
         return;
     }
     $frm_form = new FrmForm();
     $form = $frm_form->getOne($_GET['form']);
     $form_options = maybe_unserialize($form->options);
     $fields = $frm_field->getAll("fi.type not in ('divider','captcha','break','rte','textarea','file','grid','html','signature','table') and fi.form_id=" . (int) $form->id, 'field_order ASC');
     $js = '';
     $data = array();
     $colors = '#21759B,#EF8C08,#C6C6C6';
     $data['time'] = self::get_daily_entries($form, array('is3d' => true, 'colors' => $colors));
     $data['month'] = self::get_daily_entries($form, array('is3d' => true, 'colors' => $colors), 'MONTH');
     foreach ($fields as $field) {
         $data[$field->id] = self::graph_shortcode(array('id' => $field->id, 'field' => $field, 'is3d' => true, 'min' => 0, 'colors' => $colors, 'width' => 650));
         unset($field);
     }
     include FrmAppHelper::plugin_path() . '/pro/classes/views/frmpro-statistics/show.php';
 }
Exemplo n.º 20
0
 /**
  * @covers FrmDb::migrate_to_17
  */
 function test_migrate_from_12_to_17()
 {
     $this->frm_install();
     update_option('frm_db_version', 12);
     $form = FrmForm::getOne('contact-db12');
     $this->assertNotEmpty($form);
     $this->assertTrue(is_numeric($form->id));
     $notification = array(0 => array('email_to' => '*****@*****.**', 'also_email_to' => array(1, 2), 'reply_to' => '*****@*****.**', 'reply_to_name' => 'Reply to me', 'cust_reply_to' => '', 'cust_reply_to_name' => '', 'plain_text' => 1, 'email_message' => 'This is my email message. [default-message]', 'email_subject' => 'The subject', 'update_email' => 2, 'inc_user_info' => 1));
     $form->options['notification'] = $notification;
     global $wpdb;
     $updated = $wpdb->update($wpdb->prefix . 'frm_forms', array('options' => maybe_serialize($form->options)), array('id' => $form->id));
     FrmForm::clear_form_cache();
     $this->assertEquals($updated, 1);
     $form = FrmForm::getOne('contact-db12');
     $this->assertNotEmpty($form->options, 'The form settings are empty');
     $this->assertTrue(isset($form->options['notification']), 'The old notification settings are missing');
     $this->assertEquals($form->options['notification'][0]['email_to'], '*****@*****.**');
     // migrate data
     FrmAppController::install();
     $form_actions = FrmFormAction::get_action_for_form($form->id, 'email');
     foreach ($form_actions as $action) {
         $this->assertTrue(strpos($action->post_content['email_to'], '*****@*****.**') !== false);
     }
 }
Exemplo n.º 21
0
 function get_object_by_id($form_id)
 {
     return FrmForm::getOne($form_id);
 }
Exemplo n.º 22
0
 public static function generate_xml($type, $args = array())
 {
     global $wpdb;
     $type = (array) $type;
     if (in_array('items', $type) && !in_array('forms', $type)) {
         // make sure the form is included if there are entries
         $type[] = 'forms';
     }
     if (in_array('forms', $type)) {
         // include actions with forms
         $type[] = 'actions';
     }
     $tables = array('items' => $wpdb->prefix . 'frm_items', 'forms' => $wpdb->prefix . 'frm_forms', 'posts' => $wpdb->posts, 'styles' => $wpdb->posts, 'actions' => $wpdb->posts);
     $defaults = array('ids' => false);
     $args = wp_parse_args($args, $defaults);
     $sitename = sanitize_key(get_bloginfo('name'));
     if (!empty($sitename)) {
         $sitename .= '.';
     }
     $filename = $sitename . 'formidable.' . date('Y-m-d') . '.xml';
     header('Content-Description: File Transfer');
     header('Content-Disposition: attachment; filename=' . $filename);
     header('Content-Type: text/xml; charset=' . get_option('blog_charset'), true);
     //make sure ids are numeric
     if (is_array($args['ids']) && !empty($args['ids'])) {
         $args['ids'] = array_filter($args['ids'], 'is_numeric');
     }
     $records = array();
     foreach ($type as $tb_type) {
         $where = array();
         $join = '';
         $table = $tables[$tb_type];
         $select = $table . '.id';
         $query_vars = array();
         switch ($tb_type) {
             case 'forms':
                 //add forms
                 if ($args['ids']) {
                     $where[] = array('or' => 1, $table . '.id' => $args['ids'], $table . '.parent_form_id' => $args['ids']);
                 } else {
                     $where[$table . '.status !'] = 'draft';
                 }
                 break;
             case 'actions':
                 $select = $table . '.ID';
                 $where['post_type'] = FrmFormActionsController::$action_post_type;
                 if (!empty($args['ids'])) {
                     $where['menu_order'] = $args['ids'];
                 }
                 break;
             case 'items':
                 //$join = "INNER JOIN {$wpdb->prefix}frm_item_metas im ON ($table.id = im.item_id)";
                 if ($args['ids']) {
                     $where[$table . '.form_id'] = $args['ids'];
                 }
                 break;
             case 'styles':
                 // Loop through all exported forms and get their selected style IDs
                 $form_ids = $args['ids'];
                 $style_ids = array();
                 foreach ($form_ids as $form_id) {
                     $form_data = FrmForm::getOne($form_id);
                     // For forms that have not been updated while running 2.0, check if custom_style is set
                     if (isset($form_data->options['custom_style'])) {
                         $style_ids[] = $form_data->options['custom_style'];
                     }
                     unset($form_id, $form_data);
                 }
                 $select = $table . '.ID';
                 $where['post_type'] = 'frm_styles';
                 // Only export selected styles
                 if (!empty($style_ids)) {
                     $where['ID'] = $style_ids;
                 }
                 break;
             default:
                 $select = $table . '.ID';
                 $join = ' INNER JOIN ' . $wpdb->postmeta . ' pm ON (pm.post_id=' . $table . '.ID)';
                 $where['pm.meta_key'] = 'frm_form_id';
                 if (empty($args['ids'])) {
                     $where['pm.meta_value >'] = 1;
                 } else {
                     $where['pm.meta_value'] = $args['ids'];
                 }
                 break;
         }
         $records[$tb_type] = FrmDb::get_col($table . $join, $where, $select);
         unset($tb_type);
     }
     echo '<?xml version="1.0" encoding="' . esc_attr(get_bloginfo('charset')) . "\" ?>\n";
     include FrmAppHelper::plugin_path() . '/classes/views/xml/xml.php';
 }
Exemplo n.º 23
0
    public function search_box($text, $input_id)
    {
        if (!$this->has_items() && !isset($_REQUEST['s'])) {
            return;
        }
        if (isset($this->params['form'])) {
            $form = FrmForm::getOne($this->params['form']);
        } else {
            $form = FrmForm::get_published_forms(array(), 1);
        }
        if ($form) {
            $field_list = FrmField::getAll(array('fi.form_id' => $form->id, 'fi.type not' => FrmField::no_save_fields()), 'field_order');
        }
        $fid = isset($_REQUEST['fid']) ? esc_attr(stripslashes($_REQUEST['fid'])) : '';
        $input_id = $input_id . '-search-input';
        $search_str = isset($_REQUEST['s']) ? esc_attr(stripslashes($_REQUEST['s'])) : '';
        foreach (array('orderby', 'order') as $get_var) {
            if (!empty($_REQUEST[$get_var])) {
                echo '<input type="hidden" name="' . esc_attr($get_var) . '" value="' . esc_attr($_REQUEST[$get_var]) . '" />';
            }
        }
        ?>
<div class="search-box frm_sidebar">
	<label class="screen-reader-text" for="<?php 
        echo esc_attr($input_id);
        ?>
"><?php 
        echo esc_attr($text);
        ?>
:</label>
	<input type="text" id="<?php 
        echo esc_attr($input_id);
        ?>
" name="s" value="<?php 
        echo esc_attr($search_str);
        ?>
" />
	<?php 
        if (isset($field_list) && !empty($field_list)) {
            ?>
	<select name="fid" class="hide-if-js">
		<option value="">&mdash; <?php 
            _e('All Fields', 'formidable');
            ?>
 &mdash;</option>
		<option value="created_at" <?php 
            selected($fid, 'created_at');
            ?>
><?php 
            _e('Entry creation date', 'formidable');
            ?>
</option>
		<option value="id" <?php 
            selected($fid, 'id');
            ?>
><?php 
            _e('Entry ID', 'formidable');
            ?>
</option>
		<?php 
            foreach ($field_list as $f) {
                ?>
		<option value="<?php 
                echo $f->type == 'user_id' ? 'user_id' : $f->id;
                ?>
" <?php 
                selected($fid, $f->id);
                ?>
><?php 
                echo FrmAppHelper::truncate($f->name, 30);
                ?>
</option>
		<?php 
            }
            ?>
	</select>

	<div class="button dropdown hide-if-no-js">
		<a href="#" id="frm-fid-search" class="frm-dropdown-toggle" data-toggle="dropdown"><?php 
            _e('Search', 'formidable');
            ?>
 <b class="caret"></b></a>
		<ul class="frm-dropdown-menu pull-right" id="frm-fid-search-menu" role="menu" aria-labelledby="frm-fid-search">
			<li><a href="#" id="fid-">&mdash; <?php 
            _e('All Fields', 'formidable');
            ?>
 &mdash;</a></li>
			<li><a href="#" id="fid-created_at"><?php 
            _e('Entry creation date', 'formidable');
            ?>
</a></li>
			<li><a href="#" id="fid-id"><?php 
            _e('Entry ID', 'formidable');
            ?>
</a></li>
			<?php 
            foreach ($field_list as $f) {
                ?>
			<li><a href="#" id="fid-<?php 
                echo $f->type == 'user_id' ? 'user_id' : $f->id;
                ?>
"><?php 
                echo FrmAppHelper::truncate($f->name, 30);
                ?>
</a></li>
			<?php 
                unset($f);
            }
            ?>
		</ul>
	</div>
	<?php 
            submit_button($text, 'button hide-if-js', false, false, array('id' => 'search-submit'));
        } else {
            submit_button($text, 'button', false, false, array('id' => 'search-submit'));
            if (!empty($search_str)) {
                ?>
	<a href="<?php 
                echo esc_url(admin_url('admin.php?page=formidable-entries&frm_action=list&form=' . $form->id));
                ?>
"><?php 
                _e('Reset', 'formidable');
                ?>
</a>
	<?php 
            }
        }
        ?>

</div>
<?php 
    }
 /**
  * @covers FrmProFieldsController::toggle_repeat
  */
 function _check_if_new_form_created($old_count, $args)
 {
     global $wpdb;
     $all_forms = $wpdb->get_col("SELECT id FROM " . $wpdb->prefix . "frm_forms");
     $new_count = count($all_forms);
     $this->assertEquals($old_count + 1, $new_count, 'A new form is not created when switching divider to repeatable.');
     // Get ID of new form
     $new_form_id = max($all_forms);
     // Check parent_form_id
     $new_form = FrmForm::getOne($new_form_id);
     $this->assertEquals($args['parent_form_id'], $new_form->parent_form_id, 'parent_form_id is not set correctly when a new form is created when switching to a repeating section.');
     return $new_form_id;
 }
Exemplo n.º 25
0
 /**
  * If a form is a child form, get the parent form. Then if the entry is a child entry, get the parent entry.
  *
  * @since 2.0.13
  * @param int|object $form - pass by reference
  * @param int|object $entry - pass by reference
  */
 private static function maybe_get_parent_form_and_entry(&$form, &$entry)
 {
     // If form is a child form, refer to parent form's settings
     if ($form->parent_form_id) {
         $form = FrmForm::getOne($form->parent_form_id);
         // Make sure we're also checking the parent entry's permissions
         FrmEntry::maybe_get_entry($entry);
         if ($entry->parent_item_id) {
             $entry = FrmEntry::getOne($entry->parent_item_id);
         }
     }
 }
Exemplo n.º 26
0
 public static function get_params($form = null)
 {
     global $frm_vars;
     $frm_form = new FrmForm();
     if (!$form) {
         $form = $frm_form->getAll(array(), 'name', 1);
     } else {
         if (!is_object($form)) {
             $form = $frm_form->getOne($form);
         }
     }
     if (isset($frm_vars['form_params']) && is_array($frm_vars['form_params']) && isset($frm_vars['form_params'][$form->id])) {
         return $frm_vars['form_params'][$form->id];
     }
     $action_var = isset($_REQUEST['frm_action']) ? 'frm_action' : 'action';
     $action = apply_filters('frm_show_new_entry_page', FrmAppHelper::get_param($action_var, 'new'), $form);
     $default_values = array('id' => '', 'form_name' => '', 'paged' => 1, 'form' => $form->id, 'form_id' => $form->id, 'field_id' => '', 'search' => '', 'sort' => '', 'sdir' => '', 'action' => $action);
     $values['posted_form_id'] = FrmAppHelper::get_param('form_id');
     if (!is_numeric($values['posted_form_id'])) {
         $values['posted_form_id'] = FrmAppHelper::get_param('form');
     }
     if ($form->id == $values['posted_form_id']) {
         //if there are two forms on the same page, make sure not to submit both
         foreach ($default_values as $var => $default) {
             if ($var == 'action') {
                 $values[$var] = FrmAppHelper::get_param($action_var, $default);
             } else {
                 $values[$var] = FrmAppHelper::get_param($var, $default);
             }
             unset($var);
             unset($default);
         }
     } else {
         foreach ($default_values as $var => $default) {
             $values[$var] = $default;
             unset($var);
             unset($default);
         }
     }
     if (in_array($values['action'], array('create', 'update')) and (!isset($_POST) or !isset($_POST['action']) and !isset($_POST['frm_action']))) {
         $values['action'] = 'new';
     }
     return $values;
 }
Exemplo n.º 27
0
 public static function delete_form_transient($form_id)
 {
     $form_id = absint($form_id);
     delete_transient('frm_form_fields_' . $form_id . 'exclude');
     delete_transient('frm_form_fields_' . $form_id . 'include');
     global $wpdb;
     $wpdb->query($wpdb->prepare('DELETE FROM ' . $wpdb->options . ' WHERE option_name LIKE %s OR option_name LIKE %s OR option_name LIKE %s OR option_name LIKE %s', '_transient_timeout_frm_form_fields_' . $form_id . 'ex%', '_transient_frm_form_fields_' . $form_id . 'ex%', '_transient_timeout_frm_form_fields_' . $form_id . 'in%', '_transient_frm_form_fields_' . $form_id . 'in%'));
     $cache_key = serialize(array('fi.form_id' => $form_id)) . 'field_orderlb';
     wp_cache_delete($cache_key, 'frm_field');
     // this cache key is autogenerated in FrmDb::get_var
     wp_cache_delete('(__fi.form_id=%d_OR_fr.parent_form_id=%d_)__' . $form_id . '_' . $form_id . '_ORDER_BY_field_orderfi.*__fr.name_as_form_name_results', 'frm_field');
     $form = FrmForm::getOne($form_id);
     if ($form && $form->parent_form_id) {
         self::delete_form_transient($form->parent_form_id);
     }
 }
Exemplo n.º 28
0
 /**
  * Initialize the plugin by setting localization, filters, and administration functions.
  *
  * @since 1.0.0
  *
  * @access private
  */
 private function __construct()
 {
     global $formworks_tracker;
     //auto load modules
     $dir = FRMWKS_PATH . 'includes/modules';
     if (is_dir($dir)) {
         if ($dh = opendir($dir)) {
             while (($folder = readdir($dh)) !== false) {
                 if ($folder === '..' || $folder === '.') {
                     continue;
                 }
                 if (file_exists($dir . '/' . $folder . '/handler.php')) {
                     include_once $dir . '/' . $folder . '/handler.php';
                 }
             }
             closedir($dh);
         }
     }
     // Load plugin text domain
     add_action('init', array($this, 'load_plugin_textdomain'));
     //initialize visitor tracker
     if (!is_admin()) {
         add_action('wp', array($this, 'register_visitor_session'));
     }
     // Activate plugin when new blog is added
     add_action('wpmu_new_blog', array($this, 'activate_new_site'));
     // Load admin style sheet and JavaScript.
     add_action('admin_enqueue_scripts', array($this, 'enqueue_admin_stylescripts'));
     // Load front style sheet and JavaScript.
     add_action('wp_enqueue_scripts', array($this, 'enqueue_front_stylescripts'));
     // output tracking code
     add_action('wp_print_footer_scripts', array($this, 'print_front_scripts'));
     // Add partial completions
     add_action('wp_ajax_frmwks_push', array($this, 'tracker_push'));
     add_action('wp_ajax_nopriv_frmwks_push', array($this, 'tracker_push'));
     // open actions
     add_action('formworks_track', array($this, 'handle_track'), 10, 4);
     /**
      * Tracking
      */
     /** Caldera Forms */
     add_action('caldera_forms_submit_complete', function ($form) {
         do_action('formworks_track', 'caldera', $form['ID'], 'submission');
     });
     add_filter('caldera_forms_render_form', function ($html, $form) {
         $selector = array("name" => $form['name'], "selector" => "." . $form['ID'], "prefix" => 'caldera', "id" => $form['ID']);
         do_action('formworks_track', 'caldera', $form['ID'], 'loaded', $selector);
         return $html;
     }, 10, 2);
     /** JETPACK */
     add_filter('grunion_contact_form_success_message', function ($html) {
         if (isset($_GET['contact-form-id'])) {
             $form_id = $_GET['contact-form-id'];
             do_action('formworks_track', 'jp', $form_id, 'submission');
         }
         return $html;
     });
     add_filter('grunion_contact_form_form_action', function ($url, $post, $form) {
         $selector = array("name" => $post->post_title, "selector" => "#contact-form-" . $form);
         do_action('formworks_track', 'jp', $form, 'loaded', $selector);
         return $url;
     }, 15, 3);
     /** Formidable */
     add_action('frm_process_entry', function ($params) {
         do_action('formworks_track', 'frmid', $params['form_id'], 'submission');
     }, 15);
     add_filter('formidable_shortcode_atts', function ($shortcode_atts, $atts) {
         if (class_exists('\\FrmForm')) {
             $form = \FrmForm::getOne($atts['id']);
         }
         $selector = array("name" => $form->name, "selector" => "#form_" . $form->form_key);
         do_action('formworks_track', 'frmid', $form->id, 'loaded', $selector);
     }, 10, 2);
     /** Contact Form 7 */
     add_filter('wpcf7_form_elements', function ($html) {
         if (class_exists('\\WPCF7_ContactForm')) {
             $form = \WPCF7_ContactForm::get_current();
             do_action('formworks_track', 'cf7', $form->id(), 'loaded');
         }
         return $html;
     }, 10, 2);
     add_action('wpcf7_submit', function ($instance, $result) {
         if (isset($result['status']) && 'mail_sent' === $result['status']) {
             do_action('formworks_track', 'cf7', $instance->id(), 'submission');
         }
     }, 20, 2);
     /** Gravity Forms */
     add_filter('gform_get_form_filter', function ($html, $form) {
         $selector = array("name" => $form['title'], "selector" => "#gform_" . $form['id']);
         do_action('formworks_track', 'gform', $form['id'], 'loaded', $selector);
         return $html;
     }, 10, 2);
     add_action('gform_after_submission', function ($form) {
         // do a submission complete
         do_action('formworks_track', 'gform', $form['form_id'], 'submission');
         return;
     });
     /** Ninja Forms */
     add_action('ninja_forms_post_process', function () {
         global $ninja_forms_processing;
         if (is_object($ninja_forms_processing)) {
             do_action('formworks_track', 'ninja', $ninja_forms_processing->get_form_ID(), 'submission');
         }
     });
     //load settings class && licensing in admin
     if (is_admin()) {
         new settings();
         add_action('admin_init', function () {
             $plugin = frmwks_licensing_args();
             new \calderawp\licensing_helper\licensing($plugin);
         }, 0);
     }
 }
 private static function fields_to_values($form_id, array &$values)
 {
     $form = FrmForm::getOne($form_id);
     $values = array('fields' => array(), 'id' => $form->id);
     $fields = FrmField::get_all_for_form($form->id);
     foreach ($fields as $k => $f) {
         $f = (array) $f;
         $opts = (array) $f['field_options'];
         $f = array_merge($opts, $f);
         if (!isset($f['post_field'])) {
             $f['post_field'] = '';
         }
         $values['fields'][] = $f;
         unset($k, $f);
     }
     return $form;
 }
Exemplo n.º 30
0
 function validate($values, $exclude = false)
 {
     global $wpdb, $frm_field, $frm_entry_meta, $frm_settings;
     $errors = array();
     if (!isset($values['form_id']) || !isset($values['item_meta'])) {
         $errors['form'] = __('There was a problem with your submission. Please try again.', 'formidable');
         return $errors;
     }
     if (is_admin() && is_user_logged_in() && (!isset($values['frm_submit_entry_' . $values['form_id']]) || !wp_verify_nonce($values['frm_submit_entry_' . $values['form_id']], 'frm_submit_entry_nonce'))) {
         $errors['form'] = __('You do not have permission to do that', 'formidable');
     }
     if (!isset($values['item_key']) or $values['item_key'] == '') {
         $_POST['item_key'] = $values['item_key'] = FrmAppHelper::get_unique_key('', $wpdb->prefix . 'frm_items', 'item_key');
     }
     $where = apply_filters('frm_posted_field_ids', 'fi.form_id=' . (int) $values['form_id']);
     if ($exclude) {
         $where .= " and fi.type not in ('" . implode("','", array_filter($exclude, 'esc_sql')) . "')";
     }
     $posted_fields = $frm_field->getAll($where, 'field_order');
     foreach ($posted_fields as $posted_field) {
         $posted_field->field_options = maybe_unserialize($posted_field->field_options);
         $value = '';
         if (isset($values['item_meta'][$posted_field->id])) {
             $value = $values['item_meta'][$posted_field->id];
         }
         if (isset($posted_field->field_options['default_blank']) and $posted_field->field_options['default_blank'] and $value == $posted_field->default_value) {
             $value = '';
         }
         if (is_array($value) and count($value) === 1) {
             $value = reset($value);
         }
         if ($posted_field->type == 'rte' and !is_array($value) and trim($value) == '<br>') {
             $value = '';
         }
         if ($posted_field->required == '1' and !is_array($value) and trim($value) == '') {
             $errors['field' . $posted_field->id] = (!isset($posted_field->field_options['blank']) or $posted_field->field_options['blank'] == '' or $posted_field->field_options['blank'] == 'Untitled cannot be blank') ? $frm_settings->blank_msg : $posted_field->field_options['blank'];
         } else {
             if ($posted_field->type == 'text' and !isset($_POST['name'])) {
                 $_POST['name'] = $value;
             }
         }
         $_POST['item_meta'][$posted_field->id] = $value;
         if ($posted_field->type == 'captcha' and isset($_POST['recaptcha_challenge_field'])) {
             global $frm_settings;
             if (!function_exists('recaptcha_check_answer')) {
                 require FrmAppHelper::plugin_path() . '/classes/recaptchalib.php';
             }
             $response = recaptcha_check_answer($frm_settings->privkey, $_SERVER['REMOTE_ADDR'], $_POST['recaptcha_challenge_field'], $_POST['recaptcha_response_field']);
             if (!$response->is_valid) {
                 // What happens when the CAPTCHA was entered incorrectly
                 $errors['captcha-' . $response->error] = $errors['field' . $posted_field->id] = (!isset($posted_field->field_options['invalid']) or $posted_field->field_options['invalid'] == '') ? $frm_settings->re_msg : $posted_field->field_options['invalid'];
             }
         }
         $errors = apply_filters('frm_validate_field_entry', $errors, $posted_field, $value);
     }
     // check for spam
     if (empty($exclude) && isset($values['item_meta']) && !empty($values['item_meta']) && empty($errors)) {
         global $wpcom_api_key;
         if ((function_exists('akismet_http_post') || is_callable('Akismet::http_post')) && (get_option('wordpress_api_key') || $wpcom_api_key) && $this->akismet($values)) {
             $frm_form = new FrmForm();
             $form = $frm_form->getOne($values['form_id']);
             if (isset($form->options['akismet']) && !empty($form->options['akismet']) && ($form->options['akismet'] != 'logged' || !is_user_logged_in())) {
                 $errors['spam'] = __('Your entry appears to be spam!', 'formidable');
             }
         }
         // check for blacklist keys
         if ($this->blacklist_check($values)) {
             $errors['spam'] = __('Your entry appears to be spam!', 'formidable');
         }
     }
     $errors = apply_filters('frm_validate_entry', $errors, $values);
     return $errors;
 }