/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($id, CreateUserRequest $request)
{
$especialista = User::findOrFail($id);
$especialista->fill($request->all());
$especialista->save();
return redirect()->route('admin.especialistas.index');
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$listado = Listado_horas::all();
$especialista = User::where('type', 'Especialista')->get(['first_name', 'last_name', 'id']);
$paciente = User::where('type', '!=', 'Especialista')->get(['first_name', 'last_name', 'id']);
return view('admin.citas.cita', compact('listado', 'especialista', 'paciente'));
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(EditUserPerfilRequest $request, $id)
{
$user = User::findOrFail($id);
$user->fill($request->all());
$user->save();
return redirect()->route('admin.userPerfil.index');
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
$pacientes = User::where('type', '!=', 'Especialista')->get(['first_name', 'last_name', 'id']);
$especialistas = User::where('type', 'Especialista')->get(['first_name', 'last_name', 'id']);
$tratamientos = Tratamiento::all();
return view('admin.diagnostico.create', compact('pacientes', 'especialistas', 'tratamientos'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index(Request $request)
{
$users = User::query()->orderBy('first_name', 'asc')->get();
$usuarios = DB::table('users')->lists('first_name', 'id');
if ($request->ajax()) {
return response()->json($users);
}
return view('admin.intervenciones.create', compact('users', 'usuarios'));
}
public function reporteCitas(Request $request)
{
$fecha = $request->fecha;
$id = $request->especialista;
$especialista = User::where('id', $id)->first();
$citas = Horas_agendadas::where('fecha', $fecha)->where('id_especialista', $id)->get();
$view = View::make('pdf.reporteCitas.index', compact('invoice', 'fecha', 'citas'))->with('especialista', $especialista)->render();
$pdf = App::make('dompdf.wrapper');
$pdf->loadHTML($view);
//return $pdf->download('usuarios.pdf');
return $pdf->stream('invoice');
}
public function paciente(Request $request)
{
$id = Auth::user()->id;
$diagnosticos = Diagnostico::especialista($request->get('especialista'))->fecha($request->get('fecha'))->Where('id_usuario', $id)->orderBy('fecha', 'asc')->paginate(8);
$especialistas = User::where('type', 'especialista')->orderBy('first_name', 'asc')->get(['first_name', 'last_name', 'id']);
return view('admin.diagnostico.paciente', compact('diagnosticos', 'especialistas'));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$pagos = Pagos::findOrFail($id);
$pacientes = User::where('type', '!=', 'Especialista')->orderBy('first_name', 'asc')->get(['first_name', 'last_name', 'id']);
return view('admin.pagos.edit', compact('pagos', 'pacientes'));
}
/**
* 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'])]);
}
public function pagar($id)
{
$user = User::findOrFail($id);
return view('secretaria.users.pagar', compact($user));
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update(EditUserRequest $request, $id)
{
$especialista = User::findOrFail($id);
$especialista->fill($request->all());
$especialista->save();
$message = $this->user->first_name . ' ' . $this->user->last_name . ' fue editado en la Base de Datos';
Session::flash('message', $message);
return redirect()->route('admin.users.index');
}
public function editar_cita()
{
$listado = Hora::orderBy('hora', 'asc')->get();
$especialista = User::where('type', 'Especialista')->get(['first_name', 'last_name', 'id']);
$paciente = User::where('type', '!=', 'Especialista')->get(['first_name', 'last_name', 'id']);
$disponibles = Hora::orderBy('hora', 'asc')->get();
return view('admin.citas.edit', compact('listado', 'especialista', 'paciente', 'disponibles'));
}
public function getData()
{
$users = User::query()->orderBy('first_name', 'ASC')->paginate(100000);
return $users;
}
public function verHistorial($id)
{
$paciente = User::findOrFail($id);
$diagnosticos = Diagnostico::where('id_usuario', $id)->paginate();
return view('admin.historiales.index', compact('paciente', 'diagnosticos'));
}
public function getData()
{
$users = User::where('saldo', '>', 0)->orderBy('first_name', 'ASC')->paginate(100000);
return $users;
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$usuario = User::findOrFail($id);
return view('admin.pagar.create', compact('usuario'));
}
public function pagado(Requests\CreatePagoRequest $request, $id)
{
$pago = new Pagos($request->all());
$usuario = User::findOrFail($id);
if ($usuario->saldo > 0 && $pago->monto <= $usuario->saldo) {
$saldo = $usuario->saldo;
$saldo2 = $usuario->saldo = $saldo - $pago->monto;
DB::table('users')->where('id', $usuario->id)->update(['saldo' => $saldo2]);
$pago = Pagos::create($request->all());
$message = 'El Paciente ' . $usuario->first_name . ' ' . $usuario->last_name . ' pago un total de: ' . '$' . number_format($pago->monto);
Session::flash('message', $message);
return Redirect::route('admin.pagar.index');
} else {
$message = $usuario->first_name . ' ' . $usuario->last_name . ' no registra deuda en el sistema o el monto de ' . '$' . number_format($pago->monto) . ' que se quiere pagar es superior al saldo: ' . '$' . number_format($usuario->saldo);
Session::flash('message', $message);
return Redirect::route('admin.users.index');
}
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$intervenciones = DB::table('intervencions')->join('consultas', 'intervencions.id_consulta', '=', 'consultas.id')->join('users', 'consultas.id', '=', 'users.id')->join('tratamientos', 'intervencions.id_tratamiento', '=', 'tratamientos.id')->select('users.*', 'intervencions.*', 'consultas.*', 'tratamientos.*')->where('users.id_especialidad', $id)->get();
$users = User::Where('id', $id)->first();
return view('admin.intervenciones.index', compact('users', 'intervenciones'));
}
