function agenda_g2_datang($t) {
  global $db,$ar;
  $dt=[];
  $sql="SELECT * from mykloter where `in_hotel_date`='".$t."' order by in_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 id";
      $res1=mysqli_query($db,$sql1);
      $b=0;
      while($r1=mysqli_fetch_assoc($res1)) {
        $dt[$a]['hotel'][$b]=$r1;
        $b++;
      }  
      $a++;
    }
  ?>
  <h4 class="teal-text text-darken-5">Kedatangan Hari ke-<?=$ar['tgl4day'][$t];?> ke Madinah Sektor 5</h4>
    <div class="row border_top fw-900 green green lighten-5 teal-text text-darken-5">
      <div class="col-4">Keberangkatan dari Makkah</div>
      <div class="col-8">Penempatan Hotel</div>
    </div>
    <div class="row border_top border_bottom green green 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">Tgl</div>
          <div class="col-1">Jam</div>
          <div class="col-1">JHI</div>
          <div class="col-1">P</div>
          <div class="col-2">Lansia</div>
        </div>        
      </div>
      <div class="col-8">
        <div class="row">
          <div class="col-1">CheckIn</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"><?=date("d/m/Y",$v['in_hotel_time']-21600);?></div>
          <div class="col-1"><?=date("H:i",$v['in_hotel_time']-21600);?></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['in_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['in_bus'];?></div>
            <div class="col-1"><?=$r['in_bus_no'];?></div>
          </div>
          <?php
        }
        ?>
      </div>
    </div>
    <?php
    }
  ?>
  <br>
  <?php
  }
  //echo "<pre>"; print_r($dt); echo "</pre>";
}