
    fy                     8    d dl mZ d dlZd dlmZ  G d d      Zy)    )	TurnModelN)or_c                   &    e Zd Zd Zd Zd ZddZy)	TurnClassc                     || _         y N)db)selfr	   s     SC:\Users\jesus\OneDrive\Desktop\escritorio\newerp\app\backend\classes\turn_class.py__init__zTurnClass.__init__   s	        c                     	 | j                   j                  t              j                  t        j                  |k(        j                         }|S # t        $ r}t        |      }d| cY d }~S d }~ww xY wNError: )r	   queryr   filtergroup_idall	Exceptionstr)r
   r   dataeerror_messages        r   get_by_groupzTurnClass.get_by_group	   sc    	-77==+2293E3E3QRVVXDK 	-FM]O,,	-s   AA 	A4A/)A4/A4c                     	 | j                   j                  t              j                         }|S # t        $ r}t        |      }d| cY d }~S d }~ww xY wr   )r	   r   r   r   r   r   )r
   r   r   r   s       r   get_allzTurnClass.get_all   sM    	-77==+//1DK 	-FM]O,,	-s   .1 	AA	AANc                    	 | j                   j                  t              j                  t        j                  |k(  t        j
                  |k(        }|r<|dk7  r7|j                  t        t        j                  j                  |                  }|j                         }|sy|S # t        $ r}t        |      }d| cY d }~S d }~ww xY w)NzBuscar TurnozNo data foundr   )r	   r   r   r   employee_type_idr   r   turncontainsr   r   r   )r
   r   r   search_termr   r   r   r   s           r   getzTurnClass.get   s    	-GGMM),y115EEyGYGY]eGef  {n<S)@)@)M%NO99;D&K 	-FM]O,,	-s$   B!B& $B& &	C	/C>C	C	r   )__name__
__module____qualname__r   r   r   r"    r   r   r   r      s    ---r   r   )app.backend.db.modelsr   json
sqlalchemyr   r   r&   r   r   <module>r*      s    +  %- %-r   