/** * @param $job * @param $data */ public function fire($job, $data) { $job->delete(); if (!empty($data['send_id'])) { $user_send_water = new UserSendWater(); $result = $user_send_water->where('id', $data['send_id'])->first(); if (!empty($result) && $result->status == UserSendWater::STATUS_IS_FALSE) { $user_send_water->where('id', $data['send_id'])->update(['status' => UserSendWater::STATUS_IS_ACTIVE_FALSE]); $user_financial_result = UserFinancial::where('user_id', $result->user_id)->first(); UserFinancial::where('user_id', $result->user_id)->update(['water_count' => $user_financial_result->water_count + $result->water_count, 'send_water' => $user_financial_result->send_water - $result->water_count]); } } }
/** * 回收亲水值 * Execute the console command. * @return mixed */ public function fire() { $i = 0; while (true) { $user_send_water = new UserSendWater(); $user_send_rt = $user_send_water->where('status', UserSendWater::STATUS_IS_FALSE)->where('id', '>', $i)->limit($this->limit)->orderBy('id', 'asc')->get()->toArray(); if (empty($user_send_rt)) { break; } $user_financial = new UserFinancial(); foreach ($user_send_rt as $user_send_rt_v) { //如果创建时间比现在超过48小时则算无效 if (strtotime($user_send_rt_v['created_at']) - time() >= UserSendWater::getSystemTime()) { $result = $user_send_water->where('id', $user_send_rt['id'])->first(); if (!empty($result) && $result->status == UserSendWater::STATUS_IS_FALSE) { $user_send_water->where('id', $user_send_rt['id'])->update(['status' => UserSendWater::STATUS_IS_ACTIVE_FALSE]); $user_financial_result = $user_financial->where('user_id', $result->user_id)->first(); $user_financial->where('user_id', $result->user_id)->update(['water_count' => $user_financial_result->water_count + $result->water_count, 'send_water' => $user_financial_result->send_water - $result->water_count]); } } $i = $user_send_rt['id']; } } }
/** * 亲水列表 * @param $params * @param $user_id * @return array */ public function bagList($params, $user_id) { $page = $params->get('page') ?: 1; $count = $params->get('count') ?: 10; $user_send_water = new UserSendWater(); $result = []; $send_water = 0; if ($params->get('status')) { switch ($params->get('status')) { case 0: $result = $user_send_water->where('accept_user_id', $user_id)->where('status', UserSendWater::STATUS_IS_FALSE)->where('overdue_date', '>=', time())->skip(($page - 1) * $count)->take($count)->get()->toArray(); $send_water = $user_send_water->where('accept_user_id', $user_id)->where('status', UserSendWater::STATUS_IS_FALSE)->count(); break; case 1: $result = $user_send_water->where('accept_user_id', $user_id)->where('status', UserSendWater::STATUS_IS_TRUE)->where('overdue_date', '>=', time())->skip(($page - 1) * $count)->take($count)->get()->toArray(); $send_water = $user_send_water->where('accept_user_id', $user_id)->where('status', UserSendWater::STATUS_IS_FALSE)->count(); break; case 2: $result = $user_send_water->where('accept_user_id', $user_id)->whereBetween('status', [0, 2])->where('overdue_date', '<', time())->skip(($page - 1) * $count)->take($count)->get()->toArray(); $send_water = $user_send_water->where('status', UserSendWater::STATUS_IS_FALSE)->count(); break; } } else { $result = $user_send_water->where('accept_user_id', $user_id)->skip(($page - 1) * $count)->take($count)->get()->toArray(); $send_water = $user_send_water->where('accept_user_id', $user_id)->count(); } $next_page = ($page - 1) * $count >= $send_water ? $page : $page + 1; $pager = ['page' => $page, 'count' => $count, 'total' => $send_water, 'next' => $next_page]; if (empty($result)) { return ['status' => true, 'message' => 'success', 'info' => [], 'pager' => $pager]; } $user_ids = []; foreach ($result as $value) { $user_ids[] = $value['user_id']; } $user_result = UserBase::whereIn('user_id', array_unique($user_ids))->get()->toArray(); $user_list = []; foreach ($user_result as $user_result_val) { $user_list[$user_result_val['user_id']] = $user_result_val['user_name'] ?: '匿名'; } $list = []; foreach ($result as $value) { $list[] = ['bag_id' => $value['id'], 'water_num' => $value['water_count'], 'from_id' => $value['user_id'], 'from_name' => $user_list[$value['user_id']], 'create_time' => $value['created_at'], 'get_time' => $value['updated_at'], 'status' => $value['status']]; } return ['status' => true, 'message' => 'success', 'info' => $list, 'pager' => $pager]; }