function agenda_g1_pergi($t) {
global $db,$ar;
$dt=[];
$sql="SELECT * from mykloter where `out_hotel_date`='".$t."' order by out_hotel_time";
$res=mysqli_query($db,$sql);
if(mysqli_num_rows($res)>0) {
$a=0;
while($r=mysqli_fetch_assoc($res)) {
$dt[$a]=$r;
$sql1="SELECT * from myhotel where code='".$r['code']."' order by out_hotel_time,id";
$res1=mysqli_query($db,$sql1);
$b=0;
while($r1=mysqli_fetch_assoc($res1)) {
$dt[$a]['hotel'][$b]=$r1;
$b++;
}
$a++;
}
?>
<h4 class="purple-text text-darken-4">Keberangkatan Hari ke-<?=$ar['tgl3day'][$t];?> dari Madinah Sektor 5</h4>
<div class="row border_top purple lighten-5 fw-900 purple-text text-darken-4">
<div class="col-4">Kedatangan Kloter di Saudi Arabia</div>
<div class="col-8">Penempatan Hotel</div>
</div>
<div class="row border_top border_bottom purple lighten-5 fw-500">
<div class="col-4">
<div class="row">
<div class="col-1">No</div>
<div class="col-2">Kode</div>
<div class="col-1">Srk</div>
<div class="col-2">Flight</div>
<div class="col-1">Tgl</div>
<div class="col-1">Jam</div>
<div class="col-1">JHI</div>
<div class="col-1">Prp</div>
<div class="col-2">Lansia</div>
</div>
</div>
<div class="col-8">
<div class="row">
<div class="col-1">CheckOut</div>
<div class="col-1">Tim</div>
<div class="col-1">No</div>
<div class="col-2">Nama Hotel</div>
<div class="col-1">Pax</div>
<div class="col-1">Kontrak</div>
<div class="col-1">Dapur</div>
<div class="col-2">Catering</div>
<div class="col-1">Bus</div>
<div class="col-1">No</div>
</div>
</div>
</div>
<?php
foreach ($dt as $k => $v) {
$lan=$v['lan_l']+$v['lan_p'];
?>
<div class="row border_bottom">
<div class="col-4">
<div class="row">
<div class="col-1"><?=$k+1;?></div>
<div class="col-2"><?=$v['code'];?></div>
<div class="col-1"><?=$v['syarikah'];?></div>
<div class="col-2"><?=$v['flight_no'];?></div>
<div class="col-1"><?=date("d/m",$v['sa_arrival_time']);?></div>
<div class="col-1"><?=date("H:i",$v['sa_arrival_time']);?></div>
<div class="col-1"><?=$v['total'];?></div>
<div class="col-1"><?=$v['j_p'];?></div>
<div class="col-2"><?=$lan;?></div>
</div>
</div>
<div class="col-8">
<?php
foreach ($v['hotel'] as $k1 => $r) {
if($r['med_sektor']==5) {
$light=' grey-text text-darken-4';
} else {
$light=' fw-300';
}
?>
<div class="row border_top<?=$light;?>">
<div class="col-1"><?=date("H:i",$r['out_hotel_time']);?></div>
<div class="col-1"><?=$r['teamwork'];?></div>
<div class="col-1"><?=$r['hotel_no'];?></div>
<div class="col-2"><?=$ar['med_hotel'][$r['hotel_no']];?></div>
<div class="col-1"><?=$r['pax'];?></div>
<div class="col-1"><?=$r['contract_no'];?></div>
<div class="col-1"><?=$r['kitchen_code'];?></div>
<div class="col-2"><?=$ar['catering'][$r['kitchen_code']];?></div>
<div class="col-1"><?=$r['out_bus'];?></div>
<div class="col-1"><?=$r['out_bus_no'];?></div>
</div>
<?php
}
?>
</div>
</div>
<?php
}
}
//echo "<pre>"; print_r($dt); echo "</pre>";
}