code/post_turno.php

   1 <?php
   2
   3 function handle_request($id, $input)
   4 {
   5     $input = json_decode($input, true);
   6     $appointment = $input['turno'];
   7     $petId = $input['mascota_id'];
   8
   9     $db = new SQLite3('database.sqlite');
  10
  11     $veterinaries = [];
  12
  13     $result = $db->query('SELECT id FROM veterinario');
  14
  15     while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
  16         $veterinaries[] = $row['id'];
  17     }
  18
  19     $result = $db->query("SELECT veterinario_id FROM turno WHERE turno = '{$appointment}'");
  20
  21     while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
  22         $key = array_search($row['veterinario_id'], $veterinaries);
  23         if (false != $key) {
  24             unset($veterinaries[$key]);
  25         }
  26     }
  27
  28     $veterinaryId = array_shift($veterinaries);
  29
  30     $db->exec("INSERT INTO turno (turno, mascota_id, veterinario_id) VALUES ('{$appointment}', '{$petId}', '{$veterinaryId}')");
  31
  32     $db->close();
  33
  34     echo json_encode([
  35         'turno' => $appointment,
  36         'mascota_id' => $petId,
  37     ]);
  38 }