| Server IP : 46.105.57.169 / Your IP : 216.73.216.67 Web Server : Apache System : Linux webm002.cluster120.gra.hosting.ovh.net 6.18.42-ovh-vps-grsec-zfs+ #1 SMP PREEMPT_DYNAMIC Wed Aug 5 15:59:48 CEST 2026 x86_64 User : verseaumee ( 152031) PHP Version : 8.5.7 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/verseaumee/ptitsanes/administrator/components/com_solidres/tables/ |
Upload File : |
<?php
/**
------------------------------------------------------------------------
SOLIDRES - Accommodation booking extension for Joomla
------------------------------------------------------------------------
* @author Solidres Team <contact@solidres.com>
* @website https://www.solidres.com
* @copyright Copyright (C) 2013 - 2019 Solidres. All Rights Reserved.
* @license GNU General Public License version 3, or later
------------------------------------------------------------------------
*/
defined('_JEXEC') or die;
/**
* Room table
*
* @package Solidres
* @subpackage Room
* @since 0.1.0
*/
class SolidresTableRoom extends JTable
{
public function __construct(JDatabaseDriver $db)
{
parent::__construct('#__sr_rooms', 'id', $db);
}
/**
* Method to delete a row from the database table by primary key value.
*
* @param mixed An optional primary key value to delete. If not set the
* instance property value is used.
*
* @return boolean True on success.
* @since 1.0
* @link http://docs.joomla.org/JTable/delete
*/
public function delete($pk = null)
{
$query = $this->_db->getQuery(true);
// Take care of relationship with Reservation
$query->update('#__sr_reservation_room_xref')
->set('room_id = NULL')
->where('room_id = ' . $this->_db->quote($pk));
$this->_db->setQuery($query)->execute();
// Take care of relationship with Extra in Reservation
$query->clear();
$query->update('#__sr_reservation_room_extra_xref')
->set('room_id = NULL')
->where('room_id = ' . $this->_db->quote($pk));
$this->_db->setQuery($query)->execute();
if (SRPlugin::isEnabled('limitbooking'))
{
$query->clear();
$query->delete($this->_db->quoteName('#__sr_limit_booking_details'))->where('room_id = ' . (int) $pk);
$this->_db->setQuery($query)->execute();
}
if (SRPlugin::isEnabled('housekeeping'))
{
$query->clear();
$query->delete($this->_db->quoteName('#__sr_housekeeping'))->where('room_id = ' . (int) $pk);
$this->_db->setQuery($query)->execute();
}
// Delete it
return parent::delete($pk);
}
}