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/Feedbackreport.php |
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
/**
* Description of VideoUpload
*
* @author : Sharda Tech Pvt. Ltd
*/
class Feedbackreport extends CI_Controller {
//variable for storing error message
private $error;
//variable for storing success message
private $success;
function __construct() {
parent::__construct();
//load this to validate the inputs in upload form
$this->load->model(array('Common_Model'));
if(! $this->session->userdata('adid'))
redirect('admin/login');
}
//appends all error messages
private function handle_error($err) {
$this->error .= $err . "\r\n";
}
//appends all success messages
private function handle_success($succ) {
$this->success .= $succ . "\r\n";
}
/*
* Function: index
*/
public function index(){
$data = array();
$role_id = $this->session->userdata('adid')->role_id;
$author_id = $this->session->userdata('adid')->id;
$searchCond = array('is_deleted'=>'0','status'=>'1');
if($_GET['search_for']){
$searchCond['event_id'] = $_GET['search_for'];
} else {
$searchCond['event_id'] = $_GET['search_for'] = '1';
}
$data['categoryDetails'] = $this->Common_Model->getAllRecords('tbl_checklist_master', '*', $searchCond);
$from_date = date('Y-m-'). '1';
$to_date = date('Y-m-d');
//$data['recorddetails'] = $this->Common_Model->getAllFeedbackNRecords('tbl_feedback_ratingrecord', '*', array('is_deleted'=>'0'), NULL, NULL, NULL, $dateFilter = array('from_date'=>$from_date,'to_date'=>$to_date));
$questionsArray = $this->Common_Model->getAllRecords('tbl_questions_master','*', array('status'=>'1'));
$finalQuestionArray = array();
foreach($questionsArray as $row){
$finalQuestionArray[$row['category_id']][] = $row;
}
$data['questionsArray'] = $finalQuestionArray;
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/feedbackreport/index',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to manage feedback report module');
}
/*
* Function : getAutostats
*
*/
public function getAutostats(){
$question_id = $_POST['question_id'];
$rating_id = $_POST['rating_id'];
$search_fromdate = $_POST['search_fromdate'];
$search_todate = $_POST['search_todate'];
$template = '';
if($question_id>0 && $rating_id>0){
// Get Totoal QuestionCount
$totalQs = $this->Common_Model->questionsCount('tbl_feedback_ratingrecord',$question_id,$search_fromdate,$search_todate);
$totalRs = $this->Common_Model->questionsRatingCount('tbl_feedback_ratingrecord',$question_id,$rating_id,$search_fromdate,$search_todate);
//$questionDStatsRow = $this->Common_Model->getRatingStats(array('is_deleted'=>'0','status'=>'2', 'rating_id'=>$rating_id,'question_id'=>$question_id));
if($totalRs>0 && $totalRs==$totalQs) {
$template .= "<a href='".base_url('admin/feedbackreport/viewdetails?question_id='.$question_id.'&rating_id='.$rating_id.'&search_fromdate='.$search_fromdate.'&search_todate='.$search_todate)."' target='_blank'><span style='color:green;font-weight:bold;font-size:18px;text-align:center;'>$totalRs/$totalQs</span></a>";
}
else if($totalRs>0 && $totalRs<>$totalQs){
$template .= "<a href='".base_url('admin/feedbackreport/viewdetails?question_id='.$question_id.'&rating_id='.$rating_id.'&search_fromdate='.$search_fromdate.'&search_todate='.$search_todate)."' target='_blank'><span style='color:orange;font-weight:bold;13px;text-align:center;'>$totalRs/$totalQs</span></a>";
} else {
$template .= "<a href='".base_url('admin/feedbackreport/viewdetails?question_id='.$question_id.'&rating_id='.$rating_id.'&search_fromdate='.$search_fromdate.'&search_todate='.$search_todate)."' target='_blank'><span style='color:red;font-weight:bold;12px;text-align:center;'>$totalRs/$totalQs</span></a>";
}
//$template .= "$totalRs/$totalQs";
}
header('Content-type: application/json');
echo json_encode($template);
exit;
}
/*
* Function : viewdetails
*/
public function viewdetails()
{
$data = array();
$questionId = $_GET['question_id'];
$rating_id = $_GET['rating_id'];
$search_fromdate = $_GET['search_fromdate'];
$search_todate = $_GET['search_todate'];
$data['ratingArray'] = $this->Common_Model->getSingleRecord('tbl_pdms_rating_master','*', array('status'=>'1','id'=>$rating_id));
$data['questionsArray'] = $questionsArray = $this->Common_Model->getSingleRecord('tbl_questions_master','*', array('status'=>'1','id'=>$questionId));
$category_id= $questionsArray['category_id'];
$data['categoryArray'] = $categoryArray = $this->Common_Model->getSingleRecord('tbl_checklist_master','*', array('status'=>'1','id'=>$category_id));
$event_id = $categoryArray['event_id'];
if($event_id=='2'){
$detailsArray = $this->Common_Model->getpdmsipPatientCommonQuery(array('q_id'=>$questionId,'r_id'=>$rating_id));
} else {
$detailsArray = $this->Common_Model->getpdmsopPatientCommonQuery(array('q_id'=>$questionId,'r_id'=>$rating_id));
}
$data['detailsArray'] = $detailsArray;
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/feedbackreport/viewdetails',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to manage Feedback report module');
}
}
Kontol Shell Bypass