public function update($id)
{
// save updated
$record = $this->records->find($id);
if (!$record) {
Applicantfinancial::create(Input::all());
return $this->respond($record);
}
$record->fill(Input::all())->save();
return $this->respond($record);
}
public function run()
{
DB::table('applicantfinancials')->delete();
//8 - Ag-Input
Applicantfinancial::create(['loan_id' => 1, 'applicant_id' => 8, 'cpa_financials' => 1, 'credit_score' => 780, 'experience' => 36, 'grade' => 'A', 'amount_requested' => 250000, 'year_1_revenue' => 2130576, 'year_1_expenses' => 1000000, 'year_2_revenue' => 1937418, 'year_2_expenses' => 900000, 'year_3_revenue' => 2950500, 'year_3_expenses' => 1000000, 'current_assets' => 3255079, 'current_assets_factor' => 15, 'current_assets_liability' => 710285, 'intermediate_assets' => 2831750, 'intermediate_assets_factor' => 40, 'intermediate_assets_liability' => 776456, 'fixed_assets' => 3590675, 'fixed_assets_factor' => 25, 'fixed_assets_liability' => 1246794, 'debt2asset_ratio' => 21, 'debt2asset_ratio_adj' => 33, 'ratio_current' => 409, 'ratio_current_adj' => 362, 'capWork' => 114, 'capWork_adj' => 91, 'capBorrow' => 69, 'capBorrow_adj' => 57]);
//2 - Ag-Input
Applicantfinancial::create(['loan_id' => 1, 'applicant_id' => 1, 'cpa_financials' => 1, 'credit_score' => 730, 'experience' => 36, 'grade' => 'A', 'amount_requested' => 1000000, 'year_1_revenue' => 1842701, 'year_1_expenses' => 1000000, 'year_2_revenue' => 1937418, 'year_2_expenses' => 900000, 'year_3_revenue' => 2845790, 'year_3_expenses' => 800000, 'current_assets' => 1555079, 'current_assets_factor' => 15, 'current_assets_liability' => 410285, 'intermediate_assets' => 2831750, 'intermediate_assets_factor' => 40, 'intermediate_assets_liability' => 776456, 'fixed_assets' => 3590675, 'fixed_assets_factor' => 25, 'fixed_assets_liability' => 1246794, 'debt2asset_ratio' => 31, 'debt2asset_ratio_adj' => 43, 'ratio_current' => 379, 'ratio_current_adj' => 322, 'capWork' => 114, 'capWork_adj' => 91, 'capBorrow' => 69, 'capBorrow_adj' => 57]);
//5 - Capital Bridge
Applicantfinancial::create(['loan_id' => 3, 'applicant_id' => 6, 'cpa_financials' => 1, 'credit_score' => 730, 'experience' => 2, 'grade' => 'D', 'amount_requested' => 500000, 'year_1_revenue' => 1842701, 'year_1_expenses' => 1000000, 'year_2_revenue' => 1937418, 'year_2_expenses' => 900000, 'year_3_revenue' => 2845790, 'year_3_expenses' => 800000, 'current_assets' => 1555079, 'current_assets_factor' => 15, 'current_assets_liability' => 410285, 'intermediate_assets' => 2831750, 'intermediate_assets_factor' => 40, 'intermediate_assets_liability' => 776456, 'fixed_assets' => 3590675, 'fixed_assets_factor' => 25, 'fixed_assets_liability' => 1246794]);
//4 - Ag-Pro Fasttrack
Applicantfinancial::create(['loan_id' => 4, 'applicant_id' => 3, 'cpa_financials' => 1, 'credit_score' => 730, 'experience' => 3, 'grade' => 'C', 'amount_requested' => 750000, 'year_1_revenue' => 1842701, 'year_1_expenses' => 1000000, 'year_2_revenue' => 1937418, 'year_2_expenses' => 900000, 'year_3_revenue' => 2845790, 'year_3_expenses' => 800000, 'current_assets' => 1555079, 'current_assets_factor' => 15, 'current_assets_liability' => 410285, 'intermediate_assets' => 2831750, 'intermediate_assets_factor' => 40, 'intermediate_assets_liability' => 776456, 'fixed_assets' => 3590675, 'fixed_assets_factor' => 25, 'fixed_assets_liability' => 1246794]);
//6 - Ag-Vest
Applicantfinancial::create(['loan_id' => 5, 'applicant_id' => 4, 'cpa_financials' => 1, 'credit_score' => 730, 'experience' => 36, 'grade' => 'B', 'amount_requested' => 1400500, 'year_1_revenue' => 1842701, 'year_1_expenses' => 1000000, 'year_2_revenue' => 1937418, 'year_2_expenses' => 900000, 'year_3_revenue' => 2845790, 'year_3_expenses' => 800000, 'current_assets' => 1555079, 'current_assets_factor' => 15, 'current_assets_liability' => 410285, 'intermediate_assets' => 2831750, 'intermediate_assets_factor' => 40, 'intermediate_assets_liability' => 776456, 'fixed_assets' => 3590675, 'fixed_assets_factor' => 25, 'fixed_assets_liability' => 1246794]);
//3 - Ag-Pro
Applicantfinancial::create(['loan_id' => 6, 'applicant_id' => 2, 'cpa_financials' => 1, 'credit_score' => 770, 'experience' => 25, 'grade' => 'A', 'amount_requested' => 865000, 'year_1_revenue' => 1842701, 'year_1_expenses' => 1000000, 'year_2_revenue' => 1937418, 'year_2_expenses' => 900000, 'year_3_revenue' => 2845790, 'year_3_expenses' => 800000, 'current_assets' => 1555079, 'current_assets_factor' => 15, 'current_assets_liability' => 410285, 'intermediate_assets' => 2831750, 'intermediate_assets_factor' => 40, 'intermediate_assets_liability' => 776456, 'fixed_assets' => 3590675, 'fixed_assets_factor' => 25, 'fixed_assets_liability' => 1246794]);
//1 - All-In
Applicantfinancial::create(['loan_id' => 7, 'applicant_id' => 5, 'cpa_financials' => 1, 'credit_score' => 730, 'experience' => 36, 'grade' => 'B', 'amount_requested' => 2500000, 'year_1_revenue' => 1842701, 'year_1_expenses' => 1000000, 'year_2_revenue' => 1937418, 'year_2_expenses' => 900000, 'year_3_revenue' => 2845790, 'year_3_expenses' => 800000, 'current_assets' => 1555079, 'current_assets_factor' => 15, 'current_assets_liability' => 410285, 'intermediate_assets' => 2831750, 'intermediate_assets_factor' => 40, 'intermediate_assets_liability' => 776456, 'fixed_assets' => 3590675, 'fixed_assets_factor' => 25, 'fixed_assets_liability' => 1246794]);
//7 - Grain-Storage
Applicantfinancial::create(['loan_id' => 8, 'applicant_id' => 7, 'amount_requested' => 200000]);
}
