/** * 计算黑水值 * Execute the console command. * @return mixed */ public function fire() { $i = 0; $black_water_val = (int) getenv('BLACK_WATER'); while (true) { $result = UserBase::where('user_id', '>', $i)->orderBy('user_id', 'asc')->limit($this->limit)->get()->toArray(); if (empty($result)) { break; } foreach ($result as $value) { $user_login_log = UserLoginLog::where('user_id', $value['user_id'])->where('date', date('Ymd', strtotime('-1 day')))->first(); if (empty($user_login_log)) { $user_black_water = new UserBlackWater(); $user_black_water_result = $user_black_water->where('user_id', $value['user_id'])->first(); if (empty($user_black_water_result)) { $user_black_water->user_id = $value['user_id']; $user_black_water->black_water = $black_water_val; $user_black_water->save(); } else { $user_black_water->where('user_id', $value['user_id'])->update(['black_water' => $user_black_water_result->black_water + $black_water_val]); } } $i = $value['user_id']; } } }
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 $user_id * @return array */ public function bankInfo($user_id) { $data = []; $user_black_water = UserBlackWater::where('user_id', $user_id)->first(); $data['water_num'] = empty($user_black_water) ? 0 : $user_black_water->black_water; $user_financial = new UserFinancial(); $data['person_water'] = $user_financial->sum('water_count'); $user_financial_result = $user_financial->where('user_id', $user_id)->first(); $data['protect_num'] = $user_financial_result ? $user_financial_result->water_count : 0; $data['water_rank'] = UserRank::getUserRank($user_id); return ['status' => true, 'message' => 'success', 'info' => $data]; }