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

$check_order = mysqli_query($db, "SELECT * FROM orders WHERE status IN ('Pending','Processing')");

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['oid'];
    $o_poid = $data_order['poid'];
    $o_provider = $data_order['provider'];
  if ($o_provider == "MANUAL") {
    echo "Order manual<br />";
  } else {
		$check_provider = mysqli_query($db, "SELECT * FROM provider WHERE code = 'WS'");
		$data_provider = mysqli_fetch_assoc($check_provider);
			$p_link = $data_provider['link'];
			$p_apikey = $data_provider['api_key'];

		$api_postdata = "api_key=$p_apikey&action=status&id=$o_poid";

		$ch = curl_init();
		curl_setopt($ch, CURLOPT_URL, $p_link);
		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);

		if ($json_result['data']['status'] == "Pending") {
			$u_status = "Pending";
		} else if ($json_result['data']['status'] == "Processing") {
			$u_status = "Processing";
		} else if ($json_result['data']['status'] == "Partial") {
			$u_status = "Partial";
		} else if ($json_result['data']['status'] == "Error") {
			$u_status = "Error";
		} else if ($json_result['data']['status'] == "Success") {
			$u_status = "Success";
		} else {
			$u_status = "Pending";
		}

      $u_start = $json_result['data']['start_count'];
      $u_remains = $json_result['data']['remains'];

    $update_order = mysqli_query($db, "UPDATE orders SET status = '$u_status', start_count = '$u_start', remains = '$u_remains' WHERE poid = '$o_poid'");
    if ($update_order == TRUE) {
      echo "<br />ID Web: $o_oid<br />ID Pusat: $o_poid<br /> Status: $u_status<br /> Remains: $u_remains<br /><br />";
    } else {
      echo "Error database.";
    }
  }
  }
}c($ch);
		curl_close($ch);
		$json_result = json_decode($chresult, true);

		if ($json_result['data']['status'] == "Pending") {
			$u_status = "Pending";
		} else if ($json_result['data']['status'] == "Processing") {
			$u_status = "Processing";
		} else if ($json_result['data']['status'] == "Partial") {
			$u_status = "Partial";
		} else if ($json_result['data']['status'] == "Error") {
			$u_status = "Error";
		} else if ($json_result['data']['status'] == "Success") {
			$u_status = "Success";
		} else {
			$u_status = "Pending";
		}

      $u_start = $json_result['data']['start_count'];
      $u_remains = $json_result['data']['remains'];

    $update_order = mysqli_query($db, "UPDATE orders SET status = '$u_status', start_count = '$u_start', remains = '$u_remains' WHERE poid = '$o_poid'");
    if ($update_order == TRUE) {
      echo "<br />ID Web: $o_oid<br />ID Pusat: $o_poid<br /> Status: $u_status<br /> Remains: $u_remains<br /><br />";
    } else {
      echo "Error database.";
    }
  }