1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / public_html / admin / view /
Filename : reports.php
back
<?php
include('../../admin/inc/config.php');
include('../inc/auth.php');
$tinyEditor = "textual";$url = $adminRoot.'reports';
define('TITLE','Manage Reports');
define('HEADER','Reports');
define('BREADCRUMB','reports');

if(isset($_GET['edit']) || isset($_GET['send'])){
    if(isset($_GET['id'])){ $id = $_GET['id']; }
    $dbTitle = getDBVal('reports',$id, 'title');
    $dbReport = getDBVal('reports',$id, 'report');
    if(isset($_GET['edit']) && $_GET['edit'] == "true"){
        $crdTitle = "Edit Report (<small>".strtolower($dbTitle).")</small>";
    }
    if(isset($_GET['send']) && $_GET['send'] == 'true'){
        if(checkPending('reports', $id)){
            $q = changeStatus('reports','submitted',$id);
            if($q){ $smsg = "report '$dbTitle' turned in successfully";jsRefresh($url,5000); }else{ $emsg = "something went wrong."; }
        }
    }
}


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-12">
                        <div class="card">
                            <div class="card-header  border-0 pb-0">
                                <h4 class="card-title">All Reports</h4>
                            </div>
                            <div class="card-body">
                                <div class="row">
                                    <div class="col-md-7">
                                        <div class="widget-media dz-scroll scroll-550 ps ps--active-y">
                                            <ul class="timeline">
                                                <?php
                                                $q = getRows('reports',"*");
                                                while($row = mysqli_fetch_array($q)){
                                                    $staffFName = getDBVal('team_members',$row['staff'],'fName');
                                                    $staffLName = getDBVal('team_members',$row['staff'],'lName');
                                                    ?>
                                                    <li>
                                                        <div class="timeline-panel">
                                                            <div class="media mr-2">
                                                                <i class="fa fa-<?= ($row['status'] == 'pending') ? 'times' : 'check' ?> fa-2x text-primary"></i>
                                                            </div>
                                                            <div class="media-body">
                                                                <h5 class="mb-1"><?= $row['title'] ?></h5>
                                                                <small class="d-inline-block mr-3"><i class="fa fa-user"></i> <?= "$staffFName $staffLName" ?></small>
                                                                <small class="d-inline-block"><i class="fa fa-calendar"></i> <?= 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">
                                                                    <?php if($row['status'] == 'pending'): ?>
                                                                    <a class="dropdown-item" href="<?= $adminRoot ?>reports?edit=true&id=<?= $row['id'] ?>">Edit</a>
                                                                    <a class="dropdown-item" href="<?= $adminRoot ?>reports?send=true&id=<?= $row['id'] ?>">Turn In</a>
                                                                    <?php endif ?>
                                                                    <a class="dropdown-item" href="<?= $adminRoot ?>reports?preview=true&id=<?= $row['id'] ?>">Preview</a>
                                                                </div>
                                                            </div>
                                                        </div>
                                                    </li>
                                                <?php } ?>
                                            </ul>
                                        </div>
                                    </div>
                                    <div class="col-md-5">
                                        <?php if(isset($_GET['preview']) && isset($_GET['id']) && $_GET['preview'] == 'true'){
                                        $id = $_GET['id'];
                                        $q = dbSelect('reports',"*","id=$id");
                                        while($row = mysqli_fetch_array($q)){
                                        ?>
                                        <div class=" pb-0">
                                            <h4><?= $row['title'] ?></h4>
                                            <ul class="list-group list-group-flush">
                                                <li class="list-group-item d-flex px-0 justify-content-between">
                                                    <strong>Date</strong>
                                                    <span class="mb-0"><?= formatDate($row['dc'],"F jS, Y") ?></span>
                                                </li>
                                                <li class="list-group-item d-flex px-0 justify-content-between">
                                                    <strong>Turned In</strong>
                                                    <span class="mb-0"><?= formatDate($row['du'], "h:ia") ?></span>
                                                </li>
                                                <li class="list-group-item d-flex px-0 justify-content-between">
                                                    <strong>Status</strong>
                                                    <span class="mb-0"><?= ucfirst($row['status']) ?></span>
                                                </li>
                                                <li class="list-group-item d-flex px-0 justify-content-between">
                                                    <strong>Report</strong>
                                                    <span class="mb-0"><?= $row['report'] ?></span>
                                                </li>
                                            </ul>
                                        </div>
                                        <?php }} ?>
                                    </div>
                                </div>
                            </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"); ?>