Changeset 16894 for schedule/Transaction/insert.php

Timestamp:

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

Author:

tanio

Message:

 

File:

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

schedule/Transaction/insert.php

@@ -1 +1 @@
 <?php
+//Build by: khristofer Usman
+//Modified by: Jaypee Tanio
+// June 14,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'];
+ $Date = $_POST['Date'];
+ echo $Date;
+ $SelectedMeasure = $_POST['measure'];
+$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);
+$limtex = count(explode(",",$SelectedMeasure));
 echo "<br />";
-$temp = "";
-$insert_count = 0;
-        
-
-
-
-
-                                                
-                                
-        
-                                        
-
-for($i=0;$i<=$limtex-1;$i++){
+for($i=0;$i<=$limtex-1;$i++)
+{
 $select = explode(",",$SelectedSource);
-                                                $n1 = $n_value[$i];
-                                                
-                                         $selectf = $select[$i];
-                                //////Time////
-                                //$Timef = $Time[$i];
-                                                
-                                //////// for measurement /////////
-                                                
+                                        $n1 = $n_value[$i];
+                                        $selectf = $select[$i];
+                                //////// for measurement /////////      
                                                 $measuref = $measure[$i];
-
                                 //////// Date parsing into format////////
                                                 $dateTime=new DateTime($date." ".$Times[$i]);
@@ -55 +32 @@
                                         
                         $select = mysql_query("SELECT * FROM schedule WHERE fLastUpdate = '$parsed_date'");
-                        if($select){
-                        while($row = mysql_fetch_array($select)){
+                        if($select)
+                        {
+                                while($row = mysql_fetch_array($select))
+                                {       
+                                        $new =   $row['fMeasurementID'] + 1 ;
+                                }
+                        }
+                        else
+                        {
+                                $new = 0;
+                        }
+                        $insert = mysql_query("INSERT INTO schedule values('','$parsed_date','$parsed_date','$measuref','','$n1','$selectf','$measuref')") or die(mysql_error());                               
+
                 
-                                
-                                $new =   $row['fMeasurementID'] + 1 ;
-                                
-                        
-                        
-                        }
-                                }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
-        
-        }
         
 ?>