예제 #1
0
function writeTable($conn, $showall)
{
    $id = $_SESSION["id"];
    $sqlGetBookings = "SELECT * FROM RecurringBookings\n                         WHERE BookedByID={$id}";
    $resultGetBookings = mysqli_query($conn, $sqlGetBookings);
    $today = date('Ymd');
    while ($row = mysqli_fetch_assoc($resultGetBookings)) {
        // if we want to show all bookings
        // or today's date is less than the end date of the booking
        if ($showall == true || strtotime($today) <= strtotime($row["EndDate"])) {
            echo "<tr>";
            echo "<td>" . styleResource($row["Resource"]) . "</td>";
            echo "<td>" . styleDay($row["RecurDay"]) . "</td>";
            echo "<td>" . stylePeriod($row["RecurPeriod"], getResourceType($row["Resource"])) . "</td>";
            echo "<td>";
            if ($row["isWeekly"] == 1) {
                echo "Week";
            } else {
                echo "Fortnight";
            }
            echo "</td>";
            echo "<td>" . styleDate($row["StartDate"]) . "</td>";
            echo "<td>" . styleDate($row["EndDate"]) . "</td>";
            ?>
        <td>
          <form method="POST" action="managerecurring.php">
          <!--Has a confirm box to make sure user can cancel action-->
          <button type="submit" id="deletebooking" name="deletebooking"
                  onclick="return confirm('Are you sure you want to delete this recurring record? \nThat includes ALL future bookings related to this recurrence!');"
                  value=<?php 
            echo "'" . $row["BookingID"] . "," . $row["Resource"] . "," . $row["BookedByID"] . "'";
            ?>
>Delete</button>
          </form>
        </td>
        <?php 
        }
        // if
    }
    // while
}
예제 #2
0
function writeBookingsForTable($includepast, $conn, $id, $table, $tablestring)
{
    $sqlGetBookings = "SELECT BookingID,BookingDate,BookingPeriod,BookingDesc FROM {$table}\n                             WHERE BookedByID={$id} ORDER BY bookingdate DESC, bookingperiod ASC";
    $resultGetBookings = mysqli_query($conn, $sqlGetBookings);
    while ($row = mysqli_fetch_assoc($resultGetBookings)) {
        // If includepast=true, i.e. write ALL bookings, past and current
        if ($includepast) {
            echo "<tr>";
            echo "<td>" . $row["BookingDesc"] . "</td>";
            echo "<td>" . $row["BookingDate"] . "</td>";
            echo "<td>" . stylePeriod($row["BookingPeriod"], getResourceType($table)) . "</td>";
            echo "<td>{$tablestring}</td>";
            ?>
              <td>
                <form method="POST" action="managebookings.php">
                <!--Has a confirm box to make sure user can cancel action-->
                <button type="submit" id="deletebooking" name="deletebooking" onclick="return confirm('Are you sure you want to delete this record?');" value=<?php 
            echo "'" . $row["BookingID"] . "," . $table . "'";
            ?>
>Delete</button>
                </form>
              </td>
              <?php 
            echo "</tr>";
        } else {
            // If booking date is not in the past, print row
            if (!checkIfInThePast($row["BookingDate"])) {
                echo "<tr>";
                echo "<td>" . $row["BookingDesc"] . "</td>";
                echo "<td>" . styleDate($row["BookingDate"]) . "</td>";
                echo "<td>" . stylePeriod($row["BookingPeriod"], getResourceType($table)) . "</td>";
                echo "<td>{$tablestring}</td>";
                ?>
                <td>
                  <form method="POST" action="managebookings.php">
                  <!--Has a confirm box to make sure user can cancel action-->
                  <button type="submit" id="deletebooking" name="deletebooking" onclick="return confirm('Are you sure you want to delete this record?');" value=<?php 
                echo "'" . $row["BookingID"] . "," . $table . "'";
                ?>
>Delete</button>
                  </form>
                </td>
                <?php 
                echo "</tr>";
            }
            // if
        }
        // else
    }
    // while
}