function olahxls_wafat($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[11]);
          $dt[$k] = [
            'no' => $r[0],
            'reg' => $r[1],
            'emb' => $r[2],
            'klt' => $r[3],
            'porsi' => $r[4],
            'nama' => $r[5],
            'ayah' => $r[6],
            'lp' => $r[7],
            'paspor' => $r[8],
            'pelapor' => $r[9],
            'tempat_wafat' => $r[10],
            'tgl_wafat' => $ex[2].'-'.$ex[1].'-'.$ex[0].' '.trim($r[12]).':00',
            'sebab' => $r[13],
            'makam' => $r[14],
            'usia' => $r[15],
            'maktab' => $r[16],
            'no_rumah' => $r[17],
            'provinsi' => $r[18],
            'kokab' => $r[19],
            'alamat' => $r[20],
            'desa' => $r[21],
            'code' => trim($r[2]).''.trim($r[3]),
          ];           
        }
      }
    }
    //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'=>$v['no'],
        'reg'=>$v['reg'],
        'emb'=>$v['emb'],
        'klt'=>$v['klt'],
        'code'=>$v['code'],
        'porsi'=>$v['porsi'],
        'nama'=>gpc($v['nama']),
        'ayah'=>gpc($v['ayah']),
        'lp'=>$v['lp'],
        'paspor'=>$v['paspor'],
        'pelapor'=>$v['pelapor'],
        'tempat_wafat'=>gpc($v['tempat_wafat']),
        'tgl_wafat'=>$v['tgl_wafat'],
        'jam_wafat'=>strtotime($v['tgl_wafat']),
        'sebab'=>gpc($v['sebab']),
        'makam'=>$v['makam'],
        'usia'=>$v['usia'],
        'maktab'=>$v['maktab'],
        'no_rumah'=>$v['no_rumah'],
        'kokab'=>$v['kokab'],
        'provinsi'=>$v['provinsi'],
        'alamat'=>$v['alamat'],
        'desa'=>$v['desa'],
        'update_at'=>time(),
      );
      $udt=array(
        'nama'=>gpc($v['nama']),
        'ayah'=>gpc($v['ayah']),
        'tempat_wafat'=>gpc($v['tempat_wafat']),
        'tgl_wafat'=>$v['tgl_wafat'],
        'jam_wafat'=>strtotime($v['tgl_wafat']),
        'sebab'=>gpc($v['sebab']),
        'update_at'=>time(),
      );
      InsertUpdate($db,"wafat",$idt,$udt,1);
      $udt2=array(
        'is_wafat'=>1,
        'wafat_id'=>$v['no'],
      );
      Update($db,"penempatan",$udt2,"`paspor`='".$v['paspor']."'",1);
    }
    /* */
    $sql2="SELECT `code`,`gel` from berangkat";
    $res2=mysqli_query($db,$sql2);
    while($r2=mysqli_fetch_assoc($res2)) {
      $udt3=array(
        'daker'=>2,
        'gel'=>$r2['gel'],
      );
      Update($db,"wafat",$udt3,"`code`='".$r2['code']."'",1);
    }   
    $sql3="SELECT lp,daker,sektor,gel,porsi,paspor,wafat_id,no_rumah from penempatan where is_wafat=1 and wafat_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,"wafat",$udt3,"`id`='".$r3['wafat_id']."'",1);            
    }    
  } else {
    echo 'tak ada data<br>';
  }
}