Пример #1
0
 public function post()
 {
     $post = JRequest::get('post');
     $data = json_decode($post['JSON_object']);
     $table = JTable::getInstance('Comment', 'JTable');
     $table->created = gmdate("Y-m-d H:i:s");
     $table->name = $this->plugin->get('user')->name;
     $table->username = $this->plugin->get('user')->username;
     $table->userid = $this->plugin->get('user')->id;
     $table->email = $this->plugin->get('user')->email;
     $table->comments = $data->comments;
     $table->pid = $data->listing_id;
     $table->store();
     // Create rating record here
     $rating = JTable::getInstance('Rating', 'JTable');
     $rating->reviewid = $table->id;
     $rating->ratings = isset($post['rating']) ? (double) $post['rating'] : 'na';
     $rating->ratings_sum = is_numeric($rating->ratings) ? $rating->ratings : 0;
     $rating->ratings_qty = $rating->ratings == 'na' ? 0 : 1;
     $rating->store();
     require_once JPATH_SITE . '/components/com_jreviews/jreviews/framework.php';
     require_once JPATH_SITE . '/components/com_jreviews/jreviews/models/review.php';
     $model = new ReviewModel();
     $model->saveListingTotals($data->listing_id, 'com_content');
     $this->addStream($table);
     if ($table->email) {
         $this->sendEmail($table);
     }
     JRequest::setVar('id', $table->id);
     $this->get();
 }
Пример #2
0
 function onPhotoComment($photoid, $message)
 {
     // when users comment on a photo that is related to a catch report,
     // add that comment to the catch report as well
     $db =& JFactory::getDBO();
     $user =& JFactory::getUser();
     // get related listings
     $sql = "SELECT rp.listing_id FROM #__relate_photos rp " . "LEFT JOIN #__content c ON rp.listing_id = c.id " . "WHERE rp.photo_id = '" . $photoid . "' " . "AND rp.listing_id != 0 AND c.state > 0 AND c.catid IN (13,14,15) ";
     $db->setQuery($sql);
     $listings = $db->loadResultArray();
     foreach ($listings as $listing_id) {
         $jr_comment = array('pid' => $listing_id, 'mode' => 'com_content', 'created' => gmdate("Y-m-d H:i:s"), 'userid' => $user->id, 'name' => $user->name, 'username' => $user->username, 'email' => $user->email, 'comments' => $message, 'published' => '1', 'ipaddress' => $_SERVER['REMOTE_ADDR'], 'posts' => '0', 'vote_helpful' => '0', 'vote_total' => '0');
         $sql = "INSERT INTO #__jreviews_comments (" . implode(",", array_keys($jr_comment)) . ") VALUES ('" . implode("','", $jr_comment) . "')";
         $db->setQuery($sql);
         $db->query();
         $jr_ratings = array('reviewid' => $db->insertid(), 'ratings' => 'na', 'ratings_sum' => 0, 'ratings_qty' => 0);
         $sql = "INSERT INTO #__jreviews_ratings (" . implode(",", array_keys($jr_ratings)) . ") VALUES ('" . implode("','", $jr_ratings) . "')";
         $db->setQuery($sql);
         $db->query();
         require_once JPATH_SITE . '/components/com_jreviews/jreviews/framework.php';
         require_once JPATH_SITE . '/components/com_jreviews/jreviews/models/review.php';
         $model = new ReviewModel();
         $model->saveListingTotals($listing_id, 'com_content');
     }
 }
Пример #3
0
 function getReviewsTable()
 {
     $reviewModel = new ReviewModel();
     $reviews = $reviewModel->getReviews();
     $result = "<div style='height:400px;overflow:auto;'>\n\t\t\t\t\t<table class='tables'>\n\t\t\t\t\t  <thead>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t  <th>Id review</th>\n\t\t\t\t\t\t  <th>Description</th>\n\t\t\t\t\t\t  <th>Id user</th>\n\t\t\t\t\t\t  <th>Id book</th>\n\t\t\t\t\t\t  <th>Approved</th>\n\t\t\t\t\t\t  <th>Approve review</th>\n\t\t\t\t\t\t  <th>Delete review</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t  </thead>\n\t\t\t\t\t  <tbody>";
     foreach ($reviews as $review) {
         $result = $result . "<tr>\n\t\t\t\t\t\t  <td>{$review->idReview}</td>\n\t\t\t\t\t\t  <td><div style='width:600px;height:40px;overflow:auto;'>{$review->description}</div></td>\n\t\t\t\t\t\t  <td>{$review->idUser}</td>\n\t\t\t\t\t\t  <td>{$review->idBook}</td>\n\t\t\t\t\t\t  <td>{$review->approved}</td>\n\t\t\t\t\t\t  <td>\n\t\t\t\t\t\t\t<form action='' method='post'>\n\t\t\t\t\t\t\t<!--<input type='image' src='img/check.png' alt='submit' style = 'width: 40px; height: 40px;' name='approve'/>-->\n\t\t\t\t\t\t\t<input type='hidden' name='idreview' value='{$review->idReview}' />\n\t\t\t\t\t\t\t<input type='submit' name='approve' value='' id='approve'/>\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t</form>\n\t\t\t\t\t\t  </td>\n\t\t\t\t\t\t  \n\t\t\t\t\t\t  <td>\n\t\t\t\t\t\t\t<form action='' method='post'>\n\t\t\t\t\t\t\t<!--<input type='image' src='img/check.png' alt='submit' style = 'width: 40px; height: 40px;' name='approve'/>-->\n\t\t\t\t\t\t\t<input type='hidden' name='idreview' value='{$review->idReview}' />\n\t\t\t\t\t\t\t<input type='submit' name='deletereview' value='' id='deletereview'/>\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t</form>\n\t\t\t\t\t\t  </td>\n\t\t\t\t\t\t</tr>";
     }
     $result = $result . "</tbody>\n\t\t\t\t\t</table>\n\t\t\t\t\t</div>";
     return $result;
 }
 public static function getAllowedSubmissions($intMemberId, $blnRemoveAlreadyReviewed = false)
 {
     $arrSubmissions = array();
     if ($intMemberId && ($objSubmissions = static::findAll()) !== null) {
         while ($objSubmissions->next()) {
             if ($objSubmissions->published && in_array($intMemberId, deserialize($objSubmissions->allowedJids, true))) {
                 $objReview = ReviewModel::findOneBy(array('sid=?', 'jid=?'), array($objSubmissions->id, $intMemberId));
                 // check for already existing reviews by the member for the current submission
                 if (!$blnRemoveAlreadyReviewed || $blnRemoveAlreadyReviewed && (!$objReview || \Input::get('id') == $objReview->id)) {
                     $arrSubmissions[] = $objSubmissions->current();
                 }
             }
         }
     }
     return $arrSubmissions;
 }
Пример #5
0
 public static function postReview($url_parts)
 {
     require_once 'Review.model.php';
     $data = array();
     if (isset($_POST['sendreview'])) {
         $rate = $_POST['rate'];
         $comment = $_POST['comment'];
         $seller_id = $_POST['seller_id'];
         try {
             $result = ReviewModel::reviewPosted($rate, $comment, $seller_id);
             $data['template'] = 'reviewSuccess.html';
         } catch (Exception $e) {
             $data['error'] = $e->getMessage();
             $data['template'] = 'error.html';
         }
     }
     return $data;
 }
*/
session_start();
include "../classes/User.php";
include "../classes/BookingDetails.php";
include "../classes/FlightSearchParameters.php";
include "../classes/FlightDetails.php";
include "../classes/Review.php";
include "../classes/Passenger.php";
include "../model/UserAccountModel.php";
include "../model/BookingModel.php";
include "../model/FlightModel.php";
include "../model/ReviewModel.php";
$userModel = new UserAccountModel();
$bookingModel = new BookingModel();
$flightModel = new FlightModel();
$reviewModel = new ReviewModel();
if ($_SESSION['action'] == "login") {
    $user = unserialize($_SESSION['user']);
    $arrayOfBookings = array();
    if ($userModel->isUserPresent($user->getLoginId(), $user->getPassword()) == true) {
        $user = $userModel->getUserInstance($user->getLoginId(), $user->getPassword());
        $_SESSION['userId'] = $user->getUserId();
        $_SESSION['userMiles'] = $user->getMiles();
        $_SESSION['loginName'] = $user->getLoginId();
        $arrayOfBookings = $bookingModel->getBookings($user->getUserId());
        $_SESSION['bookingsArray'] = serialize($arrayOfBookings);
        header("Location: ../view/Startup.php");
    } else {
        $_SESSION['loginToken'] = "invalid";
        header("Location: ../view/Login.php");
    }