MypapersController.php

Go to the documentation of this file.

<?php

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

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

            Connect_DatabaseController::connect();
       
            //select all papers that the user has submitted from paper_author table
            $administrating = mysql_query("SELECT DISTINCT conferenceid FROM conference_user_type WHERE userid='$usid' AND usertype=1");
            $i=0;

            while($row = mysql_fetch_array($administrating))
                    {

                    $asd = $row['conferenceid'];

                    $result1 = mysql_query("SELECT paperid FROM conference_paper WHERE conferenceid=$asd");
                            if($result1!=NULL){
                                    while($row2 = mysql_fetch_array($result1))
                                    {
                                        $paper = $row2['paperid'];
                                        
                                        $result2 = mysql_query("SELECT paper_name FROM paper WHERE id=$paper");
                                        
                                        if($result2!=NULL){
                                            while($row3 = mysql_fetch_array($result2))
                                            {/*
                                        $co = $row2['paperid'];
                                        echo "<B>".($i+1)."</B>" . ") Paper Name : " . $row3['paper_name'];

                                        echo "<br/>";
                                        echo "<a href=\" ./index.php?r=paper/view&id=$co\">View Paper </a>";
                                        echo "<br/>";
                                        echo "<br/>";
                                        */
                                        $i++;
                                            }
                                        }
                                    }

                            }
                            else {echo "No Papers";}

            }
            
            if($i===0) echo "You are not administrating any papers.";
            else 
            {
                echo "<a href=\" ./index.php?r=admintableviewall/index&sort=1\">View All Papers Belonging to Your Conferences </a><br><br>";
                echo "<a href=\" ./index.php?r=admintableview/index&sort=1\">Approve/Reject Papers Belonging to Your Conferences </a><br><br>";
                echo "<a href=\" ./index.php?r=assignment_function/index\"> Assign Referees Automatically </a><br><br>";    
            }
            
                            }
        
        public function authoring()
        {
            
            if(Yii::app()->user->id != NULL)
            $usid = Yii::app()->user->id;
            else
            $usid = 0;

            Connect_DatabaseController::connect();            

            //select all papers that the user has submitted from paper_author table
            $authoring = mysql_query("SELECT DISTINCT paperid FROM paper_author WHERE userid='$usid'");
            $i=0;

            while($row = mysql_fetch_array($authoring))
                    {

                    $asd = $row['paperid'];
                    $result1 = mysql_query("SELECT * FROM paper WHERE id='$asd'");

                    while($row2 = mysql_fetch_array($result1))
                            {
                            echo "<B>".($i+1)."</B>" . ") Paper Name : " . $row2['name'];
                            echo "  ";
                            }

            //  echo "<br />";
            //  echo "Conference ID   : " . $row['conferenceid'];
                    $co = $row['paperid'];
                    echo "<br />";
            //      echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
                            echo "<a href=\" ./index.php?r=paper/view&id=$co\">View Paper </a>";
                            echo "<br/>";
                    echo "<br />";
            $i++;
                    }
                    
            if($i===0) echo "You are not authoring any papers.";
            
        }
        
        public function refereeing()
        {
            
            if(Yii::app()->user->id != NULL)
            $usid = Yii::app()->user->id;
            else
            $usid = 0;

            Connect_DatabaseController::connect();                    
            
            $refereeing = mysql_query("SELECT DISTINCT paperid FROM paper_referee WHERE userid='$usid'");
            $i=0;

            while($row = mysql_fetch_array($refereeing))
                    {

                    $asd = $row['paperid'];
                    $result1 = mysql_query("SELECT paper_name FROM paper WHERE id='$asd'");

                    while($row2 = mysql_fetch_array($result1))
                            {
                        /*
                            echo "<B>".($i+1)."</B>" . ") Paper Name : " . $row2['paper_name'];
                            echo "  ";
                          */
                            }
                         
/*
            //  echo "<br />";
            //  echo "Conference ID   : " . $row['conferenceid'];
                    $co = $row['paperid'];
                    echo "<br />";
            //      echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
                            echo "<a href=\" ./index.php?r=paper/view&id=$co\">View Paper </a>";
                            echo "<br/>";
                    echo "<br />";*/
            $i++;
                    }

                    if($i===0) echo "You are not refereeing any papers.<br><br>";
                    else echo "<a href=\" ./index.php?r=refereetableview/index&sort=1\">View All Assigned Papers </a>";

        }
        

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