simulated_annealing_view_jadwal_ruangan.php

<?php

require_once "algoritma_sa.php";
// require_once "../fungsiGlobal.php";

function moveElement(&$array, $a, $b) {
    $out = array_splice($array, $a, 1);
    array_splice($array, $b, 0, $out);
}

$displayError ='display: none';
$displaySuccess = false;
$defineOperasiJantung = 'Operasi Jantung';
$defineNamaRuanganJantung = 'Ruang Operasi Jantung';

$jdJumlahOperasiQuery = $db->fetch_all("tbl_jadwal ORDER BY id_jadwal ASC");

$jdJumlahOperasi = [];
$jumlahRuangOperasi= [];
$idRuangan = [];
foreach ($jdJumlahOperasiQuery as $key => $value) {
    $jdJumlahOperasi[] = $value;
    $jumlahRuangOperasi[$value->id_ruangan][] = $value->id_ruangan;
    $idRuangan[] = $value->id_ruangan;
    $operasi[] = $value->nama_operasi;
    $tanggalMasukArr[] = $value->tanggal_masuk;
    $jamMasukArr[] = $value->jam_masuk;
    $jamKeluarArr[] = $value->jam_keluar;
    $totalHargaArr[] = $value->total_harga;
    $arrayIdRuangan[$value->id_ruangan] = $value->id_ruangan;
    $hasilQuery[] = $value;
}

$hasil = [];
foreach ($hasilQuery as $key => $value) {
    foreach  ($hasilQuery as $key2 => $value2) {
        if ($key == $key2) {
            $hasil[$value->id_ruangan][] = (float) $value2->durasi;
        }
    }
}

sort($hasil);
foreach($hasil as $k => $v) {
    for ($i=0; $i < count($operasi); $i++) {
        if (empty($hasil[$k][$i])) {
            array_push($hasil[$k], 1);
        }
    }
}

// exit(var_dump($hasil));

$jumlahRuangOperasi = count($jumlahRuangOperasi);
$jumlahOperasi = count($jdJumlahOperasi);
$maxIterasi = 100000;
$suhuSekarang = 10000;
$idRuangan = array_values($idRuangan);
$namaRuangan = array_values($namaRuangan);
$operasi = array_values($operasi);

$dari_view_jadwal_ruang = false;
$generate = generate($hasil,
    $jumlahRuangOperasi,
    $jumlahOperasi,
    $operasi,
    $maxIterasi,
    $suhuSekarang,
    $idRuangan, $namaRuangan, $tanggalMasukArr, $jamMasukArr, $jamKeluarArr, $totalHargaArr,
    $dari_view_jadwal_ruang
);
?>

<!-- Hasil Perhitungan -->
        <div class="row">
            <div class="col-xs-12">
                <div class="box">
                    <div class="box-header">
                        <h3 class="box-title">Hasil Proses Optimal</h3>
                    </div>
                    <!-- /.box-header -->
                    <div class="box-body table-responsive">
                        <b>
                            <p>Total Iterasi
                                <?= $generate['totalIterasi'] ?>
                            </p>
                        </b>
                        <table id="dtb_jadwal_ruangan" class="table table-bordered table-striped">
                            <thead>
                                <tr>
                                    <th>No</th>
                                    <th>Nama Ruangan</th>
                                    <th>Nama Operasi</th>
                                    <th>Tanggal Masuk</th>
                                    <th>Jam Masuk</th>
                                    <th>Jam Keluar</th>
                                    <th>Durasi</th>
                                    <th>Total Harga</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php
                                $no = 1;
                                    foreach ($generate['result'] as $key => $dataTableJadwal) {
                                        // if (!empty($dataTableJadwal['tanggal_masuk']) && !empty($dataTableJadwal['jam_masuk']) && !empty($dataTableJadwal['jam_keluar'])) {
                                        ?>

                                    <tr>
                                        <td>
                                            <?php echo $no ?> </td>
                                        <td>
                                            <?php
                                                // query untuk dapat nama ruangan
                                                $servername = "localhost";
                                                $username = "guest";
                                                $password = "guest";
                                                $dbname = 'yarsi_kamal';

                                                $conn = new mysqli($servername, $username, $password, $dbname);
                                                // Check connection
                                                if ($conn->connect_error) {
                                                    die("Connection failed: " . $conn->connect_error);
                                                }

                                                $sql = "SELECT nama_ruangan FROM tbl_ruangan WHERE id_ruangan=" . $dataTableJadwal['id_ruangan'];
                                                $result = $conn->query($sql);

                                                if ($result->num_rows > 0) {
                                                    // output data of each row
                                                    while($row = $result->fetch_assoc()) {
                                                        echo $row['nama_ruangan'];
                                                    }
                                                } else {
                                                    echo "0 results <br>";
                                                }
                                             ?>
                                        </td>
                                        <td>
                                            <?php echo $dataTableJadwal['operasi'] ?> </td>
                                        <td>
                                            <?php
                                            echo $dataTableJadwal['tanggal_masuk']
                                            ?>
                                        </td>
                                        <td>
                                            <?php echo $dataTableJadwal['jam_masuk'] ?> </td>
                                        <td>
                                            <?php echo $dataTableJadwal['jam_keluar'] ?> </td>
                                        <td>
                                            <?php echo $dataTableJadwal['durasi'] ?> menit </td>
                                        <td>
                                            Rp <?php echo number_format($dataTableJadwal['total_harga'], 0); ?>
                                        </td>
                                    </tr>

                                    <?php
                                        $no++;
                                        // }
                                    }
                            ?>
                            </tbody>
                        </table>
                    </div>
                </div>
                <!-- /.box -->
            </div>
        </div>