Detailed explanation of the steps to implement fuzzy matching and multi-condition query function in Laravel5-PHP Tutorial-php.cn

Detailed explanation of the steps to implement fuzzy matching and multi-condition query function in Laravel5

php中世界最好的语言

Release： 2023-03-26 11:24:01

Original

1957 people have browsed it

This time I will bring you a detailed explanation of the steps to implement the fuzzy matching and multi-condition query function in Laravel5. What are the precautions for Laravel5 to implement the fuzzy matching and multi-condition query function. The following is a practical case. One Get up and take a look.

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 splicing to perform fuzzy or precise multiple conditions Sousu

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

I believe you have mastered the method after reading the case in this article. For more exciting information, please pay attention to other related articles on the php Chinese website!