Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev 5685 Rev 5687
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)
 72 
        $select->where->equalTo('sender_id', $user1)
75 
            ->and->equalTo('sender_status', Conversation::STATUS_NORMAL)
 - 
 
76 
            ->and->equalTo('receiver_id', $user2)
 73 
            ->and->equalTo('receiver_id', $user2)
77 
            ->unnest()
 - 
 
78 
            ->or->nest()
 - 
 
79 
            ->equalTo('receiver_id', $user1)
 74 
            ->equalTo('receiver_id', $user1)
80 
            ->and->equalTo('sender_id', $user2)
 75 
            ->and->equalTo('sender_id', $user2);
81 
            ->unnest()
 - 
 
82 
            ->unnest();
 - 
 
Línea 83... Línea 76...
83 
 
 76 
 
84 
        return $this->executeFetchOneObject($select, $prototype);
 77 
        return $this->executeFetchOneObject($select, $prototype);