function getItemDetail($id) { //$sql =& $this->get('project'); //echo "id:$id<br>"; //echo "sql:$sql<br>"; $row =& $this->get('project'); if (!$row->id) { return; } $this->assignRef('row', $row); $res = ComJea::getImagesById($row->id, true); $this->assignRef('main_image', $res['main_image']); $this->assignRef('secondaries_images', $res['secondaries_images']); // Add list of other projects and the same investor projects $listOtherProjects = $this->getListOtherProjects($row->project_group_ids, $row->id); $listSameInvestorProject = $this->getListSameInvestorProjects($row->investor, $id); $loaihinh = $this->getProject_Group(); $this->assignRef('listOther', $listOtherProjects); $this->assignRef('listSameInvestor', $listSameInvestorProject); $this->assignRef('loaihinh', $loaihinh); $document =& JFactory::getDocument(); if ($this->escape($row->page_title) == NULL) { $page_title = ucfirst(JText::sprintf($this->escape($row->value) . ', ' . $this->escape($row->town))); } else { $page_title = ucfirst($this->escape($row->page_title)); } if ($this->escape($row->page_keywords) != NULL) { $page_keywords = ucfirst($this->escape($row->page_keywords)); $document->setMetaData('keywords', $page_keywords); } if ($this->escape($row->page_description) != NULL) { $page_description = ucfirst($this->escape($row->page_description)); $document->setMetaData('description', $page_description); } $this->assign('page_title', $page_title); $mainframe =& JFactory::getApplication(); $pathway =& $mainframe->getPathway(); $pathway->addItem($page_title); $document->setTitle($page_title); }
function getCompare() { $idCompare = JRequest::getVar('sosanh', array(), '', 'array'); $model =& $this->getModel(); $i = 0; $rows = array(); /*foreach($idCompare as $id) { $rows[$i] = $model->getPropertyCompare($id); $res = ComJea::getImagesById($id); $this->assignRef("main_image_$i", $res['main_image']); $this->assignRef("secondaries_images_$i", $res['secondaries_images']); $i++; }*/ // lay 2 bien session de so sanh $session =& JFactory::getSession(); //echo "Session: ".$session->get('valueCompare_1'); $rows[0] = $model->getPropertyCompare($session->get('valueCompare_1')); $res = ComJea::getImagesById($session->get('valueCompare_1')); $this->assignRef("main_image_0", $res['main_image']); $this->assignRef("secondaries_images_0", $res['secondaries_images']); $rows[1] = $model->getPropertyCompare($session->get('valueCompare_2')); $res = ComJea::getImagesById($session->get('valueCompare_2')); $this->assignRef("main_image_1", $res['main_image']); $this->assignRef("secondaries_images_1", $res['secondaries_images']); // $this->assignRef('row1', $rows[0]); $this->assignRef('row2', $rows[1]); parent::display('compare'); }
function getItem() { $result = array(); $row =& $this->getRow(); if ($row->id == 0) { $row->published = 0; $row->dispo = ''; } $imgs = ComJea::getImagesById($row->id, true); $rootURL = JURI::root(); $this->_cat = ''; if (!empty($imgs['main_image']) && is_array($imgs['main_image'])) { $imgs['main_image']['delete_url'] = $rootURL . 'administrator/index2.php?option=com_jea' . '&controller=' . JRequest::getVar('controller', '') . '&task=deleteimg&id=' . $row->id . '&cat=' . $this->_cat; } foreach ($imgs['secondaries_images'] as $k => $v) { $imgs['secondaries_images'][$k]['delete_url'] = $rootURL . 'administrator/index.php?option=com_jea' . '&controller=' . JRequest::getVar('controller', '') . '&task=deleteimg&id=' . $row->id . '&image=' . $v['name'] . '&cat=' . $this->_cat; } $result['row'] = $row; return $result + $imgs; }
function getItemDetail() { //try to increase memory ini_set('memory_limit', '32M'); $text = ''; $row =& $this->get('property'); if (!$row->id) { return $text; } $res = ComJea::getImagesById($row->id); $webpage_to_property = 'http://' . $_SERVER['SERVER_NAME'] . str_replace('&format=pdf', '', $_SERVER['REQUEST_URI']); $page_title = ucfirst(JText::sprintf('PROPERTY TYPE IN TOWN', $this->escape($row->type), $this->escape($row->town))); $document =& JFactory::getDocument(); $document->setTitle($page_title . ' ' . JText::_('ref') . ' : ' . $row->ref); $document->setName($row->ref); if (is_file(JPATH_ROOT . DS . 'images' . DS . 'com_jea' . DS . 'images' . DS . $row->id . DS . 'preview.jpg')) { $text .= '<p><img src="' . $this->UrlAbsoluteToRelative($res['main_image']['preview_url']) . '" alt="" /></p>'; } $text .= $row->description . '<br /><br />'; $text .= $row->is_renting ? JText::_('Renting price') : JText::_('Selling price'); $text .= ' : ' . $this->formatPrice(floatval($row->price), JText::_('Consult us')) . '<br />'; if ($row->charges) { $text .= JText::_('Charges') . ' : ' . $this->formatPrice(floatval($row->charges), JText::_('Consult us')) . '<br />'; } if ($row->fees) { $text .= JText::_('Fees') . ' : ' . $this->formatPrice(floatval($row->fees), JText::_('Consult us')) . '<br />'; } if ($row->condition) { $text .= JText::_('Condition') . ' : ' . ucfirst($this->escape($row->condition)) . '<br />'; } if ($row->living_space) { $text .= JText::_('Living space') . ' : ' . $row->living_space . ' ' . $this->params->get('surface_measure') . '<br />'; } if ($row->land_space) { $text .= JText::_('Land space') . ' : ' . $row->land_space . ' ' . $this->params->get('surface_measure') . '<br />'; } if ($row->rooms) { $text .= JText::_('Number of rooms') . ' : ' . $row->rooms . '<br />'; } if ($row->floor) { $text .= JText::_('Number of floors') . ' : ' . $row->floor . '<br />'; } if ($row->bathrooms) { $text .= JText::_('Number of bathrooms') . ' : ' . $row->bathrooms . '<br />'; } if ($row->toilets) { $text .= JText::_('Number of toilets') . ' : ' . $row->toilets . '<br />'; } if ($row->hot_water_type) { $text .= JText::_('Hot water type') . ' : ' . ucfirst($this->escape($row->hot_water)) . '<br />'; } if ($row->heating_type) { $text .= JText::_('Heating type') . ' : ' . ucfirst($this->escape($row->heating)) . '<br />'; } if (intval($row->availability)) { $text .= '<p><em>' . JText::_('Availability date') . ' : ' . $row->availability . '</em> </p>'; } $text .= '<br /><br />'; if ($row->advantages) { $text .= '<h3>' . JText::_('Advantages') . ' :</h3>'; $text .= $this->getAdvantages($row->advantages); } $text .= '<h3>' . JText::_('Adress') . ' :</h3><br />'; if ($row->adress) { $text .= trim($row->adress) . ",<br />\n"; } if ($row->zip_code) { $text .= trim($row->zip_code) . ' '; } if ($row->town) { $text .= strtoupper($this->escape($row->town)) . "<br />\n"; } if ($row->area) { $text .= JText::_('Area') . ' : ' . $this->escape($row->area) . "\n"; } $text .= '<br /><br />' . $webpage_to_property; return $text; }
function getListingByRealtorId($id) { // get basic info $sql = "SELECT p.id, p.ref, p.price, p.price_unit AS `price_unit`, p.address, \n \t\t\t\t\t\tp.price_area_unit AS `price_area_unit`, p.living_space, \n \t\t\t\t\t\ta.value AS `area`, t.value AS `town`, p.kind_id AS `kind_id` " . " FROM #__jea_properties p" . PHP_EOL . "LEFT JOIN #__jea_areas AS a ON a.id = p.area_id" . PHP_EOL . "LEFT JOIN #__jea_towns AS t ON t.id = p.town_id" . PHP_EOL . "LEFT JOIN #__jea_price_units AS pu ON pu.id = p.price_unit" . PHP_EOL . "LEFT JOIN #__jea_price_area_units AS pau ON pau.id = p.price_area_unit" . PHP_EOL . "WHERE p.realtor_id = " . $id . PHP_EOL . "AND p.published = 1 " . PHP_EOL . "ORDER BY p.ordering"; $this->_db->setQuery($sql); $rows = $this->_db->loadObjectList(); foreach ($rows as $row) { // TODO: refractor --- get Itemid $Itemid = 1; if ($row->kind_id == 1) { $row->itemid = '10'; } else { if ($row->kind_id == 2) { $row->itemid = '11'; } else { if ($row->kind_id == 3) { $row->itemid = '12'; } else { if ($row->kind_id == 4) { $row->itemid = '13'; } } } } // make link $row->link = "index.php?option=com_jea&view=properties&id=" . $row->id . "&Itemid=" . $row->itemid; // get images $images_info = ComJea::getImagesById($row->id); if (!empty($images_info['main_image']['min_url'])) { $row->image = $images_info['main_image']['min_url']; } else { $row->image = "images/noimage.jpg"; } $priceStr = reFormatPrice($row->price) . $row->price_unit . '/' . $row->price_area_unit; $row->full_price = $priceStr; // format price } return $rows; }