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