}
if (!isset($_GET['till'])) {
$_GET['till'] = '';
} else {
$_GET['till'] = rawurldecode($_GET['till']);
}
$show_tables = false;
$CurrDate = TransformDATEToTemplate(date("Y-m-d"));
if ($_GET['from']) {
if (isTemplateDate($_GET['from'])) {
$show_tables = true;
} else {
$error_date_format = true;
}
} elseif (!isset($_POST['from'])) {
$_GET['from'] = TransformDATEToTemplate(date("Y-m-01"));
} else {
$error_date_format = true;
}
if ($_GET['till']) {
if (isTemplateDate($_GET['till'])) {
$show_tables = $show_tables && true;
} else {
$show_tables = false;
$error_date_format = true;
}
} elseif (!isset($_POST['till'])) {
$_GET['till'] = $CurrDate;
$show_tables = false;
} else {
$show_tables = false;
/**
* Return array with commission information by order id
*
* @param integer $_OrderID
* @return array
*/
function affp_getCommissionByOrder($_OrderID)
{
$sql = "select cID, customerID, Amount, CurrencyISO3, xDateTime, Description, CustomerID\n FROM " . AFFILIATE_COMMISSIONS_TABLE . "\n WHERE OrderID=" . (int) $_OrderID;
$commission = db_fetch_row(db_query($sql));
if (!$commission['cID']) {
return $commission;
}
$commission['CustomerLogin'] = regGetLoginById($commission['customerID']);
$commission['Amount'] = sprintf("%.2f", $commission['Amount']);
list($_t) = explode(' ', $commission['xDateTime']);
$commission['xDateTime'] = TransformDATEToTemplate($_t);
return $commission;
}
