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

function post_spionam($json) {
  global $db;
  //file_put_contents($noken.".json", $json);
  $time_start = microtime(true);
  $dt=array();
  $js=json_decode($json,true);
  //$dt['jjs']=$js;

  $id=$js['id'];
  $jsc=$js['company'];
  $udt2=array(
    'name'=>$jsc['NamaPerusahaan'],
    'provincy'=>$jsc['Provinsi'],
    'address'=>$jsc['AlamatPerusahaan'],
    'nodejs_at'=>time(),
  );
  Update($db,"company",$udt2,"id=".$js['id'],0);
  
  $udt3=array(
    'spionam_st'=>2,
  );
  Update($db,"car",$udt3,"company_id=".$id,0);
  Update($db,"vehicle",$udt3,"cid=".$id,0);
  Update($db,"ngekir",$udt3,"cid=".$id,0);
  Update($db,"car_tax",$udt3,"cid=".$id,0);
  Update($db,"blue",$udt3,"cid=".$id,0);
  Update($db,"noken",$udt3,"cid=".$id,0);
  
  $jsa=$js['trayek'];
  foreach ($jsa as $k => $v) {
    $eu=explode("-",$v['TglAkhirUji']);
    $ek=explode("-",$v['TglAkhirKPS']);
      $idt=array(
        'noken'=>$v['NoKendaraan'],
        'company_id'=>$id,
        'company_name'=>$jsc['NamaPerusahaan'],
        'provincy'=>$jsc['Provinsi'],
        'jenis_angkutan'=>$v['JenisAngkutan'],
        'trayek_kendaraan'=>$v['NamaTrayek'],
        'trayek_rute'=>$v['RuteTrayek'],
        'uji_berkala_no'=>NoSpace($v['NoUji']),
        'uji_berkala_masa'=>strtotime($v['TglAkhirUji']),
        'merk'=>$v['Merek'],
        'kps_no'=>$v['NoKPS'],
        'kps_masa'=>strtotime($v['TglAkhirKPS']),
        'group_company_id'=>167,
        'armada'=>'orang',
        'spionam_st'=>1,
        'create_at'=>time(),
      );

      $udt=array(
        'company_id'=>$id,
        'company_name'=>$jsc['NamaPerusahaan'],
        'provincy'=>$jsc['Provinsi'],
        'jenis_angkutan'=>$v['JenisAngkutan'],
        'trayek_kendaraan'=>$v['NamaTrayek'],
        'trayek_rute'=>$v['RuteTrayek'],
        'uji_berkala_no'=>NoSpace($v['NoUji']),
        'uji_berkala_masa'=>strtotime($v['TglAkhirUji']),
        'merk'=>$v['Merek'],
        'kps_no'=>$v['NoKPS'],
        'kps_masa'=>strtotime($v['TglAkhirKPS']),
        'group_company_id'=>167,
        'armada'=>'orang',
        'spionam_st'=>1,
        'update_at'=>time(),
      );
      InsertUpdate($db,"car",$idt,$udt,0);
      $udt1=array(
        'spionam_st'=>1,        
      );

      $idt1b=array(
        'noken'=>$v['NoKendaraan'],
        'cid'=>$id,
        'spionam_st'=>1,        
        'is_trayek'=>1,        
        'uji_no'=>NoSpace($v['NoUji']),
        'merk'=>$v['Merek'],
        'uji_exp'=>$eu[2]."-".$eu[1]."-".$eu[0],
        'kps_exp'=>$ek[2]."-".$ek[1]."-".$ek[0],
        'create_at'=>time(),
      );

      $udt1b=array(
        'spionam_st'=>1,        
        'is_trayek'=>1,        
        'uji_no'=>NoSpace($v['NoUji']),
        'merk'=>$v['Merek'],
        //'uji_exp'=>$eu[2]."-".$eu[1]."-".$eu[0],
        'kps_exp'=>$ek[2]."-".$ek[1]."-".$ek[0],
        'cid'=>$id,
      );
      $dt['udt1'][$k]=$udt1b;
      //Update($db,"noken",$udt1b,"noken='".$v['nopol']."'",0); 
      InsertUpdate($db,"noken",$idt1b,$udt1b,0);

      $idt3=array(
        'nopol'=>$v['NoKendaraan'],
        'cid'=>$id,
        'spionam_st'=>1,        
      );
      $udt3=array(
        'spionam_st'=>1,        
        'cid'=>$id,
        'update_at'=>time(),
      );    
      InsertUpdate($db,"vehicle",$idt3,$udt3,0);
      $idt4=array(
        'noken'=>$v['NoKendaraan'],
        'cid'=>$id,
        'spionam_st'=>1,        
      );
      InsertUpdate($db,"blue",$idt4,$udt3,0);
      InsertUpdate($db,"ngekir",$idt4,$udt3,0);
      InsertUpdate($db,"car_tax",$idt4,$udt3,0);
  }
    
  $jsb=$js['nontrayek'];
  foreach ($jsb as $k => $v) {
    $eu=explode("-",$v['TglAkhirUji']);
    $ek=explode("-",$v['TglAkhirKPS']);
    $idt=array(
      'noken'=>$v['NoKendaraan'],
      'company_id'=>$id,
      'company_name'=>$jsc['NamaPerusahaan'],
      'provincy'=>$jsc['Provinsi'],
      'jenis_angkutan'=>$v['JenisAngkutan'],
      'uji_berkala_no'=>NoSpace($v['NoUji']),
      'uji_berkala_masa'=>strtotime($v['TglAkhirUji']),
      'merk'=>$v['Merek'],
      'kps_no'=>$v['NoKPS'],
      'kps_masa'=>strtotime($v['TglAkhirKPS']),
      'armada'=>'orang',
      'group_company_id'=>167,
      'spionam_st'=>1,
      'create_at'=>time(),
    );

    $udt=array(
      'company_id'=>$id,
      'company_name'=>$jsc['NamaPerusahaan'],
      'provincy'=>$jsc['Provinsi'],
      'jenis_angkutan'=>$v['JenisAngkutan'],
      'uji_berkala_no'=>NoSpace($v['NoUji']),
      'uji_berkala_masa'=>strtotime($v['TglAkhirUji']),
      'merk'=>$v['Merek'],
      'kps_no'=>$v['NoKPS'],
      'kps_masa'=>strtotime($v['TglAkhirKPS']),
      'armada'=>'orang',
      'spionam_st'=>1,
      'group_company_id'=>167,
      'update_at'=>time(),
    );
    InsertUpdate($db,"car",$idt,$udt,0);
    $udt1=array(
      'spionam_st'=>1,        
    );

    $idt1b=array(
      'noken'=>$v['NoKendaraan'],
      'cid'=>$id,
      'spionam_st'=>1,        
      'uji_no'=>NoSpace($v['NoUji']),
      'merk'=>$v['Merek'],
      'uji_exp'=>$eu[2]."-".$eu[1]."-".$eu[0],
      'kps_exp'=>$ek[2]."-".$ek[1]."-".$ek[0],
      'create_at'=>time(),
    );

    $udt1b=array(
      'spionam_st'=>1,        
      'uji_no'=>NoSpace($v['NoUji']),
      'merk'=>$v['Merek'],
      //'uji_exp'=>$eu[2]."-".$eu[1]."-".$eu[0],
      'kps_exp'=>$ek[2]."-".$ek[1]."-".$ek[0],
      'cid'=>$id,
    );
    $dt['udt2'][$k]=$udt1b;
    InsertUpdate($db,"noken",$idt1b,$udt1b,0);

    $idt3=array(
      'nopol'=>$v['NoKendaraan'],
      'cid'=>$id,
      'spionam_st'=>1,        
    );
    $udt3=array(
      'spionam_st'=>1,        
      'cid'=>$id,
      'update_at'=>time(),
    );    
    InsertUpdate($db,"vehicle",$idt3,$udt3,0);
    $idt4=array(
      'noken'=>$v['NoKendaraan'],
      'cid'=>$id,
      'spionam_st'=>1,        
    );
    InsertUpdate($db,"blue",$idt4,$udt3,0);
    InsertUpdate($db,"ngekir",$idt4,$udt3,0);
    InsertUpdate($db,"car_tax",$idt4,$udt3,0);
  }  
  $sql7="UPDATE noken set `own`=2 where cid=167 or cid=217 or cid=802";
  $res7=mysqli_query($db,$sql7);
  $dt['message']="upload successfully";
  $db->close();
  /* */
  $time_end = microtime(true);
  $time_execution = $time_end-$time_start;  
  $dt['time_query']=$time_execution;
  return $dt;
} 
?>