]> git.ipfire.org Git - ipfire.org.git/blobdiff - webapp/backend/fireinfo.py
i-use: Fix error images when the profile is disabled or not found
[ipfire.org.git] / webapp / backend / fireinfo.py
index a194282200327b4dd293a5e4370d1c2806358928..b4b742481263cf2d8e3320ee29835b77aade3cea 100644 (file)
@@ -1504,6 +1504,14 @@ class Fireinfo(Object):
                if res:
                        return Profile(self.backend, res.id, res)
 
+       def get_profile_with_data(self, public_id, when=None):
+               res = self.db.get("WITH profiles AS (SELECT fireinfo_profiles_with_data_at(%s) AS id) \
+                       SELECT * FROM profiles JOIN fireinfo_profiles ON profiles.id = fireinfo_profiles.id \
+                               WHERE public_id = %s ORDER BY time_updated DESC LIMIT 1", when, public_id)
+
+               if res:
+                       return Profile(self.backend, res.id, res)
+
        def get_profiles(self, public_id):
                res = self.db.query("SELECT * FROM fireinfo_profiles \
                        WHERE public_id = %s ORDER BY time_created DESC", public_id)