<?php

namespace App\Repositories;

use App\Models\CheckinHistory;
##K.Nakazaki 2023/06/28 開始
use App\Models\User;
use App\Models\Parameter;
##K.Nakazaki 2023/06/28 終了
use Illuminate\Support\Facades\Storage;

class CheckinHistoryRepository
{
    /**
     * The repository model.
     *
     * @var Model
     */
    public $model;

    /**
     * CheckinHistoryRepository Construct
     *
     * @param CheckinHistory $checkin
     */
    public function __construct(CheckinHistory $checkin)
    {
//        \Log::info('■'.__CLASS__.'|'.__FUNCTION__.'|'.__LINE__.'|'.__FILE__);
        $this->model = $checkin;
    }

    /**
     * Store Checkin History
     *
     * @param array $attributes
     * @return void
     */
    public function createCheckin(array $attributes)
    {
        return $this->model->create($attributes);
    }

    /**
     * Get List Checkin History of a user
     *
     * @param int|string $user_id
     * @param array $params
     * @return mix
     */
    public function getListCheckin($user_id, $params = [])
    {
        $query = $this->model->whereUserId($user_id);

        if (
            !empty($params['year']) && !empty($params['month'])
            && is_numeric($params['month']) && is_numeric($params['year'])
        ) {
            $query = $query->whereYear('checkin_at_time', $params['year'])
                ->whereMonth('checkin_at_time', $params['month']);

            if (!empty($params['date']) && is_numeric($params['date'])) {
                $date = $params['year'] . '-' . $params['month'] . '-' . $params['date'];
                $query = $query->whereDate('checkin_at_time', $date);
            }
        }

        if (!empty($params['order_by']) && $params['order_by'] == 'desc') {
            $query = $query->latest('checkin_at_time');
        } else {
            $query = $query->oldest('checkin_at_time');
        }

        return $query->get();
    }
//##K.Nakazaki 2023/06/28 開始
    public function getCheckinHistoryList(array $params = [], $paginate = 0)
    {
        $query = $this->model;
        $query = $query->whereDate('checkin_at_time', $params['date']);
        $query->orderBy('checkin_at_time');
        if($paginate > 0) {
//##K.Nakazaki 2023/08/24 開始
//            return $query->paginate($paginate);
            return $query->paginate($paginate)->appends(['date'=>$params['date']]);
//##K.Nakazaki 2023/08/24 終了
        }else{
            return $query->get();
        }
    }

    public function getUser()
    {
        $data = [];
//        $data = $this->parameterSpeak('speak');
//$data['UNKNOWN_PRONUNCIATION_JA'] = 'Stranger';
        $parameter_table = Parameter::where('group','speak');
        $parameter_table->where('name','UNKNOWN_PRONUNCIATION_JA');
        foreach($parameter_table->get() as $value) {
            $data[0] = $value->value;
        }
        $user_table = User::orderBy('id');
        foreach($user_table->get() as $value) {
            $data[$value->id] = $value->name;
        }
        return $data;
    }

    public function getCheckinHistoryImage(array $params = [])
    {
        $query = $this->model;
        $query = $query->where('id', $params['id']);
        $query_records = $query->get();
        if(count($query_records) == 1) {
            $query_value = $query_records[0];
            if(Storage::disk('local')->exists(URL_IMAGE_CHECKIN . $query_value->image)) {
                return Storage::disk('local')->download(URL_IMAGE_CHECKIN . $query_value->image);
            }
        }
        return abort(404);
    }
//##K.Nakazaki 2023/06/28 終了
}
