Changeset 17422 for schedule/Transaction

Timestamp:

01/03/14 09:23:03 (11 years ago)

Author:

tanio

Message:

 

Location:

schedule/Transaction

Files:

• insert.php (modified) (1 diff)
• update.php (modified) (1 diff)

schedule/Transaction/insert.php

@@ -1 @@
-<?php
-//Build by: khristofer Usman
-//Modified by: Jaypee Tanio
-// June 14,2013
+ <?php
+//connect to the mysql
+$db = mysql_connect('localhost', 'root', '') or die("Could not connect database");
+mysql_select_db('sandboxschedule', $db) or die("Could not select database");
 
-include '../include/factdb.php';
- $Time =$_POST['Time'];
- $SelectedSource = $_POST['Source'];
- $Date = $_POST['Date'];
- echo $Date;
- $SelectedMeasure = $_POST['measure'];
-$value = $_POST['Data'];
-$date = $_POST['Date'];
-echo "<br />";
-$n_value = explode(",",$value);
-$Times = explode(",",$Time);
-$select = explode(",",$SelectedSource);
-$measure = explode(",",$SelectedMeasure);
-$limtex = count(explode(",",$SelectedMeasure));
-echo "<br />";
-for($i=0;$i<=$limtex-1;$i++)
-{
-        $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');
+
+        $GTimes=$_POST['GTime'];
+        $Source=$_POST['Source'];
+        $measure=$_POST['measure'];
+        $data=$_POST['Data'];
+        $Gdates = $_POST['GDate'];
+        $seq = $_POST['seq'];
         
-                mysql_query("INSERT INTO schedule VALUES('null','".$parsed_date."','".$UpdateDate."','".$measuref."','','".$n1."','".$selectf."','".$measuref."')");    
-                        
-}
+        $date = new DateTime($Gdates.$GTimes);
+        $par=$date->format('Y-m-d H:i:s');
+        $Timez = new DateTime($GTimes);
+        $part = $Timez->format('H:i:s');        
+                        //database query
+                        mysql_query("INSERT INTO schedule VALUES('null','".$par."','".$part."','".$seq."','','".$data."','".$Source."','".$measure."')");
+        
         
 ?>

schedule/Transaction/update.php

@@ -1 @@
-
-<?php
-//Build by: khristofer Usman
-//Modified by: Jaypee Tanio
-// June 22,2013
-include '../include/factdb.php';
-$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);
-$Times = explode(",",$Time);
-$select = explode(",",$SelectedSource);
-$measure = explode(",",$SelectedMeasure);
-//date_default_timezone_set('Asia/Manila'); // Setting up the localTimeZone in asia
-$UpdateDate=(date('Y-m-d H:i:s'));
+ <?php
+//connect to the mysql
+$db = mysql_connect('localhost', 'root', '') or die("Could not connect database");
+mysql_select_db('sandboxschedule', $db) or die("Could not select database");
 
 
-                                                $days = Date('Y-m-d',strtotime($date));
+        $GTimes=$_POST['GTime'];
+        $Source=$_POST['Source'];
+        $measure=$_POST['measure'];
+        $data=$_POST['Data'];
+        $Gdates = $_POST['GDate'];
+        $seq = $_POST['seq'];
+        
+        $date = new DateTime($Gdates.$GTimes);
+        $par=$date->format('Y-m-d H:i:s');
+        $UpdateDate=(date('Y-m-d H:i:s'));
 
-                        $fetch = mysql_query("SELECT * FROM schedule") or die(mysql_error());
-                                        
-                                        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)
-                                                {
-
-                                                $delete = mysql_query("DELETE FROM `schedule` WHERE `fStart`='{$rows['fStart']}'");
+                        $days = Date('Y-m-d',strtotime($Gdates));
+                        $cnt = 0;
+                        //QUERY TO DELETE THE TABLE INSIDE THE DATABASE
+                        //$fetch = mysql_query("SELECT * FROM schedule WHERE date(fStart)='$days'") or die(mysql_error());                      
+                        //while($rows = mysql_fetch_array($fetch)){
+                                //$update=mysql_query("UPDATE schedule SET `fStart`='$par',`fLastUpdate`='$UpdateDate',`fMeasurementID`='$seq',`fData`='$data',`fSourceKey`='$Source',`fMeasurementTypeKey`='$measure' WHERE fScheduleID = '".$rows['fSchecduleID']."' ");
+                                
+                                //mysql_query("DELETE FROM schedule WHERE date(fStart)='".$rows['fStart']."'");
+                                mysql_query("INSERT INTO schedule VALUES('null','".$par."','".$UpdateDate."','".$seq."','','".$data."','".$Source."','".$measure."')");
+                        //}     
                         
-                                                }
-                                        }
-                                        
-
-for($i=0;$i<=$limtex-1;$i++)
-{
-$select = explode(",",$SelectedSource);
-        $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');
+                        
+                                //$delete = mysql_query("DELETE FROM `schedule` WHERE `fStart`='{$rows['fStart']}'");
+                        //database query
         
-                mysql_query("INSERT INTO schedule VALUES('null','".$parsed_date."','".$UpdateDate."','".$measuref."','','".$n1."','".$selectf."','".$measuref."')");    
-                        
-}       
 ?>