Esempio n. 1
0
 protected function getInput()
 {
     require_once JPATH_SITE . '/components/com_javoice/models/items.php';
     require_once JPATH_SITE . '/components/com_javoice/models/forums.php';
     $jaVoiceModelItems = new JAVoiceModelItems();
     $model_forums = new JAVoiceModelforums();
     $class = (string) $this->element['class'];
     $multiple = $this->element['multiple'] ? 'multiple="multiple"' : '';
     $types = $jaVoiceModelItems->getVoiceTypes(" AND vt.published = 1", "vt.ordering");
     $forums = array();
     $forums[0] = new stdClass();
     $forums[0]->id = '1';
     $forums[0]->title = JText::_("Select All");
     foreach ($types as $type) {
         array_push($forums, JHTML::_('select.optgroup', $type->title, 'id', 'title'));
         $where_more = ' and f.published=1 and ft.voice_types_id=' . $type->id;
         $join = 'INNER JOIN #__jav_forums_has_voice_types as ft ON f.id=ft.forums_id';
         $results = $model_forums->getItems($where_more, 100, 0, 'f.ordering', '', $join);
         //array_push($forums, $optgroup);
         foreach ($results as $result) {
             $result->id = $type->id . '_' . $result->id;
             array_push($forums, $result);
         }
         array_push($forums, JHTML::_('select.optgroup', $type->title, 'id', 'title'));
     }
     //jexit();
     $out = JHTML::_('select.genericlist', $forums, $this->name, 'class="inputbox ' . $class . '" ' . $multiple, 'id', 'title', $this->value);
     return $out;
 }
Esempio n. 2
0
 function getList(&$params)
 {
     $mainframe = JFactory::getApplication();
     $db = JFactory::getDBO();
     $user = JFactory::getUser();
     $limit = intval($params->get('numberitems', 5));
     $displaymode = intval($params->get('displaymode', 0));
     $where_more = '';
     $order = '';
     if (!$displaymode) {
         $order = 'i.create_date desc';
     } else {
         $order = 'i.total_vote_up desc';
     }
     /*$forums_id = 0;
     		if($params->get ( 'forums', 0 )){
     			$forums_id = $params->get ( 'forums', 0 );
     			if(isset($forums_id) && is_array($forums_id))
     				$forums_id = implode(',', $forums_id);
     		}
     		if($forums_id)*/
     $forums_id = $params->get('forums', '');
     $str_forums_id = array();
     if ($forums_id && is_array($forums_id)) {
         foreach ($forums_id as $fid) {
             if ($fid == 1) {
                 $str_forums_id = array();
                 break;
             }
             $fid = explode('_', $fid);
             $str_forums_id[$fid[0]][] = $fid[1];
         }
     }
     if ($str_forums_id) {
         foreach ($str_forums_id as $k => $row) {
             if ($row) {
                 $forums = implode(',', $row);
                 $subwhere[] = " ( i.voice_types_id = '{$k}' and i.forums_id in (" . $forums . ") )";
             }
         }
         $where_more .= ' and ' . implode(' or ', $subwhere);
     }
     /* BEGIN: Show items are activing Only */
     $model_status = new javoiceModelvoicetypesstatus();
     $list_status = $model_status->getListTreeStatus($params->get('voicetypes', 5));
     $status_ids = array(0);
     if ($list_status) {
         foreach ($list_status as $k => $status) {
             if ($status->parent_id != 0 && ($status->allow_voting == 1 || $status->allow_voting == -1 && $list_status[$status->parent_id]->allow_voting == 1) || JRequest::getWord('layout') == 'item') {
                 $status_ids[] = $status->id;
             }
         }
     }
     $where_more .= " and ( i.voice_type_status_id in (" . implode(',', $status_ids) . "))";
     $where_more .= ' and i.published=1';
     $join = " LEFT JOIN #__jav_voice_type_status as s ON s.id=i.voice_type_status_id";
     $fields_join = ' s.title as status_title, s.class_css as status_class_css, s.allow_voting as status_allow_voting, s.parent_id as status_parent_id';
     $model = new JAVoiceModelItems();
     $items = $model->getItems($where_more, $order, 0, $limit, $fields_join, $join);
     return $items;
 }