1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / mfms22 / dev.mfmsbd.com /
Filename : open-capital.php
back
<?PHP
	require 'functions.php';
	checkLogin();
	checkPermissionReport();
	$db_link = connect();
	$timestamp = time();


    if(isset($_POST['opening_capital'])){

        $del_query = mysqli_query($db_link, "DELETE FROM capital");

        $amount     = getNumber(sanitize($db_link, $_POST['amount']));
		$cap_date   = strtotime(sanitize($db_link, $_POST['cap_date']));

        $update_sql     = "INSERT INTO capital (amount, cap_date) VALUES ($amount, $cap_date)";
		$update_query   = mysqli_query($db_link, $update_sql);

		if($update_query){
				$_SESSION['open_capital'] = "Opening Capital Update Successfully";
			}else{
				$_SESSION['open_capital'] = "Opening Capit Update Faild";
			}
    }

  

	// select all from cpital
	$select_sql = "SELECT * FROM capital";
	$select_query = mysqli_query($db_link, $select_sql);

    // Total cpital
	$total_capital_sql = "SELECT sum(amount) as amount FROM capital";
	$total_capital_query = mysqli_query($db_link, $total_capital_sql);
    $row_total_capital = mysqli_fetch_assoc($total_capital_query);
    
    // Opening capital
    $opening_capital_sql = "SELECT * FROM capital LIMIT 1";
	$opening_capital_query = mysqli_query($db_link, $opening_capital_sql);
    $row_opening_capital = mysqli_fetch_assoc($opening_capital_query);

	

?>

<?php headandmenu('Opening Capital', '3sc'); ?>

<!--main content start-->
      <section id="main-content">
          <section class="wrapper" style="min-height: 850px;">


          <!--breadcrumbs start -->
          	<div class="row">
                  <div class="col-lg-12 pb-4">
                      <!--breadcrumbs start -->
                      <nav aria-label="breadcrumb">
                          <ol class="breadcrumb">
                              <li class="breadcrumb-item"><a href="start.php"><i class="fa fa-home"></i> Dashboard</a></li>
                              <li class="breadcrumb-item"><a href="#">Opening Capital</a></li>
                          </ol>
                      </nav>
                  </div>
              </div>
             <!--breadcrumbs end -->
		
			
		<!-- LEFT SIDE: Form for entering new expense -->


    <div class="row">
		 	<div class="col-md-4">
				<div class="card">
					<div class="card-header">
						<h4>Openign Capital</h4>
					</div>
					<div class="card-body">

					<?php if(isset($_SESSION['open_capital'])){  ?> 
						<div class="col-md-12 alert alert-warning alert-dismissible fade show" role="alert">
							<?php echo $_SESSION['open_capital']; ?>
						</div>
					<?php unset($_SESSION['open_capital']); } ?>	

						<form action="open-capital.php" method="POST">
							<div class="col-md-12 mb-3">
								<label>Amount</label>
								<input type="text" name="amount" class="form-control" required>
							</div>
							<div class="col-md-12 mb-3">
								<label>Date</label>
								<input type="text" id="datepicker" name="cap_date" value="<?PHP echo date('d.m.Y',$timestamp); ?>" class="form-control" required>
							</div>
							<div class="col-md-12">
								<input onclick="return confirm('If you update opening capital all previous capital will be deleted. Are you sure update opening balance?')" type="submit" class="btn btn-primary" value="Submit" name="opening_capital" >
							</div>
						</form>
					</div>
				</div>
			</div>
		
		
		<!-- RIGHT SIDE: Recent Expenses -->
		<div class="col-md-8">
			<table id="tb_table">
				<tr>
					<th class="title" colspan="7">Opening Capital</th>
				</tr>
				<tr>
					<th>Type</th>
					<th>Date</th>
					<th>Amount</th>
				</tr>
		
				<tr>
					<td>Opening Capital</td>
					<td><?= date('d.m.Y', $row_opening_capital['cap_date']);  ?></td>
					<td><?= $row_opening_capital['amount']; ?> BDT</td>
					
				</tr>
			</table>
		</div>
	</div>




             </section>
      </section>
      <!--main content end-->
      
   <?php footer(); ?>