<!--
Author: W3layouts
Author URL: http://w3layouts.com
License: Creative Commons Attribution 3.0 Unported
License URL: http://creativecommons.org/licenses/by/3.0/
-->
<!DOCTYPE HTML>
<html>
<head>
<title>nehrdelivery.com</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<script type="application/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
 <!-- Bootstrap Core CSS -->
<link href="css/bootstrap.min.css" rel='stylesheet' type='text/css' />
<!-- Custom CSS -->
<link href="css/style.css" rel='stylesheet' type='text/css' />
<link href="css/font-awesome.css" rel="stylesheet"> 
<!-- jQuery -->
<script src="js/jquery.min.js"></script>
<!----webfonts--->
<link href='http://fonts.googleapis.com/css?family=Roboto:400,100,300,500,700,900' rel='stylesheet' type='text/css'>
<!---//webfonts--->  
<script>
    $(document).ready(function(){
       
       $("#staff_doc_form").submit(function(event) {
              event.preventDefault();
            
              var formValues = $(this).serialize();
              //var url = 'common/logic_load_documents.php';
              alert("test");
             $.post("common/logic_load_documents.php", formValues, function(data){
                $("#doc_load_result").innerHtml=data;
                console.log(data);
                /*if(data == 'Success'){
                    
                }else{
                    $("#doc_load_result").innerHtml="Document loading failed";
                }*/  
            });
    });
      
    });
</script>
<style>
.view {
  background: #bbf0bbab; 
  border: none;
  color: #00000;
  padding: 5px;
  text-align: center;
  text-decoration: none;
  display: inline-block;
  font-size: 10px;
  margin: 4px 2px;
  cursor: pointer;
  border-radius: 5px;
}
</style>
</head>
<body>
    <div id="wrapper">
     <!-- Navigation -->
        <?php include 'common/nav.php';?>
        <?php include 'common/connection.php';?>
        <div id="page-wrapper">
        <div class="graphs">
	   <div class="md">
		 <h3>Document Management</h3>
			
			<div class="clearfix"> </div>
			<div class="row">
			<div class="col-md-4">
				<div class="panel " data-widget="{&quot;draggable&quot;: &quot;false&quot;}" data-widget-static="">
					<div class="panel-heading">
						<h2>Staff List</h2>
						<div class="panel-ctrls" data-actions-container="" data-action-collapse="{&quot;target&quot;: &quot;.panel-body&quot;}"><span class="button-icon has-bg"><i class="ti ti-angle-down"></i></span></div>
					</div>
					<?php
					    $servername = "localhost";
                        $username = "finstech_sales";
                        $password = "SalesApp@123";
                        $dbname = "finstech_salesapp";
                        
                        $arr = [];
                        try {
                            $pdo = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
                            $rows = $pdo->query("SELECT * FROM master_staff");
                            //$rows = $stmt->execute();
                            $rows->setFetchMode(PDO::FETCH_ASSOC);
                            /*while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
                              $arr[] = $row;
                            }*/
                        }catch(PDOException $e) {
                            echo $sql . "<br>" . $e->getMessage();
                        }
                        $stmt = null;
                        $pdo = null;
					?>
					<div class="panel-body no-padding" style="display: block;">
						<table class="table table-striped">
							<thead>
								<tr >
									<th>#</th>
									<th>Name</th>
									<th>Pincode</th>
								</tr>
							</thead>
							<tbody>
							    <?php
							        $count = 1;
                                    while ($row = $rows->fetch()):
								?><tr>
								    <td><?php echo $count ?></td>
									<td><?php echo htmlspecialchars($row['name']) ?></td>
									<td><?php echo htmlspecialchars($row['assigned_pincode']) ?></td>
									<td><form action="#" method="post" id="staff_doc_form"><input type="text" name="sid" value="<?php echo htmlspecialchars($row['staff_id']) ?>"><input class="view" type="submit" value="go"></form></td>
									</tr>
								<?php 
								    $count = $count + 1; 
								    endwhile; 
								?>
							</tbody>
						</table>
					</div>
				</div>
			</div>
			<div class="col-md-8">
			    <div class="panel " data-widget="{&quot;draggable&quot;: &quot;false&quot;}" data-widget-static="">
					<div class="panel-heading">
						<h2>Documents Shared</h2>
					</div>
					<label id="doc_load_result">No documents found</label>
			    </div>
			    
			</div>
			<div class="clearfix"> </div>
		   </div>
		</div>					
       </div>
      </div>
      <!-- /#page-wrapper -->
   </div>
    <!-- /#wrapper -->
    <!-- Nav CSS -->
<link href="css/custom.css" rel="stylesheet">
<!-- Metis Menu Plugin JavaScript -->
<script src="js/metisMenu.min.js"></script>
<script src="js/custom.js"></script>
<!-- Bootstrap Core JavaScript -->
<script src="js/bootstrap.min.js"></script>

</body>
</html>
