@extends('layout')

@section('css')
	<style>
		.vertical-center {
			position: relative;
			top: 35%;
			-webkit-transform: translateY(35%);
			-ms-transform: translateY(35%);
			transform: translateY(35%);
		}
	</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">
			<h3 class="font-weight-bold"><span class="font-weight-light">INVOICE -</span> Summary</h3>
			<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">
	<div class="card">
		
		<div class="card-body">

				<div class="form-group row">

					<label class="col-form-label col-md-1">Periode</label>
					<div class="col-md-2">
						<input type="text" id="periode_filter"
								name="periode_filter"
								class="daterange-picker form-control border-1 border-teal">

					</div>

					@if (!in_array(\Auth::user()->role, [20, 21, 22]))
						
						<label class="col-form-label col-md-1">Coload</label>
						<div class="col-md-3">
							<select class="form-control" name="coload_id" id="coload_id">
								<option value="">-- Pilih Coload --</option>
								@foreach ($coloads as $coload)
									<option value="{{$coload->id}}">{{$coload->nama}}</option>
								@endforeach
							</select>
						</div>
						<label class="col-form-label col-md-1">Marketing</label>
						<div class="col-md-4">
							<select class="form-control form-control-select2" name="filter_marketing" id="filter_marketing">
								<option value="">-- Pilih Marketing --</option>
								@foreach ($marketings as $marketing)
									<option value="{{$marketing->id}}">{{@$marketing->coload->nama}} - {{$marketing->nama}}</option>
								@endforeach
							</select>
						</div>
					@else
						<div class="col text-right">
							<button id="btn-filter" class="btn btn-success">
								<i class="fas fa-filter mr-1"></i> Filter
							</button>
							{{-- <a id="btn-filter" class="btn btn-success mr-1" href="{{ url('summaryinvoice').'?no='.app('request')->input('no').'&s='.app('request')->input('s').'&e='.app('request')->input('e')}}" data-uri="{{ url('summaryinvoice') }}"><i class="icon-paperplane mr-1"></i> Filter</a> --}}
							<a class="btn btn-info" href="{{ url('summaryinvoice')}}"><i class="icon-spinner11 mr-1"></i> View All</a>
							@if (in_array(\Auth::user()->role,[1,2,5,15,20,21,22]) || Auth::user()->id==251 || Auth::user()->id==252)
							<a data-toggle="modal" data-target="#modal_excel" href="{{url('/invoice-sudah-ditagih-excel')}}"><button type="button" class="btn btn-success"><i class="icon-file-spreadsheet mr-2"></i> Download Xls</button></a>
							@endif
						</div>
					@endif
				</div>

				<div class="form-group row">	
					<div class="col-lg-1">
						<div class="form-control-plaintext">Container</div>
					</div>
					<div class="col-lg-4">
						<select id="no_container" name="no_container" class="form-control form-control-select2 text-center">
							<option value="semua" selected>Semua Container</option>
							@foreach($containers as $container)
							{{-- <option value="{{$container->no_container}}" {{ app('request')->input('s') == $sale->id ? 'selected' : null }}>{{ ucwords($sale->nama) }}</option> --}}
							<option value="{{$container->no_container}}" {{ app('request')->input('no') == $container->no_container ? 'selected' : null }}>{{ $container->no_container }}</option>
							@endforeach
						</select>
					</div>
					
					@if (!in_array(\Auth::user()->role, [20,21,22]))

						<div class="col text-right">
							<button id="btn-filter" class="btn btn-success">
								<i class="fas fa-filter mr-1"></i> Filter
							</button>
							{{-- <a id="btn-filter" class="btn btn-success mr-1" href="{{ url('summaryinvoice').'?no='.app('request')->input('no').'&s='.app('request')->input('s').'&e='.app('request')->input('e')}}" data-uri="{{ url('summaryinvoice') }}"><i class="icon-paperplane mr-1"></i> Filter</a> --}}
							<a class="btn btn-info" href="{{ url('summaryinvoice')}}"><i class="icon-spinner11 mr-1"></i> View All</a>
							@if (in_array(\Auth::user()->role,[1,2,5,15,20,21,22]) || Auth::user()->id==251 || Auth::user()->id==252)
							<a data-toggle="modal" data-target="#modal_excel" href="{{url('/invoice-sudah-ditagih-excel')}}"><button type="button" class="btn btn-success"><i class="icon-file-spreadsheet mr-2"></i> Download Xls</button></a>
							@endif
						</div>
					@endif
				</div>

				<div class="row">
					<div class="col">
						<span class="text-muted">* Showing data within 3 months by default</span>

					</div>
				</div>

			<hr>

			<div class="row text-center">
				<div class="col">
					<h5>Total Tagihan : <span class="font-weight-semibold" id="text_totaltagihan">Rp {{ribuan($tottagihan)}}</span></h5>
				</div>
				<div class="col">
					<h5>Total Pembayaran : <span class="font-weight-semibold" id="text_totalbayar">Rp {{ribuan($totbayar)}}</span></h5>
				</div>
				<div class="col">
					<h5>Total Kurang Bayar : <span class="font-weight-semibold" id="text_totalkurang">Rp {{ribuan($totpiutang)}}</span></h5>
				</div>
			</div>

                    <table class="table datatable-basic table-hover">
                        <thead>
                            <tr>
								<th style="display: none">created_at</th>
								<th>No</th>
                                <th>No. Invoice</th>
                                <th>No. Container</th>
                                <th>Nama</th>
                                <th>Marketing</th>
                                <th>Tagihan</th>
                                <th>Pembayaran</th>
                                <th>Kurang Pembayaran</th>
                                <th>Status</th>
                                {{-- @if (\Auth::user()->role == 1)
                                    <th class="text-center">Action</th>
                                    @endif --}}
                                </tr>
                        </thead>
                        <tbody>
						
						</tbody>
					</table>
				</div>
			</div>
		</div>

		<!-- 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> Hapus Data? </h2>
						</div>

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

		<div id="modal_excel" class="modal fade">
			<div class="modal-dialog modal-lg">
				<div class="modal-content">
					<div class="modal-header bg-success" align="center">
						<h3>Download Excel</h3>
						<button type="button" class="close" data-dismiss="modal">&times;</button>
					</div>
	
					<div class="modal-body">
						<form action="{{ url('downloadallinvoice')}}" method="POST">
							@csrf
							<div class="row">
								<div class="col-lg-3">
									<span>Filter Coload</span>
									<select name="coload_id" class="form-control form-control-select2"
									@if (in_array(\Auth::user()->role,[20,21,22]))
									disabled	
									@endif
									>
										<option value="semua">--Semua--</option>
										@foreach ($coloads as $coload)
											<option value="{{$coload->id}}"
												@if (in_array(\Auth::user()->role,[20,21,22]))
													{{$coload->id == \Auth::user()->coload_id?'selected':''}}
												@endif
												>{{$coload->nama}}</option>
										@endforeach
									</select>
								</div>
								<div class="col-lg-2">
									<span>Filter Tahun</span>
									<select name="year" class="form-control form-control-select2">
										@foreach ($getyears as $year)
											<option value="{{$year->year}}">{{$year->year}}</option>	
										@endforeach
									</select>
								</div>
								{{-- <div class="col vertical-center">
									<button type="submit" class="btn btn-light rounded-round"><i class="icon-file-spreadsheet mr-2"></i> Download Xls</button>
								</div> --}}
								<div class="col-lg-6 vertical-center">
									<button type="submit" name="param" value="xls" class="btn btn-light rounded-round"><i class="icon-file-spreadsheet mr-2"></i> Download Xls</button>
								
									<button type="submit" name="param" value="xls_per_detail" class="btn btn-success rounded-round"><i class="icon-file-spreadsheet mr-2"></i> Download Xls per Detail</button>
								</div>
							</div>
						</form>
					</div>
	
				</div>
			</div>
		</div>

		@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/ui/moment/moment.min.js')}}"></script>
		<script src="{{asset('global_assets/js/plugins/pickers/daterangepicker.js')}}"></script>
		<script src="{{asset('global_assets/js/plugins/pickers/anytime.min.js')}}"></script>

		<script src="{{asset('global_assets/js/plugins/pickers/pickadate/picker.js')}}"></script>
		<script src="{{asset('global_assets/js/plugins/pickers/pickadate/picker.date.js')}}"></script>
		<script src="{{asset('global_assets/js/plugins/pickers/pickadate/picker.time.js')}}"></script>

		<script src="{{asset('global_assets/js/plugins/pickers/pickadate/legacy.js')}}"></script>
		<script src="{{asset('global_assets/js/plugins/notifications/jgrowl.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/picker_date.js')}}"></script>
		<script>
            let status_invoice = {!! json_encode(config('custom.status_invoice')) !!};
            let status_notifikasi_color = {!! json_encode(config('custom.status_notifikasi_color')) !!};
            let status_notifikasi = {!! json_encode(config('custom.status_notifikasi')) !!};
			var periode = null;
			var coload = null;
			var container = null;
			var tanggal_start = null;
			var tanggal_end = null;
			var marketing = null;

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

			$(document).on('change','#inctgl', function () {
				if ($('#inctgl').is(':checked')) {
					$("#filtertanggal").show();
				} else {
					$("#filtertanggal").hide();
				}
			});

			$(document).on('change', '#no_container, #fstart, #fend' ,function(){
            var uri = $('#btn-filter').data('uri');

            var val1 = $('#no_container option:selected').val();
            var val2 = '';
            var val3 = '';

            var href = `${uri}?no=${val1}`;
			if ($('#inctgl').is(':checked')) {
				// console.log('checked!')
					var val2 = $('#fstart').val()
					var val3 = $('#fend').val()
            	href = `${uri}?no=${val1}&s=${val2}&e=${val3}`;
			}
			// console.log(val1,val2,val3);
            $('#btn-filter').attr('href', href);
        })

		$(document).on('click', '#btn-filter', function() {
			periode = $('#periode_filter').val();
			coload = $('#coload_id').find(':selected').val();
			marketing = $('#filter_marketing').find(':selected').val();
			container = $('#no_container').find(':selected').val();

			$('#text_totaltagihan').html('Rp '+0);
			$('#text_totalbayar').html('Rp '+0);
			$('#text_totalkurang').html('Rp '+0);

            $('.datatable-basic').DataTable().clear().destroy()
			DatatableBasic.init()
		})


			var DatatableBasic = function() {

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

					// Setting datatable defaults
					$.extend( $.fn.dataTable.defaults, {
						autoWidth: false,
						columnDefs: [
							// {
							//    orderable: false,
							//    width: 220,
							//    targets: [ 6 ]
							// },
							{
								visible: false,
								targets: [ 0 ]
							},
							],
							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;' }
							}
						});

						// Basic datatable
						$('.datatable-basic').DataTable({
                            processing: true,
                            serverSide: true,
                            // ajax: "{{url('summaryinvoice-datatable')}}",
							ajax: {
								url: "{{url('summaryinvoice-datatable')}}",
								type: "GET",
								data:{
									_token: '{{csrf_token()}}',
									container: container,
									periode: periode,
									coload: coload,
									marketing: marketing,
								},
								beforeSend: function () {
									$('.datatable-basic > tbody').html(
										'<tr class="odd">' +
										'<td valign="top" colspan="100%" class="dataTables_empty"><div class="spinner-border text-success" role="status"><span class="sr-only">Loading...</span></div></td>' +
										'</tr>'
									);
								},
							},
							"initComplete": function(settings, json) {
								// Call your new function here
								kalkulasisummary();
							},
                            columns:[
								{data:'created_at', name:'created_at'},
								{data:'DT_RowIndex', name:'no'},
								{data:'no_invoice', name:'no_invoice'},
								{data:null, name: 'no_container', render:function(data, type, row){
									if(data.invoice_detail.length > 0){
										return data.invoice_detail[0].no_container
									}else{
										return '-';
									}
								}},
								{data:null, name:'nama', render:function(data, type, row){
									html = ''
									if (data.nama) {
										html += `${data.nama}` + ` - ` + `${data.shipping_mark}`
									} else {
										html += '-'
									}
									return ucwords(html)
								}},
								{data:null, render:function(data, type, row){
									html = ''
									if (data.customer) {
										if (data.customer.sales) {
											html += `${data.customer.sales.nama}`
										}
									} else {
										html += '-'
									}
									return ucwords(html)
								}},
								{data:null, name:'total_tagihan', render:function(data, type, row){
									var totaltagihan = 0
									if (data.total_tagihan != null) {
										totaltagihan = data.total_tagihan.toLocaleString('ID')
									}
									return "Rp. "+totaltagihan;
								}},
								{data:null, name:'total_bayar', render:function(data, type, row){
									var totalbayar = 0
									if (data.total_bayar != null) {
										totalbayar = data.total_bayar.toLocaleString('ID')
									}
									return "Rp. "+totalbayar;
								}},
								{data:null, name:'total_tagihan - total_bayar',render:function(data, type, row){
									var total = data.total_tagihan - data.total_bayar
									return "Rp. "+total.toLocaleString('ID');
								}},
								{data:null, render:function(data, type, row){
									html = ''

									if (data.status == 4) {
										html += `<span class='text-success font-weight-semibold'>`
									} else {
										html += `<span>`
									}
									// html += `${status_invoice[data.status]} </span>`
									html += `${status_invoice[data.statusinvoice]} </span>`
									
									return html;
								}},
							],
							order: {
								name: 'created_at',
								dir: 'desc'
							}
                        });

						// 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();
				});
				
				// kalkulasi ulang total summary
				function kalkulasisummary() {
					periode = $('#periode_filter').val();
					coload = $('#coload_id').find(':selected').val();
					marketing = $('#filter_marketing').find(':selected').val();
					container = $('#no_container').find(':selected').val();

					$.ajax({
						type: 'GET',
						url: "{{ url('/kalkulasisum_invoice/')}}",
						data: {periode:periode, coload:coload, marketing:marketing, container:container},
						success: function (data) {
							if (data != null) {
								$('#text_totaltagihan').html('Rp '+data.tottagihan.toLocaleString('ID'));
								$('#text_totalbayar').html('Rp '+data.totbayar.toLocaleString('ID'));
								$('#text_totalkurang').html('Rp '+data.totpiutang.toLocaleString('ID'));
							}
						}
					});
				}

				var $select = $('.form-control-select2').select2();

				$( document ).ready(function() {
					$('.daterange-picker').daterangepicker({
						applyClass: 'btn-primary',
						cancelClass: 'btn-light',

						startDate: '{{ $start_date }}',
						endDate: '{{ $end_date }}',
						
						locale: {
						format: 'YYYY/MM/DD'
						}
					});
					
					// 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

				});
			</script>

			<script>

				var DateTimePickers = function() {

					// Pickadate picker
					var _componentPickadate = function() {
						if (!$().pickadate) {
							console.warn('Warning - picker.js and/or picker.date.js is not loaded.');
							return;
						}

						// Basic options
						$('.pickadate').pickadate();

						// Change day names
						$('.pickadate-strings').pickadate({
							weekdaysShort: ['Su', 'Mo', 'Tu', 'We', 'Th', 'Fr', 'Sa'],
							showMonthsShort: true
						});

						// Dropdown selectors
						$('.pickadate-selectors').pickadate({
							format: 'yyyy-mm-dd',
							selectYears: true,
							selectMonths: true

						});
					};

					return {
						init: function() {
							_componentPickadate();
						}
					}
				}();
				// Initialize module
				// ------------------------------

				document.addEventListener('DOMContentLoaded', function() {
					DateTimePickers.init();
				});

			</script>

			@endsection