<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Arr;
use App\Http\Resources\SiteResource;
use App\Site;
use Validator;
use DB;

class SiteController extends Controller
{
    const ITEM_PER_PAGE = 20;

    private $_user = null;

    public function __construct()
    {
        $this->_user = auth('api')->user();
    }

    public function index(Request $request)
    {
        $searchParams = $request->all();
        $limit = Arr::get($searchParams, 'limit', static::ITEM_PER_PAGE);
        $keyword = Arr::get($searchParams, 'keyword', '');

        $siteIds = DB::table('user_projects')
            ->join('projects', 'user_projects.project_id', '=', 'projects.id')
            ->join('sites', 'projects.site_id', '=', 'sites.id')
            ->select('sites.id')
            ->where('user_projects.user_id', $this->_user->id)
            ->where('sites.is_deleted', false)
            ->where('sites.is_activated', true)
            ->pluck('id')
            ->toArray();

        $list = Site::isPublished()->whereIn('id', $siteIds);

        if (!empty($keyword)) {
            $list->where('name', 'LIKE', '%' . $keyword . '%');
        }

        $list->orderBy('position')->orderBy('id');

        return SiteResource::collection($list->paginate($limit));
    }
}