def get_config():
ApiResponse = api_response.ApiResponse()
Key = request.form.get("Key", type=str, default=None)
if Key is None or Key == "":
raise custom_error.CustomFlaskErr(status_code=500, message="key不能为空")
data = mysql.get_object(basic_sql.get_config, (Key))
ApiResponse.message = "成功"
ApiResponse.data = data
return api_response.response_return(ApiResponse)
def register():
ApiResponse = api_response.ApiResponse()
Account = request.form.get("Account", type=str, default=None)
Password = request.form.get("Password", type=str, default=None)
VCode = request.form.get("VCode", type=str, default=None)
if Account == None:
raise custom_error.CustomFlaskErr(status_code=500, message="账号不能为空")
if Password == None:
raise custom_error.CustomFlaskErr(status_code=500, message="密码不能为空")
if VCode == None:
raise custom_error.CustomFlaskErr(status_code=500, message="验证码不能为空")
data_exists = mysql.get_list(user_sql.select_exists_user, (Account))
if len(data_exists):
raise custom_error.CustomFlaskErr(status_code=500, message="账号已经存在")
vocde_exists = mysql.get_object(verification_code_sql.select_verification_lastcode, (Account, 1))
if vocde_exists == None:
raise custom_error.CustomFlaskErr(status_code=500, message="验证码已失效")
if vocde_exists["VCode"] != VCode:
raise custom_error.CustomFlaskErr(status_code=500, message="验证码不正确")
# 设置验证码已读
mysql.operate_object(verification_code_sql.update_verificatioin_vcode, (vocde_exists["Id"]))
guid = str(uuid.uuid1())
sql_list = [user_sql.insert_user, user_sql.insert_userinfo]
args_list = [(guid, Account, Password, Account), (guid)]
data_register = mysql.operate__many(sql_list, args_list)
if data_register > 0:
# region 设置登陆信息，直接跳转到首页
guid = str(uuid.uuid1())
ip = request.remote_addr
count = mysql.operate_object(user_sql.update_user_token, (guid, ip, Account, Password))
user = mysql.get_object(user_sql.select_user_login_info, (guid))
session["user"] = user
data = {"token": guid, "datetime": time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), "user": user}
ApiResponse.message = "注册成功"
ApiResponse.status = 200
ApiResponse.data = data
return api_response.response_return(ApiResponse)
# date = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())
raise custom_error.CustomFlaskErr(status_code=500, message="注册失败")
def select_user_list(name,page=1,size=10):
if page<=0:
page=1
if size<=0:
size=10
sear="%"+ name +"%"
listCount = mysql.get_object(user_sql.select_user_list_count,(name,name,sear,sear))
data= mysql.get_list(user_sql.select_user_list,(name,name,sear,sear,(page-1)*size,size))
return data,listCount
def get_base_config_by_id():
ApiResponse = api_response.ApiResponse()
Id = request.form.get("Id", type=int, default=0)
if Id <= 0:
raise custom_error.CustomFlaskErr(status_code=500, message="Id不能为空")
ApiResponse.data = mysql.get_object(config_sql.get_base_config_by_id, (Id))
ApiResponse.message = "成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
def current_user():
user = session.get("user", None)
#if user != None and any(user):
# return user
token = get_token()
if token == None:
return None
#本地缓存中不存在去数据库拿
user = mysql.get_object(user_sql.select_user_login_info, (token))
session["user"] = user
return user
def update_upgrade_user():
UserId = request_back_helper.current_user_mush_login()["UserId"]
Id = request.form.get("Id", type=str, default=None)
Status = request.form.get("Status", type=int, default=-1)
if Id is None or Id == "":
raise custom_error.CustomFlaskErr(status_code=500, message="参数id不能为空")
if Status == -1:
raise custom_error.CustomFlaskErr(status_code=500, message="参数状态不能为空")
#查询规划师升级数据
upgradeInfo = mysql.get_object(upgrade_user_sql.get_upgrade_info_by_id,
(Id))
if upgradeInfo is None:
raise custom_error.CustomFlaskErr(status_code=500, message="该审核数据不存在")
if upgradeInfo["Status"] != 0:
raise custom_error.CustomFlaskErr(status_code=500,
message="该审核数据已处理，请勿重复操作")
# 审核不通过
if Status == 2:
success = mysql.operate_object(upgrade_user_sql.update_upgrade_status,
(Status, UserId, Id))
if success <= 0:
raise custom_error.CustomFlaskErr(status_code=500, message="审核失败")
# 审核通过
if Status == 1:
idCard = " " #判断IDCard是否不存在
if 'IDCard' in upgradeInfo and upgradeInfo["IDCard"] is not None:
idCard = upgradeInfo["IDCard"]
sql_list = [
upgrade_user_sql.update_upgrade_status,
upgrade_user_sql.update_user_type,
upgrade_user_sql.update_user_info,
upgrade_user_sql.insert_planner_statistics
]
args_list = [
(Status, UserId, Id), (UserId, upgradeInfo["UserId"]),
(upgradeInfo["Name"], upgradeInfo["Sex"], upgradeInfo["Address"],
upgradeInfo["Experience"], upgradeInfo["Email"], idCard,
upgradeInfo["IDCardPic"], upgradeInfo["IDCardBackPic"],
upgradeInfo["ServiceAreaId"], upgradeInfo["ServiceId"], UserId,
upgradeInfo["UserId"]),
(upgradeInfo["UserId"], UserId, UserId, upgradeInfo["UserId"],
upgradeInfo["UserId"])
]
success = mysql.operate__many(sql_list, args_list)
if success <= 0:
raise custom_error.CustomFlaskErr(status_code=500, message="审核失败")
ApiResponse = api_response.ApiResponse()
ApiResponse.message = "成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
def get_upgrade_apply_detail():
request_back_helper.current_user_mush_login()
ApiResponse = api_response.ApiResponse()
Id = request.form.get("Id", type=str, default=None)
if Id is None or Id == "":
raise custom_error.CustomFlaskErr(status_code=500, message="参数id不能为空")
ApiResponse.data = mysql.get_object(
upgrade_user_sql.get_upgrade_apply_detail, (Id))
ApiResponse.message = "成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
def get_order_detail():
ApiResponse = api_response.ApiResponse()
OrderId = request.form.get("OrderId", type=str, default=None)
if OrderId == None or OrderId == "":
raise custom_error.CustomFlaskErr(status_code=500, message="订单id不能为空")
ApiResponse.data = mysql.get_object(order_sql.select_planner_order_detail,
(OrderId))
flowList = []
if ApiResponse.data != None:
order_flow_list = mysql.get_list(order_sql.get_order_status, (OrderId))
if len(order_flow_list) > 0:
for item in order_flow_list:
if item["StartStatus"] == 6:
flowList.append({
"StatusStr": "服务完成",
"IsDo": "1",
"ChangeTime": item["ChangeTime"]
})
flowList.append({
"StatusStr": "付款确认",
"IsDo": "1",
"ChangeTime": item["ChangeTime"]
})
if item["StartStatus"] == 5:
flowList.append({
"StatusStr": "平台审查",
"IsDo": "1",
"ChangeTime": item["ChangeTime"]
})
if item["StartStatus"] == 4:
flowList.append({
"StatusStr": "线下签约",
"IsDo": "1",
"ChangeTime": item["ChangeTime"]
})
if item["StartStatus"] == 3:
flowList.append({
"StatusStr": "拟定合同",
"IsDo": "1",
"ChangeTime": item["ChangeTime"]
})
if item["StartStatus"] == 2:
flowList.append({
"StatusStr": "客服回访",
"IsDo": "1",
"ChangeTime": item["ChangeTime"]
})
ApiResponse.data["OrderFlowing"] = flowList
ApiResponse.message = "成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
def insert_userinfo(userId,account,phone,password,userType,name,realName,sex,age,education,address,email,headImage,IDCard,IDCardJust,IDCardBack,current_user_id):
if userId == None or userId=="" or current_user_id == None or current_user_id=="":
raise custom_error.CustomFlaskErr(status_code=500, message="参数不正确，请刷新后重试")
if account == None or account=="" or name == None or name==""or realName == None or realName=="":
raise custom_error.CustomFlaskErr(status_code=500, message="帐号姓名不能为空")
a_userid = mysql.get_object(user_sql.select_userid_by_account, (account))
if a_userid!=None and a_userid!="" :
raise custom_error.CustomFlaskErr(status_code=500, message="账号已经存在")
data_register = mysql.operate_object(user_sql.insert_user,(userId,account,phone,password,userType,current_user_id,current_user_id
,userId,name,realName,sex,age,education,address,email,headImage,IDCard,IDCardJust,IDCardBack,current_user_id,current_user_id))
if userType==2 or userType ==3:
mysql.operate_object(upgrade_user_sql.insert_planner_statistics,(userId,current_user_id,current_user_id,userId,userId))
return data_register > 0
def insert_undertake():
ApiResponse = api_response.ApiResponse()
DemandId = request.form.get("DemandId", type=str, default=None)
if DemandId == None or DemandId == "":
raise custom_error.CustomFlaskErr(status_code=500, message="需求id不能为空")
ContractId = request.form.get("ContractId", type=int, default=0)
if ContractId == None or ContractId == 0:
raise custom_error.CustomFlaskErr(status_code=500, message="合同id不能为空")
userId = request_helper.current_user_mush_login()["Id"]
userInfo = mysql.get_object(user_info_sql.select_userinfo_by_id, (userId))
if userInfo == None or userInfo["UserType"] == 1:
raise custom_error.CustomFlaskErr(status_code=500, message="你还不是规划师")
service_exists = mysql.get_object(demand_undertake.select_exists_demand,
(DemandId))
if service_exists == None or service_exists["IsUndertake"] == 1:
raise custom_error.CustomFlaskErr(status_code=500,
message="该需求不存在或者已被承接")
data_exists = mysql.get_object(
demand_undertake.select_exists_demand_service, (DemandId, userId))
if data_exists["total"] > 0:
raise custom_error.CustomFlaskErr(status_code=500,
message="你已经存在承接该需求的记录")
insertResult = mysql.operate_object(
demand_undertake.insert_demand_undertake,
(DemandId, userId, userId, enum.IsUser.no, ContractId))
if insertResult > 0:
ApiResponse.message = "申请成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="申请失败")
def get_user_info():
ApiResponse = api_response.ApiResponse()
userid = request.form.get("userid", type=str, default=None)
if userid == None or userid == "":
userid = request_helper.current_user_mush_login()["Id"]
if userid == None or userid == "":
raise custom_error.CustomFlaskErr(status_code=500,
message="参数userid不能为空")
userinfo = mysql.get_object(user_info_sql.select_userinfo_by_id, (userid))
if userinfo != None and any(userinfo):
ApiResponse.data = userinfo
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="用户不存在")
def join_team():
ApiResponse = api_response.ApiResponse()
userId = request_helper.current_user_mush_login()["Id"]
user_info = mysql.get_object(user_sql.select_user_by_id, (userId))
if user_info is None or user_info["UserType"] == 1:
raise custom_error.CustomFlaskErr(status_code=500, message="你还不是规划师")
TeamId = request.form.get("TeamId", type=str, default=None)
if TeamId is None or TeamId == '':
raise custom_error.CustomFlaskErr(status_code=500, message="团队id不能为空")
exists_team = mysql.get_object(team_sql.exists_team_peoper, (userId))
if exists_team is not None and exists_team["Status"] == 1:
raise custom_error.CustomFlaskErr(status_code=500,
message="您已经申请过加入该团队，请耐心等待审核")
if exists_team is not None and exists_team["Status"] == 2:
raise custom_error.CustomFlaskErr(status_code=500, message="您已经是团队成员")
team_detail = mysql.get_object(team_sql.select_team_adminid, (TeamId))
if team_detail is None:
raise custom_error.CustomFlaskErr(status_code=500,
message="您所申请的团队不存在")
guid = str(uuid.uuid1())
sql_list = [team_sql.insert_team_notice, team_sql.insert_team_notice]
args_list = [(userId, TeamId, "您正在申请加入 " + team_detail["Name"] + " 团队", 1,
2, userId, guid),
(team_detail["AdminUserId"], TeamId,
"用户 " + request_helper.current_user_mush_login()["Name"] +
" 正在申请加入团队", 1, 1, userId, guid)]
data_register = mysql.operate__many(sql_list, args_list)
ApiResponse.message = "成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
def select_demand_list():
ApiResponse = api_response.ApiResponse()
size = request.form.get("size", type=int, default=10)
name = request.form.get("name", type=str, default="")
page = request.form.get("page", type=int, default=1)
type = request.form.get("type", type=int, default=1)
if page <= 0:
page = 1
if size <= 0:
size = 10
data = mysql.get_list(demand_service_sql.select_demand_list, (type,(page - 1) * size, size))
listCount = mysql.get_object(demand_service_sql.select_demand_count, (type))
if listCount is not None:
ApiResponse.data = data
ApiResponse.listCount = listCount["count"]
ApiResponse.message = "成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
def get_upgrade_apply_list():
ApiResponse = api_response.ApiResponse()
size = request.form.get("size", type=int, default=10)
name = request.form.get("name", type=str, default="")
page = request.form.get("page", type=int, default=1)
if page <= 0:
page = 1
if size <= 0:
size = 10
sear = "%" + name + "%"
data = mysql.get_list(upgrade_user_sql.get_upgrade_apply_list,
(name, name, sear, (page - 1) * size, size))
listCount = mysql.get_object(upgrade_user_sql.get_upgrade_apply_count,
(name, name, sear))
ApiResponse.message = "成功"
ApiResponse.status = 200
if listCount is not None:
ApiResponse.data = data
ApiResponse.listCount = listCount["count"]
return api_response.response_return(ApiResponse)
def update_team_name():
ApiResponse = api_response.ApiResponse()
userId = request_helper.current_user_mush_login()["Id"]
TeamId = request.form.get("TeamId", type=str, default=None)
if TeamId is None or TeamId == '':
raise custom_error.CustomFlaskErr(status_code=500, message="团队id不能为空")
TeamName = request.form.get("TeamName", type=str, default=None)
if TeamName is None or TeamName == '':
raise custom_error.CustomFlaskErr(status_code=500, message="团队名称不能为空")
team_info = mysql.get_object(team_sql.get_team_info, (TeamId))
if team_info is None:
raise custom_error.CustomFlaskErr(status_code=500, message="没有该团队")
if team_info["AdminUserId"] != userId:
raise custom_error.CustomFlaskErr(status_code=500, message="您不是队长")
update_count = mysql.operate_object(team_sql.update_team_name,
(TeamName, TeamId, userId))
if update_count <= 0:
raise custom_error.CustomFlaskErr(status_code=500, message="修改失败")
ApiResponse.message = "成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
def select_carouselimage_info(imageId):
return mysql.get_object(baseinfo_sql.select_carouselimage_info, (imageId))
def select_service_type_info(typeId):
return mysql.get_object(service_type_sql.select_service_type_info,
(typeId))
def set_session_login():
token = get_token()
session["user"] = mysql.get_object(user_sql.select_user_login_info,
(token))
def select_service_area_info(areaId):
return mysql.get_object(service_area_sql.select_service_area_info,
(areaId))
def select_user_team(userid):
if userid == None or userid == "":
raise custom_error.CustomFlaskErr(status_code=500,
message="输入不正确，请刷新后重试")
return mysql.get_object(team_sql.select_user_team, (userid))
def select_platforminfo():
return mysql.get_object(baseinfo_sql.select_platforminfo, ())
def get_whether_follw(userid, plannerId):
return mysql.get_object(planner_sql.get_whether_follw, (plannerId, userid))
def select_planner_info(userid):
return mysql.get_object(planner_sql.select_planner_info, (userid))
def select_user_role_list(user_id, current_user_id):
if user_id == None or user_id == "" or current_user_id == None or current_user_id == "":
raise custom_error.CustomFlaskErr(status_code=500,
message="参数不正确，请刷新后重试")
return mysql.get_object(sys_role_sql.select_user_role_list, (user_id))
def select_user_info(userId):
return mysql.get_object(user_sql.select_user_info, (userId))
def select_dynamic_info(dynamicId):
if dynamicId == None or dynamicId=="":
raise custom_error.CustomFlaskErr(status_code=500, message="输入不正确，请刷新后重试")
mysql.operate_object(dynamic_sql.update_dynamic_readcount, (dynamicId))
return mysql.get_object(dynamic_sql.select_dynamic_info,(dynamicId))
def select_resour_info(id):
return mysql.get_object(planner_sql.select_resour_info, (id))
def select_society_info(id):
return mysql.get_object(planner_sql.select_society_info, (id))
def select_education_info(id):
return mysql.get_object(planner_sql.select_education_info, (id))
def select_sys_role_info(role_id):
if role_id == None or role_id == "":
raise custom_error.CustomFlaskErr(status_code=500,
message="参数role_id不能为空")
return mysql.get_object(sys_role_sql.select_sys_role_info, (role_id))
