<?php include('../template/header.php');
$order_by= $_GET['order_by'];
	$order_by2= $_GET['order_by2'];
	if($order_by=='')
	{
		$order_by='lead_id';
	}
	if($order_by2==""){
		$order_by2='DESC';
	}
$_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 * ";
if($_SESSION['role_id']=='4'){ 
$listingsql=" FROM mstr_leads WHERE 1=1 and del_id !='1' and company_id ='".$_SESSION['company_id']."' and lead_status !='0' and assign_to = '".$_SESSION['user_id']."' and assign_tc != '' and assign_tc !='0'";
}else{
//$listingsql=" FROM mstr_leads WHERE 1=1 and del_id !='1' and company_id ='".$_SESSION['company_id']."' and lead_status !='0' and assign_by = '".$_SESSION['user_id']."' or assign_to = '".$_SESSION['user_id']."'";

$listingsql=" FROM mstr_leads WHERE 1=1 and del_id !='1' and company_id ='".$_SESSION['company_id']."' and lead_status !='0'";
}
//$listingsql=" FROM mstr_leads 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 selectAll(source) {
		checkboxes = document.getElementsByName('l_ids[]');
		for(var i in checkboxes)
			checkboxes[i].checked = source.checked;
	}
</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 Leads</h3>
                        <p class="animated fadeInDown">
                          Leads <span class="fa-angle-right fa"></span>Manage Leads
                        </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> Leads List (<?php echo $reccnt;?>)</h3></div>
                  <div class="panel-body">					
					<div class="table-responsive">   
					<form method="post" action="assign_leads.php" name="form_frm">
					<input type="hidden" name="haction">
					<input type="hidden" name="id">
					<div class="clearfix">
								<?php if(in_array("10", $action_menu)){ ?><div class="btn-group">
									<button id="add-new" type="button" class="btn btn-primary" onclick="window.location.href='add_leads_form.php';">
										Add New Lead <i class="fa fa-plus"></i>
									</button>
								</div><?php } ?>
								<?php if(in_array("1", $action_menu)){ ?><div class="btn-group">
									<button id="assign-lead" type="button" class="btn btn-warning" onclick="window.location.href='manage_leads.php';">
										View Unassigned Leads
									</button>
								</div><?php } ?>
								<?php if(in_array("2", $action_menu)){ ?><div class="btn-group">
									<button id="assign-lead" type="button" class="btn btn-success" onclick="window.location.href='assign_sales_leads.php';">
										Forwarded to Sales Team
									</button>
								</div><?php } ?>
								<?php if(in_array("30", $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="dataTbl2" class="table table-striped table-bordered" width="100%" cellspacing="0">
        <thead class="cf">
        <tr>         
                       <!--th class="sorting_disabled">
					   <div class="form-group form-animate-checkbox">
                          <input type="checkbox" class="checkbox" id="selectall" onClick="selectAll(this)">                         
                        </div>
					   </th-->
					    <th>Lead Code</th>
                        <th>Project Name</th>
						<th>User Role</th>			
						<th>Name</th>
						<th>Email</th>
						<th>Mobile</th>
						<th>Phone</th>
						<th>Interested In</th>
						<th>Budget</th>	
						<th>Lead Status</th>
            <?php if(in_array("400", $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)) {				 
		?>
        <tr>
						<!--td>			
						<div class="form-group form-animate-checkbox">
                          <input name="l_ids[]" type="checkbox" value="<?php echo $line['lead_id']?>" class="checkbox">                         
                        </div>
						</td-->
						<td><?php echo $line['lead_code']?></td>
						<td><?php echo $line['project_name']?></td>
						
						<td><?php 
						if($_SESSION['role_id']=='4' || $line['assign_tc'] !='' && $line['assign_tc'] !='0'){						
							echo getUserName2($line['assign_tc']); ?> - <b><?php echo getRoleByUser($line['assign_tc']); 
						}else{
							echo getUserName2($line['assign_to']); ?> - <b><?php echo getRoleByUser($line['assign_to']); 
						}
						?></b></td>            
						<td><?php echo $line['name']?></td>
						<td><?php echo $line['email']?></td>
						<td><?php echo $line['mobile']?></td>
						<td><?php echo $line['phone']?></td>
						<td><?php echo $line['interested']?></td>
						<td><?php echo $line['budget']?></td> 						
						<td><a class="btn <?php echo getLeadBtnStatus($line['lead_status']); ?>"><?php echo getLeadStatus($line['lead_status']); ?></a></td> 
            <?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="leads_history.php?id=<?php echo $line['lead_id']?>" class="tooltips edit-btn" data-placement="top" data-toggle="tooltip" data-original-title="History"><i class="fa fa-history"></i> </a></li><?php } ?>
            <?php if(in_array("2", $action_menu)){ ?><li><a href="edit_leads_form.php?id=<?php echo $line['lead_id']?>" class="tooltips edit-btn" data-placement="top" data-toggle="tooltip" data-original-title="Edit"><i class="fa fa-edit"></i> </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['lead_id']; ?>');"><i class="fa fa-trash-o"></i> Delete</a></li><?php } ?>
            </ul></td>
			<?php } ?>
        </tr>
		
        <?php }  }else {?>
        <tr>
           <td colspan="12" style="margin:0px auto; text-align:center; color:#282828; font-size:14px; font-variant:small-caps; font-weight:bold;">
           Your Leads List is Empty.</td>	
           </tr>
           </p>
        <?php }?>
        </tbody>      
        </table>       
				<div class="col-md-6" style="padding-top:20px;">
                    <span><?php echo $PGobj->showEntries($no); ?></span>
                  </div>
                  <div class="col-md-6">                       
                         <?php echo $PGobj->showPagerContent(); ?>                     
                  </div>	  
            </form>		
                  </div>                
                </div>
              </div>
            </div>  
          </div>
		  
        <!--body wrapper end-->
<?php include('../template/footer.php');?>