/**
* @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];
}
/**
* 接受手机号 验证码 分享批次-邀请码
* @param $params
* @return array
*/
public function shareGet($params)
{
$code = $params->get('code');
$e = explode('-', $code);
if (count($e) == 2) {
$user_share_log = new UserShareLog();
$user_share_log_tr = $user_share_log->where('share_time', $e[0])->first();
if (empty($user_share_log_tr)) {
return ['status' => false, 'message' => '非法参数', 'code' => 1, 'info' => []];
}
if ($user_share_log_tr->status == UserShareLog::SHARE_NO) {
return ['status' => false, 'message' => '分享已经结束', 'code' => 2, 'info' => []];
}
$rt = $this->checkVerify($params->get('cellphone'), $params->get('verify'));
if (!$rt['status']) {
return ['status' => false, 'code' => 3, 'message' => $rt['message'], 'userInfo' => []];
}
//注册成为用户
$user_base = new UserBase();
$user_base_rt = $user_base->where('user_cellphone', $params->get('cellphone'))->first();
if (empty($user_base_rt)) {
$user_id = $user_base->user_id;
$password = mt_rand(100000, 999999);
$user_base->user_cellphone = $params->get('cellphone');
$user_base->password = $this->encryptPassword($password);
$user_base->user_name = !empty($user_name) ? $user_name : '';
$user_base->invite_code = crc32(md5($params->get('cellphone')));
if ($user_base->save()) {
//发送短信提示
$user_verify = new UserVerify();
$content = '感谢你注册水想世界，您的APP登入密码为' . $password . '，请尽快登入之后修改密码噢～';
$user_verify->getSendMsgUrl($params->get('cellphone'), $content);
//建立图片
$user_image = new UserImage();
$user_image->user_id = $user_base->user_id;
$user_image->image_url = UserImage::defaultImage();
$user_image->type = UserImage::TYPE_HEAD;
$user_image->save();
//绑定关系
$user_relationship = new UserRelationship();
$user_relationship_rt = $user_relationship->where('user_id', $user_share_log_tr->user_id)->where('guest_id', $user_base->user_id)->first();
if (!empty($user_relationship_rt)) {
$user_relationship->user_id = $user_share_log_tr->user_id;
$user_relationship->guest_id = $user_base->user_id;
$user_relationship->save();
}
}
} else {
$user_id = $user_base_rt->user_id;
}
$user_share_receive_log = new UserShareReceiveLog();
$s = $user_share_receive_log->where('share_id', $user_share_log_tr->id)->where('share_receive_user_id', $user_id)->first();
if (!empty($s)) {
return ['status' => false, 'code' => 4, 'message' => '您已经领取过', 'info' => ['water_count' => $s->share_water_count]];
}
if (!empty($user_id)) {
//开始分享
$water = 0;
$share_count = 0;
$share_status = 1;
switch ($user_share_log_tr->share_count) {
case 0:
$water = ceil($user_share_log_tr->share_water_count / 3);
$share_count = 1;
break;
case 1:
$water = ceil(($user_share_log_tr->share_water_count - $user_share_log_tr->share_receive) / 2);
$share_count = 2;
break;
case 2:
$water = $user_share_log_tr->share_water_count - $user_share_log_tr->share_receive;
$share_count = 3;
$share_status = 0;
break;
}
//放入用户账户
$user_financial = new UserFinancial();
$user_f_rt = $user_financial->where('user_id', $user_id)->first();
if (empty($user_f_rt)) {
$user_financial->user_id = $user_id;
$user_financial->water_count = $water;
$user_financial->save();
} else {
$user_financial->where('user_id', $user_id)->update(['water_count' => $user_f_rt->water_count + $water]);
}
$user_share_log->where('id', $user_share_log_tr->id)->update(['share_count' => $share_count, 'status' => $share_status, 'share_receive' => $user_share_log_tr->share_receive + $water]);
//建立领取记录
$user_send_water = new UserSendWater();
$user_send_water->user_id = $user_share_log_tr->user_id;
$user_send_water->water_count = $water;
$user_send_water->accept_user_id = $user_id;
$user_send_water->overdue_date = time();
$user_send_water->share_type = UserSendWater::SHARE_TYPE_WEIXIN;
$user_send_water->status = UserSendWater::STATUS_IS_TRUE;
$user_send_water->save();
//记录每期领取的人
$user_share_receive_log->share_id = $user_share_log_tr->id;
$user_share_receive_log->share_receive_user_id = $user_id;
$user_share_receive_log->share_water_count = $water;
$user_share_receive_log->save();
return ['status' => true, 'message' => '领取成功', 'info' => ['water_count' => $water]];
} else {
return ['status' => false, 'code' => 5, 'message' => '系统一个人旅行去了，请重试!', 'info' => []];
}
} else {
return ['status' => false, 'code' => 1, 'message' => '非法参数', 'info' => []];
}
}
