@@ -30,9 +30,9 @@ |
||
| 30 | 30 | $table->primary(['episode_id', 'tag_id']); |
| 31 | 31 | |
| 32 | 32 | $table->foreign('episode_id')->references('id')->on('cosmicradiotv_podcast_episodes') |
| 33 | - ->onUpdate('cascade')->onDelete('cascade'); |
|
| 33 | + ->onUpdate('cascade')->onDelete('cascade'); |
|
| 34 | 34 | $table->foreign('tag_id')->references('id')->on('cosmicradiotv_podcast_tags') |
| 35 | - ->onUpdate('cascade')->onDelete('cascade'); |
|
| 35 | + ->onUpdate('cascade')->onDelete('cascade'); |
|
| 36 | 36 | }); |
| 37 | 37 | }); |
| 38 | 38 | } |
@@ -30,7 +30,7 @@ |
||
| 30 | 30 | $table->timestamps(); |
| 31 | 31 | |
| 32 | 32 | $table->foreign('show_id')->references('id')->on('cosmicradiotv_podcast_shows') |
| 33 | - ->onUpdate('cascade'); |
|
| 33 | + ->onUpdate('cascade'); |
|
| 34 | 34 | $table->unique(['show_id', 'slug']); |
| 35 | 35 | }); |
| 36 | 36 | }); |
@@ -36,9 +36,9 @@ |
||
| 36 | 36 | $table->timestamps(); |
| 37 | 37 | |
| 38 | 38 | $table->foreign('episode_id')->references('id')->on('cosmicradiotv_podcast_episodes') |
| 39 | - ->onUpdate('cascade'); |
|
| 39 | + ->onUpdate('cascade'); |
|
| 40 | 40 | $table->foreign('release_type_id')->references('id')->on('cosmicradiotv_podcast_release_types') |
| 41 | - ->onUpdate('cascade'); |
|
| 41 | + ->onUpdate('cascade'); |
|
| 42 | 42 | |
| 43 | 43 | }); |
| 44 | 44 | }); |
@@ -9,29 +9,29 @@ |
||
| 9 | 9 | |
| 10 | 10 | class AddSortOrderToReleaseTypes extends Migration |
| 11 | 11 | { |
| 12 | - /** |
|
| 13 | - * Migration |
|
| 14 | - */ |
|
| 15 | - public function up() |
|
| 16 | - { |
|
| 17 | - DB::transaction(function() { |
|
| 18 | - Schema::table('cosmicradiotv_podcast_release_types', function (Blueprint $table) { |
|
| 19 | - $table->unsignedInteger('sort_order'); |
|
| 20 | - }); |
|
| 21 | - }); |
|
| 22 | - } |
|
| 12 | + /** |
|
| 13 | + * Migration |
|
| 14 | + */ |
|
| 15 | + public function up() |
|
| 16 | + { |
|
| 17 | + DB::transaction(function() { |
|
| 18 | + Schema::table('cosmicradiotv_podcast_release_types', function (Blueprint $table) { |
|
| 19 | + $table->unsignedInteger('sort_order'); |
|
| 20 | + }); |
|
| 21 | + }); |
|
| 22 | + } |
|
| 23 | 23 | |
| 24 | - /** |
|
| 25 | - * Rollback |
|
| 26 | - */ |
|
| 27 | - public function down() |
|
| 28 | - { |
|
| 29 | - DB::transaction(function() { |
|
| 30 | - Schema::table('cosmicradiotv_podcast_release_types', function (Blueprint $table) { |
|
| 31 | - $table->dropColumn([ |
|
| 32 | - 'sort_order', |
|
| 33 | - ]); |
|
| 34 | - }); |
|
| 35 | - }); |
|
| 36 | - } |
|
| 24 | + /** |
|
| 25 | + * Rollback |
|
| 26 | + */ |
|
| 27 | + public function down() |
|
| 28 | + { |
|
| 29 | + DB::transaction(function() { |
|
| 30 | + Schema::table('cosmicradiotv_podcast_release_types', function (Blueprint $table) { |
|
| 31 | + $table->dropColumn([ |
|
| 32 | + 'sort_order', |
|
| 33 | + ]); |
|
| 34 | + }); |
|
| 35 | + }); |
|
| 36 | + } |
|
| 37 | 37 | } |
| 38 | 38 | \ No newline at end of file |
@@ -6,8 +6,8 @@ |
||
| 6 | 6 | use CosmicRadioTV\Podcast\Models\Episode; |
| 7 | 7 | use CosmicRadioTV\Podcast\Models\Show; |
| 8 | 8 | /** |
| 9 | - * Episodes Back-end Controller |
|
| 10 | - */ |
|
| 9 | + * Episodes Back-end Controller |
|
| 10 | + */ |
|
| 11 | 11 | class Episodes extends Controller |
| 12 | 12 | { |
| 13 | 13 | public $implement = [ |
@@ -89,7 +89,7 @@ |
||
| 89 | 89 | curl_exec($ch); |
| 90 | 90 | |
| 91 | 91 | if (!curl_errno($ch)) { |
| 92 | - $this->size = curl_getinfo($ch, CURLINFO_CONTENT_LENGTH_DOWNLOAD); |
|
| 92 | + $this->size = curl_getinfo($ch, CURLINFO_CONTENT_LENGTH_DOWNLOAD); |
|
| 93 | 93 | } |
| 94 | 94 | curl_close($ch); |
| 95 | 95 | } |
@@ -74,8 +74,8 @@ |
||
| 74 | 74 | $showSlugFilter = $this->property('showSlugFilter'); |
| 75 | 75 | if (!empty($showSlugFilter)) { |
| 76 | 76 | $this->show = Show::query() |
| 77 | - ->where('slug', $showSlugFilter) |
|
| 78 | - ->firstOrFail(); |
|
| 77 | + ->where('slug', $showSlugFilter) |
|
| 78 | + ->firstOrFail(); |
|
| 79 | 79 | |
| 80 | 80 | $this->episode = $this->show->episodes() |
| 81 | 81 | ->getQuery() |
@@ -174,25 +174,25 @@ |
||
| 174 | 174 | public function setState() |
| 175 | 175 | { |
| 176 | 176 | $this->show = $show = Show::query() |
| 177 | - ->where('slug', $this->property('showSlug')) |
|
| 178 | - ->firstOrFail(); |
|
| 177 | + ->where('slug', $this->property('showSlug')) |
|
| 178 | + ->firstOrFail(); |
|
| 179 | 179 | $this->releaseType = $releaseType = ReleaseType::query() |
| 180 | - ->where('slug', $this->property('releaseTypeSlug')) |
|
| 181 | - ->firstOrFail(); |
|
| 180 | + ->where('slug', $this->property('releaseTypeSlug')) |
|
| 181 | + ->firstOrFail(); |
|
| 182 | 182 | $this->episodes = $this->show->episodes() |
| 183 | - ->with([ |
|
| 184 | - 'releases' => function (Relation $query) use ($releaseType) { |
|
| 185 | - /** @var Relation|Builder $query */ |
|
| 186 | - $query->where('release_type_id', $releaseType->id); |
|
| 187 | - } |
|
| 188 | - ]) |
|
| 189 | - ->where('published', true) |
|
| 190 | - ->whereHas('releases', function (Builder $query) use ($releaseType) { |
|
| 191 | - $query->where('release_type_id', $releaseType->id); |
|
| 192 | - }) |
|
| 193 | - ->orderBy('release', 'desc') |
|
| 194 | - ->take(intval($this->property('itemLimit'))) |
|
| 195 | - ->get(); |
|
| 183 | + ->with([ |
|
| 184 | + 'releases' => function (Relation $query) use ($releaseType) { |
|
| 185 | + /** @var Relation|Builder $query */ |
|
| 186 | + $query->where('release_type_id', $releaseType->id); |
|
| 187 | + } |
|
| 188 | + ]) |
|
| 189 | + ->where('published', true) |
|
| 190 | + ->whereHas('releases', function (Builder $query) use ($releaseType) { |
|
| 191 | + $query->where('release_type_id', $releaseType->id); |
|
| 192 | + }) |
|
| 193 | + ->orderBy('release', 'desc') |
|
| 194 | + ->take(intval($this->property('itemLimit'))) |
|
| 195 | + ->get(); |
|
| 196 | 196 | |
| 197 | 197 | $this->episodes->map(function (Episode $episode) use ($show) { |
| 198 | 198 | $episode->setRelation('show', $show); |
@@ -199,8 +199,8 @@ |
||
| 199 | 199 | } |
| 200 | 200 | |
| 201 | 201 | $query->with('image') |
| 202 | - ->where('published', true) |
|
| 203 | - ->orderBy('release', 'desc'); |
|
| 202 | + ->where('published', true) |
|
| 203 | + ->orderBy('release', 'desc'); |
|
| 204 | 204 | |
| 205 | 205 | if ($this->tag) { |
| 206 | 206 | $query->whereHas('tags', function (Builder $q) { |