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////
}
