<?PHP 
include("header.php");
//session_start();
//error_reporting(0);
include("include/db-connect.php");
//....Tamil font......
//mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'");
//.................

if(isset($_REQUEST['submit']))
{
	$search=$_REQUEST['search'];
	
	header("Location:viewsearch.php?search=$search");
}
 ?>
 
 <!----------SEARCH 1------------------->
 <!--
  <script type="text/javascript" src="search/jquery-1.9.1.min.js"></script>
  <script type="text/javascript" src="search/jquery.autocomplete.min.js"></script>
  <script type="text/javascript">
  var $j = jQuery.noConflict();
  $j(function(){
  var currencies = [
  <?php  $qur="SELECT * FROM products"; 
		$result = mysql_query($qur);
		while ($row_section = mysql_fetch_array($result)) 

	{

	?>	  
    { value: '<?php echo $row_section['name']; ?>' },
	<?php } ?>
  ];
  
  
  $j('#autocomplete1').autocomplete({
    lookup: currencies,
    onSelect: function (suggestion) {
      var tdehtml = '<strong>Service Name:</strong> ' + suggestion.data;
      $j('#outputcontent').html(tdehtml);
    }
  });
  

});
</script>-->
<!------------END SEARCH 1----------------------->

  <div id="content">
  <div class="breadcrumb">
       <!-- <a href="http://amarasudhan.com/admin/index.php?route=common/home&amp;token=b735cc089ec2d51abb9a8e1901f501fb">Home</a>-->
      </div>
              <div class="box">
    <div class="heading">
     <?php 
		    
			 
			 $dis1=("select count(*) as num  from ".$PRODUCT." ");		
		     $total_pages = mysql_fetch_array(mysql_query($dis1));
		

             $total_pages = $total_pages[num];
	       
		 ?>
      <h1><img src="view/image/home.png" alt="" />Product Details  &nbsp;&nbsp;&nbsp;Total Products - <?php echo  $total_pages; ?>  </h1>
    </div>
    <div class="content">
      <div class="overview" style="width:90%; margin-left:80px;">
        <div class="dashboard-heading" style="  margin-top:20px; ">
        <h3 class="tabs_involved" style="margin-left:25px; widtd:400px; color:#033;">
        
<div style=" widtd:700px;">

<form action="" metdod="post">

<input list="browsers" name="search" style="width:300px;height:20px;padding:4px;
  border-radius:4px;border:1px groove;border-color:#333;font-size:20px;">
  <datalist id="browsers">
  <? $selecf_pr_details=mysql_query("select * from `products` ");
  while($fetch_pr_details=mysql_fetch_array($selecf_pr_details)){ ?>
    <option value="<? echo $fetch_pr_details['name']; ?>">
   <? } ?>
  </datalist>
<input type="submit" value="SUBMIT" name="submit">
</form>
        </h3></div>
        <div class="dashboard-content">
<!--Message Display-->	
<?php
if($_REQUEST['add'] == 'success') {echo $result= '<h4 class="alert_success">Product Added Successfully </h4>';}
if($_REQUEST['edit'] == 'success') {echo $result= '<h4 class="alert_success">Product Edited Successfully </h4>';}
?>	
 
		 
  <table class="list" cellspacing="0" > 
			<thead> 
                <tr>
                    <td class="left">S.No</td>
                    <td class="left">Category</td>
                    <!--<td class="left">Sub Category</td>
                    <td class="left">Sub Sub Category</td>-->
                    <td class="left">Product ID</td> 
                    <td class="left">Product Name</td>
                    <!--<td class="left">Back Name</td>-->
                    <td class="left">Tax (%)</td>
                    <td class="left">Quantity</td>
                    <td class="left">Purchase Price</td>
                    <td class="left">Sales Price</td> 
                   <!-- <td class="left">Tax</td> 
                    <td class="left">Total</td>--> 
                    <td class="left">Picture</td>
                    <td class="left">Actions</td>
              </tr>
              </thead>
			<tbody> 
			<?php 
			$search=$_REQUEST['search'];
	  $qur="SELECT * FROM ".$PRODUCT." where name='$search' order by serial desc"; 
		$result = mysql_query($qur)or die('Have an error in viewing data'.mysql_error());
		while ($row_section = mysql_fetch_array($result)) 
			{
	  $serial=$row_section['serial'];
	   $category=$row_section['category'];
	   $sub_category=$row_section['sub_category'];
	   $sub_sub_cat=$row_section['sub_sub_cat'];
	   $name=$row_section['name'];
	   $description=$row_section['description'];
	   $price=$row_section['price'];
	   $quantity=$row_section['quantity'];
	    $product_id=$row_section['product_id'];
	   $offper=$row_section['offper'];
	   $small_jpg=$row_section['small_jpg'];
	   $in_price=$row_section['in_price'];
	   $sale_tax=$row_section['sale_tax'];
	   $tax_percen=$row_section['tax_percen'];
	   $pur_price=$row_section['pur_price'];
	   $tname=$row_section['tname'];
			  ?>	    
				 
			   <tr> 
    				<td><?php echo $i=$i+1; ?></td>
                    <td><?php echo $category; ?></td>
                    <!--<td><?php echo $sub_category; ?></td>
                    <td><?php echo $sub_sub_cat; ?></td>-->
                     <td><?php echo $product_id; ?></td>
                    <td><?php echo $name; ?></td>
                    <td><?php echo $tax_percen; ?></td>
                    <td><?php echo $quantity; ?></td>                   
                    <td><?php //echo $corrrency;?> <?php echo $pur_price; ?></td>
                    <td><?php //echo $corrrency;?> <?php echo $in_price; ?></td>
                   <!-- <td><?php //echo $corrrency;?> <?php echo $sale_tax; ?></td>
                    <td><?php //echo $corrrency;?> <?php echo $price; ?></td>-->
                    <td><img src="<?php echo $small_jpg; ?>" border="0" height="30" widtd="60"/></td>
                                       
   				  <td><a href="editproduct2.php?id=<?php echo $row_section['serial'];?>">
                    <input type="image" src="images/edit.jpg" title="Edit" widtd="20" height="15"></a>
                    
                     <a href="deleteproduct.php?id=<?php echo $row_section['serial'];?>&&imgname=<? echo $small_jpg; ?>" 
                     onClick="return confirm('Are you sure you want to delete?')">
                     <input type="image" src="images/delete.jpg" title="Delete" widtd="20" height="15"></a></td> 
				</tr>  	 
				 
<?php } ?> 
 
			</tbody> 
			</table>
            
   
        </div>
        <div align="right"><?php echo $pagination; ?> 	</div>	
      </div>
      
      
    </div>
  </div>
</div>
<!--[if IE]>
<script type="text/javascript" src="view/javascript/jquery/flot/excanvas.js"></script>
<![endif]--> 
<script type="text/javascript" src="view/javascript/jquery/flot/jquery.flot.js"></script> 
<script type="text/javascript"><!--
function getSalesChart(range) {
	$.ajax({
		type: 'get',
		url: 'index.php?route=common/home/chart&token=b735cc089ec2d51abb9a8e1901f501fb&range=' + range,
		dataType: 'json',
		async: false,
		success: function(json) {
			var option = {	
				shadowSize: 0,
				lines: { 
					show: true,
					fill: true,
					lineWidtd: 1
				},
				grid: {
					backgroundColor: '#FFFFFF'
				},	
				xaxis: {
            		ticks: json.xaxis
				}
			}

			$.plot($('#report'), [json.order, json.customer], option);
		}
	});
}

getSalesChart($('#range').val());
//--></script> 
</div>
<?php include("footer.php"); ?>