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

$delete = mysqli_query($db, "DELETE FROM service_pulsa");
$delete = mysqli_query($db, "DELETE FROM service_pulsa_cat");
if($delete) {
	$cek_provider = mysqli_query($db, "SELECT * FROM provider WHERE coe 'RETROPULSA'");
	$data_provider = mysqli_fetch_assoc($cek_provider);
	$api_key = $data_provider['api_key'];
	$url = $data_provider['link'];
	$postdata = "api_key=$api_key&action=layanan";

	$ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    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);
    $chresult = curl_exec($ch);
    curl_close($ch);
    $json_result = json_decode($chresult, true);
}

$no = "0";
$retro = "1";
$hitung = count($json_result['data']);
while ($no < $hitung) {
	$json_input = $json_result['data'][$no];
	$cat = $json_input['category'];
	$opt = $json_input['operator'];
	$serv = $json_input['service'];
	$cod = $json_input['code'];
	$price = $json_input['price'];
	$status = $json_input['status'];


	$harga = $price + 200; //Tambah harga biar lo untung

	$cek_cat = mysqli_query($db, "SELECT * FROM service_pulsa_cat WHERE code = '$cod'");
	if (mysqli_num_rows($cek_cat) > 0) {
	} else {
		$rtr = mysqli_query($db, "INSERT INTO service_pulsa_cat VALUES('$retro','$opt','$opt','$cat')");
	}
	$cek_serv = mysqli_query($db, "SELECT * FROM service_pulsa WHERE sid = '$cod'");
	if (mysqli_num_rows($cek_serv) > 0) {
		$result = "DATA SUDAH ADA DI DALAM DATABASE";
	} else {
		$rtr = mysqli_query($db, "INSERT INTO service_pulsa VALUES('sesuaikan sama struktur db kamu')");
		$result = "
		==========================<br />
		Succesfully Add Service
		Category: $cat<br />
		operator: $opt<br />
		Service: $serv<br />
		Harga: $harga<br />
		Provider: RETRO PULSA<br />
		==========================<br />
		";
	}
	$no++;
	$retro++;
	echo $result;
}
?>