ikan Uploader :
Directory : /var/www/html/shardahospital.org/application/controllers_new/admin_old/
Upload File : |
| Current File : /var/www/html/shardahospital.org/application/controllers_new/admin_old/Advancesetting.php |
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
Class Advancesetting extends CI_Controller {
function __construct(){
parent::__construct();
$this->load->model(array('ManageUsers_Model','Common_Model'));
if(! $this->session->userdata('elib_adminloggedin'))
redirect('admin');
}
public function index(){
$data = array();
$header = array();
$data['schoolArray'] = $this->Common_Model->SqlgetCommonIdArray('su_schools');
$data['roleArray'] = $this->Common_Model->getCommonIdArray('tbl_role_master');
$data['departmentArray'] = $this->Common_Model->SqlgetCommonIdArray('su_departments');
$data['userdetails'] = $recordsArray = $this->Common_Model->getCommonQuery('tbl_admin');
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/manageusers/index',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to Advance Setting Page');
}
/*
* Function :
*/
public function role(){
$data = array();
$header = array();
$data['moduleArray'] = $this->Common_Model->getCommonIdArray('tbl_module_master');
$data['userdetails'] = $recordsArray = $this->Common_Model->getCommonQuery('tbl_role_master');
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/advancesetting/role',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to Role module');
}
/*
* Function : addrole
* For particular Record
*/
public function addrole($uid = '')
{
if($_POST){
$this->form_validation->set_rules('role_name','Role Name','required');
$this->form_validation->set_rules('status','Status','required');
if($this->form_validation->run())
{
$role_name = $this->input->post('role_name');
$status = $this->input->post('status');
$module_ids = implode(',',$this->input->post('module_ids'));
$data=array(
'role_name'=>$role_name,
'module_ids'=>$module_ids,
'status'=>$status,
'is_deleted'=>'0',
'createdon'=>date('y-m-d H:i:s')
);
if($this->input->post('id')){
$id = $this->input->post('id');
$this->Common_Model->updateinfo($tbl_name='tbl_role_master',$data,'id',$id);
} else {
$this->Common_Model->saveinfo($tbl_name='tbl_role_master',$data);
}
setHistory('Role Added Successfully');
redirect('admin/advancesetting/role');
} else {
setHistory('Validation error on adding role');
$this->load->view('admin/advancesetting/addrole');
}
} else {
$data['moduleArray'] = $this->Common_Model->getCommonIdArray('tbl_module_master');
$data['sd'] = $sd = $this->Common_Model->getSingleRecord('tbl_role_master',' * ', array('id'=>$uid));
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/advancesetting/addrole',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to Add/Edit Role Module');
}
}
public function module(){
$data = array();
$header = array();
$data['userdetails'] = $recordsArray = $this->Common_Model->getCommonQuery('tbl_module_master');
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/advancesetting/module',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to module page');
}
/*
* Function : addmodule
* For particular Record
*/
public function addmodule($uid = '')
{
if($_POST){
$this->form_validation->set_rules('module_name','Module Name','required');
$this->form_validation->set_rules('display_name','Display Name','required');
$this->form_validation->set_rules('display_icon','Display Icon','required');
$this->form_validation->set_rules('display_order','Display Order','required');
$this->form_validation->set_rules('status','Status','required');
if($this->form_validation->run())
{
$module_name = $this->input->post('module_name');
$display_name = $this->input->post('display_name');
$display_icon = $this->input->post('display_icon');
$display_order = $this->input->post('display_order');
$status = $this->input->post('status');
$data=array(
'module_name'=>$module_name,
'display_name'=>$display_name,
'display_icon'=>$display_icon,
'display_order'=>$display_order,
'status'=>$status,
'is_deleted'=>'0',
'createdon'=>date('y-m-d H:i:s')
);
//print_r($data); die;
if($this->input->post('id')){
$id = $this->input->post('id');
$this->Common_Model->updateinfo($tbl_name='tbl_module_master',$data,'id',$id);
} else {
$this->Common_Model->saveinfo($tbl_name='tbl_module_master',$data);
}
setHistory('Module added Successfully');
redirect('admin/advancesetting/module');
} else {
$this->load->view('admin/advancesetting/addmodule');
setHistory('Validation error on Add/Edit module page');
}
} else {
$data['sd'] = $sd = $this->Common_Model->getSingleRecord('tbl_module_master',' * ', array('id'=>$uid));
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/advancesetting/addmodule',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to Add/Edit module page');
}
}
/*
* Function : deletemodule
*
*/
public function deletemodule($uid){
$this->Common_Model->removeAllItems("tbl_module_master",$uid,'id');
$this->session->set_flashdata('success', 'Module data deleted');
redirect('admin/advancesetting/module');
setHistory('advance setting record deleted successfully');
}
/*
* Function : addmanagecategory
* For particular Record
*/
public function managecategory(){
$data = array();
$header = array();
$data['userdetails'] = $recordsArray = $this->Common_Model->getCommonQuery('tbl_category');
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/advancesetting/managecategory',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to manage category page');
}
/*
* Function : addmanagecategory
* For particular Record
*/
public function addmanagecategory($uid = '')
{
if($_POST){
$this->form_validation->set_rules('category_name','Category Name','required');
$this->form_validation->set_rules('display_name','Display Name','required');
$this->form_validation->set_rules('display_icon','Display Icon','required');
$this->form_validation->set_rules('display_order','Display Order','required');
$this->form_validation->set_rules('status','Status','required');
if($this->form_validation->run())
{
$module_name = $this->input->post('module_name');
$display_name = $this->input->post('display_name');
$display_icon = $this->input->post('display_icon');
$display_order = $this->input->post('display_order');
$status = $this->input->post('status');
$data=array(
'module_name'=>$module_name,
'display_name'=>$display_name,
'display_icon'=>$display_icon,
'display_order'=>$display_order,
'status'=>$status,
'is_deleted'=>'0',
'createdon'=>date('y-m-d H:i:s')
);
//print_r($data); die;
if($this->input->post('id')){
$id = $this->input->post('id');
$this->Common_Model->updateinfo($tbl_name='tbl_module_master',$data,'id',$id);
} else {
$this->Common_Model->saveinfo($tbl_name='tbl_module_master',$data);
}
setHistory('Module added Successfully');
redirect('admin/advancesetting/module');
} else {
$this->load->view('admin/_parts/header');
$this->load->view('admin/advancesetting/addmodule');
$this->load->view('admin/_parts/footer');
setHistory('Validation error on Add/Edit module page');
}
} else {
$data['sd'] = $sd = $this->Common_Model->getSingleRecord('tbl_module_master',' * ', array('id'=>$uid));
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/advancesetting/addcategory',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to Add/Edit module page');
}
}
/*
* Function : deletecategory
*
*/
public function deletecategory($uid){
$this->Common_Model->removeAllItems("tbl_module_master",$uid,'id');
$this->session->set_flashdata('success', 'Module data deleted');
redirect('admin/advancesetting/module');
setHistory('advance setting record deleted successfully');
}
/*
* Function : audiences
* For particular Record
*/
public function audiences(){
$data = array();
$header = array();
$data['userdetails'] = $recordsArray = $this->Common_Model->getCommonQuery('tbl_target_audiences');
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/advancesetting/audiences',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to manage category page');
}
/*
* Function : addaudiences
* For particular Record
*/
public function addaudiences($uid = '')
{
if($_POST){
$this->form_validation->set_rules('title','Name','required');
$this->form_validation->set_rules('display_name','Display Name','required');
$this->form_validation->set_rules('status','Status','required');
if($this->form_validation->run())
{
$title = $this->input->post('title');
$display_name = $this->input->post('display_name');
$display_icon = $this->input->post('display_icon');
$display_order = $this->input->post('display_order');
$status = $this->input->post('status');
$data=array(
'title'=>$title,
'display_name'=>$display_name,
'display_icon'=>$display_icon,
'display_order'=>$display_order,
'status'=>$status,
'is_deleted'=>'0',
'createdon'=>date('y-m-d H:i:s')
);
//print_r($data); die;
if($this->input->post('id')){
$id = $this->input->post('id');
$this->Common_Model->updateinfo($tbl_name='tbl_target_audiences',$data,'id',$id);
setHistory('Audiences added Successfully');
} else {
$this->Common_Model->saveinfo($tbl_name='tbl_target_audiences',$data);
setHistory('Audiences added Successfully');
}
redirect('admin/advancesetting/audiences');
} else {
$this->load->view('admin/_parts/header');
$this->load->view('admin/advancesetting/addaudiences');
$this->load->view('admin/_parts/footer');
setHistory('Validation error on Add/Edit audiences page');
}
} else {
$data['sd'] = $sd = $this->Common_Model->getSingleRecord('tbl_target_audiences',' * ', array('id'=>$uid));
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/advancesetting/addaudiences',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to Add/Edit audiences page');
}
}
/*
* Function : subcategory
* For particular Record
*/
public function subcategory(){
$data = array();
$header = array();
$data['userdetails'] = $recordsArray = $this->Common_Model->getCommonQuery('tbl_sub_category');
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/advancesetting/subcategory',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to manage category page');
}
/*
* Function : addsubcategory
* For particular Record
*/
public function addsubcategory($uid = '')
{
if($_POST){
$this->form_validation->set_rules('category_name','Category Name','required');
$this->form_validation->set_rules('display_name','Display Name','required');
$this->form_validation->set_rules('display_icon','Display Icon','required');
$this->form_validation->set_rules('display_order','Display Order','required');
$this->form_validation->set_rules('status','Status','required');
if($this->form_validation->run())
{
$module_name = $this->input->post('module_name');
$display_name = $this->input->post('display_name');
$display_icon = $this->input->post('display_icon');
$display_order = $this->input->post('display_order');
$status = $this->input->post('status');
$data=array(
'module_name'=>$module_name,
'display_name'=>$display_name,
'display_icon'=>$display_icon,
'display_order'=>$display_order,
'status'=>$status,
'is_deleted'=>'0',
'createdon'=>date('y-m-d H:i:s')
);
//print_r($data); die;
if($this->input->post('id')){
$id = $this->input->post('id');
$this->Common_Model->updateinfo($tbl_name='tbl_sub_category',$data,'id',$id);
} else {
$this->Common_Model->saveinfo($tbl_name='tbl_sub_category',$data);
}
setHistory('Module added Successfully');
redirect('admin/advancesetting/module');
} else {
$this->load->view('admin/_parts/header');
$this->load->view('admin/advancesetting/addmodule');
$this->load->view('admin/_parts/footer');
setHistory('Validation error on Add/Edit module page');
}
} else {
$data['sd'] = $sd = $this->Common_Model->getSingleRecord('tbl_module_master',' * ', array('id'=>$uid));
$this->load->view('admin/advancesetting/header',$data);
$this->load->view('admin/advancesetting/addsubcategory',$data);
$this->load->view('admin/advancesetting/footer');
setHistory('Go to Add/Edit module page');
}
}
/*
* Function : deletesubcategory
*
*/
public function deletesubcategory($uid){
$this->Common_Model->removeAllItems("tbl_sub_category",$uid,'id');
$this->session->set_flashdata('success', 'Module data deleted');
redirect('admin/advancesetting/subcategory');
setHistory('advance setting record deleted successfully');
}
/*
* Function : deleterolee
*
*/
public function deleterole($uid){
$this->Common_Model->removeAllItems('tbl_role_master',$uid,'id');
$this->session->set_flashdata('success', 'Role data deleted');
redirect('admin/advancesetting/role');
setHistory('advance setting record deleted successfully');
}
public function getajaxrecord()
{
$school_id = $_POST['school_id'];
if($school_id>0)
{
$data_records = $this->Common_Model->SqlgetCommonIdArray('su_departments','id,name',array('school_id'=>$school_id,'status'=>'1'));
//$data_records = $this->Common_Model->getCommonIdArray('tbl_departments','id,name',array('school_id'=>$school_id,'status'=>'1'));
$response = array();
foreach($data_records as $row)
{
$response[$row['id']] = $row['name'];
}
header('Content-type: application/json');
echo json_encode($response);
}
exit;
}
/*
* Function : importmentee
*
*/
function importmentee()
{
$data = array();
$uid = '';
$uid = $this->session->userdata('adid');
$this->load->helper('xlsimport/php-excel-reader/excel_reader2');
$this->load->helper('xlsimport/spreadsheetreader.php');
if(isset($_FILES['xlsfile'])){
$targets = 'xls/';
$targets = $targets . basename( $_FILES['xlsfile']['name']);
$docadd=($_FILES['xlsfile']['name']);
if(move_uploaded_file($_FILES['xlsfile']['tmp_name'], $targets)){
$Filepath = $targets;
$allxlsdata = array();
date_default_timezone_set('UTC');
$StartMem = memory_get_usage();
try
{
$Spreadsheet = new SpreadsheetReader($Filepath);
$BaseMem = memory_get_usage();
$Sheets = $Spreadsheet -> Sheets();
foreach ($Sheets as $Index => $Name)
{
$Time = microtime(true);
$Spreadsheet -> ChangeSheet($Index);
foreach ($Spreadsheet as $Key => $Row)
{
if ($Row)
{
$allxlsdata[] = $Row;
}
else
{
var_dump($Row);
}
$CurrentMem = memory_get_usage();
if ($Key && ($Key % 500 == 0))
{
}
}
}
}
catch (Exception $E)
{
echo $E -> getMessage();
}
// Insert into DB
//print_r($allxlsdata); die;
$resp = $this->Common_Model->import_mentee($allxlsdata,$uid);
echo 'Total '.$resp.' records addded';
setHistory('Total '.$resp.' mentee addded');
}
} else{
if(!empty($_FILES["file"]["error"])){
echo "Error: " . $_FILES["file"]["error"];
}
}
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/advancesetting/importmentee',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to import mentee page');
}
/*
* Function : importmentor
*
*/
function importmentor()
{
$data = array();
$uid = '';
$uid = $this->session->userdata('adid');
$this->load->helper('xlsimport/php-excel-reader/excel_reader2');
$this->load->helper('xlsimport/spreadsheetreader.php');
if(isset($_FILES['xlsfile'])){
$targets = 'xls/';
$targets = $targets . basename( $_FILES['xlsfile']['name']);
$docadd=($_FILES['xlsfile']['name']);
if(move_uploaded_file($_FILES['xlsfile']['tmp_name'], $targets)){
$Filepath = $targets;
$allxlsdata = array();
date_default_timezone_set('UTC');
$StartMem = memory_get_usage();
try
{
$Spreadsheet = new SpreadsheetReader($Filepath);
$BaseMem = memory_get_usage();
$Sheets = $Spreadsheet -> Sheets();
foreach ($Sheets as $Index => $Name)
{
$Time = microtime(true);
$Spreadsheet -> ChangeSheet($Index);
foreach ($Spreadsheet as $Key => $Row)
{
if ($Row)
{
$allxlsdata[] = $Row;
}
else
{
var_dump($Row);
}
$CurrentMem = memory_get_usage();
if ($Key && ($Key % 500 == 0))
{
}
}
}
}
catch (Exception $E)
{
echo $E -> getMessage();
}
// Insert into DB
//print_r($allxlsdata); die;
$resp = $this->Common_Model->import_mentor($allxlsdata,$uid);
//echo 'Total '.$resp.' records addded';
setHistory('Total '.$resp.' mentee addded');
}
} else{
if(!empty($_FILES["file"]["error"])){
echo "Error: " . $_FILES["file"]["error"];
}
}
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/advancesetting/importmentor',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to import mentor page');
}
public function user(){
$data = array();
$header = array();
//$data['schoolArray'] = $this->Common_Model->getCommonIdArray('tbl_schools');
$data['roleArray'] = $this->Common_Model->getCommonIdArray('tbl_role_master');
//$data['departmentArray'] = $this->Common_Model->getCommonIdArray('tbl_departments');
$data['userdetails'] = $recordsArray = $this->Common_Model->getCommonQuery('tbl_admin');
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/advancesetting/user',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to manage users');
}
/*
* Function : adduser
* For particular Record
*/
public function adduser($uid = '')
{
if($_POST){
$this->form_validation->set_rules('school_id','School Name','required');
$this->form_validation->set_rules('first_name','First Name','required');
$this->form_validation->set_rules('department_id','Department Name','required');
$this->form_validation->set_rules('username','User Name','required');
$this->form_validation->set_rules('email_id','Email Id','required');
//$this->form_validation->set_rules('system_id','System Id','required');
//$this->form_validation->set_rules('contact_number','Contact Number','required');
if(empty($this->input->post('id'))){
$this->form_validation->set_rules('password','Password','required');
}
$this->form_validation->set_rules('status','Status','required');
if($this->form_validation->run())
{
$school_id = $this->input->post('school_id');
$department_id = $this->input->post('department_id');
$first_name = $this->input->post('first_name');
$last_name = $this->input->post('last_name');
$username = $this->input->post('username');
$email_id = $this->input->post('email_id');
$system_id = $this->input->post('system_id');
if(!empty($this->input->post('password'))){
$password = sha1($this->input->post('password'));
}
$contact_number = $this->input->post('contact_number');
$status = $this->input->post('status');
$role_id = implode(',',$this->input->post('role_id'));
$access_id = implode(',',$this->input->post('access_id'));
$data=array(
'school_id'=>$school_id,
'department_id'=>$department_id,
'first_name'=>$first_name,
'last_name'=>$last_name,
'userName'=>$username,
'email_id'=>$email_id,
'system_id'=>$system_id,
'role_id'=>$role_id,
'access_id'=>$access_id,
'contact_number'=>$contact_number,
'status'=>$status,
'is_deleted'=>'0',
'createdon'=>date('y-m-d H:i:s')
);
if(!empty($this->input->post('password'))){ $data['password'] = $password; }
if($this->input->post('id')){
$id = $this->input->post('id');
$this->Common_Model->updateinfo($tbl_name='tbl_admin',$data,'id',$id);
setHistory('User info updated successfully');
} else {
$this->Common_Model->saveinfo($tbl_name='tbl_admin',$data);
setHistory('User info added successfully');
}
redirect('admin/advancesetting/user');
} else {
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/advancesetting/adduser');
$this->load->view('admin/_parts/footer');
}
} else {
$data['schoolArray'] = $this->Common_Model->SqlgetCommonIdArray('su_schools');
$data['accessArray'] = $this->Common_Model->getCommonIdArray('tbl_access_master');
$data['roleArray'] = $this->Common_Model->getCommonIdArray('tbl_role_master');
$data['sd'] = $sd = $this->Common_Model->getSingleRecord('tbl_admin',' * ', array('id'=>$uid));
if($sd)
{
$data['departmentArray'] = $this->Common_Model->SqlgetCommonIdArray('su_departments','*',array('school_id'=>$sd['school_id']));
} else {
$data['departmentArray'] = $this->Common_Model->SqlgetCommonIdArray('su_departments');
}
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/advancesetting/adduser',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to Add/Edit user info');
}
}
public function deleteuser($uid)
{
//$this->load->model('ManageUsers_Model');
$this->Common_Model->removeAllItems('tbl_admin',$uid,'id');
$this->session->set_flashdata('success', 'User data deleted');
setHistory('User data deleted');
redirect('admin/advancesetting/user');
}
}
?>
Kontol Shell Bypass