function showForm($data = "", $msg = "")
{
global $t, $db;
$t->set_file("page", "catNavieraCaptura.inc.html");
$PHP_SELF = $_SERVER['PHP_SELF'];
$idReg = $data[idReg];
$data[naviera] = getValueTable("naviera", "NAVIERA", "id_naviera", $idReg);
$t->set_var(array("ID_REG" => $idReg, "NAVIERA" => $data[naviera], "ACTION" => $PHP_SELF, "MENSAJE" => ""));
$idReg > 0 ? $op = "editar" : ($op = "nuevo");
switch ($op) {
case "editar":
$idReg = $data[idReg];
$t->set_var("GUARDAR", "Guardar");
$t->set_var("ACTUALIZAR", "<a href=\"javascript:submitD(document.frm1,'{$PHP_SELF}','{$idReg}','update')\">Actualizar</a>");
break;
case "nuevo":
$t->set_var("GUARDAR", "<a href=\"javascript:submitD(document.frm1,'{$PHP_SELF}','','rec')\">Guardar</a>");
$t->set_var("ACTUALIZAR", "Actualizar");
break;
}
// Si existen errores, cuenta los errores y arma una cadena con
// todos los errores para despues mostrarla al usuario.
if (!empty($msg)) {
$canErr = count($msg);
if ($canErr > 0) {
foreach ($msg as $val) {
$cadErr .= $val . " <br>";
}
$t->set_var(array("MENSAJE" => $cadErr));
}
}
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $t, $db;
$t->set_file("page", "invModSendE.inc.html");
$PHP_SELF = $_SERVER['PHP_SELF'];
$idReg = $data[idReg];
// Entonces asume que es entrada.
$idConte = getValueTable("id_contenedor", "ENTRADA", "id_entrada", $idReg);
$conteAct = getValueTable("numero", "CONTENEDOR", "id_contenedor", $idConte);
$eir = getValueTable("eir", "ENTRADA", "id_entrada", $idReg);
$eir = "E-" . $eir;
$t->set_var(array("CONTE" => $conteAct, "ACTUALIZAR" => "<a href=\"javascript:submitD(document.frm1,'{$PHP_SELF}','{$idReg}','update')\">Aceptar Cambio</a>", "EIR" => $eir, "FEC_ACT" => $fecAct, "ID_REG" => $idReg, "LOCALIDAD" => $data[localidad], "ACTION" => $PHP_SELF, "MENSAJE" => ""));
// Si existen errores, cuenta los errores y arma una cadena con
// todos los errores para despues mostrarla al usuario.
if (!empty($msg)) {
$canErr = count($msg);
if ($canErr > 0) {
foreach ($msg as $val) {
$cadErr .= $val . " <br>";
}
$t->set_var(array("MENSAJE" => $cadErr));
}
}
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $db, $t, $PHP_SELF, $sesIdUsuario, $hoy, $mscArrPerms, $usuario;
$t->set_file("page", "facCap1.inc.html");
$sesIdUsuario = $_SESSION[sesIdUsuario];
$idCliente = $data[idCliente];
$cliente = getValueTable("cliente", "FT_CLIENTE", "id_cliente", $idCliente);
$email1 = getValueTable("email1", "FT_CLIENTE", "id_cliente", $idCliente);
$email2 = getValueTable("email2", "FT_CLIENTE", "id_cliente", $idCliente);
$email3 = getValueTable("email3", "FT_CLIENTE", "id_cliente", $idCliente);
$hoy = substr($hoy, 0, 10);
$t->set_var(array("ACTION" => $PHP_SELF, "MENSAJE" => "", "EMAIL1" => $email1, "EMAIL2" => $email2, "EMAIL3" => $email3, "ID_CLIENTE" => $data[idCliente], "CLIENTE" => $cliente, "HOY" => $hoy, "RFCAA" => $data[rfcAA]));
// -------------------------------------------
// Control de mensajes
// -------------------------------------------
if (!empty($msg)) {
$canMsg = count($msg);
if ($canMsg > 0) {
foreach ($msg as $val) {
$cadMsg .= $val . " <br>";
}
$t->set_var(array("MENSAJE" => $cadMsg));
}
}
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $t, $db, $sesIdUsuario, $hoy, $PHP_SELF;
$idReg = $data[idReg];
$t->set_file("page", "liqBaja.inc.html");
$t->set_var(array("ID_REG" => $idReg, "ACTION" => $PHP_SELF, "MENSAJE" => ""));
// CONSULTA DE DATOS
if ($idReg > 0) {
$sql = "select * from LIQUIDACION where id_liquidacion='{$idReg}' ";
$db->query($sql);
while ($db->next_record()) {
$idLiq = $db->f(id_liquidacion);
$flgCancel = $db->f(cancel_flg);
$folio = $db->f(folio);
$idOper = $db->f(id_operador);
$operador = getValueTable("operador", "OPERADOR", "id_operador", $idOper);
$flgCancel == "1" ? $stReg = "CANCELADO" : ($stReg = "ACTIVO");
$t->set_var(array("NO_LIQ" => $folio, "OPERADOR" => $operador, "ST_REG" => $stReg));
}
}
// -------------------------------------------
// Control de mensajes
// -------------------------------------------
if (!empty($msg)) {
$canMsg = count($msg);
if ($canMsg > 0) {
foreach ($msg as $val) {
$cadMsg .= $val . " <br>";
}
$t->set_var(array("MENSAJE" => $cadMsg));
}
}
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $t, $db, $sesIdUsuario, $hoy, $PHP_SELF;
$idReg = $data[idReg];
$t->set_file("page", "invAltaPlus.inc.html");
$t->set_var(array("ID_REG" => $idReg, "ACTION" => $PHP_SELF, "MENSAJE" => ""));
// CONSULTA DE DATOS
if ($idReg > 0) {
$sql = "select id_inventario,id_contenedor,eir from INVENTARIO_PLUS where id_inventario='{$idReg}' ";
$db->query($sql);
while ($db->next_record()) {
$idConte = $db->f(id_contenedor);
$idEq = getValueTable("id_equipo", "CONTENEDOR", "id_contenedor", $idConte);
$conte = getValueTable("numero", "CONTENEDOR", "id_contenedor", $idConte);
$equipo = getValueTable("equipo", "EQUIPO", "id_equipo", $idEq);
}
}
$t->set_var(array("EIR" => $eir, "CONTE" => $conte, "EQUIPO" => $equipo));
// -------------------------------------------
// Control de mensajes
// -------------------------------------------
if (!empty($msg)) {
$canMsg = count($msg);
if ($canMsg > 0) {
foreach ($msg as $val) {
$cadMsg .= $val . " <br>";
}
$t->set_var(array("MENSAJE" => $cadMsg));
}
}
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $t, $db;
$t->set_file("page", "catUsuarioChgPas.inc.html");
$PHP_SELF = $_SERVER['PHP_SELF'];
$idReg = $data[idReg];
if ($idReg > 0) {
$usuario = getValueTable("usuario", "USUARIO", "id_usuario", $idReg);
$login = getValueTable("login", "USUARIO", "id_usuario", $idReg);
$pass = getValueTable("password", "USUARIO", "id_usuario", $idReg);
$idNaviera = getValueTable("id_naviera", "USUARIO", "id_usuario", $idReg);
} else {
$idNaviera = $data['idNaviera'];
}
$t->set_var(array("LOGIN" => $login, "PASSWORD" => $pass, "ID_REG" => $idReg, "USUARIO" => $data[usuario], "ACTION" => $PHP_SELF, "MENSAJE" => ""));
$idReg > 0 ? $op = "editar" : ($op = "nuevo");
switch ($op) {
case "editar":
$idReg = $data[idReg];
$t->set_var("ACTUALIZAR", "<a href=\"javascript:submitD(document.frm1,'{$PHP_SELF}','{$idReg}','update')\">Actualizar</a>");
break;
}
// Si existen errores, cuenta los errores y arma una cadena con
// todos los errores para despues mostrarla al usuario.
if (!empty($msg)) {
$canErr = count($msg);
if ($canErr > 0) {
foreach ($msg as $val) {
$cadErr .= $val . " <br>";
}
$t->set_var(array("MENSAJE" => $cadErr));
}
}
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $t, $db, $sesIdUsuario, $hoy, $usuario;
$t->set_file("page", "intro.inc.html");
$sesIdUsuario = $_SESSION[sesIdUsuario];
$PHP_SELF = $_SERVER['PHP_SELF'];
$sisIdOficina = $_SESSION[sesIdOficina];
$oficina = getValueTable("oficina", "OFICINA", "id_oficina", $sisIdOficina);
$opES = $data[opES];
$usuario = getValueTable("usuario", "USUARIO", "id_usuario", $sesIdUsuario);
$t->set_var(array("USUARIO" => $usuario));
// -------------------------------------------
// Control de mensajes
// -------------------------------------------
if (!empty($msg)) {
$canMsg = count($msg);
if ($canMsg > 0) {
foreach ($msg as $val) {
$cadMsg .= $val . " <br>";
}
$t->set_var(array("MENSAJE" => $cadMsg));
}
}
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $t, $db;
$t->set_file("page", "invModFecS.inc.html");
$PHP_SELF = $_SERVER['PHP_SELF'];
$idReg = $data[idReg];
// Entonces asume que es entrada.
$fecAct = getValueTable("cap_fec", "SALIDA", "id_salida", $idReg);
$fecAct1 = substr($fecAct, 0, 10);
$fecAct2 = substr($fecAct, 11, 8);
$eir = getValueTable("eir", "SALIDA", "id_salida", $idReg);
$eir = "S-" . $eir;
$t->set_var(array("ACTUALIZAR" => "<a href=\"javascript:submitD(document.frm1,'{$PHP_SELF}','{$idReg}','update')\">Actualizar</a>", "EIR" => $eir, "FEC_ACT1" => $fecAct1, "FEC_ACT2" => $fecAct2, "ID_REG" => $idReg, "LOCALIDAD" => $data[localidad], "ACTION" => $PHP_SELF, "MENSAJE" => ""));
// Si existen errores, cuenta los errores y arma una cadena con
// todos los errores para despues mostrarla al usuario.
if (!empty($msg)) {
$canErr = count($msg);
if ($canErr > 0) {
foreach ($msg as $val) {
$cadErr .= $val . " <br>";
}
$t->set_var(array("MENSAJE" => $cadErr));
}
}
$t->pparse("out", "page");
}
function reporte($ano, $idEveUsr)
{
global $db, $db2, $workbook, $mscIdUsuario, $hoy;
// HTTP headers
HeaderingExcel('chasisTrackingActual.xls');
// Creating the first worksheet
$worksheet1 =& $workbook->add_worksheet('Hoja1');
$fntTit =& $workbook->add_format();
$fntTit->set_size(12);
$fntTit->set_bold();
$fntTit->set_color('#E0D196');
// Font Black Normal
$fntFit =& $workbook->add_format();
$fntFit->set_size(10);
$fntBlk =& $workbook->add_format();
$fntBlk->set_size(10);
$fntBlk->set_color('black');
$fntBlk->set_bold();
$fntEnc =& $workbook->add_format();
$fntEnc->set_size(10);
$fntEnc->set_color('black');
$fntEnc->set_bold();
$fntEnc->set_align('center');
$fntEnc->set_fg_color('silver');
$fntEnc->set_pattern();
$cliente = getValueTable("cliente", "D_CLIENTE", "id_cliente", $idCliente);
$usuario = getValueTable("Nombre", "USUARIO", "Id_usuario", $mscIdUsuario);
// Encabezado
$pais = getValueTable("pais", "INFO", "id_info", 1);
$worksheet1->write_string(0, 0, "SION :: Mediteranean Shipping Company {$pais}, S.A. DE C.V.", $fntTit);
$worksheet1->write_string(2, 0, "Reporte : Tracking-Actual", $fntFit);
$worksheet1->write_string(3, 0, "Fecha : {$hoy} ", $fntFit);
$worksheet1->write_string(2, 4, "Modulo : Intermodal", $fntFit);
$worksheet1->write_string(3, 4, "Elaboro: {$usuario} ", $fntFit);
// Sub-Encabezado
$worksheet1->set_column(0, 0, 15);
$worksheet1->set_column(1, 1, 7);
$worksheet1->set_column(2, 2, 15);
$worksheet1->set_column(3, 3, 30);
$worksheet1->set_column(4, 5, 13);
$worksheet1->set_column(6, 6, 17);
$worksheet1->set_column(7, 7, 30);
$worksheet1->set_column(8, 8, 20);
$worksheet1->set_column(9, 9, 40);
$worksheet1->write_string(5, 0, "No.Chasis", $fntEnc);
$worksheet1->write_string(5, 1, "Tipo", $fntEnc);
$worksheet1->write_string(5, 2, "Conte", $fntEnc);
$worksheet1->write_string(5, 3, "Movimiento", $fntEnc);
$worksheet1->write_string(5, 4, "Fecha", $fntEnc);
$worksheet1->write_string(5, 5, "Hora", $fntEnc);
$worksheet1->write_string(5, 6, "Transportista", $fntEnc);
$worksheet1->write_string(5, 7, "Predio", $fntEnc);
$worksheet1->write_string(5, 8, "Booking", $fntEnc);
$worksheet1->write_string(5, 9, "Notas", $fntEnc);
$r = 6;
// INCLUIR DATOS
$workbook->close();
}
function showForm($data = "", $msg = "")
{
global $t, $PHP_SELF, $paging, $db;
$t->set_file("page", "catConte.inc.html");
$t->set_var(array("ACTION" => $PHP_SELF, "MENSAJE" => "", "NUEVO" => "<a href=\"javascript:ventanaNueva('catConteCaptura.php',400,400)\">Nuevo</a>"));
// ----------------------------------------------------------------
// Pagin
// Importante. Si realiza 2 busquedas sobre campos bastante grandes,
// alenta la consulta. De preferencia utilice una consulta.
// -----------------------------------------------------------------
$qw = explode_keyword($_GET[keyword]);
$qw2 = explode_keyword2($_GET[keyword2]);
$sql = "select * from CONTENEDOR where {$qw} {$qw2} ";
$paging->query($sql);
$page = $paging->print_info();
// Control de paginación.
if (!empty($page["keyword"])) {
$t->set_var("INFODATA", "Keyword : <b>{$page['keyword']}</b>");
}
if (empty($page["total"])) {
$t->set_var("INFODATA", "<u>Not Found</u>");
} else {
$t->set_var("INFODATA", "Data {$page['start']} - {$page['end']} of {$page['total']} [Total {$page['total_pages']} Pages]");
}
$t->set_block("page", "blqTupla", "lnTupla");
while ($result = $paging->result_assoc()) {
$color = $paging->print_color("#C0C7C8", "#ffffff");
$t->set_var("COLOR_ROW", $color);
$idConte = $result[id_contenedor];
$num = $result[numero];
$idEquipo = $result[id_equipo];
$equipo = getValueTable("equipo", "EQUIPO", "Id_equipo", $idEquipo);
$clase = $result[clase];
$idNav = $result[id_naviera];
$naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNav);
$manu = $result['manufactura'];
$folioImp = $result['folio_imp'];
$t->set_var(array("CONTENEDOR" => $num, "EQUIPO" => $equipo, "EDITAR" => "<a href=\"javascript:ventanaNueva('catConteCaptura.php?modo=editar&idConte={$idConte}',400,400)\">Editar</a>", "CLASE" => $clase, "NAVIERA" => $naviera, "MANU" => $manu, "FOLIO_IMP" => $folioImp));
$t->parse("lnTupla", "blqTupla", true);
}
// ----------------
// Combo de Naviera
// ----------------
$idNaviera = $data[idNaviera];
$sql = "select id_naviera,naviera from NAVIERA where id_naviera not in (9,17) order by naviera ";
$db->query($sql);
$t->set_block("page", "blqNaviera", "linNav");
while ($db->next_record()) {
$idNavieraDB = $db->f('id_naviera');
$naviera = $db->f('naviera');
$idNaviera == $idNavieraDB ? $navSel = "selected" : ($navSel = "");
$t->set_var(array("ID_NAVIERA" => $idNavieraDB, "NAVIERA" => $naviera, "NAVSEL" => $navSel));
$t->parse("linNav", "blqNaviera", true);
}
$control = $paging->print_link();
$t->set_var("CONTROL", $control);
$t->pparse("out", "page");
}
function existeConte($numero)
{
$row = getValueTable("id_contenedor", "CONTENEDOR", "numero", $numero);
if ($row > 0) {
return true;
} else {
return false;
}
}
function existeReg($cliente)
{
$row = getValueTable("id_cliente", "CLIENTE", "cliente", $cliente);
if ($row > 0) {
return true;
} else {
return false;
}
}
function existeReg($cliente)
{
$row = getValueTable("id_operador", "OPERADOR", "operador", $operador);
if ($row > 0) {
return true;
} else {
return false;
}
}
function showForm($data = "", $msg = "")
{
global $t, $paging, $db2;
$PHP_SELF = $_SERVER['PHP_SELF'];
$t->set_file("page", "invConSalSePi.inc.html");
$sesIdOficina = $_SESSION[sesIdOficina];
$oficina = getValueTable("oficina", "OFICINA", "id_oficina", $sesIdOficina);
$t->set_var(array("lnTupla" => "", "ACTION" => $PHP_SELF, "MENSAJE" => "", "OFICINA" => $oficina));
$qw1 = explode_keyword1($_GET[keyword1]);
$sql = "select * from SALIDA_BKG where {$qw1} and id_oficina='3' order by id_salida_bkg desc";
$paging->query($sql);
$page = $paging->print_info();
// Control de paginación.
if (!empty($page["keyword"])) {
$t->set_var("INFODATA", "Keyword : <b>{$page['keyword']}</b>");
}
if (empty($page["total"])) {
$t->set_var("INFODATA", "<u>Not Found</u>");
} else {
$t->set_var("INFODATA", "Data {$page['start']} - {$page['end']} of {$page['total']} [Total {$page['total_pages']} Pages]");
}
$t->set_block("page", "blqTupla", "lnTupla");
while ($result = $paging->result_assoc()) {
$color = $paging->print_color("#C0C7C8", "#ffffff");
$t->set_var("COLOR_ROW", $color);
// DATOS
$idReg = $result[id_salida_bkg];
$bkg = $result[bkg];
$totalSal = $result[total_sal];
$idUsr = $result[id_usr];
$usr = getValueTable("usuario", "USUARIO", "id_usuario", $idUsr);
$idOficina = $result[id_oficina];
$oficina = getValueTable("oficina", "OFICINA", "id_oficina", $idOficina);
$fCap = $result[f_cap];
$capturo = "{$usr} / {$fCap}";
$idOficina = $_SESSION[sesIdOficina];
// Conocer el total de salidas realizadas.
$sql2 = "select count(id_inventario) as TLSAL ";
$sql2 .= "from INVENTARIO where ";
$sql2 .= "ent_sal='S' and bkg='{$bkg}' and st_reg<>'B' and id_oficina='{$idOficina}' ";
$db2->query($sql2);
$nr2 = $db2->num_rows();
while ($db2->next_record()) {
$tlSR = $db2->f('TLSAL');
}
if (empty($nr2) || $nr2 == 0) {
$tlSR = 0;
}
$t->set_var(array("ID_REG" => $idReg, "BKG" => $bkg, "EDITAR" => "<a href='conSalCaptura.php?idReg={$idReg}'><img src=\"../images/b_edit.png\" border=0></a>", "DEL" => "<a href=\"conSalDel.php?idReg={$idReg}\"><img src=\"../images/b_del.png\" border=0></a>", "TOTAL_S" => $totalSal, "TOTAL_SR" => $tlSR, "CAPTURO" => $capturo, "OFICINA" => $oficina));
$t->parse("lnTupla", "blqTupla", true);
}
$control = $paging->print_link();
$t->set_var("CONTROL", $control);
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $t, $paging;
$PHP_SELF = $_SERVER['PHP_SELF'];
$sesIdOficina = $_SESSION[sesIdOficina];
$oficina = getValueTable("oficina", "OFICINA", "id_oficina", $sesIdOficina);
$t->set_file("page", "penConsultaG.inc.html");
$t->set_var(array("lnTupla" => "", "ACTION" => $PHP_SELF, "MENSAJE" => "", "OFICINA" => $oficina));
$qw1 = explode_keyword1($_GET[keyword1]);
$qw2 = explode_keyword2($_GET[keyword2]);
$sql = "select * from PENSION where {$qw1} {$qw2} ";
$sql .= "and id_oficina='{$sesIdOficina}' ";
// 1: Trebol 3: El pino
$sql .= "order by id_pension desc ";
$paging->query($sql);
$page = $paging->print_info();
// Control de paginación.
if (!empty($page["keyword"])) {
$t->set_var("INFODATA", "Keyword : <b>{$page['keyword']}</b>");
}
if (empty($page["total"])) {
$t->set_var("INFODATA", "<u>Not Found</u>");
} else {
$t->set_var("INFODATA", "Data {$page['start']} - {$page['end']} of {$page['total']} [Total {$page['total_pages']} Pages]");
}
$t->set_block("page", "blqTupla", "lnTupla");
while ($result = $paging->result_assoc()) {
$color = $paging->print_color("#C0C7C8", "#ffffff");
$t->set_var("COLOR_ROW", $color);
// DATOS
$idReg = $result[id_pension];
$operador = $result[operador];
$placas = $result[placas];
$idConte = $result[id_contenedor];
$conte = getValueTable("numero", "CONTENEDOR", "id_contenedor", $idConte);
$monto = $result[monto];
$flgCancel = $result[flg_cancel];
$t->set_var(array("ID_REG" => $idReg, "OPERADOR" => $operador, "PLACAS" => $placas, "CONTE" => $conte, "MONTO" => $monto, "EDITAR" => "<a href='penCaptura.php?idReg={$idReg}'><img src=\"../images/b_edit.png\" border=0></a>", "PDF" => "<a href='penPdf.php?idReg={$idReg}'><img src=\"../images/b_print.png\" border=0></a>", "DEL" => "<a href=\"javascript:ventanaNueva('penCancel.php?idReg={$idReg}',400,400)\"><img src=\"../images/b_del.png\" border=0></a>"));
$nota = "";
if ($flgCancel == 1) {
$t->set_var("DEL", "");
$t->set_var("EDITAR", "");
$t->set_var("PDF", "<font color=red>CANCELADO</font>");
$cancelIdUsr = $result[cancel_id_usr];
$cancelUsr = getValueTable("usuario", "USUARIO", "id_usuario", $cancelIdUsr);
$cancelFec = $result[cancel_fec];
$nota = "Cancelador por : {$cancelUsr} / {$cancelFec}";
}
$t->set_var("NOTA", $nota);
$t->parse("lnTupla", "blqTupla", true);
}
$control = $paging->print_link();
$t->set_var("CONTROL", $control);
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $t, $db, $sesIdUsuario, $hoy;
$sesIdUsuario = $_SESSION[sesIdUsuario];
$PHP_SELF = $_SERVER['PHP_SELF'];
$idReg = $data[idReg];
$t->set_file("page", "logAereoCancel.inc.html");
$posicion = getValueTable("posicion", " LOG_GRAL_AEREO", "id_gral_aereo", $idReg);
$t->set_var(array("ID_REG" => $idReg, "ACTION" => $PHP_SELF, "POSICION" => $posicion, "MENSAJE" => ""));
if (empty($idReg) || $idReg == 0) {
$op = "nuevo";
} else {
$op = "editar";
}
switch ($op) {
case "editar":
//$idReg=$data[idReg];
$t->set_var("GUARDAR", "");
$t->set_var("ACTUALIZAR", "<a href=\"javascript:submitD(document.frm1,'{$PHP_SELF}','{$idReg}','update')\"><img src=\"../images/guardarW.gif\" border=\"0\"></a>");
break;
case "nuevo":
$t->set_var("GUARDAR", "<a href=\"javascript:submitD(document.frm1,'{$PHP_SELF}','','rec')\">Guardar</a>");
$t->set_var("ACTUALIZAR", "");
break;
}
/*
// CONSULTA DE DATOS
if( $idReg>0 ){
$sql="select motivo from PENSION where id_demo='$idReg'";
$db->query($sql);
while( $db->next_record() ){
$campo1 = $db->f(campo1);
$campo2 = $db->f(campo2);
}
}
$t->set_var(array(
"CAMPO1"=>$campo1,
"CAMPO2"=>$campo2,
));
*/
// -------------------------------------------
// Control de mensajes
// -------------------------------------------
if (!empty($msg)) {
$canMsg = count($msg);
if ($canMsg > 0) {
foreach ($msg as $val) {
$cadMsg .= $val . " <br>";
}
$t->set_var(array("MENSAJE" => $cadMsg));
}
}
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $t, $db, $sesIdUsuario, $sesArrPerms, $hoy, $usuario;
$t->set_file("page", "opPedidoConsPDF.inc.html");
$PHP_SELF = $_SERVER['PHP_SELF'];
//$idReg = $data[idReg];
$sesIdOficina = $_SESSION[sesIdOficina];
$oficina = getValueTable("oficina", "OFICINA", "id_oficina", $sesIdOficina);
$t->set_var("PEDIDO", "");
$t->set_var(array("PEDIDO" => "", "ACTION" => $PHP_SELF, "MENSAJE" => ""));
// -------------------------------------------
// Consulta de PDF
// -------------------------------------------
$pedido = $_POST['pedido'];
$sql = "select * from PEDIDO_PDF where ";
$sql .= "pedido='{$pedido}' ";
$db->query($sql);
$nr = $db->num_rows();
if (empty($nr)) {
$t->set_var("lnInv", "");
}
$t->set_block("page", "blqInventario", "lnInv");
while ($db->next_record()) {
$idPedidoPDF = $db->f(id_pedido_pdf);
$pedido = $db->f(pedido);
$nombrePDF = $db->f(nombre_pdf);
$idUsr = $db->f(id_usr);
$nombre = getValueTable("usuario", "USUARIO", "id_usuario", $idUsr);
$fecCap = $db->f(fec_cap);
$t->set_var(array("DETALLE" => "<a href=\"javascript:ventanaNueva('opPedidoMostrarPDF.php?nombre={$nombrePDF}',1200,600)\"><img src=\"../images/pdf.gif\" border=0></a>", "PEDIDO" => $pedido, "PDF" => $nombrePDF, "USR" => $nombre, "FEC_UP" => $fecCap));
if ($idUsr == $sesIdUsuario || $usuario->havePerm("1", $_SESSION['sesArrPerms'])) {
//if ($idUsr==$sesIdUsuario ){
$t->set_var("I_BAJA", "<a href=\"javascript:ventanaNueva('opPedidoEliminarPDF.php?idPedidoPDF={$idPedidoPDF}',400,400)\"><img src=\"../images/b_del.png\" border=0></a>");
} else {
$t->set_var("I_BAJA", "");
}
//"I_BAJA"=>"<a href=\"javascript:ventanaNueva('opPedidoEliminarPDF.php?idPedidoPDF=$idPedidoPDF',400,400)\"><img src=\"../images/b_del.png\" border=0></a>",
$t->parse("lnInv", "blqInventario", true);
}
// -------------------------------------------
// Control de mensajes
// -------------------------------------------
if (!empty($msg)) {
$canMsg = count($msg);
if ($canMsg > 0) {
foreach ($msg as $val) {
$cadMsg .= $val . " <br>";
}
$t->set_var(array("MENSAJE" => $cadMsg));
}
}
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $t, $db, $sesIdUsuario, $hoy, $sesIdOficina;
$sesIdUsuario = $_SESSION[sesIdUsuario];
$PHP_SELF = $_SERVER['PHP_SELF'];
$idReg = $data[idReg];
$entSal = $data['entSal'];
$oficina = getValueTable("oficina", "OFICINA", "id_oficina", $sesIdOficina);
$t->set_file("page", "invConSalCap.inc.html");
$t->set_var(array("ID_REG" => $idReg, "ACTION" => $PHP_SELF, "MENSAJE" => "", "DEL" => "", "OFICINA" => $oficina));
if (empty($idReg) || $idReg == 0) {
$op = "nuevo";
} else {
$op = "editar";
}
switch ($op) {
case "editar":
//$idReg=$data[idReg];
$t->set_var("GUARDAR", "");
$t->set_var("ACTUALIZAR", "<a href=\"javascript:submitD(document.frm1,'{$PHP_SELF}','{$idReg}','update')\"><img src=\"../images/guardarW.gif\" border=\"0\"></a>");
$t->set_var("DEL", "<a href=\"javascript:submitD(document.frm1,'{$PHP_SELF}','{$idReg}','del')\"><img src=\"../images/b_del.png\" border=\"0\"></a>");
break;
case "nuevo":
$t->set_var("GUARDAR", "<a href=\"javascript:submitD(document.frm1,'{$PHP_SELF}','','rec')\">GUARDAR</a>");
$t->set_var("ACTUALIZAR", "");
break;
}
// CONSULTA DE DATOS
if ($idReg > 0) {
$sql = "select * from SALIDA_BKG where id_salida_bkg='{$idReg}'";
$db->query($sql);
while ($db->next_record()) {
$bkg = $db->f(bkg);
$totalSal = $db->f(total_sal);
}
}
$t->set_var(array("BKG" => $bkg, "TOTAL_SAL" => $totalSal));
// -------------------------------------------
// Control de mensajes
// -------------------------------------------
if (!empty($msg)) {
$canMsg = count($msg);
if ($canMsg > 0) {
foreach ($msg as $val) {
$cadMsg .= $val . " <br>";
}
$t->set_var(array("MENSAJE" => $cadMsg));
}
}
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $t, $PHP_SELF, $paging, $db2;
$t->set_file("page", "catUsuario.inc.html");
$t->set_var(array("lnTupla" => "", "ACTION" => $PHP_SELF, "MENSAJE" => "", "NUEVO" => "<a href=\"javascript:ventanaNueva('catUsuarioCaptura.php?modo=nuevo',700,700)\">Nuevo</a>"));
// ----------------------------------------------------------------
// Pagin
// Importante. Si realiza 2 busquedas sobre campos bastante grandes,
// alenta la consulta. De preferencia utilice una consulta.
// -----------------------------------------------------------------
$qw = explode_keyword($_GET[keyword]);
$sql = "select * from USUARIO where {$qw} order by usuario";
$paging->query($sql);
$page = $paging->print_info();
// Control de paginación.
if (!empty($page["keyword"])) {
$t->set_var("INFODATA", "Keyword : <b>{$page['keyword']}</b>");
}
if (empty($page["total"])) {
$t->set_var("INFODATA", "<u>Not Found</u>");
} else {
$t->set_var("INFODATA", "Data {$page['start']} - {$page['end']} of {$page['total']} [Total {$page['total_pages']} Pages]");
}
$t->set_block("page", "blqTupla", "lnTupla");
while ($result = $paging->result_assoc()) {
$color = $paging->print_color("#C0C7C8", "#ffffff");
$t->set_var("COLOR_ROW", $color);
$idUsuario = $result[id_usuario];
$usuario = $result[usuario];
$idNaviera = $result[id_naviera];
$naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNaviera);
$idOficina = $result[id_oficina];
$oficina = getValueTable("oficina", "OFICINA", "id_oficina", $idOficina);
$login = $result[login];
// Detectar el perfil.
$txPerm = "";
$sql2 = "select id_permiso from REL_USR_PERM where id_usuario='{$idUsuario}'";
$db2->query($sql2);
while ($db2->next_record()) {
$idPermiso = $db2->f(id_permiso);
$permiso = getValueTable("permiso", "PERMISO", "id_permiso", $idPermiso);
$txPerm .= $permiso . ",";
}
$t->set_var(array("PERFIL" => $txPerm, "USUARIO" => $usuario, "LOGIN" => $login, "NAVIERA" => $naviera, "OFICINA" => $oficina, "EDITAR" => "<a href=\"javascript:ventanaNueva('catUsuarioCaptura.php?idReg={$idUsuario}',400,400)\">Editar</a>", "CAMBIO_PASS" => "<a href=\"javascript:ventanaNueva('catUsuarioChgPas.php?idReg={$idUsuario}',400,400)\">Password</a>"));
$t->parse("lnTupla", "blqTupla", true);
}
$control = $paging->print_link();
$t->set_var("CONTROL", $control);
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $t, $db, $sesIdUsuario, $hoy;
$sesIdUsuario = $_SESSION[sesIdUsuario];
$PHP_SELF = $_SERVER['PHP_SELF'];
//$idReg = $data[idReg];
$entSal = $data['entSal'];
if ($entSal == "E") {
$entSalTx = "NUEVA ENTRADA";
}
if ($entSal == "S") {
$entSalTx = "NUEVA SALIDA";
}
$t->set_file("page", "invInCapturaG.inc.html");
$sisIdOficina = $_SESSION[sesIdOficina];
$oficina = getValueTable("oficina", "OFICINA", "id_oficina", $sisIdOficina);
$opES = $data[opES];
$conte = $data[conte];
$t->set_var(array("ID_REG" => $idReg, "ACTION" => $PHP_SELF, "ENT_SAL_LABEL" => $entSalTx, "ENT_SAL" => $entSal, "MENSAJE" => "", "OFICINA" => $oficina, "OPES" => $opES, "CONTE" => $conte, "ALERT_ST" => "hide"));
if (empty($idReg) || $idReg == 0) {
$op = "nuevo";
} else {
$op = "editar";
}
switch ($op) {
case "editar":
//$idReg=$data[idReg];
$t->set_var("GUARDAR", "");
$t->set_var("ACTUALIZAR", "<a href=\"javascript:submitD(document.frm1,'{$PHP_SELF}','{$idReg}','update')\"><img src=\"../images/guardarW.gif\" border=\"0\"></a>");
break;
case "nuevo":
$t->set_var("GUARDAR", "<a href=\"javascript:submitD(document.frm1,'{$PHP_SELF}','','rec')\">Continuar >> </a>");
$t->set_var("ACTUALIZAR", "");
break;
}
// -------------------------------------------
// Control de mensajes
// -------------------------------------------
if (!empty($msg)) {
$canMsg = count($msg);
if ($canMsg > 0) {
foreach ($msg as $val) {
$cadMsg .= $val . " <br>";
}
$t->set_var(array("ALERT_ST" => "", "MENSAJE" => $cadMsg));
}
}
$t->pparse("out", "page");
}
function getTlPayment($bl = "")
{
global $dbf;
/*
CONCEPTOS DETECTADOS
+-------------+--------------------------+
| Id_concepto | Nombre |
+-------------+--------------------------+
| 1 | THC |
| 2 | FLETE |
| 7 | OTROS CARGOS |
| 8 | TERRESTRE |
| 9 | DOC.FEE |
| 11 | * EXCEDENTE FLETE |
| 12 | * TERR.FUERA DE BL. |
| 16 | MANIFEST CORRECTOR |
| 18 | FLETE MARITIMO |
| 27 | ADMIN FEE |
| 29 | CAMBIO DESTINO (COD) |
| 36 | TERRESTRE DENTRO DE BL |
| 39 | CAMBIO DE MOD. TERRESTRE |
| 40 | OPTIONAL FEE |
| 38 | MULTA |
| 23 | * RE-IMP.BLS |
+-------------+--------------------------+
(*) Estos fueros excluidos por que no forman parte de la cobranza dentro de Bl.
*/
$bl = trim($bl);
$idBl = getValueTable("Id_expo", "EXPO", "Bl", $bl);
if (!empty($idBl)) {
$sql = "select c.Importe_usd as cImporte ";
$sql .= "from CARGO c, ENTRADA e ";
$sql .= "where c.Id_entrada=e.Id_entrada and ";
//$sql.="c.Id_expo='$idBl' and c.Id_concepto in (1,2,7,8,9,11,16,18,27,29,36,39,40,38) and ";
$sql .= "c.Id_expo='{$idBl}' and c.Id_concepto in (1,2,7,8,9,16,18,27,29,36,39,40,38) and ";
$sql .= "e.Ok_validacion='1' ";
$dbf->query($sql);
while ($dbf->next_record()) {
$importe = $dbf->f(cImporte);
$tlImporte += $importe;
}
if ($tlImporte > 0) {
return $tlImporte;
} else {
return "0.00";
}
}
}
function showForm($data = "", $msg = "")
{
global $t, $db, $sesIdUsuario, $hoy, $PHP_SELF;
$idReg = $data[idReg];
$entSal = $data[entSal];
$t->set_file("page", "invBaja.inc.html");
$t->set_var(array("ID_REG" => $idReg, "ENTSAL" => $entSal, "ACTION" => $PHP_SELF, "MENSAJE" => ""));
// CONSULTA DE DATOS
if ($idReg > 0) {
if ($entSal == "EL") {
$sql = "select id_entrada,id_contenedor,eir,st_reg from ENTRADA_LLENO where id_entrada='{$idReg}' ";
} else {
$sql = "select id_entrada,id_contenedor,eir,st_reg from ENTRADA where id_entrada='{$idReg}' ";
}
$db->query($sql);
while ($db->next_record()) {
$idEntrada = $db->f(id_entrada);
//$entSal = $db->f(ent_sal);
$eir = $db->f(eir);
if ($entSal == "EL") {
$eir = "EL-" . $eir;
} else {
$eir = "E-" . $eir;
}
$idConte = $db->f(id_contenedor);
$idEq = getValueTable("id_equipo", "CONTENEDOR", "id_contenedor", $idConte);
$conte = getValueTable("numero", "CONTENEDOR", "id_contenedor", $idConte);
$equipo = getValueTable("equipo", "EQUIPO", "id_equipo", $idEq);
$stReg = $db->f(st_reg);
}
}
$stReg == "B" ? $stReg = "BAJA" : ($stReg = "ALTA");
$t->set_var(array("EIR" => $eir, "CONTE" => $conte, "EQUIPO" => $equipo, "ST_REG" => $stReg));
// -------------------------------------------
// Control de mensajes
// -------------------------------------------
if (!empty($msg)) {
$canMsg = count($msg);
if ($canMsg > 0) {
foreach ($msg as $val) {
$cadMsg .= $val . " <br>";
}
$t->set_var(array("MENSAJE" => $cadMsg));
}
}
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $t, $paging;
$PHP_SELF = $_SERVER['PHP_SELF'];
$t->set_file("page", "liqCons.inc.html");
$t->set_var(array("lnTupla" => "", "ACTION" => $PHP_SELF, "MENSAJE" => ""));
$qw1 = explode_keyword1($_GET[keyword1]);
//$qw2= explode_keyword2($_GET[keyword2]);
$sql = "select * from LIQUIDACION where {$qw1} order by id_liquidacion desc";
$paging->query($sql);
$page = $paging->print_info();
// Control de paginación.
if (!empty($page["keyword"])) {
$t->set_var("INFODATA", "Keyword : <b>{$page['keyword']}</b>");
}
if (empty($page["total"])) {
$t->set_var("INFODATA", "<u>Not Found</u>");
} else {
$t->set_var("INFODATA", "Data {$page['start']} - {$page['end']} of {$page['total']} [Total {$page['total_pages']} Pages]");
}
$t->set_block("page", "blqTupla", "lnTupla");
while ($result = $paging->result_assoc()) {
$color = $paging->print_color("#C0C7C8", "#ffffff");
$t->set_var("COLOR_ROW", $color);
// DATOS
$idReg = $result[id_liquidacion];
$folio = $result[folio];
$idOperador = $result[id_operador];
$operador = getValueTable("operador", "OPERADOR", "id_operador", $idOperador);
$perF1 = $result[per_f1];
$perF2 = $result[per_f2];
$cancelFlg = $result[cancel_flg];
$cancelIdUsr = $result[cancel_id_usr];
$cancelUsr = getValueTable("usuario", "USUARIO", "id_usuario", $cancelIdUsr);
$cancelFec = $result[cancel_fec];
$cancelFlg == 1 ? $cancelSt = "CANCELADO" : ($cancelSt = "");
$t->set_var(array("ID_REG" => $idReg, "FOLIO" => $folio, "OPERADOR" => $operador, "PERF1" => $perF1, "PERF2" => $perF2, "EDITAR" => "<a href='liq02.php?idReg={$idReg}&modo=form2'><i class=\"icon-folder-open\"></i></a>", "PDF" => "<a href=\"liq02.php?idReg={$idReg}&modo=print\"><i class=\"icon-print\"></i></a>", "BAJA" => "<a href=\"javascript:ventanaNueva('liqBaja.php?idReg={$idReg}',400,300)\"><i class=\"icon-trash\"></i></a>", "CANCEL_ST" => $cancelSt, "CANCEL_USR" => $cancelUsr, "CANCEL_FEC" => $cancelFec));
$t->parse("lnTupla", "blqTupla", true);
}
$control = $paging->print_link();
$t->set_var("CONTROL", $control);
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $t, $PHP_SELF, $paging, $idOficina;
$t->set_file("page", "menuInv.inc.html");
$oficina = getValueTable("oficina", "OFICINA", "id_oficina", $idOficina);
$t->set_var(array("lnTupla" => "", "ACTION" => $PHP_SELF, "MENSAJE" => "", "OFICINA" => $oficina));
// -------------------------------------------
// Control de mensajes
// -------------------------------------------
if (!empty($msg)) {
$canMsg = count($msg);
if ($canMsg > 0) {
foreach ($msg as $val) {
$cadMsg .= $val . " <br>";
}
$t->set_var(array("MENSAJE" => $cadMsg));
}
}
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $db, $t, $PHP_SELF;
$t->set_file("page", "opUploadGuia.inc.html");
$idGuia = $data[idGuia];
$folio = getValueTable("folio", "GUIA", "id_guia", $idGuia);
// inicializar vars
$t->set_var("ACTION", $PHP_SELF);
$t->set_var("MENSAJE", "");
$t->set_var("FOLIO", $folio);
$t->set_var("ID_GUIA", $idGuia);
// ---------------------
// Archivos cargados
// ---------------------
// File No 1.
if (file_exists("../filesUp1/{$idGuia}.zip")) {
$t->set_var(array("FILE1_NAME" => "{$idGuia}.zip", "FILE1_ICON" => "<a href=\"../filesUp1/{$idGuia}.zip\"><img border=0 width=\"20\" src=\"../images/zip.gif\"></a>", "FILE1_DEL" => "<a href=\"javascript:delFile(document.frm1,'{$PHP_SELF}',1)\"><img src=\"../images/b_drop.png\"></a>"));
} else {
$t->set_var(array("FILE1_NAME" => "", "FILE1_ICON" => "", "FILE1_DEL" => ""));
}
// File No 2.
if (file_exists("../filesUp2/{$idGuia}.zip")) {
$t->set_var(array("FILE2_NAME" => "{$idGuia}.zip", "FILE2_ICON" => "<a href=\"../filesUp2/{$idGuia}.zip\"><img border=0 width=\"20\" src=\"../images/zip.gif\"></a>", "FILE2_DEL" => "<a href=\"javascript:delFile(document.frm1,'{$PHP_SELF}',2)\"><img src=\"../images/b_drop.png\"></a>"));
} else {
$t->set_var(array("FILE2_NAME" => "", "FILE2_ICON" => "", "FILE2_DEL" => ""));
}
// -------------------------------------------
// Control de mensajes
// -------------------------------------------
if (!empty($msg)) {
$canMsg = count($msg);
if ($canMsg > 0) {
foreach ($msg as $val) {
$cadMsg .= $val . " <br>";
}
$t->set_var(array("MENSAJE" => $cadMsg));
}
}
$t->pparse("out", "page");
}
function showForm($idUsuario)
{
global $db, $t, $PHP_SELF;
$t->set_file("page", "catUsuarioPermiso.inc.html");
$nombre = getValueTable("nombre", "USUARIO", "Id_usuario", $idUsuario);
// inicializar vars
$t->set_var("ACTION", $PHP_SELF);
$t->set_var("NOMBRE", $nombre);
$t->set_var("ID_USUARIO", $idUsuario);
$t->set_var("ELIMINAR", "");
// Rellenar la tabla de los permisos del usuario
$sql = "select * from REL_USR_PERM r, PERMISO p where r.id_usuario='{$idUsuario}' and ";
$sql .= "r.id_permiso=p.id_permiso ";
$db->query($sql);
$nr = $db->num_rows();
$t->set_block("page", "blqPermiso", "linPermiso");
while ($db->next_record()) {
$idRelUsrPerm = $db->f(id_rel_usr_perm);
$idPermiso = $db->f(id_permiso);
$permiso = getValueTable("permiso", "PERMISO", "id_permiso", $idPermiso);
$t->set_var("ID_REL_USR_PER", $idRelUsrPerm);
$t->set_var("PERMISO", $permiso);
$t->set_var("ELIMINAR", "<a href=\"javascript:emulSubmit(document.frmCaptura,'{$PHP_SELF}','del')\">Eliminar</a>");
$t->parse("linPermiso", "blqPermiso", true);
}
if (empty($nr)) {
$t->set_var("linPermiso", "");
}
// Rellenar combo de permiso X, para poder agregar permisos al usuario.
$sql = "select * from PERMISO order by permiso";
$db->query($sql);
$t->set_block("page", "blqPermisoX", "linPermisoX");
while ($db->next_record()) {
$t->set_var(array("PERMISO_X" => $db->f(permiso), "ID_PERMISO_X" => $db->f(id_permiso)));
$t->parse("linPermisoX", "blqPermisoX", true);
}
$t->set_var("ACEPTAR", "<a href=\"javascript:emulSubmit(document.frmCaptura,'{$PHP_SELF}','rec')\">Agregar</a>");
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $t, $PHP_SELF, $paging;
$t->set_file("page", "catConteRO.inc.html");
$t->set_var(array("ACTION" => $PHP_SELF, "MENSAJE" => "", "NUEVO" => "<a href=\"javascript:ventanaNueva('catConteCaptura.php?modo=nuevo',300,300)\">Nuevo</a>"));
// ----------------------------------------------------------------
// Pagin
// Importante. Si realiza 2 busquedas sobre campos bastante grandes,
// alenta la consulta. De preferencia utilice una consulta.
// -----------------------------------------------------------------
$qw = explode_keyword($_GET[keyword]);
$sql = "select * from CONTENEDOR where {$qw} ";
$paging->query($sql);
$page = $paging->print_info();
// Control de paginación.
if (!empty($page["keyword"])) {
$t->set_var("INFODATA", "Keyword : <b>{$page['keyword']}</b>");
}
if (empty($page["total"])) {
$t->set_var("INFODATA", "<u>Not Found</u>");
} else {
$t->set_var("INFODATA", "Data {$page['start']} - {$page['end']} of {$page['total']} [Total {$page['total_pages']} Pages]");
}
$t->set_block("page", "blqTupla", "lnTupla");
while ($result = $paging->result_assoc()) {
$color = $paging->print_color("#C0C7C8", "#ffffff");
$t->set_var("COLOR_ROW", $color);
$idConte = $result[id_contenedor];
$num = $result[numero];
$idEquipo = $result[id_equipo];
$equipo = getValueTable("equipo", "EQUIPO", "Id_equipo", $idEquipo);
$clase = $result[clase];
$t->set_var(array("CONTENEDOR" => $num, "EQUIPO" => $equipo, "EDITAR" => "<a href=\"javascript:selectConte('{$num}','{$equipo}')\">Capturar</a>", "CLASE" => $clase));
$t->parse("lnTupla", "blqTupla", true);
}
$control = $paging->print_link();
$t->set_var("CONTROL", $control);
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $t, $PHP_SELF, $paging, $idNaviera, $db, $usuario;
$t->set_file("page", "invInSearch2.inc.html");
// $naviera = getValueTable("naviera","NAVIERA","id_naviera",$idNaviera);
$sisIdOficina = $_SESSION[sesIdOficina];
$oficina = getValueTable("oficina", "OFICINA", "id_oficina", $sisIdOficina);
$t->set_var(array("lnTupla" => "", "ACTION" => $PHP_SELF, "MENSAJE" => "", "OFICINA" => $oficina));
// ----------------
// Combo de Naviera
// ----------------
$idNaviera = $data[idNaviera];
$sql = "select id_naviera,naviera from NAVIERA order by naviera ";
$db->query($sql);
$t->set_block("page", "blqNaviera", "linNav");
while ($db->next_record()) {
$idNavieraDB = $db->f('id_naviera');
$naviera = $db->f('naviera');
$idNaviera == $idNavieraDB ? $navSel = "selected" : ($navSel = "");
$t->set_var(array("ID_NAVIERA" => $idNavieraDB, "NAVIERA" => $naviera, "NAVSEL" => $navSel));
$t->parse("linNav", "blqNaviera", true);
}
// ----------------------------------------------------------------
// Pagin
// Importante. Si realiza 2 busquedas sobre campos bastante grandes,
// alenta la consulta. De preferencia utilice una consulta.
// -----------------------------------------------------------------
$qw1 = explode_keyword($_GET[keyword]);
// Busqueda por contenedor
$qw2 = explode_keyword2($_GET[keyword2]);
// Busqueda por fecha
$qw3 = explode_keyword3($_GET[keyword3]);
// Busqueda por sello
$qw4 = explode_keyword4($_GET[keyword4]);
// Busqueda por damage
$qw5 = explode_keyword5($_GET[keyword5]);
// Buscar por linea
$qw6 = explode_keyword6($_GET[keyword6]);
// Oficina
$sesIdOficina = $_SESSION[sesIdOficina];
$sql = "select * from ENTRADA where {$qw1} {$qw2} {$qw3} {$qw4} {$qw5} {$qw6} ";
if (!$usuario->havePerm("1", $_SESSION['sesArrPerms'])) {
$sql .= "and id_oficina='{$sesIdOficina}' ";
}
$sql .= "order by eir desc";
$paging->query($sql);
$page = $paging->print_info();
// Control de paginación.
if (!empty($page["keyword"])) {
$t->set_var("INFODATA", "Keyword : <b>{$page['keyword']}</b>");
}
if (empty($page["total"])) {
$t->set_var("INFODATA", "<u>Not Found</u>");
} else {
$t->set_var("INFODATA", "Data {$page['start']} - {$page['end']} of {$page['total']} [Total {$page['total_pages']} Pages]");
}
$t->set_block("page", "blqTupla", "lnTupla");
while ($result = $paging->result_assoc()) {
$color = $paging->print_color("#C0C7C8", "#ffffff");
$t->set_var("COLOR_ROW", $color);
$idEntrada = $result[id_entrada];
//$entSal = $result[ent_sal];
$idReg = $result[id_entrada];
$eir = $result[eir];
$idConte = $result[id_contenedor];
$conte = getValueTable("numero", "CONTENEDOR", "id_contenedor", $idConte);
$idEq = getValueTable("id_equipo", "CONTENEDOR", "id_contenedor", $idConte);
$equipo = getValueTable("equipo", "EQUIPO", "id_equipo", $idEq);
$chasis = $result[chasis];
$idNaviera = $result[id_naviera];
$naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNaviera);
$idTrans = $result[id_transporte];
$transp = getValueTable("transporte", "TRANSPORTE", "id_transporte", $idTrans);
$maniStPago = $result[mani_st_pago];
$maniCosto = $result[mani_costo];
$maniRecibo = $result[recibo];
$status = $result[status];
$cliente = $result[consig];
$transp = $result[transportista];
$operador = $result[operador];
// if($status=="IV")$status="IMP.VACIO";
// $idCliente = $result[id_cliente];
// $cliente = getValueTable("cliente","CLIENTE","id_cliente",$idCliente);
$idNome = $result[id_nome];
$nome = getValueTable("nombre", "NOMENCLATURA", "id_nome", $idNome);
$ubicacion = $result[ubicacion];
$clase = $result[clase];
$sello = $result[sello];
$reforzado = $result[reforzado];
$lavado = $result[lavado];
$placas = $result[placas];
$capFecha = $result[cap_fec];
$capIdUsr = $result[cap_id_usr];
$capUsr = getValueTable("usuario", "USUARIO", "id_usuario", $capIdUsr);
$okDm = $result[damage];
if ($okDm == "DM") {
$okDm = "<font color=red>DM</font>";
}
// En caso de baja de registro, saber quien y cuando se realizo.
$stReg = $resul['st_reg'];
$modBajaIdUsr = $result['mod_baja_id_usr'];
$modBajaUsr = getValueTable("usuario", "USUARIO", "id_usuario", $modBajaIdUsr);
$modBajaFec = $result['mod_baja_fec'];
$stReg = $result['st_reg'];
$stReg == "B" ? $notaReg = "Baja de registro por {$modBajaUsr} - {$modBajaFec}" : ($notaReg = "");
$idOficina = $result['id_oficina'];
$oficina = getValueTable("oficina", "OFICINA", "id_oficina", $idOficina);
$numLin++;
$t->set_var(array("EIR" => "E-{$eir}", "FECHA" => $capFecha, "OK_DM" => $okDm, "OPERADOR" => $operador, "PLACAS" => $placas, "REFORZADO" => $reforzado, "LAVADO" => $lavado, "CLASE" => $clase, "SELLO" => $sello, "CLIENTE" => $cliente, "TRANSP" => $transp, "NAVIERA" => $naviera, "STATUS" => $status, "CHASIS" => $chasis, "NOME" => $nome, "UBICACION" => $ubicacion, "CONTE" => $conte, "TIPO" => $equipo, "ID_REG" => $idReg, "HORA" => $hora, "MINUTO" => $min, "SAL_F" => $salF, "SAL_H" => $salH, "SAL_M" => $salM, "NUM_LIN" => $numLin, "NOTA_REG" => $notaReg, "OFICINA" => $oficina));
$stReg = $result[st_reg];
if ($stReg == "B") {
$t->set_var(array("ST_REG" => "<b><font color=red>-BAJA-</font></b>", "COLOR_ROW" => "#FF8080", "EDITAR" => "", "BAJA" => "", "PDF" => ""));
} else {
$t->set_var(array("ST_REG" => "", "EDITAR" => "<a href='invEntPlus.php?idReg={$idEntrada}'><img src=\"../images/b_edit.png\" border=0></a>", "BAJA" => "<a href=\"javascript:ventanaNueva('invBajaEntPlus.php?idReg={$idEntrada}',270,300)\"><img src=\"../images/b_del.png\" border=0></a>", "PDF" => "<a href='eirPdf3Plus.php?idReg={$idEntrada}'><img src=\"../images/b_print.png\" border=0></a>"));
}
$t->parse("lnTupla", "blqTupla", true);
}
$control = $paging->print_link();
$t->set_var("CONTROL", $control);
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $t, $paging;
$PHP_SELF = $_SERVER['PHP_SELF'];
$sesIdOficina = $_SESSION[sesIdOficina];
$oficina = getValueTable("oficina", "OFICINA", "id_oficina", $sesIdOficina);
$t->set_file("page", "logConsAereo.inc.html");
$t->set_var(array("lnTupla" => "", "ACTION" => $PHP_SELF, "MENSAJE" => "", "OFICINA" => $oficina));
$qw1 = explode_keyword1($_GET[keyword1]);
$qw2 = explode_keyword2($_GET[keyword2]);
$sql = "select * from LOG_GRAL_AEREO where {$qw1} {$qw2} ";
$sql .= "order by cap_fec desc ";
$paging->query($sql);
$page = $paging->print_info();
// Control de paginación.
if (!empty($page["keyword"])) {
$t->set_var("INFODATA", "Keyword : <b>{$page['keyword']}</b>");
}
if (empty($page["total"])) {
$t->set_var("INFODATA", "<u>Not Found</u>");
} else {
$t->set_var("INFODATA", "Data {$page['start']} - {$page['end']} of {$page['total']} [Total {$page['total_pages']} Pages]");
}
$t->set_block("page", "blqTupla", "lnTupla");
while ($result = $paging->result_assoc()) {
$color = $paging->print_color("#C0C7C8", "#ffffff");
$t->set_var("COLOR_ROW", $color);
// DATOS
$idReg = $result[id_gral_aereo];
$transportista = $result[transportista];
$maeb = $result[maeb];
//$hBl = $result[h_bl];
$posicion = $result[posicion];
//$buque = $result[buque];
//$viaje = $result[viaje];
$nota = $result[nota];
$idCapUsr = $result[cap_usr];
$capFec = $result[cap_fec];
$flgCancel = $result[flg_cancel];
$impoExpo = $result[impo_expo];
$idUsrCancel = $result[usr_cancel];
$fecCancel = $result[fec_cancel];
$notaCancel = $result[nota_cancel];
$capUsr = getValueTable("usuario", "USUARIO", "id_usuario", $idCapUsr);
$usrCancel = getValueTable("usuario", "USUARIO", "id_usuario", $idUsrCancel);
$flgBloq = getValueTable("flg_bloq", "LOG_GRAL_AEREO", "id_gral_aereo", $idReg);
if ($flgBloq == "1") {
$status = "BLOQUEADO";
$t->set_var("STATUS", $status);
} else {
$t->set_var("STATUS", "ACTIVO");
}
$t->set_var(array("ID_REG" => $idReg, "TRANSPORTISTA" => $transportista, "MAEB" => $maeb, "POSICION" => $posicion, "NOTA" => $nota, "CAP_USR" => $capUsr, "FEC_CAP" => $capFec, "IMPO_EXPO" => $impoExpo, "USR_CANCEL" => $usrCancel, "FEC_CANCEL" => $fecCancel, "NOTA_CANCEL" => $notaCancel, "COLOR" => "black"));
if ($impoExpo == 'IMPO') {
$t->set_var(array("EDITAR" => "<a href='logCapAereo.php?idReg={$idReg}'><img src=\"../images/b_edit.png\" border=0></a>", "DEL" => "<a href=\"javascript:ventanaNueva('logAereoCancel.php?idReg={$idReg}',400,400)\"><img src=\"../images/b_del.png\" border=0></a>"));
} elseif ($impoExpo == 'EXPO') {
$t->set_var(array("EDITAR" => "<a href='logCapAereo.php?idReg={$idReg}'><img src=\"../images/b_edit.png\" border=0></a>", "DEL" => "<a href=\"javascript:ventanaNueva('logAereoCancel.php?idReg={$idReg}',400,400)\"><img src=\"../images/b_del.png\" border=0></a>"));
}
//$nota="";
if ($flgCancel == 1) {
$t->set_var("DEL", "");
$t->set_var("EDITAR", "");
$t->set_var("COLOR_ROW", "silver");
$t->set_var("COLOR", "red");
$t->set_var(array("M_BL" => "Cancelado", "H_BL" => "Cancelado", "BUQUE" => "Cancelado", "VIAJE" => "Cancelado", "NOTA" => $notaCancel, "CAP_USR" => "Cancelado", "FEC_CAP" => "Cancelado", "IMPO_EXPO" => "Cancelado", "STATUS" => "Cancelado"));
$cancelIdUsr = $result[cancel_id_usr];
$cancelUsr = getValueTable("usuario", "USUARIO", "id_usuario", $cancelIdUsr);
$cancelFec = $result[cancel_fec];
//$nota= "Cancelador por : $cancelUsr / $cancelFec";
}
//$t->set_var("NOTA",$nota);
$t->parse("lnTupla", "blqTupla", true);
}
$control = $paging->print_link();
$t->set_var("CONTROL", $control);
$t->pparse("out", "page");
}
function showForm($data = "", $msg = "")
{
global $t, $PHP_SELF, $paging, $idNaviera;
$t->set_file("page", "invNavOut.inc.html");
$naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNaviera);
$t->set_var(array("lnTupla" => "", "ACTION" => $PHP_SELF, "MENSAJE" => "", "NAVIERA" => $naviera));
// ----------------------------------------------------------------
// Pagin
// Importante. Si realiza 2 busquedas sobre campos bastante grandes,
// alenta la consulta. De preferencia utilice una consulta.
// -----------------------------------------------------------------
$qw1 = explode_keyword($_GET[keyword]);
// Busqueda por contenedor
$qw2 = explode_keyword2($_GET[keyword2]);
// Busqueda por fecha
$qw3 = explode_keyword3($_GET[keyword3]);
// Busqueda por sello
$qw4 = explode_keyword4($_GET[keyword4]);
// Busqueda por damage
$qw5 = explode_keyword5($_GET[keyword5]);
if ($idNaviera > 0) {
$sql = "select * from ENTRADA where {$qw1} {$qw2} {$qw3} {$qw4} {$qw5} and id_naviera='{$idNaviera}' and ent_sal='S' order by id_entrada desc";
}
$paging->query($sql);
$page = $paging->print_info();
// Control de paginación.
if (!empty($page["keyword"])) {
$t->set_var("INFODATA", "Keyword : <b>{$page['keyword']}</b>");
}
if (empty($page["total"])) {
$t->set_var("INFODATA", "<u>Not Found</u>");
} else {
$t->set_var("INFODATA", "Data {$page['start']} - {$page['end']} of {$page['total']} [Total {$page['total_pages']} Pages]");
}
$t->set_block("page", "blqTupla", "lnTupla");
while ($result = $paging->result_assoc()) {
$color = $paging->print_color("#C0C7C8", "#ffffff");
$t->set_var("COLOR_ROW", $color);
$entSal = $result[ent_sal];
$idReg = $result[id_entrada];
$eir = "{$entSal}-{$idReg}";
//$eir = $result[eir];
$fecEnt = $result[fec_ent];
$hora = $result[hora];
$min = $result[minuto];
$idConte = $result[id_contenedor];
$conte = getValueTable("numero", "CONTENEDOR", "id_contenedor", $idConte);
$idEq = getValueTable("id_equipo", "CONTENEDOR", "id_contenedor", $idConte);
$equipo = getValueTable("equipo", "EQUIPO", "id_equipo", $idEq);
$chasis = $result[chasis];
$idNaviera = $result[id_naviera];
$naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNaviera);
$maniStPago = $result[mani_st_pago];
$maniCosto = $result[mani_costo];
$maniRecibo = $result[recibo];
$status = $result[status];
$clase = $result[clase];
$sello = $result[sello];
$reforzado = $result[reforzado];
$lavado = $result[lavado];
$placas = $result[placas];
$okDm = $result[damage];
if ($okDm == "DM") {
$okDm = "<font color=red>DM</font>";
}
$capFec = $result[cap_fec];
$cliente = $result[consig];
$transp = $result[transportista];
$operador = $result[operador];
$t->set_var(array("OK_DM" => $okDm, "OPERADOR" => $operador, "PLACAS" => $placas, "REFORZADO" => $reforzado, "LAVADO" => $lavado, "CLASE" => $clase, "SELLO" => $sello, "CLIENTE" => $cliente, "TRANSP" => $transp, "NAVIERA" => $naviera, "STATUS" => $status, "CHASIS" => $chasis, "NOME" => $nome, "UBICACION" => $ubicacion, "CONTE" => $conte, "TIPO" => $equipo, "ID_REG" => $idReg, "EIR" => $eir, "FECHA" => $capFec, "EDITAR" => "<a href='invIn.php?idReg={$idReg}'><img src=\"../images/b_edit.png\" border=0></a>", "PDF" => "<a href='eirPdf3.php?idReg={$idReg}'><img src=\"../images/b_print.png\" border=0></a>"));
$t->parse("lnTupla", "blqTupla", true);
}
$control = $paging->print_link();
$t->set_var("CONTROL", $control);
$t->pparse("out", "page");
}
