<?


include '../connect.php';


$area_sql = mysql_query("SELECT * FROM opening_hours WHERE done='0' ORDER BY opid ASC LIMIT 1");
while($area_row = mysql_fetch_array($area_sql)){
	
	$id=$area_row['opid'];
	$adid=$area_row['opadid'];
	echo 'ID: '.$id.'<br>';
	echo 'ADID: '.$adid.'<br>';
	
	// MONDAY
	$monstart=$area_row['monstart'];
	$monstart1=$area_row['monstart1'];
	$monfin=$area_row['monfin'];
	$monfin1=$area_row['monfin1'];
	$monclosed=$area_row['monclosed'];
	
	if($monclosed=='1'){
		$monday='Closed';
	}else{
		$monday=$monstart.$monstart1.' - '.$monfin.$monfin1;
	}
		
	// TUESDAY
	$tuestart=$area_row['tuestart'];
	$tuestart1=$area_row['tuestart1'];
	$tuefin=$area_row['tuefin'];
	$tuefin1=$area_row['tuefin1'];
	$tueclosed=$area_row['tueclosed'];
	
	if($tueclosed=='1'){
		$tuesday='Closed';
	}else{
		$tuesday=$tuestart.$tuestart1.' - '.$tuefin.$tuefin1;
	}
	
		
	// WEDNESDAY
	$wedstart=$area_row['wedstart'];
	$wedstart1=$area_row['wedstart1'];
	$wedfin=$area_row['wedfin'];
	$wedfin1=$area_row['wedfin1'];
	$wedclosed=$area_row['wedclosed'];
	
	if($wedclosed=='1'){
		$wednesday='Closed';
	}else{
		$wednesday=$wedstart.$wedstart1.' - '.$wedfin.$wedfin1;
	}
	
	
	// THURSDAY
	$thurstart=$area_row['thurstart'];
	$thurstart1=$area_row['thurstart1'];
	$thurfin=$area_row['thurfin'];
	$thurfin1=$area_row['thurfin1'];
	$thurclosed=$area_row['thurclosed'];
	
	if($thurclosed=='1'){
		$thursday='Closed';
	}else{
		$thursday=$thurstart.$thurstart1.' - '.$thurfin.$thurfin1;
	}
	
	
	// FRIDAY
	$fristart=$area_row['fristart'];
	$fristart1=$area_row['fristart1'];
	$frifin=$area_row['frifin'];
	$frifin1=$area_row['frifin1'];
	$friclosed=$area_row['friclosed'];
	
	if($friclosed=='1'){
		$friday='Closed';
	}else{
		$friday=$fristart.$fristart1.' - '.$frifin.$frifin1;
	}
	
	
	// SATURDAY
	$satstart=$area_row['satstart'];
	$satstart1=$area_row['satstart1'];
	$satfin=$area_row['satfin'];
	$satfin1=$area_row['satfin1'];
	$satclosed=$area_row['satclosed'];
	
	if($satclosed=='1'){
		$saturday='Closed';
	}else{
		$saturday=$satstart.$satstart1.' - '.$satfin.$satfin1;
	}
	
	
	// SUNDAY
	$sunstart=$area_row['sunstart'];
	$sunstart1=$area_row['sunstart1'];
	$sunfin=$area_row['sunfin'];
	$sunfin1=$area_row['sunfin1'];
	$sunclosed=$area_row['sunclosed'];
	
	if($sunclosed=='1'){
		$sunday='Closed';
	}else{
		$sunday=$sunstart.$sunstart1.' - '.$sunfin.$sunfin1;
	}
	
	
	
	echo $monday.'<br>';
	echo $tuesday.'<br>';
	echo $wednesday.'<br>';
	echo $thursday.'<br>';
	echo $friday.'<br>';
	echo $saturday.'<br>';
	echo $sunday.'<br>';
	


	$r4 = mysql_query("UPDATE opening_hours SET 
						monday='{$monday}',
						tuesday='{$tuesday}',
						wednesday='{$wednesday}',
						thursday='{$thursday}',
						friday='{$friday}',
						saturday='{$saturday}',
						sunday='{$sunday}',
						done='1' WHERE opid='{$id}'") or die(mysql_error());

}

header("Refresh: 0;url=http://www.yellowleaf.co.uk/staff/opening_hours.php");

?>