1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / www / staff / view /
Filename : queries.php
back
<?php
include('../../admin/inc/config.php');
include('../inc/auth.php');

define('TITLE','Manage Queries');
define('HEADER','Queries');
define('BREADCRUMB','queries');



include("../../admin/inc/head.php");
?>

<body>

    <!--*******************
        Preloader start
    ********************-->
    <?php include("../../admin/inc/preloader.php"); ?>
    <!--*******************
        Preloader end
    ********************-->

    <!--**********************************
        Main wrapper start
    ***********************************-->
    <div id="main-wrapper">

        <!--**********************************
            Nav header start
        ***********************************-->
        <?php include("../inc/nav-header.php"); ?>
        <!--**********************************
            Nav header end
        ***********************************-->


        <!--**********************************
            Header start
        ***********************************-->
        <?php include("../inc/header.php"); ?>
        <!--**********************************
            Header end ti-comment-alt
        ***********************************-->

        <!--**********************************
            Sidebar start
        ***********************************-->
        <?php include("../inc/sidebar.php"); ?>
        <!--**********************************
            Sidebar end
        ***********************************-->

        <!--**********************************
            Content body start
        ***********************************-->
        <div class="content-body">
            <div class="container-fluid">
                <?php include("../inc/page-header.php"); ?>

                <div class="row">
                    <div class="col-md-8">
                        <div class="card">
                            <div class="card-header  border-0 pb-0">
                                <h4 class="card-title">Queries from HDI</h4>
                            </div>
                            <div class="card-body">
                                <div class="widget-media dz-scroll ps ps--active-y">
                                    <ul class="timeline">
                                        <?php
                                        $q = getRows('queries',"*","target='$staffNo' AND status='Unread'");
                                        while($row = mysqli_fetch_array($q)){
                                        ?>
                                        <li>
                                            <div class="timeline-panel">
                                                <div class="media mr-2">
                                                    <i class="fa fa-<?= ($row['status'] == 'Unread') ? 'envelope' : 'envelope-open' ?> fa-2x text-primary"></i>
                                                </div>
                                                <div class="media-body">
                                                    <h5 class="mb-1"><?= $row['subject'] ?></h5>
                                                    <small class="d-block"><?= formatDate($row['dc'],"F jS, Y h:ia") ?></small>
                                                </div>
                                                <div class="dropdown">
                                                    <button type="button" class="btn btn-primary light sharp" data-toggle="dropdown">
                                                        <i class="bi bi-three-dots text-black"></i>
                                                    </button>
                                                    <div class="dropdown-menu dropdown-menu-right">
                                                        <a class="dropdown-item" href="<?= $staffRoot ?>home?show=p-queries&id=<?= $row['id'] ?>&prvw=qry">Open</a>
                                                    </div>
                                                </div>
                                            </div>
                                        </li>
                                        <?php } ?>
                                    </ul>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="card border-0">
                            <div class="card-body">
                                <h4 class="card-title">Preview Pane</h4>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <!--**********************************
            Content body end
        ***********************************-->

        <!--**********************************
            Footer start
        ***********************************-->
        <?php include("../../admin/inc/footer.php"); ?>
        <!--**********************************
            Footer end
        ***********************************-->


    </div>
    <!--**********************************
        Main wrapper end
    ***********************************-->

    <?php include("../../admin/inc/foot.php"); ?>