def invitation_customer_delete(): ''' { "main_id":"" } :return: ''' status = 200 message = '邀请人删除成功!' form = request.json haveInvitationCustomer = read("main_id", form['main_id'], InvitationCustomer) if haveInvitationCustomer: info = haveInvitationCustomer[0].serialize try: delete(haveInvitationCustomer[0]) except: status = 400 message = '外键约束!' info = '邀请人删除失败!' else: status = 400 message = '邀请人不存在!' info = '邀请人删除失败!' info = { 'status': status, 'message': message, 'info': info } return jsonify(info)
def myplan_day_delete_all(): """ :createlabel:删除多条日计划的日计划 :param:POST传: form:value (状态值) main_id_all [] :return:我的当前日计划表 """ if request.method == 'POST': form = request.json if form['main_id_all'] == []: return jsonify({'message': "日计划删除成功"}), 200, { "ContentType": "application/json" } else: delete_s = [] for x in form['main_id_all']: data = read('main_id', x, MyPlan_DayPlan_Notes_Model)[0] delete_s.append(data) print(delete_s) delete(delete_s) data = { 'message': "日计划多条删除成功!", } return jsonify(data), 200, {"ContentType": "application/json"}
def sell_process_delete(): ''' { "main_id":"" } :return: ''' status = 200 message = '尽调流程内容删除成功!' form = request.json haveSellProcess = read("main_id", form['main_id'], SellProcess) if haveSellProcess: info = haveSellProcess[0].serialize try: delete(haveSellProcess[0]) except: status = 400 message = '外键约束!' info = '尽调流程内容删除失败!' else: status = 400 message = '尽调流程不存在!' info = '尽调流程内容删除失败!' info = { 'status': status, 'message': message, 'info': info } return jsonify(info)
def admin_shell_type_delete(): ''' :parmam { "main_id":"" } :return: ''' status = 200 message = '壳公司类型删除成功!' form = request.json haveShell = read("main_id", form['main_id'], ShellType) if haveShell: info = haveShell[0].serialize try: delete(haveShell[0]) except: status = 400 message = '外键约束!' info = '壳公司类型删除失败' else: status = 400 message = '壳公司类型不存在!' info = '壳公司类型删除失败' backinfo = {'status': status, 'message': message, 'info': info} return jsonify(backinfo)
def templatefile_delete(): ''' { "process_id":"", "file_link":"" } :return: ''' status = 200 message = '模板文件删除成功!' form = request.json haveTemplateFile = read("main_id", form['main_id'], TemplateFile) if haveTemplateFile: info = haveTemplateFile[0].serialize try: delete(haveTemplateFile[0]) except: status = 400 message = '外键约束!' info = '模板文件删除失败!' else: status = 400 message = '模板文件不存在!' info = '模板文件删除失败!' info = { 'status': status, 'message': message, 'info': info } return jsonify(info)
def basic_video_del(): """ :param 无参数 {video_id} :return: data = { 'status': 200, 'message': '用户取消观看视频成功', } """ form = request.json video_id = form['video_id'] user_id = g.user_message.user_id videoStatus = Video_And_User.query.filter( Video_And_User.user_id == user_id, Video_And_User.video_id == video_id).first() delete(videoStatus) data = { 'status': 200, 'message': '用户取消观看视频成功', } return jsonify(data)
def nb_team_del(): # 团队删除 form = request.json main_id = form["main_id"] lists = NbTeam.query.filter(NbTeam.main_id == main_id).first() delete(lists) data = {'status': 200, 'message': '团队删除成功!'} return jsonify(data)
def permission_user_del(): # 板块权限删除 form = request.json per = PermissionUser.query.filter( PermissionUser.main_id == form['main_id']).first() delete(per) data = {'status': 200, 'message': '板块权限更新成功'} return jsonify(data)
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 myplanweekdelete(): """ :createlabel:删除我的周计划 :param:POST传: form:value (状态值) main_id (一条计划main_id) :return:我的当前周计划表 """ if request.method == 'POST': form = request.json delete( read('main_id', form['main_id'], MyPlan_WeekPlan_Notes_Model)[0]) data = { 'message': "周计划删除成功", } return jsonify(data), 200, {"ContentType": "application/json"}
def company_kind_del(): ''' :param main_id 法人环节名Id :return: ''' status = 200 message = '金融种类删除成功' form = request.json companyRegisitKind = CompanyRegisitKind.query.filter( CompanyRegisitKind.main_id == form['main_id']).first() if companyRegisitKind: delete(companyRegisitKind) else: status = 400 message = '金融种类删除失败' backinfo = {'status': status, 'message': message} return jsonify(backinfo)
def provider_serviceContent_del(): ''' :param main_id 法人环节名Id :return: ''' status = 200 message = '服务商服务内容(总)删除成功' form = request.json allservice = CompanyProviderAllContent.query.filter( CompanyProviderAllContent.main_id == form['main_id']).first() if allservice: delete(allservice) else: status = 400 message = '服务商服务内容(总)删除失败' backinfo = {'status': status, 'message': message, 'submit': form} return jsonify(backinfo)
def company_legalperson_del(): ''' :param company_all_legal_id 法人环节名Id :return: ''' status = 200 message = '视频法人环节名删除成功' form = request.json legalperson = CompanyRegisitAllLegalPerson.query.filter( CompanyRegisitAllLegalPerson.main_id == form['main_id']).first() if legalperson: delete(legalperson) else: status = 400 message = '视频法人环节名删除失败' backinfo = {'status': status, 'message': message} return jsonify(backinfo)
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 company_info_del(): ''' :param {'main_id': ''} :return: ''' status = 200 message = '注册公司信息删除成功' form = request.json main_id = form['main_id'] companyRegisitBusinessScopes = read("company_regisit_id", main_id, CompanyRegisitBusinessScope) for item in companyRegisitBusinessScopes: licenseFiles = read("company_business_id", item.main_id, CompanyRegisitLicenseFile) for file in licenseFiles: delete(file) delete(item) companyRegisitServiceSonContent = read("company_regisit_id", main_id, CompanyRegisitServiceSonContent) companyInfoAndAllContent = read("company_regisit_id", main_id, CompanyInfoAndAllContent) companyInfoAndAllKind = read("company_regisit_id", main_id, CompanyInfoAndAllKind) companyRegisitSonLegalPerson = read("company_regisit_id", main_id, CompanyRegisitSonLegalPerson) companyInfoAndAllLegal = read("company_regisit_id", main_id, CompanyInfoAndAllLegal) companyRegisitFileZip = read("company_regisit_id", main_id, CompanyRegisitFileZip) companyRegisitGovenmentFile = read("company_regisit_id", main_id, CompanyRegisitGovenmentFile) companyProviderInfo = read("company_regisit_id", main_id, CompanyProviderInfo) if companyProviderInfo: companyProviderCustomers = read("provider_regisit_id", companyProviderInfo[0].main_id, CompanyProviderCustomers) companyProviderContent = read("provider_regisit_id", companyProviderInfo[0].main_id, CompanyProviderContent) companyProviderAndAllContent = read("provider_regisit_id", companyProviderInfo[0].main_id, CompanyProviderAndAllContent) companyProviderSonContent = read("provider_regisit_id", companyProviderInfo[0].main_id, CompanyProviderSonContent) for item in companyProviderSonContent: delete(item) for item in companyProviderAndAllContent: delete(item) for item in companyProviderContent: delete(item) for item in companyProviderCustomers: delete(item) companyRegisitInfo = read("main_id", main_id, CompanyRegisitInfo) for item in companyProviderInfo: delete(item) for item in companyRegisitGovenmentFile: delete(item) for item in companyRegisitGovenmentFile: delete(item) for item in companyRegisitFileZip: delete(item) for item in companyRegisitSonLegalPerson: delete(item) for item in companyInfoAndAllContent: delete(item) for item in companyInfoAndAllKind: delete(item) for item in companyInfoAndAllLegal: delete(item) for item in companyRegisitServiceSonContent: delete(item) for item in companyRegisitInfo: delete(item) backinfo = { 'status': status, 'message': message, } return jsonify(backinfo)