widgetName = JText::translate('VBO_W_ROOMSLOCK_TITLE');
$this->widgetDescr = JText::translate('VBO_W_ROOMSLOCK_DESCR');
$this->widgetId = basename(__FILE__, '.php');
/**
* Define widget and icon and style name.
*
* @since 1.15.0 (J) - 1.5.0 (WP)
*/
$this->widgetIcon = '';
$this->widgetStyleName = 'orange';
}
public function render(VBOMultitaskData $data = null)
{
$dbo = JFactory::getDbo();
$rooms_locked = array();
// clean up the expired pending records
$q = "DELETE FROM `#__vikbooking_tmplock` WHERE `until`<" . time() . ";";
$dbo->setQuery($q);
$dbo->execute();
// get all future rooms locked
$q = "SELECT `lock`.*,`r`.`name`,(SELECT CONCAT_WS(' ',`or`.`t_first_name`,`or`.`t_last_name`) FROM `#__vikbooking_ordersrooms` AS `or` WHERE `lock`.`idorder`=`or`.`idorder` LIMIT 1) AS `nominative` FROM `#__vikbooking_tmplock` AS `lock` LEFT JOIN `#__vikbooking_rooms` `r` ON `lock`.`idroom`=`r`.`id` WHERE `lock`.`until`>".time()." ORDER BY `lock`.`id` DESC;";
$dbo->setQuery($q);
$dbo->execute();
if ($dbo->getNumRows() > 0) {
$rooms_locked = $dbo->loadAssocList();
}
if (!count($rooms_locked) && is_null($data)) {
// do not display any contents in the dashboard, but do it in the multitask panel
return;
}
?>