/**
* hasDisplayTitle
* @param integer $intFileId
* @return boolean
* @author Thomas Schedler <*****@*****.**>
*/
public function hasDisplayTitle($intFileId)
{
$this->core->logger->debug('core->models->Model_Files->hasDisplayTitle(' . $intFileId . ')');
try {
$this->getFileTable();
if ($intFileId != '' && $intFileId > 0) {
$objSelect = $this->objFileTable->select();
$objSelect->setIntegrityCheck(false);
$objSelect->from('files', array('id'));
$objSelect->join('fileTitles', 'fileTitles.idFiles = files.id AND fileTitles.isDisplayTitle = 1', array('title'));
$objSelect->where('files.id = ?', $intFileId);
$objRowset = $this->objFileTable->fetchAll($objSelect);
return count($objRowset) > 0 ? true : false;
}
} catch (Exception $exc) {
$this->core->logger->err($exc);
}
}
public function getAllImageFiles()
{
$this->core->logger->debug('core->models->Model_Files->getAllImageFiles()');
try {
$this->getFileTable();
$objSelect = $this->objFileTable->select();
$objSelect->setIntegrityCheck(false);
/**
* SELECT files.id, files.fileId, files.filename, files.created, files.extension, files.mimeType, files.size, fileAttributes.xDim, fileAttributes.yDim
* FROM files
* LEFT JOIN fileAttributes ON
* fileAttributes.idFiles = files.id
* WHERE files.isImage = 1
*/
$objSelect->from('files', array('id', 'fileId', 'filename', 'created', 'extension', 'mimeType', 'size'));
$objSelect->joinLeft('fileAttributes', 'fileAttributes.idFiles = files.id', array('xDim', 'yDim'));
$objSelect->where('files.isImage = 1');
return $this->objFileTable->fetchAll($objSelect);
} catch (Exception $exc) {
$this->core->logger->err($exc);
}
}
