protected function formatUsers($users)
{
if (!$users) {
return [];
}
$user_list = [];
$user_ids = [];
foreach ($users as $user) {
$user_ids[] = $user->user_id;
if ($user->type == UserBase::TYPE_ADMIN) {
$type_text = '管理员';
} elseif ($user->type == UserBase::TYPE_BUSINESS) {
$type_text = '商家';
} else {
$type_text = '用户';
}
$user_list[] = array_merge($user->toArray(), ['type_text' => $type_text, 'status_text' => $user->isOpen() ? '已激活' : '未激活', 'is_active' => $user->isOpen(), 'image_url' => '', 'image_url_real1' => '', 'image_url_real2' => '', 'image_url_real3' => '', 'water_count' => 0, 'black_water' => 0, 'send_water' => 0, 'public_count' => 0, 'giving' => 0, 'user_address' => '', 'user_desc' => '', 'user_http' => '', 'user_company_lat' => '', 'user_company_lng' => '']);
}
//获得头像信息
$user_image_rt = UserImage::whereIn('user_id', $user_ids)->get();
foreach ($user_list as &$user) {
foreach ($user_image_rt as $user_image_rt_v) {
if ($user_image_rt_v->type == 1 && $user['user_id'] == $user_image_rt_v->user_id) {
$user['image_url'] = $user_image_rt_v->path();
} elseif ($user_image_rt_v->type == 2 && $user['user_id'] == $user_image_rt_v->user_id) {
$user['image_url_real1'] = $user_image_rt_v->path();
} elseif (empty($user['image_url_real2']) && $user_image_rt_v->type == 3 && $user['user_id'] == $user_image_rt_v->user_id) {
$user['image_url_real2'] = $user_image_rt_v->path();
} elseif ($user_image_rt_v->type == 3 && $user['user_id'] == $user_image_rt_v->user_id) {
$user['image_url_real3'] = $user_image_rt_v->path();
}
}
}
//获得亲水值
$user_financial_rt = UserFinancial::whereIn('user_id', $user_ids)->get();
foreach ($user_list as &$user) {
foreach ($user_financial_rt as $user_financial_rt_v) {
if ($user['user_id'] == $user_financial_rt_v->user_id) {
$user['water_count'] = $user_financial_rt_v->water_count;
$user['send_water'] = $user_financial_rt_v->send_water;
$user['public_count'] = $user_financial_rt_v->public_count;
$user['giving'] = $user_financial_rt_v->giving;
}
}
}
//获得黑水值
$user_black_rt = UserBlackWater::whereIn('user_id', $user_ids)->get();
foreach ($user_list as &$user) {
foreach ($user_black_rt as $user_black_rt_v) {
if ($user['user_id'] == $user_black_rt_v->user_id) {
$user['black_water'] = $user_black_rt_v->send_water;
}
}
}
//获得公司信息
$user_company_extend_rt = UserCompanyExtend::whereIn('user_id', $user_ids)->get();
foreach ($user_list as &$user) {
foreach ($user_company_extend_rt as $user_company_extend_rt_v) {
if ($user['user_id'] == $user_company_extend_rt_v->user_id) {
$user['user_address'] = $user_company_extend_rt_v->user_address;
$user['user_company_name'] = $user_company_extend_rt_v->user_company_name;
$user['user_desc'] = $user_company_extend_rt_v->user_desc;
$user['user_http'] = $user_company_extend_rt_v->user_http;
$user['user_company_lat'] = $user_company_extend_rt_v->user_company_lat;
$user['user_company_lng'] = $user_company_extend_rt_v->user_company_lng;
}
}
}
return $user_list;
}
/**
* 亲水圈活动详情
* @param $params
* @param $user_id
* @return array
*/
public function circleDetail($params, $user_id)
{
if (!$params->get('circleID')) {
return ['status' => false, 'message' => '活动ID不能为空!', 'info' => []];
}
/** @var $activity \App\Model\Activity */
$activity = new Activity();
$activity_result = $activity->where('activity_id', $params->get('circleID'))->StatusOk()->first();
if (empty($activity_result)) {
return ['status' => false, 'message' => '活动不存在!', 'info' => []];
}
$activity_comment = new ActivityComment();
$data['active_id'] = $params->get('circleID');
$data['video_url'] = ActivityImage::getImages($params->get('circleID'), ActivityImage::TYPE_IMAGE_IS_GIF);
$data['title'] = $activity_result->title;
$data['content'] = $activity_result->desc;
$data['address'] = $activity_result->address;
$data['create_time'] = (string) $activity_result->created_at;
$data['is_focus'] = UserFocus::userIsFocus($params->get('circleID'), $user_id);
$data['support_count'] = $activity_result->focus_count;
$data['comment_count'] = $activity_comment->where('activity_id', $params->get('circleID'))->count();
$data['focus_count'] = (new UserFocus())->where('activity_id', $params->get('circleID'))->count();
$activity_comment_result = $activity_comment->where('activity_id', $params->get('circleID'))->orderBy('created_at', 'desc')->limit(2)->get();
if (!empty($activity_comment_result)) {
$user_ids = [];
foreach ($activity_comment_result as $activity_comment_result_v) {
array_push($user_ids, $activity_comment_result_v->user_id);
}
$user_base = new UserBase();
$user_base_result = $user_base->whereIn('user_id', $user_ids)->get();
$user_image = new UserImage();
$user_image_result = $user_image->whereIn('user_id', $user_ids)->get();
$user_image_list = [];
foreach ($user_image_result as $user_image_result_v) {
$user_image_list[$user_image_result_v->user_id] = $user_image_result_v->path();
}
$user_list = [];
foreach ($user_base_result as $user_base_result_v) {
$user_list[$user_base_result_v->user_id] = ['id' => $user_base_result_v->user_id, 'name' => $user_base_result_v->user_name, 'image_url' => isset($user_image_list[$user_base_result_v->user_id]) ? $user_image_list[$user_base_result_v->user_id] : ActivityImage::defaultImage()];
}
foreach ($activity_comment_result as $activity_comment_result_v_v) {
if (isset($user_list[$activity_comment_result_v_v->user_id])) {
$data['comment_list'][] = ['comment_id' => $activity_comment_result_v_v->id, 'comment_name' => $user_list[$activity_comment_result_v_v->user_id]['name'], 'comment_image_url' => $user_list[$activity_comment_result_v_v->user_id]['image_url'], 'comment_date' => (string) $activity_comment_result_v_v->created_at, 'comment_detail' => $activity_comment_result_v_v->content];
}
}
}
return ['status' => true, 'message' => '获取成功!', 'info' => $data];
}
/**
* 水地图列表
* @param $params
* @return array
*/
public function mapList($params)
{
if ($params->get('longitude') && $params->get('latitude')) {
// $squares = $this->returnSquarePoint($params->get('longitude'), $params->get('latitude'), $params->get('radius') ?: null);
// $result = UserCompanyExtend::where('user_company_lat', '>', '0')
// ->where('user_company_lat', '>=', $squares['right-bottom']['lat'])
// ->where('user_company_lat', '<=', $squares['left-top']['lat'])
// ->where('user_company_lng', '>=', $squares['left-top']['lng'])
// ->where('user_company_lng', '<=', $squares['right-bottom']['lng'])
// ->get();
$user_company_extend = new UserCompanyExtend();
$result = $user_company_extend->get();
if (empty($result)) {
return ['status' => true, 'message' => '获取成功!', 'info' => []];
}
$user_ids = [];
foreach ($result as $result_val) {
$user_ids[] = $result_val->user_id;
}
$user_images_result = UserImage::whereIn('user_id', $user_ids)->Head()->get();
$images = [];
if (!empty($user_images_result)) {
foreach ($user_images_result as $user_images_result_val) {
$images[$user_images_result_val->user_id] = $user_images_result_val->path();
}
}
$user_financial_result = UserFinancial::whereIn('user_id', $user_ids)->get();
$financial = [];
if (!empty($user_financial_result)) {
foreach ($user_financial_result as $user_financial_result_val) {
$financial[$user_financial_result_val->user_id] = $user_financial_result_val->water_count;
}
}
$data = [];
foreach ($result as $result_value) {
$data[] = ['store_id' => $result_value->user_id, 'store_name' => $result_value->user_company_name, 'image_url' => isset($images[$result_value->user_id]) ? $images[$result_value->user_id] : '', 'left_num' => isset($financial[$result_value->user_id]) ? $financial[$result_value->user_id] : 0, 'latitude' => $result_value->user_company_lat, 'longitude' => $result_value->user_company_lng, 'distance' => $this->getDistance($params->get('latitude'), $params->get('longitude'), $result_value->user_company_lat, $result_value->user_company_lng)];
}
return ['status' => true, 'msg' => 'success', 'info' => $data];
} else {
return ['status' => false, 'message' => '缺少经纬度参数!', 'info' => []];
}
}
