o `Ai/ @sddlZddlmZmZddlmZddlmZddlm Z ee j dZ dde d e d efd d Zd ede d ee e ffddZdS)N)DictList)OpenAI) embed_query)config)api_keydquerykreturnc Cst|}|j||d}i}|D]1}|d}|dd}|d|} ||vr,| gd||<||d|dd |d d d qt||} |d d|D| dS)zk Build a comprehensive 20-25 page report. Increased retrieval and detailed section generation. )r metadatadoc_idUnknowndoc_name)rchunksr page_number?text)pagercSsg|]}|dqS)r).0inforr@/var/www/html/fyndo/python/python_agents/rag_suite/rag/report.py *sz+build_report_from_query..)r docssections)rsearchgetappend&generate_comprehensive_report_sectionsvalues) storer r qvechits doc_chunkshitmetar rrrrrbuild_report_from_query s(      r(r%c Csi}d}|D]7\}}|ddd7}|d|dd7}|dd7}|ddd D]}|d |d d |d d7}q-qddddddddddddddddddddddddddddddd }|D]e\}} td|dd|d|dd d!|d"| d#d$ } ztjjjtjd%| d&gd'| d(d)} | jd*j j ||<Wqot y} ztd+|d,| d-t | ||<WYd} ~ qod} ~ ww|S).z Generate detailed, comprehensive report sections for 20-25 pages. Each section gets more tokens and detailed instructions. rz z<============================================================ z DOCUMENT: rrNz[Page rz] raUProvide a comprehensive executive summary (2-3 pages) that includes: - Overview of all companies analyzed - Key highlights and major findings - Critical risks and opportunities - Overall financial health assessment - Strategic recommendations Be detailed and professional. Include specific numbers, percentages, and facts from the documents.i) instruction max_tokensa)Provide detailed company overview including: - Company history and establishment - Business model and operations - Market position and competitors - Geographic presence and facilities - Key milestones and achievements - Corporate structure Provide 2-3 paragraphs per company with specific details.aProvide comprehensive analysis of leadership: - Board of Directors: names, designations, qualifications - Key Management Personnel with roles - Management changes during the year - Experience and expertise of leadership team - Board composition (independent vs executive directors) - Board committees and their roles Present in detailed narrative form with specific names and positions.aCDetailed shareholding analysis including: - Promoter shareholding with exact percentages - Institutional investors and their stakes - Public shareholding breakdown - Changes in shareholding during the year - Top 10 shareholders if available - Any pledge or encumbrance of shares Present specific numbers and analyze trends.alComprehensive financial analysis covering: - Revenue trends over 3-5 years with specific numbers - Profitability metrics (PAT, EBITDA margins) - Cash flow analysis - Balance sheet highlights (assets, liabilities, equity) - Key financial ratios - Year-over-year growth rates - Comparison with previous years Provide detailed numerical analysis with interpretations.ia]Detailed operational analysis: - Core business activities and products/services - Production capacity and utilization - Market segments served - Sales and distribution channels - Technology and R&D initiatives - Strategic partnerships and collaborations - Expansion plans and capital expenditure Provide comprehensive details with specific examples.a'Comprehensive risk analysis including: - Business and operational risks - Financial risks (credit, liquidity, market) - Regulatory and compliance risks - Industry-specific risks - Mitigation strategies for each risk - Risk management framework Provide detailed explanation of each risk category.a0Detailed governance analysis: - Corporate governance framework - Board meetings and attendance - Audit committee and other committees - Internal controls and compliance - Related party transactions - Code of conduct policies - Stakeholder engagement Provide comprehensive details on governance practices.a3Detailed compliance and legal analysis: - Regulatory framework applicable - Compliance status with key regulations - Legal proceedings if any - Statutory auditor observations - Secretarial audit findings - Penalties or fines if any - Compliance certifications Provide specific details on compliance matters.a8Comprehensive forward-looking analysis: - Industry trends and outlook - Company's strategic initiatives - Growth opportunities and challenges - Management's future plans - Analyst recommendations - Potential catalysts for growth - Key monitoring points for stakeholders Provide detailed forward-looking insights.) z1. Executive Summaryz 2. Company Overview & Backgroundz3. Directors & Managementz#4. Shareholding Pattern & Ownershipz!5. Financial Performance Analysisz!6. Business Operations & Strategyz7. Risk Assessment & Managementz8. Corporate Governancez 9. Regulatory Compliance & Legalz$10. Future Outlook & Recommendationsz Generating: z...zbYou are a professional financial analyst writing a detailed annual report section. Report Query: z9 Context from documents (use ALL relevant information): i:z Section: z Task: r+a IMPORTANT: - Be comprehensive and detailed - Use specific facts, numbers, and names from the documents - Cite sources as [Document Name, Page X] - Write in professional, formal language - Aim for 2-3 pages of content per section - Include all relevant details found in the context - Do not write "based on the context" or similar meta-commentary - Write as if you are directly presenting the findings Output:user)rolecontentg333333?r,)modelmessages temperaturer,ru ⚠️ Error generating z: zError generating this section: )itemsprintclientchat completionscreater LLM_MODELchoicesmessager/strip Exceptionstr) r%r r full_contextr rchunksection_prompts section_name config_dictpromptresponseerrrr /s              r )r)jsontypingrropenairrag.qarragrOPENAI_API_KEYr5r>intr(r rrrrs    "$