data.php

<?php 
	// et saada ligi sessioonile
	require("functions.php");
	
	require ("/class/helper.class.php")
	$Helper = new Helper();
	
	require ("/class/note.class.php")
	$Note = new Note($mysqli);
	
	//ei ole sisseloginud, suunan login lehele
	/*if(!isset ($_SESSION["userId"])) {
		header("Location: login.php");
		exit();
	}*/
	
	
	//kas kasutaja tahab välja logida
	// kas aadressireal on logout olemas
	if (isset($_GET["logout"])) {
		
		session_destroy();
		
		header("Location: login.php");
		exit();
		
	}
	//kontrollin kas on olemas profession ja location jms.
	if (	isset($_POST["profession"]) && 
			isset($_POST["location"]) && 
			isset($_POST["money"]) && 
			isset($_POST["color"]) &&
			isset($_POST["note"]) &&
			!empty($_POST["profession"]) && 
			!empty($_POST["location"]) && 
			!empty($_POST["money"]) && 
			!empty($_POST["color"])&& 
			!empty($_POST["note"])
			
	) {
		$profession = $helper->cleanInput ($_POST["profession"]);
		$location = $helper->cleanInput ($_POST["location"]);
		$money = $helper->cleanInput ($_POST["money"]);
		$color = $helper->cleanInput ($_POST["color"]);
		$note = $helper->cleanInput ($_POST["note"]);
		
		//muuda savenote fun
		$note->saveNote($profession, $location, $money, $color, $note);
		
	}
	
	$q = "";
 	
 	// otsisõna aadressirealt
 	if(isset($_GET["q"])){
 		$q = $Helper->cleanInput($_GET["q"]);
 	}
 	
 	//vaikimisi
 	$sort = "id";
 	$order = "ASC";
 	
 	if(isset($_GET["sort"]) && isset($_GET["order"])){
 		$sort = $_GET["sort"];
 		$order = $_GET["order"];
 	}
 	
 	
 	$notes = $Note->getAllNotes($q, $sort, $order);
 	
 	//echo "<pre>";
 	//var_dump($notes);
 	//echo "</pre>";
 
	
?>

<?php require("../header.php"); ?>
<link rel="stylesheet" href="Style/data.css">
<header>
  <h1>Hei, <?=$_SESSION["userEmail"]?>. Oled jõudnud andmetelehele, 
kus aitame välja selgitada, millist abikätt saab sinu käest. </h1>
</header>


<ul>
  <li><a href="data.php">Kodu</a></li>
  <li><a href="user,php.php">Sina</a></li>
  <li><a href="login.php">Logi välja</a></li>
</ul>


<h2>Sisesta mõned andmed</h2>

<form method="POST">
	<fieldset>
		<legend>Informatsioon</legend>
			<label>Millist teenust pakud?</label><br>
			<select name="profession" >
			
				<option value= "plumber" selected> Torumees</option>
				<option value= "electrician"> Elektrik</option>
				<option value= "cleaner"> Koristaja</option>
				<option value= "it-support"> IT-tugi</option>
			</select>
			
			<br><br>
<label> Millises linnaosas? <label><br>
			<select name= "location">
				<option value= "kristiine"> Kristiine</option>
				<option value= "viimsi"> Viimsi</option>
				<option value= "pirita"> Pirita</option>
				<option value= "lasnamäe"> Lasnamäe</option>
				<option value= "kesklinn"> Kesklinn</option>
				<option value= "pohja-tallinn"> Põhja-Tallinn</option>
				<option value= "mustamäe"> Mustamäe</option>
				<option value= "haabersti"> Haabersti</option>
				<option value= "nomme"> Nõmme</option>
				
			</select>
			
			<br><br>
			
			
	<label>Keskmine tunnitasu</label><br>
	<input type="range" name="money" min="0" max="15"  onchange="updateTextInput(this.value);">
	<input type="text" id="textInput" value="">
	<script>
		function updateTextInput(val) {
          document.getElementById('textInput').value=val; 
        }
	</script>
	
	<br><br>
	
	<label>Kirjelda ennast paari sõnaga:</label><br>
	<textarea name="note">Kirjeldus</textarea>
	
	<br><br>
	
	<label>Värv</label><br>
	<input name="color" type="color" value="#ffffff"/>
				
	<br><br>
	
	<input type="submit">
	
	</fieldset>
</form>

<h2>Arhiiv</h2>
<form>
 	<input type="search" name="q" value="<?=$q;?>">
 	<input type="submit" value="Otsi">	
 </form>
<?php
 //iga liikme kohta masiivis
 
 foreach ($notes as $n) {
	 $style = "width:110px;
				min-height:90px;
				float: left;
				border: 1px solid gray;
				background-color: ".$n->noteColor.";";
	echo "<p style=' ".$style." '>".$n->note ."</p>";
	
 }
 ?>
 <h2 style="clear:both" style="color:white">Tabel</h2>
 <?php
 $html = "<table class='table'>";
 	
 		$html .= "<tr>";
 		
 			$orderId = "ASC";
 			
 			if (isset($_GET["order"]) && 
 				$_GET["order"] == "ASC" && 
 				$_GET["sort"] == "id" ){
 				
 				$orderId = "DESC";
 			}
 		
 			$html .= "<th>
 			
 						<a href='?q=".$q."&sort=id&order=".$orderId."'>
 							id
 						</a>
 					</th>";
					
 			$orderProfession = "ASC";
 			
 			if (isset($_GET["order"]) && 
 				$_GET["order"] == "ASC" && 
 				$_GET["sort"] == "profession" ){
 				
 				$orderProfession = "DESC";
 			}
 		
 			$html .= "<th>
 			
 						<a href='?q=".$q."&sort=profession&order=".$orderProfession."'>
 							Teenus
 						</a>
 					</th>";
					
			$orderLocation = "ASC";
 			
 			if (isset($_GET["order"]) && 
 				$_GET["order"] == "ASC" && 
 				$_GET["sort"] == "location" ){
 				
 				$orderLocation = "DESC";
 			}
 		
 			$html .= "<th>
 			
 						<a href='?q=".$q."&sort=location&order=".$orderLocation."'>
 							Linnaosa
 						</a>
 					</th>";
					
			$orderMoney = "DESC";
 			
 			if (isset($_GET["order"]) && 
 				$_GET["order"] == "DESC" && 
 				$_GET["sort"] == "money" ){
 				
 				$orderMoney = "ASC";
 			}
 		
 			$html .= "<th>
 			
 						<a href='?q=".$q."&sort=money&order=".$orderMoney."'>
 							Eur/h
 						</a>
 					</th>";
			
 			$orderNote = "ASC";
 			
 			if (isset($_GET["order"]) && 
 				$_GET["order"] == "ASC" && 
 				$_GET["sort"] == "note" ){
 				
 				$orderNote = "DESC";
 			}
 		
 			$html .= "<th>
 			
 						<a href='?q=".$q."&sort=note&order=".$orderNote."'>
 							Kirjeldus
 						</a>
 					</th>";
 						
 			
 			
 			$orderColor = "ASC";
 			
 			if (isset($_GET["order"]) && 
 				$_GET["order"] == "ASC" && 
 				$_GET["sort"] == "color" ){
 				
 				$orderColor = "DESC";
 			}
 		
 			$html .= "<th>
 			
 						<a href='?q=".$q."&sort=color&order=".$orderColor."'>
 							Värv
 						</a>
 					</th>";
 					
 	$html .= "</tr>";
 	
	
	foreach ($notes as $note) {
		$style = "color:white";
		$html .="<tr>";
		$html .="<td>".$note ->id."</td>";
		$html .="<td>".$note ->profession."</td>";
		$html .="<td>".$note ->location."</td>";
		$html .="<td>".$note ->money."</td>";
		$html .="<td>".$note ->note."</td>";
		$html .="<td>".$note ->noteColor."</td>";
		$html .="<td><a href='edit.php?id=" .$note->id. "'>edit.php</a></td>";
		$html .="</tr>";
	}
	$html .= "</table>";
	echo $html;
?>

<?php require("footer.php"); ?>