functions

<?php
error_reporting(0);
//jlh data di produk
function Cek_CountData($mysqli)
{
    $query_string = "SELECT count(k1) as jlh FROM produk";
    $result = $mysqli->query($query_string);
    $row = $result->fetch_assoc();
    $jlh = $row['jlh'];
    return $jlh;
}

//function insert data ke Produk
function Insert_Produk($mysqli, $name, $harga, $resolusi1, $resolusi2, $sensor1, $sensor2, $iso, $speed, $tgl, $SSM, $deskripsi, $kategori, $gambar){
    $query_string = "INSERT INTO `produk`( `nama_produk`, `harga_produk`, `r1`, `r2`, `s1`, `s2`, `iso`, `ssm`, `valueSSM`, `tgl_release`, `deskripsi`, `kategori`, `gambar`) VALUES ('$name','$harga','$resolusi1','$resolusi2','$sensor1','$sensor2','$iso','$speed','$SSM', '$tgl', '$deskripsi','$kategori','$gambar')";
    $result = $mysqli->query($query_string);
    return $result;
}

//Tampilkan Semua Nilai r1*r2
function Cek_NilaiResolusi($mysqli, $hrg_Terbesar)
{
    $query_string = "select `id_produk`, `nama_produk`, (r1*r2), ( select find_in_set((r1*r2), ( select group_concat(distinct (r1*r2) order by (r1*r2) DESC separator ',') from produk)) ) as rangking from produk where harga_produk between 0 and '$hrg_Terbesar'";
    $result = $mysqli->query($query_string);
    while($row = mysqli_fetch_array($result))
        $data[]= $row;
    return $data;
}
//Tampilkan Semua Nilai s1*s2
function Cek_NilaiSensor($mysqli, $hrg_Terbesar)
{
    $query_string = "select `id_produk`, `nama_produk`, (s1*s2), ( select find_in_set((s1*s2), ( select group_concat(distinct (s1*s2) order by (s1*s2) DESC separator ',') from produk where harga_produk between 0 and '$hrg_Terbesar')) ) as rangking from produk where harga_produk between 0 and '$hrg_Terbesar'";
    $result = $mysqli->query($query_string);
    while($row = mysqli_fetch_array($result))
        $data[]= $row;
    return $data;
}
//Tampilkan Semua Nilai ISO
function Cek_NilaiISO($mysqli, $hrg_Terbesar)
{
    $query_string = "select `id_produk`, `nama_produk`, iso, ( select find_in_set(iso, ( select group_concat(distinct (iso) order by (iso) DESC separator ',') from produk)) ) as rangking from produk where harga_produk between 0 and '$hrg_Terbesar'";
    $result = $mysqli->query($query_string);
    while($row = mysqli_fetch_array($result))
        $data[]= $row;
    return $data;
}
//Tampilkan Semua Nilai ISO
function Cek_NilaiSSM($mysqli, $hrg_Terbesar)
{
    $query_string = "select `id_produk`, `nama_produk`, valueSSM, ( select find_in_set((valueSSM), ( select group_concat(distinct (valueSSM) order by (valueSSM) ASC separator ',') from produk)) ) as rangking from produk where harga_produk between 0 and '$hrg_Terbesar'";
    $result = $mysqli->query($query_string);
    while($row = mysqli_fetch_array($result))
        $data[]= $row;
    return $data;
}

//Cek Nilai terbesar pada kolom K1
function Cek_MaxK1($mysqli, $harga)
{
    $query_string = "SELECT max(r1*r2) as jlh FROM `produk` where `harga_produk` between '0' and '$harga' ";
    $result = $mysqli->query($query_string);
    $row = $result->fetch_assoc();
    $terbesarK1 = $row['jlh'];
    return $terbesarK1;
}
//Cek Nilai terbesar pada kolom K2
function Cek_MaxK2($mysqli, $harga)
{
    $query_string = "SELECT DISTINCT max(s1*s2) as terbesark2 FROM `produk` where `harga_produk` between '0' and '$harga'";
    $result = $mysqli->query($query_string);
    $row = $result->fetch_assoc();
    $terbesark2 = $row['terbesark2'];
    return $terbesark2;
}
//Cek Nilai terbesar pada kolom K3
function Cek_MaxK3($mysqli, $harga)
{
    $query_string = "SELECT DISTINCT max(iso) as terbesarK3 FROM produk where `harga_produk` between '0' and '$harga'";
    $result = $mysqli->query($query_string);
    $row = $result->fetch_assoc();
    $terbesarK3 = $row['terbesarK3'];
    return $terbesarK3;
}
//Cek Nilai terbesar pada kolom K4
function Cek_MinK4($mysqli, $harga)
{
    $query_string = "SELECT DISTINCT min(valueSSM) as terbesarK4 FROM produk where `harga_produk` between '0' and '$harga'";
    $result = $mysqli->query($query_string);
    $row = $result->fetch_assoc();
    $terbesarK4 = $row['terbesarK4'];
    return $terbesarK4;
}

//cek harga terbesar
function Hrg_Terbesar($mysqli)
{
    $query_string = "SELECT DISTINCT max(harga_produk) as big FROM produk";
    $result = $mysqli->query($query_string);
    $row = $result->fetch_assoc();
    $big = $row['big'];
    return $big;
}

//cek harga berdasarkan pilihan user
function Cek_HrgUser($mysqli, $hrg)
{
    $query_string = "SELECT * FROM `produk` WHERE `harga_produk` between '0' and '$hrg'";
    $result = $mysqli->query($query_string);
    while($row = mysqli_fetch_array($result))
        $data[]= $row;
    return $data;
}
function Tampil_HasilRekomendasi($mysqli, $hrg)
{
    $query_string = "SELECT * FROM `produk` WHERE `harga_produk` between '0' and '$hrg' LIMIT 0, 20";
    $result = $mysqli->query($query_string);
    while($row = mysqli_fetch_array($result))
        $data[]= $row;
    return $data;
}

//Tampil Produk
function Tampil_Produk($mysqli){
    $query_string = "SELECT * from produk";
    $result = $mysqli->query($query_string);
    while($row = mysqli_fetch_array($result))
        $data[]= $row;
    return $data;
}
function Tampil_Produk8($mysqli){
    $query_string = "SELECT * FROM `produk` order by id_produk DESC LIMIT 0,8";
    $result = $mysqli->query($query_string);
    while($row = mysqli_fetch_array($result))
        $data[]= $row;
    return $data;
}
function Tampil_ProdukMore($mysqli, $more){
    $query_string = "SELECT * FROM produk WHERE id_produk < $more ORDER BY id_produk DESC LIMIT 0,8";
    $result = $mysqli->query($query_string);
    while($row = mysqli_fetch_array($result))
        $data[]= $row;
    return $data;
}

function TampilProdukById($mysqli,$id){
    $query_string = "SELECT * from produk where id_produk='$id'";
    $result = $mysqli->query($query_string);
    $row = $result->fetch_assoc();
    $nama_produk = $row['nama_produk'];
    return $nama_produk;
}
//Tampil Edit Produk
function Tampil_EditProduk($mysqli, $id){
    $query_string = "SELECT * from produk where id_produk='$id'";
    $result = $mysqli->query($query_string);
    while($row = mysqli_fetch_array($result))
        $data[]= $row;
    return $data;
}
//Ambil Gambar
function Tampil_GambarSlide1($mysqli){
    $query_string = "SELECT * from produk order by `id_produk` DESC LIMIT 1";
    $result = $mysqli->query($query_string);
    $row = $result->fetch_assoc();
    $nama_produk = $row['gambar'];
    return $nama_produk;
}
function Tampil_GambarSlide2($mysqli){
    $query_string = "SELECT * from produk order by `id_produk` DESC LIMIT 1,1";
    $result = $mysqli->query($query_string);
    $row = $result->fetch_assoc();
    $nama_produk = $row['gambar'];
    return $nama_produk;
}
function Tampil_GambarSlide3($mysqli){
    $query_string = "SELECT * from produk order by `id_produk` DESC LIMIT 2,1";
    $result = $mysqli->query($query_string);
    $row = $result->fetch_assoc();
    $nama_produk = $row['gambar'];
    return $nama_produk;
}
//Update Produk
function Update_Produk($mysqli, $nama, $harga, $r1, $r2, $s1, $s2, $iso, $speed, $SSM, $tgl, $kategori, $deskripsi, $id){
    $query_string = "UPDATE `produk` SET `nama_produk`='$nama',`harga_produk`='$harga',`r1`='$r1',`r2`='$r2',`s1`='$s1',`s2`='$s2',`iso`='$iso',`ssm`='$speed', `valueSSM`='$SSM', `tgl_release`='$tgl',`deskripsi`='$deskripsi',`kategori`='$kategori' WHERE id_produk='$id'";
    $result = $mysqli->query($query_string);
    return $result;
}
function Update_ProdukWithGambar($mysqli, $nama, $harga, $r1, $r2, $s1, $s2, $iso, $speed, $SSM, $tgl, $kategori, $deskripsi, $id, $gambar){
    $query_string = "UPDATE `produk` SET `nama_produk`='$nama',`harga_produk`='$harga',`r1`='$r1',`r2`='$r2',`s1`='$s1',`s2`='$s2',`iso`='$iso',`ssm`='$speed', `valueSSM`='$SSM', `tgl_release`='$tgl',`deskripsi`='$deskripsi',`kategori`='$kategori', `gambar`='$gambar' WHERE id_produk='$id'";
    $result = $mysqli->query($query_string);
    return $result;
}

//Tampil Produk hasil rekomendais
function Tampil_ProdukRekomendasi($mysqli, $nama){
    $query_string = "SELECT * from produk where nama_produk='$nama'";
    $result = $mysqli->query($query_string);
    while($row = mysqli_fetch_array($result))
        $data[]= $row;
    return $data;
}

//Tampil Kategori Sony
function Tampil_ProdukSony($mysqli){
    $query_string = "SELECT * from produk where kategori='3' order by tgl_release desc";
    $result = $mysqli->query($query_string);
    while($row = mysqli_fetch_array($result))
        $data[]= $row;
    return $data;
}
//Tampil Kategori Canon
function Tampil_ProdukCanon($mysqli){
    $query_string = "SELECT * from produk where kategori = '4' order by tgl_release desc";
    $result = $mysqli->query($query_string);
    while($row = mysqli_fetch_array($result))
        $data[]= $row;
    return $data;
}
//Tampi Kategori Nikon
function Tampil_ProdukNikon($mysqli){
    $query_string = "SELECT * from produk where kategori='2' order by tgl_release desc";
    $result = $mysqli->query($query_string);
    while($row = mysqli_fetch_array($result))
        $data[]= $row;
    return $data;
}
//Tampi Produk Lainya
function Tampil_ProdukLain($mysqli, $id){
    $query_string = "SELECT * from produk WHERE `id_produk` <> '$id'";
    $result = $mysqli->query($query_string);
    while($row = mysqli_fetch_array($result))
        $data[]= $row;
    return $data;
}

//Nama Kategori
function Nama_Kategori($mysqli){
    //$id_view =mysqli_real_escape_string($mysqli,$id_view);
    $query_string = "SELECT * FROM kategori";
    $result = $mysqli->query($query_string);
    while($row = mysqli_fetch_array($result))
    $data[]= $row;
    return $data;
}

//Tampil Profil
function Profil($mysqli, $user){
    $query_string = "SELECT * FROM admin where username='$user'";
    $result = $mysqli->query($query_string);
    while($row = mysqli_fetch_array($result))
    $data[]= $row;
    return $data;
}
//Update Profil
function UpdateProfil($mysqli,$nama,$username,$alamat,$email,$user){
    $query_string = "UPDATE `admin` SET `username`='$username', `email`='$email',`nama_lengkap`='$nama',`alamat`='$alamat' WHERE username='$user'";
    $result = $mysqli->query($query_string);
    return $result;
}
function CekPassword($mysqli, $user){
    $user =mysqli_real_escape_string($mysqli,$user);
    $query_string = "SELECT * FROM admin WHERE username='$user'";
    $result = $mysqli->query($query_string);
    $row = $result->fetch_assoc();
    $password = $row['password'];
    return $password;
}
function UpdatePassword($mysqli, $password, $user){
    $query_string = "UPDATE `admin` SET password='$password' WHERE username='$user'";
    $result = $mysqli->query($query_string);
    return $result;
}

//Delete produk
function DeleteProduk($mysqli, $id){
    $query_string = "delete from produk WHERE id_produk='$id'";
    $result = $mysqli->query($query_string);
    return $result;
}
//Simpan Hasil MAE
function SimpanMae($mysqli, $mae, $akurasi){
    $query_string = "INSERT INTO `hasil_pengujian`( `mae`, `akurasi`) VALUES ('$mae','$akurasi')";
    $result = $mysqli->query($query_string);
    return $result;
}
//Ambil Semua data hasil pengujian
function GetHasilPengujian($mysqli){
    $query_string = "SELECT * from hasil_pengujian";
    $result = $mysqli->query($query_string);
    while($row = mysqli_fetch_array($result))
    $data[]= $row;
    return $data;
}


function generateRandomString($length = 6) {
        return substr(str_shuffle("ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789"), 0, $length);
    }

//mendapatkan data yang dipilih user
function GetDataKriteria($data){
    if($data == 0){
        $Tampil = 'Data Belum Dipilih';
    }elseif($data == 1){
        $Tampil = 'Kurang Penting';
    }elseif($data == 3){
        $Tampil = 'Sedikit Penting';
    }elseif($data==5){
        $Tampil='Cukup Penting';
    }elseif($data==7){
        $Tampil='Lebih Penting';
    }elseif($data==9){
        $Tampil='Mutlak Lebih Penting';
    }else{
        $Tampil = 'Belum Dipilih';
    }
    return $Tampil;

}


function ubahTgl($tanggal){
$pisah = explode('/',$tanggal);
$larik = array($pisah[2],$pisah[0],$pisah[1]);
$satukan = implode($larik);
return $satukan;
}
?>