ikan Uploader :
Directory : /proc/self/root/home/ubuntu/chalkbank/application/models/
Upload File : |
| Current File : //proc/self/root/home/ubuntu/chalkbank/application/models/Report_model.php |
<?php
Class Report_model extends CI_Model
{
Public function __construct(){
parent::__construct();
$db2 = $this->load->database('readerdb', TRUE);
}
function user_list($gid='', $type=''){
$db2 = $this->load->database('readerdb', TRUE);
$db2->select('savsoft_users.*,group_name');
if($this->input->post('search')){
$search=$this->input->post('search');
$db2->or_like('savsoft_users.email',$search);
$db2->or_like('savsoft_users.user_email',$search);
$db2->or_like('savsoft_users.first_name',$search);
$db2->or_like('savsoft_users.last_name',$search);
$db2->or_like('savsoft_users.contact_no',$search);
$db2->or_like('savsoft_users.school_name',$search);
$db2->or_like('savsoft_users.system_id',$search);
}
if(!empty($gid)){
$db2->where_in('savsoft_group.gid', $gid);
}
if($limit!=''){
$db2->limit($this->config->item('number_of_rows'),$limit);
}
if($type!='') {
$db2->where('savsoft_users.su>=', $type);
}
$db2->where('savsoft_users.verify_code','0');
$db2->where('savsoft_users.status','1');
$db2->where('savsoft_users.is_deleted','0');
$db2->order_by('savsoft_users.first_name','ASC');
$db2->join('savsoft_group', 'savsoft_users.gid=savsoft_group.gid');
$query = $db2->get('savsoft_users');
//echo $this->db->last_query(); die('TEST');
return $query->result_array();
}
/*
* Function : quiz_list
*
*/
function quiz_list($admin_id = '', $gidArray = ''){
$db2 = $this->load->database('readerdb', TRUE);
$date1=$this->input->post('date1');
$date2=$this->input->post('date2');
if($admin_id>0){
$db2->where('savsoft_quiz.admin_id',$admin_id);
}
if($date1 != ''){
$date1 = $date1.' 00:00';
$db2->where('savsoft_quiz.start_date >=',strtotime($date1));
}
if($date2 != ''){
$date2 = $date2.' 23:59';
$db2->where('savsoft_quiz.end_date <=',strtotime($date2));
}
$gids_list = implode(',',$gidArray);
//$db2->where("savsoft_quiz.gids IN ($gids_list)");
if(!empty($gidArray)) {
$find_in_set = array();
foreach($gidArray as $value){
$find_in_set[] = " FIND_IN_SET ('".$value."', savsoft_quiz.gids) ";
}
$implodeValues = implode(' OR ', $find_in_set);
}
$db2->where(" ($implodeValues)");
$db2->where('savsoft_quiz.quiz_type','1');
$db2->order_by('quid','desc');
$query=$db2->get('savsoft_quiz');
//echo $db2->last_query(); die;
return $query->result_array();
}
function remove_result($rid){
$this->db->where('savsoft_result.rid',$rid);
if($this->db->delete('savsoft_result')){
$this->db->where('rid',$rid);
$this->db->delete('savsoft_answers');
$this->db->where('rid',$rid);
$this->db->delete('savsoft_leaderboard');
return true;
}else{
return false;
}
}
function quiz_qlist($limit, $list_uid=''){
$db2 = $this->load->database('readerdb', TRUE);
$logged_in=$this->session->userdata('logged_in');
if($logged_in['su']=='0'){
$gid=$logged_in['gid'];
$where="FIND_IN_SET('".$gid."', gids)";
$db2->where($where);
}
if($list_uid!=''){
$db2->where('savsoft_quiz.admin_id',$list_uid);
}
if($this->input->post('search') && $logged_in['su']=='1'){
$search=$this->input->post('search');
$db2->or_where('quid',$search);
$db2->or_like('quiz_name',$search);
$db2->or_like('description',$search);
}
$db2->limit($this->config->item('number_of_rows'),$limit);
$db2->order_by('quid','desc');
$query=$db2->get('savsoft_quiz');
return $query->result_array();
}
/*
* Function : generate_report
*
*/
function generate_report($quid,$gid, $admin_id=''){
$db2 = $this->load->database('readerdb', TRUE);
$logged_in=$this->session->userdata('logged_in');
$uid=$logged_in['uid'];
$date1=$this->input->post('date1');
$date2=$this->input->post('date2');
$db2->select('savsoft_users.uid,savsoft_result.quid, savsoft_result.rid,savsoft_users.gid,savsoft_result.start_time,savsoft_result.percentage_obtained');
if($quid != ''){
$db2->where_in('savsoft_result.quid',$quid);
}
if($admin_id != ''){
//$db2->where('savsoft_users.admin_id',$admin_id);
}
if($gid != ''){
$db2->where_in('savsoft_users.gid',$gid);
}
if($date1 != ''){
$date1 = $date1.' 00:00';
$db2->where('savsoft_result.start_time >=',strtotime($date1));
}
if($date2 != ''){
$date2 = $date2.' 23:59';
$db2->where('savsoft_result.start_time <=',strtotime($date2));
}
$db2->order_by('rid','desc');
$db2->join('savsoft_users','savsoft_users.uid=savsoft_result.uid');
$db2->join('savsoft_group','savsoft_group.gid=savsoft_users.gid');
$db2->join('savsoft_quiz','savsoft_quiz.quid=savsoft_result.quid');
$query = $db2->get('savsoft_result');
//echo $db2->last_query(); die;
$response['full'] = $query->result_array();
$user_wise_quiz_result = array();
foreach($query->result_array() as $val){
$user_wise_quiz_result[$val['quid']][$val['uid']] = $val;
}
//print_r($user_wise_quiz_result); die;
$response['other'] = $user_wise_quiz_result;
return $response;
}
function get_result($rid, $uid=0)
{
$db2 = $this->load->database('readerdb', TRUE);
$logged_in=$this->session->userdata('logged_in');
$db2->where('savsoft_result.rid',$rid);
if($uid>0){
$db2->where('savsoft_users.uid',$uid);
}
$db2->join('savsoft_users','savsoft_users.uid=savsoft_result.uid');
$db2->join('savsoft_group','savsoft_group.gid=savsoft_users.gid');
$db2->join('savsoft_quiz','savsoft_quiz.quid=savsoft_result.quid');
$query=$db2->get('savsoft_result');
//echo $db2->last_query(); die;
return $query->row_array();
}
function last_ten_result($quid){
$db2 = $this->load->database('readerdb', TRUE);
$db2->order_by('percentage_obtained','desc');
$db2->limit(10);
$db2->where('savsoft_result.quid',$quid);
$db2->join('savsoft_users','savsoft_users.uid=savsoft_result.uid');
$db2->join('savsoft_quiz','savsoft_quiz.quid=savsoft_result.quid');
$query=$db2->get('savsoft_result');
return $query->result_array();
}
function get_percentile($quid,$uid,$score)
{
$db2 = $this->load->database('readerdb', TRUE);
$logged_in =$this->session->userdata('logged_in');
$gid= $logged_in['gid'];
$res=array();
$db2->where("savsoft_result.quid",$quid);
//$db2->group_by("savsoft_result.uid");
$db2->order_by("savsoft_result.score_obtained",'DESC');
$query = $this -> db -> get('savsoft_result');
$res[0]=$query -> num_rows();
$db2->where("savsoft_result.quid",$quid);
$db2->where("savsoft_result.uid !=",$uid);
if($score!=NULL){
$db2->where("savsoft_result.score_obtained <=",$score);
}
//$db2->group_by("savsoft_result.uid");
$db2->order_by("savsoft_result.score_obtained",'DESC');
$querys = $this -> db -> get('savsoft_result');
//echo $db2->last_query(); die;
$res[1]=$querys -> num_rows();
return $res;
}
}
?>
Kontol Shell Bypass