prepare($sql_select_complaint); $result_select_complaint -> execute([':complaintId' => $complaint_id]); if ($result_select_complaint->rowCount() == 1) { $row_select_complaint = $result_select_complaint->fetch(PDO::FETCH_ASSOC); $row_id = $row_select_complaint['id']; } } else { header ('location: ./complaint-track-form.php'); } ?> Track Complaint
Complaint Timeline
rowCount() == 1) { if ($row_select_complaint['status'] == '') { $sql_select_timeline = "SELECT * FROM complaint_timeline WHERE meta_id = :metaId ORDER BY id ASC"; $result_select_timeline = $conn->prepare($sql_select_timeline); $result_select_timeline -> execute([':metaId' => $complaint_id]); $timeline = '
'; if ($result_select_timeline->rowCount() > 0) { while($row_select_timeline = $result_select_timeline->fetch(PDO::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
'; } ?>