def video_label_add():
"""
功能：视频子标签添加
参数：
{"video_label_name":"标签名"}
返回值: 200视频子标签添加成功
"""
status = 200
message = '标签添加成功'
main_id = get_mainid(pre="video_label_")
form = request.json
form['main_id'] = main_id
form['grade'] = 0
haveVideoLable = VideoLabels.query.filter(
VideoLabels.video_label_name == form["video_label_name"]).first()
if haveVideoLable:
status = 400
message = '标签已存在'
else:
write(form, VideoLabels)
data = {'status': status, 'message': message, 'label': form}
return jsonify(data)
def knowledge_label_add():
"""
功能：知识库文章子标签添加
参数：
{"article_label_name":"标签名"}
返回值: 200
"""
status = 200
message = '标签添加成功'
form = request.json
form['main_id'] = get_mainid(pre="knowledge_label_")
haveVideoLable = Knowledge_Article_Labels.query.filter(Knowledge_Article_Labels.article_label_name == form["article_label_name"]).first()
if haveVideoLable:
status = 400
message = '标签已存在'
else:
write(form, Knowledge_Article_Labels)
data = {
'status': status,
'message': message,
'label': form
}
return jsonify(data)
def meeting_add():
'''
:param:
{
"title":"" #会议标题
"prov":"" #会议省
"city":"" #会议市
"address":"" #会议详细地址
"cover":"" #会议封面
"sponsor":"" #会议赞助商
"total":"" #会议参会人数
"detail":"" #会议内容安排
"price":"" #参会价格
"begin_at":"" # 开始时间
"end_at":""· # 结束时间
"admin_id" # 管理员ID
"rating" # 打分
can_apply # 是否可以通过
is_top # 是否置顶
is_valid # 是否有效
}
:return:
'''
rq_data = request.json
rq_data['end_at'] = time_transfer(rq_data['end_at'])
rq_data['hits'] = 0
rq_data['begin_at'] = time_transfer(rq_data['begin_at'])
rq_data['admin_id'] = g.user_message.user_id
rq_data['main_id'] = get_mainid("meet_")
write(rq_data, Meetings)
data = {'status': 200, 'message': '会议写入成功'}
return jsonify(data)
def knowledge_comment_add():
"""
功能：评论添加
参数：
{
talk_content 评论内容
article_id 评论文章id
}
返回值: 200评论添加成功
"""
user_id= g.user_message.user_id # 获取用户信息
# user_id = "user1"
form = request.json
form['main_id'] = get_mainid(pre="knowledge_comment_")
form["user_id"] = user_id
knowledge_Comment_Info = Knowledge_Comment_Info()
knowledge_Comment_Info.set_attrs(form)
db.session.add(knowledge_Comment_Info)
db.session.commit()
data = {
'status': 200,
'message': '评论添加成功',
'info': form
}
return jsonify(data)
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_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 wechat_info_update():
'''
:function: 微信号更新好友和群聊数量
[
{
'wechat_name':"",
'wechat_id':"",
"wechat_friend_count":"",
"wechat_chat_count":""
}
]
:return:
'''
form = request.json
user_id = g.user_message.user_id
wechatScore = WechatScore.query.filter(
WechatScore.user_id == user_id).all()
if wechatScore:
WechatScore.query.filter(WechatScore.user_id == user_id).delete()
db.session.commit()
for item in form:
item["user_id"] = g.user_message.user_id
item["main_id"] = get_mainid(pre="wechat_info_")
write(item, WechatScore)
db.session.commit()
data = {
'status': 200,
'message': '微信信息修改成功',
}
return jsonify(data)
def video_comment_add():
"""
功能：评论添加
参数：
{
video_comment_content 评论内容
video_id 视频id
}
返回值: 200评论添加成功
"""
# user = type("User", (), {"user_id": "user1", "grade": 0,"username":"******"})
user = g.user_message # 获取用户信息
form = request.json
form["video_comment_time"] = datetime.now()
form["video_id"] = form["main_id"]
form["main_id"] = get_mainid(pre="videoComment")
form["video_user_id"] = user.user_id
write(form, VideoCommentInfo)
data = {
'status': 200,
'message': '评论添加成功',
'date': {
'name': user.username,
'TimeFun': str(form["video_comment_time"]),
'good': 0,
'text': form['video_comment_content'],
}
}
return jsonify(data)
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 knowledge_good_status():
"""
功能：用户点赞
参数：
main_id 文章Id
返回值：返回200营销文章点赞成功
"""
user_id = g.user_message.user_id
# user_id = "user1"
form = request.json
article_id = form['main_id']
knowledge_Article_GoodCollection = Knowledge_Article_GoodCollection.query.filter(Knowledge_Article_GoodCollection.article_id == article_id,
Knowledge_Article_GoodCollection.user_Id == user_id).first()
if not knowledge_Article_GoodCollection:
main_id = get_mainid(pre="good_collection")
great_dirt = {
'main_id': main_id,
'article_id': article_id,
'user_Id': user_id,
'good_status' : 1
}
knowledge_Article_GoodCollection = Knowledge_Article_GoodCollection()
knowledge_Article_GoodCollection.set_attrs(great_dirt)
else:
knowledge_Article_GoodCollection.good_status = not knowledge_Article_GoodCollection.good_status
db.session.add(knowledge_Article_GoodCollection)
db.session.commit()
data = {
'status': 200,
'message': '营销文章点赞成功'
}
return jsonify(data)
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 men_keep_add():
user = g.user_message.user_id # 获取用户信息
form = request.json
form["mk_user_id"] = user
form["mk_time"] = datetime.now()
form['main_id'] = get_mainid(pre="mk_")
form['mk_message'] = json.dumps(form['mk_message'])
form['mk_mission_plan'] = json.dumps(form['mk_mission_plan'])
if form['mk_user_birthday'] == "":
del form['mk_user_birthday']
man_keep_info = ManKeep()
man_keep_info.set_attrs(form)
# 写入人脉
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 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 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 permission_user_add():
# 板块权限添加
main_id = get_mainid("per")
form = request.json
form["main_id"] = main_id
label_list = form["pu_users"]
permission_user_info = PermissionUser()
permission_user_info.set_attrs(form)
for x in label_list:
user = UserAndOA.query.filter(
UserAndOA.user_id == x['user_id']).first()
permission_user_info.puermission_users.append(user)
db.session.add(permission_user_info)
db.session.commit()
data = {'status': 200, 'message': '板块权限添加成功'}
return jsonify(data)
def knowledge_write():
"""
:function: 知识库文章内容写入
:param:
{
"article":{
"content":"",文章内容
"img":"", 文章小首图
"img_min":"",文章缩放图
"title":"", 文章标题
"nice":"", 文章是否精品
"original":"", 文章是否原创
},
"labels":[
""
]
}
:return:
"""
form = request.json
user_id = g.user_message.user_id
main_id = get_mainid(pre="articleInfo_")
form['article']["main_id"] = main_id
form['article']["user_id"] = user_id
article = Knowledge_Articles_Info()
article.set_attrs(form["article"])
# 视频和标签绑定
for item in form["labels"]:
if (item[:2] == 'al'):
advancedLabel = AdvancedLabel.query.filter(AdvancedLabel.al_uid == item).first()
article.al_labels.append(advancedLabel)
else:
articleLabels = Knowledge_Article_Labels.query.filter(Knowledge_Article_Labels.main_id == item).first()
article.article_labels.append(articleLabels)
db.session.add(article)
db.session.commit()
data = {
'status': 200,
'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 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 wechat_bind_info():
'''
:function: 微信号绑定
[
{
'wechat_name':"",
'wechat_id':"",
"wechat_friend_count":"",
"wechat_chat_count":""
}
]
:return:
'''
form = request.json
form["user_id"] = g.user_message.user_id
form["main_id"] = get_mainid(pre="wechat_info_")
write(form, WechatScore)
data = {'status': 200, 'message': '微信信息绑定成功', 'info': form}
return jsonify(data)
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 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 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 nb_team_add():
# 团队添加
form = request.json
main_id = get_mainid("team")
form["main_id"] = main_id
myobject = NbTeam()
myobject.set_attrs(form)
db.session.add(myobject)
db.session.commit()
lists = []
for x in form["pl_users"]:
users = UserAndOA.query.filter(
UserAndOA.user_id == x["user_id"]).first()
lists.append(users)
myobject.user_value = lists
db.session.commit()
data = {'status': 200, 'message': '团队添加成功！'}
return jsonify(data)
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 company_serviceContent_add():
'''
:param
company_all_service_content 服务内容（admin）
:return:
'''
status = 200
message = '服务内容总添加成功'
form = request.json
form['main_id'] = get_mainid(pre='allservice')
allservice = CompanyRegisitServiceAllContent.query.filter(
CompanyRegisitServiceAllContent.company_all_service_content ==
form['company_all_service_content']).first()
if allservice:
status = 400
message = '服务内容已存在'
else:
write(form, CompanyRegisitServiceAllContent)
backinfo = {'status': status, 'message': message, 'submit': form}
return jsonify(backinfo)
def invitation_customer_add():
'''
邀约人添加
{
"sell_id":"", //壳公司转让id
"sell_user_id":"", 业务员求购人id
"price":"" 求购预算
"message":"" 收购要求
}
:return:
'''
status = 200
message = '邀请人添加成功'
form = request.json
form["sell_user_id"] = g.user_message.user_id
main_id = get_mainid(pre="invitationCustomer")
invitationCustomer = form
invitationCustomer['main_id'] = main_id
invitationCustomer['status'] = 0
write(invitationCustomer, InvitationCustomer)
sell = SellCompany.query.filter(SellCompany.main_id == form["sell_id"]).first()
if sell.step == "1":
sell.step = 2
db.session.add(sell)
db.session.commit()
info = {
'status': status,
'message': message,
'info': form
}
return jsonify(info)
def company_info_add():
'''
:param
{
"CompanyRegisitInfo": {
"main_id":"regisit_info20190723-1007455293",
"company_charge_people": "22" ,
"company_tel":"220",
"company_addtax":"0.5",
"company_incometax":"0.2",
"company_local_incentives":"0.8",
"company_local_advantage":"good",
"company_special_note":"very good",
"company_address":"address"
},
"CompanyRegisitBusinessScope":[ {
"company_regisit_name":"kjy",
"company_business_scope": "providence",
"Company_business_img":[{
"company_license_file_name":"licfile2" ,
"company_license_file_link":"liclink2"
}]
}],
"CompanyInfoAndAllContent":[{
"company_allcontent_id":"allcontent1"
}],
"CompanyRegisitServiceSonContent":[{
"company_son_service_content":"soncontent2"
}],
"CompanyInfoAndAllKind":[{
"company_kind_id":"allkind1"
}],
"CompanyInfoAndAllLegal":[{
"company_alllegal_id":"alllegal1"
}]
"CompanyRegisitSonLegalPerson":[{
"company_son_legal_name":"sonlegal2"
}],
"CompanyRegisitGovenmentFile":[{ 政府文件上传
"company_govenment_file_name":"govname2",
"company_govenment_file_link":"govlink2"
}],
"CompanyRegisitFileZip":[{ 注册材料上传
"company_regisit_file_name":"regisitname2",
"company_regisit_file_link":"regisitlink2"
}],
"CompanyProviderInfo":[{
"company_serviceprovider_address":"zhejiang",
"company_serviceprovider_name":"xxx company",
"company_serviceprovider_person":"lzw",
"company_serviceprovider_phone": "phone 220",
"company_serviceprovider_beizhu": "phone 220",
"CompanyProviderAndAllContent":[{
"provider_allcontent_id": "provider1"
}],
"CompanyProviderSonContent":[{
"provider_son_service_content":"sonprovider2"
}],
"CompanyProviderCustomers": [{
"company_servicecustomers_id":"xxxxx2",
"company_servicecustomers_people":"customer2",
"company_serviceprovider_feedback": "good"
}],
"CompanyProviderContent":[{
"provider_regisit_info":"proxy"
}]
}]
}
:return:
'''
status = 200
message = '注册公司信息添加成功'
form = request.json
main_id = get_mainid(pre="regisit_info")
companyRegisitInfo = form['CompanyRegisitInfo']
companyRegisitInfo['main_id'] = main_id
companyRegisitInfo['grade'] = 0
write(companyRegisitInfo, CompanyRegisitInfo)
for item in form['CompanyRegisitBusinessScope']:
item['main_id'] = get_mainid(pre="Business_Scope")
item['company_regisit_id'] = main_id
write(item, CompanyRegisitBusinessScope)
try:
for licensefile in item['Company_business_img']:
licensefile['main_id'] = get_mainid(pre="LicenseFile")
licensefile['company_business_id'] = item['main_id']
write(licensefile, CompanyRegisitLicenseFile)
except:
pass
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="SnoContent")
item['company_regisit_id'] = main_id
write(item, CompanyRegisitServiceSonContent)
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['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)
for item in form['CompanyRegisitFileZip']:
item['main_id'] = get_mainid(pre="FileZip")
item['company_regisit_id'] = main_id
write(item, CompanyRegisitFileZip)
for item in form['CompanyProviderInfo']:
provider_regisit_id = get_mainid(pre="ProviderInfo")
item['main_id'] = provider_regisit_id
item['company_regisit_id'] = main_id
write(item, CompanyProviderInfo)
for t in item['CompanyProviderAndAllContent']:
t['main_id'] = get_mainid(pre="ProviderAllContent")
t['provider_regisit_id'] = provider_regisit_id
write(t, CompanyProviderAndAllContent)
for t in item['CompanyProviderSonContent']:
t['main_id'] = get_mainid(pre="ProviderSonContent")
t['provider_regisit_id'] = provider_regisit_id
write(t, CompanyProviderSonContent)
for t in item['CompanyProviderCustomers']:
t['main_id'] = get_mainid(pre="ProviderCustomers")
t['provider_regisit_id'] = provider_regisit_id
write(t, CompanyProviderCustomers)
for t in item['CompanyProviderContent']:
t['main_id'] = get_mainid(pre="ProviderContent")
t['provider_regisit_id'] = provider_regisit_id
write(t, CompanyProviderContent)
backinfo = {'status': status, 'message': message, 'submit': form}
return jsonify(backinfo)
def video_write():
"""
:param:
{
"video":{
"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":[
"",""
]
}
:return:
"""
form = request.json
video_update_time = datetime.now()
main_id = get_mainid(pre="videoInfo")
form["video"]["main_id"] = main_id
form["video"]["video_update_time"] = video_update_time
# video = VideoInfo(form["video"])
video = VideoInfo()
video.set_attrs(form["video"])
# 写入视频信息
# 视频和标签绑定
for item in form["labels"]:
if (item[:2] == 'al'):
advancedLabel = AdvancedLabel.query.filter(
AdvancedLabel.al_uid == item).first()
video.al_labels.append(advancedLabel)
else:
videoLabels = VideoLabels.query.filter(
VideoLabels.main_id == item).first()
video.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.files.append(file)
db.session.add(video)
db.session.commit()
data = {'status': 200, 'message': '视频内容写入成功'}
return jsonify(data)
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)
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)
