@extends('layout.manage')

@section('css_page_level')
<link rel="stylesheet" type="text/css" href="{{ asset('assets/global/plugins/datatables/plugins/bootstrap/dataTables.bootstrap.css') }}"/>
<link rel="stylesheet" type="text/css" href="{{ asset('assets/global/plugins/bootstrap-datepicker/css/bootstrap-datepicker3.min.css') }}" />
<link rel="stylesheet" type="text/css" href="{{ asset('assets/global/plugins/bootstrap-fileinput/bootstrap-fileinput.css') }}"/>
<link rel="stylesheet" type="text/css" href="{{ asset('assets/global/plugins/select2/css/select2.css') }}"/>
<link rel="stylesheet" type="text/css" href="{{ asset('assets/global/plugins/select2/css/select2-bootstrap.min.css') }}"/>
<link rel="stylesheet" type="text/css" href="{{ asset('assets/global/plugins/bootstrap-select/1.12.2/bootstrap-select.min.css') }}"/>
<link rel="stylesheet" type="text/css" href="{{ asset('assets/global/plugins/bootstrap-select/bootstrap-select.min.css') }}"/>
@endsection

@section('page-content-wrapper')
    <div class="page-content-wrapper" id="main">
        <div class="page-content">
            <!-- BEGIN PAGE HEADER-->
            <h3 class="page-title">
            @inject('setting','anlutro\LaravelSettings\Facade')
            {{ $setting::get('system_name','全方位建築智慧化管理系統') }} <small>{{ $setting::get('company_name','新保科技') }}</small>
            </h3>
            <div class="page-bar">
                <ul class="page-breadcrumb">
                    <li>
                        <i class="fa fa-home"></i>
                        <a href="{{route('manage::index')}}">@lang('messages.homepage')</a>
                        <i class="fa fa-angle-right"></i>
                    </li>
                    <li>
                        <a href="">@lang('messages.pricing_system')</a>
                        <i class="fa fa-angle-right"></i>
                    </li>
                    <li>
                        <a href=""> @lang('messages.many_table') </a>
                        <i class="fa fa-angle-right"></i>
                    </li>
                    <li>
                        <a href=""> @lang('messages.tenant_electricity_divide') </a>
                    </li>
                </ul>
                <div class="page-toolbar">
                </div>
            </div>
            <!-- END PAGE HEADER-->
            <!-- BEGIN DASHBOARD STATS -->
            <div class="row">
                <div class="col-md-12">
                    <!-- BEGIN EXAMPLE TABLE PORTLET-->
                    <div class="portlet light bordered">
                        <div class="portlet-body">
                            <div class="table-toolbar">
                                <div class="row">
                                    <div class="col-md-12">
                                        <div class="btn-group pull-right">
                                            <a class="btn purple dropdown-toggle pull-right" href="javascript:;" id="btn_for_one"> 特定承租戶電費 </a>
                                        </div>
                                        <div class="btn-group pull-right" style="margin-right: 5px">
                                            <a class="btn purple dropdown-toggle pull-right" href="javascript:;" id="btn_for_one_water"> 特定承租戶水費 </a>
                                        </div>
                                        @include('manage.payment.report_list')
                                        <div class="btn-group pull-right">
                                            <a class="btn purple dropdown-toggle pull-right" data-toggle="dropdown" href="javascript:;"> 快速篩選
                                                <i class="fa fa-angle-down"></i>
                                            </a>
                                            <ul class="dropdown-menu">
                                                <li>
                                                    <a href="javascript:;" id="btn_query"> 條件查詢 / 列印報表 </a>
                                                </li>
                                            </ul>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <table class="table table-striped table-bordered table-hover" id="table_payment">
                                <thead>
                                    <tr>
                                        <th>
                                            承租戶名稱
                                        </th>
                                        <th>
                                            NPPM編號
                                        </th>
                                        <th>
                                            NS編號
                                        </th>
                                        <th>
                                            設備
                                        </th>
                                    </tr>
                                </thead>
                                <tbody>
                                @foreach($user_facility as $one)
                                <tr>
                                    <td>
                                        {{$one->tenant_name}}
                                    </td>
                                    <td>
                                        {{$one->nppm_number}}
                                    </td>
                                    <td>
                                        {{$one->ns_number}}
                                    </td>
                                    <td>
                                        @if(!empty($one->facility_name))
                                        {{$one->facility_name}}
                                        @endif
                                    </td>
                                </tr>
                                @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                    <!-- END EXAMPLE TABLE PORTLET-->
                </div>
            </div>
        </div>
    <input type="hidden" id="_token" name="_token" value="{{ csrf_token() }}">
</div>
<div class="modal fade draggable-modal" id="modal_query" tabindex="-1" role="basic" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header bg-blue-madison">
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true"></button>
                <h4 class="modal-title font-white">條件查詢</h4>
            </div>
            <form id="form_query" action="" class="form-horizontal" target="_blank">
                <div class="modal-body">
                    <div class="form-body">
                        <div class="form-group">
                            <label class="col-md-2 control-label">年:</label>
                            <div class="col-md-4">
                                <select name="year" id="years" class="form-control selectpicker" data-live-search="true"> 
                                    @foreach($year_month as $one)
                                    <option value="{{$one['year']}}">{{$one['year']}}</option>
                                    @endforeach
                                </select>
                            </div>
                            <label class="col-md-1 control-label">月:</label>
                            <div class="col-md-4">
                                <select name="month" id="months" class="form-control selectpicker" data-live-search="true"> 
                                    <option value="">未選擇</option>
                                </select>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-info" id="btn_excel_list">Excel下載(List)</button>
                    <button type="button" class="btn btn-info" id="btn_list">列印(List)</button>
                    <button type="button" class="btn btn-success" id="btn_report">列印(Report)</button>
                    <button type="button" class="btn gray" data-dismiss="modal">@lang('messages.close')</button>
                    
                    <!-- <button type="button" class="btn btn-info" id="btn_query_submit">查詢</button> -->
                </div>
            </form>
        </div>
        <!-- /.modal-content -->
    </div>
    <!-- /.modal-dialog -->
</div>
<div class="modal" id="modal_select_time"  role="dialog">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true"></button>
                    <h4 class="modal-title">特定承租戶電費分算表</h4>
                </div>
                <div class="modal-body form">
                    <!-- BEGIN FORM-->
                    <form id="elec_select_form" method="POST">
                        <div class="form-body">
                            <input name="id" type="hidden">
                            <blockquote>
                                <h4>選擇特定承租戶</h4>
                            </blockquote>
                            <div class="form-group">
                                <div class="col-md-5" id="facility">
                                    <select name="facility_select[]" id="facility_select" class="form-control selectpicker" data-live-search="true" multiple>
                            
                                    </select>
                                </div>
                            </div>
                            <div class="form-group"> </div>
                            <blockquote>
                                <h4>選擇年月份</h4>
                            </blockquote>
                             <div class="form-group">
                            <label class="col-md-2 control-label">年:</label>
                            <div class="col-md-4">
                                <select name="year" id="year" class="form-control selectpicker" data-live-search="true"> 

                                </select>
                            </div>
                            <label class="col-md-1 control-label">月:</label>
                            <div class="col-md-4">
                                <select name="month" id="month" class="form-control selectpicker" data-live-search="true"> 
                                    
                                </select>
                            </div>
                        </div>
                        </div>   
                    <!-- END FORM-->
                </div>
                <div class="modal-footer" style="margin-top: 10px">
                    <input type="hidden" id="_token" name="_token" value="{{ csrf_token() }}">
                    <button id ="submit_for_one" type="button" class="btn blue">查看</button>
                    <button type="button" class="btn default" data-dismiss="modal">@lang('messages.close')</button>
                </div>
                </form>
            </div>
            <!-- /.modal-content -->
        </div>
        <!-- /.modal-dialog -->
</div>

<div class="modal" id="modal_select_time_water"  role="dialog">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true"></button>
                    <h4 class="modal-title">特定承租戶水費分算表</h4>
                </div>
                <div class="modal-body form">
                    <!-- BEGIN FORM-->
                    <form id="water_select_form" action="{{ action('Manage\PaymentController@water_for_one') }}" method="POST">
                        <div class="form-body">
                            <input name="id" type="hidden">
                            <blockquote>
                                <h4>選擇特定承租戶</h4>
                            </blockquote>
                            <div class="form-group">
                                <div class="col-md-5" id="facility">
                                    <select name="facility_select_water[]" id="facility_select_water" class="form-control selectpicker" data-live-search="true" multiple="">
                                    </select>
                                </div>
                            </div>
                            <div class="form-group"></div>
                            <blockquote>
                                <h4>選擇年月份</h4>
                            </blockquote>
                             <div class="form-group">
                            <label class="col-md-2 control-label">年:</label>
                            <div class="col-md-4">
                                <select name="year_water" id="year_water" class="form-control selectpicker" data-live-search="true"> 
                                    
                                </select>
                            </div>
                            <label class="col-md-1 control-label">月:</label>
                            <div class="col-md-4">
                                <select name="month_water" id="month_water" class="form-control selectpicker" data-live-search="true"> 
                                    
                                </select>
                            </div>
                        </div>
                        </div>
                    <!-- END FORM-->
                </div>
                <div class="modal-footer" style="margin-top: 10px">
                    <input type="hidden" id="_token" name="_token" value="{{ csrf_token() }}">
                    <button id ="submit_for_one_water" type="button" class="btn blue">查看</button>
                    <button type="button" class="btn default" data-dismiss="modal">@lang('messages.close')</button>
                </div>
                </form>
            </div>
            <!-- /.modal-content -->

        </div>
        <!-- /.modal-dialog -->
</div>

@endsection

@section('plugins_page_level')
<script type="text/javascript" src="{{ asset('assets/global/plugins/jquery-validation/js/jquery.validate.min.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/jquery-validation/js/additional-methods.min.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/datatables/media/js/jquery.dataTables.min.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/datatables/plugins/bootstrap/dataTables.bootstrap.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/bootbox/bootbox.min.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/bootstrap-datepicker/js/bootstrap-datepicker.min.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/bootstrap-datepicker/locales/bootstrap-datepicker.zh-TW.min.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/bootstrap-fileinput/bootstrap-fileinput.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/bootstrap-fileinput/additional-methods.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/select2/js/select2.min.js') }}"></script>
<script type="text/javascript" src="{{ asset('assets/global/plugins/bootstrap-select/1.12.2/bootstrap-select.min.js') }}"></script>
@endsection

@section('js_page_level')
<script>
    $(document).ready(function(){
        var table = $('#table_payment');
        var oTable = table.dataTable({
            // Internationalisation. For more info refer to http://datatables.net/manual/i18n
            "language": {
                "aria": {
                    "sortAscending": ": activate to sort column ascending",
                    "sortDescending": ": activate to sort column descending"
                },
                "emptyTable": "@lang('messages.datatable_no_data')",
                "info": "@lang('messages.display_from') _START_ @lang('messages.display_to') _END_ @lang('messages.then_total') _TOTAL_ @lang('messages.records')",
                "infoEmpty": "@lang('messages.no_match')",
                "infoFiltered": "(@lang('messages.from') _MAX_ @lang('messages.records_filter'))",
                "lengthMenu": "@lang('messages.show') _MENU_ @lang('messages.records')",
                "search": "@lang('messages.quick_filter'):",
                "zeroRecords": "@lang('messages.no_data')",
                "paginate": {
                    "previous":"@lang('messages.last_page')",
                    "next": "@lang('messages.next_page')",
                    "last": "@lang('messages.lastest')",
                    "first": "@lang('messages.most_previous')"
                }
            },
            "aaSorting": [[0,'asc']],
            "lengthMenu": [
                [10, 20, 50, -1],
                [10, 20, 50, "All"] // change per page values here
            ],
            // set the initial value
            "pageLength": 10,            
            "pagingType": "bootstrap_full_number",
        });
    });
    $(document).on('click','#btn_report',function(){
        if( $('#months').val() != '' && $('#years').val() != '' ){
            var form = $('#form_query');
            form.attr("action", "{{ route('manage::payment::print_tenant_electricity_divide_report') }}");
            $('#form_query').submit();
        }else{
            toastr['error']('請選擇年月');
        }
    });
    $(document).on('click','#btn_list',function(){
        if( $('#months').val() != '' && $('#years').val() != '' ){
            var form = $('#form_query');
            form.attr("action", "{{ route('manage::payment::print_tenant_electricity_divide') }}");
            $('#form_query').submit();
        }else{
            toastr['error']('請選擇年月');
        }
    });
    $(document).on('click','#btn_query',function(){
        var year = $('#years').val();
        get_month(year);
        $('#modal_query').modal('show');
    }); 
    $(document).on('change','#years', function(){
        var year = $('#year').val();
        get_month(year);
    });
    $(document).on('click','#btn_excel_list',function(){
        if( $('#months').val() != '' && $('#years').val() != '' ){
            var form = $('#form_query');
            form.attr("action", "{{ route('manage::payment::electricity_divide_excel') }}");
            $('#form_query').submit();
        }else{
            toastr['error']('請選擇年月');
        }
    });

    function get_month(year){
        $.ajax({
            type : 'POST',
            url  : '{{ route('manage::payment::get_electricity_check') }}',
            data : {
                year : year,
                _token : $('#_token').val(),
            },
            success : function(sendback){
                $('#months').empty();
                if(sendback.month.length == 0){
                    toastr['warning']('該年度尚缺資料');
                }else{
                    for(var i = 0;i < sendback.month.length ;i++){
                        $('#months').append('<option value="' + sendback.month[i] + '">' + sendback.month[i] + '</option>');
                    }
                }                
                $('#months').selectpicker('refresh');
            }
        });
    }
    $(document).on('click','#submit_for_one',function(){
        if( $('#facility_select').val() != null && $('#year').val() != '' && $('#month').val() != ''){
            var form = $('#elec_select_form');
            form.attr("action", "{{ route('manage::payment::electric_for_one') }}");
            $('#elec_select_form').submit();
        }else{
            toastr['warning']('請確定所有欄位皆有選擇');
        }
    });

    $(document).on('click','#submit_for_one_water',function(){
        if( $('#facility_select_water').val() != null && $('#year_water').val() != '' && $('#month_water').val() != ''){
            var form = $('#water_select_form');
            form.attr("action", "{{ route('manage::payment::water_for_one') }}");
            $('#water_select_form').submit();
        }else{
            toastr['warning']('請確定所有欄位皆有選擇');
        }
    });
    $(document).on('click','#btn_for_one',function(){
        var year = $('#year').val();
        getNameList(year);
        $('#modal_select_time').modal('show');
    }); 

    $(document).on('click','#btn_for_one_water',function(){
        var year_water = $('#year_water').val();
        getNameListWater(year_water);
        $('#modal_select_time_water').modal('show');
    }); 

    $(document).on('change','#year', function(){
        var year = $('#year').val();
        getNameList(year);
    });
    $(document).on('change','#year_water', function(){
        var year_water = $('#year_water').val();
        getNameListWater(year_water);
    });

    var getNameList = function(year){
        $.ajax({
            type  : 'POST',
            dataType : 'json',
            url   : "{{ route('manage::payment::get_name_list') }}",
            data  : {
                _token   : $('#_token').val(),
                year : year,
            },
            success : function(sendback){
                $('#month').html('');
                    
                if (year == null){
                    $.each(sendback.electric, function(i, obj) {
                        var html ='<option value="' + obj.nppm_number + '">'+obj.tenant_name +'-'+ obj.nppm_number +'</option>';
                        $('#facility_select').append(html);
                    });
                    $('#facility_select').selectpicker('refresh');
                    $.each(sendback.year_only, function(i, obj) {
                       var html ='<option>'+obj.year+'</option>';
                       $('#year').append(html);
                    });
                    $('#year').selectpicker('refresh');
                }
                $.each(sendback.month, function(i, obj) {
                    var html ='<option>'+obj+'</option>';
                    $('#month').append(html);
                });
                
                $('#month').selectpicker('refresh');

                
            },
            error  : function(sendback){

            }
        });
    }

    var getNameListWater = function(year_water){
        $.ajax({
            type  : 'POST',
            dataType : 'json',
            url   : "{{ route('manage::payment::get_name_list_water') }}",
            data  : {
                year : year_water,
                _token   : $('#_token').val(),
            },
            success : function(sendback){
                $('#month_water').html('');
                
                if (year_water == null){
                    $.each(sendback.water, function(i, obj) {
                        var html ='<option value="' + obj.nppm_number + '">'+obj.tenant_name +'-'+ obj.nppm_number +'</option>';
                        $('#facility_select_water').append(html);
                    });
                    $('#facility_select_water').selectpicker('refresh');
                    $.each(sendback.year_only, function(i, obj) {
                        var html ='<option>'+obj.year+'</option>';
                        $('#year_water').append(html);
                    });
                    $('#year_water').selectpicker('refresh');
                }
               
                $.each(sendback.month, function(i, obj) {
                    var html ='<option>'+obj+'</option>';
                    $('#month_water').append(html);
                });
                $('#month_water').selectpicker('refresh');
                
            },
            error  : function(sendback){
            }
        });
    }


</script>
@endsection