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 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 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 buy_company_find_one_update(): ''' 查看收购公司详情 :parmam {"main_id": ""} :return: ''' status = 200 message = '收购公司信息查找成功' form = request.json buyCompanys = read("main_id", form["main_id"], BuyCompany) info = [] for item in buyCompanys: t = item.serialize t['type_name'] = ShellType.query.filter(ShellType.main_id == t['type_id']).first().type_name t['update_time'] = str(t['update_time']) info.append(t) if buyCompanys == []: status = 400 message = '收购公司信息不存在' info = { 'status': status, 'message': message, 'info': info } return jsonify(info)
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_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 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 sell_company_find_one_update(): ''' 查看装让公司详情 :parmam {"main_id": ""} :return: ''' status = 200 message = '转让公司信息查找成功' form = request.json sellCompany = read("main_id", form["main_id"], SellCompany) info = [] for item in sellCompany: t = item.serialize t['type_name'] = ShellType.query.filter(ShellType.main_id == t['type_id']).first().type_name t['company_buy_time'] = str(t['company_buy_time']) t['registration_time'] = str(t['registration_time']) t['last_confirmation_time'] = str(t['last_confirmation_time']) info.append(t) if sellCompany == []: status = 400 message = '转让公司信息不存在' info = { 'status': status, 'message': message, 'info': info } 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 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 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 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 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 men_keep_label_top(): form = request.json main_id = form['main_id'] value = int(form['value']) if value == 1: ManKeepLabels = read("main_id", main_id, ManKeepLabel)[0] ManKeepLabels.grade = ManKeepLabels.grade + 1 db.session.commit() else: ManKeepLabels = read("main_id", main_id, ManKeepLabel)[0] ManKeepLabels.grade = ManKeepLabels.grade - 1 db.session.commit() data = { 'status': 200, 'message': '营销文章标签次序操作成功', } return jsonify(data)
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 company_info_findall(): ''' :param label_main_id :return: ''' status = 200 message = '注册公司信息全部查询成功' form = request.json companyInfoAndAllKinds = read("company_kind_id", form['label_main_id'], CompanyInfoAndAllKind) info = [] for item in companyInfoAndAllKinds: company_regisit_id = item.company_regisit_id companyRegisitInfo = read("main_id", company_regisit_id, CompanyRegisitInfo)[0] myjson = companyRegisitInfo.serialize business_scope = read("company_regisit_id", company_regisit_id, CompanyRegisitBusinessScope) all_content_id = read("company_regisit_id", company_regisit_id, CompanyInfoAndAllContent) son_content_id = read("company_regisit_id", company_regisit_id, CompanyRegisitServiceSonContent) myjson['businessScope'] = [] myjson['allContent'] = [] myjson['sonContent'] = [] for bs in business_scope: businessInfo = bs.serialize licenseFiles = read("company_business_id", businessInfo['main_id'], CompanyRegisitLicenseFile) licenseFile = [file.serialize for file in licenseFiles] businessInfo['Company_business_img'] = licenseFile myjson['businessScope'].append(businessInfo) for all_id in all_content_id: try: all_content = read("main_id", all_id.company_allcontent_id, CompanyRegisitServiceAllContent)[0] myjson['allContent'].append(all_content.serialize) except IndexError: myjson['allContent'] = [] for son_id in son_content_id: myjson['sonContent'].append(son_id.serialize) info.append(myjson) # if(info['businessScope']['status'] == 1): # info = sorted(info, key=lambda x: x['grade'], reverse=True) backinfo = { 'submit': info, 'status': status, 'message': message, 'count': len(info) } return jsonify(backinfo)
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 user_message(): if request.method == 'POST': form = request.json if form: value = read('user_id', form['user_id'], UserAndOA)[0] else: value = g.user_message list = value.serialize team_list = [] for x in value.team_value: team_list.append(x.serialize) list['team'] = team_list data = {'status': 200, 'message': 'ok', 'user_message': list} data = json.dumps(data, default=lambda o: o.__dict__) return data, 200, {"ContentType": "application/json"}
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 sell_company_find_one_x(): ''' 列举出转让公司的信息和达成转让条件的人 :parmam {"main_id": ""} :return: ''' status = 200 message = '转让公司信息查找成功' form = request.json sellCompany = read("main_id", form["main_id"], SellCompany) info = [] for item in sellCompany: t = item.serialize t['type_name'] = ShellType.query.filter(ShellType.main_id == t['type_id']).first().type_name if t['legal_person_tel_num'] == 11: t['legal_person_tel_num'] = t['legal_person_tel_num'][:3] + '*' * 5 + t['legal_person_tel_num'][-3:] t['docker_tel_num'] = t['docker_tel_num'][:3] + '*' * 5 + t['docker_tel_num'][-3:] t['company_buy_time'] = str(t['company_buy_time']) t['registration_time'] = str(t['registration_time']) t['last_confirmation_time'] = str(t['last_confirmation_time']) sell_users = InvitationCustomer.query.filter(form["main_id"] == InvitationCustomer.sell_id).all() users_li = [] for u in sell_users: user = u.serialize if user['status'] == 1: users_li.append(user) t['sell_users'] = users_li info.append(t) if sellCompany == []: status = 400 message = '转让公司信息不存在' info = { 'status': status, 'message': message, 'info': info } return jsonify(info)
def sell_company_find_one_l(): ''' 查看装让公司详情 :parmam {"main_id": ""} :return: ''' status = 200 message = '转让公司信息查找成功' form = request.json sellCompany = read("main_id", form["main_id"], SellCompany) info = [] for item in sellCompany: t = item.serialize t['type_name'] = ShellType.query.filter(ShellType.main_id == t['type_id']).first().type_name if t['legal_person_tel_num'] == 11: t['legal_person_tel_num'] = t['legal_person_tel_num'][:3] + '*' * 5 + t['legal_person_tel_num'][-3:] t['docker_tel_num'] = t['docker_tel_num'][:3] + '*' * 5 + t['docker_tel_num'][-3:] t['company_buy_time'] = str(t['company_buy_time']) t['registration_time'] = str(t['registration_time']) t['last_confirmation_time'] = str(t['last_confirmation_time']) if t['company_name_mini']: t['name'] = t['name'].replace(t['company_name_mini'], '') t['credit_code'] = t['credit_code'][:-4] + '****' del t['company_detail_address'] sell_users = InvitationCustomer.query.filter(form["main_id"] == InvitationCustomer.sell_id).all() users_li = [] for u in sell_users: users_li.append(u.serialize) t['sell_users'] = users_li info.append(t) if sellCompany == []: status = 400 message = '转让公司信息不存在' info = { 'status': status, 'message': message, 'info': info } return jsonify(info)
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 sell_process_findall(): ''' 查找某样进度的所有流程情况 :parmam { "main_id":"" # 出售流程公司ID } :return: ''' status = 200 message = '进度流程查找成功' form = request.json sellProcess = read("sell_id", form["main_id"], SellProcess) sellProcess = [item.serialize for item in sellProcess] info = { 'status': status, 'message': message, 'info': sellProcess } return jsonify(info)
def invitation_customer_findall(): ''' 查找全部邀约人 :parmam { "main_id":"" } :return: ''' status = 200 message = '邀请人查找成功' form = request.json invitationCustomer = read("sell_id", form["main_id"], InvitationCustomer) invitationCustomer = [item.serialize for item in invitationCustomer] info = { 'status': status, 'message': message, 'info': invitationCustomer } return jsonify(info)
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 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)