def provider_serviceContent_add():
'''
:param
provider_all_service_content 服务内容（admin）
:return:
'''
status = 200
message = '服务内容总添加成功'
form = request.json
form['main_id'] = get_mainid(pre='all_service')
allservice = read("company_all_service_content",
form['provider_all_service_content'],
CompanyRegisitServiceAllContent)
if allservice:
status = 400
message = '服务内容已存在'
else:
write(form, CompanyProviderAllContent)
backinfo = {'status': status, 'message': message, 'submit': form}
return jsonify(backinfo)
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 sell_process_update():
'''
{
"main_id":"",
"project_peroson_id":"",
"process_id":"",
"yewuyuan_id":"",
"confirm_status":"",
"file_name":""
}
:return:
'''
status = 200
message = '尽调流程内容修改成功'
form = request.json
haveSellProcess = read("main_id", form['main_id'], SellProcess)
if haveSellProcess:
update(haveSellProcess[0], form)
else:
status = 400
message = '尽调流程不存在'
info = {
'status': status,
'message': message,
'info': haveSellProcess[0].serialize
}
return jsonify(info)
def admin_shell_type_update():
'''
:parmam
{
"main_id":"",
"type_name":""
}
:return:
'''
status = 200
message = '壳公司类型修改成功'
form = request.json
haveShell = read("main_id", form['main_id'], ShellType)
if haveShell:
update(haveShell[0], form)
else:
status = 400
message = '壳公司类型不存在'
backinfo = {
'status': status,
'message': message,
'info': haveShell[0].serialize
}
return jsonify(backinfo)
def buy_company_find_one_update():
'''
查看收购公司详情
:parmam
{"main_id": ""}
:return:
'''
status = 200
message = '收购公司信息查找成功'
form = request.json
buyCompanys = read("main_id", form["main_id"], BuyCompany)
info = []
for item in buyCompanys:
t = item.serialize
t['type_name'] = ShellType.query.filter(ShellType.main_id == t['type_id']).first().type_name
t['update_time'] = str(t['update_time'])
info.append(t)
if buyCompanys == []:
status = 400
message = '收购公司信息不存在'
info = {
'status': status,
'message': message,
'info': info
}
return jsonify(info)
def templatefile_add():
'''
{
模板文件添加
"process_id":"",
"file_link":""
}
:return:
'''
status = 200
message = '模板文件添加成功'
form = request.json
main_id = get_mainid(pre="templateFile")
templateFile = form
haveFile = read("file_link", form['file_link'], TemplateFile)
if haveFile:
status = 400
message = '模板文件已存在'
else:
templateFile['main_id'] = main_id
write(templateFile, TemplateFile)
info = {
'status': status,
'message': message,
'info': form
}
return jsonify(info)
def process_update():
'''
{
"main_id":"",
"process_name":"",
"grade":""
}
:return:
'''
status = 200
message = '流程修改成功'
form = request.json
haveProcss = read("main_id", form['main_id'], Process)
if haveProcss:
form['shell_amount']=str(form['shell_amount'])
update(haveProcss[0], form)
else:
status = 400
message = '流程不存在'
info = {
'status': status,
'message': message,
'info': haveProcss[0].serialize
}
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 sell_company_find_one_update():
'''
查看装让公司详情
:parmam
{"main_id": ""}
:return:
'''
status = 200
message = '转让公司信息查找成功'
form = request.json
sellCompany = read("main_id", form["main_id"], SellCompany)
info = []
for item in sellCompany:
t = item.serialize
t['type_name'] = ShellType.query.filter(ShellType.main_id == t['type_id']).first().type_name
t['company_buy_time'] = str(t['company_buy_time'])
t['registration_time'] = str(t['registration_time'])
t['last_confirmation_time'] = str(t['last_confirmation_time'])
info.append(t)
if sellCompany == []:
status = 400
message = '转让公司信息不存在'
info = {
'status': status,
'message': message,
'info': info
}
return jsonify(info)
def process_add():
'''
流程添加
{
"process_name":"",
"grade":""
}
:return:
'''
status = 200
message = '流程添加成功'
form = request.json
main_id = get_mainid(pre="process")
process = form
haveProcess = read("process_name", form['process_name'], Process)
if haveProcess:
status = 400
message = '流程已存在'
else:
process['main_id'] = main_id
write(process, Process)
info = {
'status': status,
'message': message,
'info': form
}
return jsonify(info)
def invitation_customer_update():
'''
{
"main_id":"",
"sell_id":"",
"sell_user_id":"",
"price":""，
"status":""
}
:return:
'''
status = 200
message = '邀请人修改成功'
form = request.json
haveInvitationCustomer = read("main_id", form['main_id'], InvitationCustomer)
if haveInvitationCustomer:
others = db.session.query(InvitationCustomer).filter(InvitationCustomer.sell_id == form["sell_id"]).update({'status':0}) # 其他邀请人
update(haveInvitationCustomer[0], form)
else:
status = 400
message = '邀请人不存在'
sell = SellCompany.query.filter(SellCompany.main_id == form["sell_id"]).first()
if sell.step == "2":
sell.step = 3
db.session.add(sell)
db.session.commit()
info = {
'status': status,
'message': message,
'info': haveInvitationCustomer[0].serialize
}
return jsonify(info)
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 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 templatefile_update():
'''
{
"main_id":"",
"process_id":"",
"file_link":""
}
:return:
'''
status = 200
message = '模板文件修改成功'
form = request.json
haveTemplateFile = read("main_id", form['main_id'], TemplateFile)
if haveTemplateFile:
update(haveTemplateFile[0], form)
else:
status = 400
message = '模板文件不存在'
info = {
'status': status,
'message': message,
'info': haveTemplateFile[0].serialize
}
return jsonify(info)
def men_keep_label_top():
form = request.json
main_id = form['main_id']
value = int(form['value'])
if value == 1:
ManKeepLabels = read("main_id", main_id, ManKeepLabel)[0]
ManKeepLabels.grade = ManKeepLabels.grade + 1
db.session.commit()
else:
ManKeepLabels = read("main_id", main_id, ManKeepLabel)[0]
ManKeepLabels.grade = ManKeepLabels.grade - 1
db.session.commit()
data = {
'status': 200,
'message': '营销文章标签次序操作成功',
}
return jsonify(data)
def men_keep_label_update():
form = request.json
main_id = form['main_id']
ManKeepLabels = read("main_id", main_id, ManKeepLabel)[0]
update(ManKeepLabels, form)
data = {'status': 200, 'message': '标签更新成功'}
return jsonify(data)
def buy_company_pro_and_type():
'''
查看省市区和类型相匹配的公司业务
:parmam
{
"company_province" :""# 公司所属地区 省
"company_city" : ""# 公司所属地区 市
"company_region" : ""# 公司所属地区 区
"type_id":""# 类型id
}
:return:
'''
status = 200
message = '查询当前用户业务成功'
form = request.json
company_province = '%' + str(form["company_province"]) + '%'
company_city = '%' + form["company_city"] + '%'
company_region = '%' + form["company_region"] + '%'
type_id = form["type_id"]
# user_id = g.user_message.user_id
# sellCompanys = read("yewuyuan_id", user_id, SellCompany)
if form["company_province"] != '全部':
sellCompanys = SellCompany.query.filter(type_id == SellCompany.type_id). \
filter(or_(SellCompany.company_province.like(company_province),SellCompany.company_province.like('全部'))) \
.order_by(SellCompany.last_confirmation_time.desc()).all()
else:
sellCompanys = SellCompany.query.filter(type_id == SellCompany.type_id).order_by(SellCompany.last_confirmation_time.desc()).all()
info = []
for item in sellCompanys:
t = item.serialize
t['last_confirmation_time'] = str(t['last_confirmation_time'])
t['company_buy_time'] = str(t['company_buy_time'])
t['registration_time'] = str(t['registration_time'])
try:
shell_amount=eval(t['shell_amount'])
except:
shell_amount=[]
t['shell_amount']=shell_amount
info.append(t)
lists = read("main_id", form['main_id'], BuyCompany)[0]
m = lists.serialize
m['shell_amount'] = ""
update(lists, m)
info = {
'status': status,
'message': message,
'info': info
}
return jsonify(info)
def company_info_findall():
'''
:param
label_main_id
:return:
'''
status = 200
message = '注册公司信息全部查询成功'
form = request.json
companyInfoAndAllKinds = read("company_kind_id", form['label_main_id'],
CompanyInfoAndAllKind)
info = []
for item in companyInfoAndAllKinds:
company_regisit_id = item.company_regisit_id
companyRegisitInfo = read("main_id", company_regisit_id,
CompanyRegisitInfo)[0]
myjson = companyRegisitInfo.serialize
business_scope = read("company_regisit_id", company_regisit_id,
CompanyRegisitBusinessScope)
all_content_id = read("company_regisit_id", company_regisit_id,
CompanyInfoAndAllContent)
son_content_id = read("company_regisit_id", company_regisit_id,
CompanyRegisitServiceSonContent)
myjson['businessScope'] = []
myjson['allContent'] = []
myjson['sonContent'] = []
for bs in business_scope:
businessInfo = bs.serialize
licenseFiles = read("company_business_id", businessInfo['main_id'],
CompanyRegisitLicenseFile)
licenseFile = [file.serialize for file in licenseFiles]
businessInfo['Company_business_img'] = licenseFile
myjson['businessScope'].append(businessInfo)
for all_id in all_content_id:
try:
all_content = read("main_id", all_id.company_allcontent_id,
CompanyRegisitServiceAllContent)[0]
myjson['allContent'].append(all_content.serialize)
except IndexError:
myjson['allContent'] = []
for son_id in son_content_id:
myjson['sonContent'].append(son_id.serialize)
info.append(myjson)
# if(info['businessScope']['status'] == 1):
# info = sorted(info, key=lambda x: x['grade'], reverse=True)
backinfo = {
'submit': info,
'status': status,
'message': message,
'count': len(info)
}
return jsonify(backinfo)
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 sell_company_pro_and_type():
'''
查看省市区和类型相匹配的公司业务
:parmam
{
"registered_province" :""# 公司所属地区 省
"registered_city" : ""# 公司所属地区 市
"registered_region" : ""# 公司所属地区 区
"type_id":""# 类型id
}
:return:
'''
status = 200
message = '查询当前用户业务成功'
form = request.json
registered_province = '%' + form["registered_province"] + '%'
registered_city = '%' + form["registered_city"] + '%'
registered_region = '%' + form["registered_region"] + '%'
type_id = form["type_id"]
if form["registered_province"] != '全部':
buyCompanys = BuyCompany.query.filter(type_id == BuyCompany.type_id). \
filter(or_(BuyCompany.registered_province.like(registered_province), BuyCompany.registered_province.like('全部'))) \
.order_by(BuyCompany.update_time.desc()).all()
else:
buyCompanys = BuyCompany.query.filter(type_id == BuyCompany.type_id).order_by(BuyCompany.update_time.desc()).all()
info = []
for item in buyCompanys:
t = item.serialize
t['update_time'] = str(t['update_time'])
try:
buy_amount=eval(t['buy_amount'])
except:
buy_amount=[]
t['buy_amount'] = buy_amount
info.append(t)
lists = read("main_id", form['main_id'], SellCompany)[0]
m = lists.serialize
m['buy_amount'] = ""
update(lists, m)
info = {
'status': status,
'message': message,
'info': info
}
return jsonify(info)
def user_message():
if request.method == 'POST':
form = request.json
if form:
value = read('user_id', form['user_id'], UserAndOA)[0]
else:
value = g.user_message
list = value.serialize
team_list = []
for x in value.team_value:
team_list.append(x.serialize)
list['team'] = team_list
data = {'status': 200, 'message': 'ok', 'user_message': list}
data = json.dumps(data, default=lambda o: o.__dict__)
return data, 200, {"ContentType": "application/json"}
def my_message_updata():
if request.method == 'POST':
form = request.json
if form['user_id'] != g.user_message.user_id:
data = {
'status': 203,
'message': '您没有权限修改！',
}
data = json.dumps(data, default=lambda o: o.__dict__)
return data, 203, {"ContentType": "application/json"}
value =read ('user_id', form['user_id'], UserAndOA)[0]
update(value, form)
data = {
'status': 200,
'message': 'ok',
}
data = json.dumps(data, default=lambda o: o.__dict__)
return data, 200, {"ContentType": "application/json"}
def sell_company_find_one_x():
'''
列举出转让公司的信息和达成转让条件的人
:parmam
{"main_id": ""}
:return:
'''
status = 200
message = '转让公司信息查找成功'
form = request.json
sellCompany = read("main_id", form["main_id"], SellCompany)
info = []
for item in sellCompany:
t = item.serialize
t['type_name'] = ShellType.query.filter(ShellType.main_id == t['type_id']).first().type_name
if t['legal_person_tel_num'] == 11:
t['legal_person_tel_num'] = t['legal_person_tel_num'][:3] + '*' * 5 + t['legal_person_tel_num'][-3:]
t['docker_tel_num'] = t['docker_tel_num'][:3] + '*' * 5 + t['docker_tel_num'][-3:]
t['company_buy_time'] = str(t['company_buy_time'])
t['registration_time'] = str(t['registration_time'])
t['last_confirmation_time'] = str(t['last_confirmation_time'])
sell_users = InvitationCustomer.query.filter(form["main_id"] == InvitationCustomer.sell_id).all()
users_li = []
for u in sell_users:
user = u.serialize
if user['status'] == 1:
users_li.append(user)
t['sell_users'] = users_li
info.append(t)
if sellCompany == []:
status = 400
message = '转让公司信息不存在'
info = {
'status': status,
'message': message,
'info': info
}
return jsonify(info)
def sell_company_find_one_l():
'''
查看装让公司详情
:parmam
{"main_id": ""}
:return:
'''
status = 200
message = '转让公司信息查找成功'
form = request.json
sellCompany = read("main_id", form["main_id"], SellCompany)
info = []
for item in sellCompany:
t = item.serialize
t['type_name'] = ShellType.query.filter(ShellType.main_id == t['type_id']).first().type_name
if t['legal_person_tel_num'] == 11:
t['legal_person_tel_num'] = t['legal_person_tel_num'][:3] + '*' * 5 + t['legal_person_tel_num'][-3:]
t['docker_tel_num'] = t['docker_tel_num'][:3] + '*' * 5 + t['docker_tel_num'][-3:]
t['company_buy_time'] = str(t['company_buy_time'])
t['registration_time'] = str(t['registration_time'])
t['last_confirmation_time'] = str(t['last_confirmation_time'])
if t['company_name_mini']:
t['name'] = t['name'].replace(t['company_name_mini'], '')
t['credit_code'] = t['credit_code'][:-4] + '****'
del t['company_detail_address']
sell_users = InvitationCustomer.query.filter(form["main_id"] == InvitationCustomer.sell_id).all()
users_li = []
for u in sell_users:
users_li.append(u.serialize)
t['sell_users'] = users_li
info.append(t)
if sellCompany == []:
status = 400
message = '转让公司信息不存在'
info = {
'status': status,
'message': message,
'info': info
}
return jsonify(info)
def company_kind_add():
'''
:param
company_all_kind 金融种类名
:return:
'''
status = 200
message = '金融种类添加成功'
form = request.json
form['main_id'] = get_mainid(pre='kind')
companyRegisitKind = read("company_all_kind", form['company_all_kind'],
CompanyRegisitKind)
if companyRegisitKind:
status = 400
message = '金融种类已存在'
else:
write(form, CompanyRegisitKind)
backinfo = {'status': status, 'message': message, 'submit': form}
return jsonify(backinfo)
def sell_process_findall():
'''
查找某样进度的所有流程情况
:parmam
{
"main_id":"" # 出售流程公司ID
}
:return:
'''
status = 200
message = '进度流程查找成功'
form = request.json
sellProcess = read("sell_id", form["main_id"], SellProcess)
sellProcess = [item.serialize for item in sellProcess]
info = {
'status': status,
'message': message,
'info': sellProcess
}
return jsonify(info)
def invitation_customer_findall():
'''
查找全部邀约人
:parmam
{
"main_id":""
}
:return:
'''
status = 200
message = '邀请人查找成功'
form = request.json
invitationCustomer = read("sell_id", form["main_id"], InvitationCustomer)
invitationCustomer = [item.serialize for item in invitationCustomer]
info = {
'status': status,
'message': message,
'info': invitationCustomer
}
return jsonify(info)
def company_legalperson_add():
'''
:param
company_all_legal_name 法人环节名
:return:
'''
status = 200
message = '法人环节名添加成功'
form = request.json
form['main_id'] = get_mainid(pre='legalperson')
legalperson = read("company_all_legal_name",
form['company_all_legal_name'],
CompanyRegisitAllLegalPerson)
if legalperson:
status = 400
message = '法人环节名已存在'
else:
write(form, CompanyRegisitAllLegalPerson)
backinfo = {'status': status, 'message': message, 'submit': form}
return jsonify(backinfo)
def admin_shell_type_add():
'''
{
"type_name":""
}
:return:
'''
status = 200
message = '壳公司类型添加成功'
form = request.json
main_id = get_mainid(pre="companyType")
shellType = form
haveShell = read("type_name", form['type_name'], ShellType)
if haveShell:
status = 400
message = '壳公司类型已存在'
else:
shellType['main_id'] = main_id
write(shellType, ShellType)
backinfo = {'status': status, 'message': message, 'info': form}
return jsonify(backinfo)
def buy_company_update():
'''
{
"main_id":"",
"yewuyuan_id" :"", 业务员ID
"company_name" :"",收购机构名称
"type_id" :"",收购公司类型
"prefix" :"", 公司抬头
"spend" :"", 预算
"registered_capital" :"", 注册资本
"registered_time" :"", 注册时间要求
"registered_address" :"",注册地址要求
"business_scope" :"",经营范围
"other" :"",其他要求
"update_time" :"",发布时间
"grade" :"",置顶等级
}
:return:
'''
status = 200
message = '收购公司信息修改成功'
form = request.json
form["yewuyuan_id"] = g.user_message.user_id
haveBuyCompany = read("main_id", form['main_id'], BuyCompany)
if haveBuyCompany:
update(haveBuyCompany[0], form)
else:
status = 400
message = '收购公司信息不存在'
info = {
'status': status,
'message': message,
'info': haveBuyCompany[0].serialize
}
return jsonify(info)
