ikan Uploader :
Directory : /var/www/vhosts/omkar.com/httpdocs/application/controllers/admin/
Upload File : |
| Current File : /var/www/vhosts/omkar.com/httpdocs/application/controllers/admin/Home_8apr2019.php |
<?php
if (!defined('BASEPATH'))
exit('No direct script access allowed');
require_once APPPATH.'libraries/PHPExcel.php';
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
/*
Description of admistrator
*
* @author pc mart ltd
*/
class Home extends CI_Controller {
public function __construct() {
parent::__construct();
if ($this->session->userdata('username') ==''){
redirect('admin/login');
}
$this->load->model('home_model');
$this->load->library('classes/PHPExcel.php');
}
public function index($action = NULL) {
$data['title'] = 'Dashboard';
//$data['page'] = lang('dashboard');
$data['subview'] = $this->load->view('admin/main_content', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
/*public function list_amenites($id = NULL) {
$data['title'] = 'Manage Banners | List';
$data['info'] = $this->home_model->show_amenities_list();
$data['subview'] = $this->load->view('admin/manage_amenities/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_amenity($id = NULL) {
$data['title'] = 'Manage Amenites | Add';
$data['form_title'] = 'Add Amenity';
if(!empty($id)){
$data['title'] = 'Manage Banners | Update';
$data['form_title'] = 'Update Project';
$data['amenity_info'] = $this->home_model->getSingle_amenity($id);
}
$data['subview'] = $this->load->view('admin/manage_amenities/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function save_amenity($id = NULL) {
$amenity_name = $this->input->post('amenity_name');
$description = $this->input->post('amenity_description');
$description = trim($description,' ');
$images = $this->input->post('images');
if($id != NULL){
//update
$data = array('name' => $amenity_name,'description' => $description);
$this->home_model->update_amenity($id,$data,$_FILES);
$type = 'success';
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_amenites/');
} else{
//check duplicate
$is_duplicate = $this->home_model->checkDuplicate_amenity($amenity_name);
//add
if($is_duplicate == 0 || $is_duplicate == ""){
$data = array(
'name' => $amenity_name,
'description' => $description,
'created_date' => date('Y-m-d H:i:s'));
$this->home_model->add_amenity($data,$_FILES);
$data['type'] = 'success';
$data['message'] = "Added sccessfully";
redirect('admin/home/list_amenites/');
} else{
//duplicate
$type = 'error';
$msg = lang('already_exist');
set_message($type, $msg);
redirect('admin/home/list_amenites/');
}
}
}
public function delete_amenity($id){
$data = $this->home_model->delete_amenity($id);
redirect('admin/home/list_amenites/');
}
public function change_status_amenity($id,$status){
$data= $this->home_model->change_status_amenity($id,$status);
$type = 'success';
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_amenites/');
}*/
public function update_project($id = NULL) {
$data['title'] = 'Manage Project | Add';
$data['form_title'] = 'Update Project';
if(!empty($id)){
$data['title'] = 'Manage Project | Update';
$data['form_title'] = 'Update Project';
$data['project_info'] = $this->home_model->getSingle_project($id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($id);
//$data['is_luxurious'] = $this->home_model->getSingle_project_luxurious($id);
}
$data['subview'] = $this->load->view('admin/manage_projects/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_project($id = NULL){
$project_name = $this->input->post('project_name');
$location = $this->input->post('location');
$site_address = $this->input->post('project_site_address');
$sub_title = $this->input->post('sub_title');
$project_meta_title = $this->input->post('project_meta_title');
$project_meta_keywords = $this->input->post('project_meta_keywords');
$project_meta_description = $this->input->post('project_meta_description');
$project_type = $this->input->post('project_type');
$project_status = $this->input->post('project_status');
$rera_no = trim($this->input->post('rera_no'));
$disclaimer = trim($this->input->post('disclaimer'));
$structured_map_data = $this->input->post('structured_map_data');
$url = $this->input->post('url');
//$luxurious = $this->input->post('luxurious');
if($id != NULL){
//update
$data = array(
'name' => $project_name,
'location' => $location,
'site_address' => $site_address,
'sub_title'=>$sub_title,
'meta_title'=>$project_meta_title,
'meta_keywords'=>$project_meta_keywords,
'meta_description'=>$project_meta_description,
'project_type' => $project_type,
'project_status' => $project_status,
'url' => $url,
'rera_no' => $rera_no,
'disclaimer' => $disclaimer,
'structured_map_data'=>$structured_map_data
//'is_luxurious' => $luxurious
);
$this->home_model->update_project($id,$data,$_FILES);
$this->session->set_flashdata('project_success_msg', 'Project information has been updated.');
redirect('admin/home/update_project/'.$id);
} else{
//check duplicate
$is_duplicate = $this->home_model->checkDuplicate_project($project_name);
//add
if($is_duplicate == 0 || $is_duplicate == ""){
$data = array(
'name' => $project_name,
'location' => $location,
'site_address' => $site_address,
'sub_title'=> $sub_title,
'meta_title'=> $project_meta_title,
'meta_keywords'=> $project_meta_keywords,
'meta_description'=> $project_meta_description,
'project_type' => $project_type,
'project_status'=> $project_status,
'url'=> $url,
'rera_no' => $rera_no,
'disclaimer' => $disclaimer,
'structured_map_data'=>$structured_map_data,
//'is_luxurious' => $luxurious,
'created_date' => date('Y-m-d H:i:s'));
$this->home_model->add_project($data,$_FILES);
$data['type'] = 'success';
$data['message'] = "Added sccessfully";
redirect('admin/home/list_projects/');
} else{
//duplicate
$type = 'error';
$msg = lang('already_exist');
//set_message($type, $msg);
redirect('admin/home/list_projects/');
}
}
}
public function list_projects($id = NULL) {
$data['title'] = 'Manage Projects | List';
$data['info'] = $this->home_model->show_projects_list();
$data['subview'] = $this->load->view('admin/manage_projects/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function change_status_project($id,$status){
$data= $this->home_model->change_status_project($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_projects/');
}
public function delete_project($id){
$data = $this->home_model->delete_project($id);
redirect('admin/home/list_projects/');
}
public function updated_project_description($project_id, $id = NULL){
$data['title'] = 'Manage Project Description| Add';
$data['form_title'] = 'Description';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
if(!empty($id)){
$data['title'] = 'Manage Project Description | Update';
$data['form_title'] = 'Description';
}
$data['subview'] = $this->load->view('admin/manage_projects/description', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function updated_project_specification($project_id, $id = NULL){
$data['title'] = 'Manage Project Specification| Add';
$data['form_title'] = 'Specification';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
$data['project_spec'] = $this->home_model->getSingle_project_spec($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
if(!empty($id)){
$data['title'] = 'Manage Project Specification | Update';
$data['form_title'] = 'Specification';
}
$data['subview'] = $this->load->view('admin/manage_projects/specification', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
/*-- manage pages --*/
public function list_pages() {
$data['title'] = 'Manage Pages | List';
$data['form_title'] = 'List';
$data['info'] = $this->home_model->show_pages_list();
$data['subview'] = $this->load->view('admin/manage_pages/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_page($id) {
$data['title'] = 'Manage Pages | Update';
$data['form_title'] = 'Update Page';
$data['page_info'] = $this->home_model->getSingle_page($id);
$data['subview'] = $this->load->view('admin/manage_pages/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_page($id = NULL){
//$page_name = $this->input->post('page_name');
$content = $this->input->post('content');
$title = $this->input->post('title');
$meta_description = $this->input->post('meta_description');
$meta_keywords = $this->input->post('meta_keywords');
$structured_map_data = $this->input->post('structured_map_data');
$data = array(
'content' => $content,
'title'=> $title,
'meta_description'=> $meta_description,
'meta_keywords'=> $meta_keywords,
'structured_map_data'=>$structured_map_data
);
//update
$this->home_model->update_page($id, $data);
$type = 'success';
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_pages/');
}
public function change_status_page($id,$status){
$data= $this->home_model->change_status_page($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_pages/');
}
public function delete_page($id){
$data = $this->home_model->delete_page($id);
redirect('admin/home/list_pages');
}
/*-- //manage pages --*/
public function save_project_description($project_id,$id=NULL){
$project_desc = $this->input->post('project_desc');
if($id != NULL){
//update
$data = array(
'description'=>$project_desc,
'project_id'=>$project_id,
'created_date' => date('Y-m-d H:i:s')
);
$this->home_model->update_project_desc($id,$data);
$this->session->set_flashdata('description_success_msg', 'Project description has been updated.');
redirect('admin/home/updated_project_description/'.$project_id.'/'.$id);
}else{
$data = array(
'description'=>$project_desc,
'project_id'=>$project_id,
'created_date' => date('Y-m-d H:i:s')
);
$this->home_model->add_project_desc($data);
$this->session->set_flashdata('description_success_msg', 'Project description has been updated.');
redirect('admin/home/updated_project_description/'.$project_id.'/'.$id);
}
}
public function save_project_specification($project_id,$id=NULL){
$project_desc = $this->input->post('project_desc');
if($id != NULL){
//update
$data = array(
'description'=>$project_desc,
'project_id'=>$project_id
);
$this->home_model->update_project_spec($id,$data);
$this->session->set_flashdata('description_success_msg', 'Project specification has been updated.');
redirect('admin/home/updated_project_specification/'.$project_id.'/'.$id);
}else{
$data = array(
'description'=>$project_desc,
'project_id'=>$project_id
);
$this->home_model->add_project_spec($data);
$this->session->set_flashdata('description_success_msg', 'Project specification has been updated.');
redirect('admin/home/updated_project_specification/'.$project_id.'/'.$id);
}
}
/*-- manage footer menu --*/
public function list_footer_menu() {
$data['title'] = 'Manage footer menu | List';
$data['form_title'] = 'List';
$data['info'] = $this->home_model->show_footer_menu_list();
$data['subview'] = $this->load->view('admin/footer_menu/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_footer_menu($id = NULL) {
$data['title'] = 'Manage footer menu | Add';
$data['form_title'] = 'Add Menu';
if(!empty($id)){
$data['title'] = 'Manage footer menu | Update';
$data['form_title'] = 'Update Menu';
$data['footer_info'] = $this->home_model->getSingle_footer_menu($id);
}
$data['subview'] = $this->load->view('admin/footer_menu/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function save_footer_menu($id = NULL){
$menu_name = $this->input->post('menu_name');
$link = $this->input->post('link');
if($id != NULL){
//update
$data = array(
'name' => $menu_name,
'link'=>$link,
);
$this->home_model->update_footer_menu($id,$data);
$this->session->set_flashdata('success_msg', 'Footer menu information has been updated');
redirect('admin/home/list_footer_menu');
} else{
//check duplicate
$is_duplicate = $this->home_model->checkDuplicate_footer_menu($menu_name);
//add
if($is_duplicate == 0 || $is_duplicate == ""){
$data = array(
'name' => $menu_name,
'link'=>$link,
);
$this->home_model->add_footer_menu($data);
$this->session->set_flashdata('success_msg', 'Footer menu information has been added.');
redirect('admin/home/list_footer_menu');
} else{
//duplicate
$this->session->set_flashdata('error_msg', 'Information already exist');
redirect('admin/home/list_footer_menu');
}
}
}
public function change_status_footer_menu($id,$status){
$data = $this->home_model->change_status_footer_menu($id,$status);
if($data > 0){
$this->session->set_flashdata('success_msg', 'Status updated');
}else{
$this->session->set_flashdata('error_msg', 'Error occurred while updating status');
}
redirect('admin/home/list_footer_menu');
}
public function delete_footer_menu($id){
$data = $this->home_model->delete_footer_menu($id);
$this->session->set_flashdata('success_msg', 'Deleted sccessfully');
redirect('admin/home/list_footer_menu');
}
/*-- //manage footer menu --*/
public function list_project_floor_plan($project_id,$id = NULL) {
$data['title'] = 'Floor plan | List';
$data['form_title'] = 'Floor plan';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
//$data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
$data['info'] = $this->home_model->show_projects_floor_plan_list($project_id);
$data['subview'] = $this->load->view('admin/manage_floor_plans/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_project_floor_plan($project_id, $id = NULL){
$data['title'] = 'Manage Project floor plan| Add';
$data['form_title'] = 'Floor plan';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
//$data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
if(!empty($id)){
$data['title'] = 'Manage Project Floor Plan| Update';
$data['form_title'] = 'Floor plan';
$data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id,$id);
}
$data['subview'] = $this->load->view('admin/manage_floor_plans/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function delete_project_floor_plan($project_id,$id){
$data = $this->home_model->delete_project_floor_plan($id);
redirect('admin/home/list_project_floor_plan/'.$project_id);
}
public function delete_project_partner($project_id,$id){
$data = $this->home_model->delete_project_partner($id);
redirect('admin/home/list_project_partners/'.$project_id);
}
public function save_project_floor_plan($project_id, $id = NULL){
$project_floor_plan_name = $this->input->post('project_floor_plan_name');
$image = $this->input->post('image');
//$plan_type = $this->input->post('plan_type');
if($id != NULL){
//update
$data = array(
//'plan_type' => $plan_type,
'name' => $project_floor_plan_name,
'project_id'=> $project_id);
$this->home_model->update_project_floor_plan($id,$data,$_FILES);
$this->session->set_flashdata('project_success_msg', 'Project plan has been updated.');
redirect('admin/home/update_project_floor_plan/'.$project_id.'/'.$id);
} else{
$data = array(
//'plan_type' => $plan_type,
'name' => $project_floor_plan_name,
'project_id'=> $project_id,
'created_date' => date('Y-m-d H:i:s'));
$this->home_model->add_project_floor_plan_name($data,$_FILES);
$data['type'] = 'success';
$data['message'] = "Added sccessfully";
redirect('admin/home/list_project_floor_plan/'.$project_id);
/*//check duplicate
$is_duplicate = $this->home_model->checkDuplicate_project_floor_plan_name($project_floor_plan_name, $project_id);
//add
if($is_duplicate == 0 || $is_duplicate == ""){
$data = array(
'name' => $project_floor_plan_name,
'project_id'=> $project_id,
'created_date' => date('Y-m-d H:i:s'));
$this->home_model->add_project_floor_plan_name($data,$_FILES);
$data['type'] = 'success';
$data['message'] = "Added sccessfully";
redirect('admin/home/list_projects/');
} else{
//duplicate
$type = 'error';
$msg = lang('already_exist');
set_message($type, $msg);
redirect('admin/home/list_projects/');
}*/
}
}
/*-- manage contact enquiry --*/
public function save_contact_enquiry(){
$first_name = $this->input->post('first_name');
$last_name = $this->input->post('last_name');
$project_name = $this->input->post('project_name');
$email = $this->input->post('email');
$phone = $this->input->post('phone');
$name = $first_name.' '.$last_name;
$data = array(
'name'=>$name,
'email'=>$email,
'phone'=>$phone,
'project_name' => $project_name
);
$this->home_model->add_contact_enquiry($data);
redirect(base_url());
//$this->session->set_flashdata('success_msg', 'Project amenites has been updated.');
//redirect('admin/home/update_project_amenities/');
}
public function project_enquiries() {
$data['title'] = 'Manage contact | List';
$data['form_title'] = 'List';
$data['info'] = $this->home_model->show_project_contact_enquiry();
$data['subview'] = $this->load->view('admin/project_contact_enquiry/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function export_project_enquiries(){
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Set properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
->setLastModifiedBy("Maarten Balliauw")
->setTitle("Office 2007 XLSX Test Document")
->setSubject("Office 2007 XLSX Test Document")
->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
->setKeywords("office 2007 openxml php")
->setCategory("Test result file");
// Add some data
$objPHPExcel->getActiveSheet()->setCellValue('A2', 'Name');
$objPHPExcel->getActiveSheet()->setCellValue('B2', 'Email');
$objPHPExcel->getActiveSheet()->setCellValue('C2', "Phone Number");
$objPHPExcel->getActiveSheet()->setCellValue('D2', "Project Name");
$objPHPExcel->getActiveSheet()->setCellValue('E2', "Message");
$objPHPExcel->getActiveSheet()->setCellValue('F2', "Date");
$data = $this->home_model->show_project_contact_enquiry();
$i=3;
// while($row=mysqli_fetch_assoc($result)){
// print_r($data);exit;
foreach ($data as $key => $row) {
$name = $row['name'];
$created_on = date("Y-m-d",strtotime($row['created_on']));
$email= $row['email'];
$phone= $row['phone'];
$project_name= $row['project_name'];
$message= $row['message'];
$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $name);
$objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $email);
$objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $phone);
$objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $project_name);
$objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $message);
$objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $created_on);
$i=$i+1;
}
$objPHPExcel->getActiveSheet()->getStyle('A1:F1')->applyFromArray(
array('fill' => array(
'type' => PHPExcel_Style_Fill::FILL_SOLID,
'color' => array('argb' => 'BFBFBFBF')
),
)
);
$objPHPExcel->getActiveSheet()->getStyle('A2:F2')->applyFromArray(
array('fill' => array(
'type' => PHPExcel_Style_Fill::FILL_SOLID,
'color' => array('argb' => 'EAEAEAEA')
),
)
);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('F1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('F1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('F1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('F1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(25);
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('C2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('C2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('D2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('D2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('E2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('E2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('F2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('F2')->getFont()->setSize(11);
// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('Simple');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
// Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="project-enquiries-'.rand(10000,99999).'.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
redirect('admin/home/project_enquiries/');
}
public function nri_enquiries() {
$data['title'] = 'Manage NRI Enquiries | List';
$data['form_title'] = 'List';
$data['info'] = $this->home_model->show_nri_enquiry();
$data['subview'] = $this->load->view('admin/nri_enquiries/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function export_nri_enquiries(){
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Set properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
->setLastModifiedBy("Maarten Balliauw")
->setTitle("Office 2007 XLSX Test Document")
->setSubject("Office 2007 XLSX Test Document")
->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
->setKeywords("office 2007 openxml php")
->setCategory("Test result file");
// Add some data
$objPHPExcel->getActiveSheet()->setCellValue('A2', 'Name');
$objPHPExcel->getActiveSheet()->setCellValue('B2', 'Email');
$objPHPExcel->getActiveSheet()->setCellValue('C2', "Dialcode");
$objPHPExcel->getActiveSheet()->setCellValue('D2', "Phone Number");
$objPHPExcel->getActiveSheet()->setCellValue('E2', "Location");
$objPHPExcel->getActiveSheet()->setCellValue('F2', "Country");
$objPHPExcel->getActiveSheet()->setCellValue('G2', "Date");
$data = $this->home_model->show_nri_enquiry();
$i=3;
// while($row=mysqli_fetch_assoc($result)){
// print_r($data);exit;
foreach ($data as $key => $row) {
$name = $row['full_name'];
$created_date = date("Y-m-d",strtotime($row['created_date']));
$email_id= $row['email_id'];
$dialcode= $row['dialcode'];
$phone_no= $row['phone_no'];
$country= $row['country'];
$location= $row['location'];
$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $name);
$objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $email_id);
$objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $dialcode);
$objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $phone_no);
$objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $location);
$objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $country);
$objPHPExcel->getActiveSheet()->setCellValue('G'.$i, $created_date);
$i=$i+1;
}
$objPHPExcel->getActiveSheet()->getStyle('A1:G1')->applyFromArray(
array('fill' => array(
'type' => PHPExcel_Style_Fill::FILL_SOLID,
'color' => array('argb' => 'BFBFBFBF')
),
)
);
$objPHPExcel->getActiveSheet()->getStyle('A2:G2')->applyFromArray(
array('fill' => array(
'type' => PHPExcel_Style_Fill::FILL_SOLID,
'color' => array('argb' => 'EAEAEAEA')
),
)
);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('F1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('G1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('F1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('G1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('F1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('F1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('G1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('G1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(25);
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('C2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('C2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('D2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('D2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('E2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('E2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('F2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('F2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('G2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('G2')->getFont()->setSize(11);
// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('Simple');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
// Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="nri-enquiries-'.rand(10000,99999).'.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
redirect('admin/home/nri_enquiries/');
}
public function whatsapp_enquiries() {
$data['title'] = 'Manage WhatsApp Enquiries | List';
$data['form_title'] = 'List';
$data['info'] = $this->home_model->show_whatsapp_enquiry();
$data['subview'] = $this->load->view('admin/whatsapp_enquiries/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function export_whatsapp_enquiries(){
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Set properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
->setLastModifiedBy("Maarten Balliauw")
->setTitle("Office 2007 XLSX Test Document")
->setSubject("Office 2007 XLSX Test Document")
->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
->setKeywords("office 2007 openxml php")
->setCategory("Test result file");
// Add some data
$objPHPExcel->getActiveSheet()->setCellValue('A2', 'Name');
$objPHPExcel->getActiveSheet()->setCellValue('B2', 'Dialcode');
$objPHPExcel->getActiveSheet()->setCellValue('C2', "Mobile Number");
$objPHPExcel->getActiveSheet()->setCellValue('D2', "Project Name");
$objPHPExcel->getActiveSheet()->setCellValue('E2', "Message");
$objPHPExcel->getActiveSheet()->setCellValue('F2', "Date");
$data = $this->home_model->show_whatsapp_enquiry();
$i=3;
// while($row=mysqli_fetch_assoc($result)){
// print_r($data);exit;
foreach ($data as $key => $row) {
$name = $row['name'];
$created_date = date("Y-m-d",strtotime($row['created_date']));
$dialcode= $row['dialcode'];
$mobile_no= $row['mobile_no'];
$country= $row['country'];
$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $name);
$objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $dialcode);
$objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $mobile_no);
$objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $country);
$objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $created_date);
$i=$i+1;
}
$objPHPExcel->getActiveSheet()->getStyle('A1:E1')->applyFromArray(
array('fill' => array(
'type' => PHPExcel_Style_Fill::FILL_SOLID,
'color' => array('argb' => 'BFBFBFBF')
),
)
);
$objPHPExcel->getActiveSheet()->getStyle('A2:E2')->applyFromArray(
array('fill' => array(
'type' => PHPExcel_Style_Fill::FILL_SOLID,
'color' => array('argb' => 'EAEAEAEA')
),
)
);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(25);
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('C2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('C2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('D2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('D2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('E2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('E2')->getFont()->setSize(11);
// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('Simple');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
// Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="whatsapp-enquiries-'.rand(10000,99999).'.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
redirect('admin/home/whatsapp_enquiries/');
}
public function delete_whatsapp_enquiry($id){
$data = $this->home_model->delete_whatsapp_enquiry($id);
$this->session->set_flashdata('success_msg', 'Deleted sccessfully');
redirect('admin/home/whatsapp_enquiries');
}
public function delete_nri_enquiry($id){
$data = $this->home_model->delete_nri_enquiry($id);
$this->session->set_flashdata('success_msg', 'Deleted sccessfully');
redirect('admin/home/nri_enquiries');
}
public function delete_project_contact($id){
$data = $this->home_model->delete_project_contact($id);
$this->session->set_flashdata('success_msg', 'Deleted sccessfully');
redirect('admin/home/project_enquiries');
}
public function update_contact($project_id, $id = NULL){
$data['title'] = 'Manage Project contact| Add';
$data['form_title'] = 'contact';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
if(!empty($id)){
$data['title'] = 'Manage Project Contact| Update';
$data['form_title'] = 'contact';
}
$data['subview'] = $this->load->view('admin/manage_projects/contact_detail', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_project_contact($project_id,$id=NULL){
/*$project_address = $this->input->post('project_address');
$email_id = $this->input->post('project_email_id');
$project_phone_no = $this->input->post('project_phone_no');
$project_fax_no = $this->input->post('project_fax_no');
$project_location = $this->input->post('project_location');*/
$iframe = $this->input->post('iframe');
$sub_title = $this->input->post('sub_title');
//$project_longitude = $this->input->post('project_longitude');
$edit_thumb_img = $this->input->post('edit_thumb_img');
if($id != NULL){
if($edit_thumb_img !='' && empty($_FILES['street_map']['tmp_name'])){
$data = array(
'iframe'=>$iframe,
'sub_title'=>$sub_title,
'project_id'=>$project_id,
'street_map'=> $edit_thumb_img
);
$this->home_model->update_project_contact($id,$data);
$this->session->set_flashdata('description_success_msg', 'Project contact has been updated.');
redirect('admin/home/update_contact/'.$project_id.'/'.$id);
}else{
$temp_name = $_FILES['street_map']['tmp_name'];
$file_name = time().rand().$_FILES['street_map']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'iframe'=>$iframe,
'sub_title'=>$sub_title,
'project_id'=>$project_id,
'street_map'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/street_map_img/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->update_project_contact($id,$data);
$this->session->set_flashdata('description_success_msg', 'Project contact has been updated.');
redirect('admin/home/update_contact/'.$project_id.'/'.$id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/update_contact/'.$project_id.'/'.$id);
}
}
}else{
$temp_name = $_FILES['street_map']['tmp_name'];
$file_name = time().rand().$_FILES['street_map']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'iframe'=>$iframe,
'project_id'=>$project_id,
'street_map'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/street_map_img/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->add_project_contact($data);
$this->session->set_flashdata('description_success_msg', 'Project contact has been updated.');
redirect('admin/home/update_contact/'.$project_id.'/'.$id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/update_contact/'.$project_id.'/'.$id);
}
}
}
/*public function update_project_brochure($project_id, $id = NULL){
$data['title'] = 'Manage Project Brochure| Add';
$data['form_title'] = 'Brochure';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
$data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
if(!empty($id)){
$data['title'] = 'Manage Project Brochure| Update';
$data['form_title'] = 'Brochure';
}
$data['subview'] = $this->load->view('admin/manage_brouchers/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_project_brochure($project_id,$id=NULL){
$project_brochure_name = $this->input->post('project_brochure_name');
$edit_thumb_img = $this->input->post('edit_thumb_img');
//$brochure_file = $this->input->post('brochure_file');
if($id != NULL){
if($edit_thumb_img !='' && empty($_FILES['brochure_file']['tmp_name'])){
$data = array(
'name' => $project_brochure_name,
'project_id'=> $project_id,
'file_name'=> $edit_thumb_img
);
$this->home_model->update_brochuer($id,$data);
$this->session->set_flashdata('project_success_msg', 'Project brochure has been updated.');
redirect('admin/home/update_project_floor_plan/'.$project_id.'/'.$id);
}else{
$temp_name = $_FILES['brochure_file']['tmp_name'];
$file_name = time().rand().$_FILES['brochure_file']['name'];
$check_mime = $this->check_pdf_mime($temp_name);
if($check_mime){
$data = array(
'name' => $project_brochure_name,
'project_id'=> $project_id,
'file_name'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/brochures/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->update_brochuer($id,$data);
$this->session->set_flashdata('project_success_msg', 'Project brochure has been updated.');
redirect('admin/home/update_project_floor_plan/'.$project_id.'/'.$id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid pdf');
redirect('admin/home/update_project_brochure/'.$project_id.'/'.$id);
}
}
//update
} else{
//check duplicate
$is_duplicate = $this->home_model->checkDuplicate_project_brochure_name($project_brochure_name, $project_id);
//add
if($is_duplicate == 0 || $is_duplicate == ""){
/*$data = array(
'name' => $project_brochure_name,
'project_id'=> $project_id,
'created_date' => date('Y-m-d H:i:s'));
$this->home_model->add_project_brocher_name($data,$_FILES);
$data['type'] = 'success';
$data['message'] = "Added sccessfully";
redirect('admin/home/list_projects/');*/
/* $temp_name = $_FILES['brochure_file']['tmp_name'];
$file_name = time().rand().$_FILES['brochure_file']['name'];
$check_mime = $this->check_pdf_mime($temp_name);
if($check_mime){
$data = array(
'name' => $project_brochure_name,
'project_id'=> $project_id,
'file_name'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/brochures/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->add_project_brocher_name($data);
$this->session->set_flashdata('project_success_msg', 'Project brochure has been updated.');
redirect('admin/home/update_project_floor_plan/'.$project_id.'/'.$id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid pdf');
redirect('admin/home/update_project_brochure/'.$project_id.'/'.$id);
}
} else{
//duplicate
$this->session->set_flashdata('project_success_msg', 'Brochure name already exist');
redirect('admin/home/update_project_brochure/'.$project_id.'/'.$id);
}
}
}
public function download_brochure($name, $data){
$this->load->helper('download');
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/brochures/".$name;
$path = file_get_contents($path);
force_download('brochure.pdf',$path);
}*/
public function list_project_partners($project_id,$id = NULL) {
$data['title'] = 'Partners | List';
$data['form_title'] = 'partners';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
$data['info'] = $this->home_model->show_projects_partners_list($project_id);
$data['subview'] = $this->load->view('admin/manage_partners/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_project_partners($project_id,$id = NULL){
$data['title'] = 'Manage Project Partners| Add';
$data['form_title'] = 'partners';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
if(!empty($id)){
$data['title'] = 'Manage Project Partners| Update';
$data['form_title'] = 'partners';
$data['project_partners'] = $this->home_model->getSingle_project_partner_image($project_id,$id);
}
$data['subview'] = $this->load->view('admin/manage_partners/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_projects_partners($project_id,$id = NULL){
//print_r($_POST);exit;
$partner_name = $this->input->post('partner_name');
$name = $this->input->post('project_partners_name');
/*print_r($_POST);
echo $id;exit;*/
if($id != NULL){
if(empty($_FILES['image']['tmp_name'])){
// print_r($_POST);//exit;
$data = array(
'name' => $name,
'project_id'=> $project_id,
'partner_name'=> $partner_name,
'created_date' => date("Y-m-d H:i:s")
);
// print_r($data);exit;
$this->home_model->update_projects_partners($id,$data);
$this->session->set_flashdata('project_success_msg', 'Partner image has been updated');
redirect('admin/home/list_project_partners/'.$project_id);
}else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'name' => $name,
'project_id'=> $project_id,
'image'=> $file_name,
'partner_name'=> $partner_name,
'created_date' => date("Y-m-d H:i:s")
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/project_partners/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->update_projects_partners($id,$data);
$this->session->set_flashdata('project_success_msg', 'Partner image has been updated');
redirect('admin/home/list_project_partners/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_project_partners/'.$project_id);
}
}
//update
} else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'name' => $name,
'project_id'=> $project_id,
'image'=> $file_name,
'partner_name'=> $partner_name,
'created_date' => date("Y-m-d H:i:s")
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/project_partners/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->add_projects_partners($data);
redirect('admin/home/list_project_partners/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_project_partners/'.$project_id);
}
}
}
public function list_project_gallery($project_id,$id = NULL) {
$data['title'] = 'Gallery | List';
$data['form_title'] = 'Gallery';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
$data['info'] = $this->home_model->show_projects_gallery_list($project_id);
$data['subview'] = $this->load->view('admin/manage_gallery/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_project_gallery_image($project_id,$id = NULL){
$data['title'] = 'Manage Project Gallery| Add';
$data['form_title'] = 'Gallery';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
if(!empty($id)){
$data['title'] = 'Manage Project Gallery| Update';
$data['form_title'] = 'Gallery';
$data['project_gallery_image'] = $this->home_model->getSingle_project_gallery_image($project_id,$id);
}
$data['subview'] = $this->load->view('admin/manage_gallery/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_project_gallery_image($project_id,$id = NULL){
$name = $this->input->post('name');
$category = $this->input->post('category');
$edit_thumb_img = $this->input->post('edit_thumb_img');
if($id != NULL){
if($edit_thumb_img !='' && empty($_FILES['image']['tmp_name'])){
$data = array(
'name' => $name,
'project_id'=> $project_id,
'image'=> $edit_thumb_img,
'category'=> $category
);
$this->home_model->update_project_gallery_image($id,$data);
$this->session->set_flashdata('project_success_msg', 'Gallery image has been updated');
redirect('admin/home/list_project_gallery/'.$project_id);
}else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'name' => $name,
'project_id'=> $project_id,
'image'=> $file_name,
'category'=> $category
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/gallery/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->update_project_gallery_image($id,$data);
$this->session->set_flashdata('project_success_msg', 'Gallery image has been updated');
redirect('admin/home/list_project_gallery/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_project_gallery/'.$project_id);
}
}
//update
} else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'name' => $name,
'project_id'=> $project_id,
'image'=> $file_name,
'category'=> $category
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/gallery/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->add_project_gallery_image($data);
redirect('admin/home/list_project_gallery/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_project_gallery/'.$project_id);
}
}
}
public function delete_project_gallery_image($project_id,$image_id){
$data = $this->home_model->delete_project_gallery_image($image_id);
redirect('admin/home/list_project_gallery/'.$project_id);
}
public function change_status_project_gallery($project_id,$id,$status){
$data= $this->home_model->change_status_project_gallery($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_project_gallery/'.$project_id);
}
public function list_location_advantages($project_id,$id = NULL) {
$data['title'] = 'Location Advantages | List';
$data['form_title'] = 'Location Advantages';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
$data['info'] = $this->home_model->show_projects_gallery_list($project_id);
$data['subview'] = $this->load->view('admin/manage_gallery/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function list_project_video($project_id,$id = NULL) {
$data['title'] = 'Video | List';
$data['form_title'] = 'Video';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id,$id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
$data['info'] = $this->home_model->show_projects_video_list($project_id);
$data['subview'] = $this->load->view('admin/manage_video/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_project_video($project_id,$id = NULL){
$data['title'] = 'Manage Project Video| Add';
$data['form_title'] = 'Video';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
if(!empty($id)){
$data['title'] = 'Manage Project Video| Update';
$data['form_title'] = 'Video';
$data['project_gallery_image'] = $this->home_model->getSingle_project_gallery_image($project_id,$id);
$data['project_video'] = $this->home_model->getSingle_project_video($project_id,$id);
}
$data['subview'] = $this->load->view('admin/manage_video/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_project_video($project_id,$id = NULL){
$name = $this->input->post('name');
$link = $this->input->post('link');
//$edit_thumb_img = $this->input->post('edit_thumb_img');
if($id != NULL){
//update
$data = array(
'name' => $name,
'project_id'=> $project_id,
'link'=> $link
);
$this->home_model->update_project_video($id,$data);
$this->session->set_flashdata('project_success_msg', 'Video has been updated');
redirect('admin/home/list_project_video/'.$project_id);
/*if($edit_thumb_img !='' && empty($_FILES['thumb_img']['tmp_name'])){
$data = array(
'name' => $name,
'project_id'=> $project_id,
'link'=> $link,
'thumb_img'=> $edit_thumb_img
);
$this->home_model->update_project_video($id,$data);
$this->session->set_flashdata('project_success_msg', 'Video has been updated');
redirect('admin/home/list_project_video/'.$project_id);
}else{
$temp_name = $_FILES['thumb_img']['tmp_name'];
$file_name = time().rand().$_FILES['thumb_img']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'name' => $name,
'project_id'=> $project_id,
'link'=> $link,
'thumb_img'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/video_thumb/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->update_project_video($id,$data);
$this->session->set_flashdata('project_success_msg', 'Video has been updated');
redirect('admin/home/list_project_video/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/update_project_video/'.$project_id);
}
}*/
}else{
$data = array(
'name' => $name,
'project_id'=> $project_id,
'link'=> $link
);
$this->home_model->add_project_video($data);
$data['type'] = 'success';
$data['message'] = "Added sccessfully";
redirect('admin/home/list_project_video/'.$project_id);
/*$temp_name = $_FILES['thumb_img']['tmp_name'];
$file_name = time().rand().$_FILES['thumb_img']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'name' => $name,
'project_id'=> $project_id,
'link'=> $link,
'thumb_img'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/video_thumb/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->add_project_video($data);
$data['type'] = 'success';
$data['message'] = "Added sccessfully";
redirect('admin/home/list_project_video/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/update_project_video/'.$project_id);
}*/
}
}
public function delete_project_video($project_id,$image_id){
$data = $this->home_model->delete_project_video($image_id);
redirect('admin/home/list_project_video/'.$project_id);
}
public function list_project_banners($project_id,$id = NULL) {
$data['title'] = 'Project banner | List';
$data['form_title'] = 'Banners';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
$data['info'] = $this->home_model->show_projects_banners_list($project_id);
$data['subview'] = $this->load->view('admin/manage_banners/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_project_banner($project_id, $id = NULL){
$data['title'] = 'Manage Project Banners| Add';
$data['form_title'] = 'Banners';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
if(!empty($id)){
$data['title'] = 'Manage Project Banner| Update';
$data['form_title'] = 'Banners';
$data['project_banner'] = $this->home_model->getSingle_project_banner($project_id,$id);
}
$data['subview'] = $this->load->view('admin/manage_banners/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_project_banner($project_id, $id = NULL){
$project_banner_name = $this->input->post('project_banner_name');
$image = $this->input->post('image');
$big_text = $this->input->post('big_text');
$small_text = $this->input->post('small_text');
$edit_thumb_img = $this->input->post('edit_thumb_img');
$edit_mobile_img = $this->input->post('edit_mobile_img');
if(!empty($_FILES['mobile_banner']['tmp_name'])){
$temp_name1 = $_FILES['mobile_banner']['tmp_name'];
$file_name1 = time().rand().$_FILES['mobile_banner']['name'];
$check_mime1 = $this->check_mime($temp_name1);
if($check_mime1){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/banners/";
move_uploaded_file($temp_name1, $path.$file_name1);
$mobile_banner = $file_name1;
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_project_banners/'.$project_id);
}
}else{
$mobile_banner = $edit_mobile_img;
}
if($id != NULL){
if($edit_thumb_img !='' && empty($_FILES['image']['tmp_name'])){
$data = array(
'name' => $project_banner_name,
'big_text' => $big_text,
'small_text' => $small_text,
'project_id'=> $project_id,
'image'=> $edit_thumb_img,
'mobile_banner'=> $mobile_banner
);
$this->home_model->update_project_banner($id,$data);
$this->session->set_flashdata('project_success_msg', 'Banner has been updated.');
redirect('admin/home/list_project_banners/'.$project_id);
}else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'name' => $project_banner_name,
'big_text' => $big_text,
'small_text' => $small_text,
'project_id'=> $project_id,
'image'=> $file_name,
'mobile_banner'=> $mobile_banner
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/banners/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->update_project_banner($id,$data);
$this->session->set_flashdata('project_success_msg', 'Banner has been updated.');
redirect('admin/home/list_project_banners/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_project_banners/'.$project_id);
}
}
//update
} else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'name' => $project_banner_name,
'big_text' => $big_text,
'small_text' => $small_text,
'project_id'=> $project_id,
'image'=> $file_name,
'mobile_banner'=> $mobile_banner
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/banners/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->add_project_banner($data);
redirect('admin/home/list_project_banners/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_project_banners/'.$project_id);
}
}
//
/*$project_banner_name = $this->input->post('project_banner_name');
$image = $this->input->post('image');
$big_text = $this->input->post('big_text');
$small_text = $this->input->post('small_text');
if($id != NULL){
//update
$data = array(
'name' => $project_banner_name,
'big_text' => $big_text,
'small_text' => $small_text,
'project_id'=> $project_id);
$this->home_model->update_project_banner($id,$data,$_FILES);
$this->session->set_flashdata('project_success_msg', 'Project plan has been updated.');
redirect('admin/home/list_project_banners/'.$project_id);
} else{
$data = array(
'name' => $project_banner_name,
'big_text' => $big_text,
'small_text' => $small_text,
'project_id'=> $project_id,
'created_date' => date('Y-m-d H:i:s'));
$this->home_model->add_project_banner($data,$_FILES);
$data['type'] = 'success';
$data['message'] = "Added sccessfully";
redirect('admin/home/list_project_banners/'.$project_id);*/
/*//check duplicate
$is_duplicate = $this->home_model->checkDuplicate_project_banner_name($project_banner_name, $project_id);
//add
if($is_duplicate == 0 || $is_duplicate == ""){
$data = array(
'name' => $project_banner_name,
'project_id'=> $project_id,
'created_date' => date('Y-m-d H:i:s'));
$this->home_model->add_project_banner($data,$_FILES);
$data['type'] = 'success';
$data['message'] = "Added sccessfully";
redirect('admin/home/list_project_banners/'.$project_id);
} else{
//duplicate
$type = 'error';
$msg = lang('already_exist');
set_message($type, $msg);
redirect('admin/home/list_project_banners/'.$project_id);
}*/
//}
}
public function delete_project_banner($project_id, $image_id){
$data = $this->home_model->delete_project_banner($image_id);
$this->session->set_flashdata('success_msg', 'Deleted sccessfully');
redirect('admin/home/list_project_banners/'.$project_id);
}
public function change_status_project_banner($project_id,$id,$status){
$data= $this->home_model->change_status_project_banner($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_project_banners/'.$project_id);
}
public function list_home_banners($id = NULL) {
$data['title'] = 'Home banner | List';
$data['form_title'] = 'Home Banners';
$data['info'] = $this->home_model->show_home_banners_list();
$data['subview'] = $this->load->view('admin/home_banners/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_home_banner($id = NULL){
$data['title'] = 'Manage Home Banners| Add';
$data['form_title'] = 'Home Banners';
if(!empty($id)){
$data['title'] = 'Manage Home Banner| Update';
$data['form_title'] = 'Home Banners';
$data['home_banner'] = $this->home_model->getSingle_home_banner($id);
}
$data['subview'] = $this->load->view('admin/home_banners/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_home_banner($id = NULL){
$home_banner_name = $this->input->post('home_banner_name');
$project_id = $this->input->post('project_name');
$small_text = $this->input->post('small_text');
$big_text_white = $this->input->post('big_text_white');
$big_text_yellow = $this->input->post('big_text_yellow');
$big_text = $this->input->post('big_text');
$url = $this->input->post('url');
$edit_thumb_img = $this->input->post('edit_thumb_img');
$edit_mobile_img = $this->input->post('edit_mobile_img');
if(!empty($_FILES['mobile_banner']['tmp_name'])){
$temp_name1 = $_FILES['mobile_banner']['tmp_name'];
$file_name1 = time().rand().$_FILES['mobile_banner']['name'];
$check_mime1 = $this->check_mime($temp_name1);
if($check_mime1){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/home_page/";
move_uploaded_file($temp_name1, $path.$file_name1);
$mobile_banner = $file_name1;
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_home_banners/');
}
}else{
$mobile_banner = $edit_mobile_img;
}
if($id != NULL){
if($edit_thumb_img !='' && empty($_FILES['image']['tmp_name'])){
$data = array(
'name' => $home_banner_name,
'project_id'=> $project_id,
'image'=> $edit_thumb_img,
'mobile_banner'=> $mobile_banner,
'small_text'=> $small_text,
'big_text_white'=> $big_text_white,
'big_text_yellow'=> $big_text_yellow,
'url'=> $url,
'big_text'=> $big_text
);
$this->home_model->update_home_banner($id,$data);
$this->session->set_flashdata('project_success_msg', 'Banner has been updated.');
redirect('admin/home/list_home_banners/');
}else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'name' => $home_banner_name,
'project_id'=> $project_id,
'image'=> $file_name,
'mobile_banner'=> $mobile_banner,
'small_text'=> $small_text,
'big_text_white'=> $big_text_white,
'big_text_yellow'=> $big_text_yellow,
'url'=> $url,
'big_text'=> $big_text
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/home_page/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->update_home_banner($id,$data);
$this->session->set_flashdata('project_success_msg', 'Banner has been updated.');
redirect('admin/home/list_home_banners/');
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_home_banners/');
}
}
//update
} else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'name' => $home_banner_name,
'project_id'=> $project_id,
'image'=> $file_name,
'mobile_banner'=> $mobile_banner,
'small_text'=> $small_text,
'big_text_white'=> $big_text_white,
'big_text_yellow'=> $big_text_yellow,
'url'=> $url,
'big_text'=> $big_text
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/home_page/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->add_home_banner($data);
redirect('admin/home/list_home_banners/');
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_home_banners/');
}
}
}
public function get_particular_projects(){
$projects_results = $this->home_model->get_particular_projects($_POST['project_type']);
$html = '<option value="">Please select proejct</option>';
if(!empty($projects_results)){
foreach ($projects_results as $project) {
$html .='<option value="'.$project["id"].'">'.ucwords(strtolower($project["name"])).'</option>';
}
echo $html;
exit;
}else{
echo $html;
exit;
}
}
public function change_status_home_banner($id,$status){
$data= $this->home_model->change_status_home_banner($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_home_banners/');
}
public function delete_home_banner($banner_id){
$data = $this->home_model->delete_home_banner($banner_id);
$this->session->set_flashdata('success_msg', 'Deleted sccessfully');
redirect('admin/home/list_home_banners/');
}
public function schedule_visitors_list(){
$data['title'] = 'Manage Visitors | List';
$data['form_title'] = 'List';
$data['info'] = $this->home_model->show_schedule_visitors();
$data['subview'] = $this->load->view('admin/schedule_visitors/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function job_openings_list(){
$data['title'] = 'Manage Jobs | List';
$data['form_title'] = 'List';
$data['info'] = $this->home_model->show_job_openings();
$data['subview'] = $this->load->view('admin/manage_job_openings/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_job_opening($id = NULL) {
$data['title'] = 'Manage Jobs | Add';
$data['form_title'] = 'Add Job';
if(!empty($id)){
$data['title'] = 'Manage job | Update';
$data['form_title'] = 'Update job';
$data['job_info'] = $this->home_model->getSingle_job($id);
}
$data['subview'] = $this->load->view('admin/manage_job_openings/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_job($id = NULL) {
$position_name = $this->input->post('position_name');
$location = $this->input->post('location');
$experience = $this->input->post('experience');
$description = $this->input->post('description');
if($id != NULL){
//update
$data = array(
'position' => $position_name,
'location'=>$location,
'experience'=>$experience,
'description'=>$description
);
$this->home_model->update_job($id,$data);
$type = 'success';
$data['message'] = "Updated sccessfully";
redirect('admin/home/job_openings_list/');
} else{
//check duplicate
//$is_duplicate = $this->home_model->checkDuplicate_job($position_name);
//add
//if($is_duplicate == 0 || $is_duplicate == ""){
$data = array(
'position' => $position_name,
'location'=>$location,
'experience'=>$experience,
'description'=>$description,
'created_date' => date('Y-m-d H:i:s'));
$this->home_model->add_job($data);
$data['type'] = 'success';
$data['message'] = "Added sccessfully";
redirect('admin/home/job_openings_list/');
/* } else{
//duplicate
$type = 'error';
$data['message'] = "Already job opening present in job listing";
redirect('admin/home/update_job_opening/');
}*/
}
}
public function delete_job_opening($id){
$data = $this->home_model->delete_job_opening($id);
redirect('admin/home/job_openings_list/');
}
public function change_status_job_opening($id, $status){
$data= $this->home_model->change_status_job_opening($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/job_openings_list/');
}
public function partner_us_list(){
$data['title'] = 'Manage partners | List';
$data['form_title'] = 'List';
$data['info'] = $this->home_model->show_partners();
$data['subview'] = $this->load->view('admin/partner_us/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function partner_us_details($id){
$data['title'] = 'Details partners | Details';
$data['form_title'] = 'Details';
$data['info'] = $this->home_model->show_partner_details($id);
$data['subview'] = $this->load->view('admin/partner_us/details', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function get_partner_file($id){
$data['info'] = $this->home_model->get_partner_file($id);
$path = file_get_contents($_SERVER['DOCUMENT_ROOT'].FOLDER_NAME.'uploads/partner_us/'.$data['info']['attachment_file']);
$name = explode('.',$data['info']['attachment_file']);
force_download('partner_file'.'.'.$name[1], $path);
exit;
}
public function check_mime($temp_name){
$finfo = finfo_open(FILEINFO_MIME_TYPE);
$type = finfo_file($finfo, $temp_name);
//echo $type;exit;
if ($type == 'image/png' || $type == 'image/jpeg' || $type == 'image/jpg' || $type == 'image/gif') {
finfo_close($finfo);
return TRUE;
}else{
finfo_close($finfo);
return false;
}
}
public function check_pdf_mime($temp_name){
$finfo = finfo_open(FILEINFO_MIME_TYPE);
$type = finfo_file($finfo, $temp_name);
//echo $type;exit;
if ($type == 'application/pdf') {
finfo_close($finfo);
return TRUE;
}else{
finfo_close($finfo);
return false;
}
}
public function check_zip_mime($temp_name,$extension){
$finfo = finfo_open(FILEINFO_MIME_TYPE);
$type = finfo_file($finfo, $temp_name);
if ($type == 'application/zip' || $type == 'application/octet-stream' || $type == 'application/x-rar-compressed') {
finfo_close($finfo);
$extension = explode('.', $extension);
$allowedExts = array("zip", "rar", "ZIP", "RAR");
if (in_array($extension['1'], $allowedExts)){
return TRUE;
}else{
return false;
}
}else{
finfo_close($finfo);
return false;
}
}
public function list_awards(){
$data['title'] = 'Awards | List';
$data['award_info'] = $this->home_model->list_awards();
$data['subview'] = $this->load->view('admin/manage_awards/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function update_award($id=Null){
$data['title'] = 'Update Awards | Add';
$data['form_title'] = 'Update Awards';
if(!empty($id)){
$data['title'] = 'Update Awards| Update';
$data['form_title'] = 'Update Awards';
$data['award_info'] = $this->home_model->get_award_info($id);
}
$data['subview'] = $this->load->view('admin/manage_awards/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_awards($id=Null){
$award_name = $this->input->post('award_name');
$award_ranking = $this->input->post('award_ranking');
$description = $this->input->post('description');
$image = $this->input->post('image');
if($id != NULL){
//update
$data = array(
'name' => $award_name,
'description'=>$description,
'rank_order'=>$award_ranking
);
$this->home_model->update_award($id,$data,$_FILES);
$this->session->set_flashdata('project_success_msg', 'Project plan has been updated.');
redirect('admin/home/list_awards/'.$project_id);
} else{
//$is_duplicate = $this->home_model->checkDuplicate_award($award_name);
//if($is_duplicate == 0 || $is_duplicate == ""){
$data = array(
'name' => $award_name,
'description'=>$description,
'rank_order'=>$award_ranking,
'created_date' => date('Y-m-d H:i:s'));
$this->home_model->add_award($data,$_FILES);
$data['type'] = 'success';
$data['message'] = "Added sccessfully";
redirect('admin/home/list_awards/');
/* }else{
/*$data['type'] = 'error_msg';
$data['message'] = "Duplicate entry "; * /
$this->session->set_flashdata('class', 'alert-danger');
$this->session->set_flashdata('message', 'Duplicate home banner.');
redirect('admin/home/update_home_banner/');
}*/
}
}
public function delete_award($award_id){
$data = $this->home_model->delete_award($award_id);
$this->session->set_flashdata('success_msg', 'Deleted sccessfully');
redirect('admin/home/list_awards/');
}
public function change_status_awards($id,$status){
$data= $this->home_model->change_status_awards($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_awards/');
}
/*---------Manage Press Release-----------*/
public function manage_press_release($id = NULL) {
$data['title'] = 'Manage Press Release | List';
$data['active'] = 'press_release';
$data['info'] = $this->home_model->show_press_release_list();
$data['subview'] = $this->load->view('admin/manage_press_release/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function update_press_release($id = NULL){
$data['title'] = 'Manage Press Release | Add';
$data['form_title'] = 'Press Release';
$data['active'] = 'press_release';
//$data['page'] = lang('dashboard');
if(!empty($id)){
$data['title'] = 'Manage Press Release | Update';
$data['form_title'] = 'Update Press Release';
$data['info'] = $this->home_model->getSinglePressRelease($id);
}
$data['subview'] = $this->load->view('admin/manage_press_release/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_press_release($id = NULL){
$title = $_POST['title'];
$description = $_POST['description'];
$press_date = $_POST['press_date'];
if($id != NULL){
//update
$updatedata = array(
'title' => $title,
'description' => $description,
'press_date' => $press_date
);
$files = $_FILES;
$this->home_model->update_press_release($id, $updatedata, $files);
$type = 'success';
$msg = "Updated sccessfully";
// set_message($type, $msg);
redirect('admin/home/manage_press_release');
}else{
//check duplicate
$files = $_FILES;
//print_r($files);exit;
$adddata = array(
'title' => $title,
'description' => $description,
'press_date' => $press_date
);
$this->home_model->insert_press_release($adddata,$files);
$type = 'success';
$msg = "Added sccessfully";
// set_message($type, $msg);
redirect('admin/home/manage_press_release');
}
}
public function change_press_release_status($id,$status){
$data['info'] = $this->home_model->change_press_release_status($id,$status);
redirect('admin/home/manage_press_release');
}
public function delete_press_release($id){
$data = $this->home_model->delete_press_release($id);
redirect('admin/home/manage_press_release');
}
/*--------------------*/
/*---------Manage InfoGraphic-----------*/
Public function manage_infographics($id = NULL) {
$data['title'] = 'Manage Info Graphics | List';
$data['active'] = 'info_graphics';
$data['infograph'] = $this->home_model->show_infograpics_list();
$data['subview'] = $this->load->view('admin/manage_infographic/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function change_status_infographic($id,$status){
$data= $this->home_model->change_status_infographic($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/manage_infographics/');
}
public function delete_infographic($info_id){
$data = $this->home_model->delete_infographic($info_id);
$this->session->set_flashdata('success_msg', 'Deleted sccessfully');
redirect('admin/home/manage_infographics/');
}
public function update_infographic($id=Null){
$data['title'] = 'Update Infograph | Add';
$data['form_title'] = 'Update Infograph';
if(!empty($id)){
$data['title'] = 'Update Awards| Update';
$data['form_title'] = 'Update Awards';
$data['infograph_info'] = $this->home_model->get_infographic_info($id);
}
$data['subview'] = $this->load->view('admin/manage_infographic/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_infographic($id = Null){
$title = $this->input->post('title');
$description = $this->input->post('description');
$url = $this->input->post('url');
$view_filename = $this->input->post('view_filename');
$video = $this->input->post('video');
$publish_date = $this->input->post('publish_date');
$meta_title = $this->input->post('meta_title');
$meta_description = $this->input->post('meta_description');
$meta_keywords = $this->input->post('meta_keywords');
if($id != NULL){
//update
$files = $_FILES;
$data = array(
'title' => $title,
'description'=>$description,
'url'=>$url,
'view_filename'=>$view_filename,
'video'=>$video,
'publish_date'=>$publish_date,
'meta_title'=>$meta_title,
'meta_description'=>$meta_description,
'meta_keywords'=>$meta_keywords
);
$this->home_model->update_infographic($id,$data,$files);
$this->session->set_flashdata('project_success_msg', 'Project plan has been updated.');
redirect('admin/home/manage_infographics/'.$id);
} else{
$files = $_FILES;
$data = array(
'title' => $title,
'description'=>$description,
'url'=>$url,
'view_filename'=>$view_filename,
'video'=>$video,
'publish_date'=> date('Y-m-d', strtotime($publish_date)),
'meta_title'=>$meta_title,
'meta_description'=>$meta_description,
'meta_keywords'=>$meta_keywords,
'created_date' => date('Y-m-d H:i:s'));
//echo "<pre>";print_r($data);exit;
$this->home_model->insert_infographic($data,$_FILES);
$data['type'] = 'success';
$data['message'] = "Added sccessfully";
redirect('admin/home/manage_infographics/');
}
}
/*--------------------*/
public function list_video_gallery($id = NULL) {
$data['title'] = 'Manage Video Gallery | List';
$data['info'] = $this->home_model->show_video_gallery_list();
$data['subview'] = $this->load->view('admin/manage_video_gallery/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_video_gallery($id = NULL) {
$data['title'] = 'Manage Video Gallery | Add';
$data['form_title'] = 'Add Video';
if(!empty($id)){
$data['title'] = 'Manage Video Gallery | Update';
$data['form_title'] = 'Update Video';
$data['info'] = $this->home_model->getSingle_videoGallery($id);
}
$data['subview'] = $this->load->view('admin/manage_video_gallery/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function save_video_gallery($id = NULL) {
$title = $this->input->post('title');
$video_url = $this->input->post('link');
$media_date = $this->input->post('media_date');
if($id != NULL){
//update
$data = array('title' => $title,'video_url' => $video_url,'media_date' => $media_date);
$this->home_model->update_video_gallery($id,$data);
$type = 'success';
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_video_gallery/');
} else{
$data = array(
'title' => $title,
'video_url' => $video_url,
'media_date' => $media_date,
'created_date' => date('Y-m-d H:i:s'));
$this->home_model->add_video_gallery($data,$_FILES);
$data['type'] = 'success';
$data['message'] = "Added sccessfully";
redirect('admin/home/list_video_gallery/');
}
}
public function delete_video_gallery($id){
$data = $this->home_model->delete_video_gallery($id);
redirect('admin/home/list_video_gallery/');
}
public function change_status_video_gallery($id,$status){
$data= $this->home_model->change_status_video_gallery($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_video_gallery/');
}
/*--------------------*/
public function list_news($id = NULL) {
$data['title'] = 'Manage News | List';
$data['info'] = $this->home_model->show_news_list();
//$data['projects'] = $this->home_model->project_list_for_news();
$data['subview'] = $this->load->view('admin/manage_news/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_news($id = NULL) {
$data['title'] = 'Manage News | Add';
$data['form_title'] = 'Add News';
if(!empty($id)){
$data['title'] = 'Manage News | Update';
$data['form_title'] = 'Update News';
$data['info'] = $this->home_model->getSingle_News($id);
}
$data['projects'] = $this->home_model->project_list_for_news();
$data['subview'] = $this->load->view('admin/manage_news/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_news($id = NULL) {
$title = $this->input->post('title');
$description = $this->input->post('description');
$project_id = $this->input->post('project_id');
$news_date = $this->input->post('news_date');
if($id != NULL){
//update
$data = array('title' => $title,
'description' => $description,
'project_id' => $project_id,
'news_date' => $news_date);
$this->home_model->update_news($id,$data,$_FILES);
$type = 'success';
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_news/');
} else{
$data = array('title' => $title,
'description' => $description,
'project_id' => $project_id,
'news_date' => $news_date);
$this->home_model->add_news($data,$_FILES);
$data['type'] = 'success';
$data['message'] = "Added sccessfully";
redirect('admin/home/list_news/');
}
}
public function delete_news($id){
$data = $this->home_model->delete_news($id);
redirect('admin/home/list_news/');
}
public function change_status_news($id,$status){
$data= $this->home_model->change_status_news($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_news/');
}
public function manage_media_kit($id = NULL) {
$data['title'] = 'Manage Media Kit | List';
$data['active'] = 'media_kit';
$data['info'] = $this->home_model->show_media_kit_list();
$data['subview'] = $this->load->view('admin/manage_media_kit/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function update_media_kit($id = NULL){
$data['title'] = 'Manage Media Kit | Add';
$data['form_title'] = 'Media Kit';
$data['active'] = 'media_kit';
//$data['page'] = lang('dashboard');
if(!empty($id)){
$data['title'] = 'Manage Media Kit | Update';
$data['form_title'] = 'Update Media Kit';
$data['info'] = $this->home_model->getSingleMediaKit($id);
}
$data['subview'] = $this->load->view('admin/manage_media_kit/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_media_kit($id = NULL){
$description = $this->input->post('description');
$edit_thumb_img = $this->input->post('edit_thumb_img');
if($id != NULL){
if($edit_thumb_img !='' && empty($_FILES['image']['tmp_name'])){
$data = array(
'description' => $description,
'file_name'=> $edit_thumb_img
);
$this->home_model->update_media_kit($id,$data);
redirect('admin/home/manage_media_kit/');
}else{
$temp_name = $_FILES['image']['tmp_name'];
//print_r($_FILES);exit;
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_zip_mime($temp_name,$file_name);
//$check_mime = true;
if($check_mime){
$data = array(
'description' => $description,
'file_name'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/media_kit/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->update_media_kit($id,$data);
redirect('admin/home/manage_media_kit/');
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid file');
redirect('admin/home/update_media_kit/'.$id);
}
}
//update
} else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_zip_mime($temp_name,$file_name);
//$check_mime = true;
if($check_mime){
$data = array(
'description' => $description,
'file_name'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/media_kit/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->insert_media_kit($data);
redirect('admin/home/manage_media_kit/');
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid file');
redirect('admin/home/update_media_kit/'.$id);
}
}
//
/*if($id != NULL){
//update
$updatedata = array(
'description' => $description
);
$files = $_FILES;
$this->home_model->update_media_kit($id, $updatedata, $files);
$type = 'success';
$msg = "Updated sccessfully";
// set_message($type, $msg);
redirect('admin/home/manage_media_kit');
}else{
//check duplicate
$files = $_FILES;
//print_r($files);exit;
$adddata = array(
'description' => $description
);
$this->home_model->insert_media_kit($adddata,$files);
$type = 'success';
$msg = "Added sccessfully";
// set_message($type, $msg);
redirect('admin/home/manage_media_kit');
} */
}
public function change_media_kit_status($id,$status){
$data['info'] = $this->home_model->change_press_release_status($id,$status);
redirect('admin/home/manage_media_kit');
}
public function delete_media_kit($id){
$data = $this->home_model->delete_media_kit($id);
redirect('admin/home/manage_media_kit');
}
public function list_project_construction_updates($project_id,$id = NULL) {
$data['title'] = 'Construction Updates | List';
$data['form_title'] = 'Construction Updates';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
$data['info'] = $this->home_model->show_project_construction_updates_list($project_id);
$data['subview'] = $this->load->view('admin/manage_construction_updates/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_project_construction_updates($project_id,$id = NULL){
$data['title'] = 'Manage Project Construction Updates| Add';
$data['form_title'] = 'Construction Updates';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
if(!empty($id)){
$data['title'] = 'Manage Project Construction Updates| Update';
$data['form_title'] = 'Construction Updates';
$data['project_construction_updates'] = $this->home_model->getSingle_project_construction_updates($project_id,$id);
}
$data['subview'] = $this->load->view('admin/manage_construction_updates/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_construction_updates($project_id,$id = NULL){
$date = $this->input->post('date');
$edit_thumb_img = $this->input->post('edit_thumb_img');
if($id != NULL){
if($edit_thumb_img !='' && empty($_FILES['image']['tmp_name'])){
$data = array(
'date' => $date,
'project_id'=> $project_id,
'image'=> $edit_thumb_img
);
$this->home_model->update_project_construction_updates($id,$data);
$this->session->set_flashdata('project_success_msg', 'Construction Updates image has been updated');
redirect('admin/home/list_project_construction_updates/'.$project_id);
}else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'date' => $date,
'project_id'=> $project_id,
'image'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/construction_updates/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->update_project_construction_updates($id,$data);
$this->session->set_flashdata('project_success_msg', 'Construction Updates image has been updated');
redirect('admin/home/list_project_construction_updates/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_project_construction_updates/'.$project_id);
}
}
//update
} else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'date' => $date,
'project_id'=> $project_id,
'image'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/construction_updates/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->add_project_construction_updates($data);
redirect('admin/home/list_project_construction_updates/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_project_construction_updates/'.$project_id);
}
}
}
public function delete_project_construction_updates($project_id,$image_id){
$data = $this->home_model->delete_project_construction_updates($image_id);
redirect('admin/home/list_project_construction_updates/'.$project_id);
}
public function change_status_project_construction_updates($project_id,$id,$status){
$data= $this->home_model->change_status_project_construction_updates($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_project_construction_updates/'.$project_id);
}
public function list_project_location_advantages($project_id,$id = NULL) {
$data['title'] = 'Location Advantages | List';
$data['form_title'] = 'Location Advantages';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
$data['info'] = $this->home_model->show_project_location_advantages_list($project_id);
$data['subview'] = $this->load->view('admin/manage_location_advantages/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_project_location_advantages($project_id,$id = NULL){
$data['title'] = 'Manage Project Location Advantages| Add';
$data['form_title'] = 'Location Advantages';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
if(!empty($id)){
$data['title'] = 'Manage Project Location Advantages| Update';
$data['form_title'] = 'Location Advantages';
$data['project_location_advantages'] = $this->home_model->getSingle_project_location_advantages($project_id,$id);
}
$data['subview'] = $this->load->view('admin/manage_location_advantages/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_location_advantages($project_id, $id = NULL){
$description = $this->input->post('description');
$time = $this->input->post('time');
$image = $this->input->post('image');
$edit_thumb_img = $this->input->post('edit_thumb_img');
$edit_hover_img = $this->input->post('edit_hover_img');
if(!empty($_FILES['hover_image']['tmp_name'])){
$temp_name1 = $_FILES['hover_image']['tmp_name'];
$file_name1 = time().rand().$_FILES['hover_image']['name'];
$check_mime1 = $this->check_mime($temp_name1);
if($check_mime1){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/location_advantages/";
move_uploaded_file($temp_name1, $path.$file_name1);
$hover_image = $file_name1;
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_project_location_advantages/'.$project_id);
}
}else{
$hover_image = $edit_hover_img;
}
if($id != NULL){
if($edit_thumb_img !='' && empty($_FILES['image']['tmp_name'])){
$data = array(
'description' => $description,
'time'=> $time,
'project_id'=> $project_id,
'image'=> $edit_thumb_img,
'hover_image'=> $hover_image
);
//echo "<pre>";print_r($data);exit;
$this->home_model->update_project_location_advantages($id,$data);
$this->session->set_flashdata('project_success_msg', 'Banner has been updated.');
redirect('admin/home/list_project_location_advantages/'.$project_id);
}else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'description' => $description,
'time'=> $time,
'project_id'=> $project_id,
'image'=> $file_name,
'hover_image'=> $hover_image
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/location_advantages/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->update_project_location_advantages($id,$data);
$this->session->set_flashdata('project_success_msg', 'Banner has been updated.');
redirect('admin/home/list_project_location_advantages/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_project_location_advantages/'.$project_id);
}
}
//update
} else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'description' => $description,
'time'=> $time,
'project_id'=> $project_id,
'image'=> $file_name,
'hover_image'=> $hover_image
);
//echo "<pre>";print_r($data);exit;
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/location_advantages/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->add_project_location_advantages($data);
redirect('admin/home/list_project_location_advantages/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_project_location_advantages/'.$project_id);
}
}
}
public function delete_project_location_advantages($project_id,$image_id){
$data = $this->home_model->delete_project_location_advantages($image_id);
redirect('admin/home/list_project_location_advantages/'.$project_id);
}
public function change_status_project_location_advantages($project_id,$id,$status){
$data= $this->home_model->change_status_project_location_advantages($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_project_location_advantages/'.$project_id);
}
public function list_magazine($id = NULL) {
$data['title'] = 'Manage Magazine | List';
$data['info'] = $this->home_model->show_magazine_list();
$data['subview'] = $this->load->view('admin/manage_corporate_magazine/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_magazine($id = NULL) {
$data['title'] = 'Manage Magazine | Add';
$data['form_title'] = 'Add Magazine';
if(!empty($id)){
$data['title'] = 'Manage Magazine | Update';
$data['form_title'] = 'Update Magazine';
$data['info'] = $this->home_model->getSingle_magazine($id);
}
$data['subview'] = $this->load->view('admin/manage_corporate_magazine/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_magazine($id = NULL) {
$title = $this->input->post('title');
if($id != NULL){
//update
$data = array('title' => $title,
'created_on' => date('Y-m-d H:i:s'));
$this->home_model->update_magazine($id,$data,$_FILES);
$type = 'success';
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_magazine/');
} else{
$data = array('title' => $title,
'created_on' => date('Y-m-d H:i:s'));
$this->home_model->add_magazine($data,$_FILES);
$data['type'] = 'success';
$data['message'] = "Added sccessfully";
redirect('admin/home/list_magazine/');
}
}
public function delete_magazine($id){
$data = $this->home_model->delete_magazine($id);
redirect('admin/home/list_magazine/');
}
public function change_status_magazine($id,$status){
$data= $this->home_model->change_status_magazine($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_magazine/');
}
//
public function list_project_brochure($project_id,$id = NULL) {
$data['title'] = 'Brochure | List';
$data['form_title'] = 'Brochure';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
//$data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
$data['info'] = $this->home_model->show_project_brochure_list($project_id);
$data['subview'] = $this->load->view('admin/manage_brouchers/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_project_brochure($project_id,$id = NULL){
$data['title'] = 'Manage Project Brochure| Add';
$data['form_title'] = 'Brochure';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
if(!empty($id)){
$data['title'] = 'Manage Project Brochure| Update';
$data['form_title'] = 'Brochure';
$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id,$id);
}
$data['subview'] = $this->load->view('admin/manage_brouchers/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_project_brochure($project_id,$id = NULL){
$name = $this->input->post('name');
$edit_thumb_img = $this->input->post('edit_thumb_img');
/*print_r($_FILES);
echo (int)(ini_get('upload_max_filesize'));exit;*/
if($id != NULL){
if($edit_thumb_img !='' && empty($_FILES['image']['tmp_name'])){
$data = array(
'name' => $name,
'project_id'=> $project_id,
'image'=> $edit_thumb_img
);
$this->home_model->update_project_brochure($id,$data);
$this->session->set_flashdata('project_success_msg', 'Brochure has been updated');
redirect('admin/home/list_project_brochure/'.$project_id);
}else{
$temp_name = $_FILES['image']['tmp_name'];
$fname = $_FILES['image']['name'];
// echo $fname;exit;
$fname = str_replace(' ', '_',$fname);
$file_name = $fname;
$check_mime = $this->check_pdf_mime($temp_name);
if($check_mime){
$data = array(
'name' => $name,
'project_id'=> $project_id,
'image'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/brochures/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->update_project_brochure($id,$data);
$this->session->set_flashdata('project_success_msg', 'Brochure has been updated');
redirect('admin/home/list_project_brochure/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid pdf');
redirect('admin/home/list_project_brochure/'.$project_id);
}
}
//update
} else{
$temp_name = $_FILES['image']['tmp_name'];
$fname = $_FILES['image']['name'];
$fname = str_replace(' ', '_',$fname);
//echo $fname; print_r($_FILES);exit;
$file_name = $fname;
$check_mime = $this->check_pdf_mime($temp_name);
if($check_mime){
$data = array(
'name' => $name,
'project_id'=> $project_id,
'image'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/brochures/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->add_project_brochure($data);
redirect('admin/home/list_project_brochure/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid pdf');
redirect('admin/home/list_project_brochure/'.$project_id);
}
}
}
public function delete_project_brochure($project_id,$image_id){
$data = $this->home_model->delete_project_brochure($image_id);
redirect('admin/home/list_project_brochure/'.$project_id);
}
public function change_status_project_brochure($project_id,$id,$status){
$data= $this->home_model->change_status_project_brochure($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_project_brochure/'.$project_id);
}
//
public function list_project_investment($project_id,$id = NULL) {
$data['title'] = 'Investment Opportunity | List';
$data['form_title'] = 'Investment Opportunity';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
$data['info'] = $this->home_model->show_project_investment_list($project_id);
$data['subview'] = $this->load->view('admin/manage_investment/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_project_investment($project_id,$id = NULL){
$data['title'] = 'Manage Project Investment Opportunity| Add';
$data['form_title'] = 'Investment Opportunity';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
if(!empty($id)){
$data['title'] = 'Manage Project Investment Opportunity| Update';
$data['form_title'] = 'Investment Opportunity';
$data['project_investment'] = $this->home_model->getSingle_project_investment($project_id,$id);
}
$data['subview'] = $this->load->view('admin/manage_investment/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_investment($project_id,$id = NULL){
$description = $this->input->post('description');
//$edit_thumb_img = $this->input->post('edit_thumb_img');
//$time = $this->input->post('time');
if($id != NULL){
if(empty($_FILES['image']['tmp_name'])){
$data = array(
'description' => $description,
'project_id'=> $project_id
);
$this->home_model->update_project_investment($id,$data);
$this->session->set_flashdata('project_success_msg', 'Investment Opportunity has been updated');
redirect('admin/home/list_project_investment/'.$project_id);
}else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'description' => $description,
'project_id'=> $project_id,
'image'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/investment_opportunity/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->update_project_investment($id,$data);
$this->session->set_flashdata('project_success_msg', 'Investment Opportunity has been updated');
redirect('admin/home/list_project_investment/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_project_investment/'.$project_id);
}
}
//update
} else{
if(empty($_FILES['image']['tmp_name'])){
$data = array(
'description' => $description,
'project_id'=> $project_id
);
$this->home_model->add_project_investment($data);
redirect('admin/home/list_project_investment/'.$project_id);
}else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'description' => $description,
'project_id'=> $project_id,
'image'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/investment_opportunity/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->add_project_investment($data);
redirect('admin/home/list_project_investment/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_project_investment/'.$project_id);
}
}
}
}
public function delete_project_investment($project_id,$image_id){
$data = $this->home_model->delete_project_investment($image_id);
redirect('admin/home/list_project_investment/'.$project_id);
}
public function change_status_project_investment($project_id,$id,$status){
$data= $this->home_model->change_status_project_investment($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_project_investment/'.$project_id);
}
//
public function list_project_amenities($project_id,$id = NULL) {
$data['title'] = 'Amenities | List';
$data['form_title'] = 'Amenities';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
$data['key_description'] = $this->home_model->show_project_key_desc_amenities($project_id);
$data['info'] = $this->home_model->show_project_amenities_list($project_id);
$data['subview'] = $this->load->view('admin/manage_amenities/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_project_amenities($project_id,$id = NULL){
$data['title'] = 'Manage Project Amenities| Add';
$data['form_title'] = 'Amenities';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
//$data['project_amenities'] = $this->home_model->getSingle_project_amenities($project_id);
// $data['project_floor_plan'] = $this->home_model->getSingle_project_project_floor_plan($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
if(!empty($id)){
$data['title'] = 'Manage Project Amenities| Update';
$data['form_title'] = 'Amenities';
$data['project_amenity'] = $this->home_model->getSingle_project_amenities($project_id,$id);
}
$data['subview'] = $this->load->view('admin/manage_amenities/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_amenity($project_id,$id = NULL){
$name = $this->input->post('name');
$description = $this->input->post('description');
$edit_thumb_img = $this->input->post('edit_thumb_img');
if($id != NULL){
if($edit_thumb_img !='' && empty($_FILES['image']['tmp_name'])){
$data = array(
'name' => $name,
'project_id'=> $project_id,
'description'=> $description,
'image'=> $edit_thumb_img
);
$this->home_model->update_project_amenities($id,$data);
$this->session->set_flashdata('project_success_msg', 'Amenity has been updated');
redirect('admin/home/list_project_amenities/'.$project_id);
}else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'name' => $name,
'project_id'=> $project_id,
'description'=> $description,
'image'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/amenities/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->update_project_amenities($id,$data);
$this->session->set_flashdata('project_success_msg', 'Amenity has been updated');
redirect('admin/home/list_project_amenities/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_project_amenities/'.$project_id);
}
}
//update
} else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'name' => $name,
'project_id'=> $project_id,
'description'=> $description,
'image'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/amenities/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->add_project_amenities($data);
redirect('admin/home/list_project_amenities/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_project_amenities/'.$project_id);
}
}
}
public function delete_project_amenities($project_id,$image_id){
$data = $this->home_model->delete_project_amenities($image_id);
redirect('admin/home/list_project_amenities/'.$project_id);
}
public function change_status_project_amenities($project_id,$id,$status){
$data= $this->home_model->change_status_project_amenities($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_project_amenities/'.$project_id);
}
public function save_amenity_description($project_id = ''){
$key_description = $this->input->post('key_description');
$data = array(
'key_description' => $key_description,
'project_id'=> $project_id
);
if($project_id !=''){
$data= $this->home_model->save_amenity_description($project_id,$data);
redirect('admin/home/list_project_amenities/'.$project_id);
}else{
$this->session->set_flashdata('project_success_msg', 'Error while updating key amenities description');
redirect('admin/home/list_project_amenities/'.$project_id);
}
}
//
public function list_newsletter($id = NULL) {
$data['title'] = 'Home Newsletter | List';
$data['form_title'] = 'Home Newsletter';
$data['info'] = $this->home_model->show_newsletter_list();
$data['subview'] = $this->load->view('admin/manage_newsletter/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_newsletter($id = NULL){
$data['title'] = 'Manage Newsletter | Add';
$data['form_title'] = 'Home Newsletter';
if(!empty($id)){
$data['title'] = 'Manage Newsletter| Update';
$data['form_title'] = 'Home Newsletter';
$data['newsletter'] = $this->home_model->getSingle_newsletter($id);
}
$data['subview'] = $this->load->view('admin/manage_newsletter/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_newsletter($id = NULL){
$name = $this->input->post('name');
$link = $this->input->post('link');
$edit_thumb_img = $this->input->post('edit_thumb_img');
if($id != NULL){
if($edit_thumb_img !='' && empty($_FILES['image']['tmp_name'])){
$data = array(
'name' => $name,
'link'=> $link,
'image'=> $edit_thumb_img
);
$this->home_model->update_newsletter($id,$data);
$this->session->set_flashdata('project_success_msg', 'Newsletter has been updated.');
redirect('admin/home/list_newsletter/');
}else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'name' => $name,
'link'=> $link,
'image'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/newsletters/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->update_newsletter($id,$data);
$this->session->set_flashdata('project_success_msg', 'Newsletter has been updated.');
redirect('admin/home/list_newsletter/');
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_newsletter/');
}
}
//update
} else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'name' => $name,
'link'=> $link,
'image'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/newsletters/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->add_newsletter($data);
redirect('admin/home/list_newsletter/');
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_newsletter/');
}
}
}
public function change_status_newsletter($id,$status){
$data= $this->home_model->change_status_newsletter($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_newsletter/');
}
public function delete_newsletter($banner_id){
$data = $this->home_model->delete_newsletter($banner_id);
$this->session->set_flashdata('success_msg', 'Deleted sccessfully');
redirect('admin/home/list_newsletter/');
}
public function export_contact_enquiries(){
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Set properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
->setLastModifiedBy("Maarten Balliauw")
->setTitle("Office 2007 XLSX Test Document")
->setSubject("Office 2007 XLSX Test Document")
->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
->setKeywords("office 2007 openxml php")
->setCategory("Test result file");
// Add some data
$objPHPExcel->getActiveSheet()->setCellValue('A2', 'Name');
$objPHPExcel->getActiveSheet()->setCellValue('B2', 'Email');
$objPHPExcel->getActiveSheet()->setCellValue('C2', "Phone Number");
$objPHPExcel->getActiveSheet()->setCellValue('D2', "Location");
$objPHPExcel->getActiveSheet()->setCellValue('E2', "Comments");
$objPHPExcel->getActiveSheet()->setCellValue('F2', "Date");
$data = $this->home_model->show_contact_enquiry();
$i=3;
// while($row=mysqli_fetch_assoc($result)){
// print_r($data);exit;
foreach ($data as $key => $row) {
$name = $row['name'];
$created_on = date("Y-m-d",strtotime($row['created_on']));
$email_id= $row['email_id'];
$contact_no= $row['contact_no'];
$location= $row['location'];
$comments= $row['comments'];
$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $name);
$objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $email_id);
$objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $contact_no);
$objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $location);
$objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $comments);
$objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $created_on);
$i=$i+1;
}
$objPHPExcel->getActiveSheet()->getStyle('A1:F1')->applyFromArray(
array('fill' => array(
'type' => PHPExcel_Style_Fill::FILL_SOLID,
'color' => array('argb' => 'BFBFBFBF')
),
)
);
$objPHPExcel->getActiveSheet()->getStyle('A2:F2')->applyFromArray(
array('fill' => array(
'type' => PHPExcel_Style_Fill::FILL_SOLID,
'color' => array('argb' => 'EAEAEAEA')
),
)
);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('F1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('F1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('F1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('F1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(25);
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('C2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('C2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('D2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('D2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('E2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('E2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('F2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('F2')->getFont()->setSize(11);
// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('Simple');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
// Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="contact-enquiries-'.rand(10000,99999).'.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
redirect('admin/home/contact_enquiries/');
}
public function contact_enquiries() {
$data['title'] = 'Manage contact | List';
$data['form_title'] = 'Contact Enquiry List';
$data['info'] = $this->home_model->show_contact_enquiry();
$data['subview'] = $this->load->view('admin/contact_enquiry/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function delete_contact_enquiry($id){
$data = $this->home_model->delete_contact_enquiry($id);
$this->session->set_flashdata('success_msg', 'Deleted sccessfully');
redirect('admin/home/contact_enquiries');
}
public function vendor_registrations() {
$data['title'] = 'Manage Vendor Registration | List';
$data['form_title'] = 'Vendor Registration List';
$data['info'] = $this->home_model->show_vendor_registrations();
$data['subview'] = $this->load->view('admin/vendor_enquiry/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function delete_vendor_enquiry($id){
$data = $this->home_model->delete_vendor_enquiry($id);
$this->session->set_flashdata('success_msg', 'Deleted sccessfully');
redirect('admin/home/vendor_registrations');
}
//
public function list_event_category($id = NULL) {
$data['title'] = 'Event Category | List';
$data['form_title'] = 'Event Category List';
$data['info'] = $this->home_model->show_event_category_list();
$data['subview'] = $this->load->view('admin/manage_event_gallery/category_list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_event_category($id = NULL){
$data['title'] = 'Manage Event Category| Add';
$data['form_title'] = 'Event Category';
if(!empty($id)){
$data['title'] = 'Manage Event Category| Update';
$data['form_title'] = 'Event Category';
$data['event_category'] = $this->home_model->getSingle_event_category($id);
}
$data['subview'] = $this->load->view('admin/manage_event_gallery/category_update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_event_category($id = NULL){
$name = $this->input->post('name');
$page_name = $this->input->post('page_name');
if($id != NULL){
$data = array(
'page_name' => $page_name,
'name' => $name
);
$this->home_model->update_event_category($id,$data);
$this->session->set_flashdata('project_success_msg', 'Category has been updated.');
redirect('admin/home/list_event_category/');
//update
} else{
$data = array(
'page_name' => $page_name,
'name' => $name
);
$this->home_model->add_event_category($data);
redirect('admin/home/list_event_category/');
}
}
public function delete_event_category($banner_id){
$data = $this->home_model->delete_event_category($banner_id);
$this->session->set_flashdata('project_success_msg', 'Category deleted successfully');
redirect('admin/home/list_event_category/');
}
//
public function list_event_gallery($id = NULL) {
$data['title'] = 'Event Gallery | List';
$data['form_title'] = 'Event Gallery';
$data['info'] = $this->home_model->show_event_gallery_list();
$data['subview'] = $this->load->view('admin/manage_event_gallery/gallery_list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_event_gallery($id = NULL){
$data['title'] = 'Manage Event Gallery| Add';
$data['form_title'] = 'Event Gallery';
if(!empty($id)){
$data['title'] = 'Manage Event Gallery| Update';
$data['form_title'] = 'Event Gallery';
$data['event_gallery'] = $this->home_model->getSingle_event_gallery($id);
}
$data['event_category'] = $this->home_model->show_event_category_list();
$data['subview'] = $this->load->view('admin/manage_event_gallery/gallery_update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_event_gallery($id = NULL){
$category_id = $this->input->post('category_id');
$alt_title = $this->input->post('alt_title');
$edit_thumb_img = $this->input->post('edit_thumb_img');
if($id != NULL){
if($edit_thumb_img !='' && empty($_FILES['image']['tmp_name'])){
$data = array(
'category_id' => $category_id,
'alt_title'=> $alt_title,
'image'=> $edit_thumb_img
);
$this->home_model->update_event_gallery($id,$data);
$this->session->set_flashdata('project_success_msg', 'Event Gallery has been updated.');
redirect('admin/home/list_event_gallery/');
}else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'category_id' => $category_id,
'alt_title'=> $alt_title,
'image'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/event_gallery/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->update_event_gallery($id,$data);
$this->session->set_flashdata('project_success_msg', 'Event Gallery has been updated.');
redirect('admin/home/list_event_gallery/');
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_event_gallery/');
}
}
//update
} else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'category_id' => $category_id,
'alt_title'=> $alt_title,
'image'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/event_gallery/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->add_event_gallery($data);
redirect('admin/home/list_event_gallery/');
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_event_gallery/');
}
}
}
public function change_default_status_event_gallery($id,$category_id,$status){
$data= $this->home_model->change_default_status_event_gallery($id,$category_id,$status);
$type = 'success';
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_event_gallery/');
}
public function delete_event_gallery($banner_id){
$data = $this->home_model->delete_event_gallery($banner_id);
$this->session->set_flashdata('success_msg', 'Deleted sccessfully');
redirect('admin/home/list_event_gallery/');
}
//testimonials
public function list_testimonials($id = NULL) {
$data['title'] = 'Testimonials | List';
$data['form_title'] = 'Testimonials';
$data['info'] = $this->home_model->show_testimonials_list();
$data['subview'] = $this->load->view('admin/manage_testimonials/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_testimonials($id = NULL){
$data['title'] = 'Manage Testimonials| Add';
$data['form_title'] = 'Testimonials';
if(!empty($id)){
$data['title'] = 'Manage Testimonials| Update';
$data['form_title'] = 'Testimonials';
$data['testimonial'] = $this->home_model->getSingle_testimonials($id);
}
$data['subview'] = $this->load->view('admin/manage_testimonials/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_testimonial($id = NULL){
$page_name = $this->input->post('page_name');
$category = $this->input->post('category');
$title = $this->input->post('title');
$sub_title = $this->input->post('sub_title');
$description = $this->input->post('description');
$edit_thumb_img = $this->input->post('edit_thumb_img');
if($id != NULL){
// echo $edit_thumb_img.'---'.$_FILES['image']['tmp_name'];exit;
if($edit_thumb_img == '' && empty($_FILES['image']['tmp_name'])){
// echo 'here';exit;
$data = array(
'page_name' => $page_name,
'category' => $category,
'title'=> $title,
'sub_title'=> $sub_title,
'description'=> $description,
'image'=> $edit_thumb_img
);
$this->home_model->update_testimonials($id,$data);
$this->session->set_flashdata('project_success_msg', 'Testimonials has been updated.');
redirect('admin/home/list_testimonials/');
}else{
// echo 'im';exit;
if(!empty($_FILES['image']['tmp_name'])){
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'page_name' => $page_name,
'category' => $category,
'title'=> $title,
'sub_title'=> $sub_title,
'description'=> $description,
'image'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/testimonials/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->update_testimonials($id,$data);
$this->session->set_flashdata('project_success_msg', 'Testimonials has been updated.');
redirect('admin/home/list_testimonials/');
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_testimonials/');
}
}else{
$data = array(
'page_name' => $page_name,
'category' => $category,
'title'=> $title,
'sub_title'=> $sub_title,
'description'=> $description
//'image'=> $file_name
);
$this->home_model->update_testimonials($id,$data);
$this->session->set_flashdata('project_success_msg', 'Testimonials has been updated.');
redirect('admin/home/list_testimonials/');
}
}
//update
} else{
if($_FILES['image']['tmp_name'] != ''){
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'page_name' => $page_name,
'category' => $category,
'title'=> $title,
'sub_title'=> $sub_title,
'description'=> $description,
'image'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/testimonials/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->add_testimonials($data);
redirect('admin/home/list_testimonials/');
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_testimonials/');
}
}else{
$data = array(
'page_name' => $page_name,
'category' => $category,
'title'=> $title,
'sub_title'=> $sub_title,
'description'=> $description
//'image'=> $file_name
);
$this->home_model->add_testimonials($data);
redirect('admin/home/list_testimonials/');
}
}
}
public function change_status_testimonials($id,$status){
$data= $this->home_model->change_status_testimonials($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_testimonials/');
}
public function delete_testimonials($banner_id){
$data = $this->home_model->delete_testimonials($banner_id);
$this->session->set_flashdata('success_msg', 'Deleted sccessfully');
redirect('admin/home/list_testimonials/');
}
public function mbassy_enquiries() {
$data['title'] = 'Manage Mbassy Program Enquiries | List';
$data['form_title'] = 'Mbassy Program Enquiries';
$data['info'] = $this->home_model->show_mbassy_enquiries();
$data['subview'] = $this->load->view('admin/mbassy_enquiries/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function channel_partner_enquiries() {
$data['title'] = 'Manage Channel Partner Enquiries | List';
$data['form_title'] = 'Channel Partner Enquiries';
$data['info'] = $this->home_model->show_channel_partner_enquiries();
$data['subview'] = $this->load->view('admin/channel_partner_enquiries/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function channel_partner_enquiry_details($id) {
$data['title'] = 'ManageChannel Partner Enquiries | List';
$data['form_title'] = 'Channel Partner Enquiries';
$data['channel_partner_enquiry_details'] = $this->home_model->getSingle_channel_partner_enquiries($id);
$data['subview'] = $this->load->view('admin/channel_partner_enquiries/details', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function delete_channel_partner_enquiry($id){
$data = $this->home_model->delete_channel_partner_enquiry($id);
$this->session->set_flashdata('success_msg', 'Deleted sccessfully');
redirect('admin/home/channel_partner_enquiries');
}
public function upcoming_project_enquiries() {
$data['title'] = 'Manage Upcoming Project Enquiries | List';
$data['form_title'] = 'Upcoming Project Enquiries';
$data['info'] = $this->home_model->show_upcoming_project_enquiries();
$data['subview'] = $this->load->view('admin/upcoming_project_enquiries/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function export_upcoming_project_enquiries(){
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Set properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
->setLastModifiedBy("Maarten Balliauw")
->setTitle("Office 2007 XLSX Test Document")
->setSubject("Office 2007 XLSX Test Document")
->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
->setKeywords("office 2007 openxml php")
->setCategory("Test result file");
// Add some data
$objPHPExcel->getActiveSheet()->setCellValue('A2', 'Name');
$objPHPExcel->getActiveSheet()->setCellValue('B2', 'Email');
$objPHPExcel->getActiveSheet()->setCellValue('C2', "Phone Number");
$objPHPExcel->getActiveSheet()->setCellValue('D2', "City");
$objPHPExcel->getActiveSheet()->setCellValue('E2', "Project Name");
$objPHPExcel->getActiveSheet()->setCellValue('F2', "Project Type");
$objPHPExcel->getActiveSheet()->setCellValue('G2', "Date");
$data = $this->home_model->show_upcoming_project_enquiries();
$i=3;
// while($row=mysqli_fetch_assoc($result)){
// print_r($data);exit;
foreach ($data as $key => $row) {
$name = $row['name'];
$created_date = date("Y-m-d",strtotime($row['created_date']));
$email_id= $row['email_id'];
$city= $row['city'];
$phone_no= $row['phone'];
$project_type= $row['project_type'];
$selected_project_type= $row['selected_project_type'];
$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $name);
$objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $email_id);
$objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $phone_no);
$objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $city);
$objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $selected_project_type);
$objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $project_type);
$objPHPExcel->getActiveSheet()->setCellValue('G'.$i, $created_date);
$i=$i+1;
}
$objPHPExcel->getActiveSheet()->getStyle('A1:G1')->applyFromArray(
array('fill' => array(
'type' => PHPExcel_Style_Fill::FILL_SOLID,
'color' => array('argb' => 'BFBFBFBF')
),
)
);
$objPHPExcel->getActiveSheet()->getStyle('A2:G2')->applyFromArray(
array('fill' => array(
'type' => PHPExcel_Style_Fill::FILL_SOLID,
'color' => array('argb' => 'EAEAEAEA')
),
)
);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('F1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('G1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('F1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('G1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('F1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('F1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('G1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('G1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(25);
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('C2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('C2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('D2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('D2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('E2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('E2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('F2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('F2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('G2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('G2')->getFont()->setSize(11);
// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('Simple');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
// Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="upcoming-project-enquiries-'.rand(10000,99999).'.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
redirect('admin/home/upcoming_project_enquiries/');
}
public function embassy_enquiry_details($id) {
$data['title'] = 'Manage Mbassy Program Enquiries | List';
$data['form_title'] = 'Mbassy Program Enquiries';
$data['embassy_enquiry_details'] = $this->home_model->getSingle_mbassy_enquiries($id);
$data['subview'] = $this->load->view('admin/mbassy_enquiries/details', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function delete_upcoming_project_enquiry($id){
$data = $this->home_model->delete_upcoming_project_enquiry($id);
$this->session->set_flashdata('success_msg', 'Deleted sccessfully');
redirect('admin/home/upcoming_project_enquiries');
}
public function delete_embassy_enquiry($id){
$data = $this->home_model->delete_embassy_enquiry($id);
$this->session->set_flashdata('success_msg', 'Deleted sccessfully');
redirect('admin/home/mbassy_enquiries');
}
public function list_channel_partner_enquiries(){
$data['title'] = 'Manage Channel partner Enquiries | List';
$data['form_title'] = 'Manage Channel partner Enquiries';
$data['info'] = $this->home_model->list_channel_partner_enquiries();
$data['subview'] = $this->load->view('admin/manage_channel_partner/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function display_channel_partner_enquiery_details($id){
$data['title'] = 'Channel partner Enquiry | Details';
$data['form_title'] = 'Detials Channel partner Enquiry';
$data['channel_partner_enquiery_details'] = $this->home_model->getSingle_channel_partner_enquiery($id);
$data['subview'] = $this->load->view('admin/manage_channel_partner/details', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function delete_channel_partner_enquiery($id){
$data = $this->home_model->delete_channel_partner_enquiery($id);
$this->session->set_flashdata('success_msg', 'Deleted sccessfully');
redirect('admin/home/list_channel_partner_enquiries');
}
public function download_pan_card($id){
$result = $this->home_model->getSingle_channel_partner_enquiery($id);
$name = $result['pan_card_file'];
force_download(FCPATH.'uploads/pan_card/'.$name,NULL);
}
public function download_aadhar_card($id){
$result = $this->home_model->getSingle_channel_partner_enquiery($id);
$name = $result['adhar_card_file'];
force_download(FCPATH.'uploads/adhar_card/'.$name,NULL);
}
public function export_leads($all=NULL) {
if($all !=""){
$all = htmlentities(stripslashes($all));
}
$date = $this->input->post('reservation');
if($date!=""){
$array = explode(' - ', $date);
$start_date = $array[0];
$end_date = $array[1];
}else{
$start_date = NULL;
$end_date = NULL;
}
$all_leads = $this->home_model->getLeads($start_date,$end_date,$all);
print_r($all_leads);
exit;
date_default_timezone_set('Europe/London');
$objPHPExcel = new PHPExcel();
// Set properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
->setLastModifiedBy("Maarten Balliauw")
->setTitle("Office 2007 XLSX Test Document")
->setSubject("Office 2007 XLSX Test Document")
->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
->setKeywords("office 2007 openxml php")
->setCategory("Test result file");
// Add some data
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Leads');
$objPHPExcel->getActiveSheet()->setCellValue('A2', 'name');
$objPHPExcel->getActiveSheet()->setCellValue('B2', 'Owner Name');
$objPHPExcel->getActiveSheet()->setCellValue('C2', "Entity");
$objPHPExcel->getActiveSheet()->setCellValue('D2', "Expertise");
$objPHPExcel->getActiveSheet()->setCellValue('E2', "Expertise Other");
$objPHPExcel->getActiveSheet()->setCellValue('F2', "Pan No");
$objPHPExcel->getActiveSheet()->setCellValue('G2', "GST No");
$objPHPExcel->getActiveSheet()->setCellValue('H2', "RERA No");
$objPHPExcel->getActiveSheet()->setCellValue('I2', "Office Address");
$objPHPExcel->getActiveSheet()->setCellValue('J2', "Telephone No");
$objPHPExcel->getActiveSheet()->setCellValue('K2', "Mobile No");
$objPHPExcel->getActiveSheet()->setCellValue('L2', "Website");
$objPHPExcel->getActiveSheet()->setCellValue('M2', "Email Id");
$objPHPExcel->getActiveSheet()->setCellValue('N2', "Broker Association");
$objPHPExcel->getActiveSheet()->setCellValue('O2', "Project Interest");
$objPHPExcel->getActiveSheet()->setCellValue('P2', "Other Interested Project");
$objPHPExcel->getActiveSheet()->setCellValue('Q2', "Authorised Signatories");
$objPHPExcel->getActiveSheet()->setCellValue('R2', "Authorised Signatories Name 1");
$objPHPExcel->getActiveSheet()->setCellValue('S2', "Authorised Signatories Designation1");
$objPHPExcel->getActiveSheet()->setCellValue('T2', "Authorised Signatories Name2");
$objPHPExcel->getActiveSheet()->setCellValue('U2', "Authorised Signatories Designation2");
$objPHPExcel->getActiveSheet()->setCellValue('V2', "Area");
$objPHPExcel->getActiveSheet()->setCellValue('W2', "Other Cities of Mumbai");
$objPHPExcel->getActiveSheet()->setCellValue('X2', "Other Countries");
$objPHPExcel->getActiveSheet()->setCellValue('Y2', "Years In Operation");
$objPHPExcel->getActiveSheet()->setCellValue('Z2', "Pan Card File");
$objPHPExcel->getActiveSheet()->setCellValue('AA2', "Adhar Card File");
$objPHPExcel->getActiveSheet()->setCellValue('AB2', "Created date");/*
$objPHPExcel->getActiveSheet()->setCellValue('AB2', "Devicemodel");*/
$i=3;
if (!empty($all_leads)){
foreach ($all_leads as $v_leads){
$name = $v_leads->name;
$owner_name = $v_leads->owner_name;
$entity = $v_leads->entity;
$expertise = $v_leads->expertise;
$expertise_other = $v_leads->expertise_other;
$pan_no = $v_leads->pan_no;
//$medium = $v_leads->medium;
$gst_no = $v_leads->gst_no;
$rera_no = $v_leads->rera_no;
$office_address = $v_leads->office_address;
$telephone_no = $v_leads->telephone_no;
$mobile_no = $v_leads->mobile_no;
$website = $v_leads->website;
$email = $v_leads->email;
$broker_association = ($v_leads->broker_association==1 ? 'Yes' : 'No');
$project_interest = $v_leads->project_interest;
$other_interested_project = $v_leads->other_interested_project;
$authorised_signatories = $v_leads->authorised_signatories;
$authorised_signatories_name1 = $v_leads->authorised_signatories_name1;
$authorised_signatories_designation1 = $v_leads->authorised_signatories_designation1;
$authorised_signatories_name2 = $v_leads->authorised_signatories_name2 ;
$authorised_signatories_designation2 = $v_leads->authorised_signatories_designation2 ;
$area = $v_leads->area;
$other_cities_of_mumbai_city = $v_leads->other_cities_of_mumbai_city;
$other_countries = $v_leads->other_countries;
$years_in_operation = $v_leads->years_in_operation;
$pan_card_file = $v_leads->pan_card_file;
$adhar_card_file = $v_leads->adhar_card_file;
$created_date = $v_leads->created_date;
$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $name);
$objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $owner_name);
$objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $entity);
$objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $expertise);
$objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $expertise_other);
$objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $pan_no);
//$objPHPExcel->getActiveSheet()->setCellValue('G'.$i, $medium);
$objPHPExcel->getActiveSheet()->setCellValue('G'.$i, $gst_no);
$objPHPExcel->getActiveSheet()->setCellValue('H'.$i, $rera_no);
$objPHPExcel->getActiveSheet()->setCellValue('I'.$i, $office_address);
$objPHPExcel->getActiveSheet()->setCellValue('J'.$i, $telephone_no);
$objPHPExcel->getActiveSheet()->setCellValue('K'.$i, $mobile_no);
$objPHPExcel->getActiveSheet()->setCellValue('L'.$i, $website);
$objPHPExcel->getActiveSheet()->setCellValue('M'.$i, $email);
$objPHPExcel->getActiveSheet()->setCellValue('N'.$i, $broker_association);
$objPHPExcel->getActiveSheet()->setCellValue('O'.$i, $project_interest);
$objPHPExcel->getActiveSheet()->setCellValue('P'.$i, $other_interested_project);
$objPHPExcel->getActiveSheet()->setCellValue('Q'.$i, $authorised_signatories);
$objPHPExcel->getActiveSheet()->setCellValue('R'.$i, $authorised_signatories_name1);
$objPHPExcel->getActiveSheet()->setCellValue('S'.$i, $authorised_signatories_designation1);
$objPHPExcel->getActiveSheet()->setCellValue('T'.$i, $authorised_signatories_name2);
$objPHPExcel->getActiveSheet()->setCellValue('U'.$i, $authorised_signatories_designation2);
$objPHPExcel->getActiveSheet()->setCellValue('V'.$i, $area);
$objPHPExcel->getActiveSheet()->setCellValue('W'.$i, $other_cities_of_mumbai_city);
$objPHPExcel->getActiveSheet()->setCellValue('X'.$i, $other_countries);
$objPHPExcel->getActiveSheet()->setCellValue('Y'.$i, $years_in_operation);
$objPHPExcel->getActiveSheet()->setCellValue('Z'.$i, $pan_card_file);
$objPHPExcel->getActiveSheet()->setCellValue('AA'.$i, $adhar_card_file);
$objPHPExcel->getActiveSheet()->setCellValue('AB'.$i, $created_date);
/*
$objPHPExcel->getActiveSheet()->setCellValue('AB'.$i, $placement);*/
$i=$i+1;
}
}
else {
$this->session->set_flashdata('error', 'No data found.');
//redirect('/admin/leads');
}
$objPHPExcel->getActiveSheet()->getStyle('A1:AB1')->applyFromArray(
array('fill' => array(
'type' => PHPExcel_Style_Fill::FILL_SOLID,
'color' => array('argb' => 'BFBFBFBF')
),
)
);
$objPHPExcel->getActiveSheet()->getStyle('A2:AB2')->applyFromArray(
array('fill' => array(
'type' => PHPExcel_Style_Fill::FILL_SOLID,
'color' => array('argb' => 'EAEAEAEA')
),
)
);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('P')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('R')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('S')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('T')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('U')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('V')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('W')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('X')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('Y')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('Z')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('AA')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('AB')->setWidth(35);
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('C2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('C2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('D2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('D2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('E2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('E2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('F2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('F2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('G2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('G2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('H2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('H2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('I2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('I2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('J2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('J2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('K2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('K2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('L2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('L2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('M2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('M2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('N2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('N2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('O2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('O2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('P2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('P2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('Q2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('Q2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('R2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('R2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('S2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('S2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('T2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('T2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('U2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('U2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('V2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('V2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('W2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('W2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('X2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('X2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('Y2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('Y2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('Z2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('Z2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('AA2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('AA2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('AB2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('AB2')->getFont()->setSize(11);
// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('Leads');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
// Redirect output to a client’s web browser (Excel5)
//header('Content-Encoding: UTF-8');
header('Content-Type: application/vnd.ms-excel; charset=utf-8');
if ($this->input->post('project_name') == 'all')
header('Content-Disposition: attachment;filename="Channel_Partner-'.date('d-m-Y H:i:s').'.xls"');
else
header('Content-Disposition: attachment;filename="Channel_Partner.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
}
/*code added by Aparna to show sample flats on projects - starts here*/
public function list_sample_flats($project_id,$id = NULL) {
$data['title'] = 'Sample Flat | List';
$data['form_title'] = 'sampleflat';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
$data['key_description'] = $this->home_model->show_project_key_desc_amenities($project_id);
$data['info'] = $this->home_model->show_sampleflat_list($project_id);
$data['subview'] = $this->load->view('admin/manage_sample_flat/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_sample_flats($project_id,$id = NULL) {
$data['title'] = 'Manage Sample Flat | Add';
$data['form_title'] = 'sampleflat';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
if(!empty($id)){
$data['title'] = 'Manage Sample Flat| Update';
$data['form_title'] = 'sampleflat';
$data['sample_flat_image'] = $this->home_model->getSingle_project_sampleflat_image($project_id,$id);
}
//echo "<pre>";print_r($data);exit;
$data['subview'] = $this->load->view('admin/manage_sample_flat/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_sample_Flat_image($project_id,$id = NULL){
$name = $this->input->post('name');
$edit_thumb_img = $this->input->post('edit_thumb_img');
if($id != NULL){
if($edit_thumb_img !='' && empty($_FILES['image']['tmp_name'])){
$data = array(
'name' => $name,
'project_id'=> $project_id,
'image'=> $edit_thumb_img
);
$this->home_model->update_sample_flat_image($id,$data,$_FILES);
$this->session->set_flashdata('project_success_msg', 'Sample Flat image has been updated');
redirect('admin/home/list_sample_flats/'.$project_id);
}else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'name' => $name,
'project_id'=> $project_id,
'image'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/sample_flat/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->update_sample_flat_image($id,$data,$_FILES);
$this->session->set_flashdata('project_success_msg', 'Gallery image has been updated');
redirect('admin/home/list_sample_flats/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_sample_flats/'.$project_id);
}
}
} else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'name' => $name,
'project_id'=> $project_id,
'image'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/sample_flat/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->add_sample_flat_image($data);
redirect('admin/home/list_sample_flats/'.$project_id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/list_sample_flats/'.$project_id);
}
}
}
public function change_status_sample_flats($project_id,$id,$status)
{
$data= $this->home_model->change_status_sample_flats($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_sample_flats/'.$project_id);
}
public function delete_project_sample_flat($project_id,$image_id){
$data = $this->home_model->delete_project_sample_flat($image_id);
redirect('admin/home/list_sample_flats/'.$project_id);
}
/*code added by Aparna to show sample flats on projects - ends here*/
public function floor_pln_enquiries() {
$data['title'] = 'Manage Floor Plan Enquiries | List';
$data['form_title'] = 'List';
$data['info'] = $this->home_model->show_floor_pln_enquiry();
$data['subview'] = $this->load->view('admin/floor_pln_enquiries/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function delete_floor_plan_enquiry($id)
{
$data = $this->home_model->delete_floor_plan_enquiry($id);
$this->session->set_flashdata('success_msg', 'Deleted sccessfully');
redirect('admin/home/floor_pln_enquiries');
}
public function export_floor_plan_enquiries(){
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Set properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
->setLastModifiedBy("Maarten Balliauw")
->setTitle("Office 2007 XLSX Test Document")
->setSubject("Office 2007 XLSX Test Document")
->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
->setKeywords("office 2007 openxml php")
->setCategory("Test result file");
// Add some data
$objPHPExcel->getActiveSheet()->setCellValue('A2', 'Name');
$objPHPExcel->getActiveSheet()->setCellValue('B2', 'Email');
$objPHPExcel->getActiveSheet()->setCellValue('C2', "Mobile Number");
$objPHPExcel->getActiveSheet()->setCellValue('D2', "Configuration");
$objPHPExcel->getActiveSheet()->setCellValue('E2', "Layout");
$objPHPExcel->getActiveSheet()->setCellValue('F2', "Date");
$data = $this->home_model->show_floor_plan_enquiry();
$i=3;
// while($row=mysqli_fetch_assoc($result)){
// print_r($data);exit;
foreach ($data as $key => $row) {
$name = $row['name'];
$email = $row['email'];
$configuration = $row['configuration'];
$layout = $row['layout'];
$mobile_no= $row['mobile'];
$created_date = date("Y-m-d",strtotime($row['created_date']));
$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $name);
$objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $email);
$objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $configuration);
$objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $layout);
$objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $mobile_no);
$objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $created_date);
$i=$i+1;
}
$objPHPExcel->getActiveSheet()->getStyle('A1:E1')->applyFromArray(
array('fill' => array(
'type' => PHPExcel_Style_Fill::FILL_SOLID,
'color' => array('argb' => 'BFBFBFBF')
),
)
);
$objPHPExcel->getActiveSheet()->getStyle('A2:E2')->applyFromArray(
array('fill' => array(
'type' => PHPExcel_Style_Fill::FILL_SOLID,
'color' => array('argb' => 'EAEAEAEA')
),
)
);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(25);
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('C2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('C2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('D2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('D2')->getFont()->setSize(11);
$objPHPExcel->getActiveSheet()->getStyle('E2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('E2')->getFont()->setSize(11);
// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('Simple');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
// Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="floor_plan-enquiries-'.rand(10000,99999).'.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
redirect('admin/home/floor_pln_enquiries/');
}
// show reel video link
public function list_project_show_reel($project_id,$id = NULL) {
$data['title'] = 'ShowReel | List';
$data['form_title'] = 'Showreel';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
//$data['project_brochure'] = $this->home_model->getSingle_project_brochure($project_id);
$data['info'] = $this->home_model->show_project_showreel_link($project_id);
$data['subview'] = $this->load->view('admin/manage_showreel/list', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
}
public function update_project_showreel($project_id,$id = NULL){
$data['title'] = 'Manage Project ShowReel| Add';
$data['form_title'] = 'Showreel';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_contact($project_id);
if(!empty($id)){
$data['title'] = 'Manage Project ShowReel| Update';
$data['form_title'] = 'ShowReel';
$data['project_showreel'] = $this->home_model->getSingle_project_showreel($project_id,$id);
}
$data['subview'] = $this->load->view('admin/manage_showreel/update', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function change_status_project_showreel($project_id,$id,$status){
$data= $this->home_model->change_status_project_showreel($id,$status);
$type = 'success';
$data = array();
$data['message'] = "Updated sccessfully";
redirect('admin/home/list_project_show_reel/'.$project_id);
}
public function delete_project_showreel($project_id,$image_id){
$data = $this->home_model->delete_project_showreel($image_id);
redirect('admin/home/list_project_show_reel/'.$project_id);
}
public function save_project_showreel($project_id,$id=NULL){
$show_reel_link = $this->input->post('show_reel_link');
if($id != NULL){
//update
$data = array(
'show_reel_link'=>$show_reel_link,
'project_id'=>$project_id,
'created_date' => date('Y-m-d H:i:s')
);
$this->home_model->update_project_showreel($id,$data);
$this->session->set_flashdata('description_success_msg', 'Project description has been updated.');
redirect('admin/home/list_project_show_reel/'.$project_id.'/'.$id);
}else{
$data = array(
'show_reel_link'=>$show_reel_link,
'project_id'=>$project_id,
'created_date' => date('Y-m-d H:i:s')
);
$this->home_model->add_project_showreel($data);
$this->session->set_flashdata('description_success_msg', 'Project description has been updated.');
redirect('admin/home/list_project_show_reel/'.$project_id.'/'.$id);
}
}
// Enquire Now Background Image
public function update_enquire_image($project_id, $id = NULL){
$data['title'] = 'Manage Project Enquire Image| Add';
$data['form_title'] = 'Enquire_Image';
$data['project_info'] = $this->home_model->getSingle_project($project_id);
$data['project_desc'] = $this->home_model->getSingle_project_desc($project_id);
$data['projects_contacts'] = $this->home_model->getSingle_project_enquire_image($project_id);
if(!empty($id)){
$data['title'] = 'Manage Project Enquire Image| Update';
$data['form_title'] = 'Enquire_Image';
}
$data['subview'] = $this->load->view('admin/manage_projects/enquire_image', $data, TRUE);
$this->load->view('admin/_layout_main', $data);
$this->load->view('admin/_layout_editor');
}
public function save_project_enquire_image($project_id,$id=NULL){
$edit_thumb_img = $this->input->post('edit_thumb_img');
if($id != NULL){
if($edit_thumb_img !='' && empty($_FILES['image']['tmp_name'])){
$data = array(
'project_id'=>$project_id,
'image'=> $edit_thumb_img
);
$this->home_model->update_project_enquire_image($id,$data);
$this->session->set_flashdata('description_success_msg', 'Project contact has been updated.');
redirect('admin/home/update_enquire_image/'.$project_id.'/'.$id);
}else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'project_id'=>$project_id,
'image'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/enquire_image/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->update_project_enquire_image($id,$data);
$this->session->set_flashdata('description_success_msg', 'Project contact has been updated.');
redirect('admin/home/update_enquire_image/'.$project_id.'/'.$id);
}
}
else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/update_enquire_image/'.$project_id.'/'.$id);
}
}
}else{
$temp_name = $_FILES['image']['tmp_name'];
$file_name = time().rand().$_FILES['image']['name'];
$check_mime = $this->check_mime($temp_name);
if($check_mime){
$data = array(
'project_id'=>$project_id,
'image'=> $file_name
);
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/enquire_image/";
if(move_uploaded_file($temp_name, $path.$file_name)){
$this->home_model->add_project_enquire_image($data);
$this->session->set_flashdata('description_success_msg', 'Project contact has been updated.');
redirect('admin/home/update_enquire_image/'.$project_id.'/'.$id);
}
}else{
$this->session->set_flashdata('project_success_msg', 'Please upload valid image');
redirect('admin/home/update_enquire_image/'.$project_id.'/'.$id);
}
}
}
}
........