public function doExport()
{
Excel::create('tutasimpeg-kartu-induk-pegawai', function ($excel) {
// Set the title
$excel->setTitle('tutasimpeg');
// Chain the setters
$excel->setCreator('Irfan Mahfudz Guntur')->setCompany('Digital Tuta Network');
// Call them separately
$excel->setDescription('Export data kartu induk pegawai ke excel');
$excel->sheet('KartuIndukPegawai', function ($sheet) {
$sheet->row(1, array('Kartu Induk Pegawai'));
$kartu_induk_pegawais = KartuIndukPegawai::all();
$column = array('NIP', 'KARPEG', 'KARIS/KARSU', 'NAMA LENGKAP', 'TEMPAT LAHIR', 'TGL LAHIR', 'JENIS KELAMIN', 'STATUS PERKAWINAN', 'TGL MASUK PEGAWAI', 'STATUS KEPEGAWAIAN', 'AGAMA', 'JENIS KEPEGAWAIAN', 'TGL PENSIUN');
$sheet->appendRow($column);
// getting last row number (the one we already filled and setting it to bold
$sheet->row($sheet->getHighestRow(), function ($row) {
$row->setFontWeight('bold');
});
// putting customers data as next rows
foreach ($kartu_induk_pegawais as $value) {
$sheet->appendRow(array($value->nip, $value->karpeg, $value->karis_karsu, $value->nama_lengkap, $value->tempat_lahir, date('d-m-Y', strtotime($value->tgl_lahir)), $value->jenis_kelamin, $value->status_perkawinan, date('d-m-Y', strtotime($value->tgl_masuk_pegawai)), $value->status_kepegawaian, $value->agama, $value->jenis_kepegawaian, date('d-m-Y', strtotime($value->tgl_pensiun))));
}
});
})->export('xls');
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$kartu_induk_pegawais = KartuIndukPegawai::all();
return view('kartu-induk-pegawai.index', ['kartu_induk_pegawai' => $kartu_induk_pegawais]);
}
