| DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY |
| THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT |
| (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE |
| OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. |
| |
+-------------------------------------------------------------------------+
*/
require "../../include/session.php";
if (!isset($_GET["id"])) {
$error = new appError(300, "Passed variable not set (id)");
}
$uuid = mysql_real_escape_string($_GET["id"]);
$querystatement = "\n SELECT\n IF(`discounts`.`type` + 0 = 1,concat(`discounts`.`value`,'%'),`discounts`.`value`) AS `value`\n FROM\n `discounts`\n WHERE\n `uuid`='" . $uuid . "'\n ";
$queryresult = $db->query($querystatement);
if (!$queryresult) {
reporError(100, "Discount could not be retrieved");
}
if ($db->numRows($queryresult)) {
$therecord = $db->fetchArray($queryresult);
} else {
$therecord["value"] = 0;
}
header('Content-Type: text/xml');
echo '<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>';
?>
<response>
<value><?php
echo $therecord["value"];
?>
</value>
</response>
| PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT |
| OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, |
| SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT |
| LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, |
| DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY |
| THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT |
| (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE |
| OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. |
| |
+-------------------------------------------------------------------------+
*/
require "../../include/session.php";
$querystatement = "\n SELECT\n `percentage`\n FROM\n `tax`\n WHERE\n `uuid`='" . mysql_real_escape_string($_GET["id"]) . "'\n ";
$queryresult = $db->query($querystatement);
if (!$queryresult) {
reporError(100, "Tax percentage could not be retrieved");
}
if ($db->numRows($queryresult)) {
$therecord = $db->fetchArray($queryresult);
} else {
$therecord["percentage"] = 0;
}
header('Content-Type: text/xml');
echo '<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>';
?>
<response>
<value><?php
echo $therecord["percentage"];
?>
</value>
</response>