<?php

/**
 *
 * @author gregory
 */
class TimeKeeperMain {
    
    public $answerResponce;
                function __construct() {
        //include 'questionGenerators/subjects.php';
        //e107::js('timekeeper','js/my.js','jquery');	// Load Plugin javascript and include jQuery framework
        //e107::css('timekeeper','css/my.css');		// load css file
        //e107::lan('timekeeper'); 			// load language file ie. e107_plugins/timekeeper/languages/English.php
    }

    public function run() {
        //print_a($_COOKIE);
        //print_a($_POST);
        //$sql = e107::getDB();      // mysql class object
        $tp = e107::getParser();     // parser for converting to HTML and parsing templates etc.
        $sc = e107::getScBatch('timekeeper', TRUE); // loads e107_plugins/myplugin/myplugin_shortcodes.php
        $ns = e107::getRender();    // render in theme box.
        $form = new FormGenerator();

        
        if(!$this->answerResponce == '') {
            $ns->tablerender("Check answer", $this->answerResponce . '<br/>');
            header("Refresh:5");
            return;
        }
        
        //load development area for main site admin only
        if (check_class("Main Admin")&&false) {
            $ns->tablerender('Start of Developments Area', '<br/>');
            require_once (e_PLUGIN . 'timekeeper/DevelopmentArea.php');
            $ns->tablerender('End of Development Area', '<br/>');
        }

        //Check user submitted answer
        $submitButton = filter_input(INPUT_POST, 'Answered');
        $answerText = filter_input(INPUT_POST, 'a1');
        //print_a('-'.$answerText.'-');
        if (isset($submitButton)&&!empty($answerText)) {
            $AnswerChecker = new AnswerChecker();
            $text = $AnswerChecker->checkAnswers();
            $ns->tablerender("Check answer", $text . '<br/>');
        }

//print_a(['Development area'=>'head var','session'=>$_SESSION]);//============================= debug val

        /////////////////////////////////////////
        /// Student section
        /////////////////////////////////////////
        if (check_class("TIMEKEEPER_STUDENT")) {

            $debugQ = false;

            $countTotal = e107::getDb()->count("tkReport", "(id)", "username = '" . e107::getUser()->getLoginName() . "'");
            $currentPercent = 0;
            
            e107::getDb()->gen("SELECT COUNT(id) as cntr, CAST((SUM(correct)/COUNT(id)*10) as DECIMAL(5,2)) as percent
            FROM e107.`e107_tkReport` WHERE username = '" . e107::getUser()->getLoginName() . "'
            AND answereddatestamp >= unix_timestamp(CURRENT_DATE())
            AND answereddatestamp <= unix_timestamp(CURRENT_DATE() + INTERVAL 1 DAY)");
            $text .= '</tbody></table>';
            while ($row = e107::getDb()->fetch()) {
                $currentPercent = (int)$row['percent'];
            }

            if(empty($_COOKIE['tkQuestion']))
            {
                // Instanciate the new queation engine with debug settings.
                // 0 = Math
                // 1 = English 
                $newQuestions = new subjects((int) ($countTotal / 26000), $currentPercent, $debugQ);

                // get array of data for question
                $rawQuestion = $newQuestions->getQuestion();
                if ($debugQ) {
                    print_a(['rawQuestion'=>$rawQuestion,'countLevel'=>(int) ($countTotal / 26000),'rawPercent'=>$currentPercent,]);
                }
                
                setcookie('tkQuestion', base64_encode(json_encode($rawQuestion)), time()+7200);
                
            }else if(json_decode($rawQuestion,true)==""){
                setcookie('tkQuestion', "", time()+1);
                header("Refresh:2");
                print_a("Error: Blank question detected, resetting now. Please wait.");
            }else{
                //print_a('reuse session val.');
                $cookieQuestion = $_COOKIE['tkQuestion'];
                $rawQuestion = json_decode(base64_decode($cookieQuestion),true);
                print_a(json_decode($rawQuestion,true));
               
            }

            include('forms.php');
            $template = new forms($rawQuestion);
            $tmpdata = $template->templater();
            if ($debugQ) {
                print_a($tmpdata);
            }

            // Get question from engine
            $ns->tablerender("Question", $tmpdata);


//            $this->MainEntry();
//            $text = '';
//            $subject = $this->subjectSelector();
//            $year = $this->yearLevelSelector($subject);
//
//
//            //Return random generated question
//            $QG = new timekeeper_Question_Engine;
//            $QG->subjectSelector = $subject;
//            $QG->yearlevel = $year;
//            $content = $QG->GetRandomQuestion();
//            $text .= $content; //$this->renderQuestion($frm, $content);
//            $ns->tablerender("Question (Do not use)", $text . '<br/>');
        }

        /////////////////////////////////////////
        /// Teacher section
        /////////////////////////////////////////
        if (check_class("TIMEKEEPER_TEACHER")) {
            //$ns->tablerender("ExcelGenerator", $form->ExcelGenerator());
        }
    }

//    private function subjectRandomizer() {
//
//        $subjects = [
//            'english' => 0,
//            'pePd' => 0, //health-and-physical-education
//            'socialStudies' => 0, //humanities-and-social-sciences
//            'languages' => 0,
//            'mathematics' => 0,
//            'science' => 0,
//            'technologies' => 0,
//            'art' => 0,
//            'general' => 0 // general knowlage
//        ];
//        foreach ($this->activeSubjectsList as $key => $sub) {
//            $subjects[$key] = $sub['timekeeper_percent'] + rand(0, 200 / $sub['timekeeper_yearLevel']);
//        }
//        //print_a($subjects);
//        //print_a($this->activeSubjectsList);
//        return $subjects;
//    }

//    private function subjectSelector() {
//        $returnSubject = '';
//        $returnScore = 0;
//        foreach ($this->subjectRandomizer() as $sub => $score) {
//            if ($returnScore <= $score && $score <> 0) {
//                $returnSubject = $sub;
//                $returnScore = $score;
//            }
//        }
//        //print_a($returnSubject);
//        // Add maths as the starting subject for new users
//        if ($returnSubject === '') {
//            $returnSubject = 'mathematics';
//        }
//        return $returnSubject;
//    }

//    private function yearLevelSelector($subject) {
//        return 1;
//    }

    /**
     * Main entry point for checking and updating the statistics and year levels.
     *
     * Description needed once finished....TODO
     *
     */
//    private function MainEntry() {
//        $sql = e107::getDb();
//        $userName = e107::getUser()->getLoginName();
//
//        $this->GetActiveSubjects($sql, $userName);
//        $this->GetActiveYearForSubjects($sql, $userName);
//
//        $this->CheckSubjects($sql, $userName);
//    }

    /**
     * Get a list of active subjects.
     *
     * Populate the private class variable $activeSubjectsList with an array of active subjects for use in statistics and question selection.
     *
     */
//    private function GetActiveSubjects($sql, $userName) {
//        $this->activeSubjectsList = [];
//
//        $sql->gen("SELECT DISTINCT `timekeeper_subject` FROM e107.e107_timekeeperReport WHERE `timekeeper_username`='$userName';");
//        while ($row = $sql->fetch()) {
//            $this->activeSubjectsList = array_merge($this->activeSubjectsList, [$row['timekeeper_subject'] => []]);
//        }
//    }

    /**
     * Get the year level and percentage for the active subjects
     *
     * Populate the private class variable $activeSubjectsList with the current year level and correct percentage for the current subjects.
     *
     */
//    private function GetActiveYearForSubjects($sql, $userName) {
//
//        foreach ($this->activeSubjectsList as $subject => &$arrayHolder) {
//            $selectQuery = '`timekeeper_username` = \'' . $userName . '\' AND `timekeeper_subject` = \'' . $subject . '\' ORDER BY `timekeeper_yearLevel` DESC';
//            $arrayHolder = ($sql->retrieve('timekeeperStats', '`timekeeper_yearLevel`,`timekeeper_percent`', $selectQuery));
//        }
//    }

    /**
     * Check to see what subjects the user has answered questions for.
     *
     * This function gets a list of unique subjects from the `e107_timekeeperReport` database for the year level specified and uses that to get all answered questions for that subject to pass to 'UpdateYearAndStats'.
     *
     * @param int $yearlevel The year to check for records in the database.
     *
     */
//    private function CheckSubjects($sql, $userName) {
//        $activeSubjects = array();
//        $subjectToProcess = array();
//
//        foreach ($this->activeSubjectsList as $subject => $dataArrays) {
//            $tmpArray = array();
//            $sql->gen("SELECT * FROM e107.e107_timekeeperReport WHERE `timekeeper_username`='$userName' AND `timekeeper_yearLevel`=" . $dataArrays['timekeeper_yearLevel'] . " AND `timekeeper_subject`= '" . $subject . "' ORDER BY 'timekeeper_answereddatestamp' DESC LIMIT 1000;");
//            while ($row = $sql->fetch()) {
//                array_push($tmpArray, $row);
//            }
//            $subjectToProcess = ['userName' => $userName, 'subject' => $subject, 'yearlevel' => $dataArrays['timekeeper_yearLevel'], 'rows' => $tmpArray];
//            //print_a($subjectToProcess);
//            $this->UpdateYearAndStats($sql, $subjectToProcess);
//        }
//    }

//    private function BuildStatisticPdf($sql, $menuYear) {
//        //print_a(['BuildStatisticMenu',$menuYear]);
//        $userName = e107::getUser()->getLoginName();
//        $sql->gen("SELECT `timekeeper_subject`,`timekeeper_percent`,`timekeeper_quantity` FROM e107_timekeeperStats WHERE `timekeeper_yearLevel`=$menuYear AND `timekeeper_username`='$userName';");
//        $text = "<h4>Hello $userName</h4>"
//                . "You need to score at least 90% and answer at lest 1000 questions in each subject before you can progress to a higher level.</br>"
//                . "Your current level is <b>$menuYear</b></br>.";
//        while ($row = $sql->fetch()) {
//            $text .= 'For the subject ' . $row['timekeeper_subject'] . ' you have scored ' . $row['timekeeper_percent'] . '% and have completed ' . $row['timekeeper_quantity'] . ' questions.';
//        }
//        //$text .= $sql->getLastErrorText();
//        e107::getRender()->tablerender('Score', $text);
//    }

//    private function BuildStatisticPage($sql, $menuYear) {
//        //print_a(['BuildStatisticMenu',$menuYear]);
//        $userName = e107::getUser()->getLoginName();
//        $sql->gen("SELECT `timekeeper_subject`,`timekeeper_percent`,`timekeeper_quantity` FROM e107_timekeeperStats WHERE `timekeeper_yearLevel`=$menuYear AND `timekeeper_username`='$userName';");
//        $text = "<h4>Hello $userName</h4>"
//                . "You need to score at least 90% and answer at lest 1000 questions in each subject before you can progress to a higher level.</br>"
//                . "Your current level is <b>$menuYear</b></br>.";
//        while ($row = $sql->fetch()) {
//            $text .= 'For the subject ' . $row['timekeeper_subject'] . ' you have scored ' . $row['timekeeper_percent'] . '% and have completed ' . $row['timekeeper_quantity'] . ' questions.';
//        }
//        //$text .= $sql->getLastErrorText();
//        e107::getRender()->tablerender('Score', $text);
//    }

//    private function UpdateYearAndStats($sql, $subjectToProcess) {
//        $query = ['timekeeper_percent' => $this->getPercent($subjectToProcess['rows']), 'timekeeper_quantity' => count($subjectToProcess['rows'])];
//
//        $selectQuery = '`timekeeper_username` = \'' . $subjectToProcess['userName'] . '\' AND `timekeeper_subject` = \'' . $subjectToProcess['subject'] . '\' AND ' . '`timekeeper_yearLevel`=\'' . $subjectToProcess['yearlevel'] . '\'';
//        $updateQuery = array_merge($query, ['WHERE' => '`timekeeper_username`=\'' . $subjectToProcess['userName'] . '\' AND `timekeeper_subject`=\'' . $subjectToProcess['subject'] . '\' AND ' . '`timekeeper_yearLevel`=' . $subjectToProcess['yearlevel']]);
//        $insertQuery = array_merge($query, ['timekeeper_username' => $subjectToProcess['userName'], 'timekeeper_subject' => $subjectToProcess['subject'], 'timekeeper_yearLevel' => $subjectToProcess['yearlevel']]);
//
//        if ($sql->retrieve('timekeeperStats', 'timekeeper_id', $selectQuery) === NULL) {
//            $sql->insert('timekeeperStats', $insertQuery);
//        } else {
//            $sql->update('timekeeperStats', $updateQuery);
//        }
//        //print_a($updateQuery);
//        if (count($subjectToProcess['rows']) >= 1000 && (int) $this->getPercent($subjectToProcess['rows']) >= 92) {
//            $insertNewYear = ['timekeeper_percent' => 100, 'timekeeper_quantity' => 0, 'timekeeper_username' => $subjectToProcess['userName'], 'timekeeper_subject' => $subjectToProcess['subject'], 'timekeeper_yearLevel' => ((int) $subjectToProcess['yearlevel'] + 1)];
//            $sql->insert('timekeeperStats', $insertNewYear);
//            $ns = e107::getRender();
//            $ns->tablerender("Congratulations", 'Congratulations ' . e107::getUser()->getRealName() . ' you have moved up a year level for the subject ' . $subjectToProcess['subject'] . '.');
//        }
//    }

    ////////////////////////////////////////////////////////////////////////////
    ////////////////////////////////////////////////////////////////////////////
    ////////////////////////////////////////////////////////////////////////////
    //
    // Functions beyond here are working and don't need anymore work
    //
    ////////////////////////////////////////////////////////////////////////////
    ////////////////////////////////////////////////////////////////////////////


//    private function getPercent($subjectToProcess) {
//        $questions = 0;
//        $correct = 0;
//        foreach ($subjectToProcess as $dbCorrect) {
//            $questions++;
//            if ($dbCorrect['timekeeper_correct'] == 1) {
//                $correct++;
//            }
//            if ($questions >= 1000) {
//                break;
//            }
//        }
//        //prevent devision by zero
//        if (!$questions == 0) {
//            return (100 - ((($questions - $correct) / $questions) * 100));
//        } else {
//            return 0;
//        }
//    }

}