<?php

if ( ! class_exists( 'GFForms' ) ) {

die();

}

/**

* API for standard Gravity Forms functionality.

*

* Supports:

* - Forms

* - Entries

*

* @package Gravity Forms

* @subpackage GFAPI

* @since 1.8

* @access public

*/

class GFAPI {

// FORMS ----------------------------------------------------

/**

* Returns the form object for a given Form ID

*

* @since 1.8

* @access public

* @static

*

* @param int $form_id The ID of the Form

*

* @return mixed The form meta array or false

*/

public static function get_form( $form_id ) {

$form_id = absint( $form_id );

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

if ( ! $form ) {

return false;

}

//loading form columns into meta

$form_info = GFFormsModel::get_form( $form_id, true );

$form['is_active'] = $form_info->is_active;

$form['date_created'] = $form_info->date_created;

$form['is_trash'] = $form_info->is_trash;

return $form;

}

/**

* Returns all the form objects

*

* @since 1.8.11.5

* @access public

* @static

*

* @param bool $active

* @param bool $trash

*

* @return mixed The array of Forms

*/

public static function get_forms( $active = true, $trash = false ) {

$form_ids = GFFormsModel::get_form_ids( $active, $trash );

if ( empty( $form_ids ) ) {

return array();

}

$forms = array();

foreach ( $form_ids as $form_id ) {

$forms[] = GFAPI::get_form( $form_id );

}

return $forms;

}

/**

* Deletes the forms with the given Form IDs

*

* @since 1.8

* @access public

* @static

*

* @param array $form_ids An array of form IDs to delete

*/

public static function delete_forms( $form_ids ) {

GFFormsModel::delete_forms( $form_ids );

}

/**

* Deletes the form with the given Form ID

*

* @since 1.8

* @access public

* @static

*

* @param int $form_id The ID of the Form to delete

*

* @return mixed True for success, or a WP_Error instance

*/

public static function delete_form( $form_id ) {

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

if ( empty( $form ) ) {

return new WP_Error( 'not_found', sprintf( __( 'Form with id: %s not found', 'gravityforms' ), $form_id ), $form_id );

}

self::delete_forms( array( $form_id ) );

return true;

}

/**

* Updates the forms with an array of form objects

*

* @since 1.8

* @access public

* @static

*

* @param array $forms The Form objects

*

* @return mixed True for success, or a WP_Error instance

*/

public static function update_forms( $forms ) {

foreach ( $forms as $form ) {

$result = self::update_form( $form );

if ( is_wp_error( $result ) ) {

return $result;

}

}

return true;

}

/**

* Updates the form with a given form object.

*

* @since 1.8

* @access public

* @static

*

* @param array $form The Form object

* @param int $form_id Optional. If specified, then the ID in the Form object will be ignored

*

* @return mixed True for success, or a WP_Error instance

*/

public static function update_form( $form, $form_id = null ) {

global $wpdb;

if ( ! $form ) {

return new WP_Error( 'invalid', __( 'Invalid form object', 'gravityforms' ) );

}

$form_table_name = $wpdb->prefix . 'rg_form';

if ( empty( $form_id ) ) {

$form_id = $form['id'];

} else {

// make sure the form object has the right form id

$form['id'] = $form_id;

if ( isset( $form['fields'] ) ) {

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

if ( $field instanceof GF_Field ) {

$field->formId = $form_id;

} else {

$field['formId'] = $form_id;

}

}

}

}

if ( empty( $form_id ) ) {

return new WP_Error( 'missing_form_id', __( 'Missing form id', 'gravityforms' ) );

}

$meta_table_name = GFFormsModel::get_meta_table_name();

if ( intval( $wpdb->get_var( $wpdb->prepare( "SELECT count(0) FROM {$meta_table_name} WHERE form_id=%d", $form_id ) ) ) == 0 ) {

return new WP_Error( 'not_found', __( 'Form not found', 'gravityforms' ) );

}

// Strip confirmations and notifications

$form_display_meta = $form;

unset( $form_display_meta['confirmations'] );

unset( $form_display_meta['notifications'] );

$result = GFFormsModel::update_form_meta( $form_id, $form_display_meta );

if ( false === $result ) {

return new WP_Error( 'error_updating_form', __( 'Error updating form', 'gravityforms' ), $wpdb->last_error );

}

if ( isset( $form['confirmations'] ) && is_array( $form['confirmations'] ) ) {

$result = GFFormsModel::update_form_meta( $form_id, $form['confirmations'], 'confirmations' );

if ( false === $result ) {

return new WP_Error( 'error_updating_confirmations', __( 'Error updating form confirmations', 'gravityforms' ), $wpdb->last_error );

}

}

if ( isset( $form['notifications'] ) && is_array( $form['notifications'] ) ) {

$result = GFFormsModel::update_form_meta( $form_id, $form['notifications'], 'notifications' );

if ( false === $result ) {

return new WP_Error( 'error_updating_notifications', __( 'Error updating form notifications', 'gravityforms' ), $wpdb->last_error );

}

}

//updating form title and is_active flag

$is_active = rgar( $form, 'is_active' ) ? '1' : '0';

$result = $wpdb->query( $wpdb->prepare( "UPDATE {$form_table_name} SET title=%s, is_active=%s WHERE id=%d", $form['title'], $is_active, $form['id'] ) );

if ( false === $result ) {

return new WP_Error( 'error_updating_title', __( 'Error updating title', 'gravityforms' ), $wpdb->last_error );

}

return true;

}

/**

* Updates a form property - a column in the main forms table. e.g. is_trash, is_active, title

*

* @since 1.8.3.15

* @access public

* @static

*

* @param array $form_ids The IDs of the forms to update

* @param array $property_key The name of the column in the database e.g. is_trash, is_active, title

* @param array $value The new value

*

* @return mixed Either a WP_Error instance or the result of the query

*/

public static function update_forms_property( $form_ids, $property_key, $value ) {

global $wpdb;

$table = GFFormsModel::get_form_table_name();

$db_columns = GFFormsModel::get_form_db_columns();

if ( ! in_array( strtolower( $property_key ), $db_columns ) ) {

return new WP_Error( 'property_key_incorrect', __( 'Property key incorrect', 'gravityforms' ) );

}

$value = esc_sql( $value );

if ( ! is_numeric( $value ) ) {

$value = sprintf( "'%s'", $value );

}

$in_str_arr = array_fill( 0, count( $form_ids ), '%d' );

$in_str = join( $in_str_arr, ',' );

$result = $wpdb->query(

$wpdb->prepare(

"

UPDATE $table

SET {$property_key} = {$value}

WHERE id IN ($in_str)

", $form_ids

)

);

return $result;

}

/**

* Updates the property of one form - columns in the main forms table. e.g. is_trash, is_active, title

*

* @since 1.8.3.15

* @access public

* @static

*

* @param array|int $form_id The ID of the forms to update

* @param string $property_key The name of the column in the database e.g. is_trash, is_active, title

* @param string $value The new value

*

* @return mixed Either a WP_Error instance or the result of the query

*/

public static function update_form_property( $form_id, $property_key, $value ) {

return self::update_forms_property( array( $form_id ), $property_key, $value );

}

/**

* Adds multiple form objects.

*

* @since 1.8

* @access public

* @static

*

* @param array $forms The Form objects

*

* @return mixed Either an array of new form IDs or a WP_Error instance

*/

public static function add_forms( $forms ) {

if ( ! $forms || ! is_array( $forms ) ) {

return new WP_Error( 'invalid', __( 'Invalid form objects', 'gravityforms' ) );

}

$form_ids = array();

foreach ( $forms as $form ) {

$result = self::add_form( $form );

if ( is_wp_error( $result ) ) {

return $result;

}

$form_ids[] = $result;

}

return $form_ids;

}

/**

* Adds a new form using the given Form object. Warning, little checking is done to make sure it's a valid Form object.

*

* @since 1.8

* @access public

* @static

*

* @param array $form_meta The Form object

*

* @return mixed Either the new Form ID or a WP_Error instance

*/

public static function add_form( $form_meta ) {

global $wpdb;

if ( ! $form_meta || ! is_array( $form_meta ) ) {

return new WP_Error( 'invalid', __( 'Invalid form object', 'gravityforms' ) );

}

if ( rgar( $form_meta, 'title' ) == '' ) {

return new WP_Error( 'missing_title', __( 'The form title is missing', 'gravityforms' ) );

}

//Making sure title is not duplicate

$title = $form_meta['title'];

$count = 2;

while ( ! RGFormsModel::is_unique_title( $title ) ) {

$title = $form_meta['title'] . "($count)";

$count ++;

}

//inserting form

$form_id = RGFormsModel::insert_form( $title );

//updating form meta

$form_meta['title'] = $title;

//updating object's id property

$form_meta['id'] = $form_id;

if ( isset( $form_meta['confirmations'] ) ) {

$form_meta['confirmations'] = self::set_property_as_key( $form_meta['confirmations'], 'id' );

GFFormsModel::update_form_meta( $form_id, $form_meta['confirmations'], 'confirmations' );

unset( $form_meta['confirmations'] );

}

if ( isset( $form_meta['notifications'] ) ) {

$form_meta['notifications'] = self::set_property_as_key( $form_meta['notifications'], 'id' );

GFFormsModel::update_form_meta( $form_id, $form_meta['notifications'], 'notifications' );

unset( $form_meta['notifications'] );

}

//updating form meta

$result = GFFormsModel::update_form_meta( $form_id, $form_meta );

if ( false === $result ) {

return new WP_Error( 'insert_form_error', __( 'There was a problem while inserting the form', 'gravityforms' ), $wpdb->last_error );

}

return $form_id;

}

/**

* Private.

*

* @since 1.8

* @access private

* @static

* @ignore

*/

private static function set_property_as_key( $array, $property ) {

$new_array = array();

foreach ( $array as $item ) {

$new_array[ $item[ $property ] ] = $item;

}

return $new_array;

}

// ENTRIES ----------------------------------------------------

/**

* Returns an array of Entry objects for the given search criteria. The search criteria array is constructed as follows:

*

* Filter by status

* $search_criteria['status'] = 'active';

*

* Filter by date range

* $search_criteria['start_date'] = $start_date;

* $search_criteria['end_date'] = $end_date;

*

* Filter by any column in the main table

* $search_criteria['field_filters'][] = array("key" => 'currency', value => 'USD');

* $search_criteria['field_filters'][] = array("key" => 'is_read', value => true);

*

* Filter by Field Values

* $search_criteria['field_filters'][] = array('key' => '1', 'value' => 'gquiz159982170');

*

* Filter Operators

* Supported operators for scalar values: is/=, isnot/<>, contains

* $search_criteria['field_filters'][] = array('key' => '1', 'operator' => 'contains', value' => 'Steve');

* Supported operators for array values: in/=, not in/<>/!=

* $search_criteria['field_filters'][] = array('key' => '1', 'operator' => 'not in', value' => array( 'Alex', 'David', 'Dana' );

*

* Filter by a checkbox value (not recommended)

* $search_criteria['field_filters'][] = array('key' => '2.2', 'value' => 'gquiz246fec995');

* note: this will work for checkboxes but it won't work if the checkboxes have been re-ordered - best to use the following examples below

*

* Filter by a checkbox value (recommended)

* $search_criteria['field_filters'][] = array('key' => '2', 'value' => 'gquiz246fec995');

* $search_criteria['field_filters'][] = array('key' => '2', 'operator' => 'not in', value' => array( 'First Choice', 'Third Choice' );

*

* Filter by a global search of values of any form field

* $search_criteria['field_filters'][] = array('value' => $search_value);

* OR

* $search_criteria['field_filters'][] = array('key' => 0, 'value' => $search_value);

*

* Filter entries by Entry meta (added using the gform_entry_meta hook)

* $search_criteria['field_filters'][] = array('key' => 'gquiz_score', 'value' => '1');

* $search_criteria['field_filters'][] = array('key' => 'gquiz_is_pass', 'value' => '1');

*

* Filter by ALL / ANY of the field filters

* $search_criteria['field_filters']['mode'] = 'all'; // default

* $search_criteria['field_filters']['mode'] = 'any';

*

* Sorting: column, field or entry meta

* $sorting = array('key' => $sort_field, 'direction' => 'ASC' );

*

* Paging

* $paging = array('offset' => 0, 'page_size' => 20 );

*

*

*

* @since 1.8

* @access public

* @static

*

* @param int|array $form_ids The ID of the form or an array IDs of the Forms. Zero for all forms.

* @param array $search_criteria Optional. An array containing the search criteria

* @param array $sorting Optional. An array containing the sorting criteria

* @param array $paging Optional. An array containing the paging criteria

* @param int $total_count Optional. An output parameter containing the total number of entries. Pass a non-null value to get the total count.

*

* @return mixed Either an array of the Entry objects or a WP_Error instance

*/

public static function get_entries( $form_ids, $search_criteria = array(), $sorting = null, $paging = null, &$total_count = null ) {

if ( empty( $sorting ) ) {

$sorting = array( 'key' => 'id', 'direction' => 'DESC', 'is_numeric' => true );

}

$entries = GFFormsModel::search_leads( $form_ids, $search_criteria, $sorting, $paging );

if ( ! is_null( $total_count ) ) {

$total_count = self::count_entries( $form_ids, $search_criteria );

}

return $entries;

}

/**

* Returns the total number of entries for the given search criteria. See get_entries() for examples of the search criteria.

*

* @since 1.8

* @access public

* @static

*

* @param int|array $form_ids The ID of the Form or an array of Form IDs

* @param array $search_criteria Optional. An array containing the search criteria

*

* @return int The total count

*/

public static function count_entries( $form_ids, $search_criteria = array() ) {

return GFFormsModel::count_search_leads( $form_ids, $search_criteria );

}

/**

* Returns the Entry object for a given Entry ID

*

* @since 1.8

* @access public

* @static

*

* @param int $entry_id The ID of the Entry

*

* @return mixed The Entry object or a WP_Error instance

*/

public static function get_entry( $entry_id ) {

$search_criteria['field_filters'][] = array( 'key' => 'id', 'value' => $entry_id );

$paging = array( 'offset' => 0, 'page_size' => 1 );

$entries = self::get_entries( 0, $search_criteria, null, $paging );

if ( empty( $entries ) ) {

return new WP_Error( 'not_found', sprintf( __( 'Entry with id %s not found', 'gravityforms' ), $entry_id ), $entry_id );

}

return $entries[0];

}

/**

* Adds multiple Entry objects.

*

* @since 1.8

* @access public

* @static

*

* @param array $entries The Entry objects

* @param int $form_id Optional. If specified, the form_id in the Entry objects will be ignored

*

* @return mixed Either an array of new Entry IDs or a WP_Error instance

*/

public static function add_entries( $entries, $form_id = null ) {

$entry_ids = array();

foreach ( $entries as $entry ) {

if ( $form_id ) {

$entry['form_id'] = $form_id;

}

$result = self::add_entry( $entry );

if ( is_wp_error( $result ) ) {

return $result;

}

$entry_ids[] = $result;

}

return $entry_ids;

}

/**

* Updates multiple Entry objects.

*

* @since 1.8

* @access public

* @static

*

* @param array $entries The Entry objects

*

* @return mixed Either True for success, or a WP_Error instance

*/

public static function update_entries( $entries ) {

foreach ( $entries as $entry ) {

$result = self::update_entry( $entry, $entry['id'] );

if ( is_wp_error( $result ) ) {

return $result;

}

}

return true;

}

/**

* Updates a single Entry object.

*

* @since 1.8

* @access public

* @static

*

* @param array $entry The Entry object

* @param int $entry_id Optional. If specified, the ID in the Entry object will be ignored

*

* @return mixed Either True or a WP_Error instance

*/

public static function update_entry( $entry, $entry_id = null ) {

global $wpdb;

if ( empty( $entry_id ) ) {

$entry_id = absint( $entry['id'] );

} else {

$entry['id'] = absint( $entry_id );

}

if ( empty( $entry_id ) ) {

return new WP_Error( 'missing_entry_id', __( 'Missing entry id', 'gravityforms' ) );

}

$current_entry = $original_entry = self::get_entry( $entry_id );

if ( ! $current_entry ) {

return new WP_Error( 'not_found', __( 'Entry not found', 'gravityforms' ), $entry_id );

}

if ( is_wp_error( $current_entry ) ) {

return $current_entry;

}

// make sure the form id exists

$form_id = rgar( $entry, 'form_id' );

if ( empty( $form_id ) ) {

$form_id = rgar( $current_entry, 'form_id' );

}

if ( false === self::form_id_exists( $form_id ) ) {

return new WP_Error( 'invalid_form_id', __( 'The form for this entry does not exist', 'gravityforms' ) );

}

$entry = apply_filters( 'gform_entry_pre_update', $entry, $original_entry );

// use values in the entry object if present

$post_id = isset( $entry['post_id'] ) ? intval( $entry['post_id'] ) : 'NULL';

$date_created = isset( $entry['date_created'] ) ? sprintf( "'%s'", esc_sql( $entry['date_created'] ) ) : 'utc_timestamp()';

$is_starred = isset( $entry['is_starred'] ) ? $entry['is_starred'] : 0;

$is_read = isset( $entry['is_read'] ) ? $entry['is_read'] : 0;

$ip = isset( $entry['ip'] ) ? $entry['ip'] : GFFormsModel::get_ip();

$source_url = isset( $entry['source_url'] ) ? $entry['source_url'] : GFFormsModel::get_current_page_url();

$user_agent = isset( $entry['user_agent'] ) ? $entry['user_agent'] : 'API';

$currency = isset( $entry['currency'] ) ? $entry['currency'] : GFCommon::get_currency();

$payment_status = isset( $entry['payment_status'] ) ? sprintf( "'%s'", esc_sql( $entry['payment_status'] ) ) : 'NULL';

$payment_date = strtotime( rgar( $entry, 'payment_date' ) ) ? "'" . gmdate( 'Y-m-d H:i:s', strtotime( "{$entry['payment_date']}" ) ) . "'" : 'NULL';

$payment_amount = isset( $entry['payment_amount'] ) ? (float) $entry['payment_amount'] : 'NULL';

$payment_method = isset( $entry['payment_method'] ) ? $entry['payment_method'] : '';

$transaction_id = isset( $entry['transaction_id'] ) ? sprintf( "'%s'", esc_sql( $entry['transaction_id'] ) ) : 'NULL';

$is_fulfilled = isset( $entry['is_fulfilled'] ) ? intval( $entry['is_fulfilled'] ) : 'NULL';

$status = isset( $entry['status'] ) ? $entry['status'] : 'active';

global $current_user;

$user_id = isset( $entry['created_by'] ) ? absint( $entry['created_by'] ) : '';

if ( empty( $user_id ) ) {

$user_id = $current_user && $current_user->ID ? absint( $current_user->ID ) : 'NULL';

}

$transaction_type = isset( $entry['transaction_type'] ) ? intval( $entry['transaction_type'] ) : 'NULL';

$lead_table = GFFormsModel::get_lead_table_name();

$result = $wpdb->query(

$wpdb->prepare(

"

UPDATE $lead_table

SET

form_id = %d,

post_id = {$post_id},

date_created = {$date_created},

is_starred = %d,

is_read = %d,

ip = %s,

source_url = %s,

user_agent = %s,

currency = %s,

payment_status = {$payment_status},

payment_date = {$payment_date},

payment_amount = {$payment_amount},

transaction_id = {$transaction_id},

is_fulfilled = {$is_fulfilled},

created_by = {$user_id},

transaction_type = {$transaction_type},

status = %s,

payment_method = %s

WHERE

id = %d

", $form_id, $is_starred, $is_read, $ip, $source_url, $user_agent, $currency, $status, $payment_method, $entry_id

)

);

if ( false === $result ) {

return new WP_Error( 'update_entry_properties_failed', __( 'There was a problem while updating the entry properties', 'gravityforms' ), $wpdb->last_error );

}

// only save field values for fields that currently exist in the form. The rest in $entry will be ignored. The rest in $current_entry will get deleted.

$lead_detail_table = GFFormsModel::get_lead_details_table_name();

$current_fields = $wpdb->get_results( $wpdb->prepare( "SELECT id, field_number FROM $lead_detail_table WHERE lead_id=%d", $entry_id ) );

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

$form = apply_filters( 'gform_form_pre_update_entry', $form, $entry, $entry_id );

$form = apply_filters( "gform_form_pre_update_entry_{$form_id}", $form, $entry, $entry_id );

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

/* @var GF_Field $field */

$type = GFFormsModel::get_input_type( $field );

if ( in_array( $type, array( 'html', 'page', 'section' ) ) ) {

continue;

}

$inputs = $field->get_entry_inputs();

if ( is_array( $inputs ) ) {

foreach ( $field->inputs as $input ) {

$input_id = (string) $input['id'];

if ( isset( $entry[ $input_id ] ) ) {

if ( $entry[ $input_id ] != $current_entry[ $input_id ] ) {

$lead_detail_id = GFFormsModel::get_lead_detail_id( $current_fields, $input_id );

$result = GFFormsModel::update_lead_field_value( $form, $entry, $field, $lead_detail_id, $input_id, $entry[ $input_id ] );

if ( false === $result ) {

return new WP_Error( 'update_input_value_failed', __( 'There was a problem while updating one of the input values for the entry', 'gravityforms' ), $wpdb->last_error );

}

}

unset( $current_entry[ $input_id ] );

}

}

} else {

$field_id = $field->id;

$field_value = isset( $entry[ (string) $field_id ] ) ? $entry[ (string) $field_id ] : '';

if ( $field_value != $current_entry[ $field_id ] ) {

$lead_detail_id = GFFormsModel::get_lead_detail_id( $current_fields, $field_id );

$result = GFFormsModel::update_lead_field_value( $form, $entry, $field, $lead_detail_id, $field_id, $field_value );

if ( false === $result ) {

return new WP_Error( 'update_field_values_failed', __( 'There was a problem while updating the field values', 'gravityforms' ), $wpdb->last_error );

}

}

unset( $current_entry[ $field_id ] );

}

}

// save the entry meta values - only for the entry meta currently available for the form, ignore the rest

$entry_meta = GFFormsModel::get_entry_meta( $form_id );

if ( is_array( $entry_meta ) ) {

foreach ( array_keys( $entry_meta ) as $key ) {

if ( isset( $entry[ $key ] ) ) {

if ( $entry[ $key ] != $current_entry[ $key ] ) {

gform_update_meta( $entry_id, $key, $entry[ $key ] );

}

unset( $current_entry[ $key ] );

}

}

}

// now delete remaining values from the old entry

if ( is_array( $entry_meta ) ) {

foreach ( array_keys( $entry_meta ) as $meta_key ) {

if ( isset( $current_entry[ $meta_key ] ) ) {

gform_delete_meta( $entry_id, $meta_key );

unset( $current_entry[ $meta_key ] );

}

}

}

foreach ( $current_entry as $k => $v ) {

$lead_detail_id = GFFormsModel::get_lead_detail_id( $current_fields, $k );

$field = GFFormsModel::get_field( $form, $k );

$result = GFFormsModel::update_lead_field_value( $form, $entry, $field, $lead_detail_id, $k, '' );

if ( false === $result ) {

return new WP_Error( 'update_field_values_failed', __( 'There was a problem while updating the field values', 'gravityforms' ), $wpdb->last_error );

}

}

do_action( 'gform_post_update_entry', $entry, $original_entry );

return true;

}

/**

* Adds a single Entry object.

*

* Intended to be used for importing an entry object. The usual hooks that are triggered while saving entries are not fired here.

* Checks that the form id, field ids and entry meta exist and ignores legacy values (i.e. values for fields that no longer exist).

*

* @since 1.8

* @access public

* @static

*

* @param array $entry The Entry object

*

* @return mixed Either the new Entry ID or a WP_Error instance

*/

public static function add_entry( $entry ) {

global $wpdb;

if ( ! is_array( $entry ) ) {

return new WP_Error( 'invalid_entry_object', __( 'The entry object must be an array', 'gravityforms' ) );

}

// make sure the form id exists

$form_id = rgar( $entry, 'form_id' );

if ( empty( $form_id ) ) {

return new WP_Error( 'empty_form_id', __( 'The form id must be specified', 'gravityforms' ) );

}

if ( false === self::form_id_exists( $form_id ) ) {

return new WP_Error( 'invalid_form_id', __( 'The form for this entry does not exist', 'gravityforms' ) );

}

// use values in the entry object if present

$post_id = isset( $entry['post_id'] ) ? intval( $entry['post_id'] ) : 'NULL';

$date_created = isset( $entry['date_created'] ) && $entry['date_created'] != '' ? sprintf( "'%s'", esc_sql( $entry['date_created'] ) ) : 'utc_timestamp()';

$is_starred = isset( $entry['is_starred'] ) ? $entry['is_starred'] : 0;

$is_read = isset( $entry['is_read'] ) ? $entry['is_read'] : 0;

$ip = isset( $entry['ip'] ) ? $entry['ip'] : GFFormsModel::get_ip();

$source_url = isset( $entry['source_url'] ) ? $entry['source_url'] : GFFormsModel::get_current_page_url();

$user_agent = isset( $entry['user_agent'] ) ? $entry['user_agent'] : 'API';

$currency = isset( $entry['currency'] ) ? $entry['currency'] : GFCommon::get_currency();

$payment_status = isset( $entry['payment_status'] ) ? sprintf( "'%s'", esc_sql( $entry['payment_status'] ) ) : 'NULL';

$payment_date = strtotime( rgar( $entry, 'payment_date' ) ) ? sprintf( "'%s'", gmdate( 'Y-m-d H:i:s', strtotime( "{$entry['payment_date']}" ) ) ) : 'NULL';

$payment_amount = isset( $entry['payment_amount'] ) ? (float) $entry['payment_amount'] : 'NULL';

$payment_method = isset( $entry['payment_method'] ) ? $entry['payment_method'] : '';

$transaction_id = isset( $entry['transaction_id'] ) ? sprintf( "'%s'", esc_sql( $entry['transaction_id'] ) ) : 'NULL';

$is_fulfilled = isset( $entry['is_fulfilled'] ) ? intval( $entry['is_fulfilled'] ) : 'NULL';

$status = isset( $entry['status'] ) ? $entry['status'] : 'active';

global $current_user;

$user_id = isset( $entry['created_by'] ) ? absint( $entry['created_by'] ) : '';

if ( empty( $user_id ) ) {

$user_id = $current_user && $current_user->ID ? absint( $current_user->ID ) : 'NULL';

}

$transaction_type = isset( $entry['transaction_type'] ) ? intval( $entry['transaction_type'] ) : 'NULL';

$lead_table = GFFormsModel::get_lead_table_name();

$result = $wpdb->query(

$wpdb->prepare(

"

INSERT INTO $lead_table

(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, payment_method)

VALUES

(%d, {$post_id}, {$date_created}, %d, %d, %s, %s, %s, %s, {$payment_status}, {$payment_date}, {$payment_amount}, {$transaction_id}, {$is_fulfilled}, {$user_id}, {$transaction_type}, %s, %s)

", $form_id, $is_starred, $is_read, $ip, $source_url, $user_agent, $currency, $status, $payment_method

)

);

if ( false === $result ) {

return new WP_Error( 'insert_entry_properties_failed', __( 'There was a problem while inserting the entry properties', 'gravityforms' ), $wpdb->last_error );

}

// reading newly created lead id

$entry_id = $wpdb->insert_id;

$entry['id'] = $entry_id;

// only save field values for fields that currently exist in the form

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

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

/* @var GF_Field $field */

if ( in_array( $field->type, array( 'html', 'page', 'section' ) ) ) {

continue;

}

$inputs = $field->get_entry_inputs();

if ( is_array( $inputs ) ) {

foreach ( $inputs as $input ) {

$input_id = (string) $input['id'];

if ( isset( $entry[ $input_id ] ) ) {

$result = GFFormsModel::update_lead_field_value( $form, $entry, $field, 0, $input_id, $entry[ $input_id ] );

if ( false === $result ) {

return new WP_Error( 'insert_input_value_failed', __( 'There was a problem while inserting one of the input values for the entry', 'gravityforms' ), $wpdb->last_error );

}

}

}

} else {

$field_id = $field->id;

$field_value = isset( $entry[ (string) $field_id ] ) ? $entry[ (string) $field_id ] : '';

$result = GFFormsModel::update_lead_field_value( $form, $entry, $field, 0, $field_id, $field_value );

if ( false === $result ) {

return new WP_Error( 'insert_field_values_failed', __( 'There was a problem while inserting the field values', 'gravityforms' ), $wpdb->last_error );

}

}

}

// add save the entry meta values - only for the entry meta currently available for the form, ignore the rest

$entry_meta = GFFormsModel::get_entry_meta( $form_id );

if ( is_array( $entry_meta ) ) {

foreach ( array_keys( $entry_meta ) as $key ) {

if ( isset( $entry[ $key ] ) ) {

gform_update_meta( $entry_id, $key, $entry[ $key ], $form['id'] );

}

}

}

return $entry_id;

}

/**

* Deletes a single Entry.

*

* @since 1.8

* @access public

* @static

*

* @param int $entry_id The ID of the Entry object

*

* @return mixed Either true for success or a WP_Error instance

*/

public static function delete_entry( $entry_id ) {

$entry = GFFormsModel::get_lead( $entry_id );

if ( empty( $entry ) ) {

return new WP_Error( 'invalid_entry_id', sprintf( __( 'Invalid entry id: %s', 'gravityforms' ), $entry_id ), $entry_id );

}

GFFormsModel::delete_lead( $entry_id );

return true;

}

/**

* Updates a single property of an entry.

*

* @since 1.8.3.1

* @access public

* @static

*

* @param int $entry_id The ID of the Entry object

* @param string $property The property of the Entry object to be updated

* @param mixed $value The value to which the property should be set

*

* @return bool Whether the entry property was updated successfully

*/

public static function update_entry_property( $entry_id, $property, $value ) {

return GFFormsModel::update_lead_property( $entry_id, $property, $value );

}

/**

* Updates a single field of an entry.

*

* @since 1.9

* @access public

* @static

*

* @param int $entry_id The ID of the Entry object

* @param string $input_id The id of the input to be updated. For single input fields such as text, paragraph, website, drop down etc... this will be the same as the field ID.

* For multi input fields such as name, address, checkboxes, etc... the input id will be in the format {FIELD_ID}.{INPUT NUMBER}. ( i.e. "1.3" )

* The $input_id can be obtained by inspecting the key for the specified field in the $entry object.

*

* @param mixed $value The value to which the field should be set

*

* @return bool Whether the entry property was updated successfully

*/

public static function update_entry_field( $entry_id, $input_id, $value ) {

global $wpdb;

$entry = self::get_entry( $entry_id );

if ( is_wp_error( $entry ) ) {

return $entry;

}

$form = self::get_form( $entry['form_id'] );

if ( ! $form ) {

return false;

}

$field = GFFormsModel::get_field( $form, $input_id );

$input_id_min = (float) $input_id - 0.0001;

$input_id_max = (float) $input_id + 0.0001;

$lead_details_table_name = GFFormsModel::get_lead_details_table_name();

$lead_detail_id = $wpdb->get_var( $wpdb->prepare( "SELECT id FROM {$lead_details_table_name} WHERE lead_id=%d AND field_number BETWEEN %s AND %s", $entry_id, $input_id_min, $input_id_max ) );

$result = true;

if ( ! isset( $entry[ $input_id ] ) || $entry[ $input_id ] != $value ){

$result = GFFormsModel::update_lead_field_value( $form, $entry, $field, $lead_detail_id, $input_id, $value );

}

return $result;

}

// FORM SUBMISSIONS -------------------------------------------

/**

* Submits a form. Use this function to send input values through the complete form submission process.

* Supports field validation, notifications, confirmations, multiple-pages and save & continue.

*

* Example usage:

* $input_values['input_1'] = 'Single line text';

* $input_values['input_2_3'] = 'First name';

* $input_values['input_2_6'] = 'Last name';

* $input_values['input_5'] = 'A paragraph of text.';

* //$input_values['gform_save'] = true; // support for save and continue

*

* $result = GFAPI::submit_form( 52, $input_values );

*

* Example output for a successful submission:

* 'is_valid' => boolean true

* 'page_number' => int 0

* 'source_page_number' => int 1

* 'confirmation_message' => string 'confirmation message [snip]'

*

* Example output for failed validation:

* 'is_valid' => boolean false

* 'validation_messages' =>

* array (size=1)

* 2 => string 'This field is required. Please enter the first and last name.'

* 'page_number' => int 1

* 'source_page_number' => int 1

* 'confirmation_message' => string ''

*

*

* Example output for save and continue:

* 'is_valid' => boolean true

* 'page_number' => int 1

* 'source_page_number' => int 1

* 'confirmation_message' => string 'Please use the following link to return to your form from any computer. [snip]'

* 'resume_token' => string '045f941cc4c04d479556bab1db6d3495'

*

*

* @param int $form_id The Form ID

* @param array $input_values An array of values.

* @param array $field_values Optional.

* @param int $target_page Optional.

* @param int $source_page Optional.

*

* @return array An array containing the result of the submission.

*/

public static function submit_form( $form_id, $input_values, $field_values = array(), $target_page = 0, $source_page = 1 ) {

$form_id = absint( $form_id );

$form = GFAPI::get_form( $form_id );

if ( empty( $form ) || ! $form['is_active'] || $form['is_trash'] ) {

return new WP_Error( 'form_not_found', __( 'Your form could not be found', 'gravityforms' ) );