
    zf                         d dl mZ d dlmZ d dlmZ d dlmZ d dlmZ d dl	m
Z
 d dlmZmZ d dlmZ d	 Zg d
Zg dZd Zd Zd Zd Zd Zd Zd Zy)    )renderHttpResponse)JsonResponse)Q)connections)Module)ClassSessionClassSessionView)Venuec                     t        d      S )NzHello world!r   )requests    2/var/www/teaching_timetable/class_session/views.pystagesr      s    ''    )            )MondayTuesday	WednesdayThursdayFridayc                    g }d|z   }t         j                  j                         j                  dddd      j	                  |      j                         }|D ]  }t        d
i |}t        |j                  j                  dz   |j                  j                  z          t        |j                  |j                  |j                  |j                  j                  |j                  j                   |j"                  j                   |j                  j                  j%                         dz   |j                  j&                  z         }|j)                  |        t+        | d|t,        t.        |d	      S )NzMODULE: venue_idlevel_id
teacher_id	module_id)module__code timetable.htmlclass_sessionsperiodsweekdaysdisplay_title )r
   objectsallselect_relatedfiltervaluesprintteachertitlenamer   session_dayperioddurationvenuelevelcodemodule
capitalizesurnameappendr   r%   daysr   r7   my_listr'   classsessioncss_acss_a1csvs           r   getModuleTimeTablerC      sD   G%M''++-<<ZUacnovv w !68   &&fnn""3&v~~':'::;v116==&//SYS_S_SdSd%||00&--2D2D%~~33>>@DV^^E[E[[] 	s '+T[im  @M  .N  O  Or   c                    g }d|z   }t         j                  j                         j                  dddd      j	                  |      j                         }|D ]  }t        d
i |}t        |j                  j                         t        |j                  |j                  |j                  |j                  j                  |j                  j                  |j                  j                  |j                   j"                  j%                         dz   |j                   j&                  z         }|j)                  |        t+        | d|t,        t.        |d	      S )Nz
LECTURER: r   r   r   r   )teacher__ec_numberr!   r"   r#   r(   r
   r)   r*   r+   r,   r-   r.   r5   r1   r   r2   r3   r4   r6   r7   r8   r/   r0   r9   r:   r;   r   r%   r<   )r   ecnor>   r'   r?   r@   rA   rB   s           r   getTeacherTimeTablerH   %   s1   G 4'M''++-<<ZUacnovv w !!'   &&fll v116==&//SYS_S_SdSd%||00%}}11%~~33>>@DV^^E[E[[] 	s '+T[im  @M  .N  O  Or   c                    g }d|z   }t         j                  j                         j                  dddd      j	                  |      j                         }|D ]  }t        d
i |}t        |j                  j                         t        |j                  |j                  |j                  |j                  j                  |j                  j                  |j                  j                  |j                   j"                  j%                         dz   |j                   j&                  z         }|j)                  |        t+        | d|t,        t.        |d	      S )NProgramme Level: r   r   r   r   level__coder!   r"   r#   r(   rF   r=   s           r   getLevelTimeTablerM   7   s1   G'$.M''++-<<ZUacnovv w  &(   &&fll v116==&//SYS_S_SdSd%||00%}}11%~~33>>@DV^^E[E[[] 	s '+T[im  @M  .N  O  Or   c                    g }d|z   }t         j                  j                         j                  dddd      j	                  |      j                         }|D ]  }t        di |}t        |j                  j                         t        |j                  |j                  |j                  |j                  j                  |j                  j                  |j                  j                  |j                   j"                  j%                         dz   |j                   j&                  z         }|j                  |j                  |j                  |j                  j                  |j                  j                  |j                  j                  |j                   j"                  j%                         dz   |j                   j&                  z   d}	|j)                  |	        t+        |d	
      S )NrJ   r   r   r   r   rK   r!   )r2   r3   r4   
venue_name
level_codemodule_codeteacher_nameF)safer(   )r
   r)   r*   r+   r,   r-   r.   r5   r1   r   r2   r3   r4   r6   r7   r8   r/   r0   r9   r:   r;   r   )
r   r7   output_datatyper>   r'   r?   r@   rA   rB   session_datas
             r   getLevelTimeTableJSONrV   H   s   G'$.M''++-<<ZUacnovv w  &(   %&&fll v116==&//SYS_S_SdSd%||00%}}11%~~33>>@DV^^E[E[[] "--mm ,,++ ,,++!==--"NN00;;=cA&..BXBXX
 	|$'%* e,,r   c                    g }d|z   }t         j                  j                         j                  dddd      j	                  d      j                         }t        |       |D ]T  }t        di |}|d k7  st        d       t        |       t        d       |j                  j                  j                  d	      d
   j                         |j                         k7  r~t        |j                  j                         t        |j                  |j                  |j                   |j                  j                  |j                  j                  |j"                  j                  |j$                  j&                  j)                         dz   |j$                  j*                  z         }|j-                  |       W t/        | d|t0        t2        |d      S )NzProgramme: r   r   r   r   F)teacher__isnullzD....................................................................-r   r!   r"   r#   r(   )r
   r)   r*   r+   r,   r-   r.   r6   r7   splitlowerr5   r1   r   r2   r3   r4   r8   r/   r0   r9   r:   r;   r   r%   r<   r=   s           r   getProgrammeTimeTabler\   f   s   G!D(M''++-<<ZUacnovv  HMv  N  U  U  WL 
,  && T>XY&MXY||  &&s+A.446$**,F&,,##$"6#5#5v}}fooW]WcWcWhWh#)<<#4#4#)==#5#5#)>>#7#7#B#B#DS#HI_I_#_aC NN3! $ '+T[im  @M  .N  O  Or   c                 &   g }d|z   }t         j                  j                  dddd      j                  |      j	                         }t
        d   }|j                  j                  |      j                         }t        |       t        |j                                |D ]  }t        di |}|j                  d k(  rt        |j                  |j                  |j                  |j                   j"                  |j$                  j&                  |j                  j&                  |j(                  j*                  j-                         d	z   |j(                  j.                  z         }	|j1                  |	        t3        | d
|t4        t6        |d      S )NzVENUE: r   r   r   r   )venue__codedefault
connectionr!   r"   r#   r(   )r
   r)   r+   r,   r-   r   queryget_compileras_sqlr.   countr8   r   r2   r3   r4   r5   r1   r6   r7   r/   r0   r9   r:   r;   r   r%   r<   )
r   r7   r>   r'   classsessionsdefault_connsqlr@   rA   rB   s
             r   getVenueTimeTableri      s   GdNM ((77
JP\^ijqq  Cq  D  K  K  MMy)L



*
*l
*
C
J
J
LC	#J	-


  &&==D v116==&//SYS_S_SdSdflfrfrfwfwy  zG  zG  zL  zL%~~33>>@DV^^E[E[[]s '+T[im  AN  .O  P  Pr   c                 ,   g }d}t         j                  j                  dddd      j                  d      j	                         }t
        j                  j                         j	                         }g }|D ]  }t        di |}|j                  |         t        |       t        d   }|j                  j                  |      j                         }	t        |	       t        |j                                |D ]  }
t        di |
}|j                  d k(  rt        |j                  j                         t!        |j"                  |j$                  |j&                  |j(                  j                  |j*                  j,                  |j                  j,                  |j.                  j0                  j3                         d	z   |j.                  j4                  z         }|j                  |        t        |       t7        | d
|t8        t:        ||d      S )NzWHOLE: r   r   r   r   venue_id__namer_   r`   r!   zwhole_timetable.html)r$   r%   r&   venuesr'   r(   )r
   r)   r+   order_byr-   r   r*   r;   r.   r   rb   rc   rd   re   r8   r1   r   r2   r3   r4   r5   r6   r7   r/   r0   r9   r:   r   r%   r<   )r   r>   r'   rf   
all_venuesrl   r5   venue_1rg   rh   r@   rA   rB   s                r   getWholeTimeTablerp      s   GM ((77
JP\^ijss  uE  F  M  M  OM""$++-JF  .%.g 
&My)L



*
*l
*
C
J
J
LC	#J	-


  &&==D fmm  !v116==&//SYS_S_SdSdflfrfrfwfwy  zG  zG  zL  zL%~~33>>@DV^^E[E[[]s 
'N'1gZaos  @F  Yf  4g  h  hr   N)django.shortcutsr   django.httpr   r   django.db.modelsr   	django.dbr   module.modelsr	   class_session.modelsr
   r   venue.modelsr   r   r%   r<   rC   rH   rM   rV   r\   ri   rp   r(   r   r   <module>rx      sW    # $ $  !   > ( ;O"O$O"-<O:P*hr   