<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;

class PerhitunganModel extends Model
{
    protected $table = 'penilaian';
    protected $primaryKey = 'id_penilaian';
    protected $fillable = ['id_alternatif', 'id_kriteria', 'nilai'];
    public $timestamps = false;

    public static function data_nilai($id_alternatif, $id_kriteria)
    {
        return self::join('sub_kriteria', 'penilaian.nilai', '=', 'sub_kriteria.id_sub_kriteria')
            ->where('penilaian.id_alternatif', $id_alternatif)
            ->where('penilaian.id_kriteria', $id_kriteria)
            ->first();
    }

    public static function hapus_hasil($j)
    {
        DB::table('hasil')->where('jenis_kelamin', $j)->delete();
        return true;
    }

    public static function get_hasil($j)
    {
        $res = DB::table('hasil')
            ->join('alternatif', 'hasil.id_alternatif', '=', 'alternatif.id_alternatif')
            ->where('hasil.jenis_kelamin', $j)
            ->orderBy('hasil.nilai', 'DESC')
            ->get();

        if (request()->filled('division')) {
            $res = DB::table('hasil')
                ->join('alternatif', 'hasil.id_alternatif', '=', 'alternatif.id_alternatif')
                ->where('hasil.jenis_kelamin', $j)
                ->where('alternatif.divisi', request('division'))
                ->orderBy('hasil.nilai', 'DESC')
                ->get();
        }

        return $res;
    }
}