File size: 11,130 Bytes
fb5dc87
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
"""
Reference Search Module for Agricultural Analysis
Searches Firestore database for relevant references
"""

import logging
from typing import List, Dict, Any
from datetime import datetime

# Configure logging
logging.basicConfig(level=logging.INFO)
logger = logging.getLogger(__name__)

try:
    # Use our configured Firestore client instead of direct import
    from utils.firebase_config import get_firestore_client
    FIRESTORE_AVAILABLE = True
except ImportError:
    FIRESTORE_AVAILABLE = False
    logger.warning("Firestore not available. Database search will be disabled.")


class ReferenceSearchEngine:
    """Search engine for finding relevant references from database"""
    
    def __init__(self):
        self.firestore_client = None
        self._initialize_clients()
    
    def _initialize_clients(self):
        """Initialize Firestore client"""
        # Initialize Firestore client
        if FIRESTORE_AVAILABLE:
            try:
                self.firestore_client = get_firestore_client()
                if self.firestore_client:
                    logger.info("Firestore client initialized successfully")
                else:
                    logger.warning("Firestore client returned None - check Firebase configuration")
            except Exception as e:
                logger.error(f"Failed to initialize Firestore client: {str(e)}")
        else:
            logger.warning("Firestore not available - database search disabled")
    
    def search_database_references(self, query: str, limit: int = 5) -> List[Dict[str, Any]]:
        """Search for references in Firestore reference_documents collection with enhanced PDF support"""
        if not self.firestore_client:
            logger.warning("Firestore client not available")
            return []
        
        try:
            # Search in reference_documents collection
            ref = self.firestore_client.collection('reference_documents')
            
            # Get more documents to filter (increased from limit * 3 to limit * 5)
            docs = ref.limit(limit * 5).stream()
            
            results = []
            for doc in docs:
                doc_data = doc.to_dict()
                doc_data['id'] = doc.id
                
                # Enhanced content extraction for PDFs
                title = self._extract_pdf_title(doc_data)
                content = self._extract_pdf_content(doc_data)
                file_type = doc_data.get('file_type', '').lower()
                file_name = doc_data.get('file_name', '')
                
                # Check if query terms appear in title, content, or tags
                searchable_text = f"{title} {content} {doc_data.get('tags', '')}".lower()
                query_terms = query.lower().split()
                
                if any(term in searchable_text for term in query_terms):
                    result = {
                        'id': doc.id,
                        'title': title,
                        'content': content,
                        'source': 'Database',
                        'url': doc_data.get('url', ''),
                        'tags': doc_data.get('tags', []),
                        'created_at': doc_data.get('created_at', ''),
                        'relevance_score': self._calculate_relevance_score(query_terms, searchable_text),
                        'file_type': file_type,
                        'file_name': file_name
                    }
                    
                    # Add PDF-specific information
                    if file_type == 'pdf' or file_name.lower().endswith('.pdf'):
                        result.update({
                            'pdf_title': doc_data.get('pdf_title', title),
                            'pdf_abstract': doc_data.get('pdf_abstract', ''),
                            'pdf_keywords': doc_data.get('pdf_keywords', []),
                            'pdf_authors': doc_data.get('pdf_authors', []),
                            'pdf_pages': doc_data.get('pdf_pages', 0),
                            'pdf_language': doc_data.get('pdf_language', 'en')
                        })
                    
                    results.append(result)
            
            # Sort by relevance and limit results
            results.sort(key=lambda x: x['relevance_score'], reverse=True)
            logger.info(f"Found {len(results)} relevant database references for query: {query}")
            return results[:limit]
            
        except Exception as e:
            logger.error(f"Error searching database references: {str(e)}")
            return []
    
    def _extract_pdf_title(self, doc_data: Dict[str, Any]) -> str:
        """Extract PDF title with fallback options"""
        # Try different title fields in order of preference
        title_fields = ['pdf_title', 'title', 'document_title', 'name']
        
        for field in title_fields:
            title = doc_data.get(field, '').strip()
            if title and len(title) > 3:  # Valid title
                return title
        
        # Fallback to filename without extension
        file_name = doc_data.get('file_name', '')
        if file_name:
            name_without_ext = file_name.rsplit('.', 1)[0] if '.' in file_name else file_name
            if name_without_ext:
                return name_without_ext.replace('_', ' ').replace('-', ' ').title()
        
        return 'Untitled Document'
    
    def _extract_pdf_content(self, doc_data: Dict[str, Any]) -> str:
        """Extract PDF content with fallback options"""
        # Try different content fields in order of preference
        content_fields = ['pdf_content', 'content', 'text_content', 'extracted_text', 'abstract']
        
        for field in content_fields:
            content = doc_data.get(field, '').strip()
            if content and len(content) > 50:  # Substantial content
                # Truncate very long content to avoid token limits
                if len(content) > 2000:
                    content = content[:2000] + "..."
                return content
        
        # If no substantial content, try to build from available fields
        content_parts = []
        
        # Add abstract if available
        abstract = doc_data.get('pdf_abstract', '').strip()
        if abstract:
            content_parts.append(f"Abstract: {abstract}")
        
        # Add keywords if available
        keywords = doc_data.get('pdf_keywords', [])
        if keywords:
            content_parts.append(f"Keywords: {', '.join(keywords)}")
        
        # Add tags if available
        tags = doc_data.get('tags', [])
        if tags:
            content_parts.append(f"Tags: {', '.join(tags)}")
        
        return ' '.join(content_parts) if content_parts else 'No content available'
    
    
    def _calculate_relevance_score(self, query_terms: List[str], text: str) -> float:
        """Calculate relevance score based on term frequency"""
        score = 0.0
        text_lower = text.lower()
        
        for term in query_terms:
            if term in text_lower:
                # Count occurrences
                count = text_lower.count(term)
                score += count * 0.1
                
                # Bonus for title matches
                if term in text_lower[:100]:  # First 100 chars (likely title)
                    score += 0.5
        
        return min(score, 1.0)  # Cap at 1.0
    
    def search_all_references(self, query: str, db_limit: int = 8) -> Dict[str, Any]:
        """Search database for references"""
        logger.info(f"Searching database references for query: {query}")
        
        # Search database references only
        db_results = self.search_database_references(query, db_limit)
        logger.info(f"Found {len(db_results)} database references")
        
        return {
            'database_references': db_results,
            'web_references': [],  # Empty list for compatibility
            'total_found': len(db_results),
            'search_query': query,
            'search_timestamp': datetime.now().isoformat()
        }
    
    def format_references_for_display(self, references: Dict[str, List[Dict[str, Any]]]) -> str:
        """Format references for display in results"""
        if not references or references.get('total_found', 0) == 0:
            return "No relevant references found."
        
        formatted_text = []
        formatted_text.append("## 📚 Research References")
        formatted_text.append("")
        
        # Database references only
        db_refs = references.get('database_references', [])
        if db_refs:
            formatted_text.append("### 🗄️ Database References")
            formatted_text.append("")
            for i, ref in enumerate(db_refs, 1):
                formatted_text.append(f"**{i}. {ref['title']}**")
                formatted_text.append(f"   - Source: {ref['source']}")
                if ref.get('url'):
                    formatted_text.append(f"   - URL: {ref['url']}")
                if ref.get('tags'):
                    formatted_text.append(f"   - Tags: {', '.join(ref['tags'])}")
                formatted_text.append(f"   - Relevance: {ref.get('relevance_score', 0):.2f}")
                formatted_text.append("")
        
        return "\n".join(formatted_text)
    
    def get_reference_summary(self, references: Dict[str, List[Dict[str, Any]]]) -> str:
        """Get a comprehensive summary of references for inclusion in analysis"""
        if not references or references.get('total_found', 0) == 0:
            return "No relevant references found to support this analysis."
        
        db_count = len(references.get('database_references', []))
        
        summary_parts = []
        summary_parts.append(f"Analysis supported by {db_count} database reference(s).")
        
        # Add key insights from top references
        all_refs = references.get('database_references', [])
        if all_refs:
            # Sort by relevance score
            sorted_refs = sorted(all_refs, key=lambda x: x.get('relevance_score', 0), reverse=True)
            
            # Add top 3 references
            top_refs = sorted_refs[:3]
            summary_parts.append("Key references:")
            
            for i, ref in enumerate(top_refs, 1):
                title = ref.get('title', 'Untitled')[:100]  # Truncate long titles
                source = ref.get('source', 'Unknown')
                score = ref.get('relevance_score', 0)
                summary_parts.append(f"{i}. {title} ({source}, relevance: {score:.2f})")
            
            # Add PDF-specific information if available
            pdf_refs = [ref for ref in all_refs if ref.get('file_type') == 'pdf' or ref.get('file_name', '').lower().endswith('.pdf')]
            if pdf_refs:
                summary_parts.append(f"Found {len(pdf_refs)} PDF research documents with detailed content.")
        
        return " ".join(summary_parts)


# Global instance
reference_search_engine = ReferenceSearchEngine()