This class is meant to be subclassed in order to implement a
specific table in the database.
| public DatabaseObject ( array $p_columnNames = null ) | ||
| $p_columnNames | array | The column names of this table. These are optional. |
/**
* Constructor
* @access public
*/
function EvaluationObjectDB()
{
/* Set default values -------------------------------------------------- */
parent::DatabaseObject();
$this->instanceof = INSTANCEOF_EVALDBOBJECT;
/* --------------------------------------------------------------------- */
}
/**
* A publication represents a magazine or newspaper.
*
* This class is mainly responsible for specifying
* publication-wide configuration parameters.
*
* @param int $p_publicationId
*/
public function Publication($p_publicationId = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['Id'] = $p_publicationId;
if ($this->keyValuesExist()) {
$this->fetch();
}
}
/**
* Constructor.
* @param int $p_id
*/
public function UrlType($p_id = null)
{
parent::DatabaseObject($this->m_columnNames);
if (!is_null($p_id)) {
$this->m_data['Id'] = $p_id;
$this->fetch();
}
}
/**
* Constructor.
* @param int $p_languageId
*/
public function Language($p_languageId = null)
{
parent::DatabaseObject($this->m_columnNames);
if (!is_null($p_languageId)) {
$this->m_data['Id'] = $p_languageId;
$this->fetch();
}
}
/**
* An image is both the orginal image, plus a thumbnail image,
* plus metadata.
*
* @param int $p_imageId
*/
public function Image($p_imageId = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['Id'] = $p_imageId;
if ($this->keyValuesExist()) {
$this->fetch();
}
} // constructor
/**
* This table delays an issue's publish time to a later date.
*
* @param int $p_id
*/
public function IssuePublish($p_id = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['id'] = $p_id;
if ($this->keyValuesExist()) {
$this->fetch();
}
}
/**
* Construct by passing in the primary key to access the article in
* the database.
*
* @param int $p_languageId
* @param int $p_articleNumber
* Not required when creating an article.
*/
function Blog($p_blog_id = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['blog_id'] = $p_blog_id;
if ($this->keyValuesExist()) {
$this->fetch();
$this->m_data['images'] = BlogImageHelper::GetImagePaths('blog', $p_blog_id, true, true);
}
} // constructor
/**
* Constructor.
* @param string $p_code
* @param int $p_languageId
*/
public function Country($p_code = null, $p_languageId = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['Code'] = $p_code;
$this->m_data['IdLanguage'] = $p_languageId;
if ($this->keyValuesExist()) {
$this->fetch();
}
} // constructor
/**
* Construct by passing in the primary key to access the poll in
* the database.
*
* @param int $p_language_id
* Not required if poll_nr is given.
* @param int $p_poll_nr
* Not required when creating an poll.
*/
public function Poll($p_language_id = null, $p_poll_nr = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['fk_language_id'] = $p_language_id;
$this->m_data['poll_nr'] = $p_poll_nr;
if ($this->keyValuesExist()) {
$this->fetch();
}
}
/**
* Construct by passing in the primary key to access the
* debate <-> publication relations
*
* @param int $p_debate_nr
* @param int $p_publication_id
*/
function DebatePublication($p_debate_nr = null, $p_publication_id = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['fk_debate_nr'] = $p_debate_nr;
$this->m_data['fk_publication_id'] = $p_publication_id;
if ($this->keyValuesExist()) {
$this->fetch();
}
}
public function Soundcloud($p_article_id = null, $p_track_id = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['article_id'] = $p_article_id;
$this->m_data['track_id'] = $p_track_id;
if ($this->keyValuesExist()) {
$this->fetch();
}
}
public function SubscriptionDefaultTime($p_countryCode = null, $p_publicationId = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['CountryCode'] = $p_countryCode;
$this->m_data['IdPublication'] = $p_publicationId;
if ($this->keyValuesExist()) {
$this->fetch();
}
} // constructor
public function Phorum_forum($p_forumId = null)
{
global $PHORUM;
$this->m_dbTableName = $PHORUM['forums_table'];
parent::DatabaseObject($this->m_columnNames);
$this->m_data['forum_id'] = $p_forumId;
if (!is_null($p_forumId)) {
$this->fetch();
}
} // constructor
/**
* Constructor
*
* @param string
* $p_userTypeId (optional) The user type identifier
*
* @return void
*/
public function UserType($p_userTypeId = null)
{
parent::DatabaseObject($this->m_columnNames);
if (is_numeric($p_userTypeId) && $p_userTypeId > 0) {
$this->m_data['group_id'] = $p_userTypeId;
if ($this->keyValuesExist()) {
$this->fetch();
}
}
}
/**
* Construct by passing in the primary key to access the
* debateanswer <-> attachment relations
*
* @param int $p_debate_nr
* @param int $p_article_language_id
* @param int $p_article_nr
*/
function DebateAnswerAttachment($p_debate_nr = null, $p_debateanswer_nr = null, $p_attachment_id = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['fk_debate_nr'] = $p_debate_nr;
$this->m_data['fk_debateanswer_nr'] = $p_debateanswer_nr;
$this->m_data['fk_attachment_id'] = $p_attachment_id;
if ($this->keyValuesExist()) {
$this->fetch();
}
}
/**
* Construct by passing in the primary key to access the
* debate <-> publication relations
*
* @param int $p_debate_nr
* @param int $p_article_language_id
* @param int $p_article_nr
*/
function DebateArticle($p_debate_nr = null, $p_article_language_id = null, $p_article_nr = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['fk_debate_nr'] = $p_debate_nr;
$this->m_data['fk_article_language_id'] = $p_article_language_id;
$this->m_data['fk_article_nr'] = $p_article_nr;
if ($this->keyValuesExist()) {
$this->fetch();
}
}
/**
* A user of the system is a frontend reader or a 'admin' user, meaning
* they have login rights to the backend.
*
* @param int $p_userId
*/
public function User($p_userId = null)
{
parent::DatabaseObject($this->m_columnNames);
if (is_numeric($p_userId) && ($p_userId > 0)) {
$this->m_data['Id'] = $p_userId;
if ($this->keyValuesExist()) {
$this->fetch();
}
}
} // constructor
/**
* Construct by passing in the primary key to access the article in
* the database.
*
* @param int $p_languageId
* @param int $p_articleNumber
* Not required when creating an article.
*/
public function Article($p_languageId = null, $p_articleNumber = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['IdLanguage'] = $p_languageId;
$this->m_data['Number'] = $p_articleNumber;
if ($this->keyValuesExist()) {
$this->fetch();
}
$this->m_published = $this->isPublished();
}
/**
* Construct by passing in the primary key to access the
* poll <-> publication relations
*
* @param int $p_poll_nr
* @param int $p_publication_id
*/
function PollPublication($p_poll_nr = null, $p_publication_id = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['fk_poll_nr'] = $p_poll_nr;
$this->m_data['fk_publication_id'] = $p_publication_id;
if ($this->keyValuesExist()) {
$this->fetch();
}
} // constructor
/**
* Construct by passing in the primary key to access the poll answer in
* the database.
*
* @param int $p_fk_language_id
* @param int $p_fk_poll_nr
* @param int $p_nr_answer
*/
function PollAnswer($p_fk_language_id = null, $p_fk_poll_nr = null, $p_nr_answer = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['fk_language_id'] = $p_fk_language_id;
$this->m_data['fk_poll_nr'] = $p_fk_poll_nr;
$this->m_data['nr_answer'] = $p_nr_answer;
if ($this->keyValuesExist()) {
$this->fetch();
}
} // constructor
/**
* A Phorum_message is a message posted to a forum.
*
* @param int $p_messageId
* If specified, the message will be fetched from the database.
* @return Phorum_message
*/
public function Phorum_message($p_messageId = null)
{
global $PHORUM;
$this->m_dbTableName = $PHORUM['message_table'];
parent::DatabaseObject($this->m_columnNames);
$this->m_data["message_id"] = $p_messageId;
if (!is_null($p_messageId)) {
$this->fetch();
}
} // constructor
/**
* A publication has Issues, Issues have Sections and Articles.
* @param int $p_publicationId
* @param int $p_languageId
* @param int $p_issueNumber
*/
public function Issue($p_publicationId = null, $p_languageId = null, $p_issueNumber = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['IdPublication'] = $p_publicationId;
$this->m_data['IdLanguage'] = $p_languageId;
$this->m_data['Number'] = $p_issueNumber;
if ($this->keyValuesExist()) {
$this->fetch();
}
}
/**
* Construct by passing in the primary key to access the
* blogentry <-> topic relations
*
* @param int $p_blogentry_id
* @param int $p_topic_id
*/
function BlogentryTopic($p_blogentry_id = null, $p_topic_id = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['fk_entry_id'] = $p_blogentry_id;
$this->m_data['fk_topic_id'] = $p_topic_id;
if ($this->keyValuesExist()) {
$this->fetch();
}
} // constructor
/**
* Construct by passing in the primary key to access the debate in
* the database.
*
* @param int $p_language_id
* Not required if debate_nr is given.
* @param int $p_debate_nr
* Not required when creating an debate.
*/
public function __construct($p_language_id = null, $p_debate_nr = null, $p_user_id = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['fk_language_id'] = $p_language_id;
$this->m_data['debate_nr'] = $p_debate_nr;
$this->userId = $p_user_id;
if ($this->keyValuesExist()) {
$this->fetch();
}
}
/**
* Subscribers can be subscribed to individual sections of a publication.
*
* @param int $p_subscriptionId
* @param int $p_sectionNumber
* @param int $p_languageId
* @return SubscriptionSection
*/
public function SubscriptionSection($p_subscriptionId = null, $p_sectionNumber = null, $p_languageId = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['IdSubscription'] = $p_subscriptionId;
$this->m_data['SectionNumber'] = $p_sectionNumber;
$this->m_data['IdLanguage'] = $p_languageId;
if ($this->keyValuesExist()) {
$this->fetch();
}
}
public function CampPlugin($p_name = null, $p_version = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['Name'] = $p_name;
if (!is_null($p_version)) {
$this->m_data['Version'] = $p_version;
}
if (!is_null($p_name)) {
$this->fetch();
}
}
/**
* Construct by passing in the primary key to access the
* pollanswer <-> attachment relations
*
* @param int $p_poll_nr
* @param int $p_article_language_id
* @param int $p_article_nr
*/
function PollAnswerAttachment($p_poll_nr = null, $p_pollanswer_nr = null, $p_attachment_id = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['fk_poll_nr'] = $p_poll_nr;
$this->m_data['fk_pollanswer_nr'] = $p_pollanswer_nr;
$this->m_data['fk_attachment_id'] = $p_attachment_id;
if ($this->keyValuesExist()) {
$this->fetch();
}
} // constructor
/**
* Construct by passing in the primary key to access the interview in
* the database.
*
* @param int $p_fk_interview_id
* @param int $p_item_id - not required on creating item
*/
public function __construct($p_fk_interview_id = null, $p_item_id = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['fk_interview_id'] = $p_fk_interview_id;
$this->m_data['item_id'] = $p_item_id;
if ($this->keyValuesExist()) {
$this->fetch();
}
} // constructor
/**
* Construct by passing in the primary key to access the debate answer in
* the database.
*
* @param int $p_fk_language_id
* @param int $p_fk_debate_nr
* @param int $p_nr_answer
*/
public function __construct($p_fk_debate_nr = null, $p_fk_answer_nr = null, $p_fk_user_id = null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['fk_debate_nr'] = $p_fk_debate_nr;
$this->m_data['fk_user_id'] = $p_fk_user_id;
if ($this->keyValuesExist()) {
$this->fetch();
}
if (!is_null($p_fk_answer_nr)) {
$this->m_data['fk_answer_nr'] = $p_fk_answer_nr;
}
}
/**
* Construct by passing in the primary key to access the article in
* the database.
*
* @param int $p_languageId
* @param int $p_articleNumber
* Not required when creating an article.
*/
function BlogComment($p_comment_id=null, $p_entry_id=null)
{
parent::DatabaseObject($this->m_columnNames);
$this->m_data['comment_id'] = $p_comment_id;
if ($this->keyValuesExist()) {
$this->fetch();
} elseif ($p_entry_id) {
$this->m_data['fk_entry_id'] = $p_entry_id;
}
} // constructor
