KAR

<h3 class='ml-2 page-header'><b><i class="fas fa-user"></i>&nbsp;&nbsp;Daftar Karyawan</b></h3>
<?php
if (isset($_GET['st'])) {
    if ($_GET['st']==1) {
        echo "<div class='alert alert-warning'><strong>Berhasil Disimpan.</strong></div>";
    } elseif ($_GET['st']==2) {
        echo "<div class='alert alert-danger'><strong>Gagal Menyimpan.</strong></div>";
    } elseif ($_GET['st']==3) {
        echo "<div class='alert alert-success'><strong>Berhasil dihapus.</strong></div>";
    } elseif ($_GET['st']==4) {
        echo "<div class='alert alert-danger'><strong>Data tidak boleh kosong.</strong></div>";
    } elseif ($_GET['st']==5) {
        echo "<div class='alert alert-danger'><strong>Gagal dihapus.</strong></div>";
    }
}
?>
<div class='table-responsive'>
    <?php
    if (isset($_GET['id_kar'])) {
        if ($_GET['id_kar']!=="") {
            $id_user=$_GET['id_kar'];
            include './view/adm/edit_kar.php';
        } else {
            header("location:kar");
        }
    } else {
        $limit = 10;
        $start = 1;
        $slice = 9;
        $self_server = "./kar";
        $q = "SELECT * FROM detail_user ORDER BY id_user ASC";
        $r = $conn->query($q);
        $totalrows = $r->num_rows;

        if(!isset($_GET['pn']) || !is_numeric($_GET['pn'])){
            $page = 1;
        } else {
            $page = $_GET['pn'];
        }

        $numofpages = ceil($totalrows / $limit);
        $limitvalue = $page * $limit - ($limit);

        $q = "SELECT*FROM detail_user ORDER BY div_user ASC LIMIT $limitvalue, $limit";
//jika user nakal paging lebih dari data yg dimiliki
        $cek_page = $conn->query($q);
        if ($cek_page->num_rows != 0) {
            if ($r = $conn->query($q)) {

                if ($r->num_rows!==0) {
                    echo "<table class='table table-striped table-bordered' id='table' style='width:70% text-align:center'>
                    <thead>
                    <tr>
                    <th style='text-align:center'>No</th>
                    <th style='text-align:center'>Nama Karyawan</th>
                    <th style='text-align:center'>Divisi</th>
                    <th style='text-align:center'>Aksi</th>
                    <th style='text-align:center'>Rekap</th>
                    </tr>
                    </thead>
                    <tbody>";
                    $query_kar = $conn->query($q);
                    $no=0;
                    while ($get_kar = $query_kar->fetch_assoc()) {
                        $npk_user = $get_kar['npk_user'];
                        $id_kar = $get_kar['id_user'];
                        $name = $get_kar['name_user'];
                        $school = $get_kar['div_user'];
                        $no++;
                        echo "<tr>
                        <td style='text-align:center'>$no</td>
                        <td style='text-align:center'>$name</td>
                        <td style='text-align:center'><strong>$school</strong></td>
                        <td style='text-align:center'>
                        <a href='kar&id_kar=$id_kar' title='Edit $name'><button type='submit' class='btn btn-primary'>Edit</button></a> &nbsp; &bullet; &nbsp;
                        <button type='submit' title='Hapus $name' class='btn btn-danger' onclick='hapusKar($id_kar)' >Hapus</button>
                        </td>
                        <td style='text-align:center'>
                        <a class='btn btn-danger text text-white mr-2'  title='Cetak PDF $name' href='rekap&npk_user=$npk_user' >PDF</a> &nbsp;&bullet;&nbsp;
                        <a class='btn btn-success' name='submit'  title='Cetak Excel $name' href='./report/rek_excel_personal.php'>Excel</a>
                        </td>
                        </tr>";
                    }
                   // $conn->close();
                    echo "</tbody></table>";

                } else {
                    echo "<hr />";
                }

            } else {
                echo "<div class='alert alert-danger'><strong>Terjadi kesalahan.</strong></div>";
            }

            $sql_cek_row = "SELECT*FROM detail_user";
            $q_cek = $conn->query($sql_cek_row);
            $hitung = $q_cek->num_rows;
            if ($hitung >= $limit) {
                echo "<hr><ul class='pagination'>";
                if($page!= 1){
                    $pageprev = $page - 1;
                    echo '<li><a href="'.$self_server.'&pn='.$pageprev.'"><<</a></li>';
                }else{
                    echo "<li><a><<</a></li>";
                }

                if (($page + $slice) < $numofpages) {
                    $this_far = $page + $slice;
                } else {
                    $this_far = $numofpages;
                }

                if (($start + $page) >= 10 && ($page - 10) > 0) {
                    $start = $page - 10;
                }

                for ($i = $start; $i <= $this_far; $i++){
                    if($i == $page){
                        echo "<li class='active'><a>".$i."</a></li> ";
                    }else{
                        echo '<li><a href="'.$self_server.'&pn='.$i.'">'.$i.'</a></li> ';
                    }
                }

                if(($totalrows - ($limit * $page)) > 0){
                    $pagenext = $page + 1;
                    echo '<li><a href="'.$self_server.'&pn='.$pagenext.'">>></a></li>';
                }else{
                    echo "<li><li><a>>></a></li>";
                }
                echo "</ul>";
            }
        } else {
            echo "<div class='alert alert-danger'><strong>Tidak ada data untuk ditampilkan</strong></div>";
        }
    }
    ?>
</div>
</body>
</html>
<!-- LINK JS DATA TABLE NYA JADI INI LINK JS NYA GA BISA DI TARO DI MEDIA NANTI GA BISA LOGOUT -->
<!-- KALI MAU BUAT DATA TABLE BARU LINK JS NYA JUGA DI COPY :) -->
<!-- HAPPY CODING -->
<script type="text/javascript" src="./lib/dt/DataTables/media/js/jquery.js"></script>
<script type="text/javascript" src="./lib/dt/DataTables/media/js/jquery.dataTables.js"></script>


<script type="text/javascript">
    $(document).ready(function(){
        $.noConflict();
        var table = $('#table').DataTable({
            "paging": false,
            "ordering": false,
            "info" :false
        });
    });
</script>

<!-- TESERAH LU MAU PAKE YANG ATAS ATAU YANG BAWA SCRIPT JS NYA -->
<!-- KALI YANG ATAAS GA ADA SORTING NYA SAMA PAGINATION  -->
<!-- <script type="text/javascript">
    $(document).ready(function(){
        $.noConflict();
        var table = $('#table').DataTable();
    });
</script> -->

<!-- AKHIR DATA TABLE -->

</body>
</html>
<script src="lib/js/sweetalert2.min.js"></script> <link rel="stylesheet" type="text/css" href="lib/js/sweetalert2.css">

<script>
    function hapusKar(id_kar) {
        var id = id_kar;
        swal({
            title: 'Anda Yakin?',
            text: 'Semua data Karyawab akan dihapus!',type: 'warning',
            showCancelButton: true,
            confirmButtonColor: '#3085d6',
            cancelButtonColor: '#d33',
            confirmButtonText: 'Hapus',
            cancelButtonText: 'Batal',
            closeOnConfirm: true
        }, function() {
            window.location.href="./model/proses.php?del_kar="+id;
        });
    }
</script>
<!-- <script>
function confirmSubmit() {
    var msg;
    msg = "Apakah Anda Yakin Akan Menghapus Data ? ";
    var agree=confirm(msg);
    if (agree)
    return true ;
    else
    return false ;
}
</script> -->