def insert_statistics_amount():
# 计算昨天日期
print('开始了')
today = datetime.datetime.now()
offset = datetime.timedelta(days=-1)
yesterday = (today + offset).strftime('%Y-%m-%d')
# 查询昨日造件数量
piece_sql = MysqlHandle.get_xml_sql(xml_path='select_sql',
xml_tag='select',
xml_id='select_chart_piece')
piece_data = MysqlHandle.select_mysql_data(
piece_sql.format(create_time=yesterday))
piece_number = piece_data[0].get('number')
print('piece_data---->', piece_data)
# 查询昨日上传包数量
app_sql = MysqlHandle.get_xml_sql(xml_path='select_sql',
xml_tag='select',
xml_id='select_chart_app')
app_data = MysqlHandle.select_mysql_data(
app_sql.format(create_time=yesterday))
app_number = app_data[0].get('number')
print('app_number---->', app_number)
# 将数量插入到statistics_amount中
statistics_tuple = ((piece_number, 'PIECE'), (app_number, 'APP'))
statistics_sql = MysqlHandle.get_xml_sql(
xml_path='insert_sql',
xml_tag='insert',
xml_id='insert_into_statistics_data')
for inner in statistics_tuple:
tag = MysqlHandle.delete_update_insert_mysql_data(
statistics_sql.format(date_record=yesterday,
count=inner[0],
category=inner[1]))
print('tag----->', tag)
def IdNo(self):
try:
date = datetime.datetime.now().strftime('%m-%d')
month_day = ''.join(date.split('-'))
sql = MysqlHandle.get_xml_sql(xml_path='select_sql',
xml_tag='select',
xml_id='select_regions_code')
list = MysqlHandle.select_mysql_data(sql)
dict = list[0]
city_code = dict['regions_code']
key = '\d{18}|\d{17}X'
result = requests.get(
'http://sfz.uzuzuz.com/?region=%s&birthday=%s%s&sex=2&num=1' %
(city_code, self.year, month_day)).text
data = re.findall(key, result)
data = ''.join(data)
sql = MysqlHandle.get_xml_sql(xml_path='update_sql',
xml_tag='update',
xml_id='update_regions_enabled')
sql = sql.format(regions_code=city_code)
MysqlHandle.delete_update_insert_mysql_data(sql)
print('我被调用了')
except Exception as e:
self.code = 1
return '身份证id生成接口出现问题---详情请咨询小叶同学'
return data
def del_app_list(request):
column_id = request.POST['column_id']
MysqlHandle.reConnect()
sql_del = MysqlHandle.get_xml_sql(xml_path='delete_sql',
xml_tag='delete',
xml_id='delete_app_list_id') # 删除app的sql
sql_path = MysqlHandle.get_xml_sql(
xml_path='select_sql', xml_tag='select',
xml_id='delete_file_path') # 查找app路径的sql
data = MysqlHandle.select_mysql_data(sql_path.format(id=column_id))[0]
app_path = data.get('appPath')
app_path = './static/' + app_path[:18]
try:
shutil.rmtree(app_path)
except Exception as e:
tag = 2
tag = MysqlHandle.delete_update_insert_mysql_data(
sql_del.format(id=column_id))
if tag == 1:
return HttpResponse('1')
elif tag == 2:
return HttpResponse('2')
else:
return HttpResponse('0')
def delete_token_return_lend_request_id(request):
data = request.JSON
sale_no = data['sale_no']
mobile = data['mobile']
print('data======>', mobile)
result = {'code': '202', 'data': '没有此手机号'}
try:
sql1 = MysqlHandle.get_xml_sql(xml_path='select_sql',
xml_tag='select',
xml_id='select_lend_request_id')
print(sql1.format(mobile=mobile))
sql_data1 = MysqlHandle.select_mysql_data(sql1.format(mobile=mobile))
sql2 = MysqlHandle.get_xml_sql(xml_path='delete_sql',
xml_tag='delete',
xml_id='delete_user_token')
sql_data2 = MysqlHandle.delete_update_insert_mysql_data(
sql2.format(sale_no=sale_no))
except Exception as e:
result['code'] = '400'
result['data'] = e
return JsonResponse(result, status=400)
if sql_data1:
result['code'] = '200'
result['data'] = sql_data1[0]
return JsonResponse(result, status=200)
def qr_ios_download(request):
ids = request.GET['id']
sql_select = MysqlHandle.get_xml_sql(xml_path='select_sql',
xml_tag='select',
xml_id='select_ios_qr_path')
data = MysqlHandle.select_mysql_data(sql_select.format(id=ids))[0]
return render(request, 'qr-ios-download.html', {'data': data})
def update_app(request):
ids = request.GET['id']
sql_select = MysqlHandle.get_xml_sql(xml_path='select_sql',
xml_tag='select',
xml_id='update_app_list')
MysqlHandle.reConnect()
data = MysqlHandle.select_mysql_data(sql_select.format(id=ids))[0]
data['describe'] = data['describe'].replace("\r\n", "\\n")
message = ''
if request.method == 'POST':
appType = request.POST.get('app_type')
environment = request.POST.get('environment')
customeroruser = request.POST.get('customeroruser')
isfinal = request.POST.get('isfinal')
app_version = request.POST.get('app_version')
describe = request.POST.get('describe')
test_or_beta = request.POST.get('test_or_beta')
sql = MysqlHandle.get_xml_sql(xml_path='update_sql',
xml_tag='update',
xml_id='update_app_manage')
tag = MysqlHandle.delete_update_insert_mysql_data(
sql.format(appType=appType,
environment=environment,
customerOruser=customeroruser,
isFinal=isfinal,
appVersion=app_version,
describe=describe,
test_or_beta=test_or_beta,
id=ids))
if tag == 0 or tag == 1:
MysqlHandle.reConnect()
data = MysqlHandle.select_mysql_data(sql_select.format(id=ids))[0]
message = '修改成功！'
else:
message = '修改失败！'
return render(request, 'update_app.html', {
'data': data,
'message': message
})
def ProductIsRequired(request):
data = request.JSON
product_name = data['product_name']
sql = MysqlHandle.get_xml_sql(xml_path='select_sql',
xml_tag='select',
xml_id='search_product_required')
sql_data = MysqlHandle.select_mysql_data(
sql.format(product_name=product_name))
result_data = []
for inner in sql_data:
result_data.append(inner["material_type"])
result = {'code': 200, 'data': result_data}
print('必填项-----》', result)
return JsonResponse(result, status=200)
def welcome(request):
date = []
app_count = []
piece_count = []
# 计算一周前今天的日期
today = datetime.datetime.now()
offset = datetime.timedelta(days=-7)
hebdomad_ago = (today + offset).strftime('%Y-%m-%d')
print('一周前的今天', hebdomad_ago)
sql = MysqlHandle.get_xml_sql(xml_path='select_sql', xml_tag='select', xml_id='select_statistics_amount_app_data')
data = MysqlHandle.select_mysql_data(sql.format(hebdomad_ago=hebdomad_ago))
for i in data:
date.append(i['date'])
app_count.append(i['count'])
# 查询进件数
piece_sql = MysqlHandle.get_xml_sql(xml_path='select_sql', xml_tag='select',
xml_id='select_statistics_amount_piece_data')
piece_data = MysqlHandle.select_mysql_data(piece_sql.format(hebdomad_ago=hebdomad_ago))
for i in piece_data:
piece_count.append(i['count'])
result = {'date': mark_safe(date), 'piece_count': piece_count, 'app_count': app_count}
print('result=======>', result)
return render(request, 'welcome.html', result)
def mobile_to_id_status(request):
data = request.JSON
mobile = data['mobile']
mobile_str = ''
print('views 中 mobile----》', mobile)
for i in mobile:
mobile_str = mobile_str + '"%s"' % i + ','
sql_moblie = mobile_str.rstrip(',')
print('sql_moblie----->', sql_moblie)
sql = MysqlHandle.get_xml_sql(xml_path='select_sql',
xml_tag='select',
xml_id='select_id_status_to_piece')
print(sql.format(mobile=sql_moblie))
data = MysqlHandle.select_mysql_data(sql.format(mobile=sql_moblie))
result = {'code': 200, 'data': data}
return JsonResponse(result, status=200)
def app_product(request):
sql = MysqlHandle.get_xml_sql(xml_path='select_sql',
xml_tag='select',
xml_id='select_product_list')
data = MysqlHandle.select_mysql_data(sql)
paginator = Paginator(data, 10)
page = request.GET.get('page', 1)
currentPage = int(page)
try:
print(page)
result = paginator.page(page)
except PageNotAnInteger:
result = paginator.page(1)
except EmptyPage:
result = paginator.page(paginator.num_pages)
return render(request, 'app-product.html', {
'data': result,
'paginator': paginator
})
def piece_list(request):
print('post----------->', request.POST)
sql = request.DPOST.get('sql') + ' order by create_time desc'
data = MysqlHandle.select_mysql_data(sql)
print('sqls------>', sql)
paginator = Paginator(data, 20)
page = request.GET.get('page', 1)
currentPage = int(page)
try:
print(page)
result = paginator.page(page)
except PageNotAnInteger:
result = paginator.page(1)
except EmptyPage:
result = paginator.page(paginator.num_pages)
return render(request, 'piece-list.html', {
'piecelist': result,
'paginator': paginator
})
def mobile_enable(request):
data = request.JSON
result = {'code': '200', 'data': '1'}
mobile = data['mobile']
try:
sql = MysqlHandle.get_xml_sql(xml_path='select_sql',
xml_tag='select',
xml_id='select_mobile_enable')
print('sql---->', sql.format(mobile=mobile))
mysql_data = MysqlHandle.select_mysql_data(sql.format(mobile=mobile))
dicts = mysql_data[0]
tag = dicts['counts']
except Exception as e:
result['code'] = '400'
result['data'] = e
return JsonResponse(result, status=400)
if tag:
return JsonResponse(result, status=200)
result['data'] = '%s' % tag
return JsonResponse(result, status=200)
def app_list(request):
sql = request.DPOST.get('sql') + ' order by create_time desc'
MysqlHandle.reConnect()
data = MysqlHandle.select_mysql_data(sql)
paginator = Paginator(data, 10)
page = request.GET.get('page', 1)
currentPage = int(page)
try:
print(page)
result = paginator.page(page)
except PageNotAnInteger:
result = paginator.page(1)
except EmptyPage:
result = paginator.page(paginator.num_pages)
return render(request, 'app-list.html', {
'applist': result,
'paginator': paginator
})
def SearchResult(request):
data = request.JSON
status = data['status']
sql = MysqlHandle.get_xml_sql(xml_path='select_sql',
xml_tag='select',
xml_id='search_result')
sql_data = MysqlHandle.select_mysql_data(sql.format(status=status))
count = len(sql_data)
result = {'code': 200, 'data': sql_data}
if count:
strs = ''
for inner in sql_data:
strs = strs + ',' + inner['mobile']
aus = AesUtils()
mobile_list = aus.decrpyt(strs.lstrip(','))
for let in range(len(mobile_list)):
sql_data[let]['mobile'] = mobile_list[let]
result['data'] = sql_data
return JsonResponse(result, status=200)
result['code'] = 202
return JsonResponse(result, status=202)
def add_piece(request):
sql = MysqlHandle.get_xml_sql(xml_path='select_sql',
xml_tag='select',
xml_id='select_product_list')
data = MysqlHandle.select_mysql_data(sql)
return render(request, 'add-piece.html', {'data': data})