<?php require_once 'helpers.php'; require_once 'account.php'; require_once 'contact.php'; require_once 'product.php'; require_once 'sql_init.php'; require_once 'salesforce_ins.php'; $ms_sql = new SQL_C(); $force = new salesforce_ins(); $ms_con = $ms_sql->get_connection(); if ($ms_con && $force->get_connection()) { echo "Connection established.<br />"; $query1 = 'SELECT c.*,a.SF_ID as account_id,a.SMAN as owner_id from contacts c LEFT JOIN account a ON c.SLCODE = a.SLCODE WHERE c.SYNCH_STATUS IN (0,1)'; $res1 = sqlsrv_query($ms_con, $query1); $contacts = array(); while ($row = sqlsrv_fetch_array($res1, SQLSRV_FETCH_ASSOC)) { $contact = new contact(); $contact->set_sql_fields($row); if (!empty($row['account_id'])) { $contact->set_account($row['account_id']); } if (!empty($row['owner_id'])) { $contact->set_owner_id($row['owner_id']); } if ($row['CONTACT_LAST_NAME']) { $contacts[] = $contact; } } echo count($contacts); $chunks = array_chunk($contacts, 1);
<?php require_once 'helpers.php'; require_once 'account.php'; require_once 'contact.php'; require_once 'product.php'; require_once 'sql_init.php'; require_once 'salesforce_ins.php'; $tac = TRUE; $ms_sql = new SQL_C(); $force = new salesforce_ins(); if ($ms_sql->get_connection() && $force->get_connection()) { echo "Connection established.<br />"; $force_records = $tac ? $force->get_records() : array(); $sql_records = $tac ? $ms_sql->get_records() : array(); $acc_slcode = $ms_sql->get_primary_key('account', 'SLCODE'); $con_slcode = $ms_sql->get_primary_key('contacts', 'SLCODE'); $account = new account($acc_slcode); foreach ($force_records as $record) { if (isset($record->Id)) { $account->set_sf_fields($record); $existing_record = $ms_sql->get_record_sf_id('account', $record->Id); if ($existing_record) { $ms_sql->update('account', $account->compare_for_sql($existing_record), $record->Id); } else { $ms_sql->insert('account', $account->get_sql_record()); } $contact = new contact(array($account->get_primary_keys()['SLCODE'], 0)); } else { $contact = new contact(array($con_slcode, 0)); }