<?php
session_start();
include("today_date.php");
include("pdate.php");
include("db.php");
 
$pdate1=$today_date;
$page_title = "ثبت بلانس ابتدایی مشتری";

$customerID=$_GET['customerID'];
 
 
 if($customerID!=0){
	   $customar_id=$customerID ;
	   $customar_id=$_SESSION['customar_code']=$customar_id;
 }
if($customerID==0){
	 $customar_id= $_SESSION['customar_code'];
	
 }
 

if (isset($_SESSION['username']) && isset($_SESSION['password'])) {
	
	//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>
  <script>
   
function myconfirm()
{
    if(confirm('آیا اطلاعات را می خواهید به طور دائم پاک کنید؟'))
        return true;
    return false;
}
      
	   
 function dollarPrice(){
	    $('#dollarGhaymat').hide();
		$.post('retiveDollarrate.php', {
		   rateOfDollar:form.basecurrency.value
		   },
			function(output){
				$('#dollarGhaymat').html(output).fadeIn(10);
		})
	
	} 
	   
	 </script> 
	 <script>
		  function findingcalculation(){
	     insertval=setInterval("zarb()",1);
	    }
		  function zarb(){
	      openingBalanceP=document.getElementById('openingBalance').value; // مقدار ارز مورد معاوضه
		  var decimalCharacter = ".",
          regex = new RegExp("[\\d" + decimalCharacter + "]+", "g"),
          num_caldar=openingBalanceP;
          var openingBalance=+num_caldar.match(regex).join("");  

          // نرخ قدیم
		  dollarmixData=document.getElementById('dollarmixData').value; 
		  dollartakeData=dollarmixData.split('/');
		  dollarmainrate=dollartakeData[0];
		  dollarunit=dollartakeData[1];
		  
		  var dollarexactresult=openingBalance/dollarunit;

		  totalDollar=(dollarmainrate*1)*(dollarexactresult*1);
          findTotalDollar=totalDollar.toFixed(2);   
		  document.getElementById('totalDollar').value=findTotalDollar;
		  
		
		}   
	 
	 </script>
	 
<script type="text/javascript" src="js/decimal.js"></script>
 <script type="text/javascript" src="js/NumberFormat.js"></script>
 <?php include('messages.php'); ?>
	 
	 
     
	 <script src="js/validation.js"></script>
     <script src="dist/sweetalert-dev.js"></script>
      
<title><?php echo $page_title;?></title>
 
<!-- 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" style="border: 0px solid red;margin-top: -100px;background: #3598dc;">
	<!-- BEGIN SIDEBAR -->
	<?php
	$menu_selected="customers";
	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="add_customer.php">جستـجــــوی مشتــــری</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 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="insertOpeningBalance.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">
													<label class="control-label col-md-2">تاریخ<span class="required">
													</span>
													</label>
													<div class="col-md-4">
													    <?php include("datepicker.php"); ?>
													</div>
												</div>
												
												 
												 
												<div class="form-group">
													<label class="control-label col-md-2">نوعیت پول<span class="required">
													</span>
													</label>
													<div class="col-md-4">
													<select name="basecurrency"  id='basecurrency' style="width:300px" onClick="dollarPrice()" onchange="dollarPrice()" >
													<option></option>
														<?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">نوعیت حساب<span class="required">
													</span>
													</label>
													<div class="col-md-4">
														<select name="transactType" id="transactType"  style="width: 300px" onchange="dollarsRate()" onclick="dollarsRate()">
															<option></option>
															<option value='1'>رسیدگی </option>
															<option value='2'>بردگی</option>
														</select>
														<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="text"  class="filed" autocomplete="off" onkeyup="addSeparator(this)" id="openingBalance" name="openingBalance" onChange="findingcalculation()" onclick="findingcalculation()"/>
														<input type="hidden"        id="customerId" name="customerId"  value="<?php echo $customerID; ?>"/>
														<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">
														<textarea class="" rows="6"  cols="46"  name="desc" ></textarea>
														<span class="help-block">
														</span>
													</div>
												</div> 
												 
											 
												 
												 
												 
											</div>
										</div>
									</div>
									<div class="button_wrapper">
										<div class="row">
											<div class="col-md-offset-3 col-md-4">
												<input type="submit" id="submitbtn" 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">
													شماره
												</th>
												 
												 <th class="table-operation-header">
													تاریخ
												</th>
												 
												 
												<th class="table-operation-header">
													واحد پولی
												</th>
												 
												 <th class="table-operation-header">
													مقدار
												</th>
												 </th>
												 <th class="table-operation-header">
													توضیحات
												</th>
												 
												 
												<th class="table-operation-header">
													ویرایش
												</th>
												<th class="table-operation-header">
													حدف
												</th>
											</tr>
											</thead>
											<tbody>
												<?php
												     include("db.php");
													 //$customar_id=$_SESSION['customar_code'];
													 $table_name="customeropeningbalance";
												     $allSql="select * from customeropeningbalance where remove='0' and customerId='$customar_id'  order by id desc   ";
													 $allQuery= $db ->query($allSql);
													 
													 $ii=1;
													 while($allRow=$allQuery ->fetch_array()){
													       $editID=$allRow['id'];
													       
													       $currencyId=$allRow['currencyId'];
													       $rate=$allRow['rate'];
													       $date=$allRow['date'];
													       $openingBalance=$allRow['amount'];
													       $dollarAmount=$allRow['dollarAmount'];
													       $description=$allRow['description'];
													   
														 //=============finding Unit====================================
														  $unit_sql="select unit from crrencyrate where counterCurrency='$currencyId'";
														  $unit_query=$db ->query($unit_sql);
														  $unit_Row=$unit_query ->fetch_array();
														  $unit=$unit_Row['unit'];
														 //=============end finding Unit====================================
																											   
													//======================================
                                                         $currencyNameSql="select name from currencies where id='$currencyId'";													
													     $currencyNameQuery= $db ->query($currencyNameSql);
													     $currencyNameRow=$currencyNameQuery->fetch_array();
														 $currencyName=$currencyNameRow['name'];
													     
													
													
													
													//======================================  
													 
														   
													        echo "<tr>
															      <td>$ii</td> 
															      <td>$date</td> 
															      <td>$currencyName</td> 
															       
															      <td>".number_format($openingBalance,2)."</td> 
															      <td>".$description."</td> 
															      
															      <td><a  href='edit/edit_openingBalance.php?editID=".$editID."  & table=".$table_name."'  ><img alt='Submit' src='img/edit.png'   class='dontPrint' title='ویرایش'></a> </td>"; 
															      
																  
																  
																    echo "<td><a  href='delete/delete_openingBalance.php?editID=".$editID."  & table=".$table_name."' onclick='return myconfirm()'><img alt='Submit' src='img/delete.png' class='dontPrint' title='حذف'></a> </td> 
															       ";
																 
																  
																  
													    $ii++;    
													 }  
												?>
											</tbody>
										</table>
									</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");
}
?>