// This module prepare by : Jaypee Tanio
// June 16, 2013

function GetDate()
{
	$('#save').click(function(){
		Time = [];
		Data = [];
		Source = [];
		Measure = [];
		Table = [];
		$('div#TableHolder table').each(function(){ // call all the id of the table inside div#TableHolder
			id=$(this).attr('id'); //Getting all id's
			Time.push('#'+id+' input#Time'); // Storing id's of each element
			Data.push('#'+id+' input#txtData'); 
			Source.push('#'+id+' select#source :selected');
			Measure.push('#'+id+' select#measurement :selected');
			Table.push(id);
		});
		GetSaveData(Time,Data,Source,Measure); // Function call of saving the data
	});
	
};


function GetSaveData(Time,Data,Source,Measure){
	var checks=0;
	TimeSave = [];
	DataSave = [];
	SourceSave = [];
	MeasureSave = [];
	for(i=0;i<$('div#TableHolder table').length;i++)
	{
		$(Time[i]).each(function(){
			TimeSave.push($(this).val()); // extracting each data into a value
		});
		$(Data[i]).each(function(){
			DataSave.push($(this).val()); // extracting each data into a value
		});
		$(Source[i]).each(function(){
			SourceSave.push($(this).val()); // extracting each data into a value 
		});
		$(Measure[i]).each(function(){
			MeasureSave.push($(this).val()); // extracting each data into a value
		});
	}
	if($('#save').val()=='UPDATE')
	{
		if(checks == 0)
		{
			$.ajax({
				type: "POST",
				cache: false,
				url: "Transaction/update.php",
				data: "Time="+TimeSave+'&Source='+SourceSave+'&measure='+MeasureSave+'&Data='+DataSave+'&Date='+year+'-'+month+'-'+day, //posting the data to save
				success: function(data) {
					
						alert('Successfully Updated ! '+year+'-'+month+'-'+day);
					
				}
			});
		}
		else
		{

		alert("Please fill all the details!");
		}
	}
	else
	{
		if(checks == 0)
		{
			$.ajax({
				type: "POST",
				cache: false,
				url: "Transaction/insert.php",
				data: "Time="+TimeSave+'&Source='+SourceSave+'&measure='+MeasureSave+'&Data='+DataSave+'&Date='+year+'-'+month+'-'+day, //posting the data to save
				success: function(data) {
					
						alert('Successfully added ! '+year+'-'+month+'-'+day);
					
				}
			});
		}
		else
		{

		alert("Please fill all the details!");
		}
	
	}
	
};