
<?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'));


						$days = Date('Y-m-d',strtotime($date));

			$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']}'");
			
						}
					}
					

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');
	
		mysql_query("INSERT INTO schedule VALUES('null','".$parsed_date."','".$UpdateDate."','".$measuref."','','".$n1."','".$selectf."','".$measuref."')");	
			
}	
?>