ikan Uploader :
Directory : /var/www/html/agusttya.com/application/modules/admin/models/
Upload File : |
| Current File : /var/www/html/agusttya.com/application/modules/admin/models/Menu_model.php |
<?php
class Menu_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: setCourseDetails
* Description : set banner details
*/
function setBanners($post)
{
$post['banner_url'] = str_replace(' ','-',strtolower($post['banner_url'])); // Replace space with -
if ($post['edit'] > 0) {
$this->db->where('id', $post['edit']);
unset($post['edit']);
unset($post['id']);
if (!$this->db->update('su_banners', $post)) {
print_r($this->db->error());
log_message('error', print_r($this->db->error(), true));
show_error(lang('database_error'));
}
} else {
unset($post['edit']);
unset($post['id']);
if (!$this->db->insert('su_banners', $post)) {
print_r($this->db->error());
log_message('error', print_r($this->db->error(), true));
show_error(lang('database_error'));
}
}
}
/*
* Function : getSubmenuRecords
* Description : Get all submenu Items details
*/
function getSubmenuRecords( $submenu_id = NULL) {
$this->db->select('tbl_main_menu.menu_name, tbl_sub_menu.*');
$this->db->from('tbl_sub_menu');
$this->db->join('tbl_main_menu', 'tbl_main_menu.id = tbl_sub_menu.menu_id');
$this->db->order_by('tbl_sub_menu.display_order', 'asc');
$this->db->order_by('tbl_sub_menu.sub_menu_name', 'asc');
$this->db->where('tbl_sub_menu.is_deleted', '0');
if($submenu_id>0){
$this->db->where('tbl_sub_menu.id', $submenu_id);
}
$queryResult = $this->db->get();
if ($submenu_id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : setProgrammeRecords
* Description : Set Programme Items
*/
function setProgrammeRecords($post, $tbl_name = 'su_menu_programme')
{
$post['programme_url'] = str_replace(' ','-',strtolower($post['programme_url'])); // Replace space with -
if($post['programme_image']=='') { $post['programme_image'] = $post['old_image']; unset($post['old_image']); }
if ($post['edit'] > 0) {
$this->db->where('id', $post['edit']);
unset($post['edit']);
unset($post['id']);
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']);
unset($post['id']);
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 : getSubsubmenuRecords
*/
function getSubsubmenuRecords( $submenu_id = NULL) {
$this->db->select('tbl_main_menu.menu_name,tbl_sub_menu.sub_menu_name, tbl_sub_sub_menu.id,tbl_sub_sub_menu.sub_sub_menu_name,tbl_sub_sub_menu.display_name,tbl_sub_sub_menu.sub_sub_menu_url,tbl_sub_sub_menu.sub_menu_id, tbl_sub_sub_menu.display_order, tbl_sub_sub_menu.status');
$this->db->from('tbl_sub_sub_menu');
$this->db->join('tbl_main_menu', 'tbl_main_menu.id = tbl_sub_sub_menu.menu_id');
$this->db->join('tbl_sub_menu', 'tbl_sub_menu.id = tbl_sub_sub_menu.sub_menu_id' ,'LEFT');
$this->db->order_by('tbl_sub_sub_menu.display_order', 'asc');
$this->db->order_by('tbl_sub_sub_menu.sub_sub_menu_name', 'asc');
$this->db->where('tbl_sub_sub_menu.is_deleted', '0');
if($submenu_id>0){
$this->db->where('tbl_sub_sub_menu.id', $submenu_id);
}
$queryResult = $this->db->get();
if ($submenu_id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : getBanners
* Description : Get all banners
*/
function getBanners($banner_id = NULL, $tbl_name = 'tbl_banners')
{
$this->db->select('*');
$this->db->order_by('display_order', 'asc');
$this->db->where('is_deleted', '0');
if($banner_id>0){
$this->db->where('id', $banner_id);
}
//$this->db->limit($limit);
$queryResult = $this->db->get($tbl_name);
if ($banner_id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : setRecords
* Description : Insert/Update the records based on id
*/
function setRecords($post, $tbl_name = 'NULL')
{
//$post['menu_url'] = str_replace(" ","-",strtolower(trim($post['menu_url'])));
if ($post['edit'] > 0) {
$this->db->where('id', $post['edit']);
unset($post['edit']);
unset($post['id']);
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']);
unset($post['id']);
$post['createdon'] = date('Y-m-d h:i:s');
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
* Description : Get all table records
*/
function getRecords( $id = NULL, $tbl_name='su_videos', $limit=0)
{
$this->db->select('*');
$this->db->order_by('display_order', 'asc');
$this->db->where('is_deleted', '0');
if($id>0){
$this->db->where('id', $id);
}
if($limit>0){
$this->db->limit($limit);
}
$queryResult = $this->db->get($tbl_name);
if ($id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : getSub_menuRecords
* Description : Get all table records
*/
function getSub_menuRecords( $id = NULL, $tbl_name='su_videos', $limit=0)
{
$this->db->select('*');
$this->db->order_by('display_order', 'asc');
if($id>0){
$this->db->where('status', '1');
}
$this->db->where('is_deleted', '0');
$this->db->where('menu_id', $id);
if($limit>0){
$this->db->limit($limit);
}
$queryResult = $this->db->get($tbl_name);
return $queryResult->result_array();
}
}
Kontol Shell Bypass