public function display($tpl = null) { $document = JFactory::getDocument(); $document->addScript('components/com_gglms/js/jquery.dataTables.min.js'); $document->addScript('components/com_gglms/js/utils.js'); $document->addScript('components/com_gglms/js/levelslist.js'); $document->addStyleSheet('components/com_gglms/css/jquery.dataTables.css'); $document->addStyleSheet('components/com_gglms/css/levelslist.css'); $document->addStyleSheet('components/com_gglms/css/tv_categorie.css'); $model = & $this->getModel('webtv'); if (empty($model)) { JLoader::import('joomla.application.component.model'); JLoader::import('webtv', JPATH_BASE . DS . 'components' . DS . 'com_gglms' . DS . 'models'); $model = & JModel::getInstance('webtv', 'webtvModel'); $model->setState('id', $myItemId); } $levels = $model->getLevelsWithContents(); debug::vardump($levels); $start_level = JRequest::getVar('level', 1); debug::vardump($start_level); if (!in_array($start_level, $levels)) $start_level = $levels[0]; $levels_map = array(1 => 'A1', 2 => 'A2', 3 => 'B1', 4 => 'B2', 5 => 'C1', 6 => 'C2'); $tot = $model->totContentsByLevel($start_level); $this->assignRef('levels', $levels); $this->assignRef('start_level', $start_level); $this->assignRef('levels_map', $levels_map); $this->assign('levels_map_json', json_encode($levels_map)); $this->assignRef('tot', $tot); $this->assign('num_per_page', 5); $this->assign('view_level', $levels_map[$start_level]); parent::display($tpl); }
public function get_congresso($id) { try { debug::vardump($id, 'id'); $id = filter_var($id, FILTER_VALIDATE_INT, array('options' => array('min_range' => 1))); if (empty($id)) throw new BadMethodCallException('Identificativo congresso non specificato o non valido', E_USER_ERROR); $query = 'SELECT c.congresso, c.banner, c.abstract AS abstract_congresso, c.alias AS alias_congresso, i.* FROM #__gg_congressi AS c LEFT JOIN #__gg_contenuti AS i ON i.id_congresso = c.id WHERE c.pubblicato = 1 AND c.id = ' . $id; $this->_db->setQuery($query); debug::msg($query); return $this->_db->loadAssocList(); } catch (Exception $e) { debug::exception($e); } }
protected function getOptions() { $db = JFactory::getDBO(); $query = $db->getQuery(true); $query->select('a.id as id, a.datapalinsesto as datapalinsesto'); $query->from('#__gg_palinsesti a'); $db->setQuery((string) $query); $messages = $db->loadObjectList(); $options = array(); if ($messages) { foreach ($messages as $message) { $options[] = JHtml::_('select.option', $message->id, $message->datapalinsesto); } } $options = array_merge(parent::getOptions(), $options); debug::checkpoint("getOption"); debug::vardump($options); return $options; // $db = JFactory::getDBO(); // $query = $db->getQuery(true); // $query->select('c.id, // c.datapalinsesto, // b.categoria as categoria, // b.id as catid' // ); // $query->from('#__gg_palinsesti a'); // $query->leftJoin('#__gg_contenuti b on a.id_contenuto=b.id'); // $db->setQuery((string) $query); // $messages = $db->loadObjectList(); // $options = array(); // if ($messages) { // foreach ($messages as $message) { // $options[] = JHtml::_('select.option', $message->id, $message->titolo . ($message->catid ? ' (' . $message->categoria . ')' : '')); // } // } // $options = array_merge(parent::getOptions(), $options); // // return $options; }
*/ defined('_JEXEC') or die('Restricted access'); $document = JFactory::getDocument(); $document->addScript(JURI::root(true) . '/components/com_gglms/flash/swfobject.js'); $document->addStyleDeclaration("#flash { width: 890px; height: 700px; margin: 0 auto; display: block; }"); debug::vardump($this->elemento); $config = & JFactory::getConfig(); if (false === strpos($this->elemento['path'], 'http')) $path = $config->getValue('config.live_site') . $this->elemento['path'] . "/"; else $path = $this->elemento['path'] . "/"; $lingua = "IT"; // è ancora ininfluente dentro il flash debug::vardump($path, 'path'); ?> <script type="text/javascript"> function fnc_alert(param) { console.log(param); } </script> <div id="percorso_elemento"> Torna a <a class="percorso_modulo" href="index.php?option=com_gglms&view=corso&id=<?php echo $this->elemento['idcorso']; ?>&idm=<?php echo $this->elemento['idmodulo']; ?>"> <?php echo $this->elemento['titoloattestato']; ?></a> - <span class="titolo_elemento"> <?php echo $this->elemento['elemento']; ?></span> </div>
/** * Ritorna un array di righe. * * @param string $where * @param string $orderby * @return array Array di risultati */ public function getUnita($where = 'pubblicato=1', $orderby = 'datapubblicazione DESC') { $db = JFactory::getDBO(); $query = $db->getQuery(true); $query->select('*'); $query->from('#__gg_unita as u '); $query->where('pubblicata = 1 '); $query->order('ordinamento'); $db->setQuery((string) $query); $res = $db->loadObjectList(); debug::vardump($res); return $res; }