Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev 5672 Rev 5673
Línea 70... Línea 70...
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()
72
        $select->where->and->nest()
73
            ->nest()
73
            ->nest()
74
            ->equalTo('sender_id', $user1)
74
            ->equalTo('sender_id', $user1)
-
 
75
            ->and->equalTo('sender_status', Conversation::STATUS_NORMAL)
-
 
76
            ->unnest()
75
            ->and->equalTo('receiver_id', $user2)
77
            ->and->equalTo('receiver_id', $user2)
-
 
78
            ->and->equalTo('receiver_status', Conversation::STATUS_NORMAL)
76
            ->unnest()
79
            ->unnest()
77
            ->or->nest()
80
            ->or->nest()
78
            ->equalTo('receiver_id', $user1)
81
            ->equalTo('receiver_id', $user1)
79
            ->and->equalTo('sender_id', $user2)
82
            ->and->equalTo('sender_id', $user2)
80
            ->unnest()
83
            ->unnest()