o r–j\Iã@s&ddlZddlZddlmZddlmZddlmZddlm Z m Z ddl m Z ddl mZddlmZmZmZmZmZmZdd lmZdd lmZdd lmZed d ee d¡dZedƒZejd ddZdede fdd„Z!de"de"fdd„Z#de"de defdd„Z$de"de de"fdd „Z%dS)!éN)ÚPath)ÚOpenAI)ÚA4)ÚgetSampleStyleSheetÚParagraphStyle)Úinch)Úcolors)ÚSimpleDocTemplateÚ ParagraphÚSpacerÚTableÚ TableStyleÚ HRFlowable)Údatetime)ÚRequest)Ú load_dotenvT)ÚoverrideÚOPENAI_API_KEY)Úapi_keyÚreports)Úexist_oku¤You are a senior pharma quality investigator writing a GMP-compliant investigation report. STRICT RULES — NEVER BREAK THESE: 1. NEVER say product was not impacted without checking LIMS results first 2. If ANY LIMS result shows Status=Fail — impact_assessment MUST say product was impacted with exact test name and value 3. NEVER use generic phrases — always use exact values from the data 4. Severity MUST come from Deviation Report severity field — not your own judgment 5. ref_id MUST come from Deviation_ID in the Deviation Report 6. Duration MUST be calculated from Equipment Log timestamps — not estimated 7. Root cause MUST reference exact maintenance log observations — thermocouple, calibration dates, drift values 8. Operator MUST be included from Equipment Log Operator_ID field 9. Batch disposition MUST come from Deviation Report Batch_Disposition field 10. CAPA actions MUST reference actual work order IDs and actions from Maintenance Log Return JSON only with this exact structure: { "report_metadata": { "ref_id": string, "revision": "Rev 01", "status": "Audit Ready", "severity": one of ["Critical", "High", "Medium", "Low"], "generated_date": string, "batch_id": string, "product_name": string, "plant": string, "confidential": true }, "ai_generated_summary": string, "approval_workflow": { "qa_reviewer": { "name": string, "status": one of ["Approved", "Pending", "Rejected"], "note": string or null }, "qa_head": { "name": string, "status": one of ["Approved", "Pending Final Sign Off", "Rejected"] } }, "compliance_tags": array of strings, "sections": { "incident_overview": { "batch_number": string, "incident_date": string, "deviation_type": string, "department": string }, "detected_deviations": [ { "signal_exception": string, "duration": string, "peak_value": string, "limit": string, "is_deviation": true or false } ], "executive_summary": string, "deviation_description": string, "timeline": [ { "timestamp": string, "event": string, "severity": one of ["critical", "warning", "info"] } ], "scope_of_review": string, "exceptions_summary": string, "root_cause_analysis": { "probable_cause": string, "methodology": string, "conclusion": string }, "capa_summary": string, "impact_assessment": string, "conclusion": string, "regulatory_compliance": [ { "standard": string, "status": one of ["Compliant", "Non-Compliant", "Under Review"] } ] }, "compliance_checklist": [ { "standard": string, "description": string, "status": one of ["pass", "warn", "fail"] } ], "evidence_coverage_score": number 0-100, "confidence_label": one of ["High Confidence", "Medium Confidence", "Low Confidence"], "ai_insight": string, "export_options": ["Export as PDF", "Export as Word", "Submit to Regulatory"] } Section writing rules: ref_id: use Deviation_ID from Deviation Report exactly e.g. DEV-2024-0312 severity: copy exactly from Deviation Report Severity field executive_summary (4-5 sentences): - Name exact batch, product, plant, date - Name exact parameters that deviated with exact values and limits - Reference exact equipment ID - State LIMS outcome — if assay failed state exact % and OOS reference - State batch disposition from Deviation Report deviation_description (5-6 sentences): - Exact timestamp of first deviation from Equipment Log - Exact operator ID from Equipment Log - Progressive temperature rise with timestamps from Equipment Log - Exact peak value reached - What action was taken and when — from Deviation Report Immediate_Actions detected_deviations duration: - Calculate from Equipment Log — time from first Alert status to process stopped - Do NOT estimate — use actual timestamps root_cause_analysis.probable_cause: - Reference exact equipment ID - Reference calibration due date and overdue days from Maintenance Log - Reference thermocouple drift value (+X°C) from Maintenance Log breakdown inspection - Reference work order ID root_cause_analysis.conclusion (4-5 sentences): - Name the exact root cause with evidence - Reference Maintenance Log dates and observations - Reference Equipment Log notes at Alert rows - Reference calibration overdue status impact_assessment — CRITICAL RULE: - CHECK LIMS results first — if any Status=Fail → product WAS impacted - State exact test name, result value, specification, OOS reference number - State batch disposition — HOLD or released - If assay failed — state this clearly: "Assay result of X% is below specification of Y%-Z%" - NEVER say "no impact" if LIMS has any Fail result capa_summary: - List actual CAPA actions from Maintenance Log Action_Taken field - Reference work order IDs - Reference new parts installed - Reference requalification report if available conclusion: - State current batch status from Deviation Report Batch_Disposition - State OOS investigation reference if LIMS failed - State whether equipment was returned to service Data to generate report from: ÚrequestÚreturncCst|jƒ d¡S)Nú/)ÚstrÚbase_urlÚrstrip)r©rú*/var/www/html/fyndo/pharma/fyndo/report.pyÚ get_base_url­srÚdatac Ãs z5tj|dd}t d|dd…¡}tjjjddddœd |dœgd d id d }|jd j j }t  |¡}|WSt yO}z dt |ƒdœWYd}~Sd}~ww)Né)Úindentz i'zgpt-4oÚsystemuÕYou are a senior pharma quality investigator. CRITICAL INSTRUCTIONS: - Always check LIMS results before writing impact assessment - If LIMS has any Fail result — product was impacted — say so with exact values - Never say product was not impacted without evidence - Use exact values from data — no generic statements - Severity comes from Deviation Report — not your judgment - ref_id comes from Deviation_ID in Deviation Report Return JSON only. No extra text.)ÚroleÚcontentÚuserÚtypeÚ json_objectr)ÚmodelÚmessagesÚresponse_formatÚ temperatureÚerror)Ústatusr-)ÚjsonÚdumpsÚ REPORT_PROMPTÚreplaceÚclientÚchatÚ completionsÚcreateÚchoicesÚmessager%ÚloadsÚ Exceptionr)r Údata_strÚpromptÚresponseÚrawÚresultÚerrrÚgenerate_report_json±s.€þ þóë €ÿrAÚreportÚfilenamec&s, t|}tt|ƒtdtdtdtdtd}tƒ}g‰t d¡}t d¡}t d¡}td|ddd |d d d }td |dd|dd} td|ddd |ddd‰td|dd|ddd‰td|dd|d ddd} |  di¡} |  di¡} |  dg¡} |   dd ¡  ¡}ˆ  t d!|›d"|ƒ¡ˆ  t d#|   d$d%¡›d&|   d'd(¡›d&|   d)¡r©d*nd+›| ƒ¡ˆ  t d,|   d-d.¡›d/|   d0t  ¡ d1¡¡›| ƒ¡ˆ  td2dƒ¡d3|   d4d5¡d6|   d7d5¡gd8|   d9d5¡d:|gg}t|d;tdd?d@|fdAdBdCdDd?d@|fdEd?d@dFt dG¡fdHgƒ¡ˆ  |¡ˆ  td2dƒ¡ˆ  tdId2t dG¡dJ¡|  dKd+¡}|rVˆ  td2dƒ¡ˆ  t dLˆƒ¡ˆ  t |ˆƒ¡‡‡‡fdMdN„}|   dOi¡}|r݈  td2dƒ¡ˆ  t dPˆƒ¡ˆ  tdIdFt dG¡dJ¡ˆ  td2dƒ¡gdQ¢|  dRd5¡|  dSd5¡|  dTd5¡|  dUd5¡gg}t|dVtdVtdtdVtgd=}| td>d?dWt dG¡fdXdCdDd?d@|fdEd?d@dFt dG¡fdYgƒ¡ˆ  |¡|   dZg¡}|rnˆ  td2dƒ¡ˆ  t d[ˆƒ¡ˆ  tdIdFt dG¡dJ¡ˆ  td2dƒ¡gd\¢g}|D]}|  |  d]d5¡|  d^d5¡|  d_d5¡|  d`d5¡g¡qt|dd?dWt dG¡fdXdCdDd?d@|fdEd?d@dFt dG¡fdYdbdcd@tj|gfgƒ¡ˆ  |¡|ddde|   dfd+¡ƒ|d dg|   dhd+¡ƒˆ  td2dƒ¡ˆ  t diˆƒ¡ˆ  tdIdFt dG¡dJ¡ˆ  td2dƒ¡|   dji¡}|rdkdlg|  dmd5¡|  dnd5¡gdod+g|  dpd5¡d+gg}t|dqtdqtgd=}| td>d?dWt dG¡fd>drdst dG¡fdXdtdCdDd?d@|fdEd?d@dFt dG¡fdYdudvg ƒ¡ˆ  |¡|ddw|   dxd+¡ƒ|dydz|   d{d+¡ƒ|dd||   d}d+¡ƒ|d~d|   d€d+¡ƒ|dd|   dpd+¡ƒ|   d‚g¡}|r¹ˆ  td2dƒ¡ˆ  t dƒˆƒ¡ˆ  tdIdFt dG¡dJ¡ˆ  td2dƒ¡d„d…gg}|D]}|  |  d†d5¡|  d-d5¡g¡qmt|d td‡tgd=} |  td>d?dWt dG¡fdXdCdDd?d@|fdEd?d@dFt dG¡fdYdbdcd@tj|gfgƒ¡ˆ  | ¡| rHˆ  td2dƒ¡ˆ  t dˆˆƒ¡ˆ  tdIdFt dG¡dJ¡ˆ  td2dƒ¡gd‰¢g}!| D]#}"|"d-dŠkród‹n |"d-dŒkrüdndŽ}#|!  |"d†|"d|#g¡qèt|!dtd td;tgd=}$|$ td>d?dWt dG¡fdXdCdDd?d@|fdEd?d@dFt dG¡fdHdbdcd@tj|gfgƒ¡ˆ  |$¡ˆ  td2dƒ¡ˆ  tdId2t dG¡dJ¡ˆ  td2dƒ¡ˆ  t d|  d‘d’¡›d“|  d”d+¡›| ƒ¡|  d•d+¡}%|%rˆ  t d–|%›ˆƒ¡| ˆ¡|S)—Ngè?)ÚpagesizeÚ rightMarginÚ leftMarginÚ topMarginÚ bottomMarginz#1a1916z#7a7869z#f5f4f0ÚTitleÚNormaléúHelvetica-Boldéé)ÚparentÚfontSizeÚfontNameÚ textColorÚ spaceAfterÚleadingÚSubé r!)rOrPrRrSÚH1ééé)rOrPrQrRÚ spaceBeforerSÚBodyé)rOrPrRrTrSÚLabelé )rOrPrRrQrSrTÚreport_metadataÚsectionsÚcompliance_checklistÚseverityÚCriticalz-INVESTIGATION REPORT [z SEVERITY]zRef ID: Úref_idzDEV-2024-00001z | ÚrevisionzRev 01Ú confidentialÚ CONFIDENTIALÚzStatus: r.z Audit Readyz | Generated: Úgenerated_datez%Y-%m-%dézBatch IDÚbatch_idu—ÚProductÚ product_nameÚPlantÚplantÚSeverityg333333ó?g@)Ú colWidthsÚ BACKGROUND©rr©éÿÿÿÿrv)ÚFONTNAMErt)rrvrL)rw)r!r)r!rvrL)ÚFONTSIZErtrué Ú TEXTCOLORÚGRIDçà?ú#e2e0d8)ÚPADDINGrtrurZú100%©ÚwidthÚ thicknessÚcolorÚai_generated_summaryzAI Generated Summarycstˆ tddƒ¡ˆ t|›d|›ˆƒ¡ˆ tddt d¡d¡ˆ tddƒ¡|r8ˆ tt|ƒˆƒ¡dSdS) NrkrVz. rr|r}r€rZ)Úappendr r rrÚHexColorr)ÚnumberÚtitler%©Ú body_styleÚh1_styleÚstoryrrÚ add_section$sÿz!generate_pdf..add_sectionÚincident_overviewz01. Incident Overview)z BATCH NUMBERz INCIDENT DATEzDEVIATION TYPEÚ DEPARTMENTÚ batch_numberÚ incident_dateÚdeviation_typeÚ departmentgü?©rvr)rwrtr”rL)r~rtrur]Údetected_deviationsz02. Detected Deviations)zSIGNAL/EXCEPTIONÚDURATIONz PEAK VALUEÚLIMITÚsignal_exceptionÚdurationÚ peak_valueÚlimitgø?ÚROWBACKGROUNDS)rrkézExecutive SummaryÚexecutive_summaryzDeviation DescriptionÚdeviation_descriptionz05. Root Cause AnalysisÚroot_cause_analysiszPROBABLE CAUSEÚ METHODOLOGYÚprobable_causeÚ methodologyÚ CONCLUSIONÚ conclusiong @©rr!©rvr!)rwr¦r§rL)ÚSPANr¦)rkr!)r¨)rr)rkrzScope of ReviewÚscope_of_reviewéÚ ExceptionsÚexceptions_summaryÚCAPAÚ capa_summaryryzImpact AssessmentÚimpact_assessmentÚ ConclusionÚregulatory_compliancez11. Regulatory ComplianceÚStandardÚStatusÚstandardgš™™™™™ @zCompliance Checklist)r²Ú Descriptionr³Úpassu✓ PassÚwarnu âš  Reviewu✗ FailÚ descriptionzEvidence Coverage Score: Úevidence_coverage_scoreru% — Úconfidence_labelÚ ai_insightz AI Insight: )Ú REPORTS_DIRr rrrrrr†rÚgetÚupperr…r rÚnowÚstrftimer r ÚsetStyler rÚwhiteÚbuild)&rBrCÚfilepathÚdocÚstylesÚdarkÚmutedÚlight_bgÚ title_styleÚ sub_styleÚ label_styleÚmetaraÚ checklistrcÚ batch_dataÚ batch_tableÚ ai_summaryrÚincÚinc_dataÚ inc_tableÚdevsÚdev_dataÚdÚ dev_tableÚrcaÚrca_dataÚ rca_tableÚreg_complianceÚreg_dataÚrÚ reg_tableÚ check_dataÚitemÚ status_textÚ check_tabler»rr‰rÚ generate_pdfÖs–ú     þ ÿ þ ÿ þ    þ2þ(þþ$  ù       üþ$  ú        ü$ ù  ü ö   " ù  ( ù þ  rärcÃstt|ƒIdH}| di¡ dd¡}t ¡ d¡}d|›d|›d}t||ƒ||d<|›d |›|d <d |d <|S) Nr`rlÚBATCHz %Y%m%d_%H%M%SÚInvestigation_Report_Ú_z.pdfÚ pdf_filenamez/reports/download/Ú download_urlÚ completedr.)rAr½rr¿rÀrä)r rÚ report_jsonrlÚ timestamprCrrrÚgenerate_full_reportÃs€ rí)&Úosr/ÚpathlibrÚopenairÚreportlab.lib.pagesizesrÚreportlab.lib.stylesrrÚreportlab.lib.unitsrÚ reportlab.librÚreportlab.platypusr r r r r rrÚfastapirÚdotenvrÚgetenvr3r¼Úmkdirr1rrÚdictrArärírrrrÚs.           %n