<?php

namespace App\Http\Controllers;

use App\Models\Analisis;
use App\Models\Kriteria;
use App\Models\Penilaian;
use App\Models\Alternatif;
use App\Models\Perhitungan;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class AnalisisController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        try{
        $penilaians=Penilaian::all();
        $alternatifs=Alternatif::select('namaalternatif')->get();
        $kriterias=Kriteria::all();
        
        $na = Perhitungan::all()->sortByDesc('nilaipreferensi');
        $nilaiakhir = $na;
// dd($alternatifs);

        $tiapkrit = array();
        $tiapalter = array();
        foreach($kriterias as $kriteria){
            $kritkrit = Penilaian::select('nilai')
                        ->where('id_kriteria', $kriteria->idkrit)
                        ->orderBy('id_kriteria')
                        ->get();
            $tiapkrit[] = $kritkrit;
        }
        
        for ($a = 0; $a < $kriterias->count(); $a++){
            for ($b = 0; $b < $alternatifs->count(); $b++){
                $tiapkrite[$a][$b] = $tiapkrit[$a][$b]->nilai;
            }
        }
        
        for ($z = 0; $z < $alternatifs->count(); $z++){
            $tiapalter[] = $alternatifs[$z]->namaalternatif;
        }
        // dd($tiapkrite[1]);

        return view ('dashboards.analisis.index', [
            'nilaiakhir' => $nilaiakhir,
            'tiapalter' => $tiapalter,
            'tiapkrite' => $tiapkrite,
            'kriterias' => $kriterias
        ]);
    } catch (\Throwable $th){
        return redirect()->route('dashboard')->with('error','Silahkan Lengkapi Data Penilaian Terlebih Dahulu.');;
    }
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        //
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
    }

    /**
     * Display the specified resource.
     *
     * @param  \App\Models\Analisis  $analisis
     * @return \Illuminate\Http\Response
     */
    public function show(Analisis $analisis)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Models\Analisis  $analisis
     * @return \Illuminate\Http\Response
     */
    public function edit(Analisis $analisis)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Models\Analisis  $analisis
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, Analisis $analisis)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Models\Analisis  $analisis
     * @return \Illuminate\Http\Response
     */
    public function destroy(Analisis $analisis)
    {
        //
    }
}