/** * Execute the console command. * * @return mixed */ public function fire() { $dir = $_SERVER['DOCUMENT_ROOT'] . "public/toUpload/"; $doc = $this->argument('table') . '.xlsx'; try { Excel::filter('chunk')->load($dir . $doc)->chunk(250, function ($reader) { if ($this->argument('table') == 'extracts') { Extract::insert($this->validate($reader)); } else { ExcelDaily::insert($this->validate($reader)); } }); $message = "El archivo " . $doc . " se ha guardado en la base de datos."; } catch (Exception $e) { $message = "No se ha guardar " . $doc . ". Intenta subirlo de nuevo."; } /*Mail::send('emails.excel', ['msn' => $message], function ($m) use($message){ $m->to('*****@*****.**', 'Creditos Lilipink')->subject('Notificación Lilipink'); });*/ Mail::send('emails.excel', ['msn' => $message], function ($m) use($message) { $m->to('*****@*****.**', 'Creditos Lilipink')->subject('Notificación Lilipink'); }); unlink($dir . $doc); if (!is_dir($dir)) { rmdir($dir); } }
private function setData($identification) { $extracts = Extract::where("nit", $identification)->orderBy('id', 'DESC')->get(); if ($extracts) { $user = User::whereRaw("roles_id = 4 and identification_card = {$identification}")->first(); $minPay = ExcelDaily::where("cedula", $identification)->get(); $quota = CreditRequest::where('user_id', $user->id)->first(); $day = explode('-', date("y-m-d")); $q = $quota ? $quota->value : 300000; $this->data = ['user' => $user, 'day' => $day, 'extracts' => $extracts, 'quota' => intval($q), 'minPay' => $minPay, 'months' => $this->getMonths()]; return true; } return false; }
public function showState() { $user = Auth::user(); $credit = CreditRequest::where('user_id', $user->id)->first(); $extracts = Extract::where('nit', $user->identification_card)->get(); $vencidos = 0; $debe = 0; foreach ($extracts as $extract) { $vencidos += intval($extract->dias_vencidos); $debe += intval($extract->saldo_credito_diferido); } return View::make('front.state', compact('extracts', 'vencidos', 'debe', 'user', 'credit')); }