function olahxls_berangkat($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]!='') {
          $ex1=explode("/",$r[6]);
          $ex2=explode("/",$r[9]);
          $ex3=explode("/",$r[18]);
          if($r['8']=='MED') {
            $gel=1;
          } else {
            $gel=2;
          }
          $dt[$k] = [
            'emb' => $r[0],
            'klt' => $r[1],
            'rpergi_tgl' => $ex1[2].'-'.$ex1[1].'-'.$ex1[0],
            'rpergi_jam' => strtotime($ex1[2].'-'.$ex1[1].'-'.$ex1[0].' '.$r[7].':00'),
            'port' => $r[8],
            'rtiba_tgl' => $ex2[2].'-'.$ex2[1].'-'.$ex2[0],
            'rtiba_jam' => strtotime($ex2[2].'-'.$ex2[1].'-'.$ex2[0].' '.$r[10].':00'),
            'flight' => NoSpace($r[11]),
            'rjhi' => $r[12],
            'rtphi' => $r[13],
            'rtpihi' => $r[14],
            'rtkhi' => $r[15],
            'rtotal' => $r[16],
            'gel' => $gel,
            'ftiba_tgl' => $ex3[2].'-'.$ex3[1].'-'.$ex3[0],
            'ftiba_jam' => strtotime($ex3[2].'-'.$ex3[1].'-'.$ex3[0].' '.$r[19].':00'),
            'fjhi' => $r[20],
            'ftphi' => $r[21],
            'ftpihi' => $r[22],
            'ftkhi' => $r[23],
            'ftotal' => $r[24],
            'code' => trim($r[0]).''.trim($r[1]),
          ];           
        }
      }
    }
    //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[2]); echo "</pre>";
    
    foreach ($dt as $k => $v) {
      if($k>1) {
        $idt=array(
          'id'=>$k-1,
          'emb'=>$v['emb'],
          'klt'=>$v['klt'],
          'code'=>$v['code'],
          'rpergi_tgl'=>$v['rpergi_tgl'],
          'rpergi_jam'=>$v['rpergi_jam'],
          'port'=>$v['port'],
          'rtiba_tgl'=>$v['rtiba_tgl'],
          'rtiba_jam'=>$v['rtiba_jam'],
          'flight'=>$v['flight'],
          'rjhi'=>$v['rjhi'],
          'rtphi'=>$v['rtphi'],
          'rtkhi'=>$v['rtkhi'],
          'rtpihi'=>$v['rtpihi'],
          'rtotal'=>$v['rtotal'],
          'gel'=>$v['gel'],
          'ftiba_tgl'=>$v['ftiba_tgl'],
          'ftiba_jam'=>$v['ftiba_jam'],
          'fjhi'=>$v['fjhi'],
          'ftphi'=>$v['ftphi'],
          'ftpihi'=>$v['ftpihi'],
          'ftkhi'=>$v['ftkhi'],
          'ftotal'=>$v['ftotal'],
          'update_at'=>time(),
        );
        $udt=array(
          'code'=>$v['code'],
          'rpergi_tgl'=>$v['rpergi_tgl'],
          'rpergi_jam'=>$v['rpergi_jam'],
          'port'=>$v['port'],
          'rtiba_tgl'=>$v['rtiba_tgl'],
          'rtiba_jam'=>$v['rtiba_jam'],
          'flight'=>$v['flight'],
          'rjhi'=>$v['rjhi'],
          'rtphi'=>$v['rtphi'],
          'rtkhi'=>$v['rtkhi'],
          'rtpihi'=>$v['rtpihi'],
          'rtotal'=>$v['rtotal'],
          'gel'=>$v['gel'],
          'ftiba_tgl'=>$v['ftiba_tgl'],
          'ftiba_jam'=>$v['ftiba_jam'],
          'fjhi'=>$v['fjhi'],
          'ftphi'=>$v['ftphi'],
          'ftpihi'=>$v['ftpihi'],
          'ftkhi'=>$v['ftkhi'],
          'ftotal'=>$v['ftotal'],
          'update_at'=>time(),
        );
        InsertUpdate($db,"berangkat",$idt,$udt,1);

        $udt2=array(
          'id_takeoff_date'=>$v['rpergi_tgl'],
          'id_takeoff_time'=>$v['rpergi_jam'],
          'sa_arrival_port'=>$v['port'],
          'flight_no'=>$v['flight'],
          'sa_arrival_date'=>$v['rtiba_tgl'],
          'sa_arrival_time'=>$v['rtiba_jam'],
          'rin_jhi'=>$v['rjhi'],
          'rin_ptg'=>$v['rtphi']+$v['rtpihi']+$v['rtkhi'],
          'rin_total'=>$v['rtotal'],

          'fsa_arrival_date'=>$v['ftiba_tgl'],
          'fsa_arrival_time'=>$v['ftiba_jam'],
          'fin_jhi'=>$v['fjhi'],
          'fin_ptg'=>$v['ftphi']+$v['ftpihi']+$v['ftkhi'],
          'fin_total'=>$v['ftotal'],
        );
        Update($db,"mykloter",$udt2,"`code`='".$v['code']."'",1);
        
      }
    }
    /* */
  } else {
    echo "tak ada data xls<br>";    
  }
}