File: /var/www/unbox/uc-live/admin-dash/txn_detail.php
<?php
include("../wp-config.php");
date_default_timezone_set("Asia/Calcutta");
$curDate = date('Y-m-d H:i:s'); // add 5 hrs 30 min in curr time
?>
<style>
.table> :not(caption)>*>* {
padding: 0.4rem 0.85rem;
}
</style>
<div class="table-responsive">
<?php
// query to get invoice detail as per id
$txn_id = $_REQUEST['id'];
if ($txn_id != '') {
$invcData = $wpdb->get_row("SELECT * FROM unbox_invoice where invoice_id=$txn_id");
?>
<table class="table table-hover table-responsive">
<tbody>
<tr>
<td class="col-md-4"><em> Customer Name </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->customer_name; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Customer Email</em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->customer_email; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Customer Mobile</em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->customer_mobile; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Customer Address</em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->customer_address . ' ,' . $invcData->customer_state_name; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Domain </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->from_domain; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Vendor </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->if_vendor; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Transaction Type </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->transaction_type; ?></td>
</tr>
<tr>
<td class="col-md-4"><em> Customer Name </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->customer_name; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Payment For</em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->payment_for; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Payment Type</em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->payment_type; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Order Id</em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->order_id; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Product MRP </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->product_mrp; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>GST Rate </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->gst_rate; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>IGST Amount </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->igst_amount; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>CGST Amount </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->cgst_amount; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>SGST Amount </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->sgst_amount; ?></td>
</tr>
<tr>
<td class="col-md-4"><em> Taxable Amount </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->taxable_amount; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Unbox Amount</em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->unbox_amount; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Discount Amount</em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->discount_amount; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Net Amount</em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->net_amount; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>GST Name </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->customer_gst_name; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>GSTin </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->customer_gstin; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Transaction Date </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->transaction_date; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Transaction ID1</em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->transaction_id1; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Transaction ID2</em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->transaction_id2; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Reference Name1 </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->ref_name1; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Reference ID1 </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->ref_id1; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Reference Name2 </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->ref_name2; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Reference ID2 </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->ref_id2; ?></td>
</tr>
<tr>
<td class="col-md-4"><em><?php echo $invcData->ref_name3; ?> </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->ref_id3; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Year Extension </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->year_extn; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Invoice Issue Date</em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->invoice_issue_date; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>If Cancelled Reason</em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->cancelled_reason_if_any; ?></td>
</tr>
<tr>
<td class="col-md-4"><em>Invoice Status </em> </td>
<td class="col-md-6 text-center"><?php echo $invcData->invoice_status; ?></td>
</tr>
</tbody>
</table>
<?php } ?>
</div>