<?php

namespace App\Http\Controllers\Backend;

use App\Exports\ActivityExport;
use App\Exports\HistoryCheckInExport;
use App\Http\Requests\CaptureFaceRequest;
use App\Http\Requests\ChangePasswordRequest;
use App\Http\Requests\CheckinRequest;
use App\Http\Requests\UserlistRequest;
use App\Http\Requests\DeleteUserRequest;
use App\Http\Requests\IsValidMonthRequest;
use App\Http\Requests\ExportCheckinHistoryRequest;
use App\Http\Requests\StoreUserRequest;
use App\Http\Requests\CheckinHistorylistRequest;
use App\Models\User;
use App\Models\Parameter;
use App\Services\UserService;
use Excel;
use Illuminate\Contracts\Foundation\Application;
use Illuminate\Contracts\View\Factory;
use Illuminate\Contracts\View\View;
use Illuminate\Support\Facades\Session;
use Symfony\Component\HttpFoundation\Response;
use Carbon\Carbon;

/**
 * Class UserController.
 */
class UserController
{
    /**
     * @var UserService
     */
    protected $userService;

    /**
     * @var Text for Activity Log
     */

    /**
     * UserController constructor.
     *
     * @param UserService $userService
     */
    public function __construct(UserService $userService)
    {
        $this->userService = $userService;
    }

    /**
     * @return Application|Factory|View
     */
    public function index()
    {
        $params = request()->all();
        if (empty($params['name'])) {
            $params['id'] = !empty($params['id']) ? $params['id'] : 'asc';
        }
        $response = $this->userService->getListUser($params);

        return view('backend.user.index')
            ->withUsers($response['data'])
            ->withParams($params);
    }

    /**
     * @return Application|Factory|View
     */
    public function create()
    {
        $userName = $this->userService->generateUsername();

        return view('backend.user.create', compact('userName'));
    }
    
    public function store(StoreUserRequest $request)
    {
        try {
            $result = $this->userService->createUser($request->all());
            if ($result['success']) {
                $this->userService->logActivity([
                    'description' => ACTIVITY_LOG['order_new'],
                    'target' => $result['data'],
                ]);
                \Session::flash('flash_success', $result['message']);
            } else {
                \Session::flash('flash_danger', $result['message']);
            }

            return redirect()->route('admin.user.index');
        } catch (\Exception $e) {
			\Log::error('■'.__CLASS__.'|'.__FUNCTION__.'|'.__LINE__.'|'.__FILE__.'|'.$e->getMessage());
            Session::flash('flash_danger', __('string.server.common.error'));
            return redirect()->route('admin.user.index');
        }
    }

    public function edit(User $user)
    {
        return view('backend.user.edit', compact('user'));
    }

    public function update(StoreUserRequest $request, User $user)
    {
        try {
            $result = $this->userService->updateUser(
                $user,
                $request->only([
                    'id',
                    'password',
                    'name',
                    'pronunciation_ja',
                    'classification',
                    'comment',
                    'item01',
                    'item02',
                    'item03',
                    'item04',
                    'display_order',
                    'is_admin',
                    'is_update_password'
                ])
            );
            
            if ($result['success']) {
                $this->userService->logActivity([
                    'description' => ACTIVITY_LOG['order_edit'],
                    'target' => $user,
                ]);

                \Session::flash('flash_success', $result['message']);
				return response()->json(['save' => 'ok']);
			} else {
                \Session::flash('flash_danger', $result['message']);
				return response()->json(['save' => $result['message']]);
			}
            return redirect()->route('admin.user.index');
        } catch (\Exception $e) {
			\Log::error('■'.__CLASS__.'|'.__FUNCTION__.'|'.__LINE__.'|'.__FILE__.'|'.$e->getMessage());
            Session::flash('flash_danger', __('string.server.common.error'));
			return response()->json(['save' => __('string.server.common.error')]);
			return redirect()->route('admin.user.index');
        }

    }

    /**
     * Delete Model User.
     *
     * @param User $user
     * @return void
     */
    public function destroy(User $user)
    {   
        try {
            $response = $this->userService->delete($user);

            if ($response['success']) {
                $this->userService->logActivity([
                    'description' => ACTIVITY_LOG['order_delete'],
                    'target' => $user
                ]);
                \Session::flash('flash_success', $response['message']);
            } else {
                \Session::flash('flash_danger', $response['message']);
            }

            return redirect()->route('admin.user.index');
        } catch (\Exception $e) {
			\Log::error('■'.__CLASS__.'|'.__FUNCTION__.'|'.__LINE__.'|'.__FILE__.'|'.$e->getMessage());
            Session::flash('flash_danger', __('string.server.common.error'));
            return redirect()->route('admin.user.index');
        }
    }

    /**
     * @return Application|Factory|View
     */
    public function showFormChangePassword()
    {
        return view('backend.user.change_password')
            ->withUser($this->userService->findUserById(auth()->user()->id));
    }

    public function changPassword(ChangePasswordRequest $request)
    {
        try {
            $response = $this->userService->changePassword($request->all());

            if ($response['success']) {
                \Session::flash('flash_success', $response['message']);
				return response()->json(['save' => 'ok']);
            } else {
                \Session::flash('flash_danger', $response['message']);
				return response()->json(['save' => $response['message']]);
            }

            return redirect()->route('admin.user.index');
        } catch (\Exception $e) {
			\Log::error('■'.__CLASS__.'|'.__FUNCTION__.'|'.__LINE__.'|'.__FILE__.'|'.$e->getMessage());
            Session::flash('flash_danger', __('string.server.common.error'));
            return redirect()->route('admin.user.index');
        }
    }

    public function showFormCaptureFace(User $user)
    {
        return view('backend.user.capture_face')
            ->withUser($user)
            ->withFaceImage($user->faceImage);
    }

    public function updateCaptureFace(CaptureFaceRequest $request)
    {
        $data = array();
        if($request->has('is_edit')) {

            if($request->get('is_edit') == '3') {
                $data['info'] = $this->userService->getInfo($request->get('user_id'));
            }elseif (count(array_filter($request->get('image',array()))) == 0) {
                $data['message'] = __('string.capture_face.no_change');
            }
        }else{
            if (count(array_filter($request->get('image',array()))) != 9) {
                $data['info'] = array();
                foreach(FACE_DIRECTION as $key => $value) {
                    $data['info'][$key] = array();
                    $data['info'][$key]['message'] = __('validation.capture_face.image_required');
                }
            }
        }
        if(count($data) == 0){
            try {
                $response = $this->userService->uploadCaptureFace($request->all());
                foreach($response as $response_key => $response_value) {
                    if($response_key == 'info') {
                        foreach($response_value as $response_value_key => $response_value_value) {
                            $data['info'][$response_value_key] = $response_value_value;
                            if(array_key_exists('message',$data['info'][$response_value_key])) {
                                $data['info'][$response_value_key]['message'] = __($data['info'][$response_value_key]['message']);
                            }
                        }
                    }elseif($response_key == 'message') {
                        $data[$response_key] = __($response_value);
                    } else {
                        $data[$response_key] = $response_value;
                    }
                }
                if(array_key_exists('success',$response)) {
                    if($response['success']) {
                        $this->userService->logActivity([
                            'description' => ACTIVITY_LOG['order_taken'],
                            'target' => $this->userService->findUserById($request->get('user_id')),
                        ]);
                        \Session::flash('flash_success', __('string.capture_face.create_success'));
                        $data['save'] = true;
                    }
                }
            } catch (\Exception $e) {
                $data['message'] = $e->getMessage();
            }
        }
        return response()->json($data);
    }

    /**
     * Show Checkin History of User
     *
     * @param User $user
     * @return void
     */
    public function checkinHistory(User $user)
    {
        $this->userService->logActivity([
            'description' => ACTIVITY_LOG['order_brows'],
            'target' => $user
        ]);

        if (auth()->id() != $user->id && !auth()->user()->isAdmin) {
            return redirect()->route('admin.user.index');
        }

        $params = request()->all();

        if (request()->has('time')) {
            $times = getParamsTimeCheckin(request()->time);

            if ($times) {
                $params['year'] = $times['year'];
                $params['month'] = $times['month'];
                $params['date'] = $times['date'] ?? false;
            } else {
                return redirect()->route('admin.checkin.history', ['user' => $user->id]);
            }
        }

        $params['order_by'] = !empty($params['order_by']) ? $params['order_by'] : 'asc';
        $checkinHistories = $this->userService->getListCheckInHistory($user->id, $params);

        return view('backend.user.checkin-history')
            ->withUser($user)
            ->withOrderBy($params['order_by'])
            ->withCheckinHistories($checkinHistories['data']);
    }

    /**
     * Store Checkin History
     *
     * @param CheckinRequest $request
     * @return void
     */
    public function checkin(CheckinRequest $request)
    {
//K.Nakazaki 2023/06/29 開始
//        $result = $this->userService->checkin($request->only(['id', 'face_image', 'time', 'flag', 'temperature', 'remote_addr']));
        $result = $this->userService->checkin($request->all());
//K.Nakazaki 2023/06/29 終了

        if ($result['success']) {
            return response()->json(__('string.checkin.create.success'), Response::HTTP_OK);
        }

        return response()->json($result['message'], Response::HTTP_INTERNAL_SERVER_ERROR);
    }

    public function userlist(UserlistRequest $request)
    {
        $data = array();
        $data['userlist'] = $this->userService->getUserlist($request->only(['id']));
        $data['status'] = 'ok';
//		\Log::debug(var_export($data,true));
		return response()->json($data, Response::HTTP_OK);
    }

    public function showApiDocumentation()
    {
        return view('backend.user.api_docs')
        ->withUser($this->userService->findUserById(auth()->user()->id));
    }

    public function showFormExportActivityLog()
    {
        return view('backend.user.export.activity-log')
        ->withUser($this->userService->findUserById(auth()->user()->id));
    }

    public function exportActivityLog(IsValidMonthRequest $request)
    {   
        if (app()->isLocale('en')) {
            define('CSV_HISTORY_CHECKIN', 'Identification History.csv');
            define('EXPORT_ACTIVITY_LOG', [
                'file_name' => 'System usage history.csv'
            ]);
        }
        else {
            define('CSV_HISTORY_CHECKIN', '認証履歴.csv');
            define('EXPORT_ACTIVITY_LOG', [
                'file_name' => '利用履歴.csv'
            ]);
        }
        
        try {
            list($year, $month) = explode('/', $request->time, 2);

            return  Excel::download(
                new ActivityExport($year, $month),
                EXPORT_ACTIVITY_LOG['file_name']
            );
        } catch (\Exception $e) {
			\Log::error('■'.__CLASS__.'|'.__FUNCTION__.'|'.__LINE__.'|'.__FILE__.'|'.$e->getMessage());
            Session::flash('flash_danger', __('string.server.common.error'));
            return redirect()->route('admin.user.index');
        }
    }

    public function showHistoryCheckInExport()
    {
        return view('backend.user.export_history_checkin')
            ->withUser($this->userService->findUserById(auth()->user()->id));
    }

    /**
     * Export Checkin History
     *
     * @param HistoryCheckInExport $export
     * @return void
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
     */
    public function exportHistoryCheckin(HistoryCheckInExport $export, ExportCheckinHistoryRequest $request)
    {
        if (app()->isLocale('en')) {
            define('CSV_HISTORY_CHECKIN', 'Identification History.csv');
            define('EXPORT_ACTIVITY_LOG', [
                'file_name' => 'System usage history.csv'
            ]);
        }
        else {
            define('CSV_HISTORY_CHECKIN', '認証履歴.csv');
            define('EXPORT_ACTIVITY_LOG', [
                'file_name' => '利用履歴.csv'
            ]);
        }
        
        try {
            return \Excel::download($export, CSV_HISTORY_CHECKIN, \Maatwebsite\Excel\Excel::CSV, [
                'Content-Type' => 'text/csv',
            ]);
        } catch (\Exception $e) {
			\Log::error('■'.__CLASS__.'|'.__FUNCTION__.'|'.__LINE__.'|'.__FILE__.'|'.$e->getMessage());
            Session::flash('flash_danger', __('string.server.common.error'));
            return redirect()->route('admin.user.index');
        }
    }
//##K.Nakazaki 2023/06/28 開始
    public function checkinHistoryList()
    {
        $params = request()->all();
        if (empty($params['date'])) {
            $params['date'] = date('Y-m-d');
        }

        $unknown = [];
        $known = [];
        $total = [];

        foreach($this->userService->getCheckinHistoryList($params) as $value) {
            $h = $value->checkin_at_time->format('H');
            $in_or_out = $value->in_or_out ? 'in' : 'out';
            if($value->user_id == 0) {
                if(! array_key_exists($h, $unknown)) {
                    $unknown[$h] = ['in'=>0,'out'=>0];
                }
                $unknown[$h][$in_or_out] += 1;
            }else{
                if(! array_key_exists($h, $known)) {
                    $known[$h] = ['in'=>0,'out'=>0];
                }
                $known[$h][$in_or_out] += 1;
            }
        }


        $user = $this->userService->getUser();
        $checkinHistoryList = $this->userService->getCheckinHistoryList($params, 20);

// //##K.Nakazaki 2023/08/25 開始
//         $location = function($flag, $device) {
//             $ret = $flag;
//             try {
//                 $devices = array();
//                 $file = storage_path('devices.json');
//                 if(file_exists($file)) {
//                     $devices=json_decode(file_get_contents($file),true);
//                 }
//                 $sw = true;
//                 foreach($devices as $key => $value) {
//                     if(array_key_exists('flag',$value) and array_key_exists('device',$value) and array_key_exists('name',$value)) {
//                         if($value['flag'] == $flag and $value['device'] == $device) {
//                             $ret = $value['name'];
//                             $sw = false;
//                         }
//                     }
//                 }
//                 if($sw) {
//                     $devices[] = array(
//                         'flag'   => $flag,
//                         'device' => $device,
//                         'name'   => $ret,
//                     );
//                     file_put_contents($file,json_encode($devices));
//                 }
//             } catch(Exception $e) {
//                 \log::error($e->getMessage());
//             }
//             return $ret;
//         };
// //##K.Nakazaki 2023/08/25 終了

        return view('backend.user.capture-history')
            ->withUser($user)
            ->withLists($checkinHistoryList)
//##K.Nakazaki 2023/08/25 開始
            ->withLocation($this->location())
//##K.Nakazaki 2023/08/25 終了
            ->withParams($params)
            ->withUnknown($unknown)
            ->withKnown($known)
            ->withTotal($total);
    }

    public function checkinHistoryImage()
    {
        $params = request()->all();
        if (empty($params['checkinHistoryId'])) {
            abort(404);
        }else{
            return $this->userService->getCheckinHistoryImage(
                ['id' => $params['checkinHistoryId']]
            );
        }
    }
//##K.Nakazaki 2023/06/28 終了

//##K.Nakazaki 2023/08/23 開始
// //##K.Nakazaki 2023/08/25 開始
//         $location = function($flag, $device) {
//             $ret = $flag;
//             try {
//                 $devices = array();
//                 $file = storage_path('devices.json');
//                 if(file_exists($file)) {
//                     $devices=json_decode(file_get_contents($file),true);
//                 }
//                 $sw = true;
//                 foreach($devices as $key => $value) {
//                     if(array_key_exists('flag',$value) and array_key_exists('device',$value) and array_key_exists('name',$value)) {
//                         if($value['flag'] == $flag and $value['device'] == $device) {
//                             $ret = $value['name'];
//                             $sw = false;
//                         }
//                     }
//                 }
//                 if($sw) {
//                     $devices[] = array(
//                         'flag'   => $flag,
//                         'device' => $device,
//                         'name'   => $ret,
//                     );
//                     file_put_contents($file,json_encode($devices));
//                 }
//             } catch(Exception $e) {
//                 \log::error($e->getMessage());
//             }
//             return $ret;
//         };
// //##K.Nakazaki 2023/08/25 終了
    public function location()
    {
        return function($flag, $device) {
            $ret = $flag;
            try {
                $devices = array();
                $file = storage_path('devices.json');
                if(file_exists($file)) {
                    $devices=json_decode(file_get_contents($file),true);
                }
                $sw = true;
                foreach($devices as $key => $value) {
                    if(array_key_exists('flag',$value) and array_key_exists('device',$value) and array_key_exists('name',$value)) {
                        if($value['flag'] == $flag and $value['device'] == $device) {
                            $ret = $value['name'];
                            $sw = false;
                        }
                    }
                }
                if($sw) {
                    $devices[] = array(
                        'flag'   => $flag,
                        'device' => $device,
                        'name'   => $ret,
                    );
                    file_put_contents($file,json_encode($devices));
                }
            } catch(Exception $e) {
                \log::error($e->getMessage());
            }
            return $ret;
        };
    }

    public function workerList()
    {
        $params = array();
        $params['display_order'] = 'asc';
        $params['date'] = request()->get('date',date('Y-m-d'));

        $data = array();
        $data['date'] = $params['date'];

        $data['workerList'] = array();
        #
        $add = array();
        $parameter_table = Parameter::where('group','speak');
        $parameter_table->where('name','UNKNOWN_PRONUNCIATION_JA');
        foreach($parameter_table->get() as $value) {
            $add['name'] = $value->value;
        }
        $add['status'] = '';
        $add['初回入室時間'] = '';
        $add['最終退室時間'] = '';
        $add['入室件数'] = '';
        $add['退室件数'] = '';
        $add['履歴'] = array();
        $data['workerList'][0] = $add;
        #
        foreach($this->userService->getListUser($params)['data'] as $key => $value) {
            $add = array();
            $add['name'] = $value->name;

            $add['classification'] = $value->classification;
            $add['item01'] = $value->item01;
            $add['item02'] = $value->item02;
            $add['item03'] = $value->item03;
            $add['item04'] = $value->item04;

            $add['status'] = '';
            $add['初回入室時間'] = '';
            $add['最終退室時間'] = '';
            $add['入室件数'] = '';
            $add['退室件数'] = '';
            $add['履歴'] = array();
            $data['workerList'][$value->id] = $add;
        }

        $data['開始時間'] = 9;
        $data['終了時間'] = 18;

        foreach($this->userService->getCheckinHistoryList($params) as $value) {
            if(array_key_exists($value->user_id ,$data['workerList'])) {
                if($data['開始時間'] > $value->checkin_at_time->format('H')) {
                    $data['開始時間'] = $value->checkin_at_time->format('H');
                }
                if($data['終了時間'] < $value->checkin_at_time->format('H')) {
                    $data['終了時間'] = $value->checkin_at_time->format('H');
                }
                if($value->in_or_out == 0) {
                    $data['workerList'][$value->user_id]['status'] = '在籍';

                    if($data['workerList'][$value->user_id]['初回入室時間'] == '') {
                        $data['workerList'][$value->user_id]['初回入室時間'] = $value->checkin_at_time->format('H:i');
                    }
                    if($data['workerList'][$value->user_id]['入室件数'] == '') {
                        $data['workerList'][$value->user_id]['入室件数'] = 0;
                    }
                    $data['workerList'][$value->user_id]['入室件数'] += 1;

                } else {
                    $data['workerList'][$value->user_id]['status'] = '離籍';
                    $data['workerList'][$value->user_id]['最終退室時間'] = $value->checkin_at_time->format('H:i');
                    if($data['workerList'][$value->user_id]['退室件数'] == '') {
                        $data['workerList'][$value->user_id]['退室件数'] = 0;
                    }
                    $data['workerList'][$value->user_id]['退室件数'] += 1;
                }

                $add = array();
                $add['checkin_at_time'] = $value->checkin_at_time;
                $add['in_or_out'] = $value->in_or_out;
                $add['device'] = $value->device;
                $data['workerList'][$value->user_id]['履歴'][] = $add;
            }
        }
        $data['開始時間'] -= 1;
        if($data['開始時間'] < 0) {
            $data['開始時間'] = 0;
        }
        $data['終了時間'] += 1;
        if($data['終了時間'] > 23) {
            $data['終了時間'] = 23;
        }
        $data['開始時間'] = 0;
        $data['終了時間'] = 23;

        $nowdate = Carbon::now();
        $nowMinute = $nowdate->format('H') * 60 + $nowdate->format('i');
        $data['間隔分'] = 15;
        foreach($data['workerList'] as $key => $value) {
            $add = array();
            for($hour = 0; $hour < 24; $hour++) {
                for($minute = 0; $minute < 60; $minute += $data['間隔分']) {
                    $minute_index = $hour * 60 + $minute;
                    $add[$minute_index] = array();
                    $add[$minute_index]['時'] = $hour;
                    $add[$minute_index]['分'] = $minute;
                    $add[$minute_index]['image'] = '';
                    $add[$minute_index]['attribute'] = '';
                    if($data['date'] == $nowdate->format('Y-m-d') && ($minute_index <= $nowMinute) && ($nowMinute < ($minute_index + $data['間隔分']))) {
                        $add[$minute_index]['attribute'] .= ' class="now"';
                    }

                }
            }
            foreach($value['履歴'] as $key2 => $value2) {
                if($value2['in_or_out'] == 0) {
                    $v = 0;
                }elseif($value2['in_or_out'] == 1) {
                    $v = $data['間隔分'] - 1;
                }

                $minute_index = intval(floor(($value2['checkin_at_time']->format('H') * 60 + $value2['checkin_at_time']->format('i') - $v) / $data['間隔分']) * $data['間隔分']);

                if(array_key_exists($minute_index, $add)) {
                    foreach($add as $ret_key => $ret_value) {
                        if($value2['checkin_at_time']->format('Y/m/d') == $nowdate->format('Y/m/d') && $ret_key > $nowMinute) {
                            //未来
                        }elseif($ret_key == $minute_index) {
                            if($value2['in_or_out'] == 0) {
                                $add[$ret_key]['image'] = 'g';
                            }elseif($value2['in_or_out'] == 1) {
                                $add[$ret_key]['image'] = 'i';
                            }
                        }elseif($ret_key > $minute_index) {
                            if($value2['in_or_out'] == 0) {
                                $add[$ret_key]['image'] = 'h';
                            }elseif($value2['in_or_out'] == 1) {
                                $add[$ret_key]['image'] = '';
                            }
                        }
                    }
                }
            }

            //			\Log::error('■'.__CLASS__.'|'.__FUNCTION__.'|'.__LINE__.'|'.__FILE__.'|'.var_export($add ,True));
            $data['workerList'][$key]['list'] = $add;
        }

        #
        $data['filter'] = array();
        $data['filter']['status'] = array();
        $data['filter']['classification'] = array();
        $data['filter']['item01'] = array();
        $data['filter']['item02'] = array();
        $data['filter']['item03'] = array();
        $data['filter']['item04'] = array();

        foreach($data['workerList'] as $key => $value) {
            if($key != 0) {
                $data['workerList'][$key]['filter'] = array();
                foreach($data['filter'] as $key2 => $value2) {
                    if(! array_key_exists($value[$key2], $data['filter'][$key2])) {
                        $data['filter'][$key2][$value[$key2]] = count($data['filter'][$key2]) + 1;
                    }
                    $data['workerList'][$key]['filter'][$key2] = $data['filter'][$key2][$value[$key2]];
                }
            }
        }

        foreach($data['filter'] as $key => $value) {
            ksort($data['filter'][$key]);
        }

        return view('backend.user.workerlist')
            ->withParams($params)
            ->withNow($nowdate)
            ->withData($data);
    }
//##K.Nakazaki 2023/08/23 終了
}
