ikan Uploader :
Directory : /var/www/html/shardawelfarefoundation.org/application/modules/admin/models/
Upload File : |
| Current File : /var/www/html/shardawelfarefoundation.org/application/modules/admin/models/Eventsgallery_model.php |
<?php
class Eventsgallery_model extends CI_Model
{
public function __construct()
{
parent::__construct();
}
/*
* Function : deleteRecords
* Description : Delete Record
*/
public function deleteRecords($id, $field_name= 'id', $tbl_name)
{
$this->db->where($field_name, $id);
$data = array();
$data = array('is_deleted'=> '1','status'=>'0', 'modifiedon'=>date('Y-m-d h:i:s'));
if (!$this->db->update($tbl_name, $data)) {
log_message('error', print_r($this->db->error(), true));
show_error(lang('database_error'));
}
}
/*
* Function : setGalleryRecords
*/
public function setGalleryRecords($post, $tbl_name='su_eventsgallery_albums')
{
if ($post['edit'] > 0)
{
if($post['photo_image']=='') { $post['photo_image'] = $post['old_image']; }
$this->db->where('id', $post['edit']);
unset($post['edit']);
unset($post['old_image']);
if (!$this->db->update($tbl_name, $post)) {
print_r($this->db->error());
log_message('error', print_r($this->db->error(), true));
show_error(lang('database_error'));
}
} else {
unset($post['edit']);
if (!$this->db->insert($tbl_name, $post)) {
print_r($this->db->error());
log_message('error', print_r($this->db->error(), true));
show_error(lang('database_error'));
}
}
}
/*
* Function : setRecords
*/
public function setRecordDetails($post, $tbl_name='su_eventsgallery_albums')
{
if ($post['edit'] > 0)
{
$this->db->where('id', $post['edit']);
unset($post['edit']);
unset($post['old_image']);
if (!$this->db->update($tbl_name, $post)) {
print_r($this->db->error());
log_message('error', print_r($this->db->error(), true));
show_error(lang('database_error'));
}
} else {
unset($post['edit']);
if (!$this->db->insert($tbl_name, $post)) {
print_r($this->db->error());
log_message('error', print_r($this->db->error(), true));
show_error(lang('database_error'));
}
}
}
/*
* Function : getRecords
*/
public function getRecords($id, $tbl_name='su_eventsgallery_albums')
{
$this->db->select('*');
$this->db->order_by('id', 'desc');
$this->db->where('is_deleted', '0');
if($id>0){
$this->db->where('id', $id);
}
$queryResult = $this->db->get($tbl_name);
if ($id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : getJoinRecords
*/
public function getJoinRecords($id=NULL)
{
$this->db->select('su_eventsgallery_albums.id,su_eventsgallery_albums.album_title, su_eventsgallery_albums.album_image,su_eventsgallery_albums.album_date,su_eventsgallery_albums.school_id, su_eventsgallery_albums.album_url, su_eventsgallery_albums.display_order, su_eventsgallery_albums.status,tbl_schools.school_name');
$this->db->where('su_eventsgallery_albums.is_deleted', '0');
if($id>0){
$this->db->where('su_eventsgallery_albums.id', $id);
}
$this->db->order_by('su_eventsgallery_albums.id', 'desc');
$this->db->join('tbl_schools', 'tbl_schools.id = su_eventsgallery_albums.school_id', 'left');
$queryResult = $this->db->get('su_eventsgallery_albums');
if ($id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : getGalleryRecords
*/
public function getGalleryRecords($id=NULL, $album_id=NULL, $limit=NULL, $page=NULL)
{
$this->db->select('su_eventsgallery_images.id,su_eventsgallery_images.photo_title, su_eventsgallery_images.photo_image, su_eventsgallery_images.display_order, su_eventsgallery_images.status, su_eventsgallery_albums.album_title');
$this->db->where('su_eventsgallery_images.is_deleted', '0');
if($id>0){
$this->db->where('su_eventsgallery_images.id', $id);
}
if($album_id>0) {
$this->db->where('su_eventsgallery_albums.id', $album_id);
}
$this->db->order_by('su_eventsgallery_images.id', 'desc');
$this->db->join('su_eventsgallery_albums', 'su_eventsgallery_albums.id = su_eventsgallery_images.album_id', 'left');
/*if($limit>0){
$this->db->limit($limit);
}
*/
$queryResult = $this->db->get('su_eventsgallery_images',$limit, $page);
if ($id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : ordersCount
*/
public function getCount($onlyNew = false)
{
if ($onlyNew == true) {
$this->db->where('viewed', 0);
}
return $this->db->count_all_results('orders');
}
/**
* This function is used to select data form table
*/
function getDataBy($tableName='', $value='', $colum='',$condition='') {
if((!empty($value)) && (!empty($colum))) {
$this->db->where($colum, $value);
}
$this->db->select('*');
$this->db->from($tableName);
$query = $this->db->get();
return $query->result_array();
}
}
Kontol Shell Bypass