source: schedule/js/function.js@ 16932

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

function GetDate()
{
        $('#save').click(function(){
                var Time = [];
                var Data = [];
                var Source = [];
                var Measure = [];
                var Table = [];
                $('#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,Table); // Function call of saving the data
                alert(Table);
        });     
};


function GetSaveData(Time,Data,Source,Measure,Table){
        var checks=0;
        TimeSave = [];
        DataSave = [];
        SourceSave = [];
        MeasureSave = [];
        for(i=0;i<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!");
                }
        
        }
        
};