public function importReferrals($singleRow, $benefiter_id)
{
// referrals lookup ids
$social_referrence_lookup_id = BenefiterReferrals_lookup::where('description', 'LIKE', '%οινων%')->first()->id;
$medical_referrence_lookup_id = BenefiterReferrals_lookup::where('description', 'LIKE', '%ατρικ%')->first()->id;
$legal_referrence_lookup_id = BenefiterReferrals_lookup::where('description', 'LIKE', '%ομικ%')->first()->id;
$educational_referrence_lookup_id = BenefiterReferrals_lookup::where('description', 'LIKE', '%δευση%')->first()->id;
// if social referral
if ($this->greekStringConversion->grstrtoupper($singleRow->has_social_reference) == 'ΝΑΙ') {
BenefiterReferrals::insert($this->selectOnlyReferrals($singleRow->social_reference_actions, $singleRow->social_reference_date, $benefiter_id, $social_referrence_lookup_id));
}
// if medical referral
if ($this->greekStringConversion->grstrtoupper($singleRow->has_medical_reference) == 'ΝΑΙ') {
BenefiterReferrals::insert($this->selectOnlyReferrals($singleRow->medical_reference_actions, $singleRow->medical_reference_date, $benefiter_id, $medical_referrence_lookup_id));
}
// if legal referral
if ($this->greekStringConversion->grstrtoupper($singleRow->has_legal_reference) == 'ΝΑΙ') {
BenefiterReferrals::insert($this->selectOnlyReferrals($singleRow->legal_reference_actions, $singleRow->legal_reference_date, $benefiter_id, $legal_referrence_lookup_id));
}
// if educational referral
if ($this->greekStringConversion->grstrtoupper($singleRow->has_educational_reference) == 'ΝΑΙ') {
BenefiterReferrals::insert($this->selectOnlyReferrals($singleRow->educational_reference_actions, $singleRow->educational_reference_date, $benefiter_id, $educational_referrence_lookup_id));
}
}
public function deleteBasicInfoReferral($id, $referral_id)
{
BenefiterReferrals::where('id', '=', $referral_id)->delete();
return redirect('benefiter/' . $id . '/basic-info')->with("success", \Lang::get('records_controller_messages.referrals_delete_success'));
}
public function get_referrals_for_a_benefiter($id)
{
$benefiter_referrals_list = BenefiterReferrals::join('users', 'benefiter_referrals.user_id', '=', 'users.id')->where('benefiter_id', $id)->with('referralType')->orderBy('referral_date', 'desc')->get();
return $benefiter_referrals_list;
}
