@extends(!in_array(\Auth::user()->role, [10, 15]) ? 'layout' : 'layoutfrontdesk')

@section('title', 'Purchase Order List')

@section('css')
<style type="text/css">
	.datatable-column-width{
		overflow: hidden; text-overflow: ellipsis; max-width: 200px;
	}
    tr.group,
    tr.group:hover {
        background-color: #eaeaea !important;
    }
</style>
@endsection

@section('content')
	<!-- Page header -->
	<div class="page-header page-header-light">
		<div class="page-header-content header-elements-md-inline">
			<div class="page-title d-flex">
				<h4>  <span class="font-weight-semibold">Purchase Order List</span></h4>
				<a href="#" class="header-elements-toggle text-default d-md-none"><i class="icon-more"></i></a>
			</div>
		</div>
	</div>
	<!-- /page header -->

	<!-- Content area -->
	<div class="content">

        <!-- Filter Area -->
		<div class="card">
            <div class="card-header row">
                <div class="col-lg-12">
                    <h4>Filter Data</h4>
                    <div class="row">
                        <div class="col-lg-3">
                            <label class="col-form-label" style="white-space: nowrap"><h6><b>Order Date :</b></h6></label>
                            <input type="text" name="tanggal"
                                class="form-control"
                                id="filter_tanggal"
                                {{-- value="{{ $_GET['tanggal'] : ''?? dateFormat(getSystemDate(),'d-m-Y').'-'.dateFormat(getSystemDate(),'d-m-Y') }}" --}}
                            >
                        </div>
                        <div class="col-lg-3">
                            <label class="col-form-label" style="white-space: nowrap"><h6><b>Supplier :</b></h6></label>
                            <select name="supplier" id="filter_supplier" class="form-control form-control-select2">
                                <option value=""> -- All Supplier --</option>
                                @foreach($suppliers as $supplier)
                                    <option value="{{$supplier->id}}" {{ request('supplier') == $supplier->id ? 'selected' : '' }}>{{$supplier->company_name}}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-lg-3">
                            <label class="col-form-label" style="white-space: nowrap"><h6><b>Type :</b></h6></label>
                            <select name="type" id="filter_type" class="form-control form-control-select2">
                                <option value="" {{ request('type') == '' ? 'selected' : ''}}> -- All Type --</option>
                                <option value="x" {{ request('type') == 'x' ? 'selected' : ''}}>Without PR</option>
                                <option value="1" {{ request('type') == '1' ? 'selected' : ''}}>With PR</option>
                                <option value="2" {{ request('type') == '2' ? 'selected' : ''}}>With DML</option>
                            </select>
                        </div>
                    </div>
                </div>
			</div>
		</div>
		<!-- Filter Area -->

		<!-- Hover rows -->
		<div class="card">
			<div class="card-header header-elements-inline">
				<a href="{{ route('purchase-order.create')}}"><button type="button" class="btn btn-success rounded-round"><i class="icon-add mr-2"></i> Purchase Order</button></a>
                <span class="float-right p-1 ">
                    @php
                    $filter_date = $_GET['tanggal'] ?? '';
                    $filter_supplier = $_GET['supplier'] ?? '';
                    $filter_type = $_GET['type'] ?? '';
                    @endphp
                    <a href="{{ route('purchase-order.export-all') }}?tanggal={{ $filter_date }}&supplier={{ $filter_supplier }}&type={{ $filter_type }}"
                        target="_blank"
                    >
                        <button type="button" class="btn btn-success rounded-round">
                            <i class="fa fa-file-excel"></i>&nbsp;
                            Export PO
                        </button>
                    </a>
                </span>
			</div>

			<table class="table datatable-basic table-hover">
				<thead>
					<tr>
                        <th class="d-none"></th>
                        <th>Supplier</th>
						<th>Document No</th>
                        <th>Order Date</th>
						<th>Deliver Date</th>
						<th>ArtNo</th>
						<th>Description</th>
						<th>Quantity</th>
						<th>Unit Price</th>
						<th>Amount</th>
						<th width="15%">Receiving No</th>
						<th>Status</th>
						<th class="text-center">Actions</th>
					</tr>
				</thead>
				<tbody>
                    @if (!$purchases->isEmpty())
                        @foreach($purchases as $purchase)
                            @php
                                $checker1 = 0;
                                $checker2 = 0;
                                $checker3 = 0;
                                foreach ($purchase->purchaserOrderDetails as $key => $value) {
                                    if ($value->status_receiving == 1){
                                        $checker1 = 1;
                                        $checker2 = 1;
                                        $checker3 = 1;
                                    } elseif ($value->qty_not_arrive < $value->qty && $value->qty_not_arrive > 0) {
                                        $checker1 = 1;
                                        $checker2 = 0;
                                        $checker3 = 0;
                                    } elseif ($value->qty_not_arrive == 0) {
                                        $checker1 = 1;
                                        $checker2 = 1;
                                        $checker3 = 0;
                                    }
                                }
                                if ($purchase->status == 9) {
                                    $status = 4;
                                } else {
                                    if ($checker1 == 1 && $checker2 == 1 && $checker3 == 1) {
                                        $status = 3;
                                    } elseif ($checker1 == 1 && $checker2 == 1 && $checker3 == 0) {
                                        $status = 2;
                                    } elseif ($checker1 == 1 && $checker2 == 0 && $checker3 == 0) {
                                        $status = 1;
                                    } else {
                                        $status = 0;
                                    }
                                }
                            @endphp
                            @foreach ($purchase->purchaserOrderDetails as $key => $detail)
                                @php
                                    $type_of_order = $purchase->purchase_request_id ? ($purchase->purchase_request->type == 2 ? 2 : 1) : 0;
                                    $request_no = $purchase->purchase_request_id ? ($purchase->purchase_request->type == 2 ? $purchase->purchase_request->dml_no : $purchase->purchase_request->request_no) : '';

                                    $checkerd1 = 0;
                                    $checkerd2 = 0;
                                    $checkerd3 = 0;
                                    if ($purchase->status_receiving == 1) {
                                        $checkerd1 = 1;
                                        $checkerd2 = 1;
                                        $checkerd3 = 1;
                                    } else {
                                        if ($detail->qty == $detail->qty_not_arrive) {
                                            $checkerd1 = 0;
                                            $checkerd2 = 0;
                                            $checkerd3 = 0;
                                        } elseif ($detail->qty_not_arrive > 0) {
                                            $checkerd1 = 1;
                                            $checkerd2 = 0;
                                            $checkerd3 = 0;
                                        } else {
                                            if ($detail->status_receiving == 0) {
                                                $checkerd1 = 1;
                                                $checkerd2 = 1;
                                                $checkerd3 = 0;
                                            } else {
                                                $checkerd1 = 1;
                                                $checkerd2 = 1;
                                                $checkerd3 = 1;
                                            }
                                        }
                                    }
                                    if ($checkerd1 == 1 && $checkerd2 == 1 && $checkerd3 == 1) {
                                        $statusd = 3;
                                    } elseif ($checkerd1 == 1 && $checkerd2 == 1 && $checkerd3 == 0) {
                                        $statusd = 2;
                                    } elseif ($checkerd1 == 1 && $checkerd2 == 0 && $checkerd3 == 0) {
                                        $statusd = 1;
                                    } else {
                                        $statusd = 0;
                                    }
                                @endphp
                                <tr>
                                    <td class="d-none"></td>
                                    <td>{{ @$detail->supplier->company_name }}</td>
                                    <td>{{ $purchase->id }}-{{ $purchase->document_no }}-{{$purchase->department->name}}-{{$type_of_order}}-{{$status}}-{{$purchase->status}}-{{$request_no}}-{{ribuanWithComma($purchase->total_amount)}}</td>
                                    <td>{{ dateFormat(@$purchase->order_date,'d-m-Y') }}</td>
                                    <td>{{ dateFormat(@$purchase->delivery_date,'d-m-Y') }}</td>
                                    <td>{{ @$detail->stock->article_no }}</td>
                                    <td>{{ @$detail->stock->description }}</td>
                                    <td>{{ ribuanDuaAngkaBelakangKomaIndoFilter(@$detail->qty) }}</td>
                                    <td>{{ ribuanWithComma($detail->price_unit) }}</td>
                                    <td>{{ ribuanWithComma($detail->amount) }}</td>
                                    <td>{{ @$detail->receivingDetail->first() ? @$detail->receiving_documents : '-' }}</td>
                                    <td>
                                        @if ($purchase->status == 9)
                                            <span class="badge badge-danger" style="font-size: 14px">Canceled</span>
                                        @else
                                            @if ($statusd == 0)
                                                <span class="badge badge-info" style="font-size: 14px">Ordered</span>
                                            @elseif ($statusd == 1)
                                                <span class="badge bg-orange-300" style="font-size: 14px">Not Complete</span>
                                            @elseif ($statusd == 2)
                                                <span class="badge badge-warning" style="font-size: 14px">Not in Storage</span>
                                            @elseif ($statusd == 3)
                                                <span class="badge badge-success" style="font-size: 14px">Complete</span>
                                            @endif
                                        @endif
                                    </td>
                                    <td align="center">

                                    </td>
                                </tr>
                            @endforeach
                        @endforeach
                    @endif
				</tbody>
			</table>
		</div>
		<!-- /hover rows -->

	</div>
	<!-- /content area -->

    <!-- Danger modal -->
	<div id="modal_theme_danger" class="modal fade" tabindex="-1">
		<div class="modal-dialog">
			<div class="modal-content">
				<div class="modal-header bg-danger" align="center">
					<button type="button" class="close" data-dismiss="modal">&times;</button>
				</div>

				<form action="" method="post" id="delform">
				    @csrf
				    @method('DELETE')
					<div class="modal-body" align="center">
						<h2> Delete data? </h2>
					</div>

					<div class="modal-footer">
						<button type="button" class="btn btn-link" data-dismiss="modal">Cancel</button>
						<button type="submit" class="btn bg-danger">Delete</button>
					</div>
				</form>
			</div>
		</div>
	</div>
	<!-- /default modal -->

    <div id="modal_update_status" class="modal fade">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header bg-primary">
                    <h6 class="modal-title">Update Status Purchase Order</h6>
                    <button type="button" class="close" data-dismiss="modal">&times;</button>
                </div>

                <form action="{{url('purchase-order-update-status')}}" id="formaction_update" method="post">
                    @csrf
                    <div class="modal-body text-left text-default font-weight-normal">
                        <div class="form-group row">
                            <label class="col-form-label col-lg-4">Status Purchase Order:</label>

                            <div class="col-lg-8">
                                <select id="status" name="status" class="form-control form-control-select2 select-status">
                                    @foreach(config('custom.status_purchase_order') as $key => $val)
                                        <option value="{{$key}}">{{$val}}</option>
                                    @endforeach
                                </select>
                            </div>

                        </div>
                        <div class="form-group row" id="coa_row" style="display: none;">
                            <label class="col-form-label col-lg-4">COA for Account Payable:</label>

                            <div class="col-lg-8">
                                <select name="coa_id" class="form-control form-control-select2" disabled required>
                                    @foreach($coas as $coa)
                                    	<option value="{{$coa->id}}">({{$coa->account_no}}) {{ $coa->description }}</option>
                                    @endforeach
                                </select>
                            </div>

                        </div>
                    </div>

                    <div class="modal-footer">
                        <button type="button" class="btn btn-link" data-dismiss="modal">Close</button>
                        <button type="submit" class="btn bg-primary submit-button-check" onclick="$('#formaction_update').submit()">Save</button>
                    </div>
                </form>
            </div>
        </div>
    </div>

    <!-- Danger modal -->
	<div id="warning_receiving_order" class="modal fade" tabindex="-1">
		<div class="modal-dialog">
			<div class="modal-content">
				<div class="modal-header bg-warning" align="center">
					<button type="button" class="close" data-dismiss="modal">&times;</button>
				</div>

				<form action="" method="post" id="formOrd">
				    @csrf
				    @method('GET')
                    <input type="hidden" name="purchase_order_id" id="POid">
					<div class="modal-body" align="center">
						<h2> Are you sure want to Receive Item from this Order? </h2>
					</div>

					<div class="modal-footer">
						<button type="button" class="btn btn-link" data-dismiss="modal">Cancel</button>
						<button type="submit" class="btn bg-warning">Submit</button>
					</div>
				</form>
			</div>
		</div>
	</div>
	<!-- /default modal -->

@endsection

@section('js')
	<!-- Theme JS files -->
	<script src="{{asset('global_assets/js/plugins/notifications/pnotify.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/notifications/bootbox.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/tables/datatables/datatables.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/forms/selects/select2.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/buttons/spin.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/buttons/ladda.min.js')}}"></script>
    <script src="{{asset('global_assets/js/plugins/media/fancybox.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/forms/styling/uniform.min.js')}}"></script>

	<script src="{{asset('assets/js/app.js')}}"></script>
	<script src="{{asset('global_assets/js/demo_pages/components_modals.js')}}"></script>
	<script src="{{asset('global_assets/js/demo_pages/gallery_library.js')}}"></script>
	<script>

        // modal request order
        $(document).on("click", ".ordButton", function () {
		     var url = $(this).data('uri');
		     var id = $(this).data('id');
		     $("#formOrd").attr("action", url);
		     $("#POid").val(id);
		});

        // Ambil Data Filter Tanggal
        let tanggal = {!! json_encode((\Request::get('tanggal') ? \Request::get('tanggal') : dateFormat(getSystemDate(),'d-m-Y').' - '.dateFormat(getSystemDate(),'d-m-Y') )  ) !!}

        console.log(tanggal);
        tanggal = tanggal.split(" - ");

        // Date Picker for Filter Tnggal
        $('#filter_tanggal').daterangepicker({
            startDate: tanggal[0],
            endDate: tanggal[1],
            // startDate: "{{ formatDate(getSystemDate(), 'd-m-Y') }}",
            // endDate:  "{{ formatDate(getSystemDate(), 'd-m-Y') }}",
            applyClass: 'btn-primary',
	        cancelClass: 'btn-light',
            locale: {
                format: 'DD-MM-YYYY'
            }
        });

        // ketika tanggal di pilih
        $(document).on("change", "#filter_tanggal", function () {
            tanggal = $('#filter_tanggal').val()
            supplier = $('#filter_supplier').val()
            type = $('#filter_type').val()
            let newRequest = window.location.search;
            let params = new URLSearchParams(newRequest);
            params.delete('tanggal');
            params.delete('supplier');
            params.delete('type');
            params.append('tanggal', document.getElementById("filter_tanggal").value);
            params.append('supplier', document.getElementById("filter_supplier").value);
            params.append('type', document.getElementById("filter_type").value);
            document.location.href = "?" + params.toString();
        });

        // ketika supplier di pilih
        $(document).on("change", "#filter_supplier", function () {
            tanggal = $('#filter_tanggal').val()
            supplier = $('#filter_supplier').val()
            type = $('#filter_type').val()
            let newRequest = window.location.search;
            let params = new URLSearchParams(newRequest);
            params.delete('tanggal');
            params.delete('supplier');
            params.delete('type');
            params.append('tanggal', document.getElementById("filter_tanggal").value);
            params.append('supplier', document.getElementById("filter_supplier").value);
            params.append('type', document.getElementById("filter_type").value);
            document.location.href = "?" + params.toString();
        });

        // ketika type di pilih
        $(document).on("change", "#filter_type", function () {
            tanggal = $('#filter_tanggal').val()
            supplier = $('#filter_supplier').val()
            type = $('#filter_type').val()
            let newRequest = window.location.search;
            let params = new URLSearchParams(newRequest);
            params.delete('tanggal');
            params.delete('supplier');
            params.delete('type');
            params.append('tanggal', document.getElementById("filter_tanggal").value);
            params.append('supplier', document.getElementById("filter_supplier").value);
            params.append('type', document.getElementById("filter_type").value);
            document.location.href = "?" + params.toString();
        });

		//modal delete
		$(document).on("click", ".delbutton", function () {
		     var url = $(this).data('uri');
		     $("#delform").attr("action", url);
		});

		var DatatableBasic = function() {

		    // Basic Datatable examples
		    var _componentDatatableBasic = function() {
		        if (!$().DataTable) {
		            console.warn('Warning - datatables.min.js is not loaded.');
		            return;
		        }

		        // Setting datatable defaults
                var groupColumn = 0
		        $.extend( $.fn.dataTable.defaults, {
		            autoWidth: false,
		            columnDefs: [
                        {
                            orderable: false,
                            width: 120,
                            targets: [ 12 ]
                        },
                        { visible: false, targets: [1,2] }
                    ],
		            dom: '<"datatable-header"fl><"datatable-scroll"t><"datatable-footer"ip>',
		            language: {
		                search: '<span>Filter:</span> _INPUT_',
		                searchPlaceholder: 'Type to filter...',
		                lengthMenu: '<span>Show:</span> _MENU_',
		                paginate: { 'first': 'First', 'last': 'Last', 'next': $('html').attr('dir') == 'rtl' ? '&larr;' : '&rarr;', 'previous': $('html').attr('dir') == 'rtl' ? '&rarr;' : '&larr;' }
		            },
                    // ordering: false,
                    order: [[groupColumn, 'asc']],
                    drawCallback: function (settings) {
                        var api = this.api();
                        var rows = api.rows({ page: 'current' }).nodes();
                        var last = null;

                        api
                            .column(1, { page: 'current' })
                            .data()
                            .each(function (group, i) {
                                if (last !== group) {
                                    $(rows)
                                        .eq(i)
                                        .before(`
                                            <tr class="group">
                                                <td colspan="10">Supplier: <b>${group}</b></td>
                                            </tr>`
                                        );

                                    last = group;
                                }
                            });

                        api
                            .column(2, { page: 'current' })
                            .data()
                            .each(function (group, i) {
                                if (last !== group) {
                                    const splitted = group.split('-')
                                    const id = splitted[0]
                                    const name = splitted[1]
                                    const department = splitted[2]
                                    const type = splitted[3]
                                    const status = splitted[4]
                                    const statusp = splitted[5]
                                    const request_no = splitted[6]
                                    const total_amount = splitted[7]

                                    $(rows)
                                        .eq(i)
                                        .before(
                                            `<tr class="">
                                                <td colspan="9"><b>${name} - Department : <span class='text-primary'>${department}</span> - Type : ${type == 0 ? `<span class='text-secondary'>Without PR</span>` : ( type == 1 ? `<span class='text-success'>With PR(${request_no})</span>` : `<span class='text-info'>With DML(${request_no})</span>`)} - Status : ${status == 0 ? "<span class='text-info'>New</span>" : status == 1 ? "<span class='text-orange-300'>Not Complete</span>" : status == 2 ? "<span class='text-danger'>Not In Storage</span>" : status == 3 ? "<span class='text-success'>Complete</span>" : "<span class='text-danger'>Canceled</span>"} - Total Amount : <span class='text-success'>${total_amount}</span></b></td>
                                                <td>
                                                    ${status == 0 ? `
                                                    <button type="button" class="btn btn-primary btn-icon" onclick="updateStatus(${id});">
                                                        <i class="icon-pencil7" title="Print"></i>
                                                    </button>

                                                    <a class="delbutton" data-toggle="modal"
                                                    data-target="#modal_theme_danger"
                                                    data-uri="{{ url('purchase-order/${id}' )}}"
                                                    >
                                                        <button type="button" class="btn btn-danger btn-icon btn-tooltip">
                                                            <i class="icon-x" title="Hapus"></i>
                                                        </button>
                                                    </a>
                                                    ` : ''}
                                                    <a href="{{url('purchase-order/${id}/print')}}" target="_blank">
                                                        <button type="button" class="btn btn-success btn-icon btn-tooltip">
                                                            <i class="icon-printer" title="Print"></i>
                                                        </button>
                                                    </a>

                                                    ${status != 2 && status != 3 && statusp != 9 ? `
                                                    <a class="ordButton" data-toggle="modal"
                                                        data-target="#warning_receiving_order"
                                                        data-uri="{{ route('receiving.create') }}"
                                                        data-id="${id}"
                                                    >
                                                        <button type="button" class="btn btn-warning btn-icon btn-tooltip">
                                                            <i class="icon-box-add" title="Receive Item"></i>
                                                        </button>
                                                    </a>
                                                    ` : ''}
                                                </td>
                                            </tr>`
                                        );

                                    last = group;
                                }
                            });
                    },
		        });

		        // Basic datatable
		        $('.datatable-basic').DataTable();

		        // Alternative pagination
		        $('.datatable-pagination').DataTable({
		            pagingType: "simple",
		            language: {
		                paginate: {'next': $('html').attr('dir') == 'rtl' ? 'Next &larr;' : 'Next &rarr;', 'previous': $('html').attr('dir') == 'rtl' ? '&rarr; Prev' : '&larr; Prev'}
		            }
		        });

		        // Datatable with saving state
		        $('.datatable-save-state').DataTable({
		            stateSave: true
		        });

		        // Scrollable datatable
		        var table = $('.datatable-scroll-y').DataTable({
		            autoWidth: true,
		            scrollY: 300
		        });

		        // Resize scrollable table when sidebar width changes
		        $('.sidebar-control').on('click', function() {
		            table.columns.adjust().draw();
		        });
		    };

		    // Select2 for length menu styling
		    var _componentSelect2 = function() {
		        if (!$().select2) {
		            console.warn('Warning - select2.min.js is not loaded.');
		            return;
		        }

		        // Initialize
		        $('.dataTables_length select').select2({
		            minimumResultsForSearch: Infinity,
		            dropdownAutoWidth: true,
		            width: 'auto'
		        });
		    };


		    //
		    // Return objects assigned to module
		    //

		    return {
		        init: function() {
		            _componentDatatableBasic();
		            _componentSelect2();
		        }
		    }
		}();


		// Initialize module
		// ------------------------------

		document.addEventListener('DOMContentLoaded', function() {
		    DatatableBasic.init();
		});
	</script>
	<script type="text/javascript">
		$( document ).ready(function() {
	        // Default style
	        @if(session('error'))
	            new PNotify({
	                title: 'Error',
	                text: '{{ session('error') }}.',
	                icon: 'icon-blocked',
	                type: 'error'
	            });
            @endif
            @if ( session('success'))
	            new PNotify({
	                title: 'Success',
	                text: '{{ session('success') }}.',
	                icon: 'icon-checkmark3',
	                type: 'success'
	            });
            @endif

		});

        function updateStatus(param) {
            $.ajax({
                type: "get",
                url: "{{url('purchase-order-detail')}}",
                data: {
                    id:param
                },
                dataType: "json",
                success: function (data) {
                    $('#modal_update_status #status').val(data.status).select2().trigger('change')
                    $('#formaction_update').attr("action", "{{ url('purchase-order-update-status')}}/"+data.id);
                    $('#modal_update_status').modal('show')
                }
            });
        }

        $('.select-status').on('change', function() {
            if (this.value == 2) {
                $('#coa_row').show()
                $('#coa_row select').prop('required', true).prop('disabled',false)
            } else {
                $('#coa_row').hide()
                $('#coa_row select').prop('required', false).prop('disabled',true)
            }
        })
	</script>
@endsection