<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use App\Models\log;

class LogController extends Controller
{

	/**
	 * Display a listing of the resource.
	 *
	 * @return \Illuminate\Http\Response
	 */
	public function index(Request $request)
	{
		$data['mainMenu'] = 'blogManagement';
		$data['subMenu'] = 'logsList';
		if (isset($_GET['query']) && strlen($_GET['query']) > 1) {

			$search_text = $_GET['query'];

			$data['logs'] = DB::table('logs')->where('activity', 'LIKE', '%' . $search_text . '%')->orderBy('id', 'desc')->paginate(10);
		} else {
			$data['logs'] = DB::table('logs')->orderBy('id', 'desc')->paginate(10);
		}
		// dd(logs);
		return view('admin.logs.list', $data);
	}

	/**
	 * Show the form for creating a new resource.
	 *
	 * @return \Illuminate\Http\Response
	 */
	public function create(Request $request)
	{
		$admin_id = $request->session()->get('loggedIn')['id'];
		$data['mainMenu'] = 'blogManagement';
		$data['subMenu'] = 'blogList';

		$data['categories'] = Main_category::where(['admin_id' => $admin_id, 'parent_id' => 0])->get();
		$data['teachers'] = Admin_user::where(['role_id' => 7])->get();
		return view('admin.blog.add-blog', $data);
	}

	/**
	 * Store a newly created resource in storage.
	 *
	 * @param  \Illuminate\Http\Request  $request
	 * @return \Illuminate\Http\Response
	 */
	public function store(Request $request)
	{

		$admin_id = $request->session()->get('loggedIn')['id'];
		$request->validate([
			'selectCatId' => 'required',
			'blog_title' => 'required',
			'short_desc' => 'required',
			'description' => 'required',
			'teacher_id' => 'required',
			'image' => 'required|image|mimes:jpeg,png,jpg,gif,svg',
		]);


		$imageName = time() . rand() . '.' . $request->image->extension();

		$request->image->move(public_path('uploads/blog'), $imageName);

		// dd($imageName);

		$slug =  str_replace(' ', '-', strtolower($request->blog_title));
		$_sortOrder = Blog::get()->last();
		if (empty($_sortOrder)) {
			$sort_order = 1;
		} else {
			$sort_order =  $_sortOrder->sort_order + 1;
		}

		// dd($request->selectCatId);

		$data = array(


			'cat_id' => $request->selectCatId,
			'blog_title' => $request->blog_title,
			'short_desc' => $request->short_desc,
			'description' => $request->description,
			'author' => $request->teacher_id,
			'image' => $imageName,
			'slug' => $slug,
			'sort_order' => $sort_order,
			'status' => "1",

		);

		// dd($data);


		$res = Blog::create($data);
		if ($res) {
			return back()
				->with('success', $request->blog_title . ' Has Been Added!.');
		} else {
			return back()
				->with('error', 'Something Went Wrong!');
		}
	}

	/**
	 * Display the specified resource.
	 *
	 * @param  int  $id
	 * @return \Illuminate\Http\Response
	 */
	public function show($id)
	{
		$data['mainMenu'] = 'blogManagement';
		$data['subMenu'] = 'blogList';

		$data['blog'] = Blog::where(['id' => $id])->first();
		return view('admin.blog.view-blog', $data);
	}

	/**
	 * Show the form for editing the specified resource.
	 *
	 * @param  int  $id
	 * @return \Illuminate\Http\Response
	 */
	public function edit($id)
	{
		$admin_id = 2;
		$data['mainMenu'] = 'blogManagement';
		$data['subMenu'] = 'blogList';

		$data['blog'] = Blog::where(['id' => $id])->first();
		$data['teachers'] = Admin_user::where(['role_id' => 7])->get();
		$data['categories'] = Main_category::where(['admin_id' => $admin_id, 'parent_id' => 0])->get();
		return view('admin.blog.edit-blog', $data);
	}

	/**
	 * Update the specified resource in storage.
	 *
	 * @param  \Illuminate\Http\Request  $request
	 * @param  int  $id
	 * @return \Illuminate\Http\Response
	 */
	public function update(Request $request, $id)
	{
		// dd($request->input());
		$admin_id = $request->session()->get('loggedIn')['id'];

		$blog = Blog::where(['id' => $id])->first();

		// dd($request->image);
		if (!empty($request->image)) {
			$request->validate([
				'category' => 'required',
				'blog_title' => 'required',
				'short_desc' => 'required',
				'description' => 'required',
				'teacher_id' => 'required',
				'sort_order' => 'required',
				'image' => 'required|image|mimes:jpeg,png,jpg,gif,svg',
			]);

			if (File::exists(public_path('uploads/blog/' . $blog->image))) {

				File::delete(public_path('uploads/blog/' . $blog->image));
			}


			$imageName = time() . rand() . '.' . $request->image->extension();
			$request->image->move(public_path('uploads/blog'), $imageName);

			$data = array(

				'cat_id' => $request->category,
				'blog_title' => $request->blog_title,
				'short_desc' => $request->short_desc,
				'description' => $request->description,
				'author' => $request->teacher_id,
				'sort_order' => $request->sort_order,
				'image' => $imageName,

				'status' => "1",

			);

			$res = Blog::where(['id' => $id])->update($data);
			if ($res) {
				return back()
					->with('success', $request->blog_title . ' Has Been Added!.');
			} else {
				return back()
					->with('error', 'Something Went Wrong!');
			}
		}

		if (empty($request->image)) {
			// dd($request->input());
			$request->validate([
				'category' => 'required',
				'blog_title' => 'required',
				'short_desc' => 'required',
				'description' => 'required',
				'teacher_id' => 'required',
				'sort_order' => 'required',


			]);


			$data = array(

				'cat_id' => $request->category,
				'blog_title' => $request->blog_title,
				'short_desc' => $request->short_desc,
				'description' => $request->description,
				'author' => $request->teacher_id,
				'sort_order' => $request->sort_order,
				'status' => "1",

			);

			// dd($data);

			$res = Blog::where(['id' => $id])->update($data);
			if ($res) {
				return back()
					->with('success', $request->blog_title . ' Has Been Updated!.');
			} else {
				return back()
					->with('error', 'Something Went Wrong!');
			}
		}
	}

	/**
	 * Remove the specified resource from storage.
	 *
	 * @param  int  $id
	 * @return \Illuminate\Http\Response
	 */
	public function destroy($id)
	{
		$delete = Blog::where(['id' => $id])->first();

		if (File::exists(public_path('uploads/blog/' . $delete->image))) {

			File::delete(public_path('uploads/blog/' . $delete->image));
		}
		Blog::where(['id' => $id])->delete();
		return back()->with('success', 'Blog deleted successfully');
	}
}