Guest User

Untitled

a guest
Dec 12th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.28 KB | None | 0 0
  1. while($csClientes = mysqli_fetch_object($sqlClientes)){
  2. $visualizar .= "<tr>";
  3. $visualizar .= "<td style='font-weight: bold'><i class="fas fa-caret-right"></i> ".$csClientes->NomeCompleto."</td>";
  4. $visualizar .= "<td style='text-align: center;'>R$ ".number_format($csClientes->ValorTotal,2,',','.')."</td>";
  5. $visualizar .= "<td style='text-align: center'><span class='status'><a href='#!' id='btnAlterar' data-id='".$csClientes->IdFinanceiro."' class='btn btn-danger btn-xs'>Pendente</a></span></td>";
  6. $visualizar .= "</tr>";
  7. }
  8.  
  9. <script>
  10. $(document).on('click',"#btnAlterar", function(){
  11. var IdFinanceiro = $(this).attr('data-id');
  12. $.post('sistema/alterar-status.php', {key: IdFinanceiro}, function(retorno){
  13. if(retorno == 1){
  14. $(".status").html("<a href='#!' id='btnAlterar' data-id='<?php echo $csClientes->IdFinanceiro; ?>' class='btn btn-success btn-xs'>Pago</a>");
  15. }else{
  16. $(".status").html("<a href='#!' id='btnAlterar' data-id='<?php echo $csClientes->IdFinanceiro; ?>' class='btn btn-danger btn-xs'>Pendente</a>");
  17. }
  18. });
  19. });
  20. </script>
  21.  
  22. <script>
  23. $(document).on('click',"#btnAlterar", function(){
  24. var IdFinanceiro = $(this).attr('data-id');
  25. $.post('sistema/alterar-status.php', {key: IdFinanceiro}, function(retorno){
  26. if(retorno == 1){
  27. $("#statusPago").css('display','block')");
  28. $("#statusAberto").css('display','none')");
  29. }else{
  30. $("#statusAberto").css('display','block')");
  31. $("#statusPago").css('display','none')");
  32. }
  33. });
  34. });
  35. </script>
  36.  
  37. <td style='text-align: center'>
  38. <span id='statusAberto' style='display: block'><a href='#!' id='btnAlterar' data-id="<?php echo $csClientes->IdFinanceiro; ?>" class='btn btn-danger btn-xs'>Pendente</a></span>
  39. <span id='statusPago' style='display: none'><a href='#!' id='btnAlterar' data-id="<?php echo $csClientes->IdFinanceiro; ?>" class='btn btn-success btn-xs'>Pago</a></span>
  40. </td>
  41.  
  42. $sql = mysqli_query($this->conexao,"UPDATE pagamentos SET StatusPagamento = 'P' WHERE IdPagamento = '".$_POST["key"]."';");
  43. if(mysqli_affected_rows($this->conexao) > 0){
  44. echo '1';
  45. }else{
  46. echo '0';
  47. }
Add Comment
Please, Sign In to add comment