public function getFirstOrLastLogForUser($idUser, $first = true)
{
$db = $this->getDbTable()->getAdapter();
$sql = ' SELECT *
FROM pic
WHERE user_id = :idUser
';
if ($first) {
$sql .= ' ORDER BY date_shot DESC LIMIT 1';
} else {
$sql .= ' ORDER BY date_shot ASC LIMIT 1';
}
$stmt = new Zend_Db_Statement_Pdo($db, $sql);
$stmt->bindParam(':idUser', $idUser);
$stmt->execute();
$resultSet = $stmt->fetchAll();
$arrPics = $this->createObjektArr($resultSet);
if (empty($arrPics)) {
return 0;
} else {
return $arrPics[0];
}
}
public function searchFriendsByName($idUser, $username)
{
$db = $this->getDbTable()->getAdapter();
$sql = ' SELECT f.*
FROM user f,
user_friends u
WHERE u.id_user = :idUser
AND f.id = u.id_friend
AND f.username LIKE :name ';
$username = '******' . $username . '%';
$stmt = new Zend_Db_Statement_Pdo($db, $sql);
$stmt->bindParam(':idUser', $idUser);
$stmt->bindParam(':name', $username);
$stmt->execute();
$resultSet = $stmt->fetchAll();
$arrRestaurants = $this->createObjektArr($resultSet);
return $arrRestaurants;
}
