Example #1
0
 if ($_SESSION['codtecnicorespadm'] != "") {
     $onref = "/crediembrapa/homebanking/site/admin";
 }
 if ($codcliente != "") {
     $sqlString = "Select * From cliente where codcliente = " . $codcliente;
     $rsqry = mysql_query($sqlString);
     $rscliente = mysql_fetch_array($rsqry);
     // Se não encontrou a solicitação volta para a pagina inicial
     if ($rscliente == 0) {
         echo "<script>document.location.href='index.php';</script>";
     }
     if ($rscliente['datnascimento'] != "") {
         $datnascimento = FormataData($rscliente['datnascimento'], 'pt');
     }
     if ($rscliente['datemissaorg'] != "") {
         $datemissaorg = FormataData($rscliente['datemissaorg'], 'pt');
     }
     $codmatricula = $rscliente['codmatricula'];
     if ($codmatricula == "0") {
         $codmatricula = "";
     }
     if ($rscliente['numcpfcnpj'] != "") {
         $numcpfcnpj = +$rscliente['numcpfcnpj'];
     }
     if ($rscliente['numrg'] != "") {
         $numrg = +$rscliente['numrg'];
     }
     if ($rscliente['codnucleo'] != "") {
         $codnucleo = +$rscliente['codnucleo'];
     }
     if ($rscliente['numramaltelefone'] != "") {
Example #2
0
}
if ($_SESSION['logado'] != "") {
    // Abre conexão com o bd
    $achou = Conexao($opcao = 'open', conexao_host, conexao_user, conexao_pass, conexao_db);
    $sqlStringAviso = "Select * From aviso where codpainel = 1 and flaativo = 's' order by dataviso desc";
    $rsqryAviso = mysql_query($sqlStringAviso);
    $rsavisoadmin = mysql_fetch_array($rsqryAviso);
    ?>
	   <div style=" background-position:center; background:url(img/atencao.jpg); position: fixed; top:275px; margin-left:0px; left: 330px; height: 130px; width: 170px;" align="left">
	   <table cellspacing="0" border="0">
		  <tr>
		  	<td width="3"></td>
			<td align="justify">
				<p class="style4"><BR><BR><?php 
    if ($rsavisoadmin['desaviso']) {
        echo $rsavisoadmin['desaviso'] . "<BR><b>Postada em </b>(" . FormataData($rsavisoadmin['dataviso'], 'pt') . ")";
    }
    ?>
</p>
			</td>
			<td width="1"></td>
		  </tr>
		</table>
	    
	    
      </div>
	  
<?php 
} else {
    ?>
	  <div style=" background-position:center;  position: fixed; top:275px; margin-left:0px; left: 330px; height: 130px; width: 170px; text-align:left">
Example #3
0
">
      </td>
  </tr>
</table>
</form>

<?php 
}
//fim if tipoacao = VAZIO
// Abre conexão com o bd
$achou = Conexao($opcao = 'open', conexao_host, conexao_user, conexao_pass, conexao_db);
if ($bttipoacao == "Consultar") {
    if ($codsolicitacao == "") {
        if ($dtinicio != "") {
            $dtinicio = FormataData($dtinicio, 'en');
            $dtfinal = FormataData($dtfinal, 'en');
        }
    } else {
        $sqlwhere = " and s.codsolicitacao = " . $codsolicitacao;
    }
    ?>

<br>
<table width="750" border="1" cellspacing="0" class=form>
  <tr>
      <td width="5">&nbsp;</td>
      <td align="center" class="td2">
          <b>Resultado da Pesquisa</b>
      </td>
  </tr>
</table>
Example #4
0
</td>
            <td width="85" align="center" bgcolor="f7f4f4"><?php 
    echo $numparcelas;
    ?>
</td>
            <td width="110" align="right" bgcolor="f7f4f4"><?php 
    echo number_format($rsresult['vlcontrato'], 2, ',', '.');
    ?>
</td>
            <td width="135" align="right" bgcolor="f7f4f4"><font color="#003366"><?php 
    echo number_format($rsresult['vlpercjuros'], 2, ',', '.');
    ?>
 %</font></td>
            <td width="110" align="right" bgcolor="f7f4f4">
              <font color="#003366"><strong><?php 
    echo FormataData($rsresult['datoperacao'], 'pt');
    ?>
</strong></font></td>	
   		   <td width="30" align="center" bgcolor="f7f4f4"><?php 
    echo $opcaosol1;
    ?>
</td>		  
          </tr>

<?php 
    $rsresult = mysql_fetch_array($rsquery);
}
?>
        </table>
		
        <table width="592" border="0" cellspacing="1" cellpadding="3">
Example #5
0
            if ($rsLote['destipolote'] == 'C') {
                $valorcredito = number_format($rslancaplic['vllancamento'], 2, ',', '.');
                $valordebito = "";
                $valorsaldo = $valorsaldo + $rslancaplic['vllancamento'];
            } else {
                $valorcredito = "";
                $valorsaldo = $valorsaldo - $rslancaplic['vllancamento'];
                $valordebito = number_format($rslancaplic['vllancamento'], 2, ',', '.');
            }
            ?>
  
  
   <tr>
      <td width="5"> </td>
      <td bgcolor="#f4f4f4"><?php 
            echo FormataData($rslancaplic['datlote'], 'pt');
            ?>
</td>
	  <td bgcolor="#f4f4f4"><?php 
            echo $rsHistorico['deshistlancamento'];
            ?>
</td>	  
	  <td width="64" bgcolor="#f4f4f4" align="right"><?php 
            echo $valordebito;
            ?>
</td>
	  <td width="64" bgcolor="#f4f4f4" align="right"><?php 
            echo $valorcredito;
            ?>
	  </td>
	  <td width="64" bgcolor="#f4f4f4" align="right"><b>
Example #6
0
    <td width="45%" height="113"valign="top" background="img/topo02.jpg">
	<?php 
if (@$_SESSION['logadoadm'] != "") {
    // Abre conexão com o bd
    $achou = Conexao($opcao = 'open', conexao_host, conexao_user, conexao_pass, conexao_db);
    $sqlStringAviso = "Select * From aviso where codpainel = 0 and flaativo = 's' order by dataviso desc limit 3";
    $rsqryAviso = mysql_query($sqlStringAviso) or die("L317: " . mysql_error());
    $rsavisoadmin = mysql_fetch_array($rsqryAviso);
    ?>
     <div style="position: relative; margin-left:307px; top:-10px; width: 239px;" > 
     <?php 
    do {
        ?>
	    	<?php 
        if ($rsavisoadmin['desaviso']) {
            echo "<br><b title='" . $rsavisoadmin['desaviso'] . "'>" . substr($rsavisoadmin['desaviso'], 0, 20) . "...</b><BR>" . FormataData($rsavisoadmin['dataviso'], 'pt');
        }
        ?>
      <?php 
    } while ($rsavisoadmin = mysql_fetch_assoc($rsqryAviso));
    ?>
      </div>

	
	  
<?php 
} else {
    ?>
     <div style="position: relative; margin-left:307px; top:-10px; width: 239px;" > 
	    <p class="style4"><br>Efetue o login!</p>
      </div>
Example #7
0
    }
    if ($rslancaintegra['vllancamento'] >= 0) {
        $valorcredito = number_format($rslancaintegra['vllancamento'], 2, ',', '.');
        $valordebito = "";
        $valorsaldo = $valorsaldo + $rslancaintegra['vllancamento'];
    } else {
        $valorcredito = "";
        $valorsaldo = $valorsaldo - $rslancaintegra['vllancamento'];
        $valordebito = number_format($rslancaintegra['vllancamento'], 2, ',', '.');
    }
    ?>
		  
		    <tr>
            <td width="7" height="16">&nbsp;</td>
            <td width="69" bgcolor="f7f4f4"><?php 
    echo FormataData($rslancaintegra['datprocessamento'], 'pt');
    ?>
</td>
            <td width="120" bgcolor="f7f4f4">
              <div align="left"><?php 
    echo $rslancaintegra['deslotelancccapital'];
    ?>
</div></td>
            <td width="235" bgcolor="f7f4f4">
              <div align="left"><?php 
    echo $rsHistorico['deshistlancamento'];
    ?>
</div></td>
            <td width="40" bgcolor="f7f4f4">
              <div align="right"><?php 
    echo $valordebito;
            echo "</tr>";
            echo "</table>";
            while (!($rsresult3 == 0)) {
                // Recupera a descrição da mensagem de atendimento
                if ($rsresult3['codmenatedimento'] != "") {
                    $query5 = mysql_query("select desmenatendimento from mensatendimento where codmenatedimento = " . $rsresult3['codmenatedimento']);
                    $rsresult5 = mysql_fetch_array($query4);
                    $desmesnagem = $rsresult5['desmenatendimento'];
                }
                ?>
        <table width='568' border='1' cellspacing='0' class=form>
           <tr>
               <td width='5'>&nbsp;</td>
               <td align="right" class="td4" width="150"><b>Data/Hora:</b></td>
               <td align="left" class="td3"><?php 
                echo FormataData($rsresult3['datregandamento'], 'pt') . " - " . $rsresult3['hrregandamento'];
                ?>
&nbsp;( <?php 
                echo $rsresult3['nomtecnicoresp'];
                ?>
 )</td>
           </tr>
           <tr>
               <td width='5'>&nbsp;</td>
               <td align="right" class="td4" width="150"><b>Descrição:</b></td>
               <td align="left" class="td3"><?php 
                echo $desmesnagem;
                ?>
</td>
           </tr>
           <tr>
Example #9
0
    <td valign="top">&nbsp;</td>
    <td valign="top">&nbsp; </td>
  </tr>
  <tr>
    <td width="30" valign="top">&nbsp;</td>
    <td valign="top">
	<table width="388" border="0" align="center" cellpadding="2" cellspacing="1">
      <tr>
        <td bgcolor="#f4f4f4"><div align="center"><strong>Saldos</strong></div></td>
        <td bgcolor="#f4f4f4"><div align="right"><strong>Data</strong></div></td>		
        <td bgcolor="#f4f4f4"><div align="right"><strong>Valor</strong></div></td>
      </tr>
      <tr>
        <td width="300"><div align="right">Dispon&iacute;vel</div></td>
        <td width="95"><div align="right" class="CorFonteAzul"><?php 
        echo FormataData($Resultado['datultmovconta'], 'pt');
        ?>
</div>
        <td width="95"><div align="center" class="CorFonteAzul">
          <div align="right">
                <strong><?php 
        echo number_format($Resultado['vlsaldodispatual'], 2, ',', '.');
        ?>
</strong></div>
        </div></td>
      </tr>
      <tr>
        <td><div align="right">Bloqueado</div></td>
        <td width="95"><div align="right" class="CorFonteAzul"></div>		
        <td><div align="right" class="CorFonteAzul">
            <div align="right">
Example #10
0
<form name="form" method="post" action="" onSubmit="return VerificaCamposObrigatorios();">
<table width="600" border="1" cellspacing="0">
  <tr>
      <td width="5">&nbsp;</td>
      <td width="165" align="right" class="td4"><b>Nº da Solicitação</b></td>
	  <td width="510" class="td3">&nbsp;<?php 
echo $_REQUEST['codsolicitacao'];
?>
</td>
   </tr>	  	 
    
   <tr>	  
      <td >&nbsp;</td>
      <td align="right" class="td4"><b>Data da Abertura</b> </td>
      <td class="td3">&nbsp;<?php 
echo FormataData($dados['dtsolicitacao'], 'pt');
?>
 </td>
  </tr>
  
  <tr>
      <td >&nbsp;</td>
      <td align="right" class="td4"> <b>Tipo de Serviço</b></td>
	  <td class="td3">&nbsp;<?php 
echo $dados['destiposervsol'];
?>
</td>
   </tr>
   
   <tr>
      <td >&nbsp;</td>
Example #11
0
}

try {
	if ($filtro <> 'agendada' AND $filtro <> 'realizada' AND $filtro <> 'correcao'){
		$filtro = '';
	}

	$provas = $sessionFacade->recuperarProvaTodosDAO($filtro);
	for($i= 0; $i < count($provas); $i++) { 
		$model->assign_block_vars('prova', array(	'PROVA'		=>	$provas[$i]->getId(),
													'TITULO'	=>	$provas[$i]->getTitulo(),
													'CURSO'		=>	$provas[$i]->getDisciplina()->getCurso()->getNome(),
													'DISCIPLINA'=>	$provas[$i]->getDisciplina()->getNome(),
													'DATA'		=>	FormataData($provas[$i]->getData(),'às'),
													'DATA_INICIO'=>	FormataData($provas[$i]->getDataInicio()),
													'DATA_TERMINO'=>FormataData($provas[$i]->getDataTermino()),
													'CLASSE'	=>	$i%2==0?"class='odd'":""
		));
	}
	if (count($provas)==0){
		$msg_aux = 'cadastrada';
		if ($filtro == 'agendada'){
			$msg_aux = 'agendada';
		}
		if ($filtro == 'realizada'){
			$msg_aux = 'realizada';
		}
		if ($filtro == 'correcao'){
			$msg_aux = 'pendente de correção';
		}
		$model->assign_block_vars('naoencontrado', array('MSG' => 'Nenhuma prova '.$msg_aux));
Example #12
0
    echo $SelMovCC[0] .= " LIMIT 0,1";
    /*		$SelMovCC[0] = "SELECT datultmovconta,vlsaldodispatual FROM movcontacorrente ";
    		$SelMovCC[0].= " WHERE numcontacorrente=".$_SESSION['numcontacorrente'];
    		$SelMovCC[0].= " ORDER BY datultmovconta DESC";
    		$SelMovCC[0].= " LIMIT 0,3";
    */
    if (VerificaRegistro($SelMovCC[0])) {
        $SelMovCC[1] = @mysql_query($SelMovCC[0]);
        while ($ResMovcc = @mysql_fetch_array($SelMovCC[1])) {
            if (empty($ResMovcc['datultmovconta'])) {
                $ResMovcc['datultmovconta'] = $today = date('Y-m-d');
            }
            ?>
			<tr>
				<td><div align="center"><?php 
            echo FormataData($ResMovcc['datultmovconta'], 'pt');
            ?>
</div></td>
				<td><div align="right" class="CorFonteAzul"><?php 
            echo number_format($ResMovcc['vlsaldodispatual'], 2, ',', '.');
            ?>
C&nbsp;&nbsp;</div></td>
			</tr>
			<?php 
        }
    } else {
        ?>
			<tr>
			<td height="40" colspan="2"><div align="center">Nenhum registro foi encontrado.</div></td>
			</tr>
			<?php 
Example #13
0
$rsnoticias = mysql_fetch_array($querynoticias);
?>
	<table width="600" border="0">
		<tr class="td6">
			<td width="90"><strong>Data da Notícia</strong></td>
			<td><strong>Descrição da Notícia</strong></td>
			<td width="30"><strong>Link</strong></td>
		</tr>

<?php 
//Laço para Imprimir as notícias
while ($rsnoticias) {
    ?>
		<tr cellspacing="1">
			<td width="90" class="td6"><?php 
    echo FormataData($rsnoticias['datcadastro'], 'pt');
    ?>
</td>
			<td class="td3" ><?php 
    echo $rsnoticias['desnoticia'];
    ?>
</td>
			<td width="60" class="td6" ><strong><a href="http://<?php 
    echo $rsnoticias['desurl'];
    ?>
" target="new" class="a"><?php 
    echo $rsnoticias['desurl'];
    ?>
</a></strong></td>
		</tr>
Example #14
0
                                         <font face="arial, verdana, sans-serif" size="1"><input class="form" readonly type=text name="campolimite" size=3 maxlength=3 value="240"> Caracteres Restantes.</font>
   </td>
  </tr>
  <tr>
    <td width="5">&nbsp;</td>
    <td align="right" width="150" class="td3"><b>URL</b></td>
    <td class="td4" align="left">
	   &nbsp;<input type=text name="desurl" size=60 maxlength=50 value="<?php 
    echo $rsnoticia['desurl'];
    ?>
">
   </td>
  </tr>
<?php 
    if ($rsnoticia['datcadastro'] != "") {
        $datcadastro = FormataData($rsnoticia['datcadastro'], 'pt');
    } else {
        $datcadastro = date("d-m-Y", time());
    }
    ?>
  <tr>
    <td width="5">&nbsp;</td>
    <td align="right" width="150" class="td3"><b>Data de Cadastro da Notícia</b></td>
	<td class="td4" align="left">
	   &nbsp;<input name="datcadastro" value="<?php 
    echo $datcadastro;
    ?>
" type="text" id="datcadastro" onkeypress="mascaradata(document.form.datcadastro)" onsubmit="validadata(document.form.datcadastro)" size="14" maxlength="10" /></td>
  </tr>

<?php 
Example #15
0
        <tr>
          <td width="80"><img src="img/contacorrente2.gif" width="75" height="17"></td>
          <td><font color="#FFFFFF"><?php 
    if (!empty($_SESSION['numcontacorrente'])) {
        echo $_SESSION['numcontacorrente'];
    }
    ?>
</font><font color="#FFFFFF"> - <?php 
    if (!empty($_SESSION['nomcliente'])) {
        echo $_SESSION['nomcliente'];
    }
    ?>
          </font></td>
          <td width="78"><img src="img/ultimo_acesso.jpg" width="75" height="17"> </td>
          <td width="66"><font color="#FFFFFF"><?php 
    echo FormataData($_SESSION['datultacessocli'], 'pt');
    ?>
</font></td>
        </tr>
<?php 
}
?>
    </table></td>
   <td><img src="img2/spacer.gif" width="1" height="30" border="0" alt=""></td>
  </tr>
  <tr><!-- row 4 -->
   <td><img name="index_13" src="img2/index_13.gif" width="205" height="7" border="0" alt=""></td>
   <td><img src="img2/spacer.gif" width="1" height="7" border="0" alt=""></td>
  </tr>
  <tr><!-- row 5 -->
   <td colspan="18" background="img2/fakemenu.gif">
Example #16
0
        $codtiposervsol = $rsresult['codtiposervsol'];
        $hrsolicitacao = $rsresult['hrsolicitacao'];
        $dtsolicitacao = $rsresult['dtsolicitacao'];
        $dtsolicitacao = FormataData($dtsolicitacao, 'pt');
        $numcontacorrentesol = $rsresult['numcontacorrente'];
        $codtecnicoresp = $rsresult['codtecnicoresp'];
        $codtecnicoresp = $rsresult['codtecnicoresp'];
        $desemailcont = $rsresult['desemailcont'];
        $numtelefonecont = $rsresult['numtelefonecont'];
        if ($dtconclusao != "") {
            $dtconclusao = $rsresult['dtconclusao'];
            $dtconclusao = FormataData($dtconclusao, 'pt');
        }
        if ($dtencerramento != "") {
            $dtencerramento = $rsresult['dtencerramento'];
            $dtencerramento = FormataData($dtencerramento, 'pt');
        }
        $dessolicitacao = $rsresult['dessolicitacao'];
        $dessolicitante = RecUsuarioSol($codsolicitacao);
    }
    ?>

<form name="form" method="post" action="" onSubmit="return VerificaCamposObrigatorios();">
<br>
<br>
 <table width="580" border="0" cellspacing="0" cellpadding="0" class="table">
  <tr>
    <td width="5">&nbsp;</td>
    <td class="td2" align="center"><strong><b>Solicitação de Serviços Bancários <?php 
    if ($acaotriagem != "") {
        echo " - Triagem ";
Example #17
0
	            </tr>
	  		  </table>	
<?php 
    //somatorio coluna débito
    $vldebitotot = $vldebitotot + $vlparcelatot + $rsmov['vljurparcela'];
    ?>
	   
		  	  <table width="650" border="0" cellpadding="1" cellspacing="3" bgcolor="#FFFFFF">  
	            <tr>		  
	  		    <td width="7">&nbsp;</td>
	              <td width="85" bgcolor="f7f4f4" ><?php 
    echo $dessitparcela;
    ?>
</td>
	              <td width="81" bgcolor="f7f4f4"><?php 
    echo FormataData($rsmov['datvencimento'], 'pt');
    ?>
</td>
      	        <td width="250" bgcolor="f7f4f4">Liquidação na operação</td>
          	    <td width="80" bgcolor="f7f4f4" align="right"> </td>
	              <td width="80" bgcolor="f7f4f4" align="right"><?php 
    echo number_format($rsmov['vlparcela'], 2, ',', '.');
    ?>
</td>
      	        <td width="80" bgcolor="f7f4f4" align="right"><?php 
    $saldoaux2 = $saldoaux - $rsmov['vlparcela'];
    echo number_format($saldoaux2, 2, ',', '.');
    ?>
</td>
	            </tr>
	  		  </table>	
Example #18
0
</td>
      <td bgcolor="#f5f5f5" width="40" align="center"><font color="#000000"> <?php 
            echo $codsolicitacao1[$prox];
            ?>
 </font>
	   </td>
      <td bgcolor="#f5f5f5" width="120" align="left"><?php 
            echo $destiposervsol[$prox];
            ?>
</td>	  
	  <td bgcolor="#f5f5f5" width="200" align="left"><?php 
            echo $numcontacorrentev[$prox] . "-" . $nomclientev[$prox];
            ?>
</td>
      <td bgcolor="#f5f5f5" width="65" align="left"><?php 
            echo FormataData($dtsolicitacao[$prox], 'pt');
            ?>
</td>	  	  	  
      <td bgcolor="#f5f5f5" width="55" align="left"><?php 
            echo $hrsolicitacao[$prox];
            ?>
</td>	  	  	  	  
  </tr>	  
</table>


<?php 
        }
        $prox = $prox + 1;
    }
    $proxgrava = $prox;
Example #19
0
    echo $rsaviso['desaviso'];
    ?>
</textarea>
	</td>
  </tr>
<?php 
    //Busca HORÁRIO DE CADASTRO
    if ($rsaviso['horaaviso'] != "") {
        $horaaviso = $rsaviso['horaaviso'];
    } else {
        $horaaviso = date("H:i:s");
    }
    //Busca DATA DE CADASTRO
    if ($rsaviso['dataviso'] != "") {
        $dataviso = $rsaviso['dataviso'];
        $dataviso = FormataData($dataviso, 'pt');
    } else {
        $dataviso = date("d-m-Y");
    }
    ?>
  
  <tr>
    <td width="5">&nbsp;</td>
    <td align="right" width="150" class="td3"><b>Horário de Cadastro</b></td>
	<td class="td4" align="left">
	   &nbsp;<input name="horaaviso1" value="<?php 
    echo $horaaviso;
    ?>
" type="text" id="horaaviso1" size="10" disabled/><input name="horaaviso" value="<?php 
    echo $horaaviso;
    ?>