<?php
$dt=get_nl_kelas_armada();
echo json_encode($dt);

function get_nl_kelas_armada() {
  $dt=array();
  $time_start = microtime(true);
  global $db,$ar;
  $a=0;
  $sql2="SELECT 
    lambung,
    noken,
    tgl_last,
    id
  from `armada_v2` where `kelas_armada`=0";
  //$dt['sql']=$sql2;
  
  $res2=mysqli_query($db,$sql2);
  if(mysqli_num_rows($res2)>0) {
    $dt['count']=mysqli_num_rows($res2);
    while($r2=mysqli_fetch_assoc($res2)) {
      $sql3="SELECT armada_kelas from daily_rute_price where lambung=".$r2['lambung']." and nopol='".$r2['noken']."' order by tgl desc limit 1";
      $res3=mysqli_query($db,$sql3);
      if(mysqli_num_rows($res3)==1) {
        $r3=mysqli_fetch_assoc($res3);
        $udt=array(
          'kelas_armada'=>$r3['armada_kelas'],
        );
        Update($db,"armada_v2",$udt,"lambung=".$r2['lambung']." and noken='".$r2['noken']."' and tgl_last='".$r2['tgl_last']."'",0);
        $dt[$a]=$r2;
        $a++;
      }
    }
  } else {
    $dt['count']=0;
  }
  $db->close();
  $time_end = microtime(true);
  $time_execution = $time_end-$time_start;  
  $dt['time_query']=$time_execution;
  return $dt;
}
?>