\r
$code = $_GET['code'];\r
\r
- if (!$code) {\r
- exit(1);\r
- }\r
- \r
- $today = new DateTime;\r
- \r
- #print_r($today);\r
- \r
- $prevDTTxt = file_get_contents(DATE_FILE);\r
+ // Get month and year user is requesting\r
+ $state = explode(':', $_GET['state']);\r
\r
- $prevDT = $prevDTTxt ? DateTime::createFromFormat(DATE_FORM, $prevDTTxt) : DateTime::createFromFormat(DATE_FORM, $today->format('m/') . '01' . $today->format('/Y'));\r
\r
- if (strcmp($prevDT->format('m'), $today->format('m')) < 0) {\r
- $prevDT = DateTime::createFromFormat(DATE_FORM, $today->format('m/') . '01' . $today->format('/Y'));\r
+ if (!$code) {\r
+ exit(1);\r
}\r
- \r
+ \r
+ #print_r($today); \r
\r
#Handle Spotify Token Authorization\r
\r
\r
$spot_req = file_get_contents(AUTH_URL . 'api/token', false, $token_context);\r
\r
- #echo $spot_req;\r
+ echo $spot_req;\r
$spot_json = json_decode($spot_req, true);\r
\r
$spot_token = $spot_json['access_token'];\r
\r
+ \r
$me_opts = [\r
'http' => [\r
'method' => 'GET',\r
$me_json = json_decode($me_resp, true);\r
$me_id = $me_json['id'];\r
\r
- echo '<br />';\r
- #print_r($me_resp);\r
- \r
- $page = 1;\r
- $html = file_get_contents('https://www.marketplace.org/latest-music');\r
- $DOM = new DOMDocument;\r
- $DOM->loadHTML($html);\r
- $headers = $DOM->getElementsByTagName('h2');\r
- $divs = $DOM->getElementsByTagName('div');\r
- \r
- $recentEpDT;\r
- $episodePages = [];\r
- \r
- foreach ($headers as $header) {\r
- if ($header->hasAttribute('class') && $header->getAttribute('class') === 'river--hed') {\r
- $recentEpDT = DateTime::createFromFormat(DATE_FORM, explode(':', $header->nodeValue)[0]);\r
- break;\r
- }\r
- }\r
- \r
- $prevDate = (int) $prevDT->format('d');\r
- $recentEpDate = (int) $recentEpDT->format('d');\r
- $daysToGet = ($prevDate === 1) ? $recentEpDate : $recentEpDate - $prevDate;\r
- $daysToGet = $daysToGet - 2 * (int) ($daysToGet / 7);\r
- \r
- if ($daysToGet === 0) {\r
- echo 'No new episodes since last check.';\r
- exit(0);\r
- }\r
-\r
- \r
- do {\r
- $episodePages[] = parseEpisodePage($divs, $daysToGet);\r
- } while ($daysToGet > 0 && ($DOM->loadHTML(file_get_contents('https://www.marketplace.org/latest-music?page=' . ++$page))) && ($divs = $DOM->getElementsByTagName('div')) );\r
-\r
- /*\r
- echo '<br />';\r
-\r
- print_r($date_headers);\r
- \r
- echo '<br />';\r
- print_r($episodes);\r
- */\r
- \r
- print_r($episodePages);\r
- \r
# Check if this month's playlist exists\r
\r
- $playlistName = MONTHS[$today->format('m')] . ' Marketplace Tracks';\r
+ $playlistName = MONTHS[$state[0]] . ' ' . $state[1] . ' Marketplace Tracks';\r
\r
$checkPlaylistOpts = [\r
'http' => [\r
\r
$playlist_data = [\r
'name' => $playlistName,\r
+ 'description' => 'A playlist of Marketplace tracks by Marketplaylister.',\r
];\r
\r
$playlist_opts = [\r
\r
$uris = [];\r
\r
- foreach ( array_reverse($episodePages) as $episodes) {\r
- foreach ( array_reverse($episodes) as $episode) {\r
-\r
- $track_opts = [\r
- 'http' => [\r
- 'method' => 'GET',\r
- 'header' => 'Authorization: Bearer ' . $spot_token . "\r\n"\r
- ]\r
- ];\r
- \r
- $track_context = stream_context_create($track_opts);\r
- \r
- foreach ($episode as $song_info) {\r
- \r
- $track_search_url = BASE_URL . 'search?q=track:' . urlencode($song_info['title']) \r
- . '+artist:' . urlencode($song_info['artist']) . '&type=track';\r
- \r
- #echo '<br />' . $track_search_url;\r
- #echo '<br />';\r
- \r
- $trackReq = file_get_contents($track_search_url, false, $track_context);\r
- if ($trackReq) {\r
- $trackJSON = json_decode($trackReq, true);\r
- $trackJSON = $trackJSON['tracks'];\r
- \r
- print_r($trackJSON);\r
- \r
- if ($trackJSON['total'] === 0) {\r
- continue;\r
- }\r
- \r
- $uris[] = $trackJSON['items'][0]['uri'];\r
- \r
- #rate limit\r
- sleep(1);\r
-\r
- }\r
- }\r
- }\r
+ $pdo = new PDO("sqlite:mktplc.sqlite3");\r
+ $stmt = $pdo->prepare("SELECT uri FROM songs s WHERE (SELECT strftime('%m', s.date) == :month and strftime('%Y', s.date) == :year;");\r
+ $stmt->bindParam(':month', $state[0]);\r
+ $stmt->bindParam(':year', $state[1]);\r
+ if ($stmt->execute()) {\r
+ while ($row = $stmt->fetch()) {\r
+ $uris[] = $row['uri'];\r
+ }\r
}\r
\r
$update_data = [\r