function lay_du_lieu($table) { $language = ''; if ($language == NULL) { $language = ilandCommonUtils::getLanguage(); } $propertyModel = new U_reModelProperties(); $projectModel = new U_ReModelProjects(); switch ($table) { case 'loai_giao_dich': return $propertyModel->layDanhSachLoaiGiaoDich($language); case 'huong': return $propertyModel->layDanhSachHuong($language); case 'loai_bds': return $propertyModel->layDanhSachLoaiBatDongSan($language); case 'tinh_thanh': return $propertyModel->layDanhSachTinhThanh($language); case 'quan_huyen': if (JRequest::getVar('tinh_thanh_id')) { $townId = JRequest::getVar('tinh_thanh_id'); } else { // $townId = U_ReConfig::getValueByKey( 'COMMON', 'tinh_thanh_mac_dinh' ); if (isset($_SESSION['tmp'])) { $townId = $_SESSION['tmp']['tinh_thanh_id']; } else { $townId = 0; } } return $propertyModel->layDanhSachQuanHuyen($townId, 'vi'); case 'phuong_xa': if (JRequest::getVar('quan_huyen_id')) { $quanHuyenId = JRequest::getVar('quan_huyen_id'); } else { $quanHuyenId = U_ReConfig::getValueByKey('COMMON', 'quan_huyen_mac_dinh'); } return $propertyModel->layDanhSachPhuongXa($quanHuyenId); case 'duong_pho': if (JRequest::getVar('quan_huyen_id')) { $quanHuyenId = JRequest::getVar('quan_huyen_id'); } else { $quanHuyenId = U_ReConfig::getValueByKey('COMMON', 'quan_huyen_mac_dinh'); } return $propertyModel->layDanhSachDuongPho($quanHuyenId); case 'nhom_du_an': return $nhomduan = $projectModel->laynhomduan($language); case 'tien_ich': return $propertyModel->layDanhSachTienIch($language); case 'du_an': $ix_quan_huyen_id = JRequest::getVar('quan_huyen_id', 0); $ix_tinh_thanh_id = JRequest::getVar('tinh_thanh_id', 0); return $projectModel->laydanhsachduan($ix_quan_huyen_id, $ix_tinh_thanh_id); } }
$extension = 'mod_jea_search'; $lang1->load($extension, $basePath, $lang, true); $ten = JText::_('CHON_PHUONG_XA'); break; default: $extension = 'com_u_re'; $lang1->load($extension, $basePath, $lang, true); $ten = JText::_('CHON_PHUONG_XA'); break; } } else { $lang1->load($extension, $basePath, $language, true); $ten = JText::_('CHON_PHUONG_XA'); } $quanHuyenId = $_GET['quan_huyen_id']; $propertyModel = new U_reModelProperties(); $rows = $propertyModel->layDanhSachPhuongXa($quanHuyenId, substr($language, 0, 2)); $ix_phuong_xa_id = JRequest::getVar('phuong_xa_id', 0); if ($rows) { if ($ten != '') { $title = array('id' => 0, 'ten' => $ten); array_unshift($rows, $title); } echo JHTML::_('select.genericlist', $rows, 'phuong_xa_id', 'class="opt" size="1" ', 'id', 'ten', $ix_phuong_xa_id); } else { echo "<select id='phuong_xa_id' name='phuong_xa_id' class='opt' >"; if ($ten != '') { echo "<option value='0'>" . $ten . "</option>"; } echo "</select>"; }
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; }