<?php
include 'models/tableModel.php';
include 'models/memberModel.php';
include 'models/loanRequestModel.php';
include 'models/itemModel.php';
include 'models/reviewModel.php';
include 'models/messageModel.php';
$loanRequestModel = new loanRequestModel();
$tableModel = new tableModel();
$memberModel = new memberModel();
$itemModel = new itemModel();
$reviewModel = new reviewModel();
$messageModel = new messageModel();
?>
<div class="wrapper">
<div class="col-md-10">
<h1>Statistics</h1>
<div class="panel panel-info">
<div class="panel-body">
<!-- Nav tabs -->
<ul class="nav nav-tabs" role="tablist">
<li role="presentation" class="active"><a href="#user" aria-controls="home" role="tab" data-toggle="tab">User</a></li>
<li role="presentation"><a href="#items" aria-controls="profile" role="tab" data-toggle="tab">Items</a></li>
<li role="presentation"><a href="#loans" aria-controls="home" role="tab" data-toggle="tab">Loans</a></li>
<li role="presentation"><a href="#messages" aria-controls="home" role="tab" data-toggle="tab">Messages</a></li>
<li role="presentation"><a href="#others" aria-controls="home" role="tab" data-toggle="tab">Others</a></li>
</ul>
<!-- Tab panes -->
<div class="tab-content">
public function view()
{
session_start();
$itemName = '';
$itemOwner = '';
$itemBorrower = '';
$isValidBid = false;
// Check that URL has required fields
if (empty($_GET['item']) || empty($_GET['owner']) || empty($_GET['borrower'])) {
header("Location:index.php");
return;
}
$itemName = $_GET['item'];
$itemOwner = $_GET['owner'];
$itemBorrower = $_GET['borrower'];
$currentUser = $_SESSION['username'];
// Getting the item
include 'models/itemModel.php';
$itemModel = new itemModel();
$queryResult = $itemModel->getByKey($itemOwner, $itemName);
// Ensures that message session is for item that exist
if ($queryResult == false) {
$this->goToPreviousPage();
return;
}
$item = pg_fetch_array($queryResult);
$itemImage = $item['image_url'];
$itemPrice = $item['price'];
// Getting the members
include 'models/memberModel.php';
$memberModel = new memberModel();
// Ensures that message session is for members that exist
if (!$memberModel->memberExist($itemOwner) || !$memberModel->memberExist($itemBorrower)) {
$this->goToPreviousPage();
return;
}
// Ensures that current logged in user belongs to message session
if ($currentUser != $itemOwner && $currentUser != $itemBorrower) {
$this->goToPreviousPage();
return;
}
// Ensures that user is not sending message to self
if ($itemOwner == $itemBorrower) {
$this->goToPreviousPage();
return;
}
// Getting the loan request
include 'models/loanRequestModel.php';
$loanRequestModel = new loanRequestModel();
$bidMade = $loanRequestModel->getLoanRequestByOwnerItemBorrower($itemOwner, $itemName, $itemBorrower);
if ($bidMade != false) {
$bid = pg_fetch_array($bidMade);
$date_start = $bid['date_start'];
$bidStatus = $bid['status'];
$bidPrice = $bid['price_offer'];
$isValidBid = $bid['is_valid'];
}
// Checks if is an accept or reject
if (isset($_POST['accept'])) {
$loanRequestModel->acceptLoanRequest($itemName, $itemOwner, $itemBorrower, $date_start);
$bidStatus = 'accepted';
}
if (isset($_POST['reject'])) {
$loanRequestModel->rejectLoanRequest($itemName, $itemOwner, $itemBorrower, $date_start);
$bidStatus = 'declined';
}
// get all past messages
include 'models/messageModel.php';
$messageModel = new messageModel();
// Check for new message sent
if (isset($_POST['msg-content'])) {
$content = $_POST['msg-content'];
$sender = $itemBorrower;
$receiver = $itemOwner;
if ($currentUser == $itemOwner) {
$sender = $itemOwner;
$receiver = $itemBorrower;
}
$messageModel->addMessage($itemName, $itemOwner, $sender, $receiver, $content);
}
$chatHistory = $messageModel->getChatHistoryInOrder($itemName, $itemOwner, $itemBorrower);
// get user profile images
$ownerProfile = $memberModel->getUserByUsername($itemOwner);
$ownerIcon = pg_fetch_row($ownerProfile)[5];
$borrowerProfile = $memberModel->getUserByUsername($itemBorrower);
$borrowerIcon = pg_fetch_row($borrowerProfile)[5];
// put all messages into an array
$messageArray = array();
while ($row = pg_fetch_row($chatHistory)) {
$msgSender = $row[2];
if ($msgSender == $itemOwner) {
$msgSenderIcon = $ownerIcon;
} else {
$msgSenderIcon = $borrowerIcon;
}
$msgContent = $row[4];
$msgTimestamp = $row[5];
$message = array($msgSender, $msgSenderIcon, $msgContent, $msgTimestamp);
array_push($messageArray, $message);
}
include 'views/message.php';
}
public function view()
{
session_start();
$owner = '';
$itemName = '';
if (!empty($_GET['owner']) && !empty($_GET['item'])) {
$owner = $_GET['owner'];
$itemName = $_GET['item'];
}
// get item info
include 'models/itemModel.php';
include 'models/memberModel.php';
include 'models/itemAvailabilityModel.php';
include 'models/commentModel.php';
include 'models/loanRequestModel.php';
$loanRequestModel = new loanRequestModel();
$itemModel = new itemModel();
$memberModel = new memberModel();
$itemAvailabilityModel = new itemAvailabilityModel();
$commentModel = new commentModel();
$result = $itemModel->getByKey($owner, $itemName);
$item = pg_fetch_array($result);
$submitSuccess = false;
$submitError = false;
if (!empty($_POST)) {
if ($_POST['action'] == 'requestLoan') {
if ($_POST['start'] == '' || $_POST['end'] == '' || $_POST['bidPrice'] == '') {
$submitError = true;
} else {
// process loan request
$start = $_POST['start'];
$end = $_POST['end'];
$bidPrice = $_POST['bidPrice'];
$request = $loanRequestModel->addLoanRequest($item['item_name'], $item['owner'], $_SESSION['username'], $start, $end, $bidPrice);
if ($request) {
$submitSuccess = true;
} else {
$submitError = true;
}
}
}
if ($_POST['action'] == 'submitComment') {
$commentModel->addComment($_POST['item_name'], $_POST['owner'], $_SESSION['username'], $_POST['content']);
}
}
// get all available dates
$result = $itemAvailabilityModel->getAllByItemKey($owner, $itemName);
$availabilityArray = pg_fetch_all($result);
// get all accepted pending
$result = $loanRequestModel->getAllAcceptedByItem($itemName, $owner);
$acceptedArray = pg_fetch_all($result);
if ($acceptedArray) {
$acceptedDates = [];
foreach ($acceptedArray as $accepted) {
$startDate = strtotime($accepted['date_start']);
$endDate = strtotime($accepted['date_end']);
$yearStart = intval(date("Y", $startDate));
$monthStart = intval(date("m", $startDate));
$dateStart = intval(date("d", $startDate));
$yearEnd = intval(date("Y", $endDate));
$monthEnd = intval(date("m", $endDate));
$dateEnd = intval(date("d", $endDate));
for ($y = $yearStart; $y <= $yearEnd; $y++) {
for ($m = $monthStart; $m <= $monthEnd; $m++) {
for ($d = $dateStart; $d <= $dateEnd; $d++) {
$acceptedDates[] = $d . '-' . $m . '-' . $y;
}
}
}
}
}
$freeDates = [];
if ($availabilityArray) {
foreach ($availabilityArray as $availability) {
$startDate = strtotime($availability['date_start']);
$endDate = strtotime($availability['date_end']);
$yearStart = intval(date("Y", $startDate));
$monthStart = intval(date("m", $startDate));
$dateStart = intval(date("d", $startDate));
$yearEnd = intval(date("Y", $endDate));
$monthEnd = intval(date("m", $endDate));
$dateEnd = intval(date("d", $endDate));
for ($y = $yearStart; $y <= $yearEnd; $y++) {
for ($m = $monthStart; $m <= $monthEnd; $m++) {
for ($d = $dateStart; $d <= $dateEnd; $d++) {
$freeDates[] = $d . '-' . $m . '-' . $y;
}
}
}
}
}
if ($acceptedArray) {
for ($i = 0; $i < count($freeDates); $i++) {
for ($j = 0; $j < count($acceptedDates); $j++) {
if (strcmp($freeDates[$i], $acceptedDates[$j]) == 0) {
$freeDates[$i] = -1;
}
}
}
}
// get all comments
date_default_timezone_set("Asia/Singapore");
$result = $commentModel->getCommentsByItemKey($owner, $itemName);
$commentArray = pg_fetch_all($result);
include 'views/item.php';
}
