@include('microfin/miscellaneous/monthEndPendingAlert')

<style>
    .text-left{
        text-align: left !important;
        padding-left: 1em !important;
    }
    .text-center{
        text-align: center !important;
    }
    .text-right{
        text-align: right !important;
        padding-right: 1em !important;
    }

    .subTotalTr td{
        background-color: #9cb1d3;
    }
    .grandTotal td{
        background-color: #819bc4;
    }
    .funTotal td{
        background-color: #8296b7;
    }
    .allFunOrgTotal td{
        background-color: #55729e;
    }
    .note{
        color: white;
        font-size: 10px;
        margin-top: 1px;
    }

    .caption_tr td{
        background-color: #28a745 !important;
        font-size: larger !important;
    }
    .sub_total_tr td{
        background-color: #ffc107 !important;
        /*font-size: larger !important;*/
        font-weight: bolder !important;
    }
    .grand_total_tr td{
        background-color: #007bff !important;
        /*font-size: larger !important;*/
        font-weight: bolder !important;
    }

    .hide_class {
        display: none !important;
    }
    
    .width_25 {
        width: 25vw !important;
        min-width: 25vw !important;
        max-width: 25vw !important;
    }
    .width_30 {
        width: 30vw !important;
        min-width: 30vw !important;
        max-width: 30vw !important;
    }
    .width_35 {
        width: 35vw !important;
        min-width: 35vw !important;
        max-width: 35vw !important;
    }
    .width_40 {
        width: 40vw !important;
        min-width: 40vw !important;
        max-width: 40vw !important;
    }
    .width_45 {
        width: 45vw !important;
        min-width: 45vw !important;
        max-width: 45vw !important;
    }
    .width_50 {
        width: 50vw !important;
        min-width: 50vw !important;
        max-width: 50vw !important;
    }
    
    .border-right {
        border-right-color: rgba(153, 153, 153, 0.5) !important;
    }
    
    .hidden {
      display: none !important;
      visibility: hidden !important;
    }

</style>

<div id="printDiv">

    {{-- div for Company --}}
    <div class="row" style="padding-bottom: 10px; text-align: center; vertical-align: middle; color: black; font-weight: bold;">
        <span style="font-size:14px;">{{$company->name}}</span><br />
        <span style="font-size:11px;">{{$company->address}}</span><br />
        <span style="font-size:11px;">Month: {{ $filMonth }}</span><br />
        <span style="text-decoration: underline;  font-size:14px;">OLRS Accounting {{ ucfirst($dataType) }} Data</span>
    </div>

    {!! Form::open(array('url' => '', 'id' => 'inputForm', 'role' => 'form', 'class'=>'form-horizontal form-groups')) !!}

    <div class="row">
        <div class="col-lg-12">
            <div class="table-responsive">

                <table id="pomisOne1" width="100%" class="table table-striped table-bordered pomisOne" border="1pt solid ash" style="color:black; border-collapse: collapse;">
                    
                    <thead>
                        <tr>
                            @php
                                if($accgroup == 'BS' || $accgroup == 'IS') { 
                                    $colspanVal = 2;
                                    $width_class = ($is_migrated) ? 'width_40' : 'width_50';
                                }
                                if($accgroup == 'RP') { 
                                    $colspanVal = 4;
                                    $width_class = ($is_migrated) ? 'width_30' : 'width_40';
                                }
                            @endphp 

                            <th class="{{ $width_class }}" rowspan="2" class="border-right">{{ ucfirst($dataType) }}</th>
                            
                            <th colspan="{{ $colspanVal }}" class="border-right">Processed Data</th>
                            
                            @if($is_migrated)
                                <th colspan="{{ $colspanVal }}" class="border-right">Migrated Data</th>                            
                            @endif
                            
                        </tr>

                        <tr>                            
                            @if($accgroup == 'BS')

                                <th>Last June</th>
                                <th class="border-right">This Month</th>
                                
                                @if($is_migrated)
                                    <th>Last June</th>
                                    <th class="border-right">This Month</th>
                                @endif
                                
                            @elseif($accgroup == 'IS')
                            
                                <th>This Month</th>
                                <th class="border-right">This Fiscal Year</th>
                                
                                @if($is_migrated)
                                    <th>This Month</th>
                                    <th class="border-right">This Fiscal Year</th>
                                @endif

                            @elseif($accgroup == 'RP')

                                <th>This Month Cash</th>
                                <th>This Fiscal Year Cash</th>
                                <th>This Month Non-Cash</th>
                                <th class="border-right">This Fiscal Year Non-Cash</th>
                                
                                @if($is_migrated)
                                    <th>This Month Cash</th>
                                    <th>This Fiscal Year Cash</th>
                                    <th>This Month Non-Cash</th>
                                    <th class="border-right">This Fiscal Year Non-Cash</th>
                                @endif

                            @endif
                        </tr>


                    </thead>

                    <tbody>

                            {{ Form::hidden('mnyr', $mnyr) }}
                            {{ Form::hidden('filMonth', $filMonth) }}
                            {{ Form::hidden('dataType', $dataType) }}
                            {{ Form::hidden('accgroup', $accgroup) }}
                            {{ Form::hidden('olrs_migType', $olrs_migType) }}

                            {{ Form::hidden('company_code', $company_code) }}
                            {{ Form::hidden('po_code', $po_code) }}
                            {{ Form::hidden('company_branch_code', $company_branch_code) }}
                            {{ Form::hidden('finance_code', $finance_code) }}
                            {{ Form::hidden('project_code', $project_code) }}
                            {{ Form::hidden('component_code', $component_code) }}
                            {{ Form::hidden('coa_id', $coa_id) }}

                            @php
                                $it = 0;
                                $counter = count($constValues);

                                $grandTotal = (object) [
                                    'this_month_cash'    => array_sum(array_column($indicators, 'this_month_cash')),
                                    'last_june'          => array_sum(array_column($indicators, 'last_june')),
                                    'this_month_noncash' => array_sum(array_column($indicators, 'this_month_noncash')),
                                    'this_fy_cash'       => array_sum(array_column($indicators, 'this_fy_cash')),
                                    'this_fy_noncash'    => array_sum(array_column($indicators, 'this_fy_noncash')),
                                    
                                    'this_month_cash_migrated'     => array_sum(array_column($indicators, 'this_month_cash_migrated')),
                                    'this_month_noncash_migrated'  => array_sum(array_column($indicators, 'this_month_noncash_migrated')),
                                    'this_fy_cash_migrated'        => array_sum(array_column($indicators, 'this_fy_cash_migrated')),
                                    'this_fy_noncash_migrated'     => array_sum(array_column($indicators, 'this_fy_noncash_migrated')),
                                    'last_june_migrated'           => array_sum(array_column($indicators, 'last_june_migrated'))
                                ];
                            @endphp

                            @while($it < $counter) 
                                
                                @include('microfin.process.olrs.accountsDataTableHelper', array( 
                                    'captions'    => $constValues[$it]['CAPTION'],
                                    'ac_codes'    => $constValues[$it]['AC_CODES'],
                                    'indicators'  => $indicators,
                                    'dataType'    => $dataType,
                                    'accgroup'    => $accgroup,
                                    'colspan'     => $colspan,
                                    'is_migrated' => $is_migrated
                                ))

                                @php $it += 1; @endphp

                            @endwhile

                            <tr class="grand_total_tr">
                                <td class="text-left border-right"> Total </td>

                                @if($accgroup == 'BS')

                                    <td class="text-right">{{ number_format( $grandTotal->last_june, 2) }}</td>
                                    <td class="text-right border-right">{{ number_format( $grandTotal->this_month_cash, 2) }}</td>
                                    
                                    @if($is_migrated)
                                        <td class="text-right">{{ number_format( $grandTotal->last_june_migrated, 2) }}</td>
                                        <td class="text-right border-right">{{ number_format( $grandTotal->this_month_cash_migrated, 2) }}</td>
                                    @endif
                                    
                                @elseif($accgroup == 'IS')
                                
                                    <td class="text-right">{{ number_format( $grandTotal->this_month_cash, 2) }}</td>
                                    <td class="text-right border-right">{{ number_format( $grandTotal->this_fy_cash, 2) }}</td>
                                    
                                    @if($is_migrated)
                                        <td class="text-right">{{ number_format( $grandTotal->this_month_cash_migrated, 2) }}</td>
                                        <td class="text-right border-right">{{ number_format( $grandTotal->this_fy_cash_migrated, 2) }}</td>
                                    @endif

                                @elseif($accgroup == 'RP')

                                    <td class="text-right">{{ number_format( $grandTotal->this_month_cash, 2) }}</td>
                                    <td class="text-right">{{ number_format( $grandTotal->this_fy_cash, 2) }}</td>
                                    <td class="text-right">{{ number_format( $grandTotal->this_month_noncash, 2) }}</td>
                                    <td class="text-right border-right">{{ number_format( $grandTotal->this_fy_noncash, 2) }}</td>
                                    
                                    @if($is_migrated)
                                        <td class="text-right">{{ number_format( $grandTotal->this_month_cash_migrated, 2) }}</td>
                                        <td class="text-right">{{ number_format( $grandTotal->this_fy_cash_migrated, 2) }}</td>
                                        <td class="text-right">{{ number_format( $grandTotal->this_month_noncash_migrated, 2) }}</td>
                                        <td class="text-right border-right">{{ number_format( $grandTotal->this_fy_noncash_migrated, 2) }}</td>
                                    @endif

                                @endif

                            </tr>

                            <tr>
                                <td colspan="{{$colspan}}">
                                    <button class=" btn-lg btn-primary pull-right" id="submitButton">
                                        <i class="fa fa-exchange"> </i> Migrate to OLRS Server
                                    </button>                                   
                                </td>
                            </tr>

                            
                    </tbody>

                </table>

            </div>
        </div>
    </div>

    {!! Form::close() !!}   


<script type="text/javascript">

    $(document).ready(function() {

        $("#loadingModal").hide();
        
        $('#inputForm').submit(function(event) {

            event.preventDefault();

            $("#loadingModal").show();
            $("#submitButton").prop("disabled", true);

            let csrf = "{{csrf_token()}}";
            let serializeValue=$(this).serialize();
            
            $.ajax({
                type: 'post',
                url:  "{{ URL::to('/acc/olrs/accountingdata/store/') }}",
                data: serializeValue,
                dataType: 'json',
                success: function(_response) {
                    if (_response.responseTitle == 'Success!') {
                        toastr.success(_response.responseText, _response.responseTitle, opts);
                        setTimeout(function() {
                            location.reload();
                        }, 3000);
                    } else if (_response.responseTitle == 'Warning!') {
                        toastr.warning(_response.responseText, _response.responseTitle, opts);
                    }
                },
                error: function(_response) {
                    toastr.warning(_response.responseText, _response.responseTitle, opts);
                }
            }); //ajax

        }); // form submit  

    }); // ready
</script>