function olahxls_penempatan($POST,$FILES) {
  global $ar,$db;
  require_once $ar['path_core'].'dom/simplexlsx.php';
  $dt=[];
  if ($xlsx=SimpleXLSX::parse($FILES["xlsfile"]["tmp_name"]) ) {
    foreach($xlsx->rows() as $k=>$r) {
      if ($k>0){
        if($r[0]!='') {
          $dt[$k] = [
            'porsi' => $r[0],
            'nama' => $r[1],
            'lp' => $r[2],
            'usia' => $r[3],
            'no_rumah' => $r[4],
            'hotel' => $r[5],
            'gedung' => $r[6],
            'lantai' => $r[7],
            'kamar' => $r[8],
            'romb' => $r[9],
            'regu' => $r[10],
            'lahir' => $r[11],
            'paspor' => $r[12],
            'visa' => $r[13],
            'emb' => $r[14],
            'klt' => $r[15]
          ];           
        }
      }
    }
    //echo "<pre>"; print_r($csv); echo "</pre>";
    echo '<textarea class="form-control" rows="10">'.json_encode($dt).'></textarea>';
    $code=$dt[1]['emb']."".$dt[1]['klt'];
    $emb=$dt[1]['emb'];
    $klt=$dt[1]['klt'];
    echo "rows: ".count($dt)."; ".$dt[1]['emb']."".$dt[1]['klt']."<br>";
    if($dt[1]['gedung']!='' && $dt[1]['no_rumah']!='' && $dt[1]['no_kamar']!='') {
      foreach ($dt as $k => $v) {
        if(strlen($v['no_rumah'])>3) {
          $sektor=substr($v['no_rumah'],0,2);
        } else {
          $sektor=substr($v['no_rumah'],0,1);                
        }
        $el=explode("/",$v['lahir']);
        if($v['umur']>64) {
          $lan=1;
        } else {
          $lan=0;
        }

        $idt=array(
          'emb'=>$v['emb'],
          'klt'=>$v['klt'],
          'porsi'=>$v['porsi'],
          'nama'=>gpc($v['nama']),
          'paspor'=>$v['paspor'],
          'visa'=>$v['visa'],
          'lp'=>$v['lp'],
          'romb'=>$v['romb'],
          'regu'=>$v['regu'],
          'usia'=>$v['umur'],
          'daker'=>$_POST['daker'],
          'gel'=>$_POST['gel'],
          'lan'=>$lan,
          'nama_hotel'=>gpc($v['hotel']),
          'no_rumah'=>$v['no_rumah'],
          'gedung'=>$v['gedung'],
          'no_lantai'=>$v['lantai'],
          'no_kamar'=>$v['kamar'],
          'sektor'=>$sektor,
          'tgl_lahir'=>$el[2]."-".$el[1]."-".$el[0],
        );
        $udt=array(
          'nama_hotel'=>gpc($v['hotel']),
          'no_rumah'=>$v['no_rumah'],
          'gedung'=>$v['gedung'],
          'no_lantai'=>$v['lantai'],
          'no_kamar'=>$v['kamar'],
          'sektor'=>$sektor,
          'tgl_lahir'=>$el[2]."-".$el[1]."-".$el[0],
        );
        InsertUpdate($db,"penempatan",$idt,$udt,1);
      }
      $sql1="SELECT * from myhotel where `code`='".$code."' and daker='".$_POST['daker']."' and gel='".$_POST['gel']."'";
      $res1=mysqli_query($db,$sql1);
      $r1=mysqli_fetch_assoc($res1);
      if($r1['in_hotel_time']>0) {
        $udt1=array(
          'in_hotel_time'=>$r1['in_hotel_time'],
          'in_hotel_date'=>$r1['in_hotel_date'],
          'update_at'=>time(),
        );

        if($r1['out_hotel_time']>0) {
          $udt1['out_hotel_time']=$r1['out_hotel_time'];
          $udt1['out_hotel_date']=$r1['out_hotel_dete'];
        }
        if($r1['kitchen_code']!='') {
          $udt1['kitchen_code']=$r1['kitchen_code'];
        }
        Update($db,"penempatan",$udt1,"`emb`='".$r1['emb']."' and klt='".$r1['klt']."' and no_rumah='".$r1['hotel_no']."' and daker='".$r1['daker']."' and gel='".$r1['gel']."'",1);
      }
      $sql2="SELECT hp1,paspor from hp_petugas where `emb`='".$emb."' and klt='".$klt."'";
      $res2=mysqli_query($db,$sql2);
      while($r2=mysqli_fetch_assoc($res2)) {
        $udt2=array(
          'hpid'=>$r2['hp1'],
        );
        Update($db,"penempatan",$udt2,"paspor='".$r2['paspor']."'",1);
      }
      tool_kloter_lp();
      tool_kloter_lan_lp() ;
      tool_kloter_manifest();
      tool_kloter_ptg_lp();
      tool_hotel_lp();
      tool_hotel_lan_lp() ;
      tool_hotel_manifest();
      tool_hotel_ptg_lp();
    } else {
      echo "data kamar masih kosong<br>";
    }
  } else {
    echo "tak ada data<br>";
  }
}