/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update(EditUserRequest $request, $id)
{
$user = User::findOrFail($id);
$user->fill($request->all());
$user->save();
return redirect()->back();
}
/**
* Create a new user instance after a valid registration.
*
* @param array $data
* @return User
*/
protected function create(array $data)
{
/*return User::create([
'name' => $data['name'],
'email' => $data['email'],
'password' => bcrypt($data['password']),
]);*/
/*$user = new User([
'first_name' => $data['first_name'],
'last_name' => $data['last_name'],
'email' => $data['email'],
'password' => bcrypt($data['password']),
]);*/
$user = new User(\Request::all());
$user->type = 'user';
$user->save();
return $user;
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Estado::truncate();
Estado::create(['nombre' => 'En espera']);
Estado::create(['nombre' => 'Atendido']);
Estado::create(['nombre' => 'Ausente']);
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
User::create(['name' => 'generico', 'email' => '*****@*****.**', 'password' => '123', 'generico' => '1']);
User::create(['name' => 'admin', 'email' => '*****@*****.**', 'password' => '123', 'admin' => '1']);
Model::reguard();
}
public function getOrm()
{
// $result = User::first();
// $result = User::first()->getFullNameAttribute();
// $user = User::first();
// $users = User::get();
$users = User::select('id', 'first_name')->with('profile')->where('first_name', '<>', 'jota')->OrderBy('first_name', 'ASC')->get();
// dd($result->full_name);
// dd($result->getFullNameAttribute());
// dd($result);
// dd($user->profile);
// dd($user->profile->age);
// dd($users);
dd($users->toArray());
// return $user;
}
public function confirmacion(Request $request)
{
header("Access-Control-Allow-Origin: *");
header("Allow: GET, POST, OPTIONS");
$email = $request->input('mail');
$codigo = $request->input('confirmar');
$user = User::whereRaw('email=? and codigo=? and activo=0', [$email, $codigo])->first();
if ($user != null) {
$user->activo = 1;
$user->save();
}
return view('iniciar_sesion');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id, Request $request)
{
abort(500);
$user = User::findOrFail($id);
//$user->delete();
$message = 'Se elimino al usuario ' . $user->full_name;
if ($request->ajax()) {
return response()->json(['id' => $user->id, 'message' => $message]);
}
Session::flash('message_type', 'alert-success');
Session::flash('message', $message);
return "Usuario eliminado";
}
public function run()
{
User::create(['nombre' => 'generico', 'email' => '*****@*****.**']);
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
dd(User::findOrFail($id));
}
public function getOrm()
{
$users = User::select('id', 'first_name')->where('first_name', '<>', 'Esteban')->orderBy('first_name', 'ASC')->get();
dd($users->toArray());
}
public static function filterAndPaginate($name, $type)
{
return User::name($name)->type($type)->orderBy('id', 'DESC')->paginate();
}
public function atender_atencion(Request $request)
{
header("Access-Control-Allow-Origin: *");
header("Allow: GET, POST, OPTIONS");
$id = $request->input('id');
$estado_id = $request->input('estado_id');
$consulta = "";
$atencion = Atencion::find($id);
$atencion->estado_id = $estado_id;
if ($estado_id == 2) {
$atencion->fecha_atendido = Carbon::now();
}
if ($estado_id == 3) {
$atencion->fecha_ausente = Carbon::now();
}
$atencion->save();
//$telefono_avisar=DB::table('atencions')->select(DB::raw('telefono'))->where('colaborador_id','=',null)->where('id','>',40)->where('estado_id','=','1')->orderBy('posicion','desc')->take(3)->first()->telefono;
$ids = DB::table('atencions')->select(DB::raw('id'))->where('colaborador_id', '=', null)->where('id', '>', $id)->where('estado_id', '=', '1')->where('lista_id', '=', $atencion->lista_id)->orderBy('posicion', 'asc')->take(3)->get();
if (count($ids) == 3) {
$atencion_aviso = Atencion::find($ids[2]->id);
if ($atencion_aviso->telefono == null) {
$telefono = User::find($atencion_aviso->user_id)->telefono;
if ($telefono == null) {
$telefono = "no hay telefono";
}
} else {
$telefono = $atencion_aviso->telefono;
}
//aca se envia el sms al telefono
$mensaje = "Quedan%203%20personas%20para%20su%20turno:" . $telefono;
//$consulta=json_decode(file_get_contents("https://rest.nexmo.com/sms/json?api_key=1e6c4f1d&api_secret=d7484e91&from=NEXMO&to=51994085900&text=".$mensaje), true);
} else {
$telefono = "";
}
//return $atencion;
return ["telefono" => $telefono, "consulta" => $consulta, "usuario" => User::find($atencion->user_id)];
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function getIndex()
{
header("Access-Control-Allow-Origin: *");
$result = User::all();
return $result;
}
public function getOrm()
{
$result = User::first();
dd($result->full_name);
//dd($result->getFullNameAttribute());
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @param Request $request
* @return Response
*/
public function destroy($id, Request $request)
{
abort(500);
$user = User::findOrFail($id);
$user->delete();
$message = $user->full_name . ' fue eliminado de nuestros registros';
if ($request->ajax()) {
/*return $message;*/
return response()->json(['id' => $user->id, 'message' => $message]);
}
Session::flash('message', $message);
return redirect()->route('admin.users.index');
}
public function getOrm()
{
$users = User::select('id', 'first_name')->with('profile')->where('first_name', '<>', 'Duilio')->orderBy('first_name', 'ASC')->get();
dd($users->toArray());
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(CreateUserRequest $request)
{
$user = User::create($request->all());
return redirect()->route('admin.users.index');
}
/**
* Create a new user instance after a valid registration.
*
* @param array $data
* @return User
*/
public function create(array $data)
{
return User::create(['name' => $data['name'], 'email' => $data['email'], 'password' => bcrypt($data['password'])]);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$user = User::FindOrFail($id);
$user->delete();
\Session::Flash('message', 'El Usuario: ' . $user->name . ' fue Eliminado');
return redirect()->route('Admin.user.index');
}
