@extends('layouts.layout')
@section('title', 'QC Cashbox')
@section('body_class', 'nav-md')
@section('body_content')

<style>
    .btn-pill {
        border-radius: 5px;
    }
/*break_line*/
    .bl { 
    white-space: pre-wrap;
}
</style>
<div class="container body">
    <div class="main_container">
        @include('includes.sidebar')
        <div class="right_col" role="main">
            <div class="page-title">
                <div class="title_left">
                    <h3><i class="fa fa-edit"></i> QC Cashbox</h3>
                </div>
                <div class="clearfix"></div>
            </div>
            <div class="row">                
                <div class="col-xs-12">
                    <div class="x_panel">
                        <div class="x_title">
                            Filter (Unload Date)
                        </div>
                        <div class="x_content">
                            <form id="form-search" class="form-horizontal">
                                <div class="col-xs-12 col-sm-12">
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-3 control-label">Tanggal Mulai :</label>
                                        <div class="col-xs-12 col-sm-5">
                                            <input type="date" class="form-control date_format" name="from_date" id="from_date" value="{{ $request['from_date'] }}" placeholder="Tanggal Mulai">
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-3 control-label">Tanggal Selesai :</label>
                                        <div class="col-xs-12 col-sm-5">
                                            <input type="date" class="form-control date_format" name="end_date" id="end_date" value="{{ $request['end_date'] }}" placeholder="Tanggal Selesai">
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-3 control-label">Delivery Order :</label>
                                        <div class="col-xs-12 col-sm-5">
                                            <input type="text" class="form-control" name="do" id="do" value="{{ request('do') }}" placeholder="No DO">
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-3 control-label">QC Status :</label>
                                        <div class="col-xs-12 col-sm-5">
                                            <select class="form-control" name="status">
                                                <option value="all">All</option>
                                                <option value="uncompleted" @if($request['status'] == 'uncompleted') selected @endif>Uncompleted</option>
                                                <option value="done" @if($request['status'] == 'done') selected @endif>Done</option>
                                                <option value="cancelled" @if($request['status'] == 'cancelled') selected @endif>Cancelled</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-3 control-label">Toko :</label>
                                        <div class="col-xs-12 col-sm-5">
                                            <select class="form-control" name="store">
                                                <option value="all">All</option>
                                                @foreach($store_brands as $store_brand)
                                                    @foreach($store_brand->store as $store)
														@php
															$selected_store = '';
															if($request['store']) {
																if($request['store'] != 'all' && $request['store'] == $store->id) {
																	$selected_store = 'selected';
																}
															}
														@endphp
                                                        <option value="{{ $store->id }}") {{ $selected_store }}>{{ $store_brand->name }} {{ $store->name }}</option>
                                                    @endforeach
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="form-group" style="margin-top:20px">
                                        <label class="col-xs-12 col-sm-3 control-label"></label>
                                        <div class="col-xs-12 col-sm-5">
                                            <button type="submit" class="btn btn-primary"><i class="fa fa-search"></i> Search</button>
                                            <button type="button" class="btn btn-warning" id="reset_btn"><i class="fa fa-trash"></i> Reset</button>
                                            {{-- <a href="{{ route('butik/qc_cashbox/excel') }}">
                                                <button type="button" class="btn btn-success"> Download</button>
                                            </a> --}}
                                            <a id="download_excel" class="btn btn-success">
                                                <i class="fa fa-download"></i> Download
                                            </a>
                                        </div>
                                    </div>
                                </div>
                            </form>  
                        </div>
                    </div>
                </div>
            </div>
            <div class="row">                
                <div class="col-xs-12">
                    <div class="panel panel-default">
                        <div class="panel-body">
                            <table id="table_cashbox" class="table table-bordered table-striped">
                                <thead>
                                    <tr>
                                        <th>No.</th>
                                        <th>Delivery Order</th>
                                        <th>Receive From</th>
                                        <th>Unload Date</th>
                                        <th>QC Done At</th>
                                        <th>QC Status</th>
                                        <th width="25%">Actions</th>
                                    </tr>
                                </thead>
                                <tbody class="response" id="scroll">
                                    @foreach($query as $key => $data)
                                        @php
                                            $has_pg_qry = $data->store_resell_invoice();
                                            $has_pg = $has_pg_qry->whereHas('detail', function($detail) { $detail->where('item_brand_id', '15'); })->count();
                                            $count_pg = 0;
                                            if($has_pg) {
                                                $count_pg = \App\Models\Butik\Butik_store_resell_invoice_detail_model::whereHas('invoice', function($invoice) use($data){
                                                    $invoice->where('store_resellbox_unload_id', $data->id)
                                                        ->where('status', '4');
                                                })
                                                ->where('item_brand_id', 15)
                                                ->count();
                                            }

                                            $has_new_plu = $has_pg_qry->has('detail.new_item_plu')->count();
                                        @endphp
                                        <tr>
                                            <td>{{ $query->firstItem()+$key }}</td>
                                            <td>
                                                {{ $data->delivery_code }}
                                                @if($has_pg)
                                                    <div><i class="fa fa-check fa-success"></i> PG | {{ $count_pg }} Items</div>
                                                @endif
                                            </td>
                                            <td>{{ $data->receive_from_store->name }} <div><small>{{ $data->receive_from_store->brand->name }}</small></div></td>
                                            <td>{{ \Carbon\Carbon::parse($data->unload_date)->format('d M Y H:i') }}</td>
                                            <td>
                                                @if($data->qc_status == 'done')
                                                    @php
                                                        $qc_detail = \App\Models\Butik\Butik_store_resell_invoice_detail_model::whereHas('invoice.resellbox_unload', function($resellbox_unload) use($data) {
                                                            $resellbox_unload->where('qc_status', 'done')
                                                                ->whereId($data->id);
                                                        })
                                                        ->orderBy('qc_at', 'desc')
                                                        ->first();
                                                    @endphp

                                                    @if($qc_detail)
                                                        {{ $qc_detail->qc_at }}
                                                    @endif
                                                @endif
                                            </td>
                                            <td>
                                                @php
                                                    $label = '';
                                                    switch($data->qc_status) {
                                                    case 'cancelled':
                                                        $label = 'info';
                                                        break;
                                                    case 'uncompleted':
                                                        $label = 'danger';
                                                        break;
                                                    case 'in_progress':
                                                        $label = 'warning';
                                                        break;
                                                    case 'done':
                                                        $label = 'success';
                                                        break;
                                                    case 'moved_central':
                                                        $label = 'warning';
                                                        break;
                                                    case 'unloaded':
                                                        $label = 'default';
                                                        break;
                                                    case 'refinery':
                                                        $label = 'info';
                                                        break;
                                                    }
                                                @endphp
                                                <label class="label label-pill label-{{ $label }}">{{ $data->qc_status }}</label>
                                            </td>
                                            <td>
                                                @if($data->qc_status != 'cancelled')
                                                    @php
                                                        $disabled = 0;
                                                        if(in_array($data->received_from_store_id, $store_hub_member) && !in_array($data->received_from_store_id, [61, 53, 55, 67, 63])){
                                                            $disabled = 0;
                                                            if($data->received_by && $data->received_at) {
                                                                $disabled = 0;
                                                            }
                                                        }

                                                        $request_add_url = '?page=' . $request['page'] . '&from_date=' . $request['from_date'] . '&end_date=' . $request['end_date'] . '&do=' . $request['do'] . '&status=' . $request['status'] . '&store=' . $request['store'];
                                                    @endphp
                                                    <button type="button" onclick="window.location.href='{{ url('butik') }}/qc_cashbox/{{ $data->id }}/details_list{{ $request_add_url  }}'" title="Lihat Detail" data-id="{{ $data->id }}" class="see_detail btn btn-primary btn-white btn-sm btn-pill" {{ $disabled ? 'disabled' : '' }}><i class="fa fa-bars"></i></button>
                                                    @if($data->qc_status == 'done')
                                                        <a href="{{ url('butik/qc_cashbox/' . $data->id . '/report_export') }}" data-id="{{ $data->id }}" title="Download Report" type="button" class="delete_store_hub btn btn-default btn-sm btn-pill" style="color:#337ab7;"><i class="fa fa-file-excel-o"></i></a>
                                                        {{-- @if(in_array(auth()->user()->username, explode(',', env('USER_SEND_QC_RESULT_JAWS')))) --}}
                                                        @if(!$data->response_pushed_jaws)
                                                            @if($has_pg)
                                                                @if($has_new_plu)
                                                                    <a href="{{ url('butik/qc_cashbox/push_to_cmk/' . Crypt::encrypt($data->id)) }}" title="Download Report" type="button" class="delete_store_hub btn btn-default btn-sm btn-pill" style="color:#337ab7;"><i class="fa fa-upload"></i> Send to Jaws</a>
                                                                @else
                                                                    <a href="{{ url('butik/qc_cashbox/generate_new_plu/' . $data->id) }}" class="btn btn-info">~Generate New PLU~</button>
                                                                @endif
                                                            @endif
                                                        @else
                                                            <button disabled class="btn btn"><i class="fa fa-check"></i> Pushed Jaws</button>
                                                        @endif
                                                        {{-- @endif --}}
                                                    @endif
                                                @endif
											</td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>


                            <div class="text-center">
                                {{ $query->appends($_GET)->links() }}
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
            <div class="modal fade" id="modal_reason_reject" data-backdrop="false" tabindex="-1" role="dialog">
                <div class="modal-dialog" role="document">
                    <div class="modal-content">
                        <div class="modal-header">
                            <h4 class="modal-title">Reason Reject</h4>
                        </div>
                        <div class="modal-body">
                            <div class="alert alert-warning alert-dismissible" style="background: #fff9c4; color: #000;" role="alert">
                                <span class="bl" id="reject_content"></span>
                            </div>
                        </div>
                        <div class="modal-footer">
                            <button type="button" class="btn btn-sm waves-effect btn-clus" data-dismiss="modal"><i class="fa fa-close"></i> Close</button>
                        </div>
                    </div>
                </div>
            </div>
        @include('includes.footer')
    </div>
</div>

@endsection
@section('scripts')
@include('includes.helper_js')
<script>

    document.getElementById('download_excel').addEventListener('click', function(e) {
        e.preventDefault();

        // ambil nilai dari form
        const from_date = document.getElementById('from_date').value;
        const end_date = document.getElementById('end_date').value;
        const doNumber = document.getElementById('do').value;
        const status = document.querySelector('select[name="status"]').value;
        const store = document.querySelector('select[name="store"]').value;

        console.log({
        from_date,
        end_date,
        doNumber,
        status,
        store
    });


        // buat URL dengan query string
        const url = "{{ route('butik/qc_cashbox/excel') }}" +
            `?from_date=${from_date}&end_date=${end_date}&do=${doNumber}&status=${status}&store=${store}`;

        // redirect untuk download
        window.location.href = url;
    });

    /**
    $(function() {
        var d = new Date();
        var startDate = d.setMonth(d.getMonth() - 1);
        var e = new Date();
        var endDate = e.setDate(e.getDate());
        Helper.datePicker('date_format',null,endDate);
        $('input[name="from_date"]').val(moment(startDate).format('DD-MM-YYYY'));
        $('input[name="end_date"]').val(moment(endDate).format('DD-MM-YYYY'));
    });

    var tbl = globalCRUD.datatables({
        url: '/butik/qc_cashbox/datatables',
        selector: '#table_cashbox',
        columnsField: [
            'DT_RowIndex',
             { // receive_from_store
                data: 'receive_from_store',
                name: 'receive_from_store',
                render: function(data, type, full) {
                    return data ? data.name : '-';          
                }
            },
            { // unload_date
                data: 'unload_date',
                name: 'unload_date',
                render: function(data, type, full) {
                    return data ? moment(data).format("DD MMMM YYYY HH:mm:ss") : '-';
                }
            },
            { // qc_status
                data: 'qc_status',
                name: 'qc_status',
                render: function(data, type, full) {
                    let label;
                    switch(data) {
                    case 'uncompleted':
                        label = 'danger';
                        break;
                    case 'in_progress':
                        label = 'warning';
                        break;
                    case 'done':
                        label = 'success';
                        break;
                    case 'moved_central':
                        label = 'warning';
                        break;
                    case 'unloaded':
                        label = 'default';
                        break;
                    case 'refinery':
                        label = 'info';
                        break;
                    }
                    return `<label class="label label-pill label-${label}">${data}</label>`
                }
            },
            { // action
                data: "id",
                name: "id",
                render: function(data, type, full) {
                    const lihat_detail = `<button type="button" onclick="window.location.href='${Helper.url('/butik/qc_cashbox/'+data+'/details_list')}'" title='Lihat Detail' data-id='${data}' class='see_detail btn btn-primary btn-white btn-sm btn-pill'><i class="fa fa-bars"></i></button>`;
                    const download_report = `<a href="${Helper.url('/butik/qc_cashbox/'+data+'/report_export')}" data-id='${data}' title='Download Report' type='button' class='delete_store_hub btn btn-default btn-sm btn-pill' style='color:#337ab7;'><i class="fa fa-file-excel-o"></i></a>`;
                    let reason_reject = '';
                    if(full.reason_reject) {
                        reason_reject = `<button type="button" onclick="viewReasonReject('${full.id}','${btoa(full.reason_reject)}')" title='See Reason Reject' data-id='${data}' class='btn btn-warning btn-white btn-sm btn-pill'><i class="fa fa-lightbulb-o"></i></button>`;
                    }  
                    return lihat_detail+' '+download_report+' '+reason_reject;
                }
            }
        ],
        actionLink: ""
    });
    // search datatables;
    $("#form-search").submit(function(e) {
        e.preventDefault();
        let input = Helper.serializeForm($(this));
        playload = '?';
        _.each(input, (val, key) => {
            playload += key + '=' + val + '&'
        });
        playload = playload.substring(0, playload.length - 1);
        console.log(playload);
        url = Helper.url('/butik/qc_cashbox/datatables' + playload);
        tbl.table.reloadTable(url);
    });

    //reset field pencarian
    $("#reset_btn").click(function(e) {
        e.preventDefault();
        $('#from_date').val('');
        $('#end_date').val('');
    });

    function viewReasonReject(id,content) {
        console.log(atob(content));
        $('#reject_content').html(atob(content)).text();
        $('#modal_reason_reject').modal('show');
    }
    **/

</script>
@endsection