Monday, June 19, 2017

UAS Praktikum Pemrograman SQL

Sistem Informasi Akademik Lembaga Kursus - UAS Praktek Pemrograman SQL


1.1 Perancangan Database

Perancangan database yang akan diimplementasikan pada DBMS adalah sebagai berikut:






Gambar  1 Perancangan Database yang Akan Digunakan

Di dalam database terdapat 5 tabel yang saling berelasi. Tabel-tabelnya terdiri dari: Tabel Peserta, Tabel Kursus, Tabel Nilai, Tabel Ruangan, Tabel Jadwal, Tabel Pengajar. 

1.2 Implementasi SQL pada Aplikasi

Dalam Aplikasi Sistem Informasi Akademik Lembaga Kursus terdapat beberapa form yang dapat diakses oleh beberapa hak akses tertentu. Hak Akses Administrasi dapat mengakses seluruh form aplikasi. Hak Akses Pengajar dapat mengakses jadwal dan nilai. Hak Akses Peserta dapat mengakses jadwal dan nilai. Berikut adalah screenshot dari form-form Aplikasi Sistem Informasi Akademik Lembaga Kursus.

1.2.1 Form Login dan Tampilan Awal

 
Gambar  15 Form Login
Source code pada Form Login
<?php
session_start();
include "koneksi.php";
// Notif Error
$Err = "";
if(isset ($_GET ["Err"]) && !empty ($_GET ["Err"])){
switch ($_GET ["Err"]){
case 1:
$Err = "Username dan Password Kosong";
break;
case 2:
$Err = "Username Kosong";
break;
case 3:
$Err = "Password Kosong";
break;
case 4:
$Err = "Password Salah";
break;
case 5:
$Err = "Username dan Password Salah";
break;
case 6:
$Err = "Maaf, Terjadi Kesalahan";
break;
}
}
?>
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <title>SIA Lembaga Kursus</title>
<!-- Icon -->
<link rel="shortcut icon" type="image/icon" href="favicon.jpg">
    <!-- Tell the browser to be responsive to screen width -->
    <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
    <!-- Bootstrap 3.3.5 -->
    <link rel="stylesheet" href="assets/bootstrap/css/bootstrap.min.css">
    <!-- Font Awesome -->
    <link rel="stylesheet" href="assets/fa/css/font-awesome.css">
    <!-- Theme style -->
    <link rel="stylesheet" href="assets/dist/css/AdminLTE.min.css">
    <!-- iCheck -->
    <link rel="stylesheet" href="assets/plugins/iCheck/square/blue.css">
</head>
<body class="hold-transition login-page">
<div class="login-box">
    <div class="login-logo">
     <b>SIA Lembaga Kursus</b>
    </div><!-- /.login-logo -->
    <div class="login-box-body">
      <b><p class="login-box-msg">Login Form</p></b>
      <form action="vl_user.php" method="post">
       <div class="form-group has-feedback">
         <input type="text" name="Username" class="form-control" placeholder="Username" maxlength="30" />
          <span class="form-control-feedback"><i class="fa fa-user"></i></span>
        </div>
        <div class="form-group has-feedback">
          <input type="password" name="Password" class="form-control" placeholder="Password" maxlength="255" />
          <span class="form-control-feedback"><i class="fa fa-unlock"></i></span>
        </div>
        <div class="row">
          <div class="col-xs-8">
          </div><!-- /.col -->
         <div class="col-xs-4">
            <button type="submit" class="btn btn-success">Login<i class="fa fa-sign-in"></i></button>
          </div><!-- /.col -->
        </div>
<br>
<center><font style="color:red;"><?php echo $Err ?></font></center>
</br>
    </form>
  </div><!-- /.login-box-body -->
</div><!-- /.login-box -->
<!-- jQuery 2.1.4 -->
<script src="assets/plugins/jQuery/jQuery-2.1.4.min.js"></script>
<!-- Bootstrap 3.3.5 -->
<script src="assets/bootstrap/js/bootstrap.min.js"></script>
<!-- iCheck -->
<script src="assets/plugins/iCheck/icheck.min.js"></script>
</body>
</html>


Gambar  16 Tampilan Awal Aplikasi
Source code pada  Tampilan Awal Aplikasi

<?php
session_start();
include "../koneksi.php";
include "auth_user.php";
?>
<!DOCTYPE html>
<html>
 <head>
    <meta charset="utf-8">
    <title>SIA Lembaga Kursus</title>
<!-- Icon -->
<link rel="shortcut icon" type="image/icon" href="../favicon.jpg">
    <!-- Tell the browser to be responsive to screen width -->
    <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
    <!-- Bootstrap 3.3.5 -->
    <link rel="stylesheet" href="../assets/bootstrap/css/bootstrap.min.css">
    <!-- Font Awesome -->
    <link rel="stylesheet" href="../assets/fa/css/font-awesome.css">
    <!-- DataTables -->
    <link rel="stylesheet" href="../assets/plugins/datatables/dataTables.bootstrap.css">
    <!-- Theme style -->
    <link rel="stylesheet" href="../assets/dist/css/AdminLTE.min.css">
    <!-- AdminLTE Skins. Choose a skin from the css/skins
         folder instead of downloading all of them to reduce the load. -->
    <link rel="stylesheet" href="../assets/dist/css/skins/_all-skins.min.css">
  </head>
  <body class="sidebar-mini wysihtml5-supported skin-green-light">
    <div class="wrapper">
      <?php
        include "content_header.php";
       ?>
      <!-- Left side column. contains the logo and sidebar -->
      <aside class="main-sidebar">
        <!-- sidebar: style can be found in sidebar.less -->
        <section class="sidebar">
          <!-- Sidebar user panel -->
          <div class="user-panel">
            <div class="pull-left image">
              <p></p>
            </div>
          </div><!-- sidebar menu: : style can be found in sidebar.less -->
          <ul class="sidebar-menu">
              <li class="header"><h4><b><center>Menu Panel</center></b></h4></li>
              <li class="active"><a href="index.php"><i class="fa fa-home"></i><span>Dashboard</span></a></li>
        <li><a href="pengajar.php"><i class="fa fa-user"></i><span>Pengajar</span></a></li>
        <li><a href="peserta.php"><i class="fa fa-users"></i><span>Peserta</span></a></li>
        <li><a href="ruangan.php"><i class="fa fa-columns"></i><span>Ruangan</span></a></li>
        <li><a href="kursus.php"><i class="fa fa-book"></i><span>Kursus</span></a></li>
    <li><a href="jadwal.php"><i class="fa fa-calendar"></i><span>Jadwal</span></a></li>
    <li><a href="user.php"><i class="fa fa-user-circle-o"></i><span>User</span></a></li>
        <li><a href="about.php"><i class="fa fa-info-circle"></i><span>Tentang Aplikasi</span></a></li>
          </ul>
        </section>
        <!-- /.sidebar -->
      </aside>
      <!-- Content Wrapper. Contains page content -->
      <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
          <h1>
            Dashboard
          </h1>
          <ol class="breadcrumb">
            <li><i class="fa fa-home"></i> Dashboard</li>
          </ol>
        </section>
        <!-- Main content -->
        <section class="content">
          <div class="row">
            <div class="col-xs-12">
              <div class="box">
                <div class="box-header">
<h1><center><b>SIA Lembaga Kursus</b></center></h1>
<center><img src="../assets/foto/logo.png" width="225" height="225" /></center>
                </div><!-- /.box-header -->
                <div class="box-body">
                </div><!-- /.box-body -->
              </div><!-- /.box -->
            </div><!-- /.col -->
          </div><!-- /.row -->
        </section><!-- /.content -->
    </div><!-- /.content-wrapper -->
    <?php
include "content_footer.php";
?>
    </div><!-- ./wrapper -->
    <!-- jQuery 2.1.4 -->
    <script src="../assets/plugins/jQuery/jQuery-2.1.4.min.js"></script>
    <!-- Bootstrap 3.3.5 -->
    <script src="../assets/bootstrap/js/bootstrap.min.js"></script>
    <!-- DataTables -->
    <script src="../assets/plugins/datatables/jquery.dataTables.min.js"></script>
    <script src="../assets/plugins/datatables/dataTables.bootstrap.min.js"></script>
    <!-- SlimScroll -->
    <script src="../assets/plugins/slimScroll/jquery.slimscroll.min.js"></script>
    <!-- FastClick -->
    <script src="../assets/plugins/fastclick/fastclick.min.js"></script>
    <!-- AdminLTE App -->
    <script src="../assets/dist/js/app.min.js"></script>
  </body>
</html>

1.2.2 Form Pengajar


Gambar  17 Form Pengajar

Source code Form Pengajar
<?php
session_start();
include "../koneksi.php";
include "auth_user.php";
?>
<!DOCTYPE html>
<html>
 <head>
    <meta charset="utf-8">
    <title>SIA Lembaga Kursus</title>
<!-- Library CSS -->
<?php
include "bundle_css.php";
?>
  </head>
  <body class="sidebar-mini wysihtml5-supported skin-green-light">
    <div class="wrapper">
      <?php
        include 'content_header.php';
       ?>
      <!-- Left side column. contains the logo and sidebar -->
      <aside class="main-sidebar">
        <!-- sidebar: style can be found in sidebar.less -->
        <section class="sidebar">
          <!-- Sidebar user panel -->
          <div class="user-panel">
            <div class="pull-left image">
              <p></p>
            </div>
          </div><!-- sidebar menu: : style can be found in sidebar.less -->
          <ul class="sidebar-menu">
              <li class="header"><h4><b><center>Menu Panel</center></b></h4></li>
              <li class="active"><a href="index.php"><i class="fa fa-home"></i><span>Dashboard</span></a></li>
              <li><a href="pengajar.php"><i class="fa fa-user"></i><span>Pengajar</span></a></li>
              <li><a href="peserta.php"><i class="fa fa-users"></i><span>Peserta</span></a></li>
              <li><a href="ruangan.php"><i class="fa fa-columns"></i><span>Ruangan</span></a></li>
              <li><a href="kursus.php"><i class="fa fa-book"></i><span>Kursus</span></a></li>
              <li><a href="jadwal.php"><i class="fa fa-calendar"></i><span>Jadwal</span></a></li>
              <li><a href="user.php"><i class="fa fa-user-circle-o"></i><span>User</span></a></li>
              <li><a href="about.php"><i class="fa fa-info-circle"></i><span>Tentang Aplikasi</span></a></li>
          </ul>
        </section>
        <!-- /.sidebar -->
      </aside>
      <!-- Content Wrapper. Contains page content -->
      <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
          <h1>
            Pengajar
          </h1>
          <ol class="breadcrumb">
            <li><i class="fa fa-user"></i> Pengajar</li>
          </ol>
        </section>
        <!-- Main content -->
        <section class="content">
          <div class="row">
            <div class="col-xs-12">
              <div class="box">
                <div class="box-header">
                </div><!-- /.box-header -->
                <div class="box-body">
<a href="#"><button class="btn btn-success" type="button" data-target="#ModalAdd" data-toggle="modal"><i class="fa fa-plus"></i> Add</button></a>
        <a style="margin-bottom:10px" href="cetak_dt_pengajar.php" target="_blank" class="btn btn-default pull-right"><span class='glyphicon glyphicon-print'></span>  Cetak</a>
                  <br></br>
  <table id="data" class="table table-bordered table-striped table-scalable">
<?php
include "dt_pengajar.php";
?>
                  </table>
                </div><!-- /.box-body -->
              </div><!-- /.box -->
            </div><!-- /.col -->
          </div><!-- /.row -->
        </section><!-- /.content -->
<!-- Modal Popup Pengajar -->
<div id="ModalAdd" class="modal fade" tabindex="-1" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
<h4 class="modal-title">Tambah Pengajar</h4>
</div>
<div class="modal-body">
<form action="pengajar_add.php" name="modal_popup" enctype="multipart/form-data" method="post">
<div class="form-group">
<label>Kode Pengajar</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-id-card"></i>
</div>
<input name="kd_pengajar" type="text" class="form-control" placeholder="Kode Pengajar"/>
</div>
</div>
<div class="form-group">
<label>Pengajar</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-user"></i>
</div>
<input name="nm_pengajar" type="text" class="form-control" placeholder="Nama Pengajar"/>
</div>
</div>
<div class="form-group">
<label>Tanggal Lahir</label>
<div class="input-group date">
<div class="input-group-addon">
<i class="fa fa-calendar"></i>
</div>
<input id="Tanggal_Lahir" name="tgl_lhr" type="text" class="form-control" placeholder="Tanggal Lahir">
</div>
</div>
<div class="form-group">
<label>Jenis Kelamin</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-user-o"></i>
</div>
<select name="jekel" class="form-control">
<option selected>Pilih Jenis Kelamin</option>
<option value="L">Laki - laki</option>
<option value="P">Perempuan</option>
</select>
</div>
</div>
<div class="form-group">
<label>No. Telp</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-phone"></i>
</div>
<input name="no_telp" type="text" class="form-control" placeholder="No Telpon"/>
</div>
</div>
<div class="form-group">
<label>Alamat</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-flag"></i>
</div>
<input name="alamat" type="text" class="form-control" placeholder="Alamat"/>
</div>
</div>
<div class="modal-footer">
<button class="btn btn-success" type="submit">
Add
</button>
<button type="reset" class="btn btn-danger"  data-dismiss="modal" aria-hidden="true">
Cancel
</button>
</div>
</form>
</div>
</div>
</div>
</div>
<!-- Modal Popup Pengajar Edit -->
<div id="ModalEditPengajar" class="modal fade" tabindex="-1" role="dialog"></div>
<!-- Modal Popup untuk delete-->
<div class="modal fade" id="modal_delete">
<div class="modal-dialog">
<div class="modal-content" style="margin-top:100px;">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
<h4 class="modal-title" style="text-align:center;">Are you sure to delete this information ?</h4>
</div>
<div class="modal-footer" style="margin:0px; border-top:0px; text-align:center;">
<a href="#" class="btn btn-danger" id="delete_link">Delete</a>
<button type="button" class="btn btn-success" data-dismiss="modal">Cancel</button>
</div>
</div>
</div>
</div>
    </div><!-- /.content-wrapper -->
    <?php
include "content_footer.php";
?>
    </div><!-- ./wrapper -->
<!-- Library Scripts -->
<?php
include "bundle_script.php";
?>
  </body>
</html>

Gambar  18 Form Tambah Pengajar

Source code Form Tambah Pengajar
<?php
include "../koneksi.php";
$kd_pengajar  = $_POST["kd_pengajar"];
$nm_pengajar = $_POST["nm_pengajar"];
$tgl_lhr          = $_POST["tgl_lhr"];
$jekel  = $_POST["jekel"];
$alamat  = $_POST["alamat"];
$no_telp  = $_POST["no_telp"];
if ($add = sqlsrv_query($konek, "INSERT INTO pengajar (kd_pengajar, nm_pengajar, tgl_lhr, jekel, no_telp, alamat) VALUES ('$kd_pengajar', '$nm_pengajar', '$tgl_lhr', '$jekel', '$no_telp', '$alamat')")){
header("Location: pengajar.php");
exit();
}
die ("Terdapat kesalahan : ".sqlsrv_errors($konek));
?>

Gambar  19 Form Edit Pengajar

Source code Form Edit Pengajar
<?php
include "../koneksi.php";
$kd_pengajar          = $_POST["kd_pengajar"];
$nm_pengajar  = $_POST["nm_pengajar"];
$tgl_lhr                  = $_POST["tgl_lhr"];
$jekel  = $_POST["jekel"];
$alamat          = $_POST["alamat"];
$no_telp            = $_POST["no_telp"];
if ($edit = sqlsrv_query($konek, "UPDATE pengajar SET nm_pengajar='$nm_pengajar', tgl_lhr='$tgl_lhr', jekel='$jekel', no_telp='$no_telp', alamat='$alamat' WHERE kd_pengajar='$kd_pengajar'")){
header("Location: pengajar.php");
exit();
}
die ("Terdapat kesalahan : ".sqlsrv_errors($konek));
?>

Gambar  20 Form Delete Pengajar

Source code Form Delete Pengajar
<?php
include "../koneksi.php";
$kd_pengajar = $_GET["kd_pengajar"];
if($delete = sqlsrv_query($konek, "DELETE FROM pengajar WHERE kd_pengajar='$kd_pengajar'")){
header("Location: pengajar.php");
exit();
}
die ("Terdapat Kesalahan : ".sqlsrv_errors($konek));
?>


Gambar  21 Laporan Data Pengajar
Source code pada Laporan Data Pengajar
<?php
include '../koneksi.php';
require('../assets/pdf/fpdf.php');
$pdf = new FPDF("L","cm","A4");
$pdf->SetMargins(2,1,1);
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Times','B',11);
$pdf->SetX(4);
$pdf->MultiCell(19.5,0.5,'Laporan Pengajar',0,'L');
$pdf->SetX(4);
$pdf->MultiCell(19.5,0.5,'Sistem Informasi Akademik',0,'L');
$pdf->SetFont('Arial','B',10);
$pdf->SetX(4);
$pdf->MultiCell(19.5,0.5,'Lembaga Kursus',0,'L');
$pdf->SetX(4);
$pdf->SetLineWidth(0.1);
$pdf->Line(1,3.2,28.5,3.2);
$pdf->SetLineWidth(0);
$pdf->ln(1);
$pdf->SetFont('Arial','B',14);
$pdf->Cell(25.5,0.7,"Pengajar",0,10,'C');
$pdf->ln(1);
$pdf->SetFont('Arial','B',10);
$pdf->Cell(5,0.7,"Dicetak pada : ".date("D-d/m/Y"),0,0,'C');
$pdf->ln(1);
$pdf->SetFont('Arial','B',10);
$pdf->Cell(5, 0.8, 'Pengajar', 1, 0, 'C');
$pdf->Cell(5, 0.8, 'Tanggal Lahir', 1, 0, 'C');
$pdf->Cell(4, 0.8, 'Jenis Kelamin', 1, 0, 'C');
$pdf->Cell(4, 0.8, 'No. Telp', 1, 0, 'C');
$pdf->Cell(5, 0.8, 'Alamat', 1, 1, 'C');
$pdf->SetFont('Arial','',10);
$querypengajar = sqlsrv_query ($konek, "SELECT kd_pengajar, nm_pengajar, FORMAT(tgl_lhr, 'dd-MM-yyyy', 'en-US') AS tgl_lhr, jekel, no_telp, alamat FROM pengajar");
if($querypengajar == false){
  die ("Terjadi Kesalahan : ". sqlsrv_errors($konek));
}
while ($pengajar = sqlsrv_fetch_array ($querypengajar)){
$pdf->Cell(5, 0.8, $pengajar['nm_pengajar'] , 1, 0, 'C');
$pdf->Cell(5, 0.8, $pengajar['tgl_lhr'],1, 0, 'C');
$pdf->Cell(4, 0.8, $pengajar['jekel'], 1, 0,'C');
$pdf->Cell(4, 0.8, $pengajar['no_telp'],1, 0, 'C');
$pdf->Cell(5, 0.8, $pengajar['alamat'], 1, 1,'C');
}
$pdf->Output("cetak_pengajar.pdf","I");
?>

1.2.3 Form Peserta

 Gambar  21 Form Peserta

Source code Form Peserta
<?php
session_start();
include "../koneksi.php";
include "auth_user.php";
?>
<!DOCTYPE html>
<html>
 <head>
    <meta charset="utf-8">
    <title>SIA Lembaga Kursus</title>
<!-- Library CSS -->
<?php
include "bundle_css.php";
?>
  </head>
  <body class="sidebar-mini wysihtml5-supported skin-green-light">
    <div class="wrapper">
      <?php
        include 'content_header.php';
       ?>
      <!-- Left side column. contains the logo and sidebar -->
      <aside class="main-sidebar">
        <!-- sidebar: style can be found in sidebar.less -->
        <section class="sidebar">
          <!-- Sidebar user panel -->
          <div class="user-panel">
            <div class="pull-left image">
              <p></p>
            </div>
          </div><!-- sidebar menu: : style can be found in sidebar.less -->
          <ul class="sidebar-menu">
              <li class="header"><h4><b><center>Menu Panel</center></b></h4></li>
              <li class="active"><a href="index.php"><i class="fa fa-home"></i><span>Dashboard</span></a></li>
              <li><a href="pengajar.php"><i class="fa fa-user"></i><span>Pengajar</span></a></li>
              <li><a href="peserta.php"><i class="fa fa-users"></i><span>Peserta</span></a></li>
              <li><a href="ruangan.php"><i class="fa fa-columns"></i><span>Ruangan</span></a></li>
              <li><a href="kursus.php"><i class="fa fa-book"></i><span>Kursus</span></a></li>
              <li><a href="jadwal.php"><i class="fa fa-calendar"></i><span>Jadwal</span></a></li>
              <li><a href="user.php"><i class="fa fa-user-circle-o"></i><span>User</span></a></li>
              <li><a href="about.php"><i class="fa fa-info-circle"></i><span>Tentang Aplikasi</span></a></li>
          </ul>
        </section>
        <!-- /.sidebar -->
      </aside>
      <!-- Content Wrapper. Contains page content -->
      <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
          <h1>
            Peserta
          </h1>
          <ol class="breadcrumb">
            <li><i class="fa fa-users"></i> Peserta</li>
          </ol>
        </section>
        <!-- Main content -->
        <section class="content">
          <div class="row">
            <div class="col-xs-12">
              <div class="box">
                <div class="box-header">
                </div><!-- /.box-header -->
                <div class="box-body">
<a href="#"><button class="btn btn-success" type="button" data-target="#ModalAdd" data-toggle="modal"><i class="fa fa-plus"></i> Add</button></a>
        <a style="margin-bottom:10px" href="cetak_dt_peserta.php" target="_blank" class="btn btn-default pull-right"><span class='glyphicon glyphicon-print'></span>  Cetak</a>
                  <br></br>
  <table id="data" class="table table-bordered table-striped table-scalable">
<?php
include "dt_peserta.php";
?>
                  </table>
                </div><!-- /.box-body -->
              </div><!-- /.box -->
            </div><!-- /.col -->
          </div><!-- /.row -->
        </section><!-- /.content -->
<!-- Modal Popup Dosen -->
<div id="ModalAdd" class="modal fade" tabindex="-1" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
<h4 class="modal-title">Tambah Peserta</h4>
</div>
<div class="modal-body">
<form action="peserta_add.php" name="modal_popup" enctype="multipart/form-data" method="post">
<div class="form-group">
<label>kd_peserta</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-id-card"></i>
</div>
<input name="kd_peserta" type="text" class="form-control" placeholder="Kode Peserta"/>
</div>
</div>
<div class="form-group">
<label>Peserta</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-user"></i>
</div>
<input name="nm_peserta" type="text" class="form-control" placeholder="Nama Peserta"/>
</div>
</div>
<div class="form-group">
<label>Tanggal Lahir</label>
<div class="input-group date">
<div class="input-group-addon">
<i class="fa fa-calendar"></i>
</div>
<input id="Tanggal_Lahir" name="tgl_lhr" type="text" class="form-control" placeholder="Tanggal Lahir">
</div>
</div>
<div class="form-group">
<label>Jenis Kelamin</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-user-o"></i>
</div>
<select name="jekel" class="form-control">
<option selected>Pilih Jenis Kelamin</option>
<option value="L">Laki - laki</option>
<option value="P">Perempuan</option>
</select>
</div>
</div>
<div class="form-group">
<label>No. Telp</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-phone"></i>
</div>
<input name="no_telp" type="text" class="form-control" placeholder="No Telpon"/>
</div>
</div>
<div class="form-group">
<label>Alamat</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-flag"></i>
</div>
<input name="alamat" type="text" class="form-control" placeholder="Alamat"/>
</div>
</div>
<div class="form-group">
<label>Kursus</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-graduation-cap"></i>
</div>
<select name="kd_kursus" class="form-control">
<?php
$querykursus = sqlsrv_query($konek, "SELECT * FROM kursus");
if($querykursus == false){
die ("Terdapat Kesalahan : ". sqlsrv_errors($konek));
}
while($kursus = sqlsrv_fetch_array($querykursus)){
echo "
<option value='$kursus[kd_kursus]'>$kursus[nm_kursus]</option>";
}
?>
</select>
</div>
</div>
<div class="modal-footer">
<button class="btn btn-success" type="submit">
Add
</button>
<button type="reset" class="btn btn-danger"  data-dismiss="modal" aria-hidden="true">
Cancel
</button>
</div>
</form>
</div>
</div>
</div>
</div>
<!-- Modal Popup Dosen Edit -->
<div id="ModalEditPeserta" class="modal fade" tabindex="-1" role="dialog"></div>
<!-- Modal Popup untuk delete-->
<div class="modal fade" id="modal_delete">
<div class="modal-dialog">
<div class="modal-content" style="margin-top:100px;">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
<h4 class="modal-title" style="text-align:center;">Are you sure to delete this information ?</h4>
</div>
<div class="modal-footer" style="margin:0px; border-top:0px; text-align:center;">
<a href="#" class="btn btn-danger" id="delete_link">Delete</a>
<button type="button" class="btn btn-success" data-dismiss="modal">Cancel</button>
</div>
</div>
</div>
</div>
    </div><!-- /.content-wrapper -->
    <?php
include "content_footer.php";
?>
    </div><!-- ./wrapper -->
<!-- Library Scripts -->
<?php
include "bundle_script.php";
?>
  </body>
</html>
Gambar  22 Form Tambah Peserta

Source code Form Tambah Peserta

<?php
include "../koneksi.php";
$kd_peserta  = $_POST["kd_peserta"];
$nm_peserta = $_POST["nm_peserta"];
$tgl_lhr          = $_POST["tgl_lhr"];
$jekel  = $_POST["jekel"];
$alamat  = $_POST["alamat"];
$no_telp  = $_POST["no_telp"];
$kd_kursus          = $_POST["kd_kursus"];
if ($add = sqlsrv_query($konek, "INSERT INTO peserta (kd_peserta, nm_peserta, tgl_lhr, jekel, alamat, no_telp, kd_kursus) VALUES
('$kd_peserta', '$nm_peserta', '$tgl_lhr', '$jekel', '$alamat', '$no_telp', '$kd_kursus')")){
header("Location: peserta.php");
exit();
}
die ("Terdapat kesalahan : ".sqlsrv_errors($konek));
?>


Gambar  23 Form Ubah Peserta

Source code Form Ubah Peserta

<?php
include "../koneksi.php";
$kd_peserta  = $_POST["kd_peserta"];
$nm_peserta = $_POST["nm_peserta"];
$tgl_lhr         = $_POST["tgl_lhr"];
$jekel = $_POST["jekel"];
$no_telp = $_POST["no_telp"];
$alamat = $_POST["alamat"];
$kd_kursus         = $_POST["kd_kursus"];
if($edit = sqlsrv_query($konek, "UPDATE peserta SET nm_peserta='$nm_peserta', tgl_lhr='$tgl_lhr', jekel='$jekel', no_telp='$no_telp', alamat='$alamat', kd_kursus='$kd_kursus' WHERE kd_peserta='$kd_peserta'")){
header("Location: peserta.php");
exit();
}
die("Terdapat Kesalahan : ".sqlsrv_errors($konek));
?>
 Gambar  24 Form Hapus Peserta
Source code Form Hapus Peserta

<?php
include "../koneksi.php";
$kd_peserta = $_GET["kd_peserta"];
if($delete = sqlsrv_query($konek, "DELETE FROM peserta WHERE kd_peserta='$kd_peserta'")){
header("Location: peserta.php");
exit();
}
die ("Terdapat Kesalahan : ".sqlsrv_errors($konek));
?>


Gambar  25 Laporan Data Peserta
Source code Laporan Data Peserta

<?php
include '../koneksi.php';
require('../assets/pdf/fpdf.php');
$pdf = new FPDF("L","cm","A4");
$pdf->SetMargins(2,1,1);
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Times','B',11);
$pdf->SetX(4);
$pdf->MultiCell(19.5,0.5,'Laporan Peserta',0,'L');
$pdf->SetX(4);
$pdf->MultiCell(19.5,0.5,'Sistem Informasi Akademik',0,'L');
$pdf->SetFont('Arial','B',10);
$pdf->SetX(4);
$pdf->MultiCell(19.5,0.5,'Lembaga Kursus',0,'L');
$pdf->SetX(4);
$pdf->SetLineWidth(0.1);
$pdf->Line(1,3.2,28.5,3.2);
$pdf->SetLineWidth(0);
$pdf->ln(1);
$pdf->SetFont('Arial','B',14);
$pdf->Cell(25.5,0.7,"Peserta",0,10,'C');
$pdf->ln(1);
$pdf->SetFont('Arial','B',10);
$pdf->Cell(5,0.7,"Dicetak pada : ".date("D-d/m/Y"),0,0,'C');
$pdf->ln(1);
$pdf->SetFont('Arial','B',10);
$pdf->Cell(2, 0.8, 'Kode', 1, 0, 'C');
$pdf->Cell(5, 0.8, 'Peserta', 1, 0, 'C');
$pdf->Cell(3, 0.8, 'Tanggal Lahir', 1, 0, 'C');
$pdf->Cell(3, 0.8, 'Jenis Kelamin', 1, 0, 'C');
$pdf->Cell(3, 0.8, 'No. Telp', 1, 0, 'C');
$pdf->Cell(5, 0.8, 'Alamat', 1, 0, 'C');
$pdf->Cell(5, 0.8, 'Kursus', 1, 1, 'C');
$pdf->SetFont('Arial','',10);
$querypeserta = sqlsrv_query ($konek, "SELECT kd_peserta, nm_peserta, FORMAT(tgl_lhr, 'dd-MM-yyyy', 'en-US') AS tgl_lhr, jekel, no_telp, alamat, kursus.nm_kursus FROM peserta INNER JOIN kursus ON peserta.kd_kursus = kursus.kd_kursus ORDER BY kd_peserta");
if($querypeserta == false){
  die ("Terjadi Kesalahan : ". sqlsrv_errors($konek));
}
while ($peserta = sqlsrv_fetch_array ($querypeserta)){
  $pdf->Cell(2, 0.8, $peserta['kd_peserta'] , 1, 0, 'C');
$pdf->Cell(5, 0.8, $peserta['nm_peserta'] , 1, 0, 'C');
$pdf->Cell(3, 0.8, $peserta['tgl_lhr'],1, 0, 'C');
$pdf->Cell(3, 0.8, $peserta['jekel'], 1, 0,'C');
$pdf->Cell(3, 0.8, $peserta['no_telp'],1, 0, 'C');
  $pdf->Cell(5, 0.8, $peserta['alamat'],1, 0, 'C');
$pdf->Cell(5, 0.8, $peserta['nm_kursus'], 1, 1,'C');
}
$pdf->Output("cetak_pengajar.pdf","I");
?>

1.2.4 Form Ruangan


Gambar  26 Form Ruangan
Source code Form Ruangan
<?php
session_start();
include "../koneksi.php";
include "auth_user.php";
?>
<!DOCTYPE html>
<html>
 <head>
    <meta charset="utf-8">
    <title>SIA Lembaga Kursus</title>
<!-- Library CSS -->
<?php
include "bundle_css.php";
?>
  </head>
  <body class="sidebar-mini wysihtml5-supported skin-green-light">
    <div class="wrapper">
      <?php
        include 'content_header.php';
       ?>
      <!-- Left side column. contains the logo and sidebar -->
      <aside class="main-sidebar">
        <!-- sidebar: style can be found in sidebar.less -->
        <section class="sidebar">
          <!-- Sidebar user panel -->
          <div class="user-panel">
            <div class="pull-left image">
              <p></p>
            </div>
          </div><!-- sidebar menu: : style can be found in sidebar.less -->
          <ul class="sidebar-menu">
              <li class="header"><h4><b><center>Menu Panel</center></b></h4></li>
              <li class="active"><a href="index.php"><i class="fa fa-home"></i><span>Dashboard</span></a></li>
              <li><a href="pengajar.php"><i class="fa fa-user"></i><span>Pengajar</span></a></li>
              <li><a href="peserta.php"><i class="fa fa-users"></i><span>Peserta</span></a></li>
              <li><a href="ruangan.php"><i class="fa fa-columns"></i><span>Ruangan</span></a></li>
              <li><a href="kursus.php"><i class="fa fa-book"></i><span>Kursus</span></a></li>
              <li><a href="jadwal.php"><i class="fa fa-calendar"></i><span>Jadwal</span></a></li>
              <li><a href="user.php"><i class="fa fa-user-circle-o"></i><span>User</span></a></li>
              <li><a href="about.php"><i class="fa fa-info-circle"></i><span>Tentang Aplikasi</span></a></li>
          </ul>
        </section>
        <!-- /.sidebar -->
      </aside>
      <!-- Content Wrapper. Contains page content -->
      <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
          <h1>
            Ruangan
          </h1>
          <ol class="breadcrumb">
            <li><i class="fa fa-columns"></i> Ruangan</li>
          </ol>
        </section>
        <!-- Main content -->
        <section class="content">
          <div class="row">
            <div class="col-xs-12">
              <div class="box">
                <div class="box-header">
                </div><!-- /.box-header -->
                <div class="box-body">
<a href="#"><button class="btn btn-success" type="button" data-target="#ModalAdd" data-toggle="modal"><i class="fa fa-plus"></i> Add</button></a>
        <a style="margin-bottom:10px" href="cetak_dt_ruangan.php" target="_blank" class="btn btn-default pull-right"><span class='glyphicon glyphicon-print'></span>  Cetak</a>
                  <br></br>
  <table id="data" class="table table-bordered table-striped table-scalable">
<?php
include "dt_ruangan.php";
?>
                  </table>
                </div><!-- /.box-body -->
              </div><!-- /.box -->
            </div><!-- /.col -->
          </div><!-- /.row -->
        </section><!-- /.content -->
<!-- Modal Popup Dosen -->
<div id="ModalAdd" class="modal fade" tabindex="-1" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
<h4 class="modal-title">Tambah Ruangan</h4>
</div>
<div class="modal-body">
<form action="ruangan_add.php" name="modal_popup" enctype="multipart/form-data" method="post">
<div class="form-group">
<label>Kode Ruangan</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-columns"></i>
</div>
<input name="kd_ruangan" type="text" class="form-control" placeholder="Kode Ruangan"/>
</div>
</div>
<div class="form-group">
<label>Ruangan</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-columns"></i>
</div>
<input name="nm_ruangan" type="text" class="form-control" placeholder="Ruangan"/>
</div>
</div>
<div class="modal-footer">
<button class="btn btn-success" type="submit">
Add
</button>
<button type="reset" class="btn btn-danger"  data-dismiss="modal" aria-hidden="true">
Cancel
</button>
</div>
</form>
</div>
</div>
</div>
</div>
<!-- Modal Popup Dosen Edit -->
<div id="ModalEditRuangan" class="modal fade" tabindex="-1" role="dialog"></div>
<!-- Modal Popup untuk delete-->
<div class="modal fade" id="modal_delete">
<div class="modal-dialog">
<div class="modal-content" style="margin-top:100px;">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
<h4 class="modal-title" style="text-align:center;">Are you sure to delete this information ?</h4>
</div>
<div class="modal-footer" style="margin:0px; border-top:0px; text-align:center;">
<a href="#" class="btn btn-danger" id="delete_link">Delete</a>
<button type="button" class="btn btn-success" data-dismiss="modal">Cancel</button>
</div>
</div>
</div>
</div>
    </div><!-- /.content-wrapper -->
<?php
include "content_footer.php";
?>
    </div><!-- ./wrapper -->
<!-- Library Scripts -->
<?php
include "bundle_script.php";
?>
  </body>
</html>


 Gambar  27 Form Tambah Ruangan

Source code Form Tambah Ruangan

<?php
include "../koneksi.php";
$kd_ruangan = $_POST["kd_ruangan"];
$nm_ruangan = $_POST["nm_ruangan"];
if($add = sqlsrv_query($konek, "INSERT INTO ruangan (kd_ruangan, nm_ruangan) VALUES ('$kd_ruangan', '$nm_ruangan')")){
header("Location: ruangan.php");
exit();
}
die ("Terdapat Kesalahan : ". sqlsrv_errors($konek));
?>

Gambar  28 Form Edit Ruangan

Source code Form Edit Ruangan

<?php
include "../koneksi.php";
$kd_ruangan = $_POST["kd_ruangan"];
$nm_ruangan = $_POST["nm_ruangan"];
if ($edit = sqlsrv_query($konek, "UPDATE ruangan SET nm_ruangan='$nm_ruangan' WHERE kd_ruangan='$kd_ruangan'")){
header("Location: ruangan.php");
exit();
}
die ("Terdapat Kesalahan : ". sqlsrv_errors($konek));
?>

Gambar  29 Form Hapus Ruangan
Source code Form Hapus Ruangan
<?php
include "../koneksi.php";
$kd_ruangan = $_GET["kd_ruangan"];
if($delete = sqlsrv_query($konek, "DELETE FROM ruangan WHERE kd_ruangan='$kd_ruangan'")){
header("Location: ruangan.php");
exit();
}
die("Terdapat Kesalahan : ". sqlsrv_errors($konek));
?>


Gambar  30 Laporan Data Ruangan
Source code Laporan Data Ruangan

<?php
include '../koneksi.php';
require('../assets/pdf/fpdf.php');
$pdf = new FPDF("P","cm","A4");
$pdf->SetMargins(2,1,1);
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Times','B',11);
$pdf->SetX(4);
$pdf->MultiCell(19.5,0.5,'Laporan Ruangan',0,'L');
$pdf->SetX(4);
$pdf->MultiCell(19.5,0.5,'Sistem Informasi Akademik',0,'L');
$pdf->SetFont('Arial','B',10);
$pdf->SetX(4);
$pdf->MultiCell(19.5,0.5,'Lembaga Kursus',0,'L');
$pdf->SetX(4);
$pdf->SetLineWidth(0.1);
$pdf->Line(1,3.2,20,3.2);
$pdf->SetLineWidth(0);
$pdf->ln(1);
$pdf->SetFont('Arial','B',14);
$pdf->Cell(18,0.7,"Ruangan",0,10,'C');
$pdf->ln(1);
$pdf->SetFont('Arial','B',10);
$pdf->Cell(5,0.7,"Dicetak pada : ".date("D-d/m/Y"),0,0,'C');
$pdf->ln(1);
$pdf->SetFont('Arial','B',10);
$pdf->Cell(2, 0.8, 'Kode', 1, 0, 'C');
$pdf->Cell(5, 0.8, 'Ruangan', 1, 1, 'C');
$pdf->SetFont('Arial','',10);
$queryruangan = sqlsrv_query ($konek, "SELECT * FROM ruangan");
if($queryruangan == false){
  die ("Terjadi Kesalahan : ". sqlsrv_errors($konek));
}
while ($ruangan = sqlsrv_fetch_array ($queryruangan)){
  $pdf->Cell(2, 0.8, $ruangan['kd_ruangan'] , 1, 0, 'C');
$pdf->Cell(5, 0.8, $ruangan['nm_ruangan'] , 1, 1, 'C');
}
$pdf->Output("cetak_ruangan.pdf","I");
?>

1.2.5 Form Kursus


Gambar  31 Form Kursus
Source code Form Kursus

<?php
session_start();
include "../koneksi.php";
include "auth_user.php";
?>
<!DOCTYPE html>
<html>
 <head>
    <meta charset="utf-8">
    <title>SIA Lembaga Kursus</title>
<!-- Library CSS -->
<?php
include "bundle_css.php";
?>
  </head>
  <body class="sidebar-mini wysihtml5-supported skin-green-light">
    <div class="wrapper">
      <?php
        include 'content_header.php';
       ?>
      <!-- Left side column. contains the logo and sidebar -->
      <aside class="main-sidebar">
        <!-- sidebar: style can be found in sidebar.less -->
        <section class="sidebar">
          <!-- Sidebar user panel -->
          <div class="user-panel">
            <div class="pull-left image">
              <p></p>
            </div>
          </div><!-- sidebar menu: : style can be found in sidebar.less -->
          <ul class="sidebar-menu">
              <li class="header"><h4><b><center>Menu Panel</center></b></h4></li>
              <li class="active"><a href="index.php"><i class="fa fa-home"></i><span>Dashboard</span></a></li>
              <li><a href="pengajar.php"><i class="fa fa-user"></i><span>Pengajar</span></a></li>
              <li><a href="peserta.php"><i class="fa fa-users"></i><span>Peserta</span></a></li>
              <li><a href="ruangan.php"><i class="fa fa-columns"></i><span>Ruangan</span></a></li>
              <li><a href="kursus.php"><i class="fa fa-book"></i><span>Kursus</span></a></li>
              <li><a href="jadwal.php"><i class="fa fa-calendar"></i><span>Jadwal</span></a></li>
              <li><a href="user.php"><i class="fa fa-user-circle-o"></i><span>User</span></a></li>
              <li><a href="about.php"><i class="fa fa-info-circle"></i><span>Tentang Aplikasi</span></a></li>
          </ul>
        </section>
        <!-- /.sidebar -->
      </aside>
      <!-- Content Wrapper. Contains page content -->
      <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
          <h1>
            Kursus
          </h1>
          <ol class="breadcrumb">
            <li><i class="fa fa-book"></i> Kursus</li>
          </ol>
        </section>
        <!-- Main content -->
        <section class="content">
          <div class="row">
            <div class="col-xs-12">
              <div class="box">
                <div class="box-header">
                </div><!-- /.box-header -->
                <div class="box-body">
<a href="#"><button class="btn btn-success" type="button" data-target="#ModalAdd" data-toggle="modal"><i class="fa fa-plus"></i> Add</button></a>
        <a style="margin-bottom:10px" href="cetak_dt_kursus.php" target="_blank" class="btn btn-default pull-right"><span class='glyphicon glyphicon-print'></span>  Cetak</a>
                  <br></br>
  <table id="data" class="table table-bordered table-striped table-scalable">
<?php
include "dt_kursus.php";
?>
                  </table>
                </div><!-- /.box-body -->
              </div><!-- /.box -->
            </div><!-- /.col -->
          </div><!-- /.row -->
        </section><!-- /.content -->
<!-- Modal Popup Dosen -->
<div id="ModalAdd" class="modal fade" tabindex="-1" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
<h4 class="modal-title">Tambah Kursus</h4>
</div>
<div class="modal-body">
<form action="kursus_add.php" name="modal_popup" enctype="multipart/form-data" method="post">
<div class="form-group">
<label>Kode Kursus</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-book"></i>
</div>
<input name="kd_kursus" type="text" class="form-control" placeholder="Kode Kursus"/>
</div>
</div>
<div class="form-group">
<label>Kursus</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-book"></i>
</div>
<input name="nm_kursus" type="text" class="form-control" placeholder="Kursus"/>
</div>
</div>
<div class="modal-footer">
<button class="btn btn-success" type="submit">
Add
</button>
<button type="reset" class="btn btn-danger"  data-dismiss="modal" aria-hidden="true">
Cancel
</button>
</div>
</form>
</div>
</div>
</div>
</div>
<!-- Modal Popup Dosen Edit -->
<div id="ModalEditKursus" class="modal fade" tabindex="-1" role="dialog"></div>
<!-- Modal Popup untuk delete-->
<div class="modal fade" id="modal_delete">
<div class="modal-dialog">
<div class="modal-content" style="margin-top:100px;">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
<h4 class="modal-title" style="text-align:center;">Are you sure to delete this information ?</h4>
</div>
<div class="modal-footer" style="margin:0px; border-top:0px; text-align:center;">
<a href="#" class="btn btn-danger" id="delete_link">Delete</a>
<button type="button" class="btn btn-success" data-dismiss="modal">Cancel</button>
</div>
</div>
</div>
</div>
    </div><!-- /.content-wrapper -->
    <?php
include "content_footer.php";
?>
    </div><!-- ./wrapper -->
<!-- Library Scripts -->
<?php
include "bundle_script.php";
?>
  </body>
</html>


Gambar  32 Form Tambah Kursus
Source code Form Tambah Kursus

<?php
include "../koneksi.php";
$kd_kursus = $_POST["kd_kursus"];
$nm_kursus = $_POST["nm_kursus"];
if($add = sqlsrv_query($konek,"INSERT INTO kursus (kd_kursus, nm_kursus) VALUES ('$kd_kursus', '$nm_kursus')")){
header("Location: kursus.php");
exit();
}
die ("Terdapat Kesalahan : ". sqlsrv_errors($konek));
?>


Gambar  33 Form Ubah Kursus
Source code Form Ubah Kursus

<?php
include "../koneksi.php";
$kd_kursus = $_POST["kd_kursus"];
$nm_kursus = $_POST["nm_kursus"];
if($edit = sqlsrv_query($konek,"UPDATE kursus SET nm_kursus='$nm_kursus' WHERE kd_kursus='$kd_kursus'")){
header("Location: kursus.php");
exit();
}
die ("Terdapat Kesalahan : ". sqlsrv_errors($konek));
?>

Gambar  34 Form Hapus Kursus
Source code Form Hapus Kursus

<?php
include "../koneksi.php";
$kd_kursus = $_GET["kd_kursus"];
if($delete = sqlsrv_query($konek, "DELETE FROM kursus WHERE kd_kursus='$kd_kursus'")){
header("Location: kursus.php");
exit();
}
die ("Terdapat Kesalahan : ".sqlsrv_errors($konek));
?>
Gambar  35 Laporan Data Kursus
Source code Laporan Data Kursus
<?php
include '../koneksi.php';
require('../assets/pdf/fpdf.php');
$pdf = new FPDF("P","cm","A4");
$pdf->SetMargins(2,1,1);
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Times','B',11);
$pdf->SetX(4);
$pdf->MultiCell(19.5,0.5,'Laporan Kursus',0,'L');
$pdf->SetX(4);
$pdf->MultiCell(19.5,0.5,'Sistem Informasi Akademik',0,'L');
$pdf->SetFont('Arial','B',10);
$pdf->SetX(4);
$pdf->MultiCell(19.5,0.5,'Lembaga Kursus',0,'L');
$pdf->SetX(4);
$pdf->SetLineWidth(0.1);
$pdf->Line(1,3.2,20,3.2);
$pdf->SetLineWidth(0);
$pdf->ln(1);
$pdf->SetFont('Arial','B',14);
$pdf->Cell(18,0.7,"Kursus",0,10,'C');
$pdf->ln(1);
$pdf->SetFont('Arial','B',10);
$pdf->Cell(5,0.7,"Dicetak pada : ".date("D-d/m/Y"),0,0,'C');
$pdf->ln(1);
$pdf->SetFont('Arial','B',10);
$pdf->Cell(2, 0.8, 'Kode', 1, 0, 'C');
$pdf->Cell(5, 0.8, 'Kursus', 1, 1, 'C');
$pdf->SetFont('Arial','',10);
$querykursus = sqlsrv_query ($konek, "SELECT * FROM kursus");
if($querykursus == false){
  die ("Terdapat Kesalahan : ". sqlsrv_errors($konek));
}
while($kursus = sqlsrv_fetch_array($querykursus)){
  $pdf->Cell(2, 0.8, $kursus['kd_kursus'] , 1, 0, 'C');
$pdf->Cell(5, 0.8, $kursus['nm_kursus'] , 1, 1, 'C');
}
$pdf->Output("cetak_kursus.pdf","I");
?>

1.2.6 Form Jadwal 
Gambar  36 Form Jadwal
Source code Form Jadwal
<?php
session_start();include "../koneksi.php";include "auth_user.php";
$daftarhari[] = "Senin";$daftarhari[] = "Selasa";$daftarhari[] = "Rabu";$daftarhari[] = "Kamis";$daftarhari[] = "Jumat";$daftarhari[] = "Sabtu";$daftarhari[] = "Ahad";
?><!DOCTYPE html><html> <head>    <meta charset="utf-8">    <title>SIA Lembaga Kursus</title> <!-- Library CSS --> <?php include "bundle_css.php"; ?>  </head>  <body class="sidebar-mini wysihtml5-supported skin-green-light">    <div class="wrapper">      <?php        include 'content_header.php';       ?>      <!-- Left side column. contains the logo and sidebar -->      <aside class="main-sidebar">        <!-- sidebar: style can be found in sidebar.less -->        <section class="sidebar">          <!-- Sidebar user panel -->          <div class="user-panel">            <div class="pull-left image">              <p></p>            </div>          </div><!-- sidebar menu: : style can be found in sidebar.less -->          <ul class="sidebar-menu">              <li class="header"><h4><b><center>Menu Panel</center></b></h4></li>              <li class="active"><a href="index.php"><i class="fa fa-home"></i><span>Dashboard</span></a></li>              <li><a href="pengajar.php"><i class="fa fa-user"></i><span>Pengajar</span></a></li>              <li><a href="peserta.php"><i class="fa fa-users"></i><span>Peserta</span></a></li>              <li><a href="ruangan.php"><i class="fa fa-columns"></i><span>Ruangan</span></a></li>              <li><a href="kursus.php"><i class="fa fa-book"></i><span>Kursus</span></a></li>              <li><a href="jadwal.php"><i class="fa fa-calendar"></i><span>Jadwal</span></a></li>              <li><a href="user.php"><i class="fa fa-user-circle-o"></i><span>User</span></a></li>              <li><a href="about.php"><i class="fa fa-info-circle"></i><span>Tentang Aplikasi</span></a></li>          </ul>        </section>        <!-- /.sidebar -->      </aside>
      <!-- Content Wrapper. Contains page content -->      <div class="content-wrapper">        <!-- Content Header (Page header) -->        <section class="content-header">          <h1>            Jadwal          </h1>          <ol class="breadcrumb">            <li><i class="fa fa-calendar"></i> Jadwal</li>          </ol>        </section>
        <!-- Main content -->        <section class="content">          <div class="row">            <div class="col-xs-12">              <div class="box">                <div class="box-header">
                </div><!-- /.box-header -->                <div class="box-body"> <a href="#"><button class="btn btn-success" type="button" data-target="#ModalAdd" data-toggle="modal"><i class="fa fa-plus"></i> Add</button></a>        <a style="margin-bottom:10px" href="cetak_dt_jadwal.php" target="_blank" class="btn btn-default pull-right"><span class='glyphicon glyphicon-print'></span>  Cetak</a>                  <br></br>   <table id="data" class="table table-bordered table-striped table-scalable"> <?php include "dt_jadwal.php"; ?>                  </table>                </div><!-- /.box-body -->              </div><!-- /.box -->            </div><!-- /.col -->          </div><!-- /.row -->        </section><!-- /.content -->
<!-- Modal Popup Dosen --> <div id="ModalAdd" class="modal fade" tabindex="-1" role="dialog"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button> <h4 class="modal-title">Tambah Jadwal</h4> </div> <div class="modal-body"> <form action="jadwal_add.php" name="modal_popup" enctype="multipart/form-data" method="post">              <div class="form-group"> <label>Kode Jadwal</label> <div class="input-group"> <div class="input-group-addon"> <i class="fa fa-book"></i> </div> <input name="kd_jadwal" type="text" class="form-control" placeholder="Kode Jadwal"/> </div> </div> <div class="form-group"> <label>Pengajar</label> <div class="input-group"> <div class="input-group-addon"> <i class="fa fa-user"></i> </div> <select name="kd_pengajar" class="form-control"> <?php
$querypengajar = sqlsrv_query($konek, "SELECT * FROM pengajar"); if ($querypengajar == false){ die ("Terdapat Kesalahan : ". sqlsrv_errors($konek)); } while ($pengajar = sqlsrv_fetch_array($querypengajar)){ echo "<option value='$pengajar[kd_pengajar]'>$pengajar[nm_pengajar]</option>"; } ?> </select> </div> </div> <div class="form-group"> <label>Kursus</label> <div class="input-group"> <div class="input-group-addon"> <i class="fa fa-book"></i> </div> <select name="kd_kursus" class="form-control"> <?php
$querykursus = sqlsrv_query ($konek, "SELECT * FROM kursus"); if ($querykursus == false){ die ("Terdapat Kesalahan : ". sqlsrv_errors($konek)); } while ($kursus = sqlsrv_fetch_array($querykursus)){ echo "<option value='$kursus[kd_kursus]'>$kursus[nm_kursus]</option>"; } ?> </select> </div> </div> <div class="form-group"> <label>Ruangan</label> <div class="input-group"> <div class="input-group-addon"> <i class="fa fa-columns"></i> </div> <select name="kd_ruangan" class="form-control"> <?php
$queryruang = sqlsrv_query($konek, "SELECT * FROM ruangan"); if($queryruang == false){ die ("Terdapat Kesalahan : ". sqlsrv_errors($konek)); } while ($ruang = sqlsrv_fetch_array($queryruang)){ echo "<option value='$ruang[kd_ruangan]'>$ruang[nm_ruangan]</option>"; } ?> </select> </div> </div> <div class="form-group"> <label>Hari</label> <div class="input-group"> <div class="input-group-addon"> <i class="fa fa-calendar"></i> </div> <select name="hari" class="form-control"> <?php for($hari=0; $hari<count($daftarhari); $hari++) { echo "<option value='$daftarhari[$hari]'>$daftarhari[$hari]</option>"; } ?> </select> </div> </div> <div class="form-group"> <label>Jam Mulai</label> <div class="input-group"> <div class="input-group-addon"> <i class="fa fa-clock-o"></i> </div> <input id="Jam_Mulai" name="Jam_Mulai" type="text" class="form-control" placeholder="Jam Mulai"> </div> </div> <div class="form-group"> <label>Jam Selesai</label> <div class="input-group"> <div class="input-group-addon"> <i class="fa fa-clock-o"></i> </div> <input id="Jam_Selesai" name="Jam_Selesai" type="text" class="form-control" placeholder="Jam Selesai"> </div> </div> <div class="modal-footer"> <button class="btn btn-success" type="submit"> Add </button> <button type="reset" class="btn btn-danger"  data-dismiss="modal" aria-hidden="true"> Cancel </button> </div> </form> </div> </div> </div> </div>
<!-- Modal Popup Dosen Edit --> <div id="ModalEditJadwal" class="modal fade" tabindex="-1" role="dialog"></div>
<!-- Modal Popup untuk delete--> <div class="modal fade" id="modal_delete"> <div class="modal-dialog"> <div class="modal-content" style="margin-top:100px;"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button> <h4 class="modal-title" style="text-align:center;">Are you sure to delete this information ?</h4> </div> <div class="modal-footer" style="margin:0px; border-top:0px; text-align:center;"> <a href="#" class="btn btn-danger" id="delete_link">Delete</a> <button type="button" class="btn btn-success" data-dismiss="modal">Cancel</button> </div> </div> </div> </div>
    </div><!-- /.content-wrapper --> <?php include "content_footer.php"; ?>    </div><!-- ./wrapper --> <!-- Library Scripts --> <?php include "bundle_script.php"; ?>  </body></html>


 Gambar  37 Form Tambah Jadwal

Source Code Form Tambah Jadwal


<?php
include "../koneksi.php";
$kd_jadwal = $_POST["kd_jadwal"];
$kd_kursus = $_POST["kd_kursus"];
$kd_pengajar = $_POST["kd_pengajar"];
$kd_ruangan = $_POST["kd_ruangan"];
$hari = $_POST["hari"];
$Jam_Mulai = $_POST["Jam_Mulai"];
$Jam_Selesai = $_POST["Jam_Selesai"];
$jam = $Jam_Mulai."-".$Jam_Selesai;
if($add = sqlsrv_query($konek, "INSERT INTO jadwal(kd_jadwal, kd_kursus, kd_pengajar, kd_ruangan, hari, jam) VALUES ('$kd_jadwal', '$kd_kursus', '$kd_pengajar', '$kd_ruangan', '$hari', '$jam')")){
header("Location: jadwal.php");
exit();
}
die ("Terdapat Kesalahan : ". sqlsrv_errors($konek));
?>



Gambar  38 Form Edit Jadwal

Source Code Form Edit Jadwal 
<?php
include "../koneksi.php";
$kd_jadwal = $_POST["kd_jadwal"];
$kd_pengajar = $_POST["kd_pengajar"];
$kd_kursus = $_POST["kd_kursus"];
$kd_ruangan = $_POST["kd_ruangan"];
$hari = $_POST["hari"];
$Jam_Mulai = $_POST["Jam_Mulai"];
$Jam_Selesai = $_POST["Jam_Selesai"];
$jam = $Jam_Mulai."-".$Jam_Selesai;
if($edit = sqlsrv_query($konek, "UPDATE jadwal SET kd_pengajar='$kd_pengajar', kd_kursus='$kd_kursus', kd_ruangan='$kd_ruangan', hari='$hari', jam='$jam' WHERE kd_jadwal='$kd_jadwal'")){
header("Location: jadwal.php");
exit();
}
die("Terdapat Kesalahan : ". sqlsrv_errors($konek));
?>

Gambar  39 Form Hapus Jadwal

Source Code Form Hapus Jadwal
<?php
include "../koneksi.php";
$kd_jadwal = $_GET["kd_jadwal"];
if($delete = sqlsrv_query($konek, "DELETE FROM jadwal WHERE kd_jadwal='$kd_jadwal'")){
header("Location: jadwal.php");
exit();
}
die ("Terdapat Kesalahan : ". sqlsrv_errors($konek));
?>
 
Gambar  40 Laporan Data Jadwal

Source Code Laporan Data Jadwal
<?php
include '../koneksi.php';
require('../assets/pdf/fpdf.php');
$pdf = new FPDF("L","cm","A4");
$pdf->SetMargins(2,1,1);
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Times','B',11);
$pdf->SetX(4);
$pdf->MultiCell(19.5,0.5,'Laporan Jadwal',0,'L');
$pdf->SetX(4);
$pdf->MultiCell(19.5,0.5,'Sistem Informasi Akademik',0,'L');
$pdf->SetFont('Arial','B',10);
$pdf->SetX(4);
$pdf->MultiCell(19.5,0.5,'Lembaga Kursus',0,'L');
$pdf->SetX(4);
$pdf->SetLineWidth(0.1);
$pdf->Line(1,3.2,28.5,3.2);
$pdf->SetLineWidth(0);
$pdf->ln(1);
$pdf->SetFont('Arial','B',14);
$pdf->Cell(25.5,0.7,"Jadwal",0,10,'C');
$pdf->ln(1);
$pdf->SetFont('Arial','B',10);
$pdf->Cell(5,0.7,"Dicetak pada : ".date("D-d/m/Y"),0,0,'C');
$pdf->ln(1);
$pdf->SetFont('Arial','B',10);
$pdf->Cell(5, 0.8, 'Kursus', 1, 0, 'C');
$pdf->Cell(5, 0.8, 'Pengajar', 1, 0, 'C');
$pdf->Cell(5, 0.8, 'Ruangan', 1, 0, 'C');
$pdf->Cell(4, 0.8, 'Hari', 1, 0, 'C');
$pdf->Cell(4, 0.8, 'Jam', 1, 1, 'C');
$pdf->SetFont('Arial','',10);
$queryjadwal = sqlsrv_query ($konek, "SELECT kd_jadwal, kursus.nm_kursus, pengajar.nm_pengajar, ruangan.nm_ruangan, hari, jam FROM jadwal INNER JOIN kursus ON kursus.kd_kursus=jadwal.kd_kursus INNER JOIN pengajar ON pengajar.kd_pengajar=jadwal.kd_pengajar INNER JOIN ruangan ON ruangan.kd_ruangan=jadwal.kd_ruangan ORDER BY hari DESC");
if($queryjadwal == false){
  die ("Terjadi Kesalahan : ". sqlsrv_errors($konek));
}
while ($jadwal = sqlsrv_fetch_array($queryjadwal)){
$pdf->Cell(5, 0.8, $jadwal['nm_kursus'] , 1, 0, 'C');
$pdf->Cell(5, 0.8, $jadwal['nm_pengajar'],1, 0, 'C');
$pdf->Cell(5, 0.8, $jadwal['nm_ruangan'], 1, 0,'C');
$pdf->Cell(4, 0.8, $jadwal['hari'],1, 0, 'C');
$pdf->Cell(4, 0.8, $jadwal['jam'], 1, 1,'C');
}
$pdf->Output("cetak_jadwal.pdf","I");
?>

Aplikasi lengkapnya dapat diunduh di sini.

Anggota Kelompok:
Erlina Nofianti               : 201553006
Iman Ardhi Prabowo     : 201553013
Nurul Mashfufah           : 201553041
Rita Suryana                 : 201553050