o Uh@s"ddlmZmZmZddlmZddlmZddlm Z ddl m Z m Z ddl mZddlmZmZmZmZdd lmZmZdd lZdd lZdd lmZeZejd d dee ee fdedede fddZejdd dee ee fdedede fddZej dd dee ee fdedede fddZ!ej"ded dee ee fde#dede fddZ$ej%dd dee ee fde#dede fd d!Z&d"ej'd#e(fd$d%Z)ed&ed'd(d)ee ee fd*e#dede fd+d,Z*ed-ed'd.d)ee ee fd*e#dede fd/d0Z+d S)1) APIRouterDependsQuery)Session)service)get_db)JWTPayloadSchemaget_current_student)TblStoreFormat)StoreFormateCreateStoreFormateResponseStoreFormateUpdateStoreFormateCreate11) JSONResponseStreamingResponseN)FPDFz/store-formateT)response_model_exclude_nonerequestdbtokenct|||IdHSN)rStoreFormateServicecreate_store_formaterrrr7/var/www/html/RetailAPI/app/api/store_formate/router.pyrrz/store-formatescCst||}||Sr)rrcreate_store_format3)rrrservice_instancerrrcreate_store_formate111s  r!z/store-formate/updatecrr)rrupdate_store_formaterrrrupdate_store_formatrr#z/store-formate/{store_id})response_modelrstore_idcrr)rrget_store_formater%rrrrrr&rr&z /store-formate/delete/{store_id}crr)rrdelete_store_formater'rrr delete_store rr)dfreturncCst}||jddd|jt|jd}|jd}|jD] }|j|||ddq ||| D]\}}|D] }|j||t |ddq;||q5|j dd d S) NArial )sizer g?)borderS)destlatin1) radd_pageset_fontwlencolumns font_sizecelllniterrowsstroutputencode)r*pdf col_width row_heightcol_name_rowitemrrrdf_to_pdf_bytes%s    rFz/store-formate/download.zGroup ID to filter data) descriptiongroup_idcs|ttj|k}|stdd|dddSdd|D}t|}t|}t |}| dt |d d d |d id S)N0z+No store format records found for group_id .statusmessagecontentcSg|]}|qSras_dict.0recordrrr Hz3download_store_formate_by_group..rzapplication/pdfContent-Disposition(attachment; filename=store_format_group_z.pdf media_typeheaders) queryr filterrHallrpd DataFramerFioBytesIOseekr)rHrr all_recordsdatar* pdf_bytes pdf_streamrrrdownload_store_formate_by_group;s   riz/store-formate/download-htmlz$Group ID to filter store format datac s|ttj|k}|stdd|dddSdd|D}t|}|jdd }d |d |d }t |}| d t |ddd|didS)NrIzNo records found for group_id rJrKrNcSrPrrQrSrrrrVcrWz/download_store_formate_html..F)indexaw Store Format Report

Store Format Report (Group ID: z)

z rzapplication/octet-streamrXrYz.htmlrZ) r]r r^rHr_rr`rato_htmlrbStringIOrdr) rHrrrecordsrfr* html_content html_pagestreamrrrdownload_store_formate_htmlXs&      rq),fastapirrrsqlalchemy.ormrapp.api.store_formaterapp.database.main.mysqlrapp.dependency.authanticationrr app.models.main.store_formater schemasr r rrfastapi.responsesrrrbpandasr`fpdfrstore_formate_routerpostrr!putr#getintr&deleter)rabytesrFrirqrrrrsZ      & & && &