#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
@Copyright (C) ansjer cop Video Technology Co.,Ltd.All rights reserved.
@AUTHOR: ASJRD018
@NAME: langer
@software: PyCharm
@DATE: 2019/6/4 11:44
@Version: python3.6
@MODIFY DECORD:ansjer dev
@file: LangArea.py
@Contact: chanjunkai@163.com
"""
import json
from django.http import HttpResponse
from django.views.generic import TemplateView
from django.views.decorators.csrf import csrf_exempt
from django.utils.decorators import method_decorator
from object.ResponseObject import ResponseObject
from django.contrib.auth.hashers import make_password, check_password
from model.models import UserModel, LangSetModel, LangAreaModel, LangValModel, LangKeyModel, LangKeyClassModel, \
SearchToolBlock, SearchToolKeyModel, LangLocationModel
import time
from object.TokenObject import TokenObject
from django.http import StreamingHttpResponse
class LangAreaView(TemplateView):
def post(self, request, *args, **kwargs):
request.encoding = 'utf-8'
operation = kwargs.get('operation', None)
request_dict = json.loads(request.body.decode('utf-8'))
return self.validate(request_dict, operation)
def get(self, request, *args, **kwargs):
request.encoding = 'utf-8'
request_dict = request.GET
operation = kwargs.get('operation', None)
return self.validate(request_dict, operation)
def validate(self, request_dict, operation):
response = ResponseObject()
token = request_dict.get('token', None)
tko = TokenObject(token)
if tko.code == 0:
userID = tko.userID
user_qs = UserModel.objects.filter(id=userID, username='admin')
if not user_qs.exists():
return response.json(403)
if operation == 'add':
return self.do_add(request_dict, response)
elif operation == 'update':
return self.do_update(request_dict, response)
elif operation == 'delete':
return self.do_delete(request_dict, response)
elif operation == 'query':
return self.do_query(request_dict, response, userID)
elif operation == 'export':
return self.do_export(request_dict, response, userID)
else:
return response.json(414)
else:
return response.json(tko.code)
def do_add(self, request_dict, response):
lang = request_dict.get('lang', None)
if lang:
nowTime = int(time.time())
create_dict = {
'lang': lang,
'addTime': nowTime,
'updTime': nowTime
}
try:
LangAreaModel.objects.create(**create_dict)
except Exception as e:
return response.json(404, repr(e))
else:
return response.json(0)
else:
return response.json(414)
def do_update(self, request_dict, response):
lang = request_dict.get('lang', None)
id = request_dict.get('id', None)
nowTime = int(time.time())
update_dict = {
'lang': lang,
'updTime': nowTime
}
try:
LangAreaModel.objects.filter(id=id).update(**update_dict)
except Exception as e:
return response.json(404, repr(e))
else:
return response.json(0)
def do_delete(self, request_dict, response):
id = request_dict.get('id', None)
try:
LangAreaModel.objects.filter(id=id).delete()
except Exception as e:
return response.json(404, repr(e))
else:
return response.json(0)
def do_query(self, request_dict, response, userID):
user_qs = UserModel.objects.filter(id=userID, username='admin')
if not user_qs.exists():
return response.json(403)
la_qs = LangAreaModel.objects.filter().values('lang', 'id')
return response.json(0, list(la_qs))
def do_export(self, request_dict, response, userID):
print("进来了")
id = request_dict.get('id', None)
type = request_dict.get('type', None)
# key_list = LangKeyModel.objects.filter().values_list('word_key', flat=True)
print('id = ' + id)
langType = (1, 3, 5, 7)
if type == 'avss':
langType = (2, 3, 6, 7)
elif type == 'link_ios' or type == 'link_android':
langType = (4, 5, 6, 7)
en_qs = LangKeyModel.objects.filter(langvalmodel__la__id=20, type__in=langType).values('word_key',
'langvalmodel__word_val')
en_kv = {}
for e in en_qs:
en_kv[e['word_key']] = e['langvalmodel__word_val']
content = ''
if type == 'ios' or type == 'link_ios':
res_qs = LangKeyModel.objects.filter(langvalmodel__la__id=id, type__in=langType). \
values('word_key', 'langvalmodel__word_val')
res = {}
for r in res_qs:
print(r['langvalmodel__word_val'])
if r['langvalmodel__word_val']:
res[r['word_key']] = r['langvalmodel__word_val']
elif en_kv[r['word_key']]:
res[r['word_key']] = en_kv[r['word_key']]
for l in res:
content_val = res[l].replace('"', '\'')
content = content + '"' + l + '"="' + content_val + '";\n'
elif type == 'android' or type == 'link_android':
res_qs = LangKeyModel.objects.filter(langvalmodel__la__id=id, type__in=langType). \
values('word_key', 'langvalmodel__word_val').order_by('addTime')
res = {}
for r in res_qs:
print(r['langvalmodel__word_val'])
if r['langvalmodel__word_val']:
res[r['word_key']] = r['langvalmodel__word_val']
elif en_kv[r['word_key']]:
res[r['word_key']] = en_kv[r['word_key']]
for l in res:
lk = l
lk = lk.replace('.', '_')
lk = lk.replace('\\n', '_')
lk = lk.replace('“', '_')
lk = lk.replace('”', '_')
lk = lk.replace(' ', '_')
lk = lk.replace('\\\'', '_')
lk = lk.replace('\'', '_')
lk = lk.replace('\\', '_')
lk = lk.replace('!', '_')
lk = lk.replace('’', '_')
lk = lk.replace('...', '_')
lk = lk.replace('…', '_')
lk = lk.replace(':', '_')
lk = lk.replace('：', '_')
lk = lk.replace('(', '_')
lk = lk.replace(')', '_')
lk = lk.replace('?', '_')
lk = lk.replace(',', '_')
lk = lk.replace('-', '_')
lk = lk.replace('%', '_')
lk = lk.replace(';', '_')
lk = lk.replace('‘', '_')
lk = lk.replace('&', '&')
# 正则表达式
# re.sub("[a-z]+", "$", "123abc78ab9cdeg00t8")
content_val = res[l].replace("'", "\\'")
content_val = content_val.replace('"', '\\"')
content_val = content_val.replace('&', '&')
content = content + '' + content_val + '\n'
elif type == 'avss':
content = self.do_download_avss(id)
elif type == 'new_searchTool':
content = self.do_download_SearchTool(id, 0)
elif type == 'old_searchTool':
content = self.do_download_SearchTool(id, 1)
response = StreamingHttpResponse(content)
response['Content-Type'] = 'application/octet-stream'
response['Content-Disposition'] = 'attachment;filename="lang.txt"'
return response
return response.json(0, res)
def do_download_avss(self, id):
content = ''
en_result = self.get_area_language(20)
target_result = self.get_area_language(id)
if target_result:
content += '\n'
# keys = result.keys()
keys = en_result.keys()
for key in keys:
content += '\n'
content += key
content += '\n'
messages = None
if target_result.__contains__(key):
messages = target_result[key]
else:
messages = en_result[key]
messageKeys = en_result[key].keys()
for messageKey in messageKeys:
message = None
if messages.__contains__(messageKey):
message = messages[messageKey]
else:
message = en_result[key][messageKey]
# message = messages[messageKey]
content += '\n'
content += ''
content += message['source']
content += '\n'
content += ''
translation = message['translation']
# if translation is None or translation == '':
# content += '23333'
# else:
content += translation
content += '\n'
locations = message['locations']
print(message)
for location in locations:
if location['filename'] != '':
content += '\n'
content += '\n'
content += '\n'
content += ''
return content
else:
print('none')
return content
def get_area_language(self, id):
result = {}
lkc_qs = LangKeyModel.objects.filter(langvalmodel__la__id=id, type__in=(2, 3, 6, 7)).values('word_key',
'langkeyclassmodel__clazz__name',
'langvalmodel__word_val',
'langlocationmodel__filename',
'langlocationmodel__line')
for lkc in lkc_qs:
# print(lkc)
name = lkc['langkeyclassmodel__clazz__name']
hasClass = result.__contains__(name)
if hasClass is False:
result[name] = {}
source = lkc['word_key']
if not result[name].__contains__(source):
result[name][source] = {}
message = result[name][source]
message['source'] = source
message['translation'] = lkc['langvalmodel__word_val']
# location
locations = []
locations.append({'filename': lkc['langlocationmodel__filename'], 'line': lkc['langlocationmodel__line']})
message['locations'] = locations
print(result)
return result
def get_area_language_search(self, id):
result = {}
lkc_qs = LangKeyModel.objects.filter(langvalmodel__la__id=id, project__id=4).values('word_key',
'searchtoolkeymodel__bk__name',
'langvalmodel__word_val',
'langlocationmodel__filename',
'langlocationmodel__line')
for lkc in lkc_qs:
# print(lkc)
name = lkc['searchtoolkeymodel__bk__name']
hasClass = result.__contains__(name)
if hasClass is False:
result[name] = {}
source = lkc['word_key']
if not result[name].__contains__(source):
result[name][source] = {}
message = result[name][source]
message['source'] = source[(len(name) + 1):]
message['translation'] = lkc['langvalmodel__word_val']
# location
locations = []
locations.append({'filename': lkc['langlocationmodel__filename'], 'line': lkc['langlocationmodel__line']})
message['locations'] = locations
print(result)
return result
def get_avss_language(self, id):
if id == 18: # 简体中文
return 'zh_CN'
elif id == 19: # 繁体中文
return 'zh_HK'
elif id == 20: # 英文
return 'en_US'
elif id == 21: # 俄语
return 'ru'
elif id == 22: # 德语
return 'de'
elif id == 23: # 波兰语
return 'pl'
elif id == 24: # 法语
return 'fr'
elif id == 25: # 西班牙语
return 'es'
elif id == 26: # 日语
return 'ja'
elif id == 27: # 阿拉伯语
return 'ar'
elif id == 29: # 意大利语
return 'it'
elif id == 30: # 葡萄牙语
return 'pt'
elif id == 31: # 荷兰语
return 'nl'
elif id == 32: # 越南语
return 'vi'
else:
return 'en'
def do_download_SearchTool(self, id, searchtype):
content = ''
en_result = self.get_area_language_search(20)
print(en_result)
target_result = self.get_area_language_search(id)
if target_result:
content += '\n'
# keys = result.keys()
keys = en_result.keys()
for key in keys:
content += '\n'
content += key
content += '\n'
messages = None
if target_result.__contains__(key):
messages = target_result[key]
else:
messages = en_result[key]
messageKeys = en_result[key].keys()
for messageKey in messageKeys:
message = None
if messages.__contains__(messageKey):
message = messages[messageKey]
else:
message = en_result[key][messageKey]
# message = messages[messageKey]
content += '\n'
content += ''
content += message['source']
content += '\n'
content += ''
translation = message['translation']
# if translation is None or translation == '':
# content += '23333'
# else:
content += translation
content += '\n'
locations = message['locations']
print(message)
for location in locations:
if location['filename'] != '':
content += '\n'
content += '\n'
content += '\n'
content += ''
return content
else:
print('none')
return content
class exportLangView(TemplateView):
def post(self, request, *args, **kwargs):
request.encoding = 'utf-8'
request_dict = json.loads(request.body.decode('utf-8'))
return self.validate(request_dict)
def get(self, request, *args, **kwargs):
request.encoding = 'utf-8'
request_dict = request.GET
return self.validate(request_dict)
def validate(self, request_dict):
# 得到即将下载文件的路径和名称
response = StreamingHttpResponse('123l4kjlkfjlksadjlfksdajlf')
response['Content-Type'] = 'application/octet-stream'
response['Content-Disposition'] = 'attachment;filename="lang.txt"'
return response