ikan Uploader :
Directory : /var/www/html/shardahospital.org/incident/application/controllers/
Upload File : |
| Current File : /var/www/html/shardahospital.org/incident/application/controllers/Grievancehistory_27102023.php |
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Grievancehistory extends MY_Controller
{
public function __construct()
{
parent::__construct();
$this->load->model(array('Common_model', 'Api_model'));
$this->load->library('form_validation','session');
}
/*
* Function : index
*/
public function index()
{
$data = array();
$head = array();
$arrSeo = $this->Public_model->getSeo('adminlogin');
// Validate Session Exist Or Not
validate_user_session();
// School Array
$data['schoolArray'] = $this->Common_model->getSchoolList('su_schools');
// Department Array
$data['departmentArray'] = $this->Common_model->getDepartmentList('su_departments');
// Get grievance Array
$data['grievanceArray'] = $this->Common_model->getGrievanceList('grievance_type');
// Get Grievance Details
$data['historyArray'] = $this->Common_model->getAllGrievanceHistoryRecords('tblcomplaints','*', array('userId'=>$_SESSION['USER_DETAILS']['id']),array('complaintNumber'=>'DESC'), array('status'=>'DESC'));
/**************** L1 Start Here ***********************/
$complaintremark = $this->Common_model->getAllRecords('complaintremark','*',array('userId'=>$_SESSION['USER_DETAILS']['id'],'is_deleted'=>'0'));
$remarksArray = array();
foreach($complaintremark as $row){
$remarksArray[$row['complaintNumber']][] = $row;
}
$data['complaintremarks'] = $remarksArray;
/**************** L1 End Here ***********************/
/**************** L2 Start Here ***********************/
$complaintl2remark = $this->Common_model->getAllRecords('tbl_leveltwo_complaintremark','*',array('userId'=>$_SESSION['USER_DETAILS']['id'],'is_deleted'=>'0'));
$remarksL2Array = array();
foreach($complaintl2remark as $row){
$remarksL2Array[$row['complaintNumber']][] = $row;
}
$data['complaintl2remarks'] = $remarksL2Array;
$historyLevelTwoArray = $this->Common_model->getAllRecords('tbl_leveltwo_complaints','*', array('userId'=>$_SESSION['USER_DETAILS']['id']),array('complaintNumber'=>'DESC'), array('status'=>'DESC'));
$responseArray = array();
foreach($historyLevelTwoArray as $tlrow){
$responseArray[$tlrow['compNumber']][] = $tlrow;
}
$data['historyLevelTwoArray'] = $responseArray;
/**************** L2 End Here ***********************/
/**************** L3 Start Here ***********************/
$complaintl3remark = $this->Common_model->getAllRecords('tbl_levelthree_complaintremark','*',array('userId'=>$_SESSION['USER_DETAILS']['id'],'is_deleted'=>'0'));
$remarksL3Array = array();
foreach($complaintl3remark as $row){
$remarksL3Array[$row['complaintNumber']][] = $row;
}
$data['complaintl3remarks'] = $remarksL3Array;
$historyLevelThreeArray = $this->Common_model->getAllRecords('tbl_levelthree_complaints','*', array('userId'=>$_SESSION['USER_DETAILS']['id']),array('complaintNumber'=>'DESC'), array('status'=>'DESC'));
$responseThreeArray = array();
foreach($historyLevelThreeArray as $trow){
$responseThreeArray[$trow['compNumber']][] = $trow;
}
$data['historyLevelThreeArray'] = $responseThreeArray;
/**************** L3 End Here ***********************/
/**************** L4 Start Here ***********************/
$complaintl4remark = $this->Common_model->getAllRecords('tbl_levelfour_complaintremark','*',array('userId'=>$_SESSION['USER_DETAILS']['id'],'is_deleted'=>'0'));
$remarksL4Array = array();
foreach($complaintl4remark as $row){
$remarksL4Array[$row['complaintNumber']][] = $row;
}
$data['complaintl4remarks'] = $remarksL4Array;
$historyLevelFourArray = $this->Common_model->getAllRecords('tbl_levelfour_complaints','*', array('userId'=>$_SESSION['USER_DETAILS']['id']),array('complaintNumber'=>'DESC'), array('status'=>'DESC'));
$responseFourArray = array();
foreach($historyLevelFourArray as $frow){
$responseFourArray[$frow['compNumber']][] = $frow;
}
$data['historyLevelFourArray'] = $responseFourArray;
/**************** L4 End Here ***********************/
if($_GET['key']){
$data['grievanceDetails'] = $this->Common_model->getSingleRecord('tblcomplaints','*',array('compNumber'=>base64_decode($_GET['key']),'userId'=>$_SESSION['USER_DETAILS']['id']));
}
// SET SEO DATA
$head['title'] = @$arrSeo['title']!='' ? $arrSeo['title'] : 'Grievance History - Sharda Grievance Portal';
$this->load->view('_parts/empty_header', $head);
$this->load->view('complainthistory', $data);
$this->load->view('_parts/empty_no_footer');
}
/*
* Function : pendingincident
*/
public function pendingincident()
{
$data = array();
$head = array();
$arrSeo = $this->Public_model->getSeo('adminlogin');
// Validate Session Exist Or Not
validate_user_session();
// School Array
$data['schoolArray'] = $this->Common_model->getSchoolList('su_schools');
// Department Array
$data['departmentArray'] = $this->Common_model->getDepartmentList('su_departments');
// Get grievance Array
$data['grievanceArray'] = $this->Common_model->getGrievanceList('grievance_type');
// Get Grievance Details
$data['historyArray'] = $this->Common_model->getAllGrievanceHistoryRecords('tblcomplaints','*', array('status'=>'in Process','userId'=>$_SESSION['USER_DETAILS']['id']),array('complaintNumber'=>'DESC'), array('status'=>'DESC'));
/**************** L1 Start Here ***********************/
$complaintremark = $this->Common_model->getAllRecords('complaintremark','*',array('userId'=>$_SESSION['USER_DETAILS']['id'],'is_deleted'=>'0'));
$remarksArray = array();
foreach($complaintremark as $row){
$remarksArray[$row['complaintNumber']][] = $row;
}
$data['complaintremarks'] = $remarksArray;
/**************** L1 End Here ***********************/
/**************** L2 Start Here ***********************/
$complaintl2remark = $this->Common_model->getAllRecords('tbl_leveltwo_complaintremark','*',array('userId'=>$_SESSION['USER_DETAILS']['id'],'is_deleted'=>'0'));
$remarksL2Array = array();
foreach($complaintl2remark as $row){
$remarksL2Array[$row['complaintNumber']][] = $row;
}
$data['complaintl2remarks'] = $remarksL2Array;
$historyLevelTwoArray = $this->Common_model->getAllRecords('tbl_leveltwo_complaints','*', array('userId'=>$_SESSION['USER_DETAILS']['id']),array('complaintNumber'=>'DESC'), array('status'=>'DESC'));
$responseArray = array();
foreach($historyLevelTwoArray as $tlrow){
$responseArray[$tlrow['compNumber']][] = $tlrow;
}
$data['historyLevelTwoArray'] = $responseArray;
/**************** L2 End Here ***********************/
/**************** L3 Start Here ***********************/
$complaintl3remark = $this->Common_model->getAllRecords('tbl_levelthree_complaintremark','*',array('userId'=>$_SESSION['USER_DETAILS']['id'],'is_deleted'=>'0'));
$remarksL3Array = array();
foreach($complaintl3remark as $row){
$remarksL3Array[$row['complaintNumber']][] = $row;
}
$data['complaintl3remarks'] = $remarksL3Array;
$historyLevelThreeArray = $this->Common_model->getAllRecords('tbl_levelthree_complaints','*', array('userId'=>$_SESSION['USER_DETAILS']['id']),array('complaintNumber'=>'DESC'), array('status'=>'DESC'));
$responseThreeArray = array();
foreach($historyLevelThreeArray as $trow){
$responseThreeArray[$trow['compNumber']][] = $trow;
}
$data['historyLevelThreeArray'] = $responseThreeArray;
/**************** L3 End Here ***********************/
/**************** L4 Start Here ***********************/
$complaintl4remark = $this->Common_model->getAllRecords('tbl_levelfour_complaintremark','*',array('userId'=>$_SESSION['USER_DETAILS']['id'],'is_deleted'=>'0'));
$remarksL4Array = array();
foreach($complaintl4remark as $row){
$remarksL4Array[$row['complaintNumber']][] = $row;
}
$data['complaintl4remarks'] = $remarksL4Array;
$historyLevelFourArray = $this->Common_model->getAllRecords('tbl_levelfour_complaints','*', array('userId'=>$_SESSION['USER_DETAILS']['id']),array('complaintNumber'=>'DESC'), array('status'=>'DESC'));
$responseFourArray = array();
foreach($historyLevelFourArray as $frow){
$responseFourArray[$frow['compNumber']][] = $frow;
}
$data['historyLevelFourArray'] = $responseFourArray;
/**************** L4 End Here ***********************/
if($_GET['key']){
$data['grievanceDetails'] = $this->Common_model->getSingleRecord('tblcomplaints','*',array('compNumber'=>base64_decode($_GET['key']),'userId'=>$_SESSION['USER_DETAILS']['id']));
}
// SET SEO DATA
$head['title'] = @$arrSeo['title']!='' ? $arrSeo['title'] : 'Grievance History - Sharda Grievance Portal';
$this->load->view('_parts/empty_header', $head);
$this->load->view('complainthistory', $data);
$this->load->view('_parts/empty_no_footer');
}
/*
* Function : resolvedincident
*/
public function resolvedincident()
{
$data = array();
$head = array();
$arrSeo = $this->Public_model->getSeo('adminlogin');
// Validate Session Exist Or Not
validate_user_session();
// School Array
$data['schoolArray'] = $this->Common_model->getSchoolList('su_schools');
// Department Array
$data['departmentArray'] = $this->Common_model->getDepartmentList('su_departments');
// Get grievance Array
$data['grievanceArray'] = $this->Common_model->getGrievanceList('grievance_type');
// Get Grievance Details
$data['historyArray'] = $this->Common_model->getAllGrievanceHistoryRecords('tblcomplaints','*', array('status'=>'closed','userId'=>$_SESSION['USER_DETAILS']['id']),array('complaintNumber'=>'DESC'), array('status'=>'DESC'));
/**************** L1 Start Here ***********************/
$complaintremark = $this->Common_model->getAllRecords('complaintremark','*',array('userId'=>$_SESSION['USER_DETAILS']['id'],'is_deleted'=>'0'));
$remarksArray = array();
foreach($complaintremark as $row){
$remarksArray[$row['complaintNumber']][] = $row;
}
$data['complaintremarks'] = $remarksArray;
/**************** L1 End Here ***********************/
/**************** L2 Start Here ***********************/
$complaintl2remark = $this->Common_model->getAllRecords('tbl_leveltwo_complaintremark','*',array('userId'=>$_SESSION['USER_DETAILS']['id'],'is_deleted'=>'0'));
$remarksL2Array = array();
foreach($complaintl2remark as $row){
$remarksL2Array[$row['complaintNumber']][] = $row;
}
$data['complaintl2remarks'] = $remarksL2Array;
$historyLevelTwoArray = $this->Common_model->getAllRecords('tbl_leveltwo_complaints','*', array('userId'=>$_SESSION['USER_DETAILS']['id']),array('complaintNumber'=>'DESC'), array('status'=>'DESC'));
$responseArray = array();
foreach($historyLevelTwoArray as $tlrow){
$responseArray[$tlrow['compNumber']][] = $tlrow;
}
$data['historyLevelTwoArray'] = $responseArray;
/**************** L2 End Here ***********************/
/**************** L3 Start Here ***********************/
$complaintl3remark = $this->Common_model->getAllRecords('tbl_levelthree_complaintremark','*',array('userId'=>$_SESSION['USER_DETAILS']['id'],'is_deleted'=>'0'));
$remarksL3Array = array();
foreach($complaintl3remark as $row){
$remarksL3Array[$row['complaintNumber']][] = $row;
}
$data['complaintl3remarks'] = $remarksL3Array;
$historyLevelThreeArray = $this->Common_model->getAllRecords('tbl_levelthree_complaints','*', array('userId'=>$_SESSION['USER_DETAILS']['id']),array('complaintNumber'=>'DESC'), array('status'=>'DESC'));
$responseThreeArray = array();
foreach($historyLevelThreeArray as $trow){
$responseThreeArray[$trow['compNumber']][] = $trow;
}
$data['historyLevelThreeArray'] = $responseThreeArray;
/**************** L3 End Here ***********************/
/**************** L4 Start Here ***********************/
$complaintl4remark = $this->Common_model->getAllRecords('tbl_levelfour_complaintremark','*',array('userId'=>$_SESSION['USER_DETAILS']['id'],'is_deleted'=>'0'));
$remarksL4Array = array();
foreach($complaintl4remark as $row){
$remarksL4Array[$row['complaintNumber']][] = $row;
}
$data['complaintl4remarks'] = $remarksL4Array;
$historyLevelFourArray = $this->Common_model->getAllRecords('tbl_levelfour_complaints','*', array('userId'=>$_SESSION['USER_DETAILS']['id']),array('complaintNumber'=>'DESC'), array('status'=>'DESC'));
$responseFourArray = array();
foreach($historyLevelFourArray as $frow){
$responseFourArray[$frow['compNumber']][] = $frow;
}
$data['historyLevelFourArray'] = $responseFourArray;
/**************** L4 End Here ***********************/
if($_GET['key']){
$data['grievanceDetails'] = $this->Common_model->getSingleRecord('tblcomplaints','*',array('compNumber'=>base64_decode($_GET['key']),'userId'=>$_SESSION['USER_DETAILS']['id']));
}
// SET SEO DATA
$head['title'] = @$arrSeo['title']!='' ? $arrSeo['title'] : 'Grievance History - Sharda Grievance Portal';
$this->load->view('_parts/empty_header', $head);
$this->load->view('complainthistory', $data);
$this->load->view('_parts/empty_no_footer');
}
/*
* Function : viewgrievance
*/
public function viewgrievance()
{
$data = array();
$head = array();
$arrSeo = $this->Public_model->getSeo('viewgrievance');
$id = $_GET['cid'];
// Validate Session Exist Or Not
validate_user_session();
// Get Count
if($id>0) {
$data['complaintDetails'] = $complaintDetails = $this->Common_model->getSingleRecord('tblcomplaints','*', array('complaintNumber'=>$id,'userId'=>$_SESSION['USER_DETAILS']['id']));
/**************** L1 Start Here ***********************/
$data['complaintremark'] = $this->Common_model->getAllRecords('complaintremark','*',array('is_deleted'=>'0','complaintNumber'=>$complaintDetails['compNumber']));
/**************** L1 End Here ***********************/
/**************** L2 Start Here ***********************/
$data['complaintl2remark'] = $this->Common_model->getAllRecords('tbl_leveltwo_complaintremark','*',array('is_deleted'=>'0','complaintNumber'=>$complaintDetails['compNumber']));
$data['historyLevelTwoArray'] = $this->Common_model->getSingleRecord('tbl_leveltwo_complaints','*', array('compNumber'=>$complaintDetails['compNumber'],'userId'=>$_SESSION['USER_DETAILS']['id']));
/**************** L2 End Here ***********************/
/**************** L3 Start Here ***********************/
$data['complaintl3remark'] = $this->Common_model->getAllRecords('tbl_levelthree_complaintremark','*',array('is_deleted'=>'0','complaintNumber'=>$complaintDetails['compNumber']));
$data['historyLevelThreeArray'] = $this->Common_model->getSingleRecord('tbl_levelthree_complaints','*', array('compNumber'=>$complaintDetails['compNumber']),array('complaintNumber'=>'DESC'));
/**************** L3 End Here ***********************/
/**************** L4 Start Here ***********************/
$data['complaintl4remark'] = $this->Common_model->getAllRecords('tbl_levelfour_complaintremark','*',array('is_deleted'=>'0','complaintNumber'=>$complaintDetails['compNumber']));
$data['historyLevelFourArray'] = $this->Common_model->getSingleRecord('tbl_levelfour_complaints','*', array('compNumber'=>$complaintDetails['compNumber']),array('complaintNumber'=>'DESC'));
/**************** L4 End Here ***********************/
}
// School Array
$data['schoolArray'] = $this->Common_model->getSchoolList('su_schools');
// Department Array
$data['departmentArray'] = $this->Common_model->getDepartmentList('su_departments');
// Get grievance Array
$data['grievanceArray'] = $this->Common_model->getGrievanceList('grievance_type');
// SET SEO DATA
$head['title'] = @$arrSeo['title']!='' ? $arrSeo['title'] : 'User Complaint History - Sharda Grievance Portal';
$this->load->view('_parts/empty_header', $head);
$this->load->view('viewcomplaint', $data);
$this->load->view('_parts/empty_no_footer');
}
/*
* Function : searchgrievance
*/
public function searchgrievance()
{
$data = array();
$head = array();
$arrSeo = $this->Public_model->getSeo('searchgrievance');
if($_POST['submit']=='') {
$grievanceArray = $this->Common_model->getSingleRecord('tblcomplaints','*',array('compNumber'=>$_POST['search_grievance'],'userId'=>$_SESSION['USER_DETAILS']['id']));
if($grievanceArray['compNumber']!=''){
redirect('grievancehistory/viewgrievance?cid='.$grievanceArray['complaintNumber']);
} else {
redirect('grievancehistory/viewgrievance?msg=error');
}
}
}
}
Kontol Shell Bypass