%PDF- <> %âãÏÓ endobj 2 0 obj <> endobj 3 0 obj <>/ExtGState<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI] >>/Annots[ 28 0 R 29 0 R] /MediaBox[ 0 0 595.5 842.25] /Contents 4 0 R/Group<>/Tabs/S>> endobj ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµùÕ5sLOšuY>endobj 2 0 obj<>endobj 2 0 obj<>endobj 2 0 obj<>endobj 2 0 obj<> endobj 2 0 obj<>endobj 2 0 obj<>es 3 0 R>> endobj 2 0 obj<> ox[ 0.000000 0.000000 609.600000 935.600000]/Fi endobj 3 0 obj<> endobj 7 1 obj<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]>>/Subtype/Form>> stream
<?php defined('BASEPATH') OR exit('No direct script access allowed'); class Reports extends CI_Controller { function __construct() { parent::__construct(); $this->load->database(); $this->load->model("report_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',$status='0',$fquid='0') { $data['limit']=$limit; $data['status']=$status; $data['title']= $this->lang->line('generate_report').' - '.$this->lang->line('quiz_tagline'); // fetching result list $logged_in=$this->session->userdata('logged_in'); if($logged_in['su']=='0') { exit($this->lang->line('permission_denied')); } $this->load->model("user_model"); $gid_list = array(); if($logged_in['su']=='1') { $gid_list = explode(',',$logged_in['gid']); } $data['group_list']=$this->user_model->group_list(NULL, $gid_list); if($logged_in['su']=='1') { $admin_id = $logged_in['uid']; } else { $admin_id = $this->input->post('uid');} $gids = array(); if($_POST){ $gid = $this->input->post('gid'); $logged_in=$this->session->userdata('logged_in'); $data['quiz_list'] = $quiz_list = $this->report_model->quiz_list($admin_id, $gid); $qulist = array(); foreach($quiz_list as $val) { $qulist[] = $val['quid']; } $data['result'] = ''; if(!empty($qulist)) { $data['result'] = $this->report_model->generate_report($qulist,$gid,$admin_id); } // Get Userlist $data['userRecords'] = $this->report_model->user_list($gid); if($_POST['download']){ $this->generate_report($data); } } // Get all admin user list $data['user_list'] = $this->report_model->user_list(NULL, '1'); $this->load->view('header',$data); $this->load->view('reports/report_list',$data); $this->load->view('footer',$data); setHistory('Go to report listing module'); } /* * Function : generate_report * */ function generate_report($data) { $logged_in=$this->session->userdata('logged_in'); if($logged_in['su']=='0') { exit($this->lang->line('permission_denied')); } $this->load->helper('download'); $quiz_list = $data['quiz_list']; $result = $data['result']; $userRecords = $data['userRecords']; $csvdata=$this->lang->line('s_no').",".$this->lang->line('full_name').",".$this->lang->line('email').",". $this->lang->line('group_name').",".$this->lang->line('system_id').",".$this->lang->line('contact_no').","; foreach($quiz_list as $row) { $csvdata .= $row['quiz_name'].","; } $csvdata .= "\r\n"; $k=1; foreach($userRecords as $rk => $val){ $full_name = $val['first_name'].' '.$val['last_name']; $full_name = str_replace(array(',',' '),' ',$full_name); $csvdata.=$k.",".$full_name.",".$val['email'].",".$val['group_name'].",".$val['system_id'].",".$val['contact_no'].","; foreach($result['other'] as $key=>$pvalarray) { $csvdata.= $pvalarray[$val['uid']]=='' ? "AB"."," : round($pvalarray[$val['uid']]['percentage_obtained'],2).","; } echo $csvdata.= "\r\n"; $k++; } $filename='quizbyte_report_'.time().'.csv'; force_download($filename, $csvdata); } }