} 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; }