<?PHP 
include("header.php");
//session_start();
//error_reporting(0);

include "checksession.php";



include "include/db-connect.php";
if(isset($_REQUEST['submit']))
 {
	$start_date=$_REQUEST['from_date'];
			
	 $end_date=$_REQUEST['to_date']; 
	 //header("Location:view_sales_tax.php?sdate=$start_date&&edate=$end_date");

	  ?>
     <script>
	 window.location='view_sales_tax.php?sdate=<? echo $start_date ?>&&edate=<? echo $end_date ?>';
	 </script>
     <?
	 
	 //header("Location:sales_profit_bypid.php?product_id=$product_id");
 }

?>
<!----------------Start Date Picker Code-------->
<script type="text/javascript" src="JavaScript/calendar.js">
</script>
<script type="text/javascript" src="JavaScript/calendar-en.js">
</script>
<script type="text/javascript" src="JavaScript/calendar-setup.js">
</script>
<link rel="stylesheet" type="text/css" media="all" href="JavaScript/calendar-win2k-cold-1.css" title="win2k-cold-1" />
<!----------------End Date Picker Code-------->


  <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">
      <h1><img src="view/image/home.png" alt="" /> Sales Return </h1>
    </div>
    <div class="content">
      <div class="overview" style="width:93%; margin-left:70px;">
        <div class="dashboard-heading"> 
		   Sales Return 
        </div>
        <div class="dashboard-content">
        
<!--Message Display-->	
<?php
if($_REQUEST['add'] == 'success') {echo $result= '<h4 class="alert_success">Sales Return Added Successfully </h4>';}

elseif($_REQUEST['add'] == 'fail'){echo $result= '<h4 class="alert_error">Sales Return Already Exit</h4>';}

if($_REQUEST['edit'] == 'success') {echo $result= '<h4 class="alert_success">Sales Return Are Edited Successfully </h4>';}

elseif($_REQUEST['edit'] == 'fail'){echo $result= '<h4 class="alert_error">Sales Return Already Exit</h4>';}

if($_REQUEST['delete'] == 'success') {echo $result= '<h4 class="alert_success">Sales Return Are Deleted Successfully </h4>';}




?>	


																																					        
 <?php 
		    $start_date=$_REQUEST['sdate'];
			
            $end_date=$_REQUEST['edate'];
			
			
			 
			  $dis1=("select count(*) as num  from purchase_tax where purchase_date Between '$start_date' and '$end_date'");		
		     $total_pages = mysql_fetch_array(mysql_query($dis1));
		

             $total_pages = $total_pages[num];
	        {
?>

<?php } ?>
 

  <table class="list" cellspacing="0" > 
			<thead> 
                 <tr>
                    <td class="left">Product ID</td>
                    <td class="left">Quantity</td> 
                    <td class="left">Amount</td> 
                    <td class="left">Payment Option</td>                     
                    <td class="left">Customer Name</td>               
                    <td class="left">Return Date</td>
    				<td class="left">Delete</td>
                 </tr>
              </thead>
			<tbody> 
<?php 
			$dis1=("select count(*) as num  from ".$SAL_RET."");		
		$total_pages = mysql_fetch_array(mysql_query($dis1));

    $total_pages = $total_pages[num];

$targetpage =""; //your file name (the name of this file)
$limit = 10; //how many items to show per page
$page = $_GET['page'];
if($page)
$start = ($page - 1) * $limit; //first item to display on this page
else
$start = 0;

if ($page == 0) $page = 1; 
$prev = $page - 1; 
$next = $page + 1; 
$lastpage = ceil($total_pages/$limit);
$lpm1 = $lastpage - 1; //last page minus 1
$pagination = "";
if($lastpage > 1)
{
$pagination .= "<div class=\"pagination\">";
//previous button
if ($page > 1)
$pagination.= "<a href=\"$targetpage?page=$prev \"> Previous &nbsp;</a>";
else
$pagination.= "<span class=\"disabled\"> Previous &nbsp;</span>";

//pages
if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter &nbsp;</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter \">$counter &nbsp;</a>";
}
}
elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some
{
//close to beginning; only hide later pages
if($page < 1 + ($adjacents * 2))
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter &nbsp;</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter \">$counter &nbsp;s</a>";
}
$pagination.= "...";
$pagination.= "<a href=\"$targetpage?page=$lpm1 \">$lpm1 &nbsp;</a>";
$pagination.= "<a href=\"$targetpage?page=$lastpage \">$lastpage &nbsp;s</a>";
}
//in middle; hide some front and some back
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
$pagination.= "<a href=\"$targetpage?page=1 \">1 &nbsp;</a>";
$pagination.= "<a href=\"$targetpage?page=2 \">2 &nbsp;</a>";
$pagination.= "...";
for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter &nbsp;</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter \">$counter &nbsp;</a>";
}
$pagination.= "...";
$pagination.= "<a href=\"$targetpage?page=$lpm1 \">$lpm1 &nbsp;</a>";
$pagination.= "<a href=\"$targetpage?page=$lastpage \">$lastpage &nbsp;s</a>";
}
//close to end; only hide early pages
else
{
$pagination.= "<a href=\"$targetpage?page=1 \">1 &nbsp;</a>";
$pagination.= "<a href=\"$targetpage?page=2 \">2 &nbsp;</a>";
$pagination.= "...";
for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter &nbsp;</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter \">$counter &nbsp;</a>";
}
}
}

//next button
if ($page < $counter - 1)
$pagination.= "<a href=\"$targetpage?page=$next \">Next  &nbsp;</a>";
else
$pagination.= "<span class=\"disabled\">Next  &nbsp;</span>";
$pagination.= "</div>\n";
}

		$qur="select * from ".$SAL_RET." order by id desc limit $start, $limit"; 

		$result = mysql_query($qur)or die('Have an error in viewing data'.mysql_error());
		while ($row_section = mysql_fetch_array($result)) 
			{
                   $product_id= $row_section['product_id'];
				   $id=base64_encode($product_id);
				   
				 	$quantity= $row_section['quantity'];
					$qnty=base64_encode($quantity);
					
					$supplier_name= $row_section['customer_name'];
				  	$return_date= $row_section['return_date'];
					$amount= $row_section['amount'];
					$payment_option= $row_section['payment_option'];
			  ?>	    
			    <tr> 
                <td class="left"><?php echo $product_id; ?> </td>
                <td class="left"><?php echo $quantity; ?> </td>
                <td class="left"><?php echo $amount; ?> </td>
                <td class="left"><?php echo $payment_option; ?> </td>
                <td class="left"><?php echo $supplier_name; ?> </td>
                <td class="left"><?php echo $return_date; ?> </td>
                <td class="left"><a href="../sales_management/delete_sales_return.php?id=<?php echo $id; ?>&&qnty=<?php echo $qnty; ?>&&pay=<?php echo $payment_option; ?>&&amt=<?php echo $amount; ?>&&dt=<?php echo $return_date; ?>"><img src="../images/delete.jpg" height="30" width="30" title="Delete" onClick="return confirm('Are you sure you want to delete?')"></a></td>     
				</tr> 	 
				 
<?php } ?> 
 
			</tbody> 
            
			</table>
            
   
        </div>
        <div align="right"><?php echo $pagination; ?> 	</div>	
      </div>
      
      
      
         
                  
                
                
                </div></div>
                
                
                
                 
 				</form>
                 <script type="text/javascript">
						function formCallback(result, form) 
						{
							window.status = "valiation callback for form '" + form.id + "': result = " + result;
						}
						
						var valid = new Validation('profit_id', {immediate : true, onFormValidate : formCallback});
						Validation.addAllThese([
							['validate-password-confirm', 'Your confirmation password does not match your first password, please try again.', {
								equalToField : 'confirm_password'

							}]
						]);
					</script>


      </div></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,
					lineWidth: 1
				},
				grid: {
					backgroundColor: '#FFFFFF'
				},	
				xaxis: {
            		ticks: json.xaxis
				}
			}

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

getSalesChart($('#range').val());
//--></script> 
</div>
<div id="footer">Copyright &copy; 2014 | Powered by <a href="http://linikantech.com/" target="_blank">Linikantech</a><!--<a href="http://www.opencart.com">OpenCart</a> &copy; 2009-2016 All Rights Reserved.<br />Version 1.5.6.4--></div>
</body></html>