Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!-- index.php -->
- <?php
- session_start();
- if(isset($_POST['signin'])){
- $userID = $_POST['username'];
- $pass = $_POST['password'];
- if(isset($userID) && isset($pass)){
- $username="root";
- $password="";
- $conn = new PDO('mysql:host=localhost;dbname=medic',$username,$password);
- $stmt = $conn->prepare("SELECT password, salt, hak FROM login2 WHERE username = '$userID' LIMIT 1");
- $stmt->execute();
- $row = $stmt->fetch();
- $pass_salt = $pass.$row["salt"];
- $hash = md5($pass_salt);
- if(strcmp($row["password"], $hash)==0){
- if($row["hak"]==1){
- $_SESSION['STATUS'] = 1;
- header("location:admin-medis.php");
- }
- else{
- echo "<script type='text/javascript'>alert('Username/Password Anda Salah. Silahkan coba lagi.')</script>";
- echo "<script>
- $(document).ready(function(){
- $('#Modal').modal({
- keyboard:false,
- show:true,
- backdrop:'static'
- });
- });
- </script>";
- }
- }
- else{
- echo "<script type='text/javascript'>alert('Username/Password Anda Salah. Silahkan coba lagi.')</script>";
- echo "<script>
- $(document).ready(function(){
- $('#Modal').modal({
- keyboard:false,
- show:true,
- backdrop:'static'
- });
- });
- </script>";
- }
- }
- }
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <link rel="shortcut icon" href="images/medic.ico" />
- <link rel="stylesheet" type="text/css" href="main.css">
- <script type="text/javascript" src="js/jquery-1.11.3.min.js"></script>
- <script type="text/javascript" src="js/bootstrap.min.js"></script>
- <link rel="stylesheet" type="text/css" href="css/bootstrap.min.css">
- <link rel="stylesheet" type="text/css" href="css/bootstrap-theme.min.css">
- <link rel="stylesheet" type="text/css" href="css/dataTables.bootstrap.min.css">
- <script type="text/javascript" src="js/jquery.dataTables.min.js"></script>
- <script type="text/javascript" src="js/dataTables.bootstrap.min.js"></script>
- <title>UMN MEDICAL CENTER</title>
- <style>
- .modal-black {
- background: #ffffff;
- }
- </style>
- <?php
- if($_SESSION['STATUS']!=1){
- echo "<script>
- $(document).ready(function(){
- $('#Modal').modal({
- keyboard:false,
- show:true,
- backdrop:'static'
- });
- });
- </script>";
- }
- ?>
- <script>
- function format ( d ) {
- return '<table class="table table-striped" cellpadding="5" cellspacing="0" border="0" style="padding-left:50px;">'+
- '<tr>'+
- '<td>Nama : </td>'+
- '<td>'+d.namePen+'</td>'+
- '</tr>'+
- '<tr>'+
- '<td>NIM : </td>'+
- '<td>'+d.nimPen+'</td>'+
- '</tr>'+
- '<tr>'+
- '<td>No. HP : </td>'+
- '<td>'+d.phPen+'</td>'+
- '</tr>'+
- '<tr>'+
- '<td>ID Line : </td>'+
- '<td>'+d.linePen+'</td>'+
- '</tr>'+
- '<tr>'+
- '<td>DeskripsiW : </td>'+
- '<td>'+d.dscrPen+'</td>'+
- '</tr>'+
- '<tr>'+
- '<td>Medis : </td>'+
- '<td>'+d.medicPen+'</td>'+
- '</tr>'+
- '</table>';
- }
- $(document).ready(function() {
- var table = $('#myTable').DataTable( {
- "columns": [
- {
- "className": 'details-control',
- "orderable": false,
- "data": null,
- "defaultContent": ''
- },
- { "data": "idPen" }, //1
- { "data": "evPen" }, //2
- { "data": "namePen" }, //3
- { "data": "nimPen" }, //4
- { "data": "phPen" }, //5
- { "data": "linePen" }, //6
- { "data": "orgPen" }, //7
- { "data": "datePen1" }, //8
- { "data": "datePen2" }, //9
- { "data": "timePen1" }, //10
- { "data": "timePen2" }, //11
- { "data": "dscrPen" }, //12
- { "data": "medicPen" }, //13
- { "data": "statPen" }, //14
- { "data": "modal" } //15
- ],
- "order": [[1, 'asc']],
- "columnDefs": [
- { "visible": false, "targets": [3,4,5,6,12,13] }
- ]
- } );
- $('#myTable tbody').on('click', 'td.details-control', function () {
- var tr = $(this).closest('tr');
- var row = table.row( tr );
- if ( row.child.isShown() ) {
- row.child.hide();
- tr.removeClass('shown');
- }
- else {
- row.child( format(row.data()) ).show();
- tr.addClass('shown');
- }
- } );
- } );
- </script>
- </script>
- <style>
- .carousel-inner > .item > img,
- .carousel-inner > .item > a > img {
- width: 70%;
- margin: auto;
- }
- </style>
- </head>
- <body>
- <div id="Modal" class="modal modal-black" tabindex="1" role="dialog">
- <div class="modal-dialog" role="document">
- <div class="modal-content">
- <div class="modal-body">
- <h1 class="text-center login-title">Please Sign In</h1>
- <div class="form-group">
- <form class="form-signin" method="POST" action="index.php">
- <input id="username" name="username" type="text" class="form-control" placeholder="Username" required autofocus>
- <input id="password" name="password" type="password" class="form-control" placeholder="Password" required>
- <button name="signin" class="btn btn-lg btn-primary btn-block" type="submit">
- Sign in</button>
- </form>
- </div>
- </div>
- </div>
- </div>
- </div>
- <script type="text/javascript">
- $(document).ready(function(){
- $('#myTable').DataTable();
- });
- </script>
- <nav class='navbar navbar-default'>
- <div class='container'>
- <div class='navbar-header'>
- <a href='#' class='navbar-brand' style='color:green;'><b>UMN MEDICAL CENTER [Admin-Mode]</b></a>
- </div>
- <ul class='nav navbar-nav'>
- <li class='active'><a href='admin-medis.php'>Pengajuan Jasa Medis</a></li>
- <li><a href='admin-falkes.php'>Peminjaman Alat Kesehatan / Obat-obatan</a></li>
- <li><a href='admin-member.php'>Info Anggota</a></li>
- </ul>
- <ul class="nav navbar-nav navbar-right">
- <li><a href="logout.php">Log Out</a></li>
- </ul>
- </nav>
- </div>
- <?php
- $username = "root";
- $password = "";
- $conn2 = new PDO('mysql:host=localhost;dbname=medic',$username,$password);
- $idUp = '';
- $statUp = '';
- if(isset($_POST['update'])){
- $idUp = $_POST['inID'];
- $statUp = $_POST['inDone'];
- $sqlup = "UPDATE fmedis SET status='$statUp' WHERE id='$idUp'";
- $conn2->exec($sqlup);
- echo "<script>alert('Updated')</script>";
- }
- ?>
- <?php
- $username = "root";
- $password = "";
- $conn = new PDO('mysql:host=localhost;dbname=medic',$username,$password);
- $data = $conn->query("select id, acara, namalengkap, nim, phone, lineid, organisasi,date_format(tanggal1,'%d-%m-%Y'), date_format(tanggal2,'%d-%m-%Y'), TIME_FORMAT(waktu1,'%h:%i%p'),TIME_FORMAT(waktu2,'%h:%i%p'), dscr, medis, status from fmedis");
- echo"
- <div class='container'>
- <div class='row'>
- <div class='col-xs-10 col-xs-offset-1'>
- <table id='myTable' style='border: 1px solid black; border-collapse: collapse;' class='table table-bordered table-striped'>
- <thead>
- <tr>
- <th></th>
- <th>ID</th>
- <th>Event</th>
- <th>Nama Pengaju</th>
- <th>NIM</th>
- <th>Phone Number</th>
- <th>Line ID</th>
- <th>Organisasi/Kepanitiaan</th>
- <th>Start Date</th>
- <th>End Date</th>
- <th>Start Time</th>
- <th>End Time</th>
- <th>Description</th>
- <th>Medic</th>
- <th>Status</th>
- <th></th>
- </tr>
- </thead>
- <tbody>";
- foreach ($data as $row) {
- echo "<tr>";
- echo "<td style='width:40px;'></td>";
- echo "<td>".$row[0]."</td>";
- echo "<td>".$row[1]."</td>";
- echo "<td>".$row[2]."</td>";
- echo "<td>".$row[3]."</td>";
- echo "<td>".$row[4]."</td>";
- echo "<td>".$row[5]."</td>";
- echo "<td>".$row[6]."</td>";
- echo "<td>".$row[7]."</td>";
- echo "<td>".$row[8]."</td>";
- echo "<td>".$row[9]."</td>";
- echo "<td>".$row[10]."</td>";
- echo "<td>".$row[11]."</td>";
- echo "<td>".$row[12]."</td>";
- echo "<td>".$row[13]."</td>";
- echo "<td><center>
- <a href='#editModal'
- class='btn btn-warning open-edit_modal'
- data-toggle='modal'
- data-id='".$row[0]."'
- data-apa='".$row[7]."'
- data-itu='".$row[8]."'
- data-time1='".$row[9]."'
- data-time2='".$row[10]."'
- data-dscr='".$row[11]."'
- data-medis='".$row[12]."'
- data-status='".$row[13]."'>Edit</a>
- <a href='#deleteModal' class='btn btn-danger open-delete_modal'
- data-toggle='modal'
- data-id='".$row[0]."'
- >Delete</a>
- </center></td>";
- echo "</tr>";
- }
- echo"
- </tbody>
- </table>
- </div>
- </div>
- </div>
- ";
- ?>
- <script type="text/javascript">
- $(document).on("click", ".open-delete_modal", function(){
- var id = $(this).data('id');
- $('#id').val(id);
- });
- </script>
- <div id="deleteModal" class="modal" tabindex="1" role="dialog">
- <div class="modal-dialog" role="document">
- <div class="modal-content">
- <div class="modal-body">
- <button type="button" class="close" data-dismiss="modal">×</button>
- <h1 class="text-center login-title">Delete Data</h1>
- <div class="form-group">
- <form class="form-signin" method="POST" action="delete.php">
- <input id="id" name="id" type="hidden" />
- <h3><center>Apakah Anda yakin ingin menghapus data ini?</center></h3>
- <br><br>
- <button name="delete" class="btn btn-lg btn-danger btn-block" type="submit">Delete</button>
- </form>
- </div>
- </div>
- </div>
- </div>
- </div>
- <script type="text/javascript">
- $(document).on("click", ".open-edit_modal", function(){
- var id = $(this).data('id');
- var apa = $(this).data('apa');
- var itu = $(this).data('itu');
- var time1 = $(this).data('time1');
- var time2 = $(this).data('time2');
- var dscr = $(this).data('dscr');
- var medis = $(this).data('medis');
- var status = $(this).data('status');
- $('#sid').val(id);
- $('#tglmulai').val(apa);
- $('#tglselesai').val(itu);
- $('#wktmulai').val(time1);
- $('#wktselesai').val(time2);
- $('#descr').val(dscr);
- $('#medic').val(medis);
- $('#stat').val(status);
- });
- </script>
- <div id="editModal" class="modal" tabindex="1" role="dialog">
- <div class="modal-dialog" role="document">
- <div class="modal-content">
- <div class="modal-body">
- <button type="button" class="close" data-dismiss="modal">×</button>
- <h1 class="text-center login-title">Update Data</h1>
- <div class="form-group">
- <form class="form-signin" method="POST" action="edit.php">
- <input id="sid" name="sid" type="hidden" />
- <label for="tglmulai">Tanggal Mulai</label>
- <input id="tglmulai" name="tglmulai" type="text" class="form-control" placeholder="Apa" required autofocus>
- <br>
- <label for="tglselesai">Tanggal Selesai</label>
- <input id="tglselesai" name="tglselesai" type="text" class="form-control" placeholder="Itu" required>
- <br>
- <label for="wktmulai">Waktu Mulai</label>
- <input id="wktmulai" name="wktmulai" type="text" class="form-control" required>
- <br>
- <label for="wktselesai">Waktu Selesai</label>
- <input id="wktselesai" name="wktselesai" type="text" class="form-control" required>
- <br>
- <label for="descr">Deskripsi</label>
- <input id="descr" name="descr" type="text" class="form-control" required>
- <br>
- <label for="medic">Medis</label>
- <input id="medic" name="medic" type="text" class="form-control" required>
- <br>
- <label for="stat">Status</label>
- <input id="stat" name="stat" type="text" class="form-control" required>
- <br><br>
- <button name="update" class="btn btn-lg btn-primary btn-block" type="submit">Update</button>
- </form>
- </div>
- </div>
- </div>
- </div>
- </div>
- </body>
- </html>
- <!-- admin-member.php -->
- <?php
- session_start();
- if(($_SESSION['STATUS']!==1)){
- header("location:index.php");
- }
- else{
- }
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <link rel="shortcut icon" href="images/medic.ico" />
- <script type="text/javascript" src="js/jquery-1.11.3.min.js"></script>
- <script type="text/javascript" src="js/bootstrap.min.js"></script>
- <link rel="stylesheet" type="text/css" href="css/bootstrap.min.css">
- <link rel="stylesheet" type="text/css" href="css/bootstrap-theme.min.css">
- <link rel="stylesheet" type="text/css" href="css/dataTables.bootstrap.min.css">
- <script type="text/javascript" src="js/jquery.dataTables.min.js"></script>
- <script type="text/javascript" src="js/dataTables.bootstrap.min.js"></script>
- <title>UMN MEDICAL CENTER</title>
- <style>
- .carousel-inner > .item > img,
- .carousel-inner > .item > a > img {
- width: 70%;
- margin: auto;
- }
- </style>
- </head>
- <body>
- <nav class='navbar navbar-default'>
- <div class='container'>
- <div class='navbar-header'>
- <a href='#' class='navbar-brand' style='color:green;'><b>UMN MEDICAL CENTER [Admin-Mode]</b></a>
- </div>
- <ul class='nav navbar-nav'>
- <li><a href='admin-medis.php'>Pengajuan Jasa Medis</a></li>
- <li><a href='admin-falkes.php'>Peminjaman Alkes/Obat</a></li>
- <li class='active'><a href='admin-member.php'><strong>Info Anggota</strong></a></li>
- <li><a href='admin-obat.php'>Info Obat</a></li>
- <li><a href='admin-jadwal.php'>Info Jadwal</a></li>
- </ul>
- <ul class="nav navbar-nav navbar-right">
- <li><a href="logout.php">Log Out</a></li>
- </ul>
- </nav>
- </div>
- <div class="container" style="border:0; padding: 0;">
- <div class="text-right" style="padding-bottom:10px">
- <a href="admin-form.php" class="btn btn-primary col-xs-offset-10" role="button"><span class="glyphicon glyphicon-plus-sign" style="margin-bottom: 5px" aria-hidden="true"></span> Tambah baru</a>
- </div></div>
- <?php
- $username = "root";
- $password = "";
- $conn = new PDO('mysql:host=localhost;dbname=medic',$username,$password);
- $data = $conn->query("select nim,nama,jurusan,date_format(tgllhr,'%d-%m-%Y'),jabatan,gender from infomember2");
- $ctr = 0;
- echo"
- <div class='container'>
- <div class='row'>
- <div class='col-xs-10 col-xs-offset-1'>
- <table id='myTable' style='border: 1px solid black; border-collapse: collapse;' class='table table-bordered table-striped'>
- <thead>
- <tr>
- <th></th>
- <th>NIM</th>
- <th>Nama Lengkap</th>
- <th>Jurusan</th>
- <th>Tanggal Lahir</th>
- <th>Jabatan</th>
- <th>Gender</th>
- <th></th>
- </tr>
- </thead>
- <tbody>";
- foreach ($data as $row) {
- $ctr=$ctr+1;
- echo "<tr>";
- echo "<td style='width:40px;'>$ctr</td>";
- echo "<td>".$row[0]."</td>";
- echo "<td>".$row[1]."</td>";
- echo "<td>".$row[2]."</td>";
- echo "<td>".$row[3]."</td>";
- echo "<td>".$row[4]."</td>";
- echo "<td>".$row[5]."</td>";
- echo "<td><center>
- <a href='#editModals'
- class='btn btn-warning open-edit_member'
- data-toggle='modal'
- data-nim='".$row[0]."'
- data-nama='".$row[1]."'
- data-jurusan='".$row[2]."'
- data-tgllhr='".$row[3]."'>Edit</a>
- </center></td>";
- echo "</tr>";
- }
- echo"
- </tbody>
- </table>
- </div>
- </div>
- </div>
- ";
- ?>
- <script type="text/javascript">
- $(document).on("click", ".open-edit_member", function(){
- var nim = $(this).data('nim');
- var nama = $(this).data('nama');
- var jurusan = $(this).data('jurusan');
- var tgllhr = $(this).data('tgllhr');
- $('#snim').val(nim);
- $('#sname').val(nama);
- $('#smajor').val(jurusan);
- $('#sbirth').val(tgllhr);
- });
- </script>
- <div id="editModals" class="modal modal-black" tabindex="1" role="dialog">
- <div class="modal-dialog" role="document">
- <div class="modal-content">
- <div class="modal-body">
- <button type="button" class="close" data-dismiss="modal">×</button>
- <h1 class="text-center login-title">Update Data</h1>
- <div class="form-group">
- <form class="form-signin" method="POST" action="edit-member.php">
- <input id="snim" name="snim" type="hidden" />
- <label for="sname">Nama Lengkap</label>
- <input id="sname" name="sname" type="text" class="form-control" required autofocus>
- <br>
- <label for="smajor">Program Studi</label>
- <input id="smajor" name="smajor" type="text" class="form-control" required>
- <br>
- <label for="sbirth">Tanggal Lahir</label>
- <input id="sbirth" name="sbirth" type="text" class="form-control" required>
- <br><br>
- <button name="update" class="btn btn-lg btn-primary btn-block" type="submit">Update</button>
- </form>
- </div>
- </div>
- </div>
- </div>
- </div>
- </body>
- </html>
- <!-- admin-form.php -->
- <?php
- session_start();
- if(($_SESSION['STATUS']!==1)){
- header("location:index.php");
- }
- else{
- }
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <script type="text/javascript" src="js/jquery-1.11.3.min.js"></script>
- <script type="text/javascript" src="js/bootstrap.min.js"></script>
- <link rel="stylesheet" type="text/css" href="css/bootstrap.min.css">
- <link rel="stylesheet" type="text/css" href="css/bootstrap-theme.min.css">
- <link rel="stylesheet" type="text/css" href="css/dataTables.bootstrap.min.css">
- <script type="text/javascript" src="js/jquery.dataTables.min.js"></script>
- <script type="text/javascript" src="js/dataTables.bootstrap.min.js"></script>
- <title></title>
- </head>
- <body>
- <nav class='navbar navbar-default'>
- <div class='container'>
- <div class='navbar-header'>
- <a href='#' class='navbar-brand' style='color:green;'><b>UMN MEDICAL CENTER [Admin-Mode]</b></a>
- </div>
- <ul class='nav navbar-nav'>
- <li class='active'><a href='admin-form.php'><strong>Tambah Admin/Member</strong></a></li>
- </ul>
- </nav>
- </div>
- <div class="container">
- <!-- id -->
- <form class="form-horizontal" method="POST" action="admin-form.php">
- <div class="form-group">
- <label style="text-align:left;" for="inputsid" class="col-sm-2 control-label">NIM</label>
- <div class="col-sm-3">
- <input type="number" class="form-control" name="sid" id="inputsid" placeholder="ex:14110110020">
- </div>
- </div>
- <!-- full name -->
- <div class="form-group">
- <label style="text-align:left;" for="inputfname" class="col-sm-2 control-label">Nama Lengkap</label>
- <div class="col-sm-3">
- <input type="text" class="form-control" name="fname" id="inputfname" placeholder="Kevin Lionery">
- </div>
- </div>
- <!-- Jurusan -->
- <div class="form-group">
- <label style="text-align:left;" for="inJur" class="col-sm-2 control-label">Program Studi</label>
- <div class="col-sm-3">
- <select class="form-control" id="inJur" name="inJur">
- <option value="Teknik Informatika">Teknik Informatika</option>
- <option value="Sistem Informasi">Sistem Informasi</option>
- <option value="Sistem Komputer">Sistem Komputer</option>
- <option value="Teknik Fisika">Teknik Fisika</option>
- <option value="Teknik Elektro">Teknik Elektro</option>
- <option value="Manajemen">Manajemen</option>
- <option value="Akuntansi">Akuntansi</option>
- <option value="Komunikasi Strategis">Komunikasi Strategis</option>
- <option value="Jurnalistik">Jurnalistik</option>
- <option value="Desain Komunikasi Visual">Desain Komunikasi Visual</option>
- <option value="Arsitektur">Arsitektur</option>
- <option value="Film & Animasi">Film & Animasi</option>
- </select>
- </div>
- </div>
- <!-- tanggal lahir -->
- <div class="form-group">
- <label style="text-align:left;" for="inputbirth" class="col-sm-2 control-label">Tanggal Lahir</label>
- <div class="col-sm-3">
- <input type="date" class="form-control" name="birth" id="inputbirth" placeholder="yyyy-mmmm-dd" min="1996-12-01">
- </div>
- </div>
- <!-- Gender -->
- <div class="form-group">
- <label style="text-align:left;" for="gender" class="col-sm-2 control-label">Jenis Kelamin</label>
- <div class="col-sm-3">
- <input type="radio" name="gender" value="L">  <strong>Laki-laki</strong><br>
- <input type="radio" name="gender" value="P">  <strong>Perempuan</strong><br>
- </div>
- </div>
- <!-- Jabatan -->
- <div class="form-group">
- <label style="text-align:left;" for="inJob" class="col-sm-2 control-label">Jabatan</label>
- <div class="col-sm-3">
- <select class="form-control" id="inJob" name="inJob">
- <option value="Anggota Medic">Anggota Medic</option>
- <option value="Ketua">Ketua</option>
- <option value="Wakil">Wakil</option>
- <option value="Koor. Divisi Alkes">Koor. Divisi Alkes</option>
- <option value="Anggota Div. Alkes">Anggota Alkes</option>
- <option value="Koor. Divisi Sekretaris">Koor. Divisi Sekretaris</option>
- <option value="Anggota Div. Sekretaris">Anggota Sekretaris</option>
- <option value="Koor. Divisi Bendahara">Koor. Bendahara</option>
- <option value="Anggota Div. Bendahara">Anggota Bendahara</option>
- <option value="Koor. Divisi Medis">Koor. Divisi Medis</option>
- <option value="Anggota Div. Medis">Anggota Div. Medis</option>
- <option value="Koor. Divisi Publikasi">Koor. Publikasi</option>
- <option value="Anggota Div. Publikasi">Anggota Div. Publikasi</option>
- </select>
- </div>
- </div>
- <div class="form-group">
- <label for="inputdesc" class="col-sm-2 control-label"></label>
- <div class="col-sm-3">
-                           
- <button type="submit" name="submit" class="btn btn-primary">Submit</button>  
- <a href="admin-medis.php" class="btn btn-default" role="button">Back</a>
- </div>
- </div>
- </form>
- <?php
- $nimhs ='';
- $fullname = '' ;
- $jur = '' ;
- $tgl = '' ;
- $gender = '';
- $job = '';
- $hak = 0;
- $countchar ='';
- $result ='';
- $pas ='';
- $passalt ='';
- $hash ='';
- if(isset($_POST['submit'])){
- $nimhs = $_POST['sid'];
- $fullname = $_POST['fname'] ;
- $jur = $_POST['inJur'] ;
- $tgl = $_POST['birth'] ;
- $gender = $_POST['gender'] ;
- $job = $_POST['inJob'] ;
- $username = "root";
- $password = "";
- $conn = new PDO('mysql:host=localhost; dbname=medic',$username,$password);
- $sql = "insert into infomember2(nim,nama,jurusan,tgllhr,jabatan,gender) values('$nimhs','$fullname','$jur','$tgl','$job','$gender')";
- //echo $sql;
- $conn->exec($sql);
- //header("Location: admin-form.php");
- // generate random
- function genKey($length) {
- if($length > 0) {
- $rand_id='';
- for($i=1; $i <= $length; $i++) {
- mt_srand((double)microtime() * 1000000);
- $num = mt_rand(1,72);
- $rand_id .= assign_rand_value($num);
- }
- }
- return $rand_id;
- }
- function assign_rand_value($num) {
- switch($num) {
- case '1':
- $rand_value = 'a';
- break;
- case '2':
- $rand_value = 'b';
- break;
- case '3':
- $rand_value = 'c';
- break;
- case '4':
- $rand_value = 'd';
- break;
- case '5':
- $rand_value = 'e';
- break;
- case '6':
- $rand_value = 'f';
- break;
- case '7':
- $rand_value = 'g';
- break;
- case '8':
- $rand_value = 'h';
- break;
- case '9':
- $rand_value = 'i';
- break;
- case '10':
- $rand_value = 'j';
- break;
- case '11':
- $rand_value = 'k';
- break;
- case '12':
- $rand_value = 'l';
- break;
- case '13':
- $rand_value = 'm';
- break;
- case '14':
- $rand_value = 'n';
- break;
- case '15':
- $rand_value = 'o';
- break;
- case '16':
- $rand_value = 'p';
- break;
- case '17':
- $rand_value = 'q';
- break;
- case '18':
- $rand_value = 'r';
- break;
- case '19':
- $rand_value = 's';
- break;
- case '20':
- $rand_value = 't';
- break;
- case '21':
- $rand_value = 'u';
- break;
- case '22':
- $rand_value = 'v';
- break;
- case '23':
- $rand_value = 'w';
- break;
- case '24':
- $rand_value = 'x';
- break;
- case '25':
- $rand_value = 'y';
- break;
- case '26':
- $rand_value = 'z';
- break;
- case '27':
- $rand_value = '0';
- break;
- case '28':
- $rand_value = '1';
- break;
- case '29':
- $rand_value = '2';
- break;
- case '30':
- $rand_value = '3';
- break;
- case '31':
- $rand_value = '4';
- break;
- case '32':
- $rand_value = '5';
- break;
- case '33':
- $rand_value = '6';
- break;
- case '34':
- $rand_value = '7';
- break;
- case '35':
- $rand_value = '8';
- break;
- case '36':
- $rand_value = '9';
- break;
- case '37':
- $rand_value = '*';
- break;
- case '38':
- $rand_value = '~';
- break;
- case '39':
- $rand_value = '-';
- break;
- case '40':
- $rand_value = '|';
- break;
- case '41':
- $rand_value = '^';
- break;
- case '42':
- $rand_value = '%';
- break;
- case '43':
- $rand_value = ' ';
- break;
- case '44':
- $rand_value = '_';
- break;
- case '45':
- $rand_value = '+';
- break;
- case '46':
- $rand_value = '=';
- break;
- case '47':
- $rand_value = 'A';
- break;
- case '48':
- $rand_value = 'B';
- break;
- case '49':
- $rand_value = 'C';
- break;
- case '50':
- $rand_value = 'D';
- break;
- case '51':
- $rand_value = 'E';
- break;
- case '52':
- $rand_value = 'F';
- break;
- case '53':
- $rand_value = 'G';
- break;
- case '54':
- $rand_value = 'H';
- break;
- case '55':
- $rand_value = 'I';
- break;
- case '56':
- $rand_value = 'J';
- break;
- case '57':
- $rand_value = 'K';
- break;
- case '58':
- $rand_value = 'L';
- break;
- case '59':
- $rand_value = 'M';
- break;
- case '60':
- $rand_value = 'N';
- break;
- case '61':
- $rand_value = 'O';
- break;
- case '62':
- $rand_value = 'P';
- break;
- case '63':
- $rand_value = 'Q';
- break;
- case '64':
- $rand_value = 'R';
- break;
- case '65':
- $rand_value = 'S';
- break;
- case '66':
- $rand_value = 'T';
- break;
- case '67':
- $rand_value = 'U';
- break;
- case '68':
- $rand_value = 'V';
- break;
- case '69':
- $rand_value = 'W';
- break;
- case '70':
- $rand_value = 'X';
- break;
- case '71':
- $rand_value = 'Y';
- break;
- case '72':
- $rand_value = 'Z';
- break;
- }
- return $rand_value;
- }
- if($job=="Ketua" || $job=="Wakil" || $job=="Koor. Divisi Sekretaris"){
- $hak=1;
- }
- else{
- $hak=0;
- }
- $source = $tgl;
- $date = new DateTime($source);
- $birth = $date->format('dmY');
- //echo $birth;
- $countchar = strlen($nimhs);
- //ambil random salt
- $result = genKey($countchar);
- $pas = $birth;
- $passalt = $pas.$result;
- $hash = md5($passalt);
- $sql2 = "insert into login2(username,password,salt,hak) values('$nimhs','$hash','$result','$hak');";
- //echo $sql2;
- $conn->exec($sql2);
- if($sql2){
- echo "<script>alert('Tambah Data Berhasil!')</script>";
- }
- else{
- echo "<script>alert('Gabisa jir!')</script>";
- }
- }
- ?>
- </body>
- </html>
- <!-- admin-falkes.php -->
- <?php
- session_start();
- if(($_SESSION['STATUS']!==1)){
- header("location:index.php");
- }
- else{
- }
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <link rel="shortcut icon" href="images/medic.ico" />
- <link rel="stylesheet" type="text/css" href="main.css">
- <script type="text/javascript" src="js/jquery-1.11.3.min.js"></script>
- <script type="text/javascript" src="js/bootstrap.min.js"></script>
- <link rel="stylesheet" type="text/css" href="css/bootstrap.min.css">
- <link rel="stylesheet" type="text/css" href="css/bootstrap-theme.min.css">
- <link rel="stylesheet" type="text/css" href="css/dataTables.bootstrap.min.css">
- <script type="text/javascript" src="js/jquery.dataTables.min.js"></script>
- <script type="text/javascript" src="js/dataTables.bootstrap.min.js"></script>
- <title>UMN MEDICAL CENTER</title>
- <style>
- .modal-black {
- background: #ffffff;
- }
- </style>
- <script>
- function format ( d ) {
- return '<table class="table table-striped" cellpadding="5" cellspacing="0" border="0" style="padding-left:50px;">'+
- '<tr>'+
- '<td>NIM : </td>'+
- '<td>'+d.nimPen+'</td>'+
- '</tr>'+
- '<tr>'+
- '<td>No. HP : </td>'+
- '<td>'+d.phPen+'</td>'+
- '</tr>'+
- '<tr>'+
- '<td>ID Line : </td>'+
- '<td>'+d.linePen+'</td>'+
- '</tr>'+
- '<tr>'+
- '<td>Deskripsi : </td>'+
- '<td>'+d.dscrPen+'</td>'+
- '</tr>'+
- '<tr>'+
- '<td>Alat/Obat : </td>'+
- '<td>'+d.alkesPen+'</td>'+
- '</tr>'+
- '</table>';
- }
- $(document).ready(function() {
- var table = $('#myTable').DataTable( {
- "columns": [
- {
- "className": 'details-control',
- "orderable": false,
- "data": null,
- "defaultContent": ''
- },
- { "data": "idPen" }, //1
- { "data": "evPen" }, //2
- { "data": "namePen" }, //3
- { "data": "nimPen" }, //4
- { "data": "phPen" }, //5
- { "data": "linePen" }, //6
- { "data": "orgPen" }, //7
- { "data": "datePen" }, //8
- { "data": "timePen" }, //9
- { "data": "dscrPen" }, //10
- { "data": "alkesPen" }, //11
- { "data": "statPen" }, //12
- { "data": "udPen" } //13
- ],
- "order": [[1, 'asc']],
- "columnDefs": [
- { "visible": false, "targets": [4,5,6,10,11] }
- ]
- } );
- $('#myTable tbody').on('click', 'td.details-control', function () {
- var tr = $(this).closest('tr');
- var row = table.row( tr );
- if ( row.child.isShown() ) {
- row.child.hide();
- tr.removeClass('shown');
- }
- else {
- row.child( format(row.data()) ).show();
- tr.addClass('shown');
- }
- } );
- } );
- </script>
- </script>
- <style>
- .carousel-inner > .item > img,
- .carousel-inner > .item > a > img {
- width: 70%;
- margin: auto;
- }
- </style>
- </head>
- <body>
- <div id="Modal" class="modal modal-black" tabindex="1" role="dialog">
- <div class="modal-dialog" role="document">
- <div class="modal-content">
- <div class="modal-body">
- <h1 class="text-center login-title">Please Sign In</h1>
- <div class="form-group">
- <form class="form-signin" method="POST" action="admin-falkes.php">
- <input id="username" name="username" type="text" class="form-control" placeholder="Username" required autofocus>
- <input id="password" name="password" type="password" class="form-control" placeholder="Password" required>
- <button name="signin" class="btn btn-lg btn-primary btn-block" type="submit">
- Sign in</button>
- </form>
- </div>
- </div>
- </div>
- </div>
- </div>
- <script type="text/javascript">
- $(document).ready(function(){
- $('#myTable').DataTable();
- });
- </script>
- <nav class='navbar navbar-default'>
- <div class='container'>
- <div class='navbar-header'>
- <a href='#' class='navbar-brand' style='color:green;'><b>UMN MEDICAL CENTER [Admin-Mode]</b></a>
- </div>
- <ul class='nav navbar-nav'>
- <li><a href='admin-medis.php'>Pengajuan Jasa Medis</a></li>
- <li class='active'><a href='admin-falkes.php'><strong>Peminjaman Alkes/Obat</strong></a></li>
- <li><a href='admin-member.php'>Info Anggota</a></li>
- <li><a href='admin-obat.php'>Info Obat</a></li>
- <li><a href='admin-jadwal.php'>Info Jadwal</a></li>
- </ul>
- <ul class="nav navbar-nav navbar-right">
- <li><a href="logout.php">Log Out</a></li>
- </ul>
- </nav>
- </div>
- <?php
- $username = "root";
- $password = "";
- $conn = new PDO('mysql:host=localhost;dbname=medic',$username,$password);
- $data = $conn->query("select id, acara, namalengkap, nim, phone, lineid, organisasi, date_format(tanggal,'%d-%m-%Y'), TIME_FORMAT(waktu,'%H:%i'), dscr, alob, status from falkes");
- echo"
- <div class='container'>
- <div class='row'>
- <div class='col-xs-10 col-xs-offset-1'>
- <table id='myTable' style='border: 1px solid black; border-collapse: collapse;' class='table table-bordered table-striped'>
- <thead>
- <tr>
- <th></th>
- <th>ID</th>
- <th>Event</th>
- <th>Nama Pengaju</th>
- <th>NIM</th>
- <th>Phone Number</th>
- <th>Line ID</th>
- <th>Organisasi</th>
- <th>Date</th>
- <th>Time</th>
- <th>Description</th>
- <th>Alkes & Obat</th>
- <th>Status</th>
- <th></th>
- </tr>
- </thead>
- <tbody>";
- foreach ($data as $row) {
- echo "<tr>";
- echo "<td style='width:40px;'></td>";
- echo "<td>".$row[0]."</td>";
- echo "<td>".$row[1]."</td>";
- echo "<td>".$row[2]."</td>";
- echo "<td>".$row[3]."</td>";
- echo "<td>".$row[4]."</td>";
- echo "<td>".$row[5]."</td>";
- echo "<td>".$row[6]."</td>";
- echo "<td>".$row[7]."</td>";
- echo "<td>".$row[8]."</td>";
- echo "<td>".$row[9]."</td>";
- echo "<td>".$row[10]."</td>";
- echo "<td>".$row[11]."</td>";
- echo "<td><center>
- <a href='#editModalfal'
- class='btn btn-warning open-edit_fal'
- data-toggle='modal'
- data-idf='".$row[0]."'
- data-namaf='".$row[1]."'
- data-tanggalf='".$row[7]."'
- data-waktuf='".$row[8]."'
- data-descf='".$row[9]."'
- data-alobf='".$row[10]."'
- data-statusf='".$row[11]."'>Edit</a>
- <a href='#deleteModalfal' class='btn btn-danger open-delete_fal'
- data-toggle='modal'
- data-idfal='".$row[0]."'
- >Delete</a>
- </center></td>";
- echo "</tr>";
- }
- echo"
- </tbody>
- </table>
- </div>
- </div>
- </div>
- ";
- ?>
- <script type="text/javascript">
- $(document).on("click", ".open-edit_fal", function(){
- var idf = $(this).data('idf');
- var namaf = $(this).data('namaf');
- var tanggalf = $(this).data('tanggalf');
- var waktuf = $(this).data('waktuf');
- var descf = $(this).data('descf');
- var alobf = $(this).data('alobf');
- var statusf = $(this).data('statusf');
- $('#idfal').val(idf);
- $('#namefal').val(namaf);
- $('#tglfal').val(tanggalf);
- $('#wktfal').val(waktuf);
- $('#descfal').val(descf);
- $('#alobfal').val(alobf);
- $('#sttsfal').val(statusf);
- });
- </script>
- <div id="editModalfal" class="modal" tabindex="1" role="dialog">
- <div class="modal-dialog" role="document">
- <div class="modal-content">
- <div class="modal-body">
- <button type="button" class="close" data-dismiss="modal">×</button>
- <h1 class="text-center login-title">Update Data</h1>
- <div class="form-group">
- <form class="form-signin" method="POST" action="edit-falkes.php">
- <input id="idfal" name="idfal" type="hidden" />
- <label for="namefal">Nama Acara</label>
- <input id="namefal" name="namefal" type="text" class="form-control" required autofocus>
- <br>
- <label for="tglfal">Tanggal</label>
- <input id="tglfal" name="tglfal" type="text" class="form-control" required>
- <br>
- <label for="wktfal">Waktu</label>
- <input id="wktfal" name="wktfal" type="text" class="form-control" required>
- <br>
- <label for="descfal">Deskripsi</label>
- <input id="descfal" name="descfal" type="text" class="form-control" required>
- <br>
- <label for="alobfal">Alkes/Obat</label>
- <input id="alobfal" name="alobfal" type="text" class="form-control" required>
- <br>
- <label for="sttsfal">Status</label>
- <input id="sttsfal" name="sttsfal" type="text" class="form-control" required>
- <br><br>
- <button name="update" class="btn btn-lg btn-primary btn-block" type="submit">Update</button>
- </form>
- </div>
- </div>
- </div>
- </div>
- </div>
- <script type="text/javascript">
- $(document).on("click", ".open-delete_fal", function(){
- var idf2 = $(this).data('idfal');
- $('#idfal2').val(idf2);
- });
- </script>
- <div id="deleteModalfal" class="modal" tabindex="1" role="dialog">
- <div class="modal-dialog" role="document">
- <div class="modal-content">
- <div class="modal-body">
- <button type="button" class="close" data-dismiss="modal">×</button>
- <h1 class="text-center login-title">Delete Data</h1>
- <div class="form-group">
- <form class="form-signin" method="POST" action="delete-falkes.php">
- <input id="idfal2" name="idfal2" type="hidden" />
- <h3><center>Apakah Anda yakin ingin menghapus data ini?</center></h3>
- <br><br>
- <button name="delete" class="btn btn-lg btn-danger btn-block" type="submit">Delete</button>
- </form>
- </div>
- </div>
- </div>
- </div>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement