1 package Newslash::Model::Users::Friends;
2 use Newslash::Model::Base -base;
13 $and_clause = 'people.type = ?';
16 $and_clause = 'people.perceive = ?';
20 SELECT users.* FROM users
21 JOIN people ON users.uid = people.person
22 WHERE people.uid = ? AND $and_clause
25 my $dbh = $self->connect_db;
26 my $sth = $dbh->prepare($sql);;
28 $sth->execute($uid, $type);
31 $sth->execute($uid, $perceive);
34 my $rs = $sth->fetchall_arrayref({});
38 my @result = map { $self->new_instance_of('Users')->_create_user_object($_) } @$rs;
46 return $self->_get_friends($params->{uid}, 'friend', '');
52 return $self->_get_friends($params->{uid}, 'foe', '');
58 return $self->_get_friends($params->{uid}, '', 'fan');
64 return $self->_get_friends($params->{uid}, '', 'freak');