1: <?php
  2: 
  3: /**
  4:  * This file contains the content version collection and item class.
  5:  *
  6:  * @package          Core
  7:  * @subpackage       GenericDB_Model
  8:  * @author           Jann Dieckmann
  9:  * @copyright        four for business AG <www.4fb.de>
 10:  * @license          http://www.contenido.org/license/LIZENZ.txt
 11:  * @link             http://www.4fb.de
 12:  * @link             http://www.contenido.org
 13:  */
 14: 
 15: defined('CON_FRAMEWORK') || die('Illegal call: Missing framework initialization - request aborted.');
 16: 
 17: /**
 18:  * Content Version collection
 19:  *
 20:  * @package Core
 21:  * @subpackage GenericDB_Model
 22:  */
 23: class cApiContentVersionCollection extends ItemCollection {
 24: 
 25:     /**
 26:      * Create a new collection of items.
 27:      */
 28:     public function __construct() {
 29:         parent::__construct(cRegistry::getDbTableName('content_version'), 'idcontentversion');
 30:         $this->_setItemClass('cApiContentVersion');
 31: 
 32:         // set the join partners so that joins can be used via link() method
 33:         $this->_setJoinPartner('cApiArticleLanguageCollection');
 34:         $this->_setJoinPartner('cApiTypeCollection');
 35:     }
 36: 
 37:     /**
 38:      * Creates a content version entry.
 39:      *
 40:      * @param mixed[] $parameters{
 41:      *  @type int $idContent
 42:      *  @type int $idArtLang
 43:      *  @type int $idType
 44:      *  @type int $typeId
 45:      *  @type string $value
 46:      *  @type int $version
 47:      *  @type string $author
 48:      *  @type string $created
 49:      *  @type string $lastModified
 50:      * }
 51:      * @return cApiContentVersion
 52:      */
 53:     public function create(array $parameters) {
 54:         global $auth;
 55: 
 56:         if (empty($author)) {
 57:             $author = $auth->auth['uname'];
 58:         }
 59:         if (empty($created)) {
 60:             $created = date('Y-m-d H:i:s');
 61:         }
 62:         if (empty($lastmodified)) {
 63:             $lastmodified = date('Y-m-d H:i:s');
 64:         }
 65: 
 66:         $item = $this->createNewItem();
 67: 
 68:         // populate item w/ values
 69:         foreach (array_keys($parameters) as $key) {
 70:             $item->set($key, $parameters[$key]);
 71:         }
 72:     $item->store();
 73: 
 74:         return $item;
 75:     }
 76: 
 77:     /**
 78:      * Gets idcontentversions by where clause
 79:      *
 80:      * @param string $where
 81:      * @return array $ids
 82:      */
 83:     public function getIdsByWhereClause($where){
 84: 
 85:         $this->select($where);
 86: 
 87:         $ids = array();
 88:         while($item = $this->next()){
 89:             $ids[] = $item->get('idcontentversion');
 90:         }
 91:         return $ids;
 92: 
 93:     }
 94: 
 95: }
 96: 
 97: /**
 98:  * Content Version item
 99:  *
100:  * @package Core
101:  * @subpackage GenericDB_Model
102:  */
103: class cApiContentVersion extends Item {
104: 
105:     /**
106:      * Constructor Function
107:      *
108:      * @param mixed $id
109:      *         Specifies the ID of item to load
110:      */
111:     public function __construct($id = false) {
112:         parent::__construct(cRegistry::getDbTableName('content_version'), 'idcontentversion');
113:         $this->setFilters(array(), array());
114:         if ($id !== false) {
115:             $this->loadByPrimaryKey($id);
116:         }
117:     }
118: 
119:     /**
120:      * Userdefined setter for item fields.
121:      *
122:      * @todo should return return value of overloaded method
123:      * @param string $name
124:      * @param mixed $value
125:      * @param bool $safe
126:      *         Flag to run defined inFilter on passed value
127:      */
128:     public function setField($name, $value, $safe = true) {
129:         parent::setField($name, $value, $safe);
130:     }
131: 
132:     /**
133:      * Mark this Content Version as current Content
134:      */
135:     public function markAsCurrent() {
136: 
137:         // try to get item from database
138:         $content = new cApiContent();
139:         $succ = $content->loadByArticleLanguageIdTypeAndTypeId(
140:             $this->get('idartlang'),
141:             $this->get('idtype'),
142:             $this->get('typeid')
143:         );
144: 
145:         // create new item if none has been found
146:         if (!$succ) {
147:             $coll = new cApiContentCollection();
148:             $content = $coll->createNewItem();
149:         }
150: 
151:         // update/set attributes
152:         $content->set('idartlang', $this->get('idartlang'));
153:         $content->set('idtype', $this->get('idtype'));
154:         $content->set('typeid', $this->get('typeid'));
155:         $content->set('value', $this->get('value'));
156:         $content->set('author', $this->get('author'));
157:         $content->set('created', $this->get('created'));
158:         $content->set('lastmodified', $this->get('lastmodified'));
159: 
160:         // store item
161:         $content->store();
162: 
163:     }
164: 
165:     /**
166:      * Creates a new, editable Version with same properties as this Content Version
167:      *
168:      * @param string $version
169:      * @param mixed $deleted
170:      */
171:     public function markAsEditable($version, $deleted) {
172: 
173:         // get parameters for editable version
174:         $parameters = $this->toArray();
175:         unset($parameters['idcontentversion']);
176:         $parameters['version'] = $version;
177: 
178:         // create editable version
179:         $contentVersionColl = new cApiContentVersionCollection();
180:         $contentVersion = $contentVersionColl->create($parameters);
181:         if ($deleted == 1) {
182:             $contentVersion->set('deleted', $deleted);
183:         }
184: 
185:         $contentVersion->store();
186: 
187:     }
188: 
189:     /**
190:      * Loads a content entry by its article language id, idtype, type id and version.
191:      *
192:      * @param mixed $contentParameters[]{
193:      *  @type int idartlang
194:      *  @type int idtype
195:      *  @type int typeid
196:      *  @type int $version
197:      * }
198:      * @return bool
199:      */
200:     public function loadByArticleLanguageIdTypeTypeIdAndVersion(array $contentParameters) {
201:         //$db = cRegistry::getDb();
202:         $props = array(
203:             'idartlang' => $contentParameters['idartlang'],
204:             'idtype' => $contentParameters['idtype'],
205:             'typeid' => $contentParameters['typeid'],
206:             'version' => $contentParameters['version']
207:         );
208:         $recordSet = $this->_oCache->getItemByProperties($props);
209:         if ($recordSet) {
210:             // entry in cache found, load entry from cache
211:             $this->loadByRecordSet($recordSet);
212:             return true;
213:         } else {
214:             $where = $this->db->prepare('idartlang = %d AND idtype = %d AND typeid = %d AND version <= %d GROUP BY pk desc LIMIT 1', $contentParameters['idartlang'], $contentParameters['idtype'], $contentParameters['typeid'], $contentParameters['version']);
215:             return $this->_loadByWhereClause($where);
216:         }
217: 
218:     }
219: 
220: }
221: