<?php
$dt=selisih_bagasi($_GET);
echo json_encode($dt);
function selisih_bagasi($g) {
  global $db,$ar;
  $dt=$dt1=$dt2=$dt3=array();
  if(isset($g['day']) && $g['day']!='') {
    $tgl=date("Y-m-d",strtotime('-'.$g['day'].' days'));    
  } else {
    $tgl=date("Y-m-d");
  }

  $sql3="SELECT berangkat_id,kelas_id,kode_rute_armada as kd_armada,kode_rute,lambung,nopol,dr_time,to_time,jalan,st_kebid from `daily_rute_price` where tgl='".$tgl."'";
  $res3=mysqli_query($db,$sql3);
  if(mysqli_num_rows($res3)>0) {
    while($r3=mysqli_fetch_assoc($res3)) {
      $dt3[$r3['berangkat_id']]=$r3;
    }
  } 

  $sql2="SELECT kebid,kelas_id from `penumpang` where tgl='".$tgl."' group by kebid,kelas_id order by kebid";
  $res2=mysqli_query($db,$sql2);
  if(mysqli_num_rows($res2)>0) {
    while($r2=mysqli_fetch_assoc($res2)) {
      $dt2[$r2['kebid']]=$r2;
    }
  } 

  $sql1="SELECT kebid,kelas_id from `bagasi` where tgl='".$tgl."' group by kebid,kelas_id order by kebid";
  $res1=mysqli_query($db,$sql1);
  if(mysqli_num_rows($res1)>0) {
    $e=0;
    while($r1=mysqli_fetch_assoc($res1)) {
      $dt1[$e]=$r1['kebid'];
      $e++;
    }
  } 

  $d=0;
  foreach ($dt2 as $k2 => $v2) {
    if(!in_array($k2,$dt1)) {
      if(isset($dt3[$k2]['kelas_id']) && isset($dt3[$k2]['kd_armada'])) {
        $dt['data'][$d]['berangkat_id']=$k2;
        $dt['data'][$d]['kelas_id']=$dt3[$k2]['kelas_id'];
        $dt['data'][$d]['kd_armada']=$dt3[$k2]['kd_armada'];
        $dt['data'][$d]['kode_rute']=$dt3[$k2]['kode_rute'];
        $dt['data'][$d]['lambung']=$dt3[$k2]['lambung'];
        $dt['data'][$d]['dr_time']=$dt3[$k2]['dr_time'];
        $dt['data'][$d]['to_time']=$dt3[$k2]['to_time'];
        $dt['data'][$d]['jalan']=$dt3[$k2]['jalan'];
        $dt['data'][$d]['st_kebid']=$dt3[$k2]['st_kebid'];
        $dt['data'][$d]['tgl']=$tgl;
      $d++;          
      }
    }
  }  
  $dt['count']=$d;


return $dt;
$db->close();
} 
?>