☎
✉
🌐
| # | Description | Qty | Rate | Amount |
|---|---|---|---|---|
| 1 | Sample Cost Online survey fielding & data collection (Avg LOI: min) |
completes | ||
| 2 | Respondent Incentive Panel member incentive payments |
completes |
Update affiliate information for
Complete information for
No signups yet
| Clicked At | Signed Up | Verified | Reward | Status | |
|---|---|---|---|---|---|
| Not completed'; ?> | ✅ Pending | ✅ Not verified | ₹ Pending | Complete Awaiting Verification Clicked Only |
View and manage client information
No documents uploaded yet
Manage client accounts and projects
| ID | Client Code | Company Name | Industry | Contact Person | Location | Email & Phone | Projects | Revenue | Status | Actions |
|---|---|---|---|---|---|---|---|---|---|---|
| No clients found. Click "Add New Client" to create one. | ||||||||||
| # |
|
₹ | ||||||||
Market insights and demand forecasting for strategic decisions
Recommended Action:
Our technical team is available 24/7 to help resolve system issues.
Manage pricing, invoices & financial settings
Test your pricing by entering an LOI. Uses the saved rates above and live exchange rates.
No invoices found. Invoices are auto-generated when projects are closed.
| Invoice # | Client | Project | Curr | N | Total | Invoiced | Due | Status | Actions |
|---|---|---|---|---|---|---|---|---|---|
| 📄 |
* All amounts are inclusive of applicable taxes
-------------------- END OF FILE -------------------- FILE: RR SHOP/generate_hash.php TYPE: PHP SIZE: 184 B ------------------------------------------------------------ php -------------------- END OF FILE -------------------- FILE: RR SHOP/generate_panelbook.py TYPE: PY SIZE: 27.41 KB ------------------------------------------------------------ #!/usr/bin/env python3 """ Relevant Reflex — Panel Book PDF Generator Reads JSON data, produces a branded PDF with charts. Usage: python3 generate_panelbook.py input.json output.pdf """ import sys, json, io, math from datetime import datetime import matplotlib matplotlib.use('Agg') import matplotlib.pyplot as plt import matplotlib.ticker as mticker from reportlab.lib.pagesizes import A4 from reportlab.lib.units import mm, cm from reportlab.lib.colors import HexColor, white, black from reportlab.lib.styles import ParagraphStyle from reportlab.lib.enums import TA_CENTER, TA_LEFT, TA_RIGHT from reportlab.platypus import ( SimpleDocTemplate, Paragraph, Spacer, Image, PageBreak, Table, TableStyle, KeepTogether ) from reportlab.lib import colors from reportlab.pdfgen import canvas # ─── Brand Palette ─── RR_GREEN = HexColor('#059669') RR_DARK = HexColor('#064e3b') RR_LIGHT = HexColor('#ecfdf5') SLATE_900 = HexColor('#0f172a') SLATE_700 = HexColor('#334155') SLATE_500 = HexColor('#64748b') SLATE_300 = HexColor('#cbd5e1') SLATE_100 = HexColor('#f1f5f9') SLATE_50 = HexColor('#f8fafc') WHITE = white # Chart color palette (muted, professional) CHART_COLORS = [ '#059669', '#0d9488', '#0891b2', '#0284c7', '#4f46e5', '#7c3aed', '#c026d3', '#e11d48', '#ea580c', '#d97706', '#65a30d', '#16a34a', '#94a3b8', '#64748b', '#475569', '#334155' ] W, H = A4 # 595.27, 841.89 # ────────────────────────────────────────────── # Chart Generators (return PNG bytes via BytesIO) # ────────────────────────────────────────────── def _apply_style(): plt.rcParams.update({ 'font.family': 'sans-serif', 'font.sans-serif': ['Helvetica', 'Arial', 'DejaVu Sans'], 'font.size': 8, 'axes.labelsize': 8, 'axes.titlesize': 9, 'xtick.labelsize': 7, 'ytick.labelsize': 7, 'figure.facecolor': 'white', 'axes.facecolor': 'white', 'axes.edgecolor': '#cbd5e1', 'axes.grid': False, 'axes.spines.top': False, 'axes.spines.right': False, }) def make_pie_chart(labels, values, title='', w_inch=3.8, h_inch=2.8): _apply_style() fig, ax = plt.subplots(figsize=(w_inch, h_inch)) clrs = CHART_COLORS[:len(labels)] wedges, texts, autotexts = ax.pie( values, labels=None, autopct='%1.1f%%', startangle=140, colors=clrs, pctdistance=0.75, wedgeprops=dict(width=0.5, edgecolor='white', linewidth=2) ) for t in autotexts: t.set_fontsize(7) t.set_color('#334155') t.set_fontweight('bold') ax.legend( [f'{l} ({v:,})' for l, v in zip(labels, values)], loc='center left', bbox_to_anchor=(1, 0.5), fontsize=7, frameon=False, labelspacing=0.8 ) if title: ax.set_title(title, fontsize=9, fontweight='bold', color='#0f172a', pad=8) fig.tight_layout(pad=0.5) buf = io.BytesIO() fig.savefig(buf, format='png', dpi=180, bbox_inches='tight', facecolor='white') plt.close(fig) buf.seek(0) return buf def make_hbar_chart(labels, values, title='', w_inch=5.2, h_inch=None, color='#059669'): _apply_style() n = len(labels) if h_inch is None: h_inch = max(1.6, min(n * 0.32 + 0.6, 7.5)) fig, ax = plt.subplots(figsize=(w_inch, h_inch)) # Truncate long labels short_labels = [l[:35] + '...' if len(str(l)) > 35 else str(l) for l in labels] y_pos = range(n) bars = ax.barh(y_pos, values, color=color, height=0.65, edgecolor='white', linewidth=0.5) ax.set_yticks(y_pos) ax.set_yticklabels(short_labels, fontsize=7, color='#334155') ax.invert_yaxis() ax.set_xlabel('') # Value labels on bars max_val = max(values) if values else 1 for bar, val in zip(bars, values): pct_of_total = (val / sum(values) * 100) if sum(values) > 0 else 0 ax.text(bar.get_width() + max_val * 0.02, bar.get_y() + bar.get_height()/2, f'{val:,} ({pct_of_total:.1f}%)', va='center', fontsize=6.5, color='#64748b') ax.set_xlim(0, max_val * 1.35) ax.xaxis.set_major_formatter(mticker.FuncFormatter(lambda x, _: f'{int(x):,}')) if title: ax.set_title(title, fontsize=9, fontweight='bold', color='#0f172a', pad=8, loc='left') ax.spines['left'].set_color('#e2e8f0') ax.spines['bottom'].set_color('#e2e8f0') ax.tick_params(axis='x', colors='#94a3b8') fig.tight_layout(pad=0.5) buf = io.BytesIO() fig.savefig(buf, format='png', dpi=180, bbox_inches='tight', facecolor='white') plt.close(fig) buf.seek(0) return buf def make_vbar_chart(labels, values, title='', w_inch=5.2, h_inch=2.5, color='#059669'): _apply_style() fig, ax = plt.subplots(figsize=(w_inch, h_inch)) x_pos = range(len(labels)) bars = ax.bar(x_pos, values, color=color, width=0.6, edgecolor='white', linewidth=0.5) ax.set_xticks(x_pos) ax.set_xticklabels(labels, fontsize=7, color='#334155', rotation=0) ax.set_ylabel('') for bar, val in zip(bars, values): ax.text(bar.get_x() + bar.get_width()/2, bar.get_height() + max(values)*0.02, f'{val:,}', ha='center', va='bottom', fontsize=7, color='#334155', fontweight='bold') ax.set_ylim(0, max(values) * 1.2 if values else 1) ax.yaxis.set_major_formatter(mticker.FuncFormatter(lambda x, _: f'{int(x):,}')) if title: ax.set_title(title, fontsize=9, fontweight='bold', color='#0f172a', pad=8, loc='left') ax.spines['left'].set_color('#e2e8f0') ax.spines['bottom'].set_color('#e2e8f0') ax.tick_params(axis='y', colors='#94a3b8') fig.tight_layout(pad=0.5) buf = io.BytesIO() fig.savefig(buf, format='png', dpi=180, bbox_inches='tight', facecolor='white') plt.close(fig) buf.seek(0) return buf # ────────────────────────────────────────────── # Custom Page Template (header/footer) # ────────────────────────────────────────────── class PanelBookTemplate(SimpleDocTemplate): def __init__(self, *args, **kwargs): self.page_count = 0 self.is_cover = True super().__init__(*args, **kwargs) def afterPage(self): self.page_count += 1 def draw_page(canvas_obj, doc): """Draw header line and footer on every page except cover.""" canvas_obj.saveState() if doc.page_count == 0: # Cover page — no header/footer canvas_obj.restoreState() return page_num = doc.page_count + 1 # Top line canvas_obj.setStrokeColor(RR_GREEN) canvas_obj.setLineWidth(1.5) canvas_obj.line(30, H - 28, W - 30, H - 28) # Header text canvas_obj.setFont('Helvetica-Bold', 7) canvas_obj.setFillColor(SLATE_500) canvas_obj.drawString(32, H - 24, 'RELEVANT REFLEX') canvas_obj.setFont('Helvetica', 7) canvas_obj.drawRightString(W - 32, H - 24, 'Panel Book') # Footer canvas_obj.setStrokeColor(SLATE_300) canvas_obj.setLineWidth(0.5) canvas_obj.line(30, 32, W - 30, 32) canvas_obj.setFont('Helvetica', 6.5) canvas_obj.setFillColor(SLATE_500) canvas_obj.drawString(32, 20, 'Confidential — Relevant Reflex Panel Book') canvas_obj.drawRightString(W - 32, 20, f'Page {page_num}') canvas_obj.restoreState() # ────────────────────────────────────────────── # Styles # ────────────────────────────────────────────── def get_styles(): return { 'section_title': ParagraphStyle( 'SectionTitle', fontName='Helvetica-Bold', fontSize=16, textColor=SLATE_900, spaceAfter=4, leading=20 ), 'section_sub': ParagraphStyle( 'SectionSub', fontName='Helvetica', fontSize=8.5, textColor=SLATE_500, spaceAfter=16, leading=12 ), 'heading2': ParagraphStyle( 'Heading2', fontName='Helvetica-Bold', fontSize=11, textColor=RR_DARK, spaceAfter=6, spaceBefore=14, leading=14 ), 'body': ParagraphStyle( 'Body', fontName='Helvetica', fontSize=8.5, textColor=SLATE_700, spaceAfter=6, leading=12 ), 'body_center': ParagraphStyle( 'BodyCenter', fontName='Helvetica', fontSize=8.5, textColor=SLATE_700, spaceAfter=6, leading=12, alignment=TA_CENTER ), 'small': ParagraphStyle( 'Small', fontName='Helvetica', fontSize=7, textColor=SLATE_500, spaceAfter=4, leading=10 ), 'small_center': ParagraphStyle( 'SmallCenter', fontName='Helvetica', fontSize=7, textColor=SLATE_500, spaceAfter=4, leading=10, alignment=TA_CENTER ), 'metric_value': ParagraphStyle( 'MetricValue', fontName='Helvetica-Bold', fontSize=22, textColor=RR_GREEN, alignment=TA_CENTER, spaceAfter=0, leading=26 ), 'metric_label': ParagraphStyle( 'MetricLabel', fontName='Helvetica', fontSize=7.5, textColor=SLATE_500, alignment=TA_CENTER, spaceAfter=0, leading=10 ), 'question_title': ParagraphStyle( 'QuestionTitle', fontName='Helvetica-Bold', fontSize=9, textColor=SLATE_900, spaceAfter=2, spaceBefore=6, leading=12 ), 'question_sub': ParagraphStyle( 'QuestionSub', fontName='Helvetica', fontSize=7, textColor=SLATE_500, spaceAfter=6, leading=10 ), } def format_question(qid): """Convert question_id like 'education_level' to 'Education Level'.""" return qid.replace('_', ' ').title() # ────────────────────────────────────────────── # Build PDF # ────────────────────────────────────────────── def build_pdf(data, output_path): doc = PanelBookTemplate( output_path, pagesize=A4, topMargin=38, bottomMargin=44, leftMargin=32, rightMargin=32, title='Relevant Reflex Panel Book', author='Relevant Reflex' ) styles = get_styles() story = [] content_width = W - 64 # left + right margins # ════════════════════════════════════════════ # PAGE 1: COVER # ════════════════════════════════════════════ story.append(Spacer(1, 120)) # Logo block logo_data = [ [Paragraph('RR', ParagraphStyle('Logo', alignment=TA_CENTER))] ] logo_table = Table(logo_data, colWidths=[80], rowHeights=[64]) logo_table.setStyle(TableStyle([ ('BACKGROUND', (0,0), (-1,-1), RR_GREEN), ('ALIGN', (0,0), (-1,-1), 'CENTER'), ('VALIGN', (0,0), (-1,-1), 'MIDDLE'), ('ROUNDEDCORNERS', [12, 12, 12, 12]), ])) # Wrap logo in centered table logo_wrapper = Table([[logo_table]], colWidths=[content_width]) logo_wrapper.setStyle(TableStyle([('ALIGN', (0,0), (-1,-1), 'CENTER')])) story.append(logo_wrapper) story.append(Spacer(1, 24)) # Title story.append(Paragraph('Relevant Reflex', ParagraphStyle( 'CoverBrand', fontName='Helvetica-Bold', fontSize=32, textColor=RR_DARK, alignment=TA_CENTER, leading=38 ))) story.append(Spacer(1, 4)) story.append(Paragraph('Panel Book', ParagraphStyle( 'CoverTitle', fontName='Helvetica', fontSize=24, textColor=SLATE_500, alignment=TA_CENTER, leading=30 ))) story.append(Spacer(1, 10)) # Green divider divider_data = [[' ']] divider = Table(divider_data, colWidths=[80], rowHeights=[3]) divider.setStyle(TableStyle([ ('BACKGROUND', (0,0), (-1,-1), RR_GREEN), ('ROUNDEDCORNERS', [2, 2, 2, 2]), ])) div_wrapper = Table([[divider]], colWidths=[content_width]) div_wrapper.setStyle(TableStyle([('ALIGN', (0,0), (-1,-1), 'CENTER')])) story.append(div_wrapper) story.append(Spacer(1, 20)) # Generation info story.append(Paragraph( f'Generated on {data.get("generated_at", "")}', ParagraphStyle('CoverDate', fontName='Helvetica', fontSize=10, textColor=SLATE_700, alignment=TA_CENTER, leading=14) )) story.append(Spacer(1, 60)) # Disclaimer box disclaimer_text = ( 'All the data in this panel book are 100% based on the actual counts of the panel ' 'and not added/edited by human. This is a real-time snapshot generated at the ' 'date and time mentioned above.' ) disc_data = [[Paragraph(disclaimer_text, ParagraphStyle( 'Disclaimer', fontName='Helvetica', fontSize=7.5, textColor=SLATE_700, alignment=TA_CENTER, leading=11 ))]] disc_table = Table(disc_data, colWidths=[content_width * 0.75]) disc_table.setStyle(TableStyle([ ('BACKGROUND', (0,0), (-1,-1), SLATE_50), ('BOX', (0,0), (-1,-1), 0.5, SLATE_300), ('TOPPADDING', (0,0), (-1,-1), 12), ('BOTTOMPADDING', (0,0), (-1,-1), 12), ('LEFTPADDING', (0,0), (-1,-1), 16), ('RIGHTPADDING', (0,0), (-1,-1), 16), ])) disc_wrapper = Table([[disc_table]], colWidths=[content_width]) disc_wrapper.setStyle(TableStyle([('ALIGN', (0,0), (-1,-1), 'CENTER')])) story.append(disc_wrapper) story.append(Spacer(1, 80)) # Footer note on cover story.append(Paragraph( 'www.relevantreflex.com', ParagraphStyle('CoverURL', fontName='Helvetica', fontSize=8, textColor=SLATE_500, alignment=TA_CENTER) )) story.append(PageBreak()) # ════════════════════════════════════════════ # PAGE 2: PANEL QUALITY OVERVIEW # ════════════════════════════════════════════ story.append(Paragraph('Panel Overview', styles['section_title'])) story.append(Paragraph('Key quality metrics and panel health indicators.', styles['section_sub'])) # Metrics grid (2 rows x 3 cols) verified = data.get('verified_members', 0) active = data.get('active_members', 0) total = data.get('total_members', 0) quality = data.get('quality', {}) def metric_cell(value, label): return [ Paragraph(str(value), styles['metric_value']), Paragraph(label, styles['metric_label']) ] metrics_data = [ [ metric_cell(f'{total:,}', 'Total Registered'), metric_cell(f'{active:,}', 'Active Members'), metric_cell(f'{verified:,}', 'Email Verified'), ], [ metric_cell(f'{quality.get("members_with_profiler", 0):,}', 'Profiler Completed'), metric_cell(f'{quality.get("mobile_verified", 0):,}', 'Mobile Verified'), metric_cell(f'{quality.get("avg_profiler_completion", 0):.0f}%', 'Avg. Profiler Completion'), ] ] # Flatten for Table (each metric_cell is a list of 2 paragraphs, put in inner table) def metric_inner(val_label_pair): t = Table([val_label_pair], colWidths=[content_width/3 - 12]) t.setStyle(TableStyle([ ('ALIGN', (0,0), (-1,-1), 'CENTER'), ('VALIGN', (0,0), (-1,-1), 'MIDDLE'), ('TOPPADDING', (0,0), (-1,-1), 14), ('BOTTOMPADDING', (0,0), (-1,-1), 14), ])) return t row1 = [metric_inner(m) for m in metrics_data[0]] row2 = [metric_inner(m) for m in metrics_data[1]] col_w = content_width / 3 metrics_table = Table([row1, row2], colWidths=[col_w]*3, rowHeights=[72, 72]) metrics_table.setStyle(TableStyle([ ('GRID', (0,0), (-1,-1), 0.5, SLATE_300), ('BACKGROUND', (0,0), (-1,-1), SLATE_50), ('ALIGN', (0,0), (-1,-1), 'CENTER'), ('VALIGN', (0,0), (-1,-1), 'MIDDLE'), ('ROUNDEDCORNERS', [8, 8, 8, 8]), ])) story.append(metrics_table) story.append(Spacer(1, 20)) # Project Stats if quality.get('total_projects', 0) > 0: story.append(Paragraph('Research Activity', styles['heading2'])) proj_data = [ ['Total Projects', 'Invitations Sent', 'Completed Surveys'], [ Paragraph(f'{quality.get("total_projects", 0):,}', styles['body_center']), Paragraph(f'{quality.get("total_surveys_sent", 0):,}', styles['body_center']), Paragraph(f'{quality.get("total_completes", 0):,}', styles['body_center']), ] ] proj_table = Table(proj_data, colWidths=[col_w]*3) proj_table.setStyle(TableStyle([ ('BACKGROUND', (0,0), (-1,0), RR_DARK), ('TEXTCOLOR', (0,0), (-1,0), WHITE), ('FONTNAME', (0,0), (-1,0), 'Helvetica-Bold'), ('FONTSIZE', (0,0), (-1,0), 7.5), ('ALIGN', (0,0), (-1,-1), 'CENTER'), ('VALIGN', (0,0), (-1,-1), 'MIDDLE'), ('GRID', (0,0), (-1,-1), 0.5, SLATE_300), ('TOPPADDING', (0,0), (-1,-1), 8), ('BOTTOMPADDING', (0,0), (-1,-1), 8), ])) story.append(proj_table) # Profiler completion rates story.append(Spacer(1, 18)) story.append(Paragraph('Profiler Completion Rates', styles['heading2'])) prof_comp = data.get('profiler_completion', {}) prof_sections = data.get('profiler_sections', {}) comp_header = ['Section', 'Started', 'Completed'] comp_rows = [comp_header] for key, label in prof_sections.items(): pc = prof_comp.get(key, {}) comp_rows.append([ label, f'{pc.get("started", 0):,}', f'{pc.get("completed", 0):,}' ]) comp_table = Table(comp_rows, colWidths=[content_width * 0.55, content_width * 0.225, content_width * 0.225]) comp_table.setStyle(TableStyle([ ('BACKGROUND', (0,0), (-1,0), RR_DARK), ('TEXTCOLOR', (0,0), (-1,0), WHITE), ('FONTNAME', (0,0), (-1,0), 'Helvetica-Bold'), ('FONTSIZE', (0,0), (-1,-1), 7.5), ('FONTNAME', (0,1), (-1,-1), 'Helvetica'), ('ALIGN', (1,0), (-1,-1), 'CENTER'), ('VALIGN', (0,0), (-1,-1), 'MIDDLE'), ('GRID', (0,0), (-1,-1), 0.5, SLATE_300), ('ROWBACKGROUNDS', (0,1), (-1,-1), [WHITE, SLATE_50]), ('TOPPADDING', (0,0), (-1,-1), 6), ('BOTTOMPADDING', (0,0), (-1,-1), 6), ('LEFTPADDING', (0,0), (0,-1), 10), ])) story.append(comp_table) story.append(PageBreak()) # ════════════════════════════════════════════ # PAGE 3: DEMOGRAPHICS # ════════════════════════════════════════════ story.append(Paragraph('Demographics', styles['section_title'])) story.append(Paragraph( f'Distribution of {verified:,} active, verified panel members.', styles['section_sub'] )) # Gender Pie gender_data = data.get('gender', []) if gender_data: labels = [g['gender'] or 'Not Specified' for g in gender_data] values = [g['count'] for g in gender_data] buf = make_pie_chart(labels, values, 'Gender Distribution') img = Image(buf, width=content_width * 0.75, height=content_width * 0.55) story.append(img) story.append(Spacer(1, 12)) # Age Bar age_data = data.get('age', []) if age_data: labels = [a['age_group'] for a in age_data] values = [a['count'] for a in age_data] buf = make_vbar_chart(labels, values, 'Age Distribution', w_inch=5.2, h_inch=2.5, color='#059669') img = Image(buf, width=content_width, height=content_width * 0.48) story.append(img) story.append(Spacer(1, 12)) # Geography Bar geo_data = data.get('geography', []) if geo_data: story.append(PageBreak()) story.append(Paragraph('Geographic Distribution', styles['section_title'])) story.append(Paragraph('Top 20 postcode regions by panel size.', styles['section_sub'])) labels = [g['region'] for g in geo_data] values = [g['count'] for g in geo_data] buf = make_hbar_chart(labels, values, 'Members by Postcode Prefix (Top 20)', color='#0d9488') h_ratio = max(1.6, min(len(labels) * 0.32 + 0.6, 7.5)) / 5.2 img = Image(buf, width=content_width, height=content_width * h_ratio) story.append(img) story.append(PageBreak()) # ════════════════════════════════════════════ # PAGES 4+: PROFILER SECTIONS # ════════════════════════════════════════════ profiler_data = data.get('profiler_data', {}) section_colors = list(CHART_COLORS) for sec_idx, (sec_key, sec_label) in enumerate(prof_sections.items()): if sec_key not in profiler_data: continue questions = profiler_data[sec_key] if not questions: continue sec_color = section_colors[sec_idx % len(section_colors)] # Section header story.append(Paragraph(sec_label, styles['section_title'])) pc = prof_comp.get(sec_key, {}) story.append(Paragraph( f'{len(questions)} question{"s" if len(questions) != 1 else ""} — ' f'{pc.get("completed", 0):,} members completed this section.', styles['section_sub'] )) for q_idx, (qid, qdata) in enumerate(questions.items()): dist = qdata.get('distribution', []) resp_count = qdata.get('respondent_count', 0) if not dist: continue labels = [d['label'] for d in dist] values = [d['count'] for d in dist] q_title = format_question(qid) # Decide chart type n_cats = len(dist) elements = [] elements.append(Paragraph(q_title, styles['question_title'])) elements.append(Paragraph( f'{resp_count:,} respondents', styles['question_sub'] )) if n_cats <= 5 and n_cats >= 2: # Pie chart for small category counts buf = make_pie_chart(labels, values, '', w_inch=3.8, h_inch=2.2) img = Image(buf, width=content_width * 0.72, height=content_width * 0.42) else: # Horizontal bar for larger category counts buf = make_hbar_chart(labels, values, '', color=sec_color) n = len(labels) h_ratio = max(1.4, min(n * 0.3 + 0.5, 6.5)) / 5.2 img = Image(buf, width=content_width * 0.92, height=content_width * h_ratio * 0.92) elements.append(img) elements.append(Spacer(1, 10)) # Try to keep question + chart together story.append(KeepTogether(elements)) story.append(PageBreak()) # ════════════════════════════════════════════ # LAST PAGE: CONTACT # ════════════════════════════════════════════ story.append(Spacer(1, 140)) # Logo contact_logo = [[Paragraph('RR', ParagraphStyle('CL', alignment=TA_CENTER))]] cl_table = Table(contact_logo, colWidths=[60], rowHeights=[48]) cl_table.setStyle(TableStyle([ ('BACKGROUND', (0,0), (-1,-1), RR_GREEN), ('ALIGN', (0,0), (-1,-1), 'CENTER'), ('VALIGN', (0,0), (-1,-1), 'MIDDLE'), ('ROUNDEDCORNERS', [10, 10, 10, 10]), ])) cl_wrapper = Table([[cl_table]], colWidths=[content_width]) cl_wrapper.setStyle(TableStyle([('ALIGN', (0,0), (-1,-1), 'CENTER')])) story.append(cl_wrapper) story.append(Spacer(1, 16)) story.append(Paragraph('Relevant Reflex', ParagraphStyle( 'ContactBrand', fontName='Helvetica-Bold', fontSize=20, textColor=RR_DARK, alignment=TA_CENTER, leading=24 ))) story.append(Spacer(1, 4)) story.append(Paragraph("India's Premier Online Research Panel", ParagraphStyle( 'ContactTag', fontName='Helvetica', fontSize=9, textColor=SLATE_500, alignment=TA_CENTER, leading=13 ))) story.append(Spacer(1, 30)) # Contact details contact_items = [ ('Email', 'contact@relevantreflex.com'), ('Support', 'support@relevantreflex.com'), ('Web', 'www.relevantreflex.com'), ('Client Portal', 'www.relevantreflex.com/clients'), ('Location', 'Tamilnadu, India'), ] for label, value in contact_items: story.append(Paragraph( f'{label} ' f'{value}', ParagraphStyle('ContactItem', fontName='Helvetica', fontSize=8.5, alignment=TA_CENTER, leading=18, textColor=SLATE_700) )) story.append(Spacer(1, 40)) # Divider div2 = Table([[' ']], colWidths=[60], rowHeights=[2]) div2.setStyle(TableStyle([('BACKGROUND', (0,0), (-1,-1), SLATE_300)])) div2_w = Table([[div2]], colWidths=[content_width]) div2_w.setStyle(TableStyle([('ALIGN', (0,0), (-1,-1), 'CENTER')])) story.append(div2_w) story.append(Spacer(1, 14)) story.append(Paragraph( 'For panel inquiries, project feasibility, or partnership opportunities, ' 'please reach out to our client services team.', styles['small_center'] )) story.append(Spacer(1, 6)) story.append(Paragraph( f'This document was generated on {data.get("generated_at", "")}.', ParagraphStyle('FootNote', fontName='Helvetica', fontSize=6.5, textColor=SLATE_500, alignment=TA_CENTER, leading=9) )) # ════════════════════════════════════════════ # BUILD # ════════════════════════════════════════════ doc.build(story, onFirstPage=draw_page, onLaterPages=draw_page) print(f'PDF generated: {output_path}') # ─── Main ─── if __name__ == '__main__': if len(sys.argv) != 3: print('Usage: python3 generate_panelbook.py input.json output.pdf') sys.exit(1) with open(sys.argv[1], 'r') as f: data = json.load(f) build_pdf(data, sys.argv[2]) -------------------- END OF FILE -------------------- FILE: RR SHOP/index.php TYPE: PHP SIZE: 85.96 KB ------------------------------------------------------------ prepare("SELECT * FROM admin_users WHERE username = ? AND status = 'active'"); $stmt->execute([$username]); $user = $stmt->fetch(); if ($user && password_verify($password, $user['password'])) { $_SESSION['admin_id'] = $user['id']; $_SESSION['admin_username'] = $user['username']; $_SESSION['admin_email'] = $user['email']; $_SESSION['admin_role'] = $user['role']; $_SESSION['admin_name'] = $user['full_name']; $updateStmt = $pdo->prepare("UPDATE admin_users SET last_login = NOW() WHERE id = ?"); $updateStmt->execute([$user['id']]); logActivity($user['id'], 'login', 'User logged in successfully'); header('Location: index.php'); exit; } else { $error = 'Invalid username or password'; } } catch (Exception $e) { error_log("Login error: " . $e->getMessage()); $error = 'An error occurred. Please try again.'; } } } // ============ SHOW LOGIN FORM ============ ?>Admin Portal
Manage members, projects, clients, invoices, fieldwork, and survey operations from a single unified dashboard.
Sign in to your admin account to continue.
This is a secure admin area. All login attempts are logged and monitored. Unauthorized access is strictly prohibited.
·
| Project | Client | Status | Updated |
|---|---|---|---|
|
|
'green','Closed'=>'gray','On hold'=>'amber','Created'=>'blue','Targeted'=>'blue'][$p['status']] ?? 'gray'; ?> |
No projects yet
| Ticket | Type | Status | Updated |
|---|---|---|---|
|
|
'red','pending'=>'amber','resolved'=>'green','closed'=>'gray'][$t['status']] ?? 'gray'; ?> |
No tickets yet
| Admin | Action | Time (IST) |
|---|---|---|
No activity yet
Please ensure TCPDF is installed in the /tcpdf directory.
'); } require_once $tcpdfPath; $pdo = getDBConnection(); // ─── Load company settings ─── $settings = []; try { $result = $pdo->query("SELECT setting_key, setting_value FROM company_settings"); while ($row = $result->fetch()) { $settings[$row['setting_key']] = $row['setting_value']; } } catch (Exception $e) { die('Error loading settings.'); } $s = function ($key, $default = '') use ($settings) { return $settings[$key] ?? $default; }; // ─── Tagline (2 lines). Override via DB keys if needed. ─── $tag1 = $s('company_tagline_line1', 'MARKET RESEARCH TECHNOLOGY &'); $tag2 = $s('company_tagline_line2', 'DATA COLLECTION SOLUTIONS'); // ─── Address built as 2 lines ─── $addrLine1 = $s('company_address'); $addrLine2Bits = array_filter([ $s('company_city'), trim($s('company_state') . ' ' . $s('company_pincode')), $s('company_country'), ]); $addrLine2 = implode(', ', $addrLine2Bits); // ─── Website cleaned of scheme ─── $websiteRaw = $s('company_website', 'relevantreflex.com'); $website = preg_replace('#^https?://#i', '', $websiteRaw); // ─── Color palette (mirrors the designed letterhead) ─── $BRAND = [5, 150, 105]; // #059669 — emerald $MUTED = [107, 114, 128]; // #6B7280 — gray-500 $HAIRLINE = [209, 213, 219]; // #D1D5DB — gray-300 $WATERMARK = [229, 231, 235]; // #E5E7EB — gray-200 $WHITE = [255, 255, 255]; // ─── PDF setup ─── class LetterheadPDF extends TCPDF { public function Header() {} public function Footer() {} } $pdf = new LetterheadPDF('P', 'mm', 'A4', true, 'UTF-8', false); $pdf->SetCreator('Relevant Reflex'); $pdf->SetAuthor($s('company_name', 'Relevant Reflex Consulting')); $pdf->SetTitle('Letterhead - ' . $s('company_name', 'Company')); $pdf->SetMargins(0, 0, 0); $pdf->SetAutoPageBreak(false, 0); $pdf->setPrintHeader(false); $pdf->setPrintFooter(false); $pdf->AddPage(); // ─── Page geometry (mm) ─── $PW = 210; $PH = 297; $MX = 20; // left/right margin $RIGHT = $PW - $MX; // ===================================================================== // WATERMARKS — drawn first so they sit beneath the header/footer. // Vertical text in the side margins (x ≈ 9mm), well clear of the body // typing zone (x = 20–190mm). // ===================================================================== $pdf->SetFont('helvetica', 'B', 11); $pdf->SetTextColor(...$WATERMARK); $wmText = 'RELEVANT REFLEX CONSULTING'; // LEFT — three watermarks reading bottom-to-top foreach ([95, 170, 245] as $yPivot) { $pdf->StartTransform(); $pdf->Rotate(90, 9, $yPivot); $pdf->Text(9, $yPivot, $wmText); $pdf->StopTransform(); } // RIGHT — three watermarks reading top-to-bottom foreach ([45, 120, 195] as $yPivot) { $pdf->StartTransform(); $pdf->Rotate(-90, $PW - 9, $yPivot); $pdf->Text($PW - 9, $yPivot, $wmText); $pdf->StopTransform(); } // ===================================================================== // HEADER // ===================================================================== $logoX = $MX; $logoY = 18; $logoS = 16; // --- Logo: rounded emerald square with white "RR" centered --- $pdf->SetFillColor(...$BRAND); $pdf->RoundedRect($logoX, $logoY, $logoS, $logoS, 3, '1111', 'F'); $pdf->SetFont('helvetica', 'B', 14); $pdf->SetTextColor(...$WHITE); $pdf->SetXY($logoX, $logoY); $pdf->Cell($logoS, $logoS, 'RR', 0, 0, 'C', false, '', 0, false, 'T', 'M'); // --- Wordmark --- $wmX = $logoX + $logoS + 6; $pdf->SetFont('helvetica', 'B', 16); $pdf->SetTextColor(...$BRAND); $pdf->SetXY($wmX, $logoY + 1); $pdf->Cell(110, 7, $s('company_name', 'Relevant Reflex Consulting'), 0, 0, 'L'); // --- Tagline: 2 stacked lines, letter-spaced, muted gray --- $pdf->setFontSpacing(0.25); $pdf->SetFont('helvetica', '', 7.8); $pdf->SetTextColor(...$MUTED); $pdf->SetXY($wmX, $logoY + 8.5); $pdf->Cell(80, 3.5, $tag1, 0, 0, 'L'); $pdf->SetXY($wmX, $logoY + 12.2); $pdf->Cell(80, 3.5, $tag2, 0, 0, 'L'); $pdf->setFontSpacing(0); // --- Contact stack on the right (right-aligned to right margin) --- $contactY = $logoY + 1; $lineH = 5.2; $contactBoxW = $PW - 2 * $MX; $pdf->SetFont('helvetica', 'B', 10); $pdf->SetTextColor(...$MUTED); $pdf->SetXY($MX, $contactY); $pdf->Cell($contactBoxW, 5, $s('company_phone'), 0, 0, 'R'); $pdf->SetFont('helvetica', '', 10); $pdf->SetXY($MX, $contactY + $lineH); $pdf->Cell($contactBoxW, 5, $s('company_email'), 0, 0, 'R'); $pdf->SetTextColor(...$BRAND); $pdf->SetXY($MX, $contactY + 2 * $lineH); $pdf->Cell($contactBoxW, 5, $website, 0, 0, 'R'); // --- Header divider: short emerald accent + hairline --- $divY = $logoY + $logoS + 6; $pdf->SetDrawColor(...$BRAND); $pdf->SetLineWidth(0.6); // ≈ 1.6pt $pdf->Line($MX, $divY, $MX + 35, $divY); $pdf->SetDrawColor(...$HAIRLINE); $pdf->SetLineWidth(0.18); // ≈ 0.5pt $pdf->Line($MX + 35, $divY, $RIGHT, $divY); // ===================================================================== // FOOTER // ===================================================================== $accentY = $PH - 32; // accent line — well above the address $addr1Y = $PH - 23; // address line 1 $addr2Y = $PH - 19; // address line 2 $webY = $PH - 21; // website (right) — visually centered to address // Footer accent: hairline + brand on the right $pdf->SetDrawColor(...$HAIRLINE); $pdf->SetLineWidth(0.18); $pdf->Line($MX, $accentY, $RIGHT, $accentY); $pdf->SetDrawColor(...$BRAND); $pdf->SetLineWidth(0.6); $pdf->Line($RIGHT - 35, $accentY, $RIGHT, $accentY); // Address on left (2 lines) $pdf->SetFont('helvetica', '', 9); $pdf->SetTextColor(...$MUTED); $pdf->SetXY($MX, $addr1Y); $pdf->Cell(125, 4, $addrLine1, 0, 0, 'L'); $pdf->SetXY($MX, $addr2Y); $pdf->Cell(125, 4, $addrLine2, 0, 0, 'L'); // Website on right (vertically centered against the 2-line address) $pdf->SetFont('helvetica', 'B', 10); $pdf->SetTextColor(...$BRAND); $pdf->SetXY($MX, $webY); $pdf->Cell($contactBoxW, 5, $website, 0, 0, 'R'); // ===================================================================== // OUTPUT // ===================================================================== $filename = 'Letterhead - ' . $s('company_name', 'Company') . '.pdf'; $pdf->Output($filename, 'D'); -------------------- END OF FILE -------------------- FILE: RR SHOP/login.php TYPE: PHP SIZE: 13.49 KB ------------------------------------------------------------ prepare("SELECT * FROM admin_users WHERE username = ? AND status = 'active'"); $stmt->execute([$username]); $user = $stmt->fetch(); if ($user && password_verify($password, $user['password'])) { // Set session $_SESSION['admin_id'] = $user['id']; $_SESSION['admin_username'] = $user['username']; $_SESSION['admin_email'] = $user['email']; $_SESSION['admin_role'] = $user['role']; $_SESSION['admin_name'] = $user['full_name']; // Update last login $updateStmt = $pdo->prepare("UPDATE admin_users SET last_login = NOW() WHERE id = ?"); $updateStmt->execute([$user['id']]); // Log activity logActivity($user['id'], 'login', 'User logged in successfully'); header('Location: index.php'); exit; } else { $error = 'Invalid username or password'; } } catch (Exception $e) { error_log("Login error: " . $e->getMessage()); $error = 'An error occurred. Please try again.'; } } } ?>Admin Portal
Manage members, projects, clients, invoices, fieldwork, and survey operations from a single unified dashboard.
Sign in to your admin account to continue.
This is a secure admin area. All login attempts are logged and monitored. Unauthorized access is strictly prohibited.
Update information for member
Default: every member earns ₹5 per verified-email referral. Enable below to give this member tiered bonuses instead. Tier 1 (first 100) is always ₹5 and cannot be changed.
Complete information for member
| Request ID | Points | Amount (₹) | UPI ID | Status | Requested | Processed |
|---|---|---|---|---|---|---|
| ₹ | Pending'; ?> |
All member-to-member referral clicks, signups, verifications, and rewards
Try adjusting your filters or check back later.
| Referrer | Clicks | Signups | Verified | Rewards Paid | Survey Comm. | Status | Last Activity | |
|---|---|---|---|---|---|---|---|---|
| 0 ? '₹' . number_format($r['survey_commission'], 0) : '—'; ?> | View Clicks |
click record
| Clicked At | Referee Email | IP Address | Signed Up | Verified | Reward Paid | Survey Comm. | Signup At | Verified At |
|---|---|---|---|---|---|---|---|---|
| — | 0 ? '₹' . number_format($dr['survey_commission_earned'], 0) . '' : '—'; ?> |
View and manage all registered survey panel members
| Member ID | Gender | Date of Birth | Postcode | SEC | Points | Status | Joined | Actions | |
|---|---|---|---|---|---|---|---|---|---|
|
No panel members found
|
|||||||||
|
Verified
|
diff($dob)->y;
?>
format('M j, Y'); ?>
years old
|
'#059669','B'=>'#0d9488','C'=>'#2563eb','D'=>'#d97706','E'=>'#dc2626']; $bgc = $secColors[$member['isec_class']] ?? '#94a3b8'; ?> — | |||||||
Welcome to India\'s Trusted Survey Platform
To activate your account and start earning through paid surveys, please verify your email address:
Note: This link expires in 48 hours.
If the button doesn\'t work: ' . $verifyUrl . '
Best regards,
The Relevant Reflex Team
Welcome to India\'s Trusted Survey Platform
To activate your account and start earning through paid surveys, please verify your email address:
Note: This link expires in 48 hours.
If the button doesn\'t work: ' . $verifyUrl . '
Best regards,
The Relevant Reflex Team
Manage all registered survey panel members
Sends a fresh 48-hour verification link to all members who registered in the selected date range and have not yet verified their email.
Sends a fresh 48-hour verification link via WhatsApp (AiSensy template account_verification) to all members who registered in the selected date range, have not yet verified their email, and have confirmed their phone is a WhatsApp number. Members without a WhatsApp number, or who unchecked the "this is my WhatsApp" box at signup, are skipped automatically.
| ID | Gen | Date of Birth | Postcode | SEC | Points | Mobile | Status | Joined | Actions | |
|---|---|---|---|---|---|---|---|---|---|---|
|
No panel members found
|
||||||||||
|
Verified 📱
Verified ✉
|
diff($dob)->y;
?>
format('d M Y'); ?>
y
|
'#059669','B'=>'#0d9488','C'=>'#2563eb','D'=>'#d97706','E'=>'#dc2626']; $bgc = $secColors[$member['isec_class']] ?? '#94a3b8'; ?> — |
✓ Verified
Unverified
—
|
|||||||
All projects across all clients · live + closed + draft
| Project | Client | Industry | Country | Status | ELOI | Actual LOI | Sample Progress | Sels | URLs Funnel | Invoice | Created | Made Live | Updated | Action |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Ref:
|
min | min — |
/
%
|
Sent: ·
Cmp:
( valid)
SO: · QF: · Total: |
No invoice
|
—'; ?>
Closed: |
View →
Client |
Member reviews submitted to PaidSurveyHub India via the survey campaign. Approve to credit points, reject to decline.
| # | Member | Survey Site | Rating | Review | Proof | Submitted | Status | Action |
|---|---|---|---|---|---|---|---|---|
|
/5
|
words
|
📎 View Proof — |
Reviewed:
|
+ pts
|
— |
`
2. **Update favicon**:
- Add your `favicon.ico` to the root directory
- Update the reference in `includes/header.php`
### Custom Styling
- **Main styles**: `assets/css/main.css`
- **Mobile styles**: `assets/css/responsive.css`
- **Dashboard styles**: `assets/css/dashboard.css`
## 📱 Mobile Optimization
The system is built mobile-first with:
- **Responsive Grid System**: Adapts to all screen sizes
- **Touch-Friendly Interface**: 44px minimum touch targets
- **Optimized Navigation**: Hamburger menu on mobile
- **Fast Loading**: Optimized assets and caching
- **Progressive Enhancement**: Works without JavaScript
## 🔧 Maintenance
### Regular Tasks
1. **Database Backups**: Weekly automated backups recommended
2. **Update Dependencies**: Keep PHP and MySQL updated
3. **Monitor Performance**: Check load times and optimize
4. **Security Updates**: Regular security audits
5. **Content Updates**: Keep information current
### Performance Optimization
1. **Enable Gzip Compression** (included in .htaccess)
2. **Optimize Images**: Use WebP format when possible
3. **Monitor Database**: Run `OPTIMIZE TABLE` monthly
4. **Cache Headers**: Properly configured in .htaccess
5. **CDN Integration**: Consider using a CDN for static assets
## 🔐 Security Features
- **SQL Injection Protection**: PDO prepared statements
- **XSS Prevention**: Input sanitization and CSP headers
- **CSRF Protection**: Session-based token validation
- **Secure Headers**: Comprehensive security headers
- **File Upload Security**: Restricted file types and locations
- **Access Control**: Role-based permissions
## 🆘 Troubleshooting
### Common Issues
**1. Database Connection Error**
```
Solution: Check config.php credentials and database server status
```
**2. Page Not Found (404)**
```
Solution: Verify .htaccess file is uploaded and mod_rewrite is enabled
```
**3. Slow Loading**
```
Solution: Enable compression, check hosting performance, optimize images
```
**4. Mobile Display Issues**
```
Solution: Clear browser cache, check responsive.css is loaded
```
**5. JavaScript Not Working**
```
Solution: Check browser console for errors, verify JS files are accessible
```
### Getting Help
1. **Check Error Logs**: In your hosting control panel
2. **Browser Console**: F12 to check for JavaScript errors
3. **PHP Error Display**: Temporarily enable in config.php for debugging
4. **Hosting Support**: Contact your hosting provider for server issues
## 📞 Support
For technical support and customization services:
- **Email**: support@relevantreflex.com
- **Documentation**: Check inline comments in code files
- **Updates**: Monitor for system updates and security patches
## 📝 License
This system is proprietary software developed for Relevant Reflex. All rights reserved.
## 🚀 Quick Start Checklist
- [ ] Create database in phpMyAdmin
- [ ] Import database_schema.sql
- [ ] Update config.php with database credentials
- [ ] Upload all files to web server
- [ ] Set correct file permissions
- [ ] Test login with admin/admin123
- [ ] Change default admin password
- [ ] Customize colors and branding
- [ ] Enable SSL and HTTPS redirect
- [ ] Test all functionality
- [ ] Setup regular backups
## Version Information
- **Version**: 1.0.0
- **Release Date**: September 2025
- **PHP Compatibility**: 7.4+
- **MySQL Compatibility**: 5.7+
- **Browser Support**: All modern browsers, IE11+
---
**Important**: Always backup your database and files before making changes or updates.
-------------------- END OF FILE --------------------
FILE: RR SHOP/referral-audit.php
TYPE: PHP
SIZE: 44.13 KB
------------------------------------------------------------
prepare("
SELECT id, email, first_name, last_name, gender, date_of_birth, postcode,
status, created_at, email_verified, onboarding_completed
FROM users WHERE email = ? LIMIT 1
");
$stmt->execute([$searchEmail]);
$user = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$user) $searchError = 'No member found with that email.';
} catch (Exception $e) { $searchError = 'Database error: ' . $e->getMessage(); }
}
// ─── If member found, run the full audit ───
if ($user) {
$userId = (int)$user['id'];
$report = [];
try {
$panelPdo = getPanelDBConnection();
// Tier configuration
$report['tier_cfg'] = null;
try {
$st = $panelPdo->prepare("SELECT * FROM member_referral_tiers WHERE user_id = ?");
$st->execute([$userId]);
$report['tier_cfg'] = $st->fetch(PDO::FETCH_ASSOC) ?: null;
} catch (Exception $e) { /* table may not exist */ }
// Aggregate referral stats
$st = $panelPdo->prepare("
SELECT
COUNT(*) AS total_clicks,
COALESCE(SUM(signup_completed), 0) AS signups,
COALESCE(SUM(email_verified), 0) AS verified,
COUNT(DISTINCT ip_address) AS unique_ips,
COUNT(DISTINCT referee_user_id) AS unique_referees,
COUNT(DISTINCT user_agent) AS unique_uas,
MIN(clicked_at) AS first_click,
MAX(clicked_at) AS last_click
FROM member_referral_clicks WHERE referrer_user_id = ?
");
$st->execute([$userId]);
$report['aggregate'] = $st->fetch(PDO::FETCH_ASSOC) ?: [];
// Engagement (mobile + profilers)
$st = $panelPdo->prepare("
SELECT
COUNT(*) AS verified_referees,
SUM(CASE WHEN EXISTS(SELECT 1 FROM mobile_verifications mv
WHERE mv.user_id = u.id AND mv.is_verified = 1)
THEN 1 ELSE 0 END) AS mobile_verified,
SUM(CASE WHEN (SELECT COUNT(*) FROM profiler_completion
WHERE user_id = u.id AND is_completed = 1) > 0
THEN 1 ELSE 0 END) AS profilers_started
FROM users u
JOIN member_referral_clicks mrc ON mrc.referee_user_id = u.id
WHERE mrc.referrer_user_id = ? AND mrc.email_verified = 1
");
$st->execute([$userId]);
$report['engagement'] = $st->fetch(PDO::FETCH_ASSOC) ?: [];
// Timing analysis
$st = $panelPdo->prepare("
SELECT
COUNT(*) AS verified_count,
MIN(TIMESTAMPDIFF(SECOND, clicked_at, signed_up_at)) AS click_to_signup_min_s,
ROUND(AVG(TIMESTAMPDIFF(SECOND, clicked_at, signed_up_at))) AS click_to_signup_avg_s,
MAX(TIMESTAMPDIFF(SECOND, clicked_at, signed_up_at)) AS click_to_signup_max_s,
MIN(TIMESTAMPDIFF(SECOND, signed_up_at, verified_at)) AS signup_to_verify_min_s,
ROUND(AVG(TIMESTAMPDIFF(SECOND, signed_up_at, verified_at))) AS signup_to_verify_avg_s,
MAX(TIMESTAMPDIFF(SECOND, signed_up_at, verified_at)) AS signup_to_verify_max_s,
SUM(CASE WHEN TIMESTAMPDIFF(SECOND, clicked_at, signed_up_at) < 15 THEN 1 ELSE 0 END) AS fast_signups_under_15s,
SUM(CASE WHEN TIMESTAMPDIFF(SECOND, signed_up_at, verified_at) < 30 THEN 1 ELSE 0 END) AS fast_verifies_under_30s
FROM member_referral_clicks
WHERE referrer_user_id = ? AND email_verified = 1
AND clicked_at IS NOT NULL AND signed_up_at IS NOT NULL AND verified_at IS NOT NULL
");
$st->execute([$userId]);
$report['timing'] = $st->fetch(PDO::FETCH_ASSOC) ?: [];
// Hour-of-day distribution (IST)
$st = $panelPdo->prepare("
SELECT
HOUR(CONVERT_TZ(signed_up_at, '+00:00', '+05:30')) AS ist_hour,
COUNT(*) AS signups
FROM member_referral_clicks
WHERE referrer_user_id = ? AND email_verified = 1
GROUP BY ist_hour ORDER BY ist_hour
");
$st->execute([$userId]);
$report['hours'] = $st->fetchAll(PDO::FETCH_ASSOC) ?: [];
// Burst detection (with IP diversity)
$st = $panelPdo->prepare("
SELECT
DATE_FORMAT(CONVERT_TZ(signed_up_at, '+00:00', '+05:30'), '%Y-%m-%d %H:00') AS hour_window_ist,
COUNT(*) AS signups,
COUNT(DISTINCT ip_address) AS unique_ips,
ROUND(COUNT(DISTINCT ip_address) / COUNT(*), 2) AS ip_diversity
FROM member_referral_clicks
WHERE referrer_user_id = ? AND email_verified = 1 AND signed_up_at IS NOT NULL
GROUP BY hour_window_ist HAVING signups >= 3
ORDER BY signups DESC LIMIT 20
");
$st->execute([$userId]);
$report['bursts'] = $st->fetchAll(PDO::FETCH_ASSOC) ?: [];
// Top IPs (any IP feeding multiple signups)
$st = $panelPdo->prepare("
SELECT
ip_address,
COUNT(*) AS hits,
SUM(signup_completed) AS signups,
SUM(email_verified) AS verified
FROM member_referral_clicks
WHERE referrer_user_id = ?
GROUP BY ip_address
HAVING hits > 1
ORDER BY hits DESC LIMIT 15
");
$st->execute([$userId]);
$report['top_ips'] = $st->fetchAll(PDO::FETCH_ASSOC) ?: [];
// Email pattern duplicates (Gmail dot/plus tricks)
$st = $panelPdo->prepare("
SELECT
REPLACE(SUBSTRING_INDEX(SUBSTRING_INDEX(u.email, '@', 1), '+', 1), '.', '') AS norm_local,
SUBSTRING_INDEX(u.email, '@', -1) AS domain,
COUNT(*) AS dupes,
GROUP_CONCAT(u.email ORDER BY u.email SEPARATOR ' | ') AS emails
FROM member_referral_clicks mrc
JOIN users u ON u.id = mrc.referee_user_id
WHERE mrc.referrer_user_id = ?
GROUP BY norm_local, domain HAVING dupes > 1
ORDER BY dupes DESC LIMIT 10
");
$st->execute([$userId]);
$report['email_dupes'] = $st->fetchAll(PDO::FETCH_ASSOC) ?: [];
// Geographic — region (first digit)
$st = $panelPdo->prepare("
SELECT
LEFT(u.postcode, 1) AS region_code,
CASE LEFT(u.postcode, 1)
WHEN '1' THEN 'Delhi / Haryana / Punjab / HP / J&K'
WHEN '2' THEN 'UP / Uttarakhand'
WHEN '3' THEN 'Rajasthan / Gujarat'
WHEN '4' THEN 'Maharashtra / MP / Goa / Chhattisgarh'
WHEN '5' THEN 'Telangana / AP / Karnataka'
WHEN '6' THEN 'Tamil Nadu / Kerala / Puducherry'
WHEN '7' THEN 'West Bengal / Odisha / NE States'
WHEN '8' THEN 'Bihar / Jharkhand'
ELSE 'Other / Unknown'
END AS region,
COUNT(*) AS members
FROM users u
JOIN member_referral_clicks mrc ON mrc.referee_user_id = u.id
WHERE mrc.referrer_user_id = ? AND mrc.email_verified = 1
AND u.postcode IS NOT NULL AND u.postcode != ''
GROUP BY region_code, region ORDER BY members DESC
");
$st->execute([$userId]);
$report['regions'] = $st->fetchAll(PDO::FETCH_ASSOC) ?: [];
// Geographic — district (first 3 digits)
$st = $panelPdo->prepare("
SELECT
LEFT(u.postcode, 3) AS prefix,
COUNT(*) AS members,
GROUP_CONCAT(DISTINCT LEFT(u.postcode, 6) ORDER BY u.postcode SEPARATOR ', ') AS sample_pins
FROM users u
JOIN member_referral_clicks mrc ON mrc.referee_user_id = u.id
WHERE mrc.referrer_user_id = ? AND mrc.email_verified = 1
AND u.postcode IS NOT NULL AND u.postcode != ''
GROUP BY prefix ORDER BY members DESC LIMIT 25
");
$st->execute([$userId]);
$report['districts'] = $st->fetchAll(PDO::FETCH_ASSOC) ?: [];
// Get referee user IDs for cross-DB survey lookup
$st = $panelPdo->prepare("
SELECT referee_user_id FROM member_referral_clicks
WHERE referrer_user_id = ? AND referee_user_id IS NOT NULL AND email_verified = 1
");
$st->execute([$userId]);
$refIds = array_map('intval', array_column($st->fetchAll(PDO::FETCH_ASSOC), 'referee_user_id'));
// Survey activity (cross-DB → rrshop)
$report['surveys'] = ['referees_with_invites' => 0, 'total_invites' => 0,
'total_completes' => 0, 'unique_with_completes' => 0,
'bad_quality' => 0];
if (!empty($refIds)) {
try {
$shopPdo = getDBConnection();
$placeholders = implode(',', array_fill(0, count($refIds), '?'));
$st = $shopPdo->prepare("
SELECT
COUNT(DISTINCT sent_to_user_id) AS referees_with_invites,
COUNT(*) AS total_invites,
SUM(CASE WHEN status = 'complete' THEN 1 ELSE 0 END) AS total_completes,
COUNT(DISTINCT CASE WHEN status = 'complete' THEN sent_to_user_id END) AS unique_with_completes,
SUM(CASE WHEN quality_flag IN ('speedster','ip_duplicate','client_flagged') THEN 1 ELSE 0 END) AS bad_quality
FROM survey_urls
WHERE sent_to_user_id IN ($placeholders)
");
$st->execute($refIds);
$report['surveys'] = $st->fetch(PDO::FETCH_ASSOC) ?: $report['surveys'];
} catch (Exception $e) { error_log("Audit survey lookup error: " . $e->getMessage()); }
}
// Recent referees detail (top 30)
$st = $panelPdo->prepare("
SELECT
mrc.id, mrc.ip_address, mrc.email AS masked_email, mrc.signup_completed, mrc.email_verified,
mrc.signup_reward_paid, mrc.clicked_at, mrc.signed_up_at, mrc.verified_at,
u.email AS full_email, u.gender, u.postcode, u.status,
EXISTS(SELECT 1 FROM mobile_verifications mv WHERE mv.user_id = u.id AND mv.is_verified = 1) AS mob_v,
(SELECT COUNT(*) FROM profiler_completion WHERE user_id = u.id AND is_completed = 1) AS prof_c
FROM member_referral_clicks mrc
LEFT JOIN users u ON u.id = mrc.referee_user_id
WHERE mrc.referrer_user_id = ?
ORDER BY mrc.clicked_at DESC LIMIT 30
");
$st->execute([$userId]);
$report['recent'] = $st->fetchAll(PDO::FETCH_ASSOC) ?: [];
} catch (Exception $e) { error_log("Referral audit error: " . $e->getMessage()); }
// ─── Compute fraud verdict score (0=clean, higher=worse) ───
$score = 0;
$signals = [];
$agg = $report['aggregate'] ?? [];
$eng = $report['engagement'] ?? [];
$tim = $report['timing'] ?? [];
$bursts = $report['bursts'] ?? [];
$verifiedN = max((int)($agg['verified'] ?? 0), 1);
// 1) Aggregate IP diversity
$aggIpRatio = (int)($agg['total_clicks'] ?? 0) > 0
? (int)($agg['unique_ips'] ?? 0) / (int)$agg['total_clicks']
: 0;
if ($aggIpRatio >= 0.5) { $signals[] = ['ok', 'IP diversity (overall): ' . round($aggIpRatio*100) . '% — healthy']; }
elseif ($aggIpRatio >= 0.3) { $score += 1; $signals[] = ['warn', 'IP diversity (overall): ' . round($aggIpRatio*100) . '% — borderline']; }
else { $score += 2; $signals[] = ['bad', 'IP diversity (overall): ' . round($aggIpRatio*100) . '% — too low']; }
// 2) Worst-burst IP diversity
$worstBurst = 1.0;
foreach ($bursts as $b) { if ((float)$b['ip_diversity'] < $worstBurst) $worstBurst = (float)$b['ip_diversity']; }
if (!empty($bursts)) {
if ($worstBurst >= 0.7) { $signals[] = ['ok', 'Worst-burst IP diversity: ' . round($worstBurst*100) . '% — healthy']; }
elseif ($worstBurst >= 0.3){ $score += 1; $signals[] = ['warn', 'Worst-burst IP diversity: ' . round($worstBurst*100) . '%']; }
else { $score += 3; $signals[] = ['bad', 'Worst-burst IP diversity: ' . round($worstBurst*100) . '% — concentrated']; }
}
// 3) Mobile verified rate
$mobRate = $verifiedN > 0 ? (int)($eng['mobile_verified'] ?? 0) / $verifiedN : 0;
if ($mobRate >= 0.30) { $signals[] = ['ok', 'Mobile-verified rate: ' . round($mobRate*100) . '%']; }
elseif ($mobRate >= 0.10) { $score += 1; $signals[] = ['warn', 'Mobile-verified rate: ' . round($mobRate*100) . '% — low']; }
else { $score += 2; $signals[] = ['bad', 'Mobile-verified rate: ' . round($mobRate*100) . '% — almost no engagement']; }
// 4) Profilers started rate
$profRate = $verifiedN > 0 ? (int)($eng['profilers_started'] ?? 0) / $verifiedN : 0;
if ($profRate >= 0.30) { $signals[] = ['ok', 'Profiler-started rate: ' . round($profRate*100) . '%']; }
elseif ($profRate >= 0.10) { $score += 1; $signals[] = ['warn', 'Profiler-started rate: ' . round($profRate*100) . '% — low']; }
else { $score += 2; $signals[] = ['bad', 'Profiler-started rate: ' . round($profRate*100) . '% — empty profiles']; }
// 5) Fast verifies (<30s) rate
$vCount = (int)($tim['verified_count'] ?? 0);
$fast30 = (int)($tim['fast_verifies_under_30s'] ?? 0);
$fastRate = $vCount > 0 ? $fast30 / $vCount : 0;
if ($fastRate < 0.20) { $signals[] = ['ok', 'Fast-verify rate (<30s): ' . round($fastRate*100) . '%']; }
elseif ($fastRate < 0.50) { $signals[] = ['info', 'Fast-verify rate (<30s): ' . round($fastRate*100) . '% — note']; }
else { $score += 1; $signals[] = ['warn', 'Fast-verify rate (<30s): ' . round($fastRate*100) . '% — high (event style or automation)']; }
// 6) Scripted-fast signups (<15s)
$fast15 = (int)($tim['fast_signups_under_15s'] ?? 0);
if ($fast15 == 0) { $signals[] = ['ok', 'Scripted-fast signups (<15s): 0']; }
elseif ($fast15 < 5) { $score += 1; $signals[] = ['warn', "Scripted-fast signups (<15s): $fast15"]; }
else { $score += 3; $signals[] = ['bad', "Scripted-fast signups (<15s): $fast15 — likely automation"]; }
// 7) Email pattern duplicates
$emailDupCount = count($report['email_dupes'] ?? []);
if ($emailDupCount == 0) { $signals[] = ['ok', 'Email pattern duplicates: none']; }
elseif ($emailDupCount <= 3) { $score += 1; $signals[] = ['warn', "Email pattern duplicates: $emailDupCount (possible Gmail tricks)"]; }
else { $score += 3; $signals[] = ['bad', "Email pattern duplicates: $emailDupCount — same person, multiple aliases"]; }
// 8) Surveys completed by referees
$sv = $report['surveys'] ?? [];
$totalRefs = max(count($refIds), 1);
$surveyEngagement = (int)($sv['unique_with_completes'] ?? 0) / $totalRefs;
if ($verifiedN >= 20) { // only meaningful at scale
if ($surveyEngagement >= 0.10) { $signals[] = ['ok', 'Survey engagement: ' . round($surveyEngagement*100) . '% of referees took surveys']; }
elseif ($surveyEngagement >= 0.03) { $score += 1; $signals[] = ['warn', 'Survey engagement: ' . round($surveyEngagement*100) . '% — low']; }
else { $score += 2; $signals[] = ['bad', 'Survey engagement: ' . round($surveyEngagement*100) . '% — referees never take surveys']; }
}
// Verdict from total score
if ($score <= 3) { $verdictLevel = 'clean'; $verdictText = 'CLEAN'; $verdictColor = '#059669'; $verdictBg = '#d1fae5'; $verdictIcon = '✓'; }
elseif ($score <= 7) { $verdictLevel = 'review'; $verdictText = 'REQUIRES REVIEW'; $verdictColor = '#d97706'; $verdictBg = '#fef3c7'; $verdictIcon = '⚠'; }
else { $verdictLevel = 'risky'; $verdictText = 'HIGH FRAUD RISK'; $verdictColor = '#dc2626'; $verdictBg = '#fee2e2'; $verdictIcon = '✗'; }
$report['verdict'] = [
'score' => $score, 'level' => $verdictLevel, 'text' => $verdictText,
'color' => $verdictColor, 'bg' => $verdictBg, 'icon' => $verdictIcon, 'signals' => $signals
];
}
// Helpers
if (!function_exists('fmtNum')) { function fmtNum($v) { return number_format((int)$v); } }
if (!function_exists('fmtIST')) {
function fmtIST($dt, $fmt = 'd M Y h:i A') {
if (!$dt || $dt === '0000-00-00 00:00:00') return '—';
try { $d = new DateTime($dt, new DateTimeZone('Asia/Kolkata')); return $d->format($fmt); }
catch (Exception $e) { return date($fmt, strtotime($dt)); }
}
}
function fmtDuration($s) {
if ($s === null || $s === '') return '—';
$s = (int)$s;
if ($s < 60) return $s . 's';
if ($s < 3600) return floor($s/60) . 'm ' . ($s%60) . 's';
if ($s < 86400) return floor($s/3600) . 'h ' . floor(($s%3600)/60) . 'm';
return floor($s/86400) . 'd ' . floor(($s%86400)/3600) . 'h';
}
include 'includes/header.php';
?>
Generated IST · Relevant Reflex Admin · By
Comprehensive fraud/legitimacy assessment for any referring panel member. Enter their email to run a full multi-signal check across IPs, timing, engagement, geographic spread, and survey activity.
| Hour Window (IST) | Signups | Unique IPs | IP Diversity | Read |
|---|---|---|---|---|
| % |
| IP Address | Total Hits | Signups | Verified |
|---|---|---|---|
|
| Normalized Local | Domain | Variants | Emails |
|---|---|---|---|
|
| Pincode Prefix | Members | Sample Pincodes |
|---|---|---|
|
| IP | C→S | S→V | Verified | Mob | Prof | Postcode | Clicked (IST) | |
|---|---|---|---|---|---|---|---|---|
| ✓' : '—'; ?> | ✓' : '—'; ?> | 0 ? '' . (int)$r['prof_c'] . '' : '—'; ?> |
Manage your company details used in client invoicing
Add your company information for invoicing by switching to Edit mode.
✏ Add Company DetailsBasic company details that appear on invoices and official documents.
Tax identification numbers and registration details.
Banking information displayed on invoices for client payments.
Default text and formatting for generated invoices.
Controls how sensitive panel-member data is shown across admin pages.
Manage affiliate partners and track signups
| ID | Affiliate Code | Company/Name | Type | In-charge | Location | Contact | Hits | Not Verified | Verified | Balance | Status | Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| No affiliates found. Click "Add New Affiliate" to create one. | ||||||||||||
| # |
-
|
₹ | ||||||||||
Our support portal is available on the main Relevant Reflex website. Submit tickets, track requests, and access help resources all in one place.
Open Support Portal →Opens in a new window at relevantreflex.com
Manage admin users and their access roles
| ID | User Details | Role | Status | Last Login | Actions | |
|---|---|---|---|---|---|---|
| # |
|
Never | Current User |