ocs  2.3.6
About: OCS (Open Conference System) is a Web publishing tool that will create a complete Web presence for your scholarly conference.
  Fossies Dox: ocs-2.3.6.tar.gz  ("inofficial" and yet experimental doxygen-generated source code documentation)  

DAO Class Reference

Operations for retrieving and modifying objects from a database. More...

Inherited by AccessKeyDAO, AuthorDAO, AuthorSubmissionDAO, AuthSourceDAO, BuildingDAO, CaptchaDAO, CitationDAO, CommentDAO, ConferenceDAO, ConferenceEventLogDAO, ControlledVocabDAO, ControlledVocabEntryDAO, CountryDAO, CurrencyDAO, DirectorSubmissionDAO, EditAssignmentDAO, GroupDAO, GroupMembershipDAO, NotificationDAO, NotificationSettingsDAO, NotificationStatusDAO, OAIDAO, PaperCommentDAO, PaperDAO, PaperEmailLogDAO, PaperEventLogDAO, PaperFileDAO, PaperGalleyDAO, PaperNoteDAO, PaperReportDAO, PaperSearchDAO, PayPalDAO, PKPAnnouncementDAO, PKPAnnouncementTypeDAO, PKPEmailTemplateDAO, PKPUserDAO, PKPUserSettingsDAO, PluginSettingsDAO, PublishedPaperDAO, QueuedPaymentDAO, RegistrantReportDAO, RegistrationDAO, RegistrationOptionDAO, RegistrationTypeDAO, ReviewAssignmentDAO, ReviewerSubmissionDAO, ReviewFormDAO, ReviewFormElementDAO, ReviewFormResponseDAO, ReviewReportDAO, RoleDAO, RoomDAO, RTDAO, SchedConfDAO, SchedConfStatisticsDAO, ScheduledTaskDAO, SessionDAO, SettingsDAO, SignoffDAO, SiteDAO, SiteSettingsDAO, SpecialEventDAO, StaticPagesDAO, SuppFileDAO, TemporaryFileDAO, TimeBlockDAO, TimeZoneDAO, TrackDAO, TrackDirectorsDAO, TrackDirectorSubmissionDAO, and VersionDAO.

Public Member Functions

 DAO ($dataSource=null, $callHooks=true)
 
retrieve ($sql, $params=false, $callHooks=true)
 
retrieveCached ($sql, $params=false, $secsToCache=3600, $callHooks=true)
 
retrieveLimit ($sql, $params=false, $numRows=false, $offset=false, $callHooks=true)
 
retrieveRange ($sql, $params=false, $dbResultRange=null, $callHooks=true)
 
 update ($sql, $params=false, $callHooks=true, $dieOnError=true)
 
 replace ($table, $arrFields, $keyCols)
 
 getInsertId ($table='', $id='', $callHooks=true)
 
 setCacheDir ()
 
 flushCache ()
 
 datetimeToDB ($dt)
 
 dateToDB ($d)
 
 datetimeFromDB ($dt)
 
 dateFromDB ($d)
 
 convertFromDB ($value, $type)
 
 getType ($value)
 
 convertToDB ($value, &$type)
 
 nullOrInt ($value)
 
 getAdditionalFieldNames ()
 
 getLocaleFieldNames ()
 
 updateDataObjectSettings ($tableName, &$dataObject, $idArray)
 
 getDataObjectSettings ($tableName, $idFieldName, $idFieldValue, &$dataObject)
 
 getDriver ()
 
 getDirectionMapping ($direction)
 

Public Attributes

 $_dataSource
 

Detailed Description

Operations for retrieving and modifying objects from a database.

See also
DAORegistry

Definition at line 30 of file DAO.inc.php.

Member Function Documentation

◆ convertFromDB()

◆ convertToDB()

DAO::convertToDB (   $value,
$type 
)

◆ DAO()

DAO::DAO (   $dataSource = null,
  $callHooks = true 
)

Constructor. Initialize the database connection.

Definition at line 38 of file DAO.inc.php.

References HookRegistry\call(), checkPhpVersion(), and DBConnection\getConn().

◆ dateFromDB()

◆ datetimeFromDB()

DAO::datetimeFromDB (   $dt)

Return datetime from DB as ISO datetime string.

Parameters
$dtstring datetime from DB
Returns
string

Definition at line 276 of file DAO.inc.php.

Referenced by SignoffDAO\_fromRow(), PaperDAO\_paperFromRow(), AccessKeyDAO\_returnAccessKeyFromRow(), PKPAnnouncementDAO\_returnAnnouncementFromRow(), CaptchaDAO\_returnCaptchaFromRow(), CommentDAO\_returnCommentFromRow(), EditAssignmentDAO\_returnEditAssignmentFromRow(), PaperGalleyDAO\_returnGalleyFromRow(), OAIDAO\_returnIdentifierFromRow(), PaperEmailLogDAO\_returnLogEntryFromRow(), PaperEventLogDAO\_returnLogEntryFromRow(), ConferenceEventLogDAO\_returnLogEntryFromRow(), PaperCommentDAO\_returnPaperCommentFromRow(), PaperFileDAO\_returnPaperFileFromRow(), PaperNoteDAO\_returnPaperNoteFromRow(), PublishedPaperDAO\_returnPublishedPaperFromRow(), OAIDAO\_returnRecordFromRow(), RegistrationOptionDAO\_returnRegistrationOptionFromRow(), RegistrationTypeDAO\_returnRegistrationTypeFromRow(), ReviewAssignmentDAO\_returnReviewAssignmentFromRow(), ReviewerSubmissionDAO\_returnReviewerSubmissionFromRow(), SchedConfDAO\_returnSchedConfFromRow(), SpecialEventDAO\_returnSpecialEventFromRow(), SuppFileDAO\_returnSuppFileFromRow(), TemporaryFileDAO\_returnTemporaryFileFromRow(), TimeBlockDAO\_returnTimeBlockFromRow(), PKPUserDAO\_returnUserFromRow(), VersionDAO\_returnVersionFromRow(), OAIDAO\getEarliestDatestamp(), ReviewAssignmentDAO\getEarliestNotificationByStage(), ReviewAssignmentDAO\getLastModifiedByStage(), ScheduledTaskDAO\getLastRunTime(), SchedConfStatisticsDAO\getPaperStatistics(), PublishedPaperDAO\getPublishedPaperById(), SchedConfStatisticsDAO\getReviewerStatistics(), TrackDirectorSubmissionDAO\getReviewerStatistics(), RegistrationDAO\isValidRegistrationByDomain(), RegistrationDAO\isValidRegistrationByIP(), and RegistrationDAO\isValidRegistrationByUser().

◆ datetimeToDB()

DAO::datetimeToDB (   $dt)

Return datetime formatted for DB insertion.

Parameters
$dtint/string *nix timestamp or ISO datetime string
Returns
string

Definition at line 258 of file DAO.inc.php.

Referenced by DirectorSubmissionDAO\_getUnfilteredDirectorSubmissions(), TrackDirectorSubmissionDAO\_getUnfilteredTrackDirectorSubmissions(), AccessKeyDAO\deleteExpiredKeys(), AccessKeyDAO\getAccessKey(), AccessKeyDAO\getAccessKeyByKeyHash(), AccessKeyDAO\getAccessKeyByUserId(), CaptchaDAO\getExpiredCaptchas(), TemporaryFileDAO\getExpiredFiles(), OAIDAO\getIdentifiers(), SchedConfStatisticsDAO\getIssueStatistics(), SchedConfStatisticsDAO\getPaperStatistics(), PaperSearchDAO\getPhraseResults(), OAIDAO\getRecords(), RegistrationDAO\getRegistrationsBySchedConfId(), SchedConfStatisticsDAO\getRegistrationStatistics(), SchedConfStatisticsDAO\getReviewerStatistics(), SchedConfStatisticsDAO\getUserStatistics(), AccessKeyDAO\insertAccessKey(), PKPAnnouncementDAO\insertAnnouncement(), CaptchaDAO\insertCaptcha(), CommentDAO\insertComment(), DirectorSubmissionDAO\insertDirectorSubmission(), EditAssignmentDAO\insertEditAssignment(), PaperEmailLogDAO\insertLogEntry(), PaperEventLogDAO\insertLogEntry(), ConferenceEventLogDAO\insertLogEntry(), NotificationDAO\insertNotification(), SignoffDAO\insertObject(), PaperDAO\insertPaper(), PaperCommentDAO\insertPaperComment(), PaperFileDAO\insertPaperFile(), PaperNoteDAO\insertPaperNote(), PublishedPaperDAO\insertPublishedPaper(), QueuedPaymentDAO\insertQueuedPayment(), RegistrationOptionDAO\insertRegistrationOption(), RegistrationTypeDAO\insertRegistrationType(), ReviewAssignmentDAO\insertReviewAssignment(), SchedConfDAO\insertSchedConf(), SpecialEventDAO\insertSpecialEvent(), SuppFileDAO\insertSuppFile(), TemporaryFileDAO\insertTemporaryFile(), TimeBlockDAO\insertTimeBlock(), PayPalDAO\insertTransaction(), PKPUserDAO\insertUser(), VersionDAO\insertVersion(), NotificationDAO\setDateRead(), CommentDAO\updateComment(), EditAssignmentDAO\updateEditAssignment(), ScheduledTaskDAO\updateLastRunTime(), TemporaryFileDAO\updateObject(), PKPAnnouncementDAO\updateObject(), SignoffDAO\updateObject(), AccessKeyDAO\updateObject(), CaptchaDAO\updateObject(), PKPUserDAO\updateObject(), PaperDAO\updatePaper(), PaperCommentDAO\updatePaperComment(), PaperFileDAO\updatePaperFile(), PaperNoteDAO\updatePaperNote(), PublishedPaperDAO\updatePublishedPaper(), QueuedPaymentDAO\updateQueuedPayment(), RegistrationOptionDAO\updateRegistrationOption(), RegistrationTypeDAO\updateRegistrationType(), ReviewAssignmentDAO\updateReviewAssignment(), ReviewerSubmissionDAO\updateReviewerSubmission(), SchedConfDAO\updateSchedConf(), SpecialEventDAO\updateSpecialEvent(), TimeBlockDAO\updateTimeBlock(), and TrackDirectorSubmissionDAO\updateTrackDirectorSubmission().

◆ dateToDB()

◆ flushCache()

DAO::flushCache ( )

Flush the system cache.

Definition at line 248 of file DAO.inc.php.

References setCacheDir().

◆ getAdditionalFieldNames()

DAO::getAdditionalFieldNames ( )

Definition at line 380 of file DAO.inc.php.

References HookRegistry\call(), and checkPhpVersion().

Referenced by updateDataObjectSettings().

◆ getDataObjectSettings()

◆ getDirectionMapping()

◆ getDriver()

DAO::getDriver ( )

Get the driver for this connection.

Returns
string

Definition at line 531 of file DAO.inc.php.

References DBConnection\getInstance().

◆ getInsertId()

DAO::getInsertId (   $table = '',
  $id = '',
  $callHooks = true 
)

Return the last ID inserted in an autonumbered field.

Parameters
$tablestring table name
$idstring the ID/key column in the table
Returns
int

Definition at line 225 of file DAO.inc.php.

Referenced by AccessKeyDAO\getInsertAccessKeyId(), PKPAnnouncementDAO\getInsertAnnouncementId(), AuthorDAO\getInsertAuthorId(), BuildingDAO\getInsertBuildingId(), CaptchaDAO\getInsertCaptchaId(), CommentDAO\getInsertCommentId(), ConferenceDAO\getInsertConferenceId(), EditAssignmentDAO\getInsertEditId(), DirectorSubmissionDAO\getInsertEditId(), PKPEmailTemplateDAO\getInsertEmailId(), PaperGalleyDAO\getInsertGalleyId(), GroupDAO\getInsertGroupId(), PaperEventLogDAO\getInsertLogId(), PaperEmailLogDAO\getInsertLogId(), ConferenceEventLogDAO\getInsertLogId(), NotificationDAO\getInsertNotificationId(), NotificationSettingsDAO\getInsertNotificationSettingId(), PaperCommentDAO\getInsertPaperCommentId(), PaperFileDAO\getInsertPaperFileId(), PaperDAO\getInsertPaperId(), PaperNoteDAO\getInsertPaperNoteId(), PublishedPaperDAO\getInsertPublishedPaperId(), QueuedPaymentDAO\getInsertQueuedPaymentId(), RegistrationDAO\getInsertRegistrationId(), RegistrationOptionDAO\getInsertRegistrationOptionId(), RegistrationTypeDAO\getInsertRegistrationTypeId(), ReviewFormElementDAO\getInsertReviewFormElementId(), ReviewFormDAO\getInsertReviewFormId(), ReviewAssignmentDAO\getInsertReviewId(), RoomDAO\getInsertRoomId(), SchedConfDAO\getInsertSchedConfId(), SpecialEventDAO\getInsertSpecialEventId(), StaticPagesDAO\getInsertStaticPageId(), SuppFileDAO\getInsertSuppFileId(), TemporaryFileDAO\getInsertTemporaryFileId(), TimeBlockDAO\getInsertTimeBlockId(), TrackDAO\getInsertTrackId(), PKPAnnouncementTypeDAO\getInsertTypeId(), PKPUserDAO\getInsertUserId(), RTDAO\insertContext(), PaperSearchDAO\insertKeyword(), PaperSearchDAO\insertObject(), RTDAO\insertSearch(), AuthSourceDAO\insertSource(), RTDAO\insertVersion(), and TrackDirectorSubmissionDAO\updateTrackDirectorSubmission().

◆ getLocaleFieldNames()

DAO::getLocaleFieldNames ( )

Definition at line 393 of file DAO.inc.php.

References HookRegistry\call(), and checkPhpVersion().

Referenced by updateDataObjectSettings().

◆ getType()

DAO::getType (   $value)

Get the type of a value to be stored in the database

Parameters
$valuestring
Returns
string

Definition at line 326 of file DAO.inc.php.

Referenced by convertToDB().

◆ nullOrInt()

DAO::nullOrInt (   $value)

Definition at line 376 of file DAO.inc.php.

Referenced by SignoffDAO\insertObject(), and SignoffDAO\updateObject().

◆ replace()

DAO::replace (   $table,
  $arrFields,
  $keyCols 
)

Insert a row in a table, replacing an existing row if necessary.

Parameters
$tablestring
$arrFieldsarray Associative array of colName => value
$keyColsarray Array of column names that are keys

Definition at line 214 of file DAO.inc.php.

Referenced by updateDataObjectSettings(), SiteSettingsDAO\updateSetting(), ConferenceSettingsDAO\updateSetting(), and SchedConfSettingsDAO\updateSetting().

◆ retrieve()

& DAO::retrieve (   $sql,
  $params = false,
  $callHooks = true 
)

Execute a SELECT SQL statement.

Parameters
$sqlstring the SQL statement
$paramsarray parameters for the SQL statement
Returns
ADORecordSet

Definition at line 62 of file DAO.inc.php.

References HookRegistry\call(), checkPhpVersion(), fatalError(), DBConnection\logQuery(), and Core\microtime().

Referenced by PKPEmailTemplateDAO\_returnLocaleEmailTemplateFromRow(), PKPAnnouncementTypeDAO\announcementTypeExistsByTypeId(), SchedConfDAO\archivedSchedConfsExist(), BuildingDAO\buildingExistsForSchedConf(), RegistrationOptionDAO\checkCode(), RegistrationTypeDAO\checkCode(), PaperNoteDAO\clearAllPaperNotes(), ConferenceDAO\conferenceExistsByPath(), SchedConfDAO\currentSchedConfsExist(), PKPEmailTemplateDAO\customTemplateExistsByKey(), PaperSearchDAO\deletePaperKeywords(), PublishedPaperDAO\deletePublishedPapersByTrackId(), ReviewAssignmentDAO\deleteReviewAssignmentsByPaper(), TrackDirectorsDAO\directorExists(), StaticPagesDAO\duplicatePathExists(), ControlledVocabDAO\enumerate(), PaperGalleyDAO\galleyExistsByFileId(), AccessKeyDAO\getAccessKey(), AccessKeyDAO\getAccessKeyByKeyHash(), AccessKeyDAO\getAccessKeyByUserId(), PaperNoteDAO\getAllPaperNoteFileIds(), PKPAnnouncementDAO\getAnnouncement(), PKPAnnouncementDAO\getAnnouncementAssocId(), PKPAnnouncementDAO\getAnnouncementAssocType(), PKPAnnouncementTypeDAO\getAnnouncementType(), PKPAnnouncementTypeDAO\getAnnouncementTypeAssocId(), PKPAnnouncementTypeDAO\getAnnouncementTypeByTypeName(), PKPAnnouncementTypeDAO\getAnnouncementTypeName(), AuthorDAO\getAuthor(), AuthorDAO\getAuthorIdsByPaper(), AuthorDAO\getAuthorsByPaper(), AuthorSubmissionDAO\getAuthorSubmission(), ReviewAssignmentDAO\getAuthorViewableFilesByStage(), ReviewAssignmentDAO\getAverageQualityRatings(), PKPEmailTemplateDAO\getBaseEmailTemplate(), BuildingDAO\getBuilding(), BuildingDAO\getBuildingSchedConfId(), SignoffDAO\getById(), ControlledVocabDAO\getById(), ControlledVocabEntryDAO\getById(), ControlledVocabDAO\getBySymbolic(), SignoffDAO\getBySymbolic(), ReviewAssignmentDAO\getCancelsAndRegrets(), CaptchaDAO\getCaptcha(), CaptchaDAO\getCaptchasBySessionId(), CitationDAO\getCitation(), CommentDAO\getComment(), CommentDAO\getCommentsByParentId(), CommentDAO\getCommentsByUserId(), ReviewAssignmentDAO\getCompletedReviewCounts(), ConferenceDAO\getConference(), ConferenceDAO\getConferenceByPath(), ConferenceSettingsDAO\getConferenceSettings(), RoleDAO\getConferenceUsersCount(), RTDAO\getContext(), SchedConfDAO\getCurrentSchedConfs(), VersionDAO\getCurrentVersion(), getDataObjectSettings(), AuthSourceDAO\getDefaultSource(), EditAssignmentDAO\getDirectorAssignmentsByPaperId(), AuthorSubmissionDAO\getDirectorDecisions(), ReviewerSubmissionDAO\getDirectorDecisions(), DirectorSubmissionDAO\getDirectorDecisions(), TrackDirectorSubmissionDAO\getDirectorDecisions(), TrackDirectorsDAO\getDirectorsByTrackId(), TrackDirectorsDAO\getDirectorsNotInTrack(), EditAssignmentDAO\getDirectorStatistics(), DirectorSubmissionDAO\getDirectorSubmission(), DirectorSubmissionDAO\getDirectorSubmissionsCount(), TrackDAO\getDirectorTracks(), OAIDAO\getEarliestDatestamp(), ReviewAssignmentDAO\getEarliestNotificationByStage(), EditAssignmentDAO\getEditAssignment(), EditAssignmentDAO\getEditAssignmentsByPaperId(), EditAssignmentDAO\getEditAssignmentsByUserId(), PKPEmailTemplateDAO\getEmailTemplate(), PKPEmailTemplateDAO\getEmailTemplates(), ConferenceDAO\getEnabledConferences(), SchedConfDAO\getEnabledSchedConfs(), CaptchaDAO\getExpiredCaptchas(), TemporaryFileDAO\getExpiredFiles(), ConferenceDAO\getFreshestConference(), PaperGalleyDAO\getGalley(), PaperGalleyDAO\getGalleyImages(), PaperGalleyDAO\getGalleysByPaper(), GroupDAO\getGroup(), OAIDAO\getIdentifiers(), ReviewAssignmentDAO\getIncompleteReviewAssignments(), AuthorSubmissionDAO\getIncompleteSubmissions(), SchedConfStatisticsDAO\getIssueStatistics(), ReviewAssignmentDAO\getLastModifiedByStage(), ScheduledTaskDAO\getLastRunTime(), PKPEmailTemplateDAO\getLocaleEmailTemplate(), PaperEmailLogDAO\getLogEntry(), PaperEventLogDAO\getLogEntry(), ConferenceEventLogDAO\getLogEntry(), NotificationSettingsDAO\getMailList(), NotificationSettingsDAO\getMailListSettingId(), TrackDirectorSubmissionDAO\getMaxReviewStage(), GroupMembershipDAO\getMembership(), PKPAnnouncementDAO\getMostRecentAnnouncementByAssocId(), PaperGalleyDAO\getNextGalleySequence(), SuppFileDAO\getNextSuppFileSequence(), NotificationStatusDAO\getNotifiableUsersBySchedConfId(), NotificationStatusDAO\getNotifiableUsersCount(), NotificationDAO\getNotificationById(), NotificationSettingsDAO\getNotificationEmailSettings(), NotificationSettingsDAO\getNotificationSettings(), PaperDAO\getPaper(), PaperCommentDAO\getPaperCommentById(), PaperCommentDAO\getPaperComments(), PaperCommentDAO\getPaperCommentsByUserId(), PaperFileDAO\getPaperFile(), PaperFileDAO\getPaperFileRevisions(), PaperFileDAO\getPaperFileRevisionsInRange(), PaperFileDAO\getPaperFilesByPaper(), PaperNoteDAO\getPaperNoteById(), PaperReportDAO\getPaperReport(), PaperDAO\getPapersBySchedConfId(), PaperDAO\getPapersByUserId(), PaperDAO\getPaperSchedConfId(), SchedConfStatisticsDAO\getPaperStatistics(), PublishedPaperDAO\getPaperYearRange(), PluginSettingsDAO\getPluginSettings(), PublishedPaperDAO\getPublishedPaperAuthors(), PublishedPaperDAO\getPublishedPaperById(), PublishedPaperDAO\getPublishedPaperByPaperId(), PublishedPaperDAO\getPublishedPaperByPublicPaperId(), PublishedPaperDAO\getPublishedPaperCountBySchedConfId(), PublishedPaperDAO\getPublishedPapers(), PublishedPaperDAO\getPublishedPapersByTrackId(), AuthorDAO\getPublishedPapersForAuthor(), PublishedPaperDAO\getPublishedPapersInTracks(), QueuedPaymentDAO\getQueuedPayment(), NotificationDAO\getReadNotificationCount(), OAIDAO\getRecord(), OAIDAO\getRecords(), RegistrationDAO\getRegisteredUserCount(), RegistrantReportDAO\getRegistrantReport(), RegistrationDAO\getRegistration(), RegistrationDAO\getRegistrationIdByUser(), RegistrationOptionDAO\getRegistrationOption(), RegistrationTypeDAO\getRegistrationOptionCosts(), RegistrationOptionDAO\getRegistrationOptionName(), RegistrationOptionDAO\getRegistrationOptions(), RegistrationOptionDAO\getRegistrationOptionSchedConfId(), RegistrationDAO\getRegistrationSchedConfId(), SchedConfStatisticsDAO\getRegistrationStatistics(), RegistrationTypeDAO\getRegistrationType(), RegistrationTypeDAO\getRegistrationTypeInstitutional(), RegistrationTypeDAO\getRegistrationTypeMembership(), RegistrationTypeDAO\getRegistrationTypeName(), RegistrationTypeDAO\getRegistrationTypePublic(), RegistrationTypeDAO\getRegistrationTypeSchedConfId(), ReviewFormElementDAO\getRequiredReviewFormElementIds(), ReviewAssignmentDAO\getReviewAssignment(), ReviewAssignmentDAO\getReviewAssignmentById(), ReviewAssignmentDAO\getReviewAssignmentsByPaperId(), ReviewAssignmentDAO\getReviewAssignmentsByReviewFormId(), ReviewAssignmentDAO\getReviewAssignmentsByUserId(), TrackDirectorSubmissionDAO\getReviewersNotAssignedToPaper(), SchedConfStatisticsDAO\getReviewerStatistics(), TrackDirectorSubmissionDAO\getReviewerStatistics(), ReviewerSubmissionDAO\getReviewerSubmission(), ReviewAssignmentDAO\getReviewFilesByStage(), ReviewFormDAO\getReviewForm(), ReviewFormElementDAO\getReviewFormElement(), ReviewFormElementDAO\getReviewFormElements(), ReviewFormResponseDAO\getReviewFormResponse(), ReviewAssignmentDAO\getReviewIndexesForStage(), ReviewReportDAO\getReviewReport(), PaperFileDAO\getRevisionNumber(), RoleDAO\getRole(), RoleDAO\getRolesByConferenceId(), RoleDAO\getRolesByUserId(), RoomDAO\getRoom(), RoomDAO\getRoomBuildingId(), RoomDAO\getRoomSchedConfId(), CommentDAO\getRootCommentsByPaperId(), NotificationSettingsDAO\getRSSTokenByUserId(), SchedConfDAO\getSchedConf(), SchedConfDAO\getSchedConfByPath(), NotificationStatusDAO\getSchedConfNotifications(), SchedConfSettingsDAO\getSchedConfSettings(), RoleDAO\getSchedConfUsersCount(), RTDAO\getSearch(), SessionDAO\getSession(), PKPUserSettingsDAO\getSetting(), PKPUserSettingsDAO\getSettingsByAssoc(), SiteDAO\getSite(), SiteSettingsDAO\getSiteSettings(), AuthSourceDAO\getSource(), SpecialEventDAO\getSpecialEvent(), SpecialEventDAO\getSpecialEventSchedConfId(), StaticPagesDAO\getStaticPage(), StaticPagesDAO\getStaticPageByPath(), ReviewerSubmissionDAO\getSubmissionsCount(), AuthorSubmissionDAO\getSubmissionsCount(), SuppFileDAO\getSuppFile(), SuppFileDAO\getSuppFileByPublicSuppFileId(), SuppFileDAO\getSuppFilesByPaper(), TimeBlockDAO\getTimeBlock(), TimeBlockDAO\getTimeBlockSchedConfId(), OAIDAO\getToken(), TrackDAO\getTrack(), TrackDAO\getTrackByAbbrev(), TrackDAO\getTrackByTitle(), TrackDAO\getTrackByTitleAndAbbrev(), EditAssignmentDAO\getTrackDirectorAssignmentsByPaperId(), TrackDirectorSubmissionDAO\getTrackDirectorSubmission(), TrackDirectorSubmissionDAO\getTrackDirectorSubmissionsCount(), TrackDAO\getTracksBySchedConfId(), TrackDirectorsDAO\getTracksByUserId(), NotificationDAO\getUnreadNotificationCount(), PKPUserDAO\getUser(), PKPUserDAO\getUserByAuthStr(), PKPUserDAO\getUserByCredentials(), PKPUserDAO\getUserByEmail(), PKPUserDAO\getUserByUsername(), PKPUserDAO\getUserEmail(), PKPUserDAO\getUserFullName(), NotificationSettingsDAO\getUserIdByRSSToken(), PKPUserSettingsDAO\getUsersBySetting(), SchedConfStatisticsDAO\getUserStatistics(), RTDAO\getVersion(), VersionDAO\getVersionHistory(), PaperDAO\incompleteSubmissionExists(), PaperSearchDAO\insertKeyword(), PaperSearchDAO\insertObject(), OAIDAO\insertToken(), RegistrationDAO\isValidRegistrationByDomain(), RegistrationDAO\isValidRegistrationByIP(), RegistrationDAO\isValidRegistrationByUser(), NotificationDAO\notificationAlreadyExists(), RegistrationOptionDAO\openRegistrationOptionExistsByOptionId(), RegistrationTypeDAO\openRegistrationTypeExistsByTypeId(), PublishedPaperDAO\publicPaperIdExists(), OAIDAO\recordExists(), RegistrationDAO\registrationExistsByUser(), RegistrationOptionDAO\registrationOptionExistsByOptionId(), RegistrationTypeDAO\registrationTypeExistsByTypeId(), ControlledVocabEntryDAO\resequence(), AuthorDAO\resequenceAuthors(), ConferenceDAO\resequenceConferences(), RTDAO\resequenceContexts(), PaperGalleyDAO\resequenceGalleys(), GroupDAO\resequenceGroups(), GroupMembershipDAO\resequenceMemberships(), PublishedPaperDAO\resequencePublishedPapers(), RegistrationOptionDAO\resequenceRegistrationOptions(), RegistrationTypeDAO\resequenceRegistrationTypes(), ReviewFormElementDAO\resequenceReviewFormElements(), ReviewFormDAO\resequenceReviewForms(), SchedConfDAO\resequenceSchedConfs(), RTDAO\resequenceSearches(), SuppFileDAO\resequenceSuppFiles(), TrackDAO\resequenceTracks(), NotificationSettingsDAO\resetPassword(), retrieveRange(), TrackDirectorSubmissionDAO\reviewerExists(), ReviewFormElementDAO\reviewFormElementExists(), ReviewFormDAO\reviewFormExists(), ReviewFormResponseDAO\reviewFormResponseExists(), TrackDirectorSubmissionDAO\reviewStageExists(), RoleDAO\roleExists(), SchedConfDAO\schedConfExistsByPath(), SessionDAO\sessionExistsById(), SpecialEventDAO\specialEventExistsForSchedConf(), NotificationSettingsDAO\subscribeGuest(), SuppFileDAO\suppFileExistsByFileId(), SuppFileDAO\suppFileExistsByPublicId(), PKPEmailTemplateDAO\templateExistsByKey(), TimeBlockDAO\timeBlockExistsForSchedConf(), TimeBlockDAO\timeBlocksExistForSchedConf(), TrackDAO\trackExists(), PayPalDAO\transactionExists(), NotificationSettingsDAO\unsubscribeGuest(), ReviewFormDAO\unusedReviewFormExists(), ScheduledTaskDAO\updateLastRunTime(), PKPEmailTemplateDAO\updateLocaleEmailTemplateData(), PluginSettingsDAO\updateSetting(), PKPUserSettingsDAO\updateSetting(), PKPUserDAO\userExistsByEmail(), PKPUserDAO\userExistsById(), and PKPUserDAO\userExistsByUsername().

◆ retrieveCached()

& DAO::retrieveCached (   $sql,
  $params = false,
  $secsToCache = 3600,
  $callHooks = true 
)

Execute a cached SELECT SQL statement.

Parameters
$sqlstring the SQL statement
$paramsarray parameters for the SQL statement
Returns
ADORecordSet

Definition at line 91 of file DAO.inc.php.

References HookRegistry\call(), checkPhpVersion(), fatalError(), DBConnection\logQuery(), Core\microtime(), and setCacheDir().

Referenced by PaperSearchDAO\getPhraseResults(), PublishedPaperDAO\getPublishedPaperIdsAlphabetizedBySchedConf(), and PublishedPaperDAO\getPublishedPaperIdsAlphabetizedByTitle().

◆ retrieveLimit()

& DAO::retrieveLimit (   $sql,
  $params = false,
  $numRows = false,
  $offset = false,
  $callHooks = true 
)

Execute a SELECT SQL statement with LIMIT on the rows returned.

Parameters
$sqlstring the SQL statement
$paramsarray parameters for the SQL statement
$numRowsint maximum number of rows to return in the result set
$offsetint row offset in the result set
Returns
ADORecordSet

Definition at line 124 of file DAO.inc.php.

References HookRegistry\call(), checkPhpVersion(), fatalError(), DBConnection\logQuery(), and Core\microtime().

Referenced by PaperCommentDAO\getMostRecentPaperComment(), PaperFileDAO\getPaperFile(), and TemporaryFileDAO\getTemporaryFile().

◆ retrieveRange()

& DAO::retrieveRange (   $sql,
  $params = false,
  $dbResultRange = null,
  $callHooks = true 
)

Execute a SELECT SQL statment, returning rows in the range supplied.

Parameters
$sqlstring the SQL statement
$paramsarray parameters for the SQL statement
$dbResultRangeobject the DBResultRange object describing the desired range

Definition at line 152 of file DAO.inc.php.

References HookRegistry\call(), checkPhpVersion(), fatalError(), DBConnection\logQuery(), Core\microtime(), and retrieve().

Referenced by DirectorSubmissionDAO\_getUnfilteredDirectorSubmissions(), TrackDirectorSubmissionDAO\_getUnfilteredTrackDirectorSubmissions(), ReviewFormDAO\getActiveByAssocId(), PKPAnnouncementDAO\getAnnouncementsByAssocId(), AnnouncementDAO\getAnnouncementsByConferenceId(), PKPAnnouncementDAO\getAnnouncementsByTypeId(), PKPAnnouncementDAO\getAnnouncementsNotExpiredByAssocId(), AnnouncementDAO\getAnnouncementsNotExpiredByConferenceId(), PKPAnnouncementTypeDAO\getAnnouncementTypesByAssocId(), AuthorDAO\getAuthorsAlphabetizedBySchedConf(), AuthorSubmissionDAO\getAuthorSubmissions(), BuildingDAO\getBuildingsBySchedConfId(), ReviewFormDAO\getByAssocId(), ControlledVocabEntryDAO\getByControlledVocabId(), NotificationDAO\getByUserId(), CitationDAO\getCitationsByAssocId(), ConferenceEventLogDAO\getConferenceLogEntriesByAssoc(), ConferenceDAO\getConferences(), TrackDAO\getConferenceTracks(), RTDAO\getContexts(), PKPEmailTemplateDAO\getEmailTemplates(), GroupDAO\getGroups(), GroupMembershipDAO\getMemberships(), PKPAnnouncementDAO\getNumAnnouncementsByAssocId(), PKPAnnouncementDAO\getNumAnnouncementsNotExpiredByAssocId(), AnnouncementDAO\getNumAnnouncementsNotExpiredByConferenceId(), PaperEmailLogDAO\getPaperLogEntriesByAssoc(), PaperEventLogDAO\getPaperLogEntriesByAssoc(), PaperNoteDAO\getPaperNotes(), PaperNoteDAO\getPaperNotesByUserId(), PublishedPaperDAO\getPublishedPapersBySchedConfId(), RegistrationDAO\getRegisteredUsers(), RegistrationOptionDAO\getRegistrationOptionsBySchedConfId(), RegistrationDAO\getRegistrationsBySchedConfId(), RegistrationDAO\getRegistrationsByUser(), RegistrationTypeDAO\getRegistrationTypesBySchedConfId(), TrackDirectorSubmissionDAO\getReviewersForPaper(), ReviewerSubmissionDAO\getReviewerSubmissionsByReviewerId(), ReviewFormElementDAO\getReviewFormElementsByReviewForm(), ReviewFormResponseDAO\getReviewReviewFormResponseValues(), RoomDAO\getRoomsByBuildingId(), SchedConfDAO\getSchedConfs(), SchedConfDAO\getSchedConfsByConferenceId(), TrackDAO\getSchedConfTracks(), RTDAO\getSearches(), AuthSourceDAO\getSources(), SpecialEventDAO\getSpecialEventsBySchedConfId(), StaticPagesDAO\getStaticPagesByConferenceId(), TimeBlockDAO\getTimeBlocksBySchedConfId(), ReviewFormDAO\getUnusedByAssocId(), ReviewFormDAO\getUsedByAssocId(), RoleDAO\getUsersByConferenceId(), PKPUserDAO\getUsersByField(), RoleDAO\getUsersByRoleId(), RoleDAO\getUsersBySchedConfId(), DirectorSubmissionDAO\getUsersNotAssignedToPaper(), PKPUserDAO\getUsersWithNoRole(), RTDAO\getVersions(), and VersionDAO\getVersions().

◆ setCacheDir()

DAO::setCacheDir ( )

Configure the caching directory for database results NOTE: This is implemented as a GLOBAL setting and cannot be set on a per-connection basis.

Definition at line 234 of file DAO.inc.php.

References CacheManager\getFileCachePath().

Referenced by flushCache(), and retrieveCached().

◆ update()

DAO::update (   $sql,
  $params = false,
  $callHooks = true,
  $dieOnError = true 
)

Execute an INSERT, UPDATE, or DELETE SQL statement.

Parameters
$sqlthe SQL statement the execute
$paramsan array of parameters for the SQL statement
$callHooksboolean Whether or not to call hooks
$dieOnErrorboolean Whether or not to die if an error occurs
Returns
boolean

Definition at line 186 of file DAO.inc.php.

References HookRegistry\call(), checkPhpVersion(), fatalError(), DBConnection\logQuery(), and Core\microtime().

Referenced by PaperDAO\changePaperStatus(), OAIDAO\clearTokens(), NotificationSettingsDAO\confirmMailListSubscription(), TrackDirectorSubmissionDAO\createReviewStage(), CommentDAO\decrementChildCount(), AccessKeyDAO\deleteAccessKeyById(), SessionDAO\deleteAllSessions(), PKPAnnouncementDAO\deleteAnnouncementById(), PKPAnnouncementTypeDAO\deleteAnnouncementTypeById(), AuthorDAO\deleteAuthorById(), BuildingDAO\deleteBuildingById(), ReviewFormResponseDAO\deleteById(), ReviewFormElementDAO\deleteById(), ReviewFormDAO\deleteById(), ReviewFormResponseDAO\deleteByReviewFormElementId(), ReviewFormResponseDAO\deleteByReviewId(), CitationDAO\deleteCitationById(), CommentDAO\deleteComment(), CommentDAO\deleteCommentsByPaper(), ConferenceDAO\deleteConferenceById(), ConferenceEventLogDAO\deleteConferenceLogEntries(), RTDAO\deleteContext(), TrackDirectorSubmissionDAO\deleteDecisionsByPaper(), PKPEmailTemplateDAO\deleteDefaultEmailTemplatesByLocale(), TrackDirectorsDAO\deleteDirector(), TrackDirectorsDAO\deleteDirectorsBySchedConfId(), TrackDirectorsDAO\deleteDirectorsByTrackId(), TrackDirectorsDAO\deleteDirectorsByUserId(), EditAssignmentDAO\deleteEditAssignmentById(), EditAssignmentDAO\deleteEditAssignmentsByPaper(), PKPEmailTemplateDAO\deleteEmailTemplateByKey(), PKPEmailTemplateDAO\deleteEmailTemplatesByAssoc(), PKPEmailTemplateDAO\deleteEmailTemplatesByLocale(), AccessKeyDAO\deleteExpiredKeys(), PaperGalleyDAO\deleteGalleyById(), PaperGalleyDAO\deleteGalleyImage(), GroupDAO\deleteGroupById(), PaperGalleyDAO\deleteImagesByGalley(), PaperEventLogDAO\deleteLogEntry(), PaperEmailLogDAO\deleteLogEntry(), ConferenceEventLogDAO\deleteLogEntry(), GroupMembershipDAO\deleteMembershipByGroupId(), GroupMembershipDAO\deleteMembershipById(), GroupMembershipDAO\deleteMembershipByUserId(), NotificationDAO\deleteNotificationById(), NotificationStatusDAO\deleteNotificationStatusBySchedConf(), NotificationStatusDAO\deleteNotificationStatusByUserId(), CaptchaDAO\deleteObject(), AuthSourceDAO\deleteObject(), ControlledVocabEntryDAO\deleteObjectById(), ControlledVocabDAO\deleteObjectById(), SignoffDAO\deleteObjectById(), PaperDAO\deletePaperById(), PaperCommentDAO\deletePaperCommentById(), PaperCommentDAO\deletePaperComments(), PaperFileDAO\deletePaperFileById(), PaperFileDAO\deletePaperFiles(), PaperSearchDAO\deletePaperKeywords(), PaperEventLogDAO\deletePaperLogEntries(), PaperEmailLogDAO\deletePaperLogEntries(), PaperNoteDAO\deletePaperNoteById(), PublishedPaperDAO\deletePublishedPaperById(), PublishedPaperDAO\deletePublishedPaperByPaperId(), PublishedPaperDAO\deletePublishedPapersBySchedConfId(), PublishedPaperDAO\deletePublishedPapersByTrackId(), QueuedPaymentDAO\deleteQueuedPayment(), RegistrationDAO\deleteRegistrationById(), RegistrationDAO\deleteRegistrationByTypeId(), RegistrationDAO\deleteRegistrationByUserIdSchedConf(), RegistrationOptionDAO\deleteRegistrationOptionAssocByOptionId(), RegistrationOptionDAO\deleteRegistrationOptionAssocByRegistrationId(), RegistrationOptionDAO\deleteRegistrationOptionById(), RegistrationTypeDAO\deleteRegistrationOptionCosts(), RegistrationDAO\deleteRegistrationsBySchedConf(), RegistrationDAO\deleteRegistrationsByUserId(), RegistrationTypeDAO\deleteRegistrationTypeById(), ReviewAssignmentDAO\deleteReviewAssignmentById(), ReviewAssignmentDAO\deleteReviewAssignmentsByPaper(), TrackDirectorSubmissionDAO\deleteReviewStagesByPaper(), RoleDAO\deleteRole(), RoleDAO\deleteRoleByConferenceId(), RoleDAO\deleteRoleBySchedConfId(), RoleDAO\deleteRoleByUserId(), RoomDAO\deleteRoomById(), SchedConfDAO\deleteSchedConfById(), RTDAO\deleteSearch(), RTDAO\deleteSearchesByContextId(), SessionDAO\deleteSessionById(), SessionDAO\deleteSessionByLastUsed(), SessionDAO\deleteSessionsByUserId(), ConferenceSettingsDAO\deleteSetting(), SiteSettingsDAO\deleteSetting(), SchedConfSettingsDAO\deleteSetting(), PluginSettingsDAO\deleteSetting(), ReviewFormElementDAO\deleteSetting(), PKPUserSettingsDAO\deleteSetting(), PKPUserSettingsDAO\deleteSettings(), ConferenceSettingsDAO\deleteSettingsByConference(), PluginSettingsDAO\deleteSettingsByConferenceId(), PluginSettingsDAO\deleteSettingsByPlugin(), SchedConfSettingsDAO\deleteSettingsBySchedConf(), SpecialEventDAO\deleteSpecialEventById(), StaticPagesDAO\deleteStaticPageById(), SuppFileDAO\deleteSuppFileById(), TemporaryFileDAO\deleteTemporaryFileById(), TemporaryFileDAO\deleteTemporaryFilesByUserId(), TimeBlockDAO\deleteTimeBlockById(), TrackDAO\deleteTrackById(), PKPUserDAO\deleteUserById(), RTDAO\deleteVersion(), VersionDAO\disableVersion(), CommentDAO\incrementChildCount(), PaperGalleyDAO\incrementViews(), PublishedPaperDAO\incrementViewsByPaperId(), AccessKeyDAO\insertAccessKey(), PKPAnnouncementDAO\insertAnnouncement(), PKPAnnouncementTypeDAO\insertAnnouncementType(), AuthorDAO\insertAuthor(), PKPEmailTemplateDAO\insertBaseEmailTemplate(), BuildingDAO\insertBuilding(), CaptchaDAO\insertCaptcha(), CitationDAO\insertCitation(), CommentDAO\insertComment(), ConferenceDAO\insertConference(), RTDAO\insertContext(), TrackDirectorsDAO\insertDirector(), DirectorSubmissionDAO\insertDirectorSubmission(), EditAssignmentDAO\insertEditAssignment(), PaperGalleyDAO\insertGalley(), PaperGalleyDAO\insertGalleyImage(), GroupDAO\insertGroup(), PaperSearchDAO\insertKeyword(), PaperEmailLogDAO\insertLogEntry(), PaperEventLogDAO\insertLogEntry(), ConferenceEventLogDAO\insertLogEntry(), GroupMembershipDAO\insertMembership(), NotificationSettingsDAO\insertNewRSSToken(), NotificationDAO\insertNotification(), ReviewFormResponseDAO\insertObject(), ControlledVocabDAO\insertObject(), ReviewFormElementDAO\insertObject(), ControlledVocabEntryDAO\insertObject(), SignoffDAO\insertObject(), ReviewFormDAO\insertObject(), PaperSearchDAO\insertObject(), PaperSearchDAO\insertObjectKeyword(), PaperDAO\insertPaper(), PaperCommentDAO\insertPaperComment(), PaperFileDAO\insertPaperFile(), PaperNoteDAO\insertPaperNote(), PublishedPaperDAO\insertPublishedPaper(), QueuedPaymentDAO\insertQueuedPayment(), RegistrationDAO\insertRegistration(), RegistrationOptionDAO\insertRegistrationOption(), RegistrationOptionDAO\insertRegistrationOptionAssoc(), RegistrationTypeDAO\insertRegistrationOptionCost(), RegistrationTypeDAO\insertRegistrationType(), ReviewAssignmentDAO\insertReviewAssignment(), RoleDAO\insertRole(), RoomDAO\insertRoom(), SchedConfDAO\insertSchedConf(), RTDAO\insertSearch(), SessionDAO\insertSession(), SiteDAO\insertSite(), AuthSourceDAO\insertSource(), SpecialEventDAO\insertSpecialEvent(), StaticPagesDAO\insertStaticPage(), SuppFileDAO\insertSuppFile(), TemporaryFileDAO\insertTemporaryFile(), TimeBlockDAO\insertTimeBlock(), OAIDAO\insertToken(), TrackDAO\insertTrack(), PayPalDAO\insertTransaction(), PKPUserDAO\insertUser(), VersionDAO\insertVersion(), RTDAO\insertVersion(), PKPEmailTemplateDAO\installEmailTemplateData(), PKPEmailTemplateDAO\installEmailTemplates(), PaperDAO\removePapersFromTrack(), ControlledVocabEntryDAO\resequence(), AuthorDAO\resequenceAuthors(), ConferenceDAO\resequenceConferences(), RTDAO\resequenceContexts(), PaperGalleyDAO\resequenceGalleys(), GroupDAO\resequenceGroups(), GroupMembershipDAO\resequenceMemberships(), PublishedPaperDAO\resequencePublishedPapers(), RegistrationOptionDAO\resequenceRegistrationOptions(), RegistrationTypeDAO\resequenceRegistrationTypes(), ReviewFormElementDAO\resequenceReviewFormElements(), ReviewFormDAO\resequenceReviewForms(), SchedConfDAO\resequenceSchedConfs(), RTDAO\resequenceSearches(), SuppFileDAO\resequenceSuppFiles(), TrackDAO\resequenceTracks(), NotificationDAO\setDateRead(), AuthSourceDAO\setDefault(), NotificationStatusDAO\setSchedConfNotifications(), NotificationSettingsDAO\subscribeGuest(), AccessKeyDAO\transferAccessKeys(), ConferenceEventLogDAO\transferConferenceLogEntries(), DirectorSubmissionDAO\transferDirectorDecisions(), PaperEventLogDAO\transferPaperLogEntries(), PaperEmailLogDAO\transferPaperLogEntries(), NotificationSettingsDAO\unsubscribeGuest(), AuthorDAO\updateAuthor(), PKPEmailTemplateDAO\updateBaseEmailTemplate(), BuildingDAO\updateBuilding(), CitationDAO\updateCitation(), CommentDAO\updateComment(), ConferenceDAO\updateConference(), RTDAO\updateContext(), updateDataObjectSettings(), EditAssignmentDAO\updateEditAssignment(), PaperGalleyDAO\updateGalley(), ScheduledTaskDAO\updateLastRunTime(), PKPEmailTemplateDAO\updateLocaleEmailTemplateData(), NotificationSettingsDAO\updateNotificationEmailSettings(), NotificationSettingsDAO\updateNotificationSettings(), SessionDAO\updateObject(), SiteDAO\updateObject(), TemporaryFileDAO\updateObject(), ReviewFormResponseDAO\updateObject(), ControlledVocabDAO\updateObject(), ReviewFormElementDAO\updateObject(), GroupMembershipDAO\updateObject(), PKPAnnouncementDAO\updateObject(), SignoffDAO\updateObject(), GroupDAO\updateObject(), AccessKeyDAO\updateObject(), ControlledVocabEntryDAO\updateObject(), AuthSourceDAO\updateObject(), CaptchaDAO\updateObject(), ReviewFormDAO\updateObject(), PKPAnnouncementTypeDAO\updateObject(), PKPUserDAO\updateObject(), PaperDAO\updatePaper(), PaperCommentDAO\updatePaperComment(), PaperFileDAO\updatePaperFile(), PaperNoteDAO\updatePaperNote(), PublishedPaperDAO\updatePublishedPaper(), PublishedPaperDAO\updatePublishedPaperField(), QueuedPaymentDAO\updateQueuedPayment(), RegistrationDAO\updateRegistration(), RegistrationOptionDAO\updateRegistrationOption(), RegistrationTypeDAO\updateRegistrationType(), ReviewAssignmentDAO\updateReviewAssignment(), ReviewerSubmissionDAO\updateReviewerSubmission(), RoomDAO\updateRoom(), SchedConfDAO\updateSchedConf(), RTDAO\updateSearch(), ConferenceSettingsDAO\updateSetting(), SiteSettingsDAO\updateSetting(), SchedConfSettingsDAO\updateSetting(), PluginSettingsDAO\updateSetting(), PKPUserSettingsDAO\updateSetting(), SpecialEventDAO\updateSpecialEvent(), StaticPagesDAO\updateStaticPage(), SuppFileDAO\updateSuppFile(), TimeBlockDAO\updateTimeBlock(), TrackDAO\updateTrack(), TrackDirectorSubmissionDAO\updateTrackDirectorSubmission(), and RTDAO\updateVersion().

◆ updateDataObjectSettings()

Member Data Documentation

◆ $_dataSource

DAO::$_dataSource

The database connection object

Definition at line 32 of file DAO.inc.php.


The documentation for this class was generated from the following file: