def showdata1(request): log('start showdata') # 权限检查 auth_data = {'request': request, 'net': False, 'login': True, 'perm': ''} resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) getListJson() # s_date = time.strftime('%Y-%m-%d', time.localtime()) stat_list_json.clear() stat_list = yything_stat.objects.all() for var in stat_list: dict_data = {"stat_id": var.stat_id, "stat_name": var.stat_name} stat_list_json.append(dict_data) req = { 'title': 'abcd' # , 'date': s_date , 'stat_list_json': stat_list_json, 'type_list_json': type_list_json, 'zycd_list_json': zycd_list_json, 'jjcd_list_json': jjcd_list_json, 'team_list_json': team_list_json, 'department_list_json': department_list_json } return render(request, 'trans_zl_helloworld/show_data.html', req)
def show_update(request, info_id): print('index show_update') # 权限检查 auth_data = { 'request': request, 'net': False, 'login': True, 'debug': False, 'perm': 'search_problem.add_info' } resp_auth = main.auth(auth_data) print('user : '******'code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) print('info_id = [' + str(info_id) + ']') for line in info.objects.filter(id=info_id): data = line.__dict__ data_channel_id = line.t_channel.code data_type_id = line.t_type.code print(data) channel_data = [] for line in info_channel.objects.all(): channel_data.append(line.__dict__) type_data = [] for line in info_type.objects.all(): type_data.append(line.__dict__) comments_data = [] for line in info.objects.filter(id=info_id): data = line.__dict__ for line_comments in line.t_comments.all(): comments_data.append({ "name": line_comments.name, "update_oper": line_comments.update_oper, "update_date": line_comments.update_date.strftime("%Y-%m-%d %H:%M:%S") }) comments_data.sort(key=lambda item: item.get('update_date'), reverse=True) resp = { "code": 0, "data": data, 'type': 'update', "stat": 0, "channel": channel_data, 'type_data': type_data, "data_channel_id": data_channel_id, "data_type_id": data_type_id, "comments_data": comments_data } return render(request, 'search_problem/show.html', resp)
def index(request): log('start index hello world') print(request.POST) # form 包含提交的数据 print(request.POST.get('zh')) # 权限检查 auth_data = {'request': request, 'net': False, 'login': False, 'perm': ''} resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) bank_list = [] s_date = time.strftime('%Y-%m-%d', time.localtime()) # data = config.objects.all() data = config.objects.filter(plat_name="V2核心系统") for line in data: if line.user == 'cib': bank_list.append({'bank_name': line.name_ch}) # print(bank_list) req = { 'title': '冻结控制查询', 'date': s_date, 'req': bank_list, } print(req) return render(request, 'trans_zl_helloworld/index.html', req)
def index(request): print('index myview home') # 权限检查 # resp_auth = main.auth(request, True, False, '') # if resp_auth[0] == False: # return render(request, 'alarm/resp.html', {"message": resp_auth[1]}) auth_data = {'request': request, 'net': False, 'login': False, 'perm': ''} resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) user = request.user # 调用数据中台API res = requests.post(url='http://' + request.META.get('HTTP_HOST') + '/' + 'data_api/oper/', data={"comm_i_user_first_name": user.first_name}) resp = json.loads(res.text) user_data = {} for line in resp.get('data'): user_data = line if user_data.get('is_authenticated') == True: user_id = user_data.get('first_name') else: user_id = '未登陆' req = {"user_id": user_id, "score": user_data.get('score')} for line in user_data.get('group_data'): if line.get('name') == '应用人员': return render(request, 'myview/index.html', req) return render(request, 'myview/index2.html', req)
def index(request): print('start index cloud_file') # 权限检查 auth_data = { 'request': request , 'net': False , 'login': True , 'debug': True , 'perm': '' } resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) # print(chardet(data)) file_path = request.GET.get('file_path') if file_path == None : file_path = '/' req = { 'title': 'cloud_file' , 'file_path': file_path } # print(req) return render(request, 'cloud_file/index.html', req)
def index(request): print('start index data_control') # 权限检查 auth_data = { 'request': request, 'net': False, 'login': True, 'debug': True, 'perm': 'make' } resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) plat_list = [{ 'plat_id': 'cib', 'plat_name': '核心系统' } # , {'plat_id': 'v3_cib', 'plat_name': 'V3核心系统'} ] bank_list = [] bank_list.clear() # V2核心数据载入 queryset_data1 = config.objects.filter(plat_id='cib') for line in queryset_data1: if line.name_ch[-4:] != '_CLJ': bank_list.append({ 'name': line.name, 'name_ch': line.name_ch, 'ip': line.ip, 'ver': 'V2' }) # V3核心数据载入 queryset_data2 = config_discovery.objects.filter(plat='v3_cib') for line in queryset_data2: queryset_data3 = config.objects.filter(plat_id='v3_cib', name_ch=line.bank_group) for line2 in queryset_data3: bank_list.append({ 'name': line.bank_id, 'name_ch': line.bank_name, 'ip': line2.ip, 'ver': 'V3' }) user = request.user req = { 'title': '数据文件载入', 'user_name': user.username, 'date': time.strftime('%Y%m%d', time.localtime()), 'bank_list': bank_list, 'plat_list': plat_list } # print(req) return render(request, 'data_control/index.html', req)
def show_update_comments_stat_update(request, info_id): print('index show_update_comments_stat_update') # 权限检查 auth_data = { 'request': request, 'net': False, 'login': True, 'debug': False, 'perm': '', 'perm_group': '知识库管理员' } resp_auth = main.auth(auth_data) print('user : '******'code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) r = info_comments.objects.get(id=request.POST.get('comments_id')) r_old = info_comments.objects.get(id=request.POST.get('comments_id')) r.i_stat = info_comments_stat.objects.get( code=request.POST.get('comment_stat_code')) r.save() try: r_old_stat_code = r_old.i_stat.code except: r_old_stat_code = 999 print(r.i_stat.code) if r_old_stat_code != 0 and r.i_stat.code == 0: # 积分计算 main.action_log( request, { "app_type": "search_problem", 'action_type': "comments", 'info_id': info_id, 'text': r.id, 'oper': r.update_oper }) if r_old_stat_code == 0 and r.i_stat.code != 0: # 积分计算 main.action_log( request, { "app_type": "search_problem", 'action_type': "comments_close", 'info_id': info_id, 'text': r.id, 'oper': r.update_oper }) resp = {"code": 0} return HttpResponse(json.dumps(resp), content_type="application/json")
def show(request): print('start index make') # 权限检查 auth_data = {'request': request, 'net': False, 'login': True, 'perm': ''} resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) req = {'title': '软件下发流程管理'} return render(request, 'rjxf_server/show.html', req)
def index(request): print('start index rota_day') # 权限检查 auth_data = {'request': request, 'net': False, 'login': True, 'perm': ''} resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) req = {'title': 'rota_day'} # print(req) return render(request, 'qq_data/index.html', req)
def cmdb_input(request): print('start cmdb_input index') # 权限检查 auth_data = { 'request': request, 'net': False, 'login': True, 'debug': True, 'perm': 'rjxf_make' } resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) # 所属产品 plat_info = [] for line in i_plat.objects.all(): plat_info.append({ 'plat_id': line.plat_ver.name + '-' + line.plat_id, 'plat_name': line.plat_ver.name + '-' + line.plat_id + '-' + line.plat_name }) # 所属服务器 sys_info = [] for line in i_app_server.objects.all(): sys_info.append({ 'id': line.ip + '-' + line.user, 'name': line.ip + '-' + line.user }) # 合作行 bank_info = [] for line in i_bank.objects.all(): bank_info.append({ 'id': line.name, 'name': line.name + '-' + line.name_ch }) req = { 'title': '运维对象配置', 'plat_info': plat_info, 'sys_info': sys_info, 'bank_info': bank_info } print(req) return render(request, 'cmdb/cmdb_input.html', req)
def show_update_close(request, info_id): print('index show_update_close') # 权限检查 auth_data = { 'request': request, 'net': False, 'login': True, 'debug': False, 'perm': '', 'perm_group': '知识库管理员' } resp_auth = main.auth(auth_data) print('user : '******'code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) r = info.objects.get(id=info_id) r_old = info.objects.get(id=info_id) r.t_close = info_close.objects.get(code=999) r.save() try: r_old_close_code = r_old.t_close.code except: r_old_close_code = 0 if r_old_close_code != 999 and r.t_close.code == 999: # 积分计算 if r.t_stat.stat_id == 1: main.action_log( request, { "app_type": "search_problem", 'action_type': "answer_close", 'info_id': info_id, 'oper': r.answer_oper }) main.action_log( request, { "app_type": "search_problem", 'action_type': "input_close", 'info_id': info_id, 'oper': r.input_oper }) resp = {"code": 0} return HttpResponse(json.dumps(resp), content_type="application/json")
def make(request): print('start index make') user = request.user print(user) # 权限检查 auth_data = { 'request': request, 'net': False, 'login': True, 'debug': True, 'perm': 'rjxf_server.add_flow' } resp_auth = main.auth(auth_data) print('user : '******'code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) file_list.clear() i = 1 for rjxf_line in ftp_path.objects.all(): print(rjxf_line) print(rjxf_line.ftp_id) # 多线程不增加 sleep 的情况下 expect 会出现异常 sleep(0.02) data = {'ftp_id': rjxf_line.ftp_id, 'ftp_pwd': rjxf_line.ftp_pwd} exec('thread{} = forThread_make(data)'.format(i)) exec('thread{}.start()'.format(i)) i += 1 x = 1 while x < i: exec('thread{}.join()'.format(x)) x += 1 s_date = time.strftime('%Y-%m-%d', time.localtime()) req = { 'title': '软件下发版本制作', 'date': s_date # , 'req': list_req , 'file_list': file_list, 'user_list': User.objects.all() } # print(req) return render(request, 'rjxf_server/make.html', req)
def showdata3(request): log('start showdata3') # zl # # 权限检查 auth_data = {'request': request, 'net': False, 'login': True, 'perm': ''} resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) res = requests.post(url='http://' + request.META.get('HTTP_HOST') + '/' + 'trans_zl_helloworld/abcd/boardsAPI', data=request.POST) resp = json.loads(res.text) return HttpResponse(json.dumps(resp), content_type="application/json")
def index(request): print('start index auth_control') # 权限检查 auth_data = { 'request': request, 'net': False, 'login': False, 'perm': 'make' } resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) req = {'title': 'auth_control'} # print(req) return render(request, 'auth_control/index.html', req)
def index(request): print('start index data_control') # 权限检查 auth_data = { 'request': request, 'net': False, 'login': True, 'debug': True, 'perm': '' } resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) plat_list = [{ 'plat_id': 'cib', 'plat_name': 'V2核心系统' } # , {'plat_id': 'v3_cib', 'plat_name': 'V3核心系统'} ] cmdb_data = config.objects.filter(plat_id='cib') bank_list = [] bank_list.clear() for line in cmdb_data: if line.name_ch[-4:] != '_CLJ': bank_list.append({'name': line.name, 'name_ch': line.name_ch}) # for line in config.objects.filter(plat_id='v3_cib'): # if line.name_ch[-4:] != '_CLJ': # bank_list.append({ # 'name': line.name # , 'name_ch': line.name_ch # }) user = request.user req = { 'title': '数据文件载入', 'user_name': user.username, 'date': time.strftime('%Y%m%d', time.localtime()), 'bank_list': bank_list, 'plat_list': plat_list } # print(req) return render(request, 'data_control/index.html', req)
def upload_file(request): # 权限检查 auth_data = { 'request': request, 'net_sc': True, 'login': True, 'debug': True, 'perm': '' } resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: resp = resp_auth return HttpResponse(json.dumps(resp), content_type="application/json") file_pwd = os.getcwd() + '/static/app/search_problem/file/' file_obj = request.FILES.get('file', None) s_date = time.strftime('%Y-%m-%d-%H:%M:%S', time.localtime()) print(file_pwd) print(file_obj.name) print(file_obj.size) file_name = s_date + '-' + file_obj.name with open(file_pwd + file_name, 'wb') as f: for line in file_obj.chunks(): f.write(line) message = '上传[' + file_name + ']文件成功,大小[' + str(file_obj.size) + ']' code = 0 f.close() resp = { "code": code, "msg": message, "data": { "file_name": file_obj.name, "src": "/static/app/search_problem/file/" + file_name, "class": "layui-upload-img" # , "title": "building.png" } } # resp = { # "code": 0 # , "msg": "" # } return HttpResponse(json.dumps(resp), content_type="application/json")
def upload(request): file_obj = request.FILES.get('file', None) print(file_obj.name) print(request.GET.get('file_path')) # os.chdir(home_path + request.GET.get('file_path')) code = -1 # 权限检查 auth_data = { 'request': request , 'net_sc': True , 'login': True , 'debug': True , 'perm': '' } resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: resp = {"code": -1} return HttpResponse(json.dumps(resp), content_type="application/json") with open(home_path + request.GET.get('file_path') + file_obj.name, 'wb') as f: for line in file_obj.chunks(): f.write(line) code = 0 f.close() if code == 0 : r = info( file_name=file_obj.name , file_size=file_obj.size , update_oper=request.user.first_name , update_date=time.strftime('%Y-%m-%d %H:%M:%S', time.localtime()) , file_type='f' , file_path=request.GET.get('file_path') ) r.save() # code 为 0 表示上传文件成功 resp = { "code": code } # os.chdir(_work_path) return HttpResponse(json.dumps(resp), content_type="application/json")
def index(request): print('start cmdb index') # 权限检查 auth_data = { 'request': request, 'net': False, 'login': True, 'perm': 'rjxf_make' } resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) req = {'title': 'CMDB配置操作', 'req': list_req} # print(req) return render(request, 'cmdb/index.html', req)
def config_bank(request): print('start config_bank') # 权限检查 auth_data = { 'request': request, 'net': False, 'login': True, 'perm': 'rjxf_make' } resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) req = {'title': '多法人租户配置', 'req': list_req} # print(req) return render(request, 'cmdb/config_bank.html', req)
def cmdb_plat_info(request): print('start cmdb_plat_info index') # 权限检查 auth_data = { 'request': request, 'net': False, 'login': True, 'debug': True, 'perm': 'rjxf_make' } resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) req = {'title': 'CMDB配置操作'} # print(req) return render(request, 'cmdb/cmdb_plat_info.html', req)
def show(request): print('start index show') # 权限检查 auth_data = {'request': request, 'net': False, 'login': True, 'perm': ''} resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) start_date = datetime.datetime.now() end_date = datetime.datetime.now() for line in range(7): start_date -= datetime.timedelta(days=1) req = { 'title': 'show', 'start_date': start_date.strftime("%Y-%m-%d"), 'end_date': end_date.strftime("%Y-%m-%d") } # print(req) return render(request, 'qq_data/show.html', req)
def do_POST(self): #POST request: Relay it to auth script content_length = int(self.headers['Content-Length']) #Get the payload payload_raw = self.rfile.read(content_length) payload = json.loads(payload_raw.decode('utf8')) try: #Get the operation number op = int(payload["op"]) except TypeError: #NaN, inform the requester and send help message self.sendHelp(400, 'Invalid payload.\n') return try: response = None if op == 0: #Authenticate response = main.auth(payload["name"], payload["password"]) elif op == 1: #Sign up response = main.signUp(payload["name"], payload["password"]) else: #Invalid operation self.sendHelp(501, 'Operation not found.\n') return if response == 0: #Signed up correctly self.send(200, 'Signed up successfully. Please sign in now.') elif response == 1: #Authentication error self.send(403, 'Username or password incorrect.') elif response == 2: #Username is taken self.send(403, 'That name is already taken.') elif response == 3: #Password is too common self.send( 403, 'The password cant be in the 10.000 most used passwords list.' ) else: #Authenticated correctly self.send( 200, 'Signed in successfully. Session token:\n' + response) except Exception as e: #??? I dont even know why I put this in self.sendHelp(400, 'Invalid payload.\n') return
def index(request): print('start index rota_day') search_type = request.GET.get('type') bank_info_list = [] if search_type == "get": search_type = "get" elif search_type == "search": search_type = "search" # 调用数据中台API res = requests.post(url='http://' + request.META.get('HTTP_HOST') + '/' + 'data_api/cmdb_info/', data={'comm_i_info_stat': 0}) resp = json.loads(res.text) for line in resp.get('comm_i_c_config_bank'): # yhdm=line.get('yhdm') # name=line.get('name') # name_ch=line.get('name_ch') # bank_msg=str(yhdm)+'_'+str(name)+'_'+str(name_ch) bank_info_list.append(line) else: search_type = "get" # 权限检查 auth_data = {'request': request, 'net': False, 'login': False, 'perm': ''} resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) req = { 'title': '系统成功率', 'search_type': search_type, 'bank_info_list': bank_info_list } # print(req) return render(request, 'rate_system/index.html', req)
def index(request): print('start index') # 权限检查 auth_data = { 'request': request , 'net': False , 'login': False , 'perm': '' } resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) s_date = time.strftime('%Y-%m-%d', time.localtime()) list_req = [{'bank_id': 'v3_cib', 'bank_name': 'V3核心'}] req = { 'title': 'V3核心日结查询' , 'date': s_date , 'req': list_req } return render(request, 'chkpcl_server/index.html', req)
def index(request): print('start index trans_dlzf') user = request.user print(user) # 权限检查 auth_data = {'request': request, 'net': True, 'login': False, 'perm': ''} resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) print(user.has_perm('myApp')) s_date = time.strftime('%Y-%m-%d', time.localtime()) # input = 'topfe_server' # f = open('/home/insp_ap/inspect/src/switch/' + input + '/config.ini', 'r', encoding='gbk') list_req = [] resp = shell.getKey( 'check[run_command:user:./trans_search/get_bank_info.sh]', _ip, _port) try: info = resp[1].decode('GBK').split('\n') except: info = resp[1] for line_info in info: if line_info.startswith('RETURN:') == True: list_req.append({'bank_id': line_info.split(':')[1].strip()}) # for line in f.readlines(): # line = line.rstrip('\n') # if line.startswith('#') != True: # # print(line.split(':')[1] + '_' + line.split(':')[0]) # list_req.append({'bank_id': line.split(':')[1], 'bank_name': line.split(':')[0]}) # print(list_req) req = {'title': '代理支付交易查询', 'date': s_date, 'req': list_req} # print(req) return render(request, 'trans_dlzf/index.html', req)
def add_data(request): log('start add_data') # 权限检查 auth_data = {'request': request, 'net': False, 'login': True, 'perm': ''} resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) getListJson() s_date = time.strftime('%Y-%m-%d', time.localtime()) req = { 'title': 'abcd', 'date': s_date, 'stat_list_json': stat_list_json, 'team_list_json': team_list_json, 'department_list_json': department_list_json, 'person_list_json': person_list_json, 'bank_list_json': bank_list_json } return render(request, 'trans_zl_helloworld/add_data.html', req)
def new(request): print('index new') type = request.GET.get('type') print('type = [' + str(type) + ']') # 权限检查 auth_data = { 'request': request, 'net': False, 'login': True, 'debug': False, 'perm': 'rjxf_server.view_flow' } resp_auth = main.auth(auth_data) # print('user : '******'code') == False: return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) t1 = time.time() # 调用数据中台API # 取人员名单 res = requests.post(url='http://' + request.META.get('HTTP_HOST') + '/' + 'data_api/oper/', data={}) resp = json.loads(res.text) t2 = time.time() t = (t2 - t1) * 1000 print('oper use ' + str(t)) # 取合作行名 data_api/cib_qd_count/ res2 = requests.post(url='http://' + request.META.get('HTTP_HOST') + '/' + 'data_api/cmdb_info/', data={"comm_s_plat_id": "cib"}) resp2 = json.loads(res2.text) t3 = time.time() t = (t3 - t2) * 1000 print('cmdb_info use ' + str(t)) # 调用数据中台API res3 = requests.post(url='http://' + request.META.get('HTTP_HOST') + '/' + 'data_api/search_problem/', data={"comm_i_info_stat": 0}) resp3 = json.loads(res3.text) t4 = time.time() t = (t4 - t3) * 1000 print('search_problem use ' + str(t)) req = { 'title': '小鲲知道', 'oper': resp.get('data'), 'bank_info': resp2.get('comm_i_c_config_bank'), 'comm_i_info_channel': resp3.get('comm_i_info_channel'), 'comm_i_info_type': resp3.get('comm_i_info_type'), 'type': type } print('ok') return render(request, 'search_problem/new.html', req)
def spotify_login(): auth(request.url) return request.url
def post(request): print('start post') os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.ZHS16GBK' os.environ['ORACLE_HOME'] = '/oracle/orasoft/product/11.2.0/dbhome_1' # req = json.loads(sys.argv[1]) # req = sys.argv[1] print(request.POST.get('recid')) print(request.POST) # httpResp = "保存成功,感谢您对知识库的完善:)" auth_data = { 'request': request # , 'net_sc': True , 'login': True, 'debug': False, 'perm': '' } resp_auth = main.auth(auth_data) if resp_auth.get('code') == False: resp = {"msg": '风险控制,生产环境不得保存信息,请谅解:)'} return HttpResponse(json.dumps(resp), content_type="application/json") def UpdateKey(a, b): if a in request.POST: print("ok") try: if request.POST.get(a) == '': print('UpdateKey try row ' + a + ':' + str(b)) return row.get(b) else: print('UpdateKey except req ' + a + ':' + str(b)) return request.POST.get(a).replace('\xa0', ' ').replace('\u202c', ' ') # return request.POST.get(a) except: print('UpdateKey except ' + a + ':' + str(b)) return '' def runsql(input_cursor, input_sql, input_data): try: input_cursor.execute(input_sql, input_data) conn.commit() input_cursor.close() return "保存成功,感谢您对知识库的完善:)" except cx_Oracle.DatabaseError as msg: return '处理方式目前最大内容长度为:3000字节</br>' + str(msg) except UnicodeEncodeError as msg: return '检测到异常的字符,请联系开发人员处理</br>' + str(msg) cursor.close() conn = cx_Oracle.connect(main.getConnInfo()) cursor = conn.cursor() if request.POST.get('recid') == '0': print('insert data') insert_cursor = conn.cursor() sql = 'insert into MYVIEW_INFO_DATA(recid,text,proc,username,tel,mail,input,setdate) values(seq_info.nextval,:text,:proc,:username,:tel,:mail,:input,:setdate)' data = { "text": request.POST.get('text'), "proc": request.POST.get('proc').replace('\xa0', ' '), "username": request.POST.get('username'), "tel": request.POST.get('tel'), "mail": request.POST.get('mail'), "input": request.POST.get('input'), "setdate": request.POST.get('setdate') } httpResp = runsql(insert_cursor, sql, data) else: sql = 'select * from myview_info_data where recid = ' + request.POST.get( 'recid') cursor.execute(sql) row = cursor.fetchone() print('update recid ' + str(row[0])) update_cursor = conn.cursor() sql = 'update MYVIEW_INFO_DATA set text=:text, proc=:proc, username=:username, tel=:tel, mail=:mail, input=:input, setdate=:setdate where recid = ' + str( row[0]) print(sql) data = { "text": UpdateKey('text', 1), "proc": UpdateKey('proc', 2), "username": UpdateKey('username', 3), "tel": UpdateKey('tel', 4), "mail": UpdateKey('mail', 5), "input": UpdateKey('input', 6), "setdate": UpdateKey('setdate', 7) } print(data) # update_cursor.execute(sql, data) httpResp = runsql(update_cursor, sql, data) print('msg = [' + str(httpResp) + ']') return HttpResponse(json.dumps({"msg": str(httpResp)}), content_type="application/json")
def new_submit(request): print('index new_submit') # 权限检查 auth_data = { 'request': request, 'net': False, 'net_sc': True, 'login': True, 'debug': False, 'perm': 'rjxf_server.view_flow' } resp_auth = main.auth(auth_data) # print('user : '******'code') == False: # return render(request, 'alarm/resp.html', {"message": resp_auth.get('msg')}) resp = {"code": resp_auth.get('code'), "msg": resp_auth.get('msg')} return HttpResponse(json.dumps(resp), content_type="application/json") input_data = json.loads(request.POST.get('input_data')) fwb_data = request.POST.get('fwb_data') fwb_text_answer = request.POST.get('fwb_text_answer') user = request.user print(input_data) print(fwb_data) if request.POST.get('type') == 'input': stat = 1 answer_date = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime()) else: stat = 0 answer_date = None print('type = [' + request.POST.get('type') + ']') print(fwb_text_answer) if fwb_text_answer is None: fwb_text_answer = '' if input_data.get('comm_i_info_channel') is None: info__t_channel = None else: info__t_channel = info_channel.objects.get( code=input_data.get('comm_i_info_channel')) if input_data.get('comm_i_info_type') is None: info__t_type = None else: info__t_type = info_type.objects.get( code=input_data.get('comm_i_info_type')) problem_answer = BeautifulSoup(fwb_text_answer, 'html.parser') r = info(title=input_data.get('title'), trans_code=input_data.get('trans_code'), trans_err=input_data.get('trans_err'), problem_info=fwb_data, problem_answer=fwb_text_answer, problem_answer_txt=problem_answer.get_text(), input_oper=user.first_name, answer_oper=input_data.get('answer_oper'), bank_id=input_data.get('bank_id'), bank_oper=input_data.get('bank_oper'), problem_source=input_data.get('problem_source'), input_date=time.strftime('%Y-%m-%d %H:%M:%S', time.localtime()), update_date=time.strftime('%Y-%m-%d %H:%M:%S', time.localtime()), answer_date=answer_date, t_stat=info_stat.objects.get(stat_id=stat), t_channel=info__t_channel, t_type=info__t_type, info_check_flag=0, info_check_update=0, count_search=0, count_chick=0) code = 0 msg = '' try: r.save() code = 0 msg = '感谢您对知识库的完善:)' # 操作记录 a = action(type=action_type.objects.get(code=3), text=str(r.id), oper=request.user.first_name, date=time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())) a.save() # 积分计算 main.action_log(request, { "app_type": "search_problem", 'action_type': "input", 'info_id': r.id }) if stat == 1: main.action_log( request, { "app_type": "search_problem", 'action_type': "answer", 'info_id': r.id, 'oper': r.answer_oper }) except Exception as msg_info: code = -1 print(repr(msg_info)) print(msg_info) print(msg_info.args[0]) if msg_info.args[0] == 1406: msg = '录入失败了,答案的内容超出长度限制,入库失败了哟~~~' elif msg_info.args[0] == 1062: msg = '录入失败了,可能该标题已存在,无法重复入库~' else: msg = '录入失败了。。。<br>报错信息:' + str(msg_info) # msg = '录入失败了~' + str(msg_info) resp = {"code": code, "msg": msg} return HttpResponse(json.dumps(resp), content_type="application/json")