/home/techb158/workloadmatch.com/workloadmatch.com/Manager/Inc
Edit: /home/techb158/workloadmatch.com/workloadmatch.com/Manager/Inc/AddReference.php (8258B)
query($query);
$row = $result->fetch_assoc();
$Category_ID = $row['Category_ID'];
$Admin_ID = $row['Admin_ID'];
$Manager_ID = $row['Manager_ID'];
$Broker_ID = $row['Broker_ID'];
$User_Type_ID = $row['User_Type_ID'];
$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));
$query = "SELECT * FROM Client_Profile Where Client_ID ='".$Client_ID."' AND Email ='".$Email."' AND Deleted_Status ='0'";
$result = $mysqli->query($query);
$Managers = $result->fetch_assoc();
$Client_ID = $Managers['Client_ID'];
if ($Client_ID > 0) {
do {
$number_id = mt_rand(10000,999999);
$prep_stmt = "SELECT Reference_ID FROM Reference_File WHERE Reference_ID=? LIMIT 1";
$stmt = $mysqli->prepare($prep_stmt);
if ($stmt){
$stmt->bind_param('s', $number_id);
$stmt->execute();
$stmt->store_result();
if ($stmt->num_rows == 1) {
$count =$stmt->num_rows;
}else{
$count =0;
}
}
} while ($count > 0);
if ($insert_stmt = $mysqli->prepare("INSERT INTO Reference_File (Reference_ID, Client_ID, Category_ID, Admin_ID, Manager_ID, Broker_Sender_ID, Broker_Receiver_ID, User_Type_ID, Transaction_Type_ID, Transaction_Type, Transaction_Amount, Note, Reg_Date, Best_time_contact) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")) {
$insert_stmt->bind_param('ssssssssssssss',$number_id,$Client_ID, $Category_ID, $Admin_ID, $Manager_ID, $Broker_ID, $Broker_Receiver_ID, $User_Type_ID, $Transaction_Type_ID, $Sub_Category_Type, $Transaction_Amount, $Note, $datetime, $Best_Time_Call);
// Execute the prepared query.
if (! $insert_stmt->execute()) {
//header('Location: reference.php?error='.$mysqli->error);
header('Location: reference.php?error=Registration failure to send Reference!');
exit();
}else
{
//header('Location: reference.php?error=The Reference has been sent!');
//exit();
$Re_ID= mysqli_insert_id($mysqli);
if ($insert_stmt = $mysqli->prepare("INSERT INTO Reference_File_Follow_UP (Re_ID, Reference_ID, Client_ID, Category_ID, Admin_ID, Manager_ID, Broker_Sender_ID, Broker_Receiver_ID, User_Type_ID, Transaction_Type_ID, Transaction_Type, Transaction_Amount, Note, Reg_Date, Best_time_contact) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")) {
$insert_stmt->bind_param('sssssssssssssss',$Re_ID, $number_id, $Client_ID, $Category_ID, $Admin_ID, $Manager_ID, $Broker_ID, $Broker_Receiver_ID, $User_Type_ID, $Transaction_Type_ID, $Sub_Category_Type, $Transaction_Amount, $Note, $datetime, $Best_Time_Call);
// Execute the prepared query.
if (! $insert_stmt->execute()) {
//header('Location: reference.php?error='.$mysqli->error);
header('Location: reference.php?error=Registration failure to send Reference!');
exit();
}else
{
header('Location: reference.php?error=The Reference has been sent!');
exit();
}
}
}
}
//header('Location: reference.php?error=Client Name is already exist.');
//exit();
//foreach ($_POST['Transaction_Type'] as $Transaction_Type)
//{
// $Transaction_Type= $Transaction_Type;
//}
}else
{
if ($insert_stmt = $mysqli->prepare("INSERT INTO Client_Profile (Category_ID, Admin_ID, Manager_ID, Broker_ID, User_Type_ID, Titel, First_Name, Last_Name, User_Name, Email, Home_Phone, Cell_Phone, Address, Reg_Date, Login_Date, Logout_Date) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")) {
//header('Location: addclient.php?error=file name already exists'.$user_n.'');
$insert_stmt->bind_param('ssssssssssssssss',$Category_ID, $Admin_ID, $Manager_ID, $Broker_ID, $User_Type_ID, $Titel, $First_Name, $Last_Name, $Client_Name, $Email, $Home_Phone, $Cell_Phone, $Address, $datetime, $datetime, $datetime);
// Execute the prepared query.
if (! $insert_stmt->execute()) {
header('Location: addclient.php?error='.$mysqli->error);
//header('Location: reference.php?error=Client name already exists!');
//header('Location: reference.php?error=Registration failure to add new cleint!');
//header('Location: addassist.php?error='.$Managers_ID.'');
exit();
}else
{
$Cli_ID = mysqli_insert_id($mysqli);
if ($insert_stmt = $mysqli->prepare("INSERT INTO Reference_File (Client_ID, Category_ID, Admin_ID, Manager_ID, Broker_Sender_ID, Broker_Receiver_ID, User_Type_ID, Transaction_Type_ID, Transaction_Type, Transaction_Amount, Note, Reg_Date, Best_time_contact) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")) {
$insert_stmt->bind_param('sssssssssssss',$Cli_ID, $Category_ID, $Admin_ID, $Manager_ID, $Broker_ID, $Broker_Receiver_ID, $User_Type_ID, $Transaction_Type_ID, $Sub_Category_Type, $Transaction_Amount, $Note, $datetime, $Best_Time_Call);
// Execute the prepared query.
if (! $insert_stmt->execute()) {
//header('Location: addclient.php?error='.$mysqli->error);
header('Location: addclient.php?error=Registration failure to send Reference!');
exit();
}else
{
$Reference_ID= mysqli_insert_id($mysqli);
if ($insert_stmt = $mysqli->prepare("INSERT INTO Reference_File_Follow_UP (Reference_ID, Client_ID, Category_ID, Admin_ID, Manager_ID, Broker_Sender_ID, Broker_Receiver_ID, User_Type_ID, Transaction_Type_ID, Transaction_Type, Transaction_Amount, Note, Reg_Date, Best_time_contact) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")) {
$insert_stmt->bind_param('ssssssssssssss',$Reference_ID, $Cli_ID, $Category_ID, $Admin_ID, $Manager_ID, $Broker_ID, $Broker_Receiver_ID, $User_Type_ID, $Transaction_Type_ID, $Sub_Category_Type, $Transaction_Amount, $Note, $datetime, $Best_Time_Call);
// Execute the prepared query.
if (! $insert_stmt->execute()) {
//header('Location: reference.php?error='.$mysqli->error);
header('Location: reference.php?error=Registration failure to send Reference!');
exit();
}else
{
header('Location: reference.php?error=New cleint successfully registered and the Reference has been sent!');
exit();
}
}
//header('Location: reference.php?error=New cleint successfully registered and the Reference has been sent!');
//exit();
}
}else{
//header('Location: addclient.php?error='.$mysqli->error);
}
}
}else{
//header('Location: addclient.php?error='.$mysqli->error);
}
}
}else{
header('Location: reference.php?error=Registration failure please insert all informaion!');
exit();
}
}