Example #1
0
 /**
  * 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);
     }
 }
Example #2
0
 public function index()
 {
     $sliders = Slider::where('number_slider', '<>', '0')->orderBy('number_slider', 'ASC')->get();
     if (Auth::user()) {
         $diario = ExcelDaily::where('cedula', Auth::user()->identification_card)->first();
     }
     return View::make('front.home', compact('sliders', 'diario'));
 }
 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;
 }