";
// }
//////}
}
if (!empty($error_msg)) {
echo $error_msg;
}
if (isset($_GET['error'])) {
$mesg= $_GET['error'];
echo "
Notification! ".$mesg."
";
}
include'main-header-inc.php';
?>
prepare('SELECT * FROM Broker_Profile WHERE Broker_ID = ?');
$stmt->bind_param('s', $user_n);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();
$count =$result->num_rows;
if($count > 0)
{
$querys = "SELECT CF.Client_ID,RF.Reference_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_Sender_ID=BP.Broker_ID JOIN Categories CA ON CA.Category_ID=BP.Category_ID
where RF.Broker_Receiver_ID='".$user_n."' AND CF.Client_ID='".$Client_Name."' 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,CF.Cell_Phone,RF.Reference_ID_Follow_UP,RF.Reference_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_Sender_ID=BP.Broker_ID JOIN Categories CA ON CA.Category_ID=BP.Category_ID
where RF.Broker_Receiver_ID='".$user_n."' AND CF.Client_ID='".$Client_Name."' AND RF.Reference_ID='".$Reference_ID."' order by Reg_Date DESC Limit 1";
$results = $mysqli->query($query);
//echo $mysqli->error;
while ($rows = $results->fetch_assoc()) {
?>
prepare('SELECT * FROM Broker_Profile WHERE Broker_ID = ?');
$stmt->bind_param('s', $user_n);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();
$count =$result->num_rows;
if($count > 0)
{
$querys = "SELECT CF.Client_ID,RF.Reference_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_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='".$Client_Name."' 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.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_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='".$Client_Name."' AND RF.Reference_ID='".$Reference_ID."' order by Reg_Date DESC Limit 1";
$results = $mysqli->query($query);
//echo $mysqli->error;
while ($rows = $results->fetch_assoc()) {
?>