function olahxls_dirawat($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]!='') {
          $ex=explode("-",$r[3]);
          $dt[$k] = [
            'no' => $r[0],
            'porsi' => $r[1],
            'paspor' => $r[2],
            'urut' => $r[4],
            'provinsi' => $r[5],
            'nama' => $r[6],
            'rs' => $r[7],
            'dr' => $r[8],
            'tgl' => trim(relp_space($r[9])),
            'wilayah' => $r[10],
            'usia' => $r[11],
            'st' => $r[12],
            'code' => trim($ex[0]).''.trim($ex[1]),
            'emb' => trim($ex[0]),
            'klt' => trim($ex[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[1]); echo "</pre>";
    
    foreach ($dt as $k => $v) {
      $e1=explode(" ",$v['tgl']);
      $e2=explode("-",$e1[0]);
      $idt=array(
        'id'=>$v['no'],
        'porsi'=>$v['porsi'],
        'paspor'=>$v['paspor'],
        'urut'=>$v['urut'],
        'provinsi'=>$v['provinsi'],
        'nama'=>gpc($v['nama']),
        'rs'=>$v['rs'],
        'tgl'=>$e2[2]."-".$e2[1]."-".$e2[0],
        'jam'=>strtotime($e2[2]."-".$e2[1]."-".$e2[0]." ".$e1[1].":00"),
        'wilayah'=>$v['wilayah'],
        'usia'=>$v['usia'],
        'st'=>$v['st'],
        'emb'=>$v['emb'],
        'klt'=>$v['klt'],
        'code'=>$v['code'],
      );
      $udt=array(
        'dr'=>$v['dr'],
        'tgl'=>$e2[2]."-".$e2[1]."-".$e2[0],
        'jam'=>strtotime($e2[2]."-".$e2[1]."-".$e2[0]." ".$e1[1].":00"),
        'st'=>$v['st'],
        'update_at'=>time()
      );
      InsertUpdate($db,"dirawat",$idt,$udt,1);
      $udt2=array(
        'is_dirawat'=>1,
        'dirawat_id'=>$v['no'],
        'ket_rawat'=>$v['st'],
      );
      Update($db,"penempatan",$udt2,"`paspor`='".$v['paspor']."'",1);
    }
    /* */

    $sql2="SELECT code,gel from mykloter";
    $res2=mysqli_query($db,$sql2);
    while($r2=mysqli_fetch_assoc($res2)) {
      $udt3=array(
        'daker'=>2,
        'gel'=>$r2['gel'],
      );
      Update($db,"dirawat",$udt3,"`code`='".$r2['code']."'",1);
    }

    $sql3="SELECT lp,daker,sektor,gel,porsi,paspor,dirawat_id,no_rumah from penempatan where is_dirawat=1 and dirawat_id>0";
    $res3=mysqli_query($db,$sql3);
    while($r3=mysqli_fetch_assoc($res3)) {
      $udt3=array(
        'daker'=>$r3['daker'],
        'gel'=>$r3['gel'],
        'lp'=>$r3['lp'],
        'sektor'=>$r3['sektor'],
        'norumah'=>$r3['no_rumah'],
      );
      Update($db,"dirawat",$udt3,"`id`='".$r3['dirawat_id']."'",1);            
    }     
  } else {
    echo 'tak ada data<br>';
  }      
}