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