simulated_annealing_view_jadwal_ruangan.php

<?php

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

$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;
}

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

$data = array();
$i = 0;
foreach ($hasilQuery as $key => $value) {
    $j = 0;
    foreach ($hasilQuery as $key2 => $value2) {
        if ($value->id_ruangan > $value2->id_ruangan) {
            $data[$value->id_ruangan][] = floatval($value->durasi);
        } else {
            $data[$value->id_ruangan][] = floatval($value->durasi);
        }

        break;
    }
    $j++;

    if ($j > $jumlahRuangOperasi) {
        $j = 0;
    }
}

$data = array_values($data);

// Hitung biar sama dengan hasil data2 disini
// cuman logiknya baru dapat maksimal 4 jadwal
$hasil = [];
foreach($data as $key => $value) {
    if (count($value) <= count($operasi)) {
        $cc = count($operasi) - count($value);

        if ($key == 0) {
            $hasil[$key] = $value;
            for ($i=0; $i < $cc;$i++) {
                array_push($hasil[$key], 0);
            }
        } elseif ($key == 1) {
            $hasil[$key][] = 0;
            if (!empty($value[0])) {
                $hasil[$key][] = $value[0];
            } else {
                array_push($hasil[$key], 0);
            }
            if (!empty($value[1])) {
                $hasil[$key][] = $value[1];
            } else {
                array_push($hasil[$key], 0);
            }
            if (!empty($value[2])) {
                $hasil[$key][] = $value[2];
            } else {
                array_push($hasil[$key], 0);
            }
            // if (!empty($value[3])) {
            //     $hasil[$key][] = $value[3];
            // } else {
            //     array_push($hasil[$key], 0);
            // }
            // for ($i=0; $i < $cc;$i++) {
            //     array_push($hasil[$key], 0);
            // }
        } elseif ($key == 2 || $key == 3 || $key == 4) {
            $hasil[$key][] = 0;
            $hasil[$key][] = 0;
            $hasil[$key][] = $value[0];
            $hasil[$key][] = $value[1];
            // $hasil[$key][] = $value[2];
            for ($i=2; $i < $cc;$i++) {
                array_push($hasil[$key], 0);
            }
        } else {
            $hasil[$key][] = 0;
            $hasil[$key][] = 0;
            $hasil[$key][] = $value;
        }
    }
}

// var_dump($hasil);

$data2 = array (
    array(7.5, 0, 0, 0),
    array(0, 1.5, 0, 0),
    array(0, 0, 3.5, 2.5),
);
// exit;

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

// var_dump($hasil);
// var_dump($data);
// var_dump($data2);
// exit;
// var_dump($generate);
?>

<!-- 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>