function layDanhSachBatDongSan($language)
{
$language = 'vi';
//gan tam
$language2 = 'en';
$DBConfig = ilandCommonUtils::getSiteDBConfig();
$result = array();
$context = 'com_jea.projects';
$mainframe =& JFactory::getApplication();
$table = $mainframe->getUserStateFromRequest($context . 'table', 'table', 0, 'string');
$townId = $mainframe->getUserStateFromRequest($context . 'tinh_thanh', 'tinh_thanh', 0, 'string');
$tien_ichID = $mainframe->getUserStateFromRequest($context . 'loai_tien_ich', 'loai_tien_ich', 0, 'string');
$ten_tien_ich = $mainframe->getUserStateFromRequest($context . 'ten_tien_ich', 'ten_tien_ich', 0, 'string');
// $_SESSION['ten_tien_ich_config'] = '';
if ($ten_tien_ich != NULL) {
$_SESSION['ten_tien_ich_config'] = $ten_tien_ich;
}
if (!$table) {
$table = 'loai_bds';
}
$result['name'] = $table;
$result['townId'] = $townId;
$result['tien_ichID'] = $tien_ichID;
@($result['ten_tien_ich'] = $_SESSION['ten_tien_ich_config']);
// print_r( "tttt---".$result['ten_tien_ich'] );
if (!$townId) {
$townId = 1;
}
if (!$tien_ichID) {
$tien_ichID = 1;
}
// $townId =1;
// print_r($townId);
// exit;
// print_r($table);
// exit;
// echo "<script> alert($table)</script>";
switch ($table) {
case 'phap_ly':
$result['value'] = iland4_layDanhSachPhapLy($DBConfig, $language);
$result['value2'] = iland4_layDanhSachPhapLy($DBConfig, $language2);
break;
case 'don_vi_tien':
$result['value'] = iland4_layDanhSachDonViTien($DBConfig);
$result['value2'] = iland4_layDanhSachDonViTien($DBConfig);
break;
case 'don_vi_dien_tich':
$result['value'] = iland4_layDanhSachDonViDienTich($DBConfig, $language);
$result['value2'] = iland4_layDanhSachDonViDienTich($DBConfig, $language2);
break;
case 'loai_tien_ich':
$result['value'] = iland4_layDanhSachLoaiTienIch($DBConfig, $language);
$result['value2'] = iland4_layDanhSachLoaiTienIch($DBConfig, $language2);
break;
case 'tien_ich':
$result['value'] = iland4_layDanhSachTienIchTheoLoai($DBConfig, $tien_ichID, $language);
$result['value2'] = iland4_layDanhSachTienIchTheoLoai($DBConfig, $tien_ichID, $language2);
break;
case 'tinh_thanh':
$result['value'] = iland4_layDanhSachTinhThanhPho($DBConfig);
$result['value2'] = iland4_layDanhSachTinhThanhPho($DBConfig);
break;
case 'quan_huyen':
$result['value'] = iland4_layDanhSachQuanHuyen($DBConfig, $townId);
$result['value2'] = iland4_layDanhSachQuanHuyen($DBConfig, $townId);
break;
case 'loai_bds':
$result['value'] = iland4_layDanhSachLoaiBDS($DBConfig, $language);
$result['value2'] = iland4_layDanhSachLoaiBDS($DBConfig, $language2);
// print_r($result['value2']);
// exit;
break;
case 'loai_du_an':
$result['value'] = iland4_layDanhSachLoaiDuAn($DBConfig, $language);
$result['value2'] = iland4_layDanhSachLoaiDuAn($DBConfig, $language2);
break;
// default: $result['value'] = iland4_layDanhSachLoaiBDS( $DBConfig, $language );
}
// print_r($result['value']);
// exit;
return $result;
}
function getSelectBox($table, $name, $title, $checked, $onchange = NULL, $townId = NULL, $style = NULL, $class = NULL, $language = NULL)
{
/*
echo "<pre>";
print_r( $name.'----'.$class );
echo "</pre>";
*/
if ($language == NULL) {
$language = ilandCommonUtils::getLanguage();
}
// TODO: remove hardcode language
// $language = 'en';
// print_r($language);
$propertyModel = new U_reModelProperties();
$projectModel = new U_ReModelProjects();
switch ($table) {
case 'loai_giao_dich':
$rows = $propertyModel->layDanhSachLoaiGiaoDich($language);
//print_r($rows);
//exit;
break;
case 'phap_ly':
$rows = $propertyModel->layDanhSachPhapLy($language);
break;
case 'vi_tri':
$rows = $propertyModel->layDanhSachTienIch('1', $language);
// print_r($rows);
// exit;
break;
case 'huong':
$rows = $propertyModel->layDanhSachHuong($language);
break;
case 'don_vi_dien_tich':
$temp = 1;
if ($checked == 3 || $checked == 4) {
$temp = 2;
}
$rows = $propertyModel->layDanhSachDonViDienTich($language, $temp);
break;
case 'loai_bds':
$rows = $propertyModel->layDanhSachLoaiBatDongSan($language);
break;
case 'tinh_thanh':
$rows = $propertyModel->layDanhSachTinhThanh($language);
break;
case 'quan_huyen':
$rows = $propertyModel->layDanhSachQuanHuyen($townId, $language);
break;
case 'loai_tien_ich':
$DBConfig = ilandCommonUtils::getSiteDBConfig();
$rows = iland4_layDanhSachLoaiTienIch($DBConfig, $language);
break;
case 'loai_du_an':
// $rows = $propertyModel->layDanhSachLoaiBatDongSan($language);
$rows = $projectModel->laynhomduan($language);
break;
case 'nha_moi_gioi':
// $rows = $propertyModel->layDanhSachLoaiBatDongSan($language);
$realtorData = $projectModel->laynhamoigioi($language);
$rows = $realtorData[3];
// print_r($rows);
// exit;
break;
case 'phuong_xa':
// get quan huyen id
$rows = $propertyModel->layDanhSachPhuongXa($townId);
break;
case 'duong_pho':
$rows = $propertyModel->layDanhSachDuongPho($townId);
break;
case 'nhom_du_an':
// $rows = $projectModel->laynhomduan($language);
// break;
$nhomduan = $projectModel->laydanhsachduan();
$rows = $nhomduan[3];
break;
case 'du_an':
$rows = $projectModel->laydanhsachduan($townId);
break;
}
/*
case 'jea_type' : $rows = getTypeList($language);
break;
case 'jea_town' : $rows = getTownList(U_ReUtils::getSiteConfig(), $language);
break;
case 'jea_area' : $rows = getAreaList(U_ReUtils::getSiteConfig(), $Town_id, $language);
break;
case 'jea_project_type' : $rows = getProjectTypeList(U_ReUtils::getSiteConfig(), $language);
break;
*/
if (empty($class)) {
$class = "class='inputbox'";
}
$html = '';
$html .= "<select name='" . $name . "' id='" . $name . "' onchange='" . $onchange . "' " . $class . $style . ">";
if (!empty($title)) {
$html .= "<option value='0'>{$title}</option>";
}
if (!empty($rows)) {
foreach ($rows as $row) {
$selected = '';
$selected = $row["id"] == $checked ? 'selected = selected' : '';
$html .= "<option value={$row['id']} {$selected} >{$row['ten']}</option>";
}
}
$html .= "</select>";
return $html;
}
function layDanhSachLoaiTienIch($language = 'vi')
{
$DBConfig = ilandCommonUtils::getSiteDBConfig();
return iland4_layDanhSachLoaiTienIch($DBConfig, $language);
}
