function SF_Account_Upsert166($entry, $form)
{
    //upload information to salesforce from the final form.
    global $wpdb;
    ini_set("soap.wsdl_cache_enabled", "0");
    $USERNAME = "******";
    //- variable that contains your Salesforce.com username (must be in the form of an email)
    $PASSWORD = "******";
    //- variable that contains your Salesforce.com password
    $TOKEN = "qhO7UhNTUrYp8XU5eF1SRomDp";
    //- variable that contains your Salesforce.com password
    require_once ABSPATH . '/soapclient/SforceEnterpriseClient.php';
    require_once ABSPATH . '/soapclient/SforceHeaderOptions.php';
    // Salesforce Login information
    $wsdl = ABSPATH . '/soapclient/eSNenterprise.wsdl.xml';
    $mySforceConnectionu = new SforceEnterpriseClient();
    $mySoapClient = $mySforceConnectionu->createConnection($wsdl);
    $mylogin = $mySforceConnectionu->login($USERNAME, $PASSWORD . $TOKEN);
    $loginname = $entry[30];
    $thenewuser = get_user_by('login', $loginname);
    if ($thenewuser) {
        $user_id = $thenewuser->ID;
    } else {
        sleep(1);
        $thenewuser = get_user_by('login', $loginname);
        $user_id = $thenewuser->ID;
    }
    $newperson = array();
    $newperson['WP_Unique_ID__c'] = $user_id;
    $newperson['WP_ID__c'] = $user_id;
    $newperson['Source__c'] = $_SERVER["SERVER_NAME"];
    $newperson['Site_Registered_On__c'] = $_SERVER["SERVER_NAME"];
    $wp_subreq_id = '21' . $entry[4];
    //21 = digital ecn [4] is email
    $newSubReq = array();
    // array for subscription
    $newSubReq['Source__c'] = "Web";
    //$newSubReq['WP_ID__c'] = $user_id;
    $newSubReq['WP_ID__c'] = substr($wp_subreq_id, 0, 20);
    //need to limit length to 20 characters
    $newSubReq["Sub_Status__c"] = 'Pending';
    $newSubReq['Personal_Question__c'] = $entry[59];
    $newSubReq['Promo_Code__c'] = "Registration";
    $newSubReq['Renewal_Link__c'] = substr(${$entry}[18], 0, 254);
    $newSubReq['Request_Date__c'] = date("Y-m-d");
    $newSubReq['Request_URL__c'] = $_SERVER["SERVER_NAME"];
    $newSubReq["Name"] = 'eCampus News Digital Subscription';
    if (!empty($entry[30])) {
        $newperson['WP_Login__c'] = strtolower($entry[30]);
    }
    if (!empty($entry[4])) {
        $newperson['PersonEmail'] = $entry[4];
        $newSubReq['Email__c'] = $entry[4];
        $newperson['Email_as_ExternalID__c'] = $entry[4];
        //12-20-2011
    }
    if (!empty($entry[1])) {
        $newperson['FirstName'] = $entry[1];
        $newSubReq['First_Name__c'] = $entry[1];
    }
    if (!empty($entry[2])) {
        $newperson['LastName'] = $entry[2];
        $newSubReq['Last_Name__c'] = $entry[2];
    }
    if (!empty($entry[61])) {
        $newperson['Unique_Title__c'] = $entry[61];
        $newSubReq['Unique_Title__c'] = $entry[61];
    }
    if (!empty($entry[3])) {
        $newperson['Organization__c'] = $entry[3];
        $newSubReq['Organization__c'] = $entry[3];
    }
    if (!empty($entry[5])) {
        $newperson['PersonTitle'] = $entry[5];
        $newSubReq['Title__c'] = $entry[5];
    }
    if (!empty($entry[6])) {
        $newperson['Company_Type__c'] = $entry[6];
        $newSubReq['Organization_Type__c'] = $entry[6];
    }
    if (!empty($entry[7])) {
        $newperson['PersonMailingStreet'] = $entry[7];
        $newSubReq['Address1__c'] = $entry[7];
    }
    if (!empty($entry[8])) {
        $newperson['Mailing_Address_2__c'] = $entry[8];
        $newSubReq['Address2__c'] = $entry[8];
    }
    if (!empty($entry[9])) {
        $newperson['PersonMailingCity'] = $entry[9];
        $newSubReq['city__c'] = $entry[9];
    }
    if (!empty($entry[10])) {
        $newperson['PersonMailingState'] = $entry[10];
        $newSubReq['State__c'] = $entry[10];
    }
    if (!empty($entry[12])) {
        $newperson['PersonMailingPostalCode'] = $entry[12];
        $newSubReq['Zip__c'] = $entry[12];
    }
    if (!empty($entry[13])) {
        $newperson['PersonMailingCountry'] = $entry[13];
        $newSubReq['Country__c'] = $entry[13];
    }
    if (!empty($entry[22])) {
        $newperson['Phone'] = $entry[22];
        $newSubReq['Phone__c'] = $entry[22];
    }
    if (!empty($entry[31])) {
        $newperson['Fax'] = $entry[31];
        $newSubReq['Fax__c'] = $entry[31];
    }
    if (!empty($entry[32])) {
        $newperson['Grade_Level__c'] = $entry[32];
    } else {
        $newperson['Grade_Level__c'] = "";
    }
    if (!empty($entry[33])) {
        $newperson['Subject_Taught__c'] = $entry[33];
    } else {
        $newperson['Subject_Taught__c'] = "";
    }
    if (!empty($entry[14])) {
        $newSubReq['Personal_Answer__c'] = $entry[14];
    }
    $OptedOutflag = 0;
    if (!empty($entry['57.1'])) {
        $newperson['ecn_today__c'] = $entry['57.1'];
        if ($entry['57.1'] == 'Subscribed') {
            $OptedOutflag = 1;
        }
    } else {
        $newperson['ecn_today__c'] = "Not Subscribed";
    }
    if (!empty($entry['57.2'])) {
        $newperson['eCN_This_Week__c'] = $entry['57.2'];
        if ($entry['57.2'] == 'Subscribed') {
            $OptedOutflag = 1;
        }
    } else {
        $newperson['eCN_This_Week__c'] = "Not Subscribed";
    }
    //	<span style="cursor:Pointer;" title="Weekly on Wednesday"> eCampus IT Leadership<img src="/wp-content/themes/advanced-newspaper/images/info14.gif" /></span>|Subscribed
    if (!empty($entry['57.3'])) {
        $newperson['eCN_IT_School_Leadership__c'] = $entry['57.3'];
        if ($entry['57.3'] == 'Subscribed') {
            $OptedOutflag = 1;
        }
    } else {
        $newperson['eCN_IT_School_Leadership__c'] = "Not Subscribed";
    }
    if (!empty($entry['57.4'])) {
        $newperson['eCN_Offers__c'] = $entry['57.4'];
        if ($entry['57.4'] == 'Subscribed') {
            $OptedOutflag = 1;
        }
    } else {
        $newperson['eCN_Offers__c'] = "Not Subscribed";
    }
    if (!empty($entry['57.5'])) {
        $newperson['eCN_Partners__c'] = $entry['57.5'];
        if ($entry['57.5'] == 'Subscribed') {
            $OptedOutflag = 1;
        }
    } else {
        $newperson['eCN_Partners__c'] = "Not Subscribed";
    }
    $newperson['eSN_Today__c'] = "Not Subscribed";
    $newperson['eSN_Tools_For_Schools__c'] = "Not Subscribed";
    $newperson['Ed_Resource_Alert__c'] = "Not Subscribed";
    $newperson['eClassroom_News__c'] = "Not Subscribed";
    $newperson['eSN_This_Week__c'] = "Not Subscribed";
    $newperson['eSN_Offers__c'] = "Not Subscribed";
    $newperson['Partner_Offers__c'] = "Not Subscribed";
    //special update unsub flag if they subscribe to anything...  else do not change it.
    if ($OptedOutflag == 1) {
        $newperson['PersonHasOptedOutOfEmail'] = false;
    }
    $upsertResponse = $mySforceConnectionu->upsert('Email_as_ExternalID__c', array($newperson), 'Account');
    //When
    if ($upsertResponse->success == 1) {
        update_user_meta($user_id, "sfid", $upsertResponse->id);
        update_user_meta($user_id, "PersonContactId", $upsertResponse->id);
        $newSubReq['Person_Account__c'] = $upsertResponse->id;
        //now that we have a new user account put in the my eschool news data if it is set
        $esm_change = '6|1|';
        $seperator = ',';
        if (isset($_POST[input_54_1]) and $_POST[input_54_1] == 213) {
            $esm_change .= '213,';
        }
        if (isset($_POST[input_54_2]) and $_POST[input_54_2] == 27) {
            $esm_change .= '27,';
        }
        if (isset($_POST[input_54_3]) and $_POST[input_54_3] == 4) {
            $esm_change .= '4,';
        }
        if (isset($_POST[input_54_4]) and $_POST[input_54_4] == 5351) {
            $esm_change .= '5351,';
        }
        if (isset($_POST[input_54_5]) and $_POST[input_54_5] == 2303) {
            $esm_change .= '2303,';
        }
        if (isset($_POST[input_54_6]) and $_POST[input_54_6] == 43) {
            $esm_change .= '43,';
        }
        if (isset($_POST[input_54_7]) and $_POST[input_54_7] == 215) {
            $esm_change .= '215,';
        }
        if (isset($_POST[input_54_8]) and $_POST[input_54_8] == 4217) {
            $esm_change .= '4217,';
        }
        if (isset($_POST[input_54_9]) and $_POST[input_54_9] == 28) {
            $esm_change .= '28,';
        }
        if (isset($_POST[input_54_11]) and $_POST[input_54_11] == 9) {
            $esm_change .= '9,';
        }
        if (isset($_POST[input_54_12]) and $_POST[input_54_12] == 26) {
            $esm_change .= '26,';
        }
        if (isset($_POST[input_54_13]) and $_POST[input_54_13] == 872) {
            $esm_change .= '872,';
        }
        if (isset($_POST[input_54_14]) and $_POST[input_54_14] == 3) {
            $esm_change .= '3,';
        }
        if (isset($_POST[input_54_15]) and $_POST[input_54_15] == 11) {
            $esm_change .= '11,';
        }
        $esm_change = trim($esm_change, $seperator);
        $key = '_myesm_esn';
        $single = true;
        update_user_meta($user_id, $key, $esm_change);
        //we did it so keep little data on the server...
    } else {
        //try again in one second...
        sleep(1);
        $upsertResponse = $mySforceConnectionu->upsert('Email_as_ExternalID__c', array($newperson), 'Account');
        if ($upsertResponse->success == 1) {
            update_user_meta($user_id, "sfid", $upsertResponse->id);
            update_user_meta($user_id, "PersonContactId", $upsertResponse->id);
            $newSubReq['Person_Account__c'] = $upsertResponse->id;
            //now that we have a new user account put in the my eschool news data if it is set
            $esm_change = '6|1|';
            $seperator = ',';
            if (isset($_POST[input_54_1]) and $_POST[input_54_1] == 213) {
                $esm_change .= '213,';
            }
            if (isset($_POST[input_54_2]) and $_POST[input_54_2] == 27) {
                $esm_change .= '27,';
            }
            if (isset($_POST[input_54_3]) and $_POST[input_54_3] == 4) {
                $esm_change .= '4,';
            }
            if (isset($_POST[input_54_4]) and $_POST[input_54_4] == 5351) {
                $esm_change .= '5351,';
            }
            if (isset($_POST[input_54_5]) and $_POST[input_54_5] == 2303) {
                $esm_change .= '2303,';
            }
            if (isset($_POST[input_54_6]) and $_POST[input_54_6] == 43) {
                $esm_change .= '43,';
            }
            if (isset($_POST[input_54_7]) and $_POST[input_54_7] == 215) {
                $esm_change .= '215,';
            }
            if (isset($_POST[input_54_8]) and $_POST[input_54_8] == 4217) {
                $esm_change .= '4217,';
            }
            if (isset($_POST[input_54_9]) and $_POST[input_54_9] == 28) {
                $esm_change .= '28,';
            }
            if (isset($_POST[input_54_11]) and $_POST[input_54_11] == 9) {
                $esm_change .= '9,';
            }
            if (isset($_POST[input_54_12]) and $_POST[input_54_12] == 26) {
                $esm_change .= '26,';
            }
            if (isset($_POST[input_54_13]) and $_POST[input_54_13] == 872) {
                $esm_change .= '872,';
            }
            if (isset($_POST[input_54_14]) and $_POST[input_54_14] == 3) {
                $esm_change .= '3,';
            }
            if (isset($_POST[input_54_15]) and $_POST[input_54_15] == 11) {
                $esm_change .= '11,';
            }
            $esm_change = trim($esm_change, $seperator);
            $key = '_myesm_esn';
            $single = true;
            update_user_meta($user_id, $key, $esm_change);
        } else {
            //mail('*****@*****.**','SF User UPloaded FAILED 2nd try',print_r($sfaccountresponse));
        }
    }
    if (!empty($entry[48])) {
        //check if they want the pub, if so upload it, in a custom object so we cannot just add it if it is eSchool News.
        if ($entry[48] == 'Yes') {
            // add subscription
            $upsertResponse2 = $mySforceConnectionu->upsert('WP_ID__c', array($newSubReq), 'Subscription_Request__c');
            if ($upsertResponse2->success == 1) {
            } else {
                //try again
                sleep(1);
                $upsertResponse2 = $mySforceConnectionu->upsert('WP_ID__c', array($newSubReq), 'Subscription_Request__c');
            }
        }
    }
    $user_login = $entry[30];
    //use the input if of the username
    $user_pass = $entry[47];
    //use the input if of the password
    //pass the above to the wp_signon function
    $user = wp_signon(array('user_login' => $user_login, 'user_password' => $user_pass, 'remember' => true));
    //check if we need to give a message.
    if (!empty($entry[48]) and $entry[48] == 'No') {
        if ($upsertResponse->success == 1) {
            if ($_GET['redirect_to']) {
                $redirectto = $_GET['redirect_to'];
                $reditchk = strpos($redirectto, "eschoolnews");
                if ($reditchk > 1) {
                    //we are ok no need to do anything...
                } else {
                    $redirectto = 'http://www.eschoolnews.com/';
                }
                wp_safe_redirect($redirectto);
                sleep(2);
                exit;
                break;
            }
        }
    } else {
        if (!empty($entry[48])) {
            if ($upsertResponse2->success == 1) {
                if ($_GET['redirect_to']) {
                    $redirectto = $_GET['redirect_to'];
                    $reditchk = strpos($redirectto, "eschoolnews");
                    if ($reditchk > 1) {
                        //we are ok no need to do anything...
                    } else {
                        $redirectto = 'http://www.eschoolnews.com/';
                    }
                    wp_safe_redirect($redirectto);
                    sleep(2);
                    exit;
                    break;
                }
            }
        }
    }
    $formsuccess = validateint($_GET['success']);
}
Esempio n. 2
0
function SF_Account_Upsert($entry, $form)
{
    global $wpdb;
    $user_email = $entry[4];
    ini_set("soap.wsdl_cache_enabled", "0");
    $USERNAME = "******";
    //- variable that contains your Salesforce.com username (must be in the form of an email)
    $PASSWORD = "******";
    //- variable that contains your Salesforce.com password
    $TOKEN = "qhO7UhNTUrYp8XU5eF1SRomDp";
    //- variable that contains your Salesforce.com password
    require_once ABSPATH . '/soapclient/SforceEnterpriseClient.php';
    require_once ABSPATH . '/soapclient/SforceHeaderOptions.php';
    // Salesforce Login information
    $wsdl = ABSPATH . '/soapclient/eSNenterprise.wsdl.xml';
    $mySforceConnectionu = new SforceEnterpriseClient();
    $mySoapClient = $mySforceConnectionu->createConnection($wsdl);
    $mylogin = $mySforceConnectionu->login($USERNAME, $PASSWORD . $TOKEN);
    //determine site we are on - ecampus, eclassroom, or enews
    $sitesource = $entry[26];
    $entrysubtype = $entry[21];
    if ($entrysubtype == 'Print') {
        $pubsubtype = "Print";
        $pubforid = 1;
    } else {
        $pubsubtype = "Digital";
        $pubforid = 2;
    }
    if ($sitesource !== "") {
        $school = strpos($sitesource, "eschoolnews");
        $campus = strpos($sitesource, "ecampusnews");
        $classroom = strpos($sitesource, "eclassroomnews");
    } else {
        $school = strpos($_SERVER["SERVER_NAME"], "eschoolnews");
        $campus = strpos($_SERVER["SERVER_NAME"], "ecampusnews");
        $classroom = strpos($_SERVER["SERVER_NAME"], "eclassroomnews");
    }
    if ($school !== false) {
        $name = 'eSchoolNews ' . $pubsubtype . ' Subscription';
        $linksource = "eschoolnews";
        $pubforid = $pubforid . '1';
    } elseif ($campus !== false) {
        $name = 'eCampusNews ' . $pubsubtype . ' Subscription';
        $linksource = "ecampusnews";
        $pubforid = $pubforid . '2';
    } elseif ($classroom !== false) {
        $newSubReq["Name"] = 'eClassroomNews ' . $pubsubtype . ' Subscription';
        $linksource = "eclassroomnews";
        $pubforid = $pubforid . '3';
    } else {
        $name = 'Unknown';
        $linksource = "Unk";
        $pubforid = $pubforid . '4';
    }
    //query sfdc to see if user exists based on email address
    $sfaccountdataquery = "Select Id, WP_Unique_ID__c from Account where Email_as_ExternalID__c ='" . $user_email . "' and IsPersonAccount=true";
    $sfaccountresponse = $mySforceConnectionu->query($sfaccountdataquery);
    $wp_id = "";
    //create array for account to get upserted
    $newperson = array();
    if (count($sfaccountresponse->records) > 0) {
        $wp_id = $sfaccountresponse->records[0]->WP_Unique_ID__c;
    } else {
        //see if user is in WP and get id
        $wp_id = $wpdb->get_var($wpdb->prepare("SELECT ID FROM {$WPDB->USERS} WHERE USER_EMAIL='" . $user_email . "'"));
        $newperson['Source__c'] = $_SERVER["SERVER_NAME"];
        //only want to populate source when first creating person account
    }
    if (is_null($wp_id)) {
        $wp_id = $user_email;
    }
    $newperson['WP_Unique_ID__c'] = $wp_id;
    //query sfdc subscription request object to see if there is an existing pending subscription request
    $sfsubreqdataquery = "Select Id, wp_id__c, sub_status__c, Title__c, name from Subscription_Request__c where Email__c = '" . $user_email . "' and Sub_Status__c = 'Pending' and name = '" . $name . "'";
    $sfsubreqresponse = $mySforceConnectionu->query($sfsubreqdataquery);
    if (count($sfsubreqresponse->records) > 0) {
        $wp_subreq_id = $pubforid . $sfsubreqresponse->records[0]->WP_ID__c;
    } else {
        //there is no sub request record, need to create an external id
        //echo 'No Pending'.PHP_EOL;
        $sfcountquery = "Select id from Subscription_Request__c where Email__c = '" . $user_email . "'";
        $sfcountresponse = $mySforceConnectionu->query($sfcountquery);
        //echo 'count '.$sfcountresponse->size;
        $reccount = $sfcountresponse->size + 1;
        $wp_subreq_id = $pubforid . $user_email;
        //$wp_subreq_id = $pubforid . $reccount.$user_email;
    }
    //create new array for subscription request to be upserted
    $newSubReq = array();
    $newSubReq['Source__c'] = "Web";
    $newSubReq['WP_ID__c'] = substr($wp_subreq_id, 0, 20);
    //need to limit length to 20 characters
    //echo $newSubReq['WP_ID__c'].PHP_EOL.PHP_EOL;
    $newSubReq["Sub_Status__c"] = 'Pending';
    $newSubReq['Personal_Question__c'] = "What was your high school mascot?";
    $newSubReq['Request_URL__c'] = $_SERVER["SERVER_NAME"];
    $newSubReq["Name"] = $name;
    $newSubReq['Request_Date__c'] = date("Y-m-d");
    $sfFEIDquery = "Select feid__c, wp_id__c from Subscription_Request__c where Email__c = '" . $user_email . "' and Sub_Status__c = 'Processed' and name = '" . $name . "'";
    $sfFEIDresponse = $mySforceConnectionu->query($sfFEIDquery);
    if (count($sfFEIDresponse->records) > 0) {
        //echo 'Processed Found'.PHP_EOL;
        //echo 'wp id = '.$sfFEIDresponse->records[0]->WP_ID__C.PHP_EOL;
        $newSubReq['FEID__c'] = $sfFEIDresponse->records[0]->FEID__c;
    }
    if (!empty($entry[4])) {
        //if (strpos($entry[4], 'esmnoemailsupplied') !== false) {
        $newperson['PersonEmail'] = $entry[4];
        $newSubReq['Email__c'] = $entry[4];
        $newperson['Email_as_ExternalID__c'] = $entry[4];
        //12-20-2011
        //}
    }
    if (!empty($entry[1])) {
        $newperson['FirstName'] = $entry[1];
        $newSubReq['First_Name__c'] = $entry[1];
    }
    if (!empty($entry[2])) {
        $newperson['LastName'] = $entry[2];
        $newSubReq['Last_Name__c'] = $entry[2];
    }
    if (!empty($entry[3])) {
        $newperson['Organization__c'] = $entry[3];
        $newSubReq['Organization__c'] = $entry[3];
    }
    if (!empty($entry[5])) {
        $newperson['PersonTitle'] = $entry[5];
        $newSubReq['Title__c'] = $entry[5];
    }
    if (!empty($entry[6])) {
        $newperson['Company_Type__c'] = $entry[6];
        $newSubReq['Organization_Type__c'] = $entry[6];
    }
    if (!empty($entry[7])) {
        $newperson['PersonMailingStreet'] = $entry[7];
        $newSubReq['Address1__c'] = $entry[7];
    }
    if (!empty($entry[8])) {
        $newperson['Mailing_Address_2__c'] = $entry[8];
        $newSubReq['Address2__c'] = $entry[8];
    }
    if (!empty($entry[9])) {
        $newperson['PersonMailingCity'] = $entry[9];
        $newSubReq['city__c'] = $entry[9];
    }
    if (!empty($entry[10])) {
        $newperson['PersonMailingState'] = $entry[10];
        $newSubReq['State__c'] = $entry[10];
    }
    if (!empty($entry[12])) {
        $newperson['PersonMailingPostalCode'] = $entry[12];
        $newSubReq['Zip__c'] = $entry[12];
    }
    if (!empty($entry[13])) {
        $newperson['PersonMailingCountry'] = $entry[13];
        $newSubReq['Country__c'] = $entry[13];
    }
    if (!empty($entry[22])) {
        $newperson['Phone'] = $entry[22];
        $newSubReq['Phone__c'] = $entry[22];
    }
    if (!empty($entry[23])) {
        $newperson['Grade_Level__c'] = $entry[23];
    }
    if (!empty($entry[24])) {
        $newperson['Subject_Taught__c'] = $entry[24];
    }
    if (!empty($entry[25])) {
        $newperson['Industry__c'] = $entry[25];
    }
    if (!empty($entry[14])) {
        $newSubReq['Personal_Answer__c'] = $entry[14];
    }
    if (!empty($entry[29])) {
        $newSubReq['Promo_Code__c'] = $entry[29];
    }
    $upsertResponse = $mySforceConnectionu->upsert('Email_as_ExternalID__c', array($newperson), 'Account');
    //echo '<pre> 189<br>';
    //echo print_r($upsertResponse);
    //echo '</pre>';
    if ($upsertResponse->success == 1) {
        update_user_meta($user_id, "sfid", $upsertResponse->id);
        $sfaccountdataquery = "Select Id, PersonContactId from Account where PersonEmail ='" . $entry[4] . "'";
        $sfaccountresponse = $mySforceConnectionu->query($sfaccountdataquery);
        $sfAccountid = $sfaccountresponse->records[0]->Id;
        //	echo '<pre> 195<br>';
        //echo print_r($sfaccountresponse);
        //mail('*****@*****.**','SF Subscription upserted account', print_r($sfaccountresponse).print_r($sfAccountid));
        //echo '</pre>';
        //since upserted account successfully, now upsert sub request
        //get the person account id just created to use in the subscription request record
        $newSubReq['Person_Account__c'] = $sfAccountid;
        //need to set renewal link
        $isrenewal = strpos($entry[source_url], 'sfid');
        if ($isrenewal !== false) {
            $renewalurl = substr($entry[source_url], 0, $isrenewal) . 'sfid=' . $sfAccountid . '&source=' . $linksource;
        } else {
            if (strpos($entry[source_url], '?' !== false)) {
                $renewalurl = $entry[source_url] . '&sfid=' . $sfAccountid . '&source=' . $linksource;
            } else {
                $renewalurl = $entry[source_url] . '?sfid=' . $sfAccountid . '&source=' . $linksource;
            }
        }
        $newSubReq['Renewal_Link__c'] = substr($renewalurl, 0, 254);
        $upsertResponse2 = $mySforceConnectionu->upsert('WP_ID__c', array($newSubReq), 'Subscription_Request__c');
        //echo '<pre> 220<br>' . $Subscription_Request__c;
        //print_r($newSubReq);
        //print_r($sfaccountresponse);
        //echo '</pre>';
        if ($upsertResponse2->success == 1) {
            print_r($sfaccountresponse);
            //mail('*****@*****.**','SF Subscription request upload success','we are ok');
        } else {
            //mail('*****@*****.**','SF Subscription Request UPload FAILED', print_r($newSubReq).print_r($upsertResponse2));
        }
    } else {
        //mail('*****@*****.**','SF Subscription form UPload FAILED',print_r($sfaccountresponse));
        //mail('*****@*****.**','an SF Subscription account upload FAILED ','Email address that failed is '.$user_email);
        //echo '<pre> 236<br>';
        //print_r($newSubReq);
        //print_r($sfaccountresponse);
        //echo '</pre>';
    }
}
Esempio n. 3
0
         }
     }
     ini_set("soap.wsdl_cache_enabled", "0");
     $USERNAME = "******";
     //- variable that contains your Salesforce.com username (must be in the form of an email)
     $PASSWORD = "******";
     //- variable that contains your Salesforce.com password
     $TOKEN = "qhO7UhNTUrYp8XU5eF1SRomDp";
     //- variable that contains your Salesforce.com password
     define("SOAP_CLIENT_BASEDIR", "./soapclient");
     require_once SOAP_CLIENT_BASEDIR . '/SforceEnterpriseClient.php';
     require_once SOAP_CLIENT_BASEDIR . '/SforceHeaderOptions.php';
     $mySforceConnectionu = new SforceEnterpriseClient();
     $mySoapClient = $mySforceConnectionu->createConnection(SOAP_CLIENT_BASEDIR . '/eSNenterprise.wsdl.xml');
     $mylogin = $mySforceConnectionu->login($USERNAME, $PASSWORD . $TOKEN);
     $upsertResponse = $mySforceConnectionu->upsert('Email_as_ExternalID__c', array($changeemailsubs), 'Account');
     if ($upsertResponse->success == 1) {
         // echo print_r($upsertResponse);
     } else {
         if (isset($_POST['all_newsletters'])) {
             $wpdb->query($wpdb->prepare("INSERT INTO emailsuppression (txtemail, dtdateadd, txtipaddress) VALUES (%s, %s, %s )", $unsubemailb, $dtDate, $txtIP));
         } else {
             mail('*****@*****.**', 'FAILED UNSUBSCRIBE REQUEST USER NOT FOUND IN SF', $message);
             $wpdb->query($wpdb->prepare("INSERT INTO emailsuppression (txtemail, dtdateadd, txtipaddress) VALUES (%s, %s, %s )", $unsubemailb, $dtDate, $message));
         }
     }
 } else {
     if (isset($_POST['all_newsletters'])) {
         $wpdb->query($wpdb->prepare("INSERT INTO emailsuppression (txtemail, dtdateadd, txtipaddress) VALUES (%s, %s, %s )", $unsubemailb, $dtDate, $txtIP));
     } else {
         if (isset($_POST['eschool_news_this_week'])) {
Esempio n. 4
0
function SF_Account_Upsert226($entry, $form)
{
    global $wpdb;
    ini_set("soap.wsdl_cache_enabled", "0");
    $USERNAME = "******";
    //- variable that contains your Salesforce.com username (must be in the form of an email)
    $PASSWORD = "******";
    //- variable that contains your Salesforce.com password
    $TOKEN = "qhO7UhNTUrYp8XU5eF1SRomDp";
    //- variable that contains your Salesforce.com password
    require_once ABSPATH . '/soapclient/SforceEnterpriseClient.php';
    require_once ABSPATH . '/soapclient/SforceHeaderOptions.php';
    // Salesforce Login information
    $wsdl = ABSPATH . '/soapclient/eSNenterprise.wsdl.xml';
    $mySforceConnectionu = new SforceEnterpriseClient();
    $mySoapClient = $mySforceConnectionu->createConnection($wsdl);
    $mylogin = $mySforceConnectionu->login($USERNAME, $PASSWORD . $TOKEN);
    $loginname = $entry[30];
    $thenewuser = get_user_by('login', $loginname);
    if ($thenewuser) {
        $user_id = $thenewuser->ID;
    } else {
        sleep(1);
        $thenewuser = get_user_by('login', $loginname);
        $user_id = $thenewuser->ID;
    }
    $newperson = array();
    $newperson['WP_Unique_ID__c'] = $user_id;
    $newperson['WP_ID__c'] = $user_id;
    $newperson['Source__c'] = $_SERVER["SERVER_NAME"];
    $newperson['Site_Registered_On__c'] = $_SERVER["SERVER_NAME"];
    $wp_subreq_id = '21' . $entry[4];
    //21 = digital ecn [4] is email
    if (!empty($entry[4])) {
        $newperson['PersonEmail'] = $entry[4];
        $newSubReq['Email__c'] = $entry[4];
        $newperson['Email_as_ExternalID__c'] = $entry[4];
    }
    if (!empty($entry[1])) {
        $newperson['FirstName'] = $entry[1];
        $newSubReq['First_Name__c'] = $entry[1];
    }
    if (!empty($entry[2])) {
        $newperson['LastName'] = $entry[2];
        $newSubReq['Last_Name__c'] = $entry[2];
    }
    if (!empty($entry[61])) {
        $newperson['Unique_Title__c'] = $entry[61];
        $newSubReq['Unique_Title__c'] = $entry[61];
    }
    if (!empty($entry[5])) {
        $newperson['PersonTitle'] = $entry[5];
        $newSubReq['Title__c'] = $entry[5];
    }
    $OptedOutflag = 0;
    if (!empty($entry['57.1'])) {
        $newperson['eSN_This_Week__c'] = $entry['57.1'];
        if ($entry['57.1'] == 'Subscribed') {
            $OptedOutflag = 1;
        }
    } else {
        $newperson['eSN_This_Week__c'] = "Not Subscribed";
    }
    if (!empty($entry['57.2'])) {
        $newperson['eSN_Today__c'] = $entry['57.2'];
        if ($entry['57.2'] == 'Subscribed') {
            $OptedOutflag = 1;
        }
    } else {
        $newperson['eSN_Today__c'] = "Not Subscribed";
    }
    if (!empty($entry['57.3'])) {
        $newperson['eSN_IT_School_Leadership__c'] = $entry['57.3'];
        if ($entry['57.3'] == 'Subscribed') {
            $OptedOutflag = 1;
        }
    } else {
        $newperson['eSN_IT_School_Leadership__c'] = "Not Subscribed";
    }
    if (!empty($entry['57.4'])) {
        /* Check on this field */
        $newperson['MyeCN_EdTech_Leadership__c'] = $entry['57.4'];
        if ($entry['57.4'] == 'Subscribed') {
            $OptedOutflag = 1;
        }
    } else {
        $newperson['MyeCN_EdTech_Leadership__c'] = "Not Subscribed";
    }
    if (!empty($entry['57.5'])) {
        $newperson['eCN_Today__c'] = $entry['57.5'];
        if ($entry['57.5'] == 'Subscribed') {
            $OptedOutflag = 1;
        }
    } else {
        $newperson['eCN_Today__c'] = "Not Subscribed";
    }
    if (!empty($entry['57.6'])) {
        $newperson['eCN_This_Week__c'] = $entry['57.6'];
        if ($entry['57.6'] == 'Subscribed') {
            $OptedOutflag = 1;
        }
    } else {
        $newperson['eCN_This_Week__c'] = "Not Subscribed";
    }
    if (!empty($entry['57.7'])) {
        $newperson['eCN_IT_School_Leadership__c'] = $entry['57.7'];
        if ($entry['57.7'] == 'Subscribed') {
            $OptedOutflag = 1;
        }
    } else {
        $newperson['eCN_IT_School_Leadership__c'] = "Not Subscribed";
    }
    if (!empty($entry['57.8'])) {
        $newperson['eClassroom_News__c'] = $entry['57.8'];
        if ($entry['57.8'] == 'Subscribed') {
            $OptedOutflag = 1;
        }
    } else {
        $newperson['eClassroom_News__c'] = "Not Subscribed";
    }
    $newperson['eSN_Offers__c'] = "Not Subscribed";
    $newperson['Partner_Offers__c'] = "Not Subscribed";
    $newperson['eCN_Offers__c'] = "Not Subscribed";
    $newperson['eCN_Partners__c'] = "Not Subscribed";
    //special update unsub flag if they subscribe to anything...  else do not change it.
    if ($OptedOutflag == 1) {
        $newperson['PersonHasOptedOutOfEmail'] = false;
    }
    $upsertResponse = $mySforceConnectionu->upsert('Email_as_ExternalID__c', array($newperson), 'Account');
    if ($upsertResponse->success == 1) {
        //Saved for later use
        mail('*****@*****.**', '226 SF Subscription request success', 'line 138');
    } else {
        $upsertResponse = $mySforceConnectionu->upsert('Email_as_ExternalID__c', array($newperson), 'Account');
        mail('*****@*****.**', '226 SF Subscription request failed', 'line 142');
    }
    $formsuccess = validateint($_GET['success']);
}