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)