def attendLesson(request):
if request.method == 'POST':
html = {}
try:
student = Student.objects.get(number=request.POST['number'])
date = timezone.localtime(timezone.now()).date()
today = Attendance(attendanceDate=date, student=student)
# attend_list = student.attendance_set.all()
isAttend = student.attendance_set.filter(attendanceDate=date,
student=student)
if not isAttend:
today.save()
student.attendance_set.add(today)
html['is_valid'] = True
html['scheduleTable'] = str(student.stname) + "(" + str(
student.number) + ")" + " 의출석이 정상적으로 되었습니다."
return JsonResponse(html)
else:
html['is_valid'] = False
html['errorMsg'] = str(student.stname) + "(" + str(
student.number) + ")" + " 이미 출석했습니다."
return JsonResponse(html)
except Exception as e:
print("Error: " + str(e))
pythoncom.CoUninitialize()
html['is_valid'] = False
html['errorMsg'] = "Error: " + str(e)
return JsonResponse(html)
def parse_text(wechat_context):
message = wechat_context.get_message()
if "2222" in message.content:
d = {"expire_seconds": 604800, "action_name": "QR_SCENE", "action_info": {"scene": {"scene_id": 123}}}
return wechat_context.response_text(wechat_context.create_qrcode(dict(d)))
if u"考勤" in message.content:
from attendance.models import Attendance, AttendanceParam
import datetime
now = datetime.datetime.now()
a = Attendance(checking_date_sys=now, type="morning", remark_text="test")
a.save()
return wechat_context.response_text(Attendance.objects.all())
pass
# if "QA" or "qa" in message.content:
# articles = []
# q = message.content.replace('qa', '').replace('QA', '')
# for item in QA.objects.filter(q__contains=q):
# articles.append({
# 'title': item.q,
# 'description': item.a,
# })
# if len(articles) == 10:
# break
# if articles:
# return wechat.response_news(articles)
# else:
# return parse_tuling_msg(wechat, tuling(message.source, q))
# else:
return parse_tuling_msg(wechat_context, tuling(message.source, message.content))
def attend(request):
if request.method != 'POST' or _attended(request.user):
return HttpResponse(status=204)
attendance = Attendance(user=request.user)
attendance.attendance = datetime.now()
attendance.save()
return HttpResponseRedirect('/')
def check_in_time(request):
company_policy = Working_Days_Policy.objects.get(
enterprise=request.user.company)
current_employee = Employee.objects.get(user=request.user,
emp_end_date__isnull=True)
attendance_list = Attendance.objects.filter(employee=current_employee)
current_date = datetime.now().date()
current_time = datetime.now().time()
opened_attendance = False
for att in attendance_list:
if att.check_out is None:
opened_attendance = True
if not opened_attendance:
att_obj = Attendance(
employee=current_employee,
date=current_date,
check_in=current_time,
day_of_week=current_date.weekday(),
created_by=request.user,
)
att_obj.save()
else:
print("You still have attendance opened. Please check out first")
messages.error(
request,
_("You still have attendance opened. Please check out first"))
return redirect('attendance:user-list-attendance')
def parse_voice(wechat_context):
message = wechat_context.get_message()
if '考勤' in message.recognition:
from attendance.models import Attendance, AttendanceParam
import datetime
now = datetime.datetime
a = Attendance(checking_date_sys=now, type="morning", remark_text="test")
a.save()
pass
else:
response = parse_tuling_msg(wechat_context, tuling(message.source, message.recognition))
return response
pass
def here(request, session_id, ninja_id):
if request.method == "POST":
ninja = get_object_or_404(Ninja, pk = ninja_id)
print session_id
session = get_object_or_404(DojoSession, pk = session_id)
a = Attendance(
ninja = ninja,
session = session,
added_by = request.user
)
a.save()
return redirect('attendance:signoff', dojo_session_id = session_id)
def populate_attendance_table(date):
atts = Attendance_Interface.objects.filter(date__date=date)
if len(atts) == 0:
print("Attendance Interface table doesn't have data for date selected")
else:
data = {}
for att in atts:
try:
Employee.objects.get(user=request.user,
emp_end_date__isnull=True)
except Employee.DoesNotExist:
continue
# initialize the dictionary that hold attendance check in and check out
data[att.user_id] = ({} if data.get(att.user_id, None) is None else
data[att.user_id])
if att.punch == '0':
data[att.user_id]['check_in'] = att.date.time()
elif att.punch == '1':
data[att.user_id]["check_out"] = att.date.time()
for key, value in data.items():
emp = Employee.objects.get(emp_number=key,
emp_end_date__isnull=True)
try:
attendance = Attendance.objects.filter(date=date).get(
employee=emp)
attendance.check_in = value.get("check_in", None)
attendance.check_out = value.get("check_out", None)
except Attendance.DoesNotExist:
attendance = Attendance(
employee=emp,
date=date,
check_in=value.get("check_in", None),
check_out=value.get("check_out", None),
)
attendance.save()
# This part to get all employees who are absent this day
att_employees = Attendance.objects.filter(date=date).values_list(
"employee", flat=True)
employees = Employee.objects.all().values_list("id", flat=True)
for employee in employees:
if employee not in att_employees:
employee = Employee.objects.get(id=employee,
emp_end_date__isnull=True)
attendance = Attendance(
employee=employee,
date=date,
)
attendance.save()
def post(self, request, *args, **kwargs):
status = 200
day = request.POST['current_date']
month = request.POST['current_month']
year = request.POST['current_year']
students = ast.literal_eval(request.POST['students'])
batch_details = ast.literal_eval(request.POST['batch'])
batch = Batch.objects.get(id=batch_details['id'])
user = request.user;
date = dt.date(int(year), int(month), int(day))
try:
attendance = Attendance.objects.get(batch=batch, date=date)
except:
attendance = Attendance()
attendance.batch = batch
attendance.date = date
attendance.user = user
attendance.topics_covered = batch_details['topics']
if batch_details['remarks']:
attendance.remarks = batch_details['remarks']
attendance.save()
for student_details in students:
student = Student.objects.get(id=student_details['id'])
if student.is_rolled == False:
student_attendance, created = StudentAttendance.objects.get_or_create(student=student, attendance=attendance)
if student_details['is_presented'] == 'true':
student_attendance.status = "P"
else:
student_attendance.status = "A"
student_attendance.save()
res = {
'result': 'ok',
}
response = simplejson.dumps(res)
return HttpResponse(response, status=status, mimetype='application/json')
def detect_faces(course_id, year, date, img_urls):
group_id = str.lower(str(course_id)) + "_" + str(year)
headers = {
"Content-Type": 'application/json',
"Ocp-Apim-Subscription-Key": MICROSOFT_KEY
}
url1 = "https://westus.api.cognitive.microsoft.com/face/v1.0/detect"
url2 = "https://westus.api.cognitive.microsoft.com/face/v1.0/identify"
mappings = {}
all_imgs = {}
id_to_url = {}
for img_url in img_urls:
data1 = {"url": str(img_url)}
resp1 = requests.post(url1, headers=headers, data=json.dumps(data1))
if resp1.status_code == 200:
print "faces detected for " + img_url
body = resp1.json()
n = 0
while n < len(body):
ids = []
imgs = copy.copy(body[n:n + 10])
for img in imgs:
all_imgs[img['faceId']] = img['faceRectangle']
ids.append(img['faceId'])
data2 = {"personGroupId": str(group_id), "faceIds": ids}
resp2 = requests.post(url2,
headers=headers,
data=json.dumps(data2))
if resp2.status_code == 200:
print "mappings obtained"
a = resp2.json()
print a
for each in a:
try:
mappings[each['faceId']] = each['candidates'][0][
'personId']
id_to_url[each['candidates'][0]
['personId']] = img_url
except:
pass
else:
print "mappings not obtained"
print resp2.json()
n = n + 10
else:
print "faces not detected for " + img_url
print resp1.json()
people = mappings.values()
people = list(set(people))
faces = mappings.keys()
students = CourseGroup.objects.filter(person_group_id=group_id)
instanceList = []
for each in students:
person_id = each.person_id
if person_id in people:
img_url_store = id_to_url[person_id]
for m in faces:
if mappings[m] == person_id:
rect = all_imgs[m]
break
instance = Attendance(courseID=course_id,
date=date,
studentID=each.student_id,
present=True,
year=year,
url=img_url_store,
top=rect['top'],
left=rect['left'],
width=rect['width'],
height=rect['height'])
instance.save()
instanceList.append(instance)
else:
instance = Attendance(courseID=course_id,
date=date,
studentID=each.student_id,
present=False,
year=year)
instance.save()
instanceList.append(instance)
return instanceList
