public function LendPref()
{
$id = Auth::user()->id;
$LendPrefers = LenderPref::where('id', '=', $id)->first();
$minAmount = $lenderPrefers->min_amount;
$minTerm = $lenderPrefers->min_term;
$minRate = $lenderPrefers->min_rate;
$maxAmount = $lenderPrefers->max_amount;
$maxTerm = $lenderPrefers->max_term;
$maxRate = $lenderPrefers->max_rate;
$data = array('minAmount' => $minAmount, 'minTerm' => $minTerm, 'minRate' => $minRate, 'maxAmount' => $maxAmount, 'minTerm' => $maxTerm, 'minRate' => $maxRate);
return View::make('lendPage')->with($data);
}
public function search()
{
$id = Auth::user()->id;
$lendPrefers = LenderPref::where('user_id', '=', $id)->first();
//get lender prferences
$maxAmount = $lendPrefers->max_amount;
$minAmount = $lendPrefers->min_amount;
$maxRate = $lendPrefers->max_rate;
$minRate = $lendPrefers->min_rate;
$maxTerm = $lendPrefers->max_term;
$minTerm = $lendPrefers->min_term;
$data = array('maxAmount' => $maxAmount, 'minAmount' => $minAmount, 'maxRate' => $maxRate, 'minRate' => $minRate, 'maxTerm' => $maxTerm, 'minTerm' => $minTerm);
//search for matched application
$loanApps = DB::table('loan_app')->join('profile', 'loan_app.user_id', '=', 'profile.id')->select('profile.fname', 'profile.lname', 'loan_app.amount', 'loan_app.pref_rate', 'loan_app.term', 'loan_app.purpose', 'loan_app.loan_id')->whereBetween('amount', array($data['minAmount'], $data['maxAmount']))->whereBetween('term', array($data['minTerm'], $data['maxTerm']))->whereBetween('pref_rate', array($data['minRate'], $data['maxRate']))->where('loan_app.user_id', '<>', $id)->orderBy('weight', 'DESC')->get();
return $loanApps;
}
