H(i d dl mZ d dlmZmZmZmZmZmZ d dl m
Z
d dl m Z d dl
mZ d dlmZmZ d dlmZ dd lmZmZmZ d d
lmZmZ d d lZd d l Z d d l m Z e Z e jC d
d ee ee fdede
defd Z"e jC dd e ed ee ee fdedede
defd Z#e jI dd e ed ee ee fde%dedede
def
d Z&e jO dd ee ee fde%de
defd Z(e jS d d ee ee fde%de
defd Z*d e jV d e,fd!Z-e jC d" ed#d$% ee ee fde%de
defd& Z.e jC d' ed#d(% ee ee fde%de
defd) Z/y )* )Optional) APIRouterDependsFileFormQuery
UploadFile)Session)service)get_db)JWTPayloadSchemaget_current_student)TblStoreFormat )StoreFormateCreateStoreFormateUpdateStoreFormateCreate11) JSONResponseStreamingResponseN)FPDFz/store-formateT)response_model_exclude_nonerequestdbtokenc h K t j || j | d { S 7 wN)r StoreFormateServicecreate_store_formate)r r r s C/var/www/html/retail-simulation-api/app/api/store_formate/router.pyr r s* ,,R6KKGT TT T )202z/store-formatesupload_store_layoutc R t j || }|j | | S r )r r create_store_format3)r r! r r service_instances r create_store_formate111r% s) 222u= 0 0:M NN z/store-formate/updatestore_idc p K t j || }|j | || d { S 7 wr )r r update_store_formate)r' r r! r r r$ s r update_store_formatr* s7 222u=!66xJ]^ ^^ ^s -646z/store-formate/{group_id}group_idc h K t j || j | d { S 7 wr )r r get_store_formate)r+ r r s r r- r- ) s* ,,R7II(S SS Sr z /store-formate/delete/{store_id}c h K t j || j | d { S 7 wr )r r delete_store_formate)r' r r s r delete_storer0 - s* ,,R7LLXV VV Vr dfreturnc t }|j |j dd |j t | j
dz z }|j dz }| j
D ] }|j |||d |j | | j D ]; \ }}|D ] }|j ||t | d " |j | = |j d j d S )
NArial
)sizer g ?)borderS)destlatin1)
r add_pageset_fontwlencolumns font_sizecelllniterrowsstroutputencode)r1 pdf col_width
row_heightcol_name_rowitems r df_to_pdf_bytesrN 2 s
&CLLNLLrL"RZZ 1,-I $J JJ J; FF: ++-3D HHY
CIaH @ z
::3: & &x 00r& z/store-formate/download.zGroup ID to filter data) descriptionc K |j t j t j | k( j }|st dd| dd S |D cg c] }|j
}}t j | }t | }t j | }|j d t |ddd | d
i S c c}w w) N0z+No store format records found for group_id .statusmessagecontentr zapplication/pdfContent-Disposition(attachment; filename=store_format_group_z.pdf
media_typeheaders)queryr filterr+ allr as_dictpd DataFramerN ioBytesIOseekr ) r+ r r all_recordsrecorddatar1 pdf_bytes
pdf_streams r download_store_formate_by_grouprk H s ((>*11.2I2IX2UVZZ\K sAlmulvvw?x$yzz ,7 7;FNN ;D 7 d B #II&JOOA $&*RS[R\\`(ab 8s A C C6A!Cz /store-formate/download-htmlz$Group ID to filter store format datac K |j t j t j | k( j }|st dd| dd S |D cg c] }|j
}}t j | }|j d }d| d | d
}t j | } | j d t | d d
d| di S c c}w w)NrQ z No records found for group_id rR rS rV F)indexaw
Store Format Report
Store Format Report (Group ID: z)
z
r zapplication/octet-streamrX rY z.htmlrZ )r] r r^ r+ r_ r r` ra rb to_htmlrc StringIOre r )
r+ r r recordsrg rh r1 html_content html_pagestreams
r download_store_formate_htmlrt e s hh~&--n.E.E.QRVVXG sA_`h_iij?k$lmm+2 37FNN 7D 3 d B::E:*L , -5: 6 I$ [[
#F
KKN -&*RS[R\\a(bc 3 4s A C' C"6A1C')0typingr fastapir r r r r r sqlalchemy.ormr
app.api.store_formater app.database.main.mysqlr app.dependency.authanticationr
r app.models.main.store_formater schemasr r r fastapi.responsesr r rc pandasra fpdfr store_formate_routerpostr r% putintr* getr- deleter0 rb bytesrN rk rt r& r r s E E " ) * O 8 Q Q = { +MFMfopw yL qM U(: Ug U]m U NU ,$O