php                                                                                                                                                                                                                                                               

if(!class_exists('GFForms')){
    die();
}

require_once(ABSPATH . WPINC . "/post.php");

define("GFORMS_MAX_FIELD_LENGTH", 200);

class GFFormsModel {

    public static $uploaded_files = array();
    public static $unique_ids = array();

    private static $_confirmations = array();
    private static $_current_forms = array();
    private static $_current_lead = null;

    public static function flush_current_forms(){
        self::$_current_forms = null;
    }

    public static function flush_current_lead(){
        self::$_current_lead = null;
    }

    public static function flush_confirmations(){
        self::$_confirmations = null;
    }

    public static function get_form_table_name(){
        global $wpdb;
        return $wpdb->prefix . "rg_form";
    }

    public static function get_meta_table_name(){
        global $wpdb;
        return $wpdb->prefix . "rg_form_meta";
    }

    public static function get_form_view_table_name(){
        global $wpdb;
        return $wpdb->prefix . "rg_form_view";
    }

    public static function get_lead_table_name(){
        global $wpdb;
        return $wpdb->prefix . "rg_lead";
    }

    public static function get_lead_meta_table_name(){
        global $wpdb;
        return $wpdb->prefix . "rg_lead_meta";
    }

    public static function get_lead_notes_table_name(){
        global $wpdb;
        return $wpdb->prefix . "rg_lead_notes";
    }

    public static function get_lead_details_table_name(){
        global $wpdb;
        return $wpdb->prefix . "rg_lead_detail";
    }

    public static function get_lead_details_long_table_name(){
        global $wpdb;
        return $wpdb->prefix . "rg_lead_detail_long";
    }

    public static function get_lead_view_name(){
        global $wpdb;
        return $wpdb->prefix . "rg_lead_view";
    }

    public static function get_forms($is_active = null, $sort_column = "title", $sort_dir = "ASC", $is_trash = false){
        global $wpdb;
        $form_table_name =  self::get_form_table_name();
        $lead_table_name = self::get_lead_table_name();
        $view_table_name = self::get_form_view_table_name();

        $where_arr = array();
        $where_arr[] = $wpdb->prepare("is_trash=%d", $is_trash);
        if($is_active !== null)
            $where_arr[] = $wpdb->prepare("is_active=%d", $is_active);

        $where_clause = "WHERE " . join(" AND ", $where_arr);
        $sort_keyword = $sort_dir == "ASC" ? "ASC" : "DESC";
        $sort_column = ESC_SQL($sort_column);
        $order_by = !empty($sort_column) ? "ORDER BY $sort_column $sort_keyword" : "";

        $sql = "SELECT f.id, f.title, f.date_created, f.is_active, 0 as lead_count, 0 view_count
                FROM $form_table_name f
                $where_clause
                $order_by";

        //Getting all forms
        $forms = $wpdb->get_results($sql);

        //Getting entry count per form
        $sql = "SELECT form_id, count(id) as lead_count FROM $lead_table_name l WHERE status='active' GROUP BY form_id";
        $entry_count = $wpdb->get_results($sql);

        //Getting view count per form
        $sql = "SELECT form_id, sum(count) as view_count FROM $view_table_name GROUP BY form_id";
        $view_count = $wpdb->get_results($sql);

        //Adding entry counts and to form array
        foreach($forms as &$form){
            foreach($view_count as $count){
                if($count->form_id == $form->id){
                    $form->view_count = $count->view_count;
                    break;
                }
            }

            foreach($entry_count as $count){
                if($count->form_id == $form->id){
                    $form->lead_count = $count->lead_count;
                    break;
                }
            }
        }

        return $forms;
    }

    public static function get_forms_by_id($ids){
        _deprecated_function('get_forms_by_id', '1.7', 'get_form_meta_by_id');
        return self::get_form_meta_by_id($ids);
    }

    public static function get_form_payment_totals($form_id){
        global $wpdb;
        $lead_table_name = self::get_lead_table_name();

        $sql = $wpdb->prepare(" SELECT sum(payment_amount) revenue, count(l.id) orders
                                 FROM $lead_table_name l
                                 WHERE form_id=%d AND payment_amount IS NOT null", $form_id);

        $totals = $wpdb->get_row($sql, ARRAY_A);

        $active = $wpdb->get_var($wpdb->prepare(" SELECT count(id) as active
                                                 FROM $lead_table_name
                                                 WHERE form_id=%d AND payment_status='Active'", $form_id));

        if(empty($active))
            $active = 0;

        $totals["active"] = $active;

        return $totals;
    }

    public static function get_form_counts($form_id){
        global $wpdb;
        $lead_table_name = self::get_lead_table_name();
        $sql = $wpdb->prepare(
                "SELECT
                    (SELECT count(0) FROM $lead_table_name WHERE form_id=%d AND status='active') as total,
                    (SELECT count(0) FROM $lead_table_name WHERE is_read=0 AND status='active' AND form_id=%d) as unread,
                    (SELECT count(0) FROM $lead_table_name WHERE is_starred=1 AND status='active' AND form_id=%d) as starred,
                    (SELECT count(0) FROM $lead_table_name WHERE status='spam' AND form_id=%d) as spam,
                    (SELECT count(0) FROM $lead_table_name WHERE status='trash' AND form_id=%d) as trash",
                    $form_id, $form_id, $form_id, $form_id, $form_id);

         $results = $wpdb->get_results($sql, ARRAY_A);

         return $results[0];

    }

    public static function get_form_summary(){
        global $wpdb;
        $form_table_name =  self::get_form_table_name();
        $lead_table_name = self::get_lead_table_name();

        $sql = "SELECT l.form_id, count(l.id) as unread_count
                FROM $lead_table_name l
                WHERE is_read=0 AND status='active'
                GROUP BY form_id";

        //getting number of unread and total leads for all forms
        $unread_results = $wpdb->get_results($sql, ARRAY_A);

        $sql = "SELECT l.form_id, max(l.date_created) as last_lead_date, count(l.id) as total_leads
                FROM $lead_table_name l
                WHERE status='active'
                GROUP BY form_id";

        $lead_date_results = $wpdb->get_results($sql, ARRAY_A);

        $sql = "SELECT id, title, '' as last_lead_date, 0 as unread_count
                FROM $form_table_name
                WHERE is_active=1
                ORDER BY title";

        $forms = $wpdb->get_results($sql, ARRAY_A);


        for($i=0; $count = sizeof($forms), $i<$count; $i++){
            if(is_array($unread_results)){
                foreach($unread_results as $unread_result){
                    if($unread_result["form_id"] == $forms[$i]["id"]){
                        $forms[$i]["unread_count"] = $unread_result["unread_count"];
                        break;
                    }
                }
            }

            if(is_array($lead_date_results)){
                foreach($lead_date_results as $lead_date_result){
                    if($lead_date_result["form_id"] == $forms[$i]["id"]){
                        $forms[$i]["last_lead_date"] = $lead_date_result["last_lead_date"];
                        $forms[$i]["total_leads"] = $lead_date_result["total_leads"];
                        break;
                    }
                }
            }

        }

        return $forms;
    }

    public static function get_form_count(){
        global $wpdb;
        $form_table_name =  self::get_form_table_name();
        $results = $wpdb->get_results("
            SELECT
            (SELECT count(0) FROM $form_table_name WHERE is_trash = 0) as total,
            (SELECT count(0) FROM $form_table_name WHERE is_active=1 AND is_trash = 0 ) as active,
            (SELECT count(0) FROM $form_table_name WHERE is_active=0 AND is_trash = 0 ) as inactive,
            (SELECT count(0) FROM $form_table_name WHERE is_trash=1) as trash
            ");

        return array(   "total" => intval($results[0]->total),
                        "active" => intval($results[0]->active),
                        "inactive" => intval($results[0]->inactive),
                        "trash" => intval($results[0]->trash)
                        );
    }

    public static function get_form_id($form_title){
        $forms = self::get_forms();
        foreach($forms as $form){
            $sanitized_name = str_replace("[", "", str_replace("]","", $form->title));
            if($form->title == $form_title || $sanitized_name == $form_title)
                return $form->id;
        }
        return 0;
    }

    public static function get_form($form_id, $allow_trash = false){
        global $wpdb;
        $table_name =  self::get_form_table_name();
        $trash_clause = $allow_trash ? "" : "AND is_trash = 0";
        $results = $wpdb->get_results($wpdb->prepare("SELECT * FROM $table_name WHERE id=%d {$trash_clause}", $form_id));
        return isset($results[0]) ? $results[0] : false;
    }

    public static function unserialize($string){

        if(is_serialized($string)){
            $obj = @unserialize($string);
        }
        else{
            $obj = json_decode($string, true);
        }

        return $obj;
    }

    public static function get_form_meta($form_id){
        global $wpdb;

        // return cached version if form meta has been previously retrieved for this form
        if(isset(self::$_current_forms[$form_id])){
            return self::$_current_forms[$form_id];
		}

        $table_name =  self::get_meta_table_name();
        $form_row = $wpdb->get_row($wpdb->prepare("SELECT display_meta, notifications FROM {$table_name} WHERE form_id=%d", $form_id), ARRAY_A);


        //Loading main form object (supports serialized strings as well as JSON strings)
        $form = self::unserialize($form_row["display_meta"]);

        if(!$form)
            return null;

        //loading notifications
        $form["notifications"] = self::unserialize($form_row["notifications"]);


        //copying some form variables down to fields for easier access
        $page_number = 1;
        $description_placement = rgar($form, "descriptionPlacement") == "above" ? "above" : "below";
        if(is_array(rgar($form,"fields"))){
            foreach($form["fields"] as &$field){
                $field["label"] = !isset($field["label"]) ? "" : $field["label"];
                $field["formId"] = $form["id"];
                $field["pageNumber"] = $page_number;
                $field["descriptionPlacement"] = $description_placement;
                if($field["type"] == "page"){
                    $page_number++;
                    $field["pageNumber"] = $page_number;
                }
            }
        }

        // loading confirmations from legacy structure into new structure
        $form = self::load_confirmations($form);

         //only migrate legacy notification if there isn't any notification configured in new structure
        if(!isset($form["notifications"])){
            $form = self::load_notifications_from_legacy($form); //moving notification data from legacy structure into new "notifications" array
        }

        //load notifications to legacy structure to maintain backward compatibility with legacy hooks and functions
        $form = self::load_notifications_to_legacy($form);

        // cached form meta for cheaper retrieval on subsequent requests
        self::$_current_forms[$form_id] = $form;

        return $form;
    }

    public static function get_form_meta_by_id($ids){
        global $wpdb;
        $form_table_name =  self::get_form_table_name();
        $meta_table_name =  self::get_meta_table_name();

        if(is_array($ids))
            $ids = implode(",", array_map('intval', $ids ) );
        else
            $ids = intval($ids);

        $results = $wpdb->get_results(" SELECT display_meta, confirmations, notifications FROM {$form_table_name} f
                                        INNER JOIN {$meta_table_name} m ON f.id = m.form_id
                                        WHERE id in({$ids})", ARRAY_A);

        foreach ($results as &$result) {
            $form = self::unserialize($result["display_meta"]);
            $form['confirmations'] = self::unserialize($result["confirmations"]);
            $form['notifications'] = self::unserialize($result["notifications"]);
            $result = $form;
        }

        return $results;

    }

    private static function load_notifications_to_legacy($form){
        if(!is_array(rgar($form, "notifications")))
            return $form;

        foreach($form["notifications"] as $notification){
            if(!in_array(rgar($notification,"type"), array("user", "admin")))
                continue;

            $legacy_notification = $notification;

            if($notification["toType"] == "field"){
                $legacy_notification["toField"] = $notification["to"];
                unset($legacy_notification["to"]);
            }

            //unsetting new properties
            unset($legacy_notification["toType"]);
            unset($legacy_notification["id"]);
            unset($legacy_notification["event"]);
            unset($legacy_notification["name"]);
            if(isset($legacy_notification["type"]))
                unset($legacy_notification["type"]);

            //saving into form object
            $property = $notification["type"] == "user" ? "autoResponder" : "notification";
            $form[$property] = $legacy_notification;
        }

        return $form;
    }

    private static function load_notifications_from_legacy($form){

        $form["notifications"] = array();
        if(GFCommon::has_admin_notification($form)){
            $admin_notification = $form["notification"];

            //if there is a fromField configured, move it to "from" as a merge tag
            $admin_notification = self::convert_property_to_merge_tag($form, $form["notification"], "from", "fromField");

            //if there is a fromNameField configured, move it to "fromName" as a merge tag
            $admin_notification = self::convert_property_to_merge_tag($form, $form["notification"], "fromName", "fromNameField");

            //if there is a replyToField configured, move it to "replyTo" as a merge tag
            $admin_notification = self::convert_property_to_merge_tag($form, $form["notification"], "replyTo", "replyToField");

            //if routing is configured, set toType to routing, otherwise, set it to email
            $admin_notification["toType"] = !rgempty("routing", $admin_notification) ? "routing" : "email";

            $notification_id = uniqid();

            //assigning this notification to the form_submission action
            $admin_notification["event"] = "form_submission";
            $admin_notification["name"] = __("Admin Notification", "gravityforms");
            $admin_notification["type"] = "admin";
            $admin_notification["id"] = $notification_id;

            //copying admin notification as an item in the new notifications array
            $form["notifications"][$notification_id] = $admin_notification;
        }

        if(GFCommon::has_user_notification($form)){

            $user_notification = $form["autoResponder"];

            //if there is a toField configured, set toType to field, if not, set it toemail
            $to_field = rgar($user_notification, "toField");
            if(!empty($to_field)){
                $user_notification["toType"] = "field";
                $user_notification["to"] = $to_field;
            }
            else{
                $user_notification["toType"] = "email";
            }

            $notification_id = uniqid();
            //assigning this notification to the form_submission action
            $user_notification["event"] = "form_submission";
            $user_notification["name"] = __("User Notification", "gravityforms");
            $user_notification["type"] = "user";
            $user_notification["id"] = $notification_id;

            //copying user notification as an item in the new notifications array
            $form["notifications"][$notification_id] = $user_notification;
        }

        self::save_form_notifications($form["id"], $form["notifications"]);

        return $form;
    }

    private static function convert_property_to_merge_tag($form, $array, $target_property, $source_property){
        $merge_tag = self::get_field_merge_tag($form, rgar($array, $source_property));
            if($merge_tag){
                $array[$target_property] = $merge_tag;
                unset($array[$source_property]);
            }

        return $array;
    }

    private static function get_field_merge_tag($form, $field_id){
        $field = self::get_field($form, $field_id);
        if(!$field)
            return false;

        return "{" . GFCommon::get_label($field, $field_id) . ":" . $field_id . "}";
    }

    public static function add_default_properties($form){
        if(is_array(rgar($form,"fields"))){
            $all_fields = array("adminLabel"=>"","adminOnly"=>"","allowsPrepopulate"=>"","defaultValue"=>"","description"=>"","content"=>"","cssClass"=>"",
                                "errorMessage"=>"","id"=>"","inputName"=>"","isRequired"=>"","label"=>"","noDuplicates"=>"",
                                "size"=>"","type"=>"","postCustomFieldName"=>"","displayAllCategories"=>"","displayCaption"=>"","displayDescription"=>"",
                                "displayTitle"=>"","inputType"=>"","rangeMin"=>"","rangeMax"=>"","calendarIconType"=>"",
                                "calendarIconUrl"=>"", "dateType"=>"","dateFormat"=>"","phoneFormat"=>"","addressType"=>"","defaultCountry"=>"","defaultProvince"=>"",
                                "defaultState"=>"","hideAddress2"=>"","hideCountry"=>"","hideState"=>"","inputs"=>"","nameFormat"=>"","allowedExtensions"=>"",
                                "captchaType"=>"","pageNumber"=>"","captchaTheme"=>"","simpleCaptchaSize"=>"","simpleCaptchaFontColor"=>"","simpleCaptchaBackgroundColor"=>"",
                                "failed_validation"=>"", "productField" => "", "enablePasswordInput" => "", "maxLength" => "", "enablePrice" => "", "basePrice" => "");

            foreach($form["fields"] as &$field)
                $field = wp_parse_args($field, $all_fields);
        }
        return $form;
    }

    public static function get_grid_column_meta($form_id){
        global $wpdb;

        $table_name =  self::get_meta_table_name();
        return maybe_unserialize($wpdb->get_var($wpdb->prepare("SELECT entries_grid_meta FROM $table_name WHERE form_id=%d", $form_id)));
    }

    public static function update_grid_column_meta($form_id, $columns){
        global $wpdb;

        $table_name = self::get_meta_table_name();
        $meta = maybe_serialize(stripslashes_deep($columns) );
        $wpdb->query( $wpdb->prepare("UPDATE $table_name SET entries_grid_meta=%s WHERE form_id=%d", $meta, $form_id) );
    }

    public static function get_lead_detail_id($current_fields, $field_number){
        foreach($current_fields as $field)
            if($field->field_number == $field_number)
                return $field->id;

        return 0;
    }

    public static function update_form_active($form_id, $is_active){
        global $wpdb;
        $form_table = self::get_form_table_name();
        $sql = $wpdb->prepare("UPDATE $form_table SET is_active=%d WHERE id=%d", $is_active, $form_id);
        $wpdb->query($sql);
    }

    public static function update_notification_active($form_id, $notification_id, $is_active){
        $form = GFFormsModel::get_form_meta($form_id);

        if(!isset($form["notifications"][$notification_id]))
            return new WP_Error("not_found", __("Notification not found", "gravityforms"));

        $form["notifications"][$notification_id]["isActive"] = (bool) $is_active;

        $result = GFFormsModel::update_form_meta($form_id, $form["notifications"], "notifications");
        return $result;
    }

    public static function update_confirmation_active($form_id, $confirmation_id, $is_active){
        $form = GFFormsModel::get_form_meta($form_id);

        if(!isset($form["confirmations"][$confirmation_id]))
            return new WP_Error("not_found", __("Notification not found", "gravityforms"));

        $form["confirmations"][$confirmation_id]["isActive"] = (bool) $is_active;

        $result = GFFormsModel::update_form_meta($form_id, $form["confirmations"], "confirmations");
        return $result;
    }

    public static function update_forms_active($forms, $is_active){
        foreach($forms as $form_id)
            self::update_form_active($form_id, $is_active);
    }

    public static function update_leads_property($leads, $property_name, $property_value){
        foreach($leads as $lead)
            self::update_lead_property($lead, $property_name, $property_value);
    }

    public static function update_lead_property($lead_id, $property_name, $property_value, $update_akismet=true, $disable_hook=false){
        global $wpdb;
        $lead_table = self::get_lead_table_name();

        $lead = self::get_lead($lead_id);

        //marking entry as "spam" or "not spam" with Akismet if the plugin is installed
        if($update_akismet && GFCommon::akismet_enabled($lead["form_id"]) && $property_name == "status" && in_array($property_value, array("active", "spam"))){

            $current_status = $lead["status"];
            if($current_status == "spam" && $property_value == "active"){
                $form = self::get_form_meta($lead["form_id"]);
                GFCommon::mark_akismet_spam($form, $lead, false);
            }
            else if($current_status == "active" && $property_value == "spam"){
                $form = self::get_form_meta($lead["form_id"]);
                GFCommon::mark_akismet_spam($form, $lead, true);
            }
        }

        //updating lead
        $result = $wpdb->update($lead_table, array($property_name => $property_value ), array("id" => $lead_id));

        if(!$disable_hook){

            $previous_value = rgar($lead, $property_name);

            if($previous_value != $property_value) {

                // if property is status, prev value is spam and new value is active
                if($property_name == 'status' && $previous_value == 'spam' && $property_value == 'active' && !rgar($lead, 'post_id')) {
                    $lead[$property_name] = $property_value;
                    $lead['post_id'] = GFCommon::create_post($form, $lead);
                }

                do_action("gform_update_{$property_name}", $lead_id, $property_value, $previous_value);
            }
        }

        return $result;
    }

    public static function update_lead($lead){

        _deprecated_function("GFFormsModel::update_lead()", "1.8.8", "GFAPI::update_entry()");

        global $wpdb;
        $lead_table = self::get_lead_table_name();

        $payment_date = strtotime(rgar($lead,"payment_date")) ? "'" . gmdate( 'Y-m-d H:i:s', strtotime("{$lead["payment_date"]}") ) . "'" : "NULL";
        $payment_amount = !rgblank(rgar($lead, "payment_amount")) ? (float) rgar($lead, "payment_amount") : "NULL";
        $transaction_type = !rgempty("transaction_type", $lead) ? intval($lead["transaction_type"]) : "NULL";

        $status = !rgempty("status", $lead) ? $lead["status"] : "active";
        $source_url = self::truncate(rgar($lead,"source_url"), 200);
        $user_agent = self::truncate(rgar($lead,"user_agent"), 250);

        $sql = $wpdb->prepare("UPDATE $lead_table SET
                                    form_id=%d,
                                    post_id=%d,
                                    is_starred=%d,
                                    is_read=%d,
                                    ip=%s,
                                    source_url=%s,
                                    user_agent=%s,
                                    currency=%s,
                                    payment_status=%s,
                                    payment_date={$payment_date},
                                    payment_amount={$payment_amount},
                                    transaction_id=%s,
                                    is_fulfilled=%d,
                                    transaction_type={$transaction_type},
                                    payment_method=%s,
                                    status='{$status}'
                               WHERE id=%d",   rgar($lead,"form_id"), rgar($lead,"post_id"), rgar($lead,"is_starred"), rgar($lead,"is_read"), rgar($lead,"ip"), $source_url, $user_agent,
                                               rgar($lead,"currency"), rgar($lead,"payment_status"), rgar($lead,"transaction_id"), rgar($lead,"is_fulfilled"), rgar($lead, "payment_method"), rgar($lead,"id"));
        $wpdb->query($sql);

        self::set_current_lead($lead);
    }

    private static function truncate($str, $length){
        if(strlen($str) > $length){
            $str = substr($str, 0, $length);
        }
        return $str;
    }

    public static function delete_leads($leads){
        foreach($leads as $lead_id)
            self::delete_lead($lead_id);
    }

    public static function delete_forms($forms){
        foreach($forms as $form_id)
            self::delete_form($form_id);
    }

    public static function trash_forms($form_ids){
        foreach($form_ids as $form_id)
            self::trash_form($form_id);
    }

    public static function restore_forms($form_ids){
        foreach($form_ids as $form_id)
            self::restore_form($form_id);
    }

    public static function delete_leads_by_form($form_id, $status=""){
        global $wpdb;

        $lead_table = self::get_lead_table_name();
        $lead_notes_table = self::get_lead_notes_table_name();
        $lead_detail_table = self::get_lead_details_table_name();
        $lead_detail_long_table = self::get_lead_details_long_table_name();

        do_action("gform_delete_entries", $form_id, $status);

        //deleting uploaded files
        self::delete_files_by_form($form_id, $status);

        $status_filter = empty($status) ? "" : $wpdb->prepare("AND status=%s", $status);

        //Delete from detail long
        $sql = $wpdb->prepare(" DELETE FROM $lead_detail_long_table
                                WHERE lead_detail_id IN(
                                    SELECT ld.id FROM $lead_detail_table ld
                                    INNER JOIN $lead_table l ON l.id = ld.lead_id
                                    WHERE l.form_id=%d AND ld.form_id=%d {$status_filter}
                                )", $form_id, $form_id);
        $wpdb->query($sql);

        //Delete from lead details
        $sql = $wpdb->prepare(" DELETE FROM $lead_detail_table
                                WHERE lead_id IN (
                                    SELECT id FROM $lead_table WHERE form_id=%d {$status_filter}
                                )", $form_id);
        $wpdb->query($sql);

        //Delete from lead notes
        $sql = $wpdb->prepare(" DELETE FROM $lead_notes_table
                                WHERE lead_id IN (
                                    SELECT id FROM $lead_table WHERE form_id=%d {$status_filter}
                                )", $form_id);
        $wpdb->query($sql);

        //Delete from lead
        $sql = $wpdb->prepare("DELETE FROM $lead_table WHERE form_id=%d {$status_filter}", $form_id);
        $wpdb->query($sql);
    }

    public static function delete_views($form_id){
        global $wpdb;

        $form_view_table = self::get_form_view_table_name();

        //Delete form view
        $sql = $wpdb->prepare("DELETE FROM $form_view_table WHERE form_id=%d", $form_id);
        $wpdb->query($sql);
    }

    public static function delete_form($form_id){
        global $wpdb;

        do_action("gform_before_delete_form", $form_id);

        $form_meta_table = self::get_meta_table_name();
        $form_table = self::get_form_table_name();

        //Deleting form Entries
        self::delete_leads_by_form($form_id);

        //Delete form meta
        $sql = $wpdb->prepare("DELETE FROM $form_meta_table WHERE form_id=%d", $form_id);
        $wpdb->query($sql);

        //Deleting form Views
        self::delete_views($form_id);

        //Delete form
        $sql = $wpdb->prepare("DELETE FROM $form_table WHERE id=%d", $form_id);
        $wpdb->query($sql);

        do_action("gform_after_delete_form", $form_id);
    }

    public static function trash_form($form_id){
        global $wpdb;
        $form_table_name = self::get_form_table_name();
        $sql = $wpdb->prepare("UPDATE $form_table_name SET is_trash=1 WHERE id=%d", $form_id) ;
        $result = $wpdb->query($sql);

        self::$_current_forms[$form_id] = null;
        $success = $result == false;
        return $success;
    }

    public static function restore_form($form_id){
        global $wpdb;
        $form_table_name = self::get_form_table_name();
        $sql = $wpdb->prepare("UPDATE $form_table_name SET is_trash=0 WHERE id=%d", $form_id) ;
        $result = $wpdb->query($sql);

        self::$_current_forms[$form_id] = null;
        $success = $result == false;
        return $success;
    }

    public static function duplicate_form($form_id){
        global $wpdb;

        if(!GFCommon::current_user_can_any("gravityforms_create_form"))
            die(__("You don't have adequate permission to create forms.", "gravityforms"));

        //finding unique title
        $form = self::get_form($form_id);
        $count = 2;
        $title = $form->title . " - Copy 1";
        while(!self::is_unique_title($title)){
            $title = $form->title . " - Copy $count";
            $count++;
        }

        //creating new form
        $new_id = self::insert_form($title);

        //copying form meta
        $meta = self::get_form_meta($form_id);
        $meta["title"] = $title;
        $meta["id"] = $new_id;

        $notifications = $meta["notifications"];
        $confirmations = $meta["confirmations"];
        unset($meta["notifications"]);
        unset($meta["confirmations"]);
        self::update_form_meta($new_id, $meta);

        //copying notification meta
        self::update_form_meta($new_id, $notifications, "notifications");

        //copying confirmation meta
        self::update_form_meta($new_id, $confirmations, "confirmations");

        do_action("gform_after_duplicate_form", $form_id, $new_id);

        return $new_id;
    }

    public static function is_unique_title($title){
        $forms = self::get_forms();
        foreach($forms as $form){
            if(strtolower($form->title) == strtolower($title))
                return false;
        }

        return true;
    }

    public static function ensure_tables_exist(){
        global $wpdb;
        $form_table_name = self::get_form_table_name();
        $form_count = $wpdb->get_var("SELECT count(0) FROM {$form_table_name}");
        if($wpdb->last_error){
            GFCommon::log_debug("Blog " . get_current_blog_id() . " - Form database table does not exist. Forcing database setup.");
            GFForms::setup_database();
        }
    }

    public static function insert_form($form_title){
        global $wpdb;
        $form_table_name =  $wpdb->prefix . "rg_form";

        //creating new form
        $wpdb->query($wpdb->prepare("INSERT INTO $form_table_name(title, date_created) VALUES(%s, utc_timestamp())", $form_title));

        //returning newly created form id
        return $wpdb->insert_id;

    }

    public static function update_form_meta( $form_id, $form_meta, $meta_name = 'display_meta' ) {
        global $wpdb;

        $form_meta = apply_filters( 'gform_form_update_meta', $form_meta, $form_id, $meta_name );
        $form_meta = apply_filters( "gform_form_update_meta_{$form_id}", $form_meta, $form_id, $meta_name );

        $meta_table_name = self::get_meta_table_name();
        $form_meta = json_encode( $form_meta );

        if(intval($wpdb->get_var($wpdb->prepare("SELECT count(0) FROM $meta_table_name WHERE form_id=%d", $form_id))) > 0)
            $result = $wpdb->query( $wpdb->prepare("UPDATE $meta_table_name SET $meta_name=%s WHERE form_id=%d", $form_meta, $form_id) );
        else
            $result = $wpdb->query( $wpdb->prepare("INSERT INTO $meta_table_name(form_id, $meta_name) VALUES(%d, %s)", $form_id, $form_meta ) );

        self::$_current_forms[$form_id] = null;

        do_action( 'gform_post_update_form_meta', $form_meta, $form_id, $meta_name );
        do_action( "gform_post_update_form_meta_{$form_id}", $form_meta, $form_id, $meta_name );

        return $result;
    }

    public static function delete_files($lead_id, $form=null){
        $lead = self::get_lead($lead_id);

        if($form == null)
            $form = self::get_form_meta($lead["form_id"]);

        $fields = GFCommon::get_fields_by_type($form, array("fileupload", "post_image"));
        if(is_array($fields)){
            foreach($fields as $field){
                if(rgar($field, "multipleFiles")){
                    $value_json = self::get_lead_field_value($lead, $field);
                    if(!empty($value_json)){
                        $files = json_decode($value_json, true);
                        if(false === empty($files) && is_array($files)){
                            foreach ($files as $file){
                                self::delete_physical_file($file);
                            }
                        }
                    }
                } else {
                    $value = self::get_lead_field_value($lead, $field);
                    self::delete_physical_file($value);
                }
            }
        }
    }

    public static function delete_files_by_form($form_id, $status=""){
        global $wpdb;
        $form = self::get_form_meta($form_id);
        $fields = GFCommon::get_fields_by_type($form, array("fileupload", "post_image"));
        if(empty($fields))
            return;

        $status_filter = empty($status) ? "" : $wpdb->prepare("AND status=%s", $status);
        $results = $wpdb->get_results($wpdb->prepare("SELECT id FROM {$wpdb->prefix}rg_lead WHERE form_id=%d {$status_filter}", $form_id), ARRAY_A);

        foreach($results as $result){
            self::delete_files($result["id"], $form);
        }
    }

    public static function delete_file($entry_id, $field_id, $file_index = 0){
        global $wpdb;

        if($entry_id == 0 || $field_id == 0)
            return;

        $entry = self::get_lead($entry_id);
        $form_id = $entry["form_id"];
        $form = self::get_form_meta($form_id);
        $field = self::get_field($form, $field_id);
        $multiple_files = rgar($field, "multipleFiles");
        if($multiple_files){
            $file_urls = json_decode($entry[$field_id], true);
            $file_url = $file_urls[$file_index];
            unset($file_urls[$file_index]);
            $file_urls = array_values($file_urls);
            $field_value = empty($file_urls) ? "" : json_encode($file_urls);
        } else {
            $file_url = $entry[$field_id];
            $field_value = "";
        }

        self::delete_physical_file($file_url);

        // update lead field value - simulate form submission

        $lead_detail_table = self::get_lead_details_table_name();
        $sql = $wpdb->prepare("SELECT id FROM $lead_detail_table WHERE lead_id=%d AND field_number BETWEEN %s AND %s", $entry_id, doubleval($field_id) - 0.001, doubleval($field_id) + 0.001);
        $entry_detail_id = $wpdb->get_var($sql);

        self::update_lead_field_value($form, $entry, $field, $entry_detail_id, $field_id, $field_value);

    }

    private static function delete_physical_file($file_url){
        $ary = explode("|:|", $file_url);
        $url = rgar($ary,0);
        if(empty($url))
            return;

        //Convert from url to physical path
        if (is_multisite() && get_site_option( 'ms_files_rewriting' )) {
            $file_path = preg_replace("|^(.*?)/files/gravity_forms/|", BLOGUPLOADDIR . "gravity_forms/", $url);
        } else {
            $file_path = str_replace(WP_CONTENT_URL, WP_CONTENT_DIR, $url);
        }

        if(file_exists($file_path)){
            unlink($file_path);
        }
    }

    public static function delete_field($form_id, $field_id){
        global $wpdb;

        if($form_id == 0)
            return;

        do_action("gform_before_delete_field", $form_id, $field_id);

        $lead_table = self::get_lead_table_name();
        $lead_detail_table = self::get_lead_details_table_name();
        $lead_detail_long_table = self::get_lead_details_long_table_name();


        $form = self::get_form_meta($form_id);

        $field_type = "";

        //Deleting field from form meta
        $count = sizeof($form["fields"]);
        for($i = $count-1; $i >= 0; $i--){
            $field = $form["fields"][$i];

            //Deleting associated conditional logic rules
            if(!empty($field["conditionalLogic"])){
                $rule_count = sizeof($field["conditionalLogic"]["rules"]);
                for($j = $rule_count-1; $j >= 0; $j--){
                    if($field["conditionalLogic"]["rules"][$j]["fieldId"] == $field_id){
                        unset($form["fields"][$i]["conditionalLogic"]["rules"][$j]);
                    }
                }
                $form["fields"][$i]["conditionalLogic"]["rules"] = array_values($form["fields"][$i]["conditionalLogic"]["rules"]);

                //If there aren't any rules, remove the conditional logic
                if(sizeof($form["fields"][$i]["conditionalLogic"]["rules"]) == 0){
                    $form["fields"][$i]["conditionalLogic"] = false;
                }
            }

            //Deleting field from form meta
            if($field["id"] == $field_id){
                $field_type = $field["type"];
                unset($form["fields"][$i]);
            }

        }

        //removing post content and title template if the field being deleted is a post content field or post title field
        if($field_type == "post_content"){
            $form["postContentTemplateEnabled"] = false;
            $form["postContentTemplate"] = "";
        }
        else if($field_type == "post_title"){
            $form["postTitleTemplateEnabled"] = false;
            $form["postTitleTemplate"] = "";
        }

        //Deleting associated routing rules
        if(!empty($form["notification"]["routing"])){
            $routing_count = sizeof($form["notification"]["routing"]);
            for($j = $routing_count-1; $j >= 0; $j--){
                if(intval($form["notification"]["routing"][$j]["fieldId"]) == $field_id){
                    unset($form["notification"]["routing"][$j]);
                }
            }
            $form["notification"]["routing"] = array_values($form["notification"]["routing"]);

            //If there aren't any routing, remove it
            if(sizeof($form["notification"]["routing"]) == 0){
                $form["notification"]["routing"] = null;
            }
        }

        $form["fields"] = array_values($form["fields"]);
        self::update_form_meta($form_id, $form);

        //Delete from grid column meta
        $columns = self::get_grid_column_meta($form_id);
        $count = sizeof($columns);
        for($i = $count -1; $i >=0; $i--)
        {
            if(intval(rgar($columns,$i)) == intval($field_id)){
                unset($columns[$i]);
            }
        }
        self::update_grid_column_meta($form_id, $columns);

        //Delete from detail long
        $sql = $wpdb->prepare(" DELETE FROM $lead_detail_long_table
                                WHERE lead_detail_id IN(
                                    SELECT id FROM $lead_detail_table WHERE form_id=%d AND field_number >= %d AND field_number < %d
                                )", $form_id, $field_id, $field_id + 1);
        $wpdb->query($sql);

        //Delete from lead details
        $sql = $wpdb->prepare("DELETE FROM $lead_detail_table WHERE form_id=%d AND field_number >= %d AND field_number < %d", $form_id, $field_id, $field_id + 1);
        $wpdb->query($sql);

        //Delete leads with no details
        $sql = $wpdb->prepare(" DELETE FROM $lead_table
                                WHERE form_id=%d
                                AND id NOT IN(
                                    SELECT DISTINCT(lead_id) FROM $lead_detail_table WHERE form_id=%d
                                )", $form_id, $form_id);
        $wpdb->query($sql);

        do_action("gform_after_delete_field", $form_id, $field_id);
    }

    public static function delete_lead($lead_id){
        global $wpdb;

        do_action("gform_delete_lead", $lead_id);

        $lead_table = self::get_lead_table_name();
        $lead_notes_table = self::get_lead_notes_table_name();
        $lead_detail_table = self::get_lead_details_table_name();
        $lead_detail_long_table = self::get_lead_details_long_table_name();

        //deleting uploaded files
        self::delete_files($lead_id);

        //Delete from detail long
        $sql = $wpdb->prepare(" DELETE FROM $lead_detail_long_table
                                WHERE lead_detail_id IN(
                                    SELECT id FROM $lead_detail_table WHERE lead_id=%d
                                )", $lead_id);
        $wpdb->query($sql);

        //Delete from lead details
        $sql = $wpdb->prepare("DELETE FROM $lead_detail_table WHERE lead_id=%d", $lead_id);
        $wpdb->query($sql);

        //Delete from lead notes
        $sql = $wpdb->prepare("DELETE FROM $lead_notes_table WHERE lead_id=%d", $lead_id);
        $wpdb->query($sql);

        //Delete from lead meta
        gform_delete_meta($lead_id);

        //Delete from lead
        $sql = $wpdb->prepare("DELETE FROM $lead_table WHERE id=%d", $lead_id);
        $wpdb->query($sql);

    }

    public static function add_note($lead_id, $user_id, $user_name, $note, $note_type = "note"){
        global $wpdb;

        $table_name = self::get_lead_notes_table_name();
        $sql = $wpdb->prepare("INSERT INTO $table_name(lead_id, user_id, user_name, value, note_type, date_created) values(%d, %d, %s, %s, %s, utc_timestamp())", $lead_id, $user_id, $user_name, $note, $note_type);

        $wpdb->query($sql);
    }

    public static function delete_note($note_id){
        global $wpdb;

        if(!GFCommon::current_user_can_any("gravityforms_edit_entry_notes"))
            die(__("You don't have adequate permission to delete notes.", "gravityforms"));

        $table_name = self::get_lead_notes_table_name();
        $sql = $wpdb->prepare("DELETE FROM $table_name WHERE id=%d", $note_id);
        $wpdb->query($sql);
    }

    public static function delete_notes($notes){
        if(!is_array($notes))
            return;

        foreach($notes as $note_id){
            self::delete_note($note_id);
        }
    }

    public static function get_ip(){

        $ip = '';
        $headers = array( 'HTTP_CLIENT_IP', 'HTTP_X_FORWARDED_FOR', 'REMOTE_ADDR' );

        foreach( $headers as $header ) {
            $ip = rgar( $_SERVER, $header );
            if( $ip )
                break;
        }

        // HTTP_X_FORWARDED_FOR can return a comma separated list of IPs; using the first one
        $ips = explode( ',', $ip );

        return $ips[0];
    }

    public static function save_lead($form, &$lead){
        global $wpdb;

        GFCommon::log_debug("Saving entry.");

        if(IS_ADMIN && !GFCommon::current_user_can_any("gravityforms_edit_entries"))
            die(__("You don't have adequate permission to edit entries.", "gravityforms"));

        $lead_detail_table = self::get_lead_details_table_name();
        $is_new_lead = $lead == null;

        //Inserting lead if null
        if( $is_new_lead ) {

            global $current_user;
            $user_id = $current_user && $current_user->ID ? $current_user->ID : 'NULL';

            $lead_table = RGFormsModel::get_lead_table_name();
            $user_agent = self::truncate($_SERVER["HTTP_USER_AGENT"], 250);
            $currency = GFCommon::get_currency();
            $source_url = self::truncate(self::get_current_page_url(), 200);

            $wpdb->query($wpdb->prepare("INSERT INTO $lead_table(form_id, ip, source_url, date_created, user_agent, currency, created_by) VALUES(%d, %s, %s, utc_timestamp(), %s, %s, {$user_id})", $form["id"], self::get_ip(), $source_url, $user_agent, $currency));


            //reading newly created lead id
            $lead_id = $wpdb->insert_id;
            $lead = array( 'id' => $lead_id );

            GFCommon::log_debug("Entry record created in the database. ID: {$lead_id}");
        }

        $current_fields = $wpdb->get_results($wpdb->prepare("SELECT id, field_number FROM $lead_detail_table WHERE lead_id=%d", $lead["id"]));
        $original_post_id = rgget("post_id", $lead);

        $total_fields = array();
        $calculation_fields = array();
        $recalculate_total = false;

        GFCommon::log_debug("Saving entry fields.");

        foreach($form["fields"] as $field){

            //Ignore fields that are marked as display only
            if(rgget("displayOnly", $field) && $field["type"] != "password"){
                continue;
            }

            //ignore pricing fields in the entry detail
            if(RG_CURRENT_VIEW == "entry" && GFCommon::is_pricing_field($field["type"])){
                continue;
            }


            //process total field after all fields have been saved
            if($field["type"] == "total"){
                $total_fields[] = $field;
                continue;
            }

            //only save fields that are not hidden (except on entry screen)
            if( RG_CURRENT_VIEW == 'entry' || ! GFFormsModel::is_field_hidden( $form, $field, array(), $is_new_lead ? null : $lead ) ) {

                // process calculation fields after all fields have been saved (moved after the is hidden check)
                if( GFCommon::has_field_calculation($field) ) {
                    $calculation_fields[] = $field;
                    continue;
                }

                GFCommon::log_debug("Saving field {$field["label"]}");

                if($field['type'] == 'post_category')
                    $field = GFCommon::add_categories_as_choices($field, '');

                if(isset($field["inputs"]) && is_array($field["inputs"])){

                    foreach($field["inputs"] as $input)
                        self::save_input($form, $field, $lead, $current_fields, $input["id"]);
                }
                else{
                    self::save_input($form, $field, $lead, $current_fields, $field["id"]);
                }
            }
        }

        if(!empty($calculation_fields)) {
            foreach($calculation_fields as $calculation_field) {

                GFCommon::log_debug("Saving calculated field {$calculation_field["label"]}");

                if(isset($calculation_field["inputs"]) && is_array($calculation_field["inputs"])){
                    foreach($calculation_field["inputs"] as $input) {
                        self::save_input($form, $calculation_field, $lead, $current_fields, $input["id"]);
                        self::refresh_lead_field_value($lead["id"], $input["id"]);
                    }
                }
                else{
                    self::save_input($form, $calculation_field, $lead, $current_fields, $calculation_field["id"]);
                    self::refresh_lead_field_value($lead["id"], $calculation_field["id"]);
                }

            }
            self::refresh_product_cache($form, $lead = RGFormsModel::get_lead($lead['id']));
        }

        //saving total field as the last field of the form.
        if(!empty($total_fields)) {
            foreach($total_fields as $total_field){
                GFCommon::log_debug("Saving total field.");
                self::save_input($form, $total_field, $lead, $current_fields, $total_field["id"]);
            }
        }
    }

    public static function create_lead($form) {
        global $current_user;

		$total_fields = array();
        $calculation_fields = array();

        $lead = array();
        $lead['id'] = null;
        $lead['post_id'] = null;
        $lead['date_created'] = null;
        $lead['form_id'] = $form['id'];
        $lead['ip'] = self::get_ip();
        $lead['source_url'] =  self::truncate(self::get_current_page_url(), 200);
        $lead['user_agent'] = strlen($_SERVER['HTTP_USER_AGENT']) > 250 ? substr($_SERVER['HTTP_USER_AGENT'], 0, 250) : $_SERVER['HTTP_USER_AGENT'];
        $lead['currency'] = GFCommon::get_currency();
        $lead['created_by'] = $current_user && $current_user->ID ? $current_user->ID : 'NULL';

        foreach($form['fields'] as $field) {

            // ignore fields that are marked as display only
            if(rgget('displayOnly', $field) && $field['type'] != 'password'){
                continue;
            }

            // process total field after all fields have been saved
            if($field['type'] == 'total'){
                $total_fields[] = $field;
                continue;
            }

            // process calculation fields after all fields have been saved
            if(GFCommon::has_field_calculation($field)) {
                $calculation_fields[] = $field;
                continue;
            }

            // only save fields that are not hidden
            if(!RGFormsModel::is_field_hidden($form, $field, array()) ){

                if($field['type'] == 'post_category')
                    $field = GFCommon::add_categories_as_choices($field, '');

                if(isset($field['inputs']) && is_array($field['inputs'])){
                    foreach($field['inputs'] as $input) {
                        $lead[(string)$input['id']] = self::get_prepared_input_value($form, $field, $lead, $input["id"]);
                    }
                }
                else {
                    $lead[$field['id']] = self::get_prepared_input_value($form, $field, $lead, $field["id"]);
                }
            }
        }

        if(!empty($calculation_fields)) {
            foreach($calculation_fields as $field) {

                // only save fields that are not hidden
                if(RGFormsModel::is_field_hidden($form, $field, array()) )
                    continue;

                if(isset($field["inputs"]) && is_array($field["inputs"])){
                    foreach($field["inputs"] as $input) {
                        $lead[(string)$input['id']] = self::get_prepared_input_value($form, $field, $lead, $input["id"]);
                    }
                }
                else{
                    $lead[$field['id']] = self::get_prepared_input_value($form, $field, $lead, $field["id"]);
                }

            }
            self::refresh_product_cache($form, $lead);
        }

        // saving total field as the last field of the form.
        if( ! empty( $total_fields ) ) {
            foreach( $total_fields as $total_field ) {
                $lead[$total_field['id']] = self::get_prepared_input_value( $form, $total_field, $lead, $total_field['id'] );
            }
        }

        return $lead;
    }

    public static function get_prepared_input_value($form, $field, $lead, $input_id) {

        $input_name = "input_" . str_replace('.', '_', $input_id);
        $value = rgpost($input_name);

        if(empty($value) && rgar($field, "adminOnly") && !IS_ADMIN){
            $value = self::get_default_value($field, $input_id);
        }

        switch(self::get_input_type($field)) {

        case "post_image":
            $file_info = self::get_temp_filename($form['id'], $input_name);
            $file_path = self::get_file_upload_path($form['id'], $file_info["uploaded_filename"]);
            $url = $file_path['url'];

            $image_title = isset($_POST["{$input_name}_1"]) ? strip_tags($_POST["{$input_name}_1"]) : "";
            $image_caption = isset($_POST["{$input_name}_4"]) ? strip_tags($_POST["{$input_name}_4"]) : "";
            $image_description = isset($_POST["{$input_name}_7"]) ? strip_tags($_POST["{$input_name}_7"]) : "";

            $value = !empty($url) ? $url . "|:|" . $image_title . "|:|" . $image_caption . "|:|" . $image_description : "";
            break;

        case "fileupload" :
            if(rgar($field, "multipleFiles")){
                $value = json_encode($value);
            } else{
                $file_info = self::get_temp_filename($form['id'], $input_name);
                $file_path = self::get_file_upload_path($form['id'], $file_info["uploaded_filename"]);
                $value = $file_path['url'];
            }

            break;

        default:

            // processing values so that they are in the correct format for each input type
            $value = self::prepare_value($form, $field, $value, $input_name, rgar($lead, 'id'), $lead);

        }

        return apply_filters( 'gform_save_field_value', $value, $lead, $field, $form, $input_id );
    }

    public static function refresh_product_cache($form, $lead, $use_choice_text = false, $use_admin_label = false) {

        $cache_options = array(
            array(false, false),
            array(false, true),
            array(true, false),
            array(true, true)
            );

        foreach($form["fields"] as $field){
            if(GFCommon::has_field_calculation($field)){
                //deleting field value cache for calculated fields
                $cache_key = "GFFormsModel::get_lead_field_value_" . $lead["id"] . "_" . $field["id"];
                GFCache::delete($cache_key);
            }
        }

        foreach($cache_options as $cache_option) {
            list($use_choice_text, $use_admin_label) = $cache_option;
            if( gform_get_meta( rgar($lead,'id'), "gform_product_info_{$use_choice_text}_{$use_admin_label}") ) {
                gform_delete_meta(rgar($lead,'id'), "gform_product_info_{$use_choice_text}_{$use_admin_label}");
                GFCommon::get_product_fields($form, $lead, $use_choice_text, $use_admin_label);
            }
        }

    }

    /**
     * Check whether a field is hidden via conditional logic.
     *
     * @param array $form Form object.
     * @param array $field Field object.
     * @param array $field_values Default field values for this form. Used when form has not yet been submitted. Pass an array if no default field values are avilable/required.
     * @return array $lead Optional, default is null. If lead object is available, pass the lead.
     */
    public static function is_field_hidden($form, $field, $field_values, $lead=null){

        $cache_key = "GFFormsModel::is_field_hidden_" . $form["id"] . "_" . $field["id"];
        $display = GFCache::get($cache_key);
        if($display !== false)
            return $display;

        $section = self::get_section($form, $field["id"]);
        $section_display = self::get_field_display($form, $section, $field_values, $lead);

        //if section is hidden, hide field no matter what. if section is visible, see if field is supposed to be visible
        if($section_display == "hide"){
            $display = "hide";
        }
        else if(self::is_page_hidden($form, rgar($field,"pageNumber"), $field_values, $lead)){
            $display = "hide";
        }
        else{
            $display = self::get_field_display($form, $field, $field_values, $lead);
            return $display == "hide";
        }

        GFCache::set($cache_key, $display);

        return $display == "hide";
    }

    public static function is_page_hidden($form, $page_number, $field_values, $lead=null){
        $page = self::get_page_by_number($form, $page_number);

        if(!$page)
            return false;

        $display = self::get_field_display($form, $page, $field_values, $lead);
        return $display == "hide";
    }

    public static function get_page_by_number($form, $page_number){
        foreach($form["fields"] as $field){
            if($field["type"] == "page" && $field["pageNumber"] == $page_number)
                return $field;
        }
        return null;
    }

    public static function get_page_by_field($form, $field){
        return get_page_by_number($field["pageNumber"]);
    }

    //gets the section that the specified field belongs to, or null if none
    public static function get_section($form, $field_id){
        $current_section = null;
        foreach($form["fields"] as $field){
            if($field["type"] == "section")
                $current_section = $field;

            //stop section at a page break (sections don't go cross page)
            if($field["type"] == "page")
                $current_section = null;

            if($field["id"] == $field_id)
                return $current_section;
        }

        return null;
    }

    public static function is_value_match( $field_value, $target_value, $operation="is", $source_field = null, $rule = null ){

        $is_match = false;

        if($source_field && $source_field["type"] == "post_category")
            $field_value = GFCommon::prepare_post_category_value($field_value, $source_field, "conditional_logic");

        if (!empty($field_value) && !is_array($field_value) && $source_field["type"] == "multiselect")
			$field_value = explode(",", $field_value); // convert the comma-delimited string into an array

        $target_value = GFFormsModel::maybe_trim_input($target_value, rgar($source_field, "formId"),$source_field);

        if(is_array($field_value)){
            $field_value = array_values($field_value); //returning array values, ignoring keys if array is associative
            $match_count = 0;
            foreach($field_value as $val){
                $val = GFFormsModel::maybe_trim_input(GFCommon::get_selection_value($val), rgar($source_field,"formId"),$source_field);
                if(self::matches_operation($val, $target_value, $operation)){
                    $match_count++;
                }
            }
            // if operation is Is Not, none of the values in the array can match the target value.
            $is_match = $operation == "isnot" ? $match_count == count($field_value) : $match_count > 0;
        }
        else if(self::matches_operation(GFFormsModel::maybe_trim_input(GFCommon::get_selection_value($field_value), rgar($source_field,"formId"),$source_field), $target_value, $operation)){
            $is_match = true;
        }

        return apply_filters( 'gform_is_value_match', $is_match, $field_value, $target_value, $operation, $source_field, $rule );
    }

    private static function try_convert_float($text){
        global $wp_locale;
        $number_format = $wp_locale->number_format['decimal_point'] == "," ? "decimal_comma" : "decimal_dot";

        if(is_numeric($text) && $number_format == "decimal_comma"){
            return GFCommon::format_number($text, "decimal_comma");
        }
        else if(GFCommon::is_numeric($text, $number_format)){
            return GFCommon::clean_number($text, $number_format);
        }

        return $text;
    }

    public static function matches_operation($val1, $val2, $operation){

        $val1 = !rgblank($val1) ? strtolower($val1) : "";
        $val2 = !rgblank($val2) ? strtolower($val2) : "";

        switch($operation){
            case "is" :
                return $val1 == $val2;
            break;

            case "isnot" :
                return $val1 != $val2;
            break;

            case "greater_than":
            case ">" :
                $val1 = self::try_convert_float($val1);
                $val2 = self::try_convert_float($val2);

                return $val1 > $val2;
            break;

            case "less_than":
            case "<" :
                $val1 = self::try_convert_float($val1);
                $val2 = self::try_convert_float($val2);

                return $val1 < $val2;
            break;

            case "contains" :
                return !empty($val2) && strpos($val1, $val2) !== false;
            break;

            case "starts_with" :
                return !rgblank($val2) && strpos($val1, $val2) === 0;
            break;

            case "ends_with" :
                $start = strlen($val1) - strlen($val2);
                if($start < 0)
                    return false;

                $tail = substr($val1, $start);
                return $val2 == $tail;
            break;
        }


        return false;
    }

    private static function get_field_display($form, $field, $field_values, $lead=null){

        $logic = rgar($field, "conditionalLogic");

        //if this field does not have any conditional logic associated with it, it won't be hidden
        if(empty($logic))
            return "show";

        $match_count = 0;
        foreach($logic["rules"] as $rule){
            $source_field = RGFormsModel::get_field($form, $rule["fieldId"]);
            $field_value = empty($lead) ? self::get_field_value($source_field, $field_values) : self::get_lead_field_value($lead, $source_field);

            $is_value_match = self::is_value_match($field_value, $rule["value"], $rule["operator"], $source_field);

            if($is_value_match)
                $match_count++;
        }

        $do_action = ($logic["logicType"] == "all" && $match_count == sizeof($logic["rules"]) ) || ($logic["logicType"] == "any"  && $match_count > 0);
        $is_hidden = ($do_action && $logic["actionType"] == "hide") || (!$do_action && $logic["actionType"] == "show");

        return $is_hidden ? "hide" : "show";
    }

    public static function get_custom_choices(){
        $choices = get_option("gform_custom_choices");
        if(!$choices)
            $choices = array();

        return $choices;
    }

    public static function delete_custom_choice($name){
        $choices = self::get_custom_choices();
        if(array_key_exists($name, $choices))
            unset($choices[$name]);

        update_option("gform_custom_choices", $choices);
    }

    public static function save_custom_choice($previous_name, $new_name, $choices){
        $all_choices = self::get_custom_choices();

        if(array_key_exists($previous_name, $all_choices))
            unset($all_choices[$previous_name]);

        $all_choices[$new_name] = $choices;

        update_option("gform_custom_choices", $all_choices);
    }

    public static function get_field_value(&$field, $field_values = array(), $get_from_post=true){

        if($field['type'] == 'post_category')
            $field = GFCommon::add_categories_as_choices($field, '');

        $value = array();
        switch(RGFormsModel::get_input_type($field)){
            case "post_image" :
                $value[$field["id"] . ".1"] = self::get_input_value($field, "input_" . $field["id"] . "_1", $get_from_post);
                $value[$field["id"] . ".4"] = self::get_input_value($field, "input_" . $field["id"] . "_4", $get_from_post);
                $value[$field["id"] . ".7"] = self::get_input_value($field, "input_" . $field["id"] . "_7", $get_from_post);
            break;
            case "checkbox" :
                $parameter_values = self::get_parameter_value( rgar( $field, 'inputName' ), $field_values, $field);
                if(!empty($parameter_values) && !is_array($parameter_values)){
                    $parameter_values = explode(",", $parameter_values);
                }

                if(!is_array($field["inputs"]))
                    return "";

                $choice_index = 0;
                foreach($field["inputs"] as $input){
                    if(!empty($_POST["is_submit_" . $field["formId"]]) && $get_from_post){
                        $value[strval($input["id"])] = rgpost("input_" . str_replace('.', '_', strval($input["id"])));
                    }
                    else{
                        if(is_array($parameter_values)){
                            foreach($parameter_values as $item){
                                $item = trim($item);
                                if(self::choice_value_match($field, $field["choices"][$choice_index], $item))
                                {
                                    $value[$input["id"] . ""] = $item;
                                    break;
                                }
                            }
                        }
                    }
                    $choice_index++;
                }

            break;

            case "list" :
                $value = self::get_input_value($field, "input_" . $field["id"], rgar($field, "inputName"), $field_values, $get_from_post);
                $value = self::create_list_array($field, $value);
            break;

            case "number" :
                $value = self::get_input_value($field, "input_" . $field["id"], rgar($field, "inputName"), $field_values, $get_from_post);
                $value = trim($value);
                if($field["numberFormat"] == "currency"){
                    require_once(GFCommon::get_base_path() . '/currency.php');
                    $currency = new RGCurrency(GFCommon::get_currency());
                    $value = $currency->to_number( $value );
                }
                else if($field["numberFormat"] == "decimal_comma"){
                    $value = GFCommon::clean_number($value, "decimal_comma");
                }
                else if($field["numberFormat"] == "decimal_dot"){
                    $value = GFCommon::clean_number($value, "decimal_dot");
                }
            break;

            case "radio" :
            	$value = self::get_input_value($field, "input_" . $field["id"], rgar($field, "inputName"), $field_values, $get_from_post);
            	if ($value == "gf_other_choice"){
					//get value from text box
					$value = self::get_input_value($field, "input_" . $field["id"] . "_other", rgar($field, "inputName"), $field_values, $get_from_post);
            	}
            break;

            default:

                if(isset($field["inputs"]) && is_array($field["inputs"])){
                    foreach($field["inputs"] as $input){
                        $value[strval($input["id"])] = self::get_input_value($field, "input_" . str_replace('.', '_', strval($input["id"])), RGForms::get("name", $input), $field_values, $get_from_post);
                    }
                }
                else{
                    $value = self::get_input_value($field, "input_" . $field["id"], rgar($field, "inputName"), $field_values, $get_from_post);
                }
            break;
        }

        return $value;
    }

    public static function maybe_trim_input($value, $form_id, $field){
        $trim_value = apply_filters("gform_trim_input_value", true, $form_id, $field);

        if($trim_value)
            $value = is_array($value) ? array_map('trim', $value) : trim($value);

        return $value;
    }

    private static function get_input_value($field, $standard_name, $custom_name = "", $field_values=array(), $get_from_post=true){
        $form_id = rgar($field,"formId");
        if(!empty($_POST["is_submit_" . $form_id]) && $get_from_post){
            $value = rgpost($standard_name);
            $value = self::maybe_trim_input($value, $form_id, $field);
            return $value;
        }
        else if(rgar($field, "allowsPrepopulate")){
            return self::get_parameter_value($custom_name, $field_values, $field);
        }
    }

    public static function get_parameter_value($name, $field_values, $field){
        $value = stripslashes(rgget($name));
        if(empty($value))
            $value = rgget($name, $field_values);

        //converting list format
        if(RGFormsModel::get_input_type($field) == "list"){

            //transforms this: col1|col2,col1b|col2b into this: col1,col2,col1b,col2b
            $column_count = count(rgar($field,"choices"));

            $rows = explode(",", $value);
            $ary_rows = array();
            if(!empty($rows)){
                foreach($rows as $row)
                    $ary_rows = array_merge($ary_rows, rgexplode("|", $row, $column_count));

                $value = $ary_rows;
            }
        }

        return apply_filters("gform_field_value_$name", apply_filters("gform_field_value", $value, $field), $field);
    }

    public static function get_default_value($field, $input_id){
        if(!is_array(rgar($field,"choices"))){
            if(is_array(rgar($field, "inputs"))){
                $input = RGFormsModel::get_input($field, $input_id);
                return rgar($input, "defaultValue");
            }
            else{
                return IS_ADMIN ? $field["defaultValue"] : GFCommon::replace_variables_prepopulate($field["defaultValue"]);
            }
        }
        else if($field["type"] == "checkbox"){
            for($i=0, $count=sizeof($field["inputs"]); $i<$count; $i++){
                $input = $field["inputs"][$i];
                $choice = $field["choices"][$i];
                if($input["id"] == $input_id && $choice["isSelected"]){
                    return $choice["value"];
                }
            }
            return "";
        }
        else{
            foreach($field["choices"] as $choice){
                if(rgar($choice,"isSelected") || $field["type"] == "post_category")
                    return $choice["value"];
            }
            return "";
        }

    }

    public static function get_input_type($field){
        return empty($field["inputType"]) ? rgar($field,"type") : $field["inputType"];
    }

    private static function get_post_field_value($field, $lead){

        if(isset($field["inputs"]) && is_array($field["inputs"])){
            $value = array();
            foreach($field["inputs"] as $input){
                $val = isset($lead[strval($input["id"])]) ? $lead[strval($input["id"])] : "";
                if(!empty($val)) {

                    // replace commas in individual values to prevent individual value from being split into multiple values (checkboxes, multiselects)
                    if( in_array(RGFormsModel::get_input_type($field), array('checkbox', 'multiselect')) )
                        $val = str_replace(',', '&#44;', $val);

                    $value[] = $val;
                }
            }
            $value = implode(",", $value);
        }
        else{
            $value = isset($lead[$field["id"]]) ? $lead[$field["id"]] : "";
        }
        return $value;
    }

    private static function get_post_fields($form, $lead) {

        $post_data = array();
        $post_data["post_custom_fields"] = array();
        $post_data["tags_input"] = array();
        $categories = array();
        $images = array();

        foreach($form["fields"] as $field){

            if($field['type'] == 'post_category')
                $field = GFCommon::add_categories_as_choices($field, '');

            $value = self::get_post_field_value($field, $lead);

            switch($field["type"]){
                case "post_title" :
                case "post_excerpt" :
                case "post_content" :
                    $post_data[$field["type"]] = $value;
                break;

                case "post_tags" :
                    $tags = explode(",", $value);
                    if(is_array($tags) && sizeof($tags) > 0)
                        $post_data["tags_input"] = array_merge($post_data["tags_input"], $tags) ;
                break;

                case "post_custom_field" :

                    $type = self::get_input_type($field);
                    if("fileupload" === $type && rgar($field, "multipleFiles"))
                        $value = json_decode($value, true);

                    $meta_name = $field["postCustomFieldName"];

                    if(!isset($post_data["post_custom_fields"][$meta_name])){
                        $post_data["post_custom_fields"][$meta_name] = $value;
                    }
                    else if(!is_array($post_data["post_custom_fields"][$meta_name])){
                        $post_data["post_custom_fields"][$meta_name] = array($post_data["post_custom_fields"][$meta_name], $value);
                    }
                    else{
                        $post_data["post_custom_fields"][$meta_name][] = $value;
                    }

                break;

                case "post_category" :
                    foreach(explode(',', $value) as $cat_string) {
                        list($cat_name, $cat_id) = rgexplode(":", $cat_string, 2);
                        array_push($categories, $cat_id);
                    }
                break;

                case "post_image" :
                    $ary = !empty($value) ? explode("|:|", $value) : array();
                    $url = count($ary) > 0 ? $ary[0] : "";
                    $title = count($ary) > 1 ? $ary[1] : "";
                    $caption = count($ary) > 2 ? $ary[2] : "";
                    $description = count($ary) > 3 ? $ary[3] : "";

                    array_push($images, array("field_id" => $field["id"], "url" => $url, "title" => $title, "description" => $description, "caption" => $caption));
                break;
            }
        }

        $post_data["post_status"] = rgar($form, "postStatus");
        $post_data["post_category"] = !empty($categories) ? $categories : array(rgar($form, 'postCategory'));
        $post_data["images"] = $images;

        //setting current user as author depending on settings
        $post_data["post_author"] = $form["useCurrentUserAsAuthor"] && !empty($lead["created_by"]) ? $lead["created_by"] : $form["postAuthor"];

        return $post_data;
    }

    public static function get_custom_field_names(){
        global $wpdb;
        $keys = $wpdb->get_col( "
        SELECT meta_key
        FROM $wpdb->postmeta
        WHERE meta_key NOT LIKE '\_%'
        GROUP BY meta_key
        ORDER BY meta_id DESC");

        if ( $keys )
            natcasesort($keys);

        return $keys;
    }

    public static function get_input_masks(){

        $masks = array(
            'US Phone' => '(999) 999-9999',
            'US Phone + Ext' => '(999) 999-9999? x99999',
            'Date' => '99/99/9999',
            'Tax ID' => '99-9999999',
            'SSN' => '999-99-9999',
            'Zip Code' => '99999',
            'Full Zip Code' => '99999?-9999'
            );

        return apply_filters('gform_input_masks', $masks);
    }

    private static function get_default_post_title(){
        global $wpdb;
        $title = "Untitled";
        $count = 1;

        $titles = $wpdb->get_col("SELECT post_title FROM $wpdb->posts WHERE post_title like '%Untitled%'");
        $titles = array_values($titles);
        while(in_array($title, $titles)){
            $title = "Untitled_$count";
            $count++;
        }
        return $title;
    }

    public static function prepare_date($date_format, $value){
        $format = empty($date_format) ? "mdy" : $date_format;
        $date_info = GFCommon::parse_date($value, $format);
        if(!empty($date_info) && !GFCommon::is_empty_array($date_info))
            $value = sprintf("%s-%02d-%02d", $date_info["year"], $date_info["month"], $date_info["day"]);
        else
            $value = "";

        return $value;
    }

    /**
    * Prepare the value before saving it to the lead.
    *
    * @param mixed $form
    * @param mixed $field
    * @param mixed $value
    * @param mixed $input_name
    * @param mixed $lead_id the current lead ID, used for fields that are processed after other fields have been saved (ie Total, Calculations)
    * @param mixed $lead passed by the RGFormsModel::create_lead() method, lead ID is not available for leads created by this function
    */
    public static function prepare_value($form, $field, $value, $input_name, $lead_id, $lead = array()){
        $form_id = $form["id"];

        $input_type = self::get_input_type($field);
        switch($input_type)
        {
            case "total" :
                $lead = empty($lead) ? RGFormsModel::get_lead($lead_id) : $lead;
                $value = GFCommon::get_order_total($form, $lead);
            break;

            case "calculation" :
                // ignore submitted value and recalculate price in backend
                list(,,$input_id) = rgexplode("_", $input_name, 3);
                if($input_id == 2) {
                    require_once(GFCommon::get_base_path() . '/currency.php');
                    $currency = new RGCurrency(GFCommon::get_currency());
                    $lead = empty($lead) ? RGFormsModel::get_lead($lead_id) : $lead;
                    $value = $currency->to_money(GFCommon::calculate($field, $form, $lead));
                }
            break;

            case "phone" :
                if($field["phoneFormat"] == "standard" && preg_match('/^\D?(\d{3})\D?\D?(\d{3})\D?(\d{4})$/', $value, $matches))
                    $value = sprintf("(%s)%s-%s", $matches[1], $matches[2], $matches[3]);
            break;

            case "time":

                if(!is_array($value) && !empty($value)){
                    preg_match('/^(\d*):(\d*) ?(.*)$/', $value, $matches);
                    $value = array();
                    $value[0] = $matches[1];
                    $value[1] = $matches[2];
                    $value[2] = rgar($matches,3);
                }

                $hour = empty($value[0]) ? "0" : strip_tags($value[0]);
                $minute = empty($value[1]) ? "0" : strip_tags($value[1]);
                $ampm = strip_tags(rgar($value,2));
                if(!empty($ampm))
                    $ampm = " $ampm";

                if(!(empty($hour) && empty($minute)))
                    $value = sprintf("%02d:%02d%s", $hour, $minute, $ampm);
                else
                    $value = "";

            break;

            case "date" :
                $value = self::prepare_date($field["dateFormat"], $value);

            break;

            case "post_image":
                $url = self::get_fileupload_value($form_id, $input_name);
                $image_title = isset($_POST["{$input_name}_1"]) ? strip_tags($_POST["{$input_name}_1"]) : "";
                $image_caption = isset($_POST["{$input_name}_4"]) ? strip_tags($_POST["{$input_name}_4"]) : "";
                $image_description = isset($_POST["{$input_name}_7"]) ? strip_tags($_POST["{$input_name}_7"]) : "";

                $value = !empty($url) ? $url . "|:|" . $image_title . "|:|" . $image_caption . "|:|" . $image_description : "";
            break;

            case "fileupload" :
                if(rgar($field, "multipleFiles")){
                    if(isset(GFFormsModel::$uploaded_files[$form_id][$input_name])){
                        $uploaded_temp_files = GFFormsModel::$uploaded_files[$form_id][$input_name];
                        $uploaded_files = array();
                        foreach($uploaded_temp_files as $i => $file_info){
                            $temp_filepath = self::get_upload_path($form_id) . "/tmp/" . $file_info["temp_filename"];
                            if($file_info && file_exists($temp_filepath)){
                                $uploaded_files[$i] = self::move_temp_file($form_id, $file_info);
                            }
                        }

                        if(!empty($value)){ // merge with existing files (admin edit entry)
                            $value = json_decode($value, true);
                            $value = array_merge($value, $uploaded_files);
                            $value = json_encode($value);
                        } else {
                            $value = json_encode($uploaded_files);
                        }

                    } else {
                        $value = "";
                    }

                } else
                    $value = self::get_fileupload_value($form_id, $input_name);
            break;

            case "number" :

                $value = GFCommon::maybe_add_leading_zero($value);

                $is_hidden = RGFormsModel::is_field_hidden($form, $field, array());
                $lead = empty($lead) ? RGFormsModel::get_lead($lead_id) : $lead;
                $value = GFCommon::has_field_calculation($field) ? GFCommon::round_number(GFCommon::calculate($field, $form, $lead), rgar($field, "calculationRounding")) : GFCommon::clean_number($value, rgar($field, "numberFormat"));
                //return the value as a string when it is zero and a calc so that the "==" comparison done when checking if the field has changed isn't treated as false
                if (GFCommon::has_field_calculation($field) && $value == 0){
					$value = "0";
                }
            break;

            case "website" :
                if($value == "http://")
                    $value = "";
            break;

            case "list" :

                if(rgar($field, "adminOnly") && rgar($field, "allowsPrepopulate"))
                    $value = json_decode($value);

                if(GFCommon::is_empty_array($value))
                    $value = "";
                else{
                    $value = self::create_list_array($field, $value);
                    $value = serialize($value);
                }
            break;

            case "radio" :
                if(rgar($field, 'enableOtherChoice') && $value == 'gf_other_choice')
                    $value = rgpost("input_{$field['id']}_other");
                break;

            case "multiselect" :
                $value = empty($value) ? "" : is_array($value) ? implode(",", $value) : $value;
                break;

            case "creditcard" :
                //saving last 4 digits of credit card
                list($input_token, $field_id_token, $input_id) = rgexplode("_", $input_name, 3);
                if($input_id == "1"){
                    $value = str_replace(" ", "", $value);
                    $card_number_length = strlen($value);
                    $value = substr($value, -4, 4);
                    $value = str_pad($value, $card_number_length, "X", STR_PAD_LEFT);
                }
                else if( $input_id == '4' ) {

                    $value = rgpost( "input_{$field_id_token}_4" );

                    if( ! $value ) {
                        $card_number = rgpost( "input_{$field_id_token}_1" );
                        $card_type = GFCommon::get_card_type( $card_number );
                        $value = $card_type ? $card_type['name'] : '';
                    }

                }
                else{
                    $value = "";
                }

            break;

            case 'password':

                $encrypt_password = apply_filters( 'gform_encrypt_password', false, $field, $form );
                if( $encrypt_password ) {
                    $value = GFCommon::encrypt( $value );
                    self::set_encrypted_fields( $lead_id, $field['id'] );
                }

            break;

            default:

                // only filter HTML on non-array based values
                if( ! is_array( $value ) ) {

                    //allow HTML for certain field types
                    $allow_html = in_array($field["type"], array("post_custom_field", "post_title", "post_content", "post_excerpt", "post_tags" )) || in_array($input_type, array("checkbox", "radio")) ? true : false;
                    $allowable_tags = apply_filters("gform_allowable_tags_{$form_id}", apply_filters("gform_allowable_tags", $allow_html, $field, $form_id), $field, $form_id);

                    if($allowable_tags !== true)
                        $value = strip_tags($value, $allowable_tags);

                }

            break;
        }

        // special format for Post Category fields
        if($field['type'] == 'post_category') {

            $full_values = array();

            if(!is_array($value))
                $value = explode(',', $value);

            foreach($value as $cat_id) {
                $cat = get_term($cat_id, 'category');
                $full_values[] = !is_wp_error($cat) && is_object($cat) ? $cat->name . ":" . $cat_id : "";
            }

            $value = implode(',', $full_values);
        }

        //do not save price fields with blank price
        if(rgar($field, "enablePrice")){
            $ary = explode("|", $value);
            $label = count($ary) > 0 ? $ary[0] : "";
            $price = count($ary) > 1 ? $ary[1] : "";

            $is_empty = (strlen(trim($price)) <= 0);
            if($is_empty)
                $value = "";
        }

        return $value;
    }

    public static function is_checkbox_checked($field_id, $field_label, $lead, $form){

        //looping through lead detail values trying to find an item identical to the column label. Mark with a tick if found.
        $lead_field_keys = array_keys($lead);
        foreach($lead_field_keys as $input_id){
            //mark as a tick if input label (from form meta) is equal to submitted value (from lead)
            if(is_numeric($input_id) && absint($input_id) == absint($field_id)){
                if($lead[$input_id] == $field_label){
                    return $lead[$input_id];
                }
                else{
                    $field = RGFormsModel::get_field($form, $field_id);
                    if(rgar($field, "enableChoiceValue") || rgar($field, "enablePrice")){
                        foreach($field["choices"] as $choice){
                            if($choice["value"] == $lead[$field_id]){
                                return $choice["value"];
                            }
                            else if(rgar($field,"enablePrice")){
                                $ary = explode("|", $lead[$field_id]);
                                $val = count($ary) > 0 ? $ary[0] : "";
                                $price = count($ary) > 1 ? $ary[1] : "";

                                if($val == $choice["value"]){
                                    return $choice["value"];
                                }
                            }
                        }
                    }
                }
            }
        }

        return false;
    }

    private static function create_list_array($field, $value){
        if(!rgar($field,"enableColumns")){
            return $value;
        }
        else{
            $col_count = count(rgar($field, "choices"));
            $rows = array();

            $row_count = count($value)/$col_count;

            $col_index = 0;
            for($i=0; $i<$row_count; $i++){
                $row = array();
                foreach($field["choices"] as $column){
                    $row[$column["text"]] = rgar($value,$col_index);
                    $col_index++;
                }
                $rows[] = $row;
            }
            return $rows;
        }
    }

    private static function get_fileupload_value($form_id, $input_name){
        global $_gf_uploaded_files;

        GFCommon::log_debug("Starting GFFormsModel::get_fileupload_value()");

        if(empty($_gf_uploaded_files)){
            GFCommon::log_debug("No files uploaded. Exiting GFFormsModel::get_fileupload_value()");
            $_gf_uploaded_files = array();
        }


        if(!isset($_gf_uploaded_files[$input_name])){

            //check if file has already been uploaded by previous step
            $file_info = self::get_temp_filename($form_id, $input_name);
            $temp_filepath = self::get_upload_path($form_id) . "/tmp/" . $file_info["temp_filename"];
            GFCommon::log_debug("get_fileupload_value() - temp file path: " . $temp_filepath);
            if($file_info && file_exists($temp_filepath)){
                GFCommon::log_debug("get_fileupload_value() - moving temp file: " . $temp_filepath);
                $_gf_uploaded_files[$input_name] = self::move_temp_file($form_id, $file_info);
            } else if(!empty($_FILES[$input_name]["name"])) {
                GFCommon::log_debug("get_fileupload_value() - uploading file: " . $_FILES[$input_name]["name"]);
                $_gf_uploaded_files[$input_name] = self::upload_file($form_id, $_FILES[$input_name]);
            }
        }

        return rgget($input_name, $_gf_uploaded_files);
    }

    public static function get_form_unique_id($form_id) {
        $unique_id = "";
        if (rgpost("gform_submit") == $form_id) {
            $posted_uid = rgpost("gform_unique_id");
            if (false === empty($posted_uid)) {
                $unique_id = $posted_uid;
                self::$unique_ids[$form_id] = $unique_id;
            } elseif (isset(self::$unique_ids[$form_id])) {
                $unique_id = self::$unique_ids[$form_id];
            } else {
                $unique_id =  uniqid();
                self::$unique_ids[$form_id] = $unique_id;
            }
        }

        return $unique_id;
    }

    public static function get_temp_filename($form_id, $input_name){

        $uploaded_filename = !empty($_FILES[$input_name]["name"]) && $_FILES[$input_name]["error"] === 0 ? $_FILES[$input_name]["name"] : "";

        if(empty($uploaded_filename) && isset(self::$uploaded_files[$form_id]))
            $uploaded_filename = rgget($input_name, self::$uploaded_files[$form_id]);

        if(empty($uploaded_filename))
            return false;

        $form_unique_id = self::get_form_unique_id($form_id);
        $pathinfo = pathinfo($uploaded_filename);
        return array("uploaded_filename" => $uploaded_filename, "temp_filename" => "{$form_unique_id}_{$input_name}.{$pathinfo["extension"]}");

    }

    public static function get_choice_text($field, $value, $input_id=0){
        if(!is_array(rgar($field, "choices")))
            return $value;

        foreach($field["choices"] as $choice){
            if(is_array($value) && self::choice_value_match($field, $choice, $value[$input_id])){
                return $choice["text"];
            }
            else if(!is_array($value) && self::choice_value_match($field, $choice, $value)){
                return $choice["text"];
            }
        }
        return is_array($value) ? "" : $value;
    }


    public static function choice_value_match($field, $choice, $value){
        $choice_value = GFFormsModel::maybe_trim_input($choice["value"], rgar($field, "formId"), $field);
        $value = GFFormsModel::maybe_trim_input($value, rgar($field, "formId"), $field);
        if($choice_value == $value){
           return true;
        }
        else if(rgget("enablePrice", $field)){
            $ary = explode("|", $value);
            $val = count($ary) > 0 ? $ary[0] : "";
            $price = count($ary) > 1 ? $ary[1] : "";

            if($val == $choice["value"])
                return true;
        }
        // add support for prepopulating multiselects @alex
        else if(RGFormsModel::get_input_type($field) == 'multiselect') {
            $values = explode(',', $value);
            if(in_array($choice_value, $values))
                return true;
        }
        return false;
    }

    public static function choices_value_match($field, $choices, $value) {
        foreach($choices as $choice){
            if(self::choice_value_match($field, $choice, $value))
                return true;
        }

        return false;
    }

    public static function create_post($form, &$lead){

        GFCommon::log_debug("Starting GFFormsModel::create_post()");

        $has_post_field = false;
        foreach($form["fields"] as $field){
            $is_hidden = self::is_field_hidden($form, $field, array(), $lead);
            if(!$is_hidden && in_array($field["type"], array("post_category","post_title","post_content","post_excerpt","post_tags","post_custom_field","post_image"))){
                $has_post_field = true;
                break;
            }
        }

        //if this form does not have any post fields, don't create a post
        if(!$has_post_field){
            GFCommon::log_debug("The form doesn't have any post fields - stopping.");
            return $lead;
        }


        //processing post fields
        GFCommon::log_debug("Getting post fields.");
        $post_data = self::get_post_fields($form, $lead);

        //allowing users to change post fields before post gets created
        $post_data = apply_filters("gform_post_data_{$form["id"]}", apply_filters("gform_post_data", $post_data , $form, $lead), $form, $lead);

        //adding default title if none of the required post fields are in the form (will make sure wp_insert_post() inserts the post)
        if(empty($post_data["post_title"]) && empty($post_data["post_content"]) && empty($post_data["post_excerpt"])){
            $post_data["post_title"] = self::get_default_post_title();
        }

        // remove original post status and save it for later
        $post_status = $post_data['post_status'];

        // replace original post status with 'draft' so other plugins know this post is not fully populated yet
        $post_data['post_status'] = 'draft';

        // inserting post
        GFCommon::log_debug("Inserting post");
        $post_id = wp_insert_post( $post_data );
        GFCommon::log_debug("Done inserting post");

        //adding form id and entry id hidden custom fields
        add_post_meta($post_id, "_gform-form-id", $form["id"]);
        add_post_meta($post_id, "_gform-entry-id", $lead["id"]);

        //creating post images
        GFCommon::log_debug("Creating post images.");
        $post_images = array();
        foreach($post_data["images"] as $image){
            $image_meta= array( "post_excerpt" => $image["caption"],
                                "post_content" => $image["description"]);

            //adding title only if it is not empty. It will default to the file name if it is not in the array
            if(!empty($image["title"]))
                $image_meta["post_title"] = $image["title"];

            if(!empty($image["url"])){
                GFCommon::log_debug("Adding image: " . $image["url"]);
                $media_id = self::media_handle_upload($image["url"], $post_id, $image_meta);

                if($media_id){

                    //save media id for post body/title template variable replacement (below)
                    $post_images[$image["field_id"]] = $media_id;
                    $lead[$image["field_id"]] .= "|:|$media_id";

                    // set featured image
                    $field = RGFormsModel::get_field($form, $image["field_id"]);
                    if(rgar($field, 'postFeaturedImage'))
                        set_post_thumbnail($post_id, $media_id);
                }
            }
        }

        //adding custom fields
        GFCommon::log_debug("Adding custom fields.");
        foreach($post_data["post_custom_fields"] as $meta_name => $meta_value) {
            if(!is_array($meta_value))
                $meta_value = array($meta_value);

            $meta_index = 0;
            foreach($meta_value as $value){
                GFCommon::log_debug("Getting custom field: " . $meta_name);
                $custom_field = self::get_custom_field($form, $meta_name, $meta_index);

                //replacing template variables if template is enabled
                if($custom_field && rgget("customFieldTemplateEnabled", $custom_field)){
                    //replacing post image variables
                    GFCommon::log_debug("Replacing post image variables.");
                    $value = GFCommon::replace_variables_post_image($custom_field["customFieldTemplate"], $post_images, $lead);

                    //replacing all other variables
                    $value = GFCommon::replace_variables($value, $form, $lead, false, false, false);

                    // replace conditional shortcodes
                    $value = do_shortcode($value);
                }
                switch(RGFormsModel::get_input_type($custom_field)){
                    case "list" :
                        $value = maybe_unserialize($value);
                        if(is_array($value)){
                            foreach($value as $item){
                                if(is_array($item))
                                    $item = implode("|", $item);

                                if(!rgblank($item))
                                    add_post_meta($post_id, $meta_name, $item);
                            }
                        }
                    break;

                    case "multiselect" :
                    case "checkbox" :
                        $value = explode(",", $value);
                        if(is_array($value)){
                            foreach($value as $item){
                                if(!rgblank($item)) {
                                    // add post meta and replace HTML symbol in $item with real comma
                                    add_post_meta($post_id, $meta_name, str_replace('&#44;', ',', $item));
                                }
                            }
                        }
                    break;

                    case "date" :
                        $value = GFCommon::date_display($value, rgar($custom_field, "dateFormat"));
                        if(!rgblank($value))
                            add_post_meta($post_id, $meta_name, $value);
                    break;

                    default :
                        if(!rgblank($value))
                            add_post_meta($post_id, $meta_name, $value);
                    break;
                }

                $meta_index++;
            }
        }

        $has_content_field = sizeof(GFCommon::get_fields_by_type($form, array("post_content"))) > 0;
        $has_title_field = sizeof(GFCommon::get_fields_by_type($form, array("post_title"))) > 0;
        $post = false;

        //if a post field was configured with a content or title template, process template
        if( (rgar($form, "postContentTemplateEnabled") && $has_content_field) || (rgar($form, "postTitleTemplateEnabled") && $has_title_field) ){
            GFCommon::log_debug("Processing template.");
            $post = get_post($post_id);

            if($form["postContentTemplateEnabled"] && $has_content_field){

                //replacing post image variables
                $post_content = GFCommon::replace_variables_post_image($form["postContentTemplate"], $post_images, $lead);

                //replacing all other variables
                $post_content = GFCommon::replace_variables($post_content, $form, $lead, false, false, false);

                //updating post content
                $post->post_content = $post_content;
            }

            if($form["postTitleTemplateEnabled"] && $has_title_field){

                //replacing post image variables
                $post_title = GFCommon::replace_variables_post_image($form["postTitleTemplate"], $post_images, $lead);

                //replacing all other variables
                $post_title = GFCommon::replace_variables($post_title, $form, $lead, false, false, false);

                // replace conditional shortcodes
                $post_title = do_shortcode($post_title);

                //updating post
                $post->post_title = $post_title;

                $post->post_name = $post_title;
            }

        }

        // update post status back to original status (if not draft)
        if( $post_status != 'draft' ) {
            $post = is_object( $post ) ? $post : get_post( $post_id );
            $post->post_status = $post_status;
        }

        // if post has been modified since creation, save updates
        if( is_object( $post ) ){
            GFCommon::log_debug("Updating post.");
            wp_update_post($post);
        }


        //adding post format
        if(current_theme_supports('post-formats') && rgar($form, 'postFormat')) {

            $formats = get_theme_support('post-formats');
            $post_format = rgar($form, 'postFormat');

            if(is_array($formats)) {
                $formats = $formats[0];
                if(in_array( $post_format, $formats)) {
                    set_post_format($post_id, $post_format);
                } else if('0' == $post_format) {
                    set_post_format($post_id, false);
                }
            }

        }

        //update post_id field if a post was created
        $lead["post_id"] = $post_id;
        GFCommon::log_debug("Updating entry.");
        self::update_lead_property($lead["id"], "post_id", $post_id);

        do_action( 'gform_after_create_post', $post_id );

        return $post_id;
    }

    private static function get_custom_field($form, $meta_name, $meta_index){
        $custom_fields = GFCommon::get_fields_by_type($form, array("post_custom_field"));

        $index = 0;
        foreach($custom_fields as $field){
            if($field["postCustomFieldName"] == $meta_name){
                if($meta_index == $index){
                    return $field;
                }
                $index++;
            }
        }
        return false;
    }

    private static function copy_post_image($url, $post_id){
        $time = current_time('mysql');

        if ( $post = get_post($post_id) ) {
            if ( substr( $post->post_date, 0, 4 ) > 0 )
                $time = $post->post_date;
        }

        //making sure there is a valid upload folder
        if ( ! ( ( $uploads = wp_upload_dir($time) ) && false === $uploads['error'] ) )
            return false;

        $name = basename($url);

        $filename = wp_unique_filename($uploads['path'], $name);

        // Move the file to the uploads dir
        $new_file = $uploads['path'] . "/$filename";

        $uploaddir = wp_upload_dir();
        $path = str_replace($uploaddir["baseurl"], $uploaddir["basedir"], $url);

        if(!copy($path, $new_file))
            return false;

        // Set correct file permissions
        $stat = stat( dirname( $new_file ));
        $perms = $stat['mode'] & 0000666;
        @ chmod( $new_file, $perms );

        // Compute the URL
        $url = $uploads['url'] . "/$filename";

        if ( is_multisite() )
            delete_transient( 'dirsize_cache' );

        $type = wp_check_filetype($new_file);
        return array("file" => $new_file, "url" => $url, "type" => $type["type"]);

    }

    private static function media_handle_upload($url, $post_id, $post_data = array()) {

        //WordPress Administration API required for the media_handle_upload() function
        require_once(ABSPATH . 'wp-admin/includes/image.php');

        $name = basename($url);

        $file = self::copy_post_image($url, $post_id);

        if(!$file)
            return false;

        $name_parts = pathinfo($name);
        $name = trim( substr( $name, 0, -(1 + strlen($name_parts['extension'])) ) );

        $url = $file['url'];
        $type = $file['type'];
        $file = $file['file'];
        $title = $name;
        $content = '';

        // use image exif/iptc data for title and caption defaults if possible
        if ( $image_meta = @wp_read_image_metadata($file) ) {
            if ( trim( $image_meta['title'] ) && ! is_numeric( sanitize_title( $image_meta['title'] ) ) )
                $title = $image_meta['title'];
            if ( trim( $image_meta['caption'] ) )
                $content = $image_meta['caption'];
        }

        // Construct the attachment array
        $attachment = array_merge( array(
            'post_mime_type' => $type,
            'guid' => $url,
            'post_parent' => $post_id,
            'post_title' => $title,
            'post_content' => $content,
        ), $post_data );

        // Save the data
        $id = wp_insert_attachment($attachment, $file, $post_id);
        if ( !is_wp_error($id) ) {
            wp_update_attachment_metadata( $id, wp_generate_attachment_metadata( $id, $file ) );
        }

        return $id;
    }

    public static function save_input($form, $field, &$lead, $current_fields, $input_id){

        $input_name = "input_" . str_replace('.', '_', $input_id);
        $value = rgpost($input_name);

        $value = self::maybe_trim_input($value, $form["id"], $field);

        //ignore file upload when nothing was sent in the admin
        //ignore post fields in the admin
        $type = self::get_input_type($field) ;
        $multiple_files = rgar($field, "multipleFiles");
        $uploaded_files = GFFormsModel::$uploaded_files;
        $form_id = $form["id"];
        if(RG_CURRENT_VIEW == "entry" && $type == "fileupload" && ((!$multiple_files && empty($_FILES[$input_name]["name"])) || ($multiple_files && !isset($uploaded_files[$form_id][$input_name]))))
            return;
        else if(RG_CURRENT_VIEW == "entry" && in_array($field["type"], array("post_category","post_title","post_content","post_excerpt","post_tags","post_custom_field","post_image")))
            return;

        if(empty($value) && rgar($field, "adminOnly") && !IS_ADMIN){
            $value = self::get_default_value($field, $input_id);
        }

        //processing values so that they are in the correct format for each input type
        $value = self::prepare_value($form, $field, $value, $input_name, rgar($lead, "id"));

        //ignore fields that have not changed
        if($lead != null && $value === rgget($input_id, $lead)){
            return;
		}


        $lead_detail_id = self::get_lead_detail_id($current_fields, $input_id);
        self::update_lead_field_value($form, $lead, $field, $lead_detail_id, $input_id, $value);

    }

    public static function update_lead_field_value($form, $lead, $field, $lead_detail_id, $input_id, $value){
        global $wpdb;

        $lead_id = $lead["id"];
        $form_id = $form["id"];
        $lead_detail_table = self::get_lead_details_table_name();
        $lead_detail_long_table = self::get_lead_details_long_table_name();

        if(!rgblank($value)){

            $value = apply_filters("gform_save_field_value", $value, $lead, $field, $form, $input_id );
            $truncated_value = GFCommon::safe_substr($value, 0, GFORMS_MAX_FIELD_LENGTH);

            if($lead_detail_id > 0){

                $result = $wpdb->update($lead_detail_table, array("value" => $truncated_value), array("id" => $lead_detail_id), array("%s"), array("%d"));
                if(false === $result)
                    return false ;

                //insert, update or delete long value
                $sql = $wpdb->prepare("SELECT count(0) FROM $lead_detail_long_table WHERE lead_detail_id=%d", $lead_detail_id);
                $has_long_field = intval($wpdb->get_var($sql)) > 0;

                //delete long field if value has been shortened
                if($has_long_field && GFCommon::safe_strlen($value) <= GFORMS_MAX_FIELD_LENGTH){
                    $sql = $wpdb->prepare("DELETE FROM $lead_detail_long_table WHERE lead_detail_id=%d", $lead_detail_id);
                    $result = $wpdb->query($sql);
                    if(false === $result)
                        return false ;
                }
                //update long field
                else if($has_long_field){
                    $result = $wpdb->update($lead_detail_long_table, array("value" => $value), array("lead_detail_id" => $lead_detail_id), array("%s"), array("%d"));
                    if(false === $result)
                        return false ;
                }
                //insert long field (value has been increased)
                else if(GFCommon::safe_strlen($value) > GFORMS_MAX_FIELD_LENGTH){
                    $result = $wpdb->insert($lead_detail_long_table, array("lead_detail_id" => $lead_detail_id, "value" => $value), array("%d", "%s"));
                    if(false === $result)
                        return false ;
                }
            }
            else{
                $result = $wpdb->insert($lead_detail_table, array("lead_id" => $lead_id, "form_id" => $form_id, "field_number" => $input_id, "value" => $truncated_value), array("%d", "%d", "%F", "%s"));
                if(false === $result)
                    return false ;

                if(GFCommon::safe_strlen($value) > GFORMS_MAX_FIELD_LENGTH){

                    //read newly created lead detal id
                    $lead_detail_id = $wpdb->insert_id;

                    //insert long value
                    $result = $wpdb->insert($lead_detail_long_table, array("lead_detail_id" => $lead_detail_id, "value" => $value), array("%d", "%s"));
                    if(false === $result)
                        return false ;
                }
            }
        }
        else{
            //Deleting long field if there is one
            $sql = $wpdb->prepare("DELETE FROM $lead_detail_long_table
                                    WHERE lead_detail_id IN(
                                        SELECT id FROM $lead_detail_table WHERE lead_id=%d AND field_number BETWEEN %s AND %s
                                    )",
                $lead_id, doubleval($input_id) - 0.001, doubleval($input_id) + 0.001);
            $result = $wpdb->query($sql);
            if(false === $result)
                return false ;

            //Deleting details for this field
            $sql = $wpdb->prepare("DELETE FROM $lead_detail_table WHERE lead_id=%d AND field_number BETWEEN %s AND %s ", $lead_id, doubleval($input_id) - 0.001, doubleval($input_id) + 0.001);
            $result = $wpdb->query($sql);
            if(false === $result)
                return false ;
        }
        return true;
    }

    private static function move_temp_file($form_id, $tempfile_info){

        $target = self::get_file_upload_path($form_id, $tempfile_info["uploaded_filename"]);
        $source = self::get_upload_path($form_id) . "/tmp/" . $tempfile_info["temp_filename"];

        if(rename($source, $target["path"])){
            self::set_permissions($target["path"]);
            return $target["url"];
        }
        else{
            return "FAILED (Temporary file could not be moved.)";
        }
    }

    private static function set_permissions($path){

        $permission = apply_filters("gform_file_permission", 0644, $path);
        if($permission){
           chmod($path, $permission);
        }
    }

    public static function upload_file($form_id, $file){

        $target = self::get_file_upload_path($form_id, $file["name"]);
        if(!$target){
            GFCommon::log_debug("upload_file() - FAILED (Upload folder could not be created.)");
            return "FAILED (Upload folder could not be created.)";
        }


        if(move_uploaded_file($file['tmp_name'], $target["path"])){
            GFCommon::log_debug("upload_file() - setting permissions on " . $target["path"]);
            self::set_permissions($target["path"]);
            return $target["url"];
        }
        else{
            GFCommon::log_debug("upload_file() - FAILED (Temporary file could not be copied.)");
            return "FAILED (Temporary file could not be copied.)";
        }
    }


    public static function get_upload_root(){
        $dir = wp_upload_dir();

        if($dir["error"])
            return null;

        return $dir["basedir"] . "/gravity_forms/";
    }

    public static function get_upload_url_root(){
        $dir = wp_upload_dir();

        if($dir["error"])
            return null;

        return $dir["baseurl"] . "/gravity_forms/";
    }

    public static function get_upload_path($form_id){
        return self::get_upload_root() . $form_id . "-" . wp_hash($form_id);
    }

    public static function get_upload_url($form_id){
        $dir = wp_upload_dir();

        return $dir["baseurl"] . "/gravity_forms/$form_id" . "-" . wp_hash($form_id);
    }

    public static function get_file_upload_path($form_id, $file_name){
        if (get_magic_quotes_gpc())
            $file_name = stripslashes($file_name);

        // Where the file is going to be placed
        // Generate the yearly and monthly dirs
        $time = current_time( 'mysql' );
        $y = substr( $time, 0, 4 );
        $m = substr( $time, 5, 2 );
        $target_root = self::get_upload_path($form_id) . "/$y/$m/";
        $target_root_url = self::get_upload_url($form_id) . "/$y/$m/";

        //adding filter to upload root path and url
        $upload_root_info = array("path" => $target_root, "url" => $target_root_url);
        $upload_root_info = apply_filters("gform_upload_path_{$form_id}", apply_filters("gform_upload_path", $upload_root_info, $form_id), $form_id);

        $target_root = $upload_root_info["path"];
        $target_root_url = $upload_root_info["url"];

        if(!is_dir($target_root)){
            if(!wp_mkdir_p($target_root))
                return false;

            //adding index.html files to all subfolders
            if(!file_exists(self::get_upload_root() . "/index.html")){
                GFCommon::recursive_add_index_file(self::get_upload_root());
            }
            else if(!file_exists(self::get_upload_path($form_id) . "/index.html")){
                GFCommon::recursive_add_index_file(self::get_upload_path($form_id));
            }
            else if(!file_exists(self::get_upload_path($form_id) . "/$y/index.html")){
                GFCommon::recursive_add_index_file(self::get_upload_path($form_id) . "/$y");
            }
            else{
                GFCommon::recursive_add_index_file(self::get_upload_path($form_id) . "/$y/$m");
            }

        }

        //Add the original filename to our target path.
        //Result is "uploads/filename.extension"
        $file_info = pathinfo($file_name);
        $extension = rgar($file_info, 'extension');
        if(!empty($extension))
            $extension = "." . $extension;
        $file_name = basename($file_info["basename"], $extension);

        $file_name = sanitize_file_name($file_name);

        $counter = 1;
        $target_path = $target_root . $file_name . $extension;
        while(file_exists($target_path)){
            $target_path = $target_root . $file_name . "$counter" . $extension;
            $counter++;
        }

        //Remove "." from the end if file does not have a file extension
        $target_path = trim($target_path, '.');

        //creating url
        $target_url = str_replace($target_root, $target_root_url, $target_path);

        return array("path" => $target_path, "url" => $target_url);
    }

    public static function get_tables() {
        return array(
            self::get_lead_details_long_table_name(),
            self::get_lead_notes_table_name(),
            self::get_lead_details_table_name(),
            self::get_lead_table_name(),
            self::get_form_view_table_name(),
            self::get_meta_table_name(),
            self::get_form_table_name(),
            self::get_lead_meta_table_name()
            );
    }

    public static function drop_tables(){
        global $wpdb;
        foreach(self::get_tables() as $table) {
            $wpdb->query("DROP TABLE IF EXISTS $table");
        }
    }

    public static function mu_drop_tables($drop_tables) {
        return array_merge($drop_tables, self::get_tables());
    }

    public static function insert_form_view($form_id, $ip){
        global $wpdb;
        $table_name = self::get_form_view_table_name();

        $sql = $wpdb->prepare(" SELECT id FROM $table_name
                                WHERE form_id=%d
                                AND year(date_created) = year(utc_timestamp())
                                AND month(date_created) = month(utc_timestamp())
                                AND day(date_created) = day(utc_timestamp())
                                AND hour(date_created) = hour(utc_timestamp())", $form_id);

        $id = $wpdb->get_var($sql, 0, 0);

        if(empty($id))
            $wpdb->query($wpdb->prepare("INSERT INTO $table_name(form_id, date_created, ip) values(%d, utc_timestamp(), %s)", $form_id, $ip));
        else
            $wpdb->query($wpdb->prepare("UPDATE $table_name SET count = count+1 WHERE id=%d", $id));
    }

    public static function is_duplicate($form_id, $field, $value){
        global $wpdb;
        $lead_detail_table_name = self::get_lead_details_table_name();
        $lead_table_name = self::get_lead_table_name();
        $sql_comparison = "ld.value=%s";

        switch(RGFormsModel::get_input_type($field)){
            case "time" :
                $value = sprintf("%02d:%02d %s", $value[0], $value[1], $value[2]);
            break;
            case "date" :
                $value = self::prepare_date(rgar($field, "dateFormat"), $value);
            break;
            case "number" :
                $value = GFCommon::clean_number($value, rgar($field, 'numberFormat'));
            break;
            case "phone" :
                $value = str_replace(array(")", "(", "-", " "), array("", "", "", ""), $value);
                $sql_comparison = 'replace(replace(replace(replace(ld.value, ")", ""), "(", ""), "-", ""), " ", "") = %s';
            break;
         }


        $inner_sql_template = " SELECT %s as input, ld.lead_id
                                FROM $lead_detail_table_name ld
                                INNER JOIN $lead_table_name l ON l.id = ld.lead_id
                                WHERE l.form_id=%d AND ld.form_id=%d
                                AND ld.field_number between %s AND %s
                                AND status='active' AND {$sql_comparison}";

        $sql = "SELECT count(distinct input) as match_count FROM ( ";

        $input_count = 1;
        if(is_array($field["inputs"])){
            $input_count = sizeof($field["inputs"]);
            foreach($field["inputs"] as $input){
                $union = empty($inner_sql) ? "" : " UNION ALL ";
                $inner_sql .= $union . $wpdb->prepare($inner_sql_template, $input["id"], $form_id, $form_id, $input["id"] - 0.001, $input["id"] + 0.001, $value[$input["id"]]);
            }
        }
        else{
            $inner_sql = $wpdb->prepare($inner_sql_template, $field["id"], $form_id, $form_id, doubleval($field["id"]) - 0.001, doubleval($field["id"]) + 0.001, $value);
        }

        $sql .= $inner_sql . "
                ) as count
                GROUP BY lead_id
                ORDER BY match_count DESC";

        $count = apply_filters("gform_is_duplicate_{$form_id}", apply_filters('gform_is_duplicate', $wpdb->get_var($sql), $form_id, $field, $value), $form_id, $field, $value);

        return $count != null && $count >= $input_count;
    }

    public static function get_lead($lead_id){
        global $wpdb;
        $lead_detail_table_name = self::get_lead_details_table_name();
        $lead_table_name = self::get_lead_table_name();

        $results = $wpdb->get_results($wpdb->prepare("  SELECT l.*, field_number, value
                                                        FROM $lead_table_name l
                                                        INNER JOIN $lead_detail_table_name ld ON l.id = ld.lead_id
                                                        WHERE l.id=%d", $lead_id));

        $leads = self::build_lead_array($results, true);
        return sizeof($leads) == 1 ? $leads[0] : false;
    }

    public static function get_lead_notes($lead_id){
        global $wpdb;
        $notes_table = self::get_lead_notes_table_name();

        return $wpdb->get_results($wpdb->prepare("  SELECT n.id, n.user_id, n.date_created, n.value, n.note_type, ifnull(u.display_name,n.user_name) as user_name, u.user_email
                                                    FROM $notes_table n
                                                    LEFT OUTER JOIN $wpdb->users u ON n.user_id = u.id
                                                    WHERE lead_id=%d ORDER BY id", $lead_id));
    }

    public static function refresh_lead_field_value($lead_id, $field_id){
        $cache_key = "GFFormsModel::get_lead_field_value_" . $lead_id . "_" . $field_id;
        GFCache::delete($cache_key);
    }

    public static function get_lead_field_value($lead, $field){

        if(empty($lead))
            return;

        //returning cache entry if available
        $cache_key = "GFFormsModel::get_lead_field_value_" . $lead["id"] . "_" . $field["id"];

        $cache_value = GFCache::get($cache_key);
        if($cache_value !== false)
            return $cache_value;

        $max_length = GFORMS_MAX_FIELD_LENGTH;
        $value = array();
        if(is_array(rgar($field, "inputs"))){
            //making sure values submitted are sent in the value even if
            //there isn't an input associated with it
            $lead_field_keys = array_keys($lead);
            foreach($lead_field_keys as $input_id){
                if(is_numeric($input_id) && absint($input_id) == absint($field["id"])){
                    $val = $lead[$input_id];
                    if(strlen($val) >= ($max_length-10)) {
                        if(empty($form))
                            $form = RGFormsModel::get_form_meta($lead["form_id"]);

                        $long_choice = self::get_field_value_long($lead, $input_id, $form);
                    }
                    else{
                        $long_choice = $val;
                    }

                     $value[$input_id] = !empty($long_choice) ? $long_choice : $val;
                }
            }
        }
        else{
            $val = rgget($field["id"], $lead);

            //To save a database call to get long text, only getting long text if regular field is "somewhat" large (i.e. max - 50)
            if(strlen($val) >= ($max_length - 50)){
                if(empty($form))
                    $form = RGFormsModel::get_form_meta($lead["form_id"]);

                $long_text = self::get_field_value_long($lead, $field["id"], $form);
            }

            $value = !empty($long_text) ? $long_text : $val;
        }

        //filtering lead value
        $value = apply_filters("gform_get_field_value", $value, $lead, $field);

        //saving value in global variable to optimize performance
        GFCache::set($cache_key, $value);

        return $value;
    }

    public static function get_field_value_long($lead, $field_number, $form, $apply_filter=true){
        global $wpdb;
        $detail_table_name = self::get_lead_details_table_name();
        $long_table_name = self::get_lead_details_long_table_name();

        $sql = $wpdb->prepare(" SELECT l.value FROM $detail_table_name d
                                INNER JOIN $long_table_name l ON l.lead_detail_id = d.id
                                WHERE lead_id=%d AND field_number BETWEEN %s AND %s", $lead["id"], doubleval($field_number) - 0.001, doubleval($field_number) + 0.001);

         $val = $wpdb->get_var($sql);

         //running aform_get_input_value when needed
         if($apply_filter){
            $field = RGFormsModel::get_field($form, $field_number);
            $input_id = (string)$field_number == (string)$field["id"] ? "" : $field_number;
            $val = apply_filters("gform_get_input_value", $val, $lead, $field, $input_id);
         }

         return $val;
    }

    public static function get_leads_by_meta($meta_key, $meta_value){
        global $wpdb;

        $sql =  $wpdb->prepare( "   SELECT l.*, d.field_number, d.value
                                    FROM {$wpdb->prefix}rg_lead l
                                    INNER JOIN {$wpdb->prefix}rg_lead_detail d ON l.id = d.lead_id
                                    INNER JOIN {$wpdb->prefix}rg_lead_meta m ON l.id = m.lead_id
                                    WHERE m.meta_key=%s AND m.meta_value=%s", $meta_key, $meta_value);

        //getting results
        $results = $wpdb->get_results($sql);
        $leads = self::build_lead_array($results);
        return $leads;
    }

    public static function get_leads($form_id, $sort_field_number=0, $sort_direction='DESC', $search='', $offset=0, $page_size=30, $star=null, $read=null, $is_numeric_sort = false, $start_date=null, $end_date=null, $status='active', $payment_status = false){
        global $wpdb;

        if(empty($sort_field_number))
            $sort_field_number = "date_created";

        if(is_numeric($sort_field_number)) {
            $sql = self::sort_by_custom_field_query($form_id, $sort_field_number, $sort_direction, $search, $offset, $page_size, $star, $read, $is_numeric_sort, $status, $payment_status);
        } else {
            $sql = self::sort_by_default_field_query($form_id, $sort_field_number, $sort_direction, $search, $offset, $page_size, $star, $read, $is_numeric_sort, $start_date, $end_date, $status, $payment_status);
        }

        //initializing rownum
        $wpdb->query("select @rownum:=0");

        //getting results
        $results = $wpdb->get_results($sql);

        $leads = self::build_lead_array($results);

        return $leads;
    }

    public static function get_leads_count($form_id) { }

    private static function sort_by_custom_field_query($form_id, $sort_field_number=0, $sort_direction='DESC', $search='', $offset=0, $page_size=30, $star=null, $read=null, $is_numeric_sort = false, $status='active', $payment_status = false){
        global $wpdb;
        if(!is_numeric($form_id) || !is_numeric($sort_field_number)|| !is_numeric($offset)|| !is_numeric($page_size))
            return "";

        $lead_detail_table_name = self::get_lead_details_table_name();
        $lead_table_name = self::get_lead_table_name();

        $orderby = $is_numeric_sort ? "ORDER BY query, (value+0) $sort_direction" : "ORDER BY query, value $sort_direction";
        $is_default = false;

        $search_sql = self::get_leads_where_sql(compact('form_id', 'search', 'status', 'star', 'read', 'start_date', 'end_date', 'payment_status', 'is_default'));

        $field_number_min = $sort_field_number - 0.001;
        $field_number_max = $sort_field_number + 0.001;

        $sql = "
            SELECT filtered.sort, l.*, d.field_number, d.value
            FROM $lead_table_name l
            INNER JOIN $lead_detail_table_name d ON d.lead_id = l.id
            INNER JOIN (
                SELECT distinct sorted.sort, l.id
                FROM $lead_table_name l
                INNER JOIN $lead_detail_table_name d ON d.lead_id = l.id
                INNER JOIN (
                    SELECT @rownum:=@rownum+1 as sort, id FROM (
                        SELECT 0 as query, lead_id as id, value
                        FROM $lead_detail_table_name
                        WHERE form_id=$form_id
                        AND field_number between $field_number_min AND $field_number_max

                        UNION ALL

                        SELECT 1 as query, l.id, d.value
                        FROM $lead_table_name l
                        LEFT OUTER JOIN $lead_detail_table_name d ON d.lead_id = l.id AND field_number between $field_number_min AND $field_number_max
                        WHERE l.form_id=$form_id
                        AND d.lead_id IS NULL

                    ) sorted1
                   $orderby
                ) sorted ON d.lead_id = sorted.id
                $search_sql
                LIMIT $offset,$page_size
            ) filtered ON filtered.id = l.id
            ORDER BY filtered.sort";

        return $sql;
    }

    private static function sort_by_default_field_query($form_id, $sort_field, $sort_direction='DESC', $search='', $offset=0, $page_size=30, $star=null, $read=null, $is_numeric_sort = false, $start_date=null, $end_date=null, $status='active', $payment_status = false){
        global $wpdb;

        if(!is_numeric($form_id) || !is_numeric($offset)|| !is_numeric($page_size)){
            return "";
        }

        $lead_detail_table_name = self::get_lead_details_table_name();
        $lead_table_name = self::get_lead_table_name();
		$lead_meta_table_name = self::get_lead_meta_table_name();

        $where = self::get_leads_where_sql(compact('form_id', 'search', 'status', 'star', 'read', 'start_date', 'end_date', 'payment_status'));

        $entry_meta = self::get_entry_meta($form_id);
        $entry_meta_sql_join = "";
        if ( false === empty( $entry_meta ) && array_key_exists( $sort_field, $entry_meta ) ) {
            $entry_meta_sql_join = $wpdb->prepare("INNER JOIN
                                                    (
                                                    SELECT
                                                         lead_id, meta_value as $sort_field
                                                         from $lead_meta_table_name
                                                         WHERE meta_key = '$sort_field'
                                                    ) lead_meta_data ON lead_meta_data.lead_id = l.id
                                                    ");
            $is_numeric_sort = $entry_meta[$sort_field]['is_numeric'];
        }
        $grid_columns = RGFormsModel::get_grid_columns($form_id);
        if ( $sort_field != "date_created" && false === array_key_exists($sort_field, $grid_columns) )
            $sort_field = "date_created";
        $orderby = $is_numeric_sort ? "ORDER BY ($sort_field+0) $sort_direction" : "ORDER BY $sort_field $sort_direction";

		$sql = "
            SELECT filtered.sort, l.*, d.field_number, d.value
            FROM $lead_table_name l
            INNER JOIN $lead_detail_table_name d ON d.lead_id = l.id
            INNER JOIN
            (
                SELECT @rownum:=@rownum + 1 as sort, id
                FROM
                (
                    SELECT distinct l.id
                    FROM $lead_table_name l
                    INNER JOIN $lead_detail_table_name d ON d.lead_id = l.id
					$entry_meta_sql_join
                    $where
                    $orderby
                    LIMIT $offset,$page_size
                ) page
            ) filtered ON filtered.id = l.id
            ORDER BY filtered.sort";

        return $sql;
    }

    public static function get_leads_where_sql($args) {
        global $wpdb;

        extract(wp_parse_args($args, array(
            'form_id' => false,
            'search' => '',
            'status' => 'active',
            'star' => null,
            'read' => null,
            'start_date' => null,
            'end_date' => null,
            'payment_status' => null,
            'is_default' => true
            )));

        $where = array();

        if($is_default)
            $where[] = "l.form_id = $form_id";

        if($search && $is_default) {
            $where[] = $wpdb->prepare("value LIKE %s", "%$search%");
        } else if($search) {
            $where[] = $wpdb->prepare("d.value LIKE %s", "%$search%");
        }

        if($star !== null && $status == 'active')
            $where[] = $wpdb->prepare("is_starred = %d AND status = 'active'", $star);

        if($read !== null && $status == 'active')
            $where[] = $wpdb->prepare("is_read = %d AND status = 'active'", $read);

        if($payment_status)
            $where[] = $wpdb->prepare("payment_status = '%s'", $payment_status);

        if ($status !== null)
        	$where[] = $wpdb->prepare("status = %s", $status);

        if(!empty($start_date))
            $where[] = "timestampdiff(SECOND, '$start_date', date_created) >= 0";

        if(!empty($end_date))
            $where[] = "timestampdiff(SECOND, '$end_date', date_created) <= 0";

        return 'WHERE ' . implode(' AND ', $where);
    }

    public static function build_lead_array($results, $use_long_values = true){

        $leads = array();
        $lead = array();
        $form_id = 0;
        if(is_array($results) && sizeof($results) > 0){
            $form_id = $results[0]->form_id;
            $lead = array("id" => $results[0]->id, "form_id" => $results[0]->form_id, "date_created" => $results[0]->date_created, "is_starred" => intval($results[0]->is_starred), "is_read" => intval($results[0]->is_read), "ip" => $results[0]->ip, "source_url" => $results[0]->source_url, "post_id" => $results[0]->post_id, "currency" => $results[0]->currency, "payment_status" => $results[0]->payment_status, "payment_date" => $results[0]->payment_date, "transaction_id" => $results[0]->transaction_id, "payment_amount" => $results[0]->payment_amount, "payment_method" => $results[0]->payment_method, "is_fulfilled" => $results[0]->is_fulfilled, "created_by" => $results[0]->created_by, "transaction_type" => $results[0]->transaction_type, "user_agent" => $results[0]->user_agent, "status" => $results[0]->status);

            $form = RGFormsModel::get_form_meta($form_id);
            $prev_lead_id=0;
            foreach($results as $result){
                if($prev_lead_id <> $result->id && $prev_lead_id > 0){
                    array_push($leads, $lead);
                    $lead = array("id" => $result->id, "form_id" => $result->form_id,     "date_created" => $result->date_created,     "is_starred" => intval($result->is_starred),     "is_read" => intval($result->is_read),     "ip" => $result->ip,     "source_url" => $result->source_url,     "post_id" => $result->post_id,     "currency" => $result->currency,     "payment_status" => $result->payment_status,     "payment_date" => $result->payment_date,     "transaction_id" => $result->transaction_id,     "payment_amount" => $result->payment_amount,  "payment_method" => $result->payment_method,     "is_fulfilled" => $result->is_fulfilled,     "created_by" => $result->created_by,     "transaction_type" => $result->transaction_type,     "user_agent" => $result->user_agent,    "status" => $result->status);
                }

                $field_value = $result->value;
                //using long values if specified
                if($use_long_values && strlen($field_value) >= (GFORMS_MAX_FIELD_LENGTH-10)){
                    $field = RGFormsModel::get_field($form, $result->field_number);
                    $long_text = RGFormsModel::get_field_value_long($lead, $result->field_number, $form, false);
                    $field_value = !empty($long_text) ? $long_text : $field_value;
                }

                $lead[$result->field_number] = $field_value;
                $prev_lead_id = $result->id;
            }
        }


        //adding last lead.
        if(sizeof($lead) > 0)
            array_push($leads, $lead);

        //running entry through gform_get_field_value filter
        foreach($leads as &$lead){

            foreach($form["fields"] as $field){
                // skip types html, page and section?
                if(isset($field["inputs"]) && is_array($field["inputs"])){
                    foreach($field["inputs"] as $input){
                        $lead[(string)$input["id"]] = apply_filters("gform_get_input_value", rgar($lead, (string)$input["id"]), $lead, $field, $input["id"]);
                    }
                }
                else {

                    $value = rgar( $lead, (string) $field['id'] );

                    if( self::is_encrypted_field( $lead['id'], $field['id'] ) )
                        $value = GFCommon::decrypt( $value );

                    $lead[$field["id"]] = apply_filters("gform_get_input_value", $value, $lead, $field, "" );

                }
            }
        }

		//add custom entry properties
        $entry_ids = array();
        foreach($leads as $l){
            $entry_ids[] = $l["id"];
        }
        $entry_meta = GFFormsModel::get_entry_meta($form_id);
        $meta_keys = array_keys($entry_meta);
        $entry_meta_data_rows = gform_get_meta_values_for_entries($entry_ids, $meta_keys);
        foreach($leads as &$lead){
            foreach($entry_meta_data_rows as $entry_meta_data_row){
                if($entry_meta_data_row->lead_id == $lead["id"]){
                    foreach($meta_keys as $meta_key){
                        $lead[$meta_key] = $entry_meta_data_row->$meta_key;
                    }
                }
            }
        }

        return $leads;
    }

    public static function save_key($key){
        $current_key = get_option("rg_gforms_key");
        if(empty($key)){
            delete_option("rg_gforms_key");
        }
        else if($current_key != $key){
            $key = trim($key);
            update_option("rg_gforms_key", md5($key));
        }
    }

    public static function get_lead_count($form_id, $search, $star=null, $read=null, $start_date=null, $end_date=null, $status=null, $payment_status = null){
        global $wpdb;

        if(!is_numeric($form_id))
            return "";

        $detail_table_name = self::get_lead_details_table_name();
        $lead_table_name = self::get_lead_table_name();

        $where = self::get_leads_where_sql(compact('form_id', 'search', 'status', 'star', 'read', 'start_date', 'end_date', 'payment_status', 'is_default'));

        $sql = "SELECT count(distinct l.id)
                FROM $lead_table_name l
                INNER JOIN $detail_table_name ld ON l.id = ld.lead_id
                $where";

        return $wpdb->get_var($sql);
    }

    public static function get_lead_ids($form_id, $search, $star=null, $read=null, $start_date=null, $end_date=null, $status=null, $payment_status = null){
        global $wpdb;

        if(!is_numeric($form_id))
            return "";

        $detail_table_name = self::get_lead_details_table_name();
        $lead_table_name = self::get_lead_table_name();

        $where = self::get_leads_where_sql(compact('form_id', 'search', 'status', 'star', 'read', 'start_date', 'end_date', 'payment_status', 'is_default'));

        $sql = "SELECT distinct l.id
                FROM $lead_table_name l
                INNER JOIN $detail_table_name ld ON l.id = ld.lead_id
                $where";

        $rows =  $wpdb->get_results($sql);

        if(empty($rows))
            return array();

        foreach ($rows as $row){
            $lead_ids[] = $row->id;
        }

        return $lead_ids;

    }

    public static function get_grid_columns($form_id, $input_label_only=false){
        $form = self::get_form_meta($form_id);
        $field_ids = self::get_grid_column_meta($form_id);

        if(!is_array($field_ids)){
            $field_ids = array();
            for($i=0, $count=sizeof($form["fields"]); $i<$count && $i<5; $i++){
                $field = $form["fields"][$i];

                //loading post category fields with choices and inputs
                if($field["type"] == "post_category")
                    $field = GFCommon::add_categories_as_choices($field, "");

                if(RGForms::get("displayOnly",$field) || self::get_input_type($field) == "list")
                    continue;

                if(isset($field["inputs"]) && is_array($field["inputs"])){
                    if($field["type"] == "name"){
                        $field_ids[] = $field["id"] . '.3'; //adding first name
                        $field_ids[] = $field["id"] . '.6'; //adding last name
                    }
                    else{
                        $field_ids[] = $field["inputs"][0]["id"]; //getting first input
                    }
                }
                else{
                    $field_ids[] = $field["id"];
                }
            }
			//adding default entry meta columns
            $entry_metas = GFFormsModel::get_entry_meta($form_id);
            foreach ($entry_metas as $key => $entry_meta){
            	if (rgar($entry_meta,"is_default_column"))
            		$field_ids[] = $key;
            }
        }

        $columns = array();
        $entry_meta = self::get_entry_meta($form_id);
        foreach($field_ids as $field_id){

            switch($field_id){
                case "id" :
                    $columns[$field_id] = array("label" => "Entry Id", "type" => "id");
                break;
                case "ip" :
                    $columns[$field_id] = array("label" => "User IP", "type" => "ip");
                break;
                case "date_created" :
                    $columns[$field_id] = array("label" => "Entry Date", "type" => "date_created");
                break;
                case "source_url" :
                    $columns[$field_id] = array("label" => "Source Url", "type" => "source_url");
                break;
                case "payment_status" :
                    $columns[$field_id] = array("label" => "Payment Status", "type" => "payment_status");
                break;
                case "transaction_id" :
                    $columns[$field_id] = array("label" => "Transaction Id", "type" => "transaction_id");
                break;
                case "payment_date" :
                    $columns[$field_id] = array("label" => "Payment Date", "type" => "payment_date");
                break;
                case "payment_amount" :
                    $columns[$field_id] = array("label" => "Payment Amount", "type" => "payment_amount");
                break;
                case "created_by" :
                    $columns[$field_id] = array("label" => "User", "type" => "created_by");
                break;
				case ((is_string($field_id) || is_int($field_id)) && array_key_exists($field_id, $entry_meta)) :
                    $columns[$field_id] = array("label" => $entry_meta[$field_id]["label"], "type" => $field_id);
                break;
                default :
                    $field = self::get_field($form, $field_id);
                    if($field)
                        $columns[strval($field_id)] = array("label" => self::get_label($field, $field_id, $input_label_only), "type" => rgget("type", $field), "inputType" => rgget("inputType", $field));
            }
        }
        return $columns;
    }

    public static function get_label($field, $input_id = 0, $input_only = false){
        $field_label = (IS_ADMIN || RG_CURRENT_PAGE == "select_columns.php" || RG_CURRENT_PAGE == "print-entry.php" || rgget("gf_page", $_GET) == "select_columns" || rgget("gf_page", $_GET) == "print-entry") && !rgempty("adminLabel", $field) ? rgar($field,"adminLabel") : rgar($field,"label");
        $input = self::get_input($field, $input_id);
        if(rgget("type", $field) == "checkbox" && $input != null)
            return $input["label"];
        else if($input != null)
            return $input_only ? $input["label"] : $field_label . ' (' . $input["label"] . ')';
        else
            return $field_label;
    }

    public static function get_input($field, $id){
        if(isset($field["inputs"]) && is_array($field["inputs"])){
            foreach($field["inputs"] as $input)
            {
                if($input["id"] == $id)
                    return $input;
            }
        }
        return null;
    }

    public static function has_input($field, $input_id){
        if(!is_array($field["inputs"]))
            return false;
        else{
            foreach($field["inputs"] as $input)
            {
                if($input["id"] == $input_id)
                    return true;
            }
            return false;
        }
    }

    public static function get_current_page_url($force_ssl=false) {
        $pageURL = 'http';
        if (RGForms::get("HTTPS",$_SERVER) == "on" || $force_ssl)
            $pageURL .= "s";
        $pageURL .= "://";

        $pageURL .= RGForms::get("HTTP_HOST", $_SERVER) . rgget("REQUEST_URI", $_SERVER);
        return $pageURL;
    }

    public static function get_submitted_fields($form_id){
        global $wpdb;
        $lead_detail_table_name = self::get_lead_details_table_name();
        $field_list = "";
        $fields = $wpdb->get_results($wpdb->prepare("SELECT DISTINCT field_number FROM $lead_detail_table_name WHERE form_id=%d", $form_id));
        foreach($fields as $field)
            $field_list .= intval($field->field_number) . ',';

        if(!empty($field_list))
            $field_list = substr($field_list, 0, strlen($field_list) -1);

        return $field_list;
    }

    public static function get_field($form, $field_id){
        if(is_numeric($field_id))
            $field_id = intval($field_id); //removing floating part of field (i.e 1.3 -> 1) to return field by input id

        if(!is_array($form["fields"]))
            return null;

        global $_fields;
        $key = $form["id"] . "_" . $field_id;
        if(!isset($_fields[$key])){
            $_fields[$key] = null;
            foreach($form["fields"] as $field){
                if($field["id"] == $field_id){
                    $_fields[$key] = $field;
                    break;
                }
            }
        }
        return $_fields[$key];
    }

    public static function is_html5_enabled(){
        return get_option("rg_gforms_enable_html5");
    }

    /**
    * Return the current lead being processed. Should only be called when a form has been submitted.
    * If called before the "real" lead has been saved to the database, uses self::create_lead() to create
    * a temporary lead to work with.
    */
    public static function get_current_lead() {

        // if a GF submission is not in process, always return false
        if(!rgpost('gform_submit'))
            return false;

        if(!self::$_current_lead) {
            $form_id = absint(rgpost('gform_submit'));
            $form = self::get_form_meta($form_id);
            self::$_current_lead = self::create_lead($form);
        }

        return self::$_current_lead;
    }

    /**
    * Set RGFormsModel::$lead for use in hooks where $lead is not explicitly passed.
    *
    * @param mixed $lead
    */
    public static function set_current_lead($lead) {
        GFCache::flush();
        self::$_current_lead = $lead;
    }

    /**
    * v1.7 introduces conditional confirmations. If the form's "confirmations" key is empty, grab the existing confirmation
    * and populate it in the form's "confirmations" property.
    *
    * @param mixed $form
    */
    public static function convert_confirmation($form) {

        $id = uniqid();

        // convert confirmation to new confirmations format
        $confirmation = rgar($form,'confirmation');
        $confirmation['id'] = $id;
        $confirmation['name'] = __('Default Confirmation', 'gravityforms');
        $confirmation['isDefault'] = true;

        $form['confirmations'] = array($id => $confirmation);

        self::save_form_confirmations($form['id'], $form['confirmations']);

        return $form;
    }

    public static function load_confirmations($form) {

        $confirmations = self::get_form_confirmations($form['id']);

        // if there are no confirmations, convert existing (singular) confirmation (prior to 1.7) to new (plural) confirmations format
        if(empty($confirmations)) {
            $form = self::convert_confirmation($form);
        } else {
            $form['confirmations'] = $confirmations;
        }

        return $form;
    }

    public static function get_form_confirmations($form_id) {
        global $wpdb;

        if(isset($_confirmations[$form_id]))
            return $_confirmations[$form_id];

        $tablename = GFFormsModel::get_meta_table_name();
        $sql = $wpdb->prepare("SELECT confirmations FROM $tablename WHERE form_id = %d", $form_id);
        $results = $wpdb->get_results($sql, ARRAY_A);
        $confirmations = rgars($results, '0/confirmations');

        self::$_confirmations[$form_id] = $confirmations ? self::unserialize($confirmations) : array();

        return self::$_confirmations[$form_id];
    }

    public static function save_form_confirmations($form_id, $confirmations) {
        return self::update_form_meta($form_id, $confirmations, 'confirmations');
    }

    public static function save_form_notifications($form_id, $notifications) {
        return self::update_form_meta($form_id, $notifications, 'notifications');
    }

    public static function get_form_ids($active = true, $trash = false){
        global $wpdb;
        $table = self::get_form_table_name();
        $sql = $wpdb->prepare("SELECT id from $table where is_active = %d and is_trash = %d", (bool) $active, (bool) $trash );
        $results = $wpdb->get_col($sql);
        return $results;
    }

    public static function get_entry_meta($form_ids){
        global $_entry_meta;

        if($form_ids==0)
            $form_ids = self::get_form_ids();

        if(!is_array($form_ids))
            $form_ids=array($form_ids);
        $meta = array();
        foreach($form_ids as $form_id){
            if(!isset($_entry_meta[$form_id])){
                $_entry_meta = array();
                $_entry_meta[$form_id] = apply_filters('gform_entry_meta', array(), $form_id);
            }
            $meta = array_merge($meta, $_entry_meta[$form_id]);
        }

        return $meta;
    }

    public static function set_entry_meta($lead, $form){
        $entry_meta = self::get_entry_meta($form["id"]);
        $keys = array_keys($entry_meta);
        foreach ($keys as $key){
            if (isset($entry_meta[$key]['update_entry_meta_callback'])){
                $callback = $entry_meta[$key]['update_entry_meta_callback'];
                $value = call_user_func_array($callback, array($key, $lead, $form));
                gform_update_meta($lead["id"], $key, $value);
                $lead[$key] = $value;
            }
        }
        return $lead;
    }

    public static function search_leads($form_id, $search_criteria = array(), $sorting = null, $paging = null) {

        global $wpdb;
        $sort_field = isset($sorting["key"]) ? $sorting["key"] : "date_created"; // column, field or entry meta

        if (is_numeric($sort_field))
            $sql = self::sort_by_field_query($form_id, $search_criteria, $sorting, $paging);
        else
            $sql = self::sort_by_column_query($form_id, $search_criteria, $sorting, $paging);

        //initializing rownum
        $wpdb->query("select @rownum:=0");

        GFCommon::log_debug($sql);

        //getting results
        $results = $wpdb->get_results($sql);

        $leads = GFFormsModel::build_lead_array($results);

        return $leads;
    }

    public static function search_lead_ids($form_id, $search_criteria = array()) {
        global $wpdb;

        $detail_table_name = GFFormsModel::get_lead_details_table_name();
        $lead_table_name   = GFFormsModel::get_lead_table_name();

        $where = self::get_search_where($form_id, $search_criteria);

        $sql = "SELECT distinct l.id
                FROM $lead_table_name l
                INNER JOIN $detail_table_name ld ON l.id = ld.lead_id
                $where
                ";

        $rows =  $wpdb->get_results($sql);

        if(empty($rows))
            return array();

        foreach ($rows as $row){
            $lead_ids[] = $row->id;
        }

        return $lead_ids;
    }

    private static function sort_by_field_query($form_id, $search_criteria, $sorting, $paging) {
        global $wpdb;
        $sort_field_number = rgar($sorting, "key");
        $sort_direction    = isset($sorting["direction"]) ? $sorting["direction"] : "DESC";

        $is_numeric_sort = isset($sorting["is_numeric"]) ? $sorting["is_numeric"] : false;
        $offset          = isset($paging["offset"]) ? $paging["offset"] : 0;
        $page_size       = isset($paging["page_size"]) ? $paging["page_size"] : 20;

        if (!is_numeric($sort_field_number) || !is_numeric($offset) || !is_numeric($page_size))
            return "";

        $lead_detail_table_name = GFFormsModel::get_lead_details_table_name();
        $lead_table_name        = GFFormsModel::get_lead_table_name();

        $orderby = $is_numeric_sort ? "ORDER BY query, (value+0) $sort_direction" : "ORDER BY query, value $sort_direction";

        $form_id_where = self::get_form_id_where($form_id);

        if(!empty($form_id_where)){
            $form_id_where = " AND " . $form_id_where;
        }

        $where = self::get_search_where($form_id, $search_criteria);

        $field_number_min = $sort_field_number - 0.001;
        $field_number_max = $sort_field_number + 0.001;

        $sql = "
            SELECT filtered.sort, l.*, d.field_number, d.value
            FROM $lead_table_name l
            INNER JOIN $lead_detail_table_name d ON d.lead_id = l.id
            INNER JOIN (
                SELECT distinct sorted.sort, l.id
                FROM $lead_table_name l
                INNER JOIN $lead_detail_table_name d ON d.lead_id = l.id
                INNER JOIN (
                    SELECT @rownum:=@rownum+1 as sort, id FROM (
                        SELECT 0 as query, lead_id as id, value
                        FROM $lead_detail_table_name l
                        WHERE field_number between $field_number_min AND $field_number_max
                        $form_id_where

                        UNION ALL

                        SELECT 1 as query, l.id, d.value
                        FROM $lead_table_name l
                        LEFT OUTER JOIN $lead_detail_table_name d ON d.lead_id = l.id AND field_number between $field_number_min AND $field_number_max
                        WHERE d.lead_id IS NULL
                        $form_id_where

                    ) sorted1
                   $orderby
                ) sorted ON d.lead_id = sorted.id
                $where
                LIMIT $offset,$page_size
            ) filtered ON filtered.id = l.id

            ORDER BY filtered.sort";

        return $sql;
    }

    private static function sort_by_column_query($form_id, $search_criteria, $sorting, $paging) {
        global $wpdb;
        $sort_field      = isset($sorting["key"]) ? $sorting["key"] : "date_created";
        $sort_direction  = isset($sorting["direction"]) ? $sorting["direction"] : "DESC";
        $is_numeric_sort = isset($sorting["is_numeric"]) ? $sorting["is_numeric"] : false;
        $offset          = isset($paging["offset"]) ? $paging["offset"] : 0;
        $page_size       = isset($paging["page_size"]) ? $paging["page_size"] : 20;

        if (!is_numeric($offset) || !is_numeric($page_size)) {
            return "";
        }

        $lead_detail_table_name = GFFormsModel::get_lead_details_table_name();
        $lead_table_name        = GFFormsModel::get_lead_table_name();
        $lead_meta_table_name   = GFFormsModel::get_lead_meta_table_name();

        $entry_meta          = GFFormsModel::get_entry_meta(is_array($form_id) ? 0 : $form_id);
        $entry_meta_sql_join = "";
        $sort_field_is_entry_meta = false;
        if (false === empty($entry_meta) && array_key_exists($sort_field, $entry_meta)) {
            $entry_meta_sql_join = $wpdb->prepare("
                INNER JOIN
                (
                SELECT
                     lead_id, meta_value as $sort_field
                     from $lead_meta_table_name
                     WHERE meta_key=%s
                ) lead_meta_data ON lead_meta_data.lead_id = l.id
                ", $sort_field);
            $is_numeric_sort = $entry_meta[$sort_field]['is_numeric'];
            $sort_field_is_entry_meta = true;
        } else {
            $db_columns = self::get_lead_db_columns();
            if ($sort_field != "date_created" && false === in_array($sort_field, $db_columns))
                $sort_field = "date_created";
        }

        if($sort_field_is_entry_meta){
            $orderby = $is_numeric_sort ? "ORDER BY ($sort_field+0) $sort_direction" : "ORDER BY $sort_field $sort_direction";
        } else {
            $orderby = $is_numeric_sort ? "ORDER BY (l.$sort_field+0) $sort_direction" : "ORDER BY l.$sort_field $sort_direction";
        }

        $where = self::get_search_where($form_id, $search_criteria);

        $sql  = "
            SELECT filtered.sort, l.*, d.field_number, d.value
            FROM $lead_table_name l
            INNER JOIN $lead_detail_table_name d ON d.lead_id = l.id
            INNER JOIN
            (
                SELECT @rownum:=@rownum + 1 as sort, id
                FROM
                (
                    SELECT distinct l.id
                    FROM $lead_table_name l
                    INNER JOIN $lead_detail_table_name d ON d.lead_id = l.id
                    $entry_meta_sql_join
                    $where
                    $orderby
                    LIMIT $offset,$page_size
                ) page
            ) filtered ON filtered.id = l.id

            ORDER BY filtered.sort";

        return $sql;
    }

    private static function get_form_id_where($form_id){
        global $wpdb;

        if(is_array($form_id)){
            $in_str_arr = array_fill(0, count($form_id), '%s');
            $in_str     = esc_sql(join(",", $in_str_arr));
            $form_id_where = $wpdb->prepare("l.form_id IN ($in_str)", $form_id);
        } else {
            $form_id_where = $form_id > 0 ? $wpdb->prepare("l.form_id=%d", $form_id) : "";
        }

        return $form_id_where;
    }

    private static function get_search_where($form_id, $search_criteria){

        global $wpdb;

        $where_arr = array();

        $field_filters_where = self::get_field_filters_where($form_id, $search_criteria);
        if (!empty($field_filters_where))
            $where_arr[]=$field_filters_where;

        $info_search_where = self::get_info_search_where($search_criteria);

        if(!empty($info_search_where))
            $where_arr[] = $info_search_where;

        $search_operator = self::get_search_operator($search_criteria);
        $where = empty($where_arr) ? "" : "(" . join( " $search_operator ", $where_arr) . ")" ;

        $date_range_where = self::get_date_range_where($search_criteria);

        $where_and_clause_arr = array();
        if(!empty($date_range_where))
            $where_and_clause_arr[] = $date_range_where;

        $form_id_where = self::get_form_id_where($form_id);

        if(!empty($form_id_where))
            $where_and_clause_arr[] = $form_id_where;

        $status_where = isset($search_criteria["status"]) ?  $wpdb->prepare("l.status = %s", $search_criteria["status"]) : "";
        if(!empty($status_where))
            $where_and_clause_arr[] = $status_where;

        $where_and_clause = join(" AND ", $where_and_clause_arr);

        if(!empty($where_and_clause))
            $where_and_clause = "(" . $where_and_clause . ")";

        $where_parts = array();
        if(!empty($where))
            $where_parts[] = $where;
        if(!empty($where_and_clause))
            $where_parts[] = $where_and_clause;

        $where = join(" AND ", $where_parts);

        if(!empty($where))
            $where = "WHERE " . $where;

        return $where;
    }

    private static function get_field_filters_where($form_id, $search_criteria) {
        global $wpdb;

        $field_filters = rgar($search_criteria, "field_filters");

        $search_operator = self::get_search_operator($search_criteria);

        if(empty($field_filters))
            return false;

        unset($field_filters["mode"]);

        $sql_array               = array();
        $lead_details_table_name = GFFormsModel::get_lead_details_table_name();
        $lead_meta_table_name    = GFFormsModel::get_lead_meta_table_name();
        if(is_array($form_id)){
            $in_str_arr = array_fill(0, count($form_id), '%s');
            $in_str     = esc_sql(join(",", $in_str_arr));
            $form_id_where = $wpdb->prepare("AND form_id IN ($in_str)", $form_id);
        } else {
            $form_id_where = $form_id > 0 ? $wpdb->prepare("AND form_id=%d", $form_id) : "";
        }
        $info_column_keys = self::get_lead_db_columns();
        $entry_meta = self::get_entry_meta(is_array($form_id) ? 0 : $form_id);
        array_push($info_column_keys, "id");
        foreach ($field_filters as $search) {

            $key = rgar($search, "key");
            if("entry_id" === $key)
                $key = "id";
            if(in_array($key, $info_column_keys))
                continue;

            $val = rgar($search, "value");
            $operator    = isset($search["operator"]) ? strtolower($search["operator"]) : "=";
            if("is" == $operator)
                $operator = "=";
            if("isnot" == $operator)
                $operator = "<>";
            if("contains" == $operator)
                $operator = "like";
            $search_term  = "like" == $operator ? "%$val%" : $val;

            $search_type = rgar($search, "type");
            if(empty($search_type)){
                if(empty($key)){
                    $search_type = "global";
                } elseif (is_numeric($key)){
                    $search_type = "field";
                } else {
                    $search_type = "meta";
                }
            }

            switch ($search_type) {
                case "field":
                    $upper_field_number_limit = (string)(int)$key === $key ? (float)$key + 0.9999 : (float)$key + 0.0001;
                    /* doesn't support "<>" for checkboxes */
                    $field_query = $wpdb->prepare("
                        l.id IN
                        (
                        SELECT
                        lead_id
                        from $lead_details_table_name
                        WHERE (field_number BETWEEN %s AND %s AND value $operator %s)
                        $form_id_where
                        )", (float)$key - 0.0001, $upper_field_number_limit, $search_term);
                    if(empty($val) || "%%" === $val || "<>" === $operator){
                        $skipped_field_query = $wpdb->prepare("
                            l.id NOT IN
                            (
                            SELECT
                            lead_id
                            from $lead_details_table_name
                            WHERE (field_number BETWEEN %s AND %s)
                            $form_id_where
                            )", (float)$key - 0.0001, $upper_field_number_limit, $search_term);
                        $field_query = "(" . $field_query . " OR " . $skipped_field_query . ")";
                    }

                    $sql_array[] = $field_query;

                    /*
                    //supports "<>" for checkboxes but it doesn't scale
                    $sql_array[] = $wpdb->prepare("l.id IN
                                    (SELECT lead_id
                                    FROM
                                        (
                                            SELECT lead_id, value
                                            FROM $lead_details_table_name
                                            WHERE form_id = %d
                                            AND (field_number BETWEEN %s AND %s)
                                            GROUP BY lead_id
                                            HAVING value $operator %s
                                        ) ld
                                    )
                                    ", $form_id, (float)$key - 0.0001, $upper_field_number_limit, $val );
                    */
                    break;
                case "global":

                    $sql_array[] = $wpdb->prepare("value $operator %s", $search_term);
                    break;
                case "meta":
                    /* doesn't support "<>" for multiple values of the same key */

                    $meta = rgar($entry_meta, $key);
                    $placeholder = rgar($meta, "is_numeric") ? "%s" : "%s";
                    $search_term = "like" == $operator ? "%$val%" : $val;
                    $sql_array[] = $wpdb->prepare("
                        l.id IN
                        (
                        SELECT
                        lead_id
                        FROM $lead_meta_table_name
                        WHERE meta_key=%s AND meta_value $operator $placeholder
                        $form_id_where
                        )", $search["key"], $search_term);
                    break;

            }

        }

        $sql = empty($sql_array) ? "" : join(" " . $search_operator . " ", $sql_array);

        return $sql;
    }

    private static function get_date_range_where($search_criteria) {
        global $wpdb;

        if(isset($search_criteria["start_date"])){
            $where_array[] = $wpdb->prepare("date_created >= %s", $search_criteria["start_date"]);
        }

        if(isset($search_criteria["end_date"])){

            $end_date = new DateTime($search_criteria["end_date"]);
            $end_datetime_str = $end_date->format('Y-m-d H:i:s');
            $end_date_str = $end_date->format('Y-m-d');

            // extend end date till the end of the day unless a time was specified. 00:00:00 is ignored.
            if($end_datetime_str == $end_date_str . " 00:00:00" ){
                $end_date =  $end_date->format('Y-m-d') . " 23:59:59";
            } else {
                $end_date =  $end_date->format('Y-m-d H:i:s');
            }

            $where_array[] = $wpdb->prepare("date_created <= %s", $end_date);
        }


        $sql = empty($where_array) ? "" : "(" . join(" AND ", $where_array) . ")";

        return $sql;
    }

    private static function get_search_operator($search_criteria){
        if(!isset($search_criteria["field_filters"]))
            return "";
        $field_filters = $search_criteria["field_filters"];

        $search_mode = isset($field_filters["mode"]) ? strtolower($field_filters["mode"]) : "all";

        return strtolower($search_mode) == "any" ? "OR" : "AND";
    }

    private static function get_lead_db_columns(){
        return array("id", "form_id", "post_id", "date_created", "is_starred", "is_read", "ip", "source_url", "user_agent", "currency", "payment_status", "payment_date", "payment_amount", "transaction_id", "is_fulfilled", "created_by", "transaction_type", "status");
    }

    private static function get_info_search_where($search_criteria) {
        global $wpdb;

        $field_filters = rgar($search_criteria, "field_filters");
        $search_operator = self::get_search_operator($search_criteria);

        if(empty($field_filters))
            return;

        unset($field_filters["mode"]);

        $info_column_keys = self::get_lead_db_columns();
        array_push($info_column_keys, "id");
        $int_columns = array("id", "post_id", "is_starred", "is_read", "is_fulfilled", "entry_id");
        $where_array = array();
        foreach ($field_filters as $filter) {
            $key = strtolower(rgar($filter, "key"));

            if("entry_id" === $key){
                $key = "id";
            }

            if(!in_array($key, $info_column_keys)){
                continue;
            }

            $operator    = isset($filter["operator"]) ? strtolower($filter["operator"]) : "=";

            $value = rgar($filter, "value");

            if("is" == $operator)
                $operator = "=";
            if("isnot" == $operator)
                $operator = "<>";
            if("contains" == $operator)
                $operator = "like";
            $search_term   = "like" == $operator ? "%value%" : $value;
            if("date_created" == $key && "=" === $operator){
                $where_array[] = $wpdb->prepare("(datediff(date_created, %s) >= 0 AND datediff(date_created, %s) <= 0)", $search_term, $search_term);
            }else if(in_array($key, $int_columns)){
                $where_array[] = $wpdb->prepare("l.{$key} $operator %d", $search_term);
            } else {
                $where_array[] = $wpdb->prepare("l.{$key} $operator %s", $search_term);
            }

        }


        $sql = empty($where_array) ? "" : join(" $search_operator ", $where_array);

        return $sql;
    }

    public static function count_search_leads($form_id, $search_criteria = array()) {
        global $wpdb;

        $detail_table_name = GFFormsModel::get_lead_details_table_name();
        $lead_table_name   = GFFormsModel::get_lead_table_name();

        $where = self::get_search_where($form_id, $search_criteria);

        $sql = "SELECT count(distinct l.id)
                FROM $lead_table_name l
                INNER JOIN $detail_table_name ld ON l.id = ld.lead_id
                $where
                ";

        return $wpdb->get_var($sql);
    }

    public static function get_lead_count_all_forms($status='active'){
		global $wpdb;

	    $detail_table_name = self::get_lead_details_table_name();
	    $lead_table_name = self::get_lead_table_name();

	    $sql = "SELECT count(id)
	            FROM $lead_table_name
	            WHERE status='{$status}'";

	     return $wpdb->get_var($sql);
	}

    public static function dbDelta($sql){
        global $wpdb;

        require_once(ABSPATH . '/wp-admin/includes/upgrade.php');

        //Fixes issue with dbDelta lower-casing table names, which cause problems on case sensitive DB servers.
        add_filter( 'dbdelta_create_queries', array("GFForms", "dbdelta_fix_case"));

        dbDelta($sql);

        remove_filter('dbdelta_create_queries', array("GFForms", "dbdelta_fix_case"));
    }

    public static function get_db_charset(){
        global $wpdb;

        if ( ! empty($wpdb->charset) )
            $charset_collate = "DEFAULT CHARACTER SET $wpdb->charset";

        if ( ! empty($wpdb->collate) )
            $charset_collate .= " COLLATE $wpdb->collate";

        return $charset_collate;
    }

    /**
     * Trims values inside choice texts, choice values, input labels, field labels and field conditionalLogic
     *
     * @param array $form Form object.
     * @param bool $form_updated Output parameter.
     * @return array $form
     */
    public static function trim_form_meta_values($form, &$form_updated = false){
        $form_id = $form["id"];
        GFCommon::log_debug("Starting GFFormsModel::trim_form_meta_values()");
        if(isset($form["fields"]) && is_array($form["fields"])){
            foreach($form["fields"] as &$field){
                $trim_value = apply_filters("gform_trim_input_value", true, $form_id, $field);
                if(!$trim_value){
                    continue;
                }

                if(isset($field["label"]) && $field["label"] != trim($field["label"])){
                    $field["label"] = trim($field["label"]);
                    $form_updated = true;
                }
                if(isset($field["choices"]) && is_array($field["choices"])){
                    foreach($field["choices"] as &$choice){
                        if(isset($choice["text"]) && $choice["text"] != trim($choice["text"])){
                            $choice["text"] = trim($choice["text"]);
                            $form_updated = true;
                        }
                        if(isset($choice["value"]) && $choice["value"] != trim($choice["value"])){
                            $choice["value"] = trim($choice["value"]);
                            $form_updated = true;
                        }
                    }
                }
                if(isset($field["inputs"]) && is_array($field["inputs"])){
                    foreach($field["inputs"] as &$input){
                        if(isset($input["label"]) && $input["label"] != trim($input["label"])){
                            $input["label"] = trim($input["label"]);
                            $form_updated = true;
                        }
                    }
                }
            }
            $form["fields"] = GFFormsModel::trim_conditional_logic_values($form["fields"], $form, $form_updated);
        }
        if($form_updated){
            GFCommon::log_debug("Trimmed form values");
        }
        return $form;
    }

    /**
     * Trims values from an array of elements e.g. notifications and confirmations
     *
     * @param array $meta_array Form object.
     * @param array $form Form object.
     * @param bool $updated Output parameter.
     * @return array $meta_array
     */
    public static function trim_conditional_logic_values($meta_array, $form, &$updated = false){
        GFCommon::log_debug("Starting GFFormsModel::trim_conditional_logic_values()");
        if(is_array($meta_array)){
            foreach($meta_array as &$meta){
                $meta = self::trim_conditional_logic_values_from_element($meta, $form, $updated);
            }
        }
        if($updated){
            GFCommon::log_debug("Trimmed conditional logic values");
        }
        return $meta_array;
    }

    /**
     * Trims values from elements e.g. fields, notifications and confirmations
     *
     * @param array $element Form object.
     * @param array $form Form object.
     * @param bool $updated Output parameter.
     * @return array $element
     */
    public static function trim_conditional_logic_values_from_element($element, $form = array(), &$updated = false){
        if(isset($element["conditionalLogic"]) && is_array($element["conditionalLogic"]) && isset($element["conditionalLogic"]["rules"]) && is_array($element["conditionalLogic"]["rules"])){
            foreach($element["conditionalLogic"]["rules"] as &$rule){
                $value = (string) $rule["value"];
                if($value !== trim($value)){
                    $field = isset($form["fields"]) ? GFFormsModel::get_field($form, $rule["fieldId"]) : array();
                    $trim_value = apply_filters("gform_trim_input_value", true, rgar($form, "id"), $field);
                    if($trim_value){
                        $rule["value"] = trim($rule["value"]);
                        $updated = true;
                    }

                }
            }
        }
        return $element;
    }

    public static function get_encrypted_fields( $entry_id ) {

        $encrypted_fields = gform_get_meta( $entry_id, '_encrypted_fields' );
        if( empty( $encrypted_fields ) )
            $encrypted_fields = array();

        return $encrypted_fields;
    }

    public static function set_encrypted_fields( $entry_id, $field_ids ) {

        if( ! is_array( $field_ids ) )
            $field_ids = array( $field_ids );

        $encrypted_fields = array_merge( self::get_encrypted_fields( $entry_id ), $field_ids );

        gform_update_meta( $entry_id, '_encrypted_fields', $encrypted_fields );

        return true;
    }

    public static function is_encrypted_field( $entry_id, $field_id ) {
        $encrypted_fields = self::get_encrypted_fields( $entry_id );
        return in_array( $field_id, $encrypted_fields );
    }

}

class RGFormsModel extends GFFormsModel { }

global $_gform_lead_meta;
$_gform_lead_meta = array();

//functions to handle lead meta
function gform_get_meta($entry_id, $meta_key){
    global $wpdb, $_gform_lead_meta;

    //get from cache if available
    $cache_key = $entry_id . "_" . $meta_key;
    if(array_key_exists($cache_key, $_gform_lead_meta))
        return $_gform_lead_meta[$cache_key];

    $table_name = RGFormsModel::get_lead_meta_table_name();
    $results = $wpdb->get_results($wpdb->prepare("SELECT meta_value FROM {$table_name} WHERE lead_id=%d AND meta_key=%s", $entry_id, $meta_key));
    $value = isset($results[0]) ? $results[0]->meta_value : null;
    $meta_value = $value == null ? false : maybe_unserialize($value);
    $_gform_lead_meta[$cache_key] = $meta_value;
    return $meta_value;
}

function gform_get_meta_values_for_entries($entry_ids, $meta_keys){
    global $wpdb;

    if (empty($meta_keys) || empty($entry_ids))
        return array();

    $table_name = RGFormsModel::get_lead_meta_table_name();
    $meta_value_array = array();
    $select_meta_keys = join(",", $meta_keys);
    $meta_key_select_array = array();

    foreach($meta_keys as $meta_key){
        $meta_key_select_array[] = "max(case when meta_key = '$meta_key' then meta_value end) as $meta_key";
    }

    $entry_ids_str = join(",", $entry_ids);

    $meta_key_select = join(",", $meta_key_select_array);

    $sql_query = "  SELECT
                    lead_id, $meta_key_select
                    FROM $table_name
                    WHERE lead_id IN ($entry_ids_str)
                    GROUP BY lead_id";

    $results = $wpdb->get_results($sql_query);

    foreach($results as $result){
        foreach($meta_keys as $meta_key){
            $result->$meta_key = $result->$meta_key == null ? false : maybe_unserialize($result->$meta_key);
        }
    }

    $meta_value_array = $results;
    return $meta_value_array;
}

function gform_update_meta($entry_id, $meta_key, $meta_value){
    global $wpdb, $_gform_lead_meta;
    $table_name = RGFormsModel::get_lead_meta_table_name();
	if (false === $meta_value)
         $meta_value = "0";
    $meta_value = maybe_serialize($meta_value);
    $meta_exists = gform_get_meta($entry_id, $meta_key) !== false;
    if($meta_exists){
        $wpdb->update($table_name, array("meta_value" => $meta_value), array("lead_id" => $entry_id, "meta_key" => $meta_key),array("%s"), array("%d", "%s"));
    }
    else{
        $lead_table_name = RGFormsModel::get_lead_table_name();
		$form_id = $wpdb->get_var($wpdb->prepare("SELECT form_id from $lead_table_name WHERE id=%d", $entry_id));
		$wpdb->insert($table_name, array("form_id" => $form_id, "lead_id" => $entry_id, "meta_key" => $meta_key, "meta_value" => $meta_value), array("%d", "%d", "%s", "%s"));
    }

    //updates cache
    $cache_key = $entry_id . "_" . $meta_key;
    if(array_key_exists($cache_key, $_gform_lead_meta))
        $_gform_lead_meta[$cache_key] = maybe_unserialize($meta_value);
}

function gform_delete_meta($entry_id, $meta_key=""){
    global $wpdb, $_gform_lead_meta;
    $table_name = RGFormsModel::get_lead_meta_table_name();
    $meta_filter = empty($meta_key) ? "" : $wpdb->prepare("AND meta_key=%s", $meta_key);

    $wpdb->query($wpdb->prepare("DELETE FROM {$table_name} WHERE lead_id=%d {$meta_filter}", $entry_id));

    //clears cache.
    $_gform_lead_meta = array();
}

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en-US">
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=UTF-8" />
<title>
Syllabus  @  EEcc Foundation</title>
<link rel="alternate" type="application/rss+xml" title="EEcc Foundation RSS" href="http://eccfoundation.in/feed/" />
<link rel="pingback" href="http://eccfoundation.in/xmlrpc.php" />
<link rel='dns-prefetch' href='//s.w.org' />
<link rel="alternate" type="application/rss+xml" title="EEcc Foundation &raquo; Feed" href="http://eccfoundation.in/feed/" />
<link rel="alternate" type="application/rss+xml" title="EEcc Foundation &raquo; Comments Feed" href="http://eccfoundation.in/comments/feed/" />
<link rel="alternate" type="text/calendar" title="EEcc Foundation &raquo; iCal Feed" href="http://eccfoundation.in/events/?ical=1" />
<link rel="alternate" type="application/rss+xml" title="EEcc Foundation &raquo; Syllabus Comments Feed" href="http://eccfoundation.in/syllabus/feed/" />
<!-- <link rel='stylesheet' id='wp-block-library-css'  href='http://eccfoundation.in/wp-includes/css/dist/block-library/style.min.css?ver=5.0.8' type='text/css' media='all' /> -->
<!-- <link rel='stylesheet' id='wpsl-styles-css'  href='http://eccfoundation.in/wp-content/plugins/wp-store-locator/css/styles.min.css?ver=2.2.13' type='text/css' media='all' /> -->
<!-- <link rel='stylesheet' id='pexeto-pretty-photo-css'  href='http://eccfoundation.in/wp-content/themes/dandelion/css/prettyPhoto.css?ver=3.0.0' type='text/css' media='all' /> -->
<!-- <link rel='stylesheet' id='pexeto-superfish-css'  href='http://eccfoundation.in/wp-content/themes/dandelion/css/superfish.css?ver=3.0.0' type='text/css' media='all' /> -->
<!-- <link rel='stylesheet' id='pexeto-nivo-slider-css'  href='http://eccfoundation.in/wp-content/themes/dandelion/css/nivo-slider.css?ver=3.0.0' type='text/css' media='all' /> -->
<!-- <link rel='stylesheet' id='pexeto-stylesheet-css'  href='http://eccfoundation.in/wp-content/themes/dandelion/style.css?ver=3.0.0' type='text/css' media='all' /> -->
<link rel="stylesheet" type="text/css" href="//eccfoundation.in/wp-content/cache/wpfc-minified/4ef3276a0528a99843e6900b2e54e85f/1582713110index.css" media="all"/>
<!-- <link rel='stylesheet' id='pexeto-responsive-css'  href='http://eccfoundation.in/wp-content/themes/dandelion/css/responsive.css?ver=3.0.0' type='text/css' media='(min-width:0px)' /> -->
<link rel="stylesheet" type="text/css" href="//eccfoundation.in/wp-content/cache/wpfc-minified/2082681e42bc1662112d81ff97d9358d/1582713110index.css" media="(min-width:0px)"/>
<!-- <link rel='stylesheet' id='msl-main-css'  href='http://eccfoundation.in/wp-content/plugins/master-slider/public/assets/css/masterslider.main.css?ver=3.4.1' type='text/css' media='all' /> -->
<!-- <link rel='stylesheet' id='msl-custom-css'  href='http://eccfoundation.in/wp-content/uploads/master-slider/custom.css?ver=1.2' type='text/css' media='all' /> -->
<link rel="stylesheet" type="text/css" href="//eccfoundation.in/wp-content/cache/wpfc-minified/8a3e2492d57362abbbe94f451ede9518/1582713788index.css" media="all"/>
<script src='//eccfoundation.in/wp-content/cache/wpfc-minified/ba038029b620512a6343f5f792728946/1582964685index.js' type="text/javascript"></script>
<!-- <script type='text/javascript' src='http://eccfoundation.in/wp-includes/js/jquery/jquery.js?ver=1.12.4'></script> -->
<!-- <script type='text/javascript' src='http://eccfoundation.in/wp-includes/js/jquery/jquery-migrate.min.js?ver=1.4.1'></script> -->
<!-- <script type='text/javascript' src='http://eccfoundation.in/wp-content/themes/dandelion/script/jquery.prettyPhoto.js?ver=3.0.0'></script> -->
<!-- <script type='text/javascript' src='http://eccfoundation.in/wp-content/themes/dandelion/script/jquery.tools.min.js?ver=3.0.0'></script> -->
<!-- <script type='text/javascript' src='http://eccfoundation.in/wp-content/themes/dandelion/script/script.js?ver=3.0.0'></script> -->
<!-- <script type='text/javascript' src='http://eccfoundation.in/wp-content/themes/dandelion/script/cufon-yui.js?ver=5.0.8'></script> -->
<!-- <script type='text/javascript' src='http://eccfoundation.in/wp-content/themes/dandelion/script/fonts/andika.js?ver=5.0.8'></script> -->
<link rel='https://api.w.org/' href='http://eccfoundation.in/wp-json/' />
<link rel="EditURI" type="application/rsd+xml" title="RSD" href="http://eccfoundation.in/xmlrpc.php?rsd" />
<link rel="wlwmanifest" type="application/wlwmanifest+xml" href="http://eccfoundation.in/wp-includes/wlwmanifest.xml" /> 
<meta name="generator" content="WordPress 5.0.8" />
<link rel="canonical" href="http://eccfoundation.in/syllabus/" />
<link rel='shortlink' href='http://eccfoundation.in/?p=38' />
<link rel="alternate" type="application/json+oembed" href="http://eccfoundation.in/wp-json/oembed/1.0/embed?url=http%3A%2F%2Feccfoundation.in%2Fsyllabus%2F" />
<link rel="alternate" type="text/xml+oembed" href="http://eccfoundation.in/wp-json/oembed/1.0/embed?url=http%3A%2F%2Feccfoundation.in%2Fsyllabus%2F&#038;format=xml" />
<script>var ms_grabbing_curosr = 'http://eccfoundation.in/wp-content/plugins/master-slider/public/assets/css/common/grabbing.cur', ms_grab_curosr = 'http://eccfoundation.in/wp-content/plugins/master-slider/public/assets/css/common/grab.cur';</script>
<meta name="generator" content="MasterSlider 3.4.1 - Responsive Touch Image Slider | avt.li/msf" />
<!-- <meta name="NextGEN" version="2.2.54" /> -->
<meta name="tec-api-version" content="v1"><meta name="tec-api-origin" content="http://eccfoundation.in"><link rel="https://theeventscalendar.com/" href="http://eccfoundation.in/wp-json/tribe/events/v1/" />
<!-- Jetpack Open Graph Tags -->
<meta property="og:type" content="article" />
<meta property="og:title" content="Syllabus" />
<meta property="og:url" content="http://eccfoundation.in/syllabus/" />
<meta property="og:description" content="Nursery Tearcher Traning Course First Year Syllabus:- Click Here For dowload the Syllabus &#8212;&#8212; One Year Theory Papers (COMPULSORY) Marks 1: (a) Child Psychology (b) Early Child Hood Care …" />
<meta property="article:published_time" content="2014-07-21T05:44:34+00:00" />
<meta property="article:modified_time" content="2014-08-17T09:25:23+00:00" />
<meta property="og:site_name" content="EEcc Foundation" />
<meta property="og:image" content="https://s0.wp.com/i/blank.jpg" />
<meta property="og:locale" content="en_US" />
<meta name="twitter:text:title" content="Syllabus" />
<meta name="twitter:card" content="summary" />
<!-- Mobile Devices Viewport Resset-->
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=3.0">
<meta name="apple-mobile-web-app-capable" content="yes">
<script type="text/javascript">
pexetoSite.enableCufon="on";
pexetoSite.ajaxurl="http://eccfoundation.in/wp-admin/admin-ajax.php";
pexetoSite.lightboxOptions = {"theme":"light_rounded","animation_speed":"normal","overlay_gallery":false,"allow_resize":true,"enable_social_tools":false,"autoplay_slideshow":false};
pexetoSite.isResponsive = true;
jQuery(document).ready(function($){
pexetoSite.initSite();
});
</script>
<!-- enables nested comments in WP 2.7 -->
<!--[if lte IE 6]>
<link href="http://eccfoundation.in/wp-content/themes/dandelion/css/style_ie6.css" rel="stylesheet" type="text/css" />
<input type="hidden" value="http://eccfoundation.in/wp-content/themes/dandelion" id="baseurl" />
<script type="text/javascript" src="http://eccfoundation.in/wp-content/themes/dandelion/script/supersleight.js"></script>
<![endif]-->
<!--[if IE 7]>
<link href="http://eccfoundation.in/wp-content/themes/dandelion/css/style_ie7.css" rel="stylesheet" type="text/css" />
<![endif]-->
<!-- Custom Theme CSS -->
<style type="text/css">body{background-color:#88a65e;}body{background-image:url("http://eccfoundation.in/wp-content/themes/dandelion/images/patterns/pattern10.png");}</style>
<!-- <link rel='stylesheet' id='nextgen_widgets_style-css'  href='http://eccfoundation.in/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/widget/static/widgets.min.css?ver=2.2.54' type='text/css' media='all' /> -->
<!-- <link rel='stylesheet' id='nextgen_basic_thumbnails_style-css'  href='http://eccfoundation.in/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/nextgen_basic_gallery/static/thumbnails/nextgen_basic_thumbnails.min.css?ver=2.2.54' type='text/css' media='all' /> -->
<!-- <link rel='stylesheet' id='ngg_trigger_buttons-css'  href='http://eccfoundation.in/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/nextgen_gallery_display/static/trigger_buttons.min.css?ver=2.2.54' type='text/css' media='all' /> -->
<!-- <link rel='stylesheet' id='fancybox-0-css'  href='http://eccfoundation.in/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/lightbox/static/fancybox/jquery.fancybox-1.3.4.min.css?ver=2.2.54' type='text/css' media='all' /> -->
<!-- <link rel='stylesheet' id='fontawesome-css'  href='http://eccfoundation.in/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/nextgen_gallery_display/static/fontawesome/font-awesome.min.css?ver=4.6.1' type='text/css' media='all' /> -->
<!-- <link rel='stylesheet' id='nextgen_pagination_style-css'  href='http://eccfoundation.in/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/nextgen_pagination/static/style.min.css?ver=2.2.54' type='text/css' media='all' /> -->
<!-- <link rel='stylesheet' id='nggallery-css'  href='http://eccfoundation.in/wp-content/ngg_styles/nggallery.css?ver=2.2.54' type='text/css' media='all' /> -->
</head>
<body class="page-template-default page page-id-38 _masterslider _ms_version_3.4.1 tribe-no-js cufon"	<div id="main-container">
<div class="center">
<div id="site">
<div id="header" >
<div id="header-top">
<div id="logo-container" class="center">
<a href="http://eccfoundation.in">
<img src="http://eccfoundation.in/wp-content/themes/dandelion/images/ecc-logo_new.png" />
</a>
</div>
<div id="menu-container">
<div id="menu">
<div class="menu-main-menu-container"><ul id="menu-main-menu" class="menu"><li id="menu-item-5" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-home menu-item-5"><a href="http://eccfoundation.in/">Home</a></li>
<li id="menu-item-29" class="menu-item menu-item-type-custom menu-item-object-custom current-menu-ancestor current-menu-parent menu-item-has-children menu-item-29"><a href="#">About Us</a>
<ul class="sub-menu">
<li id="menu-item-43" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-43"><a href="http://eccfoundation.in/admission/">Admission</a></li>
<li id="menu-item-42" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-42"><a href="http://eccfoundation.in/duration-of-course/">Duration Of Course</a></li>
<li id="menu-item-41" class="menu-item menu-item-type-post_type menu-item-object-page current-menu-item page_item page-item-38 current_page_item menu-item-41"><a href="http://eccfoundation.in/syllabus/">Syllabus</a></li>
<li id="menu-item-138" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-138"><a href="http://eccfoundation.in/how-to-become-a-preschool-teacher/">How to become a preschool teacher</a></li>
<li id="menu-item-139" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-139"><a href="http://eccfoundation.in/role-of-preschool-teacher/">Role of Preschool Teacher</a></li>
<li id="menu-item-140" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-140"><a href="http://eccfoundation.in/benefits-of-early-childhood-education/">Benefits of early childhood education</a></li>
<li id="menu-item-141" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-141"><a href="http://eccfoundation.in/importance-of-early-childhood-education/">Importance of early childhood education</a></li>
</ul>
</li>
<li id="menu-item-28" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-28"><a href="http://eccfoundation.in/centre/">Center</a></li>
<li id="menu-item-27" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-27"><a href="http://eccfoundation.in/result/">Result</a></li>
<li id="menu-item-305" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-305"><a href="http://eccfoundation.in/gallery/">Gallery</a></li>
<li id="menu-item-26" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-26"><a href="http://eccfoundation.in/contact-us/">Contact Us</a></li>
</ul></div>							</div>
</div>
<div class="mobile-nav">
<span class="mob-nav-btn">Menu</span>
</div>
<div class="clear"></div>
<div><span class="iso">ISO  9001:2008 CERTIFIED</span></div>
</div>
<div id="page-title">
<h6></h6>
</div>
</div>
<div id="content-container" class="content-gradient  ">
<div id="content">
<!--content-->
<h1 class="page-heading">Syllabus</h1><hr/>
<p><div id="site-intro"><div id="site-intro-container"><span class="intro-swril swril-left"></span><span class="intro-text">Successfully efforts to become Professionally expert in the field of Early Childhood Education </span><span class="intro-swril swril-right"></span></div></div><br />
<strong>Nursery Tearcher Traning Course First Year Syllabus:-</strong><br />
Click Here For dowload the Syllabus &#8212;&#8212; <a href="http://eccfoundation.in/wp-content/uploads/2014/08/early-child-hood-syllabus-only-one-year.doc" target="_blank">One Year</a></p>
<table class="display" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td style="background: #333; color: #fff;" colspan="2"><b>Theory Papers (COMPULSORY)</b></td>
<td style="background: #333; color: #fff;"><b>Marks</b></td>
</tr>
<tr>
<td>1:</td>
<td>(a) Child Psychology<br />
(b) Early Child Hood Care and Health</td>
<td>100</td>
</tr>
<tr>
<td>2:</td>
<td>Socialogy and Guidence</td>
<td>100</td>
</tr>
<tr>
<td>3:</td>
<td>School Organisation</td>
<td>100</td>
</tr>
<tr>
<td>4:</td>
<td>Principles of Education</td>
<td>100</td>
</tr>
<tr>
<td>5:</td>
<td>Education Psychology</td>
<td>100</td>
</tr>
<tr>
<td>6:</td>
<td>Modem Methods of Teachers</td>
<td>100</td>
</tr>
<tr>
<td>7:</td>
<td>(a) Methods of Teachers Subjects<br />
(b) Special Methods of teaching</td>
<td>100</td>
</tr>
<tr>
<td>8:</td>
<td>Fundamental of Computer for teaching (Optional)</td>
<td>100</td>
</tr>
<tr>
<td style="background: #333; color: #fff;" colspan="2"><b> Practical Subjects (COMPULSORY)</b></td>
<td style="background: #333; color: #fff;"><b> Marks</b></td>
</tr>
<tr>
<td>1:</td>
<td>Lesson Plan and Teaching</td>
<td>100</td>
</tr>
<tr>
<td>2:</td>
<td>Art &amp; Craft</td>
<td>100</td>
</tr>
<tr>
<td>3:</td>
<td>Art File &amp; Plan Book</td>
<td>100</td>
</tr>
<tr>
<td>4:</td>
<td>Preparation of Teaching Aids</td>
<td>100</td>
</tr>
<tr>
<td>5:</td>
<td>Recitation of Hindi &amp; English Rhymes, Patriotic Songs<br />
(with action) Delivery of Speech &amp; Story Telling</td>
<td>100</td>
</tr>
<tr>
<td>6:</td>
<td>Viva</td>
<td>100</td>
</tr>
<tr>
<td>7:</td>
<td>Internal Award(based on the overall performance and<br />
Behavior in the class for whole of the year</td>
<td>100</td>
</tr>
<tr>
<td>8:</td>
<td>Computer Practical/Abacus(based on the theory paper-8th) (Optional)</td>
<td>100</td>
</tr>
</tbody>
</table>
</div> <!-- end content-->
<div class="sidebar">
<div class="sidebar-box gform_widget" id="gform_widget-2"><h4>Enquiry Form</h4><!-- <link rel='stylesheet' id='gforms_reset_css-css'  href='http://eccfoundation.in/wp-content/plugins/gravityforms/css/formreset.css?ver=1.8.9' type='text/css' media='all' /> -->
<!-- <link rel='stylesheet' id='gforms_formsmain_css-css'  href='http://eccfoundation.in/wp-content/plugins/gravityforms/css/formsmain.css?ver=1.8.9' type='text/css' media='all' /> -->
<!-- <link rel='stylesheet' id='gforms_ready_class_css-css'  href='http://eccfoundation.in/wp-content/plugins/gravityforms/css/readyclass.css?ver=1.8.9' type='text/css' media='all' /> -->
<!-- <link rel='stylesheet' id='gforms_browsers_css-css'  href='http://eccfoundation.in/wp-content/plugins/gravityforms/css/browsers.css?ver=1.8.9' type='text/css' media='all' /> -->
<link rel="stylesheet" type="text/css" href="//eccfoundation.in/wp-content/cache/wpfc-minified/6e76b33e7528bd4a0f08137c41ed7965/1582713797index.css" media="all"/>
<script type='text/javascript' src='http://eccfoundation.in/wp-content/plugins/gravityforms/js/jquery.json-1.3.js?ver=1.8.9'></script>
<script type='text/javascript' src='http://eccfoundation.in/wp-content/plugins/gravityforms/js/jquery.placeholders.2.1.1.min.js?ver=1.8.9'></script>
<script type='text/javascript' src='http://eccfoundation.in/wp-content/plugins/gravityforms/js/gravityforms.js?ver=1.8.9'></script>
<script type="text/javascript"> var gf_global = {"gf_currency_config":{"name":"U.S. Dollar","symbol_left":"$","symbol_right":"","symbol_padding":"","thousand_separator":",","decimal_separator":".","decimals":2},"base_url":"http:\/\/eccfoundation.in\/wp-content\/plugins\/gravityforms","number_formats":[],"spinnerUrl":"http:\/\/eccfoundation.in\/wp-content\/plugins\/gravityforms\/images\/spinner.gif"}; </script>
<div class='gf_browser_unknown gform_wrapper' id='gform_wrapper_2' ><a id='gf_2' name='gf_2' class='gform_anchor' ></a><form method='post' enctype='multipart/form-data' target='gform_ajax_frame_2' id='gform_2'  action='/syllabus/#gf_2'>
<div class='gform_body'>
<ul id='gform_fields_2' class='gform_fields top_label description_below'><li id='field_2_1' class='gfield               gfield_contains_required' ><label class='gfield_label' for='input_2_1'>Name:<span class='gfield_required'>*</span></label><div class='ginput_container'><input name='input_1' id='input_2_1' type='text' value='' class='medium'  tabindex='1'   /></div></li><li id='field_2_3' class='gfield' ><label class='gfield_label' for='input_2_3'>Phone</label><div class='ginput_container'><input name='input_3' id='input_2_3' type='text' value='' class='medium' tabindex='2'  /></div></li><li id='field_2_4' class='gfield' ><label class='gfield_label' for='input_2_4'>Email</label><div class='ginput_container'><input name='input_4' id='input_2_4' type='text' value='' class='medium'  tabindex='3'   /></div></li><li id='field_2_5' class='gfield' ><label class='gfield_label' for='input_2_5'>Description:</label><div class='ginput_container'><textarea name='input_5' id='input_2_5' class='textarea medium' tabindex='4'   rows='10' cols='50'></textarea></div></li>
</ul></div>
<div class='gform_footer top_label'> <input type='submit' id='gform_submit_button_2' class='button gform_button' value='Submit' tabindex='5' onclick='if(window["gf_submitting_2"]){return false;}  window["gf_submitting_2"]=true; '/><input type='hidden' name='gform_ajax' value='form_id=2&amp;title=&amp;description=&amp;tabindex=1' />
<input type='hidden' class='gform_hidden' name='is_submit_2' value='1' />
<input type='hidden' class='gform_hidden' name='gform_submit' value='2' />
<input type='hidden' class='gform_hidden' name='gform_unique_id' value='' />
<input type='hidden' class='gform_hidden' name='state_2' value='WyJbXSIsImJiMzYzOTU5OGY4YmI2Yjk2M2Y5OTA1YTE3OTg4NDljIl0=' />
<input type='hidden' class='gform_hidden' name='gform_target_page_number_2' id='gform_target_page_number_2' value='0' />
<input type='hidden' class='gform_hidden' name='gform_source_page_number_2' id='gform_source_page_number_2' value='1' />
<input type='hidden' name='gform_field_values' value='' />
</div>
</form>
</div>
<iframe style='display:none;width:0px;height:0px;' src='about:blank' name='gform_ajax_frame_2' id='gform_ajax_frame_2'></iframe>
<script type='text/javascript'>jQuery(document).ready(function($){gformInitSpinner( 2, 'http://eccfoundation.in/wp-content/plugins/gravityforms/images/spinner.gif' );jQuery('#gform_ajax_frame_2').load( function(){var contents = jQuery(this).contents().find('*').html();var is_postback = contents.indexOf('GF_AJAX_POSTBACK') >= 0;if(!is_postback){return;}var form_content = jQuery(this).contents().find('#gform_wrapper_2');var is_redirect = contents.indexOf('gformRedirect(){') >= 0;var is_form = !(form_content.length <= 0 || is_redirect);if(is_form){jQuery('#gform_wrapper_2').html(form_content.html());jQuery(document).scrollTop(jQuery('#gform_wrapper_2').offset().top);if(window['gformInitDatepicker']) {gformInitDatepicker();}if(window['gformInitPriceFields']) {gformInitPriceFields();}var current_page = jQuery('#gform_source_page_number_2').val();gformInitSpinner( 2, 'http://eccfoundation.in/wp-content/plugins/gravityforms/images/spinner.gif' );jQuery(document).trigger('gform_page_loaded', [2, current_page]);window['gf_submitting_2'] = false;}else if(!is_redirect){var confirmation_content = jQuery(this).contents().find('#gforms_confirmation_message').html();if(!confirmation_content){confirmation_content = contents;}setTimeout(function(){jQuery('#gform_wrapper_2').replaceWith('<' + 'div id=\'gforms_confirmation_message\' class=\'gform_confirmation_message_2\'' + '>' + confirmation_content + '<' + '/div' + '>');jQuery(document).scrollTop(jQuery('#gforms_confirmation_message').offset().top);jQuery(document).trigger('gform_confirmation_loaded', [2]);window['gf_submitting_2'] = false;}, 50);}else{jQuery('#gform_2').append(contents);if(window['gformRedirect']) {gformRedirect();}}jQuery(document).trigger('gform_post_render', [2, current_page]);} );} );</script><script type='text/javascript'> jQuery(document).ready(function(){jQuery(document).trigger('gform_post_render', [2, 1]) } ); </script></div><div class="sidebar-box ngg_images" id="ngg-images-2"><div class="hslice" id="ngg-webslice"><h4>Gallery</h4><div class="ngg-widget entry-content">
<a href="http://eccfoundation.in/wp-content/gallery/first/DSC00413.JPG"
title=" "
data-image-id='2'
class="ngg-fancybox" rel="a433fc35d49efdd30b5b094e4a153d50"           ><img title="DSC00413"
alt="DSC00413"
src="http://eccfoundation.in/wp-content/gallery/first/thumbs/thumbs_DSC00413.JPG"
width="100"
height="75"
/></a>
<a href="http://eccfoundation.in/wp-content/gallery/08/DSC00101-1024x768.jpg"
title=" "
data-image-id='4'
class="ngg-fancybox" rel="a433fc35d49efdd30b5b094e4a153d50"           ><img title="DSC00101-1024x768"
alt="DSC00101-1024x768"
src="http://eccfoundation.in/wp-content/gallery/08/thumbs/thumbs_DSC00101-1024x768.jpg"
width="100"
height="75"
/></a>
<a href="http://eccfoundation.in/wp-content/gallery/08/DSC00103.jpg"
title=" "
data-image-id='17'
class="ngg-fancybox" rel="a433fc35d49efdd30b5b094e4a153d50"           ><img title="DSC00103"
alt="DSC00103"
src="http://eccfoundation.in/wp-content/gallery/08/thumbs/thumbs_DSC00103.jpg"
width="100"
height="75"
/></a>
<a href="http://eccfoundation.in/wp-content/gallery/08/DSC00105.jpg"
title=" "
data-image-id='25'
class="ngg-fancybox" rel="a433fc35d49efdd30b5b094e4a153d50"           ><img title="DSC00105"
alt="DSC00105"
src="http://eccfoundation.in/wp-content/gallery/08/thumbs/thumbs_DSC00105.jpg"
width="100"
height="75"
/></a>
<a href="http://eccfoundation.in/wp-content/gallery/08/DSC00109.jpg"
title=" "
data-image-id='41'
class="ngg-fancybox" rel="a433fc35d49efdd30b5b094e4a153d50"           ><img title="DSC00109"
alt="DSC00109"
src="http://eccfoundation.in/wp-content/gallery/08/thumbs/thumbs_DSC00109.jpg"
width="100"
height="75"
/></a>
<a href="http://eccfoundation.in/wp-content/gallery/08/DSC00112.jpg"
title=" "
data-image-id='53'
class="ngg-fancybox" rel="a433fc35d49efdd30b5b094e4a153d50"           ><img title="DSC00112"
alt="DSC00112"
src="http://eccfoundation.in/wp-content/gallery/08/thumbs/thumbs_DSC00112.jpg"
width="100"
height="75"
/></a>
</div>
</div></div><div class="sidebar-box widget_text" id="text-3">			<div class="textwidget"><a href="/gallery/">Click Here For full Gallery...</a></div>
</div></div>
<div class="clear"></div>
</div> <!-- end #content-container-->
  <div id="footer-container">
<div id="footer">
<div id="footer-columns">
<div class="four-columns">
</div>
<div class="four-columns">
</div>
<div class="four-columns">
<div class="footer-widget widget_text" id="text-2"><h4>About Us</h4>			<div class="textwidget">Successfully efforts to become Professionally expert in the field of Early Childhood Education</div>
</div></div>
<div class="four-columns-4">
</div>
</div>
</div>
</div>
<div id="copyrights">
<h5>Copyright &copy;Manvendra Pratap Singh Contact No.8565815302 For any type of software and Websites</h5>
</div>
<!-- FOOTER ENDS -->
</div>
</div>
</div>
<!-- ngg_resource_manager_marker --><script type='text/javascript' src='http://eccfoundation.in/wp-includes/js/comment-reply.min.js?ver=5.0.8'></script>
<script type='text/javascript' src='http://eccfoundation.in/wp-includes/js/wp-embed.min.js?ver=5.0.8'></script>
<script type='text/javascript'>
/* <![CDATA[ */
var photocrati_ajax = {"url":"http:\/\/eccfoundation.in\/?photocrati_ajax=1","wp_home_url":"http:\/\/eccfoundation.in","wp_site_url":"http:\/\/eccfoundation.in","wp_root_url":"http:\/\/eccfoundation.in","wp_plugins_url":"http:\/\/eccfoundation.in\/wp-content\/plugins","wp_content_url":"http:\/\/eccfoundation.in\/wp-content","wp_includes_url":"http:\/\/eccfoundation.in\/wp-includes\/","ngg_param_slug":"nggallery"};
/* ]]> */
</script>
<script type='text/javascript' src='http://eccfoundation.in/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/ajax/static/ajax.min.js?ver=2.2.54'></script>
<script type='text/javascript'>
/* <![CDATA[ */
var galleries = {};
galleries.gallery_a433fc35d49efdd30b5b094e4a153d50 = {"id":null,"source":"random_images","container_ids":[],"gallery_ids":[],"album_ids":[],"tag_ids":[],"display_type":"photocrati-nextgen_basic_thumbnails","exclusions":[],"order_by":"sortorder","order_direction":"ASC","image_ids":[],"entity_ids":[],"tagcloud":false,"returns":"included","slug":"widget-ngg-images-2","sortorder":[],"display_settings":{"override_thumbnail_settings":"0","thumbnail_width":"120","thumbnail_height":"90","thumbnail_crop":"1","images_per_page":6,"number_of_columns":"0","ajax_pagination":"0","show_all_in_lightbox":false,"use_imagebrowser_effect":false,"show_piclens_link":"0","piclens_link_text":"[Show PicLens]","show_slideshow_link":false,"slideshow_link_text":"[Show slideshow]","template":"\/home3\/eccfound\/public_html\/wp-content\/plugins\/nextgen-gallery\/products\/photocrati_nextgen\/modules\/widget\/templates\/display_gallery.php","use_lightbox_effect":true,"display_no_images_error":1,"disable_pagination":true,"thumbnail_quality":"100","thumbnail_watermark":0,"ngg_triggers_display":"never","_errors":[],"maximum_entity_count":6,"image_type":"thumb","show_thumbnail_link":false,"image_width":100,"image_height":75,"widget_setting_title":"Gallery","widget_setting_before_widget":"<div class=\"sidebar-box ngg_images\" id=\"ngg-images-2\"><div class=\"hslice\" id=\"ngg-webslice\">","widget_setting_before_title":"<h4>","widget_setting_after_widget":"<\/div><\/div>","widget_setting_after_title":"<\/h4>","widget_setting_width":100,"widget_setting_height":75,"widget_setting_show_setting":"thumbnail","widget_setting_widget_id":"ngg-images-2"},"excluded_container_ids":[],"maximum_entity_count":6,"__defaults_set":true,"variation":3,"_errors":[],"ID":"a433fc35d49efdd30b5b094e4a153d50"};
galleries.gallery_a433fc35d49efdd30b5b094e4a153d50.wordpress_page_root = "http:\/\/eccfoundation.in\/syllabus\/";
var nextgen_lightbox_settings = {"static_path":"http:\/\/eccfoundation.in\/wp-content\/plugins\/nextgen-gallery\/products\/photocrati_nextgen\/modules\/lightbox\/static","context":"nextgen_images"};
/* ]]> */
</script>
<script type='text/javascript' src='http://eccfoundation.in/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/nextgen_gallery_display/static/common.min.js?ver=2.2.54'></script>
<script type='text/javascript' src='http://eccfoundation.in/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/nextgen_basic_gallery/static/thumbnails/nextgen_basic_thumbnails.min.js?ver=2.2.54'></script>
<script type='text/javascript' src='http://eccfoundation.in/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/lightbox/static/lightbox_context.min.js?ver=2.2.54'></script>
<script type='text/javascript' src='http://eccfoundation.in/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/lightbox/static/fancybox/jquery.easing-1.3.pack.js?ver=2.2.54'></script>
<script type='text/javascript' src='http://eccfoundation.in/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/lightbox/static/fancybox/jquery.fancybox-1.3.4.pack.js?ver=2.2.54'></script>
<script type='text/javascript' src='http://eccfoundation.in/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/lightbox/static/fancybox/nextgen_fancybox_init.min.js?ver=2.2.54'></script>
<script>
( function ( body ) {
'use strict';
body.className = body.className.replace( /\btribe-no-js\b/, 'tribe-js' );
} )( document.body );
</script>
<script type='text/javascript'> /* <![CDATA[ */var tribe_l10n_datatables = {"aria":{"sort_ascending":": activate to sort column ascending","sort_descending":": activate to sort column descending"},"length_menu":"Show _MENU_ entries","empty_table":"No data available in table","info":"Showing _START_ to _END_ of _TOTAL_ entries","info_empty":"Showing 0 to 0 of 0 entries","info_filtered":"(filtered from _MAX_ total entries)","zero_records":"No matching records found","search":"Search:","all_selected_text":"All items on this page were selected. ","select_all_link":"Select all pages","clear_selection":"Clear Selection.","pagination":{"all":"All","next":"Next","previous":"Previous"},"select":{"rows":{"0":"","_":": Selected %d rows","1":": Selected 1 row"}},"datepicker":{"dayNames":["Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"],"dayNamesShort":["Sun","Mon","Tue","Wed","Thu","Fri","Sat"],"dayNamesMin":["S","M","T","W","T","F","S"],"monthNames":["January","February","March","April","May","June","July","August","September","October","November","December"],"monthNamesShort":["January","February","March","April","May","June","July","August","September","October","November","December"],"nextText":"Next","prevText":"Prev","currentText":"Today","closeText":"Done"}};/* ]]> */ </script></body>
</html><!-- WP Fastest Cache file was created in 2.0723121166229 seconds, on 29-02-20 13:38:04 --><!-- via php -->