public function like_companies($stringPartial) { $companies = Pixie::table('companies')->where('biz_name', 'LIKE', "%{$stringPartial}%"); return $companies->get(); }
public function like_contacts($param) { $selectList = array('contacts.id', 'contacts.first_name', 'contacts.last_name', 'contacts.email', 'contacts.phone', 'companies.biz_name'); $contacts = Pixie::table('contacts')->select($selectList)->where('lookup', 'LIKE', "%{$param}%")->join('companies', 'companies.id', '=', 'company_id'); return $contacts->get(); }