public function index() { switch ($_POST['jenis']) { case "Pertemuan_Pembelajaran": $header = array(array('Data', 'Pertemuan Pembelajaran'), array('Kelas', $_POST['pertkelasnya']), array('Pelajaran', $_POST['pertpelajarannya']), array('Tahun Ajaran', $this->session->userdata['ak_setting']['ta_nama']), array('Semester', $this->session->userdata['ak_setting']['semester_nama'])); $this->load->model('ad_pembelajaran'); $arrayfirst = $this->ad_pembelajaran->getWaktuPembelajaranByKelasPelajaranIdPegawai($_POST['pelajaran'], $_POST['id_kelas']); foreach ($arrayfirst as $id => $data) { unset($data['id']); unset($data['id_sekolah']); unset($data['id_pelajaran']); unset($data['id_pegawai']); unset($data['id_kelas']); unset($data['semester']); unset($data['ta']); $array[] = $data; } unset($arrayfirst); //pr($array); break; case "Rencana_Pembelajaran": $header = array(array('Data', 'Pembelajaran'), array('Kelas', $_POST['kelasnya']), array('Pertemuan', $_POST['pertemuannya']), array('Tahun Ajaran', $this->session->userdata['ak_setting']['ta_nama']), array('Semester', $this->session->userdata['ak_setting']['semester_nama'])); $this->load->model('ad_pembelajaran'); if ($_POST['id_pertemuan'] != 0) { $arrayfirst = $this->ad_pembelajaran->getPembelajaranByKelasPelajaranIdPegawaiIdPertemuan($_POST['pelajaran'], $_POST['id_kelas'], $_POST['id_pertemuan']); } else { $arrayfirst = $this->ad_pembelajaran->getPembelajaranByKelasPelajaranIdPegawai($_POST['pelajaran'], $_POST['id_kelas'], $this->session->userdata['user_authentication']['id_pengguna']); } foreach ($arrayfirst['pembelajaran'] as $id => $data) { unset($data['id']); unset($data['file']); unset($data['id_kelas']); unset($data['id_pertemuan']); unset($data['id_pelajaran']); $array[] = $data; } unset($arrayfirst); break; case "absensi": $tgl = $this->auth->tanggal($_POST['tanggalnyaabsensi'] . " 00:00:00"); $header = array(array('Data', 'Abseni'), array('Kelas', $_POST['kelasnyaabsesnsi']), array('Guru Pengajar', $this->session->userdata['user_authentication']['nama']), array('Pelajaran', $_POST['pelajarannyaabsen']), array('Jam Pelajaran ke', $_POST['jamkenya']), array('Tanggal', $tgl[2]), array('Tahun Ajaran', $this->session->userdata['ak_setting']['ta_nama']), array('Semester', $this->session->userdata['ak_setting']['semester_nama'])); $_POST['id_kelas'] = $_POST['kelas']; $this->load->model('ad_absen'); $currentabsen = $this->ad_absen->getCurrentAbsensiExport($_POST['tanggalnyaabsensi'], $_POST['jamabsen']); if ($this->session->userdata['ak_setting']['jenjang'][0]['nama'] == 'SD') { unset($header[3]); unset($header[4]); } //pr($_POST); //pr($currentabsen); foreach ($currentabsen as $id => $data) { if ($this->session->userdata['ak_setting']['jenjang'][0]['nama'] == 'SD') { unset($data['jam_ke']); } unset($data['id']); unset($data['id_siswa_det_jenjang']); unset($data['id_sekolah']); unset($data['id_semester']); unset($data['id_pelajaran']); unset($data['id_semester']); unset($data['id_kelas']); unset($data['id_ta']); unset($data['jam']); unset($data['tanggal']); $array[] = $data; } unset($arrayfirst); break; case "Materi": $header = array(array('Data', 'Materi'), array('Guru Pengajar', $this->session->userdata['user_authentication']['nama']), array('Pelajaran', $_POST['pelajarannya']), array('Kelas', $_POST['kelasnya']), array('Tahun Ajaran', $this->session->userdata['ak_setting']['ta_nama']), array('Semester', $this->session->userdata['ak_setting']['semester_nama'])); $this->load->model('ad_materi'); $materi = $this->ad_materi->getmateriByKelasPelajaranIdPegawaiAll($_POST['pelajaran'], $_POST['id_kelas']); //pr($_POST); //pr($materi);die(); foreach ($materi as $id => $data) { unset($data['id']); unset($data['id_sekolah']); unset($data['id_pegawai']); unset($data['id_pembelajaran']); unset($data['id_pelajaran']); unset($data['semester']); unset($data['tanggal_diberikan']); //$tgl= $this->auth->tanggal($data['tanggal_diberikan']." 00:00:00"); $tglx = $this->auth->tanggal($data['tanggal_buat'] . " 00:00:00"); //$data['tanggal_diberikan']=$tgl[2]; $data['tanggal_buat'] = $tglx[2]; $array[] = $data; } unset($arrayfirst); break; case "Catatan_Guru": $tgl = $this->auth->tanggal($_POST['tanggal'] . " 00:00:00"); $header = array(array('Data', 'Catatan Guru'), array('Nama Siswa', $_POST['siswanya']), array('Kelas', $_POST['kelasnya']), array('Tanggal', $tgl[2]), array('Tahun Ajaran', $this->session->userdata['ak_setting']['ta_nama']), array('Semester', $this->session->userdata['ak_setting']['semester_nama'])); $this->load->model('ad_catatanguru'); $catatanguru = $this->ad_catatanguru->getCatatanguruByKelasTanggalIdPegawai($_POST['id_kelas'], $_POST['id_siswa_det_jenjang'], $_POST['tanggal']); //pr($_POST); //pr($catatanguru);die(); foreach ($catatanguru as $id => $data) { unset($data['id']); unset($data['semester']); unset($data['id_sekolah']); unset($data['id_siswa_det_jenjang']); unset($data['id_pegawai']); unset($data['id_kelas']); unset($data['id_aspek_kepribadian']); unset($data['ta']); $tgl = $this->auth->tanggal($data['tanggal'] . " 00:00:00"); $data['tanggal'] = $tgl[2]; $array[] = $data; } unset($arrayfirst); break; case "PR": $header = array(array('Data', 'Pekerjaan Rumah (PR)'), array('Guru Pengajar', $this->session->userdata['user_authentication']['nama']), array('Pelajaran', $_POST['pelajarannya']), array('Kelas', $_POST['kelasnya']), array('Tahun Ajaran', $this->session->userdata['ak_setting']['ta_nama']), array('Semester', $this->session->userdata['ak_setting']['semester_nama'])); $this->load->model('ad_pr'); $materi = $this->ad_pr->getPrByKelasPelajaran($_POST['pelajaran'], $_POST['id_kelas']); //pr($_POST); //pr($materi);die(); foreach ($materi as $id => $data) { unset($data['id']); unset($data['id_sekolah']); unset($data['id_pegawai']); unset($data['id_parent']); unset($data['id_pelajaran']); unset($data['semester']); unset($data['id_mengajar']); unset($data['id_kelas']); unset($data['id_pembelajaran']); unset($data['ta']); //$tgl= $this->auth->tanggal($data['tanggal_diberikan']." 00:00:00"); $tglx = $this->auth->tanggal($data['tanggal_buat'] . " 00:00:00"); //$data['tanggal_diberikan']=$tgl[2]; $data['tanggal_buat'] = $tglx[2]; $array[] = $data; } unset($arrayfirst); break; case "Tugas": $header = array(array('Data', 'Tugas'), array('Guru Pengajar', $this->session->userdata['user_authentication']['nama']), array('Pelajaran', $_POST['pelajarannya']), array('Kelas', $_POST['kelasnya']), array('Tahun Ajaran', $this->session->userdata['ak_setting']['ta_nama']), array('Semester', $this->session->userdata['ak_setting']['semester_nama'])); $this->load->model('ad_tugas'); $materi = $this->ad_tugas->getTugasByKelasPelajaran($_POST['pelajaran'], $_POST['id_kelas']); //pr($_POST); //pr($materi);die(); foreach ($materi as $id => $data) { unset($data['id']); unset($data['id_sekolah']); unset($data['id_pegawai']); unset($data['id_parent']); unset($data['id_pelajaran']); unset($data['semester']); unset($data['id_mengajar']); unset($data['id_kelas']); unset($data['id_pembelajaran']); unset($data['ta']); unset($data['tanggal_kumpul']); //$tgl= $this->auth->tanggal($data['tanggal_diberikan']." 00:00:00"); $tglx = $this->auth->tanggal($data['tanggal_buat'] . " 00:00:00"); //$data['tanggal_diberikan']=$tgl[2]; $data['tanggal_buat'] = $tglx[2]; $array[] = $data; } unset($arrayfirst); break; case "Ulangan_harian": $header = array(array('Data', 'Ulangan Harian'), array('Guru Pengajar', $this->session->userdata['user_authentication']['nama']), array('Pelajaran', $_POST['pelajarannya']), array('Kelas', $_POST['kelasnya']), array('Tahun Ajaran', $this->session->userdata['ak_setting']['ta_nama']), array('Semester', $this->session->userdata['ak_setting']['semester_nama'])); $this->load->model('ad_harian'); $materi = $this->ad_harian->getHarianByKelasPelajaran($_POST['pelajaran'], $_POST['id_kelas']); //pr($_POST); //pr($materi);die(); foreach ($materi as $id => $data) { unset($data['id']); unset($data['id_sekolah']); unset($data['id_pegawai']); unset($data['id_parent']); unset($data['id_pelajaran']); unset($data['semester']); unset($data['id_mengajar']); unset($data['id_kelas']); unset($data['id_pembelajaran']); unset($data['ta']); unset($data['tanggal_kumpul']); //$tgl= $this->auth->tanggal($data['tanggal_diberikan']." 00:00:00"); $tglx = $this->auth->tanggal($data['tanggal_buat'] . " 00:00:00"); //$data['tanggal_diberikan']=$tgl[2]; $data['tanggal_buat'] = $tglx[2]; $array[] = $data; } unset($arrayfirst); break; case "UTS": $header = array(array('Data', 'UTS'), array('Guru Pengajar', $this->session->userdata['user_authentication']['nama']), array('Pelajaran', $_POST['pelajarannya']), array('Kelas', $_POST['kelasnya']), array('Tahun Ajaran', $this->session->userdata['ak_setting']['ta_nama']), array('Semester', $this->session->userdata['ak_setting']['semester_nama'])); $this->load->model('ad_uts'); $uts = $this->ad_uts->getUtsByKelasPelajaran($_POST['pelajaran'], $_POST['id_kelas']); //pr($_POST); //pr($uts);die(); foreach ($uts as $id => $data) { unset($data['id']); unset($data['id_sekolah']); unset($data['id_pegawai']); unset($data['id_parent']); unset($data['id_pelajaran']); unset($data['semester']); unset($data['id_mengajar']); unset($data['id_kelas']); unset($data['id_pembelajaran']); unset($data['ta']); unset($data['tanggal_kumpul']); //$tgl= $this->auth->tanggal($data['tanggal_diberikan']." 00:00:00"); $tglx = $this->auth->tanggal($data['tanggal_buat'] . " 00:00:00"); //$data['tanggal_diberikan']=$tgl[2]; $data['tanggal_buat'] = $tglx[2]; $array[] = $data; } unset($arrayfirst); break; case "UAS": $header = array(array('Data', 'UAS'), array('Guru Pengajar', $this->session->userdata['user_authentication']['nama']), array('Pelajaran', $_POST['pelajarannya']), array('Kelas', $_POST['kelasnya']), array('Tahun Ajaran', $this->session->userdata['ak_setting']['ta_nama']), array('Semester', $this->session->userdata['ak_setting']['semester_nama'])); $this->load->model('ad_uas'); $uts = $this->ad_uas->getUasByKelasPelajaran($_POST['pelajaran'], $_POST['id_kelas']); //pr($_POST); //pr($uts);die(); foreach ($uts as $id => $data) { unset($data['id']); unset($data['id_sekolah']); unset($data['id_pegawai']); unset($data['id_parent']); unset($data['id_pelajaran']); unset($data['semester']); unset($data['id_mengajar']); unset($data['id_kelas']); unset($data['id_pembelajaran']); unset($data['ta']); unset($data['tanggal_kumpul']); //$tgl= $this->auth->tanggal($data['tanggal_diberikan']." 00:00:00"); $tglx = $this->auth->tanggal($data['tanggal_buat'] . " 00:00:00"); //$data['tanggal_diberikan']=$tgl[2]; $data['tanggal_buat'] = $tglx[2]; $array[] = $data; } unset($arrayfirst); break; case "Nilai": $header = array(array('Data', $_POST['namanilai']), array('Guru Pengajar', $this->session->userdata['user_authentication']['nama']), array('Pelajaran', $_POST['pelajarannya']), array('Kelas', $_POST['kelasnya']), array('Tahun Ajaran', $this->session->userdata['ak_setting']['ta_nama']), array('Semester', $this->session->userdata['ak_setting']['semester_nama'])); foreach ($_POST['nama'] as $id => $datax) { $data[$id]['nama'] = $datax; $data[$id]['nis'] = $_POST['nis'][$id]; $data[$id]['kelas'] = $_POST['kelas'][$id]; $data[$id]['nilai'] = $_POST['nilai'][$id]; $array = $data; } //pr($array);die(); break; } /** Include PHPExcel */ require_once 'application/libraries/PHPExcel.php'; // Create new PHPExcel object $objPHPExcel = new PHPExcel(); if (!empty($array) && !empty($header)) { $objPHPExcel->exports('pertemuan rpp', $array, 'PertemuanPembelajaran', $header); } else { echo '<script> alert("Data kosong"); window.location="' . base_url() . 'akademik/mainakademik/index"; window.close(); </script>'; } }