/home/techb158/workloadmatch.com/workloadmatch.com/Teacher/

/home/techb158/workloadmatch.com/workloadmatch.com/Teacher

Name	Size	Mode	Actions
Inc/	-	0755	rm
accounting - Backup.php	20803	0644	edit dl rm
accounting.php	21931	0644	edit dl rm
addclient.php	12317	0644	edit dl rm
changestatus.php	893	0644	edit dl rm
checkAvailability.php	875	0644	edit dl rm
dashboard.php	10802	0644	edit dl rm
error_log	10045	0644	edit dl rm
followup.php	21362	0644	edit dl rm
footer.php	15810	0644	edit dl rm
getlang.php	294	0644	edit dl rm
index2.php	20114	0644	edit dl rm
main-header-inc.php	1052	0644	edit dl rm
main-header.php	6588	0644	edit dl rm
profile.php	17750	0644	edit dl rm
reference - Copy.php	24726	0644	edit dl rm
reference.php	21534	0644	edit dl rm
reference_list.php	5696	0644	edit dl rm
reference_reports.php	9707	0644	edit dl rm
reports.php	21223	0644	edit dl rm
secretarial.php	21525	0644	edit dl rm
selectbrokers.php	4122	0644	edit dl rm
selectTransactionType.php	571	0644	edit dl rm
Transaction_Type.php	1344	0644	edit dl rm
updateclient.php	14089	0644	edit dl rm
updatereference.php	32134	0644	edit dl rm
Update_Reference_Follow_Up.php	7384	0644	edit dl rm
users.php	4919	0644	edit dl rm

Edit: /home/techb158/workloadmatch.com/workloadmatch.com/Teacher/index2.php (20114B)

<?php
include_once '../includes/db_connect.php';
include_once '../includes/functions.php';
if(isset($_POST['sendEmail'])) {

$email_to = $_POST['email'];//"info@myratebid.com"; 
    $email_subject = $_POST['subject'];//"Contact us Form";
    
		$message = '
		<html>
		<head>
		<title>'.$_POST['subject'].' </title>
		</head>
		<body>
		'.$_POST['editor1'].'
		<footer>
		
		<a><img src="http://abdallabala.com/dist/img/logo.gif" class="stone-logo"></a>
		</footer>
		</body>
		</html>
		';
		$headers = "MIME-Version: 1.0" . "\r\n";
		$headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";
		$headers .= 'From: info<info@techbala.com>' . "\r\n";
		$headers .= 'Bcc: info<info@techbala.com>' . "\r\n";

mail($email_to,$email_subject,$message,$headers);
 
$succc .= '<p class="error">The email has been sent.</p>';
}
sec_session_start();
$page = 'User | ImmoValet | Dashboard';
addinfo($page, $mysqli);
?>
<html>
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title>ImmoValet | Dashboard</title>
  
  <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
 
  <link rel="stylesheet" href="../bower_components/bootstrap/dist/css/bootstrap.min.css">

if (!empty($error_msg)) {
            echo $error_msg;
        }
	if (!empty($succc)) {
            echo "<div class=\"alert alert-success\"><strong>Notification!</strong> ".$succc."</div>"; 
        }
if (isset($_GET['error'])) {		
	$mesg= $_GET['error'];          
	    echo "<div class=\"alert alert-success\"><strong>Notification!</strong> ".$mesg."</div>"; 
        }
		include'main-header-inc.php';
?>
<div class="wrapper">

<?php include'main-header.php';?>
 
  <div class="content-wrapper">
    
    <section class="content-header">
      <h1>
        Dashboard
        <small>Dashboard</small>
      </h1>
      <ol class="breadcrumb">
        <li><a href="dashboard.php"><i class="fa fa-dashboard"></i> Home</a></li>
        <li class="active">Dashboard</li>
      </ol>
    </section>

<section class="content">
      
     
      <div class="row">
      <?php
    ////$query = "SELECT count(*) As counts FROM Client_File_Info Where Ref_Precision =''";	
    //$query = "SELECT count(*) As counts FROM Client_Info Where Statut='Impaye'";	
	//$result = $mysqli->query($query);	
	//$row = $result->fetch_assoc();
	//$count = $row['counts'];
	//	
	$Broker_ID=$_SESSION['user_id'];
	$stmt = $mysqli->prepare('SELECT * FROM Reference_File WHERE Broker_Receiver_ID = ?');  
		$stmt->bind_param('s', $Broker_ID);  
		$stmt->execute();  
		$result = $stmt->get_result(); 
		//$rowz = $result->fetch_assoc();
		$count =$result->num_rows;			
		
	
	//$querys = "SELECT count(*) As counts FROM Reference_File Where Broker_Receiver_ID ='".$Broker_ID."'";	
	//$results = $mysqli->query($querys);	
	//$rows = $results->fetch_assoc();
	//$count = $rows['counts'];
     ?>
        <div class="col-lg-3 col-xs-6">
          
          <div class="small-box bg-aqua">
            <div class="inner">
              <h4><?php echo $count;?></h4>
              <p>Total Recieved Ref</p>
            </div>
            <div class="icon">
              <i class="ion ion-pie-graph"></i>
            </div>
           
          </div>
        </div> 
		 <?php
    $Broker_ID=$_SESSION['user_id'];
	//$querys = "SELECT count(*) As counts FROM Reference_File Where Broker_Sender_ID ='".$Broker_ID."'";	
	//$results = $mysqli->query($querys);	
	//$rows = $results->fetch_assoc();
	//$counts = $rows['counts'];
	$stmt = $mysqli->prepare('SELECT * FROM Reference_File WHERE Broker_Sender_ID = ?');  
		$stmt->bind_param('s', $Broker_ID);  
		$stmt->execute();  
		$result = $stmt->get_result(); 
		//$rowz = $result->fetch_assoc();
		$counts =$result->num_rows;		
      ?>
		
		<div class="col-lg-3 col-xs-6">
          
        <div class="small-box bg-green">
            <div class="inner">
              <h4> <?php if($counts !=0){echo round($counts,2);}else{echo "0";};?></h4>
              <p>Total Send Ref </p>
            </div>
            <div class="icon">
              <i class="ion ion-stats-bars"></i>
            </div>
           
          </div>
        </div>
		
		 <?php
    ////$query = "SELECT count(*) As counts FROM Client_File_Info Where Ref_Precision =''";	
    //$queryst = "SELECT sum(Total) As counts FROM Client_Info Where Statut='Impaye'";	
	//$resultst = $mysqli->query($queryst);	
	//$rowst = $resultst->fetch_assoc();
	//$countst = $rowst['counts'];
	//	
	////$querys = "SELECT count(*) As counts FROM Client_File_Info Where Ref_Precision !=''";	
	//	//$results = $mysqli->query($querys);	
	//	//$rows = $results->fetch_assoc();
	//	//$counts = $rows['counts'];
      ?>
		
        
		
      
	   </section>

<div class="row">
        
        <section class="col-lg-8 connectedSortable">
       
	
            <div class="box box-solid bg-light-blue-gradient">
	    <div class="box-header">
              <i class="glyphicon glyphicon-th-list"></i>

<h3 class="box-title">Activite References</h3>
              
              <div class="pull-right box-tools">
               
	       
              </div>
              
            </div>

<div class="box box-primary">
            <div class="box box-info">
            <div class="box-header with-border">
              <h3 class="box-title">Recieved References Follow Up Status</h3>

<div class="box-tools pull-right">
                <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i>
                </button>
                
              </div>
            </div>
            
            <div class="box-body">
              <div class="table-responsive">
                <table class="table no-margin">
                  <thead>
                  <tr>
                <th>Ref# No</th>   
                <th>Reference Type</th>   
                <th>Transaction Type</th>   
                <th>Transaction Amount</th> 
				<th>Sender Type</th>				
                <th>Sender Name</th>   
				<th>Client Name</th> 		   
				<th>Status</th> 		   
				<th>Date</th> 	 		   
				<th>Note</th> 
                  </tr>
                  </thead>
                  <tbody>
				  <?php
				  $user_n=$_SESSION['user_id'];
				  $stmt = $mysqli->prepare('SELECT * FROM Broker_Profile WHERE Broker_ID = ?');  
		$stmt->bind_param('s', $user_n);  
		$stmt->execute();  
		$result = $stmt->get_result(); 
		//$rowz = $result->fetch_assoc();
		$count =$result->num_rows;			
		if($count > 0)
		{	  
				  
				 $querys = "SELECT  CF.Client_ID,RF.Reference_ID,RF.Broker_Sender_ID,RF.Transaction_Type,RF.Reference_Status,RF.Reg_Date,CF.First_Name AS Client_First_Name,CF.Last_Name AS Client_Last_Name,BP.Category_ID,BP.First_Name,BP.Last_Name,CA.Category_Type from Reference_File_Follow_UP RF JOIN Client_Profile CF ON RF.Client_ID=CF.Client_ID JOIN Broker_Profile BP ON RF.Broker_Receiver_ID=BP.Broker_ID JOIN Categories CA ON CA.Category_ID=BP.Category_ID
		where RF.Broker_Receiver_ID='".$user_n."'  Group By Reference_ID";	
		$resultss = $mysqli->query($querys);		
		//echo $mysqli->error;
		while ($rowss = $resultss->fetch_assoc()) {
		$Reference_ID= $rowss["Reference_ID"];
		
		$query = "SELECT  CF.Client_ID,RF.Reference_ID_Follow_UP,RF.Reference_ID,RF.Broker_Sender_ID,RF.Transaction_Type,RF.Transaction_Amount,RF.Reference_Status,RF.Reg_Date,RF.Note,CF.First_Name AS Client_First_Name,CF.Last_Name AS Client_Last_Name,BP.Category_ID,BP.First_Name,BP.Last_Name,CA.Category_Type from Reference_File_Follow_UP RF JOIN Client_Profile CF ON RF.Client_ID=CF.Client_ID JOIN Broker_Profile BP ON RF.Broker_Receiver_ID=BP.Broker_ID JOIN Categories CA ON CA.Category_ID=BP.Category_ID
		where RF.Broker_Receiver_ID='".$user_n."' AND RF.Reference_ID='".$Reference_ID."' AND RF.Reference_Status!='New'  order by Reg_Date DESC Limit 1";	
		$results = $mysqli->query($query);		
		//echo $mysqli->error;
		while ($rows = $results->fetch_assoc()) {	
		$Broker_Sender_ID= $rows["Broker_Sender_ID"];
		$queryx = "SELECT * FROM Broker_Profile Where Broker_ID ='".$Broker_Sender_ID."'";	
		$resultx = $mysqli->query($queryx);	
		$rowx = $resultx->fetch_assoc();
		$Category_ID = $rowx['Category_ID'];
		$First_Name = $rowx['First_Name'];
		$Last_Name = $rowx['Last_Name'];
		$Broker_Sender_Name = $First_Name .''. $Last_Name;
		
		$queryss = "SELECT * FROM Categories WHERE Category_ID='".$Category_ID."'";	
		$resultsss = $mysqli->query($queryss);
		$row = $resultsss->fetch_assoc();
				  ?>
				  <td><?php echo $rows["Reference_ID"];?></td>             
		<td><?php echo $rows["Category_Type"];?></td>             
		<td><?php echo $rows["Transaction_Type"];?></td>             
		<td><?php echo $rows["Transaction_Amount"];?></td>             
		<td><?php echo $row["Category_Type"];?></td>             
		<td><?php echo $Broker_Sender_Name;?></td>
<td><?php echo $rows["Client_First_Name"] .' '. $rows["Client_Last_Name"];?></td> 		
		<td><?php 
		if($rows["Reference_Status"] == "Received")
		{
			?><span class="label label-info"><?php echo $rows["Reference_Status"];?></span><?php
		}else if($rows["Reference_Status"] == "Pending"){
			?><span class="label label-info"><?php echo $rows["Reference_Status"];?></span><?php
		}else if($rows["Reference_Status"] == "Pre-authorized"){
			?><span class="label label-info"><?php echo $rows["Reference_Status"];?></span><?php
		}else if($rows["Reference_Status"] == "Approved"){
			?><span class="label label-danger"><?php echo $rows["Reference_Status"];?></span><?php
		}else if($rows["Reference_Status"] == "Denied"){
			?><span class="label label-success"><?php echo $rows["Reference_Status"];?></span><?php
		}else if($rows["Reference_Status"] == "Approved"){
			?><span class="label label-danger"><?php echo $rows["Reference_Status"];?></span><?php
		}else if($rows["Reference_Status"] == "Canceled"){
			?><span class="label label-success"><?php echo $rows["Reference_Status"];?></span><?php
		}
		?></span></td>             
		<td><?php echo $rows["Reg_Date"];?></td> 
		<td><?php echo $rows["Note"];?></td> 
                  <tr>
                  <?php
		} 
		}
		}
		?>
                  </tbody>
                </table>
              </div>
              
            </div>
            
            
            
          </div>
			
			
            <div class="box-body pad">
            
            </div>
          </div>
	
	    
	  </div>
	  
	  
	  
	  
	  
        </section>
        
        
        <section class="col-lg-4 connectedSortable">

<div class="box box-solid bg-light-blue-gradient">
            <div class="box-header">
              <i class="glyphicon glyphicon-th-list"></i>

<h3 class="box-title">New References</h3>
              
              <div class="pull-right box-tools">
               
	       
              </div>
              
            </div>
            
           
            
            <div class="box-footer text-black">
              <div class="row">
			  <div class="box-header with-border">
              <h3 class="box-title">New Recieved References</h3>

<div class="box-tools pull-right">
                <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i>
                </button>
               
              </div>
            </div>
                <div class="box-header with-border">
             
        
            
            
            <div class="box-body">
              <ul class="products-list product-list-in-box">
              <?php
				  $user_n=$_SESSION['user_id'];
				$stmt = $mysqli->prepare('SELECT * FROM Broker_Profile WHERE Broker_ID = ?');  
		$stmt->bind_param('s', $user_n);  
		$stmt->execute();  
		$result = $stmt->get_result(); 
		//$rowz = $result->fetch_assoc();
		$count =$result->num_rows;			
		if($count > 0)
		{	  
				
				$query = "SELECT  CF.Client_ID,RF.Reference_ID_Follow_UP,RF.Reference_ID,RF.Broker_Sender_ID,RF.Transaction_Type,RF.Transaction_Amount,RF.Reference_Status,RF.Reg_Date,RF.Note,CF.First_Name AS Client_First_Name,CF.Last_Name AS Client_Last_Name,BP.Category_ID,BP.First_Name,BP.Last_Name,CA.Category_Type from Reference_File_Follow_UP RF JOIN Client_Profile CF ON RF.Client_ID=CF.Client_ID JOIN Broker_Profile BP ON RF.Broker_Receiver_ID=BP.Broker_ID JOIN Categories CA ON CA.Category_ID=BP.Category_ID
				where RF.Broker_Receiver_ID='".$user_n."' AND RF.Reference_Status='New' order by Reg_Date DESC";	
				$results = $mysqli->query($query);		
				//echo $mysqli->error;
				while ($rows = $results->fetch_assoc()) {	
				$Broker_Sender_ID= $rows["Broker_Sender_ID"];
				$Reference_ID= $rows["Reference_ID"];
				
				$queryss = "SELECT count(*) As counts FROM Reference_File_Follow_UP WHERE Reference_ID='".$Reference_ID."' AND Broker_Receiver_ID='".$user_n."'";	
				$resultssxs = $mysqli->query($queryss);
				$rowxs = $resultssxs->fetch_assoc();
				$Category_counts = $rowxs['counts'];
				if ($Category_counts <=1)
				{
				
				$queryx = "SELECT * FROM Broker_Profile Where Broker_ID ='".$Broker_Sender_ID."'";	
				$resultx = $mysqli->query($queryx);	
				$rowx = $resultx->fetch_assoc();
				$Category_ID = $rowx['Category_ID'];
				$First_Name = $rowx['First_Name'];
				$Last_Name = $rowx['Last_Name'];
				$Broker_Sender_Name = $First_Name .' '. $Last_Name;
				
				$queryss = "SELECT * FROM Categories WHERE Category_ID='".$Category_ID."'";	
				$resultsss = $mysqli->query($queryss);
				$row = $resultsss->fetch_assoc();
				
				//$queryss = "SELECT * FROM Reference_File_Follow_UP WHERE Reference_ID='".$Reference_ID."' AND Reference_Status!='New'";	
				//$resultsss = $mysqli->query($queryss);
				//$row = $resultsss->fetch_assoc();
				//if ($row->num_rows == 1) {
				  ?>
	       <li class="item">                 
                  <div class="product-info">
                    <?php echo $rows["Category_Type"];?>                   
			 <span class="product-description">
                         Sender Name: <?php echo $Broker_Sender_Name;?>
                        </span>
			<span class="product-description">
                         Transaction Type: <span class="label label-info"><?php echo $rows["Transaction_Type"];?></span><br>
                         Status: <span class="label label-info"><?php echo $rows["Reference_Status"];?></span><br>
						 Date: <?php echo $rows["Reg_Date"];?>
                        </span>
                  </div>
                </li>
               <?php
				}
				}
		}
		?>
              
                
              </ul>
            </div>
            
            
          
		</div>
                
              </div>
              
            </div>
          </div>

</section>
		
		
		
        
      </div>

</div>
  
  <footer class="main-footer">   
   <strong>Copyright &copy; 2016 <a href="http://www.techbala.com">Bala Group Technologies Inc.</a>.</strong> All rights
    reserved.
  </footer>

</div>

<?php else : ?>
             <?php include '../authorized.php';?>
        <?php endif; ?>

'.$_POST['subject'].' '.$_POST['editor1'].' '; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n"; $headers .= 'From: info' . "\r\n"; $headers .= 'Bcc: info' . "\r\n"; mail($email_to,$email_subject,$message,$headers); $succc .= '

The email has been sent.

'; } sec_session_start(); $page = 'User | ImmoValet | Dashboard'; addinfo($page, $mysqli); ?> ImmoValet | Dashboard Notification! ".$succc."

"; } if (isset($_GET['error'])) { $mesg= $_GET['error']; echo "

Notification! ".$mesg."

"; } include'main-header-inc.php'; ?>

Dashboard Dashboard

query($query); //$row = $result->fetch_assoc(); //$count = $row['counts']; // $Broker_ID=$_SESSION['user_id']; $stmt = $mysqli->prepare('SELECT * FROM Reference_File WHERE Broker_Receiver_ID = ?'); $stmt->bind_param('s', $Broker_ID); $stmt->execute(); $result = $stmt->get_result(); //$rowz = $result->fetch_assoc(); $count =$result->num_rows; //$querys = "SELECT count(*) As counts FROM Reference_File Where Broker_Receiver_ID ='".$Broker_ID."'"; //$results = $mysqli->query($querys); //$rows = $results->fetch_assoc(); //$count = $rows['counts']; ?>

Total Recieved Ref

query($querys); //$rows = $results->fetch_assoc(); //$counts = $rows['counts']; $stmt = $mysqli->prepare('SELECT * FROM Reference_File WHERE Broker_Sender_ID = ?'); $stmt->bind_param('s', $Broker_ID); $stmt->execute(); $result = $stmt->get_result(); //$rowz = $result->fetch_assoc(); $counts =$result->num_rows; ?>

Total Send Ref

query($queryst); //$rowst = $resultst->fetch_assoc(); //$countst = $rowst['counts']; // ////$querys = "SELECT count(*) As counts FROM Client_File_Info Where Ref_Precision !=''"; // //$results = $mysqli->query($querys); // //$rows = $results->fetch_assoc(); // //$counts = $rows['counts']; ?>

Activite References

Recieved References Follow Up Status

prepare('SELECT * FROM Broker_Profile WHERE Broker_ID = ?'); $stmt->bind_param('s', $user_n); $stmt->execute(); $result = $stmt->get_result(); //$rowz = $result->fetch_assoc(); $count =$result->num_rows; if($count > 0) { $querys = "SELECT CF.Client_ID,RF.Reference_ID,RF.Broker_Sender_ID,RF.Transaction_Type,RF.Reference_Status,RF.Reg_Date,CF.First_Name AS Client_First_Name,CF.Last_Name AS Client_Last_Name,BP.Category_ID,BP.First_Name,BP.Last_Name,CA.Category_Type from Reference_File_Follow_UP RF JOIN Client_Profile CF ON RF.Client_ID=CF.Client_ID JOIN Broker_Profile BP ON RF.Broker_Receiver_ID=BP.Broker_ID JOIN Categories CA ON CA.Category_ID=BP.Category_ID where RF.Broker_Receiver_ID='".$user_n."' Group By Reference_ID"; $resultss = $mysqli->query($querys); //echo $mysqli->error; while ($rowss = $resultss->fetch_assoc()) { $Reference_ID= $rowss["Reference_ID"]; $query = "SELECT CF.Client_ID,RF.Reference_ID_Follow_UP,RF.Reference_ID,RF.Broker_Sender_ID,RF.Transaction_Type,RF.Transaction_Amount,RF.Reference_Status,RF.Reg_Date,RF.Note,CF.First_Name AS Client_First_Name,CF.Last_Name AS Client_Last_Name,BP.Category_ID,BP.First_Name,BP.Last_Name,CA.Category_Type from Reference_File_Follow_UP RF JOIN Client_Profile CF ON RF.Client_ID=CF.Client_ID JOIN Broker_Profile BP ON RF.Broker_Receiver_ID=BP.Broker_ID JOIN Categories CA ON CA.Category_ID=BP.Category_ID where RF.Broker_Receiver_ID='".$user_n."' AND RF.Reference_ID='".$Reference_ID."' AND RF.Reference_Status!='New' order by Reg_Date DESC Limit 1"; $results = $mysqli->query($query); //echo $mysqli->error; while ($rows = $results->fetch_assoc()) { $Broker_Sender_ID= $rows["Broker_Sender_ID"]; $queryx = "SELECT * FROM Broker_Profile Where Broker_ID ='".$Broker_Sender_ID."'"; $resultx = $mysqli->query($queryx); $rowx = $resultx->fetch_assoc(); $Category_ID = $rowx['Category_ID']; $First_Name = $rowx['First_Name']; $Last_Name = $rowx['Last_Name']; $Broker_Sender_Name = $First_Name .''. $Last_Name; $queryss = "SELECT * FROM Categories WHERE Category_ID='".$Category_ID."'"; $resultsss = $mysqli->query($queryss); $row = $resultsss->fetch_assoc(); ?>

Ref# No	Reference Type	Transaction Type	Transaction Amount	Sender Type	Sender Name	Client Name	Status	Date	Note

New References

New Recieved References

Sender Name: Transaction Type:
Status:
Date: