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);
}
