public function get($season, $episode) { $episode = Episode::with(['doctors', 'companions', 'enemies'])->where('season', $season)->where('episode', $episode)->first(); $ratings = Rating::getRating('episode', $episode->id); $comments = Comment::where('item_id', $episode->id)->where('item_type', 'episode')->with('user')->orderBy('created_at', 'desc')->get(); return View::make('items.episode', ['episode' => $episode, 'ratings' => $ratings, 'comments' => $comments]); }
public function get($id) { $enemy = Enemy::with('episodes')->find($id); $ratings = Rating::getRating('enemy', $id); $comments = Comment::where('item_id', $id)->where('item_type', 'enemy')->with('user')->orderBy('created_at', 'desc')->get(); return View::make('items.enemy', ['enemy' => $enemy, 'ratings' => $ratings, 'comments' => $comments]); }
public function get($id) { $doctor = Doctor::with(['companions', 'episodes'])->find($id); $ratings = Rating::getRating('doctor', $id); $comments = Comment::where('item_id', $id)->where('item_type', 'doctor')->with('user')->orderBy('created_at', 'desc')->get(); return View::make('items.doctor', ['doctor' => $doctor, 'ratings' => $ratings, 'comments' => $comments]); }
public function starRating($recipeId, $id = null, $value = null) { $session = Zend_Registry::get('session'); $log = Zend_Registry::get('log'); // fetch the rating $ra = new Rating(); $rating = $ra->getRating($recipeId); // If were passing through a value we already know what to display and are probably read only if (isset($value)) { return $this->displayRating($value, $id); } // Logged in? if (!$session->user) { return $this->displayRating($rating); } //$log->debug( $session->user['name'] . ' is logged in' ); $r = new Recipe(); if ($r->isOwner($recipeId)) { return $this->displayRating($rating); } //$log->debug( $session->user['name'] . ' is not the owner' ); // Has this user already rated? $db = Zend_Registry::get('db'); $select = $db->select()->from('ratings', array("numberOfRatings" => "COUNT(*)"))->where("recipe_id = ?", $recipeId)->where("user_id = ?", $session->user['id']); //$log->debug( $select->__toString() ); //$log->debug( $db->fetchOne( $select ) ); // If we get a result show the user the overall rating if ($db->fetchOne($select) > 0) { return $this->displayRating($rating); } //$log->debug( $session->user['name'] . ' has not already rated this' ); // Otherwise show the rating but make it clickable return $this->displayRating($rating, null, false); }
} elseif (sotf_Utils::getParameter('comment')) { $reply_to = sotf_Utils::getParameter('comment'); $page->redirect($_SERVER["PHP_SELF"] . "?id=" . $id . "&reply_to=" . $reply_to . "#edit"); //redirect page, prevent resend of data } } $reply_to = sotf_Utils::getParameter('reply_to'); $smarty->assign('reply_to', $reply_to); $smarty->assign('reply_title', $comments[$reply_to]['title']); $smarty->assign('email', $_SESSION['email']); } if ($settings["rating"] and ($user->loggedIn() or $settings["a_rating"])) { $value = (int) sotf_Utils::getParameter('rating'); if (sotf_Utils::getParameter('rate_it') and $value != 0) { $rating->setRating($id, $value); $r = $rating->getRating($id); $r['prog_id'] = $id; $r['user_name'] = $user->getName(); $r['user_email'] = $user->getEmail(); $r['host'] = getHostName(); $r['authkey'] = $page->getAuthKey(); $portal->addEvent("rating", $r); $page->redirect($_SERVER["PHP_SELF"] . "?id=" . $id); //redirect page, prevent resend of data } } $smarty->assign('comments', $comments); $result = $portal->getProgrammes(array($id)); $result = $result[0]; if ($result === NULL) { $page->redirect($_SERVER["PHP_SELF"]);
/** * Complete an offer if both ratings have been completed * * @param $id */ static function completeOffer($id) { $offer = self::getOfferSingle($id); $advertisement = Advertisement::getAdvertisement($offer['advertisement']); if (Rating::getRating($id, $offer['owner']) != null && Rating::getRating($id, $advertisement['owner']) != null) { $mysql = new MySQL(); $results = $mysql->query('UPDATE offer SET status = 3 WHERE id = :id', [':id' => $id]); } }
function getItemById($itemId) { $item = array(); $iid = $itemId; $colsArray = array("item" => array(1, 3, 4, 5, 6, 7, 9, 10, 11), "address" => array(3, 4, 5)); $colStr = getSqlColumns($colsArray); $query = "SELECT {$colStr} FROM `item`, `address` WHERE `item`.`iid`={$iid} AND `item`.`aid`=`address`.`aid`;"; if ($result = mysql_query($query)) { while ($res = mysql_fetch_array($result)) { $item = getSqlData($colsArray, $res); } } $rate = new Rating(); $item["rating"] = $rate->getRating($itemId); $comments = $this->getComments($itemId); $replies = $this->getReply($itemId); foreach ($comments as $cid => $allData) { if (!isset($comments[$cid]["replies"])) { $comments[$cid]["replies"] = array(); } if (isset($replies[$cid])) { $comments[$cid]["replies"] = $replies[$cid]; } } $item["comments"] = $comments; return $item; }
define('DBUSER', 'root'); define('DBPASS', ''); define('DBNAME', 'lbs_db'); // if NRRTG is 0, the user can rate multiple items in a day, if it is 1, the user can rate only one item in a day define('NRRTG', 0); // If you want than only the logged users to can rate the element(s) on page, sets USRRATE to 0 // And sets $_SESSION['username'] with the session that your script uses to keep logged users define('USRRATE', 1); if (USRRATE !== 1) { if (!isset($_SESSION)) { session_start(); } if (isset($_SESSION['username'])) { define('RATER', $_SESSION['username']); } } /* From Here no need to modify */ //if(!headers_sent()) header('Content-type: text/html; charset=utf-8'); // header for utf-8 include 'class.Rating.php'; // Include Rating class $obRtg = new Rating(); // if data from POST 'elm' and 'rate' if (isset($_POST['elm']) && isset($_POST['rate'])) { // removes tags and external whitespaces from 'elm' $_POST['elm'] = array_map('strip_tags', $_POST['elm']); $_POST['elm'] = array_map('trim', $_POST['elm']); if (!empty($_POST['rate'])) { $_POST['rate'] = intval($_POST['rate']); } echo $obRtg->getRating($_POST['elm'], $_POST['rate']); }
if ($page['user']['usertype'] != "1") { Session::setError('You are not able to view offers for an advertisement'); Session::redirect('/'); } // make sure is valid advertisement $advertisement = Advertisement::getAdvertisement($page['parameters']['id']); if ($advertisement == null) { Session::setError('Advertisement does not exist.'); Session::redirect('/'); } // make sure the advertisement is owned by the user if ($advertisement['owner'] != $page['user']['id']) { Session::setError('You do not own this advertisement'); Session::redirect('/'); } $page['advertisement'] = $advertisement; $offers = Offer::getOffersForAdvertisement($advertisement['id']); $page['offers'] = $offers; foreach ($page['offers'] as &$offer) { $offer['ownerDetails'] = User::getUser($offer['owner']); if ($offer['status'] == "3") { $offer['yourRating'] = Rating::getRating($offer['id'], User::getId()); if ($offer['yourRating'] != null) { $offer['yourRating']['rating'] = Rating::getStarsArray($offer['yourRating']['rating']); } $offer['theirRating'] = Rating::getRating($offer['id'], $offer['ownerDetails']['id']); if ($offer['theirRating'] != null) { $offer['theirRating']['rating'] = Rating::getStarsArray($offer['theirRating']['rating']); } } }
} else { Session::redirect('/profile'); } } // make sure the advertisement exists $advertisement = Advertisement::getAdvertisement($offer['advertisement']); if ($advertisement == null) { Session::setError('Advertisement does not exist, please check the URL and try again'); if ($page['user']['usertype'] == "1") { Session::redirect('/advertisement/' . $offer['advertisement']); } else { Session::redirect('/profile'); } } // make sure a rating hasn't already been done $rating = Rating::getRating($offer['id'], User::getId()); if ($rating != null) { Session::setError('You have already completed a rating for this offer.'); if ($page['user']['usertype'] == "1") { Session::redirect('/advertisement/' . $offer['advertisement']); } else { Session::redirect('/profile'); } } // if the form is posted if ($_SERVER['REQUEST_METHOD'] === 'POST') { $ratingScore = (int) $_POST['rating']['score']; if ($ratingScore > 5) { $ratingScore = 5; } elseif ($ratingScore < 1) { $ratingScore = 1;