Index: schedule/Transaction/update.php
===================================================================
--- schedule/Transaction/update.php	(revision 16740)
+++ schedule/Transaction/update.php	(revision 16894)
@@ -1,31 +1,22 @@
+
 <?php
+//Build by: khristofer Usman
+//Modified by: Jaypee Tanio
+// June 22,2013
 include '../include/factdb.php';
-
-
-
- $Time =$_GET['Time'];
- $SelectedSource = $_GET['Source'];
- $Date = $_GET['Date'];
-  
- $SelectedMeasure = $_GET['measure'];
-$TimeEX = explode("-",$Date);
-
-$TimeEX2 = "day=".$TimeEX[0]."&month=".$TimeEX[1]."&year=".$TimeEX[2];
- $limtex = count(explode(",",$SelectedSource));
-$insertdate = $TimeEX[2]."-".$TimeEX[1]."-".$TimeEx[0];
-$value = $_GET['Data'];
-$date = $_GET['Date'];
-//$date = new DateTime($_GET['Date']);
+$Time =$_POST['Time'];
+$SelectedSource = $_POST['Source'];
+$SelectedMeasure = $_POST['measure'];
+$limtex = count(explode(",",$SelectedSource));
+$Upd=$_POST['upd'];
+$Upt=$_POST['upt'];
+$value = $_POST['Data'];
+$date = $_POST['Date'];
 $n_value = explode(",",$value);
-echo "<br />";
-//echo $date->format('Y-m-d H:i:s');
-//fdgdfgdf
- $Times = explode(",",$Time);
+$Times = explode(",",$Time);
 $select = explode(",",$SelectedSource);
 $measure = explode(",",$SelectedMeasure);
-echo "<br />";
-$temp = "";
-$insert_count = 0;
-	
+//date_default_timezone_set('Asia/Manila'); // Setting up the localTimeZone in asia
+$UpdateDate=(date('Y-m-d H:i:s'));
 
 
@@ -34,69 +25,30 @@
 			$fetch = mysql_query("SELECT * FROM schedule") or die(mysql_error());
 					
-					while($rows = mysql_fetch_array($fetch)){
-					$timestamp=strtotime($rows['fLastUpdate']);
+					while($rows = mysql_fetch_array($fetch))
+					{
+					$timestamp=strtotime($rows['fStart']);
 					$timestamp2 = date('Y-m-d',$timestamp);
 					$date_time = date('H:i',$timestamp);
 					//$time_new = $date_time->format('H:i:s')
-					if($days == $timestamp2){
+						if($days == $timestamp2)
+						{
 
-					$delete = mysql_query("DELETE FROM `schedule` WHERE `fLastUpdate`='{$rows['fLastUpdate']}'");
+						$delete = mysql_query("DELETE FROM `schedule` WHERE `fStart`='{$rows['fStart']}'");
 			
-					}
+						}
 					}
 					
-					
-					
-					
-					
-					
 
-for($i=0;$i<=$limtex-1;$i++){
+for($i=0;$i<=$limtex;$i++)
+{
 $select = explode(",",$SelectedSource);
-						$n1 = $n_value[$i];
-						
-					 $selectf = $select[$i];
-				//////Time////
-				//$Timef = $Time[$i];
-						
-				//////// for measurement /////////
-						
-						$measuref = $measure[$i];
-
-				//////// Date parsing into format////////
-						$dateTime=new DateTime($date." ".$Times[$i]);
-						 $parsed_date =  $dateTime->format('Y-m-d H:i:s');
-						$new = 0;
-					
-			$select = mysql_query("SELECT * FROM schedule WHERE fLastUpdate = '$parsed_date'");
-			if($select){
-			while($row = mysql_fetch_array($select)){
-		
-				
-				$new =   $row['fMeasurementID'] + 1 ;
-				
+	$n1 = $n_value[$i];		
+	$selectf = $select[$i];	
+	$measuref = $measure[$i];
+	$dateTime=new DateTime($date." ".$Times[$i]);
+	$parsed_date =  $dateTime->format('Y-m-d H:i:s');
+	
+		mysql_query("INSERT INTO schedule VALUES('null','".$parsed_date."','".$UpdateDate."','".$measuref."','','".$n1."','".$selectf."','".$measuref."')");	
 			
-			
-			}
-				}else{
-				
-				$new = 0;
-				
-				}	
-			
-		$insert = mysql_query("INSERT IGNORE INTO schedule values('','$parsed_date','$parsed_date','$new','','$n1','$selectf','$measuref')") or die(mysql_error());
-					
-}
- if($insert){
-	
-				?>
-				<script type="text/javascript">
-				   
-					alert("Sucessfully save");
-					window.location = '../index.php?days=<?php echo $date; ?>';
-				</script>
-				<?php
-	
-	}
-	
+}	
 ?>