<?php

namespace App\Http\Controllers\Managment;

use App\Http\Controllers\Controller;
use App\Models\Cycle;
use App\Models\Page;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use PhpParser\Node\NullableType;

class CycleController extends Controller
{
  public function index()
  {
    return DB::table('cycles AS c')
      ->leftjoin('courses AS cr', 'c.id', 'cr.cycle_id')
      ->leftjoin('options AS m', 'c.modality_type_id', 'm.id')
      ->select(
        array(
          'c.id', 'c.name', 'c.imagen', 'c.certification', 'm.name AS modality', DB::raw('COUNT( DISTINCT cr.id) AS courses'),
        )
      )
      ->groupBy('c.id')->get();
  }

  public function store(Request $request)
  {
    try {
      DB::transaction(function () use ($request) {
        $cycle =  Cycle::create($request->all());
        $cycle->updateData($request->all(), true);
      });
      $response = true;
    } catch (\Throwable $th) {
      $response = $th;
    }
    return $response;
  }

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

  public function update(Request $request, $id)
  {
    $response = false;
    try {
      DB::transaction(function () use ($request, $id) {
        Cycle::find($id)->updateData($request->all());
      });
      $response = true;
    } catch (\Throwable $th) {
      $response = $th;
    }
    return $response;
  }

  public function destroy($id)
  {
    try {
      DB::transaction(function () use ($id) {
        $cycle = Cycle::find($id);
        Page::where('slug', '/ciclos/' . $cycle->slug)->first()->delete();
        $cycle->delete();
      });
      $response = true;
    } catch (\Throwable $th) {
      $response = $th;
    }
    return $response;
  }
}