#include "../headers/Language.h"

Language::Language() : SongListTemplate() {
	InterfaceConfig config(GlobalData::ConfigPrefix + "Language.ini");
	this->AddButton(&config);
	this->SetupSignalConnection(config.GetNameList());
	this->_queryStr = "SELECT a.*,(SELECT COUNT(*) FROM OrderList WHERE a.songId=OrderList.songId) AS BeOrdered FROM song AS a ORDER BY a.songId DESC";
	this->DisplayData();
}
void Language::ActionToDo(){
	MyButton* p_mb = (MyButton*)this->sender();
	if(p_mb->Name() == "Language/jvimage2") this->_queryStr = trUtf8("SELECT a.*,(SELECT COUNT(*) FROM OrderList WHERE a.songId=OrderList.songId) AS BeOrdered FROM song AS a WHERE a.songLanguage='國語歌曲' ORDER BY a.songId DESC");
	if(p_mb->Name() == "Language/jvimage3") this->_queryStr = trUtf8("SELECT a.*,(SELECT COUNT(*) FROM OrderList WHERE a.songId=OrderList.songId) AS BeOrdered FROM song AS a WHERE a.songLanguage='閩南歌曲' ORDER BY a.songId DESC");
	if(p_mb->Name() == "Language/jvimage4") this->_queryStr = trUtf8("SELECT a.*,(SELECT COUNT(*) FROM OrderList WHERE a.songId=OrderList.songId) AS BeOrdered FROM song AS a WHERE a.songLanguage='粵語歌曲' ORDER BY a.songId DESC");
	if(p_mb->Name() == "Language/jvimage5") this->_queryStr = trUtf8("SELECT a.*,(SELECT COUNT(*) FROM OrderList WHERE a.songId=OrderList.songId) AS BeOrdered FROM song AS a WHERE a.songLanguage='韓語歌曲' ORDER BY a.songId DESC");
	if(p_mb->Name() == "Language/jvimage6") this->_queryStr = trUtf8("SELECT a.*,(SELECT COUNT(*) FROM OrderList WHERE a.songId=OrderList.songId) AS BeOrdered FROM song AS a WHERE a.songLanguage='日語歌曲' ORDER BY a.songId DESC");
	if(p_mb->Name() == "Language/jvimage7") this->_queryStr = trUtf8("SELECT a.*,(SELECT COUNT(*) FROM OrderList WHERE a.songId=OrderList.songId) AS BeOrdered FROM song AS a WHERE a.songLanguage='英文歌曲' ORDER BY a.songId DESC");
	if(p_mb->Name() == "Language/jvimage1") this->_queryStr = "SELECT a.*,(SELECT COUNT(*) FROM OrderList WHERE a.songId=OrderList.songId) AS BeOrdered FROM song AS a ORDER BY a.songId DESC";
	this->DisplayData();
}