
    piC	                     V    S SK JrJr  S SKJrJrJr  S SKJr  S SK	J
r
  S\S\S\4S jrg	)
    )Sessionaliased)descor_and_)Reservation)Userdbuser_idrolec                    [        [        5      n[        [        5      nU R                  [        UU5      R	                  U[        R
                  UR                  :H  5      R	                  U[        R                  UR                  :H  5      R                  [        R                  R                  S 5      [        R                  S:g  5      nUS:X  a#  UR                  [        R                  U:H  5      nO(US:w  a"  UR                  [        R
                  U:H  5      nUR                  [        [        R                  5      [        [        R                  5      5      nUR                  5       n/ nU H  nUu  pnS nU	R                  =(       d    SnU	R                   =(       d    SnU	R                  nU(       dI  U(       aB  [#        U5      R%                  S5      n['        U5      S:  a  US   n['        U5      S:  a  US   nU(       d  U(       a  U S	U 3R)                  5       O
U=(       d    SnUR+                  U	R                  UUUUU	R                  U" U
5      U" U5      S
.5        M     U$ )N docenteadminc                 b    U (       d  gU R                   =(       d    U R                  =(       d    S$ )Nu   —)nameemail)us    5/home/mario/Escritorio/thel4footbal/app/notas/crud.pyget_user_label-get_notes_for_display.<locals>.get_user_label*   s     660QWW00    T   r       )iddatetime
dt_display
created_atnotesstudentr   )r   r	   queryr   	outerjoinr   r   
docente_idfilterr"   isnotorder_byr   r!   allr   r   strsplitlenstripappend)r
   r   r   StudentUserDocenteUserr$   rowsitemsrowresr#   r   r   date_txttime_txtr!   partsr    s                     r   get_notes_for_displayr9      s   $-K$-KHH i[((KNN:i[++{~~=f%R 
 yk44?@	k11W<=
 NN4 6 67knn9MNE99;DE #g	1 88>r88>r^^
 J
O))#.E5zQ 85zQ 8;Cx
!H:.557V`Vfdf
&&$$YY%g.%g.	
 		3 F Lr   N)sqlalchemy.ormr   r   
sqlalchemyr   r   r   app.models.reservationr   app.models.userr	   intr+   r9    r   r   <module>r@      s2    + & & .  Bg B B3 Br   