ikan Uploader :
Directory : /var/www/html/chalkbank.com/application/controllers/
Upload File : |
| Current File : /var/www/html/chalkbank.com/application/controllers/Qbank.php |
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Qbank extends CI_Controller {
function __construct()
{
parent::__construct();
$this->load->database();
$this->load->model("qbank_model");
$this->lang->load('basic', $this->config->item('language'));
// redirect if not loggedin
if(!$this->session->userdata('logged_in')){
redirect('login');
}
}
public function index($limit='0',$cid='0',$lid='0',$level='')
{
$this->load->helper('form');
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
// Question Bank Shared Option
$other_cids = $logged_in['catids'];
$data['category_list']= $category_list = $this->qbank_model->category_list($uid, $other_cids);
$data['level_list']=$this->qbank_model->level_list($uid, NULL, $other_cids);
$data['limit']=$limit;
$data['cid']=$cid;
$data['lid']=$lid;
$data['level']=$level;
$data['title']=$this->lang->line('qbank');
// fetching user list
if($uid=='9074' || $uid=='2529') {
if($cid>0) {
$data['result']=$this->qbank_model->question_list($limit,$cid,$lid,$uid, $level, NULL,$other_cids);
} else {
$cid = $category_list[0]['cid'];
$data['result']=$this->qbank_model->question_list($limit,$cid,$lid,$uid, $level, NULL,$other_cids);
}
} else {
$data['result']=$this->qbank_model->question_list($limit,$cid,$lid,$uid, $level, NULL,$other_cids);
}
$this->load->view('header',$data);
$this->load->view('question_list',$data);
$this->load->view('footer',$data);
setHistory('Go to manage Qbank');
}
public function rcparagraphs($limit='0',$cid='0',$lid='0',$level='')
{
$this->load->helper('form');
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
$data['category_list']=$this->qbank_model->category_list($uid);
$data['level_list']=$this->qbank_model->level_list($uid);
$data['limit']=$limit;
$data['cid']=$cid;
$data['lid']=$lid;
$data['level']=$level;
$data['title']=$this->lang->line('qbank');
// fetching user list
$data['result']=$this->qbank_model->rcquestion_list($limit,$cid,$lid,$uid, $level);
$this->load->view('header',$data);
$this->load->view('rcquestion_list',$data);
$this->load->view('footer',$data);
setHistory('Go to manage RC Question bank module');
}
function generate_report() {
$this->load->helper('download');
$last = $this->uri->total_segments();
$data['limit']=$this->uri->segment($last-2);
$cid = $this->uri->segment($last-1);
$lid = $this->uri->segment($last);
$logged_in=$this->session->userdata('logged_in');
$admin_id = '';
if($logged_in['su']=='1') { $admin_id = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
$result=$this->qbank_model->question_list($limit,$cid,$lid,$admin_id);
$csvdata=$this->lang->line('s_no').",".$this->lang->line('question_type').",Category, Level, Question, Correct Answer,Option One,Option Two,Option Three,Option Four\r\n";
$k=1;
foreach($result as $rk => $val){
$optionArray = $this->qbank_model->get_option($val['qid']);
$i=1;
foreach($optionArray as $qrow){
if($qrow['score']=='1'){
$q_option_match = $i;
}
$i++;
}
$q_option = strip_tags($optionArray['0']['q_option']);
$q_option_two = strip_tags($optionArray['1']['q_option']);
$q_option_three = strip_tags($optionArray['2']['q_option']);
$q_option_four = strip_tags($optionArray['3']['q_option']);
$csvdata.=$k.",".strip_tags($val['question_type']).",".strip_tags($val['category_name']).",".strip_tags($val['level_name']).",".str_replace(array('\r','\n',', '),'',strip_tags($val['question'])).",".$q_option_match.",".str_replace(array('\r','\n',', '),'',strip_tags($q_option)).",".str_replace(array('\r','\n',', '),'',strip_tags($q_option_two)).",".str_replace(array('\r','\n',', '),'',strip_tags($q_option_three)).",".str_replace(array('\r','\n',', '),'',strip_tags($q_option_four))."\r\n";
$k++;
}
$filename='question_bank-'.time().'.csv';
setHistory('Go to download Question List');
force_download($filename, $csvdata);
}
public function remove_rcquestion($qid){
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
if($this->qbank_model->remove_rcquestion($qid)){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('removed_successfully')." </div>");
}else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_remove')." </div>");
}
setHistory('Go to remove rcquestion');
redirect('qbank/rcparagraphs');
}
public function remove_question($qid){
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
if($this->qbank_model->remove_question($qid)){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('removed_successfully')." </div>");
}else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_remove')." </div>");
}
setHistory('Go to remove question');
redirect('qbank');
}
function pre_question_list($limit='0',$cid='0',$lid='0',$level='0'){
$cid=$this->input->post('cid');
$lid=$this->input->post('lid');
$level=$this->input->post('level');
setHistory('Go to pre question list.');
redirect('qbank/index/'.$limit.'/'.$cid.'/'.$lid.'/'.$level);
}
public function pre_new_question()
{
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
setHistory('Go to pre new question');
if($this->input->post('question_type')){
if($this->input->post('question_type')=='1'){
$nop=$this->input->post('nop');
if(!is_numeric($this->input->post('nop'))){
$nop=4;
}
redirect('qbank/new_question_1/'.$nop);
}
if($this->input->post('question_type')=='2'){
$nop=$this->input->post('nop');
if(!is_numeric($this->input->post('nop'))){
$nop=4;
}
redirect('qbank/new_question_2/'.$nop);
}
if($this->input->post('question_type')=='3'){
$nop=$this->input->post('nop');
if(!is_numeric($this->input->post('nop'))){
$nop=4;
}
redirect('qbank/new_question_3/'.$nop);
}
if($this->input->post('question_type')=='4'){
$nop=$this->input->post('nop');
if(!is_numeric($this->input->post('nop'))){
$nop=4;
}
redirect('qbank/new_question_4/'.$nop);
}
if($this->input->post('question_type')=='5'){
$nop=$this->input->post('nop');
if(!is_numeric($this->input->post('nop'))){
$nop=4;
}
redirect('qbank/new_question_5/'.$nop);
}
if($this->input->post('question_type')=='6'){
$nop=$this->input->post('nop');
if(!is_numeric($this->input->post('nop'))){
$nop=4;
}
redirect('qbank/new_question_6/'.$nop);
}
}
$data['title']=$this->lang->line('add_new').' '.$this->lang->line('question');
$this->load->view('header',$data);
$this->load->view('pre_new_question',$data);
$this->load->view('footer',$data);
}
public function new_question_1($nop='4')
{
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
if($this->input->post('question')){
$_POST['admin_id'] = $uid;
if($this->qbank_model->insert_question_1()){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('data_added_successfully')." </div>");
}else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_add_data')." </div>");
}
redirect('qbank/pre_new_question/');
}
$data['nop']=$nop;
$data['title']=$this->lang->line('add_new');
// fetching category list
$data['category_list']=$this->qbank_model->category_list($uid);
// fetching level list
$data['level_list']=$this->qbank_model->level_list($uid);
$this->load->view('header',$data);
$this->load->view('new_question_1',$data);
$this->load->view('footer',$data);
setHistory('Go to new question One');
}
public function new_question_2($nop='4')
{
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
if($this->input->post('question')){
$_POST['admin_id'] = $uid;
if($this->qbank_model->insert_question_2()){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('data_added_successfully')." </div>");
}else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_add_data')." </div>");
}
redirect('qbank/pre_new_question/');
}
$data['nop']=$nop;
$data['title']=$this->lang->line('add_new');
// fetching category list
$data['category_list']=$this->qbank_model->category_list();
// fetching level list
$data['level_list']=$this->qbank_model->level_list();
$this->load->view('header',$data);
$this->load->view('new_question_2',$data);
$this->load->view('footer',$data);
setHistory('Go to new question two');
}
public function new_question_3($nop='4')
{
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
if($this->input->post('question')){
$_POST['admin_id'] = $uid;
if($this->qbank_model->insert_question_3()){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('data_added_successfully')." </div>");
}else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_add_data')." </div>");
}
redirect('qbank/pre_new_question/');
}
$data['nop']=$nop;
$data['title']=$this->lang->line('add_new');
// fetching category list
$data['category_list']=$this->qbank_model->category_list();
// fetching level list
$data['level_list']=$this->qbank_model->level_list();
$this->load->view('header',$data);
$this->load->view('new_question_3',$data);
$this->load->view('footer',$data);
setHistory('Go to new question three');
}
public function new_question_4($nop='4')
{
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
if($this->input->post('question')){
$_POST['admin_id'] = $uid;
if($this->qbank_model->insert_question_4()){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('data_added_successfully')." </div>");
}else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_add_data')." </div>");
}
redirect('qbank/pre_new_question/');
}
$data['nop']=$nop;
$data['title']=$this->lang->line('add_new');
// fetching category list
$data['category_list']=$this->qbank_model->category_list();
// fetching level list
$data['level_list']=$this->qbank_model->level_list();
$this->load->view('header',$data);
$this->load->view('new_question_4',$data);
$this->load->view('footer',$data);
setHistory('Go to new question four');
}
public function new_question_5($nop='4')
{
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
if($this->input->post('question')){
$_POST['admin_id'] = $uid;
if($this->qbank_model->insert_question_5()){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('data_added_successfully')." </div>");
}else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_add_data')." </div>");
}
redirect('qbank/pre_new_question/');
}
$data['nop']=$nop;
$data['title']=$this->lang->line('add_new');
$data['title']=$this->lang->line('add_new');
// fetching category list
$data['category_list']=$this->qbank_model->category_list($uid);
// fetching level list
$data['level_list']=$this->qbank_model->level_list($uid);
$this->load->view('header',$data);
$this->load->view('new_question_5',$data);
$this->load->view('footer',$data);
setHistory('Go to new question five');
}
/*
* Function : new_question_6
*
*/
public function new_question_6($nop='4')
{
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
if($this->input->post('question')){
$_POST['admin_id'] = $uid;
$resp = $this->qbank_model->insert_question_6();
if($resp){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('data_added_successfully')." </div>");
}else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_add_data')." </div>");
}
redirect('qbank/rcparagraphs');
}
$data['nop']=$nop;
$data['title']=$this->lang->line('add_new');
// fetching category list
$data['category_list']=$this->qbank_model->category_list($uid);
// fetching level list
$data['level_list']=$this->qbank_model->level_list($uid);
$this->load->view('header',$data);
$this->load->view('new_question_6',$data);
$this->load->view('footer',$data);
setHistory('Go to new question six');
}
public function rc_new_question($rc_quid='4')
{
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
if($this->input->post('question')){
$_POST['admin_id'] = $uid;
if($this->qbank_model->insert_rc_question()){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('rc_question_added_successfully')." </div>");
}else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_add_data')." </div>");
}
redirect('qbank/rc_new_question/'.$_POST['rc_qid']);
}
$data['nop'] = $nop= '4'; // Define Number of options
// Title
$data['title']=$this->lang->line('add_new').' '.$this->lang->line('rc_answer_details');
// Get RC Question Details
$data['question'] = $this->qbank_model->get_rcquestion($rc_quid);
// fetching category list
$data['category_list']=$this->qbank_model->category_list($uid);
// fetching level list
$data['level_list']=$this->qbank_model->level_list($uid);
$this->load->view('header',$data);
$this->load->view('rc_new_question',$data);
$this->load->view('footer',$data);
setHistory('Go to rc new question');
}
public function view_rcquestion($qid)
{
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
$data['title'] = "View RC Question";
// fetching question
$data['question']=$this->qbank_model->get_rcquestion($qid);
$this->load->view('header',$data);
$this->load->view('view_rcquestion',$data);
$this->load->view('footer',$data);
setHistory('Go to view rcquestion details');
}
public function view_question($qid)
{
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
$data['title'] = "View Question";
// fetching question
$data['question']= $question = $this->qbank_model->get_question($qid);
$data['options']=$this->qbank_model->get_option($qid);
// Get Next Question
$result = $this->qbank_model->question_list($limit,$question['cid'],$question['lid'],$uid, $question['level'],$question['qid']);
$data['result'] = $result[0];
// fetching category list
$data['category_list']=$this->qbank_model->category_list($uid);
// fetching level list
$data['level_list']=$this->qbank_model->level_list($uid);
$this->load->view('header',$data);
$this->load->view('view_question',$data);
$this->load->view('footer',$data);
setHistory('Go to view question details');
}
public function edit_question_1($qid)
{
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
if($this->input->post('question')){
if($this->qbank_model->update_question_1($qid)){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('data_updated_successfully')." </div>");
}else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_update_data')." </div>");
}
redirect('qbank');
}
$data['title']=$this->lang->line('edit').' '.$this->lang->line('question');
// fetching question
$data['question']= $question = $this->qbank_model->get_question($qid);
$data['options']=$this->qbank_model->get_option($qid);
// fetching category list
$data['category_list']=$this->qbank_model->category_list($uid);
// fetching level list
$data['level_list']=$this->qbank_model->level_list($uid, $question['cid']);
$this->load->view('header',$data);
$this->load->view('edit_question_1',$data);
$this->load->view('footer',$data);
setHistory('Go to edit question One');
}
public function edit_question_2($qid)
{
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
if($this->input->post('question')){
if($this->qbank_model->update_question_2($qid)){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('data_updated_successfully')." </div>");
}else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_update_data')." </div>");
}
redirect('qbank/edit_question_2/'.$qid);
}
$data['title']=$this->lang->line('edit');
// fetching question
$data['question']=$this->qbank_model->get_question($qid);
$data['options']=$this->qbank_model->get_option($qid);
// fetching category list
$data['category_list']=$this->qbank_model->category_list($uid);
// fetching level list
$data['level_list']=$this->qbank_model->level_list($uid);
$this->load->view('header',$data);
$this->load->view('edit_question_2',$data);
$this->load->view('footer',$data);
setHistory('Go to edit question two');
}
public function edit_question_3($qid)
{
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
if($this->input->post('question')){
if($this->qbank_model->update_question_3($qid)){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('data_updated_successfully')." </div>");
}else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_update_data')." </div>");
}
redirect('qbank/edit_question_3/'.$qid);
}
$data['title']=$this->lang->line('edit');
// fetching question
$data['question']=$this->qbank_model->get_question($qid);
$data['options']=$this->qbank_model->get_option($qid);
// fetching category list
$data['category_list']=$this->qbank_model->category_list($uid);
// fetching level list
$data['level_list']=$this->qbank_model->level_list($uid);
$this->load->view('header',$data);
$this->load->view('edit_question_3',$data);
$this->load->view('footer',$data);
setHistory('Go to edit question three');
}
public function edit_question_4($qid)
{
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
if($this->input->post('question')){
if($this->qbank_model->update_question_4($qid)){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('data_updated_successfully')." </div>");
}else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_update_data')." </div>");
}
redirect('qbank/edit_question_4/'.$qid);
}
$data['title']=$this->lang->line('edit');
// fetching question
$data['question']=$this->qbank_model->get_question($qid);
$data['options']=$this->qbank_model->get_option($qid);
// fetching category list
$data['category_list']=$this->qbank_model->category_list($uid);
// fetching level list
$data['level_list']=$this->qbank_model->level_list($uid);
$this->load->view('header',$data);
$this->load->view('edit_question_4',$data);
$this->load->view('footer',$data);
setHistory('Go to edit question four');
}
public function edit_question_5($qid)
{
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
if($this->input->post('question')){
if($this->qbank_model->update_question_5($qid)){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('data_updated_successfully')." </div>");
}else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_update_data')." </div>");
}
redirect('qbank/edit_question_5/'.$qid);
}
$data['title']=$this->lang->line('edit');
// fetching question
$data['question']=$this->qbank_model->get_question($qid);
$data['options']=$this->qbank_model->get_option($qid);
// fetching category list
$data['category_list']=$this->qbank_model->category_list($uid);
// fetching level list
$data['level_list']=$this->qbank_model->level_list($uid);
$this->load->view('header',$data);
$this->load->view('edit_question_5',$data);
$this->load->view('footer',$data);
setHistory('Go to edit question five');
}
public function edit_question_6($qid)
{
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
if($this->input->post('question')){
if($this->qbank_model->update_question_6($qid)){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('data_updated_successfully')." </div>");
}else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_update_data')." </div>");
}
redirect('qbank/rcparagraphs');
}
$data['title']=$this->lang->line('edit');
// fetching question
if($qid>0){
$data['question']=$this->qbank_model->get_rcquestion($qid);
}
$this->load->view('header',$data);
$this->load->view('edit_question_6',$data);
$this->load->view('footer',$data);
setHistory('Go to edit rc question six');
}
public function edit_rcquestion_6($qid)
{
$logged_in=$this->session->userdata('logged_in');
$assignedModule = assignModuleList($logged_in['role_id']);
if(!array_key_exists('qbank',$assignedModule)) {
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; } else if($logged_in['su']=='0') { $uid = $logged_in['admin_id']; }
if($this->input->post('question')){
if($this->qbank_model->update_rcquestion_6($qid)){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('data_updated_successfully')." </div>");
redirect('qbank/rcparagraphs');
}else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_update_data')." </div>");
redirect('qbank/edit_rcquestion_6/'.$qid);
}
}
$data['title']=$this->lang->line('edit');
// Fetch Details
$data['question'] = $question = $this->qbank_model->get_rcquestion($qid);
// fetching category list
$data['category_list']=$this->qbank_model->category_list($uid);
// fetching level list
$data['level_list']=$this->qbank_model->level_list($uid);
$this->load->view('header',$data);
$this->load->view('edit_rcquestion_6',$data);
$this->load->view('footer',$data);
setHistory('Go to edit rcquestion six');
}
// category functions start
public function category_list(){
$logged_in=$this->session->userdata('logged_in');
if($logged_in['su']=='0'){
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; }
// fetching group list
$data['category_list']=$this->qbank_model->category_list($uid);
$data['title']=$this->lang->line('category_list');
$this->load->view('header',$data);
$this->load->view('category_list',$data);
$this->load->view('footer',$data);
setHistory('Go to category list');
}
public function insert_category()
{
$logged_in=$this->session->userdata('logged_in');
if($logged_in['su']=='0'){
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; }
$_POST['admin_id'] = $uid;
if($this->qbank_model->insert_category()){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('data_added_successfully')." </div>");
} else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_add_data')." </div>");
}
setHistory('Go to insert category list');
redirect('qbank/category_list/');
}
public function update_category($cid)
{
$logged_in=$this->session->userdata('logged_in');
if($logged_in['su']=='0'){
exit($this->lang->line('permission_denied'));
}
if($this->qbank_model->update_category($cid)){
echo "<div class='alert alert-success'>".$this->lang->line('data_updated_successfully')." </div>";
}else{
echo "<div class='alert alert-danger'>".$this->lang->line('error_to_update_data')." </div>";
}
setHistory('Go to update category list');
}
public function remove_category($cid){
$logged_in=$this->session->userdata('logged_in');
if($logged_in['su']=='0'){
exit($this->lang->line('permission_denied'));
}
if($this->qbank_model->remove_category($cid)){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('removed_successfully')." </div>");
}else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_remove')." </div>");
}
setHistory('Go to remove category');
redirect('qbank/category_list');
}
// category functions end
// level functions start
public function level_list(){
$condArray = array();
$logged_in=$this->session->userdata('logged_in');
if($logged_in['su']=='0'){
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') {
$uid = $logged_in['uid'];
$condArray['admin_id'] = $uid;
}
if($_POST['search']){
$condArray['search'] = $_POST['search'];
}
if($_POST['cid']){
$condArray['cid'] = $_POST['cid'];
$data['cid'] = $_POST['cid'];
}
// fetching level list
$data['level_list']=$this->qbank_model->level_list_array('savsoft_level',$condArray);
$data['category_list']=$this->qbank_model->category_list_array($uid);
$data['title'] = $this->lang->line('level_list');
$this->load->view('header',$data);
$this->load->view('level/index',$data);
$this->load->view('footer',$data);
setHistory('Go to view level list');
}
// addelevel functions start
public function addlevel(){
$logged_in=$this->session->userdata('logged_in');
if($logged_in['su']=='0'){
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; }
// fetching level list
if($_GET['edit']>0){
$id = $_GET['edit'];
$data['sd'] = $sd = $this->qbank_model->single_level_details($uid,$id);
if(empty($sd)){
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('permission_denied')." </div>");
redirect('qbank/level_list');
}
}
// Fetching category list
$data['category_list']=$this->qbank_model->category_list($uid);
$data['title']=$this->lang->line('level_list');
$this->load->view('header',$data);
$this->load->view('level/addlevel',$data);
$this->load->view('footer',$data);
setHistory('Go to view level list');
}
public function insert_level($lid=0)
{
$logged_in=$this->session->userdata('logged_in');
if($logged_in['su']=='0'){
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']>='1') { $uid = $logged_in['uid']; }
$_POST['admin_id'] = $uid;
if($lid>0){
if($this->qbank_model->update_level($lid)){
echo "<div class='alert alert-success'>".$this->lang->line('data_updated_successfully')." </div>";
} else {
echo "<div class='alert alert-danger'>".$this->lang->line('error_to_update_data')." </div>";
}
setHistory('Go to update level');
} else {
if($this->qbank_model->insert_level()){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('data_added_successfully')." </div>");
} else {
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_add_data')." </div>");
}
setHistory('Go to insert level');
}
redirect('qbank/level_list');
}
public function update_level($lid)
{
$logged_in=$this->session->userdata('logged_in');
if($logged_in['su']=='0'){
exit($this->lang->line('permission_denied'));
}
if($this->qbank_model->update_level($lid)){
echo "<div class='alert alert-success'>".$this->lang->line('data_updated_successfully')." </div>";
}else{
echo "<div class='alert alert-danger'>".$this->lang->line('error_to_update_data')." </div>";
}
setHistory('Go to Update level');
}
public function remove_level($lid)
{
$logged_in=$this->session->userdata('logged_in');
if($logged_in['su']=='0'){
exit($this->lang->line('permission_denied'));
}
if($this->qbank_model->remove_level($lid)){
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('removed_successfully')." </div>");
}else{
$this->session->set_flashdata('message', "<div class='alert alert-danger'>".$this->lang->line('error_to_remove')." </div>");
}
setHistory('Go to remove level list');
redirect('qbank/level_list');
}
// level functions end
function import()
{
$logged_in=$this->session->userdata('logged_in');
if($logged_in['su']=='0'){
exit($this->lang->line('permission_denied'));
}
$uid = '';
if($logged_in['su']=='1') { $uid = $logged_in['uid']; }
$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();
//echo '---------------------------------'.PHP_EOL;
//echo 'Starting memory: '.$StartMem.PHP_EOL;
//echo '---------------------------------'.PHP_EOL;
try
{
$Spreadsheet = new SpreadsheetReader($Filepath);
$BaseMem = memory_get_usage();
$Sheets = $Spreadsheet -> Sheets();
//echo '---------------------------------'.PHP_EOL;
//echo 'Spreadsheets:'.PHP_EOL;
//print_r($Sheets);
//echo '---------------------------------'.PHP_EOL;
//echo '---------------------------------'.PHP_EOL;
foreach ($Sheets as $Index => $Name)
{
//echo '---------------------------------'.PHP_EOL;
//echo '*** Sheet '.$Name.' ***'.PHP_EOL;
//echo '---------------------------------'.PHP_EOL;
$Time = microtime(true);
$Spreadsheet -> ChangeSheet($Index);
foreach ($Spreadsheet as $Key => $Row)
{
//echo $Key.': ';
if ($Row)
{
//print_r($Row);
$allxlsdata[] = $Row;
}
else
{
var_dump($Row);
}
$CurrentMem = memory_get_usage();
//echo 'Memory: '.($CurrentMem - $BaseMem).' current, '.$CurrentMem.' base'.PHP_EOL;
//echo '---------------------------------'.PHP_EOL;
if ($Key && ($Key % 500 == 0))
{
//echo '---------------------------------'.PHP_EOL;
//echo 'Time: '.(microtime(true) - $Time);
//echo '---------------------------------'.PHP_EOL;
}
}
// echo PHP_EOL.'---------------------------------'.PHP_EOL;
//echo 'Time: '.(microtime(true) - $Time);
//echo PHP_EOL;
//echo '---------------------------------'.PHP_EOL;
//echo '*** End of sheet '.$Name.' ***'.PHP_EOL;
//echo '---------------------------------'.PHP_EOL;
}
}
catch (Exception $E)
{
echo $E -> getMessage();
}
$this->qbank_model->import_question($allxlsdata,$uid);
}
} else{
echo "Error: " . $_FILES["file"]["error"];
}
$this->session->set_flashdata('message', "<div class='alert alert-success'>".$this->lang->line('data_imported_successfully')." </div>");
setHistory('Go to Import Question');
redirect('qbank');
}
}
Kontol Shell Bypass