@extends(\Auth::user()->role != 10 ? 'layout' : 'layoutfrontdesk')

@section('title', 'COA Budgets')

@section('css')
<link href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.2.0/css/datepicker.min.css" rel="stylesheet">

<style type="text/css">
	.datatable-column-width {
		overflow: hidden;
		text-overflow: ellipsis;
		max-width: 200px;
		max-height: 90px;
	}
</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">COA Budgets -</span> Data</h3>
            <a href="#" class="header-elements-toggle text-default d-md-none"><i class="icon-more"></i></a>
        </div>
		<span class="float-right">
			<a href="{{route('coa-budgets.download')}}"
				class="btn btn-success btn-outline-success mr-2"
					target="_blank">
				<i class="fa fa-download"></i>&nbsp;Download Template Budgets
			</a>
			<button class="btn btn-success" data-toggle="modal" data-target="#modal_upload">
				<i class="far fa-file-excel"></i>&nbsp;Upload Budgets Excel
			</button>
		</span>
    </div>
</div>
<!-- /page header -->

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

	<div class="row">
		<div class="col-md-12">
			<!-- Hover rows -->
			<div class="card">
				<div class="card-header header-elements-inline">
					<a data-toggle="modal" data-target="#modal_add" onclick="resetBudget()">
						<button type="button" class="btn btn-success rounded-round"><i class="icon-add mr-2"></i> Setting Budget</button>
					</a>
					<form class="row align-items-end">
                        <div class="col-7 form-group">
                            <input type="number" name="year" id="year"
                                class="form-control"
                                placeholder="Input a valid year"
                                value="{{app('request')->input('year') ?? dateFormat(getSystemDate(), "Y")}}"
                                required
                            />
                        </div>
                        <div class="col-5 form-group">
                            <button
                                class="btn btn-outline-success"
                                id="submit-year"
                                type="button"
                            >
                                Select Year
                            </button>
                        </div>
                    </form>
				</div>

				<table class="table datatable-basic table-hover">
					<thead>
						<tr>
							<th>Description</th>
							<th>JAN</th>
							<th>FEB</th>
							<th>MAR</th>
							<th>APR</th>
							<th>MAY</th>
							<th>JUN</th>
							<th>JUL</th>
							<th>AUG</th>
							<th>SEP</th>
							<th>OCT</th>
							<th>NOV</th>
							<th>DEC</th>
						</tr>
					</thead>
					<tbody>

    				@if (!$budgets->isEmpty())
    				@foreach ($budgets as $key => $budget)
						<tr>
							<td>
								{{ $budget['description'] }}
							</td>
							@for ($i = 0; $i < 12; $i++)
								@if (@$budget[numToMonth($i)])
									<td data-sort="{{ @$budget[numToMonth($i)]['budget'] ?? 0 }}" data-search="{{ @$budget[numToMonth($i)]['budget'] ?? 0 }}">
										<div class="d-flex align-items-center">
											<div class="">
												Rp {{ ribuanWithComma(@$budget[numToMonth($i)]['budget'] ?? 0) }}
											</div>
											<div class="ml-3">
												<button type="button"
														class="btn btn-primary btn-icon btn-sm"
														title="Ubah"
														data-toggle="modal"
														data-target="#modal_add"
														onclick="editBudget({{ $budget[numToMonth($i)]['id']}}, {{@$budget['coa_id']}},  {{$budget[numToMonth($i)]['budget']}}, '{{$budget[numToMonth($i)]['tanggal']}}');"
												>
													<i class="icon-pencil7"></i>
												</button>
											</div>
										</div>
									</td>
								@else
									<td data-sort="{{ 0 }}" data-search="{{ 0 }}">
										<div class="d-flex align-items-center justify-content-between">
											<div class="">
												Rp {{ ribuanWithComma(0) }}
											</div>
											<div class="ml-3">
												<button
													type="button"
													class="btn btn-primary btn-icon btn-sm"
													title="Ubah"
													data-toggle="modal"
													data-target="#modal_add"
													disabled="true"
												>
													<i class="icon-pencil7"></i>
												</button>
											</div>
										</div>
									</td>
								@endif
							@endfor
						</tr>
					@endforeach
					@endif

				</tbody>
				</table>
			</div>
			<!-- /hover rows -->
		</div>
	</div>

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

<!--MODAL-->
    <div id="modal_add" class="modal fade">
		<div class="modal-dialog">
			<div class="modal-content">
				<div class="modal-header" align="center">
					<h6 class="modal-title" id="formTitle">Add Budget</span></h6>
					<button type="button" class="close" data-dismiss="modal">&times;</button>
				</div>

				<form action="{{ route('coa-budgets.store')}}" method="post" id="budgetForm">
					@csrf

                    <input type="hidden" name="_method" id="method" value="post">
					<div class="modal-body">
						<div class="form-group">
							<label>Chart of Accounts</label>
							<select name="coa_id" id="coa_id" class="form-control-select2 select-icons" data-fouc required>
                                <option value="">-- Select COA --</option>
								@foreach($coas as $coa)
									<option value="{{ $coa->id }}">({{ $coa->account_no }}) {{ $coa->description }}</option>
								@endforeach
							</select>
						</div>
						<div class="form-group" >
							<label>Date</label>
							{{-- <input type="text" name="tanggal" id="tanggal" class="form-control daterange-single" autocomplete="off" required> --}}
							<input type="text" class="form-control daterange-single" name="tanggal" id="tanggal" required/>
						</div>
						<div class="form-group" >
							<label>Budget</label>
							<input type="text" name="budget" id="budget" class="form-control border-teal border-1" placeholder="0" required>
							{{-- <span class="form-text" id="budgetperhari">Budget each day: </span> --}}
						</div>
					</div>

					<div class="modal-footer">
						<button type="button" class="btn btn-link"  data-dismiss="modal">Close</button>
						<button type="submit" class="btn btn-success">Submit</button>
					</div>
				</form>
			</div>
		</div>
	</div>
<!--/MODAL-->

<!--MODAL-->
    <div id="modal_upload" class="modal fade">
		<div class="modal-dialog">
			<div class="modal-content">
				<div class="modal-header" align="center">
					<h6 class="modal-title" id="formTitle">Upload Budgets</span></h6>
					<button type="button" class="close" data-dismiss="modal">&times;</button>
				</div>

				<form action="{{ route('coa-budgets.upload') }}" method="post" id="upload-form" enctype="multipart/form-data">
					@csrf

                    <input type="hidden" name="_method" id="method" value="post">
					<div class="modal-body">
						<div class="form-group" >
							<label>Year</label>
							<input type="number" name="year" id="year"
								class="form-control border-teal border-1"
								placeholder="Input a valid year"
								value="{{dateFormat(getSystemDate(), "Y")}}" required>
							{{-- <span class="form-text" id="budgetperhari">Budget each day: </span> --}}
						</div>
						<div class="form-group">
							<input class="form-control-uniform" id="file" name="file" type="file" accept=".xls,.xlsx">
						</div>
						<span class="form-text text-muted">Accepted format: .xls .xlsx</span>
					</div>

					<div class="modal-footer">
						<button type="button" class="btn btn-link"  data-dismiss="modal">Close</button>
						<button type="submit" class="btn btn-success" id="submit-upload">Submit</button>
					</div>
				</form>
			</div>
		</div>
	</div>
<!--/MODAL-->

<!-- 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">
					<a type="button" class="btn btn-link" data-dismiss="modal">Batal</a>
					<button type="submit" class="btn bg-danger">Hapus</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/editors/summernote/summernote.min.js')}}"></script>
<script src="{{asset('global_assets/js/plugins/buttons/ladda.min.js')}}"></script>
<script src="{{asset('global_assets/js/plugins/forms/styling/uniform.min.js')}}"></script>
<script src="{{asset('global_assets/js/plugins/media/fancybox.min.js')}}"></script>
<script src="{{asset('global_assets/js/plugins/forms/inputs/jquery.mask.js')}}"></script>

<!-- Helpers JS -->
<script src="{{asset('assets/js/custom.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/form_inputs.js')}}"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.2.0/js/bootstrap-datepicker.min.js"></script>

<script>

	$(document).on("input", "#year", function () {
		$(this).mask("0000")
	});

	$(document).on("input", "#budget", function () {
		$(this).mask("#,##0", {reverse: true})

	});

	//Popup
	$('[data-popup="lightbox"]').fancybox({
		padding: 3
	});

    //Preview Gambar
    function preview() {
        frame.src=URL.createObjectURL(event.target.files[0]);
    }

    function resetBudget() {
            var uri = "{{ route('coa-budgets.store')}}";

            $('#budgetForm').attr("action", uri);
            $('#method').val("post");
            $('#budget').val('');
            $('#formTitle').html('Add Budget');
            $('#tanggal').val(`${moment().format('MM-YYYY')}`);
            $('#tanggal').attr('disabled', false);
            $('#coa_id').select2().val('').trigger('change');
            $('#coa_id').select2().attr('disabled', false);

    }

	function editBudget(id, coa_id, budget, tanggal){
            var uri = 'coa-budgets/'+id;

            $('#budgetForm').attr("action", uri);
            $('#method').val("put");
            $('#budget').val(ribuanWithComma(budget));
            $('#formTitle').html('Edit Budget');
            $('#tanggal').val(moment(tanggal).format('MM-YYYY'));
            $('#tanggal').attr('disabled', true);
            $('#coa_id').select2().val(coa_id).trigger('change');
            $('#coa_id').select2().attr('disabled', true);

            /*
            @if(Auth::user()->role == 1)
                var hotel = $(this).data('hotel');
                $("#hotel_id").val(hotel).trigger('change');
            @endif
            */
    }

	$('#submit-year').on('click', function() {
		const year = $('#year').val();
		const url = new URL(window.location.href);
		url.searchParams.set('year', year)

		window.location.href = url
	 })


	//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
		        $.extend( $.fn.dataTable.defaults, {
					scrollX: true,
		            autoWidth: false,
		            columnDefs: [
						{
							width: 300,
							targets: [ 0 ]
						},
						{
							width: 800,
							targets: [ 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 ]
						},
					],
		            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({
					"bInfo" : false
				});

		        // 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();
		        }
		    }
		}();

		var FormValidation = function() {

		    // Validation config
		    var _componentValidation = function() {
		        if (!$().validate) {
		            console.warn('Warning - validate.min.js is not loaded.');
		            return;
		        }

		        // Initialize
		        var validator = $('.form-validate-jquery').validate({
		            ignore: 'input[type=hidden], .select2-search__field', // ignore hidden fields
		            errorClass: 'validation-invalid-label',
		            //successClass: 'validation-valid-label',
		            validClass: 'validation-valid-label',
		            highlight: function(element, errorClass) {
		                $(element).removeClass(errorClass);
		            },
		            unhighlight: function(element, errorClass) {
		                $(element).removeClass(errorClass);
		            },
		            // success: function(label) {
		            //    label.addClass('validation-valid-label').text('Success.'); // remove to hide Success message
		            //},

		            // Different components require proper error label placement
		            errorPlacement: function(error, element) {

		                // Unstyled checkboxes, radios
		                if (element.parents().hasClass('form-check')) {
		                    error.appendTo( element.parents('.form-check').parent() );
		                }

		                // Input with icons and Select2
		                else if (element.parents().hasClass('form-group-feedback') || element.hasClass('select2-hidden-accessible')) {
		                    error.appendTo( element.parent() );
		                }

		                // Input group, styled file input
		                else if (element.parent().is('.uniform-uploader, .uniform-select') || element.parents().hasClass('input-group')) {
		                    error.appendTo( element.parent().parent() );
		                }

		                // Other elements
		                else {
		                    error.insertAfter(element);
		                }
		            },

		        });

		        // Reset form
		        $('#reset').on('click', function() {
		            validator.resetForm();
		        });
		    };

		    // Return objects assigned to module
		    return {
		        init: function() {
		            _componentValidation();
		        }
		    }
		}();

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

		document.addEventListener('DOMContentLoaded', function() {
		    DatatableBasic.init();
		    FormValidation.init();
		});
</script>
<script type="text/javascript">
	$( document ).ready(function() {

			$('.form-control-select2').select2();

			// $('.daterange-single').daterangepicker({
			// 	singleDatePicker: true,
			// 	applyClass: 'btn-primary',
			// 	cancelClass: 'btn-light',
			// 	startDate: '{{ dateFormat(getSystemDate(), "d-m-Y") }}',
			// 	locale: {
			// 		format: 'DD-MM-YYYY'
			// 	},
			// 	startView: "months",
    		// 	minViewMode: "months"
			// });

			$(".daterange-single").datepicker({
				format: "mm-yyyy",
				startView: "months",
				minViewMode: "months",
				startDate: '{{ dateFormat(getSystemDate(), "d-m-Y") }}'
			});

	        // 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

		});


	$(document).on("change", "#tanggal", function () {
		// var budget = $('#budget').unmask().val()
		// $('#budget').mask("#.##0", {reverse: true})
		// if(!budget){
		// 	return false;
		// }

		// var datestart = $(this).data('daterangepicker') ? $(this).data('daterangepicker').startDate : "{{ dateFormat(getSystemDate(), 'd-m-Y') }}"
		// var dateend = $(this).data('daterangepicker') ? $(this).data('daterangepicker').endDate : "{{ dateFormat(getSystemDate(), 'd-m-Y') }}"
		// var start = moment(datestart, "DD-MM-YYYY")
		// var end = moment(dateend, "DD-MM-YYYY")
		// var hari = end.diff(start, 'days')+1

		// var perday = parseInt(budget)/parseInt(hari)
		// var html = parseInt(perday.toFixed())


		// $('#budgetperhari').html('Budget each day: '+html.toLocaleString('ID'))
		// $('#budgetperhari').show()

	});
</script>
@endsection