maintenance.php

<h1>Maintenance Status</h1>

<?php
include("SoaringLogBase.php");

// name of this file - used in links
$thisFile = "index.php?maintenance";

session_start();
$loggedIn = False;
if ( isset( $_SESSION['loggedin'] ) ) {
    $loggedIn = True;
    print("<h2><a href=\"auth.php?logout=1&origin=maintenance\">Logout</a></h2>");
}
else {
    print("<h2><a href=\"auth.php?origin=maintenance\">Login</a></h2>");
}


// Initialize variable we'll be using from the database
$logbase = SoaringLogBase::GetInstance();
$database = $logbase->dbObj;
$tableName = $logbase->GetMaintTable(); 
$maintList = $logbase->GetMaint(); 

// using the _REQUEST array allows input via HTTP POST or URL tags
$maintItem = isset($_REQUEST["maintItem"]) ? $_REQUEST["maintItem"] : null;
$startTime = strtotime(isset($_REQUEST["startTime"]) ? $_REQUEST["startTime"] : null);
$endTime = strtotime(isset($_REQUEST["endTime"]) ? $_REQUEST["endTime"] : null);;
$logType = isset($_REQUEST["logType"]) ? $_REQUEST["logType"] : null;
$maintID = isset($_REQUEST["maintID"]) ? $_REQUEST["maintID"] : null;
$modified = isset($_REQUEST["modified"]) ? $_REQUEST["modified"] : null;
$logAircraft = isset($_REQUEST["aircraft"]) ? $_REQUEST["aircraft"] : null;

// update an existing record
if($loggedIn) {
    if($maintID && !$modified) {
        $query = "UPDATE $tableName SET ";

        if($maintItem)
            $query .= "maintItem='$maintItem',";

        if($startTime)
            $query .= "startTime='$startTime',";

        if (strcmp($_REQUEST["endTime"],"clear") == 0) {
            $query .= "endTime=NULL,";
            print("clearing...");
        }
        else if($endTime) {
            $query .= "endTime='$endTime',";
        }

        if($logType) 
            $query .= "logType='$logType',";

        if($logAircraft) 
            $query .= "logAircraft='$logAircraft',";

        // trim any trailing commas off the string
        $query = rtrim($query, ",");

        $query .= " WHERE ID='$maintID';";

        if(!$result = $database->query($query)) {
            print("uh oh.... failed to update record :(");
            print $query;
        }
    }
    else if($maintItem) {
        // Add a new maintenance item to the database
        $query = "INSERT INTO $tableName (ID, maintItem, startTime, endTime, logType, logAircraft) VALUES (NULL, '$maintItem', '$startTime', '$endTime', '$logType', '$logAircraft');";

        if(!$result = $database->query($query))
            print("uh oh.... query failed :( $result");

        // refresh the maint list
        $maintList = $logbase->GetMaint();
    }
}

// print out the list of existing entries
$tableName = $logbase->GetMaintTable(); 
$query = "SELECT * FROM $tableName ORDER BY ID;";
if($result = $database->query($query)) {
    echo("<table id=\"maintLogTable\" >");
    echo("<tr class=\"Head\"><td>Maint Item</td><td>Start Date</td><td>End Date</td><td>Log Type</td><td>Log Type Aircraft</td><td></td></tr>\n");

    // skip the first row (it should be null)
    //$row = $result->fetch(PDO::FETCH_BOTH);
    while($row = $result->fetch(PDO::FETCH_BOTH)) {
        $editMe = 0;
        // do we need to modify this row?
        if($maintID == $row['ID'] && $modified) {
            $editMe = 1;
        }

        if($editMe) {
            echo("<tr id=\"row{$row['ID']}\" class=\"IncompleteEntry\"><form id=\"form{$row['ID']}\" name=\"loggingUpdate\" action=\"{$thisFile}\" method=\"POST\"> ");
            $entryComplete = false;
        }
        else {
            echo("<tr class=\"CompleteEntry\">");
            $entryComplete = true;
        }

        // Maint Item
        if($editMe) {
            echo("<td>");
            echo("<input type=\"text\" name=\"maintItem\" value=\"{$row['maintItem']}\" id=\"maintItem{$row['ID']}\"/>");
            echo "</td>";
        }
        else 
            echo("<td>{$row['maintItem']}</td>");

        // Start Date
        if($editMe) {
            echo("<td>");
            $storedStartTime = date("F j, Y", $row['startTime']);
            echo("<input type=\"text\" name=\"startTime\" value=\"{$storedStartTime}\" id=\"startTime{$row['ID']}\"/>");
            echo "</td>";
        }
        else {
            $formattedStartTime = date("F j, Y", $row['startTime']);
            echo("<td>{$formattedStartTime}</td>");
        }

        // End Date
        if($editMe) {
            echo("<td>");
            if($row['endTime'] >= 0) {  
                $storedEndTime = date("F j, Y", $row['endTime']);
            }
            else {
                $storedEndTime = "---";
            }
            echo("<input type=\"text\" name=\"endTime\" value=\"{$storedEndTime}\" id=\"endTime{$row['ID']}\"/>");
            echo "</td>";
        }
        else {
            if ($row['endTime']) {
                $formattedStartTime = date("F j, Y", $row['endTime']);
                echo("<td>{$formattedStartTime}</td>");
            }
            else {
                echo("<td>Not yet complete</td>");
            }
        }

        // Log Type
        if($editMe) {
            echo("<td>");
            echo $logbase->PrintMaintLogTypes($row['logType']);
            echo "</td>";
        }
        else 
            echo("<td>{$row['logType']}</td>");

        // Log Aircraft
        if($row['logType'] == "PER AIRCRAFT")
        {
            if($editMe) {
                echo("<td>");
                echo $logbase->PrintAircraft($row['logAircraft']);
                echo "</td>";
            }
            else
            {
                $acList = $logbase->GetAircraft(); 
                echo("<td>{$acList[$row['logAircraft']]}</td>");
            }
        }
        else
        {
            echo "<td></td>";
        }

        // Submit button and hidden field containing the unique maint index
        if($editMe) {
            echo "<td><input type=\"hidden\" name=\"maintID\" value=\"{$row['ID']}\"/><input type=\"submit\" value=\"Update...\" /></form></td></tr>";
        }
        else {
            if($loggedIn) {
                echo "<td><center><button name=\"modify\" class=\"modify\" onClick=\"window.location.href='{$thisFile}&maintID={$row['ID']}&modified=1'; \" />";
                echo "</center></td></tr>\n";
            }
            else {
                echo "<td></td></tr>\n";
            }
        }

        // Print out entry results
        if ($row['logType'] == "PER AIRCRAFT")
        {
            $tableName = $logbase->GetFlightLogTable();
            $endTime = $row['endTime'];
            if (!$endTime)
            {
                $endTime = strtotime("now");
            }
            $query = "SELECT * FROM '$tableName' WHERE takeoffTime IS NOT NULL AND takeoffTime >= '{$row['startTime']}' AND takeoffTime <= '$endTime' AND aircraft == '{$row['logAircraft']}';";
            $acResult = $database->query($query);

            $flightCount = 0;
            $totalTime = 0;
            while($row = $acResult->fetch(PDO::FETCH_BOTH)) 
            {
                // don't print if there's no takeoff time
                if($row['takeoffTime'] && $row['landingTime']) 
                {
                    $flightCount = $flightCount + 1;
                    $totalTime += $row['landingTime'] - $row['takeoffTime'];
                }
            }
            $totalTime = round($totalTime / 3600, 1);
            echo "<tr class=\"IncompleteEntry\">";
            echo "<td>Number of flights: $flightCount</td>";
            echo "<td colspan=\"5\">Number of hours: $totalTime </td>  </tr>\n";
        }
        else 
        {
            $tableName = $logbase->GetFlightLogTable();
            $endTime = $row['endTime'];
            if ($row['endTime'])
            {
                $endTime = strtotime("now");
            }
            $query = "SELECT count(*) FROM '$tableName' WHERE takeoffTime IS NOT NULL AND takeoffTime >= '{$row['startTime']}' AND takeoffTime <= '$endTime';";
            $tows = $database->query($query)->fetchColumn();
            echo "<tr class=\"IncompleteEntry\"><td colspan=\"6\">Number of tows: $tows</td>  </tr>\n";
        }
    }

    if ($loggedIn) {
        // Row for new entries...
        echo "<tr><form name=\"maintList\" action=\"{$thisFile}\" method=\"POST\">\n";
        echo "<td><input type=\"text\" name=\"maintItem\" /></td>\n";
        echo "<td><input type=\"text\" name=\"startTime\" /></td>\n";
        echo "<td><input type=\"text\" name=\"endTime\" /></td>\n";
        echo "<td>";
        echo $logbase->PrintMaintLogTypes();
        echo "</td>";
        echo "<td>";
        echo $logbase->PrintAircraft();
        echo "</td>";
        echo "<td><input type=\"submit\" value=\"Add new...\" /></td>";
        echo "</form></tr>\n";
    }
    echo("</table><br><br><br>");
}
else
    print("Failed to execute query!!!");

?>
This page allows tracking elapsed tows or elapsed flight time between a range of dates. "PER TOW" will track the total number of launches across all aircraft. "PER AIRCRAFT" will track the number of tows as well as flight hours. Only complete flights (having both a completed takeoff and landing time) are counted. 
<br>
Enter dates like "Month, Day, Year". The word "clear" can be used to erase the end date should it be mistakenly entered. A missing end date means the calculations include up to the current time. The maintenance log can only be edited after logging in. 
<br>
<br>