ikan Uploader :
Directory : /var/www/html/shardahospital.org/pdms/application/controllers/admin/
Upload File : |
| Current File : /var/www/html/shardahospital.org/pdms/application/controllers/admin/Surveydashboard.php |
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
Class Surveydashboard extends CI_Controller {
function __construct(){
parent::__construct();
$this->load->model('Survey_Dashboard_Model');
if(! $this->session->userdata('adid'))
redirect('admin/login');
}
public function index()
{
$data = array();
$searchCond = array();
$dateFileter = array();
$from_date = date("Y-m-d", strtotime("$end_date -10 days"));
$to_date = date('Y-m-d');
if($_GET['fromdate_filter']){
$dateFileter['from_date'] = $_GET['fromdate_filter'].' 00:00:00';
} else {
$dateFileter['from_date'] = $from_date.' 00:00:00';
$_GET['fromdate_filter'] = $from_date;
}
if($_GET['todate_filter']){
$dateFileter['to_date'] = $_GET['todate_filter'].' 23:59:59';
} else{
$dateFileter['to_date'] = $to_date.' 23:59:59';
$_GET['todate_filter'] = $to_date;
}
$searchCond = array('status'=>'1');
$question_id = "";
if($_GET['survey_filter']!='' || $_GET['fromdate_filter']!='' || $_GET['todate_filter']!=''){
if($_GET['survey_filter']){
$searchCond['survey_id'] = $_GET['survey_filter'];
}
if($_GET['question_filter']){
$question_id = $searchCond['question_id'] = $_GET['question_filter'];
}
}
$data['ratingRecords'] = $this->Survey_Dashboard_Model->getfeedbackPatientOPByGroup($searchCond, $dateFileter);
$data['chart_title'] = 'Over All Survey';
$data['surveyArray'] = $this->Survey_Dashboard_Model->getCommonIdArray('survey_set','id,title', array('status'=>'1'));
$data['categoryArray'] = $this->Survey_Dashboard_Model->getCommonIdArray('survey_questions_category','id,category_name', array('status'=>'1'));
if($_GET['survey_filter']){
$data['questionListArray'] = $this->Survey_Dashboard_Model->getCommonQuery('survey_questions','*', array('survey_id'=>$_GET['survey_filter'],'status'=>'1'));
}
$data['totalusers'] = $this->Survey_Dashboard_Model->getCommonNumrowsQuery('tbl_admin','id');
$data['totaloppatient'] = $this->Survey_Dashboard_Model->getCommonNumrowsQuery('tbl_pdms_op_patient_info','id');
$data['totalippatient'] = $this->Survey_Dashboard_Model->getCommonNumrowsQuery('tbl_pdms_ip_patient_info','id', array('discharge_status'=>'1'));
$survey_id = '';
if($_GET['survey_filter']){
$survey_id = $_GET['survey_filter'];
}
$data['categoryWiseCount'] = $this->Survey_Dashboard_Model->questionWiseSurveyCount($survey_id, $question_id);
$data['categoryWiseTotalCount'] = $this->Survey_Dashboard_Model->questionTotalWiseSurveyCount($survey_id, $question_id);
if($_GET['question_filter']){
$data['questionMasterList'] = $this->Survey_Dashboard_Model->getCommonQuery('tbl_questions_master','id,title',array('status'=>'1','category_id'=>$_GET['category_filter']));
}
$this->load->view('admin/_parts/header');
$this->load->view('admin/surveydashboard',$data);
$this->load->view('admin/_parts/footer');
setHistory('Welcome to PDMS surveydashboard');
}
public function getPatientQsCategory(){
$pet_type = $_POST['pet_type'];
if($pet_type>0)
{
$pet_type = $pet_type=='1' ? '2' : '1';
$data_records = $this->Survey_Dashboard_Model->getCommonQuery('tbl_checklist_master','id,checklist',array('event_id'=>$pet_type,'status'=>'1'));
$response = array();
foreach($data_records as $row)
{
$response[$row['id']] = $row['checklist'];
}
header('Content-type: application/json');
echo json_encode($response);
}
exit;
}
public function getPatientQsCategoryWiseQuestion(){
$survey_id = $_POST['survey_id'];
if($survey_id!='')
{
$data_records = $this->Survey_Dashboard_Model->getCommonQuery('survey_questions ','id,question',array('survey_id'=>$survey_id,'status'=>'1'));
$response = array();
foreach($data_records as $row)
{
$response[$row['id']] = $row['question'];
}
header('Content-type: application/json');
echo json_encode($response);
}
exit;
}
}
Kontol Shell Bypass