ikan Uploader :
Directory : /home/ubuntu/chalkbank/application/models/
Upload File : |
| Current File : //home/ubuntu/chalkbank/application/models/Notification_Model.php |
<?php
Class Notification_Model extends CI_Model
{
Public function __construct(){
parent::__construct();
$db2 = $this->load->database('readerdb', TRUE);
}
// Activeuser Log function start
function getUserGroupNAme($group_name=''){
$db2 = $this->load->database('readerdb', TRUE);
if($group_name!=''){
$db2->where('group_name',$group_name);
$query=$db2->get('savsoft_group');
$results = $query->row_array();
return $results['gid'];
}
}
// category function start
function category_list($uid=''){
$db2 = $this->load->database('readerdb', TRUE);
$db2->order_by('cid','desc');
if($uid!='') {
$db2->where('admin_id',$uid);
}
$query=$db2->get('savsoft_category');
return $query->result_array();
}
// Setting function start
function setting_list($uid=''){
$db2 = $this->load->database('readerdb', TRUE);
$db2->order_by('display_order','asc');
$db2->order_by('status','1');
$db2->order_by('is_deleted','0');
if($uid!='') {
$db2->where('admin_id',$uid);
}
$query=$db2->get('su_registration_setting');
return $query->result_array();
}
// level function start
function level_list($uid='', $lid = ''){
$db2 = $this->load->database('readerdb', TRUE);
if($uid!='') {
$db2->where('admin_id',$uid);
}
if($lid!='') {
$db2->where('lid',$lid);
}
$query=$db2->get('savsoft_level');
//echo $db2->last_query(); die;
return $query->result_array();
}
/*
* Function : getSingleRecord
*/
public function getSingleRecord($tbl_name, $col = ' * ', $condition=null)
{
$db2 = $this->load->database('readerdb', TRUE);
$time = time();
$db2->select($col);
$db2->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
if($key=='gid'){
$where_cond = "(gid = 'All' OR FIND_IN_SET('".$val."', gid))";
$db2->where($where_cond);
} else {
$db2->where($key,$val);
}
}
}
$query = $db2->get($tbl_name);
//echo $db2->last_query(); die;
return $query->row_array();
}
/*
* Function : group_list
*/
function group_list($uid = '', $gid = ''){
$db2 = $this->load->database('readerdb', TRUE);
if(!empty($uid)){
$db2->where('admin_id',$uid);
}
if(!empty($gid)){
$db2->where_in('gid',$gid);
}
$db2->order_by('gid','desc');
$query=$db2->get('savsoft_group');
//echo $this->db->last_query(); die;
return $query->result_array();
}
/*
* Function : saveinfo
*/
public function saveinfo($tbl_name='', $post)
{
$post['createdon'] = date('Y-m-d H:i:s');
$this->db->insert($tbl_name, $post);
//echo $this->db->last_query(); die;
return $this->db->insert_id();
}
/*
* Function : updateinfo
*/
public function updateinfo($tbl_name='', $post, $field, $value)
{
$post['createdon'] = date('Y-m-d H:i:s');
$this->db->where($field, $value);
if (!$this->db->update($tbl_name, $post)) {
log_message('error', print_r($this->db->error(), true));
}
//echo $this->db->last_query(); die;
}
/*
* Function : getAllEcontent
*/
function getAllEcontent($condition = ''){
$db2 = $this->load->database('readerdb', TRUE);
if(!empty($condition)){
foreach($condition as $key=>$val){
if($key=='gid'){
$where_cond = "(gid = 'All' OR FIND_IN_SET('".$val."', gid))";
$db2->where($where_cond);
} else if($key=='search') {
$search=strtolower($val);
$db2->or_like('title',$search);
$db2->or_like('description',$search);
$db2->or_like('vfile_name',$search);
$db2->or_like('tags',$search);
} else {
$db2->where($key,$val);
}
}
}
$db2->where('is_deleted','0');
$db2->order_by('id','desc');
$query = $db2->get('tbl_notifications_master');
//echo $db2->last_query(); die;
return $query->result_array();
}
/*
* Function : remove_data
*/
function remove_data($id){
if($id>0){
$this->db->where('id',$id);
if($this->db->delete('tbl_notifications_master')){
return true;
}else{
return false;
}
} else {
return false;
}
}
/*
* Function : getAllVideo_old
*/
public function getAllVideo_old($condition=null, $createdon='', $betweenDate = '')
{
// $this->db->where('tbl_notifications_master.is_deleted', '0');
if(!empty($createdon)){
$this->db->where("DATE_FORMAT(createdon, '%Y-%m-%d') <= '$createdon'");
}
if(!empty($condition))
{
foreach($condition as $key=>$val) {
if($key=='from_date' || $key=='to_date') {
$this->db->where("DATE_FORMAT(tbl_notifications_master.createdon,'%m/%d/%Y') >='$val'");
} else {
//$this->db->where($key, $val);
}
}
}
if(!empty($betweenDate))
{
$from_date = $betweenDate['from_date'];
$to_date = $betweenDate['to_date'];
$this->db->where("DATE_FORMAT(tbl_notifications_master.createdon,'%m/%d/%Y') >='$from_date'");
$this->db->where("DATE_FORMAT(tbl_notifications_master.createdon,'%m/%d/%Y') <='$to_date'");
}
$this->db->order_by('tbl_notifications_master.createdon', 'asc');
$query = $this->db->join('savsoft_users', 'savsoft_users.uid = tbl_notifications_master.author_id');
$query = $this->db->select("tbl_notifications_master.*, tbl_admin.first_name,tbl_admin.last_name")->get('tbl_notifications_master');
//echo $this->db->last_query();die;
return $query->result_array();
}
public function getCommonIdArray($tbl_name='tbl_schools', $col = ' * ', $condition=null)
{
$db2 = $this->load->database('readerdb', TRUE);
$time = time();
$db2->select($col);
$db2->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
//$db2->order_by('id', 'asc');
$query = $db2->get($tbl_name);
$results = array();
foreach($query->result_array() as $row) {
$results[$row['id']] = $row;
}
return $results;
}
}
?>
Kontol Shell Bypass