@extends('layouts/contentLayoutMaster')

@section('title', __('locale.Request'))

{{-- @section('content') --}}

@section('vendor-style')
<!-- vendor css files -->
<link rel="stylesheet" href="{{ asset(mix('vendors/css/forms/wizard/bs-stepper.min.css')) }}">
<link rel="stylesheet" href="{{ asset(mix('vendors/css/forms/select/select2.min.css')) }}">
<link rel="stylesheet" href="{{ asset(mix('vendors/css/extensions/toastr.min.css')) }}">
@endsection


@section('page-style')
<!-- Page css files -->
<link rel="stylesheet" href="{{ asset(mix('css/base/plugins/forms/form-validation.css')) }}">
<link rel="stylesheet" href="{{ asset(mix('css/base/plugins/forms/form-wizard.css')) }}">
<link rel="stylesheet" href="{{ asset(mix('css/base/plugins/extensions/ext-component-toastr.css')) }}">

@endsection

@section('content')

<x-request.dependent :sexs="$sexs" :kinships="$kinships"/>
<x-request.holder :sexs="$sexs" :status="$status" :groups="$groups"/>

<section id="multiple-column-form">
	<div class="horizontal-wizard">
		<form class="form-add-request">
			@csrf
			<div class="col-12">
				<div class="card">
					<div class="card-header">
						<h4 class="card-title" id="operator_humanittare_value"></h4>
					</div>
					<div class="row mx-1">
						<div class="col-md-12" id="operator_humanittare_alert">
							
						</div>
					</div>
					<div class="card-body">
							<div class="row">
								<input type="hidden" name="contract_id" id="contract_id">
								@if(in_array($control_access_id, [4,5,6]))
								<input type="hidden" name="company_id" id="company_id" value="{{ $companies->id }}">
								<input type="hidden" name="group_id" id="group_id" value="{{ $companies->group_id }}">
								@endif
								<div class="col-md-12 col-12">
									<div class="mb-1">
										<label class="form-label" for="requests_type_id">{{ __('locale.Table.Request.Column.RequestType') }}</label>
										<select id="requests_type_id" class="select2" placeholder="Tipo Solicitação" name="requests_type_id" required>
											<option value="" selected disabled>{{ __('locale.Table.Request.Column.SelectOption') }}</option>
											@if ($request_types)
												@foreach ($request_types as $request_type)
													<option value="{{ $request_type->id }}">{{ $request_type->type_request }}</option>
												@endforeach
											@endif
										</select>
									</div>
								</div>
								<div class="col-md-12 col-12 inputs_delete hidden">
									<div class="mb-1">
										<label class="form-label" for="delete_type_id">{{ __('locale.Table.Request.Column.TypeofExclusion') }}</label>
										<select id="delete_type_id" class="select2" name="delete_type_id">
											<option value="" selected disabled>{{ __('locale.Table.Request.Column.SelectOption') }}</option>
											<option value="1">{{ __('locale.Table.Request.Column.Immediate') }}</option>
											<option value="2">{{ __('locale.Table.Request.Column.WithTemporaryExtension') }}</option>
											<option value="3">{{ __('locale.Table.Request.Column.WithLifetimeExtension') }}</option>
										</select>
									</div>
								</div>
								<div class="col-md-12 col-12 inputs_transfer hidden">
									<div class="mb-1">
										<label class="form-label" for="transfer_type_id">Tipos de transferincia</label>
										<select id="transfer_type_id" class="select2" name="transfer_type_id">
											<option value="" selected disabled>{{ __('locale.Table.Request.Column.SelectOption') }}</option>
											<option value="1">Empresas do mesmo grupo/subcontrato</option>
											<option value="2">Centros-de-Custo</option>
											<option value="3">Titularidade</option>
											<option value="4">Produtos contratados</option>
											<option value="5">Fornecedor</option>
										</select>
									</div>
								</div>
								@if(in_array($control_access_id, [1, 2, 3, 4]))				
								<div class="col-md-6 mb-1">
									<div class="form-group">
										<label for="group_id" class="form-label">{{ __('locale.Table.Request.Column.Group') }}</label>
										<select class="select2" name="group_id" id="group_id" required>
											<option value="" selected disabled>{{ __('locale.Table.Request.Column.SelectGroup') }}</option>
											@if ($gruops)
											@foreach ($gruops as $gruop)
											<option value="{{ $gruop->id }}">{{ $gruop->name }}</option>
											@endforeach
											@endif
										</select>
									</div>
								</div>
								<div class="col-md-6 mb-1">
									<div class="form-group">
										<label for="company_id" class="form-label">{{ __('locale.Table.Request.Column.Company') }}</label>
										<select class="select2" name="company_id" id="company_id" required>
											<option value="" selected disabled>{{ __('locale.Table.Request.Column.SelectaCompany') }}</option>
											
										</select>
									</div>
								</div>
								@endif
								<div class="col-md-12 input_product_id hidden">
									<div class="form-group mb-1">
										<label for="product_id" class="form-label">Produto</label>
										<select class="form-control" name="product_id" id="product_id">
											
											
										</select>
									</div>
								</div>
								<div class="col-md-12 col-12 input_new_company_id hidden">
									<div class="mb-1">
										<label class="form-label" for="new_company_id">Nova empresa</label>
										<select id="new_company_id" class="select2" name="new_company_id">
											<option value="" selected disabled>{{ __('locale.Table.Request.Column.SelectaCompany') }}</option>>
										</select>
									</div>
								</div>
								<div class="col-md-6 col-12 inputs_transfer_supplier hidden mt-1">
									<div class="mb-1">
										<label class="form-label" for="current_supplier">Fornecedor atual</label>
										<select id="current_supplier" class="select2" name="current_supplier">
											<option value="" selected disabled>{{ __('locale.Table.Request.Column.SelectOption') }}</option>

										</select>
									</div>
								</div>
								<div class="col-md-6 col-12 inputs_transfer_supplier hidden mt-1">
									<div class="mb-1">
										<label class="form-label" for="new_supplier">Novo fornecedor</label>
										<select id="new_supplier" class="select2" name="new_supplier">
											<option value="" selected disabled>{{ __('locale.Table.Request.Column.SelectOption') }}</option>

										</select>
									</div>
								</div>
								@if(in_array($control_access_id, [1, 2, 3]))
								<div class="{{ in_array($control_access_id, [1, 2, 3]) ? 'col-md-6' : 'col-md-12' }} mb-1">
									<label class="form-label" for="protocol_number_operator">{{ __('locale.Table.Request.Column.OperatorProtocolNumber') }}</label>
									<input type="text" id="protocol_number_operator" class="form-control" name="protocol_number_operator" placeholder="Número de Protocolo" />
								</div>
								@endif
								@if($control_access_id === 1)
								<div class="col-md-6 mb-1">
									<label class="form-label" for="status">{{ __('locale.Table.Request.Column.Status') }}</label>
									<select id="status" class="select2" placeholder="Status" name="status" required>
										<option selected disabled>{{ __('locale.Table.Request.Column.SelectStatus') }}</option>
										<option value="1">{{ __('locale.Table.Request.Column.StatusActive') }}</option>
										<option value="2">{{ __('locale.Table.Request.Column.StatusClosed') }}</option>
										<option value="3">{{ __('locale.Table.Request.Column.StatusPendingRequester') }}</option>
										<option value="4">{{ __('locale.Table.Request.Column.StatusPendingOperator') }}</option>
									</select>
								</div>
								@endif
								@if(in_array($control_access_id, [1, 2]))
								<div class="col-md-6 mb-1">
									<div class="form-group">
										<label for="employee_id" class="form-label">{{ __('locale.Table.Request.Column.Responsible') }}</label>
										<select class="select2" name="employee_id" id="employee_id" required>
											<option value="" selected disabled>{{ __('locale.Table.Request.Column.SelectResponsible') }}</option>
											@if ($employees)
											@foreach ($employees as $employee)
											<option value="{{ $employee->id }}">{{ $employee->name }}</option>
											@endforeach
											@endif
										</select>
									</div>
								</div>
								@endif
								@if(in_array($control_access_id, [1, 2, 3]))
								<div class="{{ in_array($control_access_id, [2]) ? 'col-md-12' : 'col-md-6' }} mb-1">
									<div class="form-group">
										<label for="request_incidences_id" class="form-label">{{ __('locale.Table.Request.Column.Incidents') }}</label>
										<select class="select2" name="request_incidences_id" id="request_incidences_id" >
											<option value="" selected disabled>{{ __('locale.Table.Request.Column.SelectanIncident') }}</option>
											@if ($request_incidences)
											@foreach ($request_incidences as $request_incidence)
											<option value="{{ $request_incidence->id }}">{{ $request_incidence->name }}</option>
											@endforeach
											@endif
										</select>
									</div>
								</div>
								@endif
								<div class="col-md-12">
									<div class="form-group">
										<label for="description" class="form-label">{{ __('locale.Table.Request.Column.Description') }}</label>
										<textarea class="form-control" name="description" id="description" cols="30" rows="5"></textarea>
									</div>
								</div>
							</div>
						
					</div>
				</div>
			</div>

			<div class="col-12 hidden" id="guide">
				<div class="card">
					<div class="card-header">
						<h4 class="card-title">{{ __('locale.Table.Request.Column.DocumentsforBatchImport') }}</h4>
					</div>
					<div class="card-body">
						<p>{{ __('locale.Table.Request.Column.Inthissectionyouwillfindtwoessentialfilestohelpyoucorrectlyperformtheeployeeimportprocess') }}</p>
						<span class="fw-bold">{{ __('locale.Table.Request.Column.UserGuide') }}</span>
						<p>{{ __('locale.Table.Request.Column.ThisdocumentprovidesdetailedstepbystepinstructionsonhowtocompleteandusethetemplateWerecommendreadingtheguidecarefullybeforeyoubegin') }}<a href="{{ asset('storage/system_documents/requests/guia.xlsx') }}" download>{{ __('locale.Table.Request.Column.ClickHere') }}</a></p>
						<span class="fw-bold">{{ __('locale.Table.Request.Column.FileTemplate') }}</span>
						<p>{{ __('locale.Table.Request.Column.ThisisthebasefileyoushouldusetofillinthenecessaryinformationDownloadthetemplatecompletetherequiredfieldsaccordingtotheguidesinstructionsanduseittosubmityourinformationinthecorrectandstandardizedformat') }}<a href="{{ asset('storage/system_documents/requests/modelo.xlsx') }}" download>{{ __('locale.Table.Request.Column.ClickHere') }}</a></p>
						<div id="field_list"></div>
					</div>
				</div>
			</div>

			<div class="col-12 card_in_lote">
				<div class="card">
					<div class="card-header">
						<h4 class="card-title tittle_in_lote">{{ __('locale.Table.Request.Column.ProductBundle') }}</h4>
						<button class="btn btn-primary hidden inputs_delete" id="addCombo">{{ __('locale.Add') }}</button>
					</div>
					<div class="card-body">
						<div class="row mb-1">
							<div class="col-md-6">
								<div class="form-group">
									<span>{{ __('locale.Table.Request.Column.Batch') }}
									</span>
									<div class="form-check d-inline-block mr-3">
										<label class="form-check-label" for="in_masse_yes">{{ __('locale.Table.Request.Column.Yes') }}</label>
										<input type="radio" class="form-check-input"
											id="in_masse_yes" name="in_masse"
											value="1" >
									</div>
									<div class="form-check d-inline-block mr-3">
										<label class="form-check-label" for="in_masse_no">{{ __('locale.Table.Request.Column.No') }}</label>
										<input type="radio" class="form-check-input"
											id="in_masse_no" name="in_masse"
											value="0" checked>
									</div>
								</div>
							</div>
						</div>
						<div class="row hidden mb-2" id="container_document_masse">
							<div class="col-md-6">
								<div class="form-group">
									<label for="document_masse">{{ __('locale.Table.Request.Column.BulkDataFile') }}</label>
									<input type="file" name="document_masse"
										id="document_masse" class="form-control"
										accept=".xls,.xlsx,application/vnd.ms-excel,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet">
								</div>
							</div>
							<div class="col-md-6">
								<div class="form-group">
									<label for="file_masse">Documentos</label>
									<input type="file" name="file_masse"
										id="file_masse" class="form-control"
										accept=".xls,.xlsx,application/vnd.ms-excel,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet">
								</div>
							</div>
						</div>
					</div>				
				</div>
			</div>
			<div class="col-12" id="comboList"></div>
			<div class="col-12">
				<div class="card">
					<div class="card-footer">
						<div class="row mt-2">
							<div class="col-12">
								<button type="button" class="btn btn-primary me-1" id="btnAddRequests">{{ __('locale.Table.Contract.Column.AddButton') }}</button>
								<button type="reset" class="btn btn-outline-secondary" id="btnReset">{{ __('locale.Table.Contract.Column.BackButton') }}</button>
							</div>
						</div>
					</div>
				</div>
			</div>
		</form>
	</div>
</section>



@endsection
@section('vendor-script')
<!-- vendor files -->
<script src="{{ asset(mix('vendors/js/extensions/sweetalert2.all.min.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/forms/wizard/bs-stepper.min.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/forms/select/select2.full.min.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/forms/validation/jquery.validate.min.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/extensions/toastr.min.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/jquery-mask/jquery.mask.js')) }}"></script>
<script src="{{ asset(mix('js/scripts/extensions/ext-component-toastr.js')) }}"></script>
<script src="{{ asset(mix('js/scripts/extensions/brdocs.cpfcnpjValidator.js')) }}"></script>
@endsection
@section('page-script')
<script>
	var request = null;

	window.data = {
		combo: [],
		documentExists: [],
		deletionItens: [],
	};

	let selectedHoldersTransfer = [];
	let holderData = [];
	let holders = [];
	let holdersChange = [];
	let produtos = [];
	let documents = [];
	let groupedDocuments = [];
	let matchedRules = [];

	var control_access_id = @json($control_access_id);

	if(control_access_id === 4){
		
	}
	

	function filterTable(currentComboId, holderSelectTableId) {
		const $filterNameElement = $('#filter-name' + currentComboId);
		const $filterRoleElement = $('#filter-role' + currentComboId);
		const $table = $('#' + holderSelectTableId);

		if ($filterNameElement.length === 0 || $filterRoleElement.length === 0 || $table.length === 0) {
			console.error('Elementos não encontrados. Verifique os IDs fornecidos.');
			return;
		}

		const filterValue = $filterNameElement.val().toLowerCase();
		const filterRole = $filterRoleElement.val();
		const $trs = $table.find('tbody tr');

		$trs.each(function() {
			const $tr = $(this);
			const tdName = $tr.find('td:eq(1)').text().toLowerCase();
			const tdRole = $tr.find('td:eq(3)').text();
			const tdCostCenter = $tr.find('td:eq(4)').text().toLowerCase();

			const matchesTextFilter = tdName.includes(filterValue) || tdCostCenter.includes(filterValue);
			const matchesRoleFilter = !filterRole || tdRole === filterRole;

			if (matchesTextFilter && matchesRoleFilter) {
				$tr.show();
			} else {
				$tr.hide();
			}
		});
	}

	function filterTableExclusion(index) {
		const filterValue = $(`#filter-name-exclusion-${index}`).val().toLowerCase();
		const filterRole = $(`#filter-role-exclusion-${index}`).val();
		const $tableRows = $(`#comboList .card:eq(${index}) table tbody tr`);

		$tableRows.each(function() {
			const $row = $(this);
			const nameText = $row.find('td:eq(1)').text().toLowerCase();
			const roleText = $row.find('td:eq(3)').text();

			const matchesNameFilter = nameText.includes(filterValue);
			const matchesRoleFilter = !filterRole || roleText === filterRole;

			if (matchesNameFilter && matchesRoleFilter) {
				$row.show();
			} else {
				$row.hide();
			}
		});
	}

	$(document).ready(function() {
		
		$('input[name="in_masse"]').on("change", function() {
			if ($('#in_masse_yes').is(':checked')) {
				
				$("#container_document_masse").removeClass("hidden");
				$("#container_table").addClass("hidden");
				$("#guide").removeClass("hidden");


			} else if ($('#in_masse_no').is(':checked')) {

				$("#container_table").removeClass("hidden");
				$("#container_document_masse").addClass("hidden");
				$("#guide").addClass("hidden");

			}
		});

	})

	$(function() {

		let documentsToSubmit = {};

		let comboCounter = 0;

		$("#modalHolder #zip_code").on("keyup", async function() {

			let zip_code = $(this).val().replace(/\D/g, '');

			if (zip_code.length < 8) return 0;

			let {
				data: json,
				...response
			} = await axios({
				method: 'get',
				url: `https://viacep.com.br/ws/${zip_code}/json/`,
			})

			if (json.erro) {
				if (window.toastr !== undefined) {
					window.toastr.warning('{{ __("locale.Table.Holders.Column.ZipCodeInvalid") }}', '{{ __("locale.Table.Holders.Column.Attention") }}');
				} else {
					window.alert('{{ __("locale.Table.Holders.Column.ZipCodeInvalid") }}');
				}
				$(this).val($(this).val().slice(0, -1)).focus();
				return 0;
			}
			console.log('json', json);
			$("#modalHolder #address").val(json.logradouro);
			$("#modalHolder #district").val(json.bairro);
			$("#modalHolder #state").val(json.uf);
			$("#modalHolder #city").val(json.localidade);
			$("#modalHolder #complement").val(json.complemento)


		});

		$("#modalDependent #zip_code").on("keyup", async function() {

			let zip_code = $(this).val().replace(/\D/g, '');

			if (zip_code.length < 8) return 0;

			let {
				data: json,
				...response
			} = await axios({
				method: 'get',
				url: `https://viacep.com.br/ws/${zip_code}/json/`,
			})

			if (json.erro) {
				if (window.toastr !== undefined) {
					window.toastr.warning('{{ __("locale.Table.Holders.Column.ZipCodeInvalid") }}', '{{ __("locale.Table.Holders.Column.Attention") }}');
				} else {
					window.alert('{{ __("locale.Table.Holders.Column.ZipCodeInvalid") }}');
				}
				$(this).val($(this).val().slice(0, -1)).focus();
				return 0;
			}
			console.log('json', json);
			$("#modalDependent #address").val(json.logradouro);
			$("#modalDependent #district").val(json.bairro);
			$("#modalDependent #state").val(json.uf);
			$("#modalDependent #city").val(json.localidade);
			$("#modalDependent #complement").val(json.complemento)


		});

		$("#modalHolder #cpf").on("keyup", function() {

			let cpf = $(this).val().replace(/\D/g, '');

			if (!validations.cpf.isValid(cpf)) {
				$("#Holder-information .btn-next").attr('{{ __("locale.Table.Holders.Column.Disabled") }}', '{{ __("locale.Table.Holders.Column.Disabled") }}');
			} else {
				$("#Holder-information .btn-next").removeAttr('{{ __("locale.Table.Holders.Column.Disabled") }}');
			}

		});

		$("#modalDependent #cpf").on("keyup", function() {

			let cpf = $(this).val().replace(/\D/g, '');

			if (!validations.cpf.isValid(cpf)) {
				$("#Holder-information .btn-next").attr('{{ __("locale.Table.Holders.Column.Disabled") }}', '{{ __("locale.Table.Holders.Column.Disabled") }}');
			} else {
				$("#Holder-information .btn-next").removeAttr('{{ __("locale.Table.Holders.Column.Disabled") }}');
			}

		});

		$('#wage').mask("#.##0,00", {
			reverse: true
		});

		$("#employee_type").on("change", function() {
                
			var selectedValue = $(this).val();
			
			if (selectedValue == 1) {
				$('#company_name').prop('disabled', true);
				$('#cnpj').prop('disabled', true);
			} else {
				$('#company_name').prop('disabled', false);
				$('#cnpj').prop('disabled', false);
			}

		});

		$('.select2').each(function() {
			var $this = $(this);
			$this.wrap('<div class="position-relative"></div>');
			$this.select2({
				dropdownAutoWidth: true,
				width: '100%',
				dropdownParent: $this.parent()
			});
		});

		$("#group_id").on("change", function() {
			let group_id = $(this).val();
			axios.get(`{{ route('api.contracts.getCompaniesByGroup', '') }}/${group_id}`, {
					headers: {
						"Authorization": "Bearer {{ session('Authorization') }}"
					}
				})
				.then(function(response) {

					$('#company_id').empty();
					$('#new_company_id').empty();

					$('#company_id').append('<option value="" selected disabled>Selecione uma Empresa</option>');
					$('#new_company_id').append('<option value="" selected disabled>Selecione uma Empresa</option>');

					var companies = response.data;

					$('#company_id').select2({
						multiple: false,
						placeholder: "Selecione uma Empresa",
						data: companies.map(function(company) {
							return {
								id: company.id,
								text: company.name
							};
						})
					});

					$('#new_company_id').select2({
						multiple: false,
						placeholder: "Selecione uma Empresa",
						data: companies.map(function(company) {
							return {
								id: company.id,
								text: company.name
							};
						})
					});
				})
				.catch(function(error) {
					console.error('Erro na requisição:', error);
				});
		});

		if(control_access_id === 5 || control_access_id === 6){

			let group_id = $('#group_id').val();
			axios.get(`{{ route('api.contracts.getCompaniesByGroup', '') }}/${group_id}`, {
					headers: {
						"Authorization": "Bearer {{ session('Authorization') }}"
					}
				})
				.then(function(response) {

					// $('#company_id').empty();
					$('#new_company_id').empty();

					// $('#company_id').append('<option value="" selected disabled>Selecione uma Empresa</option>');
					$('#new_company_id').append('<option value="" selected disabled>Selecione uma Empresa</option>');

					var companies = response.data;

					// $('#company_id').select2({
					// 	multiple: false,
					// 	placeholder: "Selecione uma Empresa",
					// 	data: companies.map(function(company) {
					// 		return {
					// 			id: company.id,
					// 			text: company.name
					// 		};
					// 	})
					// });

					$('#new_company_id').select2({
						multiple: false,
						placeholder: "Selecione uma Empresa",
						data: companies.map(function(company) {
							return {
								id: company.id,
								text: company.name
							};
						})
					});
				})
				.catch(function(error) {
					console.error('Erro na requisição:', error);
				});
		}

		$("#company_id").on("change", function() {

			let company_id = $(this).val();
			let requests_type_id = $('#requests_type_id').val();

			const url = `{{ route('api.contracts.getCompaniesByProduct', [':companyId', ':requestsTypeId']) }}`;

			const urlWithIds = url
				.replace(':companyId', company_id)
				.replace(':requestsTypeId', requests_type_id);

			axios.get(urlWithIds, {
					headers: {
						"Authorization": "Bearer {{ session('Authorization') }}"
					}
				})
				.then(function(response) {
					console.log(response.data);

					$('#current_supplier').empty();
					$('#current_supplier').append('<option value="" selected disabled>Selecione um fornecedor</option>');

					// Remover duplicados
					let uniqueSuppliers = response.data.filter((supplier, index, self) =>
						index === self.findIndex((s) => s.supplier_id === supplier.supplier_id)
					);

					// Configurar o `#current_supplier`
					$('#current_supplier').select2({
						multiple: false,
						placeholder: "Selecione uma Empresa",
						data: uniqueSuppliers.map(function(supplier) {
							return {
								id: supplier.supplier_id,
								text: supplier.supplier_name
							};
						})
					});

					// Evento de mudança no `#current_supplier` para atualizar o `new_supplier`
					$('#current_supplier').on('change', function() {
						let selectedSupplierId = $(this).val();

						// Filtra o `uniqueSuppliers`, removendo o selecionado em `#current_supplier`
						// let filteredSuppliers = uniqueSuppliers.filter(supplier => !selectedSupplierIds.includes(supplier.supplier_id));
						let filteredSuppliers = uniqueSuppliers.filter(supplier => supplier.supplier_id !== selectedSupplierId);

						// Atualizar o `new_supplier`
						$('#new_supplier').empty();
						$('#new_supplier').append('<option value="" selected disabled>Selecione um novo fornecedor</option>');
						$('#new_supplier').select2({
							multiple: false,
							placeholder: "Selecione um Novo Fornecedor",
							data: filteredSuppliers.map(function(supplier) {
								return {
									id: supplier.supplier_id,
									text: supplier.supplier_name
								};
							})
						});
					});
				})
				.catch(function(error) {
					console.error('Erro na requisição:', error);
				});
		});

		if(control_access_id === 4 || control_access_id === 5 || control_access_id === 6){
			$("#requests_type_id").on("change", function() {
			let company_id = $('#company_id').val();
			let requests_type_id = $('#requests_type_id').val();

			const url = `{{ route('api.contracts.getCompaniesByProduct', [':companyId', ':requestsTypeId']) }}`;

			const urlWithIds = url
				.replace(':companyId', company_id)
				.replace(':requestsTypeId', requests_type_id);

			axios.get(urlWithIds, {
					headers: {
						"Authorization": "Bearer {{ session('Authorization') }}"
					}
				})
				.then(function(response) {
					console.log(response.data);

					$('#current_supplier').empty();
					$('#current_supplier').append('<option value="" selected disabled>Selecione um fornecedor</option>');

					// Remover duplicados
					let uniqueSuppliers = response.data.filter((supplier, index, self) =>
						index === self.findIndex((s) => s.supplier_id === supplier.supplier_id)
					);

					// Configurar o `#current_supplier`
					$('#current_supplier').select2({
						multiple: false,
						placeholder: "Selecione uma Empresa",
						data: uniqueSuppliers.map(function(supplier) {
							return {
								id: supplier.supplier_id,
								text: supplier.supplier_name
							};
						})
					});

					// Evento de mudança no `#current_supplier` para atualizar o `new_supplier`
					$('#current_supplier').on('change', function() {
						let selectedSupplierId = $(this).val();

						// Filtra o `uniqueSuppliers`, removendo o selecionado em `#current_supplier`
						// let filteredSuppliers = uniqueSuppliers.filter(supplier => !selectedSupplierIds.includes(supplier.supplier_id));
						let filteredSuppliers = uniqueSuppliers.filter(supplier => supplier.supplier_id !== selectedSupplierId);

						// Atualizar o `new_supplier`
						$('#new_supplier').empty();
						$('#new_supplier').append('<option value="" selected disabled>Selecione um novo fornecedor</option>');
						$('#new_supplier').select2({
							multiple: false,
							placeholder: "Selecione um Novo Fornecedor",
							data: filteredSuppliers.map(function(supplier) {
								return {
									id: supplier.supplier_id,
									text: supplier.supplier_name
								};
							})
						});
					});
				})
				.catch(function(error) {
					console.error('Erro na requisição:', error);
				});
			});
		}

		$("#company_id, #requests_type_id, #transfer_type_id, #new_supplier, #product_id").on("change",async function() {

			let company_id = $('#company_id').val();
			let requests_type_id = $('#requests_type_id').val();
			let product_id = $('#product_id').val();

			if (company_id && requests_type_id) {
				await getCompaniesByHolders(company_id);
				console.log('produto', product_id)
				if(product_id == null){
					console.log('aqui', product_id)
					getCompaniesByProduct(company_id, requests_type_id);
				}	
			}

			switch(requests_type_id) {
			case '1':
				$(".card_in_lote").removeClass("hidden");
				$(".inputs_delete").addClass("hidden");
				$("#addCombo").removeClass("hidden");
				$(".inputs_transfer").addClass("hidden");
				$(".input_product_id").addClass("hidden");
				$(".tittle_in_lote").text("Combo de produtos");
				$("#comboList").empty();
				clearGlobalData();
				break;
			case '2':
				
				$(".card_in_lote").removeClass("hidden");
				$(".inputs_delete").removeClass("hidden");
				$(".inputs_transfer").addClass("hidden");
				$(".input_product_id").addClass("hidden");
				$("#addCombo").addClass("hidden");
				$(".tittle_in_lote").text("Lista de produtos");
				$("#comboList").empty();

				createTableExclusion(company_id);
				clearGlobalData();
				break;
			case '3':
				$(".card_in_lote").addClass("hidden");
				$(".inputs_delete").addClass("hidden");
				$(".inputs_transfer").addClass("hidden");
				$(".input_product_id").addClass("hidden");
				$("#comboList").empty();

				await dataChange(company_id);
				createTableChangeRegistration(holdersChange);
				clearGlobalData();
				break;
			case '4':
				$(".inputs_transfer").removeClass("hidden");
				$(".card_in_lote").removeClass("hidden");
				$(".inputs_delete").addClass("hidden");
				$(".input_product_id").addClass("hidden");
				$("#addCombo").addClass("hidden");
				$("#comboList").empty();

				await dataTransfer(company_id);

				if($("#transfer_type_id").val() == "1"){
					$(".input_new_company_id").removeClass("hidden");
					$(".inputs_transfer_supplier").addClass("hidden");
					createTableTransferCostCenter(holdersChange);
				}
				
				if($("#transfer_type_id").val() == "2"){
					$(".input_new_company_id").addClass("hidden");
					$(".inputs_transfer_supplier").addClass("hidden");
					createTableTransferCostCenter(holdersChange);
				}

				if($("#transfer_type_id").val() == "3"){
					$(".input_new_company_id").addClass("hidden");
					$(".inputs_transfer_supplier").addClass("hidden");
					createTableTransferCostCenter(holdersChange);
				}
				
				if($("#transfer_type_id").val() == "4"){
					$(".input_new_company_id").addClass("hidden");
					$(".inputs_transfer_supplier").addClass("hidden");
					createTableTransferProductByContract(company_id);
				}

				if($("#transfer_type_id").val() == "5"){
					$(".input_new_company_id").addClass("hidden");
					$(".inputs_transfer_supplier").removeClass("hidden");
					await dataTransferProductBySupplier($("#new_supplier").val());
					createTableTransferCostCenter(holdersChange);
				}

				break;

			case '5':
				$(".inputs_transfer").addClass("hidden");
				$(".card_in_lote").removeClass("hidden");
				$(".inputs_delete").addClass("hidden");
				$(".input_product_id").addClass("hidden");
				$("#addCombo").addClass("hidden");
				$("#addCombo").addClass("hidden");
				$("#comboList").empty();

				await dataTransfer(company_id);
				
				$(".input_new_company_id").addClass("hidden");
				$(".inputs_transfer_supplier").addClass("hidden");
				createTableUpgradeDowngrade(company_id);

				break;

			
			case '6':
				$(".card_in_lote").removeClass("hidden");
				$(".inputs_delete").addClass("hidden");
				$(".inputs_transfer").addClass("hidden");
				$(".input_product_id").removeClass("hidden");
				$("#comboList").empty();

				if(company_id && product_id){
					await dataException(company_id, product_id);
					createTableException(holdersChange);
					clearGlobalData();
				}
				break;
			case '7':
			case '8':
			case '9':
			case '10':
			case '11':
				$(".card_in_lote").addClass("hidden");
				$(".inputs_delete").addClass("hidden");
				$(".inputs_transfer").addClass("hidden");
				$(".input_product_id").removeClass("hidden");
				$("#comboList").empty();

				if(company_id && product_id){
					await dataException(company_id, product_id);
					createTableException(holdersChange);
					clearGlobalData();
				}

				break;
			default:
				
				break;
    		}
			
		});

		$("#product_id").on("change", function() {

			var selectedContractId = $(this).find(":selected").data("contract-id");

			$("#contract_id").val(selectedContractId);
			
		});

		$("#delete_type_id").on("change", function(){
			$('input[type="checkbox"]').prop('checked', false);
			$('.accordion-item').empty();
		});

		$("form").on("submit", function(event) {
			var fileInput = $("input[type='file']");
			
			if (fileInput.val() === "") {
				event.preventDefault();

				var accordionPanel = fileInput.closest(".accordion-collapse");
				
				if (!accordionPanel.hasClass("show")) {
					accordionPanel.collapse('show');
				}
				

				// Swal.fire({
				// 	icon: 'error',
				// 	title: 'Campo obrigatório!',
				// 	text: 'Por favor, preencha o campo de arquivo.',
				// });
			}
		});

		$("input[name='in_masse']").on('change', function() {

			let button = $('#addCombo');

			if ($("#in_masse_yes").is(":checked")) {
				button.addClass('hidden');
				$("#comboList").addClass("hidden");
				$('#document_masse').attr('required', true);
			} else if ($("#in_masse_no").is(":checked")) {
				button.removeClass('hidden');
				$("#comboList").removeClass("hidden");
				$('#document_masse').attr('required', false);
			}

		});

		$('#requests_type_id').on('change', function() {
			let typeRequestId = $(this).val();

			axios.get(`{{ route('api.suppliers.documents.find', '') }}/${typeRequestId}`, {
				headers: {
					"Authorization": "Bearer {{ session('Authorization') }}"
				}
			})
			.then(function(response) {

				documents = response.data;

			})
			.catch(function(error) {
				console.error('Erro ao obter documentos:', error);
			});
		});

		$('#requests_type_id, #transfer_type_id').on('change', function() {
			let typeRequestId = $('#requests_type_id').val();
			let transferTypeId = $('#transfer_type_id').val();
			
			let fields = [];
			switch (typeRequestId) {
				case '1':
					fields.push(
						'codigo_empresa', 
						'nome_colaborador', 
						'tipo_registro', 
						'nome_beneficiario', 
						'parentesco', 
						'data_nascimento', 
						'nome_mae', 
						'sexo', 
						'estado_civil', 
						'data_casamento', 
						'endereço', 
						'endereço_numero', 
						'endereço_complemento', 
						'endereço_bairro', 
						'endereço_cidade', 
						'endereço_estado', 
						'endereço_cep', 
						'telefone_pessoal', 
						'email_pessoal', 
						'cpf_titular', 
						'cpf_benef', 
						'sus_numero', 
						'rg_numero', 
						'rg_orgao_emissor', 
						'rg_data_emissao', 
						'matricula_numero', 
						'cargo', 
						'centro_custo', 
						'data_admissao', 
						'telefone_corp', 
						'email_corp', 
						'tipo_produto', 
						'cod_fornecedor', 
						'nome_produto'
					);
					break;
				case '2':
					fields.push(
						'codigo_empresa', 
						'nome_colaborador', 
						'tipo_registro', 
						'nome_beneficiario', 
						'cpf_titular', 
						'cpf_benef', 
						'tipo_produto', 
						'cod_fornecedor', 
						'nome_produto'
					);
					break;
				case '4':
					switch (transferTypeId) {
						case '1':
							fields.push(
								'codigo_empresa', 
								'nome_colaborador', 
								'tipo_registro', 
								'nome_beneficiario', 
								'cpf_titular', 
								'cpf_benef', 
								'matricula_numero', 
								'cargo', 
								'centro_custo', 
								'tipo_produto', 
								'cod_fornecedor', 
								'nome_produto', 
								'new_company_id'
							);
							break;
						case '2':
							fields.push(
								'codigo_empresa', 
								'nome_colaborador', 
								'tipo_registro', 
								'nome_beneficiario', 
								'cpf_titular', 
								'cpf_benef', 
								'centro_custo', 
								'tipo_produto', 
								'cod_fornecedor', 
								'nome_produto'
							);
							break;
						case '3':
							fields.push(
								'codigo_empresa', 
								'nome_colaborador', 
								'tipo_registro', 
								'nome_beneficiario', 
								'parentesco', 
								'data_nascimento', 
								'nome_mae', 
								'sexo', 
								'estado_civil', 
								'data_casamento', 
								'endereço', 
								'endereço_numero', 
								'endereço_complemento', 
								'endereço_bairro', 
								'endereço_cidade', 
								'endereço_estado', 
								'endereço_cep', 
								'telefone_pessoal', 
								'email_pessoal', 
								'cpf_titular', 
								'cpf_benef', 
								'sus_numero', 
								'rg_numero', 
								'rg_orgao_emissor', 
								'rg_data_emissao', 
								'matricula_numero', 
								'cargo', 
								'centro_custo', 
								'data_admissao', 
								'telefone_corp', 
								'email_corp', 
								'tipo_produto', 
								'cod_fornecedor', 
								'nome_produto', 
								'type'
							);
							break;
						case '4':
							fields.push(
								'codigo_empresa', 
								'nome_colaborador', 
								'tipo_registro', 
								'nome_beneficiario', 
								'cpf_titular', 
								'cpf_benef', 
								'tipo_produto', 
								'cod_fornecedor', 
								'nome_produto', 
								'new_product_id'
							);
							break;
						case '5':
							fields.push(
								'codigo_empresa', 
								'nome_colaborador', 
								'tipo_registro', 
								'nome_beneficiario', 
								'cpf_titular', 
								'cpf_benef', 
								'tipo_produto', 
								'cod_fornecedor', 
								'nome_produto',
								'new_product_id', 
								'new_supplier_id', 
								'optante'
							);
							break;
					}
					break;
				case '5':
					fields.push(
						'codigo_empresa', 
						'nome_colaborador', 
						'tipo_registro', 
						'nome_beneficiario', 
						'cpf_titular', 
						'cpf_benef', 
						'tipo_produto', 
						'cod_fornecedor', 
						'nome_produto', 
						'new_product_id'
					);
					break;
			}

			let list_field = $('#field_list');

			if (['1', '2', '4', '5'].includes(typeRequestId)) {

				list_field.html('');
				list_field.append('<span class="fw-bold">Campos obrigatórios</span><p></p><p class="text-danger">É fundamental que todos os campos obrigatórios sejam preenchidos corretamente para que a solicitação possa ser criada com sucesso.</p>');

				let pElement = list_field.find('p').first();
				pElement.empty();

				if (fields.length > 0) {
					let formattedFields = fields.join(', ');
					pElement.append(formattedFields);
				}

			}else{
				list_field.html('');
			}
			
		});

		$('#btnAddRequests').on("click", async function(eve) {

			eve.preventDefault();

			$(".form-add-request").submit();

		});	

		$(".form-add-request").on("submit", async function(event) {
			event.preventDefault();

			if ($(this).get(0).reportValidity()) {

				try {
					
					let payload = new FormData($(this).get(0));
					let requestsTypeId = $('#requests_type_id').val();
					let control_access_id = @json($control_access_id);

					payload.append('documentExists', JSON.stringify(window.data.documentExists));

					if([3, 4, 5, 6].includes(control_access_id)){
						let employee_id = @json($employees->first()->id);
						payload.append('employee_id', employee_id);
						payload.append('status', 1);
					}

					if([2].includes(control_access_id)){
						payload.append('status', 1);
					}

					if (groupedDocuments) {
						groupedDocuments.forEach((documentGroup, index) => {

							payload.append(`groupedDocuments[${index}][holderid]`, documentGroup.holderid);
							payload.append(`groupedDocuments[${index}][supplier_type_request_id]`, documentGroup.supplier_type_request_id);
							payload.append(`groupedDocuments[${index}][type]`, documentGroup.type);

							documentGroup.documentos.forEach((document, docIndex) => {
								payload.append(`groupedDocuments[${index}][documentos][${docIndex}][file]`, document.file);
								payload.append(`groupedDocuments[${index}][documentos][${docIndex}][filename]`, document.filename);
								payload.append(`groupedDocuments[${index}][documentos][${docIndex}][id]`, document.id);
							});
						});
					}

					let url;
					switch (requestsTypeId) {
						case '1':
							payload.append('combos', JSON.stringify(window.data.combo));
							url = `{{ route('api.requests.store') }}`;
							break;
						case '2':
							payload.append('combos', JSON.stringify(window.data.deletionItens));
							url = `{{ route('api.requests.storeExclusion') }}`;
							break;
						case '3':
							payload.append('combos', JSON.stringify(window.data.combo));
							payload.append('dataForm', JSON.stringify(holderData));
							url = `{{ route('api.requests.changeRegistration') }}`;
							break;
						case '4':

							console.log(JSON.stringify(window.data.combo));
							payload.append('combos', JSON.stringify(window.data.combo));
							payload.append('transfer', JSON.stringify(selectedHoldersTransfer));
							url = `{{ route('api.requests.transfer') }}`;
							break;
						case '5':

							console.log(JSON.stringify(window.data.combo));
							payload.append('combos', JSON.stringify(window.data.combo));
							payload.append('transfer', JSON.stringify(selectedHoldersTransfer));
							url = `{{ route('api.requests.upgradeDowngrade') }}`;
							break;
						case '6':

							console.log(JSON.stringify(window.data.combo));
							payload.append('combos', JSON.stringify(window.data.combo));
							payload.append('transfer', JSON.stringify(selectedHoldersTransfer));
							url = `{{ route('api.requests.exception') }}`;
							break;
						case '7':

							console.log(JSON.stringify(window.data.combo));
							payload.append('combos', JSON.stringify(window.data.combo));
							payload.append('transfer', JSON.stringify(selectedHoldersTransfer));
							url = `{{ route('api.requests.refund') }}`;
							break;
						case '8':

							console.log(JSON.stringify(window.data.combo));
							payload.append('combos', JSON.stringify(window.data.combo));
							payload.append('transfer', JSON.stringify(selectedHoldersTransfer));
							url = `{{ route('api.requests.contestation') }}`;
							break;
						case '9':

							console.log(JSON.stringify(window.data.combo));
							payload.append('combos', JSON.stringify(window.data.combo));
							payload.append('transfer', JSON.stringify(selectedHoldersTransfer));
							url = `{{ route('api.requests.secondCopy') }}`;
							break;
						case '10':

							console.log(JSON.stringify(window.data.combo));
							payload.append('combos', JSON.stringify(window.data.combo));
							payload.append('transfer', JSON.stringify(selectedHoldersTransfer));
							url = `{{ route('api.requests.question') }}`;
							break;
						case '11':

							console.log(JSON.stringify(window.data.combo));
							payload.append('combos', JSON.stringify(window.data.combo));
							payload.append('transfer', JSON.stringify(selectedHoldersTransfer));
							url = `{{ route('api.requests.complaints') }}`;
							break;

					}
					
					let response = await axios({
						url: url,
						method: 'post',
						data: payload,
						headers: {
							"Authorization": "Bearer {{ session('Authorization') }}",
							"Content-Type": "multipart/form-data"
						}
					});

					let json = response.data;
					Swal.fire({
						title: 'Uhuul!',
						text: "A solicitação foi adicionado com sucesso.",
						icon: "success"
					}).then((result) => {
						if (result.isConfirmed) {
							window.location.href = "{{ route('dashboard.requests.index') }}";
						}
					});

				} catch (error) {
					console.error('Erro na requisição:', error);

					// Tratamento de erros específicos
					let response = error.response;
					let teste = getErrorMessage(response.data);
					
					if (response) {
						if (response.status === 400 || response.status === 422) {
							Swal.fire({
								title: 'Ops!',
								html: response.data.message,
								icon: 'error',
								cancelButtonText: '{{ __("locale.Table.suppliers.Column.CloseButton") }}'
							});
						} else if (response.status === 404) {
							Swal.fire({
								title: 'Ops!',
								text: '{{ __("locale.Table.suppliers.Column.RequestedNotFound") }}',
								icon: 'error',
								cancelButtonText: '{{ __("locale.Table.suppliers.Column.CloseButton") }}'
							});
						} else {
							Swal.fire({
								title: 'Ops!',
								text: '{{ __("locale.Table.suppliers.Column.RegisterError") }}',
								icon: 'error',
								cancelButtonText: '{{ __("locale.Table.suppliers.Column.CloseButton") }}'
							});
						}
					} else {
						Swal.fire({
							title: 'Ops!',
							text: 'Erro desconhecido',
							icon: 'error',
							cancelButtonText: '{{ __("locale.Table.suppliers.Column.CloseButton") }}'
						});
					}
				}
			}
		});

		$('#addCombo').click(function(e) {
			e.preventDefault();

			comboCounter++;

			const comboId = comboCounter;
			const productTableId = 'productTable_' + comboId;
			const holderSelectTableId = 'holder_select_table_' + comboId;
			const selectAllId = 'selectAll_' + comboId;
			const filterNameId = 'filter-name_' + comboId;
			const filterRoleId = 'filter-role_' + comboId;

			let cardHtml = `
				<div class="card my-3" id="${comboId}">
					<div class="card-header">
						<h4 class="card-title">Combo ${comboId}</h4>
						<button class="btn btn-danger btn-sm float-end delete-combo" data-combo-id="${comboId}">Excluir</button>
					</div>
					<div class="card-body">
						<div class="row">
							<div class="col-md-12 my-1">
								<div style="max-height: 300px; overflow-y: auto;">
									<div id="combo_product_${comboId}"></div>
									<table class="table" id="${productTableId}">
										
									</table>
								</div>
								<button class="btn btn-primary btn-sm float-end create-button mt-1" data-combo-id="${comboId}">Criar</button>
							</div>
							<div class="col-md-12" id="container_table">
								
								<div id="menu_holder_${comboId}"></div>
								<div style="max-height: 300px; overflow-y: auto;">
									<table class="table table-striped" id="${holderSelectTableId}">
										
									</table>
								</div>
							</div>
							<div class="col-md-12 mt-1" id="accordionContainer${comboId}"></div>
						</div>
					</div>
				</div>
			`;

			$('#comboList').append(cardHtml);
			

			let requests_type_id = $('#requests_type_id').val();
			createTableProducts(productTableId, comboId, requests_type_id);
		});
		
		$(document).on('click', '.create-button', function(e) {
			e.preventDefault();

			const comboId = $(this).data('combo-id');
			const productTableId = 'productTable_' + comboId;
			const holderSelectTableId = 'holder_select_table_' + comboId;
			const selectAllId = 'selectAll_' + comboId;
			const filterNameId = 'filter-name_' + comboId;
			const filterRoleId = 'filter-role_' + comboId;

			const combo = window.data.combo.find(c => c.id === comboId);
			const products = combo ? combo.produtos : [];

			const contractIds = products.map(product => product.contract_id);
			const maxQuantity = matchedRules
				.filter(rule => contractIds.includes(rule.contract_id))
				.reduce((max, rule) => Math.max(max, rule.quantity), 0);

			const currentDate = new Date();

			const filteredHolders = holders.filter(holder => {
				const contractDate = new Date(holder.contractDate);
				const diffTime = Math.abs(currentDate - contractDate);
				const diffDays = Math.ceil(diffTime / (1000 * 60 * 60 * 24));

				return diffDays > maxQuantity;
			});

			$('#' + productTableId).hide();
			$(this).hide();

			const selectedProducts = products.filter(product => {
				const checkbox = $(`input[type="checkbox"][value="${product.product_id}"]`);
				return checkbox.is(':checked');
			});

			const productListContainer = $('<div>').addClass('product-list');
			const productListTitle = $('<h3>').text('Produtos Selecionados');
			const productList = $('<ul>');

			selectedProducts.forEach(product => {
				const listItem = $('<li>').text(`${product.supplier_name} - ${product.product_name} - Contrato #${product.contract_id}`);
				productList.append(listItem);
			});

			productListContainer.append(productListTitle, productList);

			$('#combo_product_' + comboId).append(productListContainer);

			createTableHoldes(holderSelectTableId, selectAllId, filterNameId, filterRoleId, comboId, filteredHolders);
		});

		$(document).on('click', '.delete-combo', function(e) {
			e.preventDefault();
			const comboId = $(this).data('combo-id');
			$('#comboList' + ' #' + comboId).remove();

			window.data.combo = window.data.combo.filter(item => item.id !== comboId);
			matchedRules = matchedRules.filter(rule => rule.combo_id !== comboId);

		});

		function createTableHoldes(holderSelectTableId, selectAllId, filterNameId, filterRoleId, currentComboId, dataHolders) {
			let holders = dataHolders;

			let selectedIds = new Set();

			window.data.combo.forEach(combo => {
				combo.titulares.forEach(id => selectedIds.add(id));
				combo.dependentes.forEach(id => selectedIds.add(id));
			});

			let filteredHolders = holders.filter(holder => !selectedIds.has(holder.id));

			let uniqueRoles = [...new Set(filteredHolders.map(item => item.role))];

			let $holderSelectTable = $('#' + holderSelectTableId);
			let $holderSelectAll = $('#menu_holder_' + currentComboId);
			
			$holderSelectTable.empty();

			if (filteredHolders && filteredHolders.length > 0) {

				$holderSelectAll.addClass('mb-1');
				$holderSelectAll.append(`
					<div class="row">
						<div class="col-md-4">
							<div class="form-check">
								<input class="form-check-input" id="${selectAllId}" name="${selectAllId}" type="checkbox" value="">
								<label class="form-check-label" for="${selectAllId}">
									Selecionar todos
								</label>
							</div>
						</div>
						<div class="col-md-4">
							<input class="form-control" type="text" id="filter-name${currentComboId}" placeholder="Search" oninput="filterTable(${currentComboId}, '${holderSelectTableId}')">
						</div>
						<div class="col-md-4">
							<select class="form-control" id="filter-role${currentComboId}" onchange="filterTable(${currentComboId}, '${holderSelectTableId}')">
								<option value="" selected>Selecione </option>
							</select>
						</div>
					</div>
				`);

				const combinedSelect = document.getElementById('filter-role' + currentComboId);

				const roleOptgroup = document.createElement('optgroup');
				roleOptgroup.label = "Cargos";

				uniqueRoles.forEach(role => {
					const option = document.createElement('option');
					option.value = role;
					option.textContent = role;
					roleOptgroup.appendChild(option);
				});

				combinedSelect.appendChild(roleOptgroup);

				document.getElementById('filter-name' + currentComboId).addEventListener('input', filterTable);
				document.getElementById('filter-role' + currentComboId).addEventListener('change', filterTable);

				let thead = `
					<thead style="position: sticky; top: 0; z-index: 1;">
						<tr>
							<th scope="col">#</th>
							<th scope="col">Nome</th>
							<th scope="col">Tipo</th>
							<th scope="col">Cargo</th>
							<th scope="col">Centro de custo</th>
						</tr>
					</thead>
				`;
				$holderSelectTable.append(thead);

				let tbody = $('<tbody></tbody>');

				filteredHolders.forEach(holder => {
					let row = `
						<tr>
							<td>
								<input class="form-check-input checkbox-option" id="${holder.id}" name="option${holder.id}" type="checkbox" value="${holder.type + holder.id}">
							</td>
							<td>
								<label class="form-check-label ms-3 me-6" for="${holder.id}">${holder.name}</label>
							</td>
							<td>${holder.type}</td>
							<td>${holder.role}</td>
							<td>${holder.cost_center}</td>
						</tr>
					`;
					tbody.append(row);
				});

				$holderSelectTable.append(tbody);

				$('#' + selectAllId).on('change', function() {
					let isChecked = $(this).is(':checked');
					$('#' + holderSelectTableId + ' .checkbox-option').prop('checked', isChecked);
					updateCombo(this);
				});

				$('#' + holderSelectTableId + ' .checkbox-option').on('change', function() {
					updateCombo(this, currentComboId);
				});
			} else {
				$holderSelectTable.append('<tbody><tr><td colspan="5">Colaborador não encontrado</td></tr></tbody>');
			}
		}

		function getErrorMessage(data) {

			if (data.exception && data.exception.message) {
				return data.exception.message;
				console.log(data.exception.message);
			}
			if (data.message) {
				return data.message;
				console.log(data.message);
			}
			if (data.errors) {
				let messages = [];
				for (let field in data.errors) {
					if (data.errors.hasOwnProperty(field)) {
						messages.push(data.errors[field].join(', '));
					}
				}
				return messages.join(' ');
			}
			return 'Ocorreu um erro';
		}

		function updateCombo(checkbox, comboId) {
			let comboObj = window.data.combo.find(item => item.id === comboId);
			if (!comboObj) {
				comboObj = { id: comboId, produtos: [], titulares: [], dependentes: [] };
				window.data.combo.push(comboObj);
			}

			const productId = parseInt(checkbox.value);
			const contractId = parseInt(checkbox.getAttribute('data-contract-id'));
			const supplierId = checkbox.getAttribute('data-supplier-id');
			const supplierName = checkbox.getAttribute('data-supplier-name');
			const productName = checkbox.getAttribute('data-product-name');

			if (!isNaN(productId)) {
				if (checkbox.checked) {
					comboObj.produtos.push({ product_id: productId, contract_id: contractId, supplier_id: supplierId, supplier_name: supplierName , product_name: productName});
				} else {
					comboObj.produtos = comboObj.produtos.filter(item => item.product_id !== productId || item.contract_id !== contractId);
				}
			}

			comboObj.titulares = [];
			comboObj.dependentes = [];

			const participantes = document.querySelectorAll(`#holder_select_table_${comboId} .checkbox-option`);
			const $accordionContainer = $('#accordionContainer' + comboId);

			$accordionContainer.empty();

			const accordionsAdicionados = {};

			participantes.forEach(participante => {
				const participanteValue = participante.value;
				const participanteId = parseInt(participanteValue.replace(/\D/g, ''));
				const tipo = participanteValue.startsWith('titular') ? 'titular' : 
							participanteValue.startsWith('dependente') ? 'dependente' : null;

				if (!isNaN(participanteId) && participante.checked) {
					const holder = holders.find(h => h.id === participanteId && h.type === tipo);

					if (holder) {
						comboObj.produtos.forEach(produto => {
							const accordionKey = `${holder.id}-${produto.supplier_id}-${tipo}`;

							if (!accordionsAdicionados[accordionKey]) {
								accordionsAdicionados[accordionKey] = true;

								$accordionContainer.append(makeAccordion({
									id: holder.id,
									name: holder.name,
									type: holder.type,
									supplier_id: produto.supplier_id,
									supplier_name: produto.supplier_name
								}));
							}
						});

						if (tipo === 'titular') {
							comboObj.titulares.push(participanteId);
						} else if (tipo === 'dependente') {
							comboObj.dependentes.push(participanteId);
						}
					} else {
						console.error(`Holder não encontrado para o ID: ${participanteId} e tipo: ${tipo}`);
					}
				}
			});

		}

		function getCompaniesByContract(company_id) {

			axios.get(`{{ route('api.contracts.getCompaniesByContract', '') }}/${company_id}`, {
					headers: {
						"Authorization": "Bearer {{ session('Authorization') }}"
					}
				})
				.then(function(response) {

					$('#contract').empty();
					var contracts = response.data;

					$('#contract_id').select2({
						multiple: false,
						data: contracts.map(function(contract) {
							return {
								id: contract.contract_id,
								text: 'Contrato #'+contract.contract_id
							};
						})
					});

				})
				.catch(function(error) {
					console.error('Erro na requisição:', error);
				});
		}

		function getCompaniesByProduct(company_id, requests_type_id) {

			const url = `{{ route('api.contracts.getCompaniesByProduct', [':companyId', ':requestsTypeId']) }}`;

			const urlWithIds = url
			.replace(':companyId', company_id)
			.replace(':requestsTypeId', requests_type_id);

			axios.get(urlWithIds, {
				headers: {
					"Authorization": "Bearer {{ session('Authorization') }}"
				}
			})
			.then(function(response) {
				produtos = response.data;
				
				let select = $("#product_id");
				select.empty();
				select.append('<option value="">Selecione um produto</option>');

				$.each(produtos, function(index, produto) {

					var optionText = "Contrato #" + produto.contract_id + " - " + produto.product_type_name + " - " + produto.product_name + " - " + produto.supplier_name + " - " + produto.supplier_sla + " dias";
					var optionValue = produto.product_id;
					
					var option = $("<option></option>")
					.attr("value", optionValue)
					.attr("data-contract-id", produto.contract_id)
					.text(optionText);
					
					select.append(option);
				});
			})
			.catch(function(error) {
				console.error('Erro na requisição:', error);
			});
		}

		function createTableProducts(productTableId, currentComboId, requests_type_id) {
			var table = document.getElementById(productTableId);
			table.innerHTML = '';

			var thead = document.createElement('thead');
			thead.style.position = 'sticky';
			thead.style.top = '0';
			thead.style.zIndex = '1';

			var headerRow = document.createElement('tr');

			var thCheckbox = document.createElement('th');
			thCheckbox.scope = 'col';
			thCheckbox.textContent = '#';
			headerRow.appendChild(thCheckbox);

			var thProduct = document.createElement('th');
			thProduct.scope = 'col';
			thProduct.textContent = 'Produto';
			headerRow.appendChild(thProduct);

			thead.appendChild(headerRow);
			table.appendChild(thead);

			var tbody = document.createElement('tbody');
			tbody.id = 'tableBody';

			// Ordenar os produtos
			produtos.sort(function(a, b) {
				return a.id - b.id;
			});

			
			produtos.forEach(function(product) {
				let newMatchedRules = product.contract_rules
					.filter(function(rule) {
						return rule.supplier_type_request_id == requests_type_id; 
					})
					.map(function(rule) {
						return {
							contract_id: product.contract_id,
							quantity: rule.quantity,
							combo_id: currentComboId
						};
					});

				matchedRules = matchedRules.concat(newMatchedRules);

				var row = document.createElement('tr');

				var checkboxCell = document.createElement('td');
				var checkbox = document.createElement('input');
				checkbox.classList.add('form-check-input', 'checkbox-option');
				checkbox.type = 'checkbox';
				checkbox.value = product.product_id;
				checkbox.setAttribute('data-contract-id', product.contract_id);
				checkbox.setAttribute('data-supplier-id', product.supplier_id);
				checkbox.setAttribute('data-supplier-name', product.supplier_name);
				checkbox.setAttribute('data-product-name', product.product_name);

				checkbox.addEventListener('change', function() {
					updateCombo(this, currentComboId);
				});

				checkboxCell.appendChild(checkbox);
				row.appendChild(checkboxCell);

				var nameCell = document.createElement('td');
				nameCell.textContent = `${product.product_type_name} - ${product.supplier_name} - ${product.product_name} - Contracto#${product.contract_id} - SLA ${product.supplier_sla} dias`;
				row.appendChild(nameCell);

				tbody.appendChild(row);
			});

			table.appendChild(tbody);

		}

		async function getCompaniesByHolders(company_id) {
			try {
				let response = await axios({
					url: `{{ route('api.holders.company', '') }}/${company_id}`,
					method: 'get',
					headers: {
						"Authorization": "Bearer {{ session('Authorization') }}"
					}
				});

				holders = response.data;
				
			} catch (error) {
				console.log('Erro ao carregar os colaboradores:', error);
			}
		}

		function makeAccordion(holder) {
			console.log(holder);
			const accordionExample = $('<div>').addClass('accordion border').attr('id', 'accordionExample');
			const accordionItem = $('<div>').addClass('accordion-item');
			const accordionHeader = $('<h2>').addClass('accordion-header').attr('id', 'heading' + holder.id + holder.supplier_id + holder.type + holder.product_id);
			const accordionButtonText = holder.supplier_name ? `${holder.name} - Produto: ${holder.supplier_name}` : holder.name;
			const accordionButton = $('<button>').addClass('accordion-button').attr({
				type: 'button',
				'data-bs-toggle': 'collapse',
				'data-bs-target': '#collapse' + holder.id + holder.supplier_id + holder.type + holder.product_id,
				'aria-expanded': 'true',
				'aria-controls': 'collapse' + holder.id + holder.supplier_id  + holder.type + holder.product_id
			}).text(accordionButtonText);
			const accordionCollapse = $('<div>').addClass('accordion-collapse collapse').attr({
				id: 'collapse' + holder.id + holder.supplier_id  + holder.type + holder.product_id,
				'aria-labelledby': 'heading' + holder.id + holder.supplier_id  + holder.type + holder.product_id,
				'data-bs-parent': '#accordionExample'
			});
			const accordionBody = $('<div>').addClass('accordion-body');

			accordionCollapse.append(accordionBody);
			accordionHeader.append(accordionButton);
			accordionItem.append(accordionHeader).append(accordionCollapse);

			accordionExample.append(accordionItem);

			getListDocuments(holder.id, accordionBody, holder.supplier_id, holder.type);

			return accordionExample;
		}

		function getListDocuments(holderId, accordionBody, supplier_id, holderType) {

			const typeRequestId = $('#requests_type_id').val();
			const url = `{{ route('api.suppliers.documents.getDocumentsToSupplier', [':type_request_id', ':supplier_id']) }}`
				.replace(':type_request_id', typeRequestId)
				.replace(':supplier_id', supplier_id);

			axios.get(url, {
				headers: {
					"Authorization": "Bearer {{ session('Authorization') }}"
				}
			})
			.then(async function(response) {
				
				if (response.data.length > 0) {
					let holderEntry = groupedDocuments.find(entry => entry.holderid === holderId && entry.type === holderType);
					if (!holderEntry) {
						holderEntry = {
							holderid: holderId,
							type: holderType,
							documentos: [],
							protocol_operator: ''
						};
						groupedDocuments.push(holderEntry);
					}

					const row = $('<div>').addClass('row mt-1');

					for (const document of response.data) {
						try {
							const checkResponse = await checkExistingDocuments(holderId, document.id, holderType);

							if (checkResponse.data.length > 0) {
								checkResponse.data.forEach(item => {
									const documentEntry = {
										holderId: holderId,
										type: holderType,
										documents: item
									};

									const existingDocIndex = holderEntry.documentos.findIndex(doc => doc.id === item.id && doc.type === holderType);
									if (existingDocIndex === -1) {
										window.data.documentExists.push(documentEntry);
										holderEntry.documentos.push({
											id: item.id,
											filename: item.filename,
											file: null,
											supplier_type_request_id: item.id,
											type: holderType
										});
									}
								});

								const existingDocument = checkResponse.data[0];
								const documentLink = $('<a>')
									.attr('href', `/storage/${existingDocument.filepath}`)
									.attr('target', '_blank')
									.text(existingDocument.filename)
									.addClass('mr-2');

								const replaceButton = $('<button>')
									.text('Substituir Documento')
									.addClass('btn btn-warning btn-sm ml-2')
									.on('click', function() {
										const existingDocIndex = window.data.documentExists.findIndex(doc => 
											doc.documents.id === document.id && 
											doc.holderId === holderId && 
											doc.type === holderType &&
											doc.documents.filename === document.filename
										);

										if (existingDocIndex !== -1) {
											window.data.documentExists.splice(existingDocIndex, 1);
										} else {
											console.warn(`Documento ${document.filename} não encontrado para remoção.`);
										}

										container.empty();
										const newInputDocument = $('<input>').attr({
											type: 'file',
											id: 'doc_' + holderId + '_' + holderType + '_' + document.id,
											name: `documents[${holderId}][${holderType}][${document.id}]`
										});

										const newLabelDocument = $('<label>')
											.text(document.filename)
											.attr('for', 'doc_' + holderId + '_' + holderType + '_' + document.id);

										newInputDocument.on('change', function() {
											const selectedFile = this.files[0];
											if (selectedFile) {
												const docIndex = holderEntry.documentos.findIndex(doc => doc.id === document.id && doc.type === holderType);
												
												if (docIndex > -1) {
													holderEntry.documentos[docIndex].file = selectedFile;
												} else {
													holderEntry.documentos.push({
														id: document.id,
														filename: document.filename,
														file: selectedFile,
														supplier_type_request_id: document.id,
														type: holderType
													});
												}
											}
										});

										container.append(newLabelDocument).append('<br>').append(newInputDocument);
									});

								const col = $('<div>').addClass('col-md-6');
								const container = $('<div>').addClass('document-container mb-1');

								container.append(documentLink).append(replaceButton);
								col.append(container);
								row.append(col);

								continue;
							}
						} catch (error) {
							console.error(`Erro ao verificar documento ${document.id}:`, error);
							continue;
						}

						const col = $('<div>').addClass('col-md-6');
						const container = $('<div>').addClass('document-container mb-1');
						
						const labelDocument = $('<label>').text(document.filename)
							.attr('for', 'doc_' + document.id);
						
						const inputDocument = $('<input>').attr({
							type: 'file',
							id: 'doc_' + holderId + '_' + holderType + '_' + document.id,
							name: `documents[${holderId}][${holderType}][${document.id}]`,
							required: true
						});

						inputDocument.on('change', function() {
							const selectedFile = this.files[0];
							if (selectedFile) {
								const docIndex = holderEntry.documentos.findIndex(doc => doc.id === document.id && doc.type === holderType);
								
								if (docIndex > -1) {
									holderEntry.documentos[docIndex].file = selectedFile;
								} else {
									holderEntry.documentos.push({
										id: document.id,
										filename: document.filename,
										file: selectedFile,
										supplier_type_request_id: document.id,
										type: holderType
									});
								}
							}
						});

						container.append(labelDocument).append('<br>').append(inputDocument);
						col.append(container);
						row.append(col);
					}

					accordionBody.append(row);

					if (!holderEntry.protocol_operator) {
						const containerProtocol = $('<div>').addClass('text-input-container mt-1');
						const labelProtocol = $('<label>').text('Protocolo Operadora').attr('for', 'text_' + holderId);
						const inputProtocol = $('<input>').attr({
							type: 'text',
							id: 'text_' + holderId,
							name: `protocol_operator[${holderId}]`,
							class: 'form-control'
						});

						inputProtocol.on('input', function() {
							holderEntry.protocol_operator = this.value;

							window.data.deletionItens.forEach(item => {
                        	if (item.id == holderId) {
									item.protocol = holderEntry.protocol_operator;
								}
							});
						});

						containerProtocol.append(labelProtocol).append('<br>').append(inputProtocol);
						accordionBody.append(containerProtocol);
					}

					if (typeRequestId == 2) {
						const deleteTypeId = $('#delete_type_id').val();

						if(deleteTypeId == 1){
							window.data.deletionItens.forEach(item => {
                        	if (item.id == holderId) {
									item.status = 6;
								}
							});
						}else if (deleteTypeId == 2) {

							addFileInputFile(row, holderId, holderType, 'Carta de Demitidos e Aposentados', holderEntry, 16);
							for (let i = 1; i <= 3; i++) {
								addFileInputFile(row, holderId, holderType, `Último Holerite ${i}`, holderEntry, i + 16);
							}

							window.data.deletionItens.forEach(item => {
                        	if (item.id == holderId) {
									item.status = 5;
								}
							});
						} else if (deleteTypeId == 3) {
							
							addFileInputFile(row, holderId, holderType, 'Carta de Demitidos e Aposentados', holderEntry, 16);
							for (let i = 1; i <= 3; i++) {
								addFileInputFile(row, holderId, holderType, `Último Holerite ${i}`, holderEntry, i + 16);
							}
							addFileInputFile(row, holderId, holderType, 'Carta de Aposentadoria', holderEntry, 20);
							addFileInputData(row, holderId, holderType, 'Data de Início', 'extension_start_date');
							addFileInputData(row, holderId, holderType, 'Data de Fim', 'extension_end_date');

							const inputStartDate = $('#extension_start_date_' + holderId + '_' + holderType);
							const inputEndDate = $('#extension_end_date_' + holderId + '_' + holderType);

							window.data.deletionItens.forEach(item => {
								if (item.id == holderId) {
									item.status = 5;

								}
							});

							if (inputStartDate.length) {
								inputStartDate.on('input', function() {
									const startDate = this.value;
									console.log('Data de Início:', startDate);

									window.data.deletionItens.forEach(item => {
										if (item.id == holderId) {
											item.extension_start_date = startDate;
										}
									});
								});
							}

							if (inputEndDate.length) {
								inputEndDate.on('input', function() {
									const endDate = this.value;
									console.log('Data de Fim:', endDate);
									window.data.deletionItens.forEach(item => {
										if (item.id == holderId) {
											item.extension_end_date = endDate;
										}
									});
								});
							}

							
						}
					}

					if (typeRequestId == 3) {

						$('input[type="file"]').removeAttr('required');

                        window.data.combo = {
							id: holderId,
							type: holderType
						};

						const inputProtocol = $('#text_' + holderId);
						if (inputProtocol.length) {
							inputProtocol.on('input', function() {
								console.log("Evento input acionado, valor do protocolo:", this.value);
								
								holderEntry.protocol_operator = this.value;

								window.data.combo = {
									...window.data.combo,
									protocol: holderEntry.protocol_operator
								};

							});
						}
					}
					
					if (['6', '7', '8', '9', '10', '11'].includes(String(typeRequestId))) {
						$('input[type="file"]').removeAttr('required');

						window.data.combo = window.data.combo || [];

						window.data.combo.push({
							id: holderId,
							type: holderType
						});

						const inputProtocol = $('#text_' + holderId);
						if (inputProtocol.length) {
							inputProtocol.on('input', function() {
								console.log("Evento input acionado, valor do protocolo:", this.value);
								
								holderEntry.protocol_operator = this.value;

								window.data.combo[window.data.combo.length - 1] = {
									...window.data.combo[window.data.combo.length - 1],
									protocol: holderEntry.protocol_operator
								};

								const combosJson = JSON.stringify(window.data.combo);

							});
						}
					}

					if ($("#transfer_type_id").val() == 1) {

						window.data.combo = {
							id: holderId,
							type: holderType
						};

						const inputProtocol = $('#text_' + holderId);
						if (inputProtocol.length) {
							inputProtocol.on('input', function() {
								console.log("Evento input acionado, valor do protocolo:", this.value);

								holderEntry.protocol_operator = this.value;

								window.data.combo = {
									...window.data.combo,
									protocol: holderEntry.protocol_operator
								};
							});
						}

						const divRow = $('<div>').addClass('row');

						if ($('#cost_center_' + holderId).length === 0) {
							const divCostCenterCol = $('<div>').addClass('col-md-6');

							const costCenterContainer = $('<div>').addClass('form-group mt-1');
							const costCenterLabel = $('<label>')
								.attr('for', 'cost_center_' + holderId)
								.text('Centro de Custo');
							const costCenterInput = $('<input>')
								.attr('id', 'cost_center_' + holderId)
								.attr('type', 'text')
								.attr('placeholder', 'Centro de Custo')
								.addClass('form-control')
								.on('input', function() {
									console.log("Evento input acionado, valor do centro de custo:", this.value);

									holderEntry.cost_center = this.value;

									window.data.combo = {
										...window.data.combo,
										cost_center: holderEntry.cost_center
									};
								});

							costCenterContainer.append(costCenterLabel, costCenterInput);
							divCostCenterCol.append(costCenterContainer);
							divRow.append(divCostCenterCol);
						}

						if ($('#registration_' + holderId).length === 0) {
							const divRegistrationCol = $('<div>').addClass('col-md-6');

							const registrationContainer = $('<div>').addClass('form-group mt-1');
							const registrationLabel = $('<label>')
								.attr('for', 'registration_' + holderId)
								.text('Matrícula');
							const registrationInput = $('<input>')
								.attr('id', 'registration_' + holderId)
								.attr('type', 'text')
								.attr('placeholder', 'Matrícula')
								.addClass('form-control')
								.on('input', function() {
									console.log("Evento input acionado, valor da matrícula:", this.value);

									holderEntry.registration = this.value;

									window.data.combo = {
										...window.data.combo,
										registration: holderEntry.registration
									};
								});

							registrationContainer.append(registrationLabel, registrationInput);
							divRegistrationCol.append(registrationContainer);
							divRow.append(divRegistrationCol);
						}

						if ($('#role_' + holderId).length === 0) {
							const divRoleCol = $('<div>').addClass('col-md-6');

							const roleContainer = $('<div>').addClass('form-group mt-1');
							const roleLabel = $('<label>')
								.attr('for', 'role_' + holderId)
								.text('Função');
							const roleInput = $('<input>')
								.attr('id', 'role_' + holderId)
								.attr('type', 'text')
								.attr('placeholder', 'Cargo')
								.addClass('form-control')
								.on('input', function() {
									console.log("Evento input acionado, valor da função:", this.value);

									holderEntry.role = this.value;

									window.data.combo = {
										...window.data.combo,
										role: holderEntry.role
									};
								});

							roleContainer.append(roleLabel, roleInput);
							divRoleCol.append(roleContainer);
							divRow.append(divRoleCol);
						}

						divRow.appendTo('.accordion-body');
					}

					if ($("#transfer_type_id").val() == 4) {

						window.data.combo = {
							id: holderId,
							type: holderType
						};

						const inputProtocol = $('#text_' + holderId);
						if (inputProtocol.length) {
							inputProtocol.on('input', function() {
								console.log("Evento input acionado, valor do protocolo:", this.value);

								holderEntry.protocol_operator = this.value;

								window.data.combo = {
									...window.data.combo,
									protocol: holderEntry.protocol_operator
								};
							});
						}

					}

					if ($("#transfer_type_id").val() == 2) {

						window.data.combo = {
							id: holderId,
							type: holderType
						};

						const inputProtocol = $('#text_' + holderId);
						if (inputProtocol.length) {
							inputProtocol.on('input', function() {
								console.log("Evento input acionado, valor do protocolo:", this.value);

								holderEntry.protocol_operator = this.value;

								window.data.combo = {
									...window.data.combo,
									protocol: holderEntry.protocol_operator
								};
							});
						}

						if ($('#cost_center_' + holderId).length === 0) {
							const costCenterContainer = $('<div>').addClass('form-group mt-1');

							const costCenterLabel = $('<label>')
								.attr('for', 'cost_center_' + holderId)
								.text('Centro de Custo');

							const costCenterInput = $('<input>')
								.attr('id', 'cost_center_' + holderId)
								.attr('type', 'text')
								.attr('placeholder', 'Centro de Custo')
								.addClass('form-control')
								.on('input', function() {
									console.log("Evento input acionado, valor do centro de custo:", this.value);

									holderEntry.cost_center = this.value;

									window.data.combo = {
										...window.data.combo,
										cost_center: holderEntry.cost_center
									};
								});

							costCenterContainer.append(costCenterLabel, costCenterInput);

							// Adiciona o container à área do acordeão
							costCenterContainer.appendTo('.accordion-body');
						}
					}

					if ($("#transfer_type_id").val() == 3) {
						// Inicializar 'combo' como um array vazio se ainda não existir
						if (!Array.isArray(window.data.combo)) {
							window.data.combo = [];
						}

						const inputProtocol = $('#text_' + holderId);
						if (inputProtocol.length) {
							inputProtocol.on('input', function() {
								console.log("Evento input acionado, valor do protocolo:", this.value);

								holderEntry.protocol_operator = this.value;

								const existingCombo = window.data.combo.find(combo => combo.id === holderId);
								if (existingCombo) {
									existingCombo.protocol = holderEntry.protocol_operator;
								} else {
									window.data.combo.push({
										id: holderId,
										type: holderType,
										protocol: holderEntry.protocol_operator,
										beneficiaries: []
									});
								}
							});
						}

						// Verifica se o contêiner já existe e o reutiliza
						let holderContainer = $(`#holderContainer${holderId}`);
						if (!holderContainer.length) {
							holderContainer = $('<div>')
								.attr('id', `holderContainer${holderId}`)
								.addClass('holder-container bg-light p-2 border border-1 rounded');
							$(`#collapse${holderId}${supplier_id}${holderType}undefined .accordion-body`).prepend(holderContainer);
						} else {
							holderContainer.empty(); // Limpa o conteúdo existente
						}

						// Filtrar apenas os dados do titular e dos dependentes específicos
						const holderData = holdersChange.filter(holder => {
							return (holder.type === 'titular' && holder.id === holderId) ||
								(holder.type === 'dependente' && holder.holder_id === holderId);
						});

						holderData.forEach(holder => {
							const row = $('<div>').addClass('row mb-2 align-items-center');
							const nameCol = $('<div>').addClass('col-md-4').text(`${holder.name} - ${holder.type}`);

							const titularCheckbox = $('<input>')
								.attr('type', 'checkbox')
								.addClass('form-check-input')
								.attr('name', `titular_${holder.id}`)
								.attr('id', `titular_${holder.id}`);
							if (holder.type === 'titular') {
								titularCheckbox.prop('checked', true);
							}

							const titularLabel = $('<label>')
								.addClass('form-check-label me-3')
								.attr('for', `titular_${holder.id}`)
								.text('Titular');

							const dependenteCheckbox = $('<input>')
								.attr('type', 'checkbox')
								.addClass('form-check-input')
								.attr('name', `dependente_${holder.id}`)
								.attr('id', `dependente_${holder.id}`);
							if (holder.type === 'dependente') {
								dependenteCheckbox.prop('checked', true);
							}

							const dependenteLabel = $('<label>')
								.addClass('form-check-label me-3')
								.attr('for', `dependente_${holder.id}`)
								.text('Dependente');

							const excluirCheckbox = $('<input>')
								.attr('type', 'checkbox')
								.addClass('form-check-input')
								.attr('name', `excluir_${holder.id}`)
								.attr('id', `excluir_${holder.id}`);

							const excluirLabel = $('<label>')
								.addClass('form-check-label me-3')
								.attr('for', `excluir_${holder.id}`)
								.text('Excluir');

							const checkboxCol = $('<div>').addClass('col-md-8 d-flex align-items-center')
								.append(titularCheckbox, titularLabel)
								.append(dependenteCheckbox, dependenteLabel)
								.append(excluirCheckbox, excluirLabel);

							row.append(nameCol, checkboxCol);
							holderContainer.append(row);

							const checkboxes = [
								{ checkbox: titularCheckbox, value: 1 },
								{ checkbox: dependenteCheckbox, value: 2 },
								{ checkbox: excluirCheckbox, value: 3 }
							];

							checkboxes.forEach((cbObject, index) => {
								cbObject.checkbox.on('change', function() {
									if (this.checked) {
										checkboxes.forEach((otherCb, i) => {
											if (i !== index) otherCb.checkbox.prop('checked', false);
										});

										const newBeneficiary = {
											id: holder.id,
											type: holder.type,
											newtype: cbObject.value
										};

										const existingCombo = window.data.combo.find(combo => combo.id === holderId);
										if (existingCombo) {
											const existingBeneficiaryIndex = existingCombo.beneficiaries.findIndex(
												beneficiary => beneficiary.id === holder.id
											);

											if (existingBeneficiaryIndex !== -1) {
												existingCombo.beneficiaries[existingBeneficiaryIndex] = newBeneficiary;
											} else {
												existingCombo.beneficiaries.push(newBeneficiary);
											}
										} else {
											window.data.combo.push({
												id: holderId,
												type: holderType,
												beneficiaries: [newBeneficiary]
											});
										}

										console.log("window.data.combo atualizado:", window.data.combo);
									}
								});
							});
						});
					}

					if ($("#transfer_type_id").val() == 5) {
						window.data.combo = window.data.combo || [];

						let currentCombo = window.data.combo.find(c => c.id === holderId);

						if (!currentCombo) {
							currentCombo = {
								id: holderId,
								products: [],
								naoOptante: false
							};
							window.data.combo.push(currentCombo);
						}

						let holderContainer = $(`#holderContainer${holderId}`);

						if (!holderContainer.length) {
							holderContainer = $('<div>')
								.attr('id', `holderContainer${holderId}`)
								.addClass('holder-container bg-light p-2 border border-1 rounded');
							$('.accordion-body').prepend(holderContainer);
						}

						holderContainer.empty();

						const naoOptanteCheckbox = $('<input>')
							.attr('type', 'checkbox')
							.addClass('form-check-input me-2')
							.attr('name', `nao_optante_${holderId}`)
							.attr('id', `nao_optante_${holderId}`);

						const naoOptanteLabel = $('<label>')
							.addClass('form-check-label')
							.attr('for', `nao_optante_${holderId}`)
							.text('Não Optante');

						const naoOptanteCol = $('<div>').addClass('col-md-3 d-flex align-items-center gap-2')
							.append(naoOptanteCheckbox, naoOptanteLabel);

						const naoOptanteRow = $('<div>').addClass('row mb-2 align-items-center');
						naoOptanteRow.append(naoOptanteCol);
						holderContainer.append(naoOptanteRow);

						const row = $('<div>').addClass('row mb-2 align-items-center');

						// Verifica se produtos existe e o converte em um array se necessário
						if (typeof produtos === 'object') {
							produtos = Object.values(produtos);
						}

						produtos.forEach(produto => {
							const titularCheckbox = $('<input>')
								.attr('type', 'checkbox')
								.addClass('form-check-input me-2')
								.attr('name', `titular_${produto.product_id}_${holderId}`)
								.attr('id', `titular_${produto.product_id}_${holderId}`);

							const titularLabel = $('<label>')
								.addClass('form-check-label')
								.attr('for', `titular_${produto.product_id}_${holderId}`)
								.text(produto.product_name);

							const checkboxCol = $('<div>').addClass('col-md-3 d-flex align-items-center gap-2')
								.append(titularCheckbox, titularLabel);

							row.append(checkboxCol);
							holderContainer.append(row);

							titularCheckbox.on('change', function() {
								const newProduct = {
									id: produto.product_id,
									name: produto.product_name,
									type: produto.product_type_id,
									supplier_id: produto.supplier_id,
									contract_id: produto.contract_id
								};

								currentCombo.products = currentCombo.products.filter(p => p.id !== produto.product_id);
								if (this.checked) {
									currentCombo.products.push(newProduct);
								}

								console.log("window.data.combo atualizado:", window.data.combo);
							});
						});

						naoOptanteCheckbox.on('change', function() {
							currentCombo.naoOptante = this.checked;
							console.log("window.data.combo atualizado:", window.data.combo);
						});
					}



				}else{
					Swal.fire({
						icon: 'info',
						title: 'Não existe SLA para esse produto',
						text: 'Tente cadatrar um SLA para prosseguir.',
						confirmButtonText: 'OK'
					});
				}
			})
			.catch(function(error) {
				console.error('Erro ao obter documentos:', error);
			});
		}

		function checkExistingDocuments(holderId, documentId, holderType) {

			const url = `{{ route('api.holders.documents.checkExisting', [':holder_id', ':document_id', ':holder_type']) }}`
				.replace(':holder_id', holderId)
				.replace(':document_id', documentId)
				.replace(':holder_type', holderType);

			return axios.get(url, {
				headers: {
					"Authorization": "Bearer {{ session('Authorization') }}"
				}
			});
		}

		// FUNCTION FOR EXCLUSION

		function dataExclusion(company_id) {

			const url = `{{ route('api.requests.dataExclusion', [':company_id',':supplier_type_request_id']) }}`
				.replace(':company_id', company_id)
				.replace(':supplier_type_request_id', 2)

			return axios.get(url, {
				headers: {
					"Authorization": "Bearer {{ session('Authorization') }}"
				}
			});
		}

		function createTableExclusion(company_id) {
			dataExclusion(company_id)
				.then(response => {
					
					if(response.data.length > 0){
						const comboContainer = $("#comboList");
						comboContainer.empty();

						$.each(response.data, function(index, item) {
							const card = $(`
								<div class="card mb-3">
									<div class="card-body">
										<h5 class="card-title" data-product-id="${item.produto}" data-contract-id="${item.contract}">
											${item.product_name} - Contrato: #${item.contract}
										</h5>
										<div class="row mb-2">
											<div class="col-md-4 d-flex align-items-center">
												<input type="checkbox" class="form-check-input select-all me-2" data-contract="${item.contract}">
												<label class="form-check-label" for="select-all">Selecionar tudo</label>
											</div>
											<div class="col-md-4">
												<input class="form-control" type="text" id="filter-name-exclusion-${index}" placeholder="Buscar por nome">
											</div>
											<div class="col-md-4">
												<select class="form-control" id="filter-role-exclusion-${index}">
													<option value="" selected>Selecione o Cargo</option>
												</select>
											</div>
										</div>
										<table class="table">
											<thead>
												<tr>
													<th scope="col">Selecionar</th>
													<th scope="col">Nome</th>
													<th scope="col">Tipo</th>
													<th scope="col">Cargo</th>
													<th scope="col">Centro de Custo</th>
												</tr>
											</thead>
											<tbody>
											</tbody>
										</table>
										<div class="accordion" id="accordion-${index}"></div> <!-- Acordeão -->
									</div>
								</div>
							`);

							const tableBody = card.find("tbody");
							const uniqueRoles = new Set();

							$.each(item.holders, function(_, holder) {
								uniqueRoles.add(holder.holder.role || 'N/A');
								const row = $(`
									<tr>
										<td><input type="checkbox" class="form-check-input checkbox-option" name="selectPerson${item.contract}" value="${holder.holder.id}" data-type="titular"></td>
										<td>${holder.holder.name}</td>
										<td>Titular</td>
										<td>${holder.holder.role || 'N/A'}</td>
										<td>${holder.holder.cost_center || 'N/A'}</td>
									</tr>
								`);
								tableBody.append(row);

								row.find('.checkbox-option').on('change', function() {
									if ($(this).is(':checked')) {
										console.log(holder);
										const supplierId = holder.supplier_id;
										const accordion = makeAccordion({ ...holder.holder, supplier_id: supplierId, type: 'titular', product_id: holder.product_id});
										card.append(accordion);
									} else {
										const accordionId = 'collapse' + holder.holder.id + holder.supplier_id + holder.type + holder.product_id;
										const accordionCollapseElement = card.find('#' + accordionId);
										if (accordionCollapseElement.length) {
											accordionCollapseElement.closest('.accordion-item').remove();
										}
									}
								});
							});

							$.each(item.dependentes, function(_, dependent) {
								uniqueRoles.add(dependent.dependent.role || 'N/A');
								const row = $(`
									<tr>
										<td><input type="checkbox" class="form-check-input checkbox-option" name="selectPerson${item.contract}" value="${dependent.dependent.id}" data-type="dependente"></td>
										<td>${dependent.dependent.name}</td>
										<td>Dependente</td>
										<td>${dependent.dependent.role || 'N/A'}</td>
										<td>${dependent.dependent.cost_center || 'N/A'}</td>
									</tr>
								`);
								tableBody.append(row);

								row.find('.checkbox-option').on('change', function() {
									if ($(this).is(':checked')) {
										const supplierId = dependent.supplier_id;
										const accordion = makeAccordion({ ...dependent.dependent, supplier_id: supplierId, type: 'dependente', product_id: dependent.product_id});
										card.append(accordion);
									} else {
										const accordionId = 'collapse' + dependent.dependent.id + dependent.supplier_id + dependent.type + dependent.product_id;
										const accordionCollapseElement = card.find('#' + accordionId);
										if (accordionCollapseElement.length) {
											accordionCollapseElement.closest('.accordion-item').remove();
										}
									}
								});
							});

							const roleFilter = card.find(`#filter-role-exclusion-${index}`);
							uniqueRoles.forEach(role => {
								const option = `<option value="${role}">${role}</option>`;
								roleFilter.append(option);
							});

							comboContainer.append(card);

							card.find(`#filter-name-exclusion-${index}`).on('input', function() {
								filterTableExclusion(index);
							});
							roleFilter.on('change', function() {
								filterTableExclusion(index);
							});
						});

						comboContainer.on("change", ".select-all", function() {
							const isChecked = $(this).is(':checked');
							const contractId = $(this).data('contract');
							$(`input[name="selectPerson${contractId}"]`).prop('checked', isChecked);
							updateCheckedItems();
						});

						comboContainer.on("change", ".checkbox-option", updateCheckedItems);
					}else{
						const errorRow = $(`
                            <div class="alert alert-warning" role="alert" style="padding: 1rem; text-align: center;">
								Não foi localizado nenhum beneficiario
							</div>
                        `);
                        $("#comboList").append(errorRow);
					}

				})
				.catch(error => {
					console.error("Erro ao buscar dados de exclusão:", error);
					const errorRow = $(`
						<div class="alert-warning">
							Erro ao carregar os dados
						</div>
					`);
					$("#comboList").append(errorRow);
				});
		}

		function updateCheckedItems() {
			window.data.deletionItens = [];

			$(".checkbox-option:checked").each(function() {
				const holderOrDependentId = $(this).val();
				const productId = $(this).closest(".card").find(".card-title").data("product-id");
				const contractId = $(this).closest(".card").find(".card-title").data("contract-id");
				const type = $(this).data("type");

				const existingEntry = window.data.deletionItens.find(item => item.id === holderOrDependentId);
        		const protocol = existingEntry ? existingEntry.protocol : null;

				window.data.deletionItens.push({
					id: holderOrDependentId,
					product_id: productId,
					contract_id: contractId,
					type: type,
					protocol: protocol,
					status: status
				});
			});

			console.log("Itens selecionados:", window.data.deletionItens);

		}

		function addFileInputFile(row, holderId, holderType, labelText, holderEntry, documentId, multiple = false) {
			const col = $('<div>').addClass('col-md-6');
			const container = $('<div>').addClass('document-container mb-1');

			const labelDocument = $('<label>').text(labelText);
			const inputDocument = $('<input>').attr({
				type: 'file',
				id: 'doc_' + holderId + '_' + holderType,
				name: `documents[${holderId}][${holderType}]`,
				multiple: multiple,
				required: true
			});

			inputDocument.on('change', function() {
				const selectedFile = this.files[0];
				if (selectedFile) {
					const docIndex = holderEntry.documentos.findIndex(doc => doc.filename === labelText && doc.type === holderType);

					if (docIndex > -1) {
						holderEntry.documentos[docIndex].file = selectedFile;
					} else {
						holderEntry.documentos.push({
							id: documentId,  
							filename: labelText,
							file: selectedFile,
							supplier_type_request_id: null,
							type: holderType
						});
					}
				}
			});

			container.append(labelDocument).append('<br>').append(inputDocument);
			col.append(container);
			row.append(col);
		}

		function addFileInputData(row, holderId, holderType, labelText, nameInput) {
			const col = $('<div>').addClass('col-md-6');
			const container = $('<div>').addClass('document-container mb-1');

			const labelData = $('<label>').text(labelText);
			const inputData = $('<input>').attr({
				type: 'date',
				id: nameInput + '_' + holderId + '_' + holderType,
				name: `${nameInput}[${holderId}][${holderType}]`
			}).addClass('form-control');;

			container.append(labelData).append('<br>').append(inputData);
			col.append(container);
			row.append(col);
		}

		function clearGlobalData(){
			window.data.combo = [];
			window.data.documentExists = [];
			window.data.deletionItens = [];
		}

		// END FUNCTION

		// FUNCTION FOR CHANGED

		async function dataChange(company_id) {

			const url = `{{ route('api.holders.companyChange', ':company_id') }}`
				.replace(':company_id', company_id)


			await axios.get(url, {
				headers: {
					"Authorization": "Bearer {{ session('Authorization') }}"
				}
			}).then(response => {
				
				holdersChange = response.data;

			})
			.catch(error => {

				console.error('Error:', error);

			});
		}

		function createTableChangeRegistration(dataHolders) {
			let holders = dataHolders;

			let $holderSelectTable = $('#comboList');

			$holderSelectTable.empty();

			let card = `
				<div class="card">
					<div class="card-header">
						<h5 class="mb-0">Registro de Mudança</h5>
					</div>
					<div class="card-body" id="cardBody">
						<div class="row mb-3">
							<div class="col-md-6">
								<input class="form-control mt-2" type="text" id="filterName" placeholder="Buscar por nome" oninput="filterTable()">
							</div>
							<div class="col-md-6">
								<select class="form-control mt-2" id="filterRole" onchange="filterTable()">
									<option value="" selected>Selecione cargo</option>
								</select>
							</div>
						</div>
						<table class="table">
							<thead style="position: sticky; top: 0; z-index: 1;">
								<tr>
									<th scope="col">Selecionar</th>
									<th scope="col">Nome</th>
									<th scope="col">Tipo</th>
									<th scope="col">Cargo</th>
									<th scope="col">Centro de custo</th>
								</tr>
							</thead>
							<tbody id="tableBody">
			`;

			$holderSelectTable.append(card);

			let uniqueRoles = [...new Set(holders.map(holder => holder.role))];
			const combinedSelect = document.getElementById('filterRole');

			const roleOptgroup = document.createElement('optgroup');
			roleOptgroup.label = "Cargos";

			uniqueRoles.forEach(role => {
				const option = document.createElement('option');
				option.value = role;
				option.textContent = role;
				roleOptgroup.appendChild(option);
			});

			combinedSelect.appendChild(roleOptgroup);

			let tbody = $('#tableBody');

			if (holders.length > 0) {
				holders.forEach(holder => {
					let row = `
						<tr>
							<td>
								<input class="form-check-input radio-option" name="holderSelect" id="${holder.id}" type="radio" value="${holder.type + holder.id}" data-id="${holder.id}" data-type="${holder.type}">
							</td>
							<td>
								<label class="form-check-label ms-3 me-6" for="${holder.id}">${holder.name}</label>
							</td>
							<td>${holder.type}</td>
							<td>${holder.role}</td>
							<td>${holder.cost_center}</td>
						</tr>
					`;
					tbody.append(row);
				});
			} else {
				tbody.append('<tr><td colspan="5">Colaborador não encontrado</td></tr>');
			}

			$holderSelectTable.append(`</tbody></table>`);

			const actionButton = `
				<button id="actionButton" class="btn btn-primary my-2" style="display:none;">Editar cadastro</button>
			`;
			let $cardBody = $('#cardBody');
			$cardBody.append(actionButton);

			$('input[name="holderSelect"]').on('change', function() {

				holderData = [];

				$('#actionButton').show();

				const selectedId = $(this).data('id');
				const selectedType = $(this).data('type');

				$('#accordionExample').remove();
		
				let selectedHolder = holders.find(holder => holder.id === selectedId);
				let accordion = makeAccordion({...selectedHolder, supplier_id: 2});
				$cardBody.append(accordion);

				$('#actionButton').off('click').on('click', function(e) {
					e.preventDefault();
					editRegistration(selectedId, selectedType);
				});
			});

			$holderSelectTable.append(`</div></div>`);
		}

		async function editRegistration(id, type) {
			console.log(id, type);

			if(type === 'titular'){

				if (!holderData || Object.keys(holderData).length === 0) {
					await getDataHolder(id);
				}

				$('#modalHolder').find('input, select').val('');
				
				$('#modalHolder #address').val(holderData.address);
				$('#modalHolder #admission_date').val(holderData.admission_date);
				$('#modalHolder #bank').val(holderData.bank);
				$('#modalHolder #bank_account').val(holderData.bank_account);
				$('#modalHolder #bank_agency').val(holderData.bank_agency);
				$('#modalHolder #bank_number').val(holderData.bank_number);
				$('#modalHolder #birth_date').val(holderData.birth_date);
				$('#modalHolder #city').val(holderData.city);
				$('#modalHolder #civil_status').val(holderData.civil_status);
				$('#modalHolder #cnpj').val(holderData.cnpj);
				$('#modalHolder #company_id').val(holderData.company_id);
				$('#modalHolder #company_name').val(holderData.company_name);
				$('#modalHolder #complement').val(holderData.complement);
				$('#modalHolder #coparticipation_rate').val(holderData.coparticipation_rate);
				$('#modalHolder #corporate_email').val(holderData.corporate_email);
				$('#modalHolder #corporative_phone').val(holderData.corporative_phone);
				$('#modalHolder #cost_center').val(holderData.cost_center);
				$('#modalHolder #cpf').val(holderData.cpf);
				$('#modalHolder #created_at').val(holderData.created_at);
				$('#modalHolder #deleted_at').val(holderData.deleted_at);
				$('#modalHolder #deletion_date').val(holderData.deletion_date);
				$('#modalHolder #district').val(holderData.district);
				$('#modalHolder #email').val(holderData.email);
				$('#modalHolder #employee_type').val(holderData.employee_type);
				$('#modalHolder #extension_end_date').val(holderData.extension_end_date);
				$('#modalHolder #extension_start_date').val(holderData.extension_start_date);
				$('#modalHolder #holder_status_id').val(holderData.holder_status_id);
				$('#modalHolder #included_with_carency').val(holderData.included_with_carency);
				$('#modalHolder #injuction').val(holderData.injuction);
				$('#modalHolder #issuing_body').val(holderData.issuing_body);
				$('#modalHolder #issuing_date').val(holderData.issuing_date);
				$('#modalHolder #mother_name').val(holderData.mother_name);
				$('#modalHolder #name').val(holderData.name);
				$('#modalHolder #number').val(holderData.number);
				$('#modalHolder #personal_phone').val(holderData.personal_phone);
				$('#modalHolder #pre_existing_cid').val(holderData.pre_existing_cid);
				$('#modalHolder #registration').val(holderData.registration);
				$('#modalHolder #rg').val(holderData.rg);
				$('#modalHolder #role').val(holderData.role);
				$('#modalHolder #sex').val(holderData.sex);
				$('#modalHolder #state').val(holderData.state);
				$('#modalHolder #status').val(holderData.status);
				$('#modalHolder #sus_card').val(holderData.sus_card);
				$('#modalHolder #updated_at').val(holderData.updated_at);
				$('#modalHolder #wage').val(holderData.wage);
				$('#modalHolder #wedding_date').val(holderData.wedding_date);
				$('#modalHolder #zip_code').val(holderData.zip_code);

				$('#modalHolder').modal('show');

			}
			if(type === 'dependente') {

				if (!holderData || Object.keys(holderData).length === 0) {
					await getDataDependent(id);
				}

				$('#modalDependent').find('input, select').val('');

				$('#modalDependent #address').val(holderData.address);
				$('#modalDependent #bank').val(holderData.bank);
				$('#modalDependent #bank_account').val(holderData.bank_account);
				$('#modalDependent #bank_agency').val(holderData.bank_agency);
				$('#modalDependent #bank_number').val(holderData.bank_number);
				$('#modalDependent #benefit_time').val(holderData.benefit_time);
				$('#modalDependent #birth_date').val(holderData.birth_date);
				$('#modalDependent #carency').val(holderData.carency);
				$('#modalDependent #carency_inclusion').val(holderData.carency_inclusion);
				$('#modalDependent #city').val(holderData.city);
				$('#modalDependent #civil_status').val(holderData.civil_status);
				$('#modalDependent #complement').val(holderData.complement);
				$('#modalDependent #cpf').val(holderData.cpf);
				$('#modalDependent #district').val(holderData.district);
				$('#modalDependent #email').val(holderData.email);
				$('#modalDependent #holder_id').val(holderData.holder_id);
				$('#modalDependent #id').val(holderData.id);
				$('#modalDependent #injuction').val(holderData.injuction);
				$('#modalDependent #issuing_body').val(holderData.issuing_body);
				$('#modalDependent #issuing_date').val(holderData.issuing_date);
				$('#modalDependent #kinship_id').val(holderData.kinship_id);
				$('#modalDependent #mother_name').val(holderData.mother_name);
				$('#modalDependent #name').val(holderData.name);
				$('#modalDependent #number').val(holderData.number);
				$('#modalDependent #rg').val(holderData.rg);
				$('#modalDependent #sex').val(holderData.sex);
				$('#modalDependent #state').val(holderData.state);
				$('#modalDependent #status').val(holderData.status);
				$('#modalDependent #sus_card').val(holderData.sus_card);
				$('#modalDependent #wedding_date').val(holderData.wedding_date);
				$('#modalDependent #zip_code').val(holderData.zip_code);


				$('#modalDependent').modal('show');
			}

		}

		async function getDataHolder(id) {

			try {
				let response = await axios({
					url: `{{ route('api.holders.find', '') }}/${id}`,
					method: 'get',
					headers: {
						"Authorization": "Bearer {{ session('Authorization') }}"
					}
				});

				holderData = response.data;
				
			} catch (error) {
				console.log('Erro ao carregar os colaboradores:', error);
			}
		}

		async function getDataDependent(id) {

			try {
				let response = await axios({
					url: `{{ route('api.dependents.find', '') }}/${id}`,
					method: 'get',
					headers: {
						"Authorization": "Bearer {{ session('Authorization') }}"
					}
				});

				holderData = response.data;
				
			} catch (error) {
				console.log('Erro ao carregar os colaboradores:', error);
			}
		}

		$('#btnAddMoldeHolder').on('click', function(event) {
			event.preventDefault();

			holderData = {
				address: $('#modalHolder #address').val(),
				admission_date: $('#modalHolder #admission_date').val(),
				bank: $('#modalHolder #bank').val(),
				bank_account: $('#modalHolder #bank_account').val(),
				bank_agency: $('#modalHolder #bank_agency').val(),
				bank_number: $('#modalHolder #bank_number').val(),
				birth_date: $('#modalHolder #birth_date').val(),
				city: $('#modalHolder #city').val(),
				civil_status: $('#modalHolder #civil_status').val(),
				cnpj: $('#modalHolder #cnpj').val(),
				company_id: $('#modalHolder #company_id').val(),
				company_name: $('#modalHolder #company_name').val(),
				complement: $('#modalHolder #complement').val(),
				coparticipation_rate: $('#modalHolder #coparticipation_rate').val(),
				corporate_email: $('#modalHolder #corporate_email').val(),
				corporative_phone: $('#modalHolder #corporative_phone').val(),
				cost_center: $('#modalHolder #cost_center').val(),
				cpf: $('#modalHolder #cpf').val(),
				created_at: $('#modalHolder #created_at').val(),
				deleted_at: $('#modalHolder #deleted_at').val(),
				deletion_date: $('#modalHolder #deletion_date').val(),
				district: $('#modalHolder #district').val(),
				email: $('#modalHolder #email').val(),
				employee_type: $('#modalHolder #employee_type').val(),
				extension_end_date: $('#modalHolder #extension_end_date').val(),
				extension_start_date: $('#modalHolder #extension_start_date').val(),
				holder_status_id: $('#modalHolder #holder_status_id').val(),
				included_with_carency: $('#modalHolder #included_with_carency').val(),
				injuction: $('#modalHolder #injuction').val(),
				issuing_body: $('#modalHolder #issuing_body').val(),
				issuing_date: $('#modalHolder #issuing_date').val(),
				mother_name: $('#modalHolder #mother_name').val(),
				name: $('#modalHolder #name').val(),
				number: $('#modalHolder #number').val(),
				personal_phone: $('#modalHolder #personal_phone').val(),
				pre_existing_cid: $('#modalHolder #pre_existing_cid').val(),
				registration: $('#modalHolder #registration').val(),
				rg: $('#modalHolder #rg').val(),
				role: $('#modalHolder #role').val(),
				sex: $('#modalHolder #sex').val(),
				state: $('#modalHolder #state').val(),
				status: $('#modalHolder #status').val(),
				sus_card: $('#modalHolder #sus_card').val(),
				updated_at: $('#modalHolder #updated_at').val(),
				wage: $('#modalHolder #wage').val(),
				wedding_date: $('#modalHolder #wedding_date').val(),
				zip_code: $('#modalHolder #zip_code').val()
			};

			$('#modalHolder').modal('hide');

		});

		$('#btnAddMoldeDependent').on('click', function(event) {
			event.preventDefault();

			holderData = {
				address: $('#modalDependent #address').val(),
				bank: $('#modalDependent #bank').val(),
				bank_account: $('#modalDependent #bank_account').val(),
				bank_agency: $('#modalDependent #bank_agency').val(),
				bank_number: $('#modalDependent #bank_number').val(),
				benefit_time: $('#modalDependent #benefit_time').val(),
				birth_date: $('#modalDependent #birth_date').val(),
				carency: $('#modalDependent #carency').val(),
				carency_inclusion: $('#modalDependent #carency_inclusion').val(),
				city: $('#modalDependent #city').val(),
				civil_status: $('#modalDependent #civil_status').val(),
				complement: $('#modalDependent #complement').val(),
				cpf: $('#modalDependent #cpf').val(),
				district: $('#modalDependent #district').val(),
				email: $('#modalDependent #email').val(),
				holder_id: $('#modalDependent #holder_id').val(),
				id: $('#modalDependent #id').val(),
				injuction: $('#modalDependent #injuction').val(),
				issuing_body: $('#modalDependent #issuing_body').val(),
				issuing_date: $('#modalDependent #issuing_date').val(),
				kinship_id: $('#modalDependent #kinship_id').val(),
				mother_name: $('#modalDependent #mother_name').val(),
				name: $('#modalDependent #name').val(),
				number: $('#modalDependent #number').val(),
				rg: $('#modalDependent #rg').val(),
				sex: $('#modalDependent #sex').val(),
				state: $('#modalDependent #state').val(),
				status: $('#modalDependent #status').val(),
				sus_card: $('#modalDependent #sus_card').val(),
				wedding_date: $('#modalDependent #wedding_date').val(),
				zip_code: $('#modalDependent #zip_code').val()
			};

			$('#modalDependent').modal('hide');

		});

		// END FUNCTION

		// FUNCTION FOR TRANSFER

		async function dataTransfer(company_id) {

			const url = `{{ route('api.holders.companyTransfer', ':company_id') }}`
				.replace(':company_id', company_id)


			await axios.get(url, {
				headers: {
					"Authorization": "Bearer {{ session('Authorization') }}"
				}
			}).then(response => {
				
				holdersChange = response.data;

			})
			.catch(error => {

				console.error('Error:', error);

			});
		}

		function createTableTransferCostCenter(dataHolders) {
			let holders = dataHolders;
			console.log(holders)
			let $holderSelectTable = $('#comboList');
			$holderSelectTable.empty();

			let card = `
				<div class="card">
					<div class="card-header">
						<h5 class="mb-0">Transferência de centro de custo</h5>
					</div>
					<div class="card-body" id="cardBody">
						<div class="row mb-3">
							<div class="col-md-6">
								<input class="form-control mt-2" type="text" id="filterName" placeholder="Buscar por nome" oninput="filterTable()">
							</div>
							<div class="col-md-6">
								<select class="form-control mt-2" id="filterRole" onchange="filterTable()">
									<option value="" selected>Selecione cargo</option>
								</select>
							</div>
						</div>
						<table class="table">
							<thead style="position: sticky; top: 0; z-index: 1;">
								<tr>
									<th scope="col">Selecionar</th>
									<th scope="col">Nome</th>
									<th scope="col">Tipo</th>
									<th scope="col">Cargo</th>
									<th scope="col">Centro de custo</th>
								</tr>
							</thead>
							<tbody id="tableBody">
			`;

			$holderSelectTable.append(card);

			let uniqueRoles = [...new Set(holders.map(holder => holder.role))];
			const combinedSelect = document.getElementById('filterRole');

			const roleOptgroup = document.createElement('optgroup');
			roleOptgroup.label = "Cargos";

			uniqueRoles.forEach(role => {
				const option = document.createElement('option');
				option.value = role;
				option.textContent = role;
				roleOptgroup.appendChild(option);
			});

			combinedSelect.appendChild(roleOptgroup);

			let tbody = $('#tableBody');

			if (holders.length > 0) {
				holders.forEach(holder => {
					if(holder.type == "titular"){
					let row = `
						<tr>
							<td>
								<input class="form-check-input checkbox-option" name="holderSelect" id="${holder.id}" type="checkbox" value="${holder.type + holder.id}" data-id="${holder.id}" data-type="${holder.type}">
							</td>
							<td>
								<label class="form-check-label ms-3 me-6" for="${holder.id}">${holder.name}</label>
							</td>
							<td>${holder.type}</td>
							<td>${holder.role}</td>
							<td>${holder.cost_center}</td>
						</tr>
					`;
					tbody.append(row);
					}
				});
			} else {
				tbody.append('<tr><td colspan="5">Colaborador não encontrado</td></tr>');
			}

			$holderSelectTable.append(`</tbody></table>`);
			let $cardBody = $('#cardBody');

			// Evento de mudança nas checkboxes
			$('input[name="holderSelect"]').on('change', function() {
				const selectedId = $(this).data('id');
				const selectedType = $(this).data('type');

				
				// Verificar se o checkbox está marcado
				if (this.checked) {
					// Encontra o holder selecionado e cria um acordeão para ele
					let selectedHolder = holders.find(holder => holder.id === selectedId);

					let accordion = makeAccordion({...selectedHolder, supplier_id: 2});
					
					// Adiciona o acordeão ao card body
					$cardBody.append(accordion);
				} else{
					// Remove o acordeão correspondente se desmarcado
					$(`#heading${selectedId}2${selectedType}undefined`).parent().remove();

				}
			});

			$holderSelectTable.append(`</div></div>`);
		}

		function dataTransferProductByContract(company_id) {

			const url = `{{ route('api.requests.dataProductByContract', [':company_id',':supplier_type_request_id']) }}`
				.replace(':company_id', company_id)
				.replace(':supplier_type_request_id', 2)

			return axios.get(url, {
				headers: {
					"Authorization": "Bearer {{ session('Authorization') }}"
				}
			});
		}

		function updateSelectedHolders(productTypeId, supplierId, holderId, contractId, productId, isChecked) {
			// Busca o item no array global com base no productTypeId e supplierId
			let productEntry = selectedHoldersTransfer.find(entry => 
				entry.product_type_id === productTypeId && 
				entry.supplier_id === supplierId &&
				entry.contract_id === contractId &&
				entry.product_id === productId
			);

			if (isChecked) {
				// Se o produto não existir, cria e adiciona ao array
				if (!productEntry) {
					productEntry = {
						product_type_id: productTypeId,
						supplier_id: supplierId,
						contract_id: contractId,
						product_id: productId,
						holder_by_contract: []
					};
					selectedHoldersTransfer.push(productEntry);
				}
				// Adiciona o holder com contract_id e product_id se não estiver presente
				if (!productEntry.holder_by_contract.some(holder => holder.holder_id === holderId)) {
					productEntry.holder_by_contract.push({
						holder_id: holderId,
					});
				}
			} else {
				// Remove o holder_id do array de seleção
				if (productEntry) {
					productEntry.holder_by_contract = productEntry.holder_by_contract.filter(
						holder => holder.holder_id !== holderId
					);
					// Remove a entrada de produto se não houver mais holders selecionados
					if (productEntry.holder_by_contract.length === 0) {
						selectedHoldersTransfer = selectedHoldersTransfer.filter(entry => entry !== productEntry);
					}
				}
			}
		}

		function createTableTransferProductByContract(company_id) {
			dataTransferProductByContract(company_id)
				.then(response => {
					console.log(response.data);
					if (response.data.length > 0) {
						const comboContainer = $("#comboList");
						comboContainer.empty();

						$.each(response.data, function (index, item) {
							const card = $(`
								<div class="card mb-3">
									<div class="card-body">
										<h5 class="card-title" data-product-id="${item.product_id}" data-contract-id="${item.contract_id}">
											${item.product_name} - Contrato: #${item.contract_id}
										</h5>
										<table class="table">
											<thead>
												<tr>
													<th>Selecionar</th>
													<th>Nome</th>
													<th>Tipo</th>
													<th>Cargo</th>
													<th>Centro de Custo</th>
												</tr>
											</thead>
											<tbody></tbody>
										</table>
										<div class="accordion" id="accordion-${index}"></div>
									</div>
								</div>
							`);

							const tableBody = card.find("tbody");
							const accordionContainer = card.find(`#accordion-${index}`);

							$.each(item.holders, function (_, holder) {
								const isPrechecked = item.holder_by_contract.some(hbc => hbc.holder_id === holder.id && hbc.product_id === item.product_id);
								
								const row = $(`
									<tr>
										<td><input type="checkbox" class="form-check-input checkbox-option" name="selectPerson${item.contract_id}" value="${holder.id}" data-type="titular" data-supplier-id="${item.supplier_id}" data-product-type-id="${item.product_type_id}" data-holder-id="${holder.id}" data-product-id="${item.product_id}" data-contract-id="${item.contract_id}" ${isPrechecked ? 'data-prechecked="true" checked' : ''}></td>
										<td>${holder.name}</td>
										<td>Titular</td>
										<td>${holder.role || 'N/A'}</td>
										<td>${holder.cost_center || 'N/A'}</td>
									</tr>
								`);
								tableBody.append(row);

								row.find(".checkbox-option").on("change", function () {
									const productTypeId = $(this).data("product-type-id");
									const supplierId = $(this).data("supplier-id");
									const holderId = $(this).data("holder-id");
									const contractId = $(this).data("contract-id");
									const productId = $(this).data("product-id");
									const isChecked = $(this).is(":checked");

									updateSelectedHolders(productTypeId, supplierId, holderId, contractId, productId, isChecked);

									const accordionId = `heading${holderId}${supplierId}titular${item.product_id}`;
									
									if (isChecked) {
										comboContainer.find(`.checkbox-option[data-holder-id="${holderId}"][data-product-type-id="${productTypeId}"][data-supplier-id="${supplierId}"]`).each(function () {
											if (this !== row.find(".checkbox-option")[0]) {
												$(this).prop("checked", false);
												accordionContainer.find(`#${accordionId}`).remove();
											}
										});

										const accordion = makeAccordion({ ...holder, supplier_id: item.supplier_id, type: 'titular', product_id: item.product_id });
										accordion.attr("id", accordionId);
										accordionContainer.append(accordion);
									} else {
										accordionContainer.find(`#${accordionId}`).remove();
									}
								});
							});

							comboContainer.append(card);
						});
					} else {
						const errorRow = $(`
							<div class="alert alert-warning" role="alert" style="padding: 1rem; text-align: center;">
								Não foi localizado nenhum beneficiário
							</div>
						`);
						$("#comboList").append(errorRow);
					}
				})
				.catch(error => {
					console.error("Erro ao buscar dados de exclusão:", error);
					const errorRow = $(`
						<div class="alert-warning">
							Erro ao carregar os dados
						</div>
					`);
					$("#comboList").append(errorRow);
				});
		}

		async function dataTransferProductBySupplier(supplier_id) {
			console.log(supplier_id)
			const url = `{{ route('api.products.dataProductBySupplier', [':supplier_id']) }}`
				.replace(':supplier_id', supplier_id)

			axios.get(url, {
				headers: {
					"Authorization": "Bearer {{ session('Authorization') }}"
				}
			}).then(response => {
				
				produtos = response.data;
				console.log(produtos);

			})
			.catch(error => {

				console.error('Error:', error);

			});
		}


		// END FUNCTION

		// FUNCTION FOR UPGRADE DOWNGRADE

		function dataUpgradeDowngrade(company_id) {

			const url = `{{ route('api.requests.dataUpgradeDowngrade', [':company_id',':supplier_type_request_id']) }}`
				.replace(':company_id', company_id)
				.replace(':supplier_type_request_id', 2)

			return axios.get(url, {
				headers: {
					"Authorization": "Bearer {{ session('Authorization') }}"
				}
			});
		}

		function createTableUpgradeDowngrade(company_id) {
			dataUpgradeDowngrade(company_id)
				.then(response => {
					console.log(response.data);
					if (response.data.length > 0) {
						const comboContainer = $("#comboList");
						comboContainer.empty();

						$.each(response.data, function (index, item) {
							const card = $(`
								<div class="card mb-3">
									<div class="card-body">
										<h5 class="card-title" data-product-id="${item.product_id}" data-contract-id="${item.contract_id}">
											${item.product_name} - Contrato: #${item.contract_id}
										</h5>
										<table class="table">
											<thead>
												<tr>
													<th>Selecionar</th>
													<th>Nome</th>
													<th>Tipo</th>
													<th>Cargo</th>
													<th>Centro de Custo</th>
												</tr>
											</thead>
											<tbody></tbody>
										</table>
										<div class="accordion" id="accordion-${index}"></div>
									</div>
								</div>
							`);

							const tableBody = card.find("tbody");
							const accordionContainer = card.find(`#accordion-${index}`);

							$.each(item.holders, function (_, holder) {
								const isPrechecked = item.holder_by_contract.some(hbc => hbc.holder_id === holder.id && hbc.product_id === item.product_id);
								
								const row = $(`
									<tr>
										<td><input type="checkbox" class="form-check-input checkbox-option" name="selectPerson${item.contract_id}" value="${holder.id}" data-type="titular" data-supplier-id="${item.supplier_id}" data-product-type-id="${item.product_type_id}" data-holder-id="${holder.id}" data-product-id="${item.product_id}" data-contract-id="${item.contract_id}" ${isPrechecked ? 'data-prechecked="true" checked' : ''}></td>
										<td>${holder.name}</td>
										<td>Titular</td>
										<td>${holder.role || 'N/A'}</td>
										<td>${holder.cost_center || 'N/A'}</td>
									</tr>
								`);
								tableBody.append(row);

								row.find(".checkbox-option").on("change", function () {
									const productTypeId = $(this).data("product-type-id");
									const supplierId = $(this).data("supplier-id");
									const holderId = $(this).data("holder-id");
									const contractId = $(this).data("contract-id");
									const productId = $(this).data("product-id");
									const isChecked = $(this).is(":checked");

									updateSelectedHolders(productTypeId, supplierId, holderId, contractId, productId, isChecked);

									const accordionId = `heading${holderId}${supplierId}titular${item.product_id}`;
									
									if (isChecked) {
										comboContainer.find(`.checkbox-option[data-holder-id="${holderId}"][data-product-type-id="${productTypeId}"][data-supplier-id="${supplierId}"]`).each(function () {
											if (this !== row.find(".checkbox-option")[0]) {
												$(this).prop("checked", false);
												accordionContainer.find(`#${accordionId}`).remove();
											}
										});

										const accordion = makeAccordion({ ...holder, supplier_id: item.supplier_id, type: 'titular', product_id: item.product_id });
										accordion.attr("id", accordionId);
										accordionContainer.append(accordion);
									} else {
										accordionContainer.find(`#${accordionId}`).remove();
									}
								});
							});

							comboContainer.append(card);
						});
					} else {
						const errorRow = $(`
							<div class="alert alert-warning" role="alert" style="padding: 1rem; text-align: center;">
								Não foi localizado nenhum beneficiário
							</div>
						`);
						$("#comboList").append(errorRow);
					}
				})
				.catch(error => {
					console.error("Erro ao buscar dados de exclusão:", error);
					const errorRow = $(`
						<div class="alert-warning">
							Erro ao carregar os dados
						</div>
					`);
					$("#comboList").append(errorRow);
				});
		}

		// END FUNCTION

		// FUNCTION FOR EXCEPTION

			async function dataException(company_id, product_id) {

				const url = `{{ route('api.holders.companyException', [':company_id', ':product_id']) }}`
					.replace(':company_id', company_id)
					.replace(':product_id', product_id);


				await axios.get(url, {
					headers: {
						"Authorization": "Bearer {{ session('Authorization') }}"
					}
				}).then(response => {
					
					holdersChange = response.data;

				})
				.catch(error => {

					console.error('Error:', error);

				});
			}

			function createTableException(dataHolders) {
				let holders = dataHolders;

				let $holderSelectTable = $('#comboList');

				$holderSelectTable.empty();
				let requests_type_id = $('#requests_type_id').val();
				let title = '';
				switch (requests_type_id){
					case 7:
					case 8:
					case 9:
					case 10:
					case 11:
					title = 'Colaboradores';
					break;
					default:
						title = 'Colaboradores';
						break;
				}

				let card = `
					<div class="card">
						<div class="card-header">
							<h5 class="mb-0">${title}</h5>
						</div>
						<div class="card-body" id="cardBody">
							<div class="row mb-3">
								<div class="col-md-6">
									<input class="form-control mt-2" type="text" id="filterName" placeholder="Buscar por nome" oninput="filterTable()">
								</div>
								<div class="col-md-6">
									<select class="form-control mt-2" id="filterRole" onchange="filterTable()">
										<option value="" selected>Selecione cargo</option>
									</select>
								</div>
							</div>
							<table class="table">
								<thead style="position: sticky; top: 0; z-index: 1;">
									<tr>
										<th scope="col">Selecionar</th>
										<th scope="col">Nome</th>
										<th scope="col">Tipo</th>
										<th scope="col">Cargo</th>
										<th scope="col">Centro de custo</th>
									</tr>
								</thead>
								<tbody id="tableBody">
				`;

				$holderSelectTable.append(card);

				let uniqueRoles = [...new Set(holders.map(holder => holder.role))];
				const combinedSelect = document.getElementById('filterRole');

				const roleOptgroup = document.createElement('optgroup');
				roleOptgroup.label = "Cargos";

				uniqueRoles.forEach(role => {
					const option = document.createElement('option');
					option.value = role;
					option.textContent = role;
					roleOptgroup.appendChild(option);
				});

				combinedSelect.appendChild(roleOptgroup);

				let tbody = $('#tableBody');

				if (holders.length > 0) {
					holders.forEach(holder => {
						let row = `
							<tr>
								<td>
									<input class="form-check-input checkbox-option" name="holderSelect" id="${holder.id}" type="checkbox" value="${holder.type + holder.id}" data-id="${holder.id}" data-type="${holder.type}">
								</td>
								<td>
									<label class="form-check-label ms-3 me-6" for="${holder.id}">${holder.name}</label>
								</td>
								<td>${holder.type}</td>
								<td>${holder.role}</td>
								<td>${holder.cost_center}</td>
							</tr>
						`;
						tbody.append(row);
					});
				} else {
					tbody.append('<tr><td colspan="5">Colaborador não encontrado</td></tr>');
				}

				$holderSelectTable.append(`</tbody></table>`);

				let $cardBody = $('#cardBody');

				$('input[name="holderSelect"]').on('change', function() {

					holderData = [];

					const selectedId = $(this).data('id');
					const selectedType = $(this).data('type');
			
					let selectedHolder = holders.find(holder => holder.id === selectedId);
					let accordion = makeAccordion({...selectedHolder, supplier_id: 2});
					$cardBody.append(accordion);

				});

				$holderSelectTable.append(`</div></div>`);
			}

		// END FUNCTION

	});

	$('#modalHolder').on('shown.bs.modal', function () {
		
		let holder_cpf = $("#modalHolder #cpf");
		let holder_zip = $("#modalHolder #zip_code");
		let holder_phone = $("#modalHolder #personal_phone");
		
		holder_cpf.unmask();
		holder_zip.unmask();
		holder_phone.unmask();
		
		holder_cpf.mask('000.000.000-00');
		holder_zip.mask('00000-000');
		holder_phone.mask('(00) 0 0000-0000');

	});

	$('#modalDependent').on('shown.bs.modal', function () {
		
		let dependent_cpf = $("#modalDependent #cpf");
		let dependent_zip = $("#modalDependent #zip_code");
		let dependent_phone = $("#modalDependent #personal_phone");
		
		dependent_cpf.unmask();
		holder_zip.unmask();
		dependent_phone.unmask();
		
		dependent_cpf.mask('000.000.000-00');
		holder_zip.mask('00000-000');
		dependent_phone.mask('(00) 0 0000-0000');

	});
</script>
@endsection