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});
}
