E:
/
home
/
kbcomunicacao1
/
Web
/
innterage
/
includes
/
Upload File
HOME
<?php session_start(); // Recuperando informações $ultimo = (int) $_POST['ultimo']; require 'conexao/funcao.inc.php'; require 'conexao/config.php'; require 'conexao/conn.php'; require 'conexao/function.php'; $query = "SELECT id_recibo, status_recibo, recebido_recibo, nosso_recibo, emissao_recibo, datalido_recibo, horalido_recibo, codigo_cliente, razao_cliente, nome_recibo, email_recibo, valor_recibo, competencia_recibo, vencimento_recibo, chave_recibo FROM cw_recibo, cw_cliente WHERE cliente_recibo=id_cliente AND id_recibo < {$ultimo} ORDER BY id_recibo DESC LIMIT 0,30"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); ?> <table class="footable table table-stripped" data-page-size="2400" data-filter=#filter> <tbody> <?php while($res = mysqli_fetch_assoc($result)){ ?> <tr lang='<?php echo $res['id_recibo']; ?>'> <td> <a href="#" title="Excluir" id="<?php echo $res['id_recibo']; ?>" class="deletarrecibo" ><i class="fa fa-trash"> </i></a> </td> <td class="client-status"> <?php if(($res['status_recibo']==0)||($res['status_recibo']==2)){ ?> <a href="#" title="Alterar Status" id="<?php echo $res['id_recibo']; ?>" class=""> <span class="label label-danger">Aberto</span> </a> <?php }elseif($res['status_recibo']==3){ ?> <a href="#" title="Alterar Status" id="<?php echo $res['id_recibo']; ?>" class=""> <span class="label label-info">Parcial</span> </a> <?php }elseif($res['status_recibo']==1){ ?> <a href="#" title="Alterar Status" id="<?php echo $res['id_recibo']; ?>" class=""> <span class="label label-primary">Baixado</span> </a> <?php } ?> </td> <td> <?php if($res['recebido_recibo']=='1'){ ?> <i class="fa fa-check" style="color: blue"></i> <?php } ?> </td> <td class="project-title"> <?php echo $res['nosso_recibo']; ?> <br/> <small>Emitido em <?php echo dbDateToDate2($res['emissao_recibo']); ?> <?php if($res['recebido_recibo']=='1'){ ?> - Lido: <?php echo dbDateToDate2($res['datalido_recibo']); ?> às <?php echo $res['horalido_recibo']; ?><?php } ?></small> </td> <td class="project-title"> <?php echo $res['codigo_cliente']; ?> - <?php echo $res['razao_cliente']; ?> <br/> <small><?php echo $res['nome_recibo']; ?> - <?php echo $res['email_recibo']; ?></small> </td> <td class="project-title"> <i class="fa fa-money"></i> <?php echo formataValor2($res['valor_recibo']); ?> <br/> <small><strong>Competência: <?php echo $res['competencia_recibo']; ?></strong></small> <br/> <small>Vencimento: <?php echo $res['vencimento_recibo']; ?></small> </td> <td class="project-actions"> <a href="#myModal" data-toggle="modal" id="<?php echo $res['id_recibo']; ?>" data-target="#edit-baixacobranca" class="btn btn-white btn-sm"><i class="fa fa-edit"></i> Alterar </a> </td> <td> <a href="views/recibo.php?pin=<?php echo $res['chave_recibo']; ?>" target="_blank" title="Visualizar Recibo" class="btn btn-white btn-sm"><i class="fa fa-table"></i></a> </td> <td> <a href="cobranca/boleto_santander.php?pin=<?php echo $res['chave_recibo']; ?>&tipo=00" target="_blank" title="Visualizar Boleto" class="btn btn-white btn-sm"><i class="fa fa-barcode"></i></a> </td> <td> <a href="#" title="Reenviar" id="<?php echo $res['id_recibo']; ?>" class="reenviarcobranca" class="btn btn-xs btn-white"><i class="fa fa-mail-forward"> </i></a> </td> </tr> <?php } ?> </tbody> </table>