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);
}
