query($query);
$Reference = $result->fetch_assoc();
$Reference_ID = $Reference['Reference_ID'];
$Client_ID = $Reference['Client_ID'];
$Category_ID = $Reference['Category_ID'];
$Admin_ID = $Reference['Admin_ID'];
$Master_ID = $Reference['Master_ID'];
$Manager_Sender_ID = $Reference['Manager_Sender_ID'];
$Broker_Sender_ID = $Reference['Broker_Sender_ID'];
$Broker_Receiver_ID = $Reference['Broker_Receiver_ID'];
$User_Type_ID = $Reference['User_Type_ID'];
$Transaction_Type_ID = $Reference['Transaction_Type_ID'];
$Transaction_Type = $Reference['Transaction_Type'];
$Best_Time_Call = $Reference['Best_Time_Call'];
$query = "SELECT * FROM Client_Profile Where Client_ID ='".$Client_ID."'";
$result = $mysqli->query($query);
$Managers = $result->fetch_assoc();
//$Client_ID = $Managers['Client_ID'];
$First_Name = $Managers['First_Name'];
$Last_Name = $Managers['Last_Name'];
$Client_Name = $First_Name .''. $Last_Name;
$query = "SELECT * FROM Sub_Categories Where Sub_Category_ID ='".$Transaction_Type_ID."'";
$resultw = $mysqli->query($query);
$roww = $resultw->fetch_assoc();
$Sub_Category_Type = $roww['Sub_Category_Type'];
$datetime =date("Y/m/d") . ' ' . date('H:i:s') ;
//$Best_Time_Call = date("Y-m-d", strtotime($Best_Time_Call));
if ($Client_ID > 0) {
if($Id == 1)
{
//echo $Client_ID .','.$Reference_ID_Follow_UP .','.$Id.','.$Type_ID.','.$Broker_ID.','.$Broker_Sender_ID.','.$Manager_Sender_ID.','.$Manager_ID;
if (!$mysqli->query("UPDATE Reference_File_Follow_UP SET Transaction_Amount='".$Type_ID."' WHERE Reference_ID_Follow_UP='".$Reference_ID_Follow_UP."' and Client_ID='".$Client_ID."' and Admin_ID ='".$Admin_ID."' and Master_ID ='".$Master_ID."' and Manager_Sender_ID='".$Manager_Sender_ID."' and Manager_Receiver_ID='".$Manager_ID."' and Broker_Sender_ID='".$Broker_Sender_ID."' and Broker_Receiver_ID='".$Broker_ID."' and User_Type_ID='".$User_Type_ID."'")) {
//echo $mysqli->error;
//header('Location: reference.php?error='.$mysqli->error);
//exit;
}else{
echo "The follow up is update!";
}
}else if($Id == 2){
if (!$mysqli->query("UPDATE Reference_File_Follow_UP SET Reference_Status='".$Type_ID."' WHERE Reference_ID_Follow_UP='".$Reference_ID_Follow_UP."' and Client_ID='".$Client_ID."' and Admin_ID ='".$Admin_ID."' and Master_ID ='".$Master_ID."' and Manager_Sender_ID='".$Manager_Sender_ID."' and Manager_Receiver_ID='".$Manager_ID."' and Broker_Sender_ID='".$Broker_Sender_ID."' and Broker_Receiver_ID='".$Broker_ID."' and User_Type_ID='".$User_Type_ID."'")) {
//header('Location: reference.php?error='.$mysqli->error);
//exit;
}else{
echo "The follow up is update!";
}
}else if($Id == 3){
if (!$mysqli->query("UPDATE Reference_File_Follow_UP SET Note='".$Type_ID."' WHERE Reference_ID_Follow_UP='".$Reference_ID_Follow_UP."' and Client_ID='".$Client_ID."' and Admin_ID ='".$Admin_ID."' and Master_ID ='".$Master_ID."' and Manager_Sender_ID='".$Manager_Sender_ID."' and Manager_Receiver_ID='".$Manager_ID."' and Broker_Sender_ID='".$Broker_Sender_ID."' and Broker_Receiver_ID='".$Broker_ID."' and User_Type_ID='".$User_Type_ID."'")) {
}else{
echo "The follow up is update!";
}
}
}else{
echo "Client Name is not exist";
}
}else{
echo "Registration failure please insert all informaion!";
}
}