| 1 | 'use strict';
|
|---|
| 2 | /**
|
|---|
| 3 | Created by: Jaypee Tanio
|
|---|
| 4 | Date Created: Jun 16, 2013
|
|---|
| 5 | Modified by: Ella Tose
|
|---|
| 6 | Last Modified: Feb 14, 2014
|
|---|
| 7 | */
|
|---|
| 8 |
|
|---|
| 9 |
|
|---|
| 10 | var currentDate;
|
|---|
| 11 |
|
|---|
| 12 | function GetDate(d,m,y)
|
|---|
| 13 | {
|
|---|
| 14 | currentDate = y+'-'+m+'-'+d;
|
|---|
| 15 | };
|
|---|
| 16 |
|
|---|
| 17 | $('document').ready(function() {
|
|---|
| 18 |
|
|---|
| 19 | /*---------------------------------------------------------------------------------------------
|
|---|
| 20 | Loading of previous data. Get the previous date with existing data through PreviousData.php
|
|---|
| 21 | Same Shedule.ph passed to load on the controls with extra parameter 'prev' to indicate that
|
|---|
| 22 | data is from previous schedule.
|
|---|
| 23 | ----------------------------------------------------------------------------------------------*/
|
|---|
| 24 |
|
|---|
| 25 | $('#LoadPrev').click(function() {
|
|---|
| 26 | $.ajax({
|
|---|
| 27 | type:"POST",
|
|---|
| 28 | cache: false,
|
|---|
| 29 | url: "Transaction/PreviousData.php",
|
|---|
| 30 | data: "SelectedDay="+currentDate,
|
|---|
| 31 | success: function(data) {
|
|---|
| 32 | var obj = $.parseJSON(data);
|
|---|
| 33 | $('#Scheduling').load('Module/Scheduling.php?days='+obj+'&prev=true');
|
|---|
| 34 | }
|
|---|
| 35 | });
|
|---|
| 36 | });
|
|---|
| 37 |
|
|---|
| 38 | /*---------------------------------------------------------------------------------------------
|
|---|
| 39 | Savng and updating of schedule. Data array is generated from the current table to be submitted
|
|---|
| 40 | to saveSchedule.php for the execution of queries.
|
|---|
| 41 | ----------------------------------------------------------------------------------------------*/
|
|---|
| 42 |
|
|---|
| 43 | $('#save').click(function(){
|
|---|
| 44 | var Gdate = currentDate;
|
|---|
| 45 | var data = new Array();
|
|---|
| 46 | var count = 0;
|
|---|
| 47 | $('.datalisting').each(function() {
|
|---|
| 48 | var get_seq = 0;
|
|---|
| 49 | var get_time = $(this).find(".time").val();
|
|---|
| 50 | var countchild = $(this).find(".tr").length;
|
|---|
| 51 | data[count] = new Array();
|
|---|
| 52 | $(this).find(".tr").each(function() {
|
|---|
| 53 | var get_measure = $(this).find(".measure").val();
|
|---|
| 54 | var get_source = $(this).find(".source").val();
|
|---|
| 55 | var get_selected = $(this).find(".selected").val();
|
|---|
| 56 | if(get_source != null && get_source != null && get_selected != null) {
|
|---|
| 57 | data[count][get_seq] = new Array();
|
|---|
| 58 | data[count][get_seq].push(get_time);
|
|---|
| 59 | data[count][get_seq].push(get_seq);
|
|---|
| 60 | data[count][get_seq].push(get_selected);
|
|---|
| 61 | data[count][get_seq].push(get_source);
|
|---|
| 62 | data[count][get_seq].push(get_measure);
|
|---|
| 63 | get_seq++;
|
|---|
| 64 | }
|
|---|
| 65 | });
|
|---|
| 66 | if(get_time != null) {
|
|---|
| 67 | count++;
|
|---|
| 68 | }
|
|---|
| 69 | });
|
|---|
| 70 | if($('#save').val()=='SAVE')
|
|---|
| 71 | {
|
|---|
| 72 | SaveData(data, Gdate, "save");
|
|---|
| 73 | }
|
|---|
| 74 | else {
|
|---|
| 75 | SaveData(data, Gdate, "update");
|
|---|
| 76 | }
|
|---|
| 77 | });
|
|---|
| 78 | });
|
|---|
| 79 |
|
|---|
| 80 | function SaveData(data, date, trans) {
|
|---|
| 81 | $.ajax({
|
|---|
| 82 | type:"POST",
|
|---|
| 83 | cache: false,
|
|---|
| 84 | url: "Transaction/saveSchedule.php",
|
|---|
| 85 | data: "Data="+JSON.stringify(data)+"&Date="+date,
|
|---|
| 86 | success: function(result) {
|
|---|
| 87 | if(trans == "save") {
|
|---|
| 88 | alert("New schedule successfully saved.");
|
|---|
| 89 | } else {
|
|---|
| 90 | alert("Schedule successfully updated.");
|
|---|
| 91 | }
|
|---|
| 92 | }
|
|---|
| 93 | });
|
|---|
| 94 | };
|
|---|