@extends('layouts/microfin_layout')
@section('title', '| Update Month End Info Process')
@section('content')

@php
    use App\Http\Controllers\microfin\MicroFin;
    use Carbon\Carbon;

    $branchList = ['' => 'Select'] + MicroFin::getBranchList();
    //$branchList = \DB::table('gnr_branch')->orderBy('branchCode')->select(DB::raw("CONCAT(LPAD(branchCode, 3, 0), ' - ', name) AS nameWithCode"), 'id')->pluck('nameWithCode', 'id')->all();
    if(Auth::user()->id == 1){ //Case of Super Admin
        $methodList = array(
            ''=> 'Select',
            1 => 'Store Total Member Info',
            2 => 'Store Member Info',
            3 => 'Store Member Info Category Wise',
            4 => 'Store Savings Info',
            5 => 'Store Loan Info',
            6 => 'Store Staff Info',
            7 => 'Store Independent Branch Info',
            8 => 'Store Hr Staff Employee Info',

            // 9 => 'Store Member Info Update Only',
            // 10 => 'Store Member Info Category Wise Update Only',

            // 11 => 'Store Loan Info For Per Ratio',

            12 => 'Store National Database Loans Summary',
            13 => 'Store National Database Savings Summary',

            // 14 => 'Store Total Member Info Update Only',
            15 => 'Member wise valid samity Summary',
            // 98 => 'Execute Borrower Update Methods',
            // 99 => 'Execute Member And Samity Update Methods',

            // 100 => 'Execute Employment Info (June / December)',
            'samityWiseSummary' => 'Samity Wise Summary (FY Closing)',
        );
    }else{ //Case of W/O Super Admin
        $methodList = array(
            ''=> 'Select',
            // 1 => 'Store Total Member Info',
            // 2 => 'Store Member Info',
            // 3 => 'Store Member Info Category Wise',
            //4 => 'Store Savings Info',
            //5 => 'Store Loan Info',
            // 6 => 'Store Staff Info',
            // 7 => 'Store Independent Branch Info',
            // 8 => 'Store Hr Staff Employee Info',

            // 9 => 'Store Member Info Update Only',
            // 10 => 'Store Member Info Category Wise Update Only',

            // 11 => 'Store Loan Info For Per Ratio',

            // 12 => 'Store National Database Loans Summary',
            // 13 => 'Store National Database Savings Summary',

            // 14 => 'Store Total Member Info Update Only',
            // 15 => 'Member wise valid samity Summary',
            // 98 => 'Execute Borrower Update Methods',
            // 99 => 'Execute Member And Samity Update Methods',

            // 100 => 'Execute Employment Info (June / December)',
            // 'samityWiseSummary' => 'Samity Wise Summary (FY Closing)',
        );
    }
    // $date = Carbon::parse(Carbon::now()->subMonth()->endOfMonth()->toDateString())->format('d-m-Y');
@endphp


<div class="row">
    <div class="col-md-12">

        <div class="" style="">
            <div class="">
                <div class="panel panel-default" style="background-color:#708090;">
                    <div class="panel-heading" style="padding-bottom:0px">
                        <div class="panel-options">


                        </div>
                        <h3 style=" text-align: center; font-family: Antiqua; letter-spacing: 2px; color: white;">Update Month End Info Process</h3>
                    </div>

                    <div class="panel-body panelBodyView">

                        <!-- Filtering Start -->
                        {!! Form::open(array('url' => '', 'role' => 'form', 'class'=>'form-horizontal form-groups', 'id' => 'filterFormId', 'method'=>'get')) !!}
                        <div class="row">
                            <div class="col-md-12">

                                <div class="col-md-1" id="branchDiv">
                                    <div class="form-group">
                                        <div class="col-md-12">
                                            {!! Form::label('', 'Branch:', ['class' => 'control-label pull-left']) !!}
                                        </div>
                                        <div class="col-md-12">
                                            {!! Form::select('branchId', $branchList, null ,['id'=>'branchId','class'=>'form-control input-sm','autocomplete'=>'off']) !!}
                                        </div>
                                    </div>
                                </div>

                                <div class="col-md-1" id="branchDiv">
                                    <div class="form-group">
                                        <div class="col-md-12">
                                            {!! Form::label('', 'Method:', ['class' => 'control-label pull-left']) !!}
                                        </div>
                                        <div class="col-md-12">
                                            {!! Form::select('methodNo', $methodList, null ,['id'=>'methodNo','class'=>'form-control input-sm','autocomplete'=>'off']) !!}
                                        </div>
                                    </div>
                                </div>

                                <div class="col-md-1">
                                    <div class="form-group">
                                        <div class="col-md-12">
                                            {!! Form::label('', 'Date From:', ['class' => 'control-label pull-left']) !!}
                                        </div>
                                        <div class="col-md-12">
                                            {!! Form::text('startMonth', null,['id'=>'startMonth','class'=>'form-control input-sm readonly', 'autocomplete'=>'off','style'=>'cursor:pointer;']) !!}
                                        </div>
                                    </div>
                                </div>

                                <div class="col-md-1">
                                    <div class="form-group">
                                        <div class="col-md-12">
                                            {!! Form::label('', 'Date To:', ['class' => 'control-label pull-left']) !!}
                                        </div>
                                        <div class="col-md-12">
                                            {!! Form::text('endMonth', null,['id'=>'endMonth','class'=>'form-control input-sm readonly', 'autocomplete'=>'off','style'=>'cursor:pointer;']) !!}
                                        </div>
                                    </div>
                                </div>

                                <div class="col-md-1">
                                    <div class="form-group">
                                        <div class="col-md-12">
                                            {!! Form::label('', '&nbsp;', ['class' => 'control-label pull-left']) !!}
                                        </div>
                                        <div class="col-md-12">
                                            {!! Form::submit('Run process', ['id' => 'runProcess', 'class' => 'btn btn-primary btn-sm']); !!}
                                        </div>
                                    </div>
                                </div>

                            </div>
                        </div>
                        {!! Form::close() !!}
                        <!-- filtering end-->

                        <div class="row">
                            <div class="col-md-12" id="reportingDiv">

                            </div>
                        </div>
                    </div> {{-- panel-body panelBodyView DIV --}}
                </div>
            </div>
        </div>
    </div>
</div>

<script type="text/javascript">
    $(document).ready(function() {
        /*/
        $("#runProcess").click(function(event) {
            event.preventDefault()
            autoRunProcess()
        });
        async function autoRunProcess()
        {
            let startMonth  = ''
            let endMonth    = ''
            let methodNo    = $("#methodNo").val()
            let branchId     = parseInt( $("#branchId option:selected").val() )
            let lastBranchId = parseInt( $('#branchId option:last').val() )
            while (branchId <= lastBranchId)
            {
                startMonth  = '01-06-2022'
                endMonth    = '30-06-2022'
                callProcess(branchId, startMonth, endMonth, methodNo)
                startMonth  = '01-07-2022'
                endMonth    = '31-07-2022'
                callProcess(branchId, startMonth, endMonth, methodNo)
                startMonth  = '01-08-2022'
                endMonth    = '31-08-2022'
                callProcess(branchId, startMonth, endMonth, methodNo)
                startMonth  = '01-09-2022'
                endMonth    = '30-09-2022'
                callProcess(branchId, startMonth, endMonth, methodNo)
                startMonth  = '01-10-2022'
                endMonth    = '31-10-2022'
                callProcess(branchId, startMonth, endMonth, methodNo)
                startMonth  = '01-11-2022'
                endMonth    = '30-11-2022'
                callProcess(branchId, startMonth, endMonth, methodNo)
                startMonth  = '01-12-2022'
                endMonth    = '31-12-2022'
                callProcess(branchId, startMonth, endMonth, methodNo)

                if (branchId == lastBranchId) break;
                $('#branchId option:selected').next().attr('selected', 'selected')
                branchId = parseInt( $('#branchId option:selected').val() )
            }
        }
        function callProcess(branchId, startMonth, endMonth, methodNo)
        {
            console.log(branchId, startMonth, endMonth, methodNo)
            $.ajax({
               url: `./updateMonthEndInfo/${branchId}/${startMonth}/${endMonth}/${methodNo}`
            })
            .done(function(data) {
                if (data.responseTitle=='Success!') {
                    toastr.success(data.responseText, data.responseTitle, opts)
                }
            })
            .fail(function() {
                toastr.warning('Error')
            })
        }
        //*/

        //*
        $("form").submit(function(event) {



            if($('#branchId').val() == ""){
                toastr.warning("Please select branch.", "Attention!");
                return false;
            }

            if($('#methodNo').val() == ""){
                toastr.warning("Please select method.", "Attention!");
                return false;
            }

            if($('#startMonth').val() == ""){
                toastr.warning("Please select date from.", "Attention!");
                return false;
            }

            if($('#endMonth').val() == ""){
                toastr.warning("Please select date to.", "Attention!");
                return false;
            }

            event.preventDefault();

            var branchId = $("#branchId").val();
            var startMonth = $("#startMonth").val();
            var endMonth = $("#endMonth").val();
            var methodNo = $("#methodNo").val();

            console.log(branchId, startMonth, endMonth, methodNo)
            // return

            if (startMonth > endMonth) {
                toastr.warning('start date is greater than end date');
                return;
            }

            $('#loadingModal').show();

            $.ajax({
                    url: `./updateMonthEndInfo/${branchId}/${startMonth}/${endMonth}/${methodNo}`
                })
                .done(function(data) {
                    if (data.responseTitle == 'Success!') {
                        toastr.success(data.responseText, data.responseTitle, opts);
                        // setTimeout(function(){
                        //     location.reload();
                        // }, 2000);
                    }
                })
                .fail(function() {
                    alert("error");
                })
                .always(function() {
                    $("#loadingModal").hide();
                });
        });
        //*/

        $('#startMonth').datepicker({
            dateFormat: 'dd-mm-yy',
            changeYear: true,
            changeMonth: true
        });

        $('#startMonth').click(function() {
            this.value = '';
        });

        $('#endMonth').datepicker({
            dateFormat: 'dd-mm-yy',
            changeYear: true,
            changeMonth: true
        });

        $('#endMonth').click(function() {
            this.value = '';
        });
    });
</script>


@endsection