<?php

namespace App\Http\Controllers\Managment;

use App\Http\Controllers\Controller;
use App\Models\Page;
use App\Models\Section;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx\Rels;

class PageController extends Controller
{
  public function index()
  {
    return Page::get();
  }

  public function getPages()
  {
    return DB::table('pages AS p')
      ->leftjoin('page_sections AS ps', 'p.id', 'ps.page_id')
      ->select(
        array(
          'p.id', 'p.name', 'p.slug', 'p.is_menu', DB::raw('COUNT( DISTINCT ps.id) AS sections'),
        )
      )
      ->groupBy('p.id')->orderBy('p.is_menu', 'desc')->orderBy('p.name')->get();
  }

  public function getSections(){
    return Section::select('id', 'name')->orderBy('name')->get();
  }

  public function edit($id){
    return Page::find($id)->getFullData();
  }

  public function update( Request $request, $id){
    try {
      DB::transaction(function () use ($request, $id) {
        Page::find($id)->updateFullData($request);
      });
      return true;
    } catch (\Throwable $th) {
      return $th;
    }
    
  }

  public function destroy($id)
  {
    try {
      DB::transaction(function () use ($id) {
        Page::find($id)->delete();
      });
      $response = true;
    } catch (\Throwable $th) {
      $response = $th;
    }
    return $response;
  }
}