<div class="navbar-inner">
<a class="brand" href='?'><?php
echo $project_title;
?>
</a>
<!-- -->
<ul class="nav">
<li class='tab-header active algo-header' id='tab-movies'><a href="#" onclick='show_tabs("movies")'>Movies</a></li>
<li class='dropdown tab-header' id='header-recommendationalgos'>
<a class='dropdown-toggle' href="#" data-toggle="dropdown" id='tab-recommendationalgos' >Recommendation Algos <b class="caret"></b></a>
<ul class="dropdown-menu" aria-labelledby="tab-recommendationalgos">
<?php
$sql = "SELECT DISTINCT algorithm FROM recommendations";
$stat = prepareStatement($sql);
$stat->execute();
$rows = $stat->fetchAll();
foreach ($rows as $row) {
$algo = $row['algorithm'];
print "<li id='tab-" . $algo . "' class='algo-header'><a href='#' onclick='show_rec_tabs(\"{$algo}\")'>{$algo}</a></li>";
}
?>
</ul>
</li>
<li class='tab-header algo-header' id='tab-hybrid'><a href="#" onclick='show_tabs("hybrid")'>Hybrid</a></li>
<li class='tab-header algo-header' id='tab-stats'><a href="#" onclick='show_tabs("stats")'>Stats</a></li>
<li class="divider-vertical"></li>
<li class='dropdown'>
public function saveAlgorithmWeights($algos, $user)
{
//clear old weights
$sql = "DELETE FROM algorithmweights WHERE userid=?";
$stat = prepareStatement($sql);
$stat->bindParam(1, $user);
$stat->execute();
//insert new ones
foreach ($algos as $algo => $score) {
$sql = "INSERT INTO algorithmweights (algorithm, weight, userid) VALUES (?,?,?)";
$stat = prepareStatement($sql);
$stat->bindParam(1, $algo);
$stat->bindParam(2, $score);
$stat->bindParam(3, $user);
$stat->execute();
}
}
function get_number_of_hybridrecommendations($user)
{
$sql = "SELECT COUNT(*) FROM h_recommendations WHERE userid=?";
$stat = prepareStatement($sql);
$stat->bindParam(1, $user);
$stat->execute();
$res = $stat->fetchAll();
return $res[0][0];
}
function sync_ratings()
{
$sql = "SELECT ratings.userid, ratings.movieid, ratings.rating, UNIX_TIMESTAMP(ratings.time) as time, movies.title, movies.year from ratings INNER JOIN movies ON ratings.movieid = movies.movieid";
$stat = prepareStatement($sql);
$stat->execute();
$rows = $stat->fetchAll();
$local_path = str_replace('actions.php', '', __FILE__) . 'calc_recs';
$rating_file = 'ratings.dat';
$fh = fopen("{$local_path}/{$rating_file}", 'w') or die("can't open file");
foreach ($rows as $row) {
//999999::1::4::1357741027
$userid = $row['userid'];
$movieid = $row['movieid'];
#IMDb ID must be 7 chars long
while (strlen($movieid) < 7) {
$movieid = '0' . $movieid;
}
$rating = $row['rating'];
//0000-00-00 00:00:00
$thetime = $row['time'];
$title = trim($row['title']);
$year = trim($row['year']);
fwrite($fh, $userid . '::' . $movieid . '::' . $rating . '::' . $thetime . "\n");
}
fclose($fh);
}
