interface ISqlAccess  {

	function GetAllItems($number, $search);
	function GetBrands();
	function GetTotalNumberModels($category, $search_string);
	function GetSearchItems($category, $limit, $search);
	function GetSearchItem($item);
	function GetSearchItemHistory($item);
	function GetSearchItemByName($item);
	function GetAllPhones($limit, $sort);
	function GetAllPhonesCount();
	function UpdateDateById($month, $year, $id);
	function UpdateModelPicture($id, $picture);
	function UpdateAddMonthPrice($id, $input_date, $price);
	function DeleteItem($id);
	function UpdateModelName($name, $id);
	function UpdateBrandName($brand_id, $id);
	function AddNewModel();
	function CheckUsername($name);
	function CheckUserEmail($email);
	function AddUserData($userdata);
	function AddItemsToUserId($items, $userId);
	function GetBusketItems($userId);
	function CheckUserLogin($name, $pass);
	function ConfirmUserEmail($hashedName);
	function UpdateUserBasketItems($userId);
	function UpdateUserPassword($user, $pass);
	function GetUserObject($name);
}


class SqlAccess implements ISqlAccess {

	private $db;

	function SqlAccess() {
		 $this->db = Mysql::singleton();
	}

function AddItemsToUserId($items, $userId)
	{
		foreach($items as $key=>$value)
		{
			$query = "insert into t_ordered_items (Id, ModelId, ItemCondition, CanCall, Damaged, Price, Quantity, withAdapter, withBattery, withBox, withCables, UserId, DoneOption)
						values(
							'$value->Id',
							$value->Model,
							$value->Condition,
							$value->Cancall,
							$value->Damaged,
							$value->Price,
							$value->Quantity,
							$value->withAdapter,
							$value->withBattery,
							$value->withBox,
							$value->withCables,
							'$userId',
							$value->DoneOption
						)";
			$dbquery = $this->db->modify($query);
		}
	}

	function GetBusketItems($userId)
	{
		$query = "select * from t_ordered_items where UserId = '$userId'  ";
		$dbquery = $this->db->select($query);
		if($dbquery)
		{
			$result = $dbquery->getArray();
			return $result;
		}

		return array();
	}

	function CheckUserLogin($name, $pass)
	{
		$password = sha1($pass);
		$query = "select * from t_user_data where Username = '$name' and Password = '$password'";
		$dbquery = $this->db->select($query);
		if($dbquery)
		{
			$result = $dbquery->getRow(0);
			return $result;
		}
		return null;
	}

	function ConfirmUserEmail($hashedName)
	{
		$query = "select * from t_user_data where sha1(Username) = '$hashedName'";
		$dbquery = $this->db->select($query);
		if($dbquery)
		{
			$result = $dbquery->getRow(0);

			$query = "update t_user_data set Activate = 1 where sha1(Username) = '$hashedName'";
			$dbquery = $this->db->modify($query);
			$result["Activate"] = "1";

			return $result;
		}
		return null;
	}

	function UpdateUserBasketItems($userId)
	{
		$query = "update t_ordered_items set DoneOption = 1 where UserId = '$userId'";
		$dbquery = $this->db->modify($query);
	}
}