<?php
$investor = Helpers::getinvestorDetails($transaction->user_id);
?>
{{ HTML::link('wallet/'.$transaction->user_id, @strtoupper($investor->firstname . " " . $investor->lastname), array("class" => "")) }}
</td>
<td>{{ $amount = $transaction->credit > 0 ? number_format($transaction->credit,2) . " (+)" : number_format($transaction->debit,2) . " (-)" }}</td>
<td>{{ number_format($transaction->balance,2) }}</td>
<td>{{ $transaction->updated_at }}</td>
@else
<td>{{ $transaction->id }}</td>
<td>{{ $transaction->mraditransactiontype['desc'] }}</td>
<td>{{ $transaction->order_id }}</td>
@if(strtolower(Session::get('account_type')) == 'entrepreneur')
<td> @if($transaction->mraditransactiontype['id'] == '2')
<?php
$investor = Helpers::getinvestorDetails($transaction->mradicampaignbid['investor_id']);
?>
{{ @strtoupper($investor->firstname . " " . $investor->lastname) }}
@endif </td>
@else
<td> @if($transaction->mraditransactiontype['id'] == '1')
{{ $transaction->mraditransactionlog['trx_id'] }}
@endif </td>
<td>@if($transaction->mraditransactiontype['id'] == '1')
{{ $transaction->mraditransactionlog['currency'] }}
@endif</td>
<td>@if($transaction->mraditransactiontype['id'] == '1')
{{ $transaction->mraditransactionlog['channel'] }}
@endif</td>
@endif
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;
}
</tr>
</thead>
<tbody>
@foreach($mytransactions as $transaction)
<tr>
<td>{{ $transaction->id }}</td>
<td><?php
$hLink = URL::route('campaigns_grid_info', array('campaign' => $transaction->campaign_id));
?>
{{
HTML::link($hLink, strtoupper(Helpers::getCampaignID($transaction->campaign_id, true)), array("class" => ""));
}}
</td>
<?php
$investor = Helpers::getinvestorDetails($transaction->investor_id);
?>
<td>{{ @strtoupper($investor->firstname . " " . $investor->lastname) }}</td>
<td>{{ $transaction->order_id }}</td>
<td>{{ number_format($transaction->amount,2) }}</td>
<td>{{ number_format($transaction->total_bidded,2) }}</td>
<td>{{
number_format((Helpers::getCampaignProposal($transaction->campaign_id)[0]->total_investment - $transaction->total_bidded),2)
}}</td>
<td>{{ strtoupper(Helpers::getCampaignID($transaction->campaign_id, '', true)->campaignstatus) }}</td>
<td>{{ $transaction->updated_at }}</td>
</tr>
@endforeach
</tbody>
</table>
