<?php
/**
* Description of payment-overview-orders
* @author IT TEAM BONOFACTUM
* @created Mar 14, 2015 3:07:25 PM
*/
use_class('payone');
$invoice_date_start = date('Y-m-d 00:00:00', strtotime(tep_db_prepare_input($_GET['ids'])));
$invoice_date_end = date('Y-m-d 23:59:59', strtotime(tep_db_prepare_input($_GET['ide'])));
$filter = "invoice_date >= '{$invoice_date_start}' AND invoice_date <= '{$invoice_date_end}'";
$payment_summary_data = payone::getPaymentSummaryData('A', $filter);
$content = 'Invoice Date from ' . date('d-m-Y', strtotime($invoice_date_start));
$content .= ' to ' . date('d-m-Y', strtotime($invoice_date_end));
if (count($payment_summary_data) > 0) {
$table = array();
$th = array();
$th['d'] = 'Invoice<br/>Date';
$th['d2'] = 'Invoice<br/>Due Date';
$th['c'] = 'Customer Name';
$th['o'] = 'Payment<br/>Method';
$th['id2'] = 'Order No';
$th['id3'] = 'Payone<br/>txid';
$th['p'] = 'Saldo<br/>(EUR)';
$table[] = $th;
foreach ($payment_summary_data as $dt) {
$tr = array();
$tr['d'] = date('d-m-Y', strtotime($dt['invoice_date']));
$tr['d2'] = date('d-m-Y', strtotime($dt['invoice_due_date']));
$tr['c'] = $dt['customers_name'];
$tr['o'] = $dt['payment_method'];
