<?php
session_start();
$page_title = "ثبت داراییهای نقدی";
if (isset($_SESSION['username']) && isset($_SESSION['password'])) {

include("checking_word.php");
include("pdate.php");
include("db.php");

	//select database name from file
$file_db = fopen("database_name.txt","r+");
$fname = fgets($file_db);
// sleect from database 
  

 

?>
<!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>
 
<title><?php echo $page_title;?></title>
<script>
   
function myconfirm()
{
    if(confirm('آیا اطلاعات را می خواهید به طور دائم پاک کنید؟'))
        return true;
    return false;
}
	 </script>
	 <script>
	     function get_amount(){
	    $('#rate').hide();
		$.post('retiverateRate.php', {
		   rateOfDollar:form.money.value  
		    
		   },
			function(output){
				$('#rate').html(output).fadeIn(10);
		})
	
	}
	</script>
	<script>
	 
		  function findingcalculation(){
	     insertval=setInterval("zarb()",1);
	    }
		  function zarb(){
	      amountp=document.getElementById('amount').value; // مقدار ارز مورد معاوضه
		  var decimalCharacter = ".",
          regex = new RegExp("[\\d-" + decimalCharacter + "]+", "g"),
          num_caldar=amountp;
          var amount=+num_caldar.match(regex).join("");
		 
		 // نرخ قدیم
		  dollarmixData=document.getElementById('dollarmixData').value; 
		  dollartakeData=dollarmixData.split('/');
		  dollarmainrate=dollartakeData[0];
		  dollarunit=dollartakeData[1];
		   var dollarexactresult=amount/dollarunit;
		   
		   totalDollar=(dollarmainrate*1)*(dollarexactresult*1);
           findTotalDollar=totalDollar.toFixed(2);   
		   document.getElementById('dollarRate').value=findTotalDollar;
		  /* var dollarexactresult=amount/dollarunit;
		  mainratep  =document.getElementById('mainrate').value;
	      var decimalCharacter = ".",
          regex = new RegExp("[\\d-" + decimalCharacter + "]+", "g"),
          num_caldar=mainratep;
          var mainrate=+num_caldar.match(regex).join("");  
		
		 total=(mainrate*1)*(amount*1); */
		  
		// document.getElementById('dollarRate').value=FormatNumberBy3(total.toFixed(2));
		  
		
		}   
	</script>
<!-- BEGIN GLOBAL MANDATORY STYLES -->
 <script type="text/javascript" src="js/decimal.js"></script>
 <script type="text/javascript" src="js/NumberFormat.js"></script>
<!--=========================================================-->
     <script src="js/jquery/jquery-1.4.1.min.js" type="text/javascript"></script>
	 <script src="js/validation.js"></script>
     <script src="dist/sweetalert-dev.js"></script>
     <link rel="stylesheet" href="dist/sweetalert.css">
     <link rel="stylesheet" href="css/screen.css" type="text/css"   />
<!--=========================================================-->
<!-- 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"/>
<link href="css/fontstyle.css" rel="stylesheet" type="text/css"/>
</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" style="border: 0px solid red;margin-top: -100px;background: #3598dc;">
	<!-- BEGIN SIDEBAR -->
	<?php
	$menu_selected="money";
	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" id="public_style">صفحه اصلی</a>
						<i class="fa fa-angle-left"></i>
					</li>
					<li>
						<a href="assetRegistration.php" id="public_style">ثبت داراییهای نقدی</a>
					</li>
					<li>
					 <?php if($old=="old"){ echo "<span style='color:red'>  شما وارید دوره قبلی شده اید و نمی توانید  اطلاعات ثبت کنید</span>";} ?>
					</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 id="main_title">ثبت داراییهای نقدی </span><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="registerassetMoney.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" id="sub_title">ثبت داراییهای نقدی</h3>
												
											</div>
										</div>
									</div>
									<div class="form-group">
										<label class="control-label col-md-2" id="public_style">واحد پـــولی<span class="required">
										</span>
										</label>
										<div class="col-md-4">
										<select name="money" id="money" style="width:300px" onchange="get_amount()" onclick="get_amount()" >
										<option></option>
										<?php
										include("config/views/db_const.php");
										$sql="select * from currencies";
										$query=$db ->query($sql);
										while($row=$query ->fetch_array()){
										$id=$row['id'];
										$name=$row['name'];
										echo "<option value='$id'>$name</option>";	
										}
										echo "</select>";
										?>
										<span class="help-block">
										</span>
										</div>
										</div>
												
												
												<div class="form-group">
													<label class="control-label col-md-2" id="public_style">مقدار<span class="required">
													</span>
													</label>
													<div class="col-md-4">
														<input type="text" name="amount" id="amount" autocomplete="off" onkeyup="addSeparator(this)" placeholder="" class="filed" onChange="findingcalculation()" onClick="findingcalculation()" />
														<span class="help-block">
														</span>
													</div>
												</div>
												<!--<div class="form-group">
													<label class="control-label col-md-2">نرخ<span class="required">
													</span>
													</label>
													<div class="col-md-4">
                                                        <div id='rate'><input type="hidden" id="determainRate" name="rate" class='filed' ></div>
														<span class="help-block">
														</span>
													</div>
												</div>-->
												<div class="form-group">
													<!--<label class="control-label col-md-2">مقدار به دلار<span class="required">
													</span>
													</label>-->
													<div class="col-md-4">
														<input type="hidden" name="dollarRate" id="dollarRate" placeholder="" class="filed" />
														<span class="help-block">
														</span>
													</div>
												</div>
									<div class="button_wrapper">
										<div class="row">
											<div class="col-md-offset-3 col-md-4">
												<input type="submit"   value="&nbsp;&nbsp;ذخیره&nbsp;&nbsp;" <?php if($old=="old"){echo "disabled";} ?> class="btn green button-submit" name="submit"/>
											</div>
										</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">
											<table class="table table-striped table-bordered table-hover" id="sample1">
											<thead>
											<tr>
												<th class="table-number" id="public_style">
													شماره
												</th>
												<th id="public_style">
													واحد پولی
												</th>
												<th id="public_style">
													مقدار
												</th>
												<th class="table-operation-header" id="public_style">
													ویرایش
												</th>
												 
											</tr>
											</thead>
											<tbody>
											 <?php
													 $retriveSql="select * from assetopeningbalance order by id desc";
													 $retriveQuery= $db ->query($retriveSql);
													 $i=0;
													 while($retriveRow=$retriveQuery ->fetch_array()){
												 	  $i++;
													  $amount=number_format($retriveRow['amount']);
													  $currencies_id=$retriveRow['currencyUnit'];
													  $editID=$retriveRow['id'];
													  
													  //======================================
													   $currencyNameSql="select id,name from currencies where id='$currencies_id'";
													   $currencyNameQuery =$db ->query($currencyNameSql);
													   $currencyNameRow=$currencyNameQuery ->fetch_array();
													   $currencyName=$currencyNameRow['name'];
													   
                                                       $table_name='assetopeningbalance';

													 echo "<tr><td class='table-operation'>$i</td>";
													 echo "<td class='table-operation' id='public_style'>$currencyName</td>"; 
													 echo "<td class='table-operation'>$amount</td>";  
													 echo" <td class='table-operation'><a  href='edit/edit_assetOpening.php?editID=".$editID."  & table=".$table_name."'  ><img alt='Submit' src='img/edit.png'   class='dontPrint' title='ویرایش'></a> </td>";
													 
													 }
												?>
												</tr>
											</tbody>
										</table>
									</div>
								</div>
							</div>
						</div>
                        </div>
					</div>
				</div>
			</div>
			<!-- END PAGE CONTENT-->
		</div>
	</div>
<!-- BEGIN FOOTER -->
<?php
	require_once('footer.php');

?>
<!-- END FOOTER -->
</div>
<?php
	if (isset($_GET['save'])) {
		echo "<script>alert('ولایت موفقانه در سیستم ذخیره شد.');</script>";
	}
?>
<!-- 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/select2/select2.min.js"></script>
<script type="text/javascript" src="../../assets/global/plugins/datatables/media/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="../../assets/global/plugins/datatables/extensions/TableTools/js/dataTables.tableTools.min.js"></script>
<script type="text/javascript" src="../../assets/global/plugins/datatables/extensions/ColReorder/js/dataTables.colReorder.min.js"></script>
<script type="text/javascript" src="../../assets/global/plugins/datatables/extensions/Scroller/js/dataTables.scroller.min.js"></script>
<script type="text/javascript" src="../../assets/global/plugins/datatables/plugins/bootstrap/dataTables.bootstrap.js"></script>
<!-- END PAGE LEVEL 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 -->
<script type="text/javascript" src="../../assets/global/plugins/select2/select2.min.js"></script>
<!-- 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() { 
    
    $('#totalUSD').hide(); $('#currency').hide();
    var b = $('#balance');
    b.blur(function(){
       if(b.val() != "0"){
            $('#totalUSD').show(); $('#currency').show();
       } 
    });
    
   // 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");
}  
?>