function showForm($data = "", $msg = "") { global $t, $paging; $PHP_SELF = $_SERVER['PHP_SELF']; $t->set_file("page", "plantillaSearch.inc.html"); $t->set_var(array("lnTupla" => "", "ACTION" => $PHP_SELF, "MENSAJE" => "")); $qw1 = explode_keyword1($_GET[keyword1]); $qw2 = explode_keyword2($_GET[keyword2]); $sql = "select * from DEMO_FORM where {$qw1} {$qw2} order by id_demo 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_demo]; $campo1 = $result[campo1]; $campo2 = $result[campo2]; $t->set_var(array("ID_REG" => $idReg, "CAMPO1" => $campo1, "CAMPO2" => $campo2, "EDITAR" => "<a href='plantillaFormulario.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>", "DEL" => "<a href=\"javascript:submitD(document.frm1,'{$PHP_SELF}','{$idReg}','del')\"><img src=\"../images/b_del.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, $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, $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, $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, $db; $t->set_file("page", "navInvGen13.inc.html"); $t->set_var(array("lnTupla" => "", "ACTION" => $PHP_SELF, "MENSAJE" => "", "BAJA" => "", "OFICINA" => "El Trébol")); // ---------------------------------------------------------------- // Pagin // Importante. Si realiza 2 busquedas sobre campos bastante grandes, // alenta la consulta. De preferencia utilice una consulta. // ----------------------------------------------------------------- // Busqueda por contenedor $qw1 = explode_keyword1($_GET[keyword1]); $qw2 = explode_keyword2($_GET[keyword2]); $sesIdOficina = $_SESSION[sesIdOficina]; $sql = "select *,c.clase as CLASE from INVENTARIO_PLUS i, CONTENEDOR c where "; $sql .= "i.id_contenedor=c.id_contenedor and i.id_naviera='{$idNaviera}' and "; $sql .= "c.ent_sal<>'S' and "; $sql .= " {$qw1} {$qw2} and i.id_oficina='6' order by i.id_inventario 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_inventario]; $eir = $result[eir]; $eir = "{$entSal} {$eir}"; //$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>"; } $numLin++; $t->set_var(array("EIR" => $eir, "BAJA" => "<a href=\"javascript:ventanaNueva('invBajaPlus.php?idReg={$idReg}',270,300)\"><img src=\"../images/b_del.png\" border=0></a>", "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, "EDITAR" => "<a href='invInPlus.php?idReg={$idReg}'><img src=\"../images/b_edit.png\" border=0></a>", "PDF" => "<a href='eirPdf3Plus.php?idReg={$idReg}'><img src=\"../images/b_print.png\" border=0></a>", "NUM_LIN" => $numLin)); $stReg = $result[st_reg]; if ($stReg == "B") { $t->set_var("COLOR_ROW", "#FF8080"); $t->set_var("EDITAR", "-Baja-"); $t->set_var("BAJA", "<a href=\"javascript:ventanaNueva('invAltaPlus.php?idReg={$idReg}',270,300)\">Activar</a>"); } $t->parse("lnTupla", "blqTupla", true); } $control = $paging->print_link(); $t->set_var("CONTROL", $control); $t->pparse("out", "page"); }
function showForm($data = "", $msg = "") { global $db, $t, $PHP_SELF, $paging, $usuario, $arrPerms; $t->set_file("page", "facCatCli.inc.html"); $t->set_var(array("ACTION" => $PHP_SELF, "MENSAJE" => "")); //menuFacturacion("Nueva Factura :: Catálogo de clientes"); if ($_GET[keyword1]) { $qw1 = explode_keyword1($_GET[keyword1]); } if ($_GET[keyword2]) { $qw2 = explode_keyword2($_GET[keyword2]); } if ($_GET[keyword3]) { $qw3 = explode_keyword3($_GET[keyword3]); } //if( $usuario->havePerm("1",$_SESSION['sesArrPerms']) ){ if ($usuario->havePerm("1,166", $arrPerms)) { $t->set_var("NUEVOCLI", "<a href=\"facCatCliCap.php\">NUEVO CLIENTE</a>"); $t->set_var("NUEVOCLIMAS", "<a href=\"facCatCliMas.php\">CLIENTES MASIVO</a>"); } else { $t->set_var("NUEVOCLI", "NUEVO CLIENTE"); } $sql = "select * from FT_CLIENTE where {$qw1} {$qw2} {$qw3} "; $sql .= "id_cliente>0 and flg_bloqueo=0 order by cliente "; $paging->query($sql); $page = $paging->print_info(); // --------------------- // Control de paginación. // --------------------- if (!empty($page["keyword1"])) { $t->set_var("INFODATA", "Keyword : <b>{$page['keyword1']}</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"); $t->set_var("lnTupla", ""); while ($result = $paging->result_assoc()) { $color = $paging->print_color("#dadada", "#ffffff"); $t->set_var("COLOR_ROW", $color); // Campos $idCliente = $result[id_cliente]; $codigo = $result[codigo]; $cliente = $result[cliente]; $calle = $result[calle]; $noInt = $result[no_int]; $noExt = $result[no_ext]; $colonia = $result[colonia]; $ciudad = $result[ciudad]; $estado = $result[estado]; $pais = $result[pais]; $rfc = $result[rfc]; $cp = $result[cp]; // Etiquetas $t->set_var(array("SELECT" => "<a href=\"facCap1.php?idCliente={$idCliente}\" title=\"FACTURAR\"><img src=\"../iconos/orange/plus.gif\" border=\"0\"></a>", "CODIGO" => $codigo, "CALLE" => $calle, "NO_INT" => $noInt, "NO_EXT" => $noExt, "ESTADO" => $estado, "PAIS" => $pais, "COLONIA" => $colonia, "CIUDAD" => $ciudad, "RFC" => $rfc, "CP" => $cp)); //if( $usuario->havePerm("1",$_SESSION['sesArrPerms']) ){ if ($usuario->havePerm("1,165,160", $arrPerms)) { $t->set_var("CLIENTE", "<a href=\"facCatCliCap.php?idCliente={$idCliente}\">{$cliente}</a>"); } else { $t->set_var("CLIENTE", "{$cliente}"); $t->set_var("NUEVOCLI", "NUEVO CLIENTE"); $t->set_var("NUEVOCLIMAS", "CLIENTES MASIVO"); } //if( $usuario->havePerm("1",$_SESSION['sesArrPerms']) ){ /* if ( ($usuario->havePerm("1,166",$arrPerms)) ){ $t->set_var("NUEVOCLI","<a href=\"facCatCliCap.php\">NUEVO CLIENTE</a>"); $t->set_var("NUEVOCLIMAS","<a href=\"facCatCliMas.php\">CLIENTES MASIVO</a>"); } else { $t->set_var("NUEVOCLI","NUEVO CLIENTE"); }*/ $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, $usuario; $PHP_SELF = $_SERVER['PHP_SELF']; $t->set_file("page", "opGuiaSearch.inc.html"); $sesIdOficina = $_SESSION['sesIdOficina']; $t->set_var(array("lnTupla" => "", "ACTION" => $PHP_SELF, "MENSAJE" => "")); $qw1 = explode_keyword1($_GET[keyword1]); $qw2 = explode_keyword2($_GET[keyword2]); $qw3 = explode_keyword3($_GET[keyword3]); $qw4 = explode_keyword4($_GET[keyword4]); $qw5 = explode_keyword5($_GET[keyword5]); $sql = "select * from GUIA g, PEDIDO p where "; $sql .= "g.id_pedido=p.id_pedido and "; $sql .= "{$qw1} {$qw2} {$qw3} {$qw4} {$qw5} order by g.id_guia 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_guia]; $capIdUsr = $result[cap_id_usr]; $capUsr = getValueTable("usuario", "USUARIO", "id_usuario", $capIdUsr); $capFec = $result[cap_fec]; $idOfi = getValueTable("id_oficina", "USUARIO", "id_usuario", $capIdUsr); $capOfi = getValueTable("oficina", "OFICINA", "id_oficina", $idOfi); $idGuia = $result[id_guia]; $idPedido = $result[id_pedido]; $idConte = $result[id_contenedor]; $conte = getValueTable("numero", "CONTENEDOR", "id_contenedor", $idConte); $folio = $result[folio]; //$facturaS = $result[factura_s]; //$facturaN = $result[factura]; //$factura = "$facturaS-$facturaN"; $factura = $result[factura]; $stReg = $result[st_reg]; $modIdUsr = $result[mod_id_usr]; $modUsr = getValueTable("usuario", "USUARIO", "id_usuario", $modIdUsr); $modFec = $result[mod_fec]; if ($stReg == "B") { $stReg = "<font color=white><b>BAJA</b></font>"; $stRegColor = "bgcolor=\"#FF8080\""; $bajaIdUsr = $result[baja_id_usr]; $bajaUsr = getValueTable("usuario", "USUARIO", "id_usuario", $bajaIdUsr); $bajaFec = $result[baja_fec]; $bajaDetalle = "<font color=white>{$bajaUsr} / {$bajaFec}</font>"; } else { $stRegColor = "class=\"color2\""; $bajaDetalle = ""; } $bkg = getValueTable("bkg", "PEDIDO", "id_pedido", $idPedido); $buque = getValueTable("buque", "PEDIDO", "id_pedido", $idPedido); $ori = getValueTable("ori", "PEDIDO", "id_pedido", $idPedido); $des = getValueTable("des", "PEDIDO", "id_pedido", $idPedido); $idCliente = getValueTable("id_cliente", "PEDIDO", "id_pedido", $idPedido); $idNaviera = getValueTable("id_naviera", "PEDIDO", "id_pedido", $idPedido); $cliente = getValueTable("cliente", "CLIENTE", "id_cliente", $idCliente); $naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNaviera); $folioS = substr($folio, 0, 2); $folioN = substr($folio, 2, 10); $folio = "{$folioS} {$folioN}"; /* if(empty($folio)){ $folioSer = $result[folio_ser]; $folioNum = $result[folio_num]; $folio= $folioSer.$folioNum; } */ $serie = $result[serie]; $folio = $result[folio]; $t->set_var(array("SERIE" => $serie, "FOLIO" => $folio, "CON_SER" => $cliente, "ORI" => $ori, "DES" => $des, "NAVIERA" => $naviera, "BUQUE" => $buque, "BKG" => $bkg, "N_PEDIDO" => $idPedido, "CONTE" => $conte, "FACTURA" => $factura, "PE_ST_REG" => $stReg, "PE_ST_REG_COLOR" => $stRegColor, "BAJA_DETALLE" => $bajaDetalle, "CAP_USR" => $capUsr, "CAP_FEC" => $capFec, "CAP_OFI" => $capOfi, "MOD_USR" => $modUsr, "MOD_FEC" => $modFec, "DEL" => "<a href=\"javascript:submitD(document.frm1,'{$PHP_SELF}','{$idReg}','del')\"><img src=\"../images/b_del.png\" border=\"0\"></a>", "EDITAR" => "<a href='opGuia.php?idReg={$idReg}&idPedido={$idPedido}'>Detalle</a>", "FILE_UPLOAD" => "CargarArchivos")); // ------------------------------------------------- // Adjuntos 1 y 2 // ------------------------------------------------- if (file_exists("../filesUp1/{$idGuia}.zip")) { $t->set_var("ADJ1", "<a href=\"../filesUp1/{$idGuia}.zip\"><img border=0 width=\"30\" src=\"../images/zip.gif\"></a>"); } else { $t->set_var("ADJ1", ""); } if (file_exists("../filesUp2/{$idGuia}.zip")) { $t->set_var("ADJ2", "<a href=\"../filesUp2/{$idGuia}.zip\"><img border=0 width=\"30\" src=\"../images/zip.gif\"></a>"); } else { $t->set_var("ADJ2", ""); } if ($sesIdOficina == $idOfi) { $t->set_var("FILE_UPLOAD", "<a href=\"javascript:newWindow('opUploadGuia.php?idGuia={$idReg}',400,400)\">Archivos</a>"); } // -------------------------------------------- // FACTURAS // -------------------------------------------- //$facS = getValueTable("factura_s","GUIA","id_guia",$idGuia); $facX = getValueTable("factura", "GUIA", "id_guia", $idGuia); if (preg_match("/(.{0,2})(.*)/", $facX, $parts)) { $facS = $parts[1]; $facN = $parts[2]; } $facN2 = str_pad($facN, 7, 0, STR_PAD_LEFT); $filePdfEdi = "OPE0606129RAF" . $facS . $facN2 . "_.pdf"; if (file_exists("../facturas/{$filePdfEdi}")) { $t->set_var("FACTU", "<a href=\"javascript:ventanaNueva('../facturas/{$filePdfEdi}',800,600)\"><img border=0 width=\"30\" src=\"../images/pdf.gif\"></a>"); } else { $t->set_var("FACTU", ""); } $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, $sesIdOficina, $usuario; $PHP_SELF = $_SERVER['PHP_SELF']; $t->set_file("page", "opPedidoSearch.inc.html"); $t->set_var(array("lnTupla" => "", "ACTION" => $PHP_SELF, "MENSAJE" => "")); $qw1 = explode_keyword1($_GET[keyword1]); $qw2 = explode_keyword2($_GET[keyword2]); /* // Este query es para mostrar solo lo de la oficina correspondiente. $sql= "select * from PEDIDO p,USUARIO u, OFICINA o where "; $sql.="p.cap_id_usr=u.id_usuario and u.id_oficina=o.id_oficina and "; if( !$usuario->havePerm("1",$_SESSION['sesArrPerms']) ){ $sql.="o.id_oficina='$sesIdOficina' and "; } $sql.=" $qw1 $qw2 "; $sql.="order by p.id_pedido desc"; */ $sql = "select * from PEDIDO p,USUARIO u where "; $sql .= "p.cap_id_usr=u.id_usuario and "; $sql .= " {$qw1} {$qw2} "; $sql .= "order by p.id_pedido 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_pedido]; $capIdUsr = $result[cap_id_usr]; $capUsr = getValueTable("usuario", "USUARIO", "id_usuario", $capIdUsr); $capFec = $result[cap_fec]; $idOfi = getValueTable("id_oficina", "USUARIO", "id_usuario", $capIdUsr); $capOfi = getValueTable("oficina", "OFICINA", "id_oficina", $idOfi); $bkg = $result[bkg]; $posFec = $result[pos_fec]; $posHor = $result[pos_hor]; $posMin = $result[pos_min]; $posFec = "{$posFec} {$posHor} : {$posMin} "; $idCliente = $result[id_cliente]; $cliente = getValueTable("cliente", "CLIENTE", "id_cliente", $idCliente); $idNav = $result[id_naviera]; $naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNav); $buque = $result[buque]; $ori = $result[ori]; $des = $result[des]; $stReg = $result[st_reg]; $modIdUsr = $result[mod_id_usr]; $modUsr = getValueTable("usuario", "USUARIO", "id_usuario", $modIdUsr); $modFec = $result[mod_fec]; if ($stReg == "B") { $stReg = "<font color=white><b>Cancelado</b></font>"; $stRegColor = "bgcolor=\"#FF8080\""; $bajaIdUsr = $result[baja_id_usr]; $bajaUsr = getValueTable("usuario", "USUARIO", "id_usuario", $bajaIdUsr); $bajaFec = $result[baja_fec]; $bajaDetalle = "<font color=white>{$bajaUsr} / {$bajaFec}</font>"; } else { $stRegColor = "class=\"color2\""; $bajaDetalle = ""; } $t->set_var(array("ID_REG" => $idReg, "BKG" => $bkg, "POS_FEC" => $posFec, "CON_SER" => $cliente, "BUQUE" => $buque, "ORI" => $ori, "DES" => $des, "NAVIERA" => $naviera, "EDITAR" => "<a href='opPedidoNuevo.php?idReg={$idReg}'>Detalle</a>", "PDF" => "<a href='x.php?idReg={$idReg}'><img src=\"../images/b_print.png\" border=0></a>", "DEL" => "<a href=\"javascript:submitD(document.frm1,'{$PHP_SELF}','{$idReg}','del')\"><img src=\"../images/b_del.png\" border=\"0\"></a>", "PE_ST_REG" => $stReg, "PE_ST_REG_COLOR" => $stRegColor, "BAJA_DETALLE" => $bajaDetalle, "CAP_USR" => $capUsr, "CAP_FEC" => $capFec, "CAP_OFI" => $capOfi, "MOD_USR" => $modUsr, "MOD_FEC" => $modFec)); $t->parse("lnTupla", "blqTupla", true); } $control = $paging->print_link(); $t->set_var("CONTROL", $control); $t->pparse("out", "page"); }