<?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='ASC';
	}
	
if($_SESSION['role_id']=='4')
	{
		$lead_status="and lead_status='1' and assign_tc ='' and assign_to='".$_SESSION['user_id']."'";
	}else{
		$lead_status="and lead_status='0'";
	}
	
$_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_leads WHERE 1=1 and company_id ='".$_SESSION['company_id']."' ".$lead_status;
//$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>Unassigned 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("2", $action_menu)){ ?><div class="btn-group">
									<button id="assign-lead" type="button" class="btn btn-primary" onclick="window.location.href='view_leads.php';">
										View Assigned 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 class="table table-striped table-bordered" width="100%" cellspacing="2">
        <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>Source</th>			
						<th>Name</th>
						<th>Email</th>
						<th>Mobile</th>
						<th>Phone</th>
						<th>Interested In</th>
						<th>Budget</th>
            <?php if(in_array("22", $action_menu) || in_array("33", $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 echo $line['source']?></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> 
           
            <?php if(in_array("22", $action_menu) || in_array("33", $action_menu)){ ?><td>
			<ul class="nav nav-tabs">			 
            <?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 } ?>
		<tr>
           <td colspan="12" style="margin:0px auto; text-align:center; color:#282828; font-size:14px; font-variant:small-caps; font-weight:bold;">
							<div class="col-md-2">
								<h5>Assigning the Leads :</h5>
							</div>
		                     <div class="col-md-5">
                                  <select class="form-control" name="assign_lead">
								  <?php
								  if($_SESSION['role_id']=='4'){
									  $role = "role_id IN (4,5) and rep_head='".$_SESSION['user_id']."' or user_id='".$_SESSION['user_id']."'";
								  }else{
									  $role = "role_id IN (2,3,4,5)"; 
								  }
								  $Roleresult= executeQuery("SELECT user_id,name,role_id FROM mstr_user where status='Active' and company_id ='".$_SESSION['company_id']."' and user_type !='0' and $role");
                                                while($row=mysql_fetch_array($Roleresult)) { 
												?>							
												<option value="<?php echo $row['user_id'];?>"><?php echo $row['name'];?> - <?php echo getRoleName($row['role_id']);?></option>													
                                                <?php }?>
                                    
                                  </select>							    	
                              </div>
							<div class="col-md-2">
								<input class="submit btn btn-danger" type="submit" value="Submit">
							</div>                      
		   </td>	
           </tr>
		<?php }else {?>
        <tr>
           <td colspan="100%" 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');?>