Assignment_functionController.php

Go to the documentation of this file.

<?php

class Assignment_functionController extends Controller
{
    public function actionIndex()
    {
        $this->render('index');
    }
  
        public function assignment()
        {
            Connect_DatabaseController::connect();
             //echo "fdsfsdg";
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;    
            
$confid = $_POST['confid'];
// auto assignment

// select all papers from conference

for($a=1; $a<100; $a++)
    $rank[$a]=0;

for($a=1; $a<1000; $a++)
        $refereenames[$a]=" ";


$papers = mysql_query("SELECT * FROM paper WHERE id IN (SELECT paperid FROM conference_paper WHERE conferenceid=$confid)");

echo "<form action='index.php?r=assignment_function_submit/index' method='post'>";          

$i = 1;
$j = 1;
$papnum = 1;
if(mysql_num_rows($papers)!=0)
{
while( $pap = mysql_fetch_array($papers))
{
$pap_id = $pap['id'];
$pap_name = $pap['name'];

$paperid[$papnum] = $pap_id;

$paper_interest = mysql_query("SELECT * FROM paper_interest WHERE paper_id=$pap_id");
    //echo $pap_id . " " . "<br> ";
if(mysql_num_rows($paper_interest)!=0)
{
while( $int = mysql_fetch_array($paper_interest))
{
        $paper_int = $int['interest_id'];
    
$referees = mysql_query("SELECT * FROM users WHERE userid IN 
        (SELECT userid FROM conference_user_type WHERE conferenceid=$confid AND usertype=3)");
        
        while($referee = mysql_fetch_array($referees))
        {
            $refid = $referee['userid'];
            $refname = $referee['firstname'] . " " . $referee['lastname'];
            $referee_interest = mysql_query("SELECT * FROM interest_user WHERE userid=$refid AND interestid=$paper_int");

            if(mysql_num_rows($referee_interest)!=0)
            {
            while ($ref_int = mysql_fetch_array($referee_interest))
            {
                
                $knowledge = $ref_int['knowledge'];
                
            }
            }
            else {$knowledge = 0;}
            
            $rank[$i] += $knowledge;
            $refereenames[$i] = $refname;
            $refereeids[$i] = $refid;
            $i++;
        }
        $refcount = $i;
        $i=1;
        
    }
}
else 
{

    $refcount=0;
}
        echo "<h3>Paper : <a href=\" ./index.php?r=paper/view&id=$pap_id\">$pap_name</a></h3>";
//        echo "<h3>Paper : " . $pap_name . "</h3>";
        $max = 0;
        for($j=1;$j<$refcount; $j++)
        {
            
            if($max < $rank[$j]) {$max=$rank[$j]; $maxref=$refereeids[$j]; $maxrefname=$refereenames[$j];}

        }
        
        if($max!=0)
            
            echo "<input type='checkbox' name='refid[]' value='$pap_id|$maxref' checked>Paperid: " . $pap_id . " Name :" . "<a href=\" ./index.php?r=user_profile&usid=$maxref\">$maxrefname</a>" . " Rank :" . $max . "</><br>";
            //echo "<input type='checkbox' name='refid[]' value='$pap_id|$maxref' checked>Paperid: " . $pap_id . " Username :" . $maxrefname . " Rank :" . $max . "</><br>";
        else 
        {
            echo "There are not any qualified referees.<br>";
            echo "<a href=\" ./index.php?r=inviteuser/index&va=$confid\">Invite New Referees</a>";
            echo "<br/>";

        }

        echo "<br>";

        for($j=1; $j<5; $j++)
        $rank[$j]=0;
    }
            echo "<input hidden name='paperid[]' value=$paperid[$papnum]/>";  

            echo "<br>";
            $papnum++;
}
else echo "There Are No Submitted Papers.<br><br><br>";
            
    echo "<input type='submit' name=\'formSubmit' value='Assign Referees' />";           
    echo "</form><br>";  

}

        public function selectconference()
        {
            
            Connect_DatabaseController::connect();
             //echo "fdsfsdg";
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;    
            
            $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid IN
                                        (SELECT conferenceid FROM conference_user_type WHERE userid=$usid)");
    echo "<form action='index.php?r=assignment_function/index' method='post'>";          
    $i=1;
            while($conf = mysql_fetch_array($conferences))
            {
            $confid = $conf['conferenceid'];
            $confname = $conf['name'];
            
            echo "<input type='radio' name='confid' value=$confid /> $confname<br>";
            
            $i++;

            }
    echo "<input type='submit' name=\'formSubmit' value='View Automatic Assignment Suggestions' />";           
    echo "</form><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',
            ),
        );
    }
    */
}