<?php include "layouts/menu.php"; ?> <div class="right_col" role="main">
            
            <div class="row">
                <div class="col-lg-12">
                    <!-- Form Elements -->
                    <div class="panel panel-default">
                       
                        <div class="panel-body">
                            <div class="row"> 
<?php $ddd1 = $row['date1'];
 $ddd2 = $row['date2'];
$date1 = date("Y-m-d", strtotime($ddd1));
$date2 = date("Y-m-d", strtotime($ddd2)); ?>
 <?php $sql = mysqli_query($conn, "select * from abcd where mfin='$mfin'");
 $row = mysqli_fetch_array($sql); ?>
<form name="form1" class="form-horizontal" method="post" action="" enctype="multipart/form-data">
<div class="alert alert-info">Dashboard Color Setup - </div>
<a href="https://htmlcolorcodes.com/" target="_blank"><h1>Click Here For ColorCode</h1></a></br>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">Active Loans - Main Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d1" value="<?php echo $row['d1']; ?>"  >
</div>

<label for="inputPassword3" class="col-sm-2 control-label">Active Loans - Sub Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d2" value="<?php echo $row['d2']; ?>"  >
</div>
</div>


   <div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">Closed Loans - Main Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d3" value="<?php echo $row['d3']; ?>"  >
</div>

<label for="inputPassword3" class="col-sm-2 control-label">Closed Loans - Sub Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d4" value="<?php echo $row['d4']; ?>"  >
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">Seized Loans - Main Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d5" value="<?php echo $row['d5']; ?>"  >
</div>

<label for="inputPassword3" class="col-sm-2 control-label">Seized Loans - Sub Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d6" value="<?php echo $row['d6']; ?>"  >
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">PrinBal - Main Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d7" value="<?php echo $row['d7']; ?>"  >
</div>

<label for="inputPassword3" class="col-sm-2 control-label">PrinBal - Sub Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d8" value="<?php echo $row['d8']; ?>"  >
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">Cashin - Main Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d9" value="<?php echo $row['d9']; ?>"  >
</div>

<label for="inputPassword3" class="col-sm-2 control-label">Cashin - Sub Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d10" value="<?php echo $row['d10']; ?>"  >
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">Penidng Loans - Main Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d11" value="<?php echo $row['d11']; ?>"  >
</div>

<label for="inputPassword3" class="col-sm-2 control-label">Penidng Loans - Sub Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d12" value="<?php echo $row['d12']; ?>"  >
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">Promissed - Main Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d13" value="<?php echo $row['d13']; ?>"  >
</div>

<label for="inputPassword3" class="col-sm-2 control-label">Promissed - Sub Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d14" value="<?php echo $row['d14']; ?>"  >
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label"> Loanamt - Main Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d15" value="<?php echo $row['d15']; ?>"  >
</div>

<label for="inputPassword3" class="col-sm-2 control-label"> Loanamt - Sub Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d16" value="<?php echo $row['d16']; ?>"  >
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">settle amt - Main Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d17" value="<?php echo $row['d17']; ?>"  >
</div>

<label for="inputPassword3" class="col-sm-2 control-label">settle amt - Sub Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d18" value="<?php echo $row['d18']; ?>"  >
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">interest - Main Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d19" value="<?php echo $row['d19']; ?>"  >
</div>

<label for="inputPassword3" class="col-sm-2 control-label">interest - Sub Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d20" value="<?php echo $row['d20']; ?>"  >
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">pnl- Main Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d21" value="<?php echo $row['d21']; ?>"  >
</div>

<label for="inputPassword3" class="col-sm-2 control-label">pnl - Sub Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d22" value="<?php echo $row['d22']; ?>"  >
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">MI Active Loans - Main Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d23" value="<?php echo $row['d23']; ?>"  >
</div>

<label for="inputPassword3" class="col-sm-2 control-label">AMI Active Loans - Sub Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d24" value="<?php echo $row['d24']; ?>"  >
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">MI CLOSED Loans - Main Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d25" value="<?php echo $row['d25']; ?>"  >
</div>

<label for="inputPassword3" class="col-sm-2 control-label"> MI CLOSED Loans - Sub Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d26" value="<?php echo $row['d26']; ?>"  >
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">SETLLEMENT AMT  - Main Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d27" value="<?php echo $row['d27']; ?>"  >
</div>

<label for="inputPassword3" class="col-sm-2 control-label">SETLLEMENT AMT  - Sub Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d28" value="<?php echo $row['d28']; ?>"  >
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label"> Loan AMT- Main Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d29" value="<?php echo $row['d29']; ?>"  >
</div>

<label for="inputPassword3" class="col-sm-2 control-label"> Loan AMT - Sub Color</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="inputPassword3" name="d30" value="<?php echo $row['d30']; ?>"  >
</div>
</div>
   
  <div class="form-group">
    <div class="col-sm-offset-2 col-sm-10">
      <button type="submit" class="btn btn-default" name="s1">Save This</button>
    </div>
  </div>
      <div class="alert alert-success">
	<?php
							if(isset($_POST['s1']))
							{
								extract($_POST);
								$ddd = mysqli_query($conn, "DELETE FROM abcd where mfin='$mfin'");	
				
								$insert=mysqli_query($conn, "insert into abcd(d1,d2,d3,d4,d5,d6,d7,d8,d9,d10,d11,d12,d13,d14,d15,d16,d17,d18,d19,d20,d21,d22,d23,d24,d25,d26,d27,d28,d29,d30,mfin)
											 values('$d1','$d2','$d3','$d4','$d5','$d6','$d7','$d8','$d9','$d10','$d11','$d12','$d13','$d14','$d15','$d16','$d17','$d18','$d19','$d20','$d21','$d22','$d23','$d24','$d25','$d26','$d27','$d28','$d29','$d30','$mfin')");
								
								if($insert)
								{
									
									echo "Registered Successfully";
									
								}
								else
								{
									echo "Failure";
								}
							}
?>
	  </div>
</form>
</div>

 
 
</div>
</div></div>
</div></div></div> <?php include "layouts/footer.php"; ?></body></html>