Passed
Push — master ( 289ad7...3c0aa9 )
by Greg
06:58
created

MediaController::data()   B

Complexity

Conditions 8
Paths 5

Size

Total Lines 139
Code Lines 88

Duplication

Lines 0
Ratio 0 %

Importance

Changes 2
Bugs 0 Features 0
Metric Value
cc 8
eloc 88
c 2
b 0
f 0
nc 5
nop 1
dl 0
loc 139
rs 7.0173

How to fix   Long Method   

Long Method

Small methods make your code easier to understand, in particular if combined with a good name. Besides, if your method is small, finding a good name is usually much easier.

For example, if you find yourself adding comments to a method's body, this is usually a good sign to extract the commented part to a new method, and use the comment as a starting point when coming up with a good name for this new method.

Commonly applied refactorings include:

1
<?php
2
3
/**
4
 * webtrees: online genealogy
5
 * Copyright (C) 2019 webtrees development team
6
 * This program is free software: you can redistribute it and/or modify
7
 * it under the terms of the GNU General Public License as published by
8
 * the Free Software Foundation, either version 3 of the License, or
9
 * (at your option) any later version.
10
 * This program is distributed in the hope that it will be useful,
11
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
12
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13
 * GNU General Public License for more details.
14
 * You should have received a copy of the GNU General Public License
15
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
16
 */
17
18
declare(strict_types=1);
19
20
namespace Fisharebest\Webtrees\Http\Controllers\Admin;
21
22
use Fisharebest\Webtrees\FlashMessages;
23
use Fisharebest\Webtrees\Functions\Functions;
24
use Fisharebest\Webtrees\Html;
25
use Fisharebest\Webtrees\Http\RequestHandlers\DeletePath;
26
use Fisharebest\Webtrees\I18N;
27
use Fisharebest\Webtrees\Log;
28
use Fisharebest\Webtrees\Media;
29
use Fisharebest\Webtrees\MediaFile;
30
use Fisharebest\Webtrees\Services\DatatablesService;
31
use Fisharebest\Webtrees\Services\MediaFileService;
32
use Illuminate\Database\Capsule\Manager as DB;
33
use Illuminate\Database\Query\Builder;
34
use Illuminate\Database\Query\Expression;
35
use Illuminate\Database\Query\JoinClause;
36
use Illuminate\Support\Str;
37
use League\Flysystem\FilesystemInterface;
38
use Psr\Http\Message\ResponseInterface;
39
use Psr\Http\Message\ServerRequestInterface;
40
use Psr\Http\Message\UploadedFileInterface;
41
use stdClass;
42
use Symfony\Component\HttpKernel\Exception\BadRequestHttpException;
43
use Throwable;
44
45
use function assert;
46
use function e;
47
use function explode;
48
use function filesize;
49
use function getimagesize;
50
use function ini_get;
51
use function intdiv;
52
use function is_string;
53
use function preg_match;
54
use function redirect;
55
use function route;
56
use function str_replace;
57
use function strlen;
58
use function substr;
59
use function trim;
60
61
use const UPLOAD_ERR_OK;
62
63
/**
64
 * Controller for media administration.
65
 */
66
class MediaController extends AbstractAdminController
67
{
68
    // How many files to upload on one form.
69
    private const MAX_UPLOAD_FILES = 10;
70
71
    /** @var DatatablesService */
72
    private $datatables_service;
73
74
    /** @var MediaFileService */
75
    private $media_file_service;
76
77
    /**
78
     * MediaController constructor.
79
     *
80
     * @param DatatablesService $datatables_service
81
     * @param MediaFileService  $media_file_service
82
     */
83
    public function __construct(DatatablesService $datatables_service, MediaFileService $media_file_service)
84
    {
85
        $this->datatables_service = $datatables_service;
86
        $this->media_file_service = $media_file_service;
87
    }
88
89
    /**
90
     * @param ServerRequestInterface $request
91
     *
92
     * @return ResponseInterface
93
     */
94
    public function index(ServerRequestInterface $request): ResponseInterface
95
    {
96
        $data_filesystem = $request->getAttribute('filesystem.data');
97
        assert($data_filesystem instanceof FilesystemInterface);
98
99
        $data_filesystem_name = $request->getAttribute('filesystem.data.name');
100
        assert(is_string($data_filesystem_name));
101
102
        $files         = $request->getQueryParams()['files'] ?? 'local'; // local|unused|external
103
        $media_folder  = $request->getQueryParams()['media_folder'] ?? '';
104
        $subfolders    = $request->getQueryParams()['subfolders'] ?? 'include'; // include|exclude
105
        $media_folders = $this->media_file_service->allMediaFolders($data_filesystem);
106
107
        $title = I18N::translate('Manage media');
108
109
        return $this->viewResponse('admin/media', [
110
            'data_folder'   => $data_filesystem_name,
111
            'files'         => $files,
112
            'media_folder'  => $media_folder,
113
            'media_folders' => $media_folders,
114
            'subfolders'    => $subfolders,
115
            'title'         => $title,
116
        ]);
117
    }
118
119
    /**
120
     * @param ServerRequestInterface $request
121
     *
122
     * @return ResponseInterface
123
     */
124
    public function select(ServerRequestInterface $request): ResponseInterface
125
    {
126
        return redirect(route('admin-media', [
127
            'files'        => $request->getParsedBody()['files'],
128
            'media_folder' => $request->getParsedBody()['media_folder'] ?? '',
129
            'subfolders'   => $request->getParsedBody()['subfolders'] ?? 'include',
130
        ]));
131
    }
132
133
    /**
134
     * @param ServerRequestInterface $request
135
     *
136
     * @return ResponseInterface
137
     */
138
    public function data(ServerRequestInterface $request): ResponseInterface
139
    {
140
        $data_filesystem = $request->getAttribute('filesystem.data');
141
        assert($data_filesystem instanceof FilesystemInterface);
142
143
        $files  = $request->getQueryParams()['files']; // local|external|unused
144
145
        // Files within this folder
146
        $media_folder = $request->getQueryParams()['media_folder'];
147
148
        // Show sub-folders within $media_folder
149
        $subfolders = $request->getQueryParams()['subfolders']; // include|exclude
150
151
        $search_columns = ['multimedia_file_refn', 'descriptive_title'];
152
153
        $sort_columns = [
154
            0 => 'multimedia_file_refn',
155
            2 => new Expression('descriptive_title || multimedia_file_refn'),
156
        ];
157
158
        // Convert a row from the database into a row for datatables
159
        $callback = function (stdClass $row): array {
160
            /** @var Media $media */
161
            $media = Media::rowMapper()($row);
162
163
            $media_files = $media->mediaFiles()
164
                ->filter(static function (MediaFile $media_file) use ($row): bool {
165
                    return $media_file->filename() === $row->multimedia_file_refn;
166
                })
167
                ->map(static function (MediaFile $media_file): string {
168
                    return $media_file->displayImage(150, 150, '', []);
169
                })
170
                ->first();
171
172
            return [
173
                $row->multimedia_file_refn,
174
                $media_files,
175
                $this->mediaObjectInfo($media),
176
            ];
177
        };
178
179
        switch ($files) {
180
            case 'local':
181
                $query = DB::table('media_file')
182
                    ->join('media', static function (JoinClause $join): void {
183
                        $join
184
                            ->on('media.m_file', '=', 'media_file.m_file')
185
                            ->on('media.m_id', '=', 'media_file.m_id');
186
                    })
187
                    ->join('gedcom_setting', 'gedcom_id', '=', 'media.m_file')
188
                    ->where('setting_name', '=', 'MEDIA_DIRECTORY')
189
                    ->where('multimedia_file_refn', 'NOT LIKE', 'http://%')
190
                    ->where('multimedia_file_refn', 'NOT LIKE', 'https://%')
191
                    ->select(['media.*', 'multimedia_file_refn', 'descriptive_title']);
192
193
                $query->where(new Expression('setting_value || multimedia_file_refn'), 'LIKE', $media_folder . '%');
194
195
                if ($subfolders === 'exclude') {
196
                    $query->where(new Expression('setting_value || multimedia_file_refn'), 'NOT LIKE', $media_folder . '%/%');
197
                }
198
199
                return $this->datatables_service->handleQuery($request, $query, $search_columns, $sort_columns, $callback);
200
201
            case 'external':
202
                $query = DB::table('media_file')
203
                    ->join('media', static function (JoinClause $join): void {
204
                        $join
205
                            ->on('media.m_file', '=', 'media_file.m_file')
206
                            ->on('media.m_id', '=', 'media_file.m_id');
207
                    })
208
                    ->where(static function (Builder $query): void {
209
                        $query
210
                            ->where('multimedia_file_refn', 'LIKE', 'http://%')
211
                            ->orWhere('multimedia_file_refn', 'LIKE', 'https://%');
212
                    })
213
                    ->select(['media.*', 'multimedia_file_refn', 'descriptive_title']);
214
215
                return $this->datatables_service->handleQuery($request, $query, $search_columns, $sort_columns, $callback);
216
217
            case 'unused':
218
                // Which trees use which media folder?
219
                $media_trees = DB::table('gedcom')
220
                    ->join('gedcom_setting', 'gedcom_setting.gedcom_id', '=', 'gedcom.gedcom_id')
221
                    ->where('setting_name', '=', 'MEDIA_DIRECTORY')
222
                    ->where('gedcom.gedcom_id', '>', 0)
223
                    ->pluck('setting_value', 'gedcom_name');
224
225
                $disk_files = $this->media_file_service->allFilesOnDisk($data_filesystem, $media_folder, $subfolders === 'include');
226
                $db_files   = $this->media_file_service->allFilesInDatabase($media_folder, $subfolders === 'include');
227
228
                // All unused files
229
                $unused_files = $disk_files->diff($db_files)
230
                    ->map(static function (string $file): array {
231
                        return (array) $file;
232
                    });
233
234
                $search_columns = [0];
235
236
                $sort_columns = [0 => 0];
237
238
                $callback = function (array $row) use ($data_filesystem, $media_folder, $media_trees): array {
239
                    $mime_type = $data_filesystem->getMimeType($row[0]);
240
241
                    if (explode('/', $mime_type)[0] === 'image') {
0 ignored issues
show
Bug introduced by
It seems like $mime_type can also be of type false; however, parameter $string of explode() does only seem to accept string, maybe add an additional type check? ( Ignorable by Annotation )

If this is a false-positive, you can also ignore this issue in your code via the ignore-type  annotation

241
                    if (explode('/', /** @scrutinizer ignore-type */ $mime_type)[0] === 'image') {
Loading history...
242
                        $url = route('unused-media-thumbnail', [
243
                            'path' => $row[0],
244
                            'w'    => 100,
245
                            'h'    => 100,
246
                        ]);
247
                        $img = '<img src="' . e($url) . '">';
248
                    } else {
249
                        $img = view('icons/mime', ['type' => $mime_type]);
250
                    }
251
252
                    // Form to create new media object in each tree
253
                    $create_form = '';
254
                    foreach ($media_trees as $media_tree => $media_directory) {
255
                        if (Str::startsWith($row[0], $media_directory)) {
256
                            $tmp         = substr($row[0], strlen($media_directory));
257
                            $create_form .=
258
                                '<p><a href="#" data-toggle="modal" data-target="#modal-create-media-from-file" data-file="' . e($tmp) . '" data-url="' . e(route('create-media-from-file', ['tree' => $media_tree])) . '" onclick="document.getElementById(\'modal-create-media-from-file-form\').action=this.dataset.url; document.getElementById(\'file\').value=this.dataset.file;">' . I18N::translate('Create') . '</a> — ' . e($media_tree) . '<p>';
259
                        }
260
                    }
261
262
                    $delete_link = '<p><a data-confirm="' . I18N::translate('Are you sure you want to delete “%s”?', e($row[0])) . '" data-post-url="' . e(route(DeletePath::class, [
263
                            'path'   => $row[0],
264
                        ])) . '" href="#">' . I18N::translate('Delete') . '</a></p>';
265
266
                    return [
267
                        $this->mediaFileInfo($media_folder, $row[0]) . $delete_link,
268
                        $img,
269
                        $create_form,
270
                    ];
271
                };
272
273
                return $this->datatables_service->handleCollection($request, $unused_files, $search_columns, $sort_columns, $callback);
274
275
            default:
276
                throw new BadRequestHttpException();
277
        }
278
    }
279
280
    /**
281
     * Generate some useful information and links about a media object.
282
     *
283
     * @param Media $media
284
     *
285
     * @return string HTML
286
     */
287
    private function mediaObjectInfo(Media $media): string
288
    {
289
        $html = '<b><a href="' . e($media->url()) . '">' . $media->fullName() . '</a></b>' . '<br><i>' . e($media->getNote()) . '</i></br><br>';
290
291
        $linked = [];
292
        foreach ($media->linkedIndividuals('OBJE') as $link) {
293
            $linked[] = '<a href="' . e($link->url()) . '">' . $link->fullName() . '</a>';
294
        }
295
        foreach ($media->linkedFamilies('OBJE') as $link) {
296
            $linked[] = '<a href="' . e($link->url()) . '">' . $link->fullName() . '</a>';
297
        }
298
        foreach ($media->linkedSources('OBJE') as $link) {
299
            $linked[] = '<a href="' . e($link->url()) . '">' . $link->fullName() . '</a>';
300
        }
301
        foreach ($media->linkedNotes('OBJE') as $link) {
302
            // Invalid GEDCOM - you cannot link a NOTE to an OBJE
303
            $linked[] = '<a href="' . e($link->url()) . '">' . $link->fullName() . '</a>';
304
        }
305
        foreach ($media->linkedRepositories('OBJE') as $link) {
306
            // Invalid GEDCOM - you cannot link a REPO to an OBJE
307
            $linked[] = '<a href="' . e($link->url()) . '">' . $link->fullName() . '</a>';
308
        }
309
        if ($linked !== []) {
310
            $html .= '<ul>';
311
            foreach ($linked as $link) {
312
                $html .= '<li>' . $link . '</li>';
313
            }
314
            $html .= '</ul>';
315
        } else {
316
            $html .= '<div class="alert alert-danger">' . I18N::translate('There are no links to this media object.') . '</div>';
317
        }
318
319
        return $html;
320
    }
321
322
    /**
323
     * Generate some useful information and links about a media file.
324
     *
325
     * @param string $media_folder
326
     * @param string $file
327
     *
328
     * @return string
329
     */
330
    private function mediaFileInfo(string $media_folder, string $file): string
331
    {
332
        $html = '<dl>';
333
        $html .= '<dt>' . I18N::translate('Filename') . '</dt>';
334
        $html .= '<dd>' . e($file) . '</dd>';
335
336
        $full_path = WT_DATA_DIR . $media_folder . $file;
337
        try {
338
            $size = filesize($full_path);
339
            $size = intdiv($size + 1023, 1024); // Round up to next KB
340
            /* I18N: size of file in KB */
341
            $size = I18N::translate('%s KB', I18N::number($size));
342
            $html .= '<dt>' . I18N::translate('File size') . '</dt>';
343
            $html .= '<dd>' . $size . '</dd>';
344
345
            try {
346
                $imgsize = getimagesize($full_path);
347
                $html    .= '<dt>' . I18N::translate('Image dimensions') . '</dt>';
348
                /* I18N: image dimensions, width × height */
349
                $html .= '<dd>' . I18N::translate('%1$s × %2$s pixels', I18N::number($imgsize['0']), I18N::number($imgsize['1'])) . '</dd>';
350
            } catch (Throwable $ex) {
351
                // Not an image, or not a valid image?
352
            }
353
354
            $html .= '</dl>';
355
        } catch (Throwable $ex) {
356
            // Not a file?  Not an image?
357
        }
358
359
        return $html;
360
    }
361
362
    /**
363
     * @param ServerRequestInterface $request
364
     *
365
     * @return ResponseInterface
366
     */
367
    public function upload(ServerRequestInterface $request): ResponseInterface
368
    {
369
        $data_filesystem = $request->getAttribute('filesystem.data');
370
        assert($data_filesystem instanceof FilesystemInterface);
371
372
        $media_folders = $this->media_file_service->allMediaFolders($data_filesystem);
373
374
        $filesize = ini_get('upload_max_filesize') ?: '2M';
375
376
        $title = I18N::translate('Upload media files');
377
378
        return $this->viewResponse('admin/media-upload', [
379
            'max_upload_files' => self::MAX_UPLOAD_FILES,
380
            'filesize'         => $filesize,
381
            'media_folders'    => $media_folders,
382
            'title'            => $title,
383
        ]);
384
    }
385
386
    /**
387
     * @param ServerRequestInterface $request
388
     *
389
     * @return ResponseInterface
390
     */
391
    public function uploadAction(ServerRequestInterface $request): ResponseInterface
392
    {
393
        $data_filesystem = $request->getAttribute('filesystem.data');
394
        assert($data_filesystem instanceof FilesystemInterface);
395
396
        $all_folders = $this->media_file_service->allMediaFolders($data_filesystem);
397
398
        foreach ($request->getUploadedFiles() as $key => $uploaded_file) {
399
            assert($uploaded_file instanceof UploadedFileInterface);
400
            if ($uploaded_file->getClientFilename() === '') {
401
                continue;
402
            }
403
            if ($uploaded_file->getError() !== UPLOAD_ERR_OK) {
404
                FlashMessages::addMessage(Functions::fileUploadErrorText($uploaded_file->getError()), 'danger');
405
                continue;
406
            }
407
            $key = substr($key, 9);
408
409
            $folder   = $request->getParsedBody()['folder' . $key];
410
            $filename = $request->getParsedBody()['filename' . $key];
411
412
            // If no filename specified, use the original filename.
413
            if ($filename === '') {
414
                $filename = $uploaded_file->getClientFilename();
415
            }
416
417
            // Validate the folder
418
            if (!$all_folders->contains($folder)) {
419
                break;
420
            }
421
422
            // Validate the filename.
423
            $filename = str_replace('\\', '/', $filename);
424
            $filename = trim($filename, '/');
425
426
            if (preg_match('/([:])/', $filename, $match)) {
427
                // Local media files cannot contain certain special characters, especially on MS Windows
428
                FlashMessages::addMessage(I18N::translate('Filenames are not allowed to contain the character “%s”.', $match[1]));
429
                continue;
430
            }
431
432
            if (preg_match('/(\.(php|pl|cgi|bash|sh|bat|exe|com|htm|html|shtml))$/i', $filename, $match)) {
433
                // Do not allow obvious script files.
434
                FlashMessages::addMessage(I18N::translate('Filenames are not allowed to have the extension “%s”.', $match[1]));
435
                continue;
436
            }
437
438
            $path = $folder . $filename;
439
440
            if ($data_filesystem->has($path)) {
441
                FlashMessages::addMessage(I18N::translate('The file %s already exists. Use another filename.', $path, 'error'));
442
                continue;
443
            }
444
445
            // Now copy the file to the correct location.
446
            try {
447
                $data_filesystem->writeStream($path, $uploaded_file->getStream()->detach());
448
                FlashMessages::addMessage(I18N::translate('The file %s has been uploaded.', Html::filename($path)), 'success');
449
                Log::addMediaLog('Media file ' . $path . ' uploaded');
450
            } catch (Throwable $ex) {
451
                FlashMessages::addMessage(I18N::translate('There was an error uploading your file.') . '<br>' . e($ex->getMessage()), 'danger');
452
            }
453
        }
454
455
        $url = route('admin-media-upload');
456
457
        return redirect($url);
458
    }
459
}
460