ikan Uploader :
Directory : /var/www/vhosts/omkar.com/httpdocs/application/models/
Upload File : |
| Current File : /var/www/vhosts/omkar.com/httpdocs/application/models/Amenities_model.php |
<?php
class Amenities_model extends CI_Model {
public function __construct() {
parent::__construct();
}
public function show_list(){
$this->db->order_by("id","desc");
$query = $this->db->get('projects')->result_array();
return $query;
}
public function checkDuplicate($client_name){
$name = strtolower($client_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('amenities', $data);
$insert_id = $this->db->insert_id();
if(isset($insert_id)){
$newfilename = '';
$allowedExts = array("gif", "jpeg", "jpg", "png");
foreach($_FILES["images"]["tmp_name"] as $key=>$tmp_name){
$temp= explode(".", $_FILES["images"]["name"][$key]);
$extension = $temp[1];
if ((($_FILES["images"]["type"][$key] == "image/gif")
|| ($_FILES["images"]["type"][$key] == "image/jpeg")
|| ($_FILES["images"]["type"][$key] == "image/jpg")
|| ($_FILES["images"]["type"][$key] == "image/pjpeg")
|| ($_FILES["images"]["type"][$key] == "image/x-png")
|| ($_FILES["images"]["type"][$key] == "image/png"))
&& ($_FILES["images"]["size"][$key] < 2000000)
&& in_array($extension, $allowedExts))
{
$path = $_SERVER['DOCUMENT_ROOT']."/uploads/amenities/";
$newfilename = time().rand().".".$extension;
if(move_uploaded_file($_FILES["images"]["tmp_name"][$key], $path . $newfilename)){
$data = array(
'id'=>$insert_id,
'name'=>$newfilename,
'created_on' => date('Y-m-d H:i:s'));
$query = $this->db->insert('amenities', $data);
}
}else{
echo "some error occured";
}
}
}
//return $insert_id;
}
public function getSingle($id){
$this->db->where('id', $id);
$query = $this->db->get('projects')->row_array();
return $query;
}
public function updated($id,$data,$files){
if(!empty($files)){
$newfilename = '';
$allowedExts = array("gif", "jpeg", "jpg", "png");
foreach($_FILES["images"]["tmp_name"] as $key=>$tmp_name){
$temp= explode(".", $_FILES["images"]["name"][$key]);
$extension = $temp[1];
if ((($_FILES["images"]["type"][$key] == "image/gif")
|| ($_FILES["images"]["type"][$key] == "image/jpeg")
|| ($_FILES["images"]["type"][$key] == "image/jpg")
|| ($_FILES["images"]["type"][$key] == "image/pjpeg")
|| ($_FILES["images"]["type"][$key] == "image/x-png")
|| ($_FILES["images"]["type"][$key] == "image/png"))
&& ($_FILES["images"]["size"][$key] < 2000000)
&& in_array($extension, $allowedExts))
{
$path = $_SERVER['DOCUMENT_ROOT']."/uploads/banners/";
$newfilename = time().rand().".".$extension;
if(move_uploaded_file($_FILES["images"]["tmp_name"][$key], $path . $newfilename)){
$data_image = array(
'project_id'=>$id,
'name'=>$newfilename,
'created_on' => date('Y-m-d H:i:s'));
$query = $this->db->insert('banners', $data_image);
}
}else{
echo "some error occured";
}
}
}
$this->db->where('id',$id);
$this->db->update('projects', $data);
$afftectedRows = $this->db->affected_rows();
return $afftectedRows;
}
public function getSingleImage($id){
$this->db->where('id', $id);
$query = $this->db->get('banners')->row_array();
return $query;
}
public function delete($id){
$this->db->where('project_id', $id);
$query = $this->db->get('banners')->result_array();
$path = $_SERVER['DOCUMENT_ROOT']."/uploads/banners/";
foreach ($query as $row) {
unlink($path.$row['name']);
$this->db->where('id',$row['id']);
$this->db->delete('banners');
}
$this->db->where('id', $id);
$this->db->delete('projects');
return $query;
}
public function image_update($id,$files){
if(!empty($files)){
$newfilename = '';
$allowedExts = array("gif", "jpeg", "jpg", "png");
//foreach($_FILES["images"]["tmp_name"] as $key=>$tmp_name){
$temp= explode(".", $_FILES["images"]["name"]);
$extension = $temp[1];
if ((($_FILES["images"]["type"] == "image/gif")
|| ($_FILES["images"]["type"] == "image/jpeg")
|| ($_FILES["images"]["type"] == "image/jpg")
|| ($_FILES["images"]["type"] == "image/pjpeg")
|| ($_FILES["images"]["type"] == "image/x-png")
|| ($_FILES["images"]["type"] == "image/png"))
&& ($_FILES["images"]["size"] < 2000000)
&& in_array($extension, $allowedExts))
{
$path = $_SERVER['DOCUMENT_ROOT']."/uploads/banners/";
$newfilename = time().rand().".".$extension;
if(move_uploaded_file($_FILES["images"]["tmp_name"], $path . $newfilename)){
$data_image = array('name'=>$newfilename);
$this->db->where('id',$id);
$query = $this->db->update('banners', $data_image);
}
}else{
echo "some error occured";
}
//}
$this->db->where('id', $id);
$query = $this->db->get('banners')->row_array();
return $query;
}
}
public function deleteSingleImage($id){
$this->db->where('id', $id);
$query = $this->db->get('banners')->row_array();
$path = $_SERVER['DOCUMENT_ROOT']."/uploads/banners/";
unlink($path.$query['name']);
$this->db->where('id', $id);
$this->db->delete('banners');
return $query;
}
}
........