我需要从table - privacy_settings
, 中获取值column - city
,基于user_id
我{{ $user['id'] }}
从 table users
, column 的视图中得出的值id
。
这是我的控制器:
public function findUser($role = null,$search = null,$name = null,$country = null,$city = null,$industry = null,$department = null,$function_name = null,$timeframe =null,$language_skills = null,$organization_type = null,$contact_level = null,$page = null)
{
// if($page == "")
// {
// return redirect('find-user/'.Input::get('role').'/'.Input::get('search').'/1');
// }
// return $role;
// if($page == "")
// {
// $page = 1;
// }
$data = $this->data;
$data['users'] = User::all();
$page = Input::get('page'); // Get the current page or default to 1, this is what you miss!
$perPage = 12;
$offset = ($page * $perPage) - $perPage;
$data['role'] = Input::get('role');
$search = Input::get('search');
$name = Input::get('name');
$country = Input::get('country');
$city = Input::get('city');
$industry = Input::get('industry');
$language_skills = Input::get('language_skills');
$department = Input::get('department');
$function_name = Input::get('function_name');
$company = Input::get('company');
$timeframe = Input::get('timeframe');
$organization_type = Input::get('organization_type');
$contact_level = Input::get('contact_level');
$data['search'] = $search;
// DB::enableQueryLog();
$users = User::with('country','industry','organization_type','career_path','career_path.industry','career_path.department','career_path.functions','role');
$private = DB::table('privacy_settings')->get();
我怎样才能做到这一点?我想它应该是类似的$private = DB::table('privacy_settings')->where('id', '=', 'city')->get();
,但这不起作用。
所以,现在我{{ $user['id'] }}
从 table Users
, column 中获得了用户的 id id
。在表中,privacy_settings
我有一列user_id
具有用户 ID 和city
2 个值:0 代表公共,1 代表私人。我需要根据每个值来获取这些值user_id
所以基本上,从 user_id 列中获取集合,其中 user_id = 您在刀片中传递的 id。替换$user['id']
为该值。
$temparr = [];
$buffer = 0;
foreach($users as $user){
$arr = [];
$privacy = PrivancySetting::where('user_id', $user['id'])->first();
$city = $privacy['city'];
if($city == 0){
$buffer = 0;
$arr['id'] = $user['id'];
$arr['perm'] = $buffer;
array_push($temparr, $arr);
}else{
$buffer = 1;
$arr['id'] = $user['id'];
$arr['perm'] = $buffer;
array_push($temparr, $arr);
}
}
将 $temparr 传递给您的视图并在其中执行循环以交叉检查并隐藏您需要隐藏的内容!
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句