Forum PHP.pl

[PHP] pobierz, plaintext 
<?php
// funkcja reserve
 
(...)
 
			$this->messages[] = $this->msg;
 
			$this->reservationId[] = $id;  
		}			  
		return $this->messages;
	}
	public function delete()
	{
		$items = count($this->reservationId);
 
(...)
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
public $reservationId;
 
public function __construct()
	{
	$this->reservationId = array();
(...)
}
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
class whatever
{
public $reservationId;
 
public function __construct()
	{
	$this->reservationId = array();
	}
 
public function reserve()
	{
			$this->reservationId[] = 15;
	}
 
	public function delete()
	{
		echo( count($this->reservationId) );
	}
}
 
$w = new whatever;
$w->reserve();
$w->delete();
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
class Reservation
{
	public $msg;
	public $messages;
	public $reservationId;
 
 
	public function __construct()
	{
		$this->msg = NULL;
		$this->messages = array();
		$this->reservationId = array();
	}
 
 
	public function reserve()
	{	
 
		$items = count($this->ObjSelect);
		$i = 0;
 
		while ($i < $items)
		{
 
			if ($k)
			{
...
			}
 
			$this->messages[] = $this->msg;
			$this->reservationId[] = $id;			// zwraca tablice wszystkich id
			$i++;
		}
		return $this->messages;
	}
 
	public function delete()
	{								
		$items = count($this->reservationId);
		print_r($items);		// wyswietla 0 :(
		exit;
 
		$i = 0;
		while ($i < $items)
		{
			mysql_query ("DELETE FROM `reservation` WHERE `Reservation_id` = '".$this->reservationId[$i]."' ");
			$i++;
		}
 
	}
 
 
 
 
 
}
 
 
 
 
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
if(isset($_POST['delete']))
	{
	$oReservation->delete();
	}
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
 
class Reservation
{
 
	public $bReserved;
	public $iObjectId;
	public $iUserId;
	public $StartDate;
	public $StartDatetime;
	public $iStartHour;
	public $iStartMinute;
	public $EndDate;
	public $EndDatetime;
	public $iEndHour;
	public $iEndMinute;
	public $today;
	public $year;
	public $month;
	public $day;
	public $hour;
	public $minutes;
	public $aResult;
	public $ObjSelect;
	public $aSelected;
	public $allReservations;
	public $allReservationsId;
	public $msg;
	public $messages;
	public $reservationId;
	public $insert;
 
	public function __construct()
	{
	$this->bReserved = false;
	$this->iObjectId = ($_POST['Object_id']);
	$this->iUserId = ($_POST['login']);
	$this->StartDate = ($_POST['start_calendar']);
	$this->EndDate = ($_POST['end_calendar']);
	$this->today = getdate();
	$this->year = 2000;
	$this->aResult = array();
	$this->ObjSelect = ($_POST['objSelect']);
	$this->aSelected = array();
	$this->StartDatetime = '';
	$this->iStartHour = ($_POST['startHour']);
	$this->iStartMinute = ($_POST['startMinute']);
	$this->EndDatetime = '';
	$this->iEndHour = ($_POST['endHour']);
	$this->iEndMinute = ($_POST['endMinute']);
	$this->allReservations = mysql_query("SELECT * FROM `reservation`");
	$this->allReservationsId = array();
	$this->msg = NULL;
	$this->messages = array();
	$this->reservationId = array();
	$this->insert = ($_POST['confirm']);
	}
 
	public function getYear()
	{
	$this->year = $this->today[year];
	return $this->year;
	}
 
	public function getMonth()
	{
	$this->month = $this->today[month];
	return $this->month;
	}
 
	public function getDay()
	{
	$this->day = $this->today[mday];
	return $this->day;
	}
 
	public function getHour()
	{
	$this->hour = $this->today[hours];
	return $this->hour;
	}
 
	public function getMinutes()
	{
	$this->minutes = $this->today[minutes];
	return $this->minutes;
	}
 
 
	public function setUser($login)
	{
		$userLogin = $login;
		$query = mysql_query("SELECT `User_login_id` FROM `user_login` WHERE `Login` = '$login'");
		$zm = mysql_fetch_array($query);			
		$this->iUserId = $zm['User_login_id'];
		return $this->iUserId;
	}
 
	public function reserve()
	{	
		$StartTime = $this->iStartHour.':'.$this->iStartMinute.':00';
		$withoutSpaces = str_replace(' ', '', $StartTime);
 
		$this->StartDatetime = $this->StartDate." ".$withoutSpaces;
 
		$EndTime = $this->iEndHour.':'.$this->iEndMinute.':00';
		$withoutSpaces2 = str_replace(' ', '', $EndTime);
 
		$this->EndDatetime = $this->EndDate." ".$withoutSpaces2;
 
 
 
		$items = count($this->ObjSelect);
		$i = 0;
		$id = 0;
 
 
		while ($i < $items)
		{
			$ifResObjExist = mysql_query("SELECT * FROM `reservation` WHERE `Object_id`='".$this->ObjSelect[$i]."' ");
			$catch = mysql_fetch_array($ifResObjExist);
 
			$objName =  mysql_query("SELECT `Name` FROM object WHERE `Object_id`='".$this->ObjSelect[$i]."'");
			$catchName = mysql_fetch_array($objName);
 
			// *** CHECK IF THE OBJECT IS NOT RESERVED 
			$k = 1;
			if ($catch)
			{
				$start = $catch['Start_time'];
				$end = $catch['End_time'];
 
				if ($this->StartDatetime > $start AND $this->StartDatetime < $end)
				{
					$ObjNotToReserve = $this->ObjSelect[$i];
					$this->msg = 'You can not reserve object '.$catchName['Name'];
					$k = 0;
				}
 
				if ($this->EndDatetime > $start AND $this->EndDatetime < $end)
				{
					$ObjNotToReserve = $this->ObjSelect[$i];
					$this->msg = '<BR><b>You can not reserve object '.$catchName['Name'].'<br>';
					$k = 0;
				}
 
			}
 
			if ($k)
			{
				mysql_query( "INSERT INTO `reservation` (`Object_id`, `User_login_id`, `Start_time`, `End_time` ) 
				VALUES ( '".$this->ObjSelect[$i]."','".$this->iUserId."', '".$this->StartDatetime."', '".$this->EndDatetime."') ");
				$id = mysql_insert_id();
				$this->msg = '<br><br>You have reserved object '.$catchName['Name'].
				'<ul type="square"><li>from '.$this->StartDatetime.'<li>to '.$this->EndDatetime.'</ul>';
			}
 
			$this->messages[] = $this->msg;
			$this->reservationId[] = $id;
			$i++;
		}
		return $this->messages;
 
	}
 
	public function delete()
	{
 
		$items = count($this->reservationId);
 
	//	print_r($this->reservationId);
	//	exit;
 
		$i = 0;
		while ($i < $items)
		{
			mysql_query ("DELETE FROM `reservation` WHERE `Reservation_id` = '".$this->reservationId[$i]."' ");
			$i++;
		}
 
	$this->msg = 'You did not reserve any item';
	return $this->msg;
	}
 
 
 
	public function getAllReservationsId()
	{
		while( $aRow = mysql_fetch_array($this->allReservations) )
		{
			$this->allReservationsId[] = $aRow;
		}
		return $this->allReservationsId;
	}
 
 
}
 
 
 
 
?>
[PHP] pobierz, plaintext