title: How properly select data from DB according to filter in Eloquent?
body: <p>I have a filter.</p>
  
  <p>Filter contains three fields. <code>Call_Date_From</code>, <code>Call_Date_Till</code>, <code>Telephone</code>.</p>
  
  <p>So I need to select from <code>LEADS</code> (Lead Model) table all rows that fit filter.</p>
  
  <p>In raw Php + MySQL I would write something like this:</p>
  
  <pre><code>$sql = ' WHERE ';
  $post['call_date_from'] ? $sql .= ' `call_date` &gt;= ' . $post['call_date_from'];
  $post['call_date_till'] ? $sql .= ' AND `call_date` &lt;= ' . $post['call_date_till'];
  $post['telephone'] ? $sql .= ' AND `telephone` LIKE %' . $post['telephone'] . '%';
  
  mysql: 'SELECT * FROM LEADS' . $sql;
  </code></pre>
  
  <p>So how properly do the same in Laravel Eloquent?</p>