bluzphp / module-media

application/models/Media/Table.php

<?php
/**
 * @copyright Bluz PHP Team
 * @link https://github.com/bluzphp/skeleton
 */

declare(strict_types=1);

namespace Application\Media;

use Application\Exception;

The type Application\Exception was not found. Maybe you did not declare it correctly or list all dependencies?

use Bluz\Proxy\Auth;

/**
 * Table
 *
 * @package  Application\Media
 *
 * @method   static Row findRow($primaryKey)
 * @method   static Row findRowWhere($whereList)
 */
class Table extends \Bluz\Db\Table
{
    /**
     * Table
     *
     * @var string
     */
    protected $name = 'media';

    /**
     * Primary key(s)
     * @var array
     */
    protected $primary = ['id'];

    /**
     * Get images of current user
     *
     * @return Row[]
     * @throws Exception
     */
    public function getImages()
    {
        /* @var \Application\Users\Row $user */
        if (!$user = Auth::getIdentity()) {
            throw new Exception('User not found');
        }

        return $this->getImagesByUserId($user->getId());
    }

    /**
     * Get images by owner
     *
     * @param  integer $id
     * @return Row[]
     */
    public function getImagesByUserId($id)
    {
        return self::select()
            ->where('type LIKE (?)', 'image/%')
            ->andWhere('userId = ?', $id)
            ->execute();
    }
}