
    	,h0                     x    d dl mZmZ d dlmZ d dlmZmZmZm	Z	 d dl
mZmZmZ  G d de      Z G d de      Zy	)
    )	BaseModelField)Base)Mappedmapped_columnrelationshipSession)VARCHAR
ForeignKeyIntegerc                      e Zd ZU  ed      Zedz  ed<    ed      Zedz  ed<    ed      Z	edz  ed<    ed      Z
edz  ed<    ed      Zedz  ed<    ed      Zedz  ed<    ed      Zedz  ed	<    ed      Zedz  ed
<    ed      Zedz  ed<    ed      Zedz  ed<    ed      Zedz  ed<   y)VisualMerchElementsBaseN)default	visual_idtypeunitscost_per_unittotalremarkinternal_display_remarkexternal_display_remarkFrequency_change_per_year Frequency_change_per_year_remarkgroup_id)__name__
__module____qualname__r   r   int__annotations__r   strr   r   r   r   r   r   r   r   r        H/var/www/html/RetailAPI/app/models/main/visual_merchendising_elements.pyr   r      s    "40Id
0d+D3:+t,EC$J,!&t!4MC$J4t,EC$J,-FS4Z-+0+>cDj>+0+>cDj>-24-@d
@49$4G$sTzG!$/HsTz/r"   r   c            	          e Zd ZU dZ ededd      Zee   e	d<    ed e
d      dd      Zee   e	d<    ed	edd      Zee   e	d	<    ed
edd      Zee   e	d
<    ededd      Zee   e	d<    ed e
d      dd      Zee   e	d<    ed e
d      dd      Zee   e	d<    ed e
d      dd      Zee   e	d<    ededd      Zee   e	d<    ed e
d      dd      Zee   e	d<    ede ed      d      Zee   e	d<    edd      Zedededd fd       Zedededd fd       Zededededd fd       Zed ededd fd!       Zy)"TblVisualMerchElementstbl_visual_merch_elementsr   T)primary_keyautoincrementr      N)nullableserver_defaultr   r   r   r   r   r   r   r   r   ztbl_group.group_idF)r*   TblGroupvisual_merchandising_elements)back_populatesdatadbreturnc                 x    |j                         } | di |}|j                  |       |j                          |S )Nr!   )
model_dumpaddflush)clsr/   r0   	data_dictnew_datas        r#   createzTblVisualMerchElements.create&   s5    OO%	##
x

r"   visual_get_idc                 |    |j                  |       j                  | j                  |k(        j                         }|S N)queryfilterr   first)r6   r:   r0   get_datas       r#   !get_visual_merch_elements_data_idz8TblVisualMerchElements.get_visual_merch_elements_data_id.   s1    88C=''(FGMMOr"   visual_update_idc                 .   |j                  |       j                  | j                  |k(        j                         }|j	                         }|j                         D ]  \  }}|	t        |||        |j                          |j                  |       |S r<   )	r=   r>   r   r?   r3   itemssetattrcommitrefresh)r6   rB   r/   r0   update_datar7   keyvalues           r#   update_visual_merch_elements_idz6TblVisualMerchElements.update_visual_merch_elements_id3   s}    hhsm**3==<L+LMSSUOO%	#//+JC S%0 , 			


;r"   visual_delete_idc                     |j                  |       j                  | j                  |k(        j                         }|sy|j	                  |       |j                          y)NFT)r=   r>   r   r?   deleterF   )r6   rL   r0   delete_datas       r#   delete_visual_merch_elements_idz6TblVisualMerchElements.delete_visual_merch_elements_id>   sK    hhsm**3==<L+LMSSU
		+
		r"   ) r   r   r   __tablename__r   r   r   r   r   r   r
   r   r    r   r   r   r   r   r   r   r   r   r   r   groupclassmethodr   r	   r9   rA   rK   rP   r!   r"   r#   r%   r%      sC   /M+KdbfgIsg&vws|d[_`D6#;`'4X\]EF3K]"/SWhl"mMF3Km'4X\]EF3K](73<$_cdFVC[d,9:SU\]`Ualp  BF  -GfSk  G,9:SU\]`Ualp  BF  -GfSk  G.;<WY`ko  AE  /Fs  F5BCegnorgs  C  TX  6Y$vc{  Y*:w
K_@`kpqHvc{q4STE0 W @X   S W Ph   c H_ dk   pH   c g Qi  r"   r%   N)pydanticr   r   app.models.base_classr   sqlalchemy.ormr   r   r   r	   
sqlalchemyr
   r   r   r   r%   r!   r"   r#   <module>rX      s/    % & D D 2 20i 01T 1r"   