49 lines
1.5 KiB
PHP
49 lines
1.5 KiB
PHP
<?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;
|
|
}
|
|
}
|