ikan Uploader :
Directory : /var/www/html/www.shardaevents.com/application/models/
Upload File : |
| Current File : /var/www/html/www.shardaevents.com/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 : getTotalRecordsCount
*
*/
public function getTotalRecordsCount($condition='', $order_by=''){
//$db2->where('status IN(1,2,3,4,5,6)');
$db2 = $this->load->database('readerdb', TRUE);
$db2->select('id');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
if(!empty($order_by)){
foreach($order_by as $key=>$val) {
$db2->order_by($key, $val);
}
}
$query = $db2->get('tbl_event_master');
//echo $db2->last_query(); die;
return $query->num_rows();
}
public function getRecordsCount($condition='', $order_by=''){
$db2 = $this->load->database('readerdb', TRUE);
$db2->where('status', '4');
$db2->select('id');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
if(!empty($order_by)){
foreach($order_by as $key=>$val) {
$db2->order_by($key, $val);
}
}
$query = $db2->get('tbl_event_master');
//echo $db2->last_query(); die;
return $query->num_rows();
}
/*
* function : totalPublished
*
*/
public function totalPublished($condition='',$order_by=''){
$db2 = $this->load->database('readerdb', TRUE);
$db2->select('id');
$db2->where('status', '4');
$db2->where('verified_hod', '1');
$db2->where('verified_dean', '1');
$db2->where('verified_iqac', '1');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
if(!empty($order_by)){
foreach($order_by as $key=>$val) {
$db2->order_by($key, $val);
}
}
$query = $db2->get('tbl_event_master');
return $query->num_rows();
}
/*
* function : totaldraft
*
*/
public function totaldraft($condition='',$order_by=''){
$db2 = $this->load->database('readerdb', TRUE);
$db2->select('id');
$db2->where('is_deleted', '0');
$db2->where('status', '2');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
if(!empty($order_by)){
foreach($order_by as $key=>$val) {
$db2->order_by($key, $val);
}
}
$query = $db2->get('tbl_event_master');
return $query->num_rows();
}
/*
* function : totalarchive
*
*/
public function totalarchive($condition='',$order_by=''){
$db2 = $this->load->database('readerdb', TRUE);
$db2->select('id');
$db2->where('is_deleted', '0');
$db2->where('status', '3');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
if(!empty($order_by)){
foreach($order_by as $key=>$val) {
$db2->order_by($key, $val);
}
}
$query = $db2->get('tbl_event_master');
return $query->num_rows();
}
/*
* function : totalSaved
*
*/
public function totalSaved($condition='',$order_by=''){
$db2 = $this->load->database('readerdb', TRUE);
$db2->select('id');
$db2->where('status','1');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
if(!empty($order_by)){
foreach($order_by as $key=>$val) {
$db2->order_by($key, $val);
}
}
$query = $db2->get('tbl_event_master');
//echo $db2->last_query(); die;
return $query->num_rows();
}
/*
* function : totalpending
*
*/
public function totalpending($condition='',$order_by=''){
$db2 = $this->load->database('readerdb', TRUE);
$db2->select('id');
$db2->where('status','4');
$db2->where('( verified_hod="0" OR verified_dean="0" OR verified_iqac="0" )');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
if(!empty($order_by)){
foreach($order_by as $key=>$val) {
$db2->order_by($key, $val);
}
}
$query = $db2->get('tbl_event_master');
//echo $db2->last_query(); die;
return $query->num_rows();
}
/*
* function : totalapproved
*
*/
public function totalapproved($condition='',$order_by=''){
$db2 = $this->load->database('readerdb', TRUE);
$db2->select('id');
$db2->where('is_deleted', '0');
$db2->where('status', '5');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
if(!empty($order_by)){
foreach($order_by as $key=>$val) {
$db2->order_by($key, $val);
}
}
$query = $db2->get('tbl_event_master');
return $query->num_rows();
}
/*
* function : totalDecline
*
*/
public function totalDecline($condition='',$order_by=''){
$db2 = $this->load->database('readerdb', TRUE);
$db2->select('id');
$db2->where('is_deleted', '0');
$db2->where('status', '6');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
if(!empty($order_by)){
foreach($order_by as $key=>$val) {
$db2->order_by($key, $val);
}
}
$query = $db2->get('tbl_event_master');
return $query->num_rows();
}
/*
* Function : getRecordsByGroup
*/
public function getRecordsByGroup($tbl_name='', $col = '*', $condition=null, $group_by_column='school_id')
{
$time = time();
$db2 = $this->load->database('readerdb', TRUE);
$db2->select($col);
$db2->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
if(!empty($order_by)){
foreach($order_by as $key=>$val) {
$db2->order_by($key, $val);
}
}
$db2->group_by($group_by_column);
$query = $db2->get($tbl_name);
//echo $db2->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=''){
$db2 = $this->load->database('readerdb', TRUE);
if($school_id>0) {
$query=$db2->select('id')->where('school_id',$school_id)->get('tbl_admin');
} else {
$query=$db2->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='')
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->select($col);
$db2->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
$query = $db2->get($tbl_name);
echo $db2->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();
$db2 = $this->load->database('readerdb', TRUE);
$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;
}
/*
* function : countlastsevendays
*
*/
public function countlastsevendays(){
$db2 = $this->load->database('readerdb', TRUE);
$query2=$db2->select('id')
->where('regDate >= DATE(NOW()) - INTERVAL 10 DAY')
->get('tblusers');
return $query2->num_rows();
}
/*
* function : countthirtydays
*
*/
public function countthirtydays(){
$db2 = $this->load->database('readerdb', TRUE);
$query3=$db2->select('id')
->where('regDate >= DATE(NOW()) - INTERVAL 30 DAY')
->get('tblusers');
return $query3->num_rows();
}
}
Kontol Shell Bypass