def invitation_customer_delete():
'''
{
"main_id":""
}
:return:
'''
status = 200
message = '邀请人删除成功！'
form = request.json
haveInvitationCustomer = read("main_id", form['main_id'], InvitationCustomer)
if haveInvitationCustomer:
info = haveInvitationCustomer[0].serialize
try:
delete(haveInvitationCustomer[0])
except:
status = 400
message = '外键约束！'
info = '邀请人删除失败！'
else:
status = 400
message = '邀请人不存在！'
info = '邀请人删除失败！'
info = {
'status': status,
'message': message,
'info': info
}
return jsonify(info)
def myplan_day_delete_all():
"""
:createlabel:删除多条日计划的日计划
:param:POST传：
form:value (状态值)
main_id_all []
:return:我的当前日计划表
"""
if request.method == 'POST':
form = request.json
if form['main_id_all'] == []:
return jsonify({'message': "日计划删除成功"}), 200, {
"ContentType": "application/json"
}
else:
delete_s = []
for x in form['main_id_all']:
data = read('main_id', x, MyPlan_DayPlan_Notes_Model)[0]
delete_s.append(data)
print(delete_s)
delete(delete_s)
data = {
'message': "日计划多条删除成功！",
}
return jsonify(data), 200, {"ContentType": "application/json"}
def sell_process_delete():
'''
{
"main_id":""
}
:return:
'''
status = 200
message = '尽调流程内容删除成功！'
form = request.json
haveSellProcess = read("main_id", form['main_id'], SellProcess)
if haveSellProcess:
info = haveSellProcess[0].serialize
try:
delete(haveSellProcess[0])
except:
status = 400
message = '外键约束！'
info = '尽调流程内容删除失败！'
else:
status = 400
message = '尽调流程不存在！'
info = '尽调流程内容删除失败！'
info = {
'status': status,
'message': message,
'info': info
}
return jsonify(info)
def admin_shell_type_delete():
'''
:parmam {
"main_id":""
}
:return:
'''
status = 200
message = '壳公司类型删除成功！'
form = request.json
haveShell = read("main_id", form['main_id'], ShellType)
if haveShell:
info = haveShell[0].serialize
try:
delete(haveShell[0])
except:
status = 400
message = '外键约束！'
info = '壳公司类型删除失败'
else:
status = 400
message = '壳公司类型不存在！'
info = '壳公司类型删除失败'
backinfo = {'status': status, 'message': message, 'info': info}
return jsonify(backinfo)
def templatefile_delete():
'''
{
"process_id":"",
"file_link":""
}
:return:
'''
status = 200
message = '模板文件删除成功！'
form = request.json
haveTemplateFile = read("main_id", form['main_id'], TemplateFile)
if haveTemplateFile:
info = haveTemplateFile[0].serialize
try:
delete(haveTemplateFile[0])
except:
status = 400
message = '外键约束！'
info = '模板文件删除失败！'
else:
status = 400
message = '模板文件不存在！'
info = '模板文件删除失败！'
info = {
'status': status,
'message': message,
'info': info
}
return jsonify(info)
def basic_video_del():
"""
:param
无参数
{video_id}
:return:
data = {
'status': 200,
'message': '用户取消观看视频成功',
}
"""
form = request.json
video_id = form['video_id']
user_id = g.user_message.user_id
videoStatus = Video_And_User.query.filter(
Video_And_User.user_id == user_id,
Video_And_User.video_id == video_id).first()
delete(videoStatus)
data = {
'status': 200,
'message': '用户取消观看视频成功',
}
return jsonify(data)
def nb_team_del():
# 团队删除
form = request.json
main_id = form["main_id"]
lists = NbTeam.query.filter(NbTeam.main_id == main_id).first()
delete(lists)
data = {'status': 200, 'message': '团队删除成功！'}
return jsonify(data)
def permission_user_del():
# 板块权限删除
form = request.json
per = PermissionUser.query.filter(
PermissionUser.main_id == form['main_id']).first()
delete(per)
data = {'status': 200, 'message': '板块权限更新成功'}
return jsonify(data)
def buy_company_delete():
'''
{
"main_id":"",
}
:return:
'''
status = 200
message = '收购公司信息删除成功！'
form = request.json
haveBuyCompany = read("main_id", form['main_id'], BuyCompany)
if haveBuyCompany:
registered_province=haveBuyCompany[0].registered_province
type_id=haveBuyCompany[0].type_id
main_id=haveBuyCompany[0].main_id
rule = and_(SellCompany.company_province.like('%' + registered_province + '%'),
SellCompany.type_id == type_id)
list = SellCompany.query.filter(rule).all()
for i in list:
m = i.serialize
if m['buy_amount'] != '' and not m['buy_amount'] is None:
temp=eval(m['buy_amount'])
try:
temp.remove(main_id)
except:
pass
m['buy_amount'] = str(temp)
update(i, m)
if haveBuyCompany:
info = haveBuyCompany[0].serialize
try:
delete(haveBuyCompany[0])
except:
status = 400
message = '外键约束！'
info = '收购公司信息删除失败！'
else:
status = 400
message = '尽调流程不存在！'
info = '收购公司信息删除失败！'
info = {
'status': status,
'message': message,
'info': info
}
return jsonify(info)
def myplanweekdelete():
"""
:createlabel:删除我的周计划
:param:POST传：
form:value (状态值)
main_id (一条计划main_id)
:return:我的当前周计划表
"""
if request.method == 'POST':
form = request.json
delete(
read('main_id', form['main_id'], MyPlan_WeekPlan_Notes_Model)[0])
data = {
'message': "周计划删除成功",
}
return jsonify(data), 200, {"ContentType": "application/json"}
def company_kind_del():
'''
:param
main_id 法人环节名Id
:return:
'''
status = 200
message = '金融种类删除成功'
form = request.json
companyRegisitKind = CompanyRegisitKind.query.filter(
CompanyRegisitKind.main_id == form['main_id']).first()
if companyRegisitKind:
delete(companyRegisitKind)
else:
status = 400
message = '金融种类删除失败'
backinfo = {'status': status, 'message': message}
return jsonify(backinfo)
def provider_serviceContent_del():
'''
:param
main_id 法人环节名Id
:return:
'''
status = 200
message = '服务商服务内容（总）删除成功'
form = request.json
allservice = CompanyProviderAllContent.query.filter(
CompanyProviderAllContent.main_id == form['main_id']).first()
if allservice:
delete(allservice)
else:
status = 400
message = '服务商服务内容（总）删除失败'
backinfo = {'status': status, 'message': message, 'submit': form}
return jsonify(backinfo)
def company_legalperson_del():
'''
:param
company_all_legal_id 法人环节名Id
:return:
'''
status = 200
message = '视频法人环节名删除成功'
form = request.json
legalperson = CompanyRegisitAllLegalPerson.query.filter(
CompanyRegisitAllLegalPerson.main_id == form['main_id']).first()
if legalperson:
delete(legalperson)
else:
status = 400
message = '视频法人环节名删除失败'
backinfo = {'status': status, 'message': message}
return jsonify(backinfo)
def company_info_update():
'''
:param
:return:
'''
status = 200
message = '注册公司信息全部更新成功'
form = request.json
companyRegisitInfo = form['CompanyRegisitInfo']
main_id = form['CompanyRegisitInfo']['main_id']
myCompanyRegisitInfo = read("main_id", main_id, CompanyRegisitInfo)[0]
# 更新注册信息数据
update(myCompanyRegisitInfo, companyRegisitInfo)
companyRegisitBusinessScope = read("company_regisit_id", main_id,
CompanyRegisitBusinessScope)
companyRegisitServiceSonContent = read("company_regisit_id", main_id,
CompanyRegisitServiceSonContent)
companyInfoAndAllContent = read("company_regisit_id", main_id,
CompanyInfoAndAllContent)
companyRegisitSonLegalPerson = read("company_regisit_id", main_id,
CompanyRegisitSonLegalPerson)
companyInfoAndAllLegal = read("company_regisit_id", main_id,
CompanyInfoAndAllLegal)
companyInfoAndAllKind = read("company_regisit_id", main_id,
CompanyInfoAndAllKind)
companyRegisitGovenmentFile = read("company_regisit_id", main_id,
CompanyRegisitGovenmentFile)
companyProviderInfo = read("company_regisit_id", main_id,
CompanyProviderInfo)
for item in companyRegisitBusinessScope:
licenseFiles = read("company_business_id", item.main_id,
CompanyRegisitLicenseFile)
for file in licenseFiles:
delete(file)
delete(item)
for item in companyInfoAndAllLegal:
delete(item)
for item in companyInfoAndAllKind:
delete(item)
for item in companyInfoAndAllContent:
delete(item)
for item in companyRegisitSonLegalPerson:
delete(item)
for item in companyRegisitServiceSonContent:
delete(item)
for item in companyProviderInfo:
companyProviderCustomers = read("provider_regisit_id", item.main_id,
CompanyProviderCustomers)
companyProviderContent = read("provider_regisit_id", item.main_id,
CompanyProviderContent)
companyProviderAndAllContent = read("provider_regisit_id",
item.main_id,
CompanyProviderAndAllContent)
companyProviderSonContent = read("provider_regisit_id", item.main_id,
CompanyProviderSonContent)
for temp in companyProviderSonContent:
delete(temp)
for temp in companyProviderAndAllContent:
delete(temp)
for temp in companyProviderContent:
delete(temp)
for temp in companyProviderCustomers:
delete(temp)
for item in companyRegisitSonLegalPerson:
delete(item)
for item in companyProviderInfo:
delete(item)
for item in companyRegisitGovenmentFile:
delete(item)
for item in companyInfoAndAllContent:
delete(item)
for item in companyRegisitServiceSonContent:
delete(item)
for item in form['CompanyRegisitBusinessScope']:
item['main_id'] = get_mainid(pre="Business_Scope")
item['company_regisit_id'] = main_id
write(item, CompanyRegisitBusinessScope)
try:
temp = item['Company_business_img'][:]
for licensefile in temp:
licensefile['main_id'] = get_mainid(pre="LicenseFile")
licensefile['company_business_id'] = item['main_id']
write(licensefile, CompanyRegisitLicenseFile)
except:
pass
for item in form['CompanyInfoAndAllKind']:
mydirt = {}
mydirt['company_kind_id'] = item
mydirt['main_id'] = get_mainid(pre="AllKind")
mydirt['company_regisit_id'] = main_id
write(mydirt, CompanyInfoAndAllKind)
for item in form['CompanyInfoAndAllContent']:
item['main_id'] = get_mainid(pre="AllContent")
item['company_regisit_id'] = main_id
write(item, CompanyInfoAndAllContent)
for item in form['CompanyRegisitServiceSonContent']:
item['main_id'] = get_mainid(pre="SonContent")
item['company_regisit_id'] = main_id
write(item, CompanyRegisitServiceSonContent)
for item in form['CompanyInfoAndAllLegal']:
item['main_id'] = get_mainid(pre="AllLegal")
item['company_regisit_id'] = main_id
write(item, CompanyInfoAndAllLegal)
for item in form['CompanyRegisitSonLegalPerson']:
item['main_id'] = get_mainid(pre="SnoLegal")
item['company_regisit_id'] = main_id
write(item, CompanyRegisitSonLegalPerson)
for item in form['CompanyRegisitGovenmentFile']:
item['main_id'] = get_mainid(pre="GovFile")
item['company_regisit_id'] = main_id
write(item, CompanyRegisitGovenmentFile)
provider_regisit_id = get_mainid(pre="ProviderInfo")
for item in form['CompanyProviderInfo']:
item['main_id'] = provider_regisit_id
item['company_regisit_id'] = main_id
write(item, CompanyProviderInfo)
for temp in item['CompanyProviderAndAllContent']:
temp['main_id'] = get_mainid(pre="ProviderAllContent")
temp['provider_regisit_id'] = provider_regisit_id
write(temp, CompanyProviderAndAllContent)
for temp in item['CompanyProviderSonContent']:
temp['main_id'] = get_mainid(pre="ProviderSonContent")
temp['provider_regisit_id'] = provider_regisit_id
write(temp, CompanyProviderSonContent)
for temp in item['CompanyProviderCustomers']:
temp['main_id'] = get_mainid(pre="ProviderCustomers")
temp['provider_regisit_id'] = provider_regisit_id
write(temp, CompanyProviderCustomers)
for temp in item['CompanyProviderContent']:
temp['main_id'] = get_mainid(pre="ProviderContent")
temp['provider_regisit_id'] = provider_regisit_id
write(temp, CompanyProviderContent)
backinfo = {'status': status, 'message': message}
return jsonify(backinfo)
def company_info_del():
'''
:param
{'main_id': ''}
:return:
'''
status = 200
message = '注册公司信息删除成功'
form = request.json
main_id = form['main_id']
companyRegisitBusinessScopes = read("company_regisit_id", main_id,
CompanyRegisitBusinessScope)
for item in companyRegisitBusinessScopes:
licenseFiles = read("company_business_id", item.main_id,
CompanyRegisitLicenseFile)
for file in licenseFiles:
delete(file)
delete(item)
companyRegisitServiceSonContent = read("company_regisit_id", main_id,
CompanyRegisitServiceSonContent)
companyInfoAndAllContent = read("company_regisit_id", main_id,
CompanyInfoAndAllContent)
companyInfoAndAllKind = read("company_regisit_id", main_id,
CompanyInfoAndAllKind)
companyRegisitSonLegalPerson = read("company_regisit_id", main_id,
CompanyRegisitSonLegalPerson)
companyInfoAndAllLegal = read("company_regisit_id", main_id,
CompanyInfoAndAllLegal)
companyRegisitFileZip = read("company_regisit_id", main_id,
CompanyRegisitFileZip)
companyRegisitGovenmentFile = read("company_regisit_id", main_id,
CompanyRegisitGovenmentFile)
companyProviderInfo = read("company_regisit_id", main_id,
CompanyProviderInfo)
if companyProviderInfo:
companyProviderCustomers = read("provider_regisit_id",
companyProviderInfo[0].main_id,
CompanyProviderCustomers)
companyProviderContent = read("provider_regisit_id",
companyProviderInfo[0].main_id,
CompanyProviderContent)
companyProviderAndAllContent = read("provider_regisit_id",
companyProviderInfo[0].main_id,
CompanyProviderAndAllContent)
companyProviderSonContent = read("provider_regisit_id",
companyProviderInfo[0].main_id,
CompanyProviderSonContent)
for item in companyProviderSonContent:
delete(item)
for item in companyProviderAndAllContent:
delete(item)
for item in companyProviderContent:
delete(item)
for item in companyProviderCustomers:
delete(item)
companyRegisitInfo = read("main_id", main_id, CompanyRegisitInfo)
for item in companyProviderInfo:
delete(item)
for item in companyRegisitGovenmentFile:
delete(item)
for item in companyRegisitGovenmentFile:
delete(item)
for item in companyRegisitFileZip:
delete(item)
for item in companyRegisitSonLegalPerson:
delete(item)
for item in companyInfoAndAllContent:
delete(item)
for item in companyInfoAndAllKind:
delete(item)
for item in companyInfoAndAllLegal:
delete(item)
for item in companyRegisitServiceSonContent:
delete(item)
for item in companyRegisitInfo:
delete(item)
backinfo = {
'status': status,
'message': message,
}
return jsonify(backinfo)
