<?php
class lists{
    public static function generate_guidelist($filter){        
        $result = '';
        if(!$filter){
            $guides = \SQL\GO_TRAINER_GENERATE_GUIDELIST::QQ();
            while($guide = $guides->next()){
            $avg_rating = \SQL\GO_TRAINER_GET_AVERAGE_GUIDE_RATING::Q1(array($guide['id']));
            if($avg_rating['AVG(rating)'] < 1.5 && $avg_rating['AVG(rating)'] > 0){
                $guide['average_rating_img'] = './api.php?call=files&cat=rating&id=rating_1.jpg';
            }
            elseif($avg_rating['AVG(rating)'] >= 1.5 && $avg_rating['AVG(rating)'] < 2.5){
                $guide['average_rating_img'] = './api.php?call=files&cat=rating&id=rating_2.jpg';
            }
            elseif($avg_rating['AVG(rating)'] >= 2.5 && $avg_rating['AVG(rating)'] < 3.5){
                $guide['average_rating_img'] = './api.php?call=files&cat=rating&id=rating_3.jpg';
            }
            elseif($avg_rating['AVG(rating)'] >= 3.5){
                $guide['average_rating_img'] = './api.php?call=files&cat=rating&id=rating_4.jpg';
            }
            else{
                $guide['average_rating_img'] = './api.php?call=files&cat=rating&id=rating_none.jpg';
            }
            $guide['guide_created'] = \SYSTEM\time::time_ago_string(strtotime($guide['created']));
            $guide['guide_last_edit'] = \SYSTEM\time::time_ago_string(strtotime($guide['last_edit']));
            $guide['guide_author_arr'] = \SQL\GO_TRAINER_ID_TO_USERNAME::Q1(array($guide['author']));
            $guide['guide_author'] = $guide['guide_author_arr']['username'];
            $result .= SYSTEM\PAGE\replace::replaceFile((new PPAGE('default_guides/tpl/guide_list_item.tpl'))->SERVERPATH(), $guide);
        }
        return $result;
        }
        else{
            $searchstring = '%'.$filter.'%';
            $guides = \SQL\GO_TRAINER_GENERATE_GUIDELIST_SEARCH::QA(array($searchstring, $searchstring));   
            foreach($guides as $guide){
            $avg_rating = \SQL\GO_TRAINER_GET_AVERAGE_GUIDE_RATING::Q1(array($guide['id']));
            if($avg_rating['AVG(rating)'] < 1.5 && $avg_rating['AVG(rating)'] > 0){
                $guide['average_rating_img'] = './api.php?call=files&cat=rating&id=rating_1.jpg';
            }
            elseif($avg_rating['AVG(rating)'] >= 1.5 && $avg_rating['AVG(rating)'] < 2.5){
                $guide['average_rating_img'] = './api.php?call=files&cat=rating&id=rating_2.jpg';
            }
            elseif($avg_rating['AVG(rating)'] >= 2.5 && $avg_rating['AVG(rating)'] < 3.5){
                $guide['average_rating_img'] = './api.php?call=files&cat=rating&id=rating_3.jpg';
            }
            elseif($avg_rating['AVG(rating)'] >= 3.5){
                $guide['average_rating_img'] = './api.php?call=files&cat=rating&id=rating_4.jpg';
            }
            else{
                $guide['average_rating_img'] = './api.php?call=files&cat=rating&id=rating_none.jpg';
            }
            $guide['guide_created'] = \SYSTEM\time::time_ago_string(strtotime($guide['created']));
            $guide['guide_last_edit'] = \SYSTEM\time::time_ago_string(strtotime($guide['last_edit']));
            $guide['guide_author_arr'] = \SQL\GO_TRAINER_ID_TO_USERNAME::Q1(array($guide['author']));
            $guide['guide_author'] = $guide['guide_author_arr']['username'];
            $result .= SYSTEM\PAGE\replace::replaceFile((new PPAGE('default_guides/tpl/guide_list_item.tpl'))->SERVERPATH(), $guide);
        }
        return $result;
        }
        
    }
    public static function generate_guidelist_by_author($author){        
        $result = '';
            $guides = \SQL\GO_TRAINER_GENERATE_GUIDELIST_BY_AUTHOR::QA(array($author));
        foreach($guides as $guide){
            $avg_rating = \SQL\GO_TRAINER_GET_AVERAGE_GUIDE_RATING::Q1(array($guide['id']));
            if($avg_rating['AVG(rating)'] < 1.5 && $avg_rating['AVG(rating)'] > 0){
                $guide['average_rating_img'] = './api.php?call=files&cat=rating&id=rating_1.jpg';
            }
            elseif($avg_rating['AVG(rating)'] >= 1.5 && $avg_rating['AVG(rating)'] < 2.5){
                $guide['average_rating_img'] = './api.php?call=files&cat=rating&id=rating_2.jpg';
            }
            elseif($avg_rating['AVG(rating)'] >= 2.5 && $avg_rating['AVG(rating)'] < 3.5){
                $guide['average_rating_img'] = './api.php?call=files&cat=rating&id=rating_3.jpg';
            }
            elseif($avg_rating['AVG(rating)'] >= 3.5){
                $guide['average_rating_img'] = './api.php?call=files&cat=rating&id=rating_4.jpg';
            }
            else{
                $guide['average_rating_img'] = './api.php?call=files&cat=rating&id=rating_none.jpg';
            }
            $guide['average_rating'] = $avg_rating['AVG(rating)'];
            $result .= SYSTEM\PAGE\replace::replaceFile((new PPAGE('default_account_panel/tpl/default_account_panel_guides_written_guide.tpl'))->SERVERPATH(), $guide);
        }
        
        return $result;
    }
    public static function generate_commentlist_by_author($author){        
        $result = '';
        $comments = \SQL\GO_TRAINER_GENERATE_COMMENTLIST_BY_AUTHOR::QA(array($author));
        foreach($comments as $comment){
            $result .= SYSTEM\PAGE\replace::replaceFile((new PPAGE('default_account_panel/tpl/default_account_panel_comments_written_comment.tpl'))->SERVERPATH(), $comment);
        }
        
        return $result;
    }
}