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;
}
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'));
}
}
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 checkurl()
{
foreach ($_GET as $check1) {
$check2 = check($check1);
if ($check1 != $check2 || strlen($check1) != strlen($check2)) {
@($str = "INSERT INTO `attacklog` ( `uid` , `dt` , `ip` , `key` , `memo` , `httphost` ) \r\n\t\t\t\tVALUES ( '" . $_SESSION['uid'] . "', '" . date("Y-m-d H:i:s") . "', '" . $_SERVER['REMOTE_ADDR'] . "', '" . $_SERVER['SCRIPT_FILENAME'] . "', '', '" . $_SERVER['HTTP_HOST'] . "')");
@($db = new DB_Sql());
@$db->query($str);
echo "¹¥»÷Ìáʾ";
exit;
}
}
}
function postForm()
{
$db = new DB_Sql();
foreach ($this->body() as $key => $value) {
foreach ($value as $id => $hold) {
if (!$hold) {
continue;
}
$db->query("UPDATE langtkursus_tilmelding_x_fag SET hold = " . $hold . " WHERE id = " . $id);
}
}
return new k_SeeOther($this->url());
}
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];
}
}
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;
}
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;
}
<?php
include '../../include_videotutoriales/configpc.php';
session_start();
$html = new Smarty();
if (!isset($_POST["formulario"])) {
$html->display("login.html");
} else {
$usuario = $_POST["usuario"];
$pass = $_POST["pass"];
$pass = md5($pass);
$db = new DB_Sql();
//query de usuario si es que si creamos la session usuario y vamos a perifl.php , si da error a error.php
$query = "select usuario from usuarios where usuario='{$usuario}' and pass='******'";
$db->query($query);
if ($db->num_rows() > 0) {
$_SESSION["usuario"] = $usuario;
header("location: perfil.php");
} else {
$html->display("error.html");
}
}
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!.
}
}
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;
}
// FIRMA BL A REVISION
// 1. Detectar el link los log del Bl, Draf.
// 2. Crear firma en SION, Bl-Revision
// --------------------------------------------------
$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'
/**
*
* Der m� i denne funktion ikke bruges array_map() til at genneml�be
* v�rdierne, da den �del�gger arrayet til andet brug.
* Sune: Nu har jeg alligevel benyttet array_map, for jeg kan ikke se hvor man ikke kan det.
*/
function save($input)
{
settype($input['arbejdstelefon'], 'string');
settype($input['mobil'], 'string');
settype($input['adresse'], 'string');
settype($input['postnr'], 'string');
settype($input['postby'], 'string');
if (!$this->validate($input)) {
return 0;
}
$var = $input;
$navn = vih_split_name($var['navn']);
$var['fornavn'] = $navn['fornavn'];
$var['efternavn'] = $navn['efternavn'];
if ($this->id == 0) {
$sql_type = "INSERT INTO ";
$sql_end = ", date_created = NOW()";
} else {
$sql_type = "UPDATE ";
$sql_end = ", date_changed = NOW() WHERE id = " . $this->id;
}
$sql = $sql_type . "adresse SET\r\n fornavn = '" . $var['fornavn'] . "',\r\n efternavn = '" . $var['efternavn'] . "',\r\n adresse = '" . $var['adresse'] . "',\r\n postnr = '" . $var['postnr'] . "',\r\n postby = '" . $var['postby'] . "',\r\n email = '" . $var['email'] . "',\r\n arbejdstelefon = '" . $var['arbejdstelefon'] . "',\r\n telefon = '" . $var['telefonnummer'] . "',\r\n mobil = '" . $var['mobil'] . "'" . $sql_end;
$db = new DB_Sql();
$db->query($sql);
if ($this->id == 0) {
return $db->insertedId();
}
$this->load();
return $this->id;
}
* The contents of this file are subject to the License; you may not use this file except in compliance with the License.
*
* @version $Revision: 2075 $
*/
@set_time_limit(1000);
require "../libraries/common.inc.php";
require "session_cp.inc.php";
require LIB_PATH . "db_mysql.inc.php";
uses("log");
$log = new Logs();
$db = new DB_Sql();
$conn = $db->connect($dbname, $dbhost, $dbuser, $dbpasswd);
$tpl_file = "db";
if (!($backupdir = $pdb->GetOne("SELECT valued FROM {$tb_prefix}settings WHERE variable='backup_dir'"))) {
$backupdir = pb_radom(6);
$db->query("REPLACE INTO {$tb_prefix}settings (variable, valued) values ('backup_dir', '{$backupdir}')");
}
require LIB_PATH . "func.db.php";
require LIB_PATH . "func.sql.php";
if (isset($_POST['do'])) {
$do = trim($_POST['do']);
if (!file_exists(DATA_PATH . "backup_" . $backupdir)) {
pb_create_folder(DATA_PATH . "backup_" . $backupdir);
}
if ($do == "query" && !empty($_POST['sql_content'])) {
if ($admin_runquery) {
$result = sql_run($_POST['sql_content']);
if ($result) {
flash("success");
} else {
flash();
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);
}
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>";
}
}
}
}
function deletePicture($file_id)
{
$db = new DB_Sql();
$db->query('UPDATE facilitet SET pic_id = 0, date_updated = NOW() WHERE id = ' . $this->id);
return 1;
}
if (mysql_get_server_info() > '4.1') {
mysql_query("CREATE DATABASE IF NOT EXISTS" . " {$dbname} DEFAULT CHARACTER SET {$dbcharset};");
} else {
mysql_query("CREATE DATABASE IF NOT EXISTS {$dbname};");
}
mysql_close();
} else {
$error_info = mysql_errno() . " : " . mysql_error() . "<br>";
$db_error = true;
break;
}
} else {
$sqldump = null;
$conn = $db->connect($dbname, $dbhost, $dbuser, $dbpasswd);
if ($version > '4.1' && $charset) {
$db->query($set_names);
}
if ($version > '5.0') {
$db->query($set_modes);
}
$tables = $db->table_names();
if (!empty($tables)) {
foreach ($tables as $names) {
if (!function_exists("stripos")) {
function stripos($str, $needle)
{
return strpos(strtolower($str), strtolower($needle));
}
}
if (stripos($names['table_name'], $tb_prefix) === 0) {
$sqldump .= data2sql($names['table_name']);
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);
}
/**
* Execute the SQL query.
* @param string $qs
*/
public function query($qs)
{
if ($this->env->warn_if_duplicate_query_executed) {
if (isset($this->_query_texts[$qs])) {
$count = $this->_query_texts[$qs];
log_message("The query [{$qs}] has already been executed [{$count}] times.", Msg_type_debug_warning, Msg_channel_database);
$this->_query_texts[$qs] += 1;
} else {
$this->_query_texts[$qs] = 1;
}
}
if (isset($this->env->profiler)) {
$this->env->profiler->start('db');
DB_Sql::query($qs);
$this->env->profiler->stop('db');
} else {
DB_Sql::query($qs);
}
$this->env->num_queries_executed += 1;
}
function save()
{
$db = new DB_Sql();
$db->query("INSERT INTO betaling_online SET date_created = NOW(), type='" . $this->type . "', transaktionsnummer = '', status='" . $this->eval['qpstat'] . "'");
return 1;
}
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>";
}
}
<?
include "../inc/config.php";
//?user_id=1&event_id=1&tekma_id=2
//$event_id = $_REQUEST["event_id"];
//$tekma_id = $_REQUEST["tekma_id"];
$user_id = $_REQUEST["user_id"];
echo "userID=".$user_id;
//create db object//
$db = new DB_Sql();
if ($user_id) {
$sql = "delete from users where id_user='******'";
$db->query($sql);
//echo $sql;
//redirekt to monitor page//
header("location:".$_SERVER['HTTP_REFERER']);
exit();
}
echo "Ups??";
/**
* 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;
}
define('DB_USER', $dbuser);
define('DB_PASS', $dbpass);
define('DB_NAME', $dbname);
$db = new DB_Sql();
// poprawiono dla wersji php < 4.3.0
if (!function_exists('file_get_contents')) {
$sql_query = implode('', file($db_schema));
$sql_query = explode(';', $sql_query);
} else {
$sql_query = explode(';', file_get_contents($db_schema));
}
$sql_query = str_replace('core_', $dbprefix, $sql_query);
$sql_query = $lang == 'en' ? str_replace('DEFAULT_CATEGORY', 'default', $sql_query) : str_replace('DEFAULT_CATEGORY', 'ogólna', $sql_query);
$sql_size = sizeof($sql_query) - 1;
for ($i = 0; $i < $sql_size; $i++) {
$db->query($sql_query[$i]);
}
$file = '<?php' . "\n";
$file .= "\n// Core CMS auto-generated config file\n\n";
$file .= 'define(\'DB_HOST\', \'' . $dbhost . '\');' . "\n";
$file .= 'define(\'DB_USER\', \'' . $dbuser . '\');' . "\n";
$file .= 'define(\'DB_PASS\', \'' . $dbpass . '\');' . "\n";
$file .= 'define(\'DB_NAME\', \'' . $dbname . '\');' . "\n";
$file .= 'define(\'PREFIX\', \'' . $dbprefix . '\');' . "\n\n";
$file .= "define('TABLE_ASSIGN2CAT', PREFIX . 'assign2cat');\n";
$file .= "define('TABLE_MAIN', PREFIX . 'devlog');\n";
$file .= "define('TABLE_USERS', PREFIX . 'users');\n";
$file .= "define('TABLE_COMMENTS', PREFIX . 'comments');\n";
$file .= "define('TABLE_CONFIG', PREFIX . 'config');\n";
$file .= "define('TABLE_CATEGORY', PREFIX . 'category');\n";
$file .= "define('TABLE_PAGES', PREFIX . 'pages');\n";
";
$db3->query($sql3);
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>";
}
$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">
<title>X-Tractor</title>
<link href="../include/sionMenu.css" rel="stylesheet" type="text/css">
<script src="../include/funcionesG.js" language="javascript"></script>
<link rel="stylesheet" type="text/css" href="../jquery/css/theme/jquery-ui.custom.css">
<script type="text/javascript" src="../jquery/js/jquery.min.js"></script>
/**
* 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);
}
