Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev 5691 Rev 5692
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 
 
 - 
 
83 
        $select->where->and->nest()
 72 
        $select->where->and->nest()
84 
            ->nest()
 73 
            ->nest()
85 
            ->equalTo('sender_id', $user1)
 74 
            ->equalTo('sender_id', $user1)
86 
            ->and->equalTo('receiver_id', $user2)
 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 
 
- 
 
 83 
        // $select->where->and->nest()
- 
 
 84 
        //     ->nest()
- 
 
 85 
        //     ->equalTo('sender_id', $user1)
- 
 
 86 
        //     ->and->equalTo('receiver_id', $user2)
87 
            ->and->equalTo('sender_status', Conversation::STATUS_NORMAL)
 87 
        //     ->and->equalTo('sender_status', Conversation::STATUS_NORMAL)
88 
            ->and->equalTo('receiver_status', Conversation::STATUS_NORMAL);
 88 
        //     ->and->equalTo('receiver_status', Conversation::STATUS_NORMAL);
Línea 89... Línea 89...
89 
 
 89 
 
90 
        return $this->executeFetchOneObject($select, $prototype);
 90 
        return $this->executeFetchOneObject($select, $prototype);