/** * Display a listing of the resource. * * @return Response */ public function index() { $combinations = Combination::with('PowerGenerator'); if (Input::has('Needle_Id')) { $combinations = $combinations->join('Combination_Needle', 'Combination_Needle.Combination_Id', '=', 'Combination.Combination_Id'); $combinations->whereNeedleId(Input::get('Needle_Id')); } if (Input::has('Numerical_Model_Id')) { $combinations->whereNumericalModelId(Input::get('Numerical_Model_Id')); } if (Input::has('Power_Generator_Id')) { $combinations->wherePowerGeneratorId(Input::get('Power_Generator_Id')); } if (Input::has('Protocol_Id')) { $combinations->whereProtocolId(Input::get('Protocol_Id')); } if (Input::has('Context_Id')) { if (Config::get('gosmart.context_as_enum')) { $combinations->where(Context::$idField, '=', Input::get('Context_Id')); } else { $combinations->whereContextId(Input::get('Context_Id')); } } if (Input::has('Modality_Id')) { $modality_id = Input::get('Modality_Id'); $combinations->whereHas('PowerGenerator', function ($query) use($modality_id) { $query->whereModalityId($modality_id); }); } if (Input::has('output')) { switch (Input::get('output')) { case 'Needle': $combination = $combinations->join('Combination_Needle', 'Combination_Needle.Combination_Id', '=', 'Combination.Combination_Id'); $output_ids = array_unique($combinations->get()->lists('Needle_Id')); return Needle::find($output_ids)->lists('Name', 'Id'); case 'Combination': return $combinations->get()->lists('asString', 'Combination_Id'); case 'Protocol': $output_ids = array_unique($combinations->get()->lists('Protocol_Id')); return Protocol::find($output_ids)->lists('Name', 'Id'); case 'PowerGenerator': $output_ids = array_unique($combinations->get()->lists('Power_Generator_Id')); return PowerGenerator::find($output_ids)->lists('Name', 'Id'); case 'NumericalModel': $output_ids = array_unique($combinations->get()->lists('Numerical_Model_Id')); return NumericalModel::find($output_ids)->lists('Name', 'Id'); case 'Context': if (Config::get('gosmart.context_as_enum')) { $output_ids = array_unique($combinations->get()->lists('Context_Id')); } else { $output_ids = array_unique($combinations->get()->lists('OrganType')); } return Context::find($output_ids)->lists('Name', 'Id'); case 'Modality': $combinations = $combinations->join('Power_Generator', 'Power_Generator.Id', '=', 'Combination.Power_Generator_Id')->select('Power_Generator.Modality_Id AS Modality_Id'); $output_ids = array_unique($combinations->get()->lists('Modality_Id')); return Modality::find($output_ids)->lists('Name', 'Id'); } return $combinations; } $combinations = $combinations->get()->sortBy(function ($c) { return $c->Power_Generator->Modality->Name; }); return View::make('combinations.index', compact('combinations')); }