How to fasten nested relations with one Yii request?

N

nepster-web2014-01-13 06:33:53

Yii

nepster-web, 2014-01-13 06:33:53

So:
There is a table of games (games)
There is a table of applications for the game (proposal)
There is a table waiting to play (waiting)
games

public function relations()
    {
        return array(
            'proposal' => array(self::HAS_MANY, 'GameProposalModel', '', 'on'=>'t.game_id=proposal.game_id'),
        );
    }

proposal

public function relations()
    {
        return array(
            'waiting' => array(self::HAS_MANY, 'GameWaitingModel', '', 'on'=>'t.proposal_id=waiting.proposal_id'),
        );
    }

There is a task to make such a request to get the following:
Game data
All requests with status -1
All users who are pending
I started something like this:

$criteria = new CDbCriteria;
            
            $criteria->select    = 't.game_id, t.game_name, t.alter_name';
            $criteria->condition = "t.game_id=:game_id AND proposal.status=-1";
            $criteria->params    = array(':game_id'=>$game_id);

        
            $criteria->with = array(
                 'proposal' => array('joinType'=>'LEFT JOIN'),
            );
            
        
            $data = GamesModel::model()->find($criteria);

And immediately ran into 2 jambs:
If there is no application, then false is returned.
How can I add another nested waiting relation?
Tell me please.

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

V

Vladlen Grachev, 2014-01-13
@gwer

If there is no request, then false is returned.

Checking for false in the returned value.
If I understand correctly what you need, then something like this:

$criteria->with = array(
    'proposal' => array('joinType'=>'LEFT JOIN'),
    'proposal.waiting',
);

N

nepster-web, 2014-01-13
@nepster-web

CDbCommand failed to execute SQL query

N

nepster-web, 2014-01-13
@nepster-web

Added 1 more relation in the table of games: waiting

public function relations()
    {
        return array(
            //'rule'    => array(self::HAS_MANY, 'GamesRuleModel',   '', 'on'=>'t.game_id=rule.game_id'),
            'proposal' => array(self::HAS_MANY, 'GameProposalModel', '', 'on'=>'t.game_id=proposal.game_id'),
            'waiting' => array(self::HAS_MANY, 'GameWaitingModel', '', 'on'=>'proposal.proposal_id=waiting.proposal_id'),
        );
    }

$criteria->with = array(
             'proposal' => array('joinType'=>'LEFT OUTER JOIN'),
             'waiting.proposal',
        );

Now we make a request:

$game_id = 1;
          
        $criteria = new CDbCriteria;
        
        $criteria->select    = 't.game_id, t.game_name, t.alter_name';
        $criteria->condition = "t.game_id=:game_id AND proposal.status=-1";
        $criteria->params    = array(':game_id'=>$game_id);
        $criteria->together = true;
    
        $criteria->with = array(
             'proposal' => array('joinType'=>'LEFT OUTER JOIN'),
             'waiting',
        );
        
    
        $data = GamesModel::model()->find($criteria);
        

        echo '<pre>';
        print_r($data);
        echo '</pre>';

[b]Object pops up:[/b]

Now let's figure out what we have here:
1) Data about the game, in this case, for the test, I got 3 parameters. IDs and names
2) Applications for the game proposals
3) Users who are waiting for the game waiting
So how this whole thing looks in practice:
We have an event server that makes a request for such an object:
Having received the object, Javascript draws a table of applications according to proposals and waiting
And also, according to the game data, it updates the statistics of the game (for example, how many games were played per day, the number of players online, etc.)
Now the moments:
- if there is not one waiting (no waiting records), everything is fine, the waiting object comes empty . Of course, this cannot be, but I check it on the test.
- further, for example, more players joined these three applications, the applications received a different status (-1 pending, 1 the game is in progress, 0 the game is over, -2 the game did not take place) and, as it were, there are no applications.
a request is made to the server, and if there are no applications, then emptiness is returned. In this case, I will draw a table with JavaScript, with the inscription there are no applications. But how to update the statistical data of the game if a void has come?
That is, the task is to make it so that if there is no proposal, just the game object comes.

// транзакция 

$data['game'] = .... findByPK($game_id);

if($data['game'])
{
        $data['proposal'] = ... findByAttibutes(array(...)) ;
        $data['waiting']  = ... findByAttibutes(array(...));
}

$transaction->commit();