I'm trying to create a function that after i run a search i can return a number specified in the results from the result set randomly.
Here is my code for the query
class Business extends Model
{
protected $table = 'businesses_old';
/*
* Return search result on bussinesses
* @param $params array
* @return mixed
*/
public static function search($params){
$businesses = self::query();
if(isset($params['business']) && $params['business']!=''){
$businesses->where('name','like', "%".$params['business']."%");
/*$businesses->orWhere('contact_first_name','like', "%".$params['business']."%");
$businesses->orWhere('contact_last_name','like', "%".$params['business']."%");
$businesses->orWhere('email','like', "%".$params['business']."%");
$businesses->orWhere('address_1','like', "%".$params['business']."%");
$businesses->orWhere('address_2','like', "%".$params['business']."%");*/
$businesses->orWhere('website','like', "%".$params['business']."%");
/*$businesses->orWhere('city','like', "%".$params['business']."%");*/
$businesses->orWhere('description','like', "%".$params['business']."%");
/*$businesses->orWhere('state','like', "%".$params['business']."%");*/
}
$businesses->orderBy('name','ASC');
return $businesses->paginate(20);
}
public static function InRandom($businesses) {
$random = inRandomOrder($businesses);
}
}
Here is the code for the search controller
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Input;
use App\Business;
class SearchController extends Controller
{
/**
* Display search form
*
* @return mixed
*/
public function index(){
return view('search/index');
}
/**
* Display search results
*
* @return mixed
*/
public function indexHandle(){
$params=[];
if($business = Input::get('business')){
$params['business']=$business;
}
$businesses='';
if(!empty($params)){
$businesses=Business::search($params);
}else{
return redirect('/search');
}
return view('search/result', compact('businesses','business'));
}
}
from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2tI3hac
via IFTTT
Aucun commentaire:
Enregistrer un commentaire