<!--<script> $(function(){ var formObject = $('#uploadFlw'); formObject.data('original_serialized_form', formObject.serialize()); $(':submit').click(function() { window.onbeforeunload = null; }); window.onbeforeunload = function() { if (formObject.data('original_serialized_form') !== formObject.serialize()) { return "AS MUDANÇAS DESTE FORMULÁRIO NÃO FORAM SALVAS"; } }; }); $("follows").scrollTop($("follows")[0].scrollHeight); </script>--> <?php $id = $_REQUEST['id']; $query = "SELECT * FROM cw_conta WHERE id_conta='$id'"; $result = DBExecute($query); $res = mysqli_fetch_assoc($result); $querycre = "SELECT SUM(valor_itens_conta) as total FROM cw_itens_conta WHERE conta_itens_conta='$id' AND tipo_itens_conta='1'"; $resultcre = DBExecute($querycre); $rescre = mysqli_fetch_assoc($resultcre); $querydeb = "SELECT SUM(valor_itens_conta) as total FROM cw_itens_conta WHERE conta_itens_conta='$id' AND tipo_itens_conta='2'"; $resultdeb = DBExecute($querydeb); $resdeb = mysqli_fetch_assoc($resultdeb); $saldo = $rescre['total']-$resdeb['total']; ?> <div class="row wrapper border-bottom white-bg page-heading"> <div class="col-sm-4"> <h2><strong>#Conta: <?php echo $res['nome_conta']; ?></strong></h2> <ol class="breadcrumb"> <li> <button data-toggle="modal" data-target="#ModalLogin" type="button" class="btn btn-primary btn-sm">Nova Conta</button> </li> </ol> </div> </div> <div class="row" id="follows"> <form role="form" name="upconta" method="post" id="upconta" enctype="multipart/form-data" action="includes/upconta.php"> <input type="hidden" name="id" id="id" value="<?php echo $res['id_conta']; ?>" /> <input type="hidden" name="chave" id="chave" value="" /> <div class="col-lg-9"> <div class="wrapper wrapper-content animated fadeInUp"> <div class="ibox"> <div class="ibox-content"> <div class="row"> <div class="col-lg-12"> <div class="form-group col-lg-12"> <button type="submit" class="btn btn-primary btn-sm pull-left"> <i class="fa fa-save"> </i> Salvar</button> </div> </div> <div class="col-lg-12"> <div class="form-group col-lg-12"> <div class="col-lg-4"> <label>Tipo de conta: </label> <input type="text" name="tipo" value="<?php echo $res['tipo_conta']; ?>" class="form-control" placeholder="Vendedor" required=""> </div> <div class="col-lg-8"> <label>Nome da conta: </label> <input type="text" name="conta" value="<?php echo $res['nome_conta']; ?>" class="form-control" placeholder="Vendedor" required=""> </div> </div> </div> </div> <dl class="dl-horizontal"> <a href="#" data-toggle="modal" data-target="#ModalTransfer"><dt>Transferência:</dt> <dd><span class="label label-primary"><i class="fa fa-mail-forward"></i></span></dd></a> </dl> <div class="col-lg-12 well" style="padding: 1%; margin-left: 0; border-radius:0px"> <div class="col-lg-2"> <input type="hidden" name="idconta" id="idconta" value="<?php echo $id; ?>" /> <label>Doc: </label> <input type="text" name="doclancamento" id="doclancamento" class="form-control" placeholder="Doc"> </div> <div class="col-lg-5"> <label>Descrição: </label> <input type="text" name="descricaolancamento" id="descricaolancamento" class="form-control" placeholder="Descrição do lançamento"> </div> <div class="col-lg-2"> <label>Operação: </label> <select name="operacaolacamento" id="operacaolacamento" class="chosen-select2 form-control" tabindex="2"> <option value="1">Crédito</option> <option value="2">Débito</option> </select> </div> <div class="col-lg-2"> <label>Valor: </label> <input type="text" name="insertvalorlancamento" id="insertvalorlancamento" class="form-control" placeholder="Valor"> </div> <div class="col-lg-1"> <label>&nbsp;&nbsp;</label> <a class="btn btn-info add-lancamentos" title="Adicionar Produto" href="#" > <i class="fa fa-plus"></i> </a> </div> </div> <div class="row m-t-sm"> <div class="col-lg-12"> <div class="panel blank-panel"> <div class="panel-heading"> <div class="panel-options"> <ul class="nav nav-tabs"> <li class="active"><a href="#tab-1" data-toggle="tab">Lançamentos</a></li> </ul> </div> </div> <div class="panel-body"> <div class="tab-content"> <div class="tab-pane active" id="tab-1"> <div class="full-height-scroll"> <div class="table-responsive" id="listar-lancamentos"> <table class="footable table table-stripped" data-page-size="100" data-filter=#filter> <tr> <td colspan="5" align="right"><strong>SALDO:</strong></td> <td align="right"></td> <td align="right" <?php if($saldo<0){echo"style='color:#F00'";} ?>><strong><?php echo formataValor2($saldo); ?></strong></td> </tr> <tr> <td><strong>Data</strong></td> <td><strong>Documento</strong></td> <td><strong>Descrição</strong></td> <td align="center"><strong>Operação</strong></td> <td><strong>Valor</strong></td> </tr> <tbody> <?php $queryprod = "SELECT * FROM cw_itens_conta WHERE conta_itens_conta='$id' ORDER BY id_itens_conta DESC"; $linkprod = DBConnect(); $resultprod = @mysqli_query($linkprod, $queryprod) or die(mysqli_error($linkprod)); while($resprod = mysqli_fetch_assoc($resultprod)){ ?> <tr> <td><?php echo dbDateToDate2($resprod['data_itens_conta']); ?></td> <td><?php echo $resprod['documento_itens_conta']; ?></td> <td><?php echo $resprod['nome_itens_conta']; ?></td> <td align="center"><?php if($resprod['tipo_itens_conta']=="1"){echo"<strong>C</strong>";}elseif($resprod['tipo_itens_conta']=="2"){echo"<strong>D</strong>";} ?></td> <td align="right" <?php if($resprod['tipo_itens_conta']=="1"){$sin = '';}elseif($resprod['tipo_itens_conta']=="2"){echo"style='color:#F00'"; $sin = '-';} ?>><?php echo formataValor2($resprod['valor_itens_conta']); echo $sin; ?></td> </tr> <?php } ?> </tbody> <tr> <td colspan="5" align="right"><strong>SALDO:</strong></td> <td align="right"></td> <td align="right" <?php if($saldo<0){echo"style='color:#F00'";} ?>><strong><?php echo formataValor2($saldo); ?></strong></td> </tr> </table> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> <div class="col-lg-3"> <div class="wrapper wrapper-content project-manager"> <h4>Oberservação da conta</h4> <textarea class="form-control" name="descricao" rows="8"><?php echo $res['obs_conta']; ?></textarea> </form> </div> </div> </div> <!-- 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"> &times; </button> <h3 class="modal-title-site text-center" > CADASTRO DE CONTAS </h3> </div> <div class="modal-body"> <form role="form" name="logar3" method="post" action="includes/cadcontas.php"> <div class="form-group login-username col-lg-12"> <div class="col-lg-4"> <label>Tipo de conta:</label> <input type="text" class="form-control" name="tipoconta" required=""> </div> <div class="col-lg-8"> <label>Nome da conta:</label> <input type="text" class="form-control" name="nomeconta" required=""> </div> </div> <div class="form-group login-username col-lg-12"> <div class="col-lg-12"> <label>Observação geral: </label> <textarea class="form-control" id="descricao" name="descricao" rows="3"></textarea> </div> </div> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" id="mandarcoisas3" value="CADASTRAR" type="submit"> </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="ModalTransfer" 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"> &times; </button> <h3 class="modal-title-site text-center" > TRANSFERÊNCIA ENTRE CONTAS </h3> </div> <div class="modal-body"> <form role="form" name="logar3" method="post" action="includes/transferencia.php"> <input type="hidden" name="idconta" value="<?php echo $id; ?>" /> <div class="form-group login-username col-lg-12"> <div class="col-lg-8"> <label>Conta destino: </label> <select name="conta" class="form-control chosen-select" id="conta" > <option value="<?php echo $id; ?>">Escolha uma conta</option> <?php $query = "SELECT * FROM cw_conta WHERE id_conta!='$id' order by nome_conta"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); while($ln = mysqli_fetch_assoc($result)){ echo '<option value="'.$ln['id_conta'].'">'.$ln['nome_conta'].'</option>'; } ?> </select> </div> <div class="col-lg-4"> <label>Valor:</label> <input type="text" class="form-control" name="valor" required=""> </div> </div> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" id="mandarcoisas3" value="CADASTRAR" type="submit"> </div> </div> <!--userForm--> </form> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog -->