<?php
$db = mysqli_connect('localhost','u201969863_root','Januari1699','u201969863_hg');

$check_order = mysqli_query($db, "SELECT * FROM order_line WHERE status IN ('Waiting','Pending','Processing','In progress') AND provider = 'irvan'");

if (mysqli_num_rows($check_order) == 0) {
  die("Order Pending not found.");
} else {
  while($data_order = mysqli_fetch_assoc($check_order)) {
    $o_oid = $data_order['order_id'];
    $o_poid = $data_order['order_id'];
    $o_provider = $data_order['provider'];
  if ($o_provider == "MANUAL") {
    echo "Order manual<br />";
  } else {

    $check_provider = mysqli_query($db, "SELECT * FROM provider WHERE code = '$o_provider'");
    $data_provider = mysqli_fetch_assoc($check_provider);

    $p_apikey = $data_provider['api_key'];
    $p_link = $data_provider['link'];

    if ($o_provider == "irvan") {
      $api_postdata = "api_key=$p_apikey&id=$o_poid";
    } else {
      die("System error!");
    }

   $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, "https://irvankede-smm.co.id/api/status");
    curl_setopt($ch, CURLOPT_POST, 1);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $api_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);
    print_r($json_result);

      if ($o_provider == "irvan") {
          $u_status = $json_result->data->status;
          $u_start = $json_result->data->start_count;
          $u_remains = $json_result->data->remains;
         if ($u_status == "Pending") {
            $un_status = "Pending";
         } else if ($u_status == "Processing") {
            $un_status = "In progress";
         } else if ($u_status == "Partial") {
            $un_status = "Partial";
         } else if ($u_status == "Error") {
            $un_status = "Canceled";
         } else if ($u_status == "Success") {
            $un_status = "Completed";
         } else {
             $un_status = "Pending";
         }
        }
    $update_order = mysqli_query($db, "UPDATE order_line SET status = '$un_status', remains = '$u_remains', start_count = '$u_start' WHERE order_id = '$o_poid'");
    if ($update_order == TRUE) {
      echo "ID Web: $o_oid<br />ID Pusat: $o_poid<br /> Status: $un_status<br /> Remains: $u_remains<br /><br />";
    } else {
      echo "Error database.";
    }
  }
  }
}