<?php
require("../mainconfig.php");
$provider_name = "IRVAN";
$check_provider = mysqli_query($db, "SELECT * FROM provider WHERE code = '$provider_name'");
$data_provider = mysqli_fetch_assoc($check_provider);

$api_id = $data_provider['api_id'];
$api_key = $data_provider['api_key'];

$postdata = "api_id=$api_id&api_key=$api_key&action=services";
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "https://irvankede-smm.co.id/api/services");
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);
//echo $chresult;
curl_close($ch);
$result_data = json_decode($chresult, true);

if ($result_data['status'] == false) {
    echo $result_data['data'];
} else {
for ($i=1; $i <= count($result_data['data']); $i++)  {
    $price= 2000;
// daftar layanan


    $post_sid = $result_data['data'][$i]['id'];
    $post_cat = $result_data['data'][$i]['category'];
    $post_service = $result_data['data'][$i]['name'];
    $post_note = $result_data['data'][$i]['note'];
    $post_min = $result_data['data'][$i]['min'];
    $post_max = $result_data['data'][$i]['max'];
    $post_price = $result_data['data'][$i]['price']+$price;

    $check_cat = mysqli_query($db, "SELECT * FROM service_cat WHERE name = '$post_cat'");
    $data_cat = mysqli_fetch_assoc($check_cat);
    if (mysqli_num_rows($check_cat) == 0) {
        $insert_service = mysqli_query($db, "INSERT INTO service_cat (name, code, status) VALUES ('$post_cat', 'SM', 'Active')");
    } else {
        $post_cat = $data_cat['id'];
    }

        $insert_service = mysqli_query($db, "INSERT INTO services (category, service, note, min, max, price, status, pid, provider) VALUES ('$post_cat', '$post_service', '$post_note', '$post_min', '$post_max', '$post_price', 'Active', '$post_sid', '$provider_name')");

    if ($insert_service == TRUE) {
        echo "<b>Update:</b> $update | <b>SID:</b> $post_sid | <b>Service:</b> $real_service | <b>Note:</b> $real_note | <b>Min:</b> $post_min | <b>Max:</b> $post_max<br />";
    } else {
        echo mysqli_error($db);
    }
}
}