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

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

不言

Release： 2023-03-30 06:06:02

Original

2122 people have browsed it

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->whereAll($data);
   return $where;
 }
 else
 {
   return false;
 }
}
/*多条件模糊*/
public function whereAll($data)
{
  $query = new ReportMainpage();
  $results = $query->where(function ($query) use ($data) {
    $data[&#39;report_first_received_date&#39;] && $query->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;] && $query->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;] && $query->where(&#39;aecountry_id&#39;, $data[&#39;aecountry_id&#39;]);
    $data[&#39;received_fromid_id&#39;] && $query->where(&#39;received_fromid_id&#39;, $data[&#39;received_fromid_id&#39;]);
    $data[&#39;research_id&#39;] && $query->where(&#39;research_id&#39;, &#39;like&#39;, &#39;%&#39; . $data[&#39;research_id&#39;] . &#39;%&#39;);
    $data[&#39;center_number&#39;] && $query->where(&#39;center_number&#39;, &#39;like&#39;, &#39;%&#39; . $data[&#39;center_number&#39;] . &#39;%&#39;);
  })->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; => &#39;like&#39;,
  &#39;drug_name&#39; => &#39;like&#39;,
  &#39;event_term&#39; => &#39;like&#39;,
  &#39;organize_role_id&#39; => &#39;=&#39;,
  &#39;case_causality&#39; => &#39;=&#39;,
  &#39;report_type&#39; => &#39;=&#39;,
  &#39;task_user_id&#39; => &#39;=&#39;,
  &#39;status&#39; => &#39;=&#39;,
];
/*获取查询条件*/
$where = $this->searchArray($searchFields);
/*获取数据*/
$this->reportTaskRepo->pushCriteria(new OrderBySortCriteria(&#39;asc&#39;, &#39;task_countdown&#39;));
$data = $this->reportTaskRepo->findWhere($where, $fields);
//在Trait里封装
/**
 * 获取请求中的参数的值
 * @param array $fields [description]
 * @return [type]     [description]
 */
public function searchArray($fields=[])
{
  $results = [];
  if (is_array($fields)) {
   foreach($fields as $field => $operator) {
     if(request()->has($field) && $value = $this->checkParam($field, &#39;&#39;, false)) {
      $results[$field] = [$field, $operator, "%{$value}%"];
     }
   }
  }
  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!