/**
* count notes
*
* @param Tinebase_Model_NoteFilter $_filter
* @return int notes count
*/
public function searchNotesCount(Tinebase_Model_NoteFilter $_filter)
{
$select = $this->_db->select()->from(array('notes' => SQL_TABLE_PREFIX . 'notes'), array('count' => 'COUNT(' . $this->_db->quoteIdentifier('id') . ')'));
Tinebase_Backend_Sql_Filter_FilterGroup::appendFilters($select, $_filter, $this);
//$_filter->appendFilterSql($select);
$result = $this->_db->fetchOne($select);
return $result;
}
/**
* get select for tags query
*
* @param string|array $_recordId
* @param string $_applicationId
* @param mixed $_cols
* @return Zend_Db_Select
*/
protected function _getSelect($_recordId, $_applicationId, $_cols = '*')
{
array_walk($_recordId, function (&$value, $index) {
$value = (string) $value;
});
$select = $this->_db->select()->from(array('tagging' => SQL_TABLE_PREFIX . 'tagging'), $_cols)->join(array('tags' => SQL_TABLE_PREFIX . 'tags'), $this->_db->quoteIdentifier('tagging.tag_id') . ' = ' . $this->_db->quoteIdentifier('tags.id'))->where($this->_db->quoteIdentifier('application_id') . ' = ?', $_applicationId)->where($this->_db->quoteIdentifier('record_id') . ' IN (?) ', (array) $_recordId)->where($this->_db->quoteIdentifier('is_deleted') . ' = 0');
return $select;
}
/**
* get all note types
*
* @param boolean|optional $onlyNonSystemNotes
* @return Tinebase_Record_RecordSet of Tinebase_Model_NoteType
*/
public function getNoteTypes($onlyNonSystemNotes = false, $onlyIds = false)
{
$select = $this->_db->select()->from(array('note_types' => SQL_TABLE_PREFIX . 'note_types'), $onlyIds ? 'id' : '*');
if ($onlyNonSystemNotes) {
$select->where($this->_db->quoteIdentifier('is_user_type') . ' = 1');
}
$stmt = $this->_db->query($select);
if ($onlyIds) {
$types = $stmt->fetchAll(Zend_Db::FETCH_COLUMN);
} else {
$rows = $stmt->fetchAll(Zend_Db::FETCH_ASSOC);
$types = new Tinebase_Record_RecordSet('Tinebase_Model_NoteType', $rows, true);
}
return $types;
}
/**
* merge duplicate shared tags
*
* @param string $model record model for which tags should be merged
* @param boolean $deleteObsoleteTags
* @param boolean $ignoreAcl
*
* @see 0007354: function for merging duplicate tags
*/
public function mergeDuplicateSharedTags($model, $deleteObsoleteTags = TRUE, $ignoreAcl = FALSE)
{
$select = $this->_db->select()->from(array('tags' => SQL_TABLE_PREFIX . 'tags'), 'name')->where($this->_db->quoteIdentifier('type') . ' = ?', Tinebase_Model_Tag::TYPE_SHARED)->where($this->_db->quoteIdentifier('is_deleted') . ' = 0')->group('name')->having('COUNT(' . $this->_db->quoteIdentifier('name') . ') > 1');
$queryResult = $this->_db->fetchAll($select);
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' Found ' . count($queryResult) . ' duplicate tag names.');
}
$controller = Tinebase_Core::getApplicationInstance($model);
if ($ignoreAcl) {
$containerChecks = $controller->doContainerACLChecks(FALSE);
}
$recordFilterModel = $model . 'Filter';
foreach ($queryResult as $duplicateTag) {
$filter = new Tinebase_Model_TagFilter(array('name' => $duplicateTag['name'], 'type' => Tinebase_Model_Tag::TYPE_SHARED));
$paging = new Tinebase_Model_Pagination(array('sort' => 'creation_time'));
$tagsWithSameName = $this->searchTags($filter, $paging);
$targetTag = $tagsWithSameName->getFirstRecord();
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' Merging tag ' . $duplicateTag['name'] . '. Found ' . count($tagsWithSameName) . ' tags with this name.');
}
foreach ($tagsWithSameName as $tag) {
if ($tag->getId() === $targetTag->getId()) {
// skip target (oldest) tag
continue;
}
$recordFilter = new $recordFilterModel(array(array('field' => 'tag', 'operator' => 'in', 'value' => array($tag->getId()))));
$recordIdsWithTagToMerge = $controller->search($recordFilter, NULL, FALSE, TRUE);
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' Found ' . count($recordIdsWithTagToMerge) . ' ' . $model . '(s) with tags to be merged.');
}
if (!empty($recordIdsWithTagToMerge)) {
$recordFilter = new $recordFilterModel(array(array('field' => 'id', 'operator' => 'in', 'value' => $recordIdsWithTagToMerge)));
$this->attachTagToMultipleRecords($recordFilter, $targetTag);
$this->detachTagsFromMultipleRecords($recordFilter, $tag->getId());
}
// check occurrence of the merged tag and remove it if obsolete
$tag = $this->get($tag);
if ($deleteObsoleteTags && $tag->occurrence == 0) {
$this->deleteTags($tag->getId(), $ignoreAcl);
}
}
}
if ($ignoreAcl) {
/** @noinspection PhpUndefinedVariableInspection */
$controller->doContainerACLChecks($containerChecks);
}
}
/**
* get registration by hash
*
* @param string $_hash the hash (md5 coded username) from the registration mail
* @return Tinebase_Model_Registration the registration object
*
*/
public function getRegistrationByHash($_hash)
{
$select = $this->_db->select()->from(SQL_TABLE_PREFIX . 'registrations')->where($this->_db->quoteIdentifier('login_hash') . ' = ?', $_hash);
$stmt = $select->query();
$row = $stmt->fetch(Zend_Db::FETCH_ASSOC);
if ($row === false) {
throw new Tinebase_Exception_Record_NotDefined('registration entry not found error');
}
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . "Tinebase_Model_Registration::row values: \n" . print_r($row, true));
}
try {
$registration = new Tinebase_Model_Registration();
$registration->setFromArray($row);
} catch (Exception $e) {
$validationErrors = $registration->getValidationErrors();
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . $e->getMessage() . "\n" . "Tinebase_Model_Registration::validation_errors: \n" . print_r($validationErrors, true));
}
throw $e;
}
return $registration;
}
/**
* returns rights for given application and accountId
*
* @param string $_application the name of the application
* @param int $_accountId the numeric account id
* @return array list of rights
* @throws Tinebase_Exception_AccessDenied
*
* @todo add right group by to statement if possible or remove duplicates in result array
*/
public function getApplicationRights($_application, $_accountId)
{
$application = Tinebase_Application::getInstance()->getApplicationByName($_application);
if ($application->status != 'enabled') {
throw new Tinebase_Exception_AccessDenied('User has no rights. the application is disabled.');
}
$roleMemberships = $this->getRoleMemberships($_accountId);
$select = $this->_db->select()->from(SQL_TABLE_PREFIX . 'role_rights', array('account_rights' => Tinebase_Backend_Sql_Command::getAggregateFunction($this->_db, $this->_db->quoteIdentifier(SQL_TABLE_PREFIX . 'role_rights.right'))))->where($this->_db->quoteInto($this->_db->quoteIdentifier(SQL_TABLE_PREFIX . 'role_rights.application_id') . ' = ?', $application->getId()))->where($this->_db->quoteInto($this->_db->quoteIdentifier('role_id') . ' IN (?)', $roleMemberships))->group(SQL_TABLE_PREFIX . 'role_rights.application_id');
$stmt = $this->_db->query($select);
$row = $stmt->fetch(Zend_Db::FETCH_ASSOC);
if ($row === false) {
return array();
}
$rights = explode(',', $row['account_rights']);
// remove duplicates
$result = array();
foreach ($rights as $right) {
if (!in_array($right, $result)) {
$result[] = $right;
}
}
return $result;
}
