当前位置: 首页>>代码示例>>PHP>>正文


PHP banco::PDOSelecionar方法代码示例

本文整理汇总了PHP中banco::PDOSelecionar方法的典型用法代码示例。如果您正苦于以下问题:PHP banco::PDOSelecionar方法的具体用法?PHP banco::PDOSelecionar怎么用?PHP banco::PDOSelecionar使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在banco的用法示例。


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

示例1: ArrayIterator

        <th>Código</th>
        <th>Descrição</th>
        <th>
            <button type="button" class="btn btn-info btn-xs" rel="tooltip" title="Novo Registro" onclick="abrirModalExtra('inserir', 0 , 'view/<?php 
echo $path;
?>
/form.php')">
                <i class="glyphicon glyphicon-plus"></i>
            </button>
        </th>
    </tr>
    </thead>
    <tbody>
    <?php 
$condicao = "A.idconta = B.id AND B.codconta = C.CODCONTA AND A.idgrupo = " . $idgrupo;
$dados = $consulta->PDOSelecionar("A.id, B.codconta, B.codigo, C.descricao", "ZPortareDremontagem A, ZPortarePlanocontas B, CCONTA C", $condicao, 0, 300, "B.codigo");
$d = new ArrayIterator($dados);
while ($d->valid()) {
    $m = $d->current();
    echo '<tr id="' . $path . $m->id . '">
                                <td>' . $m->codconta . '</td>
                                <td>' . $m->codigo . '</td>
                                <td>' . $m->descricao . '</td>
                                <td>
                                    <a href="javascript:void(0)" class="btn btn-primary btn-xs" rel="tooltip" title="Excluir" onclick="modalExcluir(\'view/' . $path . '/actions.php\', ' . $m->id . ')">
                                        <i class="glyphicon glyphicon-trash"></i>
                                    </a>
                                </td>
                              </tr>';
    $d->next();
}
开发者ID:profbaco,项目名称:sistemaportare,代码行数:31,代码来源:list.php

示例2: banco

<?php

if (!isset($_SESSION)) {
    session_start();
}
include_once '../../dados/config.php';
require_once '../../dados/classes.php';
$consulta = new banco();
$linkurl = explode("/", $_SERVER['SCRIPT_NAME']);
$path = $linkurl[count($linkurl) - 2];
$acao = $_REQUEST['acao'];
$id = $_REQUEST['id'];
if ($id > 0) {
    $dados = $consulta->PDOSelecionar("*", "ZPortareDregrupo", "id = " . $id, 0, 1, "id");
    $d = new ArrayIterator($dados);
    $valor = $d->current();
}
?>
<input type="hidden" id="id" value="<?php 
echo $id;
?>
">
<input type="hidden" id="acao" value="<?php 
echo $acao;
?>
">

<div class="col-md-12">
    <div class="row">
        <div class="col-md-3">
            <label for="codigo">Código</label>
开发者ID:profbaco,项目名称:sistemaportare,代码行数:31,代码来源:form.php

示例3: IN

$end = $start + $total_reg;
$condicao = "1=1";
# Aqui virá os filtros
/*foreach ($_POST as $chave => $valor) {
      if(($chave<>'acao') and ($chave<>'tipo')){
          if($valor<>'') {
              if ((str_replace("_", ".", $chave)=='A.id') or (str_replace("_", ".", $chave)=='A.idservico') or (str_replace("_", ".", $chave)=='A.idcliente') or (str_replace("_", ".", $chave)=='A.idseguradora') or (str_replace("_", ".", $chave)=='A.status')) {
                  $condicao .= " and ". str_replace("_", ".", $chave). " = ".$valor;
              } else {
                  $condicao .= " and ". str_replace("_", ".", $chave). " like '%".$valor."%'";
              }
          }
      }
  }
  //echo $condicao;*/
$dados = $consulta->PDOSelecionar("CODCONTA, DESCRICAO", "(\r\n                        SELECT CODCONTA, DESCRICAO FROM CCONTA\r\n                        WHERE CODCONTA NOT IN (SELECT X.codconta FROM ZPortarePlanocontas X)\r\n                        AND ANALITICA = 1\r\n                        AND CODCONTA LIKE '3%'\r\n                        UNION\r\n                        SELECT CODCONTA, DESCRICAO FROM CCONTA\r\n                        WHERE CODCONTA NOT IN (SELECT X.codconta FROM ZPortarePlanocontas X)\r\n                        AND ANALITICA = 1\r\n                        AND CODCONTA LIKE '4%'\r\n                    ) AS TABELA", $condicao, $start + 1, $end, "CODCONTA");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("(\r\n                        SELECT CODCONTA, DESCRICAO FROM CCONTA\r\n                        WHERE CODCONTA NOT IN (SELECT X.codconta FROM ZPortarePlanocontas X)\r\n                        AND ANALITICA = 1\r\n                        AND CODCONTA LIKE '3%'\r\n                        UNION\r\n                        SELECT CODCONTA, DESCRICAO FROM CCONTA\r\n                        WHERE CODCONTA NOT IN (SELECT X.codconta FROM ZPortarePlanocontas X)\r\n                        AND ANALITICA = 1\r\n                        AND CODCONTA LIKE '4%'\r\n                    ) AS TABELA", $condicao);
// Total de registros
$tp = ceil($tr / $total_reg);
// Total de registros na página
while ($d->valid()) {
    $m = $d->current();
    echo '<tr id="' . $path . $m->id . '">
                                <td>' . $m->CODCONTA . '</td>
                                <td>' . $m->DESCRICAO . '</td>
                              </tr>';
    $d->next();
}
?>
            </tbody>
开发者ID:profbaco,项目名称:sistemaportare,代码行数:31,代码来源:contasnaomigradas.php

示例4: elseif

                    $condicao .= " AND A.dtsaidaempresa <= '" . $ano . "-" . $mes . "-" . $dia . "'";
                } elseif (str_replace("_", ".", $chave) == 'A.dtorcamentoInicial') {
                    list($dia, $mes, $ano) = explode("/", $valor);
                    $condicao .= " AND A.dtorcamento >= '" . $ano . "-" . $mes . "-" . $dia . "'";
                } elseif (str_replace("_", ".", $chave) == 'A.dtorcamentoFinal') {
                    list($dia, $mes, $ano) = explode("/", $valor);
                    $condicao .= " AND A.dtorcamento <= '" . $ano . "-" . $mes . "-" . $dia . "'";
                } else {
                    $condicao .= " and " . str_replace("_", ".", $chave) . " like '%" . $valor . "%'";
                }
            }
        }
    }
}
#echo $condicao;
$dados = $consulta->PDOSelecionar("A.id, B.nome, C.NOME motorista, A.idcaminhao, A.idmov, CONVERT(VARCHAR(20), A.dtsaidaempresa, 103) dtsaida,\r\n(CONVERT(VARCHAR(20), A.dtorcamento, 103)+' '+CONVERT(VARCHAR(20), A.dtorcamento, 108)) dataorcamento, A.dtorcamento,\r\ncase status\r\n   WHEN 0 THEN 'Montagem'\r\n   WHEN 1 THEN 'Aguardando Resposta'\r\n   WHEN 2 THEN 'Aprovado'\r\n   WHEN 3 THEN 'Em Viagem'\r\n   WHEN 4 THEN 'Concluído'\r\n   WHEN 5 THEN 'Cancelado'\r\n   WHEN 6 THEN 'Em Carregamento'\r\nEND AS situacao, A.status, A.kmsaida, A.kmchegada, A.kmpercorrido, A.observacao", "ZPortareKm A, ZPortareLogin B, PFUNC C", $condicao, $start + 1, $end, "A.dtorcamento DESC");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortareKm A, ZPortareLogin B, PFUNC C", $condicao);
// Total de registros
$tp = ceil($tr / $total_reg);
// Total de registros na página
while ($d->valid()) {
    include "linha.php";
}
?>
            </tbody>
        </table>

        <?php 
$anterior = $pc - 1;
$proximo = $pc + 1;
开发者ID:profbaco,项目名称:sistemaportare,代码行数:31,代码来源:list.php

示例5: IN

$end = $start + $total_reg;
$condicao = "ATIVO = 1 AND CODCOLIGADA IN (0, " . $coligada . ")";
# Aqui virá os filtros
/*foreach ($_POST as $chave => $valor) {
      if(($chave<>'acao') and ($chave<>'tipo')){
          if($valor<>'') {
              if ((str_replace("_", ".", $chave)=='A.id') or (str_replace("_", ".", $chave)=='A.idservico') or (str_replace("_", ".", $chave)=='A.idcliente') or (str_replace("_", ".", $chave)=='A.idseguradora') or (str_replace("_", ".", $chave)=='A.status')) {
                  $condicao .= " and ". str_replace("_", ".", $chave). " = ".$valor;
              } else {
                  $condicao .= " and ". str_replace("_", ".", $chave). " like '%".$valor."%'";
              }
          }
      }
  }
  //echo $condicao;*/
$dados = $consulta->PDOSelecionar("CODCOLIGADA, CODCFO, NOMEFANTASIA, NOME, CGCCFO, ISNULL(VALOROP1, 0) VALOROP1, ISNULL(VALOROP2, 0) VALOROP2", "FCFO (NOLOCK)", $condicao, $start + 1, $end, "NOME");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("FCFO", $condicao);
// Total de registros
$tp = ceil($tr / $total_reg);
// Total de registros na página
while ($d->valid()) {
    $m = $d->current();
    echo '<tr id="' . $path . $m->CODCFO . '">
                                <td>' . $m->CODCFO . '</td>
                                <td>' . $m->NOMEFANTASIA . '</td>
                                <td>' . $m->NOME . '</td>
                                <td>' . $m->CGCCFO . '</td>
                                <td>' . $m->VALOROP1 . '</td>
                                <td>' . $m->VALOROP2 . '</td>
                                <td>
开发者ID:profbaco,项目名称:sistemaportare,代码行数:31,代码来源:list.php

示例6: banco

<?php

if (!isset($_SESSION)) {
    session_start();
}
include_once 'dados/config.php';
require_once 'dados/classes.php';
$consulta = new banco();
$email = filter_input(INPUT_POST, 'email', FILTER_SANITIZE_EMAIL);
$senha = md5(filter_input(INPUT_POST, 'senha', FILTER_SANITIZE_STRING));
$conta = $consulta->PDOQtderegistro("ZPortareLogin", "email = '" . $email . "'");
if ($conta > 0) {
    $sql = $consulta->PDOSelecionar("*", "ZPortareLogin", "email = '" . $email . "'", 0, 10, "id");
    $d = new ArrayIterator($sql);
    $valor = $d->current();
    if ($valor->senha == $senha) {
        if ($valor->ativo == 0) {
            echo '<div class="alert alert-dismissable alert-danger"><button type="button" class="close" data-dismiss="alert">×</button>' . 'Usuário desativado</div> &nbsp;';
        } else {
            $_SESSION['nomelogin'] = $valor->nome;
            $_SESSION['idlogin'] = $valor->id;
            echo 'Por favor, aguarde enquanto é redirecionado!';
            echo "<script language='javascript'>location.href='logado.php';</script>";
            echo '&nbsp;';
        }
    } else {
        echo '<div class="alert alert-dismissable alert-danger"><button type="button" class="close" data-dismiss="alert">×</button>' . 'A senha digitada é errada</div> &nbsp;';
    }
} else {
    echo '<div class="alert alert-dismissable alert-danger"><button type="button" class="close" data-dismiss="alert">×</button>' . 'E-mail não cadastrado</div> &nbsp;';
}
开发者ID:profbaco,项目名称:sistemaportare,代码行数:31,代码来源:valida.php

示例7: explode

if (!isset($_SESSION)) {
    session_start();
}
$linkurl = explode("/", $_SERVER['SCRIPT_NAME']);
$path = $linkurl[count($linkurl) - 2];
$acao = $_REQUEST['acao'];
$id = $_REQUEST['id'];
$tipo = $_REQUEST['tipo'];
if ($id > 0) {
    if (!isset($_SESSION)) {
        session_start();
    }
    include_once '../../dados/config.php';
    require_once '../../dados/classes.php';
    $consulta = new banco();
    $dados = $consulta->PDOSelecionar("*", "ZPortarePerfil", "id = " . $id, 0, 1, "nome");
    $d = new ArrayIterator($dados);
    $valor = $d->current();
}
?>
<script src="theme/default/js/functions.js"></script>

<input type="hidden" id="id" value="<?php 
echo $id;
?>
">
<input type="hidden" id="acao" value="<?php 
echo $acao;
?>
">
开发者ID:profbaco,项目名称:sistemaportare,代码行数:30,代码来源:form.php

示例8: carregaPagina

    # A parte onde faz a inserção das despesas se encontram na trigger
    echo '<script language="javascript">
                carregaPagina(\'view/' . $path . '/list.php\');
                $("#modalCadastro").modal("hide");
              </script>';
} elseif ($acao == 'editar') {
    $consulta->PDOEditar("ZPortareKm", "idmotorista='" . $idmotorista . "', idcaminhao='" . $idcaminhao . "', observacao='" . $observacao . "', valorcombustivel='" . $valorcombustivel . "', dtretornoempresa='" . $dtretornoempresa . "', dtsaidaempresa = '" . $dtsaidaempresa . "'", "id = " . $id);
    $consulta->PDOEditar("ZPortareCheckList", "idmotorista='" . $idmotorista . "'", "idkm = " . $id);
    echo '<script language="javascript">
                $("#modalCadastro").modal("hide");
                carregaLinha("km/linha.php", ' . $id . ');
              </script>';
} elseif ($acao == 'excluir') {
    $id = $_POST['id'];
    #Checando se ele já tem movimento gerado
    $temmov = $consulta->PDOSelecionar("isnull(idmov, 0) idmov, id", "ZPortareKm", "id=" . $id, 0, 100, "id");
    $d = new ArrayIterator($temmov);
    $valor = $d->current();
    if ($valor->idmov != 0) {
        echo '<div class="alert alert-dismissable alert-danger">
                  <button type="button" class="close" data-dismiss="alert">×</button>' . '
                  Este movimento não pode ser excluído por ter vínculo ao RM Nucleus!
              </div> &nbsp;';
    } else {
        $consulta->PDOExcluir("ZPortareKmClientes", "idkm = " . $id);
        $consulta->PDOExcluir("ZPortareKmDespesas", "idkm = " . $id);
        $consulta->PDOExcluir("ZPortareCheckList", "idkm = " . $id);
        $consulta->PDOExcluir("ZPortareKmAbastecimentos", "idkm = " . $id);
        $consulta->PDOExcluir("ZPortareKm", "id = " . $id);
        echo '<script language="javascript">
            $("#' . $path . $id . '").remove();
开发者ID:profbaco,项目名称:sistemaportare,代码行数:31,代码来源:actions.php

示例9: IN

$end = $start + $total_reg;
$condicao = "A.id NOT IN (SELECT X.id FROM ZPortareDremontagem X WITH (NOLOCK))";
# Aqui virá os filtros
/*foreach ($_POST as $chave => $valor) {
      if(($chave<>'acao') and ($chave<>'tipo')){
          if($valor<>'') {
              if ((str_replace("_", ".", $chave)=='A.id') or (str_replace("_", ".", $chave)=='A.idservico') or (str_replace("_", ".", $chave)=='A.idcliente') or (str_replace("_", ".", $chave)=='A.idseguradora') or (str_replace("_", ".", $chave)=='A.status')) {
                  $condicao .= " and ". str_replace("_", ".", $chave). " = ".$valor;
              } else {
                  $condicao .= " and ". str_replace("_", ".", $chave). " like '%".$valor."%'";
              }
          }
      }
  }
  //echo $condicao;*/
$dados = $consulta->PDOSelecionar("A.codconta, A.codigo, B.DESCRICAO", "ZPortarePlanocontas A WITH (NOLOCK) JOIN CCONTA B ON A.codconta = B.CODCONTA", $condicao, $start + 1, $end, "codigo");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortarePlanocontas A WITH (NOLOCK) JOIN CCONTA B ON A.codconta = B.CODCONTA", $condicao);
// Total de registros
$tp = ceil($tr / $total_reg);
// Total de registros na página
while ($d->valid()) {
    $m = $d->current();
    echo '<tr id="' . $path . $m->id . '">
                                <td>' . $m->codconta . '</td>
                                <td>' . $m->codigo . '</td>
                                <td>' . $m->DESCRICAO . '</td>
                              </tr>';
    $d->next();
}
?>
开发者ID:profbaco,项目名称:sistemaportare,代码行数:31,代码来源:contasnaoagrupadasdre.php

示例10: IN

        <th>Combustível</th>
        <th>Volume</th>-->
        <th>
            <button type="button" class="btn btn-info btn-xs" rel="tooltip" title="Novo Registro" onclick="abrirModalExtra('inserir', 0 , 'view/<?php 
echo $path;
?>
/formclientes.php')">
                <i class="glyphicon glyphicon-plus"></i>
            </button>
        </th>
    </tr>
    </thead>
    <tbody>
    <?php 
$condicao = "A.idcliente = B.CODCFO AND A.idcombustivel = C.id AND B.CODCOLIGADA IN (0,5) AND A.idkm = " . $idkm;
$dados = $consulta->PDOSelecionar("A.id, A.idcliente, B.CODCFO, B.nome, (A.kmasfalto+A.kmchao) totalkm, CONVERT(VARCHAR(15), A.datasaida, 103) datasaida, C.descricao combustivel, A.volume", "ZPortareKmClientes A, FCFO B, ZPortareCombustivel C", $condicao, 0, 100, "B.nome");
$d = new ArrayIterator($dados);
while ($d->valid()) {
    $m = $d->current();
    echo '<tr id="' . $path . $m->id . '">
                                <td>' . $m->CODCFO . ' - ' . $m->nome . '</td>
                                <!--<td>' . number_format($m->totalkm, 0, ',', '.') . '</td>
                                <td>' . $m->datasaida . '</td>
                                <td>' . $m->combustivel . '</td>
                                <td>' . number_format($m->volume, 2, ',', '.') . '</td>-->
                                <td>
                                    <a href="javascript:void(0)" class="btn btn-success btn-xs" rel="tooltip" title="Editar" onclick="abrirModalExtra(\'editar\', ' . $m->id . ' , \'view/' . $path . '/formclientes.php\')">
                                        <i class="glyphicon glyphicon-edit"></i>
                                    </a>
                                    <a href="javascript:void(0)" class="btn btn-warning btn-xs" rel="tooltip" title="Despesas" onclick="CarregarDespesasCliente(' . $idkm . ' , \'' . $m->idcliente . '\')">
                                        <i class="glyphicon glyphicon-usd"></i>
开发者ID:profbaco,项目名称:sistemaportare,代码行数:31,代码来源:verclientes.php

示例11: in

<table class="table table-hover table-condensed">
    <thead>
    <tr>
        <th colspan="5"><h3>Caminhões e Agregados</h3></th>
    </tr>
    <tr>
        <th>Caminhão</th>
        <th>Despesa</th>
        <th>Período</th>
        <th>Valor</th>
        <th>Calculado</th>
    </tr>
    </thead>
    <tbody>
    <?php 
$dados = $consulta->PDOSelecionar("A.id,\r\n                                        CASE WHEN A.agregado = 0 THEN A.idcaminhao ELSE '**'+A.idcaminhao END idcaminhao,\r\n                                        B.descricao, CASE A.periododiario\r\n                                         when 365 then 'Anual'\r\n                                         when 180 then 'Semestral'\r\n                                         when 90 then 'Trimestral'\r\n                                         when 60 then 'Bimestral'\r\n                                         when 30 then 'Mensal'\r\n                                         when 1 then 'Diário'\r\n                                         end periodo, A.valor, A.calculado", "ZPortareKmDespesas A, ZPortareDespesas B", "A.iddespesa = B.id AND A.idkm = " . $idkm . " AND A.agregado in (0,1)", 0, 600, "idcaminhao DESC");
$d = new ArrayIterator($dados);
$totalagregado = 0;
while ($d->valid()) {
    $m = $d->current();
    echo '<tr>
                                <td>' . $m->idcaminhao . '</td>
                                <td>' . $m->descricao . '</td>
                                <td>' . $m->periodo . '</td>
                                <td>' . number_format($m->valor, 2, ',', '.') . '</td>
                                <td>' . number_format($m->calculado, 2, ',', '.') . '</td>
                              </tr>';
    $totalagregado = $totalagregado + $m->calculado;
    $d->next();
}
?>
开发者ID:profbaco,项目名称:sistemaportare,代码行数:31,代码来源:calculokmgeral.php

示例12: banco

if (!isset($_SESSION)) {
    session_start();
}
include_once '../../dados/config.php';
require_once '../../dados/classes.php';
$consulta = new banco();
$query = strtolower($_REQUEST["term"]);
$quem = $_REQUEST['quem'];
$codfilial = $_REQUEST['codfilial'];
/*if ($quem=="idmotorista"){
    $sql = $consulta->PDOSelecionar("chapa id, nome, (chapa+' - '+nome) text", "pfunc", "codcoligada = 5 and (nome LIKE '".$query."%' or chapa like '".$query."%')", 0, 100,"nome"); 

} else*/
if ($quem == "codconta") {
    $sql = $consulta->PDOSelecionar("CODCONTA id, CODCONTA+' - '+DESCRICAO text, CODCONTA, DESCRICAO", "CCONTA", "CODCOLIGADA IN (0, 5) AND INATIVA = 0 AND (DESCRICAO like '" . $query . "%' OR CODCONTA like '" . $query . "%')", 0, 100, "CODCONTA");
} elseif ($quem == "iddespesa") {
    $sql = $consulta->PDOSelecionar("id, descricao text, descricao", "ZPortareDespesas", "tipo = 'v' and descricao like '" . $query . "%'", 0, 100, "descricao");
} elseif ($quem == "idcaminhao") {
    $sql = $consulta->PDOSelecionar("PLACA id, PLACA text, PLACA", "ZPortalCAMINHOES", "PLACA like '" . $query . "%'", 0, 100, "PLACA");
} elseif ($quem == "idmotorista") {
    $sql = $consulta->PDOSelecionar("CHAPA id, (CHAPA+' - '+NOME) text, NOME", "PFUNC", "CODFUNCAO IN ('003', '018', '019', '099') AND CODSITUACAO <> 'D' AND CODCOLIGADA = 5 AND\r\n         (CHAPA like '" . $query . "%' OR NOME LIKE '" . $query . "%')", 0, 100, "NOME");
} elseif ($quem == "idcliente") {
    $sql = $consulta->PDOSelecionar("CODCFO id, (NOME+' - '+CGCCFO) text, ISNULL(VALOROP1, 0) ASFALTO, ISNULL(VALOROP2, 0) CHAO, NOME", "FCFO", "CODCOLIGADA in (0,5) AND ATIVO=1 AND (CGCCFO like '" . $query . "%' OR NOME LIKE '" . $query . "%')", 0, 100, "NOME");
} elseif ($quem == "idcombustivel") {
    $sql = $consulta->PDOSelecionar("id, descricao text, descricao", "ZPortareCombustivel", "descricao like '" . $query . "%'", 0, 100, "descricao");
} elseif ($quem == "idconta") {
    $sql = $consulta->PDOSelecionar("A.id, (A.codigo+' - '+B.descricao) text, A.codigo", "ZPortarePlanocontas A, CCONTA B", "A.codconta = B.codconta and (B.descricao like '" . $query . "%' or A.codigo like '" . $query . "%')", 0, 100, "A.codigo");
} elseif ($quem == "codccusto") {
    $sql = $consulta->PDOSelecionarPadrao("CODCCUSTO id, (CODCCUSTO+' - '+NOME) text", "GCCUSTO", "CODCOLIGADA=5 AND ATIVO='T' AND (CODCCUSTO LIKE '" . $query . "%' OR NOME LIKE '" . $query . "%')");
} elseif ($quem == "codtmv") {
开发者ID:profbaco,项目名称:sistemaportare,代码行数:30,代码来源:busca.php

示例13: banco

<?php

if (!isset($_SESSION)) {
    session_start();
}
include_once '../../dados/config.php';
require_once '../../dados/classes.php';
$consulta = new banco();
$tipo = $_REQUEST['tipo'];
$placa = $_REQUEST['placa'];
$sql = $consulta->PDOSelecionar("IDOBJOFPAI,\r\n\t\t\tCONVERT(VARCHAR(30), DATAENTRADA, 103) + ' - ' +CONVERT(VARCHAR(30), DATAENTRADA, 108) DTHRENTRADA,\r\n\t\t\tCONVERT(VARCHAR(30), DATASAIDA, 103) + ' - ' +CONVERT(VARCHAR(30), DATASAIDA, 108) DTHRSAIDA,\r\n\t\t\tRECMODIFIEDBY, DATASAIDA", "OFHISTOBJFILHO (NOLOCK)", "IDOBJOF = '" . $placa . "'", 0, 500, "DATASAIDA ASC");
$d = new ArrayIterator($sql);
echo '<table class="table table-hover table-condensed">
				<thead>
				<tr>
					<th>Placa</th>
					<th>Dt/Hr Entrada</th>
					<th>Dt/Hr Saída</th>
					<th>Usuário RM</th>
				</tr>
				</thead>';
while ($d->valid()) {
    $valor = $d->current();
    echo '<tr>
				<td>' . $valor->IDOBJOFPAI . '</td>
				<td>' . $valor->DTHRENTRADA . '</td>
				<td>' . $valor->DTHRSAIDA . '</td>
				<td>' . $valor->RECMODIFIEDBY . '</td>
			  </tr>';
    $d->next();
}
开发者ID:profbaco,项目名称:sistemaportare,代码行数:31,代码来源:agregados.php

示例14: in

        ?>
/form.php?agregado=<?php 
        echo $agregado;
        ?>
')">
                <i class="glyphicon glyphicon-plus"></i>
            </button>
            <?php 
    }
    ?>
        </th>
    </tr>
    </thead>
    <tbody>
    <?php 
    $dados = $consulta->PDOSelecionar("A.id,\r\n                                        CASE WHEN A.agregado = 0 THEN A.idcaminhao ELSE '**'+A.idcaminhao END idcaminhao,\r\n                                        B.descricao, A.calculado", "ZPortareKmDespesas A, ZPortareDespesas B", "A.iddespesa = B.id AND A.idkm = " . $idkm . " AND A.agregado in (" . $agregado . ")", 0, 600, "idcaminhao DESC");
    $d = new ArrayIterator($dados);
    while ($d->valid()) {
        $m = $d->current();
        echo '<tr id="' . $path . $m->id . '">
                                <td>' . $m->descricao . '</td>
                                <td>' . number_format($m->calculado, 2, ',', '.') . '</td>
                                <td>
                                    <a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Editar" onclick="abrirModalExtra(\'editar\', ' . $m->id . ' , \'view/' . $path . '/form.php\')">
                                        <i class="glyphicon glyphicon-edit"></i>
                                    </a>
                                    <a href="javascript:void(0)" class="btn btn-primary btn-xs" rel="tooltip" title="Excluir" onclick="modalExcluir(\'view/' . $path . '/actions.php\', ' . $m->id . ')">
                                        <i class="glyphicon glyphicon-trash"></i>
                                    </a>
                                </td>
                              </tr>';
开发者ID:profbaco,项目名称:sistemaportare,代码行数:31,代码来源:conteudo.php


注:本文中的banco::PDOSelecionar方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。