1: <?php
  2: /**
  3:  * This file contains the category language collection and item class.
  4:  *
  5:  * @package Core
  6:  * @subpackage GenericDB_Model
  7:  * @author Timo Hummel
  8:  * @copyright four for business AG <www.4fb.de>
  9:  * @license http://www.contenido.org/license/LIZENZ.txt
 10:  * @link http://www.4fb.de
 11:  * @link http://www.contenido.org
 12:  */
 13: 
 14: defined('CON_FRAMEWORK') || die('Illegal call: Missing framework initialization - request aborted.');
 15: 
 16: /**
 17:  * Category language collection
 18:  *
 19:  * @package Core
 20:  * @subpackage GenericDB_Model
 21:  */
 22: class cApiCategoryLanguageCollection extends ItemCollection {
 23: 
 24:     /**
 25:      * Constructor to create an instance of this class.
 26:      *
 27:      * @param string $select [optional]
 28:      *         where clause to use for selection (see ItemCollection::select())
 29:      */
 30:     public function __construct($select = false) {
 31:         global $cfg;
 32:         parent::__construct($cfg['tab']['cat_lang'], 'idcatlang');
 33:         $this->_setItemClass('cApiCategoryLanguage');
 34: 
 35:         // set the join partners so that joins can be used via link() method
 36:         $this->_setJoinPartner('cApiCategoryCollection');
 37:         $this->_setJoinPartner('cApiLanguageCollection');
 38:         $this->_setJoinPartner('cApiTemplateConfigurationCollection');
 39: 
 40:         if ($select !== false) {
 41:             $this->select($select);
 42:         }
 43:     }
 44: 
 45:     /**
 46:      * Creates a category language entry.
 47:      *
 48:      * @param int $idcat
 49:      * @param int $idlang
 50:      * @param string $name
 51:      * @param string $urlname
 52:      * @param string $urlpath [optional]
 53:      * @param int $idtplcfg [optional]
 54:      * @param int $visible [optional]
 55:      * @param int $public [optional]
 56:      * @param int $status [optional]
 57:      * @param string $author [optional]
 58:      * @param int $startidartlang [optional]
 59:      * @param string $created [optional]
 60:      * @param string $lastmodified [optional]
 61:      * @return cApiCategoryLanguage
 62:      */
 63:     public function create($idcat, $idlang, $name, $urlname, $urlpath = '', $idtplcfg = 0, $visible = 0, $public = 0, $status = 0, $author = '', $startidartlang = 0, $created = '', $lastmodified = '') {
 64:         global $auth;
 65: 
 66:         if (empty($author)) {
 67:             $author = $auth->auth['uname'];
 68:         }
 69:         if (empty($created)) {
 70:             $created = date('Y-m-d H:i:s');
 71:         }
 72:         if (empty($lastmodified)) {
 73:             $lastmodified = date('Y-m-d H:i:s');
 74:         }
 75: 
 76:         $oItem = $this->createNewItem();
 77: 
 78:         $oItem->set('idcat', $idcat);
 79:         $oItem->set('idlang', $idlang);
 80:         $oItem->set('name', $name);
 81:         $oItem->set('urlname', $urlname);
 82:         $oItem->set('urlpath', $urlpath);
 83:         $oItem->set('idtplcfg', $idtplcfg);
 84:         $oItem->set('visible', $visible);
 85:         $oItem->set('public', $public);
 86:         $oItem->set('status', $status);
 87:         $oItem->set('author', $author);
 88:         $oItem->set('created', $created);
 89:         $oItem->set('lastmodified', $lastmodified);
 90:         $oItem->store();
 91: 
 92:         return $oItem;
 93:     }
 94: 
 95:     /**
 96:      * Returns startidartlang of articlelanguage by category id and language id
 97:      *
 98:      * @param int $idcat
 99:      * @param int $idlang
100:      * @return int
101:      */
102:     public function getStartIdartlangByIdcatAndIdlang($idcat, $idlang) {
103:         $sql = "SELECT startidartlang FROM `" . $this->table . "` WHERE idcat = " . (int) $idcat . " AND idlang = " . (int) $idlang . " AND startidartlang != 0";
104:         $this->db->query($sql);
105:         return ($this->db->nextRecord()) ? $this->db->f('startidartlang') : 0;
106:     }
107: 
108:     /**
109:      * Returns article id of articlelanguages startarticle by category id and
110:      * language id
111:      *
112:      * @param int $idcat
113:      * @param int $idlang
114:      * @return int
115:      */
116:     public function getStartIdartByIdcatAndIdlang($idcat, $idlang) {
117:         global $cfg;
118:         $sql = "SELECT al.idart FROM `" . $cfg['tab']['art_lang'] . "` AS al, `" . $this->table . "` " . "AS cl WHERE cl.idcat = " . (int) $idcat . " AND cl.startidartlang != 0 AND " . "cl.idlang = " . (int) $idlang . " AND cl.idlang = al.idlang AND cl.startidartlang = al.idartlang";
119:         $this->db->query($sql);
120:         return ($this->db->nextRecord()) ? $this->db->f('idart') : 0;
121:     }
122: 
123:     /**
124:      * Checks if passed idartlang is a start article.
125:      *
126:      * @param int $idartlang
127:      * @param int $idcat [optional]
128:      *         Check category id additionally
129:      * @param int $idlang [optional]
130:      *         Check language id additionally
131:      * @return bool
132:      */
133:     public function isStartArticle($idartlang, $idcat = NULL, $idlang = NULL) {
134:         $where = 'startidartlang = ' . (int) $idartlang;
135:         if (is_numeric($idcat)) {
136:             $where .= ' AND idcat = ' . $idcat;
137:         }
138:         if (is_numeric($idlang)) {
139:             $where .= ' AND idlang = ' . $idlang;
140:         }
141:         $where .= ' AND startidartlang != 0';
142: 
143:         $sql = "SELECT startidartlang FROM `" . $this->table . "` WHERE " . $where;
144:         $this->db->query($sql);
145:         return ($this->db->nextRecord() && $this->db->f('startidartlang') != 0);
146:     }
147: }
148: 
149: /**
150:  * Category language item
151:  *
152:  * @package Core
153:  * @subpackage GenericDB_Model
154:  */
155: class cApiCategoryLanguage extends Item {
156: 
157:     /**
158:      * Constructor to create an instance of this class.
159:      *
160:      * @param mixed $mId [optional]
161:      *         Specifies the ID of item to load
162:      */
163:     public function __construct($mId = false) {
164:         global $cfg;
165:         parent::__construct($cfg['tab']['cat_lang'], 'idcatlang');
166:         $this->setFilters(array(), array());
167:         if ($mId !== false) {
168:             $this->loadByPrimaryKey($mId);
169:         }
170:     }
171: 
172:     /**
173:      * Load data by category id and language id
174:      *
175:      * @param int $idcat
176:      *         Category id
177:      * @param int $idlang
178:      *         Language id
179:      * @return bool
180:      *         true on success, otherwise false
181:      */
182:     public function loadByCategoryIdAndLanguageId($idcat, $idlang) {
183:         $aProps = array(
184:             'idcat' => $idcat,
185:             'idlang' => $idlang
186:         );
187:         $aRecordSet = $this->_oCache->getItemByProperties($aProps);
188:         if ($aRecordSet) {
189:             // entry in cache found, load entry from cache
190:             $this->loadByRecordSet($aRecordSet);
191:             return true;
192:         } else {
193:             $where = $this->db->prepare('idcat = %d AND idlang = %d', $idcat, $idlang);
194:             return $this->_loadByWhereClause($where);
195:         }
196:     }
197: 
198:     /**
199:      * Userdefined setter for article language fields.
200:      *
201:      * @param string $name
202:      * @param mixed $value
203:      * @param bool $safe [optional]
204:      *         Flag to run defined inFilter on passed value
205:      *
206:      * @return bool
207:      */
208:     public function setField($name, $value, $safe = true) {
209:         switch ($name) {
210:             case 'name':
211:                 $this->setField('urlname', conHtmlSpecialChars($value, ENT_QUOTES), $safe);
212:                 break;
213:             case 'urlname':
214:                 $value = conHtmlSpecialChars(cString::cleanURLCharacters($value), ENT_QUOTES);
215:                 break;
216:             case 'visible':
217:             case 'public':
218:                 $value = ($value == 1) ? 1 : 0;
219:                 break;
220:             case 'idcat':
221:             case 'idlang':
222:             case 'idtplcfg':
223:             case 'status':
224:                 $value = (int) $value;
225:                 break;
226:         }
227: 
228:         return parent::setField($name, $value, $safe);
229:     }
230: 
231:     /**
232:      * Assigns the passed template to the category language item.
233:      *
234:      * @param int $idtpl
235:      * @return cApiTemplateConfiguration
236:      */
237:     public function assignTemplate($idtpl) {
238:         $oTplConfColl = new cApiTemplateConfigurationCollection();
239: 
240:         if ($this->get('idtplcfg') != 0) {
241:             // Remove old template first
242:             $oTplConfColl->delete($this->get('idtplcfg'));
243:         }
244: 
245:         $oTplConf = $oTplConfColl->create($idtpl);
246: 
247:         // If there is a preconfiguration of template, copy its settings into
248:         // templateconfiguration
249:         $oTplConfColl->copyTemplatePreconfiguration($idtpl, $oTplConf->get('idtplcfg'));
250: 
251:         $this->set('idtplcfg', $oTplConf->get('idtplcfg'));
252:         $this->store();
253: 
254:         return $oTplConf;
255:     }
256: 
257:     /**
258:      * Returns id of template where this item is configured
259:      *
260:      * @return int
261:      */
262:     public function getTemplate() {
263:         $oTplConf = new cApiTemplateConfiguration($this->get('idtplcfg'));
264:         return $oTplConf->get('idtpl');
265:     }
266: 
267:     /**
268:      * Checks if category language item has a start article
269:      *
270:      * @return bool
271:      */
272:     public function hasStartArticle() {
273:         cInclude('includes', 'functions.str.php');
274:         return strHasStartArticle($this->get('idcat'), $this->get('idlang'));
275:     }
276: 
277:     /**
278:      * Updates lastmodified field and calls parents store method
279:      *
280:      * @return bool
281:      */
282:     public function store() {
283:         $this->set('lastmodified', date('Y-m-d H:i:s'));
284:         return parent::store();
285:     }
286: 
287:     /**
288:      * Returns the link to the current object.
289:      *
290:      * @param int $changeLangId [optional]
291:      *         change language id for URL (optional)
292:      * @return string
293:      *         link
294:      */
295:     public function getLink($changeLangId = 0) {
296:         if ($this->isLoaded() === false) {
297:             return '';
298:         }
299: 
300:         $options = array();
301:         $options['idcat'] = $this->get('idcat');
302:         $options['lang'] = ($changeLangId == 0) ? $this->get('idlang') : $changeLangId;
303:         if ($changeLangId > 0) {
304:             $options['changelang'] = $changeLangId;
305:         }
306: 
307:         return cUri::getInstance()->build($options);
308:     }
309: }
310: