<!--
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(){
        $("#onbording").hide();    
      $("#new_staff").click(function(){
        $("#onbording").show();
      });
      $("#new_staff_close").click(function(){
        $("#onbording").hide();
      });
      $("#btn_reset").click(function(){
        setOnBoardResponse("","");
      });
      $("#btn_submit").click(function(){
        setOnBoardResponse("","");
      });
      
      $("#onboard_form").submit(function(event) {

        /* stop form from submitting normally */
          event.preventDefault();
        
          /* get the action attribute from the <form action=""> element */
          var formValues = $(this).serialize();
          var url = 'common/logic_customer_on_board.php';
         $.post("common/logic_staff_onboard.php", formValues, function(data){
            if(data == 'Success'){
                $('#onboard_form').trigger("reset");
                setOnBoardResponse("Onboarding success!","");
                location.reload();
            }else{
                console.log(data);
                setOnBoardResponse("","Onboarding failed!");
            }  
        });
         
    });
    });
    
    function setOnBoardResponse(success, failure){
        $("#onboard_result_success").text(success);
        $("#onboard_result_fail").text(failure);
    }
</script>
<style>
.edit {
  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;
}
.delete {
  background-color: #f2dcdcab; 
  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>Staff Management</h3>
		<div class="form-group">
		  <div class="row">
			<div class="col-md-12">
				<div class="col_3">
					<div class="col-md-3 widget widget1">
						<div class="r3_counter_box" id="new_staff">
							<i class="pull-left fa fa-user icon-rounded"></i>
							<div class="stats">
							  <h5><strong>New Staff</strong></h5>
							</div>
						</div>
					</div>
					<!--<div class="col-md-3 widget widget1">
						<div class="r3_counter_box" id="new_staff_category">
							<i class="pull-left fa fa-file icon-rounded"></i>
							<div class="stats">
							  <h5><strong>New Category</strong></h5>
							</div>
						</div>
					</div>-->
					<div class="clearfix"> </div>
			  </div>
			</div>
			
			<div id="onbording">
			<div class="col-md-12">
			    <div class="well1 white">
			        <button id="new_staff_close" style="float: right;">X</button>
			        <center><span id="onboard_result_success" style="color: green;"></span></center>
			        <center><span id="onboard_result_fail" style="color: red;"></span></center>
			        <h3><u>Staff on bording</u></h3>
			        <div class="row">
                <form id="onboard_form" class="form-floating" method="post">
                    <input type="hidden" name="key" value="shop_on_board"/>
                    <div class="col-md-6">
                  <fieldset>
                    <div class="form-group">
                      <label class="control-label">Name</label>
                      <input type="text" name="staff_name" id="staff_name" class="form-control1" required="required">
                    </div>
                    <!--<div class="form-group">
                      <label class="control-label">Email</label>
                      <input type="email" class="form-control1 ng-invalid ng-valid-email ng-invalid-required ng-touched" ng-model="model.email" required="">
                    </div>-->
                    <div class="form-group">
                      <label class="control-label">Mobile</label>
                      <input type="text" name="mobile" id="mobile" minlength="10" maxlength="10" class="form-control1" required="required">
                    </div>
                    <div class="form-group">
                      <label class="control-label">Place</label>
                      <input type="text" id="place" name="place" class="form-control1" required="required">
                    </div>
                    <div class="form-group">
                      <label class="control-label">pincode assigned</label>
                      <input type="text" id="pincode" name="pincode" minlength="6" maxlength="6" class="form-control1" required="required">
                    </div>
                  </fieldset>
                  </div>
                  
                    <div class="col-md-6">
                        <fieldset>
                            <div class="form-group">
                              <label class="control-label">Address Line 1</label>
                              <input type="text" name="address_line1" class="form-control1" required="required">
                            </div>
                            <div class="form-group">
                              <label class="control-label">Address Line 2</label>
                              <input type="text" name="address_line2" class="form-control1" required="required">
                            </div>
                            <div class="form-group">
                              <label class="control-label">Address Line 3</label>
                              <input type="text" name="address_line3" class="form-control1" required="required">
                            </div>
                            <div class="form-group filled">
                              <label class="control-label">Assigned Shop</label>
                              <select id="shop_id" name="shop_id" class="form-control1" required="required">
                                  <?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 shop_id, shop_name FROM master_shop");
                                        $rows->setFetchMode(PDO::FETCH_ASSOC);
                                    }catch(PDOException $e) {
                                        echo $sql . "<br>" . $e->getMessage();
                                    }
                                    $stmt = null;
                                    $pdo = null;
            					
                                    while ($row = $rows->fetch()):
								?>
                                <option value="<?php echo htmlspecialchars($row['shop_id']) ?>"><?php echo htmlspecialchars($row['shop_name']) ?></option>
                                <?php  
								    endwhile; 
								?>
                              </select>
                            </div>
                    <div class="form-group" style="float: right;">
                      <button type="reset" id="btn_reset" class="btn btn-default">Reset</button>
                      <button type="submit" id="btn_submit" class="btn btn-primary">Submit</button>
                    </div>
                        </fieldset>
                    </div>
                </form>
                </div>
              </div>
			</div>
			</div>
			</div>
			</div>
			
			<div class="clearfix"> </div>
			<div class="row">
			<div class="col-md-12">
				<div class="panel " data-widget="{&quot;draggable&quot;: &quot;false&quot;}" data-widget-static="">
					<div class="panel-heading">
						<h2>Staff Members</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>Mobile</th>
									<th>Place</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['mobile']) ?></td>
									<td><?php echo htmlspecialchars($row['place']) ?></td>
									<td><?php echo htmlspecialchars($row['assigned_pincode']) ?></td>
									<td><form action="staff_edit.php" method="post"><input type="hidden" name="sid" value="<?php echo htmlspecialchars($row['staff_id']) ?>"><input class="edit" type="submit" value="edit"></form></td>
									<td><form action="staff_delete.php" method="post"><input type="hidden" name="sid" value="<?php echo htmlspecialchars($row['staff_id']) ?>"><input class="delete" type="submit" value="delete"></form></td>
								</tr>
								<?php 
								    $count = $count + 1; 
								    endwhile; 
								?>
							</tbody>
						</table>
					</div>
				</div>
			</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>
