@extends('layouts.app')
@section('title', $viewData["title"])
@section('subtitle', $viewData["subtitle"])
@section('content')

<form action="{{route('database_management.copy_tables')}}" method="GET"
    onsubmit="return confirm('Are you sure you want to copy the anomalies tables (BDL tables will be replaced) ?')"
    title="Copy anomalies tables from Qlik to BDL (BDL tables will be replaced)">
    @csrf
    <button class="btn btn-primary">
        <i class="bi-clipboard-x"> COPY ANOMALIES TABLES FROM QLIK TO BDL</i>
    </button>
</form>
<BR>

@foreach ($viewData['data'] as $active_customer)

<div class="card">
    <div class="card-header">
        {{$active_customer['customer']}} table details
    </div>
    <div class="card-body">
        <table class="table table-hover">
            <thead>
                <tr>
                    <th class="text-center" scope="col" colspan=3>Qlik table source</th>
                    <th class="text-center align-middle" rowspan=2>
                        <div class="vr" style="height: 50px;"></div>
                    </th>
                    <th class="text-center" scope="col" colspan=3>BDL table source</th>
                    <th class="text-center align-middle" rowspan=2>
                        <div class="vr" style="height: 50px;"></div>
                    </th>
                    <th class="text-center" scope="col" colspan=2>Anomalies table - customer inputs</th>
                </tr>
                <tr>
                    <th class="text-muted"  scope="col">Table name</th>
                    <th class="text-muted" scope="col">Nb of lines</th>
                    <th class="text-muted" scope="col">Month</th>

                    <th class="text-muted" scope="col">Table name</th>
                    <th class="text-muted" scope="col">Nb of lines</th>
                    <th class="text-muted" scope="col">Month</th>                    

                    <th class="text-muted" scope="col">Table name</th>
                    <th class="text-muted" scope="col">Nb of lines</th>
                </tr>
            </thead>
            <tbody>
                <tr>
                    <td>{{ $active_customer['table_anomaly_source'] }}</td>
                    <td>{{ $active_customer['table_anomaly_source_count'] }}</td>
                    <td>{{ $active_customer['table_anomaly_source_month'] }}</td>                    
                    <td class="text-center align-middle">
                        <div class="vr"></div>
                    </td>
                    <td>{{ $active_customer['table_anomaly'] }}</td>
                    <td>{{ $active_customer['table_anomaly_count'] }}</td>
                    <td>{{ $active_customer['table_anomaly_month'] }}</td>                       
                    <td class="text-center align-middle">
                        <div class="vr"></div>
                    </td>
                    <td>{{ $active_customer['table_reason'] }}</td>
                    <td>{{ $active_customer['table_reason_count'] }}</td>
                </tr>

            </tbody>
        </table>

    </div>
</div>
<BR><BR>
@endforeach



@endsection