public function fire() { $dir = $_SERVER['DOCUMENT_ROOT'] . "public/toUpload/"; try { Excel::filter('chunk')->load($dir . 'data.xlsx')->chunk(250, function ($reader) { foreach ($reader->toArray() as $data) { $user = User::where('identification_card', $data['cedula'])->first(); if (!$user) { $user = User::create(['identification_card' => $data['cedula'], 'name' => $data['nombre'], 'user_name' => str_replace(' ', '.', $data['nombre']), 'email' => $data['email'] ? $data['email'] : 'Sin registro', 'address' => $data['direccion'] ? $data['direccion'] : 'Sin registro', 'residency_city' => $data['ciudad'] ? $data['ciudad'] : 'Sin registro', 'phone' => $data['tel1'] ? $data['tel1'] : 'Sin registro', 'mobile_phone' => $data['tel2'] ? $data['tel2'] : 'Sin registro', 'document_type' => 0, 'roles_id' => 4]); } $credit = CreditRequest::where('user_id', intval($user->id))->first(); if (!$credit) { $c = new CreditRequest(); $c->user_id = intval($user->id); $c->value = intval($data['limitecredito']); $c->state = 1; $c->location = 3; $c->responsible = 18; $c->save(); } else { $credit->value = $data['limitecredito']; $credit->save(); } } }); echo $message = "El archivo se ha guardado en la base de datos."; } catch (Exception $e) { echo $message = "No se ha guardar . Intenta subirlo de nuevo."; } Mail::send('emails.excel', ['msn' => $message], function ($m) use($message) { $m->to('*****@*****.**', 'Creditos Lilipink')->subject('Archivos actualizados'); }); array_map('unlink', glob($_SERVER['DOCUMENT_ROOT'] . "/toUpload/*")); }
public function changePassword($restore_password) { $data = Input::all(); $user = User::where('restore_password', $restore_password)->first(); if ($data["confirmar_password"] == $data["password"]) { $user->password = $data["password"]; $user->save(); } else { return Redirect::to('restaurar/' . $restore_password)->withErrors(['password' => 'La confirmación de la contraseña no coincide'])->withInput(); } new LogRepo(['responsible' => $user->name, 'action' => 'restauro la contraseña', 'affected_entity' => '', 'method' => 'savePassword']); return Redirect::route('home')->with(array('mensaje' => 'La contaseña ha sido cambiada.')); }
private function exportUsers() { $users = User::where('roles_id', '>=', '4')->select('id', 'roles_id', 'card as Tarjeta', 'identification_card as Cedula', 'name as Nombre1', 'second_name as Nombre2', 'last_name as Apellido1', 'second_last_name as Apellido2', 'email as Email', 'mobile_phone as Celular', 'location as Ciudad', 'created_at as Fecha de creación')->orderBy('roles_id', 'DESC')->get(); foreach ($users as $key => $user) { $credit = CreditRequest::where('user_id', $user->id)->first(); $users[$key]['Referencia1'] = $credit ? $credit->name_reference : null; $users[$key]['Tel_Referencia1'] = $credit ? $credit->phone_reference : null; $users[$key]['Referencia2'] = $credit ? $credit->name_reference2 : null; $users[$key]['Tel_Referencia2'] = $credit ? $credit->phone_reference2 : null; $users[$key]['Ciudad'] = $user->Ciudad ? Location::find($user->Ciudad)->name : 'Sin región'; $users[$key]['Tienda'] = $credit ? Point::find($credit->point)['name'] : 'Sin punto'; $users[$key]['Cupo_Credito'] = $credit ? $credit->value : null; $users[$key]['Emprend'] = $user->roles_id == 5 ? 'Si' : 'No'; $users[$key]['¿Empr. credito?'] = $credit && $user->roles_id == 5 ? 'Si' : $user->roles_id == 5 ? 'No' : 'N/A'; $users[$key]['Nombre referido'] = $user->roles_id == 5 ? $user['referred_name'] : 'N/A'; $users[$key]['Cedula referido'] = $user->roles_id == 5 ? $user['referred_document'] : 'N/A'; } return $users; }
public function deleteLocation($id) { $user = User::where('location', $id)->first(); $credit = CreditRequest::where('location', $id)->first(); if ($user or $credit) { return Redirect::route('location')->with(array('messages' => "No se pudo eliminar la region por que esta siendo usada")); } $location = Location::find($id); $location->delete(); new LogRepo(['responsible' => Auth::user()->user_name, 'action' => 'ha eliminado una region ', 'affected_entity' => 'Regiones', 'method' => 'deleteLocation']); return Redirect::route('location')->with(array('message' => "La region ha sido eliminada")); }
public function searchUsersCard() { $users = User::where('card', 0)->paginate(10); $points = Point::all(); return View::make('back.userCard', compact('users', 'points')); }