STATUS BANK

<?php

/**
 * Code By : BAGUS ADETYO N
 * Date Edit : 28 - 09 - 2019
 * Dont Edit Anything If You Don't Know About Script
**/

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

$check_order = $db->query("SELECT * FROM orders_pulsa WHERE status IN ('Pending','Processing') AND provider = 'DPEDIA'");

if ($check_order->num_rows == 0) {
  die("Order Pending not found.");

} else {

  while($data_order = $check_order->fetch_array(MYSQLI_ASSOC)) {

    $o_oid = $data_order['oid'];
    $o_poid = $data_order['poid'];
    $o_provider = $data_order['provider'];

    $check_provider = $db->query("SELECT * FROM provider WHERE code = 'DPEDIA'");
    $data_provider = $check_provider->fetch_array(MYSQLI_ASSOC);

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

    if ($o_provider == "MANUAL") {
        echo "Order manual<br />";
    } else if ($o_provider == "DPEDIA") {
        $order_postdata = "api_key=$p_apikey&method=confirm&code_trx=$o_poid";
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, "https://serverh2h.id/order/bank");
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_POSTFIELDS, $order_postdata);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
        $chresult = curl_exec($ch);
      //echo $chresult;
        curl_close($ch);

        $order_data = json_decode($chresult, true);
        $status = $order_data['data']['status'];
        $serial_number = $order_data['data']['code_trx'];

    } else {
        echo "Not Found Provider Code";
    }

    if ($o_provider == "DPEDIA") {
        if ($status == "Pending") {
            $real_status = "Pending";
        } else if ($status == "Processing") {
            $real_status = "Processing";
        } else if ($status == "In Progress") {
            $real_status = "Processing";
        } else if ($status == "Partial") {
            $real_status = "Partial";
        } else if ($status == "Canceled") {
            $real_status = "Error";
        } else if ($status == "Error") {
            $real_status = "Error";
        } else if ($status == "Completed") {
            $real_status = "Success";
        } else if ($status == "sukses") {
            $real_status = "Success";
        } else {
            $real_status = "Pending";
        }
    }
    if (empty($real_status)) {
        $real_status = "Pending";
    }

    $update_order = $db->query("UPDATE orders_pulsa SET status = '$real_status', sn = '$serial_number' WHERE oid = '$o_oid'");
    if ($update_order == TRUE) {
      echo "Provider => $o_provider | Order ID => $o_oid | Status => $real_status | SN/Catatan => $serial_number<br />";
    } else {
      echo "Error database.";
    }
  }
}