public function action_log()
{
$user = $this->is_logged();
if ($user === false) {
$try = new User_lif();
$try->set_username_user_lif($_POST['user']);
$try->set_password_user_lif($_POST['pw']);
$this->_id = $try->attempt();
if ($this->_id) {
$user = new User_lif();
$user->set_id_user_lif($this->_id);
$user->load();
Session::put('user', $user);
return Redirect::to_action('home@index');
}
$this->_error_form = "Identifiant ou mot de passe éronné, veuillez réessayer svp.";
return Redirect::to_action('login')->with('error_msg', $this->_error_form);
}
}
public function action_index()
{
$user = $this->is_logged();
if ($user === false) {
return Redirect::to_action('login');
} else {
$song_count = Song::count();
$album_count = Album::count();
$band_count = band::count();
$playlist_count = Playlist::count();
$user_count = User_lif::count();
$best_year_song = DB::query('SELECT date_song, count(*) as count FROM song GROUP BY date_song HAVING count ORDER BY count DESC LIMIT 1');
$max_in_playlist = DB::query('SELECT count(s.id_song) as count, b.name_band, s.`title_song` FROM song s JOIN songplaylist so ON s.id_song = so.id_song JOIN songalbum son ON s.id_song = son.id_song JOIN album a ON son.id_album = a.id_album JOIN band b ON a.id_band = b.id_band GROUP BY s.title_song HAVING count ORDER BY count DESC LIMIT 3');
//var_dump($best_year_song);
}
return View::make('stats.index')->with('song_count', $song_count)->with('album_count', $album_count)->with('best_year_song', $best_year_song)->with('playlist_count', $playlist_count)->with('user_count', $user_count)->with('max_in_playlist', $max_in_playlist)->with('band_count', $band_count);
}
public function action_add_user()
{
if ($_POST['user'] != "") {
$this->_username = $_POST['user'];
} else {
$this->_error_form = true;
}
if ($_POST['name'] != "" and $this->_error_form == false) {
$this->_name = $_POST['name'];
} else {
$this->_error_form = true;
}
if ($_POST['fname'] != "" and $this->_error_form == false) {
$this->_fname = $_POST['fname'];
} else {
$this->_error_form = true;
}
if ($_POST['pw'] != "" and $this->_error_form == false) {
$this->_password = Hash::make($_POST['pw']);
} else {
$this->_error_form = true;
}
if ($this->_error_form == true) {
$this->_client_msg = "Veuillez remplir tous les champs svp";
return Redirect::to_action('signin')->with('error_msg', $this->_client_msg);
} else {
$user = new User_lif(null, $this->_username, $this->_password, $this->_name, $this->_fname, null);
if ($user->check_exists() == false and $this->_error_form == false) {
$user->set_id_user_lif($user->add());
$user->load();
Session::put('user', $user);
$this->_client_msg = "Enregistrement réussi ! Bienvenue" . $this->_username;
return Redirect::to_action('home@index');
} else {
$this->_client_msg = "Le nom d'utilisteur est déjà utilisé. Veuillez en saisir un nouveau.";
return Redirect::to_action('signin')->with('error_msg', $this->_client_msg);
}
}
}
public function action_add_user_to_playlist()
{
$user = $this->is_logged();
if ($user === false) {
return Redirect::to_action('login');
} else {
$username = new User_lif(null, $_POST['username']);
if ($username->check_exists($_POST['username'])) {
$username->load_from_username();
$ap = new adminPlaylist($username->get_id_user_lif(), $_POST['id_playlist']);
if ($ap->check_exists() == null) {
$ap->set_code_admin('I');
$ap->add();
if ($ap->check_exists() == 1) {
echo 1;
} else {
echo 0;
}
} else {
echo -1;
}
} else {
echo -2;
}
}
}
