📁 PHP Dosya Yöneticisi
/
/
home
/
demodesigncom
/
e-ticaretv8.demodesign.com.tr
📝
functions.php
← Geri Dön
<?php // +------------------------------------------------------------------------+ // | @author Ercan Agkaya (Themerig) // | @author_url 1: https://www.themerig.com // | @author_url 2: https://codecanyon.net/user/themerig // | @author_email: support@themerig.com // +------------------------------------------------------------------------+ // | Techno Cms - E-Commerce Script // | Copyright (c) 2018 Techno CMS. All rights reserved. // +------------------------------------------------------------------------+ require_once('db/func.php'); require_once('db/db.php'); $cr = @$_GET['cr']; Switch($cr) { case'add_to_cart'; sleep(2); if (!empty($_POST)) { if (!empty($_POST['number'])) { $number = $_POST['number']; } else { $number = "1"; } $sira = 0; $option_name = explode(",", $_POST['option_name']); foreach ($option_name as $a){ if($sira == 0) $option_name = $a; else $secenek = $a; $sira++; } if (!empty($option_name)) { $option_name = $option_name; } else { $option_name = ""; } if (!empty($_POST['new_price'])) { $fiyat = $_POST['new_price']; } else { $fiyat = $_POST['old_price']; } $cart_t = $db -> query("SELECT * FROM cart WHERE option_name = '".$secenek."' AND item_id = '".$_POST['item_id']."' AND rand_id = '".$_COOKIE['COOKIE_KEY']."'")->fetch(); $remaining_stock = $colors['stock'] - $cart_t['piece']; if ($colors['stock'] != "" && $colors['stock'] < $number) { $array["error"] = "Stokta ".$colors['stock']." ürün var. ".$number." ürün sipariş veremezsiniz."; } else if ($colors['stock'] != "" && $remaining_stock < $number) { if ($remaining_stock != "0") { $rem_stock = "Stokta bu üründen ".$remaining_stock." adet kalmıştır."; } else { $rem_stock = "Stokta bu ürün tükenmiştir."; } $array["error"] = "Sepetiniz de bu üründen zaten ".$cart_t['piece']." adet var. ".$rem_stock." Bu üründen ".$number." adet daha sipariş veremezsiniz."; } else { $items = $db -> query("SELECT * FROM cart WHERE rand_id = '".$_COOKIE['COOKIE_KEY']."' AND item_id = '".$_POST['item_id']."' AND option_name = '".$secenek."'")->fetch(); if (empty($items)) { if($colors['stock'] == "" ) $secenek = " "; $cart_date = time(); $urun = $db->prepare("SELECT * FROM itemsy WHERE id=? "); $urun-> execute(array($_POST['item_id'])); $urun= $urun->fetch(PDO::FETCH_OBJ); if(empty($urun->new_price)){ $fiyat=$urun->old_price; }else{ $fiyat=$urun->new_price; } $reg = $db->prepare("INSERT INTO cart SET rand_id = ?, item_id = ?, piece = ?, y_price = ?, t_price = ?, cart_date = ?, option_name = ?"); $reg->execute(array($_COOKIE['COOKIE_KEY'], $_POST['item_id'], $number, $fiyat, $fiyat, $cart_date, $secenek)); if($reg->rowCount()) { $array["success"] = "Sepete ekleme başarılı"; } else { $array["error"] = "Sepete eklemede hata oluştu!"; } } else { $total_piece = $number + $items['piece']; $t_price = $total_piece * $items['y_price']; $query = $db->prepare("UPDATE cart SET piece = :pice, t_price = :t_prc WHERE rand_id = :rnd AND item_id = :itm AND option_name = :clr "); $update = $query->execute(array("pice" => "".$total_piece."","t_prc" => "".$t_price."","rnd" => "".$_COOKIE['COOKIE_KEY']."","itm" => "".$_POST['item_id']."","clr" => "".$secenek."")); if($update) { $array["success"] = "Sepete ekleme başarılı"; } else { $array["error"] = "Sepete eklemede hata oluştu!"; } } } } break; case'add_r'; if (!empty($_POST)) { $rand_id_cart = $db->query("SELECT count(*) FROM cart WHERE rand_id = '".$_COOKIE['COOKIE_KEY']."'")->fetchColumn(); if ($rand_id_cart > "0") { $new_price_count = $db -> query("SELECT SUM(t_price) as total FROM cart WHERE rand_id = '".$_COOKIE['COOKIE_KEY']."'")->fetch(); $cart_price = number_format($new_price_count['total'],2,',','.'); $cart = $db->prepare("SELECT * FROM cart WHERE rand_id = '".$_COOKIE['COOKIE_KEY']."'"); $cart->execute(); if ($cart->rowCount()) { foreach ($cart as $row) { $gallery = $db -> query("SELECT * FROM gallery WHERE item_id = '".$row['item_id']."' ")->fetch(); $items = $db -> query("SELECT * FROM itemsy WHERE id = '".$row['item_id']."'")->fetch(); $new_price = number_format($row['y_price'],2,',','.'); if (strlen($items['title']) > 53) { $baslik = substr($items['title'], 0, 53).'...'; } else { $baslik = $items['title']; } $array["yes_cart"].='<li> <div class="img-product"> <a href="'.seo($items['multi_sub_category_name']).'/'.seo($items['title']."-e".$items['id']).'"> <img src="'.$items['foto_url'].'" alt=""> </a> </div> <div class="info-product"> <div class="name"> '.$baslik.' </div> <div class="price"> <span>'.$row['piece'].' x</span> <span>'.$new_price.' TL</span> </div> </div> <div class="clearfix"></div> <span title="" product-id="'.$items['id'].'" onclick="removeurun('.$items['id'].');" class="delete removeBtn">x</span> </li>'; } } $array["cart_count"].='<div class="total"> <span>Toplam:</span> <span class="price">'.$cart_price.' TL</span> </div>'; $array["cart_count_pi"].='<span>'.$rand_id_cart.'</span>'; } else { $array["no_cart"].='<p style="float: left;">Sepetinizde ürün bulunmamaktadır!</p>'; } } break; case'opt'; if (!empty($_GET)) { $sub_category_search_id = $db->prepare("SELECT * FROM sub_category_search_id WHERE parent = '".$_GET['sub_category_search_id']."' AND stock > '0'"); $sub_category_search_id->execute(); if ($sub_category_search_id->rowCount()) { foreach ($sub_category_search_id as $row) { $array["yes_option"].='<option value="'.$row['id'].'" count="'.$row['stock'].'">'.$row['option_name'].'</option>'; $array["yes_stock"].=$row['stock']; } } else { $array["no_option"].='no option'; } } break; case'decount'; if (!empty($_GET)) { $id = $_POST['product_id']; $kont = $db->prepare("SELECT * FROM cart WHERE rand_id=? && item_id=?"); $kont-> execute(array($_COOKIE['COOKIE_KEY'],$id)); $kont= $kont->fetch(PDO::FETCH_OBJ); if (!empty($kont)) { if ($kont->piece>1) { $edit = $db->prepare("UPDATE cart SET piece=?,t_price=? WHERE id=?"); $edit-> execute(array($kont->piece-1,$kont->t_price-$kont->y_price,$kont->id)); }else{ $delete = $db->prepare("DELETE FROM cart WHERE id=?"); $delete-> execute(array($kont->id)); } $array["no_option"].='Bulundu'; } } break; case'incCountBtn'; if (!empty($_GET)) { $id = $_POST['product_id']; $kont = $db->prepare("SELECT * FROM cart WHERE rand_id=? && item_id=?"); $kont-> execute(array($_COOKIE['COOKIE_KEY'],$id)); $kont= $kont->fetch(PDO::FETCH_OBJ); if (!empty($kont)) { $edit = $db->prepare("UPDATE cart SET piece=?,t_price=? WHERE id=?"); $edit-> execute(array($kont->piece+1,$kont->t_price+$kont->y_price,$kont->id)); $array["no_option"].='Bulundu'; } } break; case'removeBtn'; if (!empty($_GET)) { $id = $_POST['product_id']; $kont = $db->prepare("SELECT * FROM cart WHERE rand_id=? && item_id=?"); $kont-> execute(array($_COOKIE['COOKIE_KEY'],$id)); $kont= $kont->fetch(PDO::FETCH_OBJ); if (!empty($kont)) { $delete = $db->prepare("DELETE FROM cart WHERE id=?"); $delete-> execute(array($kont->id)); $array["no_option"].='Bulundu'; } } break; default: { $array["debug"] = "error"; } break; } echo json_encode($array);
💾 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