function deleteRemoved($lead_id, $expense_ids) { $lead = new Lead(); $applicantIds = $lead->getLeadApplicantIds($lead_id); $old_ids = LivingExpense::whereIn('applicant_id', $applicantIds)->lists('id')->toArray(); $removed_expenses = array_diff($old_ids, $expense_ids); LivingExpense::whereIn('id', $removed_expenses)->delete(); }
function add_others(array $request, $lead_id) { DB::beginTransaction(); try { $expense = new LivingExpense(); $expense->add($request, $lead_id); return true; if ($request['cars'] == 1) { foreach ($request['car_applicant_id'] as $key => $applicant_id) { $car = Car::create(['make_model' => $request['make_model'][$key], 'year_built' => $request['year_built'][$key], 'value' => $request['value'][$key], 'applicant_id' => $applicant_id]); if (isset($request['car_loan'][$key]) && $request['car_loan'][$key] == 1) { CarLoan::create(['to_be_cleared' => $request['to_be_cleared'][$key], 'lender' => $request['lender'][$key], 'debit_from' => $request['debit_from'][$key], 'limit' => $request['limit'][$key], 'balance' => $request['balance'][$key], 'applicant_id' => $applicant_id]); } } } if ($request['banks'] == 1) { foreach ($request['bank_applicant_id'] as $key => $applicant_id) { BankAccount::create(['bank' => $request['bank'][$key], 'balance' => $request['bank_balance'][$key], 'applicant_id' => $applicant_id]); } } if ($request['assets'] == 1) { foreach ($request['other_applicant_id'] as $key => $applicant_id) { OtherAsset::create(['applicant_id' => $applicant_id, 'type' => $request['other_type'][$key], 'value' => $request['other_value'][$key], 'home_content' => $request['home_content'][$key], 'superannuation' => $request['superannuation'][$key], 'deposit_paid' => $request['deposit_paid'][$key]]); } } if ($request['cards'] == 1) { foreach ($request['card_applicant_id'] as $key => $applicant_id) { CreditCard::create(['applicant_id' => $applicant_id, 'type' => $request['card_type'][$key], 'to_be_cleared' => $request['card_to_be_cleared'][$key], 'lender' => $request['card_lender'][$key], 'debit_from' => $request['card_debit_from'][$key], 'limit' => $request['card_limit'][$key], 'balance' => $request['card_balance'][$key]]); } } if ($request['incomes'] == 1) { foreach ($request['income_applicant_id'] as $key => $applicant_id) { OtherIncome::create(['applicant_id' => $applicant_id, 'type' => $request['income_type'][$key], 'credit_to' => $request['income_credit_to'][$key], 'monthly_net_income' => $request['monthly_net_income'][$key]]); } } //add or edit expense $expense = new LivingExpense(); $expense->add($request, $lead_id); DB::commit(); return true; } catch (\Exception $e) { DB::rollback(); dd($e); return false; } }