예제 #1
0
파일: Liste.php 프로젝트: hlag/svs
 public function getSongs($status)
 {
     if ($status == 'all') {
         $songs = AGDO::getInstance()->GetAll("SELECT * FROM SVsongs LEFT OUTER JOIN sv_song_genres ON g_id = website ORDER BY title");
     } elseif ($status == 'repertoire') {
         $songs = AGDO::getInstance()->GetAll("SELECT * FROM SVsongs LEFT OUTER JOIN sv_song_genres ON g_id = website WHERE probe != 1 AND probe != 5 ORDER BY title");
     } elseif ($status == 'uebrige') {
         $songs = AGDO::getInstance()->GetAll("SELECT * FROM SVsongs LEFT OUTER JOIN sv_song_genres ON g_id = website WHERE probe != 1 AND probe != 5 ORDER BY g_id,  title");
     } elseif ($status == 'erschienen') {
         $songs = AGDO::getInstance()->GetAll("SELECT * FROM SVsongs LEFT OUTER JOIN sv_song_genres ON g_id = website  ORDER BY erschienen DESC");
     } elseif ($status == 2) {
         $dringend = AGDO::getInstance()->GetAll("SELECT * FROM SVsongs LEFT OUTER JOIN sv_song_genres ON g_id = website WHERE probe = 3 ORDER BY title");
         $proben = AGDO::getInstance()->GetAll("SELECT * FROM SVsongs LEFT OUTER JOIN sv_song_genres ON g_id = website WHERE probe = 2 ORDER BY title");
         $sonstige = AGDO::getInstance()->GetAll("SELECT * FROM SVsongs LEFT OUTER JOIN sv_song_genres ON g_id = website WHERE probe = 4 ORDER BY letzteProbe");
         $songs = array_merge($dringend, $proben, $sonstige);
     } elseif ($status == 5) {
         $songs = AGDO::getInstance()->GetAll("SELECT * FROM SVsongs LEFT OUTER JOIN sv_song_genres ON g_id = website WHERE\n                    angefangen > '" . date("Y-m-d", time() - 3600 * 24 * 21) . "' OR probe = '5' ORDER BY angefangen DESC");
     } else {
         $songs = AGDO::getInstance()->GetAll("SELECT * FROM SVsongs LEFT OUTER JOIN sv_song_genres ON g_id = website WHERE probe = '" . $status . "' ORDER BY title");
     }
     foreach ($songs as $song) {
         $song['b'] = $song['c'];
         $song['arr_b'] = $song['arr_c'];
         $song['arr_t'] = '';
         $song['arr_p'] = '';
         $S = new Song();
         $S->setSong($song);
         $this->songs[$song['id']] = $S;
     }
     return $this->songs;
 }
예제 #2
0
파일: playlistSongs.php 프로젝트: hlag/svs
 public function setSong($song)
 {
     parent::setSong($song);
     $this->ps_id = $song['ps_id'];
     $this->pl_id = $song['pl_id'];
     $this->pb_id = $song['pb_id'];
     $this->pl_datum = $song['pl_datum'];
     $this->setPlayedButton();
 }