countRelief($getReliefWhere, $getReliefBetween); // 查询系统设置表救济金领取表. $getConfigSelect = [ 'systemconfig_data', 'systemconfig_status', 'systemconfig_id', ]; $getConfigWhere['systemconfig_name'] = 'relief'; $getSystemconfig = $reliefDataModel->getSystemconfig($getConfigSelect, $getConfigWhere); // 查询用户余额. $getUserSelect = ['membersDetailed_cash']; $getUserWhere['members_id'] = $uid; $cash = $userInfoModel->userInfo($getUserSelect, $getUserWhere); // 查询用户游戏余额. $gameMoneySelect = ['gameMoney_money']; $gameMoneyWhere['members_id'] = $uid; $gameMoney = $userInfoModel->gameMoney($gameMoneySelect, $gameMoneyWhere); // 获取用户总余额. $allCash = $cash['membersDetailed_cash']; foreach ($gameMoney as $v) { $allCash += $v['gameMoney_money']; } // 验证是否可领取. $data = json_decode($getSystemconfig[0]['systemconfig_data'], true); $status = $getSystemconfig[0]['systemconfig_status']; if ($res >= $data['count']) { return toJson(-30002); } else if ($data['condition'] < $allCash) { return toJson(-30003); } if ($status == 1 && $res < $data['count'] && $data['condition'] >= $allCash) { DB::beginTransaction(); $upUserInfoWhere['members_id'] = $uid; $upUserInfoData['membersDetailed_cash'] = ($data['mony'] + $cash['membersDetailed_cash']); // 修改用户信息. $upUserInfo = $userInfoModel->upUserInfo($upUserInfoWhere, $upUserInfoData); // 新增救济金记录. $orderId = getOrderId(); $addReliefData = [ 'getrelief_identity' => $orderId, 'members_id' => $uid, 'getrelief_addtime' => time(), 'getrelief_mony' => $data['mony'], 'getrelief_begin_money' => $cash['membersDetailed_cash'], 'getrelief_end_money' => ($data['mony'] + $cash['membersDetailed_cash']), ]; $addRelief = $reliefDataModel->addRelief($addReliefData); if ($addRelief && $upUserInfo) { DB::commit(); return toJson(1, '成功', ['money' => ($data['mony'] + $cash['membersDetailed_cash'])]); } else { return toJson(-2); DB::rollBack(); } } else { return toJson(-30003); }//end if } catch (Exception $e) { echo $e->getMessage(); }//end try } }