function olahxls_pulang($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] = [
            'emb' => $r[0],
            'klt' => $r[1],
            //'hari' => $r[1],
            'tgl' => $r[3],
            'jam' => strtotime($r[3]),
            //'airline' => $r[4],
            //'flight' => $r[5],
            'qty' => $r[6],
            'noh1' => $r[7],
            'hotel1' => $r[8],
            'map1' => $r[9],
            'kap1' => $r[10],

            'noh2' => $r[11],
            'hotel2' => $r[12],
            'map2' => $r[13],
            'kap2' => $r[14],
            
            'noh3' => $r[15],
            'hotel3' => $r[16],
            'map3' => $r[17],
            'kap3' => $r[18],
            'code' => trim($r[0]).''.trim($r[1]),
            'flight_no' => trim($r[4]).''.trim($r[5]),
          ];           
        }
      }
    }
    //echo "<pre>"; print_r($csv); echo "</pre>";
    echo '<textarea class="form-control" rows="10">'.json_encode($dt).'></textarea>';
    echo "rows: ".count($dt)."<br>";
    echo "<pre>"; print_r($dt[1]); echo "</pre>";
    
    foreach ($dt as $k => $v) {
        $idt=array(
          'id'=>$k-1,
          'emb'=>$v['emb'],
          'klt'=>$v['klt'],
          'code'=>$v['code'],
          'tgl'=>$v['tgl'],
          'jam'=>$v['jam'],
          'flight_no'=>$v['flight_no'],
          'qty'=>$v['qty'],
          'noh1'=>$v['noh1'],
          'hotel1'=>gpc($v['hotel1']),
          'map1'=>$v['map1'],
          'kap1'=>$v['kap1'],
          'noh2'=>$v['noh2'],
          'hotel2'=>gpc($v['hotel2']),
          'map2'=>$v['map2'],
          'kap2'=>$v['kap2'],
          'noh3'=>$v['noh3'],
          'hotel3'=>gpc($v['hotel3']),
          'map3'=>$v['map3'],
          'kap3'=>$v['kap3'],
          'update_at'=>time(),
        );
        $udt=array(
          'emb'=>$v['emb'],
          'klt'=>$v['klt'],
          'code'=>$v['code'],
          'tgl'=>$v['tgl'],
          'jam'=>$v['jam'],
          'flight_no'=>$v['flight_no'],
          'qty'=>$v['qty'],
          'noh1'=>$v['noh1'],
          'hotel1'=>gpc($v['hotel1']),
          'map1'=>$v['map1'],
          'kap1'=>$v['kap1'],
          'noh2'=>$v['noh2'],
          'hotel2'=>gpc($v['hotel2']),
          'map2'=>$v['map2'],
          'kap2'=>$v['kap2'],
          'noh3'=>$v['noh3'],
          'hotel3'=>gpc($v['hotel3']),
          'map3'=>$v['map3'],
          'kap3'=>$v['kap3'],
          'update_at'=>time(),
        );
        InsertUpdate($db,"pulang",$idt,$udt,1);

        $udt2=array(
          'sa_departure_flight'=>$v['flight_no'],
          'sa_departure_date'=>$v['tgl'],
          'sa_departure_time'=>$v['jam'],
          'out_qty'=>$v['qty'],
        );
        Update($db,"mykloter",$udt2,"`code`='".$v['code']."'",1);      
    }
    /* */
  } else {
    echo "tak ada data xls<br>";    
  }
}