AdminviewevaluationsController.php

Go to the documentation of this file.

<?php

class AdminviewevaluationsController extends Controller
{
    public function actionIndex()
    {
        $this->render('index');
    }

    public function comments($paperid)
    {
        
            Connect_DatabaseController::connect();

            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;

            //select all conferences that the user has admin as his user type
            $comment = mysql_query("SELECT * FROM paper_comment WHERE paperid='$paperid'");

        if(mysql_num_rows($comment)!=0)
        {
            while($row = mysql_fetch_array($comment))
            {
                
                $content = $row['content'];
                $commentid = $row['comment_id'];
                $referee = mysql_query("SELECT * FROM users WHERE userid IN (SELECT DISTINCT referee_id FROM referee_comment WHERE comment_id='$commentid')");
                
                while($row2 = mysql_fetch_array($referee))
                {
                    $refereename = $row2['username'];
                    
                    echo "<b>" . $refereename . " : </b>" . $content . "<br><br>";
                    
                }
        }}
        else echo "There are no comments for this paper.<br><br>";
        
    }

    public function view_evaluation($paperid)
    {
        
            Connect_DatabaseController::connect();

            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;

            //select all conferences that the user has admin as his user type
            $evaluation = mysql_query("SELECT * FROM paper_evaluation WHERE paper_id='$paperid'");

        if(mysql_num_rows($evaluation)!=0)
        {
            while($row = mysql_fetch_array($evaluation))
            {
                
                $recommendation = $row['recommendation'];
                $categorization = $row['categorization'];
                $evaluationid = $row['evaluation_id'];
                $referee = mysql_query("SELECT * FROM users WHERE userid IN (SELECT DISTINCT referee_id FROM paper_evaluation_referee WHERE evaluation_id='$evaluationid')");
                
                while($row2 = mysql_fetch_array($referee))
                {
                    $refereename = $row2['username'];
                    
                    echo "<b><b>" . $refereename . " : </b></b><br>";
                    echo "<b>Recommendation : </b>" ; echo  $this->recommendation($recommendation) . "<br>";
                    echo "<b>Categorization : </b>" ; echo  $this->categorization($categorization) . "<br><br>";
                }
        }}
        else echo "There are no evaluations for this paper.<br><br>";
        
    }
    
    public function recommendation($recommendation)
    {
        if($recommendation==0) echo "Reject";
        else if($recommendation==1) echo "Probable Reject";
        else if($recommendation==2) echo "Marginal Tend To Reject";
        else if($recommendation==3) echo "Marginal Tend To Accept";
        else if($recommendation==4) echo "Probable Accept";
        else if($recommendation==5) echo "Accept";
        
    }

    public function categorization($categorization)
    {
        if($categorization==0) echo "Highly Theoretical";
        else if($categorization==1) echo "Tends Towards Theoretical";
        else if($categorization==2) echo "Balanced Theory And Practice";
        else if($categorization==3) echo "Tends Towards Practical";
        else if($categorization==4) echo "Highly Practical";

        
    }
    
    // Uncomment the following methods and override them if needed
    /*
    public function filters()
    {
        // return the filter configuration for this controller, e.g.:
        return array(
            'inlineFilterName',
            array(
                'class'=>'path.to.FilterClass',
                'propertyName'=>'propertyValue',
            ),
        );
    }

    public function actions()
    {
        // return external action classes, e.g.:
        return array(
            'action1'=>'path.to.ActionClass',
            'action2'=>array(
                'class'=>'path.to.AnotherActionClass',
                'propertyName'=>'propertyValue',
            ),
        );
    }
    */
}