/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/reports.php (21223B)

<?php
include_once '../includes/db_connect.php';
include_once '../includes/functions.php';
//include_once 'Inc/AddLander.php';
sec_session_start();
?>
<!DOCTYPE html>
<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="../bootstrap/css/bootstrap.min.css">
  
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.5.0/css/font-awesome.min.css">
  
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/ionicons/2.0.1/css/ionicons.min.css">
  
  <link rel="stylesheet" href="../plugins/daterangepicker/daterangepicker-bs3.css">
  
  <link rel="stylesheet" href="../plugins/datepicker/datepicker3.css">
  
  <link rel="stylesheet" href="../plugins/iCheck/all.css">
  
  <link rel="stylesheet" href="../plugins/colorpicker/bootstrap-colorpicker.min.css">
  
  <link rel="stylesheet" href="../plugins/timepicker/bootstrap-timepicker.min.css">
  
  <link rel="stylesheet" href="../plugins/select2/select2.min.css">
  
  <link rel="stylesheet" href="../dist/css/AdminLTE.min.css">
  
 <link rel="stylesheet" href="../dist/css/skins/skin-black-light.min.css">
  
    
  <link rel="stylesheet" href="../plugins/datatables/dataTables.bootstrap.css">
  
  
  
  
  <style>
    .example-modal .modal {
      position: relative;
      top: auto;
      bottom: auto;
      right: auto;
      left: auto;
      display: block;
      z-index: 1;
    }

.example-modal .modal {
      background: transparent !important;
    }
  </style>
<script type="text/javascript">
  function createField(subId)
  {
   //  alert(subId);
    var ids = subId;  
 var idAll = ids;
var parts = idAll.split(/\s*,\s*/);

document.getElementById("Lander_ID_Update").value = parts[0];   
   document.getElementById("Lander_Name_Update").value = parts[1];
   document.getElementById("datepickerm").value = parts[2];
   //document.getElementById("datepickerm").value = date('Y-m-d', strtotime(parts[4]));
   document.getElementById("Note_Update").value = parts[3];
 
  }
</script>
</head>
<body class="hold-transition skin-black-light sidebar-mini">
<?php if (login_check($mysqli) == true) : ?>
<?php

if(isset($_POST["submitsr"]) && $_POST["submitsr"]!="") {
	//$Manager_name = $_SESSION['user_id'];	
	//$Lander_ID = $_POST["Lander_ID_Update"];	
	//$Lander_Name_Update = $_POST["Lander_Name_Update"];
	//$Note = $_POST["Note_Update"];
	//$datepicker = $_POST['datepickerm'];
	//$Date_Time = date("Y-m-d", strtotime($datepicker));	
	////$Date_Time = date("m/d/Y", strtotime($datepicker));
	//
	//$datetime =date("Y/m/d") . ' ' . date('H:i:s') ;
	////$error_msg .= $Insurance_ID .' '. $Broker_ID_Update .' '. $Date_Time .' '. $Equfax_Fees_Update .' '. $Note;
	////if (empty($error_msg)) {
	//if (!$mysqli->query("UPDATE Lander SET lander_name='$Lander_Name_Update', Date_Time ='$Date_Time', Note='$Note', Broker_ID_Update='$Manager_name', Register_Date='$datetime' WHERE ID_Lander ='$Lander_ID'")) {
	//	
	//	echo "<div class=\"alert alert-success\"><strong>Notification!</strong> Lander info update failure!</div>"; 
	//	}else{  	
	//echo "<div class=\"alert alert-success\"><strong>Notification!</strong>Lander info successfully updated!</div>"; 
	//	}
	//////}
}
 if (!empty($error_msg)) {
            echo $error_msg;
        }
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>
        Broker Reports
      </h1>
      <ol class="breadcrumb">
        <li><a href="index.php"><i class="fa fa-dashboard"></i> Home</a></li>        
        <li class="active"> Broker Reports</li>
      </ol>
    </section>

<section class="content">

<div class="row">
        	
        
        <div class="col-md-10">
          <div class="nav-tabs-custom">            
            <div class="tab-content">
              <div class="active tab-pane" id="activity">
        
          
            
            <div class="box-body">
<div class="row">
        <div class="col-xs-15">
         
<h3 class="box-title"> Select User (Client)</h3> 	
 <div class="col-md-3">   	
		<select class="form-control" id="User_Name" name="User_Name" style="width: 100%;" onchange="this.form.submit();">
		<option value="" selected="selected">Select (Client)</option>
		<?php 		
		$user_n=$_SESSION['user_id'];			
		//$query = "SELECT DISTINCT ID,First_Name,Last_name from Users order by First_Name";	
		//$result = $mysqli->query($query);	
		//while($Client_Name = $result->fetch_assoc())
		//{
		//echo "<option ". (($_POST['User_Name'] == $Client_Name["ID"]) ? 'selected ' : '') ."value=\"".$User_Name["ID"]."\">".$User_Name["First_Name"]." ".$User_Name["Last_Name"]."</option>";
		//}
	
		?>	
		</select>
</div>
<div class="col-md-3">  
<div class="form-group">
                    <label for="inputName" class="col-sm-2 control-label">From</label>
                    <div class="col-sm-10">
                     <div class="input-group date">
                  <div class="input-group-addon">
                    <i class="fa fa-calendar"></i>
                  </div>
		   <input type="text" class="form-control pull-right" id="datepicker" name="datepicker" placeholder="From">              
                </div>
                    </div>
                  </div>
</div>
<div class="col-md-3">  
<div class="form-group">
                    <label for="inputName" class="col-sm-2 control-label">To</label>
                    <div class="col-sm-10">
                     <div class="input-group date">
                  <div class="input-group-addon">
                    <i class="fa fa-calendar"></i>
                  </div>
		   <input type="text" class="form-control pull-right" id="datepickerm" name="datepickerm" placeholder="To">              
                </div>
                    </div>
                  </div>
</div>
<div class="col-md-3">  
<input type="submit"  name="submit" value="Get Report" class="btn btn-danger"> 
</div>
</div>
</div>
</div>
		
	     </div>
	     </div>

</div>
            
          </div>
		  <div class="col-md-10">
		  
        
        
        
            
            <div class="tab-content">
             
             <div class="box box-primary">
            <div class="box-header with-border">
              <h3 class="box-title">Reçu Rapports Sommaires</h3>
            </div>
	     
	 
	              	
            
            <div class="box-body">
	      <div class="row">
        <div class="col-xs-12">
          <div class="box">

<div class="box-body table-responsive no-padding">
             <table id="example1" class="table table-bordered table-striped">
                <thead>
                <tr>	
		<th>Total Fichier </th>	               
                  <th>Type de courtier</th>
                  <th>Nom du courtier</th> 
		<th>Détaillés</th>		  
                </tr>
                </thead>
                <tbody>
		<?php
		//$brokerid =$_SESSION['ID'];		
		//$Numbers_Broker_Type[0] = "Courtier immobilier";
		//$Numbers_Broker_Type[1] = "Inspecteur";
		//$Numbers_Broker_Type[2] = "Courtier Assurance";
		//$Numbers_Broker_Type[3] = "Courtier Assurance generales";		
		//$Numbers_Broker_Type[4] = "Planificateur financier";
		//$Numbers_Broker_Type[5] = "Notaire";
		//$Numbers_Broker_Type[6] = "Courtier Commercial";
		//foreach( $Numbers_Broker_Type as $value ){			
		//if($value == "Courtier Commercial")
		//{
		//$RefernceType= "U_C_M_B_info";
		//$db="C_M_B_To_M_B";
		//$To_ID="ID_C_M_Broker";
		//$To_Username="C_M_B_Username";
		//}else if($value == "Courtier immobilier")
		//{
		//$RefernceType= "U_R_E_B_info";
		//$db="R_E_B_To_M_B";
		//$To_ID="ID_R_E_Broker";
		//$To_Username="R_E_B_Username";
		//}else if($value == "Inspecteur")
		//{
		//$RefernceType= "U_Ins_info";
		//$db="Ins_To_M_B";
		//$To_ID="ID_Ins_Broker";
		//$To_Username="Ins_B_Username";
		//}else if($value == "Courtier Assurance")
		//{
		//$RefernceType= "U_I_B_info";
		//$db="I_B_To_M_B";
		//$To_ID="ID_I_Broker";
		//$To_Username="I_B_Username";
		//}else if($value == "Courtier Assurance generales")
		//{
		//$RefernceType= "U_G_I_B_info";
		//$db="G_I_B_To_M_B";
		//$To_ID="ID_G_I_Broker";
		//$To_Username="G_I_B_Username";
		//}else if($value == "Planificateur financier")
		//{
		//$RefernceType= "U_F_P_info";
		//$db="F_P_To_M_B";
		//$To_ID="ID_F_P_Broker";
		//$To_Username="F_P_B_Username";
		//}else if($value == "Notaire")
		//{
		//$RefernceType= "U_Not_info";
		//$db="Not_To_M_B";
		//$To_ID="ID_Not_Broker";
		//$To_Username="Not_B_Username";
		//}
		//
		//$results = mysql_query("SELECT * FROM $db where ID_M_Broker='".$brokerid."' group by $To_Username"); 	 
		//while($MBroker=mysql_fetch_array($results))
		//{
		//$M_B_ID = $MBroker[$To_ID]; 
		//$Inforesult = mysql_query("SELECT * FROM $RefernceType where ID='".$M_B_ID."'");
		//$R_E_B =mysql_fetch_array($Inforesult);
		//$Broker_User_Name = $R_E_B['Username'];
		//$First_Name = $R_E_B['Fullname'];
		//$Last_Name = $R_E_B['Familyname'];
		//$BrokerName =$First_Name .' '. $Last_Name;		
		//$result = mysql_query("SELECT COUNT(*) as total FROM $db where ID_M_Broker='".$brokerid."' and $To_ID='".$M_B_ID."'"); 		
		//$MBrokerCount=mysql_fetch_assoc($result);		
		?>
		
                <tr>
                  <td><?php echo $MBrokerCount["total"]; ?></td>                 
                  <td><?php echo $value; ?></td>                  
                  <td><?php echo $BrokerName; ?></td>  
                  <td><a href="./detailsreports.php?var=<?php $tag=","; echo $M_B_ID; echo $tag; echo $value;?>">Détaillés</a></td>  
                
                </tr>
		
		<?php		
		//}
		//}
		?>	      
                </tbody>
                <tfoot>
                <tr>
                 <th>Total Fichier </th>               
                  <th>Type de courtier</th>
                  <th>Nom du courtier</th>                
                  <th>Détaillés</th>                
                </tr>
                </tfoot>
              </table>
            </div>
            
          </div>
          
        </div>
      </div>
	      </div>
	     </div>

</div>
            
         
        
     
          </div> 
		  <div class="col-md-10">
		   
        
        
       
            
            <div class="tab-content">
             
             <div class="box box-primary">
            <div class="box-header with-border">
              <h3 class="box-title">Envoyé Rapports Sommaires</h3>
            </div>
	     
	 
	              	
            
            <div class="box-body">
	      <div class="row">
        <div class="col-xs-12">
          <div class="box">

<div class="box-body table-responsive no-padding">
             <table id="example3" class="table table-bordered table-striped">
                <thead>
                <tr>	
		<th>Total Fichier </th>	               
                  <th>Type de courtier</th>
                  <th>Nom du courtier</th> 
		<th>Détaillés</th> 		  
                </tr>
                </thead>
                <tbody>
		<?php
		//$brokerid =$_SESSION['ID'];		
		//$Numbers_Broker_Type[0] = "Courtier immobilier";
		//$Numbers_Broker_Type[1] = "Inspecteur";
		//$Numbers_Broker_Type[2] = "Courtier Assurance";
		//$Numbers_Broker_Type[3] = "Courtier Assurance generales";		
		//$Numbers_Broker_Type[4] = "Planificateur financier";
		//$Numbers_Broker_Type[5] = "Notaire";
		//$Numbers_Broker_Type[6] = "Courtier Commercial";
		//foreach( $Numbers_Broker_Type as $value ){			
		//if($value == "Courtier Commercial")
		//{
		//$RefernceType= "U_C_M_B_info";
		//$db="M_B_To_C_M_B";
		//$To_ID="ID_C_M_Broker";
		//$To_Username="C_M_B_Username";
		//}else if($value == "Courtier immobilier")
		//{
		//$RefernceType= "U_R_E_B_info";
		//$db="M_B_To_R_E_B";
		//$To_ID="ID_R_E_Broker";
		//$To_Username="R_E_B_Username";
		//}else if($value == "Inspecteur")
		//{
		//$RefernceType= "U_Ins_info";
		//$db="M_B_To_Ins";
		//$To_ID="ID_Ins_Broker";
		//$To_Username="Ins_B_Username";
		//}else if($value == "Courtier Assurance")
		//{
		//$RefernceType= "U_I_B_info";
		//$db="M_B_To_I_B";
		//$To_ID="ID_I_Broker";
		//$To_Username="I_B_Username";
		//}else if($value == "Courtier Assurance generales")
		//{
		//$RefernceType= "U_G_I_B_info";
		//$db="M_B_To_G_I_B";
		//$To_ID="ID_G_I_Broker";
		//$To_Username="G_I_B_Username";
		//}else if($value == "Planificateur financier")
		//{
		//$RefernceType= "U_F_P_info";
		//$db="M_B_To_F_P";
		//$To_ID="ID_F_P_Broker";
		//$To_Username="F_P_B_Username";
		//}else if($value == "Notaire")
		//{
		//$RefernceType= "U_Not_info";
		//$db="M_B_To_Not";
		//$To_ID="ID_Not_Broker";
		//$To_Username="Not_B_Username";
		//}
		//
		//$results = mysql_query("SELECT * FROM $db where ID_M_Broker='".$brokerid."' group by $To_Username"); 	 
		//while($MBroker=mysql_fetch_array($results))
		//{
		//$M_B_ID = $MBroker[$To_ID]; 
		//$Inforesult = mysql_query("SELECT * FROM $RefernceType where ID='".$M_B_ID."'");
		//$R_E_B =mysql_fetch_array($Inforesult);
		//$Broker_User_Name = $R_E_B['Username'];
		//$First_Name = $R_E_B['Fullname'];
		//$Last_Name = $R_E_B['Familyname'];
		//$BrokerName =$First_Name .' '. $Last_Name;		
		//$result = mysql_query("SELECT COUNT(*) as total FROM $db where ID_M_Broker='".$brokerid."' and $To_ID='".$M_B_ID."'"); 		
		//$MBrokerCount=mysql_fetch_assoc($result);		
		?>
                <tr>
                  <td><?php echo $MBrokerCount["total"]; ?></td>                 
                  <td><?php echo $value; ?></td>                  
                  <td><?php echo $BrokerName; ?></td>  
		   <td><a href="./detailsreports.php?var=<?php $tag=","; echo $M_B_ID; echo $tag; echo $value;?>">Détaillés</a></td>  
                </tr>
		<?php		
		//}
		//}
		?>	      
                </tbody>
                <tfoot>
                <tr>
                 <th>Total Fichier </th>               
                  <th>Type de courtier</th>
                  <th>Nom du courtier</th>  
 <th>Détaillés</th> 		  
                </tr>
                </tfoot>
              </table>
            </div>
            
          </div>
          
        </div>
      </div>
	      </div>
	     </div>

</div>
            
         
        
      
          </div>
          
        </div>
        
      </div>

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

<script src="../plugins/jQuery/jQuery-2.2.0.min.js"></script>

<script src="../bootstrap/js/bootstrap.min.js"></script>

<script src="../plugins/select2/select2.full.min.js"></script>

<script src="../plugins/input-mask/jquery.inputmask.js"></script>
<script src="../plugins/input-mask/jquery.inputmask.date.extensions.js"></script>
<script src="../plugins/input-mask/jquery.inputmask.extensions.js"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.11.2/moment.min.js"></script>
<script src="../plugins/daterangepicker/daterangepicker.js"></script>

<script src="../plugins/datepicker/bootstrap-datepicker.js"></script>

<script src="../plugins/colorpicker/bootstrap-colorpicker.min.js"></script>

<script src="../plugins/timepicker/bootstrap-timepicker.min.js"></script>

<script src="../plugins/slimScroll/jquery.slimscroll.min.js"></script>

<script src="../plugins/iCheck/icheck.min.js"></script>

<script src="../plugins/fastclick/fastclick.js"></script>

<script src="../dist/js/app.min.js"></script>

<script src="../dist/js/demo.js"></script>

<script src="../plugins/datatables/jquery.dataTables.min.js"></script>
<script src="../plugins/datatables/dataTables.bootstrap.min.js"></script>

<script>
  $(function () {
    $("#example1").DataTable();
    $("#example3").DataTable();
    $('#example2').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false
    });
  });
</script>
<script>
  $(function () {
    //Initialize Select2 Elements
    $(".select2").select2();

//Datemask dd/mm/yyyy
    $("#datemask").inputmask("dd/mm/yyyy", {"placeholder": "dd/mm/yyyy"});
    //Datemask2 mm/dd/yyyy
    $("#datemask2").inputmask("mm/dd/yyyy", {"placeholder": "mm/dd/yyyy"});
    //Money Euro
    $("[data-mask]").inputmask();

//Date range picker
    $('#reservation').daterangepicker();
    //Date range picker with time picker
    $('#reservationtime').daterangepicker({timePicker: true, timePickerIncrement: 30, format: 'MM/DD/YYYY h:mm A'});
    //Date range as a button
    $('#daterange-btn').daterangepicker(
        {
          ranges: {
            'Today': [moment(), moment()],
            'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
            'Last 7 Days': [moment().subtract(6, 'days'), moment()],
            'Last 30 Days': [moment().subtract(29, 'days'), moment()],
            'This Month': [moment().startOf('month'), moment().endOf('month')],
            'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
          },
          startDate: moment().subtract(29, 'days'),
          endDate: moment()
        },
        function (start, end) {
          $('#daterange-btn span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));
        }
    );

//Date picker
    $('#datepicker').datepicker({
      autoclose: true
    });
 //Date picker
    $('#datepickerm').datepicker({
      autoclose: true
    });

//iCheck for checkbox and radio inputs
    $('input[type="checkbox"].minimal, input[type="radio"].minimal').iCheck({
      checkboxClass: 'icheckbox_minimal-blue',
      radioClass: 'iradio_minimal-blue'
    });
    //Red color scheme for iCheck
    $('input[type="checkbox"].minimal-red, input[type="radio"].minimal-red').iCheck({
      checkboxClass: 'icheckbox_minimal-red',
      radioClass: 'iradio_minimal-red'
    });
    //Flat red color scheme for iCheck
    $('input[type="checkbox"].flat-red, input[type="radio"].flat-red').iCheck({
      checkboxClass: 'icheckbox_flat-green',
      radioClass: 'iradio_flat-green'
    });

//Colorpicker
    $(".my-colorpicker1").colorpicker();
    //color picker with addon
    $(".my-colorpicker2").colorpicker();

//Timepicker
    $(".timepicker").timepicker({
      showInputs: false
    });
  });
</script>

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

</body>
</html>

ImmoValet | Dashboard query("UPDATE Lander SET lander_name='$Lander_Name_Update', Date_Time ='$Date_Time', Note='$Note', Broker_ID_Update='$Manager_name', Register_Date='$datetime' WHERE ID_Lander ='$Lander_ID'")) { // // echo "

Notification! Lander info update failure!

"; // }else{ //echo "

Notification!Lander info successfully updated!

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

Notification! ".$mesg."

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

Broker Reports

Select User (Client)

From

Reçu Rapports Sommaires

Total Fichier	Type de courtier	Nom du courtier	Détaillés
			">Détaillés
Total Fichier	Type de courtier	Nom du courtier	Détaillés

Envoyé Rapports Sommaires

Total Fichier	Type de courtier	Nom du courtier	Détaillés
			">Détaillés
Total Fichier	Type de courtier	Nom du courtier	Détaillés