/** * Dispatch get actions * * @param array $segments Method segments indicate action and resource * * @return void */ public function restGet($segments) { $action_id = $segments[0]; switch ($action_id) { case 'get-song-audio-td': $validate_song_id = LMValidateHelper::validateNoEmpty($_GET['song_id']); if (!$validate_song_id) { $type = 'not_exist_value'; $parameter = array("none" => "none"); $error_messanger = new LMErrorMessenger($type, $parameter); $error_messanger->printErrorJSON(); unset($error_messanger); } else { $song_id = $_GET['song_id']; require SITE_ROOT . "/ajax-action/SongActionView/song-audio-td.php"; } break; case 'song-list': $offset = $_GET['offset']; if (!LMValidateHelper::validateNoEmpty($offset)) { $offset = 0; } $length = $_GET['length']; if (!LMValidateHelper::validateNoEmpty($length)) { $length = 33; } switch ($_GET['song_list_type']) { case 'audio': $song_list_type = 'audio'; break; case 'no-audio': $song_list_type = 'no-audio'; break; case 'all': default: $song_list_type = 'all'; break; } $song_god_obj = new LMSongGod(); $song_list = $song_god_obj->getList($song_list_type, $offset, $length); require SITE_ROOT . "/ajax-action/SongActionView/song-list.php"; unset($song_god_obj); break; default: $type = 'page_not_found'; $parameter = array("none" => "none"); $error_messanger = new LMErrorMessenger($type, $parameter); $error_messanger->printErrorJSON(); unset($error_messanger); break; } }
case 'no-audio': $song_list_type = 'no-audio'; break; case 'all': default: $song_list_type = 'all'; break; } $song_god_obj = new LMSongGod(); if (isset($_GET['search_query']) && !empty($_GET['search_query'])) { $song_list = $song_god_obj->search($_GET['search_query']); } else { $song_list = $song_god_obj->getList($song_list_type, $offset, $length); } require SITE_ROOT."/ajax-action/SongActionView/song-list.php"; unset($song_god_obj); ?>
* * @category PHP * @package /p-schedule/ * @author Fukuball Lin <*****@*****.**> * @license No Licence * @version Release: <1.0> * @link http://sarasti.cs.nccu.edu.tw */ require_once dirname(dirname(__FILE__)) . "/p-config/application-setter.php"; $kkbox_link = 'http://tw.kkbox.com'; $db_obj = LMDBAccess::getInstance(); $performer_god_obj = new LMPerformerGod(); $composer_god_obj = new LMComposerGod(); $lyricist_god_obj = new LMLyricistGod(); $disc_god_obj = new LMDiscGod(); $song_god_obj = new LMSongGod(); $select_sql = "SELECT " . "* " . "FROM temp_midi " . "WHERE " . "is_moved='0' AND kkbox_url != '' AND memo=''"; $query_result = $db_obj->selectCommand($select_sql); // get unprocess data foreach ($query_result as $query_result_data) { $midi_id = $query_result_data['id']; echo "create midi_id {$midi_id} \n"; $artist_title = $query_result_data['artist_title']; $song_title = $query_result_data['song_title']; $midi_path = $query_result_data['midi_path']; $temp_kkbox_url = $query_result_data['kkbox_url']; // get song detail $yql_query = urlencode('SELECT * FROM html WHERE url="' . $temp_kkbox_url . '"'); $song_page_html = file_get_contents('http://query.yahooapis.com/v1/public/yql?q=' . $yql_query . '&format=json'); $song_page_dom = json_decode($song_page_html); //print_r($song_page_dom);