• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    公众号

PHP getValueTable函数代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了PHP中getValueTable函数的典型用法代码示例。如果您正苦于以下问题:PHP getValueTable函数的具体用法?PHP getValueTable怎么用?PHP getValueTable使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。



在下文中一共展示了getValueTable函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: showForm

 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");
 }
开发者ID:nesmaster,项目名称:anakosta,代码行数:33,代码来源:catNavieraCaptura.php


示例2: showForm

 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");
 }
开发者ID:nesmaster,项目名称:anakosta,代码行数:25,代码来源:invModSendE.php


示例3: showForm

 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");
 }
开发者ID:nesmaster,项目名称:anakosta,代码行数:26,代码来源:facCap1.php


示例4: showForm

 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");
 }
开发者ID:nesmaster,项目名称:anakosta,代码行数:34,代码来源:liqBaja.php


示例5: showForm

 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");
 }
开发者ID:nesmaster,项目名称:anakosta,代码行数:32,代码来源:invAltaPlus.php


示例6: showForm

 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");
 }
开发者ID:nesmaster,项目名称:anakosta,代码行数:35,代码来源:catUsuarioChgPas.php


示例7: showForm

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");
}
开发者ID:nesmaster,项目名称:mopsapro,代码行数:25,代码来源:intro.php


示例8: showForm

 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");
 }
开发者ID:nesmaster,项目名称:anakosta,代码行数:26,代码来源:invModFecS.php


示例9: reporte

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();
}
开发者ID:nesmaster,项目名称:anakosta,代码行数:58,代码来源:plantillaExcelPerres.php


示例10: showForm

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");
}
开发者ID:nesmaster,项目名称:mopsapro,代码行数:58,代码来源:catConte.php


示例11: existeConte

 function existeConte($numero)
 {
     $row = getValueTable("id_contenedor", "CONTENEDOR", "numero", $numero);
     if ($row > 0) {
         return true;
     } else {
         return false;
     }
 }
开发者ID:nesmaster,项目名称:mopsapro,代码行数:9,代码来源:piInvInCaptura.php


示例12: existeReg

 function existeReg($cliente)
 {
     $row = getValueTable("id_cliente", "CLIENTE", "cliente", $cliente);
     if ($row > 0) {
         return true;
     } else {
         return false;
     }
 }
开发者ID:nesmaster,项目名称:anakosta,代码行数:9,代码来源:catClienteCaptura.php


示例13: existeReg

 function existeReg($cliente)
 {
     $row = getValueTable("id_operador", "OPERADOR", "operador", $operador);
     if ($row > 0) {
         return true;
     } else {
         return false;
     }
 }
开发者ID:nesmaster,项目名称:anakosta,代码行数:9,代码来源:catOperadorCaptura.php


示例14: showForm

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");
}
开发者ID:nesmaster,项目名称:trane,代码行数:55,代码来源:invConSalSePi.php


示例15: showForm

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");
}
开发者ID:nesmaster,项目名称:mopsapro,代码行数:55,代码来源:penConsultaG.php


示例16: showForm

 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");
 }
开发者ID:nesmaster,项目名称:anakosta,代码行数:54,代码来源:logAereoCancel.php


示例17: showForm

 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");
 }
开发者ID:nesmaster,项目名称:anakosta,代码行数:53,代码来源:opPedidoConsPDF.php


示例18: showForm

 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");
 }
开发者ID:nesmaster,项目名称:anakosta,代码行数:51,代码来源:invConSalCapAr.php


示例19: showForm

 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");
 }
开发者ID:nesmaster,项目名称:lition,代码行数:50,

鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
PHP getValues函数代码示例发布时间:2022-05-15
下一篇:
PHP getValueFromArray函数代码示例发布时间:2022-05-15
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap