Open Journal Systems  2.4.4
 All Classes Namespaces Functions Variables Groups Pages
DAO Class Reference
Inheritance diagram for DAO:
AccessKeyDAO ArticleCommentDAO ArticleDAO ArticleGalleyDAO ArticleReportDAO ArticleSearchDAO AuthorSubmissionDAO AuthSourceDAO BookForReviewAuthorDAO BookForReviewDAO CaptchaDAO CitationDAO CodelistItemDAO CommentDAO ControlledVocabDAO ControlledVocabEntryDAO CopyeditorSubmissionDAO CurrencyDAO DataObjectTombstoneDAO DataObjectTombstoneSettingsDAO DataverseFileDAO DataverseStudyDAO EditAssignmentDAO EditorSubmissionDAO EmailLogDAO EventLogDAO ExternalFeedDAO FilterDAO FilterGroupDAO GroupDAO GroupMembershipDAO IssueDAO IssueGalleyDAO JournalDAO JournalSettingsDAO JournalStatisticsDAO LanguageDAO LayoutEditorSubmissionDAO MetadataDescriptionDAO MetricsDAO NotificationDAO NotificationMailListDAO NotificationSettingsDAO NotificationSubscriptionSettingsDAO ObjectForReviewAssignmentDAO ObjectForReviewDAO ObjectForReviewPersonDAO ObjectForReviewSettingsDAO OJSCompletedPaymentDAO PayPalDAO PKPAnnouncementDAO PKPAnnouncementTypeDAO PKPAuthorDAO PKPEmailTemplateDAO PKPFileDAO PKPGiftDAO PKPOAIDAO PKPReviewAssignmentDAO PKPSignoffDAO PKPUserDAO PKPUserGroupDAO PKPUserSettingsDAO PluginSettingsDAO ProcessDAO ProofreaderSubmissionDAO PublishedArticleDAO QueuedPaymentDAO ReferralDAO ReviewerSubmissionDAO ReviewFormDAO ReviewFormElementDAO ReviewFormResponseDAO ReviewObjectMetadataDAO ReviewObjectTypeDAO ReviewReportDAO RoleDAO RTDAO ScheduledTaskDAO SectionDAO SectionEditorsDAO SectionEditorSubmissionDAO SessionDAO SiteDAO SiteSettingsDAO StaticPagesDAO SubmissionFileDAODelegate SubscriptionDAO SubscriptionTypeDAO SuppFileDAO TemporaryFileDAO ThesisDAO UsageStatsTemporaryRecordDAO VersionDAO

Public Member Functions

 concat ()
 
 convertFromDB ($value, $type)
 
 convertToDB ($value, &$type)
 
 DAO ($dataSource=null, $callHooks=true)
 
 dateFromDB ($d)
 
 datetimeFromDB ($dt)
 
 datetimeToDB ($dt)
 
 dateToDB ($d)
 
 flushCache ()
 
 formatDateToDB ($date, $defaultNumWeeks=null, $acceptPastDate=true)
 
 getAffectedRows ()
 
 getDataChangedEvent ($elementId=null, $parentElementId=null)
 
getDataSource ()
 
 getDirectionMapping ($direction)
 
 getDriver ()
 
 getInsertId ($table= '', $id= '', $callHooks=true)
 
 getType ($value)
 
 replace ($table, $arrFields, $keyCols)
 
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)
 
 setCacheDir ()
 
 setDataSource (&$dataSource)
 
 update ($sql, $params=false, $callHooks=true, $dieOnError=true)
 
 updateDataObjectSettings ($tableName, &$dataObject, $idArray)
 

Public Attributes

 $_dataSource
 

Detailed Description

Operations for retrieving and modifying objects from a database.

See Also
DAORegistry

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

Member Function Documentation

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

Constructor. Initialize the database connection.

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

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

DAO::dateFromDB (   $d)

Return date from DB as ISO date string.

Parameters
$dstring date from DB
Returns
string

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

References getDataSource().

Referenced by SubscriptionDAO\_returnSubscriptionFromRow(), SuppFileDAO\_returnSuppFileFromRow(), and ThesisDAO\_returnThesisFromRow().

DAO::datetimeFromDB (   $dt)

Return datetime from DB as ISO datetime string.

Parameters
$dtstring datetime from DB
Returns
string

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

References getDataSource().

Referenced by ArticleDAO\_articleFromRow(), PKPOAIDAO\_doCommonOAIFromRowOperations(), DataObjectTombstoneDAO\_fromRow(), ObjectForReviewAssignmentDAO\_fromRow(), PKPSignoffDAO\_fromRow(), PKPReviewAssignmentDAO\_fromRow(), AccessKeyDAO\_returnAccessKeyFromRow(), PKPAnnouncementDAO\_returnAnnouncementFromRow(), ArticleCommentDAO\_returnArticleCommentFromRow(), ArticleFileDAO\_returnArticleFileFromRow(), CaptchaDAO\_returnCaptchaFromRow(), CommentDAO\_returnCommentFromRow(), EditAssignmentDAO\_returnEditAssignmentFromRow(), IssueGalleyDAO\_returnGalleyFromRow(), ArticleGalleyDAO\_returnGalleyFromRow(), PKPGiftDAO\_returnGiftFromRow(), IssueFileDAO\_returnIssueFileFromRow(), IssueDAO\_returnIssueFromRow(), NotificationDAO\_returnNotificationFromRow(), OJSCompletedPaymentDAO\_returnPaymentFromRow(), PublishedArticleDAO\_returnPublishedArticleFromRow(), ReferralDAO\_returnReferralFromRow(), ReviewerSubmissionDAO\_returnReviewerSubmissionFromRow(), SubscriptionDAO\_returnSubscriptionFromRow(), SuppFileDAO\_returnSuppFileFromRow(), TemporaryFileDAO\_returnTemporaryFileFromRow(), PKPUserDAO\_returnUserFromRow(), VersionDAO\_returnVersionFromRow(), EventLogDAO\build(), EmailLogDAO\build(), JournalStatisticsDAO\getArticleStatistics(), SectionEditorSubmissionDAO\getCopyeditorStatistics(), PKPOAIDAO\getEarliestDatestamp(), PKPReviewAssignmentDAO\getEarliestNotificationByRound(), JournalStatisticsDAO\getFirstActivityDate(), PKPReviewAssignmentDAO\getLastModifiedByRound(), ScheduledTaskDAO\getLastRunTime(), SectionEditorSubmissionDAO\getLayoutEditorStatistics(), SectionEditorSubmissionDAO\getProofreaderStatistics(), PublishedArticleDAO\getPublishedArticleById(), JournalStatisticsDAO\getReviewerStatistics(), and SectionEditorSubmissionDAO\getReviewerStatistics().

DAO::datetimeToDB (   $dt)

Return datetime formatted for DB insertion.

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

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

References getDataSource().

Referenced by SubscriptionDAO\_generateSearchSQL(), EditorSubmissionDAO\_getUnfilteredEditorSubmissions(), SectionEditorSubmissionDAO\_getUnfilteredSectionEditorSubmissions(), SubscriptionDAO\_insertSubscription(), SubscriptionDAO\_updateSubscription(), AccessKeyDAO\deleteExpiredKeys(), SubscriptionDAO\flagReminded(), AccessKeyDAO\getAccessKey(), AccessKeyDAO\getAccessKeyByKeyHash(), AccessKeyDAO\getAccessKeyByUserId(), ThesisDAO\getActiveThesesByJournalId(), JournalStatisticsDAO\getArticleStatistics(), CopyeditorSubmissionDAO\getCopyeditorSubmissionsByCopyeditorId(), OAIDAO\getDateRangeWhereClause(), CaptchaDAO\getExpiredCaptchas(), JournalStatisticsDAO\getIssueStatistics(), ArticleSearchDAO\getPhraseResults(), JournalStatisticsDAO\getReviewerStatistics(), LayoutEditorSubmissionDAO\getSubmissions(), ProofreaderSubmissionDAO\getSubmissions(), JournalStatisticsDAO\getSubscriptionStatistics(), IndividualSubscriptionDAO\getSubscriptionsToRemind(), InstitutionalSubscriptionDAO\getSubscriptionsToRemind(), ThesisDAO\getThesesByJournalId(), JournalStatisticsDAO\getUserStatistics(), AccessKeyDAO\insertAccessKey(), PKPAnnouncementDAO\insertAnnouncement(), ArticleDAO\insertArticle(), ArticleCommentDAO\insertArticleComment(), ArticleFileDAO\insertArticleFile(), CaptchaDAO\insertCaptcha(), CommentDAO\insertComment(), OJSCompletedPaymentDAO\insertCompletedPayment(), EditAssignmentDAO\insertEditAssignment(), EditorSubmissionDAO\insertEditorSubmission(), IssueDAO\insertIssue(), IssueFileDAO\insertIssueFile(), ObjectForReviewDAO\insertObject(), PKPGiftDAO\insertObject(), ObjectForReviewAssignmentDAO\insertObject(), EventLogDAO\insertObject(), DataObjectTombstoneDAO\insertObject(), EmailLogDAO\insertObject(), BookForReviewDAO\insertObject(), NotificationDAO\insertObject(), PKPSignoffDAO\insertObject(), PKPReviewAssignmentDAO\insertObject(), PublishedArticleDAO\insertPublishedArticle(), QueuedPaymentDAO\insertQueuedPayment(), SuppFileDAO\insertSuppFile(), TemporaryFileDAO\insertTemporaryFile(), ThesisDAO\insertThesis(), PayPalDAO\insertTransaction(), PKPUserDAO\insertUser(), VersionDAO\insertVersion(), ReferralDAO\replaceReferral(), NotificationDAO\setDateRead(), ArticleDAO\updateArticle(), ArticleCommentDAO\updateArticleComment(), ArticleFileDAO\updateArticleFile(), CommentDAO\updateComment(), EditAssignmentDAO\updateEditAssignment(), IssueDAO\updateIssue(), IssueFileDAO\updateIssueFile(), ScheduledTaskDAO\updateLastRunTime(), TemporaryFileDAO\updateObject(), ObjectForReviewDAO\updateObject(), ObjectForReviewAssignmentDAO\updateObject(), PKPAnnouncementDAO\updateObject(), AccessKeyDAO\updateObject(), DataObjectTombstoneDAO\updateObject(), PKPGiftDAO\updateObject(), CaptchaDAO\updateObject(), PKPSignoffDAO\updateObject(), BookForReviewDAO\updateObject(), PKPUserDAO\updateObject(), PublishedArticleDAO\updatePublishedArticle(), QueuedPaymentDAO\updateQueuedPayment(), ReferralDAO\updateReferral(), PKPReviewAssignmentDAO\updateReviewAssignment(), ReviewerSubmissionDAO\updateReviewerSubmission(), SectionEditorSubmissionDAO\updateSectionEditorSubmission(), and ThesisDAO\updateThesis().

DAO::formatDateToDB (   $date,
  $defaultNumWeeks = null,
  $acceptPastDate = true 
)

Format a passed date (in English textual datetime) to Y-m-d H:i:s format, used in database.

Parameters
$datestring Any English textual datetime.
$defaultNumWeeksint If passed and date is null, used to calculate a data in future from today.
$acceptPastDateboolean Will not accept past dates, returning today if false and the passed date is in the past.
Returns
string or null

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

DAO::getDataChangedEvent (   $elementId = null,
  $parentElementId = null 
)

Generate a JSON message with an event that can be sent to the client to refresh itself according to changes in the DB.

Parameters
$elementIdstring To refresh a single element give the element ID here. Otherwise all elements will be refreshed.
$parentElementIdstring To refresh a single element that is associated with another one give the parent element ID here.
Returns
string A rendered JSON message.

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

Referenced by GridHandler\saveSequence().

DAO::getDriver ( )

Get the driver for this connection.

Returns
string

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

References DBConnection\getInstance().

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 252 of file DAO.inc.php.

References getDataSource().

Referenced by ArticleSearchDAO\_insertKeyword(), AccessKeyDAO\getInsertAccessKeyId(), PKPAnnouncementDAO\getInsertAnnouncementId(), ArticleCommentDAO\getInsertArticleCommentId(), ArticleFileDAO\getInsertArticleFileId(), ArticleDAO\getInsertArticleId(), BookForReviewAuthorDAO\getInsertAuthorId(), PKPAuthorDAO\getInsertAuthorId(), BookForReviewDAO\getInsertBookForReviewId(), CaptchaDAO\getInsertCaptchaId(), CommentDAO\getInsertCommentId(), OJSCompletedPaymentDAO\getInsertCompletedPaymentId(), DataverseFileDAO\getInsertDataverseFileId(), EditAssignmentDAO\getInsertEditId(), EditorSubmissionDAO\getInsertEditId(), PKPEmailTemplateDAO\getInsertEmailId(), ExternalFeedDAO\getInsertExternalFeedId(), IssueGalleyDAO\getInsertGalleyId(), ArticleGalleyDAO\getInsertGalleyId(), PKPGiftDAO\getInsertGiftId(), GroupDAO\getInsertGroupId(), IssueFileDAO\getInsertIssueFileId(), IssueDAO\getInsertIssueId(), JournalDAO\getInsertJournalId(), EventLogDAO\getInsertLogId(), EmailLogDAO\getInsertLogId(), NotificationDAO\getInsertNotificationId(), NotificationMailListDAO\getInsertNotificationMailListId(), ReferralDAO\getInsertObjectId(), PublishedArticleDAO\getInsertPublishedArticleId(), QueuedPaymentDAO\getInsertQueuedPaymentId(), ReviewFormElementDAO\getInsertReviewFormElementId(), ReviewFormDAO\getInsertReviewFormId(), PKPReviewAssignmentDAO\getInsertReviewId(), SectionDAO\getInsertSectionId(), DataverseStudyDAO\getInsertStudyId(), SubscriptionDAO\getInsertSubscriptionId(), SubscriptionTypeDAO\getInsertSubscriptionTypeId(), SuppFileDAO\getInsertSuppFileId(), TemporaryFileDAO\getInsertTemporaryFileId(), ThesisDAO\getInsertThesisId(), DataObjectTombstoneDAO\getInsertTombstoneId(), PKPAnnouncementTypeDAO\getInsertTypeId(), PKPUserGroupDAO\getInsertUserGroupId(), PKPUserDAO\getInsertUserId(), RTDAO\insertContext(), ArticleSearchDAO\insertObject(), RTDAO\insertSearch(), AuthSourceDAO\insertSource(), RTDAO\insertVersion(), and SectionEditorSubmissionDAO\updateSectionEditorSubmission().

DAO::getType (   $value)

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

Parameters
$valuestring
Returns
string

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

Referenced by convertToDB().

DAO::replace (   $table,
  $arrFields,
  $keyCols 
)
& 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 83 of file DAO.inc.php.

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

Referenced by FilterDAO\_deleteSubFiltersByParentFilterId(), PKPSignoffDAO\_getAllInternally(), ObjectForReviewAssignmentDAO\_getAllInternally(), UsageStatsTemporaryRecordDAO\_getGrouped(), PKPSubmissionFileDAO\_getInternally(), PKPOAIDAO\_getRecordsRecordSet(), ReviewAssignmentDAO\_getSubmissionReviewFileId(), ArticleXMLGalleyDAO\_getXMLGalleyFromId(), ArticleSearchDAO\_insertKeyword(), FilterDAO\_populateSubFilters(), PKPEmailTemplateDAO\_returnLocaleEmailTemplateFromRow(), InstitutionalSubscriptionDAO\_returnSubscriptionFromRow(), PKPAnnouncementTypeDAO\announcementTypeExistsByTypeId(), ArticleXMLGalleyDAO\appendXMLGalleys(), ObjectForReviewAssignmentDAO\assignmentExists(), CommentDAO\attributedCommentsExistForUser(), EventLogDAO\build(), CitationDAO\checkNextRawCitation(), PKPUserGroupDAO\contextHasGroup(), SectionEditorSubmissionDAO\copyeditorExists(), IssueDAO\customIssueOrderingExists(), SectionDAO\customSectionOrderingExists(), PKPEmailTemplateDAO\customTemplateExistsByKey(), ArticleSearchDAO\deleteArticleKeywords(), PKPUserGroupDAO\deleteByContextId(), PKPReviewAssignmentDAO\deleteBySubmissionId(), PublishedArticleDAO\deletePublishedArticlesBySectionId(), IndividualSubscriptionDAO\deleteSubscriptionsByJournal(), InstitutionalSubscriptionDAO\deleteSubscriptionsByJournal(), IndividualSubscriptionDAO\deleteSubscriptionsByTypeId(), InstitutionalSubscriptionDAO\deleteSubscriptionsByTypeId(), IndividualSubscriptionDAO\deleteSubscriptionsByUserId(), InstitutionalSubscriptionDAO\deleteSubscriptionsByUserId(), IndividualSubscriptionDAO\deleteSubscriptionsByUserIdForJournal(), InstitutionalSubscriptionDAO\deleteSubscriptionsByUserIdForJournal(), SubscriptionTypeDAO\deleteSubscriptionTypesByJournal(), StaticPagesDAO\duplicatePathExists(), SectionEditorsDAO\editorExists(), ControlledVocabDAO\enumerate(), IssueGalleyDAO\galleyExistsByFileId(), ArticleGalleyDAO\galleyExistsByFileId(), AccessKeyDAO\getAccessKey(), AccessKeyDAO\getAccessKeyByKeyHash(), AccessKeyDAO\getAccessKeyByUserId(), PKPAnnouncementDAO\getAnnouncementAssocId(), PKPAnnouncementDAO\getAnnouncementAssocType(), PKPAnnouncementTypeDAO\getAnnouncementTypeAssocId(), PKPAnnouncementTypeDAO\getAnnouncementTypeName(), ObjectForReviewDAO\getArrayByReviewObjectTypeId(), ReviewObjectMetadataDAO\getArrayByReviewObjectTypeId(), ArticleDAO\getArticle(), ArticleCommentDAO\getArticleCommentById(), ArticleCommentDAO\getArticleComments(), ArticleCommentDAO\getArticleCommentsByUserId(), ArticleFileDAO\getArticleFile(), ArticleFileDAO\getArticleFileRevisions(), ArticleFileDAO\getArticleFileRevisionsInRange(), ArticleFileDAO\getArticleFilesByArticle(), ArticleFileDAO\getArticleFilesByAssocId(), ArticleDAO\getArticleJournalId(), ArticleReportDAO\getArticleReport(), ArticleDAO\getArticlesByJournalId(), ArticleDAO\getArticlesByUserId(), JournalStatisticsDAO\getArticleStatistics(), PublishedArticleDAO\getArticleYearRange(), BookForReviewAuthorDAO\getAuthor(), PKPAuthorDAO\getAuthor(), PKPAuthorDAO\getAuthorCountBySubmissionId(), BookForReviewAuthorDAO\getAuthorIdsByBookForReview(), BookForReviewAuthorDAO\getAuthorsByBookForReview(), PKPAuthorDAO\getAuthorsBySubmissionId(), AuthorSubmissionDAO\getAuthorSubmission(), ReviewAssignmentDAO\getAuthorViewableFilesByRound(), ReviewAssignmentDAO\getAverageQualityRatings(), PKPEmailTemplateDAO\getBaseEmailTemplate(), BookForReviewDAO\getBookForReview(), BookForReviewDAO\getBookForReviewJournalId(), BookForReviewDAO\getBooksForReviewStatusCount(), PKPUserGroupDAO\getByContextId(), DataObjectTombstoneDAO\getByDataObjectId(), PKPSignoffDAO\getByFileRevision(), JournalDAO\getById(), PKPAnnouncementDAO\getById(), NotificationDAO\getById(), PKPSignoffDAO\getById(), ControlledVocabEntryDAO\getById(), EmailLogDAO\getById(), EventLogDAO\getById(), ObjectForReviewPersonDAO\getById(), GroupDAO\getById(), ReviewObjectTypeDAO\getById(), ReviewObjectMetadataDAO\getById(), ObjectForReviewAssignmentDAO\getById(), ObjectForReviewDAO\getById(), PKPAnnouncementTypeDAO\getById(), ControlledVocabDAO\getById(), DataObjectTombstoneDAO\getById(), PKPUserDAO\getById(), PKPReviewAssignmentDAO\getById(), CommentDAO\getById(), PKPUserGroupDAO\getById(), ReviewObjectTypeDAO\getByKey(), ReviewObjectMetadataDAO\getByKey(), ObjectForReviewAssignmentDAO\getByObjectAndUserId(), ObjectForReviewPersonDAO\getByObjectForReview(), PKPReviewAssignmentDAO\getByReviewFormId(), PKPUserGroupDAO\getByRoleId(), ControlledVocabEntryDAO\getBySetting(), PublishedArticleDAO\getBySetting(), PKPReviewAssignmentDAO\getBySubmissionId(), ControlledVocabDAO\getBySymbolic(), PKPSignoffDAO\getBySymbolic(), PKPAnnouncementTypeDAO\getByTypeName(), CommentDAO\getByUserId(), PKPReviewAssignmentDAO\getByUserId(), PKPUserGroupDAO\getByUserId(), PKPSignoffDAO\getByUserId(), PKPUserDAO\getByUsername(), PKPReviewAssignmentDAO\getCancelsAndRegrets(), CaptchaDAO\getCaptcha(), CaptchaDAO\getCaptchasBySessionId(), CommentDAO\getCommentsByParentId(), OJSCompletedPaymentDAO\getCompletedPayment(), ReviewAssignmentDAO\getCompletedReviewCounts(), RTDAO\getContext(), PKPUserGroupDAO\getContextUsersCount(), SectionEditorSubmissionDAO\getCopyeditorStatistics(), CopyeditorSubmissionDAO\getCopyeditorSubmission(), IssueDAO\getCurrentIssue(), VersionDAO\getCurrentProducts(), VersionDAO\getCurrentVersion(), IssueDAO\getCustomIssueOrder(), SectionDAO\getCustomSectionOrder(), DataverseFileDAO\getDataverseFileBySuppFileId(), DataverseFileDAO\getDataverseFilesByStudyId(), DataverseFileDAO\getDataverseFilesBySubmissionId(), AuthSourceDAO\getDefaultSource(), ReviewObjectMetadataDAO\getDisplayReviewObjectMetadataIds(), PKPOAIDAO\getEarliestDatestamp(), PKPReviewAssignmentDAO\getEarliestNotificationByRound(), EditAssignmentDAO\getEditAssignment(), EditAssignmentDAO\getEditAssignmentsByArticleId(), EditAssignmentDAO\getEditAssignmentsByUserId(), EditAssignmentDAO\getEditingSectionEditorAssignmentsByArticleId(), EditAssignmentDAO\getEditorAssignmentsByArticleId(), AuthorSubmissionDAO\getEditorDecisions(), ReviewerSubmissionDAO\getEditorDecisions(), EditorSubmissionDAO\getEditorDecisions(), SectionEditorSubmissionDAO\getEditorDecisions(), SectionEditorsDAO\getEditorsBySectionId(), SectionDAO\getEditorSections(), SectionEditorsDAO\getEditorsNotInSection(), EditAssignmentDAO\getEditorStatistics(), EditorSubmissionDAO\getEditorSubmission(), EditorSubmissionDAO\getEditorSubmissionsCount(), PKPEmailTemplateDAO\getEmailTemplate(), PKPEmailTemplateDAO\getEmailTemplates(), CaptchaDAO\getExpiredCaptchas(), ExternalFeedDAO\getExternalFeed(), ExternalFeedDAO\getExternalFeedJournalId(), OJSCompletedPaymentDAO\getFastTrackCompletedPayment(), JournalStatisticsDAO\getFirstActivityDate(), IssueGalleyDAO\getGalley(), ArticleGalleyDAO\getGalley(), IssueGalleyDAO\getGalleyByPubId(), ArticleGalleyDAO\getGalleyImages(), ArticleGalleyDAO\getGalleysByArticle(), IssueGalleyDAO\getGalleysByIssue(), ArticleGalleyDAO\getGalleysByJournalId(), ArticleGalleyDAO\getGalleysBySetting(), PKPGiftDAO\getGift(), PKPGiftDAO\getGiftAssocId(), PKPGiftDAO\getGiftAssocType(), ObjectForReviewAssignmentDAO\getIncompleteAssignmentsByContextId(), PKPReviewAssignmentDAO\getIncompleteReviewAssignments(), IssueDAO\getIssueByArticleId(), IssueDAO\getIssueById(), IssueFileDAO\getIssueFile(), IssueFileDAO\getIssueFilesByIssue(), IssueDAO\getIssuesBySetting(), JournalStatisticsDAO\getIssueStatistics(), JournalDAO\getJournalByPath(), SectionDAO\getJournalEmptySectionIds(), JournalSettingsDAO\getJournalSettings(), RoleDAO\getJournalUsersCount(), RoleDAO\getJournalUsersRoleCount(), PKPReviewAssignmentDAO\getLastModifiedByRound(), ScheduledTaskDAO\getLastRunTime(), PKPSubmissionFileDAO\getLatestRevisionNumber(), SectionEditorSubmissionDAO\getLayoutEditorStatistics(), MetricsDAO\getLoadId(), PKPEmailTemplateDAO\getLocaleEmailTemplate(), NotificationMailListDAO\getMailList(), NotificationMailListDAO\getMailListIdByToken(), SectionEditorSubmissionDAO\getMaxReviewRound(), GroupMembershipDAO\getMembership(), ReviewObjectMetadataDAO\getMetadataId(), ThesisDAO\getMostRecentActiveThesisByJournalId(), PKPAnnouncementDAO\getMostRecentAnnouncementByAssocId(), IssueGalleyDAO\getNextGalleySequence(), ArticleGalleyDAO\getNextGalleySequence(), SuppFileDAO\getNextSuppFileSequence(), NotificationDAO\getNotificationCount(), NotificationSettingsDAO\getNotificationSettings(), NotificationSubscriptionSettingsDAO\getNotificationSubscriptionSettings(), IssueDAO\getNumArticles(), ProcessDAO\getNumberOfObjectsByProcessType(), DataObjectTombstoneDAO\getOAISetObjectsIds(), MetadataDescriptionDAO\getObjectById(), FilterGroupDAO\getObjectById(), CitationDAO\getObjectById(), ProcessDAO\getObjectById(), FilterDAO\getObjectById(), FilterGroupDAO\getObjectBySymbolic(), FilterDAO\getObjectsByClass(), FilterDAO\getObjectsByGroup(), FilterDAO\getObjectsByGroupAndClass(), FilterDAO\getObjectsByTypeDescription(), PluginSettingsDAO\getPluginSettings(), PKPAuthorDAO\getPrimaryContact(), SectionEditorSubmissionDAO\getProofreaderStatistics(), OJSCompletedPaymentDAO\getPublicationCompletedPayment(), PublishedArticleDAO\getPublishedArticleByArticleId(), PublishedArticleDAO\getPublishedArticleById(), PublishedArticleDAO\getPublishedArticleCountByJournalId(), PublishedArticleDAO\getPublishedArticles(), PublishedArticleDAO\getPublishedArticlesBySectionId(), AuthorDAO\getPublishedArticlesForAuthor(), PublishedArticleDAO\getPublishedArticlesInSections(), IssueDAO\getPublishedIssuesByNumber(), QueuedPaymentDAO\getQueuedPayment(), PKPOAIDAO\getRecord(), ReferralDAO\getReferral(), ReviewFormElementDAO\getRequiredReviewFormElementIds(), ReviewObjectMetadataDAO\getRequiredReviewObjectMetadataIds(), PKPReviewAssignmentDAO\getReviewAssignment(), PKPReviewAssignmentDAO\getReviewerIdsBySubmissionId(), SectionEditorSubmissionDAO\getReviewersNotAssignedToArticle(), JournalStatisticsDAO\getReviewerStatistics(), SectionEditorSubmissionDAO\getReviewerStatistics(), ReviewerSubmissionDAO\getReviewerSubmission(), ReviewAssignmentDAO\getReviewFilesByRound(), ReviewFormDAO\getReviewForm(), ReviewFormElementDAO\getReviewFormElement(), ReviewFormElementDAO\getReviewFormElements(), ReviewFormResponseDAO\getReviewFormResponse(), PKPReviewAssignmentDAO\getReviewIndexesForRound(), EditAssignmentDAO\getReviewingSectionEditorAssignmentsByArticleId(), ReviewReportDAO\getReviewReport(), ArticleFileDAO\getRevisionNumber(), RoleDAO\getRole(), RoleDAO\getRolesByJournalId(), RoleDAO\getRolesByUserId(), CommentDAO\getRootCommentsBySubmissionId(), NotificationSubscriptionSettingsDAO\getRSSTokenByUserId(), RTDAO\getSearch(), SectionDAO\getSection(), SectionDAO\getSectionByAbbrev(), SectionDAO\getSectionByTitle(), SectionDAO\getSectionByTitleAndAbbrev(), SectionEditorSubmissionDAO\getSectionEditorSubmission(), SectionEditorSubmissionDAO\getSectionEditorSubmissions(), SectionEditorSubmissionDAO\getSectionEditorSubmissionsCount(), SectionDAO\getSectionsForIssue(), SessionDAO\getSession(), DataObjectTombstoneDAO\getSets(), DataObjectTombstoneSettingsDAO\getSetting(), PKPUserSettingsDAO\getSetting(), ObjectForReviewSettingsDAO\getSetting(), PKPUserGroupDAO\getSetting(), ObjectForReviewSettingsDAO\getSettings(), PKPUserSettingsDAO\getSettingsByAssoc(), SiteDAO\getSite(), SiteSettingsDAO\getSiteSettings(), AuthSourceDAO\getSource(), IndividualSubscriptionDAO\getStatusCount(), InstitutionalSubscriptionDAO\getStatusCount(), DataverseStudyDAO\getStudy(), DataverseStudyDAO\getStudyBySubmissionId(), ProofreaderSubmissionDAO\getSubmission(), LayoutEditorSubmissionDAO\getSubmission(), OJSCompletedPaymentDAO\getSubmissionCompletedPayment(), AuthorSubmissionDAO\getSubmissionsCount(), ReviewerSubmissionDAO\getSubmissionsCount(), ProofreaderSubmissionDAO\getSubmissionsCount(), LayoutEditorSubmissionDAO\getSubmissionsCount(), CopyeditorSubmissionDAO\getSubmissionsCount(), BookForReviewDAO\getSubmittedBookForReviewByArticle(), BookForReviewDAO\getSubmittedBookForReviewIdByArticle(), IndividualSubscriptionDAO\getSubscription(), InstitutionalSubscriptionDAO\getSubscription(), IndividualSubscriptionDAO\getSubscriptionIdByUser(), SubscriptionDAO\getSubscriptionJournalId(), JournalStatisticsDAO\getSubscriptionStatistics(), SubscriptionTypeDAO\getSubscriptionType(), SubscriptionTypeDAO\getSubscriptionTypeDisablePublicDisplay(), SubscriptionTypeDAO\getSubscriptionTypeInstitutional(), SubscriptionTypeDAO\getSubscriptionTypeJournalId(), SubscriptionTypeDAO\getSubscriptionTypeMembership(), SubscriptionTypeDAO\getSubscriptionTypeName(), SubscriptionTypeDAO\getSubscriptionTypeNonExpiring(), SuppFileDAO\getSuppFile(), SuppFileDAO\getSuppFilesByArticle(), SuppFileDAO\getSuppFilesByJournalId(), SuppFileDAO\getSuppFilesBySetting(), ReviewObjectMetadataDAO\getTextareaReviewObjectMetadataIds(), ThesisDAO\getThesis(), ThesisDAO\getThesisJournalId(), PKPOAIDAO\getToken(), ReviewObjectTypeDAO\getTypeIdsAlphabetizedByContext(), ReviewObjectTypeDAO\getTypeKeys(), ReviewFormDAO\getUseCounts(), PKPUserDAO\getUserByAuthStr(), PKPUserDAO\getUserByCredentials(), PKPUserDAO\getUserByEmail(), PKPUserDAO\getUserEmail(), PKPUserDAO\getUserFullName(), PKPUserGroupDAO\getUserGroupIdsByRoleId(), NotificationSubscriptionSettingsDAO\getUserIdByRSSToken(), InterestDAO\getUserIdsByInterest(), PKPUserSettingsDAO\getUsersBySetting(), PKPSignoffDAO\getUsersBySymbolic(), PKPUserGroupDAO\getUsersNotInRole(), JournalStatisticsDAO\getUserStatistics(), RTDAO\getVersion(), VersionDAO\getVersionHistory(), OJSCompletedPaymentDAO\hasPaidFastTrack(), OJSCompletedPaymentDAO\hasPaidPublication(), OJSCompletedPaymentDAO\hasPaidPurchaseArticle(), OJSCompletedPaymentDAO\hasPaidPurchaseIssue(), OJSCompletedPaymentDAO\hasPaidSubmission(), MetricsDAO\hasRecord(), ArticleDAO\incompleteSubmissionExists(), CitationDAO\insertObject(), ArticleSearchDAO\insertObject(), PKPOAIDAO\insertToken(), OpenAIREDAO\isOpenAIREArticle(), OpenAIREDAO\isOpenAIRERecord(), IssueDAO\issueExists(), IssueDAO\issueIdExists(), ThesisDAO\isThesisActive(), IndividualSubscriptionDAO\isValidIndividualSubscription(), InstitutionalSubscriptionDAO\isValidInstitutionalSubscription(), JournalDAO\journalExistsByPath(), IssueDAO\moveCustomIssueOrder(), ArticleGalleyDAO\pubIdExists(), IssueGalleyDAO\pubIdExists(), SuppFileDAO\pubIdExists(), IssueDAO\pubIdExists(), ArticleDAO\pubIdExists(), PKPGiftDAO\recipientHasGift(), PKPGiftDAO\recipientHasNotRedeemedGift(), PKPOAIDAO\recordExists(), ReferralDAO\referralExistsByUrl(), ObjectForReviewPersonDAO\resequence(), ControlledVocabEntryDAO\resequence(), ReviewObjectMetadataDAO\resequence(), BookForReviewAuthorDAO\resequenceAuthors(), PKPAuthorDAO\resequenceAuthors(), RTDAO\resequenceContexts(), IssueDAO\resequenceCustomIssueOrders(), SectionDAO\resequenceCustomSectionOrders(), ExternalFeedDAO\resequenceExternalFeeds(), IssueGalleyDAO\resequenceGalleys(), ArticleGalleyDAO\resequenceGalleys(), GroupDAO\resequenceGroups(), JournalDAO\resequenceJournals(), GroupMembershipDAO\resequenceMemberships(), PublishedArticleDAO\resequencePublishedArticles(), ReviewFormElementDAO\resequenceReviewFormElements(), ReviewFormDAO\resequenceReviewForms(), RTDAO\resequenceSearches(), SectionDAO\resequenceSections(), SubscriptionTypeDAO\resequenceSubscriptionTypes(), SuppFileDAO\resequenceSuppFiles(), retrieveRange(), SectionEditorSubmissionDAO\reviewerExists(), ReviewFormElementDAO\reviewFormElementExists(), ReviewFormDAO\reviewFormExists(), ReviewFormResponseDAO\reviewFormResponseExists(), ReviewObjectMetadataDAO\reviewObjectMetadataExists(), ReviewObjectTypeDAO\reviewObjectTypeExists(), SectionEditorSubmissionDAO\reviewRoundExists(), SectionDAO\sectionExists(), SessionDAO\sessionExistsById(), SectionDAO\setDefaultCustomSectionOrders(), PKPSignoffDAO\signoffExists(), NotificationMailListDAO\subscribeGuest(), IndividualSubscriptionDAO\subscriptionExists(), InstitutionalSubscriptionDAO\subscriptionExists(), InstitutionalSubscriptionDAO\subscriptionExistsByInstitutionName(), IndividualSubscriptionDAO\subscriptionExistsByUser(), InstitutionalSubscriptionDAO\subscriptionExistsByUser(), IndividualSubscriptionDAO\subscriptionExistsByUserForJournal(), InstitutionalSubscriptionDAO\subscriptionExistsByUserForJournal(), SubscriptionTypeDAO\subscriptionTypeExistsByTypeId(), SubscriptionTypeDAO\subscriptionTypesExistByInstitutional(), SuppFileDAO\suppFileExistsByFileId(), PKPEmailTemplateDAO\templateExistsByKey(), PayPalDAO\transactionExists(), ReviewFormDAO\unusedReviewFormExists(), ScheduledTaskDAO\updateLastRunTime(), PKPEmailTemplateDAO\updateLocaleEmailTemplateData(), PluginSettingsDAO\updateSetting(), PKPUserSettingsDAO\updateSetting(), PKPUserDAO\userExistsByEmail(), PKPUserDAO\userExistsById(), PKPUserDAO\userExistsByUsername(), RoleDAO\userHasRole(), PKPUserGroupDAO\userInAnyGroup(), and PKPUserGroupDAO\userInGroup().

& 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 113 of file DAO.inc.php.

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

Referenced by ArticleSearchDAO\getPhraseResults().

& 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 147 of file DAO.inc.php.

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

Referenced by ArticleFileDAO\getArticleFile(), IssueDAO\getLastCreatedIssue(), MetricsDAO\getMetrics(), ArticleCommentDAO\getMostRecentArticleComment(), and TemporaryFileDAO\getTemporaryFile().

& 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
$dbResultRangeDBResultRange object describing the desired range

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

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

Referenced by PKPSubmissionFileDAO\_getInternally(), EditorSubmissionDAO\_getUnfilteredEditorSubmissions(), SectionEditorSubmissionDAO\_getUnfilteredSectionEditorSubmissions(), ReviewFormDAO\getActiveByAssocId(), ThesisDAO\getActiveThesesByJournalId(), PKPGiftDAO\getAllGiftsByRecipient(), PKPAnnouncementDAO\getAnnouncementsNotExpiredByAssocId(), AuthorDAO\getAuthorsAlphabetizedByJournal(), AuthorSubmissionDAO\getAuthorSubmissions(), BookForReviewDAO\getBooksForReviewAssignedByAuthor(), BookForReviewDAO\getBooksForReviewByAuthor(), BookForReviewDAO\getBooksForReviewByDateDue(), BookForReviewDAO\getBooksForReviewByJournalId(), EventLogDAO\getByAssoc(), NotificationDAO\getByAssoc(), EmailLogDAO\getByAssoc(), PKPAnnouncementTypeDAO\getByAssoc(), ReviewFormDAO\getByAssocId(), PKPAnnouncementDAO\getByAssocId(), ReviewObjectTypeDAO\getByContextId(), ControlledVocabEntryDAO\getByControlledVocabId(), EmailLogDAO\getByEventType(), ReviewObjectMetadataDAO\getByReviewObjectTypeId(), ArticleDAO\getBySetting(), PKPAnnouncementDAO\getByTypeId(), NotificationDAO\getByUserId(), ReferralDAO\getByUserId(), RTDAO\getContexts(), CopyeditorSubmissionDAO\getCopyeditorSubmissionsByCopyeditorId(), PKPEmailTemplateDAO\getEmailTemplates(), ExternalFeedDAO\getExternalFeedsByJournalId(), PKPGiftDAO\getGiftsByAssocId(), PKPGiftDAO\getGiftsByRecipient(), PKPGiftDAO\getGiftsByTypeAndRecipient(), GroupDAO\getGroups(), IssueDAO\getIssues(), JournalDAO\getJournals(), SectionDAO\getJournalSections(), UserDAO\getJournalUsersByField(), GroupMembershipDAO\getMemberships(), MetricsDAO\getMetrics(), PKPGiftDAO\getNotRedeemedGiftsByRecipient(), PKPGiftDAO\getNotRedeemedGiftsByTypeAndRecipient(), PKPAnnouncementDAO\getNumAnnouncementsByAssocId(), PKPAnnouncementDAO\getNumAnnouncementsNotExpiredByAssocId(), MetadataDescriptionDAO\getObjectsByAssocId(), CitationDAO\getObjectsByAssocId(), OJSCompletedPaymentDAO\getPaymentsByJournalId(), PublishedArticleDAO\getPublishedArticlesByJournalId(), IssueDAO\getPublishedIssues(), ReferralDAO\getPublishedReferralsForArticle(), SectionEditorSubmissionDAO\getReviewersForArticle(), ReviewerSubmissionDAO\getReviewerSubmissionsByReviewerId(), ReviewFormElementDAO\getReviewFormElementsByReviewForm(), ReviewFormResponseDAO\getReviewReviewFormResponseValues(), RTDAO\getSearches(), SectionDAO\getSections(), AuthSourceDAO\getSources(), LayoutEditorSubmissionDAO\getSubmissions(), ProofreaderSubmissionDAO\getSubmissions(), IndividualSubscriptionDAO\getSubscribedUsers(), InstitutionalSubscriptionDAO\getSubscribedUsers(), IndividualSubscriptionDAO\getSubscriptionByUserForJournal(), IndividualSubscriptionDAO\getSubscriptions(), InstitutionalSubscriptionDAO\getSubscriptions(), InstitutionalSubscriptionDAO\getSubscriptionsByInstitutionName(), IndividualSubscriptionDAO\getSubscriptionsByJournalId(), InstitutionalSubscriptionDAO\getSubscriptionsByJournalId(), InstitutionalSubscriptionDAO\getSubscriptionsByUser(), IndividualSubscriptionDAO\getSubscriptionsByUser(), InstitutionalSubscriptionDAO\getSubscriptionsByUserForJournal(), IndividualSubscriptionDAO\getSubscriptionsToRemind(), InstitutionalSubscriptionDAO\getSubscriptionsToRemind(), SubscriptionTypeDAO\getSubscriptionTypesByInstitutional(), SubscriptionTypeDAO\getSubscriptionTypesByJournalId(), ThesisDAO\getThesesByJournalId(), IssueDAO\getUnpublishedIssues(), ReviewFormDAO\getUnusedByAssocId(), ReviewFormDAO\getUsedByAssocId(), InterestDAO\getUserInterestIds(), PKPUserDAO\getUsersByField(), PKPUserGroupDAO\getUsersById(), RoleDAO\getUsersByJournalId(), RoleDAO\getUsersByRoleId(), EditorSubmissionDAO\getUsersNotAssignedToArticle(), PKPUserDAO\getUsersWithNoRole(), PKPUserGroupDAO\getUsersWithNoUserGroupAssignments(), and RTDAO\getVersions().

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 271 of file DAO.inc.php.

Referenced by ArticleSearchDAO\clearIndex(), flushCache(), and retrieveCached().

DAO::setDataSource ( $dataSource)

Set db conn.

Parameters
$dataSourceADONewConnection

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

Referenced by DAO().

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 211 of file DAO.inc.php.

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

Referenced by InstitutionalSubscriptionDAO\_deleteSubscriptionIPRanges(), ArticleSearchDAO\_insertKeyword(), SubscriptionDAO\_insertSubscription(), InstitutionalSubscriptionDAO\_insertSubscriptionIPRanges(), SubscriptionDAO\_updateSubscription(), PKPSubmissionFileDAO\assignRevisionToReviewRound(), ProcessDAO\authorizeProcess(), NotificationDAO\build(), ArticleDAO\changeArticleStatus(), BookForReviewDAO\changeBookForReviewStatus(), ObjectForReviewAssignmentDAO\changeStatus(), EventLogDAO\changeUser(), EmailLogDAO\changeUser(), CitationDAO\checkNextRawCitation(), ArticleSearchDAO\clearIndex(), PKPOAIDAO\clearTokens(), NotificationMailListDAO\confirmMailListSubscription(), CommentDAO\decrementChildCount(), AccessKeyDAO\deleteAccessKeyById(), ObjectForReviewAssignmentDAO\deleteAllByObjectId(), SuppFileDAO\deleteAllPubIds(), ArticleGalleyDAO\deleteAllPubIds(), ArticleDAO\deleteAllPubIds(), IssueDAO\deleteAllPubIds(), PKPSubmissionFileDAO\deleteAllRevisionsByReviewRound(), SessionDAO\deleteAllSessions(), ArticleDAO\deleteArticleById(), ArticleCommentDAO\deleteArticleCommentById(), ArticleCommentDAO\deleteArticleComments(), ArticleFileDAO\deleteArticleFileById(), ArticleFileDAO\deleteArticleFiles(), ArticleSearchDAO\deleteArticleKeywords(), BookForReviewAuthorDAO\deleteAuthorById(), PKPAuthorDAO\deleteAuthorById(), BookForReviewDAO\deleteBookForReviewById(), EmailLogDAO\deleteByAssoc(), PKPUserGroupDAO\deleteByContextId(), PKPUserGroupDAO\deleteById(), DataObjectTombstoneDAO\deleteById(), ReviewFormResponseDAO\deleteById(), ReviewFormElementDAO\deleteById(), ObjectForReviewPersonDAO\deleteById(), ReviewObjectTypeDAO\deleteById(), ReviewObjectMetadataDAO\deleteById(), NotificationDAO\deleteById(), ObjectForReviewAssignmentDAO\deleteById(), PKPAnnouncementDAO\deleteById(), ReviewFormDAO\deleteById(), PKPAnnouncementTypeDAO\deleteById(), PKPReviewAssignmentDAO\deleteById(), UsageStatsTemporaryRecordDAO\deleteByLoadId(), ReviewFormResponseDAO\deleteByReviewFormElementId(), ReviewFormResponseDAO\deleteByReviewId(), ObjectForReviewSettingsDAO\deleteByReviewObjectMetadataId(), CommentDAO\deleteBySubmissionId(), PKPReviewAssignmentDAO\deleteBySubmissionId(), CommentDAO\deleteComment(), RTDAO\deleteContext(), IssueDAO\deleteCustomIssueOrdering(), SectionDAO\deleteCustomSection(), SectionDAO\deleteCustomSectionOrdering(), DataverseFileDAO\deleteDataverseFileById(), SectionEditorSubmissionDAO\deleteDecisionsByArticle(), PKPEmailTemplateDAO\deleteDefaultEmailTemplatesByLocale(), EditAssignmentDAO\deleteEditAssignmentById(), EditAssignmentDAO\deleteEditAssignmentsByArticle(), SectionEditorsDAO\deleteEditor(), SectionEditorsDAO\deleteEditorsByJournalId(), SectionEditorsDAO\deleteEditorsBySectionId(), SectionEditorsDAO\deleteEditorsByUserId(), PKPEmailTemplateDAO\deleteEmailTemplateByKey(), PKPEmailTemplateDAO\deleteEmailTemplatesByAssoc(), PKPEmailTemplateDAO\deleteEmailTemplatesByLocale(), AccessKeyDAO\deleteExpiredKeys(), QueuedPaymentDAO\deleteExpiredQueuedPayments(), ExternalFeedDAO\deleteExternalFeedById(), IssueGalleyDAO\deleteGalleyById(), ArticleGalleyDAO\deleteGalleyById(), ArticleGalleyDAO\deleteGalleyImage(), PKPGiftDAO\deleteGiftById(), GroupDAO\deleteGroupById(), ArticleGalleyDAO\deleteImagesByGalley(), IssueDAO\deleteIssue(), IssueFileDAO\deleteIssueFileById(), IssueFileDAO\deleteIssueFiles(), JournalDAO\deleteJournalById(), GroupMembershipDAO\deleteMembershipByGroupId(), GroupMembershipDAO\deleteMembershipById(), GroupMembershipDAO\deleteMembershipByUserId(), NotificationSubscriptionSettingsDAO\deleteNotificationSubscriptionSettings(), DataObjectTombstoneDAO\deleteOAISetObjects(), FilterGroupDAO\deleteObject(), ObjectForReviewDAO\deleteObject(), CaptchaDAO\deleteObject(), EventLogDAO\deleteObject(), EmailLogDAO\deleteObject(), AuthSourceDAO\deleteObject(), MetadataDescriptionDAO\deleteObjectById(), ControlledVocabDAO\deleteObjectById(), ControlledVocabEntryDAO\deleteObjectById(), ProcessDAO\deleteObjectById(), PKPSignoffDAO\deleteObjectById(), CitationDAO\deleteObjectById(), FilterDAO\deleteObjectById(), ArticleDAO\deletePermissions(), PublishedArticleDAO\deletePublishedArticleByArticleId(), PublishedArticleDAO\deletePublishedArticleById(), PublishedArticleDAO\deletePublishedArticlesByIssueId(), PublishedArticleDAO\deletePublishedArticlesBySectionId(), QueuedPaymentDAO\deleteQueuedPayment(), UsageStatsTemporaryRecordDAO\deleteRecord(), ReferralDAO\deleteReferralById(), PKPSubmissionFileDAO\deleteReviewRoundAssignment(), SectionEditorSubmissionDAO\deleteReviewRoundsByArticle(), RoleDAO\deleteRole(), RoleDAO\deleteRoleByJournalId(), RoleDAO\deleteRoleByUserId(), RTDAO\deleteSearch(), RTDAO\deleteSearchesByContextId(), SectionDAO\deleteSectionById(), SessionDAO\deleteSessionById(), SessionDAO\deleteSessionByLastUsed(), SessionDAO\deleteSessionsByUserId(), DataObjectTombstoneSettingsDAO\deleteSetting(), ObjectForReviewSettingsDAO\deleteSetting(), JournalSettingsDAO\deleteSetting(), PluginSettingsDAO\deleteSetting(), SiteSettingsDAO\deleteSetting(), ReviewFormElementDAO\deleteSetting(), PKPUserSettingsDAO\deleteSetting(), ReviewObjectMetadataDAO\deleteSetting(), ObjectForReviewSettingsDAO\deleteSettings(), DataObjectTombstoneSettingsDAO\deleteSettings(), PKPUserSettingsDAO\deleteSettings(), JournalSettingsDAO\deleteSettingsByJournal(), PluginSettingsDAO\deleteSettingsByJournalId(), PKPUserGroupDAO\deleteSettingsByLocale(), NotificationSettingsDAO\deleteSettingsByNotificationId(), PluginSettingsDAO\deleteSettingsByPlugin(), DataverseStudyDAO\deleteStudyById(), IndividualSubscriptionDAO\deleteSubscriptionById(), InstitutionalSubscriptionDAO\deleteSubscriptionById(), SubscriptionTypeDAO\deleteSubscriptionTypeById(), SuppFileDAO\deleteSuppFileById(), TemporaryFileDAO\deleteTemporaryFileById(), TemporaryFileDAO\deleteTemporaryFilesByUserId(), ThesisDAO\deleteThesesByJournal(), ThesisDAO\deleteThesisById(), PKPUserDAO\deleteUserById(), RTDAO\deleteVersion(), ArticleXMLGalleyDAO\deleteXMLGalleys(), ProcessDAO\deleteZombies(), VersionDAO\disableVersion(), SubscriptionDAO\flagReminded(), CommentDAO\incrementChildCount(), ReferralDAO\incrementReferralCount(), IssueGalleyDAO\incrementViews(), ArticleGalleyDAO\incrementViews(), PublishedArticleDAO\incrementViewsByArticleId(), ArticleXMLGalleyDAO\incrementXMLViews(), UsageStatsTemporaryRecordDAO\insert(), AccessKeyDAO\insertAccessKey(), PKPAnnouncementDAO\insertAnnouncement(), PKPAnnouncementTypeDAO\insertAnnouncementType(), ArticleDAO\insertArticle(), ArticleCommentDAO\insertArticleComment(), ArticleFileDAO\insertArticleFile(), BookForReviewAuthorDAO\insertAuthor(), AuthorDAO\insertAuthor(), PKPEmailTemplateDAO\insertBaseEmailTemplate(), CaptchaDAO\insertCaptcha(), CommentDAO\insertComment(), OJSCompletedPaymentDAO\insertCompletedPayment(), RTDAO\insertContext(), IssueDAO\insertCustomIssueOrder(), SectionDAO\insertCustomSectionOrder(), DataverseFileDAO\insertDataverseFile(), EditAssignmentDAO\insertEditAssignment(), SectionEditorsDAO\insertEditor(), EditorSubmissionDAO\insertEditorSubmission(), ExternalFeedDAO\insertExternalFeed(), IssueGalleyDAO\insertGalley(), ArticleGalleyDAO\insertGalley(), ArticleGalleyDAO\insertGalleyImage(), GroupDAO\insertGroup(), IssueDAO\insertIssue(), IssueFileDAO\insertIssueFile(), JournalDAO\insertJournal(), GroupMembershipDAO\insertMembership(), NotificationSubscriptionSettingsDAO\insertNewRSSToken(), DataObjectTombstoneDAO\insertOAISetObjects(), FilterGroupDAO\insertObject(), MetadataDescriptionDAO\insertObject(), CitationDAO\insertObject(), ReviewFormResponseDAO\insertObject(), ProcessDAO\insertObject(), ObjectForReviewDAO\insertObject(), ReviewFormElementDAO\insertObject(), ControlledVocabDAO\insertObject(), ObjectForReviewPersonDAO\insertObject(), PKPGiftDAO\insertObject(), FilterDAO\insertObject(), ObjectForReviewAssignmentDAO\insertObject(), ReviewObjectTypeDAO\insertObject(), EventLogDAO\insertObject(), ReviewObjectMetadataDAO\insertObject(), ControlledVocabEntryDAO\insertObject(), DataObjectTombstoneDAO\insertObject(), EmailLogDAO\insertObject(), BookForReviewDAO\insertObject(), NotificationDAO\insertObject(), PKPSignoffDAO\insertObject(), ArticleSearchDAO\insertObject(), ReviewFormDAO\insertObject(), PKPReviewAssignmentDAO\insertObject(), ArticleSearchDAO\insertObjectKeyword(), PublishedArticleDAO\insertPublishedArticle(), QueuedPaymentDAO\insertQueuedPayment(), MetricsDAO\insertRecord(), RoleDAO\insertRole(), RTDAO\insertSearch(), SectionDAO\insertSection(), SessionDAO\insertSession(), SiteDAO\insertSite(), AuthSourceDAO\insertSource(), DataverseStudyDAO\insertStudy(), InstitutionalSubscriptionDAO\insertSubscription(), SubscriptionTypeDAO\insertSubscriptionType(), SuppFileDAO\insertSuppFile(), TemporaryFileDAO\insertTemporaryFile(), ThesisDAO\insertThesis(), PKPOAIDAO\insertToken(), PayPalDAO\insertTransaction(), PKPUserDAO\insertUser(), PKPUserGroupDAO\insertUserGroup(), VersionDAO\insertVersion(), RTDAO\insertVersion(), ArticleXMLGalleyDAO\insertXMLGalleys(), PKPEmailTemplateDAO\installEmailTemplateData(), PKPEmailTemplateDAO\installEmailTemplates(), IssueDAO\moveCustomIssueOrder(), SectionDAO\moveCustomSectionOrder(), MetricsDAO\purgeLoadBatch(), MetricsDAO\purgeRecords(), ArticleDAO\removeArticlesFromSection(), ObjectForReviewPersonDAO\resequence(), ControlledVocabEntryDAO\resequence(), ReviewObjectMetadataDAO\resequence(), BookForReviewAuthorDAO\resequenceAuthors(), PKPAuthorDAO\resequenceAuthors(), RTDAO\resequenceContexts(), IssueDAO\resequenceCustomIssueOrders(), SectionDAO\resequenceCustomSectionOrders(), ExternalFeedDAO\resequenceExternalFeeds(), IssueGalleyDAO\resequenceGalleys(), ArticleGalleyDAO\resequenceGalleys(), GroupDAO\resequenceGroups(), JournalDAO\resequenceJournals(), GroupMembershipDAO\resequenceMemberships(), PublishedArticleDAO\resequencePublishedArticles(), ReviewFormElementDAO\resequenceReviewFormElements(), ReviewFormDAO\resequenceReviewForms(), RTDAO\resequenceSearches(), SectionDAO\resequenceSections(), SubscriptionTypeDAO\resequenceSubscriptionTypes(), SuppFileDAO\resequenceSuppFiles(), PKPAuthorDAO\resetPrimaryContact(), NotificationDAO\setDateRead(), AuthSourceDAO\setDefault(), InterestDAO\setUserInterests(), NotificationMailListDAO\subscribeGuest(), AccessKeyDAO\transferAccessKeys(), EditorSubmissionDAO\transferEditorDecisions(), NotificationDAO\transferNotifications(), PKPSignoffDAO\transferSignoffs(), NotificationMailListDAO\unsubscribeGuest(), ArticleDAO\updateArticle(), ArticleCommentDAO\updateArticleComment(), ArticleFileDAO\updateArticleFile(), BookForReviewAuthorDAO\updateAuthor(), AuthorDAO\updateAuthor(), PKPEmailTemplateDAO\updateBaseEmailTemplate(), CommentDAO\updateComment(), RTDAO\updateContext(), IssueDAO\updateCurrentIssue(), updateDataObjectSettings(), DataverseFileDAO\updateDataverseFile(), EditAssignmentDAO\updateEditAssignment(), ExternalFeedDAO\updateExternalFeed(), IssueGalleyDAO\updateGalley(), ArticleGalleyDAO\updateGalley(), IssueDAO\updateIssue(), IssueFileDAO\updateIssueFile(), JournalDAO\updateJournal(), ScheduledTaskDAO\updateLastRunTime(), PKPEmailTemplateDAO\updateLocaleEmailTemplateData(), NotificationSettingsDAO\updateNotificationSetting(), NotificationSubscriptionSettingsDAO\updateNotificationSubscriptionSettings(), DataObjectTombstoneDAO\updateOAISetObjects(), SessionDAO\updateObject(), MetadataDescriptionDAO\updateObject(), SiteDAO\updateObject(), ReviewFormResponseDAO\updateObject(), FilterGroupDAO\updateObject(), TemporaryFileDAO\updateObject(), ObjectForReviewDAO\updateObject(), ReviewFormElementDAO\updateObject(), ControlledVocabDAO\updateObject(), GroupMembershipDAO\updateObject(), ObjectForReviewPersonDAO\updateObject(), ReviewObjectTypeDAO\updateObject(), ObjectForReviewAssignmentDAO\updateObject(), PKPAnnouncementDAO\updateObject(), AccessKeyDAO\updateObject(), ReviewObjectMetadataDAO\updateObject(), GroupDAO\updateObject(), AuthSourceDAO\updateObject(), DataObjectTombstoneDAO\updateObject(), PKPGiftDAO\updateObject(), CaptchaDAO\updateObject(), PKPSignoffDAO\updateObject(), ReviewFormDAO\updateObject(), ControlledVocabEntryDAO\updateObject(), PKPAnnouncementTypeDAO\updateObject(), BookForReviewDAO\updateObject(), PKPUserDAO\updateObject(), CitationDAO\updateObject(), FilterDAO\updateObject(), PublishedArticleDAO\updatePublishedArticle(), PublishedArticleDAO\updatePublishedArticleField(), QueuedPaymentDAO\updateQueuedPayment(), ReferralDAO\updateReferral(), PKPReviewAssignmentDAO\updateReviewAssignment(), ReviewerSubmissionDAO\updateReviewerSubmission(), RTDAO\updateSearch(), SectionDAO\updateSection(), SectionEditorSubmissionDAO\updateSectionEditorSubmission(), DataObjectTombstoneSettingsDAO\updateSetting(), PluginSettingsDAO\updateSetting(), JournalSettingsDAO\updateSetting(), SiteSettingsDAO\updateSetting(), PKPUserSettingsDAO\updateSetting(), PKPUserGroupDAO\updateSetting(), ArticleDAO\updateSetting(), DataverseStudyDAO\updateStudy(), InstitutionalSubscriptionDAO\updateSubscription(), SubscriptionTypeDAO\updateSubscriptionType(), SuppFileDAO\updateSuppFile(), ThesisDAO\updateThesis(), and RTDAO\updateVersion().

Member Data Documentation

DAO::$_dataSource

The database connection object

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

Referenced by getDataSource().


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