<?php

namespace FootyRoom\Repositories;

use FootyRoom\Core\Wall\Wall;
use FootyRoom\Support\AutoMapper;
use Illuminate\Database\Connection;

class WallRepository
{
    /**
     * @var \Illuminate\Database\Connection
     */
    protected $mysql;

    /**
     * Constructor.
     *
     * @param \Illuminate\Database\Connection $mysql
     */
    public function __construct(Connection $mysql)
    {
        $this->mysql = $mysql;
    }

    /**
     * Finds wall by userId.
     *
     * @param int $userId
     *
     * @return \FootyRoom\Core\Wall\Wall|null
     */
    public function findByUserId($userId)
    {
        $postDto = $this->mysql

        ->table('fr_users')
        ->select([
            'user_id as userId',
            'username',
        ])
        ->where('user_id', '=', $userId)
        ->first();

        if (!$postDto) {
            return null;
        }

        $post = AutoMapper::map($postDto, Wall::class);

        return $post;
    }
}