<?php
session_start();
include("pdate.php");
require_once('../../config/db_const.php');
require_once ('../../config/class.Database.php');

$page_title = "ارزیابی خرید و فروش روزانه";
$db = new Database(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME);
$db->connect();

if (isset($_SESSION['username']) && isset($_SESSION['password'])) {

  
?>

<!DOCTYPE html>
<!--[if IE 8]> <html lang="en" class="ie8 no-js"> <![endif]-->
<!--[if IE 9]> <html lang="en" class="ie9 no-js"> <![endif]-->
<!--[if !IE]><!-->
<html lang="en" class="no-js">
<!--<![endif]-->
<!-- BEGIN HEAD -->
<head>
  
<meta charset="utf-8"/>
<title><?php echo $page_title;?></title>
 <?php include('messages.php'); ?>
<!-- BEGIN GLOBAL MANDATORY STYLES -->
<link href="../../assets/global/plugins/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>
<link href="../../assets/global/plugins/simple-line-icons/simple-line-icons.min.css" rel="stylesheet" type="text/css"/>
<link href="../../assets/global/plugins/bootstrap/css/bootstrap-rtl.min.css" rel="stylesheet" type="text/css"/>
<link href="../../assets/global/plugins/uniform/css/uniform.default.css" rel="stylesheet" type="text/css"/>
<link href="../../assets/global/plugins/bootstrap-switch/css/bootstrap-switch-rtl.min.css" rel="stylesheet" type="text/css"/>
<!-- END GLOBAL MANDATORY STYLES -->
<!-- BEGIN PAGE LEVEL PLUGIN STYLES -->
<link href="../../assets/global/plugins/bootstrap-daterangepicker/daterangepicker-bs3.css" rel="stylesheet" type="text/css"/>
<!-- END PAGE LEVEL PLUGIN STYLES -->
<!-- BEGIN PAGE LEVEL PLUGIN STYLES -->
<link rel="stylesheet" type="text/css" href="../../assets/global/plugins/select2/select2.css"/>
<link rel="stylesheet" type="text/css" href="../../assets/global/plugins/datatables/extensions/Scroller/css/dataTables.scroller.min.css"/>
<link rel="stylesheet" type="text/css" href="../../assets/global/plugins/datatables/extensions/ColReorder/css/dataTables.colReorder.min.css"/>
<link rel="stylesheet" type="text/css" href="../../assets/global/plugins/datatables/plugins/bootstrap/dataTables.bootstrap-rtl.css"/>
<link href="../../assets/global/plugins/bootstrap-daterangepicker/daterangepicker-bs3.css" rel="stylesheet" type="text/css"/>
<!-- END PAGE LEVEL PLUGIN STYLES -->
<!-- BEGIN PAGE LEVEL STYLES -->
<link rel="stylesheet" type="text/css" href="../../assets/global/plugins/select2/select2.css"/>
<!-- END PAGE LEVEL SCRIPTS -->
<!-- BEGIN THEME STYLES -->
<link href="../../assets/global/css/components-md-rtl.css" id="style_components" rel="stylesheet" type="text/css"/>
<link href="../../assets/global/css/plugins-md-rtl.css" rel="stylesheet" type="text/css"/>
<link href="../../assets/admin/layout/css/layout-rtl.css" rel="stylesheet" type="text/css"/>
<link id="style_color" href="../../assets/admin/layout/css/themes/darkblue-rtl.css" rel="stylesheet" type="text/css"/>
<link href="../../assets/admin/layout/css/custom-rtl.css" rel="stylesheet" type="text/css"/>
<!-- END THEME STYLES -->
<link rel="shortcut icon" href="favicon.ico"/>
</head>
<!-- END HEAD -->
<!-- BEGIN BODY -->
<body class="page-md page-header-fixed page-quick-sidebar-over-content">

<?php require_once('header.php');?>

<div class="clearfix">
</div>
<!-- BEGIN CONTAINER -->
<div class="page-container">
	<!-- BEGIN SIDEBAR -->
	<?php
	$menu_selected="treat";
	require_once('sidebar.php');?>
	<!-- END SIDEBAR -->
	<!-- BEGIN CONTENT -->
	<div class="page-content-wrapper">
		<div class="page-content">
			<!-- BEGIN PAGE CONTENT-->
			<!--BEGIN PAGE HEADER-->
			<div class="page-bar">
				<ul class="page-breadcrumb">
					<li>
						<i class="fa fa-home"></i>
						<a href="index.php">صفحه اصلی</a>
						<i class="fa fa-angle-left"></i>
					</li>
					<li>
						<a href="dillyestimate.php">ارزیابی خرید و فروش روزانه</a>
					</li>
				</ul>
			</div>
			<!-- END PAGE HEADER-->
			<div class="row">
				<div class="col-md-12">
					<div class="portlet box blue" id="form_wizard_1">
						<div class="portlet-title">
							<div class="caption">
								<i class="fa fa-user"></i>ارزیابی خرید و فروش روزانه<span class="step-title"></span>
							</div>
							<div class="tools hidden-xs">
								<a href="javascript:;" class="collapse">
								</a>
							</div>
						</div>
						<div class="portlet-body form">
							<form action="stemite_result.php" class="form-horizontal"  name="form" id="submit_form" method="POST">
								<div class="form-wizard">
									<div class="form-body">
										<div class="tab-content">
											 
											<div class="tab-pane active" id="tab1">
												<h3 class="block">ارزیابی خرید و فروش روزانه</h3>
												 
												<div class="form-group">
													 
												</div>
												 
											</div>
										</div>
									</div>
									<div class="button_wrapper">
										<div class="row">
											 
											 
											 
											 <?php

 include("db.php");
  $date=$_POST['date'];
  
  $counterCurrency=$_POST['counterCurrency'];
  if(strlen(trim($counterCurrency))==0  or strlen(trim($date))==0){
		echo' <script>
					 sweetAlert("اخطا ر... ", "لطفا جاهای خالی را پرکنید !", "error");
				  </script>';

         echo '<meta http-equiv="refresh" content ="1; url=dillyestimate.php" >';
		die;


}
  
 echo "<form method='post' action='sellRate.php'>
      
	   <table border='1' cellpadding='0' cellspacing='0' style='margin: 0px auto'>
       <tr>
	    <th style='background: silver;color: #000;text-align: center;padding: 4px'>تاریخ</th>
		<th style='background: silver;color: #000;text-align: center'>&nbsp;ارز مورد معاوضه&nbsp;</th>
		<th style='background: silver;color: #000;text-align: center'>&nbsp;مقدار ارز مورد معاوضه&nbsp;</th>
		<th style='background: silver;color: #000;text-align: center'>&nbsp;نرخ &nbsp;</th>
		<th style='background: silver;color: #000;text-align: center'>&nbsp;مقدار به ارز پایه&nbsp;</th>
		<th style='background: silver;color: #000;text-align: center'>&nbsp;نرخ روز&nbsp;</th>
		 
	   </tr>";
	   
 $sellrate=$_POST['sellRate'];
  
 $findSql="select * from transaction where treatment!='2' and counterCurrency='$counterCurrency' and date='$date'";
 $findQuery= $db ->query($findSql);
 $count="1";
 while($row= $findQuery->fetch_array()){
 echo "<tr>";
  $date=$row['date'];
  $id=$row['id'];
  $counterAmount=$row['counterAmount'];
  $counterCurrencyId=$row['counterCurrency'];
  $rate=$row['rate'];
  $baseAmount=$row['baseAmount'];
  $baseCurrencyId=$row['baseCurrency'];
  $newAmount=($counterAmount*$sellrate)/1000;
  $differnt=$newAmount-$baseAmount;
  
   $currenycNameSql="select name,id from currencies where id ='$counterCurrencyId'";
  $currenycNameQuery= $db ->query($currenycNameSql);
  $currenycNameRow=$currenycNameQuery ->fetch_array();
  $currenycName=$currenycNameRow['name'];   
  
  
  $baseCurrencyNameSql="select name from currencies where id ='$baseCurrencyId'";
  $baseCurrencyQuery= $db ->query($baseCurrencyNameSql);
  $baseCurrencyRow=$baseCurrencyQuery ->fetch_array();
  $baseCurrencyName=$baseCurrencyRow['name']; 
  
  echo "<td>$date</td> 
        <td>$currenycName</td> 
        <td>$counterAmount</td>  
        <td>$rate</td>  
        <td>$baseAmount$baseCurrencyName</td>  
        <td><input type='text' name='select[]'  ></td>  
        <input type='hidden' name='idNumber[]' value='$id'>
 		
        "; 
       
  
  
  $baseCurrency=$row['baseCurrency'];
  
 
  
   
 
  
   
  
  $count++;
 
 }
 echo "</tr><tr><td colspan='6' style='text-align: center'><input type='submit' name='submit' value='ارزیابی خریداری'></td></tr><table></form>";




?>
											 
											 
											 
											 
											 
											 
											 
											 
											 
											 
											 
											 
											 
											 
											 
											 
											 
											 
											 
											 
											 
											 
										</div>
									</div>	
								</div>
							</form>
							<!-- BEGIN PAGE CONTENT-->
							<div class="row">
								<div class="col-md-12">
									<!-- BEGIN EXAMPLE TABLE PORTLET-->
									<div class="table-wrapper">
										<hr class="horizontal-line" />
										<div class="portlet-body">
											 
									</div>
								</div>
							</div>
						</div>
					</div>
				</div>
			</div>
			<!-- END PAGE CONTENT-->
		</div>
	</div>
<!-- BEGIN FOOTER -->
<?php require_once('footer.php');?>
<!-- END FOOTER -->
</div>
<!-- BEGIN JAVASCRIPTS(Load javascripts at bottom, this will reduce page load time) -->
<!-- BEGIN CORE PLUGINS -->
<!--[if lt IE 9]>
<script src="../../assets/global/plugins/respond.min.js"></script>
<script src="../../assets/global/plugins/excanvas.min.js"></script> 
<![endif]-->
<script src="../../assets/global/plugins/jquery.min.js" type="text/javascript"></script>
<script src="../../assets/global/plugins/jquery-migrate.min.js" type="text/javascript"></script>
<!-- IMPORTANT! Load jquery-ui.min.js before bootstrap.min.js to fix bootstrap tooltip conflict with jquery ui tooltip -->
<script src="../../assets/global/plugins/jquery-ui/jquery-ui.min.js" type="text/javascript"></script>
<script src="../../assets/global/plugins/bootstrap/js/bootstrap.min.js" type="text/javascript"></script>
<script src="../../assets/global/plugins/bootstrap-hover-dropdown/bootstrap-hover-dropdown.min.js" type="text/javascript"></script>
<script src="../../assets/global/plugins/jquery-slimscroll/jquery.slimscroll.min.js" type="text/javascript"></script>
<script src="../../assets/global/plugins/jquery.blockui.min.js" type="text/javascript"></script>
<script src="../../assets/global/plugins/jquery.cokie.min.js" type="text/javascript"></script>
<script src="../../assets/global/plugins/uniform/jquery.uniform.min.js" type="text/javascript"></script>
<script src="../../assets/global/plugins/bootstrap-switch/js/bootstrap-switch.min.js" type="text/javascript"></script>
<!-- END CORE PLUGINS -->
 
<!-- BEGIN PAGE LEVEL PLUGINS -->
<script type="text/javascript" src="../../assets/global/plugins/jquery-validation/js/jquery.validate.min.js"></script>
<script type="text/javascript" src="../../assets/global/plugins/jquery-validation/js/additional-methods.min.js"></script>
<script type="text/javascript" src="../../assets/global/plugins/bootstrap-wizard/jquery.bootstrap.wizard.min.js"></script>
<!-- END PAGE LEVEL PLUGINS -->
<!-- BEGIN PAGE LEVEL PLUGINS -->
<!-- END PAGE LEVEL PLUGINS -->

<!-- BEGIN PAGE LEVEL SCRIPTS -->
<script src="../../assets/global/scripts/metronic.js" type="text/javascript"></script>
<script src="../../assets/admin/layout/scripts/layout.js" type="text/javascript"></script>
<script src="../../assets/admin/layout/scripts/demo.js" type="text/javascript"></script>
<script src="../../assets/admin/pages/scripts/table-advanced.js"></script>
<script src="../../assets/admin/pages/scripts/form-wizard.js"></script>
<!-- END PAGE LEVEL SCRIPTS -->
<script>
jQuery(document).ready(function() { 
   // initiate layout and plugins
   Metronic.init(); // init metronic core components
   Layout.init(); // init current layout
   Demo.init(); // init demo features
   TableAdvanced.init();
   FormWizard.init(); 
});
</script>

<!-- END JAVASCRIPTS -->
</body>
<!-- END BODY -->
</html>
<?php
}else{
	header("Location: login.php");
}
?>