a 2jf<@s4ddlmZmZmZddlmZddlmZddlm Z ddl m Z ddl m Z mZddlmZdd lmZdd lmZdd lmZmZmZmZmZmZmZdd lmZmZed dZeddZ eddZ!eddZ"eddZ#eddZ$eddZ%eddZ&eddZ'edd Z(ed!d"Z)d#S)$)renderredirectget_object_or_404)login_required)messages) HttpResponse)timezone)StudentTeacher)RiskPredictioncalculate_student_risk Assignment)GroupSubject ScheduleItemRoom Attendance AcademicDebtOlympiad)datetime timedeltac Cstj}|jd}|r(tt|d}n|}|rNtjj|d ddd}ng}i}|D].}|j |vrri||j <|||j |j d<qZgd}gd }||||||t jtjtjd } t|d | S) u4Главная страница расписанияgroupidrsubjectteacherroom%H:%M)ПНВТСРЧТПТСБВС))z09:00z10:30)z10:45z12:15)z12:45z14:15)z14:30z16:00)z16:15z17:45) groupsselected_group schedule_dictschedule_itemsweekdaystimessubjectsteachersroomszschedule_new.html)robjectsallGETgetrfirstrfilterselect_relatedweekday start_timestrftimerr rr) requestr)selected_group_idr*r,r+itemr-r.contextr@D:\diplom_project\risk\views.py schedule_views4     rBc Cstt|d}tjj|dddd}dddd d d d d d ddd dddd dddd dddd dddd g}i}|D]}g||d<qv|D]}||j|q|D]}||jdddq|||d }t |d!|S)"uFРасписание конкретного преподавателяr)rrrr Понедельникr"r )nameshortnumberВторникr# Средаr$Четвергr%Пятницаr&Субботаr'Воскресеньеr(rFcSs|jS)N)r:xr@r@rAPz"teacher_schedule..)key)rr-schedule_by_weekdayzteacher_schedule.html) rr rr2r7r8r9appendsortr) r< teacher_idrr,r-rXdayr>r?r@r@rAteacher_schedule7s,         r]c Cs|jjdvr(|jjs(t|dtdS|jdkrtjj |j d|j d|j d|j dpdd |j d |j d |j d |j d dk|j ddkd t |dtdS)uhДобавление занятия (только для преподавателей и админов)racademic_staffadminuBУ вас нет прав на добавление занятийschedulePOSTgroup_id subject_idr[room_idNr9r:end_time is_even_weekon is_odd_week) rcrdr[rer9r:rfrgriu!Занятие добавлено) userroleis_staffrerrorrmethodrr2createrbr5success)r<r@r@rAadd_schedule_itemZs"         rqcCsP|jjdvr(|jjs(t|dtdStt|d}|t |dtdS)udУдаление занятия (только для преподавателей и админов)r^u>У вас нет прав на удаление занятийraruЗанятие удалено) rjrkrlrrmrrrdeleterp)r<item_idr>r@r@rAdelete_schedule_itemqs   rtc Csddlm}ddlm}m}m}|jd}|sDt |dt dSt t |d}t jj|dd d d }|}|j} d |j| _gd } gd} d|j| d<|ddd| d_| dd| d<t| ddD]J\} } | jd| | d|ddd| jd| d_|dddd | jd| d_qi}|D]2}|j|vr@i||j<|||j|jd!<q&t| d"dD]$\}\}}| j|d#|d$|d|d%d&| j|d#d_ttd#d'ddD]\}}||i|}|r`|jrt|jnd(}|jr|jj rd)}|j!jd*|j"j#d+|j"j$d*|}| j|||d|dd%d%d,| j||d_d-| j%|_&n&| j||d(d|d%d&| j||d_qqftd#d'D]}d.| j't(d/|_)qt*d0d1}d2|jd3t+,d4d5|d6<|-||S)7u,Экспорт расписания в Excelr)Workbook) AlignmentFont PatternFillruВыберите группуrarrrrr uРасписание )rCrGrIrKrMrOrQ)z 09:00-10:30z 10:45-12:15z 12:45-14:15z 14:30-16:00z 16:15-17:45u"Расписание группы A1T)sizeboldzA1:H1u ВремяA3rH)startrJ)rowcolumnvalueFFFFFF)r|color)rr4395ABsolid) start_color end_color fill_typer!rLr -center) horizontalu—u🌐 Дистант  ) wrap_textrvertical<@zAapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet) content_typezattachment; filename="schedule__z%Y%m%dz.xlsx"zContent-Disposition).openpyxlruopenpyxl.stylesrvrwrxr4r5rrmrrrrr2r7r8activerDtitlefont merge_cells enumeratecellfillr9r:r; alignmentranger str is_distancerr last_name first_namerow_dimensionsheightcolumn_dimensionschrwidthrrnowsave)r<rurvrwrxrcrr,wbws weekdays_rusr.ir\r+r>row_idxr~endcol_idxr9 room_name cell_valuecolresponser@r@rAexport_schedule~sh       &  rc Cs8|jjdkrtdStjdd}ddddd}g}|D]d}|j}|stt |\}}}} t jj ||||| d}||j d7<|j d vr<| ||d q.T)rWreversezrisk_list.html risk_list)rjrkrlrr r2r3rr6rr rorYrZr) r<r risk_datarpredrrrrr@r@rArs"   rc Cs|jjdkrtdS|jj}|j}|jd}|rFtt ||d}n| }|r|j }|sddl m }||\}}} } tjj|||| | d}nd}t|d |||d S) uPСтраница успеваемости ребёнка для родителяparentrchild)rparentsr r rNzchild_progress.html)childrenselected_childr)rjrkrrrr3r4r5rr r6rrisk_calculatorrr r2ror) r<rrselected_child_idrrrrrrrr@r@rAchild_progresss.     rc Cs|jjdkr:|jj}tjj|dd}t|d||dStj }|j d}|j dt d}|r~tt|d }g}n |}g}|rtjj|d ng}i} tjj|d D]} | | | jd | j<q|||||| d } t|d| S)u)Страница посещаемостиr)rschedule_item__subjectzmy_attendance.html) attendancesrrdatez%Y-%m-%drr)schedule_item__inr)r)r* selected_dater,rattendances_dictzattendance.html)rjrkrrr2r7r8rrr3r4r5rrr;rr6r schedule_item_id student_id) r<rrr)r=rr*r,rrattr?r@r@rAattendance_view(s0    rcCs|jdkr|jd}|jd}|jd}|jdd}tjj||||dd\}}|jd d krdd lm}|dd iSt |d t dS)u'Отметка посещаемостиrbrrstatus late_minutesr)rr)rrdefaultszx-requested-withXMLHttpRequest) JsonResponseoku)Посещаемость отмечена attendance) rnrbr5rr2update_or_createheaders django.httprrrpr)r<rrrrrcreatedrr@r@rAmark_attendanceLs        rc Cs|jjdkrtdS|jj}|j}|s\ddlm}||\}}}}tj j |||||d}ddl m }ddl m } |j j|j| d d d d } t|d ||| dS)uJСтраница риска для конкретного студентаrrr r rrr)r)r deadline__gtedeadlineNrNz my_risk.html)rrupcoming_assignments)rjrkrrrr6rrr r2roassignments.modelsrrr7rrrorder_byr) r<rrrrrrrrrrr@r@rArds4      rN)*django.shortcutsrrrdjango.contrib.auth.decoratorsrdjango.contribrrr django.utilsrZ users.modelsr r modelsr rrrrZ core.modelsrrrrrrrrrrBr]rqrtrrrrrrrr@r@r@rAs@       $ & "   C '  # #