<?php include('../template/header.php');

$order_by= $_GET['order_by'];
	$order_by2= $_GET['order_by2'];

	if($order_by=='')
	{
		$order_by='company_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 = 10; 
$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_company WHERE 1=1";
$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 Clients</h3>
                        <p class="animated fadeInDown">
                          Clients <span class="fa-angle-right fa"></span>Manage Client
                        </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> Client List (<?php echo $reccnt;?>)</h3></div>
                  <div class="panel-body">					
					<div class="responsive-table">   
					<form method="post" action="delete_company.php" name="form_frm">
					<input type="hidden" name="haction">
					<input type="hidden" name="id">
					<div class="clearfix">
								<?php if(in_array("11", $action_menu)){ ?><div class="btn-group">
									<button id="add-new" type="button" class="btn btn-primary" onclick="window.location.href='add_company_form.php';">
										Add New Client <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>Sr no.</th>
            <th>Client Id</th>
            <th>Member Since</th>
            <th>Client Name</th>
			<th>Active Users</th>
            <th>Image</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)) {
//				  $resultcity=mysql_query("select city_name,state_name from mstr_city_state where city_id='".$line['city_name']."';");
//				  while($cityrow=mysql_fetch_array($resultcity)){
//				  	$city=$cityrow['city_name'];
//					$state=$cityrow['state_name'];
//			  		}
		?>
        <tr>
            <!--td><input type="checkbox" name="ids[]" value="< ?php echo $line['company_id']?>"></td-->
			<td><?php echo $count; ?></td>
            <td><?php echo $line['client_id']?></td>
            <td><?php echo $line['created_date']?></td>
            <td><?php echo $line['company_name']?></td>
			<td><a href="view_company_user.php?cid=<?php echo $line['company_id']?>" class="btn btn-<?php if(getActiveUser($line['company_id'])!=0){?>success<?php }else{ echo "danger"; } ?>" ><?php echo getActiveUser($line['company_id']); ?></a></td>
            <td><img src="../resources/<?php if($line['logo']!=''){ echo 'client/'.$line['logo']; }else{echo "no_image.jpg";}?>" class="media-object img-5"/></td>
            <?php if(in_array("4", $action_menu)){ ?><td>
			  <?php if($line['status']=="Active"){ ?>
                <a href="delete_company.php?id=<?php echo $line['company_id']?>&amp;status=Inactive" class="thickbox none btn btn-success" title="Change Status">Active</a>
                 <?php }?>
                 <?php if($line['status']=="Inactive"){?>
              <a href="delete_company.php?id=<?php echo $line['company_id']?>&amp;status=Active" class="btn btn-danger" style="color:#700;" title="Change Status">Inactive</a>
             <?php }?></td><?php } ?>
            <?php if(in_array("2", $action_menu) || in_array("3", $action_menu)){ ?><td>
			<ul class="nav nav-tabs">
            <?php if(in_array("2", $action_menu)){ ?><li><a href="edit_company_form.php?id=<?php echo $line['company_id']?>" class="tooltips edit-btn" data-placement="top" data-toggle="tooltip" data-trigger="hover" 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-trigger="hover" data-original-title="Delete" onClick="want_to_Delete_qt('<?php echo $line['company_id']; ?>');"><i class="fa fa-trash-o"></i> Delete</a></li><?php } ?>
            </ul></td><?php } ?>
        </tr>
        <?php  $count++; } }else {?>
        <tr>
           <td colspan="6" style="margin:0px auto; text-align:center; color:#282828; font-size:14px; font-variant:small-caps; font-weight:bold;">
           Your Client 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>

<?php include('../template/footer.php');?>