<?php
	$token = $_GET['token'];
	$email = $_GET['email'];
	$nokant = $_GET['nokant'];
    $hosts = $_GET['hosts'];
    $alamat = "$hosts/konsol/datacabang/lap_kolektibilitas.php?"."token={$token}&email={$email}&nokant={$nokant}";	
	$data = file_get_contents($alamat);	
	$dataitem = json_decode($data);
	
	include "../cek_key.php";
	
	if ($cekey!=''){
		if($dataitem->status=== true){
			foreach ($dataitem->data as $nilai){
				
				$tahun = $nilai->TAHUN; 
				$bulan = $nilai->BULAN;
				$nokant = $nilai->NOKANT;
				$outs_lancar = $nilai->OUTS_LANCAR;
				$jumlah_lancar = $nilai->JUMLAH_LANCAR;
				$outs_dalam_perhatian_khusus = $nilai->OUTS_DALAM_PERHATIAN_KHUSUS; 
				$jumlah_dalam_perhatian_khusus = $nilai->JUMLAH_DALAM_PERHATIAN_KHUSUS;
				$outs_kurang_lancar = $nilai->OUTS_KURANG_LANCAR;
				$jumlah_kurang_lancar = $nilai->JUMLAH_KURANG_LANCAR;
				$outs_diragukan = $nilai->OUTS_DIRAGUKAN;
				$jumlah_diragukan = $nilai->JUMLAH_DIRAGUKAN;
				$outs_macet = $nilai->OUTS_MACET;
				$jumlah_macet = $nilai->JUMLAH_MACET;
				
				
				$sts= ibase_query($konek,"update or insert into kolektibilitas (tahun, bulan, nokant, outs_lancar, jumlah_lancar, outs_dalam_perhatian_khusus, jumlah_dalam_perhatian_khusus, outs_kurang_lancar, jumlah_kurang_lancar, outs_diragukan, jumlah_diragukan, outs_macet, jumlah_macet)
											values ($tahun, $bulan, '$nokant', $outs_lancar, $jumlah_lancar, $outs_dalam_perhatian_khusus, $jumlah_dalam_perhatian_khusus, $outs_kurang_lancar, $jumlah_kurang_lancar, $outs_diragukan, $jumlah_diragukan, $outs_macet, $jumlah_macet)
											matching (tahun, bulan, nokant)");
								
				 
			}
		}
		if($sts==1){$msg='Export Kolektibilitas Sukses !!!';}else{$msg='Export Kolektibilitas Gagal !!!';}
		echo json_encode($msg);

	}
	ibase_close($konek);
  
?>