| 1 | <?php\r |
| 2 | declare(strict_types = 1);\r |
| 3 | \r |
| 4 | require 'secrets.php';\r |
| 5 | require 'mpfuncs.php';\r |
| 6 | \r |
| 7 | const BASE_URL = 'https://api.spotify.com/v1/';\r |
| 8 | const AUTH_URL = 'https://accounts.spotify.com/';\r |
| 9 | const DATE_FILE = 'prev_date.txt';\r |
| 10 | const MONTHS = [\r |
| 11 | '01' => 'January',\r |
| 12 | '02' => 'February',\r |
| 13 | '03' => 'March',\r |
| 14 | '04' => 'April',\r |
| 15 | '05' => 'May',\r |
| 16 | '06' => 'June',\r |
| 17 | '07' => 'July',\r |
| 18 | '08' => 'August',\r |
| 19 | '09' => 'September',\r |
| 20 | '10' => 'October',\r |
| 21 | '11' => 'November',\r |
| 22 | '12' => 'December',\r |
| 23 | ];\r |
| 24 | \r |
| 25 | $code = $_GET['code'];\r |
| 26 | \r |
| 27 | // Get month and year user is requesting\r |
| 28 | $state = explode(':', $_GET['state']);\r |
| 29 | \r |
| 30 | \r |
| 31 | if (!$code) {\r |
| 32 | exit(1);\r |
| 33 | }\r |
| 34 | \r |
| 35 | #print_r($today); \r |
| 36 | \r |
| 37 | #Handle Spotify Token Authorization\r |
| 38 | \r |
| 39 | $token_data = [\r |
| 40 | 'grant_type' => 'authorization_code',\r |
| 41 | 'code' => $code,\r |
| 42 | 'redirect_uri' => REDIRECT_URI\r |
| 43 | ];\r |
| 44 | $token_data = http_build_query($token_data);\r |
| 45 | \r |
| 46 | $token_opts = [\r |
| 47 | 'http' => [\r |
| 48 | 'method' => 'POST',\r |
| 49 | /*'header' => "Content-type: application/x-www-form-urlencoded\r\n"\r |
| 50 | . "Content-Length: " . strlen($token_data) . "\r\n"\r |
| 51 | . "Authorization: Basic " . base64_encode('868e2cba00de4819900dd8a647a7ba7d:' . CLIENT_SECRET) . "\r\n",*/\r |
| 52 | 'header' => "Authorization: Basic " . base64_encode('93a6f9c0375c45d4b348157691aa24e8:' . CLIENT_SECRET) . " \r\n",\r |
| 53 | 'content' => $token_data\r |
| 54 | ]\r |
| 55 | ];\r |
| 56 | \r |
| 57 | $token_context = stream_context_create($token_opts);\r |
| 58 | \r |
| 59 | $spot_req = file_get_contents(AUTH_URL . 'api/token', false, $token_context);\r |
| 60 | \r |
| 61 | echo $spot_req;\r |
| 62 | $spot_json = json_decode($spot_req, true);\r |
| 63 | \r |
| 64 | $spot_token = $spot_json['access_token'];\r |
| 65 | \r |
| 66 | \r |
| 67 | $me_opts = [\r |
| 68 | 'http' => [\r |
| 69 | 'method' => 'GET',\r |
| 70 | 'header' => 'Authorization: Bearer ' . $spot_token . "\r\n"\r |
| 71 | ]\r |
| 72 | ];\r |
| 73 | \r |
| 74 | $me_context = stream_context_create($me_opts);\r |
| 75 | \r |
| 76 | $me_resp = file_get_contents(BASE_URL . 'me', false, $me_context);\r |
| 77 | $me_json = json_decode($me_resp, true);\r |
| 78 | $me_id = $me_json['id'];\r |
| 79 | \r |
| 80 | # Check if this month's playlist exists\r |
| 81 | \r |
| 82 | $playlistName = MONTHS[$state[0]] . ' ' . $state[1] . ' Marketplace Tracks';\r |
| 83 | \r |
| 84 | $checkPlaylistOpts = [\r |
| 85 | 'http' => [\r |
| 86 | 'method' => 'GET',\r |
| 87 | 'header' => 'Authorization: Bearer ' . $spot_token . "\r\n"\r |
| 88 | ]\r |
| 89 | ];\r |
| 90 | \r |
| 91 | $checkPlaylistContext = stream_context_create($checkPlaylistOpts);\r |
| 92 | \r |
| 93 | $checkPlaylistReq = file_get_contents(BASE_URL . 'me/playlists', false, $checkPlaylistContext);\r |
| 94 | \r |
| 95 | $checkPlaylistJson = json_decode($checkPlaylistReq, true);\r |
| 96 | \r |
| 97 | foreach ($checkPlaylistJson['items'] as $playlist) {\r |
| 98 | #TODO should check if $user owns playlist\r |
| 99 | if (!strcmp($playlistName, $playlist['name'])) {\r |
| 100 | $playlistID = $playlist['id'];\r |
| 101 | }\r |
| 102 | }\r |
| 103 | \r |
| 104 | #echo 'playlistID' . $playlistID;\r |
| 105 | \r |
| 106 | # Create new playlist if one does not exist\r |
| 107 | # DEVELOPMENT TEMP ALWAYS CREATE NEW PLAYLIST\r |
| 108 | #if (!$playlistID) {\r |
| 109 | if (true) {\r |
| 110 | \r |
| 111 | $playlist_data = [\r |
| 112 | 'name' => $playlistName,\r |
| 113 | 'description' => 'A playlist of Marketplace tracks by Marketplaylister.',\r |
| 114 | ];\r |
| 115 | \r |
| 116 | $playlist_opts = [\r |
| 117 | 'http' => [\r |
| 118 | 'method' => 'POST',\r |
| 119 | 'header' => 'Authorization: Bearer ' . $spot_token . "\r\n"\r |
| 120 | . 'Content-Type application/json \r\n',\r |
| 121 | 'content' => json_encode($playlist_data)\r |
| 122 | ]\r |
| 123 | ];\r |
| 124 | \r |
| 125 | $playlist_context = stream_context_create($playlist_opts);\r |
| 126 | $playlist_req = file_get_contents(BASE_URL . 'users/' . $me_id . '/playlists', false, $playlist_context);\r |
| 127 | $playlist_json = json_decode($playlist_req, true);\r |
| 128 | $playlistID = $playlist_json['id'];\r |
| 129 | \r |
| 130 | #echo '<br />' . $playlistID;\r |
| 131 | \r |
| 132 | }\r |
| 133 | \r |
| 134 | $uris = [];\r |
| 135 | \r |
| 136 | $pdo = new PDO("sqlite:mktplc.sqlite3");\r |
| 137 | $stmt = $pdo->prepare("SELECT uri FROM songs s WHERE uri IS NOT NULL AND strftime('%m', s.date) == :month AND strftime('%Y', s.date) == :year");\r |
| 138 | $stmt->bindParam(':month', $state[0]);\r |
| 139 | $stmt->bindParam(':year', $state[1]);\r |
| 140 | if ($stmt->execute()) {\r |
| 141 | while ($row = $stmt->fetch()) {\r |
| 142 | $uris[] = $row['uri'];\r |
| 143 | }\r |
| 144 | }\r |
| 145 | \r |
| 146 | $update_data = [\r |
| 147 | 'uris' => $uris,\r |
| 148 | ];\r |
| 149 | \r |
| 150 | echo '<br /> update_data <br />';\r |
| 151 | #print_r($update_data);\r |
| 152 | \r |
| 153 | $update_opts = [\r |
| 154 | 'http' => [\r |
| 155 | 'method' => 'POST',\r |
| 156 | 'header' => 'Authorization: Bearer ' . $spot_token . "\r\n"\r |
| 157 | . 'Content-Type application/json \r\n',\r |
| 158 | 'content' => json_encode($update_data)\r |
| 159 | ]\r |
| 160 | ];\r |
| 161 | \r |
| 162 | $update_context = stream_context_create($update_opts);\r |
| 163 | $update_url = BASE_URL . 'users/' . $me_id . '/playlists/' . $playlistID . '/tracks';\r |
| 164 | echo '<br />' . $update_url;\r |
| 165 | echo '<br />';\r |
| 166 | echo '<br />' . count($uris);\r |
| 167 | echo '<br />';\r |
| 168 | print_r(json_encode($update_data));\r |
| 169 | $update_req = file_get_contents(BASE_URL . 'users/' . $me_id . '/playlists/' . $playlistID . '/tracks', false, $update_context);\r |
| 170 | print_r($update_req); |