protected function load()
{
$db = new DB_Sql();
$sql = "SELECT art, indhold FROM kortkursus_tilmelding_oplysninger\r\n WHERE tilmelding_id = '" . $this->tilmelding->get('id') . "'";
$db->query($sql);
while ($db->nextRecord()) {
$this->value[$db->f('art')] = $db->f('indhold');
}
return true;
}
function getList($type = '')
{
$value = array();
$i = 0;
$db = new DB_Sql();
if ($type == 'all') {
$db->query("SELECT *, DATE_FORMAT(date_created, '%d-%m-%Y %H:%i') AS date_dk FROM materialebestilling ORDER BY date_created");
} else {
$db->query("SELECT *, DATE_FORMAT(date_created, '%d-%m-%Y %H:%i') AS date_dk FROM materialebestilling WHERE er_sendt = 0 ORDER BY date_created");
}
while ($db->nextRecord()) {
$value[$i]['id'] = $db->f('id');
$value[$i]['navn'] = $db->f('navn');
$value[$i]['adresse'] = $db->f('adresse');
$value[$i]['postnr'] = $db->f('postnr');
$value[$i]['postby'] = $db->f('postby');
$value[$i]['email'] = $db->f('email');
$value[$i]['telefon'] = $db->f('telefon');
$value[$i]['langekurser'] = $db->f('langekurser');
$value[$i]['kortekurser'] = $db->f('kortekurser');
$value[$i]['kursuscenter'] = $db->f('kursuscenter');
$value[$i]['efterskole'] = $db->f('efterskole');
$value[$i]['besked'] = $db->f('besked');
$value[$i]['date_dk'] = $db->f('date_dk');
$value[$i]['er_sendt'] = $db->f('er_sendt');
$i++;
}
return $value;
}
public function getList($show = "open")
{
$sql_ekstra = "";
switch ($show) {
case 'åbne':
// fall through
// fall through
case 'open':
$sql_ekstra = "published = 1 AND DATE_ADD(dato_start, INTERVAL 14 DAY) > NOW()";
break;
case 'aktuelle':
$sql_ekstra = "dato_slut > NOW()";
break;
case 'intranet':
$sql_ekstra = "dato_slut > DATE_SUB(NOW(), INTERVAL 400 DAY)";
break;
case 'old':
$sql_ekstra = "dato_slut > DATE_SUB(NOW(), INTERVAL 3650 DAY)";
break;
default:
$sql_ekstra = " 1 = 1";
break;
}
$db = new DB_Sql();
$db->query("SELECT id FROM langtkursus WHERE " . $sql_ekstra . " AND active = 1 ORDER BY dato_start ASC, dato_slut DESC, belong_to ASC, navn ASC");
$kurser = array();
while ($db->nextRecord()) {
$kurser[] = new VIH_Model_LangtKursus($db->f('id'));
}
return $kurser;
}
public function get($art)
{
if (!empty($this->info[$art])) {
return $this->info[$art];
}
$art = trim(strip_tags(mysql_escape_string($art)));
$sql = "SELECT art, indhold FROM kortkursus_deltager_oplysninger_ny\r\n WHERE deltager_id = '" . $this->deltager->get('id') . "'";
$db = new DB_Sql();
$db->query($sql);
while ($db->nextRecord()) {
$this->info[$db->f('art')] = $db->f('indhold');
}
if (!empty($this->info[$art])) {
return $this->info[$art];
}
}
private function init()
{
$db = new DB_Sql();
$db->query("SELECT id FROM langtkursus_tilmelding WHERE session_id = '" . $this->session_id . "'");
if ($db->nextRecord()) {
parent::__construct($db->f('id'));
}
}
public static function getList()
{
$db = new DB_Sql();
$db->query("SELECT id FROM langtkursus_fag_gruppe WHERE active = 1");
$grp = array();
while ($db->nextRecord()) {
$grp[] = new VIH_Model_Fag_Gruppe($db->f('id'));
}
return $grp;
}
function renderHtml()
{
$get = $this->query();
if (1 == 2 and !empty($get['date']['Y'])) {
$date = $get['date']['Y'] . '-' . $get['date']['M'] . '-' . $get['date']['d'];
} elseif (!empty($get['date'])) {
$date = $get['date'];
} else {
$date = date('Y-m-d');
}
$this->getForm()->setDefaults(array('date' => $date));
$db = new DB_Sql();
// Tr�kker alle ud p� den p�g�ldende holdliste
$db->query("SELECT DISTINCT(tilmelding.id) AS id, x_fag.hold, x_fag.id AS hold_id\r\n FROM langtkursus_tilmelding tilmelding\r\n INNER JOIN langtkursus ON langtkursus.id = tilmelding.kursus_id\r\n INNER JOIN adresse ON tilmelding.adresse_id = adresse.id\r\n INNER JOIN langtkursus_tilmelding_x_fag x_fag ON tilmelding.id = x_fag.tilmelding_id\r\n INNER JOIN langtkursus_fag f*g ON x_fag.fag_id = f*g.id\r\n INNER JOIN langtkursus_fag_periode periode ON langtkursus.id = periode.langtkursus_id\r\n WHERE\r\n (\r\n (tilmelding.dato_start <= '{$date}' AND tilmelding.dato_slut >= '{$date}')\r\n OR (tilmelding.dato_slut = '0000-00-00' AND langtkursus.dato_start <= '{$date}' AND langtkursus.dato_slut >= '{$date}'))\r\n AND tilmelding.active = 1 AND x_fag.fag_id = " . $this->name() . " AND (periode.date_start <= '{$date}' AND periode.date_end >= '{$date}')\r\n AND (periode.date_start <= '{$date}' AND periode.date_end >= '{$date}' AND x_fag.periode_id = periode.id)\r\n ORDER BY x_fag.hold ASC, adresse.fornavn ASC");
$list = array();
while ($db->nextRecord()) {
$list[$db->f('id')] = new VIH_Model_LangtKursus_Tilmelding($db->f('id'));
$list[$db->f('id')]->value['hold'] = (int) $db->f('hold');
$list[$db->f('id')]->value['hold_id'] = (int) $db->f('hold_id');
}
$f*g = new VIH_Model_Fag($this->name());
// skal hente holdnumrene for den p�g�ldende tilmelding
$data = array('tilmeldinger' => $list);
// $this->getForm()->toHTML()
// echo $date;
$this->document->setTitle($f*g->get('navn'));
$tpl = $this->template->create('VIH/Intranet/view/holdlister/holdliste');
return '<p>' . count($list) . '</p>' . $date . $this->render($this, $data);
}
function get_db_value($sql = '', $default = '')
{
$this->connect_to_db();
$this->enable_data = FALSE;
$sql = trim($sql);
if (mb_strlen($sql) > 0) {
$this->set_sql($sql);
}
$this->db->query($this->sql);
$this->after_query();
if ($this->db->next_record()) {
$this->enable_data = TRUE;
return $this->db->f(0);
} else {
return $default;
}
}
function _is_jubilar($auth)
{
$jubilar = false;
$db = new DB_Sql();
$db->query("SELECT aargange FROM elevforeningen_jubilar ORDER BY id DESC");
if ($db->nextRecord()) {
$jubilar_aargange = array_values(unserialize($db->f('aargange')));
}
$contact = $auth->get();
$keywords = $auth->contact_client->getConnectedKeywords($contact['id']);
$jubilar = false;
if (is_array($keywords)) {
foreach ($keywords as $key => $value) {
if (in_array($value, $jubilar_aargange)) {
$jubilar = true;
}
}
}
return $jubilar;
}
function load()
{
$db = new DB_Sql();
$sql = "SELECT id, fornavn, efternavn, adresse, postnr, postby, arbejdstelefon, telefon, mobil, email FROM adresse WHERE id = " . $this->id . " LIMIT 1";
$db->query($sql);
if (!$db->nextRecord()) {
return 0;
}
$this->id = $db->f('id');
$this->value['id'] = $db->f('id');
$this->value['navn'] = trim($db->f('fornavn') . ' ' . $db->f('efternavn'));
$this->value['fornavn'] = $db->f('fornavn');
$this->value['efternavn'] = $db->f('efternavn');
$this->value['adresse'] = $db->f('adresse');
$this->value['postnr'] = $db->f('postnr');
$this->value['postby'] = $db->f('postby');
$this->value['arbejdstelefon'] = $db->f('arbejdstelefon');
$this->value['telefon'] = $db->f('telefon');
$this->value['mobil'] = $db->f('mobil');
$this->value['email'] = $db->f('email');
return 1;
}
// --------------------------------------------------
$sql2 = "\n SELECT *\n FROM Z_MS_LOG\n where Action_Description like '%draft%' and Action_Description like '%{$bl}%'\n ";
$db2->query($sql2);
$nrLog = $db2->num_rows();
unset($myrow);
if ($nrLog > 0) {
while ($db2->next_record()) {
$userName = $db2->f('User_Name');
$userName = str_replace("nala\\", "", $userName);
if (!empty($userName)) {
//echo "UserName : $userName <br>";
$sqlX = "select Id_usuario from USUARIO where Email like '{$userName}%' ";
$dbX->query($sqlX);
unset($rowZ);
while ($dbX->next_record()) {
$idUsrSion = $dbX->f('Id_usuario');
}
} elseif ($idUsrSion == 0 || empty($idUsrSion)) {
$idUsrSion = 647;
// Robot SION.
}
$actionDesc = $db2->f('Action_Description');
$actionDesc = addslashes($actionDesc);
$logDateTime = $db2->f('Log_DateTime');
// Comprobar que no exista para evitar Duplicado
if ($idBlDCE > 0) {
$sqlX = "\n select id_firma_his from FIRMA_HIS\n where id_bl='{$idBlDCE}' and id_firma_cpto='1' ";
// and nota='$actionDesc'
$dbX->query($sqlX);
$nrU = $dbX->num_rows();
if ($nrU == 0) {
/**
* Statistics
*
* @todo Optimize
*/
function statistik($filter = '')
{
// count number of spots on each course
$countPladser = 0;
$countOptagne = 0;
$db1 = new DB_Sql();
$sql = "SELECT id, pladser FROM kortkursus\r\n WHERE published=1\r\n AND tilmeldingsmulighed = 'Ja'\r\n AND DATE_FORMAT(dato_start, '%Y') >= 2005";
if (!empty($filter)) {
$sql .= "\tAND gruppe_id = " . (int) $filter;
}
$sql .= " ORDER BY dato_start ASC";
$db1->query($sql);
while ($db1->nextRecord()) {
$countPladser += $db1->f('pladser');
$kursus = new VIH_Model_KortKursus($db1->f('id'));
$countOptagne += $kursus->getOptagnePladser();
}
if ($countPladser == 0) {
$countPladser = 1;
}
$percent = round($countOptagne / $countPladser * 100, 0);
return array('pladser' => $countPladser, 'percent' => $percent, 'optagne' => $countOptagne);
}
//create db object//
$db = new DB_Sql();
//open template//
$tem = template_open("print_user.tpl");
//add header footer//
///$tem = template_add_head_foot($tem,head,foot);
$tmp = template_get_repeat_text("##START##","##STOP##","##USER_LIST##",$tem);
$row = $tmp[1];
$tem = $tmp[0];
//get out the events//
$sql = "SELECT *
FROM users, events
WHERE users.event_id=events.event_id and id_user=$id_user
ORDER BY events.event_id, users.number ASC";
$db->query($sql);
while ($db->next_record()) {
$table.=$row;
$table = str_replace("##USER_ID##",$db->f("id_user"),$table);
$table = str_replace("##NAME##",$db->f("full_name"),$table);
$table = str_replace("##EVENT##",$db->f("name"),$table);
$table = str_replace("##NUMBER##",$db->f("number"),$table);
}
//replace template variables//
$tem = str_replace("##USER_LIST##",$table,$tem);
$tem = str_replace("##MESSAGE##",$message,$tem);
///clean up//
$tem = template_clean_up_tags($tem,"##");
//output of the template//
echo $tem;
while( $db3->next_record() ){
$idBarcoX = $db3->f('Id_barco');
if( $idBarco!=$idBarcoX ){
echo "Se eliminara $nombre | $viaje | $eta | $IE | $puerto | $tlBls <br>";
}
else{
echo "No se eliminara $nombre | $viaje | $eta | $IE | $puerto | $tlBls <br>"";
}
}
*/
}
if ($flgDup == 1) {
$sql3 = "select * from Z_BUQUE_DUP WHERE nombre='{$nombre}' and viaje='{$viaje}' and Eta1='{$eta}' and Impo_expo='{$IE}' and Puerto='{$puerto}'";
$db3->query($sql3);
while ($db3->next_record()) {
$idBarcoX = $db3->f('Id_barco');
if ($idBarco != $idBarcoX) {
echo "[Eliminado] {$nombre} | {$viaje} | {$eta} | {$IE} | {$puerto} | {$tlBls} <br>";
// Mover los Bls al buque correcto.
$sql2 = "update EXPO set Id_barco='{$idBarco}' where Id_barco='{$idBarcoX}'";
$db2->query($sql2);
// Eliminar el buque.
$sql2 = "delete from BARCO where Id_barco='{$idBarcoX}'";
$db2->query($sql2);
$sql2 = "delete from Z_BUQUE_DUP where Id_barco='{$idBarcoX}'";
$db2->query($sql2);
} else {
//echo "No se eliminara $nombre | $viaje | $eta | $IE | $puerto | $tlBls <br>";
}
}
}
//echo $row_category . "<hr>". $row;
$tekma = $_REQUEST["tekma"];
$event_id = $_REQUEST["event_id"];
$sql = "select events.name as ename,event_id from events ";
$db->query($sql);
while ($db->next_record()) {
$event_name = $db->f("ename");
$tekma_name = $db->f("tname");
$event_id = $db->f("event_id");
//Pogledamo rezultate za Mladino do 19let//
$age="19";
$res = get_user_group_event("M",$age,"<=");
if ($res->affected_rows()>0) {
$titleAge=explode(" ",$age);
create_results($res,$event_name." - mladina M do ".$titleAge[0]." let");
$age=0;
}
//Pogledamo rezultate za Moske pod 40 let//
$age="20 and 40";
$res = get_user_group_event("M",$age,"between");
public function getKurser()
{
$db = new DB_Sql();
$db->query("SELECT * FROM langtkursus_x_fag INNER JOIN langtkursus ON langtkursus_x_fag.langtkursus_id = langtkursus.id WHERE fag_id = " . $this->id . ' AND dato_start > NOW() AND langtkursus.active = 1 AND langtkursus.published = 1 GROUP BY langtkursus_id ORDER BY dato_start');
$kurser = array();
while ($db->nextRecord()) {
$kurser[] = new VIH_Model_LangtKursus($db->f('langtkursus_id'));
}
return $kurser;
}
function getList($type = 'published')
{
$db = new DB_Sql();
$sql = "SELECT id FROM facilitet WHERE active = 1";
if ($type == 'published') {
$sql .= " AND published = 1";
} elseif ($type == 'højskole') {
$sql .= " AND kategori_id > 0 AND kategori_id < 4 AND published = 1";
}
$sql .= " ORDER BY kategori_id, navn";
$db->query($sql);
$list = array();
while ($db->nextRecord()) {
$list[] = new VIH_Model_Facilitet($db->f('id'));
}
return $list;
}
//create db object//
$db = new DB_Sql();
//open template//
$tem = template_open("run.tpl");
//add header footer//
$tem = template_add_head_foot($tem,head,foot);
$tmp = template_get_repeat_text("##START##","##STOP##","##RUNNERS##",$tem);
$row = $tmp[1];
$tem = $tmp[0];
//get out the event title//
$sql = "Select events.name as ename, tekma.name as tname from events,tekma where event_id='$event_id' and tekma_id='$tekma_id'";
$db->query($sql);
if ($db->next_record()) {
$tem = str_replace("##TITLE##",$db->f("ename"). " - ". $db->f("tname"),$tem);
}
///now the runners//
$sql = "SELECT *
FROM `timming` , users
WHERE `timming`.event_id = $event_id
AND tekma_id = $tekma_id
AND STOP =0
AND `timming`.user_id = `users`.id_user ";
$db->query($sql);
if ($db->affected_rows()==0) {
header("location:event_list.php");
exit();
function updateCGAGpo($idGrupo, $forzarMov = 0)
{
$db = new DB_Sql();
$db->connect("MscCobranza", "localhost", "root", "");
$db2 = new DB_Sql();
$db2->connect("MscCobranza", "localhost", "root", "");
$db3 = new DB_Sql();
$db3->connect("MscCobranza", "localhost", "root", "");
//echo "Gpo:$idGrupo || forzaMov:$forzarMov <br>";
// ---------------------------------
// PROCESO PARA ACTUALIZAR LAS C.G.A
// ---------------------------------
$ano = date("Y");
$anoAnt = $ano - 1;
$grupo = getValueTable("grupo", "D_GRUPO", "id_grupo", $idGrupo);
$cgaAct = getValueTable("cga", "D_GRUPO", "id_grupo", $idGrupo);
$cgaOld = getValueTable("cga_old", "D_GRUPO", "id_grupo", $idGrupo);
// * DETECTAR REGISTROS DEL CLIENTE
$sql2 = "select a.id_calculo as IDCALCULO, a.carta_g as CGACAL, a.id_bl_conte as IDBLCONTE ";
$sql2 .= "from D_CALCULO a, D_CLIENTE b ";
$sql2 .= "where ";
$sql2 .= "a.id_cliente=b.id_cliente and b.id_grupo='{$idGrupo}' and ";
if ($forzarMov == '0') {
$sql2 .= "a.carta_g='' and ";
}
$sql2 .= "(libre_f1 BETWEEN '{$anoAnt}-01-01' and '{$ano}-12-31%' )";
$db2->query($sql2);
while ($db2->next_record()) {
$idCalculo = $db2->f(IDCALCULO);
//echo "idCalculo=$idCalculo <br>";
$idBlConte = $db2->f(IDBLCONTE);
$cgaCal = $db2->f(CGACAL);
$idBl = getValueTable("id_bl", "BL_CONTE", "id_bl_conte", $idBlConte);
$bl = getValueTable("Bl", "EXPO", "Id_expo", $idBl);
$idBarco = getValueTable("Id_barco", "EXPO", "Id_expo", $idBl);
$eta = getValueTable("Eta1", "BARCO", "Id_barco", $idBarco);
if (preg_match("/^(\\d{4})/i", $eta, $parts)) {
$etaAno = $parts[1];
}
// * CGA - ACTUAL
if (!empty($cgaAct) && (empty($cgaCal) || $forzarMov == 1)) {
if (preg_match("/CGA {$etaAno}/i", $cgaAct)) {
$sql3 = "update D_CALCULO set carta_g='{$cgaAct}' where id_calculo='{$idCalculo}'";
$db3->query($sql3);
//echo "$bl [CGA - Actualizada]...<br>";
}
}
// * CGA - ANTERIOR
if (!empty($cgaOld) && (empty($cgaCal) || $forzarMov == 1)) {
if (preg_match("/CGA {$etaAno}/i", $cgaOld)) {
$sql3 = "update D_CALCULO set carta_g='{$cgaOld}' where id_calculo='{$idCalculo}'";
$db3->query($sql3);
//echo "$bl [CGA - Actualizada]...<br>";
}
}
}
}
/**
* Cleans up old subscriptions
*
* NOTICE: Use cancel() and not delete()
*
* @return 1 on success
*/
function cleanUp()
{
$db = new DB_Sql();
$db->query("SELECT id, DATE_ADD(date_updated, INTERVAL 1 HOUR) AS date_created FROM kortkursus_tilmelding\n WHERE DATE_ADD(date_updated, INTERVAL 1 HOUR) < NOW()\n AND (status_key = '" . $this->getStatusKey('undervejs') . "' OR status_key = '" . $this->getStatusKey('ikke tilmeldt') . "') AND active = 1");
while ($db->nextRecord()) {
$tilmelding = new VIH_Model_KortKursus_Tilmelding($db->f('id'));
$tilmelding->setStatus('annulleret');
}
return true;
}
$message = "Manjkajoca polja!";
}
}
$names[] = "Moski";
$names[] = "Zenska";
$values[] = "M";
$values[] = "F";
$sex_dd = html_drop_down_arrays('sex',$names,$values,$sex);
//get events
$sql="select * from events";
$db->query($sql);
while ($db->next_record()) {
$e_names[] = $db->f("name");
$e_values[] = $db->f("event_id");
}
$event_dd = html_drop_down_arrays('event',$e_names,$e_values,$event);
//replace template variables//
$tem = str_replace("##SEX##",$sex_dd,$tem);
$tem = str_replace("##EVENT##",$event_dd,$tem);
if (!$sucsess) {
$tem = str_replace("##CLUB##",$club,$tem);
$tem = str_replace("##FULL_NAME##",$full_name,$tem);
include_once "../include/template.inc";
include_once "../include/db_mysql.inc";
include_once "../include/class.phpmailer.php";
$t = new Template('c:\\xampp\\htdocs\\msclink\\templates', "keep");
$hoy = date("Y-m-d");
// ---------------
// CONFIGURACION
// -------------
// --- SION ---
$sionDB = "MscCobranza";
$sionSrv = "10.110.0.5";
$db = new DB_Sql();
$db2 = new DB_Sql();
$db->connect($sionDB, $sionSrv, "root", "");
$db2->connect($sionDB, $sionSrv, "root", "");
$sql = "select * from Z_MS_20_40";
$db->query($sql);
$l = 1;
while ($db->next_record()) {
$bl = $db->f('Bill_Of_Lading_Number');
$bl = str_replace("MSCU", "", $bl);
$c20 = $db->f('# 20s');
$c40 = $db->f('# 40s');
// Actualizar info
$sql2 = "update EXPO set C20='{$c20}',C40='{$c40}' where Bl='{$bl}'";
$db2->query($sql2);
echo "{$l} [Actualizado] {$bl} ( <small>{$sql2}</small> ) <br>";
$l++;
}
echo "<hr>Fin del proceso :)";
function getValueTable($campo, $tabla, $idTabla, $idEnviado)
{
// Extrae solo info de SION
global $sionSrv, $sionDB;
/*
* @return Info de un campo especifico
* @param string $campo
* @param string $tabla
* @param string $idTabla
* @param string $idEnviado
* @desc Esta funcion sirve para traer informacion de x campo de cualquier tabla.
*/
$dbf = new DB_Sql();
$dbf->connect($sionDB, $sionSrv, "root", "");
$sql = "select {$campo} from {$tabla} where {$idTabla}='{$idEnviado}'";
$dbf->query($sql);
while ($dbf->next_record()) {
$valor = $dbf->f($campo);
return $valor;
// No mover el return, podria ser peligroso!.
}
}
function sendMail($bl, $pod)
{
global $hoy, $sionSrv, $sionDB;
$db = new DB_Sql();
$db->connect($sionDB, $sionSrv, "root", "");
$mail = new phpmailer();
$mail->Priority = 0;
// Se declara la prioridad del mensaje.
// ------------------------------------------------
// CONFIGURAR EMAIL.
// ------------------------------------------------
//Definimos las propiedades y llamamos a los m�todos
//correspondientes del objeto mail
//Con PluginDir le indicamos a la clase phpmailer donde se
//encuentra la clase smtp que como he comentado al principio de
//este ejemplo va a estar en el subdirectorio includes
$mail->PluginDir = "../include/";
$mail->Mailer = "smtp";
// ++ EXCHANGE MSC ++
$userName = '******';
$linkPass = '******';
$mail->IsSMTP();
$mail->SMTPSecure = 'tls';
$mail->SMTPAuth = true;
$mail->Host = 'mail.mscgva.ch';
// IP 193.138.73.142
$mail->Username = $userName;
$mail->Password = $linkPass;
$mail->Port = 25;
$mail->From = '*****@*****.**';
$mail->FromName = 'Robot.SION';
$mail->Timeout = 10;
//El valor por defecto 10 de Timeout es un poco escaso dado que voy a usar
//una cuenta gratuita, por tanto lo pongo a 30
//$mail->Timeout=10;
$mail->Timeout = 10;
$paisSan = getValueTable("country", "DOC_PAIS_SANCIONADO", "code", $pod);
// --------------------
// FORMATO HTML
// --------------------
$mail->Body = "\n <html>\n <body>\n <center>\n <table border=0 cellpadding=2 cellspacing=1>\n <tr>\n <td width=\"60\" height=\"40\" valign=top align=right><img src=\"http://148.245.13.34/nestor/images/logoMscGoldSmall.gif\" ></td>\n <td valign=top align=center>\n <font size=\"4\"><b>Mediterranean Shipping Company M�xico S.A. de C.V.</b></font><br>\n <font size=\"2\">S�lo como agentes / As agents only</font>\n </td>\n </tr>\n <tr>\n <td colspan=2><hr></td>\n </tr>\n </table>\n <font size=\"4\"><b>NOTIFICACION - SANCTIONS COMPLIANCE<br>({$paisSan})</b><BR>{$bl}</font>\n </center>\n <p>\n\n Estimado Ejecutivo de Ventas\n <p>\n El bl de referencia tiene un destino a uno de los pa�ses sancionados.\n Por favor confirmar si el procedimiento de las pol�ticas de conformidad ha sido realizado y firmado por el Sr. Alonso Sope�a y/o el Sr. Homely Rojas\n de lo contrario la carga no podr� ser embarcada.\n <p>\n En espera de sus urgentes comentarios.\n <br>\n Este mensaje es enviado por razones de SEGURIDAD.\n <p>\n <i>\n Att. Robot SION.<br>\n </i>\n <p>\n <hr>\n <font color=\"red\" size=\"2\">\n <i>Este es un correo de envio autom�tico por nuestro sistema SION, por favor no responda este email.</i>\n </font>\n <br>\n <br>\n <br>\n\n </body>\n </html>\n\n ";
// -------------------------------------------------------
// FORMATO TEXTO
// Definimos AltBody por si el destinatario del correo
// no admite email con formato html
// -------------------------------------------------------
$mail->AltBody = "\n MEDITERRANEAN SHIPPING COMPANY M�XICO\n MSC M�xico (As Agents Only-Solo como Agentes)\n =====================================================================\n ";
// Nota :
// La direccion PARA solo se puede manejar 1.
// Las direcciones CC puede manejar N correos.
// -------------
// Destinatarios
// -------------
$mail->ClearAddresses();
// ------------------------------------------------
/*
$arrDirDestino[] ="*****@*****.**";
foreach ( $arrDirDestino as $emailDestino ) {
if (! empty ( $emailDestino )) {
$mail->AddAddress ( $emailDestino );
$emailDesTxt .= "$emailDestino,";
}
}
*/
$mail->AddCC("*****@*****.**");
// Copia Ciega
$mail->AddBCC("*****@*****.**");
$mail->AddBCC("*****@*****.**");
//$mail->AddAddress("*****@*****.**");
//if(!empty($sndCC))$mail->AddCC($sndCC);
// -----------------------------------------
// Subject
//-----------------------------------------
$sql = "select * from DOC_CTRL_EXPO ";
$sql .= "where bl='{$bl}' ";
$db->query($sql);
while ($db->next_record()) {
// -----------------------------------------
// Comprobar q no tenga la firma BL-REVISION
// -----------------------------------------
$bl = $db->f(bl);
$bkg = $db->f(bkg);
$bkgp = $db->f(bkg_party);
$executive = $db->f(bkg_executive);
$exeMail1 = getValueTable("mail1", "DOC_CAT_EJE", "cod", $executive);
$exeMail2 = getValueTable("mail2", "DOC_CAT_EJE", "cod", $executive);
$exeMail3 = getValueTable("mail3", "DOC_CAT_EJE", "cod", $executive);
if (!empty($exeMail1)) {
$mail->AddAddress($exeMail1);
}
if (!empty($exeMail2)) {
$mail->AddAddress($exeMail2);
}
if (!empty($exeMail3)) {
$mail->AddAddress($exeMail3);
}
$pol = $db->f(pol);
$pod = $db->f(pod);
$who = $db->f(who);
$idBarco = getValueTable("id_barco", "DOC_CTRL_EXPO", "id_bl", $idBl);
$vessel = getValueTable("Nombre", "BARCO", "Id_barco", $idBarco);
$voy = getValueTable("Viaje", "BARCO", "Id_barco", $idBarco);
$eta = getValueTable("Eta1", "BARCO", "Id_barco", $idBarco);
$vesVoy = "{$vessel} / {$voy} (<font color=maroon>{$idBarco}</font>)";
$puerto = getValueTable("puerto", "CS_CODIGO", "codigo", $pod);
$pais = getValueTable("pais", "CS_CODIGO", "codigo", $pod);
}
// VERACRUZ : MXVER
// ALTAMIRA : MXLMR,MXATM
// PACIFICO : MXZLO,MXMZT,MXSCX,MXLZC,MXPMS,MXGYM
if ($pol == "MXVER") {
$mail->AddCC("*****@*****.**");
} elseif ($pol == "MXZLO" || $pol == "MXMZT" || $pol == "MXSCX" || $pol == "MXLZC" || $pol == "MXPMS" || $pol == "MXGYM") {
$mail->AddCC("*****@*****.**");
} elseif ($pol == "MXLMR" || $pol == "MXATM") {
$mail->AddCC("*****@*****.**");
} else {
$mail->AddCC("*****@*****.**");
}
$paisSan = getValueTable("country", "DOC_PAIS_SANCIONADO", "code", $pol);
$txtSubj = "SANCTIONS COMPLIANCE {$paisSan} / [{$who}] / {$vessel} {$voy} / MSCU{$bl} / {$bkg} / {$bkgp} / {$pol} / {$pol} / [{$who}] %0A%0A";
$txtSubj = str_replace("&", "AND", $txtSubj);
$mail->Subject = "{$txtSubj}";
// Incluir Attach.
//$mail->AddAttachment("../files/demo.txt","demo.txt");
// Se envia el mensaje, si no ha habido problemas, la variable $exito tendra el valor true
$exito = $mail->Send();
/*
// PARA INTAR REENVIARLO
//Si el mensaje no ha podido ser enviado se realizaran 4 intentos mas como mucho
//para intentar enviar el mensaje, cada intento se hara 5 segundos despues
//del anterior, para ello se usa la funcion sleep
$intentos=1;
while ((!$exito) && ($intentos < 5)) {
sleep(5);
$exito = $mail->Send();
$intentos=$intentos+1;
}
*/
if (!$exito) {
echo "[ <font color=red><b>Problema de envio</b></font> ] {$emailDestino} -> {$valor}" . $mail->ErrorInfo . "<br>\n";
} else {
echo "[ <font color=green><b>Enviado</b></font> ] <br>";
}
}
public function getPictures()
{
$db = new DB_Sql();
$db->query("SELECT * FROM langtkursus_x_file WHERE langtkursus_id = " . $this->id);
$id = array();
while ($db->nextRecord()) {
$id[]['file_id'] = $db->f('file_id');
}
return $id;
}
function getForfaldenDato($key = '', $sprog = '')
{
if (!in_array($key, array('depositum', ''))) {
throw new Exception("Tilmelding->getForfaldenDato");
}
if (!empty($sprog)) {
$sprog = '_' . $sprog;
}
$db = new DB_Sql();
switch ($key) {
case 'depositum':
$db->query("SELECT\n date_add(date_created, interval 10 day) AS dato_forfalden,\n DATE_FORMAT(date_add(date_created, interval 10 day), '%d-%m-%Y') AS forfald_dk\n FROM kortkursus_tilmelding\n WHERE id=" . $this->get('id'));
break;
default:
$db->query("SELECT date_sub(dato_start, interval 42 day) AS dato_forfalden,\n DATE_FORMAT(date_sub(dato_start, interval 42 day), '%d-%m-%Y') AS forfald_dk\n FROM kortkursus\n WHERE id=" . $this->kursus->get('id'));
break;
}
if (!$db->nextRecord()) {
return 0;
}
return $db->f('forfald' . $sprog);
}
$dsn = "Driver={SQL Server};Server={$linkSrv};Database={$linkDB};Integrated Security=SSPI;Persist Security Info=False;";
// Se realiza la conex�n con los datos especificados anteriormente
$conn = odbc_connect($dsn, $linkUsr, $linkPass);
// ---------------------------------------------------------------------------------------
if (isset($_POST['clave'])) {
$clave = $_POST['clave'];
if ($clave == "cerdo") {
$flgClave = 1;
}
}
if ($_POST['modo'] == "ok" && $flgClave == 1) {
$salesExe = "";
$sql = "select * from Z_HOME";
$db->query($sql);
while ($db->next_record()) {
$id = $db->f('id');
$bl = $db->f('bl');
$sql2 = "\n SELECT\n b.booking_number,\n B.Bill_Of_Lading_Number,\n cs.Local_STR_1 AS Sales_Exec,\n cs.Local_STR_2 AS Doc_Exec\n FROM\n interlink_dfeed90.dfeed.FNTB_Booking_BL (1, 200) B\n INNER JOIN Interlink_Main90.dbo.Cargo_Shipment (nolock) cs ON b.Cargo_Shipment_id = cs.Cargo_Shipment_id\n WHERE\n B.Bill_Of_Lading_Number='{$bl}' ";
$rs = odbc_exec($conn, $sql2);
while (odbc_fetch_row($rs)) {
$salesExe = odbc_result($rs, "Sales_Exec");
}
if (!empty($salesExe)) {
$sql2 = "update Z_HOME set sales_exe='{$salesExe}' where id='{$id}'";
$db2->query($sql2);
echo "OK {$bl} <br>";
}
}
} else {
echo "La contraseña es incorrecta...";
}
function addContenedor($bl)
{
global $serverName, $db, $usuario, $pass;
$dbf = new DB_Sql();
$dbf->connect("MscCobranza", "10.110.13.13", "root", "");
$dsn = "Driver={SQL Server};Server={$serverName};Database={$db};Integrated Security=SSPI;Persist Security Info=False;";
$conn2 = odbc_connect($dsn, $usuario, $pass);
$blSION = str_replace("MSCU", "", $bl);
// Consultar los contenedores y despues agregarlos al SION.
$sql = "\n SELECT DISTINCT\n\tCH.Container_Number as CONTE,\n\tC.EQ_Type AS EQUIPO,\n\tC.Shipper_Owned AS SOC\n FROM\n Interlink_DFeed90.dfeed.FNTB_Bill_Of_Lading (1, NULL) BL\n INNER JOIN Interlink_DFeed90.dfeed.FNTB_Charge (1, NULL) CH ON BL.Bill_of_Lading_id = CH.Bill_Of_Lading_id\n INNER JOIN Interlink_DFeed90.dfeed.FNTB_BOLREP_Container () C ON CH.Container_Number = C.Container_Number\n WHERE\n BL.Include_In_Manifest_And_DTX = '1'\n AND CH.Container_Number <> ''\n AND BL.Bill_Of_Lading_Number='{$bl}'\n ";
$rsf = odbc_exec($conn2, $sql);
while (odbc_fetch_row($rsf)) {
$conte = odbc_result($rsf, "CONTE");
$equipo = odbc_result($rsf, "EQUIPO");
$soc = odbc_result($rsf, "SOC");
// Detectar el Equipo en SION.
$sql2 = "select id_equipo from EQUIPO where equipo_link='{$equipo}' ";
$dbf->query($sql2);
while ($dbf->next_record()) {
$idEquipo = $dbf->f('id_equipo');
}
// Comprobar si existe en el SION,
// Si existe, entonces actualzar equipo y SOC.
// No existe, agregar.
$sql2 = "select id_contenedor from CONTENEDOR where numero='{$conte}' ";
$dbf->query($sql2);
while ($dbf->next_record()) {
$idConte = $dbf->f('id_contenedor');
}
if (!empty($idConte)) {
// Actualizar
$sql2 = "update CONTENEDOR set id_equipo='{$idEquipo}',soc='{$soc}' where id_contenedor='{$idConte}'";
$dbf->query($sql2);
unset($idConte);
} else {
// Nuevo contenedor
$sql2 = "insert into CONTENEDOR (";
$sql2 .= "numero,id_equipo,soc";
$sql2 .= ") values (";
$sql2 .= "'{$conte}','{$idEquipo}','{$soc}'";
$sql2 .= ")";
$dbf->query($sql2);
}
$sql2 = "select id_contenedor from CONTENEDOR where numero='{$conte}' ";
$dbf->query($sql2);
while ($dbf->next_record()) {
$idConte = $dbf->f('id_contenedor');
}
$sql2 = "select Id_expo from EXPO where Bl='{$blSION}' ";
$dbf->query($sql2);
while ($dbf->next_record()) {
$idBlSion = $dbf->f('Id_expo');
}
if (!empty($idConte) && !empty($idBlSion)) {
// Comprobar que no exista en SION : BL_CONTE,
// Si no existe, entonces grabarlo en la relación bl-conte.
$sql2 = "select id_bl_conte from BL_CONTE where id_bl='{$idBlSion}' and id_contenedor='{$idConte}' ";
$dbf->query($sql2);
while ($dbf->next_record()) {
$idBlConte = $dbf->f('id_bl_conte');
}
if (empty($idBlConte)) {
$sql2 = "insert into BL_CONTE (";
$sql2 .= "id_bl,id_contenedor";
$sql2 .= ") values (";
$sql2 .= "'{$idBlSion}','{$idConte}'";
$sql2 .= ")";
$dbf->query($sql2);
unset($idConte);
unset($idBlSion);
echo "[Cargado] {$bl} | {$conte} <br>\n";
}
}
}
//odbc_close($conn2);
}
// ODBC
// El sistema se trata de conectar mediante ODBC nativo a la base de datos MscLink
// -------------------------------------------------------------------------------
$dsn = "Driver={SQL Server};Server={$linkSrv};Database={$linkDB};Integrated Security=SSPI;Persist Security Info=False;";
// Se realiza la conex�n con los datos especificados anteriormente
$conn = odbc_connect($dsn, $linkUsr, $linkPass);
// ---------------------------------------------------------------------------------------
if ($_POST['modo'] == "ok") {
$salesExe = "";
$sql = "select * from Z_MS_POLPOD";
$db->query($sql);
while ($db->next_record()) {
$POLUN = "";
$PODUN = "";
//$id = $db->f('id');
$bl = $db->f('Bill_Of_Lading_Number');
$bl = str_replace("MSCU", "", $bl);
$POLUN = $db->f('POLUN');
$PODUN = $db->f('PODUN');
$sql2 = "\n update EXPO \n set Loading='{$POLUN}', Discharge='{$PODUN}'\n WHERE Bl='{$bl}'";
$db2->query($sql2);
echo "{$bl} [Actualizado] <br>";
}
}
?>
<!doctype html>
<html lang="es">
<head>
<meta charset="iso-8859-1">
function getFag()
{
$db = new DB_Sql();
$db->query("SELECT * FROM ansat_x_fag INNER JOIN langtkursus_fag f*g ON ansat_x_fag.fag_id = f*g.id WHERE ansat_id = " . $this->id . " AND f*g.active = 1 AND f*g.published = 1");
$f*g = array();
while ($db->nextRecord()) {
$f*g[] = new VIH_Model_Fag($db->f('fag_id'));
}
return $f*g;
}
