<?php
$dt=update_armada_byday($_GET['d']);
echo json_encode($dt);

function update_armada_byday($tg=0) {
  global $db,$ar;
  $dt=array();

  if($tg==0) {
    $tgl=date('Y-m-d');
  } else {
    $tgl=date('Y-m-d', strtotime('-'.$tg.' days'));
  }

  $sql1="SELECT 
    kd_armada,
    lambung,
    dr_ccd,
    to_ccd,
    armada_kelas,
    dr_time,
    count(*) as jseat_bagasi,
    sum(harga_tiket) as omset_tiket,
    sum(total) as omset_total

  from bagasi where tgl='".$tgl."' group by kd_armada";
  $dt['sql']=$sql1;
  $res1=mysqli_query($db,$sql1);
  while($r3=mysqli_fetch_assoc($res1)) {
      $idt3=array(
        'tgl'=>$tgl,
        'lambung'=>$r3['lambung'],
        'kode_rute_armada'=>$r3['kd_armada'],
        'dr_time'=>$r3['dr_time'],
        'dr_ccd'=>$r3['dr_ccd'],
        'to_ccd'=>$r3['to_ccd'],
        'kursi_terjual'=>$r3['jseat_bagasi'],
        'estimasi_omset'=>$r3['omset_tiket'],
        'harga_tiket'=>$r3['omset_tiket'],
        'kelas_id'=>$r3['armada_kelas'],
        'create_at'=>time(),
      );
      $udt3=array(
        'lambung'=>$r3['lambung'],
        'dr_ccd'=>$r3['dr_ccd'],
        'to_ccd'=>$r3['to_ccd'],
        'kursi_terjual'=>$r3['jseat_bagasi'],
        'estimasi_omset'=>$r3['omset_tiket'],
        'harga_tiket'=>$r3['omset_tiket'],
        'update_at'=>time(),
      );
      InsertUpdate($db,"armada_daily",$idt3,$udt3,$v);  
    }

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