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