rendered paste body<?php
require_once('../../Connections/ghostlicense.php');
require_once('../../Connections/Shopping.php');
mysql_select_db($database_Shopping, $Shopping);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Orders</title>
<script charset='UTF-8' src='menu.js' type='text/javascript'></script>
<script type='text/javascript'>awmBuildMenu();</script>
<!-- ******** END CODE FOR menu ******** -->
<style type="text/css">
body {
background-color:#FFFFD5;
}
FORM {
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #000080;
border: 2px solid #4682B4;
padding: 5px;
background-color: #0099CC;
}
table {
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #000080;
border-color: #0066CC;
background-color: #0099CC;
}
td {
font-size:10px;
background-color:#FFFFCC;
}
</style></head>
<body>
<div align="left">
<p align="center">
<!-- DO NOT MOVE! The following AllWebMenus code must always be placed right AFTER the BODY tag-->
<!-- ******** BEGIN ALLWEBMENUS CODE FOR menu ******** -->
<script type='text/javascript'>var MenuLinkedBy='AllWebMenus [4]',awmMenuName='menu',awmBN='DW';awmAltUrl='';</script>
<script charset='UTF-8' src='menu.js' type='text/javascript'></script>
<script type='text/javascript'>awmBuildMenu();</script>
<!-- ******** END ALLWEBMENUS CODE FOR menu ******** -->
<span id='awmAnchor-menu'> </span><br />
<br />
</p>
<p><br />
<br />
</p>
</div>
<!-- form to set date -->
<form id="setdate" name="setdate" method="post"
action="<?php echo "totals.php?from='" . $startdate . "'&to='" . $enddate . "'";?>">
<table border=0>
<tr>
<td>
Start:
</td>
<td>
<select name="start_month" size="1" id="start_month">
<option>Month</option>
<option>01</option>
<option>02</option>
<option>03</option>
<option>04</option>
<option>05</option>
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option>
</select>
<select name="start_day" id="start_day">
<option>Day</option>
<option>01</option>
<option>02</option>
<option>03</option>
<option>04</option>
<option>05</option>
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select>
<select name="start_year" id="start_year">
<option>Year</option>
<option>2006</option>
<option>2007</option>
<option>2008</option>
<option>2009</option>
<option>2010</option>
</select>
</td>
<td width="10" background="#000080"></td>
<td>
End:
</td>
<td>
<select name="end_month" size="1" id="end_month">
<option selected><?php echo date(m); ?></option>
<option>01</option>
<option>02</option>
<option>03</option>
<option>04</option>
<option>05</option>
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option>
</select>
<select name="end_day" id="end_day">
<option selected><?php echo date(d); ?></option>
<option>01</option>
<option>02</option>
<option>03</option>
<option>04</option>
<option>05</option>
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select>
<select name="end_year" id="end_year">
<option selected><?php echo date(Y); ?></option>
<option>2006</option>
<option>2007</option>
<option>2008</option>
<option>2009</option>
<option>2010</option>
</select>
</td>
<td>
<input type="submit" value="Filter" name="setdate">
</td>
</tr>
</table>
<!-- used for start and end dates filter -->
<?php
$startdate = $start_month . '/' . $start_day . '/' . $start_year;
$enddate = $end_month . '/' . $end_day . '/' . $end_year;
$start_unix_stamp = strtotime($startdate);
$end_unix_stamp = strtotime($enddate);
?>
</form>
<!-- function to run queries -->
<?php
function writedata($var1, $var2, $var3, $var4, $var5, $value){
global $Shopping;
if(isset($_POST['setdate']))
{
$var1 = "
SELECT
CubeCart_order_inv.name,
CubeCart_order_sum.cart_order_id,
CubeCart_order_sum.time,
CubeCart_order_inv.cart_order_id,
SUM(CubeCart_order_sum.prod_total) as $var2
FROM
CubeCart_order_sum,
CubeCart_order_inv
WHERE
(CubeCart_order_inv.name LIKE $var3)
AND
(CubeCart_order_sum.cart_order_id = CubeCart_order_inv.cart_order_id)
AND
(CubeCart_order_sum.time BETWEEN $from AND $to
GROUP BY
CubeCart_order_inv.name";
}
else
{
$var1 = "
SELECT
CubeCart_order_inv.name,
CubeCart_order_sum.cart_order_id,
CubeCart_order_sum.time,
CubeCart_order_inv.cart_order_id,
SUM(CubeCart_order_sum.prod_total) as $var2
FROM
CubeCart_order_sum,
CubeCart_order_inv
WHERE
(CubeCart_order_inv.name LIKE $var3)
AND
(CubeCart_order_sum.cart_order_id = CubeCart_order_inv.cart_order_id)
GROUP BY
CubeCart_order_inv.name";
}
$var4 = mysql_query($var1, $Shopping) or die(mysql_error());
while ($var5 = mysql_fetch_array($var4)){
?>
<tr>
<td>
<?php echo $var5['name'] ; ?>
</td>
<td>
$<?php echo $var5[$var2] ; ?>
</td>
<td>
<?php echo round($var5[$var2] / $value) ; ?>
</td>
</tr>
<?php
}
}
?>
<table>
<table border="1" width="80%">
<tr>
<td>
Name
</td>
<td>
Total
</td>
<td>
Sold
</td>
</tr>
<!-- Function Ghost Hunts -->
<?php
writedata("query_tickets_sold","tickets_total","'Ghost Hunt -%'","tickets_sold","row_tickets_sold","51.75");
?>
<!-- Function Night Tours -->
<?php
writedata("query_nighttours","nighttours_total","'%night%'","nighttours","row_nighttours","515");
?>
<!-- Ghost Hunting Classes -->
<?php
writedata("query_hunting_tickets_sold","hunting_tickets_total","'Ghost Hunting%'","hunting_tickets_sold","row_hunting_tickets_sold","51.75");
?>
<!-- Function Flashlight Tours -->
<?php
writedata("query_flashlights","flashlights_total","'%flashlight%'","flashlights","row_flashlights","20.60");
?>
<!-- Function T-Shirts -->
<?php
writedata("query_tshirts","tshirts_total","'%t-shirt%'","tshirts","row_tshirts","18.54");
?>
<!-- Virtual Tours -->
<?php
writedata("query_virtual_tour","virtual_total","'%virtual%'","virtual_tour","row_virtual_tour","18.5297");
?>
<!-- Hats -->
<?php
writedata("query_hats","hats_total","'%cap%'","hats","row_hats","13.39");
?>
</table>