Ir para conteúdo
Fórum Script Brasil

jacirmenon

Membros
  • Total de itens

    3
  • Registro em

  • Última visita

Sobre jacirmenon

jacirmenon's Achievements

0

Reputação

  1. jacirmenon

    Compo de porcentagem

    Valeu irmão pela ajuda. Deu certo
  2. jacirmenon

    Compo de porcentagem

    Em Valor eu preciso de um campo para colocar o desconto ex. 5% . e que retorne no valor já correto com o desconto aplicado
  3. Olá a todos. Preciso de uma ajuda no codigo abaixo. Preciso inserir um campo de - % e retorne o valor já calculado na planilha . <?php session_start(); set_time_limit(0); include 'config.php'; include 'functions.php'; if (isset($_GET['acao']) && $_GET['acao'] == 'apagar') { $id = $_GET['id']; mysql_query("DELETE FROM lc_movimento WHERE id='$id'"); echo mysql_error(); header("Location: ?mes=" . $_GET['mes'] . "&ano=" . $_GET['ano'] . "&ok=2"); exit(); } if (isset($_POST['acao']) && $_POST['acao'] == 'editar_cat') { $id = $_POST['id']; $nome = $_POST['nome']; mysql_query("UPDATE lc_cat SET nome='$nome' WHERE id='$id'"); echo mysql_error(); header("Location: ?mes=" . $_GET['mes'] . "&ano=" . $_GET['ano'] . "&cat_ok=3"); exit(); } if (isset($_GET['acao']) && $_GET['acao'] == 'apagar_cat') { $id = $_GET['id']; $qr=mysql_query("SELECT c.id FROM lc_movimento m, lc_cat c WHERE c.id=m.cat && c.id=$id"); if (mysql_num_rows($qr)>0){ header("Location: ?mes=" . $_GET['mes'] . "&ano=" . $_GET['ano'] . "&cat_err=1"); exit(); } mysql_query("DELETE FROM lc_cat WHERE id='$id'"); echo mysql_error(); header("Location: ?mes=" . $_GET['mes'] . "&ano=" . $_GET['ano'] . "&cat_ok=2"); exit(); } if (isset($_POST['acao']) && $_POST['acao'] == 'editar_mov') { $id = $_POST['id']; $dia = $_POST['dia']; $tipo = $_POST['tipo']; $cat = $_POST['cat']; $descricao = $_POST['descricao']; $cliente = $_POST['cliente']; $pagamento = $_POST['pagamento']; $valor = str_replace(",", ".", $_POST['valor']); mysql_query("UPDATE lc_movimento SET dia='$dia', tipo='$tipo', cat='$cat', descricao='$descricao', cliente='$cliente',pagamento='$pagamento', valor='$valor' WHERE id='$id'"); echo mysql_error(); header("Location: ?mes=" . $_GET['mes'] . "&ano=" . $_GET['ano'] . "&ok=3"); exit(); } if (isset($_POST['acao']) && $_POST['acao'] == 2) { $nome = $_POST['nome']; mysql_query("INSERT INTO lc_cat (nome) values ('$nome')"); echo mysql_error(); header("Location: ?mes=" . $_GET['mes'] . "&ano=" . $_GET['ano'] . "&cat_ok=1"); exit(); } if (isset($_POST['acao']) && $_POST['acao'] == 1) { $data = $_POST['data']; $tipo = $_POST['tipo']; $cat = $_POST['cat']; $cliente = $_POST['cliente']; $descricao = $_POST['descricao']; $pagamento = $_POST['pagamento']; $valor = str_replace(",", ".", $_POST['valor']); $t = explode("/", $data); $dia = $t[0]; $mes = $t[1]; $ano = $t[2]; mysql_query("INSERT INTO lc_movimento (dia,mes,ano,tipo,descricao,cliente,pagamento,valor,cat) values ('$dia','$mes','$ano','$tipo','$descricao','$cliente','$pagamento','$valor','$cat')"); echo mysql_error(); header("Location: ?mes=" . $_GET['mes'] . "&ano=" . $_GET['ano'] . "&ok=1"); exit(); } if (isset($_GET['mes'])) $mes_hoje = $_GET['mes']; else $mes_hoje = date('m'); if (isset($_GET['ano'])) $ano_hoje = $_GET['ano']; else $ano_hoje = date('Y'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title id='titulo'>Livro caixa <?php echo $lc_titulo?></title> <meta name="LANGUAGE" content="Portuguese" /> <meta name="AUDIENCE" content="all" /> <meta name="RATING" content="GENERAL" /> <link href="styles.css" rel="stylesheet" type="text/css" /> <link href="login.css" rel="stylesheet" type="text/css" /> <link rel="stylesheet" type="text/css" href="../layout.css" type="text/css" media="screen" /> <link rel="shortcut icon" href="../iptvfwiptv.png" type="image/x-icon" /> <link rel="stylesheet" type="text/css" href="css/reset.css"> <link rel="stylesheet" type="text/css" href="css/bootstrap.css"> <link rel="stylesheet" type="text/css" href="http://fonts.googleapis.com/css?family=Lato:300,400"> <script type="text/javascript" src="http://code.jquery.com/jquery-1.11.1.min.js"></script> <script type="text/javascript" src="js/menuresponsive.js"></script> <script language="javascript" src="scripts.js"></script> </head> <body> <div id="dialog-explorer" title="File Browser" style="display: none;"> <div id="dialogContent"></div> </div><script> </script> <section id="secondary_bar"> <div class="user"> <p><a href="login.php?sair"><u>Sair</u></a></p> </div> </section> <aside id="sidebar" class="column"> <form class="logo"> <img src="https://www.jmiptv.com.br/wp-content/uploads/2015/07/logo-iptvbr.png" width="70%" /> </form> <hr /> <h3 id="LinhasStreaming">Lancamentos</h3> <li class="icn_connection_logs"><a href="javascript:;" onclick="abreFecha('add_movimento')" class="botao"><strong>[+] Adicionar Movimento</strong></a></li> <br> <li class="icn_connection_logs"><a href="javascript:;" onclick="abreFecha('add_cat')" class="botao">[+] Adicionar Categoria</a></li> <br> <h3 id="Principal">Menu de opcoes</h3> <ul> <li class="icn_main_page"><a href="index.php"><h2><span style="color:#FFF">Pagina principal</h2></a></li> <br> <li class="icn_connection_logs"><a href="connection_logs.php"><h2><span style="color:#FFF">link</h2></a></li> </ul> <footer> <hr /> </footer> </aside> <section id="main" class="column"> <article class="module width_full"> </header> <table cellpadding="1" cellspacing="10" width="900" align="center" style="background-color:#033"> <tr> <td colspan="11" style="background-color:#005B5B;"> <h2 style="color:#FFF; margin:5px">Livro Caixa - <?php echo $lc_titulo?></h2> </td> <td colspan="2" align="right" style="background-color:#005B5B;"> <a style="color:#FFF" href="?mes=<?php echo date('m')?>&ano=<?php echo date('Y')?>">Hoje:<strong> <?php echo date('d')?> de <?php echo mostraMes(date('m'))?> de <?php echo date('Y')?></strong></a>&nbsp; </td> </tr> <tr> <td width="70"> <select onchange="location.replace('?mes=<?php echo $mes_hoje?>&ano='+this.value)"> <?php for ($i=2018;$i<=2020;$i++){ ?> <option value="<?php echo $i?>" <?php if ($i==$ano_hoje) echo "selected=selected"?> ><?php echo $i?></option> <?php }?> </select> </td> <?php for ($i=1;$i<=12;$i++){ ?> <td align="center" style="<?php if ($i!=12) echo "border-right:1px solid #FFF;"?> padding-right:5px"> <a href="?mes=<?php echo $i?>&ano=<?php echo $ano_hoje?>" style=" <?php if($mes_hoje==$i){?> color:#033; font-size:16px; font-weight:bold; background-color:#FFF; padding:5px <?php }else{?> color:#FFF; font-size:16px; <?php }?> "> <?php echo mostraMes($i);?> </a> </td> <?php } ?> </tr> </table> <table cellpadding="10" cellspacing="0" width="900" align="center" > <tr> <td colspan="2"> </td> </tr> <tr > <td colspan="3" > <?php if (isset($_GET['cat_err']) && $_GET['cat_err']==1){ ?> <div style="padding:5px; background-color:#FF6; text-align:center; color:#030"> <strong>Esta categoria não pode ser removida, pois há movimentos associados a esta</strong> </div> <?php }?> <?php if (isset($_GET['cat_ok']) && $_GET['cat_ok']==2){ ?> <div style="padding:5px; background-color:#FF6; text-align:center; color:#030"> <strong>Categoria removida com sucesso!</strong> </div> <?php }?> <?php if (isset($_GET['cat_ok']) && $_GET['cat_ok']==1){ ?> <div style="padding:5px; background-color:#FF6; text-align:center; color:#030"> <strong>Categoria Cadastrada com sucesso!</strong> </div> <?php }?> <?php if (isset($_GET['cat_ok']) && $_GET['cat_ok']==3){ ?> <div style="padding:5px; background-color:#FF6; text-align:center; color:#030"> <strong>Categoria alterada com sucesso!</strong> </div> <?php }?> <?php if (isset($_GET['ok']) && $_GET['ok']==1){ ?> <div style="padding:5px; background-color:#FF6; text-align:center; color:#030"> <strong>Movimento Cadastrado com sucesso!</strong> </div> <?php }?> <?php if (isset($_GET['ok']) && $_GET['ok']==2){ ?> <div style="padding:5px; background-color:#900; text-align:center; color:#FFF"> <strong>Movimento removido com sucesso!</strong> </div> <?php }?> <?php if (isset($_GET['ok']) && $_GET['ok']==3){ ?> <div style="padding:5px; background-color:#FF6; text-align:center; color:#030"> <strong>Movimento alterado com sucesso!</strong> </div> <?php }?> <div style=" background-color:#4584b7; padding:10px; border:1px solid #999; margin:5px; display:none" id="add_cat"> <h3>Adicionar Categoria</h3> <table width="100%"> <tr> <td valign="top"> <form method="post" action="?mes=<?php echo $mes_hoje?>&ano=<?php echo $ano_hoje?>"> <input type="hidden" name="acao" value="2" /> Nome: <input type="text" name="nome" size="20" maxlength="50" /> <br /> <br /> <input type="submit" class="input" value="Enviar" /> </form> </td> <td valign="top" align="right"> <b>Editar/Remover Categorias:</b><br/><br/> <?php $qr=mysql_query("SELECT id, nome FROM lc_cat"); while ($row=mysql_fetch_array($qr)){ ?> <div id="editar2_cat_<?php echo $row['id']?>"> <?php echo $row['nome']?> <a style="font-size:15px; color:#ce0100" onclick="return confirm('Tem certeza que deseja remover esta categoria?\nAtenção: Apenas categorias sem movimentos associados poderão ser removidas.')" href="?mes=<?php echo $mes_hoje?>&ano=<?php echo $ano_hoje?>&acao=apagar_cat&id=<?php echo $row['id']?>" title="Remover"> [remover] </a> <a href="javascript:;" style="font-size:15px; color:lightgoldenrodyellow" onclick="document.getElementById('editar_cat_<?php echo $row['id']?>').style.display=''; document.getElementById('editar2_cat_<?php echo $row['id']?>').style.display='none'" title="Editar"> [editar] </a> </div> <div style="display:none" id="editar_cat_<?php echo $row['id']?>"> <form method="post" action="?mes=<?php echo $mes_hoje?>&ano=<?php echo $ano_hoje?>"> <input type="hidden" name="acao" value="editar_cat" /> <input type="hidden" name="id" value="<?php echo $row['id']?>" /> <input type="text" name="nome" value="<?php echo $row['nome']?>" size="20" maxlength="50" /> <input type="submit" class="input" value="Alterar" /> </form> </div> <?php }?> </td> </tr> </table> </div> <div style=" background-color:#4584b7; padding:10px; border:1px solid #999; margin:5px; display:none" id="add_movimento"> <h3>Adicionar Movimento</h3> <?php $qr=mysql_query("SELECT * FROM lc_cat"); if (mysql_num_rows($qr)==0) echo "Adicione ao menos uma categoria"; else{ ?> <form method="post" action="?mes=<?php echo $mes_hoje?>&ano=<?php echo $ano_hoje?>"> <input type="hidden" name="acao" value="1" /> <strong>Data:</strong><br /> <input type="text" name="data" size="11" maxlength="10" value="<?php echo date('d')?>/<?php echo $mes_hoje?>/<?php echo $ano_hoje?>" /> <br /> <br /> <strong>Tipo:<br /></strong> <label for="tipo_receita" style="color:#030"><input type="radio" name="tipo" value="1" id="tipo_receita" /> Receita</label>&nbsp; <label for="tipo_despesa" style="color:#C00"><input type="radio" name="tipo" value="0" id="tipo_despesa" /> Despesa</label> <br /> <br /> <strong>Categoria:</strong><br /> <select name="cat"> <?php while ($row=mysql_fetch_array($qr)){ ?> <option value="<?php echo $row['id']?>"><?php echo $row['nome']?></option> <?php }?> </select> <br /> <br /> <strong>Cliente:</strong><br /> <input type="text" name="cliente" size="50" maxlength="255" /> <br /> <br /> <strong>Descricao:</strong><br /> <input type="text" name="descricao" size="100" maxlength="255" /> <br /> <br /> <strong>Pagamento:</strong><br /> <datalist id="browsers"> <option value="Pag Seguro"> <option value="Mercado Pago"> <option value="Transferencia Caixa"> <option value="Transferencia Bradesco"> <option value="Pagamento mao Jacir"> <option value="Pagamento mao Gilmar"> <option value="Em caixa"> </datalist> <input list="browsers" name="pagamento" size="50" maxlength="255" /> <br /> <br /> <strong>Valor:</strong><br /> R$<input type="text" name="valor" size="8" maxlength="10" /> <br /> <br /> <input type="submit" class="input" value="Enviar" /> </form> <?php }?> </div> </td> </tr> <tr> <td align="left" valign="top" width="450" style="background-color:#D3FFE2"> <?php $qr=mysql_query("SELECT SUM(valor) as total FROM lc_movimento WHERE tipo=1 && mes='$mes_hoje' && ano='$ano_hoje'"); $row=mysql_fetch_array($qr); $entradas=$row['total']; $qr=mysql_query("SELECT SUM(valor) as total FROM lc_movimento WHERE tipo=0 && mes='$mes_hoje' && ano='$ano_hoje'"); $row=mysql_fetch_array($qr); $saidas=$row['total']; $resultado_mes=$entradas-$saidas; ?> <fieldset> <legend><strong>Entradas e Saidas deste mes</strong></legend> <table cellpadding="0" cellspacing="0" width="100%"> <tr> <td><span style="font-size:18px; color:#030">Entradas:</span></td> <td align="right"><span style="font-size:18px; color:#030"><?php echo formata_dinheiro($entradas) ?></span></td> </tr> <tr> <td><span style="font-size:18px; color:#C00">Saidas:</span></td> <td align="right"><span style="font-size:18px; color:#C00"><?php echo formata_dinheiro($saidas) ?></span></td> </tr> <tr> <td colspan="2"> <hr size="1" /> </td> </tr> <tr> <td><strong style="font-size:22px; color:<?php if ($resultado_mes < 0) echo "#C00"; else echo "#030" ?>">Resultado:</strong></td> <td align="right"><strong style="font-size:22px; color:<?php if ($resultado_mes < 0) echo "#C00"; else echo "#030" ?>"><?php echo formata_dinheiro($resultado_mes) ?></strong></td> </tr> </table> </fieldset> </td> <td width="15"> </td> <td align="left" valign="top" width="450" style="background-color:#F1F1F1"> <fieldset> <legend>Balanco Geral</legend> <?php $qr=mysql_query("SELECT SUM(valor) as total FROM lc_movimento WHERE tipo=1 "); $row=mysql_fetch_array($qr); $entradas=$row['total']; $qr=mysql_query("SELECT SUM(valor) as total FROM lc_movimento WHERE tipo=0 "); $row=mysql_fetch_array($qr); $saidas=$row['total']; $resultado_geral=$entradas-$saidas; ?> <table cellpadding="0" cellspacing="0" width="100%"> <tr> <td><span style="font-size:18px; color:#030">Entradas:</span></td> <td align="right"><span style="font-size:18px; color:#030"><?php echo formata_dinheiro($entradas)?></span></td> </tr> <tr> <td><span style="font-size:18px; color:#C00">Saidas:</span></td> <td align="right"><span style="font-size:18px; color:#C00"><?php echo formata_dinheiro($saidas)?></span></td> </tr> <tr> <td colspan="2"> <hr size="1" /> </td> </tr> <tr> <td><strong style="font-size:22px; color:<?php if ($resultado_geral<0) echo "#C00"; else echo "#030"?>">Resultado:</strong></td> <td align="right"><strong style="font-size:22px; color:<?php if ($resultado_geral<0) echo "#C00"; else echo "#030"?>"><?php echo formata_dinheiro($resultado_geral)?></strong></td> </tr> </table> </fieldset> </td> </tr> </table> <br /> <table cellpadding="5" cellspacing="0" width="1010" align="center"> <tr> <td colspan="3"> <div style="float:right; text-align:right"> <form name="form_filtro_cat" method="get" action="" > <input type="hidden" name="mes" value="<?php echo $mes_hoje?>" > <input type="hidden" name="ano" value="<?php echo $ano_hoje?>" > <select name="filtro_cat" onchange="form_filtro_cat.submit()"> <option value="">Tudo</option> <?php $qr=mysql_query("SELECT DISTINCT c.id, c.nome FROM lc_cat c, lc_movimento m WHERE m.cat=c.id && m.mes='$mes_hoje' && m.ano='$ano_hoje'"); while ($row=mysql_fetch_array($qr)){ ?> <option <?php if (isset($_GET['filtro_cat']) && $_GET['filtro_cat']==$row['id'])echo "selected=selected"?> value="<?php echo $row['id']?>"><?php echo $row['nome']?></option> <?php }?> </select> </form> </div> <h2>Movimentos deste Mes <?php echo mostraMes($mes_hoje)?>/<?php echo $ano_hoje?></h2> </td> </tr> <tr style="background-color:green" > <td><h3><center><font color="#FFFFFF">DIA</h3> <td><h3><center><font color="#FFFFFF">CLIENTE</h3></td> <td><h3><font color="#FFFFFF">COMPRA</h3></td> <td><h3><font color="#FFFFFF">DESCRICAO</h3></td> <td><h3><font color="#FFFFFF">PAGAMENTO</h3></td> <td colspan="5" align="center"<h2><font color="#FFFFFF"><strong>VALOR</strong></h2></td> </tr> <?php $filtros=""; if (isset($_GET['filtro_cat'])){ if ($_GET['filtro_cat']!=''){ $filtros="&& cat='".$_GET['filtro_cat']."'"; $qr=mysql_query("SELECT SUM(valor) as total FROM lc_movimento WHERE tipo=1 && mes='$mes_hoje' && ano='$ano_hoje' $filtros"); $row=mysql_fetch_array($qr); $entradas=$row['total']; $qr=mysql_query("SELECT SUM(valor) as total FROM lc_movimento WHERE tipo=0 && mes='$mes_hoje' && ano='$ano_hoje' $filtros"); $row=mysql_fetch_array($qr); $saidas=$row['total']; $resultado_mes=$entradas-$saidas; } } $qr=mysql_query("SELECT * FROM lc_movimento WHERE mes='$mes_hoje' && ano='$ano_hoje' $filtros ORDER By dia"); $cont=0; while ($row=mysql_fetch_array($qr)){ $cont++; $cat=$row['cat']; $qr2=mysql_query("SELECT nome FROM lc_cat WHERE id='$cat'"); $row2=mysql_fetch_array($qr2); $categoria=$row2['nome']; ?> <tr style="background-color:<?php if ($cont%2==0) echo "#F1F1F1"; else echo "#E0E0E0"?>" > <td width="40"><h2><center><?php echo $row['dia']?></center></h2></td> <td width="200"><h2><center><?php echo $row['cliente']?> <a href="?mes=<?php echo $mes_hoje?>&ano=<?php echo $ano_hoje?>&filtro_cat=<?php echo $cat?>"></a><a href="javascript:;" style="font-size:10px; color:red" onclick="document.getElementById('editar_mov_<?php echo $row['id']?>').style.display=''; " title="Editar">[editar]</a></center></h2></td> <td width="100"><strong><?php echo $categoria?></strong></td> <td width="440"><?php echo $row['descricao']?></td> <td width="215"><?php echo $row['pagamento']?></td> <td width="115"><strong style="color:<?php if ($row['tipo']==0) echo "#C00"; else echo "#030"?>"><?php if ($row['tipo']==0) echo "-"; else echo "+"?><?php echo formata_dinheiro($row['valor'])?></strong></td> </tr> <tr style="display:none; background-color:<?php if ($cont%2==0) echo "#F1F1F1"; else echo "#E0E0E0"?>" id="editar_mov_<?php echo $row['id']?>"> <td colspan="6"> <hr/> <form method="post" action="?mes=<?php echo $mes_hoje?>&ano=<?php echo $ano_hoje?>"> <input type="hidden" name="acao" value="editar_mov" /> <input type="hidden" name="id" value="<?php echo $row['id']?>" /> <b>Dia:</b> <input type="text" name="dia" size="3" maxlength="2" value="<?php echo $row['dia']?>" />&nbsp;|&nbsp; <b>Tipo:</b> <label for="tipo_receita<?php echo $row['id']?>" style="color:#030"><input <?php if($row['tipo']==1) echo "checked=checked"?> type="radio" name="tipo" value="1" id="tipo_receita<?php echo $row['id']?>" /> Receita</label>&nbsp; <label for="tipo_despesa<?php echo $row['id']?>" style="color:#C00"><input <?php if($row['tipo']==0) echo "checked=checked"?> type="radio" name="tipo" value="0" id="tipo_despesa<?php echo $row['id']?>" /> Despesa</label>&nbsp;|&nbsp; <b>Categoria:</b> <select name="cat"> <?php $qr2=mysql_query("SELECT * FROM lc_cat"); while ($row2=mysql_fetch_array($qr2)){ ?> <option <?php if($row2['id']==$row['cat']) echo "selected"?> value="<?php echo $row2['id']?>"><?php echo $row2['nome']?></option> <?php }?> <datalist id="browsers"> <option value="Pag Seguro"> <option value="Mercado Pago"> <option value="Transferencia Caixa"> <option value="Transferencia Bradesco"> </datalist> </select>&nbsp;|&nbsp; <br><br><b>Valor:</b> R$<input type="text" value="<?php echo $row['valor']?>" name="valor" size="8" maxlength="10" /> <br/> <br> <b>Cliente:</b> <input type="text" name="cliente" value="<?php echo $row['cliente']?>" size="20" maxlength="255" /> <br/> <br> <b>Pagamento:</b> <input list="browsers" name="pagamento" value="<?php echo $row['pagamento']?>" size="40" maxlength="255" /> <br/> <br> <b>Descricao:</b> <input type="text" name="descricao" value="<?php echo $row['descricao']?>" size="70" maxlength="255" /> <br><br> <input type="submit" class="input" value="Alterar" /> </form> <div style="text-align: right"> <a style="color:#FF0000" onclick="return confirm('Tem certeza que deseja apagar?')" href="?mes=<?php echo $mes_hoje?>&ano=<?php echo $ano_hoje?>&acao=apagar&id=<?php echo $row['id']?>" title="Remover"><strong>[remover]</strong></a> </div> <hr/> </td> </tr> <?php } ?> <tr> <td colspan="6" align="right"> <strong style="font-size:22px; color:#<?php if ($resultado_mes<0) echo "#C00"; else echo "#05FC11"?>"><?php echo formata_dinheiro($resultado_mes)?></strong> </td> </tr> </table> <br /> <br /> </body> </html>
×
×
  • Criar Novo...