Pastable version of Ferret, pagination and multiple joins

<div style="overflow:auto;border:solid 1px #ccc;background:#000;color:#F8F8F8">
          <div class="section">
            
            <pre style="float:left;margin:0 10px;border-right:0;color:#666;">1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31</pre>
            <pre class="sunburst"><span style="color:#E28964;">def</span> <span style="color:#89BDFF;">self.paged_search</span>(<span style="color:#3E87E3;">query<span style="color:#3E87E3;">,</span> from<span style="color:#3E87E3;">,</span> category<span style="color:#3E87E3;">,</span> locality<span style="color:#3E87E3;">,</span> page<span style="color:#3E87E3;">,</span> per_page <span style="color:#E28964;">=</span> <span style="color:#3387CC;">10</span></span>)
    query_str <span style="color:#E28964;">=</span> []
    query_prms <span style="color:#E28964;">=</span> []
    <span style="color:#E28964;">if</span> from
      query_str <span style="color:#E28964;">&lt;&lt;</span> <span style="color:#65B042;"><span style="color:#65B042;">&quot;</span>created_at &gt; ?<span style="color:#65B042;">&quot;</span></span>
      query_prms <span style="color:#E28964;">&lt;&lt;</span> from
    <span style="color:#E28964;">end</span>
    <span style="color:#E28964;">unless</span> locality.<span style="color:#89BDFF;">blank?</span>
      <span style="color:#E28964;">unless</span> locality.<span style="color:#89BDFF;">is_a?</span>(<span style="color:#3E87E3;">Array</span>)
        l <span style="color:#E28964;">=</span> <span style="color:#9B859D;">Locality</span>.<span style="color:#89BDFF;">find</span>(locality)
        locality <span style="color:#E28964;">=</span> l.<span style="color:#89BDFF;">direct_children</span>.<span style="color:#89BDFF;">collect</span> {|<span style="color:#3E87E3;">i</span>| i.<span style="color:#89BDFF;">id</span> } <span style="color:#E28964;">&lt;&lt;</span> l.<span style="color:#89BDFF;">id</span> <span style="color:#E28964;">if</span> l.<span style="color:#89BDFF;">direct_children</span>.<span style="color:#89BDFF;">size</span> <span style="color:#E28964;">&gt;</span> <span style="color:#3387CC;">0</span>
      <span style="color:#E28964;">end</span>
      query_str <span style="color:#E28964;">&lt;&lt;</span> <span style="color:#65B042;"><span style="color:#65B042;">&quot;</span>locality_id IN (?)<span style="color:#65B042;">&quot;</span></span>
      query_prms <span style="color:#E28964;">&lt;&lt;</span> locality
    <span style="color:#E28964;">end</span>
    <span style="color:#E28964;">unless</span> category.<span style="color:#89BDFF;">blank?</span>
      <span style="color:#E28964;">unless</span> category.<span style="color:#89BDFF;">is_a?</span>(<span style="color:#3E87E3;">Array</span>)
        c <span style="color:#E28964;">=</span> <span style="color:#9B859D;">Category</span>.<span style="color:#89BDFF;">find</span>(category)
        category <span style="color:#E28964;">=</span> c.<span style="color:#89BDFF;">direct_children</span>.<span style="color:#89BDFF;">collect</span> {|<span style="color:#3E87E3;">i</span>| i.<span style="color:#89BDFF;">id</span> } <span style="color:#E28964;">&lt;&lt;</span> c.<span style="color:#89BDFF;">id</span> <span style="color:#E28964;">if</span> c.<span style="color:#89BDFF;">direct_children</span>.<span style="color:#89BDFF;">size</span> <span style="color:#E28964;">&gt;</span> <span style="color:#3387CC;">0</span>
      <span style="color:#E28964;">end</span>
      query_str <span style="color:#E28964;">&lt;&lt;</span> <span style="color:#65B042;"><span style="color:#65B042;">&quot;</span>category_assignments.category_id IN (?)<span style="color:#65B042;">&quot;</span></span>
      query_prms <span style="color:#E28964;">&lt;&lt;</span> category
    <span style="color:#E28964;">end</span>
    conditions <span style="color:#E28964;">=</span> [query_str.<span style="color:#89BDFF;">join</span>(<span style="color:#65B042;"><span style="color:#65B042;">&quot;</span> AND <span style="color:#65B042;">&quot;</span></span>)] <span style="color:#E28964;">+</span> query_prms
    <span style="color:#E28964;">if</span> query.<span style="color:#89BDFF;">blank?</span>
      companies <span style="color:#E28964;">=</span> <span style="color:#9B859D;">Company</span>.<span style="color:#89BDFF;">paginate</span>(<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>conditions</span>=&gt; conditions, <span style="color:#3387CC;"><span style="color:#3387CC;">:</span>page</span> =&gt; page, <span style="color:#3387CC;"><span style="color:#3387CC;">:</span>joins</span> =&gt; <span style="color:#3387CC;"><span style="color:#3387CC;">:</span>category_assignments</span>, <span style="color:#3387CC;"><span style="color:#3387CC;">:</span>per_page</span> =&gt; per_page)
    <span style="color:#E28964;">else</span>
      companies <span style="color:#E28964;">=</span> <span style="color:#9B859D;">Company</span>.<span style="color:#89BDFF;">find_by_contents</span>(query, {<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>page</span> =&gt; page, <span style="color:#3387CC;"><span style="color:#3387CC;">:</span>per_page</span> =&gt; per_page}, <span style="color:#3387CC;"><span style="color:#3387CC;">:</span>joins</span> =&gt; <span style="color:#3387CC;"><span style="color:#3387CC;">:</span>category_assignments</span>, <span style="color:#3387CC;"><span style="color:#3387CC;">:</span>conditions</span> =&gt; conditions )  
    <span style="color:#E28964;">end</span>
    <span style="color:#E28964;">return</span> companies.<span style="color:#89BDFF;">uniq</span>
  <span style="color:#E28964;">end</span>
</pre>
          </div>
        </div>

<a href="http://refactormycode.com/codes/374-ferret-pagination-and-multiple-joins" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://refactormycode.com/images/small_logo.gif" style="border:0" /></a>

counter free hit invisible