Customer Transaction Table is Empty

Code: Select all

 <?php
class ModelAccountTransaction extends Model {	
	public function getTransactions($data = array()) {
		$sql = "SELECT * FROM `" . DB_PREFIX . "customer_transaction` WHERE customer_id = '" . (int)$this->customer->getId() . "'";
		   
		$sort_data = array(
			'amount',
			'description',
			'date_added'
		);
	
		if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
			$sql .= " ORDER BY " . $data['sort'];	
		} else {
			$sql .= " ORDER BY date_added";	
		}
			
		if (isset($data['order']) && ($data['order'] == 'DESC')) {
			$sql .= " DESC";

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<modification>
<id><![CDATA[Customer Purchases]]></id>
<version><![CDATA[OS v.1.5.6.5]]></version>
<vqmver><![CDATA[2.4.1]]></vqmver>
<author><![CDATA[ecomteck.com]]></author>

<file name="admin/controller/sale/customer.php">
<operation error="abort">
<search position="after"><![CDATA[public function update() {]]></search>
<add><![CDATA[
	$this->language->load('eccustomerpurchases/order');
	$this->document->addScript('view/javascript/eccustomerpurchases/jquery.cookie.js');
]]></add>
</operation>
</file>

<file name="admin/view/template/sale/customer_form.tpl">
<operation  error="abort">
<search position="replace"><![CDATA[<a href="#tab-ip"><?php echo $tab_ip; ?></a></div>]]></search>
<add><![CDATA[
	<a href="#tab-ip"><?php echo $tab_ip; ?></a><?php if ($customer_id) { ?><a href="#tab-purchases"><i class="fa fa-sale fa-1x"></i><?php echo $this->language->get("tab_purchases"); ?></a><?php } ?></div>
]]></add>
</operation>

<operation  error="abort">
<search position="before"><![CDATA[<div id="tab-general">]]></search>
<add><![CDATA[
	<?php if($customer_id) { ?>
	<div id="tab-purchases">
	<?php  echo $this->getChild('eccustomerpurchases/order', array("customer_id"=>$customer_id)); ?>
	</div>
	<?php } ?>
]]></add>
</operation>
</file>
</modification>