query($sql_select_complaint); if ($result_select_complaint->num_rows == 1) { $row_select_complaint = $result_select_complaint->fetch_assoc(); $row_id = $row_select_complaint['id']; } } else { header ('location: ./complaint-track-form.php'); } ?> Track Complaint
Complaint Timeline
num_rows == 1) { if ($row_select_complaint['status'] == '') { $sql_select_timeline = "SELECT * FROM complaint_timeline WHERE meta_id = '".$complaint_id."' ORDER BY id ASC"; $result_select_timeline = $conn->query($sql_select_timeline); $timeline = '
'; if ($result_select_timeline->num_rows > 0) { while($row_select_timeline = $result_select_timeline->fetch_assoc()) { $timeline .= '
'; $timeline .= ''; $timeline .= ''.$row_select_timeline['form_created_on'].' - '.$row_select_timeline['form_created_time'].''; $timeline .= ''; $timeline .= '
'; if ($row_select_timeline['meta_name'] == 'complaint form') { $timeline .= '
'; if ($row_select_timeline['meta_type'] == 'out') { $timeline .= ''; } else { $timeline .= ''; } $timeline .= '
'; $timeline .= ' '.$row_select_timeline['form_created_time'].''; $timeline .= '
'; $timeline .= ''.$row_select_timeline['meta_user'].': '.urldecode($row_select_timeline['meta_description']).''; $timeline .= '
'; $timeline .= '
'; $timeline .= '
'; } } $message_box = '
'; } else { $timeline .= '
No Timeline Found.
'; }; $timeline .= '
'; print $timeline; print $message_box; } else { echo '
Your Complaint Id Is Closed.
'; } } else { echo '
We are currently experiencing some technical issues with old complaint id. Please file a new grievance here.
File Your Grievance
'; } ?>