<?php

namespace App\Http\Controllers\Managment;

use App\Http\Controllers\Controller;
use App\Models\Course;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class CourseController extends Controller
{
  public function index()
  {
    return DB::table('courses AS c')
      ->leftjoin('cycles AS cy', 'cy.id', 'c.cycle_id')
      ->select('c.id', 'c.name', 'c.start_date', 'c.end_date', 'cy.name AS cycle', 'c.certification')
      ->orderBy('c.start_date', 'desc')->get();
  }

  public function store(Request $request)
  {
    try {
      DB::transaction(function () use ($request) {
        $course =  Course::create($request->all());
        $course->updateFullData($request->all()); //Almecena imagen
      });
      $response = true;
    } catch (\Throwable $th) {
      $response = $th;
    }
    return $response;
  }

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

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

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