//echo "<pre>", print_r($Bean), "</pre>"; die();
$User = $Bean->get_full_list('', "users.rowid_tercero=" . $row['f200_rowid']);
if (count($User)) {
$Bean = $User[0];
if ($Bean->codigo_erp != $row['f210_id'] || $Bean->identificacion != $row['f200_id'] || $Bean->first_name != $row['f200_nombres'] || $Bean->last_name != $row['f200_apellido1'] . " " . $row['f200_apellido2'] || $Bean->rowid_tercero != $row['f200_rowid']) {
set_bean($Bean, $row);
$update = $Bean->save();
if ($update) {
$actualizadas[$row['f200_rowid']] = array($row['f200_id'], $row['f200_nombres'], $row['f200_apellido1'], $Bean->id);
}
} else {
$no_actualizadas[$row['f200_rowid']] = array($row['f200_id'], $row['f200_nombres'], $row['f200_apellido1'], $Bean->id);
}
} else {
$Bean = BeanFactory::newBean('Users');
set_bean($Bean, $row);
$save = $Bean->save();
if ($save) {
$creadas[$row['f200_rowid']] = array($row['f200_id'], $row['f200_nombres'], $row['f200_apellido1'], $Bean->id);
} else {
$con_error[$row['f200_rowid']] = array($row['f200_id'], $row['f200_nombres'], $row['f200_apellido1'], $Bean->id);
}
}
}
$GLOBALS['log']->fatal("Sync Vendedores Ejecutada");
$html = "<h1>Actualizadas exitosamente (" . count($actualizadas) . ")</h1>";
$html .= "<table border='1'>\n <thead>\n <tr>\n <td>Nit</td>\n <td>Nombre</td>\n <td>Apellido</td>\n <td>ID</td>\n </tr>\n </thead>\n <tbody>";
foreach ($actualizadas as $iden => $arr) {
$html .= "<tr><td>{$arr['0']}</td><td>{$arr['1']}</td><td>{$arr['2']}</td><td>{$arr['3']}</td></tr>";
}
$html .= "</tbody></table>";
if (count($Account)) {
/*echo "<pre>";
print_r($row);
echo "</pre>";
die;*/
$Bean = $Account[0];
if ($Bean->rowid_tercero != $row['ROWID'] || $Bean->id_sucursal != $row['ID_SUCURSAL'] || $Bean->identificacion != $row['NIT'] || $Bean->nombre_establecimiento != $row['NOMBRE_EST'] || $Bean->tipo_cliente != $row['TIPCLI'] || $Bean->name != $row['NOMBRE'] || $Bean->razon_social != $row['RAZON_SOC'] || $Bean->phone_office != $row['TELF'] || $Bean->phone_fax != $row['FAX'] || $Bean->fecha_nacimiento != date('Y-m-d', strtotime($row['FECHA_NAC'])) || $Bean->billing_address_street != $row['DIR1'] . " " . $row['DIR2'] . " " . $row['DIR3'] || $Bean->billing_address_postalcode != $row['BARRIO'] || $Bean->billing_address_city != $row['CIUDAD'] || $Bean->billing_address_state != $row['DEPTO'] || $Bean->billing_address_country != $row['PAIS'] || $Bean->shipping_address_street != $row['DIR1_PENV'] || $Bean->shipping_address_postalcode != $row['BARRIO_PENV'] || $Bean->shipping_address_city != $row['CIUDAD_PENV'] || $Bean->shipping_address_state != $row['DEPTO_PENV'] || $Bean->shipping_address_country != $row['PAIS_PENV'] || $Bean->assigned_user_id != $row['ID_user'] || $Bean->bloqueadocupo != $row['F201_IND_BLOQUEO_CUPO'] || $Bean->bloqueadomora != $row['F201_IND_BLOQUEO_MORA']) {
set_bean($Bean, $row, $planes_cliente);
$update = $Bean->save();
if ($update) {
$actualizadas[$row_id . '_' . $suc_id] = array($nit, $suc_id, $nombre, $Bean->id);
}
}
} else {
$Bean = BeanFactory::newBean('Accounts');
set_bean($Bean, $row, $planes_cliente);
$save = $Bean->save();
/*echo "<pre>";
print_r($row);
echo "</pre>";*/
if ($save) {
$creadas[$row_id . '_' . $suc_id] = array($nit, $suc_id, $nombre);
} else {
$con_error[$row_id . '_' . $suc_id] = array($nit, $suc_id, $nombre);
}
}
}
$GLOBALS['log']->fatal("Sync Clientes Ejecutada");
$html = "<h1>Actualizadas exitosamente (" . count($actualizadas) . ")</h1>";
$html .= "<table border='1'>\n <thead>\n <tr>\n <td>Nit</td>\n <td>Sucursal</td>\n <td>Nombre</td>\n <td>ID</td>\n </tr>\n </thead>\n <tbody>";
foreach ($actualizadas as $iden => $arr) {
