 <!-------------Modal Manage imprest Items---------------------->
<div class="modal fade" id="modalimprestitems">
<div class="modal-dialog">
  <div class="modal-content">
    <div class="modal-header">
      <h6 class="modal-title text-secondary" >Manage Expenses Categories</h6>
      <button type="button" class="close" data-bs-dismiss="modal" aria-label="Close">
        <span aria-hidden="true">&times;</span>
      </button>
    </div>
    <div class="modal-body">
    <form method="POST" action="" id="formexpecategories" enctype="multipart/form-data" novalidate onsubmit="return false" >
        <div class="row">
             <div class="col-md-8">
                <div class="form-group">
                <label for="inputProjectLeader">Item <span class="text-danger">*</span></label>
                <input type="text" id="itemu" class="form-control" placeholder="i.e Salaries" required  />
                
              </div>
             </div>

             <div class="col-md-12">
              <div class="form-group">
                  <center><label id="expefeedback"></label></center>
             </div>
            <div class="col-md-8">
            <div class="form-group">
                <button class="btn btn-success btn-sm pull-right" id="saveitems"> Save <i class="fa fa-save"></i>
                </button>
           </div>
           </div>
             </div>
        </div>
        </form>
        <center><label id="dellabel"></label></center>
        <center><label id="">Added Expenses Items</label></center>
         <div class="table-responsive" id="divimprest">
                 <table class="table table-bordered table-sm" id="tableexpen" >
                     <thead>
                         <tr>
                             <th>#</th>
                             <th>Item</th>
                             <th>Entry Date</th>
                             <th>Action</th>
                         </tr>
                     </thead>
                     <tbody>
                        <?php
                        $sql = "select * from expenses ORDER BY Item ASC ";
                        $result = $con->query($sql);
                        if ($result->num_rows > 0) 
                        {
                        $cnt='1';
                        while($row = $result->fetch_assoc()) 
                        {
                        ?>	
                       <tr>
                        <td><?php echo $cnt; ?></td>
                        <td><?php echo $row["Item"]; ?></td>
                        <td><?php echo $row["EntryDate"]; ?></td>
                        <td>
                            <input type="hidden" name="bid" class="expecountholder" value="<?php echo $row["Count"]; ?>" />
                            <input type="hidden" name="bid" class="itemitemitem" value="<?php echo $row["Item"]; ?>" />
                            <i class="fa fa-pen btn btn-sm text-success expeediting" ></i>
                            <i class="fa fa-trash btn btn-sm text-danger expedelete" ></i>
                        </td>
                            </tr>
                            <?php
                            $cnt=$cnt+1;
                            }
                        }
                            ?>
                     </tbody>
                 </table> 
        
            </div>
          </div>
          <!-- /.modal-content -->
        </div>
        <!-- /.modal-dialog -->
      </div> 
      </div>
     
        <!-------------Modal Manage imprest Items---------------------->
<div class="modal fade" id="modalitemupdate">
<div class="modal-dialog">
  <div class="modal-content">
    <div class="modal-header">
      <h6 class="modal-title text-secondary" >Update Expenditure Category</h6>
      <button type="button" class="close" data-bs-dismiss="modal" aria-label="Close">
        <span aria-hidden="true">&times;</span>
      </button>
    </div>
    <div class="modal-body">
    <form method="POST" action="" id="" enctype="multipart/form-data" novalidate onsubmit="return false" >
        <div class="row">
             <div class="col-md-8">
                <div class="form-group">
                <label for="inputProjectLeader">Item <span class="text-danger">*</span></label>
                <input type="text" id="itemuu" class="form-control" placeholder="i.e Salaries" required  />
                <input type="hidden" id="itemuid" class="form-control" />
              </div>
             </div>
             <div class="col-md-12">
              <div class="form-group">
                  <center><label id="expefeedback2"></label></center>
             </div>
            <div class="col-md-8">
            <div class="form-group">
                <button class="btn btn-success btn-sm pull-right" id=""> Update <i class="fa fa-refresh"></i>
                </button>
           </div>
           </div>
             </div>
        </div>
        </form>
            </div>
          </div>
          <!-- /.modal-content -->
        </div>
    </div>

         <!-------------Modal imprest data View---------------------->
<div class="modal fade" id="modalimprestview">
<div class="modal-dialog">
  <div class="modal-content">
    <div class="modal-header">
      <h5 class="modal-title text-secondary" ><strong><u>imprest Update</u></strong></h5>
      <button type="button" class="close" data-dismiss="modal" aria-label="Close">
        <span aria-hidden="true">&times;</span>
      </button>
    </div>
    <div class="modal-body">
                
    <form method="POST" action="" id="" enctype="multipart/form-data" novalidate onsubmit="return false" >
        
        <div class="row">
             <div class="col-md-12 ">
                 <input type="hidden" id="impid" />
                <div class="form-group">
                <label for="inputProjectLeader">imprest Title </label>
                <input type="text" id="imptit" class="form-control text-danger" disabled placeholder="January-2022-imprest"   />
              </div>
              
              <div class="form-group">
                <label for="inputProjectLeader">Particular <span class="text-danger">*</span></label>
                <input type="text" id="partii" class="form-control" required  />
              </div>
             
               <div class="form-group">
                <label for="inputProjectLeader">Amount (KES) <span class="text-danger">*</span></label>
                <input type="text" id="impama" class="form-control text-success" required />
              </div>
            
               <div class="form-group">
                <label for="inputProjectLeader">Expense Date <span class="text-danger">*</span></label>
                <input type="date" id="expedate" class="form-control" />
              </div>
          
            
               <div class="form-group">
                <label for="inputProjectLeader">Category <span class="text-danger">*</span></label>
                <select id="cate" class="form-control custom-select">
                    <option selected value="">Select ---</option>
                    <?php
                    $sql = "SELECT * FROM expenses order by Item ASC";
                    $result = $con->query($sql);
                    while($row = $result->fetch_assoc()) 
                    {
                    ?>
                    <option value="<?php echo $row['Count']; ?>"><?php echo $row['Item']; ?>
                    </option>
                    <?php
                    }
                    ?>
                </select>
              </div>
              
              <div class="form-group">
                <label for="inputProjectLeader">Mode of Payment <span class="text-danger">*</span></label>
                <input type="text" id="mod" class="form-control" />
              </div>
              
              <div class="form-group">
                <label for="inputProjectLeader">Description</label>
               <textarea id="descri" class="form-control" ></textarea>
              </div>
              
              <div class="form-group">
                <label for="inputProjectLeader">Saved/Last Update by</label>
               <input type="text" id="usa" class="form-control"  />
              </div>
             </div>
             <div class="form-group">
                 <input type="hidden" id="txtimpid" />
                 <center><label id="impmes"></label></center>
                <button class="btn btn-success btn-sm " id="btnimprestdata" style="float:right">Update <i class="fa fa-refresh"></i></button>
             </div>
        </div>
        </form>
          </div>
          <!-- /.modal-content -->
        </div>
        <!-- /.modal-dialog -->
      </div> 
      </div>  
     
    
      <!-------------Modal Update imprests---------------------->
          
<div class="modal fade" id="modalupdateimprest">
<div class="modal-dialog modal-lg">
  <div class="modal-content">
    <div class="modal-header">
      <h4 class="modal-title text-secondary" >Update imprest Data</h4>
      <button type="button" class="close" data-dismiss="modal" aria-label="Close">
        <span aria-hidden="true">&times;</span>
      </button>
    </div>
    <div class="modal-body">
                
    <form method="POST" action="" id="formupdateimprest" enctype="multipart/form-data" novalidate onsubmit="return false" >
        
        <div class="row">
             <div class="col-md-4">
                 <input type="hidden" id="impid" />
                <div class="form-group">
                <label for="inputProjectLeader">imprest Title <span class="text-danger">*</span></label>
                <input type="text" id="imptitlee" class="form-control" placeholder="January-2022-imprest" required  />
              </div>
             </div>
             
              <div class="col-md-4">
               <div class="form-group">
                <label for="inputProjectLeader">imprest Worth (KES) <span class="text-danger">*</span></label>
                <input type="text" id="impamountt" class="form-control" required />
              </div>
             </div>
             
              <div class="col-md-4">
               <div class="form-group">
                      <label for="inputProjectLeader">Account Debited <span class="text-danger">*</span></label>
                       <select id="impbankk" class="form-control custom-select">
                            <option selected value="">Select ---</option>
                            <?php
                            $sql = "SELECT * FROM bankdata";
                            $result = $con->query($sql);
                            while($row = $result->fetch_assoc()) 
                            {
                            ?>
                            <option value="<?php echo $row['id']; ?>"><?php echo $row['Bname'].'->'; ?>  <small><?php echo $row['Account']; ?></small>
                            </option>
                            <?php
                            }
                            ?>
                     </select>
                       </div>
             </div>
             
             <div class="col-md-4">
               <div class="form-group">
                <label for="inputProjectLeader">Withdrawal Date <span class="text-danger">*</span></label>
                <input type="date" id="impwithdatee" class="form-control" />
              </div>
             </div>
             
             <div class="col-md-4">
               <div class="form-group">
                <label for="inputProjectLeader">Cheque No. <span class="text-danger">*</span></label>
                <input type="text" id="impcheqq" class="form-control" required />
              </div>
             </div>
            
             
             <div class="col-md-12">
               <div class="form-group">
                <label for="inputProjectLeader">imprest Description</label>
                <textarea id="impdescc" class="form-control"></textarea>
              </div>
             </div>
             
             <div class="col-md-12">
              <div class="form-group">
                  <center><label id="impfeedbackk"></label></center>
              </div>
              
                <div class="form-group">
                    <button class="btn btn-info btn-sm" id="updateimprest"> Update Project <i class="fa fa-refresh"></i>
                    </button>
               </div>
               </div>
        </div>
        </form>
          </div>
          <!-- /.modal-content -->
        </div>
        <!-- /.modal-dialog -->
      </div> 
      </div>  
   
   
     <!-------------Modal Manager for imprests---------------------->
          
<div class="modal fade" id="modalimprest">
<div class="modal-dialog modal-xl">
  <div class="modal-content">
    <div class="modal-header">
      <h4 class="modal-title text-secondary" >Manage imprests</h4>
      <button type="button" class="close" data-dismiss="modal" aria-label="Close">
        <span aria-hidden="true">&times;</span>
      </button>
    </div>
    <div class="modal-body">
                
    <form method="POST" action="" id="formsubmitimprest" enctype="multipart/form-data" novalidate onsubmit="return false" >
        
        <div class="row">
             <div class="col-md-4">
                <div class="form-group">
                <label for="inputProjectLeader">imprest Title <span class="text-danger">*</span></label>
                <input type="text" id="imptitle" class="form-control" placeholder="January-2022-imprest" required  />
              </div>
             </div>
             
              <div class="col-md-4">
               <div class="form-group">
                <label for="inputProjectLeader">imprest Worth (KES) <span class="text-danger">*</span></label>
                <input type="text" id="impamount" class="form-control" required />
              </div>
             </div>
             
              <div class="col-md-4">
               <div class="form-group">
                      <label for="inputProjectLeader">Account Debited <span class="text-danger">*</span></label>
                       <select id="impbank" class="form-control custom-select">
                            <option selected value="">Select ---</option>
                            <?php
                            $sql = "SELECT * FROM bankdata";
                            $result = $con->query($sql);
                            while($row = $result->fetch_assoc()) 
                            {
                            ?>
                            <option value="<?php echo $row['id']; ?>"><?php echo $row['Bname'].'->'; ?>  <small><?php echo $row['Account']; ?></small>
                            </option>
                            <?php
                            }
                            ?>
                     </select>
                       </div>
             </div>
             
             <div class="col-md-4">
               <div class="form-group">
                <label for="inputProjectLeader">Withdrawal Date <span class="text-danger">*</span></label>
                <input type="date" id="impwithdate" class="form-control" />
              </div>
             </div>
             
             <div class="col-md-4">
               <div class="form-group">
                <label for="inputProjectLeader">Cheque No. <span class="text-danger">*</span></label>
                <input type="text" id="impcheq" class="form-control" required />
              </div>
             </div>
            
             
             <div class="col-md-12">
               <div class="form-group">
                <label for="inputProjectLeader">imprest Description</label>
                <textarea id="impdesc" class="form-control"></textarea>
              </div>
             </div>
             
             <div class="col-md-12">
              <div class="form-group">
                  <center><label id="impfeedback"></label></center>
              </div>
              
                <div class="form-group">
                    <button class="btn btn-info btn-sm" id="saveimprest"> Save imprest <i class="fa fa-paper-plane"></i>
                    </button>
               </div>
               </div>
        </div>
        </form>
        <center><label id="implabel"></label></center>
         <div class="table-responsive" id="divimprest">
                 <table class="table table-bordered" id="tableimprests" >
                     <thead>
                         <tr>
                             <th>#</th>
                             <th>imprest Title</th>
                             <th>imprest Worth (KES)</th>
                             <th>Withdrawal Date</th>
                             <th>Cheque No.</th>
                             <th>Bank Debited</th>
                             <th>Total Spent</th>
                             <th>Balance</th>
                             <th>Entry Date</th>
                             <th>Description</th>
                             <th>Action</th>
                         </tr>
                     </thead>
                     <tbody>
                        <?php
                        //include('../include/config.php');
                        $sql = "select Imprest.*,bankdata.Bname as bnm, bankdata.Account as act,(SELECT SUM(Amount) from Imprest2 WHERE Imprest=Imprest.id) as spent from Imprest left join bankdata ON bankdata.id=Imprest.Bank 
                        left join Imprest2 ON Imprest2.imprest=Imprest.id GROUP BY id ORDER by Date DESC ";
                        $result = $con->query($sql);
                        if ($result->num_rows > 0) 
                        {
                        $cnt='1';
                        while($row = $result->fetch_assoc()) 
                        {
                        ?>	
                       <tr>
                        <td><?php echo $cnt; ?></td>
                        <td><?php echo $row["Title"]; ?></td>
                        <td class="alert-success"><strong><?php echo $row["Amount"]; ?></strong>
                        </td>
                        <td><?php echo $row["Date"]; ?></td>
                        <td><strong><?php echo $row["Cheque"]; ?></strong></td>
                        <td><?php echo $row["bnm"]; ?> ( <small><?php echo $row["act"]; ?></small>)</td>
                        
                        <td class="alert-success"><strong><?php echo $row["spent"]; ?></strong></td>
                        <td class="alert-warning">
                            <strong>
                           <?php
                            $am=$row["Amount"];
                            $sp=$row["spent"];
                            $bal=$am-$sp;
                            echo $bal; 
                            ?>
                            </strong>
                            </td>
                        <td><?php echo $row["EntryDate"]; ?></td>
                        <td><?php echo $row["Des"]; ?></td>
                        
                        <td>
                            <input type="hidden" name="bid" class="impidholder" value="<?php echo $row["id"]; ?>" />
                         <i class="fa fa-edit btn-xs text-info impedit" id="">
                             
                         </i>
                        |
                        <i class="fa fa-trash btn-xs text-danger impdelete" >
                        </i>
                        </td>
                            </tr>
                            <?php
                            $cnt=$cnt+1;
                            }
                        }
                            ?>
                     </tbody>
                 </table> 
        
            </div>
          </div>
          <!-- /.modal-content -->
        </div>
        <!-- /.modal-dialog -->
      </div> 
      </div>
   
   
   
   
   
   
   
   <!-------------Modal Add projects---------------------->
          
<div class="modal fade" id="modalprojects">
<div class="modal-dialog modal-lg">
  <div class="modal-content">
    <div class="modal-header">
      <h4 class="modal-title text-secondary" >Add new Project</h4>
      <button type="button" class="close" data-dismiss="modal" aria-label="Close">
        <span aria-hidden="true">&times;</span>
      </button>
    </div>
    <div class="modal-body">
                
    <form method="POST" action="" id="formsubmitproject" enctype="multipart/form-data" novalidate onsubmit="return false" >
        
        <div class="row">
             <div class="col-md-4">
                <div class="form-group">
                <label for="inputProjectLeader">Project ID <span class="text-danger">*</span></label>
                <input type="text" id="proid" class="form-control" required  />
              </div>
             </div>
             
              <div class="col-md-8">
               <div class="form-group">
                <label for="inputProjectLeader">Project Name <span class="text-danger">*</span></label>
                <input type="text" id="proname" class="form-control" required />
              </div>
             </div>
             
              <div class="col-md-4">
               <div class="form-group">
                <label for="inputProjectLeader">Estimated Cost (KES)</label>
                <input type="number" id="estcost" class="form-control" placeholder="i.e 200000">
              </div>
             </div>
             
             <div class="col-md-4">
               <div class="form-group">
                <label for="inputProjectLeader">Project Start Date <span class="text-danger">*</span></label>
                <input type="date" id="projstart" class="form-control" />
              </div>
             </div>
             
             <div class="col-md-4">
               <div class="form-group">
                <label for="inputProjectLeader">Expected Completion Date</label>
                <input type="date" id="ExCompDate" class="form-control" />
              </div>
             </div>
             
             <div class="col-md-6">
               <div class="form-group">
                <label for="inputProjectLeader">Contractor/Supervisor <span class="text-danger">*</span></label>
                <input type="text" id="superviser" class="form-control" />
              </div>
             </div>
            
             
             <div class="col-md-12">
               <div class="form-group">
                <label for="inputProjectLeader">Any other Information</label>
                <textarea id="prodesc" class="form-control"></textarea>
              </div>
             </div>
             
             <div class="col-md-12">
              <div class="form-group">
                  <center><label id="projectfeedback"></label></center>
              </div>
              
                <div class="form-group">
                    <button class="btn btn-info btn-sm" id="saveprojectdata"> Save Project <i class="fa fa-paper-plane"></i>
                    </button>
               </div>
               </div>
        </div>
        </form>
        
            </div>
          </div>
          <!-- /.modal-content -->
        </div>
        <!-- /.modal-dialog -->
      </div>
      
      <!------Update project data --->
         <!-------------Modal Add projects---------------------->
          
<div class="modal fade" id="updatepromo">
        <div class="modal-dialog modal-lg">
          <div class="modal-content">
            <div class="modal-header">
              <h4 class="modal-title text-secondary" >Update Project Data</h4>
              <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                <span aria-hidden="true">&times;</span>
              </button>
            </div>
            <div class="modal-body">
                
    <form method="POST" action="" id="formsubmitproject2" enctype="multipart/form-data" novalidate onsubmit="return false" >
        
        <div class="row">
             <div class="col-md-4">
                <div class="form-group">
                <label for="inputProjectLeader">Project ID <span class="text-danger">*</span></label>
                <input type="text" id="proid2" class="form-control" required disabled=""  />
              </div>
             </div>
             
              <div class="col-md-8">
               <div class="form-group">
                <label for="inputProjectLeader">Project Name <span class="text-danger">*</span></label>
                <input type="text" id="proname2" class="form-control" required />
              </div>
             </div>
             
              <div class="col-md-4">
               <div class="form-group">
                <label for="inputProjectLeader">Estimated Cost (KES)</label>
                <input type="number" id="estcost2" class="form-control" placeholder="i.e 200000">
              </div>
             </div>
             
             <div class="col-md-4">
               <div class="form-group">
                <label for="inputProjectLeader">Project Start Date <span class="text-danger">*</span></label>
                <input type="date" id="projstart2" class="form-control" />
              </div>
             </div>
             
             <div class="col-md-4">
               <div class="form-group">
                <label for="inputProjectLeader">Expected Completion Date</label>
                <input type="date" id="ExCompDate2" class="form-control" />
              </div>
             </div>
             
             <div class="col-md-6">
               <div class="form-group">
                <label for="inputProjectLeader">Contractor/Supervisor <span class="text-danger">*</span></label>
                <input type="text" id="superviser2" class="form-control" />
              </div>
             </div>
             
             <div class="col-md-3">
               <div class="form-group">
                <label for="inputProjectLeader">Date Completed </label>
                <input type="date" id="compdate" class="form-control" />
              </div>
             </div>
             
             <div class="col-md-3">
               <div class="form-group">
                <label for="inputProjectLeader">Status </label>
                <select class="form-control" id="prostate">
                    <option value="Ongoing">Ongoing</option>
                    <option value="Complete">Complete</option>
                    <option value="Halted">Halted</option>
                    <option value="Cancelled">Cancelled</option>
                </select>
              </div>
             </div>
            
             <div class="col-md-12">
               <div class="form-group">
                <label for="inputProjectLeader">Any other Information</label>
                <textarea id="prodesc2" class="form-control"></textarea>
              </div>
             </div>
             
             <div class="col-md-12">
              <div class="form-group">
                  <center><label id="projectfeedback2"></label></center>
              </div>
              
                <div class="form-group">
                    <input type="hidden" id="proidhidden" class="form-control" required  />
                    <button class="btn btn-success btn-sm" id="saveprojectdata"> Update Project <i class="fa fa-refresh"></i>
                    </button>
               </div>
               </div>
        </div>
        </form>
        
            </div>
          </div>
          <!-- /.modal-content -->
        </div>
        <!-- /.modal-dialog -->
      </div>
      
      <!---------------Add Data  -->
      






<div class="modal fade" id="Modaltransactions">
<div class="modal-dialog modal-lg">
  <div class="modal-content">
    <div class="modal-header">
      <h6 class="modal-title text-secondary" >Project Expenses</h6>
      <button type="button" class="close" data-dismiss="modal" aria-label="Close">
        <span aria-hidden="true">&times;</span>
      </button>
    </div>
    <div class="modal-body">
    <form method="POST" action="" id="formprodata" enctype="multipart/form-data" novalidate onsubmit="return false" >
       
        <div class="row">
             <div class="col-md-4">
                <div class="form-group">
                <label for="inputProjectLeader">Date <span class="text-danger">*</span></label>
                <input type="date" id="da" class="form-control" required   />
              </div>
             </div>
             
              <div class="col-md-8">
               <div class="form-group">
                <label for="inputProjectLeader">Particular <span class="text-danger">*</span></label>
                <input type="text" id="pa" class="form-control" required />
              </div>
             </div>
             
              <div class="col-md-4">
               <div class="form-group">
                <label for="inputProjectLeader">Amount spent (KES)  <span class="text-danger">*</span></label>
                <input type="number" id="am" class="form-control" placeholder="i.e 200000">
              </div>
             </div>
             
             <div class="col-md-4">
               <div class="form-group">
                <label for="inputProjectLeader">Cheque No</label>
                <input type="text" id="ch" class="form-control" placeholder="i.e 200000">
              </div>
             </div>
             <div class="col-md-4">
             <div class="form-group">
                      <label for="inputProjectLeader">Account Debited</label>
                       <select id="actdeb" class="form-control custom-select">
                            <option selected value="">Select ---</option>
                            <?php
                            $sql = "SELECT * FROM bankdata";
                            $result = $con->query($sql);
                            while($row = $result->fetch_assoc()) 
                            {
                            ?>
                            <option value="<?php echo $row['id']; ?>"> <?php echo $row['Bname'].'->'; ?> <small><?php echo $row['Account']; ?> </small>
                            </option>
                            <?php
                            }
                            ?>
                     </select>
                       </div>
                </div>
         
             <div class="col-md-12">
              <div class="form-group">
                  <center><label id="promess"></label></center>
              </div>
              
                <div class="form-group">
                    <input type="hidden" name="" id="projid" />
                    <button class="btn btn-success btn-sm" id="saveprodat"> Submit <i class="fa fa-plus"></i>
                    </button>
               </div>
               </div>
        </div>
        </form>
        
            </div>
          </div>
          <!-- /.modal-content -->
        </div>
        <!-- /.modal-dialog -->
      </div>
      
      
      
<div class="modal fade" id="Modaltransactionsss">
<div class="modal-dialog modal-lg">
  <div class="modal-content">
    <div class="modal-header">
      <h6 class="modal-title text-secondary" >Update Project's Expenses</h6>
      <button type="button" class="close" data-dismiss="modal" aria-label="Close">
        <span aria-hidden="true">&times;</span>
      </button>
    </div>
    <div class="modal-body">
    <form method="POST" action="" id="formprodataaa" enctype="multipart/form-data" novalidate onsubmit="return false" >
       
        <div class="row">
             <div class="col-md-4">
                <div class="form-group">
                <label for="inputProjectLeader">Date <span class="text-danger">*</span></label>
                <input type="date" id="eda" class="form-control" required   />
              </div>
             </div>
             
              <div class="col-md-8">
               <div class="form-group">
                <label for="inputProjectLeader">Particular <span class="text-danger">*</span></label>
                <input type="text" id="epa" class="form-control" required />
              </div>
             </div>
             
              <div class="col-md-4">
               <div class="form-group">
                <label for="inputProjectLeader">Amount spent (KES)  <span class="text-danger">*</span></label>
                <input type="number" id="eam" class="form-control" placeholder="i.e 200000">
              </div>
             </div>
             
             <div class="col-md-4">
               <div class="form-group">
                <label for="inputProjectLeader">Cheque No</label>
                <input type="text" id="ech" class="form-control" placeholder="i.e 200000">
              </div>
             </div>
             <div class="col-md-4">
             <div class="form-group">
                      <label for="inputProjectLeader">Account Debited</label>
                       <select id="eactdeb" class="form-control custom-select">
                            <option selected value="">Select ---</option>
                            <?php
                            $sql = "SELECT * FROM bankdata";
                            $result = $con->query($sql);
                            while($row = $result->fetch_assoc()) 
                            {
                            ?>
                            <option value="<?php echo $row['id']; ?>"> <?php echo $row['Bname'].'->'; ?> <small><?php echo $row['Account']; ?> </small>
                            </option>
                            <?php
                            }
                            ?>
                     </select>
                       </div>
                </div>
         
             <div class="col-md-12">
              <div class="form-group">
                  <center><label id="promesss"></label></center>
              </div>
              
                <div class="form-group">
                    <input type="hidden" name="" id="eprojid" />
                      <button class="btn btn-info btn-sm" id="saveprodataa"> Submit <i class="fa fa-plus"></i>
                    </button>
               </div>
               </div>
        </div>
        </form>
        
            </div>
          </div>
          <!-- /.modal-content -->
        </div>
        <!-- /.modal-dialog -->
      </div>
      
      
      
      