function layDanhSachNhaMoiGioi($returnField, $page, $limit)
{
$result = array();
$context = 'com_jea.projects';
$mainframe =& JFactory::getApplication();
$published = $mainframe->getUserStateFromRequest($context . 'published', 'published', -1, 'int');
$language = ilandCommonUtils::getLanguage();
$offsetLimitArr = ilandCommonUtils::getOffsetLimit($page, $limit);
$DBConfig = ilandCommonUtils::getSiteDBConfig();
$conditionParams = ' 1 ';
//gan tam
if ($published != -1) {
$conditionParams .= ' AND hien_thi_ra_ngoai = ' . $published;
}
// print_r( $returnField );
// $result['rows'] = iland4_layDanhSachNhaMoiGioi($DBConfig, 'id, ten' , $conditionParams , $page, $limit, $language);
$result['rows'] = iland4_layDanhSachNhaMoiGioi($DBConfig, $returnField, $conditionParams, $page, $limit, $language);
// print_r( $published );
//exit;
$result['published'] = $published;
return $result;
}
function getListProjects($returnField, $page, $limit)
{
$result = array();
$context = 'com_jea.projects';
$mainframe =& JFactory::getApplication();
$type_id = $mainframe->getUserStateFromRequest($context . 'type_id', 'type_id', 0, 'int');
$town_id = $mainframe->getUserStateFromRequest($context . 'town_id', 'town_id', 0, 'int');
$area_id = $mainframe->getUserStateFromRequest($context . 'area_id', 'area_id', 0, 'int');
$search = $mainframe->getUserStateFromRequest($context . 'search', 'search', '', 'string');
$published = $mainframe->getUserStateFromRequest($context . 'published', 'published', -1, 'int');
$emphasis = $mainframe->getUserStateFromRequest($context . 'emphasis', 'emphasis', -1, 'int');
$language = ilandCommonUtils::getLanguage();
$offsetLimitArr = ilandCommonUtils::getOffsetLimit($page, $limit);
$DBConfig = ilandCommonUtils::getSiteDBConfig();
$conditionParams = '1';
//gan tam
if ($emphasis != -1) {
$conditionParams .= ' AND noi_bat = ' . $emphasis;
}
if ($published != -1) {
$conditionParams .= ' AND hien_thi_ra_ngoai = ' . $published;
}
if ($town_id != 0) {
$conditionParams .= ' AND tinh_thanh_id = ' . $town_id;
}
if ($area_id != 0 && $town_id != 0) {
$conditionParams .= ' AND quan_huyen_id = ' . $area_id;
}
if ($type_id != 0) {
$conditionParams .= ' AND loai_du_an_id = ' . $type_id;
}
if ($search != NULL) {
$conditionParams .= ' AND ten LIKE "' . $search . '"';
}
$result['search'] = $search;
$result['town_id'] = $town_id;
$result['area_id'] = $area_id;
$result['published'] = $published;
$result['emphasis'] = $emphasis;
$result['type_id'] = $type_id;
//$result['rows'] = iland4_layDanhSachDuAn($DBConfig, $returnField, $conditionParams , $offsetLimitArr, $limit, $language); //
$result['rows'] = iland4_layDanhSachDuAn($DBConfig, $returnField, $conditionParams, $page, $limit, $orderby, $language);
return $result;
}
