All pastes #512208 Raw Edit

Untitled

public text v1 · immutable
#512208 ·published 2007-05-26 19:56 UTC
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'>&nbsp;</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='" . $from . "'&to='" . $to . "'";?>">

<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">
    </td>
  </tr>
</table>
</form>
<!-- function to run queries -->
<?php

function writedata($var1, $var2, $var3, $var4, $var5, $value){
	global $Shopping;
$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>