Gecko [ elibrary.unsap.ac.id ]

Name	Size	Permission	Date
.git	[ DIR ]	drwxrwxrwx	2025-04-27 13:16
.well-known	[ DIR ]	drwxrwxrwx	2024-09-05 02:01
asset	[ DIR ]	drwxrwxrwx	2025-04-27 15:34
include	[ DIR ]	drwxrwxrwx	2025-04-20 13:23
resource	[ DIR ]	drwxrwxrwx	2025-04-21 15:02
save	[ DIR ]	drwxrwxrwx	2025-04-21 13:47
upload	[ DIR ]	drwxrwxrwx	2025-02-11 02:56
Backup_13_Jan_2025_1736756652.sql	0 B	-rw-rw-rw-	2025-04-20 13:22
README.md	1.52 KB	-rw-rw-rw-	2024-09-07 01:58
admin.php	6.35 KB	-rw-rw-rw-	2024-09-04 22:54
agenda_surat_keluar.php	17 KB	-rw-rw-rw-	2024-09-04 22:54
agenda_surat_masuk.php	17.09 KB	-rw-rw-rw-	2024-09-04 22:54
backup.php	9.09 KB	-rw-rw-rw-	2024-09-04 22:54
cetak_disposisi.php	12.88 KB	-rw-rw-rw-	2024-09-04 22:54
disposisi.php	11.53 KB	-rw-rw-rw-	2024-09-04 22:54
edit_disposisi.php	12.92 KB	-rw-rw-rw-	2024-09-04 22:54
edit_klasifikasi.php	9.94 KB	-rw-rw-rw-	2024-09-04 22:54
edit_surat_keluar.php	22.76 KB	-rw-rw-rw-	2024-09-04 22:54
edit_surat_masuk.php	23.54 KB	-rw-rw-rw-	2024-09-04 22:54
edit_tipe_user.php	8.92 KB	-rw-rw-rw-	2024-09-04 22:54
enable-javascript.html	3.4 KB	-rw-rw-rw-	2024-09-04 22:54
file_sk.php	10.32 KB	-rw-rw-rw-	2024-09-04 22:54
file_sm.php	10.61 KB	-rw-rw-rw-	2024-09-04 22:54
fti-aset.sql	37.22 KB	-rw-rw-rw-	2024-09-05 02:19
galeri_sk.php	17.88 KB	-rw-rw-rw-	2024-09-04 22:54
galeri_sm.php	17.91 KB	-rw-rw-rw-	2024-09-04 22:54
google3afbb06bed30a512.html	53 B	-rw-rw-rw-	2025-04-27 15:35
hapus_disposisi.php	4.86 KB	-rw-rw-rw-	2024-09-04 22:54
hapus_klasifikasi.php	4.15 KB	-rw-rw-rw-	2024-09-04 22:54
hapus_surat_keluar.php	6.94 KB	-rw-rw-rw-	2024-09-04 22:54
hapus_surat_masuk.php	7.02 KB	-rw-rw-rw-	2024-09-04 22:54
hapus_user.php	5.49 KB	-rw-rw-rw-	2024-09-04 22:54
index.php	11.43 KB	-rw-rw-rw-	2024-09-04 22:54
kode.php	847 B	-rw-rw-rw-	2025-02-01 14:35
logout.php	92 B	-rw-rw-rw-	2024-09-04 22:54
pengaturan.php	25.78 KB	-rw-rw-rw-	2024-09-04 22:54
profil.php	15.59 KB	-rw-rw-rw-	2024-09-04 22:54
referensi.php	22.04 KB	-rw-rw-rw-	2024-09-04 22:54
restore.php	10.75 KB	-rw-rw-rw-	2024-09-04 22:54
robots.txt	323 B	-rw-rw-rw-	2025-04-27 15:41
surat-fti.sql	11.87 KB	-rw-rw-rw-	2024-09-05 02:17
tambah_disposisi.php	11.71 KB	-rw-rw-rw-	2024-09-04 22:54
tambah_klasifikasi.php	9.83 KB	-rw-rw-rw-	2024-09-04 22:54
tambah_surat_keluar.php	19.99 KB	-rw-rw-rw-	2024-09-04 22:54
tambah_surat_masuk.php	21.77 KB	-rw-rw-rw-	2024-09-04 22:54
tambah_user.php	12.69 KB	-rw-rw-rw-	2024-09-04 22:54
transaksi_surat_keluar.php	25.79 KB	-rw-rw-rw-	2024-09-04 22:54
transaksi_surat_masuk.php	27.32 KB	-rw-rw-rw-	2024-09-04 22:54
upload_referensi.php	11.5 KB	-rw-rw-rw-	2024-09-04 22:54
user.php	10.28 KB	-rw-rw-rw-	2024-09-04 22:54
web.config	655 B	-rw-rw-rw-	2024-09-07 01:34

Rename

<?php
    //cek session
    if(empty($_SESSION['admin'])){
        $_SESSION['err'] = '<center>Anda harus login terlebih dahulu!</center>';
        header("Location: ./");
        die();
    } else {

if($_SESSION['admin'] != 1 AND $_SESSION['admin'] != 2){
            echo '<script language="javascript">
                    window.alert("ERROR! Anda tidak memiliki hak akses untuk membuka halaman ini");
                    window.location.href="./logout.php";
                  </script>';
        } else {

//proses upload file
            if(isset($_POST['submit'])){

$file = $_FILES['file']['tmp_name'];

if($file == ""){
                    $_SESSION['errEmpty'] = 'ERROR! Form File tidak boleh kosong';
                    header("Location: ./admin.php?page=ref&act=imp");
                    die();
                } else {

$x = explode('.', $_FILES['file']['name']);
                    $eks = strtolower(end($x));

if($eks == 'csv'){

//jika tidak ingin menghapus data yang sudah ada
                        if(isset($_REQUEST['cek'])){

//upload file
                            if(is_uploaded_file($file)){
                                $_SESSION['succUpload'] = 'SUKSES! Data berhasil diimport';
                            } else {
                                $_SESSION['errUpload'] = 'ERROR! Proses upload data gagal';
                                header("Location: ./admin.php?page=ref&act=imp");
                                die();
                            }

//membuka file csv
                            $handle = fopen($file, "r");
                            $id_user = $_SESSION['id_user'];

//parsing file csv
                            while(($data = fgetcsv($handle, 1000, ",")) !== FALSE){

//insert data ke dalam database
                                $query = mysqli_query($config, "INSERT into tbl_klasifikasi(id_klasifikasi,kode,nama,uraian,id_user) values(null,'$data[1]','$data[2]','$data[3]','$id_user')");
                            }
                            fclose($handle);
                            header("Location: ./admin.php?page=ref");
                            die();
                        } else {

//mengosongkan table klasifikasi
                            mysqli_query($config, "TRUNCATE TABLE tbl_klasifikasi");

//membuka file csv
                            $handle = fopen($file, "r");
                            $id_user = $_SESSION['id_user'];

//parsing file csv
                            while(($data = fgetcsv($handle, 1000, ",")) !== FALSE){

//insert data ke dalam database
                                $query = mysqli_query($config, "INSERT into tbl_klasifikasi(id_klasifikasi,kode,nama,uraian,id_user) values('$data[0]','$data[1]','$data[2]','$data[3]','$id_user')");
                            }
                            fclose($handle);
                            header("Location: ./admin.php?page=ref");
                            die();
                        }

} else {
                        $_SESSION['errFormat'] = 'ERROR! Format file yang diperbolehkan hanya *.CSV';
                        header("Location: ./admin.php?page=ref&act=imp");
                        die();
                    }
                }
            }

echo '
                
                <div class="row">
                    
                    <div class="col s12">
                        <div class="z-depth-1">
                            <nav class="secondary-nav">
                                <div class="nav-wrapper blue-grey darken-1">
                                    <div class="col m12">
                                        <ul class="left">
                                            <li class="waves-effect waves-light"><a href="?page=ref&act=imp" class="judul"><i class="material-icons">bookmark</i> Import Referensi Surat</a></li>
                                            <li class="waves-effect waves-light"><a href="?page=ref"><i class="material-icons">arrow_back</i> Kembali</a></li>
                                        </ul>
                                    </div>
                                </div>
                            </nav>
                        </div>
                    </div>
                    
                </div>
                ';

if(isset($_SESSION['errFormat'])){
                    $errFormat = $_SESSION['errFormat'];
                    echo '<div id="alert-message" class="row">
                            <div class="col m12">
                                <div class="card red lighten-5">
                                    <div class="card-content notif">
                                        <span class="card-title red-text"><i class="material-icons md-36">clear</i> '.$errFormat.'</span>
                                    </div>
                                </div>
                            </div>
                        </div>';
                    unset($_SESSION['errFormat']);
                }
                if(isset($_SESSION['errUpload'])){
                    $errUpload = $_SESSION['errUpload'];
                    echo '<div id="alert-message" class="row">
                            <div class="col m12">
                                <div class="card red lighten-5">
                                    <div class="card-content notif">
                                        <span class="card-title red-text"><i class="material-icons md-36">clear</i> '.$errUpload.'</span>
                                    </div>
                                </div>
                            </div>
                        </div>';
                    unset($_SESSION['errUpload']);
                }
                if(isset($_SESSION['errEmpty'])){
                    $errEmpty = $_SESSION['errEmpty'];
                    echo '<div id="alert-message" class="row">
                            <div class="col m12">
                                <div class="card red lighten-5">
                                    <div class="card-content notif">
                                        <span class="card-title red-text"><i class="material-icons md-36">clear</i> '.$errEmpty.'</span>
                                    </div>
                                </div>
                            </div>
                        </div>';
                    unset($_SESSION['errEmpty']);
                }

echo '
                
                <div class="row">
                    <div class="col m12">
                        <div class="card">
                            <div class="card-content">
                                <span class="card-title black-text">Import Referensi Kode Klasifikasi Surat</span>
                                <p class="kata">Silakan pilih file referensi kode klasifikasi berformat *.csv (file excel) lalu klik tombol <strong>"Import"</strong> untuk melakukan import file. Contoh format file csv bisa di download melalui link dibawah ini.</p><br/>';

// download file contoh format csv
                                if(isset($_REQUEST['download'])){

$dir = "./asset/";
                                    $file = $dir."contoh_format.csv";

if(file_exists($file)){
                                        header('Content-Description: File Transfer');
                                        header('Content-Type: application/octet-stream');
                                        header('Content-Disposition: attachment; filename="contoh_format.csv"');
                                        header('Content-Transfer-Encoding: binary');
                                        header('Expires: 0');
                                        header('Cache-Control: private');
                                        header('Pragma: private');
                                        header('Content-Length: ' . filesize($file));
                                        ob_clean();
                                        flush();
                                        readfile($file);
                                        exit;
                                    }
                                } echo '

<p>
                                    <form method="post" enctype="multipart/form-data" >
                                        <a href="?page=ref&act=imp&download" name="download" class="waves-effect waves-light blue-text"><i class="material-icons">file_download</i> <strong>DOWNLOAD CONTOH FORMAT FILE CSV</strong></a>
                                    </form>
                                </p><br/>

<p class="kata"><span class="red-text"><i class="material-icons">error_outline</i> <strong>PERINGATAN!</strong></span><br/>Secara default, data yang ada akan diganti dengan data yang baru. Jika tidak ingin menghapus data yang sudah ada, silakan centang checkbox <i class="material-icons">check_box_outline_blank</i> dibawah form file.</p>
                            </div>
                            <div class="card-action">
                                <form method="post" enctype="multipart/form-data">
                                    <div class="file-field input-field col m6 tooltipped" data-position="top" data-tooltip="Format file yang diperbolehkan hanya *.CSV">
                                        <div class="btn light-green darken-1">
                                            <span>File</span>
                                            <input type="file" name="file" accept=".csv" required>
                                        </div>
                                        <div class="file-path-wrapper">
                                            <input class="file-path validate" placeholder="Upload file csv referensi kode klasifikasi" type="text">
                                         </div>
                                    </div>&nbsp;&nbsp;&nbsp;&nbsp;
                                    <div class="col m12" style="margin-bottom: 25px;">
                                        <input type="checkbox" id="cek" name="cek">
                                        <label for="cek" class="kata" style="color: #444;">Centang jika tidak ingin menghapus data yang sudah ada</label>
                                    </div>
                                    <button type="submit" class="btn-large blue waves-effect waves-light" name="submit">IMPORT <i class="material-icons">file_upload</i></button>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>';
            }
        }
?>