Laravel5實作模糊匹配功能-php教程-PHP中文網

Laravel5實作模糊匹配功能

小云云

發布： 2023-03-22 09:32:01

原創

2350 人瀏覽過

本文主要和大家介紹了Laravel5中實現模糊匹配加多條件查詢功能的方法,結合實例形式分析了Laravel5多條件模糊查詢及相關封裝操作技巧,希望能幫助到大家。

方法1. ORM模式

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;
}

登入後複製

上面的$data為前端傳過來的陣列利用封裝拼接進行模糊或精確的多條件搜素

不好的地方程式碼不健壯不利於維護

方法2. 大神封裝法利用到的知識是Repository 倉庫

$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;
}

登入後複製