File Manager

✏️ Edit File: /var/www/vhosts/nursoft.al/public_html/Borova/MobileAppApi/get_data.php

<?php

include_once("lidhu_me_db.php");
if($_SERVER['REQUEST_METHOD']=='GET'){
$nid = strip_tags($_GET['nid']);
$artikull_id = strip_tags($_GET['artikull_id']);
$produkt_id = strip_tags($_GET['produkt_id']);
$user_id = strip_tags($_GET['user_id']);
$dervice_id = strip_tags($_GET['dervice_id']);
$push_id = strip_tags($_GET['push_id']);
$token = strip_tags($_GET['token']);
$nga = strip_tags($_GET['nga']);

//porosi te pa sakta me nr qe nuk ekzistojne
if($dervice_id == 'C5E94698-1E37-42CB-A14D-41E6325DAC14'){
//	exit();
}
$arrei = '{';
if(!isset($_GET["noshow"])){$arrei .= '"wisata": [';} 
if($nid == "Menu"){
 $sql = "SELECT * FROM `kategorite` WHERE web = '1' AND FIND_IN_SET('1', dyqan_id) > 0 order by radhit asc";
if($push_id != "0" && $push_id != ""){ $conn->query("UPDATE push SET hapur = hapur + '1' WHERE id = '$push_id'"); 
									  $conn->query("INSERT INTO pushe_hapur(user_id,push_id,dervice_id,token) VALUES('$user_id','$push_id','$dervice_id','$token')"); }
}
if($nid == "RrethNesh"){
 //$sql = "SELECT * FROM `permbledhje` WHERE id = '1'";
}
if($nid == "SlideShow"){
 $sql = "SELECT * FROM `permbledhje` WHERE kategoria = 'SlideShow'";
} 
if($nid == "Speciale" || $nid == "EksploroMenu"){
 $sql = "SELECT titulli,id,foto,kategoria,artikulli FROM `produkte` WHERE web = '1'  AND produkt_sherbim = 'Produkt' ";
 if($nid == "EksploroMenu" && $artikull_id !=""){  $sql .=" AND kategoria = '$artikull_id' "; }
 if($nid == "Speciale"){ $sql .="order by RAND() asc limit 20"; }
}
if($nid == "Shporta"){

$sql = "SELECT sh.produkt_id,sh.sasia, sh.id as shportaid, p.foto as foto, p.id, p.titulli as titulli, p.kategoria, p.artikulli FROM `shporta` sh INNER JOIN produkte p ON p.id = sh.produkt_id WHERE sh.id !='' AND sh.token = '$token' AND sh.dervice_id = '$dervice_id'";
  // if($user_id != ""){  $sql .=" AND (sh.user_id = '$user_id' OR sh.ip= '$ip') "; }else if($ip != ""){  $sql .=" AND sh.ip = '$ip' "; }
}

if($nid == "TotalShporte"){
$sql = "SELECT produkt_id,sasia FROM shporta WHERE id !='' AND token = '$token' AND dervice_id = '$dervice_id'";
// if($user_id != ""){  $sql .=" AND (user_id = '$user_id' OR ip= '$ip') "; }else if($ip != ""){  $sql .=" AND ip = '$ip' "; }
}

if($nid == "PorositEmia"){
  $sql = "SELECT f.produkt_id,f.sasia, p.foto as foto, p.id, p.titulli as titulli, p.kategoria, p.artikulli FROM `produkte_te_shitura` f INNER JOIN produkte p ON p.id = f.produkt_id WHERE f.id !='' AND f.klient_id = '$user_id' ";
}

if($nid == "AdresaCel"){
 $sql = "SELECT nr FROM `nr_telefoni` WHERE user_id = '$user_id' AND aktiv='1'";
}
$result = $conn->query($sql); 
if ($result->num_rows > 0) {

$x = 0; $totali = 0;
    while($to = $result->fetch_assoc()) {
		if($nid == "RrethNesh"){
	    $arrei .= '{"id":"'.$to["id"].'","pozicioni":"'.$x.'","kategoria":"'.$to["id"].'","titulli":'.json_encode($to["emri"]).',"image":'.json_encode("https://piceriensari.com/images/pizza.jpeg").',"artikulli":'.json_encode($to["artikulli"]).',"info":"","info2":""},';
	}
if($nid == "SlideShow"){
	    $arrei .= '{"id":"'.$to["id"].'","pozicioni":"'.$x.'","kategoria":"'.$to["id"].'","titulli":'.json_encode($to["emri"]).',"image":'.json_encode("https://piceriensari.com/images/".$to["foto"]).',"artikulli":'.json_encode($to["artikulli"]).',"info":"","info2":""},';
}
	if($nid == "Menu"){
	    $sql3 = "SELECT COUNT(id) as idd FROM `produkte` where kategoria  = '".$to['id']."' AND web = '1' AND produkt_sherbim = 'Produkt'";
		$result3 = $conn->query($sql3);
		$to3 = $result3->fetch_assoc();
			if($to["foto"] =="" || $to["foto"] ==" "){ $to["foto"] = "https://piceriensari.com/images/pizza.jpeg"; }else{ $to["foto"] = "https://piceriensari.com/images/".$to["foto"]; }
	    $arrei .= '{"id":"'.$to["id"].'","pozicioni":"'.$x.'","kategoria":"'.$to["id"].'","titulli":'.json_encode($to["emri"]).',"image":'.json_encode($to["foto"]).',"artikulli":'.json_encode($to3["idd"]." Produkte").',"info":"","info2":""},';
	}
	
if($nid == "Speciale"|| $nid == "EksploroMenu"){
	    $sql3 = "SELECT * FROM `cmimet` where produkt_id  = '$to[id]' AND dyqan_id = '1'";
		$result3 = $conn->query($sql3);
		$to3 = $result3->fetch_assoc();
		$kat = $conn->query("SELECT emri FROM `kategorite` where id  = '$to[kategoria]'");
		$kategoria = $kat->fetch_assoc();
		if($to3["cmimi"] =="" || $to3["cmimi"] ==" "){ $to3["cmimi"] = "0"; }
		if($to["foto"] =="" || $to["foto"] ==" "){ $to["foto"] = "https://piceriensari.com/images/pizza.jpeg"; }else{ $to["foto"] = "https://piceriensari.com/images/".$to["foto"]; }
	
	$arrei .= '{"id":"'.$to["id"].'","pozicioni":"'.$to["id"].'","kategoria":"'.$kategoria["emri"].'","titulli":'.json_encode($to["titulli"]).',"image":'.json_encode($to["foto"]).',"artikulli":'.json_encode($to3["cmimi"]).',"info":'.json_encode($kategoria["emri"]).',"info2":'.json_encode($to["artikulli"]).'},';
	}
		if($nid == "Shporta"){
	    $sql3 = "SELECT * FROM `cmimet` where produkt_id  = '$to[produkt_id]' AND dyqan_id = '1'";
		$result3 = $conn->query($sql3);
		$to3 = $result3->fetch_assoc();
		$kat = $conn->query("SELECT emri FROM `kategorite` where id  = '$to[kategoria]'");
		$kategoria = $kat->fetch_assoc();
		if($to3["cmimi"] =="" || $to3["cmimi"] ==" "){ $to3["cmimi"] = "0"; }		if($to["foto"] =="" || $to["foto"] ==" "){ $to["foto"] = "https://upload.wikimedia.org/wikipedia/sq/c/c0/Pica.jpg"; }else{ $to["foto"] = "https://piceriensari.com/images/".$to["foto"]; }
		$shuma = $to3["cmimi"] * $to["sasia"];
		$totali = $totali + $shuma;
	$arrei .= '{"id":"'.$to["shportaid"].'","pozicioni":"'.$totali.'","kategoria":"'.$to["sasia"].'","titulli":'.json_encode($to["titulli"]).',"image":'.json_encode($to["foto"]).',"artikulli":'.json_encode($to3["cmimi"]).',"info":'.json_encode($kategoria["emri"]).',"info2":'.json_encode($to["artikulli"]).'},';
	}
		
		if($nid == "TotalShporte"){
		$sql3 = "SELECT * FROM `cmimet` where produkt_id  = '$to[produkt_id]' AND dyqan_id = '1'";
		$result3 = $conn->query($sql3);
		$to3 = $result3->fetch_assoc();
		if($to3["cmimi"] =="" || $to3["cmimi"] ==" "){ $to3["cmimi"] = "0"; }
		$shuma = $to3["cmimi"] * $to["sasia"];
		$totali = $totali + $shuma;
		}
			
		if($nid == "PorositEmia"){
	    $sql3 = "SELECT * FROM `cmimet` where produkt_id  = '$to[produkt_id]' AND dyqan_id = '1'";
		$result3 = $conn->query($sql3);
		$to3 = $result3->fetch_assoc();
		$kat = $conn->query("SELECT emri FROM `kategorite` where id  = '$to[kategoria]'");
		$kategoria = $kat->fetch_assoc();
		if($to3["cmimi"] =="" || $to3["cmimi"] ==" "){ $to3["cmimi"] = "0"; }
		$shuma = $to3["cmimi"] * $to["sasia"];
		$totali = $totali + $shuma;
	$arrei .= '{"id":"'.$to["id"].'","pozicioni":"'.$totali.'","kategoria":"'.$to["sasia"].'","titulli":'.json_encode($to["titulli"]).',"image":'.json_encode("https://piceriensari.com/images/".$to["foto"]).',"artikulli":'.json_encode($to["sasia"]." x ".$to3["cmimi"]).',"info":'.json_encode($kategoria["emri"]).',"info2":'.json_encode($to["artikulli"]).'},';
	}
if($nid == "AdresaCel"){
	$arrei .= '{"id":"'.$to["id"].'","pozicioni":"'.$totali.'","cel":"'.$to["nr"].'","adresa":"0","image":'.json_encode("https://piceriensari.com/images/pizza.jpeg").',"artikulli":'.json_encode($to["sasia"]." x ".$to3["cmimi"]).',"info":"","info2":""},';
	}
    $x++; }
}
	
 if($nid == "TotalShporte"){  if($totali == ""){ $totali = "0";} $arrei .= '{"totali":"'.$totali.'"},'; }
 if($nid == "AdresaCel"){
  $sql = "SELECT adresa FROM `adresa` WHERE user_id = '$user_id' ";

$result = $conn->query($sql);
if ($result->num_rows > 0) {
	$x = 0; $totali = 0;
    while($to = $result->fetch_assoc()) {
	$arrei .= '{"id":"'.$to["id"].'","pozicioni":"'.$totali.'","cel":"0","adresa":'.json_encode($to["adresa"]).',"image":'.json_encode("https://piceriensari.com/images/pizza.jpeg").',"artikulli":'.json_encode($to["sasia"]." x ".$to3["cmimi"]).',"info":"","info2":""},';
	}}
 }
    if($nid == "PorositEmia"){
     $sql = "SELECT f.produkt_id,f.sasia, p.foto as foto, p.id, p.titulli as titulli, p.kategoria, p.artikulli FROM `produkte_te_shitura_arkiv` f INNER JOIN produkte p ON p.id = f.produkt_id WHERE f.id !='' AND f.klient_id = '$user_id' ";

$result = $conn->query($sql);
   if ($result->num_rows > 0) {
       $x = 0; $totali = 0;
       while($to = $result->fetch_assoc()) {
           $sql3 = "SELECT * FROM `cmimet` where produkt_id  = '$to[produkt_id]' AND dyqan_id = '1'";
           $result3 = $conn->query($sql3);
           $to3 = $result3->fetch_assoc();
           $kat = $conn->query("SELECT emri FROM `kategorite` where id  = '$to[kategoria]'");
           $kategoria = $kat->fetch_assoc();
           if($to3["cmimi"] =="" || $to3["cmimi"] ==" "){ $to3["cmimi"] = "0"; }
           $shuma = $to3["cmimi"] * $to["sasia"];
           $totali = $totali + $shuma;
       $arrei .= '{"id":"'.$to["id"].'","pozicioni":"'.$totali.'","kategoria":"'.$to["sasia"].'","titulli":'.json_encode($to["titulli"]).',"image":'.json_encode("https://piceriensari.com/images/".$to["foto"]).',"artikulli":'.json_encode($to["sasia"]." x ".$to3["cmimi"]).',"info":'.json_encode($kategoria["emri"]).',"info2":'.json_encode($to["artikulli"]).'},';
       
       }
       
   }
    } 
$conn->close();

echo rtrim($arrei,",");

if(!isset($_GET["noshow"])){echo  ']';} 
echo "}";
}
exit();
?>

Batal

⬅ Naik ke Borova 6 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁Android	dir	—	2023-07-24 12:33	📂 Buka
📁Ios	dir	—	2023-07-24 12:33	📂 Buka
🐘get_data.php	php	9 KB	2023-07-24 12:33	✏️ Edit 👁️ View
🐘lidhu_me_db.php	php	3.1 KB	2023-07-24 12:33	✏️ Edit 👁️ View
🐘post_data.php	php	13.8 KB	2023-07-24 12:33	✏️ Edit 👁️ View
🐘prova.php	php	603 B	2023-07-24 12:33	✏️ Edit 👁️ View