ikan Uploader :
Directory : /var/www/vhosts/omkar.com/httpdocs/application/models/
Upload File : |
| Current File : /var/www/vhosts/omkar.com/httpdocs/application/models/Home_model.php |
<?php
class Home_model extends CI_Model {
public function __construct() {
parent::__construct();
}
public function show_video_gallery_list(){
$this->db->order_by("id","desc");
$query = $this->db->get('video_gallery')->result_array();
return $query;
}
public function show_nri_enquiry(){
$this->db->order_by("id","desc");
$query = $this->db->get('nri_enquiries')->result_array();
return $query;
}
public function show_whatsapp_enquiry(){
$this->db->order_by("id","desc");
$query = $this->db->get('whatsapp_enquiries')->result_array();
return $query;
}
public function show_channel_partner_enquiries(){
$this->db->order_by("id","desc");
$query = $this->db->get('channel-partner')->result_array();
return $query;
}
public function delete_nri_enquiry($id){
$this->db->where('id', $id);
$query = $this->db->delete('nri_enquiries');
return $query;
}
public function delete_whatsapp_enquiry($id){
$this->db->where('id', $id);
$query = $this->db->delete('whatsapp_enquiries');
return $query;
}
/*public function show_amenities_list(){
$this->db->order_by("id","desc");
$query = $this->db->get('amenities')->result_array();
return $query;
}
public function checkDuplicate_amenity($amenity_name){
$name = strtolower($amenity_name);
$this->db->where('name', $name);
$query = $this->db->get('amenities')->row_array();
return $query['id'];
}
public function add_amenity($data,$files){
$query = $this->db->insert('amenities', $data);
$insert_id = $this->db->insert_id();
$extension = explode('/', $_FILES["images"]["type"]);
if(isset($insert_id)){
$newfilename = '';
$allowedExts = array("gif", "jpeg", "jpg", "png");
if (($_FILES["images"]["size"] < 2000000) && in_array($extension['1'], $allowedExts))
{
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/amenities/";
$newfilename = time().rand().".".$extension['1'];
if(move_uploaded_file($_FILES["images"]["tmp_name"], $path.$newfilename)){
$data_image = array('image'=>$newfilename);
$this->db->where('id', $insert_id);
$query = $this->db->update('amenities', $data_image);
}
}else{
echo "some error occured";
}
}
return $insert_id;
}
public function getSingle_amenity($id){
$this->db->where('id', $id);
$query = $this->db->get('amenities')->row_array();
return $query;
}
public function update_amenity($id,$data,$files){
//print_r($files);
//exit;
if(!empty($_FILES["images"]["tmp_name"])){
$newfilename = '';
$tmp_name = $_FILES["images"]["tmp_name"];
$check_mime = $this->check_mime($tmp_name);
// $extension = explode('/', $_FILES["images"]["type"]);
// $allowedExts = array("gif", "jpeg", "jpg", "png");
if (($_FILES["images"]["size"] < 2000000) && $check_mime)
{
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/amenities/";
$newfilename = time().rand().".".$extension;
if(move_uploaded_file($tmp_name, $path.$newfilename)){
$data_image = array('image'=>$newfilename);
$this->db->where('id', $id);
$query = $this->db->update('amenities', $data_image);
}
}else{
echo "some error occured";
}
}
$this->db->where('id',$id);
$this->db->update('amenities', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_amenity($id){
$this->db->where('id', $id);
$query = $this->db->get('amenities')->result_array();
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."/uploads/amenities/";
unlink($path.$row['image']);
$this->db->where('id', $id);
$this->db->delete('amenities');
return $query;
}
public function change_status_amenity($id,$status){
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('amenities', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}*/
public function checkDuplicate_project($project_name){
$name = strtolower($project_name);
$this->db->where('name', $name);
$query = $this->db->get('projects')->row_array();
return $query['id'];
}
public function add_project($data,$files){
$query = $this->db->insert('projects', $data);
$insert_id = $this->db->insert_id();
$extension = explode('/', $_FILES["image"]["type"]);
$extension1 = explode('/', $_FILES["logo_image"]["type"]);
if(isset($insert_id)){
$newfilename = '';
$newfilename1 = '';
$allowedExts = array("gif", "jpeg", "jpg", "png");
if (($_FILES["logo_image"]["size"] < 2000000) && in_array($extension1['1'], $allowedExts)){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/projects/logo_image/";
$newfilename1 = time().rand().".".$extension1['1'];
$newfilename1 = str_replace(' ', '_', $newfilename1);
if(move_uploaded_file($_FILES["logo_image"]["tmp_name"], $path.$newfilename1)){
$data_image1 = array('logo_image'=>$newfilename1);
$this->db->where('id', $insert_id);
$query1 = $this->db->update('projects', $data_image1);
}
}
if (($_FILES["image"]["size"] < 2000000) && in_array($extension['1'], $allowedExts))
{
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/projects/small_image/";
$newfilename = time().rand().".".$extension['1'];
$newfilename = str_replace(' ', '_', $newfilename);
if(move_uploaded_file($_FILES["image"]["tmp_name"], $path.$newfilename)){
$data_image = array('small_image'=>$newfilename);
$this->db->where('id', $insert_id);
$query = $this->db->update('projects', $data_image);
}
}else{
echo "some error occured";
}
}
return $insert_id;
}
public function show_projects_list(){
$this->db->order_by("id","desc");
$query = $this->db->get('projects')->result_array();
return $query;
}
public function change_status_project($id,$status){
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('projects', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_project($id){
$this->db->where('id', $id);
$query = $this->db->get('projects')->result_array();
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."/uploads/projects/";
unlink($path.$row['image']);
$this->db->where('id', $id);
$this->db->delete('projects');
return $query;
}
public function getSingle_project($id){
$this->db->where('id', $id);
$query = $this->db->get('projects')->row_array();
return $query;
}
/*-- manage pages --*/
public function show_pages_list(){
$this->db->order_by("id","desc");
$query = $this->db->get('pages')->result_array();
return $query;
}
public function getSingle_page($id){
$this->db->where('id', $id);
$query = $this->db->get('pages')->row_array();
return $query;
}
public function update_page($id, $data){
$this->db->where('id',$id);
$this->db->update('pages', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function change_status_page($id,$status){
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('pages', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_page($id){
$this->db->where('id', $id);
$query = $this->db->delete('pages');
return $query;
}
/*-- //manage pages --*/
public function update_project($id,$data,$files){
//print_r($files);exit;
if(!empty($files)){
$newfilename = '';
$allowedExts = array("gif", "jpeg", "jpg", "png");
if($files['image']['name'] != ''){
$extension1 = explode('/', $_FILES["image"]["type"]);
if (($_FILES["image"]["size"] < 2000000) && in_array($extension1[1], $allowedExts))
{
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/projects/small_image/";
$newfilename = time().rand().".".$extension1[1];
$newfilename = str_replace(' ', '_', $newfilename);
if(move_uploaded_file($_FILES["image"]["tmp_name"], $path . $newfilename)){
$data_image = array('small_image'=>$newfilename);
$this->db->where('id', $id);
$query = $this->db->update('projects', $data_image);
}
}else{
echo "some error occured";
}
}
if($files['logo_image']['name'] != ''){
$extension = explode('/', $_FILES["logo_image"]["type"]);
if (($_FILES["logo_image"]["size"] < 2000000) && in_array($extension[1], $allowedExts)){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/projects/logo_image/";
$newfilename1 = time().rand().".".$extension[1];
$newfilename1 = str_replace(' ', '_', $newfilename1);
if(move_uploaded_file($_FILES["logo_image"]["tmp_name"], $path.$newfilename1)){
$data_image1 = array('logo_image'=>$newfilename1);
$this->db->where('id', $id);
$query1 = $this->db->update('projects', $data_image1);
}
}else{
echo "some error occured";
}
}
}
$this->db->where('id',$id);
$this->db->update('projects', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function add_project_desc($data){
$query = $this->db->insert('projects_description', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function add_project_spec($data){
$query = $this->db->insert('projects_specification', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function getSingle_project_desc($project_id){
$this->db->where('project_id', $project_id);
$query = $this->db->get('projects_description')->row_array();
return $query;
}
public function getSingle_project_spec($project_id){
$this->db->where('project_id', $project_id);
$query = $this->db->get('projects_specification')->row_array();
return $query;
}
public function update_project_desc($id,$data){
$this->db->where('id',$id);
$this->db->update('projects_description', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function update_project_spec($id,$data){
$this->db->where('id',$id);
$this->db->update('projects_specification', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
/*public function get_all_amenities(){
$this->db->order_by("id","desc");
$query = $this->db->get('amenities')->result_array();
return $query;
}
public function add_project_amenities($data){
$query = $this->db->insert('project_amenities', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function getSingle_project_amenities($project_id){
$this->db->where('project_id', $project_id);
$query = $this->db->get('project_amenities')->row_array();
return $query;
}
public function update_project_amenities($id,$data){
$this->db->where('id',$id);
$this->db->update('project_amenities', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}*/
public function checkDuplicate_project_floor_plan_name($project_floor_plan_name, $project_id){
$name = strtolower($project_floor_plan_name);
$this->db->where('name', $name);
$this->db->where('project_id', $project_id);
$query = $this->db->get('projects_floor_plan')->row_array();
return $query['id'];
}
/*-- manage footer menu --*/
public function show_footer_menu_list(){
$this->db->order_by("id","desc");
$query = $this->db->get('footer_menu')->result_array();
return $query;
}
public function getSingle_footer_menu($id){
$this->db->where('id', $id);
$query = $this->db->get('footer_menu')->row_array();
return $query;
}
public function update_footer_menu($id, $data){
$this->db->where('id',$id);
$this->db->update('footer_menu', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function checkDuplicate_footer_menu($menu_name) {
$result = $this->db->query("SELECT COUNT(*) num FROM footer_menu WHERE name='".$menu_name."' ")->row_array();
return $result['num'];
}
public function add_footer_menu($adddata) {
return $this->db->insert('footer_menu', $adddata);
}
public function change_status_footer_menu($id,$status){
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('footer_menu', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_footer_menu($id){
$this->db->where('id', $id);
$query = $this->db->delete('footer_menu');
return $query;
}
/*-- //manage footer menu --*/
/*-- manage contact enquiry --*/
public function add_contact_enquiry($adddata) {
return $this->db->insert('contact_enquiry', $adddata);
}
public function show_project_contact_enquiry(){
$this->db->order_by("id","desc");
$query = $this->db->get('project_contact_enquiry')->result_array();
return $query;
}
public function delete_project_contact($id){
$this->db->where('id', $id);
$query = $this->db->delete('project_contact_enquiry');
return $query;
}
/*-- //manage contact enquiry --*/
public function show_projects_partners_list($project_id){
$this->db->where('project_id', $project_id);
$this->db->order_by("id","desc");
$query = $this->db->get('projects_partners')->result_array();
return $query;
}
public function show_projects_floor_plan_list($project_id){
$this->db->where('project_id', $project_id);
$this->db->order_by("id","desc");
$query = $this->db->get('projects_floor_plan')->result_array();
return $query;
}
public function add_project_floor_plan_name($data,$files){
$query = $this->db->insert('projects_floor_plan', $data);
$insert_id = $this->db->insert_id();
$extension = explode('/', $_FILES["image"]["type"]);
if(isset($insert_id)){
$newfilename = '';
$allowedExts = array("gif", "jpeg", "jpg", "png");
if (($_FILES["image"]["size"] < 2000000) && in_array($extension['1'], $allowedExts))
{
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/floor_plan/";
$newfilename = time().rand().".".$extension['1'];
$newfilename = str_replace(' ', '_', $newfilename);
if(move_uploaded_file($_FILES["image"]["tmp_name"], $path.$newfilename)){
$data_image = array('image'=>$newfilename);
$this->db->where('id', $insert_id);
$query = $this->db->update('projects_floor_plan', $data_image);
}
}else{
echo "some error occured";
}
}
return $insert_id;
}
public function getSingle_project_project_floor_plan($project_id,$id){
//$this->db->where('project_id', $project_id);
$query = $this->db->get_where('projects_floor_plan',array("project_id" => $project_id, "id" => $id))->row_array();
return $query;
}
public function delete_project_floor_plan($image_id){
$this->db->where('id', $image_id);
$query = $this->db->get('projects_floor_plan')->row_array();
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."/uploads/floor_plan/";
unlink($path.$query['image']);
$this->db->where('id', $image_id);
$this->db->delete('projects_floor_plan');
return $query;
}
public function delete_project_partner($image_id){
$this->db->where('id', $image_id);
$query = $this->db->get('projects_partners')->row_array();
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."/uploads/projects_partners/";
unlink($path.$query['image']);
$this->db->where('id', $image_id);
$this->db->delete('projects_partners');
return $query;
}
public function update_projects_partners($id,$data){
$this->db->where('id',$id);
$query = $this->db->update('projects_partners', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function update_project_floor_plan($id,$data,$files){
$this->db->where('id',$id);
$query = $this->db->update('projects_floor_plan', $data);
if(!empty($files)){
$extension = explode('/', $_FILES["image"]["type"]);
$newfilename = '';
$allowedExts = array("gif", "jpeg", "jpg", "png");
if (($_FILES["image"]["size"] < 2000000) && in_array($extension['1'], $allowedExts)) {
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/floor_plan/";
$newfilename = time().rand().".".$extension['1'];
$newfilename = str_replace(' ', '_', $newfilename);
// echo $path;exit;
if(move_uploaded_file($_FILES["image"]["tmp_name"], $path.$newfilename)){
$data_image = array('image'=>$newfilename);
$this->db->where('id', $id);
$query = $this->db->update('projects_floor_plan', $data_image);
}
}else{
echo "some error occured";
}
}
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function add_project_contact($data){
$query = $this->db->insert('projects_contacts', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function update_project_contact($id,$data){
$this->db->where('id',$id);
$this->db->update('projects_contacts', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function getSingle_project_contact($project_id){
$this->db->where('project_id', $project_id);
$query = $this->db->get('projects_contacts')->row_array();
return $query;
}
public function getSingle_project_luxurious($project_id){
$this->db->select('is_luxurious');
$this->db->where('id', $project_id);
$query = $this->db->get('projects')->row_array();
return $query;
}
/* public function checkDuplicate_project_brochure_name($project_brochure_name, $project_id){
$project_brochure_name = strtolower($project_brochure_name);
$this->db->where('project_id', $project_id);
$this->db->where('name', $project_brochure_name);
$query = $this->db->get('projects_brochures')->row_array();
return $query['id'];
}
public function add_project_brocher_name($data){
$query = $this->db->insert('projects_brochures', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function getSingle_project_brochure($project_id){
$this->db->where('project_id', $project_id);
$query = $this->db->get('projects_brochures')->row_array();
return $query;
}
public function update_brochuer($id,$data){
$this->db->where('id',$id);
$query = $this->db->update('projects_brochures', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}*/
public function show_projects_gallery_list($project_id){
$this->db->where('project_id', $project_id);
$this->db->order_by("id","desc");
$query = $this->db->get('projects_gallery')->result_array();
return $query;
}
public function checkDuplicate_project_gallery_image($image_name,$project_id){
$image_name = strtolower($image_name);
$this->db->where('name', $image_name);
$this->db->where('project_id', $project_id);
$query = $this->db->get('projects_gallery')->row_array();
return $query['id'];
}
public function add_projects_partners($data){
$query = $this->db->insert('projects_partners', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function add_project_gallery_image($data){
$query = $this->db->insert('projects_gallery', $data);
$insert_id = $this->db->insert_id();
/*$extension = explode('/', $_FILES["image"]["type"]);
if(isset($insert_id)){
$newfilename = '';
$allowedExts = array("gif", "jpeg", "jpg", "png");
if (($_FILES["image"]["size"] < 2000000) && in_array($extension['1'], $allowedExts))
{
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/gallery/";
$newfilename = time().rand().".".$extension['1'];
if(move_uploaded_file($_FILES["image"]["tmp_name"], $path.$newfilename)){
$data_image = array('image'=>$newfilename);
$this->db->where('id', $insert_id);
$query = $this->db->update('projects_gallery', $data_image);
}
}else{
echo "some error occured";
}
}*/
return $insert_id;
}
public function getSingle_project_gallery_image($project_id,$id){
$this->db->where('project_id', $project_id);
$this->db->where('id', $id);
$query = $this->db->get('projects_gallery')->row_array();
return $query;
}
public function getSingle_project_partner_image($project_id,$id){
$this->db->where('project_id', $project_id);
$this->db->where('id', $id);
$query = $this->db->get('projects_partners')->row_array();
return $query;
}
public function update_project_gallery_image($id,$data){
$this->db->where('id',$id);
$query = $this->db->update('projects_gallery', $data);
/*if(!empty($files)){
$extension = explode('/', $_FILES["image"]["type"]);
$newfilename = '';
$allowedExts = array("gif", "jpeg", "jpg", "png");
if (($_FILES["image"]["size"] < 2000000) && in_array($extension['1'], $allowedExts)) {
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/gallery/";
$newfilename = time().rand().".".$extension['1'];
if(move_uploaded_file($_FILES["image"]["tmp_name"], $path.$newfilename)){
$data_image = array('image'=>$newfilename);
$this->db->where('id', $id);
$query = $this->db->update('projects_gallery', $data_image);
}
}else{
echo "some error occured";
}
}*/
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_project_gallery_image($image_id){
$this->db->where('id', $image_id);
$query = $this->db->get('projects_gallery')->row_array();
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."/uploads/gallery/";
unlink($path.$query['image']);
$this->db->where('id', $image_id);
$this->db->delete('projects_gallery');
return $query;
}
public function change_status_project_gallery($id,$status){
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('projects_gallery', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function show_projects_video_list($project_id){
$this->db->where('project_id',$project_id);
$this->db->order_by("id","desc");
$query = $this->db->get('projects_video')->result_array();
return $query;
}
public function checkDuplicate_project_video($highlight_name){
$highlight_name = strtolower($highlight_name);
$this->db->where('name', $highlight_name);
$query = $this->db->get('projects_video')->row_array();
return $query['id'];
}
public function add_project_video($data){
$query = $this->db->insert('projects_video', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function update_project_video($id,$data){
$this->db->where('id',$id);
$query = $this->db->update('projects_video', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function getSingle_project_video($project_id,$id){
$this->db->where('project_id', $project_id);
$this->db->where('id', $id);
$query = $this->db->get('projects_video')->row_array();
return $query;
}
public function delete_project_video($highlights_id){
/*$q1 = "select thumb_img from projects_video where id = '".$highlights_id."'";
$rz1 = $this->db->query($q1)->row_array();
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/video_thumb/";
if(unlink($path.$rz1['thumb_img'])){
$this->db->where('id', $highlights_id);
$this->db->delete('projects_video');
return $query;
}*/
$this->db->where('id', $highlights_id);
$this->db->delete('projects_video');
return $query;
}
public function show_projects_banners_list($project_id){
$this->db->where('project_id', $project_id);
$this->db->order_by("id","desc");
$query = $this->db->get('projects_banners')->result_array();
return $query;
}
public function checkDuplicate_project_banner_name($project_banner_name, $project_id){
$project_banner_name = strtolower($project_banner_name);
$this->db->where('name', $project_banner_name);
$this->db->where('project_id', $project_id);
$query = $this->db->get('projects_banners')->row_array();
return $query['id'];
}
public function add_project_banner($data){
$query = $this->db->insert('projects_banners', $data);
$insert_id = $this->db->insert_id();
/*$extension = explode('/', $_FILES["image"]["type"]);
if(isset($insert_id)){
$newfilename = '';
$allowedExts = array("gif", "jpeg", "jpg", "png");
if (($_FILES["image"]["size"] < 2000000) && in_array($extension['1'], $allowedExts))
{
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/banners/";
$newfilename = time().rand().".".$extension['1'];
if(move_uploaded_file($_FILES["image"]["tmp_name"], $path.$newfilename)){
$data_image = array('image'=>$newfilename);
$this->db->where('id', $insert_id);
$query = $this->db->update('projects_banners', $data_image);
}
}else{
echo "some error occured";
}
}*/
return $insert_id;
}
public function update_project_banner($id,$data){
$this->db->where('id',$id);
$query = $this->db->update('projects_banners', $data);
/*if(!empty($files)){
$extension = explode('/', $_FILES["image"]["type"]);
$newfilename = '';
$allowedExts = array("gif", "jpeg", "jpg", "png");
if (($_FILES["image"]["size"] < 2000000) && in_array($extension['1'], $allowedExts)) {
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/floor_plan/";
$newfilename = time().rand().".".$extension['1'];
if(move_uploaded_file($_FILES["image"]["tmp_name"], $path.$newfilename)){
$data_image = array('image'=>$newfilename);
$this->db->where('id', $id);
$query = $this->db->update('projects_banners', $data_image);
}
}else{
echo "some error occured";
}
}*/
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function getSingle_project_banner($project_id,$id){
$this->db->where('project_id', $project_id);
$this->db->where('id', $id);
$query = $this->db->get('projects_banners')->row_array();
return $query;
}
public function delete_project_banner($image_id){
$this->db->where('id', $image_id);
$query = $this->db->get('projects_banners')->row_array();
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."/uploads/banners/";
if(!empty($query['image']) && !empty($query['mobile_banner'])){
unlink($path.$query['image']);
unlink($path.$query['mobile_banner']);
}
$this->db->where('id', $image_id);
$this->db->delete('projects_banners');
return $query;
}
public function change_status_project_banner($id,$status){
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('projects_banners', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function show_home_banners_list(){
$this->db->order_by("id","desc");
$query = $this->db->get('home_page_banners')->result_array();
return $query;
}
public function get_particular_projects($project_type){
$this->db->where('project_type', $project_type);
$this->db->where('status', '1');
$query = $this->db->get('projects')->result_array();
return $query;
}
public function add_home_banner($data){
$query = $this->db->insert('home_page_banners', $data);
$insert_id = $this->db->insert_id();
/*$extension = explode('/', $_FILES["image"]["type"]);
if(isset($insert_id)){
$newfilename = '';
$allowedExts = array("gif", "jpeg", "jpg", "png");
if (($_FILES["image"]["size"] < 2000000) && in_array($extension['1'], $allowedExts))
{
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/home_page/";
$newfilename = time().rand().".".$extension['1'];
if(move_uploaded_file($_FILES["image"]["tmp_name"], $path.$newfilename)){
$data_image = array('image'=>$newfilename);
$this->db->where('id', $insert_id);
$query = $this->db->update('home_page_banners', $data_image);
}
}else{
echo "some error occured";
}
}*/
return $insert_id;
}
public function change_status_home_banner($id,$status){
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('home_page_banners', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function getSingle_home_banner($id){
$this->db->select('home_page_banners.*,projects.name as project_name,projects.project_type');
$this->db->from('home_page_banners');
$this->db->join('projects', 'home_page_banners.project_id = projects.id', 'inner');
$this->db->where('home_page_banners.id',$id);
$query = $this->db->get();
return $query->row_array();
}
public function update_home_banner($id,$data){
$this->db->where('id',$id);
$query = $this->db->update('home_page_banners', $data);
/*if(!empty($files)){
$extension = explode('/', $_FILES["image"]["type"]);
$newfilename = '';
$allowedExts = array("gif", "jpeg", "jpg", "png");
if (($_FILES["image"]["size"] < 2000000) && in_array($extension['1'], $allowedExts)) {
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/home_page/";
$newfilename = time().rand().".".$extension['1'];
if(move_uploaded_file($_FILES["image"]["tmp_name"], $path.$newfilename)){
$data_image = array('image'=>$newfilename);
$this->db->where('id', $id);
$query = $this->db->update('home_page_banners', $data_image);
}
}else{
echo "some error occured";
}
}*/
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_home_banner($banner_id){
$this->db->where('id', $banner_id);
$query = $this->db->get('home_page_banners')->row_array();
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/home_page/";
if(!empty($query['image']) && !empty($query['mobile_banner'])){
unlink($path.$query['image']);
unlink($path.$query['mobile_banner']);
}
$this->db->where('id', $banner_id);
$this->db->delete('home_page_banners');
return $query;
}
public function show_schedule_visitors(){
$this->db->order_by("id","desc");
$query = $this->db->get('schedule_visit')->result_array();
return $query;
}
public function show_job_openings(){
$this->db->order_by("id","desc");
$query = $this->db->get('jobs')->result_array();
return $query;
}
public function getSingle_job($id){
$this->db->where('id', $id);
$query = $this->db->get('jobs')->row_array();
return $query;
}
public function checkDuplicate_job($position_name){
$position_name = strtolower($position_name);
$this->db->where('position', $position_name);
$query = $this->db->get('jobs')->row_array();
return $query['id'];
}
public function add_job($data){
$query = $this->db->insert('jobs', $data);
$insert_id = $this->db->insert_id();
}
public function delete_job_opening($id){
$this->db->where('id', $id);
$this->db->delete('jobs');
return $query;
}
public function update_job($id,$data){
$this->db->where('id',$id);
$this->db->update('jobs', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function change_status_job_opening($id,$status){
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('jobs', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function show_partners(){
$this->db->order_by("id","desc");
$query = $this->db->get('partner_with_us')->result_array();
return $query;
}
public function show_partner_details($id){
$this->db->where('id',$id);
$this->db->order_by("id","desc");
$query = $this->db->get('partner_with_us')->row_array();
return $query;
}
public function get_partner_file($id){
$this->db->where('id',$id);
$this->db->order_by("id","desc");
$query = $this->db->get('partner_with_us')->row_array();
return $query;
}
public function check_mime($temp_name){
$finfo = finfo_open(FILEINFO_MIME_TYPE);
$type = finfo_file($finfo, $temp_name);
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 list_awards(){
$this->db->order_by("rank_order","asc");
$query = $this->db->get('awards')->result_array();
return $query;
}
public function checkDuplicate_award($award_name){
$award_name = strtolower($award_name);
$this->db->where('name', $award_name);
$query = $this->db->get('awards')->row_array();
return $query['id'];
}
public function add_award($data,$files){
$query = $this->db->insert('awards', $data);
$insert_id = $this->db->insert_id();
if(isset($insert_id)){
$extension = explode('.', $_FILES["image"]["name"]);
$newfilename = '';
$allowedExts = array("gif", "jpeg", "jpg","JPG","PNG", "png");
if (($_FILES["image"]["size"] < 2000000) && in_array($extension[1], $allowedExts))
{
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/awards/"; //echo $path;exit;
$newfilename = time().rand().".".$extension[1];
$newfilename = str_replace(' ', '_', $newfilename);
if(move_uploaded_file($_FILES["image"]["tmp_name"], $path.$newfilename)){
$data_image = array('image'=>$newfilename);
$this->db->where('id', $insert_id);
$query = $this->db->update('awards', $data_image);
}
}else{
echo "some error occured";
}
}
return $insert_id;
}
public function update_award($id, $data,$files){
$this->db->where('id',$id);
$query = $this->db->update('awards', $data);
if(!empty($files)){
$extension = explode('.', $_FILES["image"]["name"]);
$newfilename = '';
$allowedExts = array("gif", "jpeg", "jpg","JPG","PNG", "png");
// print_r($files);exit;
if (($_FILES["image"]["size"] < 2000000) && in_array($extension[1], $allowedExts)) {
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/awards/";
// echo $path;exit;
$newfilename = time().rand().".".$extension[1];
$newfilename = str_replace(' ', '_', $newfilename);
if(move_uploaded_file($_FILES["image"]["tmp_name"], $path.$newfilename)){
$data_image = array('image'=>$newfilename);
$this->db->where('id', $id);
$query = $this->db->update('awards', $data_image);
}
}else{
echo "some error occured";
}
}
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_award($award_id){
$this->db->where('id', $award_id);
$query = $this->db->get('awards')->row_array();
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/awards/";
unlink($path.$query['image']);
$this->db->where('id', $award_id);
$this->db->delete('awards');
return $query;
}
public function get_award_info($id){
$this->db->where('id',$id);
$result = $this->db->get('awards')->row_array();
return $result;
}
public function change_status_awards($id,$status){
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('awards', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function show_press_release_list(){
return $this->db->get("press_release")->result_array();
}
public function getSinglePressRelease($id){
return $this->db->get_where("press_release",array("id" => $id))->row_array();
}
public function update_press_release($id, $data, $files){
if($files['image']['name'] != ''){
$filename = $files['image']['name'];
$extension = pathinfo($filename, PATHINFO_EXTENSION);
$newfilename = rand().time().'.'.$extension;
$newfilename = str_replace(' ', '_', $newfilename);
$path = $_SERVER["DOCUMENT_ROOT"].FOLDER_NAME.'/uploads/press_release/';
move_uploaded_file($files['image']['tmp_name'], $path.$newfilename);
$data['image'] = $newfilename;
}
$this->db->where('id',$id);
$this->db->update('press_release', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function insert_press_release($data,$files){
// echo $files['image']['name'];exit;
if($files['image']['name'] != ''){
$filename = $files['image']['name'];
$extension = pathinfo($filename, PATHINFO_EXTENSION);
$newfilename = rand().time().'.'.$extension;
$newfilename = str_replace(' ', '_', $newfilename);
$path = $_SERVER["DOCUMENT_ROOT"].FOLDER_NAME.'/uploads/press_release/';
move_uploaded_file($files['image']['tmp_name'], $path.$newfilename);
$data['image'] = $newfilename;
}
$query = $this->db->insert('press_release', $data);
$insert_id = $this->db->insert_id();
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function change_press_release_status($id,$status){
$data= array('is_active'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('press_release', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_press_release($id){
$res = $this->db->get_where("press_release",array("id" => $id))->row_array();
if($res['image'] != ''){
unlink($_SERVER["DOCUMENT_ROOT"].FOLDER_NAME.'/uploads/press_release/'.$res['image']);
}
$this->db->where('id', $id);
return $this->db->delete("press_release");
}
public function show_events_and_updates_list(){
return $this->db->get("events_updates")->result_array();
}
public function update_video_gallery($id,$data){
$this->db->where('id',$id);
$this->db->update('video_gallery', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function add_video_gallery($data){
return $this->db->insert('video_gallery', $data);
}
public function getSingle_videoGallery($id){
return $this->db->get_where("video_gallery",array("id" => $id))->row_array();
}
public function change_status_video_gallery($id,$status){
$data= array('is_active'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('video_gallery', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_video_gallery($id){
$this->db->where('id', $id);
return $this->db->delete("video_gallery");
}
public function show_news_list(){
$q1 = "select n.*, p.name project_name from news n left outer join projects p on n.project_id=p.id order by n.id";
//$this->db->order_by("id","desc");
return $this->db->query($q1)->result_array();
}
public function project_list_for_news(){
$q1 = "select id project_id, name project_name from projects order by name";
return $this->db->query($q1)->result_array();
}
public function add_news($data,$files){
//echo $files['image']['name'];exit;
if($files['image']['name'] != ''){
$filename = $files['image']['name'];
$extension = pathinfo($filename, PATHINFO_EXTENSION);
$newfilename = rand().time().'.'.$extension;
$newfilename = str_replace(' ', '_', $newfilename);
$path = $_SERVER["DOCUMENT_ROOT"].FOLDER_NAME.'uploads/news/';
// echo $path;exit;
move_uploaded_file($files['image']['tmp_name'], $path.$newfilename);
$data['image'] = $newfilename;
}
if($files['document']['name'] != ''){
$filename = $files['document']['name'];
$extension = pathinfo($filename, PATHINFO_EXTENSION);
$newfilename = rand().time().'.'.$extension;
$newfilename = str_replace(' ', '_', $newfilename);
$path = $_SERVER["DOCUMENT_ROOT"].FOLDER_NAME.'uploads/news_document/';
// echo $path;exit;
move_uploaded_file($files['document']['tmp_name'], $path.$newfilename);
$data['document'] = $newfilename;
}
$query = $this->db->insert('news', $data);
$insert_id = $this->db->insert_id();
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function getSingle_News($id){
return $this->db->get_where("news",array("id" => $id))->row_array();
}
public function update_news($id, $data, $files){
if($files['image']['name'] != ''){
$filename = $files['image']['name'];
$extension = pathinfo($filename, PATHINFO_EXTENSION);
$newfilename = rand().time().'.'.$extension;
$newfilename = str_replace(' ', '_', $newfilename);
$path = $_SERVER["DOCUMENT_ROOT"].FOLDER_NAME.'uploads/news/';
// echo $path;exit;
move_uploaded_file($files['image']['tmp_name'], $path.$newfilename);
$data['image'] = $newfilename;
}
if($files['document']['name'] != ''){
$filename = $files['document']['name'];
$extension = pathinfo($filename, PATHINFO_EXTENSION);
$newfilename = rand().time().'.'.$extension;
$newfilename = str_replace(' ', '_', $newfilename);
$path = $_SERVER["DOCUMENT_ROOT"].FOLDER_NAME.'uploads/news_document/';
// echo $path;exit;
move_uploaded_file($files['document']['tmp_name'], $path.$newfilename);
$data['document'] = $newfilename;
}
$this->db->where('id',$id);
$this->db->update('news', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function show_media_kit_list(){
return $this->db->get("media_kit")->result_array();
}
public function getSingleMediaKit($id){
return $this->db->get_where("media_kit",array("id" => $id))->row_array();
}
public function update_media_kit($id, $data){
/*if($files['image']['name'] != ''){
$filename = $files['image']['name'];
$extension = pathinfo($filename, PATHINFO_EXTENSION);
$newfilename = rand().time().'.'.$extension;
$path = $_SERVER["DOCUMENT_ROOT"].FOLDER_NAME.'/uploads/media_kit/';
move_uploaded_file($files['image']['tmp_name'], $path.$newfilename);
$data['file_name'] = $newfilename;
}*/
$this->db->where('id',$id);
$this->db->update('media_kit', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function insert_media_kit($data){
// echo $files['image']['name'];exit;
/*if($files['image']['name'] != ''){
$filename = $files['image']['name'];
$extension = pathinfo($filename, PATHINFO_EXTENSION);
$newfilename = rand().time().'.'.$extension;
$path = $_SERVER["DOCUMENT_ROOT"].FOLDER_NAME.'/uploads/media_kit/';
move_uploaded_file($files['image']['tmp_name'], $path.$newfilename);
$data['file_name'] = $newfilename;
}*/
$query = $this->db->insert('media_kit', $data);
$insert_id = $this->db->insert_id();
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function change_media_kit_status($id,$status){
$data= array('is_active'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('media_kit', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_media_kit($id){
$res = $this->db->get_where("media_kit",array("id" => $id))->row_array();
if($res['image'] != ''){
unlink($_SERVER["DOCUMENT_ROOT"].FOLDER_NAME.'/uploads/media_kit/'.$res['image']);
}
$this->db->where('id', $id);
return $this->db->delete("media_kit");
}
public function show_project_construction_updates_list($project_id){
$this->db->where('project_id', $project_id);
$this->db->order_by("id","desc");
$query = $this->db->get('projects_construction_updates')->result_array();
return $query;
}
public function add_project_construction_updates($data){
$query = $this->db->insert('projects_construction_updates', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function getSingle_project_construction_updates($project_id,$id){
$this->db->where('project_id', $project_id);
$this->db->where('id', $id);
$query = $this->db->get('projects_construction_updates')->row_array();
return $query;
}
public function update_project_construction_updates($id,$data){
$this->db->where('id',$id);
$query = $this->db->update('projects_construction_updates', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_project_construction_updates($image_id){
$this->db->where('id', $image_id);
$query = $this->db->get('projects_construction_updates')->row_array();
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."/uploads/construction_updates/";
unlink($path.$query['image']);
$this->db->where('id', $image_id);
$this->db->delete('projects_construction_updates');
return $query;
}
public function change_status_project_construction_updates($id,$status){
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('projects_construction_updates', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
//
public function show_project_location_advantages_list($project_id){
$this->db->where('project_id', $project_id);
$this->db->order_by("id","desc");
$query = $this->db->get('projects_location_advantages')->result_array();
return $query;
}
public function add_project_location_advantages($data){
$query = $this->db->insert('projects_location_advantages', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function getSingle_project_location_advantages($project_id,$id){
$this->db->where('project_id', $project_id);
$this->db->where('id', $id);
$query = $this->db->get('projects_location_advantages')->row_array();
return $query;
}
public function update_project_location_advantages($id,$data){
$this->db->where('id',$id);
$query = $this->db->update('projects_location_advantages', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_project_location_advantages($image_id){
$this->db->where('id', $image_id);
$query = $this->db->get('projects_location_advantages')->row_array();
if(!empty($query['image'])){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."/uploads/location_advantages/";
unlink($path.$query['image']);
}
$this->db->where('id', $image_id);
$this->db->delete('projects_location_advantages');
return $query;
}
public function change_status_project_location_advantages($id,$status){
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('projects_location_advantages', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_magazine($id){
$this->db->where('id', $id);
$query = $this->db->delete('corporate_magazine');
return $query;
}
public function show_magazine_list(){
$this->db->order_by("id","desc");
$query = $this->db->get('corporate_magazine')->result_array();
return $query;
}
public function getSingle_magazine($id){
$this->db->where('id', $id);
$query = $this->db->get('corporate_magazine')->row_array();
return $query;
}
public function add_magazine($data,$files){
//echo $files['image']['name'];exit;
if($files['image']['name'] != ''){
$filename = $files['image']['name'];
$extension = pathinfo($filename, PATHINFO_EXTENSION);
$newfilename = rand().time().'.'.$extension;
$newfilename = str_replace(' ', '_', $newfilename);
$path = $_SERVER["DOCUMENT_ROOT"].FOLDER_NAME.'uploads/corporate_magazine/';
// echo $path;exit;
move_uploaded_file($files['image']['tmp_name'], $path.$newfilename);
$data['image'] = $newfilename;
}
if($files['document']['name'] != ''){
$filename = $files['document']['name'];
$extension = pathinfo($filename, PATHINFO_EXTENSION);
$newfilename = rand().time().'.'.$extension;
$newfilename = str_replace(' ', '_', $newfilename);
$path = $_SERVER["DOCUMENT_ROOT"].FOLDER_NAME.'uploads/corporate_magazine_document/';
// echo $path;exit;
move_uploaded_file($files['document']['tmp_name'], $path.$newfilename);
$data['document'] = $newfilename;
}
$query = $this->db->insert('corporate_magazine', $data);
$insert_id = $this->db->insert_id();
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function update_magazine($id, $data, $files){
if($files['image']['name'] != ''){
$filename = $files['image']['name'];
$extension = pathinfo($filename, PATHINFO_EXTENSION);
$newfilename = rand().time().'.'.$extension;
$newfilename = str_replace(' ', '_', $newfilename);
$path = $_SERVER["DOCUMENT_ROOT"].FOLDER_NAME.'uploads/corporate_magazine/';
// echo $path;exit;
move_uploaded_file($files['image']['tmp_name'], $path.$newfilename);
$data['image'] = $newfilename;
}
if($files['document']['name'] != ''){
$filename = $files['document']['name'];
$extension = pathinfo($filename, PATHINFO_EXTENSION);
$newfilename = rand().time().'.'.$extension;
$newfilename = str_replace(' ', '_', $newfilename);
$path = $_SERVER["DOCUMENT_ROOT"].FOLDER_NAME.'uploads/corporate_magazine_document/';
// echo $path;exit;
move_uploaded_file($files['document']['tmp_name'], $path.$newfilename);
$data['document'] = $newfilename;
}
$this->db->where('id',$id);
$this->db->update('corporate_magazine', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function show_project_brochure_list($project_id){
$this->db->where('project_id', $project_id);
$this->db->order_by("id","desc");
$query = $this->db->get('projects_brochures')->result_array();
return $query;
}
public function add_project_brochure($data){
$query = $this->db->insert('projects_brochures', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function getSingle_project_brochure($project_id,$id){
$this->db->where('project_id', $project_id);
$this->db->where('id', $id);
$query = $this->db->get('projects_brochures')->row_array();
return $query;
}
public function update_project_brochure($id,$data){
$this->db->where('id',$id);
$query = $this->db->update('projects_brochures', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_project_brochure($image_id){
$this->db->where('id', $image_id);
$query = $this->db->get('projects_brochures')->row_array();
if(!empty($query['image'])){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."/uploads/brochures/";
unlink($path.$query['image']);
}
$this->db->where('id', $image_id);
$this->db->delete('projects_brochures');
return $query;
}
public function change_status_project_brochure($id,$status){
if($status == 1){
$data1= array('status'=>0);
$this->db->update('projects_brochures', $data1);
}
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('projects_brochures', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
//
public function show_project_investment_list($project_id){
$this->db->where('project_id', $project_id);
$this->db->order_by("id","desc");
$query = $this->db->get('projects_investment')->result_array();
return $query;
}
public function add_project_investment($data){
$query = $this->db->insert('projects_investment', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function getSingle_project_investment($project_id,$id){
$this->db->where('project_id', $project_id);
$this->db->where('id', $id);
$query = $this->db->get('projects_investment')->row_array();
return $query;
}
public function update_project_investment($id,$data){
$this->db->where('id',$id);
$query = $this->db->update('projects_investment', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_project_investment($image_id){
$this->db->where('id', $image_id);
$query = $this->db->get('projects_investment')->row_array();
if(!empty($query['image'])){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."/uploads/investment_opportunity/";
unlink($path.$query['image']);
}
$this->db->where('id', $image_id);
$this->db->delete('projects_investment');
return $query;
}
public function change_status_project_investment($id,$status){
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('projects_investment', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function change_status_news($id,$status){
$data= array('is_active'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('news', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_news($id){
$this->db->where('id', $id);
$query = $this->db->get('news')->row_array();
if(!empty($query['image'])){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."/uploads/news/";
unlink($path.$query['image']);
}
$this->db->where('id', $id);
$this->db->delete('news');
return $query;
}
public function get_location_on_property_type($property_type){
$this->db->order_by('id','desc');
$this->db->where('project_type',$property_type);
$result= $this->db->get('property')->result_array();
return $result;
}
//
public function show_project_amenities_list($project_id){
$this->db->where('project_id', $project_id);
$this->db->order_by("id","desc");
$query = $this->db->get('project_amenities')->result_array();
return $query;
}
public function add_project_amenities($data){
$query = $this->db->insert('project_amenities', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function getSingle_project_amenities($project_id,$id){
$this->db->where('project_id', $project_id);
$this->db->where('id', $id);
$query = $this->db->get('project_amenities')->row_array();
return $query;
}
public function update_project_amenities($id,$data){
$this->db->where('id',$id);
$query = $this->db->update('project_amenities', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_project_amenities($image_id){
$this->db->where('id', $image_id);
$query = $this->db->get('project_amenities')->row_array();
if(!empty($query['image'])){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."/uploads/amenities/";
unlink($path.$query['image']);
}
$this->db->where('id', $image_id);
$this->db->delete('project_amenities');
return $query;
}
public function change_status_project_amenities($id,$status){
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('project_amenities', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function save_amenity_description($project_id,$data){
$this->db->where('project_id', $project_id);
$query = $this->db->get('project_key_amenities_desc')->row_array();
if(!empty($query)){
$this->db->where('project_id',$project_id);
$query = $this->db->update('project_key_amenities_desc', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}else{
$query = $this->db->insert('project_key_amenities_desc', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
}
public function show_project_key_desc_amenities($project_id){
$this->db->where('project_id', $project_id);
$query = $this->db->get('project_key_amenities_desc')->row_array();
return $query;
}
//
public function show_newsletter_list(){
$this->db->order_by("id","desc");
$query = $this->db->get('newsletters')->result_array();
return $query;
}
public function add_newsletter($data){
$query = $this->db->insert('newsletters', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function change_status_newsletter($id,$status){
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('newsletters', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function getSingle_newsletter($id){
$this->db->where('id', $id);
$query = $this->db->get('newsletters')->row_array();
return $query;
}
public function update_newsletter($id,$data){
$this->db->where('id',$id);
$query = $this->db->update('newsletters', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_newsletter($banner_id){
$this->db->where('id', $banner_id);
$query = $this->db->get('newsletters')->row_array();
if(!empty($query['image'])){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/newsletters/";
unlink($path.$query['image']);
}
$this->db->where('id', $banner_id);
$this->db->delete('newsletters');
return $query;
}
public function show_contact_enquiry(){
$this->db->order_by("id","desc");
$query = $this->db->get('contact_enquiries')->result_array();
return $query;
}
public function delete_contact_enquiry($id){
$this->db->where('id', $id);
$query = $this->db->delete('contact_enquiries');
return $query;
}
public function show_vendor_registrations(){
$this->db->order_by("id","desc");
$query = $this->db->get('vendor_enquiries')->result_array();
return $query;
}
public function delete_vendor_enquiry($id){
$this->db->where('id', $id);
$query = $this->db->delete('vendor_enquiries');
return $query;
}
//
public function show_event_category_list(){
$this->db->order_by("id","desc");
$query = $this->db->get('event_category')->result_array();
return $query;
}
public function add_event_category($data){
$query = $this->db->insert('event_category', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function getSingle_event_category($id){
$this->db->where('id',$id);
$query = $this->db->get('event_category')->row_array();
return $query;
}
public function update_event_category($id,$data){
$this->db->where('id',$id);
$query = $this->db->update('event_category', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_event_category($banner_id){
$this->db->where('id', $banner_id);
$this->db->delete('event_category');
$this->db->where('category_id', $banner_id);
$query = $this->db->delete('event_gallery');
return $query;
}
//
public function show_event_gallery_list(){
$q1 = "select g.*,c.name event_name from event_gallery g inner join event_category c on g.category_id=c.id order by g.id desc";
$query = $this->db->query($q1)->result_array();
return $query;
}
public function add_event_gallery($data){
$query = $this->db->insert('event_gallery', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function getSingle_event_gallery($id){
$q2 = "select g.*,c.name event_name from event_gallery g inner join event_category c on g.category_id=c.id where g.id='$id'";
$query = $this->db->query($q2)->row_array();
return $query;
}
public function update_event_gallery($id,$data){
$this->db->where('id',$id);
$query = $this->db->update('event_gallery', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_event_gallery($banner_id){
$this->db->where('id', $banner_id);
$query = $this->db->get('event_gallery')->row_array();
if(!empty($query['image'])){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/event_gallery/";
unlink($path.$query['image']);
}
$this->db->where('id', $banner_id);
$this->db->delete('event_gallery');
return $query;
}
public function change_default_status_event_gallery($id,$category_id,$status){
if($status == 1){
$data1= array('default_status'=>'0');
$this->db->where('category_id', $category_id);
$this->db->update('event_gallery', $data1);
}
//return true;
$data= array('default_status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('event_gallery', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
//testimonials
public function show_testimonials_list(){
$this->db->order_by("id","desc");
$query = $this->db->get('testimonials')->result_array();
return $query;
}
public function add_testimonials($data){
$query = $this->db->insert('testimonials', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function getSingle_testimonials($id){
$this->db->where('id',$id);
$query = $this->db->get('testimonials')->row_array();
return $query;
}
public function update_testimonials($id,$data){
$this->db->where('id',$id);
$query = $this->db->update('testimonials', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_testimonials($banner_id){
$this->db->where('id', $banner_id);
$query = $this->db->get('testimonials')->row_array();
if(!empty($query['image'])){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/testimonials/";
unlink($path.$query['image']);
}
$this->db->where('id', $banner_id);
$this->db->delete('testimonials');
return $query;
}
public function change_status_testimonials($id,$status){
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('testimonials', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function show_mbassy_enquiries(){
$this->db->order_by("id","desc");
$query = $this->db->get('mbassy_enquiry')->result_array();
return $query;
}
public function show_upcoming_project_enquiries(){
$this->db->order_by("id","desc");
$query = $this->db->get('saved_upcoming_project_form')->result_array();
return $query;
}
public function delete_upcoming_project_enquiry($id){
$this->db->where('id', $id);
$query = $this->db->delete('saved_upcoming_project_form');
return $query;
}
public function getSingle_channel_partner_enquiries($id){
$this->db->where('id',$id);
$query = $this->db->get('channel-partner')->row_array();
return $query;
}
public function delete_channel_partner_enquiry($id){
$this->db->where('id', $id);
$query = $this->db->delete('channel-partner');
return $query;
}
public function getSingle_mbassy_enquiries($id){
$this->db->where('id',$id);
$query = $this->db->get('mbassy_enquiry')->row_array();
return $query;
}
public function delete_embassy_enquiry($id){
$this->db->where('id', $id);
$query = $this->db->delete('mbassy_enquiry');
return $query;
}
public function list_channel_partner_enquiries(){
$this->db->order_by("id","desc");
$query = $this->db->get('channel-partner')->result_array();
return $query;
}
public function getSingle_channel_partner_enquiery($id){
$this->db->where('id',$id);
$query = $this->db->get('channel-partner')->row_array();
return $query;
}
public function delete_channel_partner_enquiery($id){
$this->db->where('id', $id);
$query = $this->db->get('channel-partner')->row_array();
if(!empty($query['pan_card'])){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/pan_card/";
unlink($path.$query['pan_card']);
}
if(!empty($query['adhar_card'])){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/adhar_card/";
unlink($path.$query['adhar_card']);
}
$this->db->where('id', $id);
$query = $this->db->delete('channel-partner');
return $query;
}
public function getLeads($start_date=Null,$end_date=Null,$all=Null) {
if($start_date!=$end_date and $start_date < $end_date and $start_date!=Null && $end_date!=Null){
$sql = "select * from `channel-partner` where created_date between '".$start_date." 00:00:00' AND '".$end_date." 12:59:59' order by id desc ";
}else if($start_date==$end_date and $start_date!=Null && $end_date!=Null){
$sql = "select * from `channel-partner` where created_date between '".$start_date." 00:00:00' AND '".$end_date." 12:59:59' order by id desc";
}else{
$sql = "select * from `channel-partner` where created_date order by id desc";
}
return $this->db->query($sql)->result();
}
/*code added by Aparna to list out sample flat images - starts here*/
public function show_sampleflat_list($project_id)
{
$this->db->where('project_id', $project_id);
$this->db->order_by("id","desc");
$query = $this->db->get('projects_sample_flat')->result_array();
return $query;
}
public function getSingle_project_sampleflat_image($project_id,$id){
$this->db->where('project_id', $project_id);
$this->db->where('id', $id);
$query = $this->db->get('projects_sample_flat')->row_array();
return $query;
}
public function add_sample_flat_image($data){
$query = $this->db->insert('projects_sample_flat', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function update_sample_flat_image($id,$data){
$this->db->where('id',$id);
$query = $this->db->update('projects_sample_flat', $data);
if(!empty($files)){
$extension = explode('/', $_FILES["image"]["type"]);
$newfilename = '';
$allowedExts = array("gif", "jpeg", "jpg", "png");
if (($_FILES["image"]["size"] < 2000000) && in_array($extension['1'], $allowedExts)) {
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/sample_flat/";
$newfilename = time().rand().".".$extension['1'];
if(move_uploaded_file($_FILES["image"]["tmp_name"], $path.$newfilename)){
$data_image = array('image'=>$newfilename);
$this->db->where('id', $id);
$query = $this->db->update('projects_sample_flat', $data_image);
}
}else{
echo "some error occured";
}
}
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function change_status_sample_flats($id,$status){
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('projects_sample_flat', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_project_sample_flat($image_id){
$this->db->where('id', $image_id);
$query = $this->db->get('projects_sample_flat')->row_array();
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."/uploads/sample_flat/";
unlink($path.$query['image']);
$this->db->where('id', $image_id);
$this->db->delete('projects_sample_flat');
return $query;
}
/*code added by Aparna to list out sample flat images - ends here*/
/*---------Manage InfoGraphic-----------*/
public function show_infograpics_list()
{
return $this->db->get("tbl_infographics")->result_array();
}
public function change_status_infographic($id,$status){
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('tbl_infographics', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function delete_infographic($info_id)
{
$this->db->where('id', $info_id);
$query = $this->db->delete('tbl_infographics');
return $query;
}
public function get_infographic_info($id){
$this->db->where('id',$id);
$result = $this->db->get('tbl_infographics')->row_array();
return $result;
}
public function update_infographic($id,$data,$files){
if(!empty($files)){
$newfilename = '';
// $newfilename2 = '';
$allowedExts = array("gif", "jpeg", "jpg", "png");
$allowedExts1 = array("mp4", "flv", "wmv");
if($files['image']['name'] != ''){
$extension1 = explode('/', $_FILES["image"]["type"]);
if (($_FILES["image"]["size"] < 2000000) && in_array($extension1[1], $allowedExts))
{
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/infographic/image/";
$newfilename = time().rand().".".$extension1[1];
$newfilename = str_replace(' ', '_', $newfilename);
if(move_uploaded_file($_FILES["image"]["tmp_name"], $path . $newfilename)){
$data_image = array('image'=>$newfilename);
$this->db->where('id', $id);
$query = $this->db->update('tbl_infographics', $data_image);
}
}else{
echo "some error occured";
}
}
//
if($files['video_file']['name'] != ''){
$extension1 = explode('/', $_FILES["video_file"]["type"]);
if (($_FILES["video_file"]["size"] > 2000000) && in_array($extension1[1], $allowedExts1))
{
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/infographic/video/";
$newfilename = time().rand().".".$extension1[1];
$newfilename = str_replace(' ', '_', $newfilename);
if(move_uploaded_file($_FILES["video_file"]["tmp_name"], $path . $newfilename)){
$data_image = array('video_file'=>$newfilename);
$this->db->where('id', $id);
$query = $this->db->update('tbl_infographics', $data_image);
}
}else{
echo "some error occured";
}
}
//
if($files['list_image']['name'] != ''){
$extension = explode('/', $_FILES["list_image"]["type"]);
if (($_FILES["list_image"]["size"] < 2000000) && in_array($extension[1], $allowedExts)){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/infographic/list/";
echo $path;
$newfilename1 = time().rand().".".$extension[1];
$newfilename1 = str_replace(' ', '_', $newfilename1);
if(move_uploaded_file($_FILES["list_image"]["tmp_name"], $path.$newfilename1)){
$data_image1 = array('list_image'=>$newfilename1);
$this->db->where('id', $id);
$query1 = $this->db->update('tbl_infographics', $data_image1);
}
}else{
echo "some error occured";
}
}
// video image
if($files['video_image']['name'] != ''){
$extension = explode('/', $_FILES["video_image"]["type"]);
if (($_FILES["video_image"]["size"] < 2000000) && in_array($extension[1], $allowedExts)){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/infographic/video_image/";
echo $path;
$newfilename1 = time().rand().".".$extension[1];
$newfilename1 = str_replace(' ', '_', $newfilename1);
if(move_uploaded_file($_FILES["video_image"]["tmp_name"], $path.$newfilename1)){
$data_image1 = array('video_image'=>$newfilename1);
$this->db->where('id', $id);
$query1 = $this->db->update('tbl_infographics', $data_image1);
}
}else{
echo "some error occured";
}
}
}
$this->db->where('id',$id);
$this->db->update('tbl_infographics', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function insert_infographic($data,$files){
//echo $files['video_file']['name'];exit;
$query = $this->db->insert('tbl_infographics', $data);
$insert_id = $this->db->insert_id();
$extension = explode('/', $_FILES["image"]["type"]);
$extension1 = explode('/', $_FILES["list_image"]["type"]);
$extension2 = explode('/', $_FILES["video_file"]["type"]);
if(isset($insert_id)){
$newfilename = '';
$newfilename1 = '';
$newfilename2 = '';
$allowedExts = array("gif", "jpeg", "jpg", "png");
$allowedExts1 = array("mp4", "flv", "wmv");
// list video
if (($_FILES["list_image"]["size"] < 2000000) && in_array($extension1['1'], $allowedExts)){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/infographic/list/";
$newfilename1 = time().rand().".".$extension1['1'];
$newfilename1 = str_replace(' ', '_', $newfilename1);
if(move_uploaded_file($_FILES["list_image"]["tmp_name"], $path.$newfilename1)){
$data_image1 = array('list_image'=>$newfilename1);
$this->db->where('id', $insert_id);
$query1 = $this->db->update('tbl_infographics', $data_image1);
}
}
///video image
if (($_FILES["video_image"]["size"] < 2000000) && in_array($extension1['1'], $allowedExts)){
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/infographic/video_image/";
$newfilename1 = time().rand().".".$extension1['1'];
$newfilename1 = str_replace(' ', '_', $newfilename1);
if(move_uploaded_file($_FILES["video_image"]["tmp_name"], $path.$newfilename1)){
$data_image1 = array('video_image'=>$newfilename1);
$this->db->where('id', $insert_id);
$query1 = $this->db->update('tbl_infographics', $data_image1);
}
}
/// infographic image
if (($_FILES["image"]["size"] < 2000000) && in_array($extension['1'], $allowedExts))
{
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/infographic/image/";
$newfilename = time().rand().".".$extension['1'];
$newfilename = str_replace(' ', '_', $newfilename);
if(move_uploaded_file($_FILES["image"]["tmp_name"], $path.$newfilename)){
$data_image = array('image'=>$newfilename);
$this->db->where('id', $insert_id);
$query = $this->db->update('tbl_infographics', $data_image);
}
}
// uploaded video
if (($_FILES["video_file"]["size"] > 2000000) && in_array($extension2['1'], $allowedExts1))
{
$path = $_SERVER['DOCUMENT_ROOT'].FOLDER_NAME."uploads/infographic/video/";
$newfilename2 = time().rand().".".$extension2['1'];
$newfilename2 = str_replace(' ', '_', $newfilename2);
if(move_uploaded_file($_FILES["video_file"]["tmp_name"], $path.$newfilename2)){
$data_image = array('video_file'=>$newfilename2);
$this->db->where('id', $insert_id);
$query = $this->db->update('tbl_infographics', $data_image);
}
}
else{
echo "some error occured";
}
}
return $insert_id;
}
/*--------------------*/
/*---------floor plan enquiries-----------*/
public function show_floor_pln_enquiry(){
$this->db->order_by("id","desc");
$query = $this->db->get('floor_plan_enquiry')->result_array();
return $query;
}
public function delete_floor_plan_enquiry($id){
$this->db->where('id', $id);
$query = $this->db->delete('floor_plan_enquiry');
return $query;
}
public function show_floor_plan_enquiry(){
$this->db->order_by("id","desc");
$query = $this->db->get('floor_plan_enquiry')->result_array();
return $query;
}
// Show REel video link
public function show_project_showreel_link($project_id){
$this->db->where('project_id', $project_id);
$this->db->order_by("id","desc");
$query = $this->db->get('project_showreel_video')->result_array();
return $query;
}
public function change_status_project_showreel($id,$status){
$data= array('status'=>$status);
$this->db->where('id',$id);
$query = $this->db->update('project_showreel_video', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function getSingle_project_showreel($project_id,$id){
$this->db->where('project_id', $project_id);
$this->db->where('id', $id);
$query = $this->db->get('project_showreel_video')->row_array();
return $query;
}
public function delete_project_showreel($image_id){
// $this->db->where('id', $image_id);
// $query = $this->db->get('project_showreel_video')->row_array();
$this->db->where('id', $image_id);
$this->db->delete('project_showreel_video');
return $query;
}
public function add_project_showreel($data){
$query = $this->db->insert('project_showreel_video', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function update_project_showreel($id,$data){
$this->db->where('id',$id);
$this->db->update('project_showreel_video', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function getSingle_project_enquire_image($project_id){
$this->db->where('project_id', $project_id);
$query = $this->db->get('project_enquire_image')->row_array();
return $query;
}
public function add_project_enquire_image($data){
$query = $this->db->insert('project_enquire_image', $data);
$insert_id = $this->db->insert_id();
return $insert_id;
}
public function update_project_enquire_image($id,$data){
$this->db->where('id',$id);
$this->db->update('project_enquire_image', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
}
........