Changeset 16894 for schedule/Transaction/update.php

Timestamp:

06/23/13 09:54:35 (12 years ago)

Author:

tanio

Message:

 

File:

• schedule/Transaction/update.php (modified) (2 diffs)

schedule/Transaction/update.php

@@ +1 @@
+
 <?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 +25 @@
                         $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
-        
-        }
-        
+}       
 ?>