<?php
    require_once("../mainconfig.php");

        $check_provider = mysqli_query($db, "SELECT * FROM provider WHERE code = 'VECT'");
		$data_provider = mysqli_fetch_assoc($check_provider);
	// api data
		$api_link = $data_provider['link'];
		$api_key = $data_provider['api_key'];
		// end api data

        $postdata = "key=$api_key&action=service"; //MASUKAN APIKEYMU YG DI VECTPEDIA

        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $api_link);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_POSTFIELDS, $postdata);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
        $data = curl_exec($ch);
        // echo $result;
        $olah = json_decode($data, true);

        //echo $olah->result->service;
        $no = 1;
        foreach($olah as $datanya){
            $service = $datanya['service'];
            $category = $datanya['category'];
            $kode = $datanya['sid'];
            $status = $datanya['status'];
            $min = $datanya['min'];
            $max = $datanya['max'];
            $note = $datanya['note'];
            $price = $datanya['price'];

            $rate = 500; //TAMBAH HARGA BIAR UNTUNG
		    $totaly = $rate+$price;

		$cek_service = mysqli_query($db, "SELECT * FROM services WHERE sid = '$kode'");

		if (mysqli_num_rows($cek_service) > 0) {
			echo "Service $service => sudah ada<br>";
			$no++;
		} else {
			$input = mysqli_query($db, "INSERT INTO services (sid, category, service, note, min, max, price, status, pid, provider) VALUES ('$kode', '$category', '$service', '$note', '$min', '$max', '$totaly', 'Active', '$kode', 'VECT')");
			if ($input){
				echo "===============<br>Successfully Adding Services<br>Category: $category<br>Service: $service<br>Price: $totaly (+$rate)<br>Min: $min<br>Max: $max<br>Note: $note<br>Status: Active<br>===============<br>";
				$no++;
			}else{
				echo mysqli_error();
			}
				$no++;
		}
	}
?>