public function run()
{
$faker = Faker::create();
foreach (range(1, 100) as $index) {
Simpanan::create(['id' => $index, 'user_id' => $index, 'simpanan_wajib' => 10000, 'simpanan_sukarela' => 10000, 'pinjaman' => 20000, 'tanggal_pembayaran' => $faker->date($format = 'Y-m-d', $max = 'now'), 'created_at' => null, 'updated_at' => null]);
$faker->unique(true);
}
}
/**
* Export the specified simpanan from storage.
*
* @param int $id
* @return Response
*/
public function exportdata()
{
// EXPORT VALIDASI
$rules = ['tanggal_pembayaran' => 'required'];
$messages = ['tanggal_pembayaran.required' => 'Pilih Data Tanggal Yang Akan Anda Ambil.'];
$validator = Validator::make(Input::all(), $rules, $messages);
if ($validator->fails()) {
return Redirect::back()->withErrors($validator);
}
$simpanans = Simpanan::where('tanggal_pembayaran', Input::get('tanggal_pembayaran'))->get();
Excel::create('Data Simpanan', function ($excel) use($simpanans) {
// Set the properties
$excel->setTitle('Laporan Simpanan')->setCreator('Andreas Krisandy');
$excel->sheet('Data Simpanan', function ($sheet) use($simpanans) {
$row = 1;
$sheet->row($row, array('TANGGAL PEMBAYARAN', 'NO IDENTITAS/KTP', 'AP', 'NAMA ANGGOTA', 'SIMPANAN WAJIB', 'SIMPANAN SUKARELA', 'TOTAL SIMPANAN', 'PINJAMAN'));
foreach ($simpanans as $simpanan) {
$sheet->row(++$row, array($simpanan->tanggal_pembayaran, $simpanan->anggotas->no_ktp, null, $simpanan->anggotas->nama, $simpanan->simpanan_sukarela, $simpanan->simpanan_wajib, null, $simpanan->pinjaman));
}
});
})->export('xls');
}
