//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) {