/**
* Execute query and sql query
*
* @return xml if the query is a Select, a result message if not
*/
function executeSQL($sql, $db)
{
$query_type = explode(" ", trim($sql));
$result = $db->Execute($sql);
if (!$result) {
die('\\nInvalid query: ' . $sql . ' ' . mysql_error());
}
switch (strtoupper($query_type[0])) {
case "SELECT":
if ($result->RecordCount() > 0) {
$xml = '<xml>';
while (!$result->EOF) {
$xml .= '<object>';
/*print_r($result->fields);*/
foreach ($result->fields as $fieldname => $fieldvalue) {
if (!empty($fieldvalue)) {
$xml .= '<' . $fieldname . '>' . sanitizeStringForXML($fieldvalue) . '</' . $fieldname . '>';
}
}
$xml .= '</object>';
$result->MoveNext();
}
$xml .= '</xml>';
} else {
$xml = "<xml></xml>";
}
//$xml="\nNo record for your query!";
return $xml;
break;
/*case "INSERT":
break;
case "DELETE":
break; */
/*case "INSERT":
break;
case "DELETE":
break; */
default:
// In the case no objects is return, return an OK message
$xml = "\nQuery successfully processed!";
return $xml;
break;
}
//End switch
}
$req_select_2 .= "'0.00' AS discount_tax_rate ";
$req_select_2 .= "FROM " . TABLE_ORDERS . " ordr ";
$req_select_2 .= "LEFT OUTER JOIN " . orders_total . " tot ON (ordr.orders_id=tot.orders_id \n AND tot.class='ot_coupon') ";
$req_select_2 .= "WHERE ordr.orders_status = '1' AND tot.value>0 ";
$req_select_2 .= "AND ordr.orders_id = '" . $fieldvalue . "' ";
$result_select_2 = $db->Execute($req_select_2);
if ($result_select_2->RecordCount() > 0) {
$xml2 = "";
foreach ($result_select_2->fields as $fieldname2 => $fieldvalue2) {
if (!empty($fieldvalue2)) {
$xml2 .= '<' . $fieldname2 . '>' . sanitizeStringForXML($fieldvalue2) . '</' . $fieldname2 . '>';
}
}
}
}
$xml .= '<' . $fieldname . '>' . sanitizeStringForXML($fieldvalue) . '</' . $fieldname . '>';
}
}
$xml .= $xml1;
$xml .= $xml2;
$xml .= '</object>';
$result2->MoveNext();
}
$xml .= '</xml>';
echo $xml;
header('Content-type: text/xml');
//echo executeSQL($req_select_1, $db);
$db->close();
?>
