OpenCart 🇺🇦

$this->language->load('report/customer_credit');

$this->document->setTitle($this->language->get('heading_title'));

if (isset($this->request->get['filter_date_start'])) {
	$filter_date_start = $this->request->get['filter_date_start'];
} else {
	$filter_date_start = '';
}

if (isset($this->request->get['filter_date_end'])) {
	$filter_date_end = $this->request->get['filter_date_end'];
} else {
	$filter_date_end = '';
}

if (isset($this->request->get['page'])) {
	$page = $this->request->get['page'];
} else {
	$page = 1;
}

$url = '';

if (isset($this->request->get['filter_date_start'])) {
	$url .= '&filter_date_start=' . $this->request->get['filter_date_start'];
}

if (isset($this->request->get['filter_date_end'])) {
	$url .= '&filter_date_end=' . $this->request->get['filter_date_end'];
}

if (isset($this->request->get['page'])) {
	$url .= '&page=' . $this->request->get['page'];
}

$this->data['breadcrumbs'] = array();

$this->data['breadcrumbs'][] = array(
	'text'      => $this->language->get('text_home'),
	'href'      => $this->url->link('common/home', 'token=' . $this->session->data['token'], 'SSL'),
	'separator' => false
);

$this->data['breadcrumbs'][] = array(
	'text'      => $this->language->get('heading_title'),
	'href'      => $this->url->link('report/customer_credit', 'token=' . $this->session->data['token'] . $url, 'SSL'),
	'separator' => ' :: '
);

$this->load->model('report/customer');

$this->data['customers'] = array();

$data = array(
	'filter_date_start'	=> $filter_date_start, 
	'filter_date_end'	=> $filter_date_end, 
	'start'             => ($page - 1) * $this->config->get('config_admin_limit'),
	'limit'             => $this->config->get('config_admin_limit')
);

$customer_total = $this->model_report_customer->getTotalCredit($data); 

$results = $this->model_report_customer->getCredit($data);

foreach ($results as $result) {
	$action = array();

	$action[] = array(
		'text' => $this->language->get('text_edit'),
		'href' => $this->url->link('sale/customer/update', 'token=' . $this->session->data['token'] . '&customer_id=' . $result['customer_id'] . $url, 'SSL')
	);

	$this->data['customers'][] = array(
		'customer'       => $result['customer'],
		'email'          => $result['email'],
		'customer_group' => $result['customer_group'],
		'status'         => ($result['status'] ? $this->language->get('text_enabled') : $this->language->get('text_disabled')),
		'total'          => $this->currency->format($result['total'], $this->config->get('config_currency')),
		'action'         => $action
	);
}

$this->data['heading_title'] = $this->language->get('heading_title');

$this->data['text_no_results'] = $this->language->get('text_no_results');

$this->data['column_customer'] = $this->language->get('column_customer');
$this->data['column_email'] = $this->language->get('column_email');
$this->data['column_customer_group'] = $this->language->get('column_customer_group');
$this->data['column_status'] = $this->language->get('column_status');
$this->data['column_total'] = $this->language->get('column_total');
$this->data['column_action'] = $this->language->get('column_action');

$this->data['entry_date_start'] = $this->language->get('entry_date_start');
$this->data['entry_date_end'] = $this->language->get('entry_date_end');

$this->data['button_filter'] = $this->language->get('button_filter');

$this->data['token'] = $this->session->data['token'];

$url = '';

if (isset($this->request->get['filter_date_start'])) {
	$url .= '&filter_date_start=' . $this->request->get['filter_date_start'];
}

if (isset($this->request->get['filter_date_end'])) {
	$url .= '&filter_date_end=' . $this->request->get['filter_date_end'];
}

$pagination = new Pagination();
$pagination->total = $customer_total;
$pagination->page = $page;
$pagination->limit = $this->config->get('config_admin_limit');
$pagination->text = $this->language->get('text_pagination');
$pagination->url = $this->url->link('report/customer_credit', 'token=' . $this->session->data['token'] . $url . '&page={page}', 'SSL');

$this->data['pagination'] = $pagination->render();

$this->data['filter_date_start'] = $filter_date_start;
$this->data['filter_date_end'] = $filter_date_end;		

$this->template = 'report/customer_credit.tpl';
$this->children = array(
	'common/header',
	'common/footer'
);

$this->response->setOutput($this->render());