where('seller_id',$_SESSION['user']['id'])
->order_by_desc('id')
->find_many();
$total_item = count($rows);
foreach ($rows as $row)
{
$transactions[$count]['id'] = $row['id'];
$transactions[$count]['product_id'] = $row['product_id'];
$transactions[$count]['product_name'] = $row['product_name'];
$transactions[$count]['amount'] = price_format($row['amount']);
$transactions[$count]['payment_by'] = $row['transaction_gatway'];
$transactions[$count]['time'] = date('d M Y h:i A', $row['transaction_time']);
$pro_url = create_slug($row['product_name']);
//$product_link = $link['POST-DETAIL'].'/' . $row['product_id'] . '/'.$pro_url;
$transactions[$count]['product_link'] = "#";
$premium = '';
if($row['transaction_method'] == 'Subscription'){
$premium = ''.__("Membership").'';
} else if($row['transaction_method'] == 'prepaid_plan'){
$premium = ''.__("Prepaid Plan").'';
}
$t_status = $row['status'];
$status = '';
if ($t_status == "success") {
$status = ''.__("Success").'';
} elseif ($t_status == "pending") {
$status = ''.__("Pending").'';
} elseif ($t_status == "failed") {
$status = ''.__("Failed").'';
}else{
$status = ''.__("Cancel").'';
}
$transactions[$count]['premium'] = $premium;
$transactions[$count]['status'] = $status;
$transactions[$count]['invoice'] = $t_status == "success" ? $link['INVOICE'].'/'.$row['id']:'';
$count++;
}
//Print Template
HtmlTemplate::display('global/transaction', array(
'transactions' => $transactions,
'pages' => pagenav($total_item,$_GET['page'],20,$link['TRANSACTION'] ,0),
'total_item' => $total_item
));
exit;
}
else{
error(__("Page Not Found"), __LINE__, __FILE__, 1);
exit();
}
?>