<?php
require '../config.php';

$cekmutasi = $is->query("SELECT * FROM deposit WHERE provider = 'OVO' AND status = 'Pending'");


while($mutasi = $cekmutasi->fetch_assoc()) {
    $end_date = new DateTime(date('Y-m-d'));
    $start_date = new DateTime($mutasi['daate']);
    $masa_berlaku = $start_date->diff($end_date);
    $data = array(

        "search" => array(

            "date" =>   array(

                "from" =>  $start_date,
                "to" => $end_date
                ),
            "account_number" => "083142182276",
            "amount" => $mutasi['quantity']
            )
        );

$ch = curl_init();
curl_setopt_array($ch, array(

    CURLOPT_URL => "https://api.cekmutasi.co.id/v1/ovo/search",
    CURLOPT_POST => TRUE,
    CURLOPT_POSTFIELDS => http_build_query($data),
    CURLOPT_HTTPHEADER => ["API-KEY:d673c04d0e7edacb81663caf8bb77d9b"],
    CURLOPT_SSL_VERIFYHOST => 0,
    CURLOPT_SSL_VERIFYPEER => 0,
    CURLOPT_RETURNTRANSFER => TRUE,
    CURLOPT_HEADER => FALSE,
    )
  );
  $chresult = curl_exec($ch);
  curl_close($ch);


  if($chresult['success'] == TRUE)
  {
      $cekdepo = $is->query("SELECT * FROM deposit WHERE quantity = '".$mutasi['quantity']."' AND status = 'Pending'");
      if($cekdepo->num_rows() == 0)
      {
          echo "Data Not Found";
      } else {
          $cekdepo = $cekdepo->fetch_array();
          $isuser = $is->query("SELECT * FROM user WHERE username = '".$mutasi['username']."' ");
          if($isuser->num_rows() > 0) {
              $isuser = $isuser->fetch_array();
              $zha = "UPDATE user SET saldo = '".$isuser['saldo'] + $cekdepo['quantity']."' WHERE username = '".$isuser['username']."'";
              $is->query($zha);
              $cha = "UPDATE deposit SET status = 'Success' WHERE id = '".$cekdepo['id']."' ";
              $is->query($chaa);

              echo "Deposit dengan Jumlah ".$cekdepo['quantity']." telah berhasil dan saldo sudah di terima";
          }

      }
  } else {
      $respon = $chresult['error_message'];

      echo $respon;
  }
}