<?php
$dt=cek_rute_time_v1();
echo json_encode($dt);
function cek_rute_time_v1() {
  global $db,$ar;
  $dt=array();
  $sql2="SELECT `kode_pergi`, `dr_time`, `to_time`, `hplus`, `dr_agen`, `to_agen`, `jalur_id`, `cek_time`, `penawaran`, `id`
FROM `trayek`
WHERE `penawaran` > '0' AND `cek_time` = '0' and (to_time='' or to_time is null) order by penawaran desc";
  $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)) {

      $sql3="SELECT to_time,ket_hplus from daily_price where kode_rute='".$r2['kode_pergi']."' and dr_agen=".$r2['dr_agen']." and to_agen=".$r2['to_agen']." and (to_time!='' or to_time is not null) order by tgl desc limit 1";
      //$dt[$a]['sql']=$sql3;
      
      $res3=mysqli_query($db,$sql3);
      if(mysqli_num_rows($res3)>0) {
        $r3=mysqli_fetch_assoc($res3);
        if(strlen($r3['to_time'])>12) {
          $udt=array(
            'to_time'=>substr($r3['to_time'],12,5),
            'hplus'=>$r3['ket_hplus'],
            'cek_time'=>1,
            'update_at'=>time(),
          );
          update($db,"trayek",$udt,"kode_pergi='".$r2['kode_pergi']."' and dr_agen=".$r2['dr_agen']." and to_agen=".$r2['to_agen']." ",0);
        }
        $dt[$a]=$r3;
        $dt[$a]['kode_rute']=$r2['kode_pergi'];
        $dt[$a]['dr_agen']=$r2['dr_agen'];
        $dt[$a]['to_agen']=$r2['to_agen'];
      } 
      
      $a++;
    }
    
  } 
  //file_put_contents($ar['app_path']."js/uji_no.json", json_encode($dt)); 
  //echo json_encode($dt);
  return $dt;
  $db->close();
} 
?>