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);
foreach ($chunks as $chunk) {
$contacts = $force->insert_batch('Contact', $chunk);
foreach ($contacts as $c) {
} else {
$ms_sql->insert('contacts', $contact->get_sql_record());
}
}
}
foreach ($sql_records as $company => $slcode) {
$insert_accounts = array();
$update_accounts = array();
foreach ($slcode as $record) {
if ($record['Account']) {
$account = new account();
$account->set_sql_fields($record['Account']);
if ($record['Contact']) {
foreach ($record['Contact'] as $c) {
$contact = new contact();
$contact->set_sql_fields($c);
$account->contacts[] = $contact;
}
}
if ($account->get_status() == 0) {
$insert_accounts[] = $account;
} elseif ($account->get_status() == 1) {
$update_accounts[] = $account;
}
}
if (count($insert_accounts) >= 200) {
// do insert handling
insert_accounts($force, $ms_sql, $insert_accounts);
$insert_accounts = array();
}
if (count($update_accounts) >= 200) {
