<?php include('../template/header.php');
$order_by= $_GET['order_by'];
	$order_by2= $_GET['order_by2'];
	if($order_by=='')
	{
		$order_by='desi_id';
	}
	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_designation WHERE 1=1 and company_id ='".$_SESSION['company_id']."'";
$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.id.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 Designation</h3>
                        <p class="animated fadeInDown">
                          Designation <span class="fa-angle-right fa"></span>Manage Designation
                        </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> Designation List (<?php echo $reccnt;?>)</h3></div>
                  <div class="panel-body">					
					<div class="responsive-table">   
					<form method="post" action="delete_desi.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_desi_form.php';">
										Add New Designation <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 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>Sr no.</th>
            <th>Code</th>
            <th>Name</th>
            <th>Description</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){
			  $count = ($cp*$Num_Records_Page)-$Num_Records_Page+1;
			  while($line=mysql_fetch_array($result)) {				 
		?>
        <tr>
            <!--td><input type="checkbox" name="u_ids[]" value="< ?php echo $line['desi_id']?>"></td-->
			<td><?php echo $count; ?></td>
            <td><?php echo $line['desi_code']?></td>
            <td><?php echo $line['desi_name']?></td>            
            <td><?php echo $line['desi_desc']?></td>
            <?php if(in_array("4", $action_menu)){ ?><td>
			  <?php if($line['status']=="Active"){ ?>
                <a href="delete_desi.php?id=<?php echo $line['desi_id']?>&amp;status=Inactive" class="thickbox none btn btn-success" title="Change Status">Active</a>
                 <?php }?>
                 <?php if($line['status']=="Inactive"){?>
              <a href="delete_desi.php?id=<?php echo $line['desi_id']?>&amp;status=Active" 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_desi_form.php?id=<?php echo $line['desi_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("33", $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['desi_id']; ?>');"><i class="fa fa-trash-o"></i> Delete</a></li><?php } ?>
            </ul></td><?php } ?>
        </tr>
        <?php  $count++; } }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 Designation List is Empty.</td>	
           </tr>
           </p>
        <?php }?>
        </tbody>
        <tfoot>
        </tfoot>
        </table>
       
				<div class="row-fluid">
					<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');?>