<?php session_start(); include "../common/DatabaseConnection.php"; $db = new DatabaseConnection(); $db->createConnection(); $locationFK = $_SESSION['userLoc']; $type = $_GET['artefactType']; $dateType = $_GET['dtype']; if ($dateType == 'c') { getCurrentDate($locationFK, $type, $db); } else { getPending($locationFK, $type, $db); } function getCurrentDate($locationFK, $type, $db) { $sql = "select s.ScheduleMaintenancePK,s.ArtefactCode,a.ArtefactName,s.ScheduledServiceDate from scheduledmaintenance s\r\n\t\tinner join artefact a\r\n\t\ton s.ArtefactCode = a.ArtefactCode\r\n\t\twhere s.ScheduleMaintenancePK not in (select ScheduleMaintenanceFK from tasklist)\r\n\t\tand s.ScheduledServiceDate = current_date() and s.LocationFK='{$locationFK}' and s.ArtefactTypeCode = '{$type}' and a.visiblestatus='on'"; if ($result = $db->setQuery($sql)) { if ($result->num_rows > 0) { $resultArray = array(); while ($row = $result->fetch_assoc()) { $url = "conditionalReport.php?artefactCode=" . $row['ArtefactCode'] . "&key=" . $row['ScheduleMaintenancePK']; $name = $row['ArtefactName']; echo "<a href=" . $url . " class='list-group-item'>" . "<span class='glyphicon glyphicon-file'></span>" . $name . "<span class='badge'>" . date('d/m/Y', strtotime($row['ScheduledServiceDate'])) . "</span></a>"; //echo " <a href=".$url." class='list-group-item' ><span class='glyphicon glyphicon-file'></span>".$name."<span class='badge'>".date('d/m/Y', strtotime($row['ScheduledServiceDate']))."</span></a>"; } //echo json_encode($resultArray); } else { echo "NULL"; } }
function pendingInfo() { $pending = getPending(); return $pending; }