/plugins/gravityforms/forms_model.php
PHP | 3720 lines | 2872 code | 638 blank | 210 comment | 482 complexity | a0de73cf64abd8d521dc89e16c2e2edb MD5 | raw file
Possible License(s): GPL-3.0
Large files files are truncated, but you can click here to view the full file
- <?php
- require_once(ABSPATH . "/wp-includes/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="title ASC"){
- 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();
- $active_clause = $is_active !== null ? $wpdb->prepare("WHERE is_active=%d", $is_active) : "";
- $order_by = !empty($sort) ? "ORDER BY $sort" : "";
- $sql = "SELECT f.id, f.title, f.date_created, f.is_active, 0 as lead_count, 0 view_count
- FROM $form_table_name f
- $active_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 count(0) as count FROM $form_table_name UNION ALL SELECT count(0) as count FROM $form_table_name WHERE is_active=1 ");
- return array( "total" => intval($results[0]->count),
- "active" => intval($results[1]->count),
- "inactive" => intval($results[0]->count) - intval($results[1]->count)
- );
- }
- 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){
- global $wpdb;
- $table_name = self::get_form_table_name();
- $results = $wpdb->get_results($wpdb->prepare("SELECT * FROM $table_name WHERE id=%d", $form_id));
- return $results[0];
- }
- 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
- $form = maybe_unserialize($form_row["display_meta"]);
- if(!$form)
- return null;
- //loading notifications
- $form["notifications"] = maybe_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["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 = maybe_unserialize($result["display_meta"]);
- $form['confirmations'] = maybe_unserialize($result["confirmations"]);
- $form['notifications'] = maybe_unserialize($result["notifications"]);
- $result = $form;
- }
- return $results;
- }
- private static function load_notifications_to_legacy($form){
- if(!is_array(rgar($form, "notifications")))
- return;
- 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_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
- $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);
- }
- }
- }
- public static function update_lead($lead){
- 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";
- $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},
- status='{$status}'
- WHERE id=%d", rgar($lead,"form_id"), rgar($lead,"post_id"), rgar($lead,"is_starred"), rgar($lead,"is_read"), rgar($lead,"ip"), rgar($lead,"source_url"), rgar($lead,"user_agent"),
- rgar($lead,"currency"), rgar($lead,"payment_status"), rgar($lead,"transaction_id"), rgar($lead,"is_fulfilled"), rgar($lead,"id"));
- $wpdb->query($sql);
- self::set_current_lead($lead);
- }
- 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 delete_leads_by_form($form_id, $status=""){
- global $wpdb;
- if(!GFCommon::current_user_can_any("gravityforms_delete_entries"))
- die(__("You don't have adequate permission to delete entries.", "gravityforms"));
- $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_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;
- if(!GFCommon::current_user_can_any("gravityforms_delete_forms"))
- die(__("You don't have adequate permission to delete forms.", "gravityforms"));
- 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 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;
- self::update_form_meta($new_id, $meta);
- 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){
- GFForms::setup(true);
- }
- }
- 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;
- $meta_table_name = self::get_meta_table_name();
- $form_meta = maybe_serialize($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 ) );
- 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){
- $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($lead_id, $field_id){
- global $wpdb;
- if($lead_id == 0 || $field_id == 0)
- return;
- $lead_detail_table = self::get_lead_details_table_name();
- //Deleting file
- $sql = $wpdb->prepare("SELECT value FROM $lead_detail_table WHERE lead_id=%d AND field_number BETWEEN %s AND %s", $lead_id, doubleval($field_id) - 0.001, doubleval($field_id) + 0.001);
- $file_path = $wpdb->get_var($sql);
- self::delete_physical_file($file_path);
- //Delete from lead details
- $sql = $wpdb->prepare("DELETE FROM $lead_detail_table WHERE lead_id=%d AND field_number BETWEEN %s AND %s", $lead_id, doubleval($field_id) - 0.001, doubleval($field_id) + 0.001);
- $wpdb->query($sql);
- }
- 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()) {
- $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;
- if(!GFCommon::current_user_can_any("gravityforms_delete_entries"))
- die(__("You don't have adequate permission to delete entries.", "gravityforms"));
- 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){
- global $wpdb;
- $table_name = self::get_lead_notes_table_name();
- $sql = $wpdb->prepare("INSERT INTO $table_name(lead_id, user_id, user_name, value, date_created) values(%d, %d, %s, %s, utc_timestamp())", $lead_id, $user_id, $user_name, $note);
- $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 = rgget("HTTP_X_FORWARDED_FOR", $_SERVER);
- if (!$ip)
- $ip = rgget("REMOTE_ADDR", $_SERVER);
- $ip_array = explode(",", $ip); //HTTP_X_FORWARDED_FOR can return a comma separated list of IPs. Using the first one.
- return $ip_array[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();
- //Inserting lead if null
- if($lead == null){
- global $current_user;
- $user_id = $current_user && $current_user->ID ? $current_user->ID : 'NULL';
- $lead_table = RGFormsModel::get_lead_table_name();
- $user_agent = strlen($_SERVER["HTTP_USER_AGENT"]) > 250 ? substr($_SERVER["HTTP_USER_AGENT"], 0, 250) : $_SERVER["HTTP_USER_AGENT"];
- $currency = GFCommon::get_currency();
- $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(), self::get_current_page_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_field = null;
- $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_field = $field;
- continue;
- }
- //only save fields that are not hidden (except on entry screen)
- if(RG_CURRENT_VIEW == "entry" || !RGFormsModel::is_field_hidden($form, $field, array()) ){
- // 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"]);
- }
- }
- else{
- self::save_input($form, $calculation_field, $lead, $current_fields, $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($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;
- $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::get_current_page_url();
- $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_field = $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) {
- 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(isset($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" :
- $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);
- }
- 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…
Large files files are truncated, but you can click here to view the full file