
    U+iS                         d dl mZmZmZmZ d dlmZ d dlmZ d dl	m
Z
 d dlmZmZmZ d dlmZ d dlmZ d dlmZ  ed	d
g      Zej-                  d       edd       edd       edd       ee
       ee      fdee   dee   dee   dedef
d       Zej-                  d       ee
       ee      fdededefd       Zej-                  d       ee
       ee      fdededefd       Zej7                  d       ee
       ee      fdededefd       Zej;                  d       ee
       ee      fdedededefd       Zej?                  d       ee
       ee      fdededefd       Zy)     )	APIRouterDependsQuerystatus)JSONResponse)get_db)get_current_active_user)	UserLoginStoreSupportOrganizationUpdateSupportOrganization)SupportOrganizationClass)Session)Optionalz/support_organizationszSupport Organizations)prefixtags Nz-1 o omitir = no filtrar)description	school_id	course_id
subject_idsession_userdbc           	         	 t        |      j                  | ||      }|j                  d      dk(  r?t        t        j                  d|j                  dd      |j                  dg       d	      S t        t        j
                  d
d|j                  dg       d	      S # t        $ r2}t        t        j                  dt        |      g d	      cY d}~S d}~ww xY w)zhLista registros activos (deleted_date is None). Filtros opcionales por school_id, course_id, subject_id.)r   r   r   r   error  messageError al listardatar   r   r   status_codecontent   OKN)r   getr   r   HTTP_500_INTERNAL_SERVER_ERRORHTTP_200_OK	Exceptionstr)r   r   r   r   r   resultes          Q/var/www/pie360backend.cl/public_html/app/backend/routes/support_organizations.pyget_listr-      s    
)"-119 2 
 ::h7*"AA!%zz)5FG"JJvr2  **

62.
 	
  
==q6
 	

s$   A/B! 2.B! !	C*'CCCz/by_course/{course_id}c           	         	 t        |      j                  |       }|j                  d      dk(  r/t        t        j
                  d|j                  dd      g d      S t        t        j                  d	d
|j                  dg       d      S # t        $ r2}t        t        j
                  dt        |      g d      cY d}~S d}~ww xY w)z8Obtiene la lista de registros activos para un course_id.)r   r   r   r   r   r   r   r    r#   r$   r   N)	r   get_by_course_idr%   r   r   r&   r'   r(   r)   )r   r   r   r*   r+   s        r,   r/   r/   =   s    
)"->>>S::h7*"AA!%zz)5FG  **

62.
 	
  
=="s1vrB
 	

s$   AB  .B 	C
'C?C
C
z/{id}idc                    	 t        |      j                  |       }|j                  d      dk(  r/t        t        j
                  d|j                  dd      dd      S t        t        j                  d	d
|j                  d      d      S # t        $ r2}t        t        j                  dt        |      dd      cY d}~S d}~ww xY w)zObtiene un registro por id.r   r     r   Registro no encontradoNr   r    r#   r$   r   r   )
r   	get_by_idr%   r   r   HTTP_404_NOT_FOUNDr'   r(   r&   r)   r0   r   r   r*   r+   s        r,   r4   r4   ^   s    
)"-77;::h7*"55!%zz)5MN   **

6*
 	
  
=="s1vtD
 	

s$   AB -B 	C'C=CCz/storer   c           	         	 t        | d      r| j                         n| j                         }|j                  d      t	        |dd      |j
                  |d<   t        |      j                  |      }|j                  d      dk(  r/t        t        j                  d|j                  dd      dd	
      S |j                  d      }t        t        j                  d|j                  dd      ||nd|j                  d      id	
      S # t        $ r2}t        t        j                  dt        |      dd	
      cY d}~S d}~ww xY w)uA   Crea un registro. school_id del body o de la sesión del usuario.
model_dumpr   Nr   r   r   r   zError al guardarr   r    r      zRegistro creador0   )hasattrr8   dictr%   getattrr   r   storer   r   r&   HTTP_201_CREATEDr(   r)   )r   r   r   payloadr*   createdr+   s          r,   r=   r=      s7   
'.t\'B$//#		;;{#+kSW0X0d#/#9#9GK )"-33G<::h7*"AA!%zz)5GH   **V$//!::i1BC#*#6T6::dCS<T
 	
  
==q6
 	

s%   B5D 8AD 	E'E=EEc           	      n   	 t        |d      r|j                  d      n4|j                         j                         D ci c]  \  }}|	|| c}}}t	        |      j                  | |      }|j                  d      dk(  r/t        t        j                  d|j                  dd	      dd
      S t        t        j                  d|j                  dd      d|j                  d      id
      S c c}}w # t        $ r2}t        t        j                  dt        |      dd
      cY d}~S d}~ww xY w)zActualiza un registro por id.r8   T)exclude_unsetNr   r   r2   r   r3   r   r    r#   zRegistro actualizador0   r   )r:   r8   r;   itemsr   updater%   r   r   r5   r'   r(   r&   r)   )	r0   r   r   r   kvr?   r*   r+   s	            r,   rD   rD      s=   
9@|9T$///5lplululwl}l}l  [Rdhdegh  DE  DQ[\^_[_  [R)"-44RA::h7*"55!%zz)5MN   **!::i1GHvzz$/0
 	
 [R&  
==q6
 	

s<   ?C9 
C3C3A!C9 3?C9 3C9 9	D4'D/)D4/D4c                    	 t        |      j                  |       }|j                  d      dk(  r/t        t        j
                  d|j                  dd      dd      S t        t        j                  d	|j                  dd
      dd      S # t        $ r2}t        t        j                  dt        |      dd      cY d}~S d}~ww xY w)u$   Borrado lógico: setea deleted_date.r   r   r2   r   r3   Nr   r    r#   zRegistro eliminador   )
r   deleter%   r   r   r5   r'   r(   r&   r)   r6   s        r,   rH   rH      s    
)"-44R8::h7*"55!%zz)5MN   **!::i1EF
 	
  
==q6
 	

s$   AB .B 	C	'C>C	C	) fastapir   r   r   r   fastapi.responsesr   app.backend.db.databaser   app.backend.auth.auth_userr	   app.backend.schemasr
   r   r   .app.backend.classes.support_organization_classr   sqlalchemy.ormr   typingr   support_organizationsr%   intr-   r/   r4   postr=   putrD   rH        r,   <module>rW      sO   5 5 * * > 
 T " !#
!	"  2$T7QR$T7QR %d8R S%&=>&/%
}%
}%
 %
 	%

 	%
 %
P 34 &&=>&/


 	
 5
@ 7# &&=>&/


 	
 $
@ H% &&=>&/%

"%
%
 	%
 &%
P 7# &&=>&/	#
#

##
 #
 		#
 $#
L g& &&=>&/!
!
!
 	!
 '!
rV   