<?php

namespace App\Http\Controllers\Managment;

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

class BannerController extends Controller
{
  public function index()
  {
    return DB::table('banners AS b')
      ->join('pages AS p', 'b.page_id', 'p.id')
      ->select('b.id', 'p.name', 'b.name AS title', 'b.order', 'b.imagen')
      ->get();
  }

  public function store(Request $request)
  {
    try {
      DB::transaction(function () use ($request) {
        $banner =  Banner::create($request->all());
        $banner->saveImage($request->image); //Almecena imagen
      });
      return true;
    } catch (\Throwable $th) {}
  }

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

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

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