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)