function postDetail($url)
{
$typeNameNone = $this->uri->segment(1, "");
$type = new Estatetype();
$type->where('name_none', $typeNameNone)->get();
if ($type->exists()) {
show_404();
}
$cate = new Estatecatalogue();
$cate->where('name_none', $this->uri->segment(1, ''))->get();
if (!$cate->exists()) {
show_404();
}
$dis['cate'] = $cate;
$url = geturlfromuri($this->uri->segment(3));
$estate = new Estate();
$estate->where('title_none', $url);
$estate->where_related_estatecatalogue('id', $cate->id);
$estate->where('active', 0);
$estate->get();
if (!$estate->exists()) {
redirect(base_url() . $this->uri->segment(1, '') . '-' . $this->uri->segment(2, ''));
die;
}
$dis['o'] = $estate;
$photo = new Estate_photo();
$photo->where('estate_id', $estate->id);
$photo->get_iterated();
$dis['photo'] = $photo;
$tag = $estate->tag;
$dis['tag'] = explode(',', $tag);
$description = str_replace(array("\r", "\n"), '', strip_tags($estate->description));
$keyword = explode(' ', $estate->title);
$this->page_title = $estate->title . ' | SotayNhadat.vn';
$this->page_description = cut_string($description, 180);
$this->page_keyword = implode(', ', $keyword);
/*Get estate related vip*/
$estates_vip = new Estate();
$estates_vip->where('id !=', $estate->id);
$estates_vip->where('estatetype_id', $estate->estatetype_id);
$estates_vip->where('estatecity_id', $estate->estatecity_id);
$estates_vip->where('estateprice_id', $estate->estateprice_id);
$estates_vip->where('isVip', 1);
$estates_vip->where('active', 0);
$estates_vip->order_by('created', 'desc');
$estates_vip->get(10);
$count_vip = $estates_vip->result_count();
$dis['estates_vip'] = $estates_vip;
/*Get estate related follow type, city and price*/
$estates_related_type_city_area = new Estate();
$estates_related_type_city_area->where('id !=', $estate->id);
$estates_related_type_city_area->where('estatetype_id', $estate->estatetype_id);
$estates_related_type_city_area->where('estatecity_id', $estate->estatecity_id);
$estates_related_type_city_area->where('estateprice_id', $estate->estateprice_id);
$estates_related_type_city_area->where('isVip', 0);
$estates_related_type_city_area->where('active', 0);
$estates_related_type_city_area->order_by('created', 'desc');
$estates_related_type_city_area->get(10 - $count_vip);
$dis['estates_related_type_city_area'] = $estates_related_type_city_area;
$count_type_city_area = $estates_related_type_city_area->result_count();
/*Get all id estate*/
$list_estates_id = array(0);
foreach ($estates_related_type_city_area as $row) {
array_push($list_estates_id, $row->id);
}
/*Get estate related follow type, city and area*/
if (10 - $count_vip - $count_type_city_area > 0) {
/*If count more than 10*/
$estates_related_area_price = new Estate();
$estates_related_area_price->where('estatetype_id', $estate->estatetype_id);
$estates_related_area_price->where('estatearea_id', $estate->estatearea_id);
$estates_related_area_price->where('estatecity_id', $estate->estatecity_id);
$estates_related_area_price->where_not_in('id', $list_estates_id);
$estates_related_area_price->where('isVip', 0);
$estates_related_area_price->where('active', 0);
$estates_related_area_price->order_by('created', 'desc');
$estates_related_area_price->get(10 - $count_vip - $count_type_city_area);
//$dis['estates_related_area_price'] = $estates_related_area_price;
}
//$limit_lv3 = $estates_related_area_price->result_count()==$limit_lv2?0:$limit_lv2-$estates_related_area_price->result_count();
foreach ($estates_related_area_price as $row) {
array_push($list_estates_id, $row->id);
}
$estates_related_new = new Estate();
$estates_related_new->where('estatetype_id', $estate->estatetype_id);
$estates_related_new->where('estatearea_id', $estate->estatearea_id);
$estates_related_new->where('estatecity_id', $estate->estatecity_id);
$estates_related_new->where('estateprice_id', $estate->estateprice_id);
$estates_related_new->where_not_in('id', $list_estates_id);
$estates_related_new->where('active', 0);
$estates_related_new->order_by('created', 'desc');
$estates_related_new->get($limit_lv3);
$dis['estates_related_new'] = $estates_related_new;
$estates_related_price = new Estate();
$estates_related_price->where('estateprice_id', $estate->estateprice_id);
$estates_related_price->where('estatecity_id', $estate->estatecity_id);
$estates_related_price->where('id !=', $estate->id);
$estates_related_price->where('active', 0);
$estates_related_price->order_by('created', 'desc');
$estates_related_price->get(10);
$dis['estates_related_price'] = $estates_related_price;
$estatePrices = new Estateprice();
$estatePrices->where('estatecatalogue_id', $estate->estatecatalogue_id);
$estatePrices->order_by('position', 'asc');
$estatePrices->get_iterated();
$dis['estatePrices'] = $estatePrices;
$this->isRobotFollow = 3;
$dis['base_url'] = base_url();
$dis['view'] = 'front/user/post-detail';
$this->viewfront($dis);
}
function edit($id = 0)
{
$estate = new estate($id);
if ($_SERVER['REQUEST_METHOD'] == "POST") {
$this->load->helper('remove_vn_helper');
$this->load->library('file_lib');
$estate->estatecity_id = $this->input->post('estatecity_id');
$estate->estatedistrict_id = $this->input->post('estatedistrict_id');
$estate->estateward_id = $this->input->post('estateward_id');
$estate->estatedirection_id = $this->input->post('estatedirection_id');
$estate->estatecatalogue_id = $this->input->post('estatecatalogue_id');
$estate->estatetype_id = $this->input->post('estatetype_id');
$estate->estatearea_id = $this->input->post('estatearea_id');
$estate->estateprice_id = $this->input->post('estateprice_id');
$estate->address = $this->input->post('address');
$estate->isArea = $this->input->post('IsArea');
$estate->area = $this->input->post('area');
$estate->legally = $this->input->post('legally');
$estate->isPrice = $this->input->post('IsPrice');
$estate->price_text = $this->input->post('price_text');
$estate->estatedirection_id = $this->input->post('estatedirection_id');
/*$estate->estateuser_id = $this->session->userdata('userLoginId');*/
$estate->title = $this->input->post('title');
$estate->description = $this->input->post('description');
$estate->price_text = $this->input->post('price_text');
$estate->area_text = $this->input->post('area_text');
$estate->article_id = $this->input->post('article_id');
$estate->price_type = $this->input->post('price_type');
if ($estate->isVip == 0) {
$estate->updateTime = date('Y-m-d H:i:s');
} else {
$estate->created = $estate->created;
$estate->updated = $estate->updated;
$estate->updateTime = date('Y-m-d H:i:s');
}
$estate->tag = $this->input->post('tag');
$tags = remove_vn($this->input->post('tag') . ' ' . $this->input->post('title'));
$tags = explode('-', $tags);
$estate->tag_search = implode(' ', $tags);
// Change images default
if ($_FILES['image']['name'] != "") {
$folder = 'img/project/';
$dataupload = $this->file_lib->upload('image', $folder, $rename_file = true);
if (!is_array($dataupload)) {
flash_message('error', $dataupload);
$estate->photo = '';
} else {
$estate->photo = $folder . $dataupload['file_name'];
}
}
// Add thumbnail to slide
if ($_FILES['thumb']['name'] != "") {
$folder = 'img/project/';
$dataupload = $this->file_lib->upload('thumb', $folder, $rename_file = true);
if (!is_array($dataupload)) {
flash_message('error', $dataupload);
} else {
$estate_photos = new Estate_photo();
$estate_photos->estate_id = $estate->id;
$estate_photos->name = $folder . $dataupload['file_name'];
$estate_photos->save();
$estate_photos->clear();
}
}
$estate->title_none = remove_vn($this->input->post('title')) . $estate->code;
if ($estate->save()) {
flash_message('success', 'Bản tin đã được thay đổi thành công.');
redirect($this->admin_url . 'estates/list_all/');
//redirect($this->admin_url.'estates/edit/'.$estate->id);
} else {
flash_message('error', 'Đã có lỗi xãy ra !');
//redirect($this->admin_url.'estates/list_all/');
redirect($this->admin_url . 'estates/edit/' . $estate->id);
}
}
$estateCategory = new Estatecatalogue();
$estateCategory->get_iterated();
$dis['estateCategory'] = $estateCategory;
$estateType = new Estatetype();
$estateType->order_by('id');
$estateType->where('estatecatalogue_id', $estate->estatecatalogue_id);
$estateType->get_iterated();
$dis['estateType'] = $estateType;
$estateAreas = new Estatearea();
$estateAreas->order_by('position');
//$estateAreas->where('estatecatalogue_id', $estate->estatecatalogue_id);
$estateAreas->get_iterated();
$dis['estateAreas'] = $estateAreas;
$estateDirection = new Estatedirection();
$estateDirection->order_by('id');
$estateDirection->get_iterated();
$dis['estateDirection'] = $estateDirection;
$estatePrices = new Estateprice();
$estatePrices->where('estatecatalogue_id', $estate->estatecatalogue_id);
$estatePrices->order_by('position', 'asc');
$estatePrices->get_iterated();
$dis['estatePrices'] = $estatePrices;
$estateCities = new Estatecity();
$estateCities->order_by('id');
$estateCities->get_iterated();
$dis['estateCities'] = $estateCities;
$estateDictricts = new Estatedistrict();
$estateDictricts->where('estatecity_id', $estate->estatecity_id);
$estateDictricts->order_by('position', 'asc');
$estateDictricts->get_iterated();
$dis['estateDictricts'] = $estateDictricts;
$estateWards = new Estateward();
$estateWards->where('estatedistrict_id', $estate->estatedistrict_id);
$estateWards->order_by('position');
$estateWards->get_iterated();
$dis['estateWards'] = $estateWards;
$project = new Article();
$project->where('recycle', 0);
$project->where('estatecity_id', $estate->estatecity_id);
$project->where('estatedistrict_id', $estate->estatedistrict_id);
$project->order_by('title_vietnamese', 'asc');
$project->get_iterated();
$dis['project'] = $project;
$photos = new Estate_photo();
$photos->where('estate_id', $estate->id);
$photos->get_iterated();
$dis['photos'] = $photos;
$dis['object'] = $estate;
$dis['base_url'] = base_url();
$dis['view'] = 'estate/edit';
$dis['menu_active'] = 'Tin bất động sản';
$dis['title'] = "Thêm/Sửa Tin '" . $estate->title . "'";
$dis['nav_menu'] = array(array("type" => "back", "text" => "Quay về", "link" => "{$this->admin_url}estates/list_all/", "onclick" => ""));
$this->viewadmin($dis);
}
