def login(sno, spw, do): # 实现登录的代码
try:
login_session = requests.session() # 需要一个登录的session，后期的操作都基于这个session
get_text = login_session.get("http://210.30.208.126/",
headers=headers_user_agent())
now_url = get_text.url[:49]
get_soup, _ = return_soup(get_text)
send_data = set_data(sno, spw,
get_soup.find('input').get('value'), "学生",
now_url, login_session)
send_header = set_header(now_url)
login_info = login_session.post(now_url + "default2.aspx",
data=send_data,
headers=send_header)
login_soup, login_text = return_soup(login_info)
login_success, err_info = jud_login(login_text)
if login_success: # 当登录成功了进入路由，根据do进行进行下一步操作
return json.dumps(route(do, Student(sno,
spw), login_session, now_url,
login_soup, send_header, True, ""),
ensure_ascii=False)
else: # 若是错误为验证码不对，则重复这个函数，反之返回登录失败的json
if err_info == "验证码不正确":
return login(sno, spw, do)
else:
return json.dumps(route(do, Student("", ""), "", "", "", "",
False, err_info),
ensure_ascii=False)
except Exception as err_info:
return json.dumps(route(do, Student("", ""), "", "", "", "", False,
str(err_info)),
ensure_ascii=False)
def seed_student_table():
student = Student(email="*****@*****.**",
student_id="101678608",
first_name="Jan",
last_name="Timpe")
student.save()
student = Student(email="*****@*****.**",
student_id="74151585",
first_name="Test",
last_name="Testerson")
student.save()
def setUp(self):
self.student_a = Student(
first_name="Tiffany",
last_name="Jeruto",
date_of_birth=datetime.date(2000, 6, 24),
registration_number="254016",
Email="*****@*****.**",
phone_number="0789647745",
place_of_residence="Rongai",
guardian_phone="0789567484",
id_number=345378625,
date_joined=datetime.date.today(),
)
self.student_b = Student(
first_name="Clay",
last_name="Jensen",
date_of_birth=datetime.date(1999, 7, 25),
registration_number="254017",
Email="*****@*****.**",
phone_number="0789765945",
place_of_residence="Roysambu",
guardian_phone="0780007684",
id_number=3453734789,
date_joined=datetime.date.today(),
)
self.python = Course(name="Python",
duration_in_months=10,
Course_number="1001",
description="Django and Flask frameworks")
self.javascript = Course(
name="Javascript",
duration_in_months=10,
Course_number="1002",
description="Vanilla javascript and frameworks")
self.hardware = Course(name="Hardware",
duration_in_months=10,
Course_number="1003",
description=" Product design using Fusion 360")
self.teacher = Teacher(first_name="James",
last_name="Mwai",
place_of_residence="Kilimani",
phone_number="0723456786",
Email="*****@*****.**",
id_number=3128956743,
profession="Google Expert",
registration_number="2344",
date_joined=datetime.date.today())
def display(request):
name = request.POST.get("name")
age = request.POST.get("age")
crse = request.POST.get("crse")
ob=Student(name=name,age=age,crse=crse)
ob.save()
return getStudent(request)
def ins(request):
name = request.POST.get('name', '')
phone = request.POST.get('phone', '')
student_id = request.POST.get('student_id', '')
address = request.POST.get('address', '')
gender = request.POST.get('gender', '')
dob = request.POST.get('dob', '')
joining = request.POST.get('joining', '')
Class = request.POST.get('Class', '')
section = request.POST.get('section', '')
guardian = request.POST.get('guardian', '')
b = Student(name=name,
student_id=student_id,
phone=phone,
address=address,
gender=gender,
dob=dob,
joining=joining,
Class=Class,
section=section,
guardian=guardian)
b.save()
return render(request, 'teacher/dashboard.html')
def index(request):
# words = 'World!'
# students = Student.objects.all()
students = Student.get_all()
if request.method == 'POST':
form = StudentForm(request.POST)
if form.is_valid():
cleaned_data = form.cleaned_data
student = Student()
student.name = cleaned_data["name"]
student.sex = cleaned_data["sex"]
student.email = cleaned_data["email"]
student.profession = cleaned_data["profession"]
student.qq = cleaned_data['qq']
student.phone = cleaned_data['phone']
student.save()
return HttpResponseRedirect(reverse(index))
else:
form = StudentForm()
context = {
'students': students,
'form': form,
}
return render(request, 'index.html', context=context)
def save(self, user):
student = Student()
student.user = user
student.college = self.cleaned_data['college']
student.course = self.cleaned_data['course']
student.batch_start_year = self.cleaned_data['batch_start_year']
student.save()
def setUp(self):
self.activities_data = []
self.activities = []
self.students_data = []
self.students = []
# 生成三个活动
for i in range(0, 3):
activity_data = get_activity_data()
activity = Activity(**activity_data)
activity.save()
self.activities_data.append(activity_data)
self.activities.append(activity)
# 生成8个学生
company_data = get_company_data()
company = Company(**company_data)
company.save()
for i in range(0, 8):
# make pylint happy
if i == -1:
pass
student_data = get_student_data()
student = Student(company=company, **student_data)
student.save()
self.students_data.append(student_data)
self.students.append(student)
def student_register_action(request):
name = request.POST.get('full_name', 'NULL')
department = request.POST.get('department', 'NULL')
gender = request.POST.get('gender', 'NULL')
email = request.POST.get('email', 'NULL')
contact = request.POST.get('phone', 'NULL')
linkedin = request.POST.get('linkedin', 'NULL')
github = request.POST.get('github', 'NULL')
password = request.POST.get('password', 'NULL')
uploadedfileurl = ''
if request.method == 'POST' and request.FILES['myfile']:
myfile = request.FILES['myfile']
fs = FileSystemStorage()
filename = fs.save(myfile.name, myfile)
uploadedfileurl = fs.url(filename)
bool = emailpresent(email)
if contact == 'NULL':
contact = 0
if bool == True:
s = Student(name=name,
department=department,
gender=gender,
email=email,
contact=contact,
linkedin=linkedin,
github=github,
password=password,
pic_path=uploadedfileurl)
s.save()
return HttpResponseRedirect(reverse('student_login'))
else:
return HttpResponse('Email exists')
else:
return HttpResponseRedirect(reverse('student_register'))
def student_signup(request):
if request.method == 'POST':
if request.POST['key'] == request.POST['key_confirm']:
try:
user = User.objects.get(username=request.POST['username'])
return render(request, 'home.html',
{'error': 'Username has already been taken'})
except User.DoesNotExist:
user = User.objects.create_user(request.POST['username'],
password=request.POST['key'])
fullname = request.POST['fullname'].split(" ", 1)
user.first_name = fullname[0].lower().capitalize()
user.last_name = fullname[1].lower().capitalize()
user.email = request.POST['email']
user.save()
auth.login(request, user)
student = Student(user=user)
student.save()
send_mail(
'NUCES Circle Validation',
'Hi user, \n\nYour NUCES-Circle account has been created. Enjoy!\n\nBest Regards,\nNUCES-Circle Team',
'*****@*****.**',
[user.email],
fail_silently=False,
)
return redirect('student/feed')
else:
return render(request, 'home.html',
{'error': 'Passwords must match'})
else:
# User wants to enter info
return render(request, 'accounts/signup.html')
def upload_student(self, file_path, teacher_id):
wb = openpyxl.load_workbook(file_path) # 打开excel
ws = wb.active # 选中第一个sheet
rows = ws.max_row # 获取行数
columns = ws.max_column # 获取列数
student_list = []
repetition = 0
# 从第2行开始遍历每行
for row in ws.iter_rows(min_row=2,
min_col=1,
max_row=rows,
max_col=columns):
data = [i.value for i in row] # 获取每一行数据
# 取出重复数据
if Student.objects.filter(student_num=data[0]).exists():
repetition += 1
continue
# 写入User表
user = User(
username=data[0], # 以学号作为用户名，防止重复
password=make_password(settings.STUDENT_INIT_PASSWORD))
user.save() # 存入数据库
# 写入student表
student = Student(
student_num=data[0],
name=data[1].strip(), # 去除空格
gender='male' if data[2] == '男' else 'female',
phone=data[4],
birthday=data[3],
user_id=user.id,
teacher_id=teacher_id)
student_list.append(student)
Student.objects.bulk_create(student_list) # 批量加入Student表
return repetition
def setUp(self): self.student_a=Student(first_name=Joy, last_name=Wahome, date_of_birth=datetime.date(1998,8,25), registration_number=123, place_of_residence=Nairobi, phone_number=123456789, [email protected], guardian_phone=12345, id_number=1111111, date_joined=datetime.date.today(),) self.student_b=Student(first_name=Ivy, last_name=Wahome, date_of_birth=datetime.date(1996,5,24), registration_number=1234, place_of_residence=Nairobi, phone_number=123456789, [email protected], guardian_phone=123456, id_number=2222222, date_joined=datetime.date.today(),) self.python=Course(name=python, duration_in_months=10, course_number=1, description=Learn to code in Python,) self.javascript=Course(name=javascript, duration_in_months=10, course_number=2, description=Learn to code in JS,) self.hardware=Course(name=hardware, duration_in_months=10, course_number=3, description=Learn to build hardware,) self.teacher=Teacher(first_name=James, last_name=Mwai, date_of_birth=datetime.date(1998,8,25), registration_no=123, place_of_residence=Nairobi, phone_number=123456789, [email protected], id_number=1111111, profession=Consultant,)
def submit(request):
f_name = str(request.POST['first_name'])
l_name = str(request.POST['last_name'])
mi = str(request.POST['middle_name'])
if len(mi) > 0:
mi = str(mi[0])
add = str(request.POST['address'])
city = str(request.POST['city'])
state = str(request.POST['state'])
zi = str(request.POST['zip'])
phone = str(request.POST['phone'])
dob = request.POST['dob'].split("-")
clas = str(request.POST['class'])
s_pin = str(request.POST['s_pin'])
f_id = request.POST['f_id']
if f_id != "":
f_id = int(request.POST['f_id'])
else:
f_id = None
date_enrolled = str(request.POST['date_enrolled'])
if len(dob) > 1:
date = datetime.datetime(int(dob[0]), int(dob[1]), int(dob[2]), 0, 0,
0, 0)
else:
date = None
if len(date_enrolled.split("-")) != 3:
date_enrolled = None
i = str(len(Student.objects.all()) + 1)
s = Student(i, l_name, f_name, mi, add, city, state, zi, phone, clas, f_id,
s_pin, date, date_enrolled)
try:
s.save()
except Exception as e:
print(e.args)
context = {
'error_message':
'Please fill out all fields exactly as instructed.',
'f_name': f_name,
'l_name': l_name,
'm_name': mi,
'address': add,
'city': city,
'state': state,
'zip': zi,
'phone': phone,
'class': clas,
's_pin': s_pin,
'f_id': f_id,
}
return render(request, 'form.html', context)
else:
context = {}
return render(request, 'thank_you.html', context)
def test_two_student(self):
student_obj = Student(
Name = 'FriendlyRadio UnitTester',
StudentId = 1234,
)
student_obj.save()
student2_obj = Student(
Name = 'Another FriendlyRadio UnitTester',
StudentId = 12345,
)
student2_obj.save()
count = Student.objects.count()
self.assertEqual(count, 2)
print('\n\r --- START print to screen ---')
print(student_obj.Name)
print(' --- STOP print to screen ---')
def register_student(request, **args):
new_user = RegistrationBackend().register(request, **args)
new_user.userattributes.has_agreed_to_terms()
domain = new_user.email.split("@")[1]
if not DomainName.objects.filter(domain=domain).exists():
#make new domain name
DomainName.objects.create(domain=domain)
#send email
#gets email of [email protected]
recipients = [mail_tuple[1] for mail_tuple in s.MANAGERS]
context = Context({'domain': domain})
context.update(get_basic_email_context())
txt_email_body = render_to_string('new_domain_email_body.txt', context)
subject = ''.join(
render_to_string('email_admin_subject.txt', {
'message': "New Domain: %s" % domain
}, context).splitlines())
send_email(subject, txt_email_body, recipients)
if new_user.first_name and new_user.last_name:
student = Student(user=new_user,
first_name=new_user.first_name,
last_name=new_user.last_name)
else:
student = Student(user=new_user)
umeqo = Employer.objects.get(name="Umeqo")
student.save()
if args.has_key("course"):
try:
course = Course.objects.get(id=args["course"])
except:
Course.DoesNotExist
else:
student.first_major = course
student.subscriptions.add(umeqo)
student.save()
return student
def save_student(request):
name = request.POST.get("name", "")
age = request.POST.get("age", -1)
std = request.POST.get("std", -1)
if not name or age == -1 or std == -1:
return JsonResponse({"saved": False}, status=400)
stu_obj = Student(name=name, age=age, std=std)
stu_obj.save()
return JsonResponse({"saved": True})
def registration(request):
if request.is_ajax():
if request.method == 'POST':
try:
StudentImage = request.FILES['txtimageurl']
filesystem = FileSystemStorage()
filename = filesystem.save(StudentImage.name, StudentImage)
url = filesystem.url(filename)
# users = User.objects.get(username = request.POST['txtusername'])
if User.objects.filter(
username=request.POST['txtusername']).exists():
messages.warning(request, "User already exist")
return render(request, 'client/registration-form.html')
# User Creation
user = User.objects.create_user(request.POST['txtusername'],
request.POST['txtemail'],
request.POST['txtpassword'])
group = Group.objects.get(name="Student")
user.groups.add(group)
# Name split and join
Name = request.POST['txtfullname'].split()
if len(Name) > 1:
user.first_name = Name[0]
user.last_name = " ".join(Name[1:])
else:
user.first_name = " ".join(Name)
student = Student(
StudentName=request.POST['txtfullname'],
UserId_id=user.id,
# StudentUserName = request.POST['txtusername'],
# StudentPassword = request.POST['txtpassword'],
DepartmentName_id=request.POST['dropdowndepartment'],
SubDepartmentName_id=request.POST['dropdownsubdepartment'],
StudentImageName=filename,
StudentImage=url,
StudentGender=request.POST['gender'],
StudentPhoneNumber=request.POST['txtphoneno'],
StudentEmail=request.POST['txtemail'],
StudentAddress=request.POST['txtaddress'],
StudentCity=request.POST['txtcityname'])
user.save()
student.save()
return JsonResponse({}, status=200)
except:
return JsonResponse(
{
'error':
'Sorry, We Couldn\'t complete your request! Plesae Try Again Later!'
},
status=500)
department_data = Department.objects.all()
subdepartment_data = SubDepartment.objects.all()
context = {
'department_data': department_data,
'subdepartment_data': subdepartment_data
}
return render(request, 'client/registration-form.html', context)
def student_add(request):
if request.method == 'POST':
StudentImage = request.FILES['txtimageurl']
filesystem = FileSystemStorage()
filename = filesystem.save(StudentImage.name, StudentImage)
url = filesystem.url(filename)
users = User.objects.all()
for user in users:
if user.username == request.POST['txtusername']:
messages.warning(request, "User already exist")
return redirect('/admin/student/add/')
# User Creation
user = User.objects.create_user(request.POST['txtusername'],
request.POST['txtemail'],
request.POST['txtpassword'])
group = Group.objects.get(name="Student")
user.groups.add(group)
# Name split and join
Name = request.POST['txtfullname'].split()
if len(Name) > 1:
user.first_name = Name[0]
user.last_name = " ".join(Name[1:])
else:
user.first_name = " ".join(Name)
user.save()
student = Student(
StudentName=request.POST['txtfullname'],
UserId=user,
# StudentUserName = request.POST['txtusername'],
# StudentPassword = request.POST['txtpassword'],
DepartmentName_id=request.POST['dropdowndepartment'],
SubDepartmentName_id=request.POST['dropdownsubdepartment'],
StudentImageName=filename,
StudentImage=url,
StudentGender=request.POST['gender'],
StudentPhoneNumber=request.POST['txtphoneno'],
StudentEmail=request.POST['txtemail'],
StudentAddress=request.POST['txtaddress'],
StudentCity=request.POST['txtcityname'])
student.save()
notification = Notification(
NotificationTitle="New Student",
NotificationDescription=request.POST['txtfullname'] +
" Added by Akshit Mithaiwala")
notification.save()
return redirect('/admin/student/add/')
else:
department_data = Department.objects.all()
subdepartment_data = SubDepartment.objects.all()
return render(
request, 'admin/student-add.html', {
'department_data': department_data,
'subdepartment_data': subdepartment_data
})
def register_student(csv_path: str) -> None:
"""
Registers students in the platform.
Iterates over the rows of a CSV file
collecting the information to be used
for the account creation.
Parameters
----------
csv_path: str
String containing the path to the file.
"""
msg = ""
columns = ['id', 'password', 'first_name', 'last_name', 'email']
with open(csv_path, 'r') as csv_file:
rows = list(csv.reader(csv_file))
if validate_header(columns, rows[0]) == False:
msg = 'Headers are wrong, headers should be: {}'.format(columns)
return False, msg
# Check empty values
for idx, row in enumerate(rows):
if is_empty(row):
msg = 'File has an empty cell at index: {}'.format(idx)
return False, msg
# Checks all cells exist
for idx, row in enumerate(rows):
if len(row) < len(columns):
msg = 'File has missing cells at index: {}'.format(idx)
return False, msg
with open(csv_path, 'r') as csv_file:
reader = csv.DictReader(csv_file, fieldnames=columns)
# Start registering
for idx, row in enumerate(reader):
if idx != 0:
crt_dict = {}
for column in columns:
crt_dict[column] = row[column]
user1 = User.objects.filter(username=crt_dict['id'])
if user1.exists() == False:
user = User()
user.set_password(crt_dict['password'])
user.username = crt_dict['id']
user.first_name = crt_dict['first_name']
user.last_name = crt_dict['last_name']
user.email = crt_dict['email']
user.save()
student = Student(user=user)
student.save()
return True, msg
def addMark(request):
rollno = int(request.POST['rollno'])
name = request.POST['name']
totalmark = int(request.POST['totalmark'])
student = Student()
student.rollno = rollno
student.name = name
student.toltalmark = totalmark
Student.save(student)
return render(request, "addmark.html", {"result": "SUCCESS"})
def createStudent(request):
print('inside create emp')
print(request.data)
student = request.data
s = Student(sname=student['sname'],
saddress=student['saddress'],
smarks=student['smarks'])
s.save()
print('Emp saved successfully...!')
return Response({"message": "Success"})
def getregdetails(request):
email = request.POST.get("uname")
pasw = request.POST.get("pasw")
print("email: ", email)
print("Password:"******"object saved")
return render(request, "student_login.html")
def add_students(request, excel_file, student_class):
COLUMN_LIMIT = 6
sheet_name = "students"
students = _get_data_from_sheet(request, excel_file, COLUMN_LIMIT,
sheet_name)
if not students: return False
# DATA HEAD FROM EXCEL SHEET:
# No student_id name paren_sms Class ID course ID elective IDs
# Add student to the database
for row in students:
if (len(row) > 0):
if (row[0] != "No" and row[0] != "CLASS ID"):
# if there are empty colums
if (len(row) < COLUMN_LIMIT):
i = len(row)
while (i < COLUMN_LIMIT):
# fill with ""
row.append("")
i += 1
try:
# Check for the exitence of the staff id
s = Student.objects.filter(student_id=row[1])
if (s.count() == 0):
# Students elective subjects
elective_ids = row[4].split(" ")
new_student = Student(student_id=row[1],
name=row[2],
parent_sms=row[3],
student_class=student_class,
house=row[5].capitalize())
new_student.save()
for id in elective_ids:
if id:
elective = Subject.objects.filter(
is_elective=True, subject_id=id).first()
if elective:
new_student.electives.add(elective)
new_student.save()
else:
new_student.delete()
request.session[
"error_message"] = f"Elective subject with ID '{id}' not found"
return False
else:
request.session[
"error_message"] = "Student IDs must be unique for all students."
except Exception as err:
request.session["error_message"] = str(err)
return False
return True
def create_test_students(request):
if not request.is_ajax():
return HttpResponseBadRequest
room_name = request.GET.get("room_name", None)
if room_name is None:
return HttpResponseBadRequest
try:
room = Room.objects.get(room_name=room_name)
except Room.DoesNotExist:
return ajax_bad_request("Room" + room_name + " doesn't exist")
for _ in range(0, 10):
Student(user_name=random_word()[:6], session=None, room=room).save()
return HttpResponseNoContent()
def insert(request):
if request.POST:
post = request.POST
new_student = Student(
num = post["num"],
name = post["name"],
chinese = post["chinese"],
math = post["math"],
english = post["english"],
physics = post["physics"],
chemistry = post["chemistry"],
allscore = int(post["chinese"])+int(post["math"])+int(post["english"])+int(post["physics"])+int(post["chemistry"]))
new_student.save()
return render(request, 'insert.html')
def test_authenticate_fail(self):
auth = authentication.Authentication()
student = Student(registrationNo='2017bcs042',
fname='d',
lname='j',
email='*****@*****.**',
mobile='1234567890',
city='nanded',
state='maha')
student.save()
studentId = Student.objects.get(email='*****@*****.**').studentId
response = auth.create_token('student', studentId, '*****@*****.**')
token_decode = self.client.get('/req/auth/ee' + response['Token'])
self.assertEqual(json.loads(token_decode.content)['Status'], 400)
def register(request):
if request.method == 'POST':
username = request.POST['username']
first_name = request.POST['first_name']
last_name = request.POST['last_name']
email = request.POST['email']
phone = request.POST['phone']
isEmployer = request.POST['isEmployer']
password = request.POST['passwd1']
password2 = request.POST['passwd2']
if password == password2:
if CustomUser.objects.filter(username=username).exists():
messages.error(request, 'Ta nazwa uzytkownika jest zajeta, sprobuj innej')
return redirect('register')
else:
if CustomUser.objects.filter(email=email).exists():
messages.error(request, 'Ten email akutalnie wystepuje w naszym systemie, sprobuj inny')
return redirect('register')
else:
if len(username) > 150 or len(username) < 3:
messages.error(request, 'Nazwa uzytkownika powinna byc dluzsza od 3 znakow i krotsza od 150')
else:
if len(first_name) > 30:
messages.error(request, 'Imie powinno zawierac mniej niz 30 znakow')
else:
if len(last_name) > 150:
messages.error(request, 'Nazwisko powinno zawierac mniej niz 150 znakow')
else:
if len(email) > 254:
messages.error(request, 'Adres email jest za dlugi')
else:
if len(phone) > 20:
messages.error(request, 'Numer telefonu jest za dlugo gosciu')
else:
user = CustomUser.objects.create_user(password=password, username=username, first_name=first_name, last_name = last_name, email = email, isEmployer=isEmployer, phone=phone)
user.save()
if isEmployer == 'True':
company = Company(user=user, email=email)
company.save()
else:
student = Student(user=user, name=first_name, surname=last_name, email=email)
student.save()
messages.success(request, 'Rejestracja przebiegla pomyslnie')
return redirect('login')
else:
messages.error(request, 'Hasla nie zgadzaja sie')
return redirect('register')
return render(request, 'users/register.html')
def regprocessv(request):
#1. Get data from html form
v1 = request.GET.get('n1')
v2 = request.GET.get('n2')
v3 = request.GET.get('n3')
v4 = request.GET.get('n4')
try:
x = Student.objects.get(userid=v2)
return render(request, 'regerror.html')
except ObjectDoesNotExist:
obj = Student(fullname=v1, pwd=v3, address=v4, userid=v2)
obj.save()
return render(request, 'regsuccess.html')
def login_page_callback(request):
username = ''
password = ''
student = Student()
user = authenticate(username=username, password=password)
if user is not None:
login(request, user);
else:
pass
pass
def GetStudVal(request):
id = request.POST.get("sid")
fname = request.POST.get("name")
course = request.POST.get("course")
mark = request.POST.get("total")
ob = Student(name=fname, course=course, marks=mark, rollnum=id)
ob.save()
context = {}
data = Student.objects.all()
context['data'] = data
print(ob.name)
return render(request, 'Student/Output.html', context)
