<?php

include "koneksi.php";

if($_GET['act']=='upload'):
    $tipe =$_FILES['fgambar']['type'];
    if( $tipe != "image/jpg" AND
        $tipe != "image/jpeg" AND
        $tipe != "image/pjpeg" AND
        $tipe != "image/png"
        )

    echo '<p><b>Upload Gagal</b></p>
         <p>Tipe file yang diperbolehkan jpg, jpeg, jpeg atau.</p>
         <p><a href="sellerview.php">ULANGI</p></p>';

    else{
        $file_name  =$_FILES['fgambar']['name'];
        $ukuran     =$_FILES['fgambar']['size'];
        $harga      =$_POST['harga'];
        $category   =$_POST['category'];
        $direktori  =$_POST['direktori'];
        $code       =$_POST['code'];
        $title      =$_POST['title'];
        $deskripsi  =$_POST['deskripsi'];
        $keterangan =$_POST['keterangan'];
        $diskon     =$_POST['diskon'];
        $seller     =$_POST['seller'];
        $date       =$_POST['date'];


        //Cek gambar
        $SQL = mysqli_query($link,"SELECT * FROM product WHERE file_name='$file_name'");
        $qGambar = @mysqli_query($SQL);
        if(count(@mysqli_fetch_array($qGambar)) > 1){
            echo '<p><b>Upload Gagal</b></p>
            <p>Gambar telah tersedia</p>
            <p><a href="location:sellerview.php">KEMBALI</p></p>';
        }else{
            //upload gambar

            move_uploaded_file($_FILES['fgambar']['tmp_name'],$direktori.'/'.$file_name);

            //simpan data gambar
            mysqli_query($link,"INSERT INTO product
                SET file_name   ='$file_name',
                    code        ='$code',
                    harga       ='$harga',
                    ukuran      ='$ukuran',
                    category    ='$category',
                    direktori   ='$direktori',
                    title       ='$title',
                    deskripsi   ='$deskripsi',
                    keterangan  ='$keterangan',
                    diskon      ='$diskon',
                    seller      ='$seller'");
            header('location:sellerview.php');
        }
            echo '<label>Successfully added!!</label>';
    }
endif;

//aksi hapus
if($_GET['act']=='hapus'):
    //pilih gambar
    $id =$_GET['id'];
    $SQL =@mysqli_query($link,"SELECT * FROM product WHERE file_id='$id'");
    $qGambar =@mysqli_query($SQL);
    $row =@mysqli_fetch_array($qGambar);
    //hapus gambar
    if(file_exists($row['direktori'].'/'.$row['file_name']))
        unlink($row['direktori'].'/'.$row['file_name']);

    //hapus data gambar
    @mysqli_query($link,"DELETE FROM product WHERE file_id='$id'");
    header('location:sellerview.php');
endif;

?>