public function generate($id = 0) { $this->load->library('PHPWord'); $this->load->helper('util'); $date = date('Y-m-d_H-i-s'); //if ($id==0); $data = $this->db->where('id_permohonan_peng_data', $id)->join($this->cms_complete_table_name('mas_jurusan'), 'id_jurusan=fk_id_jurusan')->get($this->cms_complete_table_name('permohonan_peng_data'))->result(); $PHPWord = new PHPWord(); //Generate Document foreach ($data as $d) { $document = $PHPWord->loadTemplate('assets/surat_keluar/Permohonan Pengambilan Data/peng_data.docx'); $document->setValue('nomor_surat', $d->nomor_surat); $document->setValue('lampiran', $d->lampiran); $document->setValue('kepada', $d->kepada); $document->setValue('di', $d->di); $document->setValue('nama_mahasiswa', $d->nama_mahasiswa); $document->setValue('npm', $d->npm); $document->setValue('jurusan', $d->nama_jurusan); $document->setValue('ketua_jurusan', $d->ketua_jurusan); $document->setValue('tanggal', tanggal(date('d-m-Y'))); $document->setValue('bulan', bulan_romawi(date('m'))); $document->setValue('tahun', date('Y')); ////open file//// $objWriter = PHPWord_IOFactory::createWriter($PHPWord, 'Word2007'); $filename = $d->npm . '-Surat_Permohonan_Peng_Data.docx'; $document->save($filename); header('Content-Description: File Transfer'); header('Content-Type: application/octet-stream'); header('Content-Disposition: attachment; filename=' . $filename); header('Content-Transfer-Encoding: binary'); header('Expires: 0'); header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header('Pragma: public'); header('Content-Length: ' . filesize($filename)); flush(); readfile($filename); unlink($filename); // deletes the temporary file exit; } ////end of open file//// ///save file//// //$document->save('assets/docs/'.$d->nama_kar.'-'.$d->id_pegawai.'.docx'); //redirect(base_url().'assets/docs/'.$d->nama_kar.'-'.$d->id_pegawai.'.docx', 'assets/manage_pegawai'); ///end of save file//// }
public function generate($id = 0) { $this->load->library('PHPWord'); $this->load->helper('util'); $date = date('Y-m-d_H-i-s'); //if ($id==0); $data = $this->db->where('id_surat_tugas', $id)->get($this->cms_complete_table_name('surat_tugas'))->result(); $PHPWord = new PHPWord(); //Generate Document foreach ($data as $d) { $document = $PHPWord->loadTemplate('assets/surat_keluar/surat_tugas/surat_tugas.docx'); $document->setValue('nomor_surat', $d->nomor_surat); $document->setValue('nama_pegawai', $d->nama_pegawai); $document->setValue('nik', $d->nik); $document->setValue('pangkat_golongan', $d->pangkat_golongan); $document->setValue('jabatan', $d->jabatan); $document->setValue('tujuan', $d->tujuan); $document->setValue('tanggal', tanggal(date('d-m-Y'))); $document->setValue('bulan', bulan_romawi(date('m'))); $document->setValue('tahun', date('Y')); ////open file//// $objWriter = PHPWord_IOFactory::createWriter($PHPWord, 'Word2007'); $filename = $d->nik . '-Surat_Tugas.docx'; $document->save($filename); header('Content-Description: File Transfer'); header('Content-Type: application/octet-stream'); header('Content-Disposition: attachment; filename=' . $filename); header('Content-Transfer-Encoding: binary'); header('Expires: 0'); header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header('Pragma: public'); header('Content-Length: ' . filesize($filename)); flush(); readfile($filename); unlink($filename); // deletes the temporary file exit; } }
public function generate($id = 0) { $this->load->library('PHPWord'); $this->load->helper('util'); $date = date('Y-m-d_H-i-s'); //if ($id==0); $conf = $this->db->get($this->cms_complete_table_name('konfigurasi'))->result(); $data = $this->db->where('id_kelakuan_baik', $id)->join($this->cms_complete_table_name('mas_jurusan'), 'id_jurusan=fk_id_jurusan')->get($this->cms_complete_table_name('kelakuan_baik'))->result(); $PHPWord = new PHPWord(); //Generate Document foreach ($data as $d) { $document = $PHPWord->loadTemplate('assets/surat_keluar/Ket. Kelakuan Baik/kelakuan_baik.docx'); $document->setValue('nomor_surat', $d->nomor_surat); $document->setValue('nama_mahasiswa', $d->nama_mahasiswa); $document->setValue('npm', $d->npm); $document->setValue('tempat_lahir', $d->tempat_lahir); $document->setValue('tanggal_lahir', tanggal(date($d->tanggal_lahir))); $document->setValue('jurusan', $d->nama_jurusan); $document->setValue('semester', $d->semester); $document->setValue('tahun_akademis', $d->tahun_akademis); $document->setValue('tanggal', tanggal(date('d-m-Y'))); $document->setValue('bulan', bulan_romawi(date('m'))); $document->setValue('tahun', date('Y')); foreach ($conf as $c) { $document->setValue('nama_instansi', $c->nama_instansi); $document->setValue('alamat', $c->alamat); $document->setValue('status_akreditasi', $c->status_akreditasi); $document->setValue('nama_puket', $c->nama_puket); $document->setValue('pangkat_puket', $c->pangkat_puket); } ////open file//// $objWriter = PHPWord_IOFactory::createWriter($PHPWord, 'Word2007'); $filename = $d->npm . '-Surat_Kelakuan_Baik.docx'; $document->save($filename); header('Content-Description: File Transfer'); header('Content-Type: application/octet-stream'); header('Content-Disposition: attachment; filename=' . $filename); header('Content-Transfer-Encoding: binary'); header('Expires: 0'); header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header('Pragma: public'); header('Content-Length: ' . filesize($filename)); flush(); readfile($filename); unlink($filename); // deletes the temporary file exit; } ////end of open file//// ///save file//// //$document->save('assets/docs/'.$d->nama_kar.'-'.$d->id_pegawai.'.docx'); //redirect(base_url().'assets/docs/'.$d->nama_kar.'-'.$d->id_pegawai.'.docx', 'assets/manage_pegawai'); ///end of save file//// }