Method to implement fuzzy matching and multi-condition query function in Laravel5-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

Method to implement fuzzy matching and multi-condition query function in Laravel5

Jun 06, 2018 am 11:01 AM

Multi-condition query fuzzy matching

This article mainly introduces the method of implementing fuzzy matching and multi-condition query function in Laravel5, and analyzes Laravel5 multi-condition fuzzy query and related packaging operation skills in the form of examples. Friends in need can refer to it

The example of this article describes the method of implementing fuzzy matching and multi-condition query function in Laravel5. Share it with everyone for your reference, the details are as follows:

Method 1. ORM mode

public function ReportAccurate($data)
{
 if(is_array($data))
 {
   $where = $this-&gt;whereAll($data);
   return $where;
 }
 else
 {
   return false;
 }
}
/*多条件模糊*/
public function whereAll($data)
{
  $query = new ReportMainpage();
  $results = $query-&gt;where(function ($query) use ($data) {
    $data[&#39;report_first_received_date&#39;] &amp;&amp; $query-&gt;where(&#39;report_first_received_date&#39;, &#39;like&#39;, &#39;%&#39; . $data[&#39;report_first_received_date&#39;] . &#39;%&#39;);
    $data[&#39;report_drug_safety_date&#39;] &amp;&amp; $query-&gt;where(&#39;report_drug_safety_date&#39;, &#39;like&#39;, &#39;%&#39; . $data[&#39;report_drug_safety_date&#39;] . &#39;%&#39;);
    $data[&#39;aecountry_id&#39;] &amp;&amp; $query-&gt;where(&#39;aecountry_id&#39;, $data[&#39;aecountry_id&#39;]);
    $data[&#39;received_fromid_id&#39;] &amp;&amp; $query-&gt;where(&#39;received_fromid_id&#39;, $data[&#39;received_fromid_id&#39;]);
    $data[&#39;research_id&#39;] &amp;&amp; $query-&gt;where(&#39;research_id&#39;, &#39;like&#39;, &#39;%&#39; . $data[&#39;research_id&#39;] . &#39;%&#39;);
    $data[&#39;center_number&#39;] &amp;&amp; $query-&gt;where(&#39;center_number&#39;, &#39;like&#39;, &#39;%&#39; . $data[&#39;center_number&#39;] . &#39;%&#39;);
  })-&gt;get();
  return $results;
}

Copy after login

The $data above is the array passed from the front end and uses encapsulation and splicing to perform fuzzy or precise multi-condition search.

The bad part is that the code is not robust and is not conducive to maintenance

Method 2. The knowledge used by the master encapsulation method is the Repository warehouse

$fields = [&#39;id&#39;, &#39;report_id&#39;, &#39;report_identify&#39;, &#39;report_first_received_date&#39;, &#39;drug_name&#39;, &#39;first_event_term&#39;, &#39;case_serious&#39;, &#39;standard_of_seriousness&#39;, &#39;case_causality&#39;, &#39;received_from_id&#39;, &#39;task_user_name&#39;, &#39;organize_role_name&#39;, &#39;task_countdown&#39;, &#39;report_countdown&#39;];
/*查询的字段*/
$searchFields = [
  &#39;report_identify&#39; =&gt; &#39;like&#39;,
  &#39;drug_name&#39; =&gt; &#39;like&#39;,
  &#39;event_term&#39; =&gt; &#39;like&#39;,
  &#39;organize_role_id&#39; =&gt; &#39;=&#39;,
  &#39;case_causality&#39; =&gt; &#39;=&#39;,
  &#39;report_type&#39; =&gt; &#39;=&#39;,
  &#39;task_user_id&#39; =&gt; &#39;=&#39;,
  &#39;status&#39; =&gt; &#39;=&#39;,
];
/*获取查询条件*/
$where = $this-&gt;searchArray($searchFields);
/*获取数据*/
$this-&gt;reportTaskRepo-&gt;pushCriteria(new OrderBySortCriteria(&#39;asc&#39;, &#39;task_countdown&#39;));
$data = $this-&gt;reportTaskRepo-&gt;findWhere($where, $fields);
//在Trait里封装
/**
 * 获取请求中的参数的值
 * @param array $fields [description]
 * @return [type]     [description]
 */
public function searchArray($fields=[])
{
  $results = [];
  if (is_array($fields)) {
   foreach($fields as $field =&gt; $operator) {
     if(request()-&gt;has($field) &amp;&amp; $value = $this-&gt;checkParam($field, &#39;&#39;, false)) {
      $results[$field] = [$field, $operator, &quot;%{$value}%&quot;];
     }
   }
  }
  return $results;
}

Copy after login

The above is the detailed content of Method to implement fuzzy matching and multi-condition query function in Laravel5. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn