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;
