cl_protprocesso::sql_query PHP代码示例

示例#1

0

显示文件

文件： pro2_relconspro002.php 项目： arendasistemasintegrados/mateusleme

$rsResultado = pg_fetch_assoc($sRetorno);
$nomeinstabrev = $rsResultado["nomeinstabrev"];
if (isset($codproc) && $codproc != "") {
    $head3 = "Consulta de Processo ";
    $head4 = "Processo N° {$codproc}";
    $pdf = new PDF();
    $pdf->Open();
    $pdf->AliasNbPages();
    $pdf->addpage('L');
    $total = 0;
    $pdf->setfillcolor(235);
    $pdf->setfont('arial', 'b', 8);
    $troca = 1;
    $alt = 4;
    $total = 0;
    $result_protprocesso = $clprotprocesso->sql_record($clprotprocesso->sql_query($codproc));
    if ($clprotprocesso->numrows != 0) {
        db_fieldsmemory($result_protprocesso, 0);
        $pdf->cell(50, $alt, 'Número de Controle do Processo :', 0, 0, "R", 0);
        $pdf->cell(75, $alt, $codproc, 0, 1, "L", 0);
        $pdf->cell(50, $alt, 'Número do Processo :', 0, 0, "R", 0);
        $pdf->cell(75, $alt, $p58_numero . '/' . $p58_ano, 0, 0, "L", 0);
        $pdf->cell(50, $alt, 'Titular do Processo :', 0, 0, "R", 0);
        $pdf->cell(75, $alt, $z01_nome, 0, 1, "L", 0);
        $pdf->cell(50, $alt, 'Data :', 0, 0, "R", 0);
        $pdf->cell(75, $alt, db_formatar($p58_dtproc, 'd'), 0, 0, "L", 0);
        $pdf->cell(50, $alt, 'Hora :', 0, 0, "R", 0);
        $pdf->cell(75, $alt, $p58_hora, 0, 1, "L", 0);
        $pdf->cell(50, $alt, 'Tipo :', 0, 0, "R", 0);
        $pdf->cell(75, $alt, $p51_descr, 0, 0, "L", 0);
        $pdf->cell(50, $alt, 'Atendente :', 0, 0, "R", 0);

示例#2

0

显示文件

文件： digitaprocesso.php 项目： arendasistemasintegrados/mateusleme

<script>
  document.getElementById('int_perc1').style.visibility='visible';
</script>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" bgcolor="<?php 
echo $w01_corbody;
?>
" onLoad="" <?php 
mens_OnHelp();
?>
>
<br>
<center>
<?php 
//verifica se está logado
if (@$id_usuario != "") {
    $result = $clprotprocesso->sql_record($clprotprocesso->sql_query("", "distinct cgm.z01_numcgm,cgm.z01_cgccpf,cgm.z01_nome,protprocesso.p58_codproc,protprocesso.p58_dtproc,protprocesso.p58_obs", "protprocesso.p58_dtproc desc", "cgm.z01_numcgm = {$id_usuario}"));
    $linhas = $clprotprocesso->numrows;
    if ($linhas != 0) {
        db_fieldsmemory($result, 0);
        //11 14
        if (strlen($z01_cgccpf) > 11) {
            $cgc = $z01_cgccpf;
            $cpf = "";
        } else {
            $cgc = "";
            $cpf = $z01_cgccpf;
        }
        //mostra encontrados
        ?>
   <a href="digitaprocesso.php?outro='outro processo'">:: Pesquisar Outro Processo ::</a><br><br>
   <b><?php

示例#3

0

显示文件

文件： digitaconsultahabitacao.php 项目： arendasistemasintegrados/mateusleme

</script>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" bgcolor="<?php 
echo $w01_corbody;
?>
" onLoad="" <?php 
mens_OnHelp();
?>
>
<br>
<center>
<?php 
//verifica se está logado
if (isset($id_usuario) && !empty($id_usuario)) {
    $sCampos = "distinct cgm.z01_numcgm, cgm.z01_cgccpf, cgm.z01_nome, protprocesso.p58_codproc, ";
    $sCampos .= "protprocesso.p58_dtproc, protprocesso.p58_obs";
    $sSqlProtProcesso = $clprotprocesso->sql_query(null, $sCampos, "protprocesso.p58_dtproc desc", "cgm.z01_numcgm = {$id_usuario}");
    $result = $clprotprocesso->sql_record($sSqlProtProcesso);
    $linhas = $clprotprocesso->numrows;
    if ($linhas != 0) {
        db_fieldsmemory($result, 0);
        //11 14
        if (strlen($z01_cgccpf) > 11) {
            $cgc = $z01_cgccpf;
            $cpf = "";
        } else {
            $cgc = "";
            $cpf = $z01_cgccpf;
        }
        //mostra encontrados
        ?>
   <a href="digitaconsultahabitacao.php?outro='outro processo'">:: Pesquisar Outro Processo ::</a><br><br>

示例#4

0

显示文件

文件： pro3_conspro002.php 项目： arendasistemasintegrados/mateusleme

$result_param = $clprotparam->sql_record($clprotparam->sql_query(null, "*", null, "p90_instit=" . db_getsession("DB_instit")));
if ($clprotparam->numrows > 0) {
    db_fieldsmemory($result_param, 0);
}
if (isset($oPOST->codproc) || isset($oPOST->numeroprocesso)) {
    //Validação se o CPF/CNPJ passado para pesquisa do processo de protocolo é o mesmo do titular do processo.
    if (isset($oPOST->cpf) && !empty($oPOST->cpf)) {
        $sWhere .= " {$sAnd} z01_cgccpf = '" . ereg_replace("[./-]", "", $oPOST->cpf) . "' ";
        $sAnd = " and ";
    } else {
        if (isset($oPOST->cgc) && !empty($oPOST->cgc)) {
            $sWhere .= " {$sAnd} z01_cgccpf = '" . ereg_replace("[./-]", "", $oPOST->cgc) . "' ";
            $sAnd = " and ";
        }
    }
    $sSqlProtProcesso = $clprotprocesso->sql_query(null, "*", null, $sWhere);
    $result_protprocesso = $clprotprocesso->sql_record($sSqlProtProcesso);
    // se existem linhas processa, se não exibe mensagem que não encontrou processos com o código fornecido
    if ($clprotprocesso->numrows > 0) {
        db_fieldsmemory($result_protprocesso, 0);
        if (empty($codproc)) {
            $codproc = $p58_codproc;
        }
        echo "<table width='100%' class='texto'border=0>\n                <tr>\n                  <td width=280px><b>NÚMERO DE CONTROLE DO PROCESSO:</b></td>\n                  <td nowrap colspan='3'>{$codproc}</td>\n                </tr>\n\t              <tr>\n\t\t\t            <td width=280px><b>NÚMERO DO PROCESSO:</b></td>\n                  <td width=350pxnowrap>{$p58_numero}/{$p58_ano} </td>\n                  <td width=100px><b>NOME:</b></td>\n                  <td nowrap>{$z01_nome}</td>\n\t\t            </tr>\n\t\t            <tr>\n                  <td><b>DATA:</b></td>\n                  <td nowrap>" . db_formatar($p58_dtproc, 'd') . "</td>\n                  <td><b>HORA:</b></td>\n                  <td nowrap>{$p58_hora}&nbsp;</td>\n\t\t            </tr>\n\t\t            <tr>\n                  <td><b>TIPO:</b></td>\n\t\t\t            <td nowrap>{$p51_descr}</td>\n\t\t\t            <td><b>ATENDENTE:</b></td>\n\t\t\t            <td nowrap>{$nome}</td>\n\t\t            </tr>\n\t              <tr>\n                  <td><b>DEPARTAMENTO:</b> </td>\n                  <td colspan='3' nowrap>{$p58_coddepto}-{$descrdepto}</td>\n                </tr>\n                <tr>\n                  <td><b>INSTITUIÇÃO:</b> </td>\n                  <td colspan='3' nowrap>{$p58_instit}-{$nomeinst}</td>\n\t\t            </tr>\n\t\t            <tr>\n                  <td><b>REQUERENTE:</b> </td>\n\t\t\t            <td nowrap>{$p58_requer}</td>\n\t\t\t            <td colspan=2>\n                    <input name='imprimir' class='botao' type='button' value='Imprimir Consulta' onclick='js_imprime({$codproc});'>\n                    <input class='botao' type='button' value='Voltar' onclick=\"history.back()\">\n\t \t\t            </td>\n\t\t            </tr>\n\t\t            <tr>\n                  <td ><b>OBSERVAÇÃO:</b> </td>\n                  <td colspan='3'>" . ($p58_obs == "" ? "&nbsp;" : nl2br($p58_obs)) . "</td>\n                </tr>\n                </table>";
        if ($db21_usasisagua == 't') {
            echo "<table width='100%' class='tab' cellspacing=0 cellpading=0 border=1>\n\t\t\t\t          <tr>\n\t\t                <td style='background-color:#CCCCCC' colspan='7' align='center'><b>Andamentos</b></td>\n\t\t              </tr>\n\t\t\t\t          <tr>\n\t\t\t\t\t\t\t\t\t\t<td style='background-color:#CCCCCC' align='center'><b>Data</b></td>\n\t\t\t\t\t\t\t\t\t\t<td style='background-color:#CCCCCC' align='center'><b>Hora</b></td>\n\t\t\t\t\t\t\t\t\t\t<td style='background-color:#CCCCCC' align='center'><b>Depto</b></td>\n\t\t\t\t\t\t\t\t\t\t<td style='background-color:#CCCCCC' align='center'><b>Insti</b></td>\n\t\t\t\t\t\t\t\t\t\t<td style='background-color:#CCCCCC' align='center'><b>Ocorrencia</b></td>\n\t\t                <td style='background-color:#CCCCCC' align='center'><b>Despacho</b></td>\n\t\t\t\t          </tr>";
        } else {
            echo "<table width='100%' class='tab' cellspacing=0 cellpading=0 border=1>\n                  <tr>\n                    <td style='background-color:#CCCCCC' colspan='7' align='center'><b>Andamentos</b></td>\n                  </tr>\n                  <tr>\n                    <td style='background-color:#CCCCCC' align='center'><b>Data</b></td>\n                    <td style='background-color:#CCCCCC' align='center'><b>Hora</b></td>\n                    <td style='background-color:#CCCCCC' align='center'><b>Depto</b></td>\n                    <td style='background-color:#CCCCCC' align='center'><b>Insti</b></td>\n                    <td style='background-color:#CCCCCC' align='center'><b>Login</b></td>\n                    <td style='background-color:#CCCCCC' align='center'><b>Ocorrencia</b></td>\n                    <td style='background-color:#CCCCCC' align='center'><b>Despacho</b></td>\n                  </tr>";
        }
        $result_proctransferproc = $clproctransferproc->sql_record($clproctransferproc->sql_query_file(null, null, "*", "p63_codtran", "p63_codproc = {$codproc}"));
        if ($clproctransferproc->numrows != 0) {

PHP cl_protprocesso::sql_query示例