MyInvitationsFunctionController.php

Go to the documentation of this file.

<?php

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

        public function author_accept($confid, $uid, $type, $accept)
        {
        
            Connect_DatabaseController::connect();
            
            $sql_insert_conference_user_type="INSERT INTO conference_user_type ( userid, usertype, conferenceid)
            VALUES
            ($uid, $type , $confid)";
            mysql_query($sql_insert_conference_user_type) or die (mysql_error());

            $sql_insert_conference_user="INSERT INTO conference_user( userid, conferenceid)
            VALUES
            ($uid , $confid)";
            mysql_query($sql_insert_conference_user) or die (mysql_error());
            
            $sql_accept_author="UPDATE invitations SET accepted_rejected=$accept WHERE conferenceid=$confid AND userid=$uid AND usertype=2 ";
            mysql_query($sql_accept_author) or die (mysql_error());

        }

        public function author_reject($confid, $uid, $type, $accept)
        {
            
             Connect_DatabaseController::connect();

            $sql_accept_referee="DELETE FROM conference_user  WHERE conferenceid=$confid AND userid=$uid";
            mysql_query($sql_accept_referee) or die (mysql_error());

            $sql_accept_referee="DELETE FROM conference_user_type  WHERE conferenceid=$confid AND userid=$uid AND usertype=2";
            mysql_query($sql_accept_referee) or die (mysql_error());            
            
            $sql_accept_author="UPDATE invitations SET accepted_rejected=$accept WHERE conferenceid=$confid AND userid=$uid AND usertype=2 ";
            mysql_query($sql_accept_author) or die (mysql_error());

        }
        
        public function referee_accept($confid, $uid, $type, $accept)
        {
        
            Connect_DatabaseController::connect();
            
            $sql_insert_conference_user_type="INSERT INTO conference_user_type ( userid, usertype, conferenceid)
            VALUES
            ($uid, $type , $confid)";
            mysql_query($sql_insert_conference_user_type) or die (mysql_error());

            $sql_insert_conference_user="INSERT INTO conference_user( userid, conferenceid)
            VALUES
            ($uid , $confid)";
            mysql_query($sql_insert_conference_user) or die (mysql_error());
            
            $sql_accept_author="UPDATE invitations SET accepted_rejected=$accept WHERE conferenceid=$confid AND userid=$uid AND usertype=3 ";
            mysql_query($sql_accept_author) or die (mysql_error());

        }
        
        public function referee_reject($confid, $uid, $type, $accept)
        {
            
            Connect_DatabaseController::connect();

            $sql_accept_referee="DELETE FROM conference_user  WHERE conferenceid=$confid AND userid=$uid";
            mysql_query($sql_accept_referee) or die (mysql_error());

            $sql_accept_referee="DELETE FROM conference_user_type  WHERE conferenceid=$confid AND userid=$uid AND usertype=3";
            mysql_query($sql_accept_referee) or die (mysql_error());            
            
            $sql_accept_author="UPDATE invitations SET accepted_rejected=$accept WHERE conferenceid=$confid AND userid=$uid AND usertype=3 ";
            mysql_query($sql_accept_author) or die (mysql_error());

        }        
        
        public function attendee_accept($confid, $uid, $type, $accept)
        {
        
            Connect_DatabaseController::connect();
            
            $sql_insert_conference_user_type="INSERT INTO conference_user_type ( userid, usertype, conferenceid)
            VALUES
            ($uid, $type , $confid)";
            mysql_query($sql_insert_conference_user_type) or die (mysql_error());

            $sql_insert_conference_user="INSERT INTO conference_user( userid, conferenceid)
            VALUES
            ($uid , $confid)";
            mysql_query($sql_insert_conference_user) or die (mysql_error());
            
            $sql_accept_author="UPDATE invitations SET accepted_rejected=$accept WHERE conferenceid=$confid AND userid=$uid AND usertype=4 ";
            mysql_query($sql_accept_author) or die (mysql_error());

        }
        
        public function attendee_reject($confid, $uid, $type, $accept)
        {
            
            Connect_DatabaseController::connect();

            $sql_accept_referee="DELETE FROM conference_user  WHERE conferenceid=$confid AND userid=$uid";
            mysql_query($sql_accept_referee) or die (mysql_error());

            $sql_accept_referee="DELETE FROM conference_user_type  WHERE conferenceid=$confid AND userid=$uid AND usertype=4";
            mysql_query($sql_accept_referee) or die (mysql_error());            
            
            $sql_accept_author="UPDATE invitations SET accepted_rejected=$accept WHERE conferenceid=$confid AND userid=$uid AND usertype=4 ";
            mysql_query($sql_accept_author) or die (mysql_error());

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