Assignment_function_conferenceController.php

Go to the documentation of this file.

<?php

class Assignment_function_conferenceController 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 = $_GET['confid'];
// auto assignment
$interest_id = $_POST['interestid'];
// 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) AND id IN
                    (SELECT paper_id FROM paper_interest WHERE interest_id=$interest_id)");

echo "<form action='index.php?r=assignment_function_submit_conference/index&confid=$confid' 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 selectinterest()
        {
            
            Connect_DatabaseController::connect();
             //echo "fdsfsdg";
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;    
            
            $confid = $_GET['confid'];
            
            echo "<h3>Select Interest Topics of Papers You Want To View</h3>";
            
            $interests = mysql_query("SELECT * FROM interests_topics WHERE id IN
                                        (SELECT topicid FROM topic_subtopic WHERE subtopicid IN
                                        (SELECT titleid FROM conference_title WHERE conferenceid=$confid))");
    
            
            if(mysql_num_rows($interests)!=0)
            {
            echo "<form action='index.php?r=assignment_function_conference/index&confid=$confid' method='post'>";          
    $i=1;
            while($inter = mysql_fetch_array($interests))
            {
            $interestid = $inter['id'];
            $interestname = $inter['name'];
            
            $subs = mysql_query("SELECT * FROM interests_subtopics WHERE id IN
                                (SELECT subtopicid FROM topic_subtopic WHERE topicid=$interestid) AND id IN
                                (SELECT titleid FROM conference_title WHERE conferenceid=$confid)");    
            
            echo "<b>$interestname</b><br>";
            while($sub = mysql_fetch_array($subs))
            {
                
            $subid = $sub['id'];
            $subname = $sub['name'];
            echo "<input type='radio' name='interestid' value=$subid /> $subname<br>";
            
            }
            $i++;
            echo "<br>";
            }
            
            
    echo "<input type='submit' name=\'formSubmit' value='View Automatic Assignment Suggestions' />";           
    echo "</form><br>";  
            }
            else echo "No topics specified.<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',
            ),
        );
    }
    */
}