@extends('layouts.app')

@section('title', 'AI Reports & Analytics')

@section('content')
<style>
.qsa-filter,.qsa-card,.qsa-panel{background:#fff;border:1px solid #e5eaf0;border-radius:12px;box-shadow:0 4px 16px rgba(15,23,42,.05)}.qsa-filter{padding:14px 16px;margin-bottom:16px}.qsa-cards{display:grid;grid-template-columns:repeat(5,minmax(150px,1fr));gap:12px;margin-bottom:16px}.qsa-card{padding:16px;position:relative;overflow:hidden}.qsa-card small{display:block;color:#64748b;text-transform:uppercase;font-weight:600;letter-spacing:.04em}.qsa-card strong{display:block;font-size:22px;color:#172033;margin-top:7px}.qsa-card span{color:#64748b;font-size:12px}.qsa-card:before{content:"";position:absolute;right:-16px;top:-20px;width:70px;height:70px;border-radius:50%;background:#eef2ff}.qsa-panel{padding:18px;margin-bottom:16px}.qsa-panel h3{margin:0 0 14px;font-size:17px}.qsa-grid{display:grid;grid-template-columns:2fr 1fr;gap:16px}.qsa-chart{width:100%;height:260px}.qsa-legend{display:flex;gap:15px;flex-wrap:wrap;color:#64748b;font-size:12px;margin-bottom:8px}.qsa-dot{display:inline-block;width:9px;height:9px;border-radius:50%;margin-right:5px}.qsa-table-wrap{overflow:auto}.qsa-table{width:100%;min-width:720px;border-collapse:collapse}.qsa-table th,.qsa-table td{padding:9px 10px;border-bottom:1px solid #edf0f4;text-align:left;vertical-align:top}.qsa-table th{font-size:12px;text-transform:uppercase;color:#64748b;background:#f8fafc}.qsa-tabs{display:flex;gap:6px;margin-bottom:16px}.qsa-tab{border:1px solid #dbe3ee;background:#fff;border-radius:20px;padding:7px 14px;cursor:pointer}.qsa-tab.active{background:#4f46e5;color:#fff;border-color:#4f46e5}.qsa-tab-panel{display:none}.qsa-tab-panel.active{display:block}.qsa-ai-output{background:#f8fafc;border-left:4px solid #6366f1;padding:16px;border-radius:8px;margin-top:14px}.qsa-ai-output table{width:100%;border-collapse:collapse}.qsa-ai-output th,.qsa-ai-output td{border:1px solid #dbe3ee;padding:7px}.qsa-positive{color:#15803d}.qsa-negative{color:#b91c1c}.qsa-badge{display:inline-block;padding:3px 7px;border-radius:10px;background:#eef2ff;color:#4338ca;font-size:11px}@media(max-width:1100px){.qsa-cards{grid-template-columns:repeat(2,1fr)}.qsa-grid{grid-template-columns:1fr}}@media(max-width:600px){.qsa-cards{grid-template-columns:1fr}.qsa-tabs{overflow:auto}.qsa-filter .form-inline>*{margin-bottom:7px}}
</style>
<section class="content-header">
    <h1><i class="fas fa-chart-line"></i> <span class="label label-primary" style="font-size:12px;vertical-align:middle">AI</span> Reports & Analytics <small>Permission-scoped business, pricing and accounting intelligence</small></h1>
</section>
<section class="content">
    <form class="qsa-filter form-inline" method="GET" action="{{ route('quicksellai.reports') }}">
        <label>From&nbsp;</label><input class="form-control" type="date" name="from" value="{{ $from->toDateString() }}">
        <label style="margin-left:8px">To&nbsp;</label><input class="form-control" type="date" name="to" value="{{ $to->toDateString() }}">
        <button class="btn btn-primary" type="submit" style="margin-left:8px"><i class="fa fa-filter"></i> Apply</button>
        <a class="btn btn-default pull-right" href="{{ route('quicksellai.report.export', ['type'=>'overview','from'=>$from->toDateString(),'to'=>$to->toDateString()]) }}"><i class="fa fa-download"></i> Export overview</a>
    </form>

    <div class="qsa-cards">
        @foreach(['sales'=>'Sales','purchases'=>'Purchases','expenses'=>'Expenses','receivables'=>'Receivables','payables'=>'Payables'] as $key=>$label)
            @php($metric = data_get($snapshot, 'metrics.'.$key))
            <div class="qsa-card"><small>{{ $label }}</small>@if(is_array($metric))<strong>{{ number_format((float)$metric['total'],2) }}</strong><span>{{ number_format((int)$metric['count']) }} records</span>@else<strong>Restricted</strong><span>Role permission required</span>@endif</div>
        @endforeach
    </div>

    <div class="qsa-tabs">
        <button type="button" class="qsa-tab active" data-tab="overview">Overview</button>
        @if(auth()->user()->can('superadmin') || auth()->user()->can('ai.use_pricing_copilot'))<button type="button" class="qsa-tab" data-tab="pricing">Price recommendations</button>@endif
        @if(auth()->user()->can('superadmin') || auth()->user()->can('ai.view_accounting'))<button type="button" class="qsa-tab" data-tab="accounting">Accounting & ledgers</button>@endif
        <button type="button" class="qsa-tab" data-tab="ai-report">AI management report</button>
    </div>

    <div id="qsa-overview" class="qsa-tab-panel active">
        <div class="qsa-grid">
            <div class="qsa-panel"><h3>Business movement</h3><div class="qsa-legend"><span><i class="qsa-dot" style="background:#4f46e5"></i>Sales</span><span><i class="qsa-dot" style="background:#0ea5e9"></i>Purchases</span><span><i class="qsa-dot" style="background:#f97316"></i>Expenses</span></div><canvas id="qsa_trend" class="qsa-chart"></canvas></div>
            <div class="qsa-panel"><h3>Period summary</h3><p><strong>{{ $snapshot['period']['days'] }}</strong> days analyzed</p><p>From {{ $snapshot['period']['from'] }} to {{ $snapshot['period']['to'] }}</p><hr><p class="text-muted">All figures are permission- and location-scoped. Current dues are calculated from invoices less recorded payments.</p></div>
        </div>
        <div class="qsa-panel"><h3>Top-selling products</h3><div class="qsa-table-wrap"><table class="qsa-table"><thead><tr><th>Product</th><th>Variation</th><th>SKU</th><th>Units</th><th>Revenue</th></tr></thead><tbody>@forelse($snapshot['top_products'] as $row)<tr><td>{{ $row['product'] }}</td><td>{{ $row['variation'] }}</td><td>{{ $row['sku'] }}</td><td>{{ number_format($row['units'],2) }}</td><td>{{ number_format($row['revenue'],2) }}</td></tr>@empty<tr><td colspan="5" class="text-muted">No accessible product sales in this period.</td></tr>@endforelse</tbody></table></div></div>
    </div>

    @if(auth()->user()->can('superadmin') || auth()->user()->can('ai.use_pricing_copilot'))
    <div id="qsa-pricing" class="qsa-tab-panel">
        <div class="qsa-panel"><div class="clearfix"><h3 class="pull-left">Evidence-backed price recommendations</h3><a class="btn btn-default btn-sm pull-right" href="{{ route('quicksellai.report.export', ['type'=>'pricing','from'=>$from->toDateString(),'to'=>$to->toDateString()]) }}"><i class="fa fa-download"></i> Export CSV</a></div><p class="text-muted">Uses cost, current gross margin, sales velocity, available stock, and alert quantity. Suggestions are advisory and are never applied automatically.</p><div class="qsa-table-wrap"><table class="qsa-table"><thead><tr><th>Product</th><th>Cost</th><th>Current</th><th>Margin</th><th>Suggested</th><th>Change</th><th>Stock / Sold</th><th>Confidence</th><th>Reason</th></tr></thead><tbody>@forelse($snapshot['pricing'] as $row)<tr><td><strong>{{ $row['product'] }}</strong><br><small>{{ $row['sku'] }}</small></td><td>{{ number_format($row['cost'],2) }}</td><td>{{ number_format($row['current_price'],2) }}</td><td>{{ number_format($row['current_margin_percent'],1) }}%</td><td><strong>{{ number_format($row['suggested_price'],2) }}</strong></td><td class="{{ $row['change_percent'] > 0 ? 'qsa-positive' : ($row['change_percent'] < 0 ? 'qsa-negative' : '') }}">{{ $row['change_percent'] > 0 ? '+' : '' }}{{ number_format($row['change_percent'],1) }}%</td><td>{{ number_format($row['stock'],2) }} / {{ number_format($row['units_sold'],2) }}</td><td><span class="qsa-badge">{{ ucfirst($row['confidence']) }}</span></td><td>{{ $row['reason'] }}</td></tr>@empty<tr><td colspan="9">No accessible products.</td></tr>@endforelse</tbody></table></div></div>
    </div>
    @endif

    @if(auth()->user()->can('superadmin') || auth()->user()->can('ai.view_accounting'))
    <div id="qsa-accounting" class="qsa-tab-panel">
        @if(!empty($snapshot['accounting']))
            @php($accounting = $snapshot['accounting'])
            <div class="qsa-cards">
                <div class="qsa-card"><small>Cash credits</small><strong>{{ number_format(data_get($accounting,'cash_flow.credits',0),2) }}</strong></div><div class="qsa-card"><small>Cash debits</small><strong>{{ number_format(data_get($accounting,'cash_flow.debits',0),2) }}</strong></div><div class="qsa-card"><small>Net cash flow</small><strong>{{ number_format(data_get($accounting,'cash_flow.net',0),2) }}</strong></div>
                @if($accounting['profit_loss'])<div class="qsa-card"><small>Est. gross profit</small><strong>{{ number_format($accounting['profit_loss']['estimated_gross_profit'],2) }}</strong></div><div class="qsa-card"><small>Est. net profit</small><strong>{{ number_format($accounting['profit_loss']['estimated_net_profit'],2) }}</strong></div>@endif
            </div>
            @if($accounting['profit_loss'])<div class="qsa-panel"><h3>Profit analysis</h3><div class="qsa-table-wrap"><table class="qsa-table"><thead><tr><th>Revenue</th><th>Estimated COGS</th><th>Estimated gross profit</th><th>Expenses</th><th>Estimated net profit</th><th>QuickSell mapped net profit</th></tr></thead><tbody><tr><td>{{ number_format($accounting['profit_loss']['revenue'],2) }}</td><td>{{ number_format($accounting['profit_loss']['estimated_cogs'],2) }}</td><td>{{ number_format($accounting['profit_loss']['estimated_gross_profit'],2) }}</td><td>{{ number_format($accounting['profit_loss']['expenses'],2) }}</td><td>{{ number_format($accounting['profit_loss']['estimated_net_profit'],2) }}</td><td>{{ number_format($accounting['profit_loss']['net_profit'],2) }}</td></tr></tbody></table></div><small class="text-muted">{{ $accounting['profit_loss']['estimate_basis'] }} QuickSell mapped profit uses the software's purchase-to-sale mappings.</small></div>@endif
            <div class="qsa-panel"><div class="clearfix"><h3 class="pull-left">Account balances and period movement</h3><a class="btn btn-default btn-sm pull-right" href="{{ route('quicksellai.report.export', ['type'=>'accounting','from'=>$from->toDateString(),'to'=>$to->toDateString()]) }}"><i class="fa fa-download"></i> Export CSV</a></div><div class="qsa-table-wrap"><table class="qsa-table"><thead><tr><th>Account</th><th>Number</th><th>Balance</th><th>Credits</th><th>Debits</th><th>Net flow</th></tr></thead><tbody>@forelse($accounting['accounts'] as $row)<tr><td>{{ $row['name'] }}</td><td>{{ $row['account_number'] }}</td><td>{{ number_format($row['balance'],2) }}</td><td>{{ number_format($row['credits'],2) }}</td><td>{{ number_format($row['debits'],2) }}</td><td>{{ number_format($row['net_cash_flow'],2) }}</td></tr>@empty<tr><td colspan="6">No account-ledger entries are available.</td></tr>@endforelse</tbody></table></div></div>
            <div class="qsa-panel"><h3>Recent ledger entries</h3><div class="qsa-table-wrap"><table class="qsa-table"><thead><tr><th>Date</th><th>Account</th><th>Reference</th><th>Type</th><th>Amount</th><th>Note</th></tr></thead><tbody>@forelse($accounting['recent_ledger_entries'] as $row)<tr><td>{{ $row['date'] }}</td><td>{{ $row['account'] }}</td><td>{{ $row['reference'] }}</td><td>{{ ucfirst($row['type']) }} {{ $row['transaction_type'] ? '· '.str_replace('_',' ',$row['transaction_type']) : '' }}</td><td>{{ number_format($row['amount'],2) }}</td><td>{{ $row['note'] }}</td></tr>@empty<tr><td colspan="6">No ledger entries in this period.</td></tr>@endforelse</tbody></table></div></div>
        @else<div class="alert alert-warning">Your underlying QuickSell role does not permit accounting reports.</div>@endif
    </div>
    @endif

    <div id="qsa-ai-report" class="qsa-tab-panel"><div class="qsa-panel"><h3>AI management report</h3><p>Generate an executive summary using only the figures currently shown on this permission-scoped dashboard.</p><button id="qsa_generate" class="btn btn-primary"><i class="fas fa-sparkles"></i> Generate report</button><div id="qsa_ai_output" class="qsa-ai-output" style="display:none"></div></div></div>
</section>
@endsection

@section('javascript')
<script>
$(function(){
    $('.qsa-tab').on('click',function(){ $('.qsa-tab').removeClass('active'); $(this).addClass('active'); $('.qsa-tab-panel').removeClass('active'); $('#qsa-'+$(this).data('tab')).addClass('active'); });
    function drawTrend(){
        var data=@json($snapshot['trend']), canvas=document.getElementById('qsa_trend'); if(!canvas)return;
        var ratio=window.devicePixelRatio||1,w=canvas.clientWidth||700,h=260; canvas.width=w*ratio;canvas.height=h*ratio;var c=canvas.getContext('2d');c.scale(ratio,ratio);c.clearRect(0,0,w,h);
        var pad={l:48,r:15,t:15,b:35},cw=w-pad.l-pad.r,ch=h-pad.t-pad.b,max=1;data.forEach(function(d){max=Math.max(max,d.sales,d.purchases,d.expenses);});
        c.strokeStyle='#e2e8f0';c.fillStyle='#64748b';c.font='11px sans-serif';for(var i=0;i<=4;i++){var y=pad.t+(ch*i/4);c.beginPath();c.moveTo(pad.l,y);c.lineTo(w-pad.r,y);c.stroke();c.fillText(Math.round(max*(1-i/4)).toLocaleString(),2,y+4);}
        [['sales','#4f46e5'],['purchases','#0ea5e9'],['expenses','#f97316']].forEach(function(series){c.strokeStyle=series[1];c.lineWidth=2;c.beginPath();data.forEach(function(d,i){var x=pad.l+(data.length<=1?cw/2:cw*i/(data.length-1)),y=pad.t+ch-(Number(d[series[0]])/max*ch);i?c.lineTo(x,y):c.moveTo(x,y);});c.stroke();});
        if(data.length){c.fillStyle='#64748b';c.fillText(data[0].date,pad.l,h-10);var last=data[data.length-1].date;c.fillText(last,w-pad.r-c.measureText(last).width,h-10);}
    } drawTrend(); $(window).on('resize',drawTrend);
    $('#qsa_generate').on('click',function(){var b=$(this).prop('disabled',true).html('<i class="fa fa-spinner fa-spin"></i> Analyzing…');$.post(@json(route('quicksellai.dashboard.insight')),{_token:@json(csrf_token()),from:@json($from->toDateString()),to:@json($to->toDateString())}).done(function(r){$('#qsa_ai_output').html(r.html).show();}).fail(function(x){toastr.error((x.responseJSON&&x.responseJSON.message)||'Could not generate the report.');}).always(function(){b.prop('disabled',false).html('<i class="fas fa-sparkles"></i> Generate report');});});
});
</script>
@endsection