📁 PHP Dosya Yöneticisi
/
/
home
/
demodesigncom
/
e-ticaretv10.demodesign.com.tr
/
secured
/
inc
/
modules
/
catalog
📝
multi_update.php
← Geri Dön
<?php echo !defined("GUVENLIK") ? exit : NULL; if ($yetki["demo"] != "1") { $secure1 = trim(strip_tags($_POST["updateStatusPersonality"])); $secure2 = trim(strip_tags($_POST["updateStatus"])); $selected = trim(strip_tags($_POST["secenek"])); if ($secure1 == "true" && $secure2 == "success") { if ($selected) { if ($selected == "price_plus" || $selected == "stock_code" || $selected == "price_minus" || $selected == "price_plus_percent" || $selected == "price_minus_percent" || $selected == "stock_plus" || $selected == "stock_minus" || $selected == "cargo" || $selected == "status_choose" || $selected == "kdv") { $searchInput = trim(strip_tags($_POST["search_input"])); $statusInput = trim(strip_tags($_POST["status_input"])); $featureInput = trim(strip_tags($_POST["feature_input"])); $date1Input = trim(strip_tags($_POST["date_1_input"])); $date2Input = trim(strip_tags($_POST["date_2_input"])); $minInput = trim(strip_tags($_POST["min_input"])); $maxInput = trim(strip_tags($_POST["max_input"])); $catInput = trim(strip_tags($_POST["category_input"])); $brandInput = trim(strip_tags($_POST["brand_input"])); $searchGet = $searchInput; if ($searchGet) { $search = "where (baslik like '%" . $searchGet . "%' or seo_baslik like '%" . $searchGet . "%' or spot like '%" . $searchGet . "%' or icerik like '%" . $searchGet . "%' or tags like '%" . $searchGet . "%' or meta_desc like '%" . $searchGet . "%' or urun_kod like '%" . $searchGet . "%' or seo_url like '%" . $searchGet . "%') "; } else { $search = "where (baslik like '%" . $searchGet . "%' or seo_baslik like '%" . $searchGet . "%' or spot like '%" . $searchGet . "%' or icerik like '%" . $searchGet . "%' or tags like '%" . $searchGet . "%' or meta_desc like '%" . $searchGet . "%' or urun_kod like '%" . $searchGet . "%' or seo_url like '%" . $searchGet . "%') "; } if ($statusInput == "0" || $statusInput == NULL || $statusInput == "1" || $statusInput == "2" || $statusInput == "3" || $statusInput == "4" || $statusInput == "5" || $statusInput == "6" || $statusInput == "7" || $statusInput == "8") { if ($statusInput == "0") { $productStatusGet = "and durum='0'"; } if ($statusInput == "1") { $productStatusGet = "and durum='1'"; } if ($statusInput == "2") { $productStatusGet = "and gorunmez='1'"; } if ($statusInput == "3") { $productStatusGet = "and siparis_islem='0'"; } if ($statusInput == "4") { $productStatusGet = "and siparis_islem!='0'"; } if ($statusInput == "5") { $productStatusGet = "and fiyat_goster='0'"; } if ($statusInput == "6") { $productStatusGet = "and fiyat_goster='1'"; } if ($statusInput == "7") { $productStatusGet = "and fiyat_goster='2'"; } if ($statusInput == "8") { $productStatusGet = "and fiyat_goster='3'"; } } else { $productStatusGet = NULL; } if ($featureInput == NULL || $featureInput == "1" || $featureInput == "2" || $featureInput == "3" || $featureInput == "4" || $featureInput == "5" || $featureInput == "6") { if ($featureInput == "1") { $featureGet = "and indirim='1'"; } if ($featureInput == "2") { $featureGet = "and firsat='1'"; } if ($featureInput == "3") { $featureGet = "and hizli_kargo='1'"; } if ($featureInput == "4") { $featureGet = "and editor_secim ='1'"; } if ($featureInput == "5") { $featureGet = "and yeni='1'"; } if ($featureInput == "6") { $featureGet = "and taksit='1'"; } } else { $featureGet = NULL; } if ($catInput) { $categoryIDCome = $catInput; $categoryGet = "and (kat_id like '%" . $categoryIDCome . ",%')"; } if ($brandInput) { $brandSecureGet = $brandInput; $brandGet = "and marka='" . $brandSecureGet . "'"; } if ($date1Input) { $dateGet = "and sade_tarih >='" . $date1Input . "' "; } else { $dateGet = NULL; } if ($date2Input) { $dateEndGet = "and sade_tarih <='" . $date2Input . "' "; } else { $dateEndGet = NULL; } if ($minInput) { $minTutarSecure = $minInput; $minTutarGet = "and (fiyat >='" . $minTutarSecure . "') "; } else { $minTutarGet = NULL; } if ($maxInput) { $maxTutarSecure = $maxInput; $maxTutarGet = "and (fiyat <='" . $maxTutarSecure . "') "; } else { $maxTutarGet = NULL; } $uruNSorgu = $db->prepare("select id from urun " . $search . " " . $productStatusGet . " " . $featureGet . " " . $categoryGet . " " . $brandGet . " " . $dateGet . " " . $dateEndGet . " " . $minTutarGet . " " . $maxTutarGet); $uruNSorgu->execute(); if ($selected == "stock_code") { if ("0" < $uruNSorgu->rowCount()) { 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; } foreach ($uruNSorgu as $row) { $stokKodu = get_random_string(); $urunSorguSql = $db->prepare("select * from urun where id=:id "); $urunSorguSql->execute(["id" => $row["id"]]); $inRow = $urunSorguSql->fetch(PDO::FETCH_ASSOC); $guncelle = $db->prepare("UPDATE urun SET\r\n urun_kod=:urun_kod\r\n WHERE id=" . $inRow["id"] . " \r\n "); $sonuc = $guncelle->execute(["urun_kod" => $stokKodu]); } $_SESSION["main_alert"] = "success"; header("Location:" . $ayar["panel_url"] . "pages.php?page=allupdate_product"); } else { header("Location:" . $ayar["site_url"] . "404"); } } if ($selected == "price_plus") { if ("0" < $uruNSorgu->rowCount()) { foreach ($uruNSorgu as $row) { $urunSorguSql = $db->prepare("select * from urun where id=:id "); $urunSorguSql->execute(["id" => $row["id"]]); $inRow = $urunSorguSql->fetch(PDO::FETCH_ASSOC); if ($_POST["plus_price_value"]) { $gelenFiyat = trim(strip_tags($_POST["plus_price_value"])); } else { $gelenFiyat = "0"; } if ($_POST["ozel_plus_price_value"]) { $gelenTip2Fiyat = trim(strip_tags($_POST["ozel_plus_price_value"])); } else { $gelenTip2Fiyat = "0"; } $yeniFiyat = $inRow["fiyat"] + $gelenFiyat; if ("0" < $inRow["fiyat_tip2"]) { $yeniFiyatTip2 = $inRow["fiyat_tip2"] + $gelenTip2Fiyat; } else { $yeniFiyatTip2 = "0"; } $guncelle = $db->prepare("UPDATE urun SET\r\n fiyat=:fiyat,\r\n fiyat_tip2=:fiyat_tip2\r\n WHERE id=" . $inRow["id"] . " \r\n "); $sonuc = $guncelle->execute(["fiyat" => $yeniFiyat, "fiyat_tip2" => $yeniFiyatTip2]); } $_SESSION["main_alert"] = "success"; header("Location:" . $ayar["panel_url"] . "pages.php?page=allupdate_product"); } else { header("Location:" . $ayar["site_url"] . "404"); } } if ($selected == "price_minus") { if ("0" < $uruNSorgu->rowCount()) { foreach ($uruNSorgu as $row) { $urunSorguSql = $db->prepare("select * from urun where id=:id "); $urunSorguSql->execute(["id" => $row["id"]]); $inRow = $urunSorguSql->fetch(PDO::FETCH_ASSOC); if ($_POST["minus_price_value"]) { $gelenFiyat = trim(strip_tags($_POST["minus_price_value"])); } else { $gelenFiyat = "0"; } if ($_POST["ozel_minus_price_value"]) { $gelenTip2Fiyat = trim(strip_tags($_POST["ozel_minus_price_value"])); } else { $gelenTip2Fiyat = "0"; } if ($gelenFiyat < $inRow["fiyat"]) { $yeniFiyat = $inRow["fiyat"] - $gelenFiyat; } else { $yeniFiyat = $inRow["fiyat"]; } if ("0" < $inRow["fiyat_tip2"]) { if ($gelenTip2Fiyat < $inRow["fiyat_tip2"]) { $yeniFiyatTip2 = $inRow["fiyat_tip2"] - $gelenTip2Fiyat; } else { $yeniFiyatTip2 = $inRow["fiyat_tip2"]; } } else { $yeniFiyatTip2 = "0"; } $guncelle = $db->prepare("UPDATE urun SET\r\n fiyat=:fiyat,\r\n fiyat_tip2=:fiyat_tip2,\r\n indirim=:indirim\r\n WHERE id=" . $inRow["id"] . " \r\n "); $sonuc = $guncelle->execute(["fiyat" => $yeniFiyat, "fiyat_tip2" => $yeniFiyatTip2, "indirim" => $_POST["indirim"]]); } $_SESSION["main_alert"] = "success"; header("Location:" . $ayar["panel_url"] . "pages.php?page=allupdate_product"); } else { header("Location:" . $ayar["site_url"] . "404"); } } if ($selected == "price_plus_percent") { if ("0" < $uruNSorgu->rowCount()) { foreach ($uruNSorgu as $row) { $urunSorguSql = $db->prepare("select * from urun where id=:id "); $urunSorguSql->execute(["id" => $row["id"]]); $inRow = $urunSorguSql->fetch(PDO::FETCH_ASSOC); if ($_POST["plus_price_percent"]) { $gelenOran = trim(strip_tags($_POST["plus_price_percent"])); $oranHesap = $inRow["fiyat"] * $gelenOran / 100; if ($oranHesap <= $inRow["fiyat"]) { $yeniFiyat = $inRow["fiyat"] + $oranHesap; } else { $yeniFiyat = $inRow["fiyat"]; } } else { $yeniFiyat = $inRow["fiyat"]; } if ($_POST["ozel_plus_price_percent"]) { if ("0" < $inRow["fiyat_tip2"]) { $gelenOranTip2 = trim(strip_tags($_POST["ozel_plus_price_percent"])); $oranHesapTip2 = $inRow["fiyat_tip2"] * $gelenOranTip2 / 100; if ($oranHesapTip2 <= $inRow["fiyat_tip2"]) { $yeniFiyatTip2 = $inRow["fiyat_tip2"] + $oranHesapTip2; } else { $yeniFiyatTip2 = $inRow["fiyat_tip2"]; } } else { $yeniFiyatTip2 = $inRow["fiyat_tip2"]; } } else { $yeniFiyatTip2 = $inRow["fiyat_tip2"]; } $guncelle = $db->prepare("UPDATE urun SET\r\n fiyat=:fiyat,\r\n fiyat_tip2=:fiyat_tip2\r\n WHERE id=" . $inRow["id"] . " \r\n "); $sonuc = $guncelle->execute(["fiyat" => $yeniFiyat, "fiyat_tip2" => $yeniFiyatTip2]); } $_SESSION["main_alert"] = "success"; header("Location:" . $ayar["panel_url"] . "pages.php?page=allupdate_product"); } else { header("Location:" . $ayar["site_url"] . "404"); } } if ($selected == "price_minus_percent") { if ("0" < $uruNSorgu->rowCount()) { foreach ($uruNSorgu as $row) { $urunSorguSql = $db->prepare("select * from urun where id=:id "); $urunSorguSql->execute(["id" => $row["id"]]); $inRow = $urunSorguSql->fetch(PDO::FETCH_ASSOC); if ($_POST["minus_price_percent"]) { $gelenOran = trim(strip_tags($_POST["minus_price_percent"])); $oranHesap = $inRow["fiyat"] * $gelenOran / 100; if ($oranHesap <= $inRow["fiyat"]) { $yeniFiyat = $inRow["fiyat"] - $oranHesap; } else { $yeniFiyat = $inRow["fiyat"]; } } else { $yeniFiyat = $inRow["fiyat"]; } if ($_POST["ozel_minus_price_percent"]) { if ("0" < $inRow["fiyat_tip2"]) { $gelenOranTip2 = trim(strip_tags($_POST["ozel_minus_price_percent"])); $oranHesapTip2 = $inRow["fiyat_tip2"] * $gelenOranTip2 / 100; if ($oranHesapTip2 <= $inRow["fiyat_tip2"]) { $yeniFiyatTip2 = $inRow["fiyat_tip2"] - $oranHesapTip2; } else { $yeniFiyatTip2 = $inRow["fiyat_tip2"]; } } else { $yeniFiyatTip2 = $inRow["fiyat_tip2"]; } } else { $yeniFiyatTip2 = $inRow["fiyat_tip2"]; } $guncelle = $db->prepare("UPDATE urun SET\r\n fiyat=:fiyat,\r\n fiyat_tip2=:fiyat_tip2,\r\n indirim=:indirim\r\n WHERE id=" . $inRow["id"] . " \r\n "); $sonuc = $guncelle->execute(["fiyat" => $yeniFiyat, "fiyat_tip2" => $yeniFiyatTip2, "indirim" => $_POST["indirim"]]); } $_SESSION["main_alert"] = "success"; header("Location:" . $ayar["panel_url"] . "pages.php?page=allupdate_product"); } else { header("Location:" . $ayar["site_url"] . "404"); } } if ($selected == "stock_plus") { if ("0" < $uruNSorgu->rowCount()) { foreach ($uruNSorgu as $row) { $urunSorguSql = $db->prepare("select * from urun where id=:id "); $urunSorguSql->execute(["id" => $row["id"]]); $inRow = $urunSorguSql->fetch(PDO::FETCH_ASSOC); if ($_POST["plus_stock_value"]) { $gelenStok = trim(strip_tags($_POST["plus_stock_value"])); $yeniStok = $inRow["stok"] + $gelenStok; } else { $yeniStok = $inRow["stok"]; } $guncelle = $db->prepare("UPDATE urun SET\r\n stok=:stok\r\n WHERE id=" . $inRow["id"] . " \r\n "); $sonuc = $guncelle->execute(["stok" => $yeniStok]); } $_SESSION["main_alert"] = "success"; header("Location:" . $ayar["panel_url"] . "pages.php?page=allupdate_product"); } else { header("Location:" . $ayar["site_url"] . "404"); } } if ($selected == "stock_minus") { if ("0" < $uruNSorgu->rowCount()) { foreach ($uruNSorgu as $row) { $urunSorguSql = $db->prepare("select * from urun where id=:id "); $urunSorguSql->execute(["id" => $row["id"]]); $inRow = $urunSorguSql->fetch(PDO::FETCH_ASSOC); if ($_POST["minus_stock_value"]) { $gelenStok = trim(strip_tags($_POST["minus_stock_value"])); if ($gelenStok <= $inRow["stok"]) { $yeniStok = $inRow["stok"] - $gelenStok; } else { $yeniStok = $inRow["stok"]; } } else { $yeniStok = $inRow["stok"]; } $guncelle = $db->prepare("UPDATE urun SET\r\n stok=:stok\r\n WHERE id=" . $inRow["id"] . " \r\n "); $sonuc = $guncelle->execute(["stok" => $yeniStok]); } $_SESSION["main_alert"] = "success"; header("Location:" . $ayar["panel_url"] . "pages.php?page=allupdate_product"); } else { header("Location:" . $ayar["site_url"] . "404"); } } if ($selected == "cargo") { if ("0" < $uruNSorgu->rowCount()) { foreach ($uruNSorgu as $row) { $urunSorguSql = $db->prepare("select * from urun where id=:id "); $urunSorguSql->execute(["id" => $row["id"]]); $inRow = $urunSorguSql->fetch(PDO::FETCH_ASSOC); $gelenKargoDurum = trim(strip_tags($_POST["cargo_value"])); $gelenKargoTip = trim(strip_tags($_POST["kargo_tipi"])); $gelenUcret = trim(strip_tags($_POST["kargo_ucret"])); $kargoSure = trim(strip_tags($_POST["kargo_sure"])); $kargoHizli = trim(strip_tags($_POST["hizli_kargo"])); if ($gelenKargoDurum == "1") { if ($gelenUcret) { $yeniucret = $gelenUcret; } else { $gelenKargoDurum = "0"; } } $guncelle = $db->prepare("UPDATE urun SET\r\n kargo=:kargo,\r\n kargo_tipi=:kargo_tipi,\r\n kargo_ucret=:kargo_ucret,\r\n hizli_kargo=:hizli_kargo,\r\n kargo_sure=:kargo_sure\r\n WHERE id=" . $inRow["id"] . " \r\n "); $sonuc = $guncelle->execute(["kargo" => $gelenKargoDurum, "kargo_tipi" => $gelenKargoTip, "kargo_ucret" => $yeniucret, "hizli_kargo" => $kargoHizli, "kargo_sure" => $kargoSure]); } $_SESSION["main_alert"] = "success"; header("Location:" . $ayar["panel_url"] . "pages.php?page=allupdate_product"); } else { header("Location:" . $ayar["site_url"] . "404"); } } if ($selected == "kdv") { if ("0" < $uruNSorgu->rowCount()) { foreach ($uruNSorgu as $row) { $urunSorguSql = $db->prepare("select * from urun where id=:id "); $urunSorguSql->execute(["id" => $row["id"]]); $inRow = $urunSorguSql->fetch(PDO::FETCH_ASSOC); $gelenKDVDurum = trim(strip_tags($_POST["kdv_value"])); $kdvOrani = trim(strip_tags($_POST["kdv_percent"])); $guncelle = $db->prepare("UPDATE urun SET\r\n kdv=:kdv,\r\n kdv_oran=:kdv_oran\r\n WHERE id=" . $inRow["id"] . " \r\n "); $sonuc = $guncelle->execute(["kdv" => $gelenKDVDurum, "kdv_oran" => $kdvOrani]); } $_SESSION["main_alert"] = "success"; header("Location:" . $ayar["panel_url"] . "pages.php?page=allupdate_product"); } else { header("Location:" . $ayar["site_url"] . "404"); } } if ($selected == "status_choose") { if ("0" < $uruNSorgu->rowCount()) { foreach ($uruNSorgu as $row) { $urunSorguSql = $db->prepare("select * from urun where id=:id "); $urunSorguSql->execute(["id" => $row["id"]]); $inRow = $urunSorguSql->fetch(PDO::FETCH_ASSOC); $durumValue = trim(strip_tags($_POST["durum_value"])); if ($durumValue == "1" || $durumValue == "2" || $durumValue == "3" || $durumValue == "4" || $durumValue == "5" || $durumValue == "6" || $durumValue == "7" || $durumValue == "8") { if ($durumValue == "1") { $guncelle = $db->prepare("UPDATE urun SET\r\n durum=:durum\r\n WHERE id=" . $inRow["id"] . " \r\n "); $sonuc = $guncelle->execute(["durum" => "0"]); } if ($durumValue == "2") { $guncelle = $db->prepare("UPDATE urun SET\r\n gorunmez=:gorunmez\r\n WHERE id=" . $inRow["id"] . " \r\n "); $sonuc = $guncelle->execute(["gorunmez" => "1"]); } if ($durumValue == "3") { $guncelle = $db->prepare("UPDATE urun SET\r\n fiyat_goster=:fiyat_goster\r\n WHERE id=" . $inRow["id"] . " \r\n "); $sonuc = $guncelle->execute(["fiyat_goster" => "0"]); } if ($durumValue == "4") { $guncelle = $db->prepare("UPDATE urun SET\r\n fiyat_goster=:fiyat_goster\r\n WHERE id=" . $inRow["id"] . " \r\n "); $sonuc = $guncelle->execute(["fiyat_goster" => "1"]); } if ($durumValue == "5") { $guncelle = $db->prepare("UPDATE urun SET\r\n fiyat_goster=:fiyat_goster\r\n WHERE id=" . $inRow["id"] . " \r\n "); $sonuc = $guncelle->execute(["fiyat_goster" => "2"]); } if ($durumValue == "6") { $guncelle = $db->prepare("UPDATE urun SET\r\n fiyat_goster=:fiyat_goster\r\n WHERE id=" . $inRow["id"] . " \r\n "); $sonuc = $guncelle->execute(["fiyat_goster" => "3"]); } if ($durumValue == "7") { $guncelle = $db->prepare("UPDATE urun SET\r\n durum=:durum\r\n WHERE id=" . $inRow["id"] . " \r\n "); $sonuc = $guncelle->execute(["durum" => "1"]); } if ($durumValue == "8") { $guncelle = $db->prepare("UPDATE urun SET\r\n gorunmez=:gorunmez\r\n WHERE id=" . $inRow["id"] . " \r\n "); $sonuc = $guncelle->execute(["gorunmez" => "0"]); } } else { header("Location:" . $ayar["site_url"] . "404"); exit; } } $_SESSION["main_alert"] = "success"; header("Location:" . $ayar["panel_url"] . "pages.php?page=allupdate_product"); } else { header("Location:" . $ayar["site_url"] . "404"); } } } else { header("Location:" . $ayar["site_url"] . "404"); } } else { $_SESSION["main_alert"] = "multi_update_emptyerror"; header("Location:" . $ayar["panel_url"] . "pages.php?page=allupdate_product"); } } else { header("Location:" . $ayar["site_url"] . "404"); } } else { header("Location:" . $_SESSION["current_url"] . ""); $_SESSION["main_alert"] = "demo"; } ?>
💾 Kaydet
İptal
📝 Yeniden Adlandır
İptal
Kaydet
🔐 Dosya İzinleri (chmod)
İzin Değeri:
Hızlı Seçim:
777
755
644
600
777
= Herkes okur/yazar/çalıştırır
755
= Sahip tam, diğerleri okur/çalıştırır
644
= Sahip okur/yazar, diğerleri okur
600
= Sadece sahip okur/yazar
İptal
Uygula