<?php
$dt=get_nl_byday($_GET);
echo json_encode($dt);

function get_nl_byday($js) {
  $dt=array();
  $time_start = microtime(true);
  global $db,$ar;
  $tg=date("Y-m-d",strtotime('-'.$js['d'].' days'));
  $a=0;
  $sql2="SELECT lambung,nopol as noken,kode_rute_armada as kd_armada,armada_kelas as kelas_armada,dr_time,dr_ccd,to_ccd,sum(jseat_bagasi) as kursi_terjual,sum(omset_tiket) as omset_tiket from `daily_rute_price` where tgl='".$tg."' and lambung>0 GROUP BY lambung";
  $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)) {
      if($r2['kursi_terjual']>0) {
        $jl=1;
      } else {
        $jl=0;
      }
      $idt=array(
        'tgl'=>$tg,
        'jalan'=>$jl,
        'lambung'=>$r2['lambung'],
        'noken'=>$r2['noken'],
        'kd_armada'=>$r2['kd_armada'],
        'kelas_armada'=>$r2['kelas_armada'],
        'dr_time'=>$r2['dr_time'],
        'dr_ccd'=>$r2['dr_ccd'],
        'to_ccd'=>$r2['to_ccd'],
        'kursi_terjual'=>$r2['kursi_terjual'],
        'omset_tiket'=>$r2['omset_tiket'],
        'update_at'=>time(),
      );
      $udt=array(
        'jalan'=>$jl,
        'noken'=>$r2['noken'],
        'kd_armada'=>$r2['kd_armada'],
        'kelas_armada'=>$r2['kelas_armada'],
        'dr_time'=>$r2['dr_time'],
        'dr_ccd'=>$r2['dr_ccd'],
        'to_ccd'=>$r2['to_ccd'],
        'kursi_terjual'=>$r2['kursi_terjual'],
        'omset_tiket'=>$r2['omset_tiket'],
        'update_at'=>time(),
      );
      InsertUpdate($db,"daily_lambung",$idt,$udt,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;
}
?>