ikan Uploader :
Directory : /var/www/html/new-ugenterprises.com/blog/application/models/
Upload File : |
| Current File : /var/www/html/new-ugenterprises.com/blog/application/models/Admin_Dashboard_Model.php |
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Admin_Dashboard_Model extends CI_Model {
function __construct(){
parent::__construct();
if(! $this->session->userdata('adid'))
redirect('admin/login');
}
/*
* function : totalmentee
*
*/
public function totalevents($uuid='',$school_id=''){
if($uuid>0) {
$query=$this->db->select('id')->where('status','1')->where('id',$uuid)->get('tbl_status_master');
} else if($school_id>0) {
$query=$this->db->select('id')->where('status','1')->where('school_id',$school_id)->get('tbl_schools');
} else {
$query=$this->db->select('id')->where('status','1')->get('tbl_status_master');
}
return $query->num_rows();
}
/*
* function : totalupappointment
*
*/
public function totalpublish($uuid='',$school_id=''){
if($uuid>0) {
$query=$this->db->select('id')->where('status','1')->where('event_id',$uuid)->get('tbl_status_master');
} else if($school_id>0) {
$query=$this->db->select('id')->where('status','1')->where('school_id',$school_id)->get('tbl_status_master');
} else {
$query=$this->db->select('id')->where('status','4')->get('tbl_event_master');
}
return $query->num_rows();
}
/*
* function : totaldraft
*
*/
public function totaldraft($uuid='',$school_id=''){
if($uuid>0) {
$query=$this->db->select('id')->where('status','1')->where('event_id',$uuid)->get('tbl_status_master');
} else if($school_id>0) {
$query=$this->db->select('id')->where('status','1')->where('school_id',$school_id)->get('tbl_status_master');
} else {
$query=$this->db->select('id')->where('status','2')->get('tbl_event_master');
}
return $query->num_rows();
}
/*
* function : totalarchive
*
*/
public function totalarchive($uuid='',$school_id=''){
if($uuid>0) {
$query=$this->db->select('id')->where('status','1')->where('id',$uuid)->get('tbl_status_master');
} else if($school_id>0) {
$query=$this->db->select('id')->where('status','1')->where('school_id',$school_id)->get('tbl_status_master');
} else {
$query=$this->db->select('id')->where('status','3')->get('tbl_event_master');
}
return $query->num_rows();
}
/*
* function : totalpending
*
*/
public function totalpending($uuid='',$school_id=''){
if($uuid>0) {
$query=$this->db->select('id')->where('status','1')->where('id',$uuid)->get('tbl_status_master');
} else if($school_id>0) {
$query=$this->db->select('id')->where('status','1')->where('school_id',$school_id)->get('tbl_status_master');
} else {
$query=$this->db->select('id')->where('status','6')->get('tbl_status_master');
}
return $query->num_rows();
}
/*
* function : totalapproved
*
*/
public function totalapproved($uuid='',$school_id=''){
if($uuid>0) {
$query=$this->db->select('id')->where('status','1')->where('id',$uuid)->get('tbl_status_master');
} else if($school_id>0) {
$query=$this->db->select('id')->where('status','1')->where('school_id',$school_id)->get('tbl_status_master');
} else {
$query=$this->db->select('id')->where('status','5')->get('tbl_status_master');
}
return $query->num_rows();
}
/*
* Function : getRecordsByGroup
*/
public function getRecordsByGroup($tbl_name='', $col = '*', $condition=null, $group_by_column='school_id')
{
$time = time();
$this->db->select($col);
$this->db->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$this->db->where($key, $val);
}
}
if(!empty($order_by)){
foreach($order_by as $key=>$val) {
$this->db->order_by($key, $val);
}
}
$this->db->group_by($group_by_column);
$query = $this->db->get($tbl_name);
//echo $this->db->last_query(); die;
$resutls = array();
foreach($query->result_array() as $row){
$resutls[$row[$group_by_column]] = $row['total'];
}
return $resutls;
}
/*
* function : totalmentor
*
*/
public function totalmentor($uuid='',$school_id=''){
if($school_id>0) {
$query=$this->db->select('id')->where('school_id',$school_id)->get('tbl_admin');
} else {
$query=$this->db->select('id')->where('role_id','4')->get('tbl_admin');
}
return $query->num_rows();
}
/*
* function : totalcounselling
*
*/
public function totalcounselling($uuid='',$school_id=''){
$num_rows =0;
return $num_rows;
}
/*
* Function : getCommonQuery
*/
public function getCommonQuery($tbl_name = 'tbl_schools', $col = ' * ', $condition='')
{
$this->db->select($col);
$this->db->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$this->db->where($key, $val);
}
}
$query = $this->db->get($tbl_name);
echo $this->db->last_query(); die;
return $query->result_array();
}
/*
* Function: getGrievanceList
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getCommonIdArray($tbl_name='tbl_schools', $col = ' * ', $condition=null)
{
$time = time();
$this->db->select($col);
$this->db->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$this->db->where($key, $val);
}
}
//$this->db->order_by('id', 'asc');
$query = $this->db->get($tbl_name);
$results = array();
foreach($query->result_array() as $row) {
$results[$row['id']] = $row;
}
return $results;
}
/*
* function : countlastsevendays
*
*/
public function countlastsevendays(){
$query2=$this->db->select('id')
->where('regDate >= DATE(NOW()) - INTERVAL 10 DAY')
->get('tblusers');
return $query2->num_rows();
}
/*
* function : countthirtydays
*
*/
public function countthirtydays(){
$query3=$this->db->select('id')
->where('regDate >= DATE(NOW()) - INTERVAL 30 DAY')
->get('tblusers');
return $query3->num_rows();
}
}
Kontol Shell Bypass