function editItem()
{
global $u_reGlobalConfig;
$cid = JRequest::getVar('cid', array(0), '', 'array');
if ($idurl = JFactory::getURI()->getVar("id")) {
$id = $idurl;
} else {
$id = $cid[0];
}
$tinhThanhId = $u_reGlobalConfig['COMMON']['tinh_thanh_mac_dinh'];
$quanHuyenId = $u_reGlobalConfig['COMMON']['quan_huyen_mac_dinh'];
$templatePath = "../templates/" . $u_reGlobalConfig['DB']['template'] . "/html/com_u_re/projects/";
$this->assignRef('lang', ilandCommonUtils::getLanguage());
$this->status = 2;
$projectModel = new U_ReModelProjects();
$projectData = $projectModel->getProjectById($id, $this->lang);
$tinhThanhId = $projectData['tinh_thanh_id'];
$quanHuyenId = $projectData['quan_huyen_id'];
$projectDataEn = $projectModel->getProjectById($id, 'en');
$this->assignRef('row', $projectData);
$this->assignRef('rowEn', $projectDataEn);
$this->assignRef('town_id', $projectData['tinh_thanh_id']);
$towns = ilandCommonUtils::getSelectBox('tinh_thanh', 'town_id', '', $tinhThanhId, 'layseachquanhuyenadmin("area_id",this.value,"vi-VN","' . JURI::root() . '","area_id") ', '', "style='width:264px!important'", "class='inputbox2'");
$this->assignRef('towns', $towns);
$this->assignRef('area_id', $projectData['quan_huyen_id']);
$areas = ilandCommonUtils::getSelectBox('quan_huyen', 'area_id', '', $quanHuyenId, '', $tinhThanhId, "style='width:264px!important'", "class='inputbox2'");
$this->assignRef('areas', $areas);
// $type_selected = $this->row['loai_du_an_id'] ;
//$type_id = ilandCommonUtils::getSelectBox( 'loai_du_an', 'type_id','', $type_selected,'','','','',$this->lang);
//$this->assignRef( 'type', $type_id );
// hien thi cho chinh
$mainImage = ilandCommonUtils::getProjectMainImage($id);
// hien thi cho trinh dien anh
$subImages = ilandCommonUtils::getProjectSubImages($id);
// get image block
$imageData = array();
$imageData['status'] = 2;
$imageTemplateName = 'image_block';
$imageData['mainImage'] = $mainImage;
$imageData['subImages'] = $subImages;
$imageData['title'] = '';
$imageData['id'] = $id;
$imageBlockHTML = ilandCommonUtils::fetchImageBlockTemplate($templatePath, $imageTemplateName, $imageData);
$this->assignRef('imageBlockHTML', $imageBlockHTML);
// lay cac hinh anh dac biet: so do mat bang, noi that, ngoai that
// so do mat bang
$soDoMatBangImageData = array();
$soDoMatBangImageData['id'] = 0;
$soDoMatBangImageData['status'] = 2;
$soDoMatBangImageData['images'] = '';
$soDoMatBangImageData['folder'] = 'sodomatbang';
$soDoMatBangImageData['spec_name'] = 'so_do_mat_bang_img';
// noi that
$noiThatImageData = array();
$noiThatImageData['id'] = 0;
$noiThatImageData['status'] = 2;
$noiThatImageData['images'] = '';
$noiThatImageData['folder'] = 'noithat';
$noiThatImageData['spec_name'] = 'noi_that_img';
// ngoai that
$ngoaiThatImageData = array();
$ngoaiThatImageData['id'] = 0;
$ngoaiThatImageData['status'] = 2;
$ngoaiThatImageData['images'] = '';
$ngoaiThatImageData['folder'] = 'ngoaithat';
$ngoaiThatImageData['spec_name'] = 'ngoai_that_img';
if ($id) {
// so do mat bang
$soDoMatBangImageData['id'] = $id;
$soDoMatBangImageData['images'] = ilandCommonUtils::layHinhAnhSoDoMatBang($id, 'project');
// noi that
$noiThatImageData['id'] = $id;
$noiThatImageData['images'] = ilandCommonUtils::layHinhAnhNoiThat($id, 'project');
// ngoai that
$ngoaiThatImageData['id'] = $id;
$ngoaiThatImageData['images'] = ilandCommonUtils::layHinhAnhNgoaiThat($id, 'project');
}
// fetch hinh anh so do mat bang, noi that, ngoai that
$soDoMatBangImageHTML = ilandCommonUtils::fetchImageBlockTemplate($templatePath, 'spec_image_block', $soDoMatBangImageData);
$this->assignRef('soDoMatBangImageHTML', $soDoMatBangImageHTML);
$noiThatImageHTML = ilandCommonUtils::fetchImageBlockTemplate($templatePath, 'spec_image_block', $noiThatImageData);
$this->assignRef('noiThatImageHTML', $noiThatImageHTML);
$ngoaiThatImageHTML = ilandCommonUtils::fetchImageBlockTemplate($templatePath, 'spec_image_block', $ngoaiThatImageData);
$this->assignRef('ngoaiThatImageHTML', $ngoaiThatImageHTML);
// lay thong tin dat cho
$this->row['status'] = 2;
JRequest::setVar('hidemainmenu', 1);
$title = "";
$title .= ' : ';
$title .= $this->row['ten'] ? JText::_('Edit') . ' ' . $this->row['ten'] : JText::_('New');
JToolBarHelper::title($title, 'jea.png');
$app =& JFactory::getApplication();
$this->addTemplatePath($templatePath);
$this->setLayout('detail');
parent::display();
}
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);
}
}
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 thongTinDatCho()
{
// lay du lieu
global $u_reGlobalConfig;
$data = array();
$id = JRequest::getVar('id', '0');
$id = intval($id);
$project = U_ReModelProjects::getProjectById($id, 'vi');
if (!empty($project) && $project['hien_thi_ra_ngoai'] == 1) {
$data['code'] = '1';
$data['du_an_id'] = $project['id'];
$data['ten_du_an'] = $project['ten'];
$user =& JFactory::getUser();
if ($user->id != 0) {
$data['ho_ten'] = $user->name;
$data['dia_chi'] = $user->address;
$data['so_dien_thoai'] = $user->phone;
$data['email'] = $user->email;
} else {
$data['ho_ten'] = '';
$data['dia_chi'] = '';
$data['so_dien_thoai'] = '';
$data['email'] = '';
}
} else {
$data['code'] = '500';
}
$this->assignRef('data', $data);
// chon template
$currentTemplate = JFactory::getApplication()->getTemplate();
$templatePath = JPATH_THEMES . DS . $currentTemplate . DS . "html" . DS . "com_u_re" . DS . "projects";
$this->addTemplatePath($templatePath);
$this->setLayout($u_reGlobalConfig['PROJECT']['dat_cho_template']);
parent::display();
}
function getProjectById($id, $language)
{
if ($id == 0) {
return U_ReModelProjects::laygiatrirong();
}
$db = JFactory::getDBO();
$sql = "select * from iland4_du_an_vi where id = {$id}";
$db->setQuery($sql);
$db->query();
return $db->loadAssoc();
//$DBConfig = ilandCommonUtils::getSiteDBConfig();
//return iland4_layChiTietDuAn($DBConfig, $id, $language );
}
function dangKyMail($email)
{
$this->assignRef('lang', ilandCommonUtils::getLanguage());
$this->assignRef('SiteDBConfig', ilandCommonUtils::getSiteDBConfig());
// global config
global $u_reGlobalConfig;
// get data from post
$data = array();
$data['du_an_id'] = '-1';
$data['ten_du_an'] = '';
$data['ho_ten'] = '';
$data['dia_chi'] = '';
$data['dien_thoai'] = '';
$data['email'] = $email;
$data['yeu_cau'] = 'Nhận tin mới qua mail';
$data['ngay_gui'] = '' . time();
$data['dat_cho'] = '0';
$data['giao_dich_thanh_cong'] = '0';
// luu data
$projectModel = new U_ReModelProjects();
$result = $projectModel->luuThongTinDatChoDuAn($data);
// chuyen sang trang thong bao luu thanh cong
$templatePath = "templates/" . $u_reGlobalConfig['DB']['template'] . "/html/com_u_re/projects/";
$this->addTemplatePath($templatePath);
// hardcode template name
$this->setLayout('dang_ky_mail_thanh_cong');
$linkData = array();
$linkData['linkTrangChu'] = 'index.php';
$linkData['linkListDuAn'] = 'index.php?option=com_u_re&controller=projects&Itemid=24';
// assign
$this->assignRef('linkData', $linkData);
// display template
parent::display();
}
