view_search.php

<?php
/**
 * Created by PhpStorm.
 * User: oimtrust
 * Date: 08/09/17
 * Time: 9:39
 */?>

<div class="container">
    <div class="row">
        <div class="col s12 m12 l12">
            <div class="card red darken-1">
                <div class="card-content white-text">
                    <span class="card-title">Daftar Antrian Email @unikama.ac.id</span>
                    Bagi pendaftar email dengan status GAGAL, mohon segera mendaftar ulang dengan memperhatikan aturan layanan email yang ada. Terima Kasih !!!.
                    <ol>
                        <li>
                            Alamat email harus @unikama.ac.id
                        </li>
                        <li>
                            Nomor Handphone wajib diisi. Digunakan untuk verifikasi password jika user lupa passwordnya.
                        </li>
                        <li>
                            Apabila status anda <b class="yellow-text">GAGAL</b> segera hubungi pihak MSI untuk memastikan bahwa anda akan mendaftar ulang. Maka data anda yang kami anggap gagal akan kami hapus.
                            Hal ini dikarenakan apabila belum dihapus anda tidak bisa melakukan pendaftaran lagi.
                        </li>
                    </ol>
                </div>
            </div>
        </div>
    </div>

    <?php
    if (isset($error)) {
        foreach ($error as $error) {
            ?>
            <div class="row alert_box">
                <div class="col s12">
                    <div class="card red darken-2">
                        <div class="row">
                            <div class="col s9">
                                <div class="card-content white-text">
                                    <?php echo $error; ?>
                                </div>
                            </div>
                            <div class="col s3 white-text">
                                <i class="mdi mdi-close close right alert_close" aria-hidden="true"></i>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <?php
        }
    }?>

    <form method="post">
        <div class="row">
            <div class="right">
                <div class="input-field inline">
                    <input id="search" type="text" name="search" class="validate">
                    <label for="search">Cari NPM</label>
                </div>
                <button name="btn_search" type="submit" class="btn btn-floating purple accent-3 waves-light waves-effect tooltipped" data-position="bottom" data-delay="50" data-tooltip="Cari"><i class="mdi mdi-account-search"></i> </button>
            </div>
        </div>

        <div class="row">
            <table class="responsive-table highlight">
                <thead>
                <tr>
                    <th>#</th>
                    <th>NIDN/NIPP/NPM</th>
                    <th>Nama</th>
                    <th>Email</th>
                    <th>Handphone</th>
                    <th>Tgl. Daftar</th>
                    <th>Tgl. Diproses</th>
                    <th>Status</th>
                </tr>
                </thead>

                <tbody>
                <?php
                $limit  = 20;
                $pagination = isset($_GET['pagination']) ? $_GET['pagination'] : "";

                if (empty($pagination)){
                    $position   = 0;
                    $pagination = 1;
                }
                else{
                    $position   = ($pagination - 1) * $limit;
                }

                $query = $connect->execute("SELECT code_id, CONCAT(first_name, ' ', last_name) AS nama,
                    email_asked, phone, status, created_at, updated_at FROM tbl_register_email LIMIT $position, $limit");

                $no = 1 + $position;

                if (isset($_POST['btn_search'])){
                    $code_id    = $_POST['search'];

                    if ($code_id == ''){
                        $error[]    = "Tidak ada data yang anda cari";
                    }
                    else{
                        if ($code_id != ''){
                            $query = $connect->execute("SELECT code_id, CONCAT(first_name, ' ', last_name) AS nama,
                    email_asked, phone, status, created_at, updated_at FROM tbl_register_email WHERE code_id LIKE '%$code_id%'");
                        }
                        else{
                            $query = $connect->execute("SELECT code_id, CONCAT(first_name, ' ', last_name) AS nama,
                    email_asked, phone, status, created_at, updated_at FROM tbl_register_email LIMIT $position, $limit");
                        }
                    }
                }
                else{
                    $query = $connect->execute("SELECT code_id, CONCAT(first_name, ' ', last_name) AS nama,
                    email_asked, phone, status, created_at, updated_at FROM tbl_register_email LIMIT $position, $limit");
                }

                $check_search = $query->num_rows;

                if ($check_search < 1){
                    ?>
                    <tr>
                        <td colspan="8" class="center">Data Tidak Ditemukan</td>
                    </tr>
                    <?php
                }
                else {
                    while ($data = $query->fetch_object()){

                        if ($data->status == 'DALAM ANTRIAN'){
                            $color = "yellow";
                        }
                        elseif ($data->status == 'SELESAI'){
                            $color = "green";
                        }
                        else {
                            $color = "red";
                        }
                        ?>
                        <tr class="<?php if($no % 2 == 0) {echo "odd";} else {echo "even";} ?>">
                            <th scope="row"><?php echo $no;?></th>
                            <td><?php echo $data->code_id;?></td>
                            <td><?php echo $data->nama;?></td>
                            <td><?php echo $data->email_asked;?></td>
                            <td>
                                <?php
                                $phone = $data->phone;
                                echo substr($phone, 0, -3) . 'xxx';
                                ?>
                            </td>
                            <td><?php echo $data->created_at;?></td>
                            <td><?php echo $data->updated_at;?></td>
                            <td class="<?php echo $color;?>">
                                <?php
                                echo $data->status;
                                ?>
                            </td>
                        </tr>
                        <?php
                        $no++;
                    }
                }
                ?>
                </tbody>
            </table>
            <?php
            $amount_data = $connect->execute("SELECT * FROM tbl_register_email");
            $rows = $amount_data->num_rows;

            $amount_page = ceil($rows / $limit);

            if ($pagination > 1){
                $link = $pagination -1;
                $prev = "<a href='".$baseUrl."index.php?page=home&action=queue&pagination=".$link."' class='btn purple'><i class='white-text material-icons'>chevron_left</i></a>";
            }
            else {
                $prev = "<a href='#' class='btn purple'><i class='white-text material-icons'>chevron_left</i></a>";
            }

            if ($pagination < $amount_page) {
                $link = $pagination + 1;
                $next = "<a href='".$baseUrl."index.php?page=home&action=queue&pagination=".$link."' class='btn purple'><i class='white-text material-icons'>chevron_right</i></a>";
            }
            else {
                $next = "<a href='#' class='btn purple'><i class='white-text material-icons'>chevron_right</i></a>";
            }

            echo "<ul class='pagination'>
                <li class='waves-effect left'>".$prev."</li>
                <li class='waves-effect right'>".$next."</li>
            </ul>";
            ?>
        </div>
    </form>
</div>

<script type="text/javascript">
    $('.alert_close').click(function(){
        $( ".alert_box" ).fadeOut( "slow", function() {
        });
    });
</script>