functions.php

<?php
// koneksi ke database
$conn = mysqli_connect("localhost", "root", "", "usecase_psi");

function query($query){
  global $conn;
  $result = mysqli_query($conn, $query);
  $rows = [];
  while ($row = mysqli_fetch_assoc($result)){
    $rows[] = $row;
  }
  return $rows;
}

function listFitur($id_aktor){
    global $conn;
    $sql = "SELECT * FROM `fitur` WHERE id_aktor = '$id_aktor'";

    return query($sql);
}

function detailFitur($id_fitur){
    global $conn;
    $sql = "SELECT * FROM `fitur` INNER JOIN aktor ON fitur.id_aktor = aktor.id_aktor WHERE id_fitur = '$id_fitur'";
// echo $sql;die;
    return query($sql);
}


function listAktor($id_sistem){
    global $conn;
    $sql = "SELECT * FROM `aktor` WHERE id_sistem = '$id_sistem'";

    return query($sql);
}

function listSistem(){
    global $conn;
    $sql = "SELECT * FROM `sistem`";

    return query($sql);
}

function tambahScenario($data, $id_fitur){
    global $conn;

    $namaFitur = htmlspecialchars(trim($data["nama-fitur"]));  
    $deskripsiFitur = htmlspecialchars(trim($data["deskripsi-fitur"]));  
    $kondisiAwal = htmlspecialchars(trim($data["kondisi-awal"]));  
    $kondisiAkhir = htmlspecialchars(trim($data["kondisi-akhir"]));  
    $scenarioNormal = htmlspecialchars(trim($data["scenario-normal"]));  
    $scenarioAlternatif = htmlspecialchars(trim($data["scenario-alternatif"]));  
    $scenarioException = htmlspecialchars(trim($data["scenario-exception"]));  
    
    $arraySN = explode(PHP_EOL,trim($scenarioNormal));
    $arraySA = explode(PHP_EOL,trim($scenarioAlternatif));
    $arraySE = explode(PHP_EOL,trim($scenarioException));

    //tiap baris di textarea scenarionormal divek apakah punya @halaman_view
    foreach ($arraySN as $key => $value) {
      $pecah = explode(" ",$value);

      foreach ($pecah as $key => $value2) {
        if (strpos($value2, '@') !== false) {
          //masukkan @halaman_view ke tabel 'view'         

          $sql = "SELECT * FROM `view` WHERE id_fitur = '$id_fitur'";
          $jumlahRecord = count(query($sql));

          if ($jumlahRecord > 0){
            $sql = "UPDATE `view` SET nama_view = '$value2' WHERE id_fitur = '$id_fitur'";
            mysqli_query($conn, $sql);

            $sql = "SELECT * FROM `view` WHERE id_fitur ='$id_fitur'";                        
            $id_view = query($sql)[0]['id_view'];
            // echo "Update " .$value2." ke tabel view";      
            // echo "<br>";
            
          } else {
            $sql = "INSERT INTO `view` (id_fitur, nama_view) VALUES ('$id_fitur', '$value2')";
            mysqli_query($conn, $sql);
            // echo "Masukkan " .$value2." ke tabel view";      
            // echo "<br>";

            $id_view = mysqli_insert_id($conn);
          }
          
        }    
      }
            
    }    

    foreach ($arraySN as $key => $value) {
      $pecah = explode(" ",$value);

     
      foreach ($pecah as $key2 => $value2) {
        
        
        if (strpos($value2, '#') !== false) {
          //ambil id @view yang barusan dimasukkan
          //masukkan id view dan nama_component ke tabel component_view   
          
          $index_underscore = strpos($value2, '_');
          $tipe_component = substr($value2, 0, $index_underscore);
          
          if($tipe_component == '#form'){
            $tipe_fix = 'Form';
          } elseif ($tipe_component == '#tombol') {
            $tipe_fix = 'Tombol';
          } elseif ($tipe_component == '#tabel') {
            $tipe_fix = 'Tabel';
          } else {
            $tipe_fix = 'Belum ditentukan';
          }          
          

          $sql = "SELECT * FROM `component_view` WHERE nama_component = '$value2' AND id_view = '$id_view'";              
          $jumlahRecord = count(query($sql));
          
          if ($jumlahRecord == 0){
            // echo "Masukkan ".$value2." ke tabel component view";      
            // echo "<br>";

            $sql = "INSERT INTO `component_view` (id_view, nama_component, jenis_component) VALUES ('$id_view', '$value2', '$tipe_fix')";
            mysqli_query($conn, $sql);            
          }
          
        }     
      }
  
    }
    
    //tiap baris di textarea scenarioAlternatif divek apakah punya @halaman_view
    foreach ($arraySA as $key => $value) {
      $pecah = explode(" ",$value);

      foreach ($pecah as $key => $value2) {
        if (strpos($value2, '@') !== false) {
          //masukkan @halaman_view ke tabel 'view'  
          
          

          $sql = "SELECT * FROM `view` WHERE id_fitur = '$id_fitur'";
          $jumlahRecord = count(query($sql));
          
          if ($jumlahRecord > 0){
            $sql = "UPDATE `view` SET nama_view = '$value2' WHERE id_fitur = '$id_fitur'";
            mysqli_query($conn, $sql);

            $sql = "SELECT * FROM `view` WHERE id_fitur ='$id_fitur'";                        
            $id_view = query($sql)[0]['id_view'];
            // echo "Update " .$value2." ke tabel view";      
            // echo "<br>";
            
          } else {
            $sql = "INSERT INTO `view` (id_fitur, nama_view) VALUES ('$id_fitur', '$value2')";
            mysqli_query($conn, $sql);
            // echo "Masukkan " .$value2." ke tabel view";      
            // echo "<br>";

            $id_view = mysqli_insert_id($conn);
          }
          
        }    
      }
            
    }    

    foreach ($arraySA as $key => $value) {
      $pecah = explode(" ",$value);      

      foreach ($pecah as $key2 => $value2) {
        # code...
        if (strpos($value2, '#') !== false) {
          //ambil id @view yang barusan dimasukkan
          //masukkan id view dan nama_component ke tabel component_view   

          
          $index_underscore = strpos($value2, '_');
          $tipe_component = substr($value2, 0, $index_underscore);
          
          if($tipe_component == '#form'){
            $tipe_fix = 'Form';
          } elseif ($tipe_component == '#tombol') {
            $tipe_fix = 'Tombol';
          } elseif ($tipe_component == '#tabel') {
            $tipe_fix = 'Tabel';
          } else {
            $tipe_fix = 'Belum ditentukan';
          }          
          
          $sql = "SELECT * FROM `component_view` WHERE nama_component = '$value2' AND id_view = '$id_view'";
          $jumlahRecord = count(query($sql));
          
          
          if ($jumlahRecord == 0){
            // echo "Masukkan ".$value2." ke tabel component view";      
            // echo "<br>";

            $sql = "INSERT INTO `component_view` (id_view, nama_component, jenis_component) VALUES ('$id_view', '$value2','$tipe_fix')";            
            mysqli_query($conn, $sql);
          }
          
        }     
      }
  
    }
    

    //tiap baris di textarea scenarioException divek apakah punya @halaman_view
    foreach ($arraySE as $key => $value) {
      $pecah = explode(" ",$value);

      foreach ($pecah as $key => $value2) {
        if (strpos($value2, '@') !== false) {
          //masukkan @halaman_view ke tabel 'view'         

          $sql = "SELECT * FROM `view` WHERE id_fitur = '$id_fitur'";
          $jumlahRecord = count(query($sql));

          if ($jumlahRecord > 0){
            $sql = "UPDATE `view` SET nama_view = '$value2' WHERE id_fitur = '$id_fitur'";
            mysqli_query($conn, $sql);

            $sql = "SELECT * FROM `view` WHERE id_fitur ='$id_fitur'";                        
            $id_view = query($sql)[0]['id_view'];
            // echo "Update " .$value2." ke tabel view";      
            // echo "<br>";
            
          } else {
            $sql = "INSERT INTO `view` (id_fitur, nama_view) VALUES ('$id_fitur', '$value2')";
            mysqli_query($conn, $sql);
            // echo "Masukkan " .$value2." ke tabel view";      
            // echo "<br>";

            $id_view = mysqli_insert_id($conn);
          }
          
        }    
      }
            
    }    

    foreach ($arraySE as $key => $value) {
      $pecah = explode(" ",$value);

      foreach ($pecah as $key2 => $value2) {
        # code...
        if (strpos($value2, '#') !== false) {
          //ambil id @view yang barusan dimasukkan
          //masukkan id view dan nama_component ke tabel component_view   

          
          $index_underscore = strpos($value2, '_');
          $tipe_component = substr($value2, 0, $index_underscore);
          
          if($tipe_component == '#form'){
            $tipe_fix = 'Form';
          } elseif ($tipe_component == '#tombol') {
            $tipe_fix = 'Tombol';
          } elseif ($tipe_component == '#tabel') {
            $tipe_fix = 'Tabel';
          } else {
            $tipe_fix = 'Belum ditentukan';
          }          
                    
          $sql = "SELECT * FROM `component_view` WHERE nama_component = '$value2' AND id_view = '$id_view'";
          $jumlahRecord = count(query($sql));
          
          if ($jumlahRecord == 0){
            // echo "Masukkan ".$value2." ke tabel component view";      
            // echo "<br>";

            $sql = "INSERT INTO `component_view` (id_view, nama_component, jenis_component) VALUES ('$id_view', '$value2', '$tipe_fix')";
            
            mysqli_query($conn, $sql);
          }
          
        }     
      }
  
    }
    // die; // sampai sini dulu yaa

    // ----> minta masukkan title untuk view tsb
    // for setiap component_view pada view tsb (select pake id view), isi jenis_component di tabel component_view
    //kalau milih :
    // - tabel pilih berapa kolom, dan tiap kolom namanya apa aja
    // - form typenya apa (text file dsb)
    // - tombol tulisannya apa

    //kalau datanya belum ada tinggal tambah
    // kalau daranya sudah ada di tambah lagi aja gapapa
    //jadi dicek dulu apakah sudah ada view dengan id_fitur yang sedang ingin ditambahkan
    //ingat 1 fitur, cuma ada 1 view


    //di component view dashboard bisa hapus dan ubah jenis component
    // die;
  
    $query = "UPDATE `fitur` SET nama_fitur = '$namaFitur', deskripsi = '$deskripsiFitur', kondisi_awal = '$kondisiAwal', kondisi_akhir = '$kondisiAkhir', scenario_normal = '$scenarioNormal', scenario_alternatif = '$scenarioAlternatif', scenario_exception = '$scenarioException' WHERE id_fitur = '$id_fitur'";
    // echo $query;die;
    
    
  
    return mysqli_query($conn, $query);
  }

  function simpanTitle($data){
    global $conn;
  
    $namaTitle = htmlspecialchars($data["nama-title"]);  
    $idView = htmlspecialchars($data["id-view"]);  

  
    $query = "UPDATE `view` SET title = '$namaTitle' WHERE id_view = $idView";
    mysqli_query($conn, $query);
  
    return mysqli_query($conn, $query);
  }
  

function tambahSistem($data){
  global $conn;

  $namaSistem = htmlspecialchars($data["nama-sistem"]);  

  $query = "INSERT INTO sistem
              VALUES ('','$namaSistem')
              ";
  mysqli_query($conn, $query);

  return mysqli_affected_rows($conn);
}

function ubahSistem($data){
  global $conn;
  $idSistem = $data["id-sistem"];
  $namaSistem = htmlspecialchars($data["nama-sistem"]);

  $query = "UPDATE sistem SET
              nama_sistem = '$namaSistem'        
              WHERE id_sistem = $idSistem";
 

  return  mysqli_query($conn, $query);
}

function ubahAktor($data){
  global $conn;
  $idAktor = $data["id-aktor"];
  $namaAktor = htmlspecialchars($data["nama-aktor"]);

  $query = "UPDATE aktor SET
              nama_aktor = '$namaAktor'        
              WHERE id_aktor = $idAktor";
 

  return  mysqli_query($conn, $query);
}

function ubahComponent($data){
  global $conn;
  // $idAktor = $data["id-aktor"];
  // $namaAktor = htmlspecialchars($data["nama-aktor"]);

  // $query = "UPDATE aktor SET
  //             nama_aktor = '$namaAktor'        
  //             WHERE id_aktor = $idAktor";
 
  // echo "Ubah!";
  
  $idComponent = $_POST['id-component'];
  $namaComponent = $_POST['nama-component'];
  $tipeComponent = $_POST['tipe-component'];
  
  if($tipeComponent == "Belum Ditentukan"){
    echo "<script>alert('Tipe component harus ditentukan!')</script>";
    return false;    
  }
 

  $componentAsli = query("SELECT * FROM `component_view` WHERE id_component = $idComponent");
  $tipeComponentAsli =  $componentAsli[0]['jenis_component'];

  //hapus dulu data info component di tiap tabel ybs, yang lama sebelum update
  if ($tipeComponentAsli == "Form") {
    $sql = "DELETE FROM `info_form` WHERE `info_form`.`id_component_view` = $idComponent";
    mysqli_query($conn, $sql);
  } elseif($tipeComponentAsli == "Tabel"){    
    $sql = "DELETE FROM `info_tabel` WHERE `info_tabel`.`id_component_view` = $idComponent";
    mysqli_query($conn, $sql);
  } elseif($tipeComponentAsli == "Tombol"){
    $sql = "DELETE FROM `info_tombol` WHERE `info_tombol`.`id_component_view` = $idComponent";
    mysqli_query($conn, $sql);
  } 
  

  //update info component nama, jenis untuk tabel component_view
  $query = "UPDATE component_view SET
              nama_component = '$namaComponent',
              jenis_component = '$tipeComponent'
              WHERE id_component = $idComponent";
  
  mysqli_query($conn, $query);

  //insert data info component yang baru sesuai tipe componentnya
  if ($tipeComponent == "Form") {
    $label = $_POST['label-form'];
    $tipe = $_POST['tipe-form'];
    $placeholder = $_POST['placeholder-form'];
    $sql = "INSERT INTO `info_form` (id_component_view, label_form, tipe_form, placeholder_form) VALUES ('$idComponent', '$label', '$tipe', '$placeholder')";
    
    mysqli_query($conn, $sql);

  } elseif($tipeComponent == "Tabel"){
     
    $jumlahKolom = 0;
    foreach ($_POST as $key => $value) {
      // var_dump(strpos($key, '-kolom-'));
      // echo "<br>";
      if(strpos($key, 'nama-kolom-') !== false){
        $jumlahKolom++;        
        $sql = "INSERT INTO `info_tabel` (id_component_view, nama_kolom) VALUES ('$idComponent', '$value')";                
        mysqli_query($conn, $sql);
      }
    }  
    
  } elseif($tipeComponent == "Tombol"){
    $namaTombol = $_POST['nama-tombol'];
    $tipeTombol = $_POST['tipe-tombol'];        
    $sql = "INSERT INTO `info_tombol` (id_component_view, nama_tombol, jenis_tombol) VALUES ('$idComponent', '$namaTombol', '$tipeTombol')";        
    mysqli_query($conn, $sql);
  } else {
    echo "<script>alert('Tipe component harus ditentukan!')</script>";
    return false;
  }
  
  return mysqli_affected_rows($conn);
}

function cekPernahGenerate($id_sistem){
  $cek = query("SELECT * FROM `generate` WHERE id_sistem = '$id_sistem'");

  $jumlahCek = count($cek);

  if ($jumlahCek > 0){
    // return $cek[0]['id_generate'];
    return true;
  }

  return false;
}

function rrmdir($dir) {
  if (is_dir($dir)) {
    $objects = scandir($dir);
    foreach ($objects as $object) {
      if ($object != "." && $object != "..") {
        if (filetype($dir."/".$object) == "dir") 
           rrmdir($dir."/".$object); 
        else unlink   ($dir."/".$object);
      }
    }
    reset($objects);
    rmdir($dir);
  }
 }

function prosesGenerate($id_sistem){  

  global $conn;
  $cek = query("SELECT * FROM `generate` WHERE id_sistem = '$id_sistem'");
  $sistem = query("SELECT * FROM `sistem` WHERE id_sistem = '$id_sistem'");
  $aktor = query("SELECT * FROM `aktor` WHERE id_sistem = '$id_sistem'");

  $namaSistem = $sistem[0]['nama_sistem'];
  
  
  $jumlahCek = count($cek);

  if ($jumlahCek > 0){ //kalau sudah ada datanya hapus dulu, baru buat ulang (generate ulang case )
    rrmdir("hasil/".$id_sistem);
  }
  
  //cari id sistem
  //bikin folder utk sistem ybs, taruh di /hasil/...folder_sistem.../

  //cari aktor tiap sistem
  //bikin folder utk tiap aktor ybs

  //cari fitur tiap aktor  
  //cari view dari tiap fitur
  //cari component view dari tiap fitur
  //concate tiap component view sesuai urutan db
  //bikin file html untuk tiap fitur ybs (isi titlenya, dll)

  //compress folder sistem jadi .zip, taruh di /download/..... .zip
  mkdir("hasil/".$id_sistem);  
  foreach($aktor as $akt){      
    mkdir(getcwd()."/hasil/".$id_sistem."/".$akt['nama_aktor']);

    //cari fitur
    $idAktor = $akt['id_aktor'];
    $namaAktor = $akt['nama_aktor'];
    $fitur = query("SELECT * FROM `fitur` WHERE id_aktor = '$idAktor'");
    foreach($fitur as $fit){
      $idFitur = $fit['id_fitur'];
      $namaFitur = $fit['nama_fitur'];
      $namaFileFitur = strtolower($namaFitur);
      $namaFileFitur = str_replace(" ", "-", $namaFileFitur);
      $namaFileFitur .= '.html';    
      
      $view = query("SELECT * FROM `view` WHERE id_fitur = $idFitur");
      if (count($view) > 0){
        $judulHalaman = $view[0]['title'];
      } else {
        $judulHalaman = '';
      }     

      //buat html
      $fh = fopen("hasil/".$id_sistem."/".$namaAktor."/".$namaFileFitur, 'w'); // or die("error");  
      $bagianAtas = '        
<!DOCTYPE html>
<!--
This is a starter template page. Use this page to start your new project from
scratch. This page gets rid of all links and provides the needed markup only.
-->
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta http-equiv="x-ua-compatible" content="ie=edge">

<title>'.$judulHalaman.'</title>
  
<!-- Theme style -->
<link rel="stylesheet" href="https://dimassatria.tech/psi/adminlte.min.css">  
<!-- Google Font: Source Sans Pro -->
<link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700" rel="stylesheet">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">
</head>


<body class="hold-transition sidebar-mini">
<div class="wrapper">

<!-- Navbar -->
<nav class="main-header navbar navbar-expand navbar-white navbar-light">
  <!-- Left navbar links -->
  <ul class="navbar-nav">
    <li class="nav-item">
      <a class="nav-link" data-widget="pushmenu" href="#"><i class="fa fa-bars" aria-hidden="true"></i></a>
    </li>
  </ul>
  <!-- Right navbar links -->
  <ul class="navbar-nav ml-auto">
          
    <li class="nav-item">
      <a class="nav-link" data-widget="control-sidebar" data-slide="true" href="#"><i
          class="fas fa-th-large"></i></a>
    </li>
  </ul>
</nav>
<!-- /.navbar -->
<!-- Main Sidebar Container -->
<aside class="main-sidebar sidebar-dark-primary elevation-4">
  <!-- Brand Logo -->
  <a href="#" class="brand-link">
    <img src="https://dimassatria.tech/psi/AdminLTELogo.png" alt="AdminLTE Logo" class="brand-image img-circle elevation-3"
         style="opacity: .8">
    <span class="brand-text font-weight-light">'.$namaSistem.'</span>
  </a>

  <!-- Sidebar -->
  <div class="sidebar">
    <!-- Sidebar user panel (optional) -->
    <div class="user-panel mt-3 pb-3 mb-3 d-flex">
      <div class="image">
        <img src="https://dimassatria.tech/psi/user2-160x160.jpg" class="img-circle elevation-2" alt="User Image">
      </div>
      <div class="info">
        <a href="#" class="d-block">'.$namaAktor.'</a>
      </div>
    </div>';

    $bagianSidebar =
    '<!-- Sidebar Menu -->
    <nav class="mt-2">
      <ul class="nav nav-pills nav-sidebar flex-column" data-widget="treeview" role="menu" data-accordion="false">
        <!-- Add icons to the links using the .nav-icon class
             with font-awesome or any other icon font library -->'; 

    foreach($fitur as $fit2){  
      $namaFileFitur2 = strtolower($fit2['nama_fitur']);
      $namaFileFitur2 = str_replace(" ", "-", $namaFileFitur2);
      $namaFileFitur2 .= '.html';   
      if($namaFitur == $fit2['nama_fitur']){
        $bagianSidebar .=
        '<li class="nav-item">
        <a href="'.$namaFileFitur2.'" style="background-color:#E11584" class="nav-link active">              
          <p>'
          .$fit2['nama_fitur'].           
          '</p>
        </a>
      </li>';
      }else {
        $bagianSidebar .=
      '<li class="nav-item">
      <a href="'.$namaFileFitur2.'" class="nav-link">              
        <p>'
        .$fit2['nama_fitur'].           
        '</p>
      </a>
    </li>';
      }
      
    }
       

    $bagianSidebar .=
    '</ul>
    </nav>
    <!-- /.sidebar-menu -->
  </div>
  <!-- /.sidebar -->
</aside>';


$bagianContent = '<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
  <!-- Content Header (Page header) -->
  
<div class="content-header">
  <div class="container-fluid">
      <div class="row mb-2">
          <div class="col-sm-6">
              <h1 class="m-0 text-dark">'.$namaFitur.'</h1>
          </div><!-- /.col -->           
      </div><!-- /.row -->
  </div><!-- /.container-fluid -->
</div>
<!-- /.content-header -->

<!-- Main content -->

<div class="content">
  <div class="container-fluid">

    <div class="row">
        <div class="col-12">
            <dic class="card">
                <div class="card-body">';


                    
                
foreach($view as $vi){
  $idView = $vi['id_view'];
  $component_view = query("SELECT * FROM `component_view` WHERE id_view='$idView'");
  
  foreach($component_view as $comp){
    $idComponent = $comp['id_component'];
    if($comp['jenis_component'] == 'Form' ){
      $info_form = query("SELECT * FROM `info_form` WHERE id_component_view ='$idComponent'");

      if(count($info_form) > 0){
        $labelForm = $info_form[0]['label_form'];
        $tipeForm = $info_form[0]['tipe_form'];
        $placeholderForm = $info_form[0]['placeholder_form'];

        $bagianContent .= '
        <div class="form-group row">
            <label for="nama-fitur" class="col-sm-2 col-form-label">'.$labelForm.'</label>
            <div class="col-sm-10">
                <input placeholder="'.$placeholderForm.'" type="'.$tipeForm.'" class="form-control">
            </div>
        </div>
        ';
      }      
    } elseif($comp['jenis_component'] == 'Tabel'){

      $info_tabel = query("SELECT * FROM `info_tabel` WHERE id_component_view ='$idComponent'");

      $htmlTabel = '
      <table id="example1" class="mt-5 text-center table table-bordered table-striped dataTable" role="grid"
      aria-describedby="example1_info">
      <thead>
          <tr role="row">';                
                      
      if(count($info_tabel) > 0){
        $jumlahKolom = count($info_tabel);          
        foreach($info_tabel as $info){
          $namaKolom = $info['nama_kolom'];
          $htmlTabel .= '
          <th class="sorting_asc" tabindex="0" aria-controls="example1" rowspan="1"
                  colspan="1" aria-sort="ascending"
                  aria-label="Rendering engine: activate to sort column descending"
                  style="width: 5px;">'.$namaKolom.'
          </th>
          ';
        }

        $htmlTabel .= '
        </tr>
        </thead>
        <tbody>';

        $jumlahBaris = 5; //angka terserah
        for ($i=0; $i < $jumlahBaris ; $i++) { 
          $htmlTabel .= '<tr role="row" class="even">';
          for ($j=0; $j < $jumlahKolom ; $j++) {     
            $htmlTabel .= '<td>-</td>';
          }
          $htmlTabel .= '</tr>';
        }
                           
      $htmlTabel .= '
      </tbody>
    </table>
        ';     

        $bagianContent .= $htmlTabel;         
      }      
    
      
    } elseif($comp['jenis_component'] == 'Tombol'){
      $info_tombol = query("SELECT * FROM `info_tombol` WHERE id_component_view ='$idComponent'");
      
      if(count($info_tombol) > 0){
        $namaTombol = $info_tombol[0]['nama_tombol'];
        $jenisTombol = $info_tombol[0]['jenis_tombol'];          

        $bagianContent .= '
        <div class="row">
            <button class="btn btn-'.$jenisTombol.' btn-block">'.$namaTombol.'</button>
        </div>
        ';          
      }      
    }
  }
}
$bagianContent .= '</div>
            </dic>
        </div>
    </div>
        
  </div><!-- /.container-fluid -->
</div>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->

<!-- REQUIRED SCRIPTS -->


<!-- jQuery -->
<script src="https://dimassatria.tech/psi/jquery.min.js"></script>
<!-- Bootstrap 4 -->
<script src="https://dimassatria.tech/psi/bootstrap.bundle.min.js"></script> 
<!-- AdminLTE App -->
<script src="https://dimassatria.tech/psi/adminlte.min.js"></script>

</body>
</html>
';  
$stringData = $bagianAtas;
$stringData .= $bagianSidebar; 
$stringData .= $bagianContent;
      fwrite($fh, $stringData);
      fclose($fh);

      
    }
  }
  $folderToCompress = "hasil/".$id_sistem."/";
  $folderTujuanZip = "download/".uniqid().".zip";
  // var_dump($folderTujuanZip);die;
  if(Zip($folderToCompress, $folderTujuanZip) != false){
    $query = "INSERT INTO `generate` (id_sistem, url_hasil)
    VALUES ('$id_sistem', '$folderTujuanZip')";
        
    return mysqli_query($conn, $query);
  } else {
    return false;
  }

}

function Zip($source, $destination)
{
  // echo $source;
  // var_dump(file_exists($source));die;    
    if (!extension_loaded('zip') || !file_exists($source)) {
        return false;
    }
    
    $zip = new ZipArchive();
    if (!$zip->open($destination, ZIPARCHIVE::CREATE)) {
        return false;
    }

    $source = str_replace('\\', '/', $source);


    if (is_dir($source) === true)
    {
        $files = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($source), RecursiveIteratorIterator::SELF_FIRST);
    
        foreach ($files as $file)
        {
            $file = str_replace('\\', '/', $file);
           

            // Ignore "." and ".." folders
            if( in_array(substr($file, strrpos($file, '/')+1), array('.', '..')) )
                continue;

            // $file = realpath($file);
           

            if (is_dir($file) === true)
            {
                $namaFolder = str_replace($source . '/', '', $file . '/');
                
                $zip->addEmptyDir($namaFolder);
            }
            else if (is_file($file) === true)
            {
              $namaFile = str_replace($source . '/', '', $file);              
              $zip->addFromString($namaFile, file_get_contents($file));
            }
        }
    }
    else if (is_file($source) === true)
    {
        $zip->addFromString(basename($source), file_get_contents($source));
    }

    return $zip->close();
}


function tambahAktor($data, $id_sistem){
    global $conn;
  
    $namaAktor = htmlspecialchars($data["nama-aktor"]);  
  
    $query = "INSERT INTO aktor
                VALUES ('','$namaAktor', '$id_sistem')
                ";
    mysqli_query($conn, $query);
  
    return mysqli_affected_rows($conn);
  }

  function tambahFitur($data, $id_aktor){
    global $conn;
  
    $namaFitur = htmlspecialchars($data["nama-fitur"]);  
  
    $query = "INSERT INTO `fitur` (nama_fitur, id_aktor)
    VALUES ('$namaFitur', $id_aktor)";

    // echo $query;die;
    mysqli_query($conn, $query);
  
    return mysqli_affected_rows($conn);
  }

function upload(){
  $namaFile = $_FILES['gambar']['name'];
  $ukuranFile = $_FILES['gambar']['size'];
  $error = $_FILES['gambar']['error'];
  $tmpName = $_FILES['gambar']['tmp_name'];

  // cek apakah tidak ada gambar yang diupload

  if ($error === 4){
    echo "<script>
            alert('pilih gambar terlebih dahulu!')
          </script>

    ";
    return false;
  }

  // cek apakah yang diupload adalah gambar
  $ekstensiGambarValid = ['jpg', 'jpeg', 'png'];
  $ekstensiGambar = explode('.',$namaFile);
  // dimas.jpg = ['dimas']['jpg']
  $ekstensiGambar = strtolower(end($ekstensiGambar));
  if(!in_array($ekstensiGambar, $ekstensiGambarValid)){
    echo "<script>
            alert('YANG KAMU UPLOAD BUKAN GAMBAR TAUK! :)')
          </script>

    ";
    return false;
  }

  // cek ukuran gambar terlalu besar
  if ($ukuranFile > 1000000){
    echo "<script>
            alert('ukuran file gambar terlalu besar!')
          </script>

    ";
    return false;
  }

  // lolos pengecekan, gambar siap diupload
  // generate nama gambar baru
  $namaFileBaru = uniqid();
  $namaFileBaru .= '.';
  $namaFileBaru .= $ekstensiGambar;
  // var_dump($namaFileBaru); die;
  move_uploaded_file($tmpName, 'img/'. $namaFileBaru);

  return $namaFileBaru;
}

function hapusSistem($id_sistem){
  global $conn;
  mysqli_query($conn, "DELETE FROM sistem WHERE id_sistem = $id_sistem");
  return mysqli_affected_rows($conn);
}

function hapusAktor($id_aktor){
  global $conn;
  mysqli_query($conn, "DELETE FROM aktor WHERE id_aktor = $id_aktor");
  return mysqli_affected_rows($conn);
}

function hapusFitur($id_fitur){
  global $conn;
  mysqli_query($conn, "DELETE FROM fitur WHERE id_fitur = $id_fitur");
  return mysqli_affected_rows($conn);
}

function hapusComponent($id_component){
  global $conn;
  mysqli_query($conn, "DELETE FROM component_view WHERE id_component = $id_component");
  return mysqli_affected_rows($conn);
}

function ubah($data){
  global $conn;
  $id = $data["id"];
  $nrp = htmlspecialchars($data["nrp"]);
  $nama = htmlspecialchars($data["nama"]);
  $email = htmlspecialchars($data["email"]);
  $jurusan = htmlspecialchars($data["jurusan"]);

  $gambarLama = htmlspecialchars($data["gambarLama"]);

  if ($_FILES['gambar']['error'] === 4){
    $gambar = $gambarLama;
    // var_dump($gambar); die;
  } else {
    $gambar = upload();
    // var_dump($gambar); die;
  }
  // $gambar = htmlspecialchars($data["gambar"]);

  $query = "UPDATE mahasiswa SET
              nrp = '$nrp',
              nama = '$nama',
              email = '$email',
              jurusan = '$jurusan',
              gambar = '$gambar'
              WHERE id = $id";
  mysqli_query($conn, $query);

  return mysqli_affected_rows($conn);
}

function cari($keyword){
  $query = "SELECT * FROM mahasiswa
            WHERE
            nama LIKE '%$keyword%' OR
            nrp LIKE '%$keyword%' OR
            email LIKE '%$keyword%' OR
            jurusan LIKE '%$keyword%'
            ";
  return query($query);
}

function registrasi($data){
  global $conn;

  $username = strtolower(stripslashes($data["username"]));
  $password = mysqli_real_escape_string($conn, $data["password"]);
  $password2 = mysqli_real_escape_string($conn, $data["password2"]);

  // cek username sudah ada atau belum
  $result = mysqli_query($conn, "SELECT username FROM users WHERE username = '$username'");

  if (mysqli_fetch_assoc($result)){
    echo "<script>
            alert('username sudah terdaftar!')
          </script>

    ";
    return false;
  }

  // cek konfirmasi password
  if ( $password !== $password2){
    echo "<script>
            alert('password tidak sama!')
          </script>

    ";
    return false;
  }
  // enkripsi password
  $password = password_hash($password, PASSWORD_DEFAULT);
  // var_dump($password);

  // tambahkan userbaru ke database
  mysqli_query($conn, "INSERT INTO users VALUES('', '$username', '$password')");

  return mysqli_affected_rows($conn);

}
?>