在數(shù)據(jù)搜索時(shí)最常見(jiàn)的就是調(diào)用同一個(gè)方法查詢，而查詢的字段卻可能是其中一個(gè)或其中的幾個(gè)字段一起組合查詢，例如：對(duì)列表的搜索，基本上都是幾個(gè)字段隨意組合搜索。那么在model里就需要判斷有那個(gè)字段組合，怎么組合。
網(wǎng)上找了很久，Laravel群里也問(wèn)了幾個(gè)，都說(shuō)沒(méi)有寫(xiě)過(guò)，于是自己寫(xiě)個(gè)吧。話不多說(shuō)，見(jiàn)代碼：
function findByParam($param = array())
{
$select = new Customer();
if (isset($param['name']) '' != $param['name'])
{
$select = $select->where('customer.name', '=', $param['name']);
}
if (isset($param['phone']) '' != $param['phone'])
{
$select = $select->where('customer.phone', '=', $param['phone']);
}
if (isset($param['email']) '' != $param['email'])
{
$select = $select->where('customer.email', '=', $param['email']);
}
if (isset($param['tel']) '' != $param['tel'])
{
$select = $select->where('customer.tel', '=', $param['tel']);
}
if (isset($param['qq']) '' != $param['qq'])
{
$select = $select->where('customer.qq', '=', $param['qq']);
}
if (isset($param['IDCard']) '' != $param['IDCard'])
{
$select = $select->where('customer.IDCard', '=', $param['IDCard']);
}
$customers = $select->leftJoin("member", function ($join)
{
$join->on("customer.memberID", "=", "member.id");
})
->get(array(
'customer.id',
'customer.name',
'customer.sex',
'customer.tel',
'customer.phone',
'customer.address',
'customer.email',
'customer.qq',
'customer.headPic',
'customer.birthday',
'customer.IDCard',
'customer.enable',
'customer.memberID',
'customer.IDCard',
'customer.info',
'member.name as mname',
'member.discount'
));
return json_encode($customers);
function anyFindbyparam()
{
$name = Input::get('name');
$tel = Input::get('tel');
$phone = Input::get('phone');
$email = Input::get('email');
$qq = Input::get('qq');
$IDCard = Input::get('IDCard');
$customer = new Customer();
$customers = $customer->findByParam(array(
'name' => $name,
'tel' => $tel,
'phone' => $phone,
'email' => $email,
'qq' => $qq,
'IDCard' => $IDCard
));
return $customers;
}
以上這篇Laravel Eloquent ORM 多條件查詢的例子就是小編分享給大家的全部?jī)?nèi)容了，希望能給大家一個(gè)參考，也希望大家多多支持腳本之家。
