Rev_report.php | searchcode

/Rev_report.php

https://bitbucket.org/bsaisandeep/social-networking-site
PHP | 217 lines | 155 code | 62 blank | 0 comment | 28 complexity | 6e7b47022dd95b1fb0ab992507aafa2d MD5 | raw file

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8">


<title> SBU network </title>

<link rel="stylesheet" href="./Wordpress Theme   TW_files/style.css" type="text/css" media="screen">


<link rel="stylesheet" id="wp-polls-css" href="./Wordpress Theme   TW_files/polls-css.css" type="text/css" media="all">
<link rel="stylesheet" id="wp-pagenavi-css" href="./Wordpress Theme   TW_files/pagenavi-css.css" type="text/css" media="all">



</head>
<body class="home blog">



<!-- wrapper_top -->
<div class="wrapper_top">
	<!-- wrapper -->
	<div class="wrapper">
		<div id="header">
			<!-- mainmenu -->
			<div id="mainmenu">
				<ul>
					<li class="page_item page-item-4"><a href="Welcome.php"><span>Home</span></a></li>
					<li class="page_item page-item-4"><a href="MyProfile.php" title="About"><span>Profile</span></a></li>
<li class="page_item page-item-4"><a href="Friends.php"><span>Friends</span></a></li>
<li class="page_item page-item-6"><a href="upload.php" title="Links"><span>Photos</span></a></li>
<li class="page_item page-item-4"><a href="LoginPage.php" title="Logout"><span>Logout</span></a>

			</div>
			<!-- /mainmenu -->
			<!-- sidebar_search -->
			<div id="sidebar_search">
				<form action="SearchFriends.php" method="get">
					<fieldset>
						<label for="main_search_val">Search</label>
						<input type="text" value="" name="s" id="main_search_val">
						<input type="image" src="./Wordpress Theme   TW_files/button_search.gif" alt="search" id="main_search_sub">
					</fieldset>
				</form>
			</div>
			<!-- /sidebar_search -->
		</div>

<img src="./Penguins.jpg" alt="Big Boat" width="760" height="228"/>

<br><br>
		<!-- /header -->
		<!-- board -->
		
				<!-- navigation -->
				
<div id="board1"> <p> About Me </p></div>
				<br><br>
	
<div id="board">
			
			<p>


<?php
 $con = mysql_connect("localhost","root","sandeep");
 if (!$con)
   {
   die('Could not connect: ' . mysql_error());
   }
 
mysql_select_db("my_db", $con);
$id=$_COOKIE["user"];
$srch=$_GET['searchby'];
if ($_GET['searchtype'] == 1)
{
echo "user " . $srch ."<br>";
$result = mysql_query("Select SUM(revenue) as Sum from Transactions where LoginID = '$srch' ");
$row = mysql_fetch_array($result);
echo "<br><br>Generated Revenue of:". $row['Sum'];

}

else if ($_GET['searchtype'] == 2)
{
$sum=0;
echo "Item " . $srch ."<br>";
$result = mysql_query(" Select * from Ads where Item = '$srch'");
while($row = mysql_fetch_array($result))
{
$srch = $row['AdID'];
$result1 = mysql_query(" Select SUM(revenue) as Sum from Transactions where AdID = '$srch' ");
$row1 = mysql_fetch_array($result1);
$sum=$sum+$row1['Sum'];
}

echo " Generated revenue of " . $sum;

}

else if ($_GET['searchtype'] == 3)
{

$sum=0;
echo "Company " . $srch ."<br>";
$result = mysql_query(" Select * from Ads where Company = '$srch'");
while($row = mysql_fetch_array($result))
{
$srch = $row['AdID'];
$result1 = mysql_query(" Select SUM(revenue) as Sum from Transactions where AdID = '$srch' ");
$row1 = mysql_fetch_array($result1);
$sum=$sum+$row1['Sum'];

}
echo " Generated revenue of " . $sum;
}


else if ($_GET['searchtype'] == 4)
{

echo "Transactions of " . $srch ."<br>";
$result = mysql_query(" Select * from Transactions where LoginID = '$srch'");
echo " AdID &nbsp&nbsp&nbsp&nbsp&nbsp  noOfUnits &nbsp&nbsp&nbsp&nbsp&nbsp Date <br>"; 
while($row = mysql_fetch_array($result))
{

echo $row['AdID'] ."  &nbsp &nbsp &nbsp&nbsp &nbsp &nbsp&nbsp &nbsp &nbsp" . $row['noOfUnits'] ."  &nbsp &nbsp &nbsp &nbsp &nbsp&nbsp" . $row['Date'] . "<br>";
}

}


else if ($_GET['searchtype'] == 5)
{

echo "Transactions of " . $srch ."<br>";
$result = mysql_query(" Select * from Transactions where AdID IN (Select AdID from Ads where Item like '$srch')");
echo " AdID &nbsp&nbsp&nbsp&nbsp&nbsp  noOfUnits &nbsp&nbsp&nbsp&nbsp&nbsp Date <br>"; 
while($row = mysql_fetch_array($result))
{

echo $row['AdID'] ."  &nbsp &nbsp &nbsp&nbsp &nbsp &nbsp&nbsp &nbsp &nbsp" . $row['noOfUnits'] ."  &nbsp &nbsp &nbsp &nbsp &nbsp&nbsp" . $row['Date'] . "<br>";
}

}


else if ($_GET['searchtype'] == 6)
{

echo "Customers who bought " . $srch ."<br><br>";
$result = mysql_query(" Select Distinct(LoginID) from Transactions where AdID IN (Select AdID from Ads where Item like '$srch')");
echo " LoginID <br>"; 
while($row = mysql_fetch_array($result))
{
echo $row['LoginID'];
}

}


else if ($_GET['searchtype'] == 7)
{

echo "Transactions of " . $srch ."<br>";
$result = mysql_query(" SELECT AdID,SUM(noOfUnits) As sum from Transactions T Where T.AdID in (Select AdID from Ads where Company='$srch') group by AdID order by sum ");
echo " AdID &nbsp&nbsp&nbsp&nbsp&nbsp  noOfUnits &nbsp&nbsp&nbsp&nbsp&nbsp <br>"; 
while($row = mysql_fetch_array($result))
{
echo $row['AdID'] ."  &nbsp &nbsp &nbsp&nbsp &nbsp &nbsp&nbsp &nbsp &nbsp" . $row['sum'] . "<br>";
}

}


else if ($_GET['searchtype'] == 8)
{

echo "Customers who bought " . $srch ."<br><br>";
$result = mysql_query(" Select TransID, AdID, T.LoginId,Address,City,State,Zipcode,Phone from Transactions T, Registration R where T.LoginID=R.LoginId and AdID IN (Select AdID from Ads where item like '$srch')");
echo " TransID &nbsp AdID &nbsp&nbsp &nbsp &nbsp &nbsp LoginID &nbsp&nbsp &nbsp &nbsp&nbsp &nbsp &nbsp Address &nbsp&nbsp &nbsp &nbsp&nbsp &nbsp &nbsp City &nbsp&nbsp &nbsp &nbsp&nbsp &nbsp &nbsp State &nbsp&nbsp &nbsp &nbsp&nbsp &nbsp &nbsp Zipcode &nbsp&nbsp &nbsp &nbsp&nbsp &nbsp &nbsp Phone<br>"; 
while($row = mysql_fetch_array($result))
{
echo $row['TransID'] . "&nbsp &nbsp &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp" .$row['AdID'] ."  &nbsp &nbsp &nbsp&nbsp &nbsp &nbsp" . $row['LoginId'] ."  &nbsp &nbsp &nbsp &nbsp &nbsp&nbsp" . $row['Address'] . "  &nbsp &nbsp &nbsp &nbsp &nbsp&nbsp" . $row['City'] ."  &nbsp &nbsp &nbsp &nbsp &nbsp&nbsp" . $row['State'] ."  &nbsp &nbsp &nbsp &nbsp &nbsp&nbsp" . $row['Zipcode'] ."  &nbsp &nbsp &nbsp &nbsp &nbsp&nbsp" . $row['Phone'] . "<br>";
}

}


else if ($_GET['searchtype'] == 9)
{

echo "Suggested Items for " . $srch ."<br><br>";
$result = mysql_query(" Select AdID, Item,Company FROM Ads where item IN (SELECT Distinct(item) FROM Ads A, Transactions T WHERE A.AdID=T.AdID and T.LoginID='$srch')");
 
while($row = mysql_fetch_array($result))
{
echo $row['AdID'] . "&nbsp &nbsp &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp" .$row['Item'] ."  &nbsp &nbsp &nbsp&nbsp &nbsp &nbsp" . $row['Company'] . "<br>";
}

}


else
{
echo "company and item";
}


?>
</p>
</div>



</body></html>