<?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));
}
