<?php
if(isset($_POST['start'])){
    
    $nama_file = $_FILES['file']['name'];
    $lokasi = "C://xampp3/htdocs/bc/upload_file_excel/".$_FILES['file']['name'];
    $pindah = move_uploaded_file($_FILES['file']['tmp_name'], $lokasi);
    if($pindah){
        print "pindah file selesai , mohon ditunggu :";
    }

    $excel = \PhpOffice\PhpSpreadsheet\IOFactory::load($lokasi); 
    $per = 1;
    while($excel->getActiveSheet()->getCell("A".$per) != ''){
        
        $per=$per+1;

        //berhenti jika menemukan nilai ksong
        if ($excel->getActiveSheet()->getCell("A".$per) == '' ) {
        print " <b>sudah selesai</b> ";
        break;
        }

        $kode_propinsi = $excel->getActiveSheet()->getCell("A".$per);
        $kode_dati2 = $excel->getActiveSheet()->getCell("B".$per);
        $kode_kecamatan = $excel->getActiveSheet()->getCell("C".$per);
        $kode_kelurahan = $excel->getActiveSheet()->getCell("D".$per);
        $kode_blok = $excel->getActiveSheet()->getCell("E".$per);
        $no_urut = $excel->getActiveSheet()->getCell("F".$per);
        $kode_jns_op = $excel->getActiveSheet()->getCell("G".$per);
        $tahun_pajak_sppt = $excel->getActiveSheet()->getCell("H".$per);
        $nama_wp = $excel->getActiveSheet()->getCell("I".$per);
        $total_pokok = $excel->getActiveSheet()->getCell("J".$per);
        $total_denda = $excel->getActiveSheet()->getCell("K".$per);
        $nomor_billing = $excel->getActiveSheet()->getCell("L".$per);
        $kode_pembayaran = $excel->getActiveSheet()->getCell("M".$per);
        $tangal_pembayaran = $excel->getActiveSheet()->getCell("N".$per);
        $tanggal_billing = $excel->getActiveSheet()->getCell("O".$per);

        $query = mysqli_query($koneksi, "INSERT INTO bc_manifest_detil (Nomor_Permintaan, Kd_Propinsi, Kd_Dati2, Kd_Kecamatan, Kd_Kelurahan, Kd_Blok, No_Urut, Kd_Jns_Op, Thn_Pajak_SPPT, Nama_WP, Kelurahan_WP, Total_Pokok, Total_Denda, Nomor_Billing, Kode_Pembayaran, isValid, State, UserCreate, DateCreate, UserUpdate, DateUpdate, Tanggal_Pembayaran, Jam_Pembayaran, Tanggal_Billing) VALUES ('', '$kode_propinsi', '$kode_dati2', '$kode_kecamatan', '$kode_kelurahan', '$kode_blok', '$no_urut', '$kode_jns_op', '$tahun_pajak_sppt', '$nama_wp', NULL, '$total_pokok', '$total_denda', '$nomor_billing', '$kode_pembayaran', '1', NULL, NULL, NULL, NULL, NULL, '$tangal_pembayaran', '00:00:00', '$tanggal_billing')");

        print "|";
        if ($query) {
            print "sukses";
        }else{
            print "gagal";
        }

    }
    //print $excel->getActiveSheet()->getCell('B8');

}

?>	