1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / www / staff / view /
Filename : reports.php
back
<?php
include('../../admin/inc/config.php');
include('../inc/auth.php');
$tinyEditor = "textual";$url = $staffRoot.'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');
    $dbReportDC = getDBVal('reports',$id, 'dc');
    if(isset($_GET['edit']) && $_GET['edit'] == "true"){
        $crdTitle = "Edit Report (<small>".strtolower($dbTitle).")</small>";
    }
    if(isset($_GET['send']) && $_GET['send'] == 'true'){
        $reportDC = formatDate($dbReportDC, "Y-m-d");
        if(strtotime($today) > strtotime($dbReportDC)){
            $emsg = "You cannot turn this report in anymore";
        }
        else {
            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.";
                }
            }
        }
    }
}


# update report
if(isset($_POST['saveExistingReport']) || isset($_POST['sendExistingReport'])){
    #data cleaning & scrutinization
    $reportTitle = trim(stripslashes(mysqli_real_escape_string($db, $_POST['reportTitle'])));
    $report = trim(mysqli_real_escape_string($db, $_POST['report']));
    #data validation
    if(empty($reportTitle)){
        array_push($errs, $reportTitleErr = "please enter a value");
    }
    if(empty($report)){
        array_push($errs, $reportErr = "please enter a value");
    }
    #execute when errors have been solved
    if(count($errs) == 0){
        if(isset($_POST['sendExistingReport'])) {
            $reportDC = formatDate($dbReportDC, "Y-m-d");
            if(strtotime($today) > strtotime($dbReportDC)){
                $emsg = "You cannot turn this report in anymore";
            }
            else {
                $q = dbUpdate("reports", ['title' => $reportTitle, 'report' => $report, 'status' => 'submitted', 'du' => $now], "id=" . $id);
                if ($q) {
                    $body = "Your daily report for today $today has been turned in successfully. You will receive a notification once the report has been acknowledged.";
                    $logoPath = "../../assets/img/hscs/brand/logo.png";
                    $subject = "Daily Report Submission Completed";
                    $destination = $staffNo;
                    require '../../admin/vendor/PHPMailer/PHPMailerAutoload.php';
                    include("../../admin/inc/mail-temps/notification.php");
                    $smsg = "Report turned in successfully";
                    jsRefresh($url, 5000);
                } else {
                    $emsg = "Action not successful. Try again later";
                }
            }
        }
        if(isset($_POST['saveExistingReport'])) {
            $q = dbUpdate("reports", ['title' => $reportTitle, 'report' => $report, 'du' => $now], "id=" . $id);
            if($q){
                $smsg = "Report DRAFT updated successfully";$preventResubmission = true;
            }
            else{
                $emsg = "Action not successful. Try again later";
            }
        }
    }
}

#save report
if(isset($_POST['saveReport']) || isset($_POST['sendReport'])){
    #data cleaning & scrutinization
    $reportTitle = trim(stripslashes(mysqli_real_escape_string($db, $_POST['reportTitle'])));
    $report = trim(mysqli_real_escape_string($db, $_POST['report']));
    #data validation
    if(empty($reportTitle)){
        array_push($errs, $reportTitleErr = "please enter a value");
    }
    if(empty($report)){
        array_push($errs, $reportErr = "please enter a value");
    }
    #prevent duplicates
    $rowCnt = checkDuplicates('reports', "staff=$userId AND dc LIKE '%$today%'");
    if($rowCnt > 0){
        array_push($errs, $reportExistErr = "");
        $emsg = "You already have a pending report for today, kindy edit that instead if it's not been submitted for approval.";
    }


    #execute when errors have been solved
    if(count($errs) == 0){
        $q = dbInsert("reports", ['staff' => $userId, 'title' => $reportTitle, 'report' => $report, 'dc' => $now]);
        if($q){
            $logoPath = "../../assets/img/hscs/brand/logo.png";$subject = "Daily Report Submission";$destination = $staffNo;
            if(isset($_POST['saveReport'])) {
                $body = "Your daily report for today $today has been saved successfully as DRAFT. Please ensure you turn it in for approval before 12 midnight";$msg = "saved";
            }
            if(isset($_POST['sendReport'])) {
                $body = "Your daily report has been turned in successfully. You will receive a notification once the report has been acknowledged.";$msg = "turned in";
            }
            require '../../admin/vendor/PHPMailer/PHPMailerAutoload.php';
            include("../../admin/inc/mail-temps/notification.php");
            $smsg = "Report $msg successfully";$preventResubmission = true;
        }
        else{
            $emsg = "Action not successful. Try again later";
        }
    }
}


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-4">
                        <div class="card border-0">
                            <div class="card-body">
                                <h4 class="card-title"><?php if(isset($crdTitle)){ echo $crdTitle; }else{ ?>New Report for <span class="text-primary"><?= date("F jS, Y") ?></span><?php } ?></h4>
                                <form action="" method="post" enctype="multipart/form-data">

                                    <?php if(isset($_GET['edit']) && $_GET['edit'] == "true"): ?>
                                        <div class="form-row" id="new-report">
                                            <div class="form-group col-md-12">
                                                <label>Subject / Title</label>
                                                <input type="text" class="form-control" name="reportTitle" placeholder="" value="<?php if(isset($_POST['reportTitle'])){ echo $_POST['reportTitle']; }else{ echo $dbTitle; } ?>">
                                                <?php if(isset($reportTitleErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $reportTitleErr; ?></span><?php endif ?>
                                            </div>
                                            <div class="form-group col-md-12">
                                                <label>Details</label>
                                                <textarea name="report" id="" cols="30" rows="10" class="form-control tinyeditor"><?php if(isset($_POST['report'])){ echo $_POST['report']; }else{ echo $dbReport; } ?></textarea>
                                                <?php if(isset($reportErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $reportErr; ?></span><?php endif ?>
                                            </div>
                                        </div>
                                        <div class="form-row mt-3">
                                            <div class="col-md-12">
                                                <button type="submit" name="sendExistingReport" class="btn btn-xs btn-success">Send for Approval</button>
                                                <button type="submit" name="saveExistingReport" class="btn btn-xs btn-primary">Update Draft</button>
                                            </div>
                                        </div>
                                    <?php else: ?>
                                        <div class="form-row" id="new-report">
                                            <div class="form-group col-md-12">
                                                <label>Subject / Title</label>
                                                <input type="text" class="form-control" name="reportTitle" placeholder="" value="<?php if(isset($_POST['reportTitle'])){ echo $_POST['reportTitle']; } ?>">
                                                <?php if(isset($reportTitleErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $reportTitleErr; ?></span><?php endif ?>
                                            </div>
                                            <div class="form-group col-md-12">
                                                <label>Details</label>
                                                <textarea name="report" id="" cols="30" rows="10" class="form-control tinyeditor"><?php if(isset($_POST['report'])){ echo $_POST['report']; } ?></textarea>
                                                <?php if(isset($reportErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $reportErr; ?></span><?php endif ?>
                                            </div>
                                        </div>
                                        <div class="form-row mt-3">
                                            <div class="col-md-12">
                                                <button type="submit" name="sendReport" class="btn btn-xs btn-success">Send for Approval</button>
                                                <button type="submit" name="saveReport" class="btn btn-xs btn-primary">Save as Draft</button>
                                            </div>
                                        </div>
                                    <?php endif ?>
                                </form>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-8">
                        <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-6">
                                        <div class="widget-media dz-scroll scroll-550 ps ps--active-y">
                                            <ul class="timeline">
                                                <?php
                                                $q = getRows('reports',"*","staff=$userId");
                                                while($row = mysqli_fetch_array($q)){
                                                    ?>
                                                    <li>
                                                        <div class="timeline-panel">
                                                            <div class="media mr-2">
                                                                <i class="fa fa-<?= ($row['status'] == 'pending') ? 'eye-slash' : 'eye' ?> fa-2x text-primary"></i>
                                                            </div>
                                                            <div class="media-body">
                                                                <h5 class="mb-1"><?= $row['title'] ?></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">
                                                                    <?php if($row['status'] == 'pending'): ?>
                                                                    <a class="dropdown-item" href="<?= $staffRoot ?>reports?edit=true&id=<?= $row['id'] ?>">Edit</a>
                                                                    <a class="dropdown-item" href="<?= $staffRoot ?>reports?send=true&id=<?= $row['id'] ?>">Turn In</a>
                                                                    <?php endif ?>
                                                                    <a class="dropdown-item" href="<?= $staffRoot ?>reports?preview=true&id=<?= $row['id'] ?>">Preview</a>
                                                                </div>
                                                            </div>
                                                        </div>
                                                    </li>
                                                <?php } ?>
                                            </ul>
                                        </div>
                                    </div>
                                    <div class="col-md-6">
                                        <?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"); ?>