$params['user_id']])->sum('money'); $user['invite_count'] = UserRelation::where(['parent_id' => $params['user_id'],'level' => 1])->count(); //查询会员等级 $member_id = UtilsService::get_user_member_id($params['user_id']); $userMember = UserMember::field('id,name') ->where(['id' => $member_id]) ->where(['is_show' => 1]) ->findOrEmpty(); return [ 'user' => $user, 'member' => $userMember, ]; } /** * @notes 会员列表 * @param $params * @return array * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException * @author BD * @date 2024/02/22 10:54 */ public static function getAllData(array $params) { $field = ['id, name as text, logo, bg_img as image, text_color, money, level1_num,level1_vip_id, item_num, item_add_rate,mine_speed']; $members = UserMember::field($field) ->append(['vip_name']) ->where(['is_show' => 1]) ->order(['money' => 'asc', 'id' => 'desc']) ->select() ->toArray(); $config_mine = ConfigService::get('website', 'mine'); foreach ($members as &$member) { $member['mine_speed'] = $member['mine_speed'].' '.$config_mine['symbol'].' / H'; } return $members; } /** * @notes 加入会员 * @param $params * @return array|false * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException * @author BD * @date 2024/02/22 10:54 */ public static function join(array $params) { Db::startTrans(); try { //判断会员等级是否存在 $member = UserMember::where(['id' => $params['id']])->findOrEmpty(); $data = [ 'user_id' => $params['user_id'], 'member_id' => $member['id'], ]; $record = UserMemberRecord::create($data); //记录日志 UtilsService::user_finance_add( $data['user_id'], 10, 2, $member['price'], '' ); //用户资金修改 UtilsService::user_money_change($data['user_id'], 2, $member['price'],'user_money'); Db::commit(); return [ 'order_id' => $record['id'], ]; } catch (\Exception $e) { Db::rollback(); self::setError($e->getMessage()); return false; } } }