Miscellany

<?php
// top 10 information (shot via ajax)         
$radioWaste  = $_GET["radioWaste"];
$radioMeters = $_GET["radioMeters"];
$radioEff    = $_GET["radioEff"];
$toggle      = $_GET["toggle"];
$timeFrame   = $_GET["timeFrame"];
$submit      = $_GET["submit"];

// date control
$date = mktime();

$year   = strftime("%Y", $date);
$month  = strftime("%m", $date);
$day    = strftime("%d", $date);
          
$startDate  = mktime(22, 0, 0, $month, $day, $year);

if ($timeFrame == "last30Days")
  $startDate = strtotime(strftime("%c",$startDate)." - 30 days");
elseif ($timeFrame == "last3Months")
  $startDate = strtotime(strftime("%c",$startDate)." - 3 months");
elseif ($timeFrame == "last12Months")
  $startDate = strtotime(strftime("%c",$startDate)." - 12 months");

$endDate    = mktime(24, 0, 0, $month, $day, $year);
         
$where = "`timeSubmitted` BETWEEN $startDate AND $endDate";
          
// column, order by and group by control
$column = "";
$order  = "";
$group  = "";
          
if ($submit == "line")
  $column = "mil";
elseif ($submit == "product")
  $column = "product";
elseif ($submit == "group")
  $column = "productGroup";
elseif ($submit == "shift")
  $column = "shift";

$group = $column;
  
if ($radioWaste == "true") {
  $column .= ",SUM(wasteProd)";
  $order   = "SUM(wasteProd)";
} elseif ($radioMeters == "true") {
  $column .= ",SUM(meters)";
  $order   = "SUM(wasteProd)";
} elseif ($radioEff == "true") {
  $column .= "SUM(eff)/count(eff) as eff";
  $order   = "eff";
  $where  .= " AND eff <> 0";
}

// sort control
$sort = "";
if ($toggle == "most")  $sort = "DESC";
if ($toggle == "least") $sort = "ASC";                 

$sql = "SELECT $column FROM `allproducts` WHERE $where GROUP BY $group ORDER BY $order $sort LIMIT 0,10";

echo "<br>$sql<br>";
?>