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'] != "") {
}
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">
">
</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"> </td>
<td align="center" class="td2">
<b>Resultado da Pesquisa</b>
</td>
</tr>
</table>
</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">
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>
<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>
}
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"> </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'> </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'];
?>
( <?php
echo $rsresult3['nomtecnicoresp'];
?>
)</td>
</tr>
<tr>
<td width='5'> </td>
<td align="right" class="td4" width="150"><b>Descrição:</b></td>
<td align="left" class="td3"><?php
echo $desmesnagem;
?>
</td>
</tr>
<tr>
<td valign="top"> </td>
<td valign="top"> </td>
</tr>
<tr>
<td width="30" valign="top"> </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í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">
<form name="form" method="post" action="" onSubmit="return VerificaCamposObrigatorios();">
<table width="600" border="1" cellspacing="0">
<tr>
<td width="5"> </td>
<td width="165" align="right" class="td4"><b>Nº da Solicitação</b></td>
<td width="510" class="td3"> <?php
echo $_REQUEST['codsolicitacao'];
?>
</td>
</tr>
<tr>
<td > </td>
<td align="right" class="td4"><b>Data da Abertura</b> </td>
<td class="td3"> <?php
echo FormataData($dados['dtsolicitacao'], 'pt');
?>
</td>
</tr>
<tr>
<td > </td>
<td align="right" class="td4"> <b>Tipo de Serviço</b></td>
<td class="td3"> <?php
echo $dados['destiposervsol'];
?>
</td>
</tr>
<tr>
<td > </td>
}
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));
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 </div></td>
</tr>
<?php
}
} else {
?>
<tr>
<td height="40" colspan="2"><div align="center">Nenhum registro foi encontrado.</div></td>
</tr>
<?php
$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>
<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"> </td>
<td align="right" width="150" class="td3"><b>URL</b></td>
<td class="td4" align="left">
<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"> </td>
<td align="right" width="150" class="td3"><b>Data de Cadastro da Notícia</b></td>
<td class="td4" align="left">
<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
<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">
$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"> </td>
<td class="td2" align="center"><strong><b>Solicitação de Serviços Bancários <?php
if ($acaotriagem != "") {
echo " - Triagem ";
</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"> </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>
</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;
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"> </td>
<td align="right" width="150" class="td3"><b>Horário de Cadastro</b></td>
<td class="td4" align="left">
<input name="horaaviso1" value="<?php
echo $horaaviso;
?>
" type="text" id="horaaviso1" size="10" disabled/><input name="horaaviso" value="<?php
echo $horaaviso;
?>