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 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 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 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 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 buy_company_add():
'''
{
"yewuyuan_id" :"", 业务员ID
"company_name" :"",收购机构名称
"type_id" :"",收购公司类型
"prefix" :"", 公司抬头
"spend" :"", 预算
"registered_capital" :"", 注册资本
"registered_time" :"", 注册时间要求
"registered_address" :"",注册地址要求
"business_scope" :"",经营范围
"other" :"",其他要求
"update_time" :"",发布时间
"grade" :"",置顶等级
}
'''
status = 200
message = '收购公司信息添加成功'
form = request.json
form["yewuyuan_id"] = g.user_message.user_id
main_id = get_mainid(pre="buyCompany")
buyCompany = form
buyCompany['main_id'] = main_id
buyCompany['update_time'] = datetime.now()
write(buyCompany, BuyCompany)
# 为所有相关的转让壳信息添加数字
if form['registered_province'] != '全部':
rule = and_(SellCompany.company_province.like('%' + form['registered_province'] + '%'),
SellCompany.type_id == form['type_id'])
else:
rule = SellCompany.type_id == form['type_id']
list = SellCompany.query.filter(rule).all()
for i in list:
m = i.serialize
print(m['buy_amount'])
if m['buy_amount'] == '' or m['buy_amount'] is None:
temp=[]
else:
temp=eval(m['buy_amount'])
temp.append(main_id)
m['buy_amount'] = str(temp)
update(i, m)
info = {
'status': status,
'message': message,
'info': form
}
return jsonify(info)
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 myplanweeksummarycreate():
"""
:createlabel:周计划总结
:param:POST传：
form:myplan_weekplan_summary (总结)
main_id (周计划main_id)
:return:我的当前周计划表
"""
if request.method == 'POST':
form = request.json
update(
read('main_id', form['main_id'], MyPlan_WeekPlan_Model)[0], form)
data = {'message': "周计划总结成功"}
return jsonify(data), 200, {"ContentType": "application/json"}
def myplandayupdate():
"""
:createlabel:修改我的日计划
:param:POST传：
form:value (状态值)
main_id (一条计划main_id)
:return:我的当前日计划表
"""
if request.method == 'POST':
form = request.json
data = read('main_id', form['main_id'], MyPlan_DayPlan_Notes_Model)[0]
update(data, form)
data = {
'message': "日计划修改成功",
}
return jsonify(data), 200, {"ContentType": "application/json"}
def men_keep_update():
form = request.json
form['mk_message'] = json.dumps(form['mk_message'])
form['mk_mission_plan'] = json.dumps(form['mk_mission_plan'])
if form['mk_contract']:
form['mk_contract'] = json.dumps(form['mk_contract'])
if form['mk_user_birthday'] == None or form['mk_user_birthday'] == "None":
del form['mk_user_birthday']
man_keep_info = ManKeep.query.filter(
ManKeep.main_id == form["main_id"]).first()
print(form)
update(man_keep_info, form)
man_keep_info.man_keep_label = []
man_keep_info.ManKeepTalentedPerson = []
db.session.add(man_keep_info)
db.session.commit()
# 写入人脉
label_list = form["label_one"] + form["label_two"]
# 人脉和 人脉标签绑定
for x in label_list:
label_info = ManKeepLabel.query.filter(
ManKeepLabel.main_id == x).first()
man_keep_info.man_keep_label.append(label_info)
#
if "mk_talented_person" in form and form[
'mk_talented_person'] != "" and form['mk_talented_person'] != {}:
form['mk_talented_person']['main_id'] = get_mainid(pre="mkt_")
form['mk_talented_person']['tp_resume'] = json.dumps(
form['mk_talented_person']['tp_resume'])
mkt_info = ManKeepTalentedPerson()
mkt_info.set_attrs(form['mk_talented_person'])
man_keep_info.ManKeepTalentedPerson = [mkt_info]
db.session.add(man_keep_info)
db.session.commit()
data = {
'status': 200,
'message': '人脉修改成功',
}
return jsonify(data)
def sell_company_update():
'''
{
"main_id":"",
"type_id" :"",
"name" :"",
"credit_code" :"",
"legal_person" :"",
"legal_person_tel_num" :"",
"docker_identity" :"",
"docker_tel_num" :"",
"company_area" :"",
"company_detail_address" :"",
"registration_time" :"",
"company_buy_time" :"",
"registered_capital" :"",
"company_buy_price" :"",
"business_scope" :"",
"remarks" :"",
"customer_file" :"",
"last_confirmation_time" :"",
"project_peroson_id" :"",
"social_account_status" :"",
"tax_registration_status" :"",
"bank_account_status" :"",
"shop_status" :""
}
'''
status = 200
message = '转让公司信息修改成功'
form = request.json
haveCompany = db.session.query(SellCompany).filter(SellCompany.main_id == form['main_id']).first()
if haveCompany:
form['buy_amount']=str(form['buy_amount'])
update(haveCompany,form)
else:
status = 400
message = '转让公司不存在'
info = {
'status': status,
'message': message,
'info': form
}
return jsonify(info)
def rev_test():
rq_data = request.json
if 'oa_token' in rq_data:
oa_token = rq_data['oa_token']
secret = "nbjinfu6666"
decode_data = jwt.decode(oa_token, secret)
if decode_data['user_id'] == rq_data['user_id']:
mydirt = {
'user_id': rq_data['user_id'],
'username': rq_data['realname'],
'userphone': rq_data['cellphone'],
'ningben_id': rq_data['crew_no'],
'department': rq_data['position'],
'img_url': rq_data['avatar'],
'user_text': '',
'grade': 0,
'role': 0,
'deletes': 0,
}
mydirt2 = {
'user_id': rq_data['user_id'],
'username': rq_data['realname'],
'userphone': rq_data['cellphone'],
'ningben_id': rq_data['crew_no'],
'department': rq_data['position'],
# 'img_url': rq_data['avatar'],
}
user = db.session.query(UserAndOA).filter(
UserAndOA.user_id == rq_data['user_id']).first()
if user is None:
user = UserAndOA()
user.set_attrs(mydirt)
db.session.add(user)
db.session.commit()
else:
update(user, mydirt2)
token = user.fa_oa_token()
token = token.decode('utf-8')
go_url = rq_data['red_url'] + "?token={}".format(token)
return jsonify({'code': 1, 'go_url': go_url})
return jsonify({'code': 0})
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 video_collection_handle():
"""
功能：视频收藏夹添加删除
参数：
video_id 视频Id
返回值：返回200添加到营销文章成功
"""
user_id = g.user_message.user_id
# user_id = "user1"
form = request.json
video_id = form['main_id']
goodCollection = VideoGoodCollection.query.filter(
VideoGoodCollection.video_id == video_id,
VideoGoodCollection.user_id == user_id).first()
if not goodCollection:
main_id = get_mainid("good_collection")
great_dirt = {
'main_id': main_id,
'video_id': video_id,
'user_id': user_id,
'collection_status': 1
}
write(great_dirt, VideoGoodCollection)
else:
temp = goodCollection.serialize
temp["collection_status"] = not temp["collection_status"]
update(goodCollection, temp)
goodCollection = VideoGoodCollection.query.filter(
VideoGoodCollection.video_id == video_id,
VideoGoodCollection.user_id == user_id).first()
data = {
'status': 200,
'labels': goodCollection.serialize,
'message': '营销文章收藏成功'
}
return jsonify(data)
def sell_process_add():
'''
出售流程添加
{
"sell_id":"",
"process_id":"",
"confirm_status":"",
"file_name":""
}
:return:
'''
status = 200
message = '尽调流程内容添加成功'
form = request.json
main_id = get_mainid(pre="sellProcess")
sellProcess = form
sell_id = form['sell_id']
sellProcess['main_id'] = main_id
write(sellProcess, SellProcess)
invitationCustomer = InvitationCustomer.query.filter(InvitationCustomer.sell_id == sell_id).first()
invitationCustomer = invitationCustomer.serialize
if(sellProcess.confirm_status == 2):
invitationCustomer['status'] == 3
update(invitationCustomer, InvitationCustomer)
else:
sellCount = SellProcess.query.filter(SellCompany.sell_id == sell_id).count()
processCount = Process.query.all().count()
if(sellCount == processCount):
invitationCustomer['status'] == 2
else:
invitationCustomer['status'] == 1
update(invitationCustomer, InvitationCustomer)
info = {
'status': status,
'message': message,
'info': form
}
return jsonify(info)
def article_label_update():
"""
功能：子标签更新
参数：
main_id 子标签Id
返回值: 200标签更新成功
"""
form = request.form.json
main_id = form['uid']
mal_article_label_name = form['mal_article_label_name']
marketing_Article_Label = Marketing_Article_Labels.query.filter(
Marketing_Article_Labels.main_id == main_id).first()
mydirt = marketing_Article_Label.serialize
mydirt['mal_article_label_name'] = mal_article_label_name
update(marketing_Article_Label, mydirt)
data = {'status': 200, 'message': '标签更新成功'}
return jsonify(data)
def video_good_handle():
"""
功能：添加用户点赞功能
参数：
video_id 文章Id
返回值：返回200视频点赞成功
"""
form = request.json
user_id = g.user_message.user_id # 获取用户信息
video_id = form['main_id']
goodCollection = VideoGoodCollection.query.filter(
VideoGoodCollection.video_id == video_id,
VideoGoodCollection.user_id == user_id).first()
if not goodCollection:
main_id = get_mainid("good_collection")
great_dirt = {
'main_id': main_id,
'video_id': video_id,
'user_id': user_id,
'good_status': 1
}
write(great_dirt, VideoGoodCollection)
else:
temp = goodCollection.serialize
temp["good_status"] = not temp["good_status"]
update(goodCollection, temp)
goodCollection = VideoGoodCollection.query.filter(
VideoGoodCollection.video_id == video_id,
VideoGoodCollection.user_id == user_id).first()
data = {
'status': 200,
'labels': goodCollection.serialize,
'message': '营销文章点赞成功'
}
return jsonify(data)
def basic_video_add():
"""
:param
无参数
{video_id, status}
:return:
data = {
'status': 200,
'message': '用户观看视频成功',
}
"""
user_id = g.user_message.user_id
form = request.json
# print(form)
# print(form['status'], form['video_id'])
form['user_id'] = user_id
videos = Video_And_User.query.filter(
Video_And_User.user_id == user_id,
Video_And_User.video_id == form['video_id']).first()
if videos:
video_status = videos.status
if (form['status'] > video_status):
update(videos, form)
elif (int(form['status']) == 2):
if (video_status == 2):
form['status'] = 1
update(videos, form)
else:
write(form, Video_And_User)
data = {
'status': 200,
'message': '用户观看视频成功',
}
return jsonify(data)
def joined_room(message):
"""Sent by clients when they enter a room.
A status message is broadcast to all people in the room."""
room = session.get('room')
user_name = session.get('name')
sid = request.sid
user = Online_Users.query.filter(Online_Users.user_id == user_name).first()
if user:
user_dirt = user.serialize
user_dirt['sid'] = sid
update(user, user_dirt)
else:
user = {
"main_id": get_mainid(pre="user_"),
"user_id": user_name,
"sid": sid,
}
write(user, Online_Users)
join_room(room)
if room in online_users:
online_users[room][user_name] = sid
if user_name not in online_users[room]:
emit('online_status', {
'msg': user_name + ' has entered the room.',
'online_users': online_users
},
room=room)
else:
emit('online_status', {'online_users': online_users}, room=room)
else:
online_users[room] = {user_name: sid}
emit('online_status', {
'msg': user_name + ' has entered the room.',
'online_users': online_users
},
room=room)
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)
def provider_status_handle():
'''
{
company_regisit_id:"" # 注册公司Id
main_id:"" # 服务商Id
}
:return:
'''
form = request.json
company_regisit_id = form['company_regisit_id']
main_id = form['main_id']
companyProviderInfo = CompanyProviderInfo.query.fileter(
CompanyProviderInfo.main_id == main_id,
CompanyProviderInfo.company_regisit_id == company_regisit_id).first()
companyProviderInfo = int(not companyProviderInfo.serialize['status'])
update(companyProviderInfo, CompanyProviderInfo)
data = {
'status': 200,
'message': '服务商状态操作成功',
'submit': companyProviderInfo
}
return jsonify(data)
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 sell_company_add():
'''
{
"type_id" :"",
"name" :"",
"company_name_mini" :"",
"credit_code" :"",
"legal_person" :"",
"legal_person_tel_num" :"",
"docker_identity" :"",
"docker_tel_num" :"",
"company_area" :"",
"company_detail_address" :"",
"registration_time" :"",
"company_buy_time" :"",
"registered_capital" :"",
"company_buy_price" :"",
"business_scope" :"",
"remarks" :"",
"customer_file" :"",
"last_confirmation_time" :"",
"project_peroson_id" :"",
"social_account_status" :"",
"tax_registration_status" :"",
"bank_account_status" :"",
"shop_status" :""
}
'''
status = 200
message = '转让公司信息添加成功'
form = request.json
form["yewuyuan_id"] = g.user_message.user_id
menkeep = ManKeep.query.filter(and_(ManKeep.mk_user_id == form["yewuyuan_id"], ManKeep.mk_phone == form["docker_tel_num"],)).first()
print(menkeep,"111111111111111111111111")
print(form["yewuyuan_id"], form["docker_tel_num"], form["docker_name"],"22222222222222222222222222222222222222")
if not menkeep:
print(form["yewuyuan_id"], form["docker_tel_num"], form["docker_name"])
menKeeps(form["yewuyuan_id"], form["docker_tel_num"], form["docker_name"])
main_id = get_mainid(pre="sellCompany")
sellCompany = form
sellCompany['main_id'] = main_id
write(sellCompany, SellCompany)
# 为所有相关的收购壳信息添加数字
rule = and_(BuyCompany.registered_province.like('%'+form['company_province']+'%'), BuyCompany.type_id == form['type_id'])
list = BuyCompany.query.filter(rule).all()
for i in list:
m = i.serialize
if m['shell_amount'] == '' or m['shell_amount'] is None:
temp = []
else:
temp = eval(m['shell_amount'])
temp.append(main_id)
m['shell_amount'] = str(temp)
update(i, m)
info = {
'status': status,
'message': message,
'info': form
}
return jsonify(info)
def video_update():
"""
功能：视频更新
参数：
{
"video":{
"main_id":"",需要更新视频的main_id
"video_img":"",视频首图
"video_min_img":"",视频小首图
"video_title":"",视频标题
"video_link":"",视频连接
"video_user_id":"",视频作者Id
"video_password":"",视频密码
"video_talker":""视频主讲人
},
"files":[
{
"video_file_name":"", #视频名
"video_file_link":"", # 视频链接
}
],
"labels":[
{
"label":""
}
]
}
返回值：返回200视频更新成功
"""
form = request.json
main_id = form['video']['main_id']
video_info = VideoInfo.query.filter(VideoInfo.main_id == main_id).first()
video = form['video']
video['video_update_time'] = datetime.now()
update(video_info, video)
video_info.files = []
video_info.comment = []
video_info.video_labels = []
video_info.al_labels = []
db.session.add(video_info)
db.session.commit()
for item in form["labels"]:
if (item[:2] == 'al'):
advancedLabel = AdvancedLabel.query.filter(
AdvancedLabel.al_uid == item).first()
video_info.al_labels.append(advancedLabel)
else:
videoLabels = VideoLabels.query.filter(
VideoLabels.main_id == item).first()
video_info.video_labels.append(videoLabels)
# 写入视频文件
for item in form["files"]:
item["main_id"] = get_mainid(pre="file")
item["video_id"] = main_id
file = VideoFiles()
file.set_attrs(item)
video_info.files.append(file)
db.session.add(video_info)
db.session.commit()
data = {'status': 200, 'message': '视频内容更新成功'}
return jsonify(data)
