public function showProfile(Request $request, $id = null)
{
$user = User::find($id != null ? $id : $request->user()->id);
if ($user != null) {
if ($user->city_id != 0) {
$city = Cities::find($user->city_id);
} else {
$city = null;
}
if ($user->birth_date != "0000-00-00") {
$user->age = Helper::ageCalculator($user->birth_date);
}
if ($user->ava != null) {
$img = $user->ava;
$user->ava = '/upload/' . $img;
}
if ($user->id == $request->user()->id) {
$user->self = true;
} else {
$user->self = false;
}
return view()->make('user.show', array('user' => $user, 'city' => $city));
} else {
return view()->make('error.access_denied');
}
}
public function getList(Request $request, $id = null)
{
if ($id != null) {
$s = Seances::find($id);
$c = Cinemas::find($s->cinema_id);
$city_id = $c->city_id;
} else {
$city_id = $request->input('city_id');
}
$users = new User();
if ($request->input('gender')) {
$users = $users->where("gender", '=', $request->input('gender'));
}
if ($request->input('city_id') != 0) {
$users = $users->where("city_id", '=', $city_id);
}
if ($request->input('age_from') != 0) {
$users = $users->where(DB::raw("TIMESTAMPDIFF(YEAR,birth_date,CURDATE())"), '>=', $request->input('age_from'));
}
if ($request->input('age_to') != 0) {
$users = $users->where(DB::raw("TIMESTAMPDIFF(YEAR,birth_date,CURDATE())"), '<=', $request->input('age_to'));
}
$users = $users->where("status", "enable");
$users = $users->where("id", '<>', $request->user()->id);
$users = $users->get();
$cities = Cities::orderBy('city')->get();
$cityList = [];
$cityList[0] = 'Любой';
foreach ($cities as $key => $value) {
$cityList[$value->id] = $value->city;
}
foreach ($users as $key => $user) {
if ($user->ava != 'noava.jpeg') {
$img = $user->ava;
$users[$key]->ava = '/upload/' . $img;
} else {
$users[$key]->ava = '/images/noava.jpeg';
}
$age = Helper::ageCalculator($user->birth_date);
$users[$key]->age = $age == null ? " " : $age;
if ($user->city_id != '0') {
$users[$key]->city = Cities::find($user->city_id)->city;
} else {
$users[$key]->city = " ";
}
}
return view()->make('search.user_filter', array('users' => $users, 'cityList' => $cityList, 'city_id' => $city_id, 'age_from' => $request->input('age_from') ? $request->input('age_from') : 0, 'age_to' => $request->input('age_to') ? $request->input('age_to') : 0, 'gender' => $request->input('gender'), 'id' => $id));
}
