o g@sdZddlmZmZmZddlmZddlmZddl m Z ddl m Z ddl mZmZmZmZmZmZddlmZdd lmZdd lmZdd lmZdd lmZeZed Z eddgdddiigdZ!eZ"e!j#deddedefddZ$e!j%de edddZ&e!j%de edde'fddZ(e!j%d edd!e)fd"d#Z*e!j+d e j,d$d!e)defd%d&Z-e!j%d'e edd(d)Z.e!j#d*eddedefd+d,Z/e!j%d-ed.Bdde'd!e)fd/d0Z0e!1d1d!e)dedefd2d3Z2d.S)4zFinancial Information router) APIRouter HTTPExceptionRequest) JSONResponse)SQLAlchemyError) HTTPStatus)List) FinancialInformationPageResponseFinancialInformationPageCreate$FinancialInformationTemplateResponse!FinancialInformationTableResponseFinancialInformationTableCreateFinancialInformationPageUpdate)FinancialInformationPageService)#FinancialInformationTemplateService) FinancialInformationTableService) ServiceLogger)MySQLDBWARNINGz/financial_infofinancial_infoi descriptionz Not found)prefixtags responses dependenciesz/pages)response_model page_datarequestc fz|jj}tjtfd|i|IdH}|WSty2}ztd|t t j dd|d}~ww)z2 Create a new financial information page. current_userNzError creating page: %sInternal Server Error status_codedetail) staterrinsert_new_recordmysql_db model_dumprloggererrorrrINTERNAL_SERVER_ERROR)rrr created_pageer-6/var/www/html/XCapMarket/controllers/financial_info.py create_page$s(  r/c Nz ttIdH}|WSty&}ztd|ttjdd|d}~ww)z. Get all financial information pages. NError getting pages: %sr r!) rget_all_recordsr&rr(r)rrr*responser,r-r-r. get_pages:s r5z/pages/{project_id} project_idc sPz tt|IdH}|WSty'}ztd|ttjdd|d}~ww)z< Get all financial information pages for a project. Nr1r r!) rget_all_records_for_projectr&rr(r)rrr*)r6r4r,r-r-r.get_pages_for_projectIs  r8z/page/{page_id}page_idc s^ztt|IdH}|r|dWSWdSty.}ztd|ttjdd|d}~ww)z1 Get a financial information page by id. NrzError getting page: %sr r!) rget_record_by_idr&rr(r)rrr*)r9pager,r-r-r.get_page\s  r<)r"c slz|jj}tjt|d|dIdHttjddidWSty5}zt d|t tj dd |d}~ww) z> Mark a financial information page as inactive by id. F) is_activerNmessagez$Page marked as inactive successfully)r"contentz"Error marking page as inactive: %sr r!) r$rrupdate_record_by_idr&rrOKrr(r)rr*)r9rrr,r-r-r. delete_pagems&  rBz /templatesc r0)z2 Get all financial information templates. Nr1r r!) rr2r&rr(r)rrr*r3r-r-r. get_templatess rCz/save/{project_id}/{page_id}c r)z2 Save a financial information page by id. rNzError saving page: %sr r!) r$rr save_recordr&r'rr(r)rrr*)rrr saved_pager,r-r-r. save_pages(  rFz/table/{project_id}/{page_id}Nc sRz tt||IdH}|WSty(}ztd|ttjdd|d}~ww)z2 Get a financial information table by id. NzError getting table: %sr r!) rr:r&rr(r)rrr*)r6r9r4r,r-r-r. get_tables  rGz/pages/{page_id}c shz|jj}tjt|fd|i|IdH}|WSty3}ztd|t t j dd|d}~ww)z4 Update a financial information page by id. rNzError updating page: %sr r!) r$rrr@r&r'rr(r)rrr*)r9rrr updated_pager,r-r-r. update_pages(  rI)3__doc__fastapirrrfastapi.responsesrsqlalchemy.excrhttprtypingrschemas.financial_informationr r r r r r$services.financial_info.page_servicer!services.financial_info.templatesr%services.financial_info.table_servicer utils.loggerrutils.mysql_dbrservice_logger get_loggerr(rr&postr/getr5strr8intr<delete NO_CONTENTrBrCrFrGputrIr-r-r-r.st