Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

Apache

System:

Linux 5.14.0-570.60.1.el9_6.x86_64

PHP Version:

8.1.34

User:

jivandharaoldage

Directory:

/home/jivandharaoldage/public_html/donation/admin

Free Space:

16.7 GB

🔧 Quick Actions

✏️ Editing: report_employee_wise.php

<?php 
error_reporting(0);
session_start();

$utype=$_SESSION['utype']; 
$username=$_SESSION['username'];
$emp_id=$_SESSION['emp_id']; 
$employee_name=$_SESSION['employee_name'];

if(!isset($_SESSION['utype']) || ($_SESSION['utype'] == "") )
{
?>
<script language="javascript">window.location.href="index.php";</script>
<?php 
}
include "config.php";
?>

<!DOCTYPE html>
<html lang="en">

<head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        
        <title>Report Employee Wise</title>
        <link rel="shortcut icon" href="assets/dist/img/favicon.ico" type="image/x-icon">
        <script src="ajax/libs/webfont.js"></script>
        
        
         <link href="assets/dist/css/base.css" rel="stylesheet" type="text/css">
         
        <link href="assets/plugins/jquery.sumoselect/sumoselect.min.css" rel="stylesheet" type="text/css"/>
        <link href="assets/plugins/select2/select2.min.css" rel="stylesheet" type="text/css"/>
        
        <link href="assets/dist/css/component_ui.css" rel="stylesheet" type="text/css"/>
        <link href="assets/dist/css/style.css" rel="stylesheet" type="text/css"/>
    </head>
    <body class="sidebar-mini sidebar-collapse">
        
        
       
        
        
        <div class="wrapper">
            <?php include('header.php');?>
            
            <div class="content-wrapper">
                <div class="content">
                    
                    <div class="content-header">
                        
                        <div class="header-title">
                           
                           
                            <ol class="breadcrumb">
                                <li><a href="dashboard.php"><i class="pe-7s-home"></i> Home</a></li>
                                <li class="active">Report Employee Wise</li>
                            </ol>
                        </div>
                    </div> 
                    <div class="row">
                        
                        <div class="col-sm-12">
                            <div class="panel panel-bd">
                                
                                
                                
                                <div class="panel-body">
                                  
                                    <form method="post">
									
									
										<div class="form-group col-sm-3">
                                        
									
                                            <label for="exampleName">Employee Name</label>
											<select class="form-control basic-single" name="emp_id">
                                             <option value="">Select Employee</option> 
												 <?php $ure1=mysqli_query($conn,"select * from  tbl_employee");
													while($urow1=mysqli_fetch_array($ure1)) {?>
                                                      <option value="<?php echo $urow1['emp_id']; ?>"<?php if($urow['emp_id'] == $urow1['emp_id']) echo 'selected="selected"' ?>><?php echo $urow1['employee_name']; ?></option>
                               						 <?php }?>
												 </select>
                                          
                                            
                                        </div>
										
										<div class="form-group col-sm-2">
										 <label for="exampleName"> Lead Status</label>
										<select  name="lead_status" class="form-control">
										 <option value="">Select Status </option>
										<option value="Prospective">Prospective</option>
										<option value="Interested">Interested</option>
										<option value="Not_Interested">Not_Interested</option>
										<option value="Registered">Register</option>
									
										</select>
                                            
                                        </div>
										
										 <div class="form-group col-sm-3">
                                        
                                            <label for="exampleName">From Date</label>
                                            <input type="date" class="form-control"  id="exampleName"  name="datefrom">
                                            
                                        </div>
										
                                       
										 <div class="form-group col-sm-3">
                                        
                                            <label for="exampleName">TO Date</label>
                                            <input type="date" class="form-control" id="exampleName"  name="dateto" >
                                            
                                        </div>
                                        
									
									
										<div class="form-group col-sm-1">
                                        
                                            <br>
											&nbsp;
                                            <input type="submit" value="Search" name="search" class="btn btn-cap m-r-5">
                                            
                                        </div>
										
									
                                    </form>
									
									<?php
	  if(isset($_POST['search']))
		{ 
		$emp_id=$_REQUEST['emp_id']; 
		$_SESSION['emp_id'] = $emp_id; 
		$emp_id = $_SESSION['emp_id']; 
		
		$lead_status=$_REQUEST['lead_status']; 
		$_SESSION['lead_status'] = $lead_status; 
		$lead_status = $_SESSION['lead_status']; 
          
	//	$ure=mysqli_query($conn,"select * from tbl_customer_mst where emp_id='$emp_id'");		
	//	$sord=mysqli_fetch_array($ure); 
	//	$transport_chrages = $sord['transport_chrages']; 
	//	$discount= $sord['discount']; 
	//	$followup_date= $sord['followup_date'];  
		 
		$datefroms=$_REQUEST['datefrom']; 
		$datefrom=date("Y-m-d", strtotime($datefroms)); 
		$_SESSION['datefrom'] = $datefrom; 
		$datefrom = $_SESSION['datefrom']; 
 
		$datetoss=$_REQUEST['dateto']; 
		$datetos=date("Y-m-d", strtotime($datetoss)); 
		$_SESSION['datetos'] = $datetos; 
		$datetos = $_SESSION['datetos']; 
	 ?>
	 <?php }?>
                                </div>
                            </div>
                        </div>
                        
                        
                        
                        
                    </div>

<?php if($datefrom && $datetos){?>
  
                    <div class="row">
					 <center><?php /*?><a target="_blank" href="print_employeewise_report.php?empid=<?php echo $emp_id; ?>&&lead_status=<?php echo $lead_status; ?>&&datefrom=<?php echo $datefrom; ?>&&datetos=<?php echo $datetos; ?>"><b style="color:#CC0000"><i class="ti-printer"></i>&nbsp;Print Report</b></a>&nbsp;/&nbsp;<?php */?><a  href="report_employeewise.xls"><b style="color:#0066FF"><i class="ti-file"></i>Exel Report</b></a></center>
                          
						<br>
                        <div class="col-sm-12">
						<div class="panel panel-bd" style="margin-bottom: 1px;">
                  <div class="panel-body" style="padding:0px; background-color:#2f7a2e; color: #ffffff">
                    <div class="table-responsive">
                      <table class="table" style="margin-bottom: 2px;">
                         <?php 
                                
								  
							   
								 if($emp_id != '' &&  $datefrom == '1970-01-01' && $datetos == '1970-01-01'){
								 
								$ure1="SELECT *  FROM tbl_lead_inquiry WHERE emp_id='$emp_id' && lead_status='Fresh' order by emp_id desc";
								$exe1=mysqli_query($conn,$ure1);
                 				$no1 = mysql_num_rows($exe1);
								   
								 $ure2="SELECT *  FROM tbl_lead_inquiry WHERE emp_id='$emp_id' && lead_status='Prospective'  order by emp_id desc";
							
								$exe2=mysqli_query($conn,$ure2);
                 				$no2 = mysql_num_rows($exe2);
								
								 $ure3="SELECT *  FROM tbl_lead_inquiry WHERE emp_id='$emp_id' && lead_status='Interested'  order by emp_id desc";
							
								$exe3=mysqli_query($conn,$ure3);
                 				$no3 = mysql_num_rows($exe3);
								
								 $ure4="SELECT *  FROM tbl_lead_inquiry WHERE emp_id='$emp_id' && lead_status='Not_Interested'  order by emp_id desc";
							
								$exe4=mysqli_query($conn,$ure4);
                 				$no4 = mysql_num_rows($exe4);
								
								 $ure5="SELECT *  FROM tbl_lead_inquiry WHERE emp_id='$emp_id' && lead_status='Registered'  order by emp_id desc";
							
								$exe5=mysqli_query($conn,$ure5);
                 				$no5 = mysql_num_rows($exe5);
								
								$ure6="SELECT *  FROM tbl_lead_inquiry WHERE emp_id='$emp_id'  order by emp_id desc";
								$exe6=mysqli_query($conn,$ure6);
                 				$no6 = mysql_num_rows($exe6);	
								
								} elseif($emp_id != '' &&  $datefrom != '1970-01-01' && $datetos != '1970-01-01') {
								
								 $ure1="SELECT *  FROM tbl_lead_inquiry WHERE emp_id='$emp_id' && lead_status='Fresh' AND lead_date between '$datefrom' and '$datetos' order by emp_id desc";
								$exe1=mysqli_query($conn,$ure1);
                 				$no1 = mysql_num_rows($exe1);
								
								  $ure2="SELECT *  FROM tbl_lead_inquiry WHERE emp_id='$emp_id' && lead_status='Prospective' AND lead_date between '$datefrom' and '$datetos' order by emp_id desc";
							
								$exe2=mysqli_query($conn,$ure2);
                 				$no2 = mysql_num_rows($exe2);
								
								 $ure3="SELECT *  FROM tbl_lead_inquiry WHERE emp_id='$emp_id' && lead_status='Interested' AND lead_date between '$datefrom' and '$datetos' order by emp_id desc";
							
								$exe3=mysqli_query($conn,$ure3);
                 				$no3 = mysql_num_rows($exe3);
								
								 $ure4="SELECT *  FROM tbl_lead_inquiry WHERE emp_id='$emp_id' && lead_status='Not_Interested' AND lead_date between '$datefrom' and '$datetos' order by emp_id desc";
							
								$exe4=mysqli_query($conn,$ure4);
                 				$no4 = mysql_num_rows($exe4);
								
								 $ure5="SELECT *  FROM tbl_lead_inquiry WHERE emp_id='$emp_id' && lead_status='Registered' AND lead_date between '$datefrom' and '$datetos' order by emp_id desc";
							
								$exe5=mysqli_query($conn,$ure5);
                 				$no5 = mysql_num_rows($exe5);
								
								} else {
								
								 $ure1="SELECT *  FROM tbl_lead_inquiry WHERE  lead_status='Fresh' AND lead_date between '$datefrom' and '$datetos' order by emp_id desc";
								$exe1=mysqli_query($conn,$ure1);
                 				$no1 = mysql_num_rows($exe1);
								  $ure2="SELECT *  FROM tbl_lead_inquiry WHERE lead_status='Prospective' AND lead_date between '$datefrom' and '$datetos' order by emp_id desc";
							
								$exe2=mysqli_query($conn,$ure2);
                 				$no2 = mysql_num_rows($exe2);
								
								 $ure3="SELECT *  FROM tbl_lead_inquiry WHERE lead_status='Interested' AND lead_date between '$datefrom' and '$datetos' order by emp_id desc";
							
								$exe3=mysqli_query($conn,$ure3);
                 				$no3 = mysql_num_rows($exe3);
								
								 $ure4="SELECT *  FROM tbl_lead_inquiry WHERE  lead_status='Not_Interested' AND lead_date between '$datefrom' and '$datetos' order by emp_id desc";
							
								$exe4=mysqli_query($conn,$ure4);
                 				$no4 = mysql_num_rows($exe4);
								
								 $ure5="SELECT *  FROM tbl_lead_inquiry WHERE  lead_status='Registered' AND lead_date between '$datefrom' and '$datetos' order by emp_id desc";
							
								$exe5=mysqli_query($conn,$ure5);
                 				$no5 = mysql_num_rows($exe5);
								
								$ure6="SELECT *  FROM tbl_lead_inquiry WHERE lead_date between '$datefrom' and '$datetos' order by emp_id desc";
								$exe6=mysqli_query($conn,$ure6);
                 				$no6 = mysql_num_rows($exe6);	
								
								}
								
								
								
								?>
                                           
                                                <tr>
													<td>Total :	<b><?php echo $no6; ?></b></td>
                                                    <td>Pending :	<b><?php echo $no1; ?></b></td>
                                                    <td>Prospective :	<b><?php echo $no2; ?> </b></td>
													<td>Interested :	<b><?php echo $no3; ?></b></td>
                                                   <td>Not Interested :	<b><?php echo $no4; ?></b></td>
												   <td>Registered :	<b><?php echo $no5; ?></b></td>
                                                  
                                                </tr>
                                              
                      </table>
                    </div>
                  </div>
                </div>
                            <div class="panel panel-bd">
                              
                                <div class="panel-body">
                                   
                                    <div class="table-responsive">
									
                                        <table class="table table-bordered">
                                            <thead>
                                                <tr>
                                                   
                                                    <th>Date</th>
													<th>Name</th>   
													<th>Mobile</th>   
													<th>Email</th>    
													<th>Invest Rang</th>
													<th>Invest Time</th>
													<th>Budget</th>
                                                   	<th>Visit</th>
													<th>Followup</th>
												    <th>Referenceby</th>
													<th>Lead quality</th>
													<th> Status</th>           				
													<th> Lead by</th>    
													       
                      								
                                                </tr>
                                            </thead>
                                            <tbody>
											 <?php				
							
								
                            	$n=0;
                           		 if($emp_id == '' && $lead_status == '' && $datefrom != '1970-01-01' && $datetos != '1970-01-01')
 								{
								  $ure="SELECT *  FROM tbl_lead_inquiry where lead_date between '$datefrom' and '$datetos' order by emp_id desc";
								
								   $ures = mysqli_query($conn,$ure);
								   
								   
 								}
								
							    else if($emp_id != '' && $lead_status == '' && $datefrom != '1970-01-01' && $datetos != '1970-01-01')
  								{
								 $ure="SELECT *  FROM tbl_lead_inquiry WHERE emp_id='$emp_id' && lead_date between '$datefrom' and '$datetos' order by emp_id desc";
							
								$ures = mysqli_query($conn,$ure);
  								} 	
								
								else if($emp_id == '' && $lead_status != '' && $datefrom == '1970-01-01' && $datetos == '1970-01-01')
  								{
								 $ure="SELECT *  FROM tbl_lead_inquiry WHERE lead_status='$lead_status'  order by emp_id desc";
							
								$ures = mysqli_query($conn,$ure);
  								} 	
								
								 else if($emp_id != '' && $lead_status == '' && $datefrom == '1970-01-01' && $datetos == '1970-01-01')
  								{
								 $ure="SELECT *  FROM tbl_lead_inquiry WHERE emp_id='$emp_id'  order by emp_id desc";
							
								$ures = mysqli_query($conn,$ure);
  								} 	
								
								  else if($emp_id == '' && $lead_status != '' && $datefrom != '1970-01-01' && $datetos != '1970-01-01')
  								{
								  $ure="SELECT *  FROM tbl_lead_inquiry WHERE lead_status='$lead_status' AND lead_date between '$datefrom' and '$datetos' order by emp_id desc";
							
								$ures = mysqli_query($conn,$ure);
  								} 	
								
								 else if($emp_id != '' && $lead_status != '' && $datefrom == '1970-01-01' && $datetos == '1970-01-01')
  								{
								  $ure="SELECT *  FROM tbl_lead_inquiry WHERE emp_id='$emp_id' && lead_status='$lead_status' order by emp_id desc";
							
								$ures = mysqli_query($conn,$ure);
  								} 	
								
								 else if($emp_id != '' && $lead_status != '' && $datefrom != '1970-01-01' && $datetos != '1970-01-01')
  								{
								 $ure="SELECT *  FROM tbl_lead_inquiry WHERE emp_id='$emp_id' && lead_status='$lead_status' AND lead_status='$lead_status' AND lead_date between '$datefrom' and '$datetos' order by emp_id desc";
							
								$ures = mysqli_query($conn,$ure);
  								} 						 		
								
									 							 					 
								
								while($urow=mysqli_fetch_array($ures))
								 { 
								 	
									
									$n++; 
								?>
                            
                                <tr>
                            
                            
                             <td><?php $date=$urow['lead_date']; echo	$lead_date=date("d-m-Y", strtotime($date)); ?>   </td>
							  <td><?php echo $urow['person_name']; ?></td>
							  <td><?php echo $urow['mobile']; ?></td>
							  <td><?php echo $urow['email']; ?></td>
							  <td><?php echo $urow['requirment']; ?></td>
							  <td><?php echo $urow['investment_time']; ?></td>
							  <td><?php echo $urow['budget']; ?></td>
							  <td><?php echo $urow['meeting_followup']; ?></td>
							  <td><?php echo $urow['update_feedback']; ?></td>
							  <td><?php echo $urow['referenceby']; ?></td>
							 <td><?php echo $urow['lead_quality']; ?></td>
							  <td><?php echo $urow['lead_status']; ?></td>
							  <td><?php echo $urow['employee_name']; ?></td>
							 
							<?php  $total = 1; $total_amount2[] = 1; ?>
							 
                            
							<?php 
							} 
							?>
							
							<tr><td colspan="13">&nbsp;</td></tr>
							<tr>
							 
							 <td align="right" colspan="12"><b>Total Employee Lead </b></td>
							<td>
                            <?php echo $total_amount11 = array_sum($total_amount2);  ?>.00
                            
                            </td>
							
                            </tr>
							
					 
                                              
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
						
                    </div>
					<?php } else { ?>
					
					<?php } ?>
                    
                </div> 
            </div>
            <?php include('footer.php');?>
        </div> 
        
      <script src="assets/plugins/jQuery/jquery-1.12.4.min.js"></script>
        <script src="assets/plugins/jquery-ui-1.12.1/jquery-ui.min.js"></script>
        <script src="assets/bootstrap/js/bootstrap.min.js"></script>
        <script src="assets/plugins/slimScroll/jquery.slimscroll.min.js"></script>
        <script src="assets/plugins/fastclick/fastclick.min.js"></script>
        <script src="assets/plugins/metisMenu/metisMenu.min.js"></script>
        <script src="assets/plugins/lobipanel/lobipanel.min.js"></script>
        
        <script src="assets/plugins/jquery.sumoselect/jquery.sumoselect.min.js"></script>
        <script src="assets/plugins/jquery.sumoselect/sumoselect-active.js"></script>
        
        <script src="assets/plugins/select2/select2.min.js"></script>
        <script src="assets/plugins/select2/select2-active.js"></script>

<script src="assets/dist/js/theme.js"></script>
    </body>

</html>
<?php

require_once("excelwriter.class.php");
	$excel=new ExcelWriter("report_employeewise.xls");
	if($excel==false)	
	echo $excel->error;
	$myArr=array("Month","Date","Name","Mobile","Email","Investment Rang","investment Time","Budget","Visit","Followup","Reference by","Lead Quality","Lead Status","Lead By");
	$excel->writeLine($myArr);

if($emp_id == '' && $lead_status == '' && $datefrom != '1970-01-01' && $datetos != '1970-01-01')
 								{
								  $qry11=mysqli_query($conn,"SELECT *  FROM tbl_lead_inquiry where lead_date between '$datefrom' and '$datetos' order by emp_id desc");
								
								 
								   
								   
 								}
								
							    else if($emp_id != '' && $lead_status == '' && $datefrom != '1970-01-01' && $datetos != '1970-01-01')
  								{
								 $qry11=mysqli_query($conn,"SELECT *  FROM tbl_lead_inquiry WHERE emp_id='$emp_id' && lead_date between '$datefrom' and '$datetos' order by emp_id desc");
							
								
  								} 	
								
								 else if($emp_id != '' && $lead_status == '' && $datefrom == '1970-01-01' && $datetos == '1970-01-01')
  								{
								 $qry11=mysqli_query($conn,"SELECT *  FROM tbl_lead_inquiry WHERE emp_id='$emp_id'  order by emp_id desc");
							
								
  								} 	
								
								  else if($emp_id == '' && $lead_status != '' && $datefrom != '1970-01-01' && $datetos != '1970-01-01')
  								{
								 $qry11=mysqli_query($conn,"SELECT *  FROM tbl_lead_inquiry WHERE lead_status='$lead_status'  AND lead_date between '$datefrom' and '$datetos' order by emp_id desc");
							
								
  								} 	
								
								 else if($emp_id != '' && $lead_status != '' && $datefrom != '1970-01-01' && $datetos != '1970-01-01')
  								{
								 $qry11=mysqli_query($conn,"SELECT *  FROM tbl_lead_inquiry WHERE emp_id='$emp_id' && lead_status='$lead_status' AND lead_status='$lead_status' AND lead_date between '$datefrom' and '$datetos' order by emp_id desc");
							
								
  								} 				
	
	//if($qry11!=false)
//	{
	//$i=1;
	while($res11=mysqli_fetch_array($qry11))
	{	
				
				
	$myArr=array($res11['lead_month'],$res11['lead_date'],$res11['person_name'],$res11['mobile'],$res11['email'],$res11['requirment'],$res11['investment_time'],$res11['budget'],$res11['meeting_followup'],$res11['update_feedback'],$res11['referenceby'],$res11['lead_quality'],$res11['lead_status'],$res11['employee_name']);
	$excel->writeLine($myArr);
	
	//}
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: report_employee_wise.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation