<?php
$dt=ricar();
echo json_encode($dt);
function ricar() {
  global $db,$ar;
  $dt=array();
  $dt1=array();
  $dt2=array();
  $dt3=array();
  $dt4=array();
  $today=time();

  $sql1="SELECT noken,model,tipe,merk,cylinder,sumbu,warna,bbm,th_rakit,tax_exp,stnk_exp,total,spionam_st,cid from `car_tax` where cid=167 or cid=217 or cid=802 order by noken";
  $res1=mysqli_query($db,$sql1);
  while($r1=mysqli_fetch_assoc($res1)) {
    $str_stnk=strtotime($r1['stnk_exp']);
    $str_tax =strtotime($r1['tax_exp']);

    $dt1[$r1['noken']]=$r1;
    $dt1[$r1['noken']]['total_rp']=ang2($r1['total']);
    if($today<$str_tax) {
      $dt1[$r1['noken']]['stnk_st']='lunas';
    } else {
      $dt1[$r1['noken']]['stnk_st']='terlambat';      
    }
  }  

  $sql2="SELECT noken,jenis_angkutan,kps_no,kps_masa,trayek_kendaraan,jenis_layanan,seat,uji_berkala_no,uji_berkala_masa,nomor_rangka,nomor_mesin,nomor_srut,armada,spionam_st,update_at from `car` where company_id=167 or company_id=217 or company_id=802 order by noken";
  $res2=mysqli_query($db,$sql2);
  //$dt['count']=mysqli_num_rows($res2);
  if(mysqli_num_rows($res2)>0) {
    $a=0;
    while($r2=mysqli_fetch_assoc($res2)) {
      $dt2[$r2['noken']]=$r2;
      $dt2[$r2['noken']]['update_at']=date("Y-m-d H:i:s",$r2['update_at']);
      $dt2[$r2['noken']]['kps_end']=date("Y-m-d",$r2['kps_masa']);
      $dt2[$r2['noken']]['uji_berkala_end']=date("Y-m-d",$r2['uji_berkala_masa']);
      if($today<$r2['kps_masa']) {
        $dt2[$r2['noken']]['kps_st']='aktif/berlaku';
      } else {
        $dt2[$r2['noken']]['kps_st']='terlambat';      
      }
      $a++;
    }
  } 

  $sql4="SELECT id,noken,spionam_id,no_uji,masa_berlaku,jenis_kendaraan,merk,srut_no,kps_no,srut_tgl,kps_exp_tgl,pelaksana,spionam_st,cid from `blue` where cid=167 or cid=217 or cid=802 order by noken";
  $res4=mysqli_query($db,$sql4);
  while($r4=mysqli_fetch_assoc($res4)) {
    $str_uji=strtotime($r4['masa_berlaku']);
    $dt4[$r4['noken']]=$r4;
    if($today<$str_uji) {
      $dt4[$r4['noken']]['uji_st']='aktif/berlaku';
    } else {
      $dt4[$r4['noken']]['uji_st']='terlambat';      
    }
  }  


  $sql3="SELECT lambung from `armada_v2` where `lambung`>0  group by lambung order by lambung";
  //echo $sql.";<br>";
  $res3=mysqli_query($db,$sql3);
  $dt['count']['all']=mysqli_num_rows($res3);
  while($r3=mysqli_fetch_assoc($res3)) {
    $sql4="SELECT noken from `armada_v2` where lambung=".$r3['lambung']." and `noken`!='' order by tgl_last desc limit 1";
    //echo $sql.";<br>";
    $res4=mysqli_query($db,$sql4);
    $r4=mysqli_fetch_assoc($res4);
    $dt['bynl'][$r3['lambung']]['noken']=$r4['noken'];
    $dt['bynl'][$r3['lambung']]['tax']=$dt1[$r4['noken']];
    $dt['bynl'][$r3['lambung']]['spionam']=$dt2[$r4['noken']];
    $dt['bynl'][$r3['lambung']]['blue']=$dt4[$r4['noken']];
  }
  file_put_contents($ar['app_path']."js/ricar.json", json_encode($dt)); 
  //echo json_encode($dt);
return $dt;
$db->close();
} 
?>