<?php

// ambil data dari server cloud table room
$url  = "http://localhost/php-crud-api/room";
$data = file_get_contents($url);

?>

<!-- ##################### MS-ACCESS ##################### -->

<?php

$file_db = $_SERVER['DOCUMENT_ROOT'] . "/hoteldieng/ic2000.mdb";
if (!file_exists($file_db)) {
  die("Could not find database");
}

// koneksi ke ms-access
$mdbFilename = "ic2000";
$user        = "";
$password    = "";
$konek       = odbc_connect($mdbFilename, $user, $password);

if (!$konek) {
  die("ODBC not configuration");
}

// menampilkan data
$sql  = "SELECT * FROM room";
$rs   = odbc_exec($konek, $sql);

// ambil data room dari mysql menggunakan json
$user = json_decode($data, TRUE);
// var_dump($user);

// $kosongkan   = "TRUNCATE TABLE room";
$kosongkan   = "DELETE FROM room";
$empty_table = odbc_exec($konek, $kosongkan);

if ($empty_table) {
    echo "<script>alert('data berhasil dihapus')</script>";
} else {
    echo "<script>alert('data gagal dihapus')</script>";
}

foreach ($user as $items):
  // echo "<pre>";
  // print_r($items);
  // echo "</pre>";
  // die();

  $count = count($items['records']);
  for ($i=0; $i<$count; $i++):
    $room_id          = $items['records'][$i][0];
    $building_id      = $items['records'][$i][1];
    $building_name    = $items['records'][$i][2];
    $floor            = $items['records'][$i][3];
    $room_no_id       = $items['records'][$i][4];
    $room_no          = $items['records'][$i][5];
    $card_num         = $items['records'][$i][6];
    $max_num          = $items['records'][$i][7];
    $room_type_code   = $items['records'][$i][8];
    $room_status_code = $items['records'][$i][9];
    $remark           = $items['records'][$i][10];
    $losttime         = $items['records'][$i][11];

    #insert
    $sql_odbc = "INSERT INTO room
    (
      room_id,        /*0*/
      building_id,    /*1*/
      building_name,  /*2*/
      floor,          /*3*/
      room_no_id,     /*4*/
      room_no,        /*5*/
      card_num,       /*6*/
      max_num,        /*7*/
      room_type_code, /*8*/
      room_status_code,/*9*/
      remark,         /*10*/
      losttime        /*11*/
    ) VALUES (
      '$room_id',
      '$building_id',
      '$building_name',
      '$floor',
      '$room_no_id',
      '$room_no',
      '$card_num',
      '$max_num',
      '$room_type_code',
      '$room_status_code',
      '$remark',
      '$losttime'
    )";

    $input_data = odbc_exec($konek, $sql_odbc);
    // echo $losttime."<br>";
  endfor;

  if ($input_data) {
      echo "<script>alert('data berhasil disimpan')</script>";
  } else {
      // echo "<script>alert('data gagal disimpan')</script>";
      echo odbc_error($konek)." ".odbc_errormsg($konek);
  }

endforeach;

?>