User_profileController.php

Go to the documentation of this file.

<?php

class User_profileController extends Controller
{
    public function actionIndex()
    {
        $this->render('index');
    }
        
        public function set_interests()
        {
            
            Connect_DatabaseController::connect();       
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;
            
            $userid = $_GET['usid'];
            
            
            if($usid!=$userid)
            {
                echo "<br/>";
            }
            else
            {
                echo "<br><br>";
                echo "<a href=\" ./index.php?r=interests/index\">Update Your Interests </a>";
                echo "<br><br>";
                
            }
            
        }
        
        public function send_message()
        {
            
            Connect_DatabaseController::connect();       
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;
            
            $userid = $_GET['usid'];
            
            
            if($usid==$userid)
            {
                
            }
            else
            {
                echo "<br>";
                echo "<a href=\" ./index.php?r=viewusermessage/index&userid=$userid\">Send Message To This User </a>";
                echo "<br><br>";
                
            }            
            
            
        }
                
        public function username()
        {
            
            Connect_DatabaseController::connect();       

            $usid = $_GET['usid'];
            
            $result = mysql_query("SELECT * FROM users WHERE userid=$usid");
    
            while($row = mysql_fetch_array($result))
                {
                    echo $row['firstname'] . " " . $row['lastname'];
                }
                
        }
        
        public function viewUser()
        {

            Connect_DatabaseController::connect();       

            $usid = $_GET['usid'];        
            
            $result = mysql_query("SELECT * FROM users WHERE userid=$usid");
    
            while($row = mysql_fetch_array($result))
                {

                        $this->widget('zii.widgets.CDetailView', array(
                        'data'=>$row,
                        'attributes'=>array(
                                'userid',
                                'username',
                                'firstname',
                                'lastname',
                                'email',

                        ),
                    )); 
                }
            
        }
        
        public function viewInterests()
        {

            Connect_DatabaseController::connect();       

            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;
            
            $userid = $_GET['usid'];
            
            if($usid==$userid)
            {
                
            }
            else
            {
                $usid=$userid;
                
            }              

            $topicname = mysql_query("SELECT * FROM interests_topics WHERE id IN 
                (SELECT topicid FROM topic_subtopic WHERE subtopicid IN 
                (SELECT interestid FROM interest_user WHERE userid=$usid))");

            $i=0;
            while ($row4 = mysql_fetch_array($topicname))
            {
                
                echo "<b>" . $row4['name'] . "</b><br>";
                $topid = $row4['id'];
                
                $interest = mysql_query("SELECT * FROM interests_subtopics WHERE id IN 
                    (SELECT subtopicid FROM topic_subtopic WHERE topicid=$topid AND subtopicid IN 
                    (SELECT interestid FROM interest_user WHERE userid=$usid))");
                
                while($row5 = mysql_fetch_array($interest))
                {
                    
                    echo $row5['name'] . " ";
                    $subid = $row5['id'];
                    $know = mysql_query("SELECT * FROM interest_user WHERE interestid=$subid AND userid=$usid");
                    
                    while($row6 = mysql_fetch_array($know))
                    {
                        
                      //  echo "(" . $row6['knowledge'] . ")<br>";
                        
                        $knowledge = $row6['knowledge'];
                        
                        if($knowledge==1) echo "( mediocre )<br>";
                        else if($knowledge==2) echo "( good )<br>";
                        else echo "( excellent )<br>";
                        
                    }
                }
                
                echo "<br>";
                $i++; 
            }
            /*
            $interestname = mysql_query("SELECT name FROM interests_subtopics WHERE id IN (SELECT interestid FROM interest_user WHERE userid=$usid)");
            
            while ($row3 = mysql_fetch_array($interestname))
            {
                
                echo $row3['name'] . "<br>";
                
            }
            */
                if($i==0) echo "This user has no interests.";

        }           
        
        public function user_conferences()
        {
            
            Connect_DatabaseController::connect();       
            
            $usid = $_GET['usid'];        

            //select all conferences that the user has admin as his user type
            $participating = mysql_query("SELECT DISTINCT conferenceid FROM conference_user_type WHERE userid='$usid'");
            
            $i=0;

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

                    $asd = $row['conferenceid'];
                    $result1 = mysql_query("SELECT name FROM conference WHERE conferenceid='$asd'");

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

            //  echo "<br />";
            //  echo "Conference ID   : " . $row['conferenceid'];
                    $co = $row['conferenceid'];
                    echo "<br />";
            //      echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
                            echo "<a href=\" ./index.php?r=conference/view&id=$co\">View Conference </a>";
                    echo "<br />";
                    echo "<br />";
            $i++;
                    }
                    
            if($i==0) echo "This user is not participating in any conference.";        
            
        }
        
        public function user_papers()
        {
            
            Connect_DatabaseController::connect();       
            
            $usid = $_GET['usid'];        

            //select all conferences that the user has admin as his user type
            $papers = mysql_query("SELECT DISTINCT id FROM paper WHERE author_id='$usid'");
            
            $i=0;
            if($papers!=NULL){
            while($row = mysql_fetch_array($papers))
                    {

                    $asd = $row['id'];
                    $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 "  ";
                            }


                    $co = $row['id'];
                    echo "<br />";
                    echo "<a href=\" ./index.php?r=paper/view&id=$co\">View Paper </a>";
                    echo "<br /><br />";
            $i++;
                    }
            }
            if($i==0) echo "This user does not have any papers.";    

            
            
            
        }

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