mxhack3/deudas.php at master · MadDevs/mxhack3 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
<?php
/**
 * Created by PhpStorm.
 * User: enriqueohernandez
 * Date: 10/4/15
 * Time: 4:59 AM
 */

$titulo = "Deudas";
include ("head.php");

include('./includes/conn.php');


$mysqli = con_start();

$smtp = $mysqli->prepare("SELECT id_deudor, id_user, name, description, amount, completed, hidden FROM Deudores WHERE id_user = 1");

$smtp->execute();


$smtp->store_result();

$smtp->bind_result($id_deudor, $id_user, $name, $description, $amount, $completed, $hidden);

while ($smtp->fetch()) {
    $ret[$count][0] =  $id_deudor;
    $ret[$count][1] =  $id_user;
    $ret[$count][2] =  $name;
    $ret[$count][3] =  $description;
    $ret[$count][4] =  $amount;
    $ret[$count][5] =  $completed;
    $ret[$count][6] =  $hidden;

    $count++;
}
//echo "test 3";

$smtp->free_result();
$smtp->close();


//unset($_SESSION["newsession"]);
//session_unset();
// echo&cantidad='$amount'&nombre='$nombre'&descripcion='$description'";


?>

<div class="container">

    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>&nbsp;</p>


    <h1>Nueva Deuda</h1>

    <form action="nuevaDeuda.php">

        <button name="tipo" value="nueva" type="submit" class="btn btn-primary btn-lg btn-block">Nueva Deuda</button>

    </form>


    <h1>Deudas</h1>

    <table class="table table-striped">
        <thead>
        <tr>
            <th>Nombre</th>
            <th>Descripcion</th>
            <th>Cantidad</th>
            <th>Estatus</th>
        </tr>
        </thead>
        <tbody>

         <?php

        // echo "deudasController.php?id_deudor='$id_deudor'&id_usuario='$id_user'&cantidad='$amount'&nombre='$nombre'&descripcion='$description'";


         /*
          *
          *  $ret[$count][0] =  $id_deudor;
    $ret[$count][1] =  $id_user;
    $ret[$count][2] =  $name;
    $ret[$count][3] =  $description;
    $ret[$count][4] =  $amount;
    $ret[$count][5] =  $completed;
    $ret[$count][6] =  $hidden;
          */
         foreach($ret as $personas){
             if($personas[6] == "0") {

                 echo '<tr>'; /////creo!!!
                 echo '<td>' . $personas[2] . '</td>';
                 echo '<td>' . $personas[3] . '</td>';
                 echo '<td>' . $personas[4] . '</td>';
                 echo '<td><form action="deudasController.php"><input type="hidden" name="descripcion" value="'.$personas[3].'" /><input type="hidden" name="nombre" value="'.$personas[2].'" /><input type="hidden" name="cantidad" value="'.$personas[4].'" /><input type="hidden" name="id_usuario" value="'.$personas[1].'" /><input type="hidden" name="id_deudor" value="'.$personas[0].'" /><button name="tipo" value="pagado" type="submit" class="btn btn-primary">Pagado</button> &nbsp; &nbsp;<button name="tipo" value="hide" type="submit" class="btn btn-primary">Eliminar X</button></form></td>';

                 echo '</tr>';
             }
         }

         ?>


        </tbody>
    </table>


</div>
<script type="text/javascript">
      $(document).ready(function() {
        $('#deudas').addClass("active");
      });
</script>

<?php
include ("foot.php")
?>