CoverController::__construct()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 16
Code Lines 6

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
eloc 6
dl 0
loc 16
rs 10
c 0
b 0
f 0
cc 1
nc 1
nop 7
1
<?php
2
/**
3
 * Audio Player
4
 *
5
 * This file is licensed under the Affero General Public License version 3 or
6
 * later. See the LICENSE.md file.
7
 *
8
 * @author Marcel Scherello <[email protected]>
9
 * @author Sebastian Doell <[email protected]>
10
 * @copyright 2016-2021 Marcel Scherello
11
 * @copyright 2015 Sebastian Doell
12
 */
13
14
namespace OCA\audioplayer\Controller;
15
16
use OCP\AppFramework\Controller;
17
use OCP\IL10N;
18
use OCP\IRequest;
19
use Psr\Log\LoggerInterface;
20
use OCP\IDBConnection;
21
use \OCA\audioplayer\Http\ImageResponse;
0 ignored issues
show
Bug introduced by
The type \OCA\audioplayer\Http\ImageResponse was not found. Maybe you did not declare it correctly or list all dependencies?

The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. excluded_paths: ["lib/*"], you can move it to the dependency path list as follows:

filter:
    dependency_paths: ["lib/*"]

For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths

Loading history...
22
23
24
class CoverController extends Controller
25
{
26
27
    private $userId;
28
    private $l10n;
29
    private $logger;
30
    private $DBController;
31
    private $db;
32
33
    public function __construct(
34
        $appName,
35
        IRequest $request,
36
        $userId,
37
        IL10N $l10n,
38
        IDBConnection $db,
39
        LoggerInterface $logger,
40
        DbController $DBController
41
    )
42
    {
43
        parent::__construct($appName, $request);
44
        $this->userId = $userId;
45
        $this->l10n = $l10n;
46
        $this->db = $db;
47
        $this->logger = $logger;
48
        $this->DBController = $DBController;
49
    }
50
51
    /**
52
     * @NoAdminRequired
53
     * @NoCSRFRequired
54
     * @param $album
55
     * @return ImageResponse
56
     */
57
    public function getCover($album)
58
    {
59
        $cover = '';
60
        $SQL = "SELECT  `cover`, `name`, `artist_id`
61
				FROM `*PREFIX*audioplayer_albums` 
62
			 	WHERE  `user_id` = ? AND `id` = ? 
63
			 	";
64
65
        $stmt = $this->db->prepare($SQL);
66
        $stmt->execute(array($this->userId, $album));
67
        $results = $stmt->fetchAll();
0 ignored issues
show
Deprecated Code introduced by
The function OCP\DB\IPreparedStatement::fetchAll() has been deprecated: 21.0.0 use \OCP\DB\IResult::fetchAll on the \OCP\DB\IResult returned by \OCP\IDBConnection::prepare ( Ignorable by Annotation )

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

67
        $results = /** @scrutinizer ignore-deprecated */ $stmt->fetchAll();

This function has been deprecated. The supplier of the function has supplied an explanatory message.

The explanatory message should give you some clue as to whether and when the function will be removed and what other function to use instead.

Loading history...
68
        foreach ($results as $row) {
69
            $artist = $this->DBController->loadArtistsToAlbum($album, $row['artist_id']);
70
            $cover = $row['cover'];
71
            if ($row['name'] === $this->l10n->t('Unknown') AND $artist === $this->l10n->t('Various Artists')) {
72
                $cover = 'iVBORw0KGgoAAAANSUhEUgAAAPoAAAD6CAIAAAAHjs1qAAAAK3RFWHRDcmVhdGlvbiBUaW1lAERpIDE1IE5vdiAyMDE2IDExOjU3OjA0ICswMTAwCiwhogAAAAd0SU1FB+ALDwo7AioIm6cAAAAJcEhZcwAALiMAAC4jAXilP3YAAAAEZ0FNQQAAsY8L/GEFAAAO2UlEQVR42u3d+1NU9R/H8f5EWG5ykzukZUR4wVBD00olsxwzvDRUIxNUViQzFZE6EGmlNSqokBd0FKPClDtetvfgfBu/nvf7s8vu+ZzP4bxfjx+dz9mjZ5+7fnb3c855JgNAjWdc/wUAgoPcQRHkDoogd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDoogd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDoogd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDoogd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDoogd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDoogd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDoogd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDoogd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDoogd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDoogd1AEuYMiyB0UQe6gCHJ3oLS09Ny5c7OzsyMjIytWrAhgjzU1NS+++GJeXp7rf7pjyD1oVN7Nmzfj/3Pnzp26ujp7uyssLOzr65ucnKRX1+jo6I4dO1wfAJeQe6AaGhoePHgQ/39zc3NFRUU2dkdv5+Pj40/t7t1333V9GJxB7sF566234oL9+/fb2OPhw4fZ3dXX17s+GG4g94C0tbXFZd3d3TZ2OjAwwO5uYmIiPz/f9SFxALlbF4vFenp64kbHjx+3sesLFy5Ie+zv73d9YBxA7nbl5uYODg7GE7GU+6FDhww7bW5udn14gobcLSorKxsbG0vYur3cc3Jy/vzzT2mn8/PzJSUlrg9SoJC7LXV1dTMzM8m0bi938vzzzz969Eja788//+z6OAUKuVuxZcuWJEO3nTvZs2ePYdf0V3V9tIKD3P23f//+RbVuO3dC7+LSrsfHx2nO4/qYBQS5++zo0aOLbT393GtqatauXVtZWSkNKCgomJ6elvb+wQcfuD5sAUHuvsnOzv7ll19SaD2d3IuLi8+fP//f45w5c0b6Qv2NN96Q9n7//n16HNfHLwjI3R9FRUVXr15NrfWUc4/FYrdu3Xrqoa5du0Z/zo43vBo7OztdH8IgIHcfrFix4t69eym3nnLur776KvtobW1t7Hia7Ujf0tCfl5aWuj6Q1iH3dDU2NtJkIJ3WU879yJEj0gO+8MIL7CYdHR2a3+CRe1reeeedNENPJ3fDV0Cjo6NZWVneTWhmL31mpRetpYWZ4YHcU/fxxx/70nrKuVdVVRkes7W1ld3K8CKRNokM5J4K+ix47Ngxv1pPOXfy2WefSY8pfd+Sk5MzMTHBbnL37t3s7GzXR9ci5L5oeXl5Fy9e9LH1dHKnGYv3y5n/9PT0sFu9//770iZbt251fYAtQu6LU1FRYVh0FXzupLa21vDIK1eu9G6ybNmyubk5dvzZs2ddH2OLkPsirF69OvlVX4HlnmGc0vT19bGbGH79LSsrc32kbUHuydq2bZuN0H3JneZXk5OT0oNXV1d7N6mpqZHGHzx40PXBtgW5J8V8noS93Glqvnv37t7e3m+++WbDhg2GvyENkx7822+/ZTcZGhpix4+MjLg+3rZEM/ecnJxcn9A0t6ury2rrUu4FBQVPfQyVPnqSzMzMJ6/n8aQHDx4UFhZ6N3nzzTelv09VVZXr59CKqOW+a9eu69evz/hkenpa+kgXQO6nTp3yjty3b5/0b9++fbv0+Hv27PGOp9eA9yogj+3du9f1M2lFpHI3/Kgect7ci4qK2PUt8/Pz7Ft1xsKSzDt37rCPf+3aNXaTM2fOsON/++0310+mFdHJvbW11XW0fuZu+MWU5vHSQWhpaZG2Yr+RbG5uZgfT/2k0i3P9lPovOrkbTl8IP2/ueXl5s7Oz0viKigr2IND/CdL8pKOjwzu+pKRE2sWaNWtcP6X+i07urov1OXfyxRdfSOOlL1vIyZMn2U3oIw07nuY57PhIrp9B7qHA5k7TiampKXY8vYVLqxc3bdok7YX9/Uj6wBPJn1eReyhI37sbFhhLl5WkWZD00+/bb7/tHb9x40Z28MTERPSWiyH3UDD8zCR92XLr1q3MzEx2q9OnT7Ob/PTTT97By5cvl05xMpzrvUQh91AwLCI4cOCAtJV0KwTpUsP0yvGe8xGLxf766y92fFNTk+tn1WfIPRQMuRcWFkonB3700UfsJhUVFdKO2K90pKvQRG/xDHIPBfMSsb6+Pnar4eFhdrxhCvTKK694x7e3t7ODDd//LFHIPRTMuVOj7FbSYpgM+Rob7BWUdu7cyQ4eHBx0/az6DLmHgjn3ZcuWSfOZdevWsZtId084ceKEd/BLL73EDqZPwxG7exlyD4WE690vXbrEbtjS0sKOl1bns/Of0tJSdvDExMSzzz7r+on1E3IPhYS5S+crSUuCn3vuOXY8++VMfn4++7/H3NyceZH9koPcQyFh7q+//jq74cWLF9nx0mKY2dlZ7/V+6QVw9+5d7+CHDx9G7MsZ5B4KCXNftWoVu+HY2Bj7YxPNuefn573jHz16tHz58qcG0yP88ccf7OBPP/3U9RPrJ+QeCglzLy8vZzecmZnJzc31jo/FYuwbdlz4rfTGjRts7hH7LhK5h0LC3Ondml3ZS3PugoIC73jDb6XsmdrS5Ytt32chYMg9FBJWRW/h7GmENL1ml0ZS7tL1cGpqarzjpW9+InZaE3IPhWRyZ9c50nyDzZ2m41Lu7HeL586dYwcPDQ25fmL9hNxDIZnc2Y+eNMNZ7GSGfXeXJjO9vb2un1g/IfdQSJi74Uxt9qRSyl1aNsNeVGNkZIQdbLjUx1KE3EMhYe40A2E3HB8fZ29Nk52dLZ286z2niWY+7HVV6QX21VdfuX5i/YTcQyFh7g0NDeyGN27cYMcXFxez/xvQ5Mf7vwHl/vfff3sH0+dgaY3xEoXcQyFh7tJV+6TbXldXV7Pj7927511EIF31gF4bzc3Nrp9YPyH3UEiYe39/P7the3s7O76xsZEdz16PQPpgMDU1tWrVKtdPrJ+QeyiYc5fWtJDXXnuN3WTfvn3s+NOnT3sHr1y5kh1MM5ySkhLXT6yfkHsomHOXljfG5WuX0gOy448cOeIdvGHDBnbw5cuXpVu0LlHIPRTMuUvnatC7L5uj9E0L2blzp3e8dPY3e+WCJQ25h4Ihdwp6bGyM3Ur6UtxwaV/24gXfffcdO5i9zt6ShtxDwZD7+vXrpa02bdrEbiJ9azkzM+Nd7J4h/6S6Y8cO18+qz5B7KBhyl66RJC39zZAvLnnp0iXvYGllPKmtrXX9rPoMuYeClLt0Vgfp7u5mN6GJ++3bt9lN2MmJtAt6DeTn57t+Vn2G3ENByn1gYEDaRHrrlZYbkLq6Ou/49957jx0sXTF4SUPuocDmLl1ehly5ckU6DtKt66emptiJu3RFmq6uLtdPqf+ik7uNu/u6zf3333+Xxm/evJk9CFlZWePj4+wmP/zwg3e8tIyebNu2zfVT6r/o5L5+/XpL9/h1kju9E0ufIGmaIV37V/pORsp3zZo10vjy8nLXT6n/opN7xsKlyqVrN4ecN3d6n5buZUAvbOkI/Prrr+wm09PT7Nc4nZ2d7PibN29Kr6glLVK5k7KyssOHDx9fcCxt33//vXQvF9u5E/oLeEeeOnVK+rcb1hp8/fXX3vGGmc/nn3/u+pm0Imq5+y4Wi/X09DjJvbi4+Kkzkv755x/6Q+mveuLECenx2a9x6uvrpfHSpSeXOuSelA8//DD43DMWfgNqb28fGRmh+XpHR4fh5o/Sqsb4wkovdpPu7m52/OTkJPsdTgQg92Tt2rUr+NyTd/bsWenB2Q+phls4Rez81Cch90Wgz4jStyVuc29qapIe+fbt2+yqyd27d0ubRHUmk4HcF6u6upom0KHKPTs7mz3T9DH27LvMzEyaHbHjpUXF0YDcF62wsNDwA1DwuR89elR62NHRUbbdtWvXSpu0tbW5PsAWIfdU0Bvqjz/+GIbcDcuDSWNjI7vV+fPnpU3YWw1HBnJP3Zdffuk2d3rnZi9U/Zh0eUfp1jTk5MmTrg+qXcg9LS0tLQ5zp8+UhseU7jMzODgobUKvBNdH1C7knq7Nmzenv3IhtdylO+aR1tZWdhPDKkv25I+IQe4+qK2tlda3WM1d+ll0eHiYXfGSlZUlnflBInYbJhZy90dpaeno6GjAudPc3ft9Iv1XI12NwzD1ku5IHDHI3Te5ubnSVdIt5Z6xsCTuyWtszM/Pb9y4kR1JL0jp8gSkoaHB9fELAnL3E00hpIUolnLPWJiiNDU1HTp0aPv27YazS6W1wfHI3aLDALn7L4X1ZLZvgWRYMhAXLj4TScjdiubm5vDkXllZaZjGdHZ2uj5awUHutqxbty759WT2cqepjnRnjvjCbeDz8vJcH6rgIHeLqqqqpCv3BpZ7V1eXYb9bt251fZAChdztKigoGB4edpV7bW2tYaf9/f2uD0/QkLt1NJ2QbkZgO/dPPvlE2uPk5GT0LhKWEHIPiHTO/2OWTiCSLu0blxdLRhtyD450Rw1y8OBBG3uUvn+UbnETecg9UFu2bPGuJ7t//77h+gLpyMnJ8Z57NTAwEMlryCQDuQeNPj4+uU6L5tAvv/yyvd1VVlYODQ09fo09fPiwr68vqlcZSAZyd6C8vPzy5cvxhRND6+vrbe+OPivTZKm3t5fmNq7/6Y4hd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDoogd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDoogd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDoogd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDoogd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDoogd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDoogd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDoogd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDoogd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDoogd1AEuYMiyB0UQe6gCHIHRZA7KILcQRHkDor8C3D7LDKaAfDjAAAAAElFTkSuQmCC';
73
            }
74
        }
75
        $imageData = base64_decode($cover);
76
        return new ImageResponse(array('mimetype' => 'image/jpg', 'content' => $imageData));
77
    }
78
}
79