本文整理汇总了PHP中getValueTable函数的典型用法代码示例。如果您正苦于以下问题：PHP getValueTable函数的具体用法？PHP getValueTable怎么用？PHP getValueTable使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了getValueTable函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的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");
}示例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");
}示例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");
}示例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");
}示例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");
}示例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");
}示例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");
}示例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");
}示例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();
}示例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");
}示例11: existeConte
function existeConte($numero)
{
$row = getValueTable("id_contenedor", "CONTENEDOR", "numero", $numero);
if ($row > 0) {
return true;
} else {
return false;
}
}示例12: existeReg
function existeReg($cliente)
{
$row = getValueTable("id_cliente", "CLIENTE", "cliente", $cliente);
if ($row > 0) {
return true;
} else {
return false;
}
}示例13: existeReg
function existeReg($cliente)
{
$row = getValueTable("id_operador", "OPERADOR", "operador", $operador);
if ($row > 0) {
return true;
} else {
return false;
}
}示例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");
}示例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");
}