private static function getBuilderWithParam($find_name, $find_age) { Log::info("*********************[FindPeople::getBuilderWithParam]*********************"); Log::info("********[find_name]************"); Log::info($find_name); Log::info("********[find_age]************"); Log::info($find_age); $name = false; $age = false; if ($find_name) { $name = true; } if ($find_age) { $age = true; } $results = array(); $explanation = ""; if ($name && !$age) { // Only Name Specified // First-name and Last-name search // $results = DB::table('FoundPeople') // ->where('first-name', '=', $updates_name) // ->orWhere('last-name', '=', $updates_name) // ->get(); // Substr match // $results = FindPeople::whereRaw('first_name LIKE ? and last_name LIKE ?', array( // '%'.$find_first_name.'%', '%'.$find_last_name.'%' // )); $results = Helper::searchTableForName(FindPeople::TABLE_NAME, $find_name); // TODO : separate out exact matches and substr matches and disp them separately } elseif ($age && !$name) { // Only Age Specified $results = FindPeople::where('age', '=', $find_age); } elseif ($name && $age) { // Name, Age Specified // $results = FindPeople::whereRaw('( first_name LIKE ? and last_name LIKE ? ) and age = ?', array( // '%'.$find_first_name.'%', '%'.$find_last_name.'%', $find_age // )); $results = Helper::searchTableForNameAndAge(FindPeople::TABLE_NAME, $find_name, $find_age); // TODO : separate out exact matches and substr matches and disp them separately } return $results; }