mercredi 19 juillet 2017

laravel5 -> how to return 100 results from a query randomly

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