
    7i                         d dl mZmZ ddlmZ ddlmZmZ d dlm	Z	m
Z
  e       Z e       Zej                  de      defd	       Zej                  d
e      de	eef   fd       Zy)    )	APIRouterHTTPException   )StudentExcelService)StudentDataInputExcelUpdateResponse)DictAnyz/save-student-data)response_modeldatac                   K   	 t         j                  | j                  | j                        }t	        ddt        | j                         dt        | j                              S # t        $ r}t        dt        |            d}~ww xY ww)z%Save student UI form data to databasesuccesszSaved z form fields to databasestatusmessagerecords_saved  status_codedetailN)	servicesave_student_data
student_id	form_datar   len	Exceptionr   str)r   resultes      C/var/www/html/retail-simulation-api/app/api/student_excel/router.pyr   r   	   sz     <**4??DNNK"S011IJdnn-
 	

  <CF;;<s)   BA!A& %B&	B
/BB

Bz/update-excelc                   K   	 | j                  d      }|st        dd      t        j                  |      }t	        dd|j                  dd       |d	   
      S # t
        $ r}t        dt        |            d}~ww xY ww)z-Update existing Excel file with database datar   i  zstudent_id requiredr   r   zExcel updated: 
excel_pathzFile updatedupdated_cellsr   r   N)getr   r   update_excel_with_database_datar   r   r   )r   r   r   r   s       r    update_excel_filer&      s     <XXl+
C8MNN88D"%fjj~&N%OP 1
 	

  <CF;;<s)   BAA B	B&A<<BBN)fastapir   r   r   r   schemar   r   typingr	   r
   
stu_routerpostr   r   r&        r    <module>r.      s|    , ( 9 [


%6IJ
<"2 
< K
< 1DE<$sCx. < F<r-   