Changes between Version 2 and Version 3 of ViewBuilds

Timestamp:

12/29/25 00:24:49 (5 hours ago)

Author:

233051

Comment:

--

ViewBuilds

@@ -33 +33 @@
   b.created_at DESC
 LIMIT COALESCE($limit, 100);
+}}}
 
+4. The user clicks on one of the build cards and a popup with the build details is displayed 
+
+{{{
+BEGIN;
+
+SELECT
+  b.id,
+  b.user_id,
+  b.name,
+  b.created_at,
+  b.description,
+  b.total_price,
+  b.is_approved,
+  u.username     AS "creator"
+FROM build AS b
+INNER JOIN users AS u
+  ON b.user_id = u.id
+WHERE b.id = $buildId
+LIMIT 1;
+
+SELECT
+  bc.component_id AS "componentId",
+  c.*             AS "component"
+FROM build_component AS bc
+INNER JOIN components AS c
+  ON bc.component_id = c.id
+WHERE bc.build_id = $buildId;
+
+SELECT
+  u.username,
+  r.content,
+  r.created_at
+FROM review AS r
+INNER JOIN users AS u
+  ON r.user_id = u.id
+WHERE r.build_id = $buildId
+ORDER BY r.created_at DESC;
+
+SELECT
+  COALESCE(AVG(rb.value::float), 0) AS "averageRating",
+  COUNT(rb.value)                  AS "ratingCount"
+FROM rating_build AS rb
+WHERE rb.build_id = $buildId;
+
+SELECT value
+FROM rating_build
+WHERE build_id = $buildId AND user_id = $userId
+LIMIT 1;
+
+SELECT 1
+FROM favorite_build
+WHERE build_id = $buildId AND user_id = $userId
+LIMIT 1;
+
+SELECT content
+FROM review
+WHERE build_id = $buildId AND user_id = $userId
+LIMIT 1;
+
+COMMIT;
 }}}