<?php

class HomeController extends BaseController {

	/*
	|--------------------------------------------------------------------------
	| Default Home Controller
	|--------------------------------------------------------------------------
	|
	| You may wish to use controllers instead of, or in addition to, Closure
	| based routes. That's great! Here is an example controller method to
	| get you started. To route to this controller, just add the route:
	|
	|	Route::get('/', 'HomeController@showWelcome');
	|
	*/

	public function home()
	{

/*
		$user = User::whereNull('crypt_pass')->get();
		foreach ($user as $key => $one) {
			$old = $one->password;
			$new = Hash::make($old);

			$one->crypt_pass=$new;
			$one->update();
		}*/



		return View::make('home');
	}

	public function postSearch()
	{
		$what = Input::get('k');
    					
		$circolari = Circolari::where(function($query)
		{
			$what = Input::get('k');
			$query  ->where('numero','LIKE','%'. $what .'%')
					->orWhere('data_edizione','LIKE','%'. $what .'%')
			        ->orWhere('titolo','LIKE','%'. $what .'%');
		})->get();  //->paginate(12);

		$brokers = Broker::where(function($query)
		{
			$what = Input::get('k');
			$query  ->where('numero','LIKE','%'. $what .'%')
					->orWhere('testo','LIKE','%'. $what .'%')
			        ->orWhere('titolo','LIKE','%'. $what .'%');
		})->get();

		/*echo '<pre>';
		print_r($brokers->first()->titolo);
		echo '</pre>';*/
		//return;
				        
		return  View::make('cerca', ['k'=>$what])
				->with('circolari',$circolari)
				->with('brokers',$brokers);
	}

}