def index(request, **kwargs):
"""
会员首页
"""
error = ""
template_name = "member/base.html"
UserBasic = kwargs.pop("Mem")
request.session["contactor_name"] = UserBasic.name
print request.session["contactor_name"]
ValueSetting = value_setting.objects.defer("grade_summit", "mall_VIP_threshold").all()[0]
UserBasic = get_submmit_level(UserBasic=UserBasic)
# cursor = connection.cursor()
# try:
# cursor.execute('SELECT FA_SUM.father_id as min_id , max(MA_SUM.id) as summit_level FROM (SELECT FATHER.id AS father_id , count(SON.id) AS summit_son_number FROM member_user_recommender AS RECC INNER JOIN member_user_basic AS FATHER ON FATHER.id = RECC.recommending_id INNER JOIN member_user_basic AS SON ON SON.id = RECC.recommended_id ,management_value_setting AS SETTING WHERE SON.mall_team_score > SETTING.grade_summit GROUP BY FATHER.id AS FA_SUM INNER JOIN management_mall_summit AS MA_SUM ON FA_SUM.summit_son_number >= MA_SUM.summit_num where FA_SUM.father_id=%s GROUP BY min_id',UserBasic.id)
# cursor.execute('SELECT `V_SETTLE_CWEB_BASIC`.`level_name`,`V_SETTLE_CWEB_BASIC`.`threshold_value`,`V_SETTLE_CWEB_BASIC`.`gain_rate`,`V_SETTLE_CWEB_BASIC`.`is_summit` FROM `rtyk_triple`.`V_SETTLE_CWEB_BASIC` where id=%s',UserBasic.id)
# level = cursor.fetchall()[0]
# is_summit = level[3]
# UserBasic.level = level[0]
# UserBasic.is_summit = is_summit
# except:
# UserBasic.level = "新手上路"
# UserBasic.is_summit = False
notices = Notice.objects.notices_for(request.user, on_site=True, unseen=True)
request.session["ValueSetting"] = ValueSetting
request.session["name"] = UserBasic.name
if request.method == "POST":
password_2nd = request.POST.get("password_2nd")
result = verify_password_2nd(password_2nd, request.user)
if result:
request.session["password_2nd"] = True
return HttpResponseRedirect(reverse("member_index"))
else:
error = "二级密码错误"
ctx = {"UserBasic": UserBasic, "error": error, "notices": notices}
return render_to_response(template_name, RequestContext(request, ctx))
def member_details(request, template_name=None, **kwargs):
"""
会员和报单中心查看自己的详细信息
"""
UserBasic = kwargs.pop("UserBasic")
request.session["subject"] = "member_center"
UserAddress = ""
role = ""
Level = ""
UserRecommender = ""
UMid = ""
UserContactor = ""
UMax = ""
error3 = ""
error1 = request.GET.get("error1")
error2 = request.GET.get("error2")
ValueSetting = value_setting.objects.defer("stock_share_out_min_amount").get(id=1)
if not UserBasic:
try:
UserBasic = user_basic.objects.filter(user=request.user)[0]
except:
raise Http404
try:
UserAddress = user_address.objects.filter(user=UserBasic).order_by("id")[0]
except:
UserAddress = None
try:
UserRecommender = user_recommender.objects.filter(recommended=UserBasic)[0]
UserBasic.recommending_id = UserRecommender.recommending.number
UserBasic.recommending_name = UserRecommender.recommending.name
except:
UserRecommender = user_recommender(recommended=UserBasic)
UserBasic.recommending_id = "无"
UserBasic.recommending_name = "无"
if UserBasic.role != "MemMin" and UserBasic.role != "MinVIP":
try:
UserMidMem = user_mid_mem.objects.filter(user=UserBasic)
print UserMidMem, "UserMidMem"
UMid = UserMidMem[0]
UserBasic.level = UMid.level.level
UserBasic.level_name = UMid.level.name
Level = member_lv_money.objects.all()
except:
pass
try:
UserContactor = user_contactor.objects.filter(contacted=UserBasic)[0]
UserBasic.contacting_id = UserContactor.contacting.number
UserBasic.contacting_name = UserContactor.contacting.name
UserBasic.contact_area = UserContactor.contact_area
except:
UserContactor = user_contactor(contacted=UserBasic)
UserBasic.contacting_id = "无"
UserBasic.contacting_name = "无"
UserBasic.contact_area = "无"
UserCentralUsual = None
# 报单中心信息
if UserBasic.role == "MemMax":
print UserBasic.role, "================"
try:
UserMaxMem = user_max_mem.objects.filter(user_mid=UMid)
print UserMaxMem, "bbbbbbb"
UMax = UserMaxMem[0]
print UMax, "==================="
if not UMax.is_central:
try:
UserCentralUsual = user_central_usual.objects.filter(user_usual=UMax)[0]
print UserCentralUsual, "ssss"
UserBasic.user_central_number = UserCentralUsual.user_central.user_mid.user.number
UserBasic.user_central_name = UserCentralUsual.user_central.user_mid.user.name
except:
print "sss"
if UMax.is_central == True:
UserBasic.is_central = True
else:
UserBasic.is_central = False
except:
print "ss"
UserBasic.sum = UserBasic.cash + UserBasic.stock_rebuy + UserBasic.stock_repeat
try:
UserAdder = user_adder.objects.defer("adding").filter(added=UserBasic)[0]
except:
UserAdder = None
if request.method == "POST":
can_share_out = request.POST.get("can_share_out")
if can_share_out:
if not UserBasic.can_share_out:
UserBasic.can_share_out = True
extra_context = "申请分红成功"
users = User.objects.filter(is_superuser=True)
notification.send(UserBasic.user, "share_appl", extra_context, True, request.user)
else:
if UserBasic.can_share_out:
UserBasic.can_share_out = False
id_card_number = request.POST.get("id_card_number")
if id_card_number:
UserBasic.id_card_number = id_card_number
stock_hold_max = request.POST.get("stock_hold_max")
if stock_hold_max:
UserBasic.stock_hold_max = stock_hold_max
number = request.POST.get("number")
if number:
UserBasic.number = request.POST.get("number")
bank_account_id = request.POST.get("bank_account_id")
if bank_account_id:
UserBasic.bank_account_id = bank_account_id
city = request.POST.get("city")
if city:
UserBasic.city = city
role = request.POST.get("role")
can_devide = request.POST.get("can_devide")
if can_devide:
if not UserBasic.can_devide:
UserBasic.can_devide = True
else:
if UserBasic.can_devide:
UserBasic.can_devide = False
is_void = request.POST.get("is_void")
if is_void:
if not UserBasic.is_void:
UserBasic.is_void = True
else:
if UserBasic.is_void:
UserBasic.is_void = False
if role:
UserBasic.role = role
if role == "MemVIP":
extra_context = "恭喜你成为了商城VIP"
notification.send(UserBasic.user, "vip_appl", extra_context, True, request.user)
MinUpgradeRecord = min_upgrade_record.objects.filter(user=UserBasic)
if MinUpgradeRecord:
UserBasic.bank_name = MinUpgradeRecord[0].bank_name
UserBasic.bank_account_id = MinUpgradeRecord[0].bank_account_id
UserBasic.bank_account_name = MinUpgradeRecord[0].bank_account_name
UserBasic.id_card_number = MinUpgradeRecord[0].id_card_number
MinUpgradeRecord.state = "sure"
MinUpgradeRecord.save()
elif role == "MemMax":
UMax = user_max_mem(user_mid=UMid)
UMax.save()
elif role == "MemMin":
try:
UMax.delete()
except:
pass
user_central = request.POST.get("user_central")
if user_central:
_userBasic = user_basic.objects.get(number=user_central)
print _userBasic, "_userBasic"
if _userBasic:
_userMidMem = user_mid_mem.objects.get(user=_userBasic)
print _userMidMem, "_userMidMem"
if _userMidMem:
_userMaxMem = user_max_mem.objects.get(user_mid=_userMidMem)
if UserCentralUsual and _userMaxMem:
UserCentralUsual.user_central = _userMaxMem
UserCentralUsual.save()
if not UserCentralUsual and _userMaxMem:
print _userMaxMem, "======================"
UserCentralUsual = user_central_usual()
UserCentralUsual.user_central = _userMaxMem
UserCentralUsual.user_usual = UMax
UserCentralUsual.save()
bank_name = request.POST.get("bank_name")
if bank_name:
UserBasic.bank_name = bank_name
phone = request.POST.get("phone")
if phone:
UserBasic.phone = phone
QQ = request.POST.get("QQ")
if QQ:
UserBasic.QQ = QQ
name = request.POST.get("name")
if name:
UserBasic.name = name
bank_account_name = request.POST.get("bank_account_name")
if bank_account_name:
UserBasic.bank_account_name = bank_account_name
mobile = request.POST.get("mobile")
if mobile:
UserBasic.mobile = mobile
gender = request.POST.get("gender")
if gender:
UserBasic.gender = gender
start_date = request.POST.get("start_date")
if start_date:
UserBasic.start_date = start_date
level = request.POST.get("level")
if level:
if UMid.level.id != level:
_Level = Level.get(id=level)
upgrade_choice = request.POST.get("upgrade_choice")
# if UserBasic.is_void:
# UMid.init_money = _Level.money - UMid.level.money
# UserBasic.is_void = False
# UserBasic.save()
# else:
# UMid.init_money = _Level.money
if upgrade_choice:
if UserBasic.is_void:
UMid.init_money = _Level.money - UMid.level.money
UserBasic.is_void = False
UserBasic.save()
else:
UMid.init_money = _Level.money
call_proc = CallProc()
call_proc.CallProcFuc_2("member_update", UserBasic.id, _Level.money)
UMid.level = _Level
UMid.save()
recommending = request.POST.get("recommending")
if recommending:
# try:
UBasic = user_basic.objects.defer(None).filter(number=recommending)[0]
UserRecommender.recommending = UBasic
UserRecommender.save()
# except:
# error1 = "推荐人不存在"
proxy_style = request.POST.get("proxy_style")
if proxy_style:
if proxy_style == "1":
UserBasic.proxy_city = None
UserBasic.proxy_area = None
UserBasic.proxy_province = None
else:
proxy_province = request.POST.get("proxy_province")
proxy_city = request.POST.get("proxy_city")
proxy_area = request.POST.get("proxy_area")
UserBasic.proxy_city = proxy_city
UserBasic.proxy_area = proxy_area
UserBasic.proxy_province = proxy_province
contacting = request.POST.get("contacting")
if contacting:
try:
UBasic = user_basic.objects.defer(None).filter(number=contacting)[0]
UserContactor.contacting = UBasic
UserContactor.save()
except:
error2 = "接点人不存在"
contact_area = request.POST.get("contact_area", None)
if contact_area:
if UserContactor:
if UserContactor.contact_area != contact_area:
UserContactor.contact_area = contact_area
UserContactor.save()
else:
UserContactor = user_contactor.objects.filter(contacted=UserBasic)[0]
style = request.POST.get("style")
if style:
if style == "1":
UMax.is_central = False
else:
UMax.is_central = True
UMax.save()
try:
UserBasic.save()
except:
error3 = "编号不能重复"
url = reverse("management_change_mem_info") + "?user_number=" + UserBasic.number
if error1:
url += "&error1=" + error1
if error2:
url += "&error2=" + error2
return HttpResponseRedirect(url)
UserBasic.stock_hold = UserBasic.stock_hold_0devide + UserBasic.stock_hold_1devide + UserBasic.stock_hold_2devide
# ValueSetting = request.session.get('ValueSetting')
try:
grade_summit = ValueSetting.grade_summit
mall_VIP_threshold = ValueSetting.mall_VIP_threshold
except:
grade_summit = None
mall_VIP_threshold = None
UserBasic = get_submmit_level(UserBasic=UserBasic)
# count_a = 0
# count_b=0
# count_sum = 0
# count_info = request.session.get("count_info")
# if not count_info:
count_info = getCountInfo(UserBasic.id)
# request.session["count_info"] = count_info
count_a = count_info[5]
count_b = count_info[6]
count_sum = count_info[7]
ctx = {
"UserBasic": UserBasic,
"UserAddress": UserAddress,
"role": UserBasic.role,
"Level": Level,
"grade_summit": grade_summit,
"mall_VIP_threshold": mall_VIP_threshold,
"stock_share_out_min_amount": ValueSetting.stock_share_out_min_amount,
"count_a": count_a,
"count_b": count_b,
"count_sum": count_sum,
"UserAdder": UserAdder,
"error1": error1,
"error2": error2,
"error3": error3,
}
return render_to_response(template_name, RequestContext(request, ctx))