public function evaluateWeight($id, $loan_id)
{
$finance = FinancialProfile::where('user_id', '=', $id)->first();
$count = LoanApp::where('user_id', '=', $id)->count();
$loan_app = LoanApp::where('loan_id', '=', $loan_id)->first();
$current_bids = Bid::where('loan_id', '=', $loan_id)->count();
$amout = $loan_app->amount;
$term = $loan_app->term;
$rate = $loan_app->pref_rate;
$residence = $finance->residence_status;
$year_income = $finance->monthly_income * 12;
$home_loan = $finance->home_loan;
$car_loan = $finance->car_loan;
$other_loan = $finance->other_loan;
$expense = $finance->loan_repayment;
$other_exp = $finance->other_expense;
$house_owner = 0;
if (strcmp($residence, 'Mortage') == 0 || strcmp($residence, 'noMortage') == 0) {
$house_owner = 1;
}
$property = $finance->property;
$vehicle = $finance->vehicle;
$share = $finance->share;
$other_property = $finance->others;
$active_loan = $total_liab = $home_loan + $car_loan + $other_loan;
$income_debt_ratio = $year_income / (1 + $count + $total_liab);
$total_assests = $property + $vehicle + $share + $other_property;
$disposable_income = $year_income - $total_liab;
$sum = $rate + $house_owner + $total_assests + $income_debt_ratio + $current_bids + $disposable_income;
$weight = pow($sum, 1 / 6);
//$loan_app-> weight = $weight;
return $weight;
}
public function buy($price)
{
$art->sold = 1;
$art->sold_for = $art->price;
$art->sold_to = Auth::user()->id;
$art->save();
Bid::where('art_id', $art_id)->delete();
watchlist::where('art_id', $art_id)->delete();
}
public function updateProgress($loan_id, $bid_id)
{
$current_sum = Bid::where('loan_id', '=', $loan_id)->sum('bid_amount');
$loan = loanApp::where('loan_id', '=', $loan_id)->get();
$loan_amount = $loan->amount;
$progress = $current_sum / $loan_amount;
$loan->progress = $progress;
$loan->save();
return $progress;
}
public function deleteBid($bidId)
{
Bid::where('bid_id', '=', $bidId)->delete();
return Redirect::to('mytransaction');
}
public function current_bid_draft_from($vendor)
{
$bid = Bid::where('project_id', '=', $this->id)->where('vendor_id', '=', $vendor->id)->where_null('submitted_at')->first();
return $bid ? $bid : false;
}
