PHP rejectExtension Examples

Example #1

File: submit_reject_extension.php Project: uxreactor/Library-Management-System

<?php

require 'controller.php';
$bookId = $_POST['bookId'];
$memberId = $_POST['memId'];
$message = rejectExtension($memberId, $bookId);
echo $message;

Example #2

File: controller.php Project: uxreactor/Library-Management-System

/**
 * @approveDueDateExtension : This function is used approve the requests of due date extension and replace the updated due date in database.
 * @author : Mohan, Bala
 *
 * @param : string - memberId
 * @param : string - bookId
 * @param : string - returnDate
 * @param : string - extensionDays
 *
 * @return/outcome : If the extension is approved it will save the updated extension date else it will reject.
 */
function approveDueDateExtension($memberid, $bookid)
{
    $conn = connection();
    $sql = " SELECT a.extension_days, b.return_expected FROM due_date_extension a JOIN tbl_issued_books b WHERE b.mem_id = '{$memberid}' AND a.book_id = '{$bookid}' ";
    $result = $conn->query($sql);
    if ($result->num_rows > 0) {
        // output data of each row
        $row = $result->fetch_assoc();
        $returndate = $row["return_expected"];
        $extension = $row["extension_days"];
    } else {
        return 0;
    }
    $date = date('Y-m-d', strtotime("+{$extension} days", strtotime($returndate)));
    $sql = "UPDATE tbl_issued_books SET return_expected = '{$date}'  WHERE mem_id = '{$memberid}' AND book_id = '{$bookid}' ";
    if ($conn->query($sql) === TRUE) {
        rejectExtension($memberid, $bookid);
        return 1;
    } else {
        return "Error: " . $sql . "<br>" . $conn->error;
    }
    $conn->close();
}