File: /www/exchange0old/exchange/classes/Display/DTransactions.php
<?php
include_once('admin/classes/Display/DBase.php');
class Display_DTransactions extends DBase
{
function displayStatements($recordSet)
{
$output='<tr class="grays_bg4">
<td align="left" valign="top"><b>Order ID </b></td>
<td align="right" valign="top"><b>Purchased</b></td>
<td align="left" width="10%" valign="top"><b>Download</b></td>
</tr>';
if(count($recordSet)==0)
{
return $output;
}
foreach($recordSet as $key)
{
$output.='<tr class="row1">
<td align="left" valign="top">'.$key['transaction_reference_id'].'</td>
<td align="right" valign="top">'.$key['order_date'].'</td>
<td align="center" valign="top">
<a target="_blank" href="index.php?do=statementsPDF&id='.$key['transaction_id'].'"><img alt="Download Report" src="../images/download_history_pdf.png" border="0"></a>
</td>
</tr>';
}
return $output;
}
function displayCreditReports($recordSet)
{
$output='<tr class="grays_bg4">
<td align="left" width="" valign="top"><b>Report Name </b></td>
<td align="center" valign="top"><b>Order ID</b></td>
<td align="right" valign="top"><b>Purchased</b></td>
<td align="left" width="10%" valign="top"><b>Experian</b></td>
<td align="left" width="10%" valign="top"><b>Creditsafe</b></td>
</tr>';
if(count($recordSet)==0)
{
return $output;
}
foreach($recordSet as $key)
{
$output.='<tr class="row1">
<td align="left" valign="top">'.$key['name'].'</td>
<td align="right" valign="top">'.$key['transaction_reference_id'].'</td>
<td align="right" valign="top">'.$key['order_date'].'</td>
<td align="left" valign="top">
<a target="_blank" href="index.php?do=reportPDF&id='.$key['transaction_id'].'&cart='.$key['shopping_cart_id'].'&p=1"><img alt="Download Report" src="../images/download_history_pdf.png" border="0"></a>
</td>
<td align="left" valign="top">
<a target="_blank" href="index.php?do=reportPDF&id='.$key['transaction_id'].'&cart='.$key['shopping_cart_id'].'&p=2"><img alt="Download Report" src="../images/download_history_pdf.png" border="0"></a>
</td>
</tr>';
}
return $output;
}
function showRetailInvestors($total,$recordSet)
{
$uri = explode("?",$_SERVER['REQUEST_URI']);
$url = 'index.php?do=intermedinvstatements';
$img=self::generateColumns(6,$uri[1] == 'do=invusers');
$recordSize=count($recordSet);
$output ='<tr class="grays_bg">
<td align="left" valign="top" width="4%"><b>No.</b></td>
<td align="left" width="11%" valign="top"><b>Date</b> '.$img[6].'</td>
<td align="left" width="" valign="top"><b>Investor</b> '.$img[1].'</td>
<td align="left" width="11%" valign="top"><b>Status</b> '.$img[4].' </td>
<td align="left" width="18%" valign="top"><b>Amount Invested</b> '.$img[2].' </td>
<td align="right" width="9%" valign="top"><b>Rate</b> '.$img[3].' </td>
<td align="right" width="16%" valign="top" colspan="16"><b>Options</b><script>
function redirect(sorts,type)
{
var str = "sort"+sorts;
var ordr = "order"+sorts;
var srch = "/("+str+"=)[0-9]&/g";
var uri = "'.$url.'";
var srchtxt = "'.$_REQUEST['srchtxt'].'";
uri = uri.replace(/(&page=)[0-9]/g, "");
self.location = uri+"&"+str+"="+sorts+"&"+ordr+"="+type+"&page=1&srchtxt="+srchtxt;
}
</script></td>
</tr>';
if($recordSize==0)
{
return $output.'<tr class="row1"><td valign="top" align="center" colspan="16">No Records Found</td></tr>';
}
$serialNo = Model_MHelpers::serialNo();
for($i=0;$i<$recordSize;$i++)
{
$output.='<tr class="'.(($i%2==0)?'row9':'row10').'">
<td align="left" valign="top">'.$serialNo++.'</td>
<td align="left" valign="top">'.$recordSet[$i]['date'].'</td>
<td width="" align="left" valign="top">'.self::substr($recordSet[$i]['retailer_name'],28);
$output .='</td>';
switch ($recordSet[$i]['status'])
{
case 0:
$orglink[$i] .="Invited";
break;
case 1:
$orglink[$i] .="Waiting for approval";
break;
case 2:
$orglink[$i] .="Invited User";
break;
case 3:
$orglink[$i] .="Activated";
break;
case 4:
$orglink[$i] .="Authorised";
break;
case 5:
$orglink[$i] .="Suspended";
break;
case 6:
$orglink[$i] .="Terminated";
break;
}
$output .='
<td align="left" valign="top">'.$orglink[$i].'</td>
<td align="right" valign="top">'.$recordSet[$i]['currency_code'].' amount_invested</td>
<td align="right" valign="top">'.number_format($recordSet[$i]['quote_rate'],3).' %</td>
<td align="right" valign="top" class="'.$class.'">
<a href="?do=retailinvusersview&uid='.$recordSet[$i]['uid'].'&flag='.$recordSet[$i]['flag'].'&view=sta&&pg='.$_REQUEST['page'].'">View </a> | <a href="?do=retailinvstatements&uid='.$recordSet[$i]['user_id'].'">Transactions </a></td></tr>';
}
$output.='<tr><td valign="top" align="right" colspan="21" class="pagination">'.self::generatePagination($total).'</td></tr>';
return $output;
}
function getManualTransDetails($recordSet,$recordSize)
{
if($recordSize==0)
{
return '';
}
$query = new Bin_Query();
for($i=0;$i<$recordSize;$i++)
{
$query->executeQuery("SELECT m.*, c.*,trans.*,DATE(trans.created_at) as created
FROM invoice_master m, invoice_closed c,manual_transactions trans
WHERE trans.manual_transaction_id='".$recordSet[$i]['manual_transaction_id']."' && m.debtor_id='".$_REQUEST['id']."' && m.user_id='".$_SESSION['user']['userid']."' && m.root_invoice_id > 0 && m.invoice_status = 3 && c.invoice_id = m.invoice_id && trans.manual_transaction_id=m.manual_transaction_id
GROUP BY m.invoice_id
ORDER BY trans.created_at DESC");
$transaction = $query->records;
for($j=0;$j<count($transaction);$j++)
{
$output.='<tr class="'.(($j%2==0)?'row2':'row1').'">
<td valign="top" align="center">'.$transaction[$j]['created'].'</td>
<td valign="top" align="left">'.$transaction[$j]['trade_reference_id'].'</td>
<td valign="top" align="right" style="border-right:4px solid #FFF;">'.$transaction[$j]['invoice_no'].'</td>
<td valign="top" align="right">'.number_format($transaction[$j]['amount'],2,'.',',').'</td>
<td valign="top" align="center"></td>
<td valign="top" align="right" style="border-right:4px solid #FFF;">'.number_format($transaction[$j]['balance'],2,'.',',').'</td>
<td valign="top" align="right"></td>
<td valign="top" align="right"></td>
<td valign="top" align="right"></td>
</tr>';
$price = $price+($purchasePrice);
$reserve = $reserve+($rebate);
$settle = $settle+($purchasePrice+$rebate);
$balance[$i] = $balance[$i];
$amount[$i] = $amount[$i] + $transaction[$j]['amount'];
}
$output.='<tr class="'.(($j%2==0)?'row2':'row1').'">
<td valign="top" align="left"></td>
<td valign="top" align="left"></td>
<td valign="top" align="left"></td>
<td valign="top" align="right"><strong>'.number_format($amount[$i],2,'.',',').'</strong></td>
<td valign="top" align="right">Balance</td>
<td valign="top" align="right"><strong>'.number_format($balance[$i],2,'.',',').'</strong></td>
<td valign="top" align="right">'.number_format($price,2,'.',',').'</td>
<td valign="top" align="right">'.number_format($reserve,2,'.',',').'</td>
<td valign="top" align="right"><strong>'.number_format($settle,2,'.',',').'</strong></td>
</tr>';
}
return $output;
}
function getPaymentOnAccDetails($recordSet,$recordSize)
{
if($recordSize==0)
{
return FALSE;
}
for($i=0;$i<$recordSize;$i++)
{
$output.='<tr class="'.(($i%2==0)?'row2':'row1').'">
<td valign="top" align="center">'.$recordSet[$i]['issuedate'].'</td>
<td valign="top" align="left">'.$recordSet[$i]['organisation_reference_id'].'</td>
<td valign="top" align="left">'.$recordSet[$i]['organisation_name'].'</td>
<td valign="top" align="right">'.number_format($recordSet[$i]['amount'],2,'.',',').'</td>
</tr>';
$amount += $recordSet[$i]['amount'];
}
$output.='<tr class="'.(($i%2==0)?'row2':'row1').'">
<td valign="top" align="left"></td>
<td valign="top" align="left"></td>
<td valign="top" align="right"><strong>Total</strong></td>
<td valign="top" align="right">'.number_format($amount,2,'.',',').'</td>
</tr>';
return $output;
}
}
?>