<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\Prompt;
use Illuminate\Support\Facades\Hash;

class PromptController extends Controller
{
    //
    public function index(Request $request)
    {
        $prompts = Prompt::query();

        $title = "Prompts list";
        
        /*if($request->q){
            $prompts->where(function($query) use($request) {
                $query->where('name', 'like', '%'.$request->q.'%')
                    ->orWhere('email', 'like', '%'.$request->q.'%');
            });
        }*/
        $dir = $request->get('dir', 'desc');

        
        if (!in_array(strtolower($dir), ['asc', 'desc'])) {
            $dir = 'desc';
        }
        $col = "prompts.created_at";

        if($request->col){
            $col = $request->col;
        }
        $prompts = $prompts->where("user_id",null)->orderBy($col, $dir);

        $prompts = $prompts->paginate(20); // 10 users per page

        return view('prompts.index', compact('prompts','title'));
    }
    public function listUserPrompts(Request $request, $id)
    {
        $prompts = Prompt::query();

        $title = "Prompts list";
        
        /*if($request->q){
            $prompts->where(function($query) use($request) {
                $query->where('name', 'like', '%'.$request->q.'%')
                    ->orWhere('email', 'like', '%'.$request->q.'%');
            });
        }*/
        $dir = $request->get('dir', 'desc');

        
        if (!in_array(strtolower($dir), ['asc', 'desc'])) {
            $dir = 'desc';
        }
        $col = "prompts.created_at";

        if($request->col){
            $col = $request->col;
        }
        //$prompts = $prompts->where("user_id",$id)->where("website_id",null)->orderBy($col, $dir);

        $prompts = $prompts->where("user_id",$id)->orderBy($col, $dir);

        $prompts = $prompts->paginate(20); // 10 users per page

         $prompts_count = Prompt::query();

        //->where("website_id",null)
        $prompts_count = $prompts_count->where("user_id",$id)->count();

        return view('prompts.user_prompts', compact('prompts','title','id','prompts_count'));
    }
    
     public function viewSiteStructure(Request $request, $id)
    {
        $prompt = Prompt::query()->where("id", $id)->first();

        $title = "Site Structure";
        
        $meta = json_decode($prompt->meta, true);

        return view('prompts.site_structure', compact('prompt','title','id','meta'));
    }

}