@extends('main')
@section('title', '首頁')
@section('main_content')
            <!-- Recent Sales Start -->
            <div class="container-fluid pt-4 px-4">
                <div class="col-sm-12 col-xl-6">
                    <div class="bg-light rounded h-100 p-4">
                        <h6 class="mb-4">查詢</h6>
                        <form>
                            <div class="row mb-3">
                                <label for="search_date" class="col-sm-2 col-form-label">搜尋</label>
                                <div class="col-sm-10">
                                    <input type="text" class="form-control" id="search_name" value="{{$search_name}}">
                                </div>
                                <label for="search_date" class="col-sm-2 col-form-label">業務</label>
                                <div class="col-sm-10">
                                    <select class="form-select form-select-sm mb-3" aria-label=".form-select-sm example" name="search_business" id="search_business">
                                        <option value="0"
                                            @if ($search_business==0)
                                                selected
                                            @endif >全部</option>
                                        @foreach ($agentlines as $agentline )
                                            <option value="{{ $agentline->id}}"
                                            @if ($search_business==$agentline->id)
                                                selected
                                            @endif >{{ $agentline->agent}}-{{ $agentline->name}}</option>
                                        @endforeach
                                    </select>
                                </div>
                                <label for="search_date" class="col-sm-2 col-form-label">狀態</label>
                                <div class="col-sm-10">
                                    <select class="form-select form-select-sm mb-3" aria-label=".form-select-sm example" name="search_istatus" id="search_istatus">
                                        <option value="0"
                                            @if ($search_istatus==-1)
                                                selected
                                            @endif >全部</option>
                                            <option value="2"
                                                @if ($search_istatus==2)
                                                    selected
                                                @endif >正常</option>
                                    </select>
                                </div>
                                <label for="search_date" class="col-sm-2 col-form-label">日期</label>
                                <div class="col-sm-10">
                                    <input class="form-check-input" type="checkbox" role="switch"
                                    id="flexSwitchCheckDefault">
                                    <label class="form-check-label" for="flexSwitchCheckDefault">依日期查詢</label>
                                    <input type="date" class="form-control" id="search_date_std" value="{{$search_date_std}}" onfocus="this.showPicker()">到
                                    <input type="date" class="form-control" id="search_date_etd" value="{{$search_date_etd}}" onfocus="this.showPicker()">
                                </div>
                            </div>
                            <button type="button" class="btn btn-success" onclick="changedate('nowtime','nowtime')">預設</button>
                            <button type="button" class="btn btn-dark" onclick="changedate('nowtime','nowtime')">今天</button>
                            <button type="button" class="btn btn-dark" onclick="changedate('lasttime','lasttime')">昨天</button>
                            <button type="button" class="btn btn-dark" onclick="changedate('nowweek_std','nowweek_etd')">本週</button>
                            <button type="button" class="btn btn-dark" onclick="changedate('nowmonth_std','nowmonth_etd')">本月</button>
                            <button type="button" class="btn btn-dark" onclick="changedate('lastmonth_std','lastmonth_etd')">上個月</button>
                            <button type="button" class="btn btn-dark" onclick="changedate('nowyear_std','nowyear_etd')">今年</button>
                            <button type="button" class="btn btn-primary" onclick="filterColumn()">查詢</button>
                            <input type="hidden" id="nowtime" value="{{$nowtime}}">
                            <input type="hidden" id="lasttime" value="{{$lasttime}}">
                            <input type="hidden" id="nowweek_std" value="{{$nowweek_std}}">
                            <input type="hidden" id="nowweek_etd" value="{{$nowweek_etd}}">
                            <input type="hidden" id="lastmonth_std" value="{{$lastmonth_std}}">
                            <input type="hidden" id="lastmonth_etd" value="{{$lastmonth_etd}}">
                            <input type="hidden" id="nowmonth_std" value="{{$nowmonth_std}}">
                            <input type="hidden" id="nowmonth_etd" value="{{$nowmonth_etd}}">
                            <input type="hidden" id="nowyear_std" value="{{$nowyear_std}}">
                            <input type="hidden" id="nowyear_etd" value="{{$nowyear_etd}}">
                        </form>
                    </div>
                </div>
            </div>

            <div class="container-fluid pt-4 px-4">
                <div class="bg-light text-center rounded p-4">
                    <div class="d-flex align-items-center justify-content-between mb-4">
                        <h6 class="mb-0">顧客</h6>
                        <a href="/customer/add">創建新客戶</a>
                    </div>
                    <div class="table-responsive" style="background-color: #FFF">
                        <table id="tablelist2" class="display" style="width:100%">
                            <thead>
                                <tr>
                                    {{-- <th>號碼</th> --}}
                                    <th>客戶代碼</th>
                                    <th>業務</th>
                                    <th>身份證</th>
                                    <th>姓名</th>
                                    <th>電話號碼</th>
                                    <th>建立日期</th>
                                    <th>備註</th>
                                    <th>貸款筆數</th>
                                    <th>貸款已完成</th>
                                    <th>貸款呆帳</th>
                                    <th>貸款呆帳已完成</th>
                                    <th>貸款全部</th>
                                    <th>貸款[高風險]</th>
                                    <th></th>
                                </tr>
                            </thead>
                        </table>
                    </div>
                </div>
            </div>
            <!-- Recent Sales End -->
@endsection
@section('footer_js')
<script>
    function filterColumn () {
         var str = '';
         var selectid = 0;
         if ($('#flexSwitchCheckDefault').is(":checked")) {
            selectid = 1;
         }
         //alert(selectid);return;
         //搜尋0|業務1|狀態2|是否日期搜尋3|日期std4|日期etd5
         var data={};
         data["search_name"] = $('#search_name').val();
         data["search_business"] = $('#search_business').find('option:selected').val();
         data["search_istatus"] = $('#search_istatus').find('option:selected').val();
         data["selectdate"] = selectid;
         data["search_date_std"] = $('#search_date_std').val();
         data["search_date_etd"] = $('#search_date_etd').val();
         var str =JSON.stringify(data);
         /* str = $('#search_name').val()+"|"+
               $('#search_business').val()+"|"+
               $('#search_istatus').val()+"|"+
               selectid+"|"+
               $('#search_date_std').val()+'|'+
               $('#search_date_etd').val(); */
         $('#tablelist2').DataTable().search(str).draw();
    }

    function changedate(std,etd) {
        $('#search_date_std').val($('#'+std).val());
        $('#search_date_etd').val($('#'+etd).val());
    }

    $(document).ready(function(){
        new DataTable('#tablelist2', {
            'dom': 'lrtip',
            ajax: {
                url: '/customer/list',
                type: 'GET',
            },
            columns: [
                /* { data: null, orderable: false, searchable: false, render: DataTable.render.select()}, */
                { data: 'serId' },
                { data: 'agentline' },
                { data: 'codeid' },
                { data: 'name' },
                { data: 'gsm' },
                { data: 'create_date' },
                { data: 'memo' },
                { data: 'loan_cs' },
                { data: 'loan_finish' },
                { data: 'loan_baddebt' },
                { data: 'loan_baddebt_finish' },
                { data: 'loan_all' },
                { data: 'loan_highrisk' },
                {
                  "render": function ( data, type, full) {
                    //return '<button type="button" class="btn btn-success" onclick="alert(\''+full['DT_RowId']+'\')">PAY</button>';
                    return '<a href="/customer/edit/'+full['RowId']+'" class="btn btn-sm btn-primary m-2" role="button">編輯</a>' +
                    '<a href="javascript:;" onclick="do_delete('+full['RowId']+')" class="btn btn-sm btn-danger m-2" role="button">刪除</a>' +
                    '<a href="javascript:;" onclick="do_addloan('+full['RowId']+')" class="btn btn-sm btn-success m-2" role="button">新增貸款</a>';

                  }
                },
            ],
            order: [[1, 'asc']],
            processing: true,
            serverSide: true
        });
        /* $('#example tbody').on('click', '.name', function () {
        var row = $(this).closest('tr');

        var data = table.row( row ).data().name;
        console.log(data);
        });


        $('#example tbody').on('click', '.position', function () {
        var row = $(this).closest('tr');

        var data = table.row( row ).data().position;
        console.log(data);
        });*/
    });

    function do_addloan(id) {
        location.href = 'customer/addloan/'+ id
    }

    function do_delete(id) {
        $.confirm({
            title: '注意!',
            content: '請注意此功能，若刪除後，資料是救不回的。確定要刪除嗎?!',
            buttons: {
                confirm: {
                    text: '確定',
                    action: function () {
                        $.ajax({
                            url: '/customer/delete/'+id,
                            type: 'DELETE',
                            data: {
                                '_token': "{{ csrf_token() }}",
                            },
                            success: function(result) {
                                if (result.code=="Ok"){
                                    $.confirm({
                                        title: '成功!',
                                        content: '刪除成功!',
                                        buttons: {
                                            confirm: {
                                                text: '確定',
                                                action: function () {
                                                    location.href = '/customer';
                                                }
                                            }
                                        }
                                    });
                                }else{
                                    $.alert({
                                        title: '注意!',
                                        content: result.message,
                                    });
                                }
                            }
                        });
                    }
                },
                cancel: {
                    text: '取消',
                    action: function() {
                        //$.alert('Canceled!');
                    }
                },
            }
        });
    }
</script>
@endsection