function olahxls_manifest($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] = [
            'no' => $r[0],
            'emb' => $r[1],
            'klt' => $r[2],
            'urut' => $r[3],
            'porsi' => $r[4],
            'nama' => $r[5],
            'paspor' => $r[6],
            'visa' => $r[7],
            'lp' => $r[8],
            'romb' => $r[9],
            'regu' => $r[10],
            'tugas' => $r[11],
            'kokab' => $r[12],
            'umur' => $r[13]
          ];           
        }
      }
    }
    //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)." ".$code."<br>";
    foreach ($dt as $k => $v) {
      if($v['umur']>64) {
        $lan=1;
      } else {
        $lan=0;
      }
      $idt=array(
        'emb'=>$v['emb'],
        'klt'=>$v['klt'],
        'urut'=>$v['urut'],
        'porsi'=>$v['porsi'],
        'nama'=>gpc($v['nama']),
        'paspor'=>$v['paspor'],
        'visa'=>$v['visa'],
        'lp'=>$v['lp'],
        'romb'=>$v['romb'],
        'regu'=>$v['regu'],
        'tugas'=>$v['tugas'],
        'jenis_petugas'=>trim($v['tugas']),
        'kokab'=>$v['kokab'],
        'usia'=>$v['umur'],
        'daker'=>$POST['daker'],
        'gel'=>$POST['gel'],
        'lan'=>$lan,
      );
      $udt=array(
        'emb'=>$v['emb'],
        'klt'=>$v['klt'],
        'urut'=>$v['urut'],
        'porsi'=>$v['porsi'],
        'nama'=>gpc($v['nama']),
        'paspor'=>$v['paspor'],
        'visa'=>$v['visa'],
        'lp'=>$v['lp'],
        'romb'=>$v['romb'],
        'regu'=>$v['regu'],
        'tugas'=>trim($v['tugas']),
        'jenis_petugas'=>trim($v['tugas']),
        'kokab'=>$v['kokab'],
        'usia'=>$v['umur'],
        'lan'=>$lan,
        'daker'=>$POST['daker'],
        'gel'=>$POST['gel'],
      );
      InsertUpdate($db,"penempatan",$idt,$udt,0);
    }
    tool_kloter_lp();
    tool_kloter_lan_lp() ;
    tool_kloter_manifest();
    tool_kloter_ptg_lp();
  } else {
    echo "tak ada data<br>";
  }
}