/** * 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); } }