Oreste-vet Svn

<?php 
$pageRef='Calendar';
include('includes/header.php'); 
?>

<script>
var newClientDetailsFields;	//Array of new clients info input. It's initialized in the onLoad function

function place2Num(place){
	var num;

	switch(place){
	case 'visitAppBox':
		num = 0;
		break;
	case 'homeVisitAppBox':
		num = 1;
		break;
	case 'extCommitmentAppBox':
		num = 2;
		break;
	case 'holidayAppBox':
		num = 3;
		break;
	default:
		num = 3;
	}

	return num;
}

/*************************************************/
/* Manages click event on the tab client details */
/*************************************************/
function clickOnClientDetails(e){
	var aClientIsSelected = parseInt($F('client'));

	if(aClientIsSelected){
		$('client').value=0;
		manageNewClientDetails('client');
	}
}

/*************************************/
/* Enable/disable new client details */
/*************************************/
function manageNewClientDetails(client){ 
	var heIsAClient = parseInt($F(client));

	if(heIsAClient){
		//disable all new client details input element (select included), all inputs value is now '#'
		newClientDetailsFields.each(function(s){s.value='#';s.style.color='#BBBBBB';});
	}else{
		//enable all new client details input element (select included), all inputs value is now ''
		newClientDetailsFields.each(function(s){s.value='';s.style.color='#000000';});
	}
}

/********************************************************/
/* Manages delete result caused by the cancel operation */
/********************************************************/
function successInDeletingApp(transport){
	var args	= transport.responseText.evalJSON();
	var appDate	= $F('date');
	var dateParts	= appDate.split("/");
	var day		= dateParts[0];
	var month	= dateParts[1];
	var year	= dateParts[2];

	$('qResult').style.display='block';
	$('qResult').innerHTML=args.opText;

	if(parseInt(args.opResult) == 0){
		window.location.href = 'http://127.0.0.1/Oreste/calendar.php?day='+day+'&month='+month+'&year='+year;
	}else{
		//Error during paste operation
	}
}

/**********************************************************/
/* Manages request failure caused by the cancel operation */
/**********************************************************/
function failureInDeletingApp(){
	alert('<?php echo _T("NI_viewAppointmentDetails_") ?>');
}

function deleteAppointment(aId){ 
	answer = confirm('<?php echo _T("NI_viewAppointmentDetails_I") ?>'); 

	if(answer != 0){
		OL_deleteAppointment(aId, {onSuccess: successInDeletingApp, onFailure: failureInDeletingApp});
	}else{
	}
} 

function backToCalendar(){
	var appDate	= $F('date');
	var dateParts	= appDate.split("/");
	var day		= dateParts[0];
	var month	= dateParts[1];
	var year	= dateParts[2];

	window.location.href = 'http://127.0.0.1/Oreste/calendar.php?day='+day+'&month='+month+'&year='+year;
}

function successInUpdatingAppF(transport){
	var args=transport.responseText.evalJSON();

	//Success in update request

	//Operation result advice
	$('qResult').style.display='block';
	$('qResult').innerHTML=args.opText;

	if(parseInt(args.opResult) == 0){
		//Success in update operation
	}else{
		//Failure in update operation
	}
}

function failureInUpdatingAppF(){
	//Failure in update request
	alert('<?php echo _T("NI_viewAppointmentDetails_"); ?>');
}

function saveAppointmentUpdate(appId){
	clientId	= $F('client');
	owner		= $F('owner');
	telephone	= $F('telephone');
	mobile		= $F('mobile');
	office		= $F('office');
	email		= $F('email');
	address1	= $F('address1');
	address2	= $F('address2');
	vet		= $F('vet');
	place		= place2Num($F('place'));
	date		= $F('date');
	hour		= $F('hour');
	period		= $F('period');
	note		= $F('note');

	if(telephone=='#'){$('telephone').value='';}
	if(mobile=='#'){$('mobile').value='';}
	if(office=='#'){$('office').value='';}
	if(email=='#'){$('email').value='';}

	if(formValidationRules.validate()){
		OL_saveAppointmentUpdate(appId, clientId, owner, telephone, mobile, office, email, address1, address2, vet, place, date, hour, period, note, {onSuccess: successInUpdatingAppF, onFailure: failureInUpdatingAppF});
	}else{
		alert('<?php echo _T("NI_viewAppointmentDetails_"); ?>');
	}
}	
</script>

<?php
$getData = mysql_query("SELECT * FROM calendars WHERE calendars.entryID='$_GET[appointmentID]'");
while($row = mysql_fetch_array($getData)) {
	$appID = $row[entryID];
	$forClient = $row[forClient];
	$specialNotes = $row[specialNotes];
	$date = $row[date];
	$time = $row[time];
	$timeTo = $row[timeTo];
	$forDoctor = $row[forDoctor];
	$forClientName = $row[forClientName];
	$forClientSurname = $row[forClientSurname];
	$forClientAddress1 = $row[forClientAddress1];
	$forClientAddress2 = $row[forClientAddress2];
	$forClientTel = $row[forClientTel];
	$forClientMobile = $row[forClientMobile];
	$forClientWorkNumber = $row[forClientWorkNumber];
	$location = $row[location];
	$forClientEmail = $row[forClientMail];
}
?>

<div id="qResult" class="OpResult"></div>
<div class="Columns">
	<div class="Column1">
		<div class="Block"><div class="BlockBL"><div></div></div><div class="BlockBR"><div></div></div><div class="BlockTL"></div><div class="BlockTR"><div></div></div><div class="BlockT"></div><div class="BlockR"><div></div></div><div class="BlockB"><div></div></div><div class="BlockL"></div><div class="BlockC"></div><div class="BlockContent"><span class="BlockHeader"><span>Azioni</span></span><div class="BlockContentBorder">
			<ul>
				<?php echo "<li><a href=\"javascript:saveAppointmentUpdate('" . $appID . "');\">"	. _T("Save changes")		. "</a></li>"; ?>
				<?php echo "<li><a href=\"javascript:deleteAppointment('" . $appID . "');\">"		. _T("Delete appointment")	. "</a></li>"; ?>
				<?php echo "<li><a href=\"javascript:backToCalendar();\">"				. _T("Back to calendar")	. "</a></li>"; ?>
			</ul>
		</div>
		</div>
		</div>
	</div>
		
	<div class="MainColumn">
		<div class="Block"><div class="BlockBL"><div></div></div><div class="BlockBR"><div></div></div><div class="BlockTL"></div><div class="BlockTR"><div></div></div><div class="BlockT"></div><div class="BlockR"><div></div></div><div class="BlockB"><div></div></div><div class="BlockL"></div><div class="BlockC"></div><div class="BlockContent"><span class="BlockHeader"><span>Dettagli appuntamento</span></span><div class="BlockContentBorder">
			<form id="formToValidate">
				<table width="100%">
					<tr>
					<td width="10%"><b><?php echo _T("Client") ?></b></td>      
						<?php 
							echo "<td width=\"20%\" colspan=\"3\">( <select name=\"client\" id=\"client\" style=\"width: 90%;\">";
							if($forClient != "0"){
								echo "<option value=\"0\"></option>";
							}else{
								echo "<option selected=\"selected\" value=\"0\"></option>";
							}
	
							$clientList= mysql_query("SELECT * FROM clients ORDER BY clientName");
							while($row = mysql_fetch_array($clientList)) {
								if($forClient != $row[clientID]){
									echo "<option value=\"" . $row[clientID] . "\">" . $row[clientName] . " " . $row[clientSurname] . "</option>";
								}else{
									echo "<option selected=\"selected\" value=\"" . $row[clientID] . "\">" . $row[clientName] . " " . $row[clientSurname] . "</option>";
								}
							}
							echo "</select> )";
							echo "</td>";
						?>
					</tr>
					<?php
						echo "<tr><td>" . _T("Name") . "</td>		<td colspan=\"3\"><input class=\"required\"		title=\"\"	type=\"text\" style=\"width: 90%;\" value=\"" . $forClientName . " " . $forClientSurname . "\"		name=\"owner\"		id=\"owner\"></td>	</tr>";
						echo "<tr><td>" . _T("Telephone") . "</td>	<td colspan=\"3\"><input class=\"validate-number\"	title=\"\"	type=\"text\" style=\"width: 90%;\" value=\"" . $forClientTel . "\"					name=\"telephone\"	id=\"telephone\"></td>	</tr>";
						echo "<tr><td>" . _T("Mobile") . "</td>		<td colspan=\"3\"><input class=\"validate-number\"	title=\"\"	type=\"text\" style=\"width: 90%;\" value=\"" . $forClientMobile . "\"					name=\"mobile\"		id=\"mobile\"></td>	</tr>";
						echo "<tr><td>" . _T("Office") . "</td>		<td colspan=\"3\"><input class=\"validate-number\"	title=\"\"	type=\"text\" style=\"width: 90%;\" value=\"" . $forClientWorkNumber . "\"				name=\"office\"		id=\"office\"></td>	</tr>";
						echo "<tr><td>" . _T("Address") . "</td>	<td colspan=\"3\"><input 						type=\"text\" style=\"width: 90%;\" value=\"" . $forClientAddress1 . "\"				name=\"address1\"	id=\"address1\"></td>	</tr>";
						echo "<tr><td>" . _T("Address") . "</td>	<td colspan=\"3\"><input 						type=\"text\" style=\"width: 90%;\" value=\"" . $forClientAddress2 . "\"				name=\"address2\"	id=\"address2\"></td>	</tr>";
						echo "<tr><td>" . _T("Email") . "</td>		<td colspan=\"3\"><input class=\"validate-email\"	title=\"\"	type=\"text\" style=\"width: 90%;\" value=\"" . $forClientEmail . "\"					name=\"email\"		id=\"email\"></td>	</tr>";
					?>

					<tr>
						<td><b><?php echo _T("Vet") ?></b></td>  
						<td colspan="3"><select style="width: 90%;" id="vet" name="vet">
						<?php
							$vetList=mysql_query("SELECT * FROM users ORDER BY userFullName");
							while($row = mysql_fetch_array($vetList)) {
								if($forDoctor!=$row[userFullName]){
									echo "<option value=\""  . $row[userFullName] . "\">" . $row[userFullName] . "</option>";
								}else{
									echo "<option selected=\"selected\" value=\""  . $row[userFullName] . "\">" . $row[userFullName] . "</option>";
								}
							}
						?>
						</select></td> 
					</tr>

					<tr>
						<td><b><?php echo _T("Place") ?></b></td>
						<td colspan="3">
						<select style="width: 90%;" id="place" name="place">
						<?php
							if($location == 0){//0
								echo "<option value=\"visitAppBox\" selected=\"selected\">" . _T("Clinic visit") . "</option>";
							}else{
								echo "<option value=\"visitAppBox\">" . _T("Clinic visit") . "</option>";
							}
							if($location == 1){//1
								echo "<option value=\"homeVisitAppBox\" selected=\"selected\">" . _T("Home visit") . "</option>";		
							}else{
								echo "<option value=\"homeVisitAppBox\">" . _T("Home visit") . "</option>";
							}
							if($location == 2){//2
								echo "<option value=\"extCommitmentAppBox\" selected=\"selected\">" . _T("External commitment") . "</option>";
							}else{
								echo "<option value=\"extCommitmentAppBox\">" . _T("External commitment") . "</option>";
							}
							if($location == 3){//3
								echo "<option value=\"holidayAppBox\" selected=\"selected\">" . _T("Holiday") . "</option>";
							}else{
								echo "<option value=\"holidayAppBox\">" . _T("Holiday") . "</option>";
							}
						?>
						</select>
						</td> 
					</tr>

					<tr>
						<td width="10%"><b><?php echo _T("Date") ?></b></td>
						<?php echo "<td colspan=\"3\"><input style=\"width:90%;\" type=\"text\" readonly=\"readonly\" id=\"date\" value=\"". $date . "\"></td><td width=\"10%\" align=\"left\"><a href=\"javascript:calendarLoad('dataApp');\"><img src=\"../vet/images/calendarIcon.png\"/></a></td>"; ?>
					</tr>

					<tr>
						<td><b><?php echo _T("Hour") ?> </b></td>
						<td colspan="3"><select id="hour" style="width:35%;" name="hour">
						<?php 
							$conta=8; 
							while($conta<19){
								$oraApp=$conta . ":00";
								if($oraApp == $time){
									echo "<option selected=\"selected\" value=\"" . $oraApp . "\">" . $oraApp . "</option>"; 
								}else{	
									echo "<option value=\"" . $oraApp . "\">" . $oraApp . "</option>"; 
								}	
								$oraApp=$conta . ":30"; 
								if($oraApp == $time){
									echo "<option selected=\"selected\" value=\"" . $oraApp . "\">" . $oraApp . "</option>"; 
								}else{	
									echo "<option value=\"" . $oraApp . "\">" . $oraApp . "</option>"; 
								}	
								$conta=$conta+1;
							} 
						?>
						</select>
						(
							<select name="period" style="width:35%" id="period"><?php $durata=0; while($durata<780){$durata=$durata+30;	$hourCheck = $durata%60; if($hourCheck != 0){$hourToDisplay = ($durata - 30)/60; $hourToDisplay = $hourToDisplay . ":30";}else{$hourToDisplay = $durata/60; $hourToDisplay = $hourToDisplay . ":00";} if($durata!= $timeTo){echo "<option value=\"" . $durata . "\">" . $hourToDisplay . "</option>";}else{echo "<option selected=\"selected\" value=\"" . $durata . "\">" . $hourToDisplay . "</option>";}} ?></select>
						)<?php echo _T("min") ?></td>
					</tr>

					<tr>
						<td colspan="5"><b><?php echo _T("Note") ?></b></td><td></td>
					</tr>
				
					<tr valign="top">
						<td colspan="4"><textarea rows="4" cols="1" id="note" name="note" style="font-size:0.8em; width:95%;"><?php echo $specialNotes; ?></textarea></td>
					</tr>
				</table>
			</form>
		</div>
		</div>
		</div>
	</div>
</div>

<script>
	// ************************************************************
	// * Observe window load event to call the init page function *
	// ************************************************************
	Event.observe(window, 'load', function(){
		// **************************
		// * Install event handlers *
		// **************************
		Event.observe('qResult',	'mouseover',	function(){OL_makeThisElementInvisible('qResult');});

		Event.observe('client',		'change',	function(e){manageNewClientDetails('client');});
		newClientDetailsFields = new Array($('owner'), $('telephone'), $('mobile'), $('office'), $('address1'), $('address2'), $('email'));
		newClientDetailsFields.each(function(s){Event.observe(s, 'click', function(e){clickOnClientDetails(e)})});

		// *********************
		// * Install validator *
		// *********************
		formValidationRules = new Validation('formToValidate',{immediate:true, onSubmit:false, useTitles:true, stopOnFirst:false});
	}); 
</script>

</div>
</div>
</div>
</body>
</html>