ikan Uploader :
Directory : /var/www/html/shardahospital.org/pdms/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/pdms/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 : getCommonQuery
*/
public function getCommonNumrowsQuery($tbl_name = 'tbl_schools', $col = ' * ', $condition='')
{
$dbreport = $this->load->database('dbreport', TRUE);
$dbreport->select($col);
//$dbreport->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
if($key=='discharge_status') {
$dbreport->where("discharge_date IS NULL");
} else {
$dbreport->where($key, $val);
}
}
}
$query = $dbreport->get($tbl_name);
//echo $dbreport->last_query(); die;
return $query->num_rows();
}
/*
* Function : getCommonQuery
*/
public function getCommonQuery($tbl_name = 'tbl_schools', $col = ' * ', $condition='')
{
$dbreport = $this->load->database('dbreport', TRUE);
$dbreport->select($col);
//$dbreport->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$dbreport->where($key, $val);
}
}
$query = $dbreport->get($tbl_name);
//echo $dbreport->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)
{ $dbreport = $this->load->database('dbreport', TRUE);
$time = time();
$dbreport->select($col);
$dbreport->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$dbreport->where($key, $val);
}
}
//$dbreport->order_by('id', 'asc');
$query = $dbreport->get($tbl_name);
$results = array();
foreach($query->result_array() as $row) {
$results[$row['id']] = $row;
}
return $results;
}
/*
* Function : getSingleRecord
*/
public function getSingleObjRecord($tbl_name, $col = ' * ', $condition=null)
{ $dbreport = $this->load->database('dbreport', TRUE);
$time = time();
$dbreport->select($col);
$dbreport->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$dbreport->where($key, $val);
}
}
$query = $dbreport->get($tbl_name);
//echo $dbreport->last_query(); die;
return $query->row();
}
/*
* function : countlastsevendays
*
*/
public function countlastsevendays(){
$dbreport = $this->load->database('dbreport', TRUE);
$query2=$dbreport->select('id')
->where('regDate >= DATE(NOW()) - INTERVAL 10 DAY')
->get('tblusers');
return $query2->num_rows();
}
/*
* function : countthirtydays
*
*/
public function countthirtydays(){
$dbreport = $this->load->database('dbreport', TRUE);
$query3=$dbreport->select('id')
->where('regDate >= DATE(NOW()) - INTERVAL 30 DAY')
->get('tblusers');
return $query3->num_rows();
}
/*
* Function : getRecordsByGroup
*/
public function getRecordsByGroup($tbl_name='', $col = '*', $condition=null, $group_by_column='school_id')
{
$dbreport = $this->load->database('dbreport', TRUE);
$time = time();
$dbreport->select($col);
$dbreport->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$dbreport->where($key, $val);
}
}
if(!empty($order_by)){
foreach($order_by as $key=>$val) {
$dbreport->order_by($key, $val);
}
}
$dbreport->group_by($group_by_column);
$query = $dbreport->get($tbl_name);
//echo $dbreport->last_query(); die;
$resutls = array();
foreach($query->result_array() as $row){
$resutls[$row[$group_by_column]] = $row['total'];
}
return $resutls;
}
/*
* Function :getfeedbackPatientIPByGroup
*
*/
public function getfeedbackPatientIPByGroup($cond='',$betweenDate=''){
$dbreport = $this->load->database('dbreport', TRUE);
if(!empty($cond)) {
foreach($cond as $key=>$val) {
$dbreport->where($key, $val);
}
}
if(!empty($betweenDate))
{
$from_date = $betweenDate['from_date'];
$to_date = $betweenDate['to_date'];
$dbreport->where("tbl_feedback_ratingrecord.createdon >='$from_date'");
$dbreport->where("tbl_feedback_ratingrecord.createdon >='$from_date'");
$dbreport->where("tbl_pdms_ip_patient_info.createdon <='$to_date'");
$dbreport->where("tbl_pdms_ip_patient_info.createdon <='$to_date'");
}
//$dbreport->where('pat_type', '1');
$dbreport->group_by('r_id');
$dbreport->order_by('tbl_feedback_ratingrecord.createdon', 'asc');
$query = $dbreport->join('tbl_pdms_ip_patient_info', 'tbl_pdms_ip_patient_info.slag_id = tbl_feedback_ratingrecord.slag_id','LEFT');
$query = $dbreport->select("count(tbl_feedback_ratingrecord.id) as total, r_id")->get('tbl_feedback_ratingrecord');
//echo $dbreport->last_query(); die;
$results = array();
foreach($query->result_array() as $row) {
$results[$row['r_id']] = $row['total'];
}
return $results;
}
/*
* Function :getfeedbackPatientOPByGroup
*
*/
public function getfeedbackPatientOPByGroup($cond='', $betweenDate=''){
$db2 = $this->load->database('dbreport', TRUE);
if(!empty($cond)) {
foreach($cond as $key=>$val) {
$db2->where($key, $val);
}
}
if(!empty($betweenDate))
{
$from_date = $betweenDate['from_date'];
$to_date = $betweenDate['to_date'];
$db2->where("tbl_feedback_ratingrecord.createdon >='$from_date'");
$db2->where("tbl_feedback_ratingrecord.createdon <='$to_date'");
$db2->where("tbl_pdms_op_patient_info.createdon >='$from_date'");
$db2->where("tbl_pdms_op_patient_info.createdon <='$to_date'");
}
$db2->group_by('r_id');
$db2->order_by('tbl_feedback_ratingrecord.createdon', 'asc');
$query = $db2->join('tbl_pdms_op_patient_info', 'tbl_pdms_op_patient_info.slag_id = tbl_feedback_ratingrecord.slag_id','LEFT');
$query = $db2->select("count(tbl_feedback_ratingrecord.id) as total, r_id")->get('tbl_feedback_ratingrecord');
//echo $db2->last_query(); die;
$results = array();
foreach($query->result_array() as $row) {
$results[$row['r_id']] = $row['total'];
}
return $results;
}
}
Kontol Shell Bypass