<?php
/*
  CourseMS
  https://sourceforge.net/projects/coursems

  Copyright (c) 2007 Jacques Malan

  This version of the code is released under the GNU General Public License
*/
	include('includes/application_top.php');
	$error = false;
	if (!isset($_SESSION['learner'])) {
		header("Location: login.php");
	}
	if(time() - $_SESSION['timestamp'] > Session_time_out) { //subtract new timestamp from the old one
		echo"<script>alert('Du har automatiskt loggats ut p.g.a för lång inaktivitet.');</script>";
		unset($_SESSION['learner'], $_SESSION['timestamp']);
		$_SESSION['logged_in'] = false;
		header("Location: login.php"); //redirect to index.php
		exit;
	} 
	else {
		$_SESSION['timestamp'] = time(); //set new timestamp
	}
	
	$user = $_SESSION['learner'];
	$user->set_profile();
	$date = date('Y-m-d H:i:s');

	//include(FUNCTIONS . 'sessions.php');
	
	$radera = isset($_POST['Radera'])?$_POST['Radera']:false;
	if($radera!=false){
//echo'Radera är satt!<br>';
		// algorithm to determine this user's courses
		$loggsträng = $user->firstname.' '.$user->lastname.' raderar sig från systemet.'; add_to_logg_book($loggsträng);
		$schedule_array = array();
		$query = "select ca.id, ca.course_id, ca.lockDate, ca.lock_time, c.name, r.id'registration_id', r.status from calendar as ca left join registrations as r on (r.calendar_id = ca.id) left join courses as c on (ca.course_id = c.id) where r.user_id = '$user->id' order by ca.start_date, c.center, c.type, ca.start_time, c.name";
		$result = tep_db_query($query);
		
		if (tep_db_num_rows($result) > 0) {
			while ($row = tep_db_fetch_array($result)) {
				$schedule_array[] = array('id' => $row['id'],
							  'name' => $row['name'],
							  'course_id' => $row['course_id'],
							  'status' => $row['status'],
							  'lockDate' => $row['lockDate'],
							  'lock_time' => $row['lock_time'],
							  'registration_id' => $row['registration_id']);
			}
		}
//print_r($schedule_array);
		foreach ($schedule_array as $x=>$y) {
			$kursen_tids_låst = false;
			$nuDatum = Date('Y-m-d'); $nutid = Date('H:i');
			$låsdatum = $y['lockDate']; $låstid = $y['lock_time'];
			if(($nuDatum > $låsdatum) || (($nuDatum == $låsdatum) &&($nutid>=$låstid)) ){
				$kursen_tids_låst = true;
				$loggsträng = $user->firstname.' '.$user->lastname.' raderar sig men avbokas INTE från kursen '.tep_get_course_name(tep_get_course_id(tep_get_calendar_id_from_regid($y['registration_id']))).' som är låst.'; add_to_logg_book($loggsträng);
			}
			else{
				$loggsträng = $user->firstname.' '.$user->lastname.' avboks från '. tep_get_course_name(tep_get_course_id(tep_get_calendar_id_from_regid($y['registration_id']))).' med status '.tep_get_status_from_regid($y['registration_id']).' regId:'.$y['registration_id']; add_to_logg_book($loggsträng);
				unBookUser($user->id, $y['id'], $y['registration_id']);
			}
//echo'id:',$y['id'],'  course_id:',$y['course_id'],'  namn:',$y['name'],'  status:',$y['status'],'<br>';
//echo'nutid:',$nuDatum,' ',$nutid,'  låsdatum:',$låsdatum,'  låstid:',$låstid,'  Kursen är tidslås:',$kursen_tids_låst,'<br>';
			
		}

	
		$query="delete from users where id=".$_GET['id'];
		tep_db_query($query);
		$query="delete from profiles where user_id=".$_GET['id'];
		tep_db_query($query);
	
		unset($_SESSION['learner']);
		session_destroy();
		header("Location: login.php");
	}
	
	if (isset($_POST['edit_profile'])) {

		$errors = tep_validate_registration('edit');


			//lets fill database with user
			$admn = isset($_POST['admin']) ? $_POST['admin'] : 0;
			$cntr = isset($_POST['center']) ? $_POST['center'] : 0;
			$tpe  = isset($_POST['type']) ? $_POST['type'] : 0;
			$inst = isset($_POST['instructor']) ? $_POST['instructor'] : 0;
			
					
			if (isset($_SESSION['learner']) && !$errors[0]) {
				$sql_array = array("username" => $_POST['email'],
						   "admin" => $admn,
						   "center" => $cntr,
						   "type" => $tpe,
						   "instructor" => $inst);
				// enter user into users database
				tep_db_perform(TABLE_USERS, $sql_array, 'update', "id='$user->id'");
				$user_id = mysqli_insert_id(tep_db_connect());

				$sql_array = array("user_id" => $user->id,
						   "email" => $_POST['email'],
						   //"title" => $_POST['title'],
						   "firstname" => $_POST['firstname'],
						   "lastname" => $_POST['lastname'],
						   //"hospital_name" => $_POST['hosp_name'],
						   "address_line1" => $_POST['address1'],
						   //"address_line2" => $_POST['addr2'],
						   "city" => $_POST['city'],
						   "postcode" => $_POST['postcode'],
						   "cDate" => date("Y-m-d H:i:s"),
						   "mDate" => date("Y-m-d H:i:s"),
						   //"work_telephone" => $_POST['work_tel'],
						   "home_telephone" => $_POST['home_tel'],
						   "mobile_telephone" => $_POST['mobile_tel'],
						   "date_of_birth" => $_POST['date_of_birth'],
						   "alias" => $_POST['alias']);
						   //"bleep" => $_POST['bleep'],
						   //"job_title_id" => $_POST['job_title'],
						   //"specialty_id" => $_POST['specialty'],
						   //"band" => $_POST['band'],
						   //"gmc_reg" => $_POST['gmc_reg'],
						   //"diet" => $_POST['diet'],
						   //"how_hear" => $_POST['how_hear'],
						   //"qualifications" => $_POST['qualifications'],
						   //"photo" => $filename,
						   //"instructor" => $_POST['instructor']);

				// enter user profile details
				tep_db_perform(TABLE_PROFILES, $sql_array, 'update', "user_id='$user->id'");
				$loggsträng = $user->firstname.' '.$user->lastname.' uppdaterade användaruppgifter '; add_to_logg_book($loggsträng);
		

				header("Location: view_profile.php?id=$user->id");
			}
			else
			{
				$access_error = true;
				$error = PERMISSION_ERROR;
			}
	}
	// template for page build
	include(INCLUDES . 'header.php');
	include(INCLUDES . 'front_header.php');
?>
	<TABLE width=<?php echo TABLE_WIDTH; ?> cellspacing="0" cellpadding="0" border="0" align="center" bgcolor="#ffffff">
		<tr>
			<td colspan=3><IMG height=10 src="images/blank.gif" width=1></td>
		</tr>
		<tr>
			<td width="3%" rowspan=2><IMG height=45 src="images/line.gif" width=24></td>
			<td class="title" height="27" colspan=3>&nbsp;Ändra uppgifter</td>
		</tr>
		<tr>
			<td colspan="3">&nbsp;</td>
		</tr>
	</TABLE>

	<TABLE width=<?php echo TABLE_WIDTH; ?> cellspacing="0" cellpadding="0" border="0" align="center" bgcolor="#ffffff">
		<tr>
			<td align="middle">
				<br><br>
				<!-- main content starts here -->
				<table width=<?php echo SEC_TABLE_WIDTH; ?> align="center" cellspacing="1" cellpadding="3">
					<tr>
						<td>
				
						<!--	<form enctype="multipart/form-data" name="profile" action="edit_profile.php?id=<?php echo $_GET['id']; ?>" method="post"> -->
					<!--	<form action="add_course.php" name="add_course" method="POST">
						<form action="edit_profile.php?id=<?php echo $_GET['id']; ?>" name="edit_profile" method="POST"> 
						<form action="edit_profile.php?id=1234" name="edit_profile" method="POST"> -->
						<form action="edit_profile.php?id=<?php echo $user->id; ?>" name="edit_profile" method="POST">
							<table width='100%'>
								<tr>
									<td width="60%">
										&nbsp;
									</td>
									<td>
										<span class="required">* Obligatoriska fält</span>
									</td>
								</tr>
								<?php
								if(!isset($errors)){
									$errors = false;
								}
								if ($errors[0]) {
								?>
								<tr>
									<td>
										<span class="required">Följande fel inträffade:
										<?php echo $errors[1]; ?></span>
									</td>
								</tr>
								<?php
								}

								?>

<!--							<tr>
									<td colspan="2" align="left">
										<h4>Inloggningsnamn</h4>
									</td>
								</tr>
								<tr>
									<td colspan="2">
										<table width="100%">
											<tr>
												<td width="30%" class="left">
													Epostadress:
												</td>
												<td class="right">
													<input class="textbox1" type="text" name="email" size="40" value="<?php echo $user->username; ?>">
													&nbsp;<span class="required">*</span>
												</td>
											</tr>
										</table>
									</td>
								</tr>
-->								<tr>
									<td colspan="2" align="left">
										<h4>Personuppgifter</h4>
									</td>
								</tr>
								<tr>
									<td colspan="2">
										<table width="100%">
<!--											<tr>
												<td width="30%" class="left">
													Title:
												</td>
												<td class="right">
													<INPUT TYPE=RADIO NAME="title" VALUE="mr" <?php if ($user->title=='Mr') echo 'CHECKED';?>>Mr.&nbsp;
													<INPUT TYPE=RADIO NAME="title" VALUE="mrs" <?php if ($user->title=='Mrs') echo 'CHECKED';?>>Mrs.&nbsp;
													<INPUT TYPE=RADIO NAME="title" VALUE="dr" <?php if ($user->title=='Dr') echo 'CHECKED';?>>Dr.&nbsp;
													<INPUT TYPE=RADIO NAME="title" VALUE="miss" <?php if ($user->title=='Miss') echo 'CHECKED';?>>Miss.&nbsp;
													<INPUT TYPE=RADIO NAME="title" VALUE="ms" <?php if ($user->title=='Ms') echo 'CHECKED';?>>Ms.&nbsp;
													<INPUT TYPE=RADIO NAME="title" VALUE="prof" <?php if ($user->title=='Prof') echo 'CHECKED';?>>Prof.&nbsp;
													&nbsp;<span class="required">*</span>
												</td>
											</tr>
-->											<tr>
												<td class="left">
													Epostadress:
												</td>
												<td class="right">
													<input class="textbox1" type="text" name="email" size="40" placeholder="charlie.hastsson@domain.se" value="<?php echo $user->username; ?>"> 
													&nbsp;<span class="required" >*</span>
												</td>
											</tr>
											<tr>
												<td class="left">
													Förnamn:
												</td>
												<td class="right">
													<input class="textbox1" type="text" name="firstname" placeholder="Charlie" value="<?php echo $user->firstname; ?>" size="40">
													&nbsp;<span class="required">*</span>
												</td>
											</tr>
											<tr>
												<td class="left">
													Efternamn:
												</td>
												<td class="right">
													<input class="textbox1" type="text" name="lastname" placeholder="Hästsson" value="<?php echo $user->lastname; ?>" size="40">
													&nbsp;<span class="required">*</span>
												</td>
											</tr>
											<tr>
												<td class="left">
													Födelseår:
												</td>
												<td class="right">
													<input class="textbox1" type="text" name="date_of_birth" placeholder="ÅÅÅÅ (1997)" value="<?php echo $user->date_of_birth; ?>" size="40">
													&nbsp;<span class="required"></span>
												</td>
											</tr>
											<tr>
												<td class="left">
													Alias:
												</td>
												<td class="right">
													<input class="textbox1" type="text" name="alias" placeholder="Ditt alias visas publikt istället för ditt namn." value="<?php echo $user->alias; ?>" size="40">
													&nbsp;<span class="required"></span>
												</td>
											</tr>
											<tr>
												<td class="left">
													Telefon hem:
												</td>
												<td class="right">
													<input class="textbox1" type="text" name="home_tel" placeholder="0859012345" value="<?php echo $user->home_telephone; ?>" size="40">
													&nbsp;<span class="required"></span>
												</td>
											</tr>
											<tr>
												<td class="left">
													Telefon mobil:
												</td>
												<td class="right">
													<input class="textbox1" type="text" name="mobile_tel" placeholder="0709876543" value="<?php echo $user->mobile_telephone; ?>" size="40">
													&nbsp;<span class="required"></span>
												</td>
											</tr>
											<tr>
												<td class="left">
													Gatuadress:
												</td>
												<td class="right">
													<input class="textbox1" type="text" name="address1" placeholder="Buseknusgatan 3" value="<?php echo $user->address_line1; ?>" size="40">
													&nbsp;<span class="required"></span>
												</td>
											</tr>
											<tr>
												<td class="left">
													Postnummer:
												</td>
												<td class="right">
													<input class="textbox1" type="text" name="postcode" placeholder="19435" value="<?php echo $user->postcode; ?>" size="40">
													&nbsp;<span class="required"></span>
												</td>
											</tr>
											<tr>
												<td class="left">
													Postort:
												</td>
												<td class="right">
													<input class="textbox1" type="text" name="city" placeholder="Sollentuna" value="<?php echo $user->city; ?>"size="40">
													&nbsp;<span class="required"></span>
												</td>
											</tr>
										</table>
									</td>
								</tr>
<!--							<tr>
									<td align="left">
										<h4>Course Registration Information:</h4>
									</td>
								</tr>
								<tr>
									<td colspan="2">
										<table width="100%">
											<tr>
												<td width="30%" class="left">
													Job Title:
												</td>
												<td class="right">
													<!-- <input type="text" name="job_title" value="<?php echo $_POST['job_title'] ?>">-->
<!--												<?php echo tep_build_dropdown(TABLE_JOBS, 'job_title', false, '1', '', true, $user->job_title_id); ?>
													&nbsp;<span class="required">*</span>
													<!-- needs to become dropdown generated from database -->
<!--												</td>
											</tr>
											<tr>
												<td class="left">
													Team:
												</td>
												<td class="right">
													<!-- <input type="text" name="specialty" value="<?php echo $_POST['specialty'] ?>">-->
<!--													<?php echo tep_build_dropdown(TABLE_SPECIALTIES, 'specialty', false, '1', '', true, $user->specialty_id); ?>
													<!-- needs to become dropdown generated from database -->
													<!-- &nbsp;<span class="required">*</span> -->
	<!--											</td>
											</tr>
											<tr>
												<td class="left">
													Special Requirements:
												</td>
												<td class="right">
													<!-- pulldown menu of vegitarian, halal, kosher -->
													<!-- <input type="text" name="diet" value="<?php echo $_POST['diet'] ?>"> -->
<!--													<?php echo tep_build_dropdown(TABLE_DIET, 'diet', false, '1', '', true, $user->diet); ?>
												</td>
											</tr>
										</table>
									</td>
								</tr>
								<tr>
									<td>
										&nbsp;
									</td>
								</tr>
-->								<tr>
									<td colspan="2" align="center">
									<!--    <input name="profile" type="submit" value="Skicka" class="submit3" /> -->
										<input name="edit_profile" type="submit" class="submit3" value="Uppdatera" />&nbsp&nbsp&nbsp 
										<input name="Radera" type="submit" class="submit3" value="Radera mig helt från systemet" onclick="return confirm('Vill du verkligen ta bort dig helt från systemet? Du kommer att avbokas från samtliga kurser och alla dina data kommer att raderas. Det finns ingen möjlighet att ångra denna åtgärd.')"/> 
									</td>
								</tr>
							</table>
							</form>
						</td>
					</tr>

				</table>
				<br><br>
			<table width="96%" align="center" cellspacing="0" cellpadding="2" border="0">
				<tr>
					<td colspan=3 align=right></td>
				</tr>
			</table>
			<br><br>
			</td>
		</tr>
	</TABLE>
<?php
	include(INCLUDES . 'footer.php');
?>
