$index_md = 0; foreach ($ar_tmp as $value) { echo '{index_md: ' . $index_md . ', id: ' . $value . ',landname:\'' . $land_ref_arr[$charts_modul_ref_land[$value]] . '\',modulname: \'' . $charts_modul_ref[$value] . '\','; echo 'timeunit: ['; $ival_tmp = get_exa_chart_ival($value); foreach ($ival_tmp as $key => $row) { echo "{index_tu: " . $index_tu . ",id_tu: '" . $key . "', name_tu: '" . $row . "'},"; $index_tu++; } echo '],'; echo 'timekey: ['; foreach ($ival_tmp as $key => $row) { $timekey_tmp = get_exa_chart_time_key($value, $key); $index = 0; foreach ($timekey_tmp as $keys) { echo "{index_tk: " . $index . ", id_tk: '" . $key . "', key_tk: " . $keys . ", name_tk: '" . convert_zeitekey($keys, $key) . "'},"; $index++; } } echo ']'; echo '},'; $index_md++; } echo '];'; echo '$scope.current_exa_modul_index = 0;'; echo '$scope.current_exa_modul_time_unit_index = 0;'; echo '$scope.current_exa_modul_time_key_index = 0;'; ?> $scope.top_chk_box = [{'top':10}]; $scope.change_exa_modul = function change_exa_modul(){ $scope.exasolTabTimeUnit_val = $scope.exasolTabModulId_val.timeunit[0];
function get_chart_from_exasol($top, $modul_id, $zeikey, $zeit_unit) { //modul_id = 101 : Single //modul_id = 102 : Longplay //modul_id = 103 : Compilation echo "get chart from Exasol: top {$top} , modul {$modul_id} , {$zeit_unit} {$zeikey} ..."; $format = $modul_id == 101 ? 'SONG' : 'ALBUM'; global $db; $ar = array(); $sql = "SELECT\r\n\t\tNVL(Platzierung, 0) AS pnposak,\r\n\t\tNVL(Platz_Zeitraum_1, ' ') AS pnposvv,\r\n\t\tNVL(Platz_Zeitraum_2, ' ') AS pnposww,\r\n\t\tNVL(Autor, ' ') AS pninterp,\r\n\t\tNVL(Titel, ' ') AS pntitel,\r\n\t\tNVL(code, ' ') AS Code\r\n\tFROM\r\n\t\t(\r\n\t\t\tSELECT\r\n\t\t\t\tTO_NUMBER(Platzierung) AS Platzierung,\r\n\t\t\t\tm2.Platz_Zeitraum_1,\r\n\t\t\t\tm2.Platz_Zeitraum_2,\r\n\t\t\t\tm2.Autor,\r\n\t\t\t\tm2.Titel,\r\n\t\t\t\tm2.code\r\n\t\t\tFROM\r\n\t\t\t\tmcchart m2,\r\n\t\t\t\tmcchrth h2\r\n\t\t\tWHERE\r\n\t\t\t\th2.Modul_Id = {$modul_id} AND\r\n\t\t\t\th2.Ausw_Zeitraum = '" . convert_zeitekey($zeikey, $zeit_unit) . "' AND\r\n\t\t\t\th2.Ausw_Zeitraum_Einheit = '" . $zeit_unit . "' AND\r\n\t\t\t\tm2.referenz = h2.referenz\r\n\t\t\tORDER BY\r\n\t\t\t\t1\r\n\t\t)\r\n\tWHERE\r\n\t\tPlatzierung <= {$top}"; $res = $db->query($sql); echo "done \n"; if ($modul_id == 101) { $itunes_top100 = get_itunes_top100_song(); $amazon_top100_phys = get_amazon_top100_phys_song(); $amazon_top100_dwn = get_amazon_top100_dwn_song(); } else { $itunes_top100 = get_itunes_top100_album(); $amazon_top100_phys = get_amazon_top100_phys_album(); $amazon_top100_dwn = get_amazon_top100_dwn_album(); } while ($row = $res->fetchRow(MDB2_FETCHMODE_ASSOC)) { $stamm_titel = get_de_stamm_titel(trim($row['code']), $modul_id); $stamm_artist = get_de_stamm_artist(trim($row['code']), $modul_id); $ar[] = array('RANK' => $row['pnposak'], 'RANK_W_1' => $row['pnposvv'], 'RANK_W_2' => $row['pnposww'], 'TITEL' => $stamm_titel, 'ARTIST' => $stamm_artist, 'ITUNES_LINK' => get_itunes_links($stamm_titel, $stamm_artist, $itunes_top100), 'AMAZON_PHYS_LINK' => get_amazon_links($stamm_titel, $stamm_artist, $amazon_top100_phys), 'AMAZON_DWN_LINK' => get_amazon_links($stamm_titel, $stamm_artist, $amazon_top100_dwn), 'VIDEO_LINK' => '', 'MODUL_ID' => $modul_id, 'TIME_KEY' => $zeikey, 'TIME_UNIT' => $zeit_unit); } return $ar; }