E:
/
home
/
kbcomunicacao1
/
Web
/
innterage
/
controlers
/
Upload File
HOME
<div class="row wrapper border-bottom white-bg page-heading"> <div class="col-sm-12"> <h2>Cobrança</h2> <ol class="breadcrumb"> <li> <button data-toggle="modal" data-target="#ModalConfig" type="button" class="btn btn-primary btn-sm"> <i class="fa fa-cog"> </i> Configuração</button> </li> <!--<li> <button data-toggle="modal" data-target="#ModalRelatorio" type="button" class="btn btn-info btn-sm"><i class="fa fa-barcode"></i> Gerar Cobrança</button> </li>--> <li> <button data-toggle="modal" data-target="#ModalRelatorio" type="button" class="btn btn-info btn-sm"><i class="fa fa-barcode"></i> Gerar Cobrança</button> </li> <li> <button data-toggle="modal" data-target="#ModalRelatoriocobranca" type="button" class="btn btn-info btn-sm"><i class="fa fa-bar-chart-o"></i> Relatório Cobrança</button> </li> <li> <button data-toggle="modal" data-target="#ModalLogin" type="button" class="btn btn-info btn-sm"> <i class="fa fa-certificate"> </i> Boleto Manual</button> </li> <li> <button data-toggle="modal" data-target="#ModalRemessa" type="button" class="btn btn-sm"><i class="fa fa-file-code-o"></i> Gerar Arquivo de Remessa</button> </li> </ol> </div> </div> <div class="row"> <div class="col-lg-12"> <div class="wrapper wrapper-content animated fadeInUp"> <div class="ibox"> <div class="tabs-container"> <ul class="nav nav-tabs"> <li class="active"><a data-toggle="tab" href="#tab-2"><i class="fa fa-barcode"></i> Cobrança</a></li> </ul> <div class="tab-content"> <div id="tab-2" class="tab-pane active"><!--TAB 02--> <div class="panel-body"> <div class="ibox-content"><!--DADOS DA TAB 2--> <div class="row m-b-sm m-t-sm"> <div class="col-md-1"> <i class="fa fa-refresh refresh" style="font-size: 21px; cursor: pointer;"></i> </div> <div class="col-md-11"> <div class="input-group"><input type="text" placeholder="Pesquisar" class="input-sm form-control" id="filter-boleto"> <span class="input-group-btn"> <button type="button" class="btn btn-sm btn-primary" id="bttpesboleto" > <i class="fa fa-search"></i></button> </span></div> </div> </div> <div class="project-list"> <?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, gerado_recibo FROM cw_recibo, cw_cliente WHERE cliente_recibo=id_cliente ORDER BY nosso_recibo DESC LIMIT 0,30"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); $row = mysqli_num_rows($result); ?> <table class="footable table table-stripped" data-page-size="30" 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['gerado_recibo']=='1'){ ?> <i class="fa fa-file-code-o" title="Arquivo de remessa gerado"></i> <?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> </div> <?php if($row >0){ ?> <div class="row" id="carregarmais"> <div class="load-more-block text-center"> <a class="btn btn-xs btn-white" href="javascript:func()" id="maisboleto"> <span id="status"></span><div id="lendo"></div> <i class="fa fa-plus-sign">+</i> carregar mais...</a> </div> </div> <?php } ?> </div><!--DADOS DA TAB 2--> </div> </div><!--TAB 02--> </div> </div> </div> </div> </div> </div> <div id="edit-baixacobranca" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> × </button> <h3 class="modal-title-site text-center" > GERENCIAR COBRANÇA </h3> </div> <div id="modalcobranca"> </div> <div> <div> <input name="button" class="btn btn-block btn-lg btn-primary" id="baixarLancamento" value="SALVAR" type="button"> </div> </div> </div> </div> </div> <div id="edit-lacacobranca" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> × </button> <h3 class="modal-title-site text-center" > LANÇAMENTOS DE COBRANÇA </h3> </div> <div id="modallancamentocobranca"> </div> <div> <div> <input name="button" class="btn btn-block btn-lg btn-primary" id="lancarbaixa" value="LANÇAR" type="button"> </div> </div> </div> </div> </div> <!-- MODAL DE CONFIGURAÇÕES --> <!-- Modal Login start --> <div class="modal signUpContent fade" id="ModalConfig" role="dialog" > <div class="modal-dialog "> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> × </button> <h3 class="modal-title-site text-center" > CONFIGURAÇÃO DE COBRANÇA </h3> </div> <div class="modal-body"> <form role="form" name="segurança" method="post" action="./?pag=cbanco"> <div class="form-group login-username col-lg-12"> <div class="col-lg-6"> <label>Banco: </label> <select data-placeholder="Nível do usuário" name="banco" class="chosen-select form-control" tabindex="2"> <option value="">Selecione um Banco</option> <option value="boleto_santander.php">Santander</option> </select> </div> </div> <div class="form-group login-username col-lg-12"> <div class="col-lg-6"> </div> <div class="col-lg-6"> </div> </div> </div> <div> <div> <input name="submit" class="btn cadnewusera btn-block btn-lg btn-primary" value="CADASTRAR" type="submit"> </div> </div> <!--userForm--> </form> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> <!-- MODAL DE CONFIGURAÇÕES --> <!-- MODAL DE CADASTRO DE ENVIO DE INFORME --> <!-- Modal Login start --> <div class="modal signUpContent fade" id="ModalRelatorio" tabindex="-1" role="dialog" > <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> × </button> <h3 class="modal-title-site text-center" > GERAR BOLETO </h3> </div> <div class="modal-body"> <form role="form" name="contasreceber" method="post" action="views/pre-cobranca.php" target="_blank"> <div class="form-group login-username col-lg-12"> <div class="col-lg-8"> <label>Cliente: </label> <?php $query = "SELECT * FROM cw_cliente ORDER BY razao_cliente"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); ?> <select data-placeholder="TODOS" name="cliente[]" class="chosen-select3 form-control" multiple tabindex="2"> <?php while($res = mysqli_fetch_assoc($result)){ ?> <option value="<?php echo $res['id_cliente']; ?>"><?php echo $res['razao_cliente']; ?></option> <?php } ?> </select> </div> <div class="col-lg-4"> <label>Competência: </label> <input type="text" name="periodo" class="form-control lanc" id="periodo" placeholder="Mês de competência" required=""> </div> </div> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" value="AVANÇAR" type="submit"> </div> </div> <!--userForm--> </form> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> <!-- MODAL DE CADASTRO DE ENVIO DE INFORME --> <!-- Modal Login start --> <div class="modal signUpContent fade" id="ModalConta" tabindex="-1" role="dialog" > <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> × </button> <h3 class="modal-title-site text-center" > CADASTRO DE FORMA DE PAGAMENTO </h3> </div> <div class="modal-body"> <form role="form" name="cadNewConta" > <div class="form-group login-username col-lg-12"> <div class="col-lg-12"> <label>Forma de Pagamento: </label> <input type="text" name="fp" id="fpagamento" class="form-control" placeholder="Digite a forma de pagamento" required="" /> </div> </div> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" id="cadnewfp" value="CADASTRAR" type="button"> </div> </div> <!--userForm--> </form> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> <!-- Modal Login start --> <div class="modal signUpContent fade" id="ModalBanco" tabindex="-1" role="dialog" > <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> × </button> <h3 class="modal-title-site text-center" > CADASTRO DE BANCOS </h3> </div> <div class="modal-body"> <form role="form" name="cadNewConta" > <div class="form-group login-username col-lg-12"> <div class="col-lg-12"> <label>Bancos: </label> <input type="text" name="nbanco" id="nomebanco" class="form-control" placeholder="Digite o nome do Banco" /> </div> </div> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" id="cadnewnb" value="CADASTRAR" type="button"> </div> </div> <!--userForm--> </form> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> <!-- MODAL DE CADASTRO DE USER --> <!-- Modal Login start --> <div class="modal signUpContent fade" id="ModalRelatoriocobranca" tabindex="-1" role="dialog" > <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> × </button> <h3 class="modal-title-site text-center" > RELATÓRIO COBRANÇA </h3> </div> <div class="modal-body"> <form role="form" name="contasreceber" method="post" action="views/relatorio_cobranca.php" target="_blank"> <div class="form-group login-username col-lg-12"> <div class="col-lg-4"> <div class="radio radio"> <input type="radio" name="competencia" id="radio3" value="1" checked="" onClick="alternarDocumento('CNPJ')" > <label> Competência </label> </div> <div class="radio radio"> <input type="radio" name="competencia" id="radio3" value="2" onClick="alternarDocumento('CPF')" > <label> Vencimento </label> </div> <div class="radio radio"> <input type="radio" name="competencia" id="radio3" value="3" onClick="alternarDocumento('CPF')" > <label> Baixa </label> </div> </div> <div class="col-lg-4"> <div class="radio radio"> <input type="radio" name="status" id="radio3" value="1" checked="" > <label> Todos </label> </div> <div class="radio radio"> <input type="radio" name="status" id="radio3" value="2" > <label> Aberto </label> </div> </div> </div> <div class="form-group login-username col-lg-12"> <div class="col-lg-6"> <label>Cliente: </label> <?php $query = "SELECT * FROM cw_cliente ORDER BY razao_cliente"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); ?> <select data-placeholder="TODAS" name="cliente[]" class="chosen-select3 form-control" multiple tabindex="2"> <?php while($res = mysqli_fetch_assoc($result)){ ?> <option value="<?php echo $res['id_cliente']; ?>"><?php echo $res['razao_cliente']; ?></option> <?php } ?> </select> </div> <div style="display:block" id="div_cnpj"> <div class="col-lg-3"> <div class="form-group" > <label>DE: </label> <div class="input-group date"> <span class="input-group-addon"><i class="fa fa-calendar" title="Competência incial"></i></span><input type="text" class="form-control" id="compet" name="dec"> </div> </div> </div> <div class="col-lg-3"> <div class="form-group" > <label>ATÉ: </label> <div class="input-group date"> <span class="input-group-addon"><i class="fa fa-calendar-o" title="Competência final"></i></span><input type="text" class="form-control" id="compete" name="atec"> </div> </div> </div> </div> <div style="display:none" id="div_cpf"> <div class="col-lg-3"> <div class="form-group" > <label>DE: </label> <div class="input-group date"> <span class="input-group-addon"><i class="fa fa-calendar" title="Vencimento incial"></i></span><input type="text" class="form-control" id="data_8" name="de"> </div> </div> </div> <div class="col-lg-3"> <div class="form-group" > <label>ATÉ: </label> <div class="input-group date"> <span class="input-group-addon"><i class="fa fa-calendar-o" title="Vencimento final"></i></span><input type="text" class="form-control" id="data_2" name="ate"> </div> </div> </div> </div> </div> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" value="EMITIR" type="submit"> </div> </div> <!--userForm--> </form> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> <!-- MODAL DE CADASTRO DE USER --> <!-- MODAL DE CADASTRO DE USER --> <!-- Modal Login start --> <div class="modal signUpContent fade" id="ModalRemessa" tabindex="-1" role="dialog" > <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> × </button> <h3 class="modal-title-site text-center" > ARQUIVO DE REMESSA </h3> </div> <div class="modal-body"> <form role="form" name="contasreceber" method="post" action="views/pre-remessa.php" target="_blank"> <div class="form-group login-username col-lg-12"> <div class="col-lg-5"> <div class="form-group" > <label>Emissão: </label> <div class="input-group date"> <span class="input-group-addon"><i class="fa fa-calendar" title="Competência incial"></i></span><input type="text" class="form-control" id="data_20" name="remessa"> </div> </div> </div> <div class="form-group login-username col-lg-7"> <p><strong>Filtrar por</strong>:</p> <div class="radio radio-inline"> <input type="radio" id="filtro" value="0" name="filtro" checked="" /> <label for="filtro"> Não Gerados </label> </div> <div class="radio radio-inline"> <input type="radio" id="filtro2" value="1" name="filtro" /> <label for="filtro2"> Gerados </label> </div> <div class="radio radio-inline"> <input type="radio" id="filtro3" value="2" name="filtro" /> <label for="filtro3"> Todos </label> </div> </div> </div> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" value="EMITIR" type="submit"> </div> </div> <!--userForm--> </form> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> <!-- MODAL DE CADASTRO DE USER --> <!-- MODAL DE CADASTRO DE USER --> <!-- Modal Login start --> <div class="modal signUpContent fade" id="ModalLogin" tabindex="-1" role="dialog" > <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> × </button> <h3 class="modal-title-site text-center" > LANÇAMENTO MANUAL </h3> </div> <div class="modal-body" id="modalLancamento"><!-- INICIO DO BODY DO MODAL --> <form role="form" name="cadLancamento" id="cadLancamento" method="post" target="_blank" enctype="multipart/form-data" action="views/pre-cobranca-unica.php"> <div class="col-lg-6"> <label>Cliente: </label> <select name="clienteu" class="form-control chosen-select888" id="clienteu" > <option value="0">Escolha uma empresa</option> <?php $query = "SELECT * FROM cw_cliente WHERE status_cliente=0 order by razao_cliente"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); while($ln = mysqli_fetch_assoc($result)){ echo '<option value="'.$ln['id_cliente'].'">'.$ln['razao_cliente'].'</option>'; } ?> </select> </div> <div class="col-lg-3" style="float: right;"> <label>Competência: </label> <input type="text" name="competenciaCobranca" id="competen" class="form-control" value="" /> </div> <div class="col-lg-3" style="float: right;"> <label>Vencimento: </label> <input type="text" name="vencimentoCobranca" id="data_1" class="form-control" value="" /> </div> <div class="form-group login-username col-lg-12" style="margin-top: 10px"><!-- RATEIO CASO FOR LANCAMENTO RATEADO --> <fieldset style="border:1px solid #CCC; border-radius:5px"> <legend><a href="#" data-toggle="modal" data-target="#ModalRateio">Lançar <i class="fa fa-plus-square"></i></a></legend> <div class="table-responsive" id="tablerateio"> <table class="footable table table-stripped" data-page-size="400" data-filter=#filter> <thead> <tr> <td></td> <th>Valor</th> <th>Histórico</th> </tr> </thead> <tbody> <?php $query = "SELECT * FROM cw_itens_recibo WHERE chave_itens_recibo = '$sessao'"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); ?> <?php while($res = mysqli_fetch_assoc($result)){ ?> <tr> <td> <a href="#" title="Excluir" id="<?php echo $res['id_itens_recibo']; ?>" class="deletarLcobrancau" ><i class="fa fa-trash"> </i></a> </td> <td><?php echo formataValor2($res['valor_itens_recibo']); ?></td> <td><?php echo $res['historico_itens_recibo']; ?></td> </tr> <?php } ?> </tbody> </table> </div> </fieldset> </div><!-- RATEIO CASO FOR LANCAMENTO RATEADO --> </div><!-- FIM DO BODY DO MODAL --> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" value="GERAR BOLETO" type="submit"> </div> </div> <!--userForm--> </form> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> <!-- MODAL DE CADASTRO DE USER --> <!-- MODAL DE CADASTRO DE RATEIO --> <!-- Modal Login start --> <div class="modal signUpContent fade" id="ModalRateio" tabindex="-1" role="dialog" > <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> × </button> <h3 class="modal-title-site text-center" > INSERIR LANÇAMENTO </h3> </div> <div class="modal-body"> <form role="form" name="ModalRateio"> <div class="form-group login-username col-lg-12"> <div class="col-lg-3"> <label>Valor: </label> <input type="text" name="rvaloru" class="form-control" id="rvaloru" placeholder="R$" /> </div> <div class="col-lg-9" id="newCadHistorico"> <label><a href="#" data-toggle="modal" data-target="#ModalContahistorico"><i class="fa fa-plus-circle"></i> Histórico:</a></label> <select name="rhistoricou" class="form-control chosen-select" id="rhistoricou" > <option value="">Digite o histórico</option> <?php $query = "SELECT * FROM cw_historico WHERE tipo_historico = 0 ORDER BY nome_historico"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); while($ln = mysqli_fetch_assoc($result)){ echo '<option value="'.$ln['nome_historico'].'">'.$ln['nome_historico'].'</option>'; } ?> </select> </div> </div> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" id="cadRlancamentounico" value="LANÇAR" type="button"> </div> </div> <!--userForm--> </form> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> <!-- MODAL DE CADASTRO DE RATEIO --> <!-- MODAL DE CADASTRO DE USER --> <!-- Modal Login start --> <div class="modal signUpContent fade" id="ModalContahistorico" tabindex="-1" role="dialog" > <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> × </button> <h3 class="modal-title-site text-center" > CADASTRO DE HISTÓRICOS </h3> </div> <div class="modal-body"> <form role="form" name="cadNewConta" > <div class="form-group login-username col-lg-12"> <div class="col-lg-12"> <label>Digite o histórico: </label> <input type="text" name="historico" id="newhistorico" class="form-control" placeholder="Digite o histórico" required="" /> </div> </div> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" id="cadnewhistorico2" value="CADASTRAR" type="button"> </div> </div> <!--userForm--> </form> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> <!-- MODAL DE CONFIGURAÇÃO DE LANÇAMENTOS --> <div id="edit-modalconfig-lancamento-cobranca" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> × </button> <h3 class="modal-title-site text-center" > CONFIGURAR LANÇAMENTO </h3> </div> <form name="edit-modalconfig-lancamento"> <div class="modal-body edit-content"> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" id="altRlancamento" value="SALVAR" type="button"> </div> </div> </form> </div> </div> </div> <!-- MODAL DE CONFIGURAÇÃO DE LANÇAMENTOS -->