function LayDSDuAn($param)
{
$field = 'id,ten';
$condition = 'hien_thi_ra_ngoai=1';
$orderby = '';
if ($param->get('ma_so', '0') != '0') {
$orderby .= 'id ' . $param->get('ma_so', 'ASC');
}
if ($param->get('thu_tu', '0') != '0') {
if ($orderby != '') {
$orderby .= ',';
}
$orderby .= 'ordering ' . $param->get('thu_tu', 'ASC');
}
if ($param->get('noi_bat', '0') != '0') {
if ($orderby != '') {
$orderby .= ',';
}
$orderby .= 'noi_bat ' . $param->get('noi_bat', 'ASC');
}
if ($param->get('moi_nhat', '0') != '0') {
if ($orderby != '') {
$orderby .= ',';
}
$orderby .= 'moi_nhat ' . $param->get('moi_nhat', 'ASC');
}
$pagesize = $param->get('so_duan', '10');
$DBConfig = ilandCommonUtils::getSiteDBConfig();
$lang = ilandCommonUtils::getLanguage();
$dsduan = iland4_layDanhSachDuAn($DBConfig, $field, $condition, 1, $pagesize, $orderby, $lang);
return $dsduan;
}
function getProject(&$params)
{
$returnField = U_ReConfig::getValueByKey('SLIDESHOWIMAGE', 'slide_show_list_return_field');
$limit = U_ReConfig::getValueByKey('SLIDESHOWIMAGE', 'list_limit');
$orderby = U_ReConfig::getValueByKey('SLIDESHOWIMAGE', 'orderby');
$limitstart =& JRequest::getVar('limitstart', 0);
$page = ($limitstart + $limit) / $limit;
$language = ilandCommonUtils::getLanguage();
$DBConfig = ilandCommonUtils::getSiteDBConfig();
$conditionParams = ' hien_thi_ra_ngoai=1 AND noi_bat=1 ';
$rows = iland4_layDanhSachDuAn($DBConfig, $returnField, $conditionParams, $page, $limit, $orderby, $language);
return $rows[3];
}
function save()
{
$id = JRequest::getInt('id', 0, 'POST');
$datas = array('value' => JRequest::getVar('vi_hidden_ten'), 'ordering' => '0');
// $datas_en = array (
// 'value' => JRequest::getVar( 'en_hidden_ten' ) ,
// 'ordering' => '0' ,
//// 'ordering' => JRequest::getVar( 'ordering' ) ,
// );
$DBConfig = ilandCommonUtils::getSiteDBConfig();
$language = 'vi';
$language1 = 'en';
// $tenvi = JRequest::getVar( 'vi_hidden_ten') ;
// $datas_en['id'] = JRequest::getVar( 'en_hidden_ten') ;
$paramfieldDeafaul = 'ten, ordering';
$paramfield_en = 'id, ten, ordering';
if (!$id) {
// them loai du an moi
$insertId = iland4_themLoaiDuAn($DBConfig, $paramfieldDeafaul, $datas, $language);
$datas_en[] = "{$insertId}";
$datas_en[] = JRequest::getVar('en_hidden_ten');
$datas_en[] = '6';
return iland4_themLoaiDuAn($DBConfig, $paramfield_en, $datas_en, $language1);
}
// sua loai du an moi
// return iland4_suaLoaiDuAn($DBConfig, $id, $paramvalue, $language);
$dataEn = JRequest::getVar('en_hidden_ten');
$giaTriTen = "ten='{$datas['value']}'";
$this->updateProject_group($id, $giaTriTen, $language);
$giaTriTenEn = "ten='{$dataEn}'";
$this->updateProject_group($id, $giaTriTenEn, $language1);
// print_r($giaTriTen);
// exit;
// $this->_lastId = $id;
// print_r($this->_lastId);
// exit;
// echo "<script>alert($this->_lastId)</script>";
return true;
}
function getlistproject()
{
jimport('joomla.html.pagination');
JToolBarHelper::title(JText::_(ucfirst($this->get('category')) . ' management'), 'jea.png');
JToolBarHelper::publish();
JToolBarHelper::unpublish();
JToolBarHelper::addNew();
JToolBarHelper::editList();
JToolBarHelper::deleteList(JText::_('CONFIRM_DELETE_MSG'));
global $u_reGlobalConfig;
// get return field
$returnField = $u_reGlobalConfig['PROJECT']['project_list_return_field'];
//get limit
$limit = $u_reGlobalConfig['PROJECT']['list_limit'];
$orderby = $u_reGlobalConfig['PROJECT']['orderby'];
// get condition param
$context = 'com_jea.projects';
$mainframe =& JFactory::getApplication();
$patch_split_f = split("/", JFactory::getURI()->_path);
$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();
$DBConfig = ilandCommonUtils::getSiteDBConfig();
$conditionParams = ' 1 ';
//$loai_du_an_id = JFactory::getURI()->getVar("loai_du_an_id");
$isfontend = 1;
foreach ($patch_split_f as $patch_value) {
if ($patch_value == 'administrator') {
$isfontend = 0;
break;
}
}
if ($isfontend) {
$conditionParams .= ' AND hien_thi_ra_ngoai = 1';
}
//else
//{
// if ( $published!=-1 ) $conditionParams .= ' AND hien_thi_ra_ngoai = '.$published;
//}
//if( $emphasis != -1 ) $conditionParams .= ' AND noi_bat = '.$emphasis;
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 . '%\'';
}
//if( $loai_du_an_id ) $conditionParams .= ' AND loai_du_an_id = '.$loai_du_an_id;
// end get condition param
$limitstart =& JRequest::getVar('limitstart', 0);
$page = ($limitstart + $limit) / $limit;
$projectModel = new U_ReModelProjects();
$projectData = $projectModel->getListProjects($returnField, $conditionParams, $page, $limit, $orderby);
//$this->assignRef( 'type_id', $projectData['type_id'] );
//$type = ilandCommonUtils::getSelectBox( 'loai_du_an', 'type_id', JText::_('LOAI_DU_AN'), $type_id, 'onchange=document.adminForm.submit()');
//$this->assignRef( 'type', $type );
$this->assignRef('town_id', $town_id);
$towns = ilandCommonUtils::getSelectBox('tinh_thanh', 'town_id', JText::_('TINH_THANH'), $town_id, 'onchange=document.adminForm.submit()');
$this->assignRef('towns', $towns);
$this->assignRef('area_id', $projectData['area_id']);
$areas = ilandCommonUtils::getSelectBox('quan_huyen', 'area_id', JText::_('QUAN_HUYEN'), $area_id, 'onchange=document.adminForm.submit()', $this->town_id);
$this->assignRef('areas', $areas);
$this->assignRef('paging', ilandCommonUtils::getPage($projectData['rows'][0], $limit));
$this->assignRef('rows', $projectData['rows'][3]);
//$this->assignRef( 'emphasis', $emphasis );
$this->assignRef('published', $published);
$this->assignRef('search', $search);
$this->pagination = new JPagination($projectData['rows'][0], $limitstart, $limit);
parent::display();
}
function demLuotXemDuAn($du_an_id = '0', $initValue = 100)
{
$DBConfig = ilandCommonUtils::getSiteDBConfig();
return iland4_demLuotXemDuAn($DBConfig, $du_an_id) + $initValue;
}
function ordering($table, $id, $paramstring)
{
// print_r($table);
// print_r($id);
// print_r($paramstring);
// exit;
$language = ilandCommonUtils::getLanguage();
$DBConfig = ilandCommonUtils::getSiteDBConfig();
$DBConfig = ilandCommonUtils::getSiteDBConfig();
$ordering = 'ordering_' . $id;
$orderingvalue = JRequest::getVar("{$ordering}", '');
$paramvalue = "ordering = '{$orderingvalue}'";
switch ($table) {
case 'phap_ly':
iland4_suaPhapLy($DBConfig, $id, $paramstring, $language);
break;
case 'don_vi_tien':
iland4_suaDonViTien($DBConfig, $id, $paramstring);
break;
case 'don_vi_dien_tich':
iland4_suaDonViDienTich($DBConfig, $id, $paramstring, $language);
break;
case 'loai_tien_ich':
iland4_suaLoaiTienIch($DBConfig, $id, $paramstring, $language);
break;
case 'tien_ich':
iland4_suaTienIch($DBConfig, $id, $paramstring, $language);
break;
case 'tinh_thanh':
iland4_suaTinhThanhPho($DBConfig, $id, $paramstring);
break;
case 'quan_huyen':
iland4_suaQuanHuyen($DBConfig, $id, $paramstring);
break;
case 'loai_bds':
iland4_suaLoaiBDS($DBConfig, $id, $paramstring, $language);
break;
case 'loai_du_an':
iland4_suaLoaiDuAn($DBConfig, $id, $paramstring, $language);
break;
}
}
function laydanhsachduanmulti($quanHuyenId = null, $tinhThanhId = null, $lang = 'vi')
{
// return id & name
$DBConfig = ilandCommonUtils::getSiteDBConfig();
$paramfield = 'id, ten, alias';
$page = 1;
$limit = 10000;
$condition = ' 1 ';
if (!empty($quanHuyenId)) {
$condition .= ' AND quan_huyen_id in (' . $quanHuyenId . ' )';
}
if (!empty($tinhThanhId)) {
$condition .= ' AND tinh_thanh_id = ' . $tinhThanhId . ' ';
}
$orderby = 'ten';
$language = 'vi';
$result = iland4_layDanhSachDuAn($DBConfig, $paramfield, $condition, $page, $limit, $orderby, $language);
return $result[3];
}
function ordering($id, $language)
{
$DBConfig = ilandCommonUtils::getSiteDBConfig();
$ordering = 'ordering_' . $id;
$orderingvalue = JRequest::getVar("{$ordering}", '');
$paramvalue = "ordering = '{$orderingvalue}'";
// print_r($ordering);
// print_r($orderingvalue);
// print_r($paramvalue);
// exit;
return iland4_suaDuAn($DBConfig, $id, $paramvalue, $language);
// $this->updateProject_group( $id, $paramvalue, $language );
}
function getRealtorDelete($id)
{
//xoa thu muc hinh anh cua bds
jimport('joomla.filesystem.folder');
global $u_reGlobalConfig;
$propertyImagePath = $u_reGlobalConfig['IMAGE']['realtor_image_path'];
$dirimg = JPATH_ROOT . DS . $propertyImagePath . DS . $id;
if (JFolder::exists($dirimg)) {
JFolder::delete($dirimg);
}
// xoa du lieu o database
$ArrayLanguage = ilandCommonUtils::getArrayLanguage();
$DBConfig = ilandCommonUtils::getSiteDBConfig();
return iland4_xoaNhaMoiGioi($DBConfig, $id, $ArrayLanguage);
}
function themBDS($paramfeild, $paramvalue, $language)
{
$DBConfig = ilandCommonUtils::getSiteDBConfig();
return iland4_themBDS($DBConfig, $paramfeild, $paramvalue, $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();
}
