ConferenceController2.php

Go to the documentation of this file.

<?php

class ConferenceController extends Controller
{
    public $layout='//layouts/column2';

    public function filters()
    {
        return array(
            'accessControl', // perform access control for CRUD operations
            'postOnly + delete', // we only allow deletion via POST request
        );
    }

    public function accessRules()
    {
        return array(
            array('allow',  // allow authenticated user to perform 'index' and 'view' actions
                'actions'=>array('index','view'),
                'users'=>array('@'),
            ),
            array('allow', // allow authenticated user to perform 'create' and 'update' actions
                'actions'=>array('create','update'),
                'users'=>array('@'),
            ),
            array('allow', // allow admin user to perform 'admin' and 'delete' actions
                'actions'=>array('admin','delete'),
                'users'=>array('admin'),
            ),
            array('deny',  // deny all users
                'users'=>array('*'),
            ),
        );
    }

    public function actionView($id)
    {
        $this->render('view',array(
            'model'=>$this->loadModel($id),
            
        ) 
        );

    }
        
        
        public function attends()
        {
            
            Connect_DatabaseController::connect();       
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;
            
            $id = $_GET['id'];
            
            $participates = mysql_query("SELECT DISTINCT userid FROM conference_user_type WHERE conferenceid=$id AND userid=$usid AND usertype=4");

            while($row = mysql_fetch_array($participates))
            {
                if($usid == $row['userid']) {echo "hidden";}
                else echo "visible";  
            }  
        }
        
        public function attends2()
        {
            
            Connect_DatabaseController::connect();       
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;
            
            $id = $_GET['id'];
            
            $participates = mysql_query("SELECT DISTINCT userid FROM conference_user_type WHERE conferenceid=$id AND usertype=4");

            $i=0;
            while($row = mysql_fetch_array($participates))
            {

                if($row['userid']==$usid) $i++;
                else "";
        
            }
            
            if($i==0) echo "hidden";
            else echo "visible";
        }        
        
        public function authors()
        {
            
            Connect_DatabaseController::connect();       
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;
            
            $id = $_GET['id'];
            
            $participates = mysql_query("SELECT DISTINCT userid FROM conference_user_type WHERE conferenceid=$id AND userid=$usid AND usertype=2");

            while($row = mysql_fetch_array($participates))
            {
                if($usid == $row['userid']) {echo "hidden";}
                else echo "visible";  
            }  
        }
 

        public function authors2()
        {
            
            Connect_DatabaseController::connect();       
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;
            
            $id = $_GET['id'];
            
            $participates = mysql_query("SELECT DISTINCT userid FROM conference_user_type WHERE conferenceid=$id AND usertype=2");

            $i=0;
            while($row = mysql_fetch_array($participates))
            {

                if($row['userid']==$usid) $i++;
                else "";
        
            }
            
            if($i==0) echo "hidden";
            else echo "visible";
            
        }        
        
        public function referees()
        {
            
            Connect_DatabaseController::connect();       
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;
            
            $id = $_GET['id'];
            
            $participates = mysql_query("SELECT DISTINCT userid FROM conference_user_type WHERE conferenceid=$id AND userid=$usid AND usertype=3");

            while($row = mysql_fetch_array($participates))
            {
                if($usid == $row['userid']) {echo "hidden";}
                else echo "visible";  
            }  
        }        

        public function referees2()
        {
            
            Connect_DatabaseController::connect();       
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;
            
            $id = $_GET['id'];
            
            $participates = mysql_query("SELECT DISTINCT userid FROM conference_user_type WHERE conferenceid=$id AND usertype=3");

            $i=0;
            while($row = mysql_fetch_array($participates))
            {

                if($row['userid']==$usid) $i++;
                else "";
        
            }
            
            if($i==0) echo "hidden";
            else echo "visible";
            

        }
        
    public function usersView($id)
    {
  
     Connect_DatabaseController::connect();       

        
//
// KONFERANS KULLANICILARINI GORUNTULE

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

//select all users that participate in this conference
$participants = mysql_query("SELECT DISTINCT userid FROM conference_user_type WHERE conferenceid=$id");
$i=0;



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

    $asd = $row['userid'];

    $result1 = mysql_query("SELECT * FROM users WHERE userid=$asd");
        if($result1!=NULL){
            while($row2 = mysql_fetch_array($result1))
        {
        
        $co = $row2['userid'];
        echo "<B>".($i+1)."</B>" . ") User Name : " ;//. $row2['username'];
        echo "<a href=\" /test/index.php?r=user_profile/index&usid=$co\">" . $row2['username'] . "</a>";
        echo "<br/>";   
        echo "<br/>";
        $i++;
        }
        }
        else {echo "<br/>";echo "<br/>";echo "<br/>";}
    }   
}
    
    
    public function papersView($id)
    {
            Connect_DatabaseController::connect();
            
//
// KONFERANS PAPER'LARINI GORUNTULE

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



//select all papers that belong to the conference
$papers = mysql_query("SELECT DISTINCT paperid FROM conference_paper WHERE conferenceid=$id");
$i=0;


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

    $asd = $row['paperid'];
    
    $result1 = mysql_query("SELECT * FROM paper WHERE id=$asd");
        if($result1!=NULL){
            while($row2 = mysql_fetch_array($result1))
        {
        
        $co = $row2['id'];
        echo "<B>".($i+1)."</B>" . ") Paper Name : " ;//. $row2['username'];
        echo "<a href=\" /test/index.php?r=paper/view&id=$co\">" . $row2['paper_name'] . "</a>";
        echo "<br/>";   
        echo "<br/>";

        $i++;

        }
        
        }
        else {echo "<br/>";}

}
    if($i==0) echo "No Papers Submitted Yet";
    else ;
    
    
    }
    
    
    public function actionCreate()
    {
        $model=new Conference;

        // Uncomment the following line if AJAX validation is needed
        // $this->performAjaxValidation($model);

        if(isset($_POST['Conference']))
        {
            $model->attributes=$_POST['Conference'];
            if($model->save())
                $this->redirect(array('view','id'=>$model->conferenceid));
        }

        $this->render('create',array(
            'model'=>$model,
        ));
    }

    public function actionUpdate($id)
    {
        $model=$this->loadModel($id);

        // Uncomment the following line if AJAX validation is needed
        // $this->performAjaxValidation($model);

        if(isset($_POST['Conference']))
        {
            $model->attributes=$_POST['Conference'];
            if($model->save())
                $this->redirect(array('view','id'=>$model->conferenceid));
        }

        $this->render('update',array(
            'model'=>$model,
        ));
    }

    public function actionDelete($id)
    {
        $this->loadModel($id)->delete();

        // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
        if(!isset($_GET['ajax']))
            $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
    }

    public function actionIndex()
    {
        $dataProvider=new CActiveDataProvider('Conference');
        $this->render('index',array(
            'dataProvider'=>$dataProvider,
        ));
    }

    public function actionAdmin()
    {
        $model=new Conference('search');
        $model->unsetAttributes();  // clear any default values
        if(isset($_GET['Conference']))
            $model->attributes=$_GET['Conference'];

        $this->render('admin',array(
            'model'=>$model,
        ));
    }

    public function loadModel($id)
    {
        $model=Conference::model()->findByPk($id);
        if($model===null)
            throw new CHttpException(404,'The requested page does not exist.');
        return $model;
    }

    protected function performAjaxValidation($model)
    {
        if(isset($_POST['ajax']) && $_POST['ajax']==='conference-form')
        {
            echo CActiveForm::validate($model);
            Yii::app()->end();
        }
    }
}