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