<?php

class Assessments {
    private $table = "assessments";

    function __construct() {
    }
    
    function getAssessments($order='modified', $limit=20, $offset=0) {
         global $TeKe;
         $user_id = get_logged_in_user()->getId();
         $query = "SELECT * FROM " . DB_PREFIX . $this->table;
         $query .= $this->getWhereQuery();
         $query .= " ORDER BY {$order} DESC";
         $query .= " LIMIT {$limit} OFFSET {$offset}";
         $res = query_rows($query);
         return $res;
    }

    function getWhereQuery() {
        global $TeKe;
        $query = "";
        $query .= " WHERE";
        $query .= " deleted=false";
        if (!$TeKe->plugin->is_test_constructor()) {
            $user_id = get_logged_in_user()->getId();
            $query .= " AND proctor=".$user_id;
        }
        return $query;
    }

    function getPageCount($limit=20) {
        $query = "SELECT * FROM ". DB_PREFIX . $this->table;
        $query .= $this->getWhereQuery();
        $total_count = mysql_num_rows(query($query));
        $last_page = ceil($total_count/$limit);
        return $last_page;
    }

    function getCandidateByToken($token) {
        global $TeKe;
        $query = "SELECT * FROM ". DB_PREFIX . "candidates WHERE token='".$token."'";
        $res = query_row($query);
        if ($res) {
            $candidate_id = $res->id;
            return $candidate_id;
        }
        return false;
    }

    function getAssessmentByUserToken($token) {
        global $TeKe;
        $query = "SELECT * FROM ". DB_PREFIX . "candidates WHERE token='".$token."'";
        $res = query_row($query);
        if ($res) {
            $assessment_id = $res->assessment;
            $assessment = $TeKe->plugin->loadType("assessment", $assessment_id);
            return $assessment;
        }
        return false;
    }

    function getCandidateAssessment($token) {
        global $TeKe;
        $candidate = $this->getCandidateByToken($token);
        $query = "SELECT * FROM " . DB_PREFIX . "candidate_assessments WHERE candidate=" . $candidate;
        $res = query_row($query);
        if ($res) {
            $id = $res->id;
            $candidate_assessment = $TeKe->plugin->loadType("candidateAssessment", $id);
            return $candidate_assessment;
        }
        return false; 
    }
        
}
?>