if (isset($_POST['is_cover'])) {
$result = $itemModel->addCoverImage($_POST['item_name'], $_POST['owner'], $_POST['image_url']);
} else {
$result = $itemModel->addNonCoverImage($_POST['item_name'], $_POST['owner'], $_POST['image_url']);
}
if ($result == true) {
$result = "<p class='text-success'>Item Image Successfully Created!</p>";
} else {
$result = "<p class='text-danger'>Error Occured! Try checking your database constraint.</p>";
}
} else {
if (isset($_POST['item_name']) && isset($_POST['owner']) && isset($_POST['commentor']) && isset($_POST['content'])) {
// adding comment entry
include 'models/commentModel.php';
$commentModel = new commentModel();
$result = $commentModel->addComment($_POST['item_name'], $_POST['owner'], $_POST['commentor'], $_POST['content']);
if ($result == true) {
$result = "<p class='text-success'>Review Successfully Created!</p>";
} else {
$result = "<p class='text-danger'>Error Occured! Try checking your database constraint.</p>";
}
} else {
if (isset($_POST['reviewer']) && isset($_POST['reviewee']) && isset($_POST['content'])) {
// adding review entry
include 'models/reviewModel.php';
$reviewModel = new reviewModel();
if (isset($_POST['has_like'])) {
$result = $reviewModel->addNewReview($_POST['reviewer'], $_POST['reviewee'], $_POST['content'], 1);
} else {
$result = $reviewModel->addNewReview($_POST['reviewer'], $_POST['reviewee'], $_POST['content'], 0);
}
<?php
require_once 'commentModel.class.php';
$commentModel = new commentModel();
// $commentModel->getComments('1');
$action = $_GET['action'];
$blogId = $_REQUEST['blogId'];
switch ($action) {
case 'getComments':
$result = $commentModel->getComments($blogId);
echo json_encode($result);
break;
case 'addComment':
$content = $_POST['content'];
if (strlen($content) >= 10) {
$result = $commentModel->addComment($blogId, $content);
if ($result) {
// require_once 'swiftmailer-master/lib/swift_required.php';
// $email = '*****@*****.**';
// //发送邮件，以QQ邮箱为例
// //配置邮件服务器，得到传输对象
// $transport=Swift_SmtpTransport::newInstance('smtp.qq.com',25);
// //设置登陆帐号和密码
// $transport->setUsername('*****@*****.**');
// $transport->setPassword('songwanfu0531');
// //得到发送邮件对象Swift_Mailer对象
// $mailer=Swift_Mailer::newInstance($transport);
// //得到邮件信息对象
// $msg=Swift_Message::newInstance();
// //设置管理员的信息
// $msg->setFrom(array('*****@*****.**'=>'Meet Better Me'));
function postComment($login, $article, $comment)
{
$commentModel = new commentModel();
$comment = $commentModel->addComment($login, $article, $comment);
include 'view/viewArticle.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';
}
