public function paymentListInvestorDetail(Investment $invest)
{
$investment = Investment::where('id', '=', $invest->id)->first();
//echo $investment;
return view('investment/payment_list_investor_detail', compact('investment'));
}
public function paymentListBusinessIssuerDetail(Business $busi)
{
$business = Business::where('id', '=', $busi->id)->first();
//find total people of respective investors
$no_of_investor = Investment::where('business_id', '=', $business->id)->where('agreement', '=', 'accept')->count();
//find total of eligible offers from respective investors
// $total_eligible_offers = DB::table('investments')
// ->where('business_id','=',$business->id)
// ->where('agreement','=','accept')
// ->sum('amount_to_invest');
//get the percentage funded and round up the value
//$percentage_funded = round($total_eligible_offers / $business->amount * 100);
//find the minimum offer from investors
//$minimum_offer = DB::table('investments')->where('business_id','=',$business->id)->where('agreement','=','accept')->min('amount_to_invest');
//find the maximum offer from investors
//$maximum_offer = DB::table('investments')->where('business_id','=',$business->id)->where('agreement','=','accept')->max('amount_to_invest');
//find the lowest rate offer from investors
//$lowest_rate_offer = DB::table('investments')->where('business_id','=',$business->id)->where('agreement','=','accept')->min('target_return_rate');
//find the highest rate offer from investors
//$highest_rate_offer = DB::table('investments')->where('business_id','=',$business->id)->where('agreement','=','accept')->max('target_return_rate');
$investment = Investment::where('business_id', '=', $business->id)->where('agreement', '=', 'accept')->get();
return view('business/payment_list_business_issuer_detail', compact('business', 'no_of_investor', 'investment'));
}
