<!--Muestra el formulario para ingresar un nuevo alquiler-->
  <div class="tab-pane fade" id="v-pills-messages" role="tabpanel" aria-labelledby="v-pills-messages-tab">
      <h1>Ingreso de alquiler</h1>
      <?php
      if(isset($_POST['add'])){
            $dbhost = '127.0.0.1';
            $dbuser = 'root';
            $dbpass= '';
            $db = 'proyectobd2';

          $conn =  mysqli_connect($dbhost, $dbuser, $dbpass);

          if(! $conn){
              die ("Fallo en conexión: " . mysqli_error());

          }

         $db_select = mysqli_select_db($conn, $db);

          if(! $db_select){
              die ("Fallo en conexión a base de datos: " .
                      mysqli_error());

          }

        if(! get_magic_quotes_gpc() ) {
               $ID = addslashes ($_POST['Amo']);
               $MAR = addslashes ($_POST['rate']);
            }else {
               $ID = $_POST['Amo'];
               $MAR = $_POST['rate'];
            }

            $MOD = $_POST['date'];
            $Mon=(calcDate($MOD));
            $usu=$_SESSION['username'];

        $sql = "INSERT INTO test "
                . "(id,ID_user,monthlyAmount,intRate,dueDate , payDate, pastDue,monthsOwed)"
                . "VALUES ('0',$usu,'$ID', '$MAR', '$MOD','NOW()','0','$Mon')";

        $qry = mysqli_query($conn, $sql) or
                die ('Consulta fallida');

                if(! $qry){
                    die(mysqli_error());

                }
                echo"<script>alert('Enviado correctamente')</script>";

                mysqli_close($conn);
                 }
         function calcDate($date){
 $inicio= date('y-m-d');
$fin=$date;
$datetime1=new DateTime($inicio);
$datetime2=new DateTime($fin);
$interval=$datetime2->diff($datetime1);
$interyear=$interval->format("%Y");
if($interyear<1){
$intervalMeses=$interval->format("%m");
}else{
    $intervalMeses=$interval->format("%m")+(12*$interyear);
}
return $intervalMeses;
}

                ?>
      <center>
      <form method="post" action="<?php $_PHP_SELF ?>">
          <div class="form-group mx-sm-3 mb-2">
              <label for="exampleInputEmail1">Pago Mensual</label>
              <input name="Amo" type="text" class=" form-control-sm" maxlength="35" id="exampleInputEmail1" aria-describedby="emailHelp" placeholder="ingrese una cantidad"> <br/>
              <label for="exampleInputEmail1">Tasa de interes mensual</label>
              <input  name="rate" type="text" class="form-control-sm"  maxlength="35" id="exampleInputEmail1" aria-describedby="emailHelp" placeholder="ingrese una tasa de interes"><br/>
              <label for="exampleInputEmail1">Fecha de pago</label>
              <input  name="date" type="date" class="form-control-sm"  maxlength="35" id="exampleInputEmail1" aria-describedby="emailHelp" placeholder="ingrese una cantidad"><br/>


          </div>
          <input name="add" type="submit" class="btn btn-success" id="add" value="Enviar"></input>
          <input class="btn btn-dark" type="reset" value="Reset">


      </form>
      </center>

  </div>

  <div class="tab-pane fade" id="v-pills-settings" role="tabpanel" aria-labelledby="v-pills-settings-tab">
      <h1>Verificar Saldo</h1>
      <?php
      $conn = mysqli_connect('localhost', 'root', "", "proyectobd2")
    or die('No se pudo conectar: ');



$use=$_SESSION['username'];

// Realizar una consul[ta MySQL
$query = "SELECT * FROM test WHERE ID_user= $use";
$result = mysqli_query($conn, $query) or die(' Consulta fallida: ');

// Imprimir los resultados en HTML
echo "<table >\n";
echo "<tr>";
echo "<td>ID</td>";
echo "<td>Usuario</td>";
echo "<td>Monto Mensual</td>";
echo "<td>Tasa de interes</td>";
echo "<td>Fecha de pago</td>";
echo "<td>past due</td>";
echo "<td>Meses atrasados</td>";

echo "</tr>";
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
    echo "\t<tr>\n";

    foreach ($row as $col_value) {
        echo "\t\t<td>$col_value</td>\n";
    }

    echo "\t</tr>\n";
}
echo "</table>\n";

// Liberar resultados
mysqli_free_result($result);

// Cerrar la conexión
mysqli_close($conn);

      ?>
  </div>
</div>
</body>
</html>