Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

Rev 5688 | Rev 5690 | Ir a la última revisión | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 5688 Rev 5689
Línea 67... Línea 67...
67 
     */
 67 
     */
68 
    public function fetchOneByUserId1AndUserId2($user1, $user2)
 68 
    public function fetchOneByUserId1AndUserId2($user1, $user2)
69 
    {
 69 
    {
70 
        $prototype = new Conversation();
 70 
        $prototype = new Conversation();
71 
        $select = $this->sql->select(self::_TABLE);
 71 
        $select = $this->sql->select(self::_TABLE);
- 
 
 72 
        // $select->where->and->nest()
- 
 
 73 
        // ->nest()
- 
 
 74 
        // ->equalTo('sender_id', $user1)
- 
 
 75 
        // ->and->equalTo('receiver_id', $user2)
- 
 
 76 
        // ->unnest()
- 
 
 77 
        // ->or->nest()
- 
 
 78 
        // ->equalTo('receiver_id', $user1)
- 
 
 79 
        // ->and->equalTo('sender_id', $user2)
- 
 
 80 
        // ->unnest()
- 
 
 81 
        // ->unnest();
- 
 
 82 
 
72 
        $select->where->equalTo('sender_id', $user1)
 83 
        $select->where->equalTo('sender_id', $user1)
73 
            ->and->equalTo('receiver_id', $user2);
 84 
            ->and->equalTo('receiver_id', $user2)
- 
 
 85 
            ->and->equalTo('sender_status', Conversation::STATUS_NORMAL)
- 
 
 86 
            ->and->equalTo('receiver_status', Conversation::STATUS_NORMAL);
Línea 74... Línea 87...
74 
 
 87 
 
75 
        return $this->executeFetchOneObject($select, $prototype);
 88 
        return $this->executeFetchOneObject($select, $prototype);