function createXexecRedemptionExport($post)
{
global $db;
setMyCookie($post, 'crukRed');
$CSVMaster = "<table>";
$sqlWhere = getRedeemSQL($post["EmpNum"]);
$dateSQL = getRedeemDates($post, "bo.");
$sql = "SELECT *\n \t\t\tFROM tblbasket b, tblbasketorders bo, tblempall a\n \t\t\tWHERE b.orderID IS NOT NULL \n\t\t\tAND b.orderID = bo.id \n\t\t\tAND b.EmpNum = a.EmpNum \n\t\t\t" . $sqlWhere . $dateSQL . " ORDER BY bo.id DESC";
$stmt = $db->prepare($sql);
$stmt->execute();
$CSVLine .= "<tr>";
if ($post["NomineeID"] == "yes") {
$CSVLine .= "<td>Nominee ID</td>";
}
if ($post["Nominee"] == "yes") {
$CSVLine .= "<td>Nominee</td>";
}
if ($post["Department"] == "yes") {
$CSVLine .= "<td>Department</td>";
}
if ($post["NomGrade"] == "yes") {
$CSVLine .= "<td>Grade</td>";
}
if ($post["RedeemDate"] == "yes") {
$CSVLine .= "<td>Redeem Date</td>";
}
if ($post["TransCode"] == "yes") {
$CSVLine .= "<td>Order Ref</td>";
}
if ($post["ProdCat"] == "yes") {
$CSVLine .= "<td>Product Category</td>";
}
if ($post["Product"] == "yes") {
$CSVLine .= "<td>Product</td>";
}
if ($post["AmountSpent"] == "yes") {
$CSVLine .= "<td>Amount Spent</td>";
}
if ($post["CurrentBalance"] == "yes") {
$CSVLine .= "<td>Current Balance</td>";
}
$CSVLine .= "<td>Address 1</td>";
$CSVLine .= "<td>Address 2</td>";
$CSVLine .= "<td>Town</td>";
$CSVLine .= "<td>Postcode</td>";
$CSVLine .= "</tr>";
$CSVMaster .= $CSVLine;
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$CSVLine = "<tr>";
$dbline = $row;
$Nominee = getUser($dbline["EmpNum"]);
$EmpAwards = getAvailable($dbline["EmpNum"]);
$ProdData = getProductByID($dbline["prID"]);
$CCTrans = getCCTransaction($dbline["orderID"]);
$prodCat = getProductCategory($ProdData["subID"]);
// We check each field and then add it to the CSV
if ($post["NomineeID"] == "yes") {
$CSVLine .= "<td>" . $dbline["EmpNum"] . "</td>";
}
if ($post["Nominee"] == "yes") {
$CSVLine .= "<td>" . Trim($Nominee->Fname) . " " . Trim($Nominee->Sname) . "</td>";
}
if ($post["Department"] == "yes") {
$CSVLine .= "<td>" . Trim($Nominee->Department) . "</td>";
}
if ($post["NomGrade"] == "yes") {
$CSVLine .= "<td>" . Trim($Nominee->Grade) . "</td>";
}
if ($post["RedeemDate"] == "yes") {
$CSVLine .= "<td>" . $dbline["date"] . "</td>";
}
if ($post["TransCode"] == "yes") {
$CSVLine .= "<td>CR" . $dbline["orderID"] . "</td>";
}
if ($post["ProdCat"] == "yes") {
$CSVLine .= "<td>" . Trim($prodCat["label"]) . "</td>";
}
if ($post["Product"] == "yes") {
$CSVLine .= "<td>" . Trim($ProdData["aTitle"]) . "</td>";
}
$totalprice = floatval($dbline["totalPrice"]) + floatval($CCTrans->Amount);
if ($post["AmountSpent"] == "yes") {
$CSVLine .= "<td>" . Trim($totalprice) . "</td>";
}
if ($post["CurrentBalance"] == "yes") {
$CSVLine .= "<td>" . $EmpAwards . "</td>";
}
$CSVLine .= "<td>" . Trim($dbline["address1"]) . "</td>";
$CSVLine .= "<td>" . Trim($dbline["address2"]) . "</td>";
$CSVLine .= "<td>" . Trim($dbline["town"]) . "</td>";
$CSVLine .= "<td>" . Trim($dbline["postcode"]) . "</td>";
$CSVLine .= "</tr>";
$CSVMaster .= $CSVLine;
}
$CSVMaster .= $CSVLine . "</table>";
return $CSVMaster;
}
<?php
include 'database.php';
header('Content-Type: text/plain; charset=utf-8');
if (isset($_POST['sale_order_id'])) {
$sale_order_id = $_POST['sale_order_id'];
}
if (isset($_POST['sale_order_line_id'])) {
$sale_order_line_id = $_POST['sale_order_line_id'];
$req = mysql_query("SELECT * FROM uc_order_products WHERE order_product_id={$sale_order_line_id} ") or die(mysql_error());
if (mysql_num_rows($req) > 0) {
$res = mysql_fetch_array($req);
$product_id = $res["nid"];
$category_list = getProductCategory($product_id);
$sql = "";
for ($i = 0; $i < count($category_list); $i++) {
$categories = split("/", $category_list[$i]);
$name = $categories[count($categories) - 1];
$sql .= "SELECT '" . $category_list[$i] . "' as category , tn.tid as distinction ";
$sql .= "FROM term_node tn ";
$sql .= "LEFT OUTER JOIN term_data td ON tn.tid = td.tid ";
$sql .= " where td.name='{$name}' ";
if (isset($product_id)) {
$sql .= " AND nid=" . $product_id . " ";
}
if ($i < count($category_list) - 1) {
$sql .= " UNION ";
}
}
if (!empty($sql)) {
echo executeSQL($sql);
