public function get_print()
{
$input = Input::all();
$input = Suratkeluarlain::lengkapi_array($input);
$db_surat_keluar = Suratkeluarlain::print_surat($input);
return View::make('suratkeluarlain.print')->with('title', 'Buku Agenda :: Print Surat Keluar Lain')->with('suratkeluarlains', $db_surat_keluar);
}
public static function upload_create($file)
{
$csv_rows = array();
// detect delimiter antara ',' atau ';'
$allowed_header = array('nomor_surat', 'tanggal', 'tujuan', 'hal', 'pengirim');
$csv_uploded = file($file, FILE_IGNORE_NEW_LINES);
$csv_header = str_getcsv($csv_uploded[0], ',');
$csv_header2 = str_getcsv($csv_uploded[0], ';');
if ($csv_header == $allowed_header) {
$csv_delimiter = ',';
} else {
if ($csv_header2 == $allowed_header) {
$csv_delimiter = ';';
} else {
echo 'wrong delimiter';
// FIXME throw error
exit;
}
}
// push data csv ke array
if (isset($csv_delimiter)) {
foreach ($csv_uploded as $line) {
$csv_rows[] = str_getcsv($line, $csv_delimiter);
}
// remove header dari file csv
unset($csv_rows[0]);
$jumlah = 0;
foreach ($csv_rows as $row) {
// rekam data surat lain
// -Eloquent query-
Suratkeluarlain::create(array('nomor_surat' => $row[0], 'tgl_surat' => $row[1], 'tujuan' => $row[2], 'hal' => $row[3], 'pengirim' => $row[4], 'perekam' => Auth::user()->username));
// set counter
$jumlah++;
}
$message = 'Surat Keluar Lain sebanyak ' . $jumlah . ' surat berhasil direkam.';
return $message;
}
}
