File Manager

✏️ Edit File: /var/www/vhosts/nursoft.al/public_html/BodyCode/login/Api/get_data.php

<?php
error_reporting(0);
ini_set('display_errors', '0');
include_once("lidhu_me_db_new.php");
include_once("../php_files/status.php");
include_once("../php_files/class.functions.php");
$auth = new USER();
$data = date("Y-m-d H:i:s");
$dat = date("Y-m-d");
if($_SERVER['REQUEST_METHOD']=='GET'){
$v = sanitize_input($_GET['v']);
$nid = sanitize_input($_GET['nid']);
$selectedValue = sanitize_input($_GET['selectedValue']);
if($_GET['biznes_id'] !=""){
$biznes_id = sanitize_input($_GET['biznes_id']);
 } else {
$biznes_id = sanitize_input($_SESSION['biznes_id']);
 }
$events = [];
$id = sanitize_input($_GET['id']);
$artikull_id = sanitize_input($_GET['artikull_id']);
$produkt_id = sanitize_input($_GET['produkt_id']);
$user_id = sanitize_input($_GET['user_id']);
$dervice_id = sanitize_input($_GET['dervice_id']);
$push_id = sanitize_input($_GET['push_id']);
$token = sanitize_input($_GET['token']);
$nga = sanitize_input($_GET['nga']);
$departament_id = implode(",", array(sanitize_input($_GET['departament_id'])));
$shid = sanitize_input($_GET['shid']);
$arrei = '{';
if(!isset($_GET["noshow"])){$arrei .= '"wisata": [';}

if ($nid == "GetCalendarData") {
    try {
        $startDate = $_GET["start"];
        $dege_id = $_GET["dege_id"];
        $endDate = $_GET["end"];
        $trainer_id = $_GET["trainer_id"];
        if($trainer_id == ""){
        $sql = $auth->runQuery("SELECT t.*, c.first_name as first_name, c.surname as surname
        FROM trajnime AS t
        INNER JOIN customers AS c ON t.customer_id = c.id
         WHERE t.biznes_id =:biznes_id AND t.data_trajnimit BETWEEN '$startDate' AND '$endDate' AND t.dege_id =:dege_id");
        $sql->execute(array(":biznes_id" => $biznes_id, ":dege_id" => $dege_id));
        } else if($trainer_id != ""){
        $sql = $auth->runQuery("SELECT * FROM trajnime WHERE biznes_id =:biznes_id AND dege_id =:dege_id AND trajner_id =:trainer_id");
        $sql->execute(array(":biznes_id" => $biznes_id, ":dege_id" => $dege_id, ":trainer_id" => $trainer_id));
        }

// Loop through each row of the result set
        while ($row = $sql->fetch(PDO::FETCH_ASSOC)) {
                    if($row['data_trajnimit_end'] == "0000-00-00") $row['data_trajnimit_end'] = $row['data_trajnimit'];
                    if($row['ora_end'] == "") $row['ora_end'] = date("H:i", strtotime($row['ora']." +30 minutes"));
                    if($row['kategoria'] == "1"){ $backgroundColor = "#6571ff33"; $borderColor = "#6571ff"; } 
                    else if($row['kategoria'] == "2"){ $backgroundColor = "rgba(253, 126, 20, 0.25)"; $borderColor = "rgb(253, 126, 20)"; }
                    else { $backgroundColor = "#6571ff33"; $borderColor = "#6571ff"; } 
                    if($row['status'] == "1"){ $backgroundColor = "rgba(0, 204, 204, 0.25)"; $borderColor = "rgb(0, 204, 204)"; } 
                    else if($row['status'] == "2"){ $backgroundColor = "rgb(122 115 119 / 25%)"; $borderColor = "rgb(94 86 90)"; } 
                    else if($row['status'] == "3"){ $backgroundColor = "rgba(241, 0, 117, 0.25)"; $borderColor = "rgb(241, 0, 117)"; }

// Format the event data
            $event = [
                'id' => $row['id'],
                'customer_name' => $row['first_name'] ." ". $row['surname'],
                'service_id' => $row['service_id'],
                'data_trajnimit' => $row['data_trajnimit'],
                'data_trajnimit_end' => $row['data_trajnimit_end'],
                'ora' => $row['ora'],
                'ora_end' => $row['ora_end'],
                'customer_id' => $row['customer_id'],
                'device_id' => $row['device_id'],
                'trajner_id' => $row['trajner_id'],
                'status' => $row['status'],
                'groupId' => $row['id'],
                'resourceId' => $row['device_id'],
                'title' => $row['first_name'] ." ". $row['surname'],
                'start' => $row['data_trajnimit'] . " ".$row['ora'],
                'end' => $row['data_trajnimit_end'] . " ".$row['ora_end'],
                'backgroundColor' => $backgroundColor,
                'borderColor' => $borderColor
            ];

// Add the event to the array
            $events[] = $event;
        }

// Convert the response array to JSON
        $responseJson = json_encode($events);

// Output the response
       // header('Content-Type: application/json');
        echo $responseJson;
        exit();
    } catch (PDOException $e) {
        echo "Query failed: " . $e->getMessage();
    }
}

if($nid == "Devices"){
try {
$sql = $auth->runQuery("SELECT id, emri, slots FROM devices WHERE biznes_id =:biznes_id AND dege_id = :dege_id");
$sql->execute(array(":biznes_id"=>$biznes_id,":dege_id"=>$selectedValue));
       while($row = $sql->fetch(PDO::FETCH_ASSOC)){
        $arrei .= '{"id":"'.$row["id"].'","emri":'.json_encode($row["emri"]).'},';
      $event = [
                'id' => $row['id'],
                'title' => $row['emri'],
                'maxEventsPerHour' => $row['slots']
            ];

// Add the event to the array
            $events[] = $event;
        }
             if($_GET["calendar"] == "true"){
        // Convert the response array to JSON
        $responseJson = json_encode($events);

// Output the response
       // header('Content-Type: application/json');
        echo $responseJson;
        exit();
             } 
} catch (PDOException $e) {
    echo "Query failed: " . $e->getMessage();
}
    }
    
    if($nid == "Trainier"){
try {
$sql = $auth->runQuery("SELECT id, emri FROM perdorues WHERE biznes_id =:biznes_id AND dege_id = :dege_id AND kategoria = :kategoria");
$sql->execute(array(":biznes_id"=>$biznes_id,":dege_id"=>$selectedValue,":kategoria"=>"Trainer"));
       while($row = $sql->fetch(PDO::FETCH_ASSOC)){
        $arrei .= '{"id":"'.$row["id"].'","emri":'.json_encode($row["emri"]).'},';
        }
} catch (PDOException $e) {
    echo "Query failed: " . $e->getMessage();
}
    }
    
    
if($nid == "Time"){
$data_trajnimit = $_GET["dt_fillimit"];
$trainier_id = $_GET["trainier_id"];
try {
// Execute the query to fetch the existing records
$sql = $auth->runQuery("SELECT id, data_trajnimit, data_trajnimit_end, ora, ora_end FROM trajnime WHERE biznes_id = :biznes_id AND device_id = :device_id AND data_trajnimit = :data_trajnimit AND status = :status");
$sql->execute(array(":biznes_id" => $biznes_id, ":device_id" => $selectedValue, ":data_trajnimit" => $data_trajnimit, ":status" => "0"));

// Fetch the result rows
$result = $sql->fetchAll(PDO::FETCH_ASSOC);

// Create an array to store the existing times
$existingTimes = array();

// Loop through the result rows and extract the times
foreach ($result as $row) {
    $startTime = strtotime($row['ora']);
    if (empty($row['ora_end'])) {
        // Treat it as a free time slot
        $existingTimes[] = date('H:i', $startTime);
    } else {
        $endTime = strtotime($row['ora_end']);
        // Add each half-hour within the start and end times to the existing times array
        for ($time = $startTime; $time <= $endTime; $time += 1800) {
            $existingTimes[] = date('H:i', $time);
        }
    }
}

// Count the occurrences of each time slot
$timeOccurrences = array_count_values($existingTimes);

// Create an array to store the formatted times
$formattedTimes = array();

// Loop through the 24-hour range
for ($time = strtotime('09:00'); $time <= strtotime('21:00'); $time += 1800) {
    $hour = date('H:i', $time);

// Check if the time slot occurs only once
    if ($timeOccurrences[$hour] <= 1) {
       $arrei .= '{"id":'.json_encode($hour).',"emri":'.json_encode($hour).'},';
    }
}

} catch (PDOException $e) {
    echo "Query failed: " . $e->getMessage();
}
}
    
    if($nid == "Customers"){
try {
    $selectedValues = explode(',', $selectedValue);
    $placeholders = rtrim(str_repeat('?,', count($selectedValues)), ',');
    
    $sql = $auth->runQuery("SELECT customers.*, dege.emri AS dege_name, CASE customers.status
        WHEN 1 THEN 'Active'
        WHEN 0 THEN 'Inactive'
      END AS status_text, CASE customers.lead
        WHEN 0 THEN 'Active'
        WHEN 1 THEN 'Hot'
        WHEN 2 THEN 'Warm'
        WHEN 3 THEN 'Cold'
      END AS lead_text, CASE customers.category
        WHEN 0 THEN 'Silver Card'
        WHEN 1 THEN 'Gold Card'
        WHEN 2 THEN 'Platinum Card'
      END AS category_text
    FROM customers
    LEFT JOIN dege ON customers.default_studio = dege.id
    WHERE customers.biznes_id = :biznes_id
    AND FIND_IN_SET(customers.default_studio, :selected_values) > 0");
    
    $sql->bindValue(':biznes_id', $biznes_id);
    $sql->bindValue(':selected_values', implode(',', $selectedValues));
    
    $sql->execute();

while ($row = $sql->fetch(PDO::FETCH_ASSOC)) {
        $arrei .= '{"id":"' . $row["id"] . '",
        "emri":' . json_encode($row["first_name"] . " " . $row["surname"]) . ',
        "category_text":' . json_encode($row["category_text"]) . ',
        "points":' . json_encode($row["points"]) . ',
        "lead_text":' . json_encode($row["lead_text"]) . ',
        "dege_name":' . json_encode($row["dege_name"]) . ',
        "telephone":' . json_encode($row["telephone"]) . ',
        "next_payment":' . json_encode(date("d.m.Y", strtotime($row["next_payment"]))) . ',
        "debit":' . json_encode($row["debit"]) . '
        },';
    }
} catch (PDOException $e) {
    echo "Query failed: " . $e->getMessage();
}

}
    
    
if($nid == "SherbimeTeShitura"){
try {
    $dt_mbarimit = date("Y-m-d");
$sql = $auth->runQuery("SELECT paketa.id as pid, paketa.name as pemri, sherbime_te_shitura.id as shid
       FROM sherbime_te_shitura
       LEFT JOIN paketa  ON paketa.id = sherbime_te_shitura.paketa_id
       WHERE sherbime_te_shitura.biznes_id =:biznes_id AND sherbime_te_shitura.customer_id = :customer_id AND sherbime_te_shitura.dt_mbarimit >= :dt_mbarimit");
$sql->execute(array(":biznes_id"=>$biznes_id,":customer_id"=>$selectedValue,":dt_mbarimit"=>$dt_mbarimit));
       while($row = $sql->fetch(PDO::FETCH_ASSOC)){
        $arrei .= '{"id":"'.$row["shid"].'-'.$row["pid"].'","emri":'.json_encode($row["pemri"]).'},';
        }
} catch (PDOException $e) {
    echo "Query failed: " . $e->getMessage();
}
    }
    
    
    if($nid == "Punonjes"){
try {
$sql = $auth->runQuery("SELECT id, emri, atesia, mbiemri, departament_id FROM punonjes WHERE biznes_id =:biznes_id AND aktiv = :aktiv AND fshir = :fshir AND pushuar = :pushuar AND CONCAT(',', departament_id, ',') REGEXP ',(" . str_replace(',', '|', $departament_id) . "),'");
$sql->execute(array(":biznes_id"=>$biznes_id,":aktiv"=>"1",":fshir"=>"0",":pushuar"=>"0"));

while($row = $sql->fetch(PDO::FETCH_ASSOC)){
        $arrei .= '{"id":"'.$row["id"].'"
            ,"emri":'.json_encode($row["emri"].' '.$row["atesia"].' '.$row["mbiemri"]).'
            ,"cel":'.json_encode($row["cel"]).'
            ,"adresa":'.json_encode($row["adresa"].", ".$row["qyteti"]).'
            ,"totali":'.json_encode($row["departament_id"]).'
            ,"data":'.json_encode($row["adresa"].", ".$row["qyteti"]).'
			,"linku": '.json_encode($linku).'
			},';
        }
} catch (PDOException $e) {
    echo "Query failed: " . $e->getMessage();
}
    }
    
if($nid == "NormaTeKryera"){
try {
$sql = $auth->runQuery("SELECT id, data_normes, norma, vlera FROM norma_te_kryera WHERE biznes_id =:biznes_id AND fshir = :fshir AND punonjes_id = :punonjes_id order by id desc");
$sql->execute(array(":biznes_id"=>$biznes_id, ":fshir"=>"0",":punonjes_id"=>$user_id));

while($row = $sql->fetch(PDO::FETCH_ASSOC)){
        $arrei .= '{"id":"'.$row["id"].'"
            ,"emri":'.json_encode(date("d.m.Y", strtotime($row["data_normes"]))).'
            ,"cel": "NormaTeKryera"
            ,"data":'.json_encode(number_format($row["norma"])).'
            ,"totali":'.json_encode(number_format($row["vlera"])).'
            ,"adresa":'.json_encode($row["adresa"].", ".$row["qyteti"]).'
			,"linku": '.json_encode($linku).'
			},';
        }
} catch (PDOException $e) {
    echo "Query failed: " . $e->getMessage();
}
    }
    if($nid == "NormaTeKryeraData"){
try {
$sql = $auth->runQuery("SELECT ntkd.id, ntkd.data_normes, ntkd.sasia, ntkd.cmimi, n.emri 
                        FROM norma_te_kryera_data ntkd 
                        JOIN norma n ON ntkd.norme_id = n.id 
                        WHERE ntkd.biznes_id = :biznes_id 
                        AND ntkd.fshir = :fshir 
                        AND ntkd.punonjes_id = :punonjes_id 
                        AND ntkd.norma_te_kryera_id = :norma_te_kryera_id 
                        ORDER BY ntkd.id ASC");
$sql->execute(array(":biznes_id"=>$biznes_id, ":fshir"=>"0",":norma_te_kryera_id"=>$departament_id,":punonjes_id"=>$user_id));

while($row = $sql->fetch(PDO::FETCH_ASSOC)){
        $arrei .= '{"id":"'.$row["id"].'"
            ,"emri":'.json_encode($row["emri"]).'
            ,"cel": "NormaTeKryera"
            ,"data":'.json_encode(number_format($row["sasia"])).'
            ,"totali":'.json_encode(number_format($row["sasia"] * $row["cmimi"])).'
            ,"adresa":'.json_encode($row["adresa"].", ".$row["qyteti"]).'
			,"linku": '.json_encode($linku).'
			},';
        }
} catch (PDOException $e) {
    echo "Query failed: " . $e->getMessage();
}
    }
    
if($nid == "Paga"){
try {
    
$month = date("m");
$year = date("Y");
$punonjesi = $auth->runQuery("SELECT p.id as id, p.emri as emri, p.atesia as atesia, p.tipi_pageses as tipi_pageses, p.kategoria_profesionit as kategoria_profesionit, p.kategoria_sigurimit as kategoria_sigurimit,  p.nrpersonal as nrpersonal, p.mbiemri as mbiemri, p.fillon as fillon, p.ditet_e_punes as ditet_e_punes,p.paga_deklaruar, p.vlera_pageses as vlera_pageses,
    (SELECT COUNT(*) FROM mungesa_data WHERE punonjes_id = p.id AND hiq = 1 AND fshir = 0 AND data_mungeses BETWEEN '".$year."-".$month."-01' AND '".$year."-".$month."-31') AS ditet_e_munguara,
    IFNULL(SUM(n.cmimi * n.sasia), 0) AS total_norma,
    (SELECT IFNULL(SUM(vlera), 0) FROM parapagim WHERE punonjes_id = p.id AND data_parapagimit BETWEEN '".$year."-".$month."-01' AND '".$year."-".$month."-31' AND fshir = 0) AS parapagim_total,
    IFNULL(SUM(n.cmimi * n.sasia), 0) + p.vlera_pageses + (SELECT IFNULL(SUM(vlera), 0) FROM parapagim WHERE punonjes_id = p.id AND data_parapagimit BETWEEN '".$year."-".$month."-01' AND '".$year."-".$month."-31' AND fshir = 0) AS totali,
    IF(rnp.data_fillimit BETWEEN '".$year."-".$month."-01' AND '".$year."-".$month."-31', ABS(DATEDIFF(rnp.data_fillimit, '".$year."-".$month."-01')), NULL) AS dt_fillimit_te_punes,
    DATEDIFF(lp.deri, lp.nga) AS leje_pune_diff
FROM punonjes AS p
LEFT JOIN norma_te_kryera_data AS n ON p.id = n.punonjes_id AND n.data_normes BETWEEN '".$year."-".$month."-01' AND '".$year."-".$month."-31' AND n.fshir = 0
LEFT JOIN leje_pune AS lp ON p.id = lp.punonjes_id AND lp.data BETWEEN '".$year."-".$month."-01' AND '".$year."-".$month."-31' AND lp.page = 'Jo' AND lp.fshir = 0
LEFT JOIN rikthim_ne_pune AS rnp ON p.id = rnp.punonjes_id AND rnp.fshir = 0
WHERE p.pushuar = 0 AND p.biznes_id = :biznes_id AND p.id = :id GROUP BY p.id, p.emri, p.atesia, p.mbiemri, p.vlera_pageses");
$punonjesi->execute(array(":biznes_id"=>$biznes_id, ":id"=>$user_id));
$punonjesi_row = $punonjesi->fetch(PDO::FETCH_ASSOC);
 $daysOfWork = explode(',', $punonjesi_row["ditet_e_punes"]);
 $workingDays = working_days($year, $month, $daysOfWork);
 if($punonjesi_row["paga_deklaruar"] == "" || $punonjesi_row["paga_deklaruar"] == "0") {
 $punonjesi_row["paga_deklaruar"] = $punonjesi_row["vlera_pageses"];
 }
 if ($workingDays == 0) {
 $pagese_ditore = $punonjesi_row["paga_deklaruar"];
 } else {
 $pagese_ditore = $punonjesi_row["paga_deklaruar"] / $workingDays;
 }
 $ditet_e_munguara = $pagese_ditore * $punonjesi_row["ditet_e_munguara"];
 $dt_fillimit_te_punes = $pagese_ditore * $punonjesi_row["dt_fillimit_te_punes"];
 $leje_pune_diff = $pagese_ditore * $punonjesi_row["leje_pune_diff"];
 $totali_rroges = $punonjesi_row["paga_deklaruar"] + $punonjesi_row["total_norma"];
 $vlera_e_zbritur = $ditet_e_munguara + $dt_fillimit_te_punes + $leje_pune_diff + $punonjesi_row["parapagim_total"];
 if($punonjesi_row["tipi_pageses"] != "Bruto") {
    $rroga_neto = $totali_rroges - $vlera_e_zbritur;
    $gross_wage = get_employee_salary_net_to_gross($rroga_neto);
 } else {
    $gross_wage = $totali_rroges - $vlera_e_zbritur;
    $rroga_neto = get_employee_salary_gross_to_net($gross_wage);
 }
$employee_social_security_contribution = get_employee_social_tax($gross_wage);
$employee_health_insurance_contribution = get_employee_health_tax($gross_wage);
$employer_social_security_contribution = get_employer_social_tax($gross_wage);
$employer_health_insurance_contribution = get_employer_health_tax($gross_wage);
$income_tax = tap_tax($gross_wage);

$arrei .= '{"id":"0","emri":"Emertimi","cel": "Paga","data":"","totali":"Vlera","adresa":"","linku": ""},';
$arrei .= '{"id":"'.$row["id"].'","emri":"Paga","cel": "Paga","data":"","totali":'.json_encode(number_format($punonjesi_row["vlera_pageses"])).',"adresa":"","linku": ""},';
$arrei .= '{"id":"'.$row["id"].'","emri":"Norma","cel": "Paga","data":"","totali":'.json_encode(number_format($punonjesi_row["total_norma"])).',"adresa":"","linku": ""},';
$arrei .= '{"id":"'.$row["id"].'","emri":"Mungesa","cel": "Paga","data":"","totali":'.json_encode(number_format($punonjesi_row["ditet_e_munguara"])).',"adresa":"","linku": ""},';
$arrei .= '{"id":"'.$row["id"].'","emri":"V. Mungesave","cel": "Paga","data":"","totali":'.json_encode(number_format($vlera_e_zbritur)).',"adresa":"","linku": ""},';
$arrei .= '{"id":"'.$row["id"].'","emri":"S. Shoqerore","cel": "Paga","data":"","totali":'.json_encode(number_format($employee_social_security_contribution)).',"adresa":"","linku": ""},';
$arrei .= '{"id":"'.$row["id"].'","emri":"S. Shendetesore","cel": "Paga","data":"","totali":'.json_encode(number_format($employee_health_insurance_contribution)).',"adresa":"","linku": ""},';
$arrei .= '{"id":"'.$row["id"].'","emri":"TAP","cel": "Paga","data":"","totali":'.json_encode(number_format($income_tax)).',"adresa":"","linku": ""},';
$arrei .= '{"id":"'.$row["id"].'","emri":"Paga Neto","cel": "Paga","data":"","totali":'.json_encode(number_format($rroga_neto)).',"adresa":"","linku": ""},';
$arrei .= '{"id":"'.$row["id"].'","emri":"Paga Bruto","cel": "Paga","data":"","totali":'.json_encode(number_format($gross_wage)).',"adresa":"","linku": ""},';
        
} catch (PDOException $e) {
    echo "Query failed: " . $e->getMessage();
}
    }

if($nid == "Normat"){
try {
    $sql = $auth->runQuery("SELECT id, emri, cmimi FROM norma WHERE biznes_id =:biznes_id AND aktiv = :aktiv AND fshir = :fshir  AND CONCAT(',', departamente, ',') REGEXP ',(" . str_replace(',', '|', $departament_id) . "),'");
    $sql->execute(array(":biznes_id"=>$biznes_id,":aktiv"=>"1",":fshir"=>"0"));
    while($row = $sql->fetch(PDO::FETCH_ASSOC)){
        $arrei .= '{"id":"'.$row["id"].'","emri":'.json_encode($row["emri"]).',"cel":'.json_encode($row["cmimi"]).',"adresa": "","totali": "","data": "","linku": ""},';
    }
} catch (PDOException $e) {
    echo "Error executing SQL query: " . $e->getMessage();
}
    }
if($nid == "Departamente"){
try {
    $sql = $auth->runQuery("SELECT id, emri FROM departamente WHERE biznes_id =:biznes_id AND aktiv = :aktiv AND fshir = :fshir AND id IN ($departament_id)");
    $sql->execute(array(":biznes_id"=>$biznes_id,":aktiv"=>"1",":fshir"=>"0"));
    while($row = $sql->fetch(PDO::FETCH_ASSOC)){
        $arrei .= '{"id":"'.$row["id"].'","emri":'.json_encode($row["emri"]).',"cel":"Departamente","adresa": "","totali": "","data": "","linku": ""},';
    }
} catch (PDOException $e) {
    echo "Error executing SQL query: " . $e->getMessage();
}
    }
    if($nid == "Problematike"){
        $sql3 = "SELECT * FROM `pako` where shperndaresi  = '".$user_id."' AND (statusi = '5' OR statusi = '6') AND magazinuar = '0' order by radhit asc";
        $result3 = $conn->query($sql3);
        while($to3 = $result3->fetch_assoc()){
   		$linku = "https://www.express24.al/login/printo_fature.php?code=".$to3['trackingcode']."&user_id=".$user_id;
        $arrei .= '{"id":"'.$to3["id"].'"
            ,"emri":'.json_encode($to3["emri"]).'
            ,"cel":'.json_encode($to3["cel"]).'
            ,"adresa":'.json_encode($to3["adresa"]).'
            ,"totali":'.json_encode(number_format($to3["vlera"])." ".$to3["valuta"]).'
            ,"data":'.json_encode($to3["adresa"].", ".$to3["qyteti"]).'
			,"linku": '.json_encode($linku).'
			},';
        }
    }
	    if($nid == "Biznese"){
        $sql3 = "SELECT * FROM `biznese` order by emri asc";
        $result3 = $conn->query($sql3);
        while($to3 = $result3->fetch_assoc()){
        $arrei .= '{"id":"'.$to3["id"].'"
            ,"emri":'.json_encode($to3["emri"]).'
           },';
        }
    }
		    if($nid == "Klient"){
        $sql3 = "SELECT * FROM `klient` WHERE biznes_id = '$biznes_id' order by emri asc";
        $result3 = $conn->query($sql3);
        while($to3 = $result3->fetch_assoc()){
        $arrei .= '{"id":"'.$to3["id"].'"
            ,"emri":'.json_encode($to3["emri"].", ".$to3["cel"].", ".$to3["adresa"].", ".$to3["qyteti"].", ".$to3["shteti"]).'
           },';
        }
    }
	     if($nid == "Qytete"){
			 if($shid=="Shqipëri"){
				 $shid = "1";
			 } else if($shid=="Kosovë") {
				 $shid = "2";
			 } else if($shid=="Maqedoni") {
				 $shid = "3";
			 }  
        $sql3 = "SELECT * FROM `qytete` WHERE shid = '$shid' AND aktiv = '1' order by emri asc";
        $result3 = $conn->query($sql3);
        while($to3 = $result3->fetch_assoc()){
        $arrei .= '{"id":"'.$to3["id"].'"
            ,"emri":'.json_encode($to3["emri"]).'
           },';
        }
    }
    if($nid == "Pickup"){
        $sql3 = "SELECT * FROM `pickup` where motorristi  = '".$user_id."' AND statusi = '1' order by data,ora asc";
        $result3 = $conn->query($sql3);
        while($to3 = $result3->fetch_assoc()){
			
			
        $bem = $conn->query("SELECT emri, adresa, cel FROM `biznese` where id  = '$to3[biznes_id]' ");
        $bemer = $bem->fetch_assoc();
        $arrei .= '{"id":"'.$to3["id"].'"
            ,"emri":'.json_encode($bemer["emri"]." - ".date("d/m", strtotime($to3["data"]))." ".$to3["ora"]).'
            ,"data":'.json_encode($to3["pako"]." Pako, ".$to3["shenime"].", ".$bemer["adresa"]).'
            ,"totali":'.json_encode($to3["koordinata"]).'
            ,"linku":'.json_encode($bemer["cel"]).'
            ,"cel":""
			},';
        }
    }
	
    $conn->close();
    echo rtrim($arrei,",");

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

Batal

⬅ Naik ke login 7 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁Android	dir	—	2021-02-12 17:03	📂 Buka
📁Ios	dir	—	2022-11-12 00:21	📂 Buka
🐘get_data.php	php	22.3 KB	2023-06-25 22:16	✏️ Edit 👁️ View
🐘get_data2.php	php	6.4 KB	2021-02-17 15:43	✏️ Edit 👁️ View
🐘lidhu_me_db_new.php	php	469 B	2023-05-21 16:14	✏️ Edit 👁️ View
🐘post_data.php	php	97.6 KB	2023-06-16 03:25	✏️ Edit 👁️ View
🐘post_data2.php	php	5.3 KB	2022-11-12 00:20	✏️ Edit 👁️ View