PHP Dosya Yöneticisi

<?php
echo !defined("GUVENLIK") ? exit : NULL;
if ($yetki["demo"] != "1") {
    if (isset($_GET["status"])) {
        if ($_GET["status"] == "product_add" || $_GET["status"] == "product_gallery" || $_GET["status"] == "product_post" || $_GET["status"] == "product_delete" || $_GET["status"] == "multidelete") {
            function productControl($d)
            {
                global $db;
                global $ayar;
                global $row;
                global $Sql;
                $Sql = $db->prepare("select id,baslik,ozellikler,kat_id,gorsel from urun where id=:id ");
                $Sql->execute(["id" => $d]);
                $row = $Sql->fetch(PDO::FETCH_ASSOC);
            }
            if ($_GET["status"] == "multidelete") {
                if ($_POST) {
                    if ($_POST["sil"] <= "0") {
                        $_SESSION["main_alert"] = "nocheck";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=products");
                    } else {
                        $liste = $_POST["sil"];
                        foreach ($liste as $idler) {
                            $sorgu = $db->prepare("select * from urun where id='" . $idler . "' ");
                            $sorgu->execute();
                            if ("0" < $sorgu->rowCount()) {
                                $row = $sorgu->fetch(PDO::FETCH_ASSOC);
                                $silmeislem = $db->prepare("DELETE from detay_varyant WHERE urun_id=:urun_id");
                                $sil = $silmeislem->execute(["urun_id" => $row["id"]]);
                                $silmeislem = $db->prepare("DELETE from detay_varyant_ozellik WHERE urun_id=:urun_id");
                                $sil = $silmeislem->execute(["urun_id" => $row["id"]]);
                                $silmeislem = $db->prepare("DELETE from urun_varyant_ekler WHERE urun_id=:urun_id");
                                $sil = $silmeislem->execute(["urun_id" => $row["id"]]);
                                $silmeislem = $db->prepare("DELETE from urundetay_benzer_urun WHERE detay_id=:detay_id");
                                $sil = $silmeislem->execute(["detay_id" => $row["id"]]);
                                $silmeislem = $db->prepare("DELETE from urun_favori WHERE urun_id=:urun_id");
                                $sil = $silmeislem->execute(["urun_id" => $row["id"]]);
                                $galeriListesi = $db->prepare("select * from urun_galeri where urun_id=:urun_id ");
                                $galeriListesi->execute(["urun_id" => $row["id"]]);
                                if ("0" < $galeriListesi->rowCount()) {
                                    foreach ($galeriListesi as $galerisil) {
                                        unlink("../images/product/" . $galerisil["gorsel"] . "");
                                        $silmeislem = $db->prepare("DELETE from urun_galeri WHERE urun_id=:urun_id");
                                        $sil = $silmeislem->execute(["urun_id" => $row["id"]]);
                                    }
                                }
                                $silmeislem = $db->prepare("DELETE from urun_yorum WHERE urun_id=:urun_id");
                                $sil = $silmeislem->execute(["urun_id" => $row["id"]]);
                                $silmeislem = $db->prepare("DELETE from filtre_ozellik WHERE urun_id=:urun_id");
                                $sil = $silmeislem->execute(["urun_id" => $row["id"]]);
                                $silmeislem = $db->prepare("DELETE from filtre_ozellik_grup WHERE urun_id=:urun_id");
                                $sil = $silmeislem->execute(["urun_id" => $row["id"]]);
                                $silmeislem = $db->prepare("DELETE from vitrin_firsat_urunler WHERE urun_id=:urun_id");
                                $sil = $silmeislem->execute(["urun_id" => $row["id"]]);
                                $silmeislem = $db->prepare("DELETE from vitrin_tip1_urunler WHERE urun_id=:urun_id");
                                $sil = $silmeislem->execute(["urun_id" => $row["id"]]);
                                $silmeislem = $db->prepare("DELETE from urun WHERE id=:id");
                                $sil = $silmeislem->execute(["id" => $row["id"]]);
                                if ($row["gorsel"] && $row["gorsel"] != "no-img.jpg") {
                                    unlink("../images/product/" . $row["gorsel"] . "");
                                    unlink("../images/product/big_photo/" . $row["gorsel"] . "");
                                }
                            }
                        }
                        $_SESSION["main_alert"] = "success";
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=products");
                    }
                } else {
                    $_SESSION["main_alert"] = "nocheck";
                    header("Location:" . $ayar["panel_url"] . "pages.php?page=products");
                }
            }
            if ($_GET["status"] == "product_delete" && isset($_GET["no"]) && "0" < $_GET["no"]) {
                productControl($_GET["no"]);
                if ("0" < $Sql->rowCount()) {
                    $silmeislem = $db->prepare("DELETE from detay_varyant WHERE urun_id=:urun_id");
                    $sil = $silmeislem->execute(["urun_id" => $_GET["no"]]);
                    $silmeislem = $db->prepare("DELETE from detay_varyant_ozellik WHERE urun_id=:urun_id");
                    $sil = $silmeislem->execute(["urun_id" => $_GET["no"]]);
                    $silmeislem = $db->prepare("DELETE from urun_varyant_ekler WHERE urun_id=:urun_id");
                    $sil = $silmeislem->execute(["urun_id" => $_GET["no"]]);
                    $silmeislem = $db->prepare("DELETE from urundetay_benzer_urun WHERE detay_id=:detay_id");
                    $sil = $silmeislem->execute(["detay_id" => $_GET["no"]]);
                    $silmeislem = $db->prepare("DELETE from urun_favori WHERE urun_id=:urun_id");
                    $sil = $silmeislem->execute(["urun_id" => $_GET["no"]]);
                    $galeriListesi = $db->prepare("select * from urun_galeri where urun_id=:urun_id ");
                    $galeriListesi->execute(["urun_id" => $_GET["no"]]);
                    if ("0" < $galeriListesi->rowCount()) {
                        foreach ($galeriListesi as $galerisil) {
                            unlink("../images/product/" . $galerisil["gorsel"] . "");
                            $silmeislem = $db->prepare("DELETE from urun_galeri WHERE urun_id=:urun_id");
                            $sil = $silmeislem->execute(["urun_id" => $_GET["no"]]);
                        }
                    }
                    $silmeislem = $db->prepare("DELETE from urun_yorum WHERE urun_id=:urun_id");
                    $sil = $silmeislem->execute(["urun_id" => $_GET["no"]]);
                    $silmeislem = $db->prepare("DELETE from filtre_ozellik WHERE urun_id=:urun_id");
                    $sil = $silmeislem->execute(["urun_id" => $_GET["no"]]);
                    $silmeislem = $db->prepare("DELETE from filtre_ozellik_grup WHERE urun_id=:urun_id");
                    $sil = $silmeislem->execute(["urun_id" => $_GET["no"]]);
                    $silmeislem = $db->prepare("DELETE from vitrin_firsat_urunler WHERE urun_id=:urun_id");
                    $sil = $silmeislem->execute(["urun_id" => $_GET["no"]]);
                    $silmeislem = $db->prepare("DELETE from vitrin_tip1_urunler WHERE urun_id=:urun_id");
                    $sil = $silmeislem->execute(["urun_id" => $_GET["no"]]);
                    $silmeislem = $db->prepare("DELETE from urun WHERE id=:id");
                    $sil = $silmeislem->execute(["id" => $_GET["no"]]);
                    if ($sil) {
                        if ($row["gorsel"] && $row["gorsel"] != "no-img.jpg") {
                            unlink("../images/product/" . $row["gorsel"] . "");
                            unlink("../images/product/big_photo/" . $row["gorsel"] . "");
                        }
                        header("Location:" . $ayar["panel_url"] . "pages.php?page=products&status=newproductgo");
                        $_SESSION["main_alert"] = "success";
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "product_add") {
                if ($_POST && isset($_POST["insert"])) {
                    if ($_POST["durum"] == "1" || $_POST["durum"] == "0") {
                        if ($_POST["gorunmez"] == "0" || $_POST["gorunmez"] == "1") {
                            if ($_POST["baslik"] && $_POST["stok"]) {
                                $urunKutuAyar = $db->prepare("select resim_w,resim_h,resim_big_w,resim_big_h from urun_kutu where id='1' ");
                                $urunKutuAyar->execute();
                                $urunboxRow = $urunKutuAyar->fetch(PDO::FETCH_ASSOC);
                                $resim_w = $urunboxRow["resim_w"];
                                $resim_h = $urunboxRow["resim_h"];
                                $resim_big_w = $urunboxRow["resim_big_w"];
                                $resim_big_h = $urunboxRow["resim_big_h"];
                                if ($_POST["urun_kod"]) {
                                    $stok_kod = $_POST["urun_kod"];
                                } else {
                                    function get_random_string($length = 7, $characters = "ABCDEFGHIJKLMNOPRQSTUVWXYZ0123456789")
                                    {
                                        $return = "";
                                        $num_characters = strlen($characters) - 1;
                                        while (strlen($return) < $length) {
                                            $return .= $characters[mt_rand(0, $num_characters)];
                                        }
                                        return $return;
                                    }
                                    $stok_kod = get_random_string();
                                }
                                if ($_POST["seo_url"]) {
                                    $seo_url = $_POST["seo_url"];
                                } else {
                                    $seo_url = seo($_POST["baslik"]);
                                }
                                $sadetarih = date("Y-m-d");
                                $tarih = date("Y-m-d G:i:s");
                                $ekleyen = $adminRow["user_adi"];
                                if (0 < $_FILES["gorsel"]["size"]) {
                                    $file_format = $_FILES["gorsel"];
                                    if ($file_format["type"] == "image/jpeg" || $file_format["type"] == "image/jpg" || $file_format["type"] == "image/png" || $file_format["type"] == "image/webp" || $file_format["type"] == "image/jxr" || $file_format["type"] == "image/jp2" || $file_format["type"] == "image/bmp") {
                                        include_once "inc/class.upload.php";
                                        $upload = new Verot\Upload\Upload($_FILES["gorsel"]);
                                        if ($upload->uploaded) {
                                            $random = rand(0, (int) 0);
                                            $random2 = rand(0, (int) 999);
                                            $upload->file_name_body_pre = "product_";
                                            $upload->file_name_body_add = "" . $random . "" . $random2 . "";
                                            $upload->image_resize = true;
                                            $upload->png_quality = 90;
                                            $upload->webp_quality = 92;
                                            $upload->jpeg_quality = 92;
                                            $upload->png_compression = 9;
                                            $upload->image_x = $resim_big_w;
                                            $upload->image_y = $resim_big_h;
                                            $upload->process("../images/product/big_photo");
                                            $upload->file_name_body_pre = "product_";
                                            $upload->file_name_body_add = "" . $random . "" . $random2 . "";
                                            $upload->image_resize = true;
                                            $upload->image_ratio_crop = true;
                                            $upload->png_quality = 90;
                                            $upload->webp_quality = 92;
                                            $upload->jpeg_quality = 92;
                                            $upload->png_compression = 9;
                                            $upload->image_ratio_fill = "C";
                                            $upload->image_x = $resim_w;
                                            $upload->image_y = $resim_h;
                                            $upload->process("../images/product");
                                        }
                                        if ($upload->processed) {
                                            $file_name = $upload->file_dst_name;
                                            $kaydet = $db->prepare("INSERT INTO urun SET\r\n                                             baslik=:baslik,    \r\n                                             ekleyen=:ekleyen,\r\n                                             sade_tarih=:sade_tarih,   \r\n                                             fiyat=:fiyat,\r\n                                             eski_fiyat=:eski_fiyat,\r\n                                             alis_fiyat=:alis_fiyat,\r\n                                             fiyat_tip2=:fiyat_tip2,\r\n                                             havale_indirim_tutar=:havale_indirim_tutar,\r\n                                             kargo_ucret=:kargo_ucret,\r\n                                             marka=:marka, \r\n                                             tarih=:tarih, \r\n                                             fiyat_goster=:fiyat_goster,\r\n                                             seo_url=:seo_url,\r\n                                             seo_baslik=:seo_baslik,\r\n                                             gorsel=:gorsel,\r\n                                             stok=:stok,\r\n                                             urun_kod=:urun_kod,\r\n                                             durum=:durum,\r\n                                             dil=:dil,\r\n                                             gorunmez=:gorunmez\r\n                                          ");
                                            $sonuc = $kaydet->execute(["baslik" => $_POST["baslik"], "ekleyen" => $ekleyen, "sade_tarih" => $sadetarih, "fiyat" => "0", "eski_fiyat" => "0", "alis_fiyat" => "0", "fiyat_tip2" => "0", "havale_indirim_tutar" => "0", "kargo_ucret" => "0", "marka" => NULL, "tarih" => $tarih, "fiyat_goster" => "1", "seo_url" => $seo_url, "seo_baslik" => $_POST["baslik"], "gorsel" => $file_name, "stok" => $_POST["stok"], "urun_kod" => $stok_kod, "durum" => $_POST["durum"], "dil" => $_SESSION["dil"], "gorunmez" => $_POST["gorunmez"]]);
                                            if ($sonuc) {
                                                header("Location:" . $ayar["panel_url"] . "pages.php?page=products&status=newproductgo");
                                                $_SESSION["main_alert"] = "success_product";
                                            } else {
                                                echo "Veritabanı Hatası";
                                            }
                                        } else {
                                            header("Location:" . $ayar["panel_url"] . "pages.php?page=products");
                                            $_SESSION["main_alert"] = "filetype";
                                            exit;
                                        }
                                    } else {
                                        header("Location:" . $ayar["panel_url"] . "pages.php?page=products");
                                        $_SESSION["collepse_status"] = "genelAcc";
                                        $_SESSION["main_alert"] = "filetype";
                                    }
                                } else {
                                    $kaydet = $db->prepare("INSERT INTO urun SET\r\n                                     baslik=:baslik,  \r\n                                     ekleyen=:ekleyen,\r\n                                     sade_tarih=:sade_tarih,   \r\n                                     tarih=:tarih,\r\n                                     seo_url=:seo_url,\r\n                                     seo_baslik=:seo_baslik,\r\n                                     gorsel=:gorsel,\r\n                                     stok=:stok,\r\n                                     urun_kod=:urun_kod,\r\n                                     durum=:durum,\r\n                                     dil=:dil,\r\n                                     gorunmez=:gorunmez\r\n                                  ");
                                    $sonuc = $kaydet->execute(["baslik" => $_POST["baslik"], "ekleyen" => $ekleyen, "sade_tarih" => $sadetarih, "tarih" => $tarih, "seo_url" => $seo_url, "seo_baslik" => $_POST["baslik"], "gorsel" => "no-img.jpg", "stok" => $_POST["stok"], "urun_kod" => $stok_kod, "durum" => $_POST["durum"], "dil" => $_SESSION["dil"], "gorunmez" => $_POST["gorunmez"]]);
                                    if ($sonuc) {
                                        header("Location:" . $ayar["panel_url"] . "pages.php?page=products&status=newproductgo");
                                        $_SESSION["main_alert"] = "success_product";
                                    } else {
                                        echo "Veritabanı Hatası";
                                    }
                                }
                            } else {
                                $_SESSION["main_alert"] = "zorunlu";
                                header("Location:" . $ayar["panel_url"] . "pages.php?page=products");
                            }
                        } else {
                            header("Location:" . $ayar["site_url"] . "404");
                        }
                    } else {
                        header("Location:" . $ayar["site_url"] . "404");
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
            if ($_GET["status"] == "product_gallery") {
                $folder_name = "../images/product/";
                $random = rand(0, (int) 99999);
                $random2 = rand(0, (int) 999);
                $filename = trim(addslashes($_FILES["file"]["name"]));
                $filename = str_replace(" ", "_", $filename);
                $filename = str_replace("ş", "s", $filename);
                $filename = str_replace("&", "-", $filename);
                $filename = str_replace("%", "-", $filename);
                $filename = str_replace("?", "-", $filename);
                $filename = str_replace("+", "-", $filename);
                $filename = str_replace("ı", "i", $filename);
                $filename = str_replace("Ş", "s", $filename);
                $filename = str_replace("ğ", "g", $filename);
                $filename = str_replace("Ğ", "g", $filename);
                $filename = str_replace("ü", "u", $filename);
                $filename = str_replace("Ü", "u", $filename);
                $filename = str_replace("ç", "c", $filename);
                $filename = str_replace("Ç", "c", $filename);
                $filename = str_replace("ö", "o", $filename);
                $filename = str_replace("Ö", "o", $filename);
                $filename = str_replace("İ", "i", $filename);
                $filename = preg_replace("/\\s+/", "_", $filename);
                $file_name = $random . "-" . $random2 . "-" . $filename;
                $temp_file = $_FILES["file"]["tmp_name"];
                move_uploaded_file($temp_file, $folder_name . $file_name);
                $kaydet = $db->prepare("INSERT INTO urun_galeri SET\r\n                      gorsel=:gorsel,\r\n                      urun_id=:urun_id\r\n                      ");
                $ekle = $kaydet->execute(["gorsel" => $file_name, "urun_id" => $_GET["productID"]]);
            }
            if ($_GET["status"] == "product_post" && isset($_POST["tab"])) {
                if ($_POST["tab"] == "product_info" || $_POST["tab"] == "product_price" || $_POST["tab"] == "variant_stock_add" || $_POST["tab"] == "variant_stock_edit" || $_POST["tab"] == "description" || $_POST["tab"] == "variant" || $_POST["tab"] == "variant_edit" || $_POST["tab"] == "features" || $_POST["tab"] == "extra" || $_POST["tab"] == "meta" || $_POST["tab"] == "other") {
                    if ($_POST["product_id"]) {
                        if ($_POST["tab"] == "variant_stock_edit" && isset($_POST["stockEdit"])) {
                            if ($_POST["stok_kodu"] && $_POST["stock_id"]) {
                                $guncelle = $db->prepare("UPDATE detay_varyant_stok SET\r\n                                            stok_kodu=:stok_kodu,\r\n                                            stok=:stok\r\n                                     WHERE id=" . $_POST["stock_id"] . "      \r\n                                    ");
                                $sonuc = $guncelle->execute(["stok_kodu" => $_POST["stok_kodu"], "stok" => $_POST["stok"]]);
                                if ($sonuc) {
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_variant&productID=" . $_POST["product_id"] . "");
                                    $_SESSION["main_alert"] = "success";
                                    $_SESSION["collepse_status"] = "stokAcc";
                                } else {
                                    echo "Veritabanı Hatası";
                                }
                            } else {
                                header("Location:" . $ayar["site_url"] . "404");
                            }
                        }
                        if ($_POST["tab"] == "variant_stock_add" && isset($_POST["stockAdd"])) {
                            if ($_POST["gruplar"] && $_POST["stok_adet"] && $_POST["stok_name"]) {
                                foreach ($_POST["gruplar"] as $var) {
                                    if ($var != "") {
                                        $varyantlar .= "" . $var . ",";
                                    }
                                }
                                $varyantKontrol = $db->prepare("select * from detay_varyant_stok where varyant=:varyant ");
                                $varyantKontrol->execute(["varyant" => $varyantlar]);
                                if ("0" < $varyantKontrol->rowCount()) {
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_variant&productID=" . $_POST["product_id"] . "");
                                    $_SESSION["main_alert"] = "varyant_stok_var";
                                    $_SESSION["collepse_status"] = "stokAcc";
                                    exit;
                                }
                                $kaydet = $db->prepare("INSERT INTO detay_varyant_stok SET\r\n                                          varyant=:varyant, \r\n                                          urun_id=:urun_id,\r\n                                          stok=:stok,\r\n                                          stok_kodu=:stok_kodu\r\n                                   ");
                                $sonuc = $kaydet->execute(["varyant" => $varyantlar, "urun_id" => $_POST["product_id"], "stok" => $_POST["stok_adet"], "stok_kodu" => $_POST["stok_name"]]);
                                if ($sonuc) {
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_variant&productID=" . $_POST["product_id"] . "");
                                    $_SESSION["main_alert"] = "success";
                                    $_SESSION["collepse_status"] = "stokAcc";
                                } else {
                                    echo "Veritabanı Hatası";
                                }
                            } else {
                                header("Location:" . $ayar["site_url"] . "404");
                            }
                        }
                        if ($_POST["tab"] == "variant_edit" && isset($_POST["variantID_update"])) {
                            if ($_POST["variant_id"] && $_POST["group_id"] && $_POST["grup_tur"]) {
                                if ($_POST["grup_tur"] == "2") {
                                    $guncelle = $db->prepare("UPDATE detay_varyant SET\r\n                                                zorunlu=:zorunlu\r\n                                         WHERE id=" . $_POST["group_id"] . "      \r\n                                        ");
                                    $sonuc = $guncelle->execute(["zorunlu" => $_POST["zorunlu"]]);
                                }
                                if ($_POST["grup_tur"] == "4") {
                                    $guncelle = $db->prepare("UPDATE detay_varyant SET\r\n                                                zorunlu=:zorunlu\r\n                                         WHERE id=" . $_POST["group_id"] . "      \r\n                                        ");
                                    $sonuc = $guncelle->execute(["zorunlu" => $_POST["zorunlu"]]);
                                }
                                if ($_POST["grup_tur"] == "3") {
                                    $old_img = $_POST["old_img"];
                                    if (0 < $_FILES["gorsel"]["size"]) {
                                        $file_format = $_FILES["gorsel"];
                                        if ($file_format["type"] == "image/jpeg" || $file_format["type"] == "image/jpg" || $file_format["type"] == "image/png" || $file_format["type"] == "image/webp" || $file_format["type"] == "image/jxr" || $file_format["type"] == "image/jp2" || $file_format["type"] == "image/bmp") {
                                            include_once "inc/class.upload.php";
                                            $upload = new Verot\Upload\Upload($_FILES["gorsel"]);
                                            if ($upload->uploaded) {
                                                $random = rand(0, (int) 0);
                                                $random2 = rand(0, (int) 999);
                                                $upload->file_name_body_pre = "variant_";
                                                $upload->file_name_body_add = "" . $random . "" . $random2 . "";
                                                $upload->image_resize = true;
                                                $upload->png_quality = 90;
                                                $upload->webp_quality = 92;
                                                $upload->jpeg_quality = 92;
                                                $upload->png_compression = 9;
                                                if ($_POST["gorsel_w"] && $_POST["gorsel_h"]) {
                                                    $upload->image_x = $_POST["gorsel_w"];
                                                    $upload->image_y = $_POST["gorsel_h"];
                                                } else {
                                                    $upload->image_x = 50;
                                                    $upload->image_y = 50;
                                                }
                                                $upload->process("../i/variants");
                                            }
                                            if ($upload->processed) {
                                                $file_name = $upload->file_dst_name;
                                                unlink("../i/variants/" . $old_img . "");
                                                $gorsel = $file_name;
                                            } else {
                                                header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_variant&productID=" . $_POST["product_id"] . "");
                                                $_SESSION["main_alert"] = "filetype";
                                                exit;
                                            }
                                        } else {
                                            header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_variant&productID=" . $_POST["product_id"] . "");
                                            $_SESSION["main_alert"] = "filetype";
                                            exit;
                                        }
                                    } else {
                                        $gorsel = $old_img;
                                    }
                                } else {
                                    $gorsel = NULL;
                                }
                                if ($_POST["ek_fiyat"]) {
                                    $ekfiyat = $_POST["ek_fiyat"];
                                } else {
                                    $ekfiyat = "0";
                                }
                                $guncelle = $db->prepare("UPDATE detay_varyant_ozellik SET\r\n                                            ek_fiyat=:ek_fiyat,\r\n                                            fiyat_goster=:fiyat_goster,\r\n                                            gorsel=:gorsel,\r\n                                            disable=:disable,\r\n                                            disable_t=:disable_t,\r\n                                            tarih_bugun=:tarih_bugun,\r\n                                            tarih_yil=:tarih_yil,\r\n                                            gorsel_w=:gorsel_w,\r\n                                            gorsel_h=:gorsel_h\r\n                                     WHERE id=" . $_POST["variant_id"] . "      \r\n                                    ");
                                $sonuc = $guncelle->execute(["ek_fiyat" => $ekfiyat, "fiyat_goster" => $_POST["fiyat_goster"], "gorsel" => $gorsel, "disable" => $_POST["disable"], "disable_t" => $_POST["disable_t"], "tarih_bugun" => $_POST["tarih_bugun"], "tarih_yil" => $_POST["tarih_yil"], "gorsel_w" => $_POST["gorsel_w"], "gorsel_h" => $_POST["gorsel_h"]]);
                                if ($sonuc) {
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_variant&productID=" . $_POST["product_id"] . "");
                                    $_SESSION["main_alert"] = "success";
                                } else {
                                    echo "Veritabanı Hatası";
                                }
                            } else {
                                header("Location:" . $ayar["site_url"] . "404");
                            }
                        }
                        if ($_POST["tab"] == "variant" && isset($_POST["variant_add"])) {
                            productControl($_POST["product_id"]);
                            if ("0" < $Sql->rowCount() && $_POST["varyant_grup"] && $_POST["variant_id"]) {
                                if ($_POST["ekli_tur"] == "2") {
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_variant&productID=" . $_POST["product_id"] . "");
                                    $_SESSION["main_alert"] = "variant_tur_2";
                                    exit;
                                }
                                if ($_POST["tur"] == "1" || $_POST["tur"] == "2" || $_POST["tur"] == "3" || $_POST["tur"] == "4") {
                                    $VariantSql = $db->prepare("select * from urun_varyant where id=:id ");
                                    $VariantSql->execute(["id" => $_POST["varyant_grup"]]);
                                    $varsqlRow = $VariantSql->fetch(PDO::FETCH_ASSOC);
                                    if ("0" < $VariantSql->rowCount()) {
                                        $varmikontrol = $db->prepare("select * from detay_varyant where urun_id=:urun_id and varyant_id=:varyant_id ");
                                        $varmikontrol->execute(["urun_id" => $_POST["product_id"], "varyant_id" => $_POST["varyant_grup"]]);
                                        if ($varmikontrol->rowCount() <= "0") {
                                            if ($_POST["tur"] == "3") {
                                                if (0 < $_FILES["gorsel"]["size"]) {
                                                    $file_format = $_FILES["gorsel"];
                                                    if ($file_format["type"] == "image/jpeg" || $file_format["type"] == "image/jpg" || $file_format["type"] == "image/png" || $file_format["type"] == "image/webp" || $file_format["type"] == "image/jxr" || $file_format["type"] == "image/jp2" || $file_format["type"] == "image/bmp") {
                                                        include_once "inc/class.upload.php";
                                                        $upload = new Verot\Upload\Upload($_FILES["gorsel"]);
                                                        if ($upload->uploaded) {
                                                            $random = rand(0, (int) 0);
                                                            $random2 = rand(0, (int) 999);
                                                            $upload->file_name_body_pre = "variant_";
                                                            $upload->file_name_body_add = "" . $random . "" . $random2 . "";
                                                            $upload->image_resize = true;
                                                            $upload->png_quality = 90;
                                                            $upload->webp_quality = 92;
                                                            $upload->jpeg_quality = 92;
                                                            $upload->png_compression = 9;
                                                            if ($_POST["gorsel_w"] && $_POST["gorsel_h"]) {
                                                                $upload->image_x = $_POST["gorsel_w"];
                                                                $upload->image_y = $_POST["gorsel_h"];
                                                            } else {
                                                                $upload->image_x = 50;
                                                                $upload->image_y = 50;
                                                            }
                                                            $upload->process("../i/variants");
                                                        }
                                                        if ($upload->processed) {
                                                            $file_name = $upload->file_dst_name;
                                                            $gorsel = $file_name;
                                                        } else {
                                                            header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_variant&productID=" . $_POST["product_id"] . "");
                                                            $_SESSION["main_alert"] = "filetype";
                                                            exit;
                                                        }
                                                    } else {
                                                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_variant&productID=" . $_POST["product_id"] . "");
                                                        $_SESSION["main_alert"] = "filetype";
                                                        exit;
                                                    }
                                                } else {
                                                    $gorsel = NULL;
                                                }
                                            } else {
                                                $gorsel = NULL;
                                            }
                                            if ($_POST["tur"] == "4") {
                                                $zorunluDurum = $_POST["zorunlu_tur4"];
                                            } else {
                                                $zorunluDurum = $_POST["zorunlu"];
                                            }
                                            $kaydet = $db->prepare("INSERT INTO detay_varyant SET\r\n                                                    baslik=:baslik,\r\n                                                    urun_id=:urun_id,\r\n                                                    varyant_id=:varyant_id,\r\n                                                    sira=:sira,\r\n                                                    tur=:tur,\r\n                                                    zorunlu=:zorunlu\r\n                                            ");
                                            $sonuc = $kaydet->execute(["baslik" => $varsqlRow["baslik"], "urun_id" => $_POST["product_id"], "varyant_id" => $_POST["varyant_grup"], "sira" => $varsqlRow["sira"], "tur" => $_POST["tur"], "zorunlu" => $zorunluDurum]);
                                            $degerSql = $db->prepare("select * from urun_varyant_ozellik where id=:id ");
                                            $degerSql->execute(["id" => $_POST["variant_id"]]);
                                            $ozRow = $degerSql->fetch(PDO::FETCH_ASSOC);
                                            if ($_POST["ek_fiyat"]) {
                                                $ekfiyat = $_POST["ek_fiyat"];
                                            } else {
                                                $ekfiyat = "0";
                                            }
                                            $kaydet = $db->prepare("INSERT INTO detay_varyant_ozellik SET\r\n                                                        baslik=:baslik,\r\n                                                        ozellik_id=:ozellik_id,\r\n                                                        urun_id=:urun_id,\r\n                                                        varyant_id=:varyant_id,\r\n                                                        ek_fiyat=:ek_fiyat,\r\n                                                        fiyat_goster=:fiyat_goster,\r\n                                                        tarih_bugun=:tarih_bugun,\r\n                                                        tarih_yil=:tarih_yil,\r\n                                                        gorsel=:gorsel,\r\n                                                        gorsel_w=:gorsel_w,\r\n                                                        gorsel_h=:gorsel_h\r\n                                                ");
                                            $sonuc = $kaydet->execute(["baslik" => $ozRow["baslik"], "ozellik_id" => $_POST["variant_id"], "urun_id" => $_POST["product_id"], "varyant_id" => $_POST["varyant_grup"], "ek_fiyat" => $ekfiyat, "fiyat_goster" => $_POST["fiyat_goster"], "tarih_bugun" => $_POST["tarih_bugun"], "tarih_yil" => $_POST["tarih_yil"], "gorsel" => $gorsel, "gorsel_w" => $_POST["gorsel_w"], "gorsel_h" => $_POST["gorsel_h"]]);
                                            if ($sonuc) {
                                                $_SESSION["collepse_status"] = "go_scroll";
                                                header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_variant&productID=" . $_POST["product_id"] . "");
                                            } else {
                                                echo "Veritabanı Hatası";
                                            }
                                        } else {
                                            $degerVarmiKontrol = $db->prepare("select * from detay_varyant_ozellik where urun_id=:urun_id and ozellik_id=:ozellik_id ");
                                            $degerVarmiKontrol->execute(["urun_id" => $_POST["product_id"], "ozellik_id" => $_POST["variant_id"]]);
                                            if ($degerVarmiKontrol->rowCount() <= "0") {
                                                if ($_POST["tur"] == "3") {
                                                    if (0 < $_FILES["gorsel"]["size"]) {
                                                        $file_format = $_FILES["gorsel"];
                                                        if ($file_format["type"] == "image/jpeg" || $file_format["type"] == "image/jpg" || $file_format["type"] == "image/png" || $file_format["type"] == "image/webp" || $file_format["type"] == "image/jxr" || $file_format["type"] == "image/jp2" || $file_format["type"] == "image/bmp") {
                                                            include_once "inc/class.upload.php";
                                                            $upload = new Verot\Upload\Upload($_FILES["gorsel"]);
                                                            if ($upload->uploaded) {
                                                                $random = rand(0, (int) 0);
                                                                $random2 = rand(0, (int) 999);
                                                                $upload->file_name_body_pre = "variant_";
                                                                $upload->file_name_body_add = "" . $random . "" . $random2 . "";
                                                                $upload->image_resize = true;
                                                                $upload->png_quality = 90;
                                                                $upload->webp_quality = 92;
                                                                $upload->jpeg_quality = 92;
                                                                $upload->png_compression = 9;
                                                                if ($_POST["gorsel_w"] && $_POST["gorsel_h"]) {
                                                                    $upload->image_x = $_POST["gorsel_w"];
                                                                    $upload->image_y = $_POST["gorsel_h"];
                                                                } else {
                                                                    $upload->image_x = 50;
                                                                    $upload->image_y = 50;
                                                                }
                                                                $upload->process("../i/variants");
                                                            }
                                                            if ($upload->processed) {
                                                                $file_name = $upload->file_dst_name;
                                                                $gorsel = $file_name;
                                                            } else {
                                                                header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_variant&productID=" . $_POST["product_id"] . "");
                                                                $_SESSION["main_alert"] = "filetype";
                                                                exit;
                                                            }
                                                        } else {
                                                            header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_variant&productID=" . $_POST["product_id"] . "");
                                                            $_SESSION["main_alert"] = "filetype";
                                                            exit;
                                                        }
                                                    } else {
                                                        $gorsel = NULL;
                                                    }
                                                } else {
                                                    $gorsel = NULL;
                                                }
                                                if ($_POST["tur"] == "2") {
                                                    echo "Bu varyant grubuna Yazı alanı varyant değeri sadece tek sefer eklenebilir. Yeni yazı alanları için lütfen varyant ekleme merkezinden yeni varyant ve değer oluşturup ekleme yapınız<br>";
                                                } else {
                                                    echo "bu varyant değeri mevcut varyant içine eklenebilir";
                                                    if ($_POST["tur"] != "3") {
                                                        $gorsel = NULL;
                                                    }
                                                    $degerSql = $db->prepare("select * from urun_varyant_ozellik where id=:id ");
                                                    $degerSql->execute(["id" => $_POST["variant_id"]]);
                                                    $ozRow = $degerSql->fetch(PDO::FETCH_ASSOC);
                                                    if ($_POST["ek_fiyat"]) {
                                                        $ekfiyat = $_POST["ek_fiyat"];
                                                    } else {
                                                        $ekfiyat = "0";
                                                    }
                                                    $kaydet = $db->prepare("INSERT INTO detay_varyant_ozellik SET\r\n                                                        baslik=:baslik,\r\n                                                        ozellik_id=:ozellik_id,\r\n                                                        urun_id=:urun_id,\r\n                                                        varyant_id=:varyant_id,\r\n                                                        ek_fiyat=:ek_fiyat,\r\n                                                        fiyat_goster=:fiyat_goster,\r\n                                                        gorsel=:gorsel,\r\n                                                        gorsel_w=:gorsel_w,\r\n                                                        gorsel_h=:gorsel_h\r\n                                                ");
                                                    $sonuc = $kaydet->execute(["baslik" => $ozRow["baslik"], "ozellik_id" => $_POST["variant_id"], "urun_id" => $_POST["product_id"], "varyant_id" => $_POST["varyant_grup"], "ek_fiyat" => $ekfiyat, "fiyat_goster" => $_POST["fiyat_goster"], "gorsel" => $gorsel, "gorsel_w" => $_POST["gorsel_w"], "gorsel_h" => $_POST["gorsel_h"]]);
                                                    if ($sonuc) {
                                                        $_SESSION["collepse_status"] = "go_scroll";
                                                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_variant&productID=" . $_POST["product_id"] . "");
                                                    } else {
                                                        echo "Veritabanı Hatası";
                                                    }
                                                }
                                            } else {
                                                $_SESSION["main_alert"] = "varyant_var";
                                                header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_variant&productID=" . $_POST["product_id"] . "");
                                            }
                                        }
                                    } else {
                                        header("Location:" . $ayar["site_url"] . "404");
                                    }
                                } else {
                                    header("Location:" . $ayar["site_url"] . "404");
                                }
                            } else {
                                header("Location:" . $ayar["site_url"] . "404");
                            }
                        }
                        if ($_POST["tab"] == "features" && isset($_POST["features_add"])) {
                            productControl($_POST["product_id"]);
                            if ("0" < $Sql->rowCount() && $_POST["categories_id"] && $_POST["kontrol"] && $_POST["feature_id"]) {
                                $kategoriler = $_POST["categories_id"];
                                $grup_id = $_POST["kontrol"];
                                $kontrol = $_POST["kontrol"];
                                $ozellikID = $_POST["feature_id"];
                                $ozellikRandomID = rand(0, (int) 9999999);
                                $random = rand(0, (int) 9999999);
                                $filtreGrubuVarmi = $db->prepare("select * from filtre_ozellik_grup where urun_id=:urun_id and kontrol=:kontrol ");
                                $filtreGrubuVarmi->execute(["urun_id" => $_POST["product_id"], "kontrol" => $kontrol]);
                                if ("0" < $filtreGrubuVarmi->rowCount()) {
                                    $filtreOzellikVarmi = $db->prepare("select * from filtre_ozellik where urun_id=:urun_id and ozellik_id=:ozellik_id ");
                                    $filtreOzellikVarmi->execute(["urun_id" => $_POST["product_id"], "ozellik_id" => $ozellikID]);
                                    if ($filtreOzellikVarmi->rowCount() <= "0") {
                                        $RealGroup = $db->prepare("select * from urun_ozellik_grup where id=:id ");
                                        $RealGroup->execute(["id" => $kontrol]);
                                        $realGroupRow = $RealGroup->fetch(PDO::FETCH_ASSOC);
                                        $RealFeatures = $db->prepare("select * from urun_ozellik where id=:id ");
                                        $RealFeatures->execute(["id" => $ozellikID]);
                                        $realFeatRow = $RealFeatures->fetch(PDO::FETCH_ASSOC);
                                        $urunOzellikKaydi = $ozellikID . ",";
                                        $newFeaturesIDS = $row["ozellikler"];
                                        $eski = "" . $row["ozellikler"] . "";
                                        $yeni = "" . $urunOzellikKaydi . "" . $row["ozellikler"] . "";
                                        $newFeaturesIDS = str_replace($eski, $yeni, $newFeaturesIDS);
                                        if ($row["ozellikler"]) {
                                            $featuresGoIDS = $newFeaturesIDS;
                                        } else {
                                            $featuresGoIDS = $urunOzellikKaydi;
                                        }
                                        $guncelle = $db->prepare("UPDATE urun SET\r\n                                            ozellikler=:ozellikler\r\n                                     WHERE id=" . $_POST["product_id"] . "      \r\n                                    ");
                                        $sonuc = $guncelle->execute(["ozellikler" => $featuresGoIDS]);
                                        $GrupAdi = $realGroupRow["baslik"];
                                        $GrupSira = $realGroupRow["sira"];
                                        $OzellikAdi = $realFeatRow["baslik"];
                                        $OzellikSira = $realFeatRow["sira"];
                                        if ($_POST["kisa_baslik"]) {
                                            $filtreAdi = $_POST["kisa_baslik"];
                                        } else {
                                            $filtreAdi = $OzellikAdi;
                                        }
                                        $kaydet = $db->prepare("INSERT INTO filtre_ozellik_grup SET\r\n                                                urun_id=:urun_id,    \r\n                                                baslik=:baslik,\r\n                                                real_grup_id=:real_grup_id,\r\n                                                kat_id=:kat_id,\r\n                                                durum=:durum,\r\n                                                dil=:dil,\r\n                                                random=:random,\r\n                                                sira=:sira,\r\n                                                kontrol=:kontrol\r\n                                    ");
                                        $sonuc = $kaydet->execute(["urun_id" => $_POST["product_id"], "baslik" => $GrupAdi, "real_grup_id" => $grup_id, "kat_id" => $kategoriler, "durum" => "1", "dil" => $_SESSION["dil"], "random" => $random, "sira" => $GrupSira, "kontrol" => $kontrol]);
                                        $kaydet = $db->prepare("INSERT INTO filtre_ozellik SET\r\n                                                baslik=:baslik,\r\n                                                kisa_baslik=:kisa_baslik,\r\n                                                grup_id=:grup_id,\r\n                                                ozellik_id=:ozellik_id,\r\n                                                urun_id=:urun_id,\r\n                                                sira=:sira,\r\n                                                random=:random,\r\n                                                kat_id=:kat_id,\r\n                                                filtre=:filtre,\r\n                                                kontrol=:kontrol\r\n                                    ");
                                        $sonuc = $kaydet->execute(["baslik" => $OzellikAdi, "kisa_baslik" => $filtreAdi, "grup_id" => $grup_id, "ozellik_id" => $ozellikID, "urun_id" => $_POST["product_id"], "sira" => $OzellikSira, "random" => $random, "kat_id" => $kategoriler, "filtre" => $_POST["filtre"], "kontrol" => $kontrol]);
                                        $_SESSION["collepse_status"] = "go_scroll";
                                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_features&productID=" . $_POST["product_id"] . "");
                                    } else {
                                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_features&productID=" . $_POST["product_id"] . "");
                                        $_SESSION["main_alert"] = "filtreden_var";
                                    }
                                } else {
                                    echo "Bu gruptan yok! Direkt ekleyebilirsin.";
                                    $RealGroup = $db->prepare("select * from urun_ozellik_grup where id=:id ");
                                    $RealGroup->execute(["id" => $kontrol]);
                                    $realGroupRow = $RealGroup->fetch(PDO::FETCH_ASSOC);
                                    $RealFeatures = $db->prepare("select * from urun_ozellik where id=:id ");
                                    $RealFeatures->execute(["id" => $ozellikID]);
                                    $realFeatRow = $RealFeatures->fetch(PDO::FETCH_ASSOC);
                                    $urunOzellikKaydi = $ozellikID . ",";
                                    $newFeaturesIDS = $row["ozellikler"];
                                    $eski = "" . $row["ozellikler"] . "";
                                    $yeni = "" . $urunOzellikKaydi . "" . $row["ozellikler"] . "";
                                    $newFeaturesIDS = str_replace($eski, $yeni, $newFeaturesIDS);
                                    if ($row["ozellikler"]) {
                                        $featuresGoIDS = $newFeaturesIDS;
                                    } else {
                                        $featuresGoIDS = $urunOzellikKaydi;
                                    }
                                    $guncelle = $db->prepare("UPDATE urun SET\r\n                                            ozellikler=:ozellikler\r\n                                     WHERE id=" . $_POST["product_id"] . "      \r\n                                    ");
                                    $sonuc = $guncelle->execute(["ozellikler" => $featuresGoIDS]);
                                    $GrupAdi = $realGroupRow["baslik"];
                                    $GrupSira = $realGroupRow["sira"];
                                    $OzellikAdi = $realFeatRow["baslik"];
                                    $OzellikSira = $realFeatRow["sira"];
                                    if ($_POST["kisa_baslik"]) {
                                        $filtreAdi = $_POST["kisa_baslik"];
                                    } else {
                                        $filtreAdi = $OzellikAdi;
                                    }
                                    $kaydet = $db->prepare("INSERT INTO filtre_ozellik_grup SET\r\n                                        urun_id=:urun_id,    \r\n                                        baslik=:baslik,\r\n                                        real_grup_id=:real_grup_id,\r\n                                        kat_id=:kat_id,\r\n                                        durum=:durum,\r\n                                        dil=:dil,\r\n                                        random=:random, \r\n                                        sira=:sira,\r\n                                        kontrol=:kontrol\r\n                                    ");
                                    $sonuc = $kaydet->execute(["urun_id" => $_POST["product_id"], "baslik" => $GrupAdi, "real_grup_id" => $grup_id, "kat_id" => $kategoriler, "durum" => "1", "dil" => $_SESSION["dil"], "random" => $random, "sira" => $GrupSira, "kontrol" => $kontrol]);
                                    $kaydet = $db->prepare("INSERT INTO filtre_ozellik SET\r\n                                            baslik=:baslik,\r\n                                            kisa_baslik=:kisa_baslik,\r\n                                            grup_id=:grup_id,\r\n                                            ozellik_id=:ozellik_id,\r\n                                            urun_id=:urun_id,\r\n                                            sira=:sira,\r\n                                            random=:random,\r\n                                            kat_id=:kat_id,\r\n                                            filtre=:filtre,\r\n                                            kontrol=:kontrol\r\n                                    ");
                                    $sonuc = $kaydet->execute(["baslik" => $OzellikAdi, "kisa_baslik" => $filtreAdi, "grup_id" => $grup_id, "ozellik_id" => $ozellikID, "urun_id" => $_POST["product_id"], "sira" => $OzellikSira, "random" => $random, "kat_id" => $kategoriler, "filtre" => $_POST["filtre"], "kontrol" => $kontrol]);
                                    $_SESSION["collepse_status"] = "go_scroll";
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_features&productID=" . $_POST["product_id"] . "");
                                }
                            } else {
                                header("Location:" . $ayar["site_url"] . "404");
                            }
                        }
                        if ($_POST["tab"] == "product_info" && isset($_POST["info_update"])) {
                            productControl($_POST["product_id"]);
                            if ("0" < $Sql->rowCount()) {
                                if ($_POST["baslik"] && $_POST["iliskili_kat"] && $_POST["kat_id"]) {
                                    $urunKutuAyar = $db->prepare("select resim_w,resim_h,resim_big_w,resim_big_h from urun_kutu where id='1' ");
                                    $urunKutuAyar->execute();
                                    $urunboxRow = $urunKutuAyar->fetch(PDO::FETCH_ASSOC);
                                    $resim_w = $urunboxRow["resim_w"];
                                    $resim_h = $urunboxRow["resim_h"];
                                    $resim_big_w = $urunboxRow["resim_big_w"];
                                    $resim_big_h = $urunboxRow["resim_big_h"];
                                    if ($_POST["urun_kod"]) {
                                        $stok_kod = $_POST["urun_kod"];
                                    } else {
                                        function get_random_string($length = 7, $characters = "ABCDEFGHIJKLMNOPRQSTUVWXYZ0123456789")
                                        {
                                            $return = "";
                                            $num_characters = strlen($characters) - 1;
                                            while (strlen($return) < $length) {
                                                $return .= $characters[mt_rand(0, $num_characters)];
                                            }
                                            return $return;
                                        }
                                        $stok_kod = get_random_string();
                                    }
                                    $categories = $_POST["kat_id"];
                                    foreach ($categories as $cats) {
                                        $cates .= "" . $cats . ",";
                                    }
                                    if ($row["kat_id"] != $cates) {
                                        $guncelle = $db->prepare("UPDATE filtre_ozellik_grup SET\r\n                                                    kat_id=:kat_id\r\n                                             WHERE urun_id=" . $_POST["product_id"] . "      \r\n                                            ");
                                        $guncelle->execute(["kat_id" => $cates]);
                                        $guncelle2 = $db->prepare("UPDATE filtre_ozellik SET\r\n                                                    kat_id=:kat_id\r\n                                             WHERE urun_id=" . $_POST["product_id"] . "      \r\n                                            ");
                                        $guncelle2->execute(["kat_id" => $cates]);
                                    }
                                    if ($_POST["marka"] != "0") {
                                        $markagetir = $_POST["marka"];
                                    } else {
                                        $markagetir = NULL;
                                    }
                                    $markaSiraCek = $db->prepare("select sira from urun_marka where id=:id ");
                                    $markaSiraCek->execute(["id" => $_POST["marka"]]);
                                    $markaRow = $markaSiraCek->fetch(PDO::FETCH_ASSOC);
                                    $markasira = $markaRow["sira"];
                                    if (0 < $_FILES["gorsel"]["size"]) {
                                        $file_format = $_FILES["gorsel"];
                                        if ($file_format["type"] == "image/jpeg" || $file_format["type"] == "image/jpg" || $file_format["type"] == "image/png" || $file_format["type"] == "image/webp" || $file_format["type"] == "image/jxr" || $file_format["type"] == "image/jp2" || $file_format["type"] == "image/bmp") {
                                            include_once "inc/class.upload.php";
                                            $upload = new Verot\Upload\Upload($_FILES["gorsel"]);
                                            if ($upload->uploaded) {
                                                $random = rand(0, (int) 0);
                                                $random2 = rand(0, (int) 999);
                                                $upload->file_name_body_pre = "product_";
                                                $upload->file_name_body_add = "" . $random . "" . $random2 . "";
                                                $upload->image_resize = true;
                                                $upload->png_quality = 90;
                                                $upload->webp_quality = 92;
                                                $upload->jpeg_quality = 92;
                                                $upload->png_compression = 9;
                                                $upload->image_x = $resim_big_w;
                                                $upload->image_y = $resim_big_h;
                                                $upload->process("../images/product/big_photo");
                                                $upload->file_name_body_pre = "product_";
                                                $upload->file_name_body_add = "" . $random . "" . $random2 . "";
                                                $upload->image_resize = true;
                                                $upload->png_quality = 90;
                                                $upload->webp_quality = 92;
                                                $upload->jpeg_quality = 92;
                                                $upload->png_compression = 9;
                                                $upload->image_ratio_fill = "C";
                                                $upload->image_x = $resim_w;
                                                $upload->image_y = $resim_h;
                                                $upload->image_background_color = "#FFF";
                                                $upload->process("../images/product");
                                            }
                                            if ($upload->processed) {
                                                $file_name = $upload->file_dst_name;
                                                $guncelle = $db->prepare("UPDATE urun SET\r\n                                             baslik=:baslik,    \r\n                                             gorsel=:gorsel,\r\n                                             stok=:stok,\r\n                                             urun_kod=:urun_kod,\r\n                                             barkod=:barkod,\r\n                                             kat_id=:kat_id,\r\n                                             iliskili_kat=:iliskili_kat,\r\n                                             siparis_islem=:siparis_islem,\r\n                                             marka=:marka,\r\n                                             marka_sira=:marka_sira,\r\n                                             anasayfa=:anasayfa,\r\n                                             firsat=:firsat,\r\n                                             yeni=:yeni,\r\n                                             editor_secim=:editor_secim,\r\n                                             taksit=:taksit,\r\n                                             yorum_durum=:yorum_durum,\r\n                                             star_rate=:star_rate,\r\n                                             durum=:durum,\r\n                                             gorunmez=:gorunmez  \r\n                                                 WHERE id=" . $_POST["product_id"] . "      \r\n                                                ");
                                                $sonuc = $guncelle->execute(["baslik" => $_POST["baslik"], "gorsel" => $file_name, "stok" => $_POST["stok"], "urun_kod" => $stok_kod, "barkod" => $_POST["barkod"], "kat_id" => $cates, "iliskili_kat" => $_POST["iliskili_kat"], "siparis_islem" => $_POST["siparis_islem"], "marka" => $markagetir, "marka_sira" => $markasira, "anasayfa" => $_POST["anasayfa"], "firsat" => $_POST["firsat"], "yeni" => $_POST["yeni"], "editor_secim" => $_POST["editor_secim"], "taksit" => $_POST["taksit"], "yorum_durum" => $_POST["yorum_durum"], "star_rate" => $_POST["star_rate"], "durum" => $_POST["durum"], "gorunmez" => $_POST["gorunmez"]]);
                                                if ($sonuc) {
                                                    if ($_POST["old_img"] && $_POST["old_img"] != "no-img.jpg") {
                                                        unlink("../images/product/" . $_POST["old_img"] . "");
                                                        unlink("../images/product/big_photo/" . $_POST["old_img"] . "");
                                                    }
                                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail&productID=" . $_POST["product_id"] . "");
                                                    $_SESSION["main_alert"] = "success";
                                                } else {
                                                    echo "Veritabanı Hatası";
                                                }
                                            } else {
                                                header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail&productID=" . $_POST["product_id"] . "");
                                                $_SESSION["main_alert"] = "filetype";
                                                exit;
                                            }
                                        } else {
                                            header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail&productID=" . $_POST["product_id"] . "");
                                            $_SESSION["main_alert"] = "filetype";
                                        }
                                    } else {
                                        $guncelle = $db->prepare("UPDATE urun SET\r\n                                             baslik=:baslik,    \r\n                                             stok=:stok,\r\n                                             urun_kod=:urun_kod,\r\n                                             barkod=:barkod,\r\n                                             kat_id=:kat_id,\r\n                                             iliskili_kat=:iliskili_kat,\r\n                                             siparis_islem=:siparis_islem,\r\n                                             marka=:marka,\r\n                                             marka_sira=:marka_sira,\r\n                                             anasayfa=:anasayfa,\r\n                                             firsat=:firsat,\r\n                                             yeni=:yeni,\r\n                                             editor_secim=:editor_secim,\r\n                                             taksit=:taksit,\r\n                                             yorum_durum=:yorum_durum,\r\n                                             star_rate=:star_rate,\r\n                                             durum=:durum,\r\n                                             gorunmez=:gorunmez  \r\n                                                 WHERE id=" . $_POST["product_id"] . "      \r\n                                                ");
                                        $sonuc = $guncelle->execute(["baslik" => $_POST["baslik"], "stok" => $_POST["stok"], "urun_kod" => $stok_kod, "barkod" => $_POST["barkod"], "kat_id" => $cates, "iliskili_kat" => $_POST["iliskili_kat"], "siparis_islem" => $_POST["siparis_islem"], "marka" => $_POST["marka"], "marka_sira" => $markasira, "anasayfa" => $_POST["anasayfa"], "firsat" => $_POST["firsat"], "yeni" => $_POST["yeni"], "editor_secim" => $_POST["editor_secim"], "taksit" => $_POST["taksit"], "yorum_durum" => $_POST["yorum_durum"], "star_rate" => $_POST["star_rate"], "durum" => $_POST["durum"], "gorunmez" => $_POST["gorunmez"]]);
                                        if ($sonuc) {
                                            header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail&productID=" . $_POST["product_id"] . "");
                                            $_SESSION["main_alert"] = "success";
                                        } else {
                                            echo "Veritabanı Hatası";
                                        }
                                    }
                                } else {
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail&productID=" . $_POST["product_id"] . "");
                                    $_SESSION["main_alert"] = "zorunlu";
                                }
                            } else {
                                header("Location:" . $ayar["site_url"] . "404");
                            }
                        }
                        if ($_POST["tab"] == "product_price" && isset($_POST["price_shipping_update"])) {
                            productControl($_POST["product_id"]);
                            if ("0" < $Sql->rowCount()) {
                                $kdvTip = $_POST["kdv"];
                                if (($kdvTip == "1" || $kdvTip == "2") && $_POST["kdv_oran"] == NULL) {
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_price_shipping&productID=" . $_POST["product_id"] . "");
                                    $_SESSION["main_alert"] = "zorunlu";
                                    exit;
                                }
                                if ($odemeRow["kargo_sabit"] == "0") {
                                    $ucretliKargo = $_POST["kargo"];
                                    if ($ucretliKargo == "1" && $_POST["kargo_ucret"] == NULL) {
                                        header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_price_shipping&productID=" . $_POST["product_id"] . "");
                                        $_SESSION["main_alert"] = "zorunlu";
                                        exit;
                                    }
                                }
                                if ($_POST["eski_fiyat"]) {
                                    $eskiFiyat = $_POST["eski_fiyat"];
                                } else {
                                    $eskiFiyat = "0";
                                }
                                if ($_POST["alis_fiyat"]) {
                                    $alisFiyat = $_POST["alis_fiyat"];
                                } else {
                                    $alisFiyat = "0";
                                }
                                if ($_POST["fiyat"]) {
                                    $fiyat = $_POST["fiyat"];
                                } else {
                                    $fiyat = "0";
                                }
                                if ($_POST["fiyat_tip2"]) {
                                    $fiyat2 = $_POST["fiyat_tip2"];
                                } else {
                                    $fiyat2 = "0";
                                }
                                if ($_POST["havale_indirim_tutar"]) {
                                    $havaleTutar = $_POST["havale_indirim_tutar"];
                                } else {
                                    $havaleTutar = "0";
                                }
                                if ($_POST["kargo_ucret"]) {
                                    $kargoTutar = $_POST["kargo_ucret"];
                                } else {
                                    $kargoTutar = "0";
                                }
                                if ($_POST["kdv_oran"]) {
                                    $kdvOran = $_POST["kdv_oran"];
                                } else {
                                    $kdvOran = "18";
                                }
                                $guncelle = $db->prepare("UPDATE urun SET\r\n                                                    fiyat_goster=:fiyat_goster,\r\n                                                    indirim=:indirim,\r\n                                                    eski_fiyat=:eski_fiyat,\r\n                                                    alis_fiyat=:alis_fiyat,\r\n                                                    fiyat=:fiyat,\r\n                                                    fiyat_tip2=:fiyat_tip2,\r\n                                                    havale_indirim_tur=:havale_indirim_tur,\r\n                                                    havale_indirim_tutar=:havale_indirim_tutar,\r\n                                                    kdv=:kdv,\r\n                                                    kdv_oran=:kdv_oran,\r\n                                                    kargo=:kargo,\r\n                                                    kargo_tipi=:kargo_tipi,\r\n                                                    kargo_ucret=:kargo_ucret,\r\n                                                    kargo_desi=:kargo_desi,\r\n                                                    kargo_sure=:kargo_sure,\r\n                                                    hizli_kargo=:hizli_kargo\r\n                                                    WHERE id=" . $_POST["product_id"] . "\r\n                                                    ");
                                $sonuc = $guncelle->execute(["fiyat_goster" => $_POST["fiyat_goster"], "indirim" => $_POST["indirim"], "eski_fiyat" => $eskiFiyat, "alis_fiyat" => $alisFiyat, "fiyat" => $fiyat, "fiyat_tip2" => $fiyat2, "havale_indirim_tur" => $_POST["havale_indirim_tur"], "havale_indirim_tutar" => $havaleTutar, "kdv" => $_POST["kdv"], "kdv_oran" => $kdvOran, "kargo" => $_POST["kargo"], "kargo_tipi" => $_POST["kargo_tipi"], "kargo_ucret" => $kargoTutar, "kargo_desi" => $_POST["kargo_desi"], "kargo_sure" => $_POST["kargo_sure"], "hizli_kargo" => $_POST["hizli_kargo"]]);
                                if ($sonuc) {
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_price_shipping&productID=" . $_POST["product_id"] . "");
                                    $_SESSION["main_alert"] = "success";
                                } else {
                                    echo "Veritabanı Hatası";
                                }
                            } else {
                                header("Location:" . $ayar["site_url"] . "404");
                            }
                        }
                        if ($_POST["tab"] == "description" && isset($_POST["description_update"])) {
                            productControl($_POST["product_id"]);
                            if ("0" < $Sql->rowCount()) {
                                $guncelle = $db->prepare("UPDATE urun SET\r\n                                                    ek_aciklama1=:ek_aciklama1,\r\n                                                    ek_aciklama2=:ek_aciklama2,\r\n                                                    spot=:spot,\r\n                                                    icerik=:icerik\r\n                                                    WHERE id=" . $_POST["product_id"] . "\r\n                                                    ");
                                $sonuc = $guncelle->execute(["ek_aciklama1" => $_POST["ek_aciklama1"], "ek_aciklama2" => $_POST["ek_aciklama2"], "spot" => $_POST["spot"], "icerik" => $_POST["icerik"]]);
                                if ($sonuc) {
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_description&productID=" . $_POST["product_id"] . "");
                                    $_SESSION["main_alert"] = "success";
                                } else {
                                    echo "Veritabanı Hatası";
                                }
                            } else {
                                header("Location:" . $ayar["site_url"] . "404");
                            }
                        }
                        if ($_POST["tab"] == "extra" && isset($_POST["extra_update"])) {
                            productControl($_POST["product_id"]);
                            if ("0" < $Sql->rowCount()) {
                                $guncelle = $db->prepare("UPDATE urun SET\r\n                                                    embed=:embed,\r\n                                                    katalog=:katalog,\r\n                                                    ek_tabs=:ek_tabs,\r\n                                                    ek_tabs_baslik=:ek_tabs_baslik\r\n                                                    WHERE id=" . $_POST["product_id"] . "\r\n                                                    ");
                                $sonuc = $guncelle->execute(["embed" => $_POST["embed"], "katalog" => $_POST["katalog"], "ek_tabs" => $_POST["ek_tabs"], "ek_tabs_baslik" => $_POST["ek_tabs_baslik"]]);
                                if ($sonuc) {
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_extra&productID=" . $_POST["product_id"] . "");
                                    $_SESSION["main_alert"] = "success";
                                } else {
                                    echo "Veritabanı Hatası";
                                }
                            } else {
                                header("Location:" . $ayar["site_url"] . "404");
                            }
                        }
                        if ($_POST["tab"] == "meta" && isset($_POST["meta_update"])) {
                            productControl($_POST["product_id"]);
                            if ("0" < $Sql->rowCount()) {
                                if ($_POST["seo_baslik"]) {
                                    $seoTitle = $_POST["seo_baslik"];
                                } else {
                                    $seoTitle = $row["baslik"];
                                }
                                if ($_POST["seo_url"]) {
                                    $seo_url = $_POST["seo_url"];
                                } else {
                                    $seo_url = seo($row["baslik"]);
                                }
                                $guncelle = $db->prepare("UPDATE urun SET\r\n                                                    tags=:tags,\r\n                                                    meta_desc=:meta_desc,\r\n                                                    seo_baslik=:seo_baslik,\r\n                                                    seo_url=:seo_url\r\n                                                    WHERE id=" . $_POST["product_id"] . "\r\n                                                    ");
                                $sonuc = $guncelle->execute(["tags" => $_POST["tags"], "meta_desc" => $_POST["meta_desc"], "seo_baslik" => $seoTitle, "seo_url" => $seo_url]);
                                if ($sonuc) {
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_seo&productID=" . $_POST["product_id"] . "");
                                    $_SESSION["main_alert"] = "success";
                                } else {
                                    echo "Veritabanı Hatası";
                                }
                            } else {
                                header("Location:" . $ayar["site_url"] . "404");
                            }
                        }
                        if ($_POST["tab"] == "other" && isset($_POST["other_update"])) {
                            productControl($_POST["product_id"]);
                            if ("0" < $Sql->rowCount()) {
                                if ($_POST["urun_id"]) {
                                    $urunIDS = $_POST["urun_id"];
                                    foreach ($urunIDS as $idkey) {
                                        $kontrol = $db->prepare("select * from urundetay_benzer_urun where urun_id=:urun_id and detay_id=:detay_id ");
                                        $kontrol->execute(["urun_id" => $idkey, "detay_id" => $_POST["product_id"]]);
                                        if ($kontrol->rowCount() <= "0") {
                                            $kaydet = $db->prepare("INSERT INTO urundetay_benzer_urun SET\r\n                                                   urun_id=:urun_id,     \r\n                                                   detay_id=:detay_id,\r\n                                                   sira=:sira\r\n                                                ");
                                            $sonuc = $kaydet->execute(["urun_id" => $idkey, "detay_id" => $_POST["product_id"], "sira" => "1"]);
                                        } else {
                                            $_SESSION["adding_problem"] = "problem";
                                        }
                                    }
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_other&productID=" . $_POST["product_id"] . "");
                                } else {
                                    header("Location:" . $ayar["panel_url"] . "pages.php?page=product_detail_other&productID=" . $_POST["product_id"] . "");
                                    $_SESSION["main_alert"] = "zorunlu";
                                }
                            } else {
                                header("Location:" . $ayar["site_url"] . "404");
                            }
                        }
                    } else {
                        header("Location:" . $ayar["site_url"] . "404");
                    }
                } else {
                    header("Location:" . $ayar["site_url"] . "404");
                }
            }
        } else {
            header("Location:" . $ayar["site_url"] . "404");
        }
    } else {
        header("Location:" . $ayar["site_url"] . "404");
    }
} else {
    header("Location:" . $_SESSION["current_url"] . "");
    $_SESSION["main_alert"] = "demo";
}

İptal

📁 PHP Dosya Yöneticisi

📝 catalog_post.php

📝 catalog_post.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)