ikan Uploader :
Directory : /home/ubuntu/chalkbank/application/models/
Upload File : |
| Current File : //home/ubuntu/chalkbank/application/models/Result_model.php |
<?php
Class Result_model extends CI_Model
{
Public function __construct(){
parent::__construct();
$db2 = $this->load->database('readerdb', TRUE);
}
function result_list($limit,$status='0', $admin_id = ''){
$db2 = $this->load->database('readerdb', TRUE);
$result_open=$this->lang->line('open');
$logged_in=$this->session->userdata('logged_in');
$uid=$logged_in['uid'];
if($this->input->post('search')){
$search=$this->input->post('search');
$db2->or_where('savsoft_users.email',$search);
$db2->or_where('savsoft_users.first_name',$search);
$db2->or_where('savsoft_users.last_name',$search);
$db2->or_where('savsoft_users.contact_no',$search);
$db2->or_where('savsoft_result.rid',$search);
$db2->or_where('savsoft_quiz.quiz_name',$search);
}
$db2->where('savsoft_result.result_status !=',$result_open);
// echo $logged_in['role_id']; die;
if($logged_in['su']=='0'){
$db2->where('savsoft_result.uid',$uid);
} else if(in_array('5',explode(',',$logged_in['role_id']))) {
//$db2->where('savsoft_users.gid',$logged_in['gid']);
}
if($this->input->post('fquid')){
$db2->where('savsoft_result.quid',$this->input->post('fquid'));
}
if($status !='0'){
$db2->where('savsoft_result.result_status',$status);
}
if($admin_id !=''){
$db2->where('savsoft_result.quid',$this->input->post('fquid'));
}
$db2->limit($this->config->item('number_of_rows'),$limit);
$db2->order_by('rid','desc');
$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');
//echo $db2->last_query(); die;
return $query->result_array();
}
function quiz_list($admin_id = ''){
$db2 = $this->load->database('readerdb', TRUE);
if($admin_id>0){
$db2->where('savsoft_quiz.admin_id',$admin_id);
}
$db2->order_by('quid','desc');
$query=$db2->get('savsoft_quiz');
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($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');
if($quid != '0'){
$db2->where('savsoft_result.quid',$quid);
}
if($admin_id != ''){
//$db2->where('savsoft_users.admin_id',$admin_id);
}
if($gid != '0'){
$db2->where('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;
return $query->result_array();
}
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