MymessagesController.php

Go to the documentation of this file.

<?php

class MymessagesController extends Controller
{
    public function actionIndex()
    {
        $this->render('index');
    }
        
        public function viewreceivedmessages()
        {
            
            Connect_DatabaseController::connect();
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;

            //select all conferences that the user has admin as his user type
            $message = mysql_query("SELECT * FROM (SELECT * FROM message WHERE receiverid='$usid' ORDER BY id DESC) tmp GROUP BY senderid ORDER BY id DESC ");          
            
            $i=0;

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

                    $asd = $row['senderid'];
                    $result1 = mysql_query("SELECT * FROM users WHERE userid='$asd'");

                    while($row2 = mysql_fetch_array($result1))
                            {
                        
                            echo "<B>".($i+1)."</B>" . ") User Name : " . $row2['firstname'] . " " . $row2['lastname'];
                            //echo "<br>";
                            if($row['read_unread']==0) echo " " . " NEW!<br>";
                            else echo "<br>";

                            }
                    //echo $row['read_unread'] . "<br>";

                    echo "<a href=\" ./index.php?r=viewusermessage/index&userid=$asd\">View Message History With This User </a>";

                    echo "<br><br><br>";
            $i++;
                    }
                    
            if($i==0) echo "You don't have any received messages.";

        }
        
        public function viewsentmessages()
        {
            
            Connect_DatabaseController::connect();
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;

            //select all conferences that the user has admin as his user type
//            $message = mysql_query("SELECT DISTINCT receiverid FROM message ORDER BY id WHERE senderid='$usid' ");
                    
            $message = mysql_query("SELECT * FROM (SELECT * FROM message WHERE senderid='$usid' ORDER BY id DESC) tmp GROUP BY receiverid ORDER BY id DESC ");          
            
            $i=0;

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

                    $asd = $row['receiverid'];
                    $result1 = mysql_query("SELECT * FROM users WHERE userid='$asd'");

                    while($row2 = mysql_fetch_array($result1))
                            {
                            echo "<B>".($i+1)."</B>" . ") User Name : " . $row2['firstname'] . " " . $row2['lastname'];
                            echo "<br>";
                            }
                            
                    echo "<a href=\" ./index.php?r=viewusermessage/index&userid=$asd\">View Message History With This User </a>";

                    echo "<br><br><br>";
            $i++;
                    }
                    
            if($i==0) echo "You don't have any sent messages.";

        }
            
                
                
                
             

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