275 lines
7.0 KiB
PHP
275 lines
7.0 KiB
PHP
<?php
|
|
/**
|
|
* @package JEM
|
|
* @copyright (C) 2013-2024 joomlaeventmanager.net
|
|
* @copyright (C) 2005-2009 Christoph Lukes
|
|
* @license https://www.gnu.org/licenses/gpl-3.0 GNU/GPL
|
|
*/
|
|
|
|
defined('_JEXEC') or die;
|
|
|
|
use Joomla\CMS\Table\Table;
|
|
use Joomla\CMS\Language\Text;
|
|
|
|
/**
|
|
* JEM events Model class
|
|
*
|
|
* @package JEM
|
|
*
|
|
*/
|
|
class jem_events extends Table
|
|
{
|
|
/**
|
|
* Primary Key
|
|
* @var int
|
|
*/
|
|
public $id = null;
|
|
/** @var int */
|
|
public $locid = null;
|
|
/** @var date */
|
|
public $dates = null;
|
|
/** @var date */
|
|
public $enddates = null;
|
|
/** @var date */
|
|
public $times = null;
|
|
/** @var date */
|
|
public $endtimes = null;
|
|
/** @var string */
|
|
public $title = '';
|
|
/** @var string */
|
|
public $alias = '';
|
|
/** @var date */
|
|
public $created = null;
|
|
/** @var int */
|
|
public $created_by = null;
|
|
/** @var int */
|
|
public $modified = 0;
|
|
/** @var int */
|
|
public $modified_by = null;
|
|
/** @var int */
|
|
public $version = 0;
|
|
/** @var string */
|
|
public $meta_description = '';
|
|
/** @var string */
|
|
public $meta_keywords = '';
|
|
/**
|
|
* repetition intervall
|
|
*
|
|
* @var int
|
|
*/
|
|
public $recurrence_number = 0;
|
|
/**
|
|
* type of recurrence (daily, weekly, monthly)
|
|
*
|
|
* @var int
|
|
*/
|
|
public $recurrence_type = 0;
|
|
/**
|
|
* occurence counter
|
|
*
|
|
* @var int
|
|
*/
|
|
public $recurrence_counter = 0;
|
|
/**
|
|
* limit counter for repetition
|
|
*
|
|
* @var string
|
|
*/
|
|
public $recurrence_limit = 0;
|
|
/**
|
|
* limit date for repetition
|
|
*
|
|
* @var string
|
|
*/
|
|
public $recurrence_limit_date = null;
|
|
/**
|
|
* list of day the event occurs on (2 letters, separated by comma)
|
|
*
|
|
* @var string
|
|
*/
|
|
public $recurrence_byday = '';
|
|
/** @var int id of first event for recurrence events*/
|
|
public $recurrence_first_id = 0;
|
|
/** @var string */
|
|
public $datimage = '';
|
|
/** @var string */
|
|
public $author_ip = null;
|
|
/** @var int */
|
|
public $published = null;
|
|
/** @var int */
|
|
public $registra = null;
|
|
/** @var int */
|
|
public $unregistra = null;
|
|
/** @var int */
|
|
public $maxplaces = 0;
|
|
/** @var int */
|
|
public $waitinglist = 0;
|
|
/** @var int */
|
|
public $hits = 0;
|
|
/** @var int */
|
|
public $checked_out = null;
|
|
/** @var date */
|
|
public $checked_out_time = null;
|
|
|
|
|
|
public function __construct(& $db)
|
|
{
|
|
parent::__construct('#__jem_events', 'id', $db);
|
|
}
|
|
|
|
/** overloaded check function
|
|
*
|
|
* @return boolean
|
|
*/
|
|
public function check($jemsettings = null)
|
|
{
|
|
// Check fields
|
|
if (empty($this->enddates)) {
|
|
$this->enddates = NULL;
|
|
}
|
|
|
|
if (preg_match("/^:[0-5][0-9](:[0-5][0-9])?$/", $this->times)) {
|
|
$this->_error = Text::_('WRONGSTARTTIMEFORMAT'.': '.$this->times);
|
|
Factory::getApplication()->enqueueMessage($this->_error, 'warning');
|
|
return false;
|
|
}
|
|
if (empty($this->times) || preg_match("/^:[0-5][0-9](:[0-5][0-9])?$/", $this->times)) {
|
|
$this->times = NULL;
|
|
}
|
|
if (preg_match("/^:[0-5][0-9](:[0-5][0-9])?$/", $this->endtimes)) {
|
|
$this->_error = Text::_('WRONGENDTIMEFORMAT'.': '.$this->endtimes);
|
|
Factory::getApplication()->enqueueMessage($this->_error, 'warning');
|
|
return false;
|
|
}
|
|
if (empty($this->endtimes) || empty($this->times) || preg_match("/^:[0-5][0-9](:[0-5][0-9])?$/", $this->endtimes)
|
|
|| preg_match("/^:[0-5][0-9](:[0-5][0-9])?$/", $this->times))
|
|
{
|
|
$this->endtimes = NULL;
|
|
}
|
|
|
|
$this->title = strip_tags(trim($this->title));
|
|
$titlelength = \Joomla\String\StringHelper::strlen($this->title);
|
|
|
|
if ($this->title == '') {
|
|
$this->_error = Text::_('COM_JEM_ADD_TITLE');
|
|
Factory::getApplication()->enqueueMessage($this->_error, 'warning');
|
|
return false;
|
|
}
|
|
|
|
if ($titlelength > 100) {
|
|
$this->_error = Text::_('COM_JEM_ERROR_TITLE_LONG');
|
|
Factory::getApplication()->enqueueMessage($this->_error, 'warning');
|
|
return false;
|
|
}
|
|
|
|
$alias = JFilterOutput::stringURLSafe($this->title);
|
|
|
|
if (empty($this->alias) || $this->alias === $alias) {
|
|
$this->alias = $alias;
|
|
}
|
|
|
|
if ($this->dates && !preg_match("/^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$/", $this->dates)) {
|
|
$this->_error = Text::_('COM_JEM_DATE_WRONG');
|
|
Factory::getApplication()->enqueueMessage($this->_error, 'warning');
|
|
return false;
|
|
}
|
|
|
|
if (isset($this->enddates)) {
|
|
if (!preg_match("/^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$/", $this->enddates)) {
|
|
$this->_error = Text::_('COM_JEM_ENDDATE_WRONG_FORMAT');
|
|
Factory::getApplication()->enqueueMessage($this->_error, 'warning');
|
|
return false;
|
|
}
|
|
}
|
|
|
|
/* if (isset($this->recurrence_limit_date)) {
|
|
if (!preg_match("/^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$/", $this->recurrence_limit_date)) {
|
|
$this->_error = Text::_('COM_JEM_WRONGRECURRENCEDATEFORMAT');
|
|
Factory::getApplication()->enqueueMessage($this->_error, 'warning');
|
|
return false;
|
|
}
|
|
}
|
|
*/
|
|
|
|
if (isset($this->times) && $this->times) {
|
|
if (!preg_match("/^[0-2][0-9]:[0-5][0-9](:[0-5][0-9])?$/", $this->times)) {
|
|
$this->_error = Text::_('WRONGSTARTTIMEFORMAT'.': '.$this->times);
|
|
Factory::getApplication()->enqueueMessage($this->_error, 'warning');
|
|
return false;
|
|
}
|
|
}
|
|
|
|
if (isset($this->endtimes) && $this->endtimes) {
|
|
if (!preg_match("/^[0-2][0-9]:[0-5][0-9](:[0-5][0-9])?$/", $this->endtimes)) {
|
|
$this->_error = Text::_('COM_JEM_WRONGENDTIMEFORMAT');
|
|
Factory::getApplication()->enqueueMessage($this->_error, 'warning');
|
|
return false;
|
|
}
|
|
}
|
|
|
|
//No venue or category choosen?
|
|
//if ($this->locid == '') {
|
|
// $this->_error = Text::_('COM_JEM_VENUE_EMPTY');
|
|
// Factory::getApplication()->enqueueMessage($this->_error, 'warning');
|
|
// return false;
|
|
//}
|
|
|
|
return true;
|
|
}
|
|
|
|
/**
|
|
* try to insert first, update if fails
|
|
*
|
|
* Can be overloaded/supplemented by the child class
|
|
*
|
|
* @access public
|
|
* @param boolean If false, null object variables are not updated
|
|
* @return null|string null if successful otherwise returns and error message
|
|
*/
|
|
public function insertIgnore($updateNulls = false)
|
|
{
|
|
try {
|
|
$ret = $this->_insertIgnoreObject($this->_tbl, $this, $this->_tbl_key);
|
|
} catch (RuntimeException $e){
|
|
$this->setError(get_class($this).'::store failed - '.$e->getMessage());
|
|
return false;
|
|
}
|
|
return true;
|
|
}
|
|
|
|
/**
|
|
* Inserts a row into a table based on an objects properties, ignore if already exists
|
|
*
|
|
* @access protected
|
|
* @param string The name of the table
|
|
* @param object An object whose properties match table fields
|
|
* @param string The name of the primary key. If provided the object property is updated.
|
|
* @return int number of affected row
|
|
*/
|
|
protected function _insertIgnoreObject($table, &$object, $keyName = NULL)
|
|
{
|
|
$fmtsql = 'INSERT IGNORE INTO '.$this->_db->quoteName($table).' (%s) VALUES (%s) ';
|
|
$fields = array();
|
|
foreach (get_object_vars($object) as $k => $v) {
|
|
if (is_array($v) or is_object($v) or $v === NULL) {
|
|
continue;
|
|
}
|
|
if ($k[0] == '_') { // internal field
|
|
continue;
|
|
}
|
|
$fields[] = $this->_db->quoteName($k);
|
|
$values[] = $this->_db->quote($v);
|
|
}
|
|
$this->_db->setQuery(sprintf($fmtsql, implode(",", $fields), implode(",", $values)));
|
|
if ($this->_db->execute() === false) {
|
|
return false;
|
|
}
|
|
$id = $this->_db->insertid();
|
|
if ($keyName && $id) {
|
|
$object->$keyName = $id;
|
|
}
|
|
return $this->_db->getAffectedRows();
|
|
}
|
|
}
|
|
?>
|