<?php
$dt=post_sakpol($_POST['noken'],$_POST['json']);
echo json_encode($dt);

function post_sakpol($noken,$json) {
  global $db,$ar;
  $time_start = microtime(true);
  $dt=array();
  //file_put_contents($noken.".json", $json);
  $js2=json_decode($json,true);
  $et1=explode("-",$js2['tgl_jatuh_tempo']);
  $et2=explode("-",$js2['tgl_stnk']);
  if($js2['Status']=='000') {
    $udt=array(
      'json'    =>json_encode($js2),
      'json_st' =>$js2['Status'],  
      'merk'    =>$js2['merek'],  
      'th_rakit'=>$js2['thn_buat'],  
      'model'   =>$js2['model'],  
      'tipe'    =>strtoupper($js2['tipe']),  
      'cylinder'=>$js2['cylinder'],  
      'sumbu'   =>$js2['jml_sumbu'],  
      'warna'   =>$js2['WarnaKB'],  
      'bbm'     =>$js2['bbm'],  
      'tax_exp' =>$et1[2]."-".$et1[1]."-".$et1[0],  
      'stnk_exp'=>$et2[2]."-".$et2[1]."-".$et2[0],   
      'pkb'     =>to_numeric($js2['rincian'][0]['pokok_pkb'])+to_numeric($js2['rincian'][0]['pokok_pkb_opsen']),  
      'swdkllj' =>to_numeric($js2['rincian'][0]['pokok_jr']), 
      'total'   =>to_numeric($js2['rincian'][0]['total']),  
      'st'=>1,
      'update_at'=>time(), 
    );  
    Update($db,"car_tax",$udt,"`noken`='".$noken."'",0);
    $udt2=array(
      'tax_exp' =>$et1[2]."-".$et1[1]."-".$et1[0],  
      'tipe'    =>strtoupper($js2['tipe']),  
      'th_rakit'=>$js2['thn_buat'],  
      'stnk_exp'=>$et2[2]."-".$et2[1]."-".$et2[0],   
      'taxjs_st' =>$js2['Status'],  
    );
    Update($db,"noken",$udt2,"`noken`='".$noken."'",0);
  } else {
    $udt=array(
      'json_st' =>$js2['Status'],  
      'st'=>1,
      'update_at'=>time(), 
    );  
    Update($db,"car_tax",$udt,"`noken`='".$noken."'",0);
    $udt2=array(
      'taxjs_st' =>$js2['Status'],  
    );
    Update($db,"noken",$udt2,"`noken`='".$noken."'",0);    
  }
  $dt['udt']=$udt;
  $dt['status']=true;
  $dt['message']="upload successfully";
  //echo json_encode($dt);
  $db->close();
  $time_end = microtime(true);
  $time_execution = $time_end-$time_start;  
  $dt['time_query']=$time_execution;
  return $dt;
} 

?>