<?php include('../template/header.php');
//==================================ordering================
$order_by= $_GET['order_by'];
	$order_by2= $_GET['order_by2'];
	if($order_by=='')
	{
		$order_by='user_name';
	}
	if($order_by2==""){
		$order_by2='ASC';
	}
$_SESSION['order_by2']=$order_by2;
$_SESSION['sess_order_by']=$order_by;
//==================================select data================
//pagination
include('../includes/newPagers.php');
$Num_Records_Page = 25; 
$PGobj = new PagerClass();
if($_REQUEST['page']==""){	$cp=1;	}
else{	$cp=intval($_REQUEST['page']);	}
$PGobj->setCurrentPage($cp);
$PGobj->SetCurpage($_SERVER['PHP_SELF']);
$columns="SELECT * ";
$listingsql=" FROM mstr_user WHERE company_id ='".$_SESSION['company_id']."' and user_type='4'";
$reccnt = getSingleResult("SELECT COUNT(*) ".$listingsql);
$limit = $PGobj->MyPaging($reccnt,$Num_Records_Page);
$sql= $columns.$listingsql." order by $order_by $order_by2 ".$limit;
$result= executeQuery($sql);
$no= mysql_num_rows($result);
?>
<script language="JavaScript">
	function isValid(formRef)
	{
		for(var i=0;i<formRef.elements.length;i++)
		{
			if(formRef.elements[i].type == "checkbox")
			{
				formRef.elements[i].checked = formRef.cb1.checked
			}
		}
	}
	function want_to_Delete()
	{
		var a;
		a=confirm("Are you sure? You want to delete the selected Record(s)?")
		if(a==true){
			form_frm.haction.value="Delete";
			form_frm.submit();
		}
	}
	function want_to_Delete_qt(id)
	{
		var a;
		a=confirm("Are you sure? You want to delete this Record?")
		if(a==true){
			form_frm.haction.value="Delete1";
			form_frm.uid.value=id;
			form_frm.submit()
		}
	}
</script>
		<!-- page heading start-->
             <div class="panel box-shadow-none content-header">
                  <div class="panel-body">
                    <div class="col-md-12">
                        <h3 class="animated fadeInLeft">Manage Employee</h3>
                        <p class="animated fadeInDown">
                          Employee <span class="fa-angle-right fa"></span>Manage Employee
                        </p>
                    </div>
                  </div>
              </div>
            <!-- page heading end-->
			 <!--body wrapper start-->
    
		<?php include('../template/response.php');?>
		
			 <div class="col-md-12 top-20 padding-0">
              <div class="col-md-12">
                <div class="panel">
				<div class="panel-heading"><h3> Employee List (<?php echo $reccnt;?>)</h3></div>
                  <div class="panel-body">					
					<div class="responsive-table">   
					<form method="post" action="delete_user.php" name="form_frm">
					<input type="hidden" name="haction">
					<input type="hidden" name="id">
					<div class="clearfix">
								<?php if(in_array("1", $action_menu)){ ?><div class="btn-group">
									<button id="add-new" type="button" class="btn btn-primary" onclick="window.location.href='add_emp_form.php';">
										Add New Employee <i class="fa fa-plus"></i>
									</button>
								</div><?php } ?>
								<?php if(in_array("300", $action_menu)){ ?><div class="btn-group">
									<button id="delete-selected" class="btn btn-primary" onclick="want_to_Delete()">
										Delete Selected <i class="fa fa-trash-o"></i>
									</button>
								</div><?php } ?>
					 </div>
					 <p></p>
					 
       <table id="dataTbl" class="table table-striped table-bordered" width="100%" cellspacing="0">
        <thead class="cf">
        <tr>
            <!--th class="sorting_disabled"><input type="checkbox" name="cb1" onClick="isValid(this.form)"></th-->
            <th>Username</th>
            <!--th>Password</th-->
            <th>Role</th>
            <th>Contact</th>
            <th>Email</th>
            <?php if(in_array("4", $action_menu)){ ?><th>Status</th><?php } ?>
            <?php if(in_array("2", $action_menu) || in_array("3", $action_menu)){ ?><th>Action</th><?php } ?>
        </tr>
        </thead>
        <tbody>
        <?php if($no>0){
			  while($line=mysql_fetch_array($result)) {
				  if($_SESSION['user_id']==$line['user_id'])
				  	continue;
		?>
        <tr>
            <!--td><input type="checkbox" name="u_ids[]" value="< ?php echo $line['user_id']?>"></td-->
            <td><?php echo $line['user_name']?></td>
            <!--td>< ?php echo $line['pass']?></td-->
            <td><?php echo getRoleName($line['role_id']); ?></td>
            <td><?php echo $line['contact_no']?></td>
            <td><?php echo $line['email_id']?></td>
            <?php if(in_array("4", $action_menu)){ ?><td>
			  <?php if($line['status']=="Active"){ ?>
                <a href="delete_user.php?uid=<?php echo $line['user_id']?>&amp;status=Inactive" class="thickbox none btn btn-success" title="Change Status">Active</a>
                 <?php }?>
                 <?php if($line['status']=="Inactive"){?>
             <a href="<?php if($_SESSION['user_id']==0){?>delete_user.php?uid=<?php echo $line['user_id']; ?>&amp;status=Active<?php }else{ ?>javascript:void(0);<?php } ?>" class="btn btn-danger" title="Change Status">Inactive</a>
             <?php }?></td><?php } ?>
            <?php if(in_array("2", $action_menu) || in_array("3", $action_menu)){ ?><td><ul class="action-links">
            <?php if(in_array("2", $action_menu)){ ?><li><a href="edit_emp_form.php?userid=<?php echo $line['user_id']?>" class="tooltips edit-btn" data-placement="top" data-toggle="tooltip" data-original-title="Edit"><i class="fa fa-edit"></i> Edit</a></li><?php } ?>
            <?php if(in_array("30", $action_menu)){ ?><li><a href="#" class="tooltips delete-btn" data-placement="top" data-toggle="tooltip" data-original-title="Delete" onClick="want_to_Delete_qt('<?php echo $line['user_id']; ?>');"><i class="fa fa-trash-o"></i> Delete</a></li><?php } ?>
            </ul></td><?php } ?>
        </tr>
        <?php } }else {?>
        <tr>
           <td colspan="8" style="margin:0px auto; text-align:center; color:#282828; font-size:14px; font-variant:small-caps; font-weight:bold;">
           Your Employee List is Empty.</td>	
           </tr>
           </p>
        <?php }?>
        </tbody>
        <tfoot>
        </tfoot>
        </table>
       
	   <div class="row-fluid hidden">
					<div class="span6">
						<div class="dataTables_info" id="dynamic-table_info" style="width:60%;float:left;padding-top: 8px;"><?php echo $PGobj->showEntries($no); ?></div>
					</div>
					<div class="span6">
						<?php echo $PGobj->showPagerContent(); ?>
					</div>
				</div>			  
            </form>		
                  </div>                
                </div>
              </div>
            </div>  
          </div>
		  
        <!--body wrapper end-->
<?php include('../template/footer.php');?>