دالة الاسعار ajax

import 'package:flutter/material.dart';
import 'package:flutter_local_notifications/flutter_local_notifications.dart';

void main() => runApp(MyApp());

class MyApp extends StatelessWidget {
  @override
  Widget build(BuildContext context) {
    return MaterialApp(
      title: 'Local Notifications Example',
      theme: ThemeData(
        primarySwatch: Colors.blue,
      ),
      home: MyHomePage(),
    );
  }
}

class MyHomePage extends StatelessWidget {
  final FlutterLocalNotificationsPlugin flutterLocalNotificationsPlugin =
      FlutterLocalNotificationsPlugin();

  @override
  Widget build(BuildContext context) {
    return Scaffold(
      appBar: AppBar(
        title: Text('Local Notifications Example'),
      ),
      body: Center(
        child: ElevatedButton(
          onPressed: () {
            _showNotification();
          },
          child: Text('Show Notification'),
        ),
      ),
    );
  }

  Future<void> _showNotification() async {
    const AndroidInitializationSettings initializationSettingsAndroid =
        AndroidInitializationSettings('@mipmap/ic_launcher');

    final InitializationSettings initializationSettings =
        InitializationSettings(android: initializationSettingsAndroid);

    await flutterLocalNotificationsPlugin.initialize(
      initializationSettings,
    );

    const AndroidNotificationDetails androidPlatformChannelSpecifics =
        AndroidNotificationDetails(
      'your channel id',
      'your channel name',
      importance: Importance.max,
      priority: Priority.high,
    );

    const NotificationDetails platformChannelSpecifics =
        NotificationDetails(android: androidPlatformChannelSpecifics);

    await flutterLocalNotificationsPlugin.show(
      0,
      'Notification Title',
      'Notification Body',
      platformChannelSpecifics,
      payload: 'Notification Payload',
    );
  }
}

function ajax_price()
{


    $product_id = $_GET['product_id'];
    $weight = $_GET['weight'];

    $gold_price_karats = get_post_meta($product_id, 'gold_price_karats', true);
    $extra_fee = get_post_meta($product_id, 'gold_price_product_fee', true);
    $extra_fee = empty($extra_fee) ? 0 : $extra_fee;
    $latest_id = get_latest_id_from_gold_table();
    $record_last = get_gold_record_by_id($latest_id);
    if ($record_last) {

        $weight = empty($weight) ? 1 : $weight;

        $id = $record_last['id'];
        $price_gram_24k = $record_last['price_gram_24k'] * $weight + $extra_fee;
        $price_gram_22k = $record_last['price_gram_22k'] * $weight + $extra_fee;
        $price_gram_21k = $record_last['price_gram_21k'] * $weight + $extra_fee;
        $price_gram_20k = $record_last['price_gram_20k'] * $weight + $extra_fee;
        $price_gram_18k = $record_last['price_gram_18k'] * $weight + $extra_fee;
        $price_gram_16k = $record_last['price_gram_16k'] * $weight + $extra_fee;
        $price_gram_14k = $record_last['price_gram_14k'] * $weight + $extra_fee;
        $price_gram_10k = $record_last['price_gram_10k'] * $weight + $extra_fee;
        $timestamp = $record_last['timestamp'];
        $gold_price_karats = get_post_meta($product_id, 'gold_price_karats', true);
    }

    if ($gold_price_karats == "14k") {
     
        $response = array('price' => $price_gram_14k);
        wp_send_json_success($response);


echo $price_gram_14k;
        // update_post_meta($product_id, 'custom_price_field', $price_gram_14k);


    } elseif ($gold_price_karats == "18k") {
       
        $response = array('price' => $price_gram_18k . " " . "ريال");
        wp_send_json_success($response);

    } elseif ($gold_price_karats == "22k") {

        $response = array('price' => $price_gram_22k . " " . "ريال");
        wp_send_json_success($response);
    } elseif ($gold_price_karats == "24k") {

        $response = array('price' => $price_gram_24k . " " . "ريال");
        wp_send_json_success($response);
    } elseif ($gold_price_karats == "21k") {
 
    $response = array('price' => $price_gram_21k . " " . "ريال");
        wp_send_json_success($response);
    } elseif ($gold_price_karats == "20k") {
  
    $response = array('price' => $price_gram_20k . " " . "ريال");
        wp_send_json_success($response);
    } elseif ($gold_price_karats == "18k") {

 $response = array('price' => $price_gram_18k . " " . "ريال");
        wp_send_json_success($response);
    } elseif ($gold_price_karats == "16k") {
        
 $response = array('price' => $price_gram_16k . " " . "ريال");
        wp_send_json_success($response);
  
    } elseif ($gold_price_karats == "10k") {

$response = array('price' => $price_gram_10k . " " . "ريال");
        wp_send_json_success($response);
    }else{
        $response = array('price' => 0 . " " . "ريال");
        wp_send_json_success($response);
        
        
    }

    wp_die(); // Always use wp_die() after echoing the response.


}

<link rel="preconnect" href="https://fonts.googleapis.com">
<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
<link href="https://fonts.googleapis.com/css2?family=Alexandria:wght@300&display=swap" rel="stylesheet">

<style>
    i.fas.fa-arrow-down {
        color: red;
    }

    i.fas.fa-arrow-up {
        color: yellowgreen;
    }

    i.fas.fa-circle {
        color: yellow;
    }

    po {
        color: white;
        font-size: 14px;
        font-family: 'Alexandria', sans-serif;
    }
    .fa-solid, .fas {
    font-family: "Font Awesome 6 Free" !important;
    font-weight: 900;
}
</style>
<div class="navbar" id="navGold">
    <?php
	
	function getGoldPrice($apiKey,$symbol) {
  
    $curr = "USD";
    $date = "";

    $url = "https://www.goldapi.io/api/{$symbol}/{$curr}{$date}";

    $myHeaders = array(
        'x-access-token: ' . $apiKey,
        'Content-Type: application/json'
    );

    $curl = curl_init();

    curl_setopt_array($curl, array(
        CURLOPT_URL => $url,
        CURLOPT_RETURNTRANSFER => true,
        CURLOPT_FOLLOWLOCATION => true,
        CURLOPT_HTTPHEADER => $myHeaders
    ));

    $response = curl_exec($curl);
    $error = curl_error($curl);

    curl_close($curl);

    if ($error) {
        return 'Error: ' . $error;
    } else {
        $data = json_decode($response, true);

        // Check if the response contains a 'price' key
        if (isset($data['price'])) {
            return $data['price'];
        } 
    }
}
	
	function fetchDataAndInsertIntoDatabase($pdo)
	{
		$apiKey = "goldapi-xxd2ktl4miz8nf-io";
		$symbol = "XAU";
		$curr = "SAR";
		$date = "";
		$myHeaders = array(
		'x-access-token: ' . $apiKey,
		'Content-Type: application/json'
		);

		$curl = curl_init();
		$url = "https://www.goldapi.io/api/{$symbol}/{$curr}{$date}";

		curl_setopt_array($curl, array(
		CURLOPT_URL => $url,
		CURLOPT_RETURNTRANSFER => true,
		CURLOPT_FOLLOWLOCATION => true,
		CURLOPT_HTTPHEADER => $myHeaders
		));
		$response = curl_exec($curl);
		$error = curl_error($curl);
		curl_close($curl);

		if ($error) {
		//	echo 'Error: ' . $error;
		} else {
			$data = json_decode($response, true);
			if ($data !== null) {
				$price_gram_24k = $data['price_gram_24k'];
				$price_gram_22k = $data['price_gram_22k'];
				$price_gram_21k = $data['price_gram_21k'];
				$price_gram_20k = $data['price_gram_20k'];
				$price_gram_18k = $data['price_gram_18k'];
				$price_gram_16k = $data['price_gram_16k'];
				$price_gram_14k = $data['price_gram_14k'];
				$price_gram_10k = $data['price_gram_10k'];
				$timestamp = $data['timestamp'];
				$goldPrice = getGoldPrice($apiKey,$symbol);

				try {
					$stmt = $pdo->prepare("INSERT INTO gold (price_gram_24k, price_gram_22k, price_gram_21k, price_gram_20k, price_gram_18k, price_gram_16k, price_gram_14k, price_gram_10k, timestamp,price) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?,?)");

				// 	$stmt->execute([$price_gram_24k,$price_gram_22k, $price_gram_21k, $price_gram_20k, $price_gram_18k, $price_gram_16k,$price_gram_14k,$price_gram_10k, $timestamp,$goldPrice]);
					$stmt->execute([rand(100000,200000),rand(100000,200000), rand(100000,200000), rand(100000,200000), rand(100000,200000), rand(100000,200000),rand(100000,200000),rand(100000,200000), $timestamp,$goldPrice]);

					// echo 'Data inserted successfully!';
				} catch (PDOException $e) {
				//	echo 'Error: ' . $e->getMessage();
				} finally {
					$pdo = null;
				}
			} else {
			//	echo 'Error decoding JSON';
			}
		}
	}



	function getLastButOneRecord($pdo)
	{
		try {
			$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			$sql = "SELECT * FROM gold ORDER BY id DESC LIMIT 1 OFFSET 1";
			$statement = $pdo->query($sql);
			$result = $statement->fetch(PDO::FETCH_ASSOC);
			$pdo = null;
			return $result;
		} catch (PDOException $e) {
		}
	}
	function icon($current_price, $previous_price)
	{
		$icon = '';

		if ($current_price > $previous_price) {
			$icon = 'fas fa-arrow-up';
		} elseif ($current_price < $previous_price) {
			$icon = 'fas fa-arrow-down';
		} else {
			$icon = 'fas fa-circle';
		}
		return $icon;
	}
	function display_price_status($current_price, $previous_price, $string)
	{
		$icon=icon($current_price,$previous_price);  // سيحتوي على النص الناتج
		return     $result = sprintf(
		"<a href='#'><i class=%s>&nbsp;&nbsp;<po>%s</po> : %s</i></a>",
		$string,
		$current_price
		);// تعديل النص الناتج حسب الحالة
	}
	$host = 'localhost';
	$dbname = 'bahrgold_aa';
	$username = 'bahrgold_aa';
	$password = 'm-rScfOBs39u';
	try {
// 		$pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
// 		$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
// 		fetchDataAndInsertIntoDatabase($pdo);
		$sqlLatest = "SELECT * FROM gold ORDER BY id DESC LIMIT 1";
		$stmtLatest = $pdo->query($sqlLatest);
// 		$rowLatest = $stmtLatest->fetch();
         $rowLatest=array();
         $rowLatest['price_gram_24k'] = '';
         $rowLatest['price_gram_22k'] = '';
         $rowLatest['price_gram_21k'] = '';
         $rowLatest['price_gram_20k'] = '';
         $rowLatest['price_gram_18k'] = '';
         $rowLatest['price_gram_16k'] = '';
         $rowLatest['price_gram_14k'] = '';
         $rowLatest['price_gram_10k'] = '';
		$currentFilePath = __FILE__;
		$currentFilePath;
		if ($rowLatest['price_gram_10k'] !== '') {
// 			$id = $rowLatest['id'];
			$price_gram_24k_latest = $rowLatest['price_gram_24k'];
			$price_gram_22k_latest = $rowLatest['price_gram_22k'];
			$price_gram_21k_latest = $rowLatest['price_gram_21k'];
			$price_gram_20k_latest = $rowLatest['price_gram_20k'];
			$price_gram_18k_latest = $rowLatest['price_gram_18k'];
			$price_gram_16k_latest = $rowLatest['price_gram_16k'];
			$price_gram_14k_latest = $rowLatest['price_gram_14k'];
			$price_gram_10k_latest = $rowLatest['price_gram_10k'];
			$timestamp_latest = $rowLatest['timestamp'];
	        $price = $rowLatest['price'];
			$rowPrevious=getLastButOneRecord($pdo);
			$price_gram_24k_previous = $rowPrevious['price_gram_24k'];
			$price_gram_22k_previous = $rowPrevious['price_gram_22k'];
			$price_gram_21k_previous = $rowPrevious['price_gram_21k'];
			$price_gram_20k_previous = $rowPrevious['price_gram_20k'];
			$price_gram_18k_previous = $rowPrevious['price_gram_18k'];
			$price_gram_16k_previous = $rowPrevious['price_gram_16k'];
			$price_gram_14k_previous = $rowPrevious['price_gram_14k'];
			$price_gram_10k_previous = $rowPrevious['price_gram_10k'];
			$timestamp_previous = $rowPrevious['timestamp'];
            $price_previous = $rowPrevious['price'];
			function displayPriceChange($latestPrice, $previousPrice, $caliber)
			{
				if ($latestPrice > $previousPrice) {
					$icon = 'fas fa-arrow-up';
				} elseif ($latestPrice < $previousPrice) {
					$icon = 'fas fa-arrow-down';
				} else {
					$icon = 'fas fa-arrow-up';
				}
				$latestPrice=round($latestPrice,2);
				echo sprintf(
				"<a href='#'>  &nbsp;<i class='%s'>&nbsp;&nbsp;<po>%s</po> : %s  </i> &nbsp;ريال   &nbsp;</a>",
				$icon,
				$caliber,
				$latestPrice,
				);
			}
		function displayPriceChange__($latestPrice, $previousPrice, $caliber)
			{
				if ($latestPrice > $previousPrice) {
					$icon = 'fas fa-arrow-up';
				} elseif ($latestPrice < $previousPrice) {
					$icon = 'fas fa-arrow-down';
				} else {
					$icon = 'fas fa-arrow-up';
				}
				$latestPrice=round($latestPrice,2);
				echo sprintf(
				"<a href='#'>  &nbsp;<i class='%s'>&nbsp;&nbsp;<po>%s</po> : %s  </i> </a>",
				$icon,
				$caliber,
				$latestPrice,
				);
			}
			displayPriceChange($price_gram_24k_latest, $price_gram_24k_previous, " عيار 24");
            displayPriceChange($price_gram_22k_latest, $price_gram_22k_previous, " عيار 22");
			displayPriceChange($price_gram_21k_latest, $price_gram_21k_previous, " عيار 21");
			displayPriceChange($price_gram_18k_latest, $price_gram_18k_previous, " عيار 18");
			displayPriceChange__($price, $price_previous, "الاونصة" );




		} else {
	//		echo "لم يتم العثور على سجلات";
		}

	} catch (PDOException $e) {
		// التعامل مع الأخطاء في حالة حدوث أي استثناء
	//	echo "خطأ في الاتصال بقاعدة البيانات: " . $e->getMessage();
	}
	?>
</div>