where('customerType','Member')->where('status',1)->where('branch_id',Session::get('user')['branch_id'])->get(); foreach($methods as $row){ $i++; ?> where('borrower_id',$row->id)->where('date','like',$year)->where('branch_id',Session::get('user')['branch_id'])->sum('interest_paid'); //finding sum minimum balance for each month $months=DB::table('shareholders')->where('member_id',$row->id)->where('date','like',$year)->where('branch_id',Session::get('user')['branch_id'])->distinct('date')->count(); $share_sold = DB::table('shareholders')->where('member_id',$row->id)->where('date','like',$year)->where('branch_id',Session::get('user')['branch_id'])->sum('amount'); $share_purchased = DB::table('shareholders')->where('member_id',$row->id)->where('date','like',$year)->where('branch_id',Session::get('user')['branch_id'])->sum('amount'); $total_share= $share_purchased-$share_sold; //find sum minimum balance for each month $savings = DB::table('repaymentschedule')->where('borrower_id',$row->id)->where('date','like',$year)->where('branch_id',Session::get('user')['branch_id'])->sum('interest_paid'); //find value of entered honoraria for a member $honorarium = DB::table('repaymentschedule')->where('borrower_id',$row->id)->where('date','like',$year)->where('branch_id',Session::get('user')['branch_id'])->sum('interest_paid'); ?>

S/No	Name	Interest		Share		Savings		Honorarium		Total
	firstName))." ".ucfirst(strtoupper($row->middleName))." ".ucfirst(strtoupper($row->lastName))?>		interest 2	share 1	share 2	savings 1	savings 2	hono 1	honor 2	Jumla