<?php
	require('LocalRepositoryInterface.php');

	class LocalRepository implements LocalRepositoryInterface {
		protected $db;

		public function __construct($db) {
			$this->db = $db;
		}

		public function registerLocal($local, $password) {
			$hashedPwd = password_hash($password, PASSWORD_DEFAULT);

			$query = "INSERT INTO locale(nominativo, cell, email, nomelocale, descrizione, tipologia, img1, img2, username, password, lat, lon)
    				VALUES ('".$local->nominativo."',
    						'".$local->cell."',
    						'".$local->email."',
    						'".$local->nomelocale."',
    						'".$local->descrizione."',
    						'".$local->tipologia."',
    						'".$local->img1."',
    						'".$local->img2."',
    						'".$local->username."',
    						'".$hashedPwd."',
    						'".$local->lat."',
    						'".$local->lon."')";
			
			//echo "<br/>".$query."<br/>";	

			try {
				$this->db->exec($query);
				return $this->db->lastInsertId();

				//echo "New record created successfully";
			} catch (PDOException $e) {
				echo $e->getMessage();
			}
		}

		public function setLocalPosition($id_local, $lat, $lon) {
			$query = "UPDATE locale
						SET lat=".$lat.",lon=".$lon.
						"WHERE id=".$id_local;

			try {
				return $this->db->exec($query);
			} catch (PDOException $e) {
				echo $e->getMessage();
			}		
		}
	}

?>