View of all components & their details

Actors

Guest, User, Admin

Scenario

1. The user clicks on the "COMPONENTS" dropdown

2. A list of all the component types is displayed and the users chooses one

3. A popup of all the components of that type is displayed

SELECT *
FROM components
WHERE name ILIKE ('%' || $q || '%')
ORDER BY
  CASE WHEN $sort = 'price_asc'  THEN price END ASC,
  CASE WHEN $sort = 'price_desc' THEN price END DESC,
  price DESC
LIMIT COALESCE($limit, 100);

4. The user can sort by price

5. The users can view the details of a component by clicking on it

SELECT *
FROM components
WHERE id = $componentId
LIMIT 1;

SELECT *
FROM $details_table   -- cpu/gpu/memory/storage/power_supply/motherboard/pc_case/cooler/...
WHERE component_id = $componentId
LIMIT 1;

-- if type == pc_case:
SELECT * FROM case_storage_form_factors WHERE case_id = $componentId;
SELECT * FROM case_ps_form_factors      WHERE case_id = $componentId;
SELECT * FROM case_mobo_form_factors    WHERE case_id = $componentId;

-- if type == 'cooler':
SELECT * FROM cooler_cpu_sockets WHERE cooler_id = $componentId;