function editClassified($option) { $query = "SELECT * FROM #__aard_config WHERE id ='1'"; $db =& JFactory::getDBO(); $db->setQuery($query); $rows = $db->loadObjectList(); if ($db->getErrorNum()) { echo $db->stderr(); return false; } foreach ($rows as $row) { $currency = $row->currency; } $row =& JTable::getInstance('classified', 'Table'); $cid = JRequest::getVar('cid', array(0), '', 'array'); $id = $cid[0]; $row->load($id); $lists = array(); $ad_delivery = array('0' => array('value' => 'Pickup Only', 'text' => 'Pickup Only'), '1' => array('value' => 'Delivery Only', 'text' => 'Delivery Only'), '2' => array('value' => 'Pickup or delivery', 'text' => 'Pickup or delivery')); $lists['ad_delivery'] = JHTML::_('select.genericList', $ad_delivery, 'ad_delivery', 'class="inputbox"' . '', 'value', 'text', $row->ad_delivery); $ad_state = array('0' => array('value' => 'For Sale', 'text' => 'For Sale'), '1' => array('value' => 'Wanted', 'text' => 'Wanted')); $query = "SELECT id, cat_name FROM #__aard_cats"; $objD =& JFactory::getDBO(); $objD->setQuery($query); $aryReturnedCategories = $objD->loadObjectList(); foreach ($aryReturnedCategories as $objCat) { $arySelectOptions[] = JHTML::_('select.option', $objCat->id, $objCat->cat_name); } $lists['cat_name'] = JHTML::_('select.genericlist', $arySelectOptions, 'cat_id', 'class="inputbox"', 'value', 'text', 0); $lists['ad_state'] = JHTML::_('select.genericList', $ad_state, 'ad_state', 'class="inputbox"' . '', 'value', 'text', $row->ad_state); $lists['published'] = JHTML::_('select.booleanlist', 'published', 'class="inputbox"', $row->published); // agregado por G2P $expiration_date = !$row->date_expiration ? date('Y-m-d') : $row->date_expiration; $addTagsUrl = JRoute::_('index.php?option=com_customproperties&controller=hierarchictagging&view=hierarchictagging&ce_name=ad&id=' . $row->id); $selectTags = 'select v.name as value from #__custom_properties cp, #__custom_properties_values v, #__aard_ads a where cp.value_id=v.id and cp.ref_table="ad" and cp.content_id=a.id and a.id=' . $row->id; $db = JFactory::getDBO(); $db->setQuery($selectTags); $dbTags = $db->loadObjectList(); $aux = array(); foreach ($dbTags as $tag) { $aux[] = $tag->value; } $tags = implode(', ', $aux); $data = array('tags' => $tags, 'addtagsurl' => $addTagsUrl, 'expirationdate' => $expiration_date); // fin HTML_classifieds::editClassified($row, $lists, $option, $currency, $data); }