1: <?php
  2: /**
  3:  * This file contains the upload meta collection and item class.
  4:  *
  5:  * @package          Core
  6:  * @subpackage       GenericDB_Model
  7:  * @version          SVN Revision $Rev:$
  8:  *
  9:  * @author           Dominik Ziegler
 10:  * @copyright        four for business AG <www.4fb.de>
 11:  * @license          http://www.contenido.org/license/LIZENZ.txt
 12:  * @link             http://www.4fb.de
 13:  * @link             http://www.contenido.org
 14:  */
 15: 
 16: defined('CON_FRAMEWORK') || die('Illegal call: Missing framework initialization - request aborted.');
 17: 
 18: /**
 19:  * Upload meta collection
 20:  *
 21:  * @package Core
 22:  * @subpackage GenericDB_Model
 23:  */
 24: class cApiUploadMetaCollection extends ItemCollection {
 25: 
 26:     public function __construct() {
 27:         global $cfg;
 28:         parent::__construct($cfg['tab']['upl_meta'], 'id_uplmeta');
 29:         $this->_setItemClass('cApiUploadMeta');
 30: 
 31:         // set the join partners so that joins can be used via link() method
 32:         $this->_setJoinPartner('cApiUploadCollection');
 33:     }
 34: 
 35:     /**
 36:      * Creates a upload meta entry.
 37:      *
 38:      * @global object $auth
 39:      * @param int $idupl
 40:      * @param int $idlang
 41:      * @param string $medianame
 42:      * @param string $description
 43:      * @param string $keywords
 44:      * @param string $internal_notice
 45:      * @param string $copyright
 46:      * @param string $author
 47:      * @param string $created
 48:      * @param string $modified
 49:      * @param string $modifiedby
 50:      * @return cApiUploadMeta
 51:      */
 52:     public function create($idupl, $idlang, $medianame = '', $description = '', $keywords = '', $internal_notice = '', $copyright = '', $author = '', $created = '', $modified = '', $modifiedby = '') {
 53:         global $auth;
 54: 
 55:         if (empty($author)) {
 56:             $author = $auth->auth['uname'];
 57:         }
 58:         if (empty($created)) {
 59:             $created = date('Y-m-d H:i:s');
 60:         }
 61:         if (empty($modified)) {
 62:             $modified = date('Y-m-d H:i:s');
 63:         }
 64: 
 65:         $oItem = parent::createNewItem();
 66: 
 67:         $oItem->set('idupl', $idupl);
 68:         $oItem->set('idlang', $idlang);
 69:         $oItem->set('medianame', $medianame);
 70:         $oItem->set('description', $description);
 71:         $oItem->set('keywords', $keywords);
 72:         $oItem->set('internal_notice', $internal_notice);
 73:         $oItem->set('author', $author);
 74:         $oItem->set('created', $created);
 75:         $oItem->set('modified', $modified);
 76:         $oItem->set('modifiedby', $modifiedby);
 77:         $oItem->set('copyright', $copyright);
 78:         $oItem->store();
 79: 
 80:         return $oItem;
 81:     }
 82: 
 83: }
 84: 
 85: /**
 86:  * Upload meta item
 87:  *
 88:  * @package Core
 89:  * @subpackage GenericDB_Model
 90:  */
 91: class cApiUploadMeta extends Item {
 92: 
 93:     /**
 94:      * Constructor Function
 95:      *
 96:      * @param mixed $mId Specifies the ID of item to load
 97:      */
 98:     public function __construct($mId = false) {
 99:         global $cfg;
100:         parent::__construct($cfg['tab']['upl_meta'], 'id_uplmeta');
101:         $this->setFilters(array(), array());
102:         if ($mId !== false) {
103:             $this->loadByPrimaryKey($mId);
104:         }
105:     }
106: 
107:     /**
108:      * Loads an upload meta entry by upload id and language id
109:      *
110:      * @param int $idupl
111:      * @param int $idlang
112:      * @return bool
113:      */
114:     public function loadByUploadIdAndLanguageId($idupl, $idlang) {
115:         $aProps = array(
116:             'idupl' => $idupl,
117:             'idlang' => $idlang
118:         );
119:         $aRecordSet = $this->_oCache->getItemByProperties($aProps);
120:         if ($aRecordSet) {
121:             // entry in cache found, load entry from cache
122:             $this->loadByRecordSet($aRecordSet);
123:             return true;
124:         } else {
125:             $where = $this->db->prepare('idupl = %d AND idlang = %d', $idupl, $idlang);
126:             return $this->_loadByWhereClause($where);
127:         }
128:     }
129: 
130:     /**
131:      * Userdefined setter for upload meta fields.
132:      *
133:      * @param string $name
134:      * @param mixed $value
135:      * @param bool $bSafe Flag to run defined inFilter on passed value
136:      */
137:     public function setField($name, $value, $bSafe = true) {
138:         switch ($name) {
139:             case 'idupl':
140:             case 'idlang':
141:                 $value = (int) $value;
142:                 break;
143:         }
144: 
145:         parent::setField($name, $value, $bSafe);
146:     }
147: 
148: }
149: