function addDetails($request, $key) { $address = Addresses::create(['line1' => $request['line1'][$key], 'line2' => $request['line2'][$key], 'suburb' => $request['suburb'][$key], 'state' => $request['state'][$key], 'postcode' => $request['postcode'][$key], 'country' => $request['country'][$key]]); $employment = EmploymentDetails::create(['employment_type' => $request['employment_type'][$key], 'job_title' => $request['job_title'][$key], 'starting_date' => $request['starting_date'][$key], 'business_name' => $request['business_name'][$key], 'abn' => $request['abn'][$key], 'contact_person' => $request['contact_person'][$key], 'contact_person_job_title' => $request['contact_person_job_title'][$key], 'contact_number' => $request['contact_number'][$key], 'address_id' => $address->id, 'is_current' => 1, 'applicant_id' => $request['applicant_id'][$key]]); if ($request['employment_type'][$key] == "Self Employed") { $accountant = new AccountantDetails(); $accountant->add($employment->id, $request, $key); } EmploymentIncome::create(['annual_gross_income' => $request['annual_gross_income'][$key], 'pay_frequency' => $request['pay_frequency'][$key], 'salary_crediting' => $request['salary_crediting'][$key], 'credit_to_where' => $request['credit_to_where'][$key], 'latest_pay_date' => $request['latest_pay_date'][$key], 'latest_payslip_period_from' => $request['latest_payslip_period_from'][$key], 'latest_payslip_period_to' => $request['latest_payslip_period_to'][$key], 'employment_detail_id' => $employment->id, 'applicant_id' => $request['applicant_id'][$key]]); }
function addProperty($request, $key) { $address = Addresses::create(['line1' => $request['line1'][$key], 'line2' => $request['line2'][$key], 'suburb' => $request['suburb'][$key], 'state' => $request['state'][$key], 'postcode' => $request['postcode'][$key], 'country' => $request['country'][$key]]); $property = Property::create(['taken_as_security' => $request['taken_as_security'][$key], 'market_value' => $request['market_value'][$key], 'property_usage' => $request['property_usage'][$key], 'applicant_id' => $request['applicant_id'][$key], 'property_type' => $request['property_type'][$key], 'number_of_bedrooms' => $request['number_of_bedrooms'][$key], 'number_of_bathrooms' => $request['number_of_bathrooms'][$key], 'number_of_car_spaces' => $request['number_of_car_spaces'][$key], 'size' => $request['size'][$key], 'title_particulars' => $request['title_particulars'][$key], 'title_type' => $request['title_type'][$key], 'address_id' => $address->id]); ValuationAccess::create(['access_party' => $request['access_party'][$key], 'contact_person' => $request['contact_person'][$key], 'phone_number' => $request['phone_number'][$key], 'property_id' => $property->id]); if ($request['rental_income'][$key] == 1) { Income::create(['property_id' => $property->id, 'type' => 'property', 'weekly_rental' => $request['weekly_rental'][$key], 'credit_to' => $request['credit_to'][$key]]); } if ($request['existing_loans'][$key] == 1) { ExistingLoan::create(['ownership' => $request['ownership'][$key], 'to_be_cleared' => $request['to_be_cleared'][$key], 'lender' => $request['lender'][$key], 'loan_type' => $request['loan_type'][$key], 'fixed_rate_term' => $request['fixed_rate_term'][$key], 'fixed_rate_expiry_date' => $request['fixed_rate_expiry_date'][$key], 'limit' => $request['limit'][$key], 'balance' => $request['balance'][$key], 'property_id' => $property->id]); } $property->save(); return $property->id; }
public function add($employment_id, $request, $key) { $business_address = Addresses::create(['line1' => $request['accountant_line1'][$key], 'line2' => $request['accountant_line2'][$key], 'suburb' => $request['accountant_suburb'][$key], 'state' => $request['accountant_state'][$key], 'postcode' => $request['accountant_postcode'][$key], 'country' => $request['accountant_country'][$key]]); AccountantDetails::create(['accountant_business_name' => $request['accountant_business_name'][$key], 'contact_person' => $request['accountant_contact_person'][$key], 'phone_number' => $request['accountant_phone_number'][$key], 'business_address_id' => $business_address->id, 'employment_details_id' => $employment_id]); }
function addAddressDetails($request, $key, $applicant_id) { $home_address = Addresses::create(['line1' => $request['home_line1'][$key], 'line2' => $request['home_line2'][$key], 'suburb' => $request['home_suburb'][$key], 'state' => $request['home_state'][$key], 'postcode' => $request['home_postcode'][$key], 'country' => $request['home_country'][$key]]); ApplicantAddress::create(['address_id' => $home_address->id, 'applicant_id' => $applicant_id, 'iscurrent' => 1, 'address_type_id' => 1, 'live_there_since' => $request['live_there_since'][$key]]); /*RentExpense::create([ 'weekly_rent_expense' => $request['weekly_rent_expense'][$key], 'applicant_id' => $applicant_id, 'debit_from' => $request['debit_from'][$key] ]);*/ $postal_address = Addresses::create(['line1' => $request['postal_line1'][$key], 'line2' => $request['postal_line2'][$key], 'suburb' => $request['postal_suburb'][$key], 'state' => $request['postal_state'][$key], 'postcode' => $request['postal_postcode'][$key], 'country' => $request['postal_country'][$key]]); ApplicantAddress::create(['address_id' => $postal_address->id, 'applicant_id' => $applicant_id, 'iscurrent' => 0, 'address_type_id' => 3]); $previous_address = Addresses::create(['line1' => $request['previous_line1'][$key], 'line2' => $request['previous_line2'][$key], 'suburb' => $request['previous_suburb'][$key], 'state' => $request['previous_state'][$key], 'postcode' => $request['previous_postcode'][$key], 'country' => $request['previous_country'][$key]]); ApplicantAddress::create(['address_id' => $previous_address->id, 'applicant_id' => $applicant_id, 'iscurrent' => 0, 'address_type_id' => 4]); }
function edit(array $request, $client_id) { DB::beginTransaction(); try { $client = Client::find($client_id); $client->preferred_name = $request['preferred_name']; $client->given_name = $request['given_name']; $client->surname = $request['surname']; $client->email = $request['email']; $client->salary = $request['salary']; $client->occupation = $request['occupation']; $client->salary_type = $request['salary_type']; $client->introducer = $request['introducer']; $client->title = $request['title']; $client->save(); /* Delete associated addresses and phone numbers... change this later for code optimization */ Client::find($client_id)->client_addresses()->with('address')->delete(); Client::find($client_id)->client_phones()->with('phone')->delete(); //change this later for multiple addresses $address = Addresses::create(['line1' => $request['line1'], 'line2' => $request['line2'], 'suburb' => $request['suburb'], 'state' => $request['state'], 'postcode' => $request['postcode'], 'country' => $request['country']]); ClientAddress::create(['ex_clients_id' => $client->id, 'address_type_id' => 1, 'is_current' => 1, 'address_id' => $address->id]); /* Add Phone numbers*/ $phone_numbers = $request['phone']; foreach ($phone_numbers as $key => $phone_num) { if ($phone_num != '') { $phone = Phone::create(['number' => $phone_num, 'type' => $request['phonetype'][$key]]); ClientPhone::create(['phones_id' => $phone->id, 'ex_clients_id' => $client->id]); } } DB::commit(); return $client->id; // all good } catch (\Exception $e) { DB::rollback(); dd($e); // something went wrong } if ($client) { return true; } else { return false; } }