EvaluatePaperFunctionController.php

Go to the documentation of this file.

<?php

class EvaluatePaperFunctionController extends Controller
{
    public function actionIndex()
    {
        $this->render('index');
    }
        
        public function comment($paperid, $comment)
        {
            Connect_DatabaseController::connect();
            
            $usid = Yii::app()->user->id;
            
            $sql_insert_comment="INSERT INTO paper_comment (paperid, content)
VALUES
('$paperid', '$comment')";
mysql_query($sql_insert_comment) or die (mysql_error());

            $findcomment = mysql_query("SELECT MAX(comment_id) AS comment_id FROM paper_comment WHERE content='$comment' AND paperid='$paperid'");
            
            while($row = mysql_fetch_array($findcomment))
            {
                $commentid = $row['comment_id'];
                
            $sql_insert_referee_comment="INSERT INTO referee_comment (comment_id, referee_id)
VALUES
( '$commentid', '$usid')";
mysql_query($sql_insert_referee_comment) or die (mysql_error());
                
            }
            echo "Comment Has Been Sent<br><br>";
            echo "<b>Your Comment : </b>" . $comment . "<br><br>";        
        }
        
        public function evaluate($recommendation, $categorization, $paperid)
        {
            Connect_DatabaseController::connect();
            
            $usid = Yii::app()->user->id;


            $sql_insert_evaluation="INSERT INTO paper_evaluation (recommendation, categorization, paper_id)
VALUES
('$recommendation', '$categorization', '$paperid')";
mysql_query($sql_insert_evaluation) or die (mysql_error());

            $findevaluation = mysql_query("SELECT MAX(evaluation_id) AS evaluation_id FROM paper_evaluation WHERE recommendation='$recommendation' AND categorization='$categorization' AND paper_id='$paperid'");
            
            while($row = mysql_fetch_array($findevaluation))
            {
                $evaluationid = $row['evaluation_id'];
                
            $sql_insert_referee_evaluation="INSERT INTO paper_evaluation_referee (referee_id, evaluation_id)
VALUES
( '$usid', '$evaluationid')";
mysql_query($sql_insert_referee_evaluation) or die (mysql_error());
                
            }
            echo "Evaluation Has Been Sent.<br><br>";
            

        }

    // 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',
            ),
        );
    }
    */
}