public static function getTotalInvestorBid($account_id, $status = false, $isadmin = false) { if ($status) { if (strtolower(session::get('account_type')) == 'investor' || strtolower(session::get('account_type')) == 'entrepreneur') { $res = DB::select("select count(mradicampaignbids.id) AS 'count', sum(Amount) as 'amount', tbl_campaigns.campaignstatus from tbl_campaigns inner join mradicampaignbids on tbl_campaigns.uniqueid = mradicampaignbids.campaign_id where mradicampaignbids." . strtolower(session::get('account_type')) . "_id = ? AND LOWER(tbl_campaigns.campaignstatus) = ? GROUP BY tbl_campaigns.campaignstatus", array($account_id, 'ongoing')); } else { $res = DB::select("select count(mradicampaignbids.id) AS 'count', sum(Amount) as 'amount', tbl_campaigns.campaignstatus from tbl_campaigns inner join mradicampaignbids on tbl_campaigns.uniqueid = mradicampaignbids.campaign_id where LOWER(tbl_campaigns.campaignstatus) = ? GROUP BY tbl_campaigns.campaignstatus", array('ongoing')); } $bidded = $res; } else { if ($account_id != "guest" && (strtolower(session::get('account_type')) == 'investor' || strtolower(session::get('account_type')) == 'entrepreneur')) { $bidded = Mradicampaignbid::Where(strtolower(session::get('account_type')) . '_id', $account_id)->Where('mraditransactiontype_id', '2'); } else { if ($isadmin) { $acctType = Helpers::getinvestorDetails($account_id)->account_type; $bidded = Mradicampaignbid::Where(strtolower($acctType) . '_id', $account_id)->Where('mraditransactiontype_id', '2'); } else { $bidded = Mradicampaignbid::Where('mraditransactiontype_id', '2'); } } } return $bidded; }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($campaign_id) { $transactions = Mradicampaignbid::where('campaign_id', $campaign_id)->orderBy('id', 'desc')->paginate(15); //total amount bidded $myBid = Helpers::getTotalBidded($campaign_id); $totalBid = $myBid ? $myBid->total_bidded : '0'; //campaign value $investment = Helpers::getTotalInvestment($campaign_id); $campaignValue = $investment ? $investment[0]->total_investment : 0; //no of investors $investorCount = $transactions->count(); //online bids $totalOnlineBid = Helpers::getTotalInvestorBid(Session::get('account_id'), true); return View::make('admin.pages.campaign_bid_view')->with(compact('campaign_id', 'totalBid', 'campaignValue', 'investorCount', 'totalOnlineBid'))->withObjects($transactions); }