function checkOpnamelijstStatus(studentid,link,link2)
{
	//Zetten van het tudent id
	var data =  'action=balieCheckStudent&stnr=' + studentid;
	
	//Ophalen van het result
	jQuery.ajax(
	{
		url: 'Handler.php',
		type: 'POST',
		dataType: 'json',
		data: data,
		success: function(response)
		{
			if (response)
			{
				if (response.data.user_pitch_status == 1)
				{
					window.location.href = link + link2;
				}
				
				else
				{
					$('#user_error').slideDown();
					timeout = setTimeout(function()
					{
						window.location.href = link;
					}, 4000);
					return false;
				}
			}
		}
	});
}

var timeout = null;

function ajax_search()
{
	//Legen van de timeout
	if (timeout) clearTimeout(timeout);
	
	//Zeten van de timeout
	timeout = setTimeout(function()
	{
		//Weghalen van het huidige resultaat
		$("#ls_results").slideUp(); //Hide results DIV
		
		var data	= 'action=balieSearchStudent';
		data 		+= '&stnr=' 		+ $("#ls_stnr").val();
		data 		+= '&naam=' 		+ $("#ls_naam").val();
		data 		+= '&opnamedag='	+ $("#ls_opnamedag").val();
		data 		+= '&lijst=' 		+ $("#ls_lijst").val();
		data 		+= '&limit=' 		+ $("#ls_limit").val();
		data 		+= '&pool=' 		+ $("#ls_pool").val();
		if ($("#ls_actiecode").is(':checked'))
		{
			data 		+= '&actiecode=1';
		}
		
		jQuery.ajax(
		{
			url: 'Handler.php',
			type: 'POST',
			dataType: 'json',
			data: data,
			success: function(response)
			{
				if (response)
				{
					var pool = $("#ls_pool").val();
					if(pool==undefined || pool=="alle") {
						$("#ls_results").html(result_table(response)).slideDown();
						
					} else {
						$("#ls_results").html(result_pool_table(response)).slideDown();
						
					}
					$("#ls_results table").tablesorter({widgets: ['zebra']});
				}
			}
		});
	}, 500);
}

function result_table(jsondata)
{
	//Ophalen van het aantal items
	var aantal = jsondata.length;
	var size = Object.size(jsondata);
	//Legen van resultaat
	var table = '';
	
	//Controleren of er data is
	if (aantal == 0)
	{
		return '<b>No results</b>';
	}
	else
	{
		//Opbouwen van tabelheader
		table = '('+size+')';
		table += '<table summary="pitchlijst" class="tablesorter">';
		table += '<thead><tr>';
		table += '<th>St. nr.</th>';
		table += '<th>Voornaam</th>';
		table += '<th>Achternaam</th>';
		table += '<th>Actiecode</th>';
		table += '<th>K</th>';
		table += '<th>Pers.</th>';
		table += '<th>IQ</th>';
		table += '<th>Movie</th>';
		table += '<th>Head</th>';
		table += '<th>Actief</th>';
		table += '<th>Online</th>';
		table += '<th>Opties</th>';
		table += '<th>&nbsp;&nbsp;</th>';
		table += '</tr><thead><tbody>';
		
		//Opbouwen van de tabel regels
		for (i in jsondata)
		{
			//Opbouwen van het record
			table += '<tr>';
			table += '<td>' + jsondata[i].user_id + '</td>';
			table += '<td>' + jsondata[i].user_voornaam + '</td>';
			table += '<td>' + jsondata[i].user_achternaam + '</td>';
			table += '<td>' + jsondata[i].user_actiecode + '</td>';
			table += '<td align="center"><img src="' + jsondata[i].kleur_img + '" alt="Kleur" title="Kleur" /></td>';			
			table += '<td align="center"><img src="' + jsondata[i].ph_img + '" alt="Persoonlijkheidstest" title="Persoonlijkheidstest" /></td>';			
			table += '<td align="center"><img src="' + jsondata[i].iq_img + '" alt="IQ test" title="IQ test" /></td>';
			table += '<td align="center"><img src="' + jsondata[i].movie_img + '" alt="Pitch" title="Pitch" /></td>';
			table += '<td align="center"><img src="' + jsondata[i].headshot_img + '" alt="Headshot" title="Headshot" /></td>';
			table += '<td align="center"><img src="' + jsondata[i].active + '" alt="Profiel activerings status" title="Profile geactiveerd?" /></td>';
			table += '<td align="center"><img src="' + jsondata[i].online + '" alt="Online" title="Online?" /></td>';
			table += '<td>' + jsondata[i].buttons + '</td>';
			table += '<td><a href="balie/studentenoverzicht/studentprofiel/st/' + jsondata[i].user_id + '/">bekijk profiel</a></td>';
			table += '</tr>';
		}
		
		//Afsluiten van de tabel
		table += '</tbody></table>';
		
		//Return van de tabel
		return table;
	}
}


$(document).ready(function()
{
	if($("#ls_results table").length != 0)
	{
		$("#ls_results table").tablesorter({widgets: ['zebra']});
	} 

	if($("#ls_results1 table").length != 0)
	{
		$("#ls_results1 table").tablesorter({widgets: ['zebra']});
	} 

	if($("#ls_results2 table").length != 0)
	{
		$("#ls_results2 table").tablesorter({widgets: ['zebra']});
	} 
	

	if($("#ls_submit").length != 0)
	{
		//Zoeken
		ajax_search();
		
		//Studentstock nr
		$("#ls_stnr").keyup(function(e)
		{
			e.preventDefault();
			ajax_search();
		});
		
		//Naam
		$("#ls_naam").keyup(function(e)
		{
			e.preventDefault();
			ajax_search();
		});
		
		
		//Pool
		$("#ls_pool").change(function(e)
		{
			e.preventDefault();
			ajax_search();
		});
		
		
		//Opnamedag
		$("#ls_opnamedag").change(function(e)
		{
			e.preventDefault();
			ajax_search();
		});

		//lijst
		$("#ls_lijst").change(function(e)
		{
			e.preventDefault();
			ajax_search();
		});
		
		//limit
		$("#ls_limit").change(function(e)
		{
			e.preventDefault();
			ajax_search();
		});
		
		//lijst
		$("#ls_actiecode").change(function(e)
		{
			e.preventDefault();
			ajax_search();
		});
	
		//Submit
		$("#ls_submit").click(function(e)
		{
			e.preventDefault();
			ajax_search();
		});
	}
	
	/*if (tplName == 'section/balie/studentprofiel.html')
	{
		$('#profiel_datum_online').datePicker({clickInput:true,startDate:'01-01-2008'});
		$('#user_geboortedatum').datePicker({clickInput:true,startDate:'01-01-1971'});
		$('#user_date_1').datePicker({clickInput:true,startDate:'01-01-2009'});
		$('#user_date_2').datePicker({clickInput:true,startDate:'01-01-2009'});
	}
	*/

	$("#user_geboortedatum").change(function(){
		
		var value = $("#user_geboortedatum").val();
		var userid = $("#userId").val();
		
		$.get("update.php", { fieldname: "user_geboortedatum", content: value, studentId: userid } );
	});

	$("#verwijderOpleiding").click(function(event) {
		event.preventDefault();
		var userid = $("#userId").val();
		$.get("update.php", { fieldname: "user_opleidingv", studentId: userid } );
	});
	
	$("#verwijderAfstudeerStage").click(function(event) {
		event.preventDefault();
		var userid = $("#userId").val();
        $("#user_date_1").val("(Leeg)");
		$.get("update.php", { fieldname: "user_date_1v", studentId: userid } );
	});
	
	$("#verwijderBeschikbaar").click(function(event) {
		event.preventDefault();
		var userid = $("#userId").val();
        $("#user_date_2").val("(Leeg)");
		$.get("update.php", { fieldname: "user_date_2v", studentId: userid } );
	});
		
			
	$("#user_date_1").change(function(){
		
		var value = $("#user_date_1").val();
		var userid = $("#userId").val();
		
		$.get("update.php", { fieldname: "user_date_1", content: value, studentId: userid } );
	});

	$("#user_date_2").change(function(){
		
		var value = $("#user_date_2").val();
		var userid = $("#userId").val();
		
		$.get("update.php", { fieldname: "user_date_2", content: value, studentId: userid } );
	});
	
	$('.wachtwoord input').val('');
	$('.wachtwoord_herhalen input').val('');

	$('.change_password_link').toggle(function(){
		$('.wachtwoord').css({
			'height': ''
		}).stop().slideDown();
		$(this).text(wachtwoordNietWijzigen);
	}, function(){
		$('.wachtwoord').stop().slideUp('fast', function(){
			$('.wachtwoord input').val('');
			$('.wachtwoord_herhalen input').val('');
		});
		$(this).text(wachtwoordWijzigen);
	});	
	
	
	
	
});

Object.size = function(obj) {
    var size = 0, key;
    for (key in obj) {
        if (obj.hasOwnProperty(key)) size++;
    }
    return size;
};

function result_pool_table(jsondata)
{
    //Ophalen van het aantal items
    var aantal = jsondata.length;
    var size = Object.size(jsondata);
    
    //Legen van resultaat
    var table = '';
    
    //Controleren of er data is
    if (aantal == 0)
    {
        return '<b>No results</b>';
    }
    else
    {
        //Opbouwen van tabelheader
        table = '('+size+')';
        table += '<table summary="pitchlijst" class="tablesorter">';
        table += '<thead><tr>';
        table += '<th>St. nr.</th>';
        table += '<th>Headshot</th>';
        table += '<th>Bachelor</th>';
        table += '<th>Master</th>';
        table += '<th>Profile</th>';
        table += '</tr><thead><tbody>';
        
        //Opbouwen van de tabel regels
        for (i in jsondata)
        {
            console.log(jsondata[i].pasfoto); 
            //Opbouwen van het record
            table += '<tr>';
            table += '<td>' + jsondata[i].user_id + '</td>';
            table += '<td><p class="thumb"><a><img src="image/'+ jsondata[i].pasfoto +'/thumb_balie.jpg" alt="" class="view_headshot_v2"/></a></p>';
            
            
            //table += '<td>'+ jsondata[i].headshot +'</td>';
            table += '<td>' + jsondata[i].opleiding + '</td>';
            table += '<td>' + jsondata[i].master + '</td>';
            table += '<td><a target="_blank" href="http://www.studentstock.nl/nl/profiel_zoeken/profiel/' + jsondata[i].user_id + '/">View</a></td>';
            table += '</tr>';
        }
        
        //Afsluiten van de tabel
        table += '</tbody></table>';
        
        //Return van de tabel
        return table;
    }
}