import excel

<?php
public function import()
    {
        $bukuModel = new BukuModel();
        $file = $this->request->getFile('fileExcel');
        $ext = $file->getClientExtension();
        if ($ext == 'xls') {
            $reader = new \PhpOffice\PhpSpreadsheet\Reader\Xls();
        } else {
            $reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
        }
        $spreadsheet = $reader->load($file);
        $sheet = $spreadsheet->getActiveSheet()->toArray();
        foreach ($sheet as $x => $excel) {
            //skip judul tabel
            if ($x == 0) {
                continue;
            }
            //skip jika ada data yang sama
            $slug = $bukuModel->getBuku($excel['10']);
            // dd($excel['10']);
            if (isset($slug['slug'])&& $excel['10'] == $slug['slug'])
           {
                //continue;
            }
            else
            {
            $buku = [
                'kodeBuku' => $excel['1'],
                'judul' => $excel['2'],
                'kategori' => $excel['3'],
                'penerbit' => $excel['4'],
                'jumlah' => $excel['5'],
                'deskripsi' => $excel['6'],
                'pengarang' => $excel['7'],
                'tahunTerbit' => $excel['8'],
                'sampul' => $excel['9'],
                'created_at' => Time::now(),
                'updated_at' => Time::now(),
                'slug' => $excel['10']
            ];
            $this->buku->insert($buku);
            }
        }
        session()->setFlashdata('pesan', 'Data berhasil ditambah');
        return redirect()->to('/admin/daftarBuku');
    }