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; }