'DonorPerfect', 'tasks' => array( 'create_donor' => 'Create Donor', 'create_gift' => 'Create Gift', ) ); return $actions; } add_filter( 'adfoin_settings_tabs', 'adfoin_donorperfect_settings_tab', 10, 1 ); function adfoin_donorperfect_settings_tab( $providers ) { $providers['donorperfect'] = 'DonorPerfect'; return $providers; } add_action( 'adfoin_settings_view', 'adfoin_donorperfect_settings_view', 10, 1 ); function adfoin_donorperfect_settings_view( $current_tab ) { if ( $current_tab !== 'donorperfect' ) return; $arguments = wp_json_encode( array( 'platform' => 'donorperfect', 'fields' => array( array( 'key' => 'apiKey', 'label' => __( 'API Key', 'advanced-form-integration' ), 'hidden' => true ), ), ) ); $instructions = __( 'In DonorPerfect, go to Settings > Integrations > API. Request an API token from your account manager and paste it above.', 'advanced-form-integration' ); echo adfoin_platform_settings_template( __( 'DonorPerfect', 'advanced-form-integration' ), 'donorperfect', $arguments, $instructions ); } add_action( 'adfoin_action_fields', 'adfoin_donorperfect_action_fields' ); function adfoin_donorperfect_action_fields() { ?> 'donorEmail', 'value' => 'Donor Email', 'description' => 'Used to look up the donor' ), array( 'key' => 'amount', 'value' => 'Amount', 'description' => '' ), array( 'key' => 'date', 'value' => 'Gift Date', 'description' => 'YYYY-MM-DD' ), array( 'key' => 'method', 'value' => 'Gift Method', 'description' => 'Check / Credit / Cash' ), array( 'key' => 'campaign', 'value' => 'Campaign Code', 'description' => '' ), array( 'key' => 'fund', 'value' => 'Fund Code', 'description' => '' ), array( 'key' => 'solicit', 'value' => 'Solicitation Code', 'description' => '' ), array( 'key' => 'note', 'value' => 'Note', 'description' => '' ), ); } else { $fields = array( array( 'key' => 'firstName', 'value' => 'First Name', 'description' => '' ), array( 'key' => 'lastName', 'value' => 'Last Name', 'description' => '' ), array( 'key' => 'email', 'value' => 'Email', 'description' => '' ), array( 'key' => 'phone', 'value' => 'Phone', 'description' => '' ), array( 'key' => 'organization','value' => 'Organization', 'description' => '' ), array( 'key' => 'address', 'value' => 'Address', 'description' => '' ), array( 'key' => 'city', 'value' => 'City', 'description' => '' ), array( 'key' => 'state', 'value' => 'State', 'description' => '' ), array( 'key' => 'zip', 'value' => 'Zip', 'description' => '' ), array( 'key' => 'country', 'value' => 'Country', 'description' => '' ), array( 'key' => 'donorType', 'value' => 'Donor Type', 'description' => '' ), array( 'key' => 'note', 'value' => 'Note', 'description' => '' ), ); } wp_send_json_success( $fields ); } function adfoin_donorperfect_credentials_list() { foreach ( adfoin_read_credentials( 'donorperfect' ) as $option ) { printf( '', esc_attr( $option['id'] ), esc_html( $option['title'] ) ); } } /** * DonorPerfect's real XML API (confirmed via the official * "DonorPerfect Online XML API Documentation User Manual", v6.9) does not * take one query param per field. A predefined procedure call is * `?apikey=...&action=dp_savedonor¶ms=@donor_id=0, @first_name='X', @middle_name=null, ...` * — a single `params` value containing SQL-literal-style `@name=value` * pairs (strings single-quoted, empty values the literal word null, not * an empty string). Dynamic SQL queries instead put the whole SELECT * statement directly in `action` with no `params` at all. Base domain is * donorperfect.net, not donorperfect.io. */ function adfoin_donorperfect_build_params( $fields ) { $parts = array(); foreach ( $fields as $key => $spec ) { $value = $spec['value']; $quote = $spec['quote']; if ( $value === null || $value === '' ) { $parts[] = "@{$key}=null"; } elseif ( $quote ) { $parts[] = "@{$key}='" . str_replace( "'", "''", $value ) . "'"; } else { $parts[] = "@{$key}={$value}"; } } return implode( ', ', $parts ); } function adfoin_donorperfect_request( $action, $params_string, $record = array(), $cred_id = '' ) { $credentials = adfoin_get_credentials_by_id( 'donorperfect', $cred_id ); $api_key = isset( $credentials['apiKey'] ) ? $credentials['apiKey'] : ''; if ( ! $api_key ) return; $url = 'https://www.donorperfect.net/prod/xmlrequest.asp?apikey=' . rawurlencode( $api_key ) . '&action=' . rawurlencode( $action ); if ( $params_string !== '' ) $url .= '¶ms=' . rawurlencode( $params_string ); $args = array( 'timeout' => 30, 'method' => 'GET' ); $response = wp_remote_request( $url, $args ); if ( $record ) adfoin_add_to_log( $response, $url, $args, $record ); return $response; } /** * Runs a raw Dynamic Query SELECT (the whole statement goes in `action`, * no `params`). Used to look up a donor_id by email since the predefined * dp_donorsearch procedure has no email parameter. */ function adfoin_donorperfect_query( $sql, $record = array(), $cred_id = '' ) { return adfoin_donorperfect_request( $sql, '', $record, $cred_id ); } /** Returns the value of the first in a DonorPerfect XML response. */ function adfoin_donorperfect_first_value( $response ) { if ( is_wp_error( $response ) ) return ''; $xml = @simplexml_load_string( wp_remote_retrieve_body( $response ) ); if ( ! $xml || ! isset( $xml->record ) ) return ''; foreach ( $xml->record as $record ) { foreach ( $record->field as $field ) { return (string) $field['value']; } } return ''; } function adfoin_donorperfect_find_donor_id( $email, $cred_id ) { $sql = "select donor_id from dp where email='" . str_replace( "'", "''", $email ) . "'"; return adfoin_donorperfect_first_value( adfoin_donorperfect_query( $sql, array(), $cred_id ) ); } /** * Saves a User Defined Field via dp_save_udf_xml. @matching_id is a * donor_id or gift_id depending on which record the UDF belongs to. * All incoming form values are treated as character (text) UDFs. */ function adfoin_donorperfect_save_udf( $matching_id, $field_name, $value, $cred_id ) { if ( ! $matching_id ) return; $params = adfoin_donorperfect_build_params( array( 'matching_id' => array( 'value' => $matching_id, 'quote' => false ), 'field_name' => array( 'value' => $field_name, 'quote' => true ), 'data_type' => array( 'value' => 'C', 'quote' => true ), 'char_value' => array( 'value' => $value, 'quote' => true ), 'date_value' => array( 'value' => null, 'quote' => true ), 'number_value' => array( 'value' => null, 'quote' => true ), 'user_id' => array( 'value' => 'AFI', 'quote' => true ), ) ); return adfoin_donorperfect_request( 'dp_save_udf_xml', $params, array(), $cred_id ); } add_action( 'adfoin_donorperfect_job_queue', 'adfoin_donorperfect_job_queue', 10, 1 ); function adfoin_donorperfect_job_queue( $data ) { adfoin_donorperfect_send_data( $data['record'], $data['posted_data'] ); } function adfoin_donorperfect_build_donor_params( $fields ) { $is_org = ! empty( $fields['organization'] ); return adfoin_donorperfect_build_params( array( 'donor_id' => array( 'value' => 0, 'quote' => false ), 'first_name' => array( 'value' => $is_org ? null : ( isset( $fields['firstName'] ) ? $fields['firstName'] : null ), 'quote' => true ), 'last_name' => array( 'value' => $is_org ? $fields['organization'] : ( isset( $fields['lastName'] ) ? $fields['lastName'] : null ), 'quote' => true ), 'middle_name' => array( 'value' => null, 'quote' => true ), 'suffix' => array( 'value' => null, 'quote' => true ), 'title' => array( 'value' => null, 'quote' => true ), 'salutation' => array( 'value' => null, 'quote' => true ), 'prof_title' => array( 'value' => null, 'quote' => true ), 'opt_line' => array( 'value' => null, 'quote' => true ), 'address' => array( 'value' => isset( $fields['address'] ) ? $fields['address'] : null, 'quote' => true ), 'address2' => array( 'value' => null, 'quote' => true ), 'city' => array( 'value' => isset( $fields['city'] ) ? $fields['city'] : null, 'quote' => true ), 'state' => array( 'value' => isset( $fields['state'] ) ? $fields['state'] : null, 'quote' => true ), 'zip' => array( 'value' => isset( $fields['zip'] ) ? $fields['zip'] : null, 'quote' => true ), 'country' => array( 'value' => isset( $fields['country'] ) ? $fields['country'] : null, 'quote' => true ), 'address_type' => array( 'value' => null, 'quote' => true ), 'home_phone' => array( 'value' => isset( $fields['phone'] ) ? $fields['phone'] : null, 'quote' => true ), 'business_phone' => array( 'value' => null, 'quote' => true ), 'fax_phone' => array( 'value' => null, 'quote' => true ), 'mobile_phone' => array( 'value' => null, 'quote' => true ), 'email' => array( 'value' => isset( $fields['email'] ) ? $fields['email'] : null, 'quote' => true ), 'org_rec' => array( 'value' => $is_org ? 'Y' : 'N', 'quote' => true ), 'donor_type' => array( 'value' => isset( $fields['donorType'] ) ? $fields['donorType'] : ( $is_org ? 'CO' : 'IN' ), 'quote' => true ), 'nomail' => array( 'value' => 'N', 'quote' => true ), 'nomail_reason' => array( 'value' => null, 'quote' => true ), 'narrative' => array( 'value' => isset( $fields['note'] ) ? $fields['note'] : null, 'quote' => true ), 'donor_rcpt_type' => array( 'value' => null, 'quote' => true ), 'user_id' => array( 'value' => 'AFI', 'quote' => true ), ) ); } function adfoin_donorperfect_build_gift_params( $donor_id, $fields ) { return adfoin_donorperfect_build_params( array( 'gift_id' => array( 'value' => 0, 'quote' => false ), 'donor_id' => array( 'value' => $donor_id, 'quote' => false ), 'record_type' => array( 'value' => 'G', 'quote' => true ), 'gift_date' => array( 'value' => isset( $fields['date'] ) ? $fields['date'] : gmdate( 'm/d/Y' ), 'quote' => true ), 'amount' => array( 'value' => isset( $fields['amount'] ) ? floatval( $fields['amount'] ) : 0, 'quote' => false ), 'gl_code' => array( 'value' => isset( $fields['gl_code'] ) ? $fields['gl_code'] : null, 'quote' => true ), 'solicit_code' => array( 'value' => isset( $fields['solicit'] ) ? $fields['solicit'] : null, 'quote' => true ), 'sub_solicit_code' => array( 'value' => null, 'quote' => true ), 'campaign' => array( 'value' => isset( $fields['campaign'] ) ? $fields['campaign'] : null, 'quote' => true ), 'gift_type' => array( 'value' => isset( $fields['method'] ) ? $fields['method'] : null, 'quote' => true ), 'split_gift' => array( 'value' => 'N', 'quote' => true ), 'pledge_payment' => array( 'value' => 'N', 'quote' => true ), 'reference' => array( 'value' => null, 'quote' => true ), 'transaction_id' => array( 'value' => null, 'quote' => true ), 'memory_honor' => array( 'value' => null, 'quote' => true ), 'gfname' => array( 'value' => null, 'quote' => true ), 'glname' => array( 'value' => null, 'quote' => true ), 'fmv' => array( 'value' => 0, 'quote' => false ), 'batch_no' => array( 'value' => 0, 'quote' => false ), 'gift_narrative' => array( 'value' => isset( $fields['note'] ) ? $fields['note'] : null, 'quote' => true ), 'ty_letter_no' => array( 'value' => null, 'quote' => true ), 'glink' => array( 'value' => null, 'quote' => true ), 'plink' => array( 'value' => null, 'quote' => true ), 'nocalc' => array( 'value' => 'N', 'quote' => true ), 'receipt' => array( 'value' => 'N', 'quote' => true ), 'old_amount' => array( 'value' => null, 'quote' => true ), 'user_id' => array( 'value' => 'AFI', 'quote' => true ), 'gift_aid_date' => array( 'value' => null, 'quote' => true ), 'gift_aid_amt' => array( 'value' => null, 'quote' => true ), 'gift_aid_eligible_g' => array( 'value' => null, 'quote' => true ), 'currency' => array( 'value' => 'USD', 'quote' => true ), 'receipt_delivery_g' => array( 'value' => null, 'quote' => true ), 'acknowledgepref' => array( 'value' => null, 'quote' => true ), ) ); } function adfoin_donorperfect_send_data( $record, $posted_data ) { $record_data = json_decode( $record['data'], true ); if ( isset( $record_data['action_data']['cl'] ) && adfoin_check_conditional_logic( $record_data['action_data']['cl'], $posted_data ) ) return; $data = isset( $record_data['field_data'] ) ? $record_data['field_data'] : $record_data; $cred_id = isset( $data['credId'] ) ? $data['credId'] : ( isset( $record['cred_id'] ) ? $record['cred_id'] : '' ); $fields = array(); foreach ( $data as $k => $v ) { $parsed = adfoin_get_parsed_values( $v, $posted_data ); if ( $parsed !== '' && $parsed !== null ) $fields[ $k ] = $parsed; } if ( $record['task'] === 'create_donor' ) { adfoin_donorperfect_request( 'dp_savedonor', adfoin_donorperfect_build_donor_params( $fields ), $record, $cred_id ); } elseif ( $record['task'] === 'create_gift' ) { if ( empty( $fields['donorEmail'] ) ) return; $donor_id = adfoin_donorperfect_find_donor_id( $fields['donorEmail'], $cred_id ); if ( ! $donor_id ) return; adfoin_donorperfect_request( 'dp_savegift', adfoin_donorperfect_build_gift_params( $donor_id, $fields ), $record, $cred_id ); } }