<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use App\Seo;
use Illuminate\Http\Request;
use Illuminate\Support\Arr;
use App\Fortunemethod;
use App\Helpers\Helper;
use App\Http\Resources\Admin\FortunemethodResource;
use App\Http\Resources\Admin\FortuneMethodListResource;
use Validator;
use DB;

/**
 * Class FortunemethodController
 *
 * @package App\Http\Controllers
 */
class FortunemethodController extends Controller
{
    const ITEM_PER_PAGE = 20;
    private $_imagePath;

    public function __construct()
    {
        $this->_imagePath = public_path('uploads/image/method/');
    }

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

        if (!empty($keyword)) {
            $list->where('name', 'LIKE', '%' . $keyword . '%');
        }
        if ($status != '') {
            $list->where('is_activated', $status);
        }
        $list->orderBy('order')->orderBy('id');

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

    public function listOrder(Request $request)
    {
        $searchParams = $request->all();
        $limit = Arr::get($searchParams, 'limit', static::ITEM_PER_PAGE);
        $list = Fortunemethod::select('fortune_methods.id', 'fortune_methods.name', 'fortune_method_details.fortune_method_id', DB::raw('COUNT(fortune_methods.id) as total'))
            ->leftJoin('fortune_method_details', 'fortune_methods.id', '=', 'fortune_method_details.fortune_method_id')
            ->where('fortune_methods.is_deleted', false)
            ->groupBy('fortune_methods.id')
            ->orderByRaw('COUNT(fortune_methods.id) desc')
            ->orderBy('fortune_methods.id', 'DESC')
            ->paginate($limit);

        return FortuneMethodListResource::collection($list);
    }

    public function all()
    {
        $list = Fortunemethod::select('id', 'name', 'slug')->notDeleted()->orderBy('order')->orderBy('id');

        return FortunemethodResource::collection($list->get());
    }

    public function show($id = 0)
    {
        $fortunemethod = Fortunemethod::notDeleted()->where('id', $id)->first();
        if (!isset($fortunemethod)) return response()->json(['errors' => 'Fortunemethod is not valid'], 403);

        return new FortunemethodResource($fortunemethod);
    }

    public function store(Request $request)
    {
        $validator = Validator::make($request->all(), ['name' => ['required'], 'is_activated' => ['required']]);
        if ($validator->fails()) return response()->json(['errors' => $validator->errors()], 403);
        $params = $request->all();
        $countAll = 0;
        $lastItem = Fortunemethod::where('is_deleted', false)->orderBy('order', 'DESC')->first();
        if (isset($lastItem)) $countAll = $lastItem->order + 1;
        $logo = isset($params['logo']) ? $params['logo'] : '';
        $topName = isset($params['top_name']) ? $params['top_name'] : '';

        $fortunemethod = Fortunemethod::create([
            'name'         => $params['name'],
            'slug'         => Helper::slug($params['slug']),
            'description'  => $params['description'],
            'logo'         => $logo,
            'top_name'     => $topName,
            'order'        => $countAll,
            'show_top'     => (isset($params['show_top']) && $params['show_top'] === true) ? 1 : 0,
            'is_activated' => (isset($params['is_activated']) && $params['is_activated'] === false) ? 0 : 1,
            'created_at'   => date('Y-m-d H:i:s'),
            'updated_at'   => date('Y-m-d H:i:s')
        ]);
        if ($logo != "" && $logo != null) Helper::copyThumbFit($this->_imagePath . $logo, $this->_imagePath, 150, 150);

        $seoTitle = "『" . $params['name'] . "』の当たると口コミで評判のオススメの占い師｜占いの森 / URAMORI";
        $seoDesc = "『" . $params['name'] . "』の的中率の高い・当たると評判のオススメ占い師を口コミ評価レビュー、占い料金、性別、得意な占術・相談お悩み内容などで検索し探せます。";
        $uri = "/method/" . $fortunemethod->slug;
        $checkSeo = Seo::where('uri', $uri)->first();
        if (isset($checkSeo) && $checkSeo->id != null) {
            $checkSeo->update([
                'title'       => $seoTitle,
                'description' => $seoDesc,
                'updated_at'  => date('Y-m-d H:i:s'),
            ]);
        } else {
            Seo::create([
                'uri'         => $uri,
                'title'       => $seoTitle,
                'description' => $seoDesc,
                'type'        => 'method',
                'created_at'  => date('Y-m-d H:i:s'),
                'updated_at'  => date('Y-m-d H:i:s'),
            ]);
        }

        return new FortunemethodResource($fortunemethod);
    }

    public function update($id = 0, Request $request)
    {
        $validator = Validator::make($request->all(), ['name' => ['required'], 'is_activated' => ['required']]);
        if ($validator->fails()) return response()->json(['errors' => $validator->errors()], 403);
        $fortunemethod = Fortunemethod::notDeleted()->where('id', $id)->first();
        if (!isset($fortunemethod)) return response()->json(['errors' => 'Fortunemethod is not valid'], 403);
        $oldSlug = $fortunemethod->slug;
        $params = $request->all();
        if ($params['logo'] != "" && $params['logo'] != null && $fortunemethod->logo != $params['logo']) Helper::copyThumbFit($this->_imagePath . $params['logo'], $this->_imagePath, 150, 150);
        $fortunemethod->update([
            'name'         => $params['name'],
            'slug'         => Helper::slug($params['slug']),
            'description'  => $params['description'],
            'logo'         => $params['logo'],
            'top_name'     => $params['top_name'],
            'show_top'     => ($params['show_top'] === true) ? 1 : 0,
            'is_activated' => ($params['is_activated'] === true) ? 1 : 0,
            'updated_at'   => date('Y-m-d H:i:s')
        ]);

        $seoTitle = "『" . $params['name'] . "』の当たると口コミで評判のオススメの占い師｜占いの森 / URAMORI";
        $seoDesc = "『" . $params['name'] . "』の的中率の高い・当たると評判のオススメ占い師を口コミ評価レビュー、占い料金、性別、得意な占術・相談お悩み内容などで検索し探せます。";
        $checkSeo = Seo::where('uri', "/method/" . $oldSlug)->first();
        if (isset($checkSeo) && $checkSeo->id != null) {
            $checkSeo->update([
                'uri'         => "/method/" . $fortunemethod->slug,
                'title'       => $seoTitle,
                'description' => $seoDesc,
                'type'        => 'method',
                'updated_at'  => date('Y-m-d H:i:s'),
            ]);
        } else {
            $checkSeo = Seo::where('uri', "/method/" . $fortunemethod->slug)->first();
            if (isset($checkSeo) && $checkSeo->id != null) {
                $checkSeo->update([
                    'title'       => $seoTitle,
                    'description' => $seoDesc,
                    'updated_at'  => date('Y-m-d H:i:s'),
                ]);
            } else {
                Seo::create([
                    'uri'         => "/method/" . $fortunemethod->slug,
                    'title'       => $seoTitle,
                    'description' => $seoDesc,
                    'type'        => 'method',
                    'created_at'  => date('Y-m-d H:i:s'),
                    'updated_at'  => date('Y-m-d H:i:s'),
                ]);
            }
        }

        return response()->json(null, 204);
    }

    public function destroy($id = 0)
    {
        $fortunemethod = Fortunemethod::notDeleted()->where('id', $id)->first();
        if (!isset($fortunemethod)) response()->json(['error' => 'Ehhh! Can not delete this category'], 403);

        try {
            $fortunemethod->update(['is_deleted' => true]);
        } catch (\Exception $ex) {
            response()->json(['error' => $ex->getMessage()], 403);
        }

        return response()->json(null, 204);
    }

    public function destroyMultiple(Request $request) {
        $validator = Validator::make($request->all(), ['ids' => 'required']);
        if ($validator->fails()) return response()->json(['errors' => $validator->errors()], 403);
        $listIds = $request->get('ids', []);
        $fortunemethodList = Fortunemethod::notDeleted()->whereIn('id', $listIds)->get();
        if ($fortunemethodList->count() <= 0) response()->json(['error' => 'Fortunemethod is not valid.'], 403);
        try {
            Fortunemethod::notDeleted()->whereIn('id', $listIds)->update(['is_deleted' => true]);
        } catch (\Exception $ex) {
            response()->json(['error' => $ex->getMessage()], 403);
        }

        return response()->json(null, 204);
    }

    public function activateMultiple(Request $request) {
        $validator = Validator::make($request->all(), ['ids' => 'required']);
        if ($validator->fails()) return response()->json(['errors' => $validator->errors()], 403);
        $listIds = $request->get('ids', []);
        $fortunemethodList = Fortunemethod::notDeleted()->whereIn('id', $listIds)->get();
        if ($fortunemethodList->count() <= 0) response()->json(['error' => 'Fortunemethod is not valid.'], 403);
        try {
            Fortunemethod::notDeleted()->whereIn('id', $listIds)->update(['is_activated' => true]);
        } catch (\Exception $ex) {
            response()->json(['error' => $ex->getMessage()], 403);
        }

        return response()->json(null, 204);
    }

    public function deactivateMultiple(Request $request) {
        $validator = Validator::make($request->all(), ['ids' => 'required']);
        if ($validator->fails()) return response()->json(['errors' => $validator->errors()], 403);
        $listIds = $request->get('ids', []);
        $fortunemethodList = Fortunemethod::notDeleted()->whereIn('id', $listIds)->get();
        if ($fortunemethodList->count() <= 0) response()->json(['error' => 'Fortunemethod is not valid.'], 403);
        try {
            Fortunemethod::notDeleted()->whereIn('id', $listIds)->update(['is_activated' => false]);
        } catch (\Exception $ex) {
            response()->json(['error' => $ex->getMessage()], 403);
        }

        return response()->json(null, 204);
    }

    public function uploadImage(Request $request)
    {
        if ($request->hasFile('image')) {
            $file = $request->file('image');
            $baseName = $file->getClientOriginalName();
            $fileName = md5($baseName . rand(1111, 9999) . date('YmdHis')) . '.' . $file->getClientOriginalExtension();
            $file->move($this->_imagePath, $fileName);
            return response()->json(['status' => 'success', 'message' => 'Upload Success.', 'file_name' => $fileName, 'baseName' => $baseName], 200);
        }

        return response()->json(['status' => 'error', 'message' => 'Upload Fail.', 'file_name' => null], 403);
    }

    public function position(Request $request)
    {
        if (!$request->has('position')) return response()->json(['errors' => 'Data is invalid'], 403);
        $newIndexes = $request->position;
        if (is_array($newIndexes)) {
            foreach ($newIndexes as $item) {
                Fortunemethod::where('id', $item['id'])->update(['order' => $item['order']]);
            }
        }

        return response()->json(null, 204);
    }

    public function setTop($id = 0)
    {
        $item = Fortunemethod::where('id', $id)->where('is_deleted', false)->first();
        if (isset($item)) {
            $setStatus = ($item->show_top == 0) ? 1 : 0;
            $item->update(['show_top' => $setStatus]);
        }

        return response()->json(null, 204);
    }
}