|
|
Too long in displaying the data in a Web Browser
01-24-2012
<?php
// db connection
$db = "mds_reports";
if($connect = mysql_connect("172.16.8.32", "mds_reports", "password"))
$connect = mysql_select_db($db);
else die("Unable to connect".mysql_error());
$date_from = $_POST['dfrom'];
$date_to = $_POST['dto'];
?>
<html>
<head>
</head>
<title>Address Frequency</title>
<body>
<h1>Address Frequency</h1>
<form name="fetching" method="POST" action="AddFrequency.php"></p>
Date From: <br><input type="text" name="dfrom" id="dfrom"></p>
Date To: <br><input type="text" name="dto" id="dto"><br /><br />
<input name="submit" type="submit" value="Go">
</form>
<table>
<table border="2"
cellpadding="2"
cellspacing="1"
style='width:100%;'>
<tr>
<th>Restaurant Name</th>
<th>Region</th>
<th>City</th>
<th>Area</th>
<th>Street</th>
<th>Building</th>
<th>Total Orders</th>
<th>Total Gross Sales</th>
</tr>
<?php
if(isset($_POST['submit']))
{
echo "Date select from $date_from to $date_to"."</p>";
$sql = "SELECT restaurant_master.name, RegionMaster.RegionName AS 'region',
CityMaster.CityName AS 'city',
DeliveryAddressHistory.Area,
DeliveryAddressHistory.Street,
DeliveryAddressHistory.Building,
COUNT(mds_orders.OrderDate) AS 'totalorders',
SUM(mds_orders.GrossTotal) AS 'totalgross'
FROM mds_orders
JOIN DeliveryAddressHistory
ON mds_orders.PKID = DeliveryAddressHistory.OrderFKID
JOIN CityMaster
ON DeliveryAddressHistory.CityFKID = CityMaster.PKID
JOIN RegionMaster
ON CityMaster.RegionFKID = RegionMaster.PKID
JOIN restaurant_master
ON mds_orders.RestaurantID = restaurant_master.PKID
WHERE
mds_orders.OrderDate BETWEEN '".$date_from." 00:00:00' AND '".$date_to." 23:59:59'
AND mds_orders.StatusFKID = 2
GROUP BY restaurant_master.name, RegionMaster.RegionName,
CityMaster.CityName, DeliveryAddressHistory.Area, DeliveryAddressHistory.Street,
DeliveryAddressHistory.Building, mds_orders.StatusFKID";
$result = mysql_query($sql)
or die("SELECT Error: ".mysql_error());
$num_rows = mysql_num_rows($result);
$i = 0;
if (mysql_num_rows($result) >0) {
while ($row = mysql_fetch_array($result,MYSQL_ASSOC)){
$csv .= $row['name'].",".
$row['region'].",".
$row['city'].",".
$row['Area'].",".
$row['Street'].",".
$row['Building'].",".
$row['totalorders'].",".
$row['totalgross'].","."<br>";
?>
<tr>
<td><?php echo $row['name'];?></td>
<td><?php echo $row['region'];?></td>
<td><?php echo $row['city'];?></td>
<td><?php echo $row['Area'];?></td>
<td><?php echo $row['Street'];?></td>
<td><?php echo $row['Building'];?></td>
<td><?php echo $row['totalorders'];?></td>
<td><?php echo $row['totalgross'];?></td>
</tr>
</tr>
</tr>
<?php
}}}
?>
</table<br />
<form name="export" method="POST" action="Address.php">
<input type="hidden" name="Address_dfrom" id="data" value="<?=$date_from?>">
` <input type="hidden" name="Address_dto" id="data" value="<?=$date_to?>">
<input type="submit" name="extract" value="Extract">
</form>
</body>
</html>
|
|