<?php
$dt=post_blue($_POST['noken'],$_POST['json']);
echo json_encode($dt);
//$dt2=js_noken();

function post_blue($noken,$json) {
  global $db;
  //file_put_contents($noken.".json", $json);
  $time_start = microtime(true);
  $et=array();
  $js=json_decode($json,true);
  $jsc=$js['data']['data_blue'];
  $udt3=array(
    'st_blue'=>2,
    'update_at'=>time(),
  );
  Update($db,"vehicle",$udt3,"`nopol`='".$noken."'",0);
  
  //$jsa=json_decode($js2,true);
  $idt=array(
    'id'=>$jsc['blue_id'],
    'noken'=>$noken,
    'date'=>$jsc['date'],
    'masa_berlaku'=>$jsc['masa_berlaku'],
    'jenis_kendaraan'=>$jsc['jenis_kendaraan'],
    'keterangan'=>$jsc['keterangan_hasil_uji'],
    'merk'=>$jsc['merk'],
    'no_uji'=>$jsc['no_uji_kendaraan'],
    'srut_no'=>$jsc['no_srut'],
    'srut_tgl'=>$jsc['tgl_srut'],
    'pelaksana'=>$jsc['unit_pelaksana_teknis'],
    'create_at'=>time(),
  );

  $udt=array(
    'date'=>$jsc['date'],
    'masa_berlaku'=>$jsc['masa_berlaku'],
    'jenis_kendaraan'=>$jsc['jenis_kendaraan'],
    'keterangan'=>$jsc['keterangan_hasil_uji'],
    'merk'=>$jsc['merk'],
    'no_uji'=>$jsc['no_uji_kendaraan'],
    'srut_no'=>$jsc['no_srut'],
    'srut_tgl'=>$jsc['tgl_srut'],
    'pelaksana'=>$jsc['unit_pelaksana_teknis'],
    'update_at'=>time(),
  );

  $udt2=array(
    'uji_exp'=>$jsc['masa_berlaku'],
    'uji_no'=>$jsc['no_uji_kendaraan'],
    'blue_id'=>$jsc['blue_id'],
    'st_blue'=>2,
    'update_at'=>time(),
  );

  $jss=$js['data']['data_spionam'];
  if(isset($jss['spionam_id'])) {
    $idt['spionam_id']=$udt['spionam_id']=$udt2['spionam_id']=$jss['spionam_id'];
    //Update($db,"armada_v2",$udt3,"noken='".$noken."'",0);
  } 

  if(isset($jss['no_kps'])) {
    $idt['kps_no']=$udt['kps_no']=$jss['no_kps'];
  } 

  if(isset($jss['jenis_pelayanan'])) {
    $idt['jenis_layanan']=$udt['jenis_layanan']=$jss['jenis_pelayanan'];
  } 
  if(isset($jss['seat'])) {
    $idt['seat']=$udt['seat']=$jss['seat'];
  } 
  if(isset($jsc['blue_id'])) {
    InsertUpdate($db,"blue",$idt,$udt,0);
    Update($db,"noken",$udt2,"noken='".$noken."'",0);
  }
  $et['udt']=$udt2;
  $et['message']="upload successfully";
  $db->close();
  $time_end = microtime(true);
  $time_execution = $time_end-$time_start;  
  $et['time_query']=$time_execution;
  return $et;
} 
?>