def upload(request):
try:
uid=request.COOKIES['me_uid']
except KeyError:
return HttpResponseRedirect('http://www.me.uestc.edu.cn/stu/index.php/Login/')
auth= UserAuth(uid).is_auth()
if not auth:
return HttpResponseRedirect('http://www.me.uestc.edu.cn/stu/index.php/Login/')
if request.method == "POST":
form = UploadFileForm(request.POST,request.FILES)
typ=request.FILES['files'].name.split('.')[1]
if not (typ=='xls' or typ=='xlsx'):
return HttpResponse("<h1>上传失败 只能上传excel文件</h1></br><a href='upload'>返回重新上传</a>")
if form.is_valid():
files = open('static/excel.xls','w+')
for chunk in request.FILES['files'].chunks():
files.write(chunk)
files.close()
up_suc=handle_upload_file()
if up_suc :
q=u"上传失败，请以学号为第一列！"
else:
q=u"上传成功！"
return render_to_response('success.html',{'q':q})
else :
form = UploadFileForm()
return render_to_response('upload.html', {'form': form})
def upload(request):
try:
uid = request.COOKIES['me_uid']
except KeyError:
return HttpResponseRedirect(
'http://www.me.uestc.edu.cn/stu/index.php/Login/')
auth = UserAuth(uid).is_auth()
if not auth:
return HttpResponseRedirect(
'http://www.me.uestc.edu.cn/stu/index.php/Login/')
if request.method == "POST":
form = UploadFileForm(request.POST, request.FILES)
typ = request.FILES['files'].name.split('.')[1]
if not (typ == 'xls' or typ == 'xlsx'):
return HttpResponse(
"<h1>上传失败 只能上传excel文件</h1></br><a href='upload'>返回重新上传</a>")
if form.is_valid():
files = open('static/excel.xls', 'w+')
for chunk in request.FILES['files'].chunks():
files.write(chunk)
files.close()
up_suc = handle_upload_file()
if up_suc:
q = u"上传失败，请以学号为第一列！"
else:
q = u"上传成功！"
return render_to_response('success.html', {'q': q})
else:
form = UploadFileForm()
return render_to_response('upload.html', {'form': form})
def uploadFile(request, course_id):
if request.method == 'POST':
c = Course.objects.get(pk=course_id)
upFile = UploadFileForm(request.POST, request.FILES)
data = upFile.data
if upFile.is_valid():
data = upFile.cleaned_data
newFile = Resource(name = data['name'], description = data['description'], type = 'File',
docfile = request.FILES['docfile'], sourceLink = '', course = c)
newFile.save()
return HttpResponseRedirect('/course/%d'%c.id)
else:
resources = Resource.objects.all()
context = RequestContext(request,
{
'c' : c,
'resources' : resources,
'upFileForm' : UploadFileForm(
initial={'name':data['name'], 'description':data['description']}
),
'upLinkForm' : UploadSourceLinkForm(),
'errorFile' : 'Please fill all information'
}
)
return render_to_response('course.html',context)
else:
return viewCourse(request,course_id)
def upload_file(request):
if request.method == 'POST':
form = UploadFileForm(request.POST, request.FILES) # 注意获取数据的方式
if form.is_valid():
handle_uploaded_file(request.FILES['file'])
return HttpResponseRedirect('/success/url/')
else:
form = UploadFileForm()
return render(request, 'upload.html', {'form': form})
def newSheetPage(request):
""" NewSheet view to show the UploadSheetForm """
# TODO: Create an option to upload a new version of a file
student = getStudent(request.user)
if request.method == "POST":
sheetForm = UploadSheetForm(student=student, data=request.POST)
fileForm = UploadFileForm(data=request.POST, files=request.FILES.getlist('file'))
if fileForm.is_valid() and sheetForm.is_valid():
files = request.FILES.getlist('file')
sheet = sheetForm.save(commit=False)
if splitext(files[0].name)[1] in ('.jpeg', '.jpg', '.png'):
sheet.thumbnail = files[0]
print('THUMBNAILED')
else:
sheet.thumbnail = None
sheet.uploadedBy = student
sheet.save()
for file in files:
uploadedFile = UploadedFile()
uploadedFile.file = file
uploadedFile.extension = splitext(file.name)[1]
uploadedFile.contentType = file.content_type
uploadedFile.relatedSheet = sheet
uploadedFile.save()
localVarsJSON = json.dumps({'success': 'true',})
messages.add_message(request, messages.SUCCESS, 'Votre fiche a bien été envoyée !')
return HttpResponse(localVarsJSON, content_type='application/json')
else:
errors = []
if not fileForm.is_valid(): errors.append(fileForm.errors)
if not sheetForm.is_valid(): errors.append(sheetForm.errors)
return HttpResponse(json.dumps(errors), content_type='application/json')
else:
raise Http404('Hey :/ I wasn\'t expecting you here !')
def upload_file(request):
if request.method == 'POST':
form = UploadFileForm(request.POST, request.FILES)
#print (form)
if form.is_valid():
print("Hai")
pred_data = handle_uploaded_file(request.FILES['file'])
return JsonResponse(pred_data, safe=False)
return JsonResponse(['Error'], safe=False)
def upload(request):
form = UploadFileForm()
if request.method == 'POST':
form = UploadFileForm(request.POST, request.FILES)
if form.is_valid():
p = Post()
p.description = request.POST['description']
p.image = request.FILES['file']
p.user = request.user
p.save()
return redirect('/')
return render(request, 'upload.html', {'form': form})
def show_model(request):
"""
Handle Request POST with uploded file
:param request: Request object.
:return:
"""
if request.method == 'POST':
upload_file_form = UploadFileForm(request.POST, request.FILES)
if upload_file_form.is_valid():
diagram_name_unique_id = handle_uploaded_file(
request.FILES['diagram_file'])
request.session['diagram_name'] = diagram_name_unique_id
return HttpResponseRedirect('/open_external_diagram')
else:
return HttpResponseRedirect('/')
def upload(request):
if request.user.is_superuser:
context_dict = {}
if request.method == 'POST' and request.FILES['file']:
try:
form = UploadFileForm(request.POST, request.FILES)
if form.is_valid():
def choice_func(row):
if (str(row[0]).lower().startswith("inc")):
row[0] = "income"
else:
row[0] = "expense"
try:
info = Info.objects.get(name=str(row[1]),
date=str(row[3]))
if (info.amount == row[2]):
return None
else:
info.delete()
return (row)
except:
return row
request.FILES['file'].save_to_database(
model=Info,
initializer=choice_func,
mapdict=['ttype', 'name', 'amount', 'date'])
done = 1
update()
form = UploadFileForm()
context_dict["form"] = form
context_dict["success"] = "Succesfully Uploaded!!"
return render(request, 'app/upload.html', context_dict)
except Exception as e:
print(e)
form = UploadFileForm()
context_dict["form"] = form
context_dict["error"] = e
return render(request, 'app/upload.html', context_dict)
else:
form = UploadFileForm()
context_dict["form"] = form
context_dict["error"] = "No file uploaded"
return render(request, 'app/upload.html', context_dict)
else:
return HttpResponseRedirect("/app/login/")
def index(self, request):
pesan = ""
#assert isinstance(request, HttpRequest)
if request.method == "POST":
pesan = "simpan|false"
fileForm = UploadFileForm(request.POST, request.FILES)
if fileForm.is_valid():
imagesave = ModelTraining()
imagesave.datatraining = fileForm.cleaned_data['datatraining']
imagesave.save()
pesan = "simpan|true"
else:
file = ModelTraining()
return self.tampilHalaman(request, pesan)
def file_upload(request):
# print('-------------------------------')
# print(request)
# print(request.POST)
# print(request.FILES)
# print('-------------------------------')
if (request.method == 'POST'):
form = UploadFileForm(request.POST, request.FILES)
if (form.is_valid()):
form.save()
return redirect('file_upload')
else:
print('[INFO] UploadFileForm is invalid')
upload_file_form = UploadFileForm()
else:
upload_file_form = UploadFileForm()
uploaded_files = UploadFiles.objects.all()
context = {
'upload_file_form': upload_file_form,
'uploaded_files': uploaded_files,
}
return render(request, "app/file_upload.html", context)
def upload_file(request):
data_name = 'Загрузка информации в БД'
if Group.objects.filter(name='Authors').count() == 0:
Group.objects.create(name='Admins')
Group.objects.create(name='Editors')
Group.objects.create(name='Authors')
Group.objects.create(name='Guests')
return redirect('articles')
else:
usergroup = get_usergroup(request)
if usergroup == 'Admins':
if request.method == 'POST':
form = UploadFileForm(request.POST, request.FILES)
if form.is_valid():
# так производится создание объектов модели FileModel и запись их в базу данных
p1 = FileModel.objects.create(file=request.FILES['file'])
data_way1 = 'app/static/'
data_way2 = str(request.FILES['file'])
data_way = data_way1 + data_way2
excel_data_file = xlrd.open_workbook(data_way)
sheet_3 = excel_data_file.sheet_by_index(3) #Users, Авторы
sheet_4 = excel_data_file.sheet_by_index(
4) #Usrrs, Редакторы
row_number = sheet_3.nrows # количество строк
if row_number > 0: # Проверка на пустоту файла
for row in range(1, row_number):
if User.objects.filter(
username=str(sheet_3.row(row)[0]).replace(
"text:", "").replace("'",
"")).count() == 0:
user = User.objects.create_user(
username=str(sheet_3.row(row)[0]).replace(
"text:", "").replace("'", ""),
email=str(sheet_3.row(row)[7]).replace(
"text:", "").replace("'", ""),
password=str(sheet_3.row(row)[0]).replace(
"text:", "").replace("'", ""))
group = Group.objects.get(name='Authors')
group.user_set.add(user)
permission = Permission.objects.get(
name='Can add Article')
user.user_permissions.add(permission)
permission = Permission.objects.get(
name='Can change Article')
user.user_permissions.add(permission)
permission = Permission.objects.get(
name='Can delete Article')
user.user_permissions.add(permission)
AuthorModel.objects.create(
login=user,
index="",
name=str(sheet_3.row(row)[1]).replace(
"text:", "").replace("'", ""),
birth_date=str(
sheet_3.row(row)[2]).replace(
"text:",
"").replace("'",
"").replace(".", ""),
degree=str(sheet_3.row(row)[3]).replace(
"text:", "").replace("'", ""),
title=str(sheet_3.row(row)[4]).replace(
"text:", "").replace("'", ""),
work=str(sheet_3.row(row)[5]).replace(
"text:", "").replace("'", ""),
position=str(sheet_3.row(row)[6]).replace(
"text:", "").replace("'", ""),
email=str(sheet_3.row(row)[7]).replace(
"text:", "").replace("'", ""),
education=str(sheet_3.row(row)[8]).replace(
"text:", "").replace("'", ""))
author = AuthorModel.objects.get(index="")
author.index = str(author.id)
author.save()
row_number = sheet_4.nrows # количество строк
if row_number > 0: # Проверка на пустоту файла
for row in range(1, row_number):
if User.objects.filter(
username=str(sheet_4.row(row)[0]).replace(
"text:", "").replace("'",
"")).count() == 0:
user = User.objects.create_user(
username=str(sheet_4.row(row)[0]).replace(
"text:", "").replace("'", ""),
email=str(sheet_4.row(row)[8]).replace(
"text:", "").replace("'", ""),
password=str(sheet_4.row(row)[0]).replace(
"text:", "").replace("'", ""))
group = Group.objects.get(name='Editors')
group.user_set.add(user)
editor = EditorModel.objects.create(
login=user,
name_magazine=str(
sheet_4.row(row)[3]).replace(
"text:", "").replace("'", ""),
name=str(sheet_4.row(row)[1]).replace(
"text:", "").replace("'", ""),
birth_date=str(
sheet_4.row(row)[2]).replace(
"text:",
"").replace("'",
"").replace(".", ""),
degree=str(sheet_4.row(row)[4]).replace(
"text:", "").replace("'", ""),
title=str(sheet_4.row(row)[5]).replace(
"text:", "").replace("'", ""),
work=str(sheet_4.row(row)[6]).replace(
"text:", "").replace("'", ""),
position=str(sheet_4.row(row)[7]).replace(
"text:", "").replace("'", ""),
email=str(sheet_4.row(row)[8]).replace(
"text:", "").replace("'", ""),
education=str(sheet_4.row(row)[9]).replace(
"text:", "").replace("'", ""))
p1.delete()
data_name = "Загрузка завершена"
return render_to_response('upload.html',
{'data_name': data_name})
else:
return render_to_response(
'upload.html', {
'form': form,
'data_name': "Ошибка ввода данных"
})
else:
form = UploadFileForm()
return render_to_response('upload.html', {
'form': form,
'data_name': data_name
})
else:
return redirect('articles')