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 get_basic_info_referrals_from_lookup() { $basic_info_referral = BenefiterReferrals_lookup::get()->all(); return $basic_info_referral; }