/**
* Dispatch post actions
*
* @param array $segments Method segments indicate action and resource
*
* @return void
*/
public function restPost($segments)
{
$action_id = $segments[0];
switch ($action_id) {
case 'add-song':
$validate_song_title = LMValidateHelper::validateNoEmpty($_POST['song_title']);
$validate_lyric = LMValidateHelper::validateNoEmpty($_POST['lyric']);
$validate_song_kkbox_url = LMValidateHelper::validateNoEmpty($_POST['song_kkbox_url']);
$validate_disc_cover = LMValidateHelper::validateNoEmpty($_POST['disc_cover']);
$validate_genre = LMValidateHelper::validateNoEmpty($_POST['genre']);
$validate_release_date = LMValidateHelper::validateNoEmpty($_POST['release_date']);
$validate_disc_kkbox_url = LMValidateHelper::validateNoEmpty($_POST['disc_kkbox_url']);
$validate_disc_title = LMValidateHelper::validateNoEmpty($_POST['disc_title']);
$validate_composer = LMValidateHelper::validateNoEmpty($_POST['composer']);
$validate_lyricist = LMValidateHelper::validateNoEmpty($_POST['lyricist']);
$validate_artist_name = LMValidateHelper::validateNoEmpty($_POST['artist_name']);
$validate_artist_kkbox_url = LMValidateHelper::validateNoEmpty($_POST['artist_kkbox_url']);
if (!$validate_artist_name || !$validate_artist_kkbox_url || !$validate_composer || !$validate_lyricist || !$validate_disc_title || !$validate_disc_kkbox_url || !$validate_release_date || !$validate_genre || !$validate_disc_cover || !$validate_song_title || !$validate_lyric || !$validate_song_kkbox_url) {
$type = 'not_exist_value';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
} else {
$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();
$composer = $_POST['composer'];
$lyricist = $_POST['lyricist'];
$artist_name = $_POST['artist_name'];
$artist_kkbox_url = $_POST['artist_kkbox_url'];
$disc_title = $_POST['disc_title'];
$disc_kkbox_url = $_POST['disc_kkbox_url'];
$genre = $_POST['genre'];
$release_date = $_POST['release_date'];
$disc_cover = $_POST['disc_cover'];
$song_title = $_POST['song_title'];
$lyric = $_POST['lyric'];
$song_kkbox_url = $_POST['song_kkbox_url'];
$have_english = $_POST['have_english'];
$only_english = $_POST['only_english'];
/*if ($have_english=='on') {
$have_english = 1;
} else {
$have_english = 0;
}*/
// get lyricist id
$lyricist_id = $lyricist_god_obj->findByName($lyricist);
if (empty($lyricist_id)) {
$parameter_array = array();
$parameter_array['name'] = $lyricist;
$lyricist_id = $lyricist_god_obj->create($parameter_array);
}
// get composer id
$composer_id = $composer_god_obj->findByName($composer);
if (empty($composer_id)) {
$parameter_array = array();
$parameter_array['name'] = $composer;
$composer_id = $composer_god_obj->create($parameter_array);
}
// get performer id
$performer_id = $performer_god_obj->findByKKBOXURL($artist_kkbox_url);
if (empty($performer_id)) {
$parameter_array = array();
$parameter_array['name'] = $artist_name;
$parameter_array['kkbox_url'] = $artist_kkbox_url;
$performer_id = $performer_god_obj->create($parameter_array);
}
// get disc id
$disc_id = $disc_god_obj->findByKKBOXURL($disc_kkbox_url);
if (empty($disc_id)) {
$parameter_array = array();
$parameter_array['title'] = $disc_title;
$parameter_array['kkbox_url'] = $disc_kkbox_url;
$parameter_array['release_date'] = $release_date;
$parameter_array['cover_path'] = $disc_cover;
$parameter_array['genre'] = $genre;
$parameter_array['performer_id'] = $performer_id;
$disc_id = $disc_god_obj->create($parameter_array);
}
// get song id
$song_id = $song_god_obj->findByKKBOXURL($song_kkbox_url);
if (empty($song_id)) {
$parameter_array = array();
$parameter_array['title'] = $song_title;
$parameter_array['lyric'] = $lyric;
$parameter_array['kkbox_url'] = $song_kkbox_url;
$parameter_array['release_date'] = $release_date;
$parameter_array['genre'] = $genre;
$parameter_array['performer_id'] = $performer_id;
$parameter_array['composer_id'] = $composer_id;
$parameter_array['lyricist_id'] = $lyricist_id;
$parameter_array['disc_id'] = $disc_id;
$parameter_array['have_english'] = $have_english;
$parameter_array['only_english'] = $only_english;
if ($song_god_obj->create($parameter_array)) {
$type = 'success';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
} else {
$type = 'unknow_error';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
}
}
// end if (empty($song_id))
}
break;
case 'check-add-song':
$validate_check_song_kkbox_url = LMValidateHelper::validateNoEmpty($_POST['check_song_kkbox_url']);
if (!$validate_check_song_kkbox_url) {
$type = 'not_exist_value';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
} else {
$check_song_kkbox_url = $_POST['check_song_kkbox_url'];
$song_god_obj = new LMSongGod();
$instance_id = 0;
$instance_id = $song_god_obj->findBYKKBOXURL($check_song_kkbox_url);
if ($instance_id) {
$html_block = 'song_exist';
echo $html_block;
} else {
$kkbox_link = 'http://tw.kkbox.com';
$song_kkbox_url = $check_song_kkbox_url;
// get song detail
$yql_query = urlencode('SELECT * FROM html WHERE url="' . $song_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);
// get lyric info
$kk_lyric = $song_page_dom->query->results->body->div[3]->div[1]->div[0]->div[2]->p->content;
//print_r($kk_lyric);
// parse wrighter
$kk_lyric_array = explode('：', $kk_lyric);
//print_r($kk_lyric_array);
// parse lyricist
$parse_lyricist = explode(' ', $kk_lyric_array[1]);
$in_lyricist_name = trim($parse_lyricist[0]);
// parse lyricist
//$parse_composer = explode(' ', $kk_lyric_array[2]);
$parse_composer = explode("\n", $kk_lyric_array[2]);
$in_composer_name = trim($parse_composer[0]);
// parse lyric
//$parse_lyric = explode("\n", $kk_lyric_array[4]);
$parse_lyric = explode("\n", $kk_lyric_array[2]);
$parse_lyric = array_slice($parse_lyric, 1);
//print_r($parse_lyric);
$normalize_lyric_array = array();
foreach ($parse_lyric as $key => $value) {
$normal_value = nl2br(trim($value));
$normal_value = str_replace('<br />', '', $normal_value);
$normal_value = str_replace('<br/>', '', $normal_value);
$normal_value = str_replace('<br>', '', $normal_value);
if ($normal_value != '') {
array_push($normalize_lyric_array, trim($value));
}
}
//print_r($normalize_lyric_array);
$in_lyric = implode("\n", $normalize_lyric_array);
// get performer info
$in_performer_name = trim($song_page_dom->query->results->body->div[3]->div[0]->ul->li[1]->a->content);
$in_performer_url = $kkbox_link . $song_page_dom->query->results->body->div[3]->div[0]->ul->li[1]->a->href;
// get disc info
$in_disc_name = trim($song_page_dom->query->results->body->div[3]->div[0]->ul->li[2]->a->content);
$in_disc_url = $kkbox_link . $song_page_dom->query->results->body->div[3]->div[0]->ul->li[2]->a->href;
$in_disc_src = $song_page_dom->query->results->body->div[3]->div[1]->div[0]->div[1]->div->div[0]->img->src;
//print_r($song_page_dom->query->results->body->div[3]->div[1]->div[0]->div[1]);
$in_disc_genre = $song_page_dom->query->results->body->div[3]->div[1]->div[0]->div[1]->div->div[1]->dl->dd[1]->p;
$in_disc_release = trim($song_page_dom->query->results->body->div[3]->div[1]->div[0]->div[1]->div->div[1]->dl->dd[2]->p) . '-01';
// get song info
$in_song_name = trim($song_page_dom->query->results->body->div[3]->div[0]->ul->li[3]->a->content);
//$in_song_url = $kkbox_link.$song_page_dom->query->results->body->div[3]->div[0]->ul->li[3]->a->href;
require SITE_ROOT . "/ajax-action/SongActionView/add-song-form.php";
}
unset($song_god_obj);
}
break;
case 'delete-lyric-block':
$validate_lyrics_block_truth_id = LMValidateHelper::validateNoEmpty($_POST['lyrics_block_truth_id']);
if (!$validate_lyrics_block_truth_id) {
$type = 'not_exist_value';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
} else {
$lyrics_block_truth_id = $_POST['lyrics_block_truth_id'];
$lyrics_block_truth_obj = new LMLyricsBlockTruth($lyrics_block_truth_id);
if ($lyrics_block_truth_obj->destroy()) {
$type = 'success';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
} else {
$type = 'unknow_error';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
}
unset($lyrics_block_truth_obj);
}
break;
case 'save-lyric-block':
$validate_block = LMValidateHelper::validateNoEmpty($_POST['block']);
$validate_label_id = LMValidateHelper::validateNoEmpty($_POST['label_id']);
$validate_lyrics_block_truth_id = LMValidateHelper::validateNoEmpty($_POST['lyrics_block_truth_id']);
if (!$validate_lyrics_block_truth_id || !$validate_block || !$validate_label_id) {
$type = 'not_exist_value';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
} else {
$lyrics_block_truth_id = $_POST['lyrics_block_truth_id'];
$block = $_POST['block'];
$label_id = $_POST['label_id'];
$lyrics_block_truth_obj = new LMLyricsBlockTruth($lyrics_block_truth_id);
$lyrics_block_truth_obj->block = $block;
$lyrics_block_truth_obj->label_id = $label_id;
if ($lyrics_block_truth_obj->save()) {
$type = 'success';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
} else {
$type = 'unknow_error';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
}
unset($lyrics_block_truth_obj);
}
break;
case 'add-lyric-block':
$validate_song_id = LMValidateHelper::validateNoEmpty($_POST['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 = $_POST['song_id'];
$lyrics_block_truth_god_obj = new LMLyricsBlockTruthGod();
$parameter_array['song_id'] = $song_id;
$song_lyrics_block_id = $lyrics_block_truth_god_obj->create($parameter_array);
if ($song_lyrics_block_id) {
require SITE_ROOT . "/ajax-action/SongActionView/song-lyrics-block-form.php";
} else {
$type = 'unknow_error';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
}
}
break;
case 'edit-lyric':
$validate_song_id = LMValidateHelper::validateNoEmpty($_POST['edit_lyric_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 = $_POST['edit_lyric_song_id'];
$song_lyric = $_POST['edit_lyric_content'];
$song_obj = new LMSong($song_id);
$song_obj->lyric = $song_lyric;
if ($song_obj->save()) {
$type = 'success';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
} else {
$type = 'unknow_error';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
}
unset($song_obj);
}
break;
case 'upload-audio':
// 5 minutes execution time
@set_time_limit(5 * 60);
$validate_song_id = LMValidateHelper::validateNoEmpty($_POST['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 = $_POST['song_id'];
$target_file_name = AUDIO_ROOT . '/' . $song_id;
$retunr_value = LMUploadHelper::pluploadProcess($_REQUEST, $_SERVER, $_FILES, $target_file_name);
if ($retunr_value != 'fail') {
$song_obj = new LMSong($song_id);
$song_obj->audio_path = $retunr_value;
if ($song_obj->save()) {
$type = 'success';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
} else {
$type = 'unknow_error';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
}
unset($song_obj);
} else {
$type = 'unknow_error';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
}
}
break;
case 'upload-midi':
// 5 minutes execution time
@set_time_limit(5 * 60);
$validate_song_id = LMValidateHelper::validateNoEmpty($_POST['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 = $_POST['song_id'];
$target_file_name = MIDI_ROOT . '/' . $song_id;
$retunr_value = LMUploadHelper::pluploadProcess($_REQUEST, $_SERVER, $_FILES, $target_file_name);
if ($retunr_value != 'fail') {
$song_obj = new LMSong($song_id);
$song_obj->midi_path = $retunr_value;
if ($song_obj->save()) {
$type = 'success';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
} else {
$type = 'unknow_error';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
}
unset($song_obj);
} else {
$type = 'unknow_error';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
}
}
break;
default:
$type = 'page_not_found';
$parameter = array("none" => "none");
$error_messanger = new LMErrorMessenger($type, $parameter);
$error_messanger->printErrorJSON();
unset($error_messanger);
break;
// end default
}
// end switch ($action_id)
}
*
* @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";
$db_obj = LMDBAccess::getInstance();
$select_sql = "SELECT " . "id " . "FROM song " . "WHERE is_deleted = '0' " . "AND audio_path!='' " . "AND echonest_track_id!='' " . "AND retrieval_status='success' " . "ORDER BY id";
$query_result = $db_obj->selectCommand($select_sql);
$music_feature_god = new LMMusicFeatureGod();
// get unprocess data
foreach ($query_result as $query_result_data) {
$song_obj = new LMSong($query_result_data['id']);
$echonest_analysis_file = AUDIO_ROOT . '/' . $song_obj->getId() . '.json';
$echonest_analysis = file_get_contents($echonest_analysis_file);
$echonest_data = json_decode($echonest_analysis);
$second = $echonest_data->meta->seconds;
$bar_count = count($echonest_data->bars);
$beat_count = count($echonest_data->beats);
$tatum_count = count($echonest_data->tatums);
$section_count = count($echonest_data->sections);
$segment_count = count($echonest_data->segments);
$bar_duration_sum = 0;
foreach ($echonest_data->bars as $bars_data) {
$bar_duration_sum = $bar_duration_sum + $bars_data->duration;
}
$bar_avg_second = $bar_duration_sum / $bar_count;
echo "second: {$second} \n";
/**
* song-list.php is the song list content
*
* PHP version 5
*
* @category PHP
* @package /ajax-action/SongActionView
* @author Fukuball Lin <*****@*****.**>
* @license No Licence
* @version Release: <1.0>
* @link http://sarasti.cs.nccu.edu.tw
*/
$song_num = 0;
foreach ($song_list as $song_list_data) {
$song_num++;
$song_obj = new LMSong($song_list_data['id']);
$artist_obj = new LMPerformer($song_obj->performer_id);
?>
<tr width="1000px">
<td width="50px">
<a href="<?php
echo SITE_HOST;
?>
/music/song/index.php?song_id=<?php
echo $song_obj->getId();
?>
"><?php
echo $song_obj->getId();
?>
</a>
</td>
$kkbox_link = 'http://tw.kkbox.com';
$db_obj = LMDBAccess::getInstance();
$song_god_obj = new LMSongGod();
$select_sql = "SELECT " . "* " . "FROM song";
$query_result = $db_obj->selectCommand($select_sql);
// get unprocess data
foreach ($query_result as $query_result_data) {
$song_id = $query_result_data['id'];
$lyric = $query_result_data['lyric'];
$parse_lyric = explode("\n", $lyric);
$normalize_lyric_array = array();
foreach ($parse_lyric as $key => $value) {
$normal_value = nl2br(trim($value));
$normal_value = str_replace('<br />', '', $normal_value);
$normal_value = str_replace('<br/>', '', $normal_value);
$normal_value = str_replace('<br>', '', $normal_value);
if ($normal_value != '') {
array_push($normalize_lyric_array, trim($value));
}
}
$in_lyric = implode("\n", $normalize_lyric_array);
$song_obj = new LMSong($song_id);
$song_obj->lyric = $in_lyric;
if ($song_obj->save()) {
echo "normalize {$song_id} \n";
} else {
echo "fail normalize {$song_id} \n";
}
}
// end foreach ($query_result as $query_result_data) {
require_once SITE_ROOT . "/p-config/application-unsetter.php";
<li>
<a href="<?php
echo SITE_HOST;
?>
/music">歌曲列表</a> <span class="divider">/</span>
</li>
<li class="active">
編輯歌詞分段
</li>
</ul>
<?php
$model_id = 2;
if (!empty($_GET['model_id'])) {
$model_id = $_GET['model_id'];
}
$song_obj = new LMSong($_GET['song_id']);
$disc_obj = new LMDisc($song_obj->disc_id);
$performer_obj = new LMPerformer($song_obj->performer_id);
$lyricist_obj = new LMLyricist($song_obj->lyricist_id);
$composer_obj = new LMComposer($song_obj->composer_id);
?>
<div id='song-item-block'>
<div class="row">
<div class="flow-left" style="width:300px;">
<a href="#" class="thumbnail">
<img src="<?php
echo $disc_obj->cover_path;
?>
" alt="cover">
</a>
</div>
/music">歌曲列表</a> <span class="divider">/</span>
</li>
<li class="active">
歌曲資料
</li>
</ul>
<?php
$model_id = 2;
if (!empty($_GET['model_id'])) {
$model_id = $_GET['model_id'];
}
$lmodel_id = 10;
if (!empty($_GET['lmodel_id'])) {
$lmodel_id = $_GET['lmodel_id'];
}
$song_obj = new LMSong($_GET['song_id']);
$disc_obj = new LMDisc($song_obj->disc_id);
$performer_obj = new LMPerformer($song_obj->performer_id);
$lyricist_obj = new LMLyricist($song_obj->lyricist_id);
$composer_obj = new LMComposer($song_obj->composer_id);
?>
<div id='song-item-block'>
<div class="row">
<div class="flow-left" style="width:300px;">
<a href="#" class="thumbnail">
<img src="<?php
echo $disc_obj->cover_path;
?>
" alt="cover">
</a>
</div>
* PHP version 5
*
* @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";
$db_obj = LMDBAccess::getInstance();
$select_sql = "SELECT " . "id " . "FROM song " . "WHERE is_deleted = '0' " . "AND audio_path!='' " . "AND echonest_track_id='' " . "AND retrieval_status='queue' " . "ORDER BY id";
$query_result = $db_obj->selectCommand($select_sql);
// get unprocess data
foreach ($query_result as $query_result_data) {
$song_obj = new LMSong($query_result_data['id']);
echo "upload " . $song_obj->getId() . " \n";
$echonest_upload_return = shell_exec('curl -X POST -H "Content-Type:application/octet-stream" ' . '"http://developer.echonest.com/api/v4/track/upload?api_key=' . ECHONEST_KEY . '&filetype=mp3" ' . '--data-binary "@' . $song_obj->audio_path . '"');
$echonest_upload_return_jdecode = json_decode($echonest_upload_return);
if ($echonest_upload_return_jdecode->response->status->message == "Success") {
echo "upload " . $song_obj->getId() . " success. \n";
echo "analyze " . $song_obj->getId() . " \n";
$echonest_track_id = $echonest_upload_return_jdecode->response->track->id;
$echonest_analyze_return = shell_exec('curl -F "api_key=' . ECHONEST_KEY . '" ' . '-F "format=json" -F "id=' . $echonest_track_id . '" ' . '-F "bucket=audio_summary" "http://developer.echonest.com/api/v4/track/analyze"');
$echonest_analyze_return_jdecode = json_decode($echonest_analyze_return);
if ($echonest_analyze_return_jdecode->response->status->message == "Success") {
echo "analyze " . $song_obj->getId() . " success. \n";
$key = $echonest_analyze_return_jdecode->response->track->audio_summary->key;
$mode = $echonest_analyze_return_jdecode->response->track->audio_summary->mode;
$tempo = $echonest_analyze_return_jdecode->response->track->audio_summary->tempo;
$time_signature = $echonest_analyze_return_jdecode->response->track->audio_summary->time_signature;
