E:
/
home
/
kbcomunicacao1
/
Web
/
innterage
/
controlers
/
Upload File
HOME
<div class="row wrapper border-bottom white-bg page-heading"> <div class="col-lg-10"><!--topo cliente --> <h2>Lançamentos Financeiros</h2> <ol class="breadcrumb"> <li> <button data-toggle="modal" data-target="#ModalLogin" type="button" class="btn btn-primary btn-sm">Novo Lançamento</button> </li> <li> <button data-toggle="modal" data-target="#ModalRelatorio" type="button" class="btn btn-info btn-sm"><i class="fa fa-bar-chart-o"></i> Relatório Financeiro</button> </li> </ol> </div> <div class="col-lg-2"> </div> </div><!-- topo clientes --> <div class="wrapper wrapper-content animated fadeInRight"><!-- clientes--> <div class="row"> <div class="col-sm-12"> <div class="ibox"> <div class="ibox-content"> <h2>Lançamentos Financeiros</h2> <div class="input-group col-lg-12"> <form name="pesquisa-lancamentos"> <div class="col-lg-2"><!-- PESQUISA POR VALOR OU POR OUTROS --> <div class="radio radio-danger"> <input type="radio" name="tipopesquisa" onClick="alternarPesquisa('OUTROS')" id="tp" value="1" checked="" > <label for="Outros"> Outros </label> </div> <div class="radio radio-danger"> <input type="radio" name="tipopesquisa" onClick="alternarPesquisa('PCONTA')" id="tp" value="3" > <label for="Plano de Contas"> Plano de Contas </label> </div> <div class="radio radio-danger"> <input type="radio" name="tipopesquisa" onClick="alternarPesquisa('OUTROS')" id="tp" value="2" > <label for="Valor"> Valor </label> </div> </div><!-- PESQUISA POR VALOR OU POR OUTROS --> <div style="display:block" id="div_outros" class="col-lg-4"><!-- BUSCA DA PESQUISA --> <label>Pesquisa: </label> <input type="text" id="pesquisatp" name="pesquisatp" class="form-control" placeholder="Pesquisa" /> </div><!-- BUSCA DA PESQUISA --> <div style="display:none" id="div_pconta" class="col-lg-4"><!-- BUSCA DA PESQUISA --> <label>Pesquisa: </label> <select name="pesquisapconta" class="form-control chosen-select888" id="pesquisapconta" > <option value="">Escolha um plano de conta</option> <?php $query = "SELECT * FROM cw_plano ORDER BY 1_plano, 2_plano, 3_plano, 4_plano, 5_plano, 6_plano"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); while($ln = mysqli_fetch_assoc($result)){ ?> <option value="<?php echo $ln['codigo_plano']; ?>"><?php echo $ln['codigo_plano']; ?> - <?php echo $ln['nome_plano']; ?></option> <?php } ?> </select> </div><!-- BUSCA DA PESQUISA --> <div class="col-lg-1"><!-- PESQUISA POR VALOR OU POR OUTROS --> <div class="radio radio-danger"> <input type="radio" name="tipobaixa" id="tipobaixa" value="1" checked="" > <label for="Todos"> Todos </label> </div> <div class="radio radio-danger"> <input type="radio" name="tipobaixa" id="tipobaixa" value="2" > <label for="Aberto"> Aberto </label> </div> <div class="radio radio-danger"> <input type="radio" name="tipobaixa" id="tipobaixa" value="3" > <label for="Baixado"> Baixado </label> </div> </div><!-- PESQUISA POR VALOR OU POR OUTROS --> <!-- DE PARA POR VENCIMENTO --> <div class="col-lg-2"> <div class="form-group" > <label>De: </label> <div class="input-group date"> <span class="input-group-addon"><i class="fa fa-calendar"></i></span><input type="text" class="form-control" id="data_20" name="data_20" value="" required=""> </div> </div> </div> <div class="col-lg-2"> <div class="form-group" > <label>Até: </label> <div class="input-group date"> <span class="input-group-addon"><i class="fa fa-calendar"></i></span><input type="text" class="form-control" id="data_21" name="data_21" value="" required=""> </div> </div> </div> <div class="col-lg-1"> <div class="form-group" > <label> </label> <div class="input-group date"> <button type="button" class="btn btn-primary btn-blancamento-tp"> <i class="fa fa-search"></i> </button> </div> </div> </div> <!-- DE PARA POR VENCIMENTO --> </form> </div> <div class="clients-list"> <ul class="nav nav-tabs"> <li class="active"><a data-toggle="tab" href="#tab-2"><i class="fa fa-money"></i> Lançamentos Financeiros</a></li> </ul> <div class="tab-content"> <div id="tab-2" class="tab-pane active"> <div class="full-height-scroll"> <div class="table-responsive"> <table width="100%" class="footable table table-stripped" data-page-size="100" data-filter=#filter> <thead> <tr> <td width="1%"></td> <th width="3%"></th> <th width="3%"></th> <th width="19%">Plano de Conta</th> <th width="16%">Conta</th> <th width="2%"></th> <th width="11%">Valor</th> <th width="7%">Venc.</th> <th width="7%">Baixa</th> <th width="6%">Doc</th> <th width="25%">Histórico</th> </tr> </thead> <tbody id="lancamentoFinanceiros"> <?php $query = "SELECT chave_lancamentos, id_lancamentos, numero_lancamentos, parcelas_lancamentos, rateio_lancamento, nparcelas_lancamentos, pconta_lancamento, conta_lancamento, emissao_lancamentos, dc_lancamento, valor_lancamento, vencimento_lancamentos, baixa_lancamentos, nf_lancamentos, rateio_lancamento, historico_lancamento, historico_lancamentos FROM cw_lancamentos, cw_lancamento WHERE cw_lancamentos.chave_lancamentos=cw_lancamento.chave_lancamento AND (WEEK(vencimento_lancamentos) = WEEK(NOW())) AND baixa_lancamentos = '0000-00-00' ORDER BY vencimento_lancamentos"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); ?> <?php while($res = mysqli_fetch_assoc($result)){ $querynp = "SELECT nome_plano FROM cw_plano WHERE codigo_plano='$res[pconta_lancamento]'"; $resultnp = DBExecute($querynp); $resnp = mysqli_fetch_assoc($resultnp); ?> <tr> <td><a href="#" title="Excluir" id="<?php echo $res['chave_lancamentos']; ?>" class="deletar-lancamento" ><i class="fa fa-trash"> </i></a></td> <td><a href="#myModal" data-toggle="modal" id="<?php echo $res['id_lancamentos']; ?>" data-target="#edit-modallancamentos"><?php echo $res['numero_lancamentos']; ?>.<?php echo $res['parcelas_lancamentos']; ?><?php echo $res['rateio_lancamento']; ?></a></td> <td><a href="#myModal" data-toggle="modal" id="<?php echo $res['id_lancamentos']; ?>" data-target="#edit-modallancamentos"><?php echo $res['parcelas_lancamentos']; ?>/<?php echo $res['nparcelas_lancamentos']; ?></a></td> <td><a href="#myModal" data-toggle="modal" id="<?php echo $res['id_lancamentos']; ?>" data-target="#edit-modallancamentos"><?php echo $res['pconta_lancamento']; ?> - <?php echo $resnp['nome_plano']; ?></a></td> <td><a href="#myModal" data-toggle="modal" id="<?php echo $res['id_lancamentos']; ?>" data-target="#edit-modallancamentos"><?php echo $res['conta_lancamento']; ?></a></td> <td style="text-align:center"><a href="#myModal" data-toggle="modal" id="<?php echo $res['id_lancamentos']; ?>" data-target="#edit-modallancamentos"><?php if($res['dc_lancamento']==2){echo"<i class='fa fa-plus-circle'></i> ";}else{echo"<i class='fa fa-minus-circle' style='color:#F00'></i> ";} ?></a></td> <td><a href="#myModal" data-toggle="modal" id="<?php echo $res['id_lancamentos']; ?>" data-target="#edit-modallancamentos"><?php echo formataValor2($res['valor_lancamento']); ?></a></td> <td><a href="#myModal" data-toggle="modal" id="<?php echo $res['id_lancamentos']; ?>" data-target="#edit-modallancamentos"><?php echo dbDateToDate2($res['vencimento_lancamentos']); ?></a></td> <td><a href="#myModal" data-toggle="modal" id="<?php echo $res['id_lancamentos']; ?>" data-target="#edit-modallancamentos"><?php if($res['baixa_lancamentos']!="0000-00-00"){echo dbDateToDate2($res['baixa_lancamentos']);} ?></a></td> <td><a href="#myModal" data-toggle="modal" id="<?php echo $res['id_lancamentos']; ?>" data-target="#edit-modallancamentos"><?php echo $res['nf_lancamentos']; ?></a></td> <td><a href="#myModal" data-toggle="modal" id="<?php echo $res['id_lancamentos']; ?>" data-target="#edit-modallancamentos"><?php if($res['rateio_lancamento']=="R"){echo $res['historico_lancamento'];}else{echo $res['historico_lancamentos'];} ?></a></td> </tr> <?php } ?> </tbody> </table> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div><!-- clientes--> <!-- 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ÇAMENTOS FINANCEIROS </h3> </div> <div class="modal-body" id="modalLancamento"><!-- INICIO DO BODY DO MODAL --> <form role="form" name="cadLancamento" id="cadLancamento"> <div class="form-group login-username col-lg-12"> <div class="col-lg-2"> <div class="radio radio-danger"> <input type="radio" name="tipo" onClick="alternarLancamento('UNICO')" id="tipo" value="1" checked="" > <label for="Único"> Único </label> </div> <div class="radio radio-danger"> <input type="radio" name="tipo" onClick="alternarLancamento('RATEADO')" id="tipo" value="2" > <label for="Rateado"> Rateado </label> </div> </div> <div class="col-lg-4"> <div class="form-group" > <label>Data do lançamento: </label> <div class="input-group date"> <span class="input-group-addon"><i class="fa fa-calendar"></i></span><input type="text" class="form-control" id="data_1" name="emissao" value="<?php echo date("d/m/Y"); ?>" required=""> </div> </div> </div> <div class="col-lg-6"> <div style="display:block" id="div_conta_u" class="newConta"><!-- CONTA CASO FOR LANCAMENTO UNICO --> <label><a href="#" data-toggle="modal" data-target="#ModalConta"><i class="fa fa-plus-circle"></i> Conta:</a></label> <select name="conta" class="form-control chosen-select" id="conta" > <option value="">Escolha uma conta</option> <?php $query = "SELECT * FROM cw_contas order by nome_contas"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); while($ln = mysqli_fetch_assoc($result)){ echo '<option value="'.$ln['nome_contas'].'">'.$ln['nome_contas'].'</option>'; } ?> </select> </div><!-- CONTA CASO FOR LANCAMENTO UNICO --> <div style="display:none" id="div_conta_r"><!-- CONTA CASO FOR LANCAMENTO RATEADO --> <label>Conta:</label> <select name="" disabled="disabled" class="form-control" > </select> </div><!-- CONTA CASO FOR LANCAMENTO RATEADO --> </div> </div> <div class="form-group login-username col-lg-12" style="display:none" id="div_rateio_r"><!-- RATEIO CASO FOR LANCAMENTO RATEADO --> <fieldset style="border:1px solid #CCC; border-radius:5px"> <legend><a href="#" data-toggle="modal" data-target="#ModalRateio">Rateio <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> <tbody> <?php $query = "SELECT * FROM cw_lancamento WHERE chave_lancamento = '$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_lancamento']; ?>" class="deletarLrateio" ><i class="fa fa-trash"> </i></a> </td> <td><?php if($res['dc_lancamento']=='1'){echo"DEB";}else{echo"CRED";} ?></td> <td><?php echo $res['conta_lancamento']; ?></td> <td><?php echo $res['pconta_lancamento']; ?></td> <td><?php echo formataValor2($res['valor_lancamento']); ?></td> <td><?php echo $res['historico_lancamento']; ?></td> </tr> <?php } ?> </tbody> </table> </div> </fieldset> </div><!-- RATEIO CASO FOR LANCAMENTO RATEADO --> <div class="form-group login-username col-lg-12"> <div class="col-lg-6"> <div style="display:block" id="div_plano_conta_u" class="newPlanoConta"><!-- PLANO DE CONTAS CASO FOR LANCAMENTO UNICO --> <label><a href="#" data-toggle="modal" data-target="#ModalPConta"><i class="fa fa-plus-circle"></i> Plano de conta:</a></label> <select name="plano_conta" class="form-control chosen-select" id="plano_conta" > <option value="">Escolha um plano de conta</option> <?php $query = "SELECT * FROM cw_plano WHERE cabeca_plano='0' order by codigo_plano + 0, numero_plano"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); while($ln = mysqli_fetch_assoc($result)){ ?> <option value="<?php echo $ln['codigo_plano']; ?>"><?php echo $ln['codigo_plano']; ?> - <?php echo $ln['nome_plano']; ?></option> <?php } ?> </select> </div><!-- PLANO DE CONTAS CASO FOR LANCAMENTO UNICO --> <div style="display:none" id="div_plano_conta_r"><!-- PLANO DE CONTAS CASO FOR LANCAMENTO RATEADO --> <label>Plano de conta:</label> <select class="form-control" name="" disabled="disabled" > </select> </div><!-- PLANO DE CONTAS CASO FOR LANCAMENTO RATEADO --> </div> <div class="col-lg-3"> <div class="form-group" > <label>Vencimento: </label> <div class="input-group date"> <span class="input-group-addon"><i class="fa fa-calendar"></i></span><input type="text" class="form-control" id="data_4" name="vencimento" required=""> </div> </div> </div> <div class="col-lg-3"> <div class="form-group" > <label>Previsão pgto: </label> <div class="input-group date"> <span class="input-group-addon"><i class="fa fa-calendar"></i></span><input type="text" class="form-control" id="data_5" name="previsao" required=""> </div> </div> </div> </div> <div class="form-group login-username col-lg-12"> <div class="col-lg-2"> <div style="display:block" id="div_tipo_u"><!-- C/D CASO FOR LANCAMENTO UNICO --> <div class="radio radio-danger"> <input type="radio" name="cd" id="cd" value="1" checked="" > <label for="DEB"> DEB </label> </div> <div class="radio radio-danger"> <input type="radio" name="cd" id="cd" value="2" > <label for="CRE"> CRE </label> </div> </div><!-- C/D CASO FOR LANCAMENTO UNICO --> <div style="display:none" id="div_tipo_r"><!-- C/D CASO FOR LANCAMENTO RATEADO --> <div class="radio radio-danger"> <input name="" type="radio" disabled="disabled" value="" /> <label for="DEB"> DEB </label> </div> <div class="radio radio-danger"> <input name="" type="radio" disabled="disabled" value="" /> <label for="CRE"> CRE </label> </div> </div><!-- C/D CASO FOR LANCAMENTO RATEADO --> </div> <div class="col-lg-4"> <div style="display:block" id="div_valor_u"><!-- VALOR CASO FOR LANCAMENTO UNICO --> <label>Valor: </label> <input type="text" id="valor" name="valor" class="form-control" placeholder="R$" /> </div><!-- VALOR CASO FOR LANCAMENTO UNICO --> <script type="text/javascript"> function atualizartotaiss() { var url="includes/somarateio.php"; jQuery(".somavalor").load(url); } setInterval("atualizartotaiss()", 5000); </script> <div style="display:none" id="div_valor_r" class="somavalor"><!-- VALOR CASO FOR LANCAMENTO RATEADO --> <label>Valor: </label> <input name="" id="outvalor" type="text" class="form-control" readonly="readonly" /> </div><!-- VALOR CASO FOR LANCAMENTO RATEADO --> </div> <div class="col-lg-3"> <div class="radio radio-danger"> <input type="radio" name="periodo" onClick="alternarPeriodo('UNICO')" id="periodo" value="1" checked="" > <label for="Único"> Único </label> </div> <div class="radio radio-danger"> <input type="radio" name="periodo" onClick="alternarPeriodo('PARCELAS')" id="periodo" value="2" > <label for="Parcelas"> Parcelas </label> </div> <div class="radio radio-danger"> <input type="radio" name="periodo" onClick="alternarPeriodo('PERIODICO')" id="periodo" value="3" > <label for="Periódico"> Periódico </label> </div> </div> <div class="col-lg-2" style="display:none" id="div_parcela"> <label>Parcelas: </label> <input type="text" name="parcelas" id="parcelas" class="form-control" placeholder="Parcelas" /> </div> <div class="col-lg-1" style="display:none" id="div_gerar"> <label> </label> <a class="btn btn-info add-produtos-vendas" id="gerarParcelas" title="Gerar parcelas" href="#" > <i class="fa fa-check"></i> </a> </div> </div> <div class="form-group login-username col-lg-12" style="display:none" id="div_parcelas"><!-- PARCELAS CASO FOR LANCAMENTO PARCELADO --> <fieldset style="border:1px solid #CCC; border-radius:5px"> <legend>Parcelas <i class="fa fa-stack-overflow"></i></legend> <div id="parcelamentos" style="margin-left: 10px"> </div> </fieldset> </div><!-- PARCELAS CASO FOR LANCAMENTO PARCELADO --> <div class="form-group login-username col-lg-12"> <div class="col-lg-3"> <label><a href="#" data-toggle="modal" data-target="#ModalRdoc"><i class="fa fa-plus-circle"></i> Recebeu doc.? </a></label> <div id="newRdocumento"> <select name="rdoc" class="form-control chosen-select" id="rdoc" > <option value=""></option> <?php $query = "SELECT * FROM cw_rdoc order by nome_rdoc"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); while($ln = mysqli_fetch_assoc($result)){ echo '<option value="'.$ln['nome_rdoc'].'">'.$ln['nome_rdoc'].'</option>'; } ?> </select> </div> </div> <div class="col-lg-3"> <label><a href="#" data-toggle="modal" data-target="#ModalFpgto"><i class="fa fa-plus-circle"></i> Forma de pgto: </a></label> <div id="newFdePagamento"> <select name="forma_pagamento" class="form-control chosen-select" id="forma_pagamento" > <option value=""></option> <?php $query = "SELECT * FROM cw_fpagamento order by nome_fpagamento"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); while($ln = mysqli_fetch_assoc($result)){ echo '<option value="'.$ln['nome_fpagamento'].'">'.$ln['nome_fpagamento'].'</option>'; } ?> </select> </div> </div> <div class="col-lg-3"> <div class="form-group" > <label>Baixa: </label> <div class="input-group date"> <span class="input-group-addon"><i class="fa fa-calendar"></i></span><input type="text" class="form-control" id="data_6" name="baixa" required=""> </div> </div> </div> <div class="col-lg-3"> <label>Documento: </label> <input name="nf" type="text" id="nf" class="form-control" /> </div> </div> <div class="form-group login-username col-lg-12"> <div class="col-lg-2"> <div class="checkbox checkbox-success"> <input id="tprojeto" name="tprojeto" value="1" type="checkbox" onclick="bloqueio()" /> <label for="checkbox3"> Projeto </label> </div> <div class="checkbox checkbox-success"> <input id="tclifor" value="1" name="tclifor" type="checkbox" onclick="bloqueio2()" /> <label for="checkbox2"> Cli/Fornec </label> </div> </div> <div class="col-lg-4"> <div id="divprincipal" class="newprojeto" style="display:none"> <label><a href="#" data-toggle="modal" data-target="#ModalProjeto"><i class="fa fa-plus-circle"></i> Projeto:</a></label> <select name="projeto" class="form-control chosen-select888" id="projeto" > <option value="">Escolha um projeto</option> <?php $query = "SELECT * FROM cw_projetos order by nome_projetos"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); while($ln = mysqli_fetch_assoc($result)){ echo '<option value="'.$ln['nome_projetos'].'">'.$ln['nome_projetos'].'</option>'; } ?> </select> </div> </div> <div class="col-lg-6"> <div id="divprincipal2" style="display:none"> <label>Cliente / Fornecedor:</label> <select name="clifor" class="form-control chosen-select888" id="clifor" > <option value="">Escolha um cliente / fornecedor</option> <?php $query = "SELECT id_cliente, razao_cliente FROM cw_cliente 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['razao_cliente'].'">'.$ln['razao_cliente'].'</option>'; } ?> <?php $queryf = "SELECT id_fornecedor, razao_fornecedor FROM cw_fornecedor order by razao_fornecedor"; $linkf = DBConnect(); $resultf = @mysqli_query($linkf, $queryf) or die(mysqli_error($linkf)); while($lnf = mysqli_fetch_assoc($resultf)){ echo '<option value="'.$lnf['razao_fornecedor'].'">'.$lnf['razao_fornecedor'].'</option>'; } ?> </select> </div> </div> </div> <div class="form-group login-username col-lg-12"> <div class="col-lg-12"> <label>Histórico: </label> <textarea name="historico" cols="" id="historico" class="form-control" placeholder="Histórico" rows="3" ></textarea> </div> </div> </div><!-- FIM DO BODY DO MODAL --> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary cadLancamento" value="CADASTRAR" type="button"> </div> </div> <!--userForm--> </form> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> <!-- MODAL DE CADASTRO DE USER --> <!-- MODAL DE CONFIGURAÇÃO DE LANÇAMENTOS --> <div id="edit-modallancamentos" 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 FINANCEIROS </h3> </div> <form name="alterarjuros" enctype="multipart/form-data" method="post" action="includes/upconfiglancamento.php"> <div class="modal-body edit-content"> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" value="SALVAR" type="submit"> </div> </div> </form> </div> </div> </div> <!-- MODAL DE CONFIGURAÇÃO DE LANÇAMENTOS --> <!-- 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" > CONFIGURAR RATEIO </h3> </div> <div class="modal-body"> <form role="form" name="ModalRateio"> <div class="form-group login-username col-lg-12"> <div class="col-lg-6 newConta"> <label><a href="#" data-toggle="modal" data-target="#ModalConta"><i class="fa fa-plus-circle"></i> Conta:</a></label> <select name="rconta" class="form-control chosen-select" id="rconta" > <option value="">Escolha uma conta</option> <?php $query = "SELECT * FROM cw_contas order by nome_contas"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); while($ln = mysqli_fetch_assoc($result)){ echo '<option value="'.$ln['nome_contas'].'">'.$ln['nome_contas'].'</option>'; } ?> </select> </div> <div class="col-lg-6 newPlanoConta"> <label><a href="#" data-toggle="modal" data-target="#ModalPConta"><i class="fa fa-plus-circle"></i> Plano de conta:</a></label> <select name="rplano_conta" class="form-control chosen-select" id="rplano_conta" > <option value="">Escolha um plano de conta</option> <?php $query = "SELECT * FROM cw_plano WHERE cabeca_plano='0' ORDER BY 1_plano, 2_plano, 3_plano, 4_plano, 5_plano, 6_plano"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); while($ln = mysqli_fetch_assoc($result)){ ?> <option value="<?php echo $ln['codigo_plano']; ?>"><?php echo $ln['codigo_plano']; ?> - <?php echo $ln['nome_plano']; ?></option> <?php } ?> </select> </div> </div> <div class="form-group login-username col-lg-12"> <div class="col-lg-2"> <div class="radio radio-danger"> <input type="radio" name="rcd" id="rcd" value="1" checked="" > <label for="DEB"> DEB </label> </div> <div class="radio radio-danger"> <input type="radio" name="rcd" id="rcd" value="2" > <label for="CRE"> CRE </label> </div> </div> <div class="col-lg-4"> <label>Valor: </label> <input type="text" name="rvalor" class="form-control" id="rvalor" placeholder="R$" /> </div> <div class="col-lg-6"> <label>Histórico: </label> <input type="text" name="rhistorico" class="form-control" id="rhistorico" placeholder="Histórico" /> </div> </div> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" id="cadRateio" value="CADASTRAR" 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="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 NOVA CONTA </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>Nome da Conta: </label> <input type="text" name="nome" id="nomeconta" class="form-control" placeholder="Nome da Conta" required="" /> </div> </div> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" id="cadnewconta" value="CADASTRAR" type="button"> </div> </div> <!--userForm--> </form> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> <!-- Modal Login start --> <div class="modal signUpContent fade" id="ModalPConta" 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 PLANO CONTA </h3> </div> <div class="modal-body"> <form role="form" name="newpconta"> <div class="form-group login-username col-lg-12"> <div class="col-lg-3"> <label>Código: </label> <input type="text" name="codigo" id="codigoplanodecontas" class="form-control" placeholder="Código" required="" /> </div> <div class="col-lg-7"> <label>Nome da Conta: </label> <input type="text" name="nome" id="nomepcontas" class="form-control" placeholder="Nome da Conta" required="" /> </div> <div class="col-lg-2"> <label> </label> <div class="checkbox checkbox-success"> <input id="clote" name="clote" value="1" type="checkbox" /> <label for="checkbox3"> <strong>C. Lote</strong> </label> </div> </div> <div class="form-group login-username col-lg-12" style="height:350px; overflow-y:scroll; overflow-x:hidden;"> <fieldset style="border:1px solid #CCC; border-radius:5px"> <legend><i class="fa fa-line-chart"></i> Plano de Contas</legend> <div class="table-responsive" id="tablerateio"> <table class="footable table table-stripped" data-page-size="400" data-filter=#filter> <tbody> <?php $query = "SELECT * FROM cw_plano ORDER BY 1_plano, 2_plano, 3_plano, 4_plano, 5_plano, 6_plano"; $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_plano']; ?>" class="deletarplano" ><i class="fa fa-trash"> </i></a> </td> <td><a href="#myModal" data-toggle="modal" id="<?php echo $res['id_plano']; ?>" data-target="#edit-modalplanocontas"><?php echo $res['codigo_plano']; ?></a></td> <td><?php echo $res['nome_plano']; ?></td> <td class="project-actions"> <a href="#myModal" data-toggle="modal" id="<?php echo $res['id_plano']; ?>" data-target="#edit-modalplanocontas" class="btn btn-white btn-sm"><i class="fa fa-folder"></i> Configurar </a> </tr> <?php } ?> </tbody> </table> </div> </fieldset> </div> </div> <div class="form-group login-username col-lg-12"> <div class="col-lg-12 jacadastradocodigoplano"> </div> </div> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary newpconta" id="criarplano" value="CADASTRAR" type="button"> <input name="button" type="submit" disabled="disabled" class="btn btn-block btn-lg btn-primary" id="criarplano2" value="CADASTRAR" /> </div> </div> <!--userForm--> </form> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> <!-- Modal Login start --> <div class="modal signUpContent fade" id="ModalRdoc" 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" > RECEBEU O DOCUMENTO? </h3> </div> <div class="modal-body"> <form role="form" name="newpconta"> <div class="form-group login-username col-lg-12"> <div class="col-lg-10"> <label>Descrição: </label> <input type="text" name="rdocumento" id="rdocumento" class="form-control" placeholder="Digite a descrição" required="" /> </div> <div class="form-group login-username col-lg-12" style="height:350px; overflow-y:scroll; overflow-x:hidden; margin-top:10px"> <fieldset style="border:1px solid #CCC; border-radius:5px"> <legend><i class="fa fa-file-text-o"></i> Recebeu o documento?</legend> <div class="table-responsive" id="tablerateio"> <table class="footable table table-stripped" data-page-size="400" data-filter=#filter> <tbody> <?php $query = "SELECT * FROM cw_rdoc ORDER BY nome_rdoc"; $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_rdoc']; ?>" class="deletardocumento" ><i class="fa fa-trash"> </i></a> </td> <td><?php echo $res['nome_rdoc']; ?></td> <td class="project-actions"> <a href="#myModal" data-toggle="modal" id="<?php echo $res['id_rdoc']; ?>" data-target="#edit-modalrdocumento" class="btn btn-white btn-sm"><i class="fa fa-folder"></i> Configurar </a> </tr> <?php } ?> </tbody> </table> </div> </fieldset> </div> </div> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary newrdoc" value="CADASTRAR" type="button"> </div> </div> <!--userForm--> </form> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> <!-- Modal Login start --> <div class="modal signUpContent fade" id="ModalFpgto" 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" > FORMA DE PAGAMENTO </h3> </div> <div class="modal-body"> <form role="form" name="ModalFpgto"> <div class="form-group login-username col-lg-12"> <div class="col-lg-10"> <label>Forma de pagamento: </label> <input type="text" name="fpagamento" id="fpagamento" class="form-control" placeholder="Digite a forma de pagamento" required="" /> </div> <div class="form-group login-username col-lg-12" style="height:350px; overflow-y:scroll; overflow-x:hidden; margin-top:10px"> <fieldset style="border:1px solid #CCC; border-radius:5px"> <legend><i class="fa fa-money"></i> Forma de Pagamento</legend> <div class="table-responsive" id="tablerateio"> <table class="footable table table-stripped" data-page-size="400" data-filter=#filter> <tbody> <?php $query = "SELECT * FROM cw_fpagamento ORDER BY nome_fpagamento"; $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_fpagamento']; ?>" class="deletarformadepagamento" ><i class="fa fa-trash"> </i></a> </td> <td><?php echo $res['nome_fpagamento']; ?></td> <td class="project-actions"> <a href="#myModal" data-toggle="modal" id="<?php echo $res['id_fpagamento']; ?>" data-target="#edit-modalfpagamento" class="btn btn-white btn-sm"><i class="fa fa-folder"></i> Configurar </a> </tr> <?php } ?> </tbody> </table> </div> </fieldset> </div> </div> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary newfpagto" 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="ModalProjeto" 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 NOVO PROJETO </h3> </div> <div class="modal-body"> <form role="form" name="newProjeto"> <div class="form-group login-username col-lg-12"> <div class="col-lg-12"> <label>Nome do projeto: </label> <input type="text" name="nome" id="nomeprojeto" class="form-control" placeholder="Nome da projeto" required="" /> </div> </div> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" id="cadnewprojeto" value="CADASTRAR" type="button"> </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="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" > RELATÓRIO FINANCEIRO </h3> </div> <div class="modal-body"> <form role="form" name="contasreceber" method="post" action="views/relatorio_financeiro.php" target="_blank"> <div class="form-group login-username col-lg-12"> <div class="col-lg-2"> <div class="radio radio"> <input type="radio" name="dataf" id="radio3" value="1" checked="" > <label> Venc. </label> </div> <div class="radio radio"> <input type="radio" name="dataf" id="radio3" value="2" > <label> Previsão </label> </div> <div class="radio radio"> <input type="radio" name="dataf" id="radio3" value="3" > <label> Baixa </label> </div> </div> <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="Data de Emissão"></i></span><input type="text" class="form-control" id="data_8" name="de" required=""> </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="Data de Vencimento"></i></span><input type="text" class="form-control" id="data_2" name="ate" required=""> </div> </div> </div> <div class="form-group login-username col-lg-4"> <p><strong>SALDO INICIAL</strong>:</p> <div class="checkbox checkbox-success"> <input id="saldoinicial" value="1" name="saldoinicial" type="checkbox" /> <label for="checkbox2"> <i class="fa fa-money"></i> </label> </div> </div> </div> <div class="form-group login-username col-lg-12"> <div class="col-lg-4"> <label>Conta: </label> <?php $query = "SELECT * FROM cw_contas ORDER BY nome_contas"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); ?> <select data-placeholder="TODAS" name="conta[]" class="chosen-select3 form-control" multiple tabindex="2"> <?php while($res = mysqli_fetch_assoc($result)){ ?> <option value="<?php echo $res['nome_contas']; ?>"><?php echo $res['nome_contas']; ?></option> <?php } ?> </select> </div> <div class="col-lg-4"> <label>Plano de Contas: </label> <?php $query = "SELECT * FROM cw_plano ORDER BY codigo_plano, nome_plano"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); ?> <select name="pconta" class="chosen-select3 form-control"> <option value="">TODAS</option> <?php while($res = mysqli_fetch_assoc($result)){ ?> <option value="<?php echo $res['codigo_plano']; ?>"><?php echo $res['codigo_plano']; ?> - <?php echo $res['nome_plano']; ?></option> <?php } ?> </select> </div> <div class="col-lg-4"> <label>Projetos: </label> <?php $query = "SELECT * FROM cw_projetos ORDER BY nome_projetos"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); ?> <select data-placeholder="TODOS" name="projeto[]" class="chosen-select3 form-control" multiple tabindex="2"> <?php while($res = mysqli_fetch_assoc($result)){ ?> <option value="<?php echo $res['nome_projetos']; ?>"><?php echo $res['nome_projetos']; ?></option> <?php } ?> </select> </div> </div> <div class="form-group login-username col-lg-12"> <p><strong>Ordenar por</strong>:</p> <div class="radio radio-inline"> <input type="radio" id="emissao" value="emissao" name="ordem" checked=""> <label for="emissao"> Emissão </label> </div> <div class="radio radio-inline"> <input type="radio" id="vencimento" value="vencimento" name="ordem"> <label for="vencimento"> Vencimento </label> </div> <div class="radio radio-inline"> <input type="radio" id="previsao" value="previsao" name="ordem"> <label for="previsao"> Previsão </label> </div> <div class="radio radio-inline"> <input type="radio" id="baixa" value="baixa" name="ordem"> <label for="baixa"> Baixa </label> </div> <div class="radio radio-inline"> <input type="radio" id="conta" value="conta" name="ordem" > <label for="conta"> Conta </label> </div> <div class="radio radio-inline"> <input type="radio" id="plano" value="plano" name="ordem" > <label for="plano"> Plano de Conta </label> </div> <div class="radio radio-inline"> <input type="radio" id="documento" value="documento" name="ordem"> <label for="documento"> Documento </label> </div> </div> <div class="form-group login-username col-lg-8"> <p><strong>Filtrar por</strong>:</p> <div class="radio radio-inline"> <input type="radio" id="filtro3" value="1" name="filtro" checked=""> <label for="filtro3"> Todos </label> </div> <div class="radio radio-inline"> <input type="radio" id="filtro" value="2" name="filtro" > <label for="filtro"> Aberto </label> </div> <div class="radio radio-inline"> <input type="radio" id="filtro2" value="3" name="filtro" > <label for="filtro2"> Baixado </label> </div> </div> <div class="form-group login-username col-lg-4"> <p><strong>Operação</strong>:</p> <div class="radio radio-inline"> <input type="radio" id="operacao" value="1" name="operacao" checked=""> <label for="operacao"> TODOS </label> </div> <div class="radio radio-inline"> <input type="radio" id="operacao2" value="2" name="operacao"> <label for="operacao2"> DEB </label> </div> <div class="radio radio-inline"> <input type="radio" id="operacao3" value="3" name="operacao" > <label for="operacao3"> CRE </label> </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 --> <div id="edit-modalplanocontas" 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" > CONFIGURAÇÃO DE PLANO DE CONTA </h3> </div> <form name="alterarjuros" enctype="multipart/form-data" method="post" action="includes/upplanos.php"> <div class="modal-body edit-content"> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" value="SALVAR" type="submit"> </div> </div> </form> </div> </div> </div> <div id="edit-modalrdocumento" 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" > RECEBEU O DOCUMENTO? </h3> </div> <form name="alterarjuros" enctype="multipart/form-data" method="post" action="includes/uprdoc.php"> <div class="modal-body edit-content"> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" value="SALVAR" type="submit"> </div> </div> </form> </div> </div> </div> <div id="edit-modalfpagamento" 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" > FORMA DE PAGAMENTO </h3> </div> <form name="alterarjuros" enctype="multipart/form-data" method="post" action="includes/upfpgto.php"> <div class="modal-body edit-content"> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" value="SALVAR" type="submit"> </div> </div> </form> </div> </div> </div> <!-- MODAL DE CONFIGURAÇÃO DE LANÇAMENTOS --> <div id="edit-modalconfig-lancamento" 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 altlancamento" id="altvalordolancamento" value="SALVAR" type="button"> </div> </div> </form> </div> </div> </div> <!-- MODAL DE CONFIGURAÇÃO DE LANÇAMENTOS -->