//table managment


function btnCancelCreateTable()
{
		document.location.href='index.php' +queryStringWithout();
}
function btnFilterSearchResult()
{	
	if ($(event.target).closest('#bootBoxAdminBody').length)
    	updDivFormPost('#bootBoxAdminBody', $('#frmSearch').attr('action'),'#frmSearch');
    else
		$('#frmSearch').submit()
}

function btnCogTable()
{
	var target = event.target;
	if($(target).attr('sDatabaseId')==undefined)
		target = $(target).parent();
	//console.log($(target).attr('sDatabaseId'));
	//console.log($(target).attr('sTableId'));	
	bootBoxAdmin( decodeQueryParam( $(target).attr('sTableName')),'/table/?bModal=1&sId=' + $(target).attr('sTableId')+ '&sDatabaseId=' + $(target).attr('sDatabaseId'),'history.go(0)')
}

function btnModalBackToTable()
{
	var target = event.target;
	 updDiv('#bootBoxAdminBody', '/table/?bModal=1&sId=' + $(target).attr('sTableId')+  '&sDatabaseId=' + $(target).attr('sDatabaseId'));
	
}

function btnGoTable()
{
	document.location.href='/table/' + queryStringWithout()
}
function btnTrImportData()
{
	var sErr='';
	if($('#importDataFile').val()=='')
		sErr+='%%fileIsMandatory%%';
	if(sErr!='')
		bootbox.alert(sErr)
	else
		$('#frmImportData').submit()
}
function btnCreateTable()
{
	$('.dCreateTable').toggle();
}

function btnTrCreateTable()
{
	var sErr='';
	if($('#TBL_CH_LABEL').val()=='')
		sErr += '%%tableLabelIsMandatory%%<br/>';
		
	if(sErr!='')
		bootbox.alert(sErr)
	else
		$('#frmCreateTable').submit()
}



function orderTable(sDatabaseId)
{
	$("#tTable").tableDnD({
		dragHandle: '.dragHandle',
		onDragClass: 'bg-success',
		onDrop: function(table, row) {

			var sId = row.id;

			for (var j=0; j<table.tBodies.length; j++)
			{
				var rows = table.tBodies[j].rows;
				for (var i=0; i<rows.length; i++)
				{
					if (row.id == rows[i].id)
					{
						var nOrder = (i+1);
						updDiv('#dummy','/table/trOrderTable.php?sDatabaseId=' + sDatabaseId+ '&sId=' + sId + '&nOrder=' + nOrder );
					}
				}
			}
		},
	});

}

function btnTable()
{
	document.location.href = '/table/?sId=' +  $(event.target).attr('sid') + '&sDatabaseId=' +  $(event.target).attr('sdatabaseid') 
}

function btnAdminTable () {
  $('.dAdminTable').toggle();
  const el = document.getElementById('dMainAdminTable');
  if (!el) return;
  // attendre la MAJ du layout après le toggle
  requestAnimationFrame(() => {
    el.scrollIntoView({ behavior: 'smooth', block: 'start' });
  });
}

function btnDeleteTable()
{
	var target = event.target;
	if($(target).attr('path')==undefined)
		target = $(target).parent();
	const nRows = parseInt($(target).attr('nRows') || '0', 10);
	const tConfirm = ($(target).attr('data-confirm') || 'Confirmer la suppression de cette table ?');
	const tRows = ($(target).attr('data-rows-label') || 'Nombre de lignes actives liées');
	const tWarn = ($(target).attr('data-warning') || 'Le contenu lié sera aussi supprimé.');
	const sMsg = tConfirm + '<br/><br/>' + tRows + ': ' + nRows + '<br/>' + tWarn;
	bootbox.confirm(sMsg, function(result) {
		if (result===true) {
			document.location.href='/table/trSupTable.php?' + $(target).attr('path');
		}
	});
}

function btnTrUpdateTable()
{
	var sErr='';
	if($('#TBL_CH_LABEL').val()=='')
		sErr += '%%tableLabelIsMandatory%%<br/>';
		
	if(sErr!='')
		bootbox.alert(sErr)
	else
		$('#frmUpdateTable').submit()
}