public function patient() { if (Config::get('gosmart.integrated_patient_database')) { $context = Context::find(Input::get('Context_Id')); $patients = DB::table('ItemSet_Patient')->whereExists(function ($q) { $q->select(DB::raw(1))->from('ItemSet_Segmentation')->whereRaw('ItemSet_Patient.Id = ItemSet_Segmentation.Patient_Id')->where('ItemSet_Segmentation.State', '=', 3); })->where('OrganType', '=', $context->Id)->get(); $output = []; foreach ($patients as $patient) { $output[$patient->Id] = $patient->Alias . ' (' . $patient->Description . ')'; } return $output; } return []; }
/** * 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')); }
public function getContextAttribute() { return Context::find($this->{Context::$idField}); }