1#@!#!123s

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


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

        $add_sql = "INSERT INTO capital (amount, cap_date) VALUES ($amount, $cap_date)";
        $add_query = mysqli_query($db_link, $add_sql);
        if($add_query){
            $_SESSION['update_capital'] = "Capital Update Successfully";
        }else{
            $_SESSION['update_capital'] = "Capital 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);
    



?>

<?php headandmenu('Add Capital', '2sc'); ?>

<!--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="#">Add Capital</a></li>
                          </ol>
                      </nav>
                  </div>
              </div>
             <!--breadcrumbs end -->
 
             
             <div class="row">
		 	<div class="col-md-4">
				<div class="card">
					<div class="card-header">
						<h4>Add Capital</h4>
					</div>
					<div class="card-body">

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

						<form action="add-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('Are you sure to add capital balance?')" type="submit" class="btn btn-primary" value="Submit" name="add_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">Total Capital: <?php echo $row_total_capital['amount'].' '.$_SESSION['set_cur']; ?></th>
				</tr>
				<tr>
					<th>Date</th>
					<th>Amount</th>
				</tr>
                <?php while($row = mysqli_fetch_assoc($select_query)){ ?>         
				<tr>
					<td><?= date('d.m.Y', $row['cap_date']);  ?></td>
					<td><?= $row['amount']; ?> BDT</td>
					
				</tr>
                <?php } ?>
				
				

			</table>
		</div>
	</div>




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