jadwal_ruangan_action.php

<?php
session_start();
include "../../inc/config.php";
require_once "../fungsiGlobal.php";
session_check();

switch ($_GET["act"]) {
  case "in":

    $data = array("id_ruangan"=>$_POST["id_ruangan"],"tanggal_masuk"=>$_POST["tanggal_masuk"],"jam_masuk"=>$_POST["jam_masuk"],"jam_keluar"=>$_POST["jam_keluar"],"id_status"=>$_POST["id_status"], "nama_operasi" => $_POST["nama_operasi"], "durasi" => getTimeDiff($_POST["jam_masuk"], $_POST["jam_keluar"]));

    $checkData = $db->fetch_all_custom("SELECT count(*) as hasil FROM tbl_jadwal
    WHERE id_ruangan=".$_POST["id_ruangan"]."
    AND tanggal_masuk='".$_POST["tanggal_masuk"]."'
    AND
    (
        jam_masuk between '".$_POST['jam_masuk']."' AND '".$_POST['jam_keluar']."' OR
        jam_keluar between '".$_POST['jam_masuk']."' AND '".$_POST['jam_keluar']."'
    )
    ");

    $result;
    foreach ($checkData as $value) {
      $result = $value->hasil;
    }

    if (empty($result)) {
      $in = $db->insert("tbl_jadwal",$data);
      if ($in=true) {
        echo "good";
      } else {
        return false;
      }
    } else {
      return false;
    }

    break;
  case "delete":
    $db->delete("tbl_jadwal","id_jadwal",$_GET["id"]);
    break;
  case "up":
   $data = array("id_ruangan"=>$_POST["id_ruangan"],"tanggal_masuk"=>$_POST["tanggal_masuk"],"jam_masuk"=>$_POST["jam_masuk"],"jam_keluar"=>$_POST["jam_keluar"],"id_status"=>$_POST["id_status"], "nama_operasi" => $_POST["nama_operasi"], "durasi" => getTimeDiff($_POST["jam_masuk"], $_POST["jam_keluar"]));

   $dataOld = array("id_ruangan"=>$_POST["id_ruangan"], "tanggal_masuk" => $_POST["tanggal_masuk"],"jam_masuk"=>$_POST["jam_masuk"],"jam_keluar"=>$_POST["jam_keluar"],"id_status"=>$_POST["id_status"], "nama_operasi" => $_POST["nama_operasi"], "durasi" => getTimeDiff($_POST["jam_masuk"], $_POST["jam_keluar"]));

   $checkData = $db->fetch_all_custom("SELECT count(*) as hasil FROM tbl_jadwal
    WHERE id_ruangan=".$_POST["id_ruangan"]."
    AND tanggal_masuk='".$_POST["tanggal_masuk"]."'
    AND
    (
        jam_masuk between '".$_POST['jam_masuk']."' AND '".$_POST['jam_keluar']."' OR
        jam_keluar between '".$_POST['jam_masuk']."' AND '".$_POST['jam_keluar']."'
    )
    ");

    $result;
    foreach ($checkData as $value) {
      $result = $value->hasil;
    }

    if (empty($result)) {
      $up = $db->update("tbl_jadwal",$data,"id_jadwal",$_POST["id"]);
      if ($up=true) {
        echo "good";
      } else {
        return false;
      }
    } else {
      return false;
    }
    break;
  default:
    # code...
    break;
}

?>