/wp-content/plugins/formidable/pro/classes/helpers/FrmProFieldsHelper.php

Large files files are truncated, but you can click here to view the full file

<?php

class FrmProFieldsHelper{
    function FrmProFieldsHelper(){
        add_filter('frm_get_default_value', array(&$this, 'get_default_value'), 10, 3);
        add_filter('frm_setup_edit_field_vars', array(&$this, 'setup_new_field_vars'), 10);
        add_filter('frm_setup_new_fields_vars', array(&$this, 'setup_new_vars'), 10, 2);
        add_filter('frm_setup_edit_fields_vars', array(&$this, 'setup_edit_vars'), 10, 3);
        add_filter('frm_posted_field_ids', array(&$this, 'posted_field_ids'));
        add_action('frm_after_checkbox', array(&$this, 'get_child_checkboxes'));
        add_filter('frm_get_paged_fields', array(&$this, 'get_form_fields'), 10, 3);
        add_filter('frm_show_custom_html', array(&$this, 'show_custom_html'), 10, 2);
        add_filter('frm_other_custom_html', array(&$this, 'get_default_html'), 10, 2);
        add_filter('frm_conditional_value', array(&$this, 'conditional_replace_with_value'), 10, 4);
        add_filter('frm_before_replace_shortcodes', array(&$this, 'before_replace_shortcodes'), 10, 2);
        add_filter('frm_replace_shortcodes', array(&$this, 'replace_html_shortcodes'), 10, 2);
        add_filter('frm_display_entry_content', array(&$this, 'replace_shortcodes'), 10, 6);
    }
    
    function get_default_value($value, $field, $dynamic_default=true, $return_array=false){
        if (is_array(maybe_unserialize($value))) return $value;

        if($field and $dynamic_default){
            $field->field_options = maybe_unserialize($field->field_options);
            if(isset($field->field_options['dyn_default_value']) and !empty($field->field_options['dyn_default_value'])){
                $prev_val = $value;
                $value = $field->field_options['dyn_default_value'];
            }
        }

        preg_match_all( "/\[(date|time|email|login|display_name|first_name|last_name|user_meta|post_meta|post_id|post_title|post_author_email|ip|auto_id|get|get-(.?))\b(.*?)(?:(\/))?\]/s", $value, $matches, PREG_PATTERN_ORDER);

        if (!isset($matches[0])) return do_shortcode($value);

        foreach ($matches[0] as $match_key => $val){
            switch($val){
                case '[date]':
                    global $frmpro_settings;
                    $new_value = date_i18n($frmpro_settings->date_format, strtotime(current_time('mysql')));
                    break;
                case '[time]':
                    $new_value = date('H:i:s', strtotime(current_time('mysql')));
                    break;
                case '[email]':
                    global $current_user;
                    $new_value = (isset($current_user->user_email)) ? $current_user->user_email : '';
                    break;
                case '[login]':
                    global $current_user;
                    $new_value = (isset($current_user->user_login)) ? $current_user->user_login : '';
                    break;
                case '[display_name]':
                    global $current_user;
                    $new_value = (isset($current_user->display_name)) ? $current_user->display_name : '';
                    break;
                case '[first_name]':
                    global $current_user;
                    $new_value = (isset($current_user->user_firstname)) ? $current_user->user_firstname : '';
                    break;
                case '[last_name]':
                    global $current_user;
                    $new_value = (isset($current_user->user_lastname)) ? $current_user->user_lastname : '';
                    break;
                case '[post_id]':
                    global $post;
                    if($post)
                        $new_value = $post->ID;
                    break;
                case '[post_title]':
                    global $post;
                    if($post)
                        $new_value = $post->post_title;
                    break;
                case '[post_author_email]':
                    $new_value = get_the_author_meta('user_email');
                    break;
                case '[user_id]':
                    global $user_ID;
                    $new_value = $user_ID ? $user_ID : '';
                    break;
                case '[ip]':
                    $new_value = $_SERVER['REMOTE_ADDR'];
                    break;
                default:
                    $atts = shortcode_parse_atts(stripslashes($matches[3][$match_key]));
                    $shortcode = $matches[1][$match_key];
                    
                    if (preg_match("/\[get-(.?)\b(.*?)?\]/s", $val)){
                        $param = str_replace('[get-', '', $val);
                        if (preg_match("/\[/s", $param))
                            $val .= ']';
                        else
                            $param = trim($param, ']'); //only if is doesn't create an imbalanced []
                        $new_value = FrmAppHelper::get_param($param);
                        if(is_array($new_value) and !$return_array)
                            $new_value = implode(', ', $new_value);
                    }else{
                        switch($shortcode){
                            case 'get':
                                $new_value = '';
                                if(isset($atts['param'])){
                                    if(strpos($atts['param'], '&#91;')){
                                        $atts['param'] = str_replace('&#91;', '[', $atts['param']);
                                        $atts['param'] = str_replace('&#93;', ']', $atts['param']);
                                    }
                                    $new_value = FrmAppHelper::get_param($atts['param'], false);
                                    if(!$new_value){
                                        global $wp_query;
                                        if(isset($wp_query->query_vars[$atts['param']]))
                                            $new_value = $wp_query->query_vars[$atts['param']];
                                    } 
                                    if(!$new_value and isset($atts['default']))
                                        $new_value = $atts['default'];
                                    else if(!$new_value and isset($prev_val))
                                        $new_value = $prev_val;
                                }

                                if(is_array($new_value) and !$return_array)
                                    $new_value = implode(', ', $new_value);
                            break;
                            case'auto_id':
                                global $frmpro_entry_meta;

                                $last_entry = $frmpro_entry_meta->get_max($field);

                                if(!$last_entry and isset($atts['start']))
                                    $new_value = (int)$atts['start'];

                                if (!isset($new_value)) $new_value = $last_entry + 1;
                            break;
                            case 'user_meta':
                                if(isset($atts['key'])){
                                    global $current_user;
                                    $new_value = (isset($current_user->{$atts['key']})) ? $current_user->{$atts['key']} : '';
                                }
                            break;
                            case 'post_meta':
                                if(isset($atts['key'])){
                                    global $post;
                                    if($post){
                                        $post_meta = get_post_meta($post->ID, $atts['key'], true);
                                        if($post_meta)
                                            $new_value = $post_meta;
                                    }
                                }
                            break;
                            default:
                                //check for posted item_meta
                                if(is_numeric($shortcode)){ 
                                    $new_value = FrmAppHelper::get_param('item_meta['. $shortcode .']', false);

                                    if(!$new_value and isset($atts['default']))
                                        $new_value = $atts['default'];

                                    if(is_array($new_value) and !$return_array)
                                        $new_value = implode(', ', $new_value);
                                }else{
                                    //don't replace this if it's a shortcode that still needs to be processed
                                    $new_value = $val;
                                }
                            break;
                        }
                    }
            }            
            
            if (!isset($new_value)) $new_value = '';
            
            if(is_array($new_value)){
                if(count($new_value) === 1)
                    $new_value = reset($new_value);
                $value = $new_value;
            }else{
                $value = str_replace($val, $new_value, $value);
            }
                
            unset($new_value);
        }
        
        unset($matches);
        preg_match_all( "/\[(\d*)\b(.*?)(?:(\/))?\]/s", $value, $matches, PREG_PATTERN_ORDER);
        if (isset($matches[0])){
            foreach ($matches[0] as $match_key => $val){
                $shortcode = $matches[1][$match_key];
                if(is_numeric($shortcode)){ 
                    $new_value = FrmAppHelper::get_param('item_meta['. $shortcode .']', false);

                    if(!$new_value and isset($atts['default']))
                        $new_value = $atts['default'];

                    if(is_array($new_value) and !$return_array)
                        $new_value = implode(', ', $new_value);
                        
                    if(is_array($new_value))
                        $value = $new_value;
                    else
                        $value = str_replace($val, $new_value, $value);
                }
            }
        }
        
        global $frm_skip_shortcode;
        $frm_skip_shortcode = true;
                
        $value = do_shortcode($value);
        
        $frm_skip_shortcode = false;
        return $value;
    }
    
    function setup_new_field_vars($values){
        $values['field_options'] = maybe_unserialize($values['field_options']);
        
        foreach (FrmProFieldsHelper::get_default_field_opts($values) as $opt => $default)
            $values[$opt] = (isset($values['field_options'][$opt])) ? $values['field_options'][$opt] : $default;
        
        return $values;
    }
    
    function setup_new_vars($values, $field){
        $values['use_key'] = false;

        $field->field_options = maybe_unserialize($field->field_options);
        foreach ($this->get_default_field_opts($values, $field) as $opt => $default)
            $values[$opt] = (isset($field->field_options[$opt]) && $field->field_options[$opt] != '') ? $field->field_options[$opt] : $default;
            
        $values['hide_field'] = (array)$values['hide_field'];    
        $values['hide_field_cond'] = (array)$values['hide_field_cond'];
        $values['hide_opt'] = (array)$values['hide_opt'];

        if ($values['type'] == 'data' && in_array($values['data_type'], array('select', 'radio', 'checkbox')) && is_numeric($values['form_select'])){
            global $frm_entry_meta;
            $check = $this->check_data_values($values);

            if($check)
                $values['options'] = $this->get_linked_options($values, $field);
            else if(is_numeric($values['value']))
                $values['options'] = array($values['value'] => $frm_entry_meta->get_entry_meta_by_field($values['value'], $values['form_select']));
            
            unset($check);
        }else if ($values['type'] == '10radio' or $values['type'] == 'scale'){
            $values['minnum'] = 1;
            $values['maxnum'] = 10;
        }else if ($values['type'] == 'date'){
            if (preg_match('/^\d{4}-\d{2}-\d{2}$/', $values['value'])){ 
                global $frmpro_settings;
                $values['value'] = FrmProAppHelper::convert_date($values['value'], 'Y-m-d', $frmpro_settings->date_format);
            }
        }else if($values['type'] == 'user_id' and is_admin() and current_user_can('administrator') and ($_GET['page'] != 'formidable')){
            global $user_ID;
            $values['type'] = 'select';
            $values['options'] = $this->get_user_options();
            $values['use_key'] = true;
            $values['custom_html'] = FrmFieldsHelper::get_default_html('select');
            $values['value'] = $user_ID;
        }else if(!empty($values['options'])){
            foreach($values['options'] as $val_key => $val_opt){
                if(is_array($val_opt)){
                    foreach($val_opt as $opt_key => $opt){
                        $values['options'][$val_key][$opt_key] = $this->get_default_value($opt, $field, false);
                        unset($opt_key);
                        unset($opt);
                    }
                }else{
                   $values['options'][$val_key] = $this->get_default_value($val_opt, $field, false);
                }
                unset($val_key);
                unset($val_opt);
            }
        }
        
        if($values['post_field'] == 'post_category'){
            $values['use_key'] = true;
            $values['options'] = $this->get_category_options($values);
        }else if($values['post_field'] == 'post_status'){
            $values['use_key'] = true;
            $values['options'] = $this->get_status_options($field);
        }
        
        if(is_array($values['value'])){
            foreach($values['value'] as $val_key => $val)
                $values['value'][$val_key] = apply_filters('frm_get_default_value', $val, $field);
        }else if(!empty($values['value'])){
            $values['value'] = apply_filters('frm_get_default_value', $values['value'], $field);
        }
        
        FrmProFieldsHelper::setup_conditional_fields($values);
        
        return $values;
    }
        
    function setup_edit_vars($values, $field, $entry_id=false){
        $values['use_key'] = false;
   
        $field->field_options = maybe_unserialize($field->field_options);
        foreach ($this->get_default_field_opts($values, $field) as $opt => $default){
            $values[$opt] = stripslashes_deep(($_POST and isset($_POST['field_options'][$opt.'_'.$field->id]) ) ? $_POST['field_options'][$opt.'_'.$field->id] : (isset($field->field_options[$opt]) ? $field->field_options[$opt]: $default));
        }

        $values['hide_field'] = (array)$values['hide_field'];    
        $values['hide_field_cond'] = (array)$values['hide_field_cond'];
        $values['hide_opt'] = (array)$values['hide_opt'];

        if ($values['type'] == 'data' && in_array($values['data_type'], array('select', 'radio', 'checkbox')) && is_numeric($values['form_select'])){
            global $frm_entry_meta;
            $check = $this->check_data_values($values);

            if($check)
                $values['options'] = $this->get_linked_options($values, $field, $entry_id);
            else if(is_numeric($values['value']))
                $values['options'] = array($values['value'] => $frm_entry_meta->get_entry_meta_by_field($values['value'], $values['form_select']));
            unset($check);
        }else if ($values['type'] == 'date'){
            global $frmpro_settings;
            if (preg_match('/^\d{4}-\d{2}-\d{2}$/', $values['value']))
                $values['value'] = FrmProAppHelper::convert_date($values['value'], 'Y-m-d', $frmpro_settings->date_format);
            else if (preg_match('/^\d{4}-\d{2}-\d{2}/', $values['value']))
                $values['value'] = FrmProAppHelper::convert_date($values['value'], 'Y-m-d H:i:s', $frmpro_settings->date_format);
        }else if ($values['type'] == 'file'){
            //if (isset($_POST)) ???
            if($values['post_field'] != 'post_custom'){
                global $frm_entry_meta;
                $values['value'] = $frm_entry_meta->get_entry_meta_by_field($entry_id, $values['id']);
            }
        }else if($values['type'] == 'hidden' and is_admin() and current_user_can('administrator') and ($_GET['page'] != 'formidable')){
            $values['type'] = 'text';
            $values['custom_html'] = FrmFieldsHelper::get_default_html('text');
        }else if($values['type'] == 'user_id' and is_admin() and current_user_can('administrator') and ($_GET['page'] != 'formidable')){
            $values['type'] = 'select';
            $values['options'] = $this->get_user_options();
            $values['use_key'] = true;
            $values['custom_html'] = FrmFieldsHelper::get_default_html('select');
        }else if($values['type'] == 'tag'){
            if(empty($values['value'])){
                global $wpdb, $frmdb;
                $post_id = $wpdb->get_var("SELECT post_id FROM $frmdb->entries WHERE id=$entry_id");
                if($post_id and ($tags = get_the_terms( $post_id, $values['taxonomy'] ))){
                    $names = array();
                    foreach($tags as $tag)
                        $names[] = $tag->name;
                    $values['value'] = implode(', ', $names);
                }
            }
        }
        
        if($values['post_field'] == 'post_category'){
            $values['use_key'] = true;
            $values['options'] = $this->get_category_options($values);
        }else if($values['post_field'] == 'post_status'){
            $values['use_key'] = true;
            $values['options'] = $this->get_status_options($field);
        }
        
        FrmProFieldsHelper::setup_conditional_fields($values);

        return $values;
    }
    
    function get_default_field_opts($values=false, $field=false){
        global $frmpro_settings;
        
        $minnum = 1;
        $maxnum = 10;
        $step = 1;
        $align = 'block';
        if($values){
            if($values['type'] == 'number'){
                $minnum = 0;
                $maxnum = 9999;
            }else if($values['type'] == '10radio' or $values['type'] == 'scale' and $field){
                $range = maybe_unserialize($field->options);
                $minnum = $range[0];
                $maxnum = end($range);
            }else if ($values['type'] == 'time'){
                $step = 30;
            }else if($values['type'] == 'radio'){
                $align = $frmpro_settings->radio_align;
            }else if($values['type'] == 'checkbox'){
                $align = $frmpro_settings->check_align;
            }
        }
        $end_minute = 60 - (int)$step;
        
        unset($values);
        unset($field);
        
        return array(
            'slide' => 0, 'form_select' => '', 'show_hide' => 'show', 'any_all' => 'any', 'align' => $align,
            'hide_field' => array(), 'hide_field_cond' =>  array('=='), 'hide_opt' => array(), 'star' => 0,
            'post_field' => '', 'custom_field' => '', 'taxonomy' => 'category', 'exclude_cat' => 0, 'ftypes' => array(),
            'data_type' => '', 'restrict' => 0, 'start_year' => 2000, 'end_year' => 2020, 'read_only' => 0, 
            'admin_only' => 0, 'locale' => '', 'attach' => false, 'minnum' => $minnum, 'maxnum' => $maxnum, 
            'step' => $step, 'clock' => 12, 'start_time' => '00:00', 'end_time' => '23:'.$end_minute, 
            'dependent_fields' => 0, 'unique' => 0, 'use_calc' => 0, 'calc' => '', 'duplication' => 1, 'rte' => 'nicedit',
            'dyn_default_value' => '', 'multiple' => 0
        );
    }
    
    function check_data_values($values){
        $check = true;
        if(!empty($values['hide_field']) and (!empty($values['hide_opt']) or !empty($values['form_select']))){
            foreach($values['hide_field'] as $hkey => $f){
                if(!$check or !empty($values['hide_opt'][$hkey])) continue;
                $f = FrmField::getOne($f);
                if($f and $f->type == 'data')
                    $check = false;
                unset($f);
                unset($hkey);
            }
        }
        return $check;
    }
    
    
    function setup_conditional_fields($field){
        if(!empty($field['hide_field']) and (!empty($field['hide_opt']) or !empty($field['form_select']))){
                
            global $frm_rules, $frm_field;
            if(!$frm_rules)
                $frm_rules = array();

            $conditions = array();
            
            if(!isset($field['show_hide']))
                $field['show_hide'] = 'show';
            
            if(!isset($field['any_all']))
                $field['any_all'] = 'any';
                
            foreach($field['hide_field'] as $i => $cond){
                if(!is_numeric($cond))
                    continue;
                    
                $parent_field = $frm_field->getOne($cond);

                if(!$parent_field)
                    continue;
                
                $parent_opts = maybe_unserialize($parent_field->field_options);
                
                if(empty($conditions)){  
                    foreach($field['hide_field'] as $i2 => $cond2){
                        if(!is_numeric($cond2))
                            continue;
                            
                        if((int)$cond2 == (int)$parent_field->id){ 
                            $sub_field = $parent_field;
                            $sub_opts = $parent_opts;
                        }else{
                            $sub_field = $frm_field->getOne($cond2);
                            if($sub_field)
                                $sub_opts = maybe_unserialize($sub_field->field_options);
                        }
                            
                        $condition = array('FieldName' => $sub_field->id, 'Condition' => $field['hide_field_cond'][$i2]);

                        if($sub_field->type == 'data' and $field['type'] == 'data' and (is_numeric($field['form_select']) or $field['form_select'] == 'taxonomy')){
                            $condition['LinkedField'] = $field['form_select'];
                            $condition['DataType'] = $field['data_type'];
                        }else if(isset($field['hide_opt']) and (!empty($field['hide_opt'][$i2]) or $field['hide_opt'][$i2] == 0)){
                            $condition['Value'] = stripslashes(str_replace('"', '&quot;', ( apply_filters('frm_get_default_value', $field['hide_opt'][$i2], $frm_field->getOne($field['id']) ))));
                        }
                        $condition['Type'] = $sub_field->type . (($sub_field->type == 'data') ? '-'. $sub_opts['data_type'] : '');
                        $conditions[] = $condition;
                    }
                }
                 
                $rule = array('Show' => $field['show_hide'], 'MatchType' => $field['any_all']);

                $rule['Setting'] = array(
                    'FieldName' => $field['id']
                );

                $rule['Conditions'] = $conditions;

                if(!isset($frm_rules[$parent_field->id]))
                    $frm_rules[$parent_field->id] = array();

                $frm_rules[$parent_field->id][] = $rule;
                
                unset($rule);
                unset($parent_field);
                unset($i);
                unset($cond);
            }
        }
    }
    
    function get_category_options($field){
        $field = (array)$field;
        $post_type = FrmProForm::post_type($field['form_id']);
        if(!isset($field['exclude_cat']))
            $field['exclude_cat'] = 0;
            
        $exclude = (is_array($field['exclude_cat'])) ? implode(',', $field['exclude_cat']) : $field['exclude_cat'];
        $exclude = apply_filters('frm_exclude_cats', $exclude, $field);
        
        $args = array(
            'orderby' => 'name', 'order' => 'ASC', 'hide_empty' => false, 
            'exclude' => $exclude, 'type' => $post_type
        );
        
        if($field['type'] != 'data')
            $args['parent'] = '0';
            
        if(function_exists('get_object_taxonomies')){
            $args['taxonomy'] = FrmProAppHelper::get_custom_taxonomy($post_type, $field);
            if(!$args['taxonomy'])
                return;
        }
        
        $categories = get_categories($args);

        $options = array();
        foreach($categories as $cat)
            $options[$cat->term_id] = $cat->name;
        
        return $options;
    }
    
    function get_child_checkboxes($args){
        $defaults = array(
            'field' => 0, 'field_name' => false, 'opt_key' => 0, 'opt' => '', 
            'type' => 'checkbox', 'value' => false, 'exclude' => 0, 'hide_id' => false
        );
        extract(wp_parse_args($args, $defaults));
       
        if(!$field or !isset($field['post_field']) or $field['post_field'] != 'post_category') return;
        if(!$value) $value = (isset($field['value'])) ? $field['value'] : '';
        if(!$exclude) $exclude = (is_array($field['exclude_cat'])) ? implode(',', $field['exclude_cat']) : $field['exclude_cat'];
        if(!$field_name) $field_name = "item_meta[$field[id]]";
        if($type == 'checkbox'){ 
            $field_name .= '[]';
            $onchange = ' onchange="frmCheckParents(this.id)"';
        }else{
            $onchange = '';
        }
        $post_type = FrmProForm::post_type($field['form_id']);
        $taxonomy = 'category';
        
        $args = array(
            'orderby' => 'name', 'order' => 'ASC', 'hide_empty' => false, 
            'parent' => $opt_key, 'exclude' => $exclude, 'type' => $post_type
        );
        if(!$opt_key and function_exists('get_object_taxonomies')){
            $args['taxonomy'] = FrmProAppHelper::get_custom_taxonomy($post_type, $field);
            if(!$args['taxonomy']){
                echo '<p>'. __('No Categories', 'formidable' ) .'</p>';
                return;
            }

            $taxonomy = $args['taxonomy'];
        }
            
        $children = get_categories($args);
        $level = ($opt_key) ? 2 : 1;
    	foreach($children as $key => $cat){  ?> 	    
    	<div class="frm_catlevel_<?php echo $level ?>"><?php FrmProFieldsHelper::_show_category(compact('cat', 'field', 'field_name', 'exclude', 'type', 'value', 'exclude', 'level', 'onchange', 'post_type', 'taxonomy', 'hide_id')) ?></div>
<?php   }
    }
    
    function _show_category($atts) {
        extract($atts);
    	if(!is_object($cat)) return;
    	$checked = '';
    	
    	if(is_array($value)) 
    		$checked = (in_array($cat->cat_ID, $value)) ? 'checked="checked" ' : '';
    	else if($cat->cat_ID == $value)
    	    $checked = 'checked="checked" ';
    	else
    	    $checked = '';
    	$class = '';
    	//$class = ' class="frm_selectit"'; //TODO: option to check parent cats
    	$sanitized_name = ((isset($field['id'])) ? $field['id'] : $field['field_options']['taxonomy']).'-'. $cat->cat_ID;
    	
    	?>
    	<div class="frm_<?php echo $type ?>" id="frm_<?php echo $type .'_'. $sanitized_name ?>">
    	    <label<?php echo $class ?> for="field_<?php echo $sanitized_name ?>"><input type="<?php echo $type ?>" name="<?php echo $field_name ?>" <?php echo (isset($hide_id) and $hide_id)? '' : 'id="field_'. $sanitized_name .'"'; ?> value="<?php echo $cat->cat_ID ?>" <?php echo $checked;  do_action('frm_field_input_html', $field); //echo ($onchange); ?> /><?php echo $cat->cat_name ?></label>
<?php
    	$children = get_categories(array('type' => $post_type, 'orderby' => 'name', 'order' => 'ASC', 'hide_empty' => false, 'exclude' => $exclude, 'parent' => $cat->cat_ID, 'taxonomy' => $taxonomy));
    	if($children){ 
    	    $level++;
    	    foreach($children as $key => $cat){ ?>
    	<div class="frm_catlevel_<?php echo $level ?>"><?php FrmProFieldsHelper::_show_category(compact('cat', 'field', 'field_name', 'exclude', 'type', 'value', 'exclude', 'level', 'onchange', 'post_type', 'taxonomy', 'hide_id')) ?></div>
<?php       }
        }
    	echo '</div>';
    }
    
    function get_status_options($field){
        $post_type = FrmProForm::post_type($field->form_id);
        $post_type_object = get_post_type_object($post_type);
        $options = array();
        
        if(!$post_type_object)
            return $options;
            
        $can_publish = current_user_can($post_type_object->cap->publish_posts);
        $options = get_post_statuses(); //'draft', pending, publish, private

        if(!$can_publish){ // Contributors only get "Unpublished" and "Pending Review"
        	unset($options['publish']);
        	if(isset($options['future']))
        	    unset($options['future']);
        }
        return $options;
    }
    
    function get_user_options(){
        global $wpdb;
        $users = (function_exists('get_users')) ? get_users(array( 'fields' => array('ID','user_login','display_name'), 'blog_id' => $GLOBALS['blog_id'])) : get_users_of_blog();
        $options = array('' => '');
        foreach($users as $user)
            $options[$user->ID] = (!empty($user->display_name)) ? $user->display_name : $user->user_login;
        return $options;
    }
    
    function get_linked_options($values, $field, $entry_id=false){
        global $frm_entry_meta, $user_ID, $frm_field, $frmdb;
            
        $metas = array();
        $selected_field = $frm_field->getOne($values['form_select']);
        if(!$selected_field)
            return array();
            
        $selected_field->field_options = maybe_unserialize($selected_field->field_options);
        
        $linked_posts = (isset($selected_field->field_options['post_field']) and 
            $selected_field->field_options['post_field'] and 
            $selected_field->field_options['post_field'] != '') ? true : false;
        
        $post_ids = array();

        if (is_numeric($values['hide_field']) and (empty($values['hide_opt']))){
            global $frmpro_entry_meta;

            if (isset($_POST) and isset($_POST['item_meta']))
                $observed_field_val = (isset($_POST['item_meta'][$values['hide_field']])) ? $_POST['item_meta'][$values['hide_field']] : ''; 
            else if($entry_id)
                $observed_field_val = $frm_entry_meta->get_entry_meta_by_field($entry_id, $values['hide_field']);
            else
                $observed_field_val = '';
            
            $observed_field_val = maybe_unserialize($observed_field_val);
            $metas = $frmpro_entry_meta->meta_through_join($values['hide_field'], $selected_field, $observed_field_val);
            
        }else if ($values['restrict'] and $user_ID){
            $entry_user = $user_ID;
            if($entry_id and is_admin()){
                $entry_user = $frmdb->get_var($frmdb->entries, array('id' => $entry_id), 'user_id');
                if(!$entry_user or empty($entry_user))
                    $entry_user = $user_ID;
            }
            
            if (isset($selected_field->form_id)){
                $linked_where = array('form_id' => $selected_field->form_id, 'user_id' => $entry_user);
                if($linked_posts){
                    $post_ids = $frmdb->get_records($frmdb->entries, $linked_where, '', '', 'id, post_id');
                }else{
                    $entry_ids = $frmdb->get_col($frmdb->entries, $linked_where, 'id');
                }
                unset($linked_where);
            }
            
            if (isset($entry_ids) and !empty($entry_ids))
                $metas = $frm_entry_meta->getAll("it.item_id in (".implode(',', $entry_ids).") and field_id=". (int)$values['form_select'], ' ORDER BY meta_value');
        }else{
            $limit = '';
            if(is_admin() and isset($_GET) and $_GET['page'] == 'formidable')
                $limit = 500;
            $metas = $frmdb->get_records($frmdb->entry_metas, array('field_id' => $values['form_select']), 'meta_value', $limit, 'item_id, meta_value');
            $post_ids = $frmdb->get_records($frmdb->entries, array('form_id' => $selected_field->form_id), '', $limit, 'id, post_id');
        }
        
        if($linked_posts and !empty($post_ids)){
            foreach($post_ids as $entry){
                $meta_value = FrmProEntryMetaHelper::get_post_value($entry->post_id, $selected_field->field_options['post_field'], $selected_field->field_options['custom_field'], array('type' => $selected_field->type, 'form_id' => $selected_field->form_id, 'field' => $selected_field));
                $metas[] = array('meta_value' => $meta_value, 'item_id' => $entry->id);
            }
        }

        $options = array();
        foreach ($metas as $meta){
            $meta = (array)$meta;
            if(empty($meta['meta_value'])) continue;
            
            if($selected_field->type == 'image')
                $options[$meta['item_id']] = $meta['meta_value'];
            else
                $options[$meta['item_id']] = FrmProEntryMetaHelper::display_value($meta['meta_value'], $selected_field, array('type' => $selected_field->type, 'show_icon' => false, 'show_filename' => false));
            
            unset($meta);
        }
        
        unset($metas);
        natcasesort($options); //TODO: add sorting options
        
        return $options;
    }
    
    function posted_field_ids($where){
        if (isset($_POST['form_id']) and isset($_POST['frm_page_order_'. $_POST['form_id']]))
            $where .= ' and fi.field_order < '. (int)$_POST['frm_page_order_'. $_POST['form_id']];
        return $where;
    }
    
    function get_form_fields($fields, $form_id, $error=false){
        global $frm_prev_page, $frm_field, $frm_next_page;

        $prev_page = FrmAppHelper::get_param('frm_page_order_'. $form_id, false);
        $prev_page = (int)$prev_page;
  
        //$current_form_id = FrmAppHelper::get_param('form_id', false);
        $where = "fi.type='break' AND fi.form_id=". (int)$form_id;

        //if (is_numeric($current_form_id) and $current_form_id != $form_id)
        //    return $fields;
            
        if ($error and !$prev_page)
            $prev_page = 999;
        
        if ($prev_page){
            if ($error){
                $where_error = $where . " AND fi.field_order <" . ($prev_page);
                $prev_page_obj = $frm_field->getAll($where_error, 'field_order DESC', 1);
                $prev_page = ($prev_page_obj) ? $prev_page_obj->field_order : false;
            }

            if ($prev_page and !isset($prev_page_obj)){
                $prev_where = $where . " AND fi.field_order=". $prev_page;
                $prev_page_obj = $frm_field->getAll($prev_where, 'field_order DESC', 1);
            }
     
            $frm_prev_page[$form_id] = $prev_page;
            
            $where .= ' AND fi.field_order >='. ($prev_page + 1);
        }else
            unset($frm_prev_page[$form_id]);

        $next_page = $frm_field->getAll($where, 'field_order', 1);
        unset($where);
        
        if ($next_page or $prev_page){
            $query = "(fi.type != 'break'";
            if ($next_page) $query .= " or fi.id = $next_page->id";
            if ($prev_page) $query .= " or fi.id = $prev_page_obj->id";
            $query .= ") and fi.form_id=$form_id";
            
            if ($prev_page) $query .= " and fi.field_order >= $prev_page";
            if ($next_page) $query .= " and fi.field_order <= $next_page->field_order";
            if (is_admin()) $query .= " and fi.type != 'captcha'";
            $fields = $frm_field->getAll($query, ' ORDER BY field_order');
        }
        
        if($next_page)
            $frm_next_page[$form_id] = $next_page->name;
        else
            unset($frm_next_page[$form_id]);
        
        return $fields;
    }
    
    function show_custom_html($show, $field_type){
        if (in_array($field_type, array('hidden', 'user_id')))
            $show = false;
        return $show;
    }
    
    function get_default_html($default_html, $type){
        if ($type == 'break'){
            $default_html = <<<DEFAULT_HTML
<h2 class="frm_pos_[label_position]">[field_name]</h2>
[if description]<div class="frm_description">[description]</div>[/if description]
DEFAULT_HTML;
        }else if ($type == 'divider'){
            $default_html = <<<DEFAULT_HTML
<div id="frm_field_[id]_container" class="frm_form_field form-field[error_class]">
<h2 class="frm_pos_[label_position][collapse_class]">[field_name]</h2>
[collapse_this]
[if description]<div class="frm_description">[description]</div>[/if description]
</div>
DEFAULT_HTML;
        }else if($type == 'html'){
            $default_html = '<div id="frm_field_[id]_container" class="frm_form_field form-field">[description]</div>';       
        }
        return $default_html;
    }
    
    function before_replace_shortcodes($html, $field){
        global $frmpro_settings;
        
        if(isset($field['align']) and ($field['type'] == 'radio' or $field['type'] == 'checkbox')){
            $required_class = '[required_class]';
            if(($field['type'] == 'radio' and $field['align'] != $frmpro_settings->radio_align) or 
                ($field['type'] == 'checkbox' and $field['align'] != $frmpro_settings->check_align)){
                $required_class .= ($field['align'] == 'inline') ? ' horizontal_radio' : ' vertical_radio';
                
                $html = str_replace('[required_class]', $required_class, $html);
            }
        }

        if(isset($field['classes']) and strpos($field['classes'], 'frm_grid') !== false){
            $opt_count = count($field['options']) + 1;
            $html = str_replace('[required_class]', '[required_class] frm_grid_'. $opt_count, $html);
            unset($opt_count);
        }
        
        if($field['type'] == 'html' and isset($field['classes']))
            $html = str_replace('frm_form_field', 'frm_form_field '. $field['classes'], $html);
            
        return $html;
    }
    
    function replace_html_shortcodes($html, $field){
        if ($field['type'] == 'divider'){
            global $frm_div;
            $trigger = '';
            $html = str_replace(array('frm_none_container', 'frm_hidden_container', 'frm_top_container', 'frm_left_container', 'frm_right_container'), '', $html);
            $collapse_div = '<div>'."\n";
            if (isset($field['slide']) and $field['slide']){
                $trigger =  ' frm_trigger" onclick="frmToggleSection(jQuery(this));';
                $collapse_div = '<div class="frm_toggle_container" style="display:none;">';
                if(preg_match('/\<\/div\>$/', $html)){
                    if($frm_div and $frm_div != $field['id']){
                        $html = "</div>\n". $html;
                        $frm_div = false;
                    }
                    $frm_div = $field['id'];
                    $html = preg_replace('/\<\/div\>$/', '', $html); //"</div>\n";
                }
            }else if($frm_div and $frm_div != $field['id']){
                $html = "</div>\n". $html;
                $html = preg_replace('/\<\/div\>$/', '', $html); //"</div>\n";
            }
            
            if (preg_match('/\[(collapse_this)\]/s', $html)){
                $html = "</div>\n". $html;
                $html = str_replace('[collapse_this]', $collapse_div, $html);
            }
                
            $html = str_replace('[collapse_class]', $trigger, $html);
        }else if($field['type'] == 'html'){
            if(apply_filters('frm_use_wpautop', true))
                $html = wpautop($html);
            $html = apply_filters('frm_get_default_value', $html, (object)$field, false);
            $html = do_shortcode($html);
        }
        
        if (preg_match('/\[(collapse_this)\]/s', $html))
            $html = str_replace('[collapse_this]', '', $html);
        
        return $html;
    }

    
    function get_file_icon($media_id){
        if ( !is_numeric($media_id) )
            return;
            
        $image = wp_get_attachment_image($media_id, 'thumbnail', true);
        
        if($image and !preg_match("/wp-content\/uploads/", $image)){ //if this is a mime type icon
            $attachment = get_post($media_id);
            $label = basename($attachment->guid);
            $image .= " <span id='frm_media_$media_id' class='frm_upload_label'>$label</span>";
        }
            
        return $image;
    }
    
    function get_file_name($media_ids, $short=true){
        $value = '';
        foreach((array)$media_ids as $media_id){
            if ( is_numeric($media_id) ){
        		if ($short){
        		    $attachment = get_post($media_id);
                    $label = basename($attachment->guid);
                }
                $url = wp_get_attachment_url($media_id);

                if (is_admin()){
                    global $frm_siteurl;
                    $url = '<a href="'.$url.'">'.$label.'</a>';
                    if(isset($_GET) and isset($_GET['page']) and preg_match('/formidable*/', $_GET['page']))
                        $url .= '<br/><a href="'.$frm_siteurl.'/wp-admin/media.php?action=edit&attachment_id='.$media_id.'">'. __('Edit Uploaded File', 'formidable') .'</a>';
                }
                
                $value .= $url;
        	}
	    }
	    return $value;
    }
    
    function get_data_value($value, $field, $atts=array()){
        global $frm_field;
        if(!is_object($field))
            $field = $frm_field->getOne($field);
        
        $linked_field_id = isset($atts['show']) ? $atts['show'] : false;
        $field->field_options = maybe_unserialize($field->field_options);
        
        if (is_numeric($value) and (!isset($field->field_options['form_select']) or $field->field_options['form_select'] != 'taxonomy')){
            if (!$linked_field_id and is_numeric($field->field_options['form_select']))
                $linked_field_id = $field->field_options['form_select'];
            
            if ($linked_field_id){
                global $frm_entry_meta, $frmdb;
                $linked_field = $frm_field->getOne($linked_field_id);
                $linked_field->field_options = maybe_unserialize($linked_field->field_options);
                if(isset($linked_field->field_options['post_field']) and $linked_field->field_options['post_field']){
                    global $frmdb;
                    $post_id = $frmdb->get_var($frmdb->entries, array('id' => $value), 'post_id');
                    if($post_id){
                        if(!isset($atts['truncate']))
                            $atts['truncate'] = false;
                            
                        $new_value = FrmProEntryMetaHelper::get_post_value($post_id, $linked_field->field_options['post_field'], $linked_field->field_options['custom_field'], array('form_id' => $linked_field->form_id, 'field' => $linked_field, 'type' => $linked_field->type, 'truncate' => $atts['truncate']));
                    }else{
                        $new_value = $frm_entry_meta->get_entry_meta_by_field($value, $linked_field->id);
                    }
                }else{
                    $new_value = $frm_entry_meta->get_entry_meta_by_field($value, $linked_field->id);
                }
                
                $value = (!empty($new_value) or $new_value == 0) ? $new_value : $value;
                if($linked_field){
                    if(isset($atts['show']) and !is_numeric($atts['show']))
                        $atts['show'] = $linked_field->id;
                    else if(isset($atts['show']) and (int)$atts['show'] == $linked_field->id)
                        unset($atts['show']);
                    $value = FrmProFieldsHelper::get_display_value($value, $linked_field, $atts); //get display value
                }
            }
        }
        
        return $value;
    }
    
    function get_date($date, $date_format=false){
        if(empty($date))
            return $date;
                    
        if (!$date_format)
            $date_format = get_option('date_format');
            
        if (preg_match('/^\d{1-2}\/\d{1-2}\/\d{4}$/', $date)){ 
            global $frmpro_settings;
            $date = FrmProAppHelper::convert_date($date, $frmpro_settings->date_format, 'Y-m-d');
        }
        
        return date_i18n($date_format, strtotime($date));
    }
    
    function get_display_name($user_id, $user_info='display_name', $args=array()){
        $defaults = array(
            'blank' => false, 'link' => false, 'size' => 96
        );
        
        extract(wp_parse_args($args, $defaults));
        
        $user = get_userdata($user_id);
        $info = '';
        
        if($user){
            if($user_info == 'avatar'){
                $info = get_avatar( $user_id, $size );
            }else{
                $info = isset($user->$user_info) ? $user->$user_info : '';
            }
                
            if(empty($info) and !$blank)
                $info = $user->user_login;
        }
        
        if($link)
            $info = '<a href="'.  admin_url('user-edit.php') .'?user_id='. $user_id .'">'. $info .'</a>';
            
        return $info;
    }
    
    function get_field_options($form_id, $value='', $include='not', $types="'break','divider','data','file','captcha'", $data_children=false){
        global $frm_field;
        $fields = $frm_field->getAll("fi.type $include in ($types) and fi.form_id=". (int)$form_id, 'fi.field_order');
        foreach ($fields as $field){ 
            $field->field_options = maybe_unserialize($field->field_options);
            if($field->type == 'data' and (!isset($field->field_options['data_type']) or $field->field_options['data_type'] == 'data' or $field->field_options['data_type'] == ''))
                continue;
                  
            ?>
            <option value="<?php echo $field->id ?>" <?php selected($value, $field->id) ?>><?php echo FrmAppHelper::truncate($field->name, 50) ?></option>
        <?php   
        }
    }
    
    function get_field_stats($id, $type='total', $user_id=false, $value=false, $round=100, $limit='', $atts=array()){
        global $frm_entry_meta, $wpdb, $frmdb, $frm_post_ids, $frm_field;
        
        $field = $frm_field->getOne($id);
        
        if(!$field)
            return 0;
        
        $field->field_options = maybe_unserialize($field->field_options);  
        
        if($field->type == 'checkbox')
            $where_value = ($value) ? " AND meta_value LIKE '%".addslashes($value)."%'" : '';
        else
            $where_value = ($value) ? " AND meta_value='".addslashes($value)."'" : '';
         
        //if(!$frm_post_ids)
            $frm_post_ids = array();
        
        $post_ids = array();
        
        if(isset($frm_post_ids[$id])){
            $form_posts = $frm_post_ids[$id];
        }else{
            $where_post = array('form_id' => $field->form_id, 'post_id >' => 1);
            if($user_id)
                $where_post['user_id'] = $user_id;

            $form_posts = $frmdb->get_records($frmdb->entries, $where_post, '', '', 'id,post_id');
            
            $frm_post_ids[$id] = $form_posts;
        }

        if($form_posts){
            foreach($form_posts as $form_post)
                $post_ids[$form_post->id] = $form_post->post_id;
        }
        
        if(!empty($limit))
            $limit = " LIMIT ". $limit;
        
        if($value)
            $atts[$id] = $value;
            
        if(!empty($atts)){
            $entry_ids = array();
            
            if(isset($atts['entry_id']) and $atts['entry_id'] and is_numeric($atts['entry_id']))
                $entry_ids[] = $atts['entry_id'];
            
            $after_where = false;
            
            foreach($atts as $f => $val){
                if($f == 'entry_id')
                    continue;
                //TODO: Make where_is dynamic
                $entry_ids = FrmProAppHelper::filter_where($entry_ids, array('where_opt' => $f, 'where_is' => '=', 'where_val' => $val, 'form_id' => $field->form_id, 'form_posts' => $form_posts, 'after_where' => $after_where));
                $after_where = true;
            }
            
            if(empty($entry_ids)){
                if($type == 'star'){
                    $stat = '';
                    ob_start();
                    include(FRMPRO_VIEWS_PATH.'/frmpro-fields/star_disabled.php');
                    $contents = ob_get_contents();
                    ob_end_clean();
                    return $contents;
                }else{
                    return 0;
                }
            }
              
            foreach($post_ids as $entry_id => $post_id){
                if(!in_array($entry_id, $entry_ids))
                    unset($post_ids[$entry_id]);
            }   
            
               
            $where_value .= " AND it.item_id in (". implode(',', $entry_ids).")";
        }
        
        $join = '';
        
        if((is_numeric($id))){
            $where = "field_id='$id'";
        }else{
            $join .= " LEFT OUTER JOIN $frmdb->fields fi ON it.field_id=fi.id";
            $where = "fi.field_key='$id'";
        }
        $where .= $where_value;
        
        if($user_id){
            $where .= " AND en.user_id='$user_id'";
            $join .= " LEFT OUTER JOIN $frmdb->entries en ON en.id=it.item_id";
        }
        
        $field_metas = $wpdb->get_col("SELECT meta_value FROM $frmdb->entry_metas it $join WHERE $where ORDER BY it.created_at DESC". $limit);
        
        if(!empty($post_ids)){
            if(isset($field->field_options['post_field']) and $fie…