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 back_updateplanner():
ApiResponse = api_response.ApiResponse()
userid = request.form.get("UserId", type=str, default=None)
account = request.form.get("Account", type=str, default=None)
phone = request.form.get("Phone", type=str, default=None)
userType = request.form.get("UserType", type=int, default=0)
name = request.form.get("Name", type=str, default=None)
realName = request.form.get("RealName", type=str, default=None)
sex = request.form.get("Sex", type=int, default=0)
age = request.form.get("Age", type=int, default=0)
education = request.form.get("Education", type=str, default=None)
address = request.form.get("Address", type=str, default=None)
email = request.form.get("Email", type=str, default=None)
headImage = request.form.get("HeadImage", type=str, default=None)
IDCard = request.form.get("IDCard", type=str, default=None)
IDCardJust = request.form.get("IDCardJust", type=str, default=None)
IDCardBack = request.form.get("IDCardBack", type=str, default=None)
ServiceAreaId = request.form.get("ServiceAreaId", type=str, default=None)
ServiceTypeId = request.form.get("ServiceTypeId", type=str, default=None)
Sort = request.form.get("Sort", type=int, default=0)
user = request_back_helper.current_user_mush_login()
data_register = back_planner_logic.update_planner(
account, phone, userType, name, realName, sex, age, education, address,
email, headImage, IDCard, IDCardJust, IDCardBack, ServiceAreaId,
ServiceTypeId, userid, Sort, user["UserId"])
if data_register:
ApiResponse.message = "修改成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="修改失败")
def update_demand_status():
userId = request_back_helper.current_user_mush_login()["UserId"]
ApiResponse = api_response.ApiResponse()
id = request.form.get("id", type=str, default=None)
IsUndertake = request.form.get("IsUndertake", type=int, default=-1)
IsTop = request.form.get("IsTop", type=int, default=-1)
if id is None:
raise custom_error.CustomFlaskErr(status_code=500, message="参数不正确")
if IsUndertake == -1:
raise custom_error.CustomFlaskErr(status_code=500, message="参数不正确")
if IsTop==-1 :
raise custom_error.CustomFlaskErr(status_code=500, message="参数不正确")
if IsUndertake==2:
sql_list = [demand_service_sql.update_demand_status,
demand_service_sql.update_demand_undertake_status]
args_list = [(IsTop, IsUndertake, userId,id),
( userId,id),]
mysql.operate__many(sql_list,args_list)
else :
mysql.operate_object(demand_service_sql.update_demand_status,(IsTop, IsUndertake, userId,id))
ApiResponse = api_response.ApiResponse()
ApiResponse.message = "成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
def back_update_education():
ApiResponse = api_response.ApiResponse()
Id = request.form.get("Id", type=str, default=None)
if Id == None or Id == "":
raise custom_error.CustomFlaskErr(status_code=500,
message="请选择需要修改的学历")
TimeStart = request.form.get("TimeStart", type=str, default="")
TimeEnd = request.form.get("TimeEnd", type=str, default="")
#if TimeStart == None or TimeStart=="" or TimeEnd==None or TimeEnd=="":
# raise custom_error.CustomFlaskErr(status_code=500, message="起止时间不能为空")
University = request.form.get("University", type=str, default=None)
if University == None or University == "":
raise custom_error.CustomFlaskErr(status_code=500, message="毕业学校不能为空")
Degree = request.form.get("Degree", type=str, default=None)
if Degree == None or Degree == "":
raise custom_error.CustomFlaskErr(status_code=500, message="学位不能为空")
Sort = request.form.get("Sort", type=int, default=0)
user = request_back_helper.current_user_mush_login()
data = back_planner_logic.update_education(TimeStart, TimeEnd, University,
Degree, Sort, Id,
user["UserId"])
ApiResponse.message = "成功"
ApiResponse.status = 200
ApiResponse.data = data
return api_response.response_return(ApiResponse)
def back_insert_userinfo():
ApiResponse = api_response.ApiResponse()
account = request.form.get("Account", type=str, default=None)
phone = request.form.get("Phone", type=str, default=None)
password = request.form.get("Password", type=str, default=None)
userType = request.form.get("UserType", type=int, default=0)
name = request.form.get("Name", type=str, default=None)
realName = request.form.get("RealName", type=str, default=None)
sex = request.form.get("Sex", type=int, default=0)
age = request.form.get("Age", type=int, default=0)
education = request.form.get("Education", type=str, default=None)
address = request.form.get("Address", type=str, default=None)
email = request.form.get("Email", type=str, default=None)
headImage = request.form.get("HeadImage", type=str, default=None)
if headImage is None or headImage == '':
headImage = "files/person.jpg"
IDCard = request.form.get("IDCard", type=str, default=None)
IDCardJust = request.form.get("IDCardJust", type=str, default=None)
IDCardBack = request.form.get("IDCardBack", type=str, default=None)
user = request_back_helper.current_user_mush_login()
guid = str(uuid.uuid1())
password = hashlib.md5(password.encode(encoding='gb2312')).hexdigest()
data_register = user_logic.insert_userinfo(guid, account, phone, password,
userType, name, realName, sex,
age, education, address, email,
headImage, IDCard, IDCardJust,
IDCardBack, user["UserId"])
if data_register:
ApiResponse.message = "修改成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="修改失败")
def get_current_login_user():
ApiResponse = api_response.ApiResponse()
user = request_back_helper.current_user_mush_login()
ApiResponse.message = "获取成功"
ApiResponse.status = 200
ApiResponse.data = user
return api_response.response_return(ApiResponse)
def delete_sys_user():
ApiResponse = api_response.ApiResponse()
user_id= request.form.get("user_id", type=str, default=None)
user = request_back_helper.current_user_mush_login()
data_register = sys_user_logic.delete_sys_user(user_id, user["UserId"])
ApiResponse.message = "删除成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
def select_permission_list():
ApiResponse = api_response.ApiResponse()
user = request_back_helper.current_user_mush_login()
data = sys_role_logic.select_permission_list(user["UserId"])
ApiResponse.message = "成功"
ApiResponse.status = 200
ApiResponse.data = data
return api_response.response_return(ApiResponse)
def select_sys_role_info():
ApiResponse = api_response.ApiResponse()
role_id = request.form.get("role_id", type=int, default=None)
user = request_back_helper.current_user_mush_login()
roleinfo = sys_role_logic.select_sys_role_info(role_id)
if roleinfo != None and any(roleinfo):
ApiResponse.data = roleinfo
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="角色不存在")
def select_user_role_list():
ApiResponse = api_response.ApiResponse()
user_id = request.form.get("user_id", type=str, default=None)
user = request_back_helper.current_user_mush_login()
data = sys_role_logic.select_user_role_list(user_id, user["UserId"])
ApiResponse.message = "成功"
ApiResponse.status = 200
ApiResponse.data = data
return api_response.response_return(ApiResponse)
def select_sys_user_info():
ApiResponse = api_response.ApiResponse()
user_id = request.form.get("user_id", type=str, default="")
user = request_back_helper.current_user_mush_login()
userinfo = sys_user_logic.select_sys_user_info(user_id)
if userinfo !=None and any(userinfo):
ApiResponse.data=userinfo
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="用户不存在")
def select_sys_role_list():
ApiResponse = api_response.ApiResponse()
size = request.form.get("size", type=int, default=10)
name = request.form.get("name", type=str, default="")
user = request_back_helper.current_user_mush_login()
data = sys_role_logic.select_sys_role_list(name)
ApiResponse.message = "成功"
ApiResponse.status = 200
ApiResponse.data = data
return api_response.response_return(ApiResponse)
def insert_role_permission():
ApiResponse = api_response.ApiResponse()
role_id = request.form.get("role_id", type=int, default=None)
permissionId = request.form.get("permissionId", type=str, default="")
user = request_back_helper.current_user_mush_login()
data_register = sys_role_logic.insert_role_permission(
role_id, permissionId, user["UserId"])
ApiResponse.message = "受权成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
def insert_sys_role():
ApiResponse = api_response.ApiResponse()
name = request.form.get("name", type=str, default=None)
remark = request.form.get("remark", type=str, default=None)
user = request_back_helper.current_user_mush_login()
data_register = sys_role_logic.insert_sys_role(name, remark,
user["UserId"])
ApiResponse.message = "新增成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
def delete_service_area():
ApiResponse = api_response.ApiResponse()
areaId= request.form.get("areaId", type=int, default=None)
user = request_back_helper.current_user_mush_login()
data_register = service_area_logic.delete_service_area(areaId, user["UserId"])
if data_register:
ApiResponse.message = "删除成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="删除失败")
def delete_user():
ApiResponse = api_response.ApiResponse()
userid = request.form.get("UserId", type=str, default=None)
user = request_back_helper.current_user_mush_login()
data_register = user_logic.delete_user(userid, user["UserId"])
if data_register:
ApiResponse.message = "修改成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="修改失败")
def update_Contract():
ApiResponse = api_response.ApiResponse()
ContractContent= request.form.get("ContractContent", type=str, default=None)
user = request_back_helper.current_user_mush_login()
data_register = baseinfo_logic.update_contract(ContractContent,user["UserId"])
if data_register:
ApiResponse.message = "修改成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="修改失败")
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 back_delete_education():
ApiResponse = api_response.ApiResponse()
Id = request.form.get("id", type=str, default=None)
if Id == None or Id == "":
raise custom_error.CustomFlaskErr(status_code=500,
message="请选择需要删除的学历")
user = request_back_helper.current_user_mush_login()
data = back_planner_logic.delete_education(Id, user["UserId"])
ApiResponse.message = "成功"
ApiResponse.status = 200
ApiResponse.data = data
return api_response.response_return(ApiResponse)
def select_sys_user_list():
ApiResponse = api_response.ApiResponse()
size = request.form.get("size", type=int, default=10)
uname = request.form.get("uname", type=str, default="")
nname = request.form.get("nname", type=str, default="")
phone = request.form.get("phone", type=str, default="")
page = request.form.get("page", type=int, default=1)
user = request_back_helper.current_user_mush_login()
data = sys_user_logic.select_sys_user_list(uname,nname,phone, page, size)
ApiResponse.message = "成功"
ApiResponse.status = 200
ApiResponse.data = data
return api_response.response_return(ApiResponse)
def update_platforminfo():
ApiResponse = api_response.ApiResponse()
CustomerServiceTelephone= request.form.get("CustomerServiceTelephone", type=str, default=None)
FlowImage= request.form.get("FlowImage", type=str, default=None)
BigVImage= request.form.get("BigVImage", type=str, default=None)
user = request_back_helper.current_user_mush_login()
data_register = baseinfo_logic.update_platforminfo(CustomerServiceTelephone,FlowImage,BigVImage,user["UserId"])
if data_register:
ApiResponse.message = "修改成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="修改失败")
def insert_service_area():
ApiResponse = api_response.ApiResponse()
name= request.form.get("Name", type=str, default=None)
description = request.form.get("Description", type=str, default=0)
isTop = request.form.get("IsTop", type=int, default=0)
sort = request.form.get("Sort", type=int, default=0)
user = request_back_helper.current_user_mush_login()
data_register = service_area_logic.insert_service_area(name,description,isTop,sort,user["UserId"])
if data_register:
ApiResponse.message = "新增成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="新增失败")
def update_sys_role():
ApiResponse = api_response.ApiResponse()
name = request.form.get("name", type=str, default=None)
remark = request.form.get("remark", type=str, default=None)
role_id = request.form.get("role_id", type=int, default=None)
permissionids = request.form.get("permissionids", type=str, default="")
user = request_back_helper.current_user_mush_login()
data_register = sys_role_logic.update_sys_role(name, remark, role_id,
user["UserId"])
data_register = sys_role_logic.insert_role_permission(
role_id, permissionids, user["UserId"])
ApiResponse.message = "修改成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
def back_delete_resour():
ApiResponse = api_response.ApiResponse()
Id = request.form.get("id", type=str, default=None)
if Id == None or Id == "":
raise custom_error.CustomFlaskErr(status_code=500,
message="请选择需要删除的资源背景")
user = request_back_helper.current_user_mush_login()
data = mysql.operate_object(planner_sql.delete_resour,
(user["UserId"], Id))
#data = back_planner_logic.delete_society,(Id,user["UserId"])
ApiResponse.message = "成功"
ApiResponse.status = 200
ApiResponse.data = data
return api_response.response_return(ApiResponse)
def insert_ms_dynamic():
ApiResponse = api_response.ApiResponse()
content= request.form.get("content", type=str, default=None)
imageUrl = request.form.get("imageUrl", type=str, default=None)
isTop = request.form.get("IsTop", type=int, default=0)
sort = request.form.get("Sort", type=int, default=0)
readCount = request.form.get("readCount", type=int, default=0)
user = request_back_helper.current_user_mush_login()
data_register = dynamic_logic.insert_dynamic(content,imageUrl,isTop,sort,readCount,user["UserId"])
if data_register:
ApiResponse.message = "新增成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="新增失败")
def insert_carouselimage():
ApiResponse = api_response.ApiResponse()
description= request.form.get("Description", type=str, default=None)
imageUrl = request.form.get("ImageUrl", type=str, default=None)
clickUrl = request.form.get("ClickUrl", type=str, default=None)
isTop = request.form.get("IsTop", type=int, default=0)
sort = request.form.get("Sort", type=int, default=0)
user = request_back_helper.current_user_mush_login()
data_register = baseinfo_logic.insert_carouselimage(description,imageUrl,clickUrl,isTop,sort,user["UserId"])
if data_register:
ApiResponse.message = "新增成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="新增失败")
def update_sys_user():
ApiResponse = api_response.ApiResponse()
user_id= request.form.get("user_id", type=str, default=None)
uname= request.form.get("uname", type=str, default=None)
nname = request.form.get("nname", type=str, default=None)
phone = request.form.get("phone", type=str, default=None)
email = request.form.get("email", type=str, default=None)
role_id= request.form.get("role_id", type=int, default=None)
descript = request.form.get("descript", type=str, default=None)
user = request_back_helper.current_user_mush_login()
data_register = sys_user_logic.update_sys_user(uname,nname,phone,email,descript,user_id,user["UserId"])
sys_user_logic.update_sys_userrole(user_id,role_id,user["UserId"])
ApiResponse.message = "修改成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
def update_BigV():
ApiResponse = api_response.ApiResponse()
UserId = request.form.get("UserId", type=str, default=None)
BigV = request.form.get("BigV", type=int, default=0)
if UserId == None or UserId == "":
raise custom_error.CustomFlaskErr(status_code=500,
message="请选择需要修改的规划师")
user = request_back_helper.current_user_mush_login()
data = mysql.operate_object(planner_sql.update_BigV,
(BigV, user["UserId"], UserId))
#data = back_planner_logic.update_BigV,(BigV,UserId,user["UserId"])
ApiResponse.message = "成功"
ApiResponse.status = 200
ApiResponse.data = data
return api_response.response_return(ApiResponse)
def update_sys_file_info():
ApiResponse = api_response.ApiResponse()
fileId = request.form.get("fileId", type=int, default=None)
name = request.form.get("Name", type=str, default=None)
fileUrl = request.form.get("fileUrl", type=str, default=None)
isTop = request.form.get("IsTop", type=int, default=0)
sort = request.form.get("Sort", type=int, default=0)
user = request_back_helper.current_user_mush_login()
data_register = sys_file_logic.update_sys_file_info(
name, fileUrl, isTop, sort, user["UserId"], fileId)
if data_register:
ApiResponse.message = "修改成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
raise custom_error.CustomFlaskErr(status_code=500, message="修改失败")
def insert_sys_user():
ApiResponse = api_response.ApiResponse()
uname= request.form.get("uname", type=str, default=None)
user = sys_user_logic.select_sys_user_info_by_username(uname)
if user!=None and any(user):
raise custom_error.CustomFlaskErr(status_code=500, message="用户已存在")
nname = request.form.get("nname", type=str, default=None)
phone = request.form.get("phone", type=str, default=None)
email = request.form.get("email", type=str, default=None)
descript = request.form.get("descript", type=str, default=None)
guid = str(uuid.uuid1())
user = request_back_helper.current_user_mush_login()
data_register = sys_user_logic.insert_sys_user(guid,uname,nname,phone,email,descript,user["UserId"])
ApiResponse.message = "新增成功"
ApiResponse.status = 200
return api_response.response_return(ApiResponse)
