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