banco::PDOQtderegistro PHPのコード例

コード例 #1

0

ファイルを表示

ファイル: valida.php プロジェクト: profbaco/sistemaportare

<?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;';
}

コード例 #2

0

ファイルを表示

ファイル: list.php プロジェクト: profbaco/sistemaportare

                    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;
echo '<ul class="pagination pagination-sm pull-right">';
if ($pc == 0 or $pc == 1) {

コード例 #3

0

ファイルを表示

ファイル: actions.php プロジェクト: profbaco/sistemaportare

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'];
$pagina = $_REQUEST['pagina'];
$id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT);
$codigo = filter_input(INPUT_POST, 'codigo', FILTER_SANITIZE_STRING);
$codconta = filter_input(INPUT_POST, 'codconta', FILTER_SANITIZE_STRING);
$considerar = filter_input(INPUT_POST, 'considerar', FILTER_SANITIZE_STRING);
$tipodespesa = filter_input(INPUT_POST, 'tipodespesa', FILTER_SANITIZE_STRING);
$valorconta = str_replace(",", ".", str_replace(".", "", $_REQUEST['valorconta']));
if ($acao == 'inserir') {
    #Checando se o código já existe
    $qtde = $consulta->PDOQtderegistro("ZPortarePlanocontas", "codigo = '" . $codigo . "'");
    if ($qtde > 0) {
        echo '<script>
                jQuery("#alerta").show();
              </script>';
    } else {
        $consulta->PDOInserir("ZPortarePlanocontas", "(codconta, codigo, considerar, tipodespesa, valorconta)", "('" . $codconta . "', '" . $codigo . "', '" . $considerar . "', '" . $tipodespesa . "', " . $valorconta . ")");
        echo '<script language="javascript">
                carregaPagina(\'view/' . $path . '/list.php\');
                jQuery("#alerta").hide();
                $("#modalCadastro").modal("hide");
              </script>';
    }
} elseif ($acao == 'editar') {
    $consulta->PDOEditar("ZPortarePlanocontas", "codconta='" . $codconta . "', codigo='" . $codigo . "', considerar='" . $considerar . "', tipodespesa='" . $tipodespesa . "', valorconta=" . $valorconta, "id = " . $id);
    echo '<script language="javascript">

コード例 #4

0

ファイルを表示

ファイル: list.php プロジェクト: profbaco/sistemaportare

# 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("*", "ZPortareDregrupo", $condicao, $start + 1, $end, "id");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortareDregrupo", $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->codigo . '</td>
                                <td>' . $m->descricao . '</td>
                                <td>
                                    <a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Editar" onclick="abrirModal(\'editar\', ' . $m->id . ' , \'view/' . $path . '/form.php\')">
                                        <i class="glyphicon glyphicon-edit"></i>
                                    </a>
                                    <a href="javascript:void(0)" class="btn btn-default btn-xs" rel="tooltip" title="Contas" onclick="abrirModal(\'montagem\', ' . $m->id . ' , \'view/dremontagem/list.php\')">
                                        <i class="glyphicon glyphicon-saved"></i>
                                    </a>

コード例 #5

0

ファイルを表示

ファイル: list.php プロジェクト: profbaco/sistemaportare

# 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.id, (A.idmotorista+' - '+B.NOME) NOME, A.operadora, A.numero", "ZPortareTelefones A, PFUNC B", $condicao, $start + 1, $end, "B.NOME");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortareTelefones A, PFUNC B", $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->id . '</td>
                                <td>' . $m->NOME . '</td>
                                <td>' . $m->operadora . '</td>
                                <td>' . $m->numero . '</td>
                                <td>
                                    <a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Editar" onclick="abrirModal(\'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 . ')">

コード例 #6

0

ファイルを表示

ファイル: actions.php プロジェクト: profbaco/sistemaportare

$codigo = filter_input(INPUT_POST, 'codigo', FILTER_SANITIZE_STRING);
$descricao = filter_input(INPUT_POST, 'descricao', FILTER_SANITIZE_STRING);
if ($acao == 'inserir') {
    $consulta->PDOInserir("ZPortareDregrupo", "(codigo, descricao, valor)", "('" . $codigo . "', '" . $descricao . "', 0)");
    echo '<script language="javascript">
                carregaPagina(\'view/' . $path . '/list.php\')
                $("#modalCadastro").modal("hide");
              </script>';
} elseif ($acao == 'editar') {
    $consulta->PDOEditar("ZPortareDregrupo", "codigo='" . $codigo . "', descricao='" . $descricao . "'", "id = " . $id);
    echo '<script language="javascript">
                carregaPagina(\'view/' . $path . '/list.php\')
                $("#modalCadastro").modal("hide");
              </script>';
} elseif ($acao == 'excluir') {
    $id = $_POST['id'];
    # Tem que checar se esta seguradora não faz parte de um cliente
    $checa = $consulta->PDOQtderegistro("ZPortareDremontagem", "idgrupo = " . $id);
    if ($checa > 0) {
        echo '<div class="alert alert-dismissable alert-danger">
                  <button type="button" class="close" data-dismiss="alert">×</button>' . '
                  Este grupo não pode ser excluído por apresentar contas vinculados!
              </div>';
    } else {
        $consulta->PDOExcluir("ZPortareDregrupo", "id = " . $id);
        echo '<script language="javascript">
            $("#' . $path . $id . '").remove();
            $("#modalExcluir").modal("hide");
        </script>';
    }
}

コード例 #7

0

ファイルを表示

ファイル: list.php プロジェクト: profbaco/sistemaportare

# 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("B.id, A.descricao, B.valor, CASE B.periododiario\r\n\tWHEN 365 THEN 'Anual'\r\n\tWHEN 180 THEN 'Semestral'\r\n\tWHEN 90 THEN 'Trimestral'\r\n\tWHEN 60 THEN 'Bimestral'\r\n\tWHEN 30 THEN 'Mensal'\r\n\tWHEN 1 THEN 'Diária'\r\nEND AS tipodiaria", "ZPortareDespesas A, ZPortareCaminhoesdespesas B", $condicao, $start + 1, $end, "A.descricao");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortareDespesas A, ZPortareCaminhoesdespesas B", $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->descricao . '</td>
                                <td>' . $m->tipodiaria . '</td>
                                <td>' . number_format($m->valor, 2, ',', '.') . '</td>
                                <td>
                                    <a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Editar" onclick="abrirModal(\'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>

コード例 #8

0

ファイルを表示

ファイル: contasnaomigradas.php プロジェクト: profbaco/sistemaportare

# 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>
        </table>

コード例 #9

0

ファイルを表示

ファイル: list.php プロジェクト: profbaco/sistemaportare

# 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.CHAPA, A.NOME, B.NOME FUNCAO", "PFUNC A, PFUNCAO B", $condicao, $start + 1, $end, "A.NOME");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("PFUNC A, PFUNCAO B", $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->CHAPA . '">
                                <td>' . $m->CHAPA . '</td>
                                <td>' . $m->NOME . '</td>
                                <td>' . $m->FUNCAO . '</td>
                                <td>
                                    <a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Ver Detalhes">
                                        <i class="glyphicon glyphicon-edit"></i>
                                    </a>
                                </td>
                              </tr>';

コード例 #10

0

ファイルを表示

ファイル: actions.php プロジェクト: profbaco/sistemaportare

$id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT);
$nome = filter_input(INPUT_POST, 'nome', FILTER_SANITIZE_STRING);
if ($acao == 'inserir') {
    $consulta->PDOInserir("ZPortarePerfil", "(nome)", "('" . $nome . "')");
    echo '<script language="javascript">
                carregaPagina(\'view/' . $path . '/list.php\')
                $("#modalCadastro").modal("hide");
              </script>';
} elseif ($acao == 'editar') {
    $consulta->PDOEditar("ZPortarePerfil", "nome='" . $nome . "'", "id = " . $id);
    echo '<script language="javascript">
                carregaPagina(\'view/' . $path . '/list.php\')
                $("#modalCadastro").modal("hide");
              </script>';
} elseif ($acao == 'excluir') {
    $id = $_POST['id'];
    # Tem que checar se esta seguradora não faz parte de um cliente
    $checa = $consulta->PDOQtderegistro("ZPortareLogin", "idperfil = " . $id);
    if ($checa > 0) {
        echo '<div class="alert alert-dismissable alert-danger">
                  <button type="button" class="close" data-dismiss="alert">×</button>' . '
                  Esta PERFIL não pode ser excluído por apresentar usuário vinculados!
              </div>';
    } else {
        $consulta->PDOExcluir("ZPortarePerfil", "id = " . $id);
        echo '<script language="javascript">
            $("#' . $path . $id . '").remove();
            $("#modalExcluir").modal("hide");
        </script>';
    }
}

コード例 #11

0

ファイルを表示

ファイル: list.php プロジェクト: profbaco/sistemaportare

# 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.id, A.nome, A.email, B.nome perfil, CASE A.ativo WHEN 1 THEN 'Ativo' ELSE 'Inativo' END status", "ZPortareLogin A, ZPortarePerfil B", $condicao, $start + 1, $end, "A.nome");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortareLogin A, ZPortarePerfil B", $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->id . '</td>
                                <td>' . $m->nome . '</td>
                                <td>' . $m->email . '</td>
                                <td>' . $m->perfil . '</td>
                                <td>' . $m->status . '</td>
                                <td>
                                    <a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Editar" onclick="abrirModal(\'editar\', ' . $m->id . ' , \'view/' . $path . '/form.php\')">
                                        <i class="glyphicon glyphicon-edit"></i>
                                    </a>

コード例 #12

0

ファイルを表示

ファイル: list.php プロジェクト: profbaco/sistemaportare

# 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.id, A.codconta, A.codigo, B.descricao,\r\n             CASE A.considerar WHEN 'D' THEN 'Tabela DRE' WHEN 'F' THEN 'Tabela Fixa' WHEN 'P' THEN 'Folha de Pagamento' END considerar,\r\n             CASE A.tipodespesa WHEN 'D' THEN 'Direta' WHEN 'I' THEN 'Indireta' END tipo", "ZPortarePlanocontas A, CCONTA B", $condicao, $start + 1, $end, "codigo");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortarePlanocontas A, CCONTA B", $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->id . '</td>
                                <td>' . $m->considerar . '</td>
                                <td>' . $m->tipo . '</td>
                                <td>' . $m->codconta . '</td>
                                <td>' . $m->codigo . '</td>
                                <td>' . $m->descricao . '</td>
                                <td>
                                    <a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Editar" onclick="abrirModal(\'editar\', ' . $m->id . ' , \'view/' . $path . '/form.php?pagina=' . $pc . '\')">
                                        <i class="glyphicon glyphicon-edit"></i>

コード例 #13

0

ファイルを表示

ファイル: contasnaoagrupadasdre.php プロジェクト: profbaco/sistemaportare

# 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();
}
?>
            </tbody>
        </table>

コード例 #14

0

ファイルを表示

ファイル: list.php プロジェクト: profbaco/sistemaportare

# 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("*", "ZPortarePerfil", $condicao, $start + 1, $end, "nome");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortarePerfil", $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->id . '</td>
                                <td>' . $m->nome . '</td>
                                <td>
                                    <a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Editar" onclick="abrirModal(\'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>

コード例 #15

0

ファイルを表示

ファイル: actions.php プロジェクト: profbaco/sistemaportare

$linkurl = explode("/", $_SERVER['SCRIPT_NAME']);
$path = $linkurl[count($linkurl) - 2];
$acao = $_REQUEST['acao'];
$tipo = $_REQUEST['tipo'];
$requisicao = $_REQUEST['requisicao'];
$id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT);
$idkm = filter_input(INPUT_POST, 'idkm', FILTER_SANITIZE_NUMBER_INT);
$valor = empty($_REQUEST['valor']) ? 0 : str_replace(",", ".", str_replace(".", "", $_REQUEST['valor']));
$litragem = empty($_REQUEST['litragem']) ? 0 : str_replace(",", ".", str_replace(".", "", $_REQUEST['litragem']));
$km = empty($_REQUEST['km']) ? 0 : str_replace(",", ".", str_replace(".", "", $_REQUEST['km']));
list($dia, $mes, $ano) = explode("/", $_REQUEST['data']);
$data = $ano . '-' . $mes . '-' . $dia;
if ($acao == 'inserir') {
    # Checando se já existe Saída do caminhão
    if ($tipo == 'S') {
        $saida = $consulta->PDOQtderegistro("ZPortareKmAbastecimentos", "idkm = " . $idkm . " and tipo = 'S'");
        if ($saida > 0) {
            echo '<div class="alert alert-dismissable alert-danger">
                  <button type="button" class="close" data-dismiss="alert">×</button>' . '
                  Já existe um abastecimento do <b>tipo Saída</b>!
              </div>';
            exit;
        }
    }
    if ($tipo == 'A') {
        #Verificando se já existe um abastecimento de chegada para não deixar cadastrar novos abastecimentos
        $chegada = $consulta->PDOQtderegistro("ZPortareKmAbastecimentos", "idkm = " . $idkm . " and tipo = 'C'");
        if ($chegada > 0) {
            echo '<div class="alert alert-dismissable alert-danger">
                  <button type="button" class="close" data-dismiss="alert">×</button>' . '
                  Não pode inserir abastecimento por já ter um do <b>tipo Chegada</b>!

コード例 #16

0

ファイルを表示

ファイル: list.php プロジェクト: profbaco/sistemaportare

# 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>
                                    <a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Ver Detalhes">
                                        <i class="glyphicon glyphicon-edit"></i>

コード例 #17

0

ファイルを表示

ファイル: list.php プロジェクト: profbaco/sistemaportare

# 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("*", "ZPortareDespesas", $condicao, $start + 1, $end, "descricao");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortareDespesas", $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->id . '</td>
                                <td>' . $m->descricao . '</td>
                                <td>' . number_format($m->valor, 2, ',', '.') . '</td>
                                <td>
                                    <a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Editar" onclick="abrirModal(\'editar\', ' . $m->id . ' , \'view/' . $path . '/form.php?tipo=' . $tipo . '\')">
                                        <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>

コード例 #18

0

ファイルを表示

ファイル: list.php プロジェクト: profbaco/sistemaportare

# 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("*", "ZPortalCAMINHOES", $condicao, $start + 1, $end, "MODELO");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortalCAMINHOES", $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->PLACA . '">
                                <td>' . $m->PLACA . '</td>
                                <td>' . $m->MODELO . '</td>
                                <td>' . $m->VENCIPVA . '</td>
                                <td>
                                    <a href="javascript:void(0)" onclick="CarregarDespesas(\'' . $m->PLACA . '\')" class="btn btn-info btn-xs" rel="tooltip" title="Ver Despesas">
                                        <i class="glyphicon glyphicon-folder-open"></i>
                                    </a>
                                    <a href="javascript:void(0)"  onclick="CarregarAgregados(\'' . $m->PLACA . '\' , \'carretas\')" class="btn btn-warning btn-xs" rel="tooltip" title="Históricos">
                                        <i class="glyphicon glyphicon-eye-open"></i>

コード例 #19

0

ファイルを表示

ファイル: list.php プロジェクト: profbaco/sistemaportare

# 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("*", "ZPortareCombustivel", $condicao, $start + 1, $end, "descricao");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortareCombustivel", $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->id . '</td>
                                <td>' . $m->descricao . '</td>
                                <td>
                                    <a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Editar" onclick="abrirModal(\'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>

PHP banco::PDOQtderegistroの例