def select_lable_list(page, size):
if page <= 0:
page = 1
if size <= 0:
size = 10
return mysql.get_list(planner_sql.select_lable_list,
((page - 1) * size, size))
def select_user_servicetype_list(userid, page, size):
if page <= 0:
page = 1
if size <= 0:
size = 10
return mysql.get_list(planner_sql.select_user_servicetype_list,
(userid, (page - 1) * size, size))
def select_planner_education(userid, page=1, size=10):
if page <= 0:
page = 1
if size <= 0:
size = 10
return mysql.get_list(planner_sql.select_planner_education,
(userid, (page - 1) * size, size))
def select_planner_lables(userid, page, size):
if page <= 0:
page = 1
if size <= 0:
size = 10
return mysql.get_list(planner_sql.select_planner_lables,
(userid, (page - 1) * size, size))
def service_list():
ApiResponse = api_response.ApiResponse()
data = mysql.get_list(service_sql.select_service_list, ())
ApiResponse.message = "成功"
ApiResponse.status = 200
ApiResponse.data = data
return api_response.response_return(ApiResponse)
def select_planner_qualifications(userid, page=1, size=2):
if page <= 0:
page = 1
if size <= 0:
size = 2
return mysql.get_list(planner_sql.select_planner_qualifications,
(userid, userid, userid, (page - 1) * size, size))
def get_team_member_list(teamId, page=1, size=10):
if page <= 0:
page = 1
if size <= 0:
size = 10
return mysql.get_list(team_sql.select_team_member_list,
(teamId, (page - 1) * size, size))
def select_planner_team_member_list(userid, page=1, size=10):
if page <= 0:
page = 1
if size <= 0:
size = 10
return mysql.get_list(team_sql.select_planner_team_member_list,
(userid, (page - 1) * size, size))
def select_evaluate_info(orderId, page=1, size=10):
if page <= 0:
page = 1
if size <= 0:
size = 10
return mysql.get_list(order_sql.select_evaluate_info,
(orderId, (page - 1) * size, size))
def select_planner_complete_order_list(userid, page=1, size=10):
if page <= 0:
page = 1
if size <= 0:
size = 10
return mysql.get_list(order_sql.select_planner_complete_order_list,
(userid, (page - 1) * size, size))
def select_order_evaluate(orderId, page, size):
if page <= 0:
page = 1
if size <= 0:
size = 10
return mysql.get_list(order_sql.select_order_evaluate,
(orderId, (page - 1) * size, size))
def upgrade_user():
ApiResponse = api_response.ApiResponse()
Sex = request.form.get("Sex", type=int, default=0)
if Sex == 0:
raise custom_error.CustomFlaskErr(status_code=500, message="性别不能为空")
Name = request.form.get("Name", type=str, default=None)
if Name == None:
raise custom_error.CustomFlaskErr(status_code=500, message="真实姓名不能为空")
Address = request.form.get("Address", type=str, default=None)
if Address == None:
raise custom_error.CustomFlaskErr(status_code=500, message="地址不能为空")
ServiceId = request.form.get("ServiceId", type=str, default=None)
if ServiceId == None or ServiceId == "":
raise custom_error.CustomFlaskErr(status_code=500, message="服务不能为空")
ServiceAreaId = request.form.get("ServiceAreaId", type=str, default=None)
if ServiceAreaId == None or ServiceAreaId == "":
raise custom_error.CustomFlaskErr(status_code=500, message="服务区域不能为空")
Email = request.form.get("Email", type=str, default=None)
if Email == None:
raise custom_error.CustomFlaskErr(status_code=500, message="邮箱不能为空")
Experience = request.form.get("Experience", type=str, default=None)
if Experience == None:
raise custom_error.CustomFlaskErr(status_code=500, message="资历不能为空")
IDCard = request.form.get("IDCard", type=str, default=None)
if IDCard == None:
raise custom_error.CustomFlaskErr(status_code=500, message="身份证不能为空")
IDCardPic = request.form.get("IDCardPic", type=str, default=None)
if IDCardPic == None:
raise custom_error.CustomFlaskErr(status_code=500, message="身份证正面不能为空")
IDCardBackPic = request.form.get("IDCardBackPic", type=str, default=None)
if IDCardBackPic == None:
raise custom_error.CustomFlaskErr(status_code=500, message="身份证反面不能为空")
userId = request_helper.current_user_mush_login()["Id"]
nicheng = request_helper.current_user_mush_login()["Name"]
if nicheng is None:
nicheng = Name
data_exists = mysql.get_list(user_upgrade.select_exists_upgrade, (userId))
if len(data_exists):
raise custom_error.CustomFlaskErr(status_code=500,
message="你已经存在申请过注册规划师")
argData = [(userId, Sex, Name, Address, ServiceId, ServiceAreaId, Email,
Experience, IDCardPic, userId, IDCardBackPic, IDCard),
(nicheng, userId)]
argSql = (user_upgrade.insert_upgrade_user,
user_upgrade.update_user_info_name)
data_register = mysql.operate__many(argSql, argData)
if data_register > 0:
ApiResponse.message = "申请成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="申请失败")
def select_lable_list(name, page=1, size=10):
if page <= 0:
page = 1
if size <= 0:
size = 10
sear = "%" + name + "%"
return mysql.get_list(lable_sql.select_lable_list,
(name, name, sear, (page - 1) * size, size))
def select_user_dynamic_list(userid,page,size):
if userid == None or userid=="":
raise custom_error.CustomFlaskErr(status_code=500, message="输入不正确，请刷新后重试")
if page<=0:
page=1
if size<=0:
size=10
return mysql.get_list(dynamic_sql.select_user_dynamic_list,(userid,(page-1)*size,size))
def get_team_list(userid, name, page, size):
if page <= 0:
page = 1
if size <= 0:
size = 10
sear = "%" + name + "%"
return mysql.get_list(team_sql.select_team_list,
(userid, name, name, sear, (page - 1) * size, size))
def select_service_area_list(name, page=1, size=10):
if page <= 0:
page = 1
if size <= 0:
size = 10
sear = "%" + name + "%"
return mysql.get_list(service_area_sql.select_service_area_list,
(name, name, sear, (page - 1) * size, size))
def service():
ApiResponse = api_response.ApiResponse()
count = request.form.get("count", type=int, default=5)
data = mysql.get_list(service_sql.select_top_service, (count))
ApiResponse.message = "成功"
ApiResponse.status = 200
ApiResponse.data = data
return api_response.response_return(ApiResponse)
def cooperation():
ApiResponse = api_response.ApiResponse()
size = request.form.get("size", type=int, default=10)
page = request.form.get("page", type=int, default=1)
data = mysql.get_list(platform_sql.select_platform_cooperation, ((page-1)*size,size))
ApiResponse.message = "成功"
ApiResponse.status = 200
ApiResponse.data = data
return api_response.response_return(ApiResponse)
def select_dynamic_list(content, page=1, size=10):
if page <= 0:
page = 1
if size <= 0:
size = 10
sear = "%" + content + "%"
return mysql.get_list(dynamic_sql.select_dynamic_list,
(content, content, sear, sear,
(page - 1) * size, size))
def get_service_notice_list():
userId = request_helper.current_user_mush_login()["Id"]
UserType = request_helper.current_user_mush_login()["UserType"]
ApiResponse = api_response.ApiResponse()
size = request.form.get("size", type=int, default=10)
page = request.form.get("page", type=int, default=1)
if page <= 0:
page = 1
if size <= 0:
size = 10
if UserType == 1:
data = mysql.get_list(service_notice_sql.select_service_notice_list2, (userId, (page - 1) * size, size))
else:
data = mysql.get_list(service_notice_sql.select_service_notice_list1, (userId, (page - 1) * size, size))
if len(data) > 0:
for item in data:
if item["OrderStatus"] == 1:
item["OrderStatusStr"] = "通知后台"
continue
if item["OrderStatus"] == 2:
item["OrderStatusStr"] = "客服回访"
continue
if item["OrderStatus"] == 3:
item["OrderStatusStr"] = "拟定合同"
continue
if item["OrderStatus"] == 4:
item["OrderStatusStr"] = "线下签约"
continue
if item["OrderStatus"] == 5:
item["OrderStatusStr"] = "平台审查"
continue
if item["OrderStatus"] == 6:
item["OrderStatusStr"] = "付款确认"
continue
if item["OrderStatus"] == 7:
item["OrderStatusStr"] = "服务完成"
continue
ApiResponse.message = "成功"
ApiResponse.status = 200
ApiResponse.data = data
return api_response.response_return(ApiResponse)
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_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 get_system_notice_list():
userId = request_helper.current_user_mush_login()["Id"]
ApiResponse = api_response.ApiResponse()
size = request.form.get("size", type=int, default=10)
page = request.form.get("page", type=int, default=1)
if page <= 0:
page = 1
if size <= 0:
size = 10
data = mysql.get_list(system_notice_sql.select_system_notice_list, (userId, (page - 1) * size, size))
ApiResponse.message = "成功"
ApiResponse.status = 200
ApiResponse.data = data
return api_response.response_return(ApiResponse)
def update_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不能为空")
Value = request.form.get("Value", type=str, default=None)
Remark = request.form.get("Remark", type=str, default=None)
imageUrl = request.form.get("imageUrl", type=str, default=None)
ApiResponse.data = mysql.get_list(config_sql.update_config,
(Value, Remark, imageUrl, Id))
ApiResponse.message = "成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
def searchds():
ApiResponse = api_response.ApiResponse()
size = request.form.get("size", type=int, default=10)
page = request.form.get("page", type=int, default=1)
if page <= 0:
page = 1
if size <= 0:
size = 10
data = mysql.get_list(demand_service_sql.select_search_demand_service,
((page - 1) * size, size))
ApiResponse.message = "成功"
ApiResponse.status = 200
ApiResponse.data = data
return api_response.response_return(ApiResponse)
def select_user_file():
ApiResponse = api_response.ApiResponse()
size = request.form.get("size", type=int, default=10)
page = request.form.get("page", type=int, default=1)
user = request_helper.current_user_mush_login()
if page <= 0:
page = 1
if size <= 0:
size = 10
data = mysql.get_list(user_info_sql.select_sys_file,
((page - 1) * size, size))
ApiResponse.message = "成功"
ApiResponse.status = 200
ApiResponse.data = data
return api_response.response_return(ApiResponse)
def collection_list():
ApiResponse = api_response.ApiResponse()
size = request.form.get("size", type=int, default=10)
page = request.form.get("page", type=int, default=1)
user = request_helper.current_user_mush_login()
if page <= 0:
page = 1
if size <= 0:
size = 10
data = mysql.get_list(demand_service_sql.select_collection_demand_service,
(user["Id"], (page - 1) * size, size))
ApiResponse.message = "成功"
ApiResponse.status = 200
ApiResponse.data = data
return api_response.response_return(ApiResponse)
def plannerinfo():
ApiResponse = api_response.ApiResponse()
size = request.form.get("size", type=int, default=10)
page = request.form.get("page", type=int, default=1)
plannerId = request.form.get("plannerId", type=str, default=None)
if plannerId == None:
raise custom_error.CustomFlaskErr(status_code=500, message="请选择规划师")
if page <= 0:
page = 1
if size <= 0:
size = 10
planner = planner_logic.select_planner_info(plannerId)
teamlist = team_logic.select_planner_team_member_list(
plannerId, page, size)
qualifications = planner_logic.select_planner_qualifications(
plannerId, 0, 2)
complete_order_list = order_logic.select_planner_complete_order_list(
plannerId, 0, 1)
lables = planner_logic.select_planner_lables(plannerId, 0, 4)
ServiceTypeList = planner_logic.select_user_servicetype_list(
plannerId, 0, 9)
ServiceAreaList = planner_logic.select_user_servicearea_list(
plannerId, 0, 9)
evaluate = planner_logic.select_planner_evaluate(plannerId, 0, 1)
albumList = mysql.get_list(user_info_sql.select_user_album,
(plannerId, 0, 9))
fllow_count = 0
user = request_helper.current_user()
if user != None and any(user) and user["Id"] != plannerId:
obj = planner_logic.get_whether_follw(user["Id"], plannerId)
fllow_count = obj["fllow_count"]
data = {
'planner': planner,
"teamlist": teamlist,
"qualifications": qualifications,
"order": complete_order_list,
"lables": lables,
"evaluate": evaluate,
"fllow_count": fllow_count,
"albumList": albumList,
"ServiceTypeList": ServiceTypeList,
"ServiceAreaList": ServiceAreaList
}
ApiResponse.message = "成功"
ApiResponse.status = 200
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_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)