1 local id = param.get("id")

2 local min_id = param.get("min_id")

3 local max_id = param.get("max_id")

4 local initiative_id = param.get("initiative_id")

5 local order = param.get("order")

6 local limit = param.get("limit", atom.integer)

7

8 local suggestions_selector = Suggestion:new_selector()

9

10 if id then

11 suggestions_selector:add_where{"suggestion.id = ?", id}

12 end

13

14 if min_id then

15 suggestions_selector:add_where{"suggestion.id >= ?", min_id}

16 end

17

18 if max_id then

19 suggestions_selector:add_where{"suggestion.id <= ?", max_id}

20 end

21

22 if initiative_id then

23 suggestions_selector:add_where{"suggestion.initiative_id = ?", initiative_id}

24 end

25

26 if order == "created_desc" then

27 suggestions_selector:add_order_by("suggestion.created DESC")

28 elseif order == "created_asc" or order == "created" then

29 suggestions_selector:add_order_by("suggestion.id")

30 elseif order == "id_desc" then

31 suggestions_selector:add_order_by("suggestion.id DESC")

32 else

33 suggestions_selector:add_order_by("suggestion.id")

34 end

35

36 if limit then

37 suggestions_selector:limit(limit)

38 end

39

40 local api_engine = param.get("api_engine") or "xml"

41

42 local fields = {

43

44 { name = "id", field = "suggestion.id" },

45 { name = "initiative_id", field = "suggestion.initiative_id" },

46 { name = "created", field = "suggestion.created" },

47 -- FIXME: private api

48 -- { name = "author_id", field = "suggestion.author_id" },

49 { name = "name", field = "suggestion.name" },

50 { name = "description", field = "suggestion.description" },

51 { name = "minus2_unfulfilled_count", field = "suggestion.minus2_unfulfilled_count" },

52 { name = "minus2_fulfilled_count", field = "suggestion.minus2_fulfilled_count" },

53 { name = "minus1_unfulfilled_count", field = "suggestion.minus1_unfulfilled_count" },

54 { name = "minus1_fulfilled_count", field = "suggestion.minus1_fulfilled_count" },

55 { name = "plus1_unfulfilled_count", field = "suggestion.plus1_unfulfilled_count" },

56 { name = "plus1_fulfilled_count", field = "suggestion.plus1_fulfilled_count" },

57 { name = "plus2_unfulfilled_count", field = "suggestion.plus2_unfulfilled_count" },

58 { name = "plus2_fulfilled_count", field = "suggestion.plus2_fulfilled_count" },

59

60 }

61

62 util.autoapi{

63 relation_name = "suggestion",

64 selector = suggestions_selector,

65 fields = fields,

66 api_engine = api_engine

67 }