FM / Teacher

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

/home/techb158/workloadmatch.com/workloadmatch.com/BackUp/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/BackUp/Teacher/updatereference.php (32134B)

<?php
include_once '../includes/db_connect.php';
include_once '../includes/functions.php';
include_once 'Inc/Update_Reference.php';
// CSRF Protection
	require '../includes/CSRF_Protect.php';
	$csrf = new CSRF_Protect();
sec_session_start();
$page = 'User | ImmoValet | Update Reference';
addinfo($page, $mysqli);
?>
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
   <title>ImmoValet | Update Reference</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*/);

if (!empty($error_msg)) {
            echo $error_msg;
        }

include'main-header-inc.php';
?>
<div class="wrapper">

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

<section class="content">

<div class="row">
        	
        
        <div class="col-md-12">
          <div class="nav-tabs-custom">      	  
            <div class="tab-content">
              <div class="active tab-pane" id="activity">
        
          
            
          <?php
		  if (isset($_GET["var"])) {
			
			//echo $decrypted_txt;
			$str =$_GET['var'];  
			$_GET["var"] = 0;
	// 
	$page = antiSQLInjection($_GET["var"]);
	if($page == ""){
		$page = "1";
	}
	$myArray = explode('-', $str);
	$decrypted_Cleint_ID = encrypt_decrypt('decrypt', $myArray[0]);
	$decrypted_Reference_ID = encrypt_decrypt('decrypt', $myArray[1]);
	//$decrypted_Reference_ID = $myArray[1];
			
	    if(isset($_POST["Client_Name"]) && $_POST["Client_Name"]!="") {
		$Client_Nam=$_POST["Client_Name"];		
		//$stmt = $mysqli->prepare('SELECT * FROM Broker_Profile WHERE Broker_ID = ?');  
		//$stmt->bind_param('s', $user_n);  
		//$stmt->execute();  
		//$result = $stmt->get_result(); 		
		//$count =$result->num_rows;		
		//$row = $result->fetch_assoc();	
		
		$stmt = $mysqli->prepare('SELECT * FROM Client_Profile WHERE Client_ID = ? AND Broker_ID = ? AND Master_ID = ? AND Manager_ID = ?');  
		$stmt->bind_param('ssss', $Client_Nam,$Broker_ID,$Master_ID,$Manager_ID);  
		$stmt->execute();  
		$result = $stmt->get_result(); 		
		$count =$result->num_rows;		
		$row = $result->fetch_assoc();	
		
		//$query = "SELECT * FROM Client_Profile Where Client_ID ='".$Client_Nam."' AND Broker_ID ='".$Broker_ID."' AND Master_ID ='".$Master_ID."' AND Manager_ID ='".$Manager_ID."'";	
		//$result = $mysqli->query($query);	
		//$row = $result->fetch_assoc();
		$Titel = $row["Titel"];
		$First_Name = $row["First_Name"];
		$Last_Name = $row["Last_Name"];  
		$Email = $row["Email"];  
		$Address = $row["Address"];  
		$Home_Phone = $row["Home_Phone"];  
		$Cell_Phone = $row["Cell_Phone"];  
		
	    }else{
		
		$stmt = $mysqli->prepare('SELECT * FROM Client_Profile WHERE Client_ID = ? AND Broker_ID = ? AND Master_ID = ? AND Manager_ID = ?');  
		$stmt->bind_param('ssss', $decrypted_Cleint_ID,$Broker_ID,$Master_ID,$Manager_ID);  
		$stmt->execute();  
		$result = $stmt->get_result(); 		
		$count =$result->num_rows;		
		$row = $result->fetch_assoc();	
		
		//$query = "SELECT * FROM Client_Profile Where Client_ID ='".$Client_Nam."' AND Broker_ID ='".$Broker_ID."' AND Master_ID ='".$Master_ID."' AND Manager_ID ='".$Manager_ID."'";	
		//$result = $mysqli->query($query);	
		//$row = $result->fetch_assoc();
		$Titel = $row["Titel"];
		$First_Name = $row["First_Name"];
		$Last_Name = $row["Last_Name"];  
		$Email = $row["Email"];  
		$Address = $row["Address"];  
		$Home_Phone = $row["Home_Phone"];  
		$Cell_Phone = $row["Cell_Phone"]; 
		
		
		$query = "SELECT  CF.Client_ID,RF.Reference_ID_Follow_UP,RF.Transaction_Type_ID,RF.Best_time_contact,RF.Reference_ID,RF.Transaction_Type,RF.Transaction_Amount,RF.Reference_Status,RF.Broker_Receiver_ID,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_Sender_ID=BP.Broker_ID JOIN Categories CA ON CA.Category_ID=BP.Category_ID
		where RF.Broker_Sender_ID='".$user_n."' AND CF.Client_ID='".$decrypted_Cleint_ID."' AND RF.Reference_ID='".$decrypted_Reference_ID."'  order by Reg_Date DESC Limit 1";	
		$results = $mysqli->query($query);		
		
		//echo $mysqli->error;
	
		$rows = $results->fetch_assoc();
		$Broker_Receiver_ID = $rows["Broker_Receiver_ID"];
		$Transaction_Amount = $rows["Transaction_Amount"];
		$Transaction_Type_ID = $rows["Transaction_Type_ID"];
		$Transaction_Type = $rows["Transaction_Type"];
		$Best_time_contact = $rows["Best_time_contact"];
	
	
		$Note = $rows["Note"];
		
		
		$queryex = "SELECT * FROM Broker_Profile Where Broker_ID='".$Broker_Receiver_ID."'";	
		$resultex = $mysqli->query($queryex);	
		$rowex = $resultex->fetch_assoc();		
		$Receiver_Code = $rowex['Broker_Refer_ID'];
			$Category_ID = $rowex["Category_ID"];
		}
	    ?>  
		 
		
	 <form class="form-horizontal" method="post" name="registration_form" action="<?php echo esc_url($_SERVER['REQUEST_URI']); ?>">
	
	<?php $csrf->echoInputField(); ?>
<div class="box">
 <div class="box-body">
<div class="row">
<div class="col-xs-10">
                  
					<div class="form-group">
                    <label for="inputName" class="col-sm-2 control-label"><?php echo LANG_VALUE_255; ?></label>
                    <div class="col-sm-10">
                      <input type="text" class="form-control" id="Receiver_Code" name="Receiver_Code" placeholder="<?php echo LANG_VALUE_255; ?>" value="<?php echo  $Receiver_Code;?>" disabled>
                    </div>
                  </div>	  		 
		  
		 <div class="form-group">
		 <input type="hidden" class="form-control" id="Update_ID" name="Update_ID" value="<?php echo $decrypted_Cleint_ID;?>">
		 <input type="hidden" class="form-control" id="Update_No" name="Update_No" value="<?php echo $decrypted_Reference_ID;?>">
                    <label for="inputName" class="col-sm-2 control-label"><?php echo LANG_VALUE_220; ?></label>
                    <div class="col-sm-10">
		    <select class="form-control" id="TITRE" name="TITRE" disabled>
                    <option value="<?php echo  $Titel;?>"><?php echo  $Titel;?></option>
                    <option value="<?php echo LANG_VALUE_221; ?>"><?php echo LANG_VALUE_221; ?></option>
					<option value="<?php echo LANG_VALUE_222; ?>"><?php echo LANG_VALUE_222; ?></option>   
                  </select>                     		
                    </div>
                  </div> 
		  <div class="form-group">
                    <label for="inputName" class="col-sm-2 control-label"><?php echo LANG_VALUE_223; ?></label>
                    <div class="col-sm-10">
                      <input type="text" class="form-control" id="Fullname" name="Fullname" placeholder="<?php echo LANG_VALUE_223; ?>" value="<?php echo  $First_Name;?>" required disabled>
                    </div>
                  </div>	  		 
		  
		   <div class="form-group">
                    <label for="inputName" class="col-sm-2 control-label"><?php echo LANG_VALUE_224; ?></label>
                    <div class="col-sm-10">
                     <input type="text" class="form-control" id="Familyname" name="Familyname" placeholder="<?php echo LANG_VALUE_224; ?>" value="<?php echo  $Last_Name;?>" required disabled>
                    </div>
                  </div>		  		  
		 
		  <div class="form-group">
		  
                    <label for="inputExperience" class="col-sm-2 control-label"><?php echo LANG_VALUE_93; ?></label>
                    <div class="col-sm-10">   
		    <div class="input-group">
		    <span class="input-group-addon"><i class="fa fa-envelope"></i></span>
                     <input type="text" class="form-control" id="Email" name="Email" placeholder="<?php echo LANG_VALUE_93; ?>" value="<?php echo  $Email;?>" required disabled>
                    </div>
                    </div>
                  </div>
		   <div class="form-group">
                    <label for="inputName" class="col-sm-2 control-label"><?php echo LANG_VALUE_104; ?></label>
                    <div class="col-sm-10">
                      <input type="text" class="form-control" id="Personnaladdressd" name="Personnaladdressd" placeholder="<?php echo LANG_VALUE_104; ?>" value="<?php echo  $Address;?>" required disabled>
                    </div>
                  </div>  
		   <div class="form-group">
                    <label for="inputName" class="col-sm-2 control-label"><?php echo LANG_VALUE_225; ?></label>
                    <div class="col-sm-10">
		      <div class="input-group">
                  <div class="input-group-addon">
                    <i class="fa fa-phone"></i>
                  </div>
                  <input type="text" class="form-control" id="homephone" name="homephone" data-inputmask='"mask": "(999) 999-9999"' data-mask value="<?php echo  $Home_Phone;?>" required disabled>
                </div>                     
                    </div>
                  </div> 
		  
		  <div class="form-group">
                    <label for="inputName" class="col-sm-2 control-label"><?php echo LANG_VALUE_226; ?></label>
                    <div class="col-sm-10">
		      <div class="input-group">
                  <div class="input-group-addon">
                    <i class="fa fa-phone"></i>
                  </div>
                  <input type="text" class="form-control" id="cellphone" name="cellphone" data-inputmask='"mask": "(999) 999-9999"' data-mask value="<?php echo  $Cell_Phone;?>" required disabled>
                </div>                     
                    </div>
                  </div>		  
		                      
		
		 <div class="form-group">
                    <label for="inputName" class="col-sm-2 control-label"><?php echo LANG_VALUE_175; ?></label>
                    <div class="col-sm-8">
                       <input type="text" class="form-control" id="Transaction_Amount" name="Transaction_Amount" value="<?php echo  $Transaction_Amount;?>" placeholder="<?php echo LANG_VALUE_175; ?>">
                    </div>                   
                    </div>
					<div class="form-group">
                    <label for="inputName" class="col-sm-2 control-label"><?php echo LANG_VALUE_174; ?></label>
			
						<div class="col-sm-8">  
							<select class="form-control select2" id="Transaction_Type" name="Transaction_Type" style="width: 100%;">      <option value="<?php echo $Transaction_Type_ID;?>"><?php echo $Transaction_Type;?></option> 
<?php
							$query = "SELECT Sub_Category_ID,Sub_Category_Type FROM Sub_Categories WHERE Category_ID='".$Category_ID."'";	
							$result = $mysqli->query($query);									
							while ($row = $result->fetch_assoc()) {
							echo "<option ". (($_POST['Transaction_Type'] == $row["Sub_Category_ID"]) ? 'selected ' : '') ."value=\"".$row["Sub_Category_ID"]."\">".$row["Sub_Category_Type"]."</option>";
							}
							?>								
							</select>
						</div>
										
					</div>
		
		   <div class="form-group">
                    <label for="inputName" class="col-sm-2 control-label"><?php echo LANG_VALUE_256; ?></label>
                    <div class="col-sm-8">
                     <input type="text" class="form-control pull-right" id="datepickerR" name="datepickerR" placeholder="<?php echo LANG_VALUE_256; ?>" value="<?php echo $Best_time_contact;?>" required>        
                    </div>
                  </div>
		   <div class="form-group">
                    <label for="inputName" class="col-sm-2 control-label"><?php echo LANG_VALUE_180; ?></label>
                    <div class="col-sm-8">
                      <textarea class="form-control" id="Note" name="Note" placeholder="<?php echo LANG_VALUE_246; ?>"><?php echo  $Note;?></textarea>
                    </div>
                  </div>
                  <div class="form-group">
                    <div class="col-sm-offset-2 col-sm-8">
		      <input type="submit"  name="submit" value="<?php echo LANG_VALUE_4; ?>" class="btn btn-danger">
                     
                    </div>
                  </div>
                
         
            
         
          
        </div>
      </div>
	      </div>
	      </div>
		  </form>
		  
		  <?php }?>
		 </div>
		
	     </div>

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

</section>
	</div>
    
  </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();
    $('#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
    $('#datepickerR').datepicker({
      autoclose: true
    });
    
     $('#datepickerCM').datepicker({
      autoclose: true
    });
//Date picker
    $('#datepickerIn').datepicker({
      autoclose: true
    });
    //Date picker
    $('#datepickerI').datepicker({
      autoclose: true
    });
    //Date picker
    $('#datepickerIG').datepicker({
      autoclose: true
    });
    //Date picker
    $('#datepickerF').datepicker({
      autoclose: true
    });//Date picker
    $('#datepickerNotary').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>

cmd: