@php
    /*query no cache*/
    $count = DB::select(DB::raw("select count(*) as aggregate 
    from `question_banks` where `verified` = 1 
    and `client_mng_id` is null and `id` 
    not in (select `id` from `clone_question_banks`)"));
    $count = $count[0]->aggregate ?? 0;
@endphp
<div class="row">
    <div class="col-md-6">
        <div>
            <a href="{{route('master.settings.move-question')}}" onclick="return confirm('Are you sure?')" class="btn btn-info">Move questions to production NOW</a>
            <br>
            <span class="text-muted">Total Question is waiting: {{$count}} Records</span>
            <br>
            <span class="text-muted">Data will automatically update on Sundays weekly</span>
            <br>
            <a href="{{route('master.settings.export-question-moved')}}" class="btn btn-info">Export Questions - Moved to Production</a>
        </div>
    </div>
    @if (env('ACCEPT_TRUNCATE', false) === true)
    <div class="col-md-6">
        <a onclick="return confirm('Are you sure? Data will not be restored')" href="{{route('master.settings.truncate-tables', ['mysql_prod' ,'question'])}}" class="btn btn-danger">TRUNCATE ALL TABLES related to Question Banks - Production</a>

        <a onclick="return confirm('Are you sure? Data will not be restored')" href="{{route('master.settings.truncate-tables', ['mysql_prod' ,'subject'])}}" class="btn btn-danger">TRUNCATE ALL Subjects TABLES  - Production</a>
    </div>
    @endif
</div>