@extends('layouts.app')
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/sweetalert2@7.33.1/dist/sweetalert2.min.css">
<link rel="stylesheet" href="{{ asset('argon') }}/vendor/datatables.net-bs4/css/dataTables.bootstrap4.min.css">
<link rel="stylesheet" href="{{ asset('argon') }}/vendor/datatables.net-buttons-bs4/css/buttons.bootstrap4.min.css">
<link rel="stylesheet" href="{{ asset('argon') }}/vendor/datatables.net-select-bs4/css/select.bootstrap4.min.css">
<link rel="stylesheet" href="{{ asset('css/preloader.css')}}">

<div id="preloaders" class="preloader"></div>
@section('title', 'Estoque Reman')
@section('content')
@include('layouts.headers.cards_prod')
@include('layouts.footers.auth')
<!-- A consulta desta tabela deve envolver INNER JOIN por causa dos nomes da família, nome do grupo e subgrupo, todos vindos das respectivas chaves estrangeiras -->

<div class="container-fluid mt--7">
	<div class="row">
		<div class="col-xl-12 order-xl-1">
			<div class="card bg-secondary shadow">
				<div class="card-header bg-white border-0">
					<div class="row align-items-center">
						<div class="col-8">
							<h3 class="mb-0">{{ __('Listagem do estoque') }}</h3>
						</div>
						@can('Adicionar-produtos-reman')
						<div class="col-4 text-right">
							<a href="{{route('estoque_reman.baixo')}}" class="btn btn-sm btn-danger">{{ __('Estoque Baixo') }}</a>
							<a href="{{route('produtos.cadastrar')}}" class="btn btn-sm btn-primary">{{ __('Adicionar Produto') }}</a>
						</div>
						@endcan
					</div>
				</div>
				<div class="card-body">
					<div class="table-responsive ">
						<table class="table table-flush table-bordered table-dark w-100" id="table">
							<thead class="thead-dark">
								<tr class="text-center font-weight-bold">
									<th>#</th>
									<th>Codigo</th>
									<th>Imagem</th>
									<th>Nome</th>
									<th>Quantidade</th>
									<th>Valor</th>
									<th>Posição</th>
									<th>Ações</th>
								</tr>
							</thead>
							<tfoot>
								<tr class="text-center">
									<td colspan="6"></td>
									<td colspan="1">
										<h2 class="text-white">Total em estoque: </h2>
									</td>
									<td colspan="1">
										<h2 class="text-success">R$ {{number_format($total, 2 ,',','.')}}</h2>
									</td>
								</tr>
							</tfoot>
						</table>
					</div>
				</div>
			</div>
		</div>
	</div>
</div>
<div class="modal fade" id="EstoqueModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
	<div class="modal-dialog modal-dialog-centered modal-lg" role="document">
		<div class="modal-content">
			<div class="modal-header">
				<h5 class="modal-title" id="exampleModalLabel"><strong>Estoque</strong></h5>
				<button type="button" class="close" data-dismiss="modal" aria-label="Close">
					<span aria-hidden="true">&times;</span>
				</button>
			</div>
			<div class="modal-body" style="background-color:#f7fafc">
				<form class="atualizar_estoque" method="post" enctype="multipart/form-data" action="#">
					<!-- Passando o Token -->
					{{csrf_field()}}
					<div class="row">
						<div class="col-md-12 col-lg-12 col-sm-12">
							<div class="form-group">
								<label class="form-control-label">Codigo SKU</label>
								<div class="input-group">
									<div class="input-group-prepend">
										<span class="input-group-text" id="basic-addon1"><i class="fas fa-terminal"></i></span>
									</div>
									<input name="sku_estoque" id="sku" type="text" class="form-control" placeholder="mtr-desl-gatter" aria-label="" aria-describedby="basic-addon1" value="">
								</div>
							</div>
						</div>
					</div>
					<div class="row">
						<div class="col-md-4 col-sm-12">
							<div class="form-group">
								<label class="form-control-label">Máxima</label>
								<div class="input-group">
									<div class="input-group-prepend">
										<span class="input-group-text" id="basic-addon1"><i class="fas fa-arrow-up text-success "></i></span>
									</div>
									<input name="quantidade_maxima_produtos" id="maxima" type="number" class="form-control" placeholder="" value="" aria-label="" aria-describedby="basic-addon1">
								</div>
							</div>
						</div>
						<div class="col-md-4 col-sm-12">
							<div class="form-group">
								<label class="form-control-label">Atual</label>
								<div class="input-group">
									<div class="input-group-prepend">
										<span class="input-group-text" id="basic-addon1"><i class="fas fa-arrow-right text-info "></i></span>
									</div>
									<input name="quantidade_produtos" id="atual" type="number" class="form-control" placeholder="" value="" aria-label="" aria-describedby="basic-addon1">
								</div>
							</div>
						</div>
						<div class="col-md-4 col-sm-12">
							<div class="form-group">
								<label class="form-control-label">Mínima</label>
								<div class="input-group">
									<div class="input-group-prepend">
										<span class="input-group-text" id="basic-addon1"><i class="fas fa-arrow-down text-danger "></i></span>
									</div>
									<input name="quantidade_minima_produtos" id="minima" type="number" class="form-control" placeholder="" value="" aria-label="" aria-describedby="basic-addon1">
								</div>
							</div>
						</div>
					</div>
					<div class="row">
						<div class="col-md-6 col-lg-6 col-sm-12">
							<div class="form-group">
								<label class="form-control-label">Estante</label>
								<div class="input-group">
									<div class="input-group-prepend">
										<span class="input-group-text" id="basic-addon1"><i class="fas fa-sort-alpha-up fa-2x text-primary"></i></span>
									</div>
									<input name="estante_estoque" id="estante" type="text" maxlength="1" class="form-control" placeholder="" value="" aria-label="" aria-describedby="basic-addon1">
								</div>
							</div>
						</div>
						<div class="col-md-6 col-lg-6 col-sm-12">
							<div class="form-group">
								<label class="form-control-label">Prateleira</label>
								<div class="input-group">
									<div class="input-group-prepend">
										<span class="input-group-text" id="basic-addon1"><i class="fas fa-sort-numeric-down fa-2x text-primary"></i></span>
									</div>
									<input name="prateleira_estoque" id="prateleira" type="number" class="form-control" placeholder="" value="" aria-label="" aria-describedby="basic-addon1">
								</div>
							</div>
						</div>
					</div>
			</div>
			<div class="modal-footer">
				<button type="button" class="btn btn-danger" data-dismiss="modal">Fechar</button>
				<button type="submit" class="btn btn-success">Salvar</button>
				</form>
			</div>
		</div>
	</div>
</div>

<!-- Comentando o navbar horizontal -->

@endsection

@push('js')
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@7.33.1/dist/sweetalert2.min.js"></script>
<script src="{{ asset('argon/vendor/datatables.net/js/jquery.dataTables.min.js') }}"></script>
<script src="{{ asset('argon/vendor/datatables.net-bs4/js/dataTables.bootstrap4.min.js') }}"></script>
<script src="{{ asset('argon/vendor/datatables.net-buttons-bs4/js/dataTables.buttons.min.js') }}"></script>
<script src="{{ asset('argon/vendor/datatables.net-buttons-bs4/js/buttons.bootstrap4.min.js') }}"></script>
<script src="{{ asset('argon/vendor/datatables.net-buttons-bs4/js/buttons.html5.min.js') }}"></script>
<script src="{{ asset('argon/vendor/datatables.net-buttons-bs4/js/buttons.flash.min.js') }}"></script>
<script src="{{ asset('argon/vendor/datatables.net-buttons-bs4/js/buttons.print.min.js') }}"></script>
<script src="{{ asset('argon/vendor/datatables.net-select-bs4/js/dataTables.select.min.js') }}"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/pdfmake.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.colVis.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/responsive/2.2.2/js/dataTables.responsive.min.js"></script>
<script>
	$(document).ready(function() {
		var table = $('#table').DataTable({
			"processing": true,
			"serverSide": true,
			"ajax": '{{ route('estoque_reman.data')}}',
			"deferRender": true,

			columns: [{
					"class": "align-middle text-center details-control",
					"orderable": false,
					"data": null,
					"defaultContent": '',
					"searchable": false,
					"render": function() {
						return '<i class="far fa-eye" aria-hidden="true"></i>';
					},
					width: "15px"
				},
				{
					data: 'id',
					name: 'id',
					className: 'align-middle text-center',
				},
				{
					"className": 'align-middle text-center',
					"orderable": false,
					"data": 'imagem_produto',
					"defaultContent": '',
					"searchable": false,
					"render": function(data, type, row) {
						return "<img class='avatar avatar-md rounded' src='../" + data + "'>";
					}
				},
				{
					data: 'nome_produto',
					name: 'nome_produto',
					className: 'align-middle text-center',
				},
				{
					data: 'quantidade_produtos',
					name: 'quantidade_produtos',
					className: 'align-middle text-center',
				},
				{
					"data": 'teste',
					"name": 'teste',
					"className": 'align-middle text-center',
					"render": function(data, type, row) {
						data2= parseFloat(data);
						return  data2.toLocaleString('pt-BR', { style: 'currency', currency: 'BRL' });
					}
					
				},
				{
					data: 'estante_estoque',
					name: 'estante_estoque',
					className: 'align-middle text-center',
					"render": function(data, type, row) {
						return "<i class='fas fa-boxes fa-2x text-primary mr-3'></i><strong>"+ data +"-"+row.prateleira_estoque+"</strong>";
					}
				},
				{
					"class": "align-middle text-center",
					"defaultContent": '',
					"data": 'id',
					"render": function(data, type, row) {
						return '<button type="button" id="button" class="btn btn-info" data-toggle="modal" data-target="#EstoqueModal" data-nome="'+row.nome_produto+'" data-action="../estoque/atualizar/'+row.id+'" data-id="'+row.id+'" data-sku="'+row.sku_estoque+'" data-maxima="'+row.quantidade_maxima_produtos+'" data-atual="'+row.quantidade_produtos+'" data-minima="'+row.quantidade_minima_produtos+'" data-estante="'+row.estante_estoque+'" data-prateleira="'+row.prateleira_estoque+'"> Atualizar </button>';
					}
				},
				{
					"data": 'prateleira_estoque',
					"orderable": false,
					"defaultContent": '',
					"searchable": false,
					"visible":false
				},
			],
			"language": {
				"info": "Mostrando de _START_ até _END_ de _TOTAL_ registos",
				"search": "Procurar:",
				"paginate": {
					"first": "Primeiro",
					"previous": "<",
					"next": ">",
					"last": "Último"
				}
			},

			dom: 'Bfrtip',
			lengthMenu: [
				[10, 25, 50, -1],
				['10 linhas', '25 linhas', '50 linhas', 'Todas as linhas']
			],
			buttons: [{
					extend: 'pageLength',
					className: 'btn bg-light rounded'
				},
				{
					extend: 'pdfHtml5',
					className: 'btn bg-danger text-white rounded',
					exportOptions: {
						columns: [1, 2, 3, 4]
					}
				},
				{
					extend: 'excelHtml5',
					className: 'btn bg-success text-white rounded',
					exportOptions: {
						columns: [1, 2, 3, 4]
					}
				},
				{
					extend: 'colvis',
					text: 'Colunas',
					className: 'btn bg-default text-white rounded'
				}
			],
			stateSave: true
		});
		$('#table tbody').on('click', 'td.details-control', function() {
			var tr = $(this).closest('tr');
			var tdi = tr.find("i.far");
			var row = table.row(tr);

			if (row.child.isShown()) {
				// This row is already open - close it
				row.child.hide();
				tr.removeClass('shown');
				tdi.first().removeClass('fa-eye-slash');
				tdi.first().addClass('fa-eye');
			} else {
				// Open this row
				row.child(format(row.data())).show();
				tr.addClass('shown');
				tdi.first().removeClass('fa-eye');
				tdi.first().addClass('fa-eye-slash');
			}
		});

		table.on("user-select", function(e, dt, type, cell, originalEvent) {
			if ($(cell.node()).hasClass("details-control")) {
				e.preventDefault();
			}
		});
	});

	function format(d) {
		// `d` is the original data object for the row
		return '<table class="table-sm" cellpadding="5" cellspacing="0" border="0">' +
			'<tbody class="thead-dark">' +
			'<tr>' +
			'<th class="align-middle text-center">Quantidade Máxima:</th>' +
			'<td class="align-middle text-center text-white" colspan="2">' + d.quantidade_maxima_produtos + '</td>' +
			'</tr>' +
			'<tr>' +
			'<th class="align-middle text-center">Quantidade Minima:</th>' +
			'<td class="align-middle text-center text-white" colspan="2">' + d.quantidade_minima_produtos + '</td>' +
			'</tr>' +
			'<tr>' +
			'<th class="align-middle text-center" >Valor Unitario:</th>' +
			'<td class="align-middle text-center text-white" colspan="2">' + parseFloat(d.preco_produto_varejo).toLocaleString('pt-BR', { style: 'currency', currency: 'BRL' }); + '</td>' +
			'</tr>' +
			'</tbody>' +
			'</table>';
	}
</script>
<script>
	//código usando jQuery
	$(document).ready(function() {
		$('.preloader').hide();
	});
</script>
<!--Arquivo de JS criado por nós para editar as partes lógicas do sistema  -->
<script>
	$('#EstoqueModal').on('show.bs.modal', function(event) {
		var button = $(event.relatedTarget)
		var nome = button.data('nome')
		var id = button.data('id')
		var sku = button.data('sku')
		var maxima = button.data('maxima')
		var atual = button.data('atual')
		var minima = button.data('minima')
		var estante = button.data('estante')
		var prateleira = button.data('prateleira')
		var action = button.data('action')

		var modal = $(this)
		modal.find('.modal-title').text('Estoque: ' + nome)
		modal.find('.modal-body form').attr("action", action);
		modal.find('.modal-body #sku').val(sku)
		modal.find('.modal-body #maxima').val(maxima)
		modal.find('.modal-body #atual').val(atual)
		modal.find('.modal-body #minima').val(minima)
		modal.find('.modal-body #estante').val(estante)
		modal.find('.modal-body #prateleira').val(prateleira)
	})
</script>
@endpush